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_ACCESS_PVT dependencies on AMS_UTILITY_PVT

Line 90: AMS_Utility_PVT.debug_message(l_full_name||': start');

86: IF (AMS_DEBUG_HIGH_ON) THEN
87:
88:
89:
90: AMS_Utility_PVT.debug_message(l_full_name||': start');
91:
92: END IF;
93:
94: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 112: AMS_Utility_PVT.debug_message(l_full_name ||': validate');

108:
109: ----------------------- validate -----------------------
110: IF (AMS_DEBUG_HIGH_ON) THEN
111:
112: AMS_Utility_PVT.debug_message(l_full_name ||': validate');
113: END IF;
114:
115: validate_access(
116: p_api_version => l_api_version,

Line 135: AMS_Utility_PVT.debug_message(l_full_name ||': insert');

131:
132: -------------------------- insert --------------------------
133: IF (AMS_DEBUG_HIGH_ON) THEN
134:
135: AMS_Utility_PVT.debug_message(l_full_name ||': insert');
136: END IF;
137:
138:
139: /* added by sunkumar 03-12-2002 bug id.. 2216520 */

Line 369: AMS_Utility_PVT.debug_message(l_full_name ||': end');

365: IF (AMS_DEBUG_HIGH_ON) THEN
366:
367:
368:
369: AMS_Utility_PVT.debug_message(l_full_name ||': end');
370:
371: END IF;
372:
373: EXCEPTION

Line 492: AMS_Utility_PVT.debug_message(l_full_name||': start');

488: IF (AMS_DEBUG_HIGH_ON) THEN
489:
490:
491:
492: AMS_Utility_PVT.debug_message(l_full_name||': start');
493:
494: END IF;
495:
496: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 523: AMS_Utility_PVT.debug_message(l_full_name ||': delete');

519:
520: ------------------------ delete ------------------------
521: IF (AMS_DEBUG_HIGH_ON) THEN
522:
523: AMS_Utility_PVT.debug_message(l_full_name ||': delete');
524: END IF;
525:
526: IF l_role_type = 'USER' THEN
527:

Line 737: AMS_Utility_PVT.debug_message(l_full_name ||': end');

733: IF (AMS_DEBUG_HIGH_ON) THEN
734:
735:
736:
737: AMS_Utility_PVT.debug_message(l_full_name ||': end');
738:
739: END IF;
740:
741: EXCEPTION

Line 818: AMS_Utility_PVT.debug_message(l_full_name||': start');

814:
815: -------------------- initialize ------------------------
816: IF (AMS_DEBUG_HIGH_ON) THEN
817:
818: AMS_Utility_PVT.debug_message(l_full_name||': start');
819: END IF;
820:
821: IF FND_API.to_boolean(p_init_msg_list) THEN
822: FND_MSG_PUB.initialize;

Line 839: AMS_Utility_PVT.debug_message(l_full_name||': lock');

835:
836: ------------------------ lock -------------------------
837: IF (AMS_DEBUG_HIGH_ON) THEN
838:
839: AMS_Utility_PVT.debug_message(l_full_name||': lock');
840: END IF;
841:
842: OPEN c_access_b;
843: FETCH c_access_b INTO l_access_id;

Line 864: AMS_Utility_PVT.debug_message(l_full_name ||': end');

860: IF (AMS_DEBUG_HIGH_ON) THEN
861:
862:
863:
864: AMS_Utility_PVT.debug_message(l_full_name ||': end');
865:
866: END IF;
867:
868: EXCEPTION

Line 870: WHEN AMS_Utility_PVT.resource_locked THEN

866: END IF;
867:
868: EXCEPTION
869:
870: WHEN AMS_Utility_PVT.resource_locked THEN
871: x_return_status := FND_API.g_ret_sts_error;
872: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
873: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
874: FND_MSG_PUB.add;

Line 983: AMS_Utility_PVT.debug_message(l_full_name||': start');

979: IF (AMS_DEBUG_HIGH_ON) THEN
980:
981:
982:
983: AMS_Utility_PVT.debug_message(l_full_name||': start');
984:
985: END IF;
986:
987: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 1005: AMS_Utility_PVT.debug_message(l_full_name ||': validate');

1001:
1002: ----------------------- validate ----------------------
1003: IF (AMS_DEBUG_HIGH_ON) THEN
1004:
1005: AMS_Utility_PVT.debug_message(l_full_name ||': validate');
1006: END IF;
1007:
1008: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1009: check_access_items(

Line 1028: AMS_Utility_PVT.debug_message(l_full_name ||': update');

1024:
1025: -------------------------- update --------------------
1026: IF (AMS_DEBUG_HIGH_ON) THEN
1027:
1028: AMS_Utility_PVT.debug_message(l_full_name ||': update');
1029: END IF;
1030:
1031: UPDATE ams_act_access SET
1032: last_update_date = SYSDATE,

Line 1204: AMS_Utility_PVT.debug_message(l_full_name ||': end');

1200: IF (AMS_DEBUG_HIGH_ON) THEN
1201:
1202:
1203:
1204: AMS_Utility_PVT.debug_message(l_full_name ||': end');
1205:
1206: END IF;
1207:
1208: EXCEPTION

Line 1290: AMS_Utility_PVT.debug_message(l_full_name||': start');

1286: IF (AMS_DEBUG_HIGH_ON) THEN
1287:
1288:
1289:
1290: AMS_Utility_PVT.debug_message(l_full_name||': start');
1291:
1292: END IF;
1293:
1294: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 1312: AMS_Utility_PVT.debug_message(l_full_name ||': validate');

1308:
1309: ----------------------- validate ----------------------
1310: IF (AMS_DEBUG_HIGH_ON) THEN
1311:
1312: AMS_Utility_PVT.debug_message(l_full_name ||': validate');
1313: END IF;
1314:
1315: -- added by julou 14-DEC-2001 check existence of new owner
1316: OPEN c_user_exists;

Line 1419: AMS_Utility_PVT.debug_message(l_full_name ||': end');

1415: IF (AMS_DEBUG_HIGH_ON) THEN
1416:
1417:
1418:
1419: AMS_Utility_PVT.debug_message(l_full_name ||': end');
1420:
1421: END IF;
1422:
1423: EXCEPTION

Line 1504: AMS_Utility_PVT.debug_message(l_full_name||': start validate');

1500:
1501: ----------------------- initialize --------------------
1502: IF (AMS_DEBUG_HIGH_ON) THEN
1503:
1504: AMS_Utility_PVT.debug_message(l_full_name||': start validate');
1505: END IF;
1506:
1507: IF FND_API.to_boolean(p_init_msg_list) THEN
1508: FND_MSG_PUB.initialize;

Line 1525: AMS_Utility_PVT.debug_message(l_full_name||': check items');

1521:
1522: ---------------------- validate ------------------------
1523: IF (AMS_DEBUG_HIGH_ON) THEN
1524:
1525: AMS_Utility_PVT.debug_message(l_full_name||': check items');
1526: END IF;
1527:
1528: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1529: check_access_items(

Line 1546: AMS_Utility_PVT.debug_message(l_full_name||': check record');

1542: IF (AMS_DEBUG_HIGH_ON) THEN
1543:
1544:
1545:
1546: AMS_Utility_PVT.debug_message(l_full_name||': check record');
1547:
1548: END IF;
1549:
1550: -- Check for Dupliacate Records -----

Line 1577: AMS_Utility_PVT.debug_message(l_full_name ||': end');

1573: CLOSE c_check_dup;
1574: -------------------- finish --------------------------
1575: IF (AMS_DEBUG_HIGH_ON) THEN
1576:
1577: AMS_Utility_PVT.debug_message(l_full_name ||': end');
1578: END IF;
1579:
1580: EXCEPTION
1581:

Line 2065: AMS_Utility_PVT.debug_message(' start req item');

2061: IF (AMS_DEBUG_HIGH_ON) THEN
2062:
2063:
2064:
2065: AMS_Utility_PVT.debug_message(' start req item');
2066:
2067: END IF;
2068:
2069: x_return_status := FND_API.g_ret_sts_success;

Line 2120: AMS_Utility_PVT.debug_message(': check uniquness of record');

2116: IF (AMS_DEBUG_HIGH_ON) THEN
2117:
2118:
2119:
2120: AMS_Utility_PVT.debug_message(': check uniquness of record');
2121:
2122: END IF;
2123:
2124: IF p_Access_rec.user_or_role_id IS NOT NULL AND p_access_rec.object_version_number IS NULL THEN

Line 2148: AMS_Utility_PVT.debug_message(': check uniquness of record end ');

2144:
2145: END IF;
2146: IF (AMS_DEBUG_HIGH_ON) THEN
2147:
2148: AMS_Utility_PVT.debug_message(': check uniquness of record end ');
2149: END IF;
2150:
2151: END check_Access_req_items;
2152: ---------------------------------------------------------------------

Line 2176: IF AMS_Utility_PVT.check_uniqueness(

2172: --
2173: IF p_validation_mode = JTF_PLSQL_API.g_create
2174: AND p_Access_rec.activity_access_id IS NOT NULL
2175: THEN
2176: IF AMS_Utility_PVT.check_uniqueness(
2177: 'ams_act_access',
2178: 'activity_access_id = ' || p_Access_rec.activity_access_id
2179: ) = FND_API.g_false
2180: THEN

Line 2215: IF AMS_Utility_PVT.check_fk_exists(

2211: IF p_Access_rec.user_or_role_id <> FND_API.g_miss_num THEN
2212:
2213: if UPPER(p_Access_rec.arc_user_or_role_type) = 'USER' THEN
2214:
2215: IF AMS_Utility_PVT.check_fk_exists(
2216: 'ams_jtf_rs_emp_v',
2217: 'RESOURCE_ID',
2218: p_Access_rec.user_or_role_id
2219: ) = FND_API.g_false

Line 2235: IF AMS_Utility_PVT.check_fk_exists(

2231:
2232:
2233: if UPPER(p_Access_rec.arc_user_or_role_type) = 'GROUP' THEN
2234:
2235: IF AMS_Utility_PVT.check_fk_exists(
2236: -- commented by ptendulk on 22-Jan-2001 Ref Bug #1607548
2237: --'JTF_RS_GROUPS_VL',
2238: 'JTF_RS_GROUPS_B',
2239: 'GROUP_ID',

Line 2283: IF AMS_Utility_PVT.check_lookup_exists(

2279: ----------------------- access to object ------------------------
2280: IF p_Access_rec.arc_act_access_to_object <> FND_API.g_miss_char THEN
2281:
2282: /*
2283: IF AMS_Utility_PVT.check_lookup_exists(
2284: p_lookup_type => 'AMS_SYS_ARC_QUALIFIER',
2285: p_lookup_code => p_Access_rec.arc_act_access_to_object
2286: ) = FND_API.g_false
2287: THEN

Line 2290: IF AMS_Utility_PVT.check_lookup_exists(

2286: ) = FND_API.g_false
2287: THEN
2288: */
2289: /*
2290: IF AMS_Utility_PVT.check_lookup_exists(
2291: p_lookup_type => 'AMS_SYS_ARC_QUALIFIER',
2292: p_lookup_code => p_Access_rec.arc_user_or_role_type,
2293: p_view_application_id => fnd_global.resp_appl_id
2294: ) = FND_API.g_false

Line 2304: IF AMS_Utility_PVT.check_lookup_exists(

2300: -- MDF in PV relies on assumption that Campaing is defined in AMS,
2301: -- and in other cases, we assume that responsibility's application owns this
2302: -- object, i.e. in case of programs, it should in in PV.
2303: -- So, changing code to check in 530 if not found in appl_id. -- bug#2421583
2304: IF AMS_Utility_PVT.check_lookup_exists(
2305: p_lookup_type => 'AMS_SYS_ARC_QUALIFIER',
2306: p_lookup_code => p_Access_rec.arc_act_access_to_object,
2307: p_view_application_id => fnd_global.resp_appl_id
2308: ) = FND_API.g_false

Line 2310: IF AMS_Utility_PVT.check_lookup_exists(

2306: p_lookup_code => p_Access_rec.arc_act_access_to_object,
2307: p_view_application_id => fnd_global.resp_appl_id
2308: ) = FND_API.g_false
2309: THEN
2310: IF AMS_Utility_PVT.check_lookup_exists(
2311: p_lookup_type => 'AMS_SYS_ARC_QUALIFIER',
2312: p_lookup_code => p_Access_rec.arc_act_access_to_object,
2313: p_view_application_id => 530
2314: ) = FND_API.g_false

Line 2330: IF AMS_Utility_PVT.check_lookup_exists(

2326:
2327: ------------------user or role type ---------------------------------------
2328: IF p_Access_rec.arc_user_or_role_type <> FND_API.g_miss_char THEN
2329: /*
2330: IF AMS_Utility_PVT.check_lookup_exists(
2331: p_lookup_type => 'AMS_ACCESS_TYPE',
2332: p_lookup_code => p_Access_rec.arc_user_or_role_type
2333: ) = FND_API.g_false
2334: THEN

Line 2337: IF AMS_Utility_PVT.check_lookup_exists(

2333: ) = FND_API.g_false
2334: THEN
2335: */
2336: -- User and Group lookups should exist only in AMS, and hence using 530
2337: IF AMS_Utility_PVT.check_lookup_exists(
2338: p_lookup_type => 'AMS_ACCESS_TYPE',
2339: p_lookup_code => p_Access_rec.arc_user_or_role_type,
2340: p_view_application_id => 530
2341: ) = FND_API.g_false

Line 2377: IF AMS_Utility_PVT.is_Y_or_N(p_access_rec.admin_flag) = FND_API.g_false

2373: ----------------------- admin_flag ------------------------
2374: IF p_Access_rec.admin_flag <> FND_API.g_miss_char
2375: AND p_Access_rec.admin_flag IS NOT NULL
2376: THEN
2377: IF AMS_Utility_PVT.is_Y_or_N(p_access_rec.admin_flag) = FND_API.g_false
2378: THEN
2379: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2380: THEN
2381: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_BAD_ADMIN_FLAG');

Line 2428: AMS_Utility_PVT.debug_message(' req item check start');

2424: IF (AMS_DEBUG_HIGH_ON) THEN
2425:
2426:
2427:
2428: AMS_Utility_PVT.debug_message(' req item check start');
2429:
2430: END IF;
2431: check_Access_req_items(
2432: p_Access_rec => p_Access_rec,

Line 2444: AMS_Utility_PVT.debug_message(' req item check success');

2440: IF (AMS_DEBUG_HIGH_ON) THEN
2441:
2442:
2443:
2444: AMS_Utility_PVT.debug_message(' req item check success');
2445:
2446: END IF;
2447:
2448: /* added by sunkumar 03-12-2002 bug id.. 2216520 */

Line 2467: AMS_Utility_PVT.debug_message(' UK check items success');

2463:
2464:
2465:
2466:
2467: AMS_Utility_PVT.debug_message(' UK check items success');
2468:
2469:
2470: END IF;
2471:

Line 2486: AMS_Utility_PVT.debug_message('FK check items success ');

2482: IF (AMS_DEBUG_HIGH_ON) THEN
2483:
2484:
2485:
2486: AMS_Utility_PVT.debug_message('FK check items success ');
2487:
2488: END IF;
2489:
2490: IF x_return_status <> FND_API.g_ret_sts_success THEN

Line 2512: AMS_Utility_PVT.debug_message(' Flag check items success ');

2508: IF (AMS_DEBUG_HIGH_ON) THEN
2509:
2510:
2511:
2512: AMS_Utility_PVT.debug_message(' Flag check items success ');
2513:
2514: END IF;
2515:
2516: IF x_return_status <> FND_API.g_ret_sts_success THEN