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_DEAL_PUB dependencies on ASO_DEBUG_PUB

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

187:
188: BEGIN
189:
190:
191: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
192: --pp_debug('In update deal'|| aso_debug_pub.g_debug_flag);
193: if aso_debug_pub.g_debug_flag='Y' then -- enabling trace
194: aso_debug_pub.SetDebugLevel(10);
195: aso_debug_pub.Initialize;

Line 192: --pp_debug('In update deal'|| aso_debug_pub.g_debug_flag);

188: BEGIN
189:
190:
191: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
192: --pp_debug('In update deal'|| aso_debug_pub.g_debug_flag);
193: if aso_debug_pub.g_debug_flag='Y' then -- enabling trace
194: aso_debug_pub.SetDebugLevel(10);
195: aso_debug_pub.Initialize;
196: l_file := ASO_DEBUG_PUB.Set_Debug_Mode('FILE');

Line 193: if aso_debug_pub.g_debug_flag='Y' then -- enabling trace

189:
190:
191: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
192: --pp_debug('In update deal'|| aso_debug_pub.g_debug_flag);
193: if aso_debug_pub.g_debug_flag='Y' then -- enabling trace
194: aso_debug_pub.SetDebugLevel(10);
195: aso_debug_pub.Initialize;
196: l_file := ASO_DEBUG_PUB.Set_Debug_Mode('FILE');
197: --pp_debug('In update deal'|| l_file);

Line 194: aso_debug_pub.SetDebugLevel(10);

190:
191: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
192: --pp_debug('In update deal'|| aso_debug_pub.g_debug_flag);
193: if aso_debug_pub.g_debug_flag='Y' then -- enabling trace
194: aso_debug_pub.SetDebugLevel(10);
195: aso_debug_pub.Initialize;
196: l_file := ASO_DEBUG_PUB.Set_Debug_Mode('FILE');
197: --pp_debug('In update deal'|| l_file);
198: aso_debug_pub.debug_on;

Line 195: aso_debug_pub.Initialize;

191: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
192: --pp_debug('In update deal'|| aso_debug_pub.g_debug_flag);
193: if aso_debug_pub.g_debug_flag='Y' then -- enabling trace
194: aso_debug_pub.SetDebugLevel(10);
195: aso_debug_pub.Initialize;
196: l_file := ASO_DEBUG_PUB.Set_Debug_Mode('FILE');
197: --pp_debug('In update deal'|| l_file);
198: aso_debug_pub.debug_on;
199: end if;

Line 196: l_file := ASO_DEBUG_PUB.Set_Debug_Mode('FILE');

192: --pp_debug('In update deal'|| aso_debug_pub.g_debug_flag);
193: if aso_debug_pub.g_debug_flag='Y' then -- enabling trace
194: aso_debug_pub.SetDebugLevel(10);
195: aso_debug_pub.Initialize;
196: l_file := ASO_DEBUG_PUB.Set_Debug_Mode('FILE');
197: --pp_debug('In update deal'|| l_file);
198: aso_debug_pub.debug_on;
199: end if;
200:

Line 198: aso_debug_pub.debug_on;

194: aso_debug_pub.SetDebugLevel(10);
195: aso_debug_pub.Initialize;
196: l_file := ASO_DEBUG_PUB.Set_Debug_Mode('FILE');
197: --pp_debug('In update deal'|| l_file);
198: aso_debug_pub.debug_on;
199: end if;
200:
201: --pp_debug('In update deal'|| aso_debug_pub.g_debug_flag);
202: IF aso_debug_pub.g_debug_flag = 'Y' then

Line 201: --pp_debug('In update deal'|| aso_debug_pub.g_debug_flag);

197: --pp_debug('In update deal'|| l_file);
198: aso_debug_pub.debug_on;
199: end if;
200:
201: --pp_debug('In update deal'|| aso_debug_pub.g_debug_flag);
202: IF aso_debug_pub.g_debug_flag = 'Y' then
203: aso_debug_pub.add('ASO_DEAL_PUB: ****** Start of Update_Quote_From_Deal API ******', 1, 'Y');
204: END IF;
205:

Line 202: IF aso_debug_pub.g_debug_flag = 'Y' then

198: aso_debug_pub.debug_on;
199: end if;
200:
201: --pp_debug('In update deal'|| aso_debug_pub.g_debug_flag);
202: IF aso_debug_pub.g_debug_flag = 'Y' then
203: aso_debug_pub.add('ASO_DEAL_PUB: ****** Start of Update_Quote_From_Deal API ******', 1, 'Y');
204: END IF;
205:
206: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 203: aso_debug_pub.add('ASO_DEAL_PUB: Start of Update_Quote_From_Deal API ', 1, 'Y');

199: end if;
200:
201: --pp_debug('In update deal'|| aso_debug_pub.g_debug_flag);
202: IF aso_debug_pub.g_debug_flag = 'Y' then
203: aso_debug_pub.add('ASO_DEAL_PUB: ****** Start of Update_Quote_From_Deal API ******', 1, 'Y');
204: END IF;
205:
206: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
207: 1.0,

Line 239: IF aso_debug_pub.g_debug_flag = 'Y' then

235:
236: --pp_debug('in first if'||p_event);
237: l_access_level := ASO_SECURITY_INT.Get_Quote_Access(p_resource_id,l_quote_number);
238:
239: IF aso_debug_pub.g_debug_flag = 'Y' then
240: aso_debug_pub.add('ASO_DEAL_PUB: Access Level'||l_access_level, 1, 'Y');
241: END IF;
242: --pp_debug('Access level:' || l_access_level);
243: IF ((l_access_level <> 'UPDATE') or (l_max_version_flag <> 'Y') or (l_price_request_id is not null)) THEN

Line 240: aso_debug_pub.add('ASO_DEAL_PUB: Access Level'||l_access_level, 1, 'Y');

236: --pp_debug('in first if'||p_event);
237: l_access_level := ASO_SECURITY_INT.Get_Quote_Access(p_resource_id,l_quote_number);
238:
239: IF aso_debug_pub.g_debug_flag = 'Y' then
240: aso_debug_pub.add('ASO_DEAL_PUB: Access Level'||l_access_level, 1, 'Y');
241: END IF;
242: --pp_debug('Access level:' || l_access_level);
243: IF ((l_access_level <> 'UPDATE') or (l_max_version_flag <> 'Y') or (l_price_request_id is not null)) THEN
244: x_return_status := fnd_api.g_ret_sts_error;

Line 280: IF aso_debug_pub.g_debug_flag = 'Y' then

276:
277: END IF; -- P_event in ('SUBMITTED', 'CANCELED', 'ACCEPTED')
278:
279: IF p_event = 'SUBMITTED' THEN
280: IF aso_debug_pub.g_debug_flag = 'Y' then
281: aso_debug_pub.add('ASO_DEAL_PUB:Status - '||p_event, 1, 'Y');
282: END IF;
283: open C_qte_status_id('PRICE APPROVAL PENDING');
284: fetch C_qte_status_id into ln_quote_Status_id;

Line 281: aso_debug_pub.add('ASO_DEAL_PUB:Status - '||p_event, 1, 'Y');

277: END IF; -- P_event in ('SUBMITTED', 'CANCELED', 'ACCEPTED')
278:
279: IF p_event = 'SUBMITTED' THEN
280: IF aso_debug_pub.g_debug_flag = 'Y' then
281: aso_debug_pub.add('ASO_DEAL_PUB:Status - '||p_event, 1, 'Y');
282: END IF;
283: open C_qte_status_id('PRICE APPROVAL PENDING');
284: fetch C_qte_status_id into ln_quote_Status_id;
285: close C_qte_status_id;

Line 335: IF aso_debug_pub.g_debug_flag = 'Y' then

331: AND FROM_STATUS_ID = l_quote_Status_id;
332:
333: if ln_count=0 then
334:
335: IF aso_debug_pub.g_debug_flag = 'Y' then
336: aso_debug_pub.add('ASO_DEAL_PUB:Status ln_count=0', 1, 'Y');
337: END IF;
338:
339: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 336: aso_debug_pub.add('ASO_DEAL_PUB:Status ln_count=0', 1, 'Y');

332:
333: if ln_count=0 then
334:
335: IF aso_debug_pub.g_debug_flag = 'Y' then
336: aso_debug_pub.add('ASO_DEAL_PUB:Status ln_count=0', 1, 'Y');
337: END IF;
338:
339: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
340: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 347: IF aso_debug_pub.g_debug_flag = 'Y' then

343: RAISE FND_API.G_EXC_ERROR;
344: END IF;
345: end if;
346: else -- if valid transition to price approval pending
347: IF aso_debug_pub.g_debug_flag = 'Y' then
348: aso_debug_pub.add('ASO_DEAL_PUB:Status ln_count>0'||ld_quote_Status_id, 1, 'Y');
349: END IF;
350: update aso_quote_headers_All
351: set quote_status_id=ld_quote_Status_id

Line 348: aso_debug_pub.add('ASO_DEAL_PUB:Status ln_count>0'||ld_quote_Status_id, 1, 'Y');

344: END IF;
345: end if;
346: else -- if valid transition to price approval pending
347: IF aso_debug_pub.g_debug_flag = 'Y' then
348: aso_debug_pub.add('ASO_DEAL_PUB:Status ln_count>0'||ld_quote_Status_id, 1, 'Y');
349: END IF;
350: update aso_quote_headers_All
351: set quote_status_id=ld_quote_Status_id
352: where quote_header_id=p_quote_header_id;

Line 360: IF aso_debug_pub.g_debug_flag = 'Y' then

356: open C_qte_status_id('PRICING APPROVED');
357: fetch C_qte_status_id into ln_quote_Status_id;
358: close C_qte_status_id;
359:
360: IF aso_debug_pub.g_debug_flag = 'Y' then
361: aso_debug_pub.add('ASO_DEAL_PUB:Status ln_count>0'||ld_quote_Status_id||'new stat'||ln_quote_Status_id, 1, 'Y');
362: END IF;
363:
364: ASO_VALIDATE_PVT.Validate_Status_Transition(

Line 361: aso_debug_pub.add('ASO_DEAL_PUB:Status ln_count>0'||ld_quote_Status_id||'new stat'||ln_quote_Status_id, 1, 'Y');

357: fetch C_qte_status_id into ln_quote_Status_id;
358: close C_qte_status_id;
359:
360: IF aso_debug_pub.g_debug_flag = 'Y' then
361: aso_debug_pub.add('ASO_DEAL_PUB:Status ln_count>0'||ld_quote_Status_id||'new stat'||ln_quote_Status_id, 1, 'Y');
362: END IF;
363:
364: ASO_VALIDATE_PVT.Validate_Status_Transition(
365: p_init_msg_list => FND_API.G_FALSE,

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

383:
384:
385:
386: -- for pricing adjustment updations
387: IF aso_debug_pub.g_debug_flag='Y' THEN
388: aso_debug_pub.add( 'In call update quote from deal API Before Price Adjustment' , 1 ,'Y') ;
389: end if;
390: /*
391: l_modifier_line_profile:=fnd_profile.value('QPR_DEAL_DIFF_MODIFIER');

Line 388: aso_debug_pub.add( 'In call update quote from deal API Before Price Adjustment' , 1 ,'Y') ;

384:
385:
386: -- for pricing adjustment updations
387: IF aso_debug_pub.g_debug_flag='Y' THEN
388: aso_debug_pub.add( 'In call update quote from deal API Before Price Adjustment' , 1 ,'Y') ;
389: end if;
390: /*
391: l_modifier_line_profile:=fnd_profile.value('QPR_DEAL_DIFF_MODIFIER');
392: L_modifier_line_id:=to_number(l_modifier_line_profile);

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

394: IF L_modifier_line_id is NULL THEN
395: FND_MESSAGE.SET_NAME('ASO','ASO_DEAL_PRC_PROFILE_NOT_SET');
396: --FND_MESSAGE.SET_TOKEN('PROFILE', 'QPR_DEAL_DIFF_MODIFIER');
397: FND_MSG_PUB.ADD;
398: IF aso_debug_pub.g_debug_flag='Y' THEN
399: aso_debug_pub.add( 'Profile is NULL ' , 1 ) ;
400: END IF;
401: RAISE FND_API.G_EXC_ERROR;
402: END IF;

Line 399: aso_debug_pub.add( 'Profile is NULL ' , 1 ) ;

395: FND_MESSAGE.SET_NAME('ASO','ASO_DEAL_PRC_PROFILE_NOT_SET');
396: --FND_MESSAGE.SET_TOKEN('PROFILE', 'QPR_DEAL_DIFF_MODIFIER');
397: FND_MSG_PUB.ADD;
398: IF aso_debug_pub.g_debug_flag='Y' THEN
399: aso_debug_pub.add( 'Profile is NULL ' , 1 ) ;
400: END IF;
401: RAISE FND_API.G_EXC_ERROR;
402: END IF;
403:

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

401: RAISE FND_API.G_EXC_ERROR;
402: END IF;
403:
404:
405: IF aso_debug_pub.g_debug_flag='Y' THEN
406: aso_debug_pub.add( 'In call Update Quote From Deal API-Modifier ' || L_modifier_line_id , 1 ,'Y') ;
407: END IF;
408: */
409:

Line 406: aso_debug_pub.add( 'In call Update Quote From Deal API-Modifier ' || L_modifier_line_id , 1 ,'Y') ;

402: END IF;
403:
404:
405: IF aso_debug_pub.g_debug_flag='Y' THEN
406: aso_debug_pub.add( 'In call Update Quote From Deal API-Modifier ' || L_modifier_line_id , 1 ,'Y') ;
407: END IF;
408: */
409:
410: -- using ref cursor for dynamic execution of multirow query

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

421: fetch prcadj_cv into l_uom_code ,l_currency_code ,l_ordered_qty,l_updated_line_price,l_quote_line_id,l_shipment_method_code,l_payment_term_id;
422: --pp_debug('values from deal qty ' || l_ordered_qty||'price'||l_updated_line_price||'quote_line_id'||l_quote_line_id);
423: exit when prcadj_cv%NOTFOUND;
424: l_continue:='Y';
425: IF aso_debug_pub.g_debug_flag='Y' THEN
426: aso_debug_pub.add( 'In call Update Quote From Deal API-source line id ' || l_quote_line_id||'Price'||l_updated_line_price , 1 ) ;
427: END IF;
428:
429:

Line 426: aso_debug_pub.add( 'In call Update Quote From Deal API-source line id ' || l_quote_line_id||'Price'||l_updated_line_price , 1 ) ;

422: --pp_debug('values from deal qty ' || l_ordered_qty||'price'||l_updated_line_price||'quote_line_id'||l_quote_line_id);
423: exit when prcadj_cv%NOTFOUND;
424: l_continue:='Y';
425: IF aso_debug_pub.g_debug_flag='Y' THEN
426: aso_debug_pub.add( 'In call Update Quote From Deal API-source line id ' || l_quote_line_id||'Price'||l_updated_line_price , 1 ) ;
427: END IF;
428:
429:
430: i:=i+1;

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

448: end if;
449:
450: -- checking for quanity
451: if (l_ordered_qty is not null) and (l_ordered_qty<>l_line_qty) then
452: IF aso_debug_pub.g_debug_flag='Y' THEN
453: aso_debug_pub.add( 'In call Update Quote From Deal API-qty change ' || l_ordered_qty , 1 ) ;
454: --pp_debug('In call Update Quote From Deal API-qty change ' || l_ordered_qty);
455: END IF;
456: l_qte_line_tbl(i).quantity :=l_ordered_qty;

Line 453: aso_debug_pub.add( 'In call Update Quote From Deal API-qty change ' || l_ordered_qty , 1 ) ;

449:
450: -- checking for quanity
451: if (l_ordered_qty is not null) and (l_ordered_qty<>l_line_qty) then
452: IF aso_debug_pub.g_debug_flag='Y' THEN
453: aso_debug_pub.add( 'In call Update Quote From Deal API-qty change ' || l_ordered_qty , 1 ) ;
454: --pp_debug('In call Update Quote From Deal API-qty change ' || l_ordered_qty);
455: END IF;
456: l_qte_line_tbl(i).quantity :=l_ordered_qty;
457: l_qte_line_tbl(i).pricing_quantity :=l_ordered_qty;

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

461: -- for shipment line level changes
462: if (l_shipment_method_code is not null) and (l_shipment_method_code<>l_line_ship_method_code) then
463: l_ln_shipment_Tbl1:= ASO_UTILITY_PVT.Query_Shipment_Rows(P_Quote_Header_Id,l_quote_line_id); -- For Fetching line shipment terms
464:
465: IF aso_debug_pub.g_debug_flag='Y' THEN
466: aso_debug_pub.add( 'In call update quote from deal API Before Shipment'|| l_ln_shipment_Tbl1.count , 1 ) ;
467: END IF;
468: s_index:=s_index+1;
469: if l_ln_shipment_Tbl1.count = 0 then

Line 466: aso_debug_pub.add( 'In call update quote from deal API Before Shipment'|| l_ln_shipment_Tbl1.count , 1 ) ;

462: if (l_shipment_method_code is not null) and (l_shipment_method_code<>l_line_ship_method_code) then
463: l_ln_shipment_Tbl1:= ASO_UTILITY_PVT.Query_Shipment_Rows(P_Quote_Header_Id,l_quote_line_id); -- For Fetching line shipment terms
464:
465: IF aso_debug_pub.g_debug_flag='Y' THEN
466: aso_debug_pub.add( 'In call update quote from deal API Before Shipment'|| l_ln_shipment_Tbl1.count , 1 ) ;
467: END IF;
468: s_index:=s_index+1;
469: if l_ln_shipment_Tbl1.count = 0 then
470: l_ln_shipment_Tbl(s_index):=ASO_QUOTE_PUB.G_MISS_Shipment_REC;

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

485:
486: end if;
487: -- end shipment
488:
489: IF aso_debug_pub.g_debug_flag='Y' THEN
490: aso_debug_pub.add( 'In call update quote from deal API after payment number of rows: '||l_ln_shipment_Tbl.count, 1 ) ;
491: END IF;
492:
493:

Line 490: aso_debug_pub.add( 'In call update quote from deal API after payment number of rows: '||l_ln_shipment_Tbl.count, 1 ) ;

486: end if;
487: -- end shipment
488:
489: IF aso_debug_pub.g_debug_flag='Y' THEN
490: aso_debug_pub.add( 'In call update quote from deal API after payment number of rows: '||l_ln_shipment_Tbl.count, 1 ) ;
491: END IF;
492:
493:
494: --pp_debug('before Entered payment'|| l_payment_term_id||'line'||l_line_payment_term_id);

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

494: --pp_debug('before Entered payment'|| l_payment_term_id||'line'||l_line_payment_term_id);
495: -- for payment terms line level changes
496: IF (l_payment_term_id is not NULL) and (l_payment_term_id <> l_line_payment_term_id) THEN
497: l_ln_Payment_Tbl1:= ASO_UTILITY_PVT.Query_Payment_Rows(P_Quote_Header_Id,l_quote_line_id); -- For Fetching header payment terms
498: IF aso_debug_pub.g_debug_flag='Y' THEN
499: aso_debug_pub.add( 'In call update quote from deal API payment number of rows: '||l_ln_Payment_Tbl1.count||',payment term id'||l_payment_term_id , 1 ) ;
500: END IF;
501: pa_index:=pa_index+1;
502: if l_ln_Payment_Tbl1.count = 0 then

Line 499: aso_debug_pub.add( 'In call update quote from deal API payment number of rows: '||l_ln_Payment_Tbl1.count||',payment term id'||l_payment_term_id , 1 ) ;

495: -- for payment terms line level changes
496: IF (l_payment_term_id is not NULL) and (l_payment_term_id <> l_line_payment_term_id) THEN
497: l_ln_Payment_Tbl1:= ASO_UTILITY_PVT.Query_Payment_Rows(P_Quote_Header_Id,l_quote_line_id); -- For Fetching header payment terms
498: IF aso_debug_pub.g_debug_flag='Y' THEN
499: aso_debug_pub.add( 'In call update quote from deal API payment number of rows: '||l_ln_Payment_Tbl1.count||',payment term id'||l_payment_term_id , 1 ) ;
500: END IF;
501: pa_index:=pa_index+1;
502: if l_ln_Payment_Tbl1.count = 0 then
503: l_ln_Payment_Tbl(pa_index):=ASO_QUOTE_PUB.G_MISS_Payment_REC;

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

507: l_ln_Payment_Tbl(pa_index).operation_code := 'CREATE' ;
508: elsif l_ln_Payment_Tbl1.count > 0 then
509: l_ln_Payment_Tbl(pa_index):=ASO_QUOTE_PUB.G_MISS_Payment_REC;
510: l_ln_Payment_rec:=l_ln_Payment_Tbl1(1);
511: IF aso_debug_pub.g_debug_flag='Y' THEN
512: aso_debug_pub.add( 'In call update quote from deal API after payment number of rows: '||l_ln_Payment_rec.payment_id, 1 ) ;
513: END IF;
514: l_ln_Payment_rec.PAYMENT_TERM_ID := l_payment_term_id;
515: l_ln_Payment_rec.Quote_Header_Id := P_Quote_Header_Id;

Line 512: aso_debug_pub.add( 'In call update quote from deal API after payment number of rows: '||l_ln_Payment_rec.payment_id, 1 ) ;

508: elsif l_ln_Payment_Tbl1.count > 0 then
509: l_ln_Payment_Tbl(pa_index):=ASO_QUOTE_PUB.G_MISS_Payment_REC;
510: l_ln_Payment_rec:=l_ln_Payment_Tbl1(1);
511: IF aso_debug_pub.g_debug_flag='Y' THEN
512: aso_debug_pub.add( 'In call update quote from deal API after payment number of rows: '||l_ln_Payment_rec.payment_id, 1 ) ;
513: END IF;
514: l_ln_Payment_rec.PAYMENT_TERM_ID := l_payment_term_id;
515: l_ln_Payment_rec.Quote_Header_Id := P_Quote_Header_Id;
516: l_ln_Payment_rec.Quote_line_Id := l_quote_line_id;

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

519: end if;
520:
521: END IF;
522: -- end payment
523: IF aso_debug_pub.g_debug_flag='Y' THEN
524: aso_debug_pub.add( 'In call update quote from deal API after payment number of rows: '||l_ln_Payment_Tbl.count, 1 ) ;
525: END IF;
526:
527: -- New Coding for already applied line level adjustments

Line 524: aso_debug_pub.add( 'In call update quote from deal API after payment number of rows: '||l_ln_Payment_Tbl.count, 1 ) ;

520:
521: END IF;
522: -- end payment
523: IF aso_debug_pub.g_debug_flag='Y' THEN
524: aso_debug_pub.add( 'In call update quote from deal API after payment number of rows: '||l_ln_Payment_Tbl.count, 1 ) ;
525: END IF;
526:
527: -- New Coding for already applied line level adjustments
528:

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

533:
534: for cur_auto_adj in cur_app_adj(p_quote_header_id,l_quote_line_id,l_modifier_line_id)
535: loop
536:
537: IF aso_debug_pub.g_debug_flag='Y' THEN
538: aso_debug_pub.add( 'Entered new code for previous adjustments cur_auto_adj', 1 ) ;
539: END IF;
540:
541: p_index:=p_index+1;

Line 538: aso_debug_pub.add( 'Entered new code for previous adjustments cur_auto_adj', 1 ) ;

534: for cur_auto_adj in cur_app_adj(p_quote_header_id,l_quote_line_id,l_modifier_line_id)
535: loop
536:
537: IF aso_debug_pub.g_debug_flag='Y' THEN
538: aso_debug_pub.add( 'Entered new code for previous adjustments cur_auto_adj', 1 ) ;
539: END IF;
540:
541: p_index:=p_index+1;
542: -- Assigning the price adjustments for line id fetched

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

581: l_Price_Adjustment_Tbl(p_index).change_reason_code :=cur_auto_adj.change_reason_code;
582: l_Price_Adjustment_Tbl(p_index).change_reason_text:=cur_auto_adj.change_reason_text;
583: end loop;
584:
585: IF aso_debug_pub.g_debug_flag='Y' THEN
586: aso_debug_pub.add( 'count new code for previous adjustments'||l_Price_Adjustment_Tbl.count, 1 ) ;
587: END IF;
588:
589:

Line 586: aso_debug_pub.add( 'count new code for previous adjustments'||l_Price_Adjustment_Tbl.count, 1 ) ;

582: l_Price_Adjustment_Tbl(p_index).change_reason_text:=cur_auto_adj.change_reason_text;
583: end loop;
584:
585: IF aso_debug_pub.g_debug_flag='Y' THEN
586: aso_debug_pub.add( 'count new code for previous adjustments'||l_Price_Adjustment_Tbl.count, 1 ) ;
587: END IF;
588:
589:
590: -- end coding for already applied automatic adjustments

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

594:
595: /* l_modifier_line_profile:=fnd_profile.value('QPR_DEAL_DIFF_MODIFIER');
596: L_modifier_line_id:=to_number(l_modifier_line_profile);
597: */
598: IF aso_debug_pub.g_debug_flag='Y' THEN
599: aso_debug_pub.add( 'Line Modifier Value'||L_modifier_line_id, 1 ) ;
600: END IF;
601:
602: IF L_modifier_line_id is NULL THEN

Line 599: aso_debug_pub.add( 'Line Modifier Value'||L_modifier_line_id, 1 ) ;

595: /* l_modifier_line_profile:=fnd_profile.value('QPR_DEAL_DIFF_MODIFIER');
596: L_modifier_line_id:=to_number(l_modifier_line_profile);
597: */
598: IF aso_debug_pub.g_debug_flag='Y' THEN
599: aso_debug_pub.add( 'Line Modifier Value'||L_modifier_line_id, 1 ) ;
600: END IF;
601:
602: IF L_modifier_line_id is NULL THEN
603: FND_MESSAGE.SET_NAME('ASO','ASO_DEAL_PRC_PROFILE_NOT_SET');

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

602: IF L_modifier_line_id is NULL THEN
603: FND_MESSAGE.SET_NAME('ASO','ASO_DEAL_PRC_PROFILE_NOT_SET');
604: --FND_MESSAGE.SET_TOKEN('PROFILE', 'QPR_DEAL_DIFF_MODIFIER');
605: FND_MSG_PUB.ADD;
606: IF aso_debug_pub.g_debug_flag='Y' THEN
607: aso_debug_pub.add( 'Profile is NULL ' , 1 ) ;
608: END IF;
609: RAISE FND_API.G_EXC_ERROR;
610: END IF;

Line 607: aso_debug_pub.add( 'Profile is NULL ' , 1 ) ;

603: FND_MESSAGE.SET_NAME('ASO','ASO_DEAL_PRC_PROFILE_NOT_SET');
604: --FND_MESSAGE.SET_TOKEN('PROFILE', 'QPR_DEAL_DIFF_MODIFIER');
605: FND_MSG_PUB.ADD;
606: IF aso_debug_pub.g_debug_flag='Y' THEN
607: aso_debug_pub.add( 'Profile is NULL ' , 1 ) ;
608: END IF;
609: RAISE FND_API.G_EXC_ERROR;
610: END IF;
611:

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

609: RAISE FND_API.G_EXC_ERROR;
610: END IF;
611:
612:
613: IF aso_debug_pub.g_debug_flag='Y' THEN
614: aso_debug_pub.add( 'In call Update Quote From Deal API-Modifier ' || L_modifier_line_id , 1 ,'Y') ;
615: END IF;
616:
617:

Line 614: aso_debug_pub.add( 'In call Update Quote From Deal API-Modifier ' || L_modifier_line_id , 1 ,'Y') ;

610: END IF;
611:
612:
613: IF aso_debug_pub.g_debug_flag='Y' THEN
614: aso_debug_pub.add( 'In call Update Quote From Deal API-Modifier ' || L_modifier_line_id , 1 ,'Y') ;
615: END IF;
616:
617:
618:

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

634: AND nvl(apa.expiration_date,sysdate) >= sysdate
635: AND apa.quote_line_id = aqla.quote_line_id;
636: elsif l_count_modifier=0 then
637: l_continue:='N';
638: IF aso_debug_pub.g_debug_flag='Y' THEN
639: aso_debug_pub.add( 'Modifier NO data found-Dont update this Line for modifier' , 1,'Y' ) ; -- need to have an error message here
640: end if;
641:
642: select name into l_modifier_name

Line 639: aso_debug_pub.add( 'Modifier NO data found-Dont update this Line for modifier' , 1,'Y' ) ; -- need to have an error message here

635: AND apa.quote_line_id = aqla.quote_line_id;
636: elsif l_count_modifier=0 then
637: l_continue:='N';
638: IF aso_debug_pub.g_debug_flag='Y' THEN
639: aso_debug_pub.add( 'Modifier NO data found-Dont update this Line for modifier' , 1,'Y' ) ; -- need to have an error message here
640: end if;
641:
642: select name into l_modifier_name
643: from qp_list_headers_tl t,qp_list_lines td

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

651: RAISE FND_API.G_EXC_ERROR;
652: end if;
653:
654:
655: IF aso_debug_pub.g_debug_flag='Y' THEN
656: aso_debug_pub.add( 'Modifier Adjustment exist'||l_continue , 1,'Y' ) ;
657: --pp_debug( 'Modifier Adjustment exist'||l_continue);
658: end if;
659:

Line 656: aso_debug_pub.add( 'Modifier Adjustment exist'||l_continue , 1,'Y' ) ;

652: end if;
653:
654:
655: IF aso_debug_pub.g_debug_flag='Y' THEN
656: aso_debug_pub.add( 'Modifier Adjustment exist'||l_continue , 1,'Y' ) ;
657: --pp_debug( 'Modifier Adjustment exist'||l_continue);
658: end if;
659:
660: IF (l_continue='Y') then -- Adjustment exists for the line

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

665: --pp_debug( 'Modifier Adjustment exist ld_operand121'||ld_operand);
666: ld_operand:= l_line_quote_price - l_updated_line_price ;
667: End if;
668:
669: IF aso_debug_pub.g_debug_flag='Y' THEN
670: aso_debug_pub.add( 'Modifier Calculated operand'||ld_operand , 1,'Y' ) ;
671: end if;
672: --pp_debug( 'Modifier Adjustment exist ld_operand'||ld_operand);
673:

Line 670: aso_debug_pub.add( 'Modifier Calculated operand'||ld_operand , 1,'Y' ) ;

666: ld_operand:= l_line_quote_price - l_updated_line_price ;
667: End if;
668:
669: IF aso_debug_pub.g_debug_flag='Y' THEN
670: aso_debug_pub.add( 'Modifier Calculated operand'||ld_operand , 1,'Y' ) ;
671: end if;
672: --pp_debug( 'Modifier Adjustment exist ld_operand'||ld_operand);
673:
674: p_index:=p_index+1;

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

706:
707:
708:
709:
710: IF aso_debug_pub.g_debug_flag='Y' THEN
711: aso_debug_pub.add( 'Modifier Price adjustment'||l_Price_Adjustment_Tbl.count , 1,'Y' ) ;
712: end if;
713: --pp_debug('end approved event price'||l_Price_Adjustment_Tbl.count);
714: --pp_debug('end approved event price'||l_Qte_Line_Tbl.count);

Line 711: aso_debug_pub.add( 'Modifier Price adjustment'||l_Price_Adjustment_Tbl.count , 1,'Y' ) ;

707:
708:
709:
710: IF aso_debug_pub.g_debug_flag='Y' THEN
711: aso_debug_pub.add( 'Modifier Price adjustment'||l_Price_Adjustment_Tbl.count , 1,'Y' ) ;
712: end if;
713: --pp_debug('end approved event price'||l_Price_Adjustment_Tbl.count);
714: --pp_debug('end approved event price'||l_Qte_Line_Tbl.count);
715:

Line 750: IF aso_debug_pub.g_debug_flag = 'Y' then

746:
747: END IF;
748:
749: IF P_event in ('ACCEPTED') then
750: IF aso_debug_pub.g_debug_flag = 'Y' then
751: aso_debug_pub.add('ASO_DEAL_PUB before aso_quote_pub.update_quote - '||p_event, 1, 'Y');
752: aso_debug_pub.add('ASO_DEAL_PUB:l_qte_header_rec.quote_status_id - '||l_qte_header_rec.quote_status_id, 1, 'Y');
753: aso_debug_pub.ADD ('Before calling update quote: Setting the single org context to org_id: '|| l_qte_header_rec.org_id,1,'N');
754: END IF;

Line 751: aso_debug_pub.add('ASO_DEAL_PUB before aso_quote_pub.update_quote - '||p_event, 1, 'Y');

747: END IF;
748:
749: IF P_event in ('ACCEPTED') then
750: IF aso_debug_pub.g_debug_flag = 'Y' then
751: aso_debug_pub.add('ASO_DEAL_PUB before aso_quote_pub.update_quote - '||p_event, 1, 'Y');
752: aso_debug_pub.add('ASO_DEAL_PUB:l_qte_header_rec.quote_status_id - '||l_qte_header_rec.quote_status_id, 1, 'Y');
753: aso_debug_pub.ADD ('Before calling update quote: Setting the single org context to org_id: '|| l_qte_header_rec.org_id,1,'N');
754: END IF;
755:

Line 752: aso_debug_pub.add('ASO_DEAL_PUB:l_qte_header_rec.quote_status_id - '||l_qte_header_rec.quote_status_id, 1, 'Y');

748:
749: IF P_event in ('ACCEPTED') then
750: IF aso_debug_pub.g_debug_flag = 'Y' then
751: aso_debug_pub.add('ASO_DEAL_PUB before aso_quote_pub.update_quote - '||p_event, 1, 'Y');
752: aso_debug_pub.add('ASO_DEAL_PUB:l_qte_header_rec.quote_status_id - '||l_qte_header_rec.quote_status_id, 1, 'Y');
753: aso_debug_pub.ADD ('Before calling update quote: Setting the single org context to org_id: '|| l_qte_header_rec.org_id,1,'N');
754: END IF;
755:
756: -- Setting MOAC

Line 753: aso_debug_pub.ADD ('Before calling update quote: Setting the single org context to org_id: '|| l_qte_header_rec.org_id,1,'N');

749: IF P_event in ('ACCEPTED') then
750: IF aso_debug_pub.g_debug_flag = 'Y' then
751: aso_debug_pub.add('ASO_DEAL_PUB before aso_quote_pub.update_quote - '||p_event, 1, 'Y');
752: aso_debug_pub.add('ASO_DEAL_PUB:l_qte_header_rec.quote_status_id - '||l_qte_header_rec.quote_status_id, 1, 'Y');
753: aso_debug_pub.ADD ('Before calling update quote: Setting the single org context to org_id: '|| l_qte_header_rec.org_id,1,'N');
754: END IF;
755:
756: -- Setting MOAC
757: mo_global.set_policy_context('S', l_qte_header_rec.org_id);

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

802: x_msg_data => x_msg_data
803: );
804:
805: --pp_debug('after calling aso_quote_pub');
806: IF aso_debug_pub.g_debug_flag = 'Y' THEN
807: aso_debug_pub.add('ASO_DEAL_PUB: after Update_Quote', 1, 'Y');
808: END IF;
809:
810: if x_return_status = FND_API.G_RET_STS_SUCCESS then

Line 807: aso_debug_pub.add('ASO_DEAL_PUB: after Update_Quote', 1, 'Y');

803: );
804:
805: --pp_debug('after calling aso_quote_pub');
806: IF aso_debug_pub.g_debug_flag = 'Y' THEN
807: aso_debug_pub.add('ASO_DEAL_PUB: after Update_Quote', 1, 'Y');
808: END IF;
809:
810: if x_return_status = FND_API.G_RET_STS_SUCCESS then
811: Update aso_quote_lines_all

Line 838: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

834: WHEN FND_API.G_EXC_ERROR THEN
835: --pp_debug('error aso_quote_pub');
836:
837:
838: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
839: aso_debug_pub.add('Exception in package : '|| G_PKG_NAME, 1, 'N');
840: aso_debug_pub.add('Exception in API : '|| L_API_NAME, 1, 'N');
841: end if;
842:

Line 839: aso_debug_pub.add('Exception in package : '|| G_PKG_NAME, 1, 'N');

835: --pp_debug('error aso_quote_pub');
836:
837:
838: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
839: aso_debug_pub.add('Exception in package : '|| G_PKG_NAME, 1, 'N');
840: aso_debug_pub.add('Exception in API : '|| L_API_NAME, 1, 'N');
841: end if;
842:
843: x_return_status := FND_API.G_RET_STS_ERROR;

Line 840: aso_debug_pub.add('Exception in API : '|| L_API_NAME, 1, 'N');

836:
837:
838: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
839: aso_debug_pub.add('Exception in package : '|| G_PKG_NAME, 1, 'N');
840: aso_debug_pub.add('Exception in API : '|| L_API_NAME, 1, 'N');
841: end if;
842:
843: x_return_status := FND_API.G_RET_STS_ERROR;
844:

Line 858: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

854:
855: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
856: --pp_debug('unerror aso_quote_pub'||DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
857:
858: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
859: aso_debug_pub.add('Exception in package : '|| G_PKG_NAME, 1, 'N');
860: aso_debug_pub.add('Exception in API : '|| L_API_NAME, 1, 'N');
861: end if;
862:

Line 859: aso_debug_pub.add('Exception in package : '|| G_PKG_NAME, 1, 'N');

855: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
856: --pp_debug('unerror aso_quote_pub'||DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
857:
858: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
859: aso_debug_pub.add('Exception in package : '|| G_PKG_NAME, 1, 'N');
860: aso_debug_pub.add('Exception in API : '|| L_API_NAME, 1, 'N');
861: end if;
862:
863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 860: aso_debug_pub.add('Exception in API : '|| L_API_NAME, 1, 'N');

856: --pp_debug('unerror aso_quote_pub'||DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
857:
858: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
859: aso_debug_pub.add('Exception in package : '|| G_PKG_NAME, 1, 'N');
860: aso_debug_pub.add('Exception in API : '|| L_API_NAME, 1, 'N');
861: end if;
862:
863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
864: FND_MSG_PUB.Count_And_Get

Line 872: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

868: ASO_UTILITY_PVT.Get_Messages(x_msg_count, x_msg_data);
869:
870: WHEN OTHERS THEN
871: --pp_debug('error others aso_quote_pub'||DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
872: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
873: aso_debug_pub.add('Exception in package : '|| G_PKG_NAME, 1, 'N');
874: aso_debug_pub.add('Exception in API : '|| L_API_NAME, 1, 'N');
875: aso_debug_pub.add('SQLCODE : '|| SQLCODE, 1, 'N');
876: aso_debug_pub.add('SQLERRM : '|| SQLERRM, 1, 'N');

Line 873: aso_debug_pub.add('Exception in package : '|| G_PKG_NAME, 1, 'N');

869:
870: WHEN OTHERS THEN
871: --pp_debug('error others aso_quote_pub'||DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
872: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
873: aso_debug_pub.add('Exception in package : '|| G_PKG_NAME, 1, 'N');
874: aso_debug_pub.add('Exception in API : '|| L_API_NAME, 1, 'N');
875: aso_debug_pub.add('SQLCODE : '|| SQLCODE, 1, 'N');
876: aso_debug_pub.add('SQLERRM : '|| SQLERRM, 1, 'N');
877: END IF;

Line 874: aso_debug_pub.add('Exception in API : '|| L_API_NAME, 1, 'N');

870: WHEN OTHERS THEN
871: --pp_debug('error others aso_quote_pub'||DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
872: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
873: aso_debug_pub.add('Exception in package : '|| G_PKG_NAME, 1, 'N');
874: aso_debug_pub.add('Exception in API : '|| L_API_NAME, 1, 'N');
875: aso_debug_pub.add('SQLCODE : '|| SQLCODE, 1, 'N');
876: aso_debug_pub.add('SQLERRM : '|| SQLERRM, 1, 'N');
877: END IF;
878:

Line 875: aso_debug_pub.add('SQLCODE : '|| SQLCODE, 1, 'N');

871: --pp_debug('error others aso_quote_pub'||DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
872: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
873: aso_debug_pub.add('Exception in package : '|| G_PKG_NAME, 1, 'N');
874: aso_debug_pub.add('Exception in API : '|| L_API_NAME, 1, 'N');
875: aso_debug_pub.add('SQLCODE : '|| SQLCODE, 1, 'N');
876: aso_debug_pub.add('SQLERRM : '|| SQLERRM, 1, 'N');
877: END IF;
878:
879: FND_MESSAGE.Set_Name('ASO', 'ASO_ERROR_RETURNED');

Line 876: aso_debug_pub.add('SQLERRM : '|| SQLERRM, 1, 'N');

872: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
873: aso_debug_pub.add('Exception in package : '|| G_PKG_NAME, 1, 'N');
874: aso_debug_pub.add('Exception in API : '|| L_API_NAME, 1, 'N');
875: aso_debug_pub.add('SQLCODE : '|| SQLCODE, 1, 'N');
876: aso_debug_pub.add('SQLERRM : '|| SQLERRM, 1, 'N');
877: END IF;
878:
879: FND_MESSAGE.Set_Name('ASO', 'ASO_ERROR_RETURNED');
880: FND_MESSAGE.Set_token('PKG_NAME' , g_pkg_name);

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

921: l_status_override VARCHAR2(1) := 'Y';
922:
923: BEGIN
924:
925: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
926:
927: -- API body
928: IF aso_debug_pub.g_debug_flag = 'Y' THEN
929: aso_debug_pub.add('ASO_DEAL_PUB: ****** Start of Get_Deal_Access API ******', 1, 'Y');

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

924:
925: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
926:
927: -- API body
928: IF aso_debug_pub.g_debug_flag = 'Y' THEN
929: aso_debug_pub.add('ASO_DEAL_PUB: ****** Start of Get_Deal_Access API ******', 1, 'Y');
930: END IF;
931:
932: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 929: aso_debug_pub.add('ASO_DEAL_PUB: Start of Get_Deal_Access API ', 1, 'Y');

925: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
926:
927: -- API body
928: IF aso_debug_pub.g_debug_flag = 'Y' THEN
929: aso_debug_pub.add('ASO_DEAL_PUB: ****** Start of Get_Deal_Access API ******', 1, 'Y');
930: END IF;
931:
932: IF aso_debug_pub.g_debug_flag = 'Y' THEN
933: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Access: P_RESOURCE_ID: ' || P_RESOURCE_ID, 1, 'Y');

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

928: IF aso_debug_pub.g_debug_flag = 'Y' THEN
929: aso_debug_pub.add('ASO_DEAL_PUB: ****** Start of Get_Deal_Access API ******', 1, 'Y');
930: END IF;
931:
932: IF aso_debug_pub.g_debug_flag = 'Y' THEN
933: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Access: P_RESOURCE_ID: ' || P_RESOURCE_ID, 1, 'Y');
934: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Access: P_QUOTE_HEADER_ID: ' || P_QUOTE_HEADER_ID, 1, 'Y');
935: END IF;
936:

Line 933: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Access: P_RESOURCE_ID: ' || P_RESOURCE_ID, 1, 'Y');

929: aso_debug_pub.add('ASO_DEAL_PUB: ****** Start of Get_Deal_Access API ******', 1, 'Y');
930: END IF;
931:
932: IF aso_debug_pub.g_debug_flag = 'Y' THEN
933: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Access: P_RESOURCE_ID: ' || P_RESOURCE_ID, 1, 'Y');
934: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Access: P_QUOTE_HEADER_ID: ' || P_QUOTE_HEADER_ID, 1, 'Y');
935: END IF;
936:
937: -- Getting quote header Details

Line 934: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Access: P_QUOTE_HEADER_ID: ' || P_QUOTE_HEADER_ID, 1, 'Y');

930: END IF;
931:
932: IF aso_debug_pub.g_debug_flag = 'Y' THEN
933: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Access: P_RESOURCE_ID: ' || P_RESOURCE_ID, 1, 'Y');
934: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Access: P_QUOTE_HEADER_ID: ' || P_QUOTE_HEADER_ID, 1, 'Y');
935: END IF;
936:
937: -- Getting quote header Details
938: SELECT nvl(max_version_flag,'N'), price_request_id, nvl(pricing_status_indicator,'C'),quote_number,quote_status_id

Line 946: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Access: Access level returned by ASO_SECURITY_INT: ' || l_access_level, 1, 'Y');

942:
943: -- Getting the user level access
944: l_access_level:=ASO_SECURITY_INT.Get_Quote_Access (p_resource_id,l_quote_number);
945:
946: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Access: Access level returned by ASO_SECURITY_INT: ' || l_access_level, 1, 'Y');
947:
948: -- User has update access to quote. In case user has access level 'READ' or 'NONE' for the quote nothing needs to be done
949: -- check additional conditions for max version, batch pricing, status
950: IF l_access_level = 'UPDATE' then

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

973: l_access_level:= 'READ';
974: end if;
975: END IF;
976: -- End of API body
977: IF aso_debug_pub.g_debug_flag = 'Y' THEN
978: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Access: End of API body', 1, 'Y');
979: END IF;
980: RETURN l_access_level;
981:

Line 978: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Access: End of API body', 1, 'Y');

974: end if;
975: END IF;
976: -- End of API body
977: IF aso_debug_pub.g_debug_flag = 'Y' THEN
978: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Access: End of API body', 1, 'Y');
979: END IF;
980: RETURN l_access_level;
981:
982: END Get_Deal_Access;

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

996: l_quote_number NUMBER;
997:
998: BEGIN
999:
1000: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
1001:
1002: -- API body
1003: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1004: aso_debug_pub.add('ASO_DEAL_PUB: ****** Start of Get_Deal_Enable_Buttons API ******', 1, 'Y');

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

999:
1000: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
1001:
1002: -- API body
1003: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1004: aso_debug_pub.add('ASO_DEAL_PUB: ****** Start of Get_Deal_Enable_Buttons API ******', 1, 'Y');
1005: END IF;
1006:
1007: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 1004: aso_debug_pub.add('ASO_DEAL_PUB: Start of Get_Deal_Enable_Buttons API ', 1, 'Y');

1000: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
1001:
1002: -- API body
1003: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1004: aso_debug_pub.add('ASO_DEAL_PUB: ****** Start of Get_Deal_Enable_Buttons API ******', 1, 'Y');
1005: END IF;
1006:
1007: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1008: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Enable_Buttons: P_RESOURCE_ID: ' || P_RESOURCE_ID, 1, 'Y');

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

1003: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1004: aso_debug_pub.add('ASO_DEAL_PUB: ****** Start of Get_Deal_Enable_Buttons API ******', 1, 'Y');
1005: END IF;
1006:
1007: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1008: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Enable_Buttons: P_RESOURCE_ID: ' || P_RESOURCE_ID, 1, 'Y');
1009: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Enable_Buttons: P_QUOTE_HEADER_ID: ' || P_QUOTE_HEADER_ID, 1, 'Y');
1010: END IF;
1011:

Line 1008: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Enable_Buttons: P_RESOURCE_ID: ' || P_RESOURCE_ID, 1, 'Y');

1004: aso_debug_pub.add('ASO_DEAL_PUB: ****** Start of Get_Deal_Enable_Buttons API ******', 1, 'Y');
1005: END IF;
1006:
1007: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1008: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Enable_Buttons: P_RESOURCE_ID: ' || P_RESOURCE_ID, 1, 'Y');
1009: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Enable_Buttons: P_QUOTE_HEADER_ID: ' || P_QUOTE_HEADER_ID, 1, 'Y');
1010: END IF;
1011:
1012: -- Getting quote header Details

Line 1009: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Enable_Buttons: P_QUOTE_HEADER_ID: ' || P_QUOTE_HEADER_ID, 1, 'Y');

1005: END IF;
1006:
1007: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1008: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Enable_Buttons: P_RESOURCE_ID: ' || P_RESOURCE_ID, 1, 'Y');
1009: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Enable_Buttons: P_QUOTE_HEADER_ID: ' || P_QUOTE_HEADER_ID, 1, 'Y');
1010: END IF;
1011:
1012: -- Getting quote header Details
1013: SELECT nvl(max_version_flag,'N'), price_request_id, nvl(pricing_status_indicator,'C'),quote_number

Line 1021: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Enable_Buttons: Access level returned by ASO_SECURITY_INT: ' || l_access_level, 1, 'Y');

1017:
1018: -- Getting the user level access
1019: l_access_level:=ASO_SECURITY_INT.Get_Quote_Access (p_resource_id,l_quote_number);
1020:
1021: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Enable_Buttons: Access level returned by ASO_SECURITY_INT: ' || l_access_level, 1, 'Y');
1022:
1023: -- User has update access to quote. In case user has access level 'READ' or 'NONE' for the quote nothing needs to be done
1024: -- check additional conditions for max version, batch pricing, status
1025: IF l_access_level = 'UPDATE' then

Line 1036: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Enable_Buttons: l_access_level: ' || l_access_level, 1, 'Y');

1032: l_access_level:= 'READ';
1033: end if;
1034: END IF;
1035:
1036: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Enable_Buttons: l_access_level: ' || l_access_level, 1, 'Y');
1037:
1038: -- End of API body
1039: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1040: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Enable_Buttons: End of API body', 1, 'Y');

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

1035:
1036: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Enable_Buttons: l_access_level: ' || l_access_level, 1, 'Y');
1037:
1038: -- End of API body
1039: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1040: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Enable_Buttons: End of API body', 1, 'Y');
1041: END IF;
1042:
1043:

Line 1040: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Enable_Buttons: End of API body', 1, 'Y');

1036: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Enable_Buttons: l_access_level: ' || l_access_level, 1, 'Y');
1037:
1038: -- End of API body
1039: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1040: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Enable_Buttons: End of API body', 1, 'Y');
1041: END IF;
1042:
1043:
1044: if l_access_level = 'UPDATE' then