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_REPORT_UTILS_PVT dependencies on FND_API

Line 638: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,

634: -- To insert/update counters values.
635: --------------------------------------------------------------------
636: PROCEDURE Insert_Rem_Counters (
637: p_api_version IN NUMBER,
638: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
639: p_commit IN VARCHAR2 := Fnd_Api.g_false,
640: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
641: p_rem_counter_tbl IN OUT NOCOPY Rem_Counter_Tbl_Type,
642: x_return_status OUT NOCOPY VARCHAR2,

Line 639: p_commit IN VARCHAR2 := Fnd_Api.g_false,

635: --------------------------------------------------------------------
636: PROCEDURE Insert_Rem_Counters (
637: p_api_version IN NUMBER,
638: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
639: p_commit IN VARCHAR2 := Fnd_Api.g_false,
640: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
641: p_rem_counter_tbl IN OUT NOCOPY Rem_Counter_Tbl_Type,
642: x_return_status OUT NOCOPY VARCHAR2,
643: x_msg_count OUT NOCOPY NUMBER,

Line 640: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,

636: PROCEDURE Insert_Rem_Counters (
637: p_api_version IN NUMBER,
638: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
639: p_commit IN VARCHAR2 := Fnd_Api.g_false,
640: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
641: p_rem_counter_tbl IN OUT NOCOPY Rem_Counter_Tbl_Type,
642: x_return_status OUT NOCOPY VARCHAR2,
643: x_msg_count OUT NOCOPY NUMBER,
644: x_msg_data OUT NOCOPY VARCHAR2

Line 687: IF Fnd_Api.to_boolean(p_init_msg_list) THEN

683: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.begin','At the start of PLSQL procedure');
684: END IF;
685:
686: -- Initialize message list if p_init_msg_list is set to TRUE.
687: IF Fnd_Api.to_boolean(p_init_msg_list) THEN
688: Fnd_Msg_Pub.initialize;
689: END IF;
690:
691: -- Initialize API return status to success

Line 692: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

688: Fnd_Msg_Pub.initialize;
689: END IF;
690:
691: -- Initialize API return status to success
692: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
693:
694: -- Standard call to check for call compatibility.
695: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
696: p_api_version,

Line 695: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,

691: -- Initialize API return status to success
692: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
693:
694: -- Standard call to check for call compatibility.
695: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
696: p_api_version,
697: l_api_name,G_PKG_NAME)
698: THEN
699: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

Line 699: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

695: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
696: p_api_version,
697: l_api_name,G_PKG_NAME)
698: THEN
699: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
700: END IF;
701:
702: ------------------------Start of API Body------------------------------------
703:

Line 721: RAISE Fnd_Api.G_EXC_ERROR;

717: IF c_id_exists%NOTFOUND THEN
718: CLOSE c_id_exists;
719: Fnd_Message.SET_NAME('AHL','AHL_RPT_CNTR_NOT_EXT');
720: Fnd_Msg_Pub.ADD;
721: RAISE Fnd_Api.G_EXC_ERROR;
722: END IF;
723: CLOSE c_id_exists;
724: --Update the table with the new counter values
725: UPDATE ahl_parameters

Line 742: RAISE Fnd_Api.G_EXC_ERROR;

738: FETCH c_check_for_dup INTO l_dummy;
739: IF c_check_for_dup%FOUND THEN
740: Fnd_Message.SET_NAME('AHL','AHL_RPT_REM_DUP_CNTR');
741: Fnd_Msg_Pub.ADD;
742: RAISE Fnd_Api.G_EXC_ERROR;
743: END IF;
744: CLOSE c_check_for_dup;
745:
746: -- checking for duplicate entries for Since Repair Counters

Line 752: RAISE Fnd_Api.G_EXC_ERROR;

748: FETCH c_check_for_dup INTO l_dummy;
749: IF c_check_for_dup%FOUND THEN
750: Fnd_Message.SET_NAME('AHL','AHL_RPT_SINCEREP_DUP_CNTR');
751: Fnd_Msg_Pub.ADD;
752: RAISE Fnd_Api.G_EXC_ERROR;
753: END IF;
754: CLOSE c_check_for_dup;
755:
756: -- checking for duplicate entries for Spec Limit Counters

Line 762: RAISE Fnd_Api.G_EXC_ERROR;

758: FETCH c_check_for_dup INTO l_dummy;
759: IF c_check_for_dup%FOUND THEN
760: Fnd_Message.SET_NAME('AHL','AHL_RPT_SPECLIMIT_DUP_CNTR');
761: Fnd_Msg_Pub.ADD;
762: RAISE Fnd_Api.G_EXC_ERROR;
763: END IF;
764: CLOSE c_check_for_dup;
765:
766:

Line 773: RAISE Fnd_Api.G_EXC_ERROR;

769: FETCH c_check_for_dup INTO l_dummy;
770: IF c_check_for_dup%FOUND THEN
771: Fnd_Message.SET_NAME('AHL','AHL_RPT_PST_DUP');
772: Fnd_Msg_Pub.ADD;
773: RAISE Fnd_Api.G_EXC_ERROR;
774: END IF;
775: CLOSE c_check_for_dup;
776:
777: COMMIT WORK;

Line 782: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN

778: END IF;
779:
780:
781: --Standard check for commit
782: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
783: COMMIT;
784: END IF;
785:
786: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

Line 790: WHEN Fnd_Api.g_exc_error THEN

786: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
787: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.end','At the end of PLSQL procedure');
788: END IF;
789: EXCEPTION
790: WHEN Fnd_Api.g_exc_error THEN
791: ROLLBACK TO Insert_Rem_Counters;
792: x_return_status := Fnd_Api.g_ret_sts_error;
793: Fnd_Msg_Pub.count_and_get (
794: p_encoded => Fnd_Api.g_false,

Line 792: x_return_status := Fnd_Api.g_ret_sts_error;

788: END IF;
789: EXCEPTION
790: WHEN Fnd_Api.g_exc_error THEN
791: ROLLBACK TO Insert_Rem_Counters;
792: x_return_status := Fnd_Api.g_ret_sts_error;
793: Fnd_Msg_Pub.count_and_get (
794: p_encoded => Fnd_Api.g_false,
795: p_count => x_msg_count,
796: p_data => x_msg_data

Line 794: p_encoded => Fnd_Api.g_false,

790: WHEN Fnd_Api.g_exc_error THEN
791: ROLLBACK TO Insert_Rem_Counters;
792: x_return_status := Fnd_Api.g_ret_sts_error;
793: Fnd_Msg_Pub.count_and_get (
794: p_encoded => Fnd_Api.g_false,
795: p_count => x_msg_count,
796: p_data => x_msg_data
797: );
798: WHEN Fnd_Api.g_exc_unexpected_error THEN

Line 798: WHEN Fnd_Api.g_exc_unexpected_error THEN

794: p_encoded => Fnd_Api.g_false,
795: p_count => x_msg_count,
796: p_data => x_msg_data
797: );
798: WHEN Fnd_Api.g_exc_unexpected_error THEN
799: ROLLBACK TO Insert_Rem_Counters;
800: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
801: Fnd_Msg_Pub.count_and_get (
802: p_encoded => Fnd_Api.g_false,

Line 800: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;

796: p_data => x_msg_data
797: );
798: WHEN Fnd_Api.g_exc_unexpected_error THEN
799: ROLLBACK TO Insert_Rem_Counters;
800: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
801: Fnd_Msg_Pub.count_and_get (
802: p_encoded => Fnd_Api.g_false,
803: p_count => x_msg_count,
804: p_data => x_msg_data

Line 802: p_encoded => Fnd_Api.g_false,

798: WHEN Fnd_Api.g_exc_unexpected_error THEN
799: ROLLBACK TO Insert_Rem_Counters;
800: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
801: Fnd_Msg_Pub.count_and_get (
802: p_encoded => Fnd_Api.g_false,
803: p_count => x_msg_count,
804: p_data => x_msg_data
805: );
806: WHEN OTHERS THEN

Line 808: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;

804: p_data => x_msg_data
805: );
806: WHEN OTHERS THEN
807: ROLLBACK TO Insert_Rem_Counters;
808: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
809: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
810: THEN
811: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
812: END IF;

Line 814: p_encoded => Fnd_Api.g_false,

810: THEN
811: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
812: END IF;
813: Fnd_Msg_Pub.count_and_get (
814: p_encoded => Fnd_Api.g_false,
815: p_count => x_msg_count,
816: p_data => x_msg_data
817: );
818: END Insert_Rem_Counters;