eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_FI_BILL_EXTRACT dependencies on IGS_GE_MSG_STACK

Line 58: -- the report, instead added to the igs_ge_msg.stack to add into the stack and in the report

54: -- removed clause 'person_id = p_n_person_id'
55: -- Bug# 2337820, removed the correspondance flag reference in the cursors 'cur_bill_to_addr',
56: -- 'cur_remit_addr'
57: -- Bug 2345299, removed the fnd_file.put_line call since it was not writing into the log file of
58: -- the report, instead added to the igs_ge_msg.stack to add into the stack and in the report
59: -- fnd_message.get is used to unwound the stack
60: --sarakshi 3-Apr-2002 added code according to sfcr018,bug:2293676, 'vchappid' incorporated review comments
61: --sarakshi 27-Feb-2002 bug:2238362, changed the view igs_pe_person_v to igs_fi_parties_v and used the
62: -- function igs_fi_gen_007.validate_person to validate person

Line 303: -- the report, instead added to the igs_ge_msg.stack to add into the stack and in the report

299: -- removed clause 'person_id = p_n_person_id'
300: -- Bug# 2337820, removed the correspondance flag reference in the cursors 'cur_bill_to_addr',
301: -- 'cur_remit_addr'
302: -- Bug 2345299, removed the fnd_file.put_line call since it was not writing into the log file of
303: -- the report, instead added to the igs_ge_msg.stack to add into the stack and in the report
304: -- fnd_message.get is used to unwound the stack
305: --sarakshi 3-Apr-2002 added code according to sfcr018,bug:2293676
306: --jbegum 9-Feb-02 In the following cursors the join with the IGS_FI_PARTY_SUBACTS table
307: -- was removed as part of Enh bug # 2201081

Line 775: igs_ge_msg_stack.add;

771: -- Bug#2564643 Removed code assigning value to token SUB_ACCOUNT_NAME .
772: -- Bug#5018036 cur_person_number replaced by call to igs_fi_gen_008.get_party_number
773: l_person_number := igs_fi_gen_008.get_party_number(p_n_person_id);
774: fnd_message.set_token ('PERSON_NUMBER', l_person_number);
775: igs_ge_msg_stack.add;
776: END IF;
777: END IF;
778: --
779: -- Compute the following steps only if the Start Date is less than or equal to Cut Off Date

Line 852: igs_ge_msg_stack.add;

848: p_end_date => p_d_cutoff_dt,
849: p_message_name => l_message_name);
850: IF l_message_name IS NOT NULL THEN
851: FND_MESSAGE.SET_NAME('IGS',l_message_name);
852: igs_ge_msg_stack.add;
853: l_flag :=FALSE;
854: END IF;
855: END IF;
856:

Line 1278: igs_ge_msg_stack.add;

1274: p_v_message_name => l_v_message_name
1275: );
1276: IF (l_v_manage_acc = 'OTHER') OR (l_v_manage_acc IS NULL) THEN
1277: fnd_message.set_name('IGS',l_v_message_name);
1278: igs_ge_msg_stack.add;
1279: p_c_status := 'FALSE';
1280: RETURN;
1281: END IF;
1282:

Line 1294: igs_ge_msg_stack.add;

1290: --
1291: -- Return FALSE if both the parameters are NULL.
1292: --
1293: fnd_message.set_name ('IGS', 'IGS_FI_PRS_PRSIDGRP_NULL');
1294: igs_ge_msg_stack.add;
1295: p_c_status := 'FALSE';
1296: RETURN;
1297: END IF;
1298: --

Line 1304: igs_ge_msg_stack.add;

1300: --
1301: -- Return FALSE if both the parameters are NOT NULL.
1302: --
1303: fnd_message.set_name ('IGS', 'IGS_FI_PRS_OR_PRSIDGRP');
1304: igs_ge_msg_stack.add;
1305: p_c_status := 'FALSE';
1306: RETURN;
1307: END IF;
1308: IF (p_n_prsid_grp_id IS NOT NULL) THEN

Line 1318: igs_ge_msg_stack.add;

1314: IF (cur_person_id_group%NOTFOUND) THEN
1315: CLOSE cur_person_id_group;
1316: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
1317: fnd_message.set_token('PARAMETER',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON_GROUP'));
1318: igs_ge_msg_stack.add;
1319: p_c_status := 'FALSE';
1320: RETURN;
1321: ELSE
1322: CLOSE cur_person_id_group;

Line 1332: igs_ge_msg_stack.add;

1328: -- Bug 5178298 - changed the message to IGS_FI_INVALID_PARAMETER
1329: IF igs_fi_gen_007.validate_person(p_n_person_id) = 'N' THEN
1330: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
1331: fnd_message.set_token('PARAMETER',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PARTY'));
1332: igs_ge_msg_stack.add;
1333: p_c_status := 'FALSE';
1334: RETURN;
1335: END IF;
1336: END IF;

Line 1347: igs_ge_msg_stack.add;

1343: -- Bug 5178298 - changed the message to IGS_FI_INVALID_PARAMETER
1344: IF ((p_c_test_mode NOT IN ('Y', 'N')) OR (p_c_test_mode IS NULL)) THEN
1345: fnd_message.set_name('IGS', 'IGS_FI_INVALID_PARAMETER');
1346: fnd_message.set_token('PARAMETER',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'TEST_MODE'));
1347: igs_ge_msg_stack.add;
1348: p_c_status := 'FALSE';
1349: RETURN;
1350: END IF;
1351: --

Line 1356: igs_ge_msg_stack.add;

1352: -- Check if the Cut Off Date is valid.
1353: --
1354: IF ((p_d_cutoff_dt >= TRUNC(SYSDATE)) OR (p_d_cutoff_dt IS NULL)) THEN
1355: fnd_message.set_name ('IGS', 'IGS_FI_CUTOFF_DT');
1356: igs_ge_msg_stack.add;
1357: p_c_status := 'FALSE';
1358: RETURN;
1359: END IF;
1360: --

Line 1365: igs_ge_msg_stack.add;

1361: -- Check if the Due Date is valid.
1362: --
1363: IF ((p_d_due_dt < TRUNC(SYSDATE)) OR (p_d_due_dt IS NULL)) THEN
1364: fnd_message.set_name ('IGS', 'IGS_RE_DUE_DT_CANT_BE_PAST_DT');
1365: igs_ge_msg_stack.add;
1366: p_c_status := 'FALSE';
1367: RETURN;
1368: END IF;
1369: --

Line 1375: igs_ge_msg_stack.add;

1371: -- Bug 5178298 - Modified the cursor and the messages
1372: --
1373: IF (p_n_remit_prty_site_id IS NULL) THEN
1374: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
1375: igs_ge_msg_stack.add;
1376: p_c_status := 'FALSE';
1377: RETURN;
1378: ELSE
1379: OPEN cur_usr_profl_name;

Line 1384: igs_ge_msg_stack.add;

1380: FETCH cur_usr_profl_name INTO l_v_usr_profl_name;
1381: IF (cur_usr_profl_name%NOTFOUND) THEN
1382: CLOSE cur_usr_profl_name;
1383: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
1384: igs_ge_msg_stack.add;
1385: p_c_status := 'FALSE';
1386: RETURN;
1387: ELSE
1388: CLOSE cur_usr_profl_name;

Line 1399: igs_ge_msg_stack.add;

1395: IF (cur_remit_addr%NOTFOUND) THEN
1396: CLOSE cur_remit_addr;
1397: fnd_message.set_name ('IGS', 'IGS_FI_BILL_REMIT_ADDR_INVALID');
1398: fnd_message.set_token('REMIT_ADD_USG',l_v_usr_profl_name);
1399: igs_ge_msg_stack.add;
1400: p_c_status := 'FALSE';
1401: RETURN;
1402: ELSE
1403: CLOSE cur_remit_addr;

Line 1414: igs_ge_msg_stack.add;

1410:
1411: IF (p_c_site_usg_type_cd_1 IS NULL) THEN
1412: fnd_message.set_name('IGS', 'IGS_FI_INVALID_PARAMETER');
1413: fnd_message.set_token('PARAMETER',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'BILL_ADDR_USG_1'));
1414: igs_ge_msg_stack.add;
1415: p_c_status := 'FALSE';
1416: RETURN;
1417: END IF;
1418: -- Bill To Address Usage 2 is not equal to Bill To Address Usage 1,

Line 1426: igs_ge_msg_stack.add;

1422: IF ((p_c_site_usg_type_cd_1 = p_c_site_usg_type_cd_2) OR
1423: (p_c_site_usg_type_cd_1 = p_c_site_usg_type_cd_3) OR
1424: (p_c_site_usg_type_cd_2 = p_c_site_usg_type_cd_3)) THEN
1425: fnd_message.set_name ('IGS', 'IGS_FI_BILL_TO_ADDR_USGS');
1426: igs_ge_msg_stack.add;
1427: p_c_status := 'FALSE';
1428: RETURN;
1429: END IF;
1430: --

Line 1442: igs_ge_msg_stack.add;

1438: fnd_message.set_name ('IGS', 'IGS_FI_BILL_TO_ADDUSG');
1439: fnd_message.set_token ('USG_NUM', l_n_use_num);
1440: fnd_message.set_token ('ADDR_UGS_VAL', p_c_site_usg_type_cd_1);
1441: fnd_message.set_token ('BILL_USG_LKP_TYPE', l_v_bill_usg_lkp_type);
1442: igs_ge_msg_stack.add;
1443: p_c_status := 'FALSE';
1444: RETURN;
1445: ELSE
1446: CLOSE cur_bill_to_addr_usage;

Line 1461: igs_ge_msg_stack.add;

1457: fnd_message.set_name ('IGS', 'IGS_FI_BILL_TO_ADDUSG');
1458: fnd_message.set_token ('USG_NUM', l_n_use_num);
1459: fnd_message.set_token ('ADDR_UGS_VAL', p_c_site_usg_type_cd_2);
1460: fnd_message.set_token ('BILL_USG_LKP_TYPE', l_v_bill_usg_lkp_type);
1461: igs_ge_msg_stack.add;
1462: p_c_status := 'FALSE';
1463: RETURN;
1464: ELSE
1465: CLOSE cur_bill_to_addr_usage;

Line 1481: igs_ge_msg_stack.add;

1477: fnd_message.set_name ('IGS', 'IGS_FI_BILL_TO_ADDUSG');
1478: fnd_message.set_token ('USG_NUM', l_n_use_num);
1479: fnd_message.set_token ('ADDR_UGS_VAL', p_c_site_usg_type_cd_3);
1480: fnd_message.set_token ('BILL_USG_LKP_TYPE', l_v_bill_usg_lkp_type);
1481: igs_ge_msg_stack.add;
1482: p_c_status := 'FALSE';
1483: RETURN;
1484: ELSE
1485: CLOSE cur_bill_to_addr_usage;

Line 1506: igs_ge_msg_stack.add;

1502:
1503: -- Log SQLERRM in case of any exception
1504: fnd_message.set_name('IGS','IGS_FI_ERR_TXT');
1505: fnd_message.set_token('TEXT',SQLERRM);
1506: igs_ge_msg_stack.add;
1507:
1508: -- Log Person Number in the log file.
1509: fnd_message.set_name('IGS','IGS_FI_PERSON_NUM');
1510: fnd_message.set_token('PERSON_NUM',igs_fi_gen_008.get_party_number(p_n_person_id));

Line 1511: igs_ge_msg_stack.add;

1507:
1508: -- Log Person Number in the log file.
1509: fnd_message.set_name('IGS','IGS_FI_PERSON_NUM');
1510: fnd_message.set_token('PERSON_NUM',igs_fi_gen_008.get_party_number(p_n_person_id));
1511: igs_ge_msg_stack.add;
1512: END;
1513: ELSE
1514: FOR rec_cur_person_ids IN cur_person_ids (p_n_prsid_grp_id) LOOP
1515: -- Following procedure bill_the_person invoked in a begin-end block so that

Line 1532: igs_ge_msg_stack.add;

1528:
1529: -- Log SQLERRM in case of any unhandled exception
1530: fnd_message.set_name('IGS','IGS_FI_ERR_TXT');
1531: fnd_message.set_token('TEXT',SQLERRM);
1532: igs_ge_msg_stack.add;
1533:
1534: -- Log Person Number in the log file.
1535: fnd_message.set_name('IGS','IGS_FI_PERSON_NUM');
1536: fnd_message.set_token('PERSON_NUM',igs_fi_gen_008.get_party_number(rec_cur_person_ids.person_id));

Line 1537: igs_ge_msg_stack.add;

1533:
1534: -- Log Person Number in the log file.
1535: fnd_message.set_name('IGS','IGS_FI_PERSON_NUM');
1536: fnd_message.set_token('PERSON_NUM',igs_fi_gen_008.get_party_number(rec_cur_person_ids.person_id));
1537: igs_ge_msg_stack.add;
1538: END;
1539: END LOOP;
1540: END IF;
1541: --

Line 1557: igs_ge_msg_stack.add;

1553: EXCEPTION
1554: WHEN e_resource_busy THEN
1555: p_c_status:='FALSE';
1556: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_LOCKED');
1557: igs_ge_msg_stack.add;
1558: RAISE;
1559: WHEN OTHERS THEN
1560: ROLLBACK;
1561: p_c_status := 'FALSE';