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_AZ_GEN_001 dependencies on FND_MSG_PUB

Line 351: fnd_msg_pub.ADD;

347: || l_dyn_std_to_add;
348: --
349: IF l_status <> fnd_api.g_ret_sts_success THEN
350: fnd_message.set_name ('IGS', 'IGS_AZ_DYN_PERS_ID_GRP_ERR');
351: fnd_msg_pub.ADD;
352: fnd_file.put_line (fnd_file.LOG, fnd_message.get);
353: RAISE fnd_api.g_exc_error;
354: END IF;
355: --

Line 399: errbuf := fnd_msg_pub.get (fnd_msg_pub.g_last, fnd_api.g_false);

395: retcode := 2;
396: IF (lnMsgCount = 1) THEN
397: errbuf := lvMsgData;
398: ELSE
399: errbuf := fnd_msg_pub.get (fnd_msg_pub.g_last, fnd_api.g_false);
400: END IF;
401: RAISE fnd_api.g_exc_error;
402: END IF;
403: END LOOP; -- for cur_std_to_add

Line 422: fnd_msg_pub.ADD;

418: || l_dyn_std_to_upd;
419: --
420: IF l_status <> fnd_api.g_ret_sts_success THEN
421: fnd_message.set_name ('IGS', 'IGS_AZ_DYN_PERS_ID_GRP_ERR');
422: fnd_msg_pub.ADD;
423: fnd_file.put_line (fnd_file.LOG, fnd_message.get);
424: RAISE fnd_api.g_exc_error;
425: END IF;
426: OPEN cur_std_to_add FOR l_dyn_std_to_upd USING grp_rec.group_name;

Line 469: errbuf := fnd_msg_pub.get (fnd_msg_pub.g_last, fnd_api.g_false);

465: retcode := 2;
466: IF (lnMsgCount = 1) THEN
467: errbuf := lvMsgData;
468: ELSE
469: errbuf := fnd_msg_pub.get (fnd_msg_pub.g_last, fnd_api.g_false);
470: END IF;
471: RAISE fnd_api.g_exc_error;
472: END IF;
473:

Line 499: fnd_msg_pub.ADD;

495: )
496: || l_dyn_adv_to_add;
497: IF l_status <> fnd_api.g_ret_sts_success THEN
498: fnd_message.set_name ('IGS', 'IGS_AZ_DYN_PERS_ID_GRP_ERR');
499: fnd_msg_pub.ADD;
500: fnd_file.put_line (fnd_file.LOG, fnd_message.get);
501: RAISE fnd_api.g_exc_error;
502: END IF;
503: OPEN cur_adv_to_add FOR l_dyn_adv_to_add USING grp_rec.group_name;

Line 544: errbuf := fnd_msg_pub.get (fnd_msg_pub.g_last, fnd_api.g_false);

540: retcode := 2;
541: IF lnMsgCount = 1 THEN
542: errbuf := lvMsgData;
543: ELSE
544: errbuf := fnd_msg_pub.get (fnd_msg_pub.g_last, fnd_api.g_false);
545: END IF;
546: RAISE fnd_api.g_exc_error;
547: END IF;
548: END LOOP; --cur_adv_to_add

Line 565: fnd_msg_pub.ADD;

561: )
562: || l_dyn_adv_to_upd;
563: IF l_status <> fnd_api.g_ret_sts_success THEN
564: fnd_message.set_name ('IGS', 'IGS_AZ_DYN_PERS_ID_GRP_ERR');
565: fnd_msg_pub.ADD;
566: fnd_file.put_line (fnd_file.LOG, fnd_message.get);
567: RAISE fnd_api.g_exc_error;
568: END IF;
569: OPEN cur_adv_to_add FOR l_dyn_adv_to_upd USING grp_rec.group_name;

Line 613: errbuf := fnd_msg_pub.get (fnd_msg_pub.g_last, fnd_api.g_false);

609: retcode := 2;
610: IF (lnMsgCount = 1) THEN
611: errbuf := lvMsgData;
612: ELSE
613: errbuf := fnd_msg_pub.get (fnd_msg_pub.g_last, fnd_api.g_false);
614: END IF;
615: RAISE fnd_api.g_exc_error;
616: END IF;
617:

Line 643: fnd_msg_pub.ADD;

639: l_status
640: );
641: IF l_status <> fnd_api.g_ret_sts_success THEN
642: fnd_message.set_name ('IGS', 'IGS_AZ_DYN_PERS_ID_GRP_ERR');
643: fnd_msg_pub.ADD;
644: fnd_file.put_line (fnd_file.LOG, fnd_message.get);
645: RAISE fnd_api.g_exc_error;
646: END IF;
647: OPEN cur_std_to_del FOR l_dyn_std_to_del USING grp_rec.group_name;

Line 686: fnd_msg_pub.ADD;

682: l_status
683: );
684: IF l_status <> fnd_api.g_ret_sts_success THEN
685: fnd_message.set_name ('IGS', 'IGS_AZ_DYN_PERS_ID_GRP_ERR');
686: fnd_msg_pub.ADD;
687: fnd_file.put_line (fnd_file.LOG, fnd_message.get);
688: RAISE fnd_api.g_exc_error;
689: END IF;
690: OPEN cur_adv_to_del FOR l_dyn_adv_to_del USING grp_rec.group_name;

Line 846: errbuf := fnd_msg_pub.get (fnd_msg_pub.g_last, fnd_api.g_false);

842: fnd_file.put_line (fnd_file.log, '');
843: --
844: EXCEPTION
845: WHEN fnd_api.g_exc_error THEN
846: errbuf := fnd_msg_pub.get (fnd_msg_pub.g_last, fnd_api.g_false);
847: retcode := 2;
848: ROLLBACK TO s_maintain_groups;
849: --
850: WHEN OTHERS THEN

Line 852: errbuf := fnd_msg_pub.get (fnd_msg_pub.g_last, fnd_api.g_false);

848: ROLLBACK TO s_maintain_groups;
849: --
850: WHEN OTHERS THEN
851: retcode := 2;
852: errbuf := fnd_msg_pub.get (fnd_msg_pub.g_last, fnd_api.g_false);
853: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
854: fnd_message.set_token ('NAME', 'IGS_AZ_GEN_001.Maintain_group : ' || SUBSTR (SQLERRM, 80));
855: fnd_msg_pub.add;
856: fnd_msg_pub.count_and_get(

Line 855: fnd_msg_pub.add;

851: retcode := 2;
852: errbuf := fnd_msg_pub.get (fnd_msg_pub.g_last, fnd_api.g_false);
853: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
854: fnd_message.set_token ('NAME', 'IGS_AZ_GEN_001.Maintain_group : ' || SUBSTR (SQLERRM, 80));
855: fnd_msg_pub.add;
856: fnd_msg_pub.count_and_get(
857: p_encoded => fnd_api.g_false,
858: p_count => lnMsgCount,
859: p_data => lvMsgData

Line 856: fnd_msg_pub.count_and_get(

852: errbuf := fnd_msg_pub.get (fnd_msg_pub.g_last, fnd_api.g_false);
853: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
854: fnd_message.set_token ('NAME', 'IGS_AZ_GEN_001.Maintain_group : ' || SUBSTR (SQLERRM, 80));
855: fnd_msg_pub.add;
856: fnd_msg_pub.count_and_get(
857: p_encoded => fnd_api.g_false,
858: p_count => lnMsgCount,
859: p_data => lvMsgData
860: );

Line 977: fnd_msg_pub.initialize;

973: lvCAutoMatch Varchar2(1) := 'N';
974: --
975: BEGIN
976: --
977: fnd_msg_pub.initialize;
978: --
979: -- Get Auto match indicator
980: --
981: OPEN auto_match_cur;

Line 1074: fnd_msg_pub.add;

1070: EXCEPTION
1071: WHEN OTHERS THEN
1072: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1073: fnd_message.set_token ('NAME', 'ASSIGN_STUDENTS_TO_ADVISORS : ' || SUBSTR (SQLERRM, 80));
1074: fnd_msg_pub.add;
1075: RETURN;
1076: END assign_students_to_advisors;
1077: --
1078: --

Line 1176: fnd_msg_pub.initialize;

1172: BEGIN
1173: --
1174: IGS_GE_GEN_003.SET_ORG_ID(); -- swaghmar, bug# 4951054
1175:
1176: fnd_msg_pub.initialize;
1177: --
1178: OPEN cur_hold_Type;
1179: FETCH cur_hold_Type INTO lvcHoldType;
1180: CLOSE cur_hold_Type;

Line 1205: fnd_msg_pub.initialize;

1201: lvcHoldMsgSubject := fnd_message.get;
1202: --
1203: -- Clear the message buffer now
1204: --
1205: fnd_msg_pub.initialize;
1206: --
1207: FOR std_rec IN cur_appl_hld_std (p_group_name, lvcHoldType) LOOP
1208: --
1209: IF (cur_appl_hld_std%ROWCOUNT = 1) THEN

Line 1324: fnd_msg_pub.initialize;

1320: lvcHoldMsgText := fnd_message.get;
1321: --
1322: -- Once u get the message text in a local variable initialize the message stack
1323: --
1324: fnd_msg_pub.initialize;
1325:
1326:
1327: IF (p_notify = 'Y') THEN
1328:

Line 1345: errbuf := fnd_msg_pub.get (fnd_msg_pub.g_last, fnd_api.g_false);

1341: END IF;
1342: EXCEPTION
1343: WHEN OTHERS THEN
1344: retcode := 2;
1345: errbuf := fnd_msg_pub.get (fnd_msg_pub.g_last, fnd_api.g_false);
1346: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1347: fnd_message.set_token ('NAME', 'IGS_AZ_GEN_001.Apply_hold : ' || SUBSTR (SQLERRM, 80));
1348: fnd_msg_pub.add;
1349: fnd_msg_pub.count_and_get (

Line 1348: fnd_msg_pub.add;

1344: retcode := 2;
1345: errbuf := fnd_msg_pub.get (fnd_msg_pub.g_last, fnd_api.g_false);
1346: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1347: fnd_message.set_token ('NAME', 'IGS_AZ_GEN_001.Apply_hold : ' || SUBSTR (SQLERRM, 80));
1348: fnd_msg_pub.add;
1349: fnd_msg_pub.count_and_get (
1350: p_encoded => fnd_api.g_false,
1351: p_count => lnMsgCount,
1352: p_data => lvMsgData

Line 1349: fnd_msg_pub.count_and_get (

1345: errbuf := fnd_msg_pub.get (fnd_msg_pub.g_last, fnd_api.g_false);
1346: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1347: fnd_message.set_token ('NAME', 'IGS_AZ_GEN_001.Apply_hold : ' || SUBSTR (SQLERRM, 80));
1348: fnd_msg_pub.add;
1349: fnd_msg_pub.count_and_get (
1350: p_encoded => fnd_api.g_false,
1351: p_count => lnMsgCount,
1352: p_data => lvMsgData
1353: );

Line 1462: fnd_msg_pub.initialize;

1458: lvcmsgsubject := fnd_message.get;
1459: --
1460: -- Once u get the message text in a local variable initialize the message stack
1461: --
1462: fnd_msg_pub.initialize;
1463: --
1464: -- Now u start .. 1. For newly added students:
1465: -- Get the message text to be sent to the student for being added to the group.
1466: --

Line 1475: fnd_msg_pub.initialize;

1471: lvcmsgtext := fnd_message.get;
1472: --
1473: -- Once u get the message text in a local variable initialize the message stack
1474: --
1475: fnd_msg_pub.initialize;
1476: --
1477: FOR add_std_rec IN cur_std_add LOOP
1478: IF (cur_std_add%ROWCOUNT = 1) THEN
1479: --

Line 1577: fnd_msg_pub.initialize;

1573: lvcmsgtext := fnd_message.get;
1574: --
1575: -- Once u get the message text in a local variable initialize the message stack
1576: --
1577: fnd_msg_pub.initialize;
1578: --
1579: FOR del_std_rec IN cur_std_del LOOP
1580: --
1581: -- Now since the student is slated to be notified. updated the IGS_AZ_STUDENTS table with NOTIFIED_DATE = sysdate.

Line 1709: fnd_msg_pub.initialize;

1705: lvcmsgtext := fnd_message.get;
1706: --
1707: -- Once u get the message text in a local variable initialize the message stack
1708: --
1709: fnd_msg_pub.initialize;
1710: --
1711: notify_person(
1712: p_busevent => 'oracle.apps.igs.az.ntfyadvr', -- to do --Verify this with final case and seed.
1713: p_param_name1 => 'IA_USERS', ---this must be defined in workflow as the parameter to this event

Line 1784: fnd_msg_pub.initialize;

1780: lvcmsgtext := fnd_message.get;
1781: --
1782: -- Once u get the message text in a local variable initialize the message stack
1783: --
1784: fnd_msg_pub.initialize;
1785: --
1786: notify_person(
1787: p_busevent => 'oracle.apps.igs.az.ntfyadvr', -- to do --Verify this with final case and seed.
1788: p_param_name1 => 'IA_USERS', ---this must be defined in workflow as the parameter to this event

Line 1799: errbuf := fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false);

1795: END IF; -- Some student selected for group add notification.
1796: EXCEPTION
1797: WHEN OTHERS THEN
1798: retcode := 2;
1799: errbuf := fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false);
1800: fnd_message.set_name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1801: fnd_message.set_token(
1802: 'NAME',
1803: 'IGS_AZ_GEN_001.send_notification : ' || SUBSTR(SQLERRM, 80));

Line 1804: fnd_msg_pub.ADD;

1800: fnd_message.set_name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1801: fnd_message.set_token(
1802: 'NAME',
1803: 'IGS_AZ_GEN_001.send_notification : ' || SUBSTR(SQLERRM, 80));
1804: fnd_msg_pub.ADD;
1805: fnd_msg_pub.count_and_get(
1806: p_encoded => fnd_api.g_false,
1807: p_count => lnMsgCount,
1808: p_data => lvMsgData);

Line 1805: fnd_msg_pub.count_and_get(

1801: fnd_message.set_token(
1802: 'NAME',
1803: 'IGS_AZ_GEN_001.send_notification : ' || SUBSTR(SQLERRM, 80));
1804: fnd_msg_pub.ADD;
1805: fnd_msg_pub.count_and_get(
1806: p_encoded => fnd_api.g_false,
1807: p_count => lnMsgCount,
1808: p_data => lvMsgData);
1809: RAISE;

Line 1919: fnd_msg_pub.ADD;

1915: EXCEPTION
1916: WHEN OTHERS THEN
1917: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1918: fnd_message.set_token ('NAME', 'IGS_AZ_GEN_001.notify_person : ' || SUBSTR(SQLERRM, 80));
1919: fnd_msg_pub.ADD;
1920: fnd_msg_pub.count_and_get (
1921: p_encoded => fnd_api.g_false,
1922: p_count => lnMsgCount,
1923: p_data => lvMsgData

Line 1920: fnd_msg_pub.count_and_get (

1916: WHEN OTHERS THEN
1917: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1918: fnd_message.set_token ('NAME', 'IGS_AZ_GEN_001.notify_person : ' || SUBSTR(SQLERRM, 80));
1919: fnd_msg_pub.ADD;
1920: fnd_msg_pub.count_and_get (
1921: p_encoded => fnd_api.g_false,
1922: p_count => lnMsgCount,
1923: p_data => lvMsgData
1924: );

Line 2097: fnd_msg_pub.ADD;

2093: EXCEPTION
2094: WHEN OTHERS THEN
2095: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
2096: fnd_message.set_token ('NAME', 'IGS_AZ_GEN_001.Mainatin_group : ' || SUBSTR (SQLERRM, 80));
2097: fnd_msg_pub.ADD;
2098: fnd_msg_pub.count_and_get (
2099: p_encoded => fnd_api.g_false,
2100: p_count => lnMsgCount,
2101: p_data => lvMsgData

Line 2098: fnd_msg_pub.count_and_get (

2094: WHEN OTHERS THEN
2095: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
2096: fnd_message.set_token ('NAME', 'IGS_AZ_GEN_001.Mainatin_group : ' || SUBSTR (SQLERRM, 80));
2097: fnd_msg_pub.ADD;
2098: fnd_msg_pub.count_and_get (
2099: p_encoded => fnd_api.g_false,
2100: p_count => lnMsgCount,
2101: p_data => lvMsgData
2102: );