1: PACKAGE BODY PO_PDOI_PVT AS
2: /* $Header: PO_PDOI_PVT.plb 120.6.12010000.2 2008/11/11 17:16:22 bisdas 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: -------------------------------------------------------
220: x_return_status := FND_API.G_RET_STS_SUCCESS;
221:
222: d_position := 0;
223:
224: IF (PO_LOG.d_proc) THEN
225: PO_LOG.proc_begin (d_module, 'p_api_version', p_api_version);
226: PO_LOG.proc_begin (d_module, 'p_init_msg_list', p_init_msg_list);
227: PO_LOG.proc_begin (d_module, 'p_validation_level', p_validation_level);
228: PO_LOG.proc_begin (d_module, 'p_commit', p_commit);
221:
222: d_position := 0;
223:
224: IF (PO_LOG.d_proc) THEN
225: PO_LOG.proc_begin (d_module, 'p_api_version', p_api_version);
226: PO_LOG.proc_begin (d_module, 'p_init_msg_list', p_init_msg_list);
227: PO_LOG.proc_begin (d_module, 'p_validation_level', p_validation_level);
228: PO_LOG.proc_begin (d_module, 'p_commit', p_commit);
229: PO_LOG.proc_begin (d_module, 'p_gather_intf_tbl_stat', p_gather_intf_tbl_stat);
222: d_position := 0;
223:
224: IF (PO_LOG.d_proc) THEN
225: PO_LOG.proc_begin (d_module, 'p_api_version', p_api_version);
226: PO_LOG.proc_begin (d_module, 'p_init_msg_list', p_init_msg_list);
227: PO_LOG.proc_begin (d_module, 'p_validation_level', p_validation_level);
228: PO_LOG.proc_begin (d_module, 'p_commit', p_commit);
229: PO_LOG.proc_begin (d_module, 'p_gather_intf_tbl_stat', p_gather_intf_tbl_stat);
230: PO_LOG.proc_begin (d_module, 'p_calling_module', p_calling_module);
223:
224: IF (PO_LOG.d_proc) THEN
225: PO_LOG.proc_begin (d_module, 'p_api_version', p_api_version);
226: PO_LOG.proc_begin (d_module, 'p_init_msg_list', p_init_msg_list);
227: PO_LOG.proc_begin (d_module, 'p_validation_level', p_validation_level);
228: PO_LOG.proc_begin (d_module, 'p_commit', p_commit);
229: PO_LOG.proc_begin (d_module, 'p_gather_intf_tbl_stat', p_gather_intf_tbl_stat);
230: PO_LOG.proc_begin (d_module, 'p_calling_module', p_calling_module);
231: PO_LOG.proc_begin (d_module, 'p_selected_batch_id', p_selected_batch_id);
224: IF (PO_LOG.d_proc) THEN
225: PO_LOG.proc_begin (d_module, 'p_api_version', p_api_version);
226: PO_LOG.proc_begin (d_module, 'p_init_msg_list', p_init_msg_list);
227: PO_LOG.proc_begin (d_module, 'p_validation_level', p_validation_level);
228: PO_LOG.proc_begin (d_module, 'p_commit', p_commit);
229: PO_LOG.proc_begin (d_module, 'p_gather_intf_tbl_stat', p_gather_intf_tbl_stat);
230: PO_LOG.proc_begin (d_module, 'p_calling_module', p_calling_module);
231: PO_LOG.proc_begin (d_module, 'p_selected_batch_id', p_selected_batch_id);
232: PO_LOG.proc_begin (d_module, 'p_batch_size', p_batch_size);
225: PO_LOG.proc_begin (d_module, 'p_api_version', p_api_version);
226: PO_LOG.proc_begin (d_module, 'p_init_msg_list', p_init_msg_list);
227: PO_LOG.proc_begin (d_module, 'p_validation_level', p_validation_level);
228: PO_LOG.proc_begin (d_module, 'p_commit', p_commit);
229: PO_LOG.proc_begin (d_module, 'p_gather_intf_tbl_stat', p_gather_intf_tbl_stat);
230: PO_LOG.proc_begin (d_module, 'p_calling_module', p_calling_module);
231: PO_LOG.proc_begin (d_module, 'p_selected_batch_id', p_selected_batch_id);
232: PO_LOG.proc_begin (d_module, 'p_batch_size', p_batch_size);
233: PO_LOG.proc_begin (d_module, 'p_buyer_id', p_buyer_id);
226: PO_LOG.proc_begin (d_module, 'p_init_msg_list', p_init_msg_list);
227: PO_LOG.proc_begin (d_module, 'p_validation_level', p_validation_level);
228: PO_LOG.proc_begin (d_module, 'p_commit', p_commit);
229: PO_LOG.proc_begin (d_module, 'p_gather_intf_tbl_stat', p_gather_intf_tbl_stat);
230: PO_LOG.proc_begin (d_module, 'p_calling_module', p_calling_module);
231: PO_LOG.proc_begin (d_module, 'p_selected_batch_id', p_selected_batch_id);
232: PO_LOG.proc_begin (d_module, 'p_batch_size', p_batch_size);
233: PO_LOG.proc_begin (d_module, 'p_buyer_id', p_buyer_id);
234: PO_LOG.proc_begin (d_module, 'p_document_type', p_document_type);
227: PO_LOG.proc_begin (d_module, 'p_validation_level', p_validation_level);
228: PO_LOG.proc_begin (d_module, 'p_commit', p_commit);
229: PO_LOG.proc_begin (d_module, 'p_gather_intf_tbl_stat', p_gather_intf_tbl_stat);
230: PO_LOG.proc_begin (d_module, 'p_calling_module', p_calling_module);
231: PO_LOG.proc_begin (d_module, 'p_selected_batch_id', p_selected_batch_id);
232: PO_LOG.proc_begin (d_module, 'p_batch_size', p_batch_size);
233: PO_LOG.proc_begin (d_module, 'p_buyer_id', p_buyer_id);
234: PO_LOG.proc_begin (d_module, 'p_document_type', p_document_type);
235: PO_LOG.proc_begin (d_module, 'p_document_subtype', p_document_subtype);
228: PO_LOG.proc_begin (d_module, 'p_commit', p_commit);
229: PO_LOG.proc_begin (d_module, 'p_gather_intf_tbl_stat', p_gather_intf_tbl_stat);
230: PO_LOG.proc_begin (d_module, 'p_calling_module', p_calling_module);
231: PO_LOG.proc_begin (d_module, 'p_selected_batch_id', p_selected_batch_id);
232: PO_LOG.proc_begin (d_module, 'p_batch_size', p_batch_size);
233: PO_LOG.proc_begin (d_module, 'p_buyer_id', p_buyer_id);
234: PO_LOG.proc_begin (d_module, 'p_document_type', p_document_type);
235: PO_LOG.proc_begin (d_module, 'p_document_subtype', p_document_subtype);
236: PO_LOG.proc_begin (d_module, 'p_create_items', p_create_items);
229: PO_LOG.proc_begin (d_module, 'p_gather_intf_tbl_stat', p_gather_intf_tbl_stat);
230: PO_LOG.proc_begin (d_module, 'p_calling_module', p_calling_module);
231: PO_LOG.proc_begin (d_module, 'p_selected_batch_id', p_selected_batch_id);
232: PO_LOG.proc_begin (d_module, 'p_batch_size', p_batch_size);
233: PO_LOG.proc_begin (d_module, 'p_buyer_id', p_buyer_id);
234: PO_LOG.proc_begin (d_module, 'p_document_type', p_document_type);
235: PO_LOG.proc_begin (d_module, 'p_document_subtype', p_document_subtype);
236: PO_LOG.proc_begin (d_module, 'p_create_items', p_create_items);
237: PO_LOG.proc_begin (d_module, 'p_create_sourcing_rules_flag', p_create_sourcing_rules_flag);
230: PO_LOG.proc_begin (d_module, 'p_calling_module', p_calling_module);
231: PO_LOG.proc_begin (d_module, 'p_selected_batch_id', p_selected_batch_id);
232: PO_LOG.proc_begin (d_module, 'p_batch_size', p_batch_size);
233: PO_LOG.proc_begin (d_module, 'p_buyer_id', p_buyer_id);
234: PO_LOG.proc_begin (d_module, 'p_document_type', p_document_type);
235: PO_LOG.proc_begin (d_module, 'p_document_subtype', p_document_subtype);
236: PO_LOG.proc_begin (d_module, 'p_create_items', p_create_items);
237: PO_LOG.proc_begin (d_module, 'p_create_sourcing_rules_flag', p_create_sourcing_rules_flag);
238: PO_LOG.proc_begin (d_module, 'p_rel_gen_method', p_rel_gen_method);
231: PO_LOG.proc_begin (d_module, 'p_selected_batch_id', p_selected_batch_id);
232: PO_LOG.proc_begin (d_module, 'p_batch_size', p_batch_size);
233: PO_LOG.proc_begin (d_module, 'p_buyer_id', p_buyer_id);
234: PO_LOG.proc_begin (d_module, 'p_document_type', p_document_type);
235: PO_LOG.proc_begin (d_module, 'p_document_subtype', p_document_subtype);
236: PO_LOG.proc_begin (d_module, 'p_create_items', p_create_items);
237: PO_LOG.proc_begin (d_module, 'p_create_sourcing_rules_flag', p_create_sourcing_rules_flag);
238: PO_LOG.proc_begin (d_module, 'p_rel_gen_method', p_rel_gen_method);
239: PO_LOG.proc_begin (d_module, 'p_sourcing_level', p_sourcing_level);
232: PO_LOG.proc_begin (d_module, 'p_batch_size', p_batch_size);
233: PO_LOG.proc_begin (d_module, 'p_buyer_id', p_buyer_id);
234: PO_LOG.proc_begin (d_module, 'p_document_type', p_document_type);
235: PO_LOG.proc_begin (d_module, 'p_document_subtype', p_document_subtype);
236: PO_LOG.proc_begin (d_module, 'p_create_items', p_create_items);
237: PO_LOG.proc_begin (d_module, 'p_create_sourcing_rules_flag', p_create_sourcing_rules_flag);
238: PO_LOG.proc_begin (d_module, 'p_rel_gen_method', p_rel_gen_method);
239: PO_LOG.proc_begin (d_module, 'p_sourcing_level', p_sourcing_level);
240: PO_LOG.proc_begin (d_module, 'p_sourcing_inv_org_id', p_sourcing_inv_org_id);
233: PO_LOG.proc_begin (d_module, 'p_buyer_id', p_buyer_id);
234: PO_LOG.proc_begin (d_module, 'p_document_type', p_document_type);
235: PO_LOG.proc_begin (d_module, 'p_document_subtype', p_document_subtype);
236: PO_LOG.proc_begin (d_module, 'p_create_items', p_create_items);
237: PO_LOG.proc_begin (d_module, 'p_create_sourcing_rules_flag', p_create_sourcing_rules_flag);
238: PO_LOG.proc_begin (d_module, 'p_rel_gen_method', p_rel_gen_method);
239: PO_LOG.proc_begin (d_module, 'p_sourcing_level', p_sourcing_level);
240: PO_LOG.proc_begin (d_module, 'p_sourcing_inv_org_id', p_sourcing_inv_org_id);
241: PO_LOG.proc_begin (d_module, 'p_approved_status', p_approved_status);
234: PO_LOG.proc_begin (d_module, 'p_document_type', p_document_type);
235: PO_LOG.proc_begin (d_module, 'p_document_subtype', p_document_subtype);
236: PO_LOG.proc_begin (d_module, 'p_create_items', p_create_items);
237: PO_LOG.proc_begin (d_module, 'p_create_sourcing_rules_flag', p_create_sourcing_rules_flag);
238: PO_LOG.proc_begin (d_module, 'p_rel_gen_method', p_rel_gen_method);
239: PO_LOG.proc_begin (d_module, 'p_sourcing_level', p_sourcing_level);
240: PO_LOG.proc_begin (d_module, 'p_sourcing_inv_org_id', p_sourcing_inv_org_id);
241: PO_LOG.proc_begin (d_module, 'p_approved_status', p_approved_status);
242: PO_LOG.proc_begin (d_module, 'p_process_code', p_process_code);
235: PO_LOG.proc_begin (d_module, 'p_document_subtype', p_document_subtype);
236: PO_LOG.proc_begin (d_module, 'p_create_items', p_create_items);
237: PO_LOG.proc_begin (d_module, 'p_create_sourcing_rules_flag', p_create_sourcing_rules_flag);
238: PO_LOG.proc_begin (d_module, 'p_rel_gen_method', p_rel_gen_method);
239: PO_LOG.proc_begin (d_module, 'p_sourcing_level', p_sourcing_level);
240: PO_LOG.proc_begin (d_module, 'p_sourcing_inv_org_id', p_sourcing_inv_org_id);
241: PO_LOG.proc_begin (d_module, 'p_approved_status', p_approved_status);
242: PO_LOG.proc_begin (d_module, 'p_process_code', p_process_code);
243: PO_LOG.proc_begin (d_module, 'p_interface_header_id', p_interface_header_id);
236: PO_LOG.proc_begin (d_module, 'p_create_items', p_create_items);
237: PO_LOG.proc_begin (d_module, 'p_create_sourcing_rules_flag', p_create_sourcing_rules_flag);
238: PO_LOG.proc_begin (d_module, 'p_rel_gen_method', p_rel_gen_method);
239: PO_LOG.proc_begin (d_module, 'p_sourcing_level', p_sourcing_level);
240: PO_LOG.proc_begin (d_module, 'p_sourcing_inv_org_id', p_sourcing_inv_org_id);
241: PO_LOG.proc_begin (d_module, 'p_approved_status', p_approved_status);
242: PO_LOG.proc_begin (d_module, 'p_process_code', p_process_code);
243: PO_LOG.proc_begin (d_module, 'p_interface_header_id', p_interface_header_id);
244: PO_LOG.proc_begin (d_module, 'p_org_id', p_org_id);
237: PO_LOG.proc_begin (d_module, 'p_create_sourcing_rules_flag', p_create_sourcing_rules_flag);
238: PO_LOG.proc_begin (d_module, 'p_rel_gen_method', p_rel_gen_method);
239: PO_LOG.proc_begin (d_module, 'p_sourcing_level', p_sourcing_level);
240: PO_LOG.proc_begin (d_module, 'p_sourcing_inv_org_id', p_sourcing_inv_org_id);
241: PO_LOG.proc_begin (d_module, 'p_approved_status', p_approved_status);
242: PO_LOG.proc_begin (d_module, 'p_process_code', p_process_code);
243: PO_LOG.proc_begin (d_module, 'p_interface_header_id', p_interface_header_id);
244: PO_LOG.proc_begin (d_module, 'p_org_id', p_org_id);
245: PO_LOG.proc_begin (d_module, 'p_ga_flag', p_ga_flag);
238: PO_LOG.proc_begin (d_module, 'p_rel_gen_method', p_rel_gen_method);
239: PO_LOG.proc_begin (d_module, 'p_sourcing_level', p_sourcing_level);
240: PO_LOG.proc_begin (d_module, 'p_sourcing_inv_org_id', p_sourcing_inv_org_id);
241: PO_LOG.proc_begin (d_module, 'p_approved_status', p_approved_status);
242: PO_LOG.proc_begin (d_module, 'p_process_code', p_process_code);
243: PO_LOG.proc_begin (d_module, 'p_interface_header_id', p_interface_header_id);
244: PO_LOG.proc_begin (d_module, 'p_org_id', p_org_id);
245: PO_LOG.proc_begin (d_module, 'p_ga_flag', p_ga_flag);
246: PO_LOG.proc_begin (d_module, 'p_submit_dft_flag', p_submit_dft_flag);
239: PO_LOG.proc_begin (d_module, 'p_sourcing_level', p_sourcing_level);
240: PO_LOG.proc_begin (d_module, 'p_sourcing_inv_org_id', p_sourcing_inv_org_id);
241: PO_LOG.proc_begin (d_module, 'p_approved_status', p_approved_status);
242: PO_LOG.proc_begin (d_module, 'p_process_code', p_process_code);
243: PO_LOG.proc_begin (d_module, 'p_interface_header_id', p_interface_header_id);
244: PO_LOG.proc_begin (d_module, 'p_org_id', p_org_id);
245: PO_LOG.proc_begin (d_module, 'p_ga_flag', p_ga_flag);
246: PO_LOG.proc_begin (d_module, 'p_submit_dft_flag', p_submit_dft_flag);
247: PO_LOG.proc_begin (d_module, 'p_role', p_role);
240: PO_LOG.proc_begin (d_module, 'p_sourcing_inv_org_id', p_sourcing_inv_org_id);
241: PO_LOG.proc_begin (d_module, 'p_approved_status', p_approved_status);
242: PO_LOG.proc_begin (d_module, 'p_process_code', p_process_code);
243: PO_LOG.proc_begin (d_module, 'p_interface_header_id', p_interface_header_id);
244: PO_LOG.proc_begin (d_module, 'p_org_id', p_org_id);
245: PO_LOG.proc_begin (d_module, 'p_ga_flag', p_ga_flag);
246: PO_LOG.proc_begin (d_module, 'p_submit_dft_flag', p_submit_dft_flag);
247: PO_LOG.proc_begin (d_module, 'p_role', p_role);
248: PO_LOG.proc_begin (d_module, 'p_catalog_to_expire', p_catalog_to_expire);
241: PO_LOG.proc_begin (d_module, 'p_approved_status', p_approved_status);
242: PO_LOG.proc_begin (d_module, 'p_process_code', p_process_code);
243: PO_LOG.proc_begin (d_module, 'p_interface_header_id', p_interface_header_id);
244: PO_LOG.proc_begin (d_module, 'p_org_id', p_org_id);
245: PO_LOG.proc_begin (d_module, 'p_ga_flag', p_ga_flag);
246: PO_LOG.proc_begin (d_module, 'p_submit_dft_flag', p_submit_dft_flag);
247: PO_LOG.proc_begin (d_module, 'p_role', p_role);
248: PO_LOG.proc_begin (d_module, 'p_catalog_to_expire', p_catalog_to_expire);
249: PO_LOG.proc_begin (d_module, 'p_err_lines_tolerance', p_err_lines_tolerance);
242: PO_LOG.proc_begin (d_module, 'p_process_code', p_process_code);
243: PO_LOG.proc_begin (d_module, 'p_interface_header_id', p_interface_header_id);
244: PO_LOG.proc_begin (d_module, 'p_org_id', p_org_id);
245: PO_LOG.proc_begin (d_module, 'p_ga_flag', p_ga_flag);
246: PO_LOG.proc_begin (d_module, 'p_submit_dft_flag', p_submit_dft_flag);
247: PO_LOG.proc_begin (d_module, 'p_role', p_role);
248: PO_LOG.proc_begin (d_module, 'p_catalog_to_expire', p_catalog_to_expire);
249: PO_LOG.proc_begin (d_module, 'p_err_lines_tolerance', p_err_lines_tolerance);
250: END IF;
243: PO_LOG.proc_begin (d_module, 'p_interface_header_id', p_interface_header_id);
244: PO_LOG.proc_begin (d_module, 'p_org_id', p_org_id);
245: PO_LOG.proc_begin (d_module, 'p_ga_flag', p_ga_flag);
246: PO_LOG.proc_begin (d_module, 'p_submit_dft_flag', p_submit_dft_flag);
247: PO_LOG.proc_begin (d_module, 'p_role', p_role);
248: PO_LOG.proc_begin (d_module, 'p_catalog_to_expire', p_catalog_to_expire);
249: PO_LOG.proc_begin (d_module, 'p_err_lines_tolerance', p_err_lines_tolerance);
250: END IF;
251:
244: PO_LOG.proc_begin (d_module, 'p_org_id', p_org_id);
245: PO_LOG.proc_begin (d_module, 'p_ga_flag', p_ga_flag);
246: PO_LOG.proc_begin (d_module, 'p_submit_dft_flag', p_submit_dft_flag);
247: PO_LOG.proc_begin (d_module, 'p_role', p_role);
248: PO_LOG.proc_begin (d_module, 'p_catalog_to_expire', p_catalog_to_expire);
249: PO_LOG.proc_begin (d_module, 'p_err_lines_tolerance', p_err_lines_tolerance);
250: END IF;
251:
252: PO_TIMING_UTL.init;
245: PO_LOG.proc_begin (d_module, 'p_ga_flag', p_ga_flag);
246: PO_LOG.proc_begin (d_module, 'p_submit_dft_flag', p_submit_dft_flag);
247: PO_LOG.proc_begin (d_module, 'p_role', p_role);
248: PO_LOG.proc_begin (d_module, 'p_catalog_to_expire', p_catalog_to_expire);
249: PO_LOG.proc_begin (d_module, 'p_err_lines_tolerance', p_err_lines_tolerance);
250: END IF;
251:
252: PO_TIMING_UTL.init;
253: PO_TIMING_UTL.start_time (PO_PDOI_CONSTANTS.g_T_PDOI_ALL);
363:
364: -- do interface errors reporting, log timing, etc.
365: wrap_up;
366:
367: IF (PO_LOG.d_stmt) THEN
368: PO_LOG.proc_end(d_module);
369: END IF;
370: EXCEPTION
371: WHEN OTHERS THEN
364: -- do interface errors reporting, log timing, etc.
365: wrap_up;
366:
367: IF (PO_LOG.d_stmt) THEN
368: PO_LOG.proc_end(d_module);
369: END IF;
370: EXCEPTION
371: WHEN OTHERS THEN
372: PO_MESSAGE_S.add_exc_msg
408: l_audsid NUMBER := USERENV('SESSIONID');
409: BEGIN
410: d_position := 0;
411:
412: IF (PO_LOG.d_proc) THEN
413: PO_LOG.proc_begin (d_module);
414: END IF;
415:
416: IF (PO_LOG.d_stmt) THEN
409: BEGIN
410: d_position := 0;
411:
412: IF (PO_LOG.d_proc) THEN
413: PO_LOG.proc_begin (d_module);
414: END IF;
415:
416: IF (PO_LOG.d_stmt) THEN
417: PO_LOG.stmt(d_module, d_position, 'AUDSID = ' || l_audsid);
412: IF (PO_LOG.d_proc) THEN
413: PO_LOG.proc_begin (d_module);
414: END IF;
415:
416: IF (PO_LOG.d_stmt) THEN
417: PO_LOG.stmt(d_module, d_position, 'AUDSID = ' || l_audsid);
418: END IF;
419:
420: FND_FILE.put_line(FND_FILE.log,
413: PO_LOG.proc_begin (d_module);
414: END IF;
415:
416: IF (PO_LOG.d_stmt) THEN
417: PO_LOG.stmt(d_module, d_position, 'AUDSID = ' || l_audsid);
418: END IF;
419:
420: FND_FILE.put_line(FND_FILE.log,
421: 'To get the log messages for PDOI, please use the ' ||
422: 'following id to query against FND_LOG_MESSAGES table:');
423:
424: FND_FILE.put_line(FND_FILE.log, 'AUDSID = ' || l_audsid);
425:
426: IF (PO_LOG.d_proc) THEN
427: PO_LOG.proc_end (d_module);
428: END IF;
429:
430: EXCEPTION
423:
424: FND_FILE.put_line(FND_FILE.log, 'AUDSID = ' || l_audsid);
425:
426: IF (PO_LOG.d_proc) THEN
427: PO_LOG.proc_end (d_module);
428: END IF;
429:
430: EXCEPTION
431: WHEN OTHERS THEN
481:
482: BEGIN
483: d_position := 0;
484:
485: IF (PO_LOG.d_proc) THEN
486: PO_LOG.proc_begin (d_module);
487: END IF;
488:
489: -- Setup g_request
482: BEGIN
483: d_position := 0;
484:
485: IF (PO_LOG.d_proc) THEN
486: PO_LOG.proc_begin (d_module);
487: END IF;
488:
489: -- Setup g_request
490: PO_PDOI_PARAMS.g_request.calling_module := NVL(p_calling_module, PO_PDOI_CONSTANTS.g_call_mod_UNKNOWN);
528: SELECT PO_PDOI_PROCESSING_ID_S.nextval
529: INTO PO_PDOI_PARAMS.g_processing_id
530: FROM DUAL;
531:
532: IF (PO_LOG.d_stmt) THEN
533: PO_LOG.stmt (d_module, d_position, 'g_processsing_id',
534: PO_PDOI_PARAMS.g_processing_id);
535: END IF;
536:
529: INTO PO_PDOI_PARAMS.g_processing_id
530: FROM DUAL;
531:
532: IF (PO_LOG.d_stmt) THEN
533: PO_LOG.stmt (d_module, d_position, 'g_processsing_id',
534: PO_PDOI_PARAMS.g_processing_id);
535: END IF;
536:
537: d_position := 50;
543: PO_PDOI_PARAMS.g_out.processed_lines_count := 0;
544: PO_PDOI_PARAMS.g_out.rejected_lines_count := 0;
545: PO_PDOI_PARAMS.g_out.err_tolerance_exceeded := FND_API.G_FALSE;
546:
547: IF (PO_LOG.d_proc) THEN
548: PO_LOG.proc_end (d_module);
549: END IF;
550: EXCEPTION
551: WHEN OTHERS THEN
544: PO_PDOI_PARAMS.g_out.rejected_lines_count := 0;
545: PO_PDOI_PARAMS.g_out.err_tolerance_exceeded := FND_API.G_FALSE;
546:
547: IF (PO_LOG.d_proc) THEN
548: PO_LOG.proc_end (d_module);
549: END IF;
550: EXCEPTION
551: WHEN OTHERS THEN
552: PO_MESSAGE_S.add_exc_msg
614: BEGIN
615:
616: d_position := 0;
617:
618: IF (PO_LOG.d_proc) THEN
619: PO_LOG.proc_begin (d_module);
620: END IF;
621:
622: -- po and financials system parameters
615:
616: d_position := 0;
617:
618: IF (PO_LOG.d_proc) THEN
619: PO_LOG.proc_begin (d_module);
620: END IF;
621:
622: -- po and financials system parameters
623: PO_CORE_S.get_po_parameters
740: ( p_org_id => PO_PDOI_PARAMS.g_request.org_id
741: );
742:
743: d_position := 90;
744: IF (PO_LOG.d_stmt) THEN
745: PO_LOG.stmt (d_module, d_position, 'currency_code', PO_PDOI_PARAMS.g_sys.currency_code);
746: PO_LOG.stmt (d_module, d_position, 'coa_id', PO_PDOI_PARAMS.g_sys.coa_id);
747: PO_LOG.stmt (d_module, d_position, 'po_encumbrance_flag', PO_PDOI_PARAMS.g_sys.po_encumbrance_flag);
748: PO_LOG.stmt (d_module, d_position, 'req_encumbrance_flag', PO_PDOI_PARAMS.g_sys.req_encumbrance_flag);
741: );
742:
743: d_position := 90;
744: IF (PO_LOG.d_stmt) THEN
745: PO_LOG.stmt (d_module, d_position, 'currency_code', PO_PDOI_PARAMS.g_sys.currency_code);
746: PO_LOG.stmt (d_module, d_position, 'coa_id', PO_PDOI_PARAMS.g_sys.coa_id);
747: PO_LOG.stmt (d_module, d_position, 'po_encumbrance_flag', PO_PDOI_PARAMS.g_sys.po_encumbrance_flag);
748: PO_LOG.stmt (d_module, d_position, 'req_encumbrance_flag', PO_PDOI_PARAMS.g_sys.req_encumbrance_flag);
749: PO_LOG.stmt (d_module, d_position, 'sob_id', PO_PDOI_PARAMS.g_sys.sob_id);
742:
743: d_position := 90;
744: IF (PO_LOG.d_stmt) THEN
745: PO_LOG.stmt (d_module, d_position, 'currency_code', PO_PDOI_PARAMS.g_sys.currency_code);
746: PO_LOG.stmt (d_module, d_position, 'coa_id', PO_PDOI_PARAMS.g_sys.coa_id);
747: PO_LOG.stmt (d_module, d_position, 'po_encumbrance_flag', PO_PDOI_PARAMS.g_sys.po_encumbrance_flag);
748: PO_LOG.stmt (d_module, d_position, 'req_encumbrance_flag', PO_PDOI_PARAMS.g_sys.req_encumbrance_flag);
749: PO_LOG.stmt (d_module, d_position, 'sob_id', PO_PDOI_PARAMS.g_sys.sob_id);
750: PO_LOG.stmt (d_module, d_position, 'ship_to_location_id', PO_PDOI_PARAMS.g_sys.ship_to_location_id);
743: d_position := 90;
744: IF (PO_LOG.d_stmt) THEN
745: PO_LOG.stmt (d_module, d_position, 'currency_code', PO_PDOI_PARAMS.g_sys.currency_code);
746: PO_LOG.stmt (d_module, d_position, 'coa_id', PO_PDOI_PARAMS.g_sys.coa_id);
747: PO_LOG.stmt (d_module, d_position, 'po_encumbrance_flag', PO_PDOI_PARAMS.g_sys.po_encumbrance_flag);
748: PO_LOG.stmt (d_module, d_position, 'req_encumbrance_flag', PO_PDOI_PARAMS.g_sys.req_encumbrance_flag);
749: PO_LOG.stmt (d_module, d_position, 'sob_id', PO_PDOI_PARAMS.g_sys.sob_id);
750: PO_LOG.stmt (d_module, d_position, 'ship_to_location_id', PO_PDOI_PARAMS.g_sys.ship_to_location_id);
751: PO_LOG.stmt (d_module, d_position, 'bill_to_location_id', PO_PDOI_PARAMS.g_sys.bill_to_location_id);
744: IF (PO_LOG.d_stmt) THEN
745: PO_LOG.stmt (d_module, d_position, 'currency_code', PO_PDOI_PARAMS.g_sys.currency_code);
746: PO_LOG.stmt (d_module, d_position, 'coa_id', PO_PDOI_PARAMS.g_sys.coa_id);
747: PO_LOG.stmt (d_module, d_position, 'po_encumbrance_flag', PO_PDOI_PARAMS.g_sys.po_encumbrance_flag);
748: PO_LOG.stmt (d_module, d_position, 'req_encumbrance_flag', PO_PDOI_PARAMS.g_sys.req_encumbrance_flag);
749: PO_LOG.stmt (d_module, d_position, 'sob_id', PO_PDOI_PARAMS.g_sys.sob_id);
750: PO_LOG.stmt (d_module, d_position, 'ship_to_location_id', PO_PDOI_PARAMS.g_sys.ship_to_location_id);
751: PO_LOG.stmt (d_module, d_position, 'bill_to_location_id', PO_PDOI_PARAMS.g_sys.bill_to_location_id);
752: PO_LOG.stmt (d_module, d_position, 'fob_lookup_code', PO_PDOI_PARAMS.g_sys.fob_lookup_code);
745: PO_LOG.stmt (d_module, d_position, 'currency_code', PO_PDOI_PARAMS.g_sys.currency_code);
746: PO_LOG.stmt (d_module, d_position, 'coa_id', PO_PDOI_PARAMS.g_sys.coa_id);
747: PO_LOG.stmt (d_module, d_position, 'po_encumbrance_flag', PO_PDOI_PARAMS.g_sys.po_encumbrance_flag);
748: PO_LOG.stmt (d_module, d_position, 'req_encumbrance_flag', PO_PDOI_PARAMS.g_sys.req_encumbrance_flag);
749: PO_LOG.stmt (d_module, d_position, 'sob_id', PO_PDOI_PARAMS.g_sys.sob_id);
750: PO_LOG.stmt (d_module, d_position, 'ship_to_location_id', PO_PDOI_PARAMS.g_sys.ship_to_location_id);
751: PO_LOG.stmt (d_module, d_position, 'bill_to_location_id', PO_PDOI_PARAMS.g_sys.bill_to_location_id);
752: PO_LOG.stmt (d_module, d_position, 'fob_lookup_code', PO_PDOI_PARAMS.g_sys.fob_lookup_code);
753: PO_LOG.stmt (d_module, d_position, 'freight_terms_lookup_code', PO_PDOI_PARAMS.g_sys.freight_terms_lookup_code);
746: PO_LOG.stmt (d_module, d_position, 'coa_id', PO_PDOI_PARAMS.g_sys.coa_id);
747: PO_LOG.stmt (d_module, d_position, 'po_encumbrance_flag', PO_PDOI_PARAMS.g_sys.po_encumbrance_flag);
748: PO_LOG.stmt (d_module, d_position, 'req_encumbrance_flag', PO_PDOI_PARAMS.g_sys.req_encumbrance_flag);
749: PO_LOG.stmt (d_module, d_position, 'sob_id', PO_PDOI_PARAMS.g_sys.sob_id);
750: PO_LOG.stmt (d_module, d_position, 'ship_to_location_id', PO_PDOI_PARAMS.g_sys.ship_to_location_id);
751: PO_LOG.stmt (d_module, d_position, 'bill_to_location_id', PO_PDOI_PARAMS.g_sys.bill_to_location_id);
752: PO_LOG.stmt (d_module, d_position, 'fob_lookup_code', PO_PDOI_PARAMS.g_sys.fob_lookup_code);
753: PO_LOG.stmt (d_module, d_position, 'freight_terms_lookup_code', PO_PDOI_PARAMS.g_sys.freight_terms_lookup_code);
754: PO_LOG.stmt (d_module, d_position, 'terms_id', PO_PDOI_PARAMS.g_sys.terms_id);
747: PO_LOG.stmt (d_module, d_position, 'po_encumbrance_flag', PO_PDOI_PARAMS.g_sys.po_encumbrance_flag);
748: PO_LOG.stmt (d_module, d_position, 'req_encumbrance_flag', PO_PDOI_PARAMS.g_sys.req_encumbrance_flag);
749: PO_LOG.stmt (d_module, d_position, 'sob_id', PO_PDOI_PARAMS.g_sys.sob_id);
750: PO_LOG.stmt (d_module, d_position, 'ship_to_location_id', PO_PDOI_PARAMS.g_sys.ship_to_location_id);
751: PO_LOG.stmt (d_module, d_position, 'bill_to_location_id', PO_PDOI_PARAMS.g_sys.bill_to_location_id);
752: PO_LOG.stmt (d_module, d_position, 'fob_lookup_code', PO_PDOI_PARAMS.g_sys.fob_lookup_code);
753: PO_LOG.stmt (d_module, d_position, 'freight_terms_lookup_code', PO_PDOI_PARAMS.g_sys.freight_terms_lookup_code);
754: PO_LOG.stmt (d_module, d_position, 'terms_id', PO_PDOI_PARAMS.g_sys.terms_id);
755: PO_LOG.stmt (d_module, d_position, 'default_rate_type', PO_PDOI_PARAMS.g_sys.default_rate_type);
748: PO_LOG.stmt (d_module, d_position, 'req_encumbrance_flag', PO_PDOI_PARAMS.g_sys.req_encumbrance_flag);
749: PO_LOG.stmt (d_module, d_position, 'sob_id', PO_PDOI_PARAMS.g_sys.sob_id);
750: PO_LOG.stmt (d_module, d_position, 'ship_to_location_id', PO_PDOI_PARAMS.g_sys.ship_to_location_id);
751: PO_LOG.stmt (d_module, d_position, 'bill_to_location_id', PO_PDOI_PARAMS.g_sys.bill_to_location_id);
752: PO_LOG.stmt (d_module, d_position, 'fob_lookup_code', PO_PDOI_PARAMS.g_sys.fob_lookup_code);
753: PO_LOG.stmt (d_module, d_position, 'freight_terms_lookup_code', PO_PDOI_PARAMS.g_sys.freight_terms_lookup_code);
754: PO_LOG.stmt (d_module, d_position, 'terms_id', PO_PDOI_PARAMS.g_sys.terms_id);
755: PO_LOG.stmt (d_module, d_position, 'default_rate_type', PO_PDOI_PARAMS.g_sys.default_rate_type);
756: PO_LOG.stmt (d_module, d_position, 'taxable_flag', PO_PDOI_PARAMS.g_sys.taxable_flag);
749: PO_LOG.stmt (d_module, d_position, 'sob_id', PO_PDOI_PARAMS.g_sys.sob_id);
750: PO_LOG.stmt (d_module, d_position, 'ship_to_location_id', PO_PDOI_PARAMS.g_sys.ship_to_location_id);
751: PO_LOG.stmt (d_module, d_position, 'bill_to_location_id', PO_PDOI_PARAMS.g_sys.bill_to_location_id);
752: PO_LOG.stmt (d_module, d_position, 'fob_lookup_code', PO_PDOI_PARAMS.g_sys.fob_lookup_code);
753: PO_LOG.stmt (d_module, d_position, 'freight_terms_lookup_code', PO_PDOI_PARAMS.g_sys.freight_terms_lookup_code);
754: PO_LOG.stmt (d_module, d_position, 'terms_id', PO_PDOI_PARAMS.g_sys.terms_id);
755: PO_LOG.stmt (d_module, d_position, 'default_rate_type', PO_PDOI_PARAMS.g_sys.default_rate_type);
756: PO_LOG.stmt (d_module, d_position, 'taxable_flag', PO_PDOI_PARAMS.g_sys.taxable_flag);
757: PO_LOG.stmt (d_module, d_position, 'receiving_flag', PO_PDOI_PARAMS.g_sys.receiving_flag);
750: PO_LOG.stmt (d_module, d_position, 'ship_to_location_id', PO_PDOI_PARAMS.g_sys.ship_to_location_id);
751: PO_LOG.stmt (d_module, d_position, 'bill_to_location_id', PO_PDOI_PARAMS.g_sys.bill_to_location_id);
752: PO_LOG.stmt (d_module, d_position, 'fob_lookup_code', PO_PDOI_PARAMS.g_sys.fob_lookup_code);
753: PO_LOG.stmt (d_module, d_position, 'freight_terms_lookup_code', PO_PDOI_PARAMS.g_sys.freight_terms_lookup_code);
754: PO_LOG.stmt (d_module, d_position, 'terms_id', PO_PDOI_PARAMS.g_sys.terms_id);
755: PO_LOG.stmt (d_module, d_position, 'default_rate_type', PO_PDOI_PARAMS.g_sys.default_rate_type);
756: PO_LOG.stmt (d_module, d_position, 'taxable_flag', PO_PDOI_PARAMS.g_sys.taxable_flag);
757: PO_LOG.stmt (d_module, d_position, 'receiving_flag', PO_PDOI_PARAMS.g_sys.receiving_flag);
758: PO_LOG.stmt (d_module, d_position, 'line_type_id', PO_PDOI_PARAMS.g_sys.line_type_id);
751: PO_LOG.stmt (d_module, d_position, 'bill_to_location_id', PO_PDOI_PARAMS.g_sys.bill_to_location_id);
752: PO_LOG.stmt (d_module, d_position, 'fob_lookup_code', PO_PDOI_PARAMS.g_sys.fob_lookup_code);
753: PO_LOG.stmt (d_module, d_position, 'freight_terms_lookup_code', PO_PDOI_PARAMS.g_sys.freight_terms_lookup_code);
754: PO_LOG.stmt (d_module, d_position, 'terms_id', PO_PDOI_PARAMS.g_sys.terms_id);
755: PO_LOG.stmt (d_module, d_position, 'default_rate_type', PO_PDOI_PARAMS.g_sys.default_rate_type);
756: PO_LOG.stmt (d_module, d_position, 'taxable_flag', PO_PDOI_PARAMS.g_sys.taxable_flag);
757: PO_LOG.stmt (d_module, d_position, 'receiving_flag', PO_PDOI_PARAMS.g_sys.receiving_flag);
758: PO_LOG.stmt (d_module, d_position, 'line_type_id', PO_PDOI_PARAMS.g_sys.line_type_id);
759: PO_LOG.stmt (d_module, d_position, 'manual_po_num_type', PO_PDOI_PARAMS.g_sys.manual_po_num_type);
752: PO_LOG.stmt (d_module, d_position, 'fob_lookup_code', PO_PDOI_PARAMS.g_sys.fob_lookup_code);
753: PO_LOG.stmt (d_module, d_position, 'freight_terms_lookup_code', PO_PDOI_PARAMS.g_sys.freight_terms_lookup_code);
754: PO_LOG.stmt (d_module, d_position, 'terms_id', PO_PDOI_PARAMS.g_sys.terms_id);
755: PO_LOG.stmt (d_module, d_position, 'default_rate_type', PO_PDOI_PARAMS.g_sys.default_rate_type);
756: PO_LOG.stmt (d_module, d_position, 'taxable_flag', PO_PDOI_PARAMS.g_sys.taxable_flag);
757: PO_LOG.stmt (d_module, d_position, 'receiving_flag', PO_PDOI_PARAMS.g_sys.receiving_flag);
758: PO_LOG.stmt (d_module, d_position, 'line_type_id', PO_PDOI_PARAMS.g_sys.line_type_id);
759: PO_LOG.stmt (d_module, d_position, 'manual_po_num_type', PO_PDOI_PARAMS.g_sys.manual_po_num_type);
760: PO_LOG.stmt (d_module, d_position, 'user_defined_po_num_code', PO_PDOI_PARAMS.g_sys.user_defined_po_num_code);
753: PO_LOG.stmt (d_module, d_position, 'freight_terms_lookup_code', PO_PDOI_PARAMS.g_sys.freight_terms_lookup_code);
754: PO_LOG.stmt (d_module, d_position, 'terms_id', PO_PDOI_PARAMS.g_sys.terms_id);
755: PO_LOG.stmt (d_module, d_position, 'default_rate_type', PO_PDOI_PARAMS.g_sys.default_rate_type);
756: PO_LOG.stmt (d_module, d_position, 'taxable_flag', PO_PDOI_PARAMS.g_sys.taxable_flag);
757: PO_LOG.stmt (d_module, d_position, 'receiving_flag', PO_PDOI_PARAMS.g_sys.receiving_flag);
758: PO_LOG.stmt (d_module, d_position, 'line_type_id', PO_PDOI_PARAMS.g_sys.line_type_id);
759: PO_LOG.stmt (d_module, d_position, 'manual_po_num_type', PO_PDOI_PARAMS.g_sys.manual_po_num_type);
760: PO_LOG.stmt (d_module, d_position, 'user_defined_po_num_code', PO_PDOI_PARAMS.g_sys.user_defined_po_num_code);
761: PO_LOG.stmt (d_module, d_position, 'price_type_lookup_code', PO_PDOI_PARAMS.g_sys.price_type_lookup_code);
754: PO_LOG.stmt (d_module, d_position, 'terms_id', PO_PDOI_PARAMS.g_sys.terms_id);
755: PO_LOG.stmt (d_module, d_position, 'default_rate_type', PO_PDOI_PARAMS.g_sys.default_rate_type);
756: PO_LOG.stmt (d_module, d_position, 'taxable_flag', PO_PDOI_PARAMS.g_sys.taxable_flag);
757: PO_LOG.stmt (d_module, d_position, 'receiving_flag', PO_PDOI_PARAMS.g_sys.receiving_flag);
758: PO_LOG.stmt (d_module, d_position, 'line_type_id', PO_PDOI_PARAMS.g_sys.line_type_id);
759: PO_LOG.stmt (d_module, d_position, 'manual_po_num_type', PO_PDOI_PARAMS.g_sys.manual_po_num_type);
760: PO_LOG.stmt (d_module, d_position, 'user_defined_po_num_code', PO_PDOI_PARAMS.g_sys.user_defined_po_num_code);
761: PO_LOG.stmt (d_module, d_position, 'price_type_lookup_code', PO_PDOI_PARAMS.g_sys.price_type_lookup_code);
762: PO_LOG.stmt (d_module, d_position, 'def_inv_org_id', PO_PDOI_PARAMS.g_sys.def_inv_org_id);
755: PO_LOG.stmt (d_module, d_position, 'default_rate_type', PO_PDOI_PARAMS.g_sys.default_rate_type);
756: PO_LOG.stmt (d_module, d_position, 'taxable_flag', PO_PDOI_PARAMS.g_sys.taxable_flag);
757: PO_LOG.stmt (d_module, d_position, 'receiving_flag', PO_PDOI_PARAMS.g_sys.receiving_flag);
758: PO_LOG.stmt (d_module, d_position, 'line_type_id', PO_PDOI_PARAMS.g_sys.line_type_id);
759: PO_LOG.stmt (d_module, d_position, 'manual_po_num_type', PO_PDOI_PARAMS.g_sys.manual_po_num_type);
760: PO_LOG.stmt (d_module, d_position, 'user_defined_po_num_code', PO_PDOI_PARAMS.g_sys.user_defined_po_num_code);
761: PO_LOG.stmt (d_module, d_position, 'price_type_lookup_code', PO_PDOI_PARAMS.g_sys.price_type_lookup_code);
762: PO_LOG.stmt (d_module, d_position, 'def_inv_org_id', PO_PDOI_PARAMS.g_sys.def_inv_org_id);
763: PO_LOG.stmt (d_module, d_position, 'min_rel_amount', PO_PDOI_PARAMS.g_sys.min_rel_amount);
756: PO_LOG.stmt (d_module, d_position, 'taxable_flag', PO_PDOI_PARAMS.g_sys.taxable_flag);
757: PO_LOG.stmt (d_module, d_position, 'receiving_flag', PO_PDOI_PARAMS.g_sys.receiving_flag);
758: PO_LOG.stmt (d_module, d_position, 'line_type_id', PO_PDOI_PARAMS.g_sys.line_type_id);
759: PO_LOG.stmt (d_module, d_position, 'manual_po_num_type', PO_PDOI_PARAMS.g_sys.manual_po_num_type);
760: PO_LOG.stmt (d_module, d_position, 'user_defined_po_num_code', PO_PDOI_PARAMS.g_sys.user_defined_po_num_code);
761: PO_LOG.stmt (d_module, d_position, 'price_type_lookup_code', PO_PDOI_PARAMS.g_sys.price_type_lookup_code);
762: PO_LOG.stmt (d_module, d_position, 'def_inv_org_id', PO_PDOI_PARAMS.g_sys.def_inv_org_id);
763: PO_LOG.stmt (d_module, d_position, 'min_rel_amount', PO_PDOI_PARAMS.g_sys.min_rel_amount);
764: PO_LOG.stmt (d_module, d_position, 'def_quote_warning_delay', PO_PDOI_PARAMS.g_sys.def_quote_warning_delay);
757: PO_LOG.stmt (d_module, d_position, 'receiving_flag', PO_PDOI_PARAMS.g_sys.receiving_flag);
758: PO_LOG.stmt (d_module, d_position, 'line_type_id', PO_PDOI_PARAMS.g_sys.line_type_id);
759: PO_LOG.stmt (d_module, d_position, 'manual_po_num_type', PO_PDOI_PARAMS.g_sys.manual_po_num_type);
760: PO_LOG.stmt (d_module, d_position, 'user_defined_po_num_code', PO_PDOI_PARAMS.g_sys.user_defined_po_num_code);
761: PO_LOG.stmt (d_module, d_position, 'price_type_lookup_code', PO_PDOI_PARAMS.g_sys.price_type_lookup_code);
762: PO_LOG.stmt (d_module, d_position, 'def_inv_org_id', PO_PDOI_PARAMS.g_sys.def_inv_org_id);
763: PO_LOG.stmt (d_module, d_position, 'min_rel_amount', PO_PDOI_PARAMS.g_sys.min_rel_amount);
764: PO_LOG.stmt (d_module, d_position, 'def_quote_warning_delay', PO_PDOI_PARAMS.g_sys.def_quote_warning_delay);
765: PO_LOG.stmt (d_module, d_position, 'inspection_required_flag', PO_PDOI_PARAMS.g_sys.inspection_required_flag);
758: PO_LOG.stmt (d_module, d_position, 'line_type_id', PO_PDOI_PARAMS.g_sys.line_type_id);
759: PO_LOG.stmt (d_module, d_position, 'manual_po_num_type', PO_PDOI_PARAMS.g_sys.manual_po_num_type);
760: PO_LOG.stmt (d_module, d_position, 'user_defined_po_num_code', PO_PDOI_PARAMS.g_sys.user_defined_po_num_code);
761: PO_LOG.stmt (d_module, d_position, 'price_type_lookup_code', PO_PDOI_PARAMS.g_sys.price_type_lookup_code);
762: PO_LOG.stmt (d_module, d_position, 'def_inv_org_id', PO_PDOI_PARAMS.g_sys.def_inv_org_id);
763: PO_LOG.stmt (d_module, d_position, 'min_rel_amount', PO_PDOI_PARAMS.g_sys.min_rel_amount);
764: PO_LOG.stmt (d_module, d_position, 'def_quote_warning_delay', PO_PDOI_PARAMS.g_sys.def_quote_warning_delay);
765: PO_LOG.stmt (d_module, d_position, 'inspection_required_flag', PO_PDOI_PARAMS.g_sys.inspection_required_flag);
766: PO_LOG.stmt (d_module, d_position, 'user_defined_quote_num_code', PO_PDOI_PARAMS.g_sys.user_defined_quote_num_code);
759: PO_LOG.stmt (d_module, d_position, 'manual_po_num_type', PO_PDOI_PARAMS.g_sys.manual_po_num_type);
760: PO_LOG.stmt (d_module, d_position, 'user_defined_po_num_code', PO_PDOI_PARAMS.g_sys.user_defined_po_num_code);
761: PO_LOG.stmt (d_module, d_position, 'price_type_lookup_code', PO_PDOI_PARAMS.g_sys.price_type_lookup_code);
762: PO_LOG.stmt (d_module, d_position, 'def_inv_org_id', PO_PDOI_PARAMS.g_sys.def_inv_org_id);
763: PO_LOG.stmt (d_module, d_position, 'min_rel_amount', PO_PDOI_PARAMS.g_sys.min_rel_amount);
764: PO_LOG.stmt (d_module, d_position, 'def_quote_warning_delay', PO_PDOI_PARAMS.g_sys.def_quote_warning_delay);
765: PO_LOG.stmt (d_module, d_position, 'inspection_required_flag', PO_PDOI_PARAMS.g_sys.inspection_required_flag);
766: PO_LOG.stmt (d_module, d_position, 'user_defined_quote_num_code', PO_PDOI_PARAMS.g_sys.user_defined_quote_num_code);
767: PO_LOG.stmt (d_module, d_position, 'manual_quote_num_type', PO_PDOI_PARAMS.g_sys.manual_quote_num_type);
760: PO_LOG.stmt (d_module, d_position, 'user_defined_po_num_code', PO_PDOI_PARAMS.g_sys.user_defined_po_num_code);
761: PO_LOG.stmt (d_module, d_position, 'price_type_lookup_code', PO_PDOI_PARAMS.g_sys.price_type_lookup_code);
762: PO_LOG.stmt (d_module, d_position, 'def_inv_org_id', PO_PDOI_PARAMS.g_sys.def_inv_org_id);
763: PO_LOG.stmt (d_module, d_position, 'min_rel_amount', PO_PDOI_PARAMS.g_sys.min_rel_amount);
764: PO_LOG.stmt (d_module, d_position, 'def_quote_warning_delay', PO_PDOI_PARAMS.g_sys.def_quote_warning_delay);
765: PO_LOG.stmt (d_module, d_position, 'inspection_required_flag', PO_PDOI_PARAMS.g_sys.inspection_required_flag);
766: PO_LOG.stmt (d_module, d_position, 'user_defined_quote_num_code', PO_PDOI_PARAMS.g_sys.user_defined_quote_num_code);
767: PO_LOG.stmt (d_module, d_position, 'manual_quote_num_type', PO_PDOI_PARAMS.g_sys.manual_quote_num_type);
768: PO_LOG.stmt (d_module, d_position, 'ship_via_lookup_code', PO_PDOI_PARAMS.g_sys.ship_via_lookup_code);
761: PO_LOG.stmt (d_module, d_position, 'price_type_lookup_code', PO_PDOI_PARAMS.g_sys.price_type_lookup_code);
762: PO_LOG.stmt (d_module, d_position, 'def_inv_org_id', PO_PDOI_PARAMS.g_sys.def_inv_org_id);
763: PO_LOG.stmt (d_module, d_position, 'min_rel_amount', PO_PDOI_PARAMS.g_sys.min_rel_amount);
764: PO_LOG.stmt (d_module, d_position, 'def_quote_warning_delay', PO_PDOI_PARAMS.g_sys.def_quote_warning_delay);
765: PO_LOG.stmt (d_module, d_position, 'inspection_required_flag', PO_PDOI_PARAMS.g_sys.inspection_required_flag);
766: PO_LOG.stmt (d_module, d_position, 'user_defined_quote_num_code', PO_PDOI_PARAMS.g_sys.user_defined_quote_num_code);
767: PO_LOG.stmt (d_module, d_position, 'manual_quote_num_type', PO_PDOI_PARAMS.g_sys.manual_quote_num_type);
768: PO_LOG.stmt (d_module, d_position, 'ship_via_lookup_code', PO_PDOI_PARAMS.g_sys.ship_via_lookup_code);
769: PO_LOG.stmt (d_module, d_position, 'qty_rcv_tolerance', PO_PDOI_PARAMS.g_sys.qty_rcv_tolerance);
762: PO_LOG.stmt (d_module, d_position, 'def_inv_org_id', PO_PDOI_PARAMS.g_sys.def_inv_org_id);
763: PO_LOG.stmt (d_module, d_position, 'min_rel_amount', PO_PDOI_PARAMS.g_sys.min_rel_amount);
764: PO_LOG.stmt (d_module, d_position, 'def_quote_warning_delay', PO_PDOI_PARAMS.g_sys.def_quote_warning_delay);
765: PO_LOG.stmt (d_module, d_position, 'inspection_required_flag', PO_PDOI_PARAMS.g_sys.inspection_required_flag);
766: PO_LOG.stmt (d_module, d_position, 'user_defined_quote_num_code', PO_PDOI_PARAMS.g_sys.user_defined_quote_num_code);
767: PO_LOG.stmt (d_module, d_position, 'manual_quote_num_type', PO_PDOI_PARAMS.g_sys.manual_quote_num_type);
768: PO_LOG.stmt (d_module, d_position, 'ship_via_lookup_code', PO_PDOI_PARAMS.g_sys.ship_via_lookup_code);
769: PO_LOG.stmt (d_module, d_position, 'qty_rcv_tolerance', PO_PDOI_PARAMS.g_sys.qty_rcv_tolerance);
770: PO_LOG.stmt (d_module, d_position, 'price_break_lookup_code', PO_PDOI_PARAMS.g_sys.price_break_lookup_code);
763: PO_LOG.stmt (d_module, d_position, 'min_rel_amount', PO_PDOI_PARAMS.g_sys.min_rel_amount);
764: PO_LOG.stmt (d_module, d_position, 'def_quote_warning_delay', PO_PDOI_PARAMS.g_sys.def_quote_warning_delay);
765: PO_LOG.stmt (d_module, d_position, 'inspection_required_flag', PO_PDOI_PARAMS.g_sys.inspection_required_flag);
766: PO_LOG.stmt (d_module, d_position, 'user_defined_quote_num_code', PO_PDOI_PARAMS.g_sys.user_defined_quote_num_code);
767: PO_LOG.stmt (d_module, d_position, 'manual_quote_num_type', PO_PDOI_PARAMS.g_sys.manual_quote_num_type);
768: PO_LOG.stmt (d_module, d_position, 'ship_via_lookup_code', PO_PDOI_PARAMS.g_sys.ship_via_lookup_code);
769: PO_LOG.stmt (d_module, d_position, 'qty_rcv_tolerance', PO_PDOI_PARAMS.g_sys.qty_rcv_tolerance);
770: PO_LOG.stmt (d_module, d_position, 'price_break_lookup_code', PO_PDOI_PARAMS.g_sys.price_break_lookup_code);
771: PO_LOG.stmt (d_module, d_position, 'invoice_close_tolerance', PO_PDOI_PARAMS.g_sys.invoice_close_tolerance);
764: PO_LOG.stmt (d_module, d_position, 'def_quote_warning_delay', PO_PDOI_PARAMS.g_sys.def_quote_warning_delay);
765: PO_LOG.stmt (d_module, d_position, 'inspection_required_flag', PO_PDOI_PARAMS.g_sys.inspection_required_flag);
766: PO_LOG.stmt (d_module, d_position, 'user_defined_quote_num_code', PO_PDOI_PARAMS.g_sys.user_defined_quote_num_code);
767: PO_LOG.stmt (d_module, d_position, 'manual_quote_num_type', PO_PDOI_PARAMS.g_sys.manual_quote_num_type);
768: PO_LOG.stmt (d_module, d_position, 'ship_via_lookup_code', PO_PDOI_PARAMS.g_sys.ship_via_lookup_code);
769: PO_LOG.stmt (d_module, d_position, 'qty_rcv_tolerance', PO_PDOI_PARAMS.g_sys.qty_rcv_tolerance);
770: PO_LOG.stmt (d_module, d_position, 'price_break_lookup_code', PO_PDOI_PARAMS.g_sys.price_break_lookup_code);
771: PO_LOG.stmt (d_module, d_position, 'invoice_close_tolerance', PO_PDOI_PARAMS.g_sys.invoice_close_tolerance);
772: PO_LOG.stmt (d_module, d_position, 'receive_close_tolerance', PO_PDOI_PARAMS.g_sys.receive_close_tolerance);
765: PO_LOG.stmt (d_module, d_position, 'inspection_required_flag', PO_PDOI_PARAMS.g_sys.inspection_required_flag);
766: PO_LOG.stmt (d_module, d_position, 'user_defined_quote_num_code', PO_PDOI_PARAMS.g_sys.user_defined_quote_num_code);
767: PO_LOG.stmt (d_module, d_position, 'manual_quote_num_type', PO_PDOI_PARAMS.g_sys.manual_quote_num_type);
768: PO_LOG.stmt (d_module, d_position, 'ship_via_lookup_code', PO_PDOI_PARAMS.g_sys.ship_via_lookup_code);
769: PO_LOG.stmt (d_module, d_position, 'qty_rcv_tolerance', PO_PDOI_PARAMS.g_sys.qty_rcv_tolerance);
770: PO_LOG.stmt (d_module, d_position, 'price_break_lookup_code', PO_PDOI_PARAMS.g_sys.price_break_lookup_code);
771: PO_LOG.stmt (d_module, d_position, 'invoice_close_tolerance', PO_PDOI_PARAMS.g_sys.invoice_close_tolerance);
772: PO_LOG.stmt (d_module, d_position, 'receive_close_tolerance', PO_PDOI_PARAMS.g_sys.receive_close_tolerance);
773: PO_LOG.stmt (d_module, d_position, 'expense_accrual_code', PO_PDOI_PARAMS.g_sys.expense_accrual_code);
766: PO_LOG.stmt (d_module, d_position, 'user_defined_quote_num_code', PO_PDOI_PARAMS.g_sys.user_defined_quote_num_code);
767: PO_LOG.stmt (d_module, d_position, 'manual_quote_num_type', PO_PDOI_PARAMS.g_sys.manual_quote_num_type);
768: PO_LOG.stmt (d_module, d_position, 'ship_via_lookup_code', PO_PDOI_PARAMS.g_sys.ship_via_lookup_code);
769: PO_LOG.stmt (d_module, d_position, 'qty_rcv_tolerance', PO_PDOI_PARAMS.g_sys.qty_rcv_tolerance);
770: PO_LOG.stmt (d_module, d_position, 'price_break_lookup_code', PO_PDOI_PARAMS.g_sys.price_break_lookup_code);
771: PO_LOG.stmt (d_module, d_position, 'invoice_close_tolerance', PO_PDOI_PARAMS.g_sys.invoice_close_tolerance);
772: PO_LOG.stmt (d_module, d_position, 'receive_close_tolerance', PO_PDOI_PARAMS.g_sys.receive_close_tolerance);
773: PO_LOG.stmt (d_module, d_position, 'expense_accrual_code', PO_PDOI_PARAMS.g_sys.expense_accrual_code);
774: PO_LOG.stmt (d_module, d_position, 'master_inv_org_id', PO_PDOI_PARAMS.g_sys.master_inv_org_id);
767: PO_LOG.stmt (d_module, d_position, 'manual_quote_num_type', PO_PDOI_PARAMS.g_sys.manual_quote_num_type);
768: PO_LOG.stmt (d_module, d_position, 'ship_via_lookup_code', PO_PDOI_PARAMS.g_sys.ship_via_lookup_code);
769: PO_LOG.stmt (d_module, d_position, 'qty_rcv_tolerance', PO_PDOI_PARAMS.g_sys.qty_rcv_tolerance);
770: PO_LOG.stmt (d_module, d_position, 'price_break_lookup_code', PO_PDOI_PARAMS.g_sys.price_break_lookup_code);
771: PO_LOG.stmt (d_module, d_position, 'invoice_close_tolerance', PO_PDOI_PARAMS.g_sys.invoice_close_tolerance);
772: PO_LOG.stmt (d_module, d_position, 'receive_close_tolerance', PO_PDOI_PARAMS.g_sys.receive_close_tolerance);
773: PO_LOG.stmt (d_module, d_position, 'expense_accrual_code', PO_PDOI_PARAMS.g_sys.expense_accrual_code);
774: PO_LOG.stmt (d_module, d_position, 'master_inv_org_id', PO_PDOI_PARAMS.g_sys.master_inv_org_id);
775: PO_LOG.stmt (d_module, d_position, 'enforce_ship_to_loc', PO_PDOI_PARAMS.g_sys.enforce_ship_to_loc);
768: PO_LOG.stmt (d_module, d_position, 'ship_via_lookup_code', PO_PDOI_PARAMS.g_sys.ship_via_lookup_code);
769: PO_LOG.stmt (d_module, d_position, 'qty_rcv_tolerance', PO_PDOI_PARAMS.g_sys.qty_rcv_tolerance);
770: PO_LOG.stmt (d_module, d_position, 'price_break_lookup_code', PO_PDOI_PARAMS.g_sys.price_break_lookup_code);
771: PO_LOG.stmt (d_module, d_position, 'invoice_close_tolerance', PO_PDOI_PARAMS.g_sys.invoice_close_tolerance);
772: PO_LOG.stmt (d_module, d_position, 'receive_close_tolerance', PO_PDOI_PARAMS.g_sys.receive_close_tolerance);
773: PO_LOG.stmt (d_module, d_position, 'expense_accrual_code', PO_PDOI_PARAMS.g_sys.expense_accrual_code);
774: PO_LOG.stmt (d_module, d_position, 'master_inv_org_id', PO_PDOI_PARAMS.g_sys.master_inv_org_id);
775: PO_LOG.stmt (d_module, d_position, 'enforce_ship_to_loc', PO_PDOI_PARAMS.g_sys.enforce_ship_to_loc);
776: PO_LOG.stmt (d_module, d_position, 'allow_substitutes', PO_PDOI_PARAMS.g_sys.allow_substitutes);
769: PO_LOG.stmt (d_module, d_position, 'qty_rcv_tolerance', PO_PDOI_PARAMS.g_sys.qty_rcv_tolerance);
770: PO_LOG.stmt (d_module, d_position, 'price_break_lookup_code', PO_PDOI_PARAMS.g_sys.price_break_lookup_code);
771: PO_LOG.stmt (d_module, d_position, 'invoice_close_tolerance', PO_PDOI_PARAMS.g_sys.invoice_close_tolerance);
772: PO_LOG.stmt (d_module, d_position, 'receive_close_tolerance', PO_PDOI_PARAMS.g_sys.receive_close_tolerance);
773: PO_LOG.stmt (d_module, d_position, 'expense_accrual_code', PO_PDOI_PARAMS.g_sys.expense_accrual_code);
774: PO_LOG.stmt (d_module, d_position, 'master_inv_org_id', PO_PDOI_PARAMS.g_sys.master_inv_org_id);
775: PO_LOG.stmt (d_module, d_position, 'enforce_ship_to_loc', PO_PDOI_PARAMS.g_sys.enforce_ship_to_loc);
776: PO_LOG.stmt (d_module, d_position, 'allow_substitutes', PO_PDOI_PARAMS.g_sys.allow_substitutes);
777: PO_LOG.stmt (d_module, d_position, 'routing_id', PO_PDOI_PARAMS.g_sys.routing_id);
770: PO_LOG.stmt (d_module, d_position, 'price_break_lookup_code', PO_PDOI_PARAMS.g_sys.price_break_lookup_code);
771: PO_LOG.stmt (d_module, d_position, 'invoice_close_tolerance', PO_PDOI_PARAMS.g_sys.invoice_close_tolerance);
772: PO_LOG.stmt (d_module, d_position, 'receive_close_tolerance', PO_PDOI_PARAMS.g_sys.receive_close_tolerance);
773: PO_LOG.stmt (d_module, d_position, 'expense_accrual_code', PO_PDOI_PARAMS.g_sys.expense_accrual_code);
774: PO_LOG.stmt (d_module, d_position, 'master_inv_org_id', PO_PDOI_PARAMS.g_sys.master_inv_org_id);
775: PO_LOG.stmt (d_module, d_position, 'enforce_ship_to_loc', PO_PDOI_PARAMS.g_sys.enforce_ship_to_loc);
776: PO_LOG.stmt (d_module, d_position, 'allow_substitutes', PO_PDOI_PARAMS.g_sys.allow_substitutes);
777: PO_LOG.stmt (d_module, d_position, 'routing_id', PO_PDOI_PARAMS.g_sys.routing_id);
778: PO_LOG.stmt (d_module, d_position, 'qty_rcv_exception', PO_PDOI_PARAMS.g_sys.qty_rcv_exception);
771: PO_LOG.stmt (d_module, d_position, 'invoice_close_tolerance', PO_PDOI_PARAMS.g_sys.invoice_close_tolerance);
772: PO_LOG.stmt (d_module, d_position, 'receive_close_tolerance', PO_PDOI_PARAMS.g_sys.receive_close_tolerance);
773: PO_LOG.stmt (d_module, d_position, 'expense_accrual_code', PO_PDOI_PARAMS.g_sys.expense_accrual_code);
774: PO_LOG.stmt (d_module, d_position, 'master_inv_org_id', PO_PDOI_PARAMS.g_sys.master_inv_org_id);
775: PO_LOG.stmt (d_module, d_position, 'enforce_ship_to_loc', PO_PDOI_PARAMS.g_sys.enforce_ship_to_loc);
776: PO_LOG.stmt (d_module, d_position, 'allow_substitutes', PO_PDOI_PARAMS.g_sys.allow_substitutes);
777: PO_LOG.stmt (d_module, d_position, 'routing_id', PO_PDOI_PARAMS.g_sys.routing_id);
778: PO_LOG.stmt (d_module, d_position, 'qty_rcv_exception', PO_PDOI_PARAMS.g_sys.qty_rcv_exception);
779: PO_LOG.stmt (d_module, d_position, 'days_early_receipt', PO_PDOI_PARAMS.g_sys.days_early_receipt);
772: PO_LOG.stmt (d_module, d_position, 'receive_close_tolerance', PO_PDOI_PARAMS.g_sys.receive_close_tolerance);
773: PO_LOG.stmt (d_module, d_position, 'expense_accrual_code', PO_PDOI_PARAMS.g_sys.expense_accrual_code);
774: PO_LOG.stmt (d_module, d_position, 'master_inv_org_id', PO_PDOI_PARAMS.g_sys.master_inv_org_id);
775: PO_LOG.stmt (d_module, d_position, 'enforce_ship_to_loc', PO_PDOI_PARAMS.g_sys.enforce_ship_to_loc);
776: PO_LOG.stmt (d_module, d_position, 'allow_substitutes', PO_PDOI_PARAMS.g_sys.allow_substitutes);
777: PO_LOG.stmt (d_module, d_position, 'routing_id', PO_PDOI_PARAMS.g_sys.routing_id);
778: PO_LOG.stmt (d_module, d_position, 'qty_rcv_exception', PO_PDOI_PARAMS.g_sys.qty_rcv_exception);
779: PO_LOG.stmt (d_module, d_position, 'days_early_receipt', PO_PDOI_PARAMS.g_sys.days_early_receipt);
780: PO_LOG.stmt (d_module, d_position, 'days_late_receipt', PO_PDOI_PARAMS.g_sys.days_late_receipt);
773: PO_LOG.stmt (d_module, d_position, 'expense_accrual_code', PO_PDOI_PARAMS.g_sys.expense_accrual_code);
774: PO_LOG.stmt (d_module, d_position, 'master_inv_org_id', PO_PDOI_PARAMS.g_sys.master_inv_org_id);
775: PO_LOG.stmt (d_module, d_position, 'enforce_ship_to_loc', PO_PDOI_PARAMS.g_sys.enforce_ship_to_loc);
776: PO_LOG.stmt (d_module, d_position, 'allow_substitutes', PO_PDOI_PARAMS.g_sys.allow_substitutes);
777: PO_LOG.stmt (d_module, d_position, 'routing_id', PO_PDOI_PARAMS.g_sys.routing_id);
778: PO_LOG.stmt (d_module, d_position, 'qty_rcv_exception', PO_PDOI_PARAMS.g_sys.qty_rcv_exception);
779: PO_LOG.stmt (d_module, d_position, 'days_early_receipt', PO_PDOI_PARAMS.g_sys.days_early_receipt);
780: PO_LOG.stmt (d_module, d_position, 'days_late_receipt', PO_PDOI_PARAMS.g_sys.days_late_receipt);
781: PO_LOG.stmt (d_module, d_position, 'rcv_days_exception', PO_PDOI_PARAMS.g_sys.rcv_days_exception);
774: PO_LOG.stmt (d_module, d_position, 'master_inv_org_id', PO_PDOI_PARAMS.g_sys.master_inv_org_id);
775: PO_LOG.stmt (d_module, d_position, 'enforce_ship_to_loc', PO_PDOI_PARAMS.g_sys.enforce_ship_to_loc);
776: PO_LOG.stmt (d_module, d_position, 'allow_substitutes', PO_PDOI_PARAMS.g_sys.allow_substitutes);
777: PO_LOG.stmt (d_module, d_position, 'routing_id', PO_PDOI_PARAMS.g_sys.routing_id);
778: PO_LOG.stmt (d_module, d_position, 'qty_rcv_exception', PO_PDOI_PARAMS.g_sys.qty_rcv_exception);
779: PO_LOG.stmt (d_module, d_position, 'days_early_receipt', PO_PDOI_PARAMS.g_sys.days_early_receipt);
780: PO_LOG.stmt (d_module, d_position, 'days_late_receipt', PO_PDOI_PARAMS.g_sys.days_late_receipt);
781: PO_LOG.stmt (d_module, d_position, 'rcv_days_exception', PO_PDOI_PARAMS.g_sys.rcv_days_exception);
782: PO_LOG.stmt (d_module, d_position, 'supplier_auth_acc', PO_PDOI_PARAMS.g_sys.supplier_auth_acc);
775: PO_LOG.stmt (d_module, d_position, 'enforce_ship_to_loc', PO_PDOI_PARAMS.g_sys.enforce_ship_to_loc);
776: PO_LOG.stmt (d_module, d_position, 'allow_substitutes', PO_PDOI_PARAMS.g_sys.allow_substitutes);
777: PO_LOG.stmt (d_module, d_position, 'routing_id', PO_PDOI_PARAMS.g_sys.routing_id);
778: PO_LOG.stmt (d_module, d_position, 'qty_rcv_exception', PO_PDOI_PARAMS.g_sys.qty_rcv_exception);
779: PO_LOG.stmt (d_module, d_position, 'days_early_receipt', PO_PDOI_PARAMS.g_sys.days_early_receipt);
780: PO_LOG.stmt (d_module, d_position, 'days_late_receipt', PO_PDOI_PARAMS.g_sys.days_late_receipt);
781: PO_LOG.stmt (d_module, d_position, 'rcv_days_exception', PO_PDOI_PARAMS.g_sys.rcv_days_exception);
782: PO_LOG.stmt (d_module, d_position, 'supplier_auth_acc', PO_PDOI_PARAMS.g_sys.supplier_auth_acc);
783: PO_LOG.stmt (d_module, d_position, 'cat_admin_auth_acc', PO_PDOI_PARAMS.g_sys.cat_admin_auth_acc);
776: PO_LOG.stmt (d_module, d_position, 'allow_substitutes', PO_PDOI_PARAMS.g_sys.allow_substitutes);
777: PO_LOG.stmt (d_module, d_position, 'routing_id', PO_PDOI_PARAMS.g_sys.routing_id);
778: PO_LOG.stmt (d_module, d_position, 'qty_rcv_exception', PO_PDOI_PARAMS.g_sys.qty_rcv_exception);
779: PO_LOG.stmt (d_module, d_position, 'days_early_receipt', PO_PDOI_PARAMS.g_sys.days_early_receipt);
780: PO_LOG.stmt (d_module, d_position, 'days_late_receipt', PO_PDOI_PARAMS.g_sys.days_late_receipt);
781: PO_LOG.stmt (d_module, d_position, 'rcv_days_exception', PO_PDOI_PARAMS.g_sys.rcv_days_exception);
782: PO_LOG.stmt (d_module, d_position, 'supplier_auth_acc', PO_PDOI_PARAMS.g_sys.supplier_auth_acc);
783: PO_LOG.stmt (d_module, d_position, 'cat_admin_auth_acc', PO_PDOI_PARAMS.g_sys.cat_admin_auth_acc);
784: PO_LOG.stmt (d_module, d_position, 'invoice_match_option', PO_PDOI_PARAMS.g_sys.invoice_match_option);
777: PO_LOG.stmt (d_module, d_position, 'routing_id', PO_PDOI_PARAMS.g_sys.routing_id);
778: PO_LOG.stmt (d_module, d_position, 'qty_rcv_exception', PO_PDOI_PARAMS.g_sys.qty_rcv_exception);
779: PO_LOG.stmt (d_module, d_position, 'days_early_receipt', PO_PDOI_PARAMS.g_sys.days_early_receipt);
780: PO_LOG.stmt (d_module, d_position, 'days_late_receipt', PO_PDOI_PARAMS.g_sys.days_late_receipt);
781: PO_LOG.stmt (d_module, d_position, 'rcv_days_exception', PO_PDOI_PARAMS.g_sys.rcv_days_exception);
782: PO_LOG.stmt (d_module, d_position, 'supplier_auth_acc', PO_PDOI_PARAMS.g_sys.supplier_auth_acc);
783: PO_LOG.stmt (d_module, d_position, 'cat_admin_auth_acc', PO_PDOI_PARAMS.g_sys.cat_admin_auth_acc);
784: PO_LOG.stmt (d_module, d_position, 'invoice_match_option', PO_PDOI_PARAMS.g_sys.invoice_match_option);
785: PO_LOG.stmt (d_module, d_position, 'when_to_archive_blanket', PO_PDOI_PARAMS.g_sys.when_to_archive_blanket);
778: PO_LOG.stmt (d_module, d_position, 'qty_rcv_exception', PO_PDOI_PARAMS.g_sys.qty_rcv_exception);
779: PO_LOG.stmt (d_module, d_position, 'days_early_receipt', PO_PDOI_PARAMS.g_sys.days_early_receipt);
780: PO_LOG.stmt (d_module, d_position, 'days_late_receipt', PO_PDOI_PARAMS.g_sys.days_late_receipt);
781: PO_LOG.stmt (d_module, d_position, 'rcv_days_exception', PO_PDOI_PARAMS.g_sys.rcv_days_exception);
782: PO_LOG.stmt (d_module, d_position, 'supplier_auth_acc', PO_PDOI_PARAMS.g_sys.supplier_auth_acc);
783: PO_LOG.stmt (d_module, d_position, 'cat_admin_auth_acc', PO_PDOI_PARAMS.g_sys.cat_admin_auth_acc);
784: PO_LOG.stmt (d_module, d_position, 'invoice_match_option', PO_PDOI_PARAMS.g_sys.invoice_match_option);
785: PO_LOG.stmt (d_module, d_position, 'when_to_archive_blanket', PO_PDOI_PARAMS.g_sys.when_to_archive_blanket);
786: PO_LOG.stmt (d_module, d_position, 'when_to_archive_std_po', PO_PDOI_PARAMS.g_sys.when_to_archive_std_po);
779: PO_LOG.stmt (d_module, d_position, 'days_early_receipt', PO_PDOI_PARAMS.g_sys.days_early_receipt);
780: PO_LOG.stmt (d_module, d_position, 'days_late_receipt', PO_PDOI_PARAMS.g_sys.days_late_receipt);
781: PO_LOG.stmt (d_module, d_position, 'rcv_days_exception', PO_PDOI_PARAMS.g_sys.rcv_days_exception);
782: PO_LOG.stmt (d_module, d_position, 'supplier_auth_acc', PO_PDOI_PARAMS.g_sys.supplier_auth_acc);
783: PO_LOG.stmt (d_module, d_position, 'cat_admin_auth_acc', PO_PDOI_PARAMS.g_sys.cat_admin_auth_acc);
784: PO_LOG.stmt (d_module, d_position, 'invoice_match_option', PO_PDOI_PARAMS.g_sys.invoice_match_option);
785: PO_LOG.stmt (d_module, d_position, 'when_to_archive_blanket', PO_PDOI_PARAMS.g_sys.when_to_archive_blanket);
786: PO_LOG.stmt (d_module, d_position, 'when_to_archive_std_po', PO_PDOI_PARAMS.g_sys.when_to_archive_std_po);
787: PO_LOG.stmt (d_module, d_position, 'def_business_group_id', PO_PDOI_PARAMS.g_sys.def_business_group_id);
780: PO_LOG.stmt (d_module, d_position, 'days_late_receipt', PO_PDOI_PARAMS.g_sys.days_late_receipt);
781: PO_LOG.stmt (d_module, d_position, 'rcv_days_exception', PO_PDOI_PARAMS.g_sys.rcv_days_exception);
782: PO_LOG.stmt (d_module, d_position, 'supplier_auth_acc', PO_PDOI_PARAMS.g_sys.supplier_auth_acc);
783: PO_LOG.stmt (d_module, d_position, 'cat_admin_auth_acc', PO_PDOI_PARAMS.g_sys.cat_admin_auth_acc);
784: PO_LOG.stmt (d_module, d_position, 'invoice_match_option', PO_PDOI_PARAMS.g_sys.invoice_match_option);
785: PO_LOG.stmt (d_module, d_position, 'when_to_archive_blanket', PO_PDOI_PARAMS.g_sys.when_to_archive_blanket);
786: PO_LOG.stmt (d_module, d_position, 'when_to_archive_std_po', PO_PDOI_PARAMS.g_sys.when_to_archive_std_po);
787: PO_LOG.stmt (d_module, d_position, 'def_business_group_id', PO_PDOI_PARAMS.g_sys.def_business_group_id);
788: PO_LOG.stmt (d_module, d_position, 'def_structure_id', PO_PDOI_PARAMS.g_sys.def_structure_id);
781: PO_LOG.stmt (d_module, d_position, 'rcv_days_exception', PO_PDOI_PARAMS.g_sys.rcv_days_exception);
782: PO_LOG.stmt (d_module, d_position, 'supplier_auth_acc', PO_PDOI_PARAMS.g_sys.supplier_auth_acc);
783: PO_LOG.stmt (d_module, d_position, 'cat_admin_auth_acc', PO_PDOI_PARAMS.g_sys.cat_admin_auth_acc);
784: PO_LOG.stmt (d_module, d_position, 'invoice_match_option', PO_PDOI_PARAMS.g_sys.invoice_match_option);
785: PO_LOG.stmt (d_module, d_position, 'when_to_archive_blanket', PO_PDOI_PARAMS.g_sys.when_to_archive_blanket);
786: PO_LOG.stmt (d_module, d_position, 'when_to_archive_std_po', PO_PDOI_PARAMS.g_sys.when_to_archive_std_po);
787: PO_LOG.stmt (d_module, d_position, 'def_business_group_id', PO_PDOI_PARAMS.g_sys.def_business_group_id);
788: PO_LOG.stmt (d_module, d_position, 'def_structure_id', PO_PDOI_PARAMS.g_sys.def_structure_id);
789: PO_LOG.stmt (d_module, d_position, 'def_cat_set_id', PO_PDOI_PARAMS.g_sys.def_cat_set_id);
782: PO_LOG.stmt (d_module, d_position, 'supplier_auth_acc', PO_PDOI_PARAMS.g_sys.supplier_auth_acc);
783: PO_LOG.stmt (d_module, d_position, 'cat_admin_auth_acc', PO_PDOI_PARAMS.g_sys.cat_admin_auth_acc);
784: PO_LOG.stmt (d_module, d_position, 'invoice_match_option', PO_PDOI_PARAMS.g_sys.invoice_match_option);
785: PO_LOG.stmt (d_module, d_position, 'when_to_archive_blanket', PO_PDOI_PARAMS.g_sys.when_to_archive_blanket);
786: PO_LOG.stmt (d_module, d_position, 'when_to_archive_std_po', PO_PDOI_PARAMS.g_sys.when_to_archive_std_po);
787: PO_LOG.stmt (d_module, d_position, 'def_business_group_id', PO_PDOI_PARAMS.g_sys.def_business_group_id);
788: PO_LOG.stmt (d_module, d_position, 'def_structure_id', PO_PDOI_PARAMS.g_sys.def_structure_id);
789: PO_LOG.stmt (d_module, d_position, 'def_cat_set_id', PO_PDOI_PARAMS.g_sys.def_cat_set_id);
790: PO_LOG.stmt (d_module, d_position, 'def_category_id', PO_PDOI_PARAMS.g_sys.def_category_id);
783: PO_LOG.stmt (d_module, d_position, 'cat_admin_auth_acc', PO_PDOI_PARAMS.g_sys.cat_admin_auth_acc);
784: PO_LOG.stmt (d_module, d_position, 'invoice_match_option', PO_PDOI_PARAMS.g_sys.invoice_match_option);
785: PO_LOG.stmt (d_module, d_position, 'when_to_archive_blanket', PO_PDOI_PARAMS.g_sys.when_to_archive_blanket);
786: PO_LOG.stmt (d_module, d_position, 'when_to_archive_std_po', PO_PDOI_PARAMS.g_sys.when_to_archive_std_po);
787: PO_LOG.stmt (d_module, d_position, 'def_business_group_id', PO_PDOI_PARAMS.g_sys.def_business_group_id);
788: PO_LOG.stmt (d_module, d_position, 'def_structure_id', PO_PDOI_PARAMS.g_sys.def_structure_id);
789: PO_LOG.stmt (d_module, d_position, 'def_cat_set_id', PO_PDOI_PARAMS.g_sys.def_cat_set_id);
790: PO_LOG.stmt (d_module, d_position, 'def_category_id', PO_PDOI_PARAMS.g_sys.def_category_id);
791: PO_LOG.stmt (d_module, d_position, 'is_federal_instance', PO_PDOI_PARAMS.g_sys.is_federal_instance);
784: PO_LOG.stmt (d_module, d_position, 'invoice_match_option', PO_PDOI_PARAMS.g_sys.invoice_match_option);
785: PO_LOG.stmt (d_module, d_position, 'when_to_archive_blanket', PO_PDOI_PARAMS.g_sys.when_to_archive_blanket);
786: PO_LOG.stmt (d_module, d_position, 'when_to_archive_std_po', PO_PDOI_PARAMS.g_sys.when_to_archive_std_po);
787: PO_LOG.stmt (d_module, d_position, 'def_business_group_id', PO_PDOI_PARAMS.g_sys.def_business_group_id);
788: PO_LOG.stmt (d_module, d_position, 'def_structure_id', PO_PDOI_PARAMS.g_sys.def_structure_id);
789: PO_LOG.stmt (d_module, d_position, 'def_cat_set_id', PO_PDOI_PARAMS.g_sys.def_cat_set_id);
790: PO_LOG.stmt (d_module, d_position, 'def_category_id', PO_PDOI_PARAMS.g_sys.def_category_id);
791: PO_LOG.stmt (d_module, d_position, 'is_federal_instance', PO_PDOI_PARAMS.g_sys.is_federal_instance);
792: END IF;
785: PO_LOG.stmt (d_module, d_position, 'when_to_archive_blanket', PO_PDOI_PARAMS.g_sys.when_to_archive_blanket);
786: PO_LOG.stmt (d_module, d_position, 'when_to_archive_std_po', PO_PDOI_PARAMS.g_sys.when_to_archive_std_po);
787: PO_LOG.stmt (d_module, d_position, 'def_business_group_id', PO_PDOI_PARAMS.g_sys.def_business_group_id);
788: PO_LOG.stmt (d_module, d_position, 'def_structure_id', PO_PDOI_PARAMS.g_sys.def_structure_id);
789: PO_LOG.stmt (d_module, d_position, 'def_cat_set_id', PO_PDOI_PARAMS.g_sys.def_cat_set_id);
790: PO_LOG.stmt (d_module, d_position, 'def_category_id', PO_PDOI_PARAMS.g_sys.def_category_id);
791: PO_LOG.stmt (d_module, d_position, 'is_federal_instance', PO_PDOI_PARAMS.g_sys.is_federal_instance);
792: END IF;
793:
786: PO_LOG.stmt (d_module, d_position, 'when_to_archive_std_po', PO_PDOI_PARAMS.g_sys.when_to_archive_std_po);
787: PO_LOG.stmt (d_module, d_position, 'def_business_group_id', PO_PDOI_PARAMS.g_sys.def_business_group_id);
788: PO_LOG.stmt (d_module, d_position, 'def_structure_id', PO_PDOI_PARAMS.g_sys.def_structure_id);
789: PO_LOG.stmt (d_module, d_position, 'def_cat_set_id', PO_PDOI_PARAMS.g_sys.def_cat_set_id);
790: PO_LOG.stmt (d_module, d_position, 'def_category_id', PO_PDOI_PARAMS.g_sys.def_category_id);
791: PO_LOG.stmt (d_module, d_position, 'is_federal_instance', PO_PDOI_PARAMS.g_sys.is_federal_instance);
792: END IF;
793:
794: IF (PO_LOG.d_proc) THEN
787: PO_LOG.stmt (d_module, d_position, 'def_business_group_id', PO_PDOI_PARAMS.g_sys.def_business_group_id);
788: PO_LOG.stmt (d_module, d_position, 'def_structure_id', PO_PDOI_PARAMS.g_sys.def_structure_id);
789: PO_LOG.stmt (d_module, d_position, 'def_cat_set_id', PO_PDOI_PARAMS.g_sys.def_cat_set_id);
790: PO_LOG.stmt (d_module, d_position, 'def_category_id', PO_PDOI_PARAMS.g_sys.def_category_id);
791: PO_LOG.stmt (d_module, d_position, 'is_federal_instance', PO_PDOI_PARAMS.g_sys.is_federal_instance);
792: END IF;
793:
794: IF (PO_LOG.d_proc) THEN
795: PO_LOG.proc_end (d_module);
790: PO_LOG.stmt (d_module, d_position, 'def_category_id', PO_PDOI_PARAMS.g_sys.def_category_id);
791: PO_LOG.stmt (d_module, d_position, 'is_federal_instance', PO_PDOI_PARAMS.g_sys.is_federal_instance);
792: END IF;
793:
794: IF (PO_LOG.d_proc) THEN
795: PO_LOG.proc_end (d_module);
796: END IF;
797:
798: EXCEPTION
791: PO_LOG.stmt (d_module, d_position, 'is_federal_instance', PO_PDOI_PARAMS.g_sys.is_federal_instance);
792: END IF;
793:
794: IF (PO_LOG.d_proc) THEN
795: PO_LOG.proc_end (d_module);
796: END IF;
797:
798: EXCEPTION
799: WHEN OTHERS THEN
825:
826: BEGIN
827: d_position := 0;
828:
829: IF (PO_LOG.d_proc) THEN
830: PO_LOG.proc_begin (d_module);
831: END IF;
832:
833: PO_PDOI_PARAMS.g_profile.pdoi_write_to_file :=
826: BEGIN
827: d_position := 0;
828:
829: IF (PO_LOG.d_proc) THEN
830: PO_LOG.proc_begin (d_module);
831: END IF;
832:
833: PO_PDOI_PARAMS.g_profile.pdoi_write_to_file :=
834: NVL(FND_PROFILE.value('PO_PDOI_WRITE_TO_FILE'),'N');
855: PO_PDOI_PARAMS.g_profile.allow_tax_code_override :=
856: NVL(FND_PROFILE.value('ZX_ALLOW_TAX_CLASSIF_OVERRIDE'), 'Y');
857:
858:
859: IF (PO_LOG.d_stmt) THEN
860: PO_LOG.stmt (d_module, d_position, 'pdoi_write_to_file', PO_PDOI_PARAMS.g_profile.pdoi_write_to_file);
861: PO_LOG.stmt (d_module, d_position, 'service_uom_class', PO_PDOI_PARAMS.g_profile.service_uom_class);
862: PO_LOG.stmt (d_module, d_position, 'pdoi_archive_on_approval', PO_PDOI_PARAMS.g_profile.pdoi_archive_on_approval);
863: PO_LOG.stmt (d_module, d_position, 'override_funds', PO_PDOI_PARAMS.g_profile.override_funds);
856: NVL(FND_PROFILE.value('ZX_ALLOW_TAX_CLASSIF_OVERRIDE'), 'Y');
857:
858:
859: IF (PO_LOG.d_stmt) THEN
860: PO_LOG.stmt (d_module, d_position, 'pdoi_write_to_file', PO_PDOI_PARAMS.g_profile.pdoi_write_to_file);
861: PO_LOG.stmt (d_module, d_position, 'service_uom_class', PO_PDOI_PARAMS.g_profile.service_uom_class);
862: PO_LOG.stmt (d_module, d_position, 'pdoi_archive_on_approval', PO_PDOI_PARAMS.g_profile.pdoi_archive_on_approval);
863: PO_LOG.stmt (d_module, d_position, 'override_funds', PO_PDOI_PARAMS.g_profile.override_funds);
864: PO_LOG.stmt (d_module, d_position, 'xbg', PO_PDOI_PARAMS.g_profile.xbg);
857:
858:
859: IF (PO_LOG.d_stmt) THEN
860: PO_LOG.stmt (d_module, d_position, 'pdoi_write_to_file', PO_PDOI_PARAMS.g_profile.pdoi_write_to_file);
861: PO_LOG.stmt (d_module, d_position, 'service_uom_class', PO_PDOI_PARAMS.g_profile.service_uom_class);
862: PO_LOG.stmt (d_module, d_position, 'pdoi_archive_on_approval', PO_PDOI_PARAMS.g_profile.pdoi_archive_on_approval);
863: PO_LOG.stmt (d_module, d_position, 'override_funds', PO_PDOI_PARAMS.g_profile.override_funds);
864: PO_LOG.stmt (d_module, d_position, 'xbg', PO_PDOI_PARAMS.g_profile.xbg);
865: PO_LOG.stmt (d_module, d_position, 'po_price_update_tolerance', PO_PDOI_PARAMS.g_profile.po_price_update_tolerance);
858:
859: IF (PO_LOG.d_stmt) THEN
860: PO_LOG.stmt (d_module, d_position, 'pdoi_write_to_file', PO_PDOI_PARAMS.g_profile.pdoi_write_to_file);
861: PO_LOG.stmt (d_module, d_position, 'service_uom_class', PO_PDOI_PARAMS.g_profile.service_uom_class);
862: PO_LOG.stmt (d_module, d_position, 'pdoi_archive_on_approval', PO_PDOI_PARAMS.g_profile.pdoi_archive_on_approval);
863: PO_LOG.stmt (d_module, d_position, 'override_funds', PO_PDOI_PARAMS.g_profile.override_funds);
864: PO_LOG.stmt (d_module, d_position, 'xbg', PO_PDOI_PARAMS.g_profile.xbg);
865: PO_LOG.stmt (d_module, d_position, 'po_price_update_tolerance', PO_PDOI_PARAMS.g_profile.po_price_update_tolerance);
866: PO_LOG.stmt (d_module, d_position, 'allow_tax_rate_override', PO_PDOI_PARAMS.g_profile.allow_tax_rate_override);
859: IF (PO_LOG.d_stmt) THEN
860: PO_LOG.stmt (d_module, d_position, 'pdoi_write_to_file', PO_PDOI_PARAMS.g_profile.pdoi_write_to_file);
861: PO_LOG.stmt (d_module, d_position, 'service_uom_class', PO_PDOI_PARAMS.g_profile.service_uom_class);
862: PO_LOG.stmt (d_module, d_position, 'pdoi_archive_on_approval', PO_PDOI_PARAMS.g_profile.pdoi_archive_on_approval);
863: PO_LOG.stmt (d_module, d_position, 'override_funds', PO_PDOI_PARAMS.g_profile.override_funds);
864: PO_LOG.stmt (d_module, d_position, 'xbg', PO_PDOI_PARAMS.g_profile.xbg);
865: PO_LOG.stmt (d_module, d_position, 'po_price_update_tolerance', PO_PDOI_PARAMS.g_profile.po_price_update_tolerance);
866: PO_LOG.stmt (d_module, d_position, 'allow_tax_rate_override', PO_PDOI_PARAMS.g_profile.allow_tax_rate_override);
867: PO_LOG.stmt (d_module, d_position, 'allow_tax_code_override', PO_PDOI_PARAMS.g_profile.allow_tax_code_override);
860: PO_LOG.stmt (d_module, d_position, 'pdoi_write_to_file', PO_PDOI_PARAMS.g_profile.pdoi_write_to_file);
861: PO_LOG.stmt (d_module, d_position, 'service_uom_class', PO_PDOI_PARAMS.g_profile.service_uom_class);
862: PO_LOG.stmt (d_module, d_position, 'pdoi_archive_on_approval', PO_PDOI_PARAMS.g_profile.pdoi_archive_on_approval);
863: PO_LOG.stmt (d_module, d_position, 'override_funds', PO_PDOI_PARAMS.g_profile.override_funds);
864: PO_LOG.stmt (d_module, d_position, 'xbg', PO_PDOI_PARAMS.g_profile.xbg);
865: PO_LOG.stmt (d_module, d_position, 'po_price_update_tolerance', PO_PDOI_PARAMS.g_profile.po_price_update_tolerance);
866: PO_LOG.stmt (d_module, d_position, 'allow_tax_rate_override', PO_PDOI_PARAMS.g_profile.allow_tax_rate_override);
867: PO_LOG.stmt (d_module, d_position, 'allow_tax_code_override', PO_PDOI_PARAMS.g_profile.allow_tax_code_override);
868: END IF;
861: PO_LOG.stmt (d_module, d_position, 'service_uom_class', PO_PDOI_PARAMS.g_profile.service_uom_class);
862: PO_LOG.stmt (d_module, d_position, 'pdoi_archive_on_approval', PO_PDOI_PARAMS.g_profile.pdoi_archive_on_approval);
863: PO_LOG.stmt (d_module, d_position, 'override_funds', PO_PDOI_PARAMS.g_profile.override_funds);
864: PO_LOG.stmt (d_module, d_position, 'xbg', PO_PDOI_PARAMS.g_profile.xbg);
865: PO_LOG.stmt (d_module, d_position, 'po_price_update_tolerance', PO_PDOI_PARAMS.g_profile.po_price_update_tolerance);
866: PO_LOG.stmt (d_module, d_position, 'allow_tax_rate_override', PO_PDOI_PARAMS.g_profile.allow_tax_rate_override);
867: PO_LOG.stmt (d_module, d_position, 'allow_tax_code_override', PO_PDOI_PARAMS.g_profile.allow_tax_code_override);
868: END IF;
869:
862: PO_LOG.stmt (d_module, d_position, 'pdoi_archive_on_approval', PO_PDOI_PARAMS.g_profile.pdoi_archive_on_approval);
863: PO_LOG.stmt (d_module, d_position, 'override_funds', PO_PDOI_PARAMS.g_profile.override_funds);
864: PO_LOG.stmt (d_module, d_position, 'xbg', PO_PDOI_PARAMS.g_profile.xbg);
865: PO_LOG.stmt (d_module, d_position, 'po_price_update_tolerance', PO_PDOI_PARAMS.g_profile.po_price_update_tolerance);
866: PO_LOG.stmt (d_module, d_position, 'allow_tax_rate_override', PO_PDOI_PARAMS.g_profile.allow_tax_rate_override);
867: PO_LOG.stmt (d_module, d_position, 'allow_tax_code_override', PO_PDOI_PARAMS.g_profile.allow_tax_code_override);
868: END IF;
869:
870: IF (PO_LOG.d_proc) THEN
863: PO_LOG.stmt (d_module, d_position, 'override_funds', PO_PDOI_PARAMS.g_profile.override_funds);
864: PO_LOG.stmt (d_module, d_position, 'xbg', PO_PDOI_PARAMS.g_profile.xbg);
865: PO_LOG.stmt (d_module, d_position, 'po_price_update_tolerance', PO_PDOI_PARAMS.g_profile.po_price_update_tolerance);
866: PO_LOG.stmt (d_module, d_position, 'allow_tax_rate_override', PO_PDOI_PARAMS.g_profile.allow_tax_rate_override);
867: PO_LOG.stmt (d_module, d_position, 'allow_tax_code_override', PO_PDOI_PARAMS.g_profile.allow_tax_code_override);
868: END IF;
869:
870: IF (PO_LOG.d_proc) THEN
871: PO_LOG.proc_end (d_module);
866: PO_LOG.stmt (d_module, d_position, 'allow_tax_rate_override', PO_PDOI_PARAMS.g_profile.allow_tax_rate_override);
867: PO_LOG.stmt (d_module, d_position, 'allow_tax_code_override', PO_PDOI_PARAMS.g_profile.allow_tax_code_override);
868: END IF;
869:
870: IF (PO_LOG.d_proc) THEN
871: PO_LOG.proc_end (d_module);
872: END IF;
873:
874: EXCEPTION
867: PO_LOG.stmt (d_module, d_position, 'allow_tax_code_override', PO_PDOI_PARAMS.g_profile.allow_tax_code_override);
868: END IF;
869:
870: IF (PO_LOG.d_proc) THEN
871: PO_LOG.proc_end (d_module);
872: END IF;
873:
874: EXCEPTION
875: WHEN OTHERS THEN
900:
901: BEGIN
902: d_position := 0;
903:
904: IF (PO_LOG.d_proc) THEN
905: PO_LOG.proc_begin (d_module);
906: END IF;
907:
908: IF (PO_CORE_S.get_product_install_status('WIP') = 'I') THEN
901: BEGIN
902: d_position := 0;
903:
904: IF (PO_LOG.d_proc) THEN
905: PO_LOG.proc_begin (d_module);
906: END IF;
907:
908: IF (PO_CORE_S.get_product_install_status('WIP') = 'I') THEN
909: PO_PDOI_PARAMS.g_product.wip_installed := FND_API.G_TRUE;
940: ELSE
941: PO_PDOI_PARAMS.g_product.project_cwk_installed := FND_API.G_FALSE;
942: END IF;
943:
944: IF (PO_LOG.d_stmt) THEN
945: PO_LOG.stmt (d_module, d_position, 'wip_installed', PO_PDOI_PARAMS.g_product.wip_installed);
946: PO_LOG.stmt (d_module, d_position, 'inv_installed', PO_PDOI_PARAMS.g_product.inv_installed);
947: PO_LOG.stmt (d_module, d_position, 'project_11510_installed', PO_PDOI_PARAMS.g_product.project_11510_installed);
948: PO_LOG.stmt (d_module, d_position, 'pa_installed', PO_PDOI_PARAMS.g_product.pa_installed);
941: PO_PDOI_PARAMS.g_product.project_cwk_installed := FND_API.G_FALSE;
942: END IF;
943:
944: IF (PO_LOG.d_stmt) THEN
945: PO_LOG.stmt (d_module, d_position, 'wip_installed', PO_PDOI_PARAMS.g_product.wip_installed);
946: PO_LOG.stmt (d_module, d_position, 'inv_installed', PO_PDOI_PARAMS.g_product.inv_installed);
947: PO_LOG.stmt (d_module, d_position, 'project_11510_installed', PO_PDOI_PARAMS.g_product.project_11510_installed);
948: PO_LOG.stmt (d_module, d_position, 'pa_installed', PO_PDOI_PARAMS.g_product.pa_installed);
949: PO_LOG.stmt (d_module, d_position, 'gms_enabled', PO_PDOI_PARAMS.g_product.gms_enabled);
942: END IF;
943:
944: IF (PO_LOG.d_stmt) THEN
945: PO_LOG.stmt (d_module, d_position, 'wip_installed', PO_PDOI_PARAMS.g_product.wip_installed);
946: PO_LOG.stmt (d_module, d_position, 'inv_installed', PO_PDOI_PARAMS.g_product.inv_installed);
947: PO_LOG.stmt (d_module, d_position, 'project_11510_installed', PO_PDOI_PARAMS.g_product.project_11510_installed);
948: PO_LOG.stmt (d_module, d_position, 'pa_installed', PO_PDOI_PARAMS.g_product.pa_installed);
949: PO_LOG.stmt (d_module, d_position, 'gms_enabled', PO_PDOI_PARAMS.g_product.gms_enabled);
950: PO_LOG.stmt (d_module, d_position, 'project_cwk_installed', PO_PDOI_PARAMS.g_product.project_cwk_installed);
943:
944: IF (PO_LOG.d_stmt) THEN
945: PO_LOG.stmt (d_module, d_position, 'wip_installed', PO_PDOI_PARAMS.g_product.wip_installed);
946: PO_LOG.stmt (d_module, d_position, 'inv_installed', PO_PDOI_PARAMS.g_product.inv_installed);
947: PO_LOG.stmt (d_module, d_position, 'project_11510_installed', PO_PDOI_PARAMS.g_product.project_11510_installed);
948: PO_LOG.stmt (d_module, d_position, 'pa_installed', PO_PDOI_PARAMS.g_product.pa_installed);
949: PO_LOG.stmt (d_module, d_position, 'gms_enabled', PO_PDOI_PARAMS.g_product.gms_enabled);
950: PO_LOG.stmt (d_module, d_position, 'project_cwk_installed', PO_PDOI_PARAMS.g_product.project_cwk_installed);
951: END IF;
944: IF (PO_LOG.d_stmt) THEN
945: PO_LOG.stmt (d_module, d_position, 'wip_installed', PO_PDOI_PARAMS.g_product.wip_installed);
946: PO_LOG.stmt (d_module, d_position, 'inv_installed', PO_PDOI_PARAMS.g_product.inv_installed);
947: PO_LOG.stmt (d_module, d_position, 'project_11510_installed', PO_PDOI_PARAMS.g_product.project_11510_installed);
948: PO_LOG.stmt (d_module, d_position, 'pa_installed', PO_PDOI_PARAMS.g_product.pa_installed);
949: PO_LOG.stmt (d_module, d_position, 'gms_enabled', PO_PDOI_PARAMS.g_product.gms_enabled);
950: PO_LOG.stmt (d_module, d_position, 'project_cwk_installed', PO_PDOI_PARAMS.g_product.project_cwk_installed);
951: END IF;
952:
945: PO_LOG.stmt (d_module, d_position, 'wip_installed', PO_PDOI_PARAMS.g_product.wip_installed);
946: PO_LOG.stmt (d_module, d_position, 'inv_installed', PO_PDOI_PARAMS.g_product.inv_installed);
947: PO_LOG.stmt (d_module, d_position, 'project_11510_installed', PO_PDOI_PARAMS.g_product.project_11510_installed);
948: PO_LOG.stmt (d_module, d_position, 'pa_installed', PO_PDOI_PARAMS.g_product.pa_installed);
949: PO_LOG.stmt (d_module, d_position, 'gms_enabled', PO_PDOI_PARAMS.g_product.gms_enabled);
950: PO_LOG.stmt (d_module, d_position, 'project_cwk_installed', PO_PDOI_PARAMS.g_product.project_cwk_installed);
951: END IF;
952:
953: IF (PO_LOG.d_proc) THEN
946: PO_LOG.stmt (d_module, d_position, 'inv_installed', PO_PDOI_PARAMS.g_product.inv_installed);
947: PO_LOG.stmt (d_module, d_position, 'project_11510_installed', PO_PDOI_PARAMS.g_product.project_11510_installed);
948: PO_LOG.stmt (d_module, d_position, 'pa_installed', PO_PDOI_PARAMS.g_product.pa_installed);
949: PO_LOG.stmt (d_module, d_position, 'gms_enabled', PO_PDOI_PARAMS.g_product.gms_enabled);
950: PO_LOG.stmt (d_module, d_position, 'project_cwk_installed', PO_PDOI_PARAMS.g_product.project_cwk_installed);
951: END IF;
952:
953: IF (PO_LOG.d_proc) THEN
954: PO_LOG.proc_end (d_module);
949: PO_LOG.stmt (d_module, d_position, 'gms_enabled', PO_PDOI_PARAMS.g_product.gms_enabled);
950: PO_LOG.stmt (d_module, d_position, 'project_cwk_installed', PO_PDOI_PARAMS.g_product.project_cwk_installed);
951: END IF;
952:
953: IF (PO_LOG.d_proc) THEN
954: PO_LOG.proc_end (d_module);
955: END IF;
956: EXCEPTION
957: WHEN OTHERS THEN
950: PO_LOG.stmt (d_module, d_position, 'project_cwk_installed', PO_PDOI_PARAMS.g_product.project_cwk_installed);
951: END IF;
952:
953: IF (PO_LOG.d_proc) THEN
954: PO_LOG.proc_end (d_module);
955: END IF;
956: EXCEPTION
957: WHEN OTHERS THEN
958: PO_MESSAGE_S.add_exc_msg
1036:
1037: BEGIN
1038: d_position := 0;
1039:
1040: IF (PO_LOG.d_proc) THEN
1041: PO_LOG.proc_begin (d_module);
1042: END IF;
1043:
1044: PO_TIMING_UTL.start_time (PO_PDOI_CONSTANTS.g_T_GATHER_TBL_STAT);
1037: BEGIN
1038: d_position := 0;
1039:
1040: IF (PO_LOG.d_proc) THEN
1041: PO_LOG.proc_begin (d_module);
1042: END IF;
1043:
1044: PO_TIMING_UTL.start_time (PO_PDOI_CONSTANTS.g_T_GATHER_TBL_STAT);
1045:
1096: );
1097: ELSE
1098: d_position := 80;
1099:
1100: IF (PO_LOG.d_stmt) THEN
1101: PO_LOG.stmt(d_module, d_position, 'Cannot get appl info. ' ||
1102: 'No stat gathering');
1103: END IF;
1104: END IF;
1097: ELSE
1098: d_position := 80;
1099:
1100: IF (PO_LOG.d_stmt) THEN
1101: PO_LOG.stmt(d_module, d_position, 'Cannot get appl info. ' ||
1102: 'No stat gathering');
1103: END IF;
1104: END IF;
1105:
1104: END IF;
1105:
1106: PO_TIMING_UTL.stop_time (PO_PDOI_CONSTANTS.g_T_GATHER_TBL_STAT);
1107:
1108: IF (PO_LOG.d_proc) THEN
1109: PO_LOG.proc_end (d_module);
1110: END IF;
1111:
1112: EXCEPTION
1105:
1106: PO_TIMING_UTL.stop_time (PO_PDOI_CONSTANTS.g_T_GATHER_TBL_STAT);
1107:
1108: IF (PO_LOG.d_proc) THEN
1109: PO_LOG.proc_end (d_module);
1110: END IF;
1111:
1112: EXCEPTION
1113: WHEN OTHERS THEN
1139:
1140: BEGIN
1141: d_position := 0;
1142:
1143: IF (PO_LOG.d_proc) THEN
1144: PO_LOG.proc_begin (d_module);
1145: END IF;
1146:
1147: --SQL What: Mark the drafts that are processed by the current round as
1140: BEGIN
1141: d_position := 0;
1142:
1143: IF (PO_LOG.d_proc) THEN
1144: PO_LOG.proc_begin (d_module);
1145: END IF;
1146:
1147: --SQL What: Mark the drafts that are processed by the current round as
1148: -- PDOI ERROR
1159: WHERE PHI.processing_id IN (PO_PDOI_PARAMS.g_processing_id,
1160: -PO_PDOI_PARAMS.g_processing_id)
1161: AND PHI.processing_round_num=PO_PDOI_PARAMS.g_current_round_num);
1162:
1163: IF (PO_LOG.d_proc) THEN
1164: PO_LOG.proc_end (d_module);
1165: END IF;
1166:
1167: EXCEPTION
1160: -PO_PDOI_PARAMS.g_processing_id)
1161: AND PHI.processing_round_num=PO_PDOI_PARAMS.g_current_round_num);
1162:
1163: IF (PO_LOG.d_proc) THEN
1164: PO_LOG.proc_end (d_module);
1165: END IF;
1166:
1167: EXCEPTION
1168: WHEN OTHERS THEN
1195: BEGIN
1196:
1197: d_position := 0;
1198:
1199: IF (PO_LOG.d_proc) THEN
1200: PO_LOG.proc_begin (d_module);
1201: END IF;
1202:
1203: -- flush all remaining errors to interface errors table
1196:
1197: d_position := 0;
1198:
1199: IF (PO_LOG.d_proc) THEN
1200: PO_LOG.proc_begin (d_module);
1201: END IF;
1202:
1203: -- flush all remaining errors to interface errors table
1204: PO_INTERFACE_ERRORS_UTL.flush_errors_tbl;
1219: END IF;
1220: END LOOP;
1221:
1222: -- FOR i IN 1..l_timing_info_tbl.COUNT LOOP
1223: -- PO_LOG.stmt (d_module, d_position, 'Timing Stat: ', l_timing_info_tbl(i));
1224: -- END LOOP;
1225:
1226:
1227: IF (PO_LOG.d_proc) THEN
1223: -- PO_LOG.stmt (d_module, d_position, 'Timing Stat: ', l_timing_info_tbl(i));
1224: -- END LOOP;
1225:
1226:
1227: IF (PO_LOG.d_proc) THEN
1228: PO_LOG.proc_end (d_module);
1229: END IF;
1230:
1231: EXCEPTION
1224: -- END LOOP;
1225:
1226:
1227: IF (PO_LOG.d_proc) THEN
1228: PO_LOG.proc_end (d_module);
1229: END IF;
1230:
1231: EXCEPTION
1232: WHEN OTHERS THEN