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

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

68: -- To Check_Visit_Task_Req_Items
69: PROCEDURE Check_Visit_Task_Req_Items (
70: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,
71: --Added by rnahata for Issue 105
72: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
73: x_return_status OUT NOCOPY VARCHAR2
74: );
75:
76: -- To Check_Visit_Task_UK_Items

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

75:
76: -- To Check_Visit_Task_UK_Items
77: PROCEDURE Check_Visit_Task_UK_Items (
78: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,
79: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
80: x_return_status OUT NOCOPY VARCHAR2
81: );
82:
83: -- To Check_Task_Items

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

82:
83: -- To Check_Task_Items
84: PROCEDURE Check_Task_Items (
85: p_Task_rec IN AHL_VWP_RULES_PVT.task_rec_type,
86: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
87: x_return_status OUT NOCOPY VARCHAR2
88: );
89:
90: -- To Validate_Visit_Task

Line 4946: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN

4942: END IF;
4943:
4944: -- post 11.5.10 changes by Senthil end
4945:
4946: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
4947: Check_Task_Items (
4948: p_task_rec => p_x_task_rec,
4949: p_validation_mode => Jtf_Plsql_Api.g_update,
4950: x_return_status => l_return_status

Line 4949: p_validation_mode => Jtf_Plsql_Api.g_update,

4945:
4946: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
4947: Check_Task_Items (
4948: p_task_rec => p_x_task_rec,
4949: p_validation_mode => Jtf_Plsql_Api.g_update,
4950: x_return_status => l_return_status
4951: );
4952: IF l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
4953: RAISE Fnd_Api.g_exc_unexpected_error;

Line 5593: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN

5589: (
5590: p_x_task_rec => l_Task_rec
5591: );
5592:
5593: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
5594: Check_Task_Items (
5595: p_task_rec => p_x_task_rec,
5596: p_validation_mode => Jtf_Plsql_Api.g_update,
5597: x_return_status => l_return_status

Line 5596: p_validation_mode => Jtf_Plsql_Api.g_update,

5592:
5593: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
5594: Check_Task_Items (
5595: p_task_rec => p_x_task_rec,
5596: p_validation_mode => Jtf_Plsql_Api.g_update,
5597: x_return_status => l_return_status
5598: );
5599: IF l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
5600: RAISE Fnd_Api.g_exc_unexpected_error;

Line 8445: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN

8441: L_DEBUG_KEY,
8442: ':Check items1');
8443: END IF;
8444:
8445: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
8446: Check_Task_Items (
8447: p_task_rec => p_task_rec,
8448: p_validation_mode => Jtf_Plsql_Api.g_create,
8449: x_return_status => l_return_status

Line 8448: p_validation_mode => Jtf_Plsql_Api.g_create,

8444:
8445: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
8446: Check_Task_Items (
8447: p_task_rec => p_task_rec,
8448: p_validation_mode => Jtf_Plsql_Api.g_create,
8449: x_return_status => l_return_status
8450: );
8451: IF l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
8452: RAISE Fnd_Api.g_exc_unexpected_error;

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

8510: --
8511: ---------------------------------------------------------------------
8512: PROCEDURE Check_Task_Items (
8513: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,
8514: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
8515:
8516: x_return_status OUT NOCOPY VARCHAR2
8517: )
8518: IS

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

8616: ---------------------------------------------------------------------
8617: PROCEDURE Check_Visit_Task_Req_Items (
8618: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,
8619: -- Added by rnahata for Issue 105 - validation mode parameter
8620: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
8621: x_return_status OUT NOCOPY VARCHAR2
8622: )
8623: IS
8624: L_API_NAME CONSTANT VARCHAR2(30) := 'Check_Visit_Task_Req_Items';

Line 8681: IF ( p_validation_mode = Jtf_Plsql_Api.g_create ) THEN

8677: x_return_status := Fnd_Api.g_ret_sts_error;
8678: END IF;
8679: END IF;
8680:
8681: IF ( p_validation_mode = Jtf_Plsql_Api.g_create ) THEN
8682: -- Begin changes by rnahata for Issue 105
8683: -- Check if the serial number is present only for serialised instances.
8684: OPEN c_check_inst_nonserial (p_task_rec.instance_id);
8685: FETCH c_check_inst_nonserial INTO l_serial_ctrl;

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

8725: --
8726: ---------------------------------------------------------------------
8727: PROCEDURE Check_Visit_Task_UK_Items (
8728: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,
8729: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
8730: x_return_status OUT NOCOPY VARCHAR2
8731: )
8732: IS
8733: l_valid_flag VARCHAR2(1);

Line 8748: IF p_validation_mode = Jtf_Plsql_Api.g_create

8744: --
8745: -- For Task, when ID is passed in, we need to
8746: -- check if this ID is unique.
8747:
8748: IF p_validation_mode = Jtf_Plsql_Api.g_create
8749: AND p_task_rec.Visit_Task_ID IS NOT NULL
8750: THEN
8751:
8752: IF (l_log_statement >= l_log_current_level) THEN