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

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

24: p_inventory_item_rec OUT NOCOPY Inventory_Item_Rec_Type
25: ) RETURN BOOLEAN
26: IS
27:
28: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
29: l_org_id NUMBER;
30: --
31: BEGIN
32:

Line 49: oe_debug_pub.add('Entering oe_dual_uom_util.get_fulfillment_eligible' );

45: */
46:
47:
48: IF l_debug_level > 0 THEN
49: oe_debug_pub.add('Entering oe_dual_uom_util.get_fulfillment_eligible' );
50: END IF;
51:
52: -- primary_uom_class and secondary_uom_class will be used in derive_fulfillment_base function
53:

Line 83: oe_debug_pub.add(' gfe: tracking_quantity_ind:' ||p_inventory_item_rec.tracking_quantity_ind);

79: AND msi.inventory_item_id = p_line_rec.inventory_item_id
80: AND msi.organization_id = p_line_rec.ship_from_org_id;
81:
82: IF l_debug_level > 0 THEN
83: oe_debug_pub.add(' gfe: tracking_quantity_ind:' ||p_inventory_item_rec.tracking_quantity_ind);
84: oe_debug_pub.add(' gfe: shippable_item_flag:' ||p_inventory_item_rec.shippable_item_flag);
85: oe_debug_pub.add(' gfe: inventory_item_flag:' ||p_inventory_item_rec.inventory_item_flag);
86: oe_debug_pub.add(' gfe: reservable_type:' ||p_inventory_item_rec.reservable_type);
87: END IF;

Line 84: oe_debug_pub.add(' gfe: shippable_item_flag:' ||p_inventory_item_rec.shippable_item_flag);

80: AND msi.organization_id = p_line_rec.ship_from_org_id;
81:
82: IF l_debug_level > 0 THEN
83: oe_debug_pub.add(' gfe: tracking_quantity_ind:' ||p_inventory_item_rec.tracking_quantity_ind);
84: oe_debug_pub.add(' gfe: shippable_item_flag:' ||p_inventory_item_rec.shippable_item_flag);
85: oe_debug_pub.add(' gfe: inventory_item_flag:' ||p_inventory_item_rec.inventory_item_flag);
86: oe_debug_pub.add(' gfe: reservable_type:' ||p_inventory_item_rec.reservable_type);
87: END IF;
88:

Line 85: oe_debug_pub.add(' gfe: inventory_item_flag:' ||p_inventory_item_rec.inventory_item_flag);

81:
82: IF l_debug_level > 0 THEN
83: oe_debug_pub.add(' gfe: tracking_quantity_ind:' ||p_inventory_item_rec.tracking_quantity_ind);
84: oe_debug_pub.add(' gfe: shippable_item_flag:' ||p_inventory_item_rec.shippable_item_flag);
85: oe_debug_pub.add(' gfe: inventory_item_flag:' ||p_inventory_item_rec.inventory_item_flag);
86: oe_debug_pub.add(' gfe: reservable_type:' ||p_inventory_item_rec.reservable_type);
87: END IF;
88:
89: IF (p_inventory_item_rec.tracking_quantity_ind <> 'PS') -- 1. not a dual uom item

Line 86: oe_debug_pub.add(' gfe: reservable_type:' ||p_inventory_item_rec.reservable_type);

82: IF l_debug_level > 0 THEN
83: oe_debug_pub.add(' gfe: tracking_quantity_ind:' ||p_inventory_item_rec.tracking_quantity_ind);
84: oe_debug_pub.add(' gfe: shippable_item_flag:' ||p_inventory_item_rec.shippable_item_flag);
85: oe_debug_pub.add(' gfe: inventory_item_flag:' ||p_inventory_item_rec.inventory_item_flag);
86: oe_debug_pub.add(' gfe: reservable_type:' ||p_inventory_item_rec.reservable_type);
87: END IF;
88:
89: IF (p_inventory_item_rec.tracking_quantity_ind <> 'PS') -- 1. not a dual uom item
90: OR NOT (p_inventory_item_rec.shippable_item_flag ='Y' -- 2. ordered item is neither shippable ,NOR reservable NOR Inventory Item in Master item

Line 98: oe_debug_pub.add(' gfe: checikng wareshouse ' );

94: RETURN FALSE;
95: END IF ;
96:
97: IF l_debug_level > 0 THEN
98: oe_debug_pub.add(' gfe: checikng wareshouse ' );
99: END IF;
100:
101: SELECT wms_enabled_flag
102: INTO p_inventory_item_rec.wms_enabled_flag

Line 107: oe_debug_pub.add(' gfe: wms_enabled_flag: '||p_inventory_item_rec.wms_enabled_flag );

103: FROM mtl_parameters
104: WHERE organization_id= p_line_rec.ship_from_org_id;
105:
106: IF l_debug_level > 0 THEN
107: oe_debug_pub.add(' gfe: wms_enabled_flag: '||p_inventory_item_rec.wms_enabled_flag );
108: END IF;
109:
110: IF p_inventory_item_rec.wms_enabled_flag ='N' THEN
111: RETURN FALSE ;-- 3. not a wms org

Line 115: oe_debug_pub.add(' gfe: Item eligible for FULFILLMENT_BASE Calulation' );

111: RETURN FALSE ;-- 3. not a wms org
112: END IF ;
113:
114: IF l_debug_level > 0 THEN
115: oe_debug_pub.add(' gfe: Item eligible for FULFILLMENT_BASE Calulation' );
116: END IF;
117:
118: RETURN TRUE ;
119:

Line 123: oe_debug_pub.add(' gfe: Error in get_fulfillment_eligible API: ' ||sqlerrm);

119:
120: EXCEPTION
121: WHEN OTHERS THEN
122: IF l_debug_level > 0 THEN
123: oe_debug_pub.add(' gfe: Error in get_fulfillment_eligible API: ' ||sqlerrm);
124: END IF;
125: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN
126: oe_msg_pub.Add_Exc_Msg
127: ( 'OE_DUAL_UOM_UTIL'

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

146: ) RETURN VARCHAR2
147: IS
148:
149: l_fulfillment_base oe_order_lines_all.fulfillment_base%type;
150: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
151: --
152: BEGIN
153:
154: Select fulfillment_base

Line 160: oe_debug_pub.add(' gfb: l_fulfillment_base ' ||l_fulfillment_base);

156: From oe_order_lines_all
157: Where line_id = p_line_id ;
158:
159: IF l_debug_level > 0 THEN
160: oe_debug_pub.add(' gfb: l_fulfillment_base ' ||l_fulfillment_base);
161: END IF;
162:
163: Return l_fulfillment_base;
164:

Line 168: oe_debug_pub.add(' gfb: NoDataFound Error ' ||sqlerrm);

164:
165: EXCEPTION
166: WHEN NO_DATA_FOUND THEN
167: IF l_debug_level > 0 THEN
168: oe_debug_pub.add(' gfb: NoDataFound Error ' ||sqlerrm);
169: END IF;
170: RAISE FND_API.G_EXC_ERROR;
171:
172: WHEN OTHERS THEN

Line 174: oe_debug_pub.add(' gfb: Other Error ' ||sqlerrm);

170: RAISE FND_API.G_EXC_ERROR;
171:
172: WHEN OTHERS THEN
173: IF l_debug_level > 0 THEN
174: oe_debug_pub.add(' gfb: Other Error ' ||sqlerrm);
175: END IF;
176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
177:
178: End ;

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

204: IS
205: l_fulfillment_base varchar2(1);
206: l_inventory_item_rec Inventory_Item_Rec_Type;
207: l_validate_combinition NUMBER;
208: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
209:
210: BEGIN
211:
212: IF l_debug_level > 0 THEN

Line 213: oe_debug_pub.add('In Procedure oe_dual_uom_util.derive_fulfillment_base: ' ||p_line_rec.fulfillment_base);

209:
210: BEGIN
211:
212: IF l_debug_level > 0 THEN
213: oe_debug_pub.add('In Procedure oe_dual_uom_util.derive_fulfillment_base: ' ||p_line_rec.fulfillment_base);
214: oe_debug_pub.add('derive_fulfillment_base: Inventory_Item_Id: ' ||p_line_rec.Inventory_Item_Id);
215: oe_debug_pub.add('derive_fulfillment_base: order_quantity_uom: ' ||p_line_rec.order_quantity_uom);
216: oe_debug_pub.add('derive_fulfillment_base: ship_from_org_id: ' ||p_line_rec.ship_from_org_id);
217: END IF;

Line 214: oe_debug_pub.add('derive_fulfillment_base: Inventory_Item_Id: ' ||p_line_rec.Inventory_Item_Id);

210: BEGIN
211:
212: IF l_debug_level > 0 THEN
213: oe_debug_pub.add('In Procedure oe_dual_uom_util.derive_fulfillment_base: ' ||p_line_rec.fulfillment_base);
214: oe_debug_pub.add('derive_fulfillment_base: Inventory_Item_Id: ' ||p_line_rec.Inventory_Item_Id);
215: oe_debug_pub.add('derive_fulfillment_base: order_quantity_uom: ' ||p_line_rec.order_quantity_uom);
216: oe_debug_pub.add('derive_fulfillment_base: ship_from_org_id: ' ||p_line_rec.ship_from_org_id);
217: END IF;
218:

Line 215: oe_debug_pub.add('derive_fulfillment_base: order_quantity_uom: ' ||p_line_rec.order_quantity_uom);

211:
212: IF l_debug_level > 0 THEN
213: oe_debug_pub.add('In Procedure oe_dual_uom_util.derive_fulfillment_base: ' ||p_line_rec.fulfillment_base);
214: oe_debug_pub.add('derive_fulfillment_base: Inventory_Item_Id: ' ||p_line_rec.Inventory_Item_Id);
215: oe_debug_pub.add('derive_fulfillment_base: order_quantity_uom: ' ||p_line_rec.order_quantity_uom);
216: oe_debug_pub.add('derive_fulfillment_base: ship_from_org_id: ' ||p_line_rec.ship_from_org_id);
217: END IF;
218:
219: IF (p_line_rec.Inventory_Item_Id IS NULL )

Line 216: oe_debug_pub.add('derive_fulfillment_base: ship_from_org_id: ' ||p_line_rec.ship_from_org_id);

212: IF l_debug_level > 0 THEN
213: oe_debug_pub.add('In Procedure oe_dual_uom_util.derive_fulfillment_base: ' ||p_line_rec.fulfillment_base);
214: oe_debug_pub.add('derive_fulfillment_base: Inventory_Item_Id: ' ||p_line_rec.Inventory_Item_Id);
215: oe_debug_pub.add('derive_fulfillment_base: order_quantity_uom: ' ||p_line_rec.order_quantity_uom);
216: oe_debug_pub.add('derive_fulfillment_base: ship_from_org_id: ' ||p_line_rec.ship_from_org_id);
217: END IF;
218:
219: IF (p_line_rec.Inventory_Item_Id IS NULL )
220: OR (p_line_rec.order_quantity_uom IS NULL )

Line 223: oe_debug_pub.add('derive_fulfillment_base: Inventory_Item_Id or order_quantity_uom or Warehouse is null ...return FB as null' );

219: IF (p_line_rec.Inventory_Item_Id IS NULL )
220: OR (p_line_rec.order_quantity_uom IS NULL )
221: OR (p_line_rec.ship_from_org_id IS NULL ) THEN
222: IF l_debug_level > 0 THEN
223: oe_debug_pub.add('derive_fulfillment_base: Inventory_Item_Id or order_quantity_uom or Warehouse is null ...return FB as null' );
224: END IF;
225: RETURN NULL;
226: END IF ;
227:

Line 234: oe_debug_pub.add( 'derive_fulfillment_base: VALIDATE_ITEM_WAREHOUSE' , 2 ) ;

230:
231: --- Validate item/warehouse combination on line
232: BEGIN
233: IF l_debug_level > 0 THEN
234: oe_debug_pub.add( 'derive_fulfillment_base: VALIDATE_ITEM_WAREHOUSE' , 2 ) ;
235: END IF;
236:
237: SELECT 1
238: INTO l_validate_combinition

Line 250: oe_debug_pub.add('derive_fulfillment_base: INVALID ITEM WAREHOUSE COMBINATION',3);

246:
247: EXCEPTION
248: WHEN NO_DATA_FOUND THEN
249: IF l_debug_level > 0 THEN
250: oe_debug_pub.add('derive_fulfillment_base: INVALID ITEM WAREHOUSE COMBINATION',3);
251: END IF;
252: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ITEM_WHSE');
253: OE_MSG_PUB.Add;
254: RAISE FND_API.G_EXC_ERROR;

Line 268: oe_debug_pub.add('derive_fulfillment_base return line code' );

264: IF p_line_rec.line_category_code = 'RETURN' AND p_line_rec.return_context IN ('INVOICE' ,'ORDER')
265: AND p_line_rec.reference_line_id is not null THEN
266:
267: IF l_debug_level > 0 THEN
268: oe_debug_pub.add('derive_fulfillment_base return line code' );
269: END IF;
270:
271: SELECT fulfillment_base
272: INTO l_fulfillment_base

Line 283: oe_debug_pub.add('derive_fulfillment_base Split line code ' );

279: --------------------------------------------------------------
280: ELSIF p_line_rec.split_from_line_id IS NOT NULL THEN
281:
282: IF l_debug_level > 0 THEN
283: oe_debug_pub.add('derive_fulfillment_base Split line code ' );
284: END IF;
285:
286: SELECT fulfillment_base
287: INTO l_fulfillment_base

Line 298: oe_debug_pub.add('derive_fulfillment_base: ordered uom same as primary uom');

294: --3 .If Ordered UOM is Priary return primary, if Ordered uom = Sec return FB as sec
295: --------------------------------------------------------------
296: ELSIF p_line_rec.order_quantity_uom = l_inventory_item_rec.primary_uom_code THEN
297: IF l_debug_level > 0 THEN
298: oe_debug_pub.add('derive_fulfillment_base: ordered uom same as primary uom');
299: END IF;
300:
301: RETURN 'P';
302:

Line 305: oe_debug_pub.add('derive_fulfillment_base: ordered uom same as secondary uom');

301: RETURN 'P';
302:
303: ELSIF p_line_rec.order_quantity_uom = l_inventory_item_rec.secondary_uom_code THEN
304: IF l_debug_level > 0 THEN
305: oe_debug_pub.add('derive_fulfillment_base: ordered uom same as secondary uom');
306: END IF;
307:
308: RETURN 'S';
309: --------------------------------------------------------------

Line 316: oe_debug_pub.add('derive_fulfillment_base: call hook api in else ' ||p_line_rec.fulfillment_base);

312: --4 . Custom Hook, if custom hook return null it means means hook api not used by Ct Or errored out for Ct.
313: -- FDD4.1Output from Custom HOOK is only applicable if it's a WMS Enabled Organization else the default is P.
314: --------------------------------------------------------------
315: IF l_debug_level > 0 THEN
316: oe_debug_pub.add('derive_fulfillment_base: call hook api in else ' ||p_line_rec.fulfillment_base);
317: END IF;
318:
319: l_fulfillment_base := OE_DUAL_UOM_HOOK.get_fulfillment_base (p_line_rec);
320:

Line 323: oe_debug_pub.add('derive_fulfillment_base: get_fulfillment_base hook returned invlaid status ' ||l_fulfillment_base);

319: l_fulfillment_base := OE_DUAL_UOM_HOOK.get_fulfillment_base (p_line_rec);
320:
321: IF l_fulfillment_base NOT IN ('P','S') AND l_fulfillment_base IS NOT NULL THEN
322: IF l_debug_level > 0 THEN
323: oe_debug_pub.add('derive_fulfillment_base: get_fulfillment_base hook returned invlaid status ' ||l_fulfillment_base);
324: END IF;
325: fnd_message.set_name('ONT',' OE_FB_HOOK_ERROR ');
326: OE_MSG_PUB.Add;
327: RAISE FND_API.G_EXC_ERROR;

Line 341: oe_debug_pub.add('derive_fulfillment_base: ordered_uom_class ' ||l_inventory_item_rec.ordered_uom_class );

337: FROM MTL_UNITS_OF_MEASURE
338: WHERE uom_code = p_line_rec.order_quantity_uom ;
339:
340: IF l_debug_level > 0 THEN
341: oe_debug_pub.add('derive_fulfillment_base: ordered_uom_class ' ||l_inventory_item_rec.ordered_uom_class );
342: oe_debug_pub.add('derive_fulfillment_base: primary_uom_class ' ||l_inventory_item_rec.primary_uom_class );
343: oe_debug_pub.add('derive_fulfillment_base: secondary_uom_class ' || l_inventory_item_rec.secondary_uom_class );
344: END IF;
345:

Line 342: oe_debug_pub.add('derive_fulfillment_base: primary_uom_class ' ||l_inventory_item_rec.primary_uom_class );

338: WHERE uom_code = p_line_rec.order_quantity_uom ;
339:
340: IF l_debug_level > 0 THEN
341: oe_debug_pub.add('derive_fulfillment_base: ordered_uom_class ' ||l_inventory_item_rec.ordered_uom_class );
342: oe_debug_pub.add('derive_fulfillment_base: primary_uom_class ' ||l_inventory_item_rec.primary_uom_class );
343: oe_debug_pub.add('derive_fulfillment_base: secondary_uom_class ' || l_inventory_item_rec.secondary_uom_class );
344: END IF;
345:
346: IF l_inventory_item_rec.ordered_uom_class = l_inventory_item_rec.primary_uom_class THEN

Line 343: oe_debug_pub.add('derive_fulfillment_base: secondary_uom_class ' || l_inventory_item_rec.secondary_uom_class );

339:
340: IF l_debug_level > 0 THEN
341: oe_debug_pub.add('derive_fulfillment_base: ordered_uom_class ' ||l_inventory_item_rec.ordered_uom_class );
342: oe_debug_pub.add('derive_fulfillment_base: primary_uom_class ' ||l_inventory_item_rec.primary_uom_class );
343: oe_debug_pub.add('derive_fulfillment_base: secondary_uom_class ' || l_inventory_item_rec.secondary_uom_class );
344: END IF;
345:
346: IF l_inventory_item_rec.ordered_uom_class = l_inventory_item_rec.primary_uom_class THEN
347: IF l_debug_level > 0 THEN

Line 348: oe_debug_pub.add('derive_fulfillment_base: ordered uom CLASS same as primary ,fb=P ' );

344: END IF;
345:
346: IF l_inventory_item_rec.ordered_uom_class = l_inventory_item_rec.primary_uom_class THEN
347: IF l_debug_level > 0 THEN
348: oe_debug_pub.add('derive_fulfillment_base: ordered uom CLASS same as primary ,fb=P ' );
349: END IF;
350:
351: RETURN 'P';
352:

Line 355: oe_debug_pub.add('derive_fulfillment_base: ordered uom CLASS same as secondary ,fb=S ' );

351: RETURN 'P';
352:
353: ELSIF l_inventory_item_rec.ordered_uom_class = l_inventory_item_rec.secondary_uom_class THEN
354: IF l_debug_level > 0 THEN
355: oe_debug_pub.add('derive_fulfillment_base: ordered uom CLASS same as secondary ,fb=S ' );
356: END IF;
357:
358: RETURN 'S';
359: --6. If none of above Matches return

Line 363: oe_debug_pub.add('derive_fulfillment_base: ordered uom CLASS NOT same as secondary ,fb=P ' );

359: --6. If none of above Matches return
360: ELSE
361:
362: IF l_debug_level > 0 THEN
363: oe_debug_pub.add('derive_fulfillment_base: ordered uom CLASS NOT same as secondary ,fb=P ' );
364: END IF;
365:
366: RETURN 'P';
367: END IF;

Line 374: oe_debug_pub.add('derive_fulfillment_base: get_fulfillment_eligible returned FALSE ' );

370:
371: ELSE -- IF get_fulfillment_eligible retunred false THEN
372:
373: IF l_debug_level > 0 THEN
374: oe_debug_pub.add('derive_fulfillment_base: get_fulfillment_eligible returned FALSE ' );
375: END IF;
376:
377: END IF ;-- IF get_fulfillment_eligible THEN
378: END IF; --ONT_DEFAULT_FULFILLMENT_BASE

Line 381: oe_debug_pub.add(' Exiting derive_fulfillment_base with fulfillment_base as null:');

377: END IF ;-- IF get_fulfillment_eligible THEN
378: END IF; --ONT_DEFAULT_FULFILLMENT_BASE
379:
380: IF l_debug_level > 0 THEN
381: oe_debug_pub.add(' Exiting derive_fulfillment_base with fulfillment_base as null:');
382: END IF ;
383:
384: RETURN NULL;
385: -- as per fdd. for NonWMS org FB= null,so if warehouse changed from WMS(may have fb value) to non wms , we should return FB null

Line 390: oe_debug_pub.add(' DeriveFB: NoDataFound Error ' ||sqlerrm);

386:
387: EXCEPTION
388: WHEN NO_DATA_FOUND THEN
389: IF l_debug_level > 0 THEN
390: oe_debug_pub.add(' DeriveFB: NoDataFound Error ' ||sqlerrm);
391: END IF;
392: RAISE FND_API.G_EXC_ERROR;
393: WHEN FND_API.G_EXC_ERROR THEN
394: IF l_debug_level > 0 THEN

Line 395: oe_debug_pub.add(' DeriveFB: G_EXC_ERROR ' ||sqlerrm);

391: END IF;
392: RAISE FND_API.G_EXC_ERROR;
393: WHEN FND_API.G_EXC_ERROR THEN
394: IF l_debug_level > 0 THEN
395: oe_debug_pub.add(' DeriveFB: G_EXC_ERROR ' ||sqlerrm);
396: END IF;
397: RAISE FND_API.G_EXC_ERROR;
398:
399: WHEN OTHERS THEN

Line 401: oe_debug_pub.add(' DeriveFB: Error in derive_fulfillment_base API: ' ||sqlerrm);

397: RAISE FND_API.G_EXC_ERROR;
398:
399: WHEN OTHERS THEN
400: IF l_debug_level > 0 THEN
401: oe_debug_pub.add(' DeriveFB: Error in derive_fulfillment_base API: ' ||sqlerrm);
402: END IF;
403: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN
404: oe_msg_pub.Add_Exc_Msg
405: ( 'OE_DUAL_UOM_UTIL'

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

428: l_ret_exists VARCHAR2(1);
429: l_return_status VARCHAR2(1);
430: l_ful_base VARCHAR2(1);
431:
432: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
433: BEGIN
434:
435: -------------------------------
436: --VALIDATIONS on new FB vlaue:

Line 439: oe_debug_pub.add('Entering validate_fulfillment_base :' );

435: -------------------------------
436: --VALIDATIONS on new FB vlaue:
437: -------------------------------
438: IF l_debug_level > 0 THEN
439: oe_debug_pub.add('Entering validate_fulfillment_base :' );
440: END IF;
441:
442: -- 1 VALIDATION. IF line IS pick released AND fulfillment_base has changed the throw error ,treating null same as P.
443: BEGIN

Line 463: oe_debug_pub.add('Validating FB: After pick query l_pick_status: ' ||l_pick_status);

459: l_pick_status := NULL ;
460: END;
461:
462: IF l_debug_level > 0 THEN
463: oe_debug_pub.add('Validating FB: After pick query l_pick_status: ' ||l_pick_status);
464: END IF;
465:
466: IF Nvl (l_pick_status,'X') = 'Y' THEN
467: fnd_message.set_name('ONT','OE_CANNOT_UPD_FB');

Line 495: oe_debug_pub.add('Validating FB: After return line query l_ful_base: ' ||l_ful_base);

491: AND return_context IN ('INVOICE' ,'ORDER')
492: AND fulfillment_base IS NOT NULL
493: AND reference_line_id = p_line_rec.line_id ;
494: IF l_debug_level > 0 THEN
495: oe_debug_pub.add('Validating FB: After return line query l_ful_base: ' ||l_ful_base);
496: END IF;
497:
498:
499: IF l_ful_base <> Nvl(p_line_rec.fulfillment_base,'P') THEN

Line 510: oe_debug_pub.add('Validating FB: After return line query l_ret_exists: ' ||l_ret_exists);

506: WHEN TOO_MANY_ROWS THEN
507: l_ret_exists :='Y'; --y as more than one refernce line exists having non null FB
508: END;
509: IF l_debug_level > 0 THEN
510: oe_debug_pub.add('Validating FB: After return line query l_ret_exists: ' ||l_ret_exists);
511: END IF;
512:
513: IF Nvl (l_ret_exists,'X') = 'Y' THEN
514: fnd_message.set_name('ONT','OE_CANNOT_UPD_RET_FB');

Line 522: oe_debug_pub.ADD('Validating FB: p_x_line_rec.operation '|| p_line_rec.operation ,1);

518:
519: ---3 VALIDATION. G_VALIDATE_LINE_SET request is also logged in oe_line_util.pre_write for p_line_rec.operation = oe_globals.g_opr_update
520: -- to ensure that fulfillment base is same on a line set...---Below condtion added for bug 16731675
521: IF l_debug_level > 0 THEN
522: oe_debug_pub.ADD('Validating FB: p_x_line_rec.operation '|| p_line_rec.operation ,1);
523: oe_debug_pub.ADD('Validating FB: p_x_line_rec.split_action_code '||p_line_rec.split_action_code ,1);
524: oe_debug_pub.ADD('Validating FB: p_x_line_rec.line_set_id '||p_line_rec.line_set_id ,1);
525: END IF;
526:

Line 523: oe_debug_pub.ADD('Validating FB: p_x_line_rec.split_action_code '||p_line_rec.split_action_code ,1);

519: ---3 VALIDATION. G_VALIDATE_LINE_SET request is also logged in oe_line_util.pre_write for p_line_rec.operation = oe_globals.g_opr_update
520: -- to ensure that fulfillment base is same on a line set...---Below condtion added for bug 16731675
521: IF l_debug_level > 0 THEN
522: oe_debug_pub.ADD('Validating FB: p_x_line_rec.operation '|| p_line_rec.operation ,1);
523: oe_debug_pub.ADD('Validating FB: p_x_line_rec.split_action_code '||p_line_rec.split_action_code ,1);
524: oe_debug_pub.ADD('Validating FB: p_x_line_rec.line_set_id '||p_line_rec.line_set_id ,1);
525: END IF;
526:
527: IF (p_line_rec.operation = oe_globals.g_opr_create) AND

Line 524: oe_debug_pub.ADD('Validating FB: p_x_line_rec.line_set_id '||p_line_rec.line_set_id ,1);

520: -- to ensure that fulfillment base is same on a line set...---Below condtion added for bug 16731675
521: IF l_debug_level > 0 THEN
522: oe_debug_pub.ADD('Validating FB: p_x_line_rec.operation '|| p_line_rec.operation ,1);
523: oe_debug_pub.ADD('Validating FB: p_x_line_rec.split_action_code '||p_line_rec.split_action_code ,1);
524: oe_debug_pub.ADD('Validating FB: p_x_line_rec.line_set_id '||p_line_rec.line_set_id ,1);
525: END IF;
526:
527: IF (p_line_rec.operation = oe_globals.g_opr_create) AND
528: NOT (p_line_rec.split_action_code IS NOT NULL AND

Line 534: oe_debug_pub.ADD('Validating FB: logging G_VALIDATE_LINE_SET ',1);

530: (p_line_rec.line_set_id IS NOT NULL AND
531: p_line_rec.line_set_id <> FND_API.G_MISS_NUM) THEN
532:
533: IF l_debug_level > 0 THEN
534: oe_debug_pub.ADD('Validating FB: logging G_VALIDATE_LINE_SET ',1);
535: END IF;
536:
537: OE_Delayed_Requests_Pvt.Log_Request(
538: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,

Line 548: oe_debug_pub.add('validate_fulfillment_base : Exit validate_fulfillment_base ' );

544: END IF;--end of bug 16731675
545: --------------------------------------------------------------------------------------------------------------
546:
547: IF l_debug_level > 0 THEN
548: oe_debug_pub.add('validate_fulfillment_base : Exit validate_fulfillment_base ' );
549: END IF;
550: END validate_fulfillment_base;
551:
552: END OE_DUAL_UOM_UTIL;