eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_XPRT_OM_INT_PVT dependencies on FND_LOG

Line 17: G_STMT_LEVEL CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

13: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
14:
15: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKC_XPRT_OM_INT_PVT';
16: G_MODULE_NAME CONSTANT VARCHAR2(250) := 'OKC.PLSQL.'||G_PKG_NAME||'.';
17: G_STMT_LEVEL CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
18: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
19:
20: G_ITEM_CODE CONSTANT VARCHAR2(30) := 'OKC$S_ITEM';
21: G_ITEM_CATEGORY_CODE CONSTANT VARCHAR2(30) := 'OKC$S_ITEM_CATEGORY';

Line 377: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

373: l_bill_to_address_var c_get_address_info%ROWTYPE;
374:
375: BEGIN
376:
377: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
378: l_debug := true;
379: END IF;
380:
381: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 385: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

381: x_return_status := FND_API.G_RET_STS_SUCCESS;
382:
383: l_package_procedure := G_PKG_NAME || '.' || l_api_name;
384:
385: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
386: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'10: Entered ' || l_package_procedure);
387: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'20: p_doc_type: ' || p_doc_type);
388: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'30: p_doc_id: ' || p_doc_id);
389: END IF;

Line 386: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'10: Entered ' || l_package_procedure);

382:
383: l_package_procedure := G_PKG_NAME || '.' || l_api_name;
384:
385: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
386: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'10: Entered ' || l_package_procedure);
387: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'20: p_doc_type: ' || p_doc_type);
388: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'30: p_doc_id: ' || p_doc_id);
389: END IF;
390:

Line 387: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'20: p_doc_type: ' || p_doc_type);

383: l_package_procedure := G_PKG_NAME || '.' || l_api_name;
384:
385: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
386: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'10: Entered ' || l_package_procedure);
387: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'20: p_doc_type: ' || p_doc_type);
388: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'30: p_doc_id: ' || p_doc_id);
389: END IF;
390:
391: --

Line 388: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'30: p_doc_id: ' || p_doc_id);

384:
385: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
386: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'10: Entered ' || l_package_procedure);
387: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'20: p_doc_type: ' || p_doc_type);
388: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'30: p_doc_id: ' || p_doc_id);
389: END IF;
390:
391: --
392: -- Standard call to check for call compatibility.

Line 426: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

422: IF p_doc_type = G_BSA_DOC_TYPE THEN
423:
424: OPEN c_get_bsa_header_variables;
425: FETCH c_get_bsa_header_variables INTO l_bsa_header_variables;
426: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
427: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40: c_get_bsa_header_variables%ROWCOUNT: ' || c_get_bsa_header_variables%ROWCOUNT);
428: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: Values from l_bsa_header_variables: ');
429: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'55: ************************************');
430: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: Agreement_id = '||l_bsa_header_variables.agreement_id);

Line 427: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40: c_get_bsa_header_variables%ROWCOUNT: ' || c_get_bsa_header_variables%ROWCOUNT);

423:
424: OPEN c_get_bsa_header_variables;
425: FETCH c_get_bsa_header_variables INTO l_bsa_header_variables;
426: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
427: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40: c_get_bsa_header_variables%ROWCOUNT: ' || c_get_bsa_header_variables%ROWCOUNT);
428: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: Values from l_bsa_header_variables: ');
429: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'55: ************************************');
430: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: Agreement_id = '||l_bsa_header_variables.agreement_id);
431: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: price_agr_exist = '||l_bsa_header_variables.price_agr_exist );

Line 428: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: Values from l_bsa_header_variables: ');

424: OPEN c_get_bsa_header_variables;
425: FETCH c_get_bsa_header_variables INTO l_bsa_header_variables;
426: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
427: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40: c_get_bsa_header_variables%ROWCOUNT: ' || c_get_bsa_header_variables%ROWCOUNT);
428: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: Values from l_bsa_header_variables: ');
429: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'55: ************************************');
430: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: Agreement_id = '||l_bsa_header_variables.agreement_id);
431: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: price_agr_exist = '||l_bsa_header_variables.price_agr_exist );
432: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: sold_to_org_id = '||l_bsa_header_variables.sold_to_org_id );

Line 429: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'55: ************************************');

425: FETCH c_get_bsa_header_variables INTO l_bsa_header_variables;
426: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
427: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40: c_get_bsa_header_variables%ROWCOUNT: ' || c_get_bsa_header_variables%ROWCOUNT);
428: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: Values from l_bsa_header_variables: ');
429: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'55: ************************************');
430: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: Agreement_id = '||l_bsa_header_variables.agreement_id);
431: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: price_agr_exist = '||l_bsa_header_variables.price_agr_exist );
432: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: sold_to_org_id = '||l_bsa_header_variables.sold_to_org_id );
433: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: invoice_to_org_id = '||l_bsa_header_variables.invoice_to_org_id );

Line 430: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: Agreement_id = '||l_bsa_header_variables.agreement_id);

426: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
427: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40: c_get_bsa_header_variables%ROWCOUNT: ' || c_get_bsa_header_variables%ROWCOUNT);
428: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: Values from l_bsa_header_variables: ');
429: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'55: ************************************');
430: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: Agreement_id = '||l_bsa_header_variables.agreement_id);
431: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: price_agr_exist = '||l_bsa_header_variables.price_agr_exist );
432: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: sold_to_org_id = '||l_bsa_header_variables.sold_to_org_id );
433: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: invoice_to_org_id = '||l_bsa_header_variables.invoice_to_org_id );
434: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: ship_to_org_id = '||l_bsa_header_variables.ship_to_org_id );

Line 431: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: price_agr_exist = '||l_bsa_header_variables.price_agr_exist );

427: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40: c_get_bsa_header_variables%ROWCOUNT: ' || c_get_bsa_header_variables%ROWCOUNT);
428: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: Values from l_bsa_header_variables: ');
429: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'55: ************************************');
430: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: Agreement_id = '||l_bsa_header_variables.agreement_id);
431: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: price_agr_exist = '||l_bsa_header_variables.price_agr_exist );
432: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: sold_to_org_id = '||l_bsa_header_variables.sold_to_org_id );
433: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: invoice_to_org_id = '||l_bsa_header_variables.invoice_to_org_id );
434: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: ship_to_org_id = '||l_bsa_header_variables.ship_to_org_id );
435: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'105: deliver_to_org_id = '||l_bsa_header_variables.deliver_to_org_id );

Line 432: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: sold_to_org_id = '||l_bsa_header_variables.sold_to_org_id );

428: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: Values from l_bsa_header_variables: ');
429: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'55: ************************************');
430: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: Agreement_id = '||l_bsa_header_variables.agreement_id);
431: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: price_agr_exist = '||l_bsa_header_variables.price_agr_exist );
432: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: sold_to_org_id = '||l_bsa_header_variables.sold_to_org_id );
433: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: invoice_to_org_id = '||l_bsa_header_variables.invoice_to_org_id );
434: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: ship_to_org_id = '||l_bsa_header_variables.ship_to_org_id );
435: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'105: deliver_to_org_id = '||l_bsa_header_variables.deliver_to_org_id );
436: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: sold_to_site_use_id = '||l_bsa_header_variables.sold_to_site_use_id );

Line 433: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: invoice_to_org_id = '||l_bsa_header_variables.invoice_to_org_id );

429: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'55: ************************************');
430: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: Agreement_id = '||l_bsa_header_variables.agreement_id);
431: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: price_agr_exist = '||l_bsa_header_variables.price_agr_exist );
432: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: sold_to_org_id = '||l_bsa_header_variables.sold_to_org_id );
433: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: invoice_to_org_id = '||l_bsa_header_variables.invoice_to_org_id );
434: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: ship_to_org_id = '||l_bsa_header_variables.ship_to_org_id );
435: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'105: deliver_to_org_id = '||l_bsa_header_variables.deliver_to_org_id );
436: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: sold_to_site_use_id = '||l_bsa_header_variables.sold_to_site_use_id );
437: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: order_type_id = '||l_bsa_header_variables.order_type_id );

Line 434: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: ship_to_org_id = '||l_bsa_header_variables.ship_to_org_id );

430: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: Agreement_id = '||l_bsa_header_variables.agreement_id);
431: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: price_agr_exist = '||l_bsa_header_variables.price_agr_exist );
432: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: sold_to_org_id = '||l_bsa_header_variables.sold_to_org_id );
433: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: invoice_to_org_id = '||l_bsa_header_variables.invoice_to_org_id );
434: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: ship_to_org_id = '||l_bsa_header_variables.ship_to_org_id );
435: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'105: deliver_to_org_id = '||l_bsa_header_variables.deliver_to_org_id );
436: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: sold_to_site_use_id = '||l_bsa_header_variables.sold_to_site_use_id );
437: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: order_type_id = '||l_bsa_header_variables.order_type_id );
438: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: cust_po_num_exist = '||l_bsa_header_variables.cust_po_num_exist );

Line 435: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'105: deliver_to_org_id = '||l_bsa_header_variables.deliver_to_org_id );

431: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: price_agr_exist = '||l_bsa_header_variables.price_agr_exist );
432: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: sold_to_org_id = '||l_bsa_header_variables.sold_to_org_id );
433: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: invoice_to_org_id = '||l_bsa_header_variables.invoice_to_org_id );
434: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: ship_to_org_id = '||l_bsa_header_variables.ship_to_org_id );
435: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'105: deliver_to_org_id = '||l_bsa_header_variables.deliver_to_org_id );
436: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: sold_to_site_use_id = '||l_bsa_header_variables.sold_to_site_use_id );
437: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: order_type_id = '||l_bsa_header_variables.order_type_id );
438: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: cust_po_num_exist = '||l_bsa_header_variables.cust_po_num_exist );
439: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'140: transactional_curr_code = '||l_bsa_header_variables.transactional_curr_code );

Line 436: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: sold_to_site_use_id = '||l_bsa_header_variables.sold_to_site_use_id );

432: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: sold_to_org_id = '||l_bsa_header_variables.sold_to_org_id );
433: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: invoice_to_org_id = '||l_bsa_header_variables.invoice_to_org_id );
434: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: ship_to_org_id = '||l_bsa_header_variables.ship_to_org_id );
435: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'105: deliver_to_org_id = '||l_bsa_header_variables.deliver_to_org_id );
436: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: sold_to_site_use_id = '||l_bsa_header_variables.sold_to_site_use_id );
437: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: order_type_id = '||l_bsa_header_variables.order_type_id );
438: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: cust_po_num_exist = '||l_bsa_header_variables.cust_po_num_exist );
439: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'140: transactional_curr_code = '||l_bsa_header_variables.transactional_curr_code );
440: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: freight_terms_code = '||l_bsa_header_variables.freight_terms_code );

Line 437: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: order_type_id = '||l_bsa_header_variables.order_type_id );

433: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: invoice_to_org_id = '||l_bsa_header_variables.invoice_to_org_id );
434: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: ship_to_org_id = '||l_bsa_header_variables.ship_to_org_id );
435: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'105: deliver_to_org_id = '||l_bsa_header_variables.deliver_to_org_id );
436: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: sold_to_site_use_id = '||l_bsa_header_variables.sold_to_site_use_id );
437: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: order_type_id = '||l_bsa_header_variables.order_type_id );
438: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: cust_po_num_exist = '||l_bsa_header_variables.cust_po_num_exist );
439: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'140: transactional_curr_code = '||l_bsa_header_variables.transactional_curr_code );
440: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: freight_terms_code = '||l_bsa_header_variables.freight_terms_code );
441: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: shipping_method_code = '||l_bsa_header_variables.shipping_method_code );

Line 438: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: cust_po_num_exist = '||l_bsa_header_variables.cust_po_num_exist );

434: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: ship_to_org_id = '||l_bsa_header_variables.ship_to_org_id );
435: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'105: deliver_to_org_id = '||l_bsa_header_variables.deliver_to_org_id );
436: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: sold_to_site_use_id = '||l_bsa_header_variables.sold_to_site_use_id );
437: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: order_type_id = '||l_bsa_header_variables.order_type_id );
438: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: cust_po_num_exist = '||l_bsa_header_variables.cust_po_num_exist );
439: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'140: transactional_curr_code = '||l_bsa_header_variables.transactional_curr_code );
440: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: freight_terms_code = '||l_bsa_header_variables.freight_terms_code );
441: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: shipping_method_code = '||l_bsa_header_variables.shipping_method_code );
442: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: payment_term_id = '||l_bsa_header_variables.payment_term_id );

Line 439: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'140: transactional_curr_code = '||l_bsa_header_variables.transactional_curr_code );

435: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'105: deliver_to_org_id = '||l_bsa_header_variables.deliver_to_org_id );
436: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: sold_to_site_use_id = '||l_bsa_header_variables.sold_to_site_use_id );
437: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: order_type_id = '||l_bsa_header_variables.order_type_id );
438: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: cust_po_num_exist = '||l_bsa_header_variables.cust_po_num_exist );
439: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'140: transactional_curr_code = '||l_bsa_header_variables.transactional_curr_code );
440: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: freight_terms_code = '||l_bsa_header_variables.freight_terms_code );
441: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: shipping_method_code = '||l_bsa_header_variables.shipping_method_code );
442: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: payment_term_id = '||l_bsa_header_variables.payment_term_id );
443: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: invoicing_rule_id = '||l_bsa_header_variables.invoicing_rule_id );

Line 440: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: freight_terms_code = '||l_bsa_header_variables.freight_terms_code );

436: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: sold_to_site_use_id = '||l_bsa_header_variables.sold_to_site_use_id );
437: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: order_type_id = '||l_bsa_header_variables.order_type_id );
438: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: cust_po_num_exist = '||l_bsa_header_variables.cust_po_num_exist );
439: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'140: transactional_curr_code = '||l_bsa_header_variables.transactional_curr_code );
440: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: freight_terms_code = '||l_bsa_header_variables.freight_terms_code );
441: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: shipping_method_code = '||l_bsa_header_variables.shipping_method_code );
442: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: payment_term_id = '||l_bsa_header_variables.payment_term_id );
443: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: invoicing_rule_id = '||l_bsa_header_variables.invoicing_rule_id );
444: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: tax_exempt_flag = '||l_bsa_header_variables.tax_exempt_flag );

Line 441: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: shipping_method_code = '||l_bsa_header_variables.shipping_method_code );

437: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: order_type_id = '||l_bsa_header_variables.order_type_id );
438: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: cust_po_num_exist = '||l_bsa_header_variables.cust_po_num_exist );
439: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'140: transactional_curr_code = '||l_bsa_header_variables.transactional_curr_code );
440: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: freight_terms_code = '||l_bsa_header_variables.freight_terms_code );
441: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: shipping_method_code = '||l_bsa_header_variables.shipping_method_code );
442: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: payment_term_id = '||l_bsa_header_variables.payment_term_id );
443: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: invoicing_rule_id = '||l_bsa_header_variables.invoicing_rule_id );
444: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: tax_exempt_flag = '||l_bsa_header_variables.tax_exempt_flag );
445: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: price_list_id = '||l_bsa_header_variables.price_list_id );

Line 442: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: payment_term_id = '||l_bsa_header_variables.payment_term_id );

438: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: cust_po_num_exist = '||l_bsa_header_variables.cust_po_num_exist );
439: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'140: transactional_curr_code = '||l_bsa_header_variables.transactional_curr_code );
440: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: freight_terms_code = '||l_bsa_header_variables.freight_terms_code );
441: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: shipping_method_code = '||l_bsa_header_variables.shipping_method_code );
442: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: payment_term_id = '||l_bsa_header_variables.payment_term_id );
443: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: invoicing_rule_id = '||l_bsa_header_variables.invoicing_rule_id );
444: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: tax_exempt_flag = '||l_bsa_header_variables.tax_exempt_flag );
445: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: price_list_id = '||l_bsa_header_variables.price_list_id );
446: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: org_id = '||l_bsa_header_variables.org_id );

Line 443: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: invoicing_rule_id = '||l_bsa_header_variables.invoicing_rule_id );

439: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'140: transactional_curr_code = '||l_bsa_header_variables.transactional_curr_code );
440: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: freight_terms_code = '||l_bsa_header_variables.freight_terms_code );
441: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: shipping_method_code = '||l_bsa_header_variables.shipping_method_code );
442: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: payment_term_id = '||l_bsa_header_variables.payment_term_id );
443: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: invoicing_rule_id = '||l_bsa_header_variables.invoicing_rule_id );
444: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: tax_exempt_flag = '||l_bsa_header_variables.tax_exempt_flag );
445: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: price_list_id = '||l_bsa_header_variables.price_list_id );
446: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: org_id = '||l_bsa_header_variables.org_id );
447: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: blanket_min_amount = '||l_bsa_header_variables.blanket_min_amount );

Line 444: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: tax_exempt_flag = '||l_bsa_header_variables.tax_exempt_flag );

440: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: freight_terms_code = '||l_bsa_header_variables.freight_terms_code );
441: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: shipping_method_code = '||l_bsa_header_variables.shipping_method_code );
442: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: payment_term_id = '||l_bsa_header_variables.payment_term_id );
443: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: invoicing_rule_id = '||l_bsa_header_variables.invoicing_rule_id );
444: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: tax_exempt_flag = '||l_bsa_header_variables.tax_exempt_flag );
445: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: price_list_id = '||l_bsa_header_variables.price_list_id );
446: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: org_id = '||l_bsa_header_variables.org_id );
447: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: blanket_min_amount = '||l_bsa_header_variables.blanket_min_amount );
448: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: blanket_max_amount = '||l_bsa_header_variables.blanket_max_amount );

Line 445: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: price_list_id = '||l_bsa_header_variables.price_list_id );

441: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: shipping_method_code = '||l_bsa_header_variables.shipping_method_code );
442: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: payment_term_id = '||l_bsa_header_variables.payment_term_id );
443: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: invoicing_rule_id = '||l_bsa_header_variables.invoicing_rule_id );
444: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: tax_exempt_flag = '||l_bsa_header_variables.tax_exempt_flag );
445: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: price_list_id = '||l_bsa_header_variables.price_list_id );
446: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: org_id = '||l_bsa_header_variables.org_id );
447: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: blanket_min_amount = '||l_bsa_header_variables.blanket_min_amount );
448: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: blanket_max_amount = '||l_bsa_header_variables.blanket_max_amount );
449: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'240: order_number = '||l_bsa_header_variables.order_number );

Line 446: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: org_id = '||l_bsa_header_variables.org_id );

442: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: payment_term_id = '||l_bsa_header_variables.payment_term_id );
443: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: invoicing_rule_id = '||l_bsa_header_variables.invoicing_rule_id );
444: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: tax_exempt_flag = '||l_bsa_header_variables.tax_exempt_flag );
445: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: price_list_id = '||l_bsa_header_variables.price_list_id );
446: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: org_id = '||l_bsa_header_variables.org_id );
447: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: blanket_min_amount = '||l_bsa_header_variables.blanket_min_amount );
448: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: blanket_max_amount = '||l_bsa_header_variables.blanket_max_amount );
449: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'240: order_number = '||l_bsa_header_variables.order_number );
450: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'250: cust_po_number = '||l_bsa_header_variables.cust_po_number );

Line 447: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: blanket_min_amount = '||l_bsa_header_variables.blanket_min_amount );

443: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: invoicing_rule_id = '||l_bsa_header_variables.invoicing_rule_id );
444: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: tax_exempt_flag = '||l_bsa_header_variables.tax_exempt_flag );
445: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: price_list_id = '||l_bsa_header_variables.price_list_id );
446: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: org_id = '||l_bsa_header_variables.org_id );
447: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: blanket_min_amount = '||l_bsa_header_variables.blanket_min_amount );
448: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: blanket_max_amount = '||l_bsa_header_variables.blanket_max_amount );
449: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'240: order_number = '||l_bsa_header_variables.order_number );
450: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'250: cust_po_number = '||l_bsa_header_variables.cust_po_number );
451: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'260: version_number = '||l_bsa_header_variables.version_number );

Line 448: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: blanket_max_amount = '||l_bsa_header_variables.blanket_max_amount );

444: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: tax_exempt_flag = '||l_bsa_header_variables.tax_exempt_flag );
445: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: price_list_id = '||l_bsa_header_variables.price_list_id );
446: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: org_id = '||l_bsa_header_variables.org_id );
447: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: blanket_min_amount = '||l_bsa_header_variables.blanket_min_amount );
448: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: blanket_max_amount = '||l_bsa_header_variables.blanket_max_amount );
449: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'240: order_number = '||l_bsa_header_variables.order_number );
450: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'250: cust_po_number = '||l_bsa_header_variables.cust_po_number );
451: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'260: version_number = '||l_bsa_header_variables.version_number );
452: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'270: sold_to_contact_id = '||l_bsa_header_variables.sold_to_contact_id );

Line 449: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'240: order_number = '||l_bsa_header_variables.order_number );

445: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: price_list_id = '||l_bsa_header_variables.price_list_id );
446: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: org_id = '||l_bsa_header_variables.org_id );
447: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: blanket_min_amount = '||l_bsa_header_variables.blanket_min_amount );
448: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: blanket_max_amount = '||l_bsa_header_variables.blanket_max_amount );
449: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'240: order_number = '||l_bsa_header_variables.order_number );
450: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'250: cust_po_number = '||l_bsa_header_variables.cust_po_number );
451: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'260: version_number = '||l_bsa_header_variables.version_number );
452: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'270: sold_to_contact_id = '||l_bsa_header_variables.sold_to_contact_id );
453: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'280: salesrep_id = '||l_bsa_header_variables.salesrep_id );

Line 450: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'250: cust_po_number = '||l_bsa_header_variables.cust_po_number );

446: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: org_id = '||l_bsa_header_variables.org_id );
447: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: blanket_min_amount = '||l_bsa_header_variables.blanket_min_amount );
448: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: blanket_max_amount = '||l_bsa_header_variables.blanket_max_amount );
449: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'240: order_number = '||l_bsa_header_variables.order_number );
450: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'250: cust_po_number = '||l_bsa_header_variables.cust_po_number );
451: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'260: version_number = '||l_bsa_header_variables.version_number );
452: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'270: sold_to_contact_id = '||l_bsa_header_variables.sold_to_contact_id );
453: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'280: salesrep_id = '||l_bsa_header_variables.salesrep_id );
454: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'290: start_date_active = '||l_bsa_header_variables.start_date_active );

Line 451: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'260: version_number = '||l_bsa_header_variables.version_number );

447: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: blanket_min_amount = '||l_bsa_header_variables.blanket_min_amount );
448: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: blanket_max_amount = '||l_bsa_header_variables.blanket_max_amount );
449: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'240: order_number = '||l_bsa_header_variables.order_number );
450: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'250: cust_po_number = '||l_bsa_header_variables.cust_po_number );
451: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'260: version_number = '||l_bsa_header_variables.version_number );
452: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'270: sold_to_contact_id = '||l_bsa_header_variables.sold_to_contact_id );
453: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'280: salesrep_id = '||l_bsa_header_variables.salesrep_id );
454: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'290: start_date_active = '||l_bsa_header_variables.start_date_active );
455: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'300: end_date_active = '||l_bsa_header_variables.end_date_active );

Line 452: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'270: sold_to_contact_id = '||l_bsa_header_variables.sold_to_contact_id );

448: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: blanket_max_amount = '||l_bsa_header_variables.blanket_max_amount );
449: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'240: order_number = '||l_bsa_header_variables.order_number );
450: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'250: cust_po_number = '||l_bsa_header_variables.cust_po_number );
451: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'260: version_number = '||l_bsa_header_variables.version_number );
452: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'270: sold_to_contact_id = '||l_bsa_header_variables.sold_to_contact_id );
453: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'280: salesrep_id = '||l_bsa_header_variables.salesrep_id );
454: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'290: start_date_active = '||l_bsa_header_variables.start_date_active );
455: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'300: end_date_active = '||l_bsa_header_variables.end_date_active );
456: END IF;

Line 453: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'280: salesrep_id = '||l_bsa_header_variables.salesrep_id );

449: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'240: order_number = '||l_bsa_header_variables.order_number );
450: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'250: cust_po_number = '||l_bsa_header_variables.cust_po_number );
451: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'260: version_number = '||l_bsa_header_variables.version_number );
452: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'270: sold_to_contact_id = '||l_bsa_header_variables.sold_to_contact_id );
453: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'280: salesrep_id = '||l_bsa_header_variables.salesrep_id );
454: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'290: start_date_active = '||l_bsa_header_variables.start_date_active );
455: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'300: end_date_active = '||l_bsa_header_variables.end_date_active );
456: END IF;
457: CLOSE c_get_bsa_header_variables;

Line 454: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'290: start_date_active = '||l_bsa_header_variables.start_date_active );

450: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'250: cust_po_number = '||l_bsa_header_variables.cust_po_number );
451: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'260: version_number = '||l_bsa_header_variables.version_number );
452: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'270: sold_to_contact_id = '||l_bsa_header_variables.sold_to_contact_id );
453: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'280: salesrep_id = '||l_bsa_header_variables.salesrep_id );
454: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'290: start_date_active = '||l_bsa_header_variables.start_date_active );
455: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'300: end_date_active = '||l_bsa_header_variables.end_date_active );
456: END IF;
457: CLOSE c_get_bsa_header_variables;
458:

Line 455: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'300: end_date_active = '||l_bsa_header_variables.end_date_active );

451: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'260: version_number = '||l_bsa_header_variables.version_number );
452: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'270: sold_to_contact_id = '||l_bsa_header_variables.sold_to_contact_id );
453: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'280: salesrep_id = '||l_bsa_header_variables.salesrep_id );
454: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'290: start_date_active = '||l_bsa_header_variables.start_date_active );
455: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'300: end_date_active = '||l_bsa_header_variables.end_date_active );
456: END IF;
457: CLOSE c_get_bsa_header_variables;
458:
459: ELSIF p_doc_type = G_SO_DOC_TYPE THEN

Line 463: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

459: ELSIF p_doc_type = G_SO_DOC_TYPE THEN
460:
461: OPEN c_get_so_header_variables;
462: FETCH c_get_so_header_variables INTO l_so_header_variables;
463: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
464: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40: c_get_so_header_variables%ROWCOUNT: ' || c_get_so_header_variables%ROWCOUNT);
465: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: Values from l_so_header_variables: ');
466: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'55: ************************************');
467: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: blanket_number = '||l_so_header_variables.blanket_number );

Line 464: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40: c_get_so_header_variables%ROWCOUNT: ' || c_get_so_header_variables%ROWCOUNT);

460:
461: OPEN c_get_so_header_variables;
462: FETCH c_get_so_header_variables INTO l_so_header_variables;
463: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
464: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40: c_get_so_header_variables%ROWCOUNT: ' || c_get_so_header_variables%ROWCOUNT);
465: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: Values from l_so_header_variables: ');
466: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'55: ************************************');
467: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: blanket_number = '||l_so_header_variables.blanket_number );
468: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: blanket_number_exist = '||l_so_header_variables.blanket_number_exist );

Line 465: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: Values from l_so_header_variables: ');

461: OPEN c_get_so_header_variables;
462: FETCH c_get_so_header_variables INTO l_so_header_variables;
463: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
464: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40: c_get_so_header_variables%ROWCOUNT: ' || c_get_so_header_variables%ROWCOUNT);
465: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: Values from l_so_header_variables: ');
466: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'55: ************************************');
467: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: blanket_number = '||l_so_header_variables.blanket_number );
468: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: blanket_number_exist = '||l_so_header_variables.blanket_number_exist );
469: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: agreement_id = '||l_so_header_variables.agreement_id );

Line 466: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'55: ************************************');

462: FETCH c_get_so_header_variables INTO l_so_header_variables;
463: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
464: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40: c_get_so_header_variables%ROWCOUNT: ' || c_get_so_header_variables%ROWCOUNT);
465: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: Values from l_so_header_variables: ');
466: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'55: ************************************');
467: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: blanket_number = '||l_so_header_variables.blanket_number );
468: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: blanket_number_exist = '||l_so_header_variables.blanket_number_exist );
469: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: agreement_id = '||l_so_header_variables.agreement_id );
470: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: price_agr_exist = '||l_so_header_variables.price_agr_exist );

Line 467: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: blanket_number = '||l_so_header_variables.blanket_number );

463: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
464: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40: c_get_so_header_variables%ROWCOUNT: ' || c_get_so_header_variables%ROWCOUNT);
465: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: Values from l_so_header_variables: ');
466: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'55: ************************************');
467: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: blanket_number = '||l_so_header_variables.blanket_number );
468: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: blanket_number_exist = '||l_so_header_variables.blanket_number_exist );
469: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: agreement_id = '||l_so_header_variables.agreement_id );
470: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: price_agr_exist = '||l_so_header_variables.price_agr_exist );
471: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: sold_to_org_id = '||l_so_header_variables.sold_to_org_id );

Line 468: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: blanket_number_exist = '||l_so_header_variables.blanket_number_exist );

464: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40: c_get_so_header_variables%ROWCOUNT: ' || c_get_so_header_variables%ROWCOUNT);
465: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: Values from l_so_header_variables: ');
466: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'55: ************************************');
467: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: blanket_number = '||l_so_header_variables.blanket_number );
468: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: blanket_number_exist = '||l_so_header_variables.blanket_number_exist );
469: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: agreement_id = '||l_so_header_variables.agreement_id );
470: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: price_agr_exist = '||l_so_header_variables.price_agr_exist );
471: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: sold_to_org_id = '||l_so_header_variables.sold_to_org_id );
472: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: invoice_to_org_id = '||l_so_header_variables.invoice_to_org_id );

Line 469: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: agreement_id = '||l_so_header_variables.agreement_id );

465: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: Values from l_so_header_variables: ');
466: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'55: ************************************');
467: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: blanket_number = '||l_so_header_variables.blanket_number );
468: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: blanket_number_exist = '||l_so_header_variables.blanket_number_exist );
469: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: agreement_id = '||l_so_header_variables.agreement_id );
470: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: price_agr_exist = '||l_so_header_variables.price_agr_exist );
471: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: sold_to_org_id = '||l_so_header_variables.sold_to_org_id );
472: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: invoice_to_org_id = '||l_so_header_variables.invoice_to_org_id );
473: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: ship_to_org_id = '||l_so_header_variables.ship_to_org_id );

Line 470: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: price_agr_exist = '||l_so_header_variables.price_agr_exist );

466: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'55: ************************************');
467: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: blanket_number = '||l_so_header_variables.blanket_number );
468: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: blanket_number_exist = '||l_so_header_variables.blanket_number_exist );
469: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: agreement_id = '||l_so_header_variables.agreement_id );
470: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: price_agr_exist = '||l_so_header_variables.price_agr_exist );
471: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: sold_to_org_id = '||l_so_header_variables.sold_to_org_id );
472: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: invoice_to_org_id = '||l_so_header_variables.invoice_to_org_id );
473: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: ship_to_org_id = '||l_so_header_variables.ship_to_org_id );
474: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'125: deliver_to_org_id = '||l_so_header_variables.deliver_to_org_id );

Line 471: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: sold_to_org_id = '||l_so_header_variables.sold_to_org_id );

467: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: blanket_number = '||l_so_header_variables.blanket_number );
468: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: blanket_number_exist = '||l_so_header_variables.blanket_number_exist );
469: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: agreement_id = '||l_so_header_variables.agreement_id );
470: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: price_agr_exist = '||l_so_header_variables.price_agr_exist );
471: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: sold_to_org_id = '||l_so_header_variables.sold_to_org_id );
472: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: invoice_to_org_id = '||l_so_header_variables.invoice_to_org_id );
473: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: ship_to_org_id = '||l_so_header_variables.ship_to_org_id );
474: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'125: deliver_to_org_id = '||l_so_header_variables.deliver_to_org_id );
475: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: sold_to_site_use_id = '||l_so_header_variables.sold_to_site_use_id );

Line 472: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: invoice_to_org_id = '||l_so_header_variables.invoice_to_org_id );

468: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: blanket_number_exist = '||l_so_header_variables.blanket_number_exist );
469: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: agreement_id = '||l_so_header_variables.agreement_id );
470: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: price_agr_exist = '||l_so_header_variables.price_agr_exist );
471: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: sold_to_org_id = '||l_so_header_variables.sold_to_org_id );
472: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: invoice_to_org_id = '||l_so_header_variables.invoice_to_org_id );
473: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: ship_to_org_id = '||l_so_header_variables.ship_to_org_id );
474: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'125: deliver_to_org_id = '||l_so_header_variables.deliver_to_org_id );
475: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: sold_to_site_use_id = '||l_so_header_variables.sold_to_site_use_id );
476: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'140: cust_po_num_exist = '||l_so_header_variables.cust_po_num_exist );

Line 473: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: ship_to_org_id = '||l_so_header_variables.ship_to_org_id );

469: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: agreement_id = '||l_so_header_variables.agreement_id );
470: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: price_agr_exist = '||l_so_header_variables.price_agr_exist );
471: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: sold_to_org_id = '||l_so_header_variables.sold_to_org_id );
472: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: invoice_to_org_id = '||l_so_header_variables.invoice_to_org_id );
473: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: ship_to_org_id = '||l_so_header_variables.ship_to_org_id );
474: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'125: deliver_to_org_id = '||l_so_header_variables.deliver_to_org_id );
475: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: sold_to_site_use_id = '||l_so_header_variables.sold_to_site_use_id );
476: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'140: cust_po_num_exist = '||l_so_header_variables.cust_po_num_exist );
477: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: transactional_curr_code = '||l_so_header_variables.transactional_curr_code );

Line 474: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'125: deliver_to_org_id = '||l_so_header_variables.deliver_to_org_id );

470: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: price_agr_exist = '||l_so_header_variables.price_agr_exist );
471: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: sold_to_org_id = '||l_so_header_variables.sold_to_org_id );
472: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: invoice_to_org_id = '||l_so_header_variables.invoice_to_org_id );
473: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: ship_to_org_id = '||l_so_header_variables.ship_to_org_id );
474: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'125: deliver_to_org_id = '||l_so_header_variables.deliver_to_org_id );
475: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: sold_to_site_use_id = '||l_so_header_variables.sold_to_site_use_id );
476: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'140: cust_po_num_exist = '||l_so_header_variables.cust_po_num_exist );
477: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: transactional_curr_code = '||l_so_header_variables.transactional_curr_code );
478: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: freight_terms_code = '||l_so_header_variables.freight_terms_code );

Line 475: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: sold_to_site_use_id = '||l_so_header_variables.sold_to_site_use_id );

471: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: sold_to_org_id = '||l_so_header_variables.sold_to_org_id );
472: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: invoice_to_org_id = '||l_so_header_variables.invoice_to_org_id );
473: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: ship_to_org_id = '||l_so_header_variables.ship_to_org_id );
474: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'125: deliver_to_org_id = '||l_so_header_variables.deliver_to_org_id );
475: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: sold_to_site_use_id = '||l_so_header_variables.sold_to_site_use_id );
476: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'140: cust_po_num_exist = '||l_so_header_variables.cust_po_num_exist );
477: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: transactional_curr_code = '||l_so_header_variables.transactional_curr_code );
478: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: freight_terms_code = '||l_so_header_variables.freight_terms_code );
479: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: shipping_method_code = '||l_so_header_variables.shipping_method_code );

Line 476: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'140: cust_po_num_exist = '||l_so_header_variables.cust_po_num_exist );

472: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: invoice_to_org_id = '||l_so_header_variables.invoice_to_org_id );
473: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: ship_to_org_id = '||l_so_header_variables.ship_to_org_id );
474: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'125: deliver_to_org_id = '||l_so_header_variables.deliver_to_org_id );
475: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: sold_to_site_use_id = '||l_so_header_variables.sold_to_site_use_id );
476: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'140: cust_po_num_exist = '||l_so_header_variables.cust_po_num_exist );
477: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: transactional_curr_code = '||l_so_header_variables.transactional_curr_code );
478: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: freight_terms_code = '||l_so_header_variables.freight_terms_code );
479: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: shipping_method_code = '||l_so_header_variables.shipping_method_code );
480: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: payment_term_id = '||l_so_header_variables.payment_term_id );

Line 477: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: transactional_curr_code = '||l_so_header_variables.transactional_curr_code );

473: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: ship_to_org_id = '||l_so_header_variables.ship_to_org_id );
474: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'125: deliver_to_org_id = '||l_so_header_variables.deliver_to_org_id );
475: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: sold_to_site_use_id = '||l_so_header_variables.sold_to_site_use_id );
476: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'140: cust_po_num_exist = '||l_so_header_variables.cust_po_num_exist );
477: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: transactional_curr_code = '||l_so_header_variables.transactional_curr_code );
478: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: freight_terms_code = '||l_so_header_variables.freight_terms_code );
479: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: shipping_method_code = '||l_so_header_variables.shipping_method_code );
480: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: payment_term_id = '||l_so_header_variables.payment_term_id );
481: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: invoicing_rule_id = '||l_so_header_variables.invoicing_rule_id );

Line 478: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: freight_terms_code = '||l_so_header_variables.freight_terms_code );

474: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'125: deliver_to_org_id = '||l_so_header_variables.deliver_to_org_id );
475: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: sold_to_site_use_id = '||l_so_header_variables.sold_to_site_use_id );
476: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'140: cust_po_num_exist = '||l_so_header_variables.cust_po_num_exist );
477: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: transactional_curr_code = '||l_so_header_variables.transactional_curr_code );
478: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: freight_terms_code = '||l_so_header_variables.freight_terms_code );
479: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: shipping_method_code = '||l_so_header_variables.shipping_method_code );
480: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: payment_term_id = '||l_so_header_variables.payment_term_id );
481: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: invoicing_rule_id = '||l_so_header_variables.invoicing_rule_id );
482: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: org_id = '||l_so_header_variables.org_id );

Line 479: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: shipping_method_code = '||l_so_header_variables.shipping_method_code );

475: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: sold_to_site_use_id = '||l_so_header_variables.sold_to_site_use_id );
476: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'140: cust_po_num_exist = '||l_so_header_variables.cust_po_num_exist );
477: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: transactional_curr_code = '||l_so_header_variables.transactional_curr_code );
478: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: freight_terms_code = '||l_so_header_variables.freight_terms_code );
479: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: shipping_method_code = '||l_so_header_variables.shipping_method_code );
480: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: payment_term_id = '||l_so_header_variables.payment_term_id );
481: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: invoicing_rule_id = '||l_so_header_variables.invoicing_rule_id );
482: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: org_id = '||l_so_header_variables.org_id );
483: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: order_type_id = '||l_so_header_variables.order_type_id );

Line 480: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: payment_term_id = '||l_so_header_variables.payment_term_id );

476: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'140: cust_po_num_exist = '||l_so_header_variables.cust_po_num_exist );
477: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: transactional_curr_code = '||l_so_header_variables.transactional_curr_code );
478: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: freight_terms_code = '||l_so_header_variables.freight_terms_code );
479: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: shipping_method_code = '||l_so_header_variables.shipping_method_code );
480: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: payment_term_id = '||l_so_header_variables.payment_term_id );
481: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: invoicing_rule_id = '||l_so_header_variables.invoicing_rule_id );
482: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: org_id = '||l_so_header_variables.org_id );
483: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: order_type_id = '||l_so_header_variables.order_type_id );
484: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: fob_point_code = '||l_so_header_variables.fob_point_code );

Line 481: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: invoicing_rule_id = '||l_so_header_variables.invoicing_rule_id );

477: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: transactional_curr_code = '||l_so_header_variables.transactional_curr_code );
478: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: freight_terms_code = '||l_so_header_variables.freight_terms_code );
479: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: shipping_method_code = '||l_so_header_variables.shipping_method_code );
480: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: payment_term_id = '||l_so_header_variables.payment_term_id );
481: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: invoicing_rule_id = '||l_so_header_variables.invoicing_rule_id );
482: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: org_id = '||l_so_header_variables.org_id );
483: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: order_type_id = '||l_so_header_variables.order_type_id );
484: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: fob_point_code = '||l_so_header_variables.fob_point_code );
485: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: payment_type_code = '||l_so_header_variables.payment_type_code );

Line 482: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: org_id = '||l_so_header_variables.org_id );

478: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: freight_terms_code = '||l_so_header_variables.freight_terms_code );
479: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: shipping_method_code = '||l_so_header_variables.shipping_method_code );
480: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: payment_term_id = '||l_so_header_variables.payment_term_id );
481: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: invoicing_rule_id = '||l_so_header_variables.invoicing_rule_id );
482: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: org_id = '||l_so_header_variables.org_id );
483: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: order_type_id = '||l_so_header_variables.order_type_id );
484: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: fob_point_code = '||l_so_header_variables.fob_point_code );
485: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: payment_type_code = '||l_so_header_variables.payment_type_code );
486: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'240: end_customer_id = '||l_so_header_variables.end_customer_id );

Line 483: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: order_type_id = '||l_so_header_variables.order_type_id );

479: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: shipping_method_code = '||l_so_header_variables.shipping_method_code );
480: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: payment_term_id = '||l_so_header_variables.payment_term_id );
481: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: invoicing_rule_id = '||l_so_header_variables.invoicing_rule_id );
482: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: org_id = '||l_so_header_variables.org_id );
483: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: order_type_id = '||l_so_header_variables.order_type_id );
484: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: fob_point_code = '||l_so_header_variables.fob_point_code );
485: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: payment_type_code = '||l_so_header_variables.payment_type_code );
486: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'240: end_customer_id = '||l_so_header_variables.end_customer_id );
487: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'250: end_cust_exist = '||l_so_header_variables.end_cust_exist );

Line 484: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: fob_point_code = '||l_so_header_variables.fob_point_code );

480: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: payment_term_id = '||l_so_header_variables.payment_term_id );
481: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: invoicing_rule_id = '||l_so_header_variables.invoicing_rule_id );
482: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: org_id = '||l_so_header_variables.org_id );
483: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: order_type_id = '||l_so_header_variables.order_type_id );
484: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: fob_point_code = '||l_so_header_variables.fob_point_code );
485: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: payment_type_code = '||l_so_header_variables.payment_type_code );
486: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'240: end_customer_id = '||l_so_header_variables.end_customer_id );
487: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'250: end_cust_exist = '||l_so_header_variables.end_cust_exist );
488: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'260: price_list_id = '||l_so_header_variables.price_list_id );

Line 485: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: payment_type_code = '||l_so_header_variables.payment_type_code );

481: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: invoicing_rule_id = '||l_so_header_variables.invoicing_rule_id );
482: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: org_id = '||l_so_header_variables.org_id );
483: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: order_type_id = '||l_so_header_variables.order_type_id );
484: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: fob_point_code = '||l_so_header_variables.fob_point_code );
485: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: payment_type_code = '||l_so_header_variables.payment_type_code );
486: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'240: end_customer_id = '||l_so_header_variables.end_customer_id );
487: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'250: end_cust_exist = '||l_so_header_variables.end_cust_exist );
488: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'260: price_list_id = '||l_so_header_variables.price_list_id );
489: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'270: tax_exempt_flag = '||l_so_header_variables.tax_exempt_flag );

Line 486: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'240: end_customer_id = '||l_so_header_variables.end_customer_id );

482: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: org_id = '||l_so_header_variables.org_id );
483: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: order_type_id = '||l_so_header_variables.order_type_id );
484: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: fob_point_code = '||l_so_header_variables.fob_point_code );
485: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: payment_type_code = '||l_so_header_variables.payment_type_code );
486: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'240: end_customer_id = '||l_so_header_variables.end_customer_id );
487: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'250: end_cust_exist = '||l_so_header_variables.end_cust_exist );
488: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'260: price_list_id = '||l_so_header_variables.price_list_id );
489: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'270: tax_exempt_flag = '||l_so_header_variables.tax_exempt_flag );
490: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'280: sales_channel_code = '||l_so_header_variables.sales_channel_code );

Line 487: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'250: end_cust_exist = '||l_so_header_variables.end_cust_exist );

483: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: order_type_id = '||l_so_header_variables.order_type_id );
484: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: fob_point_code = '||l_so_header_variables.fob_point_code );
485: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: payment_type_code = '||l_so_header_variables.payment_type_code );
486: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'240: end_customer_id = '||l_so_header_variables.end_customer_id );
487: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'250: end_cust_exist = '||l_so_header_variables.end_cust_exist );
488: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'260: price_list_id = '||l_so_header_variables.price_list_id );
489: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'270: tax_exempt_flag = '||l_so_header_variables.tax_exempt_flag );
490: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'280: sales_channel_code = '||l_so_header_variables.sales_channel_code );
491: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'290: total = '||l_so_header_variables.total );

Line 488: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'260: price_list_id = '||l_so_header_variables.price_list_id );

484: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: fob_point_code = '||l_so_header_variables.fob_point_code );
485: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: payment_type_code = '||l_so_header_variables.payment_type_code );
486: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'240: end_customer_id = '||l_so_header_variables.end_customer_id );
487: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'250: end_cust_exist = '||l_so_header_variables.end_cust_exist );
488: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'260: price_list_id = '||l_so_header_variables.price_list_id );
489: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'270: tax_exempt_flag = '||l_so_header_variables.tax_exempt_flag );
490: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'280: sales_channel_code = '||l_so_header_variables.sales_channel_code );
491: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'290: total = '||l_so_header_variables.total );
492: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'300: total_adjusted_amount = '||l_so_header_variables.total_adjusted_amount );

Line 489: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'270: tax_exempt_flag = '||l_so_header_variables.tax_exempt_flag );

485: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: payment_type_code = '||l_so_header_variables.payment_type_code );
486: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'240: end_customer_id = '||l_so_header_variables.end_customer_id );
487: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'250: end_cust_exist = '||l_so_header_variables.end_cust_exist );
488: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'260: price_list_id = '||l_so_header_variables.price_list_id );
489: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'270: tax_exempt_flag = '||l_so_header_variables.tax_exempt_flag );
490: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'280: sales_channel_code = '||l_so_header_variables.sales_channel_code );
491: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'290: total = '||l_so_header_variables.total );
492: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'300: total_adjusted_amount = '||l_so_header_variables.total_adjusted_amount );
493: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'310: total_list_price = '||l_so_header_variables.total_list_price );

Line 490: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'280: sales_channel_code = '||l_so_header_variables.sales_channel_code );

486: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'240: end_customer_id = '||l_so_header_variables.end_customer_id );
487: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'250: end_cust_exist = '||l_so_header_variables.end_cust_exist );
488: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'260: price_list_id = '||l_so_header_variables.price_list_id );
489: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'270: tax_exempt_flag = '||l_so_header_variables.tax_exempt_flag );
490: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'280: sales_channel_code = '||l_so_header_variables.sales_channel_code );
491: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'290: total = '||l_so_header_variables.total );
492: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'300: total_adjusted_amount = '||l_so_header_variables.total_adjusted_amount );
493: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'310: total_list_price = '||l_so_header_variables.total_list_price );
494: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'320: blanket_header_id = '||l_so_header_variables.blanket_header_id );

Line 491: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'290: total = '||l_so_header_variables.total );

487: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'250: end_cust_exist = '||l_so_header_variables.end_cust_exist );
488: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'260: price_list_id = '||l_so_header_variables.price_list_id );
489: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'270: tax_exempt_flag = '||l_so_header_variables.tax_exempt_flag );
490: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'280: sales_channel_code = '||l_so_header_variables.sales_channel_code );
491: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'290: total = '||l_so_header_variables.total );
492: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'300: total_adjusted_amount = '||l_so_header_variables.total_adjusted_amount );
493: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'310: total_list_price = '||l_so_header_variables.total_list_price );
494: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'320: blanket_header_id = '||l_so_header_variables.blanket_header_id );
495: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'330: order_number = '||l_so_header_variables.order_number );

Line 492: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'300: total_adjusted_amount = '||l_so_header_variables.total_adjusted_amount );

488: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'260: price_list_id = '||l_so_header_variables.price_list_id );
489: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'270: tax_exempt_flag = '||l_so_header_variables.tax_exempt_flag );
490: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'280: sales_channel_code = '||l_so_header_variables.sales_channel_code );
491: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'290: total = '||l_so_header_variables.total );
492: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'300: total_adjusted_amount = '||l_so_header_variables.total_adjusted_amount );
493: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'310: total_list_price = '||l_so_header_variables.total_list_price );
494: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'320: blanket_header_id = '||l_so_header_variables.blanket_header_id );
495: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'330: order_number = '||l_so_header_variables.order_number );
496: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'340: quote_number = '||l_so_header_variables.quote_number );

Line 493: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'310: total_list_price = '||l_so_header_variables.total_list_price );

489: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'270: tax_exempt_flag = '||l_so_header_variables.tax_exempt_flag );
490: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'280: sales_channel_code = '||l_so_header_variables.sales_channel_code );
491: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'290: total = '||l_so_header_variables.total );
492: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'300: total_adjusted_amount = '||l_so_header_variables.total_adjusted_amount );
493: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'310: total_list_price = '||l_so_header_variables.total_list_price );
494: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'320: blanket_header_id = '||l_so_header_variables.blanket_header_id );
495: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'330: order_number = '||l_so_header_variables.order_number );
496: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'340: quote_number = '||l_so_header_variables.quote_number );
497: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'350: cust_po_number = '||l_so_header_variables.cust_po_number );

Line 494: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'320: blanket_header_id = '||l_so_header_variables.blanket_header_id );

490: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'280: sales_channel_code = '||l_so_header_variables.sales_channel_code );
491: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'290: total = '||l_so_header_variables.total );
492: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'300: total_adjusted_amount = '||l_so_header_variables.total_adjusted_amount );
493: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'310: total_list_price = '||l_so_header_variables.total_list_price );
494: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'320: blanket_header_id = '||l_so_header_variables.blanket_header_id );
495: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'330: order_number = '||l_so_header_variables.order_number );
496: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'340: quote_number = '||l_so_header_variables.quote_number );
497: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'350: cust_po_number = '||l_so_header_variables.cust_po_number );
498: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'360: version_number = '||l_so_header_variables.version_number );

Line 495: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'330: order_number = '||l_so_header_variables.order_number );

491: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'290: total = '||l_so_header_variables.total );
492: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'300: total_adjusted_amount = '||l_so_header_variables.total_adjusted_amount );
493: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'310: total_list_price = '||l_so_header_variables.total_list_price );
494: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'320: blanket_header_id = '||l_so_header_variables.blanket_header_id );
495: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'330: order_number = '||l_so_header_variables.order_number );
496: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'340: quote_number = '||l_so_header_variables.quote_number );
497: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'350: cust_po_number = '||l_so_header_variables.cust_po_number );
498: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'360: version_number = '||l_so_header_variables.version_number );
499: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'370: sold_to_contact_id = '||l_so_header_variables.sold_to_contact_id );

Line 496: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'340: quote_number = '||l_so_header_variables.quote_number );

492: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'300: total_adjusted_amount = '||l_so_header_variables.total_adjusted_amount );
493: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'310: total_list_price = '||l_so_header_variables.total_list_price );
494: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'320: blanket_header_id = '||l_so_header_variables.blanket_header_id );
495: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'330: order_number = '||l_so_header_variables.order_number );
496: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'340: quote_number = '||l_so_header_variables.quote_number );
497: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'350: cust_po_number = '||l_so_header_variables.cust_po_number );
498: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'360: version_number = '||l_so_header_variables.version_number );
499: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'370: sold_to_contact_id = '||l_so_header_variables.sold_to_contact_id );
500: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'380: salesrep_id = '||l_so_header_variables.salesrep_id );

Line 497: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'350: cust_po_number = '||l_so_header_variables.cust_po_number );

493: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'310: total_list_price = '||l_so_header_variables.total_list_price );
494: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'320: blanket_header_id = '||l_so_header_variables.blanket_header_id );
495: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'330: order_number = '||l_so_header_variables.order_number );
496: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'340: quote_number = '||l_so_header_variables.quote_number );
497: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'350: cust_po_number = '||l_so_header_variables.cust_po_number );
498: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'360: version_number = '||l_so_header_variables.version_number );
499: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'370: sold_to_contact_id = '||l_so_header_variables.sold_to_contact_id );
500: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'380: salesrep_id = '||l_so_header_variables.salesrep_id );
501: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'381: shipment_priority_code = '||l_so_header_variables.shipment_priority_code );

Line 498: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'360: version_number = '||l_so_header_variables.version_number );

494: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'320: blanket_header_id = '||l_so_header_variables.blanket_header_id );
495: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'330: order_number = '||l_so_header_variables.order_number );
496: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'340: quote_number = '||l_so_header_variables.quote_number );
497: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'350: cust_po_number = '||l_so_header_variables.cust_po_number );
498: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'360: version_number = '||l_so_header_variables.version_number );
499: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'370: sold_to_contact_id = '||l_so_header_variables.sold_to_contact_id );
500: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'380: salesrep_id = '||l_so_header_variables.salesrep_id );
501: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'381: shipment_priority_code = '||l_so_header_variables.shipment_priority_code );
502: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'382: minisite_id = '||l_so_header_variables.minisite_id );

Line 499: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'370: sold_to_contact_id = '||l_so_header_variables.sold_to_contact_id );

495: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'330: order_number = '||l_so_header_variables.order_number );
496: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'340: quote_number = '||l_so_header_variables.quote_number );
497: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'350: cust_po_number = '||l_so_header_variables.cust_po_number );
498: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'360: version_number = '||l_so_header_variables.version_number );
499: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'370: sold_to_contact_id = '||l_so_header_variables.sold_to_contact_id );
500: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'380: salesrep_id = '||l_so_header_variables.salesrep_id );
501: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'381: shipment_priority_code = '||l_so_header_variables.shipment_priority_code );
502: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'382: minisite_id = '||l_so_header_variables.minisite_id );
503: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'390: Price_list_name = '||l_so_header_variables.price_list_name );

Line 500: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'380: salesrep_id = '||l_so_header_variables.salesrep_id );

496: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'340: quote_number = '||l_so_header_variables.quote_number );
497: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'350: cust_po_number = '||l_so_header_variables.cust_po_number );
498: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'360: version_number = '||l_so_header_variables.version_number );
499: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'370: sold_to_contact_id = '||l_so_header_variables.sold_to_contact_id );
500: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'380: salesrep_id = '||l_so_header_variables.salesrep_id );
501: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'381: shipment_priority_code = '||l_so_header_variables.shipment_priority_code );
502: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'382: minisite_id = '||l_so_header_variables.minisite_id );
503: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'390: Price_list_name = '||l_so_header_variables.price_list_name );
504: END IF;

Line 501: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'381: shipment_priority_code = '||l_so_header_variables.shipment_priority_code );

497: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'350: cust_po_number = '||l_so_header_variables.cust_po_number );
498: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'360: version_number = '||l_so_header_variables.version_number );
499: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'370: sold_to_contact_id = '||l_so_header_variables.sold_to_contact_id );
500: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'380: salesrep_id = '||l_so_header_variables.salesrep_id );
501: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'381: shipment_priority_code = '||l_so_header_variables.shipment_priority_code );
502: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'382: minisite_id = '||l_so_header_variables.minisite_id );
503: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'390: Price_list_name = '||l_so_header_variables.price_list_name );
504: END IF;
505: CLOSE c_get_so_header_variables;

Line 502: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'382: minisite_id = '||l_so_header_variables.minisite_id );

498: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'360: version_number = '||l_so_header_variables.version_number );
499: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'370: sold_to_contact_id = '||l_so_header_variables.sold_to_contact_id );
500: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'380: salesrep_id = '||l_so_header_variables.salesrep_id );
501: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'381: shipment_priority_code = '||l_so_header_variables.shipment_priority_code );
502: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'382: minisite_id = '||l_so_header_variables.minisite_id );
503: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'390: Price_list_name = '||l_so_header_variables.price_list_name );
504: END IF;
505: CLOSE c_get_so_header_variables;
506:

Line 503: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'390: Price_list_name = '||l_so_header_variables.price_list_name );

499: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'370: sold_to_contact_id = '||l_so_header_variables.sold_to_contact_id );
500: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'380: salesrep_id = '||l_so_header_variables.salesrep_id );
501: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'381: shipment_priority_code = '||l_so_header_variables.shipment_priority_code );
502: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'382: minisite_id = '||l_so_header_variables.minisite_id );
503: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'390: Price_list_name = '||l_so_header_variables.price_list_name );
504: END IF;
505: CLOSE c_get_so_header_variables;
506:
507: END IF;

Line 521: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

517:
518: IF l_sold_to_org_id IS NOT NULL THEN
519: OPEN c_get_cust_info_var(l_sold_to_org_id);
520: FETCH c_get_cust_info_var INTO l_cust_info_variables;
521: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
522: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'330: c_get_cust_info_var%ROWCOUNT: ' || c_get_cust_info_var%ROWCOUNT);
523: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'340: Values from l_cust_info_variables: ');
524: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'350: sold_to_org_id used = '||l_sold_to_org_id );
525: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'360: category_code = '||l_cust_info_variables.category_code );

Line 522: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'330: c_get_cust_info_var%ROWCOUNT: ' || c_get_cust_info_var%ROWCOUNT);

518: IF l_sold_to_org_id IS NOT NULL THEN
519: OPEN c_get_cust_info_var(l_sold_to_org_id);
520: FETCH c_get_cust_info_var INTO l_cust_info_variables;
521: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
522: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'330: c_get_cust_info_var%ROWCOUNT: ' || c_get_cust_info_var%ROWCOUNT);
523: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'340: Values from l_cust_info_variables: ');
524: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'350: sold_to_org_id used = '||l_sold_to_org_id );
525: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'360: category_code = '||l_cust_info_variables.category_code );
526: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'370: customer_class_code = '||l_cust_info_variables.customer_class_code );

Line 523: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'340: Values from l_cust_info_variables: ');

519: OPEN c_get_cust_info_var(l_sold_to_org_id);
520: FETCH c_get_cust_info_var INTO l_cust_info_variables;
521: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
522: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'330: c_get_cust_info_var%ROWCOUNT: ' || c_get_cust_info_var%ROWCOUNT);
523: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'340: Values from l_cust_info_variables: ');
524: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'350: sold_to_org_id used = '||l_sold_to_org_id );
525: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'360: category_code = '||l_cust_info_variables.category_code );
526: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'370: customer_class_code = '||l_cust_info_variables.customer_class_code );
527: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'380: profile_class_id = '||l_cust_info_variables.profile_class_id );

Line 524: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'350: sold_to_org_id used = '||l_sold_to_org_id );

520: FETCH c_get_cust_info_var INTO l_cust_info_variables;
521: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
522: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'330: c_get_cust_info_var%ROWCOUNT: ' || c_get_cust_info_var%ROWCOUNT);
523: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'340: Values from l_cust_info_variables: ');
524: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'350: sold_to_org_id used = '||l_sold_to_org_id );
525: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'360: category_code = '||l_cust_info_variables.category_code );
526: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'370: customer_class_code = '||l_cust_info_variables.customer_class_code );
527: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'380: profile_class_id = '||l_cust_info_variables.profile_class_id );
528: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'390: credit_rating = '||l_cust_info_variables.credit_rating );

Line 525: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'360: category_code = '||l_cust_info_variables.category_code );

521: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
522: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'330: c_get_cust_info_var%ROWCOUNT: ' || c_get_cust_info_var%ROWCOUNT);
523: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'340: Values from l_cust_info_variables: ');
524: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'350: sold_to_org_id used = '||l_sold_to_org_id );
525: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'360: category_code = '||l_cust_info_variables.category_code );
526: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'370: customer_class_code = '||l_cust_info_variables.customer_class_code );
527: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'380: profile_class_id = '||l_cust_info_variables.profile_class_id );
528: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'390: credit_rating = '||l_cust_info_variables.credit_rating );
529: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'400: credit_classification = '||l_cust_info_variables.credit_classification );

Line 526: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'370: customer_class_code = '||l_cust_info_variables.customer_class_code );

522: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'330: c_get_cust_info_var%ROWCOUNT: ' || c_get_cust_info_var%ROWCOUNT);
523: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'340: Values from l_cust_info_variables: ');
524: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'350: sold_to_org_id used = '||l_sold_to_org_id );
525: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'360: category_code = '||l_cust_info_variables.category_code );
526: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'370: customer_class_code = '||l_cust_info_variables.customer_class_code );
527: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'380: profile_class_id = '||l_cust_info_variables.profile_class_id );
528: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'390: credit_rating = '||l_cust_info_variables.credit_rating );
529: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'400: credit_classification = '||l_cust_info_variables.credit_classification );
530: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'410: risk_code = '||l_cust_info_variables.risk_code );

Line 527: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'380: profile_class_id = '||l_cust_info_variables.profile_class_id );

523: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'340: Values from l_cust_info_variables: ');
524: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'350: sold_to_org_id used = '||l_sold_to_org_id );
525: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'360: category_code = '||l_cust_info_variables.category_code );
526: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'370: customer_class_code = '||l_cust_info_variables.customer_class_code );
527: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'380: profile_class_id = '||l_cust_info_variables.profile_class_id );
528: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'390: credit_rating = '||l_cust_info_variables.credit_rating );
529: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'400: credit_classification = '||l_cust_info_variables.credit_classification );
530: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'410: risk_code = '||l_cust_info_variables.risk_code );
531: END IF;

Line 528: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'390: credit_rating = '||l_cust_info_variables.credit_rating );

524: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'350: sold_to_org_id used = '||l_sold_to_org_id );
525: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'360: category_code = '||l_cust_info_variables.category_code );
526: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'370: customer_class_code = '||l_cust_info_variables.customer_class_code );
527: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'380: profile_class_id = '||l_cust_info_variables.profile_class_id );
528: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'390: credit_rating = '||l_cust_info_variables.credit_rating );
529: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'400: credit_classification = '||l_cust_info_variables.credit_classification );
530: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'410: risk_code = '||l_cust_info_variables.risk_code );
531: END IF;
532: CLOSE c_get_cust_info_var;

Line 529: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'400: credit_classification = '||l_cust_info_variables.credit_classification );

525: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'360: category_code = '||l_cust_info_variables.category_code );
526: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'370: customer_class_code = '||l_cust_info_variables.customer_class_code );
527: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'380: profile_class_id = '||l_cust_info_variables.profile_class_id );
528: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'390: credit_rating = '||l_cust_info_variables.credit_rating );
529: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'400: credit_classification = '||l_cust_info_variables.credit_classification );
530: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'410: risk_code = '||l_cust_info_variables.risk_code );
531: END IF;
532: CLOSE c_get_cust_info_var;
533: END IF;

Line 530: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'410: risk_code = '||l_cust_info_variables.risk_code );

526: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'370: customer_class_code = '||l_cust_info_variables.customer_class_code );
527: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'380: profile_class_id = '||l_cust_info_variables.profile_class_id );
528: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'390: credit_rating = '||l_cust_info_variables.credit_rating );
529: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'400: credit_classification = '||l_cust_info_variables.credit_classification );
530: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'410: risk_code = '||l_cust_info_variables.risk_code );
531: END IF;
532: CLOSE c_get_cust_info_var;
533: END IF;
534:

Line 570: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

566: IF l_invoice_to_site_use_id IS NOT NULL THEN
567: OPEN c_get_address_info(l_invoice_to_site_use_id);
568: FETCH c_get_address_info INTO l_bill_to_address_var;
569: CLOSE c_get_address_info;
570: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
571: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'411: Bill to Location = '|| l_bill_to_address_var.location );
572: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'412: Bill to Address1 = '|| l_bill_to_address_var.address1);
573: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'413: Bill to Address2 = '|| l_bill_to_address_var.address2);
574: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'414: Bill to Address3= '|| l_bill_to_address_var.address3);

Line 571: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'411: Bill to Location = '|| l_bill_to_address_var.location );

567: OPEN c_get_address_info(l_invoice_to_site_use_id);
568: FETCH c_get_address_info INTO l_bill_to_address_var;
569: CLOSE c_get_address_info;
570: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
571: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'411: Bill to Location = '|| l_bill_to_address_var.location );
572: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'412: Bill to Address1 = '|| l_bill_to_address_var.address1);
573: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'413: Bill to Address2 = '|| l_bill_to_address_var.address2);
574: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'414: Bill to Address3= '|| l_bill_to_address_var.address3);
575: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'415: Bill to Address4 ='|| l_bill_to_address_var.address4);

Line 572: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'412: Bill to Address1 = '|| l_bill_to_address_var.address1);

568: FETCH c_get_address_info INTO l_bill_to_address_var;
569: CLOSE c_get_address_info;
570: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
571: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'411: Bill to Location = '|| l_bill_to_address_var.location );
572: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'412: Bill to Address1 = '|| l_bill_to_address_var.address1);
573: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'413: Bill to Address2 = '|| l_bill_to_address_var.address2);
574: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'414: Bill to Address3= '|| l_bill_to_address_var.address3);
575: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'415: Bill to Address4 ='|| l_bill_to_address_var.address4);
576: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'416: Bill to City = '|| l_bill_to_address_var.city );

Line 573: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'413: Bill to Address2 = '|| l_bill_to_address_var.address2);

569: CLOSE c_get_address_info;
570: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
571: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'411: Bill to Location = '|| l_bill_to_address_var.location );
572: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'412: Bill to Address1 = '|| l_bill_to_address_var.address1);
573: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'413: Bill to Address2 = '|| l_bill_to_address_var.address2);
574: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'414: Bill to Address3= '|| l_bill_to_address_var.address3);
575: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'415: Bill to Address4 ='|| l_bill_to_address_var.address4);
576: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'416: Bill to City = '|| l_bill_to_address_var.city );
577: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'417: Bill to = County'|| l_bill_to_address_var.county);

Line 574: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'414: Bill to Address3= '|| l_bill_to_address_var.address3);

570: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
571: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'411: Bill to Location = '|| l_bill_to_address_var.location );
572: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'412: Bill to Address1 = '|| l_bill_to_address_var.address1);
573: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'413: Bill to Address2 = '|| l_bill_to_address_var.address2);
574: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'414: Bill to Address3= '|| l_bill_to_address_var.address3);
575: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'415: Bill to Address4 ='|| l_bill_to_address_var.address4);
576: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'416: Bill to City = '|| l_bill_to_address_var.city );
577: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'417: Bill to = County'|| l_bill_to_address_var.county);
578: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'418: Bill to = State'|| l_bill_to_address_var.state);

Line 575: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'415: Bill to Address4 ='|| l_bill_to_address_var.address4);

571: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'411: Bill to Location = '|| l_bill_to_address_var.location );
572: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'412: Bill to Address1 = '|| l_bill_to_address_var.address1);
573: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'413: Bill to Address2 = '|| l_bill_to_address_var.address2);
574: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'414: Bill to Address3= '|| l_bill_to_address_var.address3);
575: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'415: Bill to Address4 ='|| l_bill_to_address_var.address4);
576: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'416: Bill to City = '|| l_bill_to_address_var.city );
577: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'417: Bill to = County'|| l_bill_to_address_var.county);
578: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'418: Bill to = State'|| l_bill_to_address_var.state);
579: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'419: Bill to = Province'|| l_bill_to_address_var.province);

Line 576: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'416: Bill to City = '|| l_bill_to_address_var.city );

572: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'412: Bill to Address1 = '|| l_bill_to_address_var.address1);
573: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'413: Bill to Address2 = '|| l_bill_to_address_var.address2);
574: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'414: Bill to Address3= '|| l_bill_to_address_var.address3);
575: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'415: Bill to Address4 ='|| l_bill_to_address_var.address4);
576: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'416: Bill to City = '|| l_bill_to_address_var.city );
577: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'417: Bill to = County'|| l_bill_to_address_var.county);
578: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'418: Bill to = State'|| l_bill_to_address_var.state);
579: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'419: Bill to = Province'|| l_bill_to_address_var.province);
580: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'420: Bill to = Postal Code'|| l_bill_to_address_var.postal_code );

Line 577: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'417: Bill to = County'|| l_bill_to_address_var.county);

573: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'413: Bill to Address2 = '|| l_bill_to_address_var.address2);
574: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'414: Bill to Address3= '|| l_bill_to_address_var.address3);
575: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'415: Bill to Address4 ='|| l_bill_to_address_var.address4);
576: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'416: Bill to City = '|| l_bill_to_address_var.city );
577: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'417: Bill to = County'|| l_bill_to_address_var.county);
578: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'418: Bill to = State'|| l_bill_to_address_var.state);
579: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'419: Bill to = Province'|| l_bill_to_address_var.province);
580: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'420: Bill to = Postal Code'|| l_bill_to_address_var.postal_code );
581: END IF;

Line 578: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'418: Bill to = State'|| l_bill_to_address_var.state);

574: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'414: Bill to Address3= '|| l_bill_to_address_var.address3);
575: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'415: Bill to Address4 ='|| l_bill_to_address_var.address4);
576: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'416: Bill to City = '|| l_bill_to_address_var.city );
577: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'417: Bill to = County'|| l_bill_to_address_var.county);
578: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'418: Bill to = State'|| l_bill_to_address_var.state);
579: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'419: Bill to = Province'|| l_bill_to_address_var.province);
580: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'420: Bill to = Postal Code'|| l_bill_to_address_var.postal_code );
581: END IF;
582: END IF;

Line 579: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'419: Bill to = Province'|| l_bill_to_address_var.province);

575: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'415: Bill to Address4 ='|| l_bill_to_address_var.address4);
576: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'416: Bill to City = '|| l_bill_to_address_var.city );
577: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'417: Bill to = County'|| l_bill_to_address_var.county);
578: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'418: Bill to = State'|| l_bill_to_address_var.state);
579: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'419: Bill to = Province'|| l_bill_to_address_var.province);
580: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'420: Bill to = Postal Code'|| l_bill_to_address_var.postal_code );
581: END IF;
582: END IF;
583:

Line 580: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'420: Bill to = Postal Code'|| l_bill_to_address_var.postal_code );

576: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'416: Bill to City = '|| l_bill_to_address_var.city );
577: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'417: Bill to = County'|| l_bill_to_address_var.county);
578: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'418: Bill to = State'|| l_bill_to_address_var.state);
579: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'419: Bill to = Province'|| l_bill_to_address_var.province);
580: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'420: Bill to = Postal Code'|| l_bill_to_address_var.postal_code );
581: END IF;
582: END IF;
583:
584: IF l_deliver_to_site_use_id IS NOT NULL THEN

Line 588: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

584: IF l_deliver_to_site_use_id IS NOT NULL THEN
585: OPEN c_get_address_info(l_invoice_to_site_use_id);
586: FETCH c_get_address_info INTO l_deliver_to_address_var;
587: CLOSE c_get_address_info;
588: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
589: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'421: Deliver to Location = '|| l_deliver_to_address_var.location );
590: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'422: Deliver to Address1 = '|| l_deliver_to_address_var.address1);
591: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'423: Deliver to Address2 = '|| l_deliver_to_address_var.address2);
592: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'424: Deliver to Address3= '|| l_deliver_to_address_var.address3);

Line 589: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'421: Deliver to Location = '|| l_deliver_to_address_var.location );

585: OPEN c_get_address_info(l_invoice_to_site_use_id);
586: FETCH c_get_address_info INTO l_deliver_to_address_var;
587: CLOSE c_get_address_info;
588: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
589: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'421: Deliver to Location = '|| l_deliver_to_address_var.location );
590: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'422: Deliver to Address1 = '|| l_deliver_to_address_var.address1);
591: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'423: Deliver to Address2 = '|| l_deliver_to_address_var.address2);
592: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'424: Deliver to Address3= '|| l_deliver_to_address_var.address3);
593: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'425: Deliver to Address4 ='|| l_deliver_to_address_var.address4);

Line 590: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'422: Deliver to Address1 = '|| l_deliver_to_address_var.address1);

586: FETCH c_get_address_info INTO l_deliver_to_address_var;
587: CLOSE c_get_address_info;
588: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
589: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'421: Deliver to Location = '|| l_deliver_to_address_var.location );
590: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'422: Deliver to Address1 = '|| l_deliver_to_address_var.address1);
591: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'423: Deliver to Address2 = '|| l_deliver_to_address_var.address2);
592: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'424: Deliver to Address3= '|| l_deliver_to_address_var.address3);
593: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'425: Deliver to Address4 ='|| l_deliver_to_address_var.address4);
594: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'426: Deliver to City = '|| l_deliver_to_address_var.city );

Line 591: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'423: Deliver to Address2 = '|| l_deliver_to_address_var.address2);

587: CLOSE c_get_address_info;
588: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
589: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'421: Deliver to Location = '|| l_deliver_to_address_var.location );
590: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'422: Deliver to Address1 = '|| l_deliver_to_address_var.address1);
591: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'423: Deliver to Address2 = '|| l_deliver_to_address_var.address2);
592: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'424: Deliver to Address3= '|| l_deliver_to_address_var.address3);
593: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'425: Deliver to Address4 ='|| l_deliver_to_address_var.address4);
594: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'426: Deliver to City = '|| l_deliver_to_address_var.city );
595: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'427: Deliver to = County'|| l_deliver_to_address_var.county);

Line 592: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'424: Deliver to Address3= '|| l_deliver_to_address_var.address3);

588: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
589: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'421: Deliver to Location = '|| l_deliver_to_address_var.location );
590: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'422: Deliver to Address1 = '|| l_deliver_to_address_var.address1);
591: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'423: Deliver to Address2 = '|| l_deliver_to_address_var.address2);
592: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'424: Deliver to Address3= '|| l_deliver_to_address_var.address3);
593: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'425: Deliver to Address4 ='|| l_deliver_to_address_var.address4);
594: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'426: Deliver to City = '|| l_deliver_to_address_var.city );
595: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'427: Deliver to = County'|| l_deliver_to_address_var.county);
596: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'428: Deliver to = State'|| l_deliver_to_address_var.state);

Line 593: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'425: Deliver to Address4 ='|| l_deliver_to_address_var.address4);

589: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'421: Deliver to Location = '|| l_deliver_to_address_var.location );
590: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'422: Deliver to Address1 = '|| l_deliver_to_address_var.address1);
591: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'423: Deliver to Address2 = '|| l_deliver_to_address_var.address2);
592: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'424: Deliver to Address3= '|| l_deliver_to_address_var.address3);
593: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'425: Deliver to Address4 ='|| l_deliver_to_address_var.address4);
594: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'426: Deliver to City = '|| l_deliver_to_address_var.city );
595: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'427: Deliver to = County'|| l_deliver_to_address_var.county);
596: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'428: Deliver to = State'|| l_deliver_to_address_var.state);
597: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'429: Deliver to = Province'|| l_deliver_to_address_var.province);

Line 594: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'426: Deliver to City = '|| l_deliver_to_address_var.city );

590: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'422: Deliver to Address1 = '|| l_deliver_to_address_var.address1);
591: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'423: Deliver to Address2 = '|| l_deliver_to_address_var.address2);
592: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'424: Deliver to Address3= '|| l_deliver_to_address_var.address3);
593: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'425: Deliver to Address4 ='|| l_deliver_to_address_var.address4);
594: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'426: Deliver to City = '|| l_deliver_to_address_var.city );
595: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'427: Deliver to = County'|| l_deliver_to_address_var.county);
596: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'428: Deliver to = State'|| l_deliver_to_address_var.state);
597: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'429: Deliver to = Province'|| l_deliver_to_address_var.province);
598: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'431: Deliver to = Postal Code'|| l_deliver_to_address_var.postal_code );

Line 595: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'427: Deliver to = County'|| l_deliver_to_address_var.county);

591: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'423: Deliver to Address2 = '|| l_deliver_to_address_var.address2);
592: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'424: Deliver to Address3= '|| l_deliver_to_address_var.address3);
593: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'425: Deliver to Address4 ='|| l_deliver_to_address_var.address4);
594: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'426: Deliver to City = '|| l_deliver_to_address_var.city );
595: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'427: Deliver to = County'|| l_deliver_to_address_var.county);
596: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'428: Deliver to = State'|| l_deliver_to_address_var.state);
597: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'429: Deliver to = Province'|| l_deliver_to_address_var.province);
598: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'431: Deliver to = Postal Code'|| l_deliver_to_address_var.postal_code );
599: END IF;

Line 596: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'428: Deliver to = State'|| l_deliver_to_address_var.state);

592: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'424: Deliver to Address3= '|| l_deliver_to_address_var.address3);
593: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'425: Deliver to Address4 ='|| l_deliver_to_address_var.address4);
594: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'426: Deliver to City = '|| l_deliver_to_address_var.city );
595: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'427: Deliver to = County'|| l_deliver_to_address_var.county);
596: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'428: Deliver to = State'|| l_deliver_to_address_var.state);
597: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'429: Deliver to = Province'|| l_deliver_to_address_var.province);
598: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'431: Deliver to = Postal Code'|| l_deliver_to_address_var.postal_code );
599: END IF;
600: END IF;

Line 597: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'429: Deliver to = Province'|| l_deliver_to_address_var.province);

593: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'425: Deliver to Address4 ='|| l_deliver_to_address_var.address4);
594: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'426: Deliver to City = '|| l_deliver_to_address_var.city );
595: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'427: Deliver to = County'|| l_deliver_to_address_var.county);
596: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'428: Deliver to = State'|| l_deliver_to_address_var.state);
597: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'429: Deliver to = Province'|| l_deliver_to_address_var.province);
598: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'431: Deliver to = Postal Code'|| l_deliver_to_address_var.postal_code );
599: END IF;
600: END IF;
601:

Line 598: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'431: Deliver to = Postal Code'|| l_deliver_to_address_var.postal_code );

594: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'426: Deliver to City = '|| l_deliver_to_address_var.city );
595: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'427: Deliver to = County'|| l_deliver_to_address_var.county);
596: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'428: Deliver to = State'|| l_deliver_to_address_var.state);
597: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'429: Deliver to = Province'|| l_deliver_to_address_var.province);
598: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'431: Deliver to = Postal Code'|| l_deliver_to_address_var.postal_code );
599: END IF;
600: END IF;
601:
602: IF l_ship_to_site_use_id IS NOT NULL THEN

Line 606: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

602: IF l_ship_to_site_use_id IS NOT NULL THEN
603: OPEN c_get_address_info(l_ship_to_site_use_id);
604: FETCH c_get_address_info INTO l_ship_to_address_var;
605: CLOSE c_get_address_info;
606: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
607: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'432: ship to Location = '|| l_ship_to_address_var.location );
608: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'433: ship to Address1 = '|| l_ship_to_address_var.address1);
609: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'434: ship to Address2 = '|| l_ship_to_address_var.address2);
610: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'435: ship to Address3= '|| l_ship_to_address_var.address3);

Line 607: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'432: ship to Location = '|| l_ship_to_address_var.location );

603: OPEN c_get_address_info(l_ship_to_site_use_id);
604: FETCH c_get_address_info INTO l_ship_to_address_var;
605: CLOSE c_get_address_info;
606: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
607: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'432: ship to Location = '|| l_ship_to_address_var.location );
608: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'433: ship to Address1 = '|| l_ship_to_address_var.address1);
609: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'434: ship to Address2 = '|| l_ship_to_address_var.address2);
610: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'435: ship to Address3= '|| l_ship_to_address_var.address3);
611: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'436: ship to Address4 ='|| l_ship_to_address_var.address4);

Line 608: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'433: ship to Address1 = '|| l_ship_to_address_var.address1);

604: FETCH c_get_address_info INTO l_ship_to_address_var;
605: CLOSE c_get_address_info;
606: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
607: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'432: ship to Location = '|| l_ship_to_address_var.location );
608: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'433: ship to Address1 = '|| l_ship_to_address_var.address1);
609: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'434: ship to Address2 = '|| l_ship_to_address_var.address2);
610: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'435: ship to Address3= '|| l_ship_to_address_var.address3);
611: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'436: ship to Address4 ='|| l_ship_to_address_var.address4);
612: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'437: ship to City = '|| l_ship_to_address_var.city );

Line 609: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'434: ship to Address2 = '|| l_ship_to_address_var.address2);

605: CLOSE c_get_address_info;
606: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
607: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'432: ship to Location = '|| l_ship_to_address_var.location );
608: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'433: ship to Address1 = '|| l_ship_to_address_var.address1);
609: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'434: ship to Address2 = '|| l_ship_to_address_var.address2);
610: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'435: ship to Address3= '|| l_ship_to_address_var.address3);
611: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'436: ship to Address4 ='|| l_ship_to_address_var.address4);
612: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'437: ship to City = '|| l_ship_to_address_var.city );
613: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'438: ship to = County'|| l_ship_to_address_var.county);

Line 610: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'435: ship to Address3= '|| l_ship_to_address_var.address3);

606: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
607: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'432: ship to Location = '|| l_ship_to_address_var.location );
608: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'433: ship to Address1 = '|| l_ship_to_address_var.address1);
609: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'434: ship to Address2 = '|| l_ship_to_address_var.address2);
610: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'435: ship to Address3= '|| l_ship_to_address_var.address3);
611: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'436: ship to Address4 ='|| l_ship_to_address_var.address4);
612: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'437: ship to City = '|| l_ship_to_address_var.city );
613: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'438: ship to = County'|| l_ship_to_address_var.county);
614: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'439: ship to = State'|| l_ship_to_address_var.state);

Line 611: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'436: ship to Address4 ='|| l_ship_to_address_var.address4);

607: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'432: ship to Location = '|| l_ship_to_address_var.location );
608: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'433: ship to Address1 = '|| l_ship_to_address_var.address1);
609: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'434: ship to Address2 = '|| l_ship_to_address_var.address2);
610: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'435: ship to Address3= '|| l_ship_to_address_var.address3);
611: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'436: ship to Address4 ='|| l_ship_to_address_var.address4);
612: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'437: ship to City = '|| l_ship_to_address_var.city );
613: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'438: ship to = County'|| l_ship_to_address_var.county);
614: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'439: ship to = State'|| l_ship_to_address_var.state);
615: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'441: ship to = Province'|| l_ship_to_address_var.province);

Line 612: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'437: ship to City = '|| l_ship_to_address_var.city );

608: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'433: ship to Address1 = '|| l_ship_to_address_var.address1);
609: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'434: ship to Address2 = '|| l_ship_to_address_var.address2);
610: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'435: ship to Address3= '|| l_ship_to_address_var.address3);
611: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'436: ship to Address4 ='|| l_ship_to_address_var.address4);
612: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'437: ship to City = '|| l_ship_to_address_var.city );
613: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'438: ship to = County'|| l_ship_to_address_var.county);
614: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'439: ship to = State'|| l_ship_to_address_var.state);
615: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'441: ship to = Province'|| l_ship_to_address_var.province);
616: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'442: ship to = Postal Code'|| l_ship_to_address_var.postal_code );

Line 613: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'438: ship to = County'|| l_ship_to_address_var.county);

609: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'434: ship to Address2 = '|| l_ship_to_address_var.address2);
610: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'435: ship to Address3= '|| l_ship_to_address_var.address3);
611: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'436: ship to Address4 ='|| l_ship_to_address_var.address4);
612: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'437: ship to City = '|| l_ship_to_address_var.city );
613: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'438: ship to = County'|| l_ship_to_address_var.county);
614: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'439: ship to = State'|| l_ship_to_address_var.state);
615: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'441: ship to = Province'|| l_ship_to_address_var.province);
616: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'442: ship to = Postal Code'|| l_ship_to_address_var.postal_code );
617: END IF;

Line 614: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'439: ship to = State'|| l_ship_to_address_var.state);

610: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'435: ship to Address3= '|| l_ship_to_address_var.address3);
611: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'436: ship to Address4 ='|| l_ship_to_address_var.address4);
612: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'437: ship to City = '|| l_ship_to_address_var.city );
613: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'438: ship to = County'|| l_ship_to_address_var.county);
614: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'439: ship to = State'|| l_ship_to_address_var.state);
615: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'441: ship to = Province'|| l_ship_to_address_var.province);
616: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'442: ship to = Postal Code'|| l_ship_to_address_var.postal_code );
617: END IF;
618: END IF;

Line 615: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'441: ship to = Province'|| l_ship_to_address_var.province);

611: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'436: ship to Address4 ='|| l_ship_to_address_var.address4);
612: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'437: ship to City = '|| l_ship_to_address_var.city );
613: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'438: ship to = County'|| l_ship_to_address_var.county);
614: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'439: ship to = State'|| l_ship_to_address_var.state);
615: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'441: ship to = Province'|| l_ship_to_address_var.province);
616: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'442: ship to = Postal Code'|| l_ship_to_address_var.postal_code );
617: END IF;
618: END IF;
619:

Line 616: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'442: ship to = Postal Code'|| l_ship_to_address_var.postal_code );

612: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'437: ship to City = '|| l_ship_to_address_var.city );
613: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'438: ship to = County'|| l_ship_to_address_var.county);
614: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'439: ship to = State'|| l_ship_to_address_var.state);
615: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'441: ship to = Province'|| l_ship_to_address_var.province);
616: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'442: ship to = Postal Code'|| l_ship_to_address_var.postal_code );
617: END IF;
618: END IF;
619:
620: FOR i IN p_sys_var_value_tbl.FIRST..p_sys_var_value_tbl.LAST LOOP

Line 646: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

642: IF l_sold_to_site_use_id IS NOT NULL THEN
643: OPEN c_get_country(l_sold_to_site_use_id);
644: FETCH c_get_country INTO p_sys_var_value_tbl(i).variable_value_id;
645: CLOSE c_get_country;
646: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
647: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'430: Sold to country = '||p_sys_var_value_tbl(i).variable_value_id);
648: END IF;
649: END IF;
650: END;

Line 647: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'430: Sold to country = '||p_sys_var_value_tbl(i).variable_value_id);

643: OPEN c_get_country(l_sold_to_site_use_id);
644: FETCH c_get_country INTO p_sys_var_value_tbl(i).variable_value_id;
645: CLOSE c_get_country;
646: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
647: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'430: Sold to country = '||p_sys_var_value_tbl(i).variable_value_id);
648: END IF;
649: END IF;
650: END;
651:

Line 658: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

654: IF l_ship_to_site_use_id IS NOT NULL THEN
655: OPEN c_get_country(l_ship_to_site_use_id);
656: FETCH c_get_country INTO p_sys_var_value_tbl(i).variable_value_id;
657: CLOSE c_get_country;
658: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
659: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'440: Ship to country = '||p_sys_var_value_tbl(i).variable_value_id);
660: END IF;
661: END IF;
662: END;

Line 659: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'440: Ship to country = '||p_sys_var_value_tbl(i).variable_value_id);

655: OPEN c_get_country(l_ship_to_site_use_id);
656: FETCH c_get_country INTO p_sys_var_value_tbl(i).variable_value_id;
657: CLOSE c_get_country;
658: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
659: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'440: Ship to country = '||p_sys_var_value_tbl(i).variable_value_id);
660: END IF;
661: END IF;
662: END;
663:

Line 670: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

666: IF l_invoice_to_site_use_id IS NOT NULL THEN
667: OPEN c_get_country(l_invoice_to_site_use_id);
668: FETCH c_get_country INTO p_sys_var_value_tbl(i).variable_value_id;
669: CLOSE c_get_country;
670: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
671: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'450: Invoice to country = '||p_sys_var_value_tbl(i).variable_value_id);
672: END IF;
673: END IF;
674: END;

Line 671: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'450: Invoice to country = '||p_sys_var_value_tbl(i).variable_value_id);

667: OPEN c_get_country(l_invoice_to_site_use_id);
668: FETCH c_get_country INTO p_sys_var_value_tbl(i).variable_value_id;
669: CLOSE c_get_country;
670: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
671: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'450: Invoice to country = '||p_sys_var_value_tbl(i).variable_value_id);
672: END IF;
673: END IF;
674: END;
675:

Line 691: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

687: IF l_invoice_to_site_use_id IS NOT NULL THEN
688: OPEN c_get_cust_account(l_invoice_to_site_use_id);
689: FETCH c_get_cust_account INTO p_sys_var_value_tbl(i).variable_value_id;
690: CLOSE c_get_cust_account;
691: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
692: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'460: Invoice to Customer = '||p_sys_var_value_tbl(i).variable_value_id);
693: END IF;
694: END IF;
695: END;

Line 692: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'460: Invoice to Customer = '||p_sys_var_value_tbl(i).variable_value_id);

688: OPEN c_get_cust_account(l_invoice_to_site_use_id);
689: FETCH c_get_cust_account INTO p_sys_var_value_tbl(i).variable_value_id;
690: CLOSE c_get_cust_account;
691: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
692: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'460: Invoice to Customer = '||p_sys_var_value_tbl(i).variable_value_id);
693: END IF;
694: END IF;
695: END;
696:

Line 703: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

699: IF l_ship_to_site_use_id IS NOT NULL THEN
700: OPEN c_get_cust_account(l_ship_to_site_use_id);
701: FETCH c_get_cust_account INTO p_sys_var_value_tbl(i).variable_value_id;
702: CLOSE c_get_cust_account;
703: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
704: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'470: Ship to Customer = '||p_sys_var_value_tbl(i).variable_value_id);
705: END IF;
706: END IF;
707: END;

Line 704: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'470: Ship to Customer = '||p_sys_var_value_tbl(i).variable_value_id);

700: OPEN c_get_cust_account(l_ship_to_site_use_id);
701: FETCH c_get_cust_account INTO p_sys_var_value_tbl(i).variable_value_id;
702: CLOSE c_get_cust_account;
703: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
704: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'470: Ship to Customer = '||p_sys_var_value_tbl(i).variable_value_id);
705: END IF;
706: END IF;
707: END;
708:

Line 1149: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1145: IF l_ship_to_site_use_id IS NOT NULL THEN
1146: OPEN c_get_country(l_deliver_to_site_use_id);
1147: FETCH c_get_country INTO p_sys_var_value_tbl(i).variable_value_id;
1148: CLOSE c_get_country;
1149: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1150: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'440: deliver to country = '||p_sys_var_value_tbl(i).variable_value_id);
1151: END IF;
1152: END IF;
1153: END;

Line 1150: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'440: deliver to country = '||p_sys_var_value_tbl(i).variable_value_id);

1146: OPEN c_get_country(l_deliver_to_site_use_id);
1147: FETCH c_get_country INTO p_sys_var_value_tbl(i).variable_value_id;
1148: CLOSE c_get_country;
1149: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1150: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'440: deliver to country = '||p_sys_var_value_tbl(i).variable_value_id);
1151: END IF;
1152: END IF;
1153: END;
1154:

Line 1165: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1161: --END- Bug 6899074
1162:
1163: END IF;
1164:
1165: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1166: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'480: p_sys_var_value_tbl('||i||').variable_code : '||p_sys_var_value_tbl(i).variable_code);
1167: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'485: p_sys_var_value_tbl('||i||').variable_value_id : '||p_sys_var_value_tbl(i).variable_value_id);
1168: END IF;
1169:

Line 1166: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'480: p_sys_var_value_tbl('||i||').variable_code : '||p_sys_var_value_tbl(i).variable_code);

1162:
1163: END IF;
1164:
1165: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1166: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'480: p_sys_var_value_tbl('||i||').variable_code : '||p_sys_var_value_tbl(i).variable_code);
1167: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'485: p_sys_var_value_tbl('||i||').variable_value_id : '||p_sys_var_value_tbl(i).variable_value_id);
1168: END IF;
1169:
1170:

Line 1167: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'485: p_sys_var_value_tbl('||i||').variable_value_id : '||p_sys_var_value_tbl(i).variable_value_id);

1163: END IF;
1164:
1165: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1166: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'480: p_sys_var_value_tbl('||i||').variable_code : '||p_sys_var_value_tbl(i).variable_code);
1167: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'485: p_sys_var_value_tbl('||i||').variable_value_id : '||p_sys_var_value_tbl(i).variable_value_id);
1168: END IF;
1169:
1170:
1171: END LOOP;

Line 1175: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1171: END LOOP;
1172:
1173: END IF;
1174:
1175: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1176: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'490: End of '||l_package_procedure||' for header level variables, x_return_status ' || x_return_status);
1177: END IF;
1178:
1179:

Line 1176: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'490: End of '||l_package_procedure||' for header level variables, x_return_status ' || x_return_status);

1172:
1173: END IF;
1174:
1175: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1176: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'490: End of '||l_package_procedure||' for header level variables, x_return_status ' || x_return_status);
1177: END IF;
1178:
1179:
1180: EXCEPTION

Line 1213: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1209: CLOSE c_get_address_info;
1210: END IF;
1211:
1212: x_return_status := FND_API.G_RET_STS_ERROR ;
1213: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1214: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'500: '||l_package_procedure||' In the FND_API.G_EXC_ERROR section');
1215: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'510: x_return_status = '||x_return_status);
1216: END IF;
1217:

Line 1214: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'500: '||l_package_procedure||' In the FND_API.G_EXC_ERROR section');

1210: END IF;
1211:
1212: x_return_status := FND_API.G_RET_STS_ERROR ;
1213: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1214: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'500: '||l_package_procedure||' In the FND_API.G_EXC_ERROR section');
1215: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'510: x_return_status = '||x_return_status);
1216: END IF;
1217:
1218: FND_MSG_PUB.Count_And_Get(

Line 1215: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'510: x_return_status = '||x_return_status);

1211:
1212: x_return_status := FND_API.G_RET_STS_ERROR ;
1213: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1214: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'500: '||l_package_procedure||' In the FND_API.G_EXC_ERROR section');
1215: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'510: x_return_status = '||x_return_status);
1216: END IF;
1217:
1218: FND_MSG_PUB.Count_And_Get(
1219: p_count => x_msg_count,

Line 1254: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1250: END IF;
1251:
1252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1253:
1254: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1255: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'520: '||l_package_procedure||' In the FND_API.G_RET_STS_UNEXP_ERROR section');
1256: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'530: x_return_status = '||x_return_status);
1257: END IF;
1258:

Line 1255: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'520: '||l_package_procedure||' In the FND_API.G_RET_STS_UNEXP_ERROR section');

1251:
1252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1253:
1254: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1255: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'520: '||l_package_procedure||' In the FND_API.G_RET_STS_UNEXP_ERROR section');
1256: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'530: x_return_status = '||x_return_status);
1257: END IF;
1258:
1259: FND_MSG_PUB.Count_And_Get(

Line 1256: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'530: x_return_status = '||x_return_status);

1252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1253:
1254: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1255: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'520: '||l_package_procedure||' In the FND_API.G_RET_STS_UNEXP_ERROR section');
1256: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'530: x_return_status = '||x_return_status);
1257: END IF;
1258:
1259: FND_MSG_PUB.Count_And_Get(
1260: p_count => x_msg_count,

Line 1294: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1290: CLOSE c_get_address_info;
1291: END IF;
1292:
1293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1294: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1295: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'540: '||l_package_procedure||' In the OTHERS section');
1296: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'550: x_return_status = '||x_return_status);
1297: END IF;
1298:

Line 1295: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'540: '||l_package_procedure||' In the OTHERS section');

1291: END IF;
1292:
1293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1294: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1295: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'540: '||l_package_procedure||' In the OTHERS section');
1296: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'550: x_return_status = '||x_return_status);
1297: END IF;
1298:
1299: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 1296: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'550: x_return_status = '||x_return_status);

1292:
1293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1294: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1295: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'540: '||l_package_procedure||' In the OTHERS section');
1296: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'550: x_return_status = '||x_return_status);
1297: END IF;
1298:
1299: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1300: FND_MSG_PUB.Add_Exc_Msg(

Line 1431: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1427: l_package_procedure := G_PKG_NAME || '.' || l_api_name || ' - 2';
1428:
1429: x_return_status := FND_API.G_RET_STS_SUCCESS;
1430:
1431: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1432: l_debug := true;
1433: END IF;
1434:
1435: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1435: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1431: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1432: l_debug := true;
1433: END IF;
1434:
1435: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1436: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'10: Entered ' || l_package_procedure);
1437: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'20: p_doc_type: ' || p_doc_type);
1438: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'30: p_doc_id: ' || p_doc_id);
1439: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40: p_line_var_tbl.COUNT: ' || p_line_var_tbl.COUNT);

Line 1436: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'10: Entered ' || l_package_procedure);

1432: l_debug := true;
1433: END IF;
1434:
1435: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1436: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'10: Entered ' || l_package_procedure);
1437: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'20: p_doc_type: ' || p_doc_type);
1438: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'30: p_doc_id: ' || p_doc_id);
1439: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40: p_line_var_tbl.COUNT: ' || p_line_var_tbl.COUNT);
1440: END IF;

Line 1437: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'20: p_doc_type: ' || p_doc_type);

1433: END IF;
1434:
1435: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1436: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'10: Entered ' || l_package_procedure);
1437: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'20: p_doc_type: ' || p_doc_type);
1438: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'30: p_doc_id: ' || p_doc_id);
1439: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40: p_line_var_tbl.COUNT: ' || p_line_var_tbl.COUNT);
1440: END IF;
1441:

Line 1438: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'30: p_doc_id: ' || p_doc_id);

1434:
1435: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1436: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'10: Entered ' || l_package_procedure);
1437: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'20: p_doc_type: ' || p_doc_type);
1438: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'30: p_doc_id: ' || p_doc_id);
1439: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40: p_line_var_tbl.COUNT: ' || p_line_var_tbl.COUNT);
1440: END IF;
1441:
1442: --

Line 1439: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40: p_line_var_tbl.COUNT: ' || p_line_var_tbl.COUNT);

1435: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1436: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'10: Entered ' || l_package_procedure);
1437: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'20: p_doc_type: ' || p_doc_type);
1438: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'30: p_doc_id: ' || p_doc_id);
1439: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40: p_line_var_tbl.COUNT: ' || p_line_var_tbl.COUNT);
1440: END IF;
1441:
1442: --
1443: -- Standard call to check for call compatibility.

Line 1471: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1467:
1468: l_master_org_id := TO_NUMBER(oe_sys_parameters.value (
1469: param_name => 'MASTER_ORGANIZATION_ID',p_org_id => l_current_org_id ));
1470:
1471: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1472: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'45: l_master_org_id: ' || l_master_org_id);
1473: END IF;
1474:
1475: -- Query OM tables oe_blanket_headers_all and oe_blanket_lines_all to retrieve values

Line 1472: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'45: l_master_org_id: ' || l_master_org_id);

1468: l_master_org_id := TO_NUMBER(oe_sys_parameters.value (
1469: param_name => 'MASTER_ORGANIZATION_ID',p_org_id => l_current_org_id ));
1470:
1471: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1472: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'45: l_master_org_id: ' || l_master_org_id);
1473: END IF;
1474:
1475: -- Query OM tables oe_blanket_headers_all and oe_blanket_lines_all to retrieve values
1476: -- against variable codes sent in by calling contrtact expert API

Line 1481: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1477:
1478: IF p_line_var_tbl.FIRST IS NOT NULL THEN
1479: FOR i IN p_line_var_tbl.FIRST..p_line_var_tbl.LAST LOOP
1480:
1481: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1482: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: Processing for ' || p_line_var_tbl(i));
1483: END IF;
1484:
1485: IF p_line_var_tbl(i) = G_ITEM_CODE THEN

Line 1482: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: Processing for ' || p_line_var_tbl(i));

1478: IF p_line_var_tbl.FIRST IS NOT NULL THEN
1479: FOR i IN p_line_var_tbl.FIRST..p_line_var_tbl.LAST LOOP
1480:
1481: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1482: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: Processing for ' || p_line_var_tbl(i));
1483: END IF;
1484:
1485: IF p_line_var_tbl(i) = G_ITEM_CODE THEN
1486:

Line 1489: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1485: IF p_line_var_tbl(i) = G_ITEM_CODE THEN
1486:
1487: FOR c_get_items_rec IN c_get_items LOOP
1488: --loop thru all the items for internal INT items
1489: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1490: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: c_get_items_rec.item_identifier_type: '||c_get_items_rec.item_identifier_type);
1491: END IF;
1492:
1493: IF c_get_items_rec.item_identifier_type = 'INT' THEN

Line 1490: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: c_get_items_rec.item_identifier_type: '||c_get_items_rec.item_identifier_type);

1486:
1487: FOR c_get_items_rec IN c_get_items LOOP
1488: --loop thru all the items for internal INT items
1489: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1490: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: c_get_items_rec.item_identifier_type: '||c_get_items_rec.item_identifier_type);
1491: END IF;
1492:
1493: IF c_get_items_rec.item_identifier_type = 'INT' THEN
1494: x_line_var_value_tbl(j).variable_code := p_line_var_tbl(i); --i.e. OKC$S_ITEM

Line 1497: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1493: IF c_get_items_rec.item_identifier_type = 'INT' THEN
1494: x_line_var_value_tbl(j).variable_code := p_line_var_tbl(i); --i.e. OKC$S_ITEM
1495: x_line_var_value_tbl(j).variable_value_id := c_get_items_rec.ordered_item; --eg. AS54888
1496:
1497: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1498: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: x_line_var_value_tbl('||j||').variable_code: ' || p_line_var_tbl(i));
1499: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: x_line_var_value_tbl('||j||').variable_value_id: ' || c_get_items_rec.ordered_item);
1500: END IF;
1501:

Line 1498: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: x_line_var_value_tbl('||j||').variable_code: ' || p_line_var_tbl(i));

1494: x_line_var_value_tbl(j).variable_code := p_line_var_tbl(i); --i.e. OKC$S_ITEM
1495: x_line_var_value_tbl(j).variable_value_id := c_get_items_rec.ordered_item; --eg. AS54888
1496:
1497: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1498: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: x_line_var_value_tbl('||j||').variable_code: ' || p_line_var_tbl(i));
1499: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: x_line_var_value_tbl('||j||').variable_value_id: ' || c_get_items_rec.ordered_item);
1500: END IF;
1501:
1502: ELSIF c_get_items_rec.item_identifier_type <> 'INT' THEN

Line 1499: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: x_line_var_value_tbl('||j||').variable_value_id: ' || c_get_items_rec.ordered_item);

1495: x_line_var_value_tbl(j).variable_value_id := c_get_items_rec.ordered_item; --eg. AS54888
1496:
1497: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1498: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: x_line_var_value_tbl('||j||').variable_code: ' || p_line_var_tbl(i));
1499: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: x_line_var_value_tbl('||j||').variable_value_id: ' || c_get_items_rec.ordered_item);
1500: END IF;
1501:
1502: ELSIF c_get_items_rec.item_identifier_type <> 'INT' THEN
1503: --map the non-INT items to INT items

Line 1505: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1501:
1502: ELSIF c_get_items_rec.item_identifier_type <> 'INT' THEN
1503: --map the non-INT items to INT items
1504:
1505: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1506: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: Mapping non-INT item to INT item, Calling OE_Id_To_Value.Ordered_Item ');
1507: END IF;
1508:
1509: -- Map non-INT item to INT item

Line 1506: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: Mapping non-INT item to INT item, Calling OE_Id_To_Value.Ordered_Item ');

1502: ELSIF c_get_items_rec.item_identifier_type <> 'INT' THEN
1503: --map the non-INT items to INT items
1504:
1505: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1506: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: Mapping non-INT item to INT item, Calling OE_Id_To_Value.Ordered_Item ');
1507: END IF;
1508:
1509: -- Map non-INT item to INT item
1510: OE_Id_To_Value.Ordered_Item (

Line 1524: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1520:
1521: x_line_var_value_tbl(j).variable_code := p_line_var_tbl(i); --i.e. OKC$S_ITEM
1522: x_line_var_value_tbl(j).variable_value_id := lx_inventory_item;
1523:
1524: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1525: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: x_line_var_value_tbl('||j||').variable_code: ' || p_line_var_tbl(i));
1526: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: x_line_var_value_tbl('||j||').variable_value_id: ' || lx_inventory_item);
1527: END IF;
1528: END IF;

Line 1525: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: x_line_var_value_tbl('||j||').variable_code: ' || p_line_var_tbl(i));

1521: x_line_var_value_tbl(j).variable_code := p_line_var_tbl(i); --i.e. OKC$S_ITEM
1522: x_line_var_value_tbl(j).variable_value_id := lx_inventory_item;
1523:
1524: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1525: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: x_line_var_value_tbl('||j||').variable_code: ' || p_line_var_tbl(i));
1526: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: x_line_var_value_tbl('||j||').variable_value_id: ' || lx_inventory_item);
1527: END IF;
1528: END IF;
1529:

Line 1526: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: x_line_var_value_tbl('||j||').variable_value_id: ' || lx_inventory_item);

1522: x_line_var_value_tbl(j).variable_value_id := lx_inventory_item;
1523:
1524: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1525: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: x_line_var_value_tbl('||j||').variable_code: ' || p_line_var_tbl(i));
1526: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: x_line_var_value_tbl('||j||').variable_value_id: ' || lx_inventory_item);
1527: END IF;
1528: END IF;
1529:
1530: j := j + 1;

Line 1544: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1540:
1541: x_line_var_value_tbl(j).variable_code := p_line_var_tbl(i); --i.e. OKC$S_ITEM_CATEGORY
1542: x_line_var_value_tbl(j).variable_value_id := c_get_item_categories_rec.ordered_item;
1543:
1544: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1545: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: x_line_var_value_tbl('||j||').variable_code: '||p_line_var_tbl(i));
1546: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: x_line_var_value_tbl('||j||').variable_value_id: '||c_get_item_categories_rec.ordered_item);
1547: END IF;
1548:

Line 1545: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: x_line_var_value_tbl('||j||').variable_code: '||p_line_var_tbl(i));

1541: x_line_var_value_tbl(j).variable_code := p_line_var_tbl(i); --i.e. OKC$S_ITEM_CATEGORY
1542: x_line_var_value_tbl(j).variable_value_id := c_get_item_categories_rec.ordered_item;
1543:
1544: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1545: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: x_line_var_value_tbl('||j||').variable_code: '||p_line_var_tbl(i));
1546: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: x_line_var_value_tbl('||j||').variable_value_id: '||c_get_item_categories_rec.ordered_item);
1547: END IF;
1548:
1549: j := j + 1;

Line 1546: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: x_line_var_value_tbl('||j||').variable_value_id: '||c_get_item_categories_rec.ordered_item);

1542: x_line_var_value_tbl(j).variable_value_id := c_get_item_categories_rec.ordered_item;
1543:
1544: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1545: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: x_line_var_value_tbl('||j||').variable_code: '||p_line_var_tbl(i));
1546: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: x_line_var_value_tbl('||j||').variable_value_id: '||c_get_item_categories_rec.ordered_item);
1547: END IF;
1548:
1549: j := j + 1;
1550:

Line 1560: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1556: -- item category
1557:
1558: FOR c_get_items_rec IN c_get_items LOOP
1559:
1560: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1561: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'140: get the item categories to which the INT and non-INT items in the BSA belong to');
1562: END IF;
1563:
1564: l_bsa_derived_item_category := null; --initialize

Line 1561: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'140: get the item categories to which the INT and non-INT items in the BSA belong to');

1557:
1558: FOR c_get_items_rec IN c_get_items LOOP
1559:
1560: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1561: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'140: get the item categories to which the INT and non-INT items in the BSA belong to');
1562: END IF;
1563:
1564: l_bsa_derived_item_category := null; --initialize
1565:

Line 1573: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1569:
1570: x_line_var_value_tbl(j).variable_code := p_line_var_tbl(i); --i.e. OKC$S_ITEM_CATEGORY
1571: x_line_var_value_tbl(j).variable_value_id := l_bsa_derived_item_category.category_concat_segs;
1572:
1573: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1574: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: x_line_var_value_tbl('||j||').variable_code: '||p_line_var_tbl(i));
1575: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: x_line_var_value_tbl('||j||').variable_value_id: '||l_bsa_derived_item_category.category_concat_segs);
1576: END IF;
1577:

Line 1574: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: x_line_var_value_tbl('||j||').variable_code: '||p_line_var_tbl(i));

1570: x_line_var_value_tbl(j).variable_code := p_line_var_tbl(i); --i.e. OKC$S_ITEM_CATEGORY
1571: x_line_var_value_tbl(j).variable_value_id := l_bsa_derived_item_category.category_concat_segs;
1572:
1573: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1574: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: x_line_var_value_tbl('||j||').variable_code: '||p_line_var_tbl(i));
1575: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: x_line_var_value_tbl('||j||').variable_value_id: '||l_bsa_derived_item_category.category_concat_segs);
1576: END IF;
1577:
1578: j := j + 1;

Line 1575: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: x_line_var_value_tbl('||j||').variable_value_id: '||l_bsa_derived_item_category.category_concat_segs);

1571: x_line_var_value_tbl(j).variable_value_id := l_bsa_derived_item_category.category_concat_segs;
1572:
1573: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1574: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: x_line_var_value_tbl('||j||').variable_code: '||p_line_var_tbl(i));
1575: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: x_line_var_value_tbl('||j||').variable_value_id: '||l_bsa_derived_item_category.category_concat_segs);
1576: END IF;
1577:
1578: j := j + 1;
1579:

Line 1587: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1583:
1584: END LOOP;
1585: END IF; ----IF p_line_var_tbl.FIRST IS NOT NULL THEN
1586:
1587: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1588: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: End of '||l_package_procedure||'for line level variables, x_return_status: '|| x_return_status);
1589: END IF;
1590:
1591: EXCEPTION

Line 1588: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: End of '||l_package_procedure||'for line level variables, x_return_status: '|| x_return_status);

1584: END LOOP;
1585: END IF; ----IF p_line_var_tbl.FIRST IS NOT NULL THEN
1586:
1587: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1588: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: End of '||l_package_procedure||'for line level variables, x_return_status: '|| x_return_status);
1589: END IF;
1590:
1591: EXCEPTION
1592:

Line 1613: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1609: FND_MSG_PUB.Count_And_Get(
1610: p_count => x_msg_count,
1611: p_data => x_msg_data );
1612:
1613: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1614: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: '||l_package_procedure||' In the FND_API.G_EXC_ERROR section');
1615: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: x_return_status = '||x_return_status);
1616: END IF;
1617:

Line 1614: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: '||l_package_procedure||' In the FND_API.G_EXC_ERROR section');

1610: p_count => x_msg_count,
1611: p_data => x_msg_data );
1612:
1613: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1614: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: '||l_package_procedure||' In the FND_API.G_EXC_ERROR section');
1615: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: x_return_status = '||x_return_status);
1616: END IF;
1617:
1618: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1615: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: x_return_status = '||x_return_status);

1611: p_data => x_msg_data );
1612:
1613: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1614: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: '||l_package_procedure||' In the FND_API.G_EXC_ERROR section');
1615: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: x_return_status = '||x_return_status);
1616: END IF;
1617:
1618: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1619:

Line 1638: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1634: FND_MSG_PUB.Count_And_Get(
1635: p_count => x_msg_count,
1636: p_data => x_msg_data );
1637:
1638: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1639: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: '||l_package_procedure||' In the FND_API.G_EXC_UNEXPECTED_ERROR section');
1640: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: x_return_status = '||x_return_status);
1641: END IF;
1642:

Line 1639: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: '||l_package_procedure||' In the FND_API.G_EXC_UNEXPECTED_ERROR section');

1635: p_count => x_msg_count,
1636: p_data => x_msg_data );
1637:
1638: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1639: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: '||l_package_procedure||' In the FND_API.G_EXC_UNEXPECTED_ERROR section');
1640: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: x_return_status = '||x_return_status);
1641: END IF;
1642:
1643: WHEN OTHERS THEN

Line 1640: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: x_return_status = '||x_return_status);

1636: p_data => x_msg_data );
1637:
1638: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1639: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: '||l_package_procedure||' In the FND_API.G_EXC_UNEXPECTED_ERROR section');
1640: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: x_return_status = '||x_return_status);
1641: END IF;
1642:
1643: WHEN OTHERS THEN
1644:

Line 1669: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1665: FND_MSG_PUB.Count_And_Get(
1666: p_count => x_msg_count,
1667: p_data => x_msg_data );
1668:
1669: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1670: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: '||l_package_procedure||' In the OTHERS section');
1671: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: x_return_status = '||x_return_status);
1672: END IF;
1673:

Line 1670: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: '||l_package_procedure||' In the OTHERS section');

1666: p_count => x_msg_count,
1667: p_data => x_msg_data );
1668:
1669: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1670: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: '||l_package_procedure||' In the OTHERS section');
1671: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: x_return_status = '||x_return_status);
1672: END IF;
1673:
1674: END get_clause_variable_values;

Line 1671: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: x_return_status = '||x_return_status);

1667: p_data => x_msg_data );
1668:
1669: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1670: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: '||l_package_procedure||' In the OTHERS section');
1671: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: x_return_status = '||x_return_status);
1672: END IF;
1673:
1674: END get_clause_variable_values;
1675:

Line 1815: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1811: l_package_procedure := G_PKG_NAME || '.' || l_api_name;
1812:
1813: x_return_status := FND_API.G_RET_STS_SUCCESS;
1814:
1815: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1816: l_debug := true;
1817: END IF;
1818:
1819: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1819: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1815: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1816: l_debug := true;
1817: END IF;
1818:
1819: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1820: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'10: Entered ' || l_package_procedure);
1821: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'20: p_doc_id: ' || p_doc_id);
1822: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'30: p_doc_type: ' || p_doc_type);
1823: END IF;

Line 1820: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'10: Entered ' || l_package_procedure);

1816: l_debug := true;
1817: END IF;
1818:
1819: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1820: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'10: Entered ' || l_package_procedure);
1821: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'20: p_doc_id: ' || p_doc_id);
1822: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'30: p_doc_type: ' || p_doc_type);
1823: END IF;
1824:

Line 1821: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'20: p_doc_id: ' || p_doc_id);

1817: END IF;
1818:
1819: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1820: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'10: Entered ' || l_package_procedure);
1821: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'20: p_doc_id: ' || p_doc_id);
1822: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'30: p_doc_type: ' || p_doc_type);
1823: END IF;
1824:
1825: --

Line 1822: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'30: p_doc_type: ' || p_doc_type);

1818:
1819: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1820: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'10: Entered ' || l_package_procedure);
1821: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'20: p_doc_id: ' || p_doc_id);
1822: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'30: p_doc_type: ' || p_doc_type);
1823: END IF;
1824:
1825: --
1826: -- Standard call to check for call compatibility.

Line 1854: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1850:
1851: l_master_org_id := TO_NUMBER(oe_sys_parameters.value (
1852: param_name => 'MASTER_ORGANIZATION_ID',p_org_id => l_current_org_id ));
1853:
1854: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1855: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'35: l_master_org_id: ' || l_master_org_id);
1856: END IF;
1857: --AK
1858:

Line 1855: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'35: l_master_org_id: ' || l_master_org_id);

1851: l_master_org_id := TO_NUMBER(oe_sys_parameters.value (
1852: param_name => 'MASTER_ORGANIZATION_ID',p_org_id => l_current_org_id ));
1853:
1854: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1855: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'35: l_master_org_id: ' || l_master_org_id);
1856: END IF;
1857: --AK
1858:
1859: IF p_doc_type = G_BSA_DOC_TYPE THEN

Line 1867: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1863: EXIT WHEN c_get_bsa_line_variables%NOTFOUND;
1864:
1865: l_line_number := to_char(l_bsa_line_variables.line_number);
1866:
1867: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1868: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40: line_number = '||l_bsa_line_variables.line_number );
1869: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: payment_term_id = '||l_bsa_line_variables.payment_term_id );
1870: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: item_id = '||l_bsa_line_variables.inventory_item_id );
1871: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: org_id = '||l_bsa_line_variables.org_id );

Line 1868: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40: line_number = '||l_bsa_line_variables.line_number );

1864:
1865: l_line_number := to_char(l_bsa_line_variables.line_number);
1866:
1867: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1868: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40: line_number = '||l_bsa_line_variables.line_number );
1869: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: payment_term_id = '||l_bsa_line_variables.payment_term_id );
1870: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: item_id = '||l_bsa_line_variables.inventory_item_id );
1871: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: org_id = '||l_bsa_line_variables.org_id );
1872: END IF;

Line 1869: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: payment_term_id = '||l_bsa_line_variables.payment_term_id );

1865: l_line_number := to_char(l_bsa_line_variables.line_number);
1866:
1867: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1868: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40: line_number = '||l_bsa_line_variables.line_number );
1869: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: payment_term_id = '||l_bsa_line_variables.payment_term_id );
1870: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: item_id = '||l_bsa_line_variables.inventory_item_id );
1871: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: org_id = '||l_bsa_line_variables.org_id );
1872: END IF;
1873:

Line 1870: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: item_id = '||l_bsa_line_variables.inventory_item_id );

1866:
1867: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1868: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40: line_number = '||l_bsa_line_variables.line_number );
1869: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: payment_term_id = '||l_bsa_line_variables.payment_term_id );
1870: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: item_id = '||l_bsa_line_variables.inventory_item_id );
1871: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: org_id = '||l_bsa_line_variables.org_id );
1872: END IF;
1873:
1874:

Line 1871: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: org_id = '||l_bsa_line_variables.org_id );

1867: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1868: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40: line_number = '||l_bsa_line_variables.line_number );
1869: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: payment_term_id = '||l_bsa_line_variables.payment_term_id );
1870: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: item_id = '||l_bsa_line_variables.inventory_item_id );
1871: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: org_id = '||l_bsa_line_variables.org_id );
1872: END IF;
1873:
1874:
1875: l_line_count := l_line_count+1;

Line 1906: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1902: x_line_sys_var_value_tbl(l_index).org_id := l_bsa_line_variables.org_id;
1903: ELSIF l_bsa_line_variables.item_identifier_type <> 'INT' THEN
1904: --map the non-INT items to INT items
1905:
1906: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1907: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'71: Mapping non-INT item to INT item, Calling OE_Id_To_Value.Ordered_Item ');
1908: END IF;
1909:
1910: -- Map non-INT item to INT item

Line 1907: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'71: Mapping non-INT item to INT item, Calling OE_Id_To_Value.Ordered_Item ');

1903: ELSIF l_bsa_line_variables.item_identifier_type <> 'INT' THEN
1904: --map the non-INT items to INT items
1905:
1906: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1907: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'71: Mapping non-INT item to INT item, Calling OE_Id_To_Value.Ordered_Item ');
1908: END IF;
1909:
1910: -- Map non-INT item to INT item
1911: OE_Id_To_Value.Ordered_Item (

Line 1928: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1924: x_line_sys_var_value_tbl(l_index).variable_value := lx_inventory_item;
1925: x_line_sys_var_value_tbl(l_index).item_id := l_bsa_line_variables.inventory_item_id;
1926: x_line_sys_var_value_tbl(l_index).org_id := l_bsa_line_variables.org_id;
1927:
1928: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1929: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'72: x_line_var_value_tbl('||j||').variable_code: ' || G_ITEM_CODE);
1930: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'73: x_line_var_value_tbl('||j||').variable_value_id: ' || lx_inventory_item);
1931: END IF;
1932: END IF;

Line 1929: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'72: x_line_var_value_tbl('||j||').variable_code: ' || G_ITEM_CODE);

1925: x_line_sys_var_value_tbl(l_index).item_id := l_bsa_line_variables.inventory_item_id;
1926: x_line_sys_var_value_tbl(l_index).org_id := l_bsa_line_variables.org_id;
1927:
1928: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1929: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'72: x_line_var_value_tbl('||j||').variable_code: ' || G_ITEM_CODE);
1930: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'73: x_line_var_value_tbl('||j||').variable_value_id: ' || lx_inventory_item);
1931: END IF;
1932: END IF;
1933:

Line 1930: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'73: x_line_var_value_tbl('||j||').variable_value_id: ' || lx_inventory_item);

1926: x_line_sys_var_value_tbl(l_index).org_id := l_bsa_line_variables.org_id;
1927:
1928: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1929: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'72: x_line_var_value_tbl('||j||').variable_code: ' || G_ITEM_CODE);
1930: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'73: x_line_var_value_tbl('||j||').variable_value_id: ' || lx_inventory_item);
1931: END IF;
1932: END IF;
1933:
1934: IF l_bsa_line_variables.inventory_item_id IS NOT NULL THEN

Line 1956: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1952: x_line_sys_var_value_tbl(l_index).variable_value := l_bsa_derived_item_category;
1953: x_line_sys_var_value_tbl(l_index).item_id := l_bsa_line_variables.inventory_item_id;
1954: x_line_sys_var_value_tbl(l_index).org_id := l_bsa_line_variables.org_id;
1955:
1956: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1957: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'74: x_line_var_value_tbl('||j||').variable_code: '||G_ITEM_CATEGORY_CODE);
1958: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'75: x_line_var_value_tbl('||j||').variable_value_id: '||l_bsa_derived_item_category);
1959: END IF;
1960: END IF;

Line 1957: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'74: x_line_var_value_tbl('||j||').variable_code: '||G_ITEM_CATEGORY_CODE);

1953: x_line_sys_var_value_tbl(l_index).item_id := l_bsa_line_variables.inventory_item_id;
1954: x_line_sys_var_value_tbl(l_index).org_id := l_bsa_line_variables.org_id;
1955:
1956: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1957: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'74: x_line_var_value_tbl('||j||').variable_code: '||G_ITEM_CATEGORY_CODE);
1958: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'75: x_line_var_value_tbl('||j||').variable_value_id: '||l_bsa_derived_item_category);
1959: END IF;
1960: END IF;
1961:

Line 1958: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'75: x_line_var_value_tbl('||j||').variable_value_id: '||l_bsa_derived_item_category);

1954: x_line_sys_var_value_tbl(l_index).org_id := l_bsa_line_variables.org_id;
1955:
1956: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1957: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'74: x_line_var_value_tbl('||j||').variable_code: '||G_ITEM_CATEGORY_CODE);
1958: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'75: x_line_var_value_tbl('||j||').variable_value_id: '||l_bsa_derived_item_category);
1959: END IF;
1960: END IF;
1961:
1962: --AK

Line 2028: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2024:
2025: END IF; /* if service number is not null */
2026: -- Bug 4768964 Logic provided by OM
2027:
2028: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2029: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: line_number = '||l_so_line_variables.line_number );
2030: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: payment_term_id = '||l_so_line_variables.payment_term_id );
2031: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: invoicing_rule_id = '||l_so_line_variables.invoicing_rule_id );
2032: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: agreement_id = '||l_so_line_variables.agreement_id );

Line 2029: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: line_number = '||l_so_line_variables.line_number );

2025: END IF; /* if service number is not null */
2026: -- Bug 4768964 Logic provided by OM
2027:
2028: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2029: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: line_number = '||l_so_line_variables.line_number );
2030: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: payment_term_id = '||l_so_line_variables.payment_term_id );
2031: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: invoicing_rule_id = '||l_so_line_variables.invoicing_rule_id );
2032: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: agreement_id = '||l_so_line_variables.agreement_id );
2033: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: item_id = '||l_so_line_variables.inventory_item_id );

Line 2030: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: payment_term_id = '||l_so_line_variables.payment_term_id );

2026: -- Bug 4768964 Logic provided by OM
2027:
2028: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2029: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: line_number = '||l_so_line_variables.line_number );
2030: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: payment_term_id = '||l_so_line_variables.payment_term_id );
2031: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: invoicing_rule_id = '||l_so_line_variables.invoicing_rule_id );
2032: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: agreement_id = '||l_so_line_variables.agreement_id );
2033: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: item_id = '||l_so_line_variables.inventory_item_id );
2034: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: org_id = '||l_so_line_variables.org_id );

Line 2031: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: invoicing_rule_id = '||l_so_line_variables.invoicing_rule_id );

2027:
2028: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2029: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: line_number = '||l_so_line_variables.line_number );
2030: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: payment_term_id = '||l_so_line_variables.payment_term_id );
2031: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: invoicing_rule_id = '||l_so_line_variables.invoicing_rule_id );
2032: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: agreement_id = '||l_so_line_variables.agreement_id );
2033: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: item_id = '||l_so_line_variables.inventory_item_id );
2034: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: org_id = '||l_so_line_variables.org_id );
2035: END IF;

Line 2032: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: agreement_id = '||l_so_line_variables.agreement_id );

2028: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2029: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: line_number = '||l_so_line_variables.line_number );
2030: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: payment_term_id = '||l_so_line_variables.payment_term_id );
2031: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: invoicing_rule_id = '||l_so_line_variables.invoicing_rule_id );
2032: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: agreement_id = '||l_so_line_variables.agreement_id );
2033: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: item_id = '||l_so_line_variables.inventory_item_id );
2034: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: org_id = '||l_so_line_variables.org_id );
2035: END IF;
2036:

Line 2033: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: item_id = '||l_so_line_variables.inventory_item_id );

2029: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: line_number = '||l_so_line_variables.line_number );
2030: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: payment_term_id = '||l_so_line_variables.payment_term_id );
2031: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: invoicing_rule_id = '||l_so_line_variables.invoicing_rule_id );
2032: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: agreement_id = '||l_so_line_variables.agreement_id );
2033: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: item_id = '||l_so_line_variables.inventory_item_id );
2034: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: org_id = '||l_so_line_variables.org_id );
2035: END IF;
2036:
2037:

Line 2034: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: org_id = '||l_so_line_variables.org_id );

2030: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: payment_term_id = '||l_so_line_variables.payment_term_id );
2031: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: invoicing_rule_id = '||l_so_line_variables.invoicing_rule_id );
2032: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: agreement_id = '||l_so_line_variables.agreement_id );
2033: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: item_id = '||l_so_line_variables.inventory_item_id );
2034: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: org_id = '||l_so_line_variables.org_id );
2035: END IF;
2036:
2037:
2038: l_line_count := l_line_count+1;

Line 2078: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2074: x_line_sys_var_value_tbl(l_index).org_id := l_so_line_variables.org_id;
2075: ELSIF l_so_line_variables.item_identifier_type <> 'INT' THEN
2076: --map the non-INT items to INT items
2077:
2078: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2079: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: Mapping non-INT item to INT item, Calling OE_Id_To_Value.Ordered_Item ');
2080: END IF;
2081:
2082: -- Map non-INT item to INT item

Line 2079: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: Mapping non-INT item to INT item, Calling OE_Id_To_Value.Ordered_Item ');

2075: ELSIF l_so_line_variables.item_identifier_type <> 'INT' THEN
2076: --map the non-INT items to INT items
2077:
2078: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2079: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: Mapping non-INT item to INT item, Calling OE_Id_To_Value.Ordered_Item ');
2080: END IF;
2081:
2082: -- Map non-INT item to INT item
2083: OE_Id_To_Value.Ordered_Item (

Line 2100: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2096: x_line_sys_var_value_tbl(l_index).variable_value := lx_inventory_item;
2097: x_line_sys_var_value_tbl(l_index).item_id := l_so_line_variables.inventory_item_id;
2098: x_line_sys_var_value_tbl(l_index).org_id := l_so_line_variables.org_id;
2099:
2100: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2101: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: x_line_var_value_tbl('||j||').variable_code: ' || G_ITEM_CODE);
2102: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: x_line_var_value_tbl('||j||').variable_value_id: ' || lx_inventory_item);
2103: END IF;
2104: END IF;

Line 2101: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: x_line_var_value_tbl('||j||').variable_code: ' || G_ITEM_CODE);

2097: x_line_sys_var_value_tbl(l_index).item_id := l_so_line_variables.inventory_item_id;
2098: x_line_sys_var_value_tbl(l_index).org_id := l_so_line_variables.org_id;
2099:
2100: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2101: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: x_line_var_value_tbl('||j||').variable_code: ' || G_ITEM_CODE);
2102: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: x_line_var_value_tbl('||j||').variable_value_id: ' || lx_inventory_item);
2103: END IF;
2104: END IF;
2105:

Line 2102: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: x_line_var_value_tbl('||j||').variable_value_id: ' || lx_inventory_item);

2098: x_line_sys_var_value_tbl(l_index).org_id := l_so_line_variables.org_id;
2099:
2100: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2101: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: x_line_var_value_tbl('||j||').variable_code: ' || G_ITEM_CODE);
2102: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: x_line_var_value_tbl('||j||').variable_value_id: ' || lx_inventory_item);
2103: END IF;
2104: END IF;
2105:
2106: IF l_so_line_variables.inventory_item_id IS NOT NULL THEN

Line 2130: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2126: x_line_sys_var_value_tbl(l_index).item_id := l_so_line_variables.inventory_item_id;
2127: x_line_sys_var_value_tbl(l_index).org_id := l_so_line_variables.org_id;
2128:
2129:
2130: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2131: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'74: x_line_var_value_tbl('||j||').variable_code: '||G_ITEM_CATEGORY_CODE);
2132: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'75: x_line_var_value_tbl('||j||').variable_value_id: '||l_so_derived_item_category);
2133: END IF;
2134: END IF;

Line 2131: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'74: x_line_var_value_tbl('||j||').variable_code: '||G_ITEM_CATEGORY_CODE);

2127: x_line_sys_var_value_tbl(l_index).org_id := l_so_line_variables.org_id;
2128:
2129:
2130: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2131: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'74: x_line_var_value_tbl('||j||').variable_code: '||G_ITEM_CATEGORY_CODE);
2132: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'75: x_line_var_value_tbl('||j||').variable_value_id: '||l_so_derived_item_category);
2133: END IF;
2134: END IF;
2135:

Line 2132: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'75: x_line_var_value_tbl('||j||').variable_value_id: '||l_so_derived_item_category);

2128:
2129:
2130: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2131: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'74: x_line_var_value_tbl('||j||').variable_code: '||G_ITEM_CATEGORY_CODE);
2132: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'75: x_line_var_value_tbl('||j||').variable_value_id: '||l_so_derived_item_category);
2133: END IF;
2134: END IF;
2135:
2136: --AK

Line 2157: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2153: x_line_count := 1; -- Since no Lines, need to set line count to 1 for the CX Java code
2154: x_line_variables_count := 0; -- Since no Lines, need to set line variables count to 0 for the CX Java code
2155: END IF;
2156:
2157: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2158: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: End of '||l_package_procedure||'for line level variables, x_return_status: '|| x_return_status);
2159: END IF;
2160:
2161: EXCEPTION

Line 2158: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: End of '||l_package_procedure||'for line level variables, x_return_status: '|| x_return_status);

2154: x_line_variables_count := 0; -- Since no Lines, need to set line variables count to 0 for the CX Java code
2155: END IF;
2156:
2157: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2158: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: End of '||l_package_procedure||'for line level variables, x_return_status: '|| x_return_status);
2159: END IF;
2160:
2161: EXCEPTION
2162:

Line 2179: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2175: FND_MSG_PUB.Count_And_Get(
2176: p_count => x_msg_count,
2177: p_data => x_msg_data );
2178:
2179: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2180: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: '||l_package_procedure||' In the FND_API.G_EXC_ERROR section');
2181: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: x_return_status = '||x_return_status);
2182: END IF;
2183:

Line 2180: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: '||l_package_procedure||' In the FND_API.G_EXC_ERROR section');

2176: p_count => x_msg_count,
2177: p_data => x_msg_data );
2178:
2179: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2180: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: '||l_package_procedure||' In the FND_API.G_EXC_ERROR section');
2181: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: x_return_status = '||x_return_status);
2182: END IF;
2183:
2184: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2181: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: x_return_status = '||x_return_status);

2177: p_data => x_msg_data );
2178:
2179: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2180: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: '||l_package_procedure||' In the FND_API.G_EXC_ERROR section');
2181: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: x_return_status = '||x_return_status);
2182: END IF;
2183:
2184: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2185: IF c_get_bsa_line_variables%ISOPEN THEN

Line 2199: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2195: FND_MSG_PUB.Count_And_Get(
2196: p_count => x_msg_count,
2197: p_data => x_msg_data );
2198:
2199: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2200: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: '||l_package_procedure||' In the FND_API.G_EXC_UNEXPECTED_ERROR section');
2201: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: x_return_status = '||x_return_status);
2202: END IF;
2203:

Line 2200: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: '||l_package_procedure||' In the FND_API.G_EXC_UNEXPECTED_ERROR section');

2196: p_count => x_msg_count,
2197: p_data => x_msg_data );
2198:
2199: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2200: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: '||l_package_procedure||' In the FND_API.G_EXC_UNEXPECTED_ERROR section');
2201: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: x_return_status = '||x_return_status);
2202: END IF;
2203:
2204: WHEN OTHERS THEN

Line 2201: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: x_return_status = '||x_return_status);

2197: p_data => x_msg_data );
2198:
2199: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2200: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: '||l_package_procedure||' In the FND_API.G_EXC_UNEXPECTED_ERROR section');
2201: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: x_return_status = '||x_return_status);
2202: END IF;
2203:
2204: WHEN OTHERS THEN
2205: IF c_get_bsa_line_variables%ISOPEN THEN

Line 2225: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2221: FND_MSG_PUB.Count_And_Get(
2222: p_count => x_msg_count,
2223: p_data => x_msg_data );
2224:
2225: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2226: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: '||l_package_procedure||' In the OTHERS section');
2227: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: x_return_status = '||x_return_status);
2228: END IF;
2229:

Line 2226: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: '||l_package_procedure||' In the OTHERS section');

2222: p_count => x_msg_count,
2223: p_data => x_msg_data );
2224:
2225: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2226: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: '||l_package_procedure||' In the OTHERS section');
2227: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: x_return_status = '||x_return_status);
2228: END IF;
2229:
2230: END get_line_variable_values;

Line 2227: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: x_return_status = '||x_return_status);

2223: p_data => x_msg_data );
2224:
2225: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2226: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: '||l_package_procedure||' In the OTHERS section');
2227: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: x_return_status = '||x_return_status);
2228: END IF;
2229:
2230: END get_line_variable_values;
2231: