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_RSV_RESERVATIONS_PVT dependencies on FND_LOG

Line 6: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;

2: /* $Header: AHLVRSVB.pls 120.17.12020000.2 2012/12/07 14:05:10 sareepar ship $ */
3: ------------------------------------
4: -- Common constants and variables --
5: ------------------------------------
6: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
7: l_log_statement NUMBER := fnd_log.level_statement;
8: l_log_procedure NUMBER := fnd_log.level_procedure;
9: l_log_error NUMBER := fnd_log.level_error;
10: l_log_unexpected NUMBER := fnd_log.level_unexpected;

Line 7: l_log_statement NUMBER := fnd_log.level_statement;

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

Line 8: l_log_procedure NUMBER := fnd_log.level_procedure;

4: -- Common constants and variables --
5: ------------------------------------
6: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
7: l_log_statement NUMBER := fnd_log.level_statement;
8: l_log_procedure NUMBER := fnd_log.level_procedure;
9: l_log_error NUMBER := fnd_log.level_error;
10: l_log_unexpected NUMBER := fnd_log.level_unexpected;
11:
12: -- Helper procedure added by skpathak on 12-NOV-2008 for bug 7241925

Line 9: l_log_error NUMBER := fnd_log.level_error;

5: ------------------------------------
6: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
7: l_log_statement NUMBER := fnd_log.level_statement;
8: l_log_procedure NUMBER := fnd_log.level_procedure;
9: l_log_error NUMBER := fnd_log.level_error;
10: l_log_unexpected NUMBER := fnd_log.level_unexpected;
11:
12: -- Helper procedure added by skpathak on 12-NOV-2008 for bug 7241925
13: -- Gets the reservation (if any) that matches the scheduled_material_id+serial_number

Line 10: l_log_unexpected NUMBER := fnd_log.level_unexpected;

6: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
7: l_log_statement NUMBER := fnd_log.level_statement;
8: l_log_procedure NUMBER := fnd_log.level_procedure;
9: l_log_error NUMBER := fnd_log.level_error;
10: l_log_unexpected NUMBER := fnd_log.level_unexpected;
11:
12: -- Helper procedure added by skpathak on 12-NOV-2008 for bug 7241925
13: -- Gets the reservation (if any) that matches the scheduled_material_id+serial_number
14: -- If p_match_serial is 'Y', also checks if the serial is already included in the reservation

Line 166: fnd_log.string

162: END IF;
163:
164: -- Log API entry point
165: IF (l_log_procedure >= l_log_current_level) THEN
166: fnd_log.string
167: (
168: fnd_log.level_procedure,
169: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
170: 'At the start of PL SQL procedure '

Line 168: fnd_log.level_procedure,

164: -- Log API entry point
165: IF (l_log_procedure >= l_log_current_level) THEN
166: fnd_log.string
167: (
168: fnd_log.level_procedure,
169: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
170: 'At the start of PL SQL procedure '
171: );
172: END IF;

Line 182: fnd_log.string

178: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_SNQTY_GTR_ZRO' );
179: FND_MSG_PUB.add;
180: -- log the error
181: IF (l_log_error >= l_log_current_level) THEN
182: fnd_log.string
183: (
184: fnd_log.level_error,
185: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
186: 'Number of Serial Numbers to be reserved equal to ZERO'

Line 184: fnd_log.level_error,

180: -- log the error
181: IF (l_log_error >= l_log_current_level) THEN
182: fnd_log.string
183: (
184: fnd_log.level_error,
185: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
186: 'Number of Serial Numbers to be reserved equal to ZERO'
187: );
188: END IF;

Line 200: fnd_log.string

196: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_INVLD_MAT_REQ' );
197: FND_MSG_PUB.add;
198: -- log the error
199: IF (l_log_error >= l_log_current_level) THEN
200: fnd_log.string
201: (
202: fnd_log.level_error,
203: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
204: 'get_mtl_req_dtls_csr, did not fetch any records'

Line 202: fnd_log.level_error,

198: -- log the error
199: IF (l_log_error >= l_log_current_level) THEN
200: fnd_log.string
201: (
202: fnd_log.level_error,
203: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
204: 'get_mtl_req_dtls_csr, did not fetch any records'
205: );
206: END IF;

Line 221: fnd_log.string

217: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_QTY_EXCDS_REQSTD' );
218: FND_MSG_PUB.add;
219: -- log the error
220: IF (l_log_error >= l_log_current_level) THEN
221: fnd_log.string
222: (
223: fnd_log.level_error,
224: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
225: 'Number of serial numbers + Completed Qty + Reserved Qty is more than Requested Qty '

Line 223: fnd_log.level_error,

219: -- log the error
220: IF (l_log_error >= l_log_current_level) THEN
221: fnd_log.string
222: (
223: fnd_log.level_error,
224: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
225: 'Number of serial numbers + Completed Qty + Reserved Qty is more than Requested Qty '
226: );
227: END IF;

Line 250: fnd_log.string

246: FND_MESSAGE.Set_Token('SERIALNUMBER',p_serial_number_tbl(i).serial_number);
247: FND_MSG_PUB.add;
248: -- log the error
249: IF (l_log_error >= l_log_current_level) THEN
250: fnd_log.string
251: (
252: fnd_log.level_error,
253: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
254: 'get_instance_dtls_csr, did not fetch any records'

Line 252: fnd_log.level_error,

248: -- log the error
249: IF (l_log_error >= l_log_current_level) THEN
250: fnd_log.string
251: (
252: fnd_log.level_error,
253: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
254: 'get_instance_dtls_csr, did not fetch any records'
255: );
256: END IF;

Line 281: fnd_log.string(fnd_log.level_statement, l_debug_module,

277: x_reservation_id => l_reservation_id,
278: x_reservation_quantity => l_x_quantity_reserved);
279:
280: IF (l_log_statement >= l_log_current_level) THEN
281: fnd_log.string(fnd_log.level_statement, l_debug_module,
282: 'GET_MATCHING_RESERVATION returned l_reservation_id = ' || l_reservation_id ||
283: ', l_x_quantity_reserved = ' || l_x_quantity_reserved);
284: END IF;
285: -- End Changes by skpathak on 12-NOV-2008 for bug 7241925

Line 300: fnd_log.string

296: -- Added by jaramana on June 29, 2005
297: l_serial_number_tbl(1).inventory_item_id := l_mtl_req_dtls_rec.inventory_item_id;
298:
299: IF (l_log_statement >= l_log_current_level) THEN
300: fnd_log.string
301: (
302: fnd_log.level_statement,
303: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
304: 'Calling WMS api:inv_reservation_pub.create_reservation'

Line 302: fnd_log.level_statement,

298:
299: IF (l_log_statement >= l_log_current_level) THEN
300: fnd_log.string
301: (
302: fnd_log.level_statement,
303: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
304: 'Calling WMS api:inv_reservation_pub.create_reservation'
305: );
306: END IF;

Line 334: fnd_log.string

330: -- initialize the table
331: l_serial_number_tbl.DELETE;
332:
333: IF (l_log_statement >= l_log_current_level) THEN
334: fnd_log.string
335: (
336: fnd_log.level_statement,
337: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
338: 'Calling WMS api:inv_reservation_pub.update_reservation'

Line 336: fnd_log.level_statement,

332:
333: IF (l_log_statement >= l_log_current_level) THEN
334: fnd_log.string
335: (
336: fnd_log.level_statement,
337: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
338: 'Calling WMS api:inv_reservation_pub.update_reservation'
339: );
340: END IF;

Line 359: fnd_log.string

355: -- Check the error status
356: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
357: -- log the error
358: IF (l_log_error >= l_log_current_level) THEN
359: fnd_log.string
360: (
361: fnd_log.level_error,
362: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
363: 'Call to WMS returned Unexpected Error'

Line 361: fnd_log.level_error,

357: -- log the error
358: IF (l_log_error >= l_log_current_level) THEN
359: fnd_log.string
360: (
361: fnd_log.level_error,
362: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
363: 'Call to WMS returned Unexpected Error'
364: );
365: END IF;

Line 370: fnd_log.string

366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
367: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
368: -- log the error
369: IF (l_log_error >= l_log_current_level) THEN
370: fnd_log.string
371: (
372: fnd_log.level_error,
373: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
374: 'Call to WMS returned Expected Error'

Line 372: fnd_log.level_error,

368: -- log the error
369: IF (l_log_error >= l_log_current_level) THEN
370: fnd_log.string
371: (
372: fnd_log.level_error,
373: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
374: 'Call to WMS returned Expected Error'
375: );
376: END IF;

Line 387: fnd_log.string

383: IF x_msg_count > 0
384: THEN
385: -- log the error
386: IF (l_log_error >= l_log_current_level) THEN
387: fnd_log.string
388: (
389: fnd_log.level_error,
390: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
391: 'Call to WMS returned Errors in x_msg_count'

Line 389: fnd_log.level_error,

385: -- log the error
386: IF (l_log_error >= l_log_current_level) THEN
387: fnd_log.string
388: (
389: fnd_log.level_error,
390: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
391: 'Call to WMS returned Errors in x_msg_count'
392: );
393: END IF;

Line 402: fnd_log.string

398: IF FND_API.TO_BOOLEAN(p_commit)
399: THEN
400: COMMIT WORK;
401: IF (l_log_statement >= l_log_current_level) THEN
402: fnd_log.string
403: (
404: fnd_log.level_statement,
405: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
406: 'Committed'

Line 404: fnd_log.level_statement,

400: COMMIT WORK;
401: IF (l_log_statement >= l_log_current_level) THEN
402: fnd_log.string
403: (
404: fnd_log.level_statement,
405: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
406: 'Committed'
407: );
408: END IF;

Line 421: fnd_log.string

417: );
418:
419: -- Log API exit point
420: IF (l_log_procedure >= l_log_current_level)THEN
421: fnd_log.string
422: (
423: fnd_log.level_procedure,
424: l_debug_module||'.end',
425: 'At the end of PLSQL procedure'

Line 423: fnd_log.level_procedure,

419: -- Log API exit point
420: IF (l_log_procedure >= l_log_current_level)THEN
421: fnd_log.string
422: (
423: fnd_log.level_procedure,
424: l_debug_module||'.end',
425: 'At the end of PLSQL procedure'
426: );
427: END IF;

Line 528: l_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

524: l_to_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
525: l_from_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
526:
527: -- Variables to check the log level according to the coding standards
528: l_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
529: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
530:
531:
532: -- Declare cursors

Line 529: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

525: l_from_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
526:
527: -- Variables to check the log level according to the coding standards
528: l_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
529: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
530:
531:
532: -- Declare cursors
533: CURSOR get_mtl_req_dtls_csr (c_scheduled_material_id IN NUMBER)

Line 571: fnd_log.string

567: END IF;
568:
569: -- Log API entry point
570: IF (l_log_procedure >= l_log_current_level)THEN
571: fnd_log.string
572: (
573: fnd_log.level_procedure,
574: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
575: 'At the start of PL SQL procedure '

Line 573: fnd_log.level_procedure,

569: -- Log API entry point
570: IF (l_log_procedure >= l_log_current_level)THEN
571: fnd_log.string
572: (
573: fnd_log.level_procedure,
574: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
575: 'At the start of PL SQL procedure '
576: );
577: END IF;

Line 586: fnd_log.string

582: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_INVLD_MAT_REQ' );
583: FND_MSG_PUB.add;
584: -- log the error
585: IF (l_log_error >= l_log_current_level) THEN
586: fnd_log.string
587: (
588: fnd_log.level_error,
589: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
590: 'schedule material id is null'

Line 588: fnd_log.level_error,

584: -- log the error
585: IF (l_log_error >= l_log_current_level) THEN
586: fnd_log.string
587: (
588: fnd_log.level_error,
589: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
590: 'schedule material id is null'
591: );
592: END IF;

Line 604: fnd_log.string

600: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_INVLD_MAT_REQ' );
601: FND_MSG_PUB.add;
602: -- log the error
603: IF (l_log_error >= l_log_current_level) THEN
604: fnd_log.string
605: (
606: fnd_log.level_error,
607: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
608: 'Invalid Material Requirement ID'

Line 606: fnd_log.level_error,

602: -- log the error
603: IF (l_log_error >= l_log_current_level) THEN
604: fnd_log.string
605: (
606: fnd_log.level_error,
607: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
608: 'Invalid Material Requirement ID'
609: );
610: END IF;

Line 622: fnd_log.string

618: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_INVLD_REQ_DATE' );
619: FND_MSG_PUB.add;
620: -- log the error
621: IF (l_log_error >= l_log_current_level) THEN
622: fnd_log.string
623: (
624: fnd_log.level_error,
625: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
626: 'Requested Date is null'

Line 624: fnd_log.level_error,

620: -- log the error
621: IF (l_log_error >= l_log_current_level) THEN
622: fnd_log.string
623: (
624: fnd_log.level_error,
625: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
626: 'Requested Date is null'
627: );
628: END IF;

Line 635: fnd_log.string

631:
632: -- if the dates are the same, no need to do anything
633: IF p_requested_date = l_requested_date THEN
634: IF (l_log_statement >= l_log_current_level) THEN
635: fnd_log.string
636: (
637: fnd_log.level_statement,
638: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
639: 'No change in dates, returning to caller'

Line 637: fnd_log.level_statement,

633: IF p_requested_date = l_requested_date THEN
634: IF (l_log_statement >= l_log_current_level) THEN
635: fnd_log.string
636: (
637: fnd_log.level_statement,
638: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
639: 'No change in dates, returning to caller'
640: );
641: END IF;

Line 660: fnd_log.string

656: l_to_serial_number_tbl(1).serial_number := p_serial_number_tbl(i).serial_number;
657: l_to_serial_number_tbl(1).inventory_item_id := l_mtl_req_dtls_rec.inventory_item;
658: */
659: IF (l_log_statement >= l_log_current_level) THEN
660: fnd_log.string
661: (
662: fnd_log.level_statement,
663: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
664: 'Calling WMS api:inv_reservation_pub.update_reservation'

Line 662: fnd_log.level_statement,

658: */
659: IF (l_log_statement >= l_log_current_level) THEN
660: fnd_log.string
661: (
662: fnd_log.level_statement,
663: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
664: 'Calling WMS api:inv_reservation_pub.update_reservation'
665: );
666: END IF;

Line 684: fnd_log.string

680:
681: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
682: -- log the error
683: IF (l_log_error >= l_log_current_level) THEN
684: fnd_log.string
685: (
686: fnd_log.level_error,
687: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
688: 'Call to WMS returned Unexpected Error'

Line 686: fnd_log.level_error,

682: -- log the error
683: IF (l_log_error >= l_log_current_level) THEN
684: fnd_log.string
685: (
686: fnd_log.level_error,
687: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
688: 'Call to WMS returned Unexpected Error'
689: );
690: END IF;

Line 696: fnd_log.string

692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
693: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
694: -- log the error
695: IF (l_log_error >= l_log_current_level) THEN
696: fnd_log.string
697: (
698: fnd_log.level_error,
699: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
700: 'Call to WMS returned Expected Error'

Line 698: fnd_log.level_error,

694: -- log the error
695: IF (l_log_error >= l_log_current_level) THEN
696: fnd_log.string
697: (
698: fnd_log.level_error,
699: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
700: 'Call to WMS returned Expected Error'
701: );
702: END IF;

Line 714: fnd_log.string

710: IF x_msg_count > 0
711: THEN
712: -- log the error
713: IF (l_log_error >= l_log_current_level) THEN
714: fnd_log.string
715: (
716: fnd_log.level_error,
717: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
718: 'Call to WMS returned Errors in x_msg_count'

Line 716: fnd_log.level_error,

712: -- log the error
713: IF (l_log_error >= l_log_current_level) THEN
714: fnd_log.string
715: (
716: fnd_log.level_error,
717: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
718: 'Call to WMS returned Errors in x_msg_count'
719: );
720: END IF;

Line 729: fnd_log.string

725: IF FND_API.TO_BOOLEAN(p_commit)
726: THEN
727: COMMIT WORK;
728: IF (l_log_statement >= l_log_current_level) THEN
729: fnd_log.string
730: (
731: fnd_log.level_statement,
732: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
733: 'Committed'

Line 731: fnd_log.level_statement,

727: COMMIT WORK;
728: IF (l_log_statement >= l_log_current_level) THEN
729: fnd_log.string
730: (
731: fnd_log.level_statement,
732: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
733: 'Committed'
734: );
735: END IF;

Line 748: fnd_log.string

744: );
745:
746: -- Log API exit point
747: IF (l_log_procedure >= l_log_current_level)THEN
748: fnd_log.string
749: (
750: fnd_log.level_procedure,
751: l_debug_module||'.end',
752: 'At the end of PLSQL procedure'

Line 750: fnd_log.level_procedure,

746: -- Log API exit point
747: IF (l_log_procedure >= l_log_current_level)THEN
748: fnd_log.string
749: (
750: fnd_log.level_procedure,
751: l_debug_module||'.end',
752: 'At the end of PLSQL procedure'
753: );
754: END IF;

Line 855: l_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

851: l_ret_value NUMBER;
852: l_reservation_id NUMBER;
853:
854: -- Variables to check the log level according to the coding standards
855: l_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
856: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
857:
858: l_temp NUMBER;
859:

Line 856: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

852: l_reservation_id NUMBER;
853:
854: -- Variables to check the log level according to the coding standards
855: l_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
856: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
857:
858: l_temp NUMBER;
859:
860:

Line 903: fnd_log.string

899: END IF;
900:
901: -- Log API entry point
902: IF (l_log_procedure >= l_log_current_level)THEN
903: fnd_log.string
904: (
905: fnd_log.level_procedure,
906: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
907: 'At the start of PL SQL procedure '

Line 905: fnd_log.level_procedure,

901: -- Log API entry point
902: IF (l_log_procedure >= l_log_current_level)THEN
903: fnd_log.string
904: (
905: fnd_log.level_procedure,
906: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
907: 'At the start of PL SQL procedure '
908: );
909: END IF;

Line 920: fnd_log.string

916: END IF;
917:
918: -- log the p_scheduled_material_id and the p_sub_inventory_code
919: IF (l_log_statement >= l_log_current_level) THEN
920: fnd_log.string
921: (
922: fnd_log.level_statement,
923: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
924: 'p_scheduled_material_id' || p_scheduled_material_id

Line 922: fnd_log.level_statement,

918: -- log the p_scheduled_material_id and the p_sub_inventory_code
919: IF (l_log_statement >= l_log_current_level) THEN
920: fnd_log.string
921: (
922: fnd_log.level_statement,
923: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
924: 'p_scheduled_material_id' || p_scheduled_material_id
925: );
926: fnd_log.string

Line 926: fnd_log.string

922: fnd_log.level_statement,
923: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
924: 'p_scheduled_material_id' || p_scheduled_material_id
925: );
926: fnd_log.string
927: (
928: fnd_log.level_statement,
929: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
930: 'p_sub_inventory_code' || p_sub_inventory_code

Line 928: fnd_log.level_statement,

924: 'p_scheduled_material_id' || p_scheduled_material_id
925: );
926: fnd_log.string
927: (
928: fnd_log.level_statement,
929: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
930: 'p_sub_inventory_code' || p_sub_inventory_code
931: );
932: END IF;

Line 946: fnd_log.string

942: FND_MESSAGE.Set_Name('AHL','AHL_RSV_INVLD_MAT_REQ');
943: FND_MSG_PUB.ADD;
944: -- log the error
945: IF (l_log_error >= l_log_current_level) THEN
946: fnd_log.string
947: (
948: fnd_log.level_error,
949: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
950: 'Invalid Material Requirement ID'

Line 948: fnd_log.level_error,

944: -- log the error
945: IF (l_log_error >= l_log_current_level) THEN
946: fnd_log.string
947: (
948: fnd_log.level_error,
949: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
950: 'Invalid Material Requirement ID'
951: );
952: END IF;

Line 966: fnd_log.string(fnd_log.level_statement, l_debug_module,

962: x_reservation_id => l_reservation_id,
963: x_reservation_quantity => l_temp);
964:
965: IF (l_log_statement >= l_log_current_level) THEN
966: fnd_log.string(fnd_log.level_statement, l_debug_module,
967: 'GET_MATCHING_RESERVATION returned l_reservation_id = ' || l_reservation_id);
968: END IF;
969:
970: IF (l_reservation_id IS NOT NULL) THEN

Line 972: fnd_log.string(fnd_log.level_statement, l_debug_module,

968: END IF;
969:
970: IF (l_reservation_id IS NOT NULL) THEN
971: IF (l_log_statement >= l_log_current_level) THEN
972: fnd_log.string(fnd_log.level_statement, l_debug_module,
973: 'About to Call inv_reservation_pub.delete_reservation with l_reservation_id: ' || l_reservation_id);
974: END IF;
975:
976: -- Assign the reservation id to be deleted

Line 990: fnd_log.string(fnd_log.level_statement, l_debug_module,

986: p_rsv_rec => l_rsv_rec,
987: p_serial_number => l_serial_number_tbl
988: );
989: IF (l_log_statement >= l_log_current_level) THEN
990: fnd_log.string(fnd_log.level_statement, l_debug_module,
991: 'Returned from inv_reservation_pub.delete_reservation, l_return_status: ' || l_return_status);
992: END IF;
993: -- Check whether the return status is success, if not raise exception
994: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 997: fnd_log.string(fnd_log.level_error, l_debug_module,

993: -- Check whether the return status is success, if not raise exception
994: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
995: -- log the error
996: IF (l_log_error >= l_log_current_level) THEN
997: fnd_log.string(fnd_log.level_error, l_debug_module,
998: 'inv_reservation_pub.delete_reservation returned FND_API.G_RET_STS_UNEXP_ERROR');
999: END IF;
1000: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1001: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 1004: fnd_log.string(fnd_log.level_error, l_debug_module,

1000: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1001: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1002: -- log the error
1003: IF (l_log_error >= l_log_current_level) THEN
1004: fnd_log.string(fnd_log.level_error, l_debug_module,
1005: 'inv_reservation_pub.delete_reservation returned FND_API.G_RET_STS_ERROR');
1006: END IF;
1007: RAISE FND_API.G_EXC_ERROR;
1008: END IF;

Line 1019: fnd_log.string

1015: FETCH get_reservation_csr INTO l_reservation_id;
1016: EXIT WHEN get_reservation_csr%NOTFOUND;
1017: -- logging
1018: IF (l_log_statement >= l_log_current_level) THEN
1019: fnd_log.string
1020: (
1021: fnd_log.level_statement,
1022: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1023: 'Going to Call inv_reservation_pub.delete_reservation l_reservation_id :' || l_reservation_id

Line 1021: fnd_log.level_statement,

1017: -- logging
1018: IF (l_log_statement >= l_log_current_level) THEN
1019: fnd_log.string
1020: (
1021: fnd_log.level_statement,
1022: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1023: 'Going to Call inv_reservation_pub.delete_reservation l_reservation_id :' || l_reservation_id
1024: );
1025: END IF;

Line 1041: fnd_log.string

1037: p_rsv_rec => l_rsv_rec,
1038: p_serial_number => l_serial_number_tbl
1039: );
1040: IF (l_log_statement >= l_log_current_level) THEN
1041: fnd_log.string
1042: (
1043: fnd_log.level_statement,
1044: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1045: 'After call inv_reservation_pub.delete_reservation,l_return_status :' || l_return_status

Line 1043: fnd_log.level_statement,

1039: );
1040: IF (l_log_statement >= l_log_current_level) THEN
1041: fnd_log.string
1042: (
1043: fnd_log.level_statement,
1044: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1045: 'After call inv_reservation_pub.delete_reservation,l_return_status :' || l_return_status
1046: );
1047: END IF;

Line 1052: fnd_log.string

1048: -- Check whether the return status is success, if not raise exception
1049: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1050: -- log the error
1051: IF (l_log_error >= l_log_current_level) THEN
1052: fnd_log.string
1053: (
1054: fnd_log.level_error,
1055: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1056: 'inv_reservation_pub.delete_reservation returned FND_API.G_RET_STS_UNEXP_ERROR'

Line 1054: fnd_log.level_error,

1050: -- log the error
1051: IF (l_log_error >= l_log_current_level) THEN
1052: fnd_log.string
1053: (
1054: fnd_log.level_error,
1055: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1056: 'inv_reservation_pub.delete_reservation returned FND_API.G_RET_STS_UNEXP_ERROR'
1057: );
1058: END IF;

Line 1064: fnd_log.string

1060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1061: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1062: -- log the error
1063: IF (l_log_error >= l_log_current_level) THEN
1064: fnd_log.string
1065: (
1066: fnd_log.level_error,
1067: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1068: 'inv_reservation_pub.delete_reservation returned FND_API.G_RET_STS_ERROR'

Line 1066: fnd_log.level_error,

1062: -- log the error
1063: IF (l_log_error >= l_log_current_level) THEN
1064: fnd_log.string
1065: (
1066: fnd_log.level_error,
1067: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1068: 'inv_reservation_pub.delete_reservation returned FND_API.G_RET_STS_ERROR'
1069: );
1070: END IF;

Line 1079: fnd_log.string

1075: END IF;
1076:
1077: -- Log API exit point
1078: IF (l_log_procedure >= l_log_current_level)THEN
1079: fnd_log.string
1080: (
1081: fnd_log.level_procedure,
1082: l_debug_module||'.end',
1083: 'At the end of PLSQL procedure'

Line 1081: fnd_log.level_procedure,

1077: -- Log API exit point
1078: IF (l_log_procedure >= l_log_current_level)THEN
1079: fnd_log.string
1080: (
1081: fnd_log.level_procedure,
1082: l_debug_module||'.end',
1083: 'At the end of PLSQL procedure'
1084: );
1085: END IF;

Line 1099: fnd_log.string

1095: IF FND_API.TO_BOOLEAN(p_commit)
1096: THEN
1097: COMMIT WORK;
1098: IF (l_log_statement >= l_log_current_level) THEN
1099: fnd_log.string
1100: (
1101: fnd_log.level_statement,
1102: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1103: 'delete reservation COMMITTED'

Line 1101: fnd_log.level_statement,

1097: COMMIT WORK;
1098: IF (l_log_statement >= l_log_current_level) THEN
1099: fnd_log.string
1100: (
1101: fnd_log.level_statement,
1102: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1103: 'delete reservation COMMITTED'
1104: );
1105: END IF;

Line 1213: l_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1209: l_x_primary_relieved_quantity NUMBER;
1210: l_x_primary_remain_quantity NUMBER;
1211:
1212: -- Variables to check the log level according to the coding standards
1213: l_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1214: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1215:
1216: -- Declare Cursors
1217: CURSOR get_mtl_req_dtls_csr (c_scheduled_material_id IN NUMBER)

Line 1214: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

1210: l_x_primary_remain_quantity NUMBER;
1211:
1212: -- Variables to check the log level according to the coding standards
1213: l_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1214: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1215:
1216: -- Declare Cursors
1217: CURSOR get_mtl_req_dtls_csr (c_scheduled_material_id IN NUMBER)
1218: IS

Line 1291: fnd_log.string

1287: END IF;
1288:
1289: -- Log API entry point
1290: IF (l_log_procedure >= l_log_current_level)THEN
1291: fnd_log.string
1292: (
1293: fnd_log.level_procedure,
1294: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
1295: 'At the start of PL SQL procedure '

Line 1293: fnd_log.level_procedure,

1289: -- Log API entry point
1290: IF (l_log_procedure >= l_log_current_level)THEN
1291: fnd_log.string
1292: (
1293: fnd_log.level_procedure,
1294: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
1295: 'At the start of PL SQL procedure '
1296: );
1297: END IF;

Line 1305: fnd_log.string

1301: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_INVLD_MAT_REQ' );
1302: FND_MSG_PUB.add;
1303: -- log the error
1304: IF (l_log_error >= l_log_current_level) THEN
1305: fnd_log.string
1306: (
1307: fnd_log.level_error,
1308: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1309: 'AHL_RSV_INVLD_MAT_REQ: FND_API.G_EXC_ERROR'

Line 1307: fnd_log.level_error,

1303: -- log the error
1304: IF (l_log_error >= l_log_current_level) THEN
1305: fnd_log.string
1306: (
1307: fnd_log.level_error,
1308: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1309: 'AHL_RSV_INVLD_MAT_REQ: FND_API.G_EXC_ERROR'
1310: );
1311: END IF;

Line 1332: fnd_log.string

1328: IF p_serial_number IS NULL THEN
1329: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_INVLD_SL_NUM' );
1330: FND_MSG_PUB.add;
1331: IF (l_log_error>= l_log_current_level)THEN
1332: fnd_log.string
1333: (
1334: fnd_log.level_error,
1335: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1336: 'p_serial_number is null'

Line 1334: fnd_log.level_error,

1330: FND_MSG_PUB.add;
1331: IF (l_log_error>= l_log_current_level)THEN
1332: fnd_log.string
1333: (
1334: fnd_log.level_error,
1335: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1336: 'p_serial_number is null'
1337: );
1338: END IF;

Line 1354: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,

1350: END IF; -- IF get_instance_dtls_csr%NOTFOUND
1351: CLOSE get_instance_dtls_csr;
1352:
1353: IF (l_log_statement >= l_log_current_level) THEN
1354: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1355: 'Serial Number to be Deleted:' || p_serial_number );
1356: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1357: 'l_get_mtl_req_dtls_rec.inventory_item_id:' ||l_get_mtl_req_dtls_rec.inventory_item_id );
1358: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,

Line 1356: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,

1352:
1353: IF (l_log_statement >= l_log_current_level) THEN
1354: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1355: 'Serial Number to be Deleted:' || p_serial_number );
1356: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1357: 'l_get_mtl_req_dtls_rec.inventory_item_id:' ||l_get_mtl_req_dtls_rec.inventory_item_id );
1358: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1359: 'l_get_mtl_req_dtls_rec.organization_id:' || l_get_mtl_req_dtls_rec.organization_id );
1360: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,

Line 1358: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,

1354: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1355: 'Serial Number to be Deleted:' || p_serial_number );
1356: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1357: 'l_get_mtl_req_dtls_rec.inventory_item_id:' ||l_get_mtl_req_dtls_rec.inventory_item_id );
1358: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1359: 'l_get_mtl_req_dtls_rec.organization_id:' || l_get_mtl_req_dtls_rec.organization_id );
1360: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1361: 'p_scheduled_material_id:' || p_scheduled_material_id );
1362: END IF;

Line 1360: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,

1356: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1357: 'l_get_mtl_req_dtls_rec.inventory_item_id:' ||l_get_mtl_req_dtls_rec.inventory_item_id );
1358: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1359: 'l_get_mtl_req_dtls_rec.organization_id:' || l_get_mtl_req_dtls_rec.organization_id );
1360: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1361: 'p_scheduled_material_id:' || p_scheduled_material_id );
1362: END IF;
1363:
1364:

Line 1385: fnd_log.string(fnd_log.level_statement, l_debug_module,

1381: x_reservation_id => l_reservation_id,
1382: x_reservation_quantity => l_reserved_quantity);
1383:
1384: IF (l_log_statement >= l_log_current_level) THEN
1385: fnd_log.string(fnd_log.level_statement, l_debug_module,
1386: 'GET_MATCHING_RESERVATION returned l_reservation_id = ' || l_reservation_id ||
1387: ', l_reserved_quantity = ' || l_reserved_quantity);
1388: END IF;
1389: -- End Changes by skpathak on 12-NOV-2008 for bug 7241925

Line 1442: fnd_log.string

1438:
1439: -- Check for the returned status from these APIs
1440: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1441: IF (l_log_error >= l_log_current_level) THEN
1442: fnd_log.string
1443: (
1444: fnd_log.level_error,
1445: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1446: 'After Relieve/Delete FND_API.G_EXC_UNEXPECTED_ERROR'

Line 1444: fnd_log.level_error,

1440: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1441: IF (l_log_error >= l_log_current_level) THEN
1442: fnd_log.string
1443: (
1444: fnd_log.level_error,
1445: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1446: 'After Relieve/Delete FND_API.G_EXC_UNEXPECTED_ERROR'
1447: );
1448: END IF;

Line 1452: fnd_log.string

1448: END IF;
1449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1450: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1451: IF (l_log_error >= l_log_current_level) THEN
1452: fnd_log.string
1453: (
1454: fnd_log.level_error,
1455: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1456: 'After Relieve/Delete FND_API.G_EXC_ERROR'

Line 1454: fnd_log.level_error,

1450: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1451: IF (l_log_error >= l_log_current_level) THEN
1452: fnd_log.string
1453: (
1454: fnd_log.level_error,
1455: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1456: 'After Relieve/Delete FND_API.G_EXC_ERROR'
1457: );
1458: END IF;

Line 1464: fnd_log.string

1460: END IF;
1461:
1462: -- Log API exit point
1463: IF (l_log_procedure >= l_log_current_level)THEN
1464: fnd_log.string
1465: (
1466: fnd_log.level_procedure,
1467: l_debug_module||'.end',
1468: 'At the end of PLSQL procedure'

Line 1466: fnd_log.level_procedure,

1462: -- Log API exit point
1463: IF (l_log_procedure >= l_log_current_level)THEN
1464: fnd_log.string
1465: (
1466: fnd_log.level_procedure,
1467: l_debug_module||'.end',
1468: 'At the end of PLSQL procedure'
1469: );
1470: END IF;

Line 1589: l_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1585: l_to_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
1586: l_x_to_reservation_id NUMBER;
1587:
1588: -- Variables to check the log level according to the coding standards
1589: l_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1590: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1591:
1592: -- Declare Cursors and local record types
1593: CURSOR get_mtl_req_dtls_csr (c_visit_id IN NUMBER)

Line 1590: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

1586: l_x_to_reservation_id NUMBER;
1587:
1588: -- Variables to check the log level according to the coding standards
1589: l_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1590: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1591:
1592: -- Declare Cursors and local record types
1593: CURSOR get_mtl_req_dtls_csr (c_visit_id IN NUMBER)
1594: IS

Line 1645: fnd_log.string

1641: END IF;
1642:
1643: -- Log API entry point
1644: IF (l_log_procedure >= l_log_current_level)THEN
1645: fnd_log.string
1646: (
1647: fnd_log.level_procedure,
1648: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
1649: 'At the start of PL SQL procedure '

Line 1647: fnd_log.level_procedure,

1643: -- Log API entry point
1644: IF (l_log_procedure >= l_log_current_level)THEN
1645: fnd_log.string
1646: (
1647: fnd_log.level_procedure,
1648: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
1649: 'At the start of PL SQL procedure '
1650: );
1651: END IF;

Line 1680: fnd_log.string

1676: l_to_rsv_rec.demand_source_line_detail := l_get_mtl_req_dtls_rec.scheduled_material_id;
1677: l_from_rsv_rec.demand_source_line_detail := l_get_mtl_req_dtls_rec.scheduled_material_id;
1678:
1679: IF (l_log_statement >= l_log_current_level) THEN
1680: fnd_log.string
1681: (
1682: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1683: 'Before Calling inv_reservation_pub.transfer_reservation'
1684: );

Line 1682: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,

1678:
1679: IF (l_log_statement >= l_log_current_level) THEN
1680: fnd_log.string
1681: (
1682: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1683: 'Before Calling inv_reservation_pub.transfer_reservation'
1684: );
1685: fnd_log.string
1686: (

Line 1685: fnd_log.string

1681: (
1682: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1683: 'Before Calling inv_reservation_pub.transfer_reservation'
1684: );
1685: fnd_log.string
1686: (
1687: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1688: 'l_to_rsv_rec.demand_source_type_id' || l_to_rsv_rec.demand_source_type_id
1689: );

Line 1687: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,

1683: 'Before Calling inv_reservation_pub.transfer_reservation'
1684: );
1685: fnd_log.string
1686: (
1687: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1688: 'l_to_rsv_rec.demand_source_type_id' || l_to_rsv_rec.demand_source_type_id
1689: );
1690: fnd_log.string
1691: (

Line 1690: fnd_log.string

1686: (
1687: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1688: 'l_to_rsv_rec.demand_source_type_id' || l_to_rsv_rec.demand_source_type_id
1689: );
1690: fnd_log.string
1691: (
1692: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1693: 'l_to_rsv_rec.demand_source_header_id' || l_to_rsv_rec.demand_source_header_id
1694: );

Line 1692: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,

1688: 'l_to_rsv_rec.demand_source_type_id' || l_to_rsv_rec.demand_source_type_id
1689: );
1690: fnd_log.string
1691: (
1692: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1693: 'l_to_rsv_rec.demand_source_header_id' || l_to_rsv_rec.demand_source_header_id
1694: );
1695: fnd_log.string
1696: (

Line 1695: fnd_log.string

1691: (
1692: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1693: 'l_to_rsv_rec.demand_source_header_id' || l_to_rsv_rec.demand_source_header_id
1694: );
1695: fnd_log.string
1696: (
1697: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1698: 'l_to_rsv_rec.demand_source_line_detail' || l_to_rsv_rec.demand_source_line_detail
1699: );

Line 1697: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,

1693: 'l_to_rsv_rec.demand_source_header_id' || l_to_rsv_rec.demand_source_header_id
1694: );
1695: fnd_log.string
1696: (
1697: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1698: 'l_to_rsv_rec.demand_source_line_detail' || l_to_rsv_rec.demand_source_line_detail
1699: );
1700: fnd_log.string
1701: (

Line 1700: fnd_log.string

1696: (
1697: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1698: 'l_to_rsv_rec.demand_source_line_detail' || l_to_rsv_rec.demand_source_line_detail
1699: );
1700: fnd_log.string
1701: (
1702: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1703: 'l_from_rsv_rec.reservation_id' || l_from_rsv_rec.reservation_id
1704: );

Line 1702: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,

1698: 'l_to_rsv_rec.demand_source_line_detail' || l_to_rsv_rec.demand_source_line_detail
1699: );
1700: fnd_log.string
1701: (
1702: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1703: 'l_from_rsv_rec.reservation_id' || l_from_rsv_rec.reservation_id
1704: );
1705: fnd_log.string
1706: (

Line 1705: fnd_log.string

1701: (
1702: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1703: 'l_from_rsv_rec.reservation_id' || l_from_rsv_rec.reservation_id
1704: );
1705: fnd_log.string
1706: (
1707: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1708: 'l_to_serial_number_tbl.COUNT' || l_to_serial_number_tbl.COUNT
1709: );

Line 1707: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,

1703: 'l_from_rsv_rec.reservation_id' || l_from_rsv_rec.reservation_id
1704: );
1705: fnd_log.string
1706: (
1707: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1708: 'l_to_serial_number_tbl.COUNT' || l_to_serial_number_tbl.COUNT
1709: );
1710:
1711: END IF;

Line 1734: fnd_log.string

1730: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1731: CLOSE get_reservation_csr;
1732: CLOSE get_mtl_req_dtls_csr;
1733: IF (l_log_error >= l_log_current_level) THEN
1734: fnd_log.string
1735: (
1736: fnd_log.level_error,
1737: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1738: 'inv_reservation_pub.transfer_reservation returned FND_API.G_EXC_ERROR'

Line 1736: fnd_log.level_error,

1732: CLOSE get_mtl_req_dtls_csr;
1733: IF (l_log_error >= l_log_current_level) THEN
1734: fnd_log.string
1735: (
1736: fnd_log.level_error,
1737: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1738: 'inv_reservation_pub.transfer_reservation returned FND_API.G_EXC_ERROR'
1739: );
1740: END IF;

Line 1746: fnd_log.string

1742: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1743: CLOSE get_reservation_csr;
1744: CLOSE get_mtl_req_dtls_csr;
1745: IF (l_log_error >= l_log_current_level) THEN
1746: fnd_log.string
1747: (
1748: fnd_log.level_error,
1749: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1750: 'inv_reservation_pub.transfer_reservation returned FND_API.G_RET_STS_ERROR'

Line 1748: fnd_log.level_error,

1744: CLOSE get_mtl_req_dtls_csr;
1745: IF (l_log_error >= l_log_current_level) THEN
1746: fnd_log.string
1747: (
1748: fnd_log.level_error,
1749: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1750: 'inv_reservation_pub.transfer_reservation returned FND_API.G_RET_STS_ERROR'
1751: );
1752: END IF;

Line 1762: fnd_log.string

1758: CLOSE get_mtl_req_dtls_csr;
1759:
1760: -- Log API exit point
1761: IF (l_log_procedure >= l_log_current_level)THEN
1762: fnd_log.string
1763: (
1764: fnd_log.level_procedure,
1765: l_debug_module||'.end',
1766: 'At the end of PLSQL procedure'

Line 1764: fnd_log.level_procedure,

1760: -- Log API exit point
1761: IF (l_log_procedure >= l_log_current_level)THEN
1762: fnd_log.string
1763: (
1764: fnd_log.level_procedure,
1765: l_debug_module||'.end',
1766: 'At the end of PLSQL procedure'
1767: );
1768: END IF;

Line 1918: fnd_log.string

1914: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1915:
1916: -- Log API entry point
1917: IF (l_log_procedure >= l_log_current_level)THEN
1918: fnd_log.string
1919: (
1920: fnd_log.level_procedure,
1921: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
1922: 'At the start of PL SQL procedure '

Line 1920: fnd_log.level_procedure,

1916: -- Log API entry point
1917: IF (l_log_procedure >= l_log_current_level)THEN
1918: fnd_log.string
1919: (
1920: fnd_log.level_procedure,
1921: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
1922: 'At the start of PL SQL procedure '
1923: );
1924: END IF;

Line 1936: fnd_log.string

1932: -- Find out the new material requirements for this reservation
1933:
1934: l_reservation_id := l_get_upd_rsv_rec.reservation_id;
1935: IF (l_log_statement >= l_log_current_level) THEN
1936: fnd_log.string
1937: (
1938: fnd_log.level_statement,
1939: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1940: 'Reservation ID to be updated:' || l_reservation_id

Line 1938: fnd_log.level_statement,

1934: l_reservation_id := l_get_upd_rsv_rec.reservation_id;
1935: IF (l_log_statement >= l_log_current_level) THEN
1936: fnd_log.string
1937: (
1938: fnd_log.level_statement,
1939: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1940: 'Reservation ID to be updated:' || l_reservation_id
1941: );
1942: END IF;

Line 1946: fnd_log.string

1942: END IF;
1943:
1944: l_inventory_item_id := l_get_upd_rsv_rec.inventory_item_id;
1945: IF (l_log_statement >= l_log_current_level) THEN
1946: fnd_log.string
1947: (
1948: fnd_log.level_statement,
1949: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1950: 'Inventory Item ID: ' || l_inventory_item_id

Line 1948: fnd_log.level_statement,

1944: l_inventory_item_id := l_get_upd_rsv_rec.inventory_item_id;
1945: IF (l_log_statement >= l_log_current_level) THEN
1946: fnd_log.string
1947: (
1948: fnd_log.level_statement,
1949: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1950: 'Inventory Item ID: ' || l_inventory_item_id
1951: );
1952: END IF;

Line 1954: fnd_log.string

1950: 'Inventory Item ID: ' || l_inventory_item_id
1951: );
1952: END IF;
1953: IF (l_log_statement >= l_log_current_level) THEN
1954: fnd_log.string
1955: (
1956: fnd_log.level_statement,
1957: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1958: 'demand_source_header_id: ' || l_get_upd_rsv_rec.demand_source_header_id

Line 1956: fnd_log.level_statement,

1952: END IF;
1953: IF (l_log_statement >= l_log_current_level) THEN
1954: fnd_log.string
1955: (
1956: fnd_log.level_statement,
1957: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1958: 'demand_source_header_id: ' || l_get_upd_rsv_rec.demand_source_header_id
1959: );
1960: END IF;

Line 1962: fnd_log.string

1958: 'demand_source_header_id: ' || l_get_upd_rsv_rec.demand_source_header_id
1959: );
1960: END IF;
1961: IF (l_log_statement >= l_log_current_level) THEN
1962: fnd_log.string
1963: (
1964: fnd_log.level_statement,
1965: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1966: 'demand_source_line_id: ' || l_get_upd_rsv_rec.demand_source_line_id

Line 1964: fnd_log.level_statement,

1960: END IF;
1961: IF (l_log_statement >= l_log_current_level) THEN
1962: fnd_log.string
1963: (
1964: fnd_log.level_statement,
1965: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1966: 'demand_source_line_id: ' || l_get_upd_rsv_rec.demand_source_line_id
1967: );
1968: END IF;

Line 1978: fnd_log.string

1974: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_UPD_VST_RSV_FAIL' );
1975: FND_MSG_PUB.add;
1976: -- log the error
1977: IF (l_log_error >= l_log_current_level) THEN
1978: fnd_log.string
1979: (
1980: fnd_log.level_error,
1981: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
1982: 'No record found in ahl schedule materials for get_mtl_req_id_csr'

Line 1980: fnd_log.level_error,

1976: -- log the error
1977: IF (l_log_error >= l_log_current_level) THEN
1978: fnd_log.string
1979: (
1980: fnd_log.level_error,
1981: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
1982: 'No record found in ahl schedule materials for get_mtl_req_id_csr'
1983: );
1984: END IF;

Line 1992: fnd_log.string

1988: END IF; -- IF get_mtl_req_id_csr%NOTFOUND
1989: CLOSE get_mtl_req_id_csr;
1990:
1991: IF (l_log_statement >= l_log_current_level) THEN
1992: fnd_log.string
1993: (
1994: fnd_log.level_statement,
1995: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1996: 'l_get_mtl_req_id_rec.scheduled_material_id: ' || l_get_mtl_req_id_rec.scheduled_material_id

Line 1994: fnd_log.level_statement,

1990:
1991: IF (l_log_statement >= l_log_current_level) THEN
1992: fnd_log.string
1993: (
1994: fnd_log.level_statement,
1995: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1996: 'l_get_mtl_req_id_rec.scheduled_material_id: ' || l_get_mtl_req_id_rec.scheduled_material_id
1997: );
1998: END IF;

Line 2012: fnd_log.string

2008: EXCEPTION
2009: WHEN NO_DATA_FOUND THEN
2010: -- log the error
2011: IF (l_log_statement >= l_log_current_level) THEN
2012: fnd_log.string
2013: (
2014: fnd_log.level_statement,
2015: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
2016: 'No Serial Numbers reseved for Reservation ID:' || l_reservation_id

Line 2014: fnd_log.level_statement,

2010: -- log the error
2011: IF (l_log_statement >= l_log_current_level) THEN
2012: fnd_log.string
2013: (
2014: fnd_log.level_statement,
2015: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
2016: 'No Serial Numbers reseved for Reservation ID:' || l_reservation_id
2017: );
2018: END IF;

Line 2029: fnd_log.string

2025: l_to_rsv_rec, -- record to be passed to the WMS packages
2026: l_return_status); -- return status
2027:
2028: IF (l_log_statement >= l_log_current_level) THEN
2029: fnd_log.string
2030: (
2031: fnd_log.level_statement,
2032: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2033: 'Organizzation ID is: ' || l_to_rsv_rec.organization_id

Line 2031: fnd_log.level_statement,

2027:
2028: IF (l_log_statement >= l_log_current_level) THEN
2029: fnd_log.string
2030: (
2031: fnd_log.level_statement,
2032: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2033: 'Organizzation ID is: ' || l_to_rsv_rec.organization_id
2034: );
2035: END IF;

Line 2039: fnd_log.string

2035: END IF;
2036:
2037: l_to_rsv_rec.primary_reservation_quantity := serial_num_tbl.count;
2038: IF (l_log_statement >= l_log_current_level) THEN
2039: fnd_log.string
2040: (
2041: fnd_log.level_statement,
2042: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2043: 'Number of Serial Numbers to be updated: ' || l_to_rsv_rec.primary_reservation_quantity

Line 2041: fnd_log.level_statement,

2037: l_to_rsv_rec.primary_reservation_quantity := serial_num_tbl.count;
2038: IF (l_log_statement >= l_log_current_level) THEN
2039: fnd_log.string
2040: (
2041: fnd_log.level_statement,
2042: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2043: 'Number of Serial Numbers to be updated: ' || l_to_rsv_rec.primary_reservation_quantity
2044: );
2045: END IF;

Line 2080: fnd_log.string

2076: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2077: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2078: -- log the error
2079: IF (l_log_statement >= l_log_current_level) THEN
2080: fnd_log.string
2081: (
2082: fnd_log.level_statement,
2083: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2084: 'inv_reservation_pub.update_reservation returned UNEXPECTED ERROR'

Line 2082: fnd_log.level_statement,

2078: -- log the error
2079: IF (l_log_statement >= l_log_current_level) THEN
2080: fnd_log.string
2081: (
2082: fnd_log.level_statement,
2083: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2084: 'inv_reservation_pub.update_reservation returned UNEXPECTED ERROR'
2085: );
2086: END IF;

Line 2092: fnd_log.string

2088: --RAISE FND_API.G_EXC_ERROR;
2089: x_return_status := FND_API.G_RET_STS_ERROR;
2090: -- log the error
2091: IF (l_log_statement >= l_log_current_level) THEN
2092: fnd_log.string
2093: (
2094: fnd_log.level_statement,
2095: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2096: 'inv_reservation_pub.update_reservation returned EXPECTED ERROR'

Line 2094: fnd_log.level_statement,

2090: -- log the error
2091: IF (l_log_statement >= l_log_current_level) THEN
2092: fnd_log.string
2093: (
2094: fnd_log.level_statement,
2095: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2096: 'inv_reservation_pub.update_reservation returned EXPECTED ERROR'
2097: );
2098: END IF;

Line 2105: fnd_log.string

2101: CLOSE get_upd_rsv_csr;
2102:
2103: -- Log API exit point
2104: IF (l_log_procedure >= l_log_current_level)THEN
2105: fnd_log.string
2106: (
2107: fnd_log.level_procedure,
2108: l_debug_module||'.end',
2109: 'At the end of PLSQL procedure'

Line 2107: fnd_log.level_procedure,

2103: -- Log API exit point
2104: IF (l_log_procedure >= l_log_current_level)THEN
2105: fnd_log.string
2106: (
2107: fnd_log.level_procedure,
2108: l_debug_module||'.end',
2109: 'At the end of PLSQL procedure'
2110: );
2111: END IF;

Line 2155: l_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2151: l_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
2152: l_x_quantity_reserved NUMBER;
2153:
2154: -- Variables to check the log level according to the coding standards
2155: l_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2156: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
2157:
2158: l_reservation_id NUMBER:= null;
2159:

Line 2156: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

2152: l_x_quantity_reserved NUMBER;
2153:
2154: -- Variables to check the log level according to the coding standards
2155: l_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2156: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
2157:
2158: l_reservation_id NUMBER:= null;
2159:
2160: --Declare Cursors

Line 2194: fnd_log.string

2190: */
2191:
2192: -- Log API entry point
2193: IF (l_log_procedure >= l_log_current_level)THEN
2194: fnd_log.string
2195: (
2196: fnd_log.level_procedure,
2197: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
2198: 'At the start of PL SQL procedure '

Line 2196: fnd_log.level_procedure,

2192: -- Log API entry point
2193: IF (l_log_procedure >= l_log_current_level)THEN
2194: fnd_log.string
2195: (
2196: fnd_log.level_procedure,
2197: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
2198: 'At the start of PL SQL procedure '
2199: );
2200: END IF;

Line 2232: fnd_log.string

2228: CLOSE get_del_rsv_csr;
2229:
2230: -- Log API exit point
2231: IF (l_log_procedure >= l_log_current_level)THEN
2232: fnd_log.string
2233: (
2234: fnd_log.level_procedure,
2235: l_debug_module||'.end',
2236: 'At the end of PLSQL procedure'

Line 2234: fnd_log.level_procedure,

2230: -- Log API exit point
2231: IF (l_log_procedure >= l_log_current_level)THEN
2232: fnd_log.string
2233: (
2234: fnd_log.level_procedure,
2235: l_debug_module||'.end',
2236: 'At the end of PLSQL procedure'
2237: );
2238: END IF;

Line 2270: l_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2266: -- Declare local variables
2267: l_api_name CONSTANT VARCHAR2(30) := 'initialize_create_rec';
2268: l_debug_module CONSTANT VARCHAR2(100) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;
2269: -- Variables to check the log level according to the coding standards
2270: l_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2271: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
2272:
2273: -- Declare cursors
2274: -- Cursor to get the Material Requirement Details

Line 2271: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

2267: l_api_name CONSTANT VARCHAR2(30) := 'initialize_create_rec';
2268: l_debug_module CONSTANT VARCHAR2(100) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;
2269: -- Variables to check the log level according to the coding standards
2270: l_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2271: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
2272:
2273: -- Declare cursors
2274: -- Cursor to get the Material Requirement Details
2275: CURSOR get_mtl_req_dtls_csr (c_scheduled_material_id IN NUMBER)

Line 2318: fnd_log.string

2314: BEGIN
2315:
2316: -- Log API exit point
2317: IF (l_log_procedure >= l_log_current_level)THEN
2318: fnd_log.string
2319: (
2320: fnd_log.level_procedure,
2321: l_debug_module||'.start',
2322: 'At the start of PLSQL procedure'

Line 2320: fnd_log.level_procedure,

2316: -- Log API exit point
2317: IF (l_log_procedure >= l_log_current_level)THEN
2318: fnd_log.string
2319: (
2320: fnd_log.level_procedure,
2321: l_debug_module||'.start',
2322: 'At the start of PLSQL procedure'
2323: );
2324: END IF;

Line 2330: fnd_log.string

2326: -- Get the material requirement details
2327:
2328:
2329: IF (l_log_statement >= l_log_current_level) THEN
2330: fnd_log.string
2331: (
2332: fnd_log.level_statement,
2333: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2334: 'p_schedule_material_id in get_mtl_req_dtls_csr is:' || p_schedule_material_id

Line 2332: fnd_log.level_statement,

2328:
2329: IF (l_log_statement >= l_log_current_level) THEN
2330: fnd_log.string
2331: (
2332: fnd_log.level_statement,
2333: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2334: 'p_schedule_material_id in get_mtl_req_dtls_csr is:' || p_schedule_material_id
2335: );
2336: END IF;

Line 2343: fnd_log.string

2339: FETCH get_mtl_req_dtls_csr INTO l_get_mtl_req_dtls_rec;
2340: CLOSE get_mtl_req_dtls_csr;
2341:
2342: IF (l_log_statement >= l_log_current_level) THEN
2343: fnd_log.string
2344: (
2345: fnd_log.level_statement,
2346: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2347: 'Fetched Value of l_get_mtl_req_dtls_rec.organization_id is:' || l_get_mtl_req_dtls_rec.organization_id

Line 2345: fnd_log.level_statement,

2341:
2342: IF (l_log_statement >= l_log_current_level) THEN
2343: fnd_log.string
2344: (
2345: fnd_log.level_statement,
2346: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2347: 'Fetched Value of l_get_mtl_req_dtls_rec.organization_id is:' || l_get_mtl_req_dtls_rec.organization_id
2348: );
2349: END IF;

Line 2354: fnd_log.string

2350:
2351:
2352:
2353: IF (l_log_statement >= l_log_current_level) THEN
2354: fnd_log.string
2355: (
2356: fnd_log.level_statement,
2357: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2358: 'p_serial_number in get_subinv_locator is: ' || p_serial_number

Line 2356: fnd_log.level_statement,

2352:
2353: IF (l_log_statement >= l_log_current_level) THEN
2354: fnd_log.string
2355: (
2356: fnd_log.level_statement,
2357: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2358: 'p_serial_number in get_subinv_locator is: ' || p_serial_number
2359: );
2360: END IF;

Line 2362: fnd_log.string

2358: 'p_serial_number in get_subinv_locator is: ' || p_serial_number
2359: );
2360: END IF;
2361: IF (l_log_statement >= l_log_current_level) THEN
2362: fnd_log.string
2363: (
2364: fnd_log.level_statement,
2365: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2366: 'l_get_mtl_req_dtls_rec.inventory_item_id in get_subinv_locator is ' || l_get_mtl_req_dtls_rec.inventory_item_id

Line 2364: fnd_log.level_statement,

2360: END IF;
2361: IF (l_log_statement >= l_log_current_level) THEN
2362: fnd_log.string
2363: (
2364: fnd_log.level_statement,
2365: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2366: 'l_get_mtl_req_dtls_rec.inventory_item_id in get_subinv_locator is ' || l_get_mtl_req_dtls_rec.inventory_item_id
2367: );
2368: END IF;

Line 2449: fnd_log.string

2445: END IF; -- l_get_mtl_req_dtls_rec.task_status_code = 'RELEASED'
2446:
2447: -- Log API exit point
2448: IF (l_log_procedure >= l_log_current_level)THEN
2449: fnd_log.string
2450: (
2451: fnd_log.level_procedure,
2452: l_debug_module||'.end',
2453: 'At the end of PLSQL procedure'

Line 2451: fnd_log.level_procedure,

2447: -- Log API exit point
2448: IF (l_log_procedure >= l_log_current_level)THEN
2449: fnd_log.string
2450: (
2451: fnd_log.level_procedure,
2452: l_debug_module||'.end',
2453: 'At the end of PLSQL procedure'
2454: );
2455: END IF;

Line 2521: l_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2517: l_to_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
2518: l_x_to_reservation_id NUMBER;
2519:
2520: -- Variables to check the log level according to the coding standards
2521: l_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2522: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
2523:
2524: BEGIN
2525: -- Standard start of API savepoint

Line 2522: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

2518: l_x_to_reservation_id NUMBER;
2519:
2520: -- Variables to check the log level according to the coding standards
2521: l_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2522: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
2523:
2524: BEGIN
2525: -- Standard start of API savepoint
2526: SAVEPOINT TRNSFR_RSRV_FOR_MATRL_REQR_PVT;

Line 2545: fnd_log.string

2541: END IF;
2542:
2543: -- Log API entry point
2544: IF (l_log_procedure >= l_log_current_level)THEN
2545: fnd_log.string
2546: (
2547: fnd_log.level_procedure,
2548: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
2549: 'At the start of PL SQL procedure '

Line 2547: fnd_log.level_procedure,

2543: -- Log API entry point
2544: IF (l_log_procedure >= l_log_current_level)THEN
2545: fnd_log.string
2546: (
2547: fnd_log.level_procedure,
2548: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
2549: 'At the start of PL SQL procedure '
2550: );
2551: END IF;

Line 2559: fnd_log.string

2555: l_to_rsv_rec.demand_source_header_id := p_visit_task_id;
2556: l_to_rsv_rec.demand_source_line_detail := p_to_mat_req_id;
2557:
2558: IF (l_log_statement >= l_log_current_level)THEN
2559: fnd_log.string
2560: (fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,'Calling inv_reservation_pub.transfer_reservation');
2561: END IF;
2562:
2563: inv_reservation_pub.transfer_reservation

Line 2560: (fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,'Calling inv_reservation_pub.transfer_reservation');

2556: l_to_rsv_rec.demand_source_line_detail := p_to_mat_req_id;
2557:
2558: IF (l_log_statement >= l_log_current_level)THEN
2559: fnd_log.string
2560: (fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,'Calling inv_reservation_pub.transfer_reservation');
2561: END IF;
2562:
2563: inv_reservation_pub.transfer_reservation
2564: (

Line 2581: fnd_log.string

2577:
2578: -- Check for the returned status from these APIs
2579: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2580: IF (l_log_error >= l_log_current_level) THEN
2581: fnd_log.string
2582: (
2583: fnd_log.level_error,
2584: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2585: 'inv_reservation_pub.transfer_reservation returned FND_API.G_EXC_ERROR'

Line 2583: fnd_log.level_error,

2579: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2580: IF (l_log_error >= l_log_current_level) THEN
2581: fnd_log.string
2582: (
2583: fnd_log.level_error,
2584: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2585: 'inv_reservation_pub.transfer_reservation returned FND_API.G_EXC_ERROR'
2586: );
2587: END IF;

Line 2591: fnd_log.string

2587: END IF;
2588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2589: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2590: IF (l_log_error >= l_log_current_level) THEN
2591: fnd_log.string
2592: (
2593: fnd_log.level_error,
2594: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2595: 'inv_reservation_pub.transfer_reservation returned FND_API.G_RET_STS_ERROR'

Line 2593: fnd_log.level_error,

2589: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2590: IF (l_log_error >= l_log_current_level) THEN
2591: fnd_log.string
2592: (
2593: fnd_log.level_error,
2594: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2595: 'inv_reservation_pub.transfer_reservation returned FND_API.G_RET_STS_ERROR'
2596: );
2597: END IF;

Line 2603: fnd_log.string

2599: END IF;
2600:
2601: -- Log API exit point
2602: IF (l_log_procedure >= l_log_current_level)THEN
2603: fnd_log.string
2604: (
2605: fnd_log.level_procedure,
2606: l_debug_module||'.end',
2607: 'At the end of PLSQL procedure'

Line 2605: fnd_log.level_procedure,

2601: -- Log API exit point
2602: IF (l_log_procedure >= l_log_current_level)THEN
2603: fnd_log.string
2604: (
2605: fnd_log.level_procedure,
2606: l_debug_module||'.end',
2607: 'At the end of PLSQL procedure'
2608: );
2609: END IF;

Line 2708: fnd_log.string(fnd_log.level_procedure, l_debug_module||'.start',

2704: BEGIN
2705:
2706: -- Log API exit point
2707: IF (l_log_procedure >= l_log_current_level) THEN
2708: fnd_log.string(fnd_log.level_procedure, l_debug_module||'.start',
2709: 'At the start of PLSQL procedure, p_scheduled_material_id = ' || p_scheduled_material_id ||
2710: ', p_serial_number = ' || p_serial_number);
2711: END IF;
2712:

Line 2719: fnd_log.string(fnd_log.level_procedure, l_debug_module||'.end',

2715: CLOSE get_reservation_csr;
2716:
2717: -- Log API exit point
2718: IF (l_log_procedure >= l_log_current_level) THEN
2719: fnd_log.string(fnd_log.level_procedure, l_debug_module||'.end',
2720: 'At the end of PLSQL procedure, x_reservation_id = ' || x_reservation_id ||
2721: ', x_reservation_quantity = ' || x_reservation_quantity);
2722: END IF;
2723: END GET_MATCHING_RESERVATION;