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_MESSAGE

Line 251: fnd_message.set_name ('FND', 'CONC-ARGUMENTS');

247: SAVEPOINT s_maintain_groups;
248: --
249: -- Write the passed parameters to the Log File
250: --
251: fnd_message.set_name ('FND', 'CONC-ARGUMENTS');
252: fnd_file.put_line (fnd_file.log, fnd_message.get);
253: fnd_file.put_line (fnd_file.log, '+---------------------------------------------------------------------------+');
254: fnd_file.put_line (fnd_file.log, 'P_GROUP_NAME=''' || p_group_name || '''');
255: fnd_file.put_line (fnd_file.log, 'P_APPLY_HOLD=''' || p_apply_hold || '''');

Line 252: fnd_file.put_line (fnd_file.log, fnd_message.get);

248: --
249: -- Write the passed parameters to the Log File
250: --
251: fnd_message.set_name ('FND', 'CONC-ARGUMENTS');
252: fnd_file.put_line (fnd_file.log, fnd_message.get);
253: fnd_file.put_line (fnd_file.log, '+---------------------------------------------------------------------------+');
254: fnd_file.put_line (fnd_file.log, 'P_GROUP_NAME=''' || p_group_name || '''');
255: fnd_file.put_line (fnd_file.log, 'P_APPLY_HOLD=''' || p_apply_hold || '''');
256: fnd_file.put_line (fnd_file.log, 'P_NOTIFY=''' || p_notify || '''');

Line 350: fnd_message.set_name ('IGS', 'IGS_AZ_DYN_PERS_ID_GRP_ERR');

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

Line 352: fnd_file.put_line (fnd_file.LOG, fnd_message.get);

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: --
356: OPEN cur_std_to_add FOR l_dyn_std_to_add USING grp_rec.group_name;

Line 421: fnd_message.set_name ('IGS', 'IGS_AZ_DYN_PERS_ID_GRP_ERR');

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

Line 423: fnd_file.put_line (fnd_file.LOG, fnd_message.get);

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;
427: ELSE

Line 498: fnd_message.set_name ('IGS', 'IGS_AZ_DYN_PERS_ID_GRP_ERR');

494: l_status
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;

Line 500: fnd_file.put_line (fnd_file.LOG, fnd_message.get);

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;
504: ELSE

Line 564: fnd_message.set_name ('IGS', 'IGS_AZ_DYN_PERS_ID_GRP_ERR');

560: l_status
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;

Line 566: fnd_file.put_line (fnd_file.LOG, fnd_message.get);

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;
570: ELSE

Line 642: fnd_message.set_name ('IGS', 'IGS_AZ_DYN_PERS_ID_GRP_ERR');

638: grp_rec.student_group_id,
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;

Line 644: fnd_file.put_line (fnd_file.LOG, fnd_message.get);

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;
648: ELSE

Line 685: fnd_message.set_name ('IGS', 'IGS_AZ_DYN_PERS_ID_GRP_ERR');

681: grp_rec.advisor_group_id,
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;

Line 687: fnd_file.put_line (fnd_file.LOG, fnd_message.get);

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;
691: ELSE

Line 726: fnd_message.set_name ('IGS', 'IGS_AZ_SUG_STU_ADD');

722: -- Print the Statistics in the log file:
723: --
724: fnd_file.put_line (fnd_file.log, lnGrpCount || '. ' || grp_rec.group_name || ' - ' || grp_rec.group_desc);
725: --
726: fnd_message.set_name ('IGS', 'IGS_AZ_SUG_STU_ADD');
727: fnd_message.set_token ('ADDSTU', lnAddedStudents);
728: fnd_message.set_token ('AUTOSTD', lvAutoStdAddInd);
729: fnd_file.put_line (fnd_file.log, ' o ' || fnd_message.get);
730: --

Line 727: fnd_message.set_token ('ADDSTU', lnAddedStudents);

723: --
724: fnd_file.put_line (fnd_file.log, lnGrpCount || '. ' || grp_rec.group_name || ' - ' || grp_rec.group_desc);
725: --
726: fnd_message.set_name ('IGS', 'IGS_AZ_SUG_STU_ADD');
727: fnd_message.set_token ('ADDSTU', lnAddedStudents);
728: fnd_message.set_token ('AUTOSTD', lvAutoStdAddInd);
729: fnd_file.put_line (fnd_file.log, ' o ' || fnd_message.get);
730: --
731: fnd_message.set_name ('IGS', 'IGS_AZ_SUG_STU_REM');

Line 728: fnd_message.set_token ('AUTOSTD', lvAutoStdAddInd);

724: fnd_file.put_line (fnd_file.log, lnGrpCount || '. ' || grp_rec.group_name || ' - ' || grp_rec.group_desc);
725: --
726: fnd_message.set_name ('IGS', 'IGS_AZ_SUG_STU_ADD');
727: fnd_message.set_token ('ADDSTU', lnAddedStudents);
728: fnd_message.set_token ('AUTOSTD', lvAutoStdAddInd);
729: fnd_file.put_line (fnd_file.log, ' o ' || fnd_message.get);
730: --
731: fnd_message.set_name ('IGS', 'IGS_AZ_SUG_STU_REM');
732: fnd_message.set_token ('DELSTU', lnDelStudents);

Line 729: fnd_file.put_line (fnd_file.log, ' o ' || fnd_message.get);

725: --
726: fnd_message.set_name ('IGS', 'IGS_AZ_SUG_STU_ADD');
727: fnd_message.set_token ('ADDSTU', lnAddedStudents);
728: fnd_message.set_token ('AUTOSTD', lvAutoStdAddInd);
729: fnd_file.put_line (fnd_file.log, ' o ' || fnd_message.get);
730: --
731: fnd_message.set_name ('IGS', 'IGS_AZ_SUG_STU_REM');
732: fnd_message.set_token ('DELSTU', lnDelStudents);
733: fnd_message.set_token ('AUTOST', lvAutoStdDelInd);

Line 731: fnd_message.set_name ('IGS', 'IGS_AZ_SUG_STU_REM');

727: fnd_message.set_token ('ADDSTU', lnAddedStudents);
728: fnd_message.set_token ('AUTOSTD', lvAutoStdAddInd);
729: fnd_file.put_line (fnd_file.log, ' o ' || fnd_message.get);
730: --
731: fnd_message.set_name ('IGS', 'IGS_AZ_SUG_STU_REM');
732: fnd_message.set_token ('DELSTU', lnDelStudents);
733: fnd_message.set_token ('AUTOST', lvAutoStdDelInd);
734: fnd_file.put_line (fnd_file.log, ' o ' || fnd_message.get);
735: --

Line 732: fnd_message.set_token ('DELSTU', lnDelStudents);

728: fnd_message.set_token ('AUTOSTD', lvAutoStdAddInd);
729: fnd_file.put_line (fnd_file.log, ' o ' || fnd_message.get);
730: --
731: fnd_message.set_name ('IGS', 'IGS_AZ_SUG_STU_REM');
732: fnd_message.set_token ('DELSTU', lnDelStudents);
733: fnd_message.set_token ('AUTOST', lvAutoStdDelInd);
734: fnd_file.put_line (fnd_file.log, ' o ' || fnd_message.get);
735: --
736: fnd_message.set_name ('IGS', 'IGS_AZ_SUG_ADV_ADD');

Line 733: fnd_message.set_token ('AUTOST', lvAutoStdDelInd);

729: fnd_file.put_line (fnd_file.log, ' o ' || fnd_message.get);
730: --
731: fnd_message.set_name ('IGS', 'IGS_AZ_SUG_STU_REM');
732: fnd_message.set_token ('DELSTU', lnDelStudents);
733: fnd_message.set_token ('AUTOST', lvAutoStdDelInd);
734: fnd_file.put_line (fnd_file.log, ' o ' || fnd_message.get);
735: --
736: fnd_message.set_name ('IGS', 'IGS_AZ_SUG_ADV_ADD');
737: fnd_message.set_token ('ADDADV', lnAddedAdvisors);

Line 734: fnd_file.put_line (fnd_file.log, ' o ' || fnd_message.get);

730: --
731: fnd_message.set_name ('IGS', 'IGS_AZ_SUG_STU_REM');
732: fnd_message.set_token ('DELSTU', lnDelStudents);
733: fnd_message.set_token ('AUTOST', lvAutoStdDelInd);
734: fnd_file.put_line (fnd_file.log, ' o ' || fnd_message.get);
735: --
736: fnd_message.set_name ('IGS', 'IGS_AZ_SUG_ADV_ADD');
737: fnd_message.set_token ('ADDADV', lnAddedAdvisors);
738: fnd_message.set_token ('AUTOADV', lvAutoAdvAddInd);

Line 736: fnd_message.set_name ('IGS', 'IGS_AZ_SUG_ADV_ADD');

732: fnd_message.set_token ('DELSTU', lnDelStudents);
733: fnd_message.set_token ('AUTOST', lvAutoStdDelInd);
734: fnd_file.put_line (fnd_file.log, ' o ' || fnd_message.get);
735: --
736: fnd_message.set_name ('IGS', 'IGS_AZ_SUG_ADV_ADD');
737: fnd_message.set_token ('ADDADV', lnAddedAdvisors);
738: fnd_message.set_token ('AUTOADV', lvAutoAdvAddInd);
739: fnd_file.put_line (fnd_file.log, ' o ' || fnd_message.get);
740: --

Line 737: fnd_message.set_token ('ADDADV', lnAddedAdvisors);

733: fnd_message.set_token ('AUTOST', lvAutoStdDelInd);
734: fnd_file.put_line (fnd_file.log, ' o ' || fnd_message.get);
735: --
736: fnd_message.set_name ('IGS', 'IGS_AZ_SUG_ADV_ADD');
737: fnd_message.set_token ('ADDADV', lnAddedAdvisors);
738: fnd_message.set_token ('AUTOADV', lvAutoAdvAddInd);
739: fnd_file.put_line (fnd_file.log, ' o ' || fnd_message.get);
740: --
741: fnd_message.set_name ('IGS', 'IGS_AZ_SUG_ADV_REM');

Line 738: fnd_message.set_token ('AUTOADV', lvAutoAdvAddInd);

734: fnd_file.put_line (fnd_file.log, ' o ' || fnd_message.get);
735: --
736: fnd_message.set_name ('IGS', 'IGS_AZ_SUG_ADV_ADD');
737: fnd_message.set_token ('ADDADV', lnAddedAdvisors);
738: fnd_message.set_token ('AUTOADV', lvAutoAdvAddInd);
739: fnd_file.put_line (fnd_file.log, ' o ' || fnd_message.get);
740: --
741: fnd_message.set_name ('IGS', 'IGS_AZ_SUG_ADV_REM');
742: fnd_message.set_token ('DELADV', lnDelAdvisors);

Line 739: fnd_file.put_line (fnd_file.log, ' o ' || fnd_message.get);

735: --
736: fnd_message.set_name ('IGS', 'IGS_AZ_SUG_ADV_ADD');
737: fnd_message.set_token ('ADDADV', lnAddedAdvisors);
738: fnd_message.set_token ('AUTOADV', lvAutoAdvAddInd);
739: fnd_file.put_line (fnd_file.log, ' o ' || fnd_message.get);
740: --
741: fnd_message.set_name ('IGS', 'IGS_AZ_SUG_ADV_REM');
742: fnd_message.set_token ('DELADV', lnDelAdvisors);
743: fnd_message.set_token ('AUTOADV', lvAutoAdvDelInd);

Line 741: fnd_message.set_name ('IGS', 'IGS_AZ_SUG_ADV_REM');

737: fnd_message.set_token ('ADDADV', lnAddedAdvisors);
738: fnd_message.set_token ('AUTOADV', lvAutoAdvAddInd);
739: fnd_file.put_line (fnd_file.log, ' o ' || fnd_message.get);
740: --
741: fnd_message.set_name ('IGS', 'IGS_AZ_SUG_ADV_REM');
742: fnd_message.set_token ('DELADV', lnDelAdvisors);
743: fnd_message.set_token ('AUTOADV', lvAutoAdvDelInd);
744: fnd_file.put_line (fnd_file.log, ' o ' || fnd_message.get);
745: --

Line 742: fnd_message.set_token ('DELADV', lnDelAdvisors);

738: fnd_message.set_token ('AUTOADV', lvAutoAdvAddInd);
739: fnd_file.put_line (fnd_file.log, ' o ' || fnd_message.get);
740: --
741: fnd_message.set_name ('IGS', 'IGS_AZ_SUG_ADV_REM');
742: fnd_message.set_token ('DELADV', lnDelAdvisors);
743: fnd_message.set_token ('AUTOADV', lvAutoAdvDelInd);
744: fnd_file.put_line (fnd_file.log, ' o ' || fnd_message.get);
745: --
746: fnd_message.set_name ('IGS', 'IGS_AZ_SUG_MATCH');

Line 743: fnd_message.set_token ('AUTOADV', lvAutoAdvDelInd);

739: fnd_file.put_line (fnd_file.log, ' o ' || fnd_message.get);
740: --
741: fnd_message.set_name ('IGS', 'IGS_AZ_SUG_ADV_REM');
742: fnd_message.set_token ('DELADV', lnDelAdvisors);
743: fnd_message.set_token ('AUTOADV', lvAutoAdvDelInd);
744: fnd_file.put_line (fnd_file.log, ' o ' || fnd_message.get);
745: --
746: fnd_message.set_name ('IGS', 'IGS_AZ_SUG_MATCH');
747: fnd_message.set_token ('SUGGMAT', lnSuggestedMatches);

Line 744: fnd_file.put_line (fnd_file.log, ' o ' || fnd_message.get);

740: --
741: fnd_message.set_name ('IGS', 'IGS_AZ_SUG_ADV_REM');
742: fnd_message.set_token ('DELADV', lnDelAdvisors);
743: fnd_message.set_token ('AUTOADV', lvAutoAdvDelInd);
744: fnd_file.put_line (fnd_file.log, ' o ' || fnd_message.get);
745: --
746: fnd_message.set_name ('IGS', 'IGS_AZ_SUG_MATCH');
747: fnd_message.set_token ('SUGGMAT', lnSuggestedMatches);
748: fnd_message.set_token ('AUTOMAT', lvAutoMatchInd);

Line 746: fnd_message.set_name ('IGS', 'IGS_AZ_SUG_MATCH');

742: fnd_message.set_token ('DELADV', lnDelAdvisors);
743: fnd_message.set_token ('AUTOADV', lvAutoAdvDelInd);
744: fnd_file.put_line (fnd_file.log, ' o ' || fnd_message.get);
745: --
746: fnd_message.set_name ('IGS', 'IGS_AZ_SUG_MATCH');
747: fnd_message.set_token ('SUGGMAT', lnSuggestedMatches);
748: fnd_message.set_token ('AUTOMAT', lvAutoMatchInd);
749: fnd_file.put_line (fnd_file.log, ' o ' || fnd_message.get);
750: fnd_file.put_line (fnd_file.log, '');

Line 747: fnd_message.set_token ('SUGGMAT', lnSuggestedMatches);

743: fnd_message.set_token ('AUTOADV', lvAutoAdvDelInd);
744: fnd_file.put_line (fnd_file.log, ' o ' || fnd_message.get);
745: --
746: fnd_message.set_name ('IGS', 'IGS_AZ_SUG_MATCH');
747: fnd_message.set_token ('SUGGMAT', lnSuggestedMatches);
748: fnd_message.set_token ('AUTOMAT', lvAutoMatchInd);
749: fnd_file.put_line (fnd_file.log, ' o ' || fnd_message.get);
750: fnd_file.put_line (fnd_file.log, '');
751: --

Line 748: fnd_message.set_token ('AUTOMAT', lvAutoMatchInd);

744: fnd_file.put_line (fnd_file.log, ' o ' || fnd_message.get);
745: --
746: fnd_message.set_name ('IGS', 'IGS_AZ_SUG_MATCH');
747: fnd_message.set_token ('SUGGMAT', lnSuggestedMatches);
748: fnd_message.set_token ('AUTOMAT', lvAutoMatchInd);
749: fnd_file.put_line (fnd_file.log, ' o ' || fnd_message.get);
750: fnd_file.put_line (fnd_file.log, '');
751: --
752: -- See if the auto notification parameter is passed as Yes

Line 749: fnd_file.put_line (fnd_file.log, ' o ' || fnd_message.get);

745: --
746: fnd_message.set_name ('IGS', 'IGS_AZ_SUG_MATCH');
747: fnd_message.set_token ('SUGGMAT', lnSuggestedMatches);
748: fnd_message.set_token ('AUTOMAT', lvAutoMatchInd);
749: fnd_file.put_line (fnd_file.log, ' o ' || fnd_message.get);
750: fnd_file.put_line (fnd_file.log, '');
751: --
752: -- See if the auto notification parameter is passed as Yes
753: --

Line 839: fnd_message.set_name ('IGS', 'IGS_AD_TOT_REC_PRC');

835: x_msg_data => lvMsgData,
836: x_msg_count => lnMsgCount
837: );
838: END LOOP; -- main
839: fnd_message.set_name ('IGS', 'IGS_AD_TOT_REC_PRC');
840: fnd_message.set_token ('RCOUNT', lnGrpCount);
841: fnd_file.put_line (fnd_file.log, fnd_message.get);
842: fnd_file.put_line (fnd_file.log, '');
843: --

Line 840: fnd_message.set_token ('RCOUNT', lnGrpCount);

836: x_msg_count => lnMsgCount
837: );
838: END LOOP; -- main
839: fnd_message.set_name ('IGS', 'IGS_AD_TOT_REC_PRC');
840: fnd_message.set_token ('RCOUNT', lnGrpCount);
841: fnd_file.put_line (fnd_file.log, fnd_message.get);
842: fnd_file.put_line (fnd_file.log, '');
843: --
844: EXCEPTION

Line 841: fnd_file.put_line (fnd_file.log, fnd_message.get);

837: );
838: END LOOP; -- main
839: fnd_message.set_name ('IGS', 'IGS_AD_TOT_REC_PRC');
840: fnd_message.set_token ('RCOUNT', lnGrpCount);
841: fnd_file.put_line (fnd_file.log, fnd_message.get);
842: fnd_file.put_line (fnd_file.log, '');
843: --
844: EXCEPTION
845: WHEN fnd_api.g_exc_error THEN

Line 853: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

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(
857: p_encoded => fnd_api.g_false,

Line 854: fnd_message.set_token ('NAME', 'IGS_AZ_GEN_001.Maintain_group : ' || SUBSTR (SQLERRM, 80));

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(
857: p_encoded => fnd_api.g_false,
858: p_count => lnMsgCount,

Line 1072: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

1068: p_n_processed := lnProcessed;
1069: --
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;

Line 1073: fnd_message.set_token ('NAME', 'ASSIGN_STUDENTS_TO_ADVISORS : ' || SUBSTR (SQLERRM, 80));

1069: --
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: --

Line 1199: fnd_message.set_name ('IGS', 'IGS_AZ_HOLD_NOTIF_SUBJECT'); -- Bug# 5283309

1195: lvcHoldPersonIds := NULL;
1196: --
1197: -- Set the token and get the message which will be used as subject for the hold notification.
1198: --
1199: fnd_message.set_name ('IGS', 'IGS_AZ_HOLD_NOTIF_SUBJECT'); -- Bug# 5283309
1200: fnd_message.set_token ('GROUP_NAME', p_group_name);
1201: lvcHoldMsgSubject := fnd_message.get;
1202: --
1203: -- Clear the message buffer now

Line 1200: fnd_message.set_token ('GROUP_NAME', p_group_name);

1196: --
1197: -- Set the token and get the message which will be used as subject for the hold notification.
1198: --
1199: fnd_message.set_name ('IGS', 'IGS_AZ_HOLD_NOTIF_SUBJECT'); -- Bug# 5283309
1200: fnd_message.set_token ('GROUP_NAME', p_group_name);
1201: lvcHoldMsgSubject := fnd_message.get;
1202: --
1203: -- Clear the message buffer now
1204: --

Line 1201: lvcHoldMsgSubject := fnd_message.get;

1197: -- Set the token and get the message which will be used as subject for the hold notification.
1198: --
1199: fnd_message.set_name ('IGS', 'IGS_AZ_HOLD_NOTIF_SUBJECT'); -- Bug# 5283309
1200: fnd_message.set_token ('GROUP_NAME', p_group_name);
1201: lvcHoldMsgSubject := fnd_message.get;
1202: --
1203: -- Clear the message buffer now
1204: --
1205: fnd_msg_pub.initialize;

Line 1211: fnd_message.set_name ('IGS', 'IGS_AZ_STU_LIST_HOLD_APPLIED');

1207: FOR std_rec IN cur_appl_hld_std (p_group_name, lvcHoldType) LOOP
1208: --
1209: IF (cur_appl_hld_std%ROWCOUNT = 1) THEN
1210: -- Put the entry in the log file for the students who are being put on advising hold...
1211: fnd_message.set_name ('IGS', 'IGS_AZ_STU_LIST_HOLD_APPLIED');
1212: fnd_file.put_line (fnd_file.log, fnd_message.get);
1213: END IF;
1214: --
1215: -- 1. Create a record in table IGS_PE_PERS_ENCUMB

Line 1212: fnd_file.put_line (fnd_file.log, fnd_message.get);

1208: --
1209: IF (cur_appl_hld_std%ROWCOUNT = 1) THEN
1210: -- Put the entry in the log file for the students who are being put on advising hold...
1211: fnd_message.set_name ('IGS', 'IGS_AZ_STU_LIST_HOLD_APPLIED');
1212: fnd_file.put_line (fnd_file.log, fnd_message.get);
1213: END IF;
1214: --
1215: -- 1. Create a record in table IGS_PE_PERS_ENCUMB
1216: --

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

1312: IF (NVL (LENGTH (lvcHoldPersonIds), 0) > 0) THEN
1313: --
1314: -- Get the message text to be sent to the student for being added to the group.
1315: --
1316: fnd_message.set_name ('IGS', 'IGS_AZ_HOLD_NOTIF_TEXT');
1317: fnd_message.set_token ('GROUP_NAME', p_group_name);
1318: fnd_message.set_token ('START_DATE', TO_CHAR (SYSDATE, 'DD-MON-RRRR'));
1319: --
1320: lvcHoldMsgText := fnd_message.get;

Line 1317: fnd_message.set_token ('GROUP_NAME', p_group_name);

1313: --
1314: -- Get the message text to be sent to the student for being added to the group.
1315: --
1316: fnd_message.set_name ('IGS', 'IGS_AZ_HOLD_NOTIF_TEXT');
1317: fnd_message.set_token ('GROUP_NAME', p_group_name);
1318: fnd_message.set_token ('START_DATE', TO_CHAR (SYSDATE, 'DD-MON-RRRR'));
1319: --
1320: lvcHoldMsgText := fnd_message.get;
1321: --

Line 1318: fnd_message.set_token ('START_DATE', TO_CHAR (SYSDATE, 'DD-MON-RRRR'));

1314: -- Get the message text to be sent to the student for being added to the group.
1315: --
1316: fnd_message.set_name ('IGS', 'IGS_AZ_HOLD_NOTIF_TEXT');
1317: fnd_message.set_token ('GROUP_NAME', p_group_name);
1318: fnd_message.set_token ('START_DATE', TO_CHAR (SYSDATE, 'DD-MON-RRRR'));
1319: --
1320: lvcHoldMsgText := fnd_message.get;
1321: --
1322: -- Once u get the message text in a local variable initialize the message stack

Line 1320: lvcHoldMsgText := fnd_message.get;

1316: fnd_message.set_name ('IGS', 'IGS_AZ_HOLD_NOTIF_TEXT');
1317: fnd_message.set_token ('GROUP_NAME', p_group_name);
1318: fnd_message.set_token ('START_DATE', TO_CHAR (SYSDATE, 'DD-MON-RRRR'));
1319: --
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;

Line 1346: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

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 (
1350: p_encoded => fnd_api.g_false,

Line 1347: fnd_message.set_token ('NAME', 'IGS_AZ_GEN_001.Apply_hold : ' || SUBSTR (SQLERRM, 80));

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 (
1350: p_encoded => fnd_api.g_false,
1351: p_count => lnMsgCount,

Line 1456: fnd_message.set_name('IGS', 'IGS_AZ_NOTIF_SUBJECT');

1452: -- all kinds of advising notification. (Message IGS_AZ_NOTIF_SUBJECT Token Group name ).
1453: --
1454: IGS_GE_GEN_003.SET_ORG_ID(); -- swaghmar, bug# 4951054
1455:
1456: fnd_message.set_name('IGS', 'IGS_AZ_NOTIF_SUBJECT');
1457: fnd_message.set_token('GROUP_NAME', p_group_name);
1458: lvcmsgsubject := fnd_message.get;
1459: --
1460: -- Once u get the message text in a local variable initialize the message stack

Line 1457: fnd_message.set_token('GROUP_NAME', p_group_name);

1453: --
1454: IGS_GE_GEN_003.SET_ORG_ID(); -- swaghmar, bug# 4951054
1455:
1456: fnd_message.set_name('IGS', 'IGS_AZ_NOTIF_SUBJECT');
1457: fnd_message.set_token('GROUP_NAME', p_group_name);
1458: lvcmsgsubject := fnd_message.get;
1459: --
1460: -- Once u get the message text in a local variable initialize the message stack
1461: --

Line 1458: lvcmsgsubject := fnd_message.get;

1454: IGS_GE_GEN_003.SET_ORG_ID(); -- swaghmar, bug# 4951054
1455:
1456: fnd_message.set_name('IGS', 'IGS_AZ_NOTIF_SUBJECT');
1457: fnd_message.set_token('GROUP_NAME', p_group_name);
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;

Line 1467: fnd_message.set_name('IGS', 'IGS_AZ_NOTIF_TEXT');

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: --
1467: fnd_message.set_name('IGS', 'IGS_AZ_NOTIF_TEXT');
1468: fnd_message.set_token('GROUP_NAME', p_group_name);
1469: fnd_message.set_token('ADDED_REMOVED ', ' assigned to');
1470: fnd_message.set_token('NOTIF_DATE', TO_CHAR(SYSDATE, 'DD-MON-YY'));
1471: lvcmsgtext := fnd_message.get;

Line 1468: fnd_message.set_token('GROUP_NAME', p_group_name);

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: --
1467: fnd_message.set_name('IGS', 'IGS_AZ_NOTIF_TEXT');
1468: fnd_message.set_token('GROUP_NAME', p_group_name);
1469: fnd_message.set_token('ADDED_REMOVED ', ' assigned to');
1470: fnd_message.set_token('NOTIF_DATE', TO_CHAR(SYSDATE, 'DD-MON-YY'));
1471: lvcmsgtext := fnd_message.get;
1472: --

Line 1469: fnd_message.set_token('ADDED_REMOVED ', ' assigned to');

1465: -- Get the message text to be sent to the student for being added to the group.
1466: --
1467: fnd_message.set_name('IGS', 'IGS_AZ_NOTIF_TEXT');
1468: fnd_message.set_token('GROUP_NAME', p_group_name);
1469: fnd_message.set_token('ADDED_REMOVED ', ' assigned to');
1470: fnd_message.set_token('NOTIF_DATE', TO_CHAR(SYSDATE, 'DD-MON-YY'));
1471: lvcmsgtext := fnd_message.get;
1472: --
1473: -- Once u get the message text in a local variable initialize the message stack

Line 1470: fnd_message.set_token('NOTIF_DATE', TO_CHAR(SYSDATE, 'DD-MON-YY'));

1466: --
1467: fnd_message.set_name('IGS', 'IGS_AZ_NOTIF_TEXT');
1468: fnd_message.set_token('GROUP_NAME', p_group_name);
1469: fnd_message.set_token('ADDED_REMOVED ', ' assigned to');
1470: fnd_message.set_token('NOTIF_DATE', TO_CHAR(SYSDATE, 'DD-MON-YY'));
1471: lvcmsgtext := fnd_message.get;
1472: --
1473: -- Once u get the message text in a local variable initialize the message stack
1474: --

Line 1471: lvcmsgtext := fnd_message.get;

1467: fnd_message.set_name('IGS', 'IGS_AZ_NOTIF_TEXT');
1468: fnd_message.set_token('GROUP_NAME', p_group_name);
1469: fnd_message.set_token('ADDED_REMOVED ', ' assigned to');
1470: fnd_message.set_token('NOTIF_DATE', TO_CHAR(SYSDATE, 'DD-MON-YY'));
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;

Line 1482: fnd_message.set_name('IGS', 'IGS_AZ_STU_LIST_ADD');

1478: IF (cur_std_add%ROWCOUNT = 1) THEN
1479: --
1480: -- Log that u are going to start the notification for the students being added
1481: --
1482: fnd_message.set_name('IGS', 'IGS_AZ_STU_LIST_ADD');
1483: fnd_file.put_line(fnd_file.LOG, fnd_message.get);
1484: END IF;
1485: --
1486: -- Now since the student is slated to be notified, updated the IGS_AZ_STUDENTS table with NOTIFIED_DATE = sysdate.

Line 1483: fnd_file.put_line(fnd_file.LOG, fnd_message.get);

1479: --
1480: -- Log that u are going to start the notification for the students being added
1481: --
1482: fnd_message.set_name('IGS', 'IGS_AZ_STU_LIST_ADD');
1483: fnd_file.put_line(fnd_file.LOG, fnd_message.get);
1484: END IF;
1485: --
1486: -- Now since the student is slated to be notified, updated the IGS_AZ_STUDENTS table with NOTIFIED_DATE = sysdate.
1487: --

Line 1564: fnd_message.set_name('IGS', 'IGS_AZ_STU_LIST_DEL');

1560: --
1561: -- Send notification to the student who are removed from the group.
1562: -- Log that u are going to start the notification for the students being rmoved from the group
1563: --
1564: fnd_message.set_name('IGS', 'IGS_AZ_STU_LIST_DEL');
1565: fnd_file.put_line(fnd_file.LOG, fnd_message.get);
1566: --
1567: -- Get the message text to be sent to the student for being added to the group.
1568: --

Line 1565: fnd_file.put_line(fnd_file.LOG, fnd_message.get);

1561: -- Send notification to the student who are removed from the group.
1562: -- Log that u are going to start the notification for the students being rmoved from the group
1563: --
1564: fnd_message.set_name('IGS', 'IGS_AZ_STU_LIST_DEL');
1565: fnd_file.put_line(fnd_file.LOG, fnd_message.get);
1566: --
1567: -- Get the message text to be sent to the student for being added to the group.
1568: --
1569: fnd_message.set_name('IGS', 'IGS_AZ_NOTIF_TEXT');

Line 1569: fnd_message.set_name('IGS', 'IGS_AZ_NOTIF_TEXT');

1565: fnd_file.put_line(fnd_file.LOG, fnd_message.get);
1566: --
1567: -- Get the message text to be sent to the student for being added to the group.
1568: --
1569: fnd_message.set_name('IGS', 'IGS_AZ_NOTIF_TEXT');
1570: fnd_message.set_token('GROUP_NAME', p_group_name);
1571: fnd_message.set_token('ADDED_REMOVED ', ' removed from');
1572: fnd_message.set_token('NOTIF_DATE', TO_CHAR(SYSDATE, 'DD-MON-YY'));
1573: lvcmsgtext := fnd_message.get;

Line 1570: fnd_message.set_token('GROUP_NAME', p_group_name);

1566: --
1567: -- Get the message text to be sent to the student for being added to the group.
1568: --
1569: fnd_message.set_name('IGS', 'IGS_AZ_NOTIF_TEXT');
1570: fnd_message.set_token('GROUP_NAME', p_group_name);
1571: fnd_message.set_token('ADDED_REMOVED ', ' removed from');
1572: fnd_message.set_token('NOTIF_DATE', TO_CHAR(SYSDATE, 'DD-MON-YY'));
1573: lvcmsgtext := fnd_message.get;
1574: --

Line 1571: fnd_message.set_token('ADDED_REMOVED ', ' removed from');

1567: -- Get the message text to be sent to the student for being added to the group.
1568: --
1569: fnd_message.set_name('IGS', 'IGS_AZ_NOTIF_TEXT');
1570: fnd_message.set_token('GROUP_NAME', p_group_name);
1571: fnd_message.set_token('ADDED_REMOVED ', ' removed from');
1572: fnd_message.set_token('NOTIF_DATE', TO_CHAR(SYSDATE, 'DD-MON-YY'));
1573: lvcmsgtext := fnd_message.get;
1574: --
1575: -- Once u get the message text in a local variable initialize the message stack

Line 1572: fnd_message.set_token('NOTIF_DATE', TO_CHAR(SYSDATE, 'DD-MON-YY'));

1568: --
1569: fnd_message.set_name('IGS', 'IGS_AZ_NOTIF_TEXT');
1570: fnd_message.set_token('GROUP_NAME', p_group_name);
1571: fnd_message.set_token('ADDED_REMOVED ', ' removed from');
1572: fnd_message.set_token('NOTIF_DATE', TO_CHAR(SYSDATE, 'DD-MON-YY'));
1573: lvcmsgtext := fnd_message.get;
1574: --
1575: -- Once u get the message text in a local variable initialize the message stack
1576: --

Line 1573: lvcmsgtext := fnd_message.get;

1569: fnd_message.set_name('IGS', 'IGS_AZ_NOTIF_TEXT');
1570: fnd_message.set_token('GROUP_NAME', p_group_name);
1571: fnd_message.set_token('ADDED_REMOVED ', ' removed from');
1572: fnd_message.set_token('NOTIF_DATE', TO_CHAR(SYSDATE, 'DD-MON-YY'));
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;

Line 1659: fnd_message.set_name('IGS', 'IGS_AZ_STU_LIST_NOTIFY_ADD');

1655: -- Notify the advisors now:
1656: --
1657: -- Log that u are going to start the notification for the advisors being assigned the group
1658: --
1659: fnd_message.set_name('IGS', 'IGS_AZ_STU_LIST_NOTIFY_ADD');
1660: fnd_file.put_line(fnd_file.LOG, fnd_message.get);
1661: --
1662: FOR add_adv_rec IN cur_adv_add LOOP
1663: --

Line 1660: fnd_file.put_line(fnd_file.LOG, fnd_message.get);

1656: --
1657: -- Log that u are going to start the notification for the advisors being assigned the group
1658: --
1659: fnd_message.set_name('IGS', 'IGS_AZ_STU_LIST_NOTIFY_ADD');
1660: fnd_file.put_line(fnd_file.LOG, fnd_message.get);
1661: --
1662: FOR add_adv_rec IN cur_adv_add LOOP
1663: --
1664: lvcpersonids := lvcpersonids || ',' || add_adv_rec.advisor_person_id; -- To do See here I am using student_person_id inplace of Froup_student_ID(seq gen PK) as mentioned in FD.

Line 1701: fnd_message.set_name('IGS', 'IGS_AZ_NOTIF_TEXT');

1697: IF NVL(LENGTH(lvcpersonids), 0) > 0 THEN
1698: --
1699: -- Get the message text to be sent to the student for being added to the group.
1700: --
1701: fnd_message.set_name('IGS', 'IGS_AZ_NOTIF_TEXT');
1702: fnd_message.set_token('GROUP_NAME', p_group_name);
1703: fnd_message.set_token('ADDED_REMOVED ', ' assigned to');
1704: fnd_message.set_token('NOTIF_DATE', TO_CHAR(SYSDATE, 'DD-MON-YY'));
1705: lvcmsgtext := fnd_message.get;

Line 1702: fnd_message.set_token('GROUP_NAME', p_group_name);

1698: --
1699: -- Get the message text to be sent to the student for being added to the group.
1700: --
1701: fnd_message.set_name('IGS', 'IGS_AZ_NOTIF_TEXT');
1702: fnd_message.set_token('GROUP_NAME', p_group_name);
1703: fnd_message.set_token('ADDED_REMOVED ', ' assigned to');
1704: fnd_message.set_token('NOTIF_DATE', TO_CHAR(SYSDATE, 'DD-MON-YY'));
1705: lvcmsgtext := fnd_message.get;
1706: --

Line 1703: fnd_message.set_token('ADDED_REMOVED ', ' assigned to');

1699: -- Get the message text to be sent to the student for being added to the group.
1700: --
1701: fnd_message.set_name('IGS', 'IGS_AZ_NOTIF_TEXT');
1702: fnd_message.set_token('GROUP_NAME', p_group_name);
1703: fnd_message.set_token('ADDED_REMOVED ', ' assigned to');
1704: fnd_message.set_token('NOTIF_DATE', TO_CHAR(SYSDATE, 'DD-MON-YY'));
1705: lvcmsgtext := fnd_message.get;
1706: --
1707: -- Once u get the message text in a local variable initialize the message stack

Line 1704: fnd_message.set_token('NOTIF_DATE', TO_CHAR(SYSDATE, 'DD-MON-YY'));

1700: --
1701: fnd_message.set_name('IGS', 'IGS_AZ_NOTIF_TEXT');
1702: fnd_message.set_token('GROUP_NAME', p_group_name);
1703: fnd_message.set_token('ADDED_REMOVED ', ' assigned to');
1704: fnd_message.set_token('NOTIF_DATE', TO_CHAR(SYSDATE, 'DD-MON-YY'));
1705: lvcmsgtext := fnd_message.get;
1706: --
1707: -- Once u get the message text in a local variable initialize the message stack
1708: --

Line 1705: lvcmsgtext := fnd_message.get;

1701: fnd_message.set_name('IGS', 'IGS_AZ_NOTIF_TEXT');
1702: fnd_message.set_token('GROUP_NAME', p_group_name);
1703: fnd_message.set_token('ADDED_REMOVED ', ' assigned to');
1704: fnd_message.set_token('NOTIF_DATE', TO_CHAR(SYSDATE, 'DD-MON-YY'));
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;

Line 1729: fnd_message.set_name('IGS', 'IGS_AZ_STU_LIST_NOTIFY_AD_REM');

1725: --
1726: -- Send notification to the advisor who are removed from the group.
1727: -- Log that u are going to start the notification for the advisors being rmoved from the group
1728: --
1729: fnd_message.set_name('IGS', 'IGS_AZ_STU_LIST_NOTIFY_AD_REM');
1730: fnd_file.put_line(fnd_file.LOG, fnd_message.get);
1731: --
1732: FOR del_adv_rec IN cur_adv_del LOOP
1733: --

Line 1730: fnd_file.put_line(fnd_file.LOG, fnd_message.get);

1726: -- Send notification to the advisor who are removed from the group.
1727: -- Log that u are going to start the notification for the advisors being rmoved from the group
1728: --
1729: fnd_message.set_name('IGS', 'IGS_AZ_STU_LIST_NOTIFY_AD_REM');
1730: fnd_file.put_line(fnd_file.LOG, fnd_message.get);
1731: --
1732: FOR del_adv_rec IN cur_adv_del LOOP
1733: --
1734: -- set the staus, message count etc. back to null so that it is used in the next call

Line 1776: fnd_message.set_name('IGS', 'IGS_AZ_NOTIF_TEXT');

1772: IF NVL(LENGTH(lvcpersonids), 0) > 0 THEN
1773: --
1774: -- Get the message text to be sent to the student for being added to the group.
1775: --
1776: fnd_message.set_name('IGS', 'IGS_AZ_NOTIF_TEXT');
1777: fnd_message.set_token('GROUP_NAME', p_group_name);
1778: fnd_message.set_token('ADDED_REMOVED ', ' removed from');
1779: fnd_message.set_token('NOTIF_DATE', TO_CHAR(SYSDATE, 'DD-MON-YY'));
1780: lvcmsgtext := fnd_message.get;

Line 1777: fnd_message.set_token('GROUP_NAME', p_group_name);

1773: --
1774: -- Get the message text to be sent to the student for being added to the group.
1775: --
1776: fnd_message.set_name('IGS', 'IGS_AZ_NOTIF_TEXT');
1777: fnd_message.set_token('GROUP_NAME', p_group_name);
1778: fnd_message.set_token('ADDED_REMOVED ', ' removed from');
1779: fnd_message.set_token('NOTIF_DATE', TO_CHAR(SYSDATE, 'DD-MON-YY'));
1780: lvcmsgtext := fnd_message.get;
1781: --

Line 1778: fnd_message.set_token('ADDED_REMOVED ', ' removed from');

1774: -- Get the message text to be sent to the student for being added to the group.
1775: --
1776: fnd_message.set_name('IGS', 'IGS_AZ_NOTIF_TEXT');
1777: fnd_message.set_token('GROUP_NAME', p_group_name);
1778: fnd_message.set_token('ADDED_REMOVED ', ' removed from');
1779: fnd_message.set_token('NOTIF_DATE', TO_CHAR(SYSDATE, 'DD-MON-YY'));
1780: lvcmsgtext := fnd_message.get;
1781: --
1782: -- Once u get the message text in a local variable initialize the message stack

Line 1779: fnd_message.set_token('NOTIF_DATE', TO_CHAR(SYSDATE, 'DD-MON-YY'));

1775: --
1776: fnd_message.set_name('IGS', 'IGS_AZ_NOTIF_TEXT');
1777: fnd_message.set_token('GROUP_NAME', p_group_name);
1778: fnd_message.set_token('ADDED_REMOVED ', ' removed from');
1779: fnd_message.set_token('NOTIF_DATE', TO_CHAR(SYSDATE, 'DD-MON-YY'));
1780: lvcmsgtext := fnd_message.get;
1781: --
1782: -- Once u get the message text in a local variable initialize the message stack
1783: --

Line 1780: lvcmsgtext := fnd_message.get;

1776: fnd_message.set_name('IGS', 'IGS_AZ_NOTIF_TEXT');
1777: fnd_message.set_token('GROUP_NAME', p_group_name);
1778: fnd_message.set_token('ADDED_REMOVED ', ' removed from');
1779: fnd_message.set_token('NOTIF_DATE', TO_CHAR(SYSDATE, 'DD-MON-YY'));
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;

Line 1800: fnd_message.set_name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

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));
1804: fnd_msg_pub.ADD;

Line 1801: fnd_message.set_token(

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));
1804: fnd_msg_pub.ADD;
1805: fnd_msg_pub.count_and_get(

Line 1917: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

1913: l_parameter_list_t.DELETE;
1914: --
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,

Line 1918: fnd_message.set_token ('NAME', 'IGS_AZ_GEN_001.notify_person : ' || SUBSTR(SQLERRM, 80));

1914: --
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,

Line 2095: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

2091: );
2092: END LOOP;
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,

Line 2096: fnd_message.set_token ('NAME', 'IGS_AZ_GEN_001.Mainatin_group : ' || SUBSTR (SQLERRM, 80));

2092: END LOOP;
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,

Line 2403: p_message_data := fnd_message.get;

2399: argument1 => p_group_name
2400: );
2401: --
2402: IF l_req_id = 0 THEN
2403: p_message_data := fnd_message.get;
2404: END IF;
2405: --
2406: p_request_id := l_req_id;
2407: --