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.6.12010000.2 2008/11/18 07:06:40 skpathak 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.6.12010000.2 2008/11/18 07:06:40 skpathak 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 949: 'ahl_mc_itemgroup_pvt.Validate_Item_Assoc', l_item_key);

945: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
946: THEN
947: 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);
948: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
949: 'ahl_mc_itemgroup_pvt.Validate_Item_Assoc', l_item_key);
950: 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);
951: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
952: 'ahl_mc_itemgroup_pvt.Validate_Item_Assoc', l_item_key);
953: END IF;

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

948: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
949: 'ahl_mc_itemgroup_pvt.Validate_Item_Assoc', l_item_key);
950: 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);
951: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
952: 'ahl_mc_itemgroup_pvt.Validate_Item_Assoc', l_item_key);
953: END IF;
954:
955: FND_MESSAGE.Set_Name('AHL','AHL_COM_KEY_NOUPDATE');
956: FND_MSG_PUB.ADD;

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

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

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

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

Line 1304: l_item_assoc_rec AHL_MC_ITEMGROUP_PVT.Item_Association_Rec_Type DEFAULT p_item_assoc_rec;

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

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

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

Line 1476: l_item_assoc_rec AHL_MC_ITEMGROUP_PVT.Item_Association_Rec_Type DEFAULT p_item_assoc_rec;

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

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

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

Line 1738: p_x_item_group_rec IN OUT NOCOPY AHL_MC_ITEMGROUP_PVT.Item_Group_Rec_Type,

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

Line 1739: p_x_items_tbl IN OUT NOCOPY AHL_MC_ITEMGROUP_PVT.Item_Association_Tbl_Type

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1945: p_item_group_rec IN AHL_MC_ITEMGROUP_PVT.Item_Group_Rec_Type,

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

Line 1946: p_x_items_tbl IN OUT NOCOPY AHL_MC_ITEMGROUP_PVT.Item_Association_Tbl_Type

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

Line 1994: l_item_group_rec AHL_MC_ITEMGROUP_PVT.Item_group_rec_Type DEFAULT p_item_group_rec;

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

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

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

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

2105: END IF;
2106:
2107: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2108: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2109: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'Loop to validate Item Association');
2110: END IF;
2111:
2112: -- Validate Item Assoc records.
2113: IF (p_x_items_tbl.COUNT > 0 ) THEN

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

2138: END IF; /* count > 0 */
2139:
2140: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2141: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2142: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'End of Loop');
2143: END IF;
2144:
2145: -- Check Error Message stack.
2146: x_msg_count := FND_MSG_PUB.count_msg;

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

2261: */
2262:
2263: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2264: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2265: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'Before calling Item Group Table Handler');
2266: END IF;
2267:
2268: AHL_ITEM_GROUPS_PKG.UPDATE_ROW(
2269: X_ITEM_GROUP_ID => l_old_item_group_rec.item_group_id,

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

2294: X_LAST_UPDATE_LOGIN => fnd_global.LOGIN_ID);
2295:
2296: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2297: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2298: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'After Table Handler');
2299: END IF;
2300:
2301:
2302: END IF; /* update only if operation_flag set */

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

2357: END IF; -- end of l_old_item_group_rec.source_item_group_id IS NOT NULL
2358:
2359: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2360: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2361: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'Item Association Loop');
2362: END IF;
2363:
2364: -- Process Item Associations table.
2365: -- Priyan . Changed the order of the DML flag checks made for item group associations.

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

2381: END IF;
2382:
2383: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2384: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2385: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'End of Loop');
2386: END IF;
2387:
2388: -- The validation of the revision update will be done only for revisions
2389: IF l_old_item_group_rec.source_item_group_id IS NOT NULL THEN

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

2430: p_encoded => fnd_api.g_false);
2431:
2432: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2433: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2434: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group',
2435: 'End of Modify_Item_group...x_return_status => '||x_return_status);
2436: END IF;
2437:
2438:

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

2446: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
2447:
2448: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2449: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2450: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'Error in Modify_Item_group');
2451: END IF;
2452:
2453:
2454: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2459: p_encoded => fnd_api.g_false);
2460: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
2461: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2462: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2463: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'Unexpected error in Modify_Item_group');
2464: END IF;
2465:
2466:
2467: WHEN OTHERS THEN

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

2478: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
2479:
2480: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2481: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2482: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'Unknown Error in Modify_Item_group');
2483: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2484: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', SQLERRM);
2485: END IF;
2486:

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

2480: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2481: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2482: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'Unknown Error in Modify_Item_group');
2483: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2484: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', SQLERRM);
2485: END IF;
2486:
2487:
2488: END Modify_Item_group;

Line 2504: p_item_group_rec IN AHL_MC_ITEMGROUP_PVT.Item_Group_Rec_Type

2500: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2501: x_return_status OUT NOCOPY VARCHAR2,
2502: x_msg_count OUT NOCOPY NUMBER,
2503: x_msg_data OUT NOCOPY VARCHAR2,
2504: p_item_group_rec IN AHL_MC_ITEMGROUP_PVT.Item_Group_Rec_Type
2505: ) IS
2506:
2507: l_api_name CONSTANT VARCHAR2(30) := 'Remove_Item_Group';
2508: l_api_version CONSTANT NUMBER := 1.0;

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

2574:
2575: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2576: THEN
2577: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2578: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'Begin of Remove_Item_group');
2579: END IF;
2580:
2581:
2582: -- Validate Item Group record.

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

2663:
2664: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2665: THEN
2666: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2667: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'Deleting Item Group');
2668: END IF;
2669:
2670: DELETE AHL_ITEM_ASSOCIATIONS_TL
2671: WHERE item_association_id IN ( SELECT item_association_id

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

2685:
2686: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2687: THEN
2688: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2689: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'Updating Item Group to Removed');
2690: END IF;
2691:
2692: Update Ahl_Item_groups_b
2693: set status_code ='REMOVED',

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

2711:
2712: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2713: THEN
2714: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2715: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'End of Remove_Item_group');
2716: END IF;
2717:
2718:
2719:

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

2727:
2728: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2729: THEN
2730: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2731: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'Error in Remove_Item_group');
2732: END IF;
2733:
2734: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2735: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

2739: p_encoded => fnd_api.g_false);
2740: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2741: THEN
2742: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2743: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'Unexpected error in Remove_Item_group');
2744: END IF;
2745:
2746:
2747: WHEN OTHERS THEN

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

2757: p_encoded => fnd_api.g_false);
2758: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2759: THEN
2760: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2761: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'Unknown error in Remove_Item_group');
2762: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2763: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', SQLERRM);
2764: END IF;
2765:

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

2759: THEN
2760: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2761: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'Unknown error in Remove_Item_group');
2762: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2763: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', SQLERRM);
2764: END IF;
2765:
2766:
2767: END Remove_Item_group;

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

2888:
2889: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2890: THEN
2891: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2892: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Begin Initiate_Itemgroup_Appr');
2893: END IF;
2894:
2895:
2896:

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

2994:
2995: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2996: THEN
2997: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2998: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'l_active flag is yes');
2999: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3000: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Updating Item group');
3001: END IF;
3002:

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

2996: THEN
2997: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2998: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'l_active flag is yes');
2999: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3000: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Updating Item group');
3001: END IF;
3002:
3003: Update AHL_ITEM_GROUPS_B
3004: Set STATUS_CODE=l_upd_status,

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

3019:
3020: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3021: THEN
3022: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3023: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Calling ahl_generic_aprv_pvt.start_wf_process');
3024: END IF;
3025:
3026: AHL_GENERIC_APRV_PVT.START_WF_PROCESS(
3027: P_OBJECT =>l_object,

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

3039:
3040: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3041: THEN
3042: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3043: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Calling ahl_mc_itemgroup_pvt.Approve_ItemGroups');
3044: END IF;
3045:
3046: AHL_MC_ITEMGROUP_PVT.Approve_ItemGroups
3047: (

Line 3046: AHL_MC_ITEMGROUP_PVT.Approve_ItemGroups

3042: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3043: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Calling ahl_mc_itemgroup_pvt.Approve_ItemGroups');
3044: END IF;
3045:
3046: AHL_MC_ITEMGROUP_PVT.Approve_ItemGroups
3047: (
3048: p_api_version =>l_api_version,
3049: -- p_init_msg_list =>l_init_msg_list,
3050: -- p_commit =>l_commit,

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

3083:
3084: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3085: THEN
3086: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3087: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'End of Initiate_Itemgroup_Appr');
3088: END IF;
3089:
3090:
3091: EXCEPTION

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

3097: p_encoded => fnd_api.g_false);
3098: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3099: THEN
3100: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3101: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Error in Initiate_Itemgroup_Appr');
3102: END IF;
3103:
3104:
3105:

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

3111: p_encoded => fnd_api.g_false);
3112: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3113: THEN
3114: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3115: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Unexpected Error in Initiate_Itemgroup_Appr');
3116: END IF;
3117:
3118:
3119: WHEN OTHERS THEN

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

3130:
3131: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3132: THEN
3133: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3134: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Unknown Error in Initiate_Itemgroup_Appr');
3135: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3136: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', SQLERRM);
3137: END IF;
3138:

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

3132: THEN
3133: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3134: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Unknown Error in Initiate_Itemgroup_Appr');
3135: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3136: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', SQLERRM);
3137: END IF;
3138:
3139: END Initiate_Itemgroup_Appr;
3140:

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

3285:
3286: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3287: THEN
3288: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3289: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'Begin of Create_ItemGroup_Revision');
3290: END IF;
3291:
3292:
3293:

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

3349:
3350: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3351: THEN
3352: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3353: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'Calling Table handler');
3354: END IF;
3355:
3356:
3357: ahl_item_groups_pkg.insert_row(

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

3404: THEN
3405: FND_LOG.STRING
3406: (
3407: FND_LOG.LEVEL_PROCEDURE,
3408: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision',
3409: 'Updated MC position '||item_group_rec.relationship_id||' with temp_item_group_id '||x_itemgroup_id
3410: );
3411: END IF;
3412: END LOOP;

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

3414:
3415: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3416: THEN
3417: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3418: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'Loop to create Item Association');
3419: END IF;
3420:
3421: FOR I IN get_itemgroup_assos_det(p_source_ItemGroup_id)
3422: LOOP

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

3468:
3469: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3470: THEN
3471: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3472: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'End of Loop');
3473: END IF;
3474:
3475: -- Standard check of p_commit
3476: IF FND_API.TO_BOOLEAN(p_commit) THEN

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

3479:
3480: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3481: THEN
3482: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3483: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'End of Create_ItemGroup_Revision');
3484: END IF;
3485:
3486:
3487:

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

3494: p_encoded => fnd_api.g_false);
3495: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3496: THEN
3497: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3498: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'Error in Create_ItemGroup_Revision');
3499: END IF;
3500:
3501:
3502: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

3507: p_encoded => fnd_api.g_false);
3508: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3509: THEN
3510: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3511: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'Unecpected Error in Create_ItemGroup_Revision');
3512: END IF;
3513:
3514:
3515: WHEN OTHERS THEN

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

3525: p_encoded => fnd_api.g_false);
3526: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3527: THEN
3528: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3529: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'Unknown Error in Create_ItemGroup_Revision');
3530: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3531: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision',SQLERRM );
3532:
3533: END IF;

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

3527: THEN
3528: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3529: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'Unknown Error in Create_ItemGroup_Revision');
3530: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3531: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision',SQLERRM );
3532:
3533: END IF;
3534:
3535:

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

3601:
3602: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3603: THEN
3604: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3605: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Inserting into History Tables');
3606: END IF;
3607:
3608:
3609: Select ahl_item_associations_b_h_s.nextval

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

3706:
3707: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3708: THEN
3709: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3710: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Inserting Item Association into history table Start of Loop');
3711: END IF;
3712:
3713:
3714: FOR l_item_assos_det IN get_item_assos_det_csr(p_ItemGroups_id) LOOP

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

3760:
3761: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3762: THEN
3763: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3764: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'End of Loop');
3765: END IF;
3766:
3767:
3768: END update_histroy;

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

3909:
3910: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3911: THEN
3912: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3913: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Begin of Approve_ItemGroups');
3914: END IF;
3915:
3916:
3917:

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

3957: IF l_itemgroup_det.Source_Item_group_id IS NULL THEN
3958:
3959: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3960: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3961: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Source Item group id is null');
3962: END IF;
3963:
3964: update ahl_item_groups_b
3965: set status_code=l_status,

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

3982:
3983: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3984: THEN
3985: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3986: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Source Item Group id is not null');
3987: END IF;
3988:
3989: l_fork_or_merge := Fork_Or_Merge(l_itemgroup_det.item_group_id);
3990: IF (l_fork_or_merge = 0)

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

4128:
4129: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
4130: THEN
4131: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4132: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Approval Rejected');
4133: END IF;
4134:
4135: update ahl_item_groups_b
4136: set status_code=l_status,

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

4145:
4146: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
4147: THEN
4148: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4149: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'End of Approve_ItemGroups');
4150: END IF;
4151:
4152:
4153:

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

4161:
4162: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
4163: THEN
4164: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4165: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Error in Approve_ItemGroups');
4166: END IF;
4167:
4168:
4169: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

4175:
4176: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
4177: THEN
4178: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4179: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Unexpected Error in Approve_ItemGroups');
4180: END IF;
4181:
4182: WHEN OTHERS THEN
4183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

4193:
4194: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
4195: THEN
4196: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4197: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Unknown Error in Approve_ItemGroups');
4198: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4199: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', SQLERRM);
4200:
4201: END IF;

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

4195: THEN
4196: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4197: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Unknown Error in Approve_ItemGroups');
4198: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4199: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', SQLERRM);
4200:
4201: END IF;
4202:
4203:

Line 4478: End AHL_MC_ITEMGROUP_PVT;

4474: END IF;
4475:
4476: END Fork_Or_Merge;
4477:
4478: End AHL_MC_ITEMGROUP_PVT;