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.36.12020000.5 2013/05/27 15:37:30 srpantha 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 315: IF (PO_LOG.d_proc) THEN

311: <> PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED
312: AND intf_headers.style_id = pdsh.style_id(+) -- Bug#16751944
313: ORDER BY 1;
314:
315: IF (PO_LOG.d_proc) THEN
316: PO_LOG.proc_end (d_module);
317: END IF;
318:
319: EXCEPTION

Line 316: PO_LOG.proc_end (d_module);

312: AND intf_headers.style_id = pdsh.style_id(+) -- Bug#16751944
313: ORDER BY 1;
314:
315: IF (PO_LOG.d_proc) THEN
316: PO_LOG.proc_end (d_module);
317: END IF;
318:
319: EXCEPTION
320: WHEN OTHERS THEN

Line 357: IF (PO_LOG.d_proc) THEN

353:
354: BEGIN
355: d_position := 0;
356:
357: IF (PO_LOG.d_proc) THEN
358: PO_LOG.proc_begin(d_module);
359: END IF;
360:
361: FETCH x_line_locs_csr BULK COLLECT INTO

Line 358: PO_LOG.proc_begin(d_module);

354: BEGIN
355: d_position := 0;
356:
357: IF (PO_LOG.d_proc) THEN
358: PO_LOG.proc_begin(d_module);
359: END IF;
360:
361: FETCH x_line_locs_csr BULK COLLECT INTO
362: x_line_locs.intf_line_loc_id_tbl,

Line 480: IF (PO_LOG.d_proc) THEN

476: -- set initial value for error_flag
477: x_line_locs.error_flag_tbl
478: LIMIT PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE;
479:
480: IF (PO_LOG.d_proc) THEN
481: PO_LOG.proc_end (d_module);
482: END IF;
483:
484: EXCEPTION

Line 481: PO_LOG.proc_end (d_module);

477: x_line_locs.error_flag_tbl
478: LIMIT PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE;
479:
480: IF (PO_LOG.d_proc) THEN
481: PO_LOG.proc_end (d_module);
482: END IF;
483:
484: EXCEPTION
485: WHEN OTHERS THEN

Line 539: IF (PO_LOG.d_proc) THEN

535:
536: BEGIN
537: d_position := 0;
538:
539: IF (PO_LOG.d_proc) THEN
540: PO_LOG.proc_begin(d_module, 'count', x_line_locs.rec_count);
541: END IF;
542:
543: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_DERIVE);

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

536: BEGIN
537: d_position := 0;
538:
539: IF (PO_LOG.d_proc) THEN
540: PO_LOG.proc_begin(d_module, 'count', x_line_locs.rec_count);
541: END IF;
542:
543: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_DERIVE);
544:

Line 631: IF (PO_LOG.d_stmt) THEN

627:
628: -- handle derivation errors
629: FOR i IN 1..x_line_locs.rec_count
630: LOOP
631: IF (PO_LOG.d_stmt) THEN
632: PO_LOG.stmt(d_module, d_position, 'index', i);
633: END IF;
634:
635: -- check derivation error on ship_to_organziation_id

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

628: -- handle derivation errors
629: FOR i IN 1..x_line_locs.rec_count
630: LOOP
631: IF (PO_LOG.d_stmt) THEN
632: PO_LOG.stmt(d_module, d_position, 'index', i);
633: END IF;
634:
635: -- check derivation error on ship_to_organziation_id
636: IF (x_line_locs.ship_to_org_code_tbl(i) IS NOT NULL AND

Line 638: IF (PO_LOG.d_stmt) THEN

634:
635: -- check derivation error on ship_to_organziation_id
636: IF (x_line_locs.ship_to_org_code_tbl(i) IS NOT NULL AND
637: x_line_locs.ship_to_org_id_tbl(i) IS NULL) THEN
638: IF (PO_LOG.d_stmt) THEN
639: PO_LOG.stmt(d_module, d_position, 'ship_to org id derivation failed');
640: PO_LOG.stmt(d_module, d_position, 'ship_to org', x_line_locs.ship_to_org_code_tbl(i));
641: END IF;
642:

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

635: -- check derivation error on ship_to_organziation_id
636: IF (x_line_locs.ship_to_org_code_tbl(i) IS NOT NULL AND
637: x_line_locs.ship_to_org_id_tbl(i) IS NULL) THEN
638: IF (PO_LOG.d_stmt) THEN
639: PO_LOG.stmt(d_module, d_position, 'ship_to org id derivation failed');
640: PO_LOG.stmt(d_module, d_position, 'ship_to org', x_line_locs.ship_to_org_code_tbl(i));
641: END IF;
642:
643: PO_PDOI_ERR_UTL.add_fatal_error

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

636: IF (x_line_locs.ship_to_org_code_tbl(i) IS NOT NULL AND
637: x_line_locs.ship_to_org_id_tbl(i) IS NULL) THEN
638: IF (PO_LOG.d_stmt) THEN
639: PO_LOG.stmt(d_module, d_position, 'ship_to org id derivation failed');
640: PO_LOG.stmt(d_module, d_position, 'ship_to org', x_line_locs.ship_to_org_code_tbl(i));
641: END IF;
642:
643: PO_PDOI_ERR_UTL.add_fatal_error
644: (

Line 666: IF (PO_LOG.d_stmt) THEN

662:
663: -- check derivation error for ship_to_location_id
664: IF (x_line_locs.ship_to_loc_tbl(i) IS NOT NULL AND
665: x_line_locs.ship_to_loc_id_tbl(i) IS NULL) THEN
666: IF (PO_LOG.d_stmt) THEN
667: PO_LOG.stmt(d_module, d_position, 'ship_to loc id derivation failed');
668: PO_LOG.stmt(d_module, d_position, 'ship_to loc', x_line_locs.ship_to_loc_tbl(i));
669: END IF;
670:

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

663: -- check derivation error for ship_to_location_id
664: IF (x_line_locs.ship_to_loc_tbl(i) IS NOT NULL AND
665: x_line_locs.ship_to_loc_id_tbl(i) IS NULL) THEN
666: IF (PO_LOG.d_stmt) THEN
667: PO_LOG.stmt(d_module, d_position, 'ship_to loc id derivation failed');
668: PO_LOG.stmt(d_module, d_position, 'ship_to loc', x_line_locs.ship_to_loc_tbl(i));
669: END IF;
670:
671: PO_PDOI_ERR_UTL.add_fatal_error

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

664: IF (x_line_locs.ship_to_loc_tbl(i) IS NOT NULL AND
665: x_line_locs.ship_to_loc_id_tbl(i) IS NULL) THEN
666: IF (PO_LOG.d_stmt) THEN
667: PO_LOG.stmt(d_module, d_position, 'ship_to loc id derivation failed');
668: PO_LOG.stmt(d_module, d_position, 'ship_to loc', x_line_locs.ship_to_loc_tbl(i));
669: END IF;
670:
671: PO_PDOI_ERR_UTL.add_fatal_error
672: (

Line 694: IF (PO_LOG.d_stmt) THEN

690:
691: -- check derivation error for terms_id
692: IF (x_line_locs.payment_terms_tbl(i) IS NOT NULL AND
693: x_line_locs.terms_id_tbl(i) IS NULL) THEN
694: IF (PO_LOG.d_stmt) THEN
695: PO_LOG.stmt(d_module, d_position, 'terms id derivation failed');
696: PO_LOG.stmt(d_module, d_position, 'payment terms', x_line_locs.payment_terms_tbl(i));
697: END IF;
698:

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

691: -- check derivation error for terms_id
692: IF (x_line_locs.payment_terms_tbl(i) IS NOT NULL AND
693: x_line_locs.terms_id_tbl(i) IS NULL) THEN
694: IF (PO_LOG.d_stmt) THEN
695: PO_LOG.stmt(d_module, d_position, 'terms id derivation failed');
696: PO_LOG.stmt(d_module, d_position, 'payment terms', x_line_locs.payment_terms_tbl(i));
697: END IF;
698:
699: PO_PDOI_ERR_UTL.add_fatal_error

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

692: IF (x_line_locs.payment_terms_tbl(i) IS NOT NULL AND
693: x_line_locs.terms_id_tbl(i) IS NULL) THEN
694: IF (PO_LOG.d_stmt) THEN
695: PO_LOG.stmt(d_module, d_position, 'terms id derivation failed');
696: PO_LOG.stmt(d_module, d_position, 'payment terms', x_line_locs.payment_terms_tbl(i));
697: END IF;
698:
699: PO_PDOI_ERR_UTL.add_fatal_error
700: (

Line 720: IF (PO_LOG.d_stmt) THEN

716:
717: -- check derivation error for receiving_routing_id
718: IF (x_line_locs.receiving_routing_tbl(i) IS NOT NULL AND
719: x_line_locs.receiving_routing_id_tbl(i) IS NULL) THEN
720: IF (PO_LOG.d_stmt) THEN
721: PO_LOG.stmt(d_module, d_position, 'routing id derivation failed');
722: PO_LOG.stmt(d_module, d_position, 'routing', x_line_locs.receiving_routing_tbl(i));
723: END IF;
724:

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

717: -- check derivation error for receiving_routing_id
718: IF (x_line_locs.receiving_routing_tbl(i) IS NOT NULL AND
719: x_line_locs.receiving_routing_id_tbl(i) IS NULL) THEN
720: IF (PO_LOG.d_stmt) THEN
721: PO_LOG.stmt(d_module, d_position, 'routing id derivation failed');
722: PO_LOG.stmt(d_module, d_position, 'routing', x_line_locs.receiving_routing_tbl(i));
723: END IF;
724:
725: PO_PDOI_ERR_UTL.add_fatal_error

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

718: IF (x_line_locs.receiving_routing_tbl(i) IS NOT NULL AND
719: x_line_locs.receiving_routing_id_tbl(i) IS NULL) THEN
720: IF (PO_LOG.d_stmt) THEN
721: PO_LOG.stmt(d_module, d_position, 'routing id derivation failed');
722: PO_LOG.stmt(d_module, d_position, 'routing', x_line_locs.receiving_routing_tbl(i));
723: END IF;
724:
725: PO_PDOI_ERR_UTL.add_fatal_error
726: (

Line 748: IF (PO_LOG.d_stmt) THEN

744: IF (PO_PDOI_PARAMS.g_request.document_type =
745: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
746: IF (x_line_locs.tax_code_id_tbl(i) IS NOT NULL AND
747: x_line_locs.tax_name_tbl(i) IS NULL) THEN
748: IF (PO_LOG.d_stmt) THEN
749: PO_LOG.stmt(d_module, d_position, 'tax name derivation failed');
750: PO_LOG.stmt(d_module, d_position, 'tax code id',
751: x_line_locs.tax_code_id_tbl(i));
752: END IF;

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

745: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
746: IF (x_line_locs.tax_code_id_tbl(i) IS NOT NULL AND
747: x_line_locs.tax_name_tbl(i) IS NULL) THEN
748: IF (PO_LOG.d_stmt) THEN
749: PO_LOG.stmt(d_module, d_position, 'tax name derivation failed');
750: PO_LOG.stmt(d_module, d_position, 'tax code id',
751: x_line_locs.tax_code_id_tbl(i));
752: END IF;
753:

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

746: IF (x_line_locs.tax_code_id_tbl(i) IS NOT NULL AND
747: x_line_locs.tax_name_tbl(i) IS NULL) THEN
748: IF (PO_LOG.d_stmt) THEN
749: PO_LOG.stmt(d_module, d_position, 'tax name derivation failed');
750: PO_LOG.stmt(d_module, d_position, 'tax code id',
751: x_line_locs.tax_code_id_tbl(i));
752: END IF;
753:
754: PO_PDOI_ERR_UTL.add_fatal_error

Line 777: IF (PO_LOG.d_stmt) THEN

773:
774: --< Shared Proc 14223789 Start >
775: d_position := 80;
776: FOR i IN 1..x_line_locs.rec_count LOOP
777: IF (PO_LOG.d_stmt) THEN
778: PO_LOG.stmt(d_module, d_position, 'x_line_locs.hd_doc_type_tbl(i)',
779: x_line_locs.hd_doc_type_tbl(i));
780: PO_LOG.stmt(d_module, d_position, 'x_line_locs.ship_to_org_id_tbl(i)',
781: x_line_locs.ship_to_org_id_tbl(i));

Line 778: PO_LOG.stmt(d_module, d_position, 'x_line_locs.hd_doc_type_tbl(i)',

774: --< Shared Proc 14223789 Start >
775: d_position := 80;
776: FOR i IN 1..x_line_locs.rec_count LOOP
777: IF (PO_LOG.d_stmt) THEN
778: PO_LOG.stmt(d_module, d_position, 'x_line_locs.hd_doc_type_tbl(i)',
779: x_line_locs.hd_doc_type_tbl(i));
780: PO_LOG.stmt(d_module, d_position, 'x_line_locs.ship_to_org_id_tbl(i)',
781: x_line_locs.ship_to_org_id_tbl(i));
782: PO_LOG.stmt(d_module, d_position, 'x_line_locs.txn_flow_header_id_tbl(i)',

Line 780: PO_LOG.stmt(d_module, d_position, 'x_line_locs.ship_to_org_id_tbl(i)',

776: FOR i IN 1..x_line_locs.rec_count LOOP
777: IF (PO_LOG.d_stmt) THEN
778: PO_LOG.stmt(d_module, d_position, 'x_line_locs.hd_doc_type_tbl(i)',
779: x_line_locs.hd_doc_type_tbl(i));
780: PO_LOG.stmt(d_module, d_position, 'x_line_locs.ship_to_org_id_tbl(i)',
781: x_line_locs.ship_to_org_id_tbl(i));
782: PO_LOG.stmt(d_module, d_position, 'x_line_locs.txn_flow_header_id_tbl(i)',
783: x_line_locs.txn_flow_header_id_tbl(i));
784: END IF;

Line 782: PO_LOG.stmt(d_module, d_position, 'x_line_locs.txn_flow_header_id_tbl(i)',

778: PO_LOG.stmt(d_module, d_position, 'x_line_locs.hd_doc_type_tbl(i)',
779: x_line_locs.hd_doc_type_tbl(i));
780: PO_LOG.stmt(d_module, d_position, 'x_line_locs.ship_to_org_id_tbl(i)',
781: x_line_locs.ship_to_org_id_tbl(i));
782: PO_LOG.stmt(d_module, d_position, 'x_line_locs.txn_flow_header_id_tbl(i)',
783: x_line_locs.txn_flow_header_id_tbl(i));
784: END IF;
785:
786: IF (x_line_locs.hd_doc_type_tbl(i) = 'STANDARD') AND

Line 801: IF (PO_LOG.d_stmt) THEN

797: x_is_valid => l_is_ship_to_org_valid,
798: x_in_current_sob => l_in_current_sob,
799: x_check_txn_flow => l_check_txn_flow,
800: x_transaction_flow_header_id => x_line_locs.txn_flow_header_id_tbl(i));
801: IF (PO_LOG.d_stmt) THEN
802: PO_LOG.stmt(d_module, d_position, 'x_line_locs.txn_flow_header_id_tbl(i)',
803: x_line_locs.txn_flow_header_id_tbl(i));
804: END IF;
805:

Line 802: PO_LOG.stmt(d_module, d_position, 'x_line_locs.txn_flow_header_id_tbl(i)',

798: x_in_current_sob => l_in_current_sob,
799: x_check_txn_flow => l_check_txn_flow,
800: x_transaction_flow_header_id => x_line_locs.txn_flow_header_id_tbl(i));
801: IF (PO_LOG.d_stmt) THEN
802: PO_LOG.stmt(d_module, d_position, 'x_line_locs.txn_flow_header_id_tbl(i)',
803: x_line_locs.txn_flow_header_id_tbl(i));
804: END IF;
805:
806: IF (l_return_status <> FND_API.g_ret_sts_success) OR

Line 834: IF (PO_LOG.d_proc) THEN

830: --< Shared Proc 14223789 End >
831:
832: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_DERIVE);
833:
834: IF (PO_LOG.d_proc) THEN
835: PO_LOG.proc_end (d_module);
836: END IF;
837:
838: EXCEPTION

Line 835: PO_LOG.proc_end (d_module);

831:
832: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_DERIVE);
833:
834: IF (PO_LOG.d_proc) THEN
835: PO_LOG.proc_end (d_module);
836: END IF;
837:
838: EXCEPTION
839: WHEN OTHERS THEN

Line 879: IF (PO_LOG.d_proc) THEN

875: l_index_tbl DBMS_SQL.NUMBER_TABLE;
876: BEGIN
877: d_position := 0;
878:
879: IF (PO_LOG.d_proc) THEN
880: PO_LOG.proc_begin(d_module);
881: END IF;
882:
883: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_DEFAULT);

Line 880: PO_LOG.proc_begin(d_module);

876: BEGIN
877: d_position := 0;
878:
879: IF (PO_LOG.d_proc) THEN
880: PO_LOG.proc_begin(d_module);
881: END IF;
882:
883: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_DEFAULT);
884:

Line 949: IF (PO_LOG.d_proc) THEN

945: );
946:
947: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_DEFAULT);
948:
949: IF (PO_LOG.d_proc) THEN
950: PO_LOG.proc_end (d_module);
951: END IF;
952:
953: EXCEPTION

Line 950: PO_LOG.proc_end (d_module);

946:
947: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_DEFAULT);
948:
949: IF (PO_LOG.d_proc) THEN
950: PO_LOG.proc_end (d_module);
951: END IF;
952:
953: EXCEPTION
954: WHEN OTHERS THEN

Line 997: IF (PO_LOG.d_proc) THEN

993:
994: BEGIN
995: d_position := 0;
996:
997: IF (PO_LOG.d_proc) THEN
998: PO_LOG.proc_begin(d_module);
999: END IF;
1000:
1001: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_VALIDATE);

Line 998: PO_LOG.proc_begin(d_module);

994: BEGIN
995: d_position := 0;
996:
997: IF (PO_LOG.d_proc) THEN
998: PO_LOG.proc_begin(d_module);
999: END IF;
1000:
1001: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_VALIDATE);
1002:

Line 1091: IF (PO_LOG.d_stmt) THEN

1087: d_position := 20;
1088:
1089: IF l_result_type = po_validations.c_result_type_failure THEN
1090:
1091: IF (PO_LOG.d_stmt) THEN
1092: PO_LOG.stmt(d_module, d_position, 'vaidate line locs return failure');
1093: END IF;
1094:
1095: PO_PDOI_ERR_UTL.process_val_type_errors

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

1088:
1089: IF l_result_type = po_validations.c_result_type_failure THEN
1090:
1091: IF (PO_LOG.d_stmt) THEN
1092: PO_LOG.stmt(d_module, d_position, 'vaidate line locs return failure');
1093: END IF;
1094:
1095: PO_PDOI_ERR_UTL.process_val_type_errors
1096: (

Line 1112: IF (PO_LOG.d_stmt) THEN

1108: );
1109: END IF;
1110:
1111: IF l_result_type = po_validations.c_result_type_fatal THEN
1112: IF (PO_LOG.d_stmt) THEN
1113: PO_LOG.stmt(d_module, d_position, 'vaidate line locs return fatal');
1114: END IF;
1115:
1116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1109: END IF;
1110:
1111: IF l_result_type = po_validations.c_result_type_fatal THEN
1112: IF (PO_LOG.d_stmt) THEN
1113: PO_LOG.stmt(d_module, d_position, 'vaidate line locs return fatal');
1114: END IF;
1115:
1116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1117: END IF;

Line 1121: IF (PO_LOG.d_proc) THEN

1117: END IF;
1118:
1119: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_VALIDATE);
1120:
1121: IF (PO_LOG.d_proc) THEN
1122: PO_LOG.proc_end (d_module);
1123: END IF;
1124:
1125: EXCEPTION

Line 1122: PO_LOG.proc_end (d_module);

1118:
1119: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_VALIDATE);
1120:
1121: IF (PO_LOG.d_proc) THEN
1122: PO_LOG.proc_end (d_module);
1123: END IF;
1124:
1125: EXCEPTION
1126: WHEN OTHERS THEN

Line 1170: IF (PO_LOG.d_proc) THEN

1166:
1167: BEGIN
1168: d_position := 0;
1169:
1170: IF (PO_LOG.d_proc) THEN
1171: PO_LOG.proc_begin(d_module, 'p_intf_line_loc_id_tbl', p_intf_line_loc_id_tbl);
1172: PO_LOG.proc_begin(d_module, 'p_line_loc_id_tbl', p_line_loc_id_tbl);
1173: PO_LOG.proc_begin(d_module, 'p_error_flag_tbl', p_error_flag_tbl);
1174: END IF;

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

1167: BEGIN
1168: d_position := 0;
1169:
1170: IF (PO_LOG.d_proc) THEN
1171: PO_LOG.proc_begin(d_module, 'p_intf_line_loc_id_tbl', p_intf_line_loc_id_tbl);
1172: PO_LOG.proc_begin(d_module, 'p_line_loc_id_tbl', p_line_loc_id_tbl);
1173: PO_LOG.proc_begin(d_module, 'p_error_flag_tbl', p_error_flag_tbl);
1174: END IF;
1175:

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

1168: d_position := 0;
1169:
1170: IF (PO_LOG.d_proc) THEN
1171: PO_LOG.proc_begin(d_module, 'p_intf_line_loc_id_tbl', p_intf_line_loc_id_tbl);
1172: PO_LOG.proc_begin(d_module, 'p_line_loc_id_tbl', p_line_loc_id_tbl);
1173: PO_LOG.proc_begin(d_module, 'p_error_flag_tbl', p_error_flag_tbl);
1174: END IF;
1175:
1176: -- update line_location_interface table with the new line_location_id

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

1169:
1170: IF (PO_LOG.d_proc) THEN
1171: PO_LOG.proc_begin(d_module, 'p_intf_line_loc_id_tbl', p_intf_line_loc_id_tbl);
1172: PO_LOG.proc_begin(d_module, 'p_line_loc_id_tbl', p_line_loc_id_tbl);
1173: PO_LOG.proc_begin(d_module, 'p_error_flag_tbl', p_error_flag_tbl);
1174: END IF;
1175:
1176: -- update line_location_interface table with the new line_location_id
1177: FORALL i IN 1..p_intf_line_loc_id_tbl.COUNT

Line 1184: IF (PO_LOG.d_proc) THEN

1180: process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_ACCEPTED
1181: WHERE interface_line_location_id = p_intf_line_loc_id_tbl(i)
1182: AND p_error_flag_tbl(i) = FND_API.g_FALSE;
1183:
1184: IF (PO_LOG.d_proc) THEN
1185: PO_LOG.proc_end (d_module);
1186: END IF;
1187:
1188: EXCEPTION

Line 1185: PO_LOG.proc_end (d_module);

1181: WHERE interface_line_location_id = p_intf_line_loc_id_tbl(i)
1182: AND p_error_flag_tbl(i) = FND_API.g_FALSE;
1183:
1184: IF (PO_LOG.d_proc) THEN
1185: PO_LOG.proc_end (d_module);
1186: END IF;
1187:
1188: EXCEPTION
1189: WHEN OTHERS THEN

Line 1229: IF (PO_LOG.d_proc) THEN

1225:
1226: BEGIN
1227: d_position := 0;
1228:
1229: IF (PO_LOG.d_proc) THEN
1230: PO_LOG.proc_begin(d_module);
1231: END IF;
1232:
1233: FORALL i IN 1..p_po_line_id_tbl.COUNT

Line 1230: PO_LOG.proc_begin(d_module);

1226: BEGIN
1227: d_position := 0;
1228:
1229: IF (PO_LOG.d_proc) THEN
1230: PO_LOG.proc_begin(d_module);
1231: END IF;
1232:
1233: FORALL i IN 1..p_po_line_id_tbl.COUNT
1234: --Bug# 10607851 : Included the secondary quantity in update statment to sum up at line level

Line 1249: IF (PO_LOG.d_proc) THEN

1245: -- PDOI for Complex PO Project
1246: WHERE po_line_id = p_po_line_id_tbl(i)
1247: AND draft_id = p_draft_id_tbl(i);
1248:
1249: IF (PO_LOG.d_proc) THEN
1250: PO_LOG.proc_end (d_module);
1251: END IF;
1252:
1253: EXCEPTION

Line 1250: PO_LOG.proc_end (d_module);

1246: WHERE po_line_id = p_po_line_id_tbl(i)
1247: AND draft_id = p_draft_id_tbl(i);
1248:
1249: IF (PO_LOG.d_proc) THEN
1250: PO_LOG.proc_end (d_module);
1251: END IF;
1252:
1253: EXCEPTION
1254: WHEN OTHERS THEN

Line 1302: IF (PO_LOG.d_proc) THEN

1298: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
1299: BEGIN
1300: d_position := 0;
1301:
1302: IF (PO_LOG.d_proc) THEN
1303: PO_LOG.proc_begin(d_module);
1304: END IF;
1305:
1306: l_key := PO_CORE_S.get_session_gt_nextval;

Line 1303: PO_LOG.proc_begin(d_module);

1299: BEGIN
1300: d_position := 0;
1301:
1302: IF (PO_LOG.d_proc) THEN
1303: PO_LOG.proc_begin(d_module);
1304: END IF;
1305:
1306: l_key := PO_CORE_S.get_session_gt_nextval;
1307:

Line 1337: IF (PO_LOG.d_proc) THEN

1333: p_delete_flag_tbl => l_delete_flag_tbl,
1334: x_record_already_exist_tbl => l_record_already_exist_tbl
1335: );
1336:
1337: IF (PO_LOG.d_proc) THEN
1338: PO_LOG.proc_end (d_module);
1339: END IF;
1340:
1341: EXCEPTION

Line 1338: PO_LOG.proc_end (d_module);

1334: x_record_already_exist_tbl => l_record_already_exist_tbl
1335: );
1336:
1337: IF (PO_LOG.d_proc) THEN
1338: PO_LOG.proc_end (d_module);
1339: END IF;
1340:
1341: EXCEPTION
1342: WHEN OTHERS THEN

Line 1397: IF (PO_LOG.d_proc) THEN

1393: l_result_tbl PO_TBL_NUMBER;
1394: BEGIN
1395: d_position := 0;
1396:
1397: IF (PO_LOG.d_proc) THEN
1398: PO_LOG.proc_begin(d_module, 'p_po_line_id_tbl', p_po_line_id_tbl);
1399: PO_LOG.proc_begin(d_module, 'p_shipment_num_tbl', p_shipment_num_tbl);
1400: PO_LOG.proc_begin(d_module, 'x_line_loc_id_tbl', x_line_loc_id_tbl);
1401: END IF;

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

1394: BEGIN
1395: d_position := 0;
1396:
1397: IF (PO_LOG.d_proc) THEN
1398: PO_LOG.proc_begin(d_module, 'p_po_line_id_tbl', p_po_line_id_tbl);
1399: PO_LOG.proc_begin(d_module, 'p_shipment_num_tbl', p_shipment_num_tbl);
1400: PO_LOG.proc_begin(d_module, 'x_line_loc_id_tbl', x_line_loc_id_tbl);
1401: END IF;
1402:

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

1395: d_position := 0;
1396:
1397: IF (PO_LOG.d_proc) THEN
1398: PO_LOG.proc_begin(d_module, 'p_po_line_id_tbl', p_po_line_id_tbl);
1399: PO_LOG.proc_begin(d_module, 'p_shipment_num_tbl', p_shipment_num_tbl);
1400: PO_LOG.proc_begin(d_module, 'x_line_loc_id_tbl', x_line_loc_id_tbl);
1401: END IF;
1402:
1403: -- run query to extract line_location_id

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

1396:
1397: IF (PO_LOG.d_proc) THEN
1398: PO_LOG.proc_begin(d_module, 'p_po_line_id_tbl', p_po_line_id_tbl);
1399: PO_LOG.proc_begin(d_module, 'p_shipment_num_tbl', p_shipment_num_tbl);
1400: PO_LOG.proc_begin(d_module, 'x_line_loc_id_tbl', x_line_loc_id_tbl);
1401: END IF;
1402:
1403: -- run query to extract line_location_id
1404: FORALL i IN 1..p_index_tbl.COUNT

Line 1428: IF (PO_LOG.d_stmt) THEN

1424:
1425: -- push the result back to x_line_loc_id_tbl
1426: FOR i IN 1..l_index_tbl.COUNT
1427: LOOP
1428: IF (PO_LOG.d_stmt) THEN
1429: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
1430: PO_LOG.stmt(d_module, d_position, 'new line loc id', l_result_tbl(i));
1431: END IF;
1432:

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

1425: -- push the result back to x_line_loc_id_tbl
1426: FOR i IN 1..l_index_tbl.COUNT
1427: LOOP
1428: IF (PO_LOG.d_stmt) THEN
1429: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
1430: PO_LOG.stmt(d_module, d_position, 'new line loc id', l_result_tbl(i));
1431: END IF;
1432:
1433: x_line_loc_id_tbl(l_index_tbl(i)) := l_result_tbl(i);

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

1426: FOR i IN 1..l_index_tbl.COUNT
1427: LOOP
1428: IF (PO_LOG.d_stmt) THEN
1429: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
1430: PO_LOG.stmt(d_module, d_position, 'new line loc id', l_result_tbl(i));
1431: END IF;
1432:
1433: x_line_loc_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
1434: END LOOP;

Line 1436: IF (PO_LOG.d_proc) THEN

1432:
1433: x_line_loc_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
1434: END LOOP;
1435:
1436: IF (PO_LOG.d_proc) THEN
1437: PO_LOG.proc_end (d_module);
1438: END IF;
1439:
1440: EXCEPTION

Line 1437: PO_LOG.proc_end (d_module);

1433: x_line_loc_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
1434: END LOOP;
1435:
1436: IF (PO_LOG.d_proc) THEN
1437: PO_LOG.proc_end (d_module);
1438: END IF;
1439:
1440: EXCEPTION
1441: WHEN OTHERS THEN

Line 1489: IF (PO_LOG.d_proc) THEN

1485: l_result_tbl PO_TBL_NUMBER;
1486: BEGIN
1487: d_position := 0;
1488:
1489: IF (PO_LOG.d_proc) THEN
1490: PO_LOG.proc_begin(d_module, 'p_ship_to_org_code_tbl', p_ship_to_org_code_tbl);
1491: PO_LOG.proc_begin(d_module, 'x_ship_to_org_id_tbl', x_ship_to_org_id_tbl);
1492: END IF;
1493:

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

1486: BEGIN
1487: d_position := 0;
1488:
1489: IF (PO_LOG.d_proc) THEN
1490: PO_LOG.proc_begin(d_module, 'p_ship_to_org_code_tbl', p_ship_to_org_code_tbl);
1491: PO_LOG.proc_begin(d_module, 'x_ship_to_org_id_tbl', x_ship_to_org_id_tbl);
1492: END IF;
1493:
1494: -- execute query to extract org_id from org_code

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

1487: d_position := 0;
1488:
1489: IF (PO_LOG.d_proc) THEN
1490: PO_LOG.proc_begin(d_module, 'p_ship_to_org_code_tbl', p_ship_to_org_code_tbl);
1491: PO_LOG.proc_begin(d_module, 'x_ship_to_org_id_tbl', x_ship_to_org_id_tbl);
1492: END IF;
1493:
1494: -- execute query to extract org_id from org_code
1495: FORALL i IN 1.. p_index_tbl.COUNT

Line 1519: IF (PO_LOG.d_stmt) THEN

1515:
1516: -- set derived result in x_ship_to_org_id_tbl
1517: FOR i IN 1..l_index_tbl.COUNT
1518: LOOP
1519: IF (PO_LOG.d_stmt) THEN
1520: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
1521: PO_LOG.stmt(d_module, d_position, 'new ship_to org id', l_result_tbl(i));
1522: END IF;
1523:

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

1516: -- set derived result in x_ship_to_org_id_tbl
1517: FOR i IN 1..l_index_tbl.COUNT
1518: LOOP
1519: IF (PO_LOG.d_stmt) THEN
1520: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
1521: PO_LOG.stmt(d_module, d_position, 'new ship_to org id', l_result_tbl(i));
1522: END IF;
1523:
1524: x_ship_to_org_id_tbl(l_index_tbl(i)) := l_result_tbl(i);

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

1517: FOR i IN 1..l_index_tbl.COUNT
1518: LOOP
1519: IF (PO_LOG.d_stmt) THEN
1520: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
1521: PO_LOG.stmt(d_module, d_position, 'new ship_to org id', l_result_tbl(i));
1522: END IF;
1523:
1524: x_ship_to_org_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
1525: END LOOP;

Line 1527: IF (PO_LOG.d_proc) THEN

1523:
1524: x_ship_to_org_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
1525: END LOOP;
1526:
1527: IF (PO_LOG.d_proc) THEN
1528: PO_LOG.proc_end (d_module);
1529: END IF;
1530:
1531: EXCEPTION

Line 1528: PO_LOG.proc_end (d_module);

1524: x_ship_to_org_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
1525: END LOOP;
1526:
1527: IF (PO_LOG.d_proc) THEN
1528: PO_LOG.proc_end (d_module);
1529: END IF;
1530:
1531: EXCEPTION
1532: WHEN OTHERS THEN

Line 1580: IF (PO_LOG.d_proc) THEN

1576: l_result_tbl PO_TBL_NUMBER;
1577: BEGIN
1578: d_position := 0;
1579:
1580: IF (PO_LOG.d_proc) THEN
1581: PO_LOG.proc_begin(d_module, 'p_receiving_routing_tbl',
1582: p_receiving_routing_tbl);
1583: PO_LOG.proc_begin(d_module, 'x_receiving_routing_id_tbl',
1584: x_receiving_routing_id_tbl);

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

1577: BEGIN
1578: d_position := 0;
1579:
1580: IF (PO_LOG.d_proc) THEN
1581: PO_LOG.proc_begin(d_module, 'p_receiving_routing_tbl',
1582: p_receiving_routing_tbl);
1583: PO_LOG.proc_begin(d_module, 'x_receiving_routing_id_tbl',
1584: x_receiving_routing_id_tbl);
1585: END IF;

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

1579:
1580: IF (PO_LOG.d_proc) THEN
1581: PO_LOG.proc_begin(d_module, 'p_receiving_routing_tbl',
1582: p_receiving_routing_tbl);
1583: PO_LOG.proc_begin(d_module, 'x_receiving_routing_id_tbl',
1584: x_receiving_routing_id_tbl);
1585: END IF;
1586:
1587: -- execute query to extract routing_id from receiving_routings

Line 1610: IF (PO_LOG.d_stmt) THEN

1606:
1607: -- set derived result in x_receiving_routing_id_tbl
1608: FOR i IN 1..l_index_tbl.COUNT
1609: LOOP
1610: IF (PO_LOG.d_stmt) THEN
1611: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
1612: PO_LOG.stmt(d_module, d_position, 'new routing id', l_result_tbl(i));
1613: END IF;
1614:

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

1607: -- set derived result in x_receiving_routing_id_tbl
1608: FOR i IN 1..l_index_tbl.COUNT
1609: LOOP
1610: IF (PO_LOG.d_stmt) THEN
1611: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
1612: PO_LOG.stmt(d_module, d_position, 'new routing id', l_result_tbl(i));
1613: END IF;
1614:
1615: x_receiving_routing_id_tbl(l_index_tbl(i)) := l_result_tbl(i);

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

1608: FOR i IN 1..l_index_tbl.COUNT
1609: LOOP
1610: IF (PO_LOG.d_stmt) THEN
1611: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
1612: PO_LOG.stmt(d_module, d_position, 'new routing id', l_result_tbl(i));
1613: END IF;
1614:
1615: x_receiving_routing_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
1616: END LOOP;

Line 1618: IF (PO_LOG.d_proc) THEN

1614:
1615: x_receiving_routing_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
1616: END LOOP;
1617:
1618: IF (PO_LOG.d_proc) THEN
1619: PO_LOG.proc_end (d_module);
1620: END IF;
1621:
1622: EXCEPTION

Line 1619: PO_LOG.proc_end (d_module);

1615: x_receiving_routing_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
1616: END LOOP;
1617:
1618: IF (PO_LOG.d_proc) THEN
1619: PO_LOG.proc_end (d_module);
1620: END IF;
1621:
1622: EXCEPTION
1623: WHEN OTHERS THEN

Line 1671: IF (PO_LOG.d_proc) THEN

1667: l_result_tbl PO_TBL_VARCHAR30;
1668: BEGIN
1669: d_position := 0;
1670:
1671: IF (PO_LOG.d_proc) THEN
1672: PO_LOG.proc_begin(d_module, 'p_tax_code_id_tbl',
1673: p_tax_code_id_tbl);
1674: PO_LOG.proc_begin(d_module, 'x_tax_name_tbl',
1675: x_tax_name_tbl);

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

1668: BEGIN
1669: d_position := 0;
1670:
1671: IF (PO_LOG.d_proc) THEN
1672: PO_LOG.proc_begin(d_module, 'p_tax_code_id_tbl',
1673: p_tax_code_id_tbl);
1674: PO_LOG.proc_begin(d_module, 'x_tax_name_tbl',
1675: x_tax_name_tbl);
1676: END IF;

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

1670:
1671: IF (PO_LOG.d_proc) THEN
1672: PO_LOG.proc_begin(d_module, 'p_tax_code_id_tbl',
1673: p_tax_code_id_tbl);
1674: PO_LOG.proc_begin(d_module, 'x_tax_name_tbl',
1675: x_tax_name_tbl);
1676: END IF;
1677:
1678: -- execute query to extract tax_name from tax_code_id

Line 1704: IF (PO_LOG.d_stmt) THEN

1700:
1701: -- set derived result in x_receiving_routing_id_tbl
1702: FOR i IN 1..l_index_tbl.COUNT
1703: LOOP
1704: IF (PO_LOG.d_stmt) THEN
1705: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
1706: PO_LOG.stmt(d_module, d_position, 'new tax_name', l_result_tbl(i));
1707: END IF;
1708:

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

1701: -- set derived result in x_receiving_routing_id_tbl
1702: FOR i IN 1..l_index_tbl.COUNT
1703: LOOP
1704: IF (PO_LOG.d_stmt) THEN
1705: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
1706: PO_LOG.stmt(d_module, d_position, 'new tax_name', l_result_tbl(i));
1707: END IF;
1708:
1709: x_tax_name_tbl(l_index_tbl(i)) := l_result_tbl(i);

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

1702: FOR i IN 1..l_index_tbl.COUNT
1703: LOOP
1704: IF (PO_LOG.d_stmt) THEN
1705: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
1706: PO_LOG.stmt(d_module, d_position, 'new tax_name', l_result_tbl(i));
1707: END IF;
1708:
1709: x_tax_name_tbl(l_index_tbl(i)) := l_result_tbl(i);
1710: END LOOP;

Line 1712: IF (PO_LOG.d_proc) THEN

1708:
1709: x_tax_name_tbl(l_index_tbl(i)) := l_result_tbl(i);
1710: END LOOP;
1711:
1712: IF (PO_LOG.d_proc) THEN
1713: PO_LOG.proc_end (d_module);
1714: END IF;
1715:
1716: EXCEPTION

Line 1713: PO_LOG.proc_end (d_module);

1709: x_tax_name_tbl(l_index_tbl(i)) := l_result_tbl(i);
1710: END LOOP;
1711:
1712: IF (PO_LOG.d_proc) THEN
1713: PO_LOG.proc_end (d_module);
1714: END IF;
1715:
1716: EXCEPTION
1717: WHEN OTHERS THEN

Line 1760: IF (PO_LOG.d_proc) THEN

1756: l_result_tbl PO_TBL_NUMBER;
1757: BEGIN
1758: d_position := 0;
1759:
1760: IF (PO_LOG.d_proc) THEN
1761: PO_LOG.proc_begin(d_module, 'p_item_id_tbl', p_item_id_tbl);
1762: PO_LOG.proc_begin(d_module, 'p_ship_to_organization_id_tbl', p_ship_to_organization_id_tbl);
1763: END IF;
1764:

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

1757: BEGIN
1758: d_position := 0;
1759:
1760: IF (PO_LOG.d_proc) THEN
1761: PO_LOG.proc_begin(d_module, 'p_item_id_tbl', p_item_id_tbl);
1762: PO_LOG.proc_begin(d_module, 'p_ship_to_organization_id_tbl', p_ship_to_organization_id_tbl);
1763: END IF;
1764:
1765: FOR i IN 1..p_item_id_tbl.COUNT LOOP

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

1758: d_position := 0;
1759:
1760: IF (PO_LOG.d_proc) THEN
1761: PO_LOG.proc_begin(d_module, 'p_item_id_tbl', p_item_id_tbl);
1762: PO_LOG.proc_begin(d_module, 'p_ship_to_organization_id_tbl', p_ship_to_organization_id_tbl);
1763: END IF;
1764:
1765: FOR i IN 1..p_item_id_tbl.COUNT LOOP
1766: x_outsourced_assembly_tbl(i) :=

Line 1773: IF (PO_LOG.d_proc) THEN

1769: p_ship_to_org_id => p_ship_to_organization_id_tbl(i)
1770: );
1771: END LOOP;
1772:
1773: IF (PO_LOG.d_proc) THEN
1774: PO_LOG.proc_end (d_module);
1775: END IF;
1776:
1777: EXCEPTION

Line 1774: PO_LOG.proc_end (d_module);

1770: );
1771: END LOOP;
1772:
1773: IF (PO_LOG.d_proc) THEN
1774: PO_LOG.proc_end (d_module);
1775: END IF;
1776:
1777: EXCEPTION
1778: WHEN OTHERS THEN

Line 1831: IF (PO_LOG.d_proc) THEN

1827:
1828: BEGIN
1829: d_position := 0;
1830:
1831: IF (PO_LOG.d_proc) THEN
1832: PO_LOG.proc_begin(d_module);
1833: END IF;
1834:
1835: -- default inspection_required_flag from item_id

Line 1832: PO_LOG.proc_begin(d_module);

1828: BEGIN
1829: d_position := 0;
1830:
1831: IF (PO_LOG.d_proc) THEN
1832: PO_LOG.proc_begin(d_module);
1833: END IF;
1834:
1835: -- default inspection_required_flag from item_id
1836: default_inspect_required_flag

Line 1849: IF (PO_LOG.d_stmt) THEN

1845:
1846: -- default attribute on each record
1847: FOR i IN 1..x_line_locs.rec_count
1848: LOOP
1849: IF (PO_LOG.d_stmt) THEN
1850: PO_LOG.stmt(d_module, d_position, 'default for spo index', i);
1851: END IF;
1852:
1853: -- default shipment_type

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

1846: -- default attribute on each record
1847: FOR i IN 1..x_line_locs.rec_count
1848: LOOP
1849: IF (PO_LOG.d_stmt) THEN
1850: PO_LOG.stmt(d_module, d_position, 'default for spo index', i);
1851: END IF;
1852:
1853: -- default shipment_type
1854: x_line_locs.shipment_type_tbl(i) :=

Line 1866: IF (PO_LOG.d_stmt) THEN

1862: (
1863: p_po_line_id => x_line_locs.ln_po_line_id_tbl(i)
1864: );
1865:
1866: IF (PO_LOG.d_stmt) THEN
1867: PO_LOG.stmt(d_module, d_position, 'default shipment num',
1868: x_line_locs.shipment_num_tbl(i));
1869: END IF;
1870: END IF;

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

1863: p_po_line_id => x_line_locs.ln_po_line_id_tbl(i)
1864: );
1865:
1866: IF (PO_LOG.d_stmt) THEN
1867: PO_LOG.stmt(d_module, d_position, 'default shipment num',
1868: x_line_locs.shipment_num_tbl(i));
1869: END IF;
1870: END IF;
1871:

Line 1877: IF (PO_LOG.d_stmt) THEN

1873: IF (x_line_locs.line_loc_id_tbl(i) IS NULL) THEN
1874: x_line_locs.line_loc_id_tbl(i) :=
1875: PO_PDOI_MAINPROC_UTL_PVT.get_next_line_loc_id;
1876:
1877: IF (PO_LOG.d_stmt) THEN
1878: PO_LOG.stmt(d_module, d_position, 'default line loc',
1879: x_line_locs.line_loc_id_tbl(i));
1880: END IF;
1881: END IF;

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

1874: x_line_locs.line_loc_id_tbl(i) :=
1875: PO_PDOI_MAINPROC_UTL_PVT.get_next_line_loc_id;
1876:
1877: IF (PO_LOG.d_stmt) THEN
1878: PO_LOG.stmt(d_module, d_position, 'default line loc',
1879: x_line_locs.line_loc_id_tbl(i));
1880: END IF;
1881: END IF;
1882:

Line 1911: IF (PO_LOG.d_stmt) THEN

1907: EXCEPTION
1908: WHEN OTHERS THEN
1909: l_receipt_req_flag_temp := NULL;
1910: l_insp_req_flag_temp := NULL;
1911: IF (PO_LOG.d_stmt) THEN
1912: PO_LOG.stmt(d_module, d_position, 'Exception',
1913: SQLERRM);
1914: END IF;
1915: END;

Line 1912: PO_LOG.stmt(d_module, d_position, 'Exception',

1908: WHEN OTHERS THEN
1909: l_receipt_req_flag_temp := NULL;
1910: l_insp_req_flag_temp := NULL;
1911: IF (PO_LOG.d_stmt) THEN
1912: PO_LOG.stmt(d_module, d_position, 'Exception',
1913: SQLERRM);
1914: END IF;
1915: END;
1916: --Ended code addition for bug 13905609

Line 1967: IF (PO_LOG.d_stmt) THEN

1963:
1964: -- another loop to default based on defaulted ship_to_organization_id
1965: FOR i IN 1..x_line_locs.rec_count
1966: LOOP
1967: IF (PO_LOG.d_stmt) THEN
1968: PO_LOG.stmt(d_module, d_position, 'second default index', i);
1969: END IF;
1970:
1971: -- default ship_to_organization_id from financial system parameter

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

1964: -- another loop to default based on defaulted ship_to_organization_id
1965: FOR i IN 1..x_line_locs.rec_count
1966: LOOP
1967: IF (PO_LOG.d_stmt) THEN
1968: PO_LOG.stmt(d_module, d_position, 'second default index', i);
1969: END IF;
1970:
1971: -- default ship_to_organization_id from financial system parameter
1972: -- for STANDARD

Line 1977: IF (PO_LOG.d_stmt) THEN

1973: x_line_locs.ship_to_org_id_tbl(i) :=
1974: NVL(x_line_locs.ship_to_org_id_tbl(i),
1975: PO_PDOI_PARAMS.g_sys.def_inv_org_id);
1976:
1977: IF (PO_LOG.d_stmt) THEN
1978: PO_LOG.stmt(d_module, d_position, 'ship_to org id',
1979: x_line_locs.ship_to_org_id_tbl(i));
1980: END IF;
1981:

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

1974: NVL(x_line_locs.ship_to_org_id_tbl(i),
1975: PO_PDOI_PARAMS.g_sys.def_inv_org_id);
1976:
1977: IF (PO_LOG.d_stmt) THEN
1978: PO_LOG.stmt(d_module, d_position, 'ship_to org id',
1979: x_line_locs.ship_to_org_id_tbl(i));
1980: END IF;
1981:
1982: d_position := 40;

Line 2012: IF (PO_LOG.d_stmt) THEN

2008: -- default qty_rcv_exception_code from receiving controls
2009: x_line_locs.qty_rcv_exception_code_tbl(i) :=
2010: NVL(x_line_locs.qty_rcv_exception_code_tbl(i), l_qty_rcv_exception);
2011:
2012: IF (PO_LOG.d_stmt) THEN
2013: PO_LOG.stmt(d_module, d_position, 'order type',
2014: x_line_locs.ln_order_type_lookup_code_tbl(i));
2015: END IF;
2016:

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

2009: x_line_locs.qty_rcv_exception_code_tbl(i) :=
2010: NVL(x_line_locs.qty_rcv_exception_code_tbl(i), l_qty_rcv_exception);
2011:
2012: IF (PO_LOG.d_stmt) THEN
2013: PO_LOG.stmt(d_module, d_position, 'order type',
2014: x_line_locs.ln_order_type_lookup_code_tbl(i));
2015: END IF;
2016:
2017: -- set the other attributes based on order_type

Line 2110: IF (PO_LOG.d_proc) THEN

2106: p_ship_to_org_id_tbl => x_line_locs.ship_to_org_id_tbl,
2107: x_secondary_unit_of_meas_tbl => x_line_locs.secondary_unit_of_meas_tbl
2108: );
2109:
2110: IF (PO_LOG.d_proc) THEN
2111: PO_LOG.proc_end (d_module);
2112: END IF;
2113:
2114: EXCEPTION

Line 2111: PO_LOG.proc_end (d_module);

2107: x_secondary_unit_of_meas_tbl => x_line_locs.secondary_unit_of_meas_tbl
2108: );
2109:
2110: IF (PO_LOG.d_proc) THEN
2111: PO_LOG.proc_end (d_module);
2112: END IF;
2113:
2114: EXCEPTION
2115: WHEN OTHERS THEN

Line 2160: IF (PO_LOG.d_proc) THEN

2156:
2157: BEGIN
2158: d_position := 0;
2159:
2160: IF (PO_LOG.d_proc) THEN
2161: PO_LOG.proc_begin(d_module);
2162: END IF;
2163:
2164: -- default ship_to_organization_id from ship_to_location_id

Line 2161: PO_LOG.proc_begin(d_module);

2157: BEGIN
2158: d_position := 0;
2159:
2160: IF (PO_LOG.d_proc) THEN
2161: PO_LOG.proc_begin(d_module);
2162: END IF;
2163:
2164: -- default ship_to_organization_id from ship_to_location_id
2165: default_ship_to_org_id

Line 2178: IF (PO_LOG.d_stmt) THEN

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

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

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

Line 2201: IF (PO_LOG.d_stmt) THEN

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

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

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

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

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

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

2202: PO_LOG.stmt(d_module, d_position, 'shipment type',
2203: x_line_locs.shipment_type_tbl(i));
2204: PO_LOG.stmt(d_module, d_position, 'shipment num',
2205: x_line_locs.shipment_num_tbl(i));
2206: PO_LOG.stmt(d_module, d_position, 'line loc id',
2207: x_line_locs.line_loc_id_tbl(i));
2208: END IF;
2209:
2210: -- set accrue_on_receipt_flag and firm_flag to NULL

Line 2248: IF (PO_LOG.d_proc) THEN

2244: -- set outsourced_assembly to 2 since it is a required field
2245: x_line_locs.outsourced_assembly_tbl(i) := 2;
2246: END LOOP;
2247:
2248: IF (PO_LOG.d_proc) THEN
2249: PO_LOG.proc_end (d_module);
2250: END IF;
2251:
2252: EXCEPTION

Line 2249: PO_LOG.proc_end (d_module);

2245: x_line_locs.outsourced_assembly_tbl(i) := 2;
2246: END LOOP;
2247:
2248: IF (PO_LOG.d_proc) THEN
2249: PO_LOG.proc_end (d_module);
2250: END IF;
2251:
2252: EXCEPTION
2253: WHEN OTHERS THEN

Line 2306: IF (PO_LOG.d_proc) THEN

2302:
2303: BEGIN
2304: d_position := 0;
2305:
2306: IF (PO_LOG.d_proc) THEN
2307: PO_LOG.proc_begin(d_module);
2308: END IF;
2309:
2310: -- default inspection_required_flag from item_id

Line 2307: PO_LOG.proc_begin(d_module);

2303: BEGIN
2304: d_position := 0;
2305:
2306: IF (PO_LOG.d_proc) THEN
2307: PO_LOG.proc_begin(d_module);
2308: END IF;
2309:
2310: -- default inspection_required_flag from item_id
2311: default_inspect_required_flag

Line 2335: IF (PO_LOG.d_stmt) THEN

2331:
2332: -- default on row by row base
2333: FOR i IN 1..x_line_locs.rec_count
2334: LOOP
2335: IF (PO_LOG.d_stmt) THEN
2336: PO_LOG.stmt(d_module, d_position, 'default for quotation index', i);
2337: END IF;
2338:
2339: -- bug5307208

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

2332: -- default on row by row base
2333: FOR i IN 1..x_line_locs.rec_count
2334: LOOP
2335: IF (PO_LOG.d_stmt) THEN
2336: PO_LOG.stmt(d_module, d_position, 'default for quotation index', i);
2337: END IF;
2338:
2339: -- bug5307208
2340: -- Truncate start/end date of the price breaks

Line 2358: IF (PO_LOG.d_stmt) THEN

2354: x_line_locs.line_loc_id_tbl(i) :=
2355: NVL(x_line_locs.line_loc_id_tbl(i),
2356: PO_PDOI_MAINPROC_UTL_PVT.get_next_line_loc_id);
2357:
2358: IF (PO_LOG.d_stmt) THEN
2359: PO_LOG.stmt(d_module, d_position, 'shipment type',
2360: x_line_locs.shipment_type_tbl(i));
2361: PO_LOG.stmt(d_module, d_position, 'shipment num',
2362: x_line_locs.shipment_num_tbl(i));

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

2355: NVL(x_line_locs.line_loc_id_tbl(i),
2356: PO_PDOI_MAINPROC_UTL_PVT.get_next_line_loc_id);
2357:
2358: IF (PO_LOG.d_stmt) THEN
2359: PO_LOG.stmt(d_module, d_position, 'shipment type',
2360: x_line_locs.shipment_type_tbl(i));
2361: PO_LOG.stmt(d_module, d_position, 'shipment num',
2362: x_line_locs.shipment_num_tbl(i));
2363: PO_LOG.stmt(d_module, d_position, 'line loc id',

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

2357:
2358: IF (PO_LOG.d_stmt) THEN
2359: PO_LOG.stmt(d_module, d_position, 'shipment type',
2360: x_line_locs.shipment_type_tbl(i));
2361: PO_LOG.stmt(d_module, d_position, 'shipment num',
2362: x_line_locs.shipment_num_tbl(i));
2363: PO_LOG.stmt(d_module, d_position, 'line loc id',
2364: x_line_locs.line_loc_id_tbl(i));
2365: END IF;

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

2359: PO_LOG.stmt(d_module, d_position, 'shipment type',
2360: x_line_locs.shipment_type_tbl(i));
2361: PO_LOG.stmt(d_module, d_position, 'shipment num',
2362: x_line_locs.shipment_num_tbl(i));
2363: PO_LOG.stmt(d_module, d_position, 'line loc id',
2364: x_line_locs.line_loc_id_tbl(i));
2365: END IF;
2366:
2367: -- default terms_id from header,

Line 2397: IF (PO_LOG.d_stmt) THEN

2393: EXCEPTION
2394: WHEN OTHERS THEN
2395: l_receipt_req_flag_temp := NULL;
2396: l_insp_req_flag_temp := NULL;
2397: IF (PO_LOG.d_stmt) THEN
2398: PO_LOG.stmt(d_module, d_position, 'Exception',
2399: SQLERRM);
2400: END IF;
2401: END;

Line 2398: PO_LOG.stmt(d_module, d_position, 'Exception',

2394: WHEN OTHERS THEN
2395: l_receipt_req_flag_temp := NULL;
2396: l_insp_req_flag_temp := NULL;
2397: IF (PO_LOG.d_stmt) THEN
2398: PO_LOG.stmt(d_module, d_position, 'Exception',
2399: SQLERRM);
2400: END IF;
2401: END;
2402: --Ended code addition for bug 13905609

Line 2458: IF (PO_LOG.d_stmt) THEN

2454: -- default qty_rcv_exception_code from receiving controls
2455: x_line_locs.qty_rcv_exception_code_tbl(i) :=
2456: NVL(x_line_locs.qty_rcv_exception_code_tbl(i), l_qty_rcv_exception);
2457:
2458: IF (PO_LOG.d_stmt) THEN
2459: PO_LOG.stmt(d_module, d_position, 'qty_rcv_tolerance',
2460: x_line_locs.qty_rcv_tolerance_tbl(i));
2461: PO_LOG.stmt(d_module, d_position, 'qty_rcv_exception_code',
2462: x_line_locs.qty_rcv_exception_code_tbl(i));

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

2455: x_line_locs.qty_rcv_exception_code_tbl(i) :=
2456: NVL(x_line_locs.qty_rcv_exception_code_tbl(i), l_qty_rcv_exception);
2457:
2458: IF (PO_LOG.d_stmt) THEN
2459: PO_LOG.stmt(d_module, d_position, 'qty_rcv_tolerance',
2460: x_line_locs.qty_rcv_tolerance_tbl(i));
2461: PO_LOG.stmt(d_module, d_position, 'qty_rcv_exception_code',
2462: x_line_locs.qty_rcv_exception_code_tbl(i));
2463: END IF;

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

2457:
2458: IF (PO_LOG.d_stmt) THEN
2459: PO_LOG.stmt(d_module, d_position, 'qty_rcv_tolerance',
2460: x_line_locs.qty_rcv_tolerance_tbl(i));
2461: PO_LOG.stmt(d_module, d_position, 'qty_rcv_exception_code',
2462: x_line_locs.qty_rcv_exception_code_tbl(i));
2463: END IF;
2464: END IF;
2465:

Line 2483: IF (PO_LOG.d_proc) THEN

2479: -- set outsourced_assembly to 2 since it is a required field
2480: x_line_locs.outsourced_assembly_tbl(i) := 2;
2481: END LOOP;
2482:
2483: IF (PO_LOG.d_proc) THEN
2484: PO_LOG.proc_end (d_module);
2485: END IF;
2486:
2487: EXCEPTION

Line 2484: PO_LOG.proc_end (d_module);

2480: x_line_locs.outsourced_assembly_tbl(i) := 2;
2481: END LOOP;
2482:
2483: IF (PO_LOG.d_proc) THEN
2484: PO_LOG.proc_end (d_module);
2485: END IF;
2486:
2487: EXCEPTION
2488: WHEN OTHERS THEN

Line 2536: IF (PO_LOG.d_proc) THEN

2532: l_result_tbl PO_TBL_VARCHAR1;
2533: BEGIN
2534: d_position := 0;
2535:
2536: IF (PO_LOG.d_proc) THEN
2537: PO_LOG.proc_begin(d_module);
2538: END IF;
2539:
2540: -- retrieve the default value from database

Line 2537: PO_LOG.proc_begin(d_module);

2533: BEGIN
2534: d_position := 0;
2535:
2536: IF (PO_LOG.d_proc) THEN
2537: PO_LOG.proc_begin(d_module);
2538: END IF;
2539:
2540: -- retrieve the default value from database
2541: FORALL i IN 1..p_index_tbl.COUNT

Line 2564: IF (PO_LOG.d_stmt) THEN

2560:
2561: -- set result back to x_inspection_required_flag_tbl
2562: FOR i IN 1..l_index_tbl.COUNT
2563: LOOP
2564: IF (PO_LOG.d_stmt) THEN
2565: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2566: PO_LOG.stmt(d_module, d_position, 'default inspection required flag',
2567: l_result_tbl(i));
2568: END IF;

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

2561: -- set result back to x_inspection_required_flag_tbl
2562: FOR i IN 1..l_index_tbl.COUNT
2563: LOOP
2564: IF (PO_LOG.d_stmt) THEN
2565: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2566: PO_LOG.stmt(d_module, d_position, 'default inspection required flag',
2567: l_result_tbl(i));
2568: END IF;
2569:

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

2562: FOR i IN 1..l_index_tbl.COUNT
2563: LOOP
2564: IF (PO_LOG.d_stmt) THEN
2565: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2566: PO_LOG.stmt(d_module, d_position, 'default inspection required flag',
2567: l_result_tbl(i));
2568: END IF;
2569:
2570: x_inspection_required_flag_tbl(l_index_tbl(i)) := l_result_tbl(i);

Line 2573: IF (PO_LOG.d_proc) THEN

2569:
2570: x_inspection_required_flag_tbl(l_index_tbl(i)) := l_result_tbl(i);
2571: END LOOP;
2572:
2573: IF (PO_LOG.d_proc) THEN
2574: PO_LOG.proc_end (d_module);
2575: END IF;
2576:
2577: EXCEPTION

Line 2574: PO_LOG.proc_end (d_module);

2570: x_inspection_required_flag_tbl(l_index_tbl(i)) := l_result_tbl(i);
2571: END LOOP;
2572:
2573: IF (PO_LOG.d_proc) THEN
2574: PO_LOG.proc_end (d_module);
2575: END IF;
2576:
2577: EXCEPTION
2578: WHEN OTHERS THEN

Line 2626: IF (PO_LOG.d_proc) THEN

2622: l_result_tbl PO_TBL_NUMBER;
2623: BEGIN
2624: d_position := 0;
2625:
2626: IF (PO_LOG.d_proc) THEN
2627: PO_LOG.proc_begin(d_module);
2628: END IF;
2629:
2630: -- default ship_to_organization_id from ship_to_location_id

Line 2627: PO_LOG.proc_begin(d_module);

2623: BEGIN
2624: d_position := 0;
2625:
2626: IF (PO_LOG.d_proc) THEN
2627: PO_LOG.proc_begin(d_module);
2628: END IF;
2629:
2630: -- default ship_to_organization_id from ship_to_location_id
2631: FORALL i IN 1..p_index_tbl.COUNT

Line 2654: IF (PO_LOG.d_stmt) THEN

2650:
2651: -- set result in x_ship_to_org_id_tbl
2652: FOR i IN 1..l_index_tbl.COUNT
2653: LOOP
2654: IF (PO_LOG.d_stmt) THEN
2655: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2656: PO_LOG.stmt(d_module, d_position, 'default ship_to org id',
2657: l_result_tbl(i));
2658: END IF;

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

2651: -- set result in x_ship_to_org_id_tbl
2652: FOR i IN 1..l_index_tbl.COUNT
2653: LOOP
2654: IF (PO_LOG.d_stmt) THEN
2655: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2656: PO_LOG.stmt(d_module, d_position, 'default ship_to org id',
2657: l_result_tbl(i));
2658: END IF;
2659:

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

2652: FOR i IN 1..l_index_tbl.COUNT
2653: LOOP
2654: IF (PO_LOG.d_stmt) THEN
2655: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2656: PO_LOG.stmt(d_module, d_position, 'default ship_to org id',
2657: l_result_tbl(i));
2658: END IF;
2659:
2660: x_ship_to_org_id_tbl(l_index_tbl(i)) := l_result_tbl(i);

Line 2663: IF (PO_LOG.d_proc) THEN

2659:
2660: x_ship_to_org_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
2661: END LOOP;
2662:
2663: IF (PO_LOG.d_proc) THEN
2664: PO_LOG.proc_end (d_module);
2665: END IF;
2666:
2667: EXCEPTION

Line 2664: PO_LOG.proc_end (d_module);

2660: x_ship_to_org_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
2661: END LOOP;
2662:
2663: IF (PO_LOG.d_proc) THEN
2664: PO_LOG.proc_end (d_module);
2665: END IF;
2666:
2667: EXCEPTION
2668: WHEN OTHERS THEN

Line 2735: IF (PO_LOG.d_proc) THEN

2731: l_index NUMBER;
2732: BEGIN
2733: d_position := 0;
2734:
2735: IF (PO_LOG.d_proc) THEN
2736: PO_LOG.proc_begin(d_module);
2737: END IF;
2738:
2739: -- first, default from item_id and ship_to_organization_id

Line 2736: PO_LOG.proc_begin(d_module);

2732: BEGIN
2733: d_position := 0;
2734:
2735: IF (PO_LOG.d_proc) THEN
2736: PO_LOG.proc_begin(d_module);
2737: END IF;
2738:
2739: -- first, default from item_id and ship_to_organization_id
2740: FORALL i IN 1..p_index_tbl.COUNT

Line 2773: IF (PO_LOG.d_stmt) THEN

2769: x_receive_close_tolerance_tbl(l_index) :=
2770: NVL(x_receive_close_tolerance_tbl(l_index),
2771: l_receive_tolerance_tbl(i));
2772:
2773: IF (PO_LOG.d_stmt) THEN
2774: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2775: PO_LOG.stmt(d_module, d_position, 'invoice close tolerance',
2776: x_invoice_close_tolerance_tbl(l_index));
2777: PO_LOG.stmt(d_module, d_position, 'receive close tolerance',

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

2770: NVL(x_receive_close_tolerance_tbl(l_index),
2771: l_receive_tolerance_tbl(i));
2772:
2773: IF (PO_LOG.d_stmt) THEN
2774: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2775: PO_LOG.stmt(d_module, d_position, 'invoice close tolerance',
2776: x_invoice_close_tolerance_tbl(l_index));
2777: PO_LOG.stmt(d_module, d_position, 'receive close tolerance',
2778: x_receive_close_tolerance_tbl(l_index));

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

2771: l_receive_tolerance_tbl(i));
2772:
2773: IF (PO_LOG.d_stmt) THEN
2774: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2775: PO_LOG.stmt(d_module, d_position, 'invoice close tolerance',
2776: x_invoice_close_tolerance_tbl(l_index));
2777: PO_LOG.stmt(d_module, d_position, 'receive close tolerance',
2778: x_receive_close_tolerance_tbl(l_index));
2779: END IF;

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

2773: IF (PO_LOG.d_stmt) THEN
2774: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2775: PO_LOG.stmt(d_module, d_position, 'invoice close tolerance',
2776: x_invoice_close_tolerance_tbl(l_index));
2777: PO_LOG.stmt(d_module, d_position, 'receive close tolerance',
2778: x_receive_close_tolerance_tbl(l_index));
2779: END IF;
2780: END LOOP;
2781:

Line 2818: IF (PO_LOG.d_stmt) THEN

2814: x_receive_close_tolerance_tbl(l_index) :=
2815: NVL(x_receive_close_tolerance_tbl(l_index),
2816: l_receive_tolerance_tbl(i));
2817:
2818: IF (PO_LOG.d_stmt) THEN
2819: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2820: PO_LOG.stmt(d_module, d_position, 'invoice close tolerance',
2821: x_invoice_close_tolerance_tbl(l_index));
2822: PO_LOG.stmt(d_module, d_position, 'receive close tolerance',

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

2815: NVL(x_receive_close_tolerance_tbl(l_index),
2816: l_receive_tolerance_tbl(i));
2817:
2818: IF (PO_LOG.d_stmt) THEN
2819: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2820: PO_LOG.stmt(d_module, d_position, 'invoice close tolerance',
2821: x_invoice_close_tolerance_tbl(l_index));
2822: PO_LOG.stmt(d_module, d_position, 'receive close tolerance',
2823: x_receive_close_tolerance_tbl(l_index));

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

2816: l_receive_tolerance_tbl(i));
2817:
2818: IF (PO_LOG.d_stmt) THEN
2819: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2820: PO_LOG.stmt(d_module, d_position, 'invoice close tolerance',
2821: x_invoice_close_tolerance_tbl(l_index));
2822: PO_LOG.stmt(d_module, d_position, 'receive close tolerance',
2823: x_receive_close_tolerance_tbl(l_index));
2824: END IF;

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

2818: IF (PO_LOG.d_stmt) THEN
2819: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2820: PO_LOG.stmt(d_module, d_position, 'invoice close tolerance',
2821: x_invoice_close_tolerance_tbl(l_index));
2822: PO_LOG.stmt(d_module, d_position, 'receive close tolerance',
2823: x_receive_close_tolerance_tbl(l_index));
2824: END IF;
2825: END LOOP;
2826:

Line 2849: IF (PO_LOG.d_stmt) THEN

2845: l_index_tbl, l_receive_tolerance_tbl;
2846:
2847: FOR i IN 1..l_index_tbl.COUNT
2848: LOOP
2849: IF (PO_LOG.d_stmt) THEN
2850: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2851: PO_LOG.stmt(d_module, d_position, 'receive close tolerance',
2852: l_receive_tolerance_tbl(i));
2853: END IF;

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

2846:
2847: FOR i IN 1..l_index_tbl.COUNT
2848: LOOP
2849: IF (PO_LOG.d_stmt) THEN
2850: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2851: PO_LOG.stmt(d_module, d_position, 'receive close tolerance',
2852: l_receive_tolerance_tbl(i));
2853: END IF;
2854:

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

2847: FOR i IN 1..l_index_tbl.COUNT
2848: LOOP
2849: IF (PO_LOG.d_stmt) THEN
2850: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2851: PO_LOG.stmt(d_module, d_position, 'receive close tolerance',
2852: l_receive_tolerance_tbl(i));
2853: END IF;
2854:
2855: x_receive_close_tolerance_tbl(l_index_tbl(i)) := l_receive_tolerance_tbl(i);

Line 2863: IF (PO_LOG.d_stmt) THEN

2859:
2860: -- Last, default from system parameters using loop
2861: FOR i IN 1..p_index_tbl.COUNT
2862: LOOP
2863: IF (PO_LOG.d_stmt) THEN
2864: PO_LOG.stmt(d_module, d_position, 'index', i);
2865: PO_LOG.stmt(d_module, d_position, 'invoice close tolerance',
2866: x_invoice_close_tolerance_tbl(i));
2867: PO_LOG.stmt(d_module, d_position, 'receive close tolerance',

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

2860: -- Last, default from system parameters using loop
2861: FOR i IN 1..p_index_tbl.COUNT
2862: LOOP
2863: IF (PO_LOG.d_stmt) THEN
2864: PO_LOG.stmt(d_module, d_position, 'index', i);
2865: PO_LOG.stmt(d_module, d_position, 'invoice close tolerance',
2866: x_invoice_close_tolerance_tbl(i));
2867: PO_LOG.stmt(d_module, d_position, 'receive close tolerance',
2868: x_receive_close_tolerance_tbl(i));

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

2861: FOR i IN 1..p_index_tbl.COUNT
2862: LOOP
2863: IF (PO_LOG.d_stmt) THEN
2864: PO_LOG.stmt(d_module, d_position, 'index', i);
2865: PO_LOG.stmt(d_module, d_position, 'invoice close tolerance',
2866: x_invoice_close_tolerance_tbl(i));
2867: PO_LOG.stmt(d_module, d_position, 'receive close tolerance',
2868: x_receive_close_tolerance_tbl(i));
2869: END IF;

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

2863: IF (PO_LOG.d_stmt) THEN
2864: PO_LOG.stmt(d_module, d_position, 'index', i);
2865: PO_LOG.stmt(d_module, d_position, 'invoice close tolerance',
2866: x_invoice_close_tolerance_tbl(i));
2867: PO_LOG.stmt(d_module, d_position, 'receive close tolerance',
2868: x_receive_close_tolerance_tbl(i));
2869: END IF;
2870:
2871: x_invoice_close_tolerance_tbl(i) :=

Line 2881: IF (PO_LOG.d_proc) THEN

2877: PO_PDOI_PARAMS.g_sys.receive_close_tolerance,
2878: 0);
2879: END LOOP;
2880:
2881: IF (PO_LOG.d_proc) THEN
2882: PO_LOG.proc_end (d_module);
2883: END IF;
2884:
2885: EXCEPTION

Line 2882: PO_LOG.proc_end (d_module);

2878: 0);
2879: END LOOP;
2880:
2881: IF (PO_LOG.d_proc) THEN
2882: PO_LOG.proc_end (d_module);
2883: END IF;
2884:
2885: EXCEPTION
2886: WHEN OTHERS THEN

Line 2940: IF (PO_LOG.d_proc) THEN

2936: l_result_tbl PO_TBL_VARCHAR30;
2937: BEGIN
2938: d_position := 0;
2939:
2940: IF (PO_LOG.d_proc) THEN
2941: PO_LOG.proc_begin(d_module);
2942: END IF;
2943:
2944: -- first, get default value from vendor_site

Line 2941: PO_LOG.proc_begin(d_module);

2937: BEGIN
2938: d_position := 0;
2939:
2940: IF (PO_LOG.d_proc) THEN
2941: PO_LOG.proc_begin(d_module);
2942: END IF;
2943:
2944: -- first, get default value from vendor_site
2945: FORALL i IN 1..p_index_tbl.COUNT

Line 2963: IF (PO_LOG.d_stmt) THEN

2959: RETURNING num1, char1 BULK COLLECT INTO l_index_tbl, l_result_tbl;
2960:
2961: FOR i IN 1..l_index_tbl.COUNT
2962: LOOP
2963: IF (PO_LOG.d_stmt) THEN
2964: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2965: PO_LOG.stmt(d_module, d_position, 'new match option', l_result_tbl(i));
2966: END IF;
2967:

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

2960:
2961: FOR i IN 1..l_index_tbl.COUNT
2962: LOOP
2963: IF (PO_LOG.d_stmt) THEN
2964: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2965: PO_LOG.stmt(d_module, d_position, 'new match option', l_result_tbl(i));
2966: END IF;
2967:
2968: x_match_option_tbl(l_index_tbl(i)) := l_result_tbl(i);

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

2961: FOR i IN 1..l_index_tbl.COUNT
2962: LOOP
2963: IF (PO_LOG.d_stmt) THEN
2964: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2965: PO_LOG.stmt(d_module, d_position, 'new match option', l_result_tbl(i));
2966: END IF;
2967:
2968: x_match_option_tbl(l_index_tbl(i)) := l_result_tbl(i);
2969: END LOOP;

Line 2992: IF (PO_LOG.d_stmt) THEN

2988: RETURNING num1, char1 BULK COLLECT INTO l_index_tbl, l_result_tbl;
2989:
2990: FOR i IN 1..l_index_tbl.COUNT
2991: LOOP
2992: IF (PO_LOG.d_stmt) THEN
2993: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2994: PO_LOG.stmt(d_module, d_position, 'new match option', l_result_tbl(i));
2995: END IF;
2996:

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

2989:
2990: FOR i IN 1..l_index_tbl.COUNT
2991: LOOP
2992: IF (PO_LOG.d_stmt) THEN
2993: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2994: PO_LOG.stmt(d_module, d_position, 'new match option', l_result_tbl(i));
2995: END IF;
2996:
2997: x_match_option_tbl(l_index_tbl(i)) := l_result_tbl(i);

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

2990: FOR i IN 1..l_index_tbl.COUNT
2991: LOOP
2992: IF (PO_LOG.d_stmt) THEN
2993: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2994: PO_LOG.stmt(d_module, d_position, 'new match option', l_result_tbl(i));
2995: END IF;
2996:
2997: x_match_option_tbl(l_index_tbl(i)) := l_result_tbl(i);
2998: END LOOP;

Line 3005: IF (PO_LOG.d_stmt) THEN

3001:
3002: -- last, get default value from financial system parameter using loop
3003: FOR i IN 1..p_index_tbl.COUNT
3004: LOOP
3005: IF (PO_LOG.d_stmt) THEN
3006: PO_LOG.stmt(d_module, d_position, 'index', i);
3007: PO_LOG.stmt(d_module, d_position, 'curr match option', x_match_option_tbl(i));
3008: END IF;
3009:

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

3002: -- last, get default value from financial system parameter using loop
3003: FOR i IN 1..p_index_tbl.COUNT
3004: LOOP
3005: IF (PO_LOG.d_stmt) THEN
3006: PO_LOG.stmt(d_module, d_position, 'index', i);
3007: PO_LOG.stmt(d_module, d_position, 'curr match option', x_match_option_tbl(i));
3008: END IF;
3009:
3010: x_match_option_tbl(i) :=

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

3003: FOR i IN 1..p_index_tbl.COUNT
3004: LOOP
3005: IF (PO_LOG.d_stmt) THEN
3006: PO_LOG.stmt(d_module, d_position, 'index', i);
3007: PO_LOG.stmt(d_module, d_position, 'curr match option', x_match_option_tbl(i));
3008: END IF;
3009:
3010: x_match_option_tbl(i) :=
3011: NVL(x_match_option_tbl(i), PO_PDOI_PARAMS.g_sys.invoice_match_option);

Line 3014: IF (PO_LOG.d_proc) THEN

3010: x_match_option_tbl(i) :=
3011: NVL(x_match_option_tbl(i), PO_PDOI_PARAMS.g_sys.invoice_match_option);
3012: END LOOP;
3013:
3014: IF (PO_LOG.d_proc) THEN
3015: PO_LOG.proc_end (d_module);
3016: END IF;
3017:
3018: EXCEPTION

Line 3015: PO_LOG.proc_end (d_module);

3011: NVL(x_match_option_tbl(i), PO_PDOI_PARAMS.g_sys.invoice_match_option);
3012: END LOOP;
3013:
3014: IF (PO_LOG.d_proc) THEN
3015: PO_LOG.proc_end (d_module);
3016: END IF;
3017:
3018: EXCEPTION
3019: WHEN OTHERS THEN

Line 3076: IF (PO_LOG.d_proc) THEN

3072: l_index NUMBER;
3073: BEGIN
3074: d_position := 0;
3075:
3076: IF (PO_LOG.d_proc) THEN
3077: PO_LOG.proc_begin(d_module);
3078: END IF;
3079:
3080: -- get default values from item

Line 3077: PO_LOG.proc_begin(d_module);

3073: BEGIN
3074: d_position := 0;
3075:
3076: IF (PO_LOG.d_proc) THEN
3077: PO_LOG.proc_begin(d_module);
3078: END IF;
3079:
3080: -- get default values from item
3081: -- first, default from item_id and ship_to_organization_id

Line 3118: IF (PO_LOG.d_stmt) THEN

3114: l_item_status := 'D'; -- Expense
3115: END IF;
3116: END IF;
3117:
3118: IF (PO_LOG.d_stmt) THEN
3119: PO_LOG.stmt(d_module, d_position, 'index', l_index);
3120: PO_LOG.stmt(d_module, d_position, 'item status', l_item_status);
3121: END IF;
3122:

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

3115: END IF;
3116: END IF;
3117:
3118: IF (PO_LOG.d_stmt) THEN
3119: PO_LOG.stmt(d_module, d_position, 'index', l_index);
3120: PO_LOG.stmt(d_module, d_position, 'item status', l_item_status);
3121: END IF;
3122:
3123: -- set default value

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

3116: END IF;
3117:
3118: IF (PO_LOG.d_stmt) THEN
3119: PO_LOG.stmt(d_module, d_position, 'index', l_index);
3120: PO_LOG.stmt(d_module, d_position, 'item status', l_item_status);
3121: END IF;
3122:
3123: -- set default value
3124: IF (l_item_status = 'O') THEN

Line 3127: IF (PO_LOG.d_stmt) THEN

3123: -- set default value
3124: IF (l_item_status = 'O') THEN
3125: x_accrue_on_receipt_flag_tbl(l_index) := 'Y';
3126: ELSIF (l_item_status = 'E') THEN
3127: IF (PO_LOG.d_stmt) THEN
3128: PO_LOG.stmt(d_module, d_position, 'INV installed',
3129: PO_PDOI_PARAMS.g_product.inv_installed);
3130: PO_LOG.stmt(d_module, d_position, 'default expense accrual code',
3131: PO_PDOI_PARAMS.g_sys.expense_accrual_code);

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

3124: IF (l_item_status = 'O') THEN
3125: x_accrue_on_receipt_flag_tbl(l_index) := 'Y';
3126: ELSIF (l_item_status = 'E') THEN
3127: IF (PO_LOG.d_stmt) THEN
3128: PO_LOG.stmt(d_module, d_position, 'INV installed',
3129: PO_PDOI_PARAMS.g_product.inv_installed);
3130: PO_LOG.stmt(d_module, d_position, 'default expense accrual code',
3131: PO_PDOI_PARAMS.g_sys.expense_accrual_code);
3132: END IF;

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

3126: ELSIF (l_item_status = 'E') THEN
3127: IF (PO_LOG.d_stmt) THEN
3128: PO_LOG.stmt(d_module, d_position, 'INV installed',
3129: PO_PDOI_PARAMS.g_product.inv_installed);
3130: PO_LOG.stmt(d_module, d_position, 'default expense accrual code',
3131: PO_PDOI_PARAMS.g_sys.expense_accrual_code);
3132: END IF;
3133:
3134: IF (PO_PDOI_PARAMS.g_product.inv_installed = FND_API.g_TRUE) then

Line 3164: IF (PO_LOG.d_stmt) THEN

3160:
3161: l_index := p_index_tbl(i);
3162: l_item_status := 'D'; -- Expense
3163:
3164: IF (PO_LOG.d_stmt) THEN
3165: PO_LOG.stmt(d_module, d_position, 'l_index = ', l_index);
3166: PO_LOG.stmt(d_module, d_position, 'l_item_status = ', l_item_status );
3167: END IF;
3168:

Line 3165: PO_LOG.stmt(d_module, d_position, 'l_index = ', l_index);

3161: l_index := p_index_tbl(i);
3162: l_item_status := 'D'; -- Expense
3163:
3164: IF (PO_LOG.d_stmt) THEN
3165: PO_LOG.stmt(d_module, d_position, 'l_index = ', l_index);
3166: PO_LOG.stmt(d_module, d_position, 'l_item_status = ', l_item_status );
3167: END IF;
3168:
3169: -- set default value

Line 3166: PO_LOG.stmt(d_module, d_position, 'l_item_status = ', l_item_status );

3162: l_item_status := 'D'; -- Expense
3163:
3164: IF (PO_LOG.d_stmt) THEN
3165: PO_LOG.stmt(d_module, d_position, 'l_index = ', l_index);
3166: PO_LOG.stmt(d_module, d_position, 'l_item_status = ', l_item_status );
3167: END IF;
3168:
3169: -- set default value
3170: IF (PO_PDOI_PARAMS.g_sys.expense_accrual_code = 'PERIOD END') THEN

Line 3181: IF (PO_LOG.d_proc) THEN

3177:
3178: END LOOP;
3179:
3180:
3181: IF (PO_LOG.d_proc) THEN
3182: PO_LOG.proc_end (d_module);
3183: END IF;
3184:
3185: EXCEPTION

Line 3182: PO_LOG.proc_end (d_module);

3178: END LOOP;
3179:
3180:
3181: IF (PO_LOG.d_proc) THEN
3182: PO_LOG.proc_end (d_module);
3183: END IF;
3184:
3185: EXCEPTION
3186: WHEN OTHERS THEN

Line 3237: IF (PO_LOG.d_proc) THEN

3233: l_result_tbl PO_TBL_VARCHAR30;
3234: BEGIN
3235: d_position := 0;
3236:
3237: IF (PO_LOG.d_proc) THEN
3238: PO_LOG.proc_begin(d_module, 'p_item_id_tbl', p_item_id_tbl);
3239: PO_LOG.proc_begin(d_module, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
3240: END IF;
3241:

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

3234: BEGIN
3235: d_position := 0;
3236:
3237: IF (PO_LOG.d_proc) THEN
3238: PO_LOG.proc_begin(d_module, 'p_item_id_tbl', p_item_id_tbl);
3239: PO_LOG.proc_begin(d_module, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
3240: END IF;
3241:
3242: -- retrieve the default value from database

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

3235: d_position := 0;
3236:
3237: IF (PO_LOG.d_proc) THEN
3238: PO_LOG.proc_begin(d_module, 'p_item_id_tbl', p_item_id_tbl);
3239: PO_LOG.proc_begin(d_module, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
3240: END IF;
3241:
3242: -- retrieve the default value from database
3243: FORALL i IN 1..p_index_tbl.COUNT

Line 3270: IF (PO_LOG.d_stmt) THEN

3266:
3267: -- set result back to x_inspection_required_flag_tbl
3268: FOR i IN 1..l_index_tbl.COUNT
3269: LOOP
3270: IF (PO_LOG.d_stmt) THEN
3271: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3272: PO_LOG.stmt(d_module, d_position, 'default secondary_unit_of_measure',
3273: l_result_tbl(i));
3274: END IF;

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

3267: -- set result back to x_inspection_required_flag_tbl
3268: FOR i IN 1..l_index_tbl.COUNT
3269: LOOP
3270: IF (PO_LOG.d_stmt) THEN
3271: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3272: PO_LOG.stmt(d_module, d_position, 'default secondary_unit_of_measure',
3273: l_result_tbl(i));
3274: END IF;
3275:

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

3268: FOR i IN 1..l_index_tbl.COUNT
3269: LOOP
3270: IF (PO_LOG.d_stmt) THEN
3271: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3272: PO_LOG.stmt(d_module, d_position, 'default secondary_unit_of_measure',
3273: l_result_tbl(i));
3274: END IF;
3275:
3276: x_secondary_unit_of_meas_tbl(l_index_tbl(i)) := l_result_tbl(i);

Line 3279: IF (PO_LOG.d_proc) THEN

3275:
3276: x_secondary_unit_of_meas_tbl(l_index_tbl(i)) := l_result_tbl(i);
3277: END LOOP;
3278:
3279: IF (PO_LOG.d_proc) THEN
3280: PO_LOG.proc_end (d_module);
3281: END IF;
3282:
3283: EXCEPTION

Line 3280: PO_LOG.proc_end (d_module);

3276: x_secondary_unit_of_meas_tbl(l_index_tbl(i)) := l_result_tbl(i);
3277: END LOOP;
3278:
3279: IF (PO_LOG.d_proc) THEN
3280: PO_LOG.proc_end (d_module);
3281: END IF;
3282:
3283: EXCEPTION
3284: WHEN OTHERS THEN

Line 3329: IF (PO_LOG.d_proc) THEN

3325: l_remove_err_line_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
3326: BEGIN
3327: d_position := 0;
3328:
3329: IF (PO_LOG.d_proc) THEN
3330: PO_LOG.proc_begin(d_module);
3331: END IF;
3332:
3333: FOR i IN 1 .. x_line_locs.intf_line_loc_id_tbl.COUNT LOOP

Line 3330: PO_LOG.proc_begin(d_module);

3326: BEGIN
3327: d_position := 0;
3328:
3329: IF (PO_LOG.d_proc) THEN
3330: PO_LOG.proc_begin(d_module);
3331: END IF;
3332:
3333: FOR i IN 1 .. x_line_locs.intf_line_loc_id_tbl.COUNT LOOP
3334: l_index_tbl(x_line_locs.intf_line_loc_id_tbl(i)) := i;

Line 3351: IF (PO_LOG.d_stmt) THEN

3347: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
3348: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
3349: d_position := 20;
3350:
3351: IF (PO_LOG.d_stmt) THEN
3352: PO_LOG.stmt(d_module, d_position, 'after error tolerance exceeded, collect error on index', l_index);
3353: END IF;
3354:
3355: -- collect intf_line_loc_ids to remove the errors from error intf table

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

3348: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
3349: d_position := 20;
3350:
3351: IF (PO_LOG.d_stmt) THEN
3352: PO_LOG.stmt(d_module, d_position, 'after error tolerance exceeded, collect error on index', l_index);
3353: END IF;
3354:
3355: -- collect intf_line_loc_ids to remove the errors from error intf table
3356: IF (NOT PO_PDOI_PARAMS.g_errored_lines.EXISTS(x_line_locs.intf_line_id_tbl(l_index))) THEN

Line 3367: IF (PO_LOG.d_stmt) THEN

3363: END IF;
3364: ELSIF (x_results.result_type(i) = po_validations.c_result_type_failure) THEN
3365: d_position := 40;
3366:
3367: IF (PO_LOG.d_stmt) THEN
3368: PO_LOG.stmt(d_module, d_position, 'set error on index', l_index);
3369: END IF;
3370:
3371: x_line_locs.error_flag_tbl(l_index) := FND_API.g_TRUE;

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

3364: ELSIF (x_results.result_type(i) = po_validations.c_result_type_failure) THEN
3365: d_position := 40;
3366:
3367: IF (PO_LOG.d_stmt) THEN
3368: PO_LOG.stmt(d_module, d_position, 'set error on index', l_index);
3369: END IF;
3370:
3371: x_line_locs.error_flag_tbl(l_index) := FND_API.g_TRUE;
3372:

Line 3381: IF (PO_LOG.d_stmt) THEN

3377: -- records
3378: IF (NOT PO_PDOI_PARAMS.g_errored_lines.EXISTS(x_line_locs.intf_line_id_tbl(l_index))) THEN
3379: d_position := 50;
3380:
3381: IF (PO_LOG.d_stmt) THEN
3382: PO_LOG.stmt(d_module, d_position, 'set error on line',
3383: x_line_locs.intf_line_id_tbl(l_index));
3384: END IF;
3385:

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

3378: IF (NOT PO_PDOI_PARAMS.g_errored_lines.EXISTS(x_line_locs.intf_line_id_tbl(l_index))) THEN
3379: d_position := 50;
3380:
3381: IF (PO_LOG.d_stmt) THEN
3382: PO_LOG.stmt(d_module, d_position, 'set error on line',
3383: x_line_locs.intf_line_id_tbl(l_index));
3384: END IF;
3385:
3386: -- set corresponding line to ERROR

Line 3398: IF (PO_LOG.d_stmt) THEN

3394: IF (PO_PDOI_PARAMS.g_request.calling_module =
3395: PO_PDOI_CONSTANTS.g_call_mod_CATALOG_UPLOAD AND
3396: PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).number_of_errored_lines
3397: = PO_PDOI_PARAMS.g_request.err_lines_tolerance) THEN
3398: IF (PO_LOG.d_stmt) THEN
3399: PO_LOG.stmt(d_module, d_position, 'threshold hit on line',
3400: x_line_locs.intf_line_id_tbl(l_index));
3401: END IF;
3402:

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

3395: PO_PDOI_CONSTANTS.g_call_mod_CATALOG_UPLOAD AND
3396: PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).number_of_errored_lines
3397: = PO_PDOI_PARAMS.g_request.err_lines_tolerance) THEN
3398: IF (PO_LOG.d_stmt) THEN
3399: PO_LOG.stmt(d_module, d_position, 'threshold hit on line',
3400: x_line_locs.intf_line_id_tbl(l_index));
3401: END IF;
3402:
3403: PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).err_tolerance_exceeded := FND_API.g_TRUE;

Line 3430: IF (PO_LOG.d_proc) THEN

3426: AND interface_line_id = l_remove_err_line_tbl(i);
3427:
3428: d_position := 70;
3429:
3430: IF (PO_LOG.d_proc) THEN
3431: PO_LOG.proc_end (d_module);
3432: END IF;
3433:
3434: EXCEPTION

Line 3431: PO_LOG.proc_end (d_module);

3427:
3428: d_position := 70;
3429:
3430: IF (PO_LOG.d_proc) THEN
3431: PO_LOG.proc_end (d_module);
3432: END IF;
3433:
3434: EXCEPTION
3435: WHEN OTHERS THEN