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.AMS_THLDACT_PVT dependencies on JTF_PLSQL_API

Line 777: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

773:
774: AMS_Utility_PVT.debug_message(l_full_name ||': validate');
775: END IF;
776:
777: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
778: Check_thldact_Items(
779: p_thldact_rec => p_thldact_rec,
780: p_validation_mode => JTF_PLSQL_API.g_update,
781: x_return_status => l_return_status

Line 780: p_validation_mode => JTF_PLSQL_API.g_update,

776:
777: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
778: Check_thldact_Items(
779: p_thldact_rec => p_thldact_rec,
780: p_validation_mode => JTF_PLSQL_API.g_update,
781: x_return_status => l_return_status
782: );
783:
784: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 794: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

790:
791: -- replace g_miss_char/num/date with current column values
792: Complete_thldact_rec(p_thldact_rec, l_thldact_rec);
793:
794: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
795: Check_thldact_record(
796: p_thldact_rec => p_thldact_rec,
797: p_complete_rec => l_thldact_rec,
798: x_return_status => l_return_status

Line 984: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

980:
981: --
982: -- API body
983: --
984: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
985: Check_Thldact_Items(
986: p_thldact_rec => p_thldact_rec,
987: p_validation_mode => JTF_PLSQL_API.g_create,
988: x_return_status => l_return_status

Line 987: p_validation_mode => JTF_PLSQL_API.g_create,

983: --
984: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
985: Check_Thldact_Items(
986: p_thldact_rec => p_thldact_rec,
987: p_validation_mode => JTF_PLSQL_API.g_create,
988: x_return_status => l_return_status
989: );
990:
991: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 1006: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

1002:
1003: AMS_Utility_PVT.debug_message(l_full_name||': check record');
1004: END IF;
1005:
1006: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
1007: Check_thldact_record(
1008: p_thldact_rec => p_thldact_rec,
1009: p_complete_rec => NULL,
1010: x_return_status => l_return_status

Line 1155: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,

1151: -- 10/26/1999 ptendulk Modified according to new standards
1152: -- End of Comments
1153: PROCEDURE Check_Thldact_Uk_Items(
1154: p_thldact_rec IN thldact_rec_type,
1155: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1156: x_return_status OUT NOCOPY VARCHAR2
1157: )
1158: IS
1159: l_valid_flag VARCHAR2(1);

Line 1167: IF p_validation_mode = JTF_PLSQL_API.g_create

1163: x_return_status := FND_API.g_ret_sts_success;
1164:
1165: -- For create_thldact, when trigger_action_id is passed in, we need to
1166: -- check if this trigger_action_id is unique.
1167: IF p_validation_mode = JTF_PLSQL_API.g_create
1168: AND p_thldact_rec.trigger_action_id IS NOT NULL
1169: THEN
1170: IF AMS_Utility_PVT.check_uniqueness(
1171: 'ams_trigger_actions',

Line 1194: -- IF p_validation_mode <> JTF_PLSQL_API.g_create THEN

1190: -- Unique TRIGGER_NAME and TRIGGER_CREATED_FOR
1191: l_where_clause := ' trigger_id = '|| p_thldact_rec.trigger_id ;
1192:
1193: -- For Updates, must also check that uniqueness is not checked against the same record.
1194: -- IF p_validation_mode <> JTF_PLSQL_API.g_create THEN
1195: l_where_clause := l_where_clause || ' AND trigger_action_id <> ' || p_thldact_rec.trigger_action_id;
1196: -- soagrawa 30-apr-2003
1197: l_where_clause := l_where_clause || ' AND execute_action_type <> ' || p_thldact_rec.execute_action_type;
1198: -- END IF;

Line 1629: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,

1625: -- 10/26/1999 ptendulk Modified according to new standards
1626: -- End of Comments
1627: PROCEDURE Check_ThldAct_Items(
1628: p_thldact_rec IN thldact_rec_type,
1629: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1630: x_return_status OUT NOCOPY VARCHAR2
1631: )
1632: IS
1633: BEGIN