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

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

20: l_atp_tbl OE_ATP.atp_tbl_type;
21: --- 2697690 --
22: l_scheduling_level_code VARCHAR2(30) := NULL;
23: --
24: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
25: --
26: l_validity_flag NUMBER := 0; -- for bug 2549166
27:
28: BEGIN

Line 31: oe_debug_pub.add( 'ENTERING ATP_CHECK' , 1 ) ;

27:
28: BEGIN
29:
30: IF l_debug_level > 0 THEN
31: oe_debug_pub.add( 'ENTERING ATP_CHECK' , 1 ) ;
32: oe_debug_pub.add( 'BEFORE FIRST ASSIGN ATPREC' , 3 ) ;
33: oe_debug_pub.add( 'NEW LINE TYPE : '||TO_CHAR ( P_LINE_ATP_REC.LINE_TYPE_ID ) , 3 ) ;
34: oe_debug_pub.add( 'OLD LINE TYPE : '||TO_CHAR ( P_OLD_LINE_ATP_REC.LINE_TYPE_ID ) , 3 ) ;
35: END IF;

Line 32: oe_debug_pub.add( 'BEFORE FIRST ASSIGN ATPREC' , 3 ) ;

28: BEGIN
29:
30: IF l_debug_level > 0 THEN
31: oe_debug_pub.add( 'ENTERING ATP_CHECK' , 1 ) ;
32: oe_debug_pub.add( 'BEFORE FIRST ASSIGN ATPREC' , 3 ) ;
33: oe_debug_pub.add( 'NEW LINE TYPE : '||TO_CHAR ( P_LINE_ATP_REC.LINE_TYPE_ID ) , 3 ) ;
34: oe_debug_pub.add( 'OLD LINE TYPE : '||TO_CHAR ( P_OLD_LINE_ATP_REC.LINE_TYPE_ID ) , 3 ) ;
35: END IF;
36:

Line 33: oe_debug_pub.add( 'NEW LINE TYPE : '||TO_CHAR ( P_LINE_ATP_REC.LINE_TYPE_ID ) , 3 ) ;

29:
30: IF l_debug_level > 0 THEN
31: oe_debug_pub.add( 'ENTERING ATP_CHECK' , 1 ) ;
32: oe_debug_pub.add( 'BEFORE FIRST ASSIGN ATPREC' , 3 ) ;
33: oe_debug_pub.add( 'NEW LINE TYPE : '||TO_CHAR ( P_LINE_ATP_REC.LINE_TYPE_ID ) , 3 ) ;
34: oe_debug_pub.add( 'OLD LINE TYPE : '||TO_CHAR ( P_OLD_LINE_ATP_REC.LINE_TYPE_ID ) , 3 ) ;
35: END IF;
36:
37: -- Check Min Attributes Required to do ATP

Line 34: oe_debug_pub.add( 'OLD LINE TYPE : '||TO_CHAR ( P_OLD_LINE_ATP_REC.LINE_TYPE_ID ) , 3 ) ;

30: IF l_debug_level > 0 THEN
31: oe_debug_pub.add( 'ENTERING ATP_CHECK' , 1 ) ;
32: oe_debug_pub.add( 'BEFORE FIRST ASSIGN ATPREC' , 3 ) ;
33: oe_debug_pub.add( 'NEW LINE TYPE : '||TO_CHAR ( P_LINE_ATP_REC.LINE_TYPE_ID ) , 3 ) ;
34: oe_debug_pub.add( 'OLD LINE TYPE : '||TO_CHAR ( P_OLD_LINE_ATP_REC.LINE_TYPE_ID ) , 3 ) ;
35: END IF;
36:
37: -- Check Min Attributes Required to do ATP
38:

Line 40: oe_debug_pub.add( 'R1' , 3 ) ;

36:
37: -- Check Min Attributes Required to do ATP
38:
39: IF l_debug_level > 0 THEN
40: oe_debug_pub.add( 'R1' , 3 ) ;
41: END IF;
42: IF (p_line_atp_rec.inventory_item_id IS null) OR
43: (p_line_atp_rec.inventory_item_id = FND_API.G_MISS_NUM)
44: THEN

Line 50: oe_debug_pub.add( 'R2' , 3 ) ;

46: goto end_atp_check;
47: END IF;
48:
49: IF l_debug_level > 0 THEN
50: oe_debug_pub.add( 'R2' , 3 ) ;
51: END IF;
52: IF (p_line_atp_rec.ordered_quantity IS null) OR
53: (p_line_atp_rec.ordered_quantity = FND_API.G_MISS_NUM) OR
54: (p_line_atp_rec.ordered_quantity <= 0) OR

Line 58: oe_debug_pub.add( 'ORDERED_QUANTITY IS NULL' , 3 ) ;

54: (p_line_atp_rec.ordered_quantity <= 0) OR
55: (p_line_atp_rec.line_category_code = 'RETURN')
56: THEN
57: IF l_debug_level > 0 THEN
58: oe_debug_pub.add( 'ORDERED_QUANTITY IS NULL' , 3 ) ;
59: END IF;
60: goto end_atp_check;
61: END IF;
62:

Line 64: oe_debug_pub.add( 'R3' , 3 ) ;

60: goto end_atp_check;
61: END IF;
62:
63: IF l_debug_level > 0 THEN
64: oe_debug_pub.add( 'R3' , 3 ) ;
65: END IF;
66: IF (p_line_atp_rec.order_quantity_uom IS null) OR
67: (p_line_atp_rec.order_quantity_uom = FND_API.G_MISS_CHAR)
68: THEN

Line 74: oe_debug_pub.add( 'R4' , 3 ) ;

70: goto end_atp_check;
71: END IF;
72:
73: IF l_debug_level > 0 THEN
74: oe_debug_pub.add( 'R4' , 3 ) ;
75: END IF;
76: IF (p_line_atp_rec.request_date IS null) OR
77: (p_line_atp_rec.request_date = FND_API.G_MISS_DATE)
78: THEN

Line 84: oe_debug_pub.add( 'R5 ', 3 ) ;

80: goto end_atp_check;
81: END IF;
82:
83: IF l_debug_level > 0 THEN
84: oe_debug_pub.add( 'R5 ', 3 ) ;
85: END IF;
86:
87: -- 3670442 : added check for External source and close order
88: IF p_line_atp_rec.source_type_code = OE_GLOBALS.G_SOURCE_EXTERNAL

Line 91: oe_debug_pub.add( 'INVALID SOURCE TYPE '||p_line_atp_rec.source_type_code , 3 ) ;

87: -- 3670442 : added check for External source and close order
88: IF p_line_atp_rec.source_type_code = OE_GLOBALS.G_SOURCE_EXTERNAL
89: THEN
90: IF l_debug_level > 0 THEN
91: oe_debug_pub.add( 'INVALID SOURCE TYPE '||p_line_atp_rec.source_type_code , 3 ) ;
92: END IF;
93: goto end_atp_check;
94: END IF;
95:

Line 99: oe_debug_pub.add( 'LINE IS SHIPPED' , 3 ) ;

95:
96: IF (p_line_atp_rec.shipped_quantity is not null) AND
97: (p_line_atp_rec.shipped_quantity <> FND_API.G_MISS_NUM) THEN
98: IF l_debug_level > 0 THEN
99: oe_debug_pub.add( 'LINE IS SHIPPED' , 3 ) ;
100: END IF;
101: goto end_atp_check;
102: END IF;
103:

Line 107: oe_debug_pub.add( 'IT IS A CLOSED LINE' , 3 ) ;

103:
104: IF NVL(p_line_atp_rec.open_flag,'Y') = 'N'
105: THEN
106: IF l_debug_level > 0 THEN
107: oe_debug_pub.add( 'IT IS A CLOSED LINE' , 3 ) ;
108: END IF;
109: goto end_atp_check;
110: END IF;
111:

Line 115: oe_debug_pub.add( 'NOT A STANDARD LINE' , 3 ) ;

111:
112: IF (p_line_atp_rec.item_type_code <> OE_GLOBALS.G_ITEM_STANDARD)
113: THEN
114: IF l_debug_level > 0 THEN
115: oe_debug_pub.add( 'NOT A STANDARD LINE' , 3 ) ;
116: END IF;
117: goto end_atp_check;
118: END IF;
119:

Line 121: oe_debug_pub.add( 'R6' , 3 ) ;

117: goto end_atp_check;
118: END IF;
119:
120: IF l_debug_level > 0 THEN
121: oe_debug_pub.add( 'R6' , 3 ) ;
122: END IF;
123:
124: --Added for Bug 2549166
125:

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

141: AND rownum=1;
142: EXCEPTION
143: WHEN NO_DATA_FOUND THEN
144: IF l_debug_level > 0 THEN
145: oe_debug_pub.add('INVALID ITEM WAREHOUSE COMBINATION',3);
146: END IF;
147: goto end_atp_check;
148: END;
149: END IF;

Line 151: oe_debug_pub.add('R7',3);

147: goto end_atp_check;
148: END;
149: END IF;
150: IF l_debug_level > 0 THEN
151: oe_debug_pub.add('R7',3);
152: END IF;
153:
154: --End of Modification for Bug 2549166
155:

Line 166: oe_debug_pub.add( 'FOUR AND FIVE CANNOT HAVE ATP PERFORMED' , 3 ) ;

162: l_scheduling_level_code = OE_SCHEDULE_UTIL.SCH_LEVEL_FIVE OR
163: NVL(fnd_profile.value('ONT_BYPASS_ATP'),'N') = 'Y' THEN
164:
165: IF l_debug_level > 0 THEN
166: oe_debug_pub.add( 'FOUR AND FIVE CANNOT HAVE ATP PERFORMED' , 3 ) ;
167: END IF;
168:
169: -- start 3431595
170: IF p_line_atp_rec.p_pa_call then

Line 196: oe_debug_pub.add( 'AFTER FIRST ASSIGN ATPREC' , 3 ) ;

192: Assign_Atprec(p_line_atp_rec => p_old_line_atp_rec
193: ,x_line_rec => l_old_line_rec);
194:
195: IF l_debug_level > 0 THEN
196: oe_debug_pub.add( 'AFTER FIRST ASSIGN ATPREC' , 3 ) ;
197: END IF;
198: IF l_debug_level > 0 THEN
199: oe_debug_pub.add( 'LINE TYPE ON LINE : '||TO_CHAR ( L_OLD_LINE_REC.LINE_TYPE_ID ) , 3 ) ;
200: END IF;

Line 199: oe_debug_pub.add( 'LINE TYPE ON LINE : '||TO_CHAR ( L_OLD_LINE_REC.LINE_TYPE_ID ) , 3 ) ;

195: IF l_debug_level > 0 THEN
196: oe_debug_pub.add( 'AFTER FIRST ASSIGN ATPREC' , 3 ) ;
197: END IF;
198: IF l_debug_level > 0 THEN
199: oe_debug_pub.add( 'LINE TYPE ON LINE : '||TO_CHAR ( L_OLD_LINE_REC.LINE_TYPE_ID ) , 3 ) ;
200: END IF;
201:
202: Assign_Atprec(p_line_atp_rec => p_line_atp_rec
203: ,x_line_rec => l_line_rec);

Line 206: oe_debug_pub.add( 'LINE TYPE ON LINE NEW : '||TO_CHAR ( L_LINE_REC.LINE_TYPE_ID ) , 3 ) ;

202: Assign_Atprec(p_line_atp_rec => p_line_atp_rec
203: ,x_line_rec => l_line_rec);
204:
205: IF l_debug_level > 0 THEN
206: oe_debug_pub.add( 'LINE TYPE ON LINE NEW : '||TO_CHAR ( L_LINE_REC.LINE_TYPE_ID ) , 3 ) ;
207: END IF;
208:
209: l_line_rec.item_type_code := OE_GLOBALS.G_ITEM_STANDARD;
210: l_line_rec.schedule_action_code := OE_ORDER_SCH_UTIL.OESCH_ACT_ATP_CHECK;

Line 215: oe_debug_pub.add( 'SCH:CALLING OE_SCHEDULE_UTIL.ATP_CHECK' , 2 ) ;

211:
212: -- Bug4504362
213:
214: IF l_debug_level > 0 THEN
215: oe_debug_pub.add( 'SCH:CALLING OE_SCHEDULE_UTIL.ATP_CHECK' , 2 ) ;
216: END IF;
217:
218: OE_SCHEDULE_UTIL.atp_check(
219: p_old_line_rec => l_old_line_rec,

Line 233: oe_debug_pub.add( 'PRINTING THE ATP RECORD' , 3 ) ;

229: RAISE FND_API.G_EXC_ERROR;
230: END IF;
231:
232: IF l_debug_level > 0 THEN
233: oe_debug_pub.add( 'PRINTING THE ATP RECORD' , 3 ) ;
234: END IF;
235:
236: x_atp_rec := l_atp_tbl(1);
237:

Line 241: oe_debug_pub.add( 'EXITING ATP_CHECK' || X_RETURN_STATUS , 1 ) ;

237:
238: <>
239: null;
240: IF l_debug_level > 0 THEN
241: oe_debug_pub.add( 'EXITING ATP_CHECK' || X_RETURN_STATUS , 1 ) ;
242: END IF;
243:
244: EXCEPTION
245: WHEN FND_API.G_EXC_ERROR THEN

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

267: Procedure Assign_Atprec(p_line_atp_rec IN line_atp_rec_type
268: ,x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type)
269: IS
270: --
271: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
272: --
273: BEGIN
274: x_line_rec.arrival_set_id := p_line_atp_rec.arrival_set_id;
275: x_line_rec.ato_line_id := p_line_atp_rec.ato_line_id;

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

319: l_entity_type VARCHAR2(30);
320: l_entity_id NUMBER;
321: l_group_req_rec OE_GRP_SCH_UTIL.Sch_Group_Rec_Type;
322: --
323: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
324: --
325: BEGIN
326:
327: IF l_debug_level > 0 THEN

Line 328: oe_debug_pub.add( 'ENTERING ATP_INQUIRY' , 1 ) ;

324: --
325: BEGIN
326:
327: IF l_debug_level > 0 THEN
328: oe_debug_pub.add( 'ENTERING ATP_INQUIRY' , 1 ) ;
329: END IF;
330: l_entity_type := p_entity_type;
331: l_entity_id := p_entity_id;
332:

Line 354: oe_debug_pub.add( 'CALLING ATP_CHECK' , 2 ) ;

350: OE_Line_Util.Query_Row(p_line_id => l_entity_id,
351: x_line_rec => l_line_atp_rec);
352:
353: IF l_debug_level > 0 THEN
354: oe_debug_pub.add( 'CALLING ATP_CHECK' , 2 ) ;
355: END IF;
356:
357: /* ATP_Check(p_line_atp_rec => l_line_atp_rec
358: ,p_old_line_atp_rec => l_line_atp_rec

Line 373: oe_debug_pub.add( 'EXITING ATP_INQUIRY' , 1 ) ;

369:
370: x_atp_tbl(1) := l_out_atp_rec;
371:
372: IF l_debug_level > 0 THEN
373: oe_debug_pub.add( 'EXITING ATP_INQUIRY' , 1 ) ;
374: END IF;
375:
376: EXCEPTION
377: WHEN FND_API.G_EXC_ERROR THEN