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.18.12010000.2 2008/12/18 13:18:43 ggandhi 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 224: IF (PO_LOG.d_proc) THEN

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

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

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

Line 442: IF (PO_LOG.d_proc) THEN

438: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
439: AND intf_dists.interface_distribution_id > p_max_intf_dist_id
440: ORDER BY intf_dists.interface_distribution_id;
441:
442: IF (PO_LOG.d_proc) THEN
443: PO_LOG.proc_end (d_module);
444: END IF;
445:
446: EXCEPTION

Line 443: PO_LOG.proc_end (d_module);

439: AND intf_dists.interface_distribution_id > p_max_intf_dist_id
440: ORDER BY intf_dists.interface_distribution_id;
441:
442: IF (PO_LOG.d_proc) THEN
443: PO_LOG.proc_end (d_module);
444: END IF;
445:
446: EXCEPTION
447: WHEN OTHERS THEN

Line 484: IF (PO_LOG.d_proc) THEN

480:
481: BEGIN
482: d_position := 0;
483:
484: IF (PO_LOG.d_proc) THEN
485: PO_LOG.proc_begin(d_module);
486: END IF;
487:
488: FETCH x_dists_csr BULK COLLECT INTO

Line 485: PO_LOG.proc_begin(d_module);

481: BEGIN
482: d_position := 0;
483:
484: IF (PO_LOG.d_proc) THEN
485: PO_LOG.proc_begin(d_module);
486: END IF;
487:
488: FETCH x_dists_csr BULK COLLECT INTO
489: x_dists.intf_dist_id_tbl,

Line 680: IF (PO_LOG.d_proc) THEN

676: x_dists.ship_to_ou_coa_id_tbl,
677: x_dists.award_set_id_tbl -- bug5201306
678: LIMIT PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE;
679:
680: IF (PO_LOG.d_proc) THEN
681: PO_LOG.proc_end (d_module);
682: END IF;
683:
684: EXCEPTION

Line 681: PO_LOG.proc_end (d_module);

677: x_dists.award_set_id_tbl -- bug5201306
678: LIMIT PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE;
679:
680: IF (PO_LOG.d_proc) THEN
681: PO_LOG.proc_end (d_module);
682: END IF;
683:
684: EXCEPTION
685: WHEN OTHERS THEN

Line 746: IF (PO_LOG.d_proc) THEN

742: l_return_status VARCHAR2(1);
743: BEGIN
744: d_position := 0;
745:
746: IF (PO_LOG.d_proc) THEN
747: PO_LOG.proc_begin(d_module);
748: END IF;
749:
750: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_DIST_DERIVE);

Line 747: PO_LOG.proc_begin(d_module);

743: BEGIN
744: d_position := 0;
745:
746: IF (PO_LOG.d_proc) THEN
747: PO_LOG.proc_begin(d_module);
748: END IF;
749:
750: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_DIST_DERIVE);
751:

Line 877: IF (PO_LOG.d_stmt) THEN

873: -- derive logic for account information
874: -- the logic will be performed on row base
875: FOR i IN 1..x_dists.rec_count
876: LOOP
877: IF (PO_LOG.d_stmt) THEN
878: PO_LOG.stmt(d_module, d_position, 'derive index', i);
879: END IF;
880:
881: -- derive charge_account_id

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

874: -- the logic will be performed on row base
875: FOR i IN 1..x_dists.rec_count
876: LOOP
877: IF (PO_LOG.d_stmt) THEN
878: PO_LOG.stmt(d_module, d_position, 'derive index', i);
879: END IF;
880:
881: -- derive charge_account_id
882: IF (x_dists.charge_account_id_tbl(i) IS NULL AND

Line 921: IF (PO_LOG.d_stmt) THEN

917: p_account_segment30 => x_dists.account_segment30_tbl(i),
918: x_account_id => x_dists.charge_account_id_tbl(i)
919: );
920:
921: IF (PO_LOG.d_stmt) THEN
922: PO_LOG.stmt(d_module, d_position, 'derived charge account id',
923: x_dists.charge_account_id_tbl(i));
924: END IF;
925: END IF;

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

918: x_account_id => x_dists.charge_account_id_tbl(i)
919: );
920:
921: IF (PO_LOG.d_stmt) THEN
922: PO_LOG.stmt(d_module, d_position, 'derived charge account id',
923: x_dists.charge_account_id_tbl(i));
924: END IF;
925: END IF;
926:

Line 969: IF (PO_LOG.d_stmt) THEN

965: p_account_segment30 => x_dists.account_segment30_tbl(i),
966: x_account_id => x_dists.dest_charge_account_id_tbl(i)
967: );
968:
969: IF (PO_LOG.d_stmt) THEN
970: PO_LOG.stmt(d_module, d_position, 'derived dest charge account id',
971: x_dists.dest_charge_account_id_tbl(i));
972: END IF;
973: END IF;

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

966: x_account_id => x_dists.dest_charge_account_id_tbl(i)
967: );
968:
969: IF (PO_LOG.d_stmt) THEN
970: PO_LOG.stmt(d_module, d_position, 'derived dest charge account id',
971: x_dists.dest_charge_account_id_tbl(i));
972: END IF;
973: END IF;
974:

Line 987: IF (PO_LOG.d_stmt) THEN

983: PO_PDOI_PARAMS.g_product.project_cwk_installed = FND_API.g_FALSE) THEN
984:
985: d_position := 120;
986:
987: IF (PO_LOG.d_stmt) THEN
988: PO_LOG.stmt(d_module, d_position, 'all project info need to be empty');
989: END IF;
990:
991: -- validate all project fields should be null

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

984:
985: d_position := 120;
986:
987: IF (PO_LOG.d_stmt) THEN
988: PO_LOG.stmt(d_module, d_position, 'all project info need to be empty');
989: END IF;
990:
991: -- validate all project fields should be null
992: validate_null_for_project_info

Line 1008: IF (PO_LOG.d_stmt) THEN

1004:
1005: -- derive project fields if enabled
1006: IF (PO_PDOI_PARAMS.g_product.pa_installed = FND_API.g_TRUE AND
1007: x_dists.project_accounting_context_tbl(i) = 'Y') THEN
1008: IF (PO_LOG.d_stmt) THEN
1009: PO_LOG.stmt(d_module, d_position, 'project info needs to be derived');
1010: END IF;
1011:
1012: -- mark the line to do the derivation logic later

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

1005: -- derive project fields if enabled
1006: IF (PO_PDOI_PARAMS.g_product.pa_installed = FND_API.g_TRUE AND
1007: x_dists.project_accounting_context_tbl(i) = 'Y') THEN
1008: IF (PO_LOG.d_stmt) THEN
1009: PO_LOG.stmt(d_module, d_position, 'project info needs to be derived');
1010: END IF;
1011:
1012: -- mark the line to do the derivation logic later
1013: l_derive_project_info_row_tbl(i) := i;

Line 1025: IF (PO_LOG.d_stmt) THEN

1021: OR
1022: (x_dists.project_accounting_context_tbl(i) <> 'Y')
1023: OR
1024: (x_dists.dest_type_code_tbl(i) <> 'EXPENSE') THEN
1025: IF (PO_LOG.d_stmt) THEN
1026: PO_LOG.stmt(d_module, d_position, 'set gms_txn_required_flag to N');
1027: END IF;
1028:
1029: x_dists.gms_txn_required_flag_tbl(i) := 'N';

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

1022: (x_dists.project_accounting_context_tbl(i) <> 'Y')
1023: OR
1024: (x_dists.dest_type_code_tbl(i) <> 'EXPENSE') THEN
1025: IF (PO_LOG.d_stmt) THEN
1026: PO_LOG.stmt(d_module, d_position, 'set gms_txn_required_flag to N');
1027: END IF;
1028:
1029: x_dists.gms_txn_required_flag_tbl(i) := 'N';
1030: x_dists.award_id_tbl(i) := NULL;

Line 1032: IF (PO_LOG.d_stmt) THEN

1028:
1029: x_dists.gms_txn_required_flag_tbl(i) := 'N';
1030: x_dists.award_id_tbl(i) := NULL;
1031: ELSE
1032: IF (PO_LOG.d_stmt) THEN
1033: PO_LOG.stmt(d_module, d_position, 'set gms_txn_required_flag to Y');
1034: END IF;
1035:
1036: x_dists.gms_txn_required_flag_tbl(i) := 'Y';

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

1029: x_dists.gms_txn_required_flag_tbl(i) := 'N';
1030: x_dists.award_id_tbl(i) := NULL;
1031: ELSE
1032: IF (PO_LOG.d_stmt) THEN
1033: PO_LOG.stmt(d_module, d_position, 'set gms_txn_required_flag to Y');
1034: END IF;
1035:
1036: x_dists.gms_txn_required_flag_tbl(i) := 'Y';
1037: END IF;

Line 1061: IF (PO_LOG.d_stmt) THEN

1057: x_return_status => l_return_status,
1058: p_award_number => x_dists.award_num_tbl(i)
1059: );
1060:
1061: IF (PO_LOG.d_stmt) THEN
1062: PO_LOG.stmt(d_module, d_position, 'l_return_status', l_return_status);
1063: PO_LOG.stmt(d_module, d_position, 'award_id', x_dists.award_id_tbl(i));
1064: END IF;
1065:

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

1058: p_award_number => x_dists.award_num_tbl(i)
1059: );
1060:
1061: IF (PO_LOG.d_stmt) THEN
1062: PO_LOG.stmt(d_module, d_position, 'l_return_status', l_return_status);
1063: PO_LOG.stmt(d_module, d_position, 'award_id', x_dists.award_id_tbl(i));
1064: END IF;
1065:
1066: -- check return status to see whether derivation is successful

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

1059: );
1060:
1061: IF (PO_LOG.d_stmt) THEN
1062: PO_LOG.stmt(d_module, d_position, 'l_return_status', l_return_status);
1063: PO_LOG.stmt(d_module, d_position, 'award_id', x_dists.award_id_tbl(i));
1064: END IF;
1065:
1066: -- check return status to see whether derivation is successful
1067: IF (l_return_status <> FND_API.g_RET_STS_SUCCESS) THEN

Line 1106: IF (PO_LOG.d_stmt) THEN

1102:
1103: -- handle all derivation errors
1104: FOR i IN 1..x_dists.rec_count
1105: LOOP
1106: IF (PO_LOG.d_stmt) THEN
1107: PO_LOG.stmt(d_module, d_position, 'index', i);
1108: END IF;
1109:
1110: -- derivation error for deliver_to_location_id

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

1103: -- handle all derivation errors
1104: FOR i IN 1..x_dists.rec_count
1105: LOOP
1106: IF (PO_LOG.d_stmt) THEN
1107: PO_LOG.stmt(d_module, d_position, 'index', i);
1108: END IF;
1109:
1110: -- derivation error for deliver_to_location_id
1111: IF (x_dists.deliver_to_loc_tbl(i) IS NOT NULL AND

Line 1113: IF (PO_LOG.d_stmt) THEN

1109:
1110: -- derivation error for deliver_to_location_id
1111: IF (x_dists.deliver_to_loc_tbl(i) IS NOT NULL AND
1112: x_dists.deliver_to_loc_id_tbl(i) IS NULL) THEN
1113: IF (PO_LOG.d_stmt) THEN
1114: PO_LOG.stmt(d_module, d_position, 'deliver to loc id derivation failed');
1115: PO_LOG.stmt(d_module, d_position, 'deliver to loc', x_dists.deliver_to_loc_tbl(i));
1116: END IF;
1117:

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

1110: -- derivation error for deliver_to_location_id
1111: IF (x_dists.deliver_to_loc_tbl(i) IS NOT NULL AND
1112: x_dists.deliver_to_loc_id_tbl(i) IS NULL) THEN
1113: IF (PO_LOG.d_stmt) THEN
1114: PO_LOG.stmt(d_module, d_position, 'deliver to loc id derivation failed');
1115: PO_LOG.stmt(d_module, d_position, 'deliver to loc', x_dists.deliver_to_loc_tbl(i));
1116: END IF;
1117:
1118: PO_PDOI_ERR_UTL.add_fatal_error

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

1111: IF (x_dists.deliver_to_loc_tbl(i) IS NOT NULL AND
1112: x_dists.deliver_to_loc_id_tbl(i) IS NULL) THEN
1113: IF (PO_LOG.d_stmt) THEN
1114: PO_LOG.stmt(d_module, d_position, 'deliver to loc id derivation failed');
1115: PO_LOG.stmt(d_module, d_position, 'deliver to loc', x_dists.deliver_to_loc_tbl(i));
1116: END IF;
1117:
1118: PO_PDOI_ERR_UTL.add_fatal_error
1119: (

Line 1138: IF (PO_LOG.d_stmt) THEN

1134:
1135: -- derivation error for deliver_to_person_id
1136: IF (x_dists.deliver_to_person_name_tbl(i) IS NOT NULL AND
1137: x_dists.deliver_to_person_id_tbl(i) IS NULL) THEN
1138: IF (PO_LOG.d_stmt) THEN
1139: PO_LOG.stmt(d_module, d_position, 'deliver to person id derivation failed');
1140: PO_LOG.stmt(d_module, d_position, 'deliver to person name',
1141: x_dists.deliver_to_person_name_tbl(i));
1142: END IF;

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

1135: -- derivation error for deliver_to_person_id
1136: IF (x_dists.deliver_to_person_name_tbl(i) IS NOT NULL AND
1137: x_dists.deliver_to_person_id_tbl(i) IS NULL) THEN
1138: IF (PO_LOG.d_stmt) THEN
1139: PO_LOG.stmt(d_module, d_position, 'deliver to person id derivation failed');
1140: PO_LOG.stmt(d_module, d_position, 'deliver to person name',
1141: x_dists.deliver_to_person_name_tbl(i));
1142: END IF;
1143:

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

1136: IF (x_dists.deliver_to_person_name_tbl(i) IS NOT NULL AND
1137: x_dists.deliver_to_person_id_tbl(i) IS NULL) THEN
1138: IF (PO_LOG.d_stmt) THEN
1139: PO_LOG.stmt(d_module, d_position, 'deliver to person id derivation failed');
1140: PO_LOG.stmt(d_module, d_position, 'deliver to person name',
1141: x_dists.deliver_to_person_name_tbl(i));
1142: END IF;
1143:
1144: PO_PDOI_ERR_UTL.add_fatal_error

Line 1164: IF (PO_LOG.d_stmt) THEN

1160:
1161: -- derivation error for destination_type_code
1162: IF (x_dists.dest_type_tbl(i) IS NOT NULL AND
1163: x_dists.dest_type_code_tbl(i) IS NULL) THEN
1164: IF (PO_LOG.d_stmt) THEN
1165: PO_LOG.stmt(d_module, d_position, 'dest type code derivation failed');
1166: PO_LOG.stmt(d_module, d_position, 'dest type',
1167: x_dists.dest_type_tbl(i));
1168: END IF;

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

1161: -- derivation error for destination_type_code
1162: IF (x_dists.dest_type_tbl(i) IS NOT NULL AND
1163: x_dists.dest_type_code_tbl(i) IS NULL) THEN
1164: IF (PO_LOG.d_stmt) THEN
1165: PO_LOG.stmt(d_module, d_position, 'dest type code derivation failed');
1166: PO_LOG.stmt(d_module, d_position, 'dest type',
1167: x_dists.dest_type_tbl(i));
1168: END IF;
1169:

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

1162: IF (x_dists.dest_type_tbl(i) IS NOT NULL AND
1163: x_dists.dest_type_code_tbl(i) IS NULL) THEN
1164: IF (PO_LOG.d_stmt) THEN
1165: PO_LOG.stmt(d_module, d_position, 'dest type code derivation failed');
1166: PO_LOG.stmt(d_module, d_position, 'dest type',
1167: x_dists.dest_type_tbl(i));
1168: END IF;
1169:
1170: PO_PDOI_ERR_UTL.add_fatal_error

Line 1190: IF (PO_LOG.d_stmt) THEN

1186:
1187: -- derivation error for destination_organization_id
1188: IF (x_dists.dest_org_tbl(i) IS NOT NULL AND
1189: x_dists.dest_org_id_tbl(i) IS NULL) THEN
1190: IF (PO_LOG.d_stmt) THEN
1191: PO_LOG.stmt(d_module, d_position, 'dest org id derivation failed');
1192: PO_LOG.stmt(d_module, d_position, 'dest org',
1193: x_dists.dest_org_tbl(i));
1194: END IF;

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

1187: -- derivation error for destination_organization_id
1188: IF (x_dists.dest_org_tbl(i) IS NOT NULL AND
1189: x_dists.dest_org_id_tbl(i) IS NULL) THEN
1190: IF (PO_LOG.d_stmt) THEN
1191: PO_LOG.stmt(d_module, d_position, 'dest org id derivation failed');
1192: PO_LOG.stmt(d_module, d_position, 'dest org',
1193: x_dists.dest_org_tbl(i));
1194: END IF;
1195:

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

1188: IF (x_dists.dest_org_tbl(i) IS NOT NULL AND
1189: x_dists.dest_org_id_tbl(i) IS NULL) THEN
1190: IF (PO_LOG.d_stmt) THEN
1191: PO_LOG.stmt(d_module, d_position, 'dest org id derivation failed');
1192: PO_LOG.stmt(d_module, d_position, 'dest org',
1193: x_dists.dest_org_tbl(i));
1194: END IF;
1195:
1196: PO_PDOI_ERR_UTL.add_fatal_error

Line 1218: IF (PO_LOG.d_stmt) THEN

1214: x_dists.dest_type_code_tbl(i) = 'SHOP FLOOR') THEN
1215: -- derivation error for wip_entity_id
1216: IF (x_dists.wip_entity_tbl(i) IS NOT NULL AND
1217: x_dists.wip_entity_id_tbl(i) IS NULL) THEN
1218: IF (PO_LOG.d_stmt) THEN
1219: PO_LOG.stmt(d_module, d_position, 'wip entity id derivation failed');
1220: PO_LOG.stmt(d_module, d_position, 'wip entity',
1221: x_dists.wip_entity_tbl(i));
1222: END IF;

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

1215: -- derivation error for wip_entity_id
1216: IF (x_dists.wip_entity_tbl(i) IS NOT NULL AND
1217: x_dists.wip_entity_id_tbl(i) IS NULL) THEN
1218: IF (PO_LOG.d_stmt) THEN
1219: PO_LOG.stmt(d_module, d_position, 'wip entity id derivation failed');
1220: PO_LOG.stmt(d_module, d_position, 'wip entity',
1221: x_dists.wip_entity_tbl(i));
1222: END IF;
1223:

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

1216: IF (x_dists.wip_entity_tbl(i) IS NOT NULL AND
1217: x_dists.wip_entity_id_tbl(i) IS NULL) THEN
1218: IF (PO_LOG.d_stmt) THEN
1219: PO_LOG.stmt(d_module, d_position, 'wip entity id derivation failed');
1220: PO_LOG.stmt(d_module, d_position, 'wip entity',
1221: x_dists.wip_entity_tbl(i));
1222: END IF;
1223:
1224: PO_PDOI_ERR_UTL.add_fatal_error

Line 1244: IF (PO_LOG.d_stmt) THEN

1240:
1241: -- derivation error for wip_line_id
1242: IF (x_dists.wip_line_code_tbl(i) IS NOT NULL AND
1243: x_dists.wip_line_id_tbl(i) IS NULL) THEN
1244: IF (PO_LOG.d_stmt) THEN
1245: PO_LOG.stmt(d_module, d_position, 'wip line id derivation failed');
1246: PO_LOG.stmt(d_module, d_position, 'wip line code',
1247: x_dists.wip_line_code_tbl(i));
1248: END IF;

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

1241: -- derivation error for wip_line_id
1242: IF (x_dists.wip_line_code_tbl(i) IS NOT NULL AND
1243: x_dists.wip_line_id_tbl(i) IS NULL) THEN
1244: IF (PO_LOG.d_stmt) THEN
1245: PO_LOG.stmt(d_module, d_position, 'wip line id derivation failed');
1246: PO_LOG.stmt(d_module, d_position, 'wip line code',
1247: x_dists.wip_line_code_tbl(i));
1248: END IF;
1249:

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

1242: IF (x_dists.wip_line_code_tbl(i) IS NOT NULL AND
1243: x_dists.wip_line_id_tbl(i) IS NULL) THEN
1244: IF (PO_LOG.d_stmt) THEN
1245: PO_LOG.stmt(d_module, d_position, 'wip line id derivation failed');
1246: PO_LOG.stmt(d_module, d_position, 'wip line code',
1247: x_dists.wip_line_code_tbl(i));
1248: END IF;
1249:
1250: PO_PDOI_ERR_UTL.add_fatal_error

Line 1271: IF (PO_LOG.d_stmt) THEN

1267:
1268: -- derivation error for bom_resource_id
1269: IF (x_dists.bom_resource_code_tbl(i) IS NOT NULL AND
1270: x_dists.bom_resource_id_tbl(i) IS NULL) THEN
1271: IF (PO_LOG.d_stmt) THEN
1272: PO_LOG.stmt(d_module, d_position, 'bom resource id derivation failed');
1273: PO_LOG.stmt(d_module, d_position, 'bom resource code',
1274: x_dists.bom_resource_code_tbl(i));
1275: END IF;

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

1268: -- derivation error for bom_resource_id
1269: IF (x_dists.bom_resource_code_tbl(i) IS NOT NULL AND
1270: x_dists.bom_resource_id_tbl(i) IS NULL) THEN
1271: IF (PO_LOG.d_stmt) THEN
1272: PO_LOG.stmt(d_module, d_position, 'bom resource id derivation failed');
1273: PO_LOG.stmt(d_module, d_position, 'bom resource code',
1274: x_dists.bom_resource_code_tbl(i));
1275: END IF;
1276:

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

1269: IF (x_dists.bom_resource_code_tbl(i) IS NOT NULL AND
1270: x_dists.bom_resource_id_tbl(i) IS NULL) THEN
1271: IF (PO_LOG.d_stmt) THEN
1272: PO_LOG.stmt(d_module, d_position, 'bom resource id derivation failed');
1273: PO_LOG.stmt(d_module, d_position, 'bom resource code',
1274: x_dists.bom_resource_code_tbl(i));
1275: END IF;
1276:
1277: PO_PDOI_ERR_UTL.add_fatal_error

Line 1298: IF (PO_LOG.d_stmt) THEN

1294: -- derivation error for ship_to_ou_coa_id
1295: IF (x_dists.dest_charge_account_id_tbl(i) IS NULL AND
1296: x_dists.loc_txn_flow_header_id_tbl(i) IS NOT NULL AND
1297: x_dists.ship_to_ou_coa_id_tbl(i) = -1) THEN
1298: IF (PO_LOG.d_stmt) THEN
1299: PO_LOG.stmt(d_module, d_position, 'ship_to ou coa id derivation failed');
1300: END IF;
1301:
1302: PO_PDOI_ERR_UTL.add_fatal_error

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

1295: IF (x_dists.dest_charge_account_id_tbl(i) IS NULL AND
1296: x_dists.loc_txn_flow_header_id_tbl(i) IS NOT NULL AND
1297: x_dists.ship_to_ou_coa_id_tbl(i) = -1) THEN
1298: IF (PO_LOG.d_stmt) THEN
1299: PO_LOG.stmt(d_module, d_position, 'ship_to ou coa id derivation failed');
1300: END IF;
1301:
1302: PO_PDOI_ERR_UTL.add_fatal_error
1303: (

Line 1321: IF (PO_LOG.d_stmt) THEN

1317: END IF;
1318:
1319: -- check derivation error for project fields
1320: IF (l_derive_project_info_row_tbl.EXISTS(i)) THEN
1321: IF (PO_LOG.d_stmt) THEN
1322: PO_LOG.stmt(d_module, d_position, 'l_derive_project_info_row',
1323: l_derive_project_info_row_tbl.EXISTS(i));
1324: END IF;
1325:

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

1318:
1319: -- check derivation error for project fields
1320: IF (l_derive_project_info_row_tbl.EXISTS(i)) THEN
1321: IF (PO_LOG.d_stmt) THEN
1322: PO_LOG.stmt(d_module, d_position, 'l_derive_project_info_row',
1323: l_derive_project_info_row_tbl.EXISTS(i));
1324: END IF;
1325:
1326: -- derivation error for project_id

Line 1329: IF (PO_LOG.d_stmt) THEN

1325:
1326: -- derivation error for project_id
1327: IF (x_dists.project_tbl(i) IS NOT NULL AND
1328: x_dists.project_id_tbl(i) IS NULL) THEN
1329: IF (PO_LOG.d_stmt) THEN
1330: PO_LOG.stmt(d_module, d_position, 'project id derivation failed');
1331: PO_LOG.stmt(d_module, d_position, 'project',
1332: x_dists.project_tbl(i));
1333: END IF;

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

1326: -- derivation error for project_id
1327: IF (x_dists.project_tbl(i) IS NOT NULL AND
1328: x_dists.project_id_tbl(i) IS NULL) THEN
1329: IF (PO_LOG.d_stmt) THEN
1330: PO_LOG.stmt(d_module, d_position, 'project id derivation failed');
1331: PO_LOG.stmt(d_module, d_position, 'project',
1332: x_dists.project_tbl(i));
1333: END IF;
1334:

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

1327: IF (x_dists.project_tbl(i) IS NOT NULL AND
1328: x_dists.project_id_tbl(i) IS NULL) THEN
1329: IF (PO_LOG.d_stmt) THEN
1330: PO_LOG.stmt(d_module, d_position, 'project id derivation failed');
1331: PO_LOG.stmt(d_module, d_position, 'project',
1332: x_dists.project_tbl(i));
1333: END IF;
1334:
1335: PO_PDOI_ERR_UTL.add_fatal_error

Line 1356: IF (PO_LOG.d_stmt) THEN

1352: -- derivation error for task_id
1353: IF (x_dists.project_id_tbl(i) IS NOT NULL AND
1354: x_dists.task_tbl(i) IS NOT NULL AND
1355: x_dists.task_id_tbl(i) IS NULL) THEN
1356: IF (PO_LOG.d_stmt) THEN
1357: PO_LOG.stmt(d_module, d_position, 'task id derivation failed');
1358: PO_LOG.stmt(d_module, d_position, 'task',
1359: x_dists.task_tbl(i));
1360: END IF;

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

1353: IF (x_dists.project_id_tbl(i) IS NOT NULL AND
1354: x_dists.task_tbl(i) IS NOT NULL AND
1355: x_dists.task_id_tbl(i) IS NULL) THEN
1356: IF (PO_LOG.d_stmt) THEN
1357: PO_LOG.stmt(d_module, d_position, 'task id derivation failed');
1358: PO_LOG.stmt(d_module, d_position, 'task',
1359: x_dists.task_tbl(i));
1360: END IF;
1361:

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

1354: x_dists.task_tbl(i) IS NOT NULL AND
1355: x_dists.task_id_tbl(i) IS NULL) THEN
1356: IF (PO_LOG.d_stmt) THEN
1357: PO_LOG.stmt(d_module, d_position, 'task id derivation failed');
1358: PO_LOG.stmt(d_module, d_position, 'task',
1359: x_dists.task_tbl(i));
1360: END IF;
1361:
1362: PO_PDOI_ERR_UTL.add_fatal_error

Line 1383: IF (PO_LOG.d_stmt) THEN

1379: -- derivation error for expenditure_type
1380: IF (x_dists.project_id_tbl(i) IS NOT NULL AND
1381: x_dists.expenditure_tbl(i) IS NOT NULL AND
1382: x_dists.expenditure_type_tbl(i) IS NULL) THEN
1383: IF (PO_LOG.d_stmt) THEN
1384: PO_LOG.stmt(d_module, d_position, 'expenditure type derivation failed');
1385: PO_LOG.stmt(d_module, d_position, 'expenditure',
1386: x_dists.expenditure_tbl(i));
1387: END IF;

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

1380: IF (x_dists.project_id_tbl(i) IS NOT NULL AND
1381: x_dists.expenditure_tbl(i) IS NOT NULL AND
1382: x_dists.expenditure_type_tbl(i) IS NULL) THEN
1383: IF (PO_LOG.d_stmt) THEN
1384: PO_LOG.stmt(d_module, d_position, 'expenditure type derivation failed');
1385: PO_LOG.stmt(d_module, d_position, 'expenditure',
1386: x_dists.expenditure_tbl(i));
1387: END IF;
1388:

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

1381: x_dists.expenditure_tbl(i) IS NOT NULL AND
1382: x_dists.expenditure_type_tbl(i) IS NULL) THEN
1383: IF (PO_LOG.d_stmt) THEN
1384: PO_LOG.stmt(d_module, d_position, 'expenditure type derivation failed');
1385: PO_LOG.stmt(d_module, d_position, 'expenditure',
1386: x_dists.expenditure_tbl(i));
1387: END IF;
1388:
1389: PO_PDOI_ERR_UTL.add_fatal_error

Line 1410: IF (PO_LOG.d_stmt) THEN

1406: -- derivation error for expenditure_organization_id
1407: IF (x_dists.project_id_tbl(i) IS NOT NULL AND
1408: x_dists.expenditure_org_tbl(i) IS NOT NULL AND
1409: x_dists.expenditure_org_id_tbl(i) IS NULL) THEN
1410: IF (PO_LOG.d_stmt) THEN
1411: PO_LOG.stmt(d_module, d_position, 'expenditure org id derivation failed');
1412: PO_LOG.stmt(d_module, d_position, 'expenditure org',
1413: x_dists.expenditure_org_tbl(i));
1414: END IF;

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

1407: IF (x_dists.project_id_tbl(i) IS NOT NULL AND
1408: x_dists.expenditure_org_tbl(i) IS NOT NULL AND
1409: x_dists.expenditure_org_id_tbl(i) IS NULL) THEN
1410: IF (PO_LOG.d_stmt) THEN
1411: PO_LOG.stmt(d_module, d_position, 'expenditure org id derivation failed');
1412: PO_LOG.stmt(d_module, d_position, 'expenditure org',
1413: x_dists.expenditure_org_tbl(i));
1414: END IF;
1415:

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

1408: x_dists.expenditure_org_tbl(i) IS NOT NULL AND
1409: x_dists.expenditure_org_id_tbl(i) IS NULL) THEN
1410: IF (PO_LOG.d_stmt) THEN
1411: PO_LOG.stmt(d_module, d_position, 'expenditure org id derivation failed');
1412: PO_LOG.stmt(d_module, d_position, 'expenditure org',
1413: x_dists.expenditure_org_tbl(i));
1414: END IF;
1415:
1416: PO_PDOI_ERR_UTL.add_fatal_error

Line 1437: IF (PO_LOG.d_stmt) THEN

1433: -- derivation error on expenditure_item_date
1434: IF (x_dists.project_id_tbl(i) IS NOT NULL AND
1435: x_dists.expenditure_org_id_tbl(i) IS NOT NULL AND
1436: x_dists.expenditure_item_date_tbl(i) IS NULL) THEN
1437: IF (PO_LOG.d_stmt) THEN
1438: PO_LOG.stmt(d_module, d_position, 'expenditure item date derivation failed');
1439: END IF;
1440:
1441: PO_PDOI_ERR_UTL.add_fatal_error

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

1434: IF (x_dists.project_id_tbl(i) IS NOT NULL AND
1435: x_dists.expenditure_org_id_tbl(i) IS NOT NULL AND
1436: x_dists.expenditure_item_date_tbl(i) IS NULL) THEN
1437: IF (PO_LOG.d_stmt) THEN
1438: PO_LOG.stmt(d_module, d_position, 'expenditure item date derivation failed');
1439: END IF;
1440:
1441: PO_PDOI_ERR_UTL.add_fatal_error
1442: (

Line 1462: IF (PO_LOG.d_proc) THEN

1458: END LOOP;
1459:
1460: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_DIST_DERIVE);
1461:
1462: IF (PO_LOG.d_proc) THEN
1463: PO_LOG.proc_end (d_module);
1464: END IF;
1465:
1466: EXCEPTION

Line 1463: PO_LOG.proc_end (d_module);

1459:
1460: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_DIST_DERIVE);
1461:
1462: IF (PO_LOG.d_proc) THEN
1463: PO_LOG.proc_end (d_module);
1464: END IF;
1465:
1466: EXCEPTION
1467: WHEN OTHERS THEN

Line 1552: IF (PO_LOG.d_proc) THEN

1548: l_success BOOLEAN;
1549: BEGIN
1550: d_position := 0;
1551:
1552: IF (PO_LOG.d_proc) THEN
1553: PO_LOG.proc_begin(d_module);
1554: END IF;
1555:
1556: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_DIST_DEFAULT);

Line 1553: PO_LOG.proc_begin(d_module);

1549: BEGIN
1550: d_position := 0;
1551:
1552: IF (PO_LOG.d_proc) THEN
1553: PO_LOG.proc_begin(d_module);
1554: END IF;
1555:
1556: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_DIST_DEFAULT);
1557:

Line 1587: IF (PO_LOG.d_stmt) THEN

1583: -- default values for each distribution record
1584: x_dists.prevent_encumbrance_flag_tbl.EXTEND(x_dists.rec_count);
1585: FOR i IN 1..x_dists.rec_count
1586: LOOP
1587: IF (PO_LOG.d_stmt) THEN
1588: PO_LOG.stmt(d_module, d_position, 'index', i);
1589: END IF;
1590:
1591: -- default distribution_num

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

1584: x_dists.prevent_encumbrance_flag_tbl.EXTEND(x_dists.rec_count);
1585: FOR i IN 1..x_dists.rec_count
1586: LOOP
1587: IF (PO_LOG.d_stmt) THEN
1588: PO_LOG.stmt(d_module, d_position, 'index', i);
1589: END IF;
1590:
1591: -- default distribution_num
1592: IF (x_dists.dist_num_tbl(i) IS NULL OR

Line 1616: IF (PO_LOG.d_stmt) THEN

1612: x_dists.dest_context_tbl(i) := 'EXPENSE';
1613: END IF;
1614: END IF;
1615:
1616: IF (PO_LOG.d_stmt) THEN
1617: PO_LOG.stmt(d_module, d_position, 'dist num', x_dists.dist_num_tbl(i));
1618: PO_LOG.stmt(d_module, d_position, 'dist id', x_dists.po_dist_id_tbl(i));
1619: PO_LOG.stmt(d_module, d_position, 'item status', x_dists.item_status_tbl(i));
1620: PO_LOG.stmt(d_module, d_position, 'dest type code', x_dists.dest_type_code_tbl(i));

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

1613: END IF;
1614: END IF;
1615:
1616: IF (PO_LOG.d_stmt) THEN
1617: PO_LOG.stmt(d_module, d_position, 'dist num', x_dists.dist_num_tbl(i));
1618: PO_LOG.stmt(d_module, d_position, 'dist id', x_dists.po_dist_id_tbl(i));
1619: PO_LOG.stmt(d_module, d_position, 'item status', x_dists.item_status_tbl(i));
1620: PO_LOG.stmt(d_module, d_position, 'dest type code', x_dists.dest_type_code_tbl(i));
1621: END IF;

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

1614: END IF;
1615:
1616: IF (PO_LOG.d_stmt) THEN
1617: PO_LOG.stmt(d_module, d_position, 'dist num', x_dists.dist_num_tbl(i));
1618: PO_LOG.stmt(d_module, d_position, 'dist id', x_dists.po_dist_id_tbl(i));
1619: PO_LOG.stmt(d_module, d_position, 'item status', x_dists.item_status_tbl(i));
1620: PO_LOG.stmt(d_module, d_position, 'dest type code', x_dists.dest_type_code_tbl(i));
1621: END IF;
1622:

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

1615:
1616: IF (PO_LOG.d_stmt) THEN
1617: PO_LOG.stmt(d_module, d_position, 'dist num', x_dists.dist_num_tbl(i));
1618: PO_LOG.stmt(d_module, d_position, 'dist id', x_dists.po_dist_id_tbl(i));
1619: PO_LOG.stmt(d_module, d_position, 'item status', x_dists.item_status_tbl(i));
1620: PO_LOG.stmt(d_module, d_position, 'dest type code', x_dists.dest_type_code_tbl(i));
1621: END IF;
1622:
1623: d_position := 20;

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

1616: IF (PO_LOG.d_stmt) THEN
1617: PO_LOG.stmt(d_module, d_position, 'dist num', x_dists.dist_num_tbl(i));
1618: PO_LOG.stmt(d_module, d_position, 'dist id', x_dists.po_dist_id_tbl(i));
1619: PO_LOG.stmt(d_module, d_position, 'item status', x_dists.item_status_tbl(i));
1620: PO_LOG.stmt(d_module, d_position, 'dest type code', x_dists.dest_type_code_tbl(i));
1621: END IF;
1622:
1623: d_position := 20;
1624:

Line 1674: IF (PO_LOG.d_stmt) THEN

1670: x_dists.expenditure_type_tbl(i) IS NULL AND
1671: x_dists.expenditure_org_id_tbl(i) IS NULL AND
1672: x_dists.expenditure_item_date_tbl(i) IS NULL AND
1673: x_dists.award_id_tbl(i) IS NULL) THEN
1674: IF (PO_LOG.d_stmt) THEN
1675: PO_LOG.stmt(d_module, d_position, 'set gms_txn_required_flag to N');
1676: END IF;
1677:
1678: x_dists.gms_txn_required_flag_tbl(i) := 'N';

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

1671: x_dists.expenditure_org_id_tbl(i) IS NULL AND
1672: x_dists.expenditure_item_date_tbl(i) IS NULL AND
1673: x_dists.award_id_tbl(i) IS NULL) THEN
1674: IF (PO_LOG.d_stmt) THEN
1675: PO_LOG.stmt(d_module, d_position, 'set gms_txn_required_flag to N');
1676: END IF;
1677:
1678: x_dists.gms_txn_required_flag_tbl(i) := 'N';
1679: END IF;

Line 1704: IF (PO_LOG.d_stmt) THEN

1700: p_expenditure_item_date => x_dists.expenditure_item_date_tbl(i),
1701: p_calling_module => 'PO_PDOI_DIST_PROCESS_PVT.default_dists'
1702: );
1703:
1704: IF (PO_LOG.d_stmt) THEN
1705: PO_LOG.stmt(d_module, d_position, 'return status', l_return_status);
1706: END IF;
1707:
1708: IF (l_return_status <> FND_API.g_RET_STS_SUCCESS) THEN

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

1701: p_calling_module => 'PO_PDOI_DIST_PROCESS_PVT.default_dists'
1702: );
1703:
1704: IF (PO_LOG.d_stmt) THEN
1705: PO_LOG.stmt(d_module, d_position, 'return status', l_return_status);
1706: END IF;
1707:
1708: IF (l_return_status <> FND_API.g_RET_STS_SUCCESS) THEN
1709: PO_PDOI_ERR_UTL.add_fatal_error

Line 1727: IF (PO_LOG.d_stmt) THEN

1723: ELSE
1724:
1725: d_position := 40;
1726:
1727: IF (PO_LOG.d_stmt) THEN
1728: PO_LOG.stmt(d_module, d_position, 'award id', x_dists.award_id_tbl(i));
1729: END IF;
1730:
1731: IF (x_dists.award_id_tbl(i) IS NOT NULL) THEN

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

1724:
1725: d_position := 40;
1726:
1727: IF (PO_LOG.d_stmt) THEN
1728: PO_LOG.stmt(d_module, d_position, 'award id', x_dists.award_id_tbl(i));
1729: END IF;
1730:
1731: IF (x_dists.award_id_tbl(i) IS NOT NULL) THEN
1732: x_dists.award_set_id_tbl(i) := GMS_PO_API_GRP.get_new_award_set_id();

Line 1751: IF (PO_LOG.d_stmt) THEN

1747: p_award_id => x_dists.award_id_tbl(i),
1748: p_award_set_id => x_dists.award_set_id_tbl(i) -- bug5201306
1749: );
1750:
1751: IF (PO_LOG.d_stmt) THEN
1752: PO_LOG.stmt(d_module, d_position, 'return status', l_return_status);
1753: END IF;
1754:
1755: -- insert error if failed

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

1748: p_award_set_id => x_dists.award_set_id_tbl(i) -- bug5201306
1749: );
1750:
1751: IF (PO_LOG.d_stmt) THEN
1752: PO_LOG.stmt(d_module, d_position, 'return status', l_return_status);
1753: END IF;
1754:
1755: -- insert error if failed
1756: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 1778: IF (PO_LOG.d_stmt) THEN

1774: END IF; -- IF (PO_PDOI_PARAMS.g_product.gms_enabled = FND_API.g_TRUE AND ..
1775:
1776: d_position := 50;
1777:
1778: IF (PO_LOG.d_stmt) THEN
1779: PO_LOG.stmt(d_module, d_position, 'dest type code',
1780: x_dists.dest_type_code_tbl(i));
1781: END IF;
1782:

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

1775:
1776: d_position := 50;
1777:
1778: IF (PO_LOG.d_stmt) THEN
1779: PO_LOG.stmt(d_module, d_position, 'dest type code',
1780: x_dists.dest_type_code_tbl(i));
1781: END IF;
1782:
1783: -- bug 4284077:

Line 1950: IF (PO_LOG.d_stmt) THEN

1946: );
1947:
1948: END IF;
1949:
1950: IF (PO_LOG.d_stmt) THEN
1951: PO_LOG.stmt(d_module, d_position, 'l_success', l_success);
1952: PO_LOG.stmt(d_module, d_position, 'l_po_encumbrance_flag',
1953: l_po_encumbrance_flag);
1954: PO_LOG.stmt(d_module, d_position, 'l_charge_success', l_charge_success);

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

1947:
1948: END IF;
1949:
1950: IF (PO_LOG.d_stmt) THEN
1951: PO_LOG.stmt(d_module, d_position, 'l_success', l_success);
1952: PO_LOG.stmt(d_module, d_position, 'l_po_encumbrance_flag',
1953: l_po_encumbrance_flag);
1954: PO_LOG.stmt(d_module, d_position, 'l_charge_success', l_charge_success);
1955: PO_LOG.stmt(d_module, d_position, 'charge_account_id',

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

1948: END IF;
1949:
1950: IF (PO_LOG.d_stmt) THEN
1951: PO_LOG.stmt(d_module, d_position, 'l_success', l_success);
1952: PO_LOG.stmt(d_module, d_position, 'l_po_encumbrance_flag',
1953: l_po_encumbrance_flag);
1954: PO_LOG.stmt(d_module, d_position, 'l_charge_success', l_charge_success);
1955: PO_LOG.stmt(d_module, d_position, 'charge_account_id',
1956: x_dists.charge_account_id_tbl(i));

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

1950: IF (PO_LOG.d_stmt) THEN
1951: PO_LOG.stmt(d_module, d_position, 'l_success', l_success);
1952: PO_LOG.stmt(d_module, d_position, 'l_po_encumbrance_flag',
1953: l_po_encumbrance_flag);
1954: PO_LOG.stmt(d_module, d_position, 'l_charge_success', l_charge_success);
1955: PO_LOG.stmt(d_module, d_position, 'charge_account_id',
1956: x_dists.charge_account_id_tbl(i));
1957: PO_LOG.stmt(d_module, d_position, 'l_budget_success', l_budget_success);
1958: PO_LOG.stmt(d_module, d_position, 'l_accrual_success', l_accrual_success);

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

1951: PO_LOG.stmt(d_module, d_position, 'l_success', l_success);
1952: PO_LOG.stmt(d_module, d_position, 'l_po_encumbrance_flag',
1953: l_po_encumbrance_flag);
1954: PO_LOG.stmt(d_module, d_position, 'l_charge_success', l_charge_success);
1955: PO_LOG.stmt(d_module, d_position, 'charge_account_id',
1956: x_dists.charge_account_id_tbl(i));
1957: PO_LOG.stmt(d_module, d_position, 'l_budget_success', l_budget_success);
1958: PO_LOG.stmt(d_module, d_position, 'l_accrual_success', l_accrual_success);
1959: PO_LOG.stmt(d_module, d_position, 'l_variance_success', l_variance_success);

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

1953: l_po_encumbrance_flag);
1954: PO_LOG.stmt(d_module, d_position, 'l_charge_success', l_charge_success);
1955: PO_LOG.stmt(d_module, d_position, 'charge_account_id',
1956: x_dists.charge_account_id_tbl(i));
1957: PO_LOG.stmt(d_module, d_position, 'l_budget_success', l_budget_success);
1958: PO_LOG.stmt(d_module, d_position, 'l_accrual_success', l_accrual_success);
1959: PO_LOG.stmt(d_module, d_position, 'l_variance_success', l_variance_success);
1960: END IF;
1961:

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

1954: PO_LOG.stmt(d_module, d_position, 'l_charge_success', l_charge_success);
1955: PO_LOG.stmt(d_module, d_position, 'charge_account_id',
1956: x_dists.charge_account_id_tbl(i));
1957: PO_LOG.stmt(d_module, d_position, 'l_budget_success', l_budget_success);
1958: PO_LOG.stmt(d_module, d_position, 'l_accrual_success', l_accrual_success);
1959: PO_LOG.stmt(d_module, d_position, 'l_variance_success', l_variance_success);
1960: END IF;
1961:
1962: d_position := 70;

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

1955: PO_LOG.stmt(d_module, d_position, 'charge_account_id',
1956: x_dists.charge_account_id_tbl(i));
1957: PO_LOG.stmt(d_module, d_position, 'l_budget_success', l_budget_success);
1958: PO_LOG.stmt(d_module, d_position, 'l_accrual_success', l_accrual_success);
1959: PO_LOG.stmt(d_module, d_position, 'l_variance_success', l_variance_success);
1960: END IF;
1961:
1962: d_position := 70;
1963:

Line 2085: IF (PO_LOG.d_proc) THEN

2081: );
2082:
2083: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_DIST_DEFAULT);
2084:
2085: IF (PO_LOG.d_proc) THEN
2086: PO_LOG.proc_end (d_module);
2087: END IF;
2088:
2089: EXCEPTION

Line 2086: PO_LOG.proc_end (d_module);

2082:
2083: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_DIST_DEFAULT);
2084:
2085: IF (PO_LOG.d_proc) THEN
2086: PO_LOG.proc_end (d_module);
2087: END IF;
2088:
2089: EXCEPTION
2090: WHEN OTHERS THEN

Line 2133: IF (PO_LOG.d_proc) THEN

2129:
2130: BEGIN
2131: d_position := 0;
2132:
2133: IF (PO_LOG.d_proc) THEN
2134: PO_LOG.proc_begin(d_module);
2135: END IF;
2136:
2137: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_DIST_VALIDATE);

Line 2134: PO_LOG.proc_begin(d_module);

2130: BEGIN
2131: d_position := 0;
2132:
2133: IF (PO_LOG.d_proc) THEN
2134: PO_LOG.proc_begin(d_module);
2135: END IF;
2136:
2137: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_DIST_VALIDATE);
2138:

Line 2207: IF (PO_LOG.d_stmt) THEN

2203:
2204: d_position := 20;
2205:
2206: IF l_result_type = po_validations.c_result_type_failure THEN
2207: IF (PO_LOG.d_stmt) THEN
2208: PO_LOG.stmt(d_module, d_position, 'vaidate dists return failure');
2209: END IF;
2210:
2211: PO_PDOI_ERR_UTL.process_val_type_errors

Line 2208: PO_LOG.stmt(d_module, d_position, 'vaidate dists return failure');

2204: d_position := 20;
2205:
2206: IF l_result_type = po_validations.c_result_type_failure THEN
2207: IF (PO_LOG.d_stmt) THEN
2208: PO_LOG.stmt(d_module, d_position, 'vaidate dists return failure');
2209: END IF;
2210:
2211: PO_PDOI_ERR_UTL.process_val_type_errors
2212: (

Line 2228: IF (PO_LOG.d_stmt) THEN

2224: );
2225: END IF;
2226:
2227: IF l_result_type = po_validations.c_result_type_fatal THEN
2228: IF (PO_LOG.d_stmt) THEN
2229: PO_LOG.stmt(d_module, d_position, 'vaidate dists return fatal');
2230: END IF;
2231:
2232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

2225: END IF;
2226:
2227: IF l_result_type = po_validations.c_result_type_fatal THEN
2228: IF (PO_LOG.d_stmt) THEN
2229: PO_LOG.stmt(d_module, d_position, 'vaidate dists return fatal');
2230: END IF;
2231:
2232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2233: END IF;

Line 2237: IF (PO_LOG.d_proc) THEN

2233: END IF;
2234:
2235: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_DIST_VALIDATE);
2236:
2237: IF (PO_LOG.d_proc) THEN
2238: PO_LOG.proc_end (d_module);
2239: END IF;
2240:
2241: EXCEPTION

Line 2238: PO_LOG.proc_end (d_module);

2234:
2235: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_DIST_VALIDATE);
2236:
2237: IF (PO_LOG.d_proc) THEN
2238: PO_LOG.proc_end (d_module);
2239: END IF;
2240:
2241: EXCEPTION
2242: WHEN OTHERS THEN

Line 2294: IF (PO_LOG.d_proc) THEN

2290: l_result_tbl PO_TBL_NUMBER;
2291: BEGIN
2292: d_position := 0;
2293:
2294: IF (PO_LOG.d_proc) THEN
2295: PO_LOG.proc_begin(d_module, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
2296: PO_LOG.proc_begin(d_module, 'x_ship_to_ou_id_tbl', x_ship_to_ou_id_tbl);
2297: END IF;
2298:

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

2291: BEGIN
2292: d_position := 0;
2293:
2294: IF (PO_LOG.d_proc) THEN
2295: PO_LOG.proc_begin(d_module, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
2296: PO_LOG.proc_begin(d_module, 'x_ship_to_ou_id_tbl', x_ship_to_ou_id_tbl);
2297: END IF;
2298:
2299: x_ship_to_ou_id_tbl := PO_TBL_NUMBER();

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

2292: d_position := 0;
2293:
2294: IF (PO_LOG.d_proc) THEN
2295: PO_LOG.proc_begin(d_module, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
2296: PO_LOG.proc_begin(d_module, 'x_ship_to_ou_id_tbl', x_ship_to_ou_id_tbl);
2297: END IF;
2298:
2299: x_ship_to_ou_id_tbl := PO_TBL_NUMBER();
2300: x_ship_to_ou_id_tbl.EXTEND(p_index_tbl.COUNT);

Line 2327: IF (PO_LOG.d_stmt) THEN

2323:
2324: -- set value back to x_ship_to_ou_id_tbl
2325: FOR i IN 1..l_index_tbl.COUNT
2326: LOOP
2327: IF (PO_LOG.d_stmt) THEN
2328: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2329: PO_LOG.stmt(d_module, d_position, 'new ship_to ou id',
2330: l_result_tbl(i));
2331: END IF;

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

2324: -- set value back to x_ship_to_ou_id_tbl
2325: FOR i IN 1..l_index_tbl.COUNT
2326: LOOP
2327: IF (PO_LOG.d_stmt) THEN
2328: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2329: PO_LOG.stmt(d_module, d_position, 'new ship_to ou id',
2330: l_result_tbl(i));
2331: END IF;
2332:

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

2325: FOR i IN 1..l_index_tbl.COUNT
2326: LOOP
2327: IF (PO_LOG.d_stmt) THEN
2328: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2329: PO_LOG.stmt(d_module, d_position, 'new ship_to ou id',
2330: l_result_tbl(i));
2331: END IF;
2332:
2333: x_ship_to_ou_id_tbl(l_index_tbl(i)) := l_result_tbl(i);

Line 2336: IF (PO_LOG.d_proc) THEN

2332:
2333: x_ship_to_ou_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
2334: END LOOP;
2335:
2336: IF (PO_LOG.d_proc) THEN
2337: PO_LOG.proc_end (d_module);
2338: END IF;
2339:
2340: EXCEPTION

Line 2337: PO_LOG.proc_end (d_module);

2333: x_ship_to_ou_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
2334: END LOOP;
2335:
2336: IF (PO_LOG.d_proc) THEN
2337: PO_LOG.proc_end (d_module);
2338: END IF;
2339:
2340: EXCEPTION
2341: WHEN OTHERS THEN

Line 2389: IF (PO_LOG.d_proc) THEN

2385: l_result_tbl PO_TBL_NUMBER;
2386: BEGIN
2387: d_position := 0;
2388:
2389: IF (PO_LOG.d_proc) THEN
2390: PO_LOG.proc_begin(d_module, 'p_deliver_to_loc_tbl',
2391: p_deliver_to_loc_tbl);
2392: PO_LOG.proc_begin(d_module, 'x_deliver_to_loc_id_tbl',
2393: x_deliver_to_loc_id_tbl);

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

2386: BEGIN
2387: d_position := 0;
2388:
2389: IF (PO_LOG.d_proc) THEN
2390: PO_LOG.proc_begin(d_module, 'p_deliver_to_loc_tbl',
2391: p_deliver_to_loc_tbl);
2392: PO_LOG.proc_begin(d_module, 'x_deliver_to_loc_id_tbl',
2393: x_deliver_to_loc_id_tbl);
2394: END IF;

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

2388:
2389: IF (PO_LOG.d_proc) THEN
2390: PO_LOG.proc_begin(d_module, 'p_deliver_to_loc_tbl',
2391: p_deliver_to_loc_tbl);
2392: PO_LOG.proc_begin(d_module, 'x_deliver_to_loc_id_tbl',
2393: x_deliver_to_loc_id_tbl);
2394: END IF;
2395:
2396: -- query database to get derived result in batch mode

Line 2420: IF (PO_LOG.d_stmt) THEN

2416:
2417: -- set value back to x_deliver_to_loc_id_tbl
2418: FOR i IN 1..l_index_tbl.COUNT
2419: LOOP
2420: IF (PO_LOG.d_stmt) THEN
2421: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2422: PO_LOG.stmt(d_module, d_position, 'new deliver_to loc id',
2423: l_result_tbl(i));
2424: END IF;

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

2417: -- set value back to x_deliver_to_loc_id_tbl
2418: FOR i IN 1..l_index_tbl.COUNT
2419: LOOP
2420: IF (PO_LOG.d_stmt) THEN
2421: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2422: PO_LOG.stmt(d_module, d_position, 'new deliver_to loc id',
2423: l_result_tbl(i));
2424: END IF;
2425:

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

2418: FOR i IN 1..l_index_tbl.COUNT
2419: LOOP
2420: IF (PO_LOG.d_stmt) THEN
2421: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2422: PO_LOG.stmt(d_module, d_position, 'new deliver_to loc id',
2423: l_result_tbl(i));
2424: END IF;
2425:
2426: x_deliver_to_loc_id_tbl(l_index_tbl(i)) := l_result_tbl(i);

Line 2429: IF (PO_LOG.d_proc) THEN

2425:
2426: x_deliver_to_loc_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
2427: END LOOP;
2428:
2429: IF (PO_LOG.d_proc) THEN
2430: PO_LOG.proc_end (d_module);
2431: END IF;
2432:
2433: EXCEPTION

Line 2430: PO_LOG.proc_end (d_module);

2426: x_deliver_to_loc_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
2427: END LOOP;
2428:
2429: IF (PO_LOG.d_proc) THEN
2430: PO_LOG.proc_end (d_module);
2431: END IF;
2432:
2433: EXCEPTION
2434: WHEN OTHERS THEN

Line 2482: IF (PO_LOG.d_proc) THEN

2478: l_result_tbl PO_TBL_NUMBER;
2479: BEGIN
2480: d_position := 0;
2481:
2482: IF (PO_LOG.d_proc) THEN
2483: PO_LOG.proc_begin(d_module, 'p_person_name_tbl', p_person_name_tbl);
2484: PO_LOG.proc_begin(d_module, 'x_person_id_tbl', x_person_id_tbl);
2485: END IF;
2486:

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

2479: BEGIN
2480: d_position := 0;
2481:
2482: IF (PO_LOG.d_proc) THEN
2483: PO_LOG.proc_begin(d_module, 'p_person_name_tbl', p_person_name_tbl);
2484: PO_LOG.proc_begin(d_module, 'x_person_id_tbl', x_person_id_tbl);
2485: END IF;
2486:
2487: -- query database to get derived result in batch mode

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

2480: d_position := 0;
2481:
2482: IF (PO_LOG.d_proc) THEN
2483: PO_LOG.proc_begin(d_module, 'p_person_name_tbl', p_person_name_tbl);
2484: PO_LOG.proc_begin(d_module, 'x_person_id_tbl', x_person_id_tbl);
2485: END IF;
2486:
2487: -- query database to get derived result in batch mode
2488: FORALL i IN 1..p_index_tbl.COUNT

Line 2511: IF (PO_LOG.d_stmt) THEN

2507:
2508: -- set value back to x_person_id_tbl
2509: FOR i IN 1..l_index_tbl.COUNT
2510: LOOP
2511: IF (PO_LOG.d_stmt) THEN
2512: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2513: PO_LOG.stmt(d_module, d_position, 'new deliver_to person id',
2514: l_result_tbl(i));
2515: END IF;

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

2508: -- set value back to x_person_id_tbl
2509: FOR i IN 1..l_index_tbl.COUNT
2510: LOOP
2511: IF (PO_LOG.d_stmt) THEN
2512: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2513: PO_LOG.stmt(d_module, d_position, 'new deliver_to person id',
2514: l_result_tbl(i));
2515: END IF;
2516:

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

2509: FOR i IN 1..l_index_tbl.COUNT
2510: LOOP
2511: IF (PO_LOG.d_stmt) THEN
2512: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2513: PO_LOG.stmt(d_module, d_position, 'new deliver_to person id',
2514: l_result_tbl(i));
2515: END IF;
2516:
2517: x_person_id_tbl(l_index_tbl(i)) := l_result_tbl(i);

Line 2520: IF (PO_LOG.d_proc) THEN

2516:
2517: x_person_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
2518: END LOOP;
2519:
2520: IF (PO_LOG.d_proc) THEN
2521: PO_LOG.proc_end (d_module);
2522: END IF;
2523:
2524: EXCEPTION

Line 2521: PO_LOG.proc_end (d_module);

2517: x_person_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
2518: END LOOP;
2519:
2520: IF (PO_LOG.d_proc) THEN
2521: PO_LOG.proc_end (d_module);
2522: END IF;
2523:
2524: EXCEPTION
2525: WHEN OTHERS THEN

Line 2573: IF (PO_LOG.d_proc) THEN

2569: l_result_tbl PO_TBL_VARCHAR25;
2570: BEGIN
2571: d_position := 0;
2572:
2573: IF (PO_LOG.d_proc) THEN
2574: PO_LOG.proc_begin(d_module, 'p_dest_type_tbl', p_dest_type_tbl);
2575: PO_LOG.proc_begin(d_module, 'x_dest_type_code_tbl', x_dest_type_code_tbl);
2576: END IF;
2577:

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

2570: BEGIN
2571: d_position := 0;
2572:
2573: IF (PO_LOG.d_proc) THEN
2574: PO_LOG.proc_begin(d_module, 'p_dest_type_tbl', p_dest_type_tbl);
2575: PO_LOG.proc_begin(d_module, 'x_dest_type_code_tbl', x_dest_type_code_tbl);
2576: END IF;
2577:
2578: -- query database to get derived result in batch mode

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

2571: d_position := 0;
2572:
2573: IF (PO_LOG.d_proc) THEN
2574: PO_LOG.proc_begin(d_module, 'p_dest_type_tbl', p_dest_type_tbl);
2575: PO_LOG.proc_begin(d_module, 'x_dest_type_code_tbl', x_dest_type_code_tbl);
2576: END IF;
2577:
2578: -- query database to get derived result in batch mode
2579: FORALL i IN 1..p_index_tbl.COUNT

Line 2602: IF (PO_LOG.d_stmt) THEN

2598:
2599: -- set value back to x_dest_type_code_tbl
2600: FOR i IN 1..l_index_tbl.COUNT
2601: LOOP
2602: IF (PO_LOG.d_stmt) THEN
2603: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2604: PO_LOG.stmt(d_module, d_position, 'new dest type code',
2605: l_result_tbl(i));
2606: END IF;

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

2599: -- set value back to x_dest_type_code_tbl
2600: FOR i IN 1..l_index_tbl.COUNT
2601: LOOP
2602: IF (PO_LOG.d_stmt) THEN
2603: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2604: PO_LOG.stmt(d_module, d_position, 'new dest type code',
2605: l_result_tbl(i));
2606: END IF;
2607:

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

2600: FOR i IN 1..l_index_tbl.COUNT
2601: LOOP
2602: IF (PO_LOG.d_stmt) THEN
2603: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2604: PO_LOG.stmt(d_module, d_position, 'new dest type code',
2605: l_result_tbl(i));
2606: END IF;
2607:
2608: x_dest_type_code_tbl(l_index_tbl(i)) := l_result_tbl(i);

Line 2611: IF (PO_LOG.d_proc) THEN

2607:
2608: x_dest_type_code_tbl(l_index_tbl(i)) := l_result_tbl(i);
2609: END LOOP;
2610:
2611: IF (PO_LOG.d_proc) THEN
2612: PO_LOG.proc_end (d_module);
2613: END IF;
2614:
2615: EXCEPTION

Line 2612: PO_LOG.proc_end (d_module);

2608: x_dest_type_code_tbl(l_index_tbl(i)) := l_result_tbl(i);
2609: END LOOP;
2610:
2611: IF (PO_LOG.d_proc) THEN
2612: PO_LOG.proc_end (d_module);
2613: END IF;
2614:
2615: EXCEPTION
2616: WHEN OTHERS THEN

Line 2667: IF (PO_LOG.d_proc) THEN

2663: l_result_tbl PO_TBL_NUMBER;
2664: BEGIN
2665: d_position := 0;
2666:
2667: IF (PO_LOG.d_proc) THEN
2668: PO_LOG.proc_begin(d_module, 'p_dest_org_tbl', p_dest_org_tbl);
2669: PO_LOG.proc_begin(d_module, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
2670: PO_LOG.proc_begin(d_module, 'x_dest_org_id_tbl', x_dest_org_id_tbl);
2671: END IF;

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

2664: BEGIN
2665: d_position := 0;
2666:
2667: IF (PO_LOG.d_proc) THEN
2668: PO_LOG.proc_begin(d_module, 'p_dest_org_tbl', p_dest_org_tbl);
2669: PO_LOG.proc_begin(d_module, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
2670: PO_LOG.proc_begin(d_module, 'x_dest_org_id_tbl', x_dest_org_id_tbl);
2671: END IF;
2672:

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

2665: d_position := 0;
2666:
2667: IF (PO_LOG.d_proc) THEN
2668: PO_LOG.proc_begin(d_module, 'p_dest_org_tbl', p_dest_org_tbl);
2669: PO_LOG.proc_begin(d_module, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
2670: PO_LOG.proc_begin(d_module, 'x_dest_org_id_tbl', x_dest_org_id_tbl);
2671: END IF;
2672:
2673: -- query database to get derived result in batch mode

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

2666:
2667: IF (PO_LOG.d_proc) THEN
2668: PO_LOG.proc_begin(d_module, 'p_dest_org_tbl', p_dest_org_tbl);
2669: PO_LOG.proc_begin(d_module, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
2670: PO_LOG.proc_begin(d_module, 'x_dest_org_id_tbl', x_dest_org_id_tbl);
2671: END IF;
2672:
2673: -- query database to get derived result in batch mode
2674: FORALL i IN 1..p_index_tbl.COUNT

Line 2712: IF (PO_LOG.d_stmt) THEN

2708:
2709: -- set value back to x_dest_org_id_tbl
2710: FOR i IN 1..l_index_tbl.COUNT
2711: LOOP
2712: IF (PO_LOG.d_stmt) THEN
2713: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2714: PO_LOG.stmt(d_module, d_position, 'new dest org id',
2715: l_result_tbl(i));
2716: END IF;

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

2709: -- set value back to x_dest_org_id_tbl
2710: FOR i IN 1..l_index_tbl.COUNT
2711: LOOP
2712: IF (PO_LOG.d_stmt) THEN
2713: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2714: PO_LOG.stmt(d_module, d_position, 'new dest org id',
2715: l_result_tbl(i));
2716: END IF;
2717:

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

2710: FOR i IN 1..l_index_tbl.COUNT
2711: LOOP
2712: IF (PO_LOG.d_stmt) THEN
2713: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2714: PO_LOG.stmt(d_module, d_position, 'new dest org id',
2715: l_result_tbl(i));
2716: END IF;
2717:
2718: x_dest_org_id_tbl(l_index_tbl(i)) := l_result_tbl(i);

Line 2721: IF (PO_LOG.d_proc) THEN

2717:
2718: x_dest_org_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
2719: END LOOP;
2720:
2721: IF (PO_LOG.d_proc) THEN
2722: PO_LOG.proc_end (d_module);
2723: END IF;
2724:
2725: EXCEPTION

Line 2722: PO_LOG.proc_end (d_module);

2718: x_dest_org_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
2719: END LOOP;
2720:
2721: IF (PO_LOG.d_proc) THEN
2722: PO_LOG.proc_end (d_module);
2723: END IF;
2724:
2725: EXCEPTION
2726: WHEN OTHERS THEN

Line 2780: IF (PO_LOG.d_proc) THEN

2776: l_result_tbl PO_TBL_NUMBER;
2777: BEGIN
2778: d_position := 0;
2779:
2780: IF (PO_LOG.d_proc) THEN
2781: PO_LOG.proc_begin(d_module, 'p_dest_org_id_tbl', p_dest_org_id_tbl);
2782: PO_LOG.proc_begin(d_module, 'p_dest_org_id_tbl', p_dest_org_id_tbl);
2783: PO_LOG.proc_begin(d_module, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
2784: PO_LOG.proc_begin(d_module, 'x_wip_entity_id_tbl', x_wip_entity_id_tbl);

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

2777: BEGIN
2778: d_position := 0;
2779:
2780: IF (PO_LOG.d_proc) THEN
2781: PO_LOG.proc_begin(d_module, 'p_dest_org_id_tbl', p_dest_org_id_tbl);
2782: PO_LOG.proc_begin(d_module, 'p_dest_org_id_tbl', p_dest_org_id_tbl);
2783: PO_LOG.proc_begin(d_module, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
2784: PO_LOG.proc_begin(d_module, 'x_wip_entity_id_tbl', x_wip_entity_id_tbl);
2785: END IF;

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

2778: d_position := 0;
2779:
2780: IF (PO_LOG.d_proc) THEN
2781: PO_LOG.proc_begin(d_module, 'p_dest_org_id_tbl', p_dest_org_id_tbl);
2782: PO_LOG.proc_begin(d_module, 'p_dest_org_id_tbl', p_dest_org_id_tbl);
2783: PO_LOG.proc_begin(d_module, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
2784: PO_LOG.proc_begin(d_module, 'x_wip_entity_id_tbl', x_wip_entity_id_tbl);
2785: END IF;
2786:

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

2779:
2780: IF (PO_LOG.d_proc) THEN
2781: PO_LOG.proc_begin(d_module, 'p_dest_org_id_tbl', p_dest_org_id_tbl);
2782: PO_LOG.proc_begin(d_module, 'p_dest_org_id_tbl', p_dest_org_id_tbl);
2783: PO_LOG.proc_begin(d_module, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
2784: PO_LOG.proc_begin(d_module, 'x_wip_entity_id_tbl', x_wip_entity_id_tbl);
2785: END IF;
2786:
2787: -- query database to get derived result in batch mode

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

2780: IF (PO_LOG.d_proc) THEN
2781: PO_LOG.proc_begin(d_module, 'p_dest_org_id_tbl', p_dest_org_id_tbl);
2782: PO_LOG.proc_begin(d_module, 'p_dest_org_id_tbl', p_dest_org_id_tbl);
2783: PO_LOG.proc_begin(d_module, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
2784: PO_LOG.proc_begin(d_module, 'x_wip_entity_id_tbl', x_wip_entity_id_tbl);
2785: END IF;
2786:
2787: -- query database to get derived result in batch mode
2788: FORALL i IN 1..p_index_tbl.COUNT

Line 2813: IF (PO_LOG.d_stmt) THEN

2809:
2810: -- set value back to x_wip_entity_id_tbl
2811: FOR i IN 1..l_index_tbl.COUNT
2812: LOOP
2813: IF (PO_LOG.d_stmt) THEN
2814: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2815: PO_LOG.stmt(d_module, d_position, 'new wip entity id',
2816: l_result_tbl(i));
2817: END IF;

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

2810: -- set value back to x_wip_entity_id_tbl
2811: FOR i IN 1..l_index_tbl.COUNT
2812: LOOP
2813: IF (PO_LOG.d_stmt) THEN
2814: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2815: PO_LOG.stmt(d_module, d_position, 'new wip entity id',
2816: l_result_tbl(i));
2817: END IF;
2818:

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

2811: FOR i IN 1..l_index_tbl.COUNT
2812: LOOP
2813: IF (PO_LOG.d_stmt) THEN
2814: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2815: PO_LOG.stmt(d_module, d_position, 'new wip entity id',
2816: l_result_tbl(i));
2817: END IF;
2818:
2819: x_wip_entity_id_tbl(l_index_tbl(i)) := l_result_tbl(i);

Line 2822: IF (PO_LOG.d_proc) THEN

2818:
2819: x_wip_entity_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
2820: END LOOP;
2821:
2822: IF (PO_LOG.d_proc) THEN
2823: PO_LOG.proc_end (d_module);
2824: END IF;
2825:
2826: EXCEPTION

Line 2823: PO_LOG.proc_end (d_module);

2819: x_wip_entity_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
2820: END LOOP;
2821:
2822: IF (PO_LOG.d_proc) THEN
2823: PO_LOG.proc_end (d_module);
2824: END IF;
2825:
2826: EXCEPTION
2827: WHEN OTHERS THEN

Line 2881: IF (PO_LOG.d_proc) THEN

2877: l_result_tbl PO_TBL_NUMBER;
2878: BEGIN
2879: d_position := 0;
2880:
2881: IF (PO_LOG.d_proc) THEN
2882: PO_LOG.proc_begin(d_module, 'p_wip_line_code_tbl', p_wip_line_code_tbl);
2883: PO_LOG.proc_begin(d_module, 'p_dest_org_id_tbl', p_dest_org_id_tbl);
2884: PO_LOG.proc_begin(d_module, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
2885: PO_LOG.proc_begin(d_module, 'x_wip_line_id_tbl', x_wip_line_id_tbl);

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

2878: BEGIN
2879: d_position := 0;
2880:
2881: IF (PO_LOG.d_proc) THEN
2882: PO_LOG.proc_begin(d_module, 'p_wip_line_code_tbl', p_wip_line_code_tbl);
2883: PO_LOG.proc_begin(d_module, 'p_dest_org_id_tbl', p_dest_org_id_tbl);
2884: PO_LOG.proc_begin(d_module, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
2885: PO_LOG.proc_begin(d_module, 'x_wip_line_id_tbl', x_wip_line_id_tbl);
2886: END IF;

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

2879: d_position := 0;
2880:
2881: IF (PO_LOG.d_proc) THEN
2882: PO_LOG.proc_begin(d_module, 'p_wip_line_code_tbl', p_wip_line_code_tbl);
2883: PO_LOG.proc_begin(d_module, 'p_dest_org_id_tbl', p_dest_org_id_tbl);
2884: PO_LOG.proc_begin(d_module, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
2885: PO_LOG.proc_begin(d_module, 'x_wip_line_id_tbl', x_wip_line_id_tbl);
2886: END IF;
2887:

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

2880:
2881: IF (PO_LOG.d_proc) THEN
2882: PO_LOG.proc_begin(d_module, 'p_wip_line_code_tbl', p_wip_line_code_tbl);
2883: PO_LOG.proc_begin(d_module, 'p_dest_org_id_tbl', p_dest_org_id_tbl);
2884: PO_LOG.proc_begin(d_module, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
2885: PO_LOG.proc_begin(d_module, 'x_wip_line_id_tbl', x_wip_line_id_tbl);
2886: END IF;
2887:
2888: -- query database to get derived result in batch mode

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

2881: IF (PO_LOG.d_proc) THEN
2882: PO_LOG.proc_begin(d_module, 'p_wip_line_code_tbl', p_wip_line_code_tbl);
2883: PO_LOG.proc_begin(d_module, 'p_dest_org_id_tbl', p_dest_org_id_tbl);
2884: PO_LOG.proc_begin(d_module, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
2885: PO_LOG.proc_begin(d_module, 'x_wip_line_id_tbl', x_wip_line_id_tbl);
2886: END IF;
2887:
2888: -- query database to get derived result in batch mode
2889: FORALL i IN 1..p_index_tbl.COUNT

Line 2914: IF (PO_LOG.d_stmt) THEN

2910:
2911: -- set value back to x_wip_line_id_tbl
2912: FOR i IN 1..l_index_tbl.COUNT
2913: LOOP
2914: IF (PO_LOG.d_stmt) THEN
2915: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2916: PO_LOG.stmt(d_module, d_position, 'new wip line id',
2917: l_result_tbl(i));
2918: END IF;

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

2911: -- set value back to x_wip_line_id_tbl
2912: FOR i IN 1..l_index_tbl.COUNT
2913: LOOP
2914: IF (PO_LOG.d_stmt) THEN
2915: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2916: PO_LOG.stmt(d_module, d_position, 'new wip line id',
2917: l_result_tbl(i));
2918: END IF;
2919:

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

2912: FOR i IN 1..l_index_tbl.COUNT
2913: LOOP
2914: IF (PO_LOG.d_stmt) THEN
2915: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
2916: PO_LOG.stmt(d_module, d_position, 'new wip line id',
2917: l_result_tbl(i));
2918: END IF;
2919:
2920: x_wip_line_id_tbl(l_index_tbl(i)) := l_result_tbl(i);

Line 2923: IF (PO_LOG.d_proc) THEN

2919:
2920: x_wip_line_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
2921: END LOOP;
2922:
2923: IF (PO_LOG.d_proc) THEN
2924: PO_LOG.proc_end (d_module);
2925: END IF;
2926:
2927: EXCEPTION

Line 2924: PO_LOG.proc_end (d_module);

2920: x_wip_line_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
2921: END LOOP;
2922:
2923: IF (PO_LOG.d_proc) THEN
2924: PO_LOG.proc_end (d_module);
2925: END IF;
2926:
2927: EXCEPTION
2928: WHEN OTHERS THEN

Line 2981: IF (PO_LOG.d_proc) THEN

2977: l_result_tbl PO_TBL_NUMBER;
2978: BEGIN
2979: d_position := 0;
2980:
2981: IF (PO_LOG.d_proc) THEN
2982: PO_LOG.proc_begin(d_module, 'p_dest_org_id_tbl', p_dest_org_id_tbl);
2983: PO_LOG.proc_begin(d_module, 'p_txn_flow_header_id_tbl',
2984: p_txn_flow_header_id_tbl);
2985: PO_LOG.proc_begin(d_module, 'p_dest_charge_account_id_tbl',

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

2978: BEGIN
2979: d_position := 0;
2980:
2981: IF (PO_LOG.d_proc) THEN
2982: PO_LOG.proc_begin(d_module, 'p_dest_org_id_tbl', p_dest_org_id_tbl);
2983: PO_LOG.proc_begin(d_module, 'p_txn_flow_header_id_tbl',
2984: p_txn_flow_header_id_tbl);
2985: PO_LOG.proc_begin(d_module, 'p_dest_charge_account_id_tbl',
2986: p_dest_charge_account_id_tbl);

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

2979: d_position := 0;
2980:
2981: IF (PO_LOG.d_proc) THEN
2982: PO_LOG.proc_begin(d_module, 'p_dest_org_id_tbl', p_dest_org_id_tbl);
2983: PO_LOG.proc_begin(d_module, 'p_txn_flow_header_id_tbl',
2984: p_txn_flow_header_id_tbl);
2985: PO_LOG.proc_begin(d_module, 'p_dest_charge_account_id_tbl',
2986: p_dest_charge_account_id_tbl);
2987: PO_LOG.proc_begin(d_module, 'x_ship_to_ou_coa_id_tbl',

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

2981: IF (PO_LOG.d_proc) THEN
2982: PO_LOG.proc_begin(d_module, 'p_dest_org_id_tbl', p_dest_org_id_tbl);
2983: PO_LOG.proc_begin(d_module, 'p_txn_flow_header_id_tbl',
2984: p_txn_flow_header_id_tbl);
2985: PO_LOG.proc_begin(d_module, 'p_dest_charge_account_id_tbl',
2986: p_dest_charge_account_id_tbl);
2987: PO_LOG.proc_begin(d_module, 'x_ship_to_ou_coa_id_tbl',
2988: x_ship_to_ou_coa_id_tbl);
2989: END IF;

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

2983: PO_LOG.proc_begin(d_module, 'p_txn_flow_header_id_tbl',
2984: p_txn_flow_header_id_tbl);
2985: PO_LOG.proc_begin(d_module, 'p_dest_charge_account_id_tbl',
2986: p_dest_charge_account_id_tbl);
2987: PO_LOG.proc_begin(d_module, 'x_ship_to_ou_coa_id_tbl',
2988: x_ship_to_ou_coa_id_tbl);
2989: END IF;
2990:
2991: -- query database to get derived result in batch mode

Line 3020: IF (PO_LOG.d_stmt) THEN

3016:
3017: -- set value back to x_wip_line_id_tbl
3018: FOR i IN 1..l_index_tbl.COUNT
3019: LOOP
3020: IF (PO_LOG.d_stmt) THEN
3021: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3022: PO_LOG.stmt(d_module, d_position, 'new ship_to ou coa id',
3023: l_result_tbl(i));
3024: END IF;

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

3017: -- set value back to x_wip_line_id_tbl
3018: FOR i IN 1..l_index_tbl.COUNT
3019: LOOP
3020: IF (PO_LOG.d_stmt) THEN
3021: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3022: PO_LOG.stmt(d_module, d_position, 'new ship_to ou coa id',
3023: l_result_tbl(i));
3024: END IF;
3025:

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

3018: FOR i IN 1..l_index_tbl.COUNT
3019: LOOP
3020: IF (PO_LOG.d_stmt) THEN
3021: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3022: PO_LOG.stmt(d_module, d_position, 'new ship_to ou coa id',
3023: l_result_tbl(i));
3024: END IF;
3025:
3026: x_ship_to_ou_coa_id_tbl(l_index_tbl(i)) := l_result_tbl(i);

Line 3029: IF (PO_LOG.d_proc) THEN

3025:
3026: x_ship_to_ou_coa_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
3027: END LOOP;
3028:
3029: IF (PO_LOG.d_proc) THEN
3030: PO_LOG.proc_end (d_module);
3031: END IF;
3032:
3033: EXCEPTION

Line 3030: PO_LOG.proc_end (d_module);

3026: x_ship_to_ou_coa_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
3027: END LOOP;
3028:
3029: IF (PO_LOG.d_proc) THEN
3030: PO_LOG.proc_end (d_module);
3031: END IF;
3032:
3033: EXCEPTION
3034: WHEN OTHERS THEN

Line 3085: IF (PO_LOG.d_proc) THEN

3081: l_result_tbl PO_TBL_NUMBER;
3082: BEGIN
3083: d_position := 0;
3084:
3085: IF (PO_LOG.d_proc) THEN
3086: PO_LOG.proc_begin(d_module, 'p_bom_resource_code_tbl',
3087: p_bom_resource_code_tbl);
3088: PO_LOG.proc_begin(d_module, 'p_dest_org_id_tbl', p_dest_org_id_tbl);
3089: PO_LOG.proc_begin(d_module, 'x_bom_resource_id_tbl',

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

3082: BEGIN
3083: d_position := 0;
3084:
3085: IF (PO_LOG.d_proc) THEN
3086: PO_LOG.proc_begin(d_module, 'p_bom_resource_code_tbl',
3087: p_bom_resource_code_tbl);
3088: PO_LOG.proc_begin(d_module, 'p_dest_org_id_tbl', p_dest_org_id_tbl);
3089: PO_LOG.proc_begin(d_module, 'x_bom_resource_id_tbl',
3090: x_bom_resource_id_tbl);

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

3084:
3085: IF (PO_LOG.d_proc) THEN
3086: PO_LOG.proc_begin(d_module, 'p_bom_resource_code_tbl',
3087: p_bom_resource_code_tbl);
3088: PO_LOG.proc_begin(d_module, 'p_dest_org_id_tbl', p_dest_org_id_tbl);
3089: PO_LOG.proc_begin(d_module, 'x_bom_resource_id_tbl',
3090: x_bom_resource_id_tbl);
3091: END IF;
3092:

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

3085: IF (PO_LOG.d_proc) THEN
3086: PO_LOG.proc_begin(d_module, 'p_bom_resource_code_tbl',
3087: p_bom_resource_code_tbl);
3088: PO_LOG.proc_begin(d_module, 'p_dest_org_id_tbl', p_dest_org_id_tbl);
3089: PO_LOG.proc_begin(d_module, 'x_bom_resource_id_tbl',
3090: x_bom_resource_id_tbl);
3091: END IF;
3092:
3093: -- query database to get derived result in batch mode

Line 3118: IF (PO_LOG.d_stmt) THEN

3114:
3115: -- set value back to x_bom_resource_id_tbl
3116: FOR i IN 1..l_index_tbl.COUNT
3117: LOOP
3118: IF (PO_LOG.d_stmt) THEN
3119: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3120: PO_LOG.stmt(d_module, d_position, 'new bom resource id',
3121: l_result_tbl(i));
3122: END IF;

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

3115: -- set value back to x_bom_resource_id_tbl
3116: FOR i IN 1..l_index_tbl.COUNT
3117: LOOP
3118: IF (PO_LOG.d_stmt) THEN
3119: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3120: PO_LOG.stmt(d_module, d_position, 'new bom resource id',
3121: l_result_tbl(i));
3122: END IF;
3123:

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

3116: FOR i IN 1..l_index_tbl.COUNT
3117: LOOP
3118: IF (PO_LOG.d_stmt) THEN
3119: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3120: PO_LOG.stmt(d_module, d_position, 'new bom resource id',
3121: l_result_tbl(i));
3122: END IF;
3123:
3124: x_bom_resource_id_tbl(l_index_tbl(i)) := l_result_tbl(i);

Line 3127: IF (PO_LOG.d_proc) THEN

3123:
3124: x_bom_resource_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
3125: END LOOP;
3126:
3127: IF (PO_LOG.d_proc) THEN
3128: PO_LOG.proc_end (d_module);
3129: END IF;
3130:
3131: EXCEPTION

Line 3128: PO_LOG.proc_end (d_module);

3124: x_bom_resource_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
3125: END LOOP;
3126:
3127: IF (PO_LOG.d_proc) THEN
3128: PO_LOG.proc_end (d_module);
3129: END IF;
3130:
3131: EXCEPTION
3132: WHEN OTHERS THEN

Line 3190: IF (PO_LOG.d_proc) THEN

3186: l_sql VARCHAR2(4000);
3187: BEGIN
3188: d_position := 0;
3189:
3190: IF (PO_LOG.d_proc) THEN
3191: PO_LOG.proc_begin (d_module);
3192: END IF;
3193:
3194: IF (p_account_segment1 IS NULL AND p_account_segment2 IS NULL AND

Line 3191: PO_LOG.proc_begin (d_module);

3187: BEGIN
3188: d_position := 0;
3189:
3190: IF (PO_LOG.d_proc) THEN
3191: PO_LOG.proc_begin (d_module);
3192: END IF;
3193:
3194: IF (p_account_segment1 IS NULL AND p_account_segment2 IS NULL AND
3195: p_account_segment3 IS NULL AND p_account_segment4 IS NULL AND

Line 3255: IF (PO_LOG.d_stmt) THEN

3251: add_account_segment_clause('segment30', p_account_segment30, l_sql);
3252:
3253: d_position := 20;
3254:
3255: IF (PO_LOG.d_stmt) THEN
3256: PO_LOG.stmt(d_module, ' stmt to generate acct id: ' || l_sql);
3257: END IF;
3258:
3259: BEGIN

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

3252:
3253: d_position := 20;
3254:
3255: IF (PO_LOG.d_stmt) THEN
3256: PO_LOG.stmt(d_module, ' stmt to generate acct id: ' || l_sql);
3257: END IF;
3258:
3259: BEGIN
3260:

Line 3282: IF (PO_LOG.d_stmt) THEN

3278: p_account_segment27, p_account_segment28,
3279: p_account_segment29, p_account_segment30;
3280: EXCEPTION
3281: WHEN NO_DATA_FOUND THEN
3282: IF (PO_LOG.d_stmt) THEN
3283: PO_LOG.stmt(d_module, 'cannot find account id based on segments provided');
3284: END IF;
3285:
3286: x_account_id := NULL;

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

3279: p_account_segment29, p_account_segment30;
3280: EXCEPTION
3281: WHEN NO_DATA_FOUND THEN
3282: IF (PO_LOG.d_stmt) THEN
3283: PO_LOG.stmt(d_module, 'cannot find account id based on segments provided');
3284: END IF;
3285:
3286: x_account_id := NULL;
3287: END;

Line 3289: IF (PO_LOG.d_proc) THEN

3285:
3286: x_account_id := NULL;
3287: END;
3288:
3289: IF (PO_LOG.d_proc) THEN
3290: PO_LOG.proc_end (d_module);
3291: END IF;
3292:
3293: EXCEPTION

Line 3290: PO_LOG.proc_end (d_module);

3286: x_account_id := NULL;
3287: END;
3288:
3289: IF (PO_LOG.d_proc) THEN
3290: PO_LOG.proc_end (d_module);
3291: END IF;
3292:
3293: EXCEPTION
3294: WHEN OTHERS THEN

Line 3389: IF (PO_LOG.d_proc) THEN

3385: l_error_msg VARCHAR2(30);
3386: BEGIN
3387: d_position := 0;
3388:
3389: IF (PO_LOG.d_proc) THEN
3390: PO_LOG.proc_begin(d_module);
3391: END IF;
3392:
3393: IF (x_dists.project_id_tbl(p_index) IS NOT NULL OR

Line 3390: PO_LOG.proc_begin(d_module);

3386: BEGIN
3387: d_position := 0;
3388:
3389: IF (PO_LOG.d_proc) THEN
3390: PO_LOG.proc_begin(d_module);
3391: END IF;
3392:
3393: IF (x_dists.project_id_tbl(p_index) IS NOT NULL OR
3394: x_dists.project_tbl(p_index) IS NOT NULL OR

Line 3414: IF (PO_LOG.d_stmt) THEN

3410: ELSE
3411: l_error_msg := 'PO_SVC_PA_FPM_NOT_ENABLED';
3412: END IF;
3413:
3414: IF (PO_LOG.d_stmt) THEN
3415: PO_LOG.stmt(d_module, d_position, 'error_msg', l_error_msg);
3416: END IF;
3417:
3418: PO_PDOI_ERR_UTL.add_fatal_error

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

3411: l_error_msg := 'PO_SVC_PA_FPM_NOT_ENABLED';
3412: END IF;
3413:
3414: IF (PO_LOG.d_stmt) THEN
3415: PO_LOG.stmt(d_module, d_position, 'error_msg', l_error_msg);
3416: END IF;
3417:
3418: PO_PDOI_ERR_UTL.add_fatal_error
3419: (

Line 3444: IF (PO_LOG.d_stmt) THEN

3440: ELSE
3441: l_error_msg := 'PO_SVC_GMS_FPM_NOT_ENABLED';
3442: END IF;
3443:
3444: IF (PO_LOG.d_stmt) THEN
3445: PO_LOG.stmt(d_module, d_position, 'error_msg', l_error_msg);
3446: END IF;
3447:
3448: PO_PDOI_ERR_UTL.add_fatal_error

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

3441: l_error_msg := 'PO_SVC_GMS_FPM_NOT_ENABLED';
3442: END IF;
3443:
3444: IF (PO_LOG.d_stmt) THEN
3445: PO_LOG.stmt(d_module, d_position, 'error_msg', l_error_msg);
3446: END IF;
3447:
3448: PO_PDOI_ERR_UTL.add_fatal_error
3449: (

Line 3463: IF (PO_LOG.d_proc) THEN

3459:
3460: x_dists.error_flag_tbl(p_index) := FND_API.g_TRUE;
3461: END IF;
3462:
3463: IF (PO_LOG.d_proc) THEN
3464: PO_LOG.proc_end (d_module);
3465: END IF;
3466:
3467: EXCEPTION

Line 3464: PO_LOG.proc_end (d_module);

3460: x_dists.error_flag_tbl(p_index) := FND_API.g_TRUE;
3461: END IF;
3462:
3463: IF (PO_LOG.d_proc) THEN
3464: PO_LOG.proc_end (d_module);
3465: END IF;
3466:
3467: EXCEPTION
3468: WHEN OTHERS THEN

Line 3517: IF (PO_LOG.d_proc) THEN

3513: l_index NUMBER;
3514: BEGIN
3515: d_position := 0;
3516:
3517: IF (PO_LOG.d_proc) THEN
3518: PO_LOG.proc_begin(d_module);
3519:
3520: PO_LOG.proc_begin(d_module, 'p_derive_row_tbl.COUNT', p_derive_row_tbl.COUNT);
3521: l_index := p_derive_row_tbl.FIRST;

Line 3518: PO_LOG.proc_begin(d_module);

3514: BEGIN
3515: d_position := 0;
3516:
3517: IF (PO_LOG.d_proc) THEN
3518: PO_LOG.proc_begin(d_module);
3519:
3520: PO_LOG.proc_begin(d_module, 'p_derive_row_tbl.COUNT', p_derive_row_tbl.COUNT);
3521: l_index := p_derive_row_tbl.FIRST;
3522: WHILE (l_index IS NOT NULL)

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

3516:
3517: IF (PO_LOG.d_proc) THEN
3518: PO_LOG.proc_begin(d_module);
3519:
3520: PO_LOG.proc_begin(d_module, 'p_derive_row_tbl.COUNT', p_derive_row_tbl.COUNT);
3521: l_index := p_derive_row_tbl.FIRST;
3522: WHILE (l_index IS NOT NULL)
3523: LOOP
3524: PO_LOG.proc_begin(d_module, 'need to derive project info for line', l_index);

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

3520: PO_LOG.proc_begin(d_module, 'p_derive_row_tbl.COUNT', p_derive_row_tbl.COUNT);
3521: l_index := p_derive_row_tbl.FIRST;
3522: WHILE (l_index IS NOT NULL)
3523: LOOP
3524: PO_LOG.proc_begin(d_module, 'need to derive project info for line', l_index);
3525: l_index := p_derive_row_tbl.NEXT(l_index);
3526: END LOOP;
3527: END IF;
3528:

Line 3583: IF (PO_LOG.d_proc) THEN

3579: p_derive_row_tbl => p_derive_row_tbl,
3580: x_expenditure_org_id_tbl => x_dists.expenditure_org_id_tbl
3581: );
3582:
3583: IF (PO_LOG.d_proc) THEN
3584: PO_LOG.proc_end (d_module);
3585: END IF;
3586:
3587: EXCEPTION

Line 3584: PO_LOG.proc_end (d_module);

3580: x_expenditure_org_id_tbl => x_dists.expenditure_org_id_tbl
3581: );
3582:
3583: IF (PO_LOG.d_proc) THEN
3584: PO_LOG.proc_end (d_module);
3585: END IF;
3586:
3587: EXCEPTION
3588: WHEN OTHERS THEN

Line 3648: IF (PO_LOG.d_proc) THEN

3644: l_result_tbl PO_TBL_NUMBER;
3645: BEGIN
3646: d_position := 0;
3647:
3648: IF (PO_LOG.d_proc) THEN
3649: PO_LOG.proc_begin(d_module, 'p_project_tbl', p_project_tbl);
3650: PO_LOG.proc_begin(d_module, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
3651: PO_LOG.proc_begin(d_module, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
3652: PO_LOG.proc_begin(d_module, 'p_ship_to_ou_id_tbl', p_ship_to_ou_id_tbl);

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

3645: BEGIN
3646: d_position := 0;
3647:
3648: IF (PO_LOG.d_proc) THEN
3649: PO_LOG.proc_begin(d_module, 'p_project_tbl', p_project_tbl);
3650: PO_LOG.proc_begin(d_module, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
3651: PO_LOG.proc_begin(d_module, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
3652: PO_LOG.proc_begin(d_module, 'p_ship_to_ou_id_tbl', p_ship_to_ou_id_tbl);
3653: PO_LOG.proc_begin(d_module, 'x_project_id_tbl', x_project_id_tbl);

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

3646: d_position := 0;
3647:
3648: IF (PO_LOG.d_proc) THEN
3649: PO_LOG.proc_begin(d_module, 'p_project_tbl', p_project_tbl);
3650: PO_LOG.proc_begin(d_module, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
3651: PO_LOG.proc_begin(d_module, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
3652: PO_LOG.proc_begin(d_module, 'p_ship_to_ou_id_tbl', p_ship_to_ou_id_tbl);
3653: PO_LOG.proc_begin(d_module, 'x_project_id_tbl', x_project_id_tbl);
3654: END IF;

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

3647:
3648: IF (PO_LOG.d_proc) THEN
3649: PO_LOG.proc_begin(d_module, 'p_project_tbl', p_project_tbl);
3650: PO_LOG.proc_begin(d_module, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
3651: PO_LOG.proc_begin(d_module, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
3652: PO_LOG.proc_begin(d_module, 'p_ship_to_ou_id_tbl', p_ship_to_ou_id_tbl);
3653: PO_LOG.proc_begin(d_module, 'x_project_id_tbl', x_project_id_tbl);
3654: END IF;
3655:

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

3648: IF (PO_LOG.d_proc) THEN
3649: PO_LOG.proc_begin(d_module, 'p_project_tbl', p_project_tbl);
3650: PO_LOG.proc_begin(d_module, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
3651: PO_LOG.proc_begin(d_module, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
3652: PO_LOG.proc_begin(d_module, 'p_ship_to_ou_id_tbl', p_ship_to_ou_id_tbl);
3653: PO_LOG.proc_begin(d_module, 'x_project_id_tbl', x_project_id_tbl);
3654: END IF;
3655:
3656: -- query database to get derived result in batch mode

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

3649: PO_LOG.proc_begin(d_module, 'p_project_tbl', p_project_tbl);
3650: PO_LOG.proc_begin(d_module, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
3651: PO_LOG.proc_begin(d_module, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
3652: PO_LOG.proc_begin(d_module, 'p_ship_to_ou_id_tbl', p_ship_to_ou_id_tbl);
3653: PO_LOG.proc_begin(d_module, 'x_project_id_tbl', x_project_id_tbl);
3654: END IF;
3655:
3656: -- query database to get derived result in batch mode
3657: -- query different views based on value of destination_type_code

Line 3697: IF (PO_LOG.d_stmt) THEN

3693:
3694: -- set value back to x_project_id_tbl
3695: FOR i IN 1..l_index_tbl.COUNT
3696: LOOP
3697: IF (PO_LOG.d_stmt) THEN
3698: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3699: PO_LOG.stmt(d_module, d_position, 'new project id',
3700: l_result_tbl(i));
3701: END IF;

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

3694: -- set value back to x_project_id_tbl
3695: FOR i IN 1..l_index_tbl.COUNT
3696: LOOP
3697: IF (PO_LOG.d_stmt) THEN
3698: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3699: PO_LOG.stmt(d_module, d_position, 'new project id',
3700: l_result_tbl(i));
3701: END IF;
3702:

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

3695: FOR i IN 1..l_index_tbl.COUNT
3696: LOOP
3697: IF (PO_LOG.d_stmt) THEN
3698: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3699: PO_LOG.stmt(d_module, d_position, 'new project id',
3700: l_result_tbl(i));
3701: END IF;
3702:
3703: x_project_id_tbl(l_index_tbl(i)) := l_result_tbl(i);

Line 3706: IF (PO_LOG.d_proc) THEN

3702:
3703: x_project_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
3704: END LOOP;
3705:
3706: IF (PO_LOG.d_proc) THEN
3707: PO_LOG.proc_end (d_module);
3708: END IF;
3709:
3710: EXCEPTION

Line 3707: PO_LOG.proc_end (d_module);

3703: x_project_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
3704: END LOOP;
3705:
3706: IF (PO_LOG.d_proc) THEN
3707: PO_LOG.proc_end (d_module);
3708: END IF;
3709:
3710: EXCEPTION
3711: WHEN OTHERS THEN

Line 3771: IF (PO_LOG.d_proc) THEN

3767: l_result_tbl PO_TBL_NUMBER;
3768: BEGIN
3769: d_position := 0;
3770:
3771: IF (PO_LOG.d_proc) THEN
3772: PO_LOG.proc_begin(d_module, 'p_task_tbl', p_task_tbl);
3773: PO_LOG.proc_begin(d_module, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
3774: PO_LOG.proc_begin(d_module, 'p_project_id_tbl', p_project_id_tbl);
3775: PO_LOG.proc_begin(d_module, 'p_ship_to_ou_id_tbl', p_ship_to_ou_id_tbl);

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

3768: BEGIN
3769: d_position := 0;
3770:
3771: IF (PO_LOG.d_proc) THEN
3772: PO_LOG.proc_begin(d_module, 'p_task_tbl', p_task_tbl);
3773: PO_LOG.proc_begin(d_module, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
3774: PO_LOG.proc_begin(d_module, 'p_project_id_tbl', p_project_id_tbl);
3775: PO_LOG.proc_begin(d_module, 'p_ship_to_ou_id_tbl', p_ship_to_ou_id_tbl);
3776: PO_LOG.proc_begin(d_module, 'x_task_id_tbl', x_task_id_tbl);

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

3769: d_position := 0;
3770:
3771: IF (PO_LOG.d_proc) THEN
3772: PO_LOG.proc_begin(d_module, 'p_task_tbl', p_task_tbl);
3773: PO_LOG.proc_begin(d_module, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
3774: PO_LOG.proc_begin(d_module, 'p_project_id_tbl', p_project_id_tbl);
3775: PO_LOG.proc_begin(d_module, 'p_ship_to_ou_id_tbl', p_ship_to_ou_id_tbl);
3776: PO_LOG.proc_begin(d_module, 'x_task_id_tbl', x_task_id_tbl);
3777: END IF;

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

3770:
3771: IF (PO_LOG.d_proc) THEN
3772: PO_LOG.proc_begin(d_module, 'p_task_tbl', p_task_tbl);
3773: PO_LOG.proc_begin(d_module, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
3774: PO_LOG.proc_begin(d_module, 'p_project_id_tbl', p_project_id_tbl);
3775: PO_LOG.proc_begin(d_module, 'p_ship_to_ou_id_tbl', p_ship_to_ou_id_tbl);
3776: PO_LOG.proc_begin(d_module, 'x_task_id_tbl', x_task_id_tbl);
3777: END IF;
3778:

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

3771: IF (PO_LOG.d_proc) THEN
3772: PO_LOG.proc_begin(d_module, 'p_task_tbl', p_task_tbl);
3773: PO_LOG.proc_begin(d_module, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
3774: PO_LOG.proc_begin(d_module, 'p_project_id_tbl', p_project_id_tbl);
3775: PO_LOG.proc_begin(d_module, 'p_ship_to_ou_id_tbl', p_ship_to_ou_id_tbl);
3776: PO_LOG.proc_begin(d_module, 'x_task_id_tbl', x_task_id_tbl);
3777: END IF;
3778:
3779: -- query database to get derived result in batch mode

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

3772: PO_LOG.proc_begin(d_module, 'p_task_tbl', p_task_tbl);
3773: PO_LOG.proc_begin(d_module, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
3774: PO_LOG.proc_begin(d_module, 'p_project_id_tbl', p_project_id_tbl);
3775: PO_LOG.proc_begin(d_module, 'p_ship_to_ou_id_tbl', p_ship_to_ou_id_tbl);
3776: PO_LOG.proc_begin(d_module, 'x_task_id_tbl', x_task_id_tbl);
3777: END IF;
3778:
3779: -- query database to get derived result in batch mode
3780: -- query different views based on value of destination_type_code

Line 3821: IF (PO_LOG.d_stmt) THEN

3817:
3818: -- set value back to x_task_id_tbl
3819: FOR i IN 1..l_index_tbl.COUNT
3820: LOOP
3821: IF (PO_LOG.d_stmt) THEN
3822: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3823: PO_LOG.stmt(d_module, d_position, 'new task id',
3824: l_result_tbl(i));
3825: END IF;

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

3818: -- set value back to x_task_id_tbl
3819: FOR i IN 1..l_index_tbl.COUNT
3820: LOOP
3821: IF (PO_LOG.d_stmt) THEN
3822: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3823: PO_LOG.stmt(d_module, d_position, 'new task id',
3824: l_result_tbl(i));
3825: END IF;
3826:

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

3819: FOR i IN 1..l_index_tbl.COUNT
3820: LOOP
3821: IF (PO_LOG.d_stmt) THEN
3822: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3823: PO_LOG.stmt(d_module, d_position, 'new task id',
3824: l_result_tbl(i));
3825: END IF;
3826:
3827: x_task_id_tbl(l_index_tbl(i)) := l_result_tbl(i);

Line 3830: IF (PO_LOG.d_proc) THEN

3826:
3827: x_task_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
3828: END LOOP;
3829:
3830: IF (PO_LOG.d_proc) THEN
3831: PO_LOG.proc_end (d_module);
3832: END IF;
3833:
3834: EXCEPTION

Line 3831: PO_LOG.proc_end (d_module);

3827: x_task_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
3828: END LOOP;
3829:
3830: IF (PO_LOG.d_proc) THEN
3831: PO_LOG.proc_end (d_module);
3832: END IF;
3833:
3834: EXCEPTION
3835: WHEN OTHERS THEN

Line 3889: IF (PO_LOG.d_proc) THEN

3885: l_result_tbl PO_TBL_VARCHAR30;
3886: BEGIN
3887: d_position := 0;
3888:
3889: IF (PO_LOG.d_proc) THEN
3890: PO_LOG.proc_begin(d_module, 'p_expenditure_tbl', p_expenditure_tbl);
3891: PO_LOG.proc_begin(d_module, 'p_project_id_tbl', p_project_id_tbl);
3892: PO_LOG.proc_begin(d_module, 'x_expenditure_type_tbl', x_expenditure_type_tbl);
3893: END IF;

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

3886: BEGIN
3887: d_position := 0;
3888:
3889: IF (PO_LOG.d_proc) THEN
3890: PO_LOG.proc_begin(d_module, 'p_expenditure_tbl', p_expenditure_tbl);
3891: PO_LOG.proc_begin(d_module, 'p_project_id_tbl', p_project_id_tbl);
3892: PO_LOG.proc_begin(d_module, 'x_expenditure_type_tbl', x_expenditure_type_tbl);
3893: END IF;
3894:

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

3887: d_position := 0;
3888:
3889: IF (PO_LOG.d_proc) THEN
3890: PO_LOG.proc_begin(d_module, 'p_expenditure_tbl', p_expenditure_tbl);
3891: PO_LOG.proc_begin(d_module, 'p_project_id_tbl', p_project_id_tbl);
3892: PO_LOG.proc_begin(d_module, 'x_expenditure_type_tbl', x_expenditure_type_tbl);
3893: END IF;
3894:
3895: -- query database to get derived result in batch mode

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

3888:
3889: IF (PO_LOG.d_proc) THEN
3890: PO_LOG.proc_begin(d_module, 'p_expenditure_tbl', p_expenditure_tbl);
3891: PO_LOG.proc_begin(d_module, 'p_project_id_tbl', p_project_id_tbl);
3892: PO_LOG.proc_begin(d_module, 'x_expenditure_type_tbl', x_expenditure_type_tbl);
3893: END IF;
3894:
3895: -- query database to get derived result in batch mode
3896: FORALL i IN INDICES OF p_derive_row_tbl

Line 3920: IF (PO_LOG.d_stmt) THEN

3916:
3917: -- set value back to x_expenditure_type_tbl
3918: FOR i IN 1..l_index_tbl.COUNT
3919: LOOP
3920: IF (PO_LOG.d_stmt) THEN
3921: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3922: PO_LOG.stmt(d_module, d_position, 'new expenditure type',
3923: l_result_tbl(i));
3924: END IF;

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

3917: -- set value back to x_expenditure_type_tbl
3918: FOR i IN 1..l_index_tbl.COUNT
3919: LOOP
3920: IF (PO_LOG.d_stmt) THEN
3921: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3922: PO_LOG.stmt(d_module, d_position, 'new expenditure type',
3923: l_result_tbl(i));
3924: END IF;
3925:

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

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

Line 3929: IF (PO_LOG.d_proc) THEN

3925:
3926: x_expenditure_type_tbl(l_index_tbl(i)) := l_result_tbl(i);
3927: END LOOP;
3928:
3929: IF (PO_LOG.d_proc) THEN
3930: PO_LOG.proc_end (d_module);
3931: END IF;
3932:
3933: EXCEPTION

Line 3930: PO_LOG.proc_end (d_module);

3926: x_expenditure_type_tbl(l_index_tbl(i)) := l_result_tbl(i);
3927: END LOOP;
3928:
3929: IF (PO_LOG.d_proc) THEN
3930: PO_LOG.proc_end (d_module);
3931: END IF;
3932:
3933: EXCEPTION
3934: WHEN OTHERS THEN

Line 3989: IF (PO_LOG.d_proc) THEN

3985: l_result_tbl PO_TBL_NUMBER;
3986: BEGIN
3987: d_position := 0;
3988:
3989: IF (PO_LOG.d_proc) THEN
3990: PO_LOG.proc_begin(d_module, 'p_expenditure_org_tbl', p_expenditure_org_tbl);
3991: PO_LOG.proc_begin(d_module, 'p_project_id_tbl', p_project_id_tbl);
3992: PO_LOG.proc_begin(d_module, 'x_expenditure_org_id_tbl',
3993: x_expenditure_org_id_tbl);

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

3986: BEGIN
3987: d_position := 0;
3988:
3989: IF (PO_LOG.d_proc) THEN
3990: PO_LOG.proc_begin(d_module, 'p_expenditure_org_tbl', p_expenditure_org_tbl);
3991: PO_LOG.proc_begin(d_module, 'p_project_id_tbl', p_project_id_tbl);
3992: PO_LOG.proc_begin(d_module, 'x_expenditure_org_id_tbl',
3993: x_expenditure_org_id_tbl);
3994: END IF;

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

3987: d_position := 0;
3988:
3989: IF (PO_LOG.d_proc) THEN
3990: PO_LOG.proc_begin(d_module, 'p_expenditure_org_tbl', p_expenditure_org_tbl);
3991: PO_LOG.proc_begin(d_module, 'p_project_id_tbl', p_project_id_tbl);
3992: PO_LOG.proc_begin(d_module, 'x_expenditure_org_id_tbl',
3993: x_expenditure_org_id_tbl);
3994: END IF;
3995:

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

3988:
3989: IF (PO_LOG.d_proc) THEN
3990: PO_LOG.proc_begin(d_module, 'p_expenditure_org_tbl', p_expenditure_org_tbl);
3991: PO_LOG.proc_begin(d_module, 'p_project_id_tbl', p_project_id_tbl);
3992: PO_LOG.proc_begin(d_module, 'x_expenditure_org_id_tbl',
3993: x_expenditure_org_id_tbl);
3994: END IF;
3995:
3996: -- query database to get derived result in batch mode

Line 4022: IF (PO_LOG.d_stmt) THEN

4018:
4019: -- set value back to x_expenditure_org_tbl
4020: FOR i IN 1..l_index_tbl.COUNT
4021: LOOP
4022: IF (PO_LOG.d_stmt) THEN
4023: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
4024: PO_LOG.stmt(d_module, d_position, 'new expenditure org id',
4025: l_result_tbl(i));
4026: END IF;

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

4019: -- set value back to x_expenditure_org_tbl
4020: FOR i IN 1..l_index_tbl.COUNT
4021: LOOP
4022: IF (PO_LOG.d_stmt) THEN
4023: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
4024: PO_LOG.stmt(d_module, d_position, 'new expenditure org id',
4025: l_result_tbl(i));
4026: END IF;
4027:

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

4020: FOR i IN 1..l_index_tbl.COUNT
4021: LOOP
4022: IF (PO_LOG.d_stmt) THEN
4023: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
4024: PO_LOG.stmt(d_module, d_position, 'new expenditure org id',
4025: l_result_tbl(i));
4026: END IF;
4027:
4028: x_expenditure_org_id_tbl(l_index_tbl(i)) := l_result_tbl(i);

Line 4031: IF (PO_LOG.d_proc) THEN

4027:
4028: x_expenditure_org_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
4029: END LOOP;
4030:
4031: IF (PO_LOG.d_proc) THEN
4032: PO_LOG.proc_end (d_module);
4033: END IF;
4034:
4035: EXCEPTION

Line 4032: PO_LOG.proc_end (d_module);

4028: x_expenditure_org_id_tbl(l_index_tbl(i)) := l_result_tbl(i);
4029: END LOOP;
4030:
4031: IF (PO_LOG.d_proc) THEN
4032: PO_LOG.proc_end (d_module);
4033: END IF;
4034:
4035: EXCEPTION
4036: WHEN OTHERS THEN

Line 4085: IF (PO_LOG.d_proc) THEN

4081: l_result_tbl PO_TBL_VARCHAR1;
4082: BEGIN
4083: d_position := 0;
4084:
4085: IF (PO_LOG.d_proc) THEN
4086: PO_LOG.proc_begin(d_module, 'p_item_id_tbl', p_item_id_tbl);
4087: PO_LOG.proc_begin(d_module, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
4088: END IF;
4089:

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

4082: BEGIN
4083: d_position := 0;
4084:
4085: IF (PO_LOG.d_proc) THEN
4086: PO_LOG.proc_begin(d_module, 'p_item_id_tbl', p_item_id_tbl);
4087: PO_LOG.proc_begin(d_module, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
4088: END IF;
4089:
4090: -- initialize out parameter

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

4083: d_position := 0;
4084:
4085: IF (PO_LOG.d_proc) THEN
4086: PO_LOG.proc_begin(d_module, 'p_item_id_tbl', p_item_id_tbl);
4087: PO_LOG.proc_begin(d_module, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
4088: END IF;
4089:
4090: -- initialize out parameter
4091: x_item_status_tbl := PO_TBL_VARCHAR1();

Line 4117: IF (PO_LOG.d_stmt) THEN

4113:
4114: -- set value back to x_item_status_tbl
4115: FOR i IN 1..l_index_tbl.COUNT
4116: LOOP
4117: IF (PO_LOG.d_stmt) THEN
4118: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
4119: PO_LOG.stmt(d_module, d_position, 'item status',
4120: l_result_tbl(i));
4121: END IF;

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

4114: -- set value back to x_item_status_tbl
4115: FOR i IN 1..l_index_tbl.COUNT
4116: LOOP
4117: IF (PO_LOG.d_stmt) THEN
4118: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
4119: PO_LOG.stmt(d_module, d_position, 'item status',
4120: l_result_tbl(i));
4121: END IF;
4122:

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

4115: FOR i IN 1..l_index_tbl.COUNT
4116: LOOP
4117: IF (PO_LOG.d_stmt) THEN
4118: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
4119: PO_LOG.stmt(d_module, d_position, 'item status',
4120: l_result_tbl(i));
4121: END IF;
4122:
4123: x_item_status_tbl(l_index_tbl(i)) := l_result_tbl(i);

Line 4126: IF (PO_LOG.d_proc) THEN

4122:
4123: x_item_status_tbl(l_index_tbl(i)) := l_result_tbl(i);
4124: END LOOP;
4125:
4126: IF (PO_LOG.d_proc) THEN
4127: PO_LOG.proc_end (d_module);
4128: END IF;
4129:
4130: EXCEPTION

Line 4127: PO_LOG.proc_end (d_module);

4123: x_item_status_tbl(l_index_tbl(i)) := l_result_tbl(i);
4124: END LOOP;
4125:
4126: IF (PO_LOG.d_proc) THEN
4127: PO_LOG.proc_end (d_module);
4128: END IF;
4129:
4130: EXCEPTION
4131: WHEN OTHERS THEN

Line 4190: IF (PO_LOG.d_proc) THEN

4186:
4187: BEGIN
4188: d_position := 0;
4189:
4190: IF (PO_LOG.d_proc) THEN
4191: PO_LOG.proc_begin(d_module, 'p_dest_type_code', p_dest_type_code);
4192: PO_LOG.proc_begin(d_module, 'p_dest_org_id', p_dest_org_id);
4193: PO_LOG.proc_begin(d_module, 'p_dest_subinventory', p_dest_subinventory);
4194: PO_LOG.proc_begin(d_module, 'p_item_id', p_item_id);

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

4187: BEGIN
4188: d_position := 0;
4189:
4190: IF (PO_LOG.d_proc) THEN
4191: PO_LOG.proc_begin(d_module, 'p_dest_type_code', p_dest_type_code);
4192: PO_LOG.proc_begin(d_module, 'p_dest_org_id', p_dest_org_id);
4193: PO_LOG.proc_begin(d_module, 'p_dest_subinventory', p_dest_subinventory);
4194: PO_LOG.proc_begin(d_module, 'p_item_id', p_item_id);
4195: PO_LOG.proc_begin(d_module, 'p_po_encumbrance_flag', p_po_encumbrance_flag);

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

4188: d_position := 0;
4189:
4190: IF (PO_LOG.d_proc) THEN
4191: PO_LOG.proc_begin(d_module, 'p_dest_type_code', p_dest_type_code);
4192: PO_LOG.proc_begin(d_module, 'p_dest_org_id', p_dest_org_id);
4193: PO_LOG.proc_begin(d_module, 'p_dest_subinventory', p_dest_subinventory);
4194: PO_LOG.proc_begin(d_module, 'p_item_id', p_item_id);
4195: PO_LOG.proc_begin(d_module, 'p_po_encumbrance_flag', p_po_encumbrance_flag);
4196: PO_LOG.proc_begin(d_module, 'p_charge_account_id', p_charge_account_id);

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

4189:
4190: IF (PO_LOG.d_proc) THEN
4191: PO_LOG.proc_begin(d_module, 'p_dest_type_code', p_dest_type_code);
4192: PO_LOG.proc_begin(d_module, 'p_dest_org_id', p_dest_org_id);
4193: PO_LOG.proc_begin(d_module, 'p_dest_subinventory', p_dest_subinventory);
4194: PO_LOG.proc_begin(d_module, 'p_item_id', p_item_id);
4195: PO_LOG.proc_begin(d_module, 'p_po_encumbrance_flag', p_po_encumbrance_flag);
4196: PO_LOG.proc_begin(d_module, 'p_charge_account_id', p_charge_account_id);
4197: PO_LOG.proc_begin(d_module, 'x_accrual_account_id', x_accrual_account_id);

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

4190: IF (PO_LOG.d_proc) THEN
4191: PO_LOG.proc_begin(d_module, 'p_dest_type_code', p_dest_type_code);
4192: PO_LOG.proc_begin(d_module, 'p_dest_org_id', p_dest_org_id);
4193: PO_LOG.proc_begin(d_module, 'p_dest_subinventory', p_dest_subinventory);
4194: PO_LOG.proc_begin(d_module, 'p_item_id', p_item_id);
4195: PO_LOG.proc_begin(d_module, 'p_po_encumbrance_flag', p_po_encumbrance_flag);
4196: PO_LOG.proc_begin(d_module, 'p_charge_account_id', p_charge_account_id);
4197: PO_LOG.proc_begin(d_module, 'x_accrual_account_id', x_accrual_account_id);
4198: PO_LOG.proc_begin(d_module, 'x_budget_account_id', x_budget_account_id);

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

4191: PO_LOG.proc_begin(d_module, 'p_dest_type_code', p_dest_type_code);
4192: PO_LOG.proc_begin(d_module, 'p_dest_org_id', p_dest_org_id);
4193: PO_LOG.proc_begin(d_module, 'p_dest_subinventory', p_dest_subinventory);
4194: PO_LOG.proc_begin(d_module, 'p_item_id', p_item_id);
4195: PO_LOG.proc_begin(d_module, 'p_po_encumbrance_flag', p_po_encumbrance_flag);
4196: PO_LOG.proc_begin(d_module, 'p_charge_account_id', p_charge_account_id);
4197: PO_LOG.proc_begin(d_module, 'x_accrual_account_id', x_accrual_account_id);
4198: PO_LOG.proc_begin(d_module, 'x_budget_account_id', x_budget_account_id);
4199: PO_LOG.proc_begin(d_module, 'x_variance_account_id', x_variance_account_id);

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

4192: PO_LOG.proc_begin(d_module, 'p_dest_org_id', p_dest_org_id);
4193: PO_LOG.proc_begin(d_module, 'p_dest_subinventory', p_dest_subinventory);
4194: PO_LOG.proc_begin(d_module, 'p_item_id', p_item_id);
4195: PO_LOG.proc_begin(d_module, 'p_po_encumbrance_flag', p_po_encumbrance_flag);
4196: PO_LOG.proc_begin(d_module, 'p_charge_account_id', p_charge_account_id);
4197: PO_LOG.proc_begin(d_module, 'x_accrual_account_id', x_accrual_account_id);
4198: PO_LOG.proc_begin(d_module, 'x_budget_account_id', x_budget_account_id);
4199: PO_LOG.proc_begin(d_module, 'x_variance_account_id', x_variance_account_id);
4200: END IF;

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

4193: PO_LOG.proc_begin(d_module, 'p_dest_subinventory', p_dest_subinventory);
4194: PO_LOG.proc_begin(d_module, 'p_item_id', p_item_id);
4195: PO_LOG.proc_begin(d_module, 'p_po_encumbrance_flag', p_po_encumbrance_flag);
4196: PO_LOG.proc_begin(d_module, 'p_charge_account_id', p_charge_account_id);
4197: PO_LOG.proc_begin(d_module, 'x_accrual_account_id', x_accrual_account_id);
4198: PO_LOG.proc_begin(d_module, 'x_budget_account_id', x_budget_account_id);
4199: PO_LOG.proc_begin(d_module, 'x_variance_account_id', x_variance_account_id);
4200: END IF;
4201:

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

4194: PO_LOG.proc_begin(d_module, 'p_item_id', p_item_id);
4195: PO_LOG.proc_begin(d_module, 'p_po_encumbrance_flag', p_po_encumbrance_flag);
4196: PO_LOG.proc_begin(d_module, 'p_charge_account_id', p_charge_account_id);
4197: PO_LOG.proc_begin(d_module, 'x_accrual_account_id', x_accrual_account_id);
4198: PO_LOG.proc_begin(d_module, 'x_budget_account_id', x_budget_account_id);
4199: PO_LOG.proc_begin(d_module, 'x_variance_account_id', x_variance_account_id);
4200: END IF;
4201:
4202: IF (p_dest_type_code = 'EXPENSE') THEN

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

4195: PO_LOG.proc_begin(d_module, 'p_po_encumbrance_flag', p_po_encumbrance_flag);
4196: PO_LOG.proc_begin(d_module, 'p_charge_account_id', p_charge_account_id);
4197: PO_LOG.proc_begin(d_module, 'x_accrual_account_id', x_accrual_account_id);
4198: PO_LOG.proc_begin(d_module, 'x_budget_account_id', x_budget_account_id);
4199: PO_LOG.proc_begin(d_module, 'x_variance_account_id', x_variance_account_id);
4200: END IF;
4201:
4202: IF (p_dest_type_code = 'EXPENSE') THEN
4203:

Line 4311: IF (PO_LOG.d_proc) THEN

4307: END IF;
4308: END IF;
4309: END IF;
4310:
4311: IF (PO_LOG.d_proc) THEN
4312: PO_LOG.proc_end (d_module);
4313: END IF;
4314:
4315: EXCEPTION

Line 4312: PO_LOG.proc_end (d_module);

4308: END IF;
4309: END IF;
4310:
4311: IF (PO_LOG.d_proc) THEN
4312: PO_LOG.proc_end (d_module);
4313: END IF;
4314:
4315: EXCEPTION
4316: WHEN OTHERS THEN

Line 4358: IF (PO_LOG.d_proc) THEN

4354:
4355: BEGIN
4356: d_position := 0;
4357:
4358: IF (PO_LOG.d_proc) THEN
4359: PO_LOG.proc_begin(d_module);
4360: END IF;
4361:
4362: FOR i IN 1 .. x_dists.intf_dist_id_tbl.COUNT LOOP

Line 4359: PO_LOG.proc_begin(d_module);

4355: BEGIN
4356: d_position := 0;
4357:
4358: IF (PO_LOG.d_proc) THEN
4359: PO_LOG.proc_begin(d_module);
4360: END IF;
4361:
4362: FOR i IN 1 .. x_dists.intf_dist_id_tbl.COUNT LOOP
4363: l_index_tbl(x_dists.intf_dist_id_tbl(i)) := i;

Line 4370: IF (PO_LOG.d_stmt) THEN

4366: d_position := 10;
4367:
4368: FOR i IN 1 .. x_results.entity_id.COUNT LOOP
4369: IF x_results.result_type(i) = po_validations.c_result_type_failure THEN
4370: IF (PO_LOG.d_stmt) THEN
4371: PO_LOG.stmt(d_module, d_position, 'error on index',
4372: l_index_tbl(x_results.entity_id(i)));
4373: END IF;
4374:

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

4367:
4368: FOR i IN 1 .. x_results.entity_id.COUNT LOOP
4369: IF x_results.result_type(i) = po_validations.c_result_type_failure THEN
4370: IF (PO_LOG.d_stmt) THEN
4371: PO_LOG.stmt(d_module, d_position, 'error on index',
4372: l_index_tbl(x_results.entity_id(i)));
4373: END IF;
4374:
4375: x_dists.error_flag_tbl(l_index_tbl(x_results.entity_id(i))) := FND_API.g_TRUE;

Line 4379: IF (PO_LOG.d_proc) THEN

4375: x_dists.error_flag_tbl(l_index_tbl(x_results.entity_id(i))) := FND_API.g_TRUE;
4376: END IF;
4377: END LOOP;
4378:
4379: IF (PO_LOG.d_proc) THEN
4380: PO_LOG.proc_end (d_module);
4381: END IF;
4382:
4383: EXCEPTION

Line 4380: PO_LOG.proc_end (d_module);

4376: END IF;
4377: END LOOP;
4378:
4379: IF (PO_LOG.d_proc) THEN
4380: PO_LOG.proc_end (d_module);
4381: END IF;
4382:
4383: EXCEPTION
4384: WHEN OTHERS THEN