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 184: fnd_log.string(l_log_statement,

180: l_atp_table.Error_Code := Mrp_Atp_Pub.number_arr(NULL);
181: l_atp_table.Message := Mrp_Atp_Pub.char2000_arr(NULL);
182:
183: IF (l_log_statement >= l_log_current_level) THEN
184: fnd_log.string(l_log_statement,
185: L_DEBUG_KEY,
186: 'Inventory Item Id : '||l_atp_table.Inventory_Item_Id(1));
187: fnd_log.string(l_log_statement,
188: L_DEBUG_KEY,

Line 187: fnd_log.string(l_log_statement,

183: IF (l_log_statement >= l_log_current_level) THEN
184: fnd_log.string(l_log_statement,
185: L_DEBUG_KEY,
186: 'Inventory Item Id : '||l_atp_table.Inventory_Item_Id(1));
187: fnd_log.string(l_log_statement,
188: L_DEBUG_KEY,
189: 'Requested Date : '||l_atp_table.Requested_ship_Date(1));
190: fnd_log.string(l_log_statement,
191: L_DEBUG_KEY,

Line 190: fnd_log.string(l_log_statement,

186: 'Inventory Item Id : '||l_atp_table.Inventory_Item_Id(1));
187: fnd_log.string(l_log_statement,
188: L_DEBUG_KEY,
189: 'Requested Date : '||l_atp_table.Requested_ship_Date(1));
190: fnd_log.string(l_log_statement,
191: L_DEBUG_KEY,
192: 'Calling Module : '||l_atp_table.Calling_Module(1));
193: fnd_log.string(l_log_statement,
194: L_DEBUG_KEY,

Line 193: fnd_log.string(l_log_statement,

189: 'Requested Date : '||l_atp_table.Requested_ship_Date(1));
190: fnd_log.string(l_log_statement,
191: L_DEBUG_KEY,
192: 'Calling Module : '||l_atp_table.Calling_Module(1));
193: fnd_log.string(l_log_statement,
194: L_DEBUG_KEY,
195: 'Organization Id : '||l_atp_table.Source_Organization_id(1));
196: fnd_log.string(l_log_statement,
197: L_DEBUG_KEY,

Line 196: fnd_log.string(l_log_statement,

192: 'Calling Module : '||l_atp_table.Calling_Module(1));
193: fnd_log.string(l_log_statement,
194: L_DEBUG_KEY,
195: 'Organization Id : '||l_atp_table.Source_Organization_id(1));
196: fnd_log.string(l_log_statement,
197: L_DEBUG_KEY,
198: 'Quantity Ordered : '||l_atp_table.Quantity_Ordered(1));
199: fnd_log.string(l_log_statement,
200: L_DEBUG_KEY,

Line 199: fnd_log.string(l_log_statement,

195: 'Organization Id : '||l_atp_table.Source_Organization_id(1));
196: fnd_log.string(l_log_statement,
197: L_DEBUG_KEY,
198: 'Quantity Ordered : '||l_atp_table.Quantity_Ordered(1));
199: fnd_log.string(l_log_statement,
200: L_DEBUG_KEY,
201: 'Action : '||l_atp_table.Action(1));
202: END IF;
203:

Line 205: fnd_log.string(l_log_statement,

201: 'Action : '||l_atp_table.Action(1));
202: END IF;
203:
204: IF (l_log_statement >= l_log_current_level) THEN
205: fnd_log.string(l_log_statement,
206: L_DEBUG_KEY,
207: 'Before calling Mrp Atp Pub.Call_ATP');
208: END IF;
209:

Line 223: fnd_log.string(l_log_statement,

219: l_msg_data,
220: l_msg_count);
221:
222: IF (l_log_statement >= l_log_current_level) THEN
223: fnd_log.string(l_log_statement,
224: L_DEBUG_KEY,
225: 'After calling Mrp Atp Pub.Call_ATP. Return Status : '|| l_return_status);
226: END IF;
227:

Line 239: fnd_log.string(l_log_statement,

235:
236: MSC_ATP_GLOBAL.Extend_ATP(x_atp_table, x_return_status);
237:
238: IF (l_log_statement >= l_log_current_level) THEN
239: fnd_log.string(l_log_statement,
240: L_DEBUG_KEY,
241: 'Inventory Item Id : '||x_atp_table.Inventory_Item_Id(1));
242: fnd_log.string(l_log_statement,
243: L_DEBUG_KEY,

Line 242: fnd_log.string(l_log_statement,

238: IF (l_log_statement >= l_log_current_level) THEN
239: fnd_log.string(l_log_statement,
240: L_DEBUG_KEY,
241: 'Inventory Item Id : '||x_atp_table.Inventory_Item_Id(1));
242: fnd_log.string(l_log_statement,
243: L_DEBUG_KEY,
244: 'Organization Id : '||x_atp_table.Source_Organization_Id(1));
245: fnd_log.string(l_log_statement,
246: L_DEBUG_KEY,

Line 245: fnd_log.string(l_log_statement,

241: 'Inventory Item Id : '||x_atp_table.Inventory_Item_Id(1));
242: fnd_log.string(l_log_statement,
243: L_DEBUG_KEY,
244: 'Organization Id : '||x_atp_table.Source_Organization_Id(1));
245: fnd_log.string(l_log_statement,
246: L_DEBUG_KEY,
247: 'Organization Code : '||x_atp_table.Source_Organization_code(1));
248: fnd_log.string(l_log_statement,
249: L_DEBUG_KEY,

Line 248: fnd_log.string(l_log_statement,

244: 'Organization Id : '||x_atp_table.Source_Organization_Id(1));
245: fnd_log.string(l_log_statement,
246: L_DEBUG_KEY,
247: 'Organization Code : '||x_atp_table.Source_Organization_code(1));
248: fnd_log.string(l_log_statement,
249: L_DEBUG_KEY,
250: 'Quantity Ordered : '||x_atp_table.Quantity_Ordered(1));
251: fnd_log.string(l_log_statement,
252: L_DEBUG_KEY,

Line 251: fnd_log.string(l_log_statement,

247: 'Organization Code : '||x_atp_table.Source_Organization_code(1));
248: fnd_log.string(l_log_statement,
249: L_DEBUG_KEY,
250: 'Quantity Ordered : '||x_atp_table.Quantity_Ordered(1));
251: fnd_log.string(l_log_statement,
252: L_DEBUG_KEY,
253: 'Requested Ship Date : '||x_atp_table.Requested_Ship_Date(1));
254: fnd_log.string(l_log_statement,
255: L_DEBUG_KEY,

Line 254: fnd_log.string(l_log_statement,

250: 'Quantity Ordered : '||x_atp_table.Quantity_Ordered(1));
251: fnd_log.string(l_log_statement,
252: L_DEBUG_KEY,
253: 'Requested Ship Date : '||x_atp_table.Requested_Ship_Date(1));
254: fnd_log.string(l_log_statement,
255: L_DEBUG_KEY,
256: 'Requested Arrival Date : '||x_atp_table.Requested_arrival_Date(1));
257: fnd_log.string(l_log_statement,
258: L_DEBUG_KEY,

Line 257: fnd_log.string(l_log_statement,

253: 'Requested Ship Date : '||x_atp_table.Requested_Ship_Date(1));
254: fnd_log.string(l_log_statement,
255: L_DEBUG_KEY,
256: 'Requested Arrival Date : '||x_atp_table.Requested_arrival_Date(1));
257: fnd_log.string(l_log_statement,
258: L_DEBUG_KEY,
259: 'Arrival Date : '||x_atp_table.Arrival_Date(1));
260: fnd_log.string(l_log_statement,
261: L_DEBUG_KEY,

Line 260: fnd_log.string(l_log_statement,

256: 'Requested Arrival Date : '||x_atp_table.Requested_arrival_Date(1));
257: fnd_log.string(l_log_statement,
258: L_DEBUG_KEY,
259: 'Arrival Date : '||x_atp_table.Arrival_Date(1));
260: fnd_log.string(l_log_statement,
261: L_DEBUG_KEY,
262: 'Available Quantity : '||x_atp_table.Available_Quantity(1));
263: fnd_log.string(l_log_statement,
264: L_DEBUG_KEY,

Line 263: fnd_log.string(l_log_statement,

259: 'Arrival Date : '||x_atp_table.Arrival_Date(1));
260: fnd_log.string(l_log_statement,
261: L_DEBUG_KEY,
262: 'Available Quantity : '||x_atp_table.Available_Quantity(1));
263: fnd_log.string(l_log_statement,
264: L_DEBUG_KEY,
265: 'Requested Date Quantity : '||x_atp_table.Requested_Date_Quantity(1));
266: fnd_log.string(l_log_statement,
267: L_DEBUG_KEY,

Line 266: fnd_log.string(l_log_statement,

262: 'Available Quantity : '||x_atp_table.Available_Quantity(1));
263: fnd_log.string(l_log_statement,
264: L_DEBUG_KEY,
265: 'Requested Date Quantity : '||x_atp_table.Requested_Date_Quantity(1));
266: fnd_log.string(l_log_statement,
267: L_DEBUG_KEY,
268: 'Error Code : '||x_atp_table.Error_Code(1));
269: fnd_log.string(l_log_statement,
270: L_DEBUG_KEY,

Line 269: fnd_log.string(l_log_statement,

265: 'Requested Date Quantity : '||x_atp_table.Requested_Date_Quantity(1));
266: fnd_log.string(l_log_statement,
267: L_DEBUG_KEY,
268: 'Error Code : '||x_atp_table.Error_Code(1));
269: fnd_log.string(l_log_statement,
270: L_DEBUG_KEY,
271: 'Pub Message : '||x_atp_table.Message(1));
272: END IF;
273:

Line 290: fnd_log.string(l_log_statement,

286: x_available_qty := trunc(x_atp_table.Available_Quantity(1));
287: x_error_code := x_atp_table.Error_code(1);
288:
289: IF (l_log_statement >= l_log_current_level) THEN
290: fnd_log.string(l_log_statement,
291: L_DEBUG_KEY,
292: 'After Calling Mrp Atp Pub. Error Code = ' || x_error_code ||
293: ', Available Quantity : '||x_available_qty);
294: END IF;

Line 302: fnd_log.string(l_log_statement,

298: FETCH Error_Message_Cur INTO x_error_message;
299: CLOSE Error_Message_Cur;
300:
301: IF (l_log_statement >= l_log_current_level) THEN
302: fnd_log.string(l_log_statement,
303: L_DEBUG_KEY,
304: 'After Calling Mrp Atp Pub Error Message : '||x_error_message);
305: END IF;
306: ELSE

Line 310: fnd_log.string(l_log_statement,

306: ELSE
307: MSC_ATP_GLOBAL.Extend_ATP(x_atp_table, l_return_status);
308:
309: IF (l_log_statement >= l_log_current_level) THEN
310: fnd_log.string(l_log_statement,
311: L_DEBUG_KEY,
312: 'After calling MSC EXTEND');
313: END IF;
314:

Line 321: fnd_log.string(l_log_statement,

317:
318: x_available_qty := trunc(x_atp_table.Available_Quantity(1));
319:
320: IF (l_log_statement >= l_log_current_level) THEN
321: fnd_log.string(l_log_statement,
322: L_DEBUG_KEY,
323: 'After ERROR CODE : '||x_error_code);
324: END IF;
325: --Get from mfg lookups

Line 331: fnd_log.string(l_log_statement,

327: FETCH Error_Message_Cur INTO x_error_message;
328: CLOSE Error_Message_Cur;
329:
330: IF (l_log_statement >= l_log_current_level) THEN
331: fnd_log.string(l_log_statement,
332: L_DEBUG_KEY,
333: 'Interface Error Message from mfg lookups : '||x_error_message);
334:
335: END IF;

Line 341: fnd_log.string(l_log_statement,

337: END IF;--Error code
338: END IF;
339:
340: IF (l_log_statement >= l_log_current_level) THEN
341: fnd_log.string(l_log_statement,
342: L_DEBUG_KEY,
343: 'Derived from Mrp Atp Pub Available Quantity : '||x_available_qty);
344: END IF;
345:

Line 355: fnd_log.string(l_log_procedure,

351: END IF;
352: END IF;
353:
354: IF (l_log_procedure >= l_log_current_level) THEN
355: fnd_log.string(l_log_procedure,
356: L_DEBUG_KEY ||'.end',
357: 'At the end of PL SQL procedure. Return Status = ' || x_return_status);
358: END IF;
359:

Line 462: fnd_log.string(l_log_procedure,

458: l_error_message VARCHAR2(2000);
459:
460: BEGIN
461: IF (l_log_procedure >= l_log_current_level) THEN
462: fnd_log.string(l_log_procedure,
463: L_DEBUG_KEY ||'.begin',
464: 'At the start of PL SQL procedure.');
465: END IF;
466: -- dbms_output.put_line( 'start private API:');

Line 487: fnd_log.string(l_log_statement,

483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
484: END IF;
485:
486: IF (l_log_statement >= l_log_current_level)THEN
487: fnd_log.string(l_log_statement,
488: L_DEBUG_KEY,
489: 'Request for Check Material Availability for Viist item ID : ' ||
490: p_x_material_avl_tbl(1).visit_id);
491: END IF;

Line 505: fnd_log.string(l_log_statement,

501: END IF;
502: CLOSE Check_Sch_Visit_cur;
503: --
504: IF (l_log_statement >= l_log_current_level)THEN
505: fnd_log.string(l_log_statement,
506: L_DEBUG_KEY,
507: 'Request for Check Material Availability for Material Records : ' ||
508: p_x_material_avl_tbl.COUNT);
509: END IF;

Line 515: fnd_log.string(l_log_statement,

511: IF p_x_material_avl_tbl.COUNT > 0 THEN
512: FOR i IN p_x_material_avl_tbl.FIRST..p_x_material_avl_tbl.LAST
513: LOOP
514: IF (l_log_statement >= l_log_current_level) THEN
515: fnd_log.string(l_log_statement,
516: L_DEBUG_KEY,
517: 'Check Material Availability for Inventory Item Id : ' ||
518: p_x_material_avl_tbl(i).inventory_item_id ||
519: ', Schedule Material Id : ' ||

Line 548: fnd_log.string(l_log_statement,

544: FETCH Item_Des_Cur INTO p_x_material_avl_tbl(i).item;
545: CLOSE Item_Des_Cur;
546:
547: IF (l_log_statement >= l_log_current_level) THEN
548: fnd_log.string(l_log_statement,
549: L_DEBUG_KEY,
550: 'Before calling Check Availability');
551: END IF;
552:

Line 569: fnd_log.string(l_log_statement,

565: x_error_message => l_error_message,
566: x_return_status => l_return_status);
567: --
568: IF (l_log_statement >= l_log_current_level) THEN
569: fnd_log.string(l_log_statement,
570: L_DEBUG_KEY,
571: 'After calling Check Availability, Return Status : '|| l_return_status);
572: END IF;
573:

Line 595: fnd_log.string(l_log_statement,

591: p_x_material_avl_tbl(i).error_code := l_error_code;
592: p_x_material_avl_tbl(i).error_message := l_error_message;
593: --
594: IF (l_log_statement >= l_log_current_level) THEN
595: fnd_log.string(l_log_statement,
596: L_DEBUG_KEY,
597: 'Inventory Item Id : ' || p_x_material_avl_tbl(i).inventory_item_id);
598: fnd_log.string(l_log_statement,
599: L_DEBUG_KEY,

Line 598: fnd_log.string(l_log_statement,

594: IF (l_log_statement >= l_log_current_level) THEN
595: fnd_log.string(l_log_statement,
596: L_DEBUG_KEY,
597: 'Inventory Item Id : ' || p_x_material_avl_tbl(i).inventory_item_id);
598: fnd_log.string(l_log_statement,
599: L_DEBUG_KEY,
600: 'Quantity Available : ' || p_x_material_avl_tbl(i).quantity_available);
601: fnd_log.string(l_log_statement,
602: L_DEBUG_KEY,

Line 601: fnd_log.string(l_log_statement,

597: 'Inventory Item Id : ' || p_x_material_avl_tbl(i).inventory_item_id);
598: fnd_log.string(l_log_statement,
599: L_DEBUG_KEY,
600: 'Quantity Available : ' || p_x_material_avl_tbl(i).quantity_available);
601: fnd_log.string(l_log_statement,
602: L_DEBUG_KEY,
603: 'Quantity Required : ' || p_x_material_avl_tbl(i).quantity);
604: fnd_log.string(l_log_statement,
605: L_DEBUG_KEY,

Line 604: fnd_log.string(l_log_statement,

600: 'Quantity Available : ' || p_x_material_avl_tbl(i).quantity_available);
601: fnd_log.string(l_log_statement,
602: L_DEBUG_KEY,
603: 'Quantity Required : ' || p_x_material_avl_tbl(i).quantity);
604: fnd_log.string(l_log_statement,
605: L_DEBUG_KEY,
606: 'Visit Task Id: ' || p_x_material_avl_tbl(i).visit_task_id);
607: fnd_log.string(l_log_statement,
608: L_DEBUG_KEY,

Line 607: fnd_log.string(l_log_statement,

603: 'Quantity Required : ' || p_x_material_avl_tbl(i).quantity);
604: fnd_log.string(l_log_statement,
605: L_DEBUG_KEY,
606: 'Visit Task Id: ' || p_x_material_avl_tbl(i).visit_task_id);
607: fnd_log.string(l_log_statement,
608: L_DEBUG_KEY,
609: 'Error Code: ' || l_error_code);
610: fnd_log.string(l_log_statement,
611: L_DEBUG_KEY,

Line 610: fnd_log.string(l_log_statement,

606: 'Visit Task Id: ' || p_x_material_avl_tbl(i).visit_task_id);
607: fnd_log.string(l_log_statement,
608: L_DEBUG_KEY,
609: 'Error Code: ' || l_error_code);
610: fnd_log.string(l_log_statement,
611: L_DEBUG_KEY,
612: 'Error Message: ' || l_error_message);
613: END IF;
614: END LOOP;

Line 626: fnd_log.string(l_log_procedure,

622: END IF;
623: END IF;
624:
625: IF (l_log_procedure >= l_log_current_level) THEN
626: fnd_log.string(l_log_procedure,
627: L_DEBUG_KEY ||'.end',
628: 'At the end of PL SQL procedure. Return Status = ' || x_return_status);
629: END IF;
630:

Line 734: fnd_log.string(l_log_procedure,

730: i NUMBER;
731: BEGIN
732:
733: IF (l_log_procedure >= l_log_current_level) THEN
734: fnd_log.string(l_log_procedure,
735: L_DEBUG_KEY ||'.begin',
736: 'At the start of PL SQL procedure. Visit Id = ' || p_visit_id);
737: END IF;
738: -- Standard Start of API savepoint

Line 791: fnd_log.string(l_log_procedure,

787: END IF;
788: END IF;
789:
790: IF (l_log_procedure >= l_log_current_level) THEN
791: fnd_log.string(l_log_procedure,
792: L_DEBUG_KEY ||'.end',
793: 'At the end of PL SQL procedure. Return Status = ' || x_return_status);
794: END IF;
795:

Line 833: fnd_log.string(l_log_procedure,

829: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
830:
831: BEGIN
832: IF (l_log_procedure >= l_log_current_level) THEN
833: fnd_log.string(l_log_procedure,
834: L_DEBUG_KEY ||'.begin',
835: 'At the start of PL SQL procedure.');
836: END IF;
837:

Line 887: fnd_log.string(l_log_procedure,

883: p_atp_table.req_item_available_date.extend;
884: p_atp_table.req_item_available_date_qty.extend;
885:
886: IF (l_log_procedure >= l_log_current_level) THEN
887: fnd_log.string(l_log_procedure,
888: L_DEBUG_KEY ||'.end',
889: 'At the end of PL SQL procedure. Return Status = ' || x_return_status);
890: END IF;
891:

Line 1003: fnd_log.string(l_log_procedure,

999:
1000: BEGIN
1001:
1002: IF (l_log_procedure >= l_log_current_level) THEN
1003: fnd_log.string(l_log_procedure,
1004: L_DEBUG_KEY ||'.begin',
1005: 'At the start of PL SQL procedure. Number of Records : ' || l_planned_matrl_tbl.COUNT);
1006: END IF;
1007: -- Standard Start of API savepoint

Line 1028: fnd_log.string(l_log_statement,

1024: SELECT MRP_ATP_SCHEDULE_TEMP_S.NEXTVAL
1025: INTO l_session_id FROM DUAL;
1026:
1027: IF (l_log_statement >= l_log_current_level) THEN
1028: fnd_log.string(l_log_statement,
1029: L_DEBUG_KEY,
1030: 'Session Id : '||l_session_id);
1031: END IF;
1032:

Line 1047: fnd_log.string(l_log_statement,

1043: --
1044: CLOSE Instance_Id_Cur;
1045:
1046: IF (l_log_statement >= l_log_current_level) THEN
1047: fnd_log.string(l_log_statement,
1048: L_DEBUG_KEY,
1049: 'Instance Id : '||l_instance_id);
1050: END IF;
1051:

Line 1097: fnd_log.string(l_log_statement,

1093: l_atp_table.order_number(i) := l_order_number;
1094: l_atp_table.calling_module(i) := 867; --fnd_global.prog_appl_id;
1095: --
1096: IF (l_log_statement >= l_log_current_level)THEN
1097: fnd_log.string(l_log_statement,
1098: L_DEBUG_KEY,
1099: 'Inventory Item Id : '||l_atp_table.inventory_item_id(i) ||'-'||i);
1100: fnd_log.string(l_log_statement,
1101: L_DEBUG_KEY,

Line 1100: fnd_log.string(l_log_statement,

1096: IF (l_log_statement >= l_log_current_level)THEN
1097: fnd_log.string(l_log_statement,
1098: L_DEBUG_KEY,
1099: 'Inventory Item Id : '||l_atp_table.inventory_item_id(i) ||'-'||i);
1100: fnd_log.string(l_log_statement,
1101: L_DEBUG_KEY,
1102: 'Inventory Item Name : '||l_atp_table.inventory_item_name(i));
1103: fnd_log.string(l_log_statement,
1104: L_DEBUG_KEY,

Line 1103: fnd_log.string(l_log_statement,

1099: 'Inventory Item Id : '||l_atp_table.inventory_item_id(i) ||'-'||i);
1100: fnd_log.string(l_log_statement,
1101: L_DEBUG_KEY,
1102: 'Inventory Item Name : '||l_atp_table.inventory_item_name(i));
1103: fnd_log.string(l_log_statement,
1104: L_DEBUG_KEY,
1105: 'Instance Id : '||l_atp_table.instance_id(i));
1106: fnd_log.string(l_log_statement,
1107: L_DEBUG_KEY,

Line 1106: fnd_log.string(l_log_statement,

1102: 'Inventory Item Name : '||l_atp_table.inventory_item_name(i));
1103: fnd_log.string(l_log_statement,
1104: L_DEBUG_KEY,
1105: 'Instance Id : '||l_atp_table.instance_id(i));
1106: fnd_log.string(l_log_statement,
1107: L_DEBUG_KEY,
1108: 'Organization Id : '||l_atp_table.source_organization_id(i));
1109: fnd_log.string(l_log_statement,
1110: L_DEBUG_KEY,

Line 1109: fnd_log.string(l_log_statement,

1105: 'Instance Id : '||l_atp_table.instance_id(i));
1106: fnd_log.string(l_log_statement,
1107: L_DEBUG_KEY,
1108: 'Organization Id : '||l_atp_table.source_organization_id(i));
1109: fnd_log.string(l_log_statement,
1110: L_DEBUG_KEY,
1111: 'Identifier : '||l_atp_table.identifier(i));
1112: fnd_log.string(l_log_statement,
1113: L_DEBUG_KEY,

Line 1112: fnd_log.string(l_log_statement,

1108: 'Organization Id : '||l_atp_table.source_organization_id(i));
1109: fnd_log.string(l_log_statement,
1110: L_DEBUG_KEY,
1111: 'Identifier : '||l_atp_table.identifier(i));
1112: fnd_log.string(l_log_statement,
1113: L_DEBUG_KEY,
1114: 'Demand Source Type : '||l_atp_table.demand_source_type(i));
1115: fnd_log.string(l_log_statement,
1116: L_DEBUG_KEY,

Line 1115: fnd_log.string(l_log_statement,

1111: 'Identifier : '||l_atp_table.identifier(i));
1112: fnd_log.string(l_log_statement,
1113: L_DEBUG_KEY,
1114: 'Demand Source Type : '||l_atp_table.demand_source_type(i));
1115: fnd_log.string(l_log_statement,
1116: L_DEBUG_KEY,
1117: 'Quantity Ordered : '||l_atp_table.quantity_ordered(i));
1118: fnd_log.string(l_log_statement,
1119: L_DEBUG_KEY,

Line 1118: fnd_log.string(l_log_statement,

1114: 'Demand Source Type : '||l_atp_table.demand_source_type(i));
1115: fnd_log.string(l_log_statement,
1116: L_DEBUG_KEY,
1117: 'Quantity Ordered : '||l_atp_table.quantity_ordered(i));
1118: fnd_log.string(l_log_statement,
1119: L_DEBUG_KEY,
1120: 'Quantity UOM : '||l_atp_table.quantity_uom(i));
1121: fnd_log.string(l_log_statement,
1122: L_DEBUG_KEY,

Line 1121: fnd_log.string(l_log_statement,

1117: 'Quantity Ordered : '||l_atp_table.quantity_ordered(i));
1118: fnd_log.string(l_log_statement,
1119: L_DEBUG_KEY,
1120: 'Quantity UOM : '||l_atp_table.quantity_uom(i));
1121: fnd_log.string(l_log_statement,
1122: L_DEBUG_KEY,
1123: 'Requested Ship Date : '||l_atp_table.requested_ship_date(i));
1124: fnd_log.string(l_log_statement,
1125: L_DEBUG_KEY,

Line 1124: fnd_log.string(l_log_statement,

1120: 'Quantity UOM : '||l_atp_table.quantity_uom(i));
1121: fnd_log.string(l_log_statement,
1122: L_DEBUG_KEY,
1123: 'Requested Ship Date : '||l_atp_table.requested_ship_date(i));
1124: fnd_log.string(l_log_statement,
1125: L_DEBUG_KEY,
1126: 'Action : '||l_atp_table.action(i));
1127: fnd_log.string(l_log_statement,
1128: L_DEBUG_KEY,

Line 1127: fnd_log.string(l_log_statement,

1123: 'Requested Ship Date : '||l_atp_table.requested_ship_date(i));
1124: fnd_log.string(l_log_statement,
1125: L_DEBUG_KEY,
1126: 'Action : '||l_atp_table.action(i));
1127: fnd_log.string(l_log_statement,
1128: L_DEBUG_KEY,
1129: 'Order Number : '||l_atp_table.order_number(i));
1130: fnd_log.string(l_log_statement,
1131: L_DEBUG_KEY,

Line 1130: fnd_log.string(l_log_statement,

1126: 'Action : '||l_atp_table.action(i));
1127: fnd_log.string(l_log_statement,
1128: L_DEBUG_KEY,
1129: 'Order Number : '||l_atp_table.order_number(i));
1130: fnd_log.string(l_log_statement,
1131: L_DEBUG_KEY,
1132: 'Requested Date Quantity : '||l_atp_table.requested_date_quantity(i));
1133: fnd_log.string(l_log_statement,
1134: L_DEBUG_KEY,

Line 1133: fnd_log.string(l_log_statement,

1129: 'Order Number : '||l_atp_table.order_number(i));
1130: fnd_log.string(l_log_statement,
1131: L_DEBUG_KEY,
1132: 'Requested Date Quantity : '||l_atp_table.requested_date_quantity(i));
1133: fnd_log.string(l_log_statement,
1134: L_DEBUG_KEY,
1135: 'Calling Module : '||l_atp_table.Calling_module(i));
1136: END IF;
1137: END IF;

Line 1141: fnd_log.string(l_log_statement,

1137: END IF;
1138: END LOOP;
1139:
1140: IF (l_log_statement >= l_log_current_level) THEN
1141: fnd_log.string(l_log_statement,
1142: L_DEBUG_KEY,
1143: 'Before calling Mrp Atp Pub.Call_ATP. Calling Module count: '||
1144: l_atp_table.Calling_module.count);
1145: END IF;

Line 1159: fnd_log.string(l_log_statement,

1155: x_msg_data,
1156: x_msg_count);
1157:
1158: IF (l_log_statement >= l_log_current_level) THEN
1159: fnd_log.string(l_log_statement,
1160: L_DEBUG_KEY,
1161: 'After calling Mrp Atp Pub.Call_ATP. Return Status : '|| x_return_status);
1162: END IF;
1163:

Line 1179: fnd_log.string(l_log_statement,

1175: LOOP
1176: MSC_ATP_GLOBAL.Extend_ATP(x_atp_table, x_return_status);
1177: IF (x_atp_table.Error_Code.EXISTS(i) AND x_atp_table.error_code(i) <> 0) THEN
1178: IF (l_log_statement >= l_log_current_level)THEN
1179: fnd_log.string(l_log_statement,
1180: L_DEBUG_KEY,
1181: 'x_atp_table.error_code(i) : '||x_atp_table.error_code(i));
1182: END IF;
1183: MSC_ATP_GLOBAL.Extend_ATP(x_atp_table, x_return_status);

Line 1199: fnd_log.string(l_log_statement,

1195: --Error code is zero update the record
1196: MSC_ATP_GLOBAL.Extend_ATP(x_atp_table, x_return_status);
1197:
1198: IF (l_log_statement >= l_log_current_level)THEN
1199: fnd_log.string(l_log_statement,
1200: L_DEBUG_KEY,
1201: 'x_atp_table.identifier(i) : '|| x_atp_table.identifier(i));
1202: fnd_log.string(l_log_statement,
1203: L_DEBUG_KEY,

Line 1202: fnd_log.string(l_log_statement,

1198: IF (l_log_statement >= l_log_current_level)THEN
1199: fnd_log.string(l_log_statement,
1200: L_DEBUG_KEY,
1201: 'x_atp_table.identifier(i) : '|| x_atp_table.identifier(i));
1202: fnd_log.string(l_log_statement,
1203: L_DEBUG_KEY,
1204: 'x_atp_table.available_quantity(i) : '|| x_atp_table.available_quantity(i));
1205: fnd_log.string(l_log_statement,
1206: L_DEBUG_KEY,

Line 1205: fnd_log.string(l_log_statement,

1201: 'x_atp_table.identifier(i) : '|| x_atp_table.identifier(i));
1202: fnd_log.string(l_log_statement,
1203: L_DEBUG_KEY,
1204: 'x_atp_table.available_quantity(i) : '|| x_atp_table.available_quantity(i));
1205: fnd_log.string(l_log_statement,
1206: L_DEBUG_KEY,
1207: 'x_atp_table.requested_date_quantity(i) : '|| trunc(x_atp_table.requested_date_quantity(i)));
1208: fnd_log.string(l_log_statement,
1209: L_DEBUG_KEY,

Line 1208: fnd_log.string(l_log_statement,

1204: 'x_atp_table.available_quantity(i) : '|| x_atp_table.available_quantity(i));
1205: fnd_log.string(l_log_statement,
1206: L_DEBUG_KEY,
1207: 'x_atp_table.requested_date_quantity(i) : '|| trunc(x_atp_table.requested_date_quantity(i)));
1208: fnd_log.string(l_log_statement,
1209: L_DEBUG_KEY,
1210: 'x_atp_table.ship_date(i) : '|| x_atp_table.ship_date(i));
1211: END IF;
1212: --Assign out parameter

Line 1236: fnd_log.string(l_log_statement,

1232: IF l_temp_atp_table.COUNT > 0 THEN
1233: FOR i IN l_temp_atp_table.FIRST..l_temp_atp_table.LAST
1234: LOOP
1235: IF (l_log_statement >= l_log_current_level)THEN
1236: fnd_log.string(l_log_statement,
1237: L_DEBUG_KEY,
1238: 'Before assign out parameter, Sch Mat ID: '||
1239: l_temp_atp_table(i).schedule_material_id ||
1240: ', Quantity Available: '||

Line 1269: fnd_log.string(l_log_procedure,

1265: END IF;
1266: --Need to fix error messages
1267:
1268: IF (l_log_procedure >= l_log_current_level) THEN
1269: fnd_log.string(l_log_procedure,
1270: L_DEBUG_KEY ||'.end',
1271: 'At the end of PL SQL procedure. Return Status = ' || x_return_status);
1272: END IF;
1273: EXCEPTION

Line 1386: fnd_log.string(l_log_procedure,

1382: j NUMBER := 1;
1383: BEGIN
1384:
1385: IF (l_log_procedure >= l_log_current_level) THEN
1386: fnd_log.string(l_log_procedure,
1387: L_DEBUG_KEY ||'.begin',
1388: 'At the start of PL SQL procedure. Number of Records : ' || l_planned_matrl_tbl.COUNT);
1389: END IF;
1390: -- Standard Start of API savepoint

Line 1452: fnd_log.string(l_log_statement,

1448:
1449: --
1450: IF l_temp_planned_matrl_tbl.COUNT > 0 THEN
1451: IF (l_log_statement >= l_log_current_level) THEN
1452: fnd_log.string(l_log_statement,
1453: L_DEBUG_KEY,
1454: 'Before calling Call ATP');
1455: END IF;
1456:

Line 1469: fnd_log.string(l_log_statement,

1465: x_msg_data => l_msg_data);
1466: END IF;
1467:
1468: IF (l_log_statement >= l_log_current_level) THEN
1469: fnd_log.string(l_log_statement,
1470: L_DEBUG_KEY,
1471: 'After calling Call ATP. Return Status : '|| l_return_status ||
1472: ', Returned Final Records : '||l_temp_planned_matrl_tbl.COUNT);
1473: END IF;

Line 1518: fnd_log.string(l_log_statement,

1514: p_x_planned_matrl_tbl(i).error_code := l_temp_planned_matrl_tbl(i).error_code;
1515: p_x_planned_matrl_tbl(i).error_message := l_temp_planned_matrl_tbl(i).error_message;
1516:
1517: IF (l_log_statement >= l_log_current_level)THEN
1518: fnd_log.string(l_log_statement,
1519: L_DEBUG_KEY,
1520: 'After Assign, Sch Mat Id : ' || p_x_planned_matrl_tbl(i).schedule_material_id ||
1521: ', Quantity Available : ' || p_x_planned_matrl_tbl(i).quantity_available ||
1522: ', Scheduled Quantity : ' || p_x_planned_matrl_tbl(i).scheduled_date ||

Line 1536: fnd_log.string(l_log_procedure,

1532: COMMIT WORK;
1533: END IF;
1534:
1535: IF (l_log_procedure >= l_log_current_level) THEN
1536: fnd_log.string(l_log_procedure,
1537: L_DEBUG_KEY ||'.end',
1538: 'At the end of PL SQL procedure. Return Status = ' || x_return_status);
1539: END IF;
1540:

Line 1645: fnd_log.string(l_log_procedure,

1641: i NUMBER;
1642: BEGIN
1643:
1644: IF (l_log_procedure >= l_log_current_level) THEN
1645: fnd_log.string(l_log_procedure,
1646: L_DEBUG_KEY ||'.begin',
1647: 'At the start of PL SQL procedure. Visit Id = ' || p_visit_id);
1648: END IF;
1649: -- Standard Start of API savepoint

Line 1687: fnd_log.string(l_log_statement,

1683: CLOSE Get_Visit_Task_Matrl_Cur;
1684: END IF; --Visit not null
1685:
1686: IF (l_log_statement >= l_log_current_level) THEN
1687: fnd_log.string(l_log_statement,
1688: L_DEBUG_KEY,
1689: 'Before calling Call ATP No of Records'||l_planned_matrl_tbl.COUNT);
1690: END IF;
1691:

Line 1705: fnd_log.string(l_log_statement,

1701: x_msg_data => l_msg_data);
1702: END IF;
1703:
1704: IF (l_log_statement >= l_log_current_level) THEN
1705: fnd_log.string(l_log_statement,
1706: L_DEBUG_KEY,
1707: 'After calling Call ATP, Return Status : '|| l_return_status);
1708: END IF;
1709:

Line 1741: fnd_log.string(l_log_statement,

1737: x_Planned_Matrl_Tbl(i).error_code := l_Planned_Matrl_Tbl(i).error_code;
1738: x_Planned_Matrl_Tbl(i).error_message := l_Planned_Matrl_Tbl(i).error_message;
1739:
1740: IF (l_log_statement >= l_log_current_level) THEN
1741: fnd_log.string(l_log_statement,
1742: L_DEBUG_KEY,
1743: 'After Assign, Sch Mat Id : ' || x_planned_matrl_tbl(i).schedule_material_id ||
1744: ', Quantity Available : ' || x_planned_matrl_tbl(i).quantity_available ||
1745: ', Scheduled Quantity : ' || x_planned_matrl_tbl(i).scheduled_date ||

Line 1757: fnd_log.string(l_log_procedure,

1753: COMMIT WORK;
1754: END IF;
1755:
1756: IF (l_log_procedure >= l_log_current_level) THEN
1757: fnd_log.string(l_log_procedure,
1758: L_DEBUG_KEY ||'.end',
1759: 'At the end of PL SQL procedure. Return Status = ' || x_return_status);
1760: END IF;
1761: