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

Line 248: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

244: l_api_version CONSTANT NUMBER := 1.0;
245:
246: BEGIN
247:
248: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
249: fnd_log.string
250: (
251: fnd_log.level_statement,
252: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 249: fnd_log.string

245:
246: BEGIN
247:
248: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
249: fnd_log.string
250: (
251: fnd_log.level_statement,
252: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
253: 'Get_Serialtag_code Instance ID : '|| p_instance_id

Line 251: fnd_log.level_statement,

247:
248: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
249: fnd_log.string
250: (
251: fnd_log.level_statement,
252: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
253: 'Get_Serialtag_code Instance ID : '|| p_instance_id
254: );
255: END IF;

Line 262: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

258: p_instance_id = FND_API.G_MISS_NUM) THEN
259: RETURN NULL;
260: END IF;
261: --
262: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
263: fnd_log.string
264: (
265: fnd_log.level_statement,
266: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 263: fnd_log.string

259: RETURN NULL;
260: END IF;
261: --
262: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
263: fnd_log.string
264: (
265: fnd_log.level_statement,
266: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
267: 'Get_Serialtag_code Instance ID : '|| p_instance_id

Line 265: fnd_log.level_statement,

261: --
262: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
263: fnd_log.string
264: (
265: fnd_log.level_statement,
266: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
267: 'Get_Serialtag_code Instance ID : '|| p_instance_id
268: );
269: END IF;

Line 610: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

606:
607: --------------------------------------------
608: -- Dump API Inputs.
609: --------------------------------------------
610: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
611: fnd_log.string
612: (
613: fnd_log.level_statement,
614: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 611: fnd_log.string

607: --------------------------------------------
608: -- Dump API Inputs.
609: --------------------------------------------
610: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
611: fnd_log.string
612: (
613: fnd_log.level_statement,
614: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
615: 'p_serialnum_change_rec.workorder_id -> '||p_serialnum_change_rec.workorder_id

Line 613: fnd_log.level_statement,

609: --------------------------------------------
610: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
611: fnd_log.string
612: (
613: fnd_log.level_statement,
614: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
615: 'p_serialnum_change_rec.workorder_id -> '||p_serialnum_change_rec.workorder_id
616: );
617: fnd_log.string

Line 617: fnd_log.string

613: fnd_log.level_statement,
614: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
615: 'p_serialnum_change_rec.workorder_id -> '||p_serialnum_change_rec.workorder_id
616: );
617: fnd_log.string
618: (
619: fnd_log.level_statement,
620: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
621: 'p_serialnum_change_rec.job_number -> '||p_serialnum_change_rec.job_number

Line 619: fnd_log.level_statement,

615: 'p_serialnum_change_rec.workorder_id -> '||p_serialnum_change_rec.workorder_id
616: );
617: fnd_log.string
618: (
619: fnd_log.level_statement,
620: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
621: 'p_serialnum_change_rec.job_number -> '||p_serialnum_change_rec.job_number
622: );
623: fnd_log.string

Line 623: fnd_log.string

619: fnd_log.level_statement,
620: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
621: 'p_serialnum_change_rec.job_number -> '||p_serialnum_change_rec.job_number
622: );
623: fnd_log.string
624: (
625: fnd_log.level_statement,
626: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
627: 'p_serialnum_change_rec.osp_line_id -> '||p_serialnum_change_rec.osp_line_id

Line 625: fnd_log.level_statement,

621: 'p_serialnum_change_rec.job_number -> '||p_serialnum_change_rec.job_number
622: );
623: fnd_log.string
624: (
625: fnd_log.level_statement,
626: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
627: 'p_serialnum_change_rec.osp_line_id -> '||p_serialnum_change_rec.osp_line_id
628: );
629: fnd_log.string

Line 629: fnd_log.string

625: fnd_log.level_statement,
626: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
627: 'p_serialnum_change_rec.osp_line_id -> '||p_serialnum_change_rec.osp_line_id
628: );
629: fnd_log.string
630: (
631: fnd_log.level_statement,
632: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
633: 'p_serialnum_change_rec.instance_id -> '||p_serialnum_change_rec.instance_id

Line 631: fnd_log.level_statement,

627: 'p_serialnum_change_rec.osp_line_id -> '||p_serialnum_change_rec.osp_line_id
628: );
629: fnd_log.string
630: (
631: fnd_log.level_statement,
632: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
633: 'p_serialnum_change_rec.instance_id -> '||p_serialnum_change_rec.instance_id
634: );
635: fnd_log.string

Line 635: fnd_log.string

631: fnd_log.level_statement,
632: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
633: 'p_serialnum_change_rec.instance_id -> '||p_serialnum_change_rec.instance_id
634: );
635: fnd_log.string
636: (
637: fnd_log.level_statement,
638: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
639: 'p_serialnum_change_rec.new_item_number -> '||p_serialnum_change_rec.new_item_number

Line 637: fnd_log.level_statement,

633: 'p_serialnum_change_rec.instance_id -> '||p_serialnum_change_rec.instance_id
634: );
635: fnd_log.string
636: (
637: fnd_log.level_statement,
638: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
639: 'p_serialnum_change_rec.new_item_number -> '||p_serialnum_change_rec.new_item_number
640: );
641: fnd_log.string

Line 641: fnd_log.string

637: fnd_log.level_statement,
638: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
639: 'p_serialnum_change_rec.new_item_number -> '||p_serialnum_change_rec.new_item_number
640: );
641: fnd_log.string
642: (
643: fnd_log.level_statement,
644: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
645: 'p_serialnum_change_rec.new_serial_number -> '||p_serialnum_change_rec.new_serial_number

Line 643: fnd_log.level_statement,

639: 'p_serialnum_change_rec.new_item_number -> '||p_serialnum_change_rec.new_item_number
640: );
641: fnd_log.string
642: (
643: fnd_log.level_statement,
644: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
645: 'p_serialnum_change_rec.new_serial_number -> '||p_serialnum_change_rec.new_serial_number
646: );
647: fnd_log.string

Line 647: fnd_log.string

643: fnd_log.level_statement,
644: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
645: 'p_serialnum_change_rec.new_serial_number -> '||p_serialnum_change_rec.new_serial_number
646: );
647: fnd_log.string
648: (
649: fnd_log.level_statement,
650: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
651: 'p_serialnum_change_rec.new_serial_tag_code -> '||p_serialnum_change_rec.new_serial_tag_code

Line 649: fnd_log.level_statement,

645: 'p_serialnum_change_rec.new_serial_number -> '||p_serialnum_change_rec.new_serial_number
646: );
647: fnd_log.string
648: (
649: fnd_log.level_statement,
650: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
651: 'p_serialnum_change_rec.new_serial_tag_code -> '||p_serialnum_change_rec.new_serial_tag_code
652: );
653: END IF;

Line 705: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

701: -- Arunjk added to check if the data has been modified of not BUG NO : 12658658 End
702:
703: IF(l_serialnum_change_rec.OSP_LINE_ID IS NOT NULL) THEN
704:
705: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
706:
707: fnd_log.string
708: (
709: fnd_log.level_statement,

Line 707: fnd_log.string

703: IF(l_serialnum_change_rec.OSP_LINE_ID IS NOT NULL) THEN
704:
705: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
706:
707: fnd_log.string
708: (
709: fnd_log.level_statement,
710: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
711: 'Copying the serial num change attributes '

Line 709: fnd_log.level_statement,

705: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
706:
707: fnd_log.string
708: (
709: fnd_log.level_statement,
710: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
711: 'Copying the serial num change attributes '
712: );
713:

Line 729: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

725:
726: l_osp_serialnum_change_rec.new_item_rev_number := l_serialnum_change_rec.new_item_rev_number;
727: l_osp_serialnum_change_rec.new_lot_number := l_serialnum_change_rec.new_lot_number;
728:
729: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
730:
731: fnd_log.string
732: (
733: fnd_log.level_statement,

Line 731: fnd_log.string

727: l_osp_serialnum_change_rec.new_lot_number := l_serialnum_change_rec.new_lot_number;
728:
729: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
730:
731: fnd_log.string
732: (
733: fnd_log.level_statement,
734: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
735: 'Before calling AHL_OSP_SHIPMENT_PUB.Process_Osp_SerialNum_Change '

Line 733: fnd_log.level_statement,

729: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
730:
731: fnd_log.string
732: (
733: fnd_log.level_statement,
734: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
735: 'Before calling AHL_OSP_SHIPMENT_PUB.Process_Osp_SerialNum_Change '
736: );
737:

Line 751: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

747: x_msg_count => l_msg_count,
748: x_msg_data => l_msg_data
749: );
750:
751: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
752:
753: fnd_log.string
754: (
755: fnd_log.level_statement,

Line 753: fnd_log.string

749: );
750:
751: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
752:
753: fnd_log.string
754: (
755: fnd_log.level_statement,
756: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
757: 'After calling AHL_OSP_SHIPMENT_PUB.Process_Osp_SerialNum_Change: l_return_status => ' ||l_return_status

Line 755: fnd_log.level_statement,

751: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
752:
753: fnd_log.string
754: (
755: fnd_log.level_statement,
756: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
757: 'After calling AHL_OSP_SHIPMENT_PUB.Process_Osp_SerialNum_Change: l_return_status => ' ||l_return_status
758: );
759:

Line 1118: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

1114: --Adithya added the following validation to verify that the UC rules are not broken
1115: --after partnumber/serial number has been changed.
1116: --Bug# 6683990
1117: IF (l_root_uc_header_id IS NOT NULL) THEN
1118: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1119: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1120: 'Entering UC rules validation api: root_uc_header_id => ' || l_root_uc_header_id );
1121: END IF;
1122:

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

1115: --after partnumber/serial number has been changed.
1116: --Bug# 6683990
1117: IF (l_root_uc_header_id IS NOT NULL) THEN
1118: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1119: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1120: 'Entering UC rules validation api: root_uc_header_id => ' || l_root_uc_header_id );
1121: END IF;
1122:
1123: ahl_uc_validation_pub.Validate_Completeness(