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

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

79:
80: -- To Check all Visit's Items
81: PROCEDURE Check_Visit_Items (
82: p_Visit_rec IN visit_rec_type,
83: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
84: x_return_status OUT NOCOPY VARCHAR2
85: );
86:
87: -- To Check all Visit's Required Items

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

92:
93: -- To Check all Visit's Unique items
94: PROCEDURE Check_Visit_UK_Items (
95: p_Visit_rec IN Visit_Rec_Type,
96: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
97: x_return_status OUT NOCOPY VARCHAR2
98: );
99:
100: -- SKPATHAK :: AVF ER: 13416865 :: 25-NOV-2011

Line 4083: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN

4079:
4080: /* MANESING::Component Maintenance Planning Project, 05-Jul-2011, commented out
4081: * following check as it's already present in Validate_Visit API.
4082: ----------------------- Validate ----------------------
4083: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
4084: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4085: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling Check_Visit_Items');
4086: END IF;
4087:

Line 4090: p_validation_mode => Jtf_Plsql_Api.g_update,

4086: END IF;
4087:
4088: Check_Visit_Items (
4089: p_Visit_rec => l_visit_rec,
4090: p_validation_mode => Jtf_Plsql_Api.g_update,
4091: x_return_status => l_return_status
4092: );
4093:
4094: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 5754: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN

5750: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5751: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Calling Check_Visit_Items');
5752: END IF;
5753:
5754: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
5755:
5756: /* MANESING::Component Maintenance Planning Project, 05-Jul-2011
5757: * Assign validation mode according to the operation flag.
5758: * This change is required as this API is now called from update_visit API too for common validations.

Line 5761: l_validation_mode := JTF_PLSQL_API.g_create;

5757: * Assign validation mode according to the operation flag.
5758: * This change is required as this API is now called from update_visit API too for common validations.
5759: */
5760: IF (UPPER(p_Visit_rec.operation_flag) = 'C') THEN
5761: l_validation_mode := JTF_PLSQL_API.g_create;
5762: ELSIF (UPPER(p_Visit_rec.operation_flag) = 'U') THEN
5763: l_validation_mode := JTF_PLSQL_API.g_update;
5764: END IF;
5765:

Line 5763: l_validation_mode := JTF_PLSQL_API.g_update;

5759: */
5760: IF (UPPER(p_Visit_rec.operation_flag) = 'C') THEN
5761: l_validation_mode := JTF_PLSQL_API.g_create;
5762: ELSIF (UPPER(p_Visit_rec.operation_flag) = 'U') THEN
5763: l_validation_mode := JTF_PLSQL_API.g_update;
5764: END IF;
5765:
5766: Check_Visit_Items (
5767: p_Visit_rec => p_Visit_rec,

Line 5768: p_validation_mode => l_validation_mode, -- Jtf_Plsql_Api.g_create,

5764: END IF;
5765:
5766: Check_Visit_Items (
5767: p_Visit_rec => p_Visit_rec,
5768: p_validation_mode => l_validation_mode, -- Jtf_Plsql_Api.g_create,
5769: x_return_status => l_return_status
5770: );
5771:
5772: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

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

6093: --
6094: ---------------------------------------------------------------------
6095: PROCEDURE Check_Visit_Items (
6096: p_Visit_rec IN Visit_Rec_Type,
6097: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
6098: x_return_status OUT NOCOPY VARCHAR2
6099: )
6100: IS
6101: BEGIN

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

6186: -- Check_Visit_UK_Items
6187: ---------------------------------------------------------------------
6188: PROCEDURE Check_Visit_UK_Items (
6189: p_Visit_rec IN Visit_Rec_Type,
6190: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
6191: x_return_status OUT NOCOPY VARCHAR2
6192: )
6193: IS
6194: l_valid_flag VARCHAR2(1);

Line 6202: IF p_validation_mode = Jtf_Plsql_Api.g_create AND p_Visit_rec.VISIT_ID IS NOT NULL

6198: -- For Create_Visit, when ID is passed in, we need to
6199: -- check if this ID is unique.
6200: IF UPPER(p_Visit_rec.operation_flag) <> 'C' THEN
6201:
6202: IF p_validation_mode = Jtf_Plsql_Api.g_create AND p_Visit_rec.VISIT_ID IS NOT NULL
6203: THEN
6204:
6205: IF Ahl_Utility_Pvt.check_uniqueness(
6206: 'Ahl_Visits_VL',

Line 6222: IF p_validation_mode = Jtf_Plsql_Api.g_create THEN

6218: END IF;
6219: END IF;
6220:
6221: -- check if VISIT NUMBER is UNIQUE
6222: IF p_validation_mode = Jtf_Plsql_Api.g_create THEN
6223: IF (p_Visit_rec.VISIT_NUMBER IS NOT NULL) THEN
6224: l_valid_flag := Ahl_Utility_Pvt.Check_Uniqueness (
6225: 'Ahl_Visits_VL',
6226: 'VISIT_NUMBER = ''' || p_Visit_rec.VISIT_NUMBER || ''''