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

Line 84: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,

80: );
81: -- Check_Approval_Dtls_UK_Items
82: PROCEDURE Check_Approval_Dtls_UK_Items (
83: p_approval_details_rec IN Approval_Details_Rec_Type,
84: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
85: x_return_status OUT NOCOPY VARCHAR2
86: );
87: -- Check_Approval_Dtls_FK_Items
88: PROCEDURE Check_Approval_Dtls_FK_Items (

Line 466: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

462: END IF;
463: RAISE FND_API.g_exc_error;
464: END IF;
465: ELSE
466: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
467: Check_approval_details_Items (
468: p_approval_details_rec => l_approval_details_Rec ,
469: p_validation_mode => JTF_PLSQL_API.g_update,
470: x_return_status => l_return_status

Line 469: p_validation_mode => JTF_PLSQL_API.g_update,

465: ELSE
466: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
467: Check_approval_details_Items (
468: p_approval_details_rec => l_approval_details_Rec ,
469: p_validation_mode => JTF_PLSQL_API.g_update,
470: x_return_status => l_return_status
471: );
472: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
473: RAISE FND_API.g_exc_unexpected_error;

Line 478: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

474: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
475: RAISE FND_API.g_exc_error;
476: END IF;
477: END IF;
478: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
479: Check_approval_details_Record (
480: p_approval_details_rec => p_approval_details_rec,
481: p_complete_rec => l_approval_details_rec,
482: x_return_status => l_return_status

Line 819: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

815: IF (AMS_DEBUG_HIGH_ON) THEN
816:
817: AMS_Utility_PVT.debug_message (l_full_name || ': Check items');
818: END IF;
819: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
820: Check_Approval_details_Items (
821: p_approval_details_rec => p_approval_details_rec,
822: p_validation_mode => JTF_PLSQL_API.g_create,
823: x_return_status => l_return_status

Line 822: p_validation_mode => JTF_PLSQL_API.g_create,

818: END IF;
819: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
820: Check_Approval_details_Items (
821: p_approval_details_rec => p_approval_details_rec,
822: p_validation_mode => JTF_PLSQL_API.g_create,
823: x_return_status => l_return_status
824: );
825: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
826: RAISE FND_API.g_exc_unexpected_error;

Line 835: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

831: IF (AMS_DEBUG_HIGH_ON) THEN
832:
833: AMS_Utility_PVT.debug_message (l_full_name || ': Check record');
834: END IF;
835: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
836: Check_Approval_details_Record (
837: p_approval_details_rec => p_approval_details_rec,
838: p_complete_rec => NULL,
839: x_return_status => l_return_status

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

894: -- required columns, foreign keys, domain constraints.
895: --
896: -- PARAMETERS
897: -- p_approval_details_rec: the record to be validated
898: -- p_validation_mode: JTF_PLSQL_API.g_create/g_update
899: ---------------------------------------------------------------------
900: PROCEDURE Check_approval_details_Items (
901: p_approval_details_rec IN approval_details_Rec_Type,
902: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,

Line 902: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,

898: -- p_validation_mode: JTF_PLSQL_API.g_create/g_update
899: ---------------------------------------------------------------------
900: PROCEDURE Check_approval_details_Items (
901: p_approval_details_rec IN approval_details_Rec_Type,
902: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
903: x_return_status OUT NOCOPY VARCHAR2
904: ) IS
905: BEGIN
906: --

Line 912: --IF p_validation_mode = JTF_PLSQL_API.g_create THEN --VMODUR 24-Jul-2002

908:
909: AMS_Utility_PVT.debug_message ('Inside Check_approval_details_Items0');
910: END IF;
911:
912: --IF p_validation_mode = JTF_PLSQL_API.g_create THEN --VMODUR 24-Jul-2002
913: --- some logic
914: If (p_approval_details_rec.start_date_active > p_approval_details_rec.end_date_active) THEN
915: --dbms_output.put_line('st > ed ');
916: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 1547: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,

1543: -- Check_Approval_Dtls_UK_Items
1544: -------------------------------------------------------------
1545: PROCEDURE Check_Approval_Dtls_UK_Items (
1546: p_approval_details_rec IN Approval_Details_Rec_Type,
1547: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1548: x_return_status OUT NOCOPY VARCHAR2
1549: )IS
1550:
1551: l_valid_flag VARCHAR2(1);

Line 1589: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

1585: END IF;
1586: x_return_status := FND_API.G_RET_STS_SUCCESS;
1587:
1588: --Validate unique approval_id
1589: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1590: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1591: 'ams_approval_details',
1592: 'approval_detail_id = ''' || p_approval_details_rec.approval_detail_id ||'''');
1593: ELSE

Line 1644: IF p_validation_mode = JTF_PLSQL_API.g_create

1640: END IF;
1641:
1642:
1643: /*
1644: IF p_validation_mode = JTF_PLSQL_API.g_create
1645: AND p_approval_details_rec.approval_detail_id IS NOT NULL THEN
1646: OPEN c_appr_name2(P_approval_details_rec.name,P_approval_details_rec.approval_detail_id);
1647: fetch c_appr_name2 into l_dummy;
1648: close c_appr_name2;

Line 1663: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

1659: END IF;
1660:
1661:
1662: -- check if NAME is UNIQUE
1663: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1664: OPEN c_appr_name1(P_approval_details_rec.name);
1665: fetch c_appr_name1 into l_dummy;
1666: close c_appr_name1;
1667: IF l_dummy <> 1 THEN

Line 2163: IF p_validation_mode = JTF_PLSQL_API.g_update THEN

2159:
2160: BEGIN
2161:
2162: /* If the Rule is already active i.e. start_date is < SYSDATE, you cannot update the start_date */
2163: IF p_validation_mode = JTF_PLSQL_API.g_update THEN
2164:
2165: OPEN c_approval_dates;
2166: FETCH c_approval_dates INTO l_start_date, l_end_date;
2167: CLOSE c_approval_dates;

Line 2212: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

2208:
2209: END IF;
2210:
2211:
2212: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
2213:
2214: /* Checking the Dates are Valid Or Not */
2215: IF (p_start_date IS NOT NULL AND p_start_date < trunc(SYSDATE)) THEN
2216: IF (AMS_DEBUG_HIGH_ON) THEN