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.OE_PRICING_CONT_PVT dependencies on OE_DEBUG_PUB

Line 35: oe_debug_pub.add('------------------------------------------------');

31: l_old_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type := p_old_Contract_rec;
32: l_p_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type; --[prarasto]
33: BEGIN
34:
35: oe_debug_pub.add('------------------------------------------------');
36: oe_debug_pub.add('Entering Contract');
37:
38: -- Load API control record
39:

Line 36: oe_debug_pub.add('Entering Contract');

32: l_p_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type; --[prarasto]
33: BEGIN
34:
35: oe_debug_pub.add('------------------------------------------------');
36: oe_debug_pub.add('Entering Contract');
37:
38: -- Load API control record
39:
40: l_control_rec := OE_GLOBALS.Init_Control_Rec

Line 237: oe_debug_pub.add('Exiting Contract');

233:
234: x_Contract_rec := l_Contract_rec;
235: x_old_Contract_rec := l_old_Contract_rec;
236:
237: oe_debug_pub.add('Exiting Contract');
238: oe_debug_pub.add('------------------------------------------------');
239:
240: EXCEPTION
241:

Line 238: oe_debug_pub.add('------------------------------------------------');

234: x_Contract_rec := l_Contract_rec;
235: x_old_Contract_rec := l_old_Contract_rec;
236:
237: oe_debug_pub.add('Exiting Contract');
238: oe_debug_pub.add('------------------------------------------------');
239:
240: EXCEPTION
241:
242: WHEN FND_API.G_EXC_ERROR THEN

Line 329: oe_debug_pub.add('------------------------------------------------');

325:
326: l_p_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type; --[prarasto]
327: BEGIN
328:
329: oe_debug_pub.add('------------------------------------------------');
330: oe_debug_pub.add('Entering Agreement');
331:
332: -- Load API control record
333:

Line 330: oe_debug_pub.add('Entering Agreement');

326: l_p_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type; --[prarasto]
327: BEGIN
328:
329: oe_debug_pub.add('------------------------------------------------');
330: oe_debug_pub.add('Entering Agreement');
331:
332: -- Load API control record
333:
334: l_control_rec := OE_GLOBALS.Init_Control_Rec

Line 456: oe_debug_pub.add('old_list_id'||to_char(l_old_agreement_rec.price_list_id)||'new_list_id'||to_char(l_agreement_rec.price_list_id));

452:
453: /*change made by spgopal 08/14/00 for duplicate qualifiers when updating
454: price list info on agreement*/
455:
456: oe_debug_pub.add('old_list_id'||to_char(l_old_agreement_rec.price_list_id)||'new_list_id'||to_char(l_agreement_rec.price_list_id));
457:
458: l_old_price_list_id := l_old_Agreement_rec.price_list_id;
459:
460: l_p_Agreement_rec := l_Agreement_rec; --[prarasto]

Line 512: oe_debug_pub.add('Geresh Before Check Delete Agreement');

508:
509: /* Check the price List associated with an agreement */
510: /* Bug 2321498 Commented following code as price List should not be deleted */
511: /*
512: oe_debug_pub.add('Geresh Before Check Delete Agreement');
513: if NOT ( Check_Delete_Agreement( p_Price_List_id => l_Agreement_rec.price_list_id )) THEN
514: l_Price_List_Exists_Flag := FALSE;
515: else
516: l_Price_List_Exists_Flag := TRUE;

Line 520: oe_debug_pub.add('Geresh After Check Delete Agreement'); */

516: l_Price_List_Exists_Flag := TRUE;
517:
518: end if;
519:
520: oe_debug_pub.add('Geresh After Check Delete Agreement'); */
521: /* Bug 2321498 : Added following line to always set the flag to false */
522: l_Price_List_Exists_Flag := TRUE;
523:
524:

Line 584: oe_debug_pub.add('before update create_agr_qual');

580: IF l_price_list_type_code = 'AGR' THEN
581:
582: --Create agreement qualifier for AGR type price lists only
583:
584: oe_debug_pub.add('before update create_agr_qual');
585:
586:
587: Create_Agreement_Qualifier(l_Agreement_rec.price_list_id
588: ,l_old_price_list_id

Line 593: oe_debug_pub.add('after update create_agr_qual');

589: ,l_Agreement_rec.Agreement_id
590: ,l_Agreement_rec.Operation
591: ,l_return_status);
592:
593: oe_debug_pub.add('after update create_agr_qual');
594:
595: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
597: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 630: oe_debug_pub.add('before insert create_agr_qual');

626: IF l_price_list_type_code = 'AGR' THEN
627:
628: --Create agreement qualifier for AGR type price lists only
629:
630: oe_debug_pub.add('before insert create_agr_qual');
631:
632: Create_Agreement_Qualifier(l_Agreement_rec.price_list_id
633: ,l_old_price_list_id
634: ,l_Agreement_rec.Agreement_id

Line 638: oe_debug_pub.add('after insert create_agr_qual');

634: ,l_Agreement_rec.Agreement_id
635: ,l_Agreement_rec.Operation
636: ,l_return_status);
637:
638: oe_debug_pub.add('after insert create_agr_qual');
639: END IF;
640:
641: END IF;
642:

Line 722: oe_debug_pub.add('Exiting Agreement');

718:
719: x_Agreement_rec := l_Agreement_rec;
720: x_old_Agreement_rec := l_old_Agreement_rec;
721:
722: oe_debug_pub.add('Exiting Agreement');
723: oe_debug_pub.add('------------------------------------------------');
724:
725: EXCEPTION
726:

Line 723: oe_debug_pub.add('------------------------------------------------');

719: x_Agreement_rec := l_Agreement_rec;
720: x_old_Agreement_rec := l_old_Agreement_rec;
721:
722: oe_debug_pub.add('Exiting Agreement');
723: oe_debug_pub.add('------------------------------------------------');
724:
725: EXCEPTION
726:
727: WHEN FND_API.G_EXC_ERROR THEN

Line 780: oe_debug_pub.add('------------------------------------------------');

776: l_p_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type; --[prarasto]
777: BEGIN
778:
779:
780: oe_debug_pub.add('------------------------------------------------');
781: oe_debug_pub.add('Entering Price_LHeader');
782: -- Load API control record
783:
784: l_control_rec := OE_GLOBALS.Init_Control_Rec

Line 781: oe_debug_pub.add('Entering Price_LHeader');

777: BEGIN
778:
779:
780: oe_debug_pub.add('------------------------------------------------');
781: oe_debug_pub.add('Entering Price_LHeader');
782: -- Load API control record
783:
784: l_control_rec := OE_GLOBALS.Init_Control_Rec
785: ( p_operation => l_Price_LHeader_rec.operation

Line 982: oe_debug_pub.add('Exiting Price_LHeader');

978:
979: x_Price_LHeader_rec := l_Price_LHeader_rec;
980: x_old_Price_LHeader_rec := l_old_Price_LHeader_rec;
981:
982: oe_debug_pub.add('Exiting Price_LHeader');
983: oe_debug_pub.add('------------------------------------------------');
984:
985: EXCEPTION
986:

Line 983: oe_debug_pub.add('------------------------------------------------');

979: x_Price_LHeader_rec := l_Price_LHeader_rec;
980: x_old_Price_LHeader_rec := l_old_Price_LHeader_rec;
981:
982: oe_debug_pub.add('Exiting Price_LHeader');
983: oe_debug_pub.add('------------------------------------------------');
984:
985: EXCEPTION
986:
987: WHEN FND_API.G_EXC_ERROR THEN

Line 1043: oe_debug_pub.add('------------------------------------------------');

1039: l_p_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type; --[prarasto]
1040:
1041: BEGIN
1042:
1043: oe_debug_pub.add('------------------------------------------------');
1044: oe_debug_pub.add('Entering Price_LLines');
1045:
1046: -- Init local table variables.
1047:

Line 1044: oe_debug_pub.add('Entering Price_LLines');

1040:
1041: BEGIN
1042:
1043: oe_debug_pub.add('------------------------------------------------');
1044: oe_debug_pub.add('Entering Price_LLines');
1045:
1046: -- Init local table variables.
1047:
1048: l_Price_LLine_tbl := p_Price_LLine_tbl;

Line 1051: oe_debug_pub.add('No of Records in Price_List_Lines table : ' || to_char(l_Price_LLine_tbl.COUNT));

1047:
1048: l_Price_LLine_tbl := p_Price_LLine_tbl;
1049: l_old_Price_LLine_tbl := p_old_Price_LLine_tbl;
1050:
1051: oe_debug_pub.add('No of Records in Price_List_Lines table : ' || to_char(l_Price_LLine_tbl.COUNT));
1052:
1053: FOR I IN 1..l_Price_LLine_tbl.COUNT LOOP
1054: BEGIN
1055:

Line 1307: oe_debug_pub.add('Exiting Price_LLines');

1303:
1304: x_Price_LLine_tbl := l_Price_LLine_tbl;
1305: x_old_Price_LLine_tbl := l_old_Price_LLine_tbl;
1306:
1307: oe_debug_pub.add('Exiting Price_LLines');
1308: oe_debug_pub.add('------------------------------------------------');
1309:
1310: EXCEPTION
1311:

Line 1308: oe_debug_pub.add('------------------------------------------------');

1304: x_Price_LLine_tbl := l_Price_LLine_tbl;
1305: x_old_Price_LLine_tbl := l_old_Price_LLine_tbl;
1306:
1307: oe_debug_pub.add('Exiting Price_LLines');
1308: oe_debug_pub.add('------------------------------------------------');
1309:
1310: EXCEPTION
1311:
1312: WHEN FND_API.G_EXC_ERROR THEN

Line 1358: oe_debug_pub.add('------------------------------------------------');

1354: l_p_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type; --[prarasto]
1355:
1356: BEGIN
1357:
1358: oe_debug_pub.add('------------------------------------------------');
1359: oe_debug_pub.add('Entering Price_Breaks');
1360:
1361: -- Init local table variables.
1362:

Line 1359: oe_debug_pub.add('Entering Price_Breaks');

1355:
1356: BEGIN
1357:
1358: oe_debug_pub.add('------------------------------------------------');
1359: oe_debug_pub.add('Entering Price_Breaks');
1360:
1361: -- Init local table variables.
1362:
1363: l_Price_Break_tbl := p_Price_Break_tbl;

Line 1640: oe_debug_pub.add('Exiting Price_Breaks');

1636:
1637: x_Price_Break_tbl := l_Price_Break_tbl;
1638: x_old_Price_Break_tbl := l_old_Price_Break_tbl;
1639:
1640: oe_debug_pub.add('Exiting Price_Breaks');
1641: oe_debug_pub.add('------------------------------------------------');
1642:
1643: EXCEPTION
1644:

Line 1641: oe_debug_pub.add('------------------------------------------------');

1637: x_Price_Break_tbl := l_Price_Break_tbl;
1638: x_old_Price_Break_tbl := l_old_Price_Break_tbl;
1639:
1640: oe_debug_pub.add('Exiting Price_Breaks');
1641: oe_debug_pub.add('------------------------------------------------');
1642:
1643: EXCEPTION
1644:
1645: WHEN FND_API.G_EXC_ERROR THEN

Line 1798: oe_debug_pub.add('Entring Process_Pricing_Cont');

1794:
1795: BEGIN
1796:
1797:
1798: oe_debug_pub.add('Entring Process_Pricing_Cont');
1799:
1800: -- Standard call to check for call compatibility
1801:
1802: IF NOT FND_API.Compatible_API_Call

Line 1928: oe_debug_pub.add('attribute1 ='||l_Discount_Header_rec.attribute1);

1924:
1925: END IF;
1926:
1927:
1928: oe_debug_pub.add('attribute1 ='||l_Discount_Header_rec.attribute1);
1929:
1930: -- The old logic exists when called from Agreement Form (Screen).
1931:
1932: if l_Discount_Header_rec.attribute1 <> 'Calling from PUBLIC API' then

Line 2305: oe_debug_pub.add('Exiting Process_Pricing_Cont');

2301: ( p_count => x_msg_count
2302: , p_data => x_msg_data
2303: );
2304:
2305: oe_debug_pub.add('Exiting Process_Pricing_Cont');
2306:
2307: EXCEPTION
2308:
2309: WHEN FND_API.G_EXC_ERROR THEN

Line 2922: oe_debug_pub.add('Geresh In Check Delete Agreement' || p_Price_List_Id);

2918: into l_count
2919: from oe_agreements_b
2920: where price_list_id = p_Price_List_id;
2921:
2922: oe_debug_pub.add('Geresh In Check Delete Agreement' || p_Price_List_Id);
2923:
2924: if ( l_count = 1) then
2925: RETURN TRUE;
2926: else

Line 2939: oe_debug_pub.add('Geresh In No Data Found Check Delete Agreement' || p_Price_List_Id);

2935:
2936:
2937: EXCEPTION
2938: WHEN NO_DATA_FOUND THEN
2939: oe_debug_pub.add('Geresh In No Data Found Check Delete Agreement' || p_Price_List_Id);
2940: RETURN TRUE;
2941:
2942: WHEN TOO_MANY_ROWS THEN
2943: oe_debug_pub.add('Geresh In No Data Found Check Delete Agreement' || p_Price_List_Id);

Line 2943: oe_debug_pub.add('Geresh In No Data Found Check Delete Agreement' || p_Price_List_Id);

2939: oe_debug_pub.add('Geresh In No Data Found Check Delete Agreement' || p_Price_List_Id);
2940: RETURN TRUE;
2941:
2942: WHEN TOO_MANY_ROWS THEN
2943: oe_debug_pub.add('Geresh In No Data Found Check Delete Agreement' || p_Price_List_Id);
2944: RETURN FALSE;
2945:
2946:
2947: END Check_Delete_Agreement;

Line 2960: oe_debug_pub.add('Geresh In Check Order Header' || p_Agreement_id);

2956:
2957: /* Commented following code for Bug 2321498 */
2958:
2959: /*
2960: oe_debug_pub.add('Geresh In Check Order Header' || p_Agreement_id);
2961: SELECT agreement_id into
2962: l_agreement_id
2963: from oe_order_lines
2964: where agreement_id = p_Agreement_id;

Line 2967: oe_debug_pub.add('Geresh In Check Order Header After sql' || sql%rowcount);

2963: from oe_order_lines
2964: where agreement_id = p_Agreement_id;
2965:
2966:
2967: oe_debug_pub.add('Geresh In Check Order Header After sql' || sql%rowcount);
2968: if SQL%ROWCOUNT > 0 then
2969: RETURN FALSE;
2970: else
2971: RETURN TRUE;

Line 2977: oe_debug_pub.add('Geresh In Check Order Line After sql');

2973:
2974: Select 'N' into l_exist from dual where
2975: not exists (select 1 from oe_order_lines
2976: where agreement_id = p_Agreement_id);
2977: oe_debug_pub.add('Geresh In Check Order Line After sql');
2978: oe_debug_pub.add('l_exist :'||l_exist);
2979:
2980: If l_exist = 'N' Then
2981: RETURN TRUE;

Line 2978: oe_debug_pub.add('l_exist :'||l_exist);

2974: Select 'N' into l_exist from dual where
2975: not exists (select 1 from oe_order_lines
2976: where agreement_id = p_Agreement_id);
2977: oe_debug_pub.add('Geresh In Check Order Line After sql');
2978: oe_debug_pub.add('l_exist :'||l_exist);
2979:
2980: If l_exist = 'N' Then
2981: RETURN TRUE;
2982: Else

Line 2985: --oe_debug_pub.add('Geresh In Check Order Line After sql');

2981: RETURN TRUE;
2982: Else
2983: RETURN FALSE;
2984: End If;
2985: --oe_debug_pub.add('Geresh In Check Order Line After sql');
2986: --oe_debug_pub.add('l_exist :'||l_exist);
2987: EXCEPTION
2988: WHEN NO_DATA_FOUND THEN
2989: RETURN FALSE;

Line 2986: --oe_debug_pub.add('l_exist :'||l_exist);

2982: Else
2983: RETURN FALSE;
2984: End If;
2985: --oe_debug_pub.add('Geresh In Check Order Line After sql');
2986: --oe_debug_pub.add('l_exist :'||l_exist);
2987: EXCEPTION
2988: WHEN NO_DATA_FOUND THEN
2989: RETURN FALSE;
2990:

Line 3008: oe_debug_pub.add('Geresh In Check Order Header' || p_Agreement_id);

3004: BEGIN
3005: --Commented following code for bug 2321498
3006:
3007: /*
3008: oe_debug_pub.add('Geresh In Check Order Header' || p_Agreement_id);
3009: SELECT agreement_id into
3010: l_agreement_id
3011: from oe_order_headers
3012: where agreement_id = p_Agreement_id;

Line 3015: oe_debug_pub.add('Geresh In Check Order Header After sql' || sql%rowcount);

3011: from oe_order_headers
3012: where agreement_id = p_Agreement_id;
3013:
3014:
3015: oe_debug_pub.add('Geresh In Check Order Header After sql' || sql%rowcount);
3016: if SQL%ROWCOUNT > 0 then
3017: RETURN FALSE;
3018: else
3019: RETURN TRUE;

Line 3026: oe_debug_pub.add('Geresh In Check Order Header After sql');

3022: --Added following code for Bug 2321498
3023: Select 'N' into l_exist from dual where
3024: not exists (select 1 from oe_order_headers
3025: where agreement_id = p_Agreement_id);
3026: oe_debug_pub.add('Geresh In Check Order Header After sql');
3027: oe_debug_pub.add('l_exist :'||l_exist);
3028:
3029: If l_exist = 'N' Then
3030: RETURN TRUE;

Line 3027: oe_debug_pub.add('l_exist :'||l_exist);

3023: Select 'N' into l_exist from dual where
3024: not exists (select 1 from oe_order_headers
3025: where agreement_id = p_Agreement_id);
3026: oe_debug_pub.add('Geresh In Check Order Header After sql');
3027: oe_debug_pub.add('l_exist :'||l_exist);
3028:
3029: If l_exist = 'N' Then
3030: RETURN TRUE;
3031: Else

Line 3090: oe_debug_pub.add('begin create_agr_qual'||to_char(p_old_list_header_id)||'old'||to_char(p_list_header_id)||'new');

3086: l_old_qual_count NUMBER;
3087:
3088: BEGIN
3089:
3090: oe_debug_pub.add('begin create_agr_qual'||to_char(p_old_list_header_id)||'old'||to_char(p_list_header_id)||'new');
3091:
3092: IF p_list_header_id IS NOT NULL OR
3093: p_list_header_id <> FND_API.G_MISS_NUM THEN
3094:

Line 3098: oe_debug_pub.add('in if create'||p_operation);

3094:
3095:
3096: if p_operation = OE_GLOBALS.G_OPR_CREATE then
3097:
3098: oe_debug_pub.add('in if create'||p_operation);
3099:
3100: l_qualifiers_rec.list_header_id := p_list_header_id;
3101: l_qualifiers_rec.qualifier_attr_value := p_agreement_id;
3102: l_qualifiers_rec.qualifier_context := 'CUSTOMER';

Line 3134: oe_debug_pub.add('in if update'||p_operation);

3130: );
3131:
3132:
3133: elsif p_operation = OE_GLOBALS.G_OPR_UPDATE then
3134: oe_debug_pub.add('in if update'||p_operation);
3135:
3136:
3137: if p_old_list_header_id <> p_list_header_id then
3138: oe_debug_pub.add('in else id!=id'||p_operation);

Line 3138: oe_debug_pub.add('in else id!=id'||p_operation);

3134: oe_debug_pub.add('in if update'||p_operation);
3135:
3136:
3137: if p_old_list_header_id <> p_list_header_id then
3138: oe_debug_pub.add('in else id!=id'||p_operation);
3139: delete from qp_qualifiers where
3140: list_header_id = p_old_list_header_id
3141: and qualifier_context = 'CUSTOMER'
3142: and qualifier_attribute = 'QUALIFIER_ATTRIBUTE7'

Line 3149: oe_debug_pub.add('in if id=id'||p_operation);

3145: else
3146: null;
3147: end if; --p_old_list_header_id = p_list_header_id
3148:
3149: oe_debug_pub.add('in if id=id'||p_operation);
3150: BEGIN
3151:
3152: select count(list_header_id) into l_qual_count
3153: from qp_qualifiers where

Line 3166: oe_debug_pub.add('in if count'||to_char(l_qual_count));

3162:
3163: END;
3164:
3165: if l_qual_count < 1 then
3166: oe_debug_pub.add('in if count'||to_char(l_qual_count));
3167: l_qualifiers_rec.list_header_id := p_list_header_id;
3168: l_qualifiers_rec.qualifier_attr_value := p_agreement_id;
3169: l_qualifiers_rec.qualifier_context := 'CUSTOMER';
3170: l_qualifiers_rec.qualifier_attribute := 'QUALIFIER_ATTRIBUTE7';

Line 3179: oe_debug_pub.add('in else count'||to_char(l_qual_count));

3175: l_qualifiers_tbl(1) := l_qualifiers_rec;
3176:
3177: else
3178:
3179: oe_debug_pub.add('in else count'||to_char(l_qual_count));
3180: null;
3181:
3182: end if; --l_qual_count<1
3183:

Line 3214: oe_debug_pub.add('end create_agr_qual'||to_char(p_old_list_header_id)||'old'||to_char(p_list_header_id)||'new');

3210: END IF;
3211:
3212:
3213:
3214: oe_debug_pub.add('end create_agr_qual'||to_char(p_old_list_header_id)||'old'||to_char(p_list_header_id)||'new');
3215:
3216: EXCEPTION
3217:
3218: WHEN OTHERS THEN

Line 3237: oe_debug_pub.add('exp create_agr_qual'||to_char(p_old_list_header_id)||'old'||to_char(p_list_header_id)||'new');

3233: ( p_count => l_msg_count
3234: , p_data => l_msg_data
3235: );
3236:
3237: oe_debug_pub.add('exp create_agr_qual'||to_char(p_old_list_header_id)||'old'||to_char(p_list_header_id)||'new');
3238:
3239: END Create_Agreement_Qualifier;
3240:
3241: END OE_Pricing_Cont_PVT;