DBA Data[Home] [Help]

APPS.OTA_INITIALIZATION_WF dependencies on FND_FILE

Line 1159: fnd_file.put_line(FND_FILE.LOG,'Event Fired ' ||p_event_fired);

1155:
1156:
1157: begin
1158: hr_utility.set_location('Entering:'||l_proc, 5);
1159: fnd_file.put_line(FND_FILE.LOG,'Event Fired ' ||p_event_fired);
1160:
1161: if p_event_fired ='CLASS_START' then
1162: --this code would be called when classbeginning notification has to be fired
1163: -- from API code on change of class dates

Line 1180: fnd_file.put_line(FND_FILE.LOG,'Event Id ' ||cls.event_id);

1176: else
1177:
1178: for cls in get_all_class_info
1179: Loop
1180: fnd_file.put_line(FND_FILE.LOG,'Event Id ' ||cls.event_id);
1181: for lrnr in get_all_wait_Learners(cls.event_id)
1182: loop
1183: fnd_file.put_line(FND_FILE.LOG,'Person Id ' ||lrnr.delegate_person_id);
1184: Initialize_wf(p_process => 'OTA_ENROLL_STATUS_CHNG_JSP_PRC',

Line 1183: fnd_file.put_line(FND_FILE.LOG,'Person Id ' ||lrnr.delegate_person_id);

1179: Loop
1180: fnd_file.put_line(FND_FILE.LOG,'Event Id ' ||cls.event_id);
1181: for lrnr in get_all_wait_Learners(cls.event_id)
1182: loop
1183: fnd_file.put_line(FND_FILE.LOG,'Person Id ' ||lrnr.delegate_person_id);
1184: Initialize_wf(p_process => 'OTA_ENROLL_STATUS_CHNG_JSP_PRC',
1185: p_item_type => 'OTWF',
1186: p_person_id => lrnr.delegate_person_id,
1187: p_eventid => cls.event_id,

Line 1199: fnd_file.put_line(FND_FILE.LOG,'Event Id ' ||cls.event_id);

1195: for trn in get_supp_res_id
1196: loop
1197: for cls in get_all_cls_info(trn.supplied_resource_id)
1198: Loop
1199: fnd_file.put_line(FND_FILE.LOG,'Event Id ' ||cls.event_id);
1200: fnd_file.put_line(FND_FILE.LOG,'Supplied Resource Id ' ||trn.supplied_resource_id);
1201: OTA_INITIALIZATION_WF.initialize_instructor_wf(
1202: p_item_type => 'OTWF',
1203: p_eventid => cls.event_id,

Line 1200: fnd_file.put_line(FND_FILE.LOG,'Supplied Resource Id ' ||trn.supplied_resource_id);

1196: loop
1197: for cls in get_all_cls_info(trn.supplied_resource_id)
1198: Loop
1199: fnd_file.put_line(FND_FILE.LOG,'Event Id ' ||cls.event_id);
1200: fnd_file.put_line(FND_FILE.LOG,'Supplied Resource Id ' ||trn.supplied_resource_id);
1201: OTA_INITIALIZATION_WF.initialize_instructor_wf(
1202: p_item_type => 'OTWF',
1203: p_eventid => cls.event_id,
1204: p_sup_res_id => trn.supplied_resource_id,

Line 1800: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc

1796: end if;
1797: hr_utility.set_location('Leaving:'||l_proc, 5);
1798: EXCEPTION
1799: when others then
1800: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc
1801: ||','||SUBSTR(SQLERRM, 1, 500));
1802: end process_cert_alert;
1803: --
1804: Procedure init_forum_notif(p_Forum_id in ota_forum_messages.forum_id%type,

Line 1902: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc

1898: ,p_item_type => 'OTWF'
1899: ,p_event_fired => 'CLASS_START');
1900: EXCEPTION
1901: when others then
1902: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc
1903: ||','||SUBSTR(SQLERRM, 1, 500));
1904: END send_event_beginning_ntf;
1905:
1906:

Line 1919: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc

1915: ,p_item_type => 'OTWF'
1916: ,p_event_fired => 'INSTRUCTOR_REMIND');
1917: EXCEPTION
1918: when others then
1919: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc
1920: ||','||SUBSTR(SQLERRM, 1, 500));
1921: END send_instructor_reminder_ntf;
1922:
1923: procedure init_course_eval_notif(p_booking_id OTA_DELEGATE_BOOKINGS.booking_id%type) is