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 CN_NOTIFY_ORDERS

Line 1: PACKAGE BODY CN_NOTIFY_ORDERS AS

1: PACKAGE BODY CN_NOTIFY_ORDERS AS
2: -- $Header: cnnooeb.pls 120.10 2005/12/19 22:27:01 apink ship $
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_NOTIFY_ORDERS';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_NOTIFY_ORDERS';

1: PACKAGE BODY CN_NOTIFY_ORDERS AS
2: -- $Header: cnnooeb.pls 120.10 2005/12/19 22:27:01 apink ship $
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_NOTIFY_ORDERS';
6: G_SOURCE_DOC_TYPE CONSTANT VARCHAR2(2) := 'OC';
7:
8: --*********************************************
9: -- Private Procedures

Line 661: cn_notify_orders.notify_line

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,
663: l_affected_line_rec.line_id,
664: x_org_id => l_org_id);
665: -- Find any Service Lines for this line on other orders and

Line 671: cn_notify_orders.notify_line

667: FOR l_affected_service_line_rec IN c_affected_service_lines(
668: l_affected_line_rec.header_id,
669: l_affected_line_rec.line_id)
670: LOOP
671: cn_notify_orders.notify_line
672: (l_affected_service_line_rec.header_id,
673: l_affected_service_line_rec.line_id, x_org_id => l_org_id);
674: END LOOP;
675: END LOOP;

Line 695: cn_notify_orders.notify_line

691: --+
692: -- If operation CREATE, add notification for the line
693: --+
694: IF p_line_tbl(i).operation = 'CREATE' THEN
695: cn_notify_orders.notify_line
696: (p_line_tbl(i).header_id,
697: p_line_tbl(i).line_id, x_org_id => l_org_id);
698: --+
699: -- If we find an UPDATE, and any significant field has changed,

Line 738: cn_notify_orders.notify_line

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;
742: END IF;

Line 755: cn_notify_orders.notify_affected_lines

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
758: END IF;
759: END LOOP;

Line 777: cn_notify_orders.notify_affected_lines

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
777: cn_notify_orders.notify_affected_lines
778: (p_header_scredit_tbl(i).header_id,
779: p_header_scredit_tbl(i).line_id,p_org_id => l_org_id); -- this should be NULL
780: --+
781: -- If we find an UPDATE, and any significant field has changed,

Line 813: cn_notify_orders.notify_affected_lines

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;
817: END IF;

Line 830: cn_notify_orders.notify_affected_lines

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);
833: END IF;
834: END LOOP;

Line 852: cn_notify_orders.notify_affected_lines

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
852: cn_notify_orders.notify_affected_lines
853: (p_line_scredit_tbl(i).header_id,
854: p_line_scredit_tbl(i).line_id,p_org_id => l_org_id);
855: --+
856: -- If we find an UPDATE, and any significant field has changed,

Line 888: cn_notify_orders.notify_affected_lines

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;
892: END IF;

Line 1150: cn_message_pkg.debug('<>');

1146: x_request_id => fnd_global.conc_request_id,
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);

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 1310: cn_debug.print_msg('>>cn_notify_orders.regular_col_notify', 1);

1306: IF (debug_pipe IS NOT NULL) THEN
1307: cn_debug.init_pipe(debug_pipe, debug_level);
1308: END IF;
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:

Line 1312: cn_message_pkg.debug('notify: cn_notify_orders.regular_col_notify>>');

1308: END IF;
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);

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 1416: --dbms_output.put_line(' In CN_NOTIFY_ORDERS REGULAR_COL_NOTIFY ');

1412: AND org_id = l_client_org_id) ;
1413:
1414: l_trx_count := SQL%ROWCOUNT;
1415:
1416: --dbms_output.put_line(' In CN_NOTIFY_ORDERS REGULAR_COL_NOTIFY ');
1417: --dbms_output.put_line(' l_trx_count '||l_trx_count);
1418:
1419:
1420: cn_process_audits_pkg.update_row(l_proc_audit_id, NULL, SYSDATE, 0,

Line 1437: cn_debug.print_msg('cn_notify_orders.regular_col_notify<<', 1);

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<<');
1440: fnd_file.put_line(fnd_file.Log, 'notify: cn_notify_orders.regular_col_notify<<');
1441:

Line 1439: cn_message_pkg.debug('notify: cn_notify_orders.regular_col_notify<<');

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<<');
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:

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 1465: END CN_NOTIFY_ORDERS;

1461:
1462: END regular_col_notify;
1463:
1464:
1465: END CN_NOTIFY_ORDERS;
1466:
1467:
1468: