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 AMS_UTILITY_PVT

Line 156: Ams_Utility_Pvt.debug_message (l_full_name || ': Start');

152: --------------------- initialize -----------------------
153: SAVEPOINT Create_Approvers;
154: IF (AMS_DEBUG_HIGH_ON) THEN
155:
156: Ams_Utility_Pvt.debug_message (l_full_name || ': Start');
157: END IF;
158: IF Fnd_Api.to_boolean (p_init_msg_list) THEN
159: Fnd_Msg_Pub.initialize;
160: END IF;

Line 173: Ams_Utility_Pvt.debug_message (l_full_name || ': Validate');

169: x_return_status := Fnd_Api.g_ret_sts_success;
170: ----------------------- validate -----------------------
171: IF (AMS_DEBUG_HIGH_ON) THEN
172:
173: Ams_Utility_Pvt.debug_message (l_full_name || ': Validate');
174: END IF;
175: Validate_approvers (
176: p_api_version => L_API_VERSION,
177: p_init_msg_list => p_init_msg_list,

Line 217: Ams_Utility_Pvt.debug_message (l_full_name || ': Insert');

213: END IF;
214: -------------------------- insert --------------------------
215: IF (AMS_DEBUG_HIGH_ON) THEN
216:
217: Ams_Utility_Pvt.debug_message (l_full_name || ': Insert');
218: END IF;
219: --
220: -- Insert into mutli-language supported table.
221: --

Line 259: Ams_Utility_Pvt.debug_message (l_full_name || ': End');

255: p_data => x_msg_data
256: );
257: IF (AMS_DEBUG_HIGH_ON) THEN
258:
259: Ams_Utility_Pvt.debug_message (l_full_name || ': End');
260: END IF;
261:
262:
263: EXCEPTION

Line 335: Ams_Utility_Pvt.debug_message (l_full_name || ': Start');

331: --------------------- initialize -----------------------
332: SAVEPOINT Update_approvers;
333: IF (AMS_DEBUG_HIGH_ON) THEN
334:
335: Ams_Utility_Pvt.debug_message (l_full_name || ': Start');
336: END IF;
337: IF Fnd_Api.to_boolean (p_init_msg_list) THEN
338: Fnd_Msg_Pub.initialize;
339: END IF;

Line 353: Ams_Utility_Pvt.debug_message (l_full_name || ': Validate');

349:
350: ----------------------- validate ----------------------
351: IF (AMS_DEBUG_HIGH_ON) THEN
352:
353: Ams_Utility_Pvt.debug_message (l_full_name || ': Validate');
354: END IF;
355: -- replace g_miss_char/num/date with current column values
356: Complete_approvers_Rec(p_approvers_rec,l_approvers_rec);
357: IF l_approvers_rec.seeded_flag = 'Y' THEN

Line 401: Ams_Utility_Pvt.debug_message (l_full_name || ': Update');

397: THEN
398: -------------------------- update --------------------
399: IF (AMS_DEBUG_HIGH_ON) THEN
400:
401: Ams_Utility_Pvt.debug_message (l_full_name || ': Update');
402: END IF;
403: Ams_Approvers_Pkg.UPDATE_ROW(
404: X_APPROVER_ID => l_approvers_rec.approver_id,
405: X_SEEDED_FLAG => l_approvers_rec.SEEDED_FLAG,

Line 433: Ams_Utility_Pvt.debug_message (l_full_name || ': End');

429: p_data => x_msg_data
430: );
431: IF (AMS_DEBUG_HIGH_ON) THEN
432:
433: Ams_Utility_Pvt.debug_message (l_full_name || ': End');
434: END IF;
435:
436:
437: EXCEPTION

Line 532: Ams_Utility_Pvt.debug_message (l_full_name || ': Start');

528: --------------------- initialize -----------------------
529: SAVEPOINT Delete_approvers;
530: IF (AMS_DEBUG_HIGH_ON) THEN
531:
532: Ams_Utility_Pvt.debug_message (l_full_name || ': Start');
533: END IF;
534: IF Fnd_Api.to_boolean (p_init_msg_list) THEN
535: Fnd_Msg_Pub.initialize;
536: END IF;

Line 550: Ams_Utility_Pvt.debug_message (l_full_name || ': Delete');

546:
547: ------------------------ delete ------------------------
548: IF (AMS_DEBUG_HIGH_ON) THEN
549:
550: Ams_Utility_Pvt.debug_message (l_full_name || ': Delete');
551: END IF;
552: -- Delete TL data
553: IF l_approvers_rec.seeded_flag='N'
554: THEN

Line 574: Ams_Utility_Pvt.debug_message (l_full_name || ': End');

570: p_data => x_msg_data
571: );
572: IF (AMS_DEBUG_HIGH_ON) THEN
573:
574: Ams_Utility_Pvt.debug_message (l_full_name || ': End');
575: END IF;
576:
577:
578: EXCEPTION

Line 682: Ams_Utility_Pvt.debug_message (l_full_name || ': Start');

678:
679: --------------------- initialize -----------------------
680: IF (AMS_DEBUG_HIGH_ON) THEN
681:
682: Ams_Utility_Pvt.debug_message (l_full_name || ': Start');
683: END IF;
684: IF Fnd_Api.to_boolean (p_init_msg_list) THEN
685: Fnd_Msg_Pub.initialize;
686: END IF;

Line 700: Ams_Utility_Pvt.debug_message (l_full_name || ': Check items');

696:
697: ---------------------- validate ------------------------
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,

Line 716: Ams_Utility_Pvt.debug_message (l_full_name || ': Check record');

712: END IF;
713: END IF;
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,

Line 742: Ams_Utility_Pvt.debug_message (l_full_name || ': End');

738: p_data => x_msg_data
739: );
740: IF (AMS_DEBUG_HIGH_ON) THEN
741:
742: Ams_Utility_Pvt.debug_message (l_full_name || ': End');
743: END IF;
744: EXCEPTION
745: WHEN Fnd_Api.g_exc_error THEN
746: x_return_status := Fnd_Api.g_ret_sts_error;

Line 1035: Ams_Utility_Pvt.DEBUG_MESSAGE('sTART DATE:'|| TO_CHAR( p_approvers_rec.start_date_active,'DD_MON_YYYY'));

1031:
1032: BEGIN
1033: IF (AMS_DEBUG_HIGH_ON) THEN
1034:
1035: Ams_Utility_Pvt.DEBUG_MESSAGE('sTART DATE:'|| TO_CHAR( p_approvers_rec.start_date_active,'DD_MON_YYYY'));
1036: END IF;
1037: IF (AMS_DEBUG_HIGH_ON) THEN
1038:
1039: Ams_Utility_Pvt.DEBUG_MESSAGE('end DATE:'|| TO_CHAR( p_approvers_rec.end_Date_active,'DD-MON-YYYY'));

Line 1039: Ams_Utility_Pvt.DEBUG_MESSAGE('end DATE:'|| TO_CHAR( p_approvers_rec.end_Date_active,'DD-MON-YYYY'));

1035: Ams_Utility_Pvt.DEBUG_MESSAGE('sTART DATE:'|| TO_CHAR( p_approvers_rec.start_date_active,'DD_MON_YYYY'));
1036: END IF;
1037: IF (AMS_DEBUG_HIGH_ON) THEN
1038:
1039: Ams_Utility_Pvt.DEBUG_MESSAGE('end DATE:'|| TO_CHAR( p_approvers_rec.end_Date_active,'DD-MON-YYYY'));
1040: END IF;
1041:
1042: IF p_approvers_rec.start_date_active IS NOT NULL THEN
1043: IF p_approvers_rec.end_Date_active IS NOT NULL THEN

Line 1327: Ams_Utility_Pvt.debug_message('The approver type is ' || p_approvers_rec.approver_type);

1323: IF (AMS_DEBUG_HIGH_ON) THEN
1324:
1325:
1326:
1327: Ams_Utility_Pvt.debug_message('The approver type is ' || p_approvers_rec.approver_type);
1328:
1329: END IF;
1330: IF (AMS_DEBUG_HIGH_ON) THEN
1331:

Line 1332: Ams_Utility_Pvt.debug_message('The object_approver_id is ' || p_approvers_rec.object_approver_id);

1328:
1329: END IF;
1330: IF (AMS_DEBUG_HIGH_ON) THEN
1331:
1332: Ams_Utility_Pvt.debug_message('The object_approver_id is ' || p_approvers_rec.object_approver_id);
1333: END IF;
1334:
1335: IF p_approvers_rec.approver_type = 'USER' THEN
1336: OPEN c_uappr_id_exists (p_approvers_rec.object_approver_id);

Line 1341: Ams_Utility_Pvt.debug_message('The l_dummy is ' || l_dummy);

1337: FETCH c_uappr_id_exists INTO l_dummy;
1338: CLOSE c_uappr_id_exists;
1339: IF (AMS_DEBUG_HIGH_ON) THEN
1340:
1341: Ams_Utility_Pvt.debug_message('The l_dummy is ' || l_dummy);
1342: END IF;
1343:
1344: IF l_dummy <> 1 THEN
1345: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

Line 1355: Ams_Utility_Pvt.debug_message('The approver type is ' || p_approvers_rec.approver_type);

1351: END IF;
1352: ELSIF p_approvers_rec.approver_type = 'ROLE' THEN
1353: IF (AMS_DEBUG_HIGH_ON) THEN
1354:
1355: Ams_Utility_Pvt.debug_message('The approver type is ' || p_approvers_rec.approver_type);
1356: END IF;
1357: IF (AMS_DEBUG_HIGH_ON) THEN
1358:
1359: Ams_Utility_Pvt.debug_message('The object_approver_id is ' || p_approvers_rec.object_approver_id);

Line 1359: Ams_Utility_Pvt.debug_message('The object_approver_id is ' || p_approvers_rec.object_approver_id);

1355: Ams_Utility_Pvt.debug_message('The approver type is ' || p_approvers_rec.approver_type);
1356: END IF;
1357: IF (AMS_DEBUG_HIGH_ON) THEN
1358:
1359: Ams_Utility_Pvt.debug_message('The object_approver_id is ' || p_approvers_rec.object_approver_id);
1360: END IF;
1361:
1362:
1363: OPEN c_rappr_id_exists (p_approvers_rec.object_approver_id);

Line 1405: Ams_Utility_Pvt.get_lookup_meaning( 'AMS_APPROVER_TYPE',

1401: l_meaning VARCHAR2(80);
1402: BEGIN
1403: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1404: IF p_approvers_rec.approver_type <> Fnd_Api.g_miss_char THEN
1405: Ams_Utility_Pvt.get_lookup_meaning( 'AMS_APPROVER_TYPE',
1406: p_approvers_rec.approver_type,
1407: x_return_status,
1408: l_meaning
1409: );

Line 1462: Ams_Utility_Pvt.debug_message('Approver end date cannot be specified without start date');

1458: IF (p_start_date IS NULL AND p_end_date IS NOT NULL) THEN
1459: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1460: IF (AMS_DEBUG_HIGH_ON) THEN
1461:
1462: Ams_Utility_Pvt.debug_message('Approver end date cannot be specified without start date');
1463: END IF;
1464:
1465: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1466: Fnd_Message.set_name('AMS', 'AMS_APPR_NO_START_DATE');

Line 1479: Ams_Utility_Pvt.debug_message('Approver start date cannot be less than the system date');

1475: IF(p_start_date < trunc(SYSDATE)) THEN
1476: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1477: IF (AMS_DEBUG_HIGH_ON) THEN
1478:
1479: Ams_Utility_Pvt.debug_message('Approver start date cannot be less than the system date');
1480: END IF;
1481:
1482: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1483: Fnd_Message.set_name('AMS', 'AMS_APPR_START_DATE_LT_SYSDATE');

Line 1493: Ams_Utility_Pvt.debug_message('Approver Start Date cannot be less than the Approval Rule Start Date');

1489: ELSIF ( p_start_date < l_start_date ) THEN
1490: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1491: IF (AMS_DEBUG_HIGH_ON) THEN
1492:
1493: Ams_Utility_Pvt.debug_message('Approver Start Date cannot be less than the Approval Rule Start Date');
1494: END IF;
1495:
1496: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1497: Fnd_Message.set_name('AMS', 'AMS_APPR_STDT_GT_APRD_STDT');

Line 1511: Ams_Utility_Pvt.debug_message('Approver end date cannot be less than the system date');

1507: IF( p_end_date < trunc(SYSDATE)) THEN
1508: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1509: IF (AMS_DEBUG_HIGH_ON) THEN
1510:
1511: Ams_Utility_Pvt.debug_message('Approver end date cannot be less than the system date');
1512: END IF;
1513:
1514: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1515: Fnd_Message.set_name('AMS', 'AMS_APPR_END_DATE_LT_SYSDATE');

Line 1525: Ams_Utility_Pvt.debug_message('Approver end date cannot be greater than the Approval Rule end date');

1521: ELSIF (p_end_date > l_end_date) THEN
1522: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1523: IF (AMS_DEBUG_HIGH_ON) THEN
1524:
1525: Ams_Utility_Pvt.debug_message('Approver end date cannot be greater than the Approval Rule end date');
1526: END IF;
1527:
1528: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1529: Fnd_Message.set_name('AMS', 'AMS_APPR_EDDT_GT_APRD_EDDT');

Line 1581: Ams_Utility_Pvt.debug_message('Approver End Date cannot be specified without Start Date');

1577: IF (p_start_date IS NULL AND p_end_date IS NOT NULL) THEN
1578: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1579: IF (AMS_DEBUG_HIGH_ON) THEN
1580:
1581: Ams_Utility_Pvt.debug_message('Approver End Date cannot be specified without Start Date');
1582: END IF;
1583:
1584: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1585: Fnd_Message.set_name('AMS', 'AMS_APPR_NO_START_DATE');

Line 1600: Ams_Utility_Pvt.debug_message('Approver start date cannot be changed as it is already active');

1596: l_start_date_ar <> p_start_date) THEN -- Clause added for Bug 2285556
1597: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1598: IF (AMS_DEBUG_HIGH_ON) THEN
1599:
1600: Ams_Utility_Pvt.debug_message('Approver start date cannot be changed as it is already active');
1601: END IF;
1602:
1603: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1604: Fnd_Message.set_name('AMS', 'AMS_APPR_STDT_NO_CHANGE');

Line 1616: Ams_Utility_Pvt.debug_message('Approver start date cannot be less than the Approval Rule start date');

1612: ELSIF ( p_start_date < l_start_date ) THEN
1613: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1614: IF (AMS_DEBUG_HIGH_ON) THEN
1615:
1616: Ams_Utility_Pvt.debug_message('Approver start date cannot be less than the Approval Rule start date');
1617: END IF;
1618:
1619: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1620: Fnd_Message.set_name('AMS', 'AMS_APPR_STDT_LT_APRD_STDT');

Line 1636: Ams_Utility_Pvt.debug_message('Approver end date cannot be less than the system date');

1632: p_end_date <> l_end_date_ar) THEN -- Clause Added for Bug 2285556
1633: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1634: IF (AMS_DEBUG_HIGH_ON) THEN
1635:
1636: Ams_Utility_Pvt.debug_message('Approver end date cannot be less than the system date');
1637: END IF;
1638:
1639: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1640: Fnd_Message.set_name('AMS', 'AMS_APPR_END_DATE_LT_SYSDATE');

Line 1652: Ams_Utility_Pvt.debug_message('Approver end date cannot be greater than the Approval Rule end date');

1648: ELSIF (p_end_date > l_end_date) THEN
1649: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1650: IF (AMS_DEBUG_HIGH_ON) THEN
1651:
1652: Ams_Utility_Pvt.debug_message('Approver end date cannot be greater than the Approval Rule end date');
1653: END IF;
1654:
1655: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1656: Fnd_Message.set_name('AMS', 'AMS_APPR_EDDT_GT_APRD_EDDT');

Line 1669: Ams_Utility_Pvt.debug_message('Approver end date cannot be open as the end date for Approval Rule is Closed');

1665: ELSIF(l_end_date IS NOT NULL) THEN
1666: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1667: IF (AMS_DEBUG_HIGH_ON) THEN
1668:
1669: Ams_Utility_Pvt.debug_message('Approver end date cannot be open as the end date for Approval Rule is Closed');
1670: END IF;
1671:
1672: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1673: Fnd_Message.set_name('AMS', 'AMS_APPR_EDDT_OPEN');

Line 1726: Ams_Utility_Pvt.debug_message('Invalid Use of Function for this objects Approval');

1722: AND l_proc_name = 'GET_OBJECT_OWNER' THEN
1723:
1724: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1725: IF (AMS_DEBUG_HIGH_ON) THEN
1726: Ams_Utility_Pvt.debug_message('Invalid Use of Function for this objects Approval');
1727: END IF;
1728:
1729: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1730: Fnd_Message.set_name('AMS', 'AMS_APPR_FUNC_INVALID');

Line 1744: Ams_Utility_Pvt.debug_message('Invalid Use of Function for this objects Approval');

1740: AND l_proc_name = 'GET_PARENT_OBJECT_OWNER' THEN
1741:
1742: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1743: IF (AMS_DEBUG_HIGH_ON) THEN
1744: Ams_Utility_Pvt.debug_message('Invalid Use of Function for this objects Approval');
1745: END IF;
1746:
1747: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1748: Fnd_Message.set_name('AMS', 'AMS_APPR_FUNC_INVALID');

Line 1765: Ams_Utility_Pvt.debug_message('Invalid Use of Function for this objects Approval as SFP is NO');

1761: Fnd_Message.Set_Name('AMS','AMS_APPR_FUNC_INVALID');
1762: Fnd_Msg_Pub.ADD;
1763: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1764: IF (AMS_DEBUG_HIGH_ON) THEN
1765: Ams_Utility_Pvt.debug_message('Invalid Use of Function for this objects Approval as SFP is NO');
1766: END IF;
1767: RETURN;
1768: END IF;
1769:

Line 1778: Ams_Utility_Pvt.debug_message('Invalid Use of Function for this objects Approval');

1774: AND l_proc_name = 'GET_BUDGET_OWNER' THEN
1775:
1776: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1777: IF (AMS_DEBUG_HIGH_ON) THEN
1778: Ams_Utility_Pvt.debug_message('Invalid Use of Function for this objects Approval');
1779: END IF;
1780:
1781: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1782: Fnd_Message.set_name('AMS', 'AMS_APPR_FUNC_INVALID');

Line 1796: Ams_Utility_Pvt.debug_message('Invalid Use of Function for this objects Approval');

1792: AND l_proc_name = 'GET_PARENT_BUDGET_OWNER' THEN
1793:
1794: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1795: IF (AMS_DEBUG_HIGH_ON) THEN
1796: Ams_Utility_Pvt.debug_message('Invalid Use of Function for this objects Approval');
1797: END IF;
1798:
1799: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1800: Fnd_Message.set_name('AMS', 'AMS_APPR_FUNC_INVALID');