DBA Data[Home] [Help]

APPS.MSD_ITEM_RELATIONSHIPS_PKG dependencies on FND_FILE

Line 73: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));

69: EXCEPTION
70: when others then
71: errbuf := substr(SQLERRM,1,150);
72: retcode := -1;
73: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
74: rollback;
75:
76: END collect_supersession_data;
77:

Line 157: fnd_file.put_line(fnd_file.log, 'Auto Refreshing Event: '|| l_event_name || ' Instance Id: '|| l_instance_id);

153:
154: FETCH auto_update_events_c1 INTO l_event_name;
155: EXIT WHEN auto_update_events_c1%NOTFOUND;
156:
157: fnd_file.put_line(fnd_file.log, 'Auto Refreshing Event: '|| l_event_name || ' Instance Id: '|| l_instance_id);
158:
159: msd_item_relationships_pkg.create_supersession_events (
160: errbuf => errbuf,
161: retcode => retcode,

Line 178: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));

174: EXCEPTION
175: when others then
176: errbuf := substr(SQLERRM,1,150);
177: retcode := -1;
178: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
179: rollback;
180:
181: END pull_supersession_data;
182:

Line 213: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));

209: EXCEPTION
210: when others then
211: errbuf := substr(SQLERRM,1,150);
212: retcode := -1;
213: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
214: rollback;
215:
216:
217: END delete_events_data;

Line 270: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));

266: EXCEPTION
267: when others then
268: errbuf := substr(SQLERRM,1,150);
269: retcode := -1;
270: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
271: rollback;
272:
273: END insert_event_products;
274:

Line 340: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));

336: EXCEPTION
337: when others then
338: errbuf := substr(SQLERRM,1,150);
339: retcode := -1;
340: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
341: rollback;
342:
343: END insert_evt_prod_relationships;
344:

Line 407: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));

403: EXCEPTION
404: when others then
405: errbuf := substr(SQLERRM,1,150);
406: retcode := -1;
407: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
408: rollback;
409:
410: END insert_evt_product_details;
411:

Line 449: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));

445: EXCEPTION
446: when others then
447: errbuf := substr(SQLERRM,1,150);
448: retcode := -1;
449: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
450:
451: END update_supersession_events;
452:
453:

Line 679: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));

675:
676: EXCEPTION
677: when others then
678: errbuf := substr(SQLERRM,1,150);
679: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
680: rollback;
681: /* Exit the process after an error happens */
682: exit;
683: end;

Line 691: fnd_file.put_line(fnd_file.log, 'Item relationship is in loop: '|| l_inventory_item_id);

687:
688: /* This exception for multiple looping */
689: EXCEPTION
690: when others then
691: fnd_file.put_line(fnd_file.log, 'Item relationship is in loop: '|| l_inventory_item_id);
692:
693: end;
694:
695: COMMIT;

Line 704: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));

700: EXCEPTION
701: when others then
702: errbuf := substr(SQLERRM,1,150);
703: retcode := -1;
704: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
705: rollback;
706:
707: END create_supersession_events;
708: