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 1077: oe_debug_pub.add( 'RL:ADJUSTED AMT = ' || L_X_LINE_ADJ_REC.ADJUSTED_AMOUNT ) ;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2213: , p_data => x_msg_data
2214: );
2215:
2216: IF l_debug_level > 0 THEN
2217: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE_ADJ.VALIDATE_AND_WRITE' , 1 ) ;
2218: END IF;
2219:
2220: EXCEPTION
2221:

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

2326: l_top_model_line_id Number;
2327: l_profile_cascade_adjustments Varchar2(1):= NVL(FND_PROFILE.VALUE('ONT_CASCADE_ADJUSTMENTS'),'N');
2328:
2329: --
2330: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2331: --
2332: BEGIN
2333:
2334: IF l_debug_level > 0 THEN

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

2331: --
2332: BEGIN
2333:
2334: IF l_debug_level > 0 THEN
2335: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_ADJ.DELETE_ROW' , 1 ) ;
2336: END IF;
2337:
2338: -- Set the UI flag
2339: OE_GLOBALS.G_UI_FLAG := TRUE;

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

2376:
2377: -- Bug 1790502
2378: If l_x_line_adj_rec.arithmetic_operator = '%' Then
2379: IF l_debug_level > 0 THEN
2380: oe_debug_pub.add( ' CS BEFORE GETTING LINE' ) ;
2381: END IF;
2382: Oe_Oe_Form_Line.Get_Line(p_line_id=>l_x_line_adj_rec.line_id,
2383: x_line_rec=>l_line_rec);
2384:

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

2400: x_line_id_tbl=>l_line_id_tbl);
2401:
2402: If l_line_id_tbl.first is Not Null Then
2403: IF l_debug_level > 0 THEN
2404: oe_debug_pub.add( ' CS DELETING CHILDREN OPTION SERVICE ADJUSTMENT LINES' ) ;
2405: END IF;
2406: Process_Adj(p_parent_adj_rec => l_x_line_adj_rec,
2407: p_line_id_tbl => l_line_id_tbl,
2408: p_delete_flag => 'Y');

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

2410:
2411: Exception when no_data_found Then
2412: Null;
2413: IF l_debug_level > 0 THEN
2414: oe_debug_pub.add( ' CS THIS IS NOT A ADJUSTMENT FOR TOP SERVICE LINE' ) ;
2415: END IF;
2416: --No data found, this is not an adjustment for service line for top model line item.
2417: End;
2418:

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

2426: x_line_id_tbl =>l_line_id_tbl);
2427:
2428: If l_line_id_tbl.first is Not Null Then
2429: IF l_debug_level > 0 THEN
2430: oe_debug_pub.add( ' CS DELETING CHILDREN OPTION ADJUSTMENT LINES' ) ;
2431: END IF;
2432: Process_Adj(p_parent_adj_rec => l_x_line_adj_rec,
2433: p_line_id_tbl => l_line_id_tbl,
2434: p_delete_flag => 'Y');

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

2482: , p_data => x_msg_data
2483: );
2484:
2485: IF l_debug_level > 0 THEN
2486: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE_ADJ.DELETE_ROW' , 1 ) ;
2487: END IF;
2488:
2489: EXCEPTION
2490:

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

2581: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2582: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2583:
2584: --
2585: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2586: --
2587: BEGIN
2588:
2589: IF l_debug_level > 0 THEN

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

2586: --
2587: BEGIN
2588:
2589: IF l_debug_level > 0 THEN
2590: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_ADJ.PROCESS_DELAYED_REQUESTS' , 1 ) ;
2591: END IF;
2592:
2593: /*
2594: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

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

2627: RAISE FND_API.G_EXC_ERROR;
2628: END IF;
2629: END IF;
2630:
2631: oe_debug_pub.ADD('Processing delayed request for Verify Payment for price adjustments changes.', 3);
2632: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
2633: (p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT
2634: ,p_delete => FND_API.G_TRUE
2635: ,x_return_status => l_return_status

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

2747: ( p_count => x_msg_count
2748: , p_data => x_msg_data
2749: );
2750:
2751: oe_debug_pub.add('Exiting OE_OE_FORM_LINE_ADJ.PROCESS_DELAYED_REQUESTS', 1);
2752:
2753: ****************************************************************/
2754:
2755: EXCEPTION

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

2852: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2853:
2854: l_line_rec Oe_Order_Pub.line_rec_type;
2855: --
2856: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2857: --
2858: BEGIN
2859:
2860: IF l_debug_level > 0 THEN

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

2857: --
2858: BEGIN
2859:
2860: IF l_debug_level > 0 THEN
2861: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_ADJ.REPLACE_ATTRIBUTES' , 1 ) ;
2862: END IF;
2863:
2864: -- Set the UI flag
2865: OE_GLOBALS.G_UI_FLAG := TRUE;

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

2900: We pass the per_pqty values also
2901: */
2902: IF (p_adjusted_amount_per_pqty is NOT NULL) Then
2903: IF l_debug_level > 0 THEN
2904: oe_debug_pub.add( 'NOT NULL ADJPQTY ' || P_ADJUSTED_AMOUNT_PER_PQTY ) ;
2905: END IF;
2906: l_x_line_adj_rec.adjusted_amount_per_pqty := p_adjusted_amount_per_pqty;
2907: END IF;
2908:

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

2907: END IF;
2908:
2909: IF (p_operand_per_pqty is NOT NULL) Then
2910: IF l_debug_level > 0 THEN
2911: oe_debug_pub.add( 'NOT NULL OPQTY ' || P_OPERAND_PER_PQTY ) ;
2912: END IF;
2913: l_x_line_adj_rec.operand_per_pqty := p_operand_per_pqty;
2914: ELSE
2915: --IF (p_operand_per_pqty IS NULL) THEN

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

2971: l_x_old_line_adj_rec.operand := null;
2972: l_x_old_Line_Adj_tbl(1) := l_x_old_Line_Adj_rec;
2973:
2974: IF l_debug_level > 0 THEN
2975: oe_debug_pub.add( 'BEFORE EXECUTING PROCESS_ORDER...' , 1 ) ;
2976: END IF;
2977:
2978: -- Call Oe_Order_Adj_Pvt.Line_Adj
2979: oe_order_adj_pvt.Line_Adjs

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

2995: RAISE FND_API.G_EXC_ERROR;
2996: END IF;
2997:
2998: IF l_debug_level > 0 THEN
2999: oe_debug_pub.add( 'AFTER EXECUTING PROCESS_ORDER...' , 1 ) ;
3000: END IF;
3001:
3002: -- Write to cache.
3003: Write_Line_Adj

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

3019: , p_data => x_msg_data
3020: );
3021:
3022: IF l_debug_level > 0 THEN
3023: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE_ADJ.REPLACE_ATTRIBUTES' , 1 ) ;
3024: END IF;
3025:
3026: EXCEPTION
3027:

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

3102: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3103: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3104:
3105: --
3106: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3107: --
3108: BEGIN
3109:
3110: IF l_debug_level > 0 THEN

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

3107: --
3108: BEGIN
3109:
3110: IF l_debug_level > 0 THEN
3111: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_ADJ.LOCK_ROW' , 1 ) ;
3112: END IF;
3113:
3114: -- Load Line_Adj record
3115:

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

3145: , p_data => x_msg_data
3146: );
3147:
3148: IF l_debug_level > 0 THEN
3149: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE_ADJ.LOCK_ROW' , 1 ) ;
3150: END IF;
3151:
3152: EXCEPTION
3153:

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

3183: , p_db_record IN BOOLEAN := FALSE
3184: )
3185: IS
3186: --
3187: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3188: --
3189: BEGIN
3190:
3191: IF l_debug_level > 0 THEN

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

3188: --
3189: BEGIN
3190:
3191: IF l_debug_level > 0 THEN
3192: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_ADJ.WRITE_LINE_ADJ' , 1 ) ;
3193: END IF;
3194:
3195: g_Line_Adj_rec := p_Line_Adj_rec;
3196:

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

3200:
3201: END IF;
3202:
3203: IF l_debug_level > 0 THEN
3204: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE_ADJ.WRITE_LINE_ADJ' , 1 ) ;
3205: END IF;
3206:
3207: END Write_Line_Adj;
3208:

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

3213: , x_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
3214: )
3215: IS
3216: --
3217: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3218: --
3219: BEGIN
3220:
3221: IF l_debug_level > 0 THEN

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

3218: --
3219: BEGIN
3220:
3221: IF l_debug_level > 0 THEN
3222: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_ADJ.GET_LINE_ADJ' , 1 ) ;
3223: END IF;
3224:
3225: IF p_price_adjustment_id <> g_Line_Adj_rec.price_adjustment_id
3226: THEN

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

3240:
3241: END IF;
3242:
3243: IF l_debug_level > 0 THEN
3244: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE_ADJ.GET_LINE_ADJ' , 1 ) ;
3245: END IF;
3246:
3247: IF p_db_record THEN
3248:

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

3261:
3262: PROCEDURE Clear_Line_Adj
3263: IS
3264: --
3265: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3266: --
3267: BEGIN
3268:
3269: IF l_debug_level > 0 THEN

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

3266: --
3267: BEGIN
3268:
3269: IF l_debug_level > 0 THEN
3270: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_ADJ.CLEAR_LINE_ADJ' , 1 ) ;
3271: END IF;
3272:
3273: g_Line_Adj_rec := OE_Order_PUB.G_MISS_LINE_ADJ_REC;
3274: g_db_Line_Adj_rec := OE_Order_PUB.G_MISS_LINE_ADJ_REC;

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

3273: g_Line_Adj_rec := OE_Order_PUB.G_MISS_LINE_ADJ_REC;
3274: g_db_Line_Adj_rec := OE_Order_PUB.G_MISS_LINE_ADJ_REC;
3275:
3276: IF l_debug_level > 0 THEN
3277: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE_ADJ.CLEAR_LINE_ADJ' , 1 ) ;
3278: END IF;
3279:
3280: END Clear_Line_Adj;
3281:

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

3293: l_line_adj_tbl Oe_Order_Pub.line_adj_tbl_type;
3294: l_line_rec Oe_Order_Pub.line_rec_type;
3295: l_dummy_tbl Oe_Order_Pub.line_adj_tbl_type;
3296: --
3297: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3298: --
3299: Begin
3300: l_line_adj_tbl(1) := p_line_adj_rec;
3301: l_control_rec.private_call := TRUE;

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

3369: EXCEPTION WHEN OTHERS THEN
3370: -- lagrawal bug 3673050
3371: OE_GLOBALS.G_UI_FLAG := FALSE;
3372: IF l_debug_level > 0 THEN
3373: oe_debug_pub.add( ' IN OE_OE_FORM_LINE_ADJ.INSER_ROW:'||SQLERRM ) ;
3374: END IF;
3375: END;
3376: END IF;
3377:

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

3375: END;
3376: END IF;
3377:
3378: IF l_debug_level > 0 THEN
3379: oe_debug_pub.add(' FLADB:l_line_adj_tbl(1).automatic_flag:'||l_line_adj_tbl(1).automatic_flag);
3380: oe_debug_pub.add(' FLADB:l_line_adj_tbl(1).updated_flag IS:'||l_line_adj_tbl(1).updated_flag);
3381: END IF;
3382:
3383: IF l_line_adj_tbl(1).applied_flag = 'Y'

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

3376: END IF;
3377:
3378: IF l_debug_level > 0 THEN
3379: oe_debug_pub.add(' FLADB:l_line_adj_tbl(1).automatic_flag:'||l_line_adj_tbl(1).automatic_flag);
3380: oe_debug_pub.add(' FLADB:l_line_adj_tbl(1).updated_flag IS:'||l_line_adj_tbl(1).updated_flag);
3381: END IF;
3382:
3383: IF l_line_adj_tbl(1).applied_flag = 'Y'
3384: AND l_line_adj_tbl(1).updated_flag IS NULL THEN

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

3413: ( G_PKG_NAME
3414: , 'Oe_Oe_Form_Line_Adj.Insert_Row:'||SQLERRM
3415: );
3416: IF l_debug_level > 0 THEN
3417: oe_debug_pub.add( 'OE_OE_FORM_LINE_ADJ.INSERT_ROW:'||SQLERRM ) ;
3418: END IF;
3419: -- Get message count and data
3420:
3421: OE_MSG_PUB.Count_And_Get

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

3461:
3462: j PLS_INTEGER := 1;
3463:
3464: --
3465: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3466: --
3467: Begin
3468: IF l_debug_level > 0 THEN
3469: oe_debug_pub.add( ' P_MODE:'||P_MODE ) ;

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

3465: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3466: --
3467: Begin
3468: IF l_debug_level > 0 THEN
3469: oe_debug_pub.add( ' P_MODE:'||P_MODE ) ;
3470: END IF;
3471: IF l_debug_level > 0 THEN
3472: oe_debug_pub.add( ' P_TOP_MODEL_LINE_ID:'||P_TOP_MODEL_LINE_ID ) ;
3473: END IF;

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

3468: IF l_debug_level > 0 THEN
3469: oe_debug_pub.add( ' P_MODE:'||P_MODE ) ;
3470: END IF;
3471: IF l_debug_level > 0 THEN
3472: oe_debug_pub.add( ' P_TOP_MODEL_LINE_ID:'||P_TOP_MODEL_LINE_ID ) ;
3473: END IF;
3474: IF l_debug_level > 0 THEN
3475: oe_debug_pub.add( ' P_SERVICE_LINE_ID:'||P_SERVICE_LINE_ID ) ;
3476: END IF;

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

3471: IF l_debug_level > 0 THEN
3472: oe_debug_pub.add( ' P_TOP_MODEL_LINE_ID:'||P_TOP_MODEL_LINE_ID ) ;
3473: END IF;
3474: IF l_debug_level > 0 THEN
3475: oe_debug_pub.add( ' P_SERVICE_LINE_ID:'||P_SERVICE_LINE_ID ) ;
3476: END IF;
3477:
3478: If p_mode = 'SERVICE' Then
3479: For i in service_cur Loop

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

3478: If p_mode = 'SERVICE' Then
3479: For i in service_cur Loop
3480: x_line_id_tbl(j):= i.line_id;
3481: IF l_debug_level > 0 THEN
3482: oe_debug_pub.add( ' SERVICE CHILD LINES ID:'||I.LINE_ID ) ;
3483: END IF;
3484: j:=j+1;
3485: End Loop;
3486: Elsif p_mode = 'OPTION' Then

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

3485: End Loop;
3486: Elsif p_mode = 'OPTION' Then
3487: For i in option_cur Loop
3488: IF l_debug_level > 0 THEN
3489: oe_debug_pub.add( ' LINE ID:'||I.LINE_ID ) ;
3490: END IF;
3491: x_line_id_tbl(j):= i.line_id;
3492: j:=j+1;
3493: End Loop;

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

3491: x_line_id_tbl(j):= i.line_id;
3492: j:=j+1;
3493: End Loop;
3494: IF l_debug_level > 0 THEN
3495: oe_debug_pub.add( ' X_LINE_ID_TBL.COUNT:'|| X_LINE_ID_TBL.COUNT ) ;
3496: END IF;
3497: End If;
3498: Exception When Others Then
3499: IF l_debug_level > 0 THEN

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

3496: END IF;
3497: End If;
3498: Exception When Others Then
3499: IF l_debug_level > 0 THEN
3500: oe_debug_pub.add( ' EXECPTION IN OE_OE_FORM_LINE_ADJ:'||SQLERRM ) ;
3501: END IF;
3502: End;
3503:
3504: --This Procedure will either change,create or delete adjustments

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

3524: lx_price_adjustment_id Number;
3525: l_reason_code Varchar2(30);
3526: stmt Number;
3527: --
3528: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3529: --
3530: Begin
3531:
3532: If nvl(p_parent_adj_rec.operand,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM Then

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

3530: Begin
3531:
3532: If nvl(p_parent_adj_rec.operand,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM Then
3533: IF l_debug_level > 0 THEN
3534: oe_debug_pub.add( ' CS PARENT OPERAND IS NULL' ) ;
3535: END IF;
3536: Return;
3537: End If;
3538:

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

3543: Open adjustment_cur(p_parent_adj_rec.list_line_id,p_line_id_tbl(i));
3544: Fetch adjustment_cur into l_price_adjustment_id,l_operand,l_reason_code;
3545:
3546: IF l_debug_level > 0 THEN
3547: oe_debug_pub.add( ' CS PRICE ADJUSTMENT ID:'||L_PRICE_ADJUSTMENT_ID ) ;
3548: END IF;
3549: IF l_debug_level > 0 THEN
3550: oe_debug_pub.add( ' CS L_OPERAND:'||L_OPERAND ) ;
3551: END IF;

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

3546: IF l_debug_level > 0 THEN
3547: oe_debug_pub.add( ' CS PRICE ADJUSTMENT ID:'||L_PRICE_ADJUSTMENT_ID ) ;
3548: END IF;
3549: IF l_debug_level > 0 THEN
3550: oe_debug_pub.add( ' CS L_OPERAND:'||L_OPERAND ) ;
3551: END IF;
3552: IF l_debug_level > 0 THEN
3553: oe_debug_pub.add( ' CS PARENT OPERAND:'||P_PARENT_ADJ_REC.OPERAND ) ;
3554: END IF;

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

3549: IF l_debug_level > 0 THEN
3550: oe_debug_pub.add( ' CS L_OPERAND:'||L_OPERAND ) ;
3551: END IF;
3552: IF l_debug_level > 0 THEN
3553: oe_debug_pub.add( ' CS PARENT OPERAND:'||P_PARENT_ADJ_REC.OPERAND ) ;
3554: END IF;
3555: IF l_debug_level > 0 THEN
3556: oe_debug_pub.add( ' CS SERVICE OPTION LINE ID:'|| P_LINE_ID_TBL ( I ) ) ;
3557: END IF;

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

3552: IF l_debug_level > 0 THEN
3553: oe_debug_pub.add( ' CS PARENT OPERAND:'||P_PARENT_ADJ_REC.OPERAND ) ;
3554: END IF;
3555: IF l_debug_level > 0 THEN
3556: oe_debug_pub.add( ' CS SERVICE OPTION LINE ID:'|| P_LINE_ID_TBL ( I ) ) ;
3557: END IF;
3558: IF l_debug_level > 0 THEN
3559: oe_debug_pub.add( ' CS PARENT LIST_LINE_ID:'||P_PARENT_ADJ_REC.LIST_LINE_ID ) ;
3560: END IF;

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

3555: IF l_debug_level > 0 THEN
3556: oe_debug_pub.add( ' CS SERVICE OPTION LINE ID:'|| P_LINE_ID_TBL ( I ) ) ;
3557: END IF;
3558: IF l_debug_level > 0 THEN
3559: oe_debug_pub.add( ' CS PARENT LIST_LINE_ID:'||P_PARENT_ADJ_REC.LIST_LINE_ID ) ;
3560: END IF;
3561: IF l_debug_level > 0 THEN
3562: oe_debug_pub.add( ' CS PARENT CHANGE REASON CODE:'||P_PARENT_ADJ_REC.CHANGE_REASON_CODE ) ;
3563: END IF;

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

3558: IF l_debug_level > 0 THEN
3559: oe_debug_pub.add( ' CS PARENT LIST_LINE_ID:'||P_PARENT_ADJ_REC.LIST_LINE_ID ) ;
3560: END IF;
3561: IF l_debug_level > 0 THEN
3562: oe_debug_pub.add( ' CS PARENT CHANGE REASON CODE:'||P_PARENT_ADJ_REC.CHANGE_REASON_CODE ) ;
3563: END IF;
3564: If p_delete_flag = 'N' Then
3565: If l_price_adjustment_id is Not Null Then
3566: --Update required, a same adjustment exists

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

3590: Else
3591: If p_create_adj_no_validate Then --just create adjustment without revalidation against engine
3592: --Create requiredx
3593: IF l_debug_level > 0 THEN
3594: oe_debug_pub.add( ' CS INSERTING NEW CHILDREN' ) ;
3595: END IF;
3596: l_line_adj_Rec := p_parent_adj_rec;
3597: l_line_adj_rec.line_id := p_line_id_tbl(i);
3598: stmt:=3;

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

3641: End Loop;
3642:
3643: Exception When Others Then
3644: IF l_debug_level > 0 THEN
3645: oe_debug_pub.add( 'IN OE_OE_FORM_LINE_ADJ.PROCESS_ADJ:'||SQLERRM||':'||STMT ) ;
3646: END IF;
3647: End;
3648:
3649: