APPS.OTA_LP_NOTIFY_SS dependencies on FND_FILE

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

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

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

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

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

592: END LOOP;
593:
594: EXCEPTION
595: when others then
596: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc
597: ||','||SUBSTR(SQLERRM, 1, 500));
598: END send_lp_ct_notifications;
599:
600:

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

669: END LOOP;
670:
671: EXCEPTION
672: when others then
673: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc
674: ||','||SUBSTR(SQLERRM, 1, 500));
675: END send_lpm_ct_notifications;
676:
677: