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 FND_MESSAGE

Line 59: -- fnd_message.get is used to unwound the stack

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
63: --jbegum 20-Feb-02 As part Enh bug#2228910

Line 304: -- fnd_message.get is used to unwound the stack

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
308: -- CUR_CHARGE_TRANS , CUR_CHARGE_TRANS_UPD ,CUR_CHARGES_TOTAL,CUR_TRANSACTIONS_FOUND

Line 730: fnd_message.set_name ('IGS', 'IGS_FI_NO_BILL_TO_ADDR');

726: );
727: FETCH cur_bill_to_addr INTO rec_cur_bill_to_addr;
728: IF (cur_bill_to_addr%NOTFOUND) THEN
729: CLOSE cur_bill_to_addr;
730: fnd_message.set_name ('IGS', 'IGS_FI_NO_BILL_TO_ADDR');
731: app_exception.raise_exception; -- Raise exception. (pathipat)
732: END IF;
733: CLOSE cur_bill_to_addr;
734:

Line 740: fnd_message.set_name('IGS',l_message_name);

736: --Fetching the value of planned credits ind from igs_fi_control,
737: --if the out parameter returns any value then return
738: l_pln_crd_setup:=igs_fi_gen_001.finp_get_planned_credits_ind(l_message_name);
739: IF l_message_name IS NOT NULL THEN
740: fnd_message.set_name('IGS',l_message_name);
741: -- Raise the exception, message is added to stack in the invoking place in billing_extract()
742: app_exception.raise_exception;
743: END IF;
744:

Line 770: fnd_message.set_name ('IGS', 'IGS_FI_CUTOFF_LSTDT');

766: l_d_start_date := NULL;
767: ELSE
768: CLOSE cur_start_date;
769: IF (l_d_start_date > p_d_cutoff_dt) THEN
770: fnd_message.set_name ('IGS', 'IGS_FI_CUTOFF_LSTDT');
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);

Line 774: fnd_message.set_token ('PERSON_NUMBER', l_person_number);

770: fnd_message.set_name ('IGS', 'IGS_FI_CUTOFF_LSTDT');
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: --

Line 851: FND_MESSAGE.SET_NAME('IGS',l_message_name);

847: p_start_date => NULL,
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;

Line 1277: fnd_message.set_name('IGS',l_v_message_name);

1273: igs_fi_com_rec_interface.chk_manage_account( p_v_manage_acc => l_v_manage_acc,
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;

Line 1293: fnd_message.set_name ('IGS', 'IGS_FI_PRS_PRSIDGRP_NULL');

1289: IF ((p_n_prsid_grp_id IS NULL) AND (p_n_person_id IS NULL)) THEN
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;

Line 1303: fnd_message.set_name ('IGS', 'IGS_FI_PRS_OR_PRSIDGRP');

1299: IF ((p_n_prsid_grp_id IS NOT NULL) AND (p_n_person_id IS NOT NULL)) THEN
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;

Line 1316: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');

1312: OPEN cur_person_id_group (p_n_prsid_grp_id);
1313: FETCH cur_person_id_group INTO rec_cur_person_id_group;
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;

Line 1317: fnd_message.set_token('PARAMETER',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON_GROUP'));

1313: FETCH cur_person_id_group INTO rec_cur_person_id_group;
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

Line 1330: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');

1326: --
1327: -- Check if the Person ID is valid.
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;

Line 1331: fnd_message.set_token('PARAMETER',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PARTY'));

1327: -- Check if the Person ID is valid.
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;

Line 1345: fnd_message.set_name('IGS', 'IGS_FI_INVALID_PARAMETER');

1341: --
1342: -- Check if the value of the parameter Test Mode is valid.
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;

Line 1346: fnd_message.set_token('PARAMETER',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'TEST_MODE'));

1342: -- Check if the value of the parameter Test Mode is valid.
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;

Line 1355: fnd_message.set_name ('IGS', 'IGS_FI_CUTOFF_DT');

1351: --
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;

Line 1364: fnd_message.set_name ('IGS', 'IGS_RE_DUE_DT_CANT_BE_PAST_DT');

1360: --
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;

Line 1374: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');

1370: -- Check if the Remittance Address for the bill is valid and the Remittance Address Usage for the bill is valid.
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

Line 1383: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');

1379: OPEN cur_usr_profl_name;
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

Line 1397: fnd_message.set_name ('IGS', 'IGS_FI_BILL_REMIT_ADDR_INVALID');

1393: );
1394: FETCH cur_remit_addr INTO rec_cur_remit_addr;
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;

Line 1398: fnd_message.set_token('REMIT_ADD_USG',l_v_usr_profl_name);

1394: FETCH cur_remit_addr INTO rec_cur_remit_addr;
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

Line 1412: fnd_message.set_name('IGS', 'IGS_FI_INVALID_PARAMETER');

1408: -- Check if the Bill to Address 1 is NOT NULL, and
1409: -- Bug 5178298 - Modified the message
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;

Line 1413: fnd_message.set_token('PARAMETER',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'BILL_ADDR_USG_1'));

1409: -- Bug 5178298 - Modified the message
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;

Line 1425: fnd_message.set_name ('IGS', 'IGS_FI_BILL_TO_ADDR_USGS');

1421: --
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;

Line 1438: fnd_message.set_name ('IGS', 'IGS_FI_BILL_TO_ADDUSG');

1434: FETCH cur_bill_to_addr_usage INTO rec_cur_bill_to_addr_usage;
1435: IF (cur_bill_to_addr_usage%NOTFOUND) THEN
1436: CLOSE cur_bill_to_addr_usage;
1437: l_n_use_num := 1;
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;

Line 1439: fnd_message.set_token ('USG_NUM', l_n_use_num);

1435: IF (cur_bill_to_addr_usage%NOTFOUND) THEN
1436: CLOSE cur_bill_to_addr_usage;
1437: l_n_use_num := 1;
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';

Line 1440: fnd_message.set_token ('ADDR_UGS_VAL', p_c_site_usg_type_cd_1);

1436: CLOSE cur_bill_to_addr_usage;
1437: l_n_use_num := 1;
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;

Line 1441: fnd_message.set_token ('BILL_USG_LKP_TYPE', l_v_bill_usg_lkp_type);

1437: l_n_use_num := 1;
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

Line 1457: fnd_message.set_name ('IGS', 'IGS_FI_BILL_TO_ADDUSG');

1453: FETCH cur_bill_to_addr_usage INTO rec_cur_bill_to_addr_usage;
1454: IF (cur_bill_to_addr_usage%NOTFOUND) THEN
1455: CLOSE cur_bill_to_addr_usage;
1456: l_n_use_num := 2;
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;

Line 1458: fnd_message.set_token ('USG_NUM', l_n_use_num);

1454: IF (cur_bill_to_addr_usage%NOTFOUND) THEN
1455: CLOSE cur_bill_to_addr_usage;
1456: l_n_use_num := 2;
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';

Line 1459: fnd_message.set_token ('ADDR_UGS_VAL', p_c_site_usg_type_cd_2);

1455: CLOSE cur_bill_to_addr_usage;
1456: l_n_use_num := 2;
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;

Line 1460: fnd_message.set_token ('BILL_USG_LKP_TYPE', l_v_bill_usg_lkp_type);

1456: l_n_use_num := 2;
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

Line 1477: fnd_message.set_name ('IGS', 'IGS_FI_BILL_TO_ADDUSG');

1473: FETCH cur_bill_to_addr_usage INTO rec_cur_bill_to_addr_usage;
1474: IF (cur_bill_to_addr_usage%NOTFOUND) THEN
1475: CLOSE cur_bill_to_addr_usage;
1476: l_n_use_num := 3;
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;

Line 1478: fnd_message.set_token ('USG_NUM', l_n_use_num);

1474: IF (cur_bill_to_addr_usage%NOTFOUND) THEN
1475: CLOSE cur_bill_to_addr_usage;
1476: l_n_use_num := 3;
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';

Line 1479: fnd_message.set_token ('ADDR_UGS_VAL', p_c_site_usg_type_cd_3);

1475: CLOSE cur_bill_to_addr_usage;
1476: l_n_use_num := 3;
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;

Line 1480: fnd_message.set_token ('BILL_USG_LKP_TYPE', l_v_bill_usg_lkp_type);

1476: l_n_use_num := 3;
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

Line 1504: fnd_message.set_name('IGS','IGS_FI_ERR_TXT');

1500: -- In case of unhandled exception, SQLERRM would hold the ORA error that occured. The same
1501: -- would be raised here.
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.

Line 1505: fnd_message.set_token('TEXT',SQLERRM);

1501: -- would be raised here.
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');

Line 1509: fnd_message.set_name('IGS','IGS_FI_PERSON_NUM');

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));
1511: igs_ge_msg_stack.add;
1512: END;
1513: ELSE

Line 1510: fnd_message.set_token('PERSON_NUM',igs_fi_gen_008.get_party_number(p_n_person_id));

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));
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

Line 1530: fnd_message.set_name('IGS','IGS_FI_ERR_TXT');

1526: -- In case of unhandled exception, SQLERRM would hold the ORA error that occured. The same
1527: -- would be raised here.
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.

Line 1531: fnd_message.set_token('TEXT',SQLERRM);

1527: -- would be raised here.
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');

Line 1535: fnd_message.set_name('IGS','IGS_FI_PERSON_NUM');

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));
1537: igs_ge_msg_stack.add;
1538: END;
1539: END LOOP;

Line 1536: fnd_message.set_token('PERSON_NUM',igs_fi_gen_008.get_party_number(rec_cur_person_ids.person_id));

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));
1537: igs_ge_msg_stack.add;
1538: END;
1539: END LOOP;
1540: END IF;

Line 1556: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_LOCKED');

1552: --
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;