APPS.OTA_LP_NOTIFY_SS dependencies on FND_FILE

Line 224: fnd_file.put_line(FND_FILE.LOG,'creator_person_id ' || l_creator_person_name);

220: IF l_lp_details.creator_person_id <> l_person_id THEN
221: OPEN csr_get_person_name(l_lp_details.creator_person_id);
222: FETCH csr_get_person_name INTO l_creator_person_name;
223: CLOSE csr_get_person_name;
224: fnd_file.put_line(FND_FILE.LOG,'creator_person_id ' || l_creator_person_name);
225: WF_ENGINE.setitemattrtext(l_item_type,l_item_key,'LP_CREATOR_NAME',l_creator_person_name);
226: END IF;
227:
228: ELSIF p_lp_notification_type IS NOT NULL THEN

Line 255: fnd_file.put_line(FND_FILE.LOG,'creator_person_id ' || l_creator_person_name);

251: IF l_lpm_details.creator_person_id <> l_person_id THEN
252: OPEN csr_get_person_name(l_lpm_details.creator_person_id);
253: FETCH csr_get_person_name INTO l_creator_person_name;
254: CLOSE csr_get_person_name;
255: fnd_file.put_line(FND_FILE.LOG,'creator_person_id ' || l_creator_person_name);
256: WF_ENGINE.setitemattrtext(l_item_type,l_item_key,'LP_CREATOR_NAME',l_creator_person_name);
257: END IF;
258:
259: IF p_lp_notification_type = 'LNR_CTG_LPM_REMINDER' OR p_lp_notification_type = 'MGR_CTG_LPM_REMINDER' THEN

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

571: END LOOP;
572:
573: EXCEPTION
574: when others then
575: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc
576: ||','||SUBSTR(SQLERRM, 1, 500));
577: END send_lp_ct_notifications;
578:
579:

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

648: END LOOP;
649:
650: EXCEPTION
651: when others then
652: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc
653: ||','||SUBSTR(SQLERRM, 1, 500));
654: END send_lpm_ct_notifications;
655:
656: