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

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

110: px_req_line_tbl(1).LINE_INDEX := 1;
111: px_req_line_tbl(1).LINE_TYPE_CODE := 'ORDER';
112: px_req_line_tbl(1).CURRENCY_CODE := p_Header_rec.currency_code;
113: px_req_line_tbl(1).PRICE_FLAG := 'Y';
114: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
115: aso_debug_pub.add('ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE '
116: ||ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE,1,'N');
117: END IF;
118: /*FastTrak: Price effective date is assigned to the price frozen unless the price frozen date is null*/

Line 115: aso_debug_pub.add('ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE '

111: px_req_line_tbl(1).LINE_TYPE_CODE := 'ORDER';
112: px_req_line_tbl(1).CURRENCY_CODE := p_Header_rec.currency_code;
113: px_req_line_tbl(1).PRICE_FLAG := 'Y';
114: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
115: aso_debug_pub.add('ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE '
116: ||ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE,1,'N');
117: END IF;
118: /*FastTrak: Price effective date is assigned to the price frozen unless the price frozen date is null*/
119: if ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE = FND_API.G_MISS_DATE

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

121: px_req_line_tbl(1).PRICING_EFFECTIVE_DATE := trunc(sysdate);
122: else
123: px_req_line_tbl(1).PRICING_EFFECTIVE_DATE := trunc(ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE);
124: end if;
125: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
126: aso_debug_pub.add('Header Request copy: px_req_line_tbl(1).PRICING_EFFECTIVE_DATE '
127: ||px_req_line_tbl(1).PRICING_EFFECTIVE_DATE,1,'N');
128: END IF;
129: end copy_Header_to_request;

Line 126: aso_debug_pub.add('Header Request copy: px_req_line_tbl(1).PRICING_EFFECTIVE_DATE '

122: else
123: px_req_line_tbl(1).PRICING_EFFECTIVE_DATE := trunc(ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE);
124: end if;
125: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
126: aso_debug_pub.add('Header Request copy: px_req_line_tbl(1).PRICING_EFFECTIVE_DATE '
127: ||px_req_line_tbl(1).PRICING_EFFECTIVE_DATE,1,'N');
128: END IF;
129: end copy_Header_to_request;
130:

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

169: l_req_line_rec.UOM_QUANTITY := p_line_dtl_rec.service_duration * l_uom_rate;
170: End If;
171: End If;
172: -- Change for manual discount updating UPDATED_ADJUSTED_UNIT_PRICE
173: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
174: aso_debug_pub.add('In Copy line to req p_Line_rec.SELLING_PRICE_CHANGE '
175: ||p_Line_rec.SELLING_PRICE_CHANGE,1,'Y');
176: END IF;
177: If p_Line_rec.SELLING_PRICE_CHANGE = 'Y' then

Line 174: aso_debug_pub.add('In Copy line to req p_Line_rec.SELLING_PRICE_CHANGE '

170: End If;
171: End If;
172: -- Change for manual discount updating UPDATED_ADJUSTED_UNIT_PRICE
173: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
174: aso_debug_pub.add('In Copy line to req p_Line_rec.SELLING_PRICE_CHANGE '
175: ||p_Line_rec.SELLING_PRICE_CHANGE,1,'Y');
176: END IF;
177: If p_Line_rec.SELLING_PRICE_CHANGE = 'Y' then
178: l_req_line_rec.UPDATED_ADJUSTED_UNIT_PRICE := p_Line_rec.line_quote_price;

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

184: l_req_line_rec.PRICING_EFFECTIVE_DATE := trunc(sysdate);
185: else
186: l_req_line_rec.PRICING_EFFECTIVE_DATE := trunc(ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE);
187: end if;
188: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
189: aso_debug_pub.add('copy line request: l_req_line_rec.PRICING_EFFECTIVE_DATE '
190: ||l_req_line_rec.PRICING_EFFECTIVE_DATE,1,'N');
191: aso_debug_pub.add('ASO_PRICING_CALLBACK_PVT:copy line request: p_Line_rec.CHARGE_PERIODICITY_CODE '
192: ||p_Line_rec.CHARGE_PERIODICITY_CODE,1,'N');

Line 189: aso_debug_pub.add('copy line request: l_req_line_rec.PRICING_EFFECTIVE_DATE '

185: else
186: l_req_line_rec.PRICING_EFFECTIVE_DATE := trunc(ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE);
187: end if;
188: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
189: aso_debug_pub.add('copy line request: l_req_line_rec.PRICING_EFFECTIVE_DATE '
190: ||l_req_line_rec.PRICING_EFFECTIVE_DATE,1,'N');
191: aso_debug_pub.add('ASO_PRICING_CALLBACK_PVT:copy line request: p_Line_rec.CHARGE_PERIODICITY_CODE '
192: ||p_Line_rec.CHARGE_PERIODICITY_CODE,1,'N');
193: END IF;

Line 191: aso_debug_pub.add('ASO_PRICING_CALLBACK_PVT:copy line request: p_Line_rec.CHARGE_PERIODICITY_CODE '

187: end if;
188: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
189: aso_debug_pub.add('copy line request: l_req_line_rec.PRICING_EFFECTIVE_DATE '
190: ||l_req_line_rec.PRICING_EFFECTIVE_DATE,1,'N');
191: aso_debug_pub.add('ASO_PRICING_CALLBACK_PVT:copy line request: p_Line_rec.CHARGE_PERIODICITY_CODE '
192: ||p_Line_rec.CHARGE_PERIODICITY_CODE,1,'N');
193: END IF;
194: l_req_line_rec.CHARGE_PERIODICITY_CODE := p_Line_rec.CHARGE_PERIODICITY_CODE;
195:

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

301:
302:
303:
304: BEGIN
305: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
306: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT: Validate_Pricing_Order Starts',1,'N');
307: END IF;
308: -- Standard Start of API savepoint
309: SAVEPOINT PRICING_ORDER_PVT;

Line 306: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT: Validate_Pricing_Order Starts',1,'N');

302:
303:
304: BEGIN
305: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
306: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT: Validate_Pricing_Order Starts',1,'N');
307: END IF;
308: -- Standard Start of API savepoint
309: SAVEPOINT PRICING_ORDER_PVT;
310:

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

319:
320: -- Initialize message list if p_init_msg_list is set to TRUE.
321: IF FND_API.to_Boolean( p_init_msg_list )
322: THEN
323: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
324: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:Begin FND_API.to_Boolean'||p_init_msg_list, 1, 'Y');
325: END IF;
326: FND_MSG_PUB.initialize;
327: END IF;

Line 324: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:Begin FND_API.to_Boolean'||p_init_msg_list, 1, 'Y');

320: -- Initialize message list if p_init_msg_list is set to TRUE.
321: IF FND_API.to_Boolean( p_init_msg_list )
322: THEN
323: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
324: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:Begin FND_API.to_Boolean'||p_init_msg_list, 1, 'Y');
325: END IF;
326: FND_MSG_PUB.initialize;
327: END IF;
328:

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

326: FND_MSG_PUB.initialize;
327: END IF;
328:
329: x_return_status := FND_API.G_RET_STS_SUCCESS;
330: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
331: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:p_control_rec.request_type:'
332: ||p_control_rec.request_type,1,'N');
333: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:p_control_rec.pricing_event:'
334: ||p_control_rec.pricing_event,1,'N');

Line 331: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:p_control_rec.request_type:'

327: END IF;
328:
329: x_return_status := FND_API.G_RET_STS_SUCCESS;
330: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
331: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:p_control_rec.request_type:'
332: ||p_control_rec.request_type,1,'N');
333: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:p_control_rec.pricing_event:'
334: ||p_control_rec.pricing_event,1,'N');
335: END IF;

Line 333: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:p_control_rec.pricing_event:'

329: x_return_status := FND_API.G_RET_STS_SUCCESS;
330: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
331: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:p_control_rec.request_type:'
332: ||p_control_rec.request_type,1,'N');
333: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:p_control_rec.pricing_event:'
334: ||p_control_rec.pricing_event,1,'N');
335: END IF;
336: l_request_type := p_control_rec.request_type;
337: l_pricing_event := p_control_rec.pricing_event;

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

340: p_qte_header_rec => p_qte_header_rec,
341: p_shipment_rec => p_hd_shipment_rec);
342:
343: /*Debug msgs to check the value of global header record elements passed into pricing order*/
344: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
345: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:QP_ATTR_MAPPING_PUB.Build_Contexts Starts',1,'Y');
346: END IF;
347: QP_ATTR_MAPPING_PUB.Build_Contexts (
348: P_REQUEST_TYPE_CODE => l_request_type,

Line 345: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:QP_ATTR_MAPPING_PUB.Build_Contexts Starts',1,'Y');

341: p_shipment_rec => p_hd_shipment_rec);
342:
343: /*Debug msgs to check the value of global header record elements passed into pricing order*/
344: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
345: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:QP_ATTR_MAPPING_PUB.Build_Contexts Starts',1,'Y');
346: END IF;
347: QP_ATTR_MAPPING_PUB.Build_Contexts (
348: P_REQUEST_TYPE_CODE => l_request_type,
349: P_PRICING_TYPE => 'H',

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

348: P_REQUEST_TYPE_CODE => l_request_type,
349: P_PRICING_TYPE => 'H',
350: X_PRICE_CONTEXTS_RESULT_TBL => l_hd_pricing_contexts_tbl,
351: X_QUAL_CONTEXTS_RESULT_TBL => l_hd_qual_contexts_tbl);
352: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
353: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:QP_ATTR_MAPPING_PUB.Build_Contexts Ends',1,'Y');
354: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:Copy_Attribs_To_Req Starts',1,'Y');
355: END IF;
356:

Line 353: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:QP_ATTR_MAPPING_PUB.Build_Contexts Ends',1,'Y');

349: P_PRICING_TYPE => 'H',
350: X_PRICE_CONTEXTS_RESULT_TBL => l_hd_pricing_contexts_tbl,
351: X_QUAL_CONTEXTS_RESULT_TBL => l_hd_qual_contexts_tbl);
352: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
353: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:QP_ATTR_MAPPING_PUB.Build_Contexts Ends',1,'Y');
354: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:Copy_Attribs_To_Req Starts',1,'Y');
355: END IF;
356:
357: Copy_Attribs_To_Req (

Line 354: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:Copy_Attribs_To_Req Starts',1,'Y');

350: X_PRICE_CONTEXTS_RESULT_TBL => l_hd_pricing_contexts_tbl,
351: X_QUAL_CONTEXTS_RESULT_TBL => l_hd_qual_contexts_tbl);
352: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
353: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:QP_ATTR_MAPPING_PUB.Build_Contexts Ends',1,'Y');
354: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:Copy_Attribs_To_Req Starts',1,'Y');
355: END IF;
356:
357: Copy_Attribs_To_Req (
358: p_line_index => 1,

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

359: p_pricing_contexts_tbl => l_hd_pricing_contexts_tbl,
360: p_qualifier_contexts_tbl => l_hd_qual_contexts_tbl,
361: px_req_line_attr_tbl => l_req_line_attr_tbl,
362: px_req_qual_tbl => l_req_qual_tbl);
363: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
364: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:Copy_Attribs_To_Req Ends',1,'Y');
365: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:Copy_Header_To_Request Starts',1,'Y');
366: END IF;
367:

Line 364: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:Copy_Attribs_To_Req Ends',1,'Y');

360: p_qualifier_contexts_tbl => l_hd_qual_contexts_tbl,
361: px_req_line_attr_tbl => l_req_line_attr_tbl,
362: px_req_qual_tbl => l_req_qual_tbl);
363: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
364: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:Copy_Attribs_To_Req Ends',1,'Y');
365: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:Copy_Header_To_Request Starts',1,'Y');
366: END IF;
367:
368: Copy_Header_To_Request(

Line 365: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:Copy_Header_To_Request Starts',1,'Y');

361: px_req_line_attr_tbl => l_req_line_attr_tbl,
362: px_req_qual_tbl => l_req_qual_tbl);
363: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
364: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:Copy_Attribs_To_Req Ends',1,'Y');
365: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:Copy_Header_To_Request Starts',1,'Y');
366: END IF;
367:
368: Copy_Header_To_Request(
369: p_Request_Type => l_request_type,

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

369: p_Request_Type => l_request_type,
370: p_pricing_event => l_pricing_event,
371: p_header_rec => p_qte_header_rec,
372: px_req_line_tbl => l_Req_line_tbl);
373: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
374: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:Copy_Header_To_Request Ends',1,'Y');
375: aso_debug_pub.add('p_qte_header_rec.quote_header_id:'||p_qte_header_rec.quote_header_id,1,'N');
376: END IF;
377:

Line 374: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:Copy_Header_To_Request Ends',1,'Y');

370: p_pricing_event => l_pricing_event,
371: p_header_rec => p_qte_header_rec,
372: px_req_line_tbl => l_Req_line_tbl);
373: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
374: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:Copy_Header_To_Request Ends',1,'Y');
375: aso_debug_pub.add('p_qte_header_rec.quote_header_id:'||p_qte_header_rec.quote_header_id,1,'N');
376: END IF;
377:
378: If p_qte_line_tbl.count = 0 then

Line 375: aso_debug_pub.add('p_qte_header_rec.quote_header_id:'||p_qte_header_rec.quote_header_id,1,'N');

371: p_header_rec => p_qte_header_rec,
372: px_req_line_tbl => l_Req_line_tbl);
373: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
374: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:Copy_Header_To_Request Ends',1,'Y');
375: aso_debug_pub.add('p_qte_header_rec.quote_header_id:'||p_qte_header_rec.quote_header_id,1,'N');
376: END IF;
377:
378: If p_qte_line_tbl.count = 0 then
379: l_qte_line_tbl := ASO_UTILITY_PVT.Query_Qte_Line_Rows(p_qte_header_rec.quote_header_id);

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

380: Else
381: l_qte_line_tbl := p_qte_line_tbl;
382: End If;
383:
384: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
385: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:l_qte_line_tbl.count'|| l_qte_line_tbl.count, 1, 'N');
386: END IF;
387: If l_qte_line_tbl.count > 0 Then
388: FOR i IN 1..l_qte_line_tbl.count LOOP

Line 385: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:l_qte_line_tbl.count'|| l_qte_line_tbl.count, 1, 'N');

381: l_qte_line_tbl := p_qte_line_tbl;
382: End If;
383:
384: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
385: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:l_qte_line_tbl.count'|| l_qte_line_tbl.count, 1, 'N');
386: END IF;
387: If l_qte_line_tbl.count > 0 Then
388: FOR i IN 1..l_qte_line_tbl.count LOOP
389: /*We store the line_index in quote_line_id before building the l_req_line_tbl */

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

395: l_qte_line_id := l_qte_line_tbl(i).quote_line_id;
396: /*Save a copy of the record to a different table before defaulting*/
397: lx_qte_line_tbl(i) := l_qte_line_tbl(i);
398:
399: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
400: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT: l_qte_line_id:'||nvl(l_qte_line_id,0),1,'N');
401: END IF;
402:
403: /* Default header_level currency_code and price list id to line level*/

Line 400: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT: l_qte_line_id:'||nvl(l_qte_line_id,0),1,'N');

396: /*Save a copy of the record to a different table before defaulting*/
397: lx_qte_line_tbl(i) := l_qte_line_tbl(i);
398:
399: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
400: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT: l_qte_line_id:'||nvl(l_qte_line_id,0),1,'N');
401: END IF;
402:
403: /* Default header_level currency_code and price list id to line level*/
404: l_qte_line_tbl(i).currency_code := p_qte_header_rec.currency_code;

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

427: l_shipment_rec := l_shipment_tbl(1);
428: END IF;
429: End If;--If l_call_flg = 'Q' then
430:
431: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
432: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:Begin Setting up the G_LINE_REC', 1, 'Y');
433: END IF;
434: ASO_PRICING_INT.G_LINE_REC := ASO_PRICING_CORE_PVT.Set_Global_Rec (
435: p_qte_line_rec => l_qte_line_tbl(i),

Line 432: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:Begin Setting up the G_LINE_REC', 1, 'Y');

428: END IF;
429: End If;--If l_call_flg = 'Q' then
430:
431: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
432: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:Begin Setting up the G_LINE_REC', 1, 'Y');
433: END IF;
434: ASO_PRICING_INT.G_LINE_REC := ASO_PRICING_CORE_PVT.Set_Global_Rec (
435: p_qte_line_rec => l_qte_line_tbl(i),
436: p_qte_line_dtl_rec => l_qte_line_dtl_rec,

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

434: ASO_PRICING_INT.G_LINE_REC := ASO_PRICING_CORE_PVT.Set_Global_Rec (
435: p_qte_line_rec => l_qte_line_tbl(i),
436: p_qte_line_dtl_rec => l_qte_line_dtl_rec,
437: p_shipment_rec => l_shipment_rec);
438: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
439: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:End Setting up the G_LINE_REC', 1, 'Y');
440: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:Begin Setting up the Line Build_Contexts', 1, 'Y');
441: END IF;
442: QP_ATTR_MAPPING_PUB.Build_Contexts (

Line 439: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:End Setting up the G_LINE_REC', 1, 'Y');

435: p_qte_line_rec => l_qte_line_tbl(i),
436: p_qte_line_dtl_rec => l_qte_line_dtl_rec,
437: p_shipment_rec => l_shipment_rec);
438: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
439: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:End Setting up the G_LINE_REC', 1, 'Y');
440: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:Begin Setting up the Line Build_Contexts', 1, 'Y');
441: END IF;
442: QP_ATTR_MAPPING_PUB.Build_Contexts (
443: P_REQUEST_TYPE_CODE => l_request_type,

Line 440: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:Begin Setting up the Line Build_Contexts', 1, 'Y');

436: p_qte_line_dtl_rec => l_qte_line_dtl_rec,
437: p_shipment_rec => l_shipment_rec);
438: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
439: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:End Setting up the G_LINE_REC', 1, 'Y');
440: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:Begin Setting up the Line Build_Contexts', 1, 'Y');
441: END IF;
442: QP_ATTR_MAPPING_PUB.Build_Contexts (
443: P_REQUEST_TYPE_CODE => l_request_type,
444: P_PRICING_TYPE => 'L',

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

443: P_REQUEST_TYPE_CODE => l_request_type,
444: P_PRICING_TYPE => 'L',
445: X_PRICE_CONTEXTS_RESULT_TBL => l_pricing_contexts_tbl,
446: X_QUAL_CONTEXTS_RESULT_TBL => l_qual_contexts_tbl);
447: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
448: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:End Setting up the Line Build_Contexts', 1, 'Y');
449: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:Begin Setting up the Copy_Attribs_To_Req', 1, 'Y');
450: END IF;
451: Copy_Attribs_To_Req (

Line 448: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:End Setting up the Line Build_Contexts', 1, 'Y');

444: P_PRICING_TYPE => 'L',
445: X_PRICE_CONTEXTS_RESULT_TBL => l_pricing_contexts_tbl,
446: X_QUAL_CONTEXTS_RESULT_TBL => l_qual_contexts_tbl);
447: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
448: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:End Setting up the Line Build_Contexts', 1, 'Y');
449: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:Begin Setting up the Copy_Attribs_To_Req', 1, 'Y');
450: END IF;
451: Copy_Attribs_To_Req (
452: p_line_index => i+1,

Line 449: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:Begin Setting up the Copy_Attribs_To_Req', 1, 'Y');

445: X_PRICE_CONTEXTS_RESULT_TBL => l_pricing_contexts_tbl,
446: X_QUAL_CONTEXTS_RESULT_TBL => l_qual_contexts_tbl);
447: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
448: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:End Setting up the Line Build_Contexts', 1, 'Y');
449: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:Begin Setting up the Copy_Attribs_To_Req', 1, 'Y');
450: END IF;
451: Copy_Attribs_To_Req (
452: p_line_index => i+1,
453: p_pricing_contexts_tbl => l_pricing_contexts_tbl,

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

453: p_pricing_contexts_tbl => l_pricing_contexts_tbl,
454: p_qualifier_contexts_tbl => l_qual_contexts_tbl,
455: px_req_line_attr_tbl => l_req_line_attr_tbl,
456: px_req_qual_tbl => l_req_qual_tbl);
457: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
458: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:End Setting up the Copy_Attribs_To_Req', 1, 'Y');
459: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:Begin Setting up the Copy_hdr_attr_to_line', 1, 'Y');
460: END IF;
461: Copy_hdr_attr_to_line (

Line 458: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:End Setting up the Copy_Attribs_To_Req', 1, 'Y');

454: p_qualifier_contexts_tbl => l_qual_contexts_tbl,
455: px_req_line_attr_tbl => l_req_line_attr_tbl,
456: px_req_qual_tbl => l_req_qual_tbl);
457: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
458: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:End Setting up the Copy_Attribs_To_Req', 1, 'Y');
459: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:Begin Setting up the Copy_hdr_attr_to_line', 1, 'Y');
460: END IF;
461: Copy_hdr_attr_to_line (
462: p_line_index => i+1,

Line 459: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:Begin Setting up the Copy_hdr_attr_to_line', 1, 'Y');

455: px_req_line_attr_tbl => l_req_line_attr_tbl,
456: px_req_qual_tbl => l_req_qual_tbl);
457: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
458: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:End Setting up the Copy_Attribs_To_Req', 1, 'Y');
459: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:Begin Setting up the Copy_hdr_attr_to_line', 1, 'Y');
460: END IF;
461: Copy_hdr_attr_to_line (
462: p_line_index => i+1,
463: p_pricing_contexts_tbl => l_hd_pricing_contexts_tbl,

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

463: p_pricing_contexts_tbl => l_hd_pricing_contexts_tbl,
464: p_qualifier_contexts_tbl => l_hd_qual_contexts_tbl,
465: px_req_line_attr_tbl => l_req_line_attr_tbl,
466: px_req_qual_tbl => l_req_qual_tbl);
467: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
468: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:End Setting up the Copy_hdr_attr_to_line', 1, 'Y');
469: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:Begin Setting up the Copy_Line_To_Request', 1, 'Y');
470: END IF;
471: Copy_Line_To_Request(

Line 468: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:End Setting up the Copy_hdr_attr_to_line', 1, 'Y');

464: p_qualifier_contexts_tbl => l_hd_qual_contexts_tbl,
465: px_req_line_attr_tbl => l_req_line_attr_tbl,
466: px_req_qual_tbl => l_req_qual_tbl);
467: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
468: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:End Setting up the Copy_hdr_attr_to_line', 1, 'Y');
469: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:Begin Setting up the Copy_Line_To_Request', 1, 'Y');
470: END IF;
471: Copy_Line_To_Request(
472: p_Request_Type => l_request_type,

Line 469: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:Begin Setting up the Copy_Line_To_Request', 1, 'Y');

465: px_req_line_attr_tbl => l_req_line_attr_tbl,
466: px_req_qual_tbl => l_req_qual_tbl);
467: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
468: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:End Setting up the Copy_hdr_attr_to_line', 1, 'Y');
469: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:Begin Setting up the Copy_Line_To_Request', 1, 'Y');
470: END IF;
471: Copy_Line_To_Request(
472: p_Request_Type => l_request_type,
473: p_pricing_event => l_pricing_event,

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

474: p_line_rec => l_qte_line_tbl(i),
475: p_line_dtl_rec => l_qte_line_dtl_rec,
476: p_control_rec => p_control_rec,
477: px_req_line_tbl => l_Req_line_tbl);
478: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
479: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:End Setting up the Copy_Line_To_Request', 1, 'Y');
480: END IF;
481:
482: /*Keeping track of indexes for service processing*/

Line 479: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:End Setting up the Copy_Line_To_Request', 1, 'Y');

475: p_line_dtl_rec => l_qte_line_dtl_rec,
476: p_control_rec => p_control_rec,
477: px_req_line_tbl => l_Req_line_tbl);
478: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
479: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:End Setting up the Copy_Line_To_Request', 1, 'Y');
480: END IF;
481:
482: /*Keeping track of indexes for service processing*/
483: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

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

479: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:End Setting up the Copy_Line_To_Request', 1, 'Y');
480: END IF;
481:
482: /*Keeping track of indexes for service processing*/
483: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
484: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:serviceable_product_flag:'
485: ||l_qte_line_tbl(i).serviceable_product_flag,1,'Y');
486: END IF;
487: If l_qte_line_tbl(i).serviceable_product_flag = 'Y' then

Line 484: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:serviceable_product_flag:'

480: END IF;
481:
482: /*Keeping track of indexes for service processing*/
483: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
484: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:serviceable_product_flag:'
485: ||l_qte_line_tbl(i).serviceable_product_flag,1,'Y');
486: END IF;
487: If l_qte_line_tbl(i).serviceable_product_flag = 'Y' then
488: l_qte_line_prcd_parent(l_qte_line_id) := i;

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

487: If l_qte_line_tbl(i).serviceable_product_flag = 'Y' then
488: l_qte_line_prcd_parent(l_qte_line_id) := i;
489: end if;
490: /*Assuming l_qte_line_tbl is the p_qte_line_tbl and data is always passed in the PL/SQL table*/
491: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
492: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:service_item_flag:'
493: ||l_qte_line_tbl(i).service_item_flag,1,'Y');
494: END IF;
495: If l_qte_line_tbl(i).service_item_flag = 'Y' then

Line 492: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:service_item_flag:'

488: l_qte_line_prcd_parent(l_qte_line_id) := i;
489: end if;
490: /*Assuming l_qte_line_tbl is the p_qte_line_tbl and data is always passed in the PL/SQL table*/
491: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
492: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:service_item_flag:'
493: ||l_qte_line_tbl(i).service_item_flag,1,'Y');
494: END IF;
495: If l_qte_line_tbl(i).service_item_flag = 'Y' then
496: l_qte_line_prcd_child(l_qte_line_id):= i;

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

499: END LOOP; --main End loop FOR i IN 1..l_qte_line_tbl.count
500:
501: /*Build relationship table: Only support Current quote*/
502: If l_srv_line_dtl_tbl.count > 0 then
503: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
504: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:l_srv_line_dtl_tbl.count:'
505: ||l_srv_line_dtl_tbl.count,1,'Y');
506: END IF;
507: For j in 1..l_srv_line_dtl_tbl.count loop

Line 504: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:l_srv_line_dtl_tbl.count:'

500:
501: /*Build relationship table: Only support Current quote*/
502: If l_srv_line_dtl_tbl.count > 0 then
503: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
504: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:l_srv_line_dtl_tbl.count:'
505: ||l_srv_line_dtl_tbl.count,1,'Y');
506: END IF;
507: For j in 1..l_srv_line_dtl_tbl.count loop
508: If (l_srv_line_dtl_tbl(j).SERVICE_REF_LINE_ID IS NOT NULL

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

506: END IF;
507: For j in 1..l_srv_line_dtl_tbl.count loop
508: If (l_srv_line_dtl_tbl(j).SERVICE_REF_LINE_ID IS NOT NULL
509: OR l_srv_line_dtl_tbl(j).SERVICE_REF_LINE_ID <> FND_API.G_MISS_NUM) Then
510: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
511: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:quote line id:'||l_srv_line_dtl_tbl(j).quote_line_id,1,'Y');
512: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:service ref line id:'||l_srv_line_dtl_tbl(j).service_ref_line_id,1,'Y');
513: END IF;
514: l_req_related_lines_tbl(j).line_index := l_qte_line_prcd_parent(l_srv_line_dtl_tbl(j).service_ref_line_id)+1;

Line 511: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:quote line id:'||l_srv_line_dtl_tbl(j).quote_line_id,1,'Y');

507: For j in 1..l_srv_line_dtl_tbl.count loop
508: If (l_srv_line_dtl_tbl(j).SERVICE_REF_LINE_ID IS NOT NULL
509: OR l_srv_line_dtl_tbl(j).SERVICE_REF_LINE_ID <> FND_API.G_MISS_NUM) Then
510: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
511: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:quote line id:'||l_srv_line_dtl_tbl(j).quote_line_id,1,'Y');
512: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:service ref line id:'||l_srv_line_dtl_tbl(j).service_ref_line_id,1,'Y');
513: END IF;
514: l_req_related_lines_tbl(j).line_index := l_qte_line_prcd_parent(l_srv_line_dtl_tbl(j).service_ref_line_id)+1;
515: l_req_related_lines_tbl(j).LINE_DETAIL_INDEX := 0;

Line 512: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:service ref line id:'||l_srv_line_dtl_tbl(j).service_ref_line_id,1,'Y');

508: If (l_srv_line_dtl_tbl(j).SERVICE_REF_LINE_ID IS NOT NULL
509: OR l_srv_line_dtl_tbl(j).SERVICE_REF_LINE_ID <> FND_API.G_MISS_NUM) Then
510: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
511: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:quote line id:'||l_srv_line_dtl_tbl(j).quote_line_id,1,'Y');
512: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:service ref line id:'||l_srv_line_dtl_tbl(j).service_ref_line_id,1,'Y');
513: END IF;
514: l_req_related_lines_tbl(j).line_index := l_qte_line_prcd_parent(l_srv_line_dtl_tbl(j).service_ref_line_id)+1;
515: l_req_related_lines_tbl(j).LINE_DETAIL_INDEX := 0;
516: l_req_related_lines_tbl(j).RELATED_LINE_INDEX := l_qte_line_prcd_child(l_srv_line_dtl_tbl(j).quote_line_id)+1;

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

515: l_req_related_lines_tbl(j).LINE_DETAIL_INDEX := 0;
516: l_req_related_lines_tbl(j).RELATED_LINE_INDEX := l_qte_line_prcd_child(l_srv_line_dtl_tbl(j).quote_line_id)+1;
517: l_req_related_lines_tbl(j).RELATED_LINE_DETAIL_INDEX := 0;
518: l_req_related_lines_tbl(j).RELATIONSHIP_TYPE_CODE :=QP_PREQ_GRP.G_SERVICE_LINE;
519: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
520: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:line_index :'
521: ||l_req_related_lines_tbl(j).line_index, 1, 'Y');
522: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:related line_index: '
523: ||l_req_related_lines_tbl(j).RELATED_LINE_INDEX , 1, 'Y');

Line 520: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:line_index :'

516: l_req_related_lines_tbl(j).RELATED_LINE_INDEX := l_qte_line_prcd_child(l_srv_line_dtl_tbl(j).quote_line_id)+1;
517: l_req_related_lines_tbl(j).RELATED_LINE_DETAIL_INDEX := 0;
518: l_req_related_lines_tbl(j).RELATIONSHIP_TYPE_CODE :=QP_PREQ_GRP.G_SERVICE_LINE;
519: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
520: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:line_index :'
521: ||l_req_related_lines_tbl(j).line_index, 1, 'Y');
522: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:related line_index: '
523: ||l_req_related_lines_tbl(j).RELATED_LINE_INDEX , 1, 'Y');
524: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:RELATIONSHIP TYPE CODE: '

Line 522: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:related line_index: '

518: l_req_related_lines_tbl(j).RELATIONSHIP_TYPE_CODE :=QP_PREQ_GRP.G_SERVICE_LINE;
519: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
520: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:line_index :'
521: ||l_req_related_lines_tbl(j).line_index, 1, 'Y');
522: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:related line_index: '
523: ||l_req_related_lines_tbl(j).RELATED_LINE_INDEX , 1, 'Y');
524: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:RELATIONSHIP TYPE CODE: '
525: ||l_req_related_lines_tbl(j).RELATIONSHIP_TYPE_CODE, 1, 'Y');
526: END IF;

Line 524: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:RELATIONSHIP TYPE CODE: '

520: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:line_index :'
521: ||l_req_related_lines_tbl(j).line_index, 1, 'Y');
522: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:related line_index: '
523: ||l_req_related_lines_tbl(j).RELATED_LINE_INDEX , 1, 'Y');
524: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:RELATIONSHIP TYPE CODE: '
525: ||l_req_related_lines_tbl(j).RELATIONSHIP_TYPE_CODE, 1, 'Y');
526: END IF;
527: END IF; --l_srv_line_dtl_tbl(j).SERVICE_REF_LINE_ID IS NOT NULL
528: End Loop;

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

536: l_control_rec.source_order_amount_flag := 'Y';
537: l_control_rec.GSA_CHECK_FLAG := 'Y';
538: l_control_rec.GSA_DUP_CHECK_FLAG := 'Y';
539:
540: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
541: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:Start of QP_PREQ_PUB.PRICE_REQUEST', 1, 'Y');
542: END IF;
543:
544: /* Change for populating QP_PREQ_GRP.CONTROL_RECORD_TYPE.ORG_ID Yogeshwar (MOAC) */

Line 541: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:Start of QP_PREQ_PUB.PRICE_REQUEST', 1, 'Y');

537: l_control_rec.GSA_CHECK_FLAG := 'Y';
538: l_control_rec.GSA_DUP_CHECK_FLAG := 'Y';
539:
540: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
541: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:Start of QP_PREQ_PUB.PRICE_REQUEST', 1, 'Y');
542: END IF;
543:
544: /* Change for populating QP_PREQ_GRP.CONTROL_RECORD_TYPE.ORG_ID Yogeshwar (MOAC) */
545:

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

576: x_line_detail_attr_tbl => lx_req_line_detail_attr_tbl,
577: x_related_lines_tbl => lx_req_related_lines_tbl,
578: x_return_status => l_return_status,
579: x_return_status_text => l_return_status_text);
580: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
581: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:End of QP_PREQ_PUB.PRICE_REQUEST', 1, 'Y');
582: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:After PRICE_REQUEST l_return_status:'
583: ||l_return_status, 1, 'Y');
584: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:After PRICE_REQUEST l_return_status_text '

Line 581: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:End of QP_PREQ_PUB.PRICE_REQUEST', 1, 'Y');

577: x_related_lines_tbl => lx_req_related_lines_tbl,
578: x_return_status => l_return_status,
579: x_return_status_text => l_return_status_text);
580: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
581: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:End of QP_PREQ_PUB.PRICE_REQUEST', 1, 'Y');
582: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:After PRICE_REQUEST l_return_status:'
583: ||l_return_status, 1, 'Y');
584: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:After PRICE_REQUEST l_return_status_text '
585: ||l_return_status_text,1,'N');

Line 582: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:After PRICE_REQUEST l_return_status:'

578: x_return_status => l_return_status,
579: x_return_status_text => l_return_status_text);
580: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
581: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:End of QP_PREQ_PUB.PRICE_REQUEST', 1, 'Y');
582: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:After PRICE_REQUEST l_return_status:'
583: ||l_return_status, 1, 'Y');
584: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:After PRICE_REQUEST l_return_status_text '
585: ||l_return_status_text,1,'N');
586: END IF;

Line 584: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:After PRICE_REQUEST l_return_status_text '

580: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
581: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:End of QP_PREQ_PUB.PRICE_REQUEST', 1, 'Y');
582: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:After PRICE_REQUEST l_return_status:'
583: ||l_return_status, 1, 'Y');
584: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:After PRICE_REQUEST l_return_status_text '
585: ||l_return_status_text,1,'N');
586: END IF;
587:
588: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

596: */
597: ASO_PRICING_INT.G_LINE_REC := NULL;
598: ASO_PRICING_INT.G_HEADER_REC := NULL;
599: /*Returning the same table back to the caller*/
600: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
601: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT: After pricing call lx_qte_line_tbl.count:'
602: ||nvl(lx_qte_line_tbl.count,0),1,'Y');
603: END IF;
604: x_qte_line_tbl := lx_qte_line_tbl;

Line 601: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT: After pricing call lx_qte_line_tbl.count:'

597: ASO_PRICING_INT.G_LINE_REC := NULL;
598: ASO_PRICING_INT.G_HEADER_REC := NULL;
599: /*Returning the same table back to the caller*/
600: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
601: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT: After pricing call lx_qte_line_tbl.count:'
602: ||nvl(lx_qte_line_tbl.count,0),1,'Y');
603: END IF;
604: x_qte_line_tbl := lx_qte_line_tbl;
605: /*In quote line table initialize the pricing_status_text to success*/

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

602: ||nvl(lx_qte_line_tbl.count,0),1,'Y');
603: END IF;
604: x_qte_line_tbl := lx_qte_line_tbl;
605: /*In quote line table initialize the pricing_status_text to success*/
606: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
607: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:x_qte_line_tbl.count:'||x_qte_line_tbl.count,1,'N');
608: END IF;
609: k := x_qte_line_tbl.FIRST;
610: While k is not null loop

Line 607: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:x_qte_line_tbl.count:'||x_qte_line_tbl.count,1,'N');

603: END IF;
604: x_qte_line_tbl := lx_qte_line_tbl;
605: /*In quote line table initialize the pricing_status_text to success*/
606: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
607: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:x_qte_line_tbl.count:'||x_qte_line_tbl.count,1,'N');
608: END IF;
609: k := x_qte_line_tbl.FIRST;
610: While k is not null loop
611: x_qte_line_tbl(k).pricing_status_code := FND_API.G_RET_STS_SUCCESS;

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

613: end loop;
614:
615: /*Update all the errored records*/
616: FOR C_status_code_rec in C_status_code LOOP
617: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
618: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT: C_status_code_rec.line_id:'
619: ||lx_req_line_rec.line_id,1,'N');
620: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT: C_status_code_rec.pricing_status_code:'
621: ||lx_req_line_rec.status_code,1,'N');

Line 618: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT: C_status_code_rec.line_id:'

614:
615: /*Update all the errored records*/
616: FOR C_status_code_rec in C_status_code LOOP
617: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
618: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT: C_status_code_rec.line_id:'
619: ||lx_req_line_rec.line_id,1,'N');
620: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT: C_status_code_rec.pricing_status_code:'
621: ||lx_req_line_rec.status_code,1,'N');
622: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT: C_status_code_rec.pricing_status_text:'

Line 620: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT: C_status_code_rec.pricing_status_code:'

616: FOR C_status_code_rec in C_status_code LOOP
617: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
618: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT: C_status_code_rec.line_id:'
619: ||lx_req_line_rec.line_id,1,'N');
620: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT: C_status_code_rec.pricing_status_code:'
621: ||lx_req_line_rec.status_code,1,'N');
622: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT: C_status_code_rec.pricing_status_text:'
623: ||lx_req_line_rec.status_text,1,'N');
624: END IF;

Line 622: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT: C_status_code_rec.pricing_status_text:'

618: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT: C_status_code_rec.line_id:'
619: ||lx_req_line_rec.line_id,1,'N');
620: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT: C_status_code_rec.pricing_status_code:'
621: ||lx_req_line_rec.status_code,1,'N');
622: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT: C_status_code_rec.pricing_status_text:'
623: ||lx_req_line_rec.status_text,1,'N');
624: END IF;
625:
626: /*For this line_id update the pricing_status_code in the x_qte_line_tbl*/

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

626: /*For this line_id update the pricing_status_code in the x_qte_line_tbl*/
627: j := x_qte_line_tbl.FIRST;
628: WHILE j IS NOT NULL LOOP
629: If C_status_code_rec.line_id = x_qte_line_tbl(j).quote_line_id then
630: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
631: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT: Updating the quote_line_id: '
632: ||x_qte_line_tbl(j).quote_line_id||' with status_code: '
633: ||FND_API.G_RET_STS_ERROR,1,'N');
634: END IF;

Line 631: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT: Updating the quote_line_id: '

627: j := x_qte_line_tbl.FIRST;
628: WHILE j IS NOT NULL LOOP
629: If C_status_code_rec.line_id = x_qte_line_tbl(j).quote_line_id then
630: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
631: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT: Updating the quote_line_id: '
632: ||x_qte_line_tbl(j).quote_line_id||' with status_code: '
633: ||FND_API.G_RET_STS_ERROR,1,'N');
634: END IF;
635: x_qte_line_tbl(j).pricing_status_code := FND_API.G_RET_STS_ERROR;

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

648: End If;
649:
650:
651: Else
652: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
653: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT: There are no quote lines for the price request validation',1,'N');
654: END IF;
655: End If; -- If l_qte_line_tbl.count > 0
656:

Line 653: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT: There are no quote lines for the price request validation',1,'N');

649:
650:
651: Else
652: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
653: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT: There are no quote lines for the price request validation',1,'N');
654: END IF;
655: End If; -- If l_qte_line_tbl.count > 0
656:
657:

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

667: );
668:
669: for l in 1 .. x_msg_count loop
670: x_msg_data := fnd_msg_pub.get( p_msg_index => l, p_encoded => 'F');
671: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
672: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:Messge count and get '||x_msg_data, 1, 'Y');
673: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:Messge count and get '||x_msg_count, 1, 'Y');
674: END IF;
675: end loop;

Line 672: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:Messge count and get '||x_msg_data, 1, 'Y');

668:
669: for l in 1 .. x_msg_count loop
670: x_msg_data := fnd_msg_pub.get( p_msg_index => l, p_encoded => 'F');
671: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
672: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:Messge count and get '||x_msg_data, 1, 'Y');
673: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:Messge count and get '||x_msg_count, 1, 'Y');
674: END IF;
675: end loop;
676:

Line 673: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:Messge count and get '||x_msg_count, 1, 'Y');

669: for l in 1 .. x_msg_count loop
670: x_msg_data := fnd_msg_pub.get( p_msg_index => l, p_encoded => 'F');
671: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
672: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:Messge count and get '||x_msg_data, 1, 'Y');
673: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:Messge count and get '||x_msg_count, 1, 'Y');
674: END IF;
675: end loop;
676:
677:

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

676:
677:
678: EXCEPTION
679: WHEN FND_API.G_EXC_ERROR THEN
680: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
681: aso_debug_pub.add('after inside EXCEPTION return status'||x_return_status, 1, 'Y');
682: END IF;
683: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
684: P_API_NAME => L_API_NAME

Line 681: aso_debug_pub.add('after inside EXCEPTION return status'||x_return_status, 1, 'Y');

677:
678: EXCEPTION
679: WHEN FND_API.G_EXC_ERROR THEN
680: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
681: aso_debug_pub.add('after inside EXCEPTION return status'||x_return_status, 1, 'Y');
682: END IF;
683: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
684: P_API_NAME => L_API_NAME
685: ,P_PKG_NAME => G_PKG_NAME