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.ASO_MAP_QUOTE_ORDER_INT dependencies on ASO_DEBUG_PUB

Line 282: IF aso_debug_pub.g_debug_flag = 'Y' THEN

278: WHERE quote_header_id = l_header_id
279: AND quote_line_id IS NULL;
280:
281: BEGIN
282: IF aso_debug_pub.g_debug_flag = 'Y' THEN
283: aso_debug_pub.add('beginning of map_quote_to_order ', 1, 'Y');
284: END IF;
285:
286: -- initialize OM record types

Line 283: aso_debug_pub.add('beginning of map_quote_to_order ', 1, 'Y');

279: AND quote_line_id IS NULL;
280:
281: BEGIN
282: IF aso_debug_pub.g_debug_flag = 'Y' THEN
283: aso_debug_pub.add('beginning of map_quote_to_order ', 1, 'Y');
284: END IF;
285:
286: -- initialize OM record types
287:

Line 293: IF aso_debug_pub.g_debug_flag = 'Y' THEN

289: px_header_rec => l_header_rec,
290: px_line_tbl => l_line_tbl,
291: p_line_tbl_count => p_line_shipment_tbl.count
292: );
293: IF aso_debug_pub.g_debug_flag = 'Y' THEN
294: aso_debug_pub.add('initialized OM rec types ', 1, 'N');
295: END IF;
296:
297: l_header_rec.accounting_rule_id := p_qte_rec.accounting_rule_id;

Line 294: aso_debug_pub.add('initialized OM rec types ', 1, 'N');

290: px_line_tbl => l_line_tbl,
291: p_line_tbl_count => p_line_shipment_tbl.count
292: );
293: IF aso_debug_pub.g_debug_flag = 'Y' THEN
294: aso_debug_pub.add('initialized OM rec types ', 1, 'N');
295: END IF;
296:
297: l_header_rec.accounting_rule_id := p_qte_rec.accounting_rule_id;
298: l_header_rec.agreement_id:= p_qte_rec.contract_id;

Line 340: IF aso_debug_pub.g_debug_flag = 'Y' THEN

336: l_header_rec.Contract_Template_Id := p_qte_rec.Contract_Template_ID;
337: l_header_rec.Contract_Source_Doc_Type_Code := 'QUOTE';
338: l_header_rec.Contract_Source_Document_Id := p_qte_rec.quote_header_id;
339:
340: IF aso_debug_pub.g_debug_flag = 'Y' THEN
341: aso_debug_pub.add('Customer_Signature: '||l_header_rec.Customer_Signature,1,'Y');
342: aso_debug_pub.add('Customer_Signature_date: '||l_header_rec.Customer_Signature_date, 1, 'Y');
343: aso_debug_pub.add('Supplier_Signature: '||l_header_rec.Supplier_Signature, 1, 'Y');
344: aso_debug_pub.add('Supplier_Signature_date: '||l_header_rec.Supplier_Signature_date, 1, 'Y');

Line 341: aso_debug_pub.add('Customer_Signature: '||l_header_rec.Customer_Signature,1,'Y');

337: l_header_rec.Contract_Source_Doc_Type_Code := 'QUOTE';
338: l_header_rec.Contract_Source_Document_Id := p_qte_rec.quote_header_id;
339:
340: IF aso_debug_pub.g_debug_flag = 'Y' THEN
341: aso_debug_pub.add('Customer_Signature: '||l_header_rec.Customer_Signature,1,'Y');
342: aso_debug_pub.add('Customer_Signature_date: '||l_header_rec.Customer_Signature_date, 1, 'Y');
343: aso_debug_pub.add('Supplier_Signature: '||l_header_rec.Supplier_Signature, 1, 'Y');
344: aso_debug_pub.add('Supplier_Signature_date: '||l_header_rec.Supplier_Signature_date, 1, 'Y');
345: aso_debug_pub.add('Contract_Template_Id: '||l_header_rec.Contract_Template_Id, 1, 'Y');

Line 342: aso_debug_pub.add('Customer_Signature_date: '||l_header_rec.Customer_Signature_date, 1, 'Y');

338: l_header_rec.Contract_Source_Document_Id := p_qte_rec.quote_header_id;
339:
340: IF aso_debug_pub.g_debug_flag = 'Y' THEN
341: aso_debug_pub.add('Customer_Signature: '||l_header_rec.Customer_Signature,1,'Y');
342: aso_debug_pub.add('Customer_Signature_date: '||l_header_rec.Customer_Signature_date, 1, 'Y');
343: aso_debug_pub.add('Supplier_Signature: '||l_header_rec.Supplier_Signature, 1, 'Y');
344: aso_debug_pub.add('Supplier_Signature_date: '||l_header_rec.Supplier_Signature_date, 1, 'Y');
345: aso_debug_pub.add('Contract_Template_Id: '||l_header_rec.Contract_Template_Id, 1, 'Y');
346: aso_debug_pub.add('Contract_Source_Doc_Type_Code: '||l_header_rec.Contract_Source_Doc_Type_Code, 1, 'Y');

Line 343: aso_debug_pub.add('Supplier_Signature: '||l_header_rec.Supplier_Signature, 1, 'Y');

339:
340: IF aso_debug_pub.g_debug_flag = 'Y' THEN
341: aso_debug_pub.add('Customer_Signature: '||l_header_rec.Customer_Signature,1,'Y');
342: aso_debug_pub.add('Customer_Signature_date: '||l_header_rec.Customer_Signature_date, 1, 'Y');
343: aso_debug_pub.add('Supplier_Signature: '||l_header_rec.Supplier_Signature, 1, 'Y');
344: aso_debug_pub.add('Supplier_Signature_date: '||l_header_rec.Supplier_Signature_date, 1, 'Y');
345: aso_debug_pub.add('Contract_Template_Id: '||l_header_rec.Contract_Template_Id, 1, 'Y');
346: aso_debug_pub.add('Contract_Source_Doc_Type_Code: '||l_header_rec.Contract_Source_Doc_Type_Code, 1, 'Y');
347: aso_debug_pub.add('Contract_Source_Document_Id: '||l_header_rec.Contract_Source_Document_Id, 1, 'Y');

Line 344: aso_debug_pub.add('Supplier_Signature_date: '||l_header_rec.Supplier_Signature_date, 1, 'Y');

340: IF aso_debug_pub.g_debug_flag = 'Y' THEN
341: aso_debug_pub.add('Customer_Signature: '||l_header_rec.Customer_Signature,1,'Y');
342: aso_debug_pub.add('Customer_Signature_date: '||l_header_rec.Customer_Signature_date, 1, 'Y');
343: aso_debug_pub.add('Supplier_Signature: '||l_header_rec.Supplier_Signature, 1, 'Y');
344: aso_debug_pub.add('Supplier_Signature_date: '||l_header_rec.Supplier_Signature_date, 1, 'Y');
345: aso_debug_pub.add('Contract_Template_Id: '||l_header_rec.Contract_Template_Id, 1, 'Y');
346: aso_debug_pub.add('Contract_Source_Doc_Type_Code: '||l_header_rec.Contract_Source_Doc_Type_Code, 1, 'Y');
347: aso_debug_pub.add('Contract_Source_Document_Id: '||l_header_rec.Contract_Source_Document_Id, 1, 'Y');
348: END IF;

Line 345: aso_debug_pub.add('Contract_Template_Id: '||l_header_rec.Contract_Template_Id, 1, 'Y');

341: aso_debug_pub.add('Customer_Signature: '||l_header_rec.Customer_Signature,1,'Y');
342: aso_debug_pub.add('Customer_Signature_date: '||l_header_rec.Customer_Signature_date, 1, 'Y');
343: aso_debug_pub.add('Supplier_Signature: '||l_header_rec.Supplier_Signature, 1, 'Y');
344: aso_debug_pub.add('Supplier_Signature_date: '||l_header_rec.Supplier_Signature_date, 1, 'Y');
345: aso_debug_pub.add('Contract_Template_Id: '||l_header_rec.Contract_Template_Id, 1, 'Y');
346: aso_debug_pub.add('Contract_Source_Doc_Type_Code: '||l_header_rec.Contract_Source_Doc_Type_Code, 1, 'Y');
347: aso_debug_pub.add('Contract_Source_Document_Id: '||l_header_rec.Contract_Source_Document_Id, 1, 'Y');
348: END IF;
349:

Line 346: aso_debug_pub.add('Contract_Source_Doc_Type_Code: '||l_header_rec.Contract_Source_Doc_Type_Code, 1, 'Y');

342: aso_debug_pub.add('Customer_Signature_date: '||l_header_rec.Customer_Signature_date, 1, 'Y');
343: aso_debug_pub.add('Supplier_Signature: '||l_header_rec.Supplier_Signature, 1, 'Y');
344: aso_debug_pub.add('Supplier_Signature_date: '||l_header_rec.Supplier_Signature_date, 1, 'Y');
345: aso_debug_pub.add('Contract_Template_Id: '||l_header_rec.Contract_Template_Id, 1, 'Y');
346: aso_debug_pub.add('Contract_Source_Doc_Type_Code: '||l_header_rec.Contract_Source_Doc_Type_Code, 1, 'Y');
347: aso_debug_pub.add('Contract_Source_Document_Id: '||l_header_rec.Contract_Source_Document_Id, 1, 'Y');
348: END IF;
349:
350: -- end of hyang new okc

Line 347: aso_debug_pub.add('Contract_Source_Document_Id: '||l_header_rec.Contract_Source_Document_Id, 1, 'Y');

343: aso_debug_pub.add('Supplier_Signature: '||l_header_rec.Supplier_Signature, 1, 'Y');
344: aso_debug_pub.add('Supplier_Signature_date: '||l_header_rec.Supplier_Signature_date, 1, 'Y');
345: aso_debug_pub.add('Contract_Template_Id: '||l_header_rec.Contract_Template_Id, 1, 'Y');
346: aso_debug_pub.add('Contract_Source_Doc_Type_Code: '||l_header_rec.Contract_Source_Doc_Type_Code, 1, 'Y');
347: aso_debug_pub.add('Contract_Source_Document_Id: '||l_header_rec.Contract_Source_Document_Id, 1, 'Y');
348: END IF;
349:
350: -- end of hyang new okc
351:

Line 358: IF aso_debug_pub.g_debug_flag = 'Y' THEN

354:
355: l_header_rec.conversion_rate_date := p_qte_rec.exchange_rate_date ;
356: l_header_rec.conversion_type_code := p_qte_rec.exchange_type_code ;
357:
358: IF aso_debug_pub.g_debug_flag = 'Y' THEN
359: aso_debug_pub.add('before functional currency'||p_qte_rec.currency_code,1,'N');
360: aso_debug_pub.add('set of books id prof: '||l_set_of_books_id, 1, 'N');
361: aso_debug_pub.add('conversion type prof: '||l_conversion_type, 1, 'N');
362: END IF;

Line 359: aso_debug_pub.add('before functional currency'||p_qte_rec.currency_code,1,'N');

355: l_header_rec.conversion_rate_date := p_qte_rec.exchange_rate_date ;
356: l_header_rec.conversion_type_code := p_qte_rec.exchange_type_code ;
357:
358: IF aso_debug_pub.g_debug_flag = 'Y' THEN
359: aso_debug_pub.add('before functional currency'||p_qte_rec.currency_code,1,'N');
360: aso_debug_pub.add('set of books id prof: '||l_set_of_books_id, 1, 'N');
361: aso_debug_pub.add('conversion type prof: '||l_conversion_type, 1, 'N');
362: END IF;
363:

Line 360: aso_debug_pub.add('set of books id prof: '||l_set_of_books_id, 1, 'N');

356: l_header_rec.conversion_type_code := p_qte_rec.exchange_type_code ;
357:
358: IF aso_debug_pub.g_debug_flag = 'Y' THEN
359: aso_debug_pub.add('before functional currency'||p_qte_rec.currency_code,1,'N');
360: aso_debug_pub.add('set of books id prof: '||l_set_of_books_id, 1, 'N');
361: aso_debug_pub.add('conversion type prof: '||l_conversion_type, 1, 'N');
362: END IF;
363:
364: -- vtariker: 3057860: overriding profile value if value is passed in hdr

Line 361: aso_debug_pub.add('conversion type prof: '||l_conversion_type, 1, 'N');

357:
358: IF aso_debug_pub.g_debug_flag = 'Y' THEN
359: aso_debug_pub.add('before functional currency'||p_qte_rec.currency_code,1,'N');
360: aso_debug_pub.add('set of books id prof: '||l_set_of_books_id, 1, 'N');
361: aso_debug_pub.add('conversion type prof: '||l_conversion_type, 1, 'N');
362: END IF;
363:
364: -- vtariker: 3057860: overriding profile value if value is passed in hdr
365: IF l_header_rec.conversion_type_code IS NOT NULL OR

Line 426: IF aso_debug_pub.g_debug_flag = 'Y' THEN

422:
423: END IF; -- conversion
424: END IF; -- currency code not null
425:
426: IF aso_debug_pub.g_debug_flag = 'Y' THEN
427: aso_debug_pub.add('l_header_rec.conversion_rate: '||l_header_rec.conversion_rate,1,'N');
428: aso_debug_pub.add('l_header_rec.conversion_rate_date: '||l_header_rec.conversion_rate_date,1,'N');
429: aso_debug_pub.add('l_header_rec.conversion_type_code: '||l_header_rec.conversion_type_code,1,'N');
430: aso_debug_pub.add('before customer account ', 1, 'Y' );

Line 427: aso_debug_pub.add('l_header_rec.conversion_rate: '||l_header_rec.conversion_rate,1,'N');

423: END IF; -- conversion
424: END IF; -- currency code not null
425:
426: IF aso_debug_pub.g_debug_flag = 'Y' THEN
427: aso_debug_pub.add('l_header_rec.conversion_rate: '||l_header_rec.conversion_rate,1,'N');
428: aso_debug_pub.add('l_header_rec.conversion_rate_date: '||l_header_rec.conversion_rate_date,1,'N');
429: aso_debug_pub.add('l_header_rec.conversion_type_code: '||l_header_rec.conversion_type_code,1,'N');
430: aso_debug_pub.add('before customer account ', 1, 'Y' );
431: END IF;

Line 428: aso_debug_pub.add('l_header_rec.conversion_rate_date: '||l_header_rec.conversion_rate_date,1,'N');

424: END IF; -- currency code not null
425:
426: IF aso_debug_pub.g_debug_flag = 'Y' THEN
427: aso_debug_pub.add('l_header_rec.conversion_rate: '||l_header_rec.conversion_rate,1,'N');
428: aso_debug_pub.add('l_header_rec.conversion_rate_date: '||l_header_rec.conversion_rate_date,1,'N');
429: aso_debug_pub.add('l_header_rec.conversion_type_code: '||l_header_rec.conversion_type_code,1,'N');
430: aso_debug_pub.add('before customer account ', 1, 'Y' );
431: END IF;
432:

Line 429: aso_debug_pub.add('l_header_rec.conversion_type_code: '||l_header_rec.conversion_type_code,1,'N');

425:
426: IF aso_debug_pub.g_debug_flag = 'Y' THEN
427: aso_debug_pub.add('l_header_rec.conversion_rate: '||l_header_rec.conversion_rate,1,'N');
428: aso_debug_pub.add('l_header_rec.conversion_rate_date: '||l_header_rec.conversion_rate_date,1,'N');
429: aso_debug_pub.add('l_header_rec.conversion_type_code: '||l_header_rec.conversion_type_code,1,'N');
430: aso_debug_pub.add('before customer account ', 1, 'Y' );
431: END IF;
432:
433: IF p_qte_rec.cust_account_id is not NULL

Line 430: aso_debug_pub.add('before customer account ', 1, 'Y' );

426: IF aso_debug_pub.g_debug_flag = 'Y' THEN
427: aso_debug_pub.add('l_header_rec.conversion_rate: '||l_header_rec.conversion_rate,1,'N');
428: aso_debug_pub.add('l_header_rec.conversion_rate_date: '||l_header_rec.conversion_rate_date,1,'N');
429: aso_debug_pub.add('l_header_rec.conversion_type_code: '||l_header_rec.conversion_type_code,1,'N');
430: aso_debug_pub.add('before customer account ', 1, 'Y' );
431: END IF;
432:
433: IF p_qte_rec.cust_account_id is not NULL
434: AND p_qte_rec.cust_account_id <> FND_API.G_MISS_NUM THEN

Line 437: IF aso_debug_pub.g_debug_flag = 'Y' THEN

433: IF p_qte_rec.cust_account_id is not NULL
434: AND p_qte_rec.cust_account_id <> FND_API.G_MISS_NUM THEN
435: l_header_rec.sold_to_org_id := p_qte_rec.cust_account_id;
436: l_cust_account_id := p_qte_rec.cust_account_id;
437: IF aso_debug_pub.g_debug_flag = 'Y' THEN
438: aso_debug_pub.add('validating cust account ' || l_cust_account_id || 'for party' || p_qte_rec.party_id, 1, 'N');
439: END IF;
440: ASO_PARTY_INT.Validate_CustAccount (
441: p_init_msg_list => FND_API.G_FALSE,

Line 438: aso_debug_pub.add('validating cust account ' || l_cust_account_id || 'for party' || p_qte_rec.party_id, 1, 'N');

434: AND p_qte_rec.cust_account_id <> FND_API.G_MISS_NUM THEN
435: l_header_rec.sold_to_org_id := p_qte_rec.cust_account_id;
436: l_cust_account_id := p_qte_rec.cust_account_id;
437: IF aso_debug_pub.g_debug_flag = 'Y' THEN
438: aso_debug_pub.add('validating cust account ' || l_cust_account_id || 'for party' || p_qte_rec.party_id, 1, 'N');
439: END IF;
440: ASO_PARTY_INT.Validate_CustAccount (
441: p_init_msg_list => FND_API.G_FALSE,
442: p_party_id => p_qte_rec.party_id,

Line 447: IF aso_debug_pub.g_debug_flag = 'Y' THEN

443: p_cust_account_id=> l_cust_account_id,
444: x_return_status => l_return_status,
445: x_msg_count => l_msg_count,
446: x_msg_data => l_msg_data);
447: IF aso_debug_pub.g_debug_flag = 'Y' THEN
448: aso_debug_pub.add(' done validating customer.return status = ' || l_return_status ,1, 'Y');
449: END IF;
450: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
451: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 448: aso_debug_pub.add(' done validating customer.return status = ' || l_return_status ,1, 'Y');

444: x_return_status => l_return_status,
445: x_msg_count => l_msg_count,
446: x_msg_data => l_msg_data);
447: IF aso_debug_pub.g_debug_flag = 'Y' THEN
448: aso_debug_pub.add(' done validating customer.return status = ' || l_return_status ,1, 'Y');
449: END IF;
450: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
451: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
452: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');

Line 462: IF aso_debug_pub.g_debug_flag = 'Y' THEN

458: ELSE
459: IF p_operation = 'CREATE' THEN
460: IF p_qte_rec.party_id is not NULL
461: AND p_qte_rec.party_id <> FND_API.G_MISS_NUM THEN
462: IF aso_debug_pub.g_debug_flag = 'Y' THEN
463: aso_debug_pub.add('deriving cust account id:p_qte_rec.party_id: '||p_qte_rec.party_id, 1, 'N');
464: END IF;
465: ASO_CHECK_TCA_PVT.Customer_Account(
466: p_api_version => 1.0,

Line 463: aso_debug_pub.add('deriving cust account id:p_qte_rec.party_id: '||p_qte_rec.party_id, 1, 'N');

459: IF p_operation = 'CREATE' THEN
460: IF p_qte_rec.party_id is not NULL
461: AND p_qte_rec.party_id <> FND_API.G_MISS_NUM THEN
462: IF aso_debug_pub.g_debug_flag = 'Y' THEN
463: aso_debug_pub.add('deriving cust account id:p_qte_rec.party_id: '||p_qte_rec.party_id, 1, 'N');
464: END IF;
465: ASO_CHECK_TCA_PVT.Customer_Account(
466: p_api_version => 1.0,
467: p_Party_Id => p_qte_rec.party_id,

Line 483: IF aso_debug_pub.g_debug_flag = 'Y' THEN

479: FND_MSG_PUB.ADD;
480: END IF;
481: raise FND_API.G_EXC_ERROR;
482: END IF;
483: IF aso_debug_pub.g_debug_flag = 'Y' THEN
484: aso_debug_pub.add('Cust_Accnt_Id in'||l_cust_account_id, 1, 'N');
485: END IF;
486: -- update quote header if account is created
487: IF upper(p_qte_rec.quote_source_code) = 'ORDER CAPTURE QUOTES' THEN

Line 484: aso_debug_pub.add('Cust_Accnt_Id in'||l_cust_account_id, 1, 'N');

480: END IF;
481: raise FND_API.G_EXC_ERROR;
482: END IF;
483: IF aso_debug_pub.g_debug_flag = 'Y' THEN
484: aso_debug_pub.add('Cust_Accnt_Id in'||l_cust_account_id, 1, 'N');
485: END IF;
486: -- update quote header if account is created
487: IF upper(p_qte_rec.quote_source_code) = 'ORDER CAPTURE QUOTES' THEN
488: UPDATE ASO_QUOTE_HEADERS_ALL

Line 502: IF aso_debug_pub.g_debug_flag = 'Y' THEN

498: l_header_rec.sold_to_org_id := l_cust_account_id;
499: END IF;
500: END IF;
501: IF p_operation = 'UPDATE' THEN
502: IF aso_debug_pub.g_debug_flag = 'Y' THEN
503: aso_debug_pub.add('before query = ' || p_qte_rec.order_id , 1, 'Y');
504: END IF;
505: OPEN get_cust_account_id(p_qte_rec.order_id);
506: FETCH get_cust_account_id INTO l_header_rec.sold_to_org_id;

Line 503: aso_debug_pub.add('before query = ' || p_qte_rec.order_id , 1, 'Y');

499: END IF;
500: END IF;
501: IF p_operation = 'UPDATE' THEN
502: IF aso_debug_pub.g_debug_flag = 'Y' THEN
503: aso_debug_pub.add('before query = ' || p_qte_rec.order_id , 1, 'Y');
504: END IF;
505: OPEN get_cust_account_id(p_qte_rec.order_id);
506: FETCH get_cust_account_id INTO l_header_rec.sold_to_org_id;
507: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 507: IF aso_debug_pub.g_debug_flag = 'Y' THEN

503: aso_debug_pub.add('before query = ' || p_qte_rec.order_id , 1, 'Y');
504: END IF;
505: OPEN get_cust_account_id(p_qte_rec.order_id);
506: FETCH get_cust_account_id INTO l_header_rec.sold_to_org_id;
507: IF aso_debug_pub.g_debug_flag = 'Y' THEN
508: aso_debug_pub.add('after query = ' || l_header_rec.sold_to_org_id, 1, 'Y');
509: END IF;
510: CLOSE get_cust_account_id;
511: IF l_header_rec.sold_to_org_id is NULL THEN

Line 508: aso_debug_pub.add('after query = ' || l_header_rec.sold_to_org_id, 1, 'Y');

504: END IF;
505: OPEN get_cust_account_id(p_qte_rec.order_id);
506: FETCH get_cust_account_id INTO l_header_rec.sold_to_org_id;
507: IF aso_debug_pub.g_debug_flag = 'Y' THEN
508: aso_debug_pub.add('after query = ' || l_header_rec.sold_to_org_id, 1, 'Y');
509: END IF;
510: CLOSE get_cust_account_id;
511: IF l_header_rec.sold_to_org_id is NULL THEN
512: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 526: IF aso_debug_pub.g_debug_flag = 'Y' THEN

522:
523: IF p_qte_rec.invoice_to_cust_account_id <> FND_API.G_MISS_NUM AND
524: p_qte_rec.invoice_to_cust_account_id IS NOT NULL AND
525: p_qte_rec.invoice_to_cust_account_id <> l_cust_account_id THEN
526: IF aso_debug_pub.g_debug_flag = 'Y' THEN
527: aso_debug_pub.add('before cust_acct_reltn:p_sold_to_cust_account: '||l_cust_account_id, 1, 'N');
528: aso_debug_pub.add('before cust_acct_reltn:p_related_cust_account: '||p_qte_rec.invoice_to_cust_account_id, 1, 'N');
529: END IF;
530: ASO_CHECK_TCA_PVT.Cust_acct_Relationship (

Line 527: aso_debug_pub.add('before cust_acct_reltn:p_sold_to_cust_account: '||l_cust_account_id, 1, 'N');

523: IF p_qte_rec.invoice_to_cust_account_id <> FND_API.G_MISS_NUM AND
524: p_qte_rec.invoice_to_cust_account_id IS NOT NULL AND
525: p_qte_rec.invoice_to_cust_account_id <> l_cust_account_id THEN
526: IF aso_debug_pub.g_debug_flag = 'Y' THEN
527: aso_debug_pub.add('before cust_acct_reltn:p_sold_to_cust_account: '||l_cust_account_id, 1, 'N');
528: aso_debug_pub.add('before cust_acct_reltn:p_related_cust_account: '||p_qte_rec.invoice_to_cust_account_id, 1, 'N');
529: END IF;
530: ASO_CHECK_TCA_PVT.Cust_acct_Relationship (
531: p_api_version => 1.0,

Line 528: aso_debug_pub.add('before cust_acct_reltn:p_related_cust_account: '||p_qte_rec.invoice_to_cust_account_id, 1, 'N');

524: p_qte_rec.invoice_to_cust_account_id IS NOT NULL AND
525: p_qte_rec.invoice_to_cust_account_id <> l_cust_account_id THEN
526: IF aso_debug_pub.g_debug_flag = 'Y' THEN
527: aso_debug_pub.add('before cust_acct_reltn:p_sold_to_cust_account: '||l_cust_account_id, 1, 'N');
528: aso_debug_pub.add('before cust_acct_reltn:p_related_cust_account: '||p_qte_rec.invoice_to_cust_account_id, 1, 'N');
529: END IF;
530: ASO_CHECK_TCA_PVT.Cust_acct_Relationship (
531: p_api_version => 1.0,
532: p_sold_to_cust_account => l_cust_account_id,

Line 539: IF aso_debug_pub.g_debug_flag = 'Y' THEN

535: x_return_status => l_return_status,
536: x_msg_count => l_msg_count,
537: x_msg_data => l_msg_data
538: );
539: IF aso_debug_pub.g_debug_flag = 'Y' THEN
540: aso_debug_pub.add('after cust_acct_reltn:l_return_status: '||l_return_status, 1, 'N');
541: END IF;
542: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
543: RAISE FND_API.G_EXC_ERROR;

Line 540: aso_debug_pub.add('after cust_acct_reltn:l_return_status: '||l_return_status, 1, 'N');

536: x_msg_count => l_msg_count,
537: x_msg_data => l_msg_data
538: );
539: IF aso_debug_pub.g_debug_flag = 'Y' THEN
540: aso_debug_pub.add('after cust_acct_reltn:l_return_status: '||l_return_status, 1, 'N');
541: END IF;
542: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
543: RAISE FND_API.G_EXC_ERROR;
544: END IF;

Line 548: IF aso_debug_pub.g_debug_flag = 'Y' THEN

544: END IF;
545:
546: END IF;
547:
548: IF aso_debug_pub.g_debug_flag = 'Y' THEN
549: aso_debug_pub.add('before org contact', 1, 'N');
550: aso_debug_pub.add('p_qte_rec.org_contact_id: ' || p_qte_rec.org_contact_id,1, 'N');
551: END IF;
552: IF p_qte_rec.party_id is not null and

Line 549: aso_debug_pub.add('before org contact', 1, 'N');

545:
546: END IF;
547:
548: IF aso_debug_pub.g_debug_flag = 'Y' THEN
549: aso_debug_pub.add('before org contact', 1, 'N');
550: aso_debug_pub.add('p_qte_rec.org_contact_id: ' || p_qte_rec.org_contact_id,1, 'N');
551: END IF;
552: IF p_qte_rec.party_id is not null and
553: p_qte_rec.party_id <> FND_API.G_MISS_NUM THEN

Line 550: aso_debug_pub.add('p_qte_rec.org_contact_id: ' || p_qte_rec.org_contact_id,1, 'N');

546: END IF;
547:
548: IF aso_debug_pub.g_debug_flag = 'Y' THEN
549: aso_debug_pub.add('before org contact', 1, 'N');
550: aso_debug_pub.add('p_qte_rec.org_contact_id: ' || p_qte_rec.org_contact_id,1, 'N');
551: END IF;
552: IF p_qte_rec.party_id is not null and
553: p_qte_rec.party_id <> FND_API.G_MISS_NUM THEN
554:

Line 564: IF aso_debug_pub.g_debug_flag = 'Y' THEN

560: ELSE
561: l_org_contact := p_qte_rec.org_contact_id;
562: END IF;
563:
564: IF aso_debug_pub.g_debug_flag = 'Y' THEN
565: aso_debug_pub.add('l_org_contact: ' || l_org_contact,1, 'N');
566: END IF;
567: IF l_org_contact is not NULL AND
568: l_org_contact <> FND_API.G_MISS_NUM THEN

Line 565: aso_debug_pub.add('l_org_contact: ' || l_org_contact,1, 'N');

561: l_org_contact := p_qte_rec.org_contact_id;
562: END IF;
563:
564: IF aso_debug_pub.g_debug_flag = 'Y' THEN
565: aso_debug_pub.add('l_org_contact: ' || l_org_contact,1, 'N');
566: END IF;
567: IF l_org_contact is not NULL AND
568: l_org_contact <> FND_API.G_MISS_NUM THEN
569: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 569: IF aso_debug_pub.g_debug_flag = 'Y' THEN

565: aso_debug_pub.add('l_org_contact: ' || l_org_contact,1, 'N');
566: END IF;
567: IF l_org_contact is not NULL AND
568: l_org_contact <> FND_API.G_MISS_NUM THEN
569: IF aso_debug_pub.g_debug_flag = 'Y' THEN
570: aso_debug_pub.add('deriving org_contact_role:l_header_rec.sold_to_org_id: ' || l_header_rec.sold_to_org_id,1, 'N');
571: END IF;
572: get_org_contact_role(
573: p_Org_Contact_Id => l_org_contact

Line 570: aso_debug_pub.add('deriving org_contact_role:l_header_rec.sold_to_org_id: ' || l_header_rec.sold_to_org_id,1, 'N');

566: END IF;
567: IF l_org_contact is not NULL AND
568: l_org_contact <> FND_API.G_MISS_NUM THEN
569: IF aso_debug_pub.g_debug_flag = 'Y' THEN
570: aso_debug_pub.add('deriving org_contact_role:l_header_rec.sold_to_org_id: ' || l_header_rec.sold_to_org_id,1, 'N');
571: END IF;
572: get_org_contact_role(
573: p_Org_Contact_Id => l_org_contact
574: ,p_Cust_account_id => l_header_rec.sold_to_org_id

Line 579: IF aso_debug_pub.g_debug_flag = 'Y' THEN

575: ,x_return_status => l_return_status
576: ,x_party_id => l_org_contact_party_id
577: ,x_cust_account_role_id => l_header_rec.sold_to_contact_id
578: );
579: IF aso_debug_pub.g_debug_flag = 'Y' THEN
580: aso_debug_pub.add('after get org contact. sold_to_contact_id = ' || l_header_rec.sold_to_contact_id ,1, 'N');
581: END IF;
582: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
583: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 580: aso_debug_pub.add('after get org contact. sold_to_contact_id = ' || l_header_rec.sold_to_contact_id ,1, 'N');

576: ,x_party_id => l_org_contact_party_id
577: ,x_cust_account_role_id => l_header_rec.sold_to_contact_id
578: );
579: IF aso_debug_pub.g_debug_flag = 'Y' THEN
580: aso_debug_pub.add('after get org contact. sold_to_contact_id = ' || l_header_rec.sold_to_contact_id ,1, 'N');
581: END IF;
582: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
583: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
584: THEN

Line 593: IF aso_debug_pub.g_debug_flag = 'Y' THEN

589: END IF;
590:
591: IF l_header_rec.sold_to_contact_id is NULL OR
592: l_header_rec.sold_to_contact_id = FND_API.G_MISS_NUM THEN
593: IF aso_debug_pub.g_debug_flag = 'Y' THEN
594: aso_debug_pub.add('calling create contact role for org contact:l_org_contact_party_id: '||l_org_contact_party_id,1, 'N');
595: aso_debug_pub.add('calling create contact role for org contact:l_header_rec.sold_to_org_id: '||l_header_rec.sold_to_org_id,1, 'N');
596: END IF;
597: ASO_PARTY_INT.Create_Contact_Role (

Line 594: aso_debug_pub.add('calling create contact role for org contact:l_org_contact_party_id: '||l_org_contact_party_id,1, 'N');

590:
591: IF l_header_rec.sold_to_contact_id is NULL OR
592: l_header_rec.sold_to_contact_id = FND_API.G_MISS_NUM THEN
593: IF aso_debug_pub.g_debug_flag = 'Y' THEN
594: aso_debug_pub.add('calling create contact role for org contact:l_org_contact_party_id: '||l_org_contact_party_id,1, 'N');
595: aso_debug_pub.add('calling create contact role for org contact:l_header_rec.sold_to_org_id: '||l_header_rec.sold_to_org_id,1, 'N');
596: END IF;
597: ASO_PARTY_INT.Create_Contact_Role (
598: p_api_version => 1.0

Line 595: aso_debug_pub.add('calling create contact role for org contact:l_header_rec.sold_to_org_id: '||l_header_rec.sold_to_org_id,1, 'N');

591: IF l_header_rec.sold_to_contact_id is NULL OR
592: l_header_rec.sold_to_contact_id = FND_API.G_MISS_NUM THEN
593: IF aso_debug_pub.g_debug_flag = 'Y' THEN
594: aso_debug_pub.add('calling create contact role for org contact:l_org_contact_party_id: '||l_org_contact_party_id,1, 'N');
595: aso_debug_pub.add('calling create contact role for org contact:l_header_rec.sold_to_org_id: '||l_header_rec.sold_to_org_id,1, 'N');
596: END IF;
597: ASO_PARTY_INT.Create_Contact_Role (
598: p_api_version => 1.0
599: ,p_party_id =>l_org_contact_party_id

Line 606: IF aso_debug_pub.g_debug_flag = 'Y' THEN

602: ,x_msg_count => l_msg_count
603: ,x_msg_data => l_msg_data
604: ,x_cust_account_role_id => l_header_rec.sold_to_contact_id
605: );
606: IF aso_debug_pub.g_debug_flag = 'Y' THEN
607: aso_debug_pub.add('after create contact role. sold_to_contact_id = ' || l_header_rec.sold_to_contact_id ,1, 'Y');
608: END IF;
609: IF L_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
610: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 607: aso_debug_pub.add('after create contact role. sold_to_contact_id = ' || l_header_rec.sold_to_contact_id ,1, 'Y');

603: ,x_msg_data => l_msg_data
604: ,x_cust_account_role_id => l_header_rec.sold_to_contact_id
605: );
606: IF aso_debug_pub.g_debug_flag = 'Y' THEN
607: aso_debug_pub.add('after create contact role. sold_to_contact_id = ' || l_header_rec.sold_to_contact_id ,1, 'Y');
608: END IF;
609: IF L_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
610: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
611: THEN

Line 622: IF aso_debug_pub.g_debug_flag = 'Y' THEN

618: END IF;
619: END IF;
620: END IF;
621:
622: IF aso_debug_pub.g_debug_flag = 'Y' THEN
623: aso_debug_pub.add('invoice_to_cust_account = ' || p_qte_rec.invoice_to_cust_account_id,1,'N');
624: END IF;
625: IF p_qte_rec.invoice_to_cust_account_id is not NULL AND
626: p_qte_rec.invoice_to_cust_account_id <> FND_API.G_MISS_NUM THEN

Line 623: aso_debug_pub.add('invoice_to_cust_account = ' || p_qte_rec.invoice_to_cust_account_id,1,'N');

619: END IF;
620: END IF;
621:
622: IF aso_debug_pub.g_debug_flag = 'Y' THEN
623: aso_debug_pub.add('invoice_to_cust_account = ' || p_qte_rec.invoice_to_cust_account_id,1,'N');
624: END IF;
625: IF p_qte_rec.invoice_to_cust_account_id is not NULL AND
626: p_qte_rec.invoice_to_cust_account_id <> FND_API.G_MISS_NUM THEN
627: l_invoice_cust_account_id := p_qte_rec.invoice_to_cust_account_id;

Line 632: IF aso_debug_pub.g_debug_flag = 'Y' THEN

628: ELSE
629: l_invoice_cust_account_id := l_header_rec.sold_to_org_id;
630: END IF;
631:
632: IF aso_debug_pub.g_debug_flag = 'Y' THEN
633: aso_debug_pub.add('l_invoice_cust_acccount_id = ' || l_invoice_cust_account_id,1,'N' );
634: aso_debug_pub.add('before invoice to party site id '|| p_qte_rec.invoice_to_party_site_id, 1, 'Y');
635: END IF;
636: IF p_qte_rec.invoice_to_party_site_id is not NULL

Line 633: aso_debug_pub.add('l_invoice_cust_acccount_id = ' || l_invoice_cust_account_id,1,'N' );

629: l_invoice_cust_account_id := l_header_rec.sold_to_org_id;
630: END IF;
631:
632: IF aso_debug_pub.g_debug_flag = 'Y' THEN
633: aso_debug_pub.add('l_invoice_cust_acccount_id = ' || l_invoice_cust_account_id,1,'N' );
634: aso_debug_pub.add('before invoice to party site id '|| p_qte_rec.invoice_to_party_site_id, 1, 'Y');
635: END IF;
636: IF p_qte_rec.invoice_to_party_site_id is not NULL
637: AND p_qte_rec.invoice_to_party_site_id <> FND_API.G_MISS_NUM THEN

Line 634: aso_debug_pub.add('before invoice to party site id '|| p_qte_rec.invoice_to_party_site_id, 1, 'Y');

630: END IF;
631:
632: IF aso_debug_pub.g_debug_flag = 'Y' THEN
633: aso_debug_pub.add('l_invoice_cust_acccount_id = ' || l_invoice_cust_account_id,1,'N' );
634: aso_debug_pub.add('before invoice to party site id '|| p_qte_rec.invoice_to_party_site_id, 1, 'Y');
635: END IF;
636: IF p_qte_rec.invoice_to_party_site_id is not NULL
637: AND p_qte_rec.invoice_to_party_site_id <> FND_API.G_MISS_NUM THEN
638:

Line 655: IF aso_debug_pub.g_debug_flag = 'Y' THEN

651:
652: IF l_header_rec.invoice_to_org_id IS NULL THEN
653: l_header_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
654: END IF;
655: IF aso_debug_pub.g_debug_flag = 'Y' THEN
656: aso_debug_pub.add('site_use_id after deriving invoice = ' || l_header_rec.invoice_to_org_id,1,'Y');
657: aso_debug_pub.add('inv_acct_site after deriving invoice = ' || l_hd_inv_cust_acct_site,1,'Y');
658: END IF;
659: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 656: aso_debug_pub.add('site_use_id after deriving invoice = ' || l_header_rec.invoice_to_org_id,1,'Y');

652: IF l_header_rec.invoice_to_org_id IS NULL THEN
653: l_header_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
654: END IF;
655: IF aso_debug_pub.g_debug_flag = 'Y' THEN
656: aso_debug_pub.add('site_use_id after deriving invoice = ' || l_header_rec.invoice_to_org_id,1,'Y');
657: aso_debug_pub.add('inv_acct_site after deriving invoice = ' || l_hd_inv_cust_acct_site,1,'Y');
658: END IF;
659: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
660: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 657: aso_debug_pub.add('inv_acct_site after deriving invoice = ' || l_hd_inv_cust_acct_site,1,'Y');

653: l_header_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
654: END IF;
655: IF aso_debug_pub.g_debug_flag = 'Y' THEN
656: aso_debug_pub.add('site_use_id after deriving invoice = ' || l_header_rec.invoice_to_org_id,1,'Y');
657: aso_debug_pub.add('inv_acct_site after deriving invoice = ' || l_hd_inv_cust_acct_site,1,'Y');
658: END IF;
659: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
660: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
661: THEN

Line 670: IF aso_debug_pub.g_debug_flag = 'Y' THEN

666: END IF;
667:
668: END IF;
669:
670: IF aso_debug_pub.g_debug_flag = 'Y' THEN
671: aso_debug_pub.add(' invoice_to_party = ' || p_qte_rec.invoice_to_party_id,1, 'N' );
672: aso_debug_pub.add(' invoice_to_party_Site = ' || p_qte_rec.invoice_to_party_site_id,1, 'N' );
673: aso_debug_pub.add('before Cust_Acct_Contact_Addr:l_invoice_cust_acccount = ' ||l_invoice_cust_account_id ,1,'Y');
674: END IF;

Line 671: aso_debug_pub.add(' invoice_to_party = ' || p_qte_rec.invoice_to_party_id,1, 'N' );

667:
668: END IF;
669:
670: IF aso_debug_pub.g_debug_flag = 'Y' THEN
671: aso_debug_pub.add(' invoice_to_party = ' || p_qte_rec.invoice_to_party_id,1, 'N' );
672: aso_debug_pub.add(' invoice_to_party_Site = ' || p_qte_rec.invoice_to_party_site_id,1, 'N' );
673: aso_debug_pub.add('before Cust_Acct_Contact_Addr:l_invoice_cust_acccount = ' ||l_invoice_cust_account_id ,1,'Y');
674: END IF;
675:

Line 672: aso_debug_pub.add(' invoice_to_party_Site = ' || p_qte_rec.invoice_to_party_site_id,1, 'N' );

668: END IF;
669:
670: IF aso_debug_pub.g_debug_flag = 'Y' THEN
671: aso_debug_pub.add(' invoice_to_party = ' || p_qte_rec.invoice_to_party_id,1, 'N' );
672: aso_debug_pub.add(' invoice_to_party_Site = ' || p_qte_rec.invoice_to_party_site_id,1, 'N' );
673: aso_debug_pub.add('before Cust_Acct_Contact_Addr:l_invoice_cust_acccount = ' ||l_invoice_cust_account_id ,1,'Y');
674: END IF;
675:
676: ASO_CHECK_TCA_PVT.Cust_Acct_Contact_Addr(

Line 673: aso_debug_pub.add('before Cust_Acct_Contact_Addr:l_invoice_cust_acccount = ' ||l_invoice_cust_account_id ,1,'Y');

669:
670: IF aso_debug_pub.g_debug_flag = 'Y' THEN
671: aso_debug_pub.add(' invoice_to_party = ' || p_qte_rec.invoice_to_party_id,1, 'N' );
672: aso_debug_pub.add(' invoice_to_party_Site = ' || p_qte_rec.invoice_to_party_site_id,1, 'N' );
673: aso_debug_pub.add('before Cust_Acct_Contact_Addr:l_invoice_cust_acccount = ' ||l_invoice_cust_account_id ,1,'Y');
674: END IF;
675:
676: ASO_CHECK_TCA_PVT.Cust_Acct_Contact_Addr(
677: p_api_version => 1.0,

Line 692: IF aso_debug_pub.g_debug_flag = 'Y' THEN

688: IF l_header_rec.invoice_to_contact_id IS NULL THEN
689: l_header_rec.invoice_to_contact_id := FND_API.G_MISS_NUM;
690: END IF;
691:
692: IF aso_debug_pub.g_debug_flag = 'Y' THEN
693: aso_debug_pub.add('mapq hd: after Cust_Acct_Contact_Addr:l_header_rec.invoice_to_contact_id: '||l_header_rec.invoice_to_contact_id,1,'N');
694: END IF;
695:
696: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 693: aso_debug_pub.add('mapq hd: after Cust_Acct_Contact_Addr:l_header_rec.invoice_to_contact_id: '||l_header_rec.invoice_to_contact_id,1,'N');

689: l_header_rec.invoice_to_contact_id := FND_API.G_MISS_NUM;
690: END IF;
691:
692: IF aso_debug_pub.g_debug_flag = 'Y' THEN
693: aso_debug_pub.add('mapq hd: after Cust_Acct_Contact_Addr:l_header_rec.invoice_to_contact_id: '||l_header_rec.invoice_to_contact_id,1,'N');
694: END IF;
695:
696: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
697: raise FND_API.G_EXC_ERROR;

Line 701: IF aso_debug_pub.g_debug_flag = 'Y' THEN

697: raise FND_API.G_EXC_ERROR;
698: END IF;
699:
700: -- end_cust
701: IF aso_debug_pub.g_debug_flag = 'Y' THEN
702: aso_debug_pub.add('End_Customer_cust_account = ' || p_qte_rec.End_Customer_cust_account_id,1,'N');
703: END IF;
704: IF p_qte_rec.End_Customer_cust_account_id is not NULL AND
705: p_qte_rec.End_Customer_cust_account_id <> FND_API.G_MISS_NUM THEN

Line 702: aso_debug_pub.add('End_Customer_cust_account = ' || p_qte_rec.End_Customer_cust_account_id,1,'N');

698: END IF;
699:
700: -- end_cust
701: IF aso_debug_pub.g_debug_flag = 'Y' THEN
702: aso_debug_pub.add('End_Customer_cust_account = ' || p_qte_rec.End_Customer_cust_account_id,1,'N');
703: END IF;
704: IF p_qte_rec.End_Customer_cust_account_id is not NULL AND
705: p_qte_rec.End_Customer_cust_account_id <> FND_API.G_MISS_NUM THEN
706: l_End_cust_account_id := p_qte_rec.End_Customer_cust_account_id;

Line 711: IF aso_debug_pub.g_debug_flag = 'Y' THEN

707: ELSE
708: l_End_cust_account_id := l_header_rec.sold_to_org_id;
709: END IF;
710:
711: IF aso_debug_pub.g_debug_flag = 'Y' THEN
712: aso_debug_pub.add('l_End_cust_acccount_id = ' || l_End_cust_account_id,1,'N' );
713: aso_debug_pub.add('before End_Customer party site id '|| p_qte_rec.End_Customer_party_site_id, 1, 'Y');
714: END IF;
715: IF p_qte_rec.End_Customer_party_site_id is not NULL

Line 712: aso_debug_pub.add('l_End_cust_acccount_id = ' || l_End_cust_account_id,1,'N' );

708: l_End_cust_account_id := l_header_rec.sold_to_org_id;
709: END IF;
710:
711: IF aso_debug_pub.g_debug_flag = 'Y' THEN
712: aso_debug_pub.add('l_End_cust_acccount_id = ' || l_End_cust_account_id,1,'N' );
713: aso_debug_pub.add('before End_Customer party site id '|| p_qte_rec.End_Customer_party_site_id, 1, 'Y');
714: END IF;
715: IF p_qte_rec.End_Customer_party_site_id is not NULL
716: AND p_qte_rec.End_Customer_party_site_id <> FND_API.G_MISS_NUM THEN

Line 713: aso_debug_pub.add('before End_Customer party site id '|| p_qte_rec.End_Customer_party_site_id, 1, 'Y');

709: END IF;
710:
711: IF aso_debug_pub.g_debug_flag = 'Y' THEN
712: aso_debug_pub.add('l_End_cust_acccount_id = ' || l_End_cust_account_id,1,'N' );
713: aso_debug_pub.add('before End_Customer party site id '|| p_qte_rec.End_Customer_party_site_id, 1, 'Y');
714: END IF;
715: IF p_qte_rec.End_Customer_party_site_id is not NULL
716: AND p_qte_rec.End_Customer_party_site_id <> FND_API.G_MISS_NUM THEN
717:

Line 734: IF aso_debug_pub.g_debug_flag = 'Y' THEN

730:
731: IF l_header_rec.End_Customer_Site_Use_Id IS NULL THEN
732: l_header_rec.End_Customer_Site_Use_Id := FND_API.G_MISS_NUM;
733: END IF;
734: IF aso_debug_pub.g_debug_flag = 'Y' THEN
735: aso_debug_pub.add('site_use_id after deriving End_Customer = ' || l_header_rec.End_Customer_Site_Use_Id,1,'Y');
736: aso_debug_pub.add('inv_acct_site after deriving End_Customer = ' || l_hd_end_cust_acct_site,1,'Y');
737: END IF;
738: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 735: aso_debug_pub.add('site_use_id after deriving End_Customer = ' || l_header_rec.End_Customer_Site_Use_Id,1,'Y');

731: IF l_header_rec.End_Customer_Site_Use_Id IS NULL THEN
732: l_header_rec.End_Customer_Site_Use_Id := FND_API.G_MISS_NUM;
733: END IF;
734: IF aso_debug_pub.g_debug_flag = 'Y' THEN
735: aso_debug_pub.add('site_use_id after deriving End_Customer = ' || l_header_rec.End_Customer_Site_Use_Id,1,'Y');
736: aso_debug_pub.add('inv_acct_site after deriving End_Customer = ' || l_hd_end_cust_acct_site,1,'Y');
737: END IF;
738: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
739: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 736: aso_debug_pub.add('inv_acct_site after deriving End_Customer = ' || l_hd_end_cust_acct_site,1,'Y');

732: l_header_rec.End_Customer_Site_Use_Id := FND_API.G_MISS_NUM;
733: END IF;
734: IF aso_debug_pub.g_debug_flag = 'Y' THEN
735: aso_debug_pub.add('site_use_id after deriving End_Customer = ' || l_header_rec.End_Customer_Site_Use_Id,1,'Y');
736: aso_debug_pub.add('inv_acct_site after deriving End_Customer = ' || l_hd_end_cust_acct_site,1,'Y');
737: END IF;
738: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
739: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
740: THEN

Line 751: IF aso_debug_pub.g_debug_flag = 'Y' THEN

747: l_header_rec.End_Customer_id := l_End_cust_account_id;
748:
749: END IF;
750:
751: IF aso_debug_pub.g_debug_flag = 'Y' THEN
752: aso_debug_pub.add(' End_Customer_party = ' || p_qte_rec.End_Customer_party_id,1, 'N' );
753: aso_debug_pub.add(' invoice_to_party_Site = ' || p_qte_rec.End_Customer_party_site_id,1, 'N' );
754: aso_debug_pub.add('before Cust_Acct_Contact_Addr:l_End_cust_acccount = ' ||l_End_cust_account_id ,1,'Y');
755: END IF;

Line 752: aso_debug_pub.add(' End_Customer_party = ' || p_qte_rec.End_Customer_party_id,1, 'N' );

748:
749: END IF;
750:
751: IF aso_debug_pub.g_debug_flag = 'Y' THEN
752: aso_debug_pub.add(' End_Customer_party = ' || p_qte_rec.End_Customer_party_id,1, 'N' );
753: aso_debug_pub.add(' invoice_to_party_Site = ' || p_qte_rec.End_Customer_party_site_id,1, 'N' );
754: aso_debug_pub.add('before Cust_Acct_Contact_Addr:l_End_cust_acccount = ' ||l_End_cust_account_id ,1,'Y');
755: END IF;
756:

Line 753: aso_debug_pub.add(' invoice_to_party_Site = ' || p_qte_rec.End_Customer_party_site_id,1, 'N' );

749: END IF;
750:
751: IF aso_debug_pub.g_debug_flag = 'Y' THEN
752: aso_debug_pub.add(' End_Customer_party = ' || p_qte_rec.End_Customer_party_id,1, 'N' );
753: aso_debug_pub.add(' invoice_to_party_Site = ' || p_qte_rec.End_Customer_party_site_id,1, 'N' );
754: aso_debug_pub.add('before Cust_Acct_Contact_Addr:l_End_cust_acccount = ' ||l_End_cust_account_id ,1,'Y');
755: END IF;
756:
757: ASO_CHECK_TCA_PVT.Cust_Acct_Contact_Addr(

Line 754: aso_debug_pub.add('before Cust_Acct_Contact_Addr:l_End_cust_acccount = ' ||l_End_cust_account_id ,1,'Y');

750:
751: IF aso_debug_pub.g_debug_flag = 'Y' THEN
752: aso_debug_pub.add(' End_Customer_party = ' || p_qte_rec.End_Customer_party_id,1, 'N' );
753: aso_debug_pub.add(' invoice_to_party_Site = ' || p_qte_rec.End_Customer_party_site_id,1, 'N' );
754: aso_debug_pub.add('before Cust_Acct_Contact_Addr:l_End_cust_acccount = ' ||l_End_cust_account_id ,1,'Y');
755: END IF;
756:
757: ASO_CHECK_TCA_PVT.Cust_Acct_Contact_Addr(
758: p_api_version => 1.0,

Line 773: IF aso_debug_pub.g_debug_flag = 'Y' THEN

769: IF l_header_rec.End_Customer_contact_id IS NULL THEN
770: l_header_rec.End_Customer_contact_id := FND_API.G_MISS_NUM;
771: END IF;
772:
773: IF aso_debug_pub.g_debug_flag = 'Y' THEN
774: aso_debug_pub.add('mapq hd: after Cust_Acct_Contact_Addr:l_header_rec.End_Customer_contact_id: '||l_header_rec.End_Customer_contact_id,1,'N');
775: aso_debug_pub.add('mapq hd: after Cust_Acct_Contact_Addr:l_header_rec.End_Customer_id: '||l_header_rec.End_Customer_id,1,'N');
776: END IF;
777:

Line 774: aso_debug_pub.add('mapq hd: after Cust_Acct_Contact_Addr:l_header_rec.End_Customer_contact_id: '||l_header_rec.End_Customer_contact_id,1,'N');

770: l_header_rec.End_Customer_contact_id := FND_API.G_MISS_NUM;
771: END IF;
772:
773: IF aso_debug_pub.g_debug_flag = 'Y' THEN
774: aso_debug_pub.add('mapq hd: after Cust_Acct_Contact_Addr:l_header_rec.End_Customer_contact_id: '||l_header_rec.End_Customer_contact_id,1,'N');
775: aso_debug_pub.add('mapq hd: after Cust_Acct_Contact_Addr:l_header_rec.End_Customer_id: '||l_header_rec.End_Customer_id,1,'N');
776: END IF;
777:
778: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 775: aso_debug_pub.add('mapq hd: after Cust_Acct_Contact_Addr:l_header_rec.End_Customer_id: '||l_header_rec.End_Customer_id,1,'N');

771: END IF;
772:
773: IF aso_debug_pub.g_debug_flag = 'Y' THEN
774: aso_debug_pub.add('mapq hd: after Cust_Acct_Contact_Addr:l_header_rec.End_Customer_contact_id: '||l_header_rec.End_Customer_contact_id,1,'N');
775: aso_debug_pub.add('mapq hd: after Cust_Acct_Contact_Addr:l_header_rec.End_Customer_id: '||l_header_rec.End_Customer_id,1,'N');
776: END IF;
777:
778: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
779: raise FND_API.G_EXC_ERROR;

Line 784: IF aso_debug_pub.g_debug_flag = 'Y' THEN

780: END IF;
781:
782: -- end_cust
783:
784: IF aso_debug_pub.g_debug_flag = 'Y' THEN
785: aso_debug_pub.add('beginning of mapping for header shipping ', 1, 'N' );
786: END IF;
787:
788: IF p_header_shipment_tbl.count > 0 THEN

Line 785: aso_debug_pub.add('beginning of mapping for header shipping ', 1, 'N' );

781:
782: -- end_cust
783:
784: IF aso_debug_pub.g_debug_flag = 'Y' THEN
785: aso_debug_pub.add('beginning of mapping for header shipping ', 1, 'N' );
786: END IF;
787:
788: IF p_header_shipment_tbl.count > 0 THEN
789: -- OM takes in only one shipment at the header level

Line 794: IF aso_debug_pub.g_debug_flag = 'Y' THEN

790:
791: IF p_header_shipment_tbl(1).ship_to_cust_account_id <> FND_API.G_MISS_NUM AND
792: p_header_shipment_tbl(1).ship_to_cust_account_id IS NOT NULL AND
793: p_header_shipment_tbl(1).ship_to_cust_account_id <> l_cust_account_id THEN
794: IF aso_debug_pub.g_debug_flag = 'Y' THEN
795: aso_debug_pub.add('before cust_acct_relationship ', 1, 'N' );
796: END IF;
797: ASO_CHECK_TCA_PVT.Cust_acct_Relationship (
798: p_api_version => 1.0,

Line 795: aso_debug_pub.add('before cust_acct_relationship ', 1, 'N' );

791: IF p_header_shipment_tbl(1).ship_to_cust_account_id <> FND_API.G_MISS_NUM AND
792: p_header_shipment_tbl(1).ship_to_cust_account_id IS NOT NULL AND
793: p_header_shipment_tbl(1).ship_to_cust_account_id <> l_cust_account_id THEN
794: IF aso_debug_pub.g_debug_flag = 'Y' THEN
795: aso_debug_pub.add('before cust_acct_relationship ', 1, 'N' );
796: END IF;
797: ASO_CHECK_TCA_PVT.Cust_acct_Relationship (
798: p_api_version => 1.0,
799: p_sold_to_cust_account => l_cust_account_id,

Line 820: IF aso_debug_pub.g_debug_flag = 'Y' THEN

816: ELSE
817: l_ship_cust_account_id := l_header_rec.sold_to_org_id;
818: END IF;
819:
820: IF aso_debug_pub.g_debug_flag = 'Y' THEN
821: aso_debug_pub.add('ship cust acccount = ' || l_ship_cust_account_id ,1, 'N');
822: aso_debug_pub.add('ship to party site = ' || p_header_shipment_tbl(1).ship_to_party_site_id, 1, 'N');
823: END IF;
824: IF p_header_shipment_tbl(1).ship_to_party_site_id is not NULL

Line 821: aso_debug_pub.add('ship cust acccount = ' || l_ship_cust_account_id ,1, 'N');

817: l_ship_cust_account_id := l_header_rec.sold_to_org_id;
818: END IF;
819:
820: IF aso_debug_pub.g_debug_flag = 'Y' THEN
821: aso_debug_pub.add('ship cust acccount = ' || l_ship_cust_account_id ,1, 'N');
822: aso_debug_pub.add('ship to party site = ' || p_header_shipment_tbl(1).ship_to_party_site_id, 1, 'N');
823: END IF;
824: IF p_header_shipment_tbl(1).ship_to_party_site_id is not NULL
825: AND p_header_shipment_tbl(1).ship_to_party_site_id <> FND_API.G_MISS_NUM

Line 822: aso_debug_pub.add('ship to party site = ' || p_header_shipment_tbl(1).ship_to_party_site_id, 1, 'N');

818: END IF;
819:
820: IF aso_debug_pub.g_debug_flag = 'Y' THEN
821: aso_debug_pub.add('ship cust acccount = ' || l_ship_cust_account_id ,1, 'N');
822: aso_debug_pub.add('ship to party site = ' || p_header_shipment_tbl(1).ship_to_party_site_id, 1, 'N');
823: END IF;
824: IF p_header_shipment_tbl(1).ship_to_party_site_id is not NULL
825: AND p_header_shipment_tbl(1).ship_to_party_site_id <> FND_API.G_MISS_NUM
826: THEN

Line 845: IF aso_debug_pub.g_debug_flag = 'Y' THEN

841: IF l_header_rec.ship_to_org_id IS NULL THEN
842: l_header_rec.ship_to_org_id := FND_API.G_MISS_NUM;
843: END IF;
844:
845: IF aso_debug_pub.g_debug_flag = 'Y' THEN
846: aso_debug_pub.add('ship to org after deriving = ' || l_header_rec.ship_to_org_id, 1, 'N');
847: aso_debug_pub.add('ship acct site after deriving = ' || l_hd_shp_cust_acct_site, 1, 'N');
848: END IF;
849: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 846: aso_debug_pub.add('ship to org after deriving = ' || l_header_rec.ship_to_org_id, 1, 'N');

842: l_header_rec.ship_to_org_id := FND_API.G_MISS_NUM;
843: END IF;
844:
845: IF aso_debug_pub.g_debug_flag = 'Y' THEN
846: aso_debug_pub.add('ship to org after deriving = ' || l_header_rec.ship_to_org_id, 1, 'N');
847: aso_debug_pub.add('ship acct site after deriving = ' || l_hd_shp_cust_acct_site, 1, 'N');
848: END IF;
849: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
850: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 847: aso_debug_pub.add('ship acct site after deriving = ' || l_hd_shp_cust_acct_site, 1, 'N');

843: END IF;
844:
845: IF aso_debug_pub.g_debug_flag = 'Y' THEN
846: aso_debug_pub.add('ship to org after deriving = ' || l_header_rec.ship_to_org_id, 1, 'N');
847: aso_debug_pub.add('ship acct site after deriving = ' || l_hd_shp_cust_acct_site, 1, 'N');
848: END IF;
849: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
850: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
851: THEN

Line 860: IF aso_debug_pub.g_debug_flag = 'Y' THEN

856: END IF;
857:
858: END IF;
859:
860: IF aso_debug_pub.g_debug_flag = 'Y' THEN
861: aso_debug_pub.add('beginning of map 2:ship_party_id: ' || p_header_shipment_tbl(1).ship_to_party_id,1,'N');
862: aso_debug_pub.add('before Cust_Acct_Contact_Addr:l_ship_cust_account_id: '||l_ship_cust_account_id,1,'N');
863: aso_debug_pub.add('before Cust_Acct_Contact_Addr:p_header_shipment_tbl(1).ship_to_party_site_id: '||p_header_shipment_tbl(1).ship_to_party_site_id,1,'N');
864: END IF;

Line 861: aso_debug_pub.add('beginning of map 2:ship_party_id: ' || p_header_shipment_tbl(1).ship_to_party_id,1,'N');

857:
858: END IF;
859:
860: IF aso_debug_pub.g_debug_flag = 'Y' THEN
861: aso_debug_pub.add('beginning of map 2:ship_party_id: ' || p_header_shipment_tbl(1).ship_to_party_id,1,'N');
862: aso_debug_pub.add('before Cust_Acct_Contact_Addr:l_ship_cust_account_id: '||l_ship_cust_account_id,1,'N');
863: aso_debug_pub.add('before Cust_Acct_Contact_Addr:p_header_shipment_tbl(1).ship_to_party_site_id: '||p_header_shipment_tbl(1).ship_to_party_site_id,1,'N');
864: END IF;
865:

Line 862: aso_debug_pub.add('before Cust_Acct_Contact_Addr:l_ship_cust_account_id: '||l_ship_cust_account_id,1,'N');

858: END IF;
859:
860: IF aso_debug_pub.g_debug_flag = 'Y' THEN
861: aso_debug_pub.add('beginning of map 2:ship_party_id: ' || p_header_shipment_tbl(1).ship_to_party_id,1,'N');
862: aso_debug_pub.add('before Cust_Acct_Contact_Addr:l_ship_cust_account_id: '||l_ship_cust_account_id,1,'N');
863: aso_debug_pub.add('before Cust_Acct_Contact_Addr:p_header_shipment_tbl(1).ship_to_party_site_id: '||p_header_shipment_tbl(1).ship_to_party_site_id,1,'N');
864: END IF;
865:
866: ASO_CHECK_TCA_PVT.Cust_Acct_Contact_Addr(

Line 863: aso_debug_pub.add('before Cust_Acct_Contact_Addr:p_header_shipment_tbl(1).ship_to_party_site_id: '||p_header_shipment_tbl(1).ship_to_party_site_id,1,'N');

859:
860: IF aso_debug_pub.g_debug_flag = 'Y' THEN
861: aso_debug_pub.add('beginning of map 2:ship_party_id: ' || p_header_shipment_tbl(1).ship_to_party_id,1,'N');
862: aso_debug_pub.add('before Cust_Acct_Contact_Addr:l_ship_cust_account_id: '||l_ship_cust_account_id,1,'N');
863: aso_debug_pub.add('before Cust_Acct_Contact_Addr:p_header_shipment_tbl(1).ship_to_party_site_id: '||p_header_shipment_tbl(1).ship_to_party_site_id,1,'N');
864: END IF;
865:
866: ASO_CHECK_TCA_PVT.Cust_Acct_Contact_Addr(
867: p_api_version => 1.0,

Line 882: IF aso_debug_pub.g_debug_flag = 'Y' THEN

878: IF l_header_rec.ship_to_contact_id IS NULL THEN
879: l_header_rec.ship_to_contact_id := FND_API.G_MISS_NUM;
880: END IF;
881:
882: IF aso_debug_pub.g_debug_flag = 'Y' THEN
883: aso_debug_pub.add('mapq hdr: after Cust_Acct_Contact_Addr:l_header_rec.ship_to_contact_id: '||l_header_rec.ship_to_contact_id,1,'N');
884: END IF;
885:
886: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 883: aso_debug_pub.add('mapq hdr: after Cust_Acct_Contact_Addr:l_header_rec.ship_to_contact_id: '||l_header_rec.ship_to_contact_id,1,'N');

879: l_header_rec.ship_to_contact_id := FND_API.G_MISS_NUM;
880: END IF;
881:
882: IF aso_debug_pub.g_debug_flag = 'Y' THEN
883: aso_debug_pub.add('mapq hdr: after Cust_Acct_Contact_Addr:l_header_rec.ship_to_contact_id: '||l_header_rec.ship_to_contact_id,1,'N');
884: END IF;
885:
886: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
887: raise FND_API.G_EXC_ERROR;

Line 891: IF aso_debug_pub.g_debug_flag = 'Y' THEN

887: raise FND_API.G_EXC_ERROR;
888: END IF;
889:
890: END IF; -- shipment tbl count
891: IF aso_debug_pub.g_debug_flag = 'Y' THEN
892: aso_debug_pub.add('after map 2 for header',1,'N');
893: END IF;
894:
895:

Line 892: aso_debug_pub.add('after map 2 for header',1,'N');

888: END IF;
889:
890: END IF; -- shipment tbl count
891: IF aso_debug_pub.g_debug_flag = 'Y' THEN
892: aso_debug_pub.add('after map 2 for header',1,'N');
893: END IF;
894:
895:
896: IF p_operation = 'CREATE' THEN

Line 917: IF aso_debug_pub.g_debug_flag = 'Y' THEN

913:
914: -- if an employee person id is passed then it needs to be converted to a
915: -- salesrep id. no error is raised if the conversion is not possible
916:
917: IF aso_debug_pub.g_debug_flag = 'Y' THEN
918: aso_debug_pub.add('l_validate_salesrep_prof =' ||l_validate_salesrep_prof,1,'N');
919: aso_debug_pub.add('l_om_defaulting_prof =' ||l_om_defaulting_prof,1,'N');
920: aso_debug_pub.add('p_qte_rec.employee_person_id = '|| p_qte_rec.employee_person_id,1,'N');
921: aso_debug_pub.add('p_qte_rec.resource_id = ' || p_qte_rec.resource_id,1,'N');

Line 918: aso_debug_pub.add('l_validate_salesrep_prof =' ||l_validate_salesrep_prof,1,'N');

914: -- if an employee person id is passed then it needs to be converted to a
915: -- salesrep id. no error is raised if the conversion is not possible
916:
917: IF aso_debug_pub.g_debug_flag = 'Y' THEN
918: aso_debug_pub.add('l_validate_salesrep_prof =' ||l_validate_salesrep_prof,1,'N');
919: aso_debug_pub.add('l_om_defaulting_prof =' ||l_om_defaulting_prof,1,'N');
920: aso_debug_pub.add('p_qte_rec.employee_person_id = '|| p_qte_rec.employee_person_id,1,'N');
921: aso_debug_pub.add('p_qte_rec.resource_id = ' || p_qte_rec.resource_id,1,'N');
922: END IF;

Line 919: aso_debug_pub.add('l_om_defaulting_prof =' ||l_om_defaulting_prof,1,'N');

915: -- salesrep id. no error is raised if the conversion is not possible
916:
917: IF aso_debug_pub.g_debug_flag = 'Y' THEN
918: aso_debug_pub.add('l_validate_salesrep_prof =' ||l_validate_salesrep_prof,1,'N');
919: aso_debug_pub.add('l_om_defaulting_prof =' ||l_om_defaulting_prof,1,'N');
920: aso_debug_pub.add('p_qte_rec.employee_person_id = '|| p_qte_rec.employee_person_id,1,'N');
921: aso_debug_pub.add('p_qte_rec.resource_id = ' || p_qte_rec.resource_id,1,'N');
922: END IF;
923:

Line 920: aso_debug_pub.add('p_qte_rec.employee_person_id = '|| p_qte_rec.employee_person_id,1,'N');

916:
917: IF aso_debug_pub.g_debug_flag = 'Y' THEN
918: aso_debug_pub.add('l_validate_salesrep_prof =' ||l_validate_salesrep_prof,1,'N');
919: aso_debug_pub.add('l_om_defaulting_prof =' ||l_om_defaulting_prof,1,'N');
920: aso_debug_pub.add('p_qte_rec.employee_person_id = '|| p_qte_rec.employee_person_id,1,'N');
921: aso_debug_pub.add('p_qte_rec.resource_id = ' || p_qte_rec.resource_id,1,'N');
922: END IF;
923:
924: IF (p_qte_rec.employee_person_id IS NOT NULL AND

Line 921: aso_debug_pub.add('p_qte_rec.resource_id = ' || p_qte_rec.resource_id,1,'N');

917: IF aso_debug_pub.g_debug_flag = 'Y' THEN
918: aso_debug_pub.add('l_validate_salesrep_prof =' ||l_validate_salesrep_prof,1,'N');
919: aso_debug_pub.add('l_om_defaulting_prof =' ||l_om_defaulting_prof,1,'N');
920: aso_debug_pub.add('p_qte_rec.employee_person_id = '|| p_qte_rec.employee_person_id,1,'N');
921: aso_debug_pub.add('p_qte_rec.resource_id = ' || p_qte_rec.resource_id,1,'N');
922: END IF;
923:
924: IF (p_qte_rec.employee_person_id IS NOT NULL AND
925: p_qte_rec.employee_person_id <> FND_API.G_MISS_NUM) AND

Line 943: IF aso_debug_pub.g_debug_flag = 'Y' THEN

939:
940: -- if the salesrep id is null and the validate flag is set to 'N' then
941: -- the sales rep id is defaulted. No warning is given if the salesrep is not
942: -- the same as the salesrep id
943: IF aso_debug_pub.g_debug_flag = 'Y' THEN
944: aso_debug_pub.add('salesrep id =' ||l_header_rec.salesrep_id,1,'N');
945: aso_debug_pub.add('default salesrep = '|| l_default_person_id_prof,1,'N');
946: aso_debug_pub.add('p_operation = '|| p_operation,1,'N');
947: END IF;

Line 944: aso_debug_pub.add('salesrep id =' ||l_header_rec.salesrep_id,1,'N');

940: -- if the salesrep id is null and the validate flag is set to 'N' then
941: -- the sales rep id is defaulted. No warning is given if the salesrep is not
942: -- the same as the salesrep id
943: IF aso_debug_pub.g_debug_flag = 'Y' THEN
944: aso_debug_pub.add('salesrep id =' ||l_header_rec.salesrep_id,1,'N');
945: aso_debug_pub.add('default salesrep = '|| l_default_person_id_prof,1,'N');
946: aso_debug_pub.add('p_operation = '|| p_operation,1,'N');
947: END IF;
948:

Line 945: aso_debug_pub.add('default salesrep = '|| l_default_person_id_prof,1,'N');

941: -- the sales rep id is defaulted. No warning is given if the salesrep is not
942: -- the same as the salesrep id
943: IF aso_debug_pub.g_debug_flag = 'Y' THEN
944: aso_debug_pub.add('salesrep id =' ||l_header_rec.salesrep_id,1,'N');
945: aso_debug_pub.add('default salesrep = '|| l_default_person_id_prof,1,'N');
946: aso_debug_pub.add('p_operation = '|| p_operation,1,'N');
947: END IF;
948:
949: IF (l_header_rec.salesrep_id IS NULL OR

Line 946: aso_debug_pub.add('p_operation = '|| p_operation,1,'N');

942: -- the same as the salesrep id
943: IF aso_debug_pub.g_debug_flag = 'Y' THEN
944: aso_debug_pub.add('salesrep id =' ||l_header_rec.salesrep_id,1,'N');
945: aso_debug_pub.add('default salesrep = '|| l_default_person_id_prof,1,'N');
946: aso_debug_pub.add('p_operation = '|| p_operation,1,'N');
947: END IF;
948:
949: IF (l_header_rec.salesrep_id IS NULL OR
950: l_header_rec.salesrep_id = FND_API.G_MISS_NUM) AND

Line 979: IF aso_debug_pub.g_debug_flag = 'Y' THEN

975: END IF;
976: END IF;
977: END IF;
978:
979: IF aso_debug_pub.g_debug_flag = 'Y' THEN
980: aso_debug_pub.add('salesrep id =' ||l_header_rec.salesrep_id,1,'N');
981: END IF;
982:
983: -- if the salesrep is still null then an error is raised.

Line 980: aso_debug_pub.add('salesrep id =' ||l_header_rec.salesrep_id,1,'N');

976: END IF;
977: END IF;
978:
979: IF aso_debug_pub.g_debug_flag = 'Y' THEN
980: aso_debug_pub.add('salesrep id =' ||l_header_rec.salesrep_id,1,'N');
981: END IF;
982:
983: -- if the salesrep is still null then an error is raised.
984:

Line 1041: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1037: l_header_rec.orig_sys_document_ref := to_char(l_quote_number);
1038:
1039: END IF;
1040:
1041: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1042: aso_debug_pub.add('l_header_rec.orig_sys_document_ref: '||l_header_rec.orig_sys_document_ref,1,'N');
1043: END IF;
1044:
1045: END IF;

Line 1042: aso_debug_pub.add('l_header_rec.orig_sys_document_ref: '||l_header_rec.orig_sys_document_ref,1,'N');

1038:
1039: END IF;
1040:
1041: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1042: aso_debug_pub.add('l_header_rec.orig_sys_document_ref: '||l_header_rec.orig_sys_document_ref,1,'N');
1043: END IF;
1044:
1045: END IF;
1046:

Line 1052: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1048:
1049: END IF; -- p_qte_rec.original_system_reference
1050: ELSIF p_operation = 'UPDATE' THEN
1051: l_header_rec.orig_sys_document_ref := p_qte_rec.original_system_reference;
1052: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1053: aso_debug_pub.add('p_operation = UPDATE ** l_header_rec.orig_sys_document_ref: '||l_header_rec.orig_sys_document_ref,1,'N');
1054: END IF;
1055:
1056: END IF; -- CREATE

Line 1053: aso_debug_pub.add('p_operation = UPDATE ** l_header_rec.orig_sys_document_ref: '||l_header_rec.orig_sys_document_ref,1,'N');

1049: END IF; -- p_qte_rec.original_system_reference
1050: ELSIF p_operation = 'UPDATE' THEN
1051: l_header_rec.orig_sys_document_ref := p_qte_rec.original_system_reference;
1052: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1053: aso_debug_pub.add('p_operation = UPDATE ** l_header_rec.orig_sys_document_ref: '||l_header_rec.orig_sys_document_ref,1,'N');
1054: END IF;
1055:
1056: END IF; -- CREATE
1057: -- default value if null

Line 1086: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1082: END IF;
1083:
1084:
1085: -- source document type id will determine the source of the document
1086: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1087: aso_debug_pub.add('in here for quote source',1,'N');
1088: END IF;
1089: IF l_quote_source is not NULL AND
1090: l_quote_source <> FND_API.G_MISS_CHAR THEN

Line 1087: aso_debug_pub.add('in here for quote source',1,'N');

1083:
1084:
1085: -- source document type id will determine the source of the document
1086: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1087: aso_debug_pub.add('in here for quote source',1,'N');
1088: END IF;
1089: IF l_quote_source is not NULL AND
1090: l_quote_source <> FND_API.G_MISS_CHAR THEN
1091:

Line 1099: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1095: null;
1096: END IF;
1097: CLOSE C_order_source;
1098: END IF;
1099: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1100: aso_debug_pub.add('in here after source code',1,'N');
1101: END IF;
1102: For i in 1..p_header_payment_tbl.count LOOP
1103:

Line 1100: aso_debug_pub.add('in here after source code',1,'N');

1096: END IF;
1097: CLOSE C_order_source;
1098: END IF;
1099: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1100: aso_debug_pub.add('in here after source code',1,'N');
1101: END IF;
1102: For i in 1..p_header_payment_tbl.count LOOP
1103:
1104: IF (NVL(l_om_defaulting_prof, 'N') = 'Y') THEN

Line 1116: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1112: END IF;
1113:
1114: -- Bug 7253077
1115: IF p_header_payment_tbl(i).payment_type_code <> 'PO' THEN
1116: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1117: aso_debug_pub.add('p_header_payment_tbl(i).payment_type_code: '||p_header_payment_tbl(i).payment_type_code,1,'N');
1118: END IF;
1119: l_header_rec.payment_type_code := p_header_payment_tbl(i).payment_type_code;
1120: END IF;

Line 1117: aso_debug_pub.add('p_header_payment_tbl(i).payment_type_code: '||p_header_payment_tbl(i).payment_type_code,1,'N');

1113:
1114: -- Bug 7253077
1115: IF p_header_payment_tbl(i).payment_type_code <> 'PO' THEN
1116: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1117: aso_debug_pub.add('p_header_payment_tbl(i).payment_type_code: '||p_header_payment_tbl(i).payment_type_code,1,'N');
1118: END IF;
1119: l_header_rec.payment_type_code := p_header_payment_tbl(i).payment_type_code;
1120: END IF;
1121: -- end bug 7253077

Line 1123: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1119: l_header_rec.payment_type_code := p_header_payment_tbl(i).payment_type_code;
1120: END IF;
1121: -- end bug 7253077
1122:
1123: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1124: aso_debug_pub.add('p_header_payment_tbl(i).cust_po_number: '||p_header_payment_tbl(i).cust_po_number,1,'N');
1125: END IF;
1126:
1127: l_header_rec.cust_po_number := p_header_payment_tbl(i).cust_po_number;

Line 1124: aso_debug_pub.add('p_header_payment_tbl(i).cust_po_number: '||p_header_payment_tbl(i).cust_po_number,1,'N');

1120: END IF;
1121: -- end bug 7253077
1122:
1123: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1124: aso_debug_pub.add('p_header_payment_tbl(i).cust_po_number: '||p_header_payment_tbl(i).cust_po_number,1,'N');
1125: END IF;
1126:
1127: l_header_rec.cust_po_number := p_header_payment_tbl(i).cust_po_number;
1128:

Line 1129: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1125: END IF;
1126:
1127: l_header_rec.cust_po_number := p_header_payment_tbl(i).cust_po_number;
1128:
1129: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1130: aso_debug_pub.add('p_header_payment_tbl(i).payment_type_code: '||p_header_payment_tbl(i).payment_type_code,1,'N');
1131: END IF;
1132: IF p_header_payment_tbl(i).payment_type_code IS NOT NULL THEN
1133: l_header_payment_tbl(pay_count).payment_type_code := p_header_payment_tbl(i).payment_type_code;

Line 1130: aso_debug_pub.add('p_header_payment_tbl(i).payment_type_code: '||p_header_payment_tbl(i).payment_type_code,1,'N');

1126:
1127: l_header_rec.cust_po_number := p_header_payment_tbl(i).cust_po_number;
1128:
1129: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1130: aso_debug_pub.add('p_header_payment_tbl(i).payment_type_code: '||p_header_payment_tbl(i).payment_type_code,1,'N');
1131: END IF;
1132: IF p_header_payment_tbl(i).payment_type_code IS NOT NULL THEN
1133: l_header_payment_tbl(pay_count).payment_type_code := p_header_payment_tbl(i).payment_type_code;
1134:

Line 1147: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1143: l_header_payment_tbl(pay_count).trxn_extension_id := p_header_payment_tbl(i).trxn_extension_id;
1144: l_header_payment_tbl(pay_count).payment_collection_event := 'INVOICE';
1145: l_header_payment_tbl(pay_count).payment_level_code := 'ORDER';
1146:
1147: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1148: aso_debug_pub.add('l_header_payment_tbl(pay_count).operation: '||l_header_payment_tbl(pay_count).operation,1,'N');
1149: aso_debug_pub.add('l_header_payment_tbl(pay_count).trxn_extension_id: '||l_header_payment_tbl(pay_count).trxn_extension_id,1,'N');
1150: END IF;
1151:

Line 1148: aso_debug_pub.add('l_header_payment_tbl(pay_count).operation: '||l_header_payment_tbl(pay_count).operation,1,'N');

1144: l_header_payment_tbl(pay_count).payment_collection_event := 'INVOICE';
1145: l_header_payment_tbl(pay_count).payment_level_code := 'ORDER';
1146:
1147: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1148: aso_debug_pub.add('l_header_payment_tbl(pay_count).operation: '||l_header_payment_tbl(pay_count).operation,1,'N');
1149: aso_debug_pub.add('l_header_payment_tbl(pay_count).trxn_extension_id: '||l_header_payment_tbl(pay_count).trxn_extension_id,1,'N');
1150: END IF;
1151:
1152: IF p_header_payment_tbl(i).payment_type_code = 'CHECK' THEN

Line 1149: aso_debug_pub.add('l_header_payment_tbl(pay_count).trxn_extension_id: '||l_header_payment_tbl(pay_count).trxn_extension_id,1,'N');

1145: l_header_payment_tbl(pay_count).payment_level_code := 'ORDER';
1146:
1147: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1148: aso_debug_pub.add('l_header_payment_tbl(pay_count).operation: '||l_header_payment_tbl(pay_count).operation,1,'N');
1149: aso_debug_pub.add('l_header_payment_tbl(pay_count).trxn_extension_id: '||l_header_payment_tbl(pay_count).trxn_extension_id,1,'N');
1150: END IF;
1151:
1152: IF p_header_payment_tbl(i).payment_type_code = 'CHECK' THEN
1153: l_header_payment_tbl(pay_count).check_number := p_header_payment_tbl(i).payment_ref_number;

Line 1161: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1157:
1158: -- bug 5613870
1159: IF p_header_payment_tbl(i).payment_type_code = 'CREDIT_CARD' THEN
1160: l_header_payment_tbl(pay_count).receipt_method_id := fnd_api.g_miss_num;
1161: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1162: aso_debug_pub.add('Passing receipt method id as g miss num' ,1,'N');
1163: END IF;
1164: END IF;
1165:

Line 1162: aso_debug_pub.add('Passing receipt method id as g miss num' ,1,'N');

1158: -- bug 5613870
1159: IF p_header_payment_tbl(i).payment_type_code = 'CREDIT_CARD' THEN
1160: l_header_payment_tbl(pay_count).receipt_method_id := fnd_api.g_miss_num;
1161: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1162: aso_debug_pub.add('Passing receipt method id as g miss num' ,1,'N');
1163: END IF;
1164: END IF;
1165:
1166: pay_count := pay_count + 1;

Line 1170: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1166: pay_count := pay_count + 1;
1167:
1168: END LOOP;
1169:
1170: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1171: aso_debug_pub.add('mapped header payment tbl',1,'N');
1172: END IF;
1173:
1174:

Line 1171: aso_debug_pub.add('mapped header payment tbl',1,'N');

1167:
1168: END LOOP;
1169:
1170: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1171: aso_debug_pub.add('mapped header payment tbl',1,'N');
1172: END IF;
1173:
1174:
1175: For i in 1..p_header_shipment_tbl.count LOOP

Line 1176: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1172: END IF;
1173:
1174:
1175: For i in 1..p_header_shipment_tbl.count LOOP
1176: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1177: aso_debug_pub.add('mapped header shipment tbl:shipping_instructions: '|| p_header_shipment_tbl(i).shipping_instructions||'trimmed',1,'N');
1178: END IF;
1179: --bug 1921958
1180: IF (p_header_shipment_tbl(i).shipping_instructions IS NULL) AND

Line 1177: aso_debug_pub.add('mapped header shipment tbl:shipping_instructions: '|| p_header_shipment_tbl(i).shipping_instructions||'trimmed',1,'N');

1173:
1174:
1175: For i in 1..p_header_shipment_tbl.count LOOP
1176: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1177: aso_debug_pub.add('mapped header shipment tbl:shipping_instructions: '|| p_header_shipment_tbl(i).shipping_instructions||'trimmed',1,'N');
1178: END IF;
1179: --bug 1921958
1180: IF (p_header_shipment_tbl(i).shipping_instructions IS NULL) AND
1181: (l_om_defaulting_prof = 'Y') THEN

Line 1198: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1194: l_header_rec.packing_instructions
1195: :=rtrim(p_header_shipment_tbl(i).packing_instructions);
1196: END IF;
1197: --bug 1921958
1198: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1199: aso_debug_pub.add('mapped header shipment tbl:shipping_instructions: '|| l_header_rec.shipping_instructions||'trimmed',1,'N');
1200: aso_debug_pub.add('mapped header shipment tbl:packing_instructions: '|| l_header_rec.packing_instructions||'trimmed',1,'N');
1201: END IF;
1202:

Line 1199: aso_debug_pub.add('mapped header shipment tbl:shipping_instructions: '|| l_header_rec.shipping_instructions||'trimmed',1,'N');

1195: :=rtrim(p_header_shipment_tbl(i).packing_instructions);
1196: END IF;
1197: --bug 1921958
1198: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1199: aso_debug_pub.add('mapped header shipment tbl:shipping_instructions: '|| l_header_rec.shipping_instructions||'trimmed',1,'N');
1200: aso_debug_pub.add('mapped header shipment tbl:packing_instructions: '|| l_header_rec.packing_instructions||'trimmed',1,'N');
1201: END IF;
1202:
1203: IF (NVL(l_om_defaulting_prof, 'N') = 'Y') THEN

Line 1200: aso_debug_pub.add('mapped header shipment tbl:packing_instructions: '|| l_header_rec.packing_instructions||'trimmed',1,'N');

1196: END IF;
1197: --bug 1921958
1198: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1199: aso_debug_pub.add('mapped header shipment tbl:shipping_instructions: '|| l_header_rec.shipping_instructions||'trimmed',1,'N');
1200: aso_debug_pub.add('mapped header shipment tbl:packing_instructions: '|| l_header_rec.packing_instructions||'trimmed',1,'N');
1201: END IF;
1202:
1203: IF (NVL(l_om_defaulting_prof, 'N') = 'Y') THEN
1204: IF p_header_shipment_tbl(i).FOB_CODE is null then

Line 1245: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1241:
1242: l_header_rec.partial_shipments_allowed
1243: :=p_header_shipment_tbl(i).ship_partial_flag;
1244:
1245: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1246: aso_debug_pub.add('request date= ' ||l_header_rec.request_date,1,'N');
1247: aso_debug_pub.add('Map_Qte_To_Ord: p_header_shipment_tbl(i).Ship_From_Org_Id: '||p_header_shipment_tbl(i).Ship_From_Org_Id,1,'Y');
1248: END IF;
1249: IF p_header_shipment_tbl(i).Ship_From_Org_Id IS NOT NULL AND

Line 1246: aso_debug_pub.add('request date= ' ||l_header_rec.request_date,1,'N');

1242: l_header_rec.partial_shipments_allowed
1243: :=p_header_shipment_tbl(i).ship_partial_flag;
1244:
1245: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1246: aso_debug_pub.add('request date= ' ||l_header_rec.request_date,1,'N');
1247: aso_debug_pub.add('Map_Qte_To_Ord: p_header_shipment_tbl(i).Ship_From_Org_Id: '||p_header_shipment_tbl(i).Ship_From_Org_Id,1,'Y');
1248: END IF;
1249: IF p_header_shipment_tbl(i).Ship_From_Org_Id IS NOT NULL AND
1250: p_header_shipment_tbl(i).Ship_From_Org_Id <> FND_API.G_MISS_NUM THEN

Line 1247: aso_debug_pub.add('Map_Qte_To_Ord: p_header_shipment_tbl(i).Ship_From_Org_Id: '||p_header_shipment_tbl(i).Ship_From_Org_Id,1,'Y');

1243: :=p_header_shipment_tbl(i).ship_partial_flag;
1244:
1245: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1246: aso_debug_pub.add('request date= ' ||l_header_rec.request_date,1,'N');
1247: aso_debug_pub.add('Map_Qte_To_Ord: p_header_shipment_tbl(i).Ship_From_Org_Id: '||p_header_shipment_tbl(i).Ship_From_Org_Id,1,'Y');
1248: END IF;
1249: IF p_header_shipment_tbl(i).Ship_From_Org_Id IS NOT NULL AND
1250: p_header_shipment_tbl(i).Ship_From_Org_Id <> FND_API.G_MISS_NUM THEN
1251:

Line 1277: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1273:
1274: END LOOP;
1275:
1276: -- reserve quantity
1277: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1278: aso_debug_pub.add('MapQ: l_reservation_lvl_prof: '||l_reservation_lvl_prof,1,'N');
1279: END IF;
1280:
1281: IF (l_header_rec.order_type_id is not null AND

Line 1278: aso_debug_pub.add('MapQ: l_reservation_lvl_prof: '||l_reservation_lvl_prof,1,'N');

1274: END LOOP;
1275:
1276: -- reserve quantity
1277: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1278: aso_debug_pub.add('MapQ: l_reservation_lvl_prof: '||l_reservation_lvl_prof,1,'N');
1279: END IF;
1280:
1281: IF (l_header_rec.order_type_id is not null AND
1282: l_header_rec.order_type_id <> FND_API.G_MISS_NUM) AND

Line 1287: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1283: l_reservation_lvl_prof = 'AUTO_ORDER' THEN
1284: OPEN scheduling_level_cur(l_header_rec.order_type_id);
1285: FETCH scheduling_level_cur INTO l_order_scheduling_level;
1286: CLOSE scheduling_level_cur;
1287: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1288: aso_debug_pub.add('l_header_rec.order_type_id = ' ||
1289: l_header_rec.order_type_id, 1,'N');
1290: END IF;
1291: END IF;

Line 1288: aso_debug_pub.add('l_header_rec.order_type_id = ' ||

1284: OPEN scheduling_level_cur(l_header_rec.order_type_id);
1285: FETCH scheduling_level_cur INTO l_order_scheduling_level;
1286: CLOSE scheduling_level_cur;
1287: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1288: aso_debug_pub.add('l_header_rec.order_type_id = ' ||
1289: l_header_rec.order_type_id, 1,'N');
1290: END IF;
1291: END IF;
1292:

Line 1293: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1289: l_header_rec.order_type_id, 1,'N');
1290: END IF;
1291: END IF;
1292:
1293: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1294: aso_debug_pub.add('after mapping header tax detail ',1,'Y');
1295: END IF;
1296:
1297: map_header_price_attr(

Line 1294: aso_debug_pub.add('after mapping header tax detail ',1,'Y');

1290: END IF;
1291: END IF;
1292:
1293: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1294: aso_debug_pub.add('after mapping header tax detail ',1,'Y');
1295: END IF;
1296:
1297: map_header_price_attr(
1298: p_header_price_attributes_tbl => p_header_price_attributes_tbl,

Line 1303: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1299: p_qte_rec => p_qte_rec,
1300: p_operation => l_header_rec.operation,
1301: x_Header_price_Att_tbl => l_header_price_att_tbl
1302: );
1303: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1304: aso_debug_pub.add('after mapping header price attr:l_header_price_att_tbl.count: '||l_header_price_att_tbl.count,1,'N');
1305: END IF;
1306:
1307: map_header_price_adj(

Line 1304: aso_debug_pub.add('after mapping header price attr:l_header_price_att_tbl.count: '||l_header_price_att_tbl.count,1,'N');

1300: p_operation => l_header_rec.operation,
1301: x_Header_price_Att_tbl => l_header_price_att_tbl
1302: );
1303: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1304: aso_debug_pub.add('after mapping header price attr:l_header_price_att_tbl.count: '||l_header_price_att_tbl.count,1,'N');
1305: END IF;
1306:
1307: map_header_price_adj(
1308: p_header_price_adj_tbl => p_header_price_adj_tbl,

Line 1314: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1310: p_operation => l_header_rec.operation,
1311: x_Header_adj_tbl => l_header_adj_tbl
1312: );
1313:
1314: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1315: aso_debug_pub.add('after header price adjustments:l_header_adj_tbl.count: '||l_header_adj_tbl.count,1,'N');
1316: END IF;
1317:
1318: map_header_price_adj_attr(

Line 1315: aso_debug_pub.add('after header price adjustments:l_header_adj_tbl.count: '||l_header_adj_tbl.count,1,'N');

1311: x_Header_adj_tbl => l_header_adj_tbl
1312: );
1313:
1314: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1315: aso_debug_pub.add('after header price adjustments:l_header_adj_tbl.count: '||l_header_adj_tbl.count,1,'N');
1316: END IF;
1317:
1318: map_header_price_adj_attr(
1319: p_header_price_adj_attr_tbl => p_header_price_adj_attr_tbl,

Line 1324: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1320: p_operation => l_header_rec.operation,
1321: x_header_adj_att_tbl => l_header_adj_att_tbl
1322: );
1323:
1324: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1325: aso_debug_pub.add('after header price adj attribute:l_header_adj_att_tbl.count: '||l_header_adj_att_tbl.count,1,'N');
1326: END IF;
1327:
1328: map_header_price_adj_rltn(

Line 1325: aso_debug_pub.add('after header price adj attribute:l_header_adj_att_tbl.count: '||l_header_adj_att_tbl.count,1,'N');

1321: x_header_adj_att_tbl => l_header_adj_att_tbl
1322: );
1323:
1324: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1325: aso_debug_pub.add('after header price adj attribute:l_header_adj_att_tbl.count: '||l_header_adj_att_tbl.count,1,'N');
1326: END IF;
1327:
1328: map_header_price_adj_rltn(
1329: P_Header_Price_Adj_rltship_Tbl => P_Header_Price_Adj_rltship_Tbl,

Line 1334: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1330: P_operation => l_header_rec.operation,
1331: x_Header_Adj_Assoc_tbl => l_Header_Adj_Assoc_tbl
1332: );
1333:
1334: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1335: aso_debug_pub.add('before header sales credit:l_Header_Adj_Assoc_tbl.count: '||l_Header_Adj_Assoc_tbl.count,1,'N');
1336: END IF;
1337:
1338: map_header_sales_credits(

Line 1335: aso_debug_pub.add('before header sales credit:l_Header_Adj_Assoc_tbl.count: '||l_Header_Adj_Assoc_tbl.count,1,'N');

1331: x_Header_Adj_Assoc_tbl => l_Header_Adj_Assoc_tbl
1332: );
1333:
1334: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1335: aso_debug_pub.add('before header sales credit:l_Header_Adj_Assoc_tbl.count: '||l_Header_Adj_Assoc_tbl.count,1,'N');
1336: END IF;
1337:
1338: map_header_sales_credits(
1339: P_header_sales_credit_Tbl => P_header_sales_credit_Tbl,

Line 1345: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1341: p_qte_rec => p_qte_rec,
1342: p_header_operation => l_header_rec.operation,
1343: x_Header_Scredit_tbl => l_Header_Scredit_tbl
1344: );
1345: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1346: aso_debug_pub.add('after header sales credit:l_Header_Scredit_tbl.count: '||l_Header_Scredit_tbl.count,1,'N');
1347: END IF;
1348:
1349: -- mapping quote lines to order lines

Line 1346: aso_debug_pub.add('after header sales credit:l_Header_Scredit_tbl.count: '||l_Header_Scredit_tbl.count,1,'N');

1342: p_header_operation => l_header_rec.operation,
1343: x_Header_Scredit_tbl => l_Header_Scredit_tbl
1344: );
1345: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1346: aso_debug_pub.add('after header sales credit:l_Header_Scredit_tbl.count: '||l_Header_Scredit_tbl.count,1,'N');
1347: END IF;
1348:
1349: -- mapping quote lines to order lines
1350: -- mapping is done based on the index and not on the line id for quotes

Line 1356: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1352:
1353: -- initializing all counts for lines
1354: i := 1;
1355: j := 1;
1356: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1357: aso_debug_pub.add('mapping quote lines',1,'N');
1358: END IF;
1359: FOR j in 1..P_line_Shipment_Tbl.count LOOP
1360: found := FND_API.G_FALSE;

Line 1357: aso_debug_pub.add('mapping quote lines',1,'N');

1353: -- initializing all counts for lines
1354: i := 1;
1355: j := 1;
1356: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1357: aso_debug_pub.add('mapping quote lines',1,'N');
1358: END IF;
1359: FOR j in 1..P_line_Shipment_Tbl.count LOOP
1360: found := FND_API.G_FALSE;
1361: FOR k in 1..p_qte_line_tbl.count LOOP

Line 1370: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1366:
1367: -- check if the line is satisfied by fulfillment (not required any more 02/09
1368:
1369: -- EDU
1370: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1371: aso_debug_pub.add('map_quote_to_order- p_qte_line_tbl(k).Commitment_Id: '||p_qte_line_tbl(k).Commitment_Id, 1, 'N');
1372: aso_debug_pub.add('map_quote_to_order- p_qte_line_tbl(k).Agreement_Id: '||p_qte_line_tbl(k).Agreement_Id,1, 'N');
1373: aso_debug_pub.add('map_quote_to_order- p_qte_line_tbl(k).minisite_id: '||p_qte_line_tbl(k).minisite_id,1, 'N');
1374: aso_debug_pub.add('map_quote_to_order- p_qte_rec.minisite_id: '||p_qte_rec.minisite_id,1, 'N');

Line 1371: aso_debug_pub.add('map_quote_to_order- p_qte_line_tbl(k).Commitment_Id: '||p_qte_line_tbl(k).Commitment_Id, 1, 'N');

1367: -- check if the line is satisfied by fulfillment (not required any more 02/09
1368:
1369: -- EDU
1370: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1371: aso_debug_pub.add('map_quote_to_order- p_qte_line_tbl(k).Commitment_Id: '||p_qte_line_tbl(k).Commitment_Id, 1, 'N');
1372: aso_debug_pub.add('map_quote_to_order- p_qte_line_tbl(k).Agreement_Id: '||p_qte_line_tbl(k).Agreement_Id,1, 'N');
1373: aso_debug_pub.add('map_quote_to_order- p_qte_line_tbl(k).minisite_id: '||p_qte_line_tbl(k).minisite_id,1, 'N');
1374: aso_debug_pub.add('map_quote_to_order- p_qte_rec.minisite_id: '||p_qte_rec.minisite_id,1, 'N');
1375: END IF;

Line 1372: aso_debug_pub.add('map_quote_to_order- p_qte_line_tbl(k).Agreement_Id: '||p_qte_line_tbl(k).Agreement_Id,1, 'N');

1368:
1369: -- EDU
1370: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1371: aso_debug_pub.add('map_quote_to_order- p_qte_line_tbl(k).Commitment_Id: '||p_qte_line_tbl(k).Commitment_Id, 1, 'N');
1372: aso_debug_pub.add('map_quote_to_order- p_qte_line_tbl(k).Agreement_Id: '||p_qte_line_tbl(k).Agreement_Id,1, 'N');
1373: aso_debug_pub.add('map_quote_to_order- p_qte_line_tbl(k).minisite_id: '||p_qte_line_tbl(k).minisite_id,1, 'N');
1374: aso_debug_pub.add('map_quote_to_order- p_qte_rec.minisite_id: '||p_qte_rec.minisite_id,1, 'N');
1375: END IF;
1376: IF p_qte_line_tbl(k).Commitment_Id IS NOT NULL AND

Line 1373: aso_debug_pub.add('map_quote_to_order- p_qte_line_tbl(k).minisite_id: '||p_qte_line_tbl(k).minisite_id,1, 'N');

1369: -- EDU
1370: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1371: aso_debug_pub.add('map_quote_to_order- p_qte_line_tbl(k).Commitment_Id: '||p_qte_line_tbl(k).Commitment_Id, 1, 'N');
1372: aso_debug_pub.add('map_quote_to_order- p_qte_line_tbl(k).Agreement_Id: '||p_qte_line_tbl(k).Agreement_Id,1, 'N');
1373: aso_debug_pub.add('map_quote_to_order- p_qte_line_tbl(k).minisite_id: '||p_qte_line_tbl(k).minisite_id,1, 'N');
1374: aso_debug_pub.add('map_quote_to_order- p_qte_rec.minisite_id: '||p_qte_rec.minisite_id,1, 'N');
1375: END IF;
1376: IF p_qte_line_tbl(k).Commitment_Id IS NOT NULL AND
1377: p_qte_line_tbl(k).Commitment_Id <> FND_API.G_MISS_NUM THEN

Line 1374: aso_debug_pub.add('map_quote_to_order- p_qte_rec.minisite_id: '||p_qte_rec.minisite_id,1, 'N');

1370: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1371: aso_debug_pub.add('map_quote_to_order- p_qte_line_tbl(k).Commitment_Id: '||p_qte_line_tbl(k).Commitment_Id, 1, 'N');
1372: aso_debug_pub.add('map_quote_to_order- p_qte_line_tbl(k).Agreement_Id: '||p_qte_line_tbl(k).Agreement_Id,1, 'N');
1373: aso_debug_pub.add('map_quote_to_order- p_qte_line_tbl(k).minisite_id: '||p_qte_line_tbl(k).minisite_id,1, 'N');
1374: aso_debug_pub.add('map_quote_to_order- p_qte_rec.minisite_id: '||p_qte_rec.minisite_id,1, 'N');
1375: END IF;
1376: IF p_qte_line_tbl(k).Commitment_Id IS NOT NULL AND
1377: p_qte_line_tbl(k).Commitment_Id <> FND_API.G_MISS_NUM THEN
1378: l_line_tbl(i).Commitment_Id := p_qte_line_tbl(k).Commitment_Id;

Line 1432: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1428:
1429: IF p_qte_line_tbl(k).invoice_to_cust_account_id <> FND_API.G_MISS_NUM AND
1430: p_qte_line_tbl(k).invoice_to_cust_account_id IS NOT NULL AND
1431: p_qte_line_tbl(k).invoice_to_cust_account_id <> l_cust_account_id THEN
1432: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1433: aso_debug_pub.add('mapq line: before cust_acct_reltn:p_sold_to_cust_account: '||l_cust_account_id,1,'N');
1434: aso_debug_pub.add('mapq line: before cust_acct_reltn:p_related_cust_account: '||p_qte_line_tbl(k).invoice_to_cust_account_id,1,'N');
1435: END IF;
1436: ASO_CHECK_TCA_PVT.Cust_acct_Relationship (

Line 1433: aso_debug_pub.add('mapq line: before cust_acct_reltn:p_sold_to_cust_account: '||l_cust_account_id,1,'N');

1429: IF p_qte_line_tbl(k).invoice_to_cust_account_id <> FND_API.G_MISS_NUM AND
1430: p_qte_line_tbl(k).invoice_to_cust_account_id IS NOT NULL AND
1431: p_qte_line_tbl(k).invoice_to_cust_account_id <> l_cust_account_id THEN
1432: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1433: aso_debug_pub.add('mapq line: before cust_acct_reltn:p_sold_to_cust_account: '||l_cust_account_id,1,'N');
1434: aso_debug_pub.add('mapq line: before cust_acct_reltn:p_related_cust_account: '||p_qte_line_tbl(k).invoice_to_cust_account_id,1,'N');
1435: END IF;
1436: ASO_CHECK_TCA_PVT.Cust_acct_Relationship (
1437: p_api_version => 1.0,

Line 1434: aso_debug_pub.add('mapq line: before cust_acct_reltn:p_related_cust_account: '||p_qte_line_tbl(k).invoice_to_cust_account_id,1,'N');

1430: p_qte_line_tbl(k).invoice_to_cust_account_id IS NOT NULL AND
1431: p_qte_line_tbl(k).invoice_to_cust_account_id <> l_cust_account_id THEN
1432: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1433: aso_debug_pub.add('mapq line: before cust_acct_reltn:p_sold_to_cust_account: '||l_cust_account_id,1,'N');
1434: aso_debug_pub.add('mapq line: before cust_acct_reltn:p_related_cust_account: '||p_qte_line_tbl(k).invoice_to_cust_account_id,1,'N');
1435: END IF;
1436: ASO_CHECK_TCA_PVT.Cust_acct_Relationship (
1437: p_api_version => 1.0,
1438: p_sold_to_cust_account => l_cust_account_id,

Line 1446: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1442: x_msg_count => l_msg_count,
1443: x_msg_data => l_msg_data
1444: );
1445:
1446: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1447: aso_debug_pub.add('mapq line: after cust_acct_reltn:l_return_status: '||l_return_status,1,'N');
1448: END IF;
1449: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1450: RAISE FND_API.G_EXC_ERROR;

Line 1447: aso_debug_pub.add('mapq line: after cust_acct_reltn:l_return_status: '||l_return_status,1,'N');

1443: x_msg_data => l_msg_data
1444: );
1445:
1446: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1447: aso_debug_pub.add('mapq line: after cust_acct_reltn:l_return_status: '||l_return_status,1,'N');
1448: END IF;
1449: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1450: RAISE FND_API.G_EXC_ERROR;
1451: END IF;

Line 1462: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1458: ELSE
1459: l_invoice_cust_account_id := l_header_rec.sold_to_org_id;
1460: END IF;
1461:
1462: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1463: aso_debug_pub.add('mapq line: before cust_acct_site:l_invoice_cust_account_id: '||l_invoice_cust_account_id,1,'N');
1464: aso_debug_pub.add('mapq line: before cust_acct_site:p_qte_line_tbl(k).invoice_to_party_site_id: '||p_qte_line_tbl(k).invoice_to_party_site_id,1,'N');
1465: END IF;
1466: IF p_qte_line_tbl(k).invoice_to_party_site_id is not NULL

Line 1463: aso_debug_pub.add('mapq line: before cust_acct_site:l_invoice_cust_account_id: '||l_invoice_cust_account_id,1,'N');

1459: l_invoice_cust_account_id := l_header_rec.sold_to_org_id;
1460: END IF;
1461:
1462: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1463: aso_debug_pub.add('mapq line: before cust_acct_site:l_invoice_cust_account_id: '||l_invoice_cust_account_id,1,'N');
1464: aso_debug_pub.add('mapq line: before cust_acct_site:p_qte_line_tbl(k).invoice_to_party_site_id: '||p_qte_line_tbl(k).invoice_to_party_site_id,1,'N');
1465: END IF;
1466: IF p_qte_line_tbl(k).invoice_to_party_site_id is not NULL
1467: AND p_qte_line_tbl(k).invoice_to_party_site_id <> FND_API.G_MISS_NUM THEN

Line 1464: aso_debug_pub.add('mapq line: before cust_acct_site:p_qte_line_tbl(k).invoice_to_party_site_id: '||p_qte_line_tbl(k).invoice_to_party_site_id,1,'N');

1460: END IF;
1461:
1462: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1463: aso_debug_pub.add('mapq line: before cust_acct_site:l_invoice_cust_account_id: '||l_invoice_cust_account_id,1,'N');
1464: aso_debug_pub.add('mapq line: before cust_acct_site:p_qte_line_tbl(k).invoice_to_party_site_id: '||p_qte_line_tbl(k).invoice_to_party_site_id,1,'N');
1465: END IF;
1466: IF p_qte_line_tbl(k).invoice_to_party_site_id is not NULL
1467: AND p_qte_line_tbl(k).invoice_to_party_site_id <> FND_API.G_MISS_NUM THEN
1468:

Line 1486: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1482: IF l_line_tbl(i).invoice_to_org_id IS NULL THEN
1483: l_line_tbl(i).invoice_to_org_id := FND_API.G_MISS_NUM;
1484: END IF;
1485:
1486: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1487: aso_debug_pub.add('mapq line: after cust_acct_site:l_line_tbl(i).invoice_to_org_id: '||l_line_tbl(i).invoice_to_org_id,1,'N');
1488: aso_debug_pub.add('mapq line: after cust_acct_site:l_ln_inv_cust_acct_site: '||l_ln_inv_cust_acct_site,1,'N');
1489: END IF;
1490: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1487: aso_debug_pub.add('mapq line: after cust_acct_site:l_line_tbl(i).invoice_to_org_id: '||l_line_tbl(i).invoice_to_org_id,1,'N');

1483: l_line_tbl(i).invoice_to_org_id := FND_API.G_MISS_NUM;
1484: END IF;
1485:
1486: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1487: aso_debug_pub.add('mapq line: after cust_acct_site:l_line_tbl(i).invoice_to_org_id: '||l_line_tbl(i).invoice_to_org_id,1,'N');
1488: aso_debug_pub.add('mapq line: after cust_acct_site:l_ln_inv_cust_acct_site: '||l_ln_inv_cust_acct_site,1,'N');
1489: END IF;
1490: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1491: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 1488: aso_debug_pub.add('mapq line: after cust_acct_site:l_ln_inv_cust_acct_site: '||l_ln_inv_cust_acct_site,1,'N');

1484: END IF;
1485:
1486: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1487: aso_debug_pub.add('mapq line: after cust_acct_site:l_line_tbl(i).invoice_to_org_id: '||l_line_tbl(i).invoice_to_org_id,1,'N');
1488: aso_debug_pub.add('mapq line: after cust_acct_site:l_ln_inv_cust_acct_site: '||l_ln_inv_cust_acct_site,1,'N');
1489: END IF;
1490: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1491: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1492: THEN

Line 1501: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1497: END IF;
1498:
1499: END IF;
1500:
1501: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1502: aso_debug_pub.add('mapq line: before Cust_Acct_Contact_Addr:l_invoice_cust_account_id: '||l_invoice_cust_account_id,1,'N');
1503: END IF;
1504:
1505: ASO_CHECK_TCA_PVT.Cust_Acct_Contact_Addr(

Line 1502: aso_debug_pub.add('mapq line: before Cust_Acct_Contact_Addr:l_invoice_cust_account_id: '||l_invoice_cust_account_id,1,'N');

1498:
1499: END IF;
1500:
1501: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1502: aso_debug_pub.add('mapq line: before Cust_Acct_Contact_Addr:l_invoice_cust_account_id: '||l_invoice_cust_account_id,1,'N');
1503: END IF;
1504:
1505: ASO_CHECK_TCA_PVT.Cust_Acct_Contact_Addr(
1506: p_api_version => 1.0,

Line 1521: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1517: IF l_line_tbl(i).invoice_to_contact_id IS NULL THEN
1518: l_line_tbl(i).invoice_to_contact_id := FND_API.G_MISS_NUM;
1519: END IF;
1520:
1521: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1522: aso_debug_pub.add('mapq line: after Cust_Acct_Contact_Addr:l_line_tbl(i).invoice_to_contact_id: '||l_line_tbl(i).invoice_to_contact_id,1,'N');
1523: END IF;
1524:
1525: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1522: aso_debug_pub.add('mapq line: after Cust_Acct_Contact_Addr:l_line_tbl(i).invoice_to_contact_id: '||l_line_tbl(i).invoice_to_contact_id,1,'N');

1518: l_line_tbl(i).invoice_to_contact_id := FND_API.G_MISS_NUM;
1519: END IF;
1520:
1521: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1522: aso_debug_pub.add('mapq line: after Cust_Acct_Contact_Addr:l_line_tbl(i).invoice_to_contact_id: '||l_line_tbl(i).invoice_to_contact_id,1,'N');
1523: END IF;
1524:
1525: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1526: raise FND_API.G_EXC_ERROR;

Line 1537: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1533: ELSE
1534: l_End_cust_account_id := l_header_rec.sold_to_org_id;
1535: END IF;
1536:
1537: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1538: aso_debug_pub.add('mapq line: before cust_acct_site:l_End_cust_account_id: '||l_End_cust_account_id,1,'N');
1539: aso_debug_pub.add('mapq line: before cust_acct_site:p_qte_line_tbl(k).End_Customer_party_site_id: '||p_qte_line_tbl(k).End_Customer_party_site_id,1,'N');
1540: END IF;
1541: IF p_qte_line_tbl(k).End_Customer_party_site_id is not NULL

Line 1538: aso_debug_pub.add('mapq line: before cust_acct_site:l_End_cust_account_id: '||l_End_cust_account_id,1,'N');

1534: l_End_cust_account_id := l_header_rec.sold_to_org_id;
1535: END IF;
1536:
1537: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1538: aso_debug_pub.add('mapq line: before cust_acct_site:l_End_cust_account_id: '||l_End_cust_account_id,1,'N');
1539: aso_debug_pub.add('mapq line: before cust_acct_site:p_qte_line_tbl(k).End_Customer_party_site_id: '||p_qte_line_tbl(k).End_Customer_party_site_id,1,'N');
1540: END IF;
1541: IF p_qte_line_tbl(k).End_Customer_party_site_id is not NULL
1542: AND p_qte_line_tbl(k).End_Customer_party_site_id <> FND_API.G_MISS_NUM THEN

Line 1539: aso_debug_pub.add('mapq line: before cust_acct_site:p_qte_line_tbl(k).End_Customer_party_site_id: '||p_qte_line_tbl(k).End_Customer_party_site_id,1,'N');

1535: END IF;
1536:
1537: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1538: aso_debug_pub.add('mapq line: before cust_acct_site:l_End_cust_account_id: '||l_End_cust_account_id,1,'N');
1539: aso_debug_pub.add('mapq line: before cust_acct_site:p_qte_line_tbl(k).End_Customer_party_site_id: '||p_qte_line_tbl(k).End_Customer_party_site_id,1,'N');
1540: END IF;
1541: IF p_qte_line_tbl(k).End_Customer_party_site_id is not NULL
1542: AND p_qte_line_tbl(k).End_Customer_party_site_id <> FND_API.G_MISS_NUM THEN
1543:

Line 1561: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1557: IF l_line_tbl(i).End_Customer_site_use_id IS NULL THEN
1558: l_line_tbl(i).End_Customer_site_use_id := FND_API.G_MISS_NUM;
1559: END IF;
1560:
1561: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1562: aso_debug_pub.add('mapq line: after cust_acct_site:l_line_tbl(i).End_Customer_site_use_id: '||l_line_tbl(i).End_Customer_site_use_id,1,'N');
1563: aso_debug_pub.add('mapq line: after cust_acct_site:l_ln_end_cust_acct_site: '||l_ln_end_cust_acct_site,1,'N');
1564: END IF;
1565: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1562: aso_debug_pub.add('mapq line: after cust_acct_site:l_line_tbl(i).End_Customer_site_use_id: '||l_line_tbl(i).End_Customer_site_use_id,1,'N');

1558: l_line_tbl(i).End_Customer_site_use_id := FND_API.G_MISS_NUM;
1559: END IF;
1560:
1561: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1562: aso_debug_pub.add('mapq line: after cust_acct_site:l_line_tbl(i).End_Customer_site_use_id: '||l_line_tbl(i).End_Customer_site_use_id,1,'N');
1563: aso_debug_pub.add('mapq line: after cust_acct_site:l_ln_end_cust_acct_site: '||l_ln_end_cust_acct_site,1,'N');
1564: END IF;
1565: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1566: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 1563: aso_debug_pub.add('mapq line: after cust_acct_site:l_ln_end_cust_acct_site: '||l_ln_end_cust_acct_site,1,'N');

1559: END IF;
1560:
1561: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1562: aso_debug_pub.add('mapq line: after cust_acct_site:l_line_tbl(i).End_Customer_site_use_id: '||l_line_tbl(i).End_Customer_site_use_id,1,'N');
1563: aso_debug_pub.add('mapq line: after cust_acct_site:l_ln_end_cust_acct_site: '||l_ln_end_cust_acct_site,1,'N');
1564: END IF;
1565: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1566: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1567: THEN

Line 1578: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1574: l_line_tbl(i).End_Customer_Id := l_End_cust_account_id;
1575:
1576: END IF;
1577:
1578: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1579: aso_debug_pub.add('mapq line: before Cust_Acct_Contact_Addr:l_End_cust_account_id: '||l_End_cust_account_id,1,'N');
1580: END IF;
1581:
1582: ASO_CHECK_TCA_PVT.Cust_Acct_Contact_Addr(

Line 1579: aso_debug_pub.add('mapq line: before Cust_Acct_Contact_Addr:l_End_cust_account_id: '||l_End_cust_account_id,1,'N');

1575:
1576: END IF;
1577:
1578: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1579: aso_debug_pub.add('mapq line: before Cust_Acct_Contact_Addr:l_End_cust_account_id: '||l_End_cust_account_id,1,'N');
1580: END IF;
1581:
1582: ASO_CHECK_TCA_PVT.Cust_Acct_Contact_Addr(
1583: p_api_version => 1.0,

Line 1598: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1594: IF l_line_tbl(i).End_Customer_contact_id IS NULL THEN
1595: l_line_tbl(i).End_Customer_contact_id := FND_API.G_MISS_NUM;
1596: END IF;
1597:
1598: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1599: aso_debug_pub.add('mapq line: after Cust_Acct_Contact_Addr:l_line_tbl(i).End_Customer_contact_id: '||l_line_tbl(i).End_Customer_contact_id,1,'N');
1600: aso_debug_pub.add('mapq line: after Cust_Acct_Contact_Addr:l_line_tbl(i).End_Customer_id: '||l_line_tbl(i).End_Customer_id,1,'N');
1601: END IF;
1602:

Line 1599: aso_debug_pub.add('mapq line: after Cust_Acct_Contact_Addr:l_line_tbl(i).End_Customer_contact_id: '||l_line_tbl(i).End_Customer_contact_id,1,'N');

1595: l_line_tbl(i).End_Customer_contact_id := FND_API.G_MISS_NUM;
1596: END IF;
1597:
1598: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1599: aso_debug_pub.add('mapq line: after Cust_Acct_Contact_Addr:l_line_tbl(i).End_Customer_contact_id: '||l_line_tbl(i).End_Customer_contact_id,1,'N');
1600: aso_debug_pub.add('mapq line: after Cust_Acct_Contact_Addr:l_line_tbl(i).End_Customer_id: '||l_line_tbl(i).End_Customer_id,1,'N');
1601: END IF;
1602:
1603: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1600: aso_debug_pub.add('mapq line: after Cust_Acct_Contact_Addr:l_line_tbl(i).End_Customer_id: '||l_line_tbl(i).End_Customer_id,1,'N');

1596: END IF;
1597:
1598: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1599: aso_debug_pub.add('mapq line: after Cust_Acct_Contact_Addr:l_line_tbl(i).End_Customer_contact_id: '||l_line_tbl(i).End_Customer_contact_id,1,'N');
1600: aso_debug_pub.add('mapq line: after Cust_Acct_Contact_Addr:l_line_tbl(i).End_Customer_id: '||l_line_tbl(i).End_Customer_id,1,'N');
1601: END IF;
1602:
1603: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1604: raise FND_API.G_EXC_ERROR;

Line 1677: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1673:
1674:
1675: IF (p_qte_line_dtl_tbl(l).qte_line_index = k) THEN
1676:
1677: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1678: aso_debug_pub.add('in quote line details',1,'N');
1679: END IF;
1680: l_line_tbl(i).service_duration:=p_qte_line_dtl_tbl(l).service_duration;
1681: l_line_tbl(i).service_period := p_qte_line_dtl_tbl(l).service_period;

Line 1678: aso_debug_pub.add('in quote line details',1,'N');

1674:
1675: IF (p_qte_line_dtl_tbl(l).qte_line_index = k) THEN
1676:
1677: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1678: aso_debug_pub.add('in quote line details',1,'N');
1679: END IF;
1680: l_line_tbl(i).service_duration:=p_qte_line_dtl_tbl(l).service_duration;
1681: l_line_tbl(i).service_period := p_qte_line_dtl_tbl(l).service_period;
1682: l_line_tbl(i).service_start_date:= p_qte_line_tbl(k).start_date_active;

Line 1795: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1791: l_line_tbl(i).return_context
1792: := p_qte_line_dtl_tbl(l).return_attribute_category;
1793: END IF;
1794:
1795: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1796: aso_debug_pub.add('l_ret_reason_code_prof: '||l_ret_reason_code_prof,1,'N');
1797: END IF;
1798:
1799: IF p_qte_line_tbl(k).line_category_code = 'RETURN' THEN

Line 1796: aso_debug_pub.add('l_ret_reason_code_prof: '||l_ret_reason_code_prof,1,'N');

1792: := p_qte_line_dtl_tbl(l).return_attribute_category;
1793: END IF;
1794:
1795: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1796: aso_debug_pub.add('l_ret_reason_code_prof: '||l_ret_reason_code_prof,1,'N');
1797: END IF;
1798:
1799: IF p_qte_line_tbl(k).line_category_code = 'RETURN' THEN
1800:

Line 1888: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1884:
1885: option_item := k;
1886: parent := option_item;
1887:
1888: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1889: aso_debug_pub.add('p_Line_Rltship_TBL.count is '||p_Line_Rltship_TBL.count,1 ,'N');
1890: END IF;
1891:
1892: FOR count_2 in 1..p_Line_Rltship_TBL.count LOOP

Line 1889: aso_debug_pub.add('p_Line_Rltship_TBL.count is '||p_Line_Rltship_TBL.count,1 ,'N');

1885: option_item := k;
1886: parent := option_item;
1887:
1888: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1889: aso_debug_pub.add('p_Line_Rltship_TBL.count is '||p_Line_Rltship_TBL.count,1 ,'N');
1890: END IF;
1891:
1892: FOR count_2 in 1..p_Line_Rltship_TBL.count LOOP
1893: if ( p_Line_Rltship_TBL(count_2).related_qte_line_index

Line 1900: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1896: EXIT;
1897: end if;
1898: END LOOP;
1899:
1900: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1901: aso_debug_pub.add('parent item is '||parent,1,'N');
1902: END IF;
1903:
1904: IF (parent <> option_item) THEN

Line 1901: aso_debug_pub.add('parent item is '||parent,1,'N');

1897: end if;
1898: END LOOP;
1899:
1900: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1901: aso_debug_pub.add('parent item is '||parent,1,'N');
1902: END IF;
1903:
1904: IF (parent <> option_item) THEN
1905: -- figure OUT NOCOPY /* file.sql.39 change */ the shipment line index for the corresponding qte line index.

Line 1920: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1916:
1917: END IF;
1918: END LOOP; -- line details
1919:
1920: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1921: aso_debug_pub.add('l_ret_reason_code_prof: '||l_ret_reason_code_prof,1,'N');
1922: END IF;
1923:
1924: IF p_qte_line_tbl(k).line_category_code = 'RETURN' THEN

Line 1921: aso_debug_pub.add('l_ret_reason_code_prof: '||l_ret_reason_code_prof,1,'N');

1917: END IF;
1918: END LOOP; -- line details
1919:
1920: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1921: aso_debug_pub.add('l_ret_reason_code_prof: '||l_ret_reason_code_prof,1,'N');
1922: END IF;
1923:
1924: IF p_qte_line_tbl(k).line_category_code = 'RETURN' THEN
1925: -- Default return reason code from profile

Line 2018: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2014: IF (p_line_shipment_tbl(j).demand_class_code is not null and p_line_shipment_tbl(j).demand_class_code <> fnd_api.g_miss_char) then
2015: l_line_tbl(i).demand_class_code := p_line_shipment_tbl(j).demand_class_code;
2016: end if;
2017:
2018: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2019: aso_debug_pub.add('p_line_shipment_tbl(j).Ship_From_Org_Id: '||p_line_shipment_tbl(j).Ship_From_Org_Id,1,'N');
2020: END IF;
2021:
2022: IF p_line_shipment_tbl(j).Ship_From_Org_Id IS NOT NULL AND

Line 2019: aso_debug_pub.add('p_line_shipment_tbl(j).Ship_From_Org_Id: '||p_line_shipment_tbl(j).Ship_From_Org_Id,1,'N');

2015: l_line_tbl(i).demand_class_code := p_line_shipment_tbl(j).demand_class_code;
2016: end if;
2017:
2018: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2019: aso_debug_pub.add('p_line_shipment_tbl(j).Ship_From_Org_Id: '||p_line_shipment_tbl(j).Ship_From_Org_Id,1,'N');
2020: END IF;
2021:
2022: IF p_line_shipment_tbl(j).Ship_From_Org_Id IS NOT NULL AND
2023: p_line_shipment_tbl(j).Ship_From_Org_Id <> FND_API.G_MISS_NUM THEN

Line 2030: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2026:
2027: IF p_line_shipment_tbl(j).ship_to_cust_account_id <> FND_API.G_MISS_NUM AND
2028: p_line_shipment_tbl(j).ship_to_cust_account_id IS NOT NULL AND
2029: p_line_shipment_tbl(j).ship_to_cust_account_id <> l_cust_account_id THEN
2030: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2031: aso_debug_pub.add('before cust_acct_reltn:p_sold_to_cust_account: '||l_cust_account_id,1,'N');
2032: aso_debug_pub.add('before cust_acct_reltn:p_related_cust_account: '||p_line_shipment_tbl(j).ship_to_cust_account_id,1,'N');
2033: END IF;
2034: ASO_CHECK_TCA_PVT.Cust_acct_Relationship (

Line 2031: aso_debug_pub.add('before cust_acct_reltn:p_sold_to_cust_account: '||l_cust_account_id,1,'N');

2027: IF p_line_shipment_tbl(j).ship_to_cust_account_id <> FND_API.G_MISS_NUM AND
2028: p_line_shipment_tbl(j).ship_to_cust_account_id IS NOT NULL AND
2029: p_line_shipment_tbl(j).ship_to_cust_account_id <> l_cust_account_id THEN
2030: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2031: aso_debug_pub.add('before cust_acct_reltn:p_sold_to_cust_account: '||l_cust_account_id,1,'N');
2032: aso_debug_pub.add('before cust_acct_reltn:p_related_cust_account: '||p_line_shipment_tbl(j).ship_to_cust_account_id,1,'N');
2033: END IF;
2034: ASO_CHECK_TCA_PVT.Cust_acct_Relationship (
2035: p_api_version => 1.0,

Line 2032: aso_debug_pub.add('before cust_acct_reltn:p_related_cust_account: '||p_line_shipment_tbl(j).ship_to_cust_account_id,1,'N');

2028: p_line_shipment_tbl(j).ship_to_cust_account_id IS NOT NULL AND
2029: p_line_shipment_tbl(j).ship_to_cust_account_id <> l_cust_account_id THEN
2030: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2031: aso_debug_pub.add('before cust_acct_reltn:p_sold_to_cust_account: '||l_cust_account_id,1,'N');
2032: aso_debug_pub.add('before cust_acct_reltn:p_related_cust_account: '||p_line_shipment_tbl(j).ship_to_cust_account_id,1,'N');
2033: END IF;
2034: ASO_CHECK_TCA_PVT.Cust_acct_Relationship (
2035: p_api_version => 1.0,
2036: p_sold_to_cust_account => l_cust_account_id,

Line 2043: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2039: x_return_status => l_return_status,
2040: x_msg_count => l_msg_count,
2041: x_msg_data => l_msg_data
2042: );
2043: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2044: aso_debug_pub.add('after cust_acct_reltn:l_return_status: '||l_return_status,1,'N');
2045: END IF;
2046:
2047: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 2044: aso_debug_pub.add('after cust_acct_reltn:l_return_status: '||l_return_status,1,'N');

2040: x_msg_count => l_msg_count,
2041: x_msg_data => l_msg_data
2042: );
2043: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2044: aso_debug_pub.add('after cust_acct_reltn:l_return_status: '||l_return_status,1,'N');
2045: END IF;
2046:
2047: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2048: RAISE FND_API.G_EXC_ERROR;

Line 2060: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2056: ELSE
2057: l_ship_cust_account_id := l_header_rec.sold_to_org_id;
2058: END IF;
2059:
2060: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2061: aso_debug_pub.add('mapq line: before cust_acct_site:l_ship_cust_account_id: '||l_ship_cust_account_id,1,'N');
2062: aso_debug_pub.add('p_line_shipment_tbl(j).ship_to_party_site_id: '||p_line_shipment_tbl(j).ship_to_party_site_id,1,'N');
2063: END IF;
2064: IF p_line_shipment_tbl(j).ship_to_party_site_id is not NULL AND

Line 2061: aso_debug_pub.add('mapq line: before cust_acct_site:l_ship_cust_account_id: '||l_ship_cust_account_id,1,'N');

2057: l_ship_cust_account_id := l_header_rec.sold_to_org_id;
2058: END IF;
2059:
2060: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2061: aso_debug_pub.add('mapq line: before cust_acct_site:l_ship_cust_account_id: '||l_ship_cust_account_id,1,'N');
2062: aso_debug_pub.add('p_line_shipment_tbl(j).ship_to_party_site_id: '||p_line_shipment_tbl(j).ship_to_party_site_id,1,'N');
2063: END IF;
2064: IF p_line_shipment_tbl(j).ship_to_party_site_id is not NULL AND
2065: p_line_shipment_tbl(j).ship_to_party_site_id <> FND_API.G_MISS_NUM THEN

Line 2062: aso_debug_pub.add('p_line_shipment_tbl(j).ship_to_party_site_id: '||p_line_shipment_tbl(j).ship_to_party_site_id,1,'N');

2058: END IF;
2059:
2060: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2061: aso_debug_pub.add('mapq line: before cust_acct_site:l_ship_cust_account_id: '||l_ship_cust_account_id,1,'N');
2062: aso_debug_pub.add('p_line_shipment_tbl(j).ship_to_party_site_id: '||p_line_shipment_tbl(j).ship_to_party_site_id,1,'N');
2063: END IF;
2064: IF p_line_shipment_tbl(j).ship_to_party_site_id is not NULL AND
2065: p_line_shipment_tbl(j).ship_to_party_site_id <> FND_API.G_MISS_NUM THEN
2066:

Line 2084: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2080: IF l_line_tbl(i).ship_to_org_id IS NULL THEN
2081: l_line_tbl(i).ship_to_org_id := FND_API.G_MISS_NUM;
2082: END IF;
2083:
2084: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2085: aso_debug_pub.add('mapq line: after cust_acct_site:l_line_tbl(i).ship_to_org_id: '||l_line_tbl(i).ship_to_org_id,1,'N');
2086: aso_debug_pub.add('mapq line: after cust_acct_site:l_ln_shp_cust_acct_site: '||l_ln_shp_cust_acct_site,1,'N');
2087: END IF;
2088: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 2085: aso_debug_pub.add('mapq line: after cust_acct_site:l_line_tbl(i).ship_to_org_id: '||l_line_tbl(i).ship_to_org_id,1,'N');

2081: l_line_tbl(i).ship_to_org_id := FND_API.G_MISS_NUM;
2082: END IF;
2083:
2084: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2085: aso_debug_pub.add('mapq line: after cust_acct_site:l_line_tbl(i).ship_to_org_id: '||l_line_tbl(i).ship_to_org_id,1,'N');
2086: aso_debug_pub.add('mapq line: after cust_acct_site:l_ln_shp_cust_acct_site: '||l_ln_shp_cust_acct_site,1,'N');
2087: END IF;
2088: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2089: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 2086: aso_debug_pub.add('mapq line: after cust_acct_site:l_ln_shp_cust_acct_site: '||l_ln_shp_cust_acct_site,1,'N');

2082: END IF;
2083:
2084: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2085: aso_debug_pub.add('mapq line: after cust_acct_site:l_line_tbl(i).ship_to_org_id: '||l_line_tbl(i).ship_to_org_id,1,'N');
2086: aso_debug_pub.add('mapq line: after cust_acct_site:l_ln_shp_cust_acct_site: '||l_ln_shp_cust_acct_site,1,'N');
2087: END IF;
2088: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2089: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2090: THEN

Line 2099: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2095: END IF;
2096:
2097: END IF;
2098:
2099: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2100: aso_debug_pub.add('p_line_shipment_tbl(j).ship_to_party_id: '||p_line_shipment_tbl(j).ship_to_party_id,1,'N');
2101: aso_debug_pub.add('p_line_shipment_tbl(j).ship_to_party_site_id: '||p_line_shipment_tbl(j).ship_to_party_site_id,1,'N');
2102: aso_debug_pub.add('mapq line: before Cust_Acct_Contact_Addr:l_ship_cust_account_id: '||l_ship_cust_account_id,1,'N');
2103: END IF;

Line 2100: aso_debug_pub.add('p_line_shipment_tbl(j).ship_to_party_id: '||p_line_shipment_tbl(j).ship_to_party_id,1,'N');

2096:
2097: END IF;
2098:
2099: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2100: aso_debug_pub.add('p_line_shipment_tbl(j).ship_to_party_id: '||p_line_shipment_tbl(j).ship_to_party_id,1,'N');
2101: aso_debug_pub.add('p_line_shipment_tbl(j).ship_to_party_site_id: '||p_line_shipment_tbl(j).ship_to_party_site_id,1,'N');
2102: aso_debug_pub.add('mapq line: before Cust_Acct_Contact_Addr:l_ship_cust_account_id: '||l_ship_cust_account_id,1,'N');
2103: END IF;
2104:

Line 2101: aso_debug_pub.add('p_line_shipment_tbl(j).ship_to_party_site_id: '||p_line_shipment_tbl(j).ship_to_party_site_id,1,'N');

2097: END IF;
2098:
2099: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2100: aso_debug_pub.add('p_line_shipment_tbl(j).ship_to_party_id: '||p_line_shipment_tbl(j).ship_to_party_id,1,'N');
2101: aso_debug_pub.add('p_line_shipment_tbl(j).ship_to_party_site_id: '||p_line_shipment_tbl(j).ship_to_party_site_id,1,'N');
2102: aso_debug_pub.add('mapq line: before Cust_Acct_Contact_Addr:l_ship_cust_account_id: '||l_ship_cust_account_id,1,'N');
2103: END IF;
2104:
2105: ASO_CHECK_TCA_PVT.Cust_Acct_Contact_Addr(

Line 2102: aso_debug_pub.add('mapq line: before Cust_Acct_Contact_Addr:l_ship_cust_account_id: '||l_ship_cust_account_id,1,'N');

2098:
2099: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2100: aso_debug_pub.add('p_line_shipment_tbl(j).ship_to_party_id: '||p_line_shipment_tbl(j).ship_to_party_id,1,'N');
2101: aso_debug_pub.add('p_line_shipment_tbl(j).ship_to_party_site_id: '||p_line_shipment_tbl(j).ship_to_party_site_id,1,'N');
2102: aso_debug_pub.add('mapq line: before Cust_Acct_Contact_Addr:l_ship_cust_account_id: '||l_ship_cust_account_id,1,'N');
2103: END IF;
2104:
2105: ASO_CHECK_TCA_PVT.Cust_Acct_Contact_Addr(
2106: p_api_version => 1.0,

Line 2121: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2117: IF l_line_tbl(i).ship_to_contact_id IS NULL THEN
2118: l_line_tbl(i).ship_to_contact_id := FND_API.G_MISS_NUM;
2119: END IF;
2120:
2121: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2122: aso_debug_pub.add('mapq line: after Cust_Acct_Contact_Addr:l_line_tbl(i).ship_to_contact_id: '||l_line_tbl(i).ship_to_contact_id,1,'N');
2123: END IF;
2124:
2125: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 2122: aso_debug_pub.add('mapq line: after Cust_Acct_Contact_Addr:l_line_tbl(i).ship_to_contact_id: '||l_line_tbl(i).ship_to_contact_id,1,'N');

2118: l_line_tbl(i).ship_to_contact_id := FND_API.G_MISS_NUM;
2119: END IF;
2120:
2121: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2122: aso_debug_pub.add('mapq line: after Cust_Acct_Contact_Addr:l_line_tbl(i).ship_to_contact_id: '||l_line_tbl(i).ship_to_contact_id,1,'N');
2123: END IF;
2124:
2125: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2126: raise FND_API.G_EXC_ERROR;

Line 2136: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2132: l_line_tbl(i).source_document_type_id
2133: := l_header_rec.source_document_type_id;
2134: l_line_tbl(i).orig_sys_document_ref := l_header_rec.orig_sys_document_ref;
2135:
2136: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2137: aso_debug_pub.add('l_line_tbl(i).orig_sys_document_ref: '||l_line_tbl(i).orig_sys_document_ref,1,'N');
2138: END IF;
2139:
2140: IF p_qte_line_tbl(k).ui_line_number IS NOT NULL AND

Line 2137: aso_debug_pub.add('l_line_tbl(i).orig_sys_document_ref: '||l_line_tbl(i).orig_sys_document_ref,1,'N');

2133: := l_header_rec.source_document_type_id;
2134: l_line_tbl(i).orig_sys_document_ref := l_header_rec.orig_sys_document_ref;
2135:
2136: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2137: aso_debug_pub.add('l_line_tbl(i).orig_sys_document_ref: '||l_line_tbl(i).orig_sys_document_ref,1,'N');
2138: END IF;
2139:
2140: IF p_qte_line_tbl(k).ui_line_number IS NOT NULL AND
2141: p_qte_line_tbl(k).ui_line_number <> FND_API.G_MISS_CHAR THEN

Line 2147: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2143:
2144: ELSIF p_qte_line_tbl(k).line_number IS NOT NULL
2145: AND p_qte_line_tbl(k).line_number <> FND_API.G_MISS_NUM THEN
2146:
2147: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2148: aso_debug_pub.add('p_qte_line_tbl(k).line_number: '||p_qte_line_tbl(k).line_number,1,'N');
2149: END IF;
2150:
2151: l_line_tbl(i).orig_sys_line_ref := to_char(p_qte_line_tbl(k).line_number);

Line 2148: aso_debug_pub.add('p_qte_line_tbl(k).line_number: '||p_qte_line_tbl(k).line_number,1,'N');

2144: ELSIF p_qte_line_tbl(k).line_number IS NOT NULL
2145: AND p_qte_line_tbl(k).line_number <> FND_API.G_MISS_NUM THEN
2146:
2147: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2148: aso_debug_pub.add('p_qte_line_tbl(k).line_number: '||p_qte_line_tbl(k).line_number,1,'N');
2149: END IF;
2150:
2151: l_line_tbl(i).orig_sys_line_ref := to_char(p_qte_line_tbl(k).line_number);
2152:

Line 2155: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2151: l_line_tbl(i).orig_sys_line_ref := to_char(p_qte_line_tbl(k).line_number);
2152:
2153: END IF;
2154:
2155: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2156: aso_debug_pub.add('l_line_tbl(i).orig_sys_line_ref: '||l_line_tbl(i).orig_sys_line_ref,1,'N');
2157: END IF;
2158:
2159: -- must have both the index values for create

Line 2156: aso_debug_pub.add('l_line_tbl(i).orig_sys_line_ref: '||l_line_tbl(i).orig_sys_line_ref,1,'N');

2152:
2153: END IF;
2154:
2155: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2156: aso_debug_pub.add('l_line_tbl(i).orig_sys_line_ref: '||l_line_tbl(i).orig_sys_line_ref,1,'N');
2157: END IF;
2158:
2159: -- must have both the index values for create
2160:

Line 2209: if aso_debug_pub.g_debug_flag = 'Y' then

2205: l_Line_Adj_tbl(l_line_adj_tbl_count + 1).list_line_type_code := 'TAX';
2206: l_Line_Adj_tbl(l_line_adj_tbl_count + 1).arithmetic_operator := 'AMT';
2207: l_Line_Adj_tbl(l_line_adj_tbl_count + 1).operation := OE_GLOBALS.g_opr_create;
2208:
2209: if aso_debug_pub.g_debug_flag = 'Y' then
2210:
2211: aso_debug_pub.add('l_line_tbl('||i||').tax_exempt_flag: '||l_line_tbl(i).tax_exempt_flag,1,'N');
2212: aso_debug_pub.add('l_line_tbl('||i||').tax_exempt_number: '||l_line_tbl(i).tax_exempt_number,1,'N');
2213: aso_debug_pub.add('l_line_tbl('||i||').tax_exempt_reason_code: '||l_line_tbl(i).tax_exempt_reason_code,1,'N');

Line 2211: aso_debug_pub.add('l_line_tbl('||i||').tax_exempt_flag: '||l_line_tbl(i).tax_exempt_flag,1,'N');

2207: l_Line_Adj_tbl(l_line_adj_tbl_count + 1).operation := OE_GLOBALS.g_opr_create;
2208:
2209: if aso_debug_pub.g_debug_flag = 'Y' then
2210:
2211: aso_debug_pub.add('l_line_tbl('||i||').tax_exempt_flag: '||l_line_tbl(i).tax_exempt_flag,1,'N');
2212: aso_debug_pub.add('l_line_tbl('||i||').tax_exempt_number: '||l_line_tbl(i).tax_exempt_number,1,'N');
2213: aso_debug_pub.add('l_line_tbl('||i||').tax_exempt_reason_code: '||l_line_tbl(i).tax_exempt_reason_code,1,'N');
2214: aso_debug_pub.add('l_line_tbl('||i||').tax_date: ' ||l_line_tbl(i).tax_date,1,'N');
2215: aso_debug_pub.add('l_line_tbl('||i||').tax_rate: ' ||l_line_tbl(i).tax_rate,1,'N');

Line 2212: aso_debug_pub.add('l_line_tbl('||i||').tax_exempt_number: '||l_line_tbl(i).tax_exempt_number,1,'N');

2208:
2209: if aso_debug_pub.g_debug_flag = 'Y' then
2210:
2211: aso_debug_pub.add('l_line_tbl('||i||').tax_exempt_flag: '||l_line_tbl(i).tax_exempt_flag,1,'N');
2212: aso_debug_pub.add('l_line_tbl('||i||').tax_exempt_number: '||l_line_tbl(i).tax_exempt_number,1,'N');
2213: aso_debug_pub.add('l_line_tbl('||i||').tax_exempt_reason_code: '||l_line_tbl(i).tax_exempt_reason_code,1,'N');
2214: aso_debug_pub.add('l_line_tbl('||i||').tax_date: ' ||l_line_tbl(i).tax_date,1,'N');
2215: aso_debug_pub.add('l_line_tbl('||i||').tax_rate: ' ||l_line_tbl(i).tax_rate,1,'N');
2216: aso_debug_pub.add('l_line_tbl('||i||').tax_value: ' ||l_line_tbl(i).tax_value,1,'N');

Line 2213: aso_debug_pub.add('l_line_tbl('||i||').tax_exempt_reason_code: '||l_line_tbl(i).tax_exempt_reason_code,1,'N');

2209: if aso_debug_pub.g_debug_flag = 'Y' then
2210:
2211: aso_debug_pub.add('l_line_tbl('||i||').tax_exempt_flag: '||l_line_tbl(i).tax_exempt_flag,1,'N');
2212: aso_debug_pub.add('l_line_tbl('||i||').tax_exempt_number: '||l_line_tbl(i).tax_exempt_number,1,'N');
2213: aso_debug_pub.add('l_line_tbl('||i||').tax_exempt_reason_code: '||l_line_tbl(i).tax_exempt_reason_code,1,'N');
2214: aso_debug_pub.add('l_line_tbl('||i||').tax_date: ' ||l_line_tbl(i).tax_date,1,'N');
2215: aso_debug_pub.add('l_line_tbl('||i||').tax_rate: ' ||l_line_tbl(i).tax_rate,1,'N');
2216: aso_debug_pub.add('l_line_tbl('||i||').tax_value: ' ||l_line_tbl(i).tax_value,1,'N');
2217:

Line 2214: aso_debug_pub.add('l_line_tbl('||i||').tax_date: ' ||l_line_tbl(i).tax_date,1,'N');

2210:
2211: aso_debug_pub.add('l_line_tbl('||i||').tax_exempt_flag: '||l_line_tbl(i).tax_exempt_flag,1,'N');
2212: aso_debug_pub.add('l_line_tbl('||i||').tax_exempt_number: '||l_line_tbl(i).tax_exempt_number,1,'N');
2213: aso_debug_pub.add('l_line_tbl('||i||').tax_exempt_reason_code: '||l_line_tbl(i).tax_exempt_reason_code,1,'N');
2214: aso_debug_pub.add('l_line_tbl('||i||').tax_date: ' ||l_line_tbl(i).tax_date,1,'N');
2215: aso_debug_pub.add('l_line_tbl('||i||').tax_rate: ' ||l_line_tbl(i).tax_rate,1,'N');
2216: aso_debug_pub.add('l_line_tbl('||i||').tax_value: ' ||l_line_tbl(i).tax_value,1,'N');
2217:
2218: end if;

Line 2215: aso_debug_pub.add('l_line_tbl('||i||').tax_rate: ' ||l_line_tbl(i).tax_rate,1,'N');

2211: aso_debug_pub.add('l_line_tbl('||i||').tax_exempt_flag: '||l_line_tbl(i).tax_exempt_flag,1,'N');
2212: aso_debug_pub.add('l_line_tbl('||i||').tax_exempt_number: '||l_line_tbl(i).tax_exempt_number,1,'N');
2213: aso_debug_pub.add('l_line_tbl('||i||').tax_exempt_reason_code: '||l_line_tbl(i).tax_exempt_reason_code,1,'N');
2214: aso_debug_pub.add('l_line_tbl('||i||').tax_date: ' ||l_line_tbl(i).tax_date,1,'N');
2215: aso_debug_pub.add('l_line_tbl('||i||').tax_rate: ' ||l_line_tbl(i).tax_rate,1,'N');
2216: aso_debug_pub.add('l_line_tbl('||i||').tax_value: ' ||l_line_tbl(i).tax_value,1,'N');
2217:
2218: end if;
2219:

Line 2216: aso_debug_pub.add('l_line_tbl('||i||').tax_value: ' ||l_line_tbl(i).tax_value,1,'N');

2212: aso_debug_pub.add('l_line_tbl('||i||').tax_exempt_number: '||l_line_tbl(i).tax_exempt_number,1,'N');
2213: aso_debug_pub.add('l_line_tbl('||i||').tax_exempt_reason_code: '||l_line_tbl(i).tax_exempt_reason_code,1,'N');
2214: aso_debug_pub.add('l_line_tbl('||i||').tax_date: ' ||l_line_tbl(i).tax_date,1,'N');
2215: aso_debug_pub.add('l_line_tbl('||i||').tax_rate: ' ||l_line_tbl(i).tax_rate,1,'N');
2216: aso_debug_pub.add('l_line_tbl('||i||').tax_value: ' ||l_line_tbl(i).tax_value,1,'N');
2217:
2218: end if;
2219:
2220: /*

Line 2221: if aso_debug_pub.g_debug_flag = 'Y' then

2217:
2218: end if;
2219:
2220: /*
2221: if aso_debug_pub.g_debug_flag = 'Y' then
2222:
2223: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').price_adjustment_id: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).price_adjustment_id,1,'N');
2224: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').line_index: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).line_index,1,'N');
2225: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').tax_rate_id: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).tax_rate_id,1,'N');

Line 2223: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').price_adjustment_id: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).price_adjustment_id,1,'N');

2219:
2220: /*
2221: if aso_debug_pub.g_debug_flag = 'Y' then
2222:
2223: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').price_adjustment_id: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).price_adjustment_id,1,'N');
2224: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').line_index: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).line_index,1,'N');
2225: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').tax_rate_id: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).tax_rate_id,1,'N');
2226: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').operand: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).operand,1,'N');
2227: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').adjusted_amount: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).adjusted_amount,1,'N');

Line 2224: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').line_index: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).line_index,1,'N');

2220: /*
2221: if aso_debug_pub.g_debug_flag = 'Y' then
2222:
2223: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').price_adjustment_id: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).price_adjustment_id,1,'N');
2224: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').line_index: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).line_index,1,'N');
2225: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').tax_rate_id: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).tax_rate_id,1,'N');
2226: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').operand: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).operand,1,'N');
2227: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').adjusted_amount: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).adjusted_amount,1,'N');
2228: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').automatic_flag: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).automatic_flag,1,'N');

Line 2225: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').tax_rate_id: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).tax_rate_id,1,'N');

2221: if aso_debug_pub.g_debug_flag = 'Y' then
2222:
2223: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').price_adjustment_id: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).price_adjustment_id,1,'N');
2224: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').line_index: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).line_index,1,'N');
2225: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').tax_rate_id: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).tax_rate_id,1,'N');
2226: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').operand: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).operand,1,'N');
2227: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').adjusted_amount: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).adjusted_amount,1,'N');
2228: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').automatic_flag: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).automatic_flag,1,'N');
2229: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').list_line_type_code: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).list_line_type_code,1,'N');

Line 2226: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').operand: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).operand,1,'N');

2222:
2223: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').price_adjustment_id: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).price_adjustment_id,1,'N');
2224: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').line_index: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).line_index,1,'N');
2225: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').tax_rate_id: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).tax_rate_id,1,'N');
2226: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').operand: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).operand,1,'N');
2227: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').adjusted_amount: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).adjusted_amount,1,'N');
2228: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').automatic_flag: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).automatic_flag,1,'N');
2229: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').list_line_type_code: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).list_line_type_code,1,'N');
2230: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').arithmetic_operator: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).arithmetic_operator,1,'N');

Line 2227: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').adjusted_amount: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).adjusted_amount,1,'N');

2223: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').price_adjustment_id: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).price_adjustment_id,1,'N');
2224: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').line_index: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).line_index,1,'N');
2225: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').tax_rate_id: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).tax_rate_id,1,'N');
2226: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').operand: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).operand,1,'N');
2227: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').adjusted_amount: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).adjusted_amount,1,'N');
2228: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').automatic_flag: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).automatic_flag,1,'N');
2229: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').list_line_type_code: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).list_line_type_code,1,'N');
2230: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').arithmetic_operator: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).arithmetic_operator,1,'N');
2231: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').operation: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).operation,1,'N');

Line 2228: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').automatic_flag: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).automatic_flag,1,'N');

2224: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').line_index: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).line_index,1,'N');
2225: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').tax_rate_id: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).tax_rate_id,1,'N');
2226: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').operand: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).operand,1,'N');
2227: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').adjusted_amount: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).adjusted_amount,1,'N');
2228: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').automatic_flag: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).automatic_flag,1,'N');
2229: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').list_line_type_code: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).list_line_type_code,1,'N');
2230: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').arithmetic_operator: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).arithmetic_operator,1,'N');
2231: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').operation: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).operation,1,'N');
2232:

Line 2229: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').list_line_type_code: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).list_line_type_code,1,'N');

2225: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').tax_rate_id: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).tax_rate_id,1,'N');
2226: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').operand: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).operand,1,'N');
2227: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').adjusted_amount: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).adjusted_amount,1,'N');
2228: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').automatic_flag: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).automatic_flag,1,'N');
2229: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').list_line_type_code: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).list_line_type_code,1,'N');
2230: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').arithmetic_operator: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).arithmetic_operator,1,'N');
2231: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').operation: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).operation,1,'N');
2232:
2233: end if;

Line 2230: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').arithmetic_operator: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).arithmetic_operator,1,'N');

2226: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').operand: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).operand,1,'N');
2227: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').adjusted_amount: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).adjusted_amount,1,'N');
2228: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').automatic_flag: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).automatic_flag,1,'N');
2229: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').list_line_type_code: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).list_line_type_code,1,'N');
2230: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').arithmetic_operator: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).arithmetic_operator,1,'N');
2231: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').operation: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).operation,1,'N');
2232:
2233: end if;
2234:

Line 2231: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').operation: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).operation,1,'N');

2227: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').adjusted_amount: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).adjusted_amount,1,'N');
2228: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').automatic_flag: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).automatic_flag,1,'N');
2229: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').list_line_type_code: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).list_line_type_code,1,'N');
2230: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').arithmetic_operator: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).arithmetic_operator,1,'N');
2231: aso_debug_pub.add('l_Line_Adj_tbl('||l_line_adj_tbl_count + 1||').operation: '||l_Line_Adj_tbl(l_line_adj_tbl_count + 1).operation,1,'N');
2232:
2233: end if;
2234:
2235: */

Line 2242: if aso_debug_pub.g_debug_flag = 'Y' then

2238: END LOOP;
2239:
2240: l_line_tbl(i).tax_value := l_ln_total_tax_amount;
2241:
2242: if aso_debug_pub.g_debug_flag = 'Y' then
2243:
2244: aso_debug_pub.add('l_line_tbl('||i||').tax_exempt_flag: '||l_line_tbl(i).tax_exempt_flag,1,'N');
2245: aso_debug_pub.add('l_line_tbl('||i||').tax_exempt_number: '||l_line_tbl(i).tax_exempt_number,1,'N');
2246: aso_debug_pub.add('l_line_tbl('||i||').tax_exempt_reason_code: '||l_line_tbl(i).tax_exempt_reason_code,1,'N');

Line 2244: aso_debug_pub.add('l_line_tbl('||i||').tax_exempt_flag: '||l_line_tbl(i).tax_exempt_flag,1,'N');

2240: l_line_tbl(i).tax_value := l_ln_total_tax_amount;
2241:
2242: if aso_debug_pub.g_debug_flag = 'Y' then
2243:
2244: aso_debug_pub.add('l_line_tbl('||i||').tax_exempt_flag: '||l_line_tbl(i).tax_exempt_flag,1,'N');
2245: aso_debug_pub.add('l_line_tbl('||i||').tax_exempt_number: '||l_line_tbl(i).tax_exempt_number,1,'N');
2246: aso_debug_pub.add('l_line_tbl('||i||').tax_exempt_reason_code: '||l_line_tbl(i).tax_exempt_reason_code,1,'N');
2247: aso_debug_pub.add('l_line_tbl('||i||').tax_date: ' ||l_line_tbl(i).tax_date,1,'N');
2248: aso_debug_pub.add('l_line_tbl('||i||').tax_rate: ' ||l_line_tbl(i).tax_rate,1,'N');

Line 2245: aso_debug_pub.add('l_line_tbl('||i||').tax_exempt_number: '||l_line_tbl(i).tax_exempt_number,1,'N');

2241:
2242: if aso_debug_pub.g_debug_flag = 'Y' then
2243:
2244: aso_debug_pub.add('l_line_tbl('||i||').tax_exempt_flag: '||l_line_tbl(i).tax_exempt_flag,1,'N');
2245: aso_debug_pub.add('l_line_tbl('||i||').tax_exempt_number: '||l_line_tbl(i).tax_exempt_number,1,'N');
2246: aso_debug_pub.add('l_line_tbl('||i||').tax_exempt_reason_code: '||l_line_tbl(i).tax_exempt_reason_code,1,'N');
2247: aso_debug_pub.add('l_line_tbl('||i||').tax_date: ' ||l_line_tbl(i).tax_date,1,'N');
2248: aso_debug_pub.add('l_line_tbl('||i||').tax_rate: ' ||l_line_tbl(i).tax_rate,1,'N');
2249: aso_debug_pub.add('l_line_tbl('||i||').tax_value: ' ||l_line_tbl(i).tax_value,1,'N');

Line 2246: aso_debug_pub.add('l_line_tbl('||i||').tax_exempt_reason_code: '||l_line_tbl(i).tax_exempt_reason_code,1,'N');

2242: if aso_debug_pub.g_debug_flag = 'Y' then
2243:
2244: aso_debug_pub.add('l_line_tbl('||i||').tax_exempt_flag: '||l_line_tbl(i).tax_exempt_flag,1,'N');
2245: aso_debug_pub.add('l_line_tbl('||i||').tax_exempt_number: '||l_line_tbl(i).tax_exempt_number,1,'N');
2246: aso_debug_pub.add('l_line_tbl('||i||').tax_exempt_reason_code: '||l_line_tbl(i).tax_exempt_reason_code,1,'N');
2247: aso_debug_pub.add('l_line_tbl('||i||').tax_date: ' ||l_line_tbl(i).tax_date,1,'N');
2248: aso_debug_pub.add('l_line_tbl('||i||').tax_rate: ' ||l_line_tbl(i).tax_rate,1,'N');
2249: aso_debug_pub.add('l_line_tbl('||i||').tax_value: ' ||l_line_tbl(i).tax_value,1,'N');
2250:

Line 2247: aso_debug_pub.add('l_line_tbl('||i||').tax_date: ' ||l_line_tbl(i).tax_date,1,'N');

2243:
2244: aso_debug_pub.add('l_line_tbl('||i||').tax_exempt_flag: '||l_line_tbl(i).tax_exempt_flag,1,'N');
2245: aso_debug_pub.add('l_line_tbl('||i||').tax_exempt_number: '||l_line_tbl(i).tax_exempt_number,1,'N');
2246: aso_debug_pub.add('l_line_tbl('||i||').tax_exempt_reason_code: '||l_line_tbl(i).tax_exempt_reason_code,1,'N');
2247: aso_debug_pub.add('l_line_tbl('||i||').tax_date: ' ||l_line_tbl(i).tax_date,1,'N');
2248: aso_debug_pub.add('l_line_tbl('||i||').tax_rate: ' ||l_line_tbl(i).tax_rate,1,'N');
2249: aso_debug_pub.add('l_line_tbl('||i||').tax_value: ' ||l_line_tbl(i).tax_value,1,'N');
2250:
2251:

Line 2248: aso_debug_pub.add('l_line_tbl('||i||').tax_rate: ' ||l_line_tbl(i).tax_rate,1,'N');

2244: aso_debug_pub.add('l_line_tbl('||i||').tax_exempt_flag: '||l_line_tbl(i).tax_exempt_flag,1,'N');
2245: aso_debug_pub.add('l_line_tbl('||i||').tax_exempt_number: '||l_line_tbl(i).tax_exempt_number,1,'N');
2246: aso_debug_pub.add('l_line_tbl('||i||').tax_exempt_reason_code: '||l_line_tbl(i).tax_exempt_reason_code,1,'N');
2247: aso_debug_pub.add('l_line_tbl('||i||').tax_date: ' ||l_line_tbl(i).tax_date,1,'N');
2248: aso_debug_pub.add('l_line_tbl('||i||').tax_rate: ' ||l_line_tbl(i).tax_rate,1,'N');
2249: aso_debug_pub.add('l_line_tbl('||i||').tax_value: ' ||l_line_tbl(i).tax_value,1,'N');
2250:
2251:
2252: for p in 1..l_Line_Adj_tbl.count loop

Line 2249: aso_debug_pub.add('l_line_tbl('||i||').tax_value: ' ||l_line_tbl(i).tax_value,1,'N');

2245: aso_debug_pub.add('l_line_tbl('||i||').tax_exempt_number: '||l_line_tbl(i).tax_exempt_number,1,'N');
2246: aso_debug_pub.add('l_line_tbl('||i||').tax_exempt_reason_code: '||l_line_tbl(i).tax_exempt_reason_code,1,'N');
2247: aso_debug_pub.add('l_line_tbl('||i||').tax_date: ' ||l_line_tbl(i).tax_date,1,'N');
2248: aso_debug_pub.add('l_line_tbl('||i||').tax_rate: ' ||l_line_tbl(i).tax_rate,1,'N');
2249: aso_debug_pub.add('l_line_tbl('||i||').tax_value: ' ||l_line_tbl(i).tax_value,1,'N');
2250:
2251:
2252: for p in 1..l_Line_Adj_tbl.count loop
2253:

Line 2254: aso_debug_pub.add('l_Line_Adj_tbl('||p||').price_adjustment_id: '||l_Line_Adj_tbl(p).price_adjustment_id,1,'N');

2250:
2251:
2252: for p in 1..l_Line_Adj_tbl.count loop
2253:
2254: aso_debug_pub.add('l_Line_Adj_tbl('||p||').price_adjustment_id: '||l_Line_Adj_tbl(p).price_adjustment_id,1,'N');
2255: aso_debug_pub.add('l_Line_Adj_tbl('||p||').line_index: '||l_Line_Adj_tbl(p).line_index,1,'N');
2256: aso_debug_pub.add('l_Line_Adj_tbl('||p||').tax_rate_id: '||l_Line_Adj_tbl(p).tax_rate_id,1,'N');
2257: aso_debug_pub.add('l_Line_Adj_tbl('||p||').operand: '||l_Line_Adj_tbl(p).operand,1,'N');
2258: aso_debug_pub.add('l_Line_Adj_tbl('||p||').adjusted_amount: '||l_Line_Adj_tbl(p).adjusted_amount,1,'N');

Line 2255: aso_debug_pub.add('l_Line_Adj_tbl('||p||').line_index: '||l_Line_Adj_tbl(p).line_index,1,'N');

2251:
2252: for p in 1..l_Line_Adj_tbl.count loop
2253:
2254: aso_debug_pub.add('l_Line_Adj_tbl('||p||').price_adjustment_id: '||l_Line_Adj_tbl(p).price_adjustment_id,1,'N');
2255: aso_debug_pub.add('l_Line_Adj_tbl('||p||').line_index: '||l_Line_Adj_tbl(p).line_index,1,'N');
2256: aso_debug_pub.add('l_Line_Adj_tbl('||p||').tax_rate_id: '||l_Line_Adj_tbl(p).tax_rate_id,1,'N');
2257: aso_debug_pub.add('l_Line_Adj_tbl('||p||').operand: '||l_Line_Adj_tbl(p).operand,1,'N');
2258: aso_debug_pub.add('l_Line_Adj_tbl('||p||').adjusted_amount: '||l_Line_Adj_tbl(p).adjusted_amount,1,'N');
2259: aso_debug_pub.add('l_Line_Adj_tbl('||p||').automatic_flag: '||l_Line_Adj_tbl(p).automatic_flag,1,'N');

Line 2256: aso_debug_pub.add('l_Line_Adj_tbl('||p||').tax_rate_id: '||l_Line_Adj_tbl(p).tax_rate_id,1,'N');

2252: for p in 1..l_Line_Adj_tbl.count loop
2253:
2254: aso_debug_pub.add('l_Line_Adj_tbl('||p||').price_adjustment_id: '||l_Line_Adj_tbl(p).price_adjustment_id,1,'N');
2255: aso_debug_pub.add('l_Line_Adj_tbl('||p||').line_index: '||l_Line_Adj_tbl(p).line_index,1,'N');
2256: aso_debug_pub.add('l_Line_Adj_tbl('||p||').tax_rate_id: '||l_Line_Adj_tbl(p).tax_rate_id,1,'N');
2257: aso_debug_pub.add('l_Line_Adj_tbl('||p||').operand: '||l_Line_Adj_tbl(p).operand,1,'N');
2258: aso_debug_pub.add('l_Line_Adj_tbl('||p||').adjusted_amount: '||l_Line_Adj_tbl(p).adjusted_amount,1,'N');
2259: aso_debug_pub.add('l_Line_Adj_tbl('||p||').automatic_flag: '||l_Line_Adj_tbl(p).automatic_flag,1,'N');
2260: aso_debug_pub.add('l_Line_Adj_tbl('||p||').list_line_type_code: '||l_Line_Adj_tbl(p).list_line_type_code,1,'N');

Line 2257: aso_debug_pub.add('l_Line_Adj_tbl('||p||').operand: '||l_Line_Adj_tbl(p).operand,1,'N');

2253:
2254: aso_debug_pub.add('l_Line_Adj_tbl('||p||').price_adjustment_id: '||l_Line_Adj_tbl(p).price_adjustment_id,1,'N');
2255: aso_debug_pub.add('l_Line_Adj_tbl('||p||').line_index: '||l_Line_Adj_tbl(p).line_index,1,'N');
2256: aso_debug_pub.add('l_Line_Adj_tbl('||p||').tax_rate_id: '||l_Line_Adj_tbl(p).tax_rate_id,1,'N');
2257: aso_debug_pub.add('l_Line_Adj_tbl('||p||').operand: '||l_Line_Adj_tbl(p).operand,1,'N');
2258: aso_debug_pub.add('l_Line_Adj_tbl('||p||').adjusted_amount: '||l_Line_Adj_tbl(p).adjusted_amount,1,'N');
2259: aso_debug_pub.add('l_Line_Adj_tbl('||p||').automatic_flag: '||l_Line_Adj_tbl(p).automatic_flag,1,'N');
2260: aso_debug_pub.add('l_Line_Adj_tbl('||p||').list_line_type_code: '||l_Line_Adj_tbl(p).list_line_type_code,1,'N');
2261: aso_debug_pub.add('l_Line_Adj_tbl('||p||').arithmetic_operator: '||l_Line_Adj_tbl(p).arithmetic_operator,1,'N');

Line 2258: aso_debug_pub.add('l_Line_Adj_tbl('||p||').adjusted_amount: '||l_Line_Adj_tbl(p).adjusted_amount,1,'N');

2254: aso_debug_pub.add('l_Line_Adj_tbl('||p||').price_adjustment_id: '||l_Line_Adj_tbl(p).price_adjustment_id,1,'N');
2255: aso_debug_pub.add('l_Line_Adj_tbl('||p||').line_index: '||l_Line_Adj_tbl(p).line_index,1,'N');
2256: aso_debug_pub.add('l_Line_Adj_tbl('||p||').tax_rate_id: '||l_Line_Adj_tbl(p).tax_rate_id,1,'N');
2257: aso_debug_pub.add('l_Line_Adj_tbl('||p||').operand: '||l_Line_Adj_tbl(p).operand,1,'N');
2258: aso_debug_pub.add('l_Line_Adj_tbl('||p||').adjusted_amount: '||l_Line_Adj_tbl(p).adjusted_amount,1,'N');
2259: aso_debug_pub.add('l_Line_Adj_tbl('||p||').automatic_flag: '||l_Line_Adj_tbl(p).automatic_flag,1,'N');
2260: aso_debug_pub.add('l_Line_Adj_tbl('||p||').list_line_type_code: '||l_Line_Adj_tbl(p).list_line_type_code,1,'N');
2261: aso_debug_pub.add('l_Line_Adj_tbl('||p||').arithmetic_operator: '||l_Line_Adj_tbl(p).arithmetic_operator,1,'N');
2262: aso_debug_pub.add('l_Line_Adj_tbl('||p||').operation: '||l_Line_Adj_tbl(p).operation,1,'N');

Line 2259: aso_debug_pub.add('l_Line_Adj_tbl('||p||').automatic_flag: '||l_Line_Adj_tbl(p).automatic_flag,1,'N');

2255: aso_debug_pub.add('l_Line_Adj_tbl('||p||').line_index: '||l_Line_Adj_tbl(p).line_index,1,'N');
2256: aso_debug_pub.add('l_Line_Adj_tbl('||p||').tax_rate_id: '||l_Line_Adj_tbl(p).tax_rate_id,1,'N');
2257: aso_debug_pub.add('l_Line_Adj_tbl('||p||').operand: '||l_Line_Adj_tbl(p).operand,1,'N');
2258: aso_debug_pub.add('l_Line_Adj_tbl('||p||').adjusted_amount: '||l_Line_Adj_tbl(p).adjusted_amount,1,'N');
2259: aso_debug_pub.add('l_Line_Adj_tbl('||p||').automatic_flag: '||l_Line_Adj_tbl(p).automatic_flag,1,'N');
2260: aso_debug_pub.add('l_Line_Adj_tbl('||p||').list_line_type_code: '||l_Line_Adj_tbl(p).list_line_type_code,1,'N');
2261: aso_debug_pub.add('l_Line_Adj_tbl('||p||').arithmetic_operator: '||l_Line_Adj_tbl(p).arithmetic_operator,1,'N');
2262: aso_debug_pub.add('l_Line_Adj_tbl('||p||').operation: '||l_Line_Adj_tbl(p).operation,1,'N');
2263:

Line 2260: aso_debug_pub.add('l_Line_Adj_tbl('||p||').list_line_type_code: '||l_Line_Adj_tbl(p).list_line_type_code,1,'N');

2256: aso_debug_pub.add('l_Line_Adj_tbl('||p||').tax_rate_id: '||l_Line_Adj_tbl(p).tax_rate_id,1,'N');
2257: aso_debug_pub.add('l_Line_Adj_tbl('||p||').operand: '||l_Line_Adj_tbl(p).operand,1,'N');
2258: aso_debug_pub.add('l_Line_Adj_tbl('||p||').adjusted_amount: '||l_Line_Adj_tbl(p).adjusted_amount,1,'N');
2259: aso_debug_pub.add('l_Line_Adj_tbl('||p||').automatic_flag: '||l_Line_Adj_tbl(p).automatic_flag,1,'N');
2260: aso_debug_pub.add('l_Line_Adj_tbl('||p||').list_line_type_code: '||l_Line_Adj_tbl(p).list_line_type_code,1,'N');
2261: aso_debug_pub.add('l_Line_Adj_tbl('||p||').arithmetic_operator: '||l_Line_Adj_tbl(p).arithmetic_operator,1,'N');
2262: aso_debug_pub.add('l_Line_Adj_tbl('||p||').operation: '||l_Line_Adj_tbl(p).operation,1,'N');
2263:
2264: end loop;

Line 2261: aso_debug_pub.add('l_Line_Adj_tbl('||p||').arithmetic_operator: '||l_Line_Adj_tbl(p).arithmetic_operator,1,'N');

2257: aso_debug_pub.add('l_Line_Adj_tbl('||p||').operand: '||l_Line_Adj_tbl(p).operand,1,'N');
2258: aso_debug_pub.add('l_Line_Adj_tbl('||p||').adjusted_amount: '||l_Line_Adj_tbl(p).adjusted_amount,1,'N');
2259: aso_debug_pub.add('l_Line_Adj_tbl('||p||').automatic_flag: '||l_Line_Adj_tbl(p).automatic_flag,1,'N');
2260: aso_debug_pub.add('l_Line_Adj_tbl('||p||').list_line_type_code: '||l_Line_Adj_tbl(p).list_line_type_code,1,'N');
2261: aso_debug_pub.add('l_Line_Adj_tbl('||p||').arithmetic_operator: '||l_Line_Adj_tbl(p).arithmetic_operator,1,'N');
2262: aso_debug_pub.add('l_Line_Adj_tbl('||p||').operation: '||l_Line_Adj_tbl(p).operation,1,'N');
2263:
2264: end loop;
2265:

Line 2262: aso_debug_pub.add('l_Line_Adj_tbl('||p||').operation: '||l_Line_Adj_tbl(p).operation,1,'N');

2258: aso_debug_pub.add('l_Line_Adj_tbl('||p||').adjusted_amount: '||l_Line_Adj_tbl(p).adjusted_amount,1,'N');
2259: aso_debug_pub.add('l_Line_Adj_tbl('||p||').automatic_flag: '||l_Line_Adj_tbl(p).automatic_flag,1,'N');
2260: aso_debug_pub.add('l_Line_Adj_tbl('||p||').list_line_type_code: '||l_Line_Adj_tbl(p).list_line_type_code,1,'N');
2261: aso_debug_pub.add('l_Line_Adj_tbl('||p||').arithmetic_operator: '||l_Line_Adj_tbl(p).arithmetic_operator,1,'N');
2262: aso_debug_pub.add('l_Line_Adj_tbl('||p||').operation: '||l_Line_Adj_tbl(p).operation,1,'N');
2263:
2264: end loop;
2265:
2266: end if;

Line 2281: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2277: OPEN scheduling_level_cur(l_line_tbl(i).line_type_id);
2278: FETCH scheduling_level_cur INTO l_line_scheduling_level;
2279: CLOSE scheduling_level_cur;
2280: END IF;
2281: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2282: aso_debug_pub.add('l_line_tbl(i).line_type_id = ' ||
2283: l_line_tbl(i).line_type_id,1,'N');
2284:
2285: aso_debug_pub.add('l_order_scheduling_level = ' ||

Line 2282: aso_debug_pub.add('l_line_tbl(i).line_type_id = ' ||

2278: FETCH scheduling_level_cur INTO l_line_scheduling_level;
2279: CLOSE scheduling_level_cur;
2280: END IF;
2281: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2282: aso_debug_pub.add('l_line_tbl(i).line_type_id = ' ||
2283: l_line_tbl(i).line_type_id,1,'N');
2284:
2285: aso_debug_pub.add('l_order_scheduling_level = ' ||
2286: l_order_scheduling_level,1,'N');

Line 2285: aso_debug_pub.add('l_order_scheduling_level = ' ||

2281: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2282: aso_debug_pub.add('l_line_tbl(i).line_type_id = ' ||
2283: l_line_tbl(i).line_type_id,1,'N');
2284:
2285: aso_debug_pub.add('l_order_scheduling_level = ' ||
2286: l_order_scheduling_level,1,'N');
2287: aso_debug_pub.add('l_line_scheduling_level = ' ||
2288: l_line_scheduling_level,1,'N');
2289: END IF;

Line 2287: aso_debug_pub.add('l_line_scheduling_level = ' ||

2283: l_line_tbl(i).line_type_id,1,'N');
2284:
2285: aso_debug_pub.add('l_order_scheduling_level = ' ||
2286: l_order_scheduling_level,1,'N');
2287: aso_debug_pub.add('l_line_scheduling_level = ' ||
2288: l_line_scheduling_level,1,'N');
2289: END IF;
2290:
2291: -- a value of 'TWO' for scheduling level means that the transaction type

Line 2295: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2291: -- a value of 'TWO' for scheduling level means that the transaction type
2292: -- doesn't allow reservations.
2293: IF l_order_scheduling_level <> 'TWO' AND
2294: l_line_scheduling_level <> 'TWO' then
2295: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2296: aso_debug_pub.add('setting schedule action to reserve',1,'N');
2297: END IF;
2298: l_line_tbl(i).schedule_action_code
2299: := OE_ORDER_SCH_UTIL.OESCH_ACT_RESERVE;

Line 2296: aso_debug_pub.add('setting schedule action to reserve',1,'N');

2292: -- doesn't allow reservations.
2293: IF l_order_scheduling_level <> 'TWO' AND
2294: l_line_scheduling_level <> 'TWO' then
2295: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2296: aso_debug_pub.add('setting schedule action to reserve',1,'N');
2297: END IF;
2298: l_line_tbl(i).schedule_action_code
2299: := OE_ORDER_SCH_UTIL.OESCH_ACT_RESERVE;
2300: END IF;

Line 2307: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2303: IF p_calculate_price_flag = FND_API.G_FALSE THEN
2304: l_line_tbl(i).calculate_price_flag := 'N';
2305: l_line_tbl(i).pricing_quantity_uom := l_line_tbl(i).order_quantity_uom;
2306: l_line_tbl(i).pricing_quantity := l_line_tbl(i).ordered_quantity;
2307: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2308: aso_debug_pub.add('l_line_tbl(i).pricing_quantity_uom: '||l_line_tbl(i).pricing_quantity_uom,1,'N');
2309: aso_debug_pub.add('l_line_tbl(i).pricing_quantity: '||l_line_tbl(i).pricing_quantity,1,'N');
2310: END IF;
2311: ELSE

Line 2308: aso_debug_pub.add('l_line_tbl(i).pricing_quantity_uom: '||l_line_tbl(i).pricing_quantity_uom,1,'N');

2304: l_line_tbl(i).calculate_price_flag := 'N';
2305: l_line_tbl(i).pricing_quantity_uom := l_line_tbl(i).order_quantity_uom;
2306: l_line_tbl(i).pricing_quantity := l_line_tbl(i).ordered_quantity;
2307: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2308: aso_debug_pub.add('l_line_tbl(i).pricing_quantity_uom: '||l_line_tbl(i).pricing_quantity_uom,1,'N');
2309: aso_debug_pub.add('l_line_tbl(i).pricing_quantity: '||l_line_tbl(i).pricing_quantity,1,'N');
2310: END IF;
2311: ELSE
2312: l_line_tbl(i).calculate_price_flag := 'Y';

Line 2309: aso_debug_pub.add('l_line_tbl(i).pricing_quantity: '||l_line_tbl(i).pricing_quantity,1,'N');

2305: l_line_tbl(i).pricing_quantity_uom := l_line_tbl(i).order_quantity_uom;
2306: l_line_tbl(i).pricing_quantity := l_line_tbl(i).ordered_quantity;
2307: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2308: aso_debug_pub.add('l_line_tbl(i).pricing_quantity_uom: '||l_line_tbl(i).pricing_quantity_uom,1,'N');
2309: aso_debug_pub.add('l_line_tbl(i).pricing_quantity: '||l_line_tbl(i).pricing_quantity,1,'N');
2310: END IF;
2311: ELSE
2312: l_line_tbl(i).calculate_price_flag := 'Y';
2313: END IF; -- pricing

Line 2315: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2311: ELSE
2312: l_line_tbl(i).calculate_price_flag := 'Y';
2313: END IF; -- pricing
2314:
2315: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2316: aso_debug_pub.add('before line price att',1,'Y');
2317: END IF;
2318:
2319: -- pricing attributes

Line 2316: aso_debug_pub.add('before line price att',1,'Y');

2312: l_line_tbl(i).calculate_price_flag := 'Y';
2313: END IF; -- pricing
2314:
2315: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2316: aso_debug_pub.add('before line price att',1,'Y');
2317: END IF;
2318:
2319: -- pricing attributes
2320:

Line 2331: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2327: );
2328:
2329: l_line_price_adj_rltship_tbl := P_Line_Price_Adj_rltship_Tbl;
2330:
2331: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2332: aso_debug_pub.add('after line price att:l_line_price_att_tbl.count: '||l_line_price_att_tbl.count,1,'N');
2333: aso_debug_pub.add('before map_ln_adj:l_Line_Price_Adj_rltship_Tbl.count: '||l_Line_Price_Adj_rltship_Tbl.count,1,'N');
2334: END IF;
2335:

Line 2332: aso_debug_pub.add('after line price att:l_line_price_att_tbl.count: '||l_line_price_att_tbl.count,1,'N');

2328:
2329: l_line_price_adj_rltship_tbl := P_Line_Price_Adj_rltship_Tbl;
2330:
2331: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2332: aso_debug_pub.add('after line price att:l_line_price_att_tbl.count: '||l_line_price_att_tbl.count,1,'N');
2333: aso_debug_pub.add('before map_ln_adj:l_Line_Price_Adj_rltship_Tbl.count: '||l_Line_Price_Adj_rltship_Tbl.count,1,'N');
2334: END IF;
2335:
2336: map_line_price_adj(

Line 2333: aso_debug_pub.add('before map_ln_adj:l_Line_Price_Adj_rltship_Tbl.count: '||l_Line_Price_Adj_rltship_Tbl.count,1,'N');

2329: l_line_price_adj_rltship_tbl := P_Line_Price_Adj_rltship_Tbl;
2330:
2331: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2332: aso_debug_pub.add('after line price att:l_line_price_att_tbl.count: '||l_line_price_att_tbl.count,1,'N');
2333: aso_debug_pub.add('before map_ln_adj:l_Line_Price_Adj_rltship_Tbl.count: '||l_Line_Price_Adj_rltship_Tbl.count,1,'N');
2334: END IF;
2335:
2336: map_line_price_adj(
2337: p_line_price_adj_tbl => p_line_price_adj_tbl,

Line 2347: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2343: x_line_adj_att_tbl => l_line_adj_att_tbl,
2344: lx_Line_Price_Adj_rltship_Tbl => l_line_price_adj_rltship_tbl
2345: );
2346:
2347: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2348: aso_debug_pub.add('after line price adjustments:l_line_adj_att_tbl.count: '||l_line_adj_att_tbl.count,1,'N');
2349: aso_debug_pub.add('after line price adjustments:l_line_price_adj_rltship_tbl.count: '||l_line_price_adj_rltship_tbl.count,1,'N');
2350: END IF;
2351:

Line 2348: aso_debug_pub.add('after line price adjustments:l_line_adj_att_tbl.count: '||l_line_adj_att_tbl.count,1,'N');

2344: lx_Line_Price_Adj_rltship_Tbl => l_line_price_adj_rltship_tbl
2345: );
2346:
2347: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2348: aso_debug_pub.add('after line price adjustments:l_line_adj_att_tbl.count: '||l_line_adj_att_tbl.count,1,'N');
2349: aso_debug_pub.add('after line price adjustments:l_line_price_adj_rltship_tbl.count: '||l_line_price_adj_rltship_tbl.count,1,'N');
2350: END IF;
2351:
2352: map_line_price_adj_rltn(

Line 2349: aso_debug_pub.add('after line price adjustments:l_line_price_adj_rltship_tbl.count: '||l_line_price_adj_rltship_tbl.count,1,'N');

2345: );
2346:
2347: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2348: aso_debug_pub.add('after line price adjustments:l_line_adj_att_tbl.count: '||l_line_adj_att_tbl.count,1,'N');
2349: aso_debug_pub.add('after line price adjustments:l_line_price_adj_rltship_tbl.count: '||l_line_price_adj_rltship_tbl.count,1,'N');
2350: END IF;
2351:
2352: map_line_price_adj_rltn(
2353: P_Line_Price_Adj_rltship_Tbl => l_Line_Price_Adj_rltship_Tbl,

Line 2360: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2356: p_operation => l_line_tbl(i).operation,
2357: x_Line_Adj_Assoc_tbl => l_Line_Adj_Assoc_tbl
2358: );
2359:
2360: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2361: aso_debug_pub.add('before line sales credit:l_Line_Adj_Assoc_tbl.count: '||l_Line_Adj_Assoc_tbl.count,1,'Y');
2362: END IF;
2363:
2364: map_line_sales_credit(

Line 2361: aso_debug_pub.add('before line sales credit:l_Line_Adj_Assoc_tbl.count: '||l_Line_Adj_Assoc_tbl.count,1,'Y');

2357: x_Line_Adj_Assoc_tbl => l_Line_Adj_Assoc_tbl
2358: );
2359:
2360: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2361: aso_debug_pub.add('before line sales credit:l_Line_Adj_Assoc_tbl.count: '||l_Line_Adj_Assoc_tbl.count,1,'Y');
2362: END IF;
2363:
2364: map_line_sales_credit(
2365: P_line_sales_credit_Tbl => P_line_sales_credit_Tbl,

Line 2372: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2368: p_line_operation => l_line_tbl(i).operation,
2369: p_operation => p_operation,
2370: x_Line_Scredit_tbl => l_Line_Scredit_tbl
2371: );
2372: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2373: aso_debug_pub.add('after line sales credit:l_Line_Scredit_tbl.count: '||l_Line_Scredit_tbl.count,1,'Y');
2374: END IF;
2375:
2376: --Line Payments change

Line 2373: aso_debug_pub.add('after line sales credit:l_Line_Scredit_tbl.count: '||l_Line_Scredit_tbl.count,1,'Y');

2369: p_operation => p_operation,
2370: x_Line_Scredit_tbl => l_Line_Scredit_tbl
2371: );
2372: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2373: aso_debug_pub.add('after line sales credit:l_Line_Scredit_tbl.count: '||l_Line_Scredit_tbl.count,1,'Y');
2374: END IF;
2375:
2376: --Line Payments change
2377:

Line 2391: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2387: IF l_line_payment_tbl.count > 0 THEN
2388: l_final_payment_tbl(l_final_payment_tbl.count + 1) := l_line_payment_tbl(1);
2389: END IF;
2390:
2391: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2392: aso_debug_pub.add('after line payments:l_line_payment_tbl.count: '||l_line_payment_tbl.count,1,'Y');
2393: aso_debug_pub.add('after line payments:l_final_payment_tbl.count: '||l_final_payment_tbl.count,1,'Y');
2394: END IF;
2395:

Line 2392: aso_debug_pub.add('after line payments:l_line_payment_tbl.count: '||l_line_payment_tbl.count,1,'Y');

2388: l_final_payment_tbl(l_final_payment_tbl.count + 1) := l_line_payment_tbl(1);
2389: END IF;
2390:
2391: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2392: aso_debug_pub.add('after line payments:l_line_payment_tbl.count: '||l_line_payment_tbl.count,1,'Y');
2393: aso_debug_pub.add('after line payments:l_final_payment_tbl.count: '||l_final_payment_tbl.count,1,'Y');
2394: END IF;
2395:
2396: map_lot_serial(

Line 2393: aso_debug_pub.add('after line payments:l_final_payment_tbl.count: '||l_final_payment_tbl.count,1,'Y');

2389: END IF;
2390:
2391: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2392: aso_debug_pub.add('after line payments:l_line_payment_tbl.count: '||l_line_payment_tbl.count,1,'Y');
2393: aso_debug_pub.add('after line payments:l_final_payment_tbl.count: '||l_final_payment_tbl.count,1,'Y');
2394: END IF;
2395:
2396: map_lot_serial(
2397: P_lot_serial_tbl => P_lot_serial_tbl,

Line 2403: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2399: p_line_index => i,
2400: p_qte_line_index => k,
2401: x_lot_serial_tbl => l_lot_serial_tbl
2402: );
2403: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2404: aso_debug_pub.add('after lot serial:l_lot_serial_tbl.count: '||l_lot_serial_tbl.count,1,'Y');
2405: END IF;
2406:
2407: found := FND_API.G_TRUE;

Line 2404: aso_debug_pub.add('after lot serial:l_lot_serial_tbl.count: '||l_lot_serial_tbl.count,1,'Y');

2400: p_qte_line_index => k,
2401: x_lot_serial_tbl => l_lot_serial_tbl
2402: );
2403: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2404: aso_debug_pub.add('after lot serial:l_lot_serial_tbl.count: '||l_lot_serial_tbl.count,1,'Y');
2405: END IF;
2406:
2407: found := FND_API.G_TRUE;
2408: END IF;

Line 2414: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2410:
2411: i:= i+1;
2412: END LOOP; -- for shipment
2413:
2414: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2415: aso_debug_pub.add('l_final_payment_tbl.count: '|| l_final_payment_tbl.count,1,'Y');
2416: END IF;
2417: IF l_final_payment_tbl.count > 0 THEN
2418: l_line_payment_tbl := l_final_payment_tbl;

Line 2415: aso_debug_pub.add('l_final_payment_tbl.count: '|| l_final_payment_tbl.count,1,'Y');

2411: i:= i+1;
2412: END LOOP; -- for shipment
2413:
2414: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2415: aso_debug_pub.add('l_final_payment_tbl.count: '|| l_final_payment_tbl.count,1,'Y');
2416: END IF;
2417: IF l_final_payment_tbl.count > 0 THEN
2418: l_line_payment_tbl := l_final_payment_tbl;
2419: END IF;

Line 2448: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2444: x_Lot_Serial_tbl := l_lot_serial_tbl;
2445: x_Lot_Serial_val_tbl := l_lot_serial_val_tbl;
2446: x_Line_Payment_tbl := l_line_payment_tbl;
2447:
2448: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2449: aso_debug_pub.add('end of map quote to order ',1,'Y');
2450: END IF;
2451:
2452: END Map_quote_to_order;

Line 2449: aso_debug_pub.add('end of map quote to order ',1,'Y');

2445: x_Lot_Serial_val_tbl := l_lot_serial_val_tbl;
2446: x_Line_Payment_tbl := l_line_payment_tbl;
2447:
2448: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2449: aso_debug_pub.add('end of map quote to order ',1,'Y');
2450: END IF;
2451:
2452: END Map_quote_to_order;
2453:

Line 2477: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2473: --and a.status = 'A'; /* status column in hz_org_contacts is obseleted */
2474: l_party_type varchar2(30);
2475: begin
2476:
2477: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2478: aso_debug_pub.add('entering get_org_contact ',1,'N');
2479: aso_debug_pub.add('party_id = ' || p_party_id,1,'N');
2480: END IF;
2481:

Line 2478: aso_debug_pub.add('entering get_org_contact ',1,'N');

2474: l_party_type varchar2(30);
2475: begin
2476:
2477: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2478: aso_debug_pub.add('entering get_org_contact ',1,'N');
2479: aso_debug_pub.add('party_id = ' || p_party_id,1,'N');
2480: END IF;
2481:
2482: OPEN party_cur;

Line 2479: aso_debug_pub.add('party_id = ' || p_party_id,1,'N');

2475: begin
2476:
2477: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2478: aso_debug_pub.add('entering get_org_contact ',1,'N');
2479: aso_debug_pub.add('party_id = ' || p_party_id,1,'N');
2480: END IF;
2481:
2482: OPEN party_cur;
2483: FETCH party_cur INTO l_party_type;

Line 2486: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2482: OPEN party_cur;
2483: FETCH party_cur INTO l_party_type;
2484: CLOSE party_cur;
2485:
2486: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2487: aso_debug_pub.add('party_type = '|| l_party_type,1,'N');
2488: END IF;
2489:
2490: IF l_party_type = 'PARTY_RELATIONSHIP' THEN

Line 2487: aso_debug_pub.add('party_type = '|| l_party_type,1,'N');

2483: FETCH party_cur INTO l_party_type;
2484: CLOSE party_cur;
2485:
2486: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2487: aso_debug_pub.add('party_type = '|| l_party_type,1,'N');
2488: END IF;
2489:
2490: IF l_party_type = 'PARTY_RELATIONSHIP' THEN
2491: OPEN org_contact;

Line 2496: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2492: FETCH org_contact INTO x_org_contact;
2493: CLOSE org_contact;
2494: END IF;
2495:
2496: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2497: aso_debug_pub.add('org_contact = ' || x_org_contact,1,'N');
2498: END IF;
2499:
2500: END;

Line 2497: aso_debug_pub.add('org_contact = ' || x_org_contact,1,'N');

2493: CLOSE org_contact;
2494: END IF;
2495:
2496: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2497: aso_debug_pub.add('org_contact = ' || x_org_contact,1,'N');
2498: END IF;
2499:
2500: END;
2501:

Line 2554: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

2550: l_party_type VARCHAR2(30);
2551: l_site_use_id number;
2552: begin
2553:
2554: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
2555:
2556: x_return_status := FND_API.G_RET_STS_SUCCESS;
2557:
2558: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 2558: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2554: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
2555:
2556: x_return_status := FND_API.G_RET_STS_SUCCESS;
2557:
2558: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2559: aso_debug_pub.add('site use in get_acct_site_uses = ' || p_acct_site_type,1,'N');
2560: END IF;
2561: OPEN party_cur;
2562: FETCH party_cur INTO l_party_type, l_party_id;

Line 2559: aso_debug_pub.add('site use in get_acct_site_uses = ' || p_acct_site_type,1,'N');

2555:
2556: x_return_status := FND_API.G_RET_STS_SUCCESS;
2557:
2558: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2559: aso_debug_pub.add('site use in get_acct_site_uses = ' || p_acct_site_type,1,'N');
2560: END IF;
2561: OPEN party_cur;
2562: FETCH party_cur INTO l_party_type, l_party_id;
2563: IF (party_cur%NOTFOUND) THEN

Line 2567: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2563: IF (party_cur%NOTFOUND) THEN
2564: l_party_type := NULL;
2565: x_return_status := FND_API.G_RET_STS_ERROR;
2566: END IF;
2567: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2568: aso_debug_pub.add('party_type in get_acct_site_uses = ' || l_party_type,1,'N');
2569: END IF;
2570: CLOSE party_cur;
2571:

Line 2568: aso_debug_pub.add('party_type in get_acct_site_uses = ' || l_party_type,1,'N');

2564: l_party_type := NULL;
2565: x_return_status := FND_API.G_RET_STS_ERROR;
2566: END IF;
2567: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2568: aso_debug_pub.add('party_type in get_acct_site_uses = ' || l_party_type,1,'N');
2569: END IF;
2570: CLOSE party_cur;
2571:
2572: IF l_party_type = 'PARTY_RELATIONSHIP' THEN

Line 2583: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2579: CLOSE relationship_cur;
2580: ELSE
2581: cur_party_id := l_party_id;
2582: END IF;
2583: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2584: aso_debug_pub.add('cur_party_id = ' || cur_party_id,1,'N');
2585: END IF;
2586:
2587: OPEN site_use_cur;

Line 2584: aso_debug_pub.add('cur_party_id = ' || cur_party_id,1,'N');

2580: ELSE
2581: cur_party_id := l_party_id;
2582: END IF;
2583: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2584: aso_debug_pub.add('cur_party_id = ' || cur_party_id,1,'N');
2585: END IF;
2586:
2587: OPEN site_use_cur;
2588: FETCH site_use_cur

Line 2590: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2586:
2587: OPEN site_use_cur;
2588: FETCH site_use_cur
2589: INTO l_site_use_id, cust_acct_site_status, cust_site_use_status;
2590: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2591: aso_debug_pub.add('site use id = ' || l_site_use_id, 1, 'N');
2592: aso_debug_pub.add('account site status = ' || cust_acct_site_status, 1,'N');
2593: aso_debug_pub.add('account site use status = ' || cust_site_use_status, 1,'N');
2594: END IF;

Line 2591: aso_debug_pub.add('site use id = ' || l_site_use_id, 1, 'N');

2587: OPEN site_use_cur;
2588: FETCH site_use_cur
2589: INTO l_site_use_id, cust_acct_site_status, cust_site_use_status;
2590: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2591: aso_debug_pub.add('site use id = ' || l_site_use_id, 1, 'N');
2592: aso_debug_pub.add('account site status = ' || cust_acct_site_status, 1,'N');
2593: aso_debug_pub.add('account site use status = ' || cust_site_use_status, 1,'N');
2594: END IF;
2595: IF (site_use_cur%NOTFOUND) THEN

Line 2592: aso_debug_pub.add('account site status = ' || cust_acct_site_status, 1,'N');

2588: FETCH site_use_cur
2589: INTO l_site_use_id, cust_acct_site_status, cust_site_use_status;
2590: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2591: aso_debug_pub.add('site use id = ' || l_site_use_id, 1, 'N');
2592: aso_debug_pub.add('account site status = ' || cust_acct_site_status, 1,'N');
2593: aso_debug_pub.add('account site use status = ' || cust_site_use_status, 1,'N');
2594: END IF;
2595: IF (site_use_cur%NOTFOUND) THEN
2596: l_site_use_id := NULL;

Line 2593: aso_debug_pub.add('account site use status = ' || cust_site_use_status, 1,'N');

2589: INTO l_site_use_id, cust_acct_site_status, cust_site_use_status;
2590: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2591: aso_debug_pub.add('site use id = ' || l_site_use_id, 1, 'N');
2592: aso_debug_pub.add('account site status = ' || cust_acct_site_status, 1,'N');
2593: aso_debug_pub.add('account site use status = ' || cust_site_use_status, 1,'N');
2594: END IF;
2595: IF (site_use_cur%NOTFOUND) THEN
2596: l_site_use_id := NULL;
2597: -- x_return_status := FND_API.G_RET_STS_ERROR;

Line 2610: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2606: END IF;
2607: FND_MSG_PUB.ADD;
2608: END IF;
2609: END IF;
2610: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2611: aso_debug_pub.add('site_use_id in get_acct_site_uses = ' || l_site_use_id,1,'N');
2612: END IF;
2613: CLOSE site_use_cur;
2614: x_site_use_id := l_site_use_id;

Line 2611: aso_debug_pub.add('site_use_id in get_acct_site_uses = ' || l_site_use_id,1,'N');

2607: FND_MSG_PUB.ADD;
2608: END IF;
2609: END IF;
2610: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2611: aso_debug_pub.add('site_use_id in get_acct_site_uses = ' || l_site_use_id,1,'N');
2612: END IF;
2613: CLOSE site_use_cur;
2614: x_site_use_id := l_site_use_id;
2615: END get_acct_site_uses;

Line 2712: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2708: l_acct_site_type VARCHAR2(50);
2709: begin
2710:
2711: x_return_status := FND_API.G_RET_STS_SUCCESS;
2712: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2713: aso_debug_pub.add('site use in get_cust_account_roles = ' || p_acct_site_type,1,'N');
2714: aso_debug_pub.add('p_party_id = ' || p_party_id,1,'N');
2715: END IF;
2716:

Line 2713: aso_debug_pub.add('site use in get_cust_account_roles = ' || p_acct_site_type,1,'N');

2709: begin
2710:
2711: x_return_status := FND_API.G_RET_STS_SUCCESS;
2712: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2713: aso_debug_pub.add('site use in get_cust_account_roles = ' || p_acct_site_type,1,'N');
2714: aso_debug_pub.add('p_party_id = ' || p_party_id,1,'N');
2715: END IF;
2716:
2717: IF p_acct_site_type = 'END_USER' THEN

Line 2714: aso_debug_pub.add('p_party_id = ' || p_party_id,1,'N');

2710:
2711: x_return_status := FND_API.G_RET_STS_SUCCESS;
2712: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2713: aso_debug_pub.add('site use in get_cust_account_roles = ' || p_acct_site_type,1,'N');
2714: aso_debug_pub.add('p_party_id = ' || p_party_id,1,'N');
2715: END IF;
2716:
2717: IF p_acct_site_type = 'END_USER' THEN
2718: l_acct_site_type := 'SHIP_TO';

Line 2727: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2723: IF (party_cur%NOTFOUND) THEN
2724: l_party_type := NULL;
2725: x_return_status := FND_API.G_RET_STS_ERROR;
2726: END IF;
2727: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2728: aso_debug_pub.add('party_type in get_cust_account_roles = ' || l_party_type,1,'N');
2729: END IF;
2730: CLOSE party_cur;
2731:

Line 2728: aso_debug_pub.add('party_type in get_cust_account_roles = ' || l_party_type,1,'N');

2724: l_party_type := NULL;
2725: x_return_status := FND_API.G_RET_STS_ERROR;
2726: END IF;
2727: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2728: aso_debug_pub.add('party_type in get_cust_account_roles = ' || l_party_type,1,'N');
2729: END IF;
2730: CLOSE party_cur;
2731:
2732: IF l_party_type = 'PERSON' THEN

Line 2741: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2737: x_return_status := FND_API.G_RET_STS_ERROR;
2738: END IF;
2739: CLOSE cust_cur;
2740:
2741: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2742: aso_debug_pub.add('l_party_id = ' || l_party_id, 1,'N');
2743: END IF;
2744: IF l_party_id IS NOT NULL AND l_party_id = p_party_id THEN
2745: -- p_party_id is owner of account, hence not a contact

Line 2742: aso_debug_pub.add('l_party_id = ' || l_party_id, 1,'N');

2738: END IF;
2739: CLOSE cust_cur;
2740:
2741: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2742: aso_debug_pub.add('l_party_id = ' || l_party_id, 1,'N');
2743: END IF;
2744: IF l_party_id IS NOT NULL AND l_party_id = p_party_id THEN
2745: -- p_party_id is owner of account, hence not a contact
2746: x_party_id := FND_API.G_MISS_NUM;

Line 2757: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2753: FETCH person_relationship_cur INTO l_relationship_party_id;
2754: EXIT WHEN person_relationship_cur%NOTFOUND OR x_return_status = FND_API.G_RET_STS_ERROR;
2755: l_count_relationship := l_count_relationship + 1;
2756:
2757: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2758: aso_debug_pub.add('relationship_party_id = ' || l_relationship_party_id,1,'N');
2759: aso_debug_pub.add('x_return_status = ' || x_return_status,1,'N');
2760: aso_debug_pub.add('opening cust_role cursor',1,'N');
2761: END IF;

Line 2758: aso_debug_pub.add('relationship_party_id = ' || l_relationship_party_id,1,'N');

2754: EXIT WHEN person_relationship_cur%NOTFOUND OR x_return_status = FND_API.G_RET_STS_ERROR;
2755: l_count_relationship := l_count_relationship + 1;
2756:
2757: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2758: aso_debug_pub.add('relationship_party_id = ' || l_relationship_party_id,1,'N');
2759: aso_debug_pub.add('x_return_status = ' || x_return_status,1,'N');
2760: aso_debug_pub.add('opening cust_role cursor',1,'N');
2761: END IF;
2762:

Line 2759: aso_debug_pub.add('x_return_status = ' || x_return_status,1,'N');

2755: l_count_relationship := l_count_relationship + 1;
2756:
2757: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2758: aso_debug_pub.add('relationship_party_id = ' || l_relationship_party_id,1,'N');
2759: aso_debug_pub.add('x_return_status = ' || x_return_status,1,'N');
2760: aso_debug_pub.add('opening cust_role cursor',1,'N');
2761: END IF;
2762:
2763: OPEN cust_role(l_relationship_party_id);

Line 2760: aso_debug_pub.add('opening cust_role cursor',1,'N');

2756:
2757: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2758: aso_debug_pub.add('relationship_party_id = ' || l_relationship_party_id,1,'N');
2759: aso_debug_pub.add('x_return_status = ' || x_return_status,1,'N');
2760: aso_debug_pub.add('opening cust_role cursor',1,'N');
2761: END IF;
2762:
2763: OPEN cust_role(l_relationship_party_id);
2764: LOOP

Line 2765: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2761: END IF;
2762:
2763: OPEN cust_role(l_relationship_party_id);
2764: LOOP
2765: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2766: aso_debug_pub.add('looping in cust_role',1,'N');
2767: END IF;
2768: FETCH cust_role INTO l_cust_account_role_id, cust_account_role_status;
2769: EXIT WHEN cust_role%NOTFOUND OR x_return_status = FND_API.G_RET_STS_ERROR;

Line 2766: aso_debug_pub.add('looping in cust_role',1,'N');

2762:
2763: OPEN cust_role(l_relationship_party_id);
2764: LOOP
2765: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2766: aso_debug_pub.add('looping in cust_role',1,'N');
2767: END IF;
2768: FETCH cust_role INTO l_cust_account_role_id, cust_account_role_status;
2769: EXIT WHEN cust_role%NOTFOUND OR x_return_status = FND_API.G_RET_STS_ERROR;
2770: IF (cust_role%ROWCOUNT) > 1 THEN

Line 2776: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2772: END IF;
2773: END LOOP;
2774: CLOSE cust_role;
2775:
2776: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2777: aso_debug_pub.add(' l_cust_account_role_id = '|| l_cust_account_role_id,1,'N' );
2778: aso_debug_pub.add('rowcount = ' || person_relationship_cur%ROWCOUNT,1,'N');
2779: aso_debug_pub.add('l_multiple_flag = ' || l_multiple_flag,1,'N');
2780: END IF;

Line 2777: aso_debug_pub.add(' l_cust_account_role_id = '|| l_cust_account_role_id,1,'N' );

2773: END LOOP;
2774: CLOSE cust_role;
2775:
2776: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2777: aso_debug_pub.add(' l_cust_account_role_id = '|| l_cust_account_role_id,1,'N' );
2778: aso_debug_pub.add('rowcount = ' || person_relationship_cur%ROWCOUNT,1,'N');
2779: aso_debug_pub.add('l_multiple_flag = ' || l_multiple_flag,1,'N');
2780: END IF;
2781:

Line 2778: aso_debug_pub.add('rowcount = ' || person_relationship_cur%ROWCOUNT,1,'N');

2774: CLOSE cust_role;
2775:
2776: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2777: aso_debug_pub.add(' l_cust_account_role_id = '|| l_cust_account_role_id,1,'N' );
2778: aso_debug_pub.add('rowcount = ' || person_relationship_cur%ROWCOUNT,1,'N');
2779: aso_debug_pub.add('l_multiple_flag = ' || l_multiple_flag,1,'N');
2780: END IF;
2781:
2782: IF person_relationship_cur%ROWCOUNT > 1 AND l_multiple_flag = FND_API.G_TRUE

Line 2779: aso_debug_pub.add('l_multiple_flag = ' || l_multiple_flag,1,'N');

2775:
2776: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2777: aso_debug_pub.add(' l_cust_account_role_id = '|| l_cust_account_role_id,1,'N' );
2778: aso_debug_pub.add('rowcount = ' || person_relationship_cur%ROWCOUNT,1,'N');
2779: aso_debug_pub.add('l_multiple_flag = ' || l_multiple_flag,1,'N');
2780: END IF;
2781:
2782: IF person_relationship_cur%ROWCOUNT > 1 AND l_multiple_flag = FND_API.G_TRUE
2783: THEN

Line 2803: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2799: IF (org_contact%NOTFOUND) THEN
2800: l_org_contact_id := NULL;
2801: x_return_status := FND_API.G_RET_STS_ERROR;
2802: END IF;
2803: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2804: aso_debug_pub.add('org_contact_id in get_cust_acct_roles = '|| l_org_contact_id,1,'N');
2805: END IF;
2806: CLOSE org_contact;
2807:

Line 2804: aso_debug_pub.add('org_contact_id in get_cust_acct_roles = '|| l_org_contact_id,1,'N');

2800: l_org_contact_id := NULL;
2801: x_return_status := FND_API.G_RET_STS_ERROR;
2802: END IF;
2803: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2804: aso_debug_pub.add('org_contact_id in get_cust_acct_roles = '|| l_org_contact_id,1,'N');
2805: END IF;
2806: CLOSE org_contact;
2807:
2808: OPEN cust_role_exists(p_party_id);

Line 2819: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2815: ELSE
2816: OPEN cust_role(p_party_id);
2817: FETCH cust_role INTO l_cust_account_role_id, cust_account_role_status;
2818:
2819: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2820: aso_debug_pub.add('cust account role id = ' || l_cust_account_role_id, 1, 'N');
2821: aso_debug_pub.add('cust account role status = ' || cust_account_role_status, 1 , 'N');
2822: END IF;
2823:

Line 2820: aso_debug_pub.add('cust account role id = ' || l_cust_account_role_id, 1, 'N');

2816: OPEN cust_role(p_party_id);
2817: FETCH cust_role INTO l_cust_account_role_id, cust_account_role_status;
2818:
2819: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2820: aso_debug_pub.add('cust account role id = ' || l_cust_account_role_id, 1, 'N');
2821: aso_debug_pub.add('cust account role status = ' || cust_account_role_status, 1 , 'N');
2822: END IF;
2823:
2824: IF (cust_role%NOTFOUND) THEN

Line 2821: aso_debug_pub.add('cust account role status = ' || cust_account_role_status, 1 , 'N');

2817: FETCH cust_role INTO l_cust_account_role_id, cust_account_role_status;
2818:
2819: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2820: aso_debug_pub.add('cust account role id = ' || l_cust_account_role_id, 1, 'N');
2821: aso_debug_pub.add('cust account role status = ' || cust_account_role_status, 1 , 'N');
2822: END IF;
2823:
2824: IF (cust_role%NOTFOUND) THEN
2825: l_cust_account_role_id := NULL;

Line 2838: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2834: FND_MSG_PUB.ADD;
2835: END IF;
2836: CLOSE cust_role;
2837: END IF;
2838: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2839: aso_debug_pub.add('l_cust_account_role_id in get_cust_acct_roles = '|| l_cust_account_role_id,1,'N');
2840: END IF;
2841: x_party_id := p_party_id;
2842:

Line 2839: aso_debug_pub.add('l_cust_account_role_id in get_cust_acct_roles = '|| l_cust_account_role_id,1,'N');

2835: END IF;
2836: CLOSE cust_role;
2837: END IF;
2838: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2839: aso_debug_pub.add('l_cust_account_role_id in get_cust_acct_roles = '|| l_cust_account_role_id,1,'N');
2840: END IF;
2841: x_party_id := p_party_id;
2842:
2843: END IF; -- end party relationship

Line 3031: IF aso_debug_pub.g_debug_flag = 'Y' THEN

3027: x_return_status := FND_API.G_RET_STS_ERROR;
3028: END IF;
3029: CLOSE C_party;
3030:
3031: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3032: aso_debug_pub.add('x_return_status = ' || x_return_status,1,'N');
3033: aso_debug_pub.add('l_party_id is = ' || l_party_id,1,'N');
3034: END IF;
3035:

Line 3032: aso_debug_pub.add('x_return_status = ' || x_return_status,1,'N');

3028: END IF;
3029: CLOSE C_party;
3030:
3031: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3032: aso_debug_pub.add('x_return_status = ' || x_return_status,1,'N');
3033: aso_debug_pub.add('l_party_id is = ' || l_party_id,1,'N');
3034: END IF;
3035:
3036: OPEN C_active_contact (l_party_id);

Line 3033: aso_debug_pub.add('l_party_id is = ' || l_party_id,1,'N');

3029: CLOSE C_party;
3030:
3031: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3032: aso_debug_pub.add('x_return_status = ' || x_return_status,1,'N');
3033: aso_debug_pub.add('l_party_id is = ' || l_party_id,1,'N');
3034: END IF;
3035:
3036: OPEN C_active_contact (l_party_id);
3037: FETCH C_active_contact INTO x_cust_account_role_id, cust_account_role_status;

Line 3038: IF aso_debug_pub.g_debug_flag = 'Y' THEN

3034: END IF;
3035:
3036: OPEN C_active_contact (l_party_id);
3037: FETCH C_active_contact INTO x_cust_account_role_id, cust_account_role_status;
3038: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3039: aso_debug_pub.add('cust account role id = ' || x_cust_account_role_id, 1, 'N');
3040: aso_debug_pub.add('cust_account_role_status = '|| cust_account_role_status, 1, 'N');
3041: END IF;
3042: IF (C_active_contact%NOTFOUND) THEN

Line 3039: aso_debug_pub.add('cust account role id = ' || x_cust_account_role_id, 1, 'N');

3035:
3036: OPEN C_active_contact (l_party_id);
3037: FETCH C_active_contact INTO x_cust_account_role_id, cust_account_role_status;
3038: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3039: aso_debug_pub.add('cust account role id = ' || x_cust_account_role_id, 1, 'N');
3040: aso_debug_pub.add('cust_account_role_status = '|| cust_account_role_status, 1, 'N');
3041: END IF;
3042: IF (C_active_contact%NOTFOUND) THEN
3043: -- this means there are no active contacts

Line 3040: aso_debug_pub.add('cust_account_role_status = '|| cust_account_role_status, 1, 'N');

3036: OPEN C_active_contact (l_party_id);
3037: FETCH C_active_contact INTO x_cust_account_role_id, cust_account_role_status;
3038: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3039: aso_debug_pub.add('cust account role id = ' || x_cust_account_role_id, 1, 'N');
3040: aso_debug_pub.add('cust_account_role_status = '|| cust_account_role_status, 1, 'N');
3041: END IF;
3042: IF (C_active_contact%NOTFOUND) THEN
3043: -- this means there are no active contacts
3044: OPEN C_inactive_contact(l_party_id);

Line 3061: IF aso_debug_pub.g_debug_flag = 'Y' THEN

3057: END IF;
3058: CLOSE C_active_contact;
3059:
3060: x_party_id := l_party_id;
3061: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3062: aso_debug_pub.add('cust acct role '||x_cust_account_role_id,1,'N');
3063: END IF;
3064: END get_org_contact_role;
3065:

Line 3062: aso_debug_pub.add('cust acct role '||x_cust_account_role_id,1,'N');

3058: CLOSE C_active_contact;
3059:
3060: x_party_id := l_party_id;
3061: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3062: aso_debug_pub.add('cust acct role '||x_cust_account_role_id,1,'N');
3063: END IF;
3064: END get_org_contact_role;
3065:
3066:

Line 4124: IF aso_debug_pub.g_debug_flag = 'Y' THEN

4120: END IF;
4121:
4122: -- pbh/prg
4123: FOR j in 1..lx_Line_Price_Adj_rltship_Tbl.count LOOP
4124: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4125: aso_debug_pub.add('map_ln_rlt: p_line_price_adj_tbl(pad_count).price_adjustment_id: '||p_line_price_adj_tbl(pad_count).price_adjustment_id,1,'N');
4126: END IF;
4127:
4128: IF lx_Line_Price_Adj_rltship_Tbl(j).price_adjustment_id

Line 4125: aso_debug_pub.add('map_ln_rlt: p_line_price_adj_tbl(pad_count).price_adjustment_id: '||p_line_price_adj_tbl(pad_count).price_adjustment_id,1,'N');

4121:
4122: -- pbh/prg
4123: FOR j in 1..lx_Line_Price_Adj_rltship_Tbl.count LOOP
4124: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4125: aso_debug_pub.add('map_ln_rlt: p_line_price_adj_tbl(pad_count).price_adjustment_id: '||p_line_price_adj_tbl(pad_count).price_adjustment_id,1,'N');
4126: END IF;
4127:
4128: IF lx_Line_Price_Adj_rltship_Tbl(j).price_adjustment_id
4129: = p_line_price_adj_tbl(pad_count).price_adjustment_id THEN

Line 4141: IF aso_debug_pub.g_debug_flag = 'Y' THEN

4137:
4138: END LOOP;
4139: -- pbh/prg
4140:
4141: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4142: aso_debug_pub.add('map_ln_rlt: lx_Line_Price_Adj_rltship_Tbl.count: '||lx_Line_Price_Adj_rltship_Tbl.count,1,'N');
4143: END IF;
4144:
4145: END LOOP; --- price adjustments

Line 4142: aso_debug_pub.add('map_ln_rlt: lx_Line_Price_Adj_rltship_Tbl.count: '||lx_Line_Price_Adj_rltship_Tbl.count,1,'N');

4138: END LOOP;
4139: -- pbh/prg
4140:
4141: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4142: aso_debug_pub.add('map_ln_rlt: lx_Line_Price_Adj_rltship_Tbl.count: '||lx_Line_Price_Adj_rltship_Tbl.count,1,'N');
4143: END IF;
4144:
4145: END LOOP; --- price adjustments
4146:

Line 4345: IF aso_debug_pub.g_debug_flag = 'Y' THEN

4341: ELSE
4342: l_Line_tbl(p_line_index).payment_term_id := P_Line_Payment_Tbl(i).payment_term_id;
4343: END IF;
4344:
4345: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4346: aso_debug_pub.add('P_Line_Payment_Tbl(i).cust_po_number: '||P_Line_Payment_Tbl(i).cust_po_number,1,'N');
4347: aso_debug_pub.add('P_Line_Payment_Tbl(i).cust_po_line_number: '||P_Line_Payment_Tbl(i).cust_po_line_number,1,'N');
4348: END IF;
4349:

Line 4346: aso_debug_pub.add('P_Line_Payment_Tbl(i).cust_po_number: '||P_Line_Payment_Tbl(i).cust_po_number,1,'N');

4342: l_Line_tbl(p_line_index).payment_term_id := P_Line_Payment_Tbl(i).payment_term_id;
4343: END IF;
4344:
4345: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4346: aso_debug_pub.add('P_Line_Payment_Tbl(i).cust_po_number: '||P_Line_Payment_Tbl(i).cust_po_number,1,'N');
4347: aso_debug_pub.add('P_Line_Payment_Tbl(i).cust_po_line_number: '||P_Line_Payment_Tbl(i).cust_po_line_number,1,'N');
4348: END IF;
4349:
4350: l_Line_tbl(p_line_index).cust_po_number := P_Line_Payment_Tbl(i).cust_po_number;

Line 4347: aso_debug_pub.add('P_Line_Payment_Tbl(i).cust_po_line_number: '||P_Line_Payment_Tbl(i).cust_po_line_number,1,'N');

4343: END IF;
4344:
4345: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4346: aso_debug_pub.add('P_Line_Payment_Tbl(i).cust_po_number: '||P_Line_Payment_Tbl(i).cust_po_number,1,'N');
4347: aso_debug_pub.add('P_Line_Payment_Tbl(i).cust_po_line_number: '||P_Line_Payment_Tbl(i).cust_po_line_number,1,'N');
4348: END IF;
4349:
4350: l_Line_tbl(p_line_index).cust_po_number := P_Line_Payment_Tbl(i).cust_po_number;
4351: l_Line_tbl(p_line_index).customer_line_number := P_Line_Payment_Tbl(i).cust_po_line_number;

Line 4353: IF aso_debug_pub.g_debug_flag = 'Y' THEN

4349:
4350: l_Line_tbl(p_line_index).cust_po_number := P_Line_Payment_Tbl(i).cust_po_number;
4351: l_Line_tbl(p_line_index).customer_line_number := P_Line_Payment_Tbl(i).cust_po_line_number;
4352:
4353: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4354: aso_debug_pub.add('P_Line_Payment_Tbl(i).payment_type_code: '||P_Line_Payment_Tbl(i).payment_type_code,1,'N');
4355: aso_debug_pub.add('P_Line_Payment_Tbl(i).payment_amount: '||P_Line_Payment_Tbl(i).payment_amount,1,'N');
4356: END IF;
4357: IF P_Line_Payment_Tbl(i).payment_type_code IS NOT NULL THEN

Line 4354: aso_debug_pub.add('P_Line_Payment_Tbl(i).payment_type_code: '||P_Line_Payment_Tbl(i).payment_type_code,1,'N');

4350: l_Line_tbl(p_line_index).cust_po_number := P_Line_Payment_Tbl(i).cust_po_number;
4351: l_Line_tbl(p_line_index).customer_line_number := P_Line_Payment_Tbl(i).cust_po_line_number;
4352:
4353: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4354: aso_debug_pub.add('P_Line_Payment_Tbl(i).payment_type_code: '||P_Line_Payment_Tbl(i).payment_type_code,1,'N');
4355: aso_debug_pub.add('P_Line_Payment_Tbl(i).payment_amount: '||P_Line_Payment_Tbl(i).payment_amount,1,'N');
4356: END IF;
4357: IF P_Line_Payment_Tbl(i).payment_type_code IS NOT NULL THEN
4358:

Line 4355: aso_debug_pub.add('P_Line_Payment_Tbl(i).payment_amount: '||P_Line_Payment_Tbl(i).payment_amount,1,'N');

4351: l_Line_tbl(p_line_index).customer_line_number := P_Line_Payment_Tbl(i).cust_po_line_number;
4352:
4353: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4354: aso_debug_pub.add('P_Line_Payment_Tbl(i).payment_type_code: '||P_Line_Payment_Tbl(i).payment_type_code,1,'N');
4355: aso_debug_pub.add('P_Line_Payment_Tbl(i).payment_amount: '||P_Line_Payment_Tbl(i).payment_amount,1,'N');
4356: END IF;
4357: IF P_Line_Payment_Tbl(i).payment_type_code IS NOT NULL THEN
4358:
4359: l_Line_Payment_tbl(pay_count).payment_type_code := P_Line_Payment_Tbl(i).payment_type_code;

Line 4369: IF aso_debug_pub.g_debug_flag = 'Y' THEN

4365: l_Line_Payment_tbl(pay_count).trxn_extension_id := P_Line_Payment_Tbl(i).trxn_extension_id;
4366: l_Line_Payment_tbl(pay_count).payment_collection_event := 'INVOICE';
4367: l_Line_Payment_tbl(pay_count).payment_level_code := 'LINE';
4368:
4369: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4370: aso_debug_pub.add('l_Line_Payment_tbl(pay_count).payment_type_code: '||l_Line_Payment_tbl(pay_count).payment_type_code,1,'N');
4371: aso_debug_pub.add('l_Line_Payment_tbl(pay_count).payment_amount: '||l_Line_Payment_tbl(pay_count).payment_amount,1,'N');
4372: aso_debug_pub.add('l_Line_Payment_tbl(pay_count).operation: '||l_Line_Payment_tbl(pay_count).operation,1,'N');
4373: aso_debug_pub.add('l_Line_Payment_tbl(pay_count).trxn_extension_id: '||l_Line_Payment_tbl(pay_count).trxn_extension_id,1,'N');

Line 4370: aso_debug_pub.add('l_Line_Payment_tbl(pay_count).payment_type_code: '||l_Line_Payment_tbl(pay_count).payment_type_code,1,'N');

4366: l_Line_Payment_tbl(pay_count).payment_collection_event := 'INVOICE';
4367: l_Line_Payment_tbl(pay_count).payment_level_code := 'LINE';
4368:
4369: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4370: aso_debug_pub.add('l_Line_Payment_tbl(pay_count).payment_type_code: '||l_Line_Payment_tbl(pay_count).payment_type_code,1,'N');
4371: aso_debug_pub.add('l_Line_Payment_tbl(pay_count).payment_amount: '||l_Line_Payment_tbl(pay_count).payment_amount,1,'N');
4372: aso_debug_pub.add('l_Line_Payment_tbl(pay_count).operation: '||l_Line_Payment_tbl(pay_count).operation,1,'N');
4373: aso_debug_pub.add('l_Line_Payment_tbl(pay_count).trxn_extension_id: '||l_Line_Payment_tbl(pay_count).trxn_extension_id,1,'N');
4374: aso_debug_pub.add('l_Line_Payment_tbl(pay_count).payment_collection_event: '||l_Line_Payment_tbl(pay_count).payment_collection_event,1,'N');

Line 4371: aso_debug_pub.add('l_Line_Payment_tbl(pay_count).payment_amount: '||l_Line_Payment_tbl(pay_count).payment_amount,1,'N');

4367: l_Line_Payment_tbl(pay_count).payment_level_code := 'LINE';
4368:
4369: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4370: aso_debug_pub.add('l_Line_Payment_tbl(pay_count).payment_type_code: '||l_Line_Payment_tbl(pay_count).payment_type_code,1,'N');
4371: aso_debug_pub.add('l_Line_Payment_tbl(pay_count).payment_amount: '||l_Line_Payment_tbl(pay_count).payment_amount,1,'N');
4372: aso_debug_pub.add('l_Line_Payment_tbl(pay_count).operation: '||l_Line_Payment_tbl(pay_count).operation,1,'N');
4373: aso_debug_pub.add('l_Line_Payment_tbl(pay_count).trxn_extension_id: '||l_Line_Payment_tbl(pay_count).trxn_extension_id,1,'N');
4374: aso_debug_pub.add('l_Line_Payment_tbl(pay_count).payment_collection_event: '||l_Line_Payment_tbl(pay_count).payment_collection_event,1,'N');
4375: aso_debug_pub.add('l_Line_Payment_tbl(pay_count).payment_level_code: '||l_Line_Payment_tbl(pay_count).payment_level_code,1,'N');

Line 4372: aso_debug_pub.add('l_Line_Payment_tbl(pay_count).operation: '||l_Line_Payment_tbl(pay_count).operation,1,'N');

4368:
4369: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4370: aso_debug_pub.add('l_Line_Payment_tbl(pay_count).payment_type_code: '||l_Line_Payment_tbl(pay_count).payment_type_code,1,'N');
4371: aso_debug_pub.add('l_Line_Payment_tbl(pay_count).payment_amount: '||l_Line_Payment_tbl(pay_count).payment_amount,1,'N');
4372: aso_debug_pub.add('l_Line_Payment_tbl(pay_count).operation: '||l_Line_Payment_tbl(pay_count).operation,1,'N');
4373: aso_debug_pub.add('l_Line_Payment_tbl(pay_count).trxn_extension_id: '||l_Line_Payment_tbl(pay_count).trxn_extension_id,1,'N');
4374: aso_debug_pub.add('l_Line_Payment_tbl(pay_count).payment_collection_event: '||l_Line_Payment_tbl(pay_count).payment_collection_event,1,'N');
4375: aso_debug_pub.add('l_Line_Payment_tbl(pay_count).payment_level_code: '||l_Line_Payment_tbl(pay_count).payment_level_code,1,'N');
4376: END IF;

Line 4373: aso_debug_pub.add('l_Line_Payment_tbl(pay_count).trxn_extension_id: '||l_Line_Payment_tbl(pay_count).trxn_extension_id,1,'N');

4369: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4370: aso_debug_pub.add('l_Line_Payment_tbl(pay_count).payment_type_code: '||l_Line_Payment_tbl(pay_count).payment_type_code,1,'N');
4371: aso_debug_pub.add('l_Line_Payment_tbl(pay_count).payment_amount: '||l_Line_Payment_tbl(pay_count).payment_amount,1,'N');
4372: aso_debug_pub.add('l_Line_Payment_tbl(pay_count).operation: '||l_Line_Payment_tbl(pay_count).operation,1,'N');
4373: aso_debug_pub.add('l_Line_Payment_tbl(pay_count).trxn_extension_id: '||l_Line_Payment_tbl(pay_count).trxn_extension_id,1,'N');
4374: aso_debug_pub.add('l_Line_Payment_tbl(pay_count).payment_collection_event: '||l_Line_Payment_tbl(pay_count).payment_collection_event,1,'N');
4375: aso_debug_pub.add('l_Line_Payment_tbl(pay_count).payment_level_code: '||l_Line_Payment_tbl(pay_count).payment_level_code,1,'N');
4376: END IF;
4377:

Line 4374: aso_debug_pub.add('l_Line_Payment_tbl(pay_count).payment_collection_event: '||l_Line_Payment_tbl(pay_count).payment_collection_event,1,'N');

4370: aso_debug_pub.add('l_Line_Payment_tbl(pay_count).payment_type_code: '||l_Line_Payment_tbl(pay_count).payment_type_code,1,'N');
4371: aso_debug_pub.add('l_Line_Payment_tbl(pay_count).payment_amount: '||l_Line_Payment_tbl(pay_count).payment_amount,1,'N');
4372: aso_debug_pub.add('l_Line_Payment_tbl(pay_count).operation: '||l_Line_Payment_tbl(pay_count).operation,1,'N');
4373: aso_debug_pub.add('l_Line_Payment_tbl(pay_count).trxn_extension_id: '||l_Line_Payment_tbl(pay_count).trxn_extension_id,1,'N');
4374: aso_debug_pub.add('l_Line_Payment_tbl(pay_count).payment_collection_event: '||l_Line_Payment_tbl(pay_count).payment_collection_event,1,'N');
4375: aso_debug_pub.add('l_Line_Payment_tbl(pay_count).payment_level_code: '||l_Line_Payment_tbl(pay_count).payment_level_code,1,'N');
4376: END IF;
4377:
4378: IF P_Line_Payment_Tbl(i).payment_type_code = 'CHECK' THEN

Line 4375: aso_debug_pub.add('l_Line_Payment_tbl(pay_count).payment_level_code: '||l_Line_Payment_tbl(pay_count).payment_level_code,1,'N');

4371: aso_debug_pub.add('l_Line_Payment_tbl(pay_count).payment_amount: '||l_Line_Payment_tbl(pay_count).payment_amount,1,'N');
4372: aso_debug_pub.add('l_Line_Payment_tbl(pay_count).operation: '||l_Line_Payment_tbl(pay_count).operation,1,'N');
4373: aso_debug_pub.add('l_Line_Payment_tbl(pay_count).trxn_extension_id: '||l_Line_Payment_tbl(pay_count).trxn_extension_id,1,'N');
4374: aso_debug_pub.add('l_Line_Payment_tbl(pay_count).payment_collection_event: '||l_Line_Payment_tbl(pay_count).payment_collection_event,1,'N');
4375: aso_debug_pub.add('l_Line_Payment_tbl(pay_count).payment_level_code: '||l_Line_Payment_tbl(pay_count).payment_level_code,1,'N');
4376: END IF;
4377:
4378: IF P_Line_Payment_Tbl(i).payment_type_code = 'CHECK' THEN
4379: l_Line_Payment_tbl(pay_count).check_number := P_Line_Payment_Tbl(i).payment_ref_number;

Line 4392: IF aso_debug_pub.g_debug_flag = 'Y' THEN

4388: END LOOP;
4389:
4390: x_Line_Payment_tbl := l_Line_Payment_tbl;
4391: x_Line_tbl := l_Line_tbl;
4392: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4393: aso_debug_pub.add('mapped line payment tblx_Line_Payment_tbl.count'||x_Line_Payment_tbl.count,1,'N');
4394: aso_debug_pub.add('mapped line payment tbl',1,'N');
4395: aso_debug_pub.add('mapped line payment tblx_Line_tbl.count'||x_Line_tbl.count,1,'N');
4396: END IF;

Line 4393: aso_debug_pub.add('mapped line payment tblx_Line_Payment_tbl.count'||x_Line_Payment_tbl.count,1,'N');

4389:
4390: x_Line_Payment_tbl := l_Line_Payment_tbl;
4391: x_Line_tbl := l_Line_tbl;
4392: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4393: aso_debug_pub.add('mapped line payment tblx_Line_Payment_tbl.count'||x_Line_Payment_tbl.count,1,'N');
4394: aso_debug_pub.add('mapped line payment tbl',1,'N');
4395: aso_debug_pub.add('mapped line payment tblx_Line_tbl.count'||x_Line_tbl.count,1,'N');
4396: END IF;
4397:

Line 4394: aso_debug_pub.add('mapped line payment tbl',1,'N');

4390: x_Line_Payment_tbl := l_Line_Payment_tbl;
4391: x_Line_tbl := l_Line_tbl;
4392: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4393: aso_debug_pub.add('mapped line payment tblx_Line_Payment_tbl.count'||x_Line_Payment_tbl.count,1,'N');
4394: aso_debug_pub.add('mapped line payment tbl',1,'N');
4395: aso_debug_pub.add('mapped line payment tblx_Line_tbl.count'||x_Line_tbl.count,1,'N');
4396: END IF;
4397:
4398:

Line 4395: aso_debug_pub.add('mapped line payment tblx_Line_tbl.count'||x_Line_tbl.count,1,'N');

4391: x_Line_tbl := l_Line_tbl;
4392: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4393: aso_debug_pub.add('mapped line payment tblx_Line_Payment_tbl.count'||x_Line_Payment_tbl.count,1,'N');
4394: aso_debug_pub.add('mapped line payment tbl',1,'N');
4395: aso_debug_pub.add('mapped line payment tblx_Line_tbl.count'||x_Line_tbl.count,1,'N');
4396: END IF;
4397:
4398:
4399: end map_line_payments;