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_MC_ITEMGROUP_PVT dependencies on AHL_MC_ITEMGROUP_PVT

Line 1: PACKAGE BODY AHL_MC_ITEMGROUP_PVT AS

1: PACKAGE BODY AHL_MC_ITEMGROUP_PVT AS
2: /* $Header: AHLVIGPB.pls 120.10.12020000.2 2012/12/10 13:41:56 shnatu ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'Ahl_MC_ItemGroup_Pvt';
5: G_FND_1WAY_CODE CONSTANT VARCHAR2(30) := '1-WAY';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'Ahl_MC_ItemGroup_Pvt';

1: PACKAGE BODY AHL_MC_ITEMGROUP_PVT AS
2: /* $Header: AHLVIGPB.pls 120.10.12020000.2 2012/12/10 13:41:56 shnatu ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'Ahl_MC_ItemGroup_Pvt';
5: G_FND_1WAY_CODE CONSTANT VARCHAR2(30) := '1-WAY';
6:
7: -- Added by skpathak for bug-7437855 on 18-NOV-2008 - Define a package scope VARCHAR2 associative array.
8: TYPE G_ITEM_DTL_TYPE IS TABLE OF NUMBER INDEX BY VARCHAR2(100);

Line 871: p_item_assoc_rec IN OUT NOCOPY AHL_MC_ITEMGROUP_PVT.Item_Association_Rec_Type,

867: ----------------------------------
868: PROCEDURE Validate_Item_Assoc(p_item_group_id IN NUMBER := NULL,
869: p_name IN VARCHAR2,
870: p_type_code IN VARCHAR2,
871: p_item_assoc_rec IN OUT NOCOPY AHL_MC_ITEMGROUP_PVT.Item_Association_Rec_Type,
872: -- Changes by skpathak for bug-7437855 on 18-NOV-2008
873: -- Duplicate item association check is now done using G_ITEM_DTL_TYPE, instead of a string.
874: p_x_inventory_list IN OUT NOCOPY G_ITEM_DTL_TYPE,
875: x_row_id OUT NOCOPY UROWID) IS

Line 898: l_x_item_assoc_rec AHL_MC_ITEMGROUP_PVT.Item_Association_Rec_Type DEFAULT p_item_assoc_rec;

894: WHERE item_association_id = p_item_assoc_id;
895:
896: l_item_assoc_rec Item_assoc_csr%ROWTYPE;
897: l_inv_segment ahl_mtl_items_non_ou_v.concatenated_segments%TYPE;
898: l_x_item_assoc_rec AHL_MC_ITEMGROUP_PVT.Item_Association_Rec_Type DEFAULT p_item_assoc_rec;
899:
900: l_revision_qty_control_code NUMBER;
901: l_serial_number_control NUMBER;
902:

Line 951: 'ahl_mc_itemgroup_pvt.Validate_Item_Assoc', l_item_key);

947: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
948: THEN
949: l_item_key := 'Inventory Item Id '||to_char(l_x_item_assoc_rec.inventory_item_id)||' - '||to_Char(l_item_assoc_rec.inventory_item_id);
950: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
951: 'ahl_mc_itemgroup_pvt.Validate_Item_Assoc', l_item_key);
952: l_item_key := 'Inventory Org Id '||to_Char(l_x_item_assoc_rec.inventory_org_id)||' - '||to_char(l_item_assoc_rec.inventory_org_id);
953: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
954: 'ahl_mc_itemgroup_pvt.Validate_Item_Assoc', l_item_key);
955: END IF;

Line 954: 'ahl_mc_itemgroup_pvt.Validate_Item_Assoc', l_item_key);

950: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
951: 'ahl_mc_itemgroup_pvt.Validate_Item_Assoc', l_item_key);
952: l_item_key := 'Inventory Org Id '||to_Char(l_x_item_assoc_rec.inventory_org_id)||' - '||to_char(l_item_assoc_rec.inventory_org_id);
953: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
954: 'ahl_mc_itemgroup_pvt.Validate_Item_Assoc', l_item_key);
955: END IF;
956:
957: FND_MESSAGE.Set_Name('AHL','AHL_COM_KEY_NOUPDATE');
958: FND_MSG_PUB.ADD;

Line 1194: PROCEDURE Insert_Item_Group(p_x_item_grp_rec IN OUT NOCOPY AHL_MC_ITEMGROUP_PVT.Item_Group_Rec_Type) IS

1190:
1191: -------------------------------------
1192: -- Insert/Update/Delete procedures --
1193: -------------------------------------
1194: PROCEDURE Insert_Item_Group(p_x_item_grp_rec IN OUT NOCOPY AHL_MC_ITEMGROUP_PVT.Item_Group_Rec_Type) IS
1195:
1196: l_item_grp_id NUMBER;
1197: l_last_update_login NUMBER;
1198: l_last_updated_by NUMBER;

Line 1303: PROCEDURE Create_Association(p_item_assoc_rec IN OUT NOCOPY AHL_MC_ITEMGROUP_PVT.Item_Association_Rec_Type)

1299:
1300: END Insert_Item_Group;
1301:
1302: ---------------------------------
1303: PROCEDURE Create_Association(p_item_assoc_rec IN OUT NOCOPY AHL_MC_ITEMGROUP_PVT.Item_Association_Rec_Type)
1304: IS
1305:
1306: l_item_assoc_rec AHL_MC_ITEMGROUP_PVT.Item_Association_Rec_Type DEFAULT p_item_assoc_rec;
1307:

Line 1306: l_item_assoc_rec AHL_MC_ITEMGROUP_PVT.Item_Association_Rec_Type DEFAULT p_item_assoc_rec;

1302: ---------------------------------
1303: PROCEDURE Create_Association(p_item_assoc_rec IN OUT NOCOPY AHL_MC_ITEMGROUP_PVT.Item_Association_Rec_Type)
1304: IS
1305:
1306: l_item_assoc_rec AHL_MC_ITEMGROUP_PVT.Item_Association_Rec_Type DEFAULT p_item_assoc_rec;
1307:
1308: l_item_association_id NUMBER;
1309: l_row_id VARCHAR2(30);
1310: BEGIN

Line 1432: PROCEDURE Update_Association(p_item_assoc_rec IN AHL_MC_ITEMGROUP_PVT.Item_Association_Rec_Type,

1428:
1429: END Create_Association;
1430:
1431: ----------------------------
1432: PROCEDURE Update_Association(p_item_assoc_rec IN AHL_MC_ITEMGROUP_PVT.Item_Association_Rec_Type,
1433: p_row_id IN UROWID) IS
1434:
1435: CURSOR Item_assoc_csr(p_rowid UROWID) IS
1436: SELECT

Line 1478: l_item_assoc_rec AHL_MC_ITEMGROUP_PVT.Item_Association_Rec_Type DEFAULT p_item_assoc_rec;

1474: and b.rowid = p_rowid
1475: AND tl.LANGUAGE = USERENV('LANG')
1476: FOR UPDATE OF object_version_number NOWAIT;
1477:
1478: l_item_assoc_rec AHL_MC_ITEMGROUP_PVT.Item_Association_Rec_Type DEFAULT p_item_assoc_rec;
1479: l_old_item_assoc_rec Item_assoc_csr%ROWTYPE;
1480:
1481: BEGIN
1482:

Line 1680: PROCEDURE Delete_Association(p_item_assoc_rec IN AHL_MC_ITEMGROUP_PVT.Item_Association_Rec_Type,

1676:
1677: END Update_Association;
1678:
1679: -----------------------------
1680: PROCEDURE Delete_Association(p_item_assoc_rec IN AHL_MC_ITEMGROUP_PVT.Item_Association_Rec_Type,
1681: p_row_id IN UROWID) IS
1682:
1683: CURSOR Item_assoc_csr(p_row_id UROWID) IS
1684: SELECT

Line 1740: p_x_item_group_rec IN OUT NOCOPY AHL_MC_ITEMGROUP_PVT.Item_Group_Rec_Type,

1736: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1737: x_return_status OUT NOCOPY VARCHAR2,
1738: x_msg_count OUT NOCOPY NUMBER,
1739: x_msg_data OUT NOCOPY VARCHAR2,
1740: p_x_item_group_rec IN OUT NOCOPY AHL_MC_ITEMGROUP_PVT.Item_Group_Rec_Type,
1741: p_x_items_tbl IN OUT NOCOPY AHL_MC_ITEMGROUP_PVT.Item_Association_Tbl_Type
1742: ) IS
1743:
1744: l_api_name CONSTANT VARCHAR2(30) := 'Create_Item_Group';

Line 1741: p_x_items_tbl IN OUT NOCOPY AHL_MC_ITEMGROUP_PVT.Item_Association_Tbl_Type

1737: x_return_status OUT NOCOPY VARCHAR2,
1738: x_msg_count OUT NOCOPY NUMBER,
1739: x_msg_data OUT NOCOPY VARCHAR2,
1740: p_x_item_group_rec IN OUT NOCOPY AHL_MC_ITEMGROUP_PVT.Item_Group_Rec_Type,
1741: p_x_items_tbl IN OUT NOCOPY AHL_MC_ITEMGROUP_PVT.Item_Association_Tbl_Type
1742: ) IS
1743:
1744: l_api_name CONSTANT VARCHAR2(30) := 'Create_Item_Group';
1745: l_api_version CONSTANT NUMBER := 1.0;

Line 1778: 'ahl.plsql.ahl_mc_itemgroup_pvt.create_item_group', 'Inside Create_Item_group');

1774:
1775: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1776: THEN
1777: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1778: 'ahl.plsql.ahl_mc_itemgroup_pvt.create_item_group', 'Inside Create_Item_group');
1779: END IF;
1780:
1781: --dbms_output.put_line('Inside Create_Item_group');
1782:

Line 1801: 'ahl.plsql.ahl_mc_itemgroup_pvt.create_item_group', 'Before validating Item Group Associations');

1797: FOR i IN p_x_items_tbl.FIRST..p_x_items_tbl.LAST LOOP
1798: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1799: THEN
1800: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1801: 'ahl.plsql.ahl_mc_itemgroup_pvt.create_item_group', 'Before validating Item Group Associations');
1802: END IF;
1803:
1804: Validate_Item_Assoc(p_name => p_x_item_group_rec.name,
1805: p_type_code => p_x_item_group_rec.type_code,

Line 1816: 'ahl.plsql.ahl_mc_itemgroup_pvt.create_item_group', 'After validating Item Group Associations');

1812:
1813: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1814: THEN
1815: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1816: 'ahl.plsql.ahl_mc_itemgroup_pvt.create_item_group', 'After validating Item Group Associations');
1817: END IF;
1818:
1819:
1820: -- Check Error Message stack.

Line 1829: 'ahl.plsql.ahl_mc_itemgroup_pvt.create_item_group', 'Before calling Insert_Item_group');

1825:
1826: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1827: THEN
1828: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1829: 'ahl.plsql.ahl_mc_itemgroup_pvt.create_item_group', 'Before calling Insert_Item_group');
1830: END IF;
1831:
1832: -- Insert into ahl_item_groups_b and TL.
1833: Insert_Item_group(p_x_item_group_rec);

Line 1838: 'ahl.plsql.ahl_mc_itemgroup_pvt.create_item_group', 'After calling Insert_Item_group');

1834:
1835: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1836: THEN
1837: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1838: 'ahl.plsql.ahl_mc_itemgroup_pvt.create_item_group', 'After calling Insert_Item_group');
1839: END IF;
1840:
1841:
1842: l_item_group_id := p_x_item_group_rec.item_group_id;

Line 1847: 'ahl.plsql.ahl_mc_itemgroup_pvt.create_item_group', 'Before loop of Item Association');

1843:
1844: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1845: THEN
1846: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1847: 'ahl.plsql.ahl_mc_itemgroup_pvt.create_item_group', 'Before loop of Item Association');
1848: END IF;
1849:
1850:
1851: -- Insert into ahl_item_associations_b/_tl.

Line 1862: 'ahl.plsql.ahl_mc_itemgroup_pvt.create_item_group', 'After loop of Item Association');

1858:
1859: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1860: THEN
1861: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1862: 'ahl.plsql.ahl_mc_itemgroup_pvt.create_item_group', 'After loop of Item Association');
1863: END IF;
1864:
1865: validate_priority(l_item_group_id);
1866:

Line 1870: 'ahl.plsql.ahl_mc_itemgroup_pvt.create_item_group', 'End of create_item_group private');

1866:
1867: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1868: THEN
1869: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1870: 'ahl.plsql.ahl_mc_itemgroup_pvt.create_item_group', 'End of create_item_group private');
1871: END IF;
1872:
1873:
1874: -- Standard call to get message count and if count is 1, get message info

Line 1890: 'ahl.plsql.ahl_mc_itemgroup_pvt.create_item_group', 'Error in create_item_group private');

1886: p_encoded => fnd_api.g_false);
1887: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1888: THEN
1889: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1890: 'ahl.plsql.ahl_mc_itemgroup_pvt.create_item_group', 'Error in create_item_group private');
1891: END IF;
1892:
1893:
1894:

Line 1905: 'ahl.plsql.ahl_mc_itemgroup_pvt.create_item_group', 'Unexpected error in create_item_group private');

1901: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
1902: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1903: THEN
1904: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1905: 'ahl.plsql.ahl_mc_itemgroup_pvt.create_item_group', 'Unexpected error in create_item_group private');
1906: END IF;
1907:
1908:
1909: WHEN OTHERS THEN

Line 1925: 'ahl.plsql.ahl_mc_itemgroup_pvt.create_item_group', 'Unknown error in create_item_group private');

1921:
1922: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1923: THEN
1924: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1925: 'ahl.plsql.ahl_mc_itemgroup_pvt.create_item_group', 'Unknown error in create_item_group private');
1926: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1927: 'ahl.plsql.ahl_mc_itemgroup_pvt.create_item_group', SQLERRM);
1928: END IF;
1929:

Line 1927: 'ahl.plsql.ahl_mc_itemgroup_pvt.create_item_group', SQLERRM);

1923: THEN
1924: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1925: 'ahl.plsql.ahl_mc_itemgroup_pvt.create_item_group', 'Unknown error in create_item_group private');
1926: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1927: 'ahl.plsql.ahl_mc_itemgroup_pvt.create_item_group', SQLERRM);
1928: END IF;
1929:
1930: END Create_Item_group;
1931:

Line 1947: p_item_group_rec IN AHL_MC_ITEMGROUP_PVT.Item_Group_Rec_Type,

1943: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1944: x_return_status OUT NOCOPY VARCHAR2,
1945: x_msg_count OUT NOCOPY NUMBER,
1946: x_msg_data OUT NOCOPY VARCHAR2,
1947: p_item_group_rec IN AHL_MC_ITEMGROUP_PVT.Item_Group_Rec_Type,
1948: p_x_items_tbl IN OUT NOCOPY AHL_MC_ITEMGROUP_PVT.Item_Association_Tbl_Type
1949: ) IS
1950:
1951: l_api_name CONSTANT VARCHAR2(30) := 'Modify_Item_Group';

Line 1948: p_x_items_tbl IN OUT NOCOPY AHL_MC_ITEMGROUP_PVT.Item_Association_Tbl_Type

1944: x_return_status OUT NOCOPY VARCHAR2,
1945: x_msg_count OUT NOCOPY NUMBER,
1946: x_msg_data OUT NOCOPY VARCHAR2,
1947: p_item_group_rec IN AHL_MC_ITEMGROUP_PVT.Item_Group_Rec_Type,
1948: p_x_items_tbl IN OUT NOCOPY AHL_MC_ITEMGROUP_PVT.Item_Association_Tbl_Type
1949: ) IS
1950:
1951: l_api_name CONSTANT VARCHAR2(30) := 'Modify_Item_Group';
1952: l_api_version CONSTANT NUMBER := 1.0;

Line 1998: l_item_group_rec AHL_MC_ITEMGROUP_PVT.Item_group_rec_Type DEFAULT p_item_group_rec;

1994: AND tl.LANGUAGE = USERENV('LANG')
1995: FOR UPDATE OF b.OBJECT_VERSION_NUMBER NOWAIT;
1996:
1997: l_old_item_group_rec Item_group_csr%ROWTYPE;
1998: l_item_group_rec AHL_MC_ITEMGROUP_PVT.Item_group_rec_Type DEFAULT p_item_group_rec;
1999:
2000: TYPE l_rowid_tbl_type IS TABLE OF UROWID INDEX BY BINARY_INTEGER;
2001: -- Build table with Rowid for Item Associations.
2002:

Line 2036: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'Begin of Modify_Item_group');

2032: x_return_status := FND_API.G_RET_STS_SUCCESS;
2033:
2034: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2035: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2036: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'Begin of Modify_Item_group');
2037: END IF;
2038:
2039: -- Validate Item Group record.
2040: OPEN Item_group_csr(p_item_group_rec.item_group_id);

Line 2119: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'Loop to validate Item Association');

2115: END IF;
2116:
2117: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2118: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2119: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'Loop to validate Item Association');
2120: END IF;
2121:
2122: -- Validate Item Assoc records.
2123: IF (p_x_items_tbl.COUNT > 0 ) THEN

Line 2152: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'End of Loop');

2148: END IF; /* count > 0 */
2149:
2150: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2151: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2152: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'End of Loop');
2153: END IF;
2154:
2155: -- Check Error Message stack.
2156: x_msg_count := FND_MSG_PUB.count_msg;

Line 2275: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'Before calling Item Group Table Handler');

2271: */
2272:
2273: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2274: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2275: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'Before calling Item Group Table Handler');
2276: END IF;
2277:
2278: AHL_ITEM_GROUPS_PKG.UPDATE_ROW(
2279: X_ITEM_GROUP_ID => l_old_item_group_rec.item_group_id,

Line 2308: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'After Table Handler');

2304: X_LAST_UPDATE_LOGIN => fnd_global.LOGIN_ID);
2305:
2306: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2307: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2308: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'After Table Handler');
2309: END IF;
2310:
2311:
2312: END IF; /* update only if operation_flag set */

Line 2371: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'Item Association Loop');

2367: END IF; -- end of l_old_item_group_rec.source_item_group_id IS NOT NULL
2368:
2369: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2370: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2371: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'Item Association Loop');
2372: END IF;
2373:
2374: -- Process Item Associations table.
2375: -- Priyan . Changed the order of the DML flag checks made for item group associations.

Line 2395: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'End of Loop');

2391: END IF;
2392:
2393: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2394: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2395: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'End of Loop');
2396: END IF;
2397:
2398: -- The validation of the revision update will be done only for revisions
2399: IF l_old_item_group_rec.source_item_group_id IS NOT NULL THEN

Line 2444: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group',

2440: p_encoded => fnd_api.g_false);
2441:
2442: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2443: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2444: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group',
2445: 'End of Modify_Item_group...x_return_status => '||x_return_status);
2446: END IF;
2447:
2448:

Line 2460: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'Error in Modify_Item_group');

2456: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
2457:
2458: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2459: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2460: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'Error in Modify_Item_group');
2461: END IF;
2462:
2463:
2464: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2473: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'Unexpected error in Modify_Item_group');

2469: p_encoded => fnd_api.g_false);
2470: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
2471: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2472: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2473: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'Unexpected error in Modify_Item_group');
2474: END IF;
2475:
2476:
2477: WHEN OTHERS THEN

Line 2492: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'Unknown Error in Modify_Item_group');

2488: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
2489:
2490: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2491: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2492: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'Unknown Error in Modify_Item_group');
2493: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2494: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', SQLERRM);
2495: END IF;
2496:

Line 2494: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', SQLERRM);

2490: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2491: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2492: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'Unknown Error in Modify_Item_group');
2493: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2494: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', SQLERRM);
2495: END IF;
2496:
2497:
2498: END Modify_Item_group;

Line 2514: p_item_group_rec IN AHL_MC_ITEMGROUP_PVT.Item_Group_Rec_Type

2510: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2511: x_return_status OUT NOCOPY VARCHAR2,
2512: x_msg_count OUT NOCOPY NUMBER,
2513: x_msg_data OUT NOCOPY VARCHAR2,
2514: p_item_group_rec IN AHL_MC_ITEMGROUP_PVT.Item_Group_Rec_Type
2515: ) IS
2516:
2517: l_api_name CONSTANT VARCHAR2(30) := 'Remove_Item_Group';
2518: l_api_version CONSTANT NUMBER := 1.0;

Line 2588: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'Begin of Remove_Item_group');

2584:
2585: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2586: THEN
2587: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2588: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'Begin of Remove_Item_group');
2589: END IF;
2590:
2591:
2592: -- Validate Item Group record.

Line 2677: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'Deleting Item Group');

2673:
2674: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2675: THEN
2676: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2677: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'Deleting Item Group');
2678: END IF;
2679:
2680: DELETE AHL_ITEM_ASSOCIATIONS_TL
2681: WHERE item_association_id IN ( SELECT item_association_id

Line 2699: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'Updating Item Group to Removed');

2695:
2696: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2697: THEN
2698: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2699: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'Updating Item Group to Removed');
2700: END IF;
2701:
2702: Update Ahl_Item_groups_b
2703: set status_code ='REMOVED',

Line 2725: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'End of Remove_Item_group');

2721:
2722: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2723: THEN
2724: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2725: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'End of Remove_Item_group');
2726: END IF;
2727:
2728:
2729:

Line 2741: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'Error in Remove_Item_group');

2737:
2738: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2739: THEN
2740: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2741: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'Error in Remove_Item_group');
2742: END IF;
2743:
2744: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2753: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'Unexpected error in Remove_Item_group');

2749: p_encoded => fnd_api.g_false);
2750: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2751: THEN
2752: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2753: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'Unexpected error in Remove_Item_group');
2754: END IF;
2755:
2756:
2757: WHEN OTHERS THEN

Line 2771: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'Unknown error in Remove_Item_group');

2767: p_encoded => fnd_api.g_false);
2768: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2769: THEN
2770: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2771: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'Unknown error in Remove_Item_group');
2772: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2773: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', SQLERRM);
2774: END IF;
2775:

Line 2773: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', SQLERRM);

2769: THEN
2770: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2771: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'Unknown error in Remove_Item_group');
2772: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2773: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', SQLERRM);
2774: END IF;
2775:
2776:
2777: END Remove_Item_group;

Line 2902: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Begin Initiate_Itemgroup_Appr');

2898:
2899: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2900: THEN
2901: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2902: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Begin Initiate_Itemgroup_Appr');
2903: END IF;
2904:
2905:
2906:

Line 3008: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'l_active flag is yes');

3004:
3005: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3006: THEN
3007: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3008: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'l_active flag is yes');
3009: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3010: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Updating Item group');
3011: END IF;
3012:

Line 3010: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Updating Item group');

3006: THEN
3007: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3008: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'l_active flag is yes');
3009: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3010: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Updating Item group');
3011: END IF;
3012:
3013: Update AHL_ITEM_GROUPS_B
3014: Set STATUS_CODE=l_upd_status,

Line 3033: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Calling ahl_generic_aprv_pvt.start_wf_process');

3029:
3030: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3031: THEN
3032: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3033: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Calling ahl_generic_aprv_pvt.start_wf_process');
3034: END IF;
3035:
3036: AHL_GENERIC_APRV_PVT.START_WF_PROCESS(
3037: P_OBJECT =>l_object,

Line 3053: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Calling ahl_mc_itemgroup_pvt.Approve_ItemGroups');

3049:
3050: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3051: THEN
3052: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3053: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Calling ahl_mc_itemgroup_pvt.Approve_ItemGroups');
3054: END IF;
3055:
3056: AHL_MC_ITEMGROUP_PVT.Approve_ItemGroups
3057: (

Line 3056: AHL_MC_ITEMGROUP_PVT.Approve_ItemGroups

3052: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3053: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Calling ahl_mc_itemgroup_pvt.Approve_ItemGroups');
3054: END IF;
3055:
3056: AHL_MC_ITEMGROUP_PVT.Approve_ItemGroups
3057: (
3058: p_api_version =>l_api_version,
3059: -- p_init_msg_list =>l_init_msg_list,
3060: -- p_commit =>l_commit,

Line 3097: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'End of Initiate_Itemgroup_Appr');

3093:
3094: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3095: THEN
3096: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3097: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'End of Initiate_Itemgroup_Appr');
3098: END IF;
3099:
3100:
3101: EXCEPTION

Line 3111: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Error in Initiate_Itemgroup_Appr');

3107: p_encoded => fnd_api.g_false);
3108: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3109: THEN
3110: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3111: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Error in Initiate_Itemgroup_Appr');
3112: END IF;
3113:
3114:
3115:

Line 3125: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Unexpected Error in Initiate_Itemgroup_Appr');

3121: p_encoded => fnd_api.g_false);
3122: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3123: THEN
3124: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3125: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Unexpected Error in Initiate_Itemgroup_Appr');
3126: END IF;
3127:
3128:
3129: WHEN OTHERS THEN

Line 3144: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Unknown Error in Initiate_Itemgroup_Appr');

3140:
3141: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3142: THEN
3143: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3144: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Unknown Error in Initiate_Itemgroup_Appr');
3145: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3146: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', SQLERRM);
3147: END IF;
3148:

Line 3146: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', SQLERRM);

3142: THEN
3143: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3144: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Unknown Error in Initiate_Itemgroup_Appr');
3145: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3146: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', SQLERRM);
3147: END IF;
3148:
3149: END Initiate_Itemgroup_Appr;
3150:

Line 3299: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'Begin of Create_ItemGroup_Revision');

3295:
3296: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3297: THEN
3298: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3299: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'Begin of Create_ItemGroup_Revision');
3300: END IF;
3301:
3302:
3303:

Line 3363: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'Calling Table handler');

3359:
3360: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3361: THEN
3362: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3363: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'Calling Table handler');
3364: END IF;
3365:
3366:
3367: ahl_item_groups_pkg.insert_row(

Line 3418: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision',

3414: THEN
3415: FND_LOG.STRING
3416: (
3417: FND_LOG.LEVEL_PROCEDURE,
3418: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision',
3419: 'Updated MC position '||item_group_rec.relationship_id||' with temp_item_group_id '||x_itemgroup_id
3420: );
3421: END IF;
3422: END LOOP;

Line 3428: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'Loop to create Item Association');

3424:
3425: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3426: THEN
3427: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3428: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'Loop to create Item Association');
3429: END IF;
3430:
3431: FOR I IN get_itemgroup_assos_det(p_source_ItemGroup_id)
3432: LOOP

Line 3482: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'End of Loop');

3478:
3479: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3480: THEN
3481: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3482: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'End of Loop');
3483: END IF;
3484:
3485: -- Standard check of p_commit
3486: IF FND_API.TO_BOOLEAN(p_commit) THEN

Line 3493: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'End of Create_ItemGroup_Revision');

3489:
3490: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3491: THEN
3492: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3493: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'End of Create_ItemGroup_Revision');
3494: END IF;
3495:
3496:
3497:

Line 3508: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'Error in Create_ItemGroup_Revision');

3504: p_encoded => fnd_api.g_false);
3505: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3506: THEN
3507: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3508: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'Error in Create_ItemGroup_Revision');
3509: END IF;
3510:
3511:
3512: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3521: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'Unecpected Error in Create_ItemGroup_Revision');

3517: p_encoded => fnd_api.g_false);
3518: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3519: THEN
3520: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3521: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'Unecpected Error in Create_ItemGroup_Revision');
3522: END IF;
3523:
3524:
3525: WHEN OTHERS THEN

Line 3539: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'Unknown Error in Create_ItemGroup_Revision');

3535: p_encoded => fnd_api.g_false);
3536: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3537: THEN
3538: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3539: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'Unknown Error in Create_ItemGroup_Revision');
3540: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3541: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision',SQLERRM );
3542:
3543: END IF;

Line 3541: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision',SQLERRM );

3537: THEN
3538: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3539: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'Unknown Error in Create_ItemGroup_Revision');
3540: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3541: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision',SQLERRM );
3542:
3543: END IF;
3544:
3545:

Line 3615: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Inserting into History Tables');

3611:
3612: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3613: THEN
3614: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3615: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Inserting into History Tables');
3616: END IF;
3617:
3618:
3619: Select ahl_item_associations_b_h_s.nextval

Line 3720: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Inserting Item Association into history table Start of Loop');

3716:
3717: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3718: THEN
3719: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3720: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Inserting Item Association into history table Start of Loop');
3721: END IF;
3722:
3723:
3724: FOR l_item_assos_det IN get_item_assos_det_csr(p_ItemGroups_id) LOOP

Line 3774: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'End of Loop');

3770:
3771: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3772: THEN
3773: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3774: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'End of Loop');
3775: END IF;
3776:
3777:
3778: END update_histroy;

Line 3923: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Begin of Approve_ItemGroups');

3919:
3920: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3921: THEN
3922: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3923: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Begin of Approve_ItemGroups');
3924: END IF;
3925:
3926:
3927:

Line 3971: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Source Item group id is null');

3967: IF l_itemgroup_det.Source_Item_group_id IS NULL THEN
3968:
3969: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3970: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3971: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Source Item group id is null');
3972: END IF;
3973:
3974: update ahl_item_groups_b
3975: set status_code=l_status,

Line 3996: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Source Item Group id is not null');

3992:
3993: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3994: THEN
3995: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3996: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Source Item Group id is not null');
3997: END IF;
3998:
3999: l_fork_or_merge := Fork_Or_Merge(l_itemgroup_det.item_group_id);
4000: IF (l_fork_or_merge = 0)

Line 4158: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Approval Rejected');

4154:
4155: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
4156: THEN
4157: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4158: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Approval Rejected');
4159: END IF;
4160:
4161: update ahl_item_groups_b
4162: set status_code=l_status,

Line 4175: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'End of Approve_ItemGroups');

4171:
4172: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
4173: THEN
4174: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4175: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'End of Approve_ItemGroups');
4176: END IF;
4177:
4178:
4179:

Line 4191: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Error in Approve_ItemGroups');

4187:
4188: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
4189: THEN
4190: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4191: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Error in Approve_ItemGroups');
4192: END IF;
4193:
4194:
4195: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4205: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Unexpected Error in Approve_ItemGroups');

4201:
4202: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
4203: THEN
4204: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4205: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Unexpected Error in Approve_ItemGroups');
4206: END IF;
4207:
4208: WHEN OTHERS THEN
4209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4223: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Unknown Error in Approve_ItemGroups');

4219:
4220: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
4221: THEN
4222: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4223: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Unknown Error in Approve_ItemGroups');
4224: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4225: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', SQLERRM);
4226:
4227: END IF;

Line 4225: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', SQLERRM);

4221: THEN
4222: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4223: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Unknown Error in Approve_ItemGroups');
4224: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4225: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', SQLERRM);
4226:
4227: END IF;
4228:
4229:

Line 4504: End AHL_MC_ITEMGROUP_PVT;

4500: END IF;
4501:
4502: END Fork_Or_Merge;
4503:
4504: End AHL_MC_ITEMGROUP_PVT;