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 581: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

577:
578: --------------------------------------------
579: -- Dump API Inputs.
580: --------------------------------------------
581: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
582: fnd_log.string
583: (
584: fnd_log.level_statement,
585: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 582: fnd_log.string

578: --------------------------------------------
579: -- Dump API Inputs.
580: --------------------------------------------
581: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
582: fnd_log.string
583: (
584: fnd_log.level_statement,
585: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
586: 'p_serialnum_change_rec.workorder_id -> '||p_serialnum_change_rec.workorder_id

Line 584: fnd_log.level_statement,

580: --------------------------------------------
581: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
582: fnd_log.string
583: (
584: fnd_log.level_statement,
585: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
586: 'p_serialnum_change_rec.workorder_id -> '||p_serialnum_change_rec.workorder_id
587: );
588: fnd_log.string

Line 588: fnd_log.string

584: fnd_log.level_statement,
585: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
586: 'p_serialnum_change_rec.workorder_id -> '||p_serialnum_change_rec.workorder_id
587: );
588: fnd_log.string
589: (
590: fnd_log.level_statement,
591: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
592: 'p_serialnum_change_rec.job_number -> '||p_serialnum_change_rec.job_number

Line 590: fnd_log.level_statement,

586: 'p_serialnum_change_rec.workorder_id -> '||p_serialnum_change_rec.workorder_id
587: );
588: fnd_log.string
589: (
590: fnd_log.level_statement,
591: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
592: 'p_serialnum_change_rec.job_number -> '||p_serialnum_change_rec.job_number
593: );
594: fnd_log.string

Line 594: fnd_log.string

590: fnd_log.level_statement,
591: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
592: 'p_serialnum_change_rec.job_number -> '||p_serialnum_change_rec.job_number
593: );
594: fnd_log.string
595: (
596: fnd_log.level_statement,
597: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
598: 'p_serialnum_change_rec.osp_line_id -> '||p_serialnum_change_rec.osp_line_id

Line 596: fnd_log.level_statement,

592: 'p_serialnum_change_rec.job_number -> '||p_serialnum_change_rec.job_number
593: );
594: fnd_log.string
595: (
596: fnd_log.level_statement,
597: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
598: 'p_serialnum_change_rec.osp_line_id -> '||p_serialnum_change_rec.osp_line_id
599: );
600: fnd_log.string

Line 600: fnd_log.string

596: fnd_log.level_statement,
597: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
598: 'p_serialnum_change_rec.osp_line_id -> '||p_serialnum_change_rec.osp_line_id
599: );
600: fnd_log.string
601: (
602: fnd_log.level_statement,
603: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
604: 'p_serialnum_change_rec.instance_id -> '||p_serialnum_change_rec.instance_id

Line 602: fnd_log.level_statement,

598: 'p_serialnum_change_rec.osp_line_id -> '||p_serialnum_change_rec.osp_line_id
599: );
600: fnd_log.string
601: (
602: fnd_log.level_statement,
603: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
604: 'p_serialnum_change_rec.instance_id -> '||p_serialnum_change_rec.instance_id
605: );
606: fnd_log.string

Line 606: fnd_log.string

602: fnd_log.level_statement,
603: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
604: 'p_serialnum_change_rec.instance_id -> '||p_serialnum_change_rec.instance_id
605: );
606: fnd_log.string
607: (
608: fnd_log.level_statement,
609: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
610: 'p_serialnum_change_rec.new_item_number -> '||p_serialnum_change_rec.new_item_number

Line 608: fnd_log.level_statement,

604: 'p_serialnum_change_rec.instance_id -> '||p_serialnum_change_rec.instance_id
605: );
606: fnd_log.string
607: (
608: fnd_log.level_statement,
609: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
610: 'p_serialnum_change_rec.new_item_number -> '||p_serialnum_change_rec.new_item_number
611: );
612: fnd_log.string

Line 612: fnd_log.string

608: fnd_log.level_statement,
609: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
610: 'p_serialnum_change_rec.new_item_number -> '||p_serialnum_change_rec.new_item_number
611: );
612: fnd_log.string
613: (
614: fnd_log.level_statement,
615: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
616: 'p_serialnum_change_rec.new_serial_number -> '||p_serialnum_change_rec.new_serial_number

Line 614: fnd_log.level_statement,

610: 'p_serialnum_change_rec.new_item_number -> '||p_serialnum_change_rec.new_item_number
611: );
612: fnd_log.string
613: (
614: fnd_log.level_statement,
615: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
616: 'p_serialnum_change_rec.new_serial_number -> '||p_serialnum_change_rec.new_serial_number
617: );
618: fnd_log.string

Line 618: fnd_log.string

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

Line 620: fnd_log.level_statement,

616: 'p_serialnum_change_rec.new_serial_number -> '||p_serialnum_change_rec.new_serial_number
617: );
618: fnd_log.string
619: (
620: fnd_log.level_statement,
621: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
622: 'p_serialnum_change_rec.new_serial_tag_code -> '||p_serialnum_change_rec.new_serial_tag_code
623: );
624: END IF;

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

644: END IF;
645:
646: IF(l_serialnum_change_rec.OSP_LINE_ID IS NOT NULL) THEN
647:
648: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
649:
650: fnd_log.string
651: (
652: fnd_log.level_statement,

Line 650: fnd_log.string

646: IF(l_serialnum_change_rec.OSP_LINE_ID IS NOT NULL) THEN
647:
648: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
649:
650: fnd_log.string
651: (
652: fnd_log.level_statement,
653: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
654: 'Copying the serial num change attributes '

Line 652: fnd_log.level_statement,

648: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
649:
650: fnd_log.string
651: (
652: fnd_log.level_statement,
653: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
654: 'Copying the serial num change attributes '
655: );
656:

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

668:
669: l_osp_serialnum_change_rec.new_item_rev_number := l_serialnum_change_rec.new_item_rev_number;
670: l_osp_serialnum_change_rec.new_lot_number := l_serialnum_change_rec.new_lot_number;
671:
672: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
673:
674: fnd_log.string
675: (
676: fnd_log.level_statement,

Line 674: fnd_log.string

670: l_osp_serialnum_change_rec.new_lot_number := l_serialnum_change_rec.new_lot_number;
671:
672: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
673:
674: fnd_log.string
675: (
676: fnd_log.level_statement,
677: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
678: 'Before calling AHL_OSP_SHIPMENT_PUB.Process_Osp_SerialNum_Change '

Line 676: fnd_log.level_statement,

672: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
673:
674: fnd_log.string
675: (
676: fnd_log.level_statement,
677: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
678: 'Before calling AHL_OSP_SHIPMENT_PUB.Process_Osp_SerialNum_Change '
679: );
680:

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

690: x_msg_count => l_msg_count,
691: x_msg_data => l_msg_data
692: );
693:
694: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
695:
696: fnd_log.string
697: (
698: fnd_log.level_statement,

Line 696: fnd_log.string

692: );
693:
694: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
695:
696: fnd_log.string
697: (
698: fnd_log.level_statement,
699: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
700: 'After calling AHL_OSP_SHIPMENT_PUB.Process_Osp_SerialNum_Change: l_return_status => ' ||l_return_status

Line 698: fnd_log.level_statement,

694: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
695:
696: fnd_log.string
697: (
698: fnd_log.level_statement,
699: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
700: 'After calling AHL_OSP_SHIPMENT_PUB.Process_Osp_SerialNum_Change: l_return_status => ' ||l_return_status
701: );
702:

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

1057: --Adithya added the following validation to verify that the UC rules are not broken
1058: --after partnumber/serial number has been changed.
1059: --Bug# 6683990
1060: IF (l_root_uc_header_id IS NOT NULL) THEN
1061: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1062: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1063: 'Entering UC rules validation api: root_uc_header_id => ' || l_root_uc_header_id );
1064: END IF;
1065:

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

1058: --after partnumber/serial number has been changed.
1059: --Bug# 6683990
1060: IF (l_root_uc_header_id IS NOT NULL) THEN
1061: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1062: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1063: 'Entering UC rules validation api: root_uc_header_id => ' || l_root_uc_header_id );
1064: END IF;
1065:
1066: ahl_uc_validation_pub.Validate_Completeness(