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 302: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

298:
299:
300: BEGIN
301:
302: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
303: l_debug := true;
304: END IF;
305:
306: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

306: x_return_status := FND_API.G_RET_STS_SUCCESS;
307:
308: l_package_procedure := G_PKG_NAME || '.' || l_api_name;
309:
310: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
311: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'10: Entered ' || l_package_procedure);
312: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'20: p_doc_type: ' || p_doc_type);
313: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'30: p_doc_id: ' || p_doc_id);
314: END IF;

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

307:
308: l_package_procedure := G_PKG_NAME || '.' || l_api_name;
309:
310: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
311: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'10: Entered ' || l_package_procedure);
312: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'20: p_doc_type: ' || p_doc_type);
313: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'30: p_doc_id: ' || p_doc_id);
314: END IF;
315:

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

308: l_package_procedure := G_PKG_NAME || '.' || l_api_name;
309:
310: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
311: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'10: Entered ' || l_package_procedure);
312: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'20: p_doc_type: ' || p_doc_type);
313: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'30: p_doc_id: ' || p_doc_id);
314: END IF;
315:
316: --

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

309:
310: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
311: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'10: Entered ' || l_package_procedure);
312: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'20: p_doc_type: ' || p_doc_type);
313: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'30: p_doc_id: ' || p_doc_id);
314: END IF;
315:
316: --
317: -- Standard call to check for call compatibility.

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

347: IF p_doc_type = G_BSA_DOC_TYPE THEN
348:
349: OPEN c_get_bsa_header_variables;
350: FETCH c_get_bsa_header_variables INTO l_bsa_header_variables;
351: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
352: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40: c_get_bsa_header_variables%ROWCOUNT: ' || c_get_bsa_header_variables%ROWCOUNT);
353: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: Values from l_bsa_header_variables: ');
354: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'55: ************************************');
355: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: Agreement_id = '||l_bsa_header_variables.agreement_id);

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

348:
349: OPEN c_get_bsa_header_variables;
350: FETCH c_get_bsa_header_variables INTO l_bsa_header_variables;
351: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
352: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40: c_get_bsa_header_variables%ROWCOUNT: ' || c_get_bsa_header_variables%ROWCOUNT);
353: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: Values from l_bsa_header_variables: ');
354: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'55: ************************************');
355: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: Agreement_id = '||l_bsa_header_variables.agreement_id);
356: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: price_agr_exist = '||l_bsa_header_variables.price_agr_exist );

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

349: OPEN c_get_bsa_header_variables;
350: FETCH c_get_bsa_header_variables INTO l_bsa_header_variables;
351: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
352: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40: c_get_bsa_header_variables%ROWCOUNT: ' || c_get_bsa_header_variables%ROWCOUNT);
353: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: Values from l_bsa_header_variables: ');
354: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'55: ************************************');
355: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: Agreement_id = '||l_bsa_header_variables.agreement_id);
356: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: price_agr_exist = '||l_bsa_header_variables.price_agr_exist );
357: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: sold_to_org_id = '||l_bsa_header_variables.sold_to_org_id );

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

350: FETCH c_get_bsa_header_variables INTO l_bsa_header_variables;
351: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
352: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40: c_get_bsa_header_variables%ROWCOUNT: ' || c_get_bsa_header_variables%ROWCOUNT);
353: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: Values from l_bsa_header_variables: ');
354: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'55: ************************************');
355: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: Agreement_id = '||l_bsa_header_variables.agreement_id);
356: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: price_agr_exist = '||l_bsa_header_variables.price_agr_exist );
357: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: sold_to_org_id = '||l_bsa_header_variables.sold_to_org_id );
358: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: invoice_to_org_id = '||l_bsa_header_variables.invoice_to_org_id );

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

351: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
352: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40: c_get_bsa_header_variables%ROWCOUNT: ' || c_get_bsa_header_variables%ROWCOUNT);
353: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: Values from l_bsa_header_variables: ');
354: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'55: ************************************');
355: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: Agreement_id = '||l_bsa_header_variables.agreement_id);
356: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: price_agr_exist = '||l_bsa_header_variables.price_agr_exist );
357: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: sold_to_org_id = '||l_bsa_header_variables.sold_to_org_id );
358: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: invoice_to_org_id = '||l_bsa_header_variables.invoice_to_org_id );
359: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: ship_to_org_id = '||l_bsa_header_variables.ship_to_org_id );

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

352: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40: c_get_bsa_header_variables%ROWCOUNT: ' || c_get_bsa_header_variables%ROWCOUNT);
353: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: Values from l_bsa_header_variables: ');
354: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'55: ************************************');
355: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: Agreement_id = '||l_bsa_header_variables.agreement_id);
356: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: price_agr_exist = '||l_bsa_header_variables.price_agr_exist );
357: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: sold_to_org_id = '||l_bsa_header_variables.sold_to_org_id );
358: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: invoice_to_org_id = '||l_bsa_header_variables.invoice_to_org_id );
359: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: ship_to_org_id = '||l_bsa_header_variables.ship_to_org_id );
360: 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 357: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: sold_to_org_id = '||l_bsa_header_variables.sold_to_org_id );

353: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: Values from l_bsa_header_variables: ');
354: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'55: ************************************');
355: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: Agreement_id = '||l_bsa_header_variables.agreement_id);
356: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: price_agr_exist = '||l_bsa_header_variables.price_agr_exist );
357: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: sold_to_org_id = '||l_bsa_header_variables.sold_to_org_id );
358: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: invoice_to_org_id = '||l_bsa_header_variables.invoice_to_org_id );
359: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: ship_to_org_id = '||l_bsa_header_variables.ship_to_org_id );
360: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: sold_to_site_use_id = '||l_bsa_header_variables.sold_to_site_use_id );
361: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: order_type_id = '||l_bsa_header_variables.order_type_id );

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

354: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'55: ************************************');
355: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: Agreement_id = '||l_bsa_header_variables.agreement_id);
356: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: price_agr_exist = '||l_bsa_header_variables.price_agr_exist );
357: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: sold_to_org_id = '||l_bsa_header_variables.sold_to_org_id );
358: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: invoice_to_org_id = '||l_bsa_header_variables.invoice_to_org_id );
359: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: ship_to_org_id = '||l_bsa_header_variables.ship_to_org_id );
360: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: sold_to_site_use_id = '||l_bsa_header_variables.sold_to_site_use_id );
361: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: order_type_id = '||l_bsa_header_variables.order_type_id );
362: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: cust_po_num_exist = '||l_bsa_header_variables.cust_po_num_exist );

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

355: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: Agreement_id = '||l_bsa_header_variables.agreement_id);
356: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: price_agr_exist = '||l_bsa_header_variables.price_agr_exist );
357: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: sold_to_org_id = '||l_bsa_header_variables.sold_to_org_id );
358: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: invoice_to_org_id = '||l_bsa_header_variables.invoice_to_org_id );
359: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: ship_to_org_id = '||l_bsa_header_variables.ship_to_org_id );
360: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: sold_to_site_use_id = '||l_bsa_header_variables.sold_to_site_use_id );
361: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: order_type_id = '||l_bsa_header_variables.order_type_id );
362: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: cust_po_num_exist = '||l_bsa_header_variables.cust_po_num_exist );
363: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'140: transactional_curr_code = '||l_bsa_header_variables.transactional_curr_code );

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

356: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: price_agr_exist = '||l_bsa_header_variables.price_agr_exist );
357: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: sold_to_org_id = '||l_bsa_header_variables.sold_to_org_id );
358: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: invoice_to_org_id = '||l_bsa_header_variables.invoice_to_org_id );
359: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: ship_to_org_id = '||l_bsa_header_variables.ship_to_org_id );
360: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: sold_to_site_use_id = '||l_bsa_header_variables.sold_to_site_use_id );
361: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: order_type_id = '||l_bsa_header_variables.order_type_id );
362: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: cust_po_num_exist = '||l_bsa_header_variables.cust_po_num_exist );
363: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'140: transactional_curr_code = '||l_bsa_header_variables.transactional_curr_code );
364: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: freight_terms_code = '||l_bsa_header_variables.freight_terms_code );

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

357: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: sold_to_org_id = '||l_bsa_header_variables.sold_to_org_id );
358: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: invoice_to_org_id = '||l_bsa_header_variables.invoice_to_org_id );
359: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: ship_to_org_id = '||l_bsa_header_variables.ship_to_org_id );
360: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: sold_to_site_use_id = '||l_bsa_header_variables.sold_to_site_use_id );
361: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: order_type_id = '||l_bsa_header_variables.order_type_id );
362: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: cust_po_num_exist = '||l_bsa_header_variables.cust_po_num_exist );
363: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'140: transactional_curr_code = '||l_bsa_header_variables.transactional_curr_code );
364: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: freight_terms_code = '||l_bsa_header_variables.freight_terms_code );
365: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: shipping_method_code = '||l_bsa_header_variables.shipping_method_code );

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

358: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: invoice_to_org_id = '||l_bsa_header_variables.invoice_to_org_id );
359: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: ship_to_org_id = '||l_bsa_header_variables.ship_to_org_id );
360: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: sold_to_site_use_id = '||l_bsa_header_variables.sold_to_site_use_id );
361: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: order_type_id = '||l_bsa_header_variables.order_type_id );
362: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: cust_po_num_exist = '||l_bsa_header_variables.cust_po_num_exist );
363: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'140: transactional_curr_code = '||l_bsa_header_variables.transactional_curr_code );
364: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: freight_terms_code = '||l_bsa_header_variables.freight_terms_code );
365: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: shipping_method_code = '||l_bsa_header_variables.shipping_method_code );
366: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: payment_term_id = '||l_bsa_header_variables.payment_term_id );

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

359: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: ship_to_org_id = '||l_bsa_header_variables.ship_to_org_id );
360: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: sold_to_site_use_id = '||l_bsa_header_variables.sold_to_site_use_id );
361: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: order_type_id = '||l_bsa_header_variables.order_type_id );
362: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: cust_po_num_exist = '||l_bsa_header_variables.cust_po_num_exist );
363: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'140: transactional_curr_code = '||l_bsa_header_variables.transactional_curr_code );
364: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: freight_terms_code = '||l_bsa_header_variables.freight_terms_code );
365: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: shipping_method_code = '||l_bsa_header_variables.shipping_method_code );
366: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: payment_term_id = '||l_bsa_header_variables.payment_term_id );
367: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: invoicing_rule_id = '||l_bsa_header_variables.invoicing_rule_id );

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

360: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: sold_to_site_use_id = '||l_bsa_header_variables.sold_to_site_use_id );
361: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: order_type_id = '||l_bsa_header_variables.order_type_id );
362: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: cust_po_num_exist = '||l_bsa_header_variables.cust_po_num_exist );
363: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'140: transactional_curr_code = '||l_bsa_header_variables.transactional_curr_code );
364: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: freight_terms_code = '||l_bsa_header_variables.freight_terms_code );
365: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: shipping_method_code = '||l_bsa_header_variables.shipping_method_code );
366: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: payment_term_id = '||l_bsa_header_variables.payment_term_id );
367: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: invoicing_rule_id = '||l_bsa_header_variables.invoicing_rule_id );
368: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: tax_exempt_flag = '||l_bsa_header_variables.tax_exempt_flag );

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

361: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: order_type_id = '||l_bsa_header_variables.order_type_id );
362: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: cust_po_num_exist = '||l_bsa_header_variables.cust_po_num_exist );
363: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'140: transactional_curr_code = '||l_bsa_header_variables.transactional_curr_code );
364: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: freight_terms_code = '||l_bsa_header_variables.freight_terms_code );
365: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: shipping_method_code = '||l_bsa_header_variables.shipping_method_code );
366: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: payment_term_id = '||l_bsa_header_variables.payment_term_id );
367: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: invoicing_rule_id = '||l_bsa_header_variables.invoicing_rule_id );
368: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: tax_exempt_flag = '||l_bsa_header_variables.tax_exempt_flag );
369: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: price_list_id = '||l_bsa_header_variables.price_list_id );

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

362: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: cust_po_num_exist = '||l_bsa_header_variables.cust_po_num_exist );
363: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'140: transactional_curr_code = '||l_bsa_header_variables.transactional_curr_code );
364: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: freight_terms_code = '||l_bsa_header_variables.freight_terms_code );
365: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: shipping_method_code = '||l_bsa_header_variables.shipping_method_code );
366: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: payment_term_id = '||l_bsa_header_variables.payment_term_id );
367: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: invoicing_rule_id = '||l_bsa_header_variables.invoicing_rule_id );
368: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: tax_exempt_flag = '||l_bsa_header_variables.tax_exempt_flag );
369: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: price_list_id = '||l_bsa_header_variables.price_list_id );
370: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: org_id = '||l_bsa_header_variables.org_id );

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

363: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'140: transactional_curr_code = '||l_bsa_header_variables.transactional_curr_code );
364: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: freight_terms_code = '||l_bsa_header_variables.freight_terms_code );
365: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: shipping_method_code = '||l_bsa_header_variables.shipping_method_code );
366: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: payment_term_id = '||l_bsa_header_variables.payment_term_id );
367: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: invoicing_rule_id = '||l_bsa_header_variables.invoicing_rule_id );
368: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: tax_exempt_flag = '||l_bsa_header_variables.tax_exempt_flag );
369: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: price_list_id = '||l_bsa_header_variables.price_list_id );
370: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: org_id = '||l_bsa_header_variables.org_id );
371: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: blanket_min_amount = '||l_bsa_header_variables.blanket_min_amount );

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

364: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: freight_terms_code = '||l_bsa_header_variables.freight_terms_code );
365: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: shipping_method_code = '||l_bsa_header_variables.shipping_method_code );
366: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: payment_term_id = '||l_bsa_header_variables.payment_term_id );
367: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: invoicing_rule_id = '||l_bsa_header_variables.invoicing_rule_id );
368: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: tax_exempt_flag = '||l_bsa_header_variables.tax_exempt_flag );
369: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: price_list_id = '||l_bsa_header_variables.price_list_id );
370: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: org_id = '||l_bsa_header_variables.org_id );
371: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: blanket_min_amount = '||l_bsa_header_variables.blanket_min_amount );
372: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: blanket_max_amount = '||l_bsa_header_variables.blanket_max_amount );

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

365: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: shipping_method_code = '||l_bsa_header_variables.shipping_method_code );
366: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: payment_term_id = '||l_bsa_header_variables.payment_term_id );
367: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: invoicing_rule_id = '||l_bsa_header_variables.invoicing_rule_id );
368: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: tax_exempt_flag = '||l_bsa_header_variables.tax_exempt_flag );
369: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: price_list_id = '||l_bsa_header_variables.price_list_id );
370: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: org_id = '||l_bsa_header_variables.org_id );
371: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: blanket_min_amount = '||l_bsa_header_variables.blanket_min_amount );
372: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: blanket_max_amount = '||l_bsa_header_variables.blanket_max_amount );
373: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'240: order_number = '||l_bsa_header_variables.order_number );

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

366: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: payment_term_id = '||l_bsa_header_variables.payment_term_id );
367: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: invoicing_rule_id = '||l_bsa_header_variables.invoicing_rule_id );
368: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: tax_exempt_flag = '||l_bsa_header_variables.tax_exempt_flag );
369: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: price_list_id = '||l_bsa_header_variables.price_list_id );
370: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: org_id = '||l_bsa_header_variables.org_id );
371: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: blanket_min_amount = '||l_bsa_header_variables.blanket_min_amount );
372: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: blanket_max_amount = '||l_bsa_header_variables.blanket_max_amount );
373: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'240: order_number = '||l_bsa_header_variables.order_number );
374: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'250: cust_po_number = '||l_bsa_header_variables.cust_po_number );

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

367: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: invoicing_rule_id = '||l_bsa_header_variables.invoicing_rule_id );
368: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: tax_exempt_flag = '||l_bsa_header_variables.tax_exempt_flag );
369: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: price_list_id = '||l_bsa_header_variables.price_list_id );
370: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: org_id = '||l_bsa_header_variables.org_id );
371: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: blanket_min_amount = '||l_bsa_header_variables.blanket_min_amount );
372: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: blanket_max_amount = '||l_bsa_header_variables.blanket_max_amount );
373: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'240: order_number = '||l_bsa_header_variables.order_number );
374: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'250: cust_po_number = '||l_bsa_header_variables.cust_po_number );
375: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'260: version_number = '||l_bsa_header_variables.version_number );

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

368: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: tax_exempt_flag = '||l_bsa_header_variables.tax_exempt_flag );
369: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: price_list_id = '||l_bsa_header_variables.price_list_id );
370: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: org_id = '||l_bsa_header_variables.org_id );
371: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: blanket_min_amount = '||l_bsa_header_variables.blanket_min_amount );
372: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: blanket_max_amount = '||l_bsa_header_variables.blanket_max_amount );
373: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'240: order_number = '||l_bsa_header_variables.order_number );
374: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'250: cust_po_number = '||l_bsa_header_variables.cust_po_number );
375: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'260: version_number = '||l_bsa_header_variables.version_number );
376: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'270: sold_to_contact_id = '||l_bsa_header_variables.sold_to_contact_id );

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

369: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: price_list_id = '||l_bsa_header_variables.price_list_id );
370: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: org_id = '||l_bsa_header_variables.org_id );
371: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: blanket_min_amount = '||l_bsa_header_variables.blanket_min_amount );
372: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: blanket_max_amount = '||l_bsa_header_variables.blanket_max_amount );
373: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'240: order_number = '||l_bsa_header_variables.order_number );
374: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'250: cust_po_number = '||l_bsa_header_variables.cust_po_number );
375: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'260: version_number = '||l_bsa_header_variables.version_number );
376: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'270: sold_to_contact_id = '||l_bsa_header_variables.sold_to_contact_id );
377: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'280: salesrep_id = '||l_bsa_header_variables.salesrep_id );

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

370: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: org_id = '||l_bsa_header_variables.org_id );
371: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: blanket_min_amount = '||l_bsa_header_variables.blanket_min_amount );
372: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: blanket_max_amount = '||l_bsa_header_variables.blanket_max_amount );
373: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'240: order_number = '||l_bsa_header_variables.order_number );
374: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'250: cust_po_number = '||l_bsa_header_variables.cust_po_number );
375: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'260: version_number = '||l_bsa_header_variables.version_number );
376: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'270: sold_to_contact_id = '||l_bsa_header_variables.sold_to_contact_id );
377: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'280: salesrep_id = '||l_bsa_header_variables.salesrep_id );
378: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'290: start_date_active = '||l_bsa_header_variables.start_date_active );

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

371: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: blanket_min_amount = '||l_bsa_header_variables.blanket_min_amount );
372: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: blanket_max_amount = '||l_bsa_header_variables.blanket_max_amount );
373: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'240: order_number = '||l_bsa_header_variables.order_number );
374: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'250: cust_po_number = '||l_bsa_header_variables.cust_po_number );
375: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'260: version_number = '||l_bsa_header_variables.version_number );
376: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'270: sold_to_contact_id = '||l_bsa_header_variables.sold_to_contact_id );
377: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'280: salesrep_id = '||l_bsa_header_variables.salesrep_id );
378: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'290: start_date_active = '||l_bsa_header_variables.start_date_active );
379: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'300: end_date_active = '||l_bsa_header_variables.end_date_active );

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

372: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: blanket_max_amount = '||l_bsa_header_variables.blanket_max_amount );
373: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'240: order_number = '||l_bsa_header_variables.order_number );
374: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'250: cust_po_number = '||l_bsa_header_variables.cust_po_number );
375: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'260: version_number = '||l_bsa_header_variables.version_number );
376: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'270: sold_to_contact_id = '||l_bsa_header_variables.sold_to_contact_id );
377: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'280: salesrep_id = '||l_bsa_header_variables.salesrep_id );
378: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'290: start_date_active = '||l_bsa_header_variables.start_date_active );
379: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'300: end_date_active = '||l_bsa_header_variables.end_date_active );
380: END IF;

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

373: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'240: order_number = '||l_bsa_header_variables.order_number );
374: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'250: cust_po_number = '||l_bsa_header_variables.cust_po_number );
375: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'260: version_number = '||l_bsa_header_variables.version_number );
376: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'270: sold_to_contact_id = '||l_bsa_header_variables.sold_to_contact_id );
377: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'280: salesrep_id = '||l_bsa_header_variables.salesrep_id );
378: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'290: start_date_active = '||l_bsa_header_variables.start_date_active );
379: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'300: end_date_active = '||l_bsa_header_variables.end_date_active );
380: END IF;
381: CLOSE c_get_bsa_header_variables;

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

374: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'250: cust_po_number = '||l_bsa_header_variables.cust_po_number );
375: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'260: version_number = '||l_bsa_header_variables.version_number );
376: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'270: sold_to_contact_id = '||l_bsa_header_variables.sold_to_contact_id );
377: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'280: salesrep_id = '||l_bsa_header_variables.salesrep_id );
378: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'290: start_date_active = '||l_bsa_header_variables.start_date_active );
379: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'300: end_date_active = '||l_bsa_header_variables.end_date_active );
380: END IF;
381: CLOSE c_get_bsa_header_variables;
382:

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

375: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'260: version_number = '||l_bsa_header_variables.version_number );
376: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'270: sold_to_contact_id = '||l_bsa_header_variables.sold_to_contact_id );
377: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'280: salesrep_id = '||l_bsa_header_variables.salesrep_id );
378: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'290: start_date_active = '||l_bsa_header_variables.start_date_active );
379: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'300: end_date_active = '||l_bsa_header_variables.end_date_active );
380: END IF;
381: CLOSE c_get_bsa_header_variables;
382:
383: ELSIF p_doc_type = G_SO_DOC_TYPE THEN

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

383: ELSIF p_doc_type = G_SO_DOC_TYPE THEN
384:
385: OPEN c_get_so_header_variables;
386: FETCH c_get_so_header_variables INTO l_so_header_variables;
387: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
388: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40: c_get_so_header_variables%ROWCOUNT: ' || c_get_so_header_variables%ROWCOUNT);
389: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: Values from l_so_header_variables: ');
390: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'55: ************************************');
391: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: blanket_number = '||l_so_header_variables.blanket_number );

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

384:
385: OPEN c_get_so_header_variables;
386: FETCH c_get_so_header_variables INTO l_so_header_variables;
387: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
388: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40: c_get_so_header_variables%ROWCOUNT: ' || c_get_so_header_variables%ROWCOUNT);
389: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: Values from l_so_header_variables: ');
390: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'55: ************************************');
391: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: blanket_number = '||l_so_header_variables.blanket_number );
392: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: blanket_number_exist = '||l_so_header_variables.blanket_number_exist );

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

385: OPEN c_get_so_header_variables;
386: FETCH c_get_so_header_variables INTO l_so_header_variables;
387: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
388: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40: c_get_so_header_variables%ROWCOUNT: ' || c_get_so_header_variables%ROWCOUNT);
389: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: Values from l_so_header_variables: ');
390: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'55: ************************************');
391: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: blanket_number = '||l_so_header_variables.blanket_number );
392: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: blanket_number_exist = '||l_so_header_variables.blanket_number_exist );
393: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: agreement_id = '||l_so_header_variables.agreement_id );

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

386: FETCH c_get_so_header_variables INTO l_so_header_variables;
387: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
388: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40: c_get_so_header_variables%ROWCOUNT: ' || c_get_so_header_variables%ROWCOUNT);
389: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: Values from l_so_header_variables: ');
390: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'55: ************************************');
391: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: blanket_number = '||l_so_header_variables.blanket_number );
392: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: blanket_number_exist = '||l_so_header_variables.blanket_number_exist );
393: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: agreement_id = '||l_so_header_variables.agreement_id );
394: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: price_agr_exist = '||l_so_header_variables.price_agr_exist );

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

387: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
388: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40: c_get_so_header_variables%ROWCOUNT: ' || c_get_so_header_variables%ROWCOUNT);
389: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: Values from l_so_header_variables: ');
390: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'55: ************************************');
391: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: blanket_number = '||l_so_header_variables.blanket_number );
392: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: blanket_number_exist = '||l_so_header_variables.blanket_number_exist );
393: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: agreement_id = '||l_so_header_variables.agreement_id );
394: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: price_agr_exist = '||l_so_header_variables.price_agr_exist );
395: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: sold_to_org_id = '||l_so_header_variables.sold_to_org_id );

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

388: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40: c_get_so_header_variables%ROWCOUNT: ' || c_get_so_header_variables%ROWCOUNT);
389: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: Values from l_so_header_variables: ');
390: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'55: ************************************');
391: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: blanket_number = '||l_so_header_variables.blanket_number );
392: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: blanket_number_exist = '||l_so_header_variables.blanket_number_exist );
393: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: agreement_id = '||l_so_header_variables.agreement_id );
394: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: price_agr_exist = '||l_so_header_variables.price_agr_exist );
395: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: sold_to_org_id = '||l_so_header_variables.sold_to_org_id );
396: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: invoice_to_org_id = '||l_so_header_variables.invoice_to_org_id );

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

389: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: Values from l_so_header_variables: ');
390: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'55: ************************************');
391: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: blanket_number = '||l_so_header_variables.blanket_number );
392: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: blanket_number_exist = '||l_so_header_variables.blanket_number_exist );
393: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: agreement_id = '||l_so_header_variables.agreement_id );
394: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: price_agr_exist = '||l_so_header_variables.price_agr_exist );
395: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: sold_to_org_id = '||l_so_header_variables.sold_to_org_id );
396: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: invoice_to_org_id = '||l_so_header_variables.invoice_to_org_id );
397: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: ship_to_org_id = '||l_so_header_variables.ship_to_org_id );

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

390: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'55: ************************************');
391: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: blanket_number = '||l_so_header_variables.blanket_number );
392: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: blanket_number_exist = '||l_so_header_variables.blanket_number_exist );
393: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: agreement_id = '||l_so_header_variables.agreement_id );
394: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: price_agr_exist = '||l_so_header_variables.price_agr_exist );
395: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: sold_to_org_id = '||l_so_header_variables.sold_to_org_id );
396: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: invoice_to_org_id = '||l_so_header_variables.invoice_to_org_id );
397: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: ship_to_org_id = '||l_so_header_variables.ship_to_org_id );
398: 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 395: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: sold_to_org_id = '||l_so_header_variables.sold_to_org_id );

391: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: blanket_number = '||l_so_header_variables.blanket_number );
392: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: blanket_number_exist = '||l_so_header_variables.blanket_number_exist );
393: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: agreement_id = '||l_so_header_variables.agreement_id );
394: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: price_agr_exist = '||l_so_header_variables.price_agr_exist );
395: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: sold_to_org_id = '||l_so_header_variables.sold_to_org_id );
396: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: invoice_to_org_id = '||l_so_header_variables.invoice_to_org_id );
397: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: ship_to_org_id = '||l_so_header_variables.ship_to_org_id );
398: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: sold_to_site_use_id = '||l_so_header_variables.sold_to_site_use_id );
399: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'140: cust_po_num_exist = '||l_so_header_variables.cust_po_num_exist );

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

392: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: blanket_number_exist = '||l_so_header_variables.blanket_number_exist );
393: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: agreement_id = '||l_so_header_variables.agreement_id );
394: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: price_agr_exist = '||l_so_header_variables.price_agr_exist );
395: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: sold_to_org_id = '||l_so_header_variables.sold_to_org_id );
396: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: invoice_to_org_id = '||l_so_header_variables.invoice_to_org_id );
397: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: ship_to_org_id = '||l_so_header_variables.ship_to_org_id );
398: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: sold_to_site_use_id = '||l_so_header_variables.sold_to_site_use_id );
399: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'140: cust_po_num_exist = '||l_so_header_variables.cust_po_num_exist );
400: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: transactional_curr_code = '||l_so_header_variables.transactional_curr_code );

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

393: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: agreement_id = '||l_so_header_variables.agreement_id );
394: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: price_agr_exist = '||l_so_header_variables.price_agr_exist );
395: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: sold_to_org_id = '||l_so_header_variables.sold_to_org_id );
396: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: invoice_to_org_id = '||l_so_header_variables.invoice_to_org_id );
397: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: ship_to_org_id = '||l_so_header_variables.ship_to_org_id );
398: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: sold_to_site_use_id = '||l_so_header_variables.sold_to_site_use_id );
399: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'140: cust_po_num_exist = '||l_so_header_variables.cust_po_num_exist );
400: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: transactional_curr_code = '||l_so_header_variables.transactional_curr_code );
401: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: freight_terms_code = '||l_so_header_variables.freight_terms_code );

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

394: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: price_agr_exist = '||l_so_header_variables.price_agr_exist );
395: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: sold_to_org_id = '||l_so_header_variables.sold_to_org_id );
396: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: invoice_to_org_id = '||l_so_header_variables.invoice_to_org_id );
397: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: ship_to_org_id = '||l_so_header_variables.ship_to_org_id );
398: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: sold_to_site_use_id = '||l_so_header_variables.sold_to_site_use_id );
399: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'140: cust_po_num_exist = '||l_so_header_variables.cust_po_num_exist );
400: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: transactional_curr_code = '||l_so_header_variables.transactional_curr_code );
401: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: freight_terms_code = '||l_so_header_variables.freight_terms_code );
402: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: shipping_method_code = '||l_so_header_variables.shipping_method_code );

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

395: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: sold_to_org_id = '||l_so_header_variables.sold_to_org_id );
396: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: invoice_to_org_id = '||l_so_header_variables.invoice_to_org_id );
397: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: ship_to_org_id = '||l_so_header_variables.ship_to_org_id );
398: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: sold_to_site_use_id = '||l_so_header_variables.sold_to_site_use_id );
399: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'140: cust_po_num_exist = '||l_so_header_variables.cust_po_num_exist );
400: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: transactional_curr_code = '||l_so_header_variables.transactional_curr_code );
401: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: freight_terms_code = '||l_so_header_variables.freight_terms_code );
402: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: shipping_method_code = '||l_so_header_variables.shipping_method_code );
403: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: payment_term_id = '||l_so_header_variables.payment_term_id );

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

396: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: invoice_to_org_id = '||l_so_header_variables.invoice_to_org_id );
397: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: ship_to_org_id = '||l_so_header_variables.ship_to_org_id );
398: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: sold_to_site_use_id = '||l_so_header_variables.sold_to_site_use_id );
399: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'140: cust_po_num_exist = '||l_so_header_variables.cust_po_num_exist );
400: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: transactional_curr_code = '||l_so_header_variables.transactional_curr_code );
401: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: freight_terms_code = '||l_so_header_variables.freight_terms_code );
402: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: shipping_method_code = '||l_so_header_variables.shipping_method_code );
403: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: payment_term_id = '||l_so_header_variables.payment_term_id );
404: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: invoicing_rule_id = '||l_so_header_variables.invoicing_rule_id );

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

397: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: ship_to_org_id = '||l_so_header_variables.ship_to_org_id );
398: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: sold_to_site_use_id = '||l_so_header_variables.sold_to_site_use_id );
399: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'140: cust_po_num_exist = '||l_so_header_variables.cust_po_num_exist );
400: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: transactional_curr_code = '||l_so_header_variables.transactional_curr_code );
401: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: freight_terms_code = '||l_so_header_variables.freight_terms_code );
402: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: shipping_method_code = '||l_so_header_variables.shipping_method_code );
403: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: payment_term_id = '||l_so_header_variables.payment_term_id );
404: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: invoicing_rule_id = '||l_so_header_variables.invoicing_rule_id );
405: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: org_id = '||l_so_header_variables.org_id );

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

398: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: sold_to_site_use_id = '||l_so_header_variables.sold_to_site_use_id );
399: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'140: cust_po_num_exist = '||l_so_header_variables.cust_po_num_exist );
400: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: transactional_curr_code = '||l_so_header_variables.transactional_curr_code );
401: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: freight_terms_code = '||l_so_header_variables.freight_terms_code );
402: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: shipping_method_code = '||l_so_header_variables.shipping_method_code );
403: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: payment_term_id = '||l_so_header_variables.payment_term_id );
404: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: invoicing_rule_id = '||l_so_header_variables.invoicing_rule_id );
405: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: org_id = '||l_so_header_variables.org_id );
406: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: order_type_id = '||l_so_header_variables.order_type_id );

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

399: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'140: cust_po_num_exist = '||l_so_header_variables.cust_po_num_exist );
400: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: transactional_curr_code = '||l_so_header_variables.transactional_curr_code );
401: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: freight_terms_code = '||l_so_header_variables.freight_terms_code );
402: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: shipping_method_code = '||l_so_header_variables.shipping_method_code );
403: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: payment_term_id = '||l_so_header_variables.payment_term_id );
404: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: invoicing_rule_id = '||l_so_header_variables.invoicing_rule_id );
405: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: org_id = '||l_so_header_variables.org_id );
406: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: order_type_id = '||l_so_header_variables.order_type_id );
407: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: fob_point_code = '||l_so_header_variables.fob_point_code );

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

400: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: transactional_curr_code = '||l_so_header_variables.transactional_curr_code );
401: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: freight_terms_code = '||l_so_header_variables.freight_terms_code );
402: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: shipping_method_code = '||l_so_header_variables.shipping_method_code );
403: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: payment_term_id = '||l_so_header_variables.payment_term_id );
404: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: invoicing_rule_id = '||l_so_header_variables.invoicing_rule_id );
405: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: org_id = '||l_so_header_variables.org_id );
406: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: order_type_id = '||l_so_header_variables.order_type_id );
407: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: fob_point_code = '||l_so_header_variables.fob_point_code );
408: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: payment_type_code = '||l_so_header_variables.payment_type_code );

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

401: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: freight_terms_code = '||l_so_header_variables.freight_terms_code );
402: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: shipping_method_code = '||l_so_header_variables.shipping_method_code );
403: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: payment_term_id = '||l_so_header_variables.payment_term_id );
404: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: invoicing_rule_id = '||l_so_header_variables.invoicing_rule_id );
405: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: org_id = '||l_so_header_variables.org_id );
406: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: order_type_id = '||l_so_header_variables.order_type_id );
407: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: fob_point_code = '||l_so_header_variables.fob_point_code );
408: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: payment_type_code = '||l_so_header_variables.payment_type_code );
409: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'240: end_customer_id = '||l_so_header_variables.end_customer_id );

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

402: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: shipping_method_code = '||l_so_header_variables.shipping_method_code );
403: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: payment_term_id = '||l_so_header_variables.payment_term_id );
404: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: invoicing_rule_id = '||l_so_header_variables.invoicing_rule_id );
405: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: org_id = '||l_so_header_variables.org_id );
406: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: order_type_id = '||l_so_header_variables.order_type_id );
407: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: fob_point_code = '||l_so_header_variables.fob_point_code );
408: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: payment_type_code = '||l_so_header_variables.payment_type_code );
409: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'240: end_customer_id = '||l_so_header_variables.end_customer_id );
410: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'250: end_cust_exist = '||l_so_header_variables.end_cust_exist );

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

403: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: payment_term_id = '||l_so_header_variables.payment_term_id );
404: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: invoicing_rule_id = '||l_so_header_variables.invoicing_rule_id );
405: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: org_id = '||l_so_header_variables.org_id );
406: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: order_type_id = '||l_so_header_variables.order_type_id );
407: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: fob_point_code = '||l_so_header_variables.fob_point_code );
408: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: payment_type_code = '||l_so_header_variables.payment_type_code );
409: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'240: end_customer_id = '||l_so_header_variables.end_customer_id );
410: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'250: end_cust_exist = '||l_so_header_variables.end_cust_exist );
411: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'260: price_list_id = '||l_so_header_variables.price_list_id );

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

404: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: invoicing_rule_id = '||l_so_header_variables.invoicing_rule_id );
405: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: org_id = '||l_so_header_variables.org_id );
406: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: order_type_id = '||l_so_header_variables.order_type_id );
407: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: fob_point_code = '||l_so_header_variables.fob_point_code );
408: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: payment_type_code = '||l_so_header_variables.payment_type_code );
409: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'240: end_customer_id = '||l_so_header_variables.end_customer_id );
410: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'250: end_cust_exist = '||l_so_header_variables.end_cust_exist );
411: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'260: price_list_id = '||l_so_header_variables.price_list_id );
412: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'270: tax_exempt_flag = '||l_so_header_variables.tax_exempt_flag );

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

405: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: org_id = '||l_so_header_variables.org_id );
406: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: order_type_id = '||l_so_header_variables.order_type_id );
407: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: fob_point_code = '||l_so_header_variables.fob_point_code );
408: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: payment_type_code = '||l_so_header_variables.payment_type_code );
409: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'240: end_customer_id = '||l_so_header_variables.end_customer_id );
410: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'250: end_cust_exist = '||l_so_header_variables.end_cust_exist );
411: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'260: price_list_id = '||l_so_header_variables.price_list_id );
412: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'270: tax_exempt_flag = '||l_so_header_variables.tax_exempt_flag );
413: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'280: sales_channel_code = '||l_so_header_variables.sales_channel_code );

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

406: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: order_type_id = '||l_so_header_variables.order_type_id );
407: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: fob_point_code = '||l_so_header_variables.fob_point_code );
408: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: payment_type_code = '||l_so_header_variables.payment_type_code );
409: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'240: end_customer_id = '||l_so_header_variables.end_customer_id );
410: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'250: end_cust_exist = '||l_so_header_variables.end_cust_exist );
411: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'260: price_list_id = '||l_so_header_variables.price_list_id );
412: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'270: tax_exempt_flag = '||l_so_header_variables.tax_exempt_flag );
413: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'280: sales_channel_code = '||l_so_header_variables.sales_channel_code );
414: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'290: total = '||l_so_header_variables.total );

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

407: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: fob_point_code = '||l_so_header_variables.fob_point_code );
408: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: payment_type_code = '||l_so_header_variables.payment_type_code );
409: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'240: end_customer_id = '||l_so_header_variables.end_customer_id );
410: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'250: end_cust_exist = '||l_so_header_variables.end_cust_exist );
411: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'260: price_list_id = '||l_so_header_variables.price_list_id );
412: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'270: tax_exempt_flag = '||l_so_header_variables.tax_exempt_flag );
413: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'280: sales_channel_code = '||l_so_header_variables.sales_channel_code );
414: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'290: total = '||l_so_header_variables.total );
415: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'300: total_adjusted_amount = '||l_so_header_variables.total_adjusted_amount );

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

408: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: payment_type_code = '||l_so_header_variables.payment_type_code );
409: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'240: end_customer_id = '||l_so_header_variables.end_customer_id );
410: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'250: end_cust_exist = '||l_so_header_variables.end_cust_exist );
411: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'260: price_list_id = '||l_so_header_variables.price_list_id );
412: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'270: tax_exempt_flag = '||l_so_header_variables.tax_exempt_flag );
413: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'280: sales_channel_code = '||l_so_header_variables.sales_channel_code );
414: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'290: total = '||l_so_header_variables.total );
415: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'300: total_adjusted_amount = '||l_so_header_variables.total_adjusted_amount );
416: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'310: total_list_price = '||l_so_header_variables.total_list_price );

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

409: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'240: end_customer_id = '||l_so_header_variables.end_customer_id );
410: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'250: end_cust_exist = '||l_so_header_variables.end_cust_exist );
411: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'260: price_list_id = '||l_so_header_variables.price_list_id );
412: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'270: tax_exempt_flag = '||l_so_header_variables.tax_exempt_flag );
413: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'280: sales_channel_code = '||l_so_header_variables.sales_channel_code );
414: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'290: total = '||l_so_header_variables.total );
415: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'300: total_adjusted_amount = '||l_so_header_variables.total_adjusted_amount );
416: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'310: total_list_price = '||l_so_header_variables.total_list_price );
417: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'320: blanket_header_id = '||l_so_header_variables.blanket_header_id );

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

410: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'250: end_cust_exist = '||l_so_header_variables.end_cust_exist );
411: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'260: price_list_id = '||l_so_header_variables.price_list_id );
412: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'270: tax_exempt_flag = '||l_so_header_variables.tax_exempt_flag );
413: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'280: sales_channel_code = '||l_so_header_variables.sales_channel_code );
414: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'290: total = '||l_so_header_variables.total );
415: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'300: total_adjusted_amount = '||l_so_header_variables.total_adjusted_amount );
416: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'310: total_list_price = '||l_so_header_variables.total_list_price );
417: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'320: blanket_header_id = '||l_so_header_variables.blanket_header_id );
418: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'330: order_number = '||l_so_header_variables.order_number );

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

411: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'260: price_list_id = '||l_so_header_variables.price_list_id );
412: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'270: tax_exempt_flag = '||l_so_header_variables.tax_exempt_flag );
413: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'280: sales_channel_code = '||l_so_header_variables.sales_channel_code );
414: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'290: total = '||l_so_header_variables.total );
415: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'300: total_adjusted_amount = '||l_so_header_variables.total_adjusted_amount );
416: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'310: total_list_price = '||l_so_header_variables.total_list_price );
417: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'320: blanket_header_id = '||l_so_header_variables.blanket_header_id );
418: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'330: order_number = '||l_so_header_variables.order_number );
419: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'340: quote_number = '||l_so_header_variables.quote_number );

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

412: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'270: tax_exempt_flag = '||l_so_header_variables.tax_exempt_flag );
413: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'280: sales_channel_code = '||l_so_header_variables.sales_channel_code );
414: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'290: total = '||l_so_header_variables.total );
415: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'300: total_adjusted_amount = '||l_so_header_variables.total_adjusted_amount );
416: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'310: total_list_price = '||l_so_header_variables.total_list_price );
417: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'320: blanket_header_id = '||l_so_header_variables.blanket_header_id );
418: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'330: order_number = '||l_so_header_variables.order_number );
419: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'340: quote_number = '||l_so_header_variables.quote_number );
420: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'350: cust_po_number = '||l_so_header_variables.cust_po_number );

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

413: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'280: sales_channel_code = '||l_so_header_variables.sales_channel_code );
414: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'290: total = '||l_so_header_variables.total );
415: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'300: total_adjusted_amount = '||l_so_header_variables.total_adjusted_amount );
416: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'310: total_list_price = '||l_so_header_variables.total_list_price );
417: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'320: blanket_header_id = '||l_so_header_variables.blanket_header_id );
418: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'330: order_number = '||l_so_header_variables.order_number );
419: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'340: quote_number = '||l_so_header_variables.quote_number );
420: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'350: cust_po_number = '||l_so_header_variables.cust_po_number );
421: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'360: version_number = '||l_so_header_variables.version_number );

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

414: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'290: total = '||l_so_header_variables.total );
415: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'300: total_adjusted_amount = '||l_so_header_variables.total_adjusted_amount );
416: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'310: total_list_price = '||l_so_header_variables.total_list_price );
417: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'320: blanket_header_id = '||l_so_header_variables.blanket_header_id );
418: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'330: order_number = '||l_so_header_variables.order_number );
419: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'340: quote_number = '||l_so_header_variables.quote_number );
420: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'350: cust_po_number = '||l_so_header_variables.cust_po_number );
421: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'360: version_number = '||l_so_header_variables.version_number );
422: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'370: sold_to_contact_id = '||l_so_header_variables.sold_to_contact_id );

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

415: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'300: total_adjusted_amount = '||l_so_header_variables.total_adjusted_amount );
416: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'310: total_list_price = '||l_so_header_variables.total_list_price );
417: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'320: blanket_header_id = '||l_so_header_variables.blanket_header_id );
418: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'330: order_number = '||l_so_header_variables.order_number );
419: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'340: quote_number = '||l_so_header_variables.quote_number );
420: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'350: cust_po_number = '||l_so_header_variables.cust_po_number );
421: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'360: version_number = '||l_so_header_variables.version_number );
422: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'370: sold_to_contact_id = '||l_so_header_variables.sold_to_contact_id );
423: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'380: salesrep_id = '||l_so_header_variables.salesrep_id );

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

416: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'310: total_list_price = '||l_so_header_variables.total_list_price );
417: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'320: blanket_header_id = '||l_so_header_variables.blanket_header_id );
418: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'330: order_number = '||l_so_header_variables.order_number );
419: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'340: quote_number = '||l_so_header_variables.quote_number );
420: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'350: cust_po_number = '||l_so_header_variables.cust_po_number );
421: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'360: version_number = '||l_so_header_variables.version_number );
422: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'370: sold_to_contact_id = '||l_so_header_variables.sold_to_contact_id );
423: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'380: salesrep_id = '||l_so_header_variables.salesrep_id );
424: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'381: shipment_priority_code = '||l_so_header_variables.shipment_priority_code );

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

417: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'320: blanket_header_id = '||l_so_header_variables.blanket_header_id );
418: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'330: order_number = '||l_so_header_variables.order_number );
419: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'340: quote_number = '||l_so_header_variables.quote_number );
420: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'350: cust_po_number = '||l_so_header_variables.cust_po_number );
421: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'360: version_number = '||l_so_header_variables.version_number );
422: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'370: sold_to_contact_id = '||l_so_header_variables.sold_to_contact_id );
423: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'380: salesrep_id = '||l_so_header_variables.salesrep_id );
424: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'381: shipment_priority_code = '||l_so_header_variables.shipment_priority_code );
425: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'382: minisite_id = '||l_so_header_variables.minisite_id );

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

418: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'330: order_number = '||l_so_header_variables.order_number );
419: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'340: quote_number = '||l_so_header_variables.quote_number );
420: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'350: cust_po_number = '||l_so_header_variables.cust_po_number );
421: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'360: version_number = '||l_so_header_variables.version_number );
422: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'370: sold_to_contact_id = '||l_so_header_variables.sold_to_contact_id );
423: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'380: salesrep_id = '||l_so_header_variables.salesrep_id );
424: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'381: shipment_priority_code = '||l_so_header_variables.shipment_priority_code );
425: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'382: minisite_id = '||l_so_header_variables.minisite_id );
426: END IF;

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

419: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'340: quote_number = '||l_so_header_variables.quote_number );
420: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'350: cust_po_number = '||l_so_header_variables.cust_po_number );
421: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'360: version_number = '||l_so_header_variables.version_number );
422: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'370: sold_to_contact_id = '||l_so_header_variables.sold_to_contact_id );
423: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'380: salesrep_id = '||l_so_header_variables.salesrep_id );
424: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'381: shipment_priority_code = '||l_so_header_variables.shipment_priority_code );
425: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'382: minisite_id = '||l_so_header_variables.minisite_id );
426: END IF;
427: CLOSE c_get_so_header_variables;

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

420: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'350: cust_po_number = '||l_so_header_variables.cust_po_number );
421: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'360: version_number = '||l_so_header_variables.version_number );
422: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'370: sold_to_contact_id = '||l_so_header_variables.sold_to_contact_id );
423: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'380: salesrep_id = '||l_so_header_variables.salesrep_id );
424: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'381: shipment_priority_code = '||l_so_header_variables.shipment_priority_code );
425: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'382: minisite_id = '||l_so_header_variables.minisite_id );
426: END IF;
427: CLOSE c_get_so_header_variables;
428:

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

421: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'360: version_number = '||l_so_header_variables.version_number );
422: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'370: sold_to_contact_id = '||l_so_header_variables.sold_to_contact_id );
423: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'380: salesrep_id = '||l_so_header_variables.salesrep_id );
424: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'381: shipment_priority_code = '||l_so_header_variables.shipment_priority_code );
425: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'382: minisite_id = '||l_so_header_variables.minisite_id );
426: END IF;
427: CLOSE c_get_so_header_variables;
428:
429: END IF;

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

439:
440: IF l_sold_to_org_id IS NOT NULL THEN
441: OPEN c_get_cust_info_var(l_sold_to_org_id);
442: FETCH c_get_cust_info_var INTO l_cust_info_variables;
443: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
444: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'330: c_get_cust_info_var%ROWCOUNT: ' || c_get_cust_info_var%ROWCOUNT);
445: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'340: Values from l_cust_info_variables: ');
446: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'350: sold_to_org_id used = '||l_sold_to_org_id );
447: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'360: category_code = '||l_cust_info_variables.category_code );

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

440: IF l_sold_to_org_id IS NOT NULL THEN
441: OPEN c_get_cust_info_var(l_sold_to_org_id);
442: FETCH c_get_cust_info_var INTO l_cust_info_variables;
443: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
444: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'330: c_get_cust_info_var%ROWCOUNT: ' || c_get_cust_info_var%ROWCOUNT);
445: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'340: Values from l_cust_info_variables: ');
446: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'350: sold_to_org_id used = '||l_sold_to_org_id );
447: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'360: category_code = '||l_cust_info_variables.category_code );
448: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'370: customer_class_code = '||l_cust_info_variables.customer_class_code );

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

441: OPEN c_get_cust_info_var(l_sold_to_org_id);
442: FETCH c_get_cust_info_var INTO l_cust_info_variables;
443: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
444: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'330: c_get_cust_info_var%ROWCOUNT: ' || c_get_cust_info_var%ROWCOUNT);
445: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'340: Values from l_cust_info_variables: ');
446: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'350: sold_to_org_id used = '||l_sold_to_org_id );
447: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'360: category_code = '||l_cust_info_variables.category_code );
448: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'370: customer_class_code = '||l_cust_info_variables.customer_class_code );
449: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'380: profile_class_id = '||l_cust_info_variables.profile_class_id );

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

442: FETCH c_get_cust_info_var INTO l_cust_info_variables;
443: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
444: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'330: c_get_cust_info_var%ROWCOUNT: ' || c_get_cust_info_var%ROWCOUNT);
445: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'340: Values from l_cust_info_variables: ');
446: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'350: sold_to_org_id used = '||l_sold_to_org_id );
447: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'360: category_code = '||l_cust_info_variables.category_code );
448: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'370: customer_class_code = '||l_cust_info_variables.customer_class_code );
449: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'380: profile_class_id = '||l_cust_info_variables.profile_class_id );
450: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'390: credit_rating = '||l_cust_info_variables.credit_rating );

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

443: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
444: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'330: c_get_cust_info_var%ROWCOUNT: ' || c_get_cust_info_var%ROWCOUNT);
445: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'340: Values from l_cust_info_variables: ');
446: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'350: sold_to_org_id used = '||l_sold_to_org_id );
447: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'360: category_code = '||l_cust_info_variables.category_code );
448: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'370: customer_class_code = '||l_cust_info_variables.customer_class_code );
449: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'380: profile_class_id = '||l_cust_info_variables.profile_class_id );
450: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'390: credit_rating = '||l_cust_info_variables.credit_rating );
451: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'400: credit_classification = '||l_cust_info_variables.credit_classification );

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

444: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'330: c_get_cust_info_var%ROWCOUNT: ' || c_get_cust_info_var%ROWCOUNT);
445: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'340: Values from l_cust_info_variables: ');
446: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'350: sold_to_org_id used = '||l_sold_to_org_id );
447: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'360: category_code = '||l_cust_info_variables.category_code );
448: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'370: customer_class_code = '||l_cust_info_variables.customer_class_code );
449: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'380: profile_class_id = '||l_cust_info_variables.profile_class_id );
450: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'390: credit_rating = '||l_cust_info_variables.credit_rating );
451: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'400: credit_classification = '||l_cust_info_variables.credit_classification );
452: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'410: risk_code = '||l_cust_info_variables.risk_code );

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

445: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'340: Values from l_cust_info_variables: ');
446: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'350: sold_to_org_id used = '||l_sold_to_org_id );
447: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'360: category_code = '||l_cust_info_variables.category_code );
448: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'370: customer_class_code = '||l_cust_info_variables.customer_class_code );
449: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'380: profile_class_id = '||l_cust_info_variables.profile_class_id );
450: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'390: credit_rating = '||l_cust_info_variables.credit_rating );
451: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'400: credit_classification = '||l_cust_info_variables.credit_classification );
452: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'410: risk_code = '||l_cust_info_variables.risk_code );
453: END IF;

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

446: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'350: sold_to_org_id used = '||l_sold_to_org_id );
447: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'360: category_code = '||l_cust_info_variables.category_code );
448: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'370: customer_class_code = '||l_cust_info_variables.customer_class_code );
449: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'380: profile_class_id = '||l_cust_info_variables.profile_class_id );
450: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'390: credit_rating = '||l_cust_info_variables.credit_rating );
451: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'400: credit_classification = '||l_cust_info_variables.credit_classification );
452: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'410: risk_code = '||l_cust_info_variables.risk_code );
453: END IF;
454: CLOSE c_get_cust_info_var;

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

447: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'360: category_code = '||l_cust_info_variables.category_code );
448: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'370: customer_class_code = '||l_cust_info_variables.customer_class_code );
449: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'380: profile_class_id = '||l_cust_info_variables.profile_class_id );
450: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'390: credit_rating = '||l_cust_info_variables.credit_rating );
451: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'400: credit_classification = '||l_cust_info_variables.credit_classification );
452: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'410: risk_code = '||l_cust_info_variables.risk_code );
453: END IF;
454: CLOSE c_get_cust_info_var;
455: END IF;

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

448: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'370: customer_class_code = '||l_cust_info_variables.customer_class_code );
449: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'380: profile_class_id = '||l_cust_info_variables.profile_class_id );
450: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'390: credit_rating = '||l_cust_info_variables.credit_rating );
451: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'400: credit_classification = '||l_cust_info_variables.credit_classification );
452: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'410: risk_code = '||l_cust_info_variables.risk_code );
453: END IF;
454: CLOSE c_get_cust_info_var;
455: END IF;
456:

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

503: IF l_sold_to_site_use_id IS NOT NULL THEN
504: OPEN c_get_country(l_sold_to_site_use_id);
505: FETCH c_get_country INTO p_sys_var_value_tbl(i).variable_value_id;
506: CLOSE c_get_country;
507: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
508: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'430: Sold to country = '||p_sys_var_value_tbl(i).variable_value_id);
509: END IF;
510: END IF;
511: END;

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

504: OPEN c_get_country(l_sold_to_site_use_id);
505: FETCH c_get_country INTO p_sys_var_value_tbl(i).variable_value_id;
506: CLOSE c_get_country;
507: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
508: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'430: Sold to country = '||p_sys_var_value_tbl(i).variable_value_id);
509: END IF;
510: END IF;
511: END;
512:

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

515: IF l_ship_to_site_use_id IS NOT NULL THEN
516: OPEN c_get_country(l_ship_to_site_use_id);
517: FETCH c_get_country INTO p_sys_var_value_tbl(i).variable_value_id;
518: CLOSE c_get_country;
519: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
520: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'440: Ship to country = '||p_sys_var_value_tbl(i).variable_value_id);
521: END IF;
522: END IF;
523: END;

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

516: OPEN c_get_country(l_ship_to_site_use_id);
517: FETCH c_get_country INTO p_sys_var_value_tbl(i).variable_value_id;
518: CLOSE c_get_country;
519: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
520: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'440: Ship to country = '||p_sys_var_value_tbl(i).variable_value_id);
521: END IF;
522: END IF;
523: END;
524:

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

527: IF l_invoice_to_site_use_id IS NOT NULL THEN
528: OPEN c_get_country(l_invoice_to_site_use_id);
529: FETCH c_get_country INTO p_sys_var_value_tbl(i).variable_value_id;
530: CLOSE c_get_country;
531: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
532: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'450: Invoice to country = '||p_sys_var_value_tbl(i).variable_value_id);
533: END IF;
534: END IF;
535: END;

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

528: OPEN c_get_country(l_invoice_to_site_use_id);
529: FETCH c_get_country INTO p_sys_var_value_tbl(i).variable_value_id;
530: CLOSE c_get_country;
531: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
532: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'450: Invoice to country = '||p_sys_var_value_tbl(i).variable_value_id);
533: END IF;
534: END IF;
535: END;
536:

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

548: IF l_invoice_to_site_use_id IS NOT NULL THEN
549: OPEN c_get_cust_account(l_invoice_to_site_use_id);
550: FETCH c_get_cust_account INTO p_sys_var_value_tbl(i).variable_value_id;
551: CLOSE c_get_cust_account;
552: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
553: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'460: Invoice to Customer = '||p_sys_var_value_tbl(i).variable_value_id);
554: END IF;
555: END IF;
556: END;

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

549: OPEN c_get_cust_account(l_invoice_to_site_use_id);
550: FETCH c_get_cust_account INTO p_sys_var_value_tbl(i).variable_value_id;
551: CLOSE c_get_cust_account;
552: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
553: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'460: Invoice to Customer = '||p_sys_var_value_tbl(i).variable_value_id);
554: END IF;
555: END IF;
556: END;
557:

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

560: IF l_ship_to_site_use_id IS NOT NULL THEN
561: OPEN c_get_cust_account(l_ship_to_site_use_id);
562: FETCH c_get_cust_account INTO p_sys_var_value_tbl(i).variable_value_id;
563: CLOSE c_get_cust_account;
564: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
565: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'470: Ship to Customer = '||p_sys_var_value_tbl(i).variable_value_id);
566: END IF;
567: END IF;
568: END;

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

561: OPEN c_get_cust_account(l_ship_to_site_use_id);
562: FETCH c_get_cust_account INTO p_sys_var_value_tbl(i).variable_value_id;
563: CLOSE c_get_cust_account;
564: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
565: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'470: Ship to Customer = '||p_sys_var_value_tbl(i).variable_value_id);
566: END IF;
567: END IF;
568: END;
569:

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

910: -- End: Added for resolving bug 5300044 and 5299978
911:
912: END IF;
913:
914: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
915: 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);
916: 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);
917: END IF;
918:

Line 915: 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);

911:
912: END IF;
913:
914: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
915: 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);
916: 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);
917: END IF;
918:
919:

Line 916: 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);

912: END IF;
913:
914: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
915: 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);
916: 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);
917: END IF;
918:
919:
920: END LOOP;

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

920: END LOOP;
921:
922: END IF;
923:
924: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
925: 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);
926: END IF;
927:
928:

Line 925: 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);

921:
922: END IF;
923:
924: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
925: 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);
926: END IF;
927:
928:
929: EXCEPTION

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

954: CLOSE c_get_expert_yes_no;
955: END IF;
956:
957: x_return_status := FND_API.G_RET_STS_ERROR ;
958: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
959: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'500: '||l_package_procedure||' In the FND_API.G_EXC_ERROR section');
960: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'510: x_return_status = '||x_return_status);
961: END IF;
962:

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

955: END IF;
956:
957: x_return_status := FND_API.G_RET_STS_ERROR ;
958: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
959: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'500: '||l_package_procedure||' In the FND_API.G_EXC_ERROR section');
960: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'510: x_return_status = '||x_return_status);
961: END IF;
962:
963: FND_MSG_PUB.Count_And_Get(

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

956:
957: x_return_status := FND_API.G_RET_STS_ERROR ;
958: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
959: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'500: '||l_package_procedure||' In the FND_API.G_EXC_ERROR section');
960: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'510: x_return_status = '||x_return_status);
961: END IF;
962:
963: FND_MSG_PUB.Count_And_Get(
964: p_count => x_msg_count,

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

991: END IF;
992:
993: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
994:
995: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
996: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'520: '||l_package_procedure||' In the FND_API.G_RET_STS_UNEXP_ERROR section');
997: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'530: x_return_status = '||x_return_status);
998: END IF;
999:

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

992:
993: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
994:
995: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
996: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'520: '||l_package_procedure||' In the FND_API.G_RET_STS_UNEXP_ERROR section');
997: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'530: x_return_status = '||x_return_status);
998: END IF;
999:
1000: FND_MSG_PUB.Count_And_Get(

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

993: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
994:
995: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
996: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'520: '||l_package_procedure||' In the FND_API.G_RET_STS_UNEXP_ERROR section');
997: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'530: x_return_status = '||x_return_status);
998: END IF;
999:
1000: FND_MSG_PUB.Count_And_Get(
1001: p_count => x_msg_count,

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

1027: CLOSE c_get_expert_yes_no;
1028: END IF;
1029:
1030: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1031: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1032: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'540: '||l_package_procedure||' In the OTHERS section');
1033: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'550: x_return_status = '||x_return_status);
1034: END IF;
1035:

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

1028: END IF;
1029:
1030: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1031: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1032: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'540: '||l_package_procedure||' In the OTHERS section');
1033: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'550: x_return_status = '||x_return_status);
1034: END IF;
1035:
1036: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

1029:
1030: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1031: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1032: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'540: '||l_package_procedure||' In the OTHERS section');
1033: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'550: x_return_status = '||x_return_status);
1034: END IF;
1035:
1036: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1037: FND_MSG_PUB.Add_Exc_Msg(

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

1164: l_package_procedure := G_PKG_NAME || '.' || l_api_name || ' - 2';
1165:
1166: x_return_status := FND_API.G_RET_STS_SUCCESS;
1167:
1168: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1169: l_debug := true;
1170: END IF;
1171:
1172: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1168: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1169: l_debug := true;
1170: END IF;
1171:
1172: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1173: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'10: Entered ' || l_package_procedure);
1174: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'20: p_doc_type: ' || p_doc_type);
1175: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'30: p_doc_id: ' || p_doc_id);
1176: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40: p_line_var_tbl.COUNT: ' || p_line_var_tbl.COUNT);

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

1169: l_debug := true;
1170: END IF;
1171:
1172: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1173: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'10: Entered ' || l_package_procedure);
1174: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'20: p_doc_type: ' || p_doc_type);
1175: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'30: p_doc_id: ' || p_doc_id);
1176: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40: p_line_var_tbl.COUNT: ' || p_line_var_tbl.COUNT);
1177: END IF;

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

1170: END IF;
1171:
1172: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1173: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'10: Entered ' || l_package_procedure);
1174: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'20: p_doc_type: ' || p_doc_type);
1175: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'30: p_doc_id: ' || p_doc_id);
1176: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40: p_line_var_tbl.COUNT: ' || p_line_var_tbl.COUNT);
1177: END IF;
1178:

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

1171:
1172: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1173: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'10: Entered ' || l_package_procedure);
1174: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'20: p_doc_type: ' || p_doc_type);
1175: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'30: p_doc_id: ' || p_doc_id);
1176: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40: p_line_var_tbl.COUNT: ' || p_line_var_tbl.COUNT);
1177: END IF;
1178:
1179: --

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

1172: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1173: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'10: Entered ' || l_package_procedure);
1174: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'20: p_doc_type: ' || p_doc_type);
1175: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'30: p_doc_id: ' || p_doc_id);
1176: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40: p_line_var_tbl.COUNT: ' || p_line_var_tbl.COUNT);
1177: END IF;
1178:
1179: --
1180: -- Standard call to check for call compatibility.

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

1204:
1205: l_master_org_id := TO_NUMBER(oe_sys_parameters.value (
1206: param_name => 'MASTER_ORGANIZATION_ID',p_org_id => l_current_org_id ));
1207:
1208: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1209: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'45: l_master_org_id: ' || l_master_org_id);
1210: END IF;
1211:
1212: -- Query OM tables oe_blanket_headers_all and oe_blanket_lines_all to retrieve values

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

1205: l_master_org_id := TO_NUMBER(oe_sys_parameters.value (
1206: param_name => 'MASTER_ORGANIZATION_ID',p_org_id => l_current_org_id ));
1207:
1208: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1209: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'45: l_master_org_id: ' || l_master_org_id);
1210: END IF;
1211:
1212: -- Query OM tables oe_blanket_headers_all and oe_blanket_lines_all to retrieve values
1213: -- against variable codes sent in by calling contrtact expert API

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

1214:
1215: IF p_line_var_tbl.FIRST IS NOT NULL THEN
1216: FOR i IN p_line_var_tbl.FIRST..p_line_var_tbl.LAST LOOP
1217:
1218: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1219: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: Processing for ' || p_line_var_tbl(i));
1220: END IF;
1221:
1222: IF p_line_var_tbl(i) = G_ITEM_CODE THEN

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

1215: IF p_line_var_tbl.FIRST IS NOT NULL THEN
1216: FOR i IN p_line_var_tbl.FIRST..p_line_var_tbl.LAST LOOP
1217:
1218: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1219: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: Processing for ' || p_line_var_tbl(i));
1220: END IF;
1221:
1222: IF p_line_var_tbl(i) = G_ITEM_CODE THEN
1223:

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

1222: IF p_line_var_tbl(i) = G_ITEM_CODE THEN
1223:
1224: FOR c_get_items_rec IN c_get_items LOOP
1225: --loop thru all the items for internal INT items
1226: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1227: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: c_get_items_rec.item_identifier_type: '||c_get_items_rec.item_identifier_type);
1228: END IF;
1229:
1230: IF c_get_items_rec.item_identifier_type = 'INT' THEN

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

1223:
1224: FOR c_get_items_rec IN c_get_items LOOP
1225: --loop thru all the items for internal INT items
1226: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1227: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: c_get_items_rec.item_identifier_type: '||c_get_items_rec.item_identifier_type);
1228: END IF;
1229:
1230: IF c_get_items_rec.item_identifier_type = 'INT' THEN
1231: x_line_var_value_tbl(j).variable_code := p_line_var_tbl(i); --i.e. OKC$S_ITEM

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

1230: IF c_get_items_rec.item_identifier_type = 'INT' THEN
1231: x_line_var_value_tbl(j).variable_code := p_line_var_tbl(i); --i.e. OKC$S_ITEM
1232: x_line_var_value_tbl(j).variable_value_id := c_get_items_rec.ordered_item; --eg. AS54888
1233:
1234: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1235: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: x_line_var_value_tbl('||j||').variable_code: ' || p_line_var_tbl(i));
1236: 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);
1237: END IF;
1238:

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

1231: x_line_var_value_tbl(j).variable_code := p_line_var_tbl(i); --i.e. OKC$S_ITEM
1232: x_line_var_value_tbl(j).variable_value_id := c_get_items_rec.ordered_item; --eg. AS54888
1233:
1234: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1235: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: x_line_var_value_tbl('||j||').variable_code: ' || p_line_var_tbl(i));
1236: 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);
1237: END IF;
1238:
1239: ELSIF c_get_items_rec.item_identifier_type <> 'INT' THEN

Line 1236: 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);

1232: x_line_var_value_tbl(j).variable_value_id := c_get_items_rec.ordered_item; --eg. AS54888
1233:
1234: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1235: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: x_line_var_value_tbl('||j||').variable_code: ' || p_line_var_tbl(i));
1236: 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);
1237: END IF;
1238:
1239: ELSIF c_get_items_rec.item_identifier_type <> 'INT' THEN
1240: --map the non-INT items to INT items

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

1238:
1239: ELSIF c_get_items_rec.item_identifier_type <> 'INT' THEN
1240: --map the non-INT items to INT items
1241:
1242: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1243: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: Mapping non-INT item to INT item, Calling OE_Id_To_Value.Ordered_Item ');
1244: END IF;
1245:
1246: -- Map non-INT item to INT item

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

1239: ELSIF c_get_items_rec.item_identifier_type <> 'INT' THEN
1240: --map the non-INT items to INT items
1241:
1242: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1243: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: Mapping non-INT item to INT item, Calling OE_Id_To_Value.Ordered_Item ');
1244: END IF;
1245:
1246: -- Map non-INT item to INT item
1247: OE_Id_To_Value.Ordered_Item (

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

1257:
1258: x_line_var_value_tbl(j).variable_code := p_line_var_tbl(i); --i.e. OKC$S_ITEM
1259: x_line_var_value_tbl(j).variable_value_id := lx_inventory_item;
1260:
1261: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1262: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: x_line_var_value_tbl('||j||').variable_code: ' || p_line_var_tbl(i));
1263: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: x_line_var_value_tbl('||j||').variable_value_id: ' || lx_inventory_item);
1264: END IF;
1265: END IF;

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

1258: x_line_var_value_tbl(j).variable_code := p_line_var_tbl(i); --i.e. OKC$S_ITEM
1259: x_line_var_value_tbl(j).variable_value_id := lx_inventory_item;
1260:
1261: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1262: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: x_line_var_value_tbl('||j||').variable_code: ' || p_line_var_tbl(i));
1263: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: x_line_var_value_tbl('||j||').variable_value_id: ' || lx_inventory_item);
1264: END IF;
1265: END IF;
1266:

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

1259: x_line_var_value_tbl(j).variable_value_id := lx_inventory_item;
1260:
1261: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1262: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: x_line_var_value_tbl('||j||').variable_code: ' || p_line_var_tbl(i));
1263: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: x_line_var_value_tbl('||j||').variable_value_id: ' || lx_inventory_item);
1264: END IF;
1265: END IF;
1266:
1267: j := j + 1;

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

1277:
1278: x_line_var_value_tbl(j).variable_code := p_line_var_tbl(i); --i.e. OKC$S_ITEM_CATEGORY
1279: x_line_var_value_tbl(j).variable_value_id := c_get_item_categories_rec.ordered_item;
1280:
1281: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1282: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: x_line_var_value_tbl('||j||').variable_code: '||p_line_var_tbl(i));
1283: 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);
1284: END IF;
1285:

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

1278: x_line_var_value_tbl(j).variable_code := p_line_var_tbl(i); --i.e. OKC$S_ITEM_CATEGORY
1279: x_line_var_value_tbl(j).variable_value_id := c_get_item_categories_rec.ordered_item;
1280:
1281: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1282: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: x_line_var_value_tbl('||j||').variable_code: '||p_line_var_tbl(i));
1283: 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);
1284: END IF;
1285:
1286: j := j + 1;

Line 1283: 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);

1279: x_line_var_value_tbl(j).variable_value_id := c_get_item_categories_rec.ordered_item;
1280:
1281: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1282: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: x_line_var_value_tbl('||j||').variable_code: '||p_line_var_tbl(i));
1283: 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);
1284: END IF;
1285:
1286: j := j + 1;
1287:

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

1293: -- item category
1294:
1295: FOR c_get_items_rec IN c_get_items LOOP
1296:
1297: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1298: 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');
1299: END IF;
1300:
1301: l_bsa_derived_item_category := null; --initialize

Line 1298: 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');

1294:
1295: FOR c_get_items_rec IN c_get_items LOOP
1296:
1297: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1298: 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');
1299: END IF;
1300:
1301: l_bsa_derived_item_category := null; --initialize
1302:

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

1306:
1307: x_line_var_value_tbl(j).variable_code := p_line_var_tbl(i); --i.e. OKC$S_ITEM_CATEGORY
1308: x_line_var_value_tbl(j).variable_value_id := l_bsa_derived_item_category.category_concat_segs;
1309:
1310: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1311: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: x_line_var_value_tbl('||j||').variable_code: '||p_line_var_tbl(i));
1312: 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);
1313: END IF;
1314:

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

1307: x_line_var_value_tbl(j).variable_code := p_line_var_tbl(i); --i.e. OKC$S_ITEM_CATEGORY
1308: x_line_var_value_tbl(j).variable_value_id := l_bsa_derived_item_category.category_concat_segs;
1309:
1310: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1311: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: x_line_var_value_tbl('||j||').variable_code: '||p_line_var_tbl(i));
1312: 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);
1313: END IF;
1314:
1315: j := j + 1;

Line 1312: 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);

1308: x_line_var_value_tbl(j).variable_value_id := l_bsa_derived_item_category.category_concat_segs;
1309:
1310: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1311: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: x_line_var_value_tbl('||j||').variable_code: '||p_line_var_tbl(i));
1312: 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);
1313: END IF;
1314:
1315: j := j + 1;
1316:

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

1320:
1321: END LOOP;
1322: END IF; ----IF p_line_var_tbl.FIRST IS NOT NULL THEN
1323:
1324: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1325: 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);
1326: END IF;
1327:
1328: EXCEPTION

Line 1325: 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);

1321: END LOOP;
1322: END IF; ----IF p_line_var_tbl.FIRST IS NOT NULL THEN
1323:
1324: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1325: 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);
1326: END IF;
1327:
1328: EXCEPTION
1329:

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

1346: FND_MSG_PUB.Count_And_Get(
1347: p_count => x_msg_count,
1348: p_data => x_msg_data );
1349:
1350: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1351: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: '||l_package_procedure||' In the FND_API.G_EXC_ERROR section');
1352: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: x_return_status = '||x_return_status);
1353: END IF;
1354:

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

1347: p_count => x_msg_count,
1348: p_data => x_msg_data );
1349:
1350: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1351: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: '||l_package_procedure||' In the FND_API.G_EXC_ERROR section');
1352: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: x_return_status = '||x_return_status);
1353: END IF;
1354:
1355: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1348: p_data => x_msg_data );
1349:
1350: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1351: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: '||l_package_procedure||' In the FND_API.G_EXC_ERROR section');
1352: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: x_return_status = '||x_return_status);
1353: END IF;
1354:
1355: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1356:

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

1371: FND_MSG_PUB.Count_And_Get(
1372: p_count => x_msg_count,
1373: p_data => x_msg_data );
1374:
1375: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1376: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: '||l_package_procedure||' In the FND_API.G_EXC_UNEXPECTED_ERROR section');
1377: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: x_return_status = '||x_return_status);
1378: END IF;
1379:

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

1372: p_count => x_msg_count,
1373: p_data => x_msg_data );
1374:
1375: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1376: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: '||l_package_procedure||' In the FND_API.G_EXC_UNEXPECTED_ERROR section');
1377: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: x_return_status = '||x_return_status);
1378: END IF;
1379:
1380: WHEN OTHERS THEN

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

1373: p_data => x_msg_data );
1374:
1375: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1376: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: '||l_package_procedure||' In the FND_API.G_EXC_UNEXPECTED_ERROR section');
1377: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: x_return_status = '||x_return_status);
1378: END IF;
1379:
1380: WHEN OTHERS THEN
1381:

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

1402: FND_MSG_PUB.Count_And_Get(
1403: p_count => x_msg_count,
1404: p_data => x_msg_data );
1405:
1406: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1407: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: '||l_package_procedure||' In the OTHERS section');
1408: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: x_return_status = '||x_return_status);
1409: END IF;
1410:

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

1403: p_count => x_msg_count,
1404: p_data => x_msg_data );
1405:
1406: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1407: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: '||l_package_procedure||' In the OTHERS section');
1408: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: x_return_status = '||x_return_status);
1409: END IF;
1410:
1411: END get_clause_variable_values;

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

1404: p_data => x_msg_data );
1405:
1406: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1407: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: '||l_package_procedure||' In the OTHERS section');
1408: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: x_return_status = '||x_return_status);
1409: END IF;
1410:
1411: END get_clause_variable_values;
1412:

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

1548: l_package_procedure := G_PKG_NAME || '.' || l_api_name;
1549:
1550: x_return_status := FND_API.G_RET_STS_SUCCESS;
1551:
1552: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1553: l_debug := true;
1554: END IF;
1555:
1556: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1552: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1553: l_debug := true;
1554: END IF;
1555:
1556: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1557: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'10: Entered ' || l_package_procedure);
1558: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'20: p_doc_id: ' || p_doc_id);
1559: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'30: p_doc_type: ' || p_doc_type);
1560: END IF;

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

1553: l_debug := true;
1554: END IF;
1555:
1556: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1557: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'10: Entered ' || l_package_procedure);
1558: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'20: p_doc_id: ' || p_doc_id);
1559: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'30: p_doc_type: ' || p_doc_type);
1560: END IF;
1561:

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

1554: END IF;
1555:
1556: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1557: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'10: Entered ' || l_package_procedure);
1558: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'20: p_doc_id: ' || p_doc_id);
1559: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'30: p_doc_type: ' || p_doc_type);
1560: END IF;
1561:
1562: --

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

1555:
1556: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1557: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'10: Entered ' || l_package_procedure);
1558: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'20: p_doc_id: ' || p_doc_id);
1559: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'30: p_doc_type: ' || p_doc_type);
1560: END IF;
1561:
1562: --
1563: -- Standard call to check for call compatibility.

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

1587:
1588: l_master_org_id := TO_NUMBER(oe_sys_parameters.value (
1589: param_name => 'MASTER_ORGANIZATION_ID',p_org_id => l_current_org_id ));
1590:
1591: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1592: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'35: l_master_org_id: ' || l_master_org_id);
1593: END IF;
1594: --AK
1595:

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

1588: l_master_org_id := TO_NUMBER(oe_sys_parameters.value (
1589: param_name => 'MASTER_ORGANIZATION_ID',p_org_id => l_current_org_id ));
1590:
1591: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1592: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'35: l_master_org_id: ' || l_master_org_id);
1593: END IF;
1594: --AK
1595:
1596: IF p_doc_type = G_BSA_DOC_TYPE THEN

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

1600: EXIT WHEN c_get_bsa_line_variables%NOTFOUND;
1601:
1602: l_line_number := to_char(l_bsa_line_variables.line_number);
1603:
1604: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1605: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40: line_number = '||l_bsa_line_variables.line_number );
1606: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: payment_term_id = '||l_bsa_line_variables.payment_term_id );
1607: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: item_id = '||l_bsa_line_variables.inventory_item_id );
1608: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: org_id = '||l_bsa_line_variables.org_id );

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

1601:
1602: l_line_number := to_char(l_bsa_line_variables.line_number);
1603:
1604: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1605: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40: line_number = '||l_bsa_line_variables.line_number );
1606: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: payment_term_id = '||l_bsa_line_variables.payment_term_id );
1607: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: item_id = '||l_bsa_line_variables.inventory_item_id );
1608: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: org_id = '||l_bsa_line_variables.org_id );
1609: END IF;

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

1602: l_line_number := to_char(l_bsa_line_variables.line_number);
1603:
1604: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1605: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40: line_number = '||l_bsa_line_variables.line_number );
1606: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: payment_term_id = '||l_bsa_line_variables.payment_term_id );
1607: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: item_id = '||l_bsa_line_variables.inventory_item_id );
1608: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: org_id = '||l_bsa_line_variables.org_id );
1609: END IF;
1610:

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

1603:
1604: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1605: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40: line_number = '||l_bsa_line_variables.line_number );
1606: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: payment_term_id = '||l_bsa_line_variables.payment_term_id );
1607: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: item_id = '||l_bsa_line_variables.inventory_item_id );
1608: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: org_id = '||l_bsa_line_variables.org_id );
1609: END IF;
1610:
1611:

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

1604: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1605: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40: line_number = '||l_bsa_line_variables.line_number );
1606: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: payment_term_id = '||l_bsa_line_variables.payment_term_id );
1607: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: item_id = '||l_bsa_line_variables.inventory_item_id );
1608: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: org_id = '||l_bsa_line_variables.org_id );
1609: END IF;
1610:
1611:
1612: l_line_count := l_line_count+1;

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

1639: x_line_sys_var_value_tbl(l_index).org_id := l_bsa_line_variables.org_id;
1640: ELSIF l_bsa_line_variables.item_identifier_type <> 'INT' THEN
1641: --map the non-INT items to INT items
1642:
1643: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1644: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'71: Mapping non-INT item to INT item, Calling OE_Id_To_Value.Ordered_Item ');
1645: END IF;
1646:
1647: -- Map non-INT item to INT item

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

1640: ELSIF l_bsa_line_variables.item_identifier_type <> 'INT' THEN
1641: --map the non-INT items to INT items
1642:
1643: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1644: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'71: Mapping non-INT item to INT item, Calling OE_Id_To_Value.Ordered_Item ');
1645: END IF;
1646:
1647: -- Map non-INT item to INT item
1648: OE_Id_To_Value.Ordered_Item (

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

1661: x_line_sys_var_value_tbl(l_index).variable_value := lx_inventory_item;
1662: x_line_sys_var_value_tbl(l_index).item_id := l_bsa_line_variables.inventory_item_id;
1663: x_line_sys_var_value_tbl(l_index).org_id := l_bsa_line_variables.org_id;
1664:
1665: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1666: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'72: x_line_var_value_tbl('||j||').variable_code: ' || G_ITEM_CODE);
1667: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'73: x_line_var_value_tbl('||j||').variable_value_id: ' || lx_inventory_item);
1668: END IF;
1669: END IF;

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

1662: x_line_sys_var_value_tbl(l_index).item_id := l_bsa_line_variables.inventory_item_id;
1663: x_line_sys_var_value_tbl(l_index).org_id := l_bsa_line_variables.org_id;
1664:
1665: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1666: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'72: x_line_var_value_tbl('||j||').variable_code: ' || G_ITEM_CODE);
1667: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'73: x_line_var_value_tbl('||j||').variable_value_id: ' || lx_inventory_item);
1668: END IF;
1669: END IF;
1670:

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

1663: x_line_sys_var_value_tbl(l_index).org_id := l_bsa_line_variables.org_id;
1664:
1665: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1666: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'72: x_line_var_value_tbl('||j||').variable_code: ' || G_ITEM_CODE);
1667: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'73: x_line_var_value_tbl('||j||').variable_value_id: ' || lx_inventory_item);
1668: END IF;
1669: END IF;
1670:
1671: IF l_bsa_line_variables.inventory_item_id IS NOT NULL THEN

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

1689: x_line_sys_var_value_tbl(l_index).variable_value := l_bsa_derived_item_category;
1690: x_line_sys_var_value_tbl(l_index).item_id := l_bsa_line_variables.inventory_item_id;
1691: x_line_sys_var_value_tbl(l_index).org_id := l_bsa_line_variables.org_id;
1692:
1693: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1694: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'74: x_line_var_value_tbl('||j||').variable_code: '||G_ITEM_CATEGORY_CODE);
1695: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'75: x_line_var_value_tbl('||j||').variable_value_id: '||l_bsa_derived_item_category);
1696: END IF;
1697: END IF;

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

1690: x_line_sys_var_value_tbl(l_index).item_id := l_bsa_line_variables.inventory_item_id;
1691: x_line_sys_var_value_tbl(l_index).org_id := l_bsa_line_variables.org_id;
1692:
1693: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1694: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'74: x_line_var_value_tbl('||j||').variable_code: '||G_ITEM_CATEGORY_CODE);
1695: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'75: x_line_var_value_tbl('||j||').variable_value_id: '||l_bsa_derived_item_category);
1696: END IF;
1697: END IF;
1698:

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

1691: x_line_sys_var_value_tbl(l_index).org_id := l_bsa_line_variables.org_id;
1692:
1693: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1694: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'74: x_line_var_value_tbl('||j||').variable_code: '||G_ITEM_CATEGORY_CODE);
1695: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'75: x_line_var_value_tbl('||j||').variable_value_id: '||l_bsa_derived_item_category);
1696: END IF;
1697: END IF;
1698:
1699: --AK

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

1761:
1762: END IF; /* if service number is not null */
1763: -- Bug 4768964 Logic provided by OM
1764:
1765: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1766: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: line_number = '||l_so_line_variables.line_number );
1767: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: payment_term_id = '||l_so_line_variables.payment_term_id );
1768: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: invoicing_rule_id = '||l_so_line_variables.invoicing_rule_id );
1769: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: agreement_id = '||l_so_line_variables.agreement_id );

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

1762: END IF; /* if service number is not null */
1763: -- Bug 4768964 Logic provided by OM
1764:
1765: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1766: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: line_number = '||l_so_line_variables.line_number );
1767: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: payment_term_id = '||l_so_line_variables.payment_term_id );
1768: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: invoicing_rule_id = '||l_so_line_variables.invoicing_rule_id );
1769: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: agreement_id = '||l_so_line_variables.agreement_id );
1770: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: item_id = '||l_so_line_variables.inventory_item_id );

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

1763: -- Bug 4768964 Logic provided by OM
1764:
1765: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1766: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: line_number = '||l_so_line_variables.line_number );
1767: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: payment_term_id = '||l_so_line_variables.payment_term_id );
1768: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: invoicing_rule_id = '||l_so_line_variables.invoicing_rule_id );
1769: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: agreement_id = '||l_so_line_variables.agreement_id );
1770: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: item_id = '||l_so_line_variables.inventory_item_id );
1771: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: org_id = '||l_so_line_variables.org_id );

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

1764:
1765: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1766: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: line_number = '||l_so_line_variables.line_number );
1767: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: payment_term_id = '||l_so_line_variables.payment_term_id );
1768: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: invoicing_rule_id = '||l_so_line_variables.invoicing_rule_id );
1769: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: agreement_id = '||l_so_line_variables.agreement_id );
1770: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: item_id = '||l_so_line_variables.inventory_item_id );
1771: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: org_id = '||l_so_line_variables.org_id );
1772: END IF;

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

1765: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1766: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: line_number = '||l_so_line_variables.line_number );
1767: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: payment_term_id = '||l_so_line_variables.payment_term_id );
1768: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: invoicing_rule_id = '||l_so_line_variables.invoicing_rule_id );
1769: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: agreement_id = '||l_so_line_variables.agreement_id );
1770: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: item_id = '||l_so_line_variables.inventory_item_id );
1771: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: org_id = '||l_so_line_variables.org_id );
1772: END IF;
1773:

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

1766: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: line_number = '||l_so_line_variables.line_number );
1767: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: payment_term_id = '||l_so_line_variables.payment_term_id );
1768: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: invoicing_rule_id = '||l_so_line_variables.invoicing_rule_id );
1769: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: agreement_id = '||l_so_line_variables.agreement_id );
1770: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: item_id = '||l_so_line_variables.inventory_item_id );
1771: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: org_id = '||l_so_line_variables.org_id );
1772: END IF;
1773:
1774:

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

1767: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: payment_term_id = '||l_so_line_variables.payment_term_id );
1768: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: invoicing_rule_id = '||l_so_line_variables.invoicing_rule_id );
1769: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: agreement_id = '||l_so_line_variables.agreement_id );
1770: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: item_id = '||l_so_line_variables.inventory_item_id );
1771: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: org_id = '||l_so_line_variables.org_id );
1772: END IF;
1773:
1774:
1775: l_line_count := l_line_count+1;

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

1811: x_line_sys_var_value_tbl(l_index).org_id := l_so_line_variables.org_id;
1812: ELSIF l_so_line_variables.item_identifier_type <> 'INT' THEN
1813: --map the non-INT items to INT items
1814:
1815: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1816: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: Mapping non-INT item to INT item, Calling OE_Id_To_Value.Ordered_Item ');
1817: END IF;
1818:
1819: -- Map non-INT item to INT item

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

1812: ELSIF l_so_line_variables.item_identifier_type <> 'INT' THEN
1813: --map the non-INT items to INT items
1814:
1815: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1816: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: Mapping non-INT item to INT item, Calling OE_Id_To_Value.Ordered_Item ');
1817: END IF;
1818:
1819: -- Map non-INT item to INT item
1820: OE_Id_To_Value.Ordered_Item (

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

1833: x_line_sys_var_value_tbl(l_index).variable_value := lx_inventory_item;
1834: x_line_sys_var_value_tbl(l_index).item_id := l_so_line_variables.inventory_item_id;
1835: x_line_sys_var_value_tbl(l_index).org_id := l_so_line_variables.org_id;
1836:
1837: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1838: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: x_line_var_value_tbl('||j||').variable_code: ' || G_ITEM_CODE);
1839: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: x_line_var_value_tbl('||j||').variable_value_id: ' || lx_inventory_item);
1840: END IF;
1841: END IF;

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

1834: x_line_sys_var_value_tbl(l_index).item_id := l_so_line_variables.inventory_item_id;
1835: x_line_sys_var_value_tbl(l_index).org_id := l_so_line_variables.org_id;
1836:
1837: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1838: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: x_line_var_value_tbl('||j||').variable_code: ' || G_ITEM_CODE);
1839: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: x_line_var_value_tbl('||j||').variable_value_id: ' || lx_inventory_item);
1840: END IF;
1841: END IF;
1842:

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

1835: x_line_sys_var_value_tbl(l_index).org_id := l_so_line_variables.org_id;
1836:
1837: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1838: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: x_line_var_value_tbl('||j||').variable_code: ' || G_ITEM_CODE);
1839: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: x_line_var_value_tbl('||j||').variable_value_id: ' || lx_inventory_item);
1840: END IF;
1841: END IF;
1842:
1843: IF l_so_line_variables.inventory_item_id IS NOT NULL THEN

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

1863: x_line_sys_var_value_tbl(l_index).item_id := l_so_line_variables.inventory_item_id;
1864: x_line_sys_var_value_tbl(l_index).org_id := l_so_line_variables.org_id;
1865:
1866:
1867: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1868: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'74: x_line_var_value_tbl('||j||').variable_code: '||G_ITEM_CATEGORY_CODE);
1869: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'75: x_line_var_value_tbl('||j||').variable_value_id: '||l_so_derived_item_category);
1870: END IF;
1871: END IF;

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

1864: x_line_sys_var_value_tbl(l_index).org_id := l_so_line_variables.org_id;
1865:
1866:
1867: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1868: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'74: x_line_var_value_tbl('||j||').variable_code: '||G_ITEM_CATEGORY_CODE);
1869: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'75: x_line_var_value_tbl('||j||').variable_value_id: '||l_so_derived_item_category);
1870: END IF;
1871: END IF;
1872:

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

1865:
1866:
1867: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1868: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'74: x_line_var_value_tbl('||j||').variable_code: '||G_ITEM_CATEGORY_CODE);
1869: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'75: x_line_var_value_tbl('||j||').variable_value_id: '||l_so_derived_item_category);
1870: END IF;
1871: END IF;
1872:
1873: --AK

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

1890: x_line_count := 1; -- Since no Lines, need to set line count to 1 for the CX Java code
1891: x_line_variables_count := 0; -- Since no Lines, need to set line variables count to 0 for the CX Java code
1892: END IF;
1893:
1894: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1895: 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);
1896: END IF;
1897:
1898: EXCEPTION

Line 1895: 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);

1891: x_line_variables_count := 0; -- Since no Lines, need to set line variables count to 0 for the CX Java code
1892: END IF;
1893:
1894: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1895: 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);
1896: END IF;
1897:
1898: EXCEPTION
1899:

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

1912: FND_MSG_PUB.Count_And_Get(
1913: p_count => x_msg_count,
1914: p_data => x_msg_data );
1915:
1916: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1917: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: '||l_package_procedure||' In the FND_API.G_EXC_ERROR section');
1918: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: x_return_status = '||x_return_status);
1919: END IF;
1920:

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

1913: p_count => x_msg_count,
1914: p_data => x_msg_data );
1915:
1916: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1917: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: '||l_package_procedure||' In the FND_API.G_EXC_ERROR section');
1918: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: x_return_status = '||x_return_status);
1919: END IF;
1920:
1921: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1914: p_data => x_msg_data );
1915:
1916: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1917: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: '||l_package_procedure||' In the FND_API.G_EXC_ERROR section');
1918: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: x_return_status = '||x_return_status);
1919: END IF;
1920:
1921: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1922: IF c_get_bsa_line_variables%ISOPEN THEN

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

1932: FND_MSG_PUB.Count_And_Get(
1933: p_count => x_msg_count,
1934: p_data => x_msg_data );
1935:
1936: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1937: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: '||l_package_procedure||' In the FND_API.G_EXC_UNEXPECTED_ERROR section');
1938: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: x_return_status = '||x_return_status);
1939: END IF;
1940:

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

1933: p_count => x_msg_count,
1934: p_data => x_msg_data );
1935:
1936: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1937: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: '||l_package_procedure||' In the FND_API.G_EXC_UNEXPECTED_ERROR section');
1938: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: x_return_status = '||x_return_status);
1939: END IF;
1940:
1941: WHEN OTHERS THEN

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

1934: p_data => x_msg_data );
1935:
1936: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1937: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: '||l_package_procedure||' In the FND_API.G_EXC_UNEXPECTED_ERROR section');
1938: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: x_return_status = '||x_return_status);
1939: END IF;
1940:
1941: WHEN OTHERS THEN
1942: IF c_get_bsa_line_variables%ISOPEN THEN

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

1958: FND_MSG_PUB.Count_And_Get(
1959: p_count => x_msg_count,
1960: p_data => x_msg_data );
1961:
1962: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1963: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: '||l_package_procedure||' In the OTHERS section');
1964: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: x_return_status = '||x_return_status);
1965: END IF;
1966:

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

1959: p_count => x_msg_count,
1960: p_data => x_msg_data );
1961:
1962: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1963: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: '||l_package_procedure||' In the OTHERS section');
1964: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: x_return_status = '||x_return_status);
1965: END IF;
1966:
1967: END get_line_variable_values;

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

1960: p_data => x_msg_data );
1961:
1962: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1963: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: '||l_package_procedure||' In the OTHERS section');
1964: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: x_return_status = '||x_return_status);
1965: END IF;
1966:
1967: END get_line_variable_values;
1968: