[Home] [Help]
14: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
15:
16: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKC_XPRT_QUOTE_INT_PVT';
17: G_APP_NAME CONSTANT VARCHAR2(30) := OKC_API.G_APP_NAME;
18: G_STMT_LEVEL CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
19: G_MODULE_NAME CONSTANT VARCHAR2(250) := 'OKC.PLSQL.'||G_PKG_NAME||'.';
20:
21: G_ITEM_CODE CONSTANT VARCHAR2(30) := 'OKC$S_ITEM';
22: G_ITEM_CATEGORY_CODE CONSTANT VARCHAR2(30) := 'OKC$S_ITEM_CATEGORY';
221: x_return_status := FND_API.G_RET_STS_SUCCESS;
222:
223: l_package_procedure := G_PKG_NAME || '.' || l_api_name;
224:
225: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
226: l_debug := true;
227: END IF;
228:
229: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
225: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
226: l_debug := true;
227: END IF;
228:
229: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
230: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'10: Entered ' || l_package_procedure);
231: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'20: p_doc_id: ' || p_doc_id);
232: END IF;
233:
226: l_debug := true;
227: END IF;
228:
229: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
230: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'10: Entered ' || l_package_procedure);
231: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'20: p_doc_id: ' || p_doc_id);
232: END IF;
233:
234: --
227: END IF;
228:
229: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
230: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'10: Entered ' || l_package_procedure);
231: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'20: p_doc_id: ' || p_doc_id);
232: END IF;
233:
234: --
235: -- Standard call to check for call compatibility.
260: IF p_sys_var_value_tbl.FIRST IS NOT NULL THEN
261:
262: OPEN c_get_quote_header_variables;
263: FETCH c_get_quote_header_variables INTO l_quote_header_variables;
264: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
265: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'30:c_get_quote_header_variables%ROWCOUNT: ' || c_get_quote_header_variables%ROWCOUNT);
266: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40:Values from l_quote_header_variables are:');
267: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,' ');
268: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'************************ ');
261:
262: OPEN c_get_quote_header_variables;
263: FETCH c_get_quote_header_variables INTO l_quote_header_variables;
264: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
265: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'30:c_get_quote_header_variables%ROWCOUNT: ' || c_get_quote_header_variables%ROWCOUNT);
266: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40:Values from l_quote_header_variables are:');
267: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,' ');
268: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'************************ ');
269: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: cust_account_id = '||l_quote_header_variables.cust_account_id );
262: OPEN c_get_quote_header_variables;
263: FETCH c_get_quote_header_variables INTO l_quote_header_variables;
264: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
265: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'30:c_get_quote_header_variables%ROWCOUNT: ' || c_get_quote_header_variables%ROWCOUNT);
266: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40:Values from l_quote_header_variables are:');
267: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,' ');
268: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'************************ ');
269: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: cust_account_id = '||l_quote_header_variables.cust_account_id );
270: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: currency_code = '||l_quote_header_variables.currency_code );
263: FETCH c_get_quote_header_variables INTO l_quote_header_variables;
264: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
265: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'30:c_get_quote_header_variables%ROWCOUNT: ' || c_get_quote_header_variables%ROWCOUNT);
266: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40:Values from l_quote_header_variables are:');
267: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,' ');
268: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'************************ ');
269: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: cust_account_id = '||l_quote_header_variables.cust_account_id );
270: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: currency_code = '||l_quote_header_variables.currency_code );
271: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: price_agreement_id = '||l_quote_header_variables.price_agreement_id );
264: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
265: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'30:c_get_quote_header_variables%ROWCOUNT: ' || c_get_quote_header_variables%ROWCOUNT);
266: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40:Values from l_quote_header_variables are:');
267: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,' ');
268: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'************************ ');
269: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: cust_account_id = '||l_quote_header_variables.cust_account_id );
270: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: currency_code = '||l_quote_header_variables.currency_code );
271: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: price_agreement_id = '||l_quote_header_variables.price_agreement_id );
272: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: price_agreement_exist = '||l_quote_header_variables.price_agreement_exist );
265: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'30:c_get_quote_header_variables%ROWCOUNT: ' || c_get_quote_header_variables%ROWCOUNT);
266: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40:Values from l_quote_header_variables are:');
267: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,' ');
268: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'************************ ');
269: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: cust_account_id = '||l_quote_header_variables.cust_account_id );
270: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: currency_code = '||l_quote_header_variables.currency_code );
271: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: price_agreement_id = '||l_quote_header_variables.price_agreement_id );
272: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: price_agreement_exist = '||l_quote_header_variables.price_agreement_exist );
273: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: total_adjusted_percent = '||l_quote_header_variables.total_adjusted_percent );
266: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40:Values from l_quote_header_variables are:');
267: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,' ');
268: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'************************ ');
269: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: cust_account_id = '||l_quote_header_variables.cust_account_id );
270: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: currency_code = '||l_quote_header_variables.currency_code );
271: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: price_agreement_id = '||l_quote_header_variables.price_agreement_id );
272: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: price_agreement_exist = '||l_quote_header_variables.price_agreement_exist );
273: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: total_adjusted_percent = '||l_quote_header_variables.total_adjusted_percent );
274: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: total_adjusted_amount = '||l_quote_header_variables.total_adjusted_amount );
267: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,' ');
268: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'************************ ');
269: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: cust_account_id = '||l_quote_header_variables.cust_account_id );
270: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: currency_code = '||l_quote_header_variables.currency_code );
271: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: price_agreement_id = '||l_quote_header_variables.price_agreement_id );
272: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: price_agreement_exist = '||l_quote_header_variables.price_agreement_exist );
273: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: total_adjusted_percent = '||l_quote_header_variables.total_adjusted_percent );
274: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: total_adjusted_amount = '||l_quote_header_variables.total_adjusted_amount );
275: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: total_quote_price = '||l_quote_header_variables.total_quote_price );
268: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'************************ ');
269: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: cust_account_id = '||l_quote_header_variables.cust_account_id );
270: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: currency_code = '||l_quote_header_variables.currency_code );
271: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: price_agreement_id = '||l_quote_header_variables.price_agreement_id );
272: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: price_agreement_exist = '||l_quote_header_variables.price_agreement_exist );
273: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: total_adjusted_percent = '||l_quote_header_variables.total_adjusted_percent );
274: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: total_adjusted_amount = '||l_quote_header_variables.total_adjusted_amount );
275: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: total_quote_price = '||l_quote_header_variables.total_quote_price );
276: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: order_type_id = '||l_quote_header_variables.order_type_id );
269: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: cust_account_id = '||l_quote_header_variables.cust_account_id );
270: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: currency_code = '||l_quote_header_variables.currency_code );
271: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: price_agreement_id = '||l_quote_header_variables.price_agreement_id );
272: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: price_agreement_exist = '||l_quote_header_variables.price_agreement_exist );
273: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: total_adjusted_percent = '||l_quote_header_variables.total_adjusted_percent );
274: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: total_adjusted_amount = '||l_quote_header_variables.total_adjusted_amount );
275: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: total_quote_price = '||l_quote_header_variables.total_quote_price );
276: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: order_type_id = '||l_quote_header_variables.order_type_id );
277: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: party_id = '||l_quote_header_variables.party_id );
270: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: currency_code = '||l_quote_header_variables.currency_code );
271: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: price_agreement_id = '||l_quote_header_variables.price_agreement_id );
272: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: price_agreement_exist = '||l_quote_header_variables.price_agreement_exist );
273: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: total_adjusted_percent = '||l_quote_header_variables.total_adjusted_percent );
274: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: total_adjusted_amount = '||l_quote_header_variables.total_adjusted_amount );
275: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: total_quote_price = '||l_quote_header_variables.total_quote_price );
276: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: order_type_id = '||l_quote_header_variables.order_type_id );
277: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: party_id = '||l_quote_header_variables.party_id );
278: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'140: invoice_to_cust_account_id = '||l_quote_header_variables.invoice_to_cust_account_id );
271: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: price_agreement_id = '||l_quote_header_variables.price_agreement_id );
272: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: price_agreement_exist = '||l_quote_header_variables.price_agreement_exist );
273: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: total_adjusted_percent = '||l_quote_header_variables.total_adjusted_percent );
274: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: total_adjusted_amount = '||l_quote_header_variables.total_adjusted_amount );
275: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: total_quote_price = '||l_quote_header_variables.total_quote_price );
276: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: order_type_id = '||l_quote_header_variables.order_type_id );
277: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: party_id = '||l_quote_header_variables.party_id );
278: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'140: invoice_to_cust_account_id = '||l_quote_header_variables.invoice_to_cust_account_id );
279: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: invoice_to_party_site_id = '||l_quote_header_variables.invoice_to_party_site_id );
272: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: price_agreement_exist = '||l_quote_header_variables.price_agreement_exist );
273: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: total_adjusted_percent = '||l_quote_header_variables.total_adjusted_percent );
274: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: total_adjusted_amount = '||l_quote_header_variables.total_adjusted_amount );
275: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: total_quote_price = '||l_quote_header_variables.total_quote_price );
276: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: order_type_id = '||l_quote_header_variables.order_type_id );
277: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: party_id = '||l_quote_header_variables.party_id );
278: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'140: invoice_to_cust_account_id = '||l_quote_header_variables.invoice_to_cust_account_id );
279: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: invoice_to_party_site_id = '||l_quote_header_variables.invoice_to_party_site_id );
280: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: sold_to_party_site_id = '||l_quote_header_variables.sold_to_party_site_id );
273: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: total_adjusted_percent = '||l_quote_header_variables.total_adjusted_percent );
274: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: total_adjusted_amount = '||l_quote_header_variables.total_adjusted_amount );
275: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: total_quote_price = '||l_quote_header_variables.total_quote_price );
276: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: order_type_id = '||l_quote_header_variables.order_type_id );
277: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: party_id = '||l_quote_header_variables.party_id );
278: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'140: invoice_to_cust_account_id = '||l_quote_header_variables.invoice_to_cust_account_id );
279: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: invoice_to_party_site_id = '||l_quote_header_variables.invoice_to_party_site_id );
280: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: sold_to_party_site_id = '||l_quote_header_variables.sold_to_party_site_id );
281: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: price_list_id = '||l_quote_header_variables.price_list_id );
274: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: total_adjusted_amount = '||l_quote_header_variables.total_adjusted_amount );
275: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: total_quote_price = '||l_quote_header_variables.total_quote_price );
276: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: order_type_id = '||l_quote_header_variables.order_type_id );
277: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: party_id = '||l_quote_header_variables.party_id );
278: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'140: invoice_to_cust_account_id = '||l_quote_header_variables.invoice_to_cust_account_id );
279: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: invoice_to_party_site_id = '||l_quote_header_variables.invoice_to_party_site_id );
280: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: sold_to_party_site_id = '||l_quote_header_variables.sold_to_party_site_id );
281: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: price_list_id = '||l_quote_header_variables.price_list_id );
282: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: sales_channel_code = '||l_quote_header_variables.sales_channel_code );
275: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: total_quote_price = '||l_quote_header_variables.total_quote_price );
276: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: order_type_id = '||l_quote_header_variables.order_type_id );
277: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: party_id = '||l_quote_header_variables.party_id );
278: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'140: invoice_to_cust_account_id = '||l_quote_header_variables.invoice_to_cust_account_id );
279: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: invoice_to_party_site_id = '||l_quote_header_variables.invoice_to_party_site_id );
280: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: sold_to_party_site_id = '||l_quote_header_variables.sold_to_party_site_id );
281: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: price_list_id = '||l_quote_header_variables.price_list_id );
282: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: sales_channel_code = '||l_quote_header_variables.sales_channel_code );
283: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: cust_po_num_exist = '||l_quote_header_variables.cust_po_num_exist );
276: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: order_type_id = '||l_quote_header_variables.order_type_id );
277: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: party_id = '||l_quote_header_variables.party_id );
278: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'140: invoice_to_cust_account_id = '||l_quote_header_variables.invoice_to_cust_account_id );
279: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: invoice_to_party_site_id = '||l_quote_header_variables.invoice_to_party_site_id );
280: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: sold_to_party_site_id = '||l_quote_header_variables.sold_to_party_site_id );
281: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: price_list_id = '||l_quote_header_variables.price_list_id );
282: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: sales_channel_code = '||l_quote_header_variables.sales_channel_code );
283: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: cust_po_num_exist = '||l_quote_header_variables.cust_po_num_exist );
284: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: payment_term_id = '||l_quote_header_variables.payment_term_id );
277: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: party_id = '||l_quote_header_variables.party_id );
278: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'140: invoice_to_cust_account_id = '||l_quote_header_variables.invoice_to_cust_account_id );
279: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: invoice_to_party_site_id = '||l_quote_header_variables.invoice_to_party_site_id );
280: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: sold_to_party_site_id = '||l_quote_header_variables.sold_to_party_site_id );
281: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: price_list_id = '||l_quote_header_variables.price_list_id );
282: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: sales_channel_code = '||l_quote_header_variables.sales_channel_code );
283: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: cust_po_num_exist = '||l_quote_header_variables.cust_po_num_exist );
284: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: payment_term_id = '||l_quote_header_variables.payment_term_id );
285: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: payment_type_code = '||l_quote_header_variables.payment_type_code );
278: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'140: invoice_to_cust_account_id = '||l_quote_header_variables.invoice_to_cust_account_id );
279: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: invoice_to_party_site_id = '||l_quote_header_variables.invoice_to_party_site_id );
280: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: sold_to_party_site_id = '||l_quote_header_variables.sold_to_party_site_id );
281: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: price_list_id = '||l_quote_header_variables.price_list_id );
282: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: sales_channel_code = '||l_quote_header_variables.sales_channel_code );
283: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: cust_po_num_exist = '||l_quote_header_variables.cust_po_num_exist );
284: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: payment_term_id = '||l_quote_header_variables.payment_term_id );
285: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: payment_type_code = '||l_quote_header_variables.payment_type_code );
286: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: tax_exempt_flag = '||l_quote_header_variables.tax_exempt_flag );
279: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: invoice_to_party_site_id = '||l_quote_header_variables.invoice_to_party_site_id );
280: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: sold_to_party_site_id = '||l_quote_header_variables.sold_to_party_site_id );
281: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: price_list_id = '||l_quote_header_variables.price_list_id );
282: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: sales_channel_code = '||l_quote_header_variables.sales_channel_code );
283: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: cust_po_num_exist = '||l_quote_header_variables.cust_po_num_exist );
284: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: payment_term_id = '||l_quote_header_variables.payment_term_id );
285: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: payment_type_code = '||l_quote_header_variables.payment_type_code );
286: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: tax_exempt_flag = '||l_quote_header_variables.tax_exempt_flag );
287: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: freight_terms_code = '||l_quote_header_variables.freight_terms_code );
280: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: sold_to_party_site_id = '||l_quote_header_variables.sold_to_party_site_id );
281: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: price_list_id = '||l_quote_header_variables.price_list_id );
282: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: sales_channel_code = '||l_quote_header_variables.sales_channel_code );
283: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: cust_po_num_exist = '||l_quote_header_variables.cust_po_num_exist );
284: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: payment_term_id = '||l_quote_header_variables.payment_term_id );
285: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: payment_type_code = '||l_quote_header_variables.payment_type_code );
286: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: tax_exempt_flag = '||l_quote_header_variables.tax_exempt_flag );
287: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: freight_terms_code = '||l_quote_header_variables.freight_terms_code );
288: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'240: ship_method_code = '||l_quote_header_variables.ship_method_code );
281: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: price_list_id = '||l_quote_header_variables.price_list_id );
282: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: sales_channel_code = '||l_quote_header_variables.sales_channel_code );
283: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: cust_po_num_exist = '||l_quote_header_variables.cust_po_num_exist );
284: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: payment_term_id = '||l_quote_header_variables.payment_term_id );
285: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: payment_type_code = '||l_quote_header_variables.payment_type_code );
286: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: tax_exempt_flag = '||l_quote_header_variables.tax_exempt_flag );
287: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: freight_terms_code = '||l_quote_header_variables.freight_terms_code );
288: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'240: ship_method_code = '||l_quote_header_variables.ship_method_code );
289: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'250: fob_code = '||l_quote_header_variables.fob_code );
282: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: sales_channel_code = '||l_quote_header_variables.sales_channel_code );
283: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: cust_po_num_exist = '||l_quote_header_variables.cust_po_num_exist );
284: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: payment_term_id = '||l_quote_header_variables.payment_term_id );
285: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: payment_type_code = '||l_quote_header_variables.payment_type_code );
286: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: tax_exempt_flag = '||l_quote_header_variables.tax_exempt_flag );
287: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: freight_terms_code = '||l_quote_header_variables.freight_terms_code );
288: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'240: ship_method_code = '||l_quote_header_variables.ship_method_code );
289: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'250: fob_code = '||l_quote_header_variables.fob_code );
290: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'260: ship_to_cust_account_id = '||l_quote_header_variables.ship_to_cust_account_id );
283: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: cust_po_num_exist = '||l_quote_header_variables.cust_po_num_exist );
284: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: payment_term_id = '||l_quote_header_variables.payment_term_id );
285: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: payment_type_code = '||l_quote_header_variables.payment_type_code );
286: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: tax_exempt_flag = '||l_quote_header_variables.tax_exempt_flag );
287: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: freight_terms_code = '||l_quote_header_variables.freight_terms_code );
288: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'240: ship_method_code = '||l_quote_header_variables.ship_method_code );
289: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'250: fob_code = '||l_quote_header_variables.fob_code );
290: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'260: ship_to_cust_account_id = '||l_quote_header_variables.ship_to_cust_account_id );
291: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'270: ship_to_party_site_id = '||l_quote_header_variables.ship_to_party_site_id );
284: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: payment_term_id = '||l_quote_header_variables.payment_term_id );
285: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: payment_type_code = '||l_quote_header_variables.payment_type_code );
286: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: tax_exempt_flag = '||l_quote_header_variables.tax_exempt_flag );
287: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: freight_terms_code = '||l_quote_header_variables.freight_terms_code );
288: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'240: ship_method_code = '||l_quote_header_variables.ship_method_code );
289: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'250: fob_code = '||l_quote_header_variables.fob_code );
290: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'260: ship_to_cust_account_id = '||l_quote_header_variables.ship_to_cust_account_id );
291: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'270: ship_to_party_site_id = '||l_quote_header_variables.ship_to_party_site_id );
292: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'272: quote_number = '||l_quote_header_variables.quote_number );
285: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: payment_type_code = '||l_quote_header_variables.payment_type_code );
286: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: tax_exempt_flag = '||l_quote_header_variables.tax_exempt_flag );
287: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: freight_terms_code = '||l_quote_header_variables.freight_terms_code );
288: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'240: ship_method_code = '||l_quote_header_variables.ship_method_code );
289: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'250: fob_code = '||l_quote_header_variables.fob_code );
290: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'260: ship_to_cust_account_id = '||l_quote_header_variables.ship_to_cust_account_id );
291: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'270: ship_to_party_site_id = '||l_quote_header_variables.ship_to_party_site_id );
292: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'272: quote_number = '||l_quote_header_variables.quote_number );
293: -- fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'273: cust_party_id = '||l_quote_header_variables.cust_party_id );
286: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'220: tax_exempt_flag = '||l_quote_header_variables.tax_exempt_flag );
287: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: freight_terms_code = '||l_quote_header_variables.freight_terms_code );
288: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'240: ship_method_code = '||l_quote_header_variables.ship_method_code );
289: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'250: fob_code = '||l_quote_header_variables.fob_code );
290: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'260: ship_to_cust_account_id = '||l_quote_header_variables.ship_to_cust_account_id );
291: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'270: ship_to_party_site_id = '||l_quote_header_variables.ship_to_party_site_id );
292: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'272: quote_number = '||l_quote_header_variables.quote_number );
293: -- fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'273: cust_party_id = '||l_quote_header_variables.cust_party_id );
294: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'274: quote_version = '||l_quote_header_variables.quote_version );
287: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'230: freight_terms_code = '||l_quote_header_variables.freight_terms_code );
288: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'240: ship_method_code = '||l_quote_header_variables.ship_method_code );
289: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'250: fob_code = '||l_quote_header_variables.fob_code );
290: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'260: ship_to_cust_account_id = '||l_quote_header_variables.ship_to_cust_account_id );
291: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'270: ship_to_party_site_id = '||l_quote_header_variables.ship_to_party_site_id );
292: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'272: quote_number = '||l_quote_header_variables.quote_number );
293: -- fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'273: cust_party_id = '||l_quote_header_variables.cust_party_id );
294: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'274: quote_version = '||l_quote_header_variables.quote_version );
295: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'275: resource_id, = '||l_quote_header_variables.resource_id );
288: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'240: ship_method_code = '||l_quote_header_variables.ship_method_code );
289: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'250: fob_code = '||l_quote_header_variables.fob_code );
290: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'260: ship_to_cust_account_id = '||l_quote_header_variables.ship_to_cust_account_id );
291: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'270: ship_to_party_site_id = '||l_quote_header_variables.ship_to_party_site_id );
292: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'272: quote_number = '||l_quote_header_variables.quote_number );
293: -- fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'273: cust_party_id = '||l_quote_header_variables.cust_party_id );
294: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'274: quote_version = '||l_quote_header_variables.quote_version );
295: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'275: resource_id, = '||l_quote_header_variables.resource_id );
296: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'276: org_id = '||l_quote_header_variables.org_id );
289: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'250: fob_code = '||l_quote_header_variables.fob_code );
290: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'260: ship_to_cust_account_id = '||l_quote_header_variables.ship_to_cust_account_id );
291: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'270: ship_to_party_site_id = '||l_quote_header_variables.ship_to_party_site_id );
292: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'272: quote_number = '||l_quote_header_variables.quote_number );
293: -- fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'273: cust_party_id = '||l_quote_header_variables.cust_party_id );
294: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'274: quote_version = '||l_quote_header_variables.quote_version );
295: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'275: resource_id, = '||l_quote_header_variables.resource_id );
296: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'276: org_id = '||l_quote_header_variables.org_id );
297: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'277: cust_po_number = '||l_quote_header_variables.cust_po_number );
290: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'260: ship_to_cust_account_id = '||l_quote_header_variables.ship_to_cust_account_id );
291: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'270: ship_to_party_site_id = '||l_quote_header_variables.ship_to_party_site_id );
292: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'272: quote_number = '||l_quote_header_variables.quote_number );
293: -- fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'273: cust_party_id = '||l_quote_header_variables.cust_party_id );
294: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'274: quote_version = '||l_quote_header_variables.quote_version );
295: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'275: resource_id, = '||l_quote_header_variables.resource_id );
296: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'276: org_id = '||l_quote_header_variables.org_id );
297: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'277: cust_po_number = '||l_quote_header_variables.cust_po_number );
298: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'278: shipment_priority_code = '||l_quote_header_variables.shipment_priority_code );
291: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'270: ship_to_party_site_id = '||l_quote_header_variables.ship_to_party_site_id );
292: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'272: quote_number = '||l_quote_header_variables.quote_number );
293: -- fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'273: cust_party_id = '||l_quote_header_variables.cust_party_id );
294: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'274: quote_version = '||l_quote_header_variables.quote_version );
295: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'275: resource_id, = '||l_quote_header_variables.resource_id );
296: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'276: org_id = '||l_quote_header_variables.org_id );
297: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'277: cust_po_number = '||l_quote_header_variables.cust_po_number );
298: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'278: shipment_priority_code = '||l_quote_header_variables.shipment_priority_code );
299: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'279: minisite_id = '||l_quote_header_variables.minisite_id );
292: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'272: quote_number = '||l_quote_header_variables.quote_number );
293: -- fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'273: cust_party_id = '||l_quote_header_variables.cust_party_id );
294: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'274: quote_version = '||l_quote_header_variables.quote_version );
295: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'275: resource_id, = '||l_quote_header_variables.resource_id );
296: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'276: org_id = '||l_quote_header_variables.org_id );
297: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'277: cust_po_number = '||l_quote_header_variables.cust_po_number );
298: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'278: shipment_priority_code = '||l_quote_header_variables.shipment_priority_code );
299: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'279: minisite_id = '||l_quote_header_variables.minisite_id );
300:
293: -- fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'273: cust_party_id = '||l_quote_header_variables.cust_party_id );
294: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'274: quote_version = '||l_quote_header_variables.quote_version );
295: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'275: resource_id, = '||l_quote_header_variables.resource_id );
296: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'276: org_id = '||l_quote_header_variables.org_id );
297: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'277: cust_po_number = '||l_quote_header_variables.cust_po_number );
298: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'278: shipment_priority_code = '||l_quote_header_variables.shipment_priority_code );
299: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'279: minisite_id = '||l_quote_header_variables.minisite_id );
300:
301:
294: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'274: quote_version = '||l_quote_header_variables.quote_version );
295: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'275: resource_id, = '||l_quote_header_variables.resource_id );
296: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'276: org_id = '||l_quote_header_variables.org_id );
297: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'277: cust_po_number = '||l_quote_header_variables.cust_po_number );
298: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'278: shipment_priority_code = '||l_quote_header_variables.shipment_priority_code );
299: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'279: minisite_id = '||l_quote_header_variables.minisite_id );
300:
301:
302: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'************************ ');
295: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'275: resource_id, = '||l_quote_header_variables.resource_id );
296: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'276: org_id = '||l_quote_header_variables.org_id );
297: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'277: cust_po_number = '||l_quote_header_variables.cust_po_number );
298: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'278: shipment_priority_code = '||l_quote_header_variables.shipment_priority_code );
299: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'279: minisite_id = '||l_quote_header_variables.minisite_id );
300:
301:
302: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'************************ ');
303: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,' ');
298: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'278: shipment_priority_code = '||l_quote_header_variables.shipment_priority_code );
299: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'279: minisite_id = '||l_quote_header_variables.minisite_id );
300:
301:
302: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'************************ ');
303: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,' ');
304:
305: END IF;
306: CLOSE c_get_quote_header_variables;
299: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'279: minisite_id = '||l_quote_header_variables.minisite_id );
300:
301:
302: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'************************ ');
303: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,' ');
304:
305: END IF;
306: CLOSE c_get_quote_header_variables;
307:
309:
310: IF l_quote_header_variables.cust_account_id IS NOT NULL THEN
311: OPEN c_get_cust_info_var(l_quote_header_variables.cust_account_id);
312: FETCH c_get_cust_info_var INTO l_cust_info_variables;
313: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
314: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'280: c_get_cust_info_var%ROWCOUNT: ' || c_get_cust_info_var%ROWCOUNT);
315: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'290: Values from l_cust_info_variables are:');
316: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,' ');
317: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'************************ ');
310: IF l_quote_header_variables.cust_account_id IS NOT NULL THEN
311: OPEN c_get_cust_info_var(l_quote_header_variables.cust_account_id);
312: FETCH c_get_cust_info_var INTO l_cust_info_variables;
313: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
314: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'280: c_get_cust_info_var%ROWCOUNT: ' || c_get_cust_info_var%ROWCOUNT);
315: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'290: Values from l_cust_info_variables are:');
316: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,' ');
317: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'************************ ');
318: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'300: category_code = '||l_cust_info_variables.category_code );
311: OPEN c_get_cust_info_var(l_quote_header_variables.cust_account_id);
312: FETCH c_get_cust_info_var INTO l_cust_info_variables;
313: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
314: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'280: c_get_cust_info_var%ROWCOUNT: ' || c_get_cust_info_var%ROWCOUNT);
315: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'290: Values from l_cust_info_variables are:');
316: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,' ');
317: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'************************ ');
318: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'300: category_code = '||l_cust_info_variables.category_code );
319: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'310: customer_class_code = '||l_cust_info_variables.customer_class_code );
312: FETCH c_get_cust_info_var INTO l_cust_info_variables;
313: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
314: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'280: c_get_cust_info_var%ROWCOUNT: ' || c_get_cust_info_var%ROWCOUNT);
315: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'290: Values from l_cust_info_variables are:');
316: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,' ');
317: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'************************ ');
318: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'300: category_code = '||l_cust_info_variables.category_code );
319: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'310: customer_class_code = '||l_cust_info_variables.customer_class_code );
320: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'320: profile_class_id = '||l_cust_info_variables.profile_class_id );
313: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
314: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'280: c_get_cust_info_var%ROWCOUNT: ' || c_get_cust_info_var%ROWCOUNT);
315: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'290: Values from l_cust_info_variables are:');
316: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,' ');
317: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'************************ ');
318: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'300: category_code = '||l_cust_info_variables.category_code );
319: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'310: customer_class_code = '||l_cust_info_variables.customer_class_code );
320: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'320: profile_class_id = '||l_cust_info_variables.profile_class_id );
321: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'330: credit_rating = '||l_cust_info_variables.credit_rating );
314: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'280: c_get_cust_info_var%ROWCOUNT: ' || c_get_cust_info_var%ROWCOUNT);
315: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'290: Values from l_cust_info_variables are:');
316: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,' ');
317: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'************************ ');
318: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'300: category_code = '||l_cust_info_variables.category_code );
319: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'310: customer_class_code = '||l_cust_info_variables.customer_class_code );
320: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'320: profile_class_id = '||l_cust_info_variables.profile_class_id );
321: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'330: credit_rating = '||l_cust_info_variables.credit_rating );
322: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'340: credit_classification = '||l_cust_info_variables.credit_classification );
315: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'290: Values from l_cust_info_variables are:');
316: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,' ');
317: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'************************ ');
318: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'300: category_code = '||l_cust_info_variables.category_code );
319: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'310: customer_class_code = '||l_cust_info_variables.customer_class_code );
320: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'320: profile_class_id = '||l_cust_info_variables.profile_class_id );
321: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'330: credit_rating = '||l_cust_info_variables.credit_rating );
322: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'340: credit_classification = '||l_cust_info_variables.credit_classification );
323: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'350: risk_code = '||l_cust_info_variables.risk_code );
316: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,' ');
317: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'************************ ');
318: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'300: category_code = '||l_cust_info_variables.category_code );
319: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'310: customer_class_code = '||l_cust_info_variables.customer_class_code );
320: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'320: profile_class_id = '||l_cust_info_variables.profile_class_id );
321: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'330: credit_rating = '||l_cust_info_variables.credit_rating );
322: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'340: credit_classification = '||l_cust_info_variables.credit_classification );
323: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'350: risk_code = '||l_cust_info_variables.risk_code );
324: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'362: party_id = '||l_cust_info_variables.party_id );
317: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'************************ ');
318: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'300: category_code = '||l_cust_info_variables.category_code );
319: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'310: customer_class_code = '||l_cust_info_variables.customer_class_code );
320: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'320: profile_class_id = '||l_cust_info_variables.profile_class_id );
321: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'330: credit_rating = '||l_cust_info_variables.credit_rating );
322: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'340: credit_classification = '||l_cust_info_variables.credit_classification );
323: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'350: risk_code = '||l_cust_info_variables.risk_code );
324: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'362: party_id = '||l_cust_info_variables.party_id );
325: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,' ');
318: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'300: category_code = '||l_cust_info_variables.category_code );
319: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'310: customer_class_code = '||l_cust_info_variables.customer_class_code );
320: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'320: profile_class_id = '||l_cust_info_variables.profile_class_id );
321: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'330: credit_rating = '||l_cust_info_variables.credit_rating );
322: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'340: credit_classification = '||l_cust_info_variables.credit_classification );
323: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'350: risk_code = '||l_cust_info_variables.risk_code );
324: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'362: party_id = '||l_cust_info_variables.party_id );
325: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,' ');
326:
319: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'310: customer_class_code = '||l_cust_info_variables.customer_class_code );
320: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'320: profile_class_id = '||l_cust_info_variables.profile_class_id );
321: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'330: credit_rating = '||l_cust_info_variables.credit_rating );
322: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'340: credit_classification = '||l_cust_info_variables.credit_classification );
323: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'350: risk_code = '||l_cust_info_variables.risk_code );
324: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'362: party_id = '||l_cust_info_variables.party_id );
325: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,' ');
326:
327: END IF;
320: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'320: profile_class_id = '||l_cust_info_variables.profile_class_id );
321: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'330: credit_rating = '||l_cust_info_variables.credit_rating );
322: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'340: credit_classification = '||l_cust_info_variables.credit_classification );
323: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'350: risk_code = '||l_cust_info_variables.risk_code );
324: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'362: party_id = '||l_cust_info_variables.party_id );
325: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,' ');
326:
327: END IF;
328: l_party_id := l_cust_info_variables.party_id;
321: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'330: credit_rating = '||l_cust_info_variables.credit_rating );
322: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'340: credit_classification = '||l_cust_info_variables.credit_classification );
323: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'350: risk_code = '||l_cust_info_variables.risk_code );
324: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'362: party_id = '||l_cust_info_variables.party_id );
325: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,' ');
326:
327: END IF;
328: l_party_id := l_cust_info_variables.party_id;
329: CLOSE c_get_cust_info_var;
332: SELECT category_code
333: INTO l_customer_category
334: FROM hz_parties
335: WHERE party_id = l_quote_header_variables.party_id;
336: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
337: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'360: category_code = '||l_customer_category );
338: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,' ');
339: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'************************ ');
340: END IF;
333: INTO l_customer_category
334: FROM hz_parties
335: WHERE party_id = l_quote_header_variables.party_id;
336: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
337: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'360: category_code = '||l_customer_category );
338: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,' ');
339: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'************************ ');
340: END IF;
341: EXCEPTION
334: FROM hz_parties
335: WHERE party_id = l_quote_header_variables.party_id;
336: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
337: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'360: category_code = '||l_customer_category );
338: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,' ');
339: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'************************ ');
340: END IF;
341: EXCEPTION
342: WHEN NO_DATA_FOUND THEN
335: WHERE party_id = l_quote_header_variables.party_id;
336: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
337: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'360: category_code = '||l_customer_category );
338: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,' ');
339: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'************************ ');
340: END IF;
341: EXCEPTION
342: WHEN NO_DATA_FOUND THEN
343: NULL;
340: END IF;
341: EXCEPTION
342: WHEN NO_DATA_FOUND THEN
343: NULL;
344: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
345: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'370: Customer Category does not exist' );
346: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,' ');
347: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'************************ ');
348: END IF;
341: EXCEPTION
342: WHEN NO_DATA_FOUND THEN
343: NULL;
344: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
345: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'370: Customer Category does not exist' );
346: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,' ');
347: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'************************ ');
348: END IF;
349: END;
342: WHEN NO_DATA_FOUND THEN
343: NULL;
344: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
345: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'370: Customer Category does not exist' );
346: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,' ');
347: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'************************ ');
348: END IF;
349: END;
350: END IF;
343: NULL;
344: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
345: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'370: Customer Category does not exist' );
346: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,' ');
347: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'************************ ');
348: END IF;
349: END;
350: END IF;
351:
385: IF l_quote_header_variables.sold_to_party_site_id IS NOT NULL THEN
386: OPEN c_get_country_quote(l_quote_header_variables.sold_to_party_site_id);
387: FETCH c_get_country_quote INTO p_sys_var_value_tbl(i).variable_value_id;
388: CLOSE c_get_country_quote;
389: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
390: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'380: Sold to country = '||p_sys_var_value_tbl(i).variable_value_id);
391: END IF;
392: END IF;
393:
386: OPEN c_get_country_quote(l_quote_header_variables.sold_to_party_site_id);
387: FETCH c_get_country_quote INTO p_sys_var_value_tbl(i).variable_value_id;
388: CLOSE c_get_country_quote;
389: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
390: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'380: Sold to country = '||p_sys_var_value_tbl(i).variable_value_id);
391: END IF;
392: END IF;
393:
394: ELSIF p_sys_var_value_tbl(i).variable_code = G_SHIPTO_COUNTRY_CODE THEN
395: IF l_quote_header_variables.ship_to_party_site_id IS NOT NULL THEN
396: OPEN c_get_country_quote(l_quote_header_variables.ship_to_party_site_id);
397: FETCH c_get_country_quote INTO p_sys_var_value_tbl(i).variable_value_id;
398: CLOSE c_get_country_quote;
399: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
400: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'390: Ship to country = '||p_sys_var_value_tbl(i).variable_value_id);
401: END IF;
402: END IF;
403:
396: OPEN c_get_country_quote(l_quote_header_variables.ship_to_party_site_id);
397: FETCH c_get_country_quote INTO p_sys_var_value_tbl(i).variable_value_id;
398: CLOSE c_get_country_quote;
399: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
400: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'390: Ship to country = '||p_sys_var_value_tbl(i).variable_value_id);
401: END IF;
402: END IF;
403:
404: ELSIF p_sys_var_value_tbl(i).variable_code = G_BILLTO_COUNTRY_CODE THEN
405: IF l_quote_header_variables.invoice_to_party_site_id IS NOT NULL THEN
406: OPEN c_get_country_quote(l_quote_header_variables.invoice_to_party_site_id);
407: FETCH c_get_country_quote INTO p_sys_var_value_tbl(i).variable_value_id;
408: CLOSE c_get_country_quote;
409: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
410: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'400: Invoice to country = '||p_sys_var_value_tbl(i).variable_value_id);
411: END IF;
412: END IF;
413:
406: OPEN c_get_country_quote(l_quote_header_variables.invoice_to_party_site_id);
407: FETCH c_get_country_quote INTO p_sys_var_value_tbl(i).variable_value_id;
408: CLOSE c_get_country_quote;
409: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
410: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'400: Invoice to country = '||p_sys_var_value_tbl(i).variable_value_id);
411: END IF;
412: END IF;
413:
414: ELSIF p_sys_var_value_tbl(i).variable_code = G_CUSTOMER_NAME_CODE THEN
521: -- XY
522:
523: END IF;
524:
525: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
526: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,' ');
527: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'410: p_sys_var_value_tbl('||i||').variable_code : '||p_sys_var_value_tbl(i).variable_code);
528: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'415: p_sys_var_value_tbl('||i||').variable_value_id : '||p_sys_var_value_tbl(i).variable_value_id);
529: END IF;
522:
523: END IF;
524:
525: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
526: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,' ');
527: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'410: p_sys_var_value_tbl('||i||').variable_code : '||p_sys_var_value_tbl(i).variable_code);
528: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'415: p_sys_var_value_tbl('||i||').variable_value_id : '||p_sys_var_value_tbl(i).variable_value_id);
529: END IF;
530:
523: END IF;
524:
525: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
526: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,' ');
527: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'410: p_sys_var_value_tbl('||i||').variable_code : '||p_sys_var_value_tbl(i).variable_code);
528: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'415: p_sys_var_value_tbl('||i||').variable_value_id : '||p_sys_var_value_tbl(i).variable_value_id);
529: END IF;
530:
531: END LOOP;
524:
525: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
526: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,' ');
527: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'410: p_sys_var_value_tbl('||i||').variable_code : '||p_sys_var_value_tbl(i).variable_code);
528: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'415: p_sys_var_value_tbl('||i||').variable_value_id : '||p_sys_var_value_tbl(i).variable_value_id);
529: END IF;
530:
531: END LOOP;
532:
531: END LOOP;
532:
533: END IF;
534:
535: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
536: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,' ');
537: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'************************ ');
538: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'420: End of '||l_package_procedure||' for header level variables, x_return_status ' || x_return_status);
539: END IF;
532:
533: END IF;
534:
535: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
536: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,' ');
537: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'************************ ');
538: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'420: End of '||l_package_procedure||' for header level variables, x_return_status ' || x_return_status);
539: END IF;
540: EXCEPTION
533: END IF;
534:
535: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
536: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,' ');
537: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'************************ ');
538: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'420: End of '||l_package_procedure||' for header level variables, x_return_status ' || x_return_status);
539: END IF;
540: EXCEPTION
541:
534:
535: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
536: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,' ');
537: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'************************ ');
538: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'420: End of '||l_package_procedure||' for header level variables, x_return_status ' || x_return_status);
539: END IF;
540: EXCEPTION
541:
542: WHEN FND_API.G_EXC_ERROR THEN
562: FND_MSG_PUB.Count_And_Get(
563: p_count => x_msg_count,
564: p_data => x_msg_data );
565:
566: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
567: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'430: '||l_package_procedure||' In the FND_API.G_RET_STS_ERROR section');
568: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'440: x_return_status = '||x_return_status);
569: END IF;
570:
563: p_count => x_msg_count,
564: p_data => x_msg_data );
565:
566: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
567: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'430: '||l_package_procedure||' In the FND_API.G_RET_STS_ERROR section');
568: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'440: x_return_status = '||x_return_status);
569: END IF;
570:
571: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
564: p_data => x_msg_data );
565:
566: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
567: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'430: '||l_package_procedure||' In the FND_API.G_RET_STS_ERROR section');
568: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'440: x_return_status = '||x_return_status);
569: END IF;
570:
571: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
572:
586: CLOSE c_get_expert_yes_no;
587: END IF;
588:
589: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
590: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
591: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'450: '||l_package_procedure||' In the FND_API.G_EXC_UNEXPECTED_ERROR section');
592: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'460: x_return_status = '||x_return_status);
593: END IF;
594:
587: END IF;
588:
589: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
590: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
591: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'450: '||l_package_procedure||' In the FND_API.G_EXC_UNEXPECTED_ERROR section');
592: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'460: x_return_status = '||x_return_status);
593: END IF;
594:
595: FND_MSG_PUB.Count_And_Get(
588:
589: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
590: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
591: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'450: '||l_package_procedure||' In the FND_API.G_EXC_UNEXPECTED_ERROR section');
592: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'460: x_return_status = '||x_return_status);
593: END IF;
594:
595: FND_MSG_PUB.Count_And_Get(
596: p_count => x_msg_count,
614: CLOSE c_get_expert_yes_no;
615: END IF;
616:
617: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
618: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
619: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'470: '||l_package_procedure||' In the FND_API.G_RET_STS_UNEXP_ERROR section');
620: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'480: x_return_status = '||x_return_status);
621: END IF;
622:
615: END IF;
616:
617: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
618: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
619: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'470: '||l_package_procedure||' In the FND_API.G_RET_STS_UNEXP_ERROR section');
620: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'480: x_return_status = '||x_return_status);
621: END IF;
622:
623: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
616:
617: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
618: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
619: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'470: '||l_package_procedure||' In the FND_API.G_RET_STS_UNEXP_ERROR section');
620: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'480: x_return_status = '||x_return_status);
621: END IF;
622:
623: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
624: FND_MSG_PUB.Add_Exc_Msg(
657: l_package_procedure := G_PKG_NAME || '.' || l_api_name;
658:
659: x_return_status := FND_API.G_RET_STS_SUCCESS;
660:
661: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
662: l_debug := true;
663: END IF;
664:
665: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
661: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
662: l_debug := true;
663: END IF;
664:
665: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
666: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,' ');
667: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'10: Start '||l_package_procedure);
668: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'20: Entered ' || l_package_procedure);
669: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'30: p_doc_id: ' || p_doc_id);
662: l_debug := true;
663: END IF;
664:
665: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
666: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,' ');
667: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'10: Start '||l_package_procedure);
668: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'20: Entered ' || l_package_procedure);
669: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'30: p_doc_id: ' || p_doc_id);
670: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40: p_variables_tbl.COUNT: ' || p_variables_tbl.COUNT);
663: END IF;
664:
665: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
666: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,' ');
667: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'10: Start '||l_package_procedure);
668: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'20: Entered ' || l_package_procedure);
669: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'30: p_doc_id: ' || p_doc_id);
670: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40: p_variables_tbl.COUNT: ' || p_variables_tbl.COUNT);
671: END IF;
664:
665: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
666: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,' ');
667: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'10: Start '||l_package_procedure);
668: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'20: Entered ' || l_package_procedure);
669: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'30: p_doc_id: ' || p_doc_id);
670: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40: p_variables_tbl.COUNT: ' || p_variables_tbl.COUNT);
671: END IF;
672:
665: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
666: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,' ');
667: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'10: Start '||l_package_procedure);
668: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'20: Entered ' || l_package_procedure);
669: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'30: p_doc_id: ' || p_doc_id);
670: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40: p_variables_tbl.COUNT: ' || p_variables_tbl.COUNT);
671: END IF;
672:
673: --
666: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,' ');
667: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'10: Start '||l_package_procedure);
668: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'20: Entered ' || l_package_procedure);
669: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'30: p_doc_id: ' || p_doc_id);
670: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40: p_variables_tbl.COUNT: ' || p_variables_tbl.COUNT);
671: END IF;
672:
673: --
674: -- Standard call to check for call compatibility.
688: FND_MSG_PUB.initialize;
689: END IF;
690:
691: l_index := p_variables_tbl.FIRST;
692: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
693: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: l_index = '||l_index);
694: END IF;
695:
696: WHILE l_index IS NOT NULL
689: END IF;
690:
691: l_index := p_variables_tbl.FIRST;
692: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
693: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: l_index = '||l_index);
694: END IF;
695:
696: WHILE l_index IS NOT NULL
697: LOOP
695:
696: WHILE l_index IS NOT NULL
697: LOOP
698: IF p_variables_tbl(l_index).Variable_code = G_ITEM_CODE THEN
699: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
700: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: variable code = '||p_variables_tbl(l_index).Variable_code);
701: END IF;
702: SELECT
703: items.concatenated_segments
696: WHILE l_index IS NOT NULL
697: LOOP
698: IF p_variables_tbl(l_index).Variable_code = G_ITEM_CODE THEN
699: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
700: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: variable code = '||p_variables_tbl(l_index).Variable_code);
701: END IF;
702: SELECT
703: items.concatenated_segments
704: BULK COLLECT INTO x_line_var_value_tbl.item
711: AND lines.LINE_CATEGORY_CODE = 'ORDER'
712: AND lines.quote_header_id = p_doc_id;
713:
714: ELSIF p_variables_tbl(l_index).Variable_code = G_ITEM_CATEGORY_CODE THEN
715: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
716: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: variable code = '||p_variables_tbl(l_index).Variable_code);
717: END IF;
718:
719: SELECT
712: AND lines.quote_header_id = p_doc_id;
713:
714: ELSIF p_variables_tbl(l_index).Variable_code = G_ITEM_CATEGORY_CODE THEN
715: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
716: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: variable code = '||p_variables_tbl(l_index).Variable_code);
717: END IF;
718:
719: SELECT
720: cats.category_concat_segs
736: AND lines.quote_header_id = p_doc_id;
737: END IF;
738:
739: l_index := p_variables_tbl.next(l_index);
740: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
741: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: l_index = '||l_index);
742: END IF;
743:
744: END LOOP;
737: END IF;
738:
739: l_index := p_variables_tbl.next(l_index);
740: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
741: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'80: l_index = '||l_index);
742: END IF;
743:
744: END LOOP;
745:
742: END IF;
743:
744: END LOOP;
745:
746: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
747: IF x_line_var_value_tbl.item.COUNT > 0 THEN
748: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: Item Count = '||x_line_var_value_tbl.item.COUNT);
749: FOR i IN x_line_var_value_tbl.item.FIRST..x_line_var_value_tbl.item.LAST LOOP
750: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: Item : '||x_line_var_value_tbl.item(i));
744: END LOOP;
745:
746: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
747: IF x_line_var_value_tbl.item.COUNT > 0 THEN
748: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: Item Count = '||x_line_var_value_tbl.item.COUNT);
749: FOR i IN x_line_var_value_tbl.item.FIRST..x_line_var_value_tbl.item.LAST LOOP
750: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: Item : '||x_line_var_value_tbl.item(i));
751: END LOOP;
752: END IF;
746: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
747: IF x_line_var_value_tbl.item.COUNT > 0 THEN
748: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'90: Item Count = '||x_line_var_value_tbl.item.COUNT);
749: FOR i IN x_line_var_value_tbl.item.FIRST..x_line_var_value_tbl.item.LAST LOOP
750: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: Item : '||x_line_var_value_tbl.item(i));
751: END LOOP;
752: END IF;
753: IF x_line_var_value_tbl.category.COUNT > 0 THEN
754: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: Item category Count = '||x_line_var_value_tbl.category.COUNT);
750: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'100: Item : '||x_line_var_value_tbl.item(i));
751: END LOOP;
752: END IF;
753: IF x_line_var_value_tbl.category.COUNT > 0 THEN
754: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: Item category Count = '||x_line_var_value_tbl.category.COUNT);
755: FOR i IN x_line_var_value_tbl.category.FIRST..x_line_var_value_tbl.category.LAST LOOP
756: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: Item category: '||x_line_var_value_tbl.category(i));
757: END LOOP;
758: END IF;
752: END IF;
753: IF x_line_var_value_tbl.category.COUNT > 0 THEN
754: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'110: Item category Count = '||x_line_var_value_tbl.category.COUNT);
755: FOR i IN x_line_var_value_tbl.category.FIRST..x_line_var_value_tbl.category.LAST LOOP
756: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: Item category: '||x_line_var_value_tbl.category(i));
757: END LOOP;
758: END IF;
759: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130:End of '||l_package_procedure||' for header level variables, x_return_status ' || x_return_status);
760: END IF;
755: FOR i IN x_line_var_value_tbl.category.FIRST..x_line_var_value_tbl.category.LAST LOOP
756: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'120: Item category: '||x_line_var_value_tbl.category(i));
757: END LOOP;
758: END IF;
759: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130:End of '||l_package_procedure||' for header level variables, x_return_status ' || x_return_status);
760: END IF;
761: EXCEPTION
762:
763: WHEN FND_API.G_EXC_ERROR THEN
762:
763: WHEN FND_API.G_EXC_ERROR THEN
764:
765: x_return_status := FND_API.G_RET_STS_ERROR ;
766: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
767: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: '||l_package_procedure||' In the FND_API.G_EXC_ERROR section');
768: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'140: x_return_status = '||x_return_status);
769: END IF;
770:
763: WHEN FND_API.G_EXC_ERROR THEN
764:
765: x_return_status := FND_API.G_RET_STS_ERROR ;
766: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
767: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: '||l_package_procedure||' In the FND_API.G_EXC_ERROR section');
768: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'140: x_return_status = '||x_return_status);
769: END IF;
770:
771: FND_MSG_PUB.Count_And_Get(
764:
765: x_return_status := FND_API.G_RET_STS_ERROR ;
766: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
767: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: '||l_package_procedure||' In the FND_API.G_EXC_ERROR section');
768: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'140: x_return_status = '||x_return_status);
769: END IF;
770:
771: FND_MSG_PUB.Count_And_Get(
772: p_count => x_msg_count,
774:
775: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
776:
777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
778: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
779: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: '||l_package_procedure||' In the FND_API.G_EXC_UNEXPECTED_ERROR section');
780: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: x_return_status = '||x_return_status);
781: END IF;
782:
775: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
776:
777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
778: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
779: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: '||l_package_procedure||' In the FND_API.G_EXC_UNEXPECTED_ERROR section');
780: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: x_return_status = '||x_return_status);
781: END IF;
782:
783: FND_MSG_PUB.Count_And_Get(
776:
777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
778: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
779: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: '||l_package_procedure||' In the FND_API.G_EXC_UNEXPECTED_ERROR section');
780: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: x_return_status = '||x_return_status);
781: END IF;
782:
783: FND_MSG_PUB.Count_And_Get(
784: p_count => x_msg_count,
786:
787: WHEN OTHERS THEN
788:
789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
790: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
791: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: '||l_package_procedure||' In the OTHERS section');
792: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: x_return_status = '||x_return_status);
793: END IF;
794:
787: WHEN OTHERS THEN
788:
789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
790: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
791: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: '||l_package_procedure||' In the OTHERS section');
792: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: x_return_status = '||x_return_status);
793: END IF;
794:
795: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
788:
789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
790: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
791: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: '||l_package_procedure||' In the OTHERS section');
792: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: x_return_status = '||x_return_status);
793: END IF;
794:
795: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
796: FND_MSG_PUB.Add_Exc_Msg(
905: l_package_procedure := G_PKG_NAME || '.' || l_api_name;
906:
907: x_return_status := FND_API.G_RET_STS_SUCCESS;
908:
909: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
910: l_debug := true;
911: END IF;
912:
913: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
909: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
910: l_debug := true;
911: END IF;
912:
913: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
914: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,' ');
915: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'10: Start '||l_package_procedure);
916: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'20: Entered ' || l_package_procedure);
917: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'30: p_doc_id: ' || p_doc_id);
910: l_debug := true;
911: END IF;
912:
913: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
914: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,' ');
915: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'10: Start '||l_package_procedure);
916: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'20: Entered ' || l_package_procedure);
917: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'30: p_doc_id: ' || p_doc_id);
918: END IF;
911: END IF;
912:
913: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
914: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,' ');
915: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'10: Start '||l_package_procedure);
916: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'20: Entered ' || l_package_procedure);
917: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'30: p_doc_id: ' || p_doc_id);
918: END IF;
919:
912:
913: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
914: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,' ');
915: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'10: Start '||l_package_procedure);
916: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'20: Entered ' || l_package_procedure);
917: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'30: p_doc_id: ' || p_doc_id);
918: END IF;
919:
920: --
913: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
914: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,' ');
915: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'10: Start '||l_package_procedure);
916: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'20: Entered ' || l_package_procedure);
917: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'30: p_doc_id: ' || p_doc_id);
918: END IF;
919:
920: --
921: -- Standard call to check for call compatibility.
957: l_line_number := l_out_qte_line_number_tbl(l_in_qte_line_number_tbl(i).quote_line_id);
958: i := i + 1;
959: -- End
960:
961: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
962: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40: line_number = '||l_quote_line_variables.line_number );
963: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: payment_term_id = '||l_quote_line_variables.payment_term_id );
964: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: item_id = '||l_quote_line_variables.inventory_item_id );
965: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: org_id = '||l_quote_line_variables.org_id );
958: i := i + 1;
959: -- End
960:
961: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
962: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40: line_number = '||l_quote_line_variables.line_number );
963: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: payment_term_id = '||l_quote_line_variables.payment_term_id );
964: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: item_id = '||l_quote_line_variables.inventory_item_id );
965: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: org_id = '||l_quote_line_variables.org_id );
966: END IF;
959: -- End
960:
961: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
962: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40: line_number = '||l_quote_line_variables.line_number );
963: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: payment_term_id = '||l_quote_line_variables.payment_term_id );
964: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: item_id = '||l_quote_line_variables.inventory_item_id );
965: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: org_id = '||l_quote_line_variables.org_id );
966: END IF;
967:
960:
961: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
962: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40: line_number = '||l_quote_line_variables.line_number );
963: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: payment_term_id = '||l_quote_line_variables.payment_term_id );
964: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: item_id = '||l_quote_line_variables.inventory_item_id );
965: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: org_id = '||l_quote_line_variables.org_id );
966: END IF;
967:
968:
961: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
962: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'40: line_number = '||l_quote_line_variables.line_number );
963: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'50: payment_term_id = '||l_quote_line_variables.payment_term_id );
964: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'60: item_id = '||l_quote_line_variables.inventory_item_id );
965: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'70: org_id = '||l_quote_line_variables.org_id );
966: END IF;
967:
968:
969: l_line_count := l_line_count+1;
1020: x_line_count := 1; -- Since no Lines, need to set line count to 1 for the CX Java code
1021: x_line_variables_count := 0; -- Since no Lines, need to set line variables count to 0 for the CX Java code
1022: END IF;
1023:
1024: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1025: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130:End of '||l_package_procedure||' for line level variables, x_return_status ' || x_return_status);
1026: END IF;
1027: EXCEPTION
1028:
1021: x_line_variables_count := 0; -- Since no Lines, need to set line variables count to 0 for the CX Java code
1022: END IF;
1023:
1024: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1025: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130:End of '||l_package_procedure||' for line level variables, x_return_status ' || x_return_status);
1026: END IF;
1027: EXCEPTION
1028:
1029: WHEN FND_API.G_EXC_ERROR THEN
1033: END IF;
1034:
1035:
1036: x_return_status := FND_API.G_RET_STS_ERROR ;
1037: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1038: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: '||l_package_procedure||' In the FND_API.G_EXC_ERROR section');
1039: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'140: x_return_status = '||x_return_status);
1040: END IF;
1041:
1034:
1035:
1036: x_return_status := FND_API.G_RET_STS_ERROR ;
1037: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1038: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: '||l_package_procedure||' In the FND_API.G_EXC_ERROR section');
1039: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'140: x_return_status = '||x_return_status);
1040: END IF;
1041:
1042: FND_MSG_PUB.Count_And_Get(
1035:
1036: x_return_status := FND_API.G_RET_STS_ERROR ;
1037: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1038: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: '||l_package_procedure||' In the FND_API.G_EXC_ERROR section');
1039: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'140: x_return_status = '||x_return_status);
1040: END IF;
1041:
1042: FND_MSG_PUB.Count_And_Get(
1043: p_count => x_msg_count,
1049: END IF;
1050:
1051:
1052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1053: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1054: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: '||l_package_procedure||' In the FND_API.G_EXC_UNEXPECTED_ERROR section');
1055: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: x_return_status = '||x_return_status);
1056: END IF;
1057:
1050:
1051:
1052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1053: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1054: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: '||l_package_procedure||' In the FND_API.G_EXC_UNEXPECTED_ERROR section');
1055: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: x_return_status = '||x_return_status);
1056: END IF;
1057:
1058: FND_MSG_PUB.Count_And_Get(
1051:
1052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1053: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1054: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: '||l_package_procedure||' In the FND_API.G_EXC_UNEXPECTED_ERROR section');
1055: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: x_return_status = '||x_return_status);
1056: END IF;
1057:
1058: FND_MSG_PUB.Count_And_Get(
1059: p_count => x_msg_count,
1064: CLOSE c_get_quote_line_variables;
1065: END IF;
1066:
1067: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1068: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1069: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: '||l_package_procedure||' In the OTHERS section');
1070: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: x_return_status = '||x_return_status);
1071: END IF;
1072:
1065: END IF;
1066:
1067: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1068: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1069: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: '||l_package_procedure||' In the OTHERS section');
1070: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: x_return_status = '||x_return_status);
1071: END IF;
1072:
1073: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1066:
1067: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1068: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1069: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: '||l_package_procedure||' In the OTHERS section');
1070: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: x_return_status = '||x_return_status);
1071: END IF;
1072:
1073: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1074: FND_MSG_PUB.Add_Exc_Msg(