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_FILE

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 253: fnd_file.put_line (fnd_file.log, '+---------------------------------------------------------------------------+');

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 || '''');
257: fnd_file.put_line (fnd_file.log, '+---------------------------------------------------------------------------+');

Line 254: fnd_file.put_line (fnd_file.log, 'P_GROUP_NAME=''' || p_group_name || '''');

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 || '''');
257: fnd_file.put_line (fnd_file.log, '+---------------------------------------------------------------------------+');
258: fnd_file.put_line (fnd_file.log, '');

Line 255: fnd_file.put_line (fnd_file.log, 'P_APPLY_HOLD=''' || p_apply_hold || '''');

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 || '''');
257: fnd_file.put_line (fnd_file.log, '+---------------------------------------------------------------------------+');
258: fnd_file.put_line (fnd_file.log, '');
259: --

Line 256: fnd_file.put_line (fnd_file.log, 'P_NOTIFY=''' || p_notify || '''');

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 || '''');
257: fnd_file.put_line (fnd_file.log, '+---------------------------------------------------------------------------+');
258: fnd_file.put_line (fnd_file.log, '');
259: --
260: FOR grp_rec IN cur_grp_to_be_processed LOOP

Line 257: fnd_file.put_line (fnd_file.log, '+---------------------------------------------------------------------------+');

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 || '''');
257: fnd_file.put_line (fnd_file.log, '+---------------------------------------------------------------------------+');
258: fnd_file.put_line (fnd_file.log, '');
259: --
260: FOR grp_rec IN cur_grp_to_be_processed LOOP
261: --

Line 258: 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 || '''');
257: fnd_file.put_line (fnd_file.log, '+---------------------------------------------------------------------------+');
258: fnd_file.put_line (fnd_file.log, '');
259: --
260: FOR grp_rec IN cur_grp_to_be_processed LOOP
261: --
262: -- check whether the dynamic persid group has to be used or not for advisor

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 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 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 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 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 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 724: fnd_file.put_line (fnd_file.log, lnGrpCount || '. ' || grp_rec.group_name || ' - ' || grp_rec.group_desc);

720: END IF;
721: --
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);

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 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 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 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 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 750: fnd_file.put_line (fnd_file.log, '');

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: --
754: IF (p_notify = 'Y') THEN

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 842: fnd_file.put_line (fnd_file.log, '');

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
846: errbuf := fnd_msg_pub.get (fnd_msg_pub.g_last, fnd_api.g_false);

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 1302: fnd_file.put_line (fnd_file.log, ' ' || std_rec.party_number || ' - ' || std_rec.party_name) ;

1298: );
1299: --
1300: -- Put in the log the info about student being put on hold..
1301: --
1302: fnd_file.put_line (fnd_file.log, ' ' || std_rec.party_number || ' - ' || std_rec.party_name) ;
1303: --
1304: END LOOP; --std_rec
1305: --
1306: -- Get the first comma from the comma separated list of person IDs.

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 1507: fnd_file.put_line(

1503: );
1504: --
1505: -- Log that the selected student is notified.
1506: --
1507: fnd_file.put_line(
1508: fnd_file.LOG,
1509: ' - ' || add_std_rec.party_number || ' - ' || add_std_rec.party_name);
1510: lvcpersonids := lvcpersonids || ',' || add_std_rec.student_person_id;
1511: lncount := lncount + 1;

Line 1508: fnd_file.LOG,

1504: --
1505: -- Log that the selected student is notified.
1506: --
1507: fnd_file.put_line(
1508: fnd_file.LOG,
1509: ' - ' || add_std_rec.party_number || ' - ' || add_std_rec.party_name);
1510: lvcpersonids := lvcpersonids || ',' || add_std_rec.student_person_id;
1511: lncount := lncount + 1;
1512: --

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 1602: fnd_file.put_line(

1598: );
1599: --
1600: -- Log that the selected student is removed from the group.
1601: --
1602: fnd_file.put_line(
1603: fnd_file.LOG,
1604: ' - ' || del_std_rec.party_number || ' - ' || del_std_rec.party_name);
1605: --
1606: lncount := lncount + 1;

Line 1603: fnd_file.LOG,

1599: --
1600: -- Log that the selected student is removed from the group.
1601: --
1602: fnd_file.put_line(
1603: fnd_file.LOG,
1604: ' - ' || del_std_rec.party_number || ' - ' || del_std_rec.party_name);
1605: --
1606: lncount := lncount + 1;
1607: lvcpersonids := lvcpersonids || ',' || del_std_rec.student_person_id;

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 1686: fnd_file.put_line(

1682: );
1683: --
1684: -- Log that the selected advisor is assigned to the group.
1685: --
1686: fnd_file.put_line(
1687: fnd_file.LOG,
1688: ' ' || add_adv_rec.party_number || ' - ' || add_adv_rec.party_name);
1689: END LOOP;
1690: --

Line 1687: fnd_file.LOG,

1683: --
1684: -- Log that the selected advisor is assigned to the group.
1685: --
1686: fnd_file.put_line(
1687: fnd_file.LOG,
1688: ' ' || add_adv_rec.party_number || ' - ' || add_adv_rec.party_name);
1689: END LOOP;
1690: --
1691: -- Now we have all the student Ids.. concatenated. Lets strip the first comma and then send the notification.

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 1761: fnd_file.put_line(

1757: );
1758: --
1759: -- Log that the selected advisor is removed from the group.
1760: --
1761: fnd_file.put_line(
1762: fnd_file.LOG,
1763: ' ' || del_adv_rec.party_number || ' - ' || del_adv_rec.party_name);
1764: END LOOP;
1765: --

Line 1762: fnd_file.LOG,

1758: --
1759: -- Log that the selected advisor is removed from the group.
1760: --
1761: fnd_file.put_line(
1762: fnd_file.LOG,
1763: ' ' || del_adv_rec.party_number || ' - ' || del_adv_rec.party_name);
1764: END LOOP;
1765: --
1766: -- Now we have all the student Ids.. concatenated. Lets strip the first comma and then send the notification.