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

Line 51: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,

47:
48: -- Check_Approval_Rules_UK_Items
49: PROCEDURE Check_Approval_Rules_UK_Items (
50: p_Approval_Rules_rec IN Approval_Rules_Rec_Type,
51: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
52: x_return_status OUT NOCOPY VARCHAR2
53: );
54:
55: -- Compare Columns

Line 130: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,

126:
127: -- Check_Approvers_UK_Items
128: PROCEDURE Check_Approvers_UK_Items (
129: p_Approvers_rec IN Approvers_Rec_Type,
130: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
131: x_return_status OUT NOCOPY VARCHAR2
132: );
133:
134: PROCEDURE Check_Approver_Name_Or_Id(

Line 957: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN

953: RAISE Fnd_Api.g_exc_unexpected_error;
954: END IF;
955: END IF;
956: END IF;*/
957: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
958: Check_Approval_Rules_Items (
959: p_Approval_Rules_rec => p_Approval_Rules_rec,
960: p_validation_mode => Jtf_Plsql_Api.g_update,
961: x_return_status => l_return_status

Line 960: p_validation_mode => Jtf_Plsql_Api.g_update,

956: END IF;*/
957: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
958: Check_Approval_Rules_Items (
959: p_Approval_Rules_rec => p_Approval_Rules_rec,
960: p_validation_mode => Jtf_Plsql_Api.g_update,
961: x_return_status => l_return_status
962: );
963: IF l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
964: RAISE Fnd_Api.g_exc_unexpected_error;

Line 970: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_record THEN

966: RAISE Fnd_Api.g_exc_error;
967: END IF;
968: END IF;
969:
970: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_record THEN
971: Check_Approval_Rules_Record (
972: p_Approval_Rules_rec => p_Approval_Rules_rec,
973: p_complete_rec => l_Approval_Rules_rec,
974: x_return_status => l_return_status

Line 1688: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN

1684: ---------------------- validate ------------------------
1685: IF G_DEBUG='Y' THEN
1686: Ahl_Debug_Pub.debug( l_full_name ||':Check items');
1687: END IF;
1688: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
1689: Check_Approval_Rules_Items (
1690: p_Approval_Rules_rec => p_Approval_Rules_rec,
1691: p_validation_mode => Jtf_Plsql_Api.g_create,
1692: x_return_status => l_return_status

Line 1691: p_validation_mode => Jtf_Plsql_Api.g_create,

1687: END IF;
1688: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
1689: Check_Approval_Rules_Items (
1690: p_Approval_Rules_rec => p_Approval_Rules_rec,
1691: p_validation_mode => Jtf_Plsql_Api.g_create,
1692: x_return_status => l_return_status
1693: );
1694: IF l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1695: RAISE Fnd_Api.g_exc_unexpected_error;

Line 1704: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_record THEN

1700: IF G_DEBUG='Y' THEN
1701: Ahl_Debug_Pub.debug( l_full_name ||':Check record');
1702: END IF;
1703:
1704: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_record THEN
1705: Check_Approval_Rules_Record (
1706: p_Approval_Rules_rec => p_Approval_Rules_rec,
1707: p_complete_rec => NULL,
1708: x_return_status => l_return_status

Line 1764: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,

1760: --
1761: ---------------------------------------------------------------------
1762: PROCEDURE Check_Approval_Rules_Items (
1763: p_Approval_Rules_rec IN Approval_Rules_Rec_Type,
1764: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
1765: x_return_status OUT NOCOPY VARCHAR2
1766: )
1767: IS
1768: BEGIN

Line 2126: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,

2122:
2123: -- Check_Approval_Rules_UK_Items
2124: PROCEDURE Check_Approval_Rules_UK_Items (
2125: p_Approval_Rules_rec IN Approval_Rules_Rec_Type,
2126: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
2127: x_return_status OUT NOCOPY VARCHAR2
2128: )
2129: IS
2130: l_valid_flag VARCHAR2(1);

Line 2160: IF p_validation_mode = Jtf_Plsql_Api.g_create

2156: x_return_status := Fnd_Api.g_ret_sts_success;
2157: --
2158: -- For Create_Approval_Rules, when ID is passed in, we need to
2159: -- check if this ID is unique.
2160: IF p_validation_mode = Jtf_Plsql_Api.g_create
2161: AND p_Approval_Rules_rec.Approval_Rule_id IS NOT NULL
2162: THEN
2163: IF Ahl_Utility_Pvt.check_uniqueness(
2164: 'Ahl_Approval_Rules_v',

Line 2178: IF p_validation_mode = Jtf_Plsql_Api.g_create THEN

2174: END IF;
2175: END IF;
2176:
2177: -- check if NAME is UNIQUE
2178: IF p_validation_mode = Jtf_Plsql_Api.g_create THEN
2179: l_valid_flag := Ahl_Utility_Pvt.Check_Uniqueness (
2180: 'Ahl_Approval_Rules_v',
2181: 'approval_rule_name = ''' || p_Approval_Rules_rec.approval_rule_name || ''''
2182: -- ''' AND language = ''' || p_Approval_Rules_rec.language || ''''

Line 2227: IF p_validation_mode = Jtf_Plsql_Api.g_create THEN

2223: l_application_usg_code := NULL;
2224: END IF;
2225: CLOSE c_appl_usg;
2226: */
2227: IF p_validation_mode = Jtf_Plsql_Api.g_create THEN
2228: -- For add approval uniqueness validations
2229: IF l_approval_priority_code IS NOT NULL AND l_OPERATING_UNIT_ID IS NOT NULL THEN
2230: l_valid_flag := Check_Rules_Uniqueness (
2231: 'Ahl_Approval_Rules_v',

Line 2626: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN

2622: Ahl_Debug_Pub.debug( l_full_name ||':Validate');
2623: END IF;
2624: -- replace g_miss_char/num/date with current column values
2625: Complete_Approvers_Rec (p_Approvers_rec, l_Approvers_rec);
2626: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
2627: Check_Approvers_Items (
2628: p_validation_mode => Jtf_Plsql_Api.g_update,
2629: p_Approvers_rec => p_Approvers_rec,
2630: x_return_status => l_return_status

Line 2628: p_validation_mode => Jtf_Plsql_Api.g_update,

2624: -- replace g_miss_char/num/date with current column values
2625: Complete_Approvers_Rec (p_Approvers_rec, l_Approvers_rec);
2626: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
2627: Check_Approvers_Items (
2628: p_validation_mode => Jtf_Plsql_Api.g_update,
2629: p_Approvers_rec => p_Approvers_rec,
2630: x_return_status => l_return_status
2631: );
2632: IF l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

Line 3018: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN

3014: IF G_DEBUG='Y' THEN
3015: Ahl_Debug_Pub.debug( l_full_name ||':Check items');
3016: END IF;
3017:
3018: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
3019: Check_Approvers_Items (
3020: p_validation_mode => Jtf_Plsql_Api.g_create,
3021: p_Approvers_rec => p_Approvers_rec,
3022: x_return_status => l_return_status

Line 3020: p_validation_mode => Jtf_Plsql_Api.g_create,

3016: END IF;
3017:
3018: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
3019: Check_Approvers_Items (
3020: p_validation_mode => Jtf_Plsql_Api.g_create,
3021: p_Approvers_rec => p_Approvers_rec,
3022: x_return_status => l_return_status
3023: );
3024: IF l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

Line 3081: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,

3077: -- Check_Approvers_Items
3078: --
3079: ---------------------------------------------------------------------
3080: PROCEDURE Check_Approvers_Items (
3081: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
3082: p_Approvers_rec IN Approvers_Rec_Type,
3083: x_return_status OUT NOCOPY VARCHAR2
3084: )
3085: IS

Line 3374: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,

3370:
3371: -- Check_Approvers_UK_Items
3372: PROCEDURE Check_Approvers_UK_Items (
3373: p_Approvers_rec IN Approvers_Rec_Type,
3374: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
3375: x_return_status OUT NOCOPY VARCHAR2
3376: )
3377: IS
3378: l_valid_flag VARCHAR2(1);

Line 3384: IF p_validation_mode = Jtf_Plsql_Api.g_create

3380: x_return_status := Fnd_Api.g_ret_sts_success;
3381: -- APPROVAL_APPROVER_ID
3382: -- For Create_Approvers, when ID is passed in, we need to
3383: -- check if this ID is unique.
3384: IF p_validation_mode = Jtf_Plsql_Api.g_create
3385: AND p_Approvers_rec.Approval_Approver_Id IS NOT NULL
3386: THEN
3387: IF Ahl_Utility_Pvt.check_uniqueness(
3388: 'AHL_Approvers',

Line 3402: IF p_validation_mode = Jtf_Plsql_Api.g_create THEN

3398: END IF;
3399: END IF;
3400: -- check if Approval_Rule_Id,Approver_Sequence and Approver_Id is UNIQUE
3401:
3402: IF p_validation_mode = Jtf_Plsql_Api.g_create THEN
3403: l_valid_flag := Ahl_Utility_Pvt.check_uniqueness (
3404: 'AHL_Approvers',
3405: 'Approval_Rule_Id = ' || p_Approvers_rec.Approval_Rule_Id ||
3406: ' AND Approver_Sequence = ' || p_Approvers_rec.Approver_Sequence