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_OE_FORM_LINE_ADJ dependencies on OE_DEBUG_PUB

Line 243: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

239: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
240: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
241:
242: --
243: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
244: --
245: BEGIN
246:
247: IF l_debug_level > 0 THEN

Line 248: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_ADJ.DEFAULT_ATTRIBUTES' , 1 ) ;

244: --
245: BEGIN
246:
247: IF l_debug_level > 0 THEN
248: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_ADJ.DEFAULT_ATTRIBUTES' , 1 ) ;
249: END IF;
250:
251: -- Set the UI flag
252: OE_GLOBALS.G_UI_FLAG := TRUE;

Line 503: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE_ADJ.DEFAULT_ATTRIBUTES' , 1 ) ;

499: , p_data => x_msg_data
500: );
501:
502: IF l_debug_level > 0 THEN
503: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE_ADJ.DEFAULT_ATTRIBUTES' , 1 ) ;
504: END IF;
505:
506: EXCEPTION
507:

Line 802: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

798: l_profile_cascade_adjustments Varchar2(1):= NVL(FND_PROFILE.VALUE('ONT_CASCADE_ADJUSTMENTS'),'N');
799: l_orcl_customization Varchar2(1):= NVL(FND_PROFILE.VALUE('ONT_ACTIVATE_ORACLE_CUSTOMIZATION'),'N');
800: l_date_format Varchar2(22) := 'DD-MON-YYYY HH24:MI:SS';
801: --
802: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
803: --
804: BEGIN
805:
806: IF l_debug_level > 0 THEN

Line 807: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_ADJ.CHANGE_ATTRIBUTES' , 1 ) ;

803: --
804: BEGIN
805:
806: IF l_debug_level > 0 THEN
807: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_ADJ.CHANGE_ATTRIBUTES' , 1 ) ;
808: END IF;
809:
810: --initialize record.
811: l_line_rec.line_id := NULL;

Line 897: oe_debug_pub.add( ' IN OE_OE_FORM_LINE_ADJ:'||SQLERRM ) ;

893: AND nvl(lin.line_id,l_x_Line_Adj_rec.line_id) = l_x_Line_Adj_rec.line_id
894: AND rownum = 1;
895: EXCEPTION WHEN OTHERS THEN
896: IF l_debug_level > 0 THEN
897: oe_debug_pub.add( ' IN OE_OE_FORM_LINE_ADJ:'||SQLERRM ) ;
898: END IF;
899: END;
900: END IF;
901: ELSIF p_attr_id = OE_Line_Adj_Util.G_MODIFIER_MECHANISM_TYPE_CODE then

Line 1079: oe_debug_pub.add( 'RL:ADJUSTED AMT = ' || L_X_LINE_ADJ_REC.ADJUSTED_AMOUNT ) ;

1075:
1076: END IF;
1077:
1078: IF l_debug_level > 0 THEN
1079: oe_debug_pub.add( 'RL:ADJUSTED AMT = ' || L_X_LINE_ADJ_REC.ADJUSTED_AMOUNT ) ;
1080: END IF;
1081: IF l_debug_level > 0 THEN
1082: oe_debug_pub.add( 'RL:ADJ PQTY = ' || L_X_LINE_ADJ_REC.ADJUSTED_AMOUNT_PER_PQTY ) ;
1083: END IF;

Line 1082: oe_debug_pub.add( 'RL:ADJ PQTY = ' || L_X_LINE_ADJ_REC.ADJUSTED_AMOUNT_PER_PQTY ) ;

1078: IF l_debug_level > 0 THEN
1079: oe_debug_pub.add( 'RL:ADJUSTED AMT = ' || L_X_LINE_ADJ_REC.ADJUSTED_AMOUNT ) ;
1080: END IF;
1081: IF l_debug_level > 0 THEN
1082: oe_debug_pub.add( 'RL:ADJ PQTY = ' || L_X_LINE_ADJ_REC.ADJUSTED_AMOUNT_PER_PQTY ) ;
1083: END IF;
1084:
1085: -- Set Operation.
1086:

Line 1123: oe_debug_pub.add( ' ARITHMETIC_OPERATOR:'||L_X_LINE_ADJ_REC.ARITHMETIC_OPERATOR ) ;

1119: same adjustment to A3 and A5 (because these are adjustments for Option lines
1120: not for service lines). */
1121:
1122: IF l_debug_level > 0 THEN
1123: oe_debug_pub.add( ' ARITHMETIC_OPERATOR:'||L_X_LINE_ADJ_REC.ARITHMETIC_OPERATOR ) ;
1124: END IF;
1125: IF l_debug_level > 0 THEN
1126: oe_debug_pub.add( ' P_ATTR_ID:'|| P_ATTR_ID ) ;
1127: END IF;

Line 1126: oe_debug_pub.add( ' P_ATTR_ID:'|| P_ATTR_ID ) ;

1122: IF l_debug_level > 0 THEN
1123: oe_debug_pub.add( ' ARITHMETIC_OPERATOR:'||L_X_LINE_ADJ_REC.ARITHMETIC_OPERATOR ) ;
1124: END IF;
1125: IF l_debug_level > 0 THEN
1126: oe_debug_pub.add( ' P_ATTR_ID:'|| P_ATTR_ID ) ;
1127: END IF;
1128: IF l_debug_level > 0 THEN
1129: oe_debug_pub.add( ' G_OPERAND_PER_PQTY:'||OE_LINE_ADJ_UTIL.G_OPERAND_PER_PQTY ) ;
1130: END IF;

Line 1129: oe_debug_pub.add( ' G_OPERAND_PER_PQTY:'||OE_LINE_ADJ_UTIL.G_OPERAND_PER_PQTY ) ;

1125: IF l_debug_level > 0 THEN
1126: oe_debug_pub.add( ' P_ATTR_ID:'|| P_ATTR_ID ) ;
1127: END IF;
1128: IF l_debug_level > 0 THEN
1129: oe_debug_pub.add( ' G_OPERAND_PER_PQTY:'||OE_LINE_ADJ_UTIL.G_OPERAND_PER_PQTY ) ;
1130: END IF;
1131:
1132:
1133: If (l_x_line_adj_rec.arithmetic_operator = '%' and

Line 1138: oe_debug_pub.add( ' CS BEFORE GETTING LINE' ) ;

1134: p_attr_id = OE_Line_Adj_Util.G_OPERAND_PER_PQTY)
1135: or p_attr_id = OE_Line_Adj_Util.G_CHANGE_REASON_CODE
1136: Then
1137: IF l_debug_level > 0 THEN
1138: oe_debug_pub.add( ' CS BEFORE GETTING LINE' ) ;
1139: END IF;
1140: Oe_Oe_Form_Line.Get_Line(p_line_id=>l_x_line_adj_rec.line_id,
1141: x_line_rec=>l_line_rec);
1142: End If;

Line 1146: oe_debug_pub.add( ' CS QUERIED LINE_ID:'||L_LINE_REC.LINE_ID ) ;

1142: End If;
1143:
1144: --Cascading adjustments for service lines
1145: IF l_debug_level > 0 THEN
1146: oe_debug_pub.add( ' CS QUERIED LINE_ID:'||L_LINE_REC.LINE_ID ) ;
1147: END IF;
1148: If nvl(l_line_rec.line_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM and
1149: l_line_rec.service_reference_line_id Is Not Null --make sure is adjustment for a service line
1150: Then

Line 1169: oe_debug_pub.add( 'CS CREATING OR CHANGING' ) ;

1165: --setting p_create_adj_no_validation to TRUE to maintain
1166: --behavior of bug 1790502 in which adjustment for service option line are not being validated
1167: If l_line_id_tbl.first is Not Null Then
1168: IF l_debug_level > 0 THEN
1169: oe_debug_pub.add( 'CS CREATING OR CHANGING' ) ;
1170: END IF;
1171: Process_Adj(p_parent_adj_rec => l_x_line_adj_rec,
1172: p_line_id_tbl => l_line_id_tbl,
1173: p_create_adj_no_validate => TRUE);

Line 1179: oe_debug_pub.add( ' CS THIS IS NOT A ADJUSTMENT FOR TOP SERVICE LINE' ) ;

1175:
1176: Exception when no_data_found Then
1177: Null;
1178: IF l_debug_level > 0 THEN
1179: oe_debug_pub.add( ' CS THIS IS NOT A ADJUSTMENT FOR TOP SERVICE LINE' ) ;
1180: END IF;
1181: --No data found, this is not an adjustment for service line for top model line item.
1182: End;
1183: End If;

Line 1187: oe_debug_pub.add( ' CS BEFORE CHECKING TOP MODEL LINE' ) ;

1183: End If;
1184:
1185: If l_orcl_customization = 'Y' Then
1186: IF l_debug_level > 0 THEN
1187: oe_debug_pub.add( ' CS BEFORE CHECKING TOP MODEL LINE' ) ;
1188: END IF;
1189: IF l_debug_level > 0 THEN
1190: oe_debug_pub.add( ' TOP MODEL LINE ID:'||L_LINE_REC.TOP_MODEL_LINE_ID ) ;
1191: END IF;

Line 1190: oe_debug_pub.add( ' TOP MODEL LINE ID:'||L_LINE_REC.TOP_MODEL_LINE_ID ) ;

1186: IF l_debug_level > 0 THEN
1187: oe_debug_pub.add( ' CS BEFORE CHECKING TOP MODEL LINE' ) ;
1188: END IF;
1189: IF l_debug_level > 0 THEN
1190: oe_debug_pub.add( ' TOP MODEL LINE ID:'||L_LINE_REC.TOP_MODEL_LINE_ID ) ;
1191: END IF;
1192: --Cascading adjustments from top model to option lines
1193: If nvl(l_line_rec.line_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM and
1194: l_line_rec.line_id = l_line_rec.top_model_line_id --to make sure this is a top model line

Line 1201: oe_debug_pub.add( ' LINE ID COUNT:'||L_LINE_ID_TBL.COUNT ) ;

1197: p_mode => 'OPTION',
1198: x_line_id_tbl=>l_line_id_tbl);
1199:
1200: IF l_debug_level > 0 THEN
1201: oe_debug_pub.add( ' LINE ID COUNT:'||L_LINE_ID_TBL.COUNT ) ;
1202: END IF;
1203: If l_line_id_tbl.first is Not Null Then
1204: IF l_debug_level > 0 THEN
1205: oe_debug_pub.add( 'CS CASCADING OPTION ADJUSTMENTS' ) ;

Line 1205: oe_debug_pub.add( 'CS CASCADING OPTION ADJUSTMENTS' ) ;

1201: oe_debug_pub.add( ' LINE ID COUNT:'||L_LINE_ID_TBL.COUNT ) ;
1202: END IF;
1203: If l_line_id_tbl.first is Not Null Then
1204: IF l_debug_level > 0 THEN
1205: oe_debug_pub.add( 'CS CASCADING OPTION ADJUSTMENTS' ) ;
1206: END IF;
1207: Process_Adj(p_parent_adj_rec => l_x_line_adj_rec,
1208: p_line_id_tbl => l_line_id_tbl);
1209: End If;

Line 1877: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE_ADJ.CHANGE_ATTRIBUTES' , 1 ) ;

1873: , p_data => x_msg_data
1874: );
1875:
1876: IF l_debug_level > 0 THEN
1877: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE_ADJ.CHANGE_ATTRIBUTES' , 1 ) ;
1878: END IF;
1879:
1880: EXCEPTION
1881:

Line 2009: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

2005: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2006:
2007:
2008: --
2009: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2010: --
2011: BEGIN
2012:
2013: IF l_debug_level > 0 THEN

Line 2014: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_ADJ.VALIDATE_AND_WRITE' , 1 ) ;

2010: --
2011: BEGIN
2012:
2013: IF l_debug_level > 0 THEN
2014: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_ADJ.VALIDATE_AND_WRITE' , 1 ) ;
2015: END IF;
2016:
2017: -- Set the UI flag
2018: OE_GLOBALS.G_UI_FLAG := TRUE;

Line 2234: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE_ADJ.VALIDATE_AND_WRITE' , 1 ) ;

2230: , p_data => x_msg_data
2231: );
2232:
2233: IF l_debug_level > 0 THEN
2234: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE_ADJ.VALIDATE_AND_WRITE' , 1 ) ;
2235: END IF;
2236:
2237: EXCEPTION
2238:

Line 2347: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

2343: l_top_model_line_id Number;
2344: l_profile_cascade_adjustments Varchar2(1):= NVL(FND_PROFILE.VALUE('ONT_CASCADE_ADJUSTMENTS'),'N');
2345:
2346: --
2347: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2348: --
2349: BEGIN
2350:
2351: IF l_debug_level > 0 THEN

Line 2352: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_ADJ.DELETE_ROW' , 1 ) ;

2348: --
2349: BEGIN
2350:
2351: IF l_debug_level > 0 THEN
2352: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_ADJ.DELETE_ROW' , 1 ) ;
2353: END IF;
2354:
2355: -- Set the UI flag
2356: OE_GLOBALS.G_UI_FLAG := TRUE;

Line 2397: oe_debug_pub.add( ' CS BEFORE GETTING LINE' ) ;

2393:
2394: -- Bug 1790502
2395: If l_x_line_adj_rec.arithmetic_operator = '%' Then
2396: IF l_debug_level > 0 THEN
2397: oe_debug_pub.add( ' CS BEFORE GETTING LINE' ) ;
2398: END IF;
2399: Oe_Oe_Form_Line.Get_Line(p_line_id=>l_x_line_adj_rec.line_id,
2400: x_line_rec=>l_line_rec);
2401:

Line 2421: oe_debug_pub.add( ' CS DELETING CHILDREN OPTION SERVICE ADJUSTMENT LINES' ) ;

2417: x_line_id_tbl=>l_line_id_tbl);
2418:
2419: If l_line_id_tbl.first is Not Null Then
2420: IF l_debug_level > 0 THEN
2421: oe_debug_pub.add( ' CS DELETING CHILDREN OPTION SERVICE ADJUSTMENT LINES' ) ;
2422: END IF;
2423: Process_Adj(p_parent_adj_rec => l_x_line_adj_rec,
2424: p_line_id_tbl => l_line_id_tbl,
2425: p_delete_flag => 'Y');

Line 2431: oe_debug_pub.add( ' CS THIS IS NOT A ADJUSTMENT FOR TOP SERVICE LINE' ) ;

2427:
2428: Exception when no_data_found Then
2429: Null;
2430: IF l_debug_level > 0 THEN
2431: oe_debug_pub.add( ' CS THIS IS NOT A ADJUSTMENT FOR TOP SERVICE LINE' ) ;
2432: END IF;
2433: --No data found, this is not an adjustment for service line for top model line item.
2434: End;
2435:

Line 2447: oe_debug_pub.add( ' CS DELETING CHILDREN OPTION ADJUSTMENT LINES' ) ;

2443: x_line_id_tbl =>l_line_id_tbl);
2444:
2445: If l_line_id_tbl.first is Not Null Then
2446: IF l_debug_level > 0 THEN
2447: oe_debug_pub.add( ' CS DELETING CHILDREN OPTION ADJUSTMENT LINES' ) ;
2448: END IF;
2449: Process_Adj(p_parent_adj_rec => l_x_line_adj_rec,
2450: p_line_id_tbl => l_line_id_tbl,
2451: p_delete_flag => 'Y');

Line 2503: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE_ADJ.DELETE_ROW' , 1 ) ;

2499: , p_data => x_msg_data
2500: );
2501:
2502: IF l_debug_level > 0 THEN
2503: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE_ADJ.DELETE_ROW' , 1 ) ;
2504: END IF;
2505:
2506: EXCEPTION
2507:

Line 2602: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

2598: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2599: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2600:
2601: --
2602: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2603: --
2604: BEGIN
2605:
2606: IF l_debug_level > 0 THEN

Line 2607: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_ADJ.PROCESS_DELAYED_REQUESTS' , 1 ) ;

2603: --
2604: BEGIN
2605:
2606: IF l_debug_level > 0 THEN
2607: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_ADJ.PROCESS_DELAYED_REQUESTS' , 1 ) ;
2608: END IF;
2609:
2610: /*
2611: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

Line 2648: oe_debug_pub.ADD('Processing delayed request for Verify Payment for price adjustments changes.', 3);

2644: RAISE FND_API.G_EXC_ERROR;
2645: END IF;
2646: END IF;
2647:
2648: oe_debug_pub.ADD('Processing delayed request for Verify Payment for price adjustments changes.', 3);
2649: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
2650: (p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT
2651: ,p_delete => FND_API.G_TRUE
2652: ,x_return_status => l_return_status

Line 2768: oe_debug_pub.add('Exiting OE_OE_FORM_LINE_ADJ.PROCESS_DELAYED_REQUESTS', 1);

2764: ( p_count => x_msg_count
2765: , p_data => x_msg_data
2766: );
2767:
2768: oe_debug_pub.add('Exiting OE_OE_FORM_LINE_ADJ.PROCESS_DELAYED_REQUESTS', 1);
2769:
2770: ****************************************************************/
2771:
2772: EXCEPTION

Line 2873: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

2869: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2870:
2871: l_line_rec Oe_Order_Pub.line_rec_type;
2872: --
2873: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2874: --
2875: BEGIN
2876:
2877: IF l_debug_level > 0 THEN

Line 2878: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_ADJ.REPLACE_ATTRIBUTES' , 1 ) ;

2874: --
2875: BEGIN
2876:
2877: IF l_debug_level > 0 THEN
2878: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_ADJ.REPLACE_ATTRIBUTES' , 1 ) ;
2879: END IF;
2880:
2881: -- Set the UI flag
2882: OE_GLOBALS.G_UI_FLAG := TRUE;

Line 2921: oe_debug_pub.add( 'NOT NULL ADJPQTY ' || P_ADJUSTED_AMOUNT_PER_PQTY ) ;

2917: We pass the per_pqty values also
2918: */
2919: IF (p_adjusted_amount_per_pqty is NOT NULL) Then
2920: IF l_debug_level > 0 THEN
2921: oe_debug_pub.add( 'NOT NULL ADJPQTY ' || P_ADJUSTED_AMOUNT_PER_PQTY ) ;
2922: END IF;
2923: l_x_line_adj_rec.adjusted_amount_per_pqty := p_adjusted_amount_per_pqty;
2924: END IF;
2925:

Line 2928: oe_debug_pub.add( 'NOT NULL OPQTY ' || P_OPERAND_PER_PQTY ) ;

2924: END IF;
2925:
2926: IF (p_operand_per_pqty is NOT NULL) Then
2927: IF l_debug_level > 0 THEN
2928: oe_debug_pub.add( 'NOT NULL OPQTY ' || P_OPERAND_PER_PQTY ) ;
2929: END IF;
2930: l_x_line_adj_rec.operand_per_pqty := p_operand_per_pqty;
2931: ELSE
2932: --IF (p_operand_per_pqty IS NULL) THEN

Line 2992: oe_debug_pub.add( 'BEFORE EXECUTING PROCESS_ORDER...' , 1 ) ;

2988: l_x_old_line_adj_rec.operand := null;
2989: l_x_old_Line_Adj_tbl(1) := l_x_old_Line_Adj_rec;
2990:
2991: IF l_debug_level > 0 THEN
2992: oe_debug_pub.add( 'BEFORE EXECUTING PROCESS_ORDER...' , 1 ) ;
2993: END IF;
2994:
2995: -- Call Oe_Order_Adj_Pvt.Line_Adj
2996: oe_order_adj_pvt.Line_Adjs

Line 3016: oe_debug_pub.add( 'AFTER EXECUTING PROCESS_ORDER...' , 1 ) ;

3012: RAISE FND_API.G_EXC_ERROR;
3013: END IF;
3014:
3015: IF l_debug_level > 0 THEN
3016: oe_debug_pub.add( 'AFTER EXECUTING PROCESS_ORDER...' , 1 ) ;
3017: END IF;
3018:
3019: -- Write to cache.
3020: Write_Line_Adj

Line 3040: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE_ADJ.REPLACE_ATTRIBUTES' , 1 ) ;

3036: , p_data => x_msg_data
3037: );
3038:
3039: IF l_debug_level > 0 THEN
3040: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE_ADJ.REPLACE_ATTRIBUTES' , 1 ) ;
3041: END IF;
3042:
3043: EXCEPTION
3044:

Line 3123: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

3119: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3120: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3121:
3122: --
3123: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3124: --
3125: BEGIN
3126:
3127: IF l_debug_level > 0 THEN

Line 3128: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_ADJ.LOCK_ROW' , 1 ) ;

3124: --
3125: BEGIN
3126:
3127: IF l_debug_level > 0 THEN
3128: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_ADJ.LOCK_ROW' , 1 ) ;
3129: END IF;
3130:
3131: -- Load Line_Adj record
3132:

Line 3166: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE_ADJ.LOCK_ROW' , 1 ) ;

3162: , p_data => x_msg_data
3163: );
3164:
3165: IF l_debug_level > 0 THEN
3166: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE_ADJ.LOCK_ROW' , 1 ) ;
3167: END IF;
3168:
3169: EXCEPTION
3170:

Line 3204: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

3200: , p_db_record IN BOOLEAN := FALSE
3201: )
3202: IS
3203: --
3204: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3205: --
3206: BEGIN
3207:
3208: IF l_debug_level > 0 THEN

Line 3209: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_ADJ.WRITE_LINE_ADJ' , 1 ) ;

3205: --
3206: BEGIN
3207:
3208: IF l_debug_level > 0 THEN
3209: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_ADJ.WRITE_LINE_ADJ' , 1 ) ;
3210: END IF;
3211:
3212: g_Line_Adj_rec := p_Line_Adj_rec;
3213:

Line 3221: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE_ADJ.WRITE_LINE_ADJ' , 1 ) ;

3217:
3218: END IF;
3219:
3220: IF l_debug_level > 0 THEN
3221: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE_ADJ.WRITE_LINE_ADJ' , 1 ) ;
3222: END IF;
3223:
3224: END Write_Line_Adj;
3225:

Line 3234: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

3230: , x_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
3231: )
3232: IS
3233: --
3234: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3235: --
3236: BEGIN
3237:
3238: IF l_debug_level > 0 THEN

Line 3239: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_ADJ.GET_LINE_ADJ' , 1 ) ;

3235: --
3236: BEGIN
3237:
3238: IF l_debug_level > 0 THEN
3239: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_ADJ.GET_LINE_ADJ' , 1 ) ;
3240: END IF;
3241:
3242: IF p_price_adjustment_id <> g_Line_Adj_rec.price_adjustment_id
3243: THEN

Line 3261: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE_ADJ.GET_LINE_ADJ' , 1 ) ;

3257:
3258: END IF;
3259:
3260: IF l_debug_level > 0 THEN
3261: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE_ADJ.GET_LINE_ADJ' , 1 ) ;
3262: END IF;
3263:
3264: IF p_db_record THEN
3265:

Line 3282: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

3278:
3279: PROCEDURE Clear_Line_Adj
3280: IS
3281: --
3282: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3283: --
3284: BEGIN
3285:
3286: IF l_debug_level > 0 THEN

Line 3287: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_ADJ.CLEAR_LINE_ADJ' , 1 ) ;

3283: --
3284: BEGIN
3285:
3286: IF l_debug_level > 0 THEN
3287: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_ADJ.CLEAR_LINE_ADJ' , 1 ) ;
3288: END IF;
3289:
3290: g_Line_Adj_rec := OE_Order_PUB.G_MISS_LINE_ADJ_REC;
3291: g_db_Line_Adj_rec := OE_Order_PUB.G_MISS_LINE_ADJ_REC;

Line 3294: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE_ADJ.CLEAR_LINE_ADJ' , 1 ) ;

3290: g_Line_Adj_rec := OE_Order_PUB.G_MISS_LINE_ADJ_REC;
3291: g_db_Line_Adj_rec := OE_Order_PUB.G_MISS_LINE_ADJ_REC;
3292:
3293: IF l_debug_level > 0 THEN
3294: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE_ADJ.CLEAR_LINE_ADJ' , 1 ) ;
3295: END IF;
3296:
3297: END Clear_Line_Adj;
3298:

Line 3314: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

3310: l_line_adj_tbl Oe_Order_Pub.line_adj_tbl_type;
3311: l_line_rec Oe_Order_Pub.line_rec_type;
3312: l_dummy_tbl Oe_Order_Pub.line_adj_tbl_type;
3313: --
3314: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3315: --
3316: Begin
3317: l_line_adj_tbl(1) := p_line_adj_rec;
3318: l_control_rec.private_call := TRUE;

Line 3390: oe_debug_pub.add( ' IN OE_OE_FORM_LINE_ADJ.INSER_ROW:'||SQLERRM ) ;

3386: EXCEPTION WHEN OTHERS THEN
3387: -- lagrawal bug 3673050
3388: OE_GLOBALS.G_UI_FLAG := FALSE;
3389: IF l_debug_level > 0 THEN
3390: oe_debug_pub.add( ' IN OE_OE_FORM_LINE_ADJ.INSER_ROW:'||SQLERRM ) ;
3391: END IF;
3392: END;
3393: END IF;
3394:

Line 3396: oe_debug_pub.add(' FLADB:l_line_adj_tbl(1).automatic_flag:'||l_line_adj_tbl(1).automatic_flag);

3392: END;
3393: END IF;
3394:
3395: IF l_debug_level > 0 THEN
3396: oe_debug_pub.add(' FLADB:l_line_adj_tbl(1).automatic_flag:'||l_line_adj_tbl(1).automatic_flag);
3397: oe_debug_pub.add(' FLADB:l_line_adj_tbl(1).updated_flag IS:'||l_line_adj_tbl(1).updated_flag);
3398: END IF;
3399:
3400: IF l_line_adj_tbl(1).applied_flag = 'Y'

Line 3397: oe_debug_pub.add(' FLADB:l_line_adj_tbl(1).updated_flag IS:'||l_line_adj_tbl(1).updated_flag);

3393: END IF;
3394:
3395: IF l_debug_level > 0 THEN
3396: oe_debug_pub.add(' FLADB:l_line_adj_tbl(1).automatic_flag:'||l_line_adj_tbl(1).automatic_flag);
3397: oe_debug_pub.add(' FLADB:l_line_adj_tbl(1).updated_flag IS:'||l_line_adj_tbl(1).updated_flag);
3398: END IF;
3399:
3400: IF l_line_adj_tbl(1).applied_flag = 'Y'
3401: AND l_line_adj_tbl(1).updated_flag IS NULL THEN

Line 3427: oe_debug_pub.add( 'IN FND_API.G_EXC_ERROR');

3423: --Start for bug 12907745
3424: WHEN FND_API.G_EXC_ERROR THEN
3425:
3426: OE_GLOBALS.G_UI_FLAG := FALSE;
3427: oe_debug_pub.add( 'IN FND_API.G_EXC_ERROR');
3428: x_return_status := FND_API.G_RET_STS_ERROR;
3429: -- Get message count and data
3430: OE_MSG_PUB.Count_And_Get
3431: ( p_count => x_msg_count

Line 3447: oe_debug_pub.add( 'OE_OE_FORM_LINE_ADJ.INSERT_ROW:'||SQLERRM ) ;

3443: ( G_PKG_NAME
3444: , 'Oe_Oe_Form_Line_Adj.Insert_Row:'||SQLERRM
3445: );
3446: IF l_debug_level > 0 THEN
3447: oe_debug_pub.add( 'OE_OE_FORM_LINE_ADJ.INSERT_ROW:'||SQLERRM ) ;
3448: END IF;
3449: -- Get message count and data
3450:
3451: OE_MSG_PUB.Count_And_Get

Line 3495: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

3491:
3492: j PLS_INTEGER := 1;
3493:
3494: --
3495: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3496: --
3497: Begin
3498: IF l_debug_level > 0 THEN
3499: oe_debug_pub.add( ' P_MODE:'||P_MODE ) ;

Line 3499: oe_debug_pub.add( ' P_MODE:'||P_MODE ) ;

3495: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3496: --
3497: Begin
3498: IF l_debug_level > 0 THEN
3499: oe_debug_pub.add( ' P_MODE:'||P_MODE ) ;
3500: END IF;
3501: IF l_debug_level > 0 THEN
3502: oe_debug_pub.add( ' P_TOP_MODEL_LINE_ID:'||P_TOP_MODEL_LINE_ID ) ;
3503: END IF;

Line 3502: oe_debug_pub.add( ' P_TOP_MODEL_LINE_ID:'||P_TOP_MODEL_LINE_ID ) ;

3498: IF l_debug_level > 0 THEN
3499: oe_debug_pub.add( ' P_MODE:'||P_MODE ) ;
3500: END IF;
3501: IF l_debug_level > 0 THEN
3502: oe_debug_pub.add( ' P_TOP_MODEL_LINE_ID:'||P_TOP_MODEL_LINE_ID ) ;
3503: END IF;
3504: IF l_debug_level > 0 THEN
3505: oe_debug_pub.add( ' P_SERVICE_LINE_ID:'||P_SERVICE_LINE_ID ) ;
3506: END IF;

Line 3505: oe_debug_pub.add( ' P_SERVICE_LINE_ID:'||P_SERVICE_LINE_ID ) ;

3501: IF l_debug_level > 0 THEN
3502: oe_debug_pub.add( ' P_TOP_MODEL_LINE_ID:'||P_TOP_MODEL_LINE_ID ) ;
3503: END IF;
3504: IF l_debug_level > 0 THEN
3505: oe_debug_pub.add( ' P_SERVICE_LINE_ID:'||P_SERVICE_LINE_ID ) ;
3506: END IF;
3507:
3508: If p_mode = 'SERVICE' Then
3509: For i in service_cur Loop

Line 3512: oe_debug_pub.add( ' SERVICE CHILD LINES ID:'||I.LINE_ID ) ;

3508: If p_mode = 'SERVICE' Then
3509: For i in service_cur Loop
3510: x_line_id_tbl(j):= i.line_id;
3511: IF l_debug_level > 0 THEN
3512: oe_debug_pub.add( ' SERVICE CHILD LINES ID:'||I.LINE_ID ) ;
3513: END IF;
3514: j:=j+1;
3515: End Loop;
3516: Elsif p_mode = 'OPTION' Then

Line 3519: oe_debug_pub.add( ' LINE ID:'||I.LINE_ID ) ;

3515: End Loop;
3516: Elsif p_mode = 'OPTION' Then
3517: For i in option_cur Loop
3518: IF l_debug_level > 0 THEN
3519: oe_debug_pub.add( ' LINE ID:'||I.LINE_ID ) ;
3520: END IF;
3521: x_line_id_tbl(j):= i.line_id;
3522: j:=j+1;
3523: End Loop;

Line 3525: oe_debug_pub.add( ' X_LINE_ID_TBL.COUNT:'|| X_LINE_ID_TBL.COUNT ) ;

3521: x_line_id_tbl(j):= i.line_id;
3522: j:=j+1;
3523: End Loop;
3524: IF l_debug_level > 0 THEN
3525: oe_debug_pub.add( ' X_LINE_ID_TBL.COUNT:'|| X_LINE_ID_TBL.COUNT ) ;
3526: END IF;
3527: End If;
3528: Exception When Others Then
3529: IF l_debug_level > 0 THEN

Line 3530: oe_debug_pub.add( ' EXECPTION IN OE_OE_FORM_LINE_ADJ:'||SQLERRM ) ;

3526: END IF;
3527: End If;
3528: Exception When Others Then
3529: IF l_debug_level > 0 THEN
3530: oe_debug_pub.add( ' EXECPTION IN OE_OE_FORM_LINE_ADJ:'||SQLERRM ) ;
3531: END IF;
3532: End;
3533:
3534: --This Procedure will either change,create or delete adjustments

Line 3558: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

3554: lx_price_adjustment_id Number;
3555: l_reason_code Varchar2(30);
3556: stmt Number;
3557: --
3558: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3559: --
3560: Begin
3561:
3562: If nvl(p_parent_adj_rec.operand,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM Then

Line 3564: oe_debug_pub.add( ' CS PARENT OPERAND IS NULL' ) ;

3560: Begin
3561:
3562: If nvl(p_parent_adj_rec.operand,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM Then
3563: IF l_debug_level > 0 THEN
3564: oe_debug_pub.add( ' CS PARENT OPERAND IS NULL' ) ;
3565: END IF;
3566: Return;
3567: End If;
3568:

Line 3577: oe_debug_pub.add( ' CS PRICE ADJUSTMENT ID:'||L_PRICE_ADJUSTMENT_ID ) ;

3573: Open adjustment_cur(p_parent_adj_rec.list_line_id,p_line_id_tbl(i));
3574: Fetch adjustment_cur into l_price_adjustment_id,l_operand,l_reason_code;
3575:
3576: IF l_debug_level > 0 THEN
3577: oe_debug_pub.add( ' CS PRICE ADJUSTMENT ID:'||L_PRICE_ADJUSTMENT_ID ) ;
3578: END IF;
3579: IF l_debug_level > 0 THEN
3580: oe_debug_pub.add( ' CS L_OPERAND:'||L_OPERAND ) ;
3581: END IF;

Line 3580: oe_debug_pub.add( ' CS L_OPERAND:'||L_OPERAND ) ;

3576: IF l_debug_level > 0 THEN
3577: oe_debug_pub.add( ' CS PRICE ADJUSTMENT ID:'||L_PRICE_ADJUSTMENT_ID ) ;
3578: END IF;
3579: IF l_debug_level > 0 THEN
3580: oe_debug_pub.add( ' CS L_OPERAND:'||L_OPERAND ) ;
3581: END IF;
3582: IF l_debug_level > 0 THEN
3583: oe_debug_pub.add( ' CS PARENT OPERAND:'||P_PARENT_ADJ_REC.OPERAND ) ;
3584: END IF;

Line 3583: oe_debug_pub.add( ' CS PARENT OPERAND:'||P_PARENT_ADJ_REC.OPERAND ) ;

3579: IF l_debug_level > 0 THEN
3580: oe_debug_pub.add( ' CS L_OPERAND:'||L_OPERAND ) ;
3581: END IF;
3582: IF l_debug_level > 0 THEN
3583: oe_debug_pub.add( ' CS PARENT OPERAND:'||P_PARENT_ADJ_REC.OPERAND ) ;
3584: END IF;
3585: IF l_debug_level > 0 THEN
3586: oe_debug_pub.add( ' CS SERVICE OPTION LINE ID:'|| P_LINE_ID_TBL ( I ) ) ;
3587: END IF;

Line 3586: oe_debug_pub.add( ' CS SERVICE OPTION LINE ID:'|| P_LINE_ID_TBL ( I ) ) ;

3582: IF l_debug_level > 0 THEN
3583: oe_debug_pub.add( ' CS PARENT OPERAND:'||P_PARENT_ADJ_REC.OPERAND ) ;
3584: END IF;
3585: IF l_debug_level > 0 THEN
3586: oe_debug_pub.add( ' CS SERVICE OPTION LINE ID:'|| P_LINE_ID_TBL ( I ) ) ;
3587: END IF;
3588: IF l_debug_level > 0 THEN
3589: oe_debug_pub.add( ' CS PARENT LIST_LINE_ID:'||P_PARENT_ADJ_REC.LIST_LINE_ID ) ;
3590: END IF;

Line 3589: oe_debug_pub.add( ' CS PARENT LIST_LINE_ID:'||P_PARENT_ADJ_REC.LIST_LINE_ID ) ;

3585: IF l_debug_level > 0 THEN
3586: oe_debug_pub.add( ' CS SERVICE OPTION LINE ID:'|| P_LINE_ID_TBL ( I ) ) ;
3587: END IF;
3588: IF l_debug_level > 0 THEN
3589: oe_debug_pub.add( ' CS PARENT LIST_LINE_ID:'||P_PARENT_ADJ_REC.LIST_LINE_ID ) ;
3590: END IF;
3591: IF l_debug_level > 0 THEN
3592: oe_debug_pub.add( ' CS PARENT CHANGE REASON CODE:'||P_PARENT_ADJ_REC.CHANGE_REASON_CODE ) ;
3593: END IF;

Line 3592: oe_debug_pub.add( ' CS PARENT CHANGE REASON CODE:'||P_PARENT_ADJ_REC.CHANGE_REASON_CODE ) ;

3588: IF l_debug_level > 0 THEN
3589: oe_debug_pub.add( ' CS PARENT LIST_LINE_ID:'||P_PARENT_ADJ_REC.LIST_LINE_ID ) ;
3590: END IF;
3591: IF l_debug_level > 0 THEN
3592: oe_debug_pub.add( ' CS PARENT CHANGE REASON CODE:'||P_PARENT_ADJ_REC.CHANGE_REASON_CODE ) ;
3593: END IF;
3594: If p_delete_flag = 'N' Then
3595: If l_price_adjustment_id is Not Null Then
3596: --Update required, a same adjustment exists

Line 3624: oe_debug_pub.add( ' CS INSERTING NEW CHILDREN' ) ;

3620: Else
3621: If p_create_adj_no_validate Then --just create adjustment without revalidation against engine
3622: --Create requiredx
3623: IF l_debug_level > 0 THEN
3624: oe_debug_pub.add( ' CS INSERTING NEW CHILDREN' ) ;
3625: END IF;
3626: l_line_adj_Rec := p_parent_adj_rec;
3627: l_line_adj_rec.line_id := p_line_id_tbl(i);
3628: stmt:=3;

Line 3675: oe_debug_pub.add( 'IN OE_OE_FORM_LINE_ADJ.PROCESS_ADJ:'||SQLERRM||':'||STMT ) ;

3671: End Loop;
3672:
3673: Exception When Others Then
3674: IF l_debug_level > 0 THEN
3675: oe_debug_pub.add( 'IN OE_OE_FORM_LINE_ADJ.PROCESS_ADJ:'||SQLERRM||':'||STMT ) ;
3676: END IF;
3677: End;
3678:
3679: