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

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

1: PACKAGE BODY po_pdoi_dist_process_pvt AS
2: /* $Header: PO_PDOI_DIST_PROCESS_PVT.plb 120.30.12020000.5 2013/05/30 11:55:32 gjyothi ship $ */
3:
4: d_pkg_name CONSTANT VARCHAR2(50) :=
5: PO_LOG.get_package_base('PO_PDOI_DIST_PROCESS_PVT');
6:
7: g_sys_accrual_account_id NUMBER;
8: g_mtl_accrual_account_id_tbl DBMS_SQL.NUMBER_TABLE;
9: g_mtl_variance_account_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 226: IF (PO_LOG.d_proc) THEN

222:
223: BEGIN
224: d_position := 0;
225:
226: IF (PO_LOG.d_proc) THEN
227: PO_LOG.proc_begin(d_module, 'p_max_intf_dist_id', p_max_intf_dist_id);
228: END IF;
229:
230: OPEN x_dists_csr FOR

Line 227: PO_LOG.proc_begin(d_module, 'p_max_intf_dist_id', p_max_intf_dist_id);

223: BEGIN
224: d_position := 0;
225:
226: IF (PO_LOG.d_proc) THEN
227: PO_LOG.proc_begin(d_module, 'p_max_intf_dist_id', p_max_intf_dist_id);
228: END IF;
229:
230: OPEN x_dists_csr FOR
231: SELECT /*+ INDEX (intf_dists PO_DISTRIBUTIONS_INTERFACE_N1) */

Line 464: IF (PO_LOG.d_proc) THEN

460: AND intf_dists.interface_distribution_id > p_max_intf_dist_id
461:
462: ORDER BY intf_dists.interface_distribution_id;
463:
464: IF (PO_LOG.d_proc) THEN
465: PO_LOG.proc_end (d_module);
466: END IF;
467:
468: EXCEPTION

Line 465: PO_LOG.proc_end (d_module);

461:
462: ORDER BY intf_dists.interface_distribution_id;
463:
464: IF (PO_LOG.d_proc) THEN
465: PO_LOG.proc_end (d_module);
466: END IF;
467:
468: EXCEPTION
469: WHEN OTHERS THEN

Line 506: IF (PO_LOG.d_proc) THEN

502:
503: BEGIN
504: d_position := 0;
505:
506: IF (PO_LOG.d_proc) THEN
507: PO_LOG.proc_begin(d_module);
508: END IF;
509:
510: FETCH x_dists_csr BULK COLLECT INTO

Line 507: PO_LOG.proc_begin(d_module);

503: BEGIN
504: d_position := 0;
505:
506: IF (PO_LOG.d_proc) THEN
507: PO_LOG.proc_begin(d_module);
508: END IF;
509:
510: FETCH x_dists_csr BULK COLLECT INTO
511: x_dists.intf_dist_id_tbl,

Line 722: IF (PO_LOG.d_proc) THEN

718: x_dists.clm_misc_loa_tbl
719:
720: LIMIT PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE;
721:
722: IF (PO_LOG.d_proc) THEN
723: PO_LOG.proc_end (d_module);
724: END IF;
725:
726: EXCEPTION

Line 723: PO_LOG.proc_end (d_module);

719:
720: LIMIT PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE;
721:
722: IF (PO_LOG.d_proc) THEN
723: PO_LOG.proc_end (d_module);
724: END IF;
725:
726: EXCEPTION
727: WHEN OTHERS THEN

Line 788: IF (PO_LOG.d_proc) THEN

784: l_return_status VARCHAR2(1);
785: BEGIN
786: d_position := 0;
787:
788: IF (PO_LOG.d_proc) THEN
789: PO_LOG.proc_begin(d_module);
790: END IF;
791:
792: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_DIST_DERIVE);

Line 789: PO_LOG.proc_begin(d_module);

785: BEGIN
786: d_position := 0;
787:
788: IF (PO_LOG.d_proc) THEN
789: PO_LOG.proc_begin(d_module);
790: END IF;
791:
792: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_DIST_DERIVE);
793:

Line 919: IF (PO_LOG.d_stmt) THEN

915: -- derive logic for account information
916: -- the logic will be performed on row base
917: FOR i IN 1..x_dists.rec_count
918: LOOP
919: IF (PO_LOG.d_stmt) THEN
920: PO_LOG.stmt(d_module, d_position, 'derive index', i);
921: END IF;
922:
923: -- derive charge_account_id

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

916: -- the logic will be performed on row base
917: FOR i IN 1..x_dists.rec_count
918: LOOP
919: IF (PO_LOG.d_stmt) THEN
920: PO_LOG.stmt(d_module, d_position, 'derive index', i);
921: END IF;
922:
923: -- derive charge_account_id
924: IF (x_dists.charge_account_id_tbl(i) IS NULL AND

Line 963: IF (PO_LOG.d_stmt) THEN

959: p_account_segment30 => x_dists.account_segment30_tbl(i),
960: x_account_id => x_dists.charge_account_id_tbl(i)
961: );
962:
963: IF (PO_LOG.d_stmt) THEN
964: PO_LOG.stmt(d_module, d_position, 'derived charge account id',
965: x_dists.charge_account_id_tbl(i));
966: END IF;
967: END IF;

Line 964: PO_LOG.stmt(d_module, d_position, 'derived charge account id',

960: x_account_id => x_dists.charge_account_id_tbl(i)
961: );
962:
963: IF (PO_LOG.d_stmt) THEN
964: PO_LOG.stmt(d_module, d_position, 'derived charge account id',
965: x_dists.charge_account_id_tbl(i));
966: END IF;
967: END IF;
968:

Line 1011: IF (PO_LOG.d_stmt) THEN

1007: p_account_segment30 => x_dists.account_segment30_tbl(i),
1008: x_account_id => x_dists.dest_charge_account_id_tbl(i)
1009: );
1010:
1011: IF (PO_LOG.d_stmt) THEN
1012: PO_LOG.stmt(d_module, d_position, 'derived dest charge account id',
1013: x_dists.dest_charge_account_id_tbl(i));
1014: END IF;
1015: END IF;

Line 1012: PO_LOG.stmt(d_module, d_position, 'derived dest charge account id',

1008: x_account_id => x_dists.dest_charge_account_id_tbl(i)
1009: );
1010:
1011: IF (PO_LOG.d_stmt) THEN
1012: PO_LOG.stmt(d_module, d_position, 'derived dest charge account id',
1013: x_dists.dest_charge_account_id_tbl(i));
1014: END IF;
1015: END IF;
1016:

Line 1029: IF (PO_LOG.d_stmt) THEN

1025: PO_PDOI_PARAMS.g_product.project_cwk_installed = FND_API.g_FALSE) THEN
1026:
1027: d_position := 120;
1028:
1029: IF (PO_LOG.d_stmt) THEN
1030: PO_LOG.stmt(d_module, d_position, 'all project info need to be empty');
1031: END IF;
1032:
1033: -- validate all project fields should be null

Line 1030: PO_LOG.stmt(d_module, d_position, 'all project info need to be empty');

1026:
1027: d_position := 120;
1028:
1029: IF (PO_LOG.d_stmt) THEN
1030: PO_LOG.stmt(d_module, d_position, 'all project info need to be empty');
1031: END IF;
1032:
1033: -- validate all project fields should be null
1034: validate_null_for_project_info

Line 1050: IF (PO_LOG.d_stmt) THEN

1046:
1047: -- derive project fields if enabled
1048: IF (PO_PDOI_PARAMS.g_product.pa_installed = FND_API.g_TRUE AND
1049: x_dists.project_accounting_context_tbl(i) = 'Y') THEN
1050: IF (PO_LOG.d_stmt) THEN
1051: PO_LOG.stmt(d_module, d_position, 'project info needs to be derived');
1052: END IF;
1053:
1054: -- mark the line to do the derivation logic later

Line 1051: PO_LOG.stmt(d_module, d_position, 'project info needs to be derived');

1047: -- derive project fields if enabled
1048: IF (PO_PDOI_PARAMS.g_product.pa_installed = FND_API.g_TRUE AND
1049: x_dists.project_accounting_context_tbl(i) = 'Y') THEN
1050: IF (PO_LOG.d_stmt) THEN
1051: PO_LOG.stmt(d_module, d_position, 'project info needs to be derived');
1052: END IF;
1053:
1054: -- mark the line to do the derivation logic later
1055: l_derive_project_info_row_tbl(i) := i;

Line 1067: IF (PO_LOG.d_stmt) THEN

1063: OR
1064: (x_dists.project_accounting_context_tbl(i) <> 'Y')
1065: OR
1066: (x_dists.dest_type_code_tbl(i) <> 'EXPENSE') THEN
1067: IF (PO_LOG.d_stmt) THEN
1068: PO_LOG.stmt(d_module, d_position, 'set gms_txn_required_flag to N');
1069: END IF;
1070:
1071: x_dists.gms_txn_required_flag_tbl(i) := 'N';

Line 1068: PO_LOG.stmt(d_module, d_position, 'set gms_txn_required_flag to N');

1064: (x_dists.project_accounting_context_tbl(i) <> 'Y')
1065: OR
1066: (x_dists.dest_type_code_tbl(i) <> 'EXPENSE') THEN
1067: IF (PO_LOG.d_stmt) THEN
1068: PO_LOG.stmt(d_module, d_position, 'set gms_txn_required_flag to N');
1069: END IF;
1070:
1071: x_dists.gms_txn_required_flag_tbl(i) := 'N';
1072: x_dists.award_id_tbl(i) := NULL;

Line 1074: IF (PO_LOG.d_stmt) THEN

1070:
1071: x_dists.gms_txn_required_flag_tbl(i) := 'N';
1072: x_dists.award_id_tbl(i) := NULL;
1073: ELSE
1074: IF (PO_LOG.d_stmt) THEN
1075: PO_LOG.stmt(d_module, d_position, 'set gms_txn_required_flag to Y');
1076: END IF;
1077:
1078: x_dists.gms_txn_required_flag_tbl(i) := 'Y';

Line 1075: PO_LOG.stmt(d_module, d_position, 'set gms_txn_required_flag to Y');

1071: x_dists.gms_txn_required_flag_tbl(i) := 'N';
1072: x_dists.award_id_tbl(i) := NULL;
1073: ELSE
1074: IF (PO_LOG.d_stmt) THEN
1075: PO_LOG.stmt(d_module, d_position, 'set gms_txn_required_flag to Y');
1076: END IF;
1077:
1078: x_dists.gms_txn_required_flag_tbl(i) := 'Y';
1079: END IF;

Line 1103: IF (PO_LOG.d_stmt) THEN

1099: x_return_status => l_return_status,
1100: p_award_number => x_dists.award_num_tbl(i)
1101: );
1102:
1103: IF (PO_LOG.d_stmt) THEN
1104: PO_LOG.stmt(d_module, d_position, 'l_return_status', l_return_status);
1105: PO_LOG.stmt(d_module, d_position, 'award_id', x_dists.award_id_tbl(i));
1106: END IF;
1107:

Line 1104: PO_LOG.stmt(d_module, d_position, 'l_return_status', l_return_status);

1100: p_award_number => x_dists.award_num_tbl(i)
1101: );
1102:
1103: IF (PO_LOG.d_stmt) THEN
1104: PO_LOG.stmt(d_module, d_position, 'l_return_status', l_return_status);
1105: PO_LOG.stmt(d_module, d_position, 'award_id', x_dists.award_id_tbl(i));
1106: END IF;
1107:
1108: -- check return status to see whether derivation is successful

Line 1105: PO_LOG.stmt(d_module, d_position, 'award_id', x_dists.award_id_tbl(i));

1101: );
1102:
1103: IF (PO_LOG.d_stmt) THEN
1104: PO_LOG.stmt(d_module, d_position, 'l_return_status', l_return_status);
1105: PO_LOG.stmt(d_module, d_position, 'award_id', x_dists.award_id_tbl(i));
1106: END IF;
1107:
1108: -- check return status to see whether derivation is successful
1109: IF (l_return_status <> FND_API.g_RET_STS_SUCCESS) THEN

Line 1148: IF (PO_LOG.d_stmt) THEN

1144:
1145: -- handle all derivation errors
1146: FOR i IN 1..x_dists.rec_count
1147: LOOP
1148: IF (PO_LOG.d_stmt) THEN
1149: PO_LOG.stmt(d_module, d_position, 'index', i);
1150: END IF;
1151:
1152: -- derivation error for deliver_to_location_id

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

1145: -- handle all derivation errors
1146: FOR i IN 1..x_dists.rec_count
1147: LOOP
1148: IF (PO_LOG.d_stmt) THEN
1149: PO_LOG.stmt(d_module, d_position, 'index', i);
1150: END IF;
1151:
1152: -- derivation error for deliver_to_location_id
1153: IF (x_dists.deliver_to_loc_tbl(i) IS NOT NULL AND

Line 1155: IF (PO_LOG.d_stmt) THEN

1151:
1152: -- derivation error for deliver_to_location_id
1153: IF (x_dists.deliver_to_loc_tbl(i) IS NOT NULL AND
1154: x_dists.deliver_to_loc_id_tbl(i) IS NULL) THEN
1155: IF (PO_LOG.d_stmt) THEN
1156: PO_LOG.stmt(d_module, d_position, 'deliver to loc id derivation failed');
1157: PO_LOG.stmt(d_module, d_position, 'deliver to loc', x_dists.deliver_to_loc_tbl(i));
1158: END IF;
1159:

Line 1156: PO_LOG.stmt(d_module, d_position, 'deliver to loc id derivation failed');

1152: -- derivation error for deliver_to_location_id
1153: IF (x_dists.deliver_to_loc_tbl(i) IS NOT NULL AND
1154: x_dists.deliver_to_loc_id_tbl(i) IS NULL) THEN
1155: IF (PO_LOG.d_stmt) THEN
1156: PO_LOG.stmt(d_module, d_position, 'deliver to loc id derivation failed');
1157: PO_LOG.stmt(d_module, d_position, 'deliver to loc', x_dists.deliver_to_loc_tbl(i));
1158: END IF;
1159:
1160: PO_PDOI_ERR_UTL.add_fatal_error

Line 1157: PO_LOG.stmt(d_module, d_position, 'deliver to loc', x_dists.deliver_to_loc_tbl(i));

1153: IF (x_dists.deliver_to_loc_tbl(i) IS NOT NULL AND
1154: x_dists.deliver_to_loc_id_tbl(i) IS NULL) THEN
1155: IF (PO_LOG.d_stmt) THEN
1156: PO_LOG.stmt(d_module, d_position, 'deliver to loc id derivation failed');
1157: PO_LOG.stmt(d_module, d_position, 'deliver to loc', x_dists.deliver_to_loc_tbl(i));
1158: END IF;
1159:
1160: PO_PDOI_ERR_UTL.add_fatal_error
1161: (

Line 1180: IF (PO_LOG.d_stmt) THEN

1176:
1177: -- derivation error for deliver_to_person_id
1178: IF (x_dists.deliver_to_person_name_tbl(i) IS NOT NULL AND
1179: x_dists.deliver_to_person_id_tbl(i) IS NULL) THEN
1180: IF (PO_LOG.d_stmt) THEN
1181: PO_LOG.stmt(d_module, d_position, 'deliver to person id derivation failed');
1182: PO_LOG.stmt(d_module, d_position, 'deliver to person name',
1183: x_dists.deliver_to_person_name_tbl(i));
1184: END IF;

Line 1181: PO_LOG.stmt(d_module, d_position, 'deliver to person id derivation failed');

1177: -- derivation error for deliver_to_person_id
1178: IF (x_dists.deliver_to_person_name_tbl(i) IS NOT NULL AND
1179: x_dists.deliver_to_person_id_tbl(i) IS NULL) THEN
1180: IF (PO_LOG.d_stmt) THEN
1181: PO_LOG.stmt(d_module, d_position, 'deliver to person id derivation failed');
1182: PO_LOG.stmt(d_module, d_position, 'deliver to person name',
1183: x_dists.deliver_to_person_name_tbl(i));
1184: END IF;
1185:

Line 1182: PO_LOG.stmt(d_module, d_position, 'deliver to person name',

1178: IF (x_dists.deliver_to_person_name_tbl(i) IS NOT NULL AND
1179: x_dists.deliver_to_person_id_tbl(i) IS NULL) THEN
1180: IF (PO_LOG.d_stmt) THEN
1181: PO_LOG.stmt(d_module, d_position, 'deliver to person id derivation failed');
1182: PO_LOG.stmt(d_module, d_position, 'deliver to person name',
1183: x_dists.deliver_to_person_name_tbl(i));
1184: END IF;
1185:
1186: PO_PDOI_ERR_UTL.add_fatal_error

Line 1206: IF (PO_LOG.d_stmt) THEN

1202:
1203: -- derivation error for destination_type_code
1204: IF (x_dists.dest_type_tbl(i) IS NOT NULL AND
1205: x_dists.dest_type_code_tbl(i) IS NULL) THEN
1206: IF (PO_LOG.d_stmt) THEN
1207: PO_LOG.stmt(d_module, d_position, 'dest type code derivation failed');
1208: PO_LOG.stmt(d_module, d_position, 'dest type',
1209: x_dists.dest_type_tbl(i));
1210: END IF;

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

1203: -- derivation error for destination_type_code
1204: IF (x_dists.dest_type_tbl(i) IS NOT NULL AND
1205: x_dists.dest_type_code_tbl(i) IS NULL) THEN
1206: IF (PO_LOG.d_stmt) THEN
1207: PO_LOG.stmt(d_module, d_position, 'dest type code derivation failed');
1208: PO_LOG.stmt(d_module, d_position, 'dest type',
1209: x_dists.dest_type_tbl(i));
1210: END IF;
1211:

Line 1208: PO_LOG.stmt(d_module, d_position, 'dest type',

1204: IF (x_dists.dest_type_tbl(i) IS NOT NULL AND
1205: x_dists.dest_type_code_tbl(i) IS NULL) THEN
1206: IF (PO_LOG.d_stmt) THEN
1207: PO_LOG.stmt(d_module, d_position, 'dest type code derivation failed');
1208: PO_LOG.stmt(d_module, d_position, 'dest type',
1209: x_dists.dest_type_tbl(i));
1210: END IF;
1211:
1212: PO_PDOI_ERR_UTL.add_fatal_error

Line 1232: IF (PO_LOG.d_stmt) THEN

1228:
1229: -- derivation error for destination_organization_id
1230: IF (x_dists.dest_org_tbl(i) IS NOT NULL AND
1231: x_dists.dest_org_id_tbl(i) IS NULL) THEN
1232: IF (PO_LOG.d_stmt) THEN
1233: PO_LOG.stmt(d_module, d_position, 'dest org id derivation failed');
1234: PO_LOG.stmt(d_module, d_position, 'dest org',
1235: x_dists.dest_org_tbl(i));
1236: END IF;

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

1229: -- derivation error for destination_organization_id
1230: IF (x_dists.dest_org_tbl(i) IS NOT NULL AND
1231: x_dists.dest_org_id_tbl(i) IS NULL) THEN
1232: IF (PO_LOG.d_stmt) THEN
1233: PO_LOG.stmt(d_module, d_position, 'dest org id derivation failed');
1234: PO_LOG.stmt(d_module, d_position, 'dest org',
1235: x_dists.dest_org_tbl(i));
1236: END IF;
1237:

Line 1234: PO_LOG.stmt(d_module, d_position, 'dest org',

1230: IF (x_dists.dest_org_tbl(i) IS NOT NULL AND
1231: x_dists.dest_org_id_tbl(i) IS NULL) THEN
1232: IF (PO_LOG.d_stmt) THEN
1233: PO_LOG.stmt(d_module, d_position, 'dest org id derivation failed');
1234: PO_LOG.stmt(d_module, d_position, 'dest org',
1235: x_dists.dest_org_tbl(i));
1236: END IF;
1237:
1238: PO_PDOI_ERR_UTL.add_fatal_error

Line 1260: IF (PO_LOG.d_stmt) THEN

1256: x_dists.dest_type_code_tbl(i) = 'SHOP FLOOR') THEN
1257: -- derivation error for wip_entity_id
1258: IF (x_dists.wip_entity_tbl(i) IS NOT NULL AND
1259: x_dists.wip_entity_id_tbl(i) IS NULL) THEN
1260: IF (PO_LOG.d_stmt) THEN
1261: PO_LOG.stmt(d_module, d_position, 'wip entity id derivation failed');
1262: PO_LOG.stmt(d_module, d_position, 'wip entity',
1263: x_dists.wip_entity_tbl(i));
1264: END IF;

Line 1261: PO_LOG.stmt(d_module, d_position, 'wip entity id derivation failed');

1257: -- derivation error for wip_entity_id
1258: IF (x_dists.wip_entity_tbl(i) IS NOT NULL AND
1259: x_dists.wip_entity_id_tbl(i) IS NULL) THEN
1260: IF (PO_LOG.d_stmt) THEN
1261: PO_LOG.stmt(d_module, d_position, 'wip entity id derivation failed');
1262: PO_LOG.stmt(d_module, d_position, 'wip entity',
1263: x_dists.wip_entity_tbl(i));
1264: END IF;
1265:

Line 1262: PO_LOG.stmt(d_module, d_position, 'wip entity',

1258: IF (x_dists.wip_entity_tbl(i) IS NOT NULL AND
1259: x_dists.wip_entity_id_tbl(i) IS NULL) THEN
1260: IF (PO_LOG.d_stmt) THEN
1261: PO_LOG.stmt(d_module, d_position, 'wip entity id derivation failed');
1262: PO_LOG.stmt(d_module, d_position, 'wip entity',
1263: x_dists.wip_entity_tbl(i));
1264: END IF;
1265:
1266: PO_PDOI_ERR_UTL.add_fatal_error

Line 1286: IF (PO_LOG.d_stmt) THEN

1282:
1283: -- derivation error for wip_line_id
1284: IF (x_dists.wip_line_code_tbl(i) IS NOT NULL AND
1285: x_dists.wip_line_id_tbl(i) IS NULL) THEN
1286: IF (PO_LOG.d_stmt) THEN
1287: PO_LOG.stmt(d_module, d_position, 'wip line id derivation failed');
1288: PO_LOG.stmt(d_module, d_position, 'wip line code',
1289: x_dists.wip_line_code_tbl(i));
1290: END IF;

Line 1287: PO_LOG.stmt(d_module, d_position, 'wip line id derivation failed');

1283: -- derivation error for wip_line_id
1284: IF (x_dists.wip_line_code_tbl(i) IS NOT NULL AND
1285: x_dists.wip_line_id_tbl(i) IS NULL) THEN
1286: IF (PO_LOG.d_stmt) THEN
1287: PO_LOG.stmt(d_module, d_position, 'wip line id derivation failed');
1288: PO_LOG.stmt(d_module, d_position, 'wip line code',
1289: x_dists.wip_line_code_tbl(i));
1290: END IF;
1291:

Line 1288: PO_LOG.stmt(d_module, d_position, 'wip line code',

1284: IF (x_dists.wip_line_code_tbl(i) IS NOT NULL AND
1285: x_dists.wip_line_id_tbl(i) IS NULL) THEN
1286: IF (PO_LOG.d_stmt) THEN
1287: PO_LOG.stmt(d_module, d_position, 'wip line id derivation failed');
1288: PO_LOG.stmt(d_module, d_position, 'wip line code',
1289: x_dists.wip_line_code_tbl(i));
1290: END IF;
1291:
1292: PO_PDOI_ERR_UTL.add_fatal_error

Line 1313: IF (PO_LOG.d_stmt) THEN

1309:
1310: -- derivation error for bom_resource_id
1311: IF (x_dists.bom_resource_code_tbl(i) IS NOT NULL AND
1312: x_dists.bom_resource_id_tbl(i) IS NULL) THEN
1313: IF (PO_LOG.d_stmt) THEN
1314: PO_LOG.stmt(d_module, d_position, 'bom resource id derivation failed');
1315: PO_LOG.stmt(d_module, d_position, 'bom resource code',
1316: x_dists.bom_resource_code_tbl(i));
1317: END IF;

Line 1314: PO_LOG.stmt(d_module, d_position, 'bom resource id derivation failed');

1310: -- derivation error for bom_resource_id
1311: IF (x_dists.bom_resource_code_tbl(i) IS NOT NULL AND
1312: x_dists.bom_resource_id_tbl(i) IS NULL) THEN
1313: IF (PO_LOG.d_stmt) THEN
1314: PO_LOG.stmt(d_module, d_position, 'bom resource id derivation failed');
1315: PO_LOG.stmt(d_module, d_position, 'bom resource code',
1316: x_dists.bom_resource_code_tbl(i));
1317: END IF;
1318:

Line 1315: PO_LOG.stmt(d_module, d_position, 'bom resource code',

1311: IF (x_dists.bom_resource_code_tbl(i) IS NOT NULL AND
1312: x_dists.bom_resource_id_tbl(i) IS NULL) THEN
1313: IF (PO_LOG.d_stmt) THEN
1314: PO_LOG.stmt(d_module, d_position, 'bom resource id derivation failed');
1315: PO_LOG.stmt(d_module, d_position, 'bom resource code',
1316: x_dists.bom_resource_code_tbl(i));
1317: END IF;
1318:
1319: PO_PDOI_ERR_UTL.add_fatal_error

Line 1340: IF (PO_LOG.d_stmt) THEN

1336: -- derivation error for ship_to_ou_coa_id
1337: IF (x_dists.dest_charge_account_id_tbl(i) IS NULL AND
1338: x_dists.loc_txn_flow_header_id_tbl(i) IS NOT NULL AND
1339: x_dists.ship_to_ou_coa_id_tbl(i) = -1) THEN
1340: IF (PO_LOG.d_stmt) THEN
1341: PO_LOG.stmt(d_module, d_position, 'ship_to ou coa id derivation failed');
1342: END IF;
1343:
1344: PO_PDOI_ERR_UTL.add_fatal_error

Line 1341: PO_LOG.stmt(d_module, d_position, 'ship_to ou coa id derivation failed');

1337: IF (x_dists.dest_charge_account_id_tbl(i) IS NULL AND
1338: x_dists.loc_txn_flow_header_id_tbl(i) IS NOT NULL AND
1339: x_dists.ship_to_ou_coa_id_tbl(i) = -1) THEN
1340: IF (PO_LOG.d_stmt) THEN
1341: PO_LOG.stmt(d_module, d_position, 'ship_to ou coa id derivation failed');
1342: END IF;
1343:
1344: PO_PDOI_ERR_UTL.add_fatal_error
1345: (

Line 1363: IF (PO_LOG.d_stmt) THEN

1359: END IF;
1360:
1361: -- check derivation error for project fields
1362: IF (l_derive_project_info_row_tbl.EXISTS(i)) THEN
1363: IF (PO_LOG.d_stmt) THEN
1364: PO_LOG.stmt(d_module, d_position, 'l_derive_project_info_row',
1365: l_derive_project_info_row_tbl.EXISTS(i));
1366: END IF;
1367:

Line 1364: PO_LOG.stmt(d_module, d_position, 'l_derive_project_info_row',

1360:
1361: -- check derivation error for project fields
1362: IF (l_derive_project_info_row_tbl.EXISTS(i)) THEN
1363: IF (PO_LOG.d_stmt) THEN
1364: PO_LOG.stmt(d_module, d_position, 'l_derive_project_info_row',
1365: l_derive_project_info_row_tbl.EXISTS(i));
1366: END IF;
1367:
1368: -- derivation error for project_id

Line 1371: IF (PO_LOG.d_stmt) THEN

1367:
1368: -- derivation error for project_id
1369: IF (x_dists.project_tbl(i) IS NOT NULL AND
1370: x_dists.project_id_tbl(i) IS NULL) THEN
1371: IF (PO_LOG.d_stmt) THEN
1372: PO_LOG.stmt(d_module, d_position, 'project id derivation failed');
1373: PO_LOG.stmt(d_module, d_position, 'project',
1374: x_dists.project_tbl(i));
1375: END IF;

Line 1372: PO_LOG.stmt(d_module, d_position, 'project id derivation failed');

1368: -- derivation error for project_id
1369: IF (x_dists.project_tbl(i) IS NOT NULL AND
1370: x_dists.project_id_tbl(i) IS NULL) THEN
1371: IF (PO_LOG.d_stmt) THEN
1372: PO_LOG.stmt(d_module, d_position, 'project id derivation failed');
1373: PO_LOG.stmt(d_module, d_position, 'project',
1374: x_dists.project_tbl(i));
1375: END IF;
1376:

Line 1373: PO_LOG.stmt(d_module, d_position, 'project',

1369: IF (x_dists.project_tbl(i) IS NOT NULL AND
1370: x_dists.project_id_tbl(i) IS NULL) THEN
1371: IF (PO_LOG.d_stmt) THEN
1372: PO_LOG.stmt(d_module, d_position, 'project id derivation failed');
1373: PO_LOG.stmt(d_module, d_position, 'project',
1374: x_dists.project_tbl(i));
1375: END IF;
1376:
1377: PO_PDOI_ERR_UTL.add_fatal_error

Line 1398: IF (PO_LOG.d_stmt) THEN

1394: -- derivation error for task_id
1395: IF (x_dists.project_id_tbl(i) IS NOT NULL AND
1396: x_dists.task_tbl(i) IS NOT NULL AND
1397: x_dists.task_id_tbl(i) IS NULL) THEN
1398: IF (PO_LOG.d_stmt) THEN
1399: PO_LOG.stmt(d_module, d_position, 'task id derivation failed');
1400: PO_LOG.stmt(d_module, d_position, 'task',
1401: x_dists.task_tbl(i));
1402: END IF;

Line 1399: PO_LOG.stmt(d_module, d_position, 'task id derivation failed');

1395: IF (x_dists.project_id_tbl(i) IS NOT NULL AND
1396: x_dists.task_tbl(i) IS NOT NULL AND
1397: x_dists.task_id_tbl(i) IS NULL) THEN
1398: IF (PO_LOG.d_stmt) THEN
1399: PO_LOG.stmt(d_module, d_position, 'task id derivation failed');
1400: PO_LOG.stmt(d_module, d_position, 'task',
1401: x_dists.task_tbl(i));
1402: END IF;
1403:

Line 1400: PO_LOG.stmt(d_module, d_position, 'task',

1396: x_dists.task_tbl(i) IS NOT NULL AND
1397: x_dists.task_id_tbl(i) IS NULL) THEN
1398: IF (PO_LOG.d_stmt) THEN
1399: PO_LOG.stmt(d_module, d_position, 'task id derivation failed');
1400: PO_LOG.stmt(d_module, d_position, 'task',
1401: x_dists.task_tbl(i));
1402: END IF;
1403:
1404: PO_PDOI_ERR_UTL.add_fatal_error

Line 1425: IF (PO_LOG.d_stmt) THEN

1421: -- derivation error for expenditure_type
1422: IF (x_dists.project_id_tbl(i) IS NOT NULL AND
1423: x_dists.expenditure_tbl(i) IS NOT NULL AND
1424: x_dists.expenditure_type_tbl(i) IS NULL) THEN
1425: IF (PO_LOG.d_stmt) THEN
1426: PO_LOG.stmt(d_module, d_position, 'expenditure type derivation failed');
1427: PO_LOG.stmt(d_module, d_position, 'expenditure',
1428: x_dists.expenditure_tbl(i));
1429: END IF;

Line 1426: PO_LOG.stmt(d_module, d_position, 'expenditure type derivation failed');

1422: IF (x_dists.project_id_tbl(i) IS NOT NULL AND
1423: x_dists.expenditure_tbl(i) IS NOT NULL AND
1424: x_dists.expenditure_type_tbl(i) IS NULL) THEN
1425: IF (PO_LOG.d_stmt) THEN
1426: PO_LOG.stmt(d_module, d_position, 'expenditure type derivation failed');
1427: PO_LOG.stmt(d_module, d_position, 'expenditure',
1428: x_dists.expenditure_tbl(i));
1429: END IF;
1430:

Line 1427: PO_LOG.stmt(d_module, d_position, 'expenditure',

1423: x_dists.expenditure_tbl(i) IS NOT NULL AND
1424: x_dists.expenditure_type_tbl(i) IS NULL) THEN
1425: IF (PO_LOG.d_stmt) THEN
1426: PO_LOG.stmt(d_module, d_position, 'expenditure type derivation failed');
1427: PO_LOG.stmt(d_module, d_position, 'expenditure',
1428: x_dists.expenditure_tbl(i));
1429: END IF;
1430:
1431: PO_PDOI_ERR_UTL.add_fatal_error

Line 1452: IF (PO_LOG.d_stmt) THEN

1448: -- derivation error for expenditure_organization_id
1449: IF (x_dists.project_id_tbl(i) IS NOT NULL AND
1450: x_dists.expenditure_org_tbl(i) IS NOT NULL AND
1451: x_dists.expenditure_org_id_tbl(i) IS NULL) THEN
1452: IF (PO_LOG.d_stmt) THEN
1453: PO_LOG.stmt(d_module, d_position, 'expenditure org id derivation failed');
1454: PO_LOG.stmt(d_module, d_position, 'expenditure org',
1455: x_dists.expenditure_org_tbl(i));
1456: END IF;

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

1449: IF (x_dists.project_id_tbl(i) IS NOT NULL AND
1450: x_dists.expenditure_org_tbl(i) IS NOT NULL AND
1451: x_dists.expenditure_org_id_tbl(i) IS NULL) THEN
1452: IF (PO_LOG.d_stmt) THEN
1453: PO_LOG.stmt(d_module, d_position, 'expenditure org id derivation failed');
1454: PO_LOG.stmt(d_module, d_position, 'expenditure org',
1455: x_dists.expenditure_org_tbl(i));
1456: END IF;
1457:

Line 1454: PO_LOG.stmt(d_module, d_position, 'expenditure org',

1450: x_dists.expenditure_org_tbl(i) IS NOT NULL AND
1451: x_dists.expenditure_org_id_tbl(i) IS NULL) THEN
1452: IF (PO_LOG.d_stmt) THEN
1453: PO_LOG.stmt(d_module, d_position, 'expenditure org id derivation failed');
1454: PO_LOG.stmt(d_module, d_position, 'expenditure org',
1455: x_dists.expenditure_org_tbl(i));
1456: END IF;
1457:
1458: PO_PDOI_ERR_UTL.add_fatal_error

Line 1479: IF (PO_LOG.d_stmt) THEN

1475: -- derivation error on expenditure_item_date
1476: IF (x_dists.project_id_tbl(i) IS NOT NULL AND
1477: x_dists.expenditure_org_id_tbl(i) IS NOT NULL AND
1478: x_dists.expenditure_item_date_tbl(i) IS NULL) THEN
1479: IF (PO_LOG.d_stmt) THEN
1480: PO_LOG.stmt(d_module, d_position, 'expenditure item date derivation failed');
1481: END IF;
1482:
1483: PO_PDOI_ERR_UTL.add_fatal_error

Line 1480: PO_LOG.stmt(d_module, d_position, 'expenditure item date derivation failed');

1476: IF (x_dists.project_id_tbl(i) IS NOT NULL AND
1477: x_dists.expenditure_org_id_tbl(i) IS NOT NULL AND
1478: x_dists.expenditure_item_date_tbl(i) IS NULL) THEN
1479: IF (PO_LOG.d_stmt) THEN
1480: PO_LOG.stmt(d_module, d_position, 'expenditure item date derivation failed');
1481: END IF;
1482:
1483: PO_PDOI_ERR_UTL.add_fatal_error
1484: (

Line 1504: IF (PO_LOG.d_proc) THEN

1500: END LOOP;
1501:
1502: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_DIST_DERIVE);
1503:
1504: IF (PO_LOG.d_proc) THEN
1505: PO_LOG.proc_end (d_module);
1506: END IF;
1507:
1508: EXCEPTION

Line 1505: PO_LOG.proc_end (d_module);

1501:
1502: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_DIST_DERIVE);
1503:
1504: IF (PO_LOG.d_proc) THEN
1505: PO_LOG.proc_end (d_module);
1506: END IF;
1507:
1508: EXCEPTION
1509: WHEN OTHERS THEN

Line 1597: IF (PO_LOG.d_proc) THEN

1593: l_gl_enc_period_name VARCHAR2(30);
1594: BEGIN
1595: d_position := 0;
1596:
1597: IF (PO_LOG.d_proc) THEN
1598: PO_LOG.proc_begin(d_module);
1599: END IF;
1600:
1601: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_DIST_DEFAULT);

Line 1598: PO_LOG.proc_begin(d_module);

1594: BEGIN
1595: d_position := 0;
1596:
1597: IF (PO_LOG.d_proc) THEN
1598: PO_LOG.proc_begin(d_module);
1599: END IF;
1600:
1601: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_DIST_DEFAULT);
1602:

Line 1632: IF (PO_LOG.d_stmt) THEN

1628: -- default values for each distribution record
1629: x_dists.prevent_encumbrance_flag_tbl.EXTEND(x_dists.rec_count);
1630: FOR i IN 1..x_dists.rec_count
1631: LOOP
1632: IF (PO_LOG.d_stmt) THEN
1633: PO_LOG.stmt(d_module, d_position, 'index', i);
1634: END IF;
1635:
1636: -- default distribution_num

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

1629: x_dists.prevent_encumbrance_flag_tbl.EXTEND(x_dists.rec_count);
1630: FOR i IN 1..x_dists.rec_count
1631: LOOP
1632: IF (PO_LOG.d_stmt) THEN
1633: PO_LOG.stmt(d_module, d_position, 'index', i);
1634: END IF;
1635:
1636: -- default distribution_num
1637: IF (x_dists.dist_num_tbl(i) IS NULL OR

Line 1672: IF (PO_LOG.d_stmt) THEN

1668: x_dists.dest_context_tbl(i) := 'EXPENSE';
1669: END IF;
1670: END IF;
1671:
1672: IF (PO_LOG.d_stmt) THEN
1673: PO_LOG.stmt(d_module, d_position, 'dist num', x_dists.dist_num_tbl(i));
1674: PO_LOG.stmt(d_module, d_position, 'dist id', x_dists.po_dist_id_tbl(i));
1675: PO_LOG.stmt(d_module, d_position, 'item status', x_dists.item_status_tbl(i));
1676: PO_LOG.stmt(d_module, d_position, 'dest type code', x_dists.dest_type_code_tbl(i));

Line 1673: PO_LOG.stmt(d_module, d_position, 'dist num', x_dists.dist_num_tbl(i));

1669: END IF;
1670: END IF;
1671:
1672: IF (PO_LOG.d_stmt) THEN
1673: PO_LOG.stmt(d_module, d_position, 'dist num', x_dists.dist_num_tbl(i));
1674: PO_LOG.stmt(d_module, d_position, 'dist id', x_dists.po_dist_id_tbl(i));
1675: PO_LOG.stmt(d_module, d_position, 'item status', x_dists.item_status_tbl(i));
1676: PO_LOG.stmt(d_module, d_position, 'dest type code', x_dists.dest_type_code_tbl(i));
1677: END IF;

Line 1674: PO_LOG.stmt(d_module, d_position, 'dist id', x_dists.po_dist_id_tbl(i));

1670: END IF;
1671:
1672: IF (PO_LOG.d_stmt) THEN
1673: PO_LOG.stmt(d_module, d_position, 'dist num', x_dists.dist_num_tbl(i));
1674: PO_LOG.stmt(d_module, d_position, 'dist id', x_dists.po_dist_id_tbl(i));
1675: PO_LOG.stmt(d_module, d_position, 'item status', x_dists.item_status_tbl(i));
1676: PO_LOG.stmt(d_module, d_position, 'dest type code', x_dists.dest_type_code_tbl(i));
1677: END IF;
1678:

Line 1675: PO_LOG.stmt(d_module, d_position, 'item status', x_dists.item_status_tbl(i));

1671:
1672: IF (PO_LOG.d_stmt) THEN
1673: PO_LOG.stmt(d_module, d_position, 'dist num', x_dists.dist_num_tbl(i));
1674: PO_LOG.stmt(d_module, d_position, 'dist id', x_dists.po_dist_id_tbl(i));
1675: PO_LOG.stmt(d_module, d_position, 'item status', x_dists.item_status_tbl(i));
1676: PO_LOG.stmt(d_module, d_position, 'dest type code', x_dists.dest_type_code_tbl(i));
1677: END IF;
1678:
1679: d_position := 20;

Line 1676: PO_LOG.stmt(d_module, d_position, 'dest type code', x_dists.dest_type_code_tbl(i));

1672: IF (PO_LOG.d_stmt) THEN
1673: PO_LOG.stmt(d_module, d_position, 'dist num', x_dists.dist_num_tbl(i));
1674: PO_LOG.stmt(d_module, d_position, 'dist id', x_dists.po_dist_id_tbl(i));
1675: PO_LOG.stmt(d_module, d_position, 'item status', x_dists.item_status_tbl(i));
1676: PO_LOG.stmt(d_module, d_position, 'dest type code', x_dists.dest_type_code_tbl(i));
1677: END IF;
1678:
1679: d_position := 20;
1680:

Line 1749: IF (PO_LOG.d_stmt) THEN

1745: x_dists.expenditure_type_tbl(i) IS NULL AND
1746: x_dists.expenditure_org_id_tbl(i) IS NULL AND
1747: x_dists.expenditure_item_date_tbl(i) IS NULL AND
1748: x_dists.award_id_tbl(i) IS NULL) THEN
1749: IF (PO_LOG.d_stmt) THEN
1750: PO_LOG.stmt(d_module, d_position, 'set gms_txn_required_flag to N');
1751: END IF;
1752:
1753: x_dists.gms_txn_required_flag_tbl(i) := 'N';

Line 1750: PO_LOG.stmt(d_module, d_position, 'set gms_txn_required_flag to N');

1746: x_dists.expenditure_org_id_tbl(i) IS NULL AND
1747: x_dists.expenditure_item_date_tbl(i) IS NULL AND
1748: x_dists.award_id_tbl(i) IS NULL) THEN
1749: IF (PO_LOG.d_stmt) THEN
1750: PO_LOG.stmt(d_module, d_position, 'set gms_txn_required_flag to N');
1751: END IF;
1752:
1753: x_dists.gms_txn_required_flag_tbl(i) := 'N';
1754: END IF;

Line 1779: IF (PO_LOG.d_stmt) THEN

1775: p_expenditure_item_date => x_dists.expenditure_item_date_tbl(i),
1776: p_calling_module => 'PO_PDOI_DIST_PROCESS_PVT.default_dists'
1777: );
1778:
1779: IF (PO_LOG.d_stmt) THEN
1780: PO_LOG.stmt(d_module, d_position, 'return status', l_return_status);
1781: END IF;
1782:
1783: IF (l_return_status <> FND_API.g_RET_STS_SUCCESS) THEN

Line 1780: PO_LOG.stmt(d_module, d_position, 'return status', l_return_status);

1776: p_calling_module => 'PO_PDOI_DIST_PROCESS_PVT.default_dists'
1777: );
1778:
1779: IF (PO_LOG.d_stmt) THEN
1780: PO_LOG.stmt(d_module, d_position, 'return status', l_return_status);
1781: END IF;
1782:
1783: IF (l_return_status <> FND_API.g_RET_STS_SUCCESS) THEN
1784: PO_PDOI_ERR_UTL.add_fatal_error

Line 1802: IF (PO_LOG.d_stmt) THEN

1798: ELSE
1799:
1800: d_position := 40;
1801:
1802: IF (PO_LOG.d_stmt) THEN
1803: PO_LOG.stmt(d_module, d_position, 'award id', x_dists.award_id_tbl(i));
1804: END IF;
1805:
1806: IF (x_dists.award_id_tbl(i) IS NOT NULL) THEN

Line 1803: PO_LOG.stmt(d_module, d_position, 'award id', x_dists.award_id_tbl(i));

1799:
1800: d_position := 40;
1801:
1802: IF (PO_LOG.d_stmt) THEN
1803: PO_LOG.stmt(d_module, d_position, 'award id', x_dists.award_id_tbl(i));
1804: END IF;
1805:
1806: IF (x_dists.award_id_tbl(i) IS NOT NULL) THEN
1807: x_dists.award_set_id_tbl(i) := GMS_PO_API_GRP.get_new_award_set_id();

Line 1826: IF (PO_LOG.d_stmt) THEN

1822: p_award_id => x_dists.award_id_tbl(i),
1823: p_award_set_id => x_dists.award_set_id_tbl(i) -- bug5201306
1824: );
1825:
1826: IF (PO_LOG.d_stmt) THEN
1827: PO_LOG.stmt(d_module, d_position, 'return status', l_return_status);
1828: END IF;
1829:
1830: -- insert error if failed

Line 1827: PO_LOG.stmt(d_module, d_position, 'return status', l_return_status);

1823: p_award_set_id => x_dists.award_set_id_tbl(i) -- bug5201306
1824: );
1825:
1826: IF (PO_LOG.d_stmt) THEN
1827: PO_LOG.stmt(d_module, d_position, 'return status', l_return_status);
1828: END IF;
1829:
1830: -- insert error if failed
1831: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 1853: IF (PO_LOG.d_stmt) THEN

1849: END IF; -- IF (PO_PDOI_PARAMS.g_product.gms_enabled = FND_API.g_TRUE AND ..
1850:
1851: d_position := 50;
1852:
1853: IF (PO_LOG.d_stmt) THEN
1854: PO_LOG.stmt(d_module, d_position, 'dest type code',
1855: x_dists.dest_type_code_tbl(i));
1856: END IF;
1857:

Line 1854: PO_LOG.stmt(d_module, d_position, 'dest type code',

1850:
1851: d_position := 50;
1852:
1853: IF (PO_LOG.d_stmt) THEN
1854: PO_LOG.stmt(d_module, d_position, 'dest type code',
1855: x_dists.dest_type_code_tbl(i));
1856: END IF;
1857:
1858: -- bug 4284077:

Line 2048: IF (PO_LOG.d_stmt) THEN

2044:
2045: --END IF;
2046: --End of code changes for the bug 12933412
2047:
2048: IF (PO_LOG.d_stmt) THEN
2049: PO_LOG.stmt(d_module, d_position, 'l_success', l_success);
2050: PO_LOG.stmt(d_module, d_position, 'l_po_encumbrance_flag',
2051: l_po_encumbrance_flag);
2052: PO_LOG.stmt(d_module, d_position, 'l_charge_success', l_charge_success);

Line 2049: PO_LOG.stmt(d_module, d_position, 'l_success', l_success);

2045: --END IF;
2046: --End of code changes for the bug 12933412
2047:
2048: IF (PO_LOG.d_stmt) THEN
2049: PO_LOG.stmt(d_module, d_position, 'l_success', l_success);
2050: PO_LOG.stmt(d_module, d_position, 'l_po_encumbrance_flag',
2051: l_po_encumbrance_flag);
2052: PO_LOG.stmt(d_module, d_position, 'l_charge_success', l_charge_success);
2053: PO_LOG.stmt(d_module, d_position, 'charge_account_id',

Line 2050: PO_LOG.stmt(d_module, d_position, 'l_po_encumbrance_flag',

2046: --End of code changes for the bug 12933412
2047:
2048: IF (PO_LOG.d_stmt) THEN
2049: PO_LOG.stmt(d_module, d_position, 'l_success', l_success);
2050: PO_LOG.stmt(d_module, d_position, 'l_po_encumbrance_flag',
2051: l_po_encumbrance_flag);
2052: PO_LOG.stmt(d_module, d_position, 'l_charge_success', l_charge_success);
2053: PO_LOG.stmt(d_module, d_position, 'charge_account_id',
2054: x_dists.charge_account_id_tbl(i));

Line 2052: PO_LOG.stmt(d_module, d_position, 'l_charge_success', l_charge_success);

2048: IF (PO_LOG.d_stmt) THEN
2049: PO_LOG.stmt(d_module, d_position, 'l_success', l_success);
2050: PO_LOG.stmt(d_module, d_position, 'l_po_encumbrance_flag',
2051: l_po_encumbrance_flag);
2052: PO_LOG.stmt(d_module, d_position, 'l_charge_success', l_charge_success);
2053: PO_LOG.stmt(d_module, d_position, 'charge_account_id',
2054: x_dists.charge_account_id_tbl(i));
2055: PO_LOG.stmt(d_module, d_position, 'l_budget_success', l_budget_success);
2056: PO_LOG.stmt(d_module, d_position, 'l_accrual_success', l_accrual_success);

Line 2053: PO_LOG.stmt(d_module, d_position, 'charge_account_id',

2049: PO_LOG.stmt(d_module, d_position, 'l_success', l_success);
2050: PO_LOG.stmt(d_module, d_position, 'l_po_encumbrance_flag',
2051: l_po_encumbrance_flag);
2052: PO_LOG.stmt(d_module, d_position, 'l_charge_success', l_charge_success);
2053: PO_LOG.stmt(d_module, d_position, 'charge_account_id',
2054: x_dists.charge_account_id_tbl(i));
2055: PO_LOG.stmt(d_module, d_position, 'l_budget_success', l_budget_success);
2056: PO_LOG.stmt(d_module, d_position, 'l_accrual_success', l_accrual_success);
2057: PO_LOG.stmt(d_module, d_position, 'l_variance_success', l_variance_success);

Line 2055: PO_LOG.stmt(d_module, d_position, 'l_budget_success', l_budget_success);

2051: l_po_encumbrance_flag);
2052: PO_LOG.stmt(d_module, d_position, 'l_charge_success', l_charge_success);
2053: PO_LOG.stmt(d_module, d_position, 'charge_account_id',
2054: x_dists.charge_account_id_tbl(i));
2055: PO_LOG.stmt(d_module, d_position, 'l_budget_success', l_budget_success);
2056: PO_LOG.stmt(d_module, d_position, 'l_accrual_success', l_accrual_success);
2057: PO_LOG.stmt(d_module, d_position, 'l_variance_success', l_variance_success);
2058: END IF;
2059:

Line 2056: PO_LOG.stmt(d_module, d_position, 'l_accrual_success', l_accrual_success);

2052: PO_LOG.stmt(d_module, d_position, 'l_charge_success', l_charge_success);
2053: PO_LOG.stmt(d_module, d_position, 'charge_account_id',
2054: x_dists.charge_account_id_tbl(i));
2055: PO_LOG.stmt(d_module, d_position, 'l_budget_success', l_budget_success);
2056: PO_LOG.stmt(d_module, d_position, 'l_accrual_success', l_accrual_success);
2057: PO_LOG.stmt(d_module, d_position, 'l_variance_success', l_variance_success);
2058: END IF;
2059:
2060: d_position := 70;

Line 2057: PO_LOG.stmt(d_module, d_position, 'l_variance_success', l_variance_success);

2053: PO_LOG.stmt(d_module, d_position, 'charge_account_id',
2054: x_dists.charge_account_id_tbl(i));
2055: PO_LOG.stmt(d_module, d_position, 'l_budget_success', l_budget_success);
2056: PO_LOG.stmt(d_module, d_position, 'l_accrual_success', l_accrual_success);
2057: PO_LOG.stmt(d_module, d_position, 'l_variance_success', l_variance_success);
2058: END IF;
2059:
2060: d_position := 70;
2061:

Line 2217: IF (PO_LOG.d_proc) THEN

2213: );
2214:
2215: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_DIST_DEFAULT);
2216:
2217: IF (PO_LOG.d_proc) THEN
2218: PO_LOG.proc_end (d_module);
2219: END IF;
2220:
2221: EXCEPTION

Line 2218: PO_LOG.proc_end (d_module);

2214:
2215: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_DIST_DEFAULT);
2216:
2217: IF (PO_LOG.d_proc) THEN
2218: PO_LOG.proc_end (d_module);
2219: END IF;
2220:
2221: EXCEPTION
2222: WHEN OTHERS THEN

Line 2265: IF (PO_LOG.d_proc) THEN

2261:
2262: BEGIN
2263: d_position := 0;
2264:
2265: IF (PO_LOG.d_proc) THEN
2266: PO_LOG.proc_begin(d_module);
2267: END IF;
2268:
2269: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_DIST_VALIDATE);

Line 2266: PO_LOG.proc_begin(d_module);

2262: BEGIN
2263: d_position := 0;
2264:
2265: IF (PO_LOG.d_proc) THEN
2266: PO_LOG.proc_begin(d_module);
2267: END IF;
2268:
2269: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_DIST_VALIDATE);
2270:

Line 2348: IF (PO_LOG.d_stmt) THEN

2344: x_result_type => l_result_type,
2345: x_results => l_results
2346: );
2347:
2348: IF (PO_LOG.d_stmt) THEN
2349: PO_LOG.stmt(d_module, d_position, 'vaidate dists returns :' || l_result_type);
2350: END IF;
2351:
2352: d_position := 20;

Line 2349: PO_LOG.stmt(d_module, d_position, 'vaidate dists returns :' || l_result_type);

2345: x_results => l_results
2346: );
2347:
2348: IF (PO_LOG.d_stmt) THEN
2349: PO_LOG.stmt(d_module, d_position, 'vaidate dists returns :' || l_result_type);
2350: END IF;
2351:
2352: d_position := 20;
2353:

Line 2355: IF (PO_LOG.d_stmt) THEN

2351:
2352: d_position := 20;
2353:
2354: IF l_result_type = po_validations.c_result_type_failure THEN
2355: IF (PO_LOG.d_stmt) THEN
2356: PO_LOG.stmt(d_module, d_position, 'vaidate dists returns');
2357: END IF;
2358:
2359: PO_PDOI_ERR_UTL.process_val_type_errors

Line 2356: PO_LOG.stmt(d_module, d_position, 'vaidate dists returns');

2352: d_position := 20;
2353:
2354: IF l_result_type = po_validations.c_result_type_failure THEN
2355: IF (PO_LOG.d_stmt) THEN
2356: PO_LOG.stmt(d_module, d_position, 'vaidate dists returns');
2357: END IF;
2358:
2359: PO_PDOI_ERR_UTL.process_val_type_errors
2360: (

Line 2376: IF (PO_LOG.d_stmt) THEN

2372: );
2373: END IF;
2374:
2375: IF l_result_type = po_validations.c_result_type_fatal THEN
2376: IF (PO_LOG.d_stmt) THEN
2377: PO_LOG.stmt(d_module, d_position, 'vaidate dists return fatal');
2378: END IF;
2379:
2380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2377: PO_LOG.stmt(d_module, d_position, 'vaidate dists return fatal');

2373: END IF;
2374:
2375: IF l_result_type = po_validations.c_result_type_fatal THEN
2376: IF (PO_LOG.d_stmt) THEN
2377: PO_LOG.stmt(d_module, d_position, 'vaidate dists return fatal');
2378: END IF;
2379:
2380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2381: END IF;

Line 2385: IF (PO_LOG.d_proc) THEN

2381: END IF;
2382:
2383: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_DIST_VALIDATE);
2384:
2385: IF (PO_LOG.d_proc) THEN
2386: PO_LOG.proc_end (d_module);
2387: END IF;
2388:
2389: EXCEPTION

Line 2386: PO_LOG.proc_end (d_module);

2382:
2383: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_DIST_VALIDATE);
2384:
2385: IF (PO_LOG.d_proc) THEN
2386: PO_LOG.proc_end (d_module);
2387: END IF;
2388:
2389: EXCEPTION
2390: WHEN OTHERS THEN

Line 2442: IF (PO_LOG.d_proc) THEN

2438: l_result_tbl PO_TBL_NUMBER;
2439: BEGIN
2440: d_position := 0;
2441:
2442: IF (PO_LOG.d_proc) THEN
2443: PO_LOG.proc_begin(d_module, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
2444: PO_LOG.proc_begin(d_module, 'x_ship_to_ou_id_tbl', x_ship_to_ou_id_tbl);
2445: END IF;
2446:

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

2439: BEGIN
2440: d_position := 0;
2441:
2442: IF (PO_LOG.d_proc) THEN
2443: PO_LOG.proc_begin(d_module, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
2444: PO_LOG.proc_begin(d_module, 'x_ship_to_ou_id_tbl', x_ship_to_ou_id_tbl);
2445: END IF;
2446:
2447: x_ship_to_ou_id_tbl := PO_TBL_NUMBER();

Line 2444: PO_LOG.proc_begin(d_module, 'x_ship_to_ou_id_tbl', x_ship_to_ou_id_tbl);

2440: d_position := 0;
2441:
2442: IF (PO_LOG.d_proc) THEN
2443: PO_LOG.proc_begin(d_module, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
2444: PO_LOG.proc_begin(d_module, 'x_ship_to_ou_id_tbl', x_ship_to_ou_id_tbl);
2445: END IF;
2446:
2447: x_ship_to_ou_id_tbl := PO_TBL_NUMBER();
2448: x_ship_to_ou_id_tbl.EXTEND(p_index_tbl.COUNT);

Line 2475: IF (PO_LOG.d_stmt) THEN

2471:
2472: -- set value back to x_ship_to_ou_id_tbl
2473: FOR i IN 1..l_index_tbl.COUNT
2474: LOOP
2475: IF (PO_LOG.d_stmt) THEN
2476: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2477: PO_LOG.stmt(d_module, d_position, 'new ship_to ou id',
2478: l_result_tbl(i));
2479: END IF;

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

2472: -- set value back to x_ship_to_ou_id_tbl
2473: FOR i IN 1..l_index_tbl.COUNT
2474: LOOP
2475: IF (PO_LOG.d_stmt) THEN
2476: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2477: PO_LOG.stmt(d_module, d_position, 'new ship_to ou id',
2478: l_result_tbl(i));
2479: END IF;
2480:

Line 2477: PO_LOG.stmt(d_module, d_position, 'new ship_to ou id',

2473: FOR i IN 1..l_index_tbl.COUNT
2474: LOOP
2475: IF (PO_LOG.d_stmt) THEN
2476: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2477: PO_LOG.stmt(d_module, d_position, 'new ship_to ou id',
2478: l_result_tbl(i));
2479: END IF;
2480:
2481: x_ship_to_ou_id_tbl(l_index_tbl(i)) := l_result_tbl(i);

Line 2484: IF (PO_LOG.d_proc) THEN

2480:
2481: x_ship_to_ou_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
2482: END LOOP;
2483:
2484: IF (PO_LOG.d_proc) THEN
2485: PO_LOG.proc_end (d_module);
2486: END IF;
2487:
2488: EXCEPTION

Line 2485: PO_LOG.proc_end (d_module);

2481: x_ship_to_ou_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
2482: END LOOP;
2483:
2484: IF (PO_LOG.d_proc) THEN
2485: PO_LOG.proc_end (d_module);
2486: END IF;
2487:
2488: EXCEPTION
2489: WHEN OTHERS THEN

Line 2537: IF (PO_LOG.d_proc) THEN

2533: l_result_tbl PO_TBL_NUMBER;
2534: BEGIN
2535: d_position := 0;
2536:
2537: IF (PO_LOG.d_proc) THEN
2538: PO_LOG.proc_begin(d_module, 'p_deliver_to_loc_tbl',
2539: p_deliver_to_loc_tbl);
2540: PO_LOG.proc_begin(d_module, 'x_deliver_to_loc_id_tbl',
2541: x_deliver_to_loc_id_tbl);

Line 2538: PO_LOG.proc_begin(d_module, 'p_deliver_to_loc_tbl',

2534: BEGIN
2535: d_position := 0;
2536:
2537: IF (PO_LOG.d_proc) THEN
2538: PO_LOG.proc_begin(d_module, 'p_deliver_to_loc_tbl',
2539: p_deliver_to_loc_tbl);
2540: PO_LOG.proc_begin(d_module, 'x_deliver_to_loc_id_tbl',
2541: x_deliver_to_loc_id_tbl);
2542: END IF;

Line 2540: PO_LOG.proc_begin(d_module, 'x_deliver_to_loc_id_tbl',

2536:
2537: IF (PO_LOG.d_proc) THEN
2538: PO_LOG.proc_begin(d_module, 'p_deliver_to_loc_tbl',
2539: p_deliver_to_loc_tbl);
2540: PO_LOG.proc_begin(d_module, 'x_deliver_to_loc_id_tbl',
2541: x_deliver_to_loc_id_tbl);
2542: END IF;
2543:
2544: -- query database to get derived result in batch mode

Line 2568: IF (PO_LOG.d_stmt) THEN

2564:
2565: -- set value back to x_deliver_to_loc_id_tbl
2566: FOR i IN 1..l_index_tbl.COUNT
2567: LOOP
2568: IF (PO_LOG.d_stmt) THEN
2569: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2570: PO_LOG.stmt(d_module, d_position, 'new deliver_to loc id',
2571: l_result_tbl(i));
2572: END IF;

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

2565: -- set value back to x_deliver_to_loc_id_tbl
2566: FOR i IN 1..l_index_tbl.COUNT
2567: LOOP
2568: IF (PO_LOG.d_stmt) THEN
2569: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2570: PO_LOG.stmt(d_module, d_position, 'new deliver_to loc id',
2571: l_result_tbl(i));
2572: END IF;
2573:

Line 2570: PO_LOG.stmt(d_module, d_position, 'new deliver_to loc id',

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

Line 2577: IF (PO_LOG.d_proc) THEN

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

Line 2578: PO_LOG.proc_end (d_module);

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

Line 2630: IF (PO_LOG.d_proc) THEN

2626: l_result_tbl PO_TBL_NUMBER;
2627: BEGIN
2628: d_position := 0;
2629:
2630: IF (PO_LOG.d_proc) THEN
2631: PO_LOG.proc_begin(d_module, 'p_person_name_tbl', p_person_name_tbl);
2632: PO_LOG.proc_begin(d_module, 'x_person_id_tbl', x_person_id_tbl);
2633: END IF;
2634:

Line 2631: PO_LOG.proc_begin(d_module, 'p_person_name_tbl', p_person_name_tbl);

2627: BEGIN
2628: d_position := 0;
2629:
2630: IF (PO_LOG.d_proc) THEN
2631: PO_LOG.proc_begin(d_module, 'p_person_name_tbl', p_person_name_tbl);
2632: PO_LOG.proc_begin(d_module, 'x_person_id_tbl', x_person_id_tbl);
2633: END IF;
2634:
2635: -- query database to get derived result in batch mode

Line 2632: PO_LOG.proc_begin(d_module, 'x_person_id_tbl', x_person_id_tbl);

2628: d_position := 0;
2629:
2630: IF (PO_LOG.d_proc) THEN
2631: PO_LOG.proc_begin(d_module, 'p_person_name_tbl', p_person_name_tbl);
2632: PO_LOG.proc_begin(d_module, 'x_person_id_tbl', x_person_id_tbl);
2633: END IF;
2634:
2635: -- query database to get derived result in batch mode
2636: FORALL i IN 1..p_index_tbl.COUNT

Line 2659: IF (PO_LOG.d_stmt) THEN

2655:
2656: -- set value back to x_person_id_tbl
2657: FOR i IN 1..l_index_tbl.COUNT
2658: LOOP
2659: IF (PO_LOG.d_stmt) THEN
2660: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2661: PO_LOG.stmt(d_module, d_position, 'new deliver_to person id',
2662: l_result_tbl(i));
2663: END IF;

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

2656: -- set value back to x_person_id_tbl
2657: FOR i IN 1..l_index_tbl.COUNT
2658: LOOP
2659: IF (PO_LOG.d_stmt) THEN
2660: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2661: PO_LOG.stmt(d_module, d_position, 'new deliver_to person id',
2662: l_result_tbl(i));
2663: END IF;
2664:

Line 2661: PO_LOG.stmt(d_module, d_position, 'new deliver_to person id',

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

Line 2668: IF (PO_LOG.d_proc) THEN

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

Line 2669: PO_LOG.proc_end (d_module);

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

Line 2721: IF (PO_LOG.d_proc) THEN

2717: l_result_tbl PO_TBL_VARCHAR25;
2718: BEGIN
2719: d_position := 0;
2720:
2721: IF (PO_LOG.d_proc) THEN
2722: PO_LOG.proc_begin(d_module, 'p_dest_type_tbl', p_dest_type_tbl);
2723: PO_LOG.proc_begin(d_module, 'x_dest_type_code_tbl', x_dest_type_code_tbl);
2724: END IF;
2725:

Line 2722: PO_LOG.proc_begin(d_module, 'p_dest_type_tbl', p_dest_type_tbl);

2718: BEGIN
2719: d_position := 0;
2720:
2721: IF (PO_LOG.d_proc) THEN
2722: PO_LOG.proc_begin(d_module, 'p_dest_type_tbl', p_dest_type_tbl);
2723: PO_LOG.proc_begin(d_module, 'x_dest_type_code_tbl', x_dest_type_code_tbl);
2724: END IF;
2725:
2726: -- query database to get derived result in batch mode

Line 2723: PO_LOG.proc_begin(d_module, 'x_dest_type_code_tbl', x_dest_type_code_tbl);

2719: d_position := 0;
2720:
2721: IF (PO_LOG.d_proc) THEN
2722: PO_LOG.proc_begin(d_module, 'p_dest_type_tbl', p_dest_type_tbl);
2723: PO_LOG.proc_begin(d_module, 'x_dest_type_code_tbl', x_dest_type_code_tbl);
2724: END IF;
2725:
2726: -- query database to get derived result in batch mode
2727: FORALL i IN 1..p_index_tbl.COUNT

Line 2750: IF (PO_LOG.d_stmt) THEN

2746:
2747: -- set value back to x_dest_type_code_tbl
2748: FOR i IN 1..l_index_tbl.COUNT
2749: LOOP
2750: IF (PO_LOG.d_stmt) THEN
2751: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2752: PO_LOG.stmt(d_module, d_position, 'new dest type code',
2753: l_result_tbl(i));
2754: END IF;

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

2747: -- set value back to x_dest_type_code_tbl
2748: FOR i IN 1..l_index_tbl.COUNT
2749: LOOP
2750: IF (PO_LOG.d_stmt) THEN
2751: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2752: PO_LOG.stmt(d_module, d_position, 'new dest type code',
2753: l_result_tbl(i));
2754: END IF;
2755:

Line 2752: PO_LOG.stmt(d_module, d_position, 'new dest type code',

2748: FOR i IN 1..l_index_tbl.COUNT
2749: LOOP
2750: IF (PO_LOG.d_stmt) THEN
2751: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2752: PO_LOG.stmt(d_module, d_position, 'new dest type code',
2753: l_result_tbl(i));
2754: END IF;
2755:
2756: x_dest_type_code_tbl(l_index_tbl(i)) := l_result_tbl(i);

Line 2759: IF (PO_LOG.d_proc) THEN

2755:
2756: x_dest_type_code_tbl(l_index_tbl(i)) := l_result_tbl(i);
2757: END LOOP;
2758:
2759: IF (PO_LOG.d_proc) THEN
2760: PO_LOG.proc_end (d_module);
2761: END IF;
2762:
2763: EXCEPTION

Line 2760: PO_LOG.proc_end (d_module);

2756: x_dest_type_code_tbl(l_index_tbl(i)) := l_result_tbl(i);
2757: END LOOP;
2758:
2759: IF (PO_LOG.d_proc) THEN
2760: PO_LOG.proc_end (d_module);
2761: END IF;
2762:
2763: EXCEPTION
2764: WHEN OTHERS THEN

Line 2815: IF (PO_LOG.d_proc) THEN

2811: l_result_tbl PO_TBL_NUMBER;
2812: BEGIN
2813: d_position := 0;
2814:
2815: IF (PO_LOG.d_proc) THEN
2816: PO_LOG.proc_begin(d_module, 'p_dest_org_tbl', p_dest_org_tbl);
2817: PO_LOG.proc_begin(d_module, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
2818: PO_LOG.proc_begin(d_module, 'x_dest_org_id_tbl', x_dest_org_id_tbl);
2819: END IF;

Line 2816: PO_LOG.proc_begin(d_module, 'p_dest_org_tbl', p_dest_org_tbl);

2812: BEGIN
2813: d_position := 0;
2814:
2815: IF (PO_LOG.d_proc) THEN
2816: PO_LOG.proc_begin(d_module, 'p_dest_org_tbl', p_dest_org_tbl);
2817: PO_LOG.proc_begin(d_module, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
2818: PO_LOG.proc_begin(d_module, 'x_dest_org_id_tbl', x_dest_org_id_tbl);
2819: END IF;
2820:

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

2813: d_position := 0;
2814:
2815: IF (PO_LOG.d_proc) THEN
2816: PO_LOG.proc_begin(d_module, 'p_dest_org_tbl', p_dest_org_tbl);
2817: PO_LOG.proc_begin(d_module, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
2818: PO_LOG.proc_begin(d_module, 'x_dest_org_id_tbl', x_dest_org_id_tbl);
2819: END IF;
2820:
2821: -- query database to get derived result in batch mode

Line 2818: PO_LOG.proc_begin(d_module, 'x_dest_org_id_tbl', x_dest_org_id_tbl);

2814:
2815: IF (PO_LOG.d_proc) THEN
2816: PO_LOG.proc_begin(d_module, 'p_dest_org_tbl', p_dest_org_tbl);
2817: PO_LOG.proc_begin(d_module, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
2818: PO_LOG.proc_begin(d_module, 'x_dest_org_id_tbl', x_dest_org_id_tbl);
2819: END IF;
2820:
2821: -- query database to get derived result in batch mode
2822: FORALL i IN 1..p_index_tbl.COUNT

Line 2860: IF (PO_LOG.d_stmt) THEN

2856:
2857: -- set value back to x_dest_org_id_tbl
2858: FOR i IN 1..l_index_tbl.COUNT
2859: LOOP
2860: IF (PO_LOG.d_stmt) THEN
2861: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2862: PO_LOG.stmt(d_module, d_position, 'new dest org id',
2863: l_result_tbl(i));
2864: END IF;

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

2857: -- set value back to x_dest_org_id_tbl
2858: FOR i IN 1..l_index_tbl.COUNT
2859: LOOP
2860: IF (PO_LOG.d_stmt) THEN
2861: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2862: PO_LOG.stmt(d_module, d_position, 'new dest org id',
2863: l_result_tbl(i));
2864: END IF;
2865:

Line 2862: PO_LOG.stmt(d_module, d_position, 'new dest org id',

2858: FOR i IN 1..l_index_tbl.COUNT
2859: LOOP
2860: IF (PO_LOG.d_stmt) THEN
2861: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2862: PO_LOG.stmt(d_module, d_position, 'new dest org id',
2863: l_result_tbl(i));
2864: END IF;
2865:
2866: x_dest_org_id_tbl(l_index_tbl(i)) := l_result_tbl(i);

Line 2869: IF (PO_LOG.d_proc) THEN

2865:
2866: x_dest_org_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
2867: END LOOP;
2868:
2869: IF (PO_LOG.d_proc) THEN
2870: PO_LOG.proc_end (d_module);
2871: END IF;
2872:
2873: EXCEPTION

Line 2870: PO_LOG.proc_end (d_module);

2866: x_dest_org_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
2867: END LOOP;
2868:
2869: IF (PO_LOG.d_proc) THEN
2870: PO_LOG.proc_end (d_module);
2871: END IF;
2872:
2873: EXCEPTION
2874: WHEN OTHERS THEN

Line 2928: IF (PO_LOG.d_proc) THEN

2924: l_result_tbl PO_TBL_NUMBER;
2925: BEGIN
2926: d_position := 0;
2927:
2928: IF (PO_LOG.d_proc) THEN
2929: PO_LOG.proc_begin(d_module, 'p_dest_org_id_tbl', p_dest_org_id_tbl);
2930: PO_LOG.proc_begin(d_module, 'p_dest_org_id_tbl', p_dest_org_id_tbl);
2931: PO_LOG.proc_begin(d_module, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
2932: PO_LOG.proc_begin(d_module, 'x_wip_entity_id_tbl', x_wip_entity_id_tbl);

Line 2929: PO_LOG.proc_begin(d_module, 'p_dest_org_id_tbl', p_dest_org_id_tbl);

2925: BEGIN
2926: d_position := 0;
2927:
2928: IF (PO_LOG.d_proc) THEN
2929: PO_LOG.proc_begin(d_module, 'p_dest_org_id_tbl', p_dest_org_id_tbl);
2930: PO_LOG.proc_begin(d_module, 'p_dest_org_id_tbl', p_dest_org_id_tbl);
2931: PO_LOG.proc_begin(d_module, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
2932: PO_LOG.proc_begin(d_module, 'x_wip_entity_id_tbl', x_wip_entity_id_tbl);
2933: END IF;

Line 2930: PO_LOG.proc_begin(d_module, 'p_dest_org_id_tbl', p_dest_org_id_tbl);

2926: d_position := 0;
2927:
2928: IF (PO_LOG.d_proc) THEN
2929: PO_LOG.proc_begin(d_module, 'p_dest_org_id_tbl', p_dest_org_id_tbl);
2930: PO_LOG.proc_begin(d_module, 'p_dest_org_id_tbl', p_dest_org_id_tbl);
2931: PO_LOG.proc_begin(d_module, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
2932: PO_LOG.proc_begin(d_module, 'x_wip_entity_id_tbl', x_wip_entity_id_tbl);
2933: END IF;
2934:

Line 2931: PO_LOG.proc_begin(d_module, 'p_dest_type_code_tbl', p_dest_type_code_tbl);

2927:
2928: IF (PO_LOG.d_proc) THEN
2929: PO_LOG.proc_begin(d_module, 'p_dest_org_id_tbl', p_dest_org_id_tbl);
2930: PO_LOG.proc_begin(d_module, 'p_dest_org_id_tbl', p_dest_org_id_tbl);
2931: PO_LOG.proc_begin(d_module, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
2932: PO_LOG.proc_begin(d_module, 'x_wip_entity_id_tbl', x_wip_entity_id_tbl);
2933: END IF;
2934:
2935: -- query database to get derived result in batch mode

Line 2932: PO_LOG.proc_begin(d_module, 'x_wip_entity_id_tbl', x_wip_entity_id_tbl);

2928: IF (PO_LOG.d_proc) THEN
2929: PO_LOG.proc_begin(d_module, 'p_dest_org_id_tbl', p_dest_org_id_tbl);
2930: PO_LOG.proc_begin(d_module, 'p_dest_org_id_tbl', p_dest_org_id_tbl);
2931: PO_LOG.proc_begin(d_module, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
2932: PO_LOG.proc_begin(d_module, 'x_wip_entity_id_tbl', x_wip_entity_id_tbl);
2933: END IF;
2934:
2935: -- query database to get derived result in batch mode
2936: FORALL i IN 1..p_index_tbl.COUNT

Line 2961: IF (PO_LOG.d_stmt) THEN

2957:
2958: -- set value back to x_wip_entity_id_tbl
2959: FOR i IN 1..l_index_tbl.COUNT
2960: LOOP
2961: IF (PO_LOG.d_stmt) THEN
2962: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2963: PO_LOG.stmt(d_module, d_position, 'new wip entity id',
2964: l_result_tbl(i));
2965: END IF;

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

2958: -- set value back to x_wip_entity_id_tbl
2959: FOR i IN 1..l_index_tbl.COUNT
2960: LOOP
2961: IF (PO_LOG.d_stmt) THEN
2962: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2963: PO_LOG.stmt(d_module, d_position, 'new wip entity id',
2964: l_result_tbl(i));
2965: END IF;
2966:

Line 2963: PO_LOG.stmt(d_module, d_position, 'new wip entity id',

2959: FOR i IN 1..l_index_tbl.COUNT
2960: LOOP
2961: IF (PO_LOG.d_stmt) THEN
2962: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2963: PO_LOG.stmt(d_module, d_position, 'new wip entity id',
2964: l_result_tbl(i));
2965: END IF;
2966:
2967: x_wip_entity_id_tbl(l_index_tbl(i)) := l_result_tbl(i);

Line 2970: IF (PO_LOG.d_proc) THEN

2966:
2967: x_wip_entity_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
2968: END LOOP;
2969:
2970: IF (PO_LOG.d_proc) THEN
2971: PO_LOG.proc_end (d_module);
2972: END IF;
2973:
2974: EXCEPTION

Line 2971: PO_LOG.proc_end (d_module);

2967: x_wip_entity_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
2968: END LOOP;
2969:
2970: IF (PO_LOG.d_proc) THEN
2971: PO_LOG.proc_end (d_module);
2972: END IF;
2973:
2974: EXCEPTION
2975: WHEN OTHERS THEN

Line 3029: IF (PO_LOG.d_proc) THEN

3025: l_result_tbl PO_TBL_NUMBER;
3026: BEGIN
3027: d_position := 0;
3028:
3029: IF (PO_LOG.d_proc) THEN
3030: PO_LOG.proc_begin(d_module, 'p_wip_line_code_tbl', p_wip_line_code_tbl);
3031: PO_LOG.proc_begin(d_module, 'p_dest_org_id_tbl', p_dest_org_id_tbl);
3032: PO_LOG.proc_begin(d_module, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
3033: PO_LOG.proc_begin(d_module, 'x_wip_line_id_tbl', x_wip_line_id_tbl);

Line 3030: PO_LOG.proc_begin(d_module, 'p_wip_line_code_tbl', p_wip_line_code_tbl);

3026: BEGIN
3027: d_position := 0;
3028:
3029: IF (PO_LOG.d_proc) THEN
3030: PO_LOG.proc_begin(d_module, 'p_wip_line_code_tbl', p_wip_line_code_tbl);
3031: PO_LOG.proc_begin(d_module, 'p_dest_org_id_tbl', p_dest_org_id_tbl);
3032: PO_LOG.proc_begin(d_module, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
3033: PO_LOG.proc_begin(d_module, 'x_wip_line_id_tbl', x_wip_line_id_tbl);
3034: END IF;

Line 3031: PO_LOG.proc_begin(d_module, 'p_dest_org_id_tbl', p_dest_org_id_tbl);

3027: d_position := 0;
3028:
3029: IF (PO_LOG.d_proc) THEN
3030: PO_LOG.proc_begin(d_module, 'p_wip_line_code_tbl', p_wip_line_code_tbl);
3031: PO_LOG.proc_begin(d_module, 'p_dest_org_id_tbl', p_dest_org_id_tbl);
3032: PO_LOG.proc_begin(d_module, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
3033: PO_LOG.proc_begin(d_module, 'x_wip_line_id_tbl', x_wip_line_id_tbl);
3034: END IF;
3035:

Line 3032: PO_LOG.proc_begin(d_module, 'p_dest_type_code_tbl', p_dest_type_code_tbl);

3028:
3029: IF (PO_LOG.d_proc) THEN
3030: PO_LOG.proc_begin(d_module, 'p_wip_line_code_tbl', p_wip_line_code_tbl);
3031: PO_LOG.proc_begin(d_module, 'p_dest_org_id_tbl', p_dest_org_id_tbl);
3032: PO_LOG.proc_begin(d_module, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
3033: PO_LOG.proc_begin(d_module, 'x_wip_line_id_tbl', x_wip_line_id_tbl);
3034: END IF;
3035:
3036: -- query database to get derived result in batch mode

Line 3033: PO_LOG.proc_begin(d_module, 'x_wip_line_id_tbl', x_wip_line_id_tbl);

3029: IF (PO_LOG.d_proc) THEN
3030: PO_LOG.proc_begin(d_module, 'p_wip_line_code_tbl', p_wip_line_code_tbl);
3031: PO_LOG.proc_begin(d_module, 'p_dest_org_id_tbl', p_dest_org_id_tbl);
3032: PO_LOG.proc_begin(d_module, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
3033: PO_LOG.proc_begin(d_module, 'x_wip_line_id_tbl', x_wip_line_id_tbl);
3034: END IF;
3035:
3036: -- query database to get derived result in batch mode
3037: FORALL i IN 1..p_index_tbl.COUNT

Line 3062: IF (PO_LOG.d_stmt) THEN

3058:
3059: -- set value back to x_wip_line_id_tbl
3060: FOR i IN 1..l_index_tbl.COUNT
3061: LOOP
3062: IF (PO_LOG.d_stmt) THEN
3063: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3064: PO_LOG.stmt(d_module, d_position, 'new wip line id',
3065: l_result_tbl(i));
3066: END IF;

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

3059: -- set value back to x_wip_line_id_tbl
3060: FOR i IN 1..l_index_tbl.COUNT
3061: LOOP
3062: IF (PO_LOG.d_stmt) THEN
3063: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3064: PO_LOG.stmt(d_module, d_position, 'new wip line id',
3065: l_result_tbl(i));
3066: END IF;
3067:

Line 3064: PO_LOG.stmt(d_module, d_position, 'new wip line id',

3060: FOR i IN 1..l_index_tbl.COUNT
3061: LOOP
3062: IF (PO_LOG.d_stmt) THEN
3063: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3064: PO_LOG.stmt(d_module, d_position, 'new wip line id',
3065: l_result_tbl(i));
3066: END IF;
3067:
3068: x_wip_line_id_tbl(l_index_tbl(i)) := l_result_tbl(i);

Line 3071: IF (PO_LOG.d_proc) THEN

3067:
3068: x_wip_line_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
3069: END LOOP;
3070:
3071: IF (PO_LOG.d_proc) THEN
3072: PO_LOG.proc_end (d_module);
3073: END IF;
3074:
3075: EXCEPTION

Line 3072: PO_LOG.proc_end (d_module);

3068: x_wip_line_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
3069: END LOOP;
3070:
3071: IF (PO_LOG.d_proc) THEN
3072: PO_LOG.proc_end (d_module);
3073: END IF;
3074:
3075: EXCEPTION
3076: WHEN OTHERS THEN

Line 3129: IF (PO_LOG.d_proc) THEN

3125: l_result_tbl PO_TBL_NUMBER;
3126: BEGIN
3127: d_position := 0;
3128:
3129: IF (PO_LOG.d_proc) THEN
3130: PO_LOG.proc_begin(d_module, 'p_dest_org_id_tbl', p_dest_org_id_tbl);
3131: PO_LOG.proc_begin(d_module, 'p_txn_flow_header_id_tbl',
3132: p_txn_flow_header_id_tbl);
3133: PO_LOG.proc_begin(d_module, 'p_dest_charge_account_id_tbl',

Line 3130: PO_LOG.proc_begin(d_module, 'p_dest_org_id_tbl', p_dest_org_id_tbl);

3126: BEGIN
3127: d_position := 0;
3128:
3129: IF (PO_LOG.d_proc) THEN
3130: PO_LOG.proc_begin(d_module, 'p_dest_org_id_tbl', p_dest_org_id_tbl);
3131: PO_LOG.proc_begin(d_module, 'p_txn_flow_header_id_tbl',
3132: p_txn_flow_header_id_tbl);
3133: PO_LOG.proc_begin(d_module, 'p_dest_charge_account_id_tbl',
3134: p_dest_charge_account_id_tbl);

Line 3131: PO_LOG.proc_begin(d_module, 'p_txn_flow_header_id_tbl',

3127: d_position := 0;
3128:
3129: IF (PO_LOG.d_proc) THEN
3130: PO_LOG.proc_begin(d_module, 'p_dest_org_id_tbl', p_dest_org_id_tbl);
3131: PO_LOG.proc_begin(d_module, 'p_txn_flow_header_id_tbl',
3132: p_txn_flow_header_id_tbl);
3133: PO_LOG.proc_begin(d_module, 'p_dest_charge_account_id_tbl',
3134: p_dest_charge_account_id_tbl);
3135: PO_LOG.proc_begin(d_module, 'x_ship_to_ou_coa_id_tbl',

Line 3133: PO_LOG.proc_begin(d_module, 'p_dest_charge_account_id_tbl',

3129: IF (PO_LOG.d_proc) THEN
3130: PO_LOG.proc_begin(d_module, 'p_dest_org_id_tbl', p_dest_org_id_tbl);
3131: PO_LOG.proc_begin(d_module, 'p_txn_flow_header_id_tbl',
3132: p_txn_flow_header_id_tbl);
3133: PO_LOG.proc_begin(d_module, 'p_dest_charge_account_id_tbl',
3134: p_dest_charge_account_id_tbl);
3135: PO_LOG.proc_begin(d_module, 'x_ship_to_ou_coa_id_tbl',
3136: x_ship_to_ou_coa_id_tbl);
3137: END IF;

Line 3135: PO_LOG.proc_begin(d_module, 'x_ship_to_ou_coa_id_tbl',

3131: PO_LOG.proc_begin(d_module, 'p_txn_flow_header_id_tbl',
3132: p_txn_flow_header_id_tbl);
3133: PO_LOG.proc_begin(d_module, 'p_dest_charge_account_id_tbl',
3134: p_dest_charge_account_id_tbl);
3135: PO_LOG.proc_begin(d_module, 'x_ship_to_ou_coa_id_tbl',
3136: x_ship_to_ou_coa_id_tbl);
3137: END IF;
3138:
3139: -- query database to get derived result in batch mode

Line 3168: IF (PO_LOG.d_stmt) THEN

3164:
3165: -- set value back to x_wip_line_id_tbl
3166: FOR i IN 1..l_index_tbl.COUNT
3167: LOOP
3168: IF (PO_LOG.d_stmt) THEN
3169: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3170: PO_LOG.stmt(d_module, d_position, 'new ship_to ou coa id',
3171: l_result_tbl(i));
3172: END IF;

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

3165: -- set value back to x_wip_line_id_tbl
3166: FOR i IN 1..l_index_tbl.COUNT
3167: LOOP
3168: IF (PO_LOG.d_stmt) THEN
3169: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3170: PO_LOG.stmt(d_module, d_position, 'new ship_to ou coa id',
3171: l_result_tbl(i));
3172: END IF;
3173:

Line 3170: PO_LOG.stmt(d_module, d_position, 'new ship_to ou coa id',

3166: FOR i IN 1..l_index_tbl.COUNT
3167: LOOP
3168: IF (PO_LOG.d_stmt) THEN
3169: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3170: PO_LOG.stmt(d_module, d_position, 'new ship_to ou coa id',
3171: l_result_tbl(i));
3172: END IF;
3173:
3174: x_ship_to_ou_coa_id_tbl(l_index_tbl(i)) := l_result_tbl(i);

Line 3177: IF (PO_LOG.d_proc) THEN

3173:
3174: x_ship_to_ou_coa_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
3175: END LOOP;
3176:
3177: IF (PO_LOG.d_proc) THEN
3178: PO_LOG.proc_end (d_module);
3179: END IF;
3180:
3181: EXCEPTION

Line 3178: PO_LOG.proc_end (d_module);

3174: x_ship_to_ou_coa_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
3175: END LOOP;
3176:
3177: IF (PO_LOG.d_proc) THEN
3178: PO_LOG.proc_end (d_module);
3179: END IF;
3180:
3181: EXCEPTION
3182: WHEN OTHERS THEN

Line 3233: IF (PO_LOG.d_proc) THEN

3229: l_result_tbl PO_TBL_NUMBER;
3230: BEGIN
3231: d_position := 0;
3232:
3233: IF (PO_LOG.d_proc) THEN
3234: PO_LOG.proc_begin(d_module, 'p_bom_resource_code_tbl',
3235: p_bom_resource_code_tbl);
3236: PO_LOG.proc_begin(d_module, 'p_dest_org_id_tbl', p_dest_org_id_tbl);
3237: PO_LOG.proc_begin(d_module, 'x_bom_resource_id_tbl',

Line 3234: PO_LOG.proc_begin(d_module, 'p_bom_resource_code_tbl',

3230: BEGIN
3231: d_position := 0;
3232:
3233: IF (PO_LOG.d_proc) THEN
3234: PO_LOG.proc_begin(d_module, 'p_bom_resource_code_tbl',
3235: p_bom_resource_code_tbl);
3236: PO_LOG.proc_begin(d_module, 'p_dest_org_id_tbl', p_dest_org_id_tbl);
3237: PO_LOG.proc_begin(d_module, 'x_bom_resource_id_tbl',
3238: x_bom_resource_id_tbl);

Line 3236: PO_LOG.proc_begin(d_module, 'p_dest_org_id_tbl', p_dest_org_id_tbl);

3232:
3233: IF (PO_LOG.d_proc) THEN
3234: PO_LOG.proc_begin(d_module, 'p_bom_resource_code_tbl',
3235: p_bom_resource_code_tbl);
3236: PO_LOG.proc_begin(d_module, 'p_dest_org_id_tbl', p_dest_org_id_tbl);
3237: PO_LOG.proc_begin(d_module, 'x_bom_resource_id_tbl',
3238: x_bom_resource_id_tbl);
3239: END IF;
3240:

Line 3237: PO_LOG.proc_begin(d_module, 'x_bom_resource_id_tbl',

3233: IF (PO_LOG.d_proc) THEN
3234: PO_LOG.proc_begin(d_module, 'p_bom_resource_code_tbl',
3235: p_bom_resource_code_tbl);
3236: PO_LOG.proc_begin(d_module, 'p_dest_org_id_tbl', p_dest_org_id_tbl);
3237: PO_LOG.proc_begin(d_module, 'x_bom_resource_id_tbl',
3238: x_bom_resource_id_tbl);
3239: END IF;
3240:
3241: -- query database to get derived result in batch mode

Line 3266: IF (PO_LOG.d_stmt) THEN

3262:
3263: -- set value back to x_bom_resource_id_tbl
3264: FOR i IN 1..l_index_tbl.COUNT
3265: LOOP
3266: IF (PO_LOG.d_stmt) THEN
3267: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3268: PO_LOG.stmt(d_module, d_position, 'new bom resource id',
3269: l_result_tbl(i));
3270: END IF;

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

3263: -- set value back to x_bom_resource_id_tbl
3264: FOR i IN 1..l_index_tbl.COUNT
3265: LOOP
3266: IF (PO_LOG.d_stmt) THEN
3267: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3268: PO_LOG.stmt(d_module, d_position, 'new bom resource id',
3269: l_result_tbl(i));
3270: END IF;
3271:

Line 3268: PO_LOG.stmt(d_module, d_position, 'new bom resource id',

3264: FOR i IN 1..l_index_tbl.COUNT
3265: LOOP
3266: IF (PO_LOG.d_stmt) THEN
3267: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3268: PO_LOG.stmt(d_module, d_position, 'new bom resource id',
3269: l_result_tbl(i));
3270: END IF;
3271:
3272: x_bom_resource_id_tbl(l_index_tbl(i)) := l_result_tbl(i);

Line 3275: IF (PO_LOG.d_proc) THEN

3271:
3272: x_bom_resource_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
3273: END LOOP;
3274:
3275: IF (PO_LOG.d_proc) THEN
3276: PO_LOG.proc_end (d_module);
3277: END IF;
3278:
3279: EXCEPTION

Line 3276: PO_LOG.proc_end (d_module);

3272: x_bom_resource_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
3273: END LOOP;
3274:
3275: IF (PO_LOG.d_proc) THEN
3276: PO_LOG.proc_end (d_module);
3277: END IF;
3278:
3279: EXCEPTION
3280: WHEN OTHERS THEN

Line 3338: IF (PO_LOG.d_proc) THEN

3334: l_sql VARCHAR2(4000);
3335: BEGIN
3336: d_position := 0;
3337:
3338: IF (PO_LOG.d_proc) THEN
3339: PO_LOG.proc_begin (d_module);
3340: END IF;
3341:
3342: IF (p_account_segment1 IS NULL AND p_account_segment2 IS NULL AND

Line 3339: PO_LOG.proc_begin (d_module);

3335: BEGIN
3336: d_position := 0;
3337:
3338: IF (PO_LOG.d_proc) THEN
3339: PO_LOG.proc_begin (d_module);
3340: END IF;
3341:
3342: IF (p_account_segment1 IS NULL AND p_account_segment2 IS NULL AND
3343: p_account_segment3 IS NULL AND p_account_segment4 IS NULL AND

Line 3403: IF (PO_LOG.d_stmt) THEN

3399: add_account_segment_clause('segment30', p_account_segment30, l_sql);
3400:
3401: d_position := 20;
3402:
3403: IF (PO_LOG.d_stmt) THEN
3404: --PO_LOG.stmt(d_module, ' stmt to generate acct id: ' || l_sql);
3405: --< Shared Proc 14223789 Start >
3406: PO_LOG.stmt(d_module, d_position, ' stmt to generate acct id: ', l_sql);
3407: --< Shared Proc 14223789 End >

Line 3404: --PO_LOG.stmt(d_module, ' stmt to generate acct id: ' || l_sql);

3400:
3401: d_position := 20;
3402:
3403: IF (PO_LOG.d_stmt) THEN
3404: --PO_LOG.stmt(d_module, ' stmt to generate acct id: ' || l_sql);
3405: --< Shared Proc 14223789 Start >
3406: PO_LOG.stmt(d_module, d_position, ' stmt to generate acct id: ', l_sql);
3407: --< Shared Proc 14223789 End >
3408: END IF;

Line 3406: PO_LOG.stmt(d_module, d_position, ' stmt to generate acct id: ', l_sql);

3402:
3403: IF (PO_LOG.d_stmt) THEN
3404: --PO_LOG.stmt(d_module, ' stmt to generate acct id: ' || l_sql);
3405: --< Shared Proc 14223789 Start >
3406: PO_LOG.stmt(d_module, d_position, ' stmt to generate acct id: ', l_sql);
3407: --< Shared Proc 14223789 End >
3408: END IF;
3409:
3410: BEGIN

Line 3433: IF (PO_LOG.d_stmt) THEN

3429: p_account_segment27, p_account_segment28,
3430: p_account_segment29, p_account_segment30;
3431: EXCEPTION
3432: WHEN NO_DATA_FOUND THEN
3433: IF (PO_LOG.d_stmt) THEN
3434: --PO_LOG.stmt(d_module, 'cannot find account id based on segments provided');
3435: --< Shared Proc 14223789 Start >
3436: PO_LOG.stmt(d_module, d_position, 'cannot find account id based on segments provided');
3437: --< Shared Proc 14223789 End >

Line 3434: --PO_LOG.stmt(d_module, 'cannot find account id based on segments provided');

3430: p_account_segment29, p_account_segment30;
3431: EXCEPTION
3432: WHEN NO_DATA_FOUND THEN
3433: IF (PO_LOG.d_stmt) THEN
3434: --PO_LOG.stmt(d_module, 'cannot find account id based on segments provided');
3435: --< Shared Proc 14223789 Start >
3436: PO_LOG.stmt(d_module, d_position, 'cannot find account id based on segments provided');
3437: --< Shared Proc 14223789 End >
3438: END IF;

Line 3436: PO_LOG.stmt(d_module, d_position, 'cannot find account id based on segments provided');

3432: WHEN NO_DATA_FOUND THEN
3433: IF (PO_LOG.d_stmt) THEN
3434: --PO_LOG.stmt(d_module, 'cannot find account id based on segments provided');
3435: --< Shared Proc 14223789 Start >
3436: PO_LOG.stmt(d_module, d_position, 'cannot find account id based on segments provided');
3437: --< Shared Proc 14223789 End >
3438: END IF;
3439:
3440: x_account_id := NULL;

Line 3443: IF (PO_LOG.d_proc) THEN

3439:
3440: x_account_id := NULL;
3441: END;
3442:
3443: IF (PO_LOG.d_proc) THEN
3444: PO_LOG.proc_end (d_module);
3445: END IF;
3446:
3447: EXCEPTION

Line 3444: PO_LOG.proc_end (d_module);

3440: x_account_id := NULL;
3441: END;
3442:
3443: IF (PO_LOG.d_proc) THEN
3444: PO_LOG.proc_end (d_module);
3445: END IF;
3446:
3447: EXCEPTION
3448: WHEN OTHERS THEN

Line 3543: IF (PO_LOG.d_proc) THEN

3539: l_error_msg VARCHAR2(30);
3540: BEGIN
3541: d_position := 0;
3542:
3543: IF (PO_LOG.d_proc) THEN
3544: PO_LOG.proc_begin(d_module);
3545: END IF;
3546:
3547: IF (x_dists.project_id_tbl(p_index) IS NOT NULL OR

Line 3544: PO_LOG.proc_begin(d_module);

3540: BEGIN
3541: d_position := 0;
3542:
3543: IF (PO_LOG.d_proc) THEN
3544: PO_LOG.proc_begin(d_module);
3545: END IF;
3546:
3547: IF (x_dists.project_id_tbl(p_index) IS NOT NULL OR
3548: x_dists.project_tbl(p_index) IS NOT NULL OR

Line 3568: IF (PO_LOG.d_stmt) THEN

3564: ELSE
3565: l_error_msg := 'PO_SVC_PA_FPM_NOT_ENABLED';
3566: END IF;
3567:
3568: IF (PO_LOG.d_stmt) THEN
3569: PO_LOG.stmt(d_module, d_position, 'error_msg', l_error_msg);
3570: END IF;
3571:
3572: PO_PDOI_ERR_UTL.add_fatal_error

Line 3569: PO_LOG.stmt(d_module, d_position, 'error_msg', l_error_msg);

3565: l_error_msg := 'PO_SVC_PA_FPM_NOT_ENABLED';
3566: END IF;
3567:
3568: IF (PO_LOG.d_stmt) THEN
3569: PO_LOG.stmt(d_module, d_position, 'error_msg', l_error_msg);
3570: END IF;
3571:
3572: PO_PDOI_ERR_UTL.add_fatal_error
3573: (

Line 3598: IF (PO_LOG.d_stmt) THEN

3594: ELSE
3595: l_error_msg := 'PO_SVC_GMS_FPM_NOT_ENABLED';
3596: END IF;
3597:
3598: IF (PO_LOG.d_stmt) THEN
3599: PO_LOG.stmt(d_module, d_position, 'error_msg', l_error_msg);
3600: END IF;
3601:
3602: PO_PDOI_ERR_UTL.add_fatal_error

Line 3599: PO_LOG.stmt(d_module, d_position, 'error_msg', l_error_msg);

3595: l_error_msg := 'PO_SVC_GMS_FPM_NOT_ENABLED';
3596: END IF;
3597:
3598: IF (PO_LOG.d_stmt) THEN
3599: PO_LOG.stmt(d_module, d_position, 'error_msg', l_error_msg);
3600: END IF;
3601:
3602: PO_PDOI_ERR_UTL.add_fatal_error
3603: (

Line 3617: IF (PO_LOG.d_proc) THEN

3613:
3614: x_dists.error_flag_tbl(p_index) := FND_API.g_TRUE;
3615: END IF;
3616:
3617: IF (PO_LOG.d_proc) THEN
3618: PO_LOG.proc_end (d_module);
3619: END IF;
3620:
3621: EXCEPTION

Line 3618: PO_LOG.proc_end (d_module);

3614: x_dists.error_flag_tbl(p_index) := FND_API.g_TRUE;
3615: END IF;
3616:
3617: IF (PO_LOG.d_proc) THEN
3618: PO_LOG.proc_end (d_module);
3619: END IF;
3620:
3621: EXCEPTION
3622: WHEN OTHERS THEN

Line 3671: IF (PO_LOG.d_proc) THEN

3667: l_index NUMBER;
3668: BEGIN
3669: d_position := 0;
3670:
3671: IF (PO_LOG.d_proc) THEN
3672: PO_LOG.proc_begin(d_module);
3673:
3674: PO_LOG.proc_begin(d_module, 'p_derive_row_tbl.COUNT', p_derive_row_tbl.COUNT);
3675: l_index := p_derive_row_tbl.FIRST;

Line 3672: PO_LOG.proc_begin(d_module);

3668: BEGIN
3669: d_position := 0;
3670:
3671: IF (PO_LOG.d_proc) THEN
3672: PO_LOG.proc_begin(d_module);
3673:
3674: PO_LOG.proc_begin(d_module, 'p_derive_row_tbl.COUNT', p_derive_row_tbl.COUNT);
3675: l_index := p_derive_row_tbl.FIRST;
3676: WHILE (l_index IS NOT NULL)

Line 3674: PO_LOG.proc_begin(d_module, 'p_derive_row_tbl.COUNT', p_derive_row_tbl.COUNT);

3670:
3671: IF (PO_LOG.d_proc) THEN
3672: PO_LOG.proc_begin(d_module);
3673:
3674: PO_LOG.proc_begin(d_module, 'p_derive_row_tbl.COUNT', p_derive_row_tbl.COUNT);
3675: l_index := p_derive_row_tbl.FIRST;
3676: WHILE (l_index IS NOT NULL)
3677: LOOP
3678: PO_LOG.proc_begin(d_module, 'need to derive project info for line', l_index);

Line 3678: PO_LOG.proc_begin(d_module, 'need to derive project info for line', l_index);

3674: PO_LOG.proc_begin(d_module, 'p_derive_row_tbl.COUNT', p_derive_row_tbl.COUNT);
3675: l_index := p_derive_row_tbl.FIRST;
3676: WHILE (l_index IS NOT NULL)
3677: LOOP
3678: PO_LOG.proc_begin(d_module, 'need to derive project info for line', l_index);
3679: l_index := p_derive_row_tbl.NEXT(l_index);
3680: END LOOP;
3681: END IF;
3682:

Line 3737: IF (PO_LOG.d_proc) THEN

3733: p_derive_row_tbl => p_derive_row_tbl,
3734: x_expenditure_org_id_tbl => x_dists.expenditure_org_id_tbl
3735: );
3736:
3737: IF (PO_LOG.d_proc) THEN
3738: PO_LOG.proc_end (d_module);
3739: END IF;
3740:
3741: EXCEPTION

Line 3738: PO_LOG.proc_end (d_module);

3734: x_expenditure_org_id_tbl => x_dists.expenditure_org_id_tbl
3735: );
3736:
3737: IF (PO_LOG.d_proc) THEN
3738: PO_LOG.proc_end (d_module);
3739: END IF;
3740:
3741: EXCEPTION
3742: WHEN OTHERS THEN

Line 3802: IF (PO_LOG.d_proc) THEN

3798: l_result_tbl PO_TBL_NUMBER;
3799: BEGIN
3800: d_position := 0;
3801:
3802: IF (PO_LOG.d_proc) THEN
3803: PO_LOG.proc_begin(d_module, 'p_project_tbl', p_project_tbl);
3804: PO_LOG.proc_begin(d_module, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
3805: PO_LOG.proc_begin(d_module, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
3806: PO_LOG.proc_begin(d_module, 'p_ship_to_ou_id_tbl', p_ship_to_ou_id_tbl);

Line 3803: PO_LOG.proc_begin(d_module, 'p_project_tbl', p_project_tbl);

3799: BEGIN
3800: d_position := 0;
3801:
3802: IF (PO_LOG.d_proc) THEN
3803: PO_LOG.proc_begin(d_module, 'p_project_tbl', p_project_tbl);
3804: PO_LOG.proc_begin(d_module, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
3805: PO_LOG.proc_begin(d_module, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
3806: PO_LOG.proc_begin(d_module, 'p_ship_to_ou_id_tbl', p_ship_to_ou_id_tbl);
3807: PO_LOG.proc_begin(d_module, 'x_project_id_tbl', x_project_id_tbl);

Line 3804: PO_LOG.proc_begin(d_module, 'p_dest_type_code_tbl', p_dest_type_code_tbl);

3800: d_position := 0;
3801:
3802: IF (PO_LOG.d_proc) THEN
3803: PO_LOG.proc_begin(d_module, 'p_project_tbl', p_project_tbl);
3804: PO_LOG.proc_begin(d_module, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
3805: PO_LOG.proc_begin(d_module, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
3806: PO_LOG.proc_begin(d_module, 'p_ship_to_ou_id_tbl', p_ship_to_ou_id_tbl);
3807: PO_LOG.proc_begin(d_module, 'x_project_id_tbl', x_project_id_tbl);
3808: END IF;

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

3801:
3802: IF (PO_LOG.d_proc) THEN
3803: PO_LOG.proc_begin(d_module, 'p_project_tbl', p_project_tbl);
3804: PO_LOG.proc_begin(d_module, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
3805: PO_LOG.proc_begin(d_module, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
3806: PO_LOG.proc_begin(d_module, 'p_ship_to_ou_id_tbl', p_ship_to_ou_id_tbl);
3807: PO_LOG.proc_begin(d_module, 'x_project_id_tbl', x_project_id_tbl);
3808: END IF;
3809:

Line 3806: PO_LOG.proc_begin(d_module, 'p_ship_to_ou_id_tbl', p_ship_to_ou_id_tbl);

3802: IF (PO_LOG.d_proc) THEN
3803: PO_LOG.proc_begin(d_module, 'p_project_tbl', p_project_tbl);
3804: PO_LOG.proc_begin(d_module, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
3805: PO_LOG.proc_begin(d_module, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
3806: PO_LOG.proc_begin(d_module, 'p_ship_to_ou_id_tbl', p_ship_to_ou_id_tbl);
3807: PO_LOG.proc_begin(d_module, 'x_project_id_tbl', x_project_id_tbl);
3808: END IF;
3809:
3810: -- query database to get derived result in batch mode

Line 3807: PO_LOG.proc_begin(d_module, 'x_project_id_tbl', x_project_id_tbl);

3803: PO_LOG.proc_begin(d_module, 'p_project_tbl', p_project_tbl);
3804: PO_LOG.proc_begin(d_module, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
3805: PO_LOG.proc_begin(d_module, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
3806: PO_LOG.proc_begin(d_module, 'p_ship_to_ou_id_tbl', p_ship_to_ou_id_tbl);
3807: PO_LOG.proc_begin(d_module, 'x_project_id_tbl', x_project_id_tbl);
3808: END IF;
3809:
3810: -- query database to get derived result in batch mode
3811: -- query different views based on value of destination_type_code

Line 3851: IF (PO_LOG.d_stmt) THEN

3847:
3848: -- set value back to x_project_id_tbl
3849: FOR i IN 1..l_index_tbl.COUNT
3850: LOOP
3851: IF (PO_LOG.d_stmt) THEN
3852: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3853: PO_LOG.stmt(d_module, d_position, 'new project id',
3854: l_result_tbl(i));
3855: END IF;

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

3848: -- set value back to x_project_id_tbl
3849: FOR i IN 1..l_index_tbl.COUNT
3850: LOOP
3851: IF (PO_LOG.d_stmt) THEN
3852: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3853: PO_LOG.stmt(d_module, d_position, 'new project id',
3854: l_result_tbl(i));
3855: END IF;
3856:

Line 3853: PO_LOG.stmt(d_module, d_position, 'new project id',

3849: FOR i IN 1..l_index_tbl.COUNT
3850: LOOP
3851: IF (PO_LOG.d_stmt) THEN
3852: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3853: PO_LOG.stmt(d_module, d_position, 'new project id',
3854: l_result_tbl(i));
3855: END IF;
3856:
3857: x_project_id_tbl(l_index_tbl(i)) := l_result_tbl(i);

Line 3860: IF (PO_LOG.d_proc) THEN

3856:
3857: x_project_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
3858: END LOOP;
3859:
3860: IF (PO_LOG.d_proc) THEN
3861: PO_LOG.proc_end (d_module);
3862: END IF;
3863:
3864: EXCEPTION

Line 3861: PO_LOG.proc_end (d_module);

3857: x_project_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
3858: END LOOP;
3859:
3860: IF (PO_LOG.d_proc) THEN
3861: PO_LOG.proc_end (d_module);
3862: END IF;
3863:
3864: EXCEPTION
3865: WHEN OTHERS THEN

Line 3925: IF (PO_LOG.d_proc) THEN

3921: l_result_tbl PO_TBL_NUMBER;
3922: BEGIN
3923: d_position := 0;
3924:
3925: IF (PO_LOG.d_proc) THEN
3926: PO_LOG.proc_begin(d_module, 'p_task_tbl', p_task_tbl);
3927: PO_LOG.proc_begin(d_module, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
3928: PO_LOG.proc_begin(d_module, 'p_project_id_tbl', p_project_id_tbl);
3929: PO_LOG.proc_begin(d_module, 'p_ship_to_ou_id_tbl', p_ship_to_ou_id_tbl);

Line 3926: PO_LOG.proc_begin(d_module, 'p_task_tbl', p_task_tbl);

3922: BEGIN
3923: d_position := 0;
3924:
3925: IF (PO_LOG.d_proc) THEN
3926: PO_LOG.proc_begin(d_module, 'p_task_tbl', p_task_tbl);
3927: PO_LOG.proc_begin(d_module, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
3928: PO_LOG.proc_begin(d_module, 'p_project_id_tbl', p_project_id_tbl);
3929: PO_LOG.proc_begin(d_module, 'p_ship_to_ou_id_tbl', p_ship_to_ou_id_tbl);
3930: PO_LOG.proc_begin(d_module, 'x_task_id_tbl', x_task_id_tbl);

Line 3927: PO_LOG.proc_begin(d_module, 'p_dest_type_code_tbl', p_dest_type_code_tbl);

3923: d_position := 0;
3924:
3925: IF (PO_LOG.d_proc) THEN
3926: PO_LOG.proc_begin(d_module, 'p_task_tbl', p_task_tbl);
3927: PO_LOG.proc_begin(d_module, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
3928: PO_LOG.proc_begin(d_module, 'p_project_id_tbl', p_project_id_tbl);
3929: PO_LOG.proc_begin(d_module, 'p_ship_to_ou_id_tbl', p_ship_to_ou_id_tbl);
3930: PO_LOG.proc_begin(d_module, 'x_task_id_tbl', x_task_id_tbl);
3931: END IF;

Line 3928: PO_LOG.proc_begin(d_module, 'p_project_id_tbl', p_project_id_tbl);

3924:
3925: IF (PO_LOG.d_proc) THEN
3926: PO_LOG.proc_begin(d_module, 'p_task_tbl', p_task_tbl);
3927: PO_LOG.proc_begin(d_module, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
3928: PO_LOG.proc_begin(d_module, 'p_project_id_tbl', p_project_id_tbl);
3929: PO_LOG.proc_begin(d_module, 'p_ship_to_ou_id_tbl', p_ship_to_ou_id_tbl);
3930: PO_LOG.proc_begin(d_module, 'x_task_id_tbl', x_task_id_tbl);
3931: END IF;
3932:

Line 3929: PO_LOG.proc_begin(d_module, 'p_ship_to_ou_id_tbl', p_ship_to_ou_id_tbl);

3925: IF (PO_LOG.d_proc) THEN
3926: PO_LOG.proc_begin(d_module, 'p_task_tbl', p_task_tbl);
3927: PO_LOG.proc_begin(d_module, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
3928: PO_LOG.proc_begin(d_module, 'p_project_id_tbl', p_project_id_tbl);
3929: PO_LOG.proc_begin(d_module, 'p_ship_to_ou_id_tbl', p_ship_to_ou_id_tbl);
3930: PO_LOG.proc_begin(d_module, 'x_task_id_tbl', x_task_id_tbl);
3931: END IF;
3932:
3933: -- query database to get derived result in batch mode

Line 3930: PO_LOG.proc_begin(d_module, 'x_task_id_tbl', x_task_id_tbl);

3926: PO_LOG.proc_begin(d_module, 'p_task_tbl', p_task_tbl);
3927: PO_LOG.proc_begin(d_module, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
3928: PO_LOG.proc_begin(d_module, 'p_project_id_tbl', p_project_id_tbl);
3929: PO_LOG.proc_begin(d_module, 'p_ship_to_ou_id_tbl', p_ship_to_ou_id_tbl);
3930: PO_LOG.proc_begin(d_module, 'x_task_id_tbl', x_task_id_tbl);
3931: END IF;
3932:
3933: -- query database to get derived result in batch mode
3934: -- query different views based on value of destination_type_code

Line 3975: IF (PO_LOG.d_stmt) THEN

3971:
3972: -- set value back to x_task_id_tbl
3973: FOR i IN 1..l_index_tbl.COUNT
3974: LOOP
3975: IF (PO_LOG.d_stmt) THEN
3976: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3977: PO_LOG.stmt(d_module, d_position, 'new task id',
3978: l_result_tbl(i));
3979: END IF;

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

3972: -- set value back to x_task_id_tbl
3973: FOR i IN 1..l_index_tbl.COUNT
3974: LOOP
3975: IF (PO_LOG.d_stmt) THEN
3976: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3977: PO_LOG.stmt(d_module, d_position, 'new task id',
3978: l_result_tbl(i));
3979: END IF;
3980:

Line 3977: PO_LOG.stmt(d_module, d_position, 'new task id',

3973: FOR i IN 1..l_index_tbl.COUNT
3974: LOOP
3975: IF (PO_LOG.d_stmt) THEN
3976: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3977: PO_LOG.stmt(d_module, d_position, 'new task id',
3978: l_result_tbl(i));
3979: END IF;
3980:
3981: x_task_id_tbl(l_index_tbl(i)) := l_result_tbl(i);

Line 3984: IF (PO_LOG.d_proc) THEN

3980:
3981: x_task_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
3982: END LOOP;
3983:
3984: IF (PO_LOG.d_proc) THEN
3985: PO_LOG.proc_end (d_module);
3986: END IF;
3987:
3988: EXCEPTION

Line 3985: PO_LOG.proc_end (d_module);

3981: x_task_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
3982: END LOOP;
3983:
3984: IF (PO_LOG.d_proc) THEN
3985: PO_LOG.proc_end (d_module);
3986: END IF;
3987:
3988: EXCEPTION
3989: WHEN OTHERS THEN

Line 4043: IF (PO_LOG.d_proc) THEN

4039: l_result_tbl PO_TBL_VARCHAR30;
4040: BEGIN
4041: d_position := 0;
4042:
4043: IF (PO_LOG.d_proc) THEN
4044: PO_LOG.proc_begin(d_module, 'p_expenditure_tbl', p_expenditure_tbl);
4045: PO_LOG.proc_begin(d_module, 'p_project_id_tbl', p_project_id_tbl);
4046: PO_LOG.proc_begin(d_module, 'x_expenditure_type_tbl', x_expenditure_type_tbl);
4047: END IF;

Line 4044: PO_LOG.proc_begin(d_module, 'p_expenditure_tbl', p_expenditure_tbl);

4040: BEGIN
4041: d_position := 0;
4042:
4043: IF (PO_LOG.d_proc) THEN
4044: PO_LOG.proc_begin(d_module, 'p_expenditure_tbl', p_expenditure_tbl);
4045: PO_LOG.proc_begin(d_module, 'p_project_id_tbl', p_project_id_tbl);
4046: PO_LOG.proc_begin(d_module, 'x_expenditure_type_tbl', x_expenditure_type_tbl);
4047: END IF;
4048:

Line 4045: PO_LOG.proc_begin(d_module, 'p_project_id_tbl', p_project_id_tbl);

4041: d_position := 0;
4042:
4043: IF (PO_LOG.d_proc) THEN
4044: PO_LOG.proc_begin(d_module, 'p_expenditure_tbl', p_expenditure_tbl);
4045: PO_LOG.proc_begin(d_module, 'p_project_id_tbl', p_project_id_tbl);
4046: PO_LOG.proc_begin(d_module, 'x_expenditure_type_tbl', x_expenditure_type_tbl);
4047: END IF;
4048:
4049: -- query database to get derived result in batch mode

Line 4046: PO_LOG.proc_begin(d_module, 'x_expenditure_type_tbl', x_expenditure_type_tbl);

4042:
4043: IF (PO_LOG.d_proc) THEN
4044: PO_LOG.proc_begin(d_module, 'p_expenditure_tbl', p_expenditure_tbl);
4045: PO_LOG.proc_begin(d_module, 'p_project_id_tbl', p_project_id_tbl);
4046: PO_LOG.proc_begin(d_module, 'x_expenditure_type_tbl', x_expenditure_type_tbl);
4047: END IF;
4048:
4049: -- query database to get derived result in batch mode
4050: FORALL i IN INDICES OF p_derive_row_tbl

Line 4074: IF (PO_LOG.d_stmt) THEN

4070:
4071: -- set value back to x_expenditure_type_tbl
4072: FOR i IN 1..l_index_tbl.COUNT
4073: LOOP
4074: IF (PO_LOG.d_stmt) THEN
4075: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
4076: PO_LOG.stmt(d_module, d_position, 'new expenditure type',
4077: l_result_tbl(i));
4078: END IF;

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

4071: -- set value back to x_expenditure_type_tbl
4072: FOR i IN 1..l_index_tbl.COUNT
4073: LOOP
4074: IF (PO_LOG.d_stmt) THEN
4075: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
4076: PO_LOG.stmt(d_module, d_position, 'new expenditure type',
4077: l_result_tbl(i));
4078: END IF;
4079:

Line 4076: PO_LOG.stmt(d_module, d_position, 'new expenditure type',

4072: FOR i IN 1..l_index_tbl.COUNT
4073: LOOP
4074: IF (PO_LOG.d_stmt) THEN
4075: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
4076: PO_LOG.stmt(d_module, d_position, 'new expenditure type',
4077: l_result_tbl(i));
4078: END IF;
4079:
4080: x_expenditure_type_tbl(l_index_tbl(i)) := l_result_tbl(i);

Line 4083: IF (PO_LOG.d_proc) THEN

4079:
4080: x_expenditure_type_tbl(l_index_tbl(i)) := l_result_tbl(i);
4081: END LOOP;
4082:
4083: IF (PO_LOG.d_proc) THEN
4084: PO_LOG.proc_end (d_module);
4085: END IF;
4086:
4087: EXCEPTION

Line 4084: PO_LOG.proc_end (d_module);

4080: x_expenditure_type_tbl(l_index_tbl(i)) := l_result_tbl(i);
4081: END LOOP;
4082:
4083: IF (PO_LOG.d_proc) THEN
4084: PO_LOG.proc_end (d_module);
4085: END IF;
4086:
4087: EXCEPTION
4088: WHEN OTHERS THEN

Line 4143: IF (PO_LOG.d_proc) THEN

4139: l_result_tbl PO_TBL_NUMBER;
4140: BEGIN
4141: d_position := 0;
4142:
4143: IF (PO_LOG.d_proc) THEN
4144: PO_LOG.proc_begin(d_module, 'p_expenditure_org_tbl', p_expenditure_org_tbl);
4145: PO_LOG.proc_begin(d_module, 'p_project_id_tbl', p_project_id_tbl);
4146: PO_LOG.proc_begin(d_module, 'x_expenditure_org_id_tbl',
4147: x_expenditure_org_id_tbl);

Line 4144: PO_LOG.proc_begin(d_module, 'p_expenditure_org_tbl', p_expenditure_org_tbl);

4140: BEGIN
4141: d_position := 0;
4142:
4143: IF (PO_LOG.d_proc) THEN
4144: PO_LOG.proc_begin(d_module, 'p_expenditure_org_tbl', p_expenditure_org_tbl);
4145: PO_LOG.proc_begin(d_module, 'p_project_id_tbl', p_project_id_tbl);
4146: PO_LOG.proc_begin(d_module, 'x_expenditure_org_id_tbl',
4147: x_expenditure_org_id_tbl);
4148: END IF;

Line 4145: PO_LOG.proc_begin(d_module, 'p_project_id_tbl', p_project_id_tbl);

4141: d_position := 0;
4142:
4143: IF (PO_LOG.d_proc) THEN
4144: PO_LOG.proc_begin(d_module, 'p_expenditure_org_tbl', p_expenditure_org_tbl);
4145: PO_LOG.proc_begin(d_module, 'p_project_id_tbl', p_project_id_tbl);
4146: PO_LOG.proc_begin(d_module, 'x_expenditure_org_id_tbl',
4147: x_expenditure_org_id_tbl);
4148: END IF;
4149:

Line 4146: PO_LOG.proc_begin(d_module, 'x_expenditure_org_id_tbl',

4142:
4143: IF (PO_LOG.d_proc) THEN
4144: PO_LOG.proc_begin(d_module, 'p_expenditure_org_tbl', p_expenditure_org_tbl);
4145: PO_LOG.proc_begin(d_module, 'p_project_id_tbl', p_project_id_tbl);
4146: PO_LOG.proc_begin(d_module, 'x_expenditure_org_id_tbl',
4147: x_expenditure_org_id_tbl);
4148: END IF;
4149:
4150: -- query database to get derived result in batch mode

Line 4176: IF (PO_LOG.d_stmt) THEN

4172:
4173: -- set value back to x_expenditure_org_tbl
4174: FOR i IN 1..l_index_tbl.COUNT
4175: LOOP
4176: IF (PO_LOG.d_stmt) THEN
4177: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
4178: PO_LOG.stmt(d_module, d_position, 'new expenditure org id',
4179: l_result_tbl(i));
4180: END IF;

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

4173: -- set value back to x_expenditure_org_tbl
4174: FOR i IN 1..l_index_tbl.COUNT
4175: LOOP
4176: IF (PO_LOG.d_stmt) THEN
4177: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
4178: PO_LOG.stmt(d_module, d_position, 'new expenditure org id',
4179: l_result_tbl(i));
4180: END IF;
4181:

Line 4178: PO_LOG.stmt(d_module, d_position, 'new expenditure org id',

4174: FOR i IN 1..l_index_tbl.COUNT
4175: LOOP
4176: IF (PO_LOG.d_stmt) THEN
4177: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
4178: PO_LOG.stmt(d_module, d_position, 'new expenditure org id',
4179: l_result_tbl(i));
4180: END IF;
4181:
4182: x_expenditure_org_id_tbl(l_index_tbl(i)) := l_result_tbl(i);

Line 4185: IF (PO_LOG.d_proc) THEN

4181:
4182: x_expenditure_org_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
4183: END LOOP;
4184:
4185: IF (PO_LOG.d_proc) THEN
4186: PO_LOG.proc_end (d_module);
4187: END IF;
4188:
4189: EXCEPTION

Line 4186: PO_LOG.proc_end (d_module);

4182: x_expenditure_org_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
4183: END LOOP;
4184:
4185: IF (PO_LOG.d_proc) THEN
4186: PO_LOG.proc_end (d_module);
4187: END IF;
4188:
4189: EXCEPTION
4190: WHEN OTHERS THEN

Line 4239: IF (PO_LOG.d_proc) THEN

4235: l_result_tbl PO_TBL_VARCHAR1;
4236: BEGIN
4237: d_position := 0;
4238:
4239: IF (PO_LOG.d_proc) THEN
4240: PO_LOG.proc_begin(d_module, 'p_item_id_tbl', p_item_id_tbl);
4241: PO_LOG.proc_begin(d_module, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
4242: END IF;
4243:

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

4236: BEGIN
4237: d_position := 0;
4238:
4239: IF (PO_LOG.d_proc) THEN
4240: PO_LOG.proc_begin(d_module, 'p_item_id_tbl', p_item_id_tbl);
4241: PO_LOG.proc_begin(d_module, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
4242: END IF;
4243:
4244: -- initialize out parameter

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

4237: d_position := 0;
4238:
4239: IF (PO_LOG.d_proc) THEN
4240: PO_LOG.proc_begin(d_module, 'p_item_id_tbl', p_item_id_tbl);
4241: PO_LOG.proc_begin(d_module, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
4242: END IF;
4243:
4244: -- initialize out parameter
4245: x_item_status_tbl := PO_TBL_VARCHAR1();

Line 4271: IF (PO_LOG.d_stmt) THEN

4267:
4268: -- set value back to x_item_status_tbl
4269: FOR i IN 1..l_index_tbl.COUNT
4270: LOOP
4271: IF (PO_LOG.d_stmt) THEN
4272: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
4273: PO_LOG.stmt(d_module, d_position, 'item status',
4274: l_result_tbl(i));
4275: END IF;

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

4268: -- set value back to x_item_status_tbl
4269: FOR i IN 1..l_index_tbl.COUNT
4270: LOOP
4271: IF (PO_LOG.d_stmt) THEN
4272: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
4273: PO_LOG.stmt(d_module, d_position, 'item status',
4274: l_result_tbl(i));
4275: END IF;
4276:

Line 4273: PO_LOG.stmt(d_module, d_position, 'item status',

4269: FOR i IN 1..l_index_tbl.COUNT
4270: LOOP
4271: IF (PO_LOG.d_stmt) THEN
4272: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
4273: PO_LOG.stmt(d_module, d_position, 'item status',
4274: l_result_tbl(i));
4275: END IF;
4276:
4277: x_item_status_tbl(l_index_tbl(i)) := l_result_tbl(i);

Line 4280: IF (PO_LOG.d_proc) THEN

4276:
4277: x_item_status_tbl(l_index_tbl(i)) := l_result_tbl(i);
4278: END LOOP;
4279:
4280: IF (PO_LOG.d_proc) THEN
4281: PO_LOG.proc_end (d_module);
4282: END IF;
4283:
4284: EXCEPTION

Line 4281: PO_LOG.proc_end (d_module);

4277: x_item_status_tbl(l_index_tbl(i)) := l_result_tbl(i);
4278: END LOOP;
4279:
4280: IF (PO_LOG.d_proc) THEN
4281: PO_LOG.proc_end (d_module);
4282: END IF;
4283:
4284: EXCEPTION
4285: WHEN OTHERS THEN

Line 4351: IF (PO_LOG.d_proc) THEN

4347:
4348: BEGIN
4349: d_position := 0;
4350:
4351: IF (PO_LOG.d_proc) THEN
4352: PO_LOG.proc_begin(d_module, 'p_dest_type_code', p_dest_type_code);
4353: PO_LOG.proc_begin(d_module, 'p_dest_org_id', p_dest_org_id);
4354: PO_LOG.proc_begin(d_module, 'p_dest_subinventory', p_dest_subinventory);
4355: PO_LOG.proc_begin(d_module, 'p_item_id', p_item_id);

Line 4352: PO_LOG.proc_begin(d_module, 'p_dest_type_code', p_dest_type_code);

4348: BEGIN
4349: d_position := 0;
4350:
4351: IF (PO_LOG.d_proc) THEN
4352: PO_LOG.proc_begin(d_module, 'p_dest_type_code', p_dest_type_code);
4353: PO_LOG.proc_begin(d_module, 'p_dest_org_id', p_dest_org_id);
4354: PO_LOG.proc_begin(d_module, 'p_dest_subinventory', p_dest_subinventory);
4355: PO_LOG.proc_begin(d_module, 'p_item_id', p_item_id);
4356: PO_LOG.proc_begin(d_module, 'p_po_encumbrance_flag', p_po_encumbrance_flag);

Line 4353: PO_LOG.proc_begin(d_module, 'p_dest_org_id', p_dest_org_id);

4349: d_position := 0;
4350:
4351: IF (PO_LOG.d_proc) THEN
4352: PO_LOG.proc_begin(d_module, 'p_dest_type_code', p_dest_type_code);
4353: PO_LOG.proc_begin(d_module, 'p_dest_org_id', p_dest_org_id);
4354: PO_LOG.proc_begin(d_module, 'p_dest_subinventory', p_dest_subinventory);
4355: PO_LOG.proc_begin(d_module, 'p_item_id', p_item_id);
4356: PO_LOG.proc_begin(d_module, 'p_po_encumbrance_flag', p_po_encumbrance_flag);
4357: PO_LOG.proc_begin(d_module, 'p_charge_account_id', p_charge_account_id);

Line 4354: PO_LOG.proc_begin(d_module, 'p_dest_subinventory', p_dest_subinventory);

4350:
4351: IF (PO_LOG.d_proc) THEN
4352: PO_LOG.proc_begin(d_module, 'p_dest_type_code', p_dest_type_code);
4353: PO_LOG.proc_begin(d_module, 'p_dest_org_id', p_dest_org_id);
4354: PO_LOG.proc_begin(d_module, 'p_dest_subinventory', p_dest_subinventory);
4355: PO_LOG.proc_begin(d_module, 'p_item_id', p_item_id);
4356: PO_LOG.proc_begin(d_module, 'p_po_encumbrance_flag', p_po_encumbrance_flag);
4357: PO_LOG.proc_begin(d_module, 'p_charge_account_id', p_charge_account_id);
4358: PO_LOG.proc_begin(d_module, 'x_accrual_account_id', x_accrual_account_id);

Line 4355: PO_LOG.proc_begin(d_module, 'p_item_id', p_item_id);

4351: IF (PO_LOG.d_proc) THEN
4352: PO_LOG.proc_begin(d_module, 'p_dest_type_code', p_dest_type_code);
4353: PO_LOG.proc_begin(d_module, 'p_dest_org_id', p_dest_org_id);
4354: PO_LOG.proc_begin(d_module, 'p_dest_subinventory', p_dest_subinventory);
4355: PO_LOG.proc_begin(d_module, 'p_item_id', p_item_id);
4356: PO_LOG.proc_begin(d_module, 'p_po_encumbrance_flag', p_po_encumbrance_flag);
4357: PO_LOG.proc_begin(d_module, 'p_charge_account_id', p_charge_account_id);
4358: PO_LOG.proc_begin(d_module, 'x_accrual_account_id', x_accrual_account_id);
4359: PO_LOG.proc_begin(d_module, 'x_budget_account_id', x_budget_account_id);

Line 4356: PO_LOG.proc_begin(d_module, 'p_po_encumbrance_flag', p_po_encumbrance_flag);

4352: PO_LOG.proc_begin(d_module, 'p_dest_type_code', p_dest_type_code);
4353: PO_LOG.proc_begin(d_module, 'p_dest_org_id', p_dest_org_id);
4354: PO_LOG.proc_begin(d_module, 'p_dest_subinventory', p_dest_subinventory);
4355: PO_LOG.proc_begin(d_module, 'p_item_id', p_item_id);
4356: PO_LOG.proc_begin(d_module, 'p_po_encumbrance_flag', p_po_encumbrance_flag);
4357: PO_LOG.proc_begin(d_module, 'p_charge_account_id', p_charge_account_id);
4358: PO_LOG.proc_begin(d_module, 'x_accrual_account_id', x_accrual_account_id);
4359: PO_LOG.proc_begin(d_module, 'x_budget_account_id', x_budget_account_id);
4360: PO_LOG.proc_begin(d_module, 'x_variance_account_id', x_variance_account_id);

Line 4357: PO_LOG.proc_begin(d_module, 'p_charge_account_id', p_charge_account_id);

4353: PO_LOG.proc_begin(d_module, 'p_dest_org_id', p_dest_org_id);
4354: PO_LOG.proc_begin(d_module, 'p_dest_subinventory', p_dest_subinventory);
4355: PO_LOG.proc_begin(d_module, 'p_item_id', p_item_id);
4356: PO_LOG.proc_begin(d_module, 'p_po_encumbrance_flag', p_po_encumbrance_flag);
4357: PO_LOG.proc_begin(d_module, 'p_charge_account_id', p_charge_account_id);
4358: PO_LOG.proc_begin(d_module, 'x_accrual_account_id', x_accrual_account_id);
4359: PO_LOG.proc_begin(d_module, 'x_budget_account_id', x_budget_account_id);
4360: PO_LOG.proc_begin(d_module, 'x_variance_account_id', x_variance_account_id);
4361: END IF;

Line 4358: PO_LOG.proc_begin(d_module, 'x_accrual_account_id', x_accrual_account_id);

4354: PO_LOG.proc_begin(d_module, 'p_dest_subinventory', p_dest_subinventory);
4355: PO_LOG.proc_begin(d_module, 'p_item_id', p_item_id);
4356: PO_LOG.proc_begin(d_module, 'p_po_encumbrance_flag', p_po_encumbrance_flag);
4357: PO_LOG.proc_begin(d_module, 'p_charge_account_id', p_charge_account_id);
4358: PO_LOG.proc_begin(d_module, 'x_accrual_account_id', x_accrual_account_id);
4359: PO_LOG.proc_begin(d_module, 'x_budget_account_id', x_budget_account_id);
4360: PO_LOG.proc_begin(d_module, 'x_variance_account_id', x_variance_account_id);
4361: END IF;
4362:

Line 4359: PO_LOG.proc_begin(d_module, 'x_budget_account_id', x_budget_account_id);

4355: PO_LOG.proc_begin(d_module, 'p_item_id', p_item_id);
4356: PO_LOG.proc_begin(d_module, 'p_po_encumbrance_flag', p_po_encumbrance_flag);
4357: PO_LOG.proc_begin(d_module, 'p_charge_account_id', p_charge_account_id);
4358: PO_LOG.proc_begin(d_module, 'x_accrual_account_id', x_accrual_account_id);
4359: PO_LOG.proc_begin(d_module, 'x_budget_account_id', x_budget_account_id);
4360: PO_LOG.proc_begin(d_module, 'x_variance_account_id', x_variance_account_id);
4361: END IF;
4362:
4363: IF (p_dest_type_code = 'EXPENSE') THEN

Line 4360: PO_LOG.proc_begin(d_module, 'x_variance_account_id', x_variance_account_id);

4356: PO_LOG.proc_begin(d_module, 'p_po_encumbrance_flag', p_po_encumbrance_flag);
4357: PO_LOG.proc_begin(d_module, 'p_charge_account_id', p_charge_account_id);
4358: PO_LOG.proc_begin(d_module, 'x_accrual_account_id', x_accrual_account_id);
4359: PO_LOG.proc_begin(d_module, 'x_budget_account_id', x_budget_account_id);
4360: PO_LOG.proc_begin(d_module, 'x_variance_account_id', x_variance_account_id);
4361: END IF;
4362:
4363: IF (p_dest_type_code = 'EXPENSE') THEN
4364:

Line 4502: IF (PO_LOG.d_proc) THEN

4498: END IF;
4499: END IF;
4500: END IF;
4501:
4502: IF (PO_LOG.d_proc) THEN
4503: PO_LOG.proc_end (d_module);
4504: END IF;
4505:
4506: EXCEPTION

Line 4503: PO_LOG.proc_end (d_module);

4499: END IF;
4500: END IF;
4501:
4502: IF (PO_LOG.d_proc) THEN
4503: PO_LOG.proc_end (d_module);
4504: END IF;
4505:
4506: EXCEPTION
4507: WHEN OTHERS THEN

Line 4549: IF (PO_LOG.d_proc) THEN

4545:
4546: BEGIN
4547: d_position := 0;
4548:
4549: IF (PO_LOG.d_proc) THEN
4550: PO_LOG.proc_begin(d_module);
4551: END IF;
4552:
4553: FOR i IN 1 .. x_dists.intf_dist_id_tbl.COUNT LOOP

Line 4550: PO_LOG.proc_begin(d_module);

4546: BEGIN
4547: d_position := 0;
4548:
4549: IF (PO_LOG.d_proc) THEN
4550: PO_LOG.proc_begin(d_module);
4551: END IF;
4552:
4553: FOR i IN 1 .. x_dists.intf_dist_id_tbl.COUNT LOOP
4554: l_index_tbl(x_dists.intf_dist_id_tbl(i)) := i;

Line 4561: IF (PO_LOG.d_stmt) THEN

4557: d_position := 10;
4558:
4559: FOR i IN 1 .. x_results.entity_id.COUNT LOOP
4560: IF x_results.result_type(i) = po_validations.c_result_type_failure THEN
4561: IF (PO_LOG.d_stmt) THEN
4562: PO_LOG.stmt(d_module, d_position, 'error on index',
4563: l_index_tbl(x_results.entity_id(i)));
4564: END IF;
4565:

Line 4562: PO_LOG.stmt(d_module, d_position, 'error on index',

4558:
4559: FOR i IN 1 .. x_results.entity_id.COUNT LOOP
4560: IF x_results.result_type(i) = po_validations.c_result_type_failure THEN
4561: IF (PO_LOG.d_stmt) THEN
4562: PO_LOG.stmt(d_module, d_position, 'error on index',
4563: l_index_tbl(x_results.entity_id(i)));
4564: END IF;
4565:
4566: x_dists.error_flag_tbl(l_index_tbl(x_results.entity_id(i))) := FND_API.g_TRUE;

Line 4570: IF (PO_LOG.d_proc) THEN

4566: x_dists.error_flag_tbl(l_index_tbl(x_results.entity_id(i))) := FND_API.g_TRUE;
4567: END IF;
4568: END LOOP;
4569:
4570: IF (PO_LOG.d_proc) THEN
4571: PO_LOG.proc_end (d_module);
4572: END IF;
4573:
4574: EXCEPTION

Line 4571: PO_LOG.proc_end (d_module);

4567: END IF;
4568: END LOOP;
4569:
4570: IF (PO_LOG.d_proc) THEN
4571: PO_LOG.proc_end (d_module);
4572: END IF;
4573:
4574: EXCEPTION
4575: WHEN OTHERS THEN