DBA Data[Home] [Help]

APPS.AHL_MC_ITEMGROUP_PVT dependencies on STANDARD

Line 1755: -- Standard start of API savepoint

1751: l_inv_segment ahl_mtl_items_non_ou_v.concatenated_segments%TYPE;
1752: l_row_id VARCHAR2(30);
1753:
1754: BEGIN
1755: -- Standard start of API savepoint
1756: SAVEPOINT Create_Item_group_Pvt;
1757:
1758:
1759: -- Standard call to check for call compatibility

Line 1759: -- Standard call to check for call compatibility

1755: -- Standard start of API savepoint
1756: SAVEPOINT Create_Item_group_Pvt;
1757:
1758:
1759: -- Standard call to check for call compatibility
1760: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
1761: G_PKG_NAME) THEN
1762: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1763: END IF;

Line 1872: -- Standard call to get message count and if count is 1, get message info

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
1873: FND_MSG_PUB.Count_And_Get
1874: ( p_count => x_msg_count,
1875: p_data => x_msg_data,
1876: p_encoded => fnd_api.g_false);

Line 1937: -- Standard IN Parameters :

1933: -- Type : Private
1934: -- Function : Modifies Item Group for Master Configuration in ahl_item_groups_b and TL tables. Also creates/deletes/modifies item-group association in ahl_item_associations_b/_tl table.
1935: -- Pre-reqs :
1936: -- Parameters :
1937: -- Standard IN Parameters :
1938:
1939: PROCEDURE Modify_Item_group (p_api_version IN NUMBER,
1940: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1941: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

Line 2013: -- Standard start of API savepoint

2009: l_index NUMBER := 1;
2010:
2011: BEGIN
2012:
2013: -- Standard start of API savepoint
2014: SAVEPOINT Modify_Item_group_Pvt;
2015:
2016: -- Standard call to check for call compatibility
2017: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,

Line 2016: -- Standard call to check for call compatibility

2012:
2013: -- Standard start of API savepoint
2014: SAVEPOINT Modify_Item_group_Pvt;
2015:
2016: -- Standard call to check for call compatibility
2017: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
2018: G_PKG_NAME) THEN
2019: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2020: END IF;

Line 2426: -- Standard call to get message count and if count is 1, get message info

2422: --Bug # 4330922
2423: validate_IG_revision(l_old_item_group_rec.item_group_id);
2424: --Priyan End
2425:
2426: -- Standard call to get message count and if count is 1, get message info
2427: FND_MSG_PUB.Count_And_Get
2428: ( p_count => x_msg_count,
2429: p_data => x_msg_data,
2430: p_encoded => fnd_api.g_false);

Line 2497: -- Standard IN Parameters :

2493: -- Type : Private
2494: -- Function : Deletes an Item Group and associated item associations.
2495: -- Pre-reqs :
2496: -- Parameters :
2497: -- Standard IN Parameters :
2498: PROCEDURE Remove_Item_group(p_api_version IN NUMBER,
2499: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2500: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2501: x_return_status OUT NOCOPY VARCHAR2,

Line 2558: -- Standard start of API savepoint

2554: l_dummy VARCHAR2(1);
2555:
2556: BEGIN
2557:
2558: -- Standard start of API savepoint
2559: SAVEPOINT Remove_Item_group_Pvt;
2560:
2561: -- Standard call to check for call compatibility
2562: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,

Line 2561: -- Standard call to check for call compatibility

2557:
2558: -- Standard start of API savepoint
2559: SAVEPOINT Remove_Item_group_Pvt;
2560:
2561: -- Standard call to check for call compatibility
2562: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
2563: G_PKG_NAME) THEN
2564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2565: END IF;

Line 2706: -- Standard call to get message count and if count is 1, get message info

2702: END IF;
2703:
2704: CLOSE Item_group_csr;
2705:
2706: -- Standard call to get message count and if count is 1, get message info
2707: FND_MSG_PUB.Count_And_Get
2708: ( p_count => x_msg_count,
2709: p_data => x_msg_data,
2710: p_encoded => fnd_api.g_false);

Line 2776: -- Standard IN Parameters :

2772: -- Function : Intiates Approval Process for Item groups
2773: --
2774: -- Pre-reqs :
2775: -- Parameters :
2776: -- Standard IN Parameters :
2777: -- p_api_version IN NUMBER Required
2778: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
2779: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
2780: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 2782: -- Standard OUT Parameters :

2778: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
2779: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
2780: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
2781: --
2782: -- Standard OUT Parameters :
2783: -- x_return_status OUT VARCHAR2 Required
2784: -- x_msg_count OUT NUMBER Required
2785: -- x_msg_data OUT VARCHAR2 Required
2786: --

Line 2879: -- Standard call to check for call compatibility.

2875:
2876: BEGIN
2877: SAVEPOINT Initiate_Itemgroup_Appr;
2878:
2879: -- Standard call to check for call compatibility.
2880:
2881: IF FND_API.to_boolean(l_init_msg_list) THEN
2882: FND_MSG_PUB.initialize;
2883: END IF;

Line 3073: -- Standard check of p_commit

3069: RAISE FND_API.G_EXC_ERROR;
3070: END IF;
3071:
3072:
3073: -- Standard check of p_commit
3074: IF FND_API.TO_BOOLEAN(p_commit) THEN
3075: COMMIT WORK;
3076: END IF;
3077:

Line 3078: -- Standard call to get message count and if count is 1, get message info

3074: IF FND_API.TO_BOOLEAN(p_commit) THEN
3075: COMMIT WORK;
3076: END IF;
3077:
3078: -- Standard call to get message count and if count is 1, get message info
3079: FND_MSG_PUB.Count_And_Get
3080: ( p_count => x_msg_count,
3081: p_data => x_msg_data,
3082: p_encoded => fnd_api.g_false);

Line 3149: -- Standard IN Parameters :

3145: -- Function : To create a New Revision of Item group
3146: --
3147: -- Pre-reqs :
3148: -- Parameters :
3149: -- Standard IN Parameters :
3150: -- p_api_version IN NUMBER Required
3151: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
3152: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
3153: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 3155: -- Standard OUT Parameters :

3151: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
3152: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
3153: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
3154: --
3155: -- Standard OUT Parameters :
3156: -- x_return_status OUT VARCHAR2 Required
3157: -- x_msg_count OUT NUMBER Required
3158: -- x_msg_data OUT VARCHAR2 Required
3159:

Line 3276: -- Standard call to check for call compatibility.

3272:
3273:
3274: SAVEPOINT Create_ItemGroup_Revision;
3275:
3276: -- Standard call to check for call compatibility.
3277:
3278: IF FND_API.to_boolean(l_init_msg_list) THEN
3279: FND_MSG_PUB.initialize;
3280: END IF;

Line 3475: -- Standard check of p_commit

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
3477: COMMIT WORK;
3478: END IF;
3479:

Line 3779: -- Standard IN Parameters :

3775: -- Version : Added for 115.10
3776: --
3777: -- Pre-reqs :
3778: -- Parameters :
3779: -- Standard IN Parameters :
3780: -- p_api_version IN NUMBER Required
3781: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
3782: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
3783: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 3785: -- Standard OUT Parameters :

3781: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
3782: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
3783: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
3784: --
3785: -- Standard OUT Parameters :
3786: -- x_return_status OUT VARCHAR2 Required
3787: -- x_msg_count OUT NUMBER Required
3788: -- x_msg_data OUT VARCHAR2 Required
3789:

Line 3900: -- Standard call to check for call compatibility.

3896:
3897: SAVEPOINT Approve_ItemGroups;
3898:
3899:
3900: -- Standard call to check for call compatibility.
3901:
3902: IF FND_API.to_boolean(l_init_msg_list) THEN
3903: FND_MSG_PUB.initialize;
3904: END IF;

Line 4253: -- Standard start of API savepoint

4249: l_junk VARCHAR2(1);
4250:
4251: BEGIN
4252:
4253: -- Standard start of API savepoint
4254: SAVEPOINT Modify_Position_Assos_SP;
4255:
4256: -- Standard call to check for call compatibility
4257: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)

Line 4256: -- Standard call to check for call compatibility

4252:
4253: -- Standard start of API savepoint
4254: SAVEPOINT Modify_Position_Assos_SP;
4255:
4256: -- Standard call to check for call compatibility
4257: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
4258: THEN
4259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4260: END IF;

Line 4360: -- Standard check for p_commit

4356: IF x_msg_count > 0 THEN
4357: RAISE FND_API.G_EXC_ERROR;
4358: END IF;
4359:
4360: -- Standard check for p_commit
4361: IF FND_API.TO_BOOLEAN (p_commit)
4362: THEN
4363: COMMIT WORK;
4364: END IF;

Line 4366: -- Standard call to get message count and if count is 1, get message info

4362: THEN
4363: COMMIT WORK;
4364: END IF;
4365:
4366: -- Standard call to get message count and if count is 1, get message info
4367: FND_MSG_PUB.count_and_get
4368: (
4369: p_count => x_msg_count,
4370: p_data => x_msg_data,