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

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

60: );
61: -- Check_Approvers_UK_Items
62: PROCEDURE Check_Approvers_UK_Items (
63: p_approvers_rec IN Approvers_Rec_Type,
64: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
65: x_return_status OUT NOCOPY VARCHAR2
66: );
67: -- Check_Approvers_FK_Items
68: PROCEDURE Check_Approvers_FK_Items (

Line 366: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN

362: END IF;
363: RAISE Fnd_Api.g_exc_error;
364: END IF;
365: ELSE
366: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
367: Check_approvers_Items (
368: p_approvers_rec => l_approvers_rec ,
369: p_validation_mode => Jtf_Plsql_Api.g_update,
370: x_return_status => l_return_status

Line 369: p_validation_mode => Jtf_Plsql_Api.g_update,

365: ELSE
366: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
367: Check_approvers_Items (
368: p_approvers_rec => l_approvers_rec ,
369: p_validation_mode => Jtf_Plsql_Api.g_update,
370: x_return_status => l_return_status
371: );
372: IF l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
373: RAISE Fnd_Api.g_exc_unexpected_error;

Line 380: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_record THEN

376: END IF;
377: END IF;
378:
379:
380: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_record THEN
381: Check_approvers_Record (
382: p_approvers_rec => l_approvers_rec,
383: p_complete_rec => l_approvers_rec,
384: x_return_status => l_return_status

Line 702: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN

698: IF (AMS_DEBUG_HIGH_ON) THEN
699:
700: Ams_Utility_Pvt.debug_message (l_full_name || ': Check items');
701: END IF;
702: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
703: Check_Approvers_Items (
704: p_approvers_rec => p_approvers_rec,
705: p_validation_mode => Jtf_Plsql_Api.g_create,
706: x_return_status => l_return_status

Line 705: p_validation_mode => Jtf_Plsql_Api.g_create,

701: END IF;
702: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
703: Check_Approvers_Items (
704: p_approvers_rec => p_approvers_rec,
705: p_validation_mode => Jtf_Plsql_Api.g_create,
706: x_return_status => l_return_status
707: );
708: IF l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
709: RAISE Fnd_Api.g_exc_unexpected_error;

Line 718: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_record THEN

714: IF (AMS_DEBUG_HIGH_ON) THEN
715:
716: Ams_Utility_Pvt.debug_message (l_full_name || ': Check record');
717: END IF;
718: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_record THEN
719: Check_Approvers_Record (
720: p_approvers_rec => p_approvers_rec,
721: p_complete_rec => NULL,
722: x_return_status => l_return_status

Line 783: -- p_validation_mode: JTF_PLSQL_API.g_create/g_update

779: -- required columns, foreign keys, domain constraints.
780: --
781: -- PARAMETERS
782: -- p_approvers_rec: the record to be validated
783: -- p_validation_mode: JTF_PLSQL_API.g_create/g_update
784: ---------------------------------------------------------------------
785: PROCEDURE Check_approvers_Items (
786: p_approvers_rec IN Approvers_Rec_Type,
787: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,

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

783: -- p_validation_mode: JTF_PLSQL_API.g_create/g_update
784: ---------------------------------------------------------------------
785: PROCEDURE Check_approvers_Items (
786: p_approvers_rec IN Approvers_Rec_Type,
787: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
788: x_return_status OUT NOCOPY VARCHAR2
789: ) IS
790: BEGIN
791: --

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

1211: -- Check_Approvers_UK_Items
1212: -------------------------------------------------------------
1213: PROCEDURE Check_Approvers_UK_Items (
1214: p_approvers_rec IN Approvers_Rec_Type,
1215: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
1216: x_return_status OUT NOCOPY VARCHAR2
1217: )IS
1218: l_dummy NUMBER;
1219: CURSOR c_appr_seq_exists(seq_num_in IN NUMBER, id_in IN NUMBER) IS

Line 1228: IF p_validation_mode = Jtf_Plsql_Api.g_create

1224: AND active_flag = 'Y'
1225: );
1226: BEGIN
1227: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1228: IF p_validation_mode = Jtf_Plsql_Api.g_create
1229: THEN
1230: OPEN c_appr_seq_exists (p_approvers_rec.approver_seq,
1231: p_approvers_rec.ams_approval_detail_id
1232: );

Line 1246: IF p_validation_mode = Jtf_Plsql_Api.g_create THEN

1242: END IF;
1243: END IF;
1244:
1245:
1246: IF p_validation_mode = Jtf_Plsql_Api.g_create THEN
1247: Check_Dates_Create_Range (
1248: p_approvers_rec => p_approvers_rec,
1249: x_return_status => x_return_status
1250: );

Line 1257: ELSIF (p_validation_mode = Jtf_Plsql_Api.g_update

1253: RAISE Fnd_Api.g_exc_unexpected_error;
1254: ELSIF x_return_status = Fnd_Api.g_ret_sts_error THEN
1255: RAISE Fnd_Api.g_exc_error;
1256: END IF;
1257: ELSIF (p_validation_mode = Jtf_Plsql_Api.g_update
1258: AND (p_approvers_rec.active_flag = 'Y' OR
1259: p_approvers_rec.active_flag = NULL OR p_approvers_rec.active_flag = Fnd_Api.g_miss_char)) THEN
1260: Check_Dates_Update_Range (
1261: p_approvers_rec => p_approvers_rec,