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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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 734: oe_debug_pub.add('Unexp Error, Load_MRP_Request');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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