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.PO_PDOI_LINE_LOC_PROCESS_PVT dependencies on PO_LOG

Line 5: PO_LOG.get_package_base('PO_PDOI_LINE_LOC_PROCESS_PVT');

1: PACKAGE BODY PO_PDOI_LINE_LOC_PROCESS_PVT AS
2: /* $Header: PO_PDOI_LINE_LOC_PROCESS_PVT.plb 120.26.12010000.2 2008/08/04 08:38:50 rramasam ship $ */
3:
4: d_pkg_name CONSTANT VARCHAR2(50) :=
5: PO_LOG.get_package_base('PO_PDOI_LINE_LOC_PROCESS_PVT');
6:
7: --------------------------------------------------------------------------
8: ---------------------- PRIVATE PROCEDURES PROTOTYPE ----------------------
9: --------------------------------------------------------------------------

Line 169: IF (PO_LOG.d_proc) THEN

165:
166: BEGIN
167: d_position := 0;
168:
169: IF (PO_LOG.d_proc) THEN
170: PO_LOG.proc_begin(d_module, 'p_max_intf_line_loc_id', p_max_intf_line_loc_id);
171: END IF;
172:
173: OPEN x_line_locs_csr FOR

Line 170: PO_LOG.proc_begin(d_module, 'p_max_intf_line_loc_id', p_max_intf_line_loc_id);

166: BEGIN
167: d_position := 0;
168:
169: IF (PO_LOG.d_proc) THEN
170: PO_LOG.proc_begin(d_module, 'p_max_intf_line_loc_id', p_max_intf_line_loc_id);
171: END IF;
172:
173: OPEN x_line_locs_csr FOR
174: SELECT /*+ NO_INDEX(DRAFT_LINES PO_LINES_DRAFT_N0) */

Line 297: IF (PO_LOG.d_proc) THEN

293: AND NVL(intf_lines.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
294: <> PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED
295: ORDER BY 1;
296:
297: IF (PO_LOG.d_proc) THEN
298: PO_LOG.proc_end (d_module);
299: END IF;
300:
301: EXCEPTION

Line 298: PO_LOG.proc_end (d_module);

294: <> PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED
295: ORDER BY 1;
296:
297: IF (PO_LOG.d_proc) THEN
298: PO_LOG.proc_end (d_module);
299: END IF;
300:
301: EXCEPTION
302: WHEN OTHERS THEN

Line 339: IF (PO_LOG.d_proc) THEN

335:
336: BEGIN
337: d_position := 0;
338:
339: IF (PO_LOG.d_proc) THEN
340: PO_LOG.proc_begin(d_module);
341: END IF;
342:
343: FETCH x_line_locs_csr BULK COLLECT INTO

Line 340: PO_LOG.proc_begin(d_module);

336: BEGIN
337: d_position := 0;
338:
339: IF (PO_LOG.d_proc) THEN
340: PO_LOG.proc_begin(d_module);
341: END IF;
342:
343: FETCH x_line_locs_csr BULK COLLECT INTO
344: x_line_locs.intf_line_loc_id_tbl,

Line 448: IF (PO_LOG.d_proc) THEN

444: -- set initial value for error_flag
445: x_line_locs.error_flag_tbl
446: LIMIT PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE;
447:
448: IF (PO_LOG.d_proc) THEN
449: PO_LOG.proc_end (d_module);
450: END IF;
451:
452: EXCEPTION

Line 449: PO_LOG.proc_end (d_module);

445: x_line_locs.error_flag_tbl
446: LIMIT PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE;
447:
448: IF (PO_LOG.d_proc) THEN
449: PO_LOG.proc_end (d_module);
450: END IF;
451:
452: EXCEPTION
453: WHEN OTHERS THEN

Line 499: IF (PO_LOG.d_proc) THEN

495: l_index_tbl DBMS_SQL.NUMBER_TABLE;
496: BEGIN
497: d_position := 0;
498:
499: IF (PO_LOG.d_proc) THEN
500: PO_LOG.proc_begin(d_module, 'count', x_line_locs.rec_count);
501: END IF;
502:
503: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_DERIVE);

Line 500: PO_LOG.proc_begin(d_module, 'count', x_line_locs.rec_count);

496: BEGIN
497: d_position := 0;
498:
499: IF (PO_LOG.d_proc) THEN
500: PO_LOG.proc_begin(d_module, 'count', x_line_locs.rec_count);
501: END IF;
502:
503: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_DERIVE);
504:

Line 591: IF (PO_LOG.d_stmt) THEN

587:
588: -- handle derivation errors
589: FOR i IN 1..x_line_locs.rec_count
590: LOOP
591: IF (PO_LOG.d_stmt) THEN
592: PO_LOG.stmt(d_module, d_position, 'index', i);
593: END IF;
594:
595: -- check derivation error on ship_to_organziation_id

Line 592: PO_LOG.stmt(d_module, d_position, 'index', i);

588: -- handle derivation errors
589: FOR i IN 1..x_line_locs.rec_count
590: LOOP
591: IF (PO_LOG.d_stmt) THEN
592: PO_LOG.stmt(d_module, d_position, 'index', i);
593: END IF;
594:
595: -- check derivation error on ship_to_organziation_id
596: IF (x_line_locs.ship_to_org_code_tbl(i) IS NOT NULL AND

Line 598: IF (PO_LOG.d_stmt) THEN

594:
595: -- check derivation error on ship_to_organziation_id
596: IF (x_line_locs.ship_to_org_code_tbl(i) IS NOT NULL AND
597: x_line_locs.ship_to_org_id_tbl(i) IS NULL) THEN
598: IF (PO_LOG.d_stmt) THEN
599: PO_LOG.stmt(d_module, d_position, 'ship_to org id derivation failed');
600: PO_LOG.stmt(d_module, d_position, 'ship_to org', x_line_locs.ship_to_org_code_tbl(i));
601: END IF;
602:

Line 599: PO_LOG.stmt(d_module, d_position, 'ship_to org id derivation failed');

595: -- check derivation error on ship_to_organziation_id
596: IF (x_line_locs.ship_to_org_code_tbl(i) IS NOT NULL AND
597: x_line_locs.ship_to_org_id_tbl(i) IS NULL) THEN
598: IF (PO_LOG.d_stmt) THEN
599: PO_LOG.stmt(d_module, d_position, 'ship_to org id derivation failed');
600: PO_LOG.stmt(d_module, d_position, 'ship_to org', x_line_locs.ship_to_org_code_tbl(i));
601: END IF;
602:
603: PO_PDOI_ERR_UTL.add_fatal_error

Line 600: PO_LOG.stmt(d_module, d_position, 'ship_to org', x_line_locs.ship_to_org_code_tbl(i));

596: IF (x_line_locs.ship_to_org_code_tbl(i) IS NOT NULL AND
597: x_line_locs.ship_to_org_id_tbl(i) IS NULL) THEN
598: IF (PO_LOG.d_stmt) THEN
599: PO_LOG.stmt(d_module, d_position, 'ship_to org id derivation failed');
600: PO_LOG.stmt(d_module, d_position, 'ship_to org', x_line_locs.ship_to_org_code_tbl(i));
601: END IF;
602:
603: PO_PDOI_ERR_UTL.add_fatal_error
604: (

Line 626: IF (PO_LOG.d_stmt) THEN

622:
623: -- check derivation error for ship_to_location_id
624: IF (x_line_locs.ship_to_loc_tbl(i) IS NOT NULL AND
625: x_line_locs.ship_to_loc_id_tbl(i) IS NULL) THEN
626: IF (PO_LOG.d_stmt) THEN
627: PO_LOG.stmt(d_module, d_position, 'ship_to loc id derivation failed');
628: PO_LOG.stmt(d_module, d_position, 'ship_to loc', x_line_locs.ship_to_loc_tbl(i));
629: END IF;
630:

Line 627: PO_LOG.stmt(d_module, d_position, 'ship_to loc id derivation failed');

623: -- check derivation error for ship_to_location_id
624: IF (x_line_locs.ship_to_loc_tbl(i) IS NOT NULL AND
625: x_line_locs.ship_to_loc_id_tbl(i) IS NULL) THEN
626: IF (PO_LOG.d_stmt) THEN
627: PO_LOG.stmt(d_module, d_position, 'ship_to loc id derivation failed');
628: PO_LOG.stmt(d_module, d_position, 'ship_to loc', x_line_locs.ship_to_loc_tbl(i));
629: END IF;
630:
631: PO_PDOI_ERR_UTL.add_fatal_error

Line 628: PO_LOG.stmt(d_module, d_position, 'ship_to loc', x_line_locs.ship_to_loc_tbl(i));

624: IF (x_line_locs.ship_to_loc_tbl(i) IS NOT NULL AND
625: x_line_locs.ship_to_loc_id_tbl(i) IS NULL) THEN
626: IF (PO_LOG.d_stmt) THEN
627: PO_LOG.stmt(d_module, d_position, 'ship_to loc id derivation failed');
628: PO_LOG.stmt(d_module, d_position, 'ship_to loc', x_line_locs.ship_to_loc_tbl(i));
629: END IF;
630:
631: PO_PDOI_ERR_UTL.add_fatal_error
632: (

Line 654: IF (PO_LOG.d_stmt) THEN

650:
651: -- check derivation error for terms_id
652: IF (x_line_locs.payment_terms_tbl(i) IS NOT NULL AND
653: x_line_locs.terms_id_tbl(i) IS NULL) THEN
654: IF (PO_LOG.d_stmt) THEN
655: PO_LOG.stmt(d_module, d_position, 'terms id derivation failed');
656: PO_LOG.stmt(d_module, d_position, 'payment terms', x_line_locs.payment_terms_tbl(i));
657: END IF;
658:

Line 655: PO_LOG.stmt(d_module, d_position, 'terms id derivation failed');

651: -- check derivation error for terms_id
652: IF (x_line_locs.payment_terms_tbl(i) IS NOT NULL AND
653: x_line_locs.terms_id_tbl(i) IS NULL) THEN
654: IF (PO_LOG.d_stmt) THEN
655: PO_LOG.stmt(d_module, d_position, 'terms id derivation failed');
656: PO_LOG.stmt(d_module, d_position, 'payment terms', x_line_locs.payment_terms_tbl(i));
657: END IF;
658:
659: PO_PDOI_ERR_UTL.add_fatal_error

Line 656: PO_LOG.stmt(d_module, d_position, 'payment terms', x_line_locs.payment_terms_tbl(i));

652: IF (x_line_locs.payment_terms_tbl(i) IS NOT NULL AND
653: x_line_locs.terms_id_tbl(i) IS NULL) THEN
654: IF (PO_LOG.d_stmt) THEN
655: PO_LOG.stmt(d_module, d_position, 'terms id derivation failed');
656: PO_LOG.stmt(d_module, d_position, 'payment terms', x_line_locs.payment_terms_tbl(i));
657: END IF;
658:
659: PO_PDOI_ERR_UTL.add_fatal_error
660: (

Line 680: IF (PO_LOG.d_stmt) THEN

676:
677: -- check derivation error for receiving_routing_id
678: IF (x_line_locs.receiving_routing_tbl(i) IS NOT NULL AND
679: x_line_locs.receiving_routing_id_tbl(i) IS NULL) THEN
680: IF (PO_LOG.d_stmt) THEN
681: PO_LOG.stmt(d_module, d_position, 'routing id derivation failed');
682: PO_LOG.stmt(d_module, d_position, 'routing', x_line_locs.receiving_routing_tbl(i));
683: END IF;
684:

Line 681: PO_LOG.stmt(d_module, d_position, 'routing id derivation failed');

677: -- check derivation error for receiving_routing_id
678: IF (x_line_locs.receiving_routing_tbl(i) IS NOT NULL AND
679: x_line_locs.receiving_routing_id_tbl(i) IS NULL) THEN
680: IF (PO_LOG.d_stmt) THEN
681: PO_LOG.stmt(d_module, d_position, 'routing id derivation failed');
682: PO_LOG.stmt(d_module, d_position, 'routing', x_line_locs.receiving_routing_tbl(i));
683: END IF;
684:
685: PO_PDOI_ERR_UTL.add_fatal_error

Line 682: PO_LOG.stmt(d_module, d_position, 'routing', x_line_locs.receiving_routing_tbl(i));

678: IF (x_line_locs.receiving_routing_tbl(i) IS NOT NULL AND
679: x_line_locs.receiving_routing_id_tbl(i) IS NULL) THEN
680: IF (PO_LOG.d_stmt) THEN
681: PO_LOG.stmt(d_module, d_position, 'routing id derivation failed');
682: PO_LOG.stmt(d_module, d_position, 'routing', x_line_locs.receiving_routing_tbl(i));
683: END IF;
684:
685: PO_PDOI_ERR_UTL.add_fatal_error
686: (

Line 708: IF (PO_LOG.d_stmt) THEN

704: IF (PO_PDOI_PARAMS.g_request.document_type =
705: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
706: IF (x_line_locs.tax_code_id_tbl(i) IS NOT NULL AND
707: x_line_locs.tax_name_tbl(i) IS NULL) THEN
708: IF (PO_LOG.d_stmt) THEN
709: PO_LOG.stmt(d_module, d_position, 'tax name derivation failed');
710: PO_LOG.stmt(d_module, d_position, 'tax code id',
711: x_line_locs.tax_code_id_tbl(i));
712: END IF;

Line 709: PO_LOG.stmt(d_module, d_position, 'tax name derivation failed');

705: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
706: IF (x_line_locs.tax_code_id_tbl(i) IS NOT NULL AND
707: x_line_locs.tax_name_tbl(i) IS NULL) THEN
708: IF (PO_LOG.d_stmt) THEN
709: PO_LOG.stmt(d_module, d_position, 'tax name derivation failed');
710: PO_LOG.stmt(d_module, d_position, 'tax code id',
711: x_line_locs.tax_code_id_tbl(i));
712: END IF;
713:

Line 710: PO_LOG.stmt(d_module, d_position, 'tax code id',

706: IF (x_line_locs.tax_code_id_tbl(i) IS NOT NULL AND
707: x_line_locs.tax_name_tbl(i) IS NULL) THEN
708: IF (PO_LOG.d_stmt) THEN
709: PO_LOG.stmt(d_module, d_position, 'tax name derivation failed');
710: PO_LOG.stmt(d_module, d_position, 'tax code id',
711: x_line_locs.tax_code_id_tbl(i));
712: END IF;
713:
714: PO_PDOI_ERR_UTL.add_fatal_error

Line 736: IF (PO_LOG.d_proc) THEN

732: END LOOP;
733:
734: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_DERIVE);
735:
736: IF (PO_LOG.d_proc) THEN
737: PO_LOG.proc_end (d_module);
738: END IF;
739:
740: EXCEPTION

Line 737: PO_LOG.proc_end (d_module);

733:
734: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_DERIVE);
735:
736: IF (PO_LOG.d_proc) THEN
737: PO_LOG.proc_end (d_module);
738: END IF;
739:
740: EXCEPTION
741: WHEN OTHERS THEN

Line 781: IF (PO_LOG.d_proc) THEN

777: l_index_tbl DBMS_SQL.NUMBER_TABLE;
778: BEGIN
779: d_position := 0;
780:
781: IF (PO_LOG.d_proc) THEN
782: PO_LOG.proc_begin(d_module);
783: END IF;
784:
785: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_DEFAULT);

Line 782: PO_LOG.proc_begin(d_module);

778: BEGIN
779: d_position := 0;
780:
781: IF (PO_LOG.d_proc) THEN
782: PO_LOG.proc_begin(d_module);
783: END IF;
784:
785: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_DEFAULT);
786:

Line 851: IF (PO_LOG.d_proc) THEN

847: );
848:
849: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_DEFAULT);
850:
851: IF (PO_LOG.d_proc) THEN
852: PO_LOG.proc_end (d_module);
853: END IF;
854:
855: EXCEPTION

Line 852: PO_LOG.proc_end (d_module);

848:
849: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_DEFAULT);
850:
851: IF (PO_LOG.d_proc) THEN
852: PO_LOG.proc_end (d_module);
853: END IF;
854:
855: EXCEPTION
856: WHEN OTHERS THEN

Line 899: IF (PO_LOG.d_proc) THEN

895:
896: BEGIN
897: d_position := 0;
898:
899: IF (PO_LOG.d_proc) THEN
900: PO_LOG.proc_begin(d_module);
901: END IF;
902:
903: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_VALIDATE);

Line 900: PO_LOG.proc_begin(d_module);

896: BEGIN
897: d_position := 0;
898:
899: IF (PO_LOG.d_proc) THEN
900: PO_LOG.proc_begin(d_module);
901: END IF;
902:
903: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_VALIDATE);
904:

Line 988: IF (PO_LOG.d_stmt) THEN

984: d_position := 20;
985:
986: IF l_result_type = po_validations.c_result_type_failure THEN
987:
988: IF (PO_LOG.d_stmt) THEN
989: PO_LOG.stmt(d_module, d_position, 'vaidate line locs return failure');
990: END IF;
991:
992: PO_PDOI_ERR_UTL.process_val_type_errors

Line 989: PO_LOG.stmt(d_module, d_position, 'vaidate line locs return failure');

985:
986: IF l_result_type = po_validations.c_result_type_failure THEN
987:
988: IF (PO_LOG.d_stmt) THEN
989: PO_LOG.stmt(d_module, d_position, 'vaidate line locs return failure');
990: END IF;
991:
992: PO_PDOI_ERR_UTL.process_val_type_errors
993: (

Line 1009: IF (PO_LOG.d_stmt) THEN

1005: );
1006: END IF;
1007:
1008: IF l_result_type = po_validations.c_result_type_fatal THEN
1009: IF (PO_LOG.d_stmt) THEN
1010: PO_LOG.stmt(d_module, d_position, 'vaidate line locs return fatal');
1011: END IF;
1012:
1013: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1010: PO_LOG.stmt(d_module, d_position, 'vaidate line locs return fatal');

1006: END IF;
1007:
1008: IF l_result_type = po_validations.c_result_type_fatal THEN
1009: IF (PO_LOG.d_stmt) THEN
1010: PO_LOG.stmt(d_module, d_position, 'vaidate line locs return fatal');
1011: END IF;
1012:
1013: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1014: END IF;

Line 1018: IF (PO_LOG.d_proc) THEN

1014: END IF;
1015:
1016: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_VALIDATE);
1017:
1018: IF (PO_LOG.d_proc) THEN
1019: PO_LOG.proc_end (d_module);
1020: END IF;
1021:
1022: EXCEPTION

Line 1019: PO_LOG.proc_end (d_module);

1015:
1016: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_VALIDATE);
1017:
1018: IF (PO_LOG.d_proc) THEN
1019: PO_LOG.proc_end (d_module);
1020: END IF;
1021:
1022: EXCEPTION
1023: WHEN OTHERS THEN

Line 1067: IF (PO_LOG.d_proc) THEN

1063:
1064: BEGIN
1065: d_position := 0;
1066:
1067: IF (PO_LOG.d_proc) THEN
1068: PO_LOG.proc_begin(d_module, 'p_intf_line_loc_id_tbl', p_intf_line_loc_id_tbl);
1069: PO_LOG.proc_begin(d_module, 'p_line_loc_id_tbl', p_line_loc_id_tbl);
1070: PO_LOG.proc_begin(d_module, 'p_error_flag_tbl', p_error_flag_tbl);
1071: END IF;

Line 1068: PO_LOG.proc_begin(d_module, 'p_intf_line_loc_id_tbl', p_intf_line_loc_id_tbl);

1064: BEGIN
1065: d_position := 0;
1066:
1067: IF (PO_LOG.d_proc) THEN
1068: PO_LOG.proc_begin(d_module, 'p_intf_line_loc_id_tbl', p_intf_line_loc_id_tbl);
1069: PO_LOG.proc_begin(d_module, 'p_line_loc_id_tbl', p_line_loc_id_tbl);
1070: PO_LOG.proc_begin(d_module, 'p_error_flag_tbl', p_error_flag_tbl);
1071: END IF;
1072:

Line 1069: PO_LOG.proc_begin(d_module, 'p_line_loc_id_tbl', p_line_loc_id_tbl);

1065: d_position := 0;
1066:
1067: IF (PO_LOG.d_proc) THEN
1068: PO_LOG.proc_begin(d_module, 'p_intf_line_loc_id_tbl', p_intf_line_loc_id_tbl);
1069: PO_LOG.proc_begin(d_module, 'p_line_loc_id_tbl', p_line_loc_id_tbl);
1070: PO_LOG.proc_begin(d_module, 'p_error_flag_tbl', p_error_flag_tbl);
1071: END IF;
1072:
1073: -- update line_location_interface table with the new line_location_id

Line 1070: PO_LOG.proc_begin(d_module, 'p_error_flag_tbl', p_error_flag_tbl);

1066:
1067: IF (PO_LOG.d_proc) THEN
1068: PO_LOG.proc_begin(d_module, 'p_intf_line_loc_id_tbl', p_intf_line_loc_id_tbl);
1069: PO_LOG.proc_begin(d_module, 'p_line_loc_id_tbl', p_line_loc_id_tbl);
1070: PO_LOG.proc_begin(d_module, 'p_error_flag_tbl', p_error_flag_tbl);
1071: END IF;
1072:
1073: -- update line_location_interface table with the new line_location_id
1074: FORALL i IN 1..p_intf_line_loc_id_tbl.COUNT

Line 1081: IF (PO_LOG.d_proc) THEN

1077: process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_ACCEPTED
1078: WHERE interface_line_location_id = p_intf_line_loc_id_tbl(i)
1079: AND p_error_flag_tbl(i) = FND_API.g_FALSE;
1080:
1081: IF (PO_LOG.d_proc) THEN
1082: PO_LOG.proc_end (d_module);
1083: END IF;
1084:
1085: EXCEPTION

Line 1082: PO_LOG.proc_end (d_module);

1078: WHERE interface_line_location_id = p_intf_line_loc_id_tbl(i)
1079: AND p_error_flag_tbl(i) = FND_API.g_FALSE;
1080:
1081: IF (PO_LOG.d_proc) THEN
1082: PO_LOG.proc_end (d_module);
1083: END IF;
1084:
1085: EXCEPTION
1086: WHEN OTHERS THEN

Line 1126: IF (PO_LOG.d_proc) THEN

1122:
1123: BEGIN
1124: d_position := 0;
1125:
1126: IF (PO_LOG.d_proc) THEN
1127: PO_LOG.proc_begin(d_module);
1128: END IF;
1129:
1130: FORALL i IN 1..p_po_line_id_tbl.COUNT

Line 1127: PO_LOG.proc_begin(d_module);

1123: BEGIN
1124: d_position := 0;
1125:
1126: IF (PO_LOG.d_proc) THEN
1127: PO_LOG.proc_begin(d_module);
1128: END IF;
1129:
1130: FORALL i IN 1..p_po_line_id_tbl.COUNT
1131: UPDATE po_lines_draft_all draft_lines

Line 1140: IF (PO_LOG.d_proc) THEN

1136: AND draft_id = draft_lines.draft_id)
1137: WHERE po_line_id = p_po_line_id_tbl(i)
1138: AND draft_id = p_draft_id_tbl(i);
1139:
1140: IF (PO_LOG.d_proc) THEN
1141: PO_LOG.proc_end (d_module);
1142: END IF;
1143:
1144: EXCEPTION

Line 1141: PO_LOG.proc_end (d_module);

1137: WHERE po_line_id = p_po_line_id_tbl(i)
1138: AND draft_id = p_draft_id_tbl(i);
1139:
1140: IF (PO_LOG.d_proc) THEN
1141: PO_LOG.proc_end (d_module);
1142: END IF;
1143:
1144: EXCEPTION
1145: WHEN OTHERS THEN

Line 1193: IF (PO_LOG.d_proc) THEN

1189: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
1190: BEGIN
1191: d_position := 0;
1192:
1193: IF (PO_LOG.d_proc) THEN
1194: PO_LOG.proc_begin(d_module);
1195: END IF;
1196:
1197: l_key := PO_CORE_S.get_session_gt_nextval;

Line 1194: PO_LOG.proc_begin(d_module);

1190: BEGIN
1191: d_position := 0;
1192:
1193: IF (PO_LOG.d_proc) THEN
1194: PO_LOG.proc_begin(d_module);
1195: END IF;
1196:
1197: l_key := PO_CORE_S.get_session_gt_nextval;
1198:

Line 1228: IF (PO_LOG.d_proc) THEN

1224: p_delete_flag_tbl => l_delete_flag_tbl,
1225: x_record_already_exist_tbl => l_record_already_exist_tbl
1226: );
1227:
1228: IF (PO_LOG.d_proc) THEN
1229: PO_LOG.proc_end (d_module);
1230: END IF;
1231:
1232: EXCEPTION

Line 1229: PO_LOG.proc_end (d_module);

1225: x_record_already_exist_tbl => l_record_already_exist_tbl
1226: );
1227:
1228: IF (PO_LOG.d_proc) THEN
1229: PO_LOG.proc_end (d_module);
1230: END IF;
1231:
1232: EXCEPTION
1233: WHEN OTHERS THEN

Line 1288: IF (PO_LOG.d_proc) THEN

1284: l_result_tbl PO_TBL_NUMBER;
1285: BEGIN
1286: d_position := 0;
1287:
1288: IF (PO_LOG.d_proc) THEN
1289: PO_LOG.proc_begin(d_module, 'p_po_line_id_tbl', p_po_line_id_tbl);
1290: PO_LOG.proc_begin(d_module, 'p_shipment_num_tbl', p_shipment_num_tbl);
1291: PO_LOG.proc_begin(d_module, 'x_line_loc_id_tbl', x_line_loc_id_tbl);
1292: END IF;

Line 1289: PO_LOG.proc_begin(d_module, 'p_po_line_id_tbl', p_po_line_id_tbl);

1285: BEGIN
1286: d_position := 0;
1287:
1288: IF (PO_LOG.d_proc) THEN
1289: PO_LOG.proc_begin(d_module, 'p_po_line_id_tbl', p_po_line_id_tbl);
1290: PO_LOG.proc_begin(d_module, 'p_shipment_num_tbl', p_shipment_num_tbl);
1291: PO_LOG.proc_begin(d_module, 'x_line_loc_id_tbl', x_line_loc_id_tbl);
1292: END IF;
1293:

Line 1290: PO_LOG.proc_begin(d_module, 'p_shipment_num_tbl', p_shipment_num_tbl);

1286: d_position := 0;
1287:
1288: IF (PO_LOG.d_proc) THEN
1289: PO_LOG.proc_begin(d_module, 'p_po_line_id_tbl', p_po_line_id_tbl);
1290: PO_LOG.proc_begin(d_module, 'p_shipment_num_tbl', p_shipment_num_tbl);
1291: PO_LOG.proc_begin(d_module, 'x_line_loc_id_tbl', x_line_loc_id_tbl);
1292: END IF;
1293:
1294: -- run query to extract line_location_id

Line 1291: PO_LOG.proc_begin(d_module, 'x_line_loc_id_tbl', x_line_loc_id_tbl);

1287:
1288: IF (PO_LOG.d_proc) THEN
1289: PO_LOG.proc_begin(d_module, 'p_po_line_id_tbl', p_po_line_id_tbl);
1290: PO_LOG.proc_begin(d_module, 'p_shipment_num_tbl', p_shipment_num_tbl);
1291: PO_LOG.proc_begin(d_module, 'x_line_loc_id_tbl', x_line_loc_id_tbl);
1292: END IF;
1293:
1294: -- run query to extract line_location_id
1295: FORALL i IN 1..p_index_tbl.COUNT

Line 1319: IF (PO_LOG.d_stmt) THEN

1315:
1316: -- push the result back to x_line_loc_id_tbl
1317: FOR i IN 1..l_index_tbl.COUNT
1318: LOOP
1319: IF (PO_LOG.d_stmt) THEN
1320: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
1321: PO_LOG.stmt(d_module, d_position, 'new line loc id', l_result_tbl(i));
1322: END IF;
1323:

Line 1320: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));

1316: -- push the result back to x_line_loc_id_tbl
1317: FOR i IN 1..l_index_tbl.COUNT
1318: LOOP
1319: IF (PO_LOG.d_stmt) THEN
1320: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
1321: PO_LOG.stmt(d_module, d_position, 'new line loc id', l_result_tbl(i));
1322: END IF;
1323:
1324: x_line_loc_id_tbl(l_index_tbl(i)) := l_result_tbl(i);

Line 1321: PO_LOG.stmt(d_module, d_position, 'new line loc id', l_result_tbl(i));

1317: FOR i IN 1..l_index_tbl.COUNT
1318: LOOP
1319: IF (PO_LOG.d_stmt) THEN
1320: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
1321: PO_LOG.stmt(d_module, d_position, 'new line loc id', l_result_tbl(i));
1322: END IF;
1323:
1324: x_line_loc_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
1325: END LOOP;

Line 1327: IF (PO_LOG.d_proc) THEN

1323:
1324: x_line_loc_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
1325: END LOOP;
1326:
1327: IF (PO_LOG.d_proc) THEN
1328: PO_LOG.proc_end (d_module);
1329: END IF;
1330:
1331: EXCEPTION

Line 1328: PO_LOG.proc_end (d_module);

1324: x_line_loc_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
1325: END LOOP;
1326:
1327: IF (PO_LOG.d_proc) THEN
1328: PO_LOG.proc_end (d_module);
1329: END IF;
1330:
1331: EXCEPTION
1332: WHEN OTHERS THEN

Line 1380: IF (PO_LOG.d_proc) THEN

1376: l_result_tbl PO_TBL_NUMBER;
1377: BEGIN
1378: d_position := 0;
1379:
1380: IF (PO_LOG.d_proc) THEN
1381: PO_LOG.proc_begin(d_module, 'p_ship_to_org_code_tbl', p_ship_to_org_code_tbl);
1382: PO_LOG.proc_begin(d_module, 'x_ship_to_org_id_tbl', x_ship_to_org_id_tbl);
1383: END IF;
1384:

Line 1381: PO_LOG.proc_begin(d_module, 'p_ship_to_org_code_tbl', p_ship_to_org_code_tbl);

1377: BEGIN
1378: d_position := 0;
1379:
1380: IF (PO_LOG.d_proc) THEN
1381: PO_LOG.proc_begin(d_module, 'p_ship_to_org_code_tbl', p_ship_to_org_code_tbl);
1382: PO_LOG.proc_begin(d_module, 'x_ship_to_org_id_tbl', x_ship_to_org_id_tbl);
1383: END IF;
1384:
1385: -- execute query to extract org_id from org_code

Line 1382: PO_LOG.proc_begin(d_module, 'x_ship_to_org_id_tbl', x_ship_to_org_id_tbl);

1378: d_position := 0;
1379:
1380: IF (PO_LOG.d_proc) THEN
1381: PO_LOG.proc_begin(d_module, 'p_ship_to_org_code_tbl', p_ship_to_org_code_tbl);
1382: PO_LOG.proc_begin(d_module, 'x_ship_to_org_id_tbl', x_ship_to_org_id_tbl);
1383: END IF;
1384:
1385: -- execute query to extract org_id from org_code
1386: FORALL i IN 1.. p_index_tbl.COUNT

Line 1410: IF (PO_LOG.d_stmt) THEN

1406:
1407: -- set derived result in x_ship_to_org_id_tbl
1408: FOR i IN 1..l_index_tbl.COUNT
1409: LOOP
1410: IF (PO_LOG.d_stmt) THEN
1411: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
1412: PO_LOG.stmt(d_module, d_position, 'new ship_to org id', l_result_tbl(i));
1413: END IF;
1414:

Line 1411: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));

1407: -- set derived result in x_ship_to_org_id_tbl
1408: FOR i IN 1..l_index_tbl.COUNT
1409: LOOP
1410: IF (PO_LOG.d_stmt) THEN
1411: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
1412: PO_LOG.stmt(d_module, d_position, 'new ship_to org id', l_result_tbl(i));
1413: END IF;
1414:
1415: x_ship_to_org_id_tbl(l_index_tbl(i)) := l_result_tbl(i);

Line 1412: PO_LOG.stmt(d_module, d_position, 'new ship_to org id', l_result_tbl(i));

1408: FOR i IN 1..l_index_tbl.COUNT
1409: LOOP
1410: IF (PO_LOG.d_stmt) THEN
1411: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
1412: PO_LOG.stmt(d_module, d_position, 'new ship_to org id', l_result_tbl(i));
1413: END IF;
1414:
1415: x_ship_to_org_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
1416: END LOOP;

Line 1418: IF (PO_LOG.d_proc) THEN

1414:
1415: x_ship_to_org_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
1416: END LOOP;
1417:
1418: IF (PO_LOG.d_proc) THEN
1419: PO_LOG.proc_end (d_module);
1420: END IF;
1421:
1422: EXCEPTION

Line 1419: PO_LOG.proc_end (d_module);

1415: x_ship_to_org_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
1416: END LOOP;
1417:
1418: IF (PO_LOG.d_proc) THEN
1419: PO_LOG.proc_end (d_module);
1420: END IF;
1421:
1422: EXCEPTION
1423: WHEN OTHERS THEN

Line 1471: IF (PO_LOG.d_proc) THEN

1467: l_result_tbl PO_TBL_NUMBER;
1468: BEGIN
1469: d_position := 0;
1470:
1471: IF (PO_LOG.d_proc) THEN
1472: PO_LOG.proc_begin(d_module, 'p_receiving_routing_tbl',
1473: p_receiving_routing_tbl);
1474: PO_LOG.proc_begin(d_module, 'x_receiving_routing_id_tbl',
1475: x_receiving_routing_id_tbl);

Line 1472: PO_LOG.proc_begin(d_module, 'p_receiving_routing_tbl',

1468: BEGIN
1469: d_position := 0;
1470:
1471: IF (PO_LOG.d_proc) THEN
1472: PO_LOG.proc_begin(d_module, 'p_receiving_routing_tbl',
1473: p_receiving_routing_tbl);
1474: PO_LOG.proc_begin(d_module, 'x_receiving_routing_id_tbl',
1475: x_receiving_routing_id_tbl);
1476: END IF;

Line 1474: PO_LOG.proc_begin(d_module, 'x_receiving_routing_id_tbl',

1470:
1471: IF (PO_LOG.d_proc) THEN
1472: PO_LOG.proc_begin(d_module, 'p_receiving_routing_tbl',
1473: p_receiving_routing_tbl);
1474: PO_LOG.proc_begin(d_module, 'x_receiving_routing_id_tbl',
1475: x_receiving_routing_id_tbl);
1476: END IF;
1477:
1478: -- execute query to extract routing_id from receiving_routings

Line 1501: IF (PO_LOG.d_stmt) THEN

1497:
1498: -- set derived result in x_receiving_routing_id_tbl
1499: FOR i IN 1..l_index_tbl.COUNT
1500: LOOP
1501: IF (PO_LOG.d_stmt) THEN
1502: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
1503: PO_LOG.stmt(d_module, d_position, 'new routing id', l_result_tbl(i));
1504: END IF;
1505:

Line 1502: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));

1498: -- set derived result in x_receiving_routing_id_tbl
1499: FOR i IN 1..l_index_tbl.COUNT
1500: LOOP
1501: IF (PO_LOG.d_stmt) THEN
1502: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
1503: PO_LOG.stmt(d_module, d_position, 'new routing id', l_result_tbl(i));
1504: END IF;
1505:
1506: x_receiving_routing_id_tbl(l_index_tbl(i)) := l_result_tbl(i);

Line 1503: PO_LOG.stmt(d_module, d_position, 'new routing id', l_result_tbl(i));

1499: FOR i IN 1..l_index_tbl.COUNT
1500: LOOP
1501: IF (PO_LOG.d_stmt) THEN
1502: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
1503: PO_LOG.stmt(d_module, d_position, 'new routing id', l_result_tbl(i));
1504: END IF;
1505:
1506: x_receiving_routing_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
1507: END LOOP;

Line 1509: IF (PO_LOG.d_proc) THEN

1505:
1506: x_receiving_routing_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
1507: END LOOP;
1508:
1509: IF (PO_LOG.d_proc) THEN
1510: PO_LOG.proc_end (d_module);
1511: END IF;
1512:
1513: EXCEPTION

Line 1510: PO_LOG.proc_end (d_module);

1506: x_receiving_routing_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
1507: END LOOP;
1508:
1509: IF (PO_LOG.d_proc) THEN
1510: PO_LOG.proc_end (d_module);
1511: END IF;
1512:
1513: EXCEPTION
1514: WHEN OTHERS THEN

Line 1562: IF (PO_LOG.d_proc) THEN

1558: l_result_tbl PO_TBL_VARCHAR30;
1559: BEGIN
1560: d_position := 0;
1561:
1562: IF (PO_LOG.d_proc) THEN
1563: PO_LOG.proc_begin(d_module, 'p_tax_code_id_tbl',
1564: p_tax_code_id_tbl);
1565: PO_LOG.proc_begin(d_module, 'x_tax_name_tbl',
1566: x_tax_name_tbl);

Line 1563: PO_LOG.proc_begin(d_module, 'p_tax_code_id_tbl',

1559: BEGIN
1560: d_position := 0;
1561:
1562: IF (PO_LOG.d_proc) THEN
1563: PO_LOG.proc_begin(d_module, 'p_tax_code_id_tbl',
1564: p_tax_code_id_tbl);
1565: PO_LOG.proc_begin(d_module, 'x_tax_name_tbl',
1566: x_tax_name_tbl);
1567: END IF;

Line 1565: PO_LOG.proc_begin(d_module, 'x_tax_name_tbl',

1561:
1562: IF (PO_LOG.d_proc) THEN
1563: PO_LOG.proc_begin(d_module, 'p_tax_code_id_tbl',
1564: p_tax_code_id_tbl);
1565: PO_LOG.proc_begin(d_module, 'x_tax_name_tbl',
1566: x_tax_name_tbl);
1567: END IF;
1568:
1569: -- execute query to extract tax_name from tax_code_id

Line 1595: IF (PO_LOG.d_stmt) THEN

1591:
1592: -- set derived result in x_receiving_routing_id_tbl
1593: FOR i IN 1..l_index_tbl.COUNT
1594: LOOP
1595: IF (PO_LOG.d_stmt) THEN
1596: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
1597: PO_LOG.stmt(d_module, d_position, 'new tax_name', l_result_tbl(i));
1598: END IF;
1599:

Line 1596: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));

1592: -- set derived result in x_receiving_routing_id_tbl
1593: FOR i IN 1..l_index_tbl.COUNT
1594: LOOP
1595: IF (PO_LOG.d_stmt) THEN
1596: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
1597: PO_LOG.stmt(d_module, d_position, 'new tax_name', l_result_tbl(i));
1598: END IF;
1599:
1600: x_tax_name_tbl(l_index_tbl(i)) := l_result_tbl(i);

Line 1597: PO_LOG.stmt(d_module, d_position, 'new tax_name', l_result_tbl(i));

1593: FOR i IN 1..l_index_tbl.COUNT
1594: LOOP
1595: IF (PO_LOG.d_stmt) THEN
1596: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
1597: PO_LOG.stmt(d_module, d_position, 'new tax_name', l_result_tbl(i));
1598: END IF;
1599:
1600: x_tax_name_tbl(l_index_tbl(i)) := l_result_tbl(i);
1601: END LOOP;

Line 1603: IF (PO_LOG.d_proc) THEN

1599:
1600: x_tax_name_tbl(l_index_tbl(i)) := l_result_tbl(i);
1601: END LOOP;
1602:
1603: IF (PO_LOG.d_proc) THEN
1604: PO_LOG.proc_end (d_module);
1605: END IF;
1606:
1607: EXCEPTION

Line 1604: PO_LOG.proc_end (d_module);

1600: x_tax_name_tbl(l_index_tbl(i)) := l_result_tbl(i);
1601: END LOOP;
1602:
1603: IF (PO_LOG.d_proc) THEN
1604: PO_LOG.proc_end (d_module);
1605: END IF;
1606:
1607: EXCEPTION
1608: WHEN OTHERS THEN

Line 1651: IF (PO_LOG.d_proc) THEN

1647: l_result_tbl PO_TBL_NUMBER;
1648: BEGIN
1649: d_position := 0;
1650:
1651: IF (PO_LOG.d_proc) THEN
1652: PO_LOG.proc_begin(d_module, 'p_item_id_tbl', p_item_id_tbl);
1653: PO_LOG.proc_begin(d_module, 'p_ship_to_organization_id_tbl', p_ship_to_organization_id_tbl);
1654: END IF;
1655:

Line 1652: PO_LOG.proc_begin(d_module, 'p_item_id_tbl', p_item_id_tbl);

1648: BEGIN
1649: d_position := 0;
1650:
1651: IF (PO_LOG.d_proc) THEN
1652: PO_LOG.proc_begin(d_module, 'p_item_id_tbl', p_item_id_tbl);
1653: PO_LOG.proc_begin(d_module, 'p_ship_to_organization_id_tbl', p_ship_to_organization_id_tbl);
1654: END IF;
1655:
1656: FOR i IN 1..p_item_id_tbl.COUNT LOOP

Line 1653: PO_LOG.proc_begin(d_module, 'p_ship_to_organization_id_tbl', p_ship_to_organization_id_tbl);

1649: d_position := 0;
1650:
1651: IF (PO_LOG.d_proc) THEN
1652: PO_LOG.proc_begin(d_module, 'p_item_id_tbl', p_item_id_tbl);
1653: PO_LOG.proc_begin(d_module, 'p_ship_to_organization_id_tbl', p_ship_to_organization_id_tbl);
1654: END IF;
1655:
1656: FOR i IN 1..p_item_id_tbl.COUNT LOOP
1657: x_outsourced_assembly_tbl(i) :=

Line 1664: IF (PO_LOG.d_proc) THEN

1660: p_ship_to_org_id => p_ship_to_organization_id_tbl(i)
1661: );
1662: END LOOP;
1663:
1664: IF (PO_LOG.d_proc) THEN
1665: PO_LOG.proc_end (d_module);
1666: END IF;
1667:
1668: EXCEPTION

Line 1665: PO_LOG.proc_end (d_module);

1661: );
1662: END LOOP;
1663:
1664: IF (PO_LOG.d_proc) THEN
1665: PO_LOG.proc_end (d_module);
1666: END IF;
1667:
1668: EXCEPTION
1669: WHEN OTHERS THEN

Line 1720: IF (PO_LOG.d_proc) THEN

1716:
1717: BEGIN
1718: d_position := 0;
1719:
1720: IF (PO_LOG.d_proc) THEN
1721: PO_LOG.proc_begin(d_module);
1722: END IF;
1723:
1724: -- default inspection_required_flag from item_id

Line 1721: PO_LOG.proc_begin(d_module);

1717: BEGIN
1718: d_position := 0;
1719:
1720: IF (PO_LOG.d_proc) THEN
1721: PO_LOG.proc_begin(d_module);
1722: END IF;
1723:
1724: -- default inspection_required_flag from item_id
1725: default_inspect_required_flag

Line 1738: IF (PO_LOG.d_stmt) THEN

1734:
1735: -- default attribute on each record
1736: FOR i IN 1..x_line_locs.rec_count
1737: LOOP
1738: IF (PO_LOG.d_stmt) THEN
1739: PO_LOG.stmt(d_module, d_position, 'default for spo index', i);
1740: END IF;
1741:
1742: -- default shipment_type

Line 1739: PO_LOG.stmt(d_module, d_position, 'default for spo index', i);

1735: -- default attribute on each record
1736: FOR i IN 1..x_line_locs.rec_count
1737: LOOP
1738: IF (PO_LOG.d_stmt) THEN
1739: PO_LOG.stmt(d_module, d_position, 'default for spo index', i);
1740: END IF;
1741:
1742: -- default shipment_type
1743: x_line_locs.shipment_type_tbl(i) :=

Line 1755: IF (PO_LOG.d_stmt) THEN

1751: (
1752: p_po_line_id => x_line_locs.ln_po_line_id_tbl(i)
1753: );
1754:
1755: IF (PO_LOG.d_stmt) THEN
1756: PO_LOG.stmt(d_module, d_position, 'default shipment num',
1757: x_line_locs.shipment_num_tbl(i));
1758: END IF;
1759: END IF;

Line 1756: PO_LOG.stmt(d_module, d_position, 'default shipment num',

1752: p_po_line_id => x_line_locs.ln_po_line_id_tbl(i)
1753: );
1754:
1755: IF (PO_LOG.d_stmt) THEN
1756: PO_LOG.stmt(d_module, d_position, 'default shipment num',
1757: x_line_locs.shipment_num_tbl(i));
1758: END IF;
1759: END IF;
1760:

Line 1766: IF (PO_LOG.d_stmt) THEN

1762: IF (x_line_locs.line_loc_id_tbl(i) IS NULL) THEN
1763: x_line_locs.line_loc_id_tbl(i) :=
1764: PO_PDOI_MAINPROC_UTL_PVT.get_next_line_loc_id;
1765:
1766: IF (PO_LOG.d_stmt) THEN
1767: PO_LOG.stmt(d_module, d_position, 'default line loc',
1768: x_line_locs.line_loc_id_tbl(i));
1769: END IF;
1770: END IF;

Line 1767: PO_LOG.stmt(d_module, d_position, 'default line loc',

1763: x_line_locs.line_loc_id_tbl(i) :=
1764: PO_PDOI_MAINPROC_UTL_PVT.get_next_line_loc_id;
1765:
1766: IF (PO_LOG.d_stmt) THEN
1767: PO_LOG.stmt(d_module, d_position, 'default line loc',
1768: x_line_locs.line_loc_id_tbl(i));
1769: END IF;
1770: END IF;
1771:

Line 1823: IF (PO_LOG.d_stmt) THEN

1819:
1820: -- another loop to default based on defaulted ship_to_organization_id
1821: FOR i IN 1..x_line_locs.rec_count
1822: LOOP
1823: IF (PO_LOG.d_stmt) THEN
1824: PO_LOG.stmt(d_module, d_position, 'second default index', i);
1825: END IF;
1826:
1827: -- default ship_to_organization_id from financial system parameter

Line 1824: PO_LOG.stmt(d_module, d_position, 'second default index', i);

1820: -- another loop to default based on defaulted ship_to_organization_id
1821: FOR i IN 1..x_line_locs.rec_count
1822: LOOP
1823: IF (PO_LOG.d_stmt) THEN
1824: PO_LOG.stmt(d_module, d_position, 'second default index', i);
1825: END IF;
1826:
1827: -- default ship_to_organization_id from financial system parameter
1828: -- for STANDARD

Line 1833: IF (PO_LOG.d_stmt) THEN

1829: x_line_locs.ship_to_org_id_tbl(i) :=
1830: NVL(x_line_locs.ship_to_org_id_tbl(i),
1831: PO_PDOI_PARAMS.g_sys.def_inv_org_id);
1832:
1833: IF (PO_LOG.d_stmt) THEN
1834: PO_LOG.stmt(d_module, d_position, 'ship_to org id',
1835: x_line_locs.ship_to_org_id_tbl(i));
1836: END IF;
1837:

Line 1834: PO_LOG.stmt(d_module, d_position, 'ship_to org id',

1830: NVL(x_line_locs.ship_to_org_id_tbl(i),
1831: PO_PDOI_PARAMS.g_sys.def_inv_org_id);
1832:
1833: IF (PO_LOG.d_stmt) THEN
1834: PO_LOG.stmt(d_module, d_position, 'ship_to org id',
1835: x_line_locs.ship_to_org_id_tbl(i));
1836: END IF;
1837:
1838: d_position := 40;

Line 1868: IF (PO_LOG.d_stmt) THEN

1864: -- default qty_rcv_exception_code from receiving controls
1865: x_line_locs.qty_rcv_exception_code_tbl(i) :=
1866: NVL(x_line_locs.qty_rcv_exception_code_tbl(i), l_qty_rcv_exception);
1867:
1868: IF (PO_LOG.d_stmt) THEN
1869: PO_LOG.stmt(d_module, d_position, 'order type',
1870: x_line_locs.ln_order_type_lookup_code_tbl(i));
1871: END IF;
1872:

Line 1869: PO_LOG.stmt(d_module, d_position, 'order type',

1865: x_line_locs.qty_rcv_exception_code_tbl(i) :=
1866: NVL(x_line_locs.qty_rcv_exception_code_tbl(i), l_qty_rcv_exception);
1867:
1868: IF (PO_LOG.d_stmt) THEN
1869: PO_LOG.stmt(d_module, d_position, 'order type',
1870: x_line_locs.ln_order_type_lookup_code_tbl(i));
1871: END IF;
1872:
1873: -- set the other attributes based on order_type

Line 1966: IF (PO_LOG.d_proc) THEN

1962: p_ship_to_org_id_tbl => x_line_locs.ship_to_org_id_tbl,
1963: x_secondary_unit_of_meas_tbl => x_line_locs.secondary_unit_of_meas_tbl
1964: );
1965:
1966: IF (PO_LOG.d_proc) THEN
1967: PO_LOG.proc_end (d_module);
1968: END IF;
1969:
1970: EXCEPTION

Line 1967: PO_LOG.proc_end (d_module);

1963: x_secondary_unit_of_meas_tbl => x_line_locs.secondary_unit_of_meas_tbl
1964: );
1965:
1966: IF (PO_LOG.d_proc) THEN
1967: PO_LOG.proc_end (d_module);
1968: END IF;
1969:
1970: EXCEPTION
1971: WHEN OTHERS THEN

Line 2012: IF (PO_LOG.d_proc) THEN

2008:
2009: BEGIN
2010: d_position := 0;
2011:
2012: IF (PO_LOG.d_proc) THEN
2013: PO_LOG.proc_begin(d_module);
2014: END IF;
2015:
2016: -- default ship_to_organization_id from ship_to_location_id

Line 2013: PO_LOG.proc_begin(d_module);

2009: BEGIN
2010: d_position := 0;
2011:
2012: IF (PO_LOG.d_proc) THEN
2013: PO_LOG.proc_begin(d_module);
2014: END IF;
2015:
2016: -- default ship_to_organization_id from ship_to_location_id
2017: default_ship_to_org_id

Line 2030: IF (PO_LOG.d_stmt) THEN

2026:
2027: -- default on row by row base
2028: FOR i IN 1..x_line_locs.rec_count
2029: LOOP
2030: IF (PO_LOG.d_stmt) THEN
2031: PO_LOG.stmt(d_module, d_position, 'default for blanket index', i);
2032: END IF;
2033:
2034: -- bug5307208

Line 2031: PO_LOG.stmt(d_module, d_position, 'default for blanket index', i);

2027: -- default on row by row base
2028: FOR i IN 1..x_line_locs.rec_count
2029: LOOP
2030: IF (PO_LOG.d_stmt) THEN
2031: PO_LOG.stmt(d_module, d_position, 'default for blanket index', i);
2032: END IF;
2033:
2034: -- bug5307208
2035: -- Truncate start/end date of the price breaks

Line 2053: IF (PO_LOG.d_stmt) THEN

2049: x_line_locs.line_loc_id_tbl(i) :=
2050: NVL(x_line_locs.line_loc_id_tbl(i),
2051: PO_PDOI_MAINPROC_UTL_PVT.get_next_line_loc_id);
2052:
2053: IF (PO_LOG.d_stmt) THEN
2054: PO_LOG.stmt(d_module, d_position, 'shipment type',
2055: x_line_locs.shipment_type_tbl(i));
2056: PO_LOG.stmt(d_module, d_position, 'shipment num',
2057: x_line_locs.shipment_num_tbl(i));

Line 2054: PO_LOG.stmt(d_module, d_position, 'shipment type',

2050: NVL(x_line_locs.line_loc_id_tbl(i),
2051: PO_PDOI_MAINPROC_UTL_PVT.get_next_line_loc_id);
2052:
2053: IF (PO_LOG.d_stmt) THEN
2054: PO_LOG.stmt(d_module, d_position, 'shipment type',
2055: x_line_locs.shipment_type_tbl(i));
2056: PO_LOG.stmt(d_module, d_position, 'shipment num',
2057: x_line_locs.shipment_num_tbl(i));
2058: PO_LOG.stmt(d_module, d_position, 'line loc id',

Line 2056: PO_LOG.stmt(d_module, d_position, 'shipment num',

2052:
2053: IF (PO_LOG.d_stmt) THEN
2054: PO_LOG.stmt(d_module, d_position, 'shipment type',
2055: x_line_locs.shipment_type_tbl(i));
2056: PO_LOG.stmt(d_module, d_position, 'shipment num',
2057: x_line_locs.shipment_num_tbl(i));
2058: PO_LOG.stmt(d_module, d_position, 'line loc id',
2059: x_line_locs.line_loc_id_tbl(i));
2060: END IF;

Line 2058: PO_LOG.stmt(d_module, d_position, 'line loc id',

2054: PO_LOG.stmt(d_module, d_position, 'shipment type',
2055: x_line_locs.shipment_type_tbl(i));
2056: PO_LOG.stmt(d_module, d_position, 'shipment num',
2057: x_line_locs.shipment_num_tbl(i));
2058: PO_LOG.stmt(d_module, d_position, 'line loc id',
2059: x_line_locs.line_loc_id_tbl(i));
2060: END IF;
2061:
2062: -- set accrue_on_receipt_flag and firm_flag to NULL

Line 2095: IF (PO_LOG.d_proc) THEN

2091: -- set outsourced_assembly to 2 since it is a required field
2092: x_line_locs.outsourced_assembly_tbl(i) := 2;
2093: END LOOP;
2094:
2095: IF (PO_LOG.d_proc) THEN
2096: PO_LOG.proc_end (d_module);
2097: END IF;
2098:
2099: EXCEPTION

Line 2096: PO_LOG.proc_end (d_module);

2092: x_line_locs.outsourced_assembly_tbl(i) := 2;
2093: END LOOP;
2094:
2095: IF (PO_LOG.d_proc) THEN
2096: PO_LOG.proc_end (d_module);
2097: END IF;
2098:
2099: EXCEPTION
2100: WHEN OTHERS THEN

Line 2150: IF (PO_LOG.d_proc) THEN

2146: l_rct_days_exception_code VARCHAR2(25);
2147: BEGIN
2148: d_position := 0;
2149:
2150: IF (PO_LOG.d_proc) THEN
2151: PO_LOG.proc_begin(d_module);
2152: END IF;
2153:
2154: -- default inspection_required_flag from item_id

Line 2151: PO_LOG.proc_begin(d_module);

2147: BEGIN
2148: d_position := 0;
2149:
2150: IF (PO_LOG.d_proc) THEN
2151: PO_LOG.proc_begin(d_module);
2152: END IF;
2153:
2154: -- default inspection_required_flag from item_id
2155: default_inspect_required_flag

Line 2179: IF (PO_LOG.d_stmt) THEN

2175:
2176: -- default on row by row base
2177: FOR i IN 1..x_line_locs.rec_count
2178: LOOP
2179: IF (PO_LOG.d_stmt) THEN
2180: PO_LOG.stmt(d_module, d_position, 'default for quotation index', i);
2181: END IF;
2182:
2183: -- bug5307208

Line 2180: PO_LOG.stmt(d_module, d_position, 'default for quotation index', i);

2176: -- default on row by row base
2177: FOR i IN 1..x_line_locs.rec_count
2178: LOOP
2179: IF (PO_LOG.d_stmt) THEN
2180: PO_LOG.stmt(d_module, d_position, 'default for quotation index', i);
2181: END IF;
2182:
2183: -- bug5307208
2184: -- Truncate start/end date of the price breaks

Line 2202: IF (PO_LOG.d_stmt) THEN

2198: x_line_locs.line_loc_id_tbl(i) :=
2199: NVL(x_line_locs.line_loc_id_tbl(i),
2200: PO_PDOI_MAINPROC_UTL_PVT.get_next_line_loc_id);
2201:
2202: IF (PO_LOG.d_stmt) THEN
2203: PO_LOG.stmt(d_module, d_position, 'shipment type',
2204: x_line_locs.shipment_type_tbl(i));
2205: PO_LOG.stmt(d_module, d_position, 'shipment num',
2206: x_line_locs.shipment_num_tbl(i));

Line 2203: PO_LOG.stmt(d_module, d_position, 'shipment type',

2199: NVL(x_line_locs.line_loc_id_tbl(i),
2200: PO_PDOI_MAINPROC_UTL_PVT.get_next_line_loc_id);
2201:
2202: IF (PO_LOG.d_stmt) THEN
2203: PO_LOG.stmt(d_module, d_position, 'shipment type',
2204: x_line_locs.shipment_type_tbl(i));
2205: PO_LOG.stmt(d_module, d_position, 'shipment num',
2206: x_line_locs.shipment_num_tbl(i));
2207: PO_LOG.stmt(d_module, d_position, 'line loc id',

Line 2205: PO_LOG.stmt(d_module, d_position, 'shipment num',

2201:
2202: IF (PO_LOG.d_stmt) THEN
2203: PO_LOG.stmt(d_module, d_position, 'shipment type',
2204: x_line_locs.shipment_type_tbl(i));
2205: PO_LOG.stmt(d_module, d_position, 'shipment num',
2206: x_line_locs.shipment_num_tbl(i));
2207: PO_LOG.stmt(d_module, d_position, 'line loc id',
2208: x_line_locs.line_loc_id_tbl(i));
2209: END IF;

Line 2207: PO_LOG.stmt(d_module, d_position, 'line loc id',

2203: PO_LOG.stmt(d_module, d_position, 'shipment type',
2204: x_line_locs.shipment_type_tbl(i));
2205: PO_LOG.stmt(d_module, d_position, 'shipment num',
2206: x_line_locs.shipment_num_tbl(i));
2207: PO_LOG.stmt(d_module, d_position, 'line loc id',
2208: x_line_locs.line_loc_id_tbl(i));
2209: END IF;
2210:
2211: -- default terms_id from header,

Line 2267: IF (PO_LOG.d_stmt) THEN

2263: -- default qty_rcv_exception_code from receiving controls
2264: x_line_locs.qty_rcv_exception_code_tbl(i) :=
2265: NVL(x_line_locs.qty_rcv_exception_code_tbl(i), l_qty_rcv_exception);
2266:
2267: IF (PO_LOG.d_stmt) THEN
2268: PO_LOG.stmt(d_module, d_position, 'qty_rcv_tolerance',
2269: x_line_locs.qty_rcv_tolerance_tbl(i));
2270: PO_LOG.stmt(d_module, d_position, 'qty_rcv_exception_code',
2271: x_line_locs.qty_rcv_exception_code_tbl(i));

Line 2268: PO_LOG.stmt(d_module, d_position, 'qty_rcv_tolerance',

2264: x_line_locs.qty_rcv_exception_code_tbl(i) :=
2265: NVL(x_line_locs.qty_rcv_exception_code_tbl(i), l_qty_rcv_exception);
2266:
2267: IF (PO_LOG.d_stmt) THEN
2268: PO_LOG.stmt(d_module, d_position, 'qty_rcv_tolerance',
2269: x_line_locs.qty_rcv_tolerance_tbl(i));
2270: PO_LOG.stmt(d_module, d_position, 'qty_rcv_exception_code',
2271: x_line_locs.qty_rcv_exception_code_tbl(i));
2272: END IF;

Line 2270: PO_LOG.stmt(d_module, d_position, 'qty_rcv_exception_code',

2266:
2267: IF (PO_LOG.d_stmt) THEN
2268: PO_LOG.stmt(d_module, d_position, 'qty_rcv_tolerance',
2269: x_line_locs.qty_rcv_tolerance_tbl(i));
2270: PO_LOG.stmt(d_module, d_position, 'qty_rcv_exception_code',
2271: x_line_locs.qty_rcv_exception_code_tbl(i));
2272: END IF;
2273: END IF;
2274:

Line 2292: IF (PO_LOG.d_proc) THEN

2288: -- set outsourced_assembly to 2 since it is a required field
2289: x_line_locs.outsourced_assembly_tbl(i) := 2;
2290: END LOOP;
2291:
2292: IF (PO_LOG.d_proc) THEN
2293: PO_LOG.proc_end (d_module);
2294: END IF;
2295:
2296: EXCEPTION

Line 2293: PO_LOG.proc_end (d_module);

2289: x_line_locs.outsourced_assembly_tbl(i) := 2;
2290: END LOOP;
2291:
2292: IF (PO_LOG.d_proc) THEN
2293: PO_LOG.proc_end (d_module);
2294: END IF;
2295:
2296: EXCEPTION
2297: WHEN OTHERS THEN

Line 2345: IF (PO_LOG.d_proc) THEN

2341: l_result_tbl PO_TBL_VARCHAR1;
2342: BEGIN
2343: d_position := 0;
2344:
2345: IF (PO_LOG.d_proc) THEN
2346: PO_LOG.proc_begin(d_module);
2347: END IF;
2348:
2349: -- retrieve the default value from database

Line 2346: PO_LOG.proc_begin(d_module);

2342: BEGIN
2343: d_position := 0;
2344:
2345: IF (PO_LOG.d_proc) THEN
2346: PO_LOG.proc_begin(d_module);
2347: END IF;
2348:
2349: -- retrieve the default value from database
2350: FORALL i IN 1..p_index_tbl.COUNT

Line 2373: IF (PO_LOG.d_stmt) THEN

2369:
2370: -- set result back to x_inspection_required_flag_tbl
2371: FOR i IN 1..l_index_tbl.COUNT
2372: LOOP
2373: IF (PO_LOG.d_stmt) THEN
2374: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2375: PO_LOG.stmt(d_module, d_position, 'default inspection required flag',
2376: l_result_tbl(i));
2377: END IF;

Line 2374: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));

2370: -- set result back to x_inspection_required_flag_tbl
2371: FOR i IN 1..l_index_tbl.COUNT
2372: LOOP
2373: IF (PO_LOG.d_stmt) THEN
2374: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2375: PO_LOG.stmt(d_module, d_position, 'default inspection required flag',
2376: l_result_tbl(i));
2377: END IF;
2378:

Line 2375: PO_LOG.stmt(d_module, d_position, 'default inspection required flag',

2371: FOR i IN 1..l_index_tbl.COUNT
2372: LOOP
2373: IF (PO_LOG.d_stmt) THEN
2374: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2375: PO_LOG.stmt(d_module, d_position, 'default inspection required flag',
2376: l_result_tbl(i));
2377: END IF;
2378:
2379: x_inspection_required_flag_tbl(l_index_tbl(i)) := l_result_tbl(i);

Line 2382: IF (PO_LOG.d_proc) THEN

2378:
2379: x_inspection_required_flag_tbl(l_index_tbl(i)) := l_result_tbl(i);
2380: END LOOP;
2381:
2382: IF (PO_LOG.d_proc) THEN
2383: PO_LOG.proc_end (d_module);
2384: END IF;
2385:
2386: EXCEPTION

Line 2383: PO_LOG.proc_end (d_module);

2379: x_inspection_required_flag_tbl(l_index_tbl(i)) := l_result_tbl(i);
2380: END LOOP;
2381:
2382: IF (PO_LOG.d_proc) THEN
2383: PO_LOG.proc_end (d_module);
2384: END IF;
2385:
2386: EXCEPTION
2387: WHEN OTHERS THEN

Line 2435: IF (PO_LOG.d_proc) THEN

2431: l_result_tbl PO_TBL_NUMBER;
2432: BEGIN
2433: d_position := 0;
2434:
2435: IF (PO_LOG.d_proc) THEN
2436: PO_LOG.proc_begin(d_module);
2437: END IF;
2438:
2439: -- default ship_to_organization_id from ship_to_location_id

Line 2436: PO_LOG.proc_begin(d_module);

2432: BEGIN
2433: d_position := 0;
2434:
2435: IF (PO_LOG.d_proc) THEN
2436: PO_LOG.proc_begin(d_module);
2437: END IF;
2438:
2439: -- default ship_to_organization_id from ship_to_location_id
2440: FORALL i IN 1..p_index_tbl.COUNT

Line 2463: IF (PO_LOG.d_stmt) THEN

2459:
2460: -- set result in x_ship_to_org_id_tbl
2461: FOR i IN 1..l_index_tbl.COUNT
2462: LOOP
2463: IF (PO_LOG.d_stmt) THEN
2464: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2465: PO_LOG.stmt(d_module, d_position, 'default ship_to org id',
2466: l_result_tbl(i));
2467: END IF;

Line 2464: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));

2460: -- set result in x_ship_to_org_id_tbl
2461: FOR i IN 1..l_index_tbl.COUNT
2462: LOOP
2463: IF (PO_LOG.d_stmt) THEN
2464: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2465: PO_LOG.stmt(d_module, d_position, 'default ship_to org id',
2466: l_result_tbl(i));
2467: END IF;
2468:

Line 2465: PO_LOG.stmt(d_module, d_position, 'default ship_to org id',

2461: FOR i IN 1..l_index_tbl.COUNT
2462: LOOP
2463: IF (PO_LOG.d_stmt) THEN
2464: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2465: PO_LOG.stmt(d_module, d_position, 'default ship_to org id',
2466: l_result_tbl(i));
2467: END IF;
2468:
2469: x_ship_to_org_id_tbl(l_index_tbl(i)) := l_result_tbl(i);

Line 2472: IF (PO_LOG.d_proc) THEN

2468:
2469: x_ship_to_org_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
2470: END LOOP;
2471:
2472: IF (PO_LOG.d_proc) THEN
2473: PO_LOG.proc_end (d_module);
2474: END IF;
2475:
2476: EXCEPTION

Line 2473: PO_LOG.proc_end (d_module);

2469: x_ship_to_org_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
2470: END LOOP;
2471:
2472: IF (PO_LOG.d_proc) THEN
2473: PO_LOG.proc_end (d_module);
2474: END IF;
2475:
2476: EXCEPTION
2477: WHEN OTHERS THEN

Line 2544: IF (PO_LOG.d_proc) THEN

2540: l_index NUMBER;
2541: BEGIN
2542: d_position := 0;
2543:
2544: IF (PO_LOG.d_proc) THEN
2545: PO_LOG.proc_begin(d_module);
2546: END IF;
2547:
2548: -- first, default from item_id and ship_to_organization_id

Line 2545: PO_LOG.proc_begin(d_module);

2541: BEGIN
2542: d_position := 0;
2543:
2544: IF (PO_LOG.d_proc) THEN
2545: PO_LOG.proc_begin(d_module);
2546: END IF;
2547:
2548: -- first, default from item_id and ship_to_organization_id
2549: FORALL i IN 1..p_index_tbl.COUNT

Line 2582: IF (PO_LOG.d_stmt) THEN

2578: x_receive_close_tolerance_tbl(l_index) :=
2579: NVL(x_receive_close_tolerance_tbl(l_index),
2580: l_receive_tolerance_tbl(i));
2581:
2582: IF (PO_LOG.d_stmt) THEN
2583: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2584: PO_LOG.stmt(d_module, d_position, 'invoice close tolerance',
2585: x_invoice_close_tolerance_tbl(l_index));
2586: PO_LOG.stmt(d_module, d_position, 'receive close tolerance',

Line 2583: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));

2579: NVL(x_receive_close_tolerance_tbl(l_index),
2580: l_receive_tolerance_tbl(i));
2581:
2582: IF (PO_LOG.d_stmt) THEN
2583: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2584: PO_LOG.stmt(d_module, d_position, 'invoice close tolerance',
2585: x_invoice_close_tolerance_tbl(l_index));
2586: PO_LOG.stmt(d_module, d_position, 'receive close tolerance',
2587: x_receive_close_tolerance_tbl(l_index));

Line 2584: PO_LOG.stmt(d_module, d_position, 'invoice close tolerance',

2580: l_receive_tolerance_tbl(i));
2581:
2582: IF (PO_LOG.d_stmt) THEN
2583: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2584: PO_LOG.stmt(d_module, d_position, 'invoice close tolerance',
2585: x_invoice_close_tolerance_tbl(l_index));
2586: PO_LOG.stmt(d_module, d_position, 'receive close tolerance',
2587: x_receive_close_tolerance_tbl(l_index));
2588: END IF;

Line 2586: PO_LOG.stmt(d_module, d_position, 'receive close tolerance',

2582: IF (PO_LOG.d_stmt) THEN
2583: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2584: PO_LOG.stmt(d_module, d_position, 'invoice close tolerance',
2585: x_invoice_close_tolerance_tbl(l_index));
2586: PO_LOG.stmt(d_module, d_position, 'receive close tolerance',
2587: x_receive_close_tolerance_tbl(l_index));
2588: END IF;
2589: END LOOP;
2590:

Line 2627: IF (PO_LOG.d_stmt) THEN

2623: x_receive_close_tolerance_tbl(l_index) :=
2624: NVL(x_receive_close_tolerance_tbl(l_index),
2625: l_receive_tolerance_tbl(i));
2626:
2627: IF (PO_LOG.d_stmt) THEN
2628: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2629: PO_LOG.stmt(d_module, d_position, 'invoice close tolerance',
2630: x_invoice_close_tolerance_tbl(l_index));
2631: PO_LOG.stmt(d_module, d_position, 'receive close tolerance',

Line 2628: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));

2624: NVL(x_receive_close_tolerance_tbl(l_index),
2625: l_receive_tolerance_tbl(i));
2626:
2627: IF (PO_LOG.d_stmt) THEN
2628: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2629: PO_LOG.stmt(d_module, d_position, 'invoice close tolerance',
2630: x_invoice_close_tolerance_tbl(l_index));
2631: PO_LOG.stmt(d_module, d_position, 'receive close tolerance',
2632: x_receive_close_tolerance_tbl(l_index));

Line 2629: PO_LOG.stmt(d_module, d_position, 'invoice close tolerance',

2625: l_receive_tolerance_tbl(i));
2626:
2627: IF (PO_LOG.d_stmt) THEN
2628: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2629: PO_LOG.stmt(d_module, d_position, 'invoice close tolerance',
2630: x_invoice_close_tolerance_tbl(l_index));
2631: PO_LOG.stmt(d_module, d_position, 'receive close tolerance',
2632: x_receive_close_tolerance_tbl(l_index));
2633: END IF;

Line 2631: PO_LOG.stmt(d_module, d_position, 'receive close tolerance',

2627: IF (PO_LOG.d_stmt) THEN
2628: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2629: PO_LOG.stmt(d_module, d_position, 'invoice close tolerance',
2630: x_invoice_close_tolerance_tbl(l_index));
2631: PO_LOG.stmt(d_module, d_position, 'receive close tolerance',
2632: x_receive_close_tolerance_tbl(l_index));
2633: END IF;
2634: END LOOP;
2635:

Line 2658: IF (PO_LOG.d_stmt) THEN

2654: l_index_tbl, l_receive_tolerance_tbl;
2655:
2656: FOR i IN 1..l_index_tbl.COUNT
2657: LOOP
2658: IF (PO_LOG.d_stmt) THEN
2659: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2660: PO_LOG.stmt(d_module, d_position, 'receive close tolerance',
2661: l_receive_tolerance_tbl(i));
2662: END IF;

Line 2659: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));

2655:
2656: FOR i IN 1..l_index_tbl.COUNT
2657: LOOP
2658: IF (PO_LOG.d_stmt) THEN
2659: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2660: PO_LOG.stmt(d_module, d_position, 'receive close tolerance',
2661: l_receive_tolerance_tbl(i));
2662: END IF;
2663:

Line 2660: PO_LOG.stmt(d_module, d_position, 'receive close tolerance',

2656: FOR i IN 1..l_index_tbl.COUNT
2657: LOOP
2658: IF (PO_LOG.d_stmt) THEN
2659: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2660: PO_LOG.stmt(d_module, d_position, 'receive close tolerance',
2661: l_receive_tolerance_tbl(i));
2662: END IF;
2663:
2664: x_receive_close_tolerance_tbl(l_index_tbl(i)) := l_receive_tolerance_tbl(i);

Line 2672: IF (PO_LOG.d_stmt) THEN

2668:
2669: -- Last, default from system parameters using loop
2670: FOR i IN 1..p_index_tbl.COUNT
2671: LOOP
2672: IF (PO_LOG.d_stmt) THEN
2673: PO_LOG.stmt(d_module, d_position, 'index', i);
2674: PO_LOG.stmt(d_module, d_position, 'invoice close tolerance',
2675: x_invoice_close_tolerance_tbl(i));
2676: PO_LOG.stmt(d_module, d_position, 'receive close tolerance',

Line 2673: PO_LOG.stmt(d_module, d_position, 'index', i);

2669: -- Last, default from system parameters using loop
2670: FOR i IN 1..p_index_tbl.COUNT
2671: LOOP
2672: IF (PO_LOG.d_stmt) THEN
2673: PO_LOG.stmt(d_module, d_position, 'index', i);
2674: PO_LOG.stmt(d_module, d_position, 'invoice close tolerance',
2675: x_invoice_close_tolerance_tbl(i));
2676: PO_LOG.stmt(d_module, d_position, 'receive close tolerance',
2677: x_receive_close_tolerance_tbl(i));

Line 2674: PO_LOG.stmt(d_module, d_position, 'invoice close tolerance',

2670: FOR i IN 1..p_index_tbl.COUNT
2671: LOOP
2672: IF (PO_LOG.d_stmt) THEN
2673: PO_LOG.stmt(d_module, d_position, 'index', i);
2674: PO_LOG.stmt(d_module, d_position, 'invoice close tolerance',
2675: x_invoice_close_tolerance_tbl(i));
2676: PO_LOG.stmt(d_module, d_position, 'receive close tolerance',
2677: x_receive_close_tolerance_tbl(i));
2678: END IF;

Line 2676: PO_LOG.stmt(d_module, d_position, 'receive close tolerance',

2672: IF (PO_LOG.d_stmt) THEN
2673: PO_LOG.stmt(d_module, d_position, 'index', i);
2674: PO_LOG.stmt(d_module, d_position, 'invoice close tolerance',
2675: x_invoice_close_tolerance_tbl(i));
2676: PO_LOG.stmt(d_module, d_position, 'receive close tolerance',
2677: x_receive_close_tolerance_tbl(i));
2678: END IF;
2679:
2680: x_invoice_close_tolerance_tbl(i) :=

Line 2690: IF (PO_LOG.d_proc) THEN

2686: PO_PDOI_PARAMS.g_sys.receive_close_tolerance,
2687: 0);
2688: END LOOP;
2689:
2690: IF (PO_LOG.d_proc) THEN
2691: PO_LOG.proc_end (d_module);
2692: END IF;
2693:
2694: EXCEPTION

Line 2691: PO_LOG.proc_end (d_module);

2687: 0);
2688: END LOOP;
2689:
2690: IF (PO_LOG.d_proc) THEN
2691: PO_LOG.proc_end (d_module);
2692: END IF;
2693:
2694: EXCEPTION
2695: WHEN OTHERS THEN

Line 2749: IF (PO_LOG.d_proc) THEN

2745: l_result_tbl PO_TBL_VARCHAR30;
2746: BEGIN
2747: d_position := 0;
2748:
2749: IF (PO_LOG.d_proc) THEN
2750: PO_LOG.proc_begin(d_module);
2751: END IF;
2752:
2753: -- first, get default value from vendor_site

Line 2750: PO_LOG.proc_begin(d_module);

2746: BEGIN
2747: d_position := 0;
2748:
2749: IF (PO_LOG.d_proc) THEN
2750: PO_LOG.proc_begin(d_module);
2751: END IF;
2752:
2753: -- first, get default value from vendor_site
2754: FORALL i IN 1..p_index_tbl.COUNT

Line 2772: IF (PO_LOG.d_stmt) THEN

2768: RETURNING num1, char1 BULK COLLECT INTO l_index_tbl, l_result_tbl;
2769:
2770: FOR i IN 1..l_index_tbl.COUNT
2771: LOOP
2772: IF (PO_LOG.d_stmt) THEN
2773: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2774: PO_LOG.stmt(d_module, d_position, 'new match option', l_result_tbl(i));
2775: END IF;
2776:

Line 2773: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));

2769:
2770: FOR i IN 1..l_index_tbl.COUNT
2771: LOOP
2772: IF (PO_LOG.d_stmt) THEN
2773: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2774: PO_LOG.stmt(d_module, d_position, 'new match option', l_result_tbl(i));
2775: END IF;
2776:
2777: x_match_option_tbl(l_index_tbl(i)) := l_result_tbl(i);

Line 2774: PO_LOG.stmt(d_module, d_position, 'new match option', l_result_tbl(i));

2770: FOR i IN 1..l_index_tbl.COUNT
2771: LOOP
2772: IF (PO_LOG.d_stmt) THEN
2773: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2774: PO_LOG.stmt(d_module, d_position, 'new match option', l_result_tbl(i));
2775: END IF;
2776:
2777: x_match_option_tbl(l_index_tbl(i)) := l_result_tbl(i);
2778: END LOOP;

Line 2801: IF (PO_LOG.d_stmt) THEN

2797: RETURNING num1, char1 BULK COLLECT INTO l_index_tbl, l_result_tbl;
2798:
2799: FOR i IN 1..l_index_tbl.COUNT
2800: LOOP
2801: IF (PO_LOG.d_stmt) THEN
2802: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2803: PO_LOG.stmt(d_module, d_position, 'new match option', l_result_tbl(i));
2804: END IF;
2805:

Line 2802: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));

2798:
2799: FOR i IN 1..l_index_tbl.COUNT
2800: LOOP
2801: IF (PO_LOG.d_stmt) THEN
2802: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2803: PO_LOG.stmt(d_module, d_position, 'new match option', l_result_tbl(i));
2804: END IF;
2805:
2806: x_match_option_tbl(l_index_tbl(i)) := l_result_tbl(i);

Line 2803: PO_LOG.stmt(d_module, d_position, 'new match option', l_result_tbl(i));

2799: FOR i IN 1..l_index_tbl.COUNT
2800: LOOP
2801: IF (PO_LOG.d_stmt) THEN
2802: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2803: PO_LOG.stmt(d_module, d_position, 'new match option', l_result_tbl(i));
2804: END IF;
2805:
2806: x_match_option_tbl(l_index_tbl(i)) := l_result_tbl(i);
2807: END LOOP;

Line 2814: IF (PO_LOG.d_stmt) THEN

2810:
2811: -- last, get default value from financial system parameter using loop
2812: FOR i IN 1..p_index_tbl.COUNT
2813: LOOP
2814: IF (PO_LOG.d_stmt) THEN
2815: PO_LOG.stmt(d_module, d_position, 'index', i);
2816: PO_LOG.stmt(d_module, d_position, 'curr match option', x_match_option_tbl(i));
2817: END IF;
2818:

Line 2815: PO_LOG.stmt(d_module, d_position, 'index', i);

2811: -- last, get default value from financial system parameter using loop
2812: FOR i IN 1..p_index_tbl.COUNT
2813: LOOP
2814: IF (PO_LOG.d_stmt) THEN
2815: PO_LOG.stmt(d_module, d_position, 'index', i);
2816: PO_LOG.stmt(d_module, d_position, 'curr match option', x_match_option_tbl(i));
2817: END IF;
2818:
2819: x_match_option_tbl(i) :=

Line 2816: PO_LOG.stmt(d_module, d_position, 'curr match option', x_match_option_tbl(i));

2812: FOR i IN 1..p_index_tbl.COUNT
2813: LOOP
2814: IF (PO_LOG.d_stmt) THEN
2815: PO_LOG.stmt(d_module, d_position, 'index', i);
2816: PO_LOG.stmt(d_module, d_position, 'curr match option', x_match_option_tbl(i));
2817: END IF;
2818:
2819: x_match_option_tbl(i) :=
2820: NVL(x_match_option_tbl(i), PO_PDOI_PARAMS.g_sys.invoice_match_option);

Line 2823: IF (PO_LOG.d_proc) THEN

2819: x_match_option_tbl(i) :=
2820: NVL(x_match_option_tbl(i), PO_PDOI_PARAMS.g_sys.invoice_match_option);
2821: END LOOP;
2822:
2823: IF (PO_LOG.d_proc) THEN
2824: PO_LOG.proc_end (d_module);
2825: END IF;
2826:
2827: EXCEPTION

Line 2824: PO_LOG.proc_end (d_module);

2820: NVL(x_match_option_tbl(i), PO_PDOI_PARAMS.g_sys.invoice_match_option);
2821: END LOOP;
2822:
2823: IF (PO_LOG.d_proc) THEN
2824: PO_LOG.proc_end (d_module);
2825: END IF;
2826:
2827: EXCEPTION
2828: WHEN OTHERS THEN

Line 2885: IF (PO_LOG.d_proc) THEN

2881: l_index NUMBER;
2882: BEGIN
2883: d_position := 0;
2884:
2885: IF (PO_LOG.d_proc) THEN
2886: PO_LOG.proc_begin(d_module);
2887: END IF;
2888:
2889: -- get default values from item

Line 2886: PO_LOG.proc_begin(d_module);

2882: BEGIN
2883: d_position := 0;
2884:
2885: IF (PO_LOG.d_proc) THEN
2886: PO_LOG.proc_begin(d_module);
2887: END IF;
2888:
2889: -- get default values from item
2890: -- first, default from item_id and ship_to_organization_id

Line 2927: IF (PO_LOG.d_stmt) THEN

2923: l_item_status := 'D'; -- Expense
2924: END IF;
2925: END IF;
2926:
2927: IF (PO_LOG.d_stmt) THEN
2928: PO_LOG.stmt(d_module, d_position, 'index', l_index);
2929: PO_LOG.stmt(d_module, d_position, 'item status', l_item_status);
2930: END IF;
2931:

Line 2928: PO_LOG.stmt(d_module, d_position, 'index', l_index);

2924: END IF;
2925: END IF;
2926:
2927: IF (PO_LOG.d_stmt) THEN
2928: PO_LOG.stmt(d_module, d_position, 'index', l_index);
2929: PO_LOG.stmt(d_module, d_position, 'item status', l_item_status);
2930: END IF;
2931:
2932: -- set default value

Line 2929: PO_LOG.stmt(d_module, d_position, 'item status', l_item_status);

2925: END IF;
2926:
2927: IF (PO_LOG.d_stmt) THEN
2928: PO_LOG.stmt(d_module, d_position, 'index', l_index);
2929: PO_LOG.stmt(d_module, d_position, 'item status', l_item_status);
2930: END IF;
2931:
2932: -- set default value
2933: IF (l_item_status = 'O') THEN

Line 2936: IF (PO_LOG.d_stmt) THEN

2932: -- set default value
2933: IF (l_item_status = 'O') THEN
2934: x_accrue_on_receipt_flag_tbl(l_index) := 'Y';
2935: ELSIF (l_item_status = 'E') THEN
2936: IF (PO_LOG.d_stmt) THEN
2937: PO_LOG.stmt(d_module, d_position, 'INV installed',
2938: PO_PDOI_PARAMS.g_product.inv_installed);
2939: PO_LOG.stmt(d_module, d_position, 'default expense accrual code',
2940: PO_PDOI_PARAMS.g_sys.expense_accrual_code);

Line 2937: PO_LOG.stmt(d_module, d_position, 'INV installed',

2933: IF (l_item_status = 'O') THEN
2934: x_accrue_on_receipt_flag_tbl(l_index) := 'Y';
2935: ELSIF (l_item_status = 'E') THEN
2936: IF (PO_LOG.d_stmt) THEN
2937: PO_LOG.stmt(d_module, d_position, 'INV installed',
2938: PO_PDOI_PARAMS.g_product.inv_installed);
2939: PO_LOG.stmt(d_module, d_position, 'default expense accrual code',
2940: PO_PDOI_PARAMS.g_sys.expense_accrual_code);
2941: END IF;

Line 2939: PO_LOG.stmt(d_module, d_position, 'default expense accrual code',

2935: ELSIF (l_item_status = 'E') THEN
2936: IF (PO_LOG.d_stmt) THEN
2937: PO_LOG.stmt(d_module, d_position, 'INV installed',
2938: PO_PDOI_PARAMS.g_product.inv_installed);
2939: PO_LOG.stmt(d_module, d_position, 'default expense accrual code',
2940: PO_PDOI_PARAMS.g_sys.expense_accrual_code);
2941: END IF;
2942:
2943: IF (PO_PDOI_PARAMS.g_product.inv_installed = FND_API.g_TRUE) then

Line 2963: IF (PO_LOG.d_proc) THEN

2959: END IF;
2960: END IF;
2961: END LOOP;
2962:
2963: IF (PO_LOG.d_proc) THEN
2964: PO_LOG.proc_end (d_module);
2965: END IF;
2966:
2967: EXCEPTION

Line 2964: PO_LOG.proc_end (d_module);

2960: END IF;
2961: END LOOP;
2962:
2963: IF (PO_LOG.d_proc) THEN
2964: PO_LOG.proc_end (d_module);
2965: END IF;
2966:
2967: EXCEPTION
2968: WHEN OTHERS THEN

Line 3019: IF (PO_LOG.d_proc) THEN

3015: l_result_tbl PO_TBL_VARCHAR30;
3016: BEGIN
3017: d_position := 0;
3018:
3019: IF (PO_LOG.d_proc) THEN
3020: PO_LOG.proc_begin(d_module, 'p_item_id_tbl', p_item_id_tbl);
3021: PO_LOG.proc_begin(d_module, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
3022: END IF;
3023:

Line 3020: PO_LOG.proc_begin(d_module, 'p_item_id_tbl', p_item_id_tbl);

3016: BEGIN
3017: d_position := 0;
3018:
3019: IF (PO_LOG.d_proc) THEN
3020: PO_LOG.proc_begin(d_module, 'p_item_id_tbl', p_item_id_tbl);
3021: PO_LOG.proc_begin(d_module, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
3022: END IF;
3023:
3024: -- retrieve the default value from database

Line 3021: PO_LOG.proc_begin(d_module, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);

3017: d_position := 0;
3018:
3019: IF (PO_LOG.d_proc) THEN
3020: PO_LOG.proc_begin(d_module, 'p_item_id_tbl', p_item_id_tbl);
3021: PO_LOG.proc_begin(d_module, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
3022: END IF;
3023:
3024: -- retrieve the default value from database
3025: FORALL i IN 1..p_index_tbl.COUNT

Line 3052: IF (PO_LOG.d_stmt) THEN

3048:
3049: -- set result back to x_inspection_required_flag_tbl
3050: FOR i IN 1..l_index_tbl.COUNT
3051: LOOP
3052: IF (PO_LOG.d_stmt) THEN
3053: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3054: PO_LOG.stmt(d_module, d_position, 'default secondary_unit_of_measure',
3055: l_result_tbl(i));
3056: END IF;

Line 3053: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));

3049: -- set result back to x_inspection_required_flag_tbl
3050: FOR i IN 1..l_index_tbl.COUNT
3051: LOOP
3052: IF (PO_LOG.d_stmt) THEN
3053: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3054: PO_LOG.stmt(d_module, d_position, 'default secondary_unit_of_measure',
3055: l_result_tbl(i));
3056: END IF;
3057:

Line 3054: PO_LOG.stmt(d_module, d_position, 'default secondary_unit_of_measure',

3050: FOR i IN 1..l_index_tbl.COUNT
3051: LOOP
3052: IF (PO_LOG.d_stmt) THEN
3053: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3054: PO_LOG.stmt(d_module, d_position, 'default secondary_unit_of_measure',
3055: l_result_tbl(i));
3056: END IF;
3057:
3058: x_secondary_unit_of_meas_tbl(l_index_tbl(i)) := l_result_tbl(i);

Line 3061: IF (PO_LOG.d_proc) THEN

3057:
3058: x_secondary_unit_of_meas_tbl(l_index_tbl(i)) := l_result_tbl(i);
3059: END LOOP;
3060:
3061: IF (PO_LOG.d_proc) THEN
3062: PO_LOG.proc_end (d_module);
3063: END IF;
3064:
3065: EXCEPTION

Line 3062: PO_LOG.proc_end (d_module);

3058: x_secondary_unit_of_meas_tbl(l_index_tbl(i)) := l_result_tbl(i);
3059: END LOOP;
3060:
3061: IF (PO_LOG.d_proc) THEN
3062: PO_LOG.proc_end (d_module);
3063: END IF;
3064:
3065: EXCEPTION
3066: WHEN OTHERS THEN

Line 3111: IF (PO_LOG.d_proc) THEN

3107: l_remove_err_line_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
3108: BEGIN
3109: d_position := 0;
3110:
3111: IF (PO_LOG.d_proc) THEN
3112: PO_LOG.proc_begin(d_module);
3113: END IF;
3114:
3115: FOR i IN 1 .. x_line_locs.intf_line_loc_id_tbl.COUNT LOOP

Line 3112: PO_LOG.proc_begin(d_module);

3108: BEGIN
3109: d_position := 0;
3110:
3111: IF (PO_LOG.d_proc) THEN
3112: PO_LOG.proc_begin(d_module);
3113: END IF;
3114:
3115: FOR i IN 1 .. x_line_locs.intf_line_loc_id_tbl.COUNT LOOP
3116: l_index_tbl(x_line_locs.intf_line_loc_id_tbl(i)) := i;

Line 3133: IF (PO_LOG.d_stmt) THEN

3129: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
3130: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
3131: d_position := 20;
3132:
3133: IF (PO_LOG.d_stmt) THEN
3134: PO_LOG.stmt(d_module, d_position, 'after error tolerance exceeded, collect error on index', l_index);
3135: END IF;
3136:
3137: -- collect intf_line_loc_ids to remove the errors from error intf table

Line 3134: PO_LOG.stmt(d_module, d_position, 'after error tolerance exceeded, collect error on index', l_index);

3130: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
3131: d_position := 20;
3132:
3133: IF (PO_LOG.d_stmt) THEN
3134: PO_LOG.stmt(d_module, d_position, 'after error tolerance exceeded, collect error on index', l_index);
3135: END IF;
3136:
3137: -- collect intf_line_loc_ids to remove the errors from error intf table
3138: IF (NOT PO_PDOI_PARAMS.g_errored_lines.EXISTS(x_line_locs.intf_line_id_tbl(l_index))) THEN

Line 3149: IF (PO_LOG.d_stmt) THEN

3145: END IF;
3146: ELSIF (x_results.result_type(i) = po_validations.c_result_type_failure) THEN
3147: d_position := 40;
3148:
3149: IF (PO_LOG.d_stmt) THEN
3150: PO_LOG.stmt(d_module, d_position, 'set error on index', l_index);
3151: END IF;
3152:
3153: x_line_locs.error_flag_tbl(l_index) := FND_API.g_TRUE;

Line 3150: PO_LOG.stmt(d_module, d_position, 'set error on index', l_index);

3146: ELSIF (x_results.result_type(i) = po_validations.c_result_type_failure) THEN
3147: d_position := 40;
3148:
3149: IF (PO_LOG.d_stmt) THEN
3150: PO_LOG.stmt(d_module, d_position, 'set error on index', l_index);
3151: END IF;
3152:
3153: x_line_locs.error_flag_tbl(l_index) := FND_API.g_TRUE;
3154:

Line 3163: IF (PO_LOG.d_stmt) THEN

3159: -- records
3160: IF (NOT PO_PDOI_PARAMS.g_errored_lines.EXISTS(x_line_locs.intf_line_id_tbl(l_index))) THEN
3161: d_position := 50;
3162:
3163: IF (PO_LOG.d_stmt) THEN
3164: PO_LOG.stmt(d_module, d_position, 'set error on line',
3165: x_line_locs.intf_line_id_tbl(l_index));
3166: END IF;
3167:

Line 3164: PO_LOG.stmt(d_module, d_position, 'set error on line',

3160: IF (NOT PO_PDOI_PARAMS.g_errored_lines.EXISTS(x_line_locs.intf_line_id_tbl(l_index))) THEN
3161: d_position := 50;
3162:
3163: IF (PO_LOG.d_stmt) THEN
3164: PO_LOG.stmt(d_module, d_position, 'set error on line',
3165: x_line_locs.intf_line_id_tbl(l_index));
3166: END IF;
3167:
3168: -- set corresponding line to ERROR

Line 3180: IF (PO_LOG.d_stmt) THEN

3176: IF (PO_PDOI_PARAMS.g_request.calling_module =
3177: PO_PDOI_CONSTANTS.g_call_mod_CATALOG_UPLOAD AND
3178: PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).number_of_errored_lines
3179: = PO_PDOI_PARAMS.g_request.err_lines_tolerance) THEN
3180: IF (PO_LOG.d_stmt) THEN
3181: PO_LOG.stmt(d_module, d_position, 'threshold hit on line',
3182: x_line_locs.intf_line_id_tbl(l_index));
3183: END IF;
3184:

Line 3181: PO_LOG.stmt(d_module, d_position, 'threshold hit on line',

3177: PO_PDOI_CONSTANTS.g_call_mod_CATALOG_UPLOAD AND
3178: PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).number_of_errored_lines
3179: = PO_PDOI_PARAMS.g_request.err_lines_tolerance) THEN
3180: IF (PO_LOG.d_stmt) THEN
3181: PO_LOG.stmt(d_module, d_position, 'threshold hit on line',
3182: x_line_locs.intf_line_id_tbl(l_index));
3183: END IF;
3184:
3185: PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).err_tolerance_exceeded := FND_API.g_TRUE;

Line 3212: IF (PO_LOG.d_proc) THEN

3208: AND interface_line_id = l_remove_err_line_tbl(i);
3209:
3210: d_position := 70;
3211:
3212: IF (PO_LOG.d_proc) THEN
3213: PO_LOG.proc_end (d_module);
3214: END IF;
3215:
3216: EXCEPTION

Line 3213: PO_LOG.proc_end (d_module);

3209:
3210: d_position := 70;
3211:
3212: IF (PO_LOG.d_proc) THEN
3213: PO_LOG.proc_end (d_module);
3214: END IF;
3215:
3216: EXCEPTION
3217: WHEN OTHERS THEN