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.CN_NOTIFY_ORDERS dependencies on FND_FILE

Line 160: fnd_file.put_line(fnd_file.Log, 'notify: adjust: entering notify_line (lid = '||p_line_id||') ');

156:
157: BEGIN
158:
159: cn_message_pkg.debug('notify: adjust: entering notify_line (lid = '||p_line_id||') ');
160: fnd_file.put_line(fnd_file.Log, 'notify: adjust: entering notify_line (lid = '||p_line_id||') ');
161:
162: cn_process_audits_pkg.insert_row
163: ( l_rowid, l_proc_audit_id, NULL, 'NOT', 'Notification run',
164: NULL, NULL, NULL, NULL, NULL, SYSDATE, NULL, x_org_id);

Line 234: fnd_file.put_line(fnd_file.Log, 'notify: adjust: . notified');

230: NVL(oe_profile.value('OE_ORGANIZATION_ID',asoh.org_id),-99)
231: AND mtl.inventory_item_id = asol.inventory_item_id
232: AND mtl.invoiceable_item_flag = 'Y'); -- only want invoiceable items
233: cn_message_pkg.debug('notify: adjust: . notified');
234: fnd_file.put_line(fnd_file.Log, 'notify: adjust: . notified');
235: END IF;
236:
237: cn_message_pkg.debug('notify: adjust: exit from notify_line (lid = '||p_line_id||')');
238: fnd_file.put_line(fnd_file.Log, 'notify: adjust: exit from notify_line (lid = '||p_line_id||')');

Line 238: fnd_file.put_line(fnd_file.Log, 'notify: adjust: exit from notify_line (lid = '||p_line_id||')');

234: fnd_file.put_line(fnd_file.Log, 'notify: adjust: . notified');
235: END IF;
236:
237: cn_message_pkg.debug('notify: adjust: exit from notify_line (lid = '||p_line_id||')');
238: fnd_file.put_line(fnd_file.Log, 'notify: adjust: exit from notify_line (lid = '||p_line_id||')');
239: END notify_line;
240:
241:
242:

Line 275: fnd_file.put_line(fnd_file.Log, 'notify: adjust: entering notify_deleted_line (lid = '||p_line_id||')');

271:
272: BEGIN
273:
274: cn_message_pkg.debug('notify: adjust: entering notify_deleted_line (lid = '||p_line_id||')');
275: fnd_file.put_line(fnd_file.Log, 'notify: adjust: entering notify_deleted_line (lid = '||p_line_id||')');
276:
277:
278: l_org_id := p_org_id;
279:

Line 328: fnd_file.put_line(fnd_file.Log, 'notify: adjust: . notified');

324: asoh.header_id = p_header_id
325: AND asoh.booked_flag = 'Y'
326: AND asoh.org_id = l_org_id; -- only interested in status of booked
327: cn_message_pkg.debug('notify: adjust: . notified');
328: fnd_file.put_line(fnd_file.Log, 'notify: adjust: . notified');
329: END IF;
330:
331: cn_message_pkg.debug('exit from notify_deleted_line (lid = '||p_line_id||')');
332: fnd_file.put_line(fnd_file.Log, 'exit from notify_deleted_line (lid = '||p_line_id||')');

Line 332: fnd_file.put_line(fnd_file.Log, 'exit from notify_deleted_line (lid = '||p_line_id||')');

328: fnd_file.put_line(fnd_file.Log, 'notify: adjust: . notified');
329: END IF;
330:
331: cn_message_pkg.debug('exit from notify_deleted_line (lid = '||p_line_id||')');
332: fnd_file.put_line(fnd_file.Log, 'exit from notify_deleted_line (lid = '||p_line_id||')');
333: END notify_deleted_line;
334:
335: ---------------------------------------------------------------------------+
336: -- Procedure Name

Line 367: fnd_file.put_line(fnd_file.Log, 'notify: adjust: entering notify_affected_lines (lid = '||p_line_id||')');

363: BEGIN
364: l_org_id := p_org_id;
365:
366: cn_message_pkg.debug('notify: adjust: entering notify_affected_lines (lid = '||p_line_id||')');
367: fnd_file.put_line(fnd_file.Log, 'notify: adjust: entering notify_affected_lines (lid = '||p_line_id||')');
368:
369: cn_process_audits_pkg.insert_row
370: ( l_rowid, l_proc_audit_id, NULL, 'NOT', 'Notification run',
371: NULL, NULL, NULL, NULL, NULL, SYSDATE, NULL, p_org_id);

Line 385: fnd_file.put_line(fnd_file.Log, 'notify: adjust: . Header SC change');

381: -- these lines, which do not have their own sales credits, will
382: -- also be re-collected.
383: --+
384: cn_message_pkg.debug('notify: adjust: . Header SC change');
385: fnd_file.put_line(fnd_file.Log, 'notify: adjust: . Header SC change');
386: FOR rec IN
387: (SELECT line_id
388: FROM aso_i_oe_order_lines_v asol
389: WHERE asol.header_id = p_header_id

Line 407: fnd_file.put_line(fnd_file.Log, 'notify: adjust: . Line SC change');

403: -- This is a line sales credt, so re-collect the line and
404: -- check if any child lines are affected.
405: --+
406: cn_message_pkg.debug('notify: adjust: . Line SC change');
407: fnd_file.put_line(fnd_file.Log, 'notify: adjust: . Line SC change');
408: notify_line(p_header_id, p_line_id,x_org_id => l_org_id);
409: --+
410: -- Get some line information
411: --+

Line 423: fnd_file.put_line(fnd_file.Log, 'notify: adjust: .. Serv/Conf line');

419: IF l_line_rec.service_reference_line_id IS NOT NULL OR
420: (l_line_rec.top_model_line_id IS NOT NULL
421: AND p_line_id <> l_line_rec.top_model_line_id) THEN
422: cn_message_pkg.debug('notify: adjust: .. Serv/Conf line');
423: fnd_file.put_line(fnd_file.Log, 'notify: adjust: .. Serv/Conf line');
424: NULL;
425: --+
426: -- If this is a 'Standard' line then also re-collect any Service
427: -- Lines belonging to this line, which do not have their own

Line 434: fnd_file.put_line(fnd_file.Log, 'notify: adjust: .. Standard line');

430: --+
431: ELSIF l_line_rec.service_reference_line_id IS NULL
432: AND l_line_rec.top_model_line_id IS NULL THEN
433: cn_message_pkg.debug('notify: adjust: .. Standard line');
434: fnd_file.put_line(fnd_file.Log, 'notify: adjust: .. Standard line');
435: FOR rec IN
436: (SELECT header_id, line_id
437: FROM aso_i_oe_order_lines_v asol
438: WHERE asol.service_reference_line_id = p_line_id

Line 455: fnd_file.put_line(fnd_file.Log, 'notify: adjust: .. Top Model line');

451: -- Note: Configured Lines will be on same order
452: --+
453: ELSIF p_line_id = l_line_rec.top_model_line_id THEN
454: cn_message_pkg.debug('notify: adjust: .. Top Model line');
455: fnd_file.put_line(fnd_file.Log, 'notify: adjust: .. Top Model line');
456: FOR rec IN
457: (SELECT line_id
458: FROM aso_i_oe_order_lines_v asol
459: WHERE asol.top_model_line_id = p_line_id

Line 474: fnd_file.put_line(fnd_file.Log, 'notify: adjust: exit from notify_affected_lines (lid = '||p_line_id||')');

470: END IF;
471: END IF;
472:
473: cn_message_pkg.debug('notify: adjust: exit from notify_affected_lines (lid = '||p_line_id||')');
474: fnd_file.put_line(fnd_file.Log, 'notify: adjust: exit from notify_affected_lines (lid = '||p_line_id||')');
475: END notify_affected_lines;
476:
477: ------------------------------------------------------------------------------+
478: -- Procedure Name

Line 557: fnd_file.put_line(fnd_file.Log, 'notify: Got update information from Order Capture Feedback Queue for an adjusted order.');

553: x_process_type => 'ORD',
554: p_org_id => l_org_id);
555:
556: cn_message_pkg.debug('notify: Got update information from Order Capture Feedback Queue for an adjusted order.');
557: fnd_file.put_line(fnd_file.Log, 'notify: Got update information from Order Capture Feedback Queue for an adjusted order.');
558:
559: cn_message_pkg.debug('notify: Checking see if any changes have occured which are relevant to Sales Compensation.');
560: fnd_file.put_line(fnd_file.Log, 'notify: Checking see if any changes have occured which are relevant to Sales Compensation.');
561:

Line 560: fnd_file.put_line(fnd_file.Log, 'notify: Checking see if any changes have occured which are relevant to Sales Compensation.');

556: cn_message_pkg.debug('notify: Got update information from Order Capture Feedback Queue for an adjusted order.');
557: fnd_file.put_line(fnd_file.Log, 'notify: Got update information from Order Capture Feedback Queue for an adjusted order.');
558:
559: cn_message_pkg.debug('notify: Checking see if any changes have occured which are relevant to Sales Compensation.');
560: fnd_file.put_line(fnd_file.Log, 'notify: Checking see if any changes have occured which are relevant to Sales Compensation.');
561:
562: cn_message_pkg.debug('notify: Entering adjust_order (hid = '||p_header_id||') ');
563: fnd_file.put_line(fnd_file.Log, 'notify: Entering adjust_order (hid = '||p_header_id||') ');
564:

Line 563: fnd_file.put_line(fnd_file.Log, 'notify: Entering adjust_order (hid = '||p_header_id||') ');

559: cn_message_pkg.debug('notify: Checking see if any changes have occured which are relevant to Sales Compensation.');
560: fnd_file.put_line(fnd_file.Log, 'notify: Checking see if any changes have occured which are relevant to Sales Compensation.');
561:
562: cn_message_pkg.debug('notify: Entering adjust_order (hid = '||p_header_id||') ');
563: fnd_file.put_line(fnd_file.Log, 'notify: Entering adjust_order (hid = '||p_header_id||') ');
564:
565: -- Standard Start of API savepoint
566: SAVEPOINT Update_Headers;
567: -- Standard call to check for call compatibility.

Line 617: fnd_file.put_line(fnd_file.Log, 'notify: adjust: Deleted Lines? - Line_Tbl');

613: --+
614: -- Have any Lines been Deleted?
615: --+
616: cn_message_pkg.debug('notify: adjust: Deleted Lines? - Line_Tbl');
617: fnd_file.put_line(fnd_file.Log, 'notify: adjust: Deleted Lines? - Line_Tbl');
618: FOR i IN NVL(p_line_tbl.FIRST,1)..NVL(p_line_tbl.LAST,0) LOOP
619: cn_message_pkg.debug('notify: adjust: . lid = '|| p_line_tbl(i).line_id || ' operation = ' || Nvl(p_line_tbl(i).operation,'NULL'));
620: fnd_file.put_line(fnd_file.Log, 'notify: adjust: . lid = '|| p_line_tbl(i).line_id || ' operation = ' || Nvl(p_line_tbl(i).operation,'NULL'));
621: IF p_line_tbl(i).operation = 'DELETE' THEN

Line 620: fnd_file.put_line(fnd_file.Log, 'notify: adjust: . lid = '|| p_line_tbl(i).line_id || ' operation = ' || Nvl(p_line_tbl(i).operation,'NULL'));

616: cn_message_pkg.debug('notify: adjust: Deleted Lines? - Line_Tbl');
617: fnd_file.put_line(fnd_file.Log, 'notify: adjust: Deleted Lines? - Line_Tbl');
618: FOR i IN NVL(p_line_tbl.FIRST,1)..NVL(p_line_tbl.LAST,0) LOOP
619: cn_message_pkg.debug('notify: adjust: . lid = '|| p_line_tbl(i).line_id || ' operation = ' || Nvl(p_line_tbl(i).operation,'NULL'));
620: fnd_file.put_line(fnd_file.Log, 'notify: adjust: . lid = '|| p_line_tbl(i).line_id || ' operation = ' || Nvl(p_line_tbl(i).operation,'NULL'));
621: IF p_line_tbl(i).operation = 'DELETE' THEN
622: notify_deleted_line
623: (p_line_tbl(i).header_id,
624: p_line_tbl(i).line_id,

Line 635: fnd_file.put_line(fnd_file.Log, 'notify: adjust: Header Insert/Update?');

631: -- If so, collect (or re-collect) the entire Order
632: --+
633: IF NOT l_order_changed THEN
634: cn_message_pkg.debug('notify: adjust: Header Insert/Update?');
635: fnd_file.put_line(fnd_file.Log, 'notify: adjust: Header Insert/Update?');
636:
637: cn_message_pkg.debug('notify: adjust: . operation = '|| Nvl(p_header_rec.operation,'NULL'));
638: fnd_file.put_line(fnd_file.Log, 'notify: adjust: . operation = '|| Nvl(p_header_rec.operation,'NULL'));
639:

Line 638: fnd_file.put_line(fnd_file.Log, 'notify: adjust: . operation = '|| Nvl(p_header_rec.operation,'NULL'));

634: cn_message_pkg.debug('notify: adjust: Header Insert/Update?');
635: fnd_file.put_line(fnd_file.Log, 'notify: adjust: Header Insert/Update?');
636:
637: cn_message_pkg.debug('notify: adjust: . operation = '|| Nvl(p_header_rec.operation,'NULL'));
638: fnd_file.put_line(fnd_file.Log, 'notify: adjust: . operation = '|| Nvl(p_header_rec.operation,'NULL'));
639:
640: IF p_header_rec.operation = 'CREATE' THEN
641: l_order_changed := TRUE;
642: ELSIF p_header_rec.operation = 'UPDATE' THEN

Line 653: fnd_file.put_line(fnd_file.Log, 'notify: adjust: . update of interest');

649: unequal(p_header_rec.conversion_rate , p_old_header_rec.conversion_rate)
650: THEN
651: l_order_changed := TRUE;
652: cn_message_pkg.debug('notify: adjust: . update of interest');
653: fnd_file.put_line(fnd_file.Log, 'notify: adjust: . update of interest');
654: END IF;
655: END IF;
656: IF l_order_changed THEN
657: cn_message_pkg.debug('notify: adjust: . Calling Notify_Line for each line');

Line 658: fnd_file.put_line(fnd_file.Log, 'notify: adjust: . Calling Notify_Line for each line');

654: END IF;
655: END IF;
656: IF l_order_changed THEN
657: cn_message_pkg.debug('notify: adjust: . Calling Notify_Line for each line');
658: fnd_file.put_line(fnd_file.Log, 'notify: adjust: . Calling Notify_Line for each line');
659: FOR l_affected_line_rec IN c_affected_lines(p_header_id)
660: LOOP
661: cn_notify_orders.notify_line
662: (l_affected_line_rec.header_id,

Line 684: fnd_file.put_line(fnd_file.Log, 'notify: adjust: Line Insert/Update? - Line_Tbl');

680: -- Or has a relevant Line field been Updated?
681: --+
682: IF NOT l_order_changed THEN
683: cn_message_pkg.debug('notify: adjust: Line Insert/Update? - Line_Tbl');
684: fnd_file.put_line(fnd_file.Log, 'notify: adjust: Line Insert/Update? - Line_Tbl');
685:
686: -- Loop thru the 'new' table
687: <>
688: FOR i IN NVL(p_line_tbl.FIRST,1)..NVL(p_line_tbl.LAST,0) LOOP

Line 690: fnd_file.put_line(fnd_file.Log, 'notify: adjust: . lid = '||p_line_tbl(i).line_id||' operation = '|| Nvl(p_line_tbl(i).operation,'NULL'));

686: -- Loop thru the 'new' table
687: <>
688: FOR i IN NVL(p_line_tbl.FIRST,1)..NVL(p_line_tbl.LAST,0) LOOP
689: cn_message_pkg.debug('notify: adjust: . lid = '||p_line_tbl(i).line_id||' operation = '|| Nvl(p_line_tbl(i).operation,'NULL'));
690: fnd_file.put_line(fnd_file.Log, 'notify: adjust: . lid = '||p_line_tbl(i).line_id||' operation = '|| Nvl(p_line_tbl(i).operation,'NULL'));
691: --+
692: -- If operation CREATE, add notification for the line
693: --+
694: IF p_line_tbl(i).operation = 'CREATE' THEN

Line 737: fnd_file.put_line(fnd_file.Log, 'notify: adjust: . update of interest');

733: unequal(p_line_tbl(i).line_category_code , p_old_line_tbl(l_idx).line_category_code) OR
734: (p_line_tbl(i).operation='UPDATE' AND p_old_line_tbl(l_idx).operation ='CREATE') -- Added for Main Line Placeholder Bug 4665116
735: THEN
736: cn_message_pkg.debug('notify: adjust: . update of interest');
737: fnd_file.put_line(fnd_file.Log, 'notify: adjust: . update of interest');
738: cn_notify_orders.notify_line
739: (p_header_id, --p_line_tbl(i).header_id
740: p_line_tbl(i).line_id,x_org_id => l_org_id);
741: END IF;

Line 750: fnd_file.put_line(fnd_file.Log, 'notify: adjust: Header Sales Credit Deletion? - Header_Scredit_Tbl');

746: -- Have any Header Sales Credits been Deleted?
747: --+
748: IF NOT l_order_changed THEN
749: cn_message_pkg.debug('notify: adjust: Header Sales Credit Deletion? - Header_Scredit_Tbl');
750: fnd_file.put_line(fnd_file.Log, 'notify: adjust: Header Sales Credit Deletion? - Header_Scredit_Tbl');
751: FOR i IN NVL(p_header_scredit_tbl.FIRST,1)..NVL(p_header_scredit_tbl.LAST,0) LOOP
752: cn_message_pkg.debug('notify: adjust: . scid = '||p_header_scredit_tbl(i).sales_credit_id|| ' operation = '|| Nvl(p_header_scredit_tbl(i).operation,'NULL'));
753: fnd_file.put_line(fnd_file.Log, 'notify: adjust: . scid = '||p_header_scredit_tbl(i).sales_credit_id|| ' operation = '|| Nvl(p_header_scredit_tbl(i).operation,'NULL'));
754: IF p_header_scredit_tbl(i).operation = 'DELETE' THEN

Line 753: fnd_file.put_line(fnd_file.Log, 'notify: adjust: . scid = '||p_header_scredit_tbl(i).sales_credit_id|| ' operation = '|| Nvl(p_header_scredit_tbl(i).operation,'NULL'));

749: cn_message_pkg.debug('notify: adjust: Header Sales Credit Deletion? - Header_Scredit_Tbl');
750: fnd_file.put_line(fnd_file.Log, 'notify: adjust: Header Sales Credit Deletion? - Header_Scredit_Tbl');
751: FOR i IN NVL(p_header_scredit_tbl.FIRST,1)..NVL(p_header_scredit_tbl.LAST,0) LOOP
752: cn_message_pkg.debug('notify: adjust: . scid = '||p_header_scredit_tbl(i).sales_credit_id|| ' operation = '|| Nvl(p_header_scredit_tbl(i).operation,'NULL'));
753: fnd_file.put_line(fnd_file.Log, 'notify: adjust: . scid = '||p_header_scredit_tbl(i).sales_credit_id|| ' operation = '|| Nvl(p_header_scredit_tbl(i).operation,'NULL'));
754: IF p_header_scredit_tbl(i).operation = 'DELETE' THEN
755: cn_notify_orders.notify_affected_lines
756: (p_old_header_scredit_tbl(i).header_id,
757: p_old_header_scredit_tbl(i).line_id, p_org_id => l_org_id); -- this should be NULL

Line 767: fnd_file.put_line(fnd_file.Log, 'notify: adjust: Header Sales Credit Insert/Update? - Header_Scredit_Tbl');

763: -- Or has a relevant Sales Credit field been Updated?
764: --+
765: IF NOT l_order_changed THEN
766: cn_message_pkg.debug('notify: adjust: Header Sales Credit Insert/Update? - Header_Scredit_Tbl');
767: fnd_file.put_line(fnd_file.Log, 'notify: adjust: Header Sales Credit Insert/Update? - Header_Scredit_Tbl');
768: -- Loop thru the 'new' table
769: <>
770: FOR i IN NVL(p_header_scredit_tbl.FIRST,1)..NVL(p_header_scredit_tbl.LAST,0) LOOP
771: cn_message_pkg.debug('notify: adjust: . scid = '||p_header_scredit_tbl(i).sales_credit_id|| ' operation = '||Nvl(p_header_scredit_tbl(i).operation,'NULL'));

Line 772: fnd_file.put_line(fnd_file.Log, 'notify: adjust: . scid = '||p_header_scredit_tbl(i).sales_credit_id|| ' operation = '||Nvl(p_header_scredit_tbl(i).operation,'NULL'));

768: -- Loop thru the 'new' table
769: <>
770: FOR i IN NVL(p_header_scredit_tbl.FIRST,1)..NVL(p_header_scredit_tbl.LAST,0) LOOP
771: cn_message_pkg.debug('notify: adjust: . scid = '||p_header_scredit_tbl(i).sales_credit_id|| ' operation = '||Nvl(p_header_scredit_tbl(i).operation,'NULL'));
772: fnd_file.put_line(fnd_file.Log, 'notify: adjust: . scid = '||p_header_scredit_tbl(i).sales_credit_id|| ' operation = '||Nvl(p_header_scredit_tbl(i).operation,'NULL'));
773: --+
774: -- If we find an INSERT, flag the order changed and quit loop
775: --+
776: IF p_header_scredit_tbl(i).operation = 'CREATE' THEN

Line 812: fnd_file.put_line(fnd_file.Log, 'notify: adjust: . update of interest');

808: unequal(p_header_scredit_tbl(i).salesrep_id , p_old_header_scredit_tbl(l_idx).salesrep_id) OR
809: unequal(p_header_scredit_tbl(i).percent , p_old_header_scredit_tbl(l_idx).percent)
810: THEN
811: cn_message_pkg.debug('notify: adjust: . update of interest');
812: fnd_file.put_line(fnd_file.Log, 'notify: adjust: . update of interest');
813: cn_notify_orders.notify_affected_lines
814: (p_header_scredit_tbl(i).header_id,
815: p_header_scredit_tbl(i).line_id,p_org_id => l_org_id); -- this should be NULL
816: END IF;

Line 825: fnd_file.put_line(fnd_file.Log, 'notify: adjust: Line Sales Credit Deletion? - Line_Scredit_Tbl');

821: -- Have any Line Sales Credits been Deleted?
822: --+
823: IF NOT l_order_changed THEN
824: cn_message_pkg.debug('notify: adjust: Line Sales Credit Deletion? - Line_Scredit_Tbl');
825: fnd_file.put_line(fnd_file.Log, 'notify: adjust: Line Sales Credit Deletion? - Line_Scredit_Tbl');
826: FOR i IN NVL(p_line_scredit_tbl.FIRST,1)..NVL(p_line_scredit_tbl.LAST,0) LOOP
827: cn_message_pkg.debug('notify: adjust: . scid = '||p_line_scredit_tbl(i).sales_credit_id||' operation = '||Nvl(p_line_scredit_tbl(i).operation,'NULL'));
828: fnd_file.put_line(fnd_file.Log, 'notify: adjust: . scid = '||p_line_scredit_tbl(i).sales_credit_id||' operation = '||Nvl(p_line_scredit_tbl(i).operation,'NULL'));
829: IF p_line_scredit_tbl(i).operation = 'DELETE' THEN

Line 828: fnd_file.put_line(fnd_file.Log, 'notify: adjust: . scid = '||p_line_scredit_tbl(i).sales_credit_id||' operation = '||Nvl(p_line_scredit_tbl(i).operation,'NULL'));

824: cn_message_pkg.debug('notify: adjust: Line Sales Credit Deletion? - Line_Scredit_Tbl');
825: fnd_file.put_line(fnd_file.Log, 'notify: adjust: Line Sales Credit Deletion? - Line_Scredit_Tbl');
826: FOR i IN NVL(p_line_scredit_tbl.FIRST,1)..NVL(p_line_scredit_tbl.LAST,0) LOOP
827: cn_message_pkg.debug('notify: adjust: . scid = '||p_line_scredit_tbl(i).sales_credit_id||' operation = '||Nvl(p_line_scredit_tbl(i).operation,'NULL'));
828: fnd_file.put_line(fnd_file.Log, 'notify: adjust: . scid = '||p_line_scredit_tbl(i).sales_credit_id||' operation = '||Nvl(p_line_scredit_tbl(i).operation,'NULL'));
829: IF p_line_scredit_tbl(i).operation = 'DELETE' THEN
830: cn_notify_orders.notify_affected_lines
831: (p_old_line_scredit_tbl(i).header_id,
832: p_old_line_scredit_tbl(i).line_id,p_org_id => l_org_id);

Line 842: fnd_file.put_line(fnd_file.Log, 'notify: adjust: Line Sales Credit Insert/Update? - Line_Scredit_Tbl');

838: -- Or has a relevant Sales Credit field been Updated?
839: --+
840: IF NOT l_order_changed THEN
841: cn_message_pkg.debug('notify: adjust: Line Sales Credit Insert/Update? - Line_Scredit_Tbl');
842: fnd_file.put_line(fnd_file.Log, 'notify: adjust: Line Sales Credit Insert/Update? - Line_Scredit_Tbl');
843: -- Loop thru the 'new' table
844: <>
845: FOR i IN NVL(p_line_scredit_tbl.FIRST,1)..NVL(p_line_scredit_tbl.LAST,0) LOOP
846: cn_message_pkg.debug('notify: adjust: . scid = '||p_line_scredit_tbl(i).sales_credit_id||' operation = '||Nvl(p_line_scredit_tbl(i).operation,'NULL'));

Line 847: fnd_file.put_line(fnd_file.Log, 'notify: adjust: . scid = '||p_line_scredit_tbl(i).sales_credit_id||' operation = '||Nvl(p_line_scredit_tbl(i).operation,'NULL'));

843: -- Loop thru the 'new' table
844: <>
845: FOR i IN NVL(p_line_scredit_tbl.FIRST,1)..NVL(p_line_scredit_tbl.LAST,0) LOOP
846: cn_message_pkg.debug('notify: adjust: . scid = '||p_line_scredit_tbl(i).sales_credit_id||' operation = '||Nvl(p_line_scredit_tbl(i).operation,'NULL'));
847: fnd_file.put_line(fnd_file.Log, 'notify: adjust: . scid = '||p_line_scredit_tbl(i).sales_credit_id||' operation = '||Nvl(p_line_scredit_tbl(i).operation,'NULL'));
848: --+
849: -- If we find an INSERT, flag the order changed and quit loop
850: --+
851: IF p_line_scredit_tbl(i).operation = 'CREATE' THEN

Line 887: fnd_file.put_line(fnd_file.Log, 'notify: adjust: . update of interest');

883: unequal(p_line_scredit_tbl(i).salesrep_id , p_old_line_scredit_tbl(l_idx).salesrep_id) OR
884: unequal(p_line_scredit_tbl(i).percent , p_old_line_scredit_tbl(l_idx).percent)
885: THEN
886: cn_message_pkg.debug('notify: adjust: . update of interest');
887: fnd_file.put_line(fnd_file.Log, 'notify: adjust: . update of interest');
888: cn_notify_orders.notify_affected_lines
889: (p_line_scredit_tbl(i).header_id,
890: p_line_scredit_tbl(i).line_id,p_org_id => l_org_id);
891: END IF;

Line 896: fnd_file.put_line(fnd_file.Log, 'notify: Exit from adjust_order (hid = '||p_header_id||') ');

892: END IF;
893: END LOOP new_lsc_tbl_loop;
894: END IF;
895: cn_message_pkg.debug('notify: Exit from adjust_order (hid = '||p_header_id||') ');
896: fnd_file.put_line(fnd_file.Log, 'notify: Exit from adjust_order (hid = '||p_header_id||') ');
897:
898: cn_message_pkg.end_batch(l_process_audit_id);
899: -------------------+
900: -- End of API body.

Line 1089: fnd_file.put_line(fnd_file.Log, 'l_return_status = FND_API.G_RET_STS_SUCCESS.');

1085: -- ROLLBACK TO Update_Headers_Savepoint;
1086:
1087: -- hithanki:23-04-03:Changes for Enhancement#2778521:Start
1088: -- Enqueue the failed message into the Order Feedback Exception Queue
1089: fnd_file.put_line(fnd_file.Log, 'l_return_status = FND_API.G_RET_STS_SUCCESS.');
1090:
1091: aso_order_feedback_pub.handle_exception(
1092: p_api_version => 1.0
1093: ,p_init_msg_list => fnd_api.g_false

Line 1151: fnd_file.put_line(fnd_file.Log, '<>');

1147: x_process_type => 'ORD',
1148: p_org_id => x_org_id);
1149:
1150: cn_message_pkg.debug('<>');
1151: fnd_file.put_line(fnd_file.Log, '<>');
1152:
1153: cn_api.get_fnd_message(NULL,NULL);
1154: cn_message_pkg.end_batch (l_process_audit_id);
1155:

Line 1173: fnd_file.put_line(fnd_file.Log, 'l_header_rec.header_id <> FND_API.G_MISS_NUM'||l_header_rec.header_id);

1169: --+
1170:
1171: l_booked_flag := 'N';
1172: IF l_header_rec.header_id <> FND_API.G_MISS_NUM THEN
1173: fnd_file.put_line(fnd_file.Log, 'l_header_rec.header_id <> FND_API.G_MISS_NUM'||l_header_rec.header_id);
1174: l_booked_flag := l_header_rec.booked_flag;
1175: l_header_id := l_header_rec.header_id;
1176: ELSE
1177: l_header_id := FND_API.G_MISS_NUM;

Line 1178: fnd_file.put_line(fnd_file.Log, 'l_header_rec.header_id == FND_API.G_MISS_NUM'||l_header_rec.header_id);

1174: l_booked_flag := l_header_rec.booked_flag;
1175: l_header_id := l_header_rec.header_id;
1176: ELSE
1177: l_header_id := FND_API.G_MISS_NUM;
1178: fnd_file.put_line(fnd_file.Log, 'l_header_rec.header_id == FND_API.G_MISS_NUM'||l_header_rec.header_id);
1179: IF l_line_tbl.COUNT >0 THEN
1180: l_header_id := l_line_tbl(l_line_tbl.FIRST).header_id;
1181: ELSIF l_old_line_tbl.COUNT >0 THEN
1182: l_header_id := l_old_line_tbl(l_old_line_tbl.FIRST).header_id;

Line 1202: fnd_file.put_line(fnd_file.Log, 'Booked Flag value...'||l_booked_flag);

1198: --dbms_output.put_line('Get_Notice - processing header_id '||NVL(TO_CHAR(l_header_id),'null')||' Booked = '||l_booked_flag);
1199: --+
1200: -- If the order is booked, call Update_Headers to process my structure
1201: --+
1202: fnd_file.put_line(fnd_file.Log, 'Booked Flag value...'||l_booked_flag);
1203: fnd_file.put_line(fnd_file.Log, 'l_line_tbl.header_id...'||l_line_tbl.COUNT);
1204: fnd_file.put_line(fnd_file.Log, 'l_old_line_tbl.header_id...'||l_old_line_tbl.COUNT);
1205: fnd_file.put_line(fnd_file.Log, 'l_line_scredit_tbl.header_id...'||l_line_scredit_tbl.COUNT);
1206: fnd_file.put_line(fnd_file.Log, 'l_old_line_scredit_tbl.header_id...'||l_old_line_scredit_tbl.COUNT);

Line 1203: fnd_file.put_line(fnd_file.Log, 'l_line_tbl.header_id...'||l_line_tbl.COUNT);

1199: --+
1200: -- If the order is booked, call Update_Headers to process my structure
1201: --+
1202: fnd_file.put_line(fnd_file.Log, 'Booked Flag value...'||l_booked_flag);
1203: fnd_file.put_line(fnd_file.Log, 'l_line_tbl.header_id...'||l_line_tbl.COUNT);
1204: fnd_file.put_line(fnd_file.Log, 'l_old_line_tbl.header_id...'||l_old_line_tbl.COUNT);
1205: fnd_file.put_line(fnd_file.Log, 'l_line_scredit_tbl.header_id...'||l_line_scredit_tbl.COUNT);
1206: fnd_file.put_line(fnd_file.Log, 'l_old_line_scredit_tbl.header_id...'||l_old_line_scredit_tbl.COUNT);
1207: fnd_file.put_line(fnd_file.Log, 'l_header_scredit_tbl.header_id...'||l_header_scredit_tbl.COUNT);

Line 1204: fnd_file.put_line(fnd_file.Log, 'l_old_line_tbl.header_id...'||l_old_line_tbl.COUNT);

1200: -- If the order is booked, call Update_Headers to process my structure
1201: --+
1202: fnd_file.put_line(fnd_file.Log, 'Booked Flag value...'||l_booked_flag);
1203: fnd_file.put_line(fnd_file.Log, 'l_line_tbl.header_id...'||l_line_tbl.COUNT);
1204: fnd_file.put_line(fnd_file.Log, 'l_old_line_tbl.header_id...'||l_old_line_tbl.COUNT);
1205: fnd_file.put_line(fnd_file.Log, 'l_line_scredit_tbl.header_id...'||l_line_scredit_tbl.COUNT);
1206: fnd_file.put_line(fnd_file.Log, 'l_old_line_scredit_tbl.header_id...'||l_old_line_scredit_tbl.COUNT);
1207: fnd_file.put_line(fnd_file.Log, 'l_header_scredit_tbl.header_id...'||l_header_scredit_tbl.COUNT);
1208: fnd_file.put_line(fnd_file.Log, 'l_old_header_scredit_tbl.header_id...'||l_old_header_scredit_tbl.COUNT);

Line 1205: fnd_file.put_line(fnd_file.Log, 'l_line_scredit_tbl.header_id...'||l_line_scredit_tbl.COUNT);

1201: --+
1202: fnd_file.put_line(fnd_file.Log, 'Booked Flag value...'||l_booked_flag);
1203: fnd_file.put_line(fnd_file.Log, 'l_line_tbl.header_id...'||l_line_tbl.COUNT);
1204: fnd_file.put_line(fnd_file.Log, 'l_old_line_tbl.header_id...'||l_old_line_tbl.COUNT);
1205: fnd_file.put_line(fnd_file.Log, 'l_line_scredit_tbl.header_id...'||l_line_scredit_tbl.COUNT);
1206: fnd_file.put_line(fnd_file.Log, 'l_old_line_scredit_tbl.header_id...'||l_old_line_scredit_tbl.COUNT);
1207: fnd_file.put_line(fnd_file.Log, 'l_header_scredit_tbl.header_id...'||l_header_scredit_tbl.COUNT);
1208: fnd_file.put_line(fnd_file.Log, 'l_old_header_scredit_tbl.header_id...'||l_old_header_scredit_tbl.COUNT);
1209:

Line 1206: fnd_file.put_line(fnd_file.Log, 'l_old_line_scredit_tbl.header_id...'||l_old_line_scredit_tbl.COUNT);

1202: fnd_file.put_line(fnd_file.Log, 'Booked Flag value...'||l_booked_flag);
1203: fnd_file.put_line(fnd_file.Log, 'l_line_tbl.header_id...'||l_line_tbl.COUNT);
1204: fnd_file.put_line(fnd_file.Log, 'l_old_line_tbl.header_id...'||l_old_line_tbl.COUNT);
1205: fnd_file.put_line(fnd_file.Log, 'l_line_scredit_tbl.header_id...'||l_line_scredit_tbl.COUNT);
1206: fnd_file.put_line(fnd_file.Log, 'l_old_line_scredit_tbl.header_id...'||l_old_line_scredit_tbl.COUNT);
1207: fnd_file.put_line(fnd_file.Log, 'l_header_scredit_tbl.header_id...'||l_header_scredit_tbl.COUNT);
1208: fnd_file.put_line(fnd_file.Log, 'l_old_header_scredit_tbl.header_id...'||l_old_header_scredit_tbl.COUNT);
1209:
1210: IF l_booked_flag = 'Y' THEN

Line 1207: fnd_file.put_line(fnd_file.Log, 'l_header_scredit_tbl.header_id...'||l_header_scredit_tbl.COUNT);

1203: fnd_file.put_line(fnd_file.Log, 'l_line_tbl.header_id...'||l_line_tbl.COUNT);
1204: fnd_file.put_line(fnd_file.Log, 'l_old_line_tbl.header_id...'||l_old_line_tbl.COUNT);
1205: fnd_file.put_line(fnd_file.Log, 'l_line_scredit_tbl.header_id...'||l_line_scredit_tbl.COUNT);
1206: fnd_file.put_line(fnd_file.Log, 'l_old_line_scredit_tbl.header_id...'||l_old_line_scredit_tbl.COUNT);
1207: fnd_file.put_line(fnd_file.Log, 'l_header_scredit_tbl.header_id...'||l_header_scredit_tbl.COUNT);
1208: fnd_file.put_line(fnd_file.Log, 'l_old_header_scredit_tbl.header_id...'||l_old_header_scredit_tbl.COUNT);
1209:
1210: IF l_booked_flag = 'Y' THEN
1211: Adjust_Order

Line 1208: fnd_file.put_line(fnd_file.Log, 'l_old_header_scredit_tbl.header_id...'||l_old_header_scredit_tbl.COUNT);

1204: fnd_file.put_line(fnd_file.Log, 'l_old_line_tbl.header_id...'||l_old_line_tbl.COUNT);
1205: fnd_file.put_line(fnd_file.Log, 'l_line_scredit_tbl.header_id...'||l_line_scredit_tbl.COUNT);
1206: fnd_file.put_line(fnd_file.Log, 'l_old_line_scredit_tbl.header_id...'||l_old_line_scredit_tbl.COUNT);
1207: fnd_file.put_line(fnd_file.Log, 'l_header_scredit_tbl.header_id...'||l_header_scredit_tbl.COUNT);
1208: fnd_file.put_line(fnd_file.Log, 'l_old_header_scredit_tbl.header_id...'||l_old_header_scredit_tbl.COUNT);
1209:
1210: IF l_booked_flag = 'Y' THEN
1211: Adjust_Order
1212: (p_api_version => 1.0,

Line 1313: fnd_file.put_line(fnd_file.Log, 'notify: cn_notify_orders.regular_col_notify>>');

1309:
1310: cn_debug.print_msg('>>cn_notify_orders.regular_col_notify', 1);
1311:
1312: cn_message_pkg.debug('notify: cn_notify_orders.regular_col_notify>>');
1313: fnd_file.put_line(fnd_file.Log, 'notify: cn_notify_orders.regular_col_notify>>');
1314:
1315: --Added as per OM MOAC Mandate
1316: MO_GLOBAL.SET_POLICY_CONTEXT ('S', x_org_id);
1317: l_so_org_id := NVL(oe_profile.value('OE_ORGANIZATION_ID'),-99);

Line 1323: fnd_file.put_line(fnd_file.Log, 'notify: Get_Notice>>');

1319: --+
1320: -- Call Get_Notice to get any pending order updates off of the queue
1321: --+
1322: cn_message_pkg.debug('notify: Get_Notice>>');
1323: fnd_file.put_line(fnd_file.Log, 'notify: Get_Notice>>');
1324:
1325: cn_message_pkg.debug('notify: Getting any pending order updates off of the Order Capture Feedback Queue');
1326: fnd_file.put_line(fnd_file.Log, 'notify: Getting any pending order updates off of the Order Capture Feedback Queue');
1327:

Line 1326: fnd_file.put_line(fnd_file.Log, 'notify: Getting any pending order updates off of the Order Capture Feedback Queue');

1322: cn_message_pkg.debug('notify: Get_Notice>>');
1323: fnd_file.put_line(fnd_file.Log, 'notify: Get_Notice>>');
1324:
1325: cn_message_pkg.debug('notify: Getting any pending order updates off of the Order Capture Feedback Queue');
1326: fnd_file.put_line(fnd_file.Log, 'notify: Getting any pending order updates off of the Order Capture Feedback Queue');
1327:
1328: l_client_org_id := x_org_id;
1329:
1330: Get_Notice(p_parent_proc_audit_id => parent_proc_audit_id, x_org_id => l_client_org_id);

Line 1333: fnd_file.put_line(fnd_file.Log, 'notify: Get_Notice<<');

1329:
1330: Get_Notice(p_parent_proc_audit_id => parent_proc_audit_id, x_org_id => l_client_org_id);
1331:
1332: cn_message_pkg.debug('notify: Get_Notice<<');
1333: fnd_file.put_line(fnd_file.Log, 'notify: Get_Notice<<');
1334:
1335: l_proc_audit_id := NULL; -- Gets a value in the call below
1336:
1337: cn_process_audits_pkg.insert_row

Line 1348: fnd_file.put_line(fnd_file.Log, 'notify: Inserting records into CN_NOT_TRX from period '

1344: cn_message_pkg.debug
1345: ( 'notify: Inserting records into CN_NOT_TRX from period '
1346: || l_start_date ||' to period '|| l_end_date ||'.');
1347:
1348: fnd_file.put_line(fnd_file.Log, 'notify: Inserting records into CN_NOT_TRX from period '
1349: || l_start_date ||' to period '|| l_end_date ||'.');
1350:
1351: OPEN batch_size;
1352: FETCH batch_size INTO l_sys_batch_size;

Line 1428: fnd_file.put_line(fnd_file.Log, 'notify: No rows inserted into CN_NOT_TRX. Possible reason: Order transactions may have already been collected.');

1424:
1425: IF ( l_trx_count = 0 ) THEN
1426:
1427: cn_message_pkg.debug('notify: No rows inserted into CN_NOT_TRX. Possible reason: Order transactions may have already been collected.');
1428: fnd_file.put_line(fnd_file.Log, 'notify: No rows inserted into CN_NOT_TRX. Possible reason: Order transactions may have already been collected.');
1429:
1430: END IF;
1431:
1432: -- COMMIT; -- Commit now done by Order Capture notification process or by CN_COLLECT_ORDERS

Line 1435: fnd_file.put_line(fnd_file.Log, 'notify: Finished notification run: Notified ' || l_trx_count || ' orders.');

1431:
1432: -- COMMIT; -- Commit now done by Order Capture notification process or by CN_COLLECT_ORDERS
1433:
1434: cn_message_pkg.debug('notify: Finished notification run: Notified ' || l_trx_count || ' orders.');
1435: fnd_file.put_line(fnd_file.Log, 'notify: Finished notification run: Notified ' || l_trx_count || ' orders.');
1436:
1437: cn_debug.print_msg('cn_notify_orders.regular_col_notify<<', 1);
1438:
1439: cn_message_pkg.debug('notify: cn_notify_orders.regular_col_notify<<');

Line 1440: fnd_file.put_line(fnd_file.Log, 'notify: cn_notify_orders.regular_col_notify<<');

1436:
1437: cn_debug.print_msg('cn_notify_orders.regular_col_notify<<', 1);
1438:
1439: cn_message_pkg.debug('notify: cn_notify_orders.regular_col_notify<<');
1440: fnd_file.put_line(fnd_file.Log, 'notify: cn_notify_orders.regular_col_notify<<');
1441:
1442: cn_message_pkg.end_batch (l_proc_audit_id);
1443:
1444:

Line 1449: fnd_file.put_line(fnd_file.Log, 'notify_orders: in exception handler');

1445: EXCEPTION
1446: WHEN OTHERS THEN ROLLBACK;
1447:
1448: cn_message_pkg.debug('notify_orders: in exception handler');
1449: fnd_file.put_line(fnd_file.Log, 'notify_orders: in exception handler');
1450:
1451: cn_message_pkg.debug(SQLCODE||' '||SQLERRM);
1452: fnd_file.put_line(fnd_file.Log, SQLCODE||' '||SQLERRM);
1453:

Line 1452: fnd_file.put_line(fnd_file.Log, SQLCODE||' '||SQLERRM);

1448: cn_message_pkg.debug('notify_orders: in exception handler');
1449: fnd_file.put_line(fnd_file.Log, 'notify_orders: in exception handler');
1450:
1451: cn_message_pkg.debug(SQLCODE||' '||SQLERRM);
1452: fnd_file.put_line(fnd_file.Log, SQLCODE||' '||SQLERRM);
1453:
1454: cn_debug.print_msg('notify_orders: in exception handler', 1);
1455: cn_process_audits_pkg.update_row(l_proc_audit_id, NULL, SYSDATE, SQLCODE,
1456: SQLERRM);