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 115: AMS_Utility_PVT.debug_message(l_full_name||': start');

111: IF (AMS_DEBUG_HIGH_ON) THEN
112:
113:
114:
115: AMS_Utility_PVT.debug_message(l_full_name||': start');
116:
117: END IF;
118:
119: IF FND_API.to_boolean(p_init_msg_list) THEN

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

133:
134: ----------------------- validate -----------------------
135: IF (AMS_DEBUG_HIGH_ON) THEN
136:
137: AMS_Utility_PVT.debug_message(l_full_name ||': validate');
138: END IF;
139:
140: validate_access(
141: p_api_version => l_api_version,

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

156:
157: -------------------------- insert --------------------------
158: IF (AMS_DEBUG_HIGH_ON) THEN
159:
160: AMS_Utility_PVT.debug_message(l_full_name ||': insert');
161: END IF;
162:
163:
164: /* added by sunkumar 03-12-2002 bug id.. 2216520 */

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

494: IF (AMS_DEBUG_HIGH_ON) THEN
495:
496:
497:
498: AMS_Utility_PVT.debug_message(l_full_name ||': end');
499:
500: END IF;
501:
502: EXCEPTION

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

645: IF (AMS_DEBUG_HIGH_ON) THEN
646:
647:
648:
649: AMS_Utility_PVT.debug_message(l_full_name||': start');
650:
651: END IF;
652:
653: IF FND_API.to_boolean(p_init_msg_list) THEN

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

676:
677: ------------------------ delete ------------------------
678: IF (AMS_DEBUG_HIGH_ON) THEN
679:
680: AMS_Utility_PVT.debug_message(l_full_name ||': delete');
681: END IF;
682:
683: IF l_role_type = 'USER' THEN
684:

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

976: IF (AMS_DEBUG_HIGH_ON) THEN
977:
978:
979:
980: AMS_Utility_PVT.debug_message(l_full_name ||': end');
981:
982: END IF;
983:
984: EXCEPTION

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

1057:
1058: -------------------- initialize ------------------------
1059: IF (AMS_DEBUG_HIGH_ON) THEN
1060:
1061: AMS_Utility_PVT.debug_message(l_full_name||': start');
1062: END IF;
1063:
1064: IF FND_API.to_boolean(p_init_msg_list) THEN
1065: FND_MSG_PUB.initialize;

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

1078:
1079: ------------------------ lock -------------------------
1080: IF (AMS_DEBUG_HIGH_ON) THEN
1081:
1082: AMS_Utility_PVT.debug_message(l_full_name||': lock');
1083: END IF;
1084:
1085: OPEN c_access_b;
1086: FETCH c_access_b INTO l_access_id;

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

1103: IF (AMS_DEBUG_HIGH_ON) THEN
1104:
1105:
1106:
1107: AMS_Utility_PVT.debug_message(l_full_name ||': end');
1108:
1109: END IF;
1110:
1111: EXCEPTION

Line 1113: WHEN AMS_Utility_PVT.resource_locked THEN

1109: END IF;
1110:
1111: EXCEPTION
1112:
1113: WHEN AMS_Utility_PVT.resource_locked THEN
1114: x_return_status := FND_API.g_ret_sts_error;
1115: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1116: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
1117: FND_MSG_PUB.add;

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

1246: IF (AMS_DEBUG_HIGH_ON) THEN
1247:
1248:
1249:
1250: AMS_Utility_PVT.debug_message(l_full_name||': start');
1251:
1252: END IF;
1253:
1254: IF FND_API.to_boolean(p_init_msg_list) THEN

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

1268:
1269: ----------------------- validate ----------------------
1270: IF (AMS_DEBUG_HIGH_ON) THEN
1271:
1272: AMS_Utility_PVT.debug_message(l_full_name ||': validate');
1273: END IF;
1274:
1275:
1276:

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

1293:
1294: -------------------------- update --------------------
1295: IF (AMS_DEBUG_HIGH_ON) THEN
1296:
1297: AMS_Utility_PVT.debug_message(l_full_name ||': update');
1298: END IF;
1299:
1300:
1301:

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

1543: IF (AMS_DEBUG_HIGH_ON) THEN
1544:
1545:
1546:
1547: AMS_Utility_PVT.debug_message(l_full_name ||': end');
1548:
1549: END IF;
1550:
1551: EXCEPTION

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

1629: IF (AMS_DEBUG_HIGH_ON) THEN
1630:
1631:
1632:
1633: AMS_Utility_PVT.debug_message(l_full_name||': start');
1634:
1635: END IF;
1636:
1637: IF FND_API.to_boolean(p_init_msg_list) THEN

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

1651:
1652: ----------------------- validate ----------------------
1653: IF (AMS_DEBUG_HIGH_ON) THEN
1654:
1655: AMS_Utility_PVT.debug_message(l_full_name ||': validate');
1656: END IF;
1657:
1658: -- added by julou 14-DEC-2001 check existence of new owner
1659: OPEN c_user_exists;

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

1758: IF (AMS_DEBUG_HIGH_ON) THEN
1759:
1760:
1761:
1762: AMS_Utility_PVT.debug_message(l_full_name ||': end');
1763:
1764: END IF;
1765:
1766: EXCEPTION

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

1843:
1844: ----------------------- initialize --------------------
1845: IF (AMS_DEBUG_HIGH_ON) THEN
1846:
1847: AMS_Utility_PVT.debug_message(l_full_name||': start validate');
1848: END IF;
1849:
1850: IF FND_API.to_boolean(p_init_msg_list) THEN
1851: FND_MSG_PUB.initialize;

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

1864:
1865: ---------------------- validate ------------------------
1866: IF (AMS_DEBUG_HIGH_ON) THEN
1867:
1868: AMS_Utility_PVT.debug_message(l_full_name||': check items');
1869: END IF;
1870:
1871: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1872: check_access_items(

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

1885: IF (AMS_DEBUG_HIGH_ON) THEN
1886:
1887:
1888:
1889: AMS_Utility_PVT.debug_message(l_full_name||': check record');
1890:
1891: END IF;
1892:
1893: -- Check for Dupliacate Records -----

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

1916: CLOSE c_check_dup;
1917: -------------------- finish --------------------------
1918: IF (AMS_DEBUG_HIGH_ON) THEN
1919:
1920: AMS_Utility_PVT.debug_message(l_full_name ||': end');
1921: END IF;
1922:
1923: EXCEPTION
1924:

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

2404: IF (AMS_DEBUG_HIGH_ON) THEN
2405:
2406:
2407:
2408: AMS_Utility_PVT.debug_message(' start req item');
2409:
2410: END IF;
2411:
2412: x_return_status := FND_API.g_ret_sts_success;

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

2459: IF (AMS_DEBUG_HIGH_ON) THEN
2460:
2461:
2462:
2463: AMS_Utility_PVT.debug_message(': check uniquness of record');
2464:
2465: END IF;
2466:
2467: IF p_Access_rec.user_or_role_id IS NOT NULL AND p_access_rec.object_version_number IS NULL THEN

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

2487:
2488: END IF;
2489: IF (AMS_DEBUG_HIGH_ON) THEN
2490:
2491: AMS_Utility_PVT.debug_message(': check uniquness of record end ');
2492: END IF;
2493:
2494: END check_Access_req_items;
2495: ---------------------------------------------------------------------

Line 2519: IF AMS_Utility_PVT.check_uniqueness(

2515: --
2516: IF p_validation_mode = JTF_PLSQL_API.g_create
2517: AND p_Access_rec.activity_access_id IS NOT NULL
2518: THEN
2519: IF AMS_Utility_PVT.check_uniqueness(
2520: 'ams_act_access',
2521: 'activity_access_id = ' || p_Access_rec.activity_access_id
2522: ) = FND_API.g_false
2523: THEN

Line 2558: IF AMS_Utility_PVT.check_fk_exists(

2554: IF p_Access_rec.user_or_role_id <> FND_API.g_miss_num THEN
2555:
2556: if UPPER(p_Access_rec.arc_user_or_role_type) = 'USER' THEN
2557:
2558: IF AMS_Utility_PVT.check_fk_exists(
2559: 'ams_jtf_rs_emp_v',
2560: 'RESOURCE_ID',
2561: p_Access_rec.user_or_role_id
2562: ) = FND_API.g_false

Line 2578: IF AMS_Utility_PVT.check_fk_exists(

2574:
2575:
2576: if UPPER(p_Access_rec.arc_user_or_role_type) = 'GROUP' THEN
2577:
2578: IF AMS_Utility_PVT.check_fk_exists(
2579: -- commented by ptendulk on 22-Jan-2001 Ref Bug #1607548
2580: --'JTF_RS_GROUPS_VL',
2581: 'JTF_RS_GROUPS_B',
2582: 'GROUP_ID',

Line 2626: IF AMS_Utility_PVT.check_lookup_exists(

2622: ----------------------- access to object ------------------------
2623: IF p_Access_rec.arc_act_access_to_object <> FND_API.g_miss_char THEN
2624:
2625: /*
2626: IF AMS_Utility_PVT.check_lookup_exists(
2627: p_lookup_type => 'AMS_SYS_ARC_QUALIFIER',
2628: p_lookup_code => p_Access_rec.arc_act_access_to_object
2629: ) = FND_API.g_false
2630: THEN

Line 2633: IF AMS_Utility_PVT.check_lookup_exists(

2629: ) = FND_API.g_false
2630: THEN
2631: */
2632: /*
2633: IF AMS_Utility_PVT.check_lookup_exists(
2634: p_lookup_type => 'AMS_SYS_ARC_QUALIFIER',
2635: p_lookup_code => p_Access_rec.arc_user_or_role_type,
2636: p_view_application_id => fnd_global.resp_appl_id
2637: ) = FND_API.g_false

Line 2647: IF AMS_Utility_PVT.check_lookup_exists(

2643: -- MDF in PV relies on assumption that Campaing is defined in AMS,
2644: -- and in other cases, we assume that responsibility's application owns this
2645: -- object, i.e. in case of programs, it should in in PV.
2646: -- So, changing code to check in 530 if not found in appl_id. -- bug#2421583
2647: IF AMS_Utility_PVT.check_lookup_exists(
2648: p_lookup_type => 'AMS_SYS_ARC_QUALIFIER',
2649: p_lookup_code => p_Access_rec.arc_act_access_to_object,
2650: p_view_application_id => fnd_global.resp_appl_id
2651: ) = FND_API.g_false

Line 2653: IF AMS_Utility_PVT.check_lookup_exists(

2649: p_lookup_code => p_Access_rec.arc_act_access_to_object,
2650: p_view_application_id => fnd_global.resp_appl_id
2651: ) = FND_API.g_false
2652: THEN
2653: IF AMS_Utility_PVT.check_lookup_exists(
2654: p_lookup_type => 'AMS_SYS_ARC_QUALIFIER',
2655: p_lookup_code => p_Access_rec.arc_act_access_to_object,
2656: p_view_application_id => 530
2657: ) = FND_API.g_false

Line 2673: IF AMS_Utility_PVT.check_lookup_exists(

2669:
2670: ------------------user or role type ---------------------------------------
2671: IF p_Access_rec.arc_user_or_role_type <> FND_API.g_miss_char THEN
2672: /*
2673: IF AMS_Utility_PVT.check_lookup_exists(
2674: p_lookup_type => 'AMS_ACCESS_TYPE',
2675: p_lookup_code => p_Access_rec.arc_user_or_role_type
2676: ) = FND_API.g_false
2677: THEN

Line 2680: IF AMS_Utility_PVT.check_lookup_exists(

2676: ) = FND_API.g_false
2677: THEN
2678: */
2679: -- User and Group lookups should exist only in AMS, and hence using 530
2680: IF AMS_Utility_PVT.check_lookup_exists(
2681: p_lookup_type => 'AMS_ACCESS_TYPE',
2682: p_lookup_code => p_Access_rec.arc_user_or_role_type,
2683: p_view_application_id => 530
2684: ) = FND_API.g_false

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

2716: ----------------------- admin_flag ------------------------
2717: IF p_Access_rec.admin_flag <> FND_API.g_miss_char
2718: AND p_Access_rec.admin_flag IS NOT NULL
2719: THEN
2720: IF AMS_Utility_PVT.is_Y_or_N(p_access_rec.admin_flag) = FND_API.g_false
2721: THEN
2722: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2723: THEN
2724: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_BAD_ADMIN_FLAG');

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

2767: IF (AMS_DEBUG_HIGH_ON) THEN
2768:
2769:
2770:
2771: AMS_Utility_PVT.debug_message(' req item check start');
2772:
2773: END IF;
2774: check_Access_req_items(
2775: p_Access_rec => p_Access_rec,

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

2783: IF (AMS_DEBUG_HIGH_ON) THEN
2784:
2785:
2786:
2787: AMS_Utility_PVT.debug_message(' req item check success');
2788:
2789: END IF;
2790:
2791: /* added by sunkumar 03-12-2002 bug id.. 2216520 */

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

2806:
2807:
2808:
2809:
2810: AMS_Utility_PVT.debug_message(' UK check items success');
2811:
2812:
2813: END IF;
2814:

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

2825: IF (AMS_DEBUG_HIGH_ON) THEN
2826:
2827:
2828:
2829: AMS_Utility_PVT.debug_message('FK check items success ');
2830:
2831: END IF;
2832:
2833: IF x_return_status <> FND_API.g_ret_sts_success THEN

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

2851: IF (AMS_DEBUG_HIGH_ON) THEN
2852:
2853:
2854:
2855: AMS_Utility_PVT.debug_message(' Flag check items success ');
2856:
2857: END IF;
2858:
2859: IF x_return_status <> FND_API.g_ret_sts_success THEN