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_TRIG_PVT dependencies on JTF_PLSQL_API

Line 1073: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1069:
1070: AMS_Utility_PVT.debug_message(l_full_name||': Validate');
1071: END IF;
1072:
1073: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1074: check_trig_items(
1075: p_trig_rec => p_trig_rec,
1076: p_validation_mode => JTF_PLSQL_API.g_update,
1077: x_return_status => l_return_status

Line 1076: p_validation_mode => JTF_PLSQL_API.g_update,

1072:
1073: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1074: check_trig_items(
1075: p_trig_rec => p_trig_rec,
1076: p_validation_mode => JTF_PLSQL_API.g_update,
1077: x_return_status => l_return_status
1078: );
1079: --dbms_output.put_line('After Item Validation : '||l_return_status);
1080: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 1090: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

1086:
1087: -- replace g_miss_char/num/date with current column values
1088: complete_trig_rec(p_trig_rec, l_trig_rec);
1089:
1090: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
1091: check_trig_record(
1092: p_trig_rec => p_trig_rec,
1093: p_complete_rec => l_trig_rec,
1094: x_return_status => l_return_status

Line 1502: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1498:
1499: AMS_Utility_PVT.debug_message(l_full_name||': check items');
1500: END IF;
1501:
1502: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1503: Check_Trig_Items(
1504: p_trig_rec => p_trig_rec,
1505: p_validation_mode => JTF_PLSQL_API.g_create,
1506: x_return_status => l_return_status

Line 1505: p_validation_mode => JTF_PLSQL_API.g_create,

1501:
1502: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1503: Check_Trig_Items(
1504: p_trig_rec => p_trig_rec,
1505: p_validation_mode => JTF_PLSQL_API.g_create,
1506: x_return_status => l_return_status
1507: );
1508: --dbms_output.put_line('Stat After Item : '||l_return_status);
1509: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 1525: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

1521:
1522: AMS_Utility_PVT.debug_message(l_full_name||': check record');
1523: END IF;
1524:
1525: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
1526: Check_Trig_Record(
1527: p_trig_rec => p_trig_rec,
1528: p_complete_rec => NULL,
1529: x_return_status => l_return_status

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

1717: -- End of Comments
1718:
1719: PROCEDURE Check_Trig_Uk_Items(
1720: p_trig_rec IN trig_rec_type,
1721: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1722: x_return_status OUT NOCOPY VARCHAR2
1723: )
1724: IS
1725: l_valid_flag VARCHAR2(1);

Line 1767: IF p_validation_mode = JTF_PLSQL_API.g_create

1763: x_return_status := FND_API.g_ret_sts_success;
1764:
1765: -- For create_trigger, when trigger_id is passed in, we need to
1766: -- check if this trigger_id is unique.
1767: IF p_validation_mode = JTF_PLSQL_API.g_create
1768: AND p_trig_rec.trigger_id IS NOT NULL
1769: THEN
1770: IF AMS_Utility_PVT.check_uniqueness(
1771: 'AMS_TRIGGERS',

Line 1792: IF p_validation_mode <> JTF_PLSQL_API.g_create THEN

1788: -- Unique TRIGGER_NAME and TRIGGER_CREATED_FOR
1789: l_where_clause := ' UPPER(TRIGGER_NAME) = ''' || UPPER(p_trig_rec.trigger_name)||'''' ;
1790:
1791: -- For Updates, must also check that uniqueness is not checked against the same record.
1792: IF p_validation_mode <> JTF_PLSQL_API.g_create THEN
1793: l_where_clause := l_where_clause || ' AND TRIGGER_ID <> ' || p_trig_rec.trigger_id;
1794: END IF;
1795:
1796: IF AMS_Utility_PVT.Check_Uniqueness(

Line 1807: IF p_validation_mode = JTF_PLSQL_API.g_update THEN

1803: RETURN;
1804: END IF;
1805: */
1806:
1807: IF p_validation_mode = JTF_PLSQL_API.g_update THEN
1808: OPEN c_trig_name_updt;
1809: FETCH c_trig_name_updt INTO l_dummy ;
1810: CLOSE c_trig_name_updt ;
1811: ELSE

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

1967: -- End of Comments
1968:
1969: PROCEDURE check_trig_items(
1970: p_trig_rec IN trig_rec_type,
1971: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1972: x_return_status OUT NOCOPY VARCHAR2
1973: )
1974: IS
1975: BEGIN