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

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

33: l_sch_error_msg VARCHAR2(2000);
34: l_index NUMBER;
35: l_error_code NUMBER;
36: --
37: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
38: --
39: BEGIN
40:
41: ---------------------------------------------------------------------

Line 46: oe_debug_pub.add( 'ERROR COUNT :'||G_SCH_ERROR_TBL.COUNT ) ;

42: -- For order lines that failed scheduling:
43: -- Insert Error Messages
44: ---------------------------------------------------------------------
45: IF l_debug_level > 0 THEN
46: oe_debug_pub.add( 'ERROR COUNT :'||G_SCH_ERROR_TBL.COUNT ) ;
47: END IF;
48:
49: l_no_source_msg := FND_MESSAGE.GET_STRING('ONT','OE_SCH_NO_SOURCE');
50: l_sch_error_msg := FND_MESSAGE.GET_STRING('ONT','OE_BULK_SCH_FAILED');

Line 100: oe_debug_pub.add( 'UNEXP ERROR , INSERT_ERROR_MESSAGE' ) ;

96:
97: EXCEPTION
98: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
99: IF l_debug_level > 0 THEN
100: oe_debug_pub.add( 'UNEXP ERROR , INSERT_ERROR_MESSAGE' ) ;
101: END IF;
102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
103: WHEN OTHERS THEN
104: IF l_debug_level > 0 THEN

Line 105: oe_debug_pub.add( 'OTHERS ERROR , INSERT_ERROR_MESSAGES' ) ;

101: END IF;
102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
103: WHEN OTHERS THEN
104: IF l_debug_level > 0 THEN
105: oe_debug_pub.add( 'OTHERS ERROR , INSERT_ERROR_MESSAGES' ) ;
106: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
107: END IF;
108: OE_BULK_MSG_PUB.Add_Exc_Msg
109: ( G_PKG_NAME

Line 106: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;

102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
103: WHEN OTHERS THEN
104: IF l_debug_level > 0 THEN
105: oe_debug_pub.add( 'OTHERS ERROR , INSERT_ERROR_MESSAGES' ) ;
106: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
107: END IF;
108: OE_BULK_MSG_PUB.Add_Exc_Msg
109: ( G_PKG_NAME
110: , 'Insert_Error_Messages'

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

121: l_order_date_type_code VARCHAR2(30);
122: l_promise_date_flag VARCHAR2(2);
123: I NUMBER;
124: --
125: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
126: --
127: BEGIN
128: IF l_debug_level > 0 THEN
129: oe_debug_pub.add( 'ENTERING INACTIVE_DEMAND_SCHEDULING' , 1 ) ;

Line 129: oe_debug_pub.add( 'ENTERING INACTIVE_DEMAND_SCHEDULING' , 1 ) ;

125: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
126: --
127: BEGIN
128: IF l_debug_level > 0 THEN
129: oe_debug_pub.add( 'ENTERING INACTIVE_DEMAND_SCHEDULING' , 1 ) ;
130: END IF;
131: x_return_status := FND_API.G_RET_STS_SUCCESS;
132: FOR I IN 1..p_line_rec.line_id.count
133: LOOP

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

214: ,p_x_atp_rec IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ
215: )
216: IS
217: --
218: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
219: --
220: BEGIN
221:
222: p_x_atp_rec.Inventory_Item_Id.extend(p_count);

Line 266: oe_debug_pub.add( 'UNEXP ERROR , EXTEND_MRP_REC' ) ;

262: p_x_atp_rec.req_item_detail_flag.extend(p_count); --BUG 4494602
263: EXCEPTION
264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
265: IF l_debug_level > 0 THEN
266: oe_debug_pub.add( 'UNEXP ERROR , EXTEND_MRP_REC' ) ;
267: END IF;
268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
269: WHEN OTHERS THEN
270: IF l_debug_level > 0 THEN

Line 271: oe_debug_pub.add( 'OTHERS ERROR , EXTEND_MRP_REC' ) ;

267: END IF;
268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
269: WHEN OTHERS THEN
270: IF l_debug_level > 0 THEN
271: oe_debug_pub.add( 'OTHERS ERROR , EXTEND_MRP_REC' ) ;
272: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
273: END IF;
274: OE_BULK_MSG_PUB.Add_Exc_Msg
275: ( G_PKG_NAME

Line 272: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;

268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
269: WHEN OTHERS THEN
270: IF l_debug_level > 0 THEN
271: oe_debug_pub.add( 'OTHERS ERROR , EXTEND_MRP_REC' ) ;
272: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
273: END IF;
274: OE_BULK_MSG_PUB.Add_Exc_Msg
275: ( G_PKG_NAME
276: , 'Extend_MRP_Rec'

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

296: --db_primary_uom_code VARCHAR2(3);
297: --db_model_item_id NUMBER := 0;
298: --db_line_unit_code VARCHAR2(3);
299: --
300: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
301: --
302: l_org_id NUMBER;
303: l_c_index NUMBER;
304:

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 310: oe_debug_pub.add( 'ATO LINE IS ' ||

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:
313: oe_debug_pub.add( 'SHIP FROM IS ' ||
314: p_line_rec.ship_from_org_id(p_ato_index), 1 ) ;

Line 313: oe_debug_pub.add( 'SHIP FROM IS ' ||

309:
310: oe_debug_pub.add( 'ATO LINE IS ' ||
311: p_line_rec.line_id(p_ato_index) , 1 ) ;
312:
313: oe_debug_pub.add( 'SHIP FROM IS ' ||
314: p_line_rec.ship_from_org_id(p_ato_index), 1 ) ;
315: END IF;
316:
317: l_org_id := nvl(p_line_rec.ship_from_org_id(p_ato_index),

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 341: oe_debug_pub.add('Return st_lead_time :'|| st_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;
345:

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 350: oe_debug_pub.add('No Data Found, Return value = 0 ');

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;
354: WHEN OTHERS THEN

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 357: oe_debug_pub.add('OTHERS, Return value = 0 ');

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;
361: END Get_Lead_Time;

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

371: ,p_x_atp_rec IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ
372: )
373: IS
374: --
375: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
376: --
377: BEGIN
378:
379: IF l_debug_level > 0 THEN

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 471: oe_debug_pub.add( 'UNEXP ERROR , ADD_MRP_REC' ) ;

467:
468: EXCEPTION
469: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
470: IF l_debug_level > 0 THEN
471: oe_debug_pub.add( 'UNEXP ERROR , ADD_MRP_REC' ) ;
472: END IF;
473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
474: WHEN OTHERS THEN
475: IF l_debug_level > 0 THEN

Line 476: oe_debug_pub.add( 'OTHERS ERROR , ADD_MRP_REC' ) ;

472: END IF;
473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
474: WHEN OTHERS THEN
475: IF l_debug_level > 0 THEN
476: oe_debug_pub.add( 'OTHERS ERROR , ADD_MRP_REC' ) ;
477: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
478: END IF;
479: OE_BULK_MSG_PUB.Add_Exc_Msg
480: ( G_PKG_NAME

Line 477: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;

473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
474: WHEN OTHERS THEN
475: IF l_debug_level > 0 THEN
476: oe_debug_pub.add( 'OTHERS ERROR , ADD_MRP_REC' ) ;
477: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
478: END IF;
479: OE_BULK_MSG_PUB.Add_Exc_Msg
480: ( G_PKG_NAME
481: , 'Add_MRP_Rec'

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

498: l_header_count NUMBER;
499: l_ii_index NUMBER;
500: l_ii_last_index NUMBER;
501: l_curr_ato_index NUMBER; --
502: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
503: --
504: l_return_status VARCHAR2(10);
505: l_result BOOLEAN;
506: BEGIN

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 528: oe_debug_pub.add('Error while extending ATP record');

524: MSC_SATP_FUNC.Extend_Atp(p_atp_tab=>p_x_atp_rec,
525: x_return_status => l_return_status,
526: p_index => OE_BULK_ORDER_PVT.G_SCH_COUNT);
527: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
528: oe_debug_pub.add('Error while extending ATP record');
529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
530: end if ;
531: p_x_atp_line_map_rec.extend(OE_BULK_ORDER_PVT.G_SCH_COUNT);
532:

Line 543: oe_debug_pub.add( 'LINE COUNT :'||L_LINE_COUNT ) ;

539: l_line_count := p_line_rec.line_id.count;
540: l_header_count := p_line_rec.header_id.count;
541:
542: IF l_debug_level > 0 THEN
543: oe_debug_pub.add( 'LINE COUNT :'||L_LINE_COUNT ) ;
544: END IF;
545: <>
546: WHILE I <= l_line_count
547: AND p_line_rec.item_type_code(I) <> 'INCLUDED'

Line 551: oe_debug_pub.add( 'I :'||I ) ;

547: AND p_line_rec.item_type_code(I) <> 'INCLUDED'
548: LOOP
549:
550: IF l_debug_level > 0 THEN
551: oe_debug_pub.add( 'I :'||I ) ;
552: oe_debug_pub.add( 'J :'||J ) ;
553: END IF;
554:
555: -- Line is NOT eligible for scheduling

Line 552: oe_debug_pub.add( 'J :'||J ) ;

548: LOOP
549:
550: IF l_debug_level > 0 THEN
551: oe_debug_pub.add( 'I :'||I ) ;
552: oe_debug_pub.add( 'J :'||J ) ;
553: END IF;
554:
555: -- Line is NOT eligible for scheduling
556: IF p_line_rec.schedule_status_code(I) IS NULL THEN

Line 579: oe_debug_pub.add( 'Calling check for holds :'||J ) ;

575: IF OE_BULK_ORDER_PVT.G_SCHEDULE_LINE_ON_HOLD = 'N' AND
576: p_line_rec.item_type_code(I) <> 'STANDARD'
577: THEN
578: IF l_debug_level > 0 THEN
579: oe_debug_pub.add( 'Calling check for holds :'||J ) ;
580: END IF;
581: l_result := OE_Bulk_Holds_PVT.Check_For_Holds(
582: p_header_id => p_line_rec.header_id(I),
583: p_line_id => p_line_rec.line_id(I),

Line 592: oe_debug_pub.add('After Calling check for holds ');

588: p_ato_line_index => p_line_rec.ato_line_index(I),
589: p_ii_parent_line_index => NULL
590: );
591: IF l_debug_level > 0 THEN
592: oe_debug_pub.add('After Calling check for holds ');
593: END IF;
594:
595: -- If found on hold then do not schedule the line.
596: IF l_result THEN

Line 628: oe_debug_pub.add( 'The current ATO index is:'||l_curr_ato_index ) ;

624:
625: l_curr_ato_index := p_line_rec.ato_line_index(I);
626:
627: IF l_debug_level > 0 THEN
628: oe_debug_pub.add( 'The current ATO index is:'||l_curr_ato_index ) ;
629: END IF;
630:
631: -- line should not be scheduled if
632: -- any included item is on hold

Line 642: oe_debug_pub.add('Calling add_mrp_rec ') ;

638: -- are not on hold in this kit
639: p_line_rec.schedule_status_code(I) := NULL;
640: ELSE
641: IF l_debug_level > 0 THEN
642: oe_debug_pub.add('Calling add_mrp_rec ') ;
643: END IF;
644: Add_MRP_Rec(p_line_index => I
645: ,p_curr_ato_index => l_curr_ato_index
646: ,p_header_index => K

Line 653: oe_debug_pub.add('After add_mrp_rec ') ;

649: ,p_header_rec => p_header_rec
650: ,p_x_atp_Rec => p_x_atp_rec
651: );
652: IF l_debug_level > 0 THEN
653: oe_debug_pub.add('After add_mrp_rec ') ;
654: END IF;
655: p_x_atp_line_map_rec(J) := I;
656: J := J+1;
657: END IF;

Line 698: oe_debug_pub.add('calling add_mrp_rec for II ') ;

694: IF l_result THEN
695: p_line_rec.schedule_status_code(I) := NULL;
696: ELSE
697: IF l_debug_level > 0 THEN
698: oe_debug_pub.add('calling add_mrp_rec for II ') ;
699: END IF;
700:
701: Add_MRP_Rec(
702: p_line_index => l_ii_index

Line 711: oe_debug_pub.add('After calling add_mrp_rec for II ') ;

707: ,p_header_rec => p_header_rec
708: ,p_x_atp_Rec => p_x_atp_rec
709: );
710: IF l_debug_level > 0 THEN
711: oe_debug_pub.add('After calling add_mrp_rec for II ') ;
712: END IF;
713: p_x_atp_line_map_rec(J) := l_ii_index;
714: J := J+1;
715: END IF;

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

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

Line 733: oe_debug_pub.add('Unexp Error, Load_MRP_Request');

729:
730:
731: EXCEPTION
732: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
733: oe_debug_pub.add('Unexp Error, Load_MRP_Request');
734: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
735: WHEN OTHERS THEN
736: oe_debug_pub.add('Others Error, Load_MRP_Request');
737: oe_debug_pub.add(substr(sqlerrm,1,240));

Line 736: oe_debug_pub.add('Others Error, Load_MRP_Request');

732: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
733: oe_debug_pub.add('Unexp Error, Load_MRP_Request');
734: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
735: WHEN OTHERS THEN
736: oe_debug_pub.add('Others Error, Load_MRP_Request');
737: oe_debug_pub.add(substr(sqlerrm,1,240));
738: OE_BULK_MSG_PUB.Add_Exc_Msg
739: ( G_PKG_NAME
740: , 'Load_MRP_Request'

Line 737: oe_debug_pub.add(substr(sqlerrm,1,240));

733: oe_debug_pub.add('Unexp Error, Load_MRP_Request');
734: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
735: WHEN OTHERS THEN
736: oe_debug_pub.add('Others Error, Load_MRP_Request');
737: oe_debug_pub.add(substr(sqlerrm,1,240));
738: OE_BULK_MSG_PUB.Add_Exc_Msg
739: ( G_PKG_NAME
740: , 'Load_MRP_Request'
741: );

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

758: l_promise_date_flag VARCHAR2(2);
759: l_order_date_type_code VARCHAR2(30);
760: l_hold_ii_flag VARCHAR2(1);
761: --
762: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
763: --
764: l_line_rec_for_hold OE_Order_PUB.Line_Rec_Type; --ER#7479609
765: l_header_rec_for_hold OE_Order_PUB.Header_Rec_Type; --ER#7479609
766: BEGIN

Line 770: oe_debug_pub.add('Line Index :'||p_line_index);

766: BEGIN
767:
768: if l_debug_level > 0 then
769:
770: oe_debug_pub.add('Line Index :'||p_line_index);
771: oe_debug_pub.add('ATP Index :'||p_atp_index);
772: oe_debug_pub.add('Ship Set :'||p_x_atp_rec.ship_set_name(p_atp_index));
773: oe_debug_pub.add('Error Code :'||p_x_atp_rec.error_code(p_atp_index));
774:

Line 771: oe_debug_pub.add('ATP Index :'||p_atp_index);

767:
768: if l_debug_level > 0 then
769:
770: oe_debug_pub.add('Line Index :'||p_line_index);
771: oe_debug_pub.add('ATP Index :'||p_atp_index);
772: oe_debug_pub.add('Ship Set :'||p_x_atp_rec.ship_set_name(p_atp_index));
773: oe_debug_pub.add('Error Code :'||p_x_atp_rec.error_code(p_atp_index));
774:
775: end if;

Line 772: oe_debug_pub.add('Ship Set :'||p_x_atp_rec.ship_set_name(p_atp_index));

768: if l_debug_level > 0 then
769:
770: oe_debug_pub.add('Line Index :'||p_line_index);
771: oe_debug_pub.add('ATP Index :'||p_atp_index);
772: oe_debug_pub.add('Ship Set :'||p_x_atp_rec.ship_set_name(p_atp_index));
773: oe_debug_pub.add('Error Code :'||p_x_atp_rec.error_code(p_atp_index));
774:
775: end if;
776:

Line 773: oe_debug_pub.add('Error Code :'||p_x_atp_rec.error_code(p_atp_index));

769:
770: oe_debug_pub.add('Line Index :'||p_line_index);
771: oe_debug_pub.add('ATP Index :'||p_atp_index);
772: oe_debug_pub.add('Ship Set :'||p_x_atp_rec.ship_set_name(p_atp_index));
773: oe_debug_pub.add('Error Code :'||p_x_atp_rec.error_code(p_atp_index));
774:
775: end if;
776:
777: --bug5880565

Line 995: oe_debug_pub.add( 'UNEXP ERROR , Update_Line_Rec' ) ;

991:
992: EXCEPTION
993: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
994: IF l_debug_level > 0 THEN
995: oe_debug_pub.add( 'UNEXP ERROR , Update_Line_Rec' ) ;
996: END IF;
997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
998: WHEN OTHERS THEN
999: IF l_debug_level > 0 THEN

Line 1000: oe_debug_pub.add( 'OTHERS ERROR , Update_Line_Rec' ) ;

996: END IF;
997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
998: WHEN OTHERS THEN
999: IF l_debug_level > 0 THEN
1000: oe_debug_pub.add( 'OTHERS ERROR , Update_Line_Rec' ) ;
1001: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
1002: END IF;
1003: OE_BULK_MSG_PUB.Add_Exc_Msg
1004: ( G_PKG_NAME

Line 1001: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;

997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
998: WHEN OTHERS THEN
999: IF l_debug_level > 0 THEN
1000: oe_debug_pub.add( 'OTHERS ERROR , Update_Line_Rec' ) ;
1001: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
1002: END IF;
1003: OE_BULK_MSG_PUB.Add_Exc_Msg
1004: ( G_PKG_NAME
1005: , 'Update_Line_Rec'

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

1014: )
1015: IS
1016: J NUMBER;
1017: --
1018: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1019: --
1020: BEGIN
1021:
1022: G_SCH_ERROR_TBL.DELETE;

Line 1042: oe_debug_pub.add( 'RETURNING AS ALL LINES WERE SUCCESSFUL' ) ;

1038: -- Return if all lines were successfully scheduled
1039:
1040: IF (G_SCH_ERROR_TBL.COUNT = 0) THEN
1041: IF l_debug_level > 0 THEN
1042: oe_debug_pub.add( 'RETURNING AS ALL LINES WERE SUCCESSFUL' ) ;
1043: END IF;
1044: RETURN;
1045: END IF;
1046:

Line 1057: oe_debug_pub.add( 'UNEXP ERROR , UPDATE_MRP_RESULTS' ) ;

1053:
1054: EXCEPTION
1055: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1056: IF l_debug_level > 0 THEN
1057: oe_debug_pub.add( 'UNEXP ERROR , UPDATE_MRP_RESULTS' ) ;
1058: END IF;
1059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1060: WHEN OTHERS THEN
1061: IF l_debug_level > 0 THEN

Line 1062: oe_debug_pub.add( 'OTHERS ERROR , UPDATE_MRP_RESULTS' ) ;

1058: END IF;
1059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1060: WHEN OTHERS THEN
1061: IF l_debug_level > 0 THEN
1062: oe_debug_pub.add( 'OTHERS ERROR , UPDATE_MRP_RESULTS' ) ;
1063: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
1064: END IF;
1065: OE_BULK_MSG_PUB.Add_Exc_Msg
1066: ( G_PKG_NAME

Line 1063: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;

1059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1060: WHEN OTHERS THEN
1061: IF l_debug_level > 0 THEN
1062: oe_debug_pub.add( 'OTHERS ERROR , UPDATE_MRP_RESULTS' ) ;
1063: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
1064: END IF;
1065: OE_BULK_MSG_PUB.Add_Exc_Msg
1066: ( G_PKG_NAME
1067: , 'Update_MRP_Results'

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

1095: l_start_time NUMBER;
1096: l_end_time NUMBER;
1097: l_atp_line_map_rec OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
1098: --
1099: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1100: --
1101: BEGIN
1102:
1103: ------------------------------------------------------------------

Line 1119: oe_debug_pub.add( 'THIS IS INACTIVE DEMAND LINE' , 1 ) ;

1115: IF NVL(fnd_profile.value('ONT_BYPASS_ATP'),'N') = 'Y' THEN
1116: -- this is an inactive demand line.
1117:
1118: IF l_debug_level > 0 THEN
1119: oe_debug_pub.add( 'THIS IS INACTIVE DEMAND LINE' , 1 ) ;
1120: END IF;
1121: Inactive_Demand_Scheduling(
1122: p_line_rec => p_line_rec
1123: ,x_return_status => x_return_status);

Line 1144: oe_debug_pub.add('No lines to schedule');

1140:
1141: IF l_mrp_atp_rec.identifier.count = 0
1142: OR l_mrp_atp_rec.inventory_item_id(1) IS NULL THEN
1143: IF l_debug_level > 0 THEN
1144: oe_debug_pub.add('No lines to schedule');
1145: END IF;
1146: RETURN;
1147: END IF;
1148:

Line 1182: oe_debug_pub.add( '3. AFTER CALL_ATP , STATUS:' ||X_RETURN_STATUS , 1 ) ;

1178: , x_msg_data => l_mrp_msg_data
1179: , x_msg_count => l_msg_count);
1180:
1181: IF l_debug_level > 0 THEN
1182: oe_debug_pub.add( '3. AFTER CALL_ATP , STATUS:' ||X_RETURN_STATUS , 1 ) ;
1183: -- Bug 5640601 =>
1184: -- Selecting hsecs from v$times is changed to execute only when debug
1185: -- is enabled, as hsec is used for logging only when debug is enabled.
1186: SELECT hsecs INTO l_end_time from v$timer;

Line 1206: oe_debug_pub.add( 'Exiting SCHEDULE_ORDERS' ) ;

1202: );
1203:
1204: END IF;
1205: IF l_debug_level > 0 THEN
1206: oe_debug_pub.add( 'Exiting SCHEDULE_ORDERS' ) ;
1207: END IF;
1208:
1209: EXCEPTION
1210: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1212: oe_debug_pub.add( 'UNEXP ERROR , SCHEDULE_ORDERS' ) ;

1208:
1209: EXCEPTION
1210: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1211: IF l_debug_level > 0 THEN
1212: oe_debug_pub.add( 'UNEXP ERROR , SCHEDULE_ORDERS' ) ;
1213: END IF;
1214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1215: WHEN OTHERS THEN
1216: IF l_debug_level > 0 THEN

Line 1217: oe_debug_pub.add( 'OTHERS ERROR , SCHEDULE_ORDERS' ) ;

1213: END IF;
1214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1215: WHEN OTHERS THEN
1216: IF l_debug_level > 0 THEN
1217: oe_debug_pub.add( 'OTHERS ERROR , SCHEDULE_ORDERS' ) ;
1218: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
1219: END IF;
1220: OE_BULK_MSG_PUB.Add_Exc_Msg
1221: ( G_PKG_NAME

Line 1218: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;

1214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1215: WHEN OTHERS THEN
1216: IF l_debug_level > 0 THEN
1217: oe_debug_pub.add( 'OTHERS ERROR , SCHEDULE_ORDERS' ) ;
1218: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
1219: END IF;
1220: OE_BULK_MSG_PUB.Add_Exc_Msg
1221: ( G_PKG_NAME
1222: , 'Schedule_Orders'

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

1236: RETURN VARCHAR2
1237: IS
1238: l_order_date_type_code VARCHAR2(30) := null;
1239: --
1240: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1241: --
1242: BEGIN
1243: IF p_header_id <> nvl(G_HEADER_ID,0) THEN
1244: BEGIN