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.AHL_LTP_MATRL_AVAL_PVT dependencies on FND_LOG

Line 9: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;

5: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
6: ------------------------------------
7: -- Common constants and variables --
8: ------------------------------------
9: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
10: l_log_statement NUMBER := fnd_log.level_statement;
11: l_log_procedure NUMBER := fnd_log.level_procedure;
12: l_log_error NUMBER := fnd_log.level_error;
13: l_log_unexpected NUMBER := fnd_log.level_unexpected;

Line 10: l_log_statement NUMBER := fnd_log.level_statement;

6: ------------------------------------
7: -- Common constants and variables --
8: ------------------------------------
9: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
10: l_log_statement NUMBER := fnd_log.level_statement;
11: l_log_procedure NUMBER := fnd_log.level_procedure;
12: l_log_error NUMBER := fnd_log.level_error;
13: l_log_unexpected NUMBER := fnd_log.level_unexpected;
14: -----------------------------------------------------------------------

Line 11: l_log_procedure NUMBER := fnd_log.level_procedure;

7: -- Common constants and variables --
8: ------------------------------------
9: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
10: l_log_statement NUMBER := fnd_log.level_statement;
11: l_log_procedure NUMBER := fnd_log.level_procedure;
12: l_log_error NUMBER := fnd_log.level_error;
13: l_log_unexpected NUMBER := fnd_log.level_unexpected;
14: -----------------------------------------------------------------------
15: --

Line 12: l_log_error NUMBER := fnd_log.level_error;

8: ------------------------------------
9: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
10: l_log_statement NUMBER := fnd_log.level_statement;
11: l_log_procedure NUMBER := fnd_log.level_procedure;
12: l_log_error NUMBER := fnd_log.level_error;
13: l_log_unexpected NUMBER := fnd_log.level_unexpected;
14: -----------------------------------------------------------------------
15: --
16: -- PACKAGE

Line 13: l_log_unexpected NUMBER := fnd_log.level_unexpected;

9: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
10: l_log_statement NUMBER := fnd_log.level_statement;
11: l_log_procedure NUMBER := fnd_log.level_procedure;
12: l_log_error NUMBER := fnd_log.level_error;
13: l_log_unexpected NUMBER := fnd_log.level_unexpected;
14: -----------------------------------------------------------------------
15: --
16: -- PACKAGE
17: -- AHL_LTP_MATRL_AVAL_PVT

Line 100: fnd_log.string(l_log_procedure,

96: i pls_integer;
97: BEGIN
98:
99: IF (l_log_procedure >= l_log_current_level) THEN
100: fnd_log.string(l_log_procedure,
101: L_DEBUG_KEY ||'.begin',
102: 'At the start of PL SQL procedure. Inventory item ID : ' || p_inventory_item_id);
103: END IF;
104:

Line 124: fnd_log.string(l_log_statement,

120: SELECT MRP_ATP_SCHEDULE_TEMP_S.NEXTVAL
121: INTO l_session_id FROM DUAL;
122:
123: IF (l_log_statement >= l_log_current_level) THEN
124: fnd_log.string(l_log_statement,
125: L_DEBUG_KEY,
126: 'Session Id : '||l_session_id);
127: END IF;
128:

Line 142: fnd_log.string(l_log_statement,

138: END IF;
139: CLOSE Instance_Id_Cur;
140: --
141: IF (l_log_statement >= l_log_current_level) THEN
142: fnd_log.string(l_log_statement,
143: L_DEBUG_KEY,
144: 'Instance Id : '||l_instance_id ||
145: ', Identifier : '||l_identifier);
146: END IF;

Line 191: fnd_log.string(l_log_statement,

187: l_atp_table.Error_Code := Mrp_Atp_Pub.number_arr(NULL);
188: l_atp_table.Message := Mrp_Atp_Pub.char2000_arr(NULL);
189:
190: IF (l_log_statement >= l_log_current_level) THEN
191: fnd_log.string(l_log_statement,
192: L_DEBUG_KEY,
193: 'Inventory Item Id : '||l_atp_table.Inventory_Item_Id(1));
194: fnd_log.string(l_log_statement,
195: L_DEBUG_KEY,

Line 194: fnd_log.string(l_log_statement,

190: IF (l_log_statement >= l_log_current_level) THEN
191: fnd_log.string(l_log_statement,
192: L_DEBUG_KEY,
193: 'Inventory Item Id : '||l_atp_table.Inventory_Item_Id(1));
194: fnd_log.string(l_log_statement,
195: L_DEBUG_KEY,
196: 'Requested Date : '||l_atp_table.Requested_ship_Date(1));
197: fnd_log.string(l_log_statement,
198: L_DEBUG_KEY,

Line 197: fnd_log.string(l_log_statement,

193: 'Inventory Item Id : '||l_atp_table.Inventory_Item_Id(1));
194: fnd_log.string(l_log_statement,
195: L_DEBUG_KEY,
196: 'Requested Date : '||l_atp_table.Requested_ship_Date(1));
197: fnd_log.string(l_log_statement,
198: L_DEBUG_KEY,
199: 'Calling Module : '||l_atp_table.Calling_Module(1));
200: fnd_log.string(l_log_statement,
201: L_DEBUG_KEY,

Line 200: fnd_log.string(l_log_statement,

196: 'Requested Date : '||l_atp_table.Requested_ship_Date(1));
197: fnd_log.string(l_log_statement,
198: L_DEBUG_KEY,
199: 'Calling Module : '||l_atp_table.Calling_Module(1));
200: fnd_log.string(l_log_statement,
201: L_DEBUG_KEY,
202: 'Organization Id : '||l_atp_table.Source_Organization_id(1));
203: fnd_log.string(l_log_statement,
204: L_DEBUG_KEY,

Line 203: fnd_log.string(l_log_statement,

199: 'Calling Module : '||l_atp_table.Calling_Module(1));
200: fnd_log.string(l_log_statement,
201: L_DEBUG_KEY,
202: 'Organization Id : '||l_atp_table.Source_Organization_id(1));
203: fnd_log.string(l_log_statement,
204: L_DEBUG_KEY,
205: 'Old Organization Id : '||l_atp_table.Old_Source_Organization_Id(1));
206: fnd_log.string(l_log_statement,
207: L_DEBUG_KEY,

Line 206: fnd_log.string(l_log_statement,

202: 'Organization Id : '||l_atp_table.Source_Organization_id(1));
203: fnd_log.string(l_log_statement,
204: L_DEBUG_KEY,
205: 'Old Organization Id : '||l_atp_table.Old_Source_Organization_Id(1));
206: fnd_log.string(l_log_statement,
207: L_DEBUG_KEY,
208: 'l_atp_table.demand_source_type : '||l_atp_table.demand_source_type(1));
209: fnd_log.string(l_log_statement,
210: L_DEBUG_KEY,

Line 209: fnd_log.string(l_log_statement,

205: 'Old Organization Id : '||l_atp_table.Old_Source_Organization_Id(1));
206: fnd_log.string(l_log_statement,
207: L_DEBUG_KEY,
208: 'l_atp_table.demand_source_type : '||l_atp_table.demand_source_type(1));
209: fnd_log.string(l_log_statement,
210: L_DEBUG_KEY,
211: 'Quantity Ordered : '||l_atp_table.Quantity_Ordered(1));
212: fnd_log.string(l_log_statement,
213: L_DEBUG_KEY,

Line 212: fnd_log.string(l_log_statement,

208: 'l_atp_table.demand_source_type : '||l_atp_table.demand_source_type(1));
209: fnd_log.string(l_log_statement,
210: L_DEBUG_KEY,
211: 'Quantity Ordered : '||l_atp_table.Quantity_Ordered(1));
212: fnd_log.string(l_log_statement,
213: L_DEBUG_KEY,
214: 'Action : '||l_atp_table.Action(1));
215: END IF;
216:

Line 218: fnd_log.string(l_log_statement,

214: 'Action : '||l_atp_table.Action(1));
215: END IF;
216:
217: IF (l_log_statement >= l_log_current_level) THEN
218: fnd_log.string(l_log_statement,
219: L_DEBUG_KEY,
220: 'Before calling Mrp Atp Pub.Call_ATP');
221: END IF;
222:

Line 236: fnd_log.string(l_log_statement,

232: l_msg_data,
233: l_msg_count);
234:
235: IF (l_log_statement >= l_log_current_level) THEN
236: fnd_log.string(l_log_statement,
237: L_DEBUG_KEY,
238: 'After calling Mrp Atp Pub.Call_ATP. Return Status : '|| l_return_status);
239: END IF;
240:

Line 253: fnd_log.string(l_log_statement,

249: -- SKPATHAK :: Bug 12833742 :: 11-AUG-2011 :: Commented the below
250: --MSC_ATP_GLOBAL.Extend_ATP(x_atp_table, x_return_status);
251:
252: IF (l_log_statement >= l_log_current_level) THEN
253: fnd_log.string(l_log_statement,
254: L_DEBUG_KEY,
255: 'Ship Date => '||x_atp_table.ship_date(1));
256: fnd_log.string(l_log_statement,
257: L_DEBUG_KEY,

Line 256: fnd_log.string(l_log_statement,

252: IF (l_log_statement >= l_log_current_level) THEN
253: fnd_log.string(l_log_statement,
254: L_DEBUG_KEY,
255: 'Ship Date => '||x_atp_table.ship_date(1));
256: fnd_log.string(l_log_statement,
257: L_DEBUG_KEY,
258: 'Inventory Item Id : '||x_atp_table.Inventory_Item_Id(1));
259: fnd_log.string(l_log_statement,
260: L_DEBUG_KEY,

Line 259: fnd_log.string(l_log_statement,

255: 'Ship Date => '||x_atp_table.ship_date(1));
256: fnd_log.string(l_log_statement,
257: L_DEBUG_KEY,
258: 'Inventory Item Id : '||x_atp_table.Inventory_Item_Id(1));
259: fnd_log.string(l_log_statement,
260: L_DEBUG_KEY,
261: 'Organization Id : '||x_atp_table.Source_Organization_Id(1));
262: fnd_log.string(l_log_statement,
263: L_DEBUG_KEY,

Line 262: fnd_log.string(l_log_statement,

258: 'Inventory Item Id : '||x_atp_table.Inventory_Item_Id(1));
259: fnd_log.string(l_log_statement,
260: L_DEBUG_KEY,
261: 'Organization Id : '||x_atp_table.Source_Organization_Id(1));
262: fnd_log.string(l_log_statement,
263: L_DEBUG_KEY,
264: 'Organization Code : '||x_atp_table.Source_Organization_code(1));
265: fnd_log.string(l_log_statement,
266: L_DEBUG_KEY,

Line 265: fnd_log.string(l_log_statement,

261: 'Organization Id : '||x_atp_table.Source_Organization_Id(1));
262: fnd_log.string(l_log_statement,
263: L_DEBUG_KEY,
264: 'Organization Code : '||x_atp_table.Source_Organization_code(1));
265: fnd_log.string(l_log_statement,
266: L_DEBUG_KEY,
267: 'Quantity Ordered : '||x_atp_table.Quantity_Ordered(1));
268: fnd_log.string(l_log_statement,
269: L_DEBUG_KEY,

Line 268: fnd_log.string(l_log_statement,

264: 'Organization Code : '||x_atp_table.Source_Organization_code(1));
265: fnd_log.string(l_log_statement,
266: L_DEBUG_KEY,
267: 'Quantity Ordered : '||x_atp_table.Quantity_Ordered(1));
268: fnd_log.string(l_log_statement,
269: L_DEBUG_KEY,
270: 'Requested Ship Date : '||x_atp_table.Requested_Ship_Date(1));
271: fnd_log.string(l_log_statement,
272: L_DEBUG_KEY,

Line 271: fnd_log.string(l_log_statement,

267: 'Quantity Ordered : '||x_atp_table.Quantity_Ordered(1));
268: fnd_log.string(l_log_statement,
269: L_DEBUG_KEY,
270: 'Requested Ship Date : '||x_atp_table.Requested_Ship_Date(1));
271: fnd_log.string(l_log_statement,
272: L_DEBUG_KEY,
273: 'Requested Arrival Date : '||x_atp_table.Requested_arrival_Date(1));
274: fnd_log.string(l_log_statement,
275: L_DEBUG_KEY,

Line 274: fnd_log.string(l_log_statement,

270: 'Requested Ship Date : '||x_atp_table.Requested_Ship_Date(1));
271: fnd_log.string(l_log_statement,
272: L_DEBUG_KEY,
273: 'Requested Arrival Date : '||x_atp_table.Requested_arrival_Date(1));
274: fnd_log.string(l_log_statement,
275: L_DEBUG_KEY,
276: 'Arrival Date : '||x_atp_table.Arrival_Date(1));
277: fnd_log.string(l_log_statement,
278: L_DEBUG_KEY,

Line 277: fnd_log.string(l_log_statement,

273: 'Requested Arrival Date : '||x_atp_table.Requested_arrival_Date(1));
274: fnd_log.string(l_log_statement,
275: L_DEBUG_KEY,
276: 'Arrival Date : '||x_atp_table.Arrival_Date(1));
277: fnd_log.string(l_log_statement,
278: L_DEBUG_KEY,
279: 'Available Quantity : '||x_atp_table.Available_Quantity(1));
280: fnd_log.string(l_log_statement,
281: L_DEBUG_KEY,

Line 280: fnd_log.string(l_log_statement,

276: 'Arrival Date : '||x_atp_table.Arrival_Date(1));
277: fnd_log.string(l_log_statement,
278: L_DEBUG_KEY,
279: 'Available Quantity : '||x_atp_table.Available_Quantity(1));
280: fnd_log.string(l_log_statement,
281: L_DEBUG_KEY,
282: 'Requested Date Quantity : '||x_atp_table.Requested_Date_Quantity(1));
283: fnd_log.string(l_log_statement,
284: L_DEBUG_KEY,

Line 283: fnd_log.string(l_log_statement,

279: 'Available Quantity : '||x_atp_table.Available_Quantity(1));
280: fnd_log.string(l_log_statement,
281: L_DEBUG_KEY,
282: 'Requested Date Quantity : '||x_atp_table.Requested_Date_Quantity(1));
283: fnd_log.string(l_log_statement,
284: L_DEBUG_KEY,
285: 'Error Code : '||x_atp_table.Error_Code(1));
286: fnd_log.string(l_log_statement,
287: L_DEBUG_KEY,

Line 286: fnd_log.string(l_log_statement,

282: 'Requested Date Quantity : '||x_atp_table.Requested_Date_Quantity(1));
283: fnd_log.string(l_log_statement,
284: L_DEBUG_KEY,
285: 'Error Code : '||x_atp_table.Error_Code(1));
286: fnd_log.string(l_log_statement,
287: L_DEBUG_KEY,
288: 'Pub Message : '||x_atp_table.Message(1));
289: END IF;
290:

Line 307: fnd_log.string(l_log_statement,

303: x_available_qty := trunc(x_atp_table.Available_Quantity(1));
304: x_error_code := x_atp_table.Error_code(1);
305:
306: IF (l_log_statement >= l_log_current_level) THEN
307: fnd_log.string(l_log_statement,
308: L_DEBUG_KEY,
309: 'After Calling Mrp Atp Pub. Error Code = ' || x_error_code ||
310: ', Available Quantity : '||x_available_qty);
311: END IF;

Line 319: fnd_log.string(l_log_statement,

315: FETCH Error_Message_Cur INTO x_error_message;
316: CLOSE Error_Message_Cur;
317:
318: IF (l_log_statement >= l_log_current_level) THEN
319: fnd_log.string(l_log_statement,
320: L_DEBUG_KEY,
321: 'After Calling Mrp Atp Pub Error Message : '||x_error_message);
322: END IF;
323: ELSE

Line 327: fnd_log.string(l_log_statement,

323: ELSE
324: MSC_ATP_GLOBAL.Extend_ATP(x_atp_table, l_return_status);
325:
326: IF (l_log_statement >= l_log_current_level) THEN
327: fnd_log.string(l_log_statement,
328: L_DEBUG_KEY,
329: 'After calling MSC EXTEND');
330: END IF;
331:

Line 338: fnd_log.string(l_log_statement,

334:
335: x_available_qty := trunc(x_atp_table.Available_Quantity(1));
336:
337: IF (l_log_statement >= l_log_current_level) THEN
338: fnd_log.string(l_log_statement,
339: L_DEBUG_KEY,
340: 'After ERROR CODE : '||x_error_code);
341: END IF;
342: --Get from mfg lookups

Line 348: fnd_log.string(l_log_statement,

344: FETCH Error_Message_Cur INTO x_error_message;
345: CLOSE Error_Message_Cur;
346:
347: IF (l_log_statement >= l_log_current_level) THEN
348: fnd_log.string(l_log_statement,
349: L_DEBUG_KEY,
350: 'Interface Error Message from mfg lookups : '||x_error_message);
351:
352: END IF;

Line 358: fnd_log.string(l_log_statement,

354: END IF;--Error code
355: END IF;
356:
357: IF (l_log_statement >= l_log_current_level) THEN
358: fnd_log.string(l_log_statement,
359: L_DEBUG_KEY,
360: 'Derived from Mrp Atp Pub Available Quantity : '||x_available_qty);
361: END IF;
362:

Line 372: fnd_log.string(l_log_procedure,

368: END IF;
369: END IF;
370:
371: IF (l_log_procedure >= l_log_current_level) THEN
372: fnd_log.string(l_log_procedure,
373: L_DEBUG_KEY ||'.end',
374: 'At the end of PL SQL procedure. Return Status = ' || x_return_status);
375: END IF;
376:

Line 479: fnd_log.string(l_log_procedure,

475: l_error_message VARCHAR2(2000);
476:
477: BEGIN
478: IF (l_log_procedure >= l_log_current_level) THEN
479: fnd_log.string(l_log_procedure,
480: L_DEBUG_KEY ||'.begin',
481: 'At the start of PL SQL procedure.');
482: END IF;
483: -- dbms_output.put_line( 'start private API:');

Line 504: fnd_log.string(l_log_statement,

500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
501: END IF;
502:
503: IF (l_log_statement >= l_log_current_level)THEN
504: fnd_log.string(l_log_statement,
505: L_DEBUG_KEY,
506: 'Request for Check Material Availability for Viist item ID : ' ||
507: p_x_material_avl_tbl(1).visit_id);
508: END IF;

Line 522: fnd_log.string(l_log_statement,

518: END IF;
519: CLOSE Check_Sch_Visit_cur;
520: --
521: IF (l_log_statement >= l_log_current_level)THEN
522: fnd_log.string(l_log_statement,
523: L_DEBUG_KEY,
524: 'Request for Check Material Availability for Material Records : ' ||
525: p_x_material_avl_tbl.COUNT);
526: END IF;

Line 532: fnd_log.string(l_log_statement,

528: IF p_x_material_avl_tbl.COUNT > 0 THEN
529: FOR i IN p_x_material_avl_tbl.FIRST..p_x_material_avl_tbl.LAST
530: LOOP
531: IF (l_log_statement >= l_log_current_level) THEN
532: fnd_log.string(l_log_statement,
533: L_DEBUG_KEY,
534: 'Check Material Availability for Inventory Item Id : ' ||
535: p_x_material_avl_tbl(i).inventory_item_id ||
536: ', Schedule Material Id : ' ||

Line 565: fnd_log.string(l_log_statement,

561: FETCH Item_Des_Cur INTO p_x_material_avl_tbl(i).item;
562: CLOSE Item_Des_Cur;
563:
564: IF (l_log_statement >= l_log_current_level) THEN
565: fnd_log.string(l_log_statement,
566: L_DEBUG_KEY,
567: 'Before calling Check Availability');
568: END IF;
569:

Line 586: fnd_log.string(l_log_statement,

582: x_error_message => l_error_message,
583: x_return_status => l_return_status);
584: --
585: IF (l_log_statement >= l_log_current_level) THEN
586: fnd_log.string(l_log_statement,
587: L_DEBUG_KEY,
588: 'After calling Check Availability, Return Status : '|| l_return_status);
589: END IF;
590:

Line 616: fnd_log.string(l_log_statement,

612: p_x_material_avl_tbl(i).error_code := l_error_code;
613: p_x_material_avl_tbl(i).error_message := l_error_message;
614: --
615: IF (l_log_statement >= l_log_current_level) THEN
616: fnd_log.string(l_log_statement,
617: L_DEBUG_KEY,
618: 'Inventory Item Id : ' || p_x_material_avl_tbl(i).inventory_item_id);
619: fnd_log.string(l_log_statement,
620: L_DEBUG_KEY,

Line 619: fnd_log.string(l_log_statement,

615: IF (l_log_statement >= l_log_current_level) THEN
616: fnd_log.string(l_log_statement,
617: L_DEBUG_KEY,
618: 'Inventory Item Id : ' || p_x_material_avl_tbl(i).inventory_item_id);
619: fnd_log.string(l_log_statement,
620: L_DEBUG_KEY,
621: 'Quantity Available : ' || p_x_material_avl_tbl(i).quantity_available);
622: fnd_log.string(l_log_statement,
623: L_DEBUG_KEY,

Line 622: fnd_log.string(l_log_statement,

618: 'Inventory Item Id : ' || p_x_material_avl_tbl(i).inventory_item_id);
619: fnd_log.string(l_log_statement,
620: L_DEBUG_KEY,
621: 'Quantity Available : ' || p_x_material_avl_tbl(i).quantity_available);
622: fnd_log.string(l_log_statement,
623: L_DEBUG_KEY,
624: 'Quantity Required : ' || p_x_material_avl_tbl(i).quantity);
625: fnd_log.string(l_log_statement,
626: L_DEBUG_KEY,

Line 625: fnd_log.string(l_log_statement,

621: 'Quantity Available : ' || p_x_material_avl_tbl(i).quantity_available);
622: fnd_log.string(l_log_statement,
623: L_DEBUG_KEY,
624: 'Quantity Required : ' || p_x_material_avl_tbl(i).quantity);
625: fnd_log.string(l_log_statement,
626: L_DEBUG_KEY,
627: 'Visit Task Id: ' || p_x_material_avl_tbl(i).visit_task_id);
628: fnd_log.string(l_log_statement,
629: L_DEBUG_KEY,

Line 628: fnd_log.string(l_log_statement,

624: 'Quantity Required : ' || p_x_material_avl_tbl(i).quantity);
625: fnd_log.string(l_log_statement,
626: L_DEBUG_KEY,
627: 'Visit Task Id: ' || p_x_material_avl_tbl(i).visit_task_id);
628: fnd_log.string(l_log_statement,
629: L_DEBUG_KEY,
630: 'Error Code: ' || l_error_code);
631: fnd_log.string(l_log_statement,
632: L_DEBUG_KEY,

Line 631: fnd_log.string(l_log_statement,

627: 'Visit Task Id: ' || p_x_material_avl_tbl(i).visit_task_id);
628: fnd_log.string(l_log_statement,
629: L_DEBUG_KEY,
630: 'Error Code: ' || l_error_code);
631: fnd_log.string(l_log_statement,
632: L_DEBUG_KEY,
633: 'Error Message: ' || l_error_message);
634: fnd_log.string(l_log_statement,
635: L_DEBUG_KEY,

Line 634: fnd_log.string(l_log_statement,

630: 'Error Code: ' || l_error_code);
631: fnd_log.string(l_log_statement,
632: L_DEBUG_KEY,
633: 'Error Message: ' || l_error_message);
634: fnd_log.string(l_log_statement,
635: L_DEBUG_KEY,
636: ' at last Scheduled Date: ' || p_x_material_avl_tbl(i).scheduled_date);
637: END IF;
638: END LOOP;

Line 650: fnd_log.string(l_log_procedure,

646: END IF;
647: END IF;
648:
649: IF (l_log_procedure >= l_log_current_level) THEN
650: fnd_log.string(l_log_procedure,
651: L_DEBUG_KEY ||'.end',
652: 'At the end of PL SQL procedure. Return Status = ' || x_return_status);
653: END IF;
654:

Line 760: fnd_log.string(l_log_procedure,

756: i NUMBER;
757: BEGIN
758:
759: IF (l_log_procedure >= l_log_current_level) THEN
760: fnd_log.string(l_log_procedure,
761: L_DEBUG_KEY ||'.begin',
762: 'At the start of PL SQL procedure. Visit Id = ' || p_visit_id);
763: END IF;
764: -- Standard Start of API savepoint

Line 817: fnd_log.string(l_log_procedure,

813: END IF;
814: END IF;
815:
816: IF (l_log_procedure >= l_log_current_level) THEN
817: fnd_log.string(l_log_procedure,
818: L_DEBUG_KEY ||'.end',
819: 'At the end of PL SQL procedure. Return Status = ' || x_return_status);
820: END IF;
821:

Line 859: fnd_log.string(l_log_procedure,

855: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
856:
857: BEGIN
858: IF (l_log_procedure >= l_log_current_level) THEN
859: fnd_log.string(l_log_procedure,
860: L_DEBUG_KEY ||'.begin',
861: 'At the start of PL SQL procedure.');
862: END IF;
863:

Line 913: fnd_log.string(l_log_procedure,

909: p_atp_table.req_item_available_date.extend;
910: p_atp_table.req_item_available_date_qty.extend;
911:
912: IF (l_log_procedure >= l_log_current_level) THEN
913: fnd_log.string(l_log_procedure,
914: L_DEBUG_KEY ||'.end',
915: 'At the end of PL SQL procedure. Return Status = ' || x_return_status);
916: END IF;
917:

Line 1031: fnd_log.string(l_log_procedure,

1027:
1028: BEGIN
1029:
1030: IF (l_log_procedure >= l_log_current_level) THEN
1031: fnd_log.string(l_log_procedure,
1032: L_DEBUG_KEY ||'.begin',
1033: 'At the start of PL SQL procedure. Number of Records : ' || l_planned_matrl_tbl.COUNT);
1034: END IF;
1035: -- Standard Start of API savepoint

Line 1056: fnd_log.string(l_log_statement,

1052: SELECT MRP_ATP_SCHEDULE_TEMP_S.NEXTVAL
1053: INTO l_session_id FROM DUAL;
1054:
1055: IF (l_log_statement >= l_log_current_level) THEN
1056: fnd_log.string(l_log_statement,
1057: L_DEBUG_KEY,
1058: 'Session Id : '||l_session_id);
1059: END IF;
1060:

Line 1075: fnd_log.string(l_log_statement,

1071: --
1072: CLOSE Instance_Id_Cur;
1073:
1074: IF (l_log_statement >= l_log_current_level) THEN
1075: fnd_log.string(l_log_statement,
1076: L_DEBUG_KEY,
1077: 'Instance Id : '||l_instance_id);
1078: END IF;
1079:

Line 1133: fnd_log.string(l_log_statement,

1129: l_atp_table.order_number(i) := l_order_number;
1130: l_atp_table.calling_module(i) := 867; --fnd_global.prog_appl_id;
1131: --
1132: IF (l_log_statement >= l_log_current_level)THEN
1133: fnd_log.string(l_log_statement,
1134: L_DEBUG_KEY,
1135: 'Inventory Item Id : '||l_atp_table.inventory_item_id(i) ||'-'||i);
1136: fnd_log.string(l_log_statement,
1137: L_DEBUG_KEY,

Line 1136: fnd_log.string(l_log_statement,

1132: IF (l_log_statement >= l_log_current_level)THEN
1133: fnd_log.string(l_log_statement,
1134: L_DEBUG_KEY,
1135: 'Inventory Item Id : '||l_atp_table.inventory_item_id(i) ||'-'||i);
1136: fnd_log.string(l_log_statement,
1137: L_DEBUG_KEY,
1138: 'Inventory Item Name : '||l_atp_table.inventory_item_name(i));
1139: fnd_log.string(l_log_statement,
1140: L_DEBUG_KEY,

Line 1139: fnd_log.string(l_log_statement,

1135: 'Inventory Item Id : '||l_atp_table.inventory_item_id(i) ||'-'||i);
1136: fnd_log.string(l_log_statement,
1137: L_DEBUG_KEY,
1138: 'Inventory Item Name : '||l_atp_table.inventory_item_name(i));
1139: fnd_log.string(l_log_statement,
1140: L_DEBUG_KEY,
1141: 'Instance Id : '||l_atp_table.instance_id(i));
1142: fnd_log.string(l_log_statement,
1143: L_DEBUG_KEY,

Line 1142: fnd_log.string(l_log_statement,

1138: 'Inventory Item Name : '||l_atp_table.inventory_item_name(i));
1139: fnd_log.string(l_log_statement,
1140: L_DEBUG_KEY,
1141: 'Instance Id : '||l_atp_table.instance_id(i));
1142: fnd_log.string(l_log_statement,
1143: L_DEBUG_KEY,
1144: 'Organization Id : '||l_atp_table.source_organization_id(i));
1145: fnd_log.string(l_log_statement,
1146: L_DEBUG_KEY,

Line 1145: fnd_log.string(l_log_statement,

1141: 'Instance Id : '||l_atp_table.instance_id(i));
1142: fnd_log.string(l_log_statement,
1143: L_DEBUG_KEY,
1144: 'Organization Id : '||l_atp_table.source_organization_id(i));
1145: fnd_log.string(l_log_statement,
1146: L_DEBUG_KEY,
1147: 'Old_Source_Organization_Id : '||l_atp_table.Old_Source_Organization_Id(i));
1148: fnd_log.string(l_log_statement,
1149: L_DEBUG_KEY,

Line 1148: fnd_log.string(l_log_statement,

1144: 'Organization Id : '||l_atp_table.source_organization_id(i));
1145: fnd_log.string(l_log_statement,
1146: L_DEBUG_KEY,
1147: 'Old_Source_Organization_Id : '||l_atp_table.Old_Source_Organization_Id(i));
1148: fnd_log.string(l_log_statement,
1149: L_DEBUG_KEY,
1150: 'Identifier : '||l_atp_table.identifier(i));
1151: fnd_log.string(l_log_statement,
1152: L_DEBUG_KEY,

Line 1151: fnd_log.string(l_log_statement,

1147: 'Old_Source_Organization_Id : '||l_atp_table.Old_Source_Organization_Id(i));
1148: fnd_log.string(l_log_statement,
1149: L_DEBUG_KEY,
1150: 'Identifier : '||l_atp_table.identifier(i));
1151: fnd_log.string(l_log_statement,
1152: L_DEBUG_KEY,
1153: 'Demand Source Type : '||l_atp_table.demand_source_type(i));
1154: fnd_log.string(l_log_statement,
1155: L_DEBUG_KEY,

Line 1154: fnd_log.string(l_log_statement,

1150: 'Identifier : '||l_atp_table.identifier(i));
1151: fnd_log.string(l_log_statement,
1152: L_DEBUG_KEY,
1153: 'Demand Source Type : '||l_atp_table.demand_source_type(i));
1154: fnd_log.string(l_log_statement,
1155: L_DEBUG_KEY,
1156: 'Quantity Ordered : '||l_atp_table.quantity_ordered(i));
1157: fnd_log.string(l_log_statement,
1158: L_DEBUG_KEY,

Line 1157: fnd_log.string(l_log_statement,

1153: 'Demand Source Type : '||l_atp_table.demand_source_type(i));
1154: fnd_log.string(l_log_statement,
1155: L_DEBUG_KEY,
1156: 'Quantity Ordered : '||l_atp_table.quantity_ordered(i));
1157: fnd_log.string(l_log_statement,
1158: L_DEBUG_KEY,
1159: 'Quantity UOM : '||l_atp_table.quantity_uom(i));
1160: fnd_log.string(l_log_statement,
1161: L_DEBUG_KEY,

Line 1160: fnd_log.string(l_log_statement,

1156: 'Quantity Ordered : '||l_atp_table.quantity_ordered(i));
1157: fnd_log.string(l_log_statement,
1158: L_DEBUG_KEY,
1159: 'Quantity UOM : '||l_atp_table.quantity_uom(i));
1160: fnd_log.string(l_log_statement,
1161: L_DEBUG_KEY,
1162: 'Requested Ship Date : '||l_atp_table.requested_ship_date(i));
1163: fnd_log.string(l_log_statement,
1164: L_DEBUG_KEY,

Line 1163: fnd_log.string(l_log_statement,

1159: 'Quantity UOM : '||l_atp_table.quantity_uom(i));
1160: fnd_log.string(l_log_statement,
1161: L_DEBUG_KEY,
1162: 'Requested Ship Date : '||l_atp_table.requested_ship_date(i));
1163: fnd_log.string(l_log_statement,
1164: L_DEBUG_KEY,
1165: 'Action : '||l_atp_table.action(i));
1166: fnd_log.string(l_log_statement,
1167: L_DEBUG_KEY,

Line 1166: fnd_log.string(l_log_statement,

1162: 'Requested Ship Date : '||l_atp_table.requested_ship_date(i));
1163: fnd_log.string(l_log_statement,
1164: L_DEBUG_KEY,
1165: 'Action : '||l_atp_table.action(i));
1166: fnd_log.string(l_log_statement,
1167: L_DEBUG_KEY,
1168: 'Order Number : '||l_atp_table.order_number(i));
1169: fnd_log.string(l_log_statement,
1170: L_DEBUG_KEY,

Line 1169: fnd_log.string(l_log_statement,

1165: 'Action : '||l_atp_table.action(i));
1166: fnd_log.string(l_log_statement,
1167: L_DEBUG_KEY,
1168: 'Order Number : '||l_atp_table.order_number(i));
1169: fnd_log.string(l_log_statement,
1170: L_DEBUG_KEY,
1171: 'Requested Date Quantity : '||l_atp_table.requested_date_quantity(i));
1172: fnd_log.string(l_log_statement,
1173: L_DEBUG_KEY,

Line 1172: fnd_log.string(l_log_statement,

1168: 'Order Number : '||l_atp_table.order_number(i));
1169: fnd_log.string(l_log_statement,
1170: L_DEBUG_KEY,
1171: 'Requested Date Quantity : '||l_atp_table.requested_date_quantity(i));
1172: fnd_log.string(l_log_statement,
1173: L_DEBUG_KEY,
1174: 'Calling Module : '||l_atp_table.Calling_module(i));
1175: END IF;
1176: END IF;

Line 1180: fnd_log.string(l_log_statement,

1176: END IF;
1177: END LOOP;
1178:
1179: IF (l_log_statement >= l_log_current_level) THEN
1180: fnd_log.string(l_log_statement,
1181: L_DEBUG_KEY,
1182: 'Before calling Mrp Atp Pub.Call_ATP. Calling Module count: '||
1183: l_atp_table.Calling_module.count);
1184: END IF;

Line 1198: fnd_log.string(l_log_statement,

1194: x_msg_data,
1195: x_msg_count);
1196:
1197: IF (l_log_statement >= l_log_current_level) THEN
1198: fnd_log.string(l_log_statement,
1199: L_DEBUG_KEY,
1200: 'After calling Mrp Atp Pub.Call_ATP. Return Status : '|| x_return_status);
1201: END IF;
1202:

Line 1218: fnd_log.string(l_log_statement,

1214: LOOP
1215: MSC_ATP_GLOBAL.Extend_ATP(x_atp_table, x_return_status);
1216: IF (x_atp_table.Error_Code.EXISTS(i) AND x_atp_table.error_code(i) <> 0) THEN
1217: IF (l_log_statement >= l_log_current_level)THEN
1218: fnd_log.string(l_log_statement,
1219: L_DEBUG_KEY,
1220: 'x_atp_table.error_code(i) : '||x_atp_table.error_code(i));
1221: END IF;
1222: MSC_ATP_GLOBAL.Extend_ATP(x_atp_table, x_return_status);

Line 1247: fnd_log.string(l_log_statement,

1243: --Error code is zero update the record
1244: MSC_ATP_GLOBAL.Extend_ATP(x_atp_table, x_return_status);
1245:
1246: IF (l_log_statement >= l_log_current_level)THEN
1247: fnd_log.string(l_log_statement,
1248: L_DEBUG_KEY,
1249: 'Ship Date => '||x_atp_table.ship_date(i));
1250: fnd_log.string(l_log_statement,
1251: L_DEBUG_KEY,

Line 1250: fnd_log.string(l_log_statement,

1246: IF (l_log_statement >= l_log_current_level)THEN
1247: fnd_log.string(l_log_statement,
1248: L_DEBUG_KEY,
1249: 'Ship Date => '||x_atp_table.ship_date(i));
1250: fnd_log.string(l_log_statement,
1251: L_DEBUG_KEY,
1252: 'x_atp_table.identifier(i) : '|| x_atp_table.identifier(i));
1253: fnd_log.string(l_log_statement,
1254: L_DEBUG_KEY,

Line 1253: fnd_log.string(l_log_statement,

1249: 'Ship Date => '||x_atp_table.ship_date(i));
1250: fnd_log.string(l_log_statement,
1251: L_DEBUG_KEY,
1252: 'x_atp_table.identifier(i) : '|| x_atp_table.identifier(i));
1253: fnd_log.string(l_log_statement,
1254: L_DEBUG_KEY,
1255: 'x_atp_table.available_quantity(i) : '|| x_atp_table.available_quantity(i));
1256: fnd_log.string(l_log_statement,
1257: L_DEBUG_KEY,

Line 1256: fnd_log.string(l_log_statement,

1252: 'x_atp_table.identifier(i) : '|| x_atp_table.identifier(i));
1253: fnd_log.string(l_log_statement,
1254: L_DEBUG_KEY,
1255: 'x_atp_table.available_quantity(i) : '|| x_atp_table.available_quantity(i));
1256: fnd_log.string(l_log_statement,
1257: L_DEBUG_KEY,
1258: 'x_atp_table.requested_date_quantity(i) : '|| trunc(x_atp_table.requested_date_quantity(i)));
1259: fnd_log.string(l_log_statement,
1260: L_DEBUG_KEY,

Line 1259: fnd_log.string(l_log_statement,

1255: 'x_atp_table.available_quantity(i) : '|| x_atp_table.available_quantity(i));
1256: fnd_log.string(l_log_statement,
1257: L_DEBUG_KEY,
1258: 'x_atp_table.requested_date_quantity(i) : '|| trunc(x_atp_table.requested_date_quantity(i)));
1259: fnd_log.string(l_log_statement,
1260: L_DEBUG_KEY,
1261: 'x_atp_table.ship_date(i) : '|| x_atp_table.ship_date(i));
1262: END IF;
1263: --Assign out parameter

Line 1287: fnd_log.string(l_log_statement,

1283: IF l_temp_atp_table.COUNT > 0 THEN
1284: FOR i IN l_temp_atp_table.FIRST..l_temp_atp_table.LAST
1285: LOOP
1286: IF (l_log_statement >= l_log_current_level)THEN
1287: fnd_log.string(l_log_statement,
1288: L_DEBUG_KEY,
1289: 'Before assign out parameter, Sch Mat ID: '||
1290: l_temp_atp_table(i).schedule_material_id ||
1291: ', Quantity Available: '||

Line 1323: fnd_log.string(l_log_procedure,

1319: END IF;
1320: --Need to fix error messages
1321:
1322: IF (l_log_procedure >= l_log_current_level) THEN
1323: fnd_log.string(l_log_procedure,
1324: L_DEBUG_KEY ||'.end',
1325: 'At the end of PL SQL procedure. Return Status = ' || x_return_status);
1326: END IF;
1327: EXCEPTION

Line 1485: fnd_log.string(l_log_procedure,

1481: j NUMBER := 1;
1482: BEGIN
1483:
1484: IF (l_log_procedure >= l_log_current_level) THEN
1485: fnd_log.string(l_log_procedure,
1486: L_DEBUG_KEY ||'.begin',
1487: 'At the start of PL SQL procedure. Number of Records : ' || l_planned_matrl_tbl.COUNT);
1488: END IF;
1489: -- Standard Start of API savepoint

Line 1551: fnd_log.string(l_log_statement,

1547:
1548: --
1549: IF l_temp_planned_matrl_tbl.COUNT > 0 THEN
1550: IF (l_log_statement >= l_log_current_level) THEN
1551: fnd_log.string(l_log_statement,
1552: L_DEBUG_KEY,
1553: 'Before calling Call ATP');
1554: END IF;
1555:

Line 1568: fnd_log.string(l_log_statement,

1564: x_msg_data => l_msg_data);
1565: END IF;
1566:
1567: IF (l_log_statement >= l_log_current_level) THEN
1568: fnd_log.string(l_log_statement,
1569: L_DEBUG_KEY,
1570: 'After calling Call ATP. Return Status : '|| l_return_status ||
1571: ', Returned Final Records : '||l_temp_planned_matrl_tbl.COUNT);
1572: END IF;

Line 1619: fnd_log.string(l_log_statement,

1615: p_x_planned_matrl_tbl(i).error_code := l_temp_planned_matrl_tbl(i).error_code;
1616: p_x_planned_matrl_tbl(i).error_message := l_temp_planned_matrl_tbl(i).error_message;
1617:
1618: IF (l_log_statement >= l_log_current_level)THEN
1619: fnd_log.string(l_log_statement,
1620: L_DEBUG_KEY,
1621: 'After Assign, Sch Mat Id : ' || p_x_planned_matrl_tbl(i).schedule_material_id ||
1622: ', Quantity Available : ' || p_x_planned_matrl_tbl(i).quantity_available ||
1623: ', Scheduled Quantity : ' || p_x_planned_matrl_tbl(i).scheduled_date ||

Line 1637: fnd_log.string(l_log_procedure,

1633: COMMIT WORK;
1634: END IF;
1635:
1636: IF (l_log_procedure >= l_log_current_level) THEN
1637: fnd_log.string(l_log_procedure,
1638: L_DEBUG_KEY ||'.end',
1639: 'At the end of PL SQL procedure. Return Status = ' || x_return_status);
1640: END IF;
1641:

Line 1748: fnd_log.string(l_log_procedure,

1744: i NUMBER;
1745: BEGIN
1746:
1747: IF (l_log_procedure >= l_log_current_level) THEN
1748: fnd_log.string(l_log_procedure,
1749: L_DEBUG_KEY ||'.begin',
1750: 'At the start of PL SQL procedure. Visit Id = ' || p_visit_id);
1751: END IF;
1752: -- Standard Start of API savepoint

Line 1790: fnd_log.string(l_log_statement,

1786: CLOSE Get_Visit_Task_Matrl_Cur;
1787: END IF; --Visit not null
1788:
1789: IF (l_log_statement >= l_log_current_level) THEN
1790: fnd_log.string(l_log_statement,
1791: L_DEBUG_KEY,
1792: 'Before calling Call ATP No of Records'||l_planned_matrl_tbl.COUNT);
1793: END IF;
1794:

Line 1808: fnd_log.string(l_log_statement,

1804: x_msg_data => l_msg_data);
1805: END IF;
1806:
1807: IF (l_log_statement >= l_log_current_level) THEN
1808: fnd_log.string(l_log_statement,
1809: L_DEBUG_KEY,
1810: 'After calling Call ATP, Return Status : '|| l_return_status);
1811: END IF;
1812:

Line 1846: fnd_log.string(l_log_statement,

1842: x_Planned_Matrl_Tbl(i).error_code := l_Planned_Matrl_Tbl(i).error_code;
1843: x_Planned_Matrl_Tbl(i).error_message := l_Planned_Matrl_Tbl(i).error_message;
1844:
1845: IF (l_log_statement >= l_log_current_level) THEN
1846: fnd_log.string(l_log_statement,
1847: L_DEBUG_KEY,
1848: 'After Assign, Sch Mat Id : ' || x_planned_matrl_tbl(i).schedule_material_id ||
1849: ', Quantity Available : ' || x_planned_matrl_tbl(i).quantity_available ||
1850: ', Scheduled Quantity : ' || x_planned_matrl_tbl(i).scheduled_date ||

Line 1862: fnd_log.string(l_log_procedure,

1858: COMMIT WORK;
1859: END IF;
1860:
1861: IF (l_log_procedure >= l_log_current_level) THEN
1862: fnd_log.string(l_log_procedure,
1863: L_DEBUG_KEY ||'.end',
1864: 'At the end of PL SQL procedure. Return Status = ' || x_return_status);
1865: END IF;
1866:

Line 1974: fnd_log.string(l_log_procedure, L_DEBUG_KEY ||'.begin',

1970:
1971: BEGIN
1972:
1973: IF (l_log_procedure >= l_log_current_level) THEN
1974: fnd_log.string(l_log_procedure, L_DEBUG_KEY ||'.begin',
1975: 'At the start of PL/SQL procedure. Number of Records: ' || p_deleted_matrl_tbl.COUNT);
1976: END IF;
1977:
1978: -- Standard Start of API savepoint

Line 1998: fnd_log.string(l_log_statement, L_DEBUG_KEY, 'Session Id: ' || l_session_id);

1994: --Get session id
1995: SELECT MRP_ATP_SCHEDULE_TEMP_S.NEXTVAL
1996: INTO l_session_id FROM DUAL;
1997: IF (l_log_statement >= l_log_current_level) THEN
1998: fnd_log.string(l_log_statement, L_DEBUG_KEY, 'Session Id: ' || l_session_id);
1999: END IF;
2000:
2001: --Get instance Id
2002: -- Changes by surrkuma on 14-JUL-2010 for the bug 9901811

Line 2015: fnd_log.string(l_log_statement, L_DEBUG_KEY, 'Instance Id: ' || l_instance_id);

2011: -- RAISE FND_API.G_EXC_ERROR;
2012: END IF;
2013: CLOSE Instance_Id_Cur;
2014: IF (l_log_statement >= l_log_current_level) THEN
2015: fnd_log.string(l_log_statement, L_DEBUG_KEY, 'Instance Id: ' || l_instance_id);
2016: END IF;
2017:
2018: -- Loop through all the records
2019: FOR i IN p_deleted_matrl_tbl.FIRST .. p_deleted_matrl_tbl.LAST

Line 2062: fnd_log.string(l_log_statement, L_DEBUG_KEY,

2058: END IF;
2059: END LOOP;
2060:
2061: IF (l_log_statement >= l_log_current_level) THEN
2062: fnd_log.string(l_log_statement, L_DEBUG_KEY,
2063: 'Before calling MRP_ATP_PUB.CALL_ATP. Calling Module count: ' || l_atp_table.Calling_module.count);
2064: END IF;
2065:
2066: -- Call ATP to Reschedule

Line 2078: fnd_log.string(l_log_statement, L_DEBUG_KEY,

2074: x_msg_data,
2075: x_msg_count);
2076:
2077: IF (l_log_statement >= l_log_current_level) THEN
2078: fnd_log.string(l_log_statement, L_DEBUG_KEY,
2079: 'After calling MRP_ATP_PUB.CALL_ATP. Return Status : ' || x_return_status);
2080: END IF;
2081:
2082: -- Check Error Message stack.

Line 2100: fnd_log.string(l_log_statement, L_DEBUG_KEY,

2096: OPEN Error_Message_Cur(x_atp_table.error_code(i));
2097: FETCH Error_Message_Cur INTO l_error_msg;
2098: CLOSE Error_Message_Cur;
2099: IF (l_log_statement >= l_log_current_level) THEN
2100: fnd_log.string(l_log_statement, L_DEBUG_KEY,
2101: 'x_atp_table.identifier(i) = ' || x_atp_table.identifier(i) ||
2102: ', x_atp_table.error_code(i) = ' || x_atp_table.error_code(i) ||
2103: ', Error Message = ' || l_error_msg);
2104: END IF;

Line 2108: fnd_log.string(l_log_statement, L_DEBUG_KEY,

2104: END IF;
2105: ELSE
2106: --Error code is zero: Success
2107: IF (l_log_statement >= l_log_current_level) THEN
2108: fnd_log.string(l_log_statement, L_DEBUG_KEY,
2109: 'x_atp_table.identifier(i) = ' || x_atp_table.identifier(i) ||
2110: ', Successfully unscheduled.');
2111: END IF;
2112: END IF;

Line 2125: fnd_log.string(l_log_procedure,

2121: END IF;
2122: END IF;
2123:
2124: IF (l_log_procedure >= l_log_current_level) THEN
2125: fnd_log.string(l_log_procedure,
2126: L_DEBUG_KEY ||'.end',
2127: 'At the end of PL SQL procedure. Return Status = ' || x_return_status);
2128: END IF;
2129: EXCEPTION