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_HEADER_PROCESS_PVT dependencies on PO_LOG

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

1: PACKAGE BODY po_pdoi_header_process_pvt AS
2: /* $Header: PO_PDOI_HEADER_PROCESS_PVT.plb 120.34.12020000.3 2013/02/10 15:06:17 vegajula ship $ */
3:
4: d_pkg_name CONSTANT VARCHAR2(50) :=
5: PO_LOG.get_package_base('PO_PDOI_HEADER_PROCESS_PVT');
6:
7:
8: --------------------------------------------------------------------------
9: ---------------------- PRIVATE PROCEDURES PROTOTYPE ----------------------

Line 189: IF (PO_LOG.d_proc) THEN

185:
186: BEGIN
187: d_position := 0;
188:
189: IF (PO_LOG.d_proc) THEN
190: PO_LOG.proc_begin(d_module, 'p_max_intf_header_id', p_max_intf_header_id);
191: END IF;
192:
193: OPEN x_headers_csr FOR

Line 190: PO_LOG.proc_begin(d_module, 'p_max_intf_header_id', p_max_intf_header_id);

186: BEGIN
187: d_position := 0;
188:
189: IF (PO_LOG.d_proc) THEN
190: PO_LOG.proc_begin(d_module, 'p_max_intf_header_id', p_max_intf_header_id);
191: END IF;
192:
193: OPEN x_headers_csr FOR
194: SELECT interface_header_id,

Line 355: IF (PO_LOG.d_proc) THEN

351: AND action IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
352: PO_PDOI_CONSTANTS.g_ACTION_REPLACE)
353: ORDER by interface_header_id;
354:
355: IF (PO_LOG.d_proc) THEN
356: PO_LOG.proc_end (d_module);
357: END IF;
358:
359: EXCEPTION

Line 356: PO_LOG.proc_end (d_module);

352: PO_PDOI_CONSTANTS.g_ACTION_REPLACE)
353: ORDER by interface_header_id;
354:
355: IF (PO_LOG.d_proc) THEN
356: PO_LOG.proc_end (d_module);
357: END IF;
358:
359: EXCEPTION
360: WHEN OTHERS THEN

Line 400: IF (PO_LOG.d_proc) THEN

396:
397: BEGIN
398: d_position := 0;
399:
400: IF (PO_LOG.d_proc) THEN
401: PO_LOG.proc_begin(d_module, 'p_intf_po_header_id', p_intf_po_header_id);
402: END IF;
403:
404: OPEN x_headers_csr FOR

Line 401: PO_LOG.proc_begin(d_module, 'p_intf_po_header_id', p_intf_po_header_id);

397: BEGIN
398: d_position := 0;
399:
400: IF (PO_LOG.d_proc) THEN
401: PO_LOG.proc_begin(d_module, 'p_intf_po_header_id', p_intf_po_header_id);
402: END IF;
403:
404: OPEN x_headers_csr FOR
405: SELECT interface_header_id,

Line 569: IF (PO_LOG.d_proc) THEN

565: AND action IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
566: PO_PDOI_CONSTANTS.g_ACTION_REPLACE)
567: ORDER by interface_header_id;
568:
569: IF (PO_LOG.d_proc) THEN
570: PO_LOG.proc_end (d_module);
571: END IF;
572:
573: EXCEPTION

Line 570: PO_LOG.proc_end (d_module);

566: PO_PDOI_CONSTANTS.g_ACTION_REPLACE)
567: ORDER by interface_header_id;
568:
569: IF (PO_LOG.d_proc) THEN
570: PO_LOG.proc_end (d_module);
571: END IF;
572:
573: EXCEPTION
574: WHEN OTHERS THEN

Line 611: IF (PO_LOG.d_proc) THEN

607:
608: BEGIN
609: d_position := 0;
610:
611: IF (PO_LOG.d_proc) THEN
612: PO_LOG.proc_begin(d_module);
613: END IF;
614:
615: FETCH x_headers_csr BULK COLLECT INTO

Line 612: PO_LOG.proc_begin(d_module);

608: BEGIN
609: d_position := 0;
610:
611: IF (PO_LOG.d_proc) THEN
612: PO_LOG.proc_begin(d_module);
613: END IF;
614:
615: FETCH x_headers_csr BULK COLLECT INTO
616: x_headers.intf_header_id_tbl,

Line 773: IF (PO_LOG.d_proc) THEN

769:
770:
771: LIMIT PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE;
772:
773: IF (PO_LOG.d_proc) THEN
774: PO_LOG.proc_end (d_module);
775: END IF;
776:
777: EXCEPTION

Line 774: PO_LOG.proc_end (d_module);

770:
771: LIMIT PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE;
772:
773: IF (PO_LOG.d_proc) THEN
774: PO_LOG.proc_end (d_module);
775: END IF;
776:
777: EXCEPTION
778: WHEN OTHERS THEN

Line 834: IF (PO_LOG.d_proc) THEN

830: l_column_name VARCHAR2(11);
831: BEGIN
832: d_position := 0;
833:
834: IF (PO_LOG.d_proc) THEN
835: PO_LOG.proc_begin(d_module, 'header_count', x_headers.rec_count);
836: END IF;
837:
838: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_HEADER_DERIVE);

Line 835: PO_LOG.proc_begin(d_module, 'header_count', x_headers.rec_count);

831: BEGIN
832: d_position := 0;
833:
834: IF (PO_LOG.d_proc) THEN
835: PO_LOG.proc_begin(d_module, 'header_count', x_headers.rec_count);
836: END IF;
837:
838: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_HEADER_DERIVE);
839:

Line 843: IF (PO_LOG.d_stmt) THEN

839:
840: -- pick a new key which will be used in all derive logic
841: l_key := PO_CORE_S.get_session_gt_nextval;
842:
843: IF (PO_LOG.d_stmt) THEN
844: PO_LOG.stmt(d_module, d_position, 'key', l_key);
845: END IF;
846:
847: -- initialize table containing the row number

Line 844: PO_LOG.stmt(d_module, d_position, 'key', l_key);

840: -- pick a new key which will be used in all derive logic
841: l_key := PO_CORE_S.get_session_gt_nextval;
842:
843: IF (PO_LOG.d_stmt) THEN
844: PO_LOG.stmt(d_module, d_position, 'key', l_key);
845: END IF;
846:
847: -- initialize table containing the row number
848: PO_PDOI_UTL.generate_ordered_num_list

Line 961: IF (PO_LOG.d_stmt) THEN

957:
958: -- derive from_header_id from from_rfq_num for QUOTATION
959: IF (PO_PDOI_PARAMS.g_request.document_type =
960: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN
961: IF (PO_LOG.d_stmt) THEN
962: PO_LOG.stmt(d_module, d_position, 'derive from header id');
963: END IF;
964:
965: derive_from_header_id

Line 962: PO_LOG.stmt(d_module, d_position, 'derive from header id');

958: -- derive from_header_id from from_rfq_num for QUOTATION
959: IF (PO_PDOI_PARAMS.g_request.document_type =
960: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN
961: IF (PO_LOG.d_stmt) THEN
962: PO_LOG.stmt(d_module, d_position, 'derive from header id');
963: END IF;
964:
965: derive_from_header_id
966: (

Line 1033: IF (PO_LOG.d_stmt) THEN

1029: --CLM PDOI Integration Ends
1030:
1031: d_position := 100;
1032:
1033: IF (PO_LOG.d_stmt) THEN
1034: PO_LOG.stmt(d_module, d_position, 'start processing derivation errors');
1035: END IF;
1036:
1037: -- handle derivation errors

Line 1034: PO_LOG.stmt(d_module, d_position, 'start processing derivation errors');

1030:
1031: d_position := 100;
1032:
1033: IF (PO_LOG.d_stmt) THEN
1034: PO_LOG.stmt(d_module, d_position, 'start processing derivation errors');
1035: END IF;
1036:
1037: -- handle derivation errors
1038: FOR i IN 1..x_headers.rec_count

Line 1042: IF (PO_LOG.d_stmt) THEN

1038: FOR i IN 1..x_headers.rec_count
1039: LOOP
1040: d_position := 110;
1041:
1042: IF (PO_LOG.d_stmt) THEN
1043: PO_LOG.stmt(d_module, d_position, 'index', i);
1044: END IF;
1045:
1046: IF (x_headers.rate_type_tbl(i) IS NOT NULL AND

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

1039: LOOP
1040: d_position := 110;
1041:
1042: IF (PO_LOG.d_stmt) THEN
1043: PO_LOG.stmt(d_module, d_position, 'index', i);
1044: END IF;
1045:
1046: IF (x_headers.rate_type_tbl(i) IS NOT NULL AND
1047: x_headers.rate_type_code_tbl(i) IS NULL) THEN

Line 1048: IF (PO_LOG.d_stmt) THEN

1044: END IF;
1045:
1046: IF (x_headers.rate_type_tbl(i) IS NOT NULL AND
1047: x_headers.rate_type_code_tbl(i) IS NULL) THEN
1048: IF (PO_LOG.d_stmt) THEN
1049: PO_LOG.stmt(d_module, d_position, 'rate type code derivation failed');
1050: PO_LOG.stmt(d_module, d_position, 'rate type', x_headers.rate_type_tbl(i));
1051: END IF;
1052:

Line 1049: PO_LOG.stmt(d_module, d_position, 'rate type code derivation failed');

1045:
1046: IF (x_headers.rate_type_tbl(i) IS NOT NULL AND
1047: x_headers.rate_type_code_tbl(i) IS NULL) THEN
1048: IF (PO_LOG.d_stmt) THEN
1049: PO_LOG.stmt(d_module, d_position, 'rate type code derivation failed');
1050: PO_LOG.stmt(d_module, d_position, 'rate type', x_headers.rate_type_tbl(i));
1051: END IF;
1052:
1053: PO_PDOI_ERR_UTL.add_fatal_error

Line 1050: PO_LOG.stmt(d_module, d_position, 'rate type', x_headers.rate_type_tbl(i));

1046: IF (x_headers.rate_type_tbl(i) IS NOT NULL AND
1047: x_headers.rate_type_code_tbl(i) IS NULL) THEN
1048: IF (PO_LOG.d_stmt) THEN
1049: PO_LOG.stmt(d_module, d_position, 'rate type code derivation failed');
1050: PO_LOG.stmt(d_module, d_position, 'rate type', x_headers.rate_type_tbl(i));
1051: END IF;
1052:
1053: PO_PDOI_ERR_UTL.add_fatal_error
1054: (

Line 1073: IF (PO_LOG.d_stmt) THEN

1069: END IF;
1070:
1071: IF (x_headers.agent_name_tbl(i) IS NOT NULL AND
1072: x_headers.agent_id_tbl(i) IS NULL) THEN
1073: IF (PO_LOG.d_stmt) THEN
1074: PO_LOG.stmt(d_module, d_position, 'agent id derivation failed');
1075: PO_LOG.stmt(d_module, d_position, 'agent name', x_headers.agent_name_tbl(i));
1076: END IF;
1077:

Line 1074: PO_LOG.stmt(d_module, d_position, 'agent id derivation failed');

1070:
1071: IF (x_headers.agent_name_tbl(i) IS NOT NULL AND
1072: x_headers.agent_id_tbl(i) IS NULL) THEN
1073: IF (PO_LOG.d_stmt) THEN
1074: PO_LOG.stmt(d_module, d_position, 'agent id derivation failed');
1075: PO_LOG.stmt(d_module, d_position, 'agent name', x_headers.agent_name_tbl(i));
1076: END IF;
1077:
1078: PO_PDOI_ERR_UTL.add_fatal_error

Line 1075: PO_LOG.stmt(d_module, d_position, 'agent name', x_headers.agent_name_tbl(i));

1071: IF (x_headers.agent_name_tbl(i) IS NOT NULL AND
1072: x_headers.agent_id_tbl(i) IS NULL) THEN
1073: IF (PO_LOG.d_stmt) THEN
1074: PO_LOG.stmt(d_module, d_position, 'agent id derivation failed');
1075: PO_LOG.stmt(d_module, d_position, 'agent name', x_headers.agent_name_tbl(i));
1076: END IF;
1077:
1078: PO_PDOI_ERR_UTL.add_fatal_error
1079: (

Line 1096: IF (PO_LOG.d_stmt) THEN

1092: END IF;
1093:
1094: IF (x_headers.ship_to_loc_tbl(i) IS NOT NULL AND
1095: x_headers.ship_to_loc_id_tbl(i) IS NULL) THEN
1096: IF (PO_LOG.d_stmt) THEN
1097: PO_LOG.stmt(d_module, d_position, 'ship_to loc id derivation failed');
1098: PO_LOG.stmt(d_module, d_position, 'ship_to loc', x_headers.ship_to_loc_tbl(i));
1099: END IF;
1100:

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

1093:
1094: IF (x_headers.ship_to_loc_tbl(i) IS NOT NULL AND
1095: x_headers.ship_to_loc_id_tbl(i) IS NULL) THEN
1096: IF (PO_LOG.d_stmt) THEN
1097: PO_LOG.stmt(d_module, d_position, 'ship_to loc id derivation failed');
1098: PO_LOG.stmt(d_module, d_position, 'ship_to loc', x_headers.ship_to_loc_tbl(i));
1099: END IF;
1100:
1101: PO_PDOI_ERR_UTL.add_fatal_error

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

1094: IF (x_headers.ship_to_loc_tbl(i) IS NOT NULL AND
1095: x_headers.ship_to_loc_id_tbl(i) IS NULL) THEN
1096: IF (PO_LOG.d_stmt) THEN
1097: PO_LOG.stmt(d_module, d_position, 'ship_to loc id derivation failed');
1098: PO_LOG.stmt(d_module, d_position, 'ship_to loc', x_headers.ship_to_loc_tbl(i));
1099: END IF;
1100:
1101: PO_PDOI_ERR_UTL.add_fatal_error
1102: (

Line 1119: IF (PO_LOG.d_stmt) THEN

1115: END IF;
1116:
1117: IF (x_headers.bill_to_loc_tbl(i) IS NOT NULL AND
1118: x_headers.bill_to_loc_id_tbl(i) IS NULL) THEN
1119: IF (PO_LOG.d_stmt) THEN
1120: PO_LOG.stmt(d_module, d_position, 'bill_to loc id derivation failed');
1121: PO_LOG.stmt(d_module, d_position, 'bill_to loc', x_headers.bill_to_loc_tbl(i));
1122: END IF;
1123:

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

1116:
1117: IF (x_headers.bill_to_loc_tbl(i) IS NOT NULL AND
1118: x_headers.bill_to_loc_id_tbl(i) IS NULL) THEN
1119: IF (PO_LOG.d_stmt) THEN
1120: PO_LOG.stmt(d_module, d_position, 'bill_to loc id derivation failed');
1121: PO_LOG.stmt(d_module, d_position, 'bill_to loc', x_headers.bill_to_loc_tbl(i));
1122: END IF;
1123:
1124: PO_PDOI_ERR_UTL.add_fatal_error

Line 1121: PO_LOG.stmt(d_module, d_position, 'bill_to loc', x_headers.bill_to_loc_tbl(i));

1117: IF (x_headers.bill_to_loc_tbl(i) IS NOT NULL AND
1118: x_headers.bill_to_loc_id_tbl(i) IS NULL) THEN
1119: IF (PO_LOG.d_stmt) THEN
1120: PO_LOG.stmt(d_module, d_position, 'bill_to loc id derivation failed');
1121: PO_LOG.stmt(d_module, d_position, 'bill_to loc', x_headers.bill_to_loc_tbl(i));
1122: END IF;
1123:
1124: PO_PDOI_ERR_UTL.add_fatal_error
1125: (

Line 1142: IF (PO_LOG.d_stmt) THEN

1138: END IF;
1139:
1140: IF (x_headers.payment_terms_tbl(i) IS NOT NULL AND
1141: x_headers.terms_id_tbl(i) IS NULL) THEN
1142: IF (PO_LOG.d_stmt) THEN
1143: PO_LOG.stmt(d_module, d_position, 'terms id derivation failed');
1144: PO_LOG.stmt(d_module, d_position, 'payment terms', x_headers.payment_terms_tbl(i));
1145: END IF;
1146:

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

1139:
1140: IF (x_headers.payment_terms_tbl(i) IS NOT NULL AND
1141: x_headers.terms_id_tbl(i) IS NULL) THEN
1142: IF (PO_LOG.d_stmt) THEN
1143: PO_LOG.stmt(d_module, d_position, 'terms id derivation failed');
1144: PO_LOG.stmt(d_module, d_position, 'payment terms', x_headers.payment_terms_tbl(i));
1145: END IF;
1146:
1147: PO_PDOI_ERR_UTL.add_fatal_error

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

1140: IF (x_headers.payment_terms_tbl(i) IS NOT NULL AND
1141: x_headers.terms_id_tbl(i) IS NULL) THEN
1142: IF (PO_LOG.d_stmt) THEN
1143: PO_LOG.stmt(d_module, d_position, 'terms id derivation failed');
1144: PO_LOG.stmt(d_module, d_position, 'payment terms', x_headers.payment_terms_tbl(i));
1145: END IF;
1146:
1147: PO_PDOI_ERR_UTL.add_fatal_error
1148: (

Line 1172: IF (PO_LOG.d_stmt) THEN

1168: ELSE
1169: l_column_name := 'VENDOR_NUM';
1170: END IF;
1171:
1172: IF (PO_LOG.d_stmt) THEN
1173: PO_LOG.stmt(d_module, d_position, 'vendor id derivation failed');
1174: PO_LOG.stmt(d_module, d_position, 'vendor name', x_headers.vendor_name_tbl(i));
1175: PO_LOG.stmt(d_module, d_position, 'vendor num', x_headers.vendor_num_tbl(i));
1176: END IF;

Line 1173: PO_LOG.stmt(d_module, d_position, 'vendor id derivation failed');

1169: l_column_name := 'VENDOR_NUM';
1170: END IF;
1171:
1172: IF (PO_LOG.d_stmt) THEN
1173: PO_LOG.stmt(d_module, d_position, 'vendor id derivation failed');
1174: PO_LOG.stmt(d_module, d_position, 'vendor name', x_headers.vendor_name_tbl(i));
1175: PO_LOG.stmt(d_module, d_position, 'vendor num', x_headers.vendor_num_tbl(i));
1176: END IF;
1177:

Line 1174: PO_LOG.stmt(d_module, d_position, 'vendor name', x_headers.vendor_name_tbl(i));

1170: END IF;
1171:
1172: IF (PO_LOG.d_stmt) THEN
1173: PO_LOG.stmt(d_module, d_position, 'vendor id derivation failed');
1174: PO_LOG.stmt(d_module, d_position, 'vendor name', x_headers.vendor_name_tbl(i));
1175: PO_LOG.stmt(d_module, d_position, 'vendor num', x_headers.vendor_num_tbl(i));
1176: END IF;
1177:
1178: PO_PDOI_ERR_UTL.add_fatal_error

Line 1175: PO_LOG.stmt(d_module, d_position, 'vendor num', x_headers.vendor_num_tbl(i));

1171:
1172: IF (PO_LOG.d_stmt) THEN
1173: PO_LOG.stmt(d_module, d_position, 'vendor id derivation failed');
1174: PO_LOG.stmt(d_module, d_position, 'vendor name', x_headers.vendor_name_tbl(i));
1175: PO_LOG.stmt(d_module, d_position, 'vendor num', x_headers.vendor_num_tbl(i));
1176: END IF;
1177:
1178: PO_PDOI_ERR_UTL.add_fatal_error
1179: (

Line 1197: IF (PO_LOG.d_stmt) THEN

1193: END IF;
1194:
1195: IF (x_headers.vendor_site_code_tbl(i) IS NOT NULL AND
1196: x_headers.vendor_site_id_tbl(i) IS NULL) THEN
1197: IF (PO_LOG.d_stmt) THEN
1198: PO_LOG.stmt(d_module, d_position, 'vendor site id derivation failed');
1199: PO_LOG.stmt(d_module, d_position, 'vendor site', x_headers.vendor_site_code_tbl(i));
1200: END IF;
1201:

Line 1198: PO_LOG.stmt(d_module, d_position, 'vendor site id derivation failed');

1194:
1195: IF (x_headers.vendor_site_code_tbl(i) IS NOT NULL AND
1196: x_headers.vendor_site_id_tbl(i) IS NULL) THEN
1197: IF (PO_LOG.d_stmt) THEN
1198: PO_LOG.stmt(d_module, d_position, 'vendor site id derivation failed');
1199: PO_LOG.stmt(d_module, d_position, 'vendor site', x_headers.vendor_site_code_tbl(i));
1200: END IF;
1201:
1202: PO_PDOI_ERR_UTL.add_fatal_error

Line 1199: PO_LOG.stmt(d_module, d_position, 'vendor site', x_headers.vendor_site_code_tbl(i));

1195: IF (x_headers.vendor_site_code_tbl(i) IS NOT NULL AND
1196: x_headers.vendor_site_id_tbl(i) IS NULL) THEN
1197: IF (PO_LOG.d_stmt) THEN
1198: PO_LOG.stmt(d_module, d_position, 'vendor site id derivation failed');
1199: PO_LOG.stmt(d_module, d_position, 'vendor site', x_headers.vendor_site_code_tbl(i));
1200: END IF;
1201:
1202: PO_PDOI_ERR_UTL.add_fatal_error
1203: (

Line 1220: IF (PO_LOG.d_stmt) THEN

1216: END IF;
1217:
1218: IF (x_headers.vendor_contact_tbl(i) IS NOT NULL AND
1219: x_headers.vendor_contact_id_tbl(i) IS NULL) THEN
1220: IF (PO_LOG.d_stmt) THEN
1221: PO_LOG.stmt(d_module, d_position, 'contact id derivation failed');
1222: PO_LOG.stmt(d_module, d_position, 'contact', x_headers.vendor_contact_tbl(i));
1223: END IF;
1224:

Line 1221: PO_LOG.stmt(d_module, d_position, 'contact id derivation failed');

1217:
1218: IF (x_headers.vendor_contact_tbl(i) IS NOT NULL AND
1219: x_headers.vendor_contact_id_tbl(i) IS NULL) THEN
1220: IF (PO_LOG.d_stmt) THEN
1221: PO_LOG.stmt(d_module, d_position, 'contact id derivation failed');
1222: PO_LOG.stmt(d_module, d_position, 'contact', x_headers.vendor_contact_tbl(i));
1223: END IF;
1224:
1225: PO_PDOI_ERR_UTL.add_fatal_error

Line 1222: PO_LOG.stmt(d_module, d_position, 'contact', x_headers.vendor_contact_tbl(i));

1218: IF (x_headers.vendor_contact_tbl(i) IS NOT NULL AND
1219: x_headers.vendor_contact_id_tbl(i) IS NULL) THEN
1220: IF (PO_LOG.d_stmt) THEN
1221: PO_LOG.stmt(d_module, d_position, 'contact id derivation failed');
1222: PO_LOG.stmt(d_module, d_position, 'contact', x_headers.vendor_contact_tbl(i));
1223: END IF;
1224:
1225: PO_PDOI_ERR_UTL.add_fatal_error
1226: (

Line 1243: IF (PO_LOG.d_stmt) THEN

1239: END IF;
1240:
1241: IF (x_headers.style_display_name_tbl(i) IS NOT NULL AND
1242: x_headers.style_id_tbl(i) IS NULL) THEN
1243: IF (PO_LOG.d_stmt) THEN
1244: PO_LOG.stmt(d_module, d_position, 'style id derivation failed');
1245: PO_LOG.stmt(d_module, d_position, 'style_display_name', x_headers.style_display_name_tbl(i));
1246: END IF;
1247:

Line 1244: PO_LOG.stmt(d_module, d_position, 'style id derivation failed');

1240:
1241: IF (x_headers.style_display_name_tbl(i) IS NOT NULL AND
1242: x_headers.style_id_tbl(i) IS NULL) THEN
1243: IF (PO_LOG.d_stmt) THEN
1244: PO_LOG.stmt(d_module, d_position, 'style id derivation failed');
1245: PO_LOG.stmt(d_module, d_position, 'style_display_name', x_headers.style_display_name_tbl(i));
1246: END IF;
1247:
1248: PO_PDOI_ERR_UTL.add_fatal_error

Line 1245: PO_LOG.stmt(d_module, d_position, 'style_display_name', x_headers.style_display_name_tbl(i));

1241: IF (x_headers.style_display_name_tbl(i) IS NOT NULL AND
1242: x_headers.style_id_tbl(i) IS NULL) THEN
1243: IF (PO_LOG.d_stmt) THEN
1244: PO_LOG.stmt(d_module, d_position, 'style id derivation failed');
1245: PO_LOG.stmt(d_module, d_position, 'style_display_name', x_headers.style_display_name_tbl(i));
1246: END IF;
1247:
1248: PO_PDOI_ERR_UTL.add_fatal_error
1249: (

Line 1268: IF (PO_LOG.d_stmt) THEN

1264: IF (PO_PDOI_PARAMS.g_request.document_type =
1265: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN
1266: IF (x_headers.from_rfq_num_tbl(i) IS NOT NULL AND
1267: x_headers.from_header_id_tbl(i) IS NULL) THEN
1268: IF (PO_LOG.d_stmt) THEN
1269: PO_LOG.stmt(d_module, d_position, 'from header id derivation failed');
1270: PO_LOG.stmt(d_module, d_position, 'rfq num', x_headers.from_rfq_num_tbl(i));
1271: END IF;
1272:

Line 1269: PO_LOG.stmt(d_module, d_position, 'from header id derivation failed');

1265: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN
1266: IF (x_headers.from_rfq_num_tbl(i) IS NOT NULL AND
1267: x_headers.from_header_id_tbl(i) IS NULL) THEN
1268: IF (PO_LOG.d_stmt) THEN
1269: PO_LOG.stmt(d_module, d_position, 'from header id derivation failed');
1270: PO_LOG.stmt(d_module, d_position, 'rfq num', x_headers.from_rfq_num_tbl(i));
1271: END IF;
1272:
1273: PO_PDOI_ERR_UTL.add_fatal_error

Line 1270: PO_LOG.stmt(d_module, d_position, 'rfq num', x_headers.from_rfq_num_tbl(i));

1266: IF (x_headers.from_rfq_num_tbl(i) IS NOT NULL AND
1267: x_headers.from_header_id_tbl(i) IS NULL) THEN
1268: IF (PO_LOG.d_stmt) THEN
1269: PO_LOG.stmt(d_module, d_position, 'from header id derivation failed');
1270: PO_LOG.stmt(d_module, d_position, 'rfq num', x_headers.from_rfq_num_tbl(i));
1271: END IF;
1272:
1273: PO_PDOI_ERR_UTL.add_fatal_error
1274: (

Line 1296: IF (PO_LOG.d_stmt) THEN

1292: THEN
1293:
1294: IF (x_headers.clm_award_type_disp_tbl(i) IS NOT NULL AND
1295: x_headers.clm_award_type_tbl(i) IS NULL) THEN
1296: IF (PO_LOG.d_stmt) THEN
1297: PO_LOG.stmt(d_module, d_position, 'clm award type derivation failed');
1298: PO_LOG.stmt(d_module, d_position, 'clm_award_type', x_headers.clm_award_type_disp_tbl(i));
1299: END IF;
1300:

Line 1297: PO_LOG.stmt(d_module, d_position, 'clm award type derivation failed');

1293:
1294: IF (x_headers.clm_award_type_disp_tbl(i) IS NOT NULL AND
1295: x_headers.clm_award_type_tbl(i) IS NULL) THEN
1296: IF (PO_LOG.d_stmt) THEN
1297: PO_LOG.stmt(d_module, d_position, 'clm award type derivation failed');
1298: PO_LOG.stmt(d_module, d_position, 'clm_award_type', x_headers.clm_award_type_disp_tbl(i));
1299: END IF;
1300:
1301: PO_PDOI_ERR_UTL.add_fatal_error

Line 1298: PO_LOG.stmt(d_module, d_position, 'clm_award_type', x_headers.clm_award_type_disp_tbl(i));

1294: IF (x_headers.clm_award_type_disp_tbl(i) IS NOT NULL AND
1295: x_headers.clm_award_type_tbl(i) IS NULL) THEN
1296: IF (PO_LOG.d_stmt) THEN
1297: PO_LOG.stmt(d_module, d_position, 'clm award type derivation failed');
1298: PO_LOG.stmt(d_module, d_position, 'clm_award_type', x_headers.clm_award_type_disp_tbl(i));
1299: END IF;
1300:
1301: PO_PDOI_ERR_UTL.add_fatal_error
1302: (

Line 1319: IF (PO_LOG.d_stmt) THEN

1315: END IF;
1316:
1317: IF (x_headers.clm_award_admin_disp_tbl(i) IS NOT NULL AND
1318: x_headers.clm_award_administrator_tbl(i) IS NULL) THEN
1319: IF (PO_LOG.d_stmt) THEN
1320: PO_LOG.stmt(d_module, d_position, 'clm award admin derivation failed');
1321: PO_LOG.stmt(d_module, d_position, 'clm_award_administrator', x_headers.clm_award_admin_disp_tbl(i));
1322: END IF;
1323:

Line 1320: PO_LOG.stmt(d_module, d_position, 'clm award admin derivation failed');

1316:
1317: IF (x_headers.clm_award_admin_disp_tbl(i) IS NOT NULL AND
1318: x_headers.clm_award_administrator_tbl(i) IS NULL) THEN
1319: IF (PO_LOG.d_stmt) THEN
1320: PO_LOG.stmt(d_module, d_position, 'clm award admin derivation failed');
1321: PO_LOG.stmt(d_module, d_position, 'clm_award_administrator', x_headers.clm_award_admin_disp_tbl(i));
1322: END IF;
1323:
1324: PO_PDOI_ERR_UTL.add_fatal_error

Line 1321: PO_LOG.stmt(d_module, d_position, 'clm_award_administrator', x_headers.clm_award_admin_disp_tbl(i));

1317: IF (x_headers.clm_award_admin_disp_tbl(i) IS NOT NULL AND
1318: x_headers.clm_award_administrator_tbl(i) IS NULL) THEN
1319: IF (PO_LOG.d_stmt) THEN
1320: PO_LOG.stmt(d_module, d_position, 'clm award admin derivation failed');
1321: PO_LOG.stmt(d_module, d_position, 'clm_award_administrator', x_headers.clm_award_admin_disp_tbl(i));
1322: END IF;
1323:
1324: PO_PDOI_ERR_UTL.add_fatal_error
1325: (

Line 1342: IF (PO_LOG.d_stmt) THEN

1338: END IF;
1339:
1340: IF (x_headers.clm_contract_officer_disp_tbl(i) IS NOT NULL AND
1341: x_headers.clm_contract_officer_tbl(i) IS NULL) THEN
1342: IF (PO_LOG.d_stmt) THEN
1343: PO_LOG.stmt(d_module, d_position, 'clm contract officer derivation failed');
1344: PO_LOG.stmt(d_module, d_position, 'clm_contract_officer', x_headers.clm_contract_officer_disp_tbl(i));
1345: END IF;
1346:

Line 1343: PO_LOG.stmt(d_module, d_position, 'clm contract officer derivation failed');

1339:
1340: IF (x_headers.clm_contract_officer_disp_tbl(i) IS NOT NULL AND
1341: x_headers.clm_contract_officer_tbl(i) IS NULL) THEN
1342: IF (PO_LOG.d_stmt) THEN
1343: PO_LOG.stmt(d_module, d_position, 'clm contract officer derivation failed');
1344: PO_LOG.stmt(d_module, d_position, 'clm_contract_officer', x_headers.clm_contract_officer_disp_tbl(i));
1345: END IF;
1346:
1347: PO_PDOI_ERR_UTL.add_fatal_error

Line 1344: PO_LOG.stmt(d_module, d_position, 'clm_contract_officer', x_headers.clm_contract_officer_disp_tbl(i));

1340: IF (x_headers.clm_contract_officer_disp_tbl(i) IS NOT NULL AND
1341: x_headers.clm_contract_officer_tbl(i) IS NULL) THEN
1342: IF (PO_LOG.d_stmt) THEN
1343: PO_LOG.stmt(d_module, d_position, 'clm contract officer derivation failed');
1344: PO_LOG.stmt(d_module, d_position, 'clm_contract_officer', x_headers.clm_contract_officer_disp_tbl(i));
1345: END IF;
1346:
1347: PO_PDOI_ERR_UTL.add_fatal_error
1348: (

Line 1365: IF (PO_LOG.d_stmt) THEN

1361: END IF;
1362:
1363: IF (x_headers.clm_source_document_disp_tbl(i) IS NOT NULL AND
1364: x_headers.clm_source_document_id_tbl(i) IS NULL) THEN
1365: IF (PO_LOG.d_stmt) THEN
1366: PO_LOG.stmt(d_module, d_position, 'clm source document id derivation failed');
1367: PO_LOG.stmt(d_module, d_position, 'clm_source_document_id', x_headers.clm_source_document_disp_tbl(i));
1368: END IF;
1369:

Line 1366: PO_LOG.stmt(d_module, d_position, 'clm source document id derivation failed');

1362:
1363: IF (x_headers.clm_source_document_disp_tbl(i) IS NOT NULL AND
1364: x_headers.clm_source_document_id_tbl(i) IS NULL) THEN
1365: IF (PO_LOG.d_stmt) THEN
1366: PO_LOG.stmt(d_module, d_position, 'clm source document id derivation failed');
1367: PO_LOG.stmt(d_module, d_position, 'clm_source_document_id', x_headers.clm_source_document_disp_tbl(i));
1368: END IF;
1369:
1370: PO_PDOI_ERR_UTL.add_fatal_error

Line 1367: PO_LOG.stmt(d_module, d_position, 'clm_source_document_id', x_headers.clm_source_document_disp_tbl(i));

1363: IF (x_headers.clm_source_document_disp_tbl(i) IS NOT NULL AND
1364: x_headers.clm_source_document_id_tbl(i) IS NULL) THEN
1365: IF (PO_LOG.d_stmt) THEN
1366: PO_LOG.stmt(d_module, d_position, 'clm source document id derivation failed');
1367: PO_LOG.stmt(d_module, d_position, 'clm_source_document_id', x_headers.clm_source_document_disp_tbl(i));
1368: END IF;
1369:
1370: PO_PDOI_ERR_UTL.add_fatal_error
1371: (

Line 1389: IF (PO_LOG.d_stmt) THEN

1385: END IF;
1386: --CLM PDOI Integration Ends
1387: END LOOP;
1388:
1389: IF (PO_LOG.d_stmt) THEN
1390: PO_LOG.stmt(d_module, d_position, 'end of processing derivation errors');
1391: END IF;
1392:
1393: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_HEADER_DERIVE);

Line 1390: PO_LOG.stmt(d_module, d_position, 'end of processing derivation errors');

1386: --CLM PDOI Integration Ends
1387: END LOOP;
1388:
1389: IF (PO_LOG.d_stmt) THEN
1390: PO_LOG.stmt(d_module, d_position, 'end of processing derivation errors');
1391: END IF;
1392:
1393: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_HEADER_DERIVE);
1394:

Line 1395: IF (PO_LOG.d_proc) THEN

1391: END IF;
1392:
1393: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_HEADER_DERIVE);
1394:
1395: IF (PO_LOG.d_proc) THEN
1396: PO_LOG.proc_end (d_module);
1397: END IF;
1398:
1399: EXCEPTION

Line 1396: PO_LOG.proc_end (d_module);

1392:
1393: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_HEADER_DERIVE);
1394:
1395: IF (PO_LOG.d_proc) THEN
1396: PO_LOG.proc_end (d_module);
1397: END IF;
1398:
1399: EXCEPTION
1400: WHEN OTHERS THEN

Line 1475: IF (PO_LOG.d_proc) THEN

1471: l_display_rate NUMBER;
1472: BEGIN
1473: d_position := 0;
1474:
1475: IF (PO_LOG.d_proc) THEN
1476: PO_LOG.proc_begin(d_module);
1477: END IF;
1478:
1479: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_HEADER_DEFAULT);

Line 1476: PO_LOG.proc_begin(d_module);

1472: BEGIN
1473: d_position := 0;
1474:
1475: IF (PO_LOG.d_proc) THEN
1476: PO_LOG.proc_begin(d_module);
1477: END IF;
1478:
1479: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_HEADER_DEFAULT);
1480:

Line 1484: IF (PO_LOG.d_stmt) THEN

1480:
1481: -- pick a new key which will be used in all derive logic
1482: l_key := PO_CORE_S.get_session_gt_nextval;
1483:
1484: IF (PO_LOG.d_stmt) THEN
1485: PO_LOG.stmt(d_module, d_position, 'key', l_key);
1486: END IF;
1487:
1488: -- initialize table containing the row number

Line 1485: PO_LOG.stmt(d_module, d_position, 'key', l_key);

1481: -- pick a new key which will be used in all derive logic
1482: l_key := PO_CORE_S.get_session_gt_nextval;
1483:
1484: IF (PO_LOG.d_stmt) THEN
1485: PO_LOG.stmt(d_module, d_position, 'key', l_key);
1486: END IF;
1487:
1488: -- initialize table containing the row number
1489: PO_PDOI_UTL.generate_ordered_num_list

Line 1544: IF (PO_LOG.d_stmt) THEN

1540: FOR i IN 1..x_headers.rec_count
1541: LOOP
1542: d_position := 50;
1543:
1544: IF (PO_LOG.d_stmt) THEN
1545: PO_LOG.stmt(d_module, d_position, 'index', i);
1546: END IF;
1547:
1548:

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

1541: LOOP
1542: d_position := 50;
1543:
1544: IF (PO_LOG.d_stmt) THEN
1545: PO_LOG.stmt(d_module, d_position, 'index', i);
1546: END IF;
1547:
1548:
1549:

Line 1663: IF (PO_LOG.d_stmt) THEN

1659: (
1660: x_headers.doc_subtype_tbl(i)
1661: );
1662:
1663: IF (PO_LOG.d_stmt) THEN
1664: PO_LOG.stmt(d_module, d_position, 'quote class code',
1665: x_headers.quotation_class_code_tbl(i));
1666: END IF;
1667:

Line 1664: PO_LOG.stmt(d_module, d_position, 'quote class code',

1660: x_headers.doc_subtype_tbl(i)
1661: );
1662:
1663: IF (PO_LOG.d_stmt) THEN
1664: PO_LOG.stmt(d_module, d_position, 'quote class code',
1665: x_headers.quotation_class_code_tbl(i));
1666: END IF;
1667:
1668: -- set global agreement flag to NULL

Line 1733: IF (PO_LOG.d_stmt) THEN

1729: IF (x_headers.document_num_tbl(i) IS NULL) THEN
1730: x_headers.document_num_tbl(i) := -x_headers.po_header_id_tbl(i);
1731: END IF;
1732:
1733: IF (PO_LOG.d_stmt) THEN
1734: PO_LOG.stmt(d_module, d_position, 'temp doc num',
1735: x_headers.document_num_tbl(i));
1736: END IF;
1737:

Line 1734: PO_LOG.stmt(d_module, d_position, 'temp doc num',

1730: x_headers.document_num_tbl(i) := -x_headers.po_header_id_tbl(i);
1731: END IF;
1732:
1733: IF (PO_LOG.d_stmt) THEN
1734: PO_LOG.stmt(d_module, d_position, 'temp doc num',
1735: x_headers.document_num_tbl(i));
1736: END IF;
1737:
1738: END IF;

Line 1806: IF (PO_LOG.d_stmt) THEN

1802: IF (x_headers.document_num_tbl(i) IS NULL) THEN
1803: x_headers.document_num_tbl(i) := -x_headers.po_header_id_tbl(i);
1804: END IF;
1805:
1806: IF (PO_LOG.d_stmt) THEN
1807: PO_LOG.stmt(d_module, d_position, 'temp doc num',
1808: x_headers.document_num_tbl(i));
1809: END IF;
1810: END IF;

Line 1807: PO_LOG.stmt(d_module, d_position, 'temp doc num',

1803: x_headers.document_num_tbl(i) := -x_headers.po_header_id_tbl(i);
1804: END IF;
1805:
1806: IF (PO_LOG.d_stmt) THEN
1807: PO_LOG.stmt(d_module, d_position, 'temp doc num',
1808: x_headers.document_num_tbl(i));
1809: END IF;
1810: END IF;
1811: ELSIF (x_headers.doc_type_tbl(i) = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN

Line 1874: IF (PO_LOG.d_stmt) THEN

1870: IF (x_headers.document_num_tbl(i) IS NULL) THEN
1871: x_headers.document_num_tbl(i) := -x_headers.po_header_id_tbl(i);
1872: END IF;
1873:
1874: IF (PO_LOG.d_stmt) THEN
1875: PO_LOG.stmt(d_module, d_position, 'temp doc num',
1876: x_headers.document_num_tbl(i));
1877: END IF;
1878:

Line 1875: PO_LOG.stmt(d_module, d_position, 'temp doc num',

1871: x_headers.document_num_tbl(i) := -x_headers.po_header_id_tbl(i);
1872: END IF;
1873:
1874: IF (PO_LOG.d_stmt) THEN
1875: PO_LOG.stmt(d_module, d_position, 'temp doc num',
1876: x_headers.document_num_tbl(i));
1877: END IF;
1878:
1879: END IF;

Line 1886: IF (PO_LOG.d_stmt) THEN

1882: d_position := 160;
1883:
1884: -- default rate info after currency is defaulted
1885: IF (x_headers.currency_code_tbl(i) <> PO_PDOI_PARAMS.g_sys.currency_code) THEN
1886: IF (PO_LOG.d_stmt) THEN
1887: PO_LOG.stmt(d_module, d_position, 'default rate info');
1888: PO_LOG.stmt(d_module, d_position, 'currency_code',
1889: x_headers.currency_code_tbl(i));
1890: END IF;

Line 1887: PO_LOG.stmt(d_module, d_position, 'default rate info');

1883:
1884: -- default rate info after currency is defaulted
1885: IF (x_headers.currency_code_tbl(i) <> PO_PDOI_PARAMS.g_sys.currency_code) THEN
1886: IF (PO_LOG.d_stmt) THEN
1887: PO_LOG.stmt(d_module, d_position, 'default rate info');
1888: PO_LOG.stmt(d_module, d_position, 'currency_code',
1889: x_headers.currency_code_tbl(i));
1890: END IF;
1891:

Line 1888: PO_LOG.stmt(d_module, d_position, 'currency_code',

1884: -- default rate info after currency is defaulted
1885: IF (x_headers.currency_code_tbl(i) <> PO_PDOI_PARAMS.g_sys.currency_code) THEN
1886: IF (PO_LOG.d_stmt) THEN
1887: PO_LOG.stmt(d_module, d_position, 'default rate info');
1888: PO_LOG.stmt(d_module, d_position, 'currency_code',
1889: x_headers.currency_code_tbl(i));
1890: END IF;
1891:
1892: -- default rate_date

Line 1911: IF (PO_LOG.d_stmt) THEN

1907: NVL(x_headers.rate_type_code_tbl(i), PO_PDOI_PARAMS.g_sys.default_rate_type); --bug 7653758
1908: END IF;
1909: EXCEPTION
1910: WHEN OTHERS THEN
1911: IF (PO_LOG.d_stmt) THEN
1912: PO_LOG.stmt(d_module, d_position, 'Exception arised in GL_CURRENCY_API');
1913: END IF;
1914: END;
1915:

Line 1912: PO_LOG.stmt(d_module, d_position, 'Exception arised in GL_CURRENCY_API');

1908: END IF;
1909: EXCEPTION
1910: WHEN OTHERS THEN
1911: IF (PO_LOG.d_stmt) THEN
1912: PO_LOG.stmt(d_module, d_position, 'Exception arised in GL_CURRENCY_API');
1913: END IF;
1914: END;
1915:
1916: IF (PO_LOG.d_stmt) THEN

Line 1916: IF (PO_LOG.d_stmt) THEN

1912: PO_LOG.stmt(d_module, d_position, 'Exception arised in GL_CURRENCY_API');
1913: END IF;
1914: END;
1915:
1916: IF (PO_LOG.d_stmt) THEN
1917: PO_LOG.stmt(d_module, d_position, 'rate type',
1918: x_headers.rate_type_code_tbl(i)); --bug7653758
1919: END IF;
1920:

Line 1917: PO_LOG.stmt(d_module, d_position, 'rate type',

1913: END IF;
1914: END;
1915:
1916: IF (PO_LOG.d_stmt) THEN
1917: PO_LOG.stmt(d_module, d_position, 'rate type',
1918: x_headers.rate_type_code_tbl(i)); --bug7653758
1919: END IF;
1920:
1921: d_position := 170;

Line 1937: IF (PO_LOG.d_stmt) THEN

1933: x_rate => x_headers.rate_tbl(i),
1934: x_display_rate => l_display_rate
1935: );
1936:
1937: IF (PO_LOG.d_stmt) THEN
1938: PO_LOG.stmt(d_module, d_position, 'rate', x_headers.rate_tbl(i));
1939: END IF;
1940: END IF;
1941: END IF;

Line 1938: PO_LOG.stmt(d_module, d_position, 'rate', x_headers.rate_tbl(i));

1934: x_display_rate => l_display_rate
1935: );
1936:
1937: IF (PO_LOG.d_stmt) THEN
1938: PO_LOG.stmt(d_module, d_position, 'rate', x_headers.rate_tbl(i));
1939: END IF;
1940: END IF;
1941: END IF;
1942: END LOOP;

Line 1952: IF (PO_LOG.d_stmt) THEN

1948: IF (PO_PDOI_PARAMS.g_request.document_type =
1949: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET AND
1950: PO_PDOI_PARAMS.g_sys.po_encumbrance_flag = 'Y' AND
1951: PO_PDOI_PARAMS.g_sys.req_encumbrance_flag = 'Y') THEN
1952: IF (PO_LOG.d_stmt) THEN
1953: PO_LOG.stmt(d_module, d_position, 'create distribution for blanket' ||
1954: ' since encumbrance is required');
1955: END IF;
1956:

Line 1953: PO_LOG.stmt(d_module, d_position, 'create distribution for blanket' ||

1949: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET AND
1950: PO_PDOI_PARAMS.g_sys.po_encumbrance_flag = 'Y' AND
1951: PO_PDOI_PARAMS.g_sys.req_encumbrance_flag = 'Y') THEN
1952: IF (PO_LOG.d_stmt) THEN
1953: PO_LOG.stmt(d_module, d_position, 'create distribution for blanket' ||
1954: ' since encumbrance is required');
1955: END IF;
1956:
1957: default_dist_attributes

Line 1996: IF (PO_LOG.d_proc) THEN

1992: --CLM PDOI Integration Ends
1993:
1994: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_HEADER_DEFAULT);
1995:
1996: IF (PO_LOG.d_proc) THEN
1997: PO_LOG.proc_end (d_module);
1998: END IF;
1999:
2000: EXCEPTION

Line 1997: PO_LOG.proc_end (d_module);

1993:
1994: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_HEADER_DEFAULT);
1995:
1996: IF (PO_LOG.d_proc) THEN
1997: PO_LOG.proc_end (d_module);
1998: END IF;
1999:
2000: EXCEPTION
2001: WHEN OTHERS THEN

Line 2044: IF (PO_LOG.d_proc) THEN

2040:
2041: BEGIN
2042: d_position := 0;
2043:
2044: IF (PO_LOG.d_proc) THEN
2045: PO_LOG.proc_begin(d_module, 'x_headers', x_headers.intf_header_id_tbl);
2046: END IF;
2047:
2048: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_HEADER_VALIDATE);

Line 2045: PO_LOG.proc_begin(d_module, 'x_headers', x_headers.intf_header_id_tbl);

2041: BEGIN
2042: d_position := 0;
2043:
2044: IF (PO_LOG.d_proc) THEN
2045: PO_LOG.proc_begin(d_module, 'x_headers', x_headers.intf_header_id_tbl);
2046: END IF;
2047:
2048: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_HEADER_VALIDATE);
2049:

Line 2135: IF (PO_LOG.d_stmt) THEN

2131:
2132: d_position := 20;
2133:
2134: IF l_result_type = po_validations.c_result_type_failure THEN
2135: IF (PO_LOG.d_stmt) THEN
2136: PO_LOG.stmt(d_module, d_position, 'vaidate headers return failure');
2137: END IF;
2138:
2139: PO_PDOI_ERR_UTL.process_val_type_errors

Line 2136: PO_LOG.stmt(d_module, d_position, 'vaidate headers return failure');

2132: d_position := 20;
2133:
2134: IF l_result_type = po_validations.c_result_type_failure THEN
2135: IF (PO_LOG.d_stmt) THEN
2136: PO_LOG.stmt(d_module, d_position, 'vaidate headers return failure');
2137: END IF;
2138:
2139: PO_PDOI_ERR_UTL.process_val_type_errors
2140: (

Line 2158: IF (PO_LOG.d_stmt) THEN

2154:
2155: d_position := 40;
2156:
2157: IF l_result_type = po_validations.c_result_type_fatal THEN
2158: IF (PO_LOG.d_stmt) THEN
2159: PO_LOG.stmt(d_module, d_position, 'vaidate headers return fatal');
2160: END IF;
2161:
2162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2159: PO_LOG.stmt(d_module, d_position, 'vaidate headers return fatal');

2155: d_position := 40;
2156:
2157: IF l_result_type = po_validations.c_result_type_fatal THEN
2158: IF (PO_LOG.d_stmt) THEN
2159: PO_LOG.stmt(d_module, d_position, 'vaidate headers return fatal');
2160: END IF;
2161:
2162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2163: END IF;

Line 2169: IF (PO_LOG.d_proc) THEN

2165: d_position := 50;
2166:
2167: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_HEADER_VALIDATE);
2168:
2169: IF (PO_LOG.d_proc) THEN
2170: PO_LOG.proc_end (d_module);
2171: END IF;
2172:
2173: EXCEPTION

Line 2170: PO_LOG.proc_end (d_module);

2166:
2167: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_HEADER_VALIDATE);
2168:
2169: IF (PO_LOG.d_proc) THEN
2170: PO_LOG.proc_end (d_module);
2171: END IF;
2172:
2173: EXCEPTION
2174: WHEN OTHERS THEN

Line 2230: IF (PO_LOG.d_proc) THEN

2226: l_result_tbl PO_TBL_NUMBER;
2227: BEGIN
2228: d_position := 0;
2229:
2230: IF (PO_LOG.d_proc) THEN
2231: PO_LOG.proc_begin(d_module, 'location type', p_location_type);
2232: PO_LOG.proc_begin(d_module, 'locations', p_location_tbl);
2233: PO_LOG.proc_begin(d_module, 'location ids', x_location_id_tbl);
2234: END IF;

Line 2231: PO_LOG.proc_begin(d_module, 'location type', p_location_type);

2227: BEGIN
2228: d_position := 0;
2229:
2230: IF (PO_LOG.d_proc) THEN
2231: PO_LOG.proc_begin(d_module, 'location type', p_location_type);
2232: PO_LOG.proc_begin(d_module, 'locations', p_location_tbl);
2233: PO_LOG.proc_begin(d_module, 'location ids', x_location_id_tbl);
2234: END IF;
2235:

Line 2232: PO_LOG.proc_begin(d_module, 'locations', p_location_tbl);

2228: d_position := 0;
2229:
2230: IF (PO_LOG.d_proc) THEN
2231: PO_LOG.proc_begin(d_module, 'location type', p_location_type);
2232: PO_LOG.proc_begin(d_module, 'locations', p_location_tbl);
2233: PO_LOG.proc_begin(d_module, 'location ids', x_location_id_tbl);
2234: END IF;
2235:
2236: IF (p_location_type = 'SHIP_TO') THEN

Line 2233: PO_LOG.proc_begin(d_module, 'location ids', x_location_id_tbl);

2229:
2230: IF (PO_LOG.d_proc) THEN
2231: PO_LOG.proc_begin(d_module, 'location type', p_location_type);
2232: PO_LOG.proc_begin(d_module, 'locations', p_location_tbl);
2233: PO_LOG.proc_begin(d_module, 'location ids', x_location_id_tbl);
2234: END IF;
2235:
2236: IF (p_location_type = 'SHIP_TO') THEN
2237: FORALL i IN 1..p_index_tbl.COUNT

Line 2270: IF (PO_LOG.d_stmt) THEN

2266: d_position := 20;
2267:
2268: FOR i IN 1..l_index_tbl.COUNT
2269: LOOP
2270: IF (PO_LOG.d_stmt) THEN
2271: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2272: PO_LOG.stmt(d_module, d_position, 'new location id', l_result_tbl(i));
2273: END IF;
2274:

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

2267:
2268: FOR i IN 1..l_index_tbl.COUNT
2269: LOOP
2270: IF (PO_LOG.d_stmt) THEN
2271: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2272: PO_LOG.stmt(d_module, d_position, 'new location id', l_result_tbl(i));
2273: END IF;
2274:
2275: x_location_id_tbl(l_index_tbl(i)) := l_result_tbl(i);

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

2268: FOR i IN 1..l_index_tbl.COUNT
2269: LOOP
2270: IF (PO_LOG.d_stmt) THEN
2271: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2272: PO_LOG.stmt(d_module, d_position, 'new location id', l_result_tbl(i));
2273: END IF;
2274:
2275: x_location_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
2276: END LOOP;

Line 2278: IF (PO_LOG.d_proc) THEN

2274:
2275: x_location_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
2276: END LOOP;
2277:
2278: IF (PO_LOG.d_proc) THEN
2279: PO_LOG.proc_end(d_module);
2280: END IF;
2281:
2282: EXCEPTION

Line 2279: PO_LOG.proc_end(d_module);

2275: x_location_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
2276: END LOOP;
2277:
2278: IF (PO_LOG.d_proc) THEN
2279: PO_LOG.proc_end(d_module);
2280: END IF;
2281:
2282: EXCEPTION
2283: WHEN OTHERS THEN

Line 2336: IF (PO_LOG.d_proc) THEN

2332: l_result_tbl PO_TBL_NUMBER;
2333: BEGIN
2334: d_position := 0;
2335:
2336: IF (PO_LOG.d_proc) THEN
2337: PO_LOG.proc_begin(d_module, 'payment terms', p_payment_terms_tbl);
2338: PO_LOG.proc_begin(d_module, 'terms ids', x_terms_id_tbl);
2339: END IF;
2340:

Line 2337: PO_LOG.proc_begin(d_module, 'payment terms', p_payment_terms_tbl);

2333: BEGIN
2334: d_position := 0;
2335:
2336: IF (PO_LOG.d_proc) THEN
2337: PO_LOG.proc_begin(d_module, 'payment terms', p_payment_terms_tbl);
2338: PO_LOG.proc_begin(d_module, 'terms ids', x_terms_id_tbl);
2339: END IF;
2340:
2341: FORALL i IN 1..p_index_tbl.COUNT

Line 2338: PO_LOG.proc_begin(d_module, 'terms ids', x_terms_id_tbl);

2334: d_position := 0;
2335:
2336: IF (PO_LOG.d_proc) THEN
2337: PO_LOG.proc_begin(d_module, 'payment terms', p_payment_terms_tbl);
2338: PO_LOG.proc_begin(d_module, 'terms ids', x_terms_id_tbl);
2339: END IF;
2340:
2341: FORALL i IN 1..p_index_tbl.COUNT
2342: INSERT INTO po_session_gt(key, num1, num2)

Line 2364: IF (PO_LOG.d_stmt) THEN

2360: d_position := 20;
2361:
2362: FOR i IN 1..l_index_tbl.COUNT
2363: LOOP
2364: IF (PO_LOG.d_stmt) THEN
2365: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2366: PO_LOG.stmt(d_module, d_position, 'new terms id', l_result_tbl(i));
2367: END IF;
2368:

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

2361:
2362: FOR i IN 1..l_index_tbl.COUNT
2363: LOOP
2364: IF (PO_LOG.d_stmt) THEN
2365: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2366: PO_LOG.stmt(d_module, d_position, 'new terms id', l_result_tbl(i));
2367: END IF;
2368:
2369: x_terms_id_tbl(l_index_tbl(i)) := l_result_tbl(i);

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

2362: FOR i IN 1..l_index_tbl.COUNT
2363: LOOP
2364: IF (PO_LOG.d_stmt) THEN
2365: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2366: PO_LOG.stmt(d_module, d_position, 'new terms id', l_result_tbl(i));
2367: END IF;
2368:
2369: x_terms_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
2370: END LOOP;

Line 2372: IF (PO_LOG.d_proc) THEN

2368:
2369: x_terms_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
2370: END LOOP;
2371:
2372: IF (PO_LOG.d_proc) THEN
2373: PO_LOG.proc_end (d_module);
2374: END IF;
2375:
2376: EXCEPTION

Line 2373: PO_LOG.proc_end (d_module);

2369: x_terms_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
2370: END LOOP;
2371:
2372: IF (PO_LOG.d_proc) THEN
2373: PO_LOG.proc_end (d_module);
2374: END IF;
2375:
2376: EXCEPTION
2377: WHEN OTHERS THEN

Line 2437: IF (PO_LOG.d_proc) THEN

2433: l_index NUMBER;
2434: BEGIN
2435: d_position := 0;
2436:
2437: IF (PO_LOG.d_proc) THEN
2438: PO_LOG.proc_begin(d_module, 'vendor names', p_vendor_name_tbl);
2439: PO_LOG.proc_begin(d_module, 'vendor nums', p_vendor_num_tbl);
2440: PO_LOG.proc_begin(d_module, 'vendor ids', x_vendor_id_tbl);
2441: END IF;

Line 2438: PO_LOG.proc_begin(d_module, 'vendor names', p_vendor_name_tbl);

2434: BEGIN
2435: d_position := 0;
2436:
2437: IF (PO_LOG.d_proc) THEN
2438: PO_LOG.proc_begin(d_module, 'vendor names', p_vendor_name_tbl);
2439: PO_LOG.proc_begin(d_module, 'vendor nums', p_vendor_num_tbl);
2440: PO_LOG.proc_begin(d_module, 'vendor ids', x_vendor_id_tbl);
2441: END IF;
2442:

Line 2439: PO_LOG.proc_begin(d_module, 'vendor nums', p_vendor_num_tbl);

2435: d_position := 0;
2436:
2437: IF (PO_LOG.d_proc) THEN
2438: PO_LOG.proc_begin(d_module, 'vendor names', p_vendor_name_tbl);
2439: PO_LOG.proc_begin(d_module, 'vendor nums', p_vendor_num_tbl);
2440: PO_LOG.proc_begin(d_module, 'vendor ids', x_vendor_id_tbl);
2441: END IF;
2442:
2443: FORALL i IN 1..p_index_tbl.COUNT

Line 2440: PO_LOG.proc_begin(d_module, 'vendor ids', x_vendor_id_tbl);

2436:
2437: IF (PO_LOG.d_proc) THEN
2438: PO_LOG.proc_begin(d_module, 'vendor names', p_vendor_name_tbl);
2439: PO_LOG.proc_begin(d_module, 'vendor nums', p_vendor_num_tbl);
2440: PO_LOG.proc_begin(d_module, 'vendor ids', x_vendor_id_tbl);
2441: END IF;
2442:
2443: FORALL i IN 1..p_index_tbl.COUNT
2444: INSERT INTO po_session_gt(key, num1, num2)

Line 2471: IF (PO_LOG.d_stmt) THEN

2467: FOR i IN 1..l_index_tbl.COUNT
2468: LOOP
2469: l_index := l_index_tbl(i);
2470:
2471: IF (PO_LOG.d_stmt) THEN
2472: PO_LOG.stmt(d_module, d_position, 'index', l_index);
2473: PO_LOG.stmt(d_module, d_position, 'new vendor id', l_result_tbl(i));
2474: END IF;
2475:

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

2468: LOOP
2469: l_index := l_index_tbl(i);
2470:
2471: IF (PO_LOG.d_stmt) THEN
2472: PO_LOG.stmt(d_module, d_position, 'index', l_index);
2473: PO_LOG.stmt(d_module, d_position, 'new vendor id', l_result_tbl(i));
2474: END IF;
2475:
2476: IF (x_vendor_id_tbl(l_index) IS NULL) THEN

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

2469: l_index := l_index_tbl(i);
2470:
2471: IF (PO_LOG.d_stmt) THEN
2472: PO_LOG.stmt(d_module, d_position, 'index', l_index);
2473: PO_LOG.stmt(d_module, d_position, 'new vendor id', l_result_tbl(i));
2474: END IF;
2475:
2476: IF (x_vendor_id_tbl(l_index) IS NULL) THEN
2477: x_vendor_id_tbl(l_index) := l_result_tbl(i);

Line 2483: IF (PO_LOG.d_proc) THEN

2479: x_vendor_id_tbl(l_index) := NULL;
2480: END IF;
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: END IF;
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 2545: IF (PO_LOG.d_proc) THEN

2541: l_result_tbl PO_TBL_VARCHAR30;
2542: BEGIN
2543: d_position := 0;
2544:
2545: IF (PO_LOG.d_proc) THEN
2546: PO_LOG.proc_begin(d_module, 'rate type', p_rate_type_tbl);
2547: PO_LOG.proc_begin(d_module, 'rate type code', x_rate_type_code_tbl);
2548: END IF;
2549:

Line 2546: PO_LOG.proc_begin(d_module, 'rate type', p_rate_type_tbl);

2542: BEGIN
2543: d_position := 0;
2544:
2545: IF (PO_LOG.d_proc) THEN
2546: PO_LOG.proc_begin(d_module, 'rate type', p_rate_type_tbl);
2547: PO_LOG.proc_begin(d_module, 'rate type code', x_rate_type_code_tbl);
2548: END IF;
2549:
2550: FORALL i IN 1..p_index_tbl.COUNT

Line 2547: PO_LOG.proc_begin(d_module, 'rate type code', x_rate_type_code_tbl);

2543: d_position := 0;
2544:
2545: IF (PO_LOG.d_proc) THEN
2546: PO_LOG.proc_begin(d_module, 'rate type', p_rate_type_tbl);
2547: PO_LOG.proc_begin(d_module, 'rate type code', x_rate_type_code_tbl);
2548: END IF;
2549:
2550: FORALL i IN 1..p_index_tbl.COUNT
2551: INSERT INTO po_session_gt(key, num1, char1)

Line 2570: IF (PO_LOG.d_stmt) THEN

2566: d_position := 20;
2567:
2568: FOR i IN 1..l_index_tbl.COUNT
2569: LOOP
2570: IF (PO_LOG.d_stmt) THEN
2571: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2572: PO_LOG.stmt(d_module, d_position, 'new rate type code', l_result_tbl(i));
2573: END IF;
2574:

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

2567:
2568: FOR i IN 1..l_index_tbl.COUNT
2569: LOOP
2570: IF (PO_LOG.d_stmt) THEN
2571: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2572: PO_LOG.stmt(d_module, d_position, 'new rate type code', l_result_tbl(i));
2573: END IF;
2574:
2575: x_rate_type_code_tbl(l_index_tbl(i)) := l_result_tbl(i);

Line 2572: PO_LOG.stmt(d_module, d_position, 'new rate type code', l_result_tbl(i));

2568: FOR i IN 1..l_index_tbl.COUNT
2569: LOOP
2570: IF (PO_LOG.d_stmt) THEN
2571: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2572: PO_LOG.stmt(d_module, d_position, 'new rate type code', l_result_tbl(i));
2573: END IF;
2574:
2575: x_rate_type_code_tbl(l_index_tbl(i)) := l_result_tbl(i);
2576: END LOOP;

Line 2578: IF (PO_LOG.d_proc) THEN

2574:
2575: x_rate_type_code_tbl(l_index_tbl(i)) := l_result_tbl(i);
2576: END LOOP;
2577:
2578: IF (PO_LOG.d_proc) THEN
2579: PO_LOG.proc_end (d_module);
2580: END IF;
2581:
2582: EXCEPTION

Line 2579: PO_LOG.proc_end (d_module);

2575: x_rate_type_code_tbl(l_index_tbl(i)) := l_result_tbl(i);
2576: END LOOP;
2577:
2578: IF (PO_LOG.d_proc) THEN
2579: PO_LOG.proc_end (d_module);
2580: END IF;
2581:
2582: EXCEPTION
2583: WHEN OTHERS THEN

Line 2636: IF (PO_LOG.d_proc) THEN

2632: l_result_tbl PO_TBL_NUMBER;
2633: BEGIN
2634: d_position := 0;
2635:
2636: IF (PO_LOG.d_proc) THEN
2637: PO_LOG.proc_begin(d_module, 'agent name', p_agent_name_tbl);
2638: PO_LOG.proc_begin(d_module, 'agent id', x_agent_id_tbl);
2639: END IF;
2640:

Line 2637: PO_LOG.proc_begin(d_module, 'agent name', p_agent_name_tbl);

2633: BEGIN
2634: d_position := 0;
2635:
2636: IF (PO_LOG.d_proc) THEN
2637: PO_LOG.proc_begin(d_module, 'agent name', p_agent_name_tbl);
2638: PO_LOG.proc_begin(d_module, 'agent id', x_agent_id_tbl);
2639: END IF;
2640:
2641: FORALL i IN 1..p_index_tbl.COUNT

Line 2638: PO_LOG.proc_begin(d_module, 'agent id', x_agent_id_tbl);

2634: d_position := 0;
2635:
2636: IF (PO_LOG.d_proc) THEN
2637: PO_LOG.proc_begin(d_module, 'agent name', p_agent_name_tbl);
2638: PO_LOG.proc_begin(d_module, 'agent id', x_agent_id_tbl);
2639: END IF;
2640:
2641: FORALL i IN 1..p_index_tbl.COUNT
2642: INSERT INTO po_session_gt(key, num1, num2)

Line 2661: IF (PO_LOG.d_stmt) THEN

2657: d_position := 20;
2658:
2659: FOR i IN 1..l_index_tbl.COUNT
2660: LOOP
2661: IF (PO_LOG.d_stmt) THEN
2662: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2663: PO_LOG.stmt(d_module, d_position, 'new agent id', l_result_tbl(i));
2664: END IF;
2665:

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

2658:
2659: FOR i IN 1..l_index_tbl.COUNT
2660: LOOP
2661: IF (PO_LOG.d_stmt) THEN
2662: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2663: PO_LOG.stmt(d_module, d_position, 'new agent id', l_result_tbl(i));
2664: END IF;
2665:
2666: x_agent_id_tbl(l_index_tbl(i)) := l_result_tbl(i);

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

2659: FOR i IN 1..l_index_tbl.COUNT
2660: LOOP
2661: IF (PO_LOG.d_stmt) THEN
2662: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2663: PO_LOG.stmt(d_module, d_position, 'new agent id', l_result_tbl(i));
2664: END IF;
2665:
2666: x_agent_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
2667: END LOOP;

Line 2669: IF (PO_LOG.d_proc) THEN

2665:
2666: x_agent_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
2667: END LOOP;
2668:
2669: IF (PO_LOG.d_proc) THEN
2670: PO_LOG.proc_end (d_module);
2671: END IF;
2672:
2673: EXCEPTION

Line 2670: PO_LOG.proc_end (d_module);

2666: x_agent_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
2667: END LOOP;
2668:
2669: IF (PO_LOG.d_proc) THEN
2670: PO_LOG.proc_end (d_module);
2671: END IF;
2672:
2673: EXCEPTION
2674: WHEN OTHERS THEN

Line 2730: IF (PO_LOG.d_proc) THEN

2726: l_result_tbl PO_TBL_NUMBER;
2727: BEGIN
2728: d_position := 0;
2729:
2730: IF (PO_LOG.d_proc) THEN
2731: PO_LOG.proc_begin(d_module, 'vendor id', p_vendor_id_tbl);
2732: PO_LOG.proc_begin(d_module, 'site code', p_vendor_site_code_tbl);
2733: PO_LOG.proc_begin(d_module, 'site id', x_vendor_site_id_tbl);
2734: END IF;

Line 2731: PO_LOG.proc_begin(d_module, 'vendor id', p_vendor_id_tbl);

2727: BEGIN
2728: d_position := 0;
2729:
2730: IF (PO_LOG.d_proc) THEN
2731: PO_LOG.proc_begin(d_module, 'vendor id', p_vendor_id_tbl);
2732: PO_LOG.proc_begin(d_module, 'site code', p_vendor_site_code_tbl);
2733: PO_LOG.proc_begin(d_module, 'site id', x_vendor_site_id_tbl);
2734: END IF;
2735:

Line 2732: PO_LOG.proc_begin(d_module, 'site code', p_vendor_site_code_tbl);

2728: d_position := 0;
2729:
2730: IF (PO_LOG.d_proc) THEN
2731: PO_LOG.proc_begin(d_module, 'vendor id', p_vendor_id_tbl);
2732: PO_LOG.proc_begin(d_module, 'site code', p_vendor_site_code_tbl);
2733: PO_LOG.proc_begin(d_module, 'site id', x_vendor_site_id_tbl);
2734: END IF;
2735:
2736: FORALL i IN 1..p_index_tbl.COUNT

Line 2733: PO_LOG.proc_begin(d_module, 'site id', x_vendor_site_id_tbl);

2729:
2730: IF (PO_LOG.d_proc) THEN
2731: PO_LOG.proc_begin(d_module, 'vendor id', p_vendor_id_tbl);
2732: PO_LOG.proc_begin(d_module, 'site code', p_vendor_site_code_tbl);
2733: PO_LOG.proc_begin(d_module, 'site id', x_vendor_site_id_tbl);
2734: END IF;
2735:
2736: FORALL i IN 1..p_index_tbl.COUNT
2737: INSERT INTO po_session_gt(key, num1, num2)

Line 2758: IF (PO_LOG.d_stmt) THEN

2754: d_position := 20;
2755:
2756: FOR i IN 1..l_index_tbl.COUNT
2757: LOOP
2758: IF (PO_LOG.d_stmt) THEN
2759: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2760: PO_LOG.stmt(d_module, d_position, 'new site id', l_result_tbl(i));
2761: END IF;
2762:

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

2755:
2756: FOR i IN 1..l_index_tbl.COUNT
2757: LOOP
2758: IF (PO_LOG.d_stmt) THEN
2759: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2760: PO_LOG.stmt(d_module, d_position, 'new site id', l_result_tbl(i));
2761: END IF;
2762:
2763: x_vendor_site_id_tbl(l_index_tbl(i)) := l_result_tbl(i);

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

2756: FOR i IN 1..l_index_tbl.COUNT
2757: LOOP
2758: IF (PO_LOG.d_stmt) THEN
2759: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2760: PO_LOG.stmt(d_module, d_position, 'new site id', l_result_tbl(i));
2761: END IF;
2762:
2763: x_vendor_site_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
2764: END LOOP;

Line 2766: IF (PO_LOG.d_proc) THEN

2762:
2763: x_vendor_site_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
2764: END LOOP;
2765:
2766: IF (PO_LOG.d_proc) THEN
2767: PO_LOG.proc_end (d_module);
2768: END IF;
2769:
2770: EXCEPTION

Line 2767: PO_LOG.proc_end (d_module);

2763: x_vendor_site_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
2764: END LOOP;
2765:
2766: IF (PO_LOG.d_proc) THEN
2767: PO_LOG.proc_end (d_module);
2768: END IF;
2769:
2770: EXCEPTION
2771: WHEN OTHERS THEN

Line 2828: IF (PO_LOG.d_proc) THEN

2824: l_result_tbl PO_TBL_NUMBER;
2825: BEGIN
2826: d_position := 0;
2827:
2828: IF (PO_LOG.d_proc) THEN
2829: PO_LOG.proc_begin(d_module, 'site id', p_vendor_site_id_tbl);
2830: PO_LOG.proc_begin(d_module, 'contact', p_vendor_contact_tbl);
2831: PO_LOG.proc_begin(d_module, 'contact id', x_vendor_contact_id_tbl);
2832: END IF;

Line 2829: PO_LOG.proc_begin(d_module, 'site id', p_vendor_site_id_tbl);

2825: BEGIN
2826: d_position := 0;
2827:
2828: IF (PO_LOG.d_proc) THEN
2829: PO_LOG.proc_begin(d_module, 'site id', p_vendor_site_id_tbl);
2830: PO_LOG.proc_begin(d_module, 'contact', p_vendor_contact_tbl);
2831: PO_LOG.proc_begin(d_module, 'contact id', x_vendor_contact_id_tbl);
2832: END IF;
2833:

Line 2830: PO_LOG.proc_begin(d_module, 'contact', p_vendor_contact_tbl);

2826: d_position := 0;
2827:
2828: IF (PO_LOG.d_proc) THEN
2829: PO_LOG.proc_begin(d_module, 'site id', p_vendor_site_id_tbl);
2830: PO_LOG.proc_begin(d_module, 'contact', p_vendor_contact_tbl);
2831: PO_LOG.proc_begin(d_module, 'contact id', x_vendor_contact_id_tbl);
2832: END IF;
2833:
2834: FORALL i IN 1..p_index_tbl.COUNT

Line 2831: PO_LOG.proc_begin(d_module, 'contact id', x_vendor_contact_id_tbl);

2827:
2828: IF (PO_LOG.d_proc) THEN
2829: PO_LOG.proc_begin(d_module, 'site id', p_vendor_site_id_tbl);
2830: PO_LOG.proc_begin(d_module, 'contact', p_vendor_contact_tbl);
2831: PO_LOG.proc_begin(d_module, 'contact id', x_vendor_contact_id_tbl);
2832: END IF;
2833:
2834: FORALL i IN 1..p_index_tbl.COUNT
2835: INSERT INTO po_session_gt(key, num1, num2)

Line 2856: IF (PO_LOG.d_stmt) THEN

2852: d_position := 20;
2853:
2854: FOR i IN 1..l_index_tbl.COUNT
2855: LOOP
2856: IF (PO_LOG.d_stmt) THEN
2857: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2858: PO_LOG.stmt(d_module, d_position, 'new contact id', l_result_tbl(i));
2859: END IF;
2860:

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

2853:
2854: FOR i IN 1..l_index_tbl.COUNT
2855: LOOP
2856: IF (PO_LOG.d_stmt) THEN
2857: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2858: PO_LOG.stmt(d_module, d_position, 'new contact id', l_result_tbl(i));
2859: END IF;
2860:
2861: x_vendor_contact_id_tbl(l_index_tbl(i)) := l_result_tbl(i);

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

2854: FOR i IN 1..l_index_tbl.COUNT
2855: LOOP
2856: IF (PO_LOG.d_stmt) THEN
2857: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2858: PO_LOG.stmt(d_module, d_position, 'new contact id', l_result_tbl(i));
2859: END IF;
2860:
2861: x_vendor_contact_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
2862: END LOOP;

Line 2864: IF (PO_LOG.d_proc) THEN

2860:
2861: x_vendor_contact_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
2862: END LOOP;
2863:
2864: IF (PO_LOG.d_proc) THEN
2865: PO_LOG.proc_end (d_module);
2866: END IF;
2867:
2868: EXCEPTION

Line 2865: PO_LOG.proc_end (d_module);

2861: x_vendor_contact_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
2862: END LOOP;
2863:
2864: IF (PO_LOG.d_proc) THEN
2865: PO_LOG.proc_end (d_module);
2866: END IF;
2867:
2868: EXCEPTION
2869: WHEN OTHERS THEN

Line 2926: IF (PO_LOG.d_proc) THEN

2922: l_result_tbl PO_TBL_NUMBER;
2923: BEGIN
2924: d_position := 0;
2925:
2926: IF (PO_LOG.d_proc) THEN
2927: PO_LOG.proc_begin(d_module, 'x_style_id_tbl', x_style_id_tbl);
2928: PO_LOG.proc_begin(d_module, 'p_style_display_name_tbl', p_style_display_name_tbl);
2929: END IF;
2930:

Line 2927: PO_LOG.proc_begin(d_module, 'x_style_id_tbl', x_style_id_tbl);

2923: BEGIN
2924: d_position := 0;
2925:
2926: IF (PO_LOG.d_proc) THEN
2927: PO_LOG.proc_begin(d_module, 'x_style_id_tbl', x_style_id_tbl);
2928: PO_LOG.proc_begin(d_module, 'p_style_display_name_tbl', p_style_display_name_tbl);
2929: END IF;
2930:
2931: FORALL i IN 1..p_index_tbl.COUNT

Line 2928: PO_LOG.proc_begin(d_module, 'p_style_display_name_tbl', p_style_display_name_tbl);

2924: d_position := 0;
2925:
2926: IF (PO_LOG.d_proc) THEN
2927: PO_LOG.proc_begin(d_module, 'x_style_id_tbl', x_style_id_tbl);
2928: PO_LOG.proc_begin(d_module, 'p_style_display_name_tbl', p_style_display_name_tbl);
2929: END IF;
2930:
2931: FORALL i IN 1..p_index_tbl.COUNT
2932: INSERT INTO po_session_gt(key, num1, num2)

Line 2951: IF (PO_LOG.d_stmt) THEN

2947: d_position := 20;
2948:
2949: FOR i IN 1..l_index_tbl.COUNT
2950: LOOP
2951: IF (PO_LOG.d_stmt) THEN
2952: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2953: PO_LOG.stmt(d_module, d_position, 'new style id', l_result_tbl(i));
2954: END IF;
2955:

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

2948:
2949: FOR i IN 1..l_index_tbl.COUNT
2950: LOOP
2951: IF (PO_LOG.d_stmt) THEN
2952: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2953: PO_LOG.stmt(d_module, d_position, 'new style id', l_result_tbl(i));
2954: END IF;
2955:
2956: x_style_id_tbl(l_index_tbl(i)) := l_result_tbl(i);

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

2949: FOR i IN 1..l_index_tbl.COUNT
2950: LOOP
2951: IF (PO_LOG.d_stmt) THEN
2952: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2953: PO_LOG.stmt(d_module, d_position, 'new style id', l_result_tbl(i));
2954: END IF;
2955:
2956: x_style_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
2957: END LOOP;

Line 2959: IF (PO_LOG.d_proc) THEN

2955:
2956: x_style_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
2957: END LOOP;
2958:
2959: IF (PO_LOG.d_proc) THEN
2960: PO_LOG.proc_end (d_module);
2961: END IF;
2962:
2963: EXCEPTION

Line 2960: PO_LOG.proc_end (d_module);

2956: x_style_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
2957: END LOOP;
2958:
2959: IF (PO_LOG.d_proc) THEN
2960: PO_LOG.proc_end (d_module);
2961: END IF;
2962:
2963: EXCEPTION
2964: WHEN OTHERS THEN

Line 3018: IF (PO_LOG.d_proc) THEN

3014: l_result_tbl PO_TBL_NUMBER;
3015: BEGIN
3016: d_position := 0;
3017:
3018: IF (PO_LOG.d_proc) THEN
3019: PO_LOG.proc_begin(d_module, 'from rfq num', p_from_rfq_num_tbl);
3020: PO_LOG.proc_begin(d_module, 'from header id', x_from_header_id_tbl);
3021: END IF;
3022:

Line 3019: PO_LOG.proc_begin(d_module, 'from rfq num', p_from_rfq_num_tbl);

3015: BEGIN
3016: d_position := 0;
3017:
3018: IF (PO_LOG.d_proc) THEN
3019: PO_LOG.proc_begin(d_module, 'from rfq num', p_from_rfq_num_tbl);
3020: PO_LOG.proc_begin(d_module, 'from header id', x_from_header_id_tbl);
3021: END IF;
3022:
3023: FORALL i IN 1..p_index_tbl.COUNT

Line 3020: PO_LOG.proc_begin(d_module, 'from header id', x_from_header_id_tbl);

3016: d_position := 0;
3017:
3018: IF (PO_LOG.d_proc) THEN
3019: PO_LOG.proc_begin(d_module, 'from rfq num', p_from_rfq_num_tbl);
3020: PO_LOG.proc_begin(d_module, 'from header id', x_from_header_id_tbl);
3021: END IF;
3022:
3023: FORALL i IN 1..p_index_tbl.COUNT
3024: INSERT INTO po_session_gt(key, num1, num2)

Line 3044: IF (PO_LOG.d_stmt) THEN

3040: d_position := 20;
3041:
3042: FOR i IN 1..l_index_tbl.COUNT
3043: LOOP
3044: IF (PO_LOG.d_stmt) THEN
3045: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3046: PO_LOG.stmt(d_module, d_position, 'new from header id', l_result_tbl(i));
3047: END IF;
3048:

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

3041:
3042: FOR i IN 1..l_index_tbl.COUNT
3043: LOOP
3044: IF (PO_LOG.d_stmt) THEN
3045: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3046: PO_LOG.stmt(d_module, d_position, 'new from header id', l_result_tbl(i));
3047: END IF;
3048:
3049: x_from_header_id_tbl(l_index_tbl(i)) := l_result_tbl(i);

Line 3046: PO_LOG.stmt(d_module, d_position, 'new from header id', l_result_tbl(i));

3042: FOR i IN 1..l_index_tbl.COUNT
3043: LOOP
3044: IF (PO_LOG.d_stmt) THEN
3045: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3046: PO_LOG.stmt(d_module, d_position, 'new from header id', l_result_tbl(i));
3047: END IF;
3048:
3049: x_from_header_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
3050: END LOOP;

Line 3052: IF (PO_LOG.d_proc) THEN

3048:
3049: x_from_header_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
3050: END LOOP;
3051:
3052: IF (PO_LOG.d_proc) THEN
3053: PO_LOG.proc_end (d_module);
3054: END IF;
3055:
3056: EXCEPTION

Line 3053: PO_LOG.proc_end (d_module);

3049: x_from_header_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
3050: END LOOP;
3051:
3052: IF (PO_LOG.d_proc) THEN
3053: PO_LOG.proc_end (d_module);
3054: END IF;
3055:
3056: EXCEPTION
3057: WHEN OTHERS THEN

Line 3119: IF (PO_LOG.d_proc) THEN

3115:
3116: BEGIN
3117: d_position := 0;
3118:
3119: IF (PO_LOG.d_proc) THEN
3120: PO_LOG.proc_begin(d_module, 'vendor ids', p_vendor_id_tbl);
3121: END IF;
3122:
3123: -- Initialize OUT parameters

Line 3120: PO_LOG.proc_begin(d_module, 'vendor ids', p_vendor_id_tbl);

3116: BEGIN
3117: d_position := 0;
3118:
3119: IF (PO_LOG.d_proc) THEN
3120: PO_LOG.proc_begin(d_module, 'vendor ids', p_vendor_id_tbl);
3121: END IF;
3122:
3123: -- Initialize OUT parameters
3124:

Line 3161: IF (PO_LOG.d_stmt) THEN

3157: l_terms_id_tbl;
3158:
3159: d_position := 20;
3160:
3161: IF (PO_LOG.d_stmt) THEN
3162: PO_LOG.stmt(d_module, d_position, 'l_index_tbl.COUNT', l_index_tbl.COUNT);
3163: END IF;
3164:
3165: FOR i IN 1..l_index_tbl.COUNT

Line 3162: PO_LOG.stmt(d_module, d_position, 'l_index_tbl.COUNT', l_index_tbl.COUNT);

3158:
3159: d_position := 20;
3160:
3161: IF (PO_LOG.d_stmt) THEN
3162: PO_LOG.stmt(d_module, d_position, 'l_index_tbl.COUNT', l_index_tbl.COUNT);
3163: END IF;
3164:
3165: FOR i IN 1..l_index_tbl.COUNT
3166: LOOP

Line 3169: IF (PO_LOG.d_stmt) THEN

3165: FOR i IN 1..l_index_tbl.COUNT
3166: LOOP
3167: l_index := l_index_tbl(i);
3168:
3169: IF (PO_LOG.d_stmt) THEN
3170: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3171: PO_LOG.stmt(d_module, d_position, 'new currency', l_currency_code_tbl(i));
3172: PO_LOG.stmt(d_module, d_position, 'new terms id', l_terms_id_tbl(i));
3173: END IF;

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

3166: LOOP
3167: l_index := l_index_tbl(i);
3168:
3169: IF (PO_LOG.d_stmt) THEN
3170: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3171: PO_LOG.stmt(d_module, d_position, 'new currency', l_currency_code_tbl(i));
3172: PO_LOG.stmt(d_module, d_position, 'new terms id', l_terms_id_tbl(i));
3173: END IF;
3174:

Line 3171: PO_LOG.stmt(d_module, d_position, 'new currency', l_currency_code_tbl(i));

3167: l_index := l_index_tbl(i);
3168:
3169: IF (PO_LOG.d_stmt) THEN
3170: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3171: PO_LOG.stmt(d_module, d_position, 'new currency', l_currency_code_tbl(i));
3172: PO_LOG.stmt(d_module, d_position, 'new terms id', l_terms_id_tbl(i));
3173: END IF;
3174:
3175: x_invoice_currency_code_tbl(l_index) := l_currency_code_tbl(i);

Line 3172: PO_LOG.stmt(d_module, d_position, 'new terms id', l_terms_id_tbl(i));

3168:
3169: IF (PO_LOG.d_stmt) THEN
3170: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3171: PO_LOG.stmt(d_module, d_position, 'new currency', l_currency_code_tbl(i));
3172: PO_LOG.stmt(d_module, d_position, 'new terms id', l_terms_id_tbl(i));
3173: END IF;
3174:
3175: x_invoice_currency_code_tbl(l_index) := l_currency_code_tbl(i);
3176: x_terms_id_tbl(l_index) := l_terms_id_tbl(i);

Line 3181: IF (PO_LOG.d_proc) THEN

3177: END LOOP;
3178:
3179: d_position := 30;
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:
3179: d_position := 30;
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 3282: IF (PO_LOG.d_proc) THEN

3278:
3279: BEGIN
3280: d_position := 0;
3281:
3282: IF (PO_LOG.d_proc) THEN
3283: PO_LOG.proc_begin(d_module, 'vendor ids', p_vendor_id_tbl);
3284: PO_LOG.proc_begin(d_module, 'vendor site ids', x_vendor_site_id_tbl);
3285: END IF;
3286:

Line 3283: PO_LOG.proc_begin(d_module, 'vendor ids', p_vendor_id_tbl);

3279: BEGIN
3280: d_position := 0;
3281:
3282: IF (PO_LOG.d_proc) THEN
3283: PO_LOG.proc_begin(d_module, 'vendor ids', p_vendor_id_tbl);
3284: PO_LOG.proc_begin(d_module, 'vendor site ids', x_vendor_site_id_tbl);
3285: END IF;
3286:
3287: x_fob_tbl := PO_TBL_VARCHAR30();

Line 3284: PO_LOG.proc_begin(d_module, 'vendor site ids', x_vendor_site_id_tbl);

3280: d_position := 0;
3281:
3282: IF (PO_LOG.d_proc) THEN
3283: PO_LOG.proc_begin(d_module, 'vendor ids', p_vendor_id_tbl);
3284: PO_LOG.proc_begin(d_module, 'vendor site ids', x_vendor_site_id_tbl);
3285: END IF;
3286:
3287: x_fob_tbl := PO_TBL_VARCHAR30();
3288: x_freight_carrier_tbl := PO_TBL_VARCHAR30();

Line 3336: IF (PO_LOG.d_stmt) THEN

3332: RETURNING num1, num2 BULK COLLECT INTO l_index_tbl, l_vendor_site_id_tbl;
3333:
3334: FOR i IN 1..l_index_tbl.COUNT
3335: LOOP
3336: IF (PO_LOG.d_stmt) THEN
3337: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3338: PO_LOG.stmt(d_module, d_position, 'new site id', l_vendor_site_id_tbl(i));
3339: END IF;
3340:

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

3333:
3334: FOR i IN 1..l_index_tbl.COUNT
3335: LOOP
3336: IF (PO_LOG.d_stmt) THEN
3337: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3338: PO_LOG.stmt(d_module, d_position, 'new site id', l_vendor_site_id_tbl(i));
3339: END IF;
3340:
3341: x_vendor_site_id_tbl(l_index_tbl(i)) := l_vendor_site_id_tbl(i);

Line 3338: PO_LOG.stmt(d_module, d_position, 'new site id', l_vendor_site_id_tbl(i));

3334: FOR i IN 1..l_index_tbl.COUNT
3335: LOOP
3336: IF (PO_LOG.d_stmt) THEN
3337: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3338: PO_LOG.stmt(d_module, d_position, 'new site id', l_vendor_site_id_tbl(i));
3339: END IF;
3340:
3341: x_vendor_site_id_tbl(l_index_tbl(i)) := l_vendor_site_id_tbl(i);
3342: END LOOP;

Line 3391: IF (PO_LOG.d_stmt) THEN

3387: FOR i IN 1..l_index_tbl.COUNT
3388: LOOP
3389: l_index := l_index_tbl(i);
3390:
3391: IF (PO_LOG.d_stmt) THEN
3392: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3393: PO_LOG.stmt(d_module, d_position, 'new fob', l_fob_tbl(i));
3394: PO_LOG.stmt(d_module, d_position, 'new freight carrier', l_freight_carrier_tbl(i));
3395: PO_LOG.stmt(d_module, d_position, 'new freight term', l_freight_term_tbl(i));

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

3388: LOOP
3389: l_index := l_index_tbl(i);
3390:
3391: IF (PO_LOG.d_stmt) THEN
3392: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3393: PO_LOG.stmt(d_module, d_position, 'new fob', l_fob_tbl(i));
3394: PO_LOG.stmt(d_module, d_position, 'new freight carrier', l_freight_carrier_tbl(i));
3395: PO_LOG.stmt(d_module, d_position, 'new freight term', l_freight_term_tbl(i));
3396: PO_LOG.stmt(d_module, d_position, 'new ship_to loc id', l_ship_to_loc_id_tbl(i));

Line 3393: PO_LOG.stmt(d_module, d_position, 'new fob', l_fob_tbl(i));

3389: l_index := l_index_tbl(i);
3390:
3391: IF (PO_LOG.d_stmt) THEN
3392: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3393: PO_LOG.stmt(d_module, d_position, 'new fob', l_fob_tbl(i));
3394: PO_LOG.stmt(d_module, d_position, 'new freight carrier', l_freight_carrier_tbl(i));
3395: PO_LOG.stmt(d_module, d_position, 'new freight term', l_freight_term_tbl(i));
3396: PO_LOG.stmt(d_module, d_position, 'new ship_to loc id', l_ship_to_loc_id_tbl(i));
3397: PO_LOG.stmt(d_module, d_position, 'new bill_to loc id', l_bill_to_loc_id_tbl(i));

Line 3394: PO_LOG.stmt(d_module, d_position, 'new freight carrier', l_freight_carrier_tbl(i));

3390:
3391: IF (PO_LOG.d_stmt) THEN
3392: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3393: PO_LOG.stmt(d_module, d_position, 'new fob', l_fob_tbl(i));
3394: PO_LOG.stmt(d_module, d_position, 'new freight carrier', l_freight_carrier_tbl(i));
3395: PO_LOG.stmt(d_module, d_position, 'new freight term', l_freight_term_tbl(i));
3396: PO_LOG.stmt(d_module, d_position, 'new ship_to loc id', l_ship_to_loc_id_tbl(i));
3397: PO_LOG.stmt(d_module, d_position, 'new bill_to loc id', l_bill_to_loc_id_tbl(i));
3398: PO_LOG.stmt(d_module, d_position, 'new currency', l_currency_code_tbl(i));

Line 3395: PO_LOG.stmt(d_module, d_position, 'new freight term', l_freight_term_tbl(i));

3391: IF (PO_LOG.d_stmt) THEN
3392: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3393: PO_LOG.stmt(d_module, d_position, 'new fob', l_fob_tbl(i));
3394: PO_LOG.stmt(d_module, d_position, 'new freight carrier', l_freight_carrier_tbl(i));
3395: PO_LOG.stmt(d_module, d_position, 'new freight term', l_freight_term_tbl(i));
3396: PO_LOG.stmt(d_module, d_position, 'new ship_to loc id', l_ship_to_loc_id_tbl(i));
3397: PO_LOG.stmt(d_module, d_position, 'new bill_to loc id', l_bill_to_loc_id_tbl(i));
3398: PO_LOG.stmt(d_module, d_position, 'new currency', l_currency_code_tbl(i));
3399: PO_LOG.stmt(d_module, d_position, 'new terms id', l_terms_id_tbl(i));

Line 3396: PO_LOG.stmt(d_module, d_position, 'new ship_to loc id', l_ship_to_loc_id_tbl(i));

3392: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3393: PO_LOG.stmt(d_module, d_position, 'new fob', l_fob_tbl(i));
3394: PO_LOG.stmt(d_module, d_position, 'new freight carrier', l_freight_carrier_tbl(i));
3395: PO_LOG.stmt(d_module, d_position, 'new freight term', l_freight_term_tbl(i));
3396: PO_LOG.stmt(d_module, d_position, 'new ship_to loc id', l_ship_to_loc_id_tbl(i));
3397: PO_LOG.stmt(d_module, d_position, 'new bill_to loc id', l_bill_to_loc_id_tbl(i));
3398: PO_LOG.stmt(d_module, d_position, 'new currency', l_currency_code_tbl(i));
3399: PO_LOG.stmt(d_module, d_position, 'new terms id', l_terms_id_tbl(i));
3400: PO_LOG.stmt(d_module, d_position, 'new shipping control', l_shipping_control_tbl(i));

Line 3397: PO_LOG.stmt(d_module, d_position, 'new bill_to loc id', l_bill_to_loc_id_tbl(i));

3393: PO_LOG.stmt(d_module, d_position, 'new fob', l_fob_tbl(i));
3394: PO_LOG.stmt(d_module, d_position, 'new freight carrier', l_freight_carrier_tbl(i));
3395: PO_LOG.stmt(d_module, d_position, 'new freight term', l_freight_term_tbl(i));
3396: PO_LOG.stmt(d_module, d_position, 'new ship_to loc id', l_ship_to_loc_id_tbl(i));
3397: PO_LOG.stmt(d_module, d_position, 'new bill_to loc id', l_bill_to_loc_id_tbl(i));
3398: PO_LOG.stmt(d_module, d_position, 'new currency', l_currency_code_tbl(i));
3399: PO_LOG.stmt(d_module, d_position, 'new terms id', l_terms_id_tbl(i));
3400: PO_LOG.stmt(d_module, d_position, 'new shipping control', l_shipping_control_tbl(i));
3401: PO_LOG.stmt(d_module, d_position, 'new pay on code', l_pay_on_code_tbl(i));

Line 3398: PO_LOG.stmt(d_module, d_position, 'new currency', l_currency_code_tbl(i));

3394: PO_LOG.stmt(d_module, d_position, 'new freight carrier', l_freight_carrier_tbl(i));
3395: PO_LOG.stmt(d_module, d_position, 'new freight term', l_freight_term_tbl(i));
3396: PO_LOG.stmt(d_module, d_position, 'new ship_to loc id', l_ship_to_loc_id_tbl(i));
3397: PO_LOG.stmt(d_module, d_position, 'new bill_to loc id', l_bill_to_loc_id_tbl(i));
3398: PO_LOG.stmt(d_module, d_position, 'new currency', l_currency_code_tbl(i));
3399: PO_LOG.stmt(d_module, d_position, 'new terms id', l_terms_id_tbl(i));
3400: PO_LOG.stmt(d_module, d_position, 'new shipping control', l_shipping_control_tbl(i));
3401: PO_LOG.stmt(d_module, d_position, 'new pay on code', l_pay_on_code_tbl(i));
3402: END IF;

Line 3399: PO_LOG.stmt(d_module, d_position, 'new terms id', l_terms_id_tbl(i));

3395: PO_LOG.stmt(d_module, d_position, 'new freight term', l_freight_term_tbl(i));
3396: PO_LOG.stmt(d_module, d_position, 'new ship_to loc id', l_ship_to_loc_id_tbl(i));
3397: PO_LOG.stmt(d_module, d_position, 'new bill_to loc id', l_bill_to_loc_id_tbl(i));
3398: PO_LOG.stmt(d_module, d_position, 'new currency', l_currency_code_tbl(i));
3399: PO_LOG.stmt(d_module, d_position, 'new terms id', l_terms_id_tbl(i));
3400: PO_LOG.stmt(d_module, d_position, 'new shipping control', l_shipping_control_tbl(i));
3401: PO_LOG.stmt(d_module, d_position, 'new pay on code', l_pay_on_code_tbl(i));
3402: END IF;
3403:

Line 3400: PO_LOG.stmt(d_module, d_position, 'new shipping control', l_shipping_control_tbl(i));

3396: PO_LOG.stmt(d_module, d_position, 'new ship_to loc id', l_ship_to_loc_id_tbl(i));
3397: PO_LOG.stmt(d_module, d_position, 'new bill_to loc id', l_bill_to_loc_id_tbl(i));
3398: PO_LOG.stmt(d_module, d_position, 'new currency', l_currency_code_tbl(i));
3399: PO_LOG.stmt(d_module, d_position, 'new terms id', l_terms_id_tbl(i));
3400: PO_LOG.stmt(d_module, d_position, 'new shipping control', l_shipping_control_tbl(i));
3401: PO_LOG.stmt(d_module, d_position, 'new pay on code', l_pay_on_code_tbl(i));
3402: END IF;
3403:
3404: x_fob_tbl(l_index) := l_fob_tbl(i);

Line 3401: PO_LOG.stmt(d_module, d_position, 'new pay on code', l_pay_on_code_tbl(i));

3397: PO_LOG.stmt(d_module, d_position, 'new bill_to loc id', l_bill_to_loc_id_tbl(i));
3398: PO_LOG.stmt(d_module, d_position, 'new currency', l_currency_code_tbl(i));
3399: PO_LOG.stmt(d_module, d_position, 'new terms id', l_terms_id_tbl(i));
3400: PO_LOG.stmt(d_module, d_position, 'new shipping control', l_shipping_control_tbl(i));
3401: PO_LOG.stmt(d_module, d_position, 'new pay on code', l_pay_on_code_tbl(i));
3402: END IF;
3403:
3404: x_fob_tbl(l_index) := l_fob_tbl(i);
3405: x_freight_carrier_tbl(l_index) := l_freight_carrier_tbl(i);

Line 3415: IF (PO_LOG.d_proc) THEN

3411: x_shipping_control_tbl(l_index) := l_shipping_control_tbl(i);
3412: x_pay_on_code_tbl(l_index) := l_pay_on_code_tbl(i);
3413: END LOOP;
3414:
3415: IF (PO_LOG.d_proc) THEN
3416: PO_LOG.proc_end (d_module);
3417: END IF;
3418:
3419: EXCEPTION

Line 3416: PO_LOG.proc_end (d_module);

3412: x_pay_on_code_tbl(l_index) := l_pay_on_code_tbl(i);
3413: END LOOP;
3414:
3415: IF (PO_LOG.d_proc) THEN
3416: PO_LOG.proc_end (d_module);
3417: END IF;
3418:
3419: EXCEPTION
3420: WHEN OTHERS THEN

Line 3477: IF (PO_LOG.d_proc) THEN

3473:
3474: BEGIN
3475: d_position := 0;
3476:
3477: IF (PO_LOG.d_proc) THEN
3478: PO_LOG.proc_begin(d_module, 'site ids', p_vendor_site_id_tbl);
3479: PO_LOG.proc_begin(d_module, 'contact ids', x_vendor_contact_id_tbl);
3480: END IF;
3481:

Line 3478: PO_LOG.proc_begin(d_module, 'site ids', p_vendor_site_id_tbl);

3474: BEGIN
3475: d_position := 0;
3476:
3477: IF (PO_LOG.d_proc) THEN
3478: PO_LOG.proc_begin(d_module, 'site ids', p_vendor_site_id_tbl);
3479: PO_LOG.proc_begin(d_module, 'contact ids', x_vendor_contact_id_tbl);
3480: END IF;
3481:
3482: -- select contact id from vendor_site table if there is only

Line 3479: PO_LOG.proc_begin(d_module, 'contact ids', x_vendor_contact_id_tbl);

3475: d_position := 0;
3476:
3477: IF (PO_LOG.d_proc) THEN
3478: PO_LOG.proc_begin(d_module, 'site ids', p_vendor_site_id_tbl);
3479: PO_LOG.proc_begin(d_module, 'contact ids', x_vendor_contact_id_tbl);
3480: END IF;
3481:
3482: -- select contact id from vendor_site table if there is only
3483: -- one contact defined on that site

Line 3508: IF (PO_LOG.d_stmt) THEN

3504: d_position := 20;
3505:
3506: FOR i IN 1..l_index_tbl.COUNT
3507: LOOP
3508: IF (PO_LOG.d_stmt) THEN
3509: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3510: PO_LOG.stmt(d_module, d_position, 'new contact id', l_result_tbl(i));
3511: END IF;
3512:

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

3505:
3506: FOR i IN 1..l_index_tbl.COUNT
3507: LOOP
3508: IF (PO_LOG.d_stmt) THEN
3509: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3510: PO_LOG.stmt(d_module, d_position, 'new contact id', l_result_tbl(i));
3511: END IF;
3512:
3513: x_vendor_contact_id_tbl(l_index_tbl(i)) := l_result_tbl(i);

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

3506: FOR i IN 1..l_index_tbl.COUNT
3507: LOOP
3508: IF (PO_LOG.d_stmt) THEN
3509: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3510: PO_LOG.stmt(d_module, d_position, 'new contact id', l_result_tbl(i));
3511: END IF;
3512:
3513: x_vendor_contact_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
3514: END LOOP;

Line 3516: IF (PO_LOG.d_proc) THEN

3512:
3513: x_vendor_contact_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
3514: END LOOP;
3515:
3516: IF (PO_LOG.d_proc) THEN
3517: PO_LOG.proc_end (d_module);
3518: END IF;
3519:
3520: EXCEPTION

Line 3517: PO_LOG.proc_end (d_module);

3513: x_vendor_contact_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
3514: END LOOP;
3515:
3516: IF (PO_LOG.d_proc) THEN
3517: PO_LOG.proc_end (d_module);
3518: END IF;
3519:
3520: EXCEPTION
3521: WHEN OTHERS THEN

Line 3565: IF (PO_LOG.d_proc) THEN

3561:
3562: BEGIN
3563: d_position := 0;
3564:
3565: IF (PO_LOG.d_proc) THEN
3566: PO_LOG.proc_begin(d_module);
3567: END IF;
3568:
3569:

Line 3566: PO_LOG.proc_begin(d_module);

3562: BEGIN
3563: d_position := 0;
3564:
3565: IF (PO_LOG.d_proc) THEN
3566: PO_LOG.proc_begin(d_module);
3567: END IF;
3568:
3569:
3570: FOR i IN 1..x_headers.rec_count

Line 3575: IF (PO_LOG.d_stmt) THEN

3571: LOOP
3572: d_position := 10;
3573:
3574: IF (x_headers.encumbrance_required_flag_tbl(i) = 'Y') THEN
3575: IF (PO_LOG.d_stmt) THEN
3576: PO_LOG.stmt(d_module, d_position, 'distribution row created for encumbrance');
3577: PO_LOG.stmt(d_module, d_position, 'index', i);
3578: END IF;
3579:

Line 3576: PO_LOG.stmt(d_module, d_position, 'distribution row created for encumbrance');

3572: d_position := 10;
3573:
3574: IF (x_headers.encumbrance_required_flag_tbl(i) = 'Y') THEN
3575: IF (PO_LOG.d_stmt) THEN
3576: PO_LOG.stmt(d_module, d_position, 'distribution row created for encumbrance');
3577: PO_LOG.stmt(d_module, d_position, 'index', i);
3578: END IF;
3579:
3580: -- default po_distribution_id

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

3573:
3574: IF (x_headers.encumbrance_required_flag_tbl(i) = 'Y') THEN
3575: IF (PO_LOG.d_stmt) THEN
3576: PO_LOG.stmt(d_module, d_position, 'distribution row created for encumbrance');
3577: PO_LOG.stmt(d_module, d_position, 'index', i);
3578: END IF;
3579:
3580: -- default po_distribution_id
3581: x_headers.po_dist_id_tbl(i) := PO_PDOI_MAINPROC_UTL_PVT.get_next_dist_id;

Line 3583: IF (PO_LOG.d_stmt) THEN

3579:
3580: -- default po_distribution_id
3581: x_headers.po_dist_id_tbl(i) := PO_PDOI_MAINPROC_UTL_PVT.get_next_dist_id;
3582:
3583: IF (PO_LOG.d_stmt) THEN
3584: PO_LOG.stmt(d_module, d_position, 'new dist id', x_headers.po_dist_id_tbl(i));
3585: END IF;
3586:
3587: -- default gl_encumbered_date and gl_encumbered_period

Line 3584: PO_LOG.stmt(d_module, d_position, 'new dist id', x_headers.po_dist_id_tbl(i));

3580: -- default po_distribution_id
3581: x_headers.po_dist_id_tbl(i) := PO_PDOI_MAINPROC_UTL_PVT.get_next_dist_id;
3582:
3583: IF (PO_LOG.d_stmt) THEN
3584: PO_LOG.stmt(d_module, d_position, 'new dist id', x_headers.po_dist_id_tbl(i));
3585: END IF;
3586:
3587: -- default gl_encumbered_date and gl_encumbered_period
3588: IF (x_headers.gl_encumbered_date_tbl(i) IS NULL) THEN

Line 3641: IF (PO_LOG.d_stmt) THEN

3637: p_account_segment30 => x_headers.budget_account_segment30_tbl(i),
3638: x_account_id => x_headers.budget_account_id_tbl(i)
3639: );
3640:
3641: IF (PO_LOG.d_stmt) THEN
3642: PO_LOG.stmt(d_module, d_position, 'default budget account id',
3643: x_headers.budget_account_id_tbl(i));
3644: END IF;
3645: END IF;

Line 3642: PO_LOG.stmt(d_module, d_position, 'default budget account id',

3638: x_account_id => x_headers.budget_account_id_tbl(i)
3639: );
3640:
3641: IF (PO_LOG.d_stmt) THEN
3642: PO_LOG.stmt(d_module, d_position, 'default budget account id',
3643: x_headers.budget_account_id_tbl(i));
3644: END IF;
3645: END IF;
3646: END IF;

Line 3649: IF (PO_LOG.d_proc) THEN

3645: END IF;
3646: END IF;
3647: END LOOP;
3648:
3649: IF (PO_LOG.d_proc) THEN
3650: PO_LOG.proc_end (d_module);
3651: END IF;
3652:
3653: EXCEPTION

Line 3650: PO_LOG.proc_end (d_module);

3646: END IF;
3647: END LOOP;
3648:
3649: IF (PO_LOG.d_proc) THEN
3650: PO_LOG.proc_end (d_module);
3651: END IF;
3652:
3653: EXCEPTION
3654: WHEN OTHERS THEN

Line 3696: IF (PO_LOG.d_proc) THEN

3692:
3693: BEGIN
3694: d_position := 0;
3695:
3696: IF (PO_LOG.d_proc) THEN
3697: PO_LOG.proc_begin(d_module);
3698: END IF;
3699:
3700: FOR i IN 1 .. x_headers.rec_count LOOP

Line 3697: PO_LOG.proc_begin(d_module);

3693: BEGIN
3694: d_position := 0;
3695:
3696: IF (PO_LOG.d_proc) THEN
3697: PO_LOG.proc_begin(d_module);
3698: END IF;
3699:
3700: FOR i IN 1 .. x_headers.rec_count LOOP
3701: l_index_tbl(x_headers.intf_header_id_tbl(i)) := i;

Line 3712: IF (PO_LOG.d_proc) THEN

3708: x_headers.error_flag_tbl(l_index_tbl(x_results.entity_id(i))) := FND_API.g_TRUE;
3709: END IF;
3710: END LOOP;
3711:
3712: IF (PO_LOG.d_proc) THEN
3713: PO_LOG.proc_end (d_module);
3714: END IF;
3715:
3716: EXCEPTION

Line 3713: PO_LOG.proc_end (d_module);

3709: END IF;
3710: END LOOP;
3711:
3712: IF (PO_LOG.d_proc) THEN
3713: PO_LOG.proc_end (d_module);
3714: END IF;
3715:
3716: EXCEPTION
3717: WHEN OTHERS THEN

Line 3751: IF (PO_LOG.d_proc) THEN

3747:
3748: BEGIN
3749: d_position := 0;
3750:
3751: IF (PO_LOG.d_proc) THEN
3752: PO_LOG.proc_begin(d_module, 'style_id_tbl', p_style_id_tbl);
3753: PO_LOG.proc_begin(d_module, 'clm_standard_form_tbl', x_clm_standard_form_tbl);
3754: PO_LOG.proc_begin(d_module, 'clm_document_format_tbl', x_clm_document_format_tbl);
3755: END IF;

Line 3752: PO_LOG.proc_begin(d_module, 'style_id_tbl', p_style_id_tbl);

3748: BEGIN
3749: d_position := 0;
3750:
3751: IF (PO_LOG.d_proc) THEN
3752: PO_LOG.proc_begin(d_module, 'style_id_tbl', p_style_id_tbl);
3753: PO_LOG.proc_begin(d_module, 'clm_standard_form_tbl', x_clm_standard_form_tbl);
3754: PO_LOG.proc_begin(d_module, 'clm_document_format_tbl', x_clm_document_format_tbl);
3755: END IF;
3756:

Line 3753: PO_LOG.proc_begin(d_module, 'clm_standard_form_tbl', x_clm_standard_form_tbl);

3749: d_position := 0;
3750:
3751: IF (PO_LOG.d_proc) THEN
3752: PO_LOG.proc_begin(d_module, 'style_id_tbl', p_style_id_tbl);
3753: PO_LOG.proc_begin(d_module, 'clm_standard_form_tbl', x_clm_standard_form_tbl);
3754: PO_LOG.proc_begin(d_module, 'clm_document_format_tbl', x_clm_document_format_tbl);
3755: END IF;
3756:
3757: FORALL i IN 1..p_index_tbl.COUNT

Line 3754: PO_LOG.proc_begin(d_module, 'clm_document_format_tbl', x_clm_document_format_tbl);

3750:
3751: IF (PO_LOG.d_proc) THEN
3752: PO_LOG.proc_begin(d_module, 'style_id_tbl', p_style_id_tbl);
3753: PO_LOG.proc_begin(d_module, 'clm_standard_form_tbl', x_clm_standard_form_tbl);
3754: PO_LOG.proc_begin(d_module, 'clm_document_format_tbl', x_clm_document_format_tbl);
3755: END IF;
3756:
3757: FORALL i IN 1..p_index_tbl.COUNT
3758: INSERT INTO po_session_gt(key, num1, char1, char2, char3, num2)

Line 3846: IF (PO_LOG.d_stmt) THEN

3842: d_position := 20;
3843:
3844: FOR i IN 1..l_index_tbl.COUNT
3845: LOOP
3846: IF (PO_LOG.d_stmt) THEN
3847: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3848: PO_LOG.stmt(d_module, d_position, 'new standard form', l_standard_form_tbl(i));
3849: PO_LOG.stmt(d_module, d_position, 'new document format', l_document_format_tbl(i));
3850: END IF;

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

3843:
3844: FOR i IN 1..l_index_tbl.COUNT
3845: LOOP
3846: IF (PO_LOG.d_stmt) THEN
3847: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3848: PO_LOG.stmt(d_module, d_position, 'new standard form', l_standard_form_tbl(i));
3849: PO_LOG.stmt(d_module, d_position, 'new document format', l_document_format_tbl(i));
3850: END IF;
3851:

Line 3848: PO_LOG.stmt(d_module, d_position, 'new standard form', l_standard_form_tbl(i));

3844: FOR i IN 1..l_index_tbl.COUNT
3845: LOOP
3846: IF (PO_LOG.d_stmt) THEN
3847: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3848: PO_LOG.stmt(d_module, d_position, 'new standard form', l_standard_form_tbl(i));
3849: PO_LOG.stmt(d_module, d_position, 'new document format', l_document_format_tbl(i));
3850: END IF;
3851:
3852: x_clm_standard_form_tbl(l_index_tbl(i)) := l_standard_form_tbl(i);

Line 3849: PO_LOG.stmt(d_module, d_position, 'new document format', l_document_format_tbl(i));

3845: LOOP
3846: IF (PO_LOG.d_stmt) THEN
3847: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3848: PO_LOG.stmt(d_module, d_position, 'new standard form', l_standard_form_tbl(i));
3849: PO_LOG.stmt(d_module, d_position, 'new document format', l_document_format_tbl(i));
3850: END IF;
3851:
3852: x_clm_standard_form_tbl(l_index_tbl(i)) := l_standard_form_tbl(i);
3853: x_clm_document_format_tbl(l_index_tbl(i)) := l_document_format_tbl(i);

Line 3856: IF (PO_LOG.d_proc) THEN

3852: x_clm_standard_form_tbl(l_index_tbl(i)) := l_standard_form_tbl(i);
3853: x_clm_document_format_tbl(l_index_tbl(i)) := l_document_format_tbl(i);
3854: END LOOP;
3855:
3856: IF (PO_LOG.d_proc) THEN
3857: PO_LOG.proc_end (d_module);
3858: END IF;
3859:
3860: EXCEPTION

Line 3857: PO_LOG.proc_end (d_module);

3853: x_clm_document_format_tbl(l_index_tbl(i)) := l_document_format_tbl(i);
3854: END LOOP;
3855:
3856: IF (PO_LOG.d_proc) THEN
3857: PO_LOG.proc_end (d_module);
3858: END IF;
3859:
3860: EXCEPTION
3861: WHEN OTHERS THEN

Line 3891: IF (PO_LOG.d_proc) THEN

3887: l_result_tbl PO_TBL_VARCHAR30;
3888: BEGIN
3889: d_position := 0;
3890:
3891: IF (PO_LOG.d_proc) THEN
3892: PO_LOG.proc_begin(d_module, 'x_clm_award_type_tbl', x_clm_award_type_tbl);
3893: --PO_LOG.proc_begin(d_module, 'p_clm_award_type_disp_tbl', p_clm_award_type_disp_tbl);
3894: END IF;
3895:

Line 3892: PO_LOG.proc_begin(d_module, 'x_clm_award_type_tbl', x_clm_award_type_tbl);

3888: BEGIN
3889: d_position := 0;
3890:
3891: IF (PO_LOG.d_proc) THEN
3892: PO_LOG.proc_begin(d_module, 'x_clm_award_type_tbl', x_clm_award_type_tbl);
3893: --PO_LOG.proc_begin(d_module, 'p_clm_award_type_disp_tbl', p_clm_award_type_disp_tbl);
3894: END IF;
3895:
3896: FORALL i IN 1..p_index_tbl.COUNT

Line 3893: --PO_LOG.proc_begin(d_module, 'p_clm_award_type_disp_tbl', p_clm_award_type_disp_tbl);

3889: d_position := 0;
3890:
3891: IF (PO_LOG.d_proc) THEN
3892: PO_LOG.proc_begin(d_module, 'x_clm_award_type_tbl', x_clm_award_type_tbl);
3893: --PO_LOG.proc_begin(d_module, 'p_clm_award_type_disp_tbl', p_clm_award_type_disp_tbl);
3894: END IF;
3895:
3896: FORALL i IN 1..p_index_tbl.COUNT
3897: INSERT INTO po_session_gt(key, num1, char1)

Line 3918: IF (PO_LOG.d_stmt) THEN

3914: d_position := 20;
3915:
3916: FOR i IN 1..l_index_tbl.COUNT
3917: LOOP
3918: IF (PO_LOG.d_stmt) THEN
3919: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3920: PO_LOG.stmt(d_module, d_position, 'new award type', l_result_tbl(i));
3921: END IF;
3922:

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

3915:
3916: FOR i IN 1..l_index_tbl.COUNT
3917: LOOP
3918: IF (PO_LOG.d_stmt) THEN
3919: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3920: PO_LOG.stmt(d_module, d_position, 'new award type', l_result_tbl(i));
3921: END IF;
3922:
3923: x_clm_award_type_tbl(l_index_tbl(i)) := l_result_tbl(i);

Line 3920: PO_LOG.stmt(d_module, d_position, 'new award type', l_result_tbl(i));

3916: FOR i IN 1..l_index_tbl.COUNT
3917: LOOP
3918: IF (PO_LOG.d_stmt) THEN
3919: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3920: PO_LOG.stmt(d_module, d_position, 'new award type', l_result_tbl(i));
3921: END IF;
3922:
3923: x_clm_award_type_tbl(l_index_tbl(i)) := l_result_tbl(i);
3924: END LOOP;

Line 3926: IF (PO_LOG.d_proc) THEN

3922:
3923: x_clm_award_type_tbl(l_index_tbl(i)) := l_result_tbl(i);
3924: END LOOP;
3925:
3926: IF (PO_LOG.d_proc) THEN
3927: PO_LOG.proc_end (d_module);
3928: END IF;
3929:
3930: EXCEPTION

Line 3927: PO_LOG.proc_end (d_module);

3923: x_clm_award_type_tbl(l_index_tbl(i)) := l_result_tbl(i);
3924: END LOOP;
3925:
3926: IF (PO_LOG.d_proc) THEN
3927: PO_LOG.proc_end (d_module);
3928: END IF;
3929:
3930: EXCEPTION
3931: WHEN OTHERS THEN

Line 3962: IF (PO_LOG.d_proc) THEN

3958: l_result_tbl PO_TBL_VARCHAR30;
3959: BEGIN
3960: d_position := 0;
3961:
3962: IF (PO_LOG.d_proc) THEN
3963: PO_LOG.proc_begin(d_module);
3964: --PO_LOG.proc_begin(d_module, 'p_clm_award_type_disp_tbl', p_clm_award_type_disp_tbl);
3965: END IF;
3966:

Line 3963: PO_LOG.proc_begin(d_module);

3959: BEGIN
3960: d_position := 0;
3961:
3962: IF (PO_LOG.d_proc) THEN
3963: PO_LOG.proc_begin(d_module);
3964: --PO_LOG.proc_begin(d_module, 'p_clm_award_type_disp_tbl', p_clm_award_type_disp_tbl);
3965: END IF;
3966:
3967: FORALL i IN 1..p_index_tbl.COUNT

Line 3964: --PO_LOG.proc_begin(d_module, 'p_clm_award_type_disp_tbl', p_clm_award_type_disp_tbl);

3960: d_position := 0;
3961:
3962: IF (PO_LOG.d_proc) THEN
3963: PO_LOG.proc_begin(d_module);
3964: --PO_LOG.proc_begin(d_module, 'p_clm_award_type_disp_tbl', p_clm_award_type_disp_tbl);
3965: END IF;
3966:
3967: FORALL i IN 1..p_index_tbl.COUNT
3968: INSERT INTO po_session_gt(key, num1, char1)

Line 3988: IF (PO_LOG.d_stmt) THEN

3984: d_position := 20;
3985:
3986: FOR i IN 1..l_index_tbl.COUNT
3987: LOOP
3988: IF (PO_LOG.d_stmt) THEN
3989: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3990: PO_LOG.stmt(d_module, d_position, 'new award admin', l_result_tbl(i));
3991: END IF;
3992:

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

3985:
3986: FOR i IN 1..l_index_tbl.COUNT
3987: LOOP
3988: IF (PO_LOG.d_stmt) THEN
3989: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3990: PO_LOG.stmt(d_module, d_position, 'new award admin', l_result_tbl(i));
3991: END IF;
3992:
3993: x_clm_award_administrator_tbl(l_index_tbl(i)) := l_result_tbl(i);

Line 3990: PO_LOG.stmt(d_module, d_position, 'new award admin', l_result_tbl(i));

3986: FOR i IN 1..l_index_tbl.COUNT
3987: LOOP
3988: IF (PO_LOG.d_stmt) THEN
3989: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3990: PO_LOG.stmt(d_module, d_position, 'new award admin', l_result_tbl(i));
3991: END IF;
3992:
3993: x_clm_award_administrator_tbl(l_index_tbl(i)) := l_result_tbl(i);
3994: END LOOP;

Line 3996: IF (PO_LOG.d_proc) THEN

3992:
3993: x_clm_award_administrator_tbl(l_index_tbl(i)) := l_result_tbl(i);
3994: END LOOP;
3995:
3996: IF (PO_LOG.d_proc) THEN
3997: PO_LOG.proc_end (d_module);
3998: END IF;
3999:
4000: EXCEPTION

Line 3997: PO_LOG.proc_end (d_module);

3993: x_clm_award_administrator_tbl(l_index_tbl(i)) := l_result_tbl(i);
3994: END LOOP;
3995:
3996: IF (PO_LOG.d_proc) THEN
3997: PO_LOG.proc_end (d_module);
3998: END IF;
3999:
4000: EXCEPTION
4001: WHEN OTHERS THEN

Line 4031: IF (PO_LOG.d_proc) THEN

4027: l_result_tbl PO_TBL_NUMBER;
4028: BEGIN
4029: d_position := 0;
4030:
4031: IF (PO_LOG.d_proc) THEN
4032: PO_LOG.proc_begin(d_module);
4033: --PO_LOG.proc_begin(d_module, 'p_clm_award_type_disp_tbl', p_clm_award_type_disp_tbl);
4034: END IF;
4035:

Line 4032: PO_LOG.proc_begin(d_module);

4028: BEGIN
4029: d_position := 0;
4030:
4031: IF (PO_LOG.d_proc) THEN
4032: PO_LOG.proc_begin(d_module);
4033: --PO_LOG.proc_begin(d_module, 'p_clm_award_type_disp_tbl', p_clm_award_type_disp_tbl);
4034: END IF;
4035:
4036: FORALL i IN 1..p_index_tbl.COUNT

Line 4033: --PO_LOG.proc_begin(d_module, 'p_clm_award_type_disp_tbl', p_clm_award_type_disp_tbl);

4029: d_position := 0;
4030:
4031: IF (PO_LOG.d_proc) THEN
4032: PO_LOG.proc_begin(d_module);
4033: --PO_LOG.proc_begin(d_module, 'p_clm_award_type_disp_tbl', p_clm_award_type_disp_tbl);
4034: END IF;
4035:
4036: FORALL i IN 1..p_index_tbl.COUNT
4037: INSERT INTO po_session_gt(key, num1, num2)

Line 4058: IF (PO_LOG.d_stmt) THEN

4054: d_position := 20;
4055:
4056: FOR i IN 1..l_index_tbl.COUNT
4057: LOOP
4058: IF (PO_LOG.d_stmt) THEN
4059: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
4060: PO_LOG.stmt(d_module, d_position, 'new contract officer', l_result_tbl(i));
4061: END IF;
4062:

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

4055:
4056: FOR i IN 1..l_index_tbl.COUNT
4057: LOOP
4058: IF (PO_LOG.d_stmt) THEN
4059: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
4060: PO_LOG.stmt(d_module, d_position, 'new contract officer', l_result_tbl(i));
4061: END IF;
4062:
4063: x_clm_contract_officer_tbl(l_index_tbl(i)) := l_result_tbl(i);

Line 4060: PO_LOG.stmt(d_module, d_position, 'new contract officer', l_result_tbl(i));

4056: FOR i IN 1..l_index_tbl.COUNT
4057: LOOP
4058: IF (PO_LOG.d_stmt) THEN
4059: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
4060: PO_LOG.stmt(d_module, d_position, 'new contract officer', l_result_tbl(i));
4061: END IF;
4062:
4063: x_clm_contract_officer_tbl(l_index_tbl(i)) := l_result_tbl(i);
4064: END LOOP;

Line 4066: IF (PO_LOG.d_proc) THEN

4062:
4063: x_clm_contract_officer_tbl(l_index_tbl(i)) := l_result_tbl(i);
4064: END LOOP;
4065:
4066: IF (PO_LOG.d_proc) THEN
4067: PO_LOG.proc_end (d_module);
4068: END IF;
4069:
4070: EXCEPTION

Line 4067: PO_LOG.proc_end (d_module);

4063: x_clm_contract_officer_tbl(l_index_tbl(i)) := l_result_tbl(i);
4064: END LOOP;
4065:
4066: IF (PO_LOG.d_proc) THEN
4067: PO_LOG.proc_end (d_module);
4068: END IF;
4069:
4070: EXCEPTION
4071: WHEN OTHERS THEN

Line 4101: IF (PO_LOG.d_proc) THEN

4097: l_result_tbl PO_TBL_NUMBER;
4098: BEGIN
4099: d_position := 0;
4100:
4101: IF (PO_LOG.d_proc) THEN
4102: PO_LOG.proc_begin(d_module);
4103: --PO_LOG.proc_begin(d_module, 'p_clm_award_type_disp_tbl', p_clm_award_type_disp_tbl);
4104: END IF;
4105:

Line 4102: PO_LOG.proc_begin(d_module);

4098: BEGIN
4099: d_position := 0;
4100:
4101: IF (PO_LOG.d_proc) THEN
4102: PO_LOG.proc_begin(d_module);
4103: --PO_LOG.proc_begin(d_module, 'p_clm_award_type_disp_tbl', p_clm_award_type_disp_tbl);
4104: END IF;
4105:
4106: FORALL i IN 1..p_index_tbl.COUNT

Line 4103: --PO_LOG.proc_begin(d_module, 'p_clm_award_type_disp_tbl', p_clm_award_type_disp_tbl);

4099: d_position := 0;
4100:
4101: IF (PO_LOG.d_proc) THEN
4102: PO_LOG.proc_begin(d_module);
4103: --PO_LOG.proc_begin(d_module, 'p_clm_award_type_disp_tbl', p_clm_award_type_disp_tbl);
4104: END IF;
4105:
4106: FORALL i IN 1..p_index_tbl.COUNT
4107: INSERT INTO po_session_gt(key, num1, num2)

Line 4126: IF (PO_LOG.d_stmt) THEN

4122: d_position := 20;
4123:
4124: FOR i IN 1..l_index_tbl.COUNT
4125: LOOP
4126: IF (PO_LOG.d_stmt) THEN
4127: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
4128: PO_LOG.stmt(d_module, d_position, 'new source idv', l_result_tbl(i));
4129: END IF;
4130:

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

4123:
4124: FOR i IN 1..l_index_tbl.COUNT
4125: LOOP
4126: IF (PO_LOG.d_stmt) THEN
4127: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
4128: PO_LOG.stmt(d_module, d_position, 'new source idv', l_result_tbl(i));
4129: END IF;
4130:
4131: x_clm_source_document_id_tbl(l_index_tbl(i)) := l_result_tbl(i);

Line 4128: PO_LOG.stmt(d_module, d_position, 'new source idv', l_result_tbl(i));

4124: FOR i IN 1..l_index_tbl.COUNT
4125: LOOP
4126: IF (PO_LOG.d_stmt) THEN
4127: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
4128: PO_LOG.stmt(d_module, d_position, 'new source idv', l_result_tbl(i));
4129: END IF;
4130:
4131: x_clm_source_document_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
4132: END LOOP;

Line 4134: IF (PO_LOG.d_proc) THEN

4130:
4131: x_clm_source_document_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
4132: END LOOP;
4133:
4134: IF (PO_LOG.d_proc) THEN
4135: PO_LOG.proc_end (d_module);
4136: END IF;
4137:
4138: EXCEPTION

Line 4135: PO_LOG.proc_end (d_module);

4131: x_clm_source_document_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
4132: END LOOP;
4133:
4134: IF (PO_LOG.d_proc) THEN
4135: PO_LOG.proc_end (d_module);
4136: END IF;
4137:
4138: EXCEPTION
4139: WHEN OTHERS THEN

Line 4169: IF (PO_LOG.d_proc) THEN

4165: l_result_tbl PO_TBL_NUMBER;
4166: BEGIN
4167: d_position := 0;
4168:
4169: IF (PO_LOG.d_proc) THEN
4170: PO_LOG.proc_begin(d_module);
4171: PO_LOG.proc_begin(d_module, 'vendor_id_tbl', x_vendor_id_tbl);
4172: END IF;
4173:

Line 4170: PO_LOG.proc_begin(d_module);

4166: BEGIN
4167: d_position := 0;
4168:
4169: IF (PO_LOG.d_proc) THEN
4170: PO_LOG.proc_begin(d_module);
4171: PO_LOG.proc_begin(d_module, 'vendor_id_tbl', x_vendor_id_tbl);
4172: END IF;
4173:
4174: FORALL i IN 1..p_index_tbl.Count

Line 4171: PO_LOG.proc_begin(d_module, 'vendor_id_tbl', x_vendor_id_tbl);

4167: d_position := 0;
4168:
4169: IF (PO_LOG.d_proc) THEN
4170: PO_LOG.proc_begin(d_module);
4171: PO_LOG.proc_begin(d_module, 'vendor_id_tbl', x_vendor_id_tbl);
4172: END IF;
4173:
4174: FORALL i IN 1..p_index_tbl.Count
4175: INSERT INTO po_session_gt(key, num1, num2)

Line 4195: IF (PO_LOG.d_stmt) THEN

4191: d_position := 20;
4192:
4193: FOR i IN 1..l_index_tbl.COUNT
4194: LOOP
4195: IF (PO_LOG.d_stmt) THEN
4196: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
4197: PO_LOG.stmt(d_module, d_position, 'new vendor id', l_result_tbl(i));
4198: END IF;
4199: x_vendor_id_tbl(l_index_tbl(i)) := l_result_tbl(i);

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

4192:
4193: FOR i IN 1..l_index_tbl.COUNT
4194: LOOP
4195: IF (PO_LOG.d_stmt) THEN
4196: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
4197: PO_LOG.stmt(d_module, d_position, 'new vendor id', l_result_tbl(i));
4198: END IF;
4199: x_vendor_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
4200: END LOOP;

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

4193: FOR i IN 1..l_index_tbl.COUNT
4194: LOOP
4195: IF (PO_LOG.d_stmt) THEN
4196: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
4197: PO_LOG.stmt(d_module, d_position, 'new vendor id', l_result_tbl(i));
4198: END IF;
4199: x_vendor_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
4200: END LOOP;
4201:

Line 4202: IF (PO_LOG.d_proc) THEN

4198: END IF;
4199: x_vendor_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
4200: END LOOP;
4201:
4202: IF (PO_LOG.d_proc) THEN
4203: PO_LOG.proc_end (d_module);
4204: END IF;
4205:
4206: EXCEPTION

Line 4203: PO_LOG.proc_end (d_module);

4199: x_vendor_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
4200: END LOOP;
4201:
4202: IF (PO_LOG.d_proc) THEN
4203: PO_LOG.proc_end (d_module);
4204: END IF;
4205:
4206: EXCEPTION
4207: WHEN OTHERS THEN

Line 4237: IF (PO_LOG.d_proc) THEN

4233: l_result_tbl PO_TBL_NUMBER;
4234: BEGIN
4235: d_position := 0;
4236:
4237: IF (PO_LOG.d_proc) THEN
4238: PO_LOG.proc_begin(d_module);
4239: --PO_LOG.proc_begin(d_module, 'p_clm_award_type_disp_tbl', p_clm_award_type_disp_tbl);
4240: END IF;
4241:

Line 4238: PO_LOG.proc_begin(d_module);

4234: BEGIN
4235: d_position := 0;
4236:
4237: IF (PO_LOG.d_proc) THEN
4238: PO_LOG.proc_begin(d_module);
4239: --PO_LOG.proc_begin(d_module, 'p_clm_award_type_disp_tbl', p_clm_award_type_disp_tbl);
4240: END IF;
4241:
4242: FORALL i IN 1..p_index_tbl.Count

Line 4239: --PO_LOG.proc_begin(d_module, 'p_clm_award_type_disp_tbl', p_clm_award_type_disp_tbl);

4235: d_position := 0;
4236:
4237: IF (PO_LOG.d_proc) THEN
4238: PO_LOG.proc_begin(d_module);
4239: --PO_LOG.proc_begin(d_module, 'p_clm_award_type_disp_tbl', p_clm_award_type_disp_tbl);
4240: END IF;
4241:
4242: FORALL i IN 1..p_index_tbl.Count
4243: INSERT INTO po_session_gt(key, num1, num2)

Line 4263: IF (PO_LOG.d_stmt) THEN

4259: d_position := 20;
4260:
4261: FOR i IN 1..l_index_tbl.COUNT
4262: LOOP
4263: IF (PO_LOG.d_stmt) THEN
4264: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
4265: PO_LOG.stmt(d_module, d_position, 'new vendor id', l_result_tbl(i));
4266: END IF;
4267: x_vendor_site_id_tbl(l_index_tbl(i)) := l_result_tbl(i);

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

4260:
4261: FOR i IN 1..l_index_tbl.COUNT
4262: LOOP
4263: IF (PO_LOG.d_stmt) THEN
4264: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
4265: PO_LOG.stmt(d_module, d_position, 'new vendor id', l_result_tbl(i));
4266: END IF;
4267: x_vendor_site_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
4268: END LOOP;

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

4261: FOR i IN 1..l_index_tbl.COUNT
4262: LOOP
4263: IF (PO_LOG.d_stmt) THEN
4264: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
4265: PO_LOG.stmt(d_module, d_position, 'new vendor id', l_result_tbl(i));
4266: END IF;
4267: x_vendor_site_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
4268: END LOOP;
4269:

Line 4270: IF (PO_LOG.d_proc) THEN

4266: END IF;
4267: x_vendor_site_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
4268: END LOOP;
4269:
4270: IF (PO_LOG.d_proc) THEN
4271: PO_LOG.proc_end (d_module);
4272: END IF;
4273:
4274: EXCEPTION

Line 4271: PO_LOG.proc_end (d_module);

4267: x_vendor_site_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
4268: END LOOP;
4269:
4270: IF (PO_LOG.d_proc) THEN
4271: PO_LOG.proc_end (d_module);
4272: END IF;
4273:
4274: EXCEPTION
4275: WHEN OTHERS THEN