APPS.OE_BULK_SCHEDULE_UTIL dependencies on OE_BULK_SCHEDULE_UTIL

Line 1: PACKAGE BODY OE_BULK_SCHEDULE_UTIL AS

1: PACKAGE BODY OE_BULK_SCHEDULE_UTIL AS
2: /* $Header: OEBUSCHB.pls 120.5.12020000.2 2012/09/20 05:14:48 rahujain ship $ */
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30):='OE_BULK_SCHEDULE_UTIL';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30):='OE_BULK_SCHEDULE_UTIL';

1: PACKAGE BODY OE_BULK_SCHEDULE_UTIL AS
2: /* $Header: OEBUSCHB.pls 120.5.12020000.2 2012/09/20 05:14:48 rahujain ship $ */
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30):='OE_BULK_SCHEDULE_UTIL';
6:
7:
8: G_INSERT_FLAG NUMBER;
9: G_HEADER_ID NUMBER := null;

Line 308: oe_debug_pub.add('Entering OE_BULK_SCHEDULE_UTIL.Get_Lead_Time');

304:
305: BEGIN
306:
307: IF l_debug_level > 0 THEN
308: oe_debug_pub.add('Entering OE_BULK_SCHEDULE_UTIL.Get_Lead_Time');
309:
310: oe_debug_pub.add( 'ATO LINE IS ' ||
311: p_line_rec.line_id(p_ato_index) , 1 ) ;
312:

Line 340: oe_debug_pub.add('Exiting OE_BULK_SCHEDULE_UTIL.Get_Lead_Time');

336: st_lead_time := ceil(db_full_lead_time);
337: END IF;
338:
339: IF l_debug_level > 0 THEN
340: oe_debug_pub.add('Exiting OE_BULK_SCHEDULE_UTIL.Get_Lead_Time');
341: oe_debug_pub.add('Return st_lead_time :'|| st_lead_time);
342: END IF;
343:
344: RETURN st_lead_time;

Line 349: oe_debug_pub.add('Exiting OE_BULK_SCHEDULE_UTIL.Get_Lead_Time');

345:
346: EXCEPTION
347: WHEN NO_DATA_FOUND THEN
348: IF l_debug_level > 0 THEN
349: oe_debug_pub.add('Exiting OE_BULK_SCHEDULE_UTIL.Get_Lead_Time');
350: oe_debug_pub.add('No Data Found, Return value = 0 ');
351: END IF;
352:
353: RETURN 0;

Line 356: oe_debug_pub.add('Exiting OE_BULK_SCHEDULE_UTIL.Get_Lead_Time');

352:
353: RETURN 0;
354: WHEN OTHERS THEN
355: IF l_debug_level > 0 THEN
356: oe_debug_pub.add('Exiting OE_BULK_SCHEDULE_UTIL.Get_Lead_Time');
357: oe_debug_pub.add('OTHERS, Return value = 0 ');
358: END IF;
359:
360: RETURN 0;

Line 380: oe_debug_pub.add('Entering OE_BULK_SCHEDULE_UTIL.Add_MRP_Rec');

376: --
377: BEGIN
378:
379: IF l_debug_level > 0 THEN
380: oe_debug_pub.add('Entering OE_BULK_SCHEDULE_UTIL.Add_MRP_Rec');
381: END IF;
382:
383: p_x_atp_rec.substitution_typ_code(p_atp_index) := 4; --BUG 4494602
384: p_x_atp_rec.req_item_detail_flag(p_atp_index) := 2; --BUG 4494602

Line 465: oe_debug_pub.add('Exiting OE_BULK_SCHEDULE_UTIL.Add_MRP_Rec');

461: p_line_rec.component_number(p_line_index);
462:
463: END IF;
464: IF l_debug_level > 0 THEN
465: oe_debug_pub.add('Exiting OE_BULK_SCHEDULE_UTIL.Add_MRP_Rec');
466: END IF;
467:
468: EXCEPTION
469: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 508: oe_debug_pub.add('Entering OE_BULK_SCHEDULE_UTIL.Load_MRP_Request');

504: l_return_status VARCHAR2(10);
505: l_result BOOLEAN;
506: BEGIN
507: IF l_debug_level > 0 THEN
508: oe_debug_pub.add('Entering OE_BULK_SCHEDULE_UTIL.Load_MRP_Request');
509: END IF;
510:
511: -- p_x_atp_line_map_rec stores the mapping of index positions
512: -- of order line in the MRP rec.

Line 728: oe_debug_pub.add('Exiting OE_BULK_SCHEDULE_UTIL.Load_MRP_Request');

724:
725: END LOOP; -- End of loop over line record
726:
727: If l_debug_level > 0 THEN
728: oe_debug_pub.add('Exiting OE_BULK_SCHEDULE_UTIL.Load_MRP_Request');
729: END IF;
730:
731:
732: EXCEPTION

Line 1267: END OE_BULK_SCHEDULE_UTIL;

1263: RETURN NULL;
1264: END Get_Date_Type;
1265:
1266:
1267: END OE_BULK_SCHEDULE_UTIL;