1: PACKAGE BODY PO_PDOI_PVT AS
2: /* $Header: PO_PDOI_PVT.plb 120.7.12020000.4 2013/03/29 06:32:41 xueche ship $ */
3:
4: d_pkg_name CONSTANT varchar2(50) :=
5: PO_LOG.get_package_base('PO_PDOI_PVT');
6:
7: -------------------------------------------------------
8: ----------- PRIVATE PROCEDURES PROTOTYPE --------------
9: -------------------------------------------------------
222: x_return_status := FND_API.G_RET_STS_SUCCESS;
223:
224: d_position := 0;
225:
226: IF (PO_LOG.d_proc) THEN
227: PO_LOG.proc_begin (d_module, 'p_api_version', p_api_version);
228: PO_LOG.proc_begin (d_module, 'p_init_msg_list', p_init_msg_list);
229: PO_LOG.proc_begin (d_module, 'p_validation_level', p_validation_level);
230: PO_LOG.proc_begin (d_module, 'p_commit', p_commit);
223:
224: d_position := 0;
225:
226: IF (PO_LOG.d_proc) THEN
227: PO_LOG.proc_begin (d_module, 'p_api_version', p_api_version);
228: PO_LOG.proc_begin (d_module, 'p_init_msg_list', p_init_msg_list);
229: PO_LOG.proc_begin (d_module, 'p_validation_level', p_validation_level);
230: PO_LOG.proc_begin (d_module, 'p_commit', p_commit);
231: PO_LOG.proc_begin (d_module, 'p_gather_intf_tbl_stat', p_gather_intf_tbl_stat);
224: d_position := 0;
225:
226: IF (PO_LOG.d_proc) THEN
227: PO_LOG.proc_begin (d_module, 'p_api_version', p_api_version);
228: PO_LOG.proc_begin (d_module, 'p_init_msg_list', p_init_msg_list);
229: PO_LOG.proc_begin (d_module, 'p_validation_level', p_validation_level);
230: PO_LOG.proc_begin (d_module, 'p_commit', p_commit);
231: PO_LOG.proc_begin (d_module, 'p_gather_intf_tbl_stat', p_gather_intf_tbl_stat);
232: PO_LOG.proc_begin (d_module, 'p_calling_module', p_calling_module);
225:
226: IF (PO_LOG.d_proc) THEN
227: PO_LOG.proc_begin (d_module, 'p_api_version', p_api_version);
228: PO_LOG.proc_begin (d_module, 'p_init_msg_list', p_init_msg_list);
229: PO_LOG.proc_begin (d_module, 'p_validation_level', p_validation_level);
230: PO_LOG.proc_begin (d_module, 'p_commit', p_commit);
231: PO_LOG.proc_begin (d_module, 'p_gather_intf_tbl_stat', p_gather_intf_tbl_stat);
232: PO_LOG.proc_begin (d_module, 'p_calling_module', p_calling_module);
233: PO_LOG.proc_begin (d_module, 'p_selected_batch_id', p_selected_batch_id);
226: IF (PO_LOG.d_proc) THEN
227: PO_LOG.proc_begin (d_module, 'p_api_version', p_api_version);
228: PO_LOG.proc_begin (d_module, 'p_init_msg_list', p_init_msg_list);
229: PO_LOG.proc_begin (d_module, 'p_validation_level', p_validation_level);
230: PO_LOG.proc_begin (d_module, 'p_commit', p_commit);
231: PO_LOG.proc_begin (d_module, 'p_gather_intf_tbl_stat', p_gather_intf_tbl_stat);
232: PO_LOG.proc_begin (d_module, 'p_calling_module', p_calling_module);
233: PO_LOG.proc_begin (d_module, 'p_selected_batch_id', p_selected_batch_id);
234: PO_LOG.proc_begin (d_module, 'p_batch_size', p_batch_size);
227: PO_LOG.proc_begin (d_module, 'p_api_version', p_api_version);
228: PO_LOG.proc_begin (d_module, 'p_init_msg_list', p_init_msg_list);
229: PO_LOG.proc_begin (d_module, 'p_validation_level', p_validation_level);
230: PO_LOG.proc_begin (d_module, 'p_commit', p_commit);
231: PO_LOG.proc_begin (d_module, 'p_gather_intf_tbl_stat', p_gather_intf_tbl_stat);
232: PO_LOG.proc_begin (d_module, 'p_calling_module', p_calling_module);
233: PO_LOG.proc_begin (d_module, 'p_selected_batch_id', p_selected_batch_id);
234: PO_LOG.proc_begin (d_module, 'p_batch_size', p_batch_size);
235: PO_LOG.proc_begin (d_module, 'p_buyer_id', p_buyer_id);
228: PO_LOG.proc_begin (d_module, 'p_init_msg_list', p_init_msg_list);
229: PO_LOG.proc_begin (d_module, 'p_validation_level', p_validation_level);
230: PO_LOG.proc_begin (d_module, 'p_commit', p_commit);
231: PO_LOG.proc_begin (d_module, 'p_gather_intf_tbl_stat', p_gather_intf_tbl_stat);
232: PO_LOG.proc_begin (d_module, 'p_calling_module', p_calling_module);
233: PO_LOG.proc_begin (d_module, 'p_selected_batch_id', p_selected_batch_id);
234: PO_LOG.proc_begin (d_module, 'p_batch_size', p_batch_size);
235: PO_LOG.proc_begin (d_module, 'p_buyer_id', p_buyer_id);
236: PO_LOG.proc_begin (d_module, 'p_document_type', p_document_type);
229: PO_LOG.proc_begin (d_module, 'p_validation_level', p_validation_level);
230: PO_LOG.proc_begin (d_module, 'p_commit', p_commit);
231: PO_LOG.proc_begin (d_module, 'p_gather_intf_tbl_stat', p_gather_intf_tbl_stat);
232: PO_LOG.proc_begin (d_module, 'p_calling_module', p_calling_module);
233: PO_LOG.proc_begin (d_module, 'p_selected_batch_id', p_selected_batch_id);
234: PO_LOG.proc_begin (d_module, 'p_batch_size', p_batch_size);
235: PO_LOG.proc_begin (d_module, 'p_buyer_id', p_buyer_id);
236: PO_LOG.proc_begin (d_module, 'p_document_type', p_document_type);
237: PO_LOG.proc_begin (d_module, 'p_document_subtype', p_document_subtype);
230: PO_LOG.proc_begin (d_module, 'p_commit', p_commit);
231: PO_LOG.proc_begin (d_module, 'p_gather_intf_tbl_stat', p_gather_intf_tbl_stat);
232: PO_LOG.proc_begin (d_module, 'p_calling_module', p_calling_module);
233: PO_LOG.proc_begin (d_module, 'p_selected_batch_id', p_selected_batch_id);
234: PO_LOG.proc_begin (d_module, 'p_batch_size', p_batch_size);
235: PO_LOG.proc_begin (d_module, 'p_buyer_id', p_buyer_id);
236: PO_LOG.proc_begin (d_module, 'p_document_type', p_document_type);
237: PO_LOG.proc_begin (d_module, 'p_document_subtype', p_document_subtype);
238: PO_LOG.proc_begin (d_module, 'p_create_items', p_create_items);
231: PO_LOG.proc_begin (d_module, 'p_gather_intf_tbl_stat', p_gather_intf_tbl_stat);
232: PO_LOG.proc_begin (d_module, 'p_calling_module', p_calling_module);
233: PO_LOG.proc_begin (d_module, 'p_selected_batch_id', p_selected_batch_id);
234: PO_LOG.proc_begin (d_module, 'p_batch_size', p_batch_size);
235: PO_LOG.proc_begin (d_module, 'p_buyer_id', p_buyer_id);
236: PO_LOG.proc_begin (d_module, 'p_document_type', p_document_type);
237: PO_LOG.proc_begin (d_module, 'p_document_subtype', p_document_subtype);
238: PO_LOG.proc_begin (d_module, 'p_create_items', p_create_items);
239: PO_LOG.proc_begin (d_module, 'p_create_sourcing_rules_flag', p_create_sourcing_rules_flag);
232: PO_LOG.proc_begin (d_module, 'p_calling_module', p_calling_module);
233: PO_LOG.proc_begin (d_module, 'p_selected_batch_id', p_selected_batch_id);
234: PO_LOG.proc_begin (d_module, 'p_batch_size', p_batch_size);
235: PO_LOG.proc_begin (d_module, 'p_buyer_id', p_buyer_id);
236: PO_LOG.proc_begin (d_module, 'p_document_type', p_document_type);
237: PO_LOG.proc_begin (d_module, 'p_document_subtype', p_document_subtype);
238: PO_LOG.proc_begin (d_module, 'p_create_items', p_create_items);
239: PO_LOG.proc_begin (d_module, 'p_create_sourcing_rules_flag', p_create_sourcing_rules_flag);
240: PO_LOG.proc_begin (d_module, 'p_rel_gen_method', p_rel_gen_method);
233: PO_LOG.proc_begin (d_module, 'p_selected_batch_id', p_selected_batch_id);
234: PO_LOG.proc_begin (d_module, 'p_batch_size', p_batch_size);
235: PO_LOG.proc_begin (d_module, 'p_buyer_id', p_buyer_id);
236: PO_LOG.proc_begin (d_module, 'p_document_type', p_document_type);
237: PO_LOG.proc_begin (d_module, 'p_document_subtype', p_document_subtype);
238: PO_LOG.proc_begin (d_module, 'p_create_items', p_create_items);
239: PO_LOG.proc_begin (d_module, 'p_create_sourcing_rules_flag', p_create_sourcing_rules_flag);
240: PO_LOG.proc_begin (d_module, 'p_rel_gen_method', p_rel_gen_method);
241: PO_LOG.proc_begin (d_module, 'p_sourcing_level', p_sourcing_level);
234: PO_LOG.proc_begin (d_module, 'p_batch_size', p_batch_size);
235: PO_LOG.proc_begin (d_module, 'p_buyer_id', p_buyer_id);
236: PO_LOG.proc_begin (d_module, 'p_document_type', p_document_type);
237: PO_LOG.proc_begin (d_module, 'p_document_subtype', p_document_subtype);
238: PO_LOG.proc_begin (d_module, 'p_create_items', p_create_items);
239: PO_LOG.proc_begin (d_module, 'p_create_sourcing_rules_flag', p_create_sourcing_rules_flag);
240: PO_LOG.proc_begin (d_module, 'p_rel_gen_method', p_rel_gen_method);
241: PO_LOG.proc_begin (d_module, 'p_sourcing_level', p_sourcing_level);
242: PO_LOG.proc_begin (d_module, 'p_sourcing_inv_org_id', p_sourcing_inv_org_id);
235: PO_LOG.proc_begin (d_module, 'p_buyer_id', p_buyer_id);
236: PO_LOG.proc_begin (d_module, 'p_document_type', p_document_type);
237: PO_LOG.proc_begin (d_module, 'p_document_subtype', p_document_subtype);
238: PO_LOG.proc_begin (d_module, 'p_create_items', p_create_items);
239: PO_LOG.proc_begin (d_module, 'p_create_sourcing_rules_flag', p_create_sourcing_rules_flag);
240: PO_LOG.proc_begin (d_module, 'p_rel_gen_method', p_rel_gen_method);
241: PO_LOG.proc_begin (d_module, 'p_sourcing_level', p_sourcing_level);
242: PO_LOG.proc_begin (d_module, 'p_sourcing_inv_org_id', p_sourcing_inv_org_id);
243: PO_LOG.proc_begin (d_module, 'p_approved_status', p_approved_status);
236: PO_LOG.proc_begin (d_module, 'p_document_type', p_document_type);
237: PO_LOG.proc_begin (d_module, 'p_document_subtype', p_document_subtype);
238: PO_LOG.proc_begin (d_module, 'p_create_items', p_create_items);
239: PO_LOG.proc_begin (d_module, 'p_create_sourcing_rules_flag', p_create_sourcing_rules_flag);
240: PO_LOG.proc_begin (d_module, 'p_rel_gen_method', p_rel_gen_method);
241: PO_LOG.proc_begin (d_module, 'p_sourcing_level', p_sourcing_level);
242: PO_LOG.proc_begin (d_module, 'p_sourcing_inv_org_id', p_sourcing_inv_org_id);
243: PO_LOG.proc_begin (d_module, 'p_approved_status', p_approved_status);
244: PO_LOG.proc_begin (d_module, 'p_process_code', p_process_code);
237: PO_LOG.proc_begin (d_module, 'p_document_subtype', p_document_subtype);
238: PO_LOG.proc_begin (d_module, 'p_create_items', p_create_items);
239: PO_LOG.proc_begin (d_module, 'p_create_sourcing_rules_flag', p_create_sourcing_rules_flag);
240: PO_LOG.proc_begin (d_module, 'p_rel_gen_method', p_rel_gen_method);
241: PO_LOG.proc_begin (d_module, 'p_sourcing_level', p_sourcing_level);
242: PO_LOG.proc_begin (d_module, 'p_sourcing_inv_org_id', p_sourcing_inv_org_id);
243: PO_LOG.proc_begin (d_module, 'p_approved_status', p_approved_status);
244: PO_LOG.proc_begin (d_module, 'p_process_code', p_process_code);
245: PO_LOG.proc_begin (d_module, 'p_interface_header_id', p_interface_header_id);
238: PO_LOG.proc_begin (d_module, 'p_create_items', p_create_items);
239: PO_LOG.proc_begin (d_module, 'p_create_sourcing_rules_flag', p_create_sourcing_rules_flag);
240: PO_LOG.proc_begin (d_module, 'p_rel_gen_method', p_rel_gen_method);
241: PO_LOG.proc_begin (d_module, 'p_sourcing_level', p_sourcing_level);
242: PO_LOG.proc_begin (d_module, 'p_sourcing_inv_org_id', p_sourcing_inv_org_id);
243: PO_LOG.proc_begin (d_module, 'p_approved_status', p_approved_status);
244: PO_LOG.proc_begin (d_module, 'p_process_code', p_process_code);
245: PO_LOG.proc_begin (d_module, 'p_interface_header_id', p_interface_header_id);
246: PO_LOG.proc_begin (d_module, 'p_org_id', p_org_id);
239: PO_LOG.proc_begin (d_module, 'p_create_sourcing_rules_flag', p_create_sourcing_rules_flag);
240: PO_LOG.proc_begin (d_module, 'p_rel_gen_method', p_rel_gen_method);
241: PO_LOG.proc_begin (d_module, 'p_sourcing_level', p_sourcing_level);
242: PO_LOG.proc_begin (d_module, 'p_sourcing_inv_org_id', p_sourcing_inv_org_id);
243: PO_LOG.proc_begin (d_module, 'p_approved_status', p_approved_status);
244: PO_LOG.proc_begin (d_module, 'p_process_code', p_process_code);
245: PO_LOG.proc_begin (d_module, 'p_interface_header_id', p_interface_header_id);
246: PO_LOG.proc_begin (d_module, 'p_org_id', p_org_id);
247: PO_LOG.proc_begin (d_module, 'p_ga_flag', p_ga_flag);
240: PO_LOG.proc_begin (d_module, 'p_rel_gen_method', p_rel_gen_method);
241: PO_LOG.proc_begin (d_module, 'p_sourcing_level', p_sourcing_level);
242: PO_LOG.proc_begin (d_module, 'p_sourcing_inv_org_id', p_sourcing_inv_org_id);
243: PO_LOG.proc_begin (d_module, 'p_approved_status', p_approved_status);
244: PO_LOG.proc_begin (d_module, 'p_process_code', p_process_code);
245: PO_LOG.proc_begin (d_module, 'p_interface_header_id', p_interface_header_id);
246: PO_LOG.proc_begin (d_module, 'p_org_id', p_org_id);
247: PO_LOG.proc_begin (d_module, 'p_ga_flag', p_ga_flag);
248: PO_LOG.proc_begin (d_module, 'p_submit_dft_flag', p_submit_dft_flag);
241: PO_LOG.proc_begin (d_module, 'p_sourcing_level', p_sourcing_level);
242: PO_LOG.proc_begin (d_module, 'p_sourcing_inv_org_id', p_sourcing_inv_org_id);
243: PO_LOG.proc_begin (d_module, 'p_approved_status', p_approved_status);
244: PO_LOG.proc_begin (d_module, 'p_process_code', p_process_code);
245: PO_LOG.proc_begin (d_module, 'p_interface_header_id', p_interface_header_id);
246: PO_LOG.proc_begin (d_module, 'p_org_id', p_org_id);
247: PO_LOG.proc_begin (d_module, 'p_ga_flag', p_ga_flag);
248: PO_LOG.proc_begin (d_module, 'p_submit_dft_flag', p_submit_dft_flag);
249: PO_LOG.proc_begin (d_module, 'p_role', p_role);
242: PO_LOG.proc_begin (d_module, 'p_sourcing_inv_org_id', p_sourcing_inv_org_id);
243: PO_LOG.proc_begin (d_module, 'p_approved_status', p_approved_status);
244: PO_LOG.proc_begin (d_module, 'p_process_code', p_process_code);
245: PO_LOG.proc_begin (d_module, 'p_interface_header_id', p_interface_header_id);
246: PO_LOG.proc_begin (d_module, 'p_org_id', p_org_id);
247: PO_LOG.proc_begin (d_module, 'p_ga_flag', p_ga_flag);
248: PO_LOG.proc_begin (d_module, 'p_submit_dft_flag', p_submit_dft_flag);
249: PO_LOG.proc_begin (d_module, 'p_role', p_role);
250: PO_LOG.proc_begin (d_module, 'p_catalog_to_expire', p_catalog_to_expire);
243: PO_LOG.proc_begin (d_module, 'p_approved_status', p_approved_status);
244: PO_LOG.proc_begin (d_module, 'p_process_code', p_process_code);
245: PO_LOG.proc_begin (d_module, 'p_interface_header_id', p_interface_header_id);
246: PO_LOG.proc_begin (d_module, 'p_org_id', p_org_id);
247: PO_LOG.proc_begin (d_module, 'p_ga_flag', p_ga_flag);
248: PO_LOG.proc_begin (d_module, 'p_submit_dft_flag', p_submit_dft_flag);
249: PO_LOG.proc_begin (d_module, 'p_role', p_role);
250: PO_LOG.proc_begin (d_module, 'p_catalog_to_expire', p_catalog_to_expire);
251: PO_LOG.proc_begin (d_module, 'p_err_lines_tolerance', p_err_lines_tolerance);
244: PO_LOG.proc_begin (d_module, 'p_process_code', p_process_code);
245: PO_LOG.proc_begin (d_module, 'p_interface_header_id', p_interface_header_id);
246: PO_LOG.proc_begin (d_module, 'p_org_id', p_org_id);
247: PO_LOG.proc_begin (d_module, 'p_ga_flag', p_ga_flag);
248: PO_LOG.proc_begin (d_module, 'p_submit_dft_flag', p_submit_dft_flag);
249: PO_LOG.proc_begin (d_module, 'p_role', p_role);
250: PO_LOG.proc_begin (d_module, 'p_catalog_to_expire', p_catalog_to_expire);
251: PO_LOG.proc_begin (d_module, 'p_err_lines_tolerance', p_err_lines_tolerance);
252: PO_LOG.proc_begin (d_module, 'p_clm_flag', p_clm_flag);
245: PO_LOG.proc_begin (d_module, 'p_interface_header_id', p_interface_header_id);
246: PO_LOG.proc_begin (d_module, 'p_org_id', p_org_id);
247: PO_LOG.proc_begin (d_module, 'p_ga_flag', p_ga_flag);
248: PO_LOG.proc_begin (d_module, 'p_submit_dft_flag', p_submit_dft_flag);
249: PO_LOG.proc_begin (d_module, 'p_role', p_role);
250: PO_LOG.proc_begin (d_module, 'p_catalog_to_expire', p_catalog_to_expire);
251: PO_LOG.proc_begin (d_module, 'p_err_lines_tolerance', p_err_lines_tolerance);
252: PO_LOG.proc_begin (d_module, 'p_clm_flag', p_clm_flag);
253: END IF;
246: PO_LOG.proc_begin (d_module, 'p_org_id', p_org_id);
247: PO_LOG.proc_begin (d_module, 'p_ga_flag', p_ga_flag);
248: PO_LOG.proc_begin (d_module, 'p_submit_dft_flag', p_submit_dft_flag);
249: PO_LOG.proc_begin (d_module, 'p_role', p_role);
250: PO_LOG.proc_begin (d_module, 'p_catalog_to_expire', p_catalog_to_expire);
251: PO_LOG.proc_begin (d_module, 'p_err_lines_tolerance', p_err_lines_tolerance);
252: PO_LOG.proc_begin (d_module, 'p_clm_flag', p_clm_flag);
253: END IF;
254:
247: PO_LOG.proc_begin (d_module, 'p_ga_flag', p_ga_flag);
248: PO_LOG.proc_begin (d_module, 'p_submit_dft_flag', p_submit_dft_flag);
249: PO_LOG.proc_begin (d_module, 'p_role', p_role);
250: PO_LOG.proc_begin (d_module, 'p_catalog_to_expire', p_catalog_to_expire);
251: PO_LOG.proc_begin (d_module, 'p_err_lines_tolerance', p_err_lines_tolerance);
252: PO_LOG.proc_begin (d_module, 'p_clm_flag', p_clm_flag);
253: END IF;
254:
255: PO_TIMING_UTL.init;
248: PO_LOG.proc_begin (d_module, 'p_submit_dft_flag', p_submit_dft_flag);
249: PO_LOG.proc_begin (d_module, 'p_role', p_role);
250: PO_LOG.proc_begin (d_module, 'p_catalog_to_expire', p_catalog_to_expire);
251: PO_LOG.proc_begin (d_module, 'p_err_lines_tolerance', p_err_lines_tolerance);
252: PO_LOG.proc_begin (d_module, 'p_clm_flag', p_clm_flag);
253: END IF;
254:
255: PO_TIMING_UTL.init;
256: PO_TIMING_UTL.start_time (PO_PDOI_CONSTANTS.g_T_PDOI_ALL);
368:
369: -- do interface errors reporting, log timing, etc.
370: wrap_up;
371:
372: IF (PO_LOG.d_stmt) THEN
373: PO_LOG.proc_end(d_module);
374: END IF;
375: EXCEPTION
376: WHEN OTHERS THEN
369: -- do interface errors reporting, log timing, etc.
370: wrap_up;
371:
372: IF (PO_LOG.d_stmt) THEN
373: PO_LOG.proc_end(d_module);
374: END IF;
375: EXCEPTION
376: WHEN OTHERS THEN
377: PO_MESSAGE_S.add_exc_msg
413: l_audsid NUMBER := USERENV('SESSIONID');
414: BEGIN
415: d_position := 0;
416:
417: IF (PO_LOG.d_proc) THEN
418: PO_LOG.proc_begin (d_module);
419: END IF;
420:
421: IF (PO_LOG.d_stmt) THEN
414: BEGIN
415: d_position := 0;
416:
417: IF (PO_LOG.d_proc) THEN
418: PO_LOG.proc_begin (d_module);
419: END IF;
420:
421: IF (PO_LOG.d_stmt) THEN
422: PO_LOG.stmt(d_module, d_position, 'AUDSID = ' || l_audsid);
417: IF (PO_LOG.d_proc) THEN
418: PO_LOG.proc_begin (d_module);
419: END IF;
420:
421: IF (PO_LOG.d_stmt) THEN
422: PO_LOG.stmt(d_module, d_position, 'AUDSID = ' || l_audsid);
423: END IF;
424:
425: FND_FILE.put_line(FND_FILE.log,
418: PO_LOG.proc_begin (d_module);
419: END IF;
420:
421: IF (PO_LOG.d_stmt) THEN
422: PO_LOG.stmt(d_module, d_position, 'AUDSID = ' || l_audsid);
423: END IF;
424:
425: FND_FILE.put_line(FND_FILE.log,
426: 'To get the log messages for PDOI, please use the ' ||
427: 'following id to query against FND_LOG_MESSAGES table:');
428:
429: FND_FILE.put_line(FND_FILE.log, 'AUDSID = ' || l_audsid);
430:
431: IF (PO_LOG.d_proc) THEN
432: PO_LOG.proc_end (d_module);
433: END IF;
434:
435: EXCEPTION
428:
429: FND_FILE.put_line(FND_FILE.log, 'AUDSID = ' || l_audsid);
430:
431: IF (PO_LOG.d_proc) THEN
432: PO_LOG.proc_end (d_module);
433: END IF;
434:
435: EXCEPTION
436: WHEN OTHERS THEN
487:
488: BEGIN
489: d_position := 0;
490:
491: IF (PO_LOG.d_proc) THEN
492: PO_LOG.proc_begin (d_module);
493: END IF;
494:
495: -- Setup g_request
488: BEGIN
489: d_position := 0;
490:
491: IF (PO_LOG.d_proc) THEN
492: PO_LOG.proc_begin (d_module);
493: END IF;
494:
495: -- Setup g_request
496: PO_PDOI_PARAMS.g_request.calling_module := NVL(p_calling_module, PO_PDOI_CONSTANTS.g_call_mod_UNKNOWN);
535: SELECT PO_PDOI_PROCESSING_ID_S.nextval
536: INTO PO_PDOI_PARAMS.g_processing_id
537: FROM DUAL;
538:
539: IF (PO_LOG.d_stmt) THEN
540: PO_LOG.stmt (d_module, d_position, 'g_processsing_id',
541: PO_PDOI_PARAMS.g_processing_id);
542: END IF;
543:
536: INTO PO_PDOI_PARAMS.g_processing_id
537: FROM DUAL;
538:
539: IF (PO_LOG.d_stmt) THEN
540: PO_LOG.stmt (d_module, d_position, 'g_processsing_id',
541: PO_PDOI_PARAMS.g_processing_id);
542: END IF;
543:
544: d_position := 50;
550: PO_PDOI_PARAMS.g_out.processed_lines_count := 0;
551: PO_PDOI_PARAMS.g_out.rejected_lines_count := 0;
552: PO_PDOI_PARAMS.g_out.err_tolerance_exceeded := FND_API.G_FALSE;
553:
554: IF (PO_LOG.d_proc) THEN
555: PO_LOG.proc_end (d_module);
556: END IF;
557: EXCEPTION
558: WHEN OTHERS THEN
551: PO_PDOI_PARAMS.g_out.rejected_lines_count := 0;
552: PO_PDOI_PARAMS.g_out.err_tolerance_exceeded := FND_API.G_FALSE;
553:
554: IF (PO_LOG.d_proc) THEN
555: PO_LOG.proc_end (d_module);
556: END IF;
557: EXCEPTION
558: WHEN OTHERS THEN
559: PO_MESSAGE_S.add_exc_msg
621: BEGIN
622:
623: d_position := 0;
624:
625: IF (PO_LOG.d_proc) THEN
626: PO_LOG.proc_begin (d_module);
627: END IF;
628:
629: -- po and financials system parameters
622:
623: d_position := 0;
624:
625: IF (PO_LOG.d_proc) THEN
626: PO_LOG.proc_begin (d_module);
627: END IF;
628:
629: -- po and financials system parameters
630: PO_CORE_S.get_po_parameters
747: ( p_org_id => PO_PDOI_PARAMS.g_request.org_id
748: );
749:
750: d_position := 90;
751: IF (PO_LOG.d_stmt) THEN
752: PO_LOG.stmt (d_module, d_position, 'currency_code', PO_PDOI_PARAMS.g_sys.currency_code);
753: PO_LOG.stmt (d_module, d_position, 'coa_id', PO_PDOI_PARAMS.g_sys.coa_id);
754: PO_LOG.stmt (d_module, d_position, 'po_encumbrance_flag', PO_PDOI_PARAMS.g_sys.po_encumbrance_flag);
755: PO_LOG.stmt (d_module, d_position, 'req_encumbrance_flag', PO_PDOI_PARAMS.g_sys.req_encumbrance_flag);
748: );
749:
750: d_position := 90;
751: IF (PO_LOG.d_stmt) THEN
752: PO_LOG.stmt (d_module, d_position, 'currency_code', PO_PDOI_PARAMS.g_sys.currency_code);
753: PO_LOG.stmt (d_module, d_position, 'coa_id', PO_PDOI_PARAMS.g_sys.coa_id);
754: PO_LOG.stmt (d_module, d_position, 'po_encumbrance_flag', PO_PDOI_PARAMS.g_sys.po_encumbrance_flag);
755: PO_LOG.stmt (d_module, d_position, 'req_encumbrance_flag', PO_PDOI_PARAMS.g_sys.req_encumbrance_flag);
756: PO_LOG.stmt (d_module, d_position, 'sob_id', PO_PDOI_PARAMS.g_sys.sob_id);
749:
750: d_position := 90;
751: IF (PO_LOG.d_stmt) THEN
752: PO_LOG.stmt (d_module, d_position, 'currency_code', PO_PDOI_PARAMS.g_sys.currency_code);
753: PO_LOG.stmt (d_module, d_position, 'coa_id', PO_PDOI_PARAMS.g_sys.coa_id);
754: PO_LOG.stmt (d_module, d_position, 'po_encumbrance_flag', PO_PDOI_PARAMS.g_sys.po_encumbrance_flag);
755: PO_LOG.stmt (d_module, d_position, 'req_encumbrance_flag', PO_PDOI_PARAMS.g_sys.req_encumbrance_flag);
756: PO_LOG.stmt (d_module, d_position, 'sob_id', PO_PDOI_PARAMS.g_sys.sob_id);
757: PO_LOG.stmt (d_module, d_position, 'ship_to_location_id', PO_PDOI_PARAMS.g_sys.ship_to_location_id);
750: d_position := 90;
751: IF (PO_LOG.d_stmt) THEN
752: PO_LOG.stmt (d_module, d_position, 'currency_code', PO_PDOI_PARAMS.g_sys.currency_code);
753: PO_LOG.stmt (d_module, d_position, 'coa_id', PO_PDOI_PARAMS.g_sys.coa_id);
754: PO_LOG.stmt (d_module, d_position, 'po_encumbrance_flag', PO_PDOI_PARAMS.g_sys.po_encumbrance_flag);
755: PO_LOG.stmt (d_module, d_position, 'req_encumbrance_flag', PO_PDOI_PARAMS.g_sys.req_encumbrance_flag);
756: PO_LOG.stmt (d_module, d_position, 'sob_id', PO_PDOI_PARAMS.g_sys.sob_id);
757: PO_LOG.stmt (d_module, d_position, 'ship_to_location_id', PO_PDOI_PARAMS.g_sys.ship_to_location_id);
758: PO_LOG.stmt (d_module, d_position, 'bill_to_location_id', PO_PDOI_PARAMS.g_sys.bill_to_location_id);
751: IF (PO_LOG.d_stmt) THEN
752: PO_LOG.stmt (d_module, d_position, 'currency_code', PO_PDOI_PARAMS.g_sys.currency_code);
753: PO_LOG.stmt (d_module, d_position, 'coa_id', PO_PDOI_PARAMS.g_sys.coa_id);
754: PO_LOG.stmt (d_module, d_position, 'po_encumbrance_flag', PO_PDOI_PARAMS.g_sys.po_encumbrance_flag);
755: PO_LOG.stmt (d_module, d_position, 'req_encumbrance_flag', PO_PDOI_PARAMS.g_sys.req_encumbrance_flag);
756: PO_LOG.stmt (d_module, d_position, 'sob_id', PO_PDOI_PARAMS.g_sys.sob_id);
757: PO_LOG.stmt (d_module, d_position, 'ship_to_location_id', PO_PDOI_PARAMS.g_sys.ship_to_location_id);
758: PO_LOG.stmt (d_module, d_position, 'bill_to_location_id', PO_PDOI_PARAMS.g_sys.bill_to_location_id);
759: PO_LOG.stmt (d_module, d_position, 'fob_lookup_code', PO_PDOI_PARAMS.g_sys.fob_lookup_code);
752: PO_LOG.stmt (d_module, d_position, 'currency_code', PO_PDOI_PARAMS.g_sys.currency_code);
753: PO_LOG.stmt (d_module, d_position, 'coa_id', PO_PDOI_PARAMS.g_sys.coa_id);
754: PO_LOG.stmt (d_module, d_position, 'po_encumbrance_flag', PO_PDOI_PARAMS.g_sys.po_encumbrance_flag);
755: PO_LOG.stmt (d_module, d_position, 'req_encumbrance_flag', PO_PDOI_PARAMS.g_sys.req_encumbrance_flag);
756: PO_LOG.stmt (d_module, d_position, 'sob_id', PO_PDOI_PARAMS.g_sys.sob_id);
757: PO_LOG.stmt (d_module, d_position, 'ship_to_location_id', PO_PDOI_PARAMS.g_sys.ship_to_location_id);
758: PO_LOG.stmt (d_module, d_position, 'bill_to_location_id', PO_PDOI_PARAMS.g_sys.bill_to_location_id);
759: PO_LOG.stmt (d_module, d_position, 'fob_lookup_code', PO_PDOI_PARAMS.g_sys.fob_lookup_code);
760: PO_LOG.stmt (d_module, d_position, 'freight_terms_lookup_code', PO_PDOI_PARAMS.g_sys.freight_terms_lookup_code);
753: PO_LOG.stmt (d_module, d_position, 'coa_id', PO_PDOI_PARAMS.g_sys.coa_id);
754: PO_LOG.stmt (d_module, d_position, 'po_encumbrance_flag', PO_PDOI_PARAMS.g_sys.po_encumbrance_flag);
755: PO_LOG.stmt (d_module, d_position, 'req_encumbrance_flag', PO_PDOI_PARAMS.g_sys.req_encumbrance_flag);
756: PO_LOG.stmt (d_module, d_position, 'sob_id', PO_PDOI_PARAMS.g_sys.sob_id);
757: PO_LOG.stmt (d_module, d_position, 'ship_to_location_id', PO_PDOI_PARAMS.g_sys.ship_to_location_id);
758: PO_LOG.stmt (d_module, d_position, 'bill_to_location_id', PO_PDOI_PARAMS.g_sys.bill_to_location_id);
759: PO_LOG.stmt (d_module, d_position, 'fob_lookup_code', PO_PDOI_PARAMS.g_sys.fob_lookup_code);
760: PO_LOG.stmt (d_module, d_position, 'freight_terms_lookup_code', PO_PDOI_PARAMS.g_sys.freight_terms_lookup_code);
761: PO_LOG.stmt (d_module, d_position, 'terms_id', PO_PDOI_PARAMS.g_sys.terms_id);
754: PO_LOG.stmt (d_module, d_position, 'po_encumbrance_flag', PO_PDOI_PARAMS.g_sys.po_encumbrance_flag);
755: PO_LOG.stmt (d_module, d_position, 'req_encumbrance_flag', PO_PDOI_PARAMS.g_sys.req_encumbrance_flag);
756: PO_LOG.stmt (d_module, d_position, 'sob_id', PO_PDOI_PARAMS.g_sys.sob_id);
757: PO_LOG.stmt (d_module, d_position, 'ship_to_location_id', PO_PDOI_PARAMS.g_sys.ship_to_location_id);
758: PO_LOG.stmt (d_module, d_position, 'bill_to_location_id', PO_PDOI_PARAMS.g_sys.bill_to_location_id);
759: PO_LOG.stmt (d_module, d_position, 'fob_lookup_code', PO_PDOI_PARAMS.g_sys.fob_lookup_code);
760: PO_LOG.stmt (d_module, d_position, 'freight_terms_lookup_code', PO_PDOI_PARAMS.g_sys.freight_terms_lookup_code);
761: PO_LOG.stmt (d_module, d_position, 'terms_id', PO_PDOI_PARAMS.g_sys.terms_id);
762: PO_LOG.stmt (d_module, d_position, 'default_rate_type', PO_PDOI_PARAMS.g_sys.default_rate_type);
755: PO_LOG.stmt (d_module, d_position, 'req_encumbrance_flag', PO_PDOI_PARAMS.g_sys.req_encumbrance_flag);
756: PO_LOG.stmt (d_module, d_position, 'sob_id', PO_PDOI_PARAMS.g_sys.sob_id);
757: PO_LOG.stmt (d_module, d_position, 'ship_to_location_id', PO_PDOI_PARAMS.g_sys.ship_to_location_id);
758: PO_LOG.stmt (d_module, d_position, 'bill_to_location_id', PO_PDOI_PARAMS.g_sys.bill_to_location_id);
759: PO_LOG.stmt (d_module, d_position, 'fob_lookup_code', PO_PDOI_PARAMS.g_sys.fob_lookup_code);
760: PO_LOG.stmt (d_module, d_position, 'freight_terms_lookup_code', PO_PDOI_PARAMS.g_sys.freight_terms_lookup_code);
761: PO_LOG.stmt (d_module, d_position, 'terms_id', PO_PDOI_PARAMS.g_sys.terms_id);
762: PO_LOG.stmt (d_module, d_position, 'default_rate_type', PO_PDOI_PARAMS.g_sys.default_rate_type);
763: PO_LOG.stmt (d_module, d_position, 'taxable_flag', PO_PDOI_PARAMS.g_sys.taxable_flag);
756: PO_LOG.stmt (d_module, d_position, 'sob_id', PO_PDOI_PARAMS.g_sys.sob_id);
757: PO_LOG.stmt (d_module, d_position, 'ship_to_location_id', PO_PDOI_PARAMS.g_sys.ship_to_location_id);
758: PO_LOG.stmt (d_module, d_position, 'bill_to_location_id', PO_PDOI_PARAMS.g_sys.bill_to_location_id);
759: PO_LOG.stmt (d_module, d_position, 'fob_lookup_code', PO_PDOI_PARAMS.g_sys.fob_lookup_code);
760: PO_LOG.stmt (d_module, d_position, 'freight_terms_lookup_code', PO_PDOI_PARAMS.g_sys.freight_terms_lookup_code);
761: PO_LOG.stmt (d_module, d_position, 'terms_id', PO_PDOI_PARAMS.g_sys.terms_id);
762: PO_LOG.stmt (d_module, d_position, 'default_rate_type', PO_PDOI_PARAMS.g_sys.default_rate_type);
763: PO_LOG.stmt (d_module, d_position, 'taxable_flag', PO_PDOI_PARAMS.g_sys.taxable_flag);
764: PO_LOG.stmt (d_module, d_position, 'receiving_flag', PO_PDOI_PARAMS.g_sys.receiving_flag);
757: PO_LOG.stmt (d_module, d_position, 'ship_to_location_id', PO_PDOI_PARAMS.g_sys.ship_to_location_id);
758: PO_LOG.stmt (d_module, d_position, 'bill_to_location_id', PO_PDOI_PARAMS.g_sys.bill_to_location_id);
759: PO_LOG.stmt (d_module, d_position, 'fob_lookup_code', PO_PDOI_PARAMS.g_sys.fob_lookup_code);
760: PO_LOG.stmt (d_module, d_position, 'freight_terms_lookup_code', PO_PDOI_PARAMS.g_sys.freight_terms_lookup_code);
761: PO_LOG.stmt (d_module, d_position, 'terms_id', PO_PDOI_PARAMS.g_sys.terms_id);
762: PO_LOG.stmt (d_module, d_position, 'default_rate_type', PO_PDOI_PARAMS.g_sys.default_rate_type);
763: PO_LOG.stmt (d_module, d_position, 'taxable_flag', PO_PDOI_PARAMS.g_sys.taxable_flag);
764: PO_LOG.stmt (d_module, d_position, 'receiving_flag', PO_PDOI_PARAMS.g_sys.receiving_flag);
765: PO_LOG.stmt (d_module, d_position, 'line_type_id', PO_PDOI_PARAMS.g_sys.line_type_id);
758: PO_LOG.stmt (d_module, d_position, 'bill_to_location_id', PO_PDOI_PARAMS.g_sys.bill_to_location_id);
759: PO_LOG.stmt (d_module, d_position, 'fob_lookup_code', PO_PDOI_PARAMS.g_sys.fob_lookup_code);
760: PO_LOG.stmt (d_module, d_position, 'freight_terms_lookup_code', PO_PDOI_PARAMS.g_sys.freight_terms_lookup_code);
761: PO_LOG.stmt (d_module, d_position, 'terms_id', PO_PDOI_PARAMS.g_sys.terms_id);
762: PO_LOG.stmt (d_module, d_position, 'default_rate_type', PO_PDOI_PARAMS.g_sys.default_rate_type);
763: PO_LOG.stmt (d_module, d_position, 'taxable_flag', PO_PDOI_PARAMS.g_sys.taxable_flag);
764: PO_LOG.stmt (d_module, d_position, 'receiving_flag', PO_PDOI_PARAMS.g_sys.receiving_flag);
765: PO_LOG.stmt (d_module, d_position, 'line_type_id', PO_PDOI_PARAMS.g_sys.line_type_id);
766: PO_LOG.stmt (d_module, d_position, 'manual_po_num_type', PO_PDOI_PARAMS.g_sys.manual_po_num_type);
759: PO_LOG.stmt (d_module, d_position, 'fob_lookup_code', PO_PDOI_PARAMS.g_sys.fob_lookup_code);
760: PO_LOG.stmt (d_module, d_position, 'freight_terms_lookup_code', PO_PDOI_PARAMS.g_sys.freight_terms_lookup_code);
761: PO_LOG.stmt (d_module, d_position, 'terms_id', PO_PDOI_PARAMS.g_sys.terms_id);
762: PO_LOG.stmt (d_module, d_position, 'default_rate_type', PO_PDOI_PARAMS.g_sys.default_rate_type);
763: PO_LOG.stmt (d_module, d_position, 'taxable_flag', PO_PDOI_PARAMS.g_sys.taxable_flag);
764: PO_LOG.stmt (d_module, d_position, 'receiving_flag', PO_PDOI_PARAMS.g_sys.receiving_flag);
765: PO_LOG.stmt (d_module, d_position, 'line_type_id', PO_PDOI_PARAMS.g_sys.line_type_id);
766: PO_LOG.stmt (d_module, d_position, 'manual_po_num_type', PO_PDOI_PARAMS.g_sys.manual_po_num_type);
767: PO_LOG.stmt (d_module, d_position, 'user_defined_po_num_code', PO_PDOI_PARAMS.g_sys.user_defined_po_num_code);
760: PO_LOG.stmt (d_module, d_position, 'freight_terms_lookup_code', PO_PDOI_PARAMS.g_sys.freight_terms_lookup_code);
761: PO_LOG.stmt (d_module, d_position, 'terms_id', PO_PDOI_PARAMS.g_sys.terms_id);
762: PO_LOG.stmt (d_module, d_position, 'default_rate_type', PO_PDOI_PARAMS.g_sys.default_rate_type);
763: PO_LOG.stmt (d_module, d_position, 'taxable_flag', PO_PDOI_PARAMS.g_sys.taxable_flag);
764: PO_LOG.stmt (d_module, d_position, 'receiving_flag', PO_PDOI_PARAMS.g_sys.receiving_flag);
765: PO_LOG.stmt (d_module, d_position, 'line_type_id', PO_PDOI_PARAMS.g_sys.line_type_id);
766: PO_LOG.stmt (d_module, d_position, 'manual_po_num_type', PO_PDOI_PARAMS.g_sys.manual_po_num_type);
767: PO_LOG.stmt (d_module, d_position, 'user_defined_po_num_code', PO_PDOI_PARAMS.g_sys.user_defined_po_num_code);
768: PO_LOG.stmt (d_module, d_position, 'price_type_lookup_code', PO_PDOI_PARAMS.g_sys.price_type_lookup_code);
761: PO_LOG.stmt (d_module, d_position, 'terms_id', PO_PDOI_PARAMS.g_sys.terms_id);
762: PO_LOG.stmt (d_module, d_position, 'default_rate_type', PO_PDOI_PARAMS.g_sys.default_rate_type);
763: PO_LOG.stmt (d_module, d_position, 'taxable_flag', PO_PDOI_PARAMS.g_sys.taxable_flag);
764: PO_LOG.stmt (d_module, d_position, 'receiving_flag', PO_PDOI_PARAMS.g_sys.receiving_flag);
765: PO_LOG.stmt (d_module, d_position, 'line_type_id', PO_PDOI_PARAMS.g_sys.line_type_id);
766: PO_LOG.stmt (d_module, d_position, 'manual_po_num_type', PO_PDOI_PARAMS.g_sys.manual_po_num_type);
767: PO_LOG.stmt (d_module, d_position, 'user_defined_po_num_code', PO_PDOI_PARAMS.g_sys.user_defined_po_num_code);
768: PO_LOG.stmt (d_module, d_position, 'price_type_lookup_code', PO_PDOI_PARAMS.g_sys.price_type_lookup_code);
769: PO_LOG.stmt (d_module, d_position, 'def_inv_org_id', PO_PDOI_PARAMS.g_sys.def_inv_org_id);
762: PO_LOG.stmt (d_module, d_position, 'default_rate_type', PO_PDOI_PARAMS.g_sys.default_rate_type);
763: PO_LOG.stmt (d_module, d_position, 'taxable_flag', PO_PDOI_PARAMS.g_sys.taxable_flag);
764: PO_LOG.stmt (d_module, d_position, 'receiving_flag', PO_PDOI_PARAMS.g_sys.receiving_flag);
765: PO_LOG.stmt (d_module, d_position, 'line_type_id', PO_PDOI_PARAMS.g_sys.line_type_id);
766: PO_LOG.stmt (d_module, d_position, 'manual_po_num_type', PO_PDOI_PARAMS.g_sys.manual_po_num_type);
767: PO_LOG.stmt (d_module, d_position, 'user_defined_po_num_code', PO_PDOI_PARAMS.g_sys.user_defined_po_num_code);
768: PO_LOG.stmt (d_module, d_position, 'price_type_lookup_code', PO_PDOI_PARAMS.g_sys.price_type_lookup_code);
769: PO_LOG.stmt (d_module, d_position, 'def_inv_org_id', PO_PDOI_PARAMS.g_sys.def_inv_org_id);
770: PO_LOG.stmt (d_module, d_position, 'min_rel_amount', PO_PDOI_PARAMS.g_sys.min_rel_amount);
763: PO_LOG.stmt (d_module, d_position, 'taxable_flag', PO_PDOI_PARAMS.g_sys.taxable_flag);
764: PO_LOG.stmt (d_module, d_position, 'receiving_flag', PO_PDOI_PARAMS.g_sys.receiving_flag);
765: PO_LOG.stmt (d_module, d_position, 'line_type_id', PO_PDOI_PARAMS.g_sys.line_type_id);
766: PO_LOG.stmt (d_module, d_position, 'manual_po_num_type', PO_PDOI_PARAMS.g_sys.manual_po_num_type);
767: PO_LOG.stmt (d_module, d_position, 'user_defined_po_num_code', PO_PDOI_PARAMS.g_sys.user_defined_po_num_code);
768: PO_LOG.stmt (d_module, d_position, 'price_type_lookup_code', PO_PDOI_PARAMS.g_sys.price_type_lookup_code);
769: PO_LOG.stmt (d_module, d_position, 'def_inv_org_id', PO_PDOI_PARAMS.g_sys.def_inv_org_id);
770: PO_LOG.stmt (d_module, d_position, 'min_rel_amount', PO_PDOI_PARAMS.g_sys.min_rel_amount);
771: PO_LOG.stmt (d_module, d_position, 'def_quote_warning_delay', PO_PDOI_PARAMS.g_sys.def_quote_warning_delay);
764: PO_LOG.stmt (d_module, d_position, 'receiving_flag', PO_PDOI_PARAMS.g_sys.receiving_flag);
765: PO_LOG.stmt (d_module, d_position, 'line_type_id', PO_PDOI_PARAMS.g_sys.line_type_id);
766: PO_LOG.stmt (d_module, d_position, 'manual_po_num_type', PO_PDOI_PARAMS.g_sys.manual_po_num_type);
767: PO_LOG.stmt (d_module, d_position, 'user_defined_po_num_code', PO_PDOI_PARAMS.g_sys.user_defined_po_num_code);
768: PO_LOG.stmt (d_module, d_position, 'price_type_lookup_code', PO_PDOI_PARAMS.g_sys.price_type_lookup_code);
769: PO_LOG.stmt (d_module, d_position, 'def_inv_org_id', PO_PDOI_PARAMS.g_sys.def_inv_org_id);
770: PO_LOG.stmt (d_module, d_position, 'min_rel_amount', PO_PDOI_PARAMS.g_sys.min_rel_amount);
771: PO_LOG.stmt (d_module, d_position, 'def_quote_warning_delay', PO_PDOI_PARAMS.g_sys.def_quote_warning_delay);
772: PO_LOG.stmt (d_module, d_position, 'inspection_required_flag', PO_PDOI_PARAMS.g_sys.inspection_required_flag);
765: PO_LOG.stmt (d_module, d_position, 'line_type_id', PO_PDOI_PARAMS.g_sys.line_type_id);
766: PO_LOG.stmt (d_module, d_position, 'manual_po_num_type', PO_PDOI_PARAMS.g_sys.manual_po_num_type);
767: PO_LOG.stmt (d_module, d_position, 'user_defined_po_num_code', PO_PDOI_PARAMS.g_sys.user_defined_po_num_code);
768: PO_LOG.stmt (d_module, d_position, 'price_type_lookup_code', PO_PDOI_PARAMS.g_sys.price_type_lookup_code);
769: PO_LOG.stmt (d_module, d_position, 'def_inv_org_id', PO_PDOI_PARAMS.g_sys.def_inv_org_id);
770: PO_LOG.stmt (d_module, d_position, 'min_rel_amount', PO_PDOI_PARAMS.g_sys.min_rel_amount);
771: PO_LOG.stmt (d_module, d_position, 'def_quote_warning_delay', PO_PDOI_PARAMS.g_sys.def_quote_warning_delay);
772: PO_LOG.stmt (d_module, d_position, 'inspection_required_flag', PO_PDOI_PARAMS.g_sys.inspection_required_flag);
773: PO_LOG.stmt (d_module, d_position, 'user_defined_quote_num_code', PO_PDOI_PARAMS.g_sys.user_defined_quote_num_code);
766: PO_LOG.stmt (d_module, d_position, 'manual_po_num_type', PO_PDOI_PARAMS.g_sys.manual_po_num_type);
767: PO_LOG.stmt (d_module, d_position, 'user_defined_po_num_code', PO_PDOI_PARAMS.g_sys.user_defined_po_num_code);
768: PO_LOG.stmt (d_module, d_position, 'price_type_lookup_code', PO_PDOI_PARAMS.g_sys.price_type_lookup_code);
769: PO_LOG.stmt (d_module, d_position, 'def_inv_org_id', PO_PDOI_PARAMS.g_sys.def_inv_org_id);
770: PO_LOG.stmt (d_module, d_position, 'min_rel_amount', PO_PDOI_PARAMS.g_sys.min_rel_amount);
771: PO_LOG.stmt (d_module, d_position, 'def_quote_warning_delay', PO_PDOI_PARAMS.g_sys.def_quote_warning_delay);
772: PO_LOG.stmt (d_module, d_position, 'inspection_required_flag', PO_PDOI_PARAMS.g_sys.inspection_required_flag);
773: PO_LOG.stmt (d_module, d_position, 'user_defined_quote_num_code', PO_PDOI_PARAMS.g_sys.user_defined_quote_num_code);
774: PO_LOG.stmt (d_module, d_position, 'manual_quote_num_type', PO_PDOI_PARAMS.g_sys.manual_quote_num_type);
767: PO_LOG.stmt (d_module, d_position, 'user_defined_po_num_code', PO_PDOI_PARAMS.g_sys.user_defined_po_num_code);
768: PO_LOG.stmt (d_module, d_position, 'price_type_lookup_code', PO_PDOI_PARAMS.g_sys.price_type_lookup_code);
769: PO_LOG.stmt (d_module, d_position, 'def_inv_org_id', PO_PDOI_PARAMS.g_sys.def_inv_org_id);
770: PO_LOG.stmt (d_module, d_position, 'min_rel_amount', PO_PDOI_PARAMS.g_sys.min_rel_amount);
771: PO_LOG.stmt (d_module, d_position, 'def_quote_warning_delay', PO_PDOI_PARAMS.g_sys.def_quote_warning_delay);
772: PO_LOG.stmt (d_module, d_position, 'inspection_required_flag', PO_PDOI_PARAMS.g_sys.inspection_required_flag);
773: PO_LOG.stmt (d_module, d_position, 'user_defined_quote_num_code', PO_PDOI_PARAMS.g_sys.user_defined_quote_num_code);
774: PO_LOG.stmt (d_module, d_position, 'manual_quote_num_type', PO_PDOI_PARAMS.g_sys.manual_quote_num_type);
775: PO_LOG.stmt (d_module, d_position, 'ship_via_lookup_code', PO_PDOI_PARAMS.g_sys.ship_via_lookup_code);
768: PO_LOG.stmt (d_module, d_position, 'price_type_lookup_code', PO_PDOI_PARAMS.g_sys.price_type_lookup_code);
769: PO_LOG.stmt (d_module, d_position, 'def_inv_org_id', PO_PDOI_PARAMS.g_sys.def_inv_org_id);
770: PO_LOG.stmt (d_module, d_position, 'min_rel_amount', PO_PDOI_PARAMS.g_sys.min_rel_amount);
771: PO_LOG.stmt (d_module, d_position, 'def_quote_warning_delay', PO_PDOI_PARAMS.g_sys.def_quote_warning_delay);
772: PO_LOG.stmt (d_module, d_position, 'inspection_required_flag', PO_PDOI_PARAMS.g_sys.inspection_required_flag);
773: PO_LOG.stmt (d_module, d_position, 'user_defined_quote_num_code', PO_PDOI_PARAMS.g_sys.user_defined_quote_num_code);
774: PO_LOG.stmt (d_module, d_position, 'manual_quote_num_type', PO_PDOI_PARAMS.g_sys.manual_quote_num_type);
775: PO_LOG.stmt (d_module, d_position, 'ship_via_lookup_code', PO_PDOI_PARAMS.g_sys.ship_via_lookup_code);
776: PO_LOG.stmt (d_module, d_position, 'qty_rcv_tolerance', PO_PDOI_PARAMS.g_sys.qty_rcv_tolerance);
769: PO_LOG.stmt (d_module, d_position, 'def_inv_org_id', PO_PDOI_PARAMS.g_sys.def_inv_org_id);
770: PO_LOG.stmt (d_module, d_position, 'min_rel_amount', PO_PDOI_PARAMS.g_sys.min_rel_amount);
771: PO_LOG.stmt (d_module, d_position, 'def_quote_warning_delay', PO_PDOI_PARAMS.g_sys.def_quote_warning_delay);
772: PO_LOG.stmt (d_module, d_position, 'inspection_required_flag', PO_PDOI_PARAMS.g_sys.inspection_required_flag);
773: PO_LOG.stmt (d_module, d_position, 'user_defined_quote_num_code', PO_PDOI_PARAMS.g_sys.user_defined_quote_num_code);
774: PO_LOG.stmt (d_module, d_position, 'manual_quote_num_type', PO_PDOI_PARAMS.g_sys.manual_quote_num_type);
775: PO_LOG.stmt (d_module, d_position, 'ship_via_lookup_code', PO_PDOI_PARAMS.g_sys.ship_via_lookup_code);
776: PO_LOG.stmt (d_module, d_position, 'qty_rcv_tolerance', PO_PDOI_PARAMS.g_sys.qty_rcv_tolerance);
777: PO_LOG.stmt (d_module, d_position, 'price_break_lookup_code', PO_PDOI_PARAMS.g_sys.price_break_lookup_code);
770: PO_LOG.stmt (d_module, d_position, 'min_rel_amount', PO_PDOI_PARAMS.g_sys.min_rel_amount);
771: PO_LOG.stmt (d_module, d_position, 'def_quote_warning_delay', PO_PDOI_PARAMS.g_sys.def_quote_warning_delay);
772: PO_LOG.stmt (d_module, d_position, 'inspection_required_flag', PO_PDOI_PARAMS.g_sys.inspection_required_flag);
773: PO_LOG.stmt (d_module, d_position, 'user_defined_quote_num_code', PO_PDOI_PARAMS.g_sys.user_defined_quote_num_code);
774: PO_LOG.stmt (d_module, d_position, 'manual_quote_num_type', PO_PDOI_PARAMS.g_sys.manual_quote_num_type);
775: PO_LOG.stmt (d_module, d_position, 'ship_via_lookup_code', PO_PDOI_PARAMS.g_sys.ship_via_lookup_code);
776: PO_LOG.stmt (d_module, d_position, 'qty_rcv_tolerance', PO_PDOI_PARAMS.g_sys.qty_rcv_tolerance);
777: PO_LOG.stmt (d_module, d_position, 'price_break_lookup_code', PO_PDOI_PARAMS.g_sys.price_break_lookup_code);
778: PO_LOG.stmt (d_module, d_position, 'invoice_close_tolerance', PO_PDOI_PARAMS.g_sys.invoice_close_tolerance);
771: PO_LOG.stmt (d_module, d_position, 'def_quote_warning_delay', PO_PDOI_PARAMS.g_sys.def_quote_warning_delay);
772: PO_LOG.stmt (d_module, d_position, 'inspection_required_flag', PO_PDOI_PARAMS.g_sys.inspection_required_flag);
773: PO_LOG.stmt (d_module, d_position, 'user_defined_quote_num_code', PO_PDOI_PARAMS.g_sys.user_defined_quote_num_code);
774: PO_LOG.stmt (d_module, d_position, 'manual_quote_num_type', PO_PDOI_PARAMS.g_sys.manual_quote_num_type);
775: PO_LOG.stmt (d_module, d_position, 'ship_via_lookup_code', PO_PDOI_PARAMS.g_sys.ship_via_lookup_code);
776: PO_LOG.stmt (d_module, d_position, 'qty_rcv_tolerance', PO_PDOI_PARAMS.g_sys.qty_rcv_tolerance);
777: PO_LOG.stmt (d_module, d_position, 'price_break_lookup_code', PO_PDOI_PARAMS.g_sys.price_break_lookup_code);
778: PO_LOG.stmt (d_module, d_position, 'invoice_close_tolerance', PO_PDOI_PARAMS.g_sys.invoice_close_tolerance);
779: PO_LOG.stmt (d_module, d_position, 'receive_close_tolerance', PO_PDOI_PARAMS.g_sys.receive_close_tolerance);
772: PO_LOG.stmt (d_module, d_position, 'inspection_required_flag', PO_PDOI_PARAMS.g_sys.inspection_required_flag);
773: PO_LOG.stmt (d_module, d_position, 'user_defined_quote_num_code', PO_PDOI_PARAMS.g_sys.user_defined_quote_num_code);
774: PO_LOG.stmt (d_module, d_position, 'manual_quote_num_type', PO_PDOI_PARAMS.g_sys.manual_quote_num_type);
775: PO_LOG.stmt (d_module, d_position, 'ship_via_lookup_code', PO_PDOI_PARAMS.g_sys.ship_via_lookup_code);
776: PO_LOG.stmt (d_module, d_position, 'qty_rcv_tolerance', PO_PDOI_PARAMS.g_sys.qty_rcv_tolerance);
777: PO_LOG.stmt (d_module, d_position, 'price_break_lookup_code', PO_PDOI_PARAMS.g_sys.price_break_lookup_code);
778: PO_LOG.stmt (d_module, d_position, 'invoice_close_tolerance', PO_PDOI_PARAMS.g_sys.invoice_close_tolerance);
779: PO_LOG.stmt (d_module, d_position, 'receive_close_tolerance', PO_PDOI_PARAMS.g_sys.receive_close_tolerance);
780: PO_LOG.stmt (d_module, d_position, 'expense_accrual_code', PO_PDOI_PARAMS.g_sys.expense_accrual_code);
773: PO_LOG.stmt (d_module, d_position, 'user_defined_quote_num_code', PO_PDOI_PARAMS.g_sys.user_defined_quote_num_code);
774: PO_LOG.stmt (d_module, d_position, 'manual_quote_num_type', PO_PDOI_PARAMS.g_sys.manual_quote_num_type);
775: PO_LOG.stmt (d_module, d_position, 'ship_via_lookup_code', PO_PDOI_PARAMS.g_sys.ship_via_lookup_code);
776: PO_LOG.stmt (d_module, d_position, 'qty_rcv_tolerance', PO_PDOI_PARAMS.g_sys.qty_rcv_tolerance);
777: PO_LOG.stmt (d_module, d_position, 'price_break_lookup_code', PO_PDOI_PARAMS.g_sys.price_break_lookup_code);
778: PO_LOG.stmt (d_module, d_position, 'invoice_close_tolerance', PO_PDOI_PARAMS.g_sys.invoice_close_tolerance);
779: PO_LOG.stmt (d_module, d_position, 'receive_close_tolerance', PO_PDOI_PARAMS.g_sys.receive_close_tolerance);
780: PO_LOG.stmt (d_module, d_position, 'expense_accrual_code', PO_PDOI_PARAMS.g_sys.expense_accrual_code);
781: PO_LOG.stmt (d_module, d_position, 'master_inv_org_id', PO_PDOI_PARAMS.g_sys.master_inv_org_id);
774: PO_LOG.stmt (d_module, d_position, 'manual_quote_num_type', PO_PDOI_PARAMS.g_sys.manual_quote_num_type);
775: PO_LOG.stmt (d_module, d_position, 'ship_via_lookup_code', PO_PDOI_PARAMS.g_sys.ship_via_lookup_code);
776: PO_LOG.stmt (d_module, d_position, 'qty_rcv_tolerance', PO_PDOI_PARAMS.g_sys.qty_rcv_tolerance);
777: PO_LOG.stmt (d_module, d_position, 'price_break_lookup_code', PO_PDOI_PARAMS.g_sys.price_break_lookup_code);
778: PO_LOG.stmt (d_module, d_position, 'invoice_close_tolerance', PO_PDOI_PARAMS.g_sys.invoice_close_tolerance);
779: PO_LOG.stmt (d_module, d_position, 'receive_close_tolerance', PO_PDOI_PARAMS.g_sys.receive_close_tolerance);
780: PO_LOG.stmt (d_module, d_position, 'expense_accrual_code', PO_PDOI_PARAMS.g_sys.expense_accrual_code);
781: PO_LOG.stmt (d_module, d_position, 'master_inv_org_id', PO_PDOI_PARAMS.g_sys.master_inv_org_id);
782: PO_LOG.stmt (d_module, d_position, 'enforce_ship_to_loc', PO_PDOI_PARAMS.g_sys.enforce_ship_to_loc);
775: PO_LOG.stmt (d_module, d_position, 'ship_via_lookup_code', PO_PDOI_PARAMS.g_sys.ship_via_lookup_code);
776: PO_LOG.stmt (d_module, d_position, 'qty_rcv_tolerance', PO_PDOI_PARAMS.g_sys.qty_rcv_tolerance);
777: PO_LOG.stmt (d_module, d_position, 'price_break_lookup_code', PO_PDOI_PARAMS.g_sys.price_break_lookup_code);
778: PO_LOG.stmt (d_module, d_position, 'invoice_close_tolerance', PO_PDOI_PARAMS.g_sys.invoice_close_tolerance);
779: PO_LOG.stmt (d_module, d_position, 'receive_close_tolerance', PO_PDOI_PARAMS.g_sys.receive_close_tolerance);
780: PO_LOG.stmt (d_module, d_position, 'expense_accrual_code', PO_PDOI_PARAMS.g_sys.expense_accrual_code);
781: PO_LOG.stmt (d_module, d_position, 'master_inv_org_id', PO_PDOI_PARAMS.g_sys.master_inv_org_id);
782: PO_LOG.stmt (d_module, d_position, 'enforce_ship_to_loc', PO_PDOI_PARAMS.g_sys.enforce_ship_to_loc);
783: PO_LOG.stmt (d_module, d_position, 'allow_substitutes', PO_PDOI_PARAMS.g_sys.allow_substitutes);
776: PO_LOG.stmt (d_module, d_position, 'qty_rcv_tolerance', PO_PDOI_PARAMS.g_sys.qty_rcv_tolerance);
777: PO_LOG.stmt (d_module, d_position, 'price_break_lookup_code', PO_PDOI_PARAMS.g_sys.price_break_lookup_code);
778: PO_LOG.stmt (d_module, d_position, 'invoice_close_tolerance', PO_PDOI_PARAMS.g_sys.invoice_close_tolerance);
779: PO_LOG.stmt (d_module, d_position, 'receive_close_tolerance', PO_PDOI_PARAMS.g_sys.receive_close_tolerance);
780: PO_LOG.stmt (d_module, d_position, 'expense_accrual_code', PO_PDOI_PARAMS.g_sys.expense_accrual_code);
781: PO_LOG.stmt (d_module, d_position, 'master_inv_org_id', PO_PDOI_PARAMS.g_sys.master_inv_org_id);
782: PO_LOG.stmt (d_module, d_position, 'enforce_ship_to_loc', PO_PDOI_PARAMS.g_sys.enforce_ship_to_loc);
783: PO_LOG.stmt (d_module, d_position, 'allow_substitutes', PO_PDOI_PARAMS.g_sys.allow_substitutes);
784: PO_LOG.stmt (d_module, d_position, 'routing_id', PO_PDOI_PARAMS.g_sys.routing_id);
777: PO_LOG.stmt (d_module, d_position, 'price_break_lookup_code', PO_PDOI_PARAMS.g_sys.price_break_lookup_code);
778: PO_LOG.stmt (d_module, d_position, 'invoice_close_tolerance', PO_PDOI_PARAMS.g_sys.invoice_close_tolerance);
779: PO_LOG.stmt (d_module, d_position, 'receive_close_tolerance', PO_PDOI_PARAMS.g_sys.receive_close_tolerance);
780: PO_LOG.stmt (d_module, d_position, 'expense_accrual_code', PO_PDOI_PARAMS.g_sys.expense_accrual_code);
781: PO_LOG.stmt (d_module, d_position, 'master_inv_org_id', PO_PDOI_PARAMS.g_sys.master_inv_org_id);
782: PO_LOG.stmt (d_module, d_position, 'enforce_ship_to_loc', PO_PDOI_PARAMS.g_sys.enforce_ship_to_loc);
783: PO_LOG.stmt (d_module, d_position, 'allow_substitutes', PO_PDOI_PARAMS.g_sys.allow_substitutes);
784: PO_LOG.stmt (d_module, d_position, 'routing_id', PO_PDOI_PARAMS.g_sys.routing_id);
785: PO_LOG.stmt (d_module, d_position, 'qty_rcv_exception', PO_PDOI_PARAMS.g_sys.qty_rcv_exception);
778: PO_LOG.stmt (d_module, d_position, 'invoice_close_tolerance', PO_PDOI_PARAMS.g_sys.invoice_close_tolerance);
779: PO_LOG.stmt (d_module, d_position, 'receive_close_tolerance', PO_PDOI_PARAMS.g_sys.receive_close_tolerance);
780: PO_LOG.stmt (d_module, d_position, 'expense_accrual_code', PO_PDOI_PARAMS.g_sys.expense_accrual_code);
781: PO_LOG.stmt (d_module, d_position, 'master_inv_org_id', PO_PDOI_PARAMS.g_sys.master_inv_org_id);
782: PO_LOG.stmt (d_module, d_position, 'enforce_ship_to_loc', PO_PDOI_PARAMS.g_sys.enforce_ship_to_loc);
783: PO_LOG.stmt (d_module, d_position, 'allow_substitutes', PO_PDOI_PARAMS.g_sys.allow_substitutes);
784: PO_LOG.stmt (d_module, d_position, 'routing_id', PO_PDOI_PARAMS.g_sys.routing_id);
785: PO_LOG.stmt (d_module, d_position, 'qty_rcv_exception', PO_PDOI_PARAMS.g_sys.qty_rcv_exception);
786: PO_LOG.stmt (d_module, d_position, 'days_early_receipt', PO_PDOI_PARAMS.g_sys.days_early_receipt);
779: PO_LOG.stmt (d_module, d_position, 'receive_close_tolerance', PO_PDOI_PARAMS.g_sys.receive_close_tolerance);
780: PO_LOG.stmt (d_module, d_position, 'expense_accrual_code', PO_PDOI_PARAMS.g_sys.expense_accrual_code);
781: PO_LOG.stmt (d_module, d_position, 'master_inv_org_id', PO_PDOI_PARAMS.g_sys.master_inv_org_id);
782: PO_LOG.stmt (d_module, d_position, 'enforce_ship_to_loc', PO_PDOI_PARAMS.g_sys.enforce_ship_to_loc);
783: PO_LOG.stmt (d_module, d_position, 'allow_substitutes', PO_PDOI_PARAMS.g_sys.allow_substitutes);
784: PO_LOG.stmt (d_module, d_position, 'routing_id', PO_PDOI_PARAMS.g_sys.routing_id);
785: PO_LOG.stmt (d_module, d_position, 'qty_rcv_exception', PO_PDOI_PARAMS.g_sys.qty_rcv_exception);
786: PO_LOG.stmt (d_module, d_position, 'days_early_receipt', PO_PDOI_PARAMS.g_sys.days_early_receipt);
787: PO_LOG.stmt (d_module, d_position, 'days_late_receipt', PO_PDOI_PARAMS.g_sys.days_late_receipt);
780: PO_LOG.stmt (d_module, d_position, 'expense_accrual_code', PO_PDOI_PARAMS.g_sys.expense_accrual_code);
781: PO_LOG.stmt (d_module, d_position, 'master_inv_org_id', PO_PDOI_PARAMS.g_sys.master_inv_org_id);
782: PO_LOG.stmt (d_module, d_position, 'enforce_ship_to_loc', PO_PDOI_PARAMS.g_sys.enforce_ship_to_loc);
783: PO_LOG.stmt (d_module, d_position, 'allow_substitutes', PO_PDOI_PARAMS.g_sys.allow_substitutes);
784: PO_LOG.stmt (d_module, d_position, 'routing_id', PO_PDOI_PARAMS.g_sys.routing_id);
785: PO_LOG.stmt (d_module, d_position, 'qty_rcv_exception', PO_PDOI_PARAMS.g_sys.qty_rcv_exception);
786: PO_LOG.stmt (d_module, d_position, 'days_early_receipt', PO_PDOI_PARAMS.g_sys.days_early_receipt);
787: PO_LOG.stmt (d_module, d_position, 'days_late_receipt', PO_PDOI_PARAMS.g_sys.days_late_receipt);
788: PO_LOG.stmt (d_module, d_position, 'rcv_days_exception', PO_PDOI_PARAMS.g_sys.rcv_days_exception);
781: PO_LOG.stmt (d_module, d_position, 'master_inv_org_id', PO_PDOI_PARAMS.g_sys.master_inv_org_id);
782: PO_LOG.stmt (d_module, d_position, 'enforce_ship_to_loc', PO_PDOI_PARAMS.g_sys.enforce_ship_to_loc);
783: PO_LOG.stmt (d_module, d_position, 'allow_substitutes', PO_PDOI_PARAMS.g_sys.allow_substitutes);
784: PO_LOG.stmt (d_module, d_position, 'routing_id', PO_PDOI_PARAMS.g_sys.routing_id);
785: PO_LOG.stmt (d_module, d_position, 'qty_rcv_exception', PO_PDOI_PARAMS.g_sys.qty_rcv_exception);
786: PO_LOG.stmt (d_module, d_position, 'days_early_receipt', PO_PDOI_PARAMS.g_sys.days_early_receipt);
787: PO_LOG.stmt (d_module, d_position, 'days_late_receipt', PO_PDOI_PARAMS.g_sys.days_late_receipt);
788: PO_LOG.stmt (d_module, d_position, 'rcv_days_exception', PO_PDOI_PARAMS.g_sys.rcv_days_exception);
789: PO_LOG.stmt (d_module, d_position, 'supplier_auth_acc', PO_PDOI_PARAMS.g_sys.supplier_auth_acc);
782: PO_LOG.stmt (d_module, d_position, 'enforce_ship_to_loc', PO_PDOI_PARAMS.g_sys.enforce_ship_to_loc);
783: PO_LOG.stmt (d_module, d_position, 'allow_substitutes', PO_PDOI_PARAMS.g_sys.allow_substitutes);
784: PO_LOG.stmt (d_module, d_position, 'routing_id', PO_PDOI_PARAMS.g_sys.routing_id);
785: PO_LOG.stmt (d_module, d_position, 'qty_rcv_exception', PO_PDOI_PARAMS.g_sys.qty_rcv_exception);
786: PO_LOG.stmt (d_module, d_position, 'days_early_receipt', PO_PDOI_PARAMS.g_sys.days_early_receipt);
787: PO_LOG.stmt (d_module, d_position, 'days_late_receipt', PO_PDOI_PARAMS.g_sys.days_late_receipt);
788: PO_LOG.stmt (d_module, d_position, 'rcv_days_exception', PO_PDOI_PARAMS.g_sys.rcv_days_exception);
789: PO_LOG.stmt (d_module, d_position, 'supplier_auth_acc', PO_PDOI_PARAMS.g_sys.supplier_auth_acc);
790: PO_LOG.stmt (d_module, d_position, 'cat_admin_auth_acc', PO_PDOI_PARAMS.g_sys.cat_admin_auth_acc);
783: PO_LOG.stmt (d_module, d_position, 'allow_substitutes', PO_PDOI_PARAMS.g_sys.allow_substitutes);
784: PO_LOG.stmt (d_module, d_position, 'routing_id', PO_PDOI_PARAMS.g_sys.routing_id);
785: PO_LOG.stmt (d_module, d_position, 'qty_rcv_exception', PO_PDOI_PARAMS.g_sys.qty_rcv_exception);
786: PO_LOG.stmt (d_module, d_position, 'days_early_receipt', PO_PDOI_PARAMS.g_sys.days_early_receipt);
787: PO_LOG.stmt (d_module, d_position, 'days_late_receipt', PO_PDOI_PARAMS.g_sys.days_late_receipt);
788: PO_LOG.stmt (d_module, d_position, 'rcv_days_exception', PO_PDOI_PARAMS.g_sys.rcv_days_exception);
789: PO_LOG.stmt (d_module, d_position, 'supplier_auth_acc', PO_PDOI_PARAMS.g_sys.supplier_auth_acc);
790: PO_LOG.stmt (d_module, d_position, 'cat_admin_auth_acc', PO_PDOI_PARAMS.g_sys.cat_admin_auth_acc);
791: PO_LOG.stmt (d_module, d_position, 'invoice_match_option', PO_PDOI_PARAMS.g_sys.invoice_match_option);
784: PO_LOG.stmt (d_module, d_position, 'routing_id', PO_PDOI_PARAMS.g_sys.routing_id);
785: PO_LOG.stmt (d_module, d_position, 'qty_rcv_exception', PO_PDOI_PARAMS.g_sys.qty_rcv_exception);
786: PO_LOG.stmt (d_module, d_position, 'days_early_receipt', PO_PDOI_PARAMS.g_sys.days_early_receipt);
787: PO_LOG.stmt (d_module, d_position, 'days_late_receipt', PO_PDOI_PARAMS.g_sys.days_late_receipt);
788: PO_LOG.stmt (d_module, d_position, 'rcv_days_exception', PO_PDOI_PARAMS.g_sys.rcv_days_exception);
789: PO_LOG.stmt (d_module, d_position, 'supplier_auth_acc', PO_PDOI_PARAMS.g_sys.supplier_auth_acc);
790: PO_LOG.stmt (d_module, d_position, 'cat_admin_auth_acc', PO_PDOI_PARAMS.g_sys.cat_admin_auth_acc);
791: PO_LOG.stmt (d_module, d_position, 'invoice_match_option', PO_PDOI_PARAMS.g_sys.invoice_match_option);
792: PO_LOG.stmt (d_module, d_position, 'when_to_archive_blanket', PO_PDOI_PARAMS.g_sys.when_to_archive_blanket);
785: PO_LOG.stmt (d_module, d_position, 'qty_rcv_exception', PO_PDOI_PARAMS.g_sys.qty_rcv_exception);
786: PO_LOG.stmt (d_module, d_position, 'days_early_receipt', PO_PDOI_PARAMS.g_sys.days_early_receipt);
787: PO_LOG.stmt (d_module, d_position, 'days_late_receipt', PO_PDOI_PARAMS.g_sys.days_late_receipt);
788: PO_LOG.stmt (d_module, d_position, 'rcv_days_exception', PO_PDOI_PARAMS.g_sys.rcv_days_exception);
789: PO_LOG.stmt (d_module, d_position, 'supplier_auth_acc', PO_PDOI_PARAMS.g_sys.supplier_auth_acc);
790: PO_LOG.stmt (d_module, d_position, 'cat_admin_auth_acc', PO_PDOI_PARAMS.g_sys.cat_admin_auth_acc);
791: PO_LOG.stmt (d_module, d_position, 'invoice_match_option', PO_PDOI_PARAMS.g_sys.invoice_match_option);
792: PO_LOG.stmt (d_module, d_position, 'when_to_archive_blanket', PO_PDOI_PARAMS.g_sys.when_to_archive_blanket);
793: PO_LOG.stmt (d_module, d_position, 'when_to_archive_std_po', PO_PDOI_PARAMS.g_sys.when_to_archive_std_po);
786: PO_LOG.stmt (d_module, d_position, 'days_early_receipt', PO_PDOI_PARAMS.g_sys.days_early_receipt);
787: PO_LOG.stmt (d_module, d_position, 'days_late_receipt', PO_PDOI_PARAMS.g_sys.days_late_receipt);
788: PO_LOG.stmt (d_module, d_position, 'rcv_days_exception', PO_PDOI_PARAMS.g_sys.rcv_days_exception);
789: PO_LOG.stmt (d_module, d_position, 'supplier_auth_acc', PO_PDOI_PARAMS.g_sys.supplier_auth_acc);
790: PO_LOG.stmt (d_module, d_position, 'cat_admin_auth_acc', PO_PDOI_PARAMS.g_sys.cat_admin_auth_acc);
791: PO_LOG.stmt (d_module, d_position, 'invoice_match_option', PO_PDOI_PARAMS.g_sys.invoice_match_option);
792: PO_LOG.stmt (d_module, d_position, 'when_to_archive_blanket', PO_PDOI_PARAMS.g_sys.when_to_archive_blanket);
793: PO_LOG.stmt (d_module, d_position, 'when_to_archive_std_po', PO_PDOI_PARAMS.g_sys.when_to_archive_std_po);
794: PO_LOG.stmt (d_module, d_position, 'def_business_group_id', PO_PDOI_PARAMS.g_sys.def_business_group_id);
787: PO_LOG.stmt (d_module, d_position, 'days_late_receipt', PO_PDOI_PARAMS.g_sys.days_late_receipt);
788: PO_LOG.stmt (d_module, d_position, 'rcv_days_exception', PO_PDOI_PARAMS.g_sys.rcv_days_exception);
789: PO_LOG.stmt (d_module, d_position, 'supplier_auth_acc', PO_PDOI_PARAMS.g_sys.supplier_auth_acc);
790: PO_LOG.stmt (d_module, d_position, 'cat_admin_auth_acc', PO_PDOI_PARAMS.g_sys.cat_admin_auth_acc);
791: PO_LOG.stmt (d_module, d_position, 'invoice_match_option', PO_PDOI_PARAMS.g_sys.invoice_match_option);
792: PO_LOG.stmt (d_module, d_position, 'when_to_archive_blanket', PO_PDOI_PARAMS.g_sys.when_to_archive_blanket);
793: PO_LOG.stmt (d_module, d_position, 'when_to_archive_std_po', PO_PDOI_PARAMS.g_sys.when_to_archive_std_po);
794: PO_LOG.stmt (d_module, d_position, 'def_business_group_id', PO_PDOI_PARAMS.g_sys.def_business_group_id);
795: PO_LOG.stmt (d_module, d_position, 'def_structure_id', PO_PDOI_PARAMS.g_sys.def_structure_id);
788: PO_LOG.stmt (d_module, d_position, 'rcv_days_exception', PO_PDOI_PARAMS.g_sys.rcv_days_exception);
789: PO_LOG.stmt (d_module, d_position, 'supplier_auth_acc', PO_PDOI_PARAMS.g_sys.supplier_auth_acc);
790: PO_LOG.stmt (d_module, d_position, 'cat_admin_auth_acc', PO_PDOI_PARAMS.g_sys.cat_admin_auth_acc);
791: PO_LOG.stmt (d_module, d_position, 'invoice_match_option', PO_PDOI_PARAMS.g_sys.invoice_match_option);
792: PO_LOG.stmt (d_module, d_position, 'when_to_archive_blanket', PO_PDOI_PARAMS.g_sys.when_to_archive_blanket);
793: PO_LOG.stmt (d_module, d_position, 'when_to_archive_std_po', PO_PDOI_PARAMS.g_sys.when_to_archive_std_po);
794: PO_LOG.stmt (d_module, d_position, 'def_business_group_id', PO_PDOI_PARAMS.g_sys.def_business_group_id);
795: PO_LOG.stmt (d_module, d_position, 'def_structure_id', PO_PDOI_PARAMS.g_sys.def_structure_id);
796: PO_LOG.stmt (d_module, d_position, 'def_cat_set_id', PO_PDOI_PARAMS.g_sys.def_cat_set_id);
789: PO_LOG.stmt (d_module, d_position, 'supplier_auth_acc', PO_PDOI_PARAMS.g_sys.supplier_auth_acc);
790: PO_LOG.stmt (d_module, d_position, 'cat_admin_auth_acc', PO_PDOI_PARAMS.g_sys.cat_admin_auth_acc);
791: PO_LOG.stmt (d_module, d_position, 'invoice_match_option', PO_PDOI_PARAMS.g_sys.invoice_match_option);
792: PO_LOG.stmt (d_module, d_position, 'when_to_archive_blanket', PO_PDOI_PARAMS.g_sys.when_to_archive_blanket);
793: PO_LOG.stmt (d_module, d_position, 'when_to_archive_std_po', PO_PDOI_PARAMS.g_sys.when_to_archive_std_po);
794: PO_LOG.stmt (d_module, d_position, 'def_business_group_id', PO_PDOI_PARAMS.g_sys.def_business_group_id);
795: PO_LOG.stmt (d_module, d_position, 'def_structure_id', PO_PDOI_PARAMS.g_sys.def_structure_id);
796: PO_LOG.stmt (d_module, d_position, 'def_cat_set_id', PO_PDOI_PARAMS.g_sys.def_cat_set_id);
797: PO_LOG.stmt (d_module, d_position, 'def_category_id', PO_PDOI_PARAMS.g_sys.def_category_id);
790: PO_LOG.stmt (d_module, d_position, 'cat_admin_auth_acc', PO_PDOI_PARAMS.g_sys.cat_admin_auth_acc);
791: PO_LOG.stmt (d_module, d_position, 'invoice_match_option', PO_PDOI_PARAMS.g_sys.invoice_match_option);
792: PO_LOG.stmt (d_module, d_position, 'when_to_archive_blanket', PO_PDOI_PARAMS.g_sys.when_to_archive_blanket);
793: PO_LOG.stmt (d_module, d_position, 'when_to_archive_std_po', PO_PDOI_PARAMS.g_sys.when_to_archive_std_po);
794: PO_LOG.stmt (d_module, d_position, 'def_business_group_id', PO_PDOI_PARAMS.g_sys.def_business_group_id);
795: PO_LOG.stmt (d_module, d_position, 'def_structure_id', PO_PDOI_PARAMS.g_sys.def_structure_id);
796: PO_LOG.stmt (d_module, d_position, 'def_cat_set_id', PO_PDOI_PARAMS.g_sys.def_cat_set_id);
797: PO_LOG.stmt (d_module, d_position, 'def_category_id', PO_PDOI_PARAMS.g_sys.def_category_id);
798: PO_LOG.stmt (d_module, d_position, 'is_federal_instance', PO_PDOI_PARAMS.g_sys.is_federal_instance);
791: PO_LOG.stmt (d_module, d_position, 'invoice_match_option', PO_PDOI_PARAMS.g_sys.invoice_match_option);
792: PO_LOG.stmt (d_module, d_position, 'when_to_archive_blanket', PO_PDOI_PARAMS.g_sys.when_to_archive_blanket);
793: PO_LOG.stmt (d_module, d_position, 'when_to_archive_std_po', PO_PDOI_PARAMS.g_sys.when_to_archive_std_po);
794: PO_LOG.stmt (d_module, d_position, 'def_business_group_id', PO_PDOI_PARAMS.g_sys.def_business_group_id);
795: PO_LOG.stmt (d_module, d_position, 'def_structure_id', PO_PDOI_PARAMS.g_sys.def_structure_id);
796: PO_LOG.stmt (d_module, d_position, 'def_cat_set_id', PO_PDOI_PARAMS.g_sys.def_cat_set_id);
797: PO_LOG.stmt (d_module, d_position, 'def_category_id', PO_PDOI_PARAMS.g_sys.def_category_id);
798: PO_LOG.stmt (d_module, d_position, 'is_federal_instance', PO_PDOI_PARAMS.g_sys.is_federal_instance);
799: END IF;
792: PO_LOG.stmt (d_module, d_position, 'when_to_archive_blanket', PO_PDOI_PARAMS.g_sys.when_to_archive_blanket);
793: PO_LOG.stmt (d_module, d_position, 'when_to_archive_std_po', PO_PDOI_PARAMS.g_sys.when_to_archive_std_po);
794: PO_LOG.stmt (d_module, d_position, 'def_business_group_id', PO_PDOI_PARAMS.g_sys.def_business_group_id);
795: PO_LOG.stmt (d_module, d_position, 'def_structure_id', PO_PDOI_PARAMS.g_sys.def_structure_id);
796: PO_LOG.stmt (d_module, d_position, 'def_cat_set_id', PO_PDOI_PARAMS.g_sys.def_cat_set_id);
797: PO_LOG.stmt (d_module, d_position, 'def_category_id', PO_PDOI_PARAMS.g_sys.def_category_id);
798: PO_LOG.stmt (d_module, d_position, 'is_federal_instance', PO_PDOI_PARAMS.g_sys.is_federal_instance);
799: END IF;
800:
793: PO_LOG.stmt (d_module, d_position, 'when_to_archive_std_po', PO_PDOI_PARAMS.g_sys.when_to_archive_std_po);
794: PO_LOG.stmt (d_module, d_position, 'def_business_group_id', PO_PDOI_PARAMS.g_sys.def_business_group_id);
795: PO_LOG.stmt (d_module, d_position, 'def_structure_id', PO_PDOI_PARAMS.g_sys.def_structure_id);
796: PO_LOG.stmt (d_module, d_position, 'def_cat_set_id', PO_PDOI_PARAMS.g_sys.def_cat_set_id);
797: PO_LOG.stmt (d_module, d_position, 'def_category_id', PO_PDOI_PARAMS.g_sys.def_category_id);
798: PO_LOG.stmt (d_module, d_position, 'is_federal_instance', PO_PDOI_PARAMS.g_sys.is_federal_instance);
799: END IF;
800:
801: IF (PO_LOG.d_proc) THEN
794: PO_LOG.stmt (d_module, d_position, 'def_business_group_id', PO_PDOI_PARAMS.g_sys.def_business_group_id);
795: PO_LOG.stmt (d_module, d_position, 'def_structure_id', PO_PDOI_PARAMS.g_sys.def_structure_id);
796: PO_LOG.stmt (d_module, d_position, 'def_cat_set_id', PO_PDOI_PARAMS.g_sys.def_cat_set_id);
797: PO_LOG.stmt (d_module, d_position, 'def_category_id', PO_PDOI_PARAMS.g_sys.def_category_id);
798: PO_LOG.stmt (d_module, d_position, 'is_federal_instance', PO_PDOI_PARAMS.g_sys.is_federal_instance);
799: END IF;
800:
801: IF (PO_LOG.d_proc) THEN
802: PO_LOG.proc_end (d_module);
797: PO_LOG.stmt (d_module, d_position, 'def_category_id', PO_PDOI_PARAMS.g_sys.def_category_id);
798: PO_LOG.stmt (d_module, d_position, 'is_federal_instance', PO_PDOI_PARAMS.g_sys.is_federal_instance);
799: END IF;
800:
801: IF (PO_LOG.d_proc) THEN
802: PO_LOG.proc_end (d_module);
803: END IF;
804:
805: EXCEPTION
798: PO_LOG.stmt (d_module, d_position, 'is_federal_instance', PO_PDOI_PARAMS.g_sys.is_federal_instance);
799: END IF;
800:
801: IF (PO_LOG.d_proc) THEN
802: PO_LOG.proc_end (d_module);
803: END IF;
804:
805: EXCEPTION
806: WHEN OTHERS THEN
832:
833: BEGIN
834: d_position := 0;
835:
836: IF (PO_LOG.d_proc) THEN
837: PO_LOG.proc_begin (d_module);
838: END IF;
839:
840: PO_PDOI_PARAMS.g_profile.pdoi_write_to_file :=
833: BEGIN
834: d_position := 0;
835:
836: IF (PO_LOG.d_proc) THEN
837: PO_LOG.proc_begin (d_module);
838: END IF;
839:
840: PO_PDOI_PARAMS.g_profile.pdoi_write_to_file :=
841: NVL(FND_PROFILE.value('PO_PDOI_WRITE_TO_FILE'),'N');
862: PO_PDOI_PARAMS.g_profile.allow_tax_code_override :=
863: NVL(FND_PROFILE.value('ZX_ALLOW_TAX_CLASSIF_OVERRIDE'), 'Y');
864:
865:
866: IF (PO_LOG.d_stmt) THEN
867: PO_LOG.stmt (d_module, d_position, 'pdoi_write_to_file', PO_PDOI_PARAMS.g_profile.pdoi_write_to_file);
868: PO_LOG.stmt (d_module, d_position, 'service_uom_class', PO_PDOI_PARAMS.g_profile.service_uom_class);
869: PO_LOG.stmt (d_module, d_position, 'pdoi_archive_on_approval', PO_PDOI_PARAMS.g_profile.pdoi_archive_on_approval);
870: PO_LOG.stmt (d_module, d_position, 'override_funds', PO_PDOI_PARAMS.g_profile.override_funds);
863: NVL(FND_PROFILE.value('ZX_ALLOW_TAX_CLASSIF_OVERRIDE'), 'Y');
864:
865:
866: IF (PO_LOG.d_stmt) THEN
867: PO_LOG.stmt (d_module, d_position, 'pdoi_write_to_file', PO_PDOI_PARAMS.g_profile.pdoi_write_to_file);
868: PO_LOG.stmt (d_module, d_position, 'service_uom_class', PO_PDOI_PARAMS.g_profile.service_uom_class);
869: PO_LOG.stmt (d_module, d_position, 'pdoi_archive_on_approval', PO_PDOI_PARAMS.g_profile.pdoi_archive_on_approval);
870: PO_LOG.stmt (d_module, d_position, 'override_funds', PO_PDOI_PARAMS.g_profile.override_funds);
871: PO_LOG.stmt (d_module, d_position, 'xbg', PO_PDOI_PARAMS.g_profile.xbg);
864:
865:
866: IF (PO_LOG.d_stmt) THEN
867: PO_LOG.stmt (d_module, d_position, 'pdoi_write_to_file', PO_PDOI_PARAMS.g_profile.pdoi_write_to_file);
868: PO_LOG.stmt (d_module, d_position, 'service_uom_class', PO_PDOI_PARAMS.g_profile.service_uom_class);
869: PO_LOG.stmt (d_module, d_position, 'pdoi_archive_on_approval', PO_PDOI_PARAMS.g_profile.pdoi_archive_on_approval);
870: PO_LOG.stmt (d_module, d_position, 'override_funds', PO_PDOI_PARAMS.g_profile.override_funds);
871: PO_LOG.stmt (d_module, d_position, 'xbg', PO_PDOI_PARAMS.g_profile.xbg);
872: PO_LOG.stmt (d_module, d_position, 'po_price_update_tolerance', PO_PDOI_PARAMS.g_profile.po_price_update_tolerance);
865:
866: IF (PO_LOG.d_stmt) THEN
867: PO_LOG.stmt (d_module, d_position, 'pdoi_write_to_file', PO_PDOI_PARAMS.g_profile.pdoi_write_to_file);
868: PO_LOG.stmt (d_module, d_position, 'service_uom_class', PO_PDOI_PARAMS.g_profile.service_uom_class);
869: PO_LOG.stmt (d_module, d_position, 'pdoi_archive_on_approval', PO_PDOI_PARAMS.g_profile.pdoi_archive_on_approval);
870: PO_LOG.stmt (d_module, d_position, 'override_funds', PO_PDOI_PARAMS.g_profile.override_funds);
871: PO_LOG.stmt (d_module, d_position, 'xbg', PO_PDOI_PARAMS.g_profile.xbg);
872: PO_LOG.stmt (d_module, d_position, 'po_price_update_tolerance', PO_PDOI_PARAMS.g_profile.po_price_update_tolerance);
873: PO_LOG.stmt (d_module, d_position, 'allow_tax_rate_override', PO_PDOI_PARAMS.g_profile.allow_tax_rate_override);
866: IF (PO_LOG.d_stmt) THEN
867: PO_LOG.stmt (d_module, d_position, 'pdoi_write_to_file', PO_PDOI_PARAMS.g_profile.pdoi_write_to_file);
868: PO_LOG.stmt (d_module, d_position, 'service_uom_class', PO_PDOI_PARAMS.g_profile.service_uom_class);
869: PO_LOG.stmt (d_module, d_position, 'pdoi_archive_on_approval', PO_PDOI_PARAMS.g_profile.pdoi_archive_on_approval);
870: PO_LOG.stmt (d_module, d_position, 'override_funds', PO_PDOI_PARAMS.g_profile.override_funds);
871: PO_LOG.stmt (d_module, d_position, 'xbg', PO_PDOI_PARAMS.g_profile.xbg);
872: PO_LOG.stmt (d_module, d_position, 'po_price_update_tolerance', PO_PDOI_PARAMS.g_profile.po_price_update_tolerance);
873: PO_LOG.stmt (d_module, d_position, 'allow_tax_rate_override', PO_PDOI_PARAMS.g_profile.allow_tax_rate_override);
874: PO_LOG.stmt (d_module, d_position, 'allow_tax_code_override', PO_PDOI_PARAMS.g_profile.allow_tax_code_override);
867: PO_LOG.stmt (d_module, d_position, 'pdoi_write_to_file', PO_PDOI_PARAMS.g_profile.pdoi_write_to_file);
868: PO_LOG.stmt (d_module, d_position, 'service_uom_class', PO_PDOI_PARAMS.g_profile.service_uom_class);
869: PO_LOG.stmt (d_module, d_position, 'pdoi_archive_on_approval', PO_PDOI_PARAMS.g_profile.pdoi_archive_on_approval);
870: PO_LOG.stmt (d_module, d_position, 'override_funds', PO_PDOI_PARAMS.g_profile.override_funds);
871: PO_LOG.stmt (d_module, d_position, 'xbg', PO_PDOI_PARAMS.g_profile.xbg);
872: PO_LOG.stmt (d_module, d_position, 'po_price_update_tolerance', PO_PDOI_PARAMS.g_profile.po_price_update_tolerance);
873: PO_LOG.stmt (d_module, d_position, 'allow_tax_rate_override', PO_PDOI_PARAMS.g_profile.allow_tax_rate_override);
874: PO_LOG.stmt (d_module, d_position, 'allow_tax_code_override', PO_PDOI_PARAMS.g_profile.allow_tax_code_override);
875: END IF;
868: PO_LOG.stmt (d_module, d_position, 'service_uom_class', PO_PDOI_PARAMS.g_profile.service_uom_class);
869: PO_LOG.stmt (d_module, d_position, 'pdoi_archive_on_approval', PO_PDOI_PARAMS.g_profile.pdoi_archive_on_approval);
870: PO_LOG.stmt (d_module, d_position, 'override_funds', PO_PDOI_PARAMS.g_profile.override_funds);
871: PO_LOG.stmt (d_module, d_position, 'xbg', PO_PDOI_PARAMS.g_profile.xbg);
872: PO_LOG.stmt (d_module, d_position, 'po_price_update_tolerance', PO_PDOI_PARAMS.g_profile.po_price_update_tolerance);
873: PO_LOG.stmt (d_module, d_position, 'allow_tax_rate_override', PO_PDOI_PARAMS.g_profile.allow_tax_rate_override);
874: PO_LOG.stmt (d_module, d_position, 'allow_tax_code_override', PO_PDOI_PARAMS.g_profile.allow_tax_code_override);
875: END IF;
876:
869: PO_LOG.stmt (d_module, d_position, 'pdoi_archive_on_approval', PO_PDOI_PARAMS.g_profile.pdoi_archive_on_approval);
870: PO_LOG.stmt (d_module, d_position, 'override_funds', PO_PDOI_PARAMS.g_profile.override_funds);
871: PO_LOG.stmt (d_module, d_position, 'xbg', PO_PDOI_PARAMS.g_profile.xbg);
872: PO_LOG.stmt (d_module, d_position, 'po_price_update_tolerance', PO_PDOI_PARAMS.g_profile.po_price_update_tolerance);
873: PO_LOG.stmt (d_module, d_position, 'allow_tax_rate_override', PO_PDOI_PARAMS.g_profile.allow_tax_rate_override);
874: PO_LOG.stmt (d_module, d_position, 'allow_tax_code_override', PO_PDOI_PARAMS.g_profile.allow_tax_code_override);
875: END IF;
876:
877: IF (PO_LOG.d_proc) THEN
870: PO_LOG.stmt (d_module, d_position, 'override_funds', PO_PDOI_PARAMS.g_profile.override_funds);
871: PO_LOG.stmt (d_module, d_position, 'xbg', PO_PDOI_PARAMS.g_profile.xbg);
872: PO_LOG.stmt (d_module, d_position, 'po_price_update_tolerance', PO_PDOI_PARAMS.g_profile.po_price_update_tolerance);
873: PO_LOG.stmt (d_module, d_position, 'allow_tax_rate_override', PO_PDOI_PARAMS.g_profile.allow_tax_rate_override);
874: PO_LOG.stmt (d_module, d_position, 'allow_tax_code_override', PO_PDOI_PARAMS.g_profile.allow_tax_code_override);
875: END IF;
876:
877: IF (PO_LOG.d_proc) THEN
878: PO_LOG.proc_end (d_module);
873: PO_LOG.stmt (d_module, d_position, 'allow_tax_rate_override', PO_PDOI_PARAMS.g_profile.allow_tax_rate_override);
874: PO_LOG.stmt (d_module, d_position, 'allow_tax_code_override', PO_PDOI_PARAMS.g_profile.allow_tax_code_override);
875: END IF;
876:
877: IF (PO_LOG.d_proc) THEN
878: PO_LOG.proc_end (d_module);
879: END IF;
880:
881: EXCEPTION
874: PO_LOG.stmt (d_module, d_position, 'allow_tax_code_override', PO_PDOI_PARAMS.g_profile.allow_tax_code_override);
875: END IF;
876:
877: IF (PO_LOG.d_proc) THEN
878: PO_LOG.proc_end (d_module);
879: END IF;
880:
881: EXCEPTION
882: WHEN OTHERS THEN
907:
908: BEGIN
909: d_position := 0;
910:
911: IF (PO_LOG.d_proc) THEN
912: PO_LOG.proc_begin (d_module);
913: END IF;
914:
915: IF (PO_CORE_S.get_product_install_status('WIP') = 'I') THEN
908: BEGIN
909: d_position := 0;
910:
911: IF (PO_LOG.d_proc) THEN
912: PO_LOG.proc_begin (d_module);
913: END IF;
914:
915: IF (PO_CORE_S.get_product_install_status('WIP') = 'I') THEN
916: PO_PDOI_PARAMS.g_product.wip_installed := FND_API.G_TRUE;
947: ELSE
948: PO_PDOI_PARAMS.g_product.project_cwk_installed := FND_API.G_FALSE;
949: END IF;
950:
951: IF (PO_LOG.d_stmt) THEN
952: PO_LOG.stmt (d_module, d_position, 'wip_installed', PO_PDOI_PARAMS.g_product.wip_installed);
953: PO_LOG.stmt (d_module, d_position, 'inv_installed', PO_PDOI_PARAMS.g_product.inv_installed);
954: PO_LOG.stmt (d_module, d_position, 'project_11510_installed', PO_PDOI_PARAMS.g_product.project_11510_installed);
955: PO_LOG.stmt (d_module, d_position, 'pa_installed', PO_PDOI_PARAMS.g_product.pa_installed);
948: PO_PDOI_PARAMS.g_product.project_cwk_installed := FND_API.G_FALSE;
949: END IF;
950:
951: IF (PO_LOG.d_stmt) THEN
952: PO_LOG.stmt (d_module, d_position, 'wip_installed', PO_PDOI_PARAMS.g_product.wip_installed);
953: PO_LOG.stmt (d_module, d_position, 'inv_installed', PO_PDOI_PARAMS.g_product.inv_installed);
954: PO_LOG.stmt (d_module, d_position, 'project_11510_installed', PO_PDOI_PARAMS.g_product.project_11510_installed);
955: PO_LOG.stmt (d_module, d_position, 'pa_installed', PO_PDOI_PARAMS.g_product.pa_installed);
956: PO_LOG.stmt (d_module, d_position, 'gms_enabled', PO_PDOI_PARAMS.g_product.gms_enabled);
949: END IF;
950:
951: IF (PO_LOG.d_stmt) THEN
952: PO_LOG.stmt (d_module, d_position, 'wip_installed', PO_PDOI_PARAMS.g_product.wip_installed);
953: PO_LOG.stmt (d_module, d_position, 'inv_installed', PO_PDOI_PARAMS.g_product.inv_installed);
954: PO_LOG.stmt (d_module, d_position, 'project_11510_installed', PO_PDOI_PARAMS.g_product.project_11510_installed);
955: PO_LOG.stmt (d_module, d_position, 'pa_installed', PO_PDOI_PARAMS.g_product.pa_installed);
956: PO_LOG.stmt (d_module, d_position, 'gms_enabled', PO_PDOI_PARAMS.g_product.gms_enabled);
957: PO_LOG.stmt (d_module, d_position, 'project_cwk_installed', PO_PDOI_PARAMS.g_product.project_cwk_installed);
950:
951: IF (PO_LOG.d_stmt) THEN
952: PO_LOG.stmt (d_module, d_position, 'wip_installed', PO_PDOI_PARAMS.g_product.wip_installed);
953: PO_LOG.stmt (d_module, d_position, 'inv_installed', PO_PDOI_PARAMS.g_product.inv_installed);
954: PO_LOG.stmt (d_module, d_position, 'project_11510_installed', PO_PDOI_PARAMS.g_product.project_11510_installed);
955: PO_LOG.stmt (d_module, d_position, 'pa_installed', PO_PDOI_PARAMS.g_product.pa_installed);
956: PO_LOG.stmt (d_module, d_position, 'gms_enabled', PO_PDOI_PARAMS.g_product.gms_enabled);
957: PO_LOG.stmt (d_module, d_position, 'project_cwk_installed', PO_PDOI_PARAMS.g_product.project_cwk_installed);
958: END IF;
951: IF (PO_LOG.d_stmt) THEN
952: PO_LOG.stmt (d_module, d_position, 'wip_installed', PO_PDOI_PARAMS.g_product.wip_installed);
953: PO_LOG.stmt (d_module, d_position, 'inv_installed', PO_PDOI_PARAMS.g_product.inv_installed);
954: PO_LOG.stmt (d_module, d_position, 'project_11510_installed', PO_PDOI_PARAMS.g_product.project_11510_installed);
955: PO_LOG.stmt (d_module, d_position, 'pa_installed', PO_PDOI_PARAMS.g_product.pa_installed);
956: PO_LOG.stmt (d_module, d_position, 'gms_enabled', PO_PDOI_PARAMS.g_product.gms_enabled);
957: PO_LOG.stmt (d_module, d_position, 'project_cwk_installed', PO_PDOI_PARAMS.g_product.project_cwk_installed);
958: END IF;
959:
952: PO_LOG.stmt (d_module, d_position, 'wip_installed', PO_PDOI_PARAMS.g_product.wip_installed);
953: PO_LOG.stmt (d_module, d_position, 'inv_installed', PO_PDOI_PARAMS.g_product.inv_installed);
954: PO_LOG.stmt (d_module, d_position, 'project_11510_installed', PO_PDOI_PARAMS.g_product.project_11510_installed);
955: PO_LOG.stmt (d_module, d_position, 'pa_installed', PO_PDOI_PARAMS.g_product.pa_installed);
956: PO_LOG.stmt (d_module, d_position, 'gms_enabled', PO_PDOI_PARAMS.g_product.gms_enabled);
957: PO_LOG.stmt (d_module, d_position, 'project_cwk_installed', PO_PDOI_PARAMS.g_product.project_cwk_installed);
958: END IF;
959:
960: IF (PO_LOG.d_proc) THEN
953: PO_LOG.stmt (d_module, d_position, 'inv_installed', PO_PDOI_PARAMS.g_product.inv_installed);
954: PO_LOG.stmt (d_module, d_position, 'project_11510_installed', PO_PDOI_PARAMS.g_product.project_11510_installed);
955: PO_LOG.stmt (d_module, d_position, 'pa_installed', PO_PDOI_PARAMS.g_product.pa_installed);
956: PO_LOG.stmt (d_module, d_position, 'gms_enabled', PO_PDOI_PARAMS.g_product.gms_enabled);
957: PO_LOG.stmt (d_module, d_position, 'project_cwk_installed', PO_PDOI_PARAMS.g_product.project_cwk_installed);
958: END IF;
959:
960: IF (PO_LOG.d_proc) THEN
961: PO_LOG.proc_end (d_module);
956: PO_LOG.stmt (d_module, d_position, 'gms_enabled', PO_PDOI_PARAMS.g_product.gms_enabled);
957: PO_LOG.stmt (d_module, d_position, 'project_cwk_installed', PO_PDOI_PARAMS.g_product.project_cwk_installed);
958: END IF;
959:
960: IF (PO_LOG.d_proc) THEN
961: PO_LOG.proc_end (d_module);
962: END IF;
963: EXCEPTION
964: WHEN OTHERS THEN
957: PO_LOG.stmt (d_module, d_position, 'project_cwk_installed', PO_PDOI_PARAMS.g_product.project_cwk_installed);
958: END IF;
959:
960: IF (PO_LOG.d_proc) THEN
961: PO_LOG.proc_end (d_module);
962: END IF;
963: EXCEPTION
964: WHEN OTHERS THEN
965: PO_MESSAGE_S.add_exc_msg
1043:
1044: BEGIN
1045: d_position := 0;
1046:
1047: IF (PO_LOG.d_proc) THEN
1048: PO_LOG.proc_begin (d_module);
1049: END IF;
1050:
1051: PO_TIMING_UTL.start_time (PO_PDOI_CONSTANTS.g_T_GATHER_TBL_STAT);
1044: BEGIN
1045: d_position := 0;
1046:
1047: IF (PO_LOG.d_proc) THEN
1048: PO_LOG.proc_begin (d_module);
1049: END IF;
1050:
1051: PO_TIMING_UTL.start_time (PO_PDOI_CONSTANTS.g_T_GATHER_TBL_STAT);
1052:
1103: );
1104: ELSE
1105: d_position := 80;
1106:
1107: IF (PO_LOG.d_stmt) THEN
1108: PO_LOG.stmt(d_module, d_position, 'Cannot get appl info. ' ||
1109: 'No stat gathering');
1110: END IF;
1111: END IF;
1104: ELSE
1105: d_position := 80;
1106:
1107: IF (PO_LOG.d_stmt) THEN
1108: PO_LOG.stmt(d_module, d_position, 'Cannot get appl info. ' ||
1109: 'No stat gathering');
1110: END IF;
1111: END IF;
1112:
1111: END IF;
1112:
1113: PO_TIMING_UTL.stop_time (PO_PDOI_CONSTANTS.g_T_GATHER_TBL_STAT);
1114:
1115: IF (PO_LOG.d_proc) THEN
1116: PO_LOG.proc_end (d_module);
1117: END IF;
1118:
1119: EXCEPTION
1112:
1113: PO_TIMING_UTL.stop_time (PO_PDOI_CONSTANTS.g_T_GATHER_TBL_STAT);
1114:
1115: IF (PO_LOG.d_proc) THEN
1116: PO_LOG.proc_end (d_module);
1117: END IF;
1118:
1119: EXCEPTION
1120: WHEN OTHERS THEN
1146:
1147: BEGIN
1148: d_position := 0;
1149:
1150: IF (PO_LOG.d_proc) THEN
1151: PO_LOG.proc_begin (d_module);
1152: END IF;
1153:
1154: --SQL What: Mark the drafts that are processed by the current round as
1147: BEGIN
1148: d_position := 0;
1149:
1150: IF (PO_LOG.d_proc) THEN
1151: PO_LOG.proc_begin (d_module);
1152: END IF;
1153:
1154: --SQL What: Mark the drafts that are processed by the current round as
1155: -- PDOI ERROR
1166: WHERE PHI.processing_id IN (PO_PDOI_PARAMS.g_processing_id,
1167: -PO_PDOI_PARAMS.g_processing_id)
1168: AND PHI.processing_round_num=PO_PDOI_PARAMS.g_current_round_num);
1169:
1170: IF (PO_LOG.d_proc) THEN
1171: PO_LOG.proc_end (d_module);
1172: END IF;
1173:
1174: EXCEPTION
1167: -PO_PDOI_PARAMS.g_processing_id)
1168: AND PHI.processing_round_num=PO_PDOI_PARAMS.g_current_round_num);
1169:
1170: IF (PO_LOG.d_proc) THEN
1171: PO_LOG.proc_end (d_module);
1172: END IF;
1173:
1174: EXCEPTION
1175: WHEN OTHERS THEN
1202: BEGIN
1203:
1204: d_position := 0;
1205:
1206: IF (PO_LOG.d_proc) THEN
1207: PO_LOG.proc_begin (d_module);
1208: END IF;
1209:
1210: -- flush all remaining errors to interface errors table
1203:
1204: d_position := 0;
1205:
1206: IF (PO_LOG.d_proc) THEN
1207: PO_LOG.proc_begin (d_module);
1208: END IF;
1209:
1210: -- flush all remaining errors to interface errors table
1211: PO_INTERFACE_ERRORS_UTL.flush_errors_tbl;
1226: END IF;
1227: END LOOP;
1228:
1229: -- FOR i IN 1..l_timing_info_tbl.COUNT LOOP
1230: -- PO_LOG.stmt (d_module, d_position, 'Timing Stat: ', l_timing_info_tbl(i));
1231: -- END LOOP;
1232:
1233:
1234: IF (PO_LOG.d_proc) THEN
1230: -- PO_LOG.stmt (d_module, d_position, 'Timing Stat: ', l_timing_info_tbl(i));
1231: -- END LOOP;
1232:
1233:
1234: IF (PO_LOG.d_proc) THEN
1235: PO_LOG.proc_end (d_module);
1236: END IF;
1237:
1238: EXCEPTION
1231: -- END LOOP;
1232:
1233:
1234: IF (PO_LOG.d_proc) THEN
1235: PO_LOG.proc_end (d_module);
1236: END IF;
1237:
1238: EXCEPTION
1239: WHEN OTHERS THEN