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_PRICING_CALLBACK_PVT dependencies on ASO_PRICING_CORE_PVT

Line 129: ASO_PRICING_INT.G_HEADER_REC := ASO_PRICING_CORE_PVT.Set_Global_Rec (

125: END IF;
126: l_request_type := p_control_rec.request_type;
127: l_pricing_event := p_control_rec.pricing_event;
128:
129: ASO_PRICING_INT.G_HEADER_REC := ASO_PRICING_CORE_PVT.Set_Global_Rec (
130: p_qte_header_rec => p_qte_header_rec,
131: p_shipment_rec => p_hd_shipment_rec);
132:
133: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 200: ASO_PRICING_INT.G_LINE_REC := ASO_PRICING_CORE_PVT.Set_Global_Rec (

196:
197: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
198: aso_debug_pub.add('ASO_PRICING_CALLBACK_PVT:Begin Setting up the G_LINE_REC', 1, 'Y');
199: END IF;
200: ASO_PRICING_INT.G_LINE_REC := ASO_PRICING_CORE_PVT.Set_Global_Rec (
201: p_qte_line_rec => l_qte_line_tbl(i),
202: p_qte_line_dtl_rec => l_qte_line_dtl_rec,
203: p_shipment_rec => l_shipment_rec);
204: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 3126: aso_debug_pub.add('ASO_PRICING_CORE_PVT:In Copy Req to line ',1,'Y');

3122: l_price_adj_prcd Index_Link_Tbl_Type;
3123: l_message_text VARCHAR2(2000);
3124: BEGIN
3125: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3126: aso_debug_pub.add('ASO_PRICING_CORE_PVT:In Copy Req to line ',1,'Y');
3127: END IF;
3128: i := p_req_line_tbl.FIRST;
3129: WHILE i IS NOT NULL LOOP
3130: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 3131: aso_debug_pub.add('ASO_PRICING_CORE_PVT:In Copy Req to line in while',1,'Y');

3127: END IF;
3128: i := p_req_line_tbl.FIRST;
3129: WHILE i IS NOT NULL LOOP
3130: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3131: aso_debug_pub.add('ASO_PRICING_CORE_PVT:In Copy Req to line in while',1,'Y');
3132: END IF;
3133: l_req_line_rec := p_req_line_tbl(i);
3134: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3135: aso_debug_pub.add('ASO_PRICING_CORE_PVT:In Copy Req to line l_req_line_rec.line_type_code'

Line 3135: aso_debug_pub.add('ASO_PRICING_CORE_PVT:In Copy Req to line l_req_line_rec.line_type_code'

3131: aso_debug_pub.add('ASO_PRICING_CORE_PVT:In Copy Req to line in while',1,'Y');
3132: END IF;
3133: l_req_line_rec := p_req_line_tbl(i);
3134: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3135: aso_debug_pub.add('ASO_PRICING_CORE_PVT:In Copy Req to line l_req_line_rec.line_type_code'
3136: ||l_req_line_rec.line_type_code,1,'Y');
3137: aso_debug_pub.add('ASO_PRICING_CORE_PVT:In Copy Req to line l_req_line_rec.status_code'
3138: ||l_req_line_rec.status_code,1,'Y');
3139: END IF;

Line 3137: aso_debug_pub.add('ASO_PRICING_CORE_PVT:In Copy Req to line l_req_line_rec.status_code'

3133: l_req_line_rec := p_req_line_tbl(i);
3134: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3135: aso_debug_pub.add('ASO_PRICING_CORE_PVT:In Copy Req to line l_req_line_rec.line_type_code'
3136: ||l_req_line_rec.line_type_code,1,'Y');
3137: aso_debug_pub.add('ASO_PRICING_CORE_PVT:In Copy Req to line l_req_line_rec.status_code'
3138: ||l_req_line_rec.status_code,1,'Y');
3139: END IF;
3140:
3141: IF l_req_line_rec.line_type_code = 'LINE' AND

Line 3148: aso_debug_pub.add('ASO_PRICING_CORE_PVT:In Copy Req to line in ELSEIF',1,'Y');

3144: QP_PREQ_GRP.G_STATUS_UNCHANGED)
3145:
3146: Then
3147: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3148: aso_debug_pub.add('ASO_PRICING_CORE_PVT:In Copy Req to line in ELSEIF',1,'Y');
3149: END IF;
3150: --IF l_req_line_rec.line_index = 1 THEN
3151: --l_qte_line_rec := p_qte_line_rec;
3152: --END IF;

Line 3158: aso_debug_pub.add('ASO_PRICING_CORE_PVT:In Copy Req to line line_list_price '

3154: l_qte_line_rec.line_quote_price :=
3155: NVL(l_req_line_rec.adjusted_unit_price, l_req_line_rec.unit_price);
3156: l_qte_line_rec.line_list_price := l_req_line_rec.unit_price ;
3157: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3158: aso_debug_pub.add('ASO_PRICING_CORE_PVT:In Copy Req to line line_list_price '
3159: ||l_qte_line_rec.line_list_price,1,'Y');
3160: END IF;
3161: l_qte_line_rec.line_adjusted_amount :=
3162: l_qte_line_rec.line_quote_price-l_qte_line_rec.line_list_price;

Line 3168: aso_debug_pub.add('ASO_PRICING_CORE_PVT:In Copy Req to line before price_list_id ',1,'Y');

3164: l_qte_line_rec.line_adjusted_percent :=
3165: (l_qte_line_rec.line_adjusted_amount/l_qte_line_rec.line_list_price)*100;
3166: END IF;
3167: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3168: aso_debug_pub.add('ASO_PRICING_CORE_PVT:In Copy Req to line before price_list_id ',1,'Y');
3169: END IF;
3170: l_qte_line_rec.quantity := l_req_line_rec.priced_quantity ;
3171: l_qte_line_rec.uom_code := l_req_line_rec.priced_uom_code ;
3172: --l_qte_line_rec.price_list_id := p_req_line_detail_tbl(1).list_header_id ;

Line 3174: aso_debug_pub.add('ASO_PRICING_CORE_PVT:In Copy Req to line after price_list_id ',1,'Y');

3170: l_qte_line_rec.quantity := l_req_line_rec.priced_quantity ;
3171: l_qte_line_rec.uom_code := l_req_line_rec.priced_uom_code ;
3172: --l_qte_line_rec.price_list_id := p_req_line_detail_tbl(1).list_header_id ;
3173: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3174: aso_debug_pub.add('ASO_PRICING_CORE_PVT:In Copy Req to line after price_list_id ',1,'Y');
3175: aso_debug_pub.add('ASO_PRICING_CORE_PVT:In Copy Req to line 11 ',1,'Y');
3176: END IF;
3177: --aso_debug_pub.add('ASO_PRICING_CORE_PVT:In Copy Req to line : Price List Id'||l_qte_line_rec.price_list_id,1,'Y');
3178: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 3175: aso_debug_pub.add('ASO_PRICING_CORE_PVT:In Copy Req to line 11 ',1,'Y');

3171: l_qte_line_rec.uom_code := l_req_line_rec.priced_uom_code ;
3172: --l_qte_line_rec.price_list_id := p_req_line_detail_tbl(1).list_header_id ;
3173: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3174: aso_debug_pub.add('ASO_PRICING_CORE_PVT:In Copy Req to line after price_list_id ',1,'Y');
3175: aso_debug_pub.add('ASO_PRICING_CORE_PVT:In Copy Req to line 11 ',1,'Y');
3176: END IF;
3177: --aso_debug_pub.add('ASO_PRICING_CORE_PVT:In Copy Req to line : Price List Id'||l_qte_line_rec.price_list_id,1,'Y');
3178: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3179: aso_debug_pub.add('ASO_PRICING_CORE_PVT:after Copy Req to line ',1,'Y');

Line 3177: --aso_debug_pub.add('ASO_PRICING_CORE_PVT:In Copy Req to line : Price List Id'||l_qte_line_rec.price_list_id,1,'Y');

3173: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3174: aso_debug_pub.add('ASO_PRICING_CORE_PVT:In Copy Req to line after price_list_id ',1,'Y');
3175: aso_debug_pub.add('ASO_PRICING_CORE_PVT:In Copy Req to line 11 ',1,'Y');
3176: END IF;
3177: --aso_debug_pub.add('ASO_PRICING_CORE_PVT:In Copy Req to line : Price List Id'||l_qte_line_rec.price_list_id,1,'Y');
3178: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3179: aso_debug_pub.add('ASO_PRICING_CORE_PVT:after Copy Req to line ',1,'Y');
3180: END IF;
3181: -- handle the percent price

Line 3179: aso_debug_pub.add('ASO_PRICING_CORE_PVT:after Copy Req to line ',1,'Y');

3175: aso_debug_pub.add('ASO_PRICING_CORE_PVT:In Copy Req to line 11 ',1,'Y');
3176: END IF;
3177: --aso_debug_pub.add('ASO_PRICING_CORE_PVT:In Copy Req to line : Price List Id'||l_qte_line_rec.price_list_id,1,'Y');
3178: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3179: aso_debug_pub.add('ASO_PRICING_CORE_PVT:after Copy Req to line ',1,'Y');
3180: END IF;
3181: -- handle the percent price
3182: IF NVL(l_req_line_rec.percent_price, 0) <> 0 OR
3183: l_req_line_rec.percent_price <> FND_API.G_MISS_NUM THEN

Line 3202: aso_debug_pub.add('ASO_PRICING_CORE_PVT:In Copy Req to line In ELSE1',1,'Y');

3198:
3199:
3200: ELSE
3201: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3202: aso_debug_pub.add('ASO_PRICING_CORE_PVT:In Copy Req to line In ELSE1',1,'Y');
3203: END IF;
3204: -- should be later assigned to a pricing error
3205: l_message_text := substr(l_req_line_rec.status_code || ': '||l_req_line_rec.status_text,1,200);
3206: /*

Line 3215: aso_debug_pub.add('ASO_PRICING_CORE_PVT:In Copy Req to line In ELSE2',1,'Y');

3211: END IF;
3212: */
3213: END IF;
3214: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3215: aso_debug_pub.add('ASO_PRICING_CORE_PVT:In Copy Req to line In ELSE2',1,'Y');
3216: END IF;
3217: i := p_req_line_tbl.NEXT(i);
3218: END LOOP;
3219:

Line 3251: aso_debug_pub.add('ASO_PRICING_CORE_PVT:In Update_Quote_Rows', 1, 'Y');

3247: l_quote_line_id NUMBER;
3248: l_price_adjustment_id NUMBER;
3249: BEGIN
3250: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3251: aso_debug_pub.add('ASO_PRICING_CORE_PVT:In Update_Quote_Rows', 1, 'Y');
3252: END IF;
3253: FOR i IN 1..P_Qte_Line_Tbl.count LOOP
3254: l_qte_line_rec := p_qte_line_tbl(i);
3255: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 3256: aso_debug_pub.add('ASO_PRICING_CORE_PVT:l_qte_line_rec.operation_code in Update Quote Rows is '

3252: END IF;
3253: FOR i IN 1..P_Qte_Line_Tbl.count LOOP
3254: l_qte_line_rec := p_qte_line_tbl(i);
3255: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3256: aso_debug_pub.add('ASO_PRICING_CORE_PVT:l_qte_line_rec.operation_code in Update Quote Rows is '
3257: ||l_qte_line_rec.operation_code,1,'N');
3258: END IF;
3259: IF l_qte_line_rec.operation_code = 'UPDATE' THEN
3260: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 3261: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Before ASO_QUOTE_LINES_PKG.Update_Row QUOTE_HEADER_ID'

3257: ||l_qte_line_rec.operation_code,1,'N');
3258: END IF;
3259: IF l_qte_line_rec.operation_code = 'UPDATE' THEN
3260: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3261: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Before ASO_QUOTE_LINES_PKG.Update_Row QUOTE_HEADER_ID'
3262: ||l_qte_line_rec.QUOTE_HEADER_ID, 1, 'N');
3263: END IF;
3264: ASO_QUOTE_LINES_PKG.Update_Row(
3265: p_QUOTE_LINE_ID => l_qte_line_rec.QUOTE_LINE_ID,

Line 3354: aso_debug_pub.add('ASO_PRICING_CORE_PVT:After ASO_QUOTE_LINES_PKG.Update_Row with UPDATE', 1, 'N');

3350: p_CONFIG_MODEL_TYPE => l_qte_line_rec.CONFIG_MODEL_TYPE
3351: );
3352:
3353: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3354: aso_debug_pub.add('ASO_PRICING_CORE_PVT:After ASO_QUOTE_LINES_PKG.Update_Row with UPDATE', 1, 'N');
3355: END IF;
3356:
3357: FOR j IN 1..l_Price_Adj_Tbl.count LOOP
3358: IF l_Price_Adj_Tbl(j).qte_line_index = i THEN

Line 3362: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Update The quote line in l_Price_Adj_Tbl is '

3358: IF l_Price_Adj_Tbl(j).qte_line_index = i THEN
3359: l_Price_Adj_Tbl(j).quote_line_id := l_qte_line_rec.QUOTE_LINE_ID;
3360: END IF;
3361: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3362: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Update The quote line in l_Price_Adj_Tbl is '
3363: ||l_Price_Adj_Tbl(j).quote_line_id,1,'N');
3364: END IF;
3365: END LOOP;
3366: FOR j IN 1..l_Price_Adj_Rltship_Tbl.count LOOP

Line 3371: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Update The quote line in l_Price_Adj_Rltship_Tbl is '

3367: IF l_Price_Adj_Rltship_Tbl(j).qte_line_index = i THEN
3368: l_Price_Adj_Rltship_Tbl(j).quote_line_id := l_qte_line_rec.QUOTE_LINE_ID;
3369: END IF;
3370: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3371: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Update The quote line in l_Price_Adj_Rltship_Tbl is '
3372: ||l_Price_Adj_Rltship_Tbl(j).quote_line_id,1,'N');
3373: END IF;
3374: END LOOP;
3375: ELSIF l_qte_line_rec.operation_code = 'CREATE' THEN

Line 3377: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Before ASO_QUOTE_LINES_PKG.Insert_Row QUOTE_HEADER_ID'

3373: END IF;
3374: END LOOP;
3375: ELSIF l_qte_line_rec.operation_code = 'CREATE' THEN
3376: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3377: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Before ASO_QUOTE_LINES_PKG.Insert_Row QUOTE_HEADER_ID'
3378: ||l_qte_line_rec.QUOTE_HEADER_ID, 1, 'N');
3379: END IF;
3380: ASO_QUOTE_LINES_PKG.Insert_Row(
3381: px_QUOTE_LINE_ID => l_QUOTE_LINE_ID,

Line 3470: aso_debug_pub.add('ASO_PRICING_CORE_PVT:After ASO_QUOTE_LINES_PKG.Insert_row with CREATE', 1, 'N');

3466: p_CONFIG_MODEL_TYPE => l_qte_line_rec.CONFIG_MODEL_TYPE
3467: );
3468:
3469: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3470: aso_debug_pub.add('ASO_PRICING_CORE_PVT:After ASO_QUOTE_LINES_PKG.Insert_row with CREATE', 1, 'N');
3471: END IF;
3472:
3473: FOR j IN 1..l_Price_Adj_Tbl.count LOOP
3474: IF l_Price_Adj_Tbl(j).qte_line_index = i THEN

Line 3478: aso_debug_pub.add('ASO_PRICING_CORE_PVT:The quote line in l_Price_Adj_Tbl is '

3474: IF l_Price_Adj_Tbl(j).qte_line_index = i THEN
3475: l_Price_Adj_Tbl(j).quote_line_id := l_QUOTE_LINE_ID;
3476: END IF;
3477: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3478: aso_debug_pub.add('ASO_PRICING_CORE_PVT:The quote line in l_Price_Adj_Tbl is '
3479: ||l_Price_Adj_Tbl(j).quote_line_id,1,'N');
3480: END IF;
3481: END LOOP;
3482: FOR j IN 1..l_Price_Adj_Rltship_Tbl.count LOOP

Line 3487: aso_debug_pub.add('ASO_PRICING_CORE_PVT:The quote line in l_Price_Adj_Rltship_Tbl is '

3483: IF l_Price_Adj_Rltship_Tbl(j).qte_line_index = i THEN
3484: l_Price_Adj_Rltship_Tbl(j).quote_line_id := l_QUOTE_LINE_ID;
3485: END IF;
3486: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3487: aso_debug_pub.add('ASO_PRICING_CORE_PVT:The quote line in l_Price_Adj_Rltship_Tbl is '
3488: ||l_Price_Adj_Rltship_Tbl(j).quote_line_id,1,'N');
3489: END IF;
3490: END LOOP;
3491: END IF;

Line 3499: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Before ASO_PRICE_ADJUSTMENTS_PKG.Insert_Row', 1, 'N');

3495: FOR i IN 1..l_Price_Adj_Tbl.count LOOP
3496: l_price_adj_rec := l_Price_Adj_Tbl(i);
3497: l_PRICE_ADJUSTMENT_ID := NULL;
3498: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3499: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Before ASO_PRICE_ADJUSTMENTS_PKG.Insert_Row', 1, 'N');
3500: END IF;
3501: ASO_PRICE_ADJUSTMENTS_PKG.Insert_Row(
3502: px_PRICE_ADJUSTMENT_ID => l_PRICE_ADJUSTMENT_ID,
3503: p_CREATION_DATE => SYSDATE,

Line 3594: aso_debug_pub.add('ASO_PRICING_CORE_PVT:After ASO_PRICE_ADJUSTMENTS_PKG.Insert_Row PRICE_ADJUSTMENT_ID'

3590: p_ADJUSTED_AMOUNT_PER_PQTY => l_price_adj_rec.ADJUSTED_AMOUNT_PER_PQTY,
3591: p_OBJECT_VERSION_NUMBER => l_price_adj_rec.OBJECT_VERSION_NUMBER
3592: );
3593: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3594: aso_debug_pub.add('ASO_PRICING_CORE_PVT:After ASO_PRICE_ADJUSTMENTS_PKG.Insert_Row PRICE_ADJUSTMENT_ID'
3595: ||l_PRICE_ADJUSTMENT_ID, 1, 'N');
3596: END IF;
3597: FOR j in 1..l_price_adj_attr_tbl.count LOOP
3598: IF l_price_adj_attr_tbl(j).price_adj_index = i THEN

Line 3608: aso_debug_pub.add('ASO_PRICING_CORE_PVT:After price_adj_index Loop l_price_adj_rltship_tbl', 1, 'N');

3604: IF l_price_adj_rltship_tbl(j).price_adj_index = i THEN
3605: l_price_adj_rltship_tbl(j).price_adjustment_id := l_price_adjustment_id;
3606: END IF;
3607: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3608: aso_debug_pub.add('ASO_PRICING_CORE_PVT:After price_adj_index Loop l_price_adj_rltship_tbl', 1, 'N');
3609: END IF;
3610: IF l_price_adj_rltship_tbl(j).rltd_price_adj_index = i THEN
3611: l_price_adj_rltship_tbl(j).rltd_price_adj_id := l_price_adjustment_id;
3612: END IF;

Line 3616: aso_debug_pub.add('ASO_PRICING_CORE_PVT:xxxxxxxxxxStart inserting into ASO_PRICE_ADJ_ATTRIBSxxxxxxx', 1, 'N');

3612: END IF;
3613: END LOOP;
3614: END LOOP;
3615: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3616: aso_debug_pub.add('ASO_PRICING_CORE_PVT:xxxxxxxxxxStart inserting into ASO_PRICE_ADJ_ATTRIBSxxxxxxx', 1, 'N');
3617: END IF;
3618: FOR i in 1..l_price_adj_attr_tbl.count LOOP
3619: l_price_adj_attr_rec := l_price_adj_attr_tbl(i);
3620: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 3621: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Before ASO_PRICE_ADJ_ATTRIBS_PKG.Insert_Row', 1, 'N');

3617: END IF;
3618: FOR i in 1..l_price_adj_attr_tbl.count LOOP
3619: l_price_adj_attr_rec := l_price_adj_attr_tbl(i);
3620: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3621: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Before ASO_PRICE_ADJ_ATTRIBS_PKG.Insert_Row', 1, 'N');
3622: END IF;
3623: ASO_PRICE_ADJ_ATTRIBS_PKG.Insert_Row(
3624: px_PRICE_ADJ_ATTRIB_ID => l_price_adj_attr_rec.PRICE_ADJ_ATTRIB_ID,
3625: p_CREATION_DATE => SYSDATE,

Line 3643: aso_debug_pub.add('ASO_PRICING_CORE_PVT:After ASO_PRICE_ADJ_ATTRIBS_PKG.Insert_Row', 1, 'N');

3639: p_COMPARISON_OPERATOR => l_price_adj_attr_rec.COMPARISON_OPERATOR,
3640: p_FLEX_TITLE => l_price_adj_attr_rec.FLEX_TITLE,
3641: p_OBJECT_VERSION_NUMBER => l_price_adj_attr_rec.OBJECT_VERSION_NUMBER);
3642: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3643: aso_debug_pub.add('ASO_PRICING_CORE_PVT:After ASO_PRICE_ADJ_ATTRIBS_PKG.Insert_Row', 1, 'N');
3644: END IF;
3645: END LOOP;
3646: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3647: aso_debug_pub.add('ASO_PRICING_CORE_PVT:xxxxxxxxxxFinish inserting into ASO_PRICE_ADJ_ATTRIBSxxxxxx', 1, 'N');

Line 3647: aso_debug_pub.add('ASO_PRICING_CORE_PVT:xxxxxxxxxxFinish inserting into ASO_PRICE_ADJ_ATTRIBSxxxxxx', 1, 'N');

3643: aso_debug_pub.add('ASO_PRICING_CORE_PVT:After ASO_PRICE_ADJ_ATTRIBS_PKG.Insert_Row', 1, 'N');
3644: END IF;
3645: END LOOP;
3646: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3647: aso_debug_pub.add('ASO_PRICING_CORE_PVT:xxxxxxxxxxFinish inserting into ASO_PRICE_ADJ_ATTRIBSxxxxxx', 1, 'N');
3648: END IF;
3649:
3650: FOR i IN 1..l_price_adj_rltship_tbl.count LOOP
3651: l_price_adj_rltship_rec := l_price_adj_rltship_tbl(i);

Line 3653: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Before ASO_PRICE_RLTSHIPS_PKG.Insert_Row', 1, 'N');

3649:
3650: FOR i IN 1..l_price_adj_rltship_tbl.count LOOP
3651: l_price_adj_rltship_rec := l_price_adj_rltship_tbl(i);
3652: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3653: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Before ASO_PRICE_RLTSHIPS_PKG.Insert_Row', 1, 'N');
3654: aso_debug_pub.add('ASO_PRICING_CORE_PVT:The quote line id is '
3655: ||l_price_adj_rltship_rec.quote_line_id, 1, 'N');
3656: aso_debug_pub.add('ASO_PRICING_CORE_PVT:The price adjustment id is '
3657: ||l_price_adj_rltship_rec.price_adjustment_id,1,'N');

Line 3654: aso_debug_pub.add('ASO_PRICING_CORE_PVT:The quote line id is '

3650: FOR i IN 1..l_price_adj_rltship_tbl.count LOOP
3651: l_price_adj_rltship_rec := l_price_adj_rltship_tbl(i);
3652: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3653: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Before ASO_PRICE_RLTSHIPS_PKG.Insert_Row', 1, 'N');
3654: aso_debug_pub.add('ASO_PRICING_CORE_PVT:The quote line id is '
3655: ||l_price_adj_rltship_rec.quote_line_id, 1, 'N');
3656: aso_debug_pub.add('ASO_PRICING_CORE_PVT:The price adjustment id is '
3657: ||l_price_adj_rltship_rec.price_adjustment_id,1,'N');
3658: aso_debug_pub.add('ASO_PRICING_CORE_PVT:The rltd price adj id is '

Line 3656: aso_debug_pub.add('ASO_PRICING_CORE_PVT:The price adjustment id is '

3652: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3653: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Before ASO_PRICE_RLTSHIPS_PKG.Insert_Row', 1, 'N');
3654: aso_debug_pub.add('ASO_PRICING_CORE_PVT:The quote line id is '
3655: ||l_price_adj_rltship_rec.quote_line_id, 1, 'N');
3656: aso_debug_pub.add('ASO_PRICING_CORE_PVT:The price adjustment id is '
3657: ||l_price_adj_rltship_rec.price_adjustment_id,1,'N');
3658: aso_debug_pub.add('ASO_PRICING_CORE_PVT:The rltd price adj id is '
3659: ||l_price_adj_rltship_rec.rltd_price_adj_id,1,'N');
3660: END IF;

Line 3658: aso_debug_pub.add('ASO_PRICING_CORE_PVT:The rltd price adj id is '

3654: aso_debug_pub.add('ASO_PRICING_CORE_PVT:The quote line id is '
3655: ||l_price_adj_rltship_rec.quote_line_id, 1, 'N');
3656: aso_debug_pub.add('ASO_PRICING_CORE_PVT:The price adjustment id is '
3657: ||l_price_adj_rltship_rec.price_adjustment_id,1,'N');
3658: aso_debug_pub.add('ASO_PRICING_CORE_PVT:The rltd price adj id is '
3659: ||l_price_adj_rltship_rec.rltd_price_adj_id,1,'N');
3660: END IF;
3661: ASO_PRICE_RLTSHIPS_PKG.Insert_Row(
3662: px_ADJ_RELATIONSHIP_ID => l_price_adj_rltship_rec.ADJ_RELATIONSHIP_ID,

Line 3679: aso_debug_pub.add('ASO_PRICING_CORE_PVT:After ASO_PRICE_RLTSHIPS_PKG.Insert_Row', 1, 'N');

3675: p_quote_shipment_id => l_price_adj_rltship_rec.quote_shipment_id,
3676: p_OBJECT_VERSION_NUMBER => l_price_adj_rltship_rec.OBJECT_VERSION_NUMBER
3677: );
3678: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3679: aso_debug_pub.add('ASO_PRICING_CORE_PVT:After ASO_PRICE_RLTSHIPS_PKG.Insert_Row', 1, 'N');
3680: aso_debug_pub.add('ASO_PRICING_CORE_PVT:The adj relationship id is '
3681: ||l_price_adj_rltship_rec.ADJ_RELATIONSHIP_ID,1,'N');
3682: aso_debug_pub.add('ASO_PRICING_CORE_PVT:IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII', 1, 'N');
3683: END IF;

Line 3680: aso_debug_pub.add('ASO_PRICING_CORE_PVT:The adj relationship id is '

3676: p_OBJECT_VERSION_NUMBER => l_price_adj_rltship_rec.OBJECT_VERSION_NUMBER
3677: );
3678: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3679: aso_debug_pub.add('ASO_PRICING_CORE_PVT:After ASO_PRICE_RLTSHIPS_PKG.Insert_Row', 1, 'N');
3680: aso_debug_pub.add('ASO_PRICING_CORE_PVT:The adj relationship id is '
3681: ||l_price_adj_rltship_rec.ADJ_RELATIONSHIP_ID,1,'N');
3682: aso_debug_pub.add('ASO_PRICING_CORE_PVT:IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII', 1, 'N');
3683: END IF;
3684: END LOOP;

Line 3682: aso_debug_pub.add('ASO_PRICING_CORE_PVT:IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII', 1, 'N');

3678: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3679: aso_debug_pub.add('ASO_PRICING_CORE_PVT:After ASO_PRICE_RLTSHIPS_PKG.Insert_Row', 1, 'N');
3680: aso_debug_pub.add('ASO_PRICING_CORE_PVT:The adj relationship id is '
3681: ||l_price_adj_rltship_rec.ADJ_RELATIONSHIP_ID,1,'N');
3682: aso_debug_pub.add('ASO_PRICING_CORE_PVT:IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII', 1, 'N');
3683: END IF;
3684: END LOOP;
3685: END Update_Quote_Rows;
3686: