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_CATEGORY_PVT dependencies on AMS_UTILITY_PVT

Line 112: AMS_Utility_PVT.debug_message(l_full_name||': start');

108: -- Standard Start of API savepoint
109: SAVEPOINT Create_Category_PVT;
110: IF (AMS_DEBUG_HIGH_ON) THEN
111:
112: AMS_Utility_PVT.debug_message(l_full_name||': start');
113: END IF;
114:
115: -- Standard call to check for call compatibility.
116: IF NOT FND_API.Compatible_API_Call ( l_api_version,

Line 137: AMS_Utility_PVT.debug_message(l_full_name ||': validate');

133:
134: ----------------------- validate -----------------------
135: IF (AMS_DEBUG_HIGH_ON) THEN
136:
137: AMS_Utility_PVT.debug_message(l_full_name ||': validate');
138: END IF;
139:
140: Validate_Category
141: ( p_api_version => 1.0

Line 163: AMS_Utility_PVT.debug_message(l_full_name ||': insert');

159: END IF;
160: -------------------------- insert --------------------------
161: IF (AMS_DEBUG_HIGH_ON) THEN
162:
163: AMS_Utility_PVT.debug_message(l_full_name ||': insert');
164: END IF;
165:
166: -- Set the value for the PK.
167:

Line 320: AMS_Utility_PVT.debug_message(l_full_name ||': end');

316: IF (AMS_DEBUG_HIGH_ON) THEN
317:
318:
319:
320: AMS_Utility_PVT.debug_message(l_full_name ||': end');
321:
322: END IF;
323:
324: EXCEPTION

Line 413: --IF (AMS_DEBUG_HIGH_ON) THENAMS_Utility_PVT.debug_message(l_full_name||': start');END IF;

409: BEGIN
410:
411: -- Standard Start of API savepoint
412: SAVEPOINT Update_Category_PVT;
413: --IF (AMS_DEBUG_HIGH_ON) THENAMS_Utility_PVT.debug_message(l_full_name||': start');END IF;
414:
415: -- Standard call to check for call compatibility.
416: IF NOT FND_API.Compatible_API_Call ( l_api_version,
417: p_api_version,

Line 434: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_Utility_PVT.debug_message(l_full_name ||': validate'); END IF;

430: -- Initialize API return status to success
431: x_return_status := FND_API.G_RET_STS_SUCCESS;
432:
433: ----------------------- validate ----------------------
434: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_Utility_PVT.debug_message(l_full_name ||': validate'); END IF;
435:
436: -- replace g_miss_char/num/date with current column values
437: complete_category_rec(p_category_rec, l_category_rec);
438:

Line 484: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_Utility_PVT.debug_message(l_full_name ||': update before SEED Data Check'); END IF;

480: ------------- code added by abhola END ------------------------------------------
481:
482:
483: -------------------------- update --------------------
484: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_Utility_PVT.debug_message(l_full_name ||': update before SEED Data Check'); END IF;
485:
486: -- seeded category if category_id < 10000
487: -- and created_by = 0 or 1 -- Bug 4064984
488: -- user cannot modify or delete seeded category

Line 593: --IF (AMS_DEBUG_HIGH_ON) THENAMS_Utility_PVT.debug_message(l_full_name ||': After update');END IF;

589: END IF;
590:
591: -------------------- finish --------------------------
592:
593: --IF (AMS_DEBUG_HIGH_ON) THENAMS_Utility_PVT.debug_message(l_full_name ||': After update');END IF;
594: -- Standard check of p_commit.
595: IF FND_API.To_Boolean ( p_commit )
596: THEN
597: COMMIT WORK;

Line 608: AMS_Utility_PVT.debug_message(l_full_name ||': end');

604: p_encoded => FND_API.G_FALSE
605: );
606: IF (AMS_DEBUG_HIGH_ON) THEN
607:
608: AMS_Utility_PVT.debug_message(l_full_name ||': end');
609: END IF;
610:
611: EXCEPTION
612:

Line 698: AMS_Utility_PVT.debug_message(l_full_name||': start');

694: -- Standard Start of API savepoint
695: SAVEPOINT Delete_Category_PVT;
696: IF (AMS_DEBUG_HIGH_ON) THEN
697:
698: AMS_Utility_PVT.debug_message(l_full_name||': start');
699: END IF;
700:
701: -- Standard call to check for call compatibility.
702: IF NOT FND_API.Compatible_API_Call ( l_api_version,

Line 722: AMS_Utility_PVT.debug_message(l_full_name ||': delete');

718:
719: ------------------------ delete ------------------------
720: IF (AMS_DEBUG_HIGH_ON) THEN
721:
722: AMS_Utility_PVT.debug_message(l_full_name ||': delete');
723: END IF;
724:
725: -- Perform the database operation
726:

Line 798: AMS_Utility_PVT.debug_message(l_full_name ||': end');

794: p_encoded => FND_API.G_FALSE
795: );
796: IF (AMS_DEBUG_HIGH_ON) THEN
797:
798: AMS_Utility_PVT.debug_message(l_full_name ||': end');
799: END IF;
800:
801: EXCEPTION
802:

Line 900: AMS_Utility_PVT.debug_message(l_full_name||': start');

896:
897: BEGIN
898: IF (AMS_DEBUG_HIGH_ON) THEN
899:
900: AMS_Utility_PVT.debug_message(l_full_name||': start');
901: END IF;
902: -- Standard call to check for call compatibility.
903: IF NOT FND_API.Compatible_API_Call ( l_api_version,
904: p_api_version,

Line 921: AMS_Utility_PVT.debug_message(l_full_name||': lock');

917:
918: ------------------------ lock -------------------------
919: IF (AMS_DEBUG_HIGH_ON) THEN
920:
921: AMS_Utility_PVT.debug_message(l_full_name||': lock');
922: END IF;
923:
924: -- Perform the database operation
925: OPEN C_ams_categories_b;

Line 952: AMS_Utility_PVT.debug_message(l_full_name ||': end');

948: p_encoded => FND_API.G_FALSE
949: );
950: IF (AMS_DEBUG_HIGH_ON) THEN
951:
952: AMS_Utility_PVT.debug_message(l_full_name ||': end');
953: END IF;
954:
955: EXCEPTION
956:

Line 977: WHEN AMS_Utility_PVT.RESOURCE_LOCKED

973: p_data => x_msg_data,
974: p_encoded => FND_API.G_FALSE
975: );
976:
977: WHEN AMS_Utility_PVT.RESOURCE_LOCKED
978: THEN
979: x_return_status := FND_API.G_RET_STS_ERROR ;
980:
981: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 1049: AMS_Utility_PVT.debug_message(l_full_name||': start');

1045: BEGIN
1046: ----------------------- initialize --------------------
1047: IF (AMS_DEBUG_HIGH_ON) THEN
1048:
1049: AMS_Utility_PVT.debug_message(l_full_name||': start');
1050: END IF;
1051:
1052: -- Standard call to check for call compatibility.
1053: IF NOT FND_API.Compatible_API_Call ( l_api_version,

Line 1128: AMS_UTILITY_PVT.debug_message('the return status after Validate_Category_Cross_Rec :'||x_return_status);

1124: IF (AMS_DEBUG_HIGH_ON) THEN
1125:
1126:
1127:
1128: AMS_UTILITY_PVT.debug_message('the return status after Validate_Category_Cross_Rec :'||x_return_status);
1129:
1130: END IF;
1131: END IF;
1132:

Line 1277: IF AMS_Utility_PVT.Check_FK_Exists (

1273: l_table_name := 'AMS_CATEGORIES_B';
1274: l_pk_name := 'CATEGORY_ID';
1275: l_pk_value := p_category_rec.PARENT_CATEGORY_ID;
1276:
1277: IF AMS_Utility_PVT.Check_FK_Exists (
1278: p_table_name => l_table_name
1279: ,p_pk_name => l_pk_name
1280: ,p_pk_value => l_pk_value
1281: ,p_additional_where_clause => l_additional_where_clause -- Bug 3847393 in 11.5.10.1R

Line 1297: AMS_UTILITY_PVT.debug_message('the return status after primary check :'||x_return_status);

1293: END IF; -- check_fk_exists
1294: END IF;
1295: IF (AMS_DEBUG_HIGH_ON) THEN
1296:
1297: AMS_UTILITY_PVT.debug_message('the return status after primary check :'||x_return_status);
1298: END IF;
1299:
1300: IF p_category_rec.enabled_flag <> FND_API.g_miss_char
1301: AND p_category_rec.enabled_flag IS NOT NULL

Line 1303: IF AMS_Utility_PVT.is_Y_or_N(p_category_rec.enabled_flag) = FND_API.g_false

1299:
1300: IF p_category_rec.enabled_flag <> FND_API.g_miss_char
1301: AND p_category_rec.enabled_flag IS NOT NULL
1302: THEN
1303: IF AMS_Utility_PVT.is_Y_or_N(p_category_rec.enabled_flag) = FND_API.g_false
1304: THEN
1305: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1306: THEN
1307: FND_MESSAGE.set_name('AMS', 'AMS_CAT_BAD_ENABLED_FLAG');

Line 1316: AMS_UTILITY_PVT.debug_message('the return status after enabled flag :'||x_return_status);

1312: END IF;
1313: END IF;
1314: IF (AMS_DEBUG_HIGH_ON) THEN
1315:
1316: AMS_UTILITY_PVT.debug_message('the return status after enabled flag :'||x_return_status);
1317: END IF;
1318:
1319: END Validate_Cty_Items;
1320:

Line 1400: (AMS_Utility_PVT.Check_FK_Exists

1396: p_category_rec.PARENT_CATEGORY_ID is NOT NULL AND
1397: p_category_rec.ENABLED_FLAG = 'N' ) THEN
1398:
1399: IF
1400: (AMS_Utility_PVT.Check_FK_Exists
1401: ( p_table_name => 'AMS_DELIVERABLES_ALL_B'
1402: ,p_pk_name => 'CATEGORY_TYPE_ID'
1403: ,p_pk_value => p_category_rec.PARENT_CATEGORY_ID
1404: ) = FND_API.G_TRUE )

Line 1408: (AMS_Utility_PVT.Check_FK_Exists

1404: ) = FND_API.G_TRUE )
1405:
1406: OR
1407:
1408: (AMS_Utility_PVT.Check_FK_Exists
1409: ( p_table_name => 'AMS_ACT_CATEGORIES'
1410: ,p_pk_name => 'CATEGORY_ID'
1411: ,p_pk_value => p_category_rec.PARENT_CATEGORY_ID
1412: ) = FND_API.G_TRUE )

Line 1416: (AMS_Utility_PVT.Check_FK_Exists

1412: ) = FND_API.G_TRUE )
1413:
1414: OR
1415:
1416: (AMS_Utility_PVT.Check_FK_Exists
1417: ( p_table_name => 'AMS_METRICS_ALL_B'
1418: ,p_pk_name => 'METRIC_CATEGORY'
1419: ,p_pk_value => p_category_rec.PARENT_CATEGORY_ID
1420: ) = FND_API.G_TRUE )

Line 1424: (AMS_Utility_PVT.Check_FK_Exists

1420: ) = FND_API.G_TRUE )
1421:
1422: OR
1423:
1424: (AMS_Utility_PVT.Check_FK_Exists
1425: ( p_table_name => 'OZF_FUNDS_ALL_B'
1426: ,p_pk_name => 'CATEGORY_ID'
1427: ,p_pk_value => p_category_rec.PARENT_CATEGORY_ID
1428: ) = FND_API.G_TRUE )

Line 1592: if AMS_Utility_PVT.Check_Uniqueness

1588: IF p_category_rec.category_id IS NULL
1589: THEN
1590:
1591: /* bug 1490374
1592: if AMS_Utility_PVT.Check_Uniqueness
1593: (p_table_name => 'AMS_CATEGORIES_TL',
1594: p_where_clause => 'category_name = '
1595: || ''''
1596: || p_category_rec.category_name

Line 1624: if AMS_Utility_PVT.Check_Uniqueness

1620:
1621: -- Update mode
1622: ELSE
1623: /* bug # 1490374
1624: if AMS_Utility_PVT.Check_Uniqueness
1625: (p_table_name => 'AMS_CATEGORIES_TL',
1626: p_where_clause => 'category_name = '
1627: || ''''
1628: || p_category_rec.category_name

Line 1719: IF AMS_Utility_PVT.Check_FK_Exists

1715: -- Initialize API/Procedure return status to success
1716: x_return_status := FND_API.G_RET_STS_SUCCESS;
1717: l_pk_value := l_category_id;
1718:
1719: IF AMS_Utility_PVT.Check_FK_Exists
1720: ( p_table_name => 'AMS_CATEGORIES_B'
1721: ,p_pk_name => 'PARENT_CATEGORY_ID'
1722: ,p_pk_value => l_pk_value
1723: ) = FND_API.G_TRUE

Line 1735: IF AMS_Utility_PVT.Check_FK_Exists

1731: x_return_status := FND_API.g_ret_sts_error;
1732: RETURN;
1733: END IF;
1734:
1735: IF AMS_Utility_PVT.Check_FK_Exists
1736: ( p_table_name => 'AMS_ACT_CATEGORIES'
1737: ,p_pk_name => 'CATEGORY_ID'
1738: ,p_pk_value => l_pk_value
1739: ) = FND_API.G_TRUE

Line 1752: IF AMS_Utility_PVT.Check_FK_Exists

1748: RETURN;
1749: END IF;
1750:
1751:
1752: IF AMS_Utility_PVT.Check_FK_Exists
1753: ( p_table_name => 'AMS_METRICS_ALL_B'
1754: ,p_pk_name => 'METRIC_CATEGORY'
1755: ,p_pk_value => l_pk_value
1756: ) = FND_API.G_TRUE

Line 1768: IF AMS_Utility_PVT.Check_FK_Exists

1764: x_return_status := FND_API.g_ret_sts_error;
1765: RETURN;
1766: END IF;
1767:
1768: IF AMS_Utility_PVT.Check_FK_Exists
1769: ( p_table_name => 'AMS_METRICS_ALL_B'
1770: ,p_pk_name => 'METRIC_SUB_CATEGORY'
1771: ,p_pk_value => l_pk_value
1772: ) = FND_API.G_TRUE

Line 1787: IF AMS_Utility_PVT.Check_FK_Exists

1783: /********
1784: --commented by musman for bug fix # 1966294
1785: -- this AMS_DELIV_OFFERINGS_B table doesn't exists.
1786:
1787: IF AMS_Utility_PVT.Check_FK_Exists
1788: ( p_table_name => 'AMS_DELIV_OFFERINGS_B'
1789: ,p_pk_name => 'CATEGORY_TYPE_ID'
1790: ,p_pk_value => l_pk_value
1791: ) = FND_API.G_TRUE

Line 1813: AMS_UTILITY_PVT.debug_message(' checking the AMS_DELIVERABLES_ALL_B for cat ');

1809:
1810:
1811:
1812:
1813: AMS_UTILITY_PVT.debug_message(' checking the AMS_DELIVERABLES_ALL_B for cat ');
1814:
1815:
1816: END IF;
1817:

Line 1818: IF AMS_Utility_PVT.Check_FK_Exists

1814:
1815:
1816: END IF;
1817:
1818: IF AMS_Utility_PVT.Check_FK_Exists
1819: ( p_table_name => 'AMS_DELIVERABLES_ALL_B'
1820: ,p_pk_name => 'CATEGORY_TYPE_ID'
1821: ,p_pk_value => l_pk_value
1822: ) = FND_API.G_TRUE

Line 1837: AMS_UTILITY_PVT.debug_message(' checking the AMS_DELIVERABLES_ALL_B for sub cat ');

1833:
1834: /* added by musman fix for 1794454 */
1835: IF (AMS_DEBUG_HIGH_ON) THEN
1836:
1837: AMS_UTILITY_PVT.debug_message(' checking the AMS_DELIVERABLES_ALL_B for sub cat ');
1838: END IF;
1839: IF AMS_Utility_PVT.Check_FK_Exists
1840: ( p_table_name => 'AMS_DELIVERABLES_ALL_B'
1841: ,p_pk_name => 'CATEGORY_SUB_TYPE_ID'

Line 1839: IF AMS_Utility_PVT.Check_FK_Exists

1835: IF (AMS_DEBUG_HIGH_ON) THEN
1836:
1837: AMS_UTILITY_PVT.debug_message(' checking the AMS_DELIVERABLES_ALL_B for sub cat ');
1838: END IF;
1839: IF AMS_Utility_PVT.Check_FK_Exists
1840: ( p_table_name => 'AMS_DELIVERABLES_ALL_B'
1841: ,p_pk_name => 'CATEGORY_SUB_TYPE_ID'
1842: ,p_pk_value => l_pk_value
1843: ) = FND_API.G_TRUE

Line 1862: AMS_UTILITY_PVT.debug_message(' checking the ozf_funds_all_b for cat ');

1858:
1859:
1860:
1861:
1862: AMS_UTILITY_PVT.debug_message(' checking the ozf_funds_all_b for cat ');
1863:
1864:
1865: END IF;
1866: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1868: AMS_UTILITY_PVT.debug_message(' the val of AMS_Utility_PVT.Check_FK_Exists : '||AMS_Utility_PVT.Check_FK_Exists

1864:
1865: END IF;
1866: IF (AMS_DEBUG_HIGH_ON) THEN
1867:
1868: AMS_UTILITY_PVT.debug_message(' the val of AMS_Utility_PVT.Check_FK_Exists : '||AMS_Utility_PVT.Check_FK_Exists
1869: ( p_table_name => 'OZF_FUNDS_ALL_B'
1870: ,p_pk_name => 'CATEGORY_ID'
1871: ,p_pk_value => l_pk_value
1872: ));

Line 1874: IF AMS_Utility_PVT.Check_FK_Exists

1870: ,p_pk_name => 'CATEGORY_ID'
1871: ,p_pk_value => l_pk_value
1872: ));
1873: END IF;
1874: IF AMS_Utility_PVT.Check_FK_Exists
1875: ( p_table_name => 'OZF_FUNDS_ALL_B'
1876: ,p_pk_name => 'CATEGORY_ID'
1877: ,p_pk_value => l_pk_value
1878: ) = FND_API.G_TRUE

Line 1893: IF AMS_Utility_PVT.Check_FK_Exists

1889: /******** end addition by abhola ***************/
1890:
1891: /****** commented by ABHOLA
1892:
1893: IF AMS_Utility_PVT.Check_FK_Exists
1894: ( p_table_name => 'AMS_DELIV_OFFERINGS_B'
1895: ,p_pk_name => 'CATEGORY_SUB_TYPE_ID'
1896: ,p_pk_value => l_pk_value
1897: ) = FND_API.G_TRUE