DBA Data[Home] [Help]

APPS.AHL_MC_ITEMGROUP_PVT dependencies on STANDARD

Line 1757: -- Standard start of API savepoint

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

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

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

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

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

Line 1939: -- Standard IN Parameters :

1935: -- Type : Private
1936: -- 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.
1937: -- Pre-reqs :
1938: -- Parameters :
1939: -- Standard IN Parameters :
1940:
1941: PROCEDURE Modify_Item_group (p_api_version IN NUMBER,
1942: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1943: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

Line 2017: -- Standard start of API savepoint

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

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

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

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

2432: --Bug # 4330922
2433: validate_IG_revision(l_old_item_group_rec.item_group_id);
2434: --Priyan End
2435:
2436: -- Standard call to get message count and if count is 1, get message info
2437: FND_MSG_PUB.Count_And_Get
2438: ( p_count => x_msg_count,
2439: p_data => x_msg_data,
2440: p_encoded => fnd_api.g_false);

Line 2507: -- Standard IN Parameters :

2503: -- Type : Private
2504: -- Function : Deletes an Item Group and associated item associations.
2505: -- Pre-reqs :
2506: -- Parameters :
2507: -- Standard IN Parameters :
2508: PROCEDURE Remove_Item_group(p_api_version IN NUMBER,
2509: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2510: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2511: x_return_status OUT NOCOPY VARCHAR2,

Line 2568: -- Standard start of API savepoint

2564: l_dummy VARCHAR2(1);
2565:
2566: BEGIN
2567:
2568: -- Standard start of API savepoint
2569: SAVEPOINT Remove_Item_group_Pvt;
2570:
2571: -- Standard call to check for call compatibility
2572: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,

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

2567:
2568: -- Standard start of API savepoint
2569: SAVEPOINT Remove_Item_group_Pvt;
2570:
2571: -- Standard call to check for call compatibility
2572: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
2573: G_PKG_NAME) THEN
2574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2575: END IF;

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

2712: END IF;
2713:
2714: CLOSE Item_group_csr;
2715:
2716: -- Standard call to get message count and if count is 1, get message info
2717: FND_MSG_PUB.Count_And_Get
2718: ( p_count => x_msg_count,
2719: p_data => x_msg_data,
2720: p_encoded => fnd_api.g_false);

Line 2786: -- Standard IN Parameters :

2782: -- Function : Intiates Approval Process for Item groups
2783: --
2784: -- Pre-reqs :
2785: -- Parameters :
2786: -- Standard IN Parameters :
2787: -- p_api_version IN NUMBER Required
2788: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
2789: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
2790: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 2792: -- Standard OUT Parameters :

2788: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
2789: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
2790: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
2791: --
2792: -- Standard OUT Parameters :
2793: -- x_return_status OUT VARCHAR2 Required
2794: -- x_msg_count OUT NUMBER Required
2795: -- x_msg_data OUT VARCHAR2 Required
2796: --

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

2885:
2886: BEGIN
2887: SAVEPOINT Initiate_Itemgroup_Appr;
2888:
2889: -- Standard call to check for call compatibility.
2890:
2891: IF FND_API.to_boolean(l_init_msg_list) THEN
2892: FND_MSG_PUB.initialize;
2893: END IF;

Line 3083: -- Standard check of p_commit

3079: RAISE FND_API.G_EXC_ERROR;
3080: END IF;
3081:
3082:
3083: -- Standard check of p_commit
3084: IF FND_API.TO_BOOLEAN(p_commit) THEN
3085: COMMIT WORK;
3086: END IF;
3087:

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

3084: IF FND_API.TO_BOOLEAN(p_commit) THEN
3085: COMMIT WORK;
3086: END IF;
3087:
3088: -- Standard call to get message count and if count is 1, get message info
3089: FND_MSG_PUB.Count_And_Get
3090: ( p_count => x_msg_count,
3091: p_data => x_msg_data,
3092: p_encoded => fnd_api.g_false);

Line 3159: -- Standard IN Parameters :

3155: -- Function : To create a New Revision of Item group
3156: --
3157: -- Pre-reqs :
3158: -- Parameters :
3159: -- Standard IN Parameters :
3160: -- p_api_version IN NUMBER Required
3161: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
3162: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
3163: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 3165: -- Standard OUT Parameters :

3161: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
3162: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
3163: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
3164: --
3165: -- Standard OUT Parameters :
3166: -- x_return_status OUT VARCHAR2 Required
3167: -- x_msg_count OUT NUMBER Required
3168: -- x_msg_data OUT VARCHAR2 Required
3169:

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

3282:
3283:
3284: SAVEPOINT Create_ItemGroup_Revision;
3285:
3286: -- Standard call to check for call compatibility.
3287:
3288: IF FND_API.to_boolean(l_init_msg_list) THEN
3289: FND_MSG_PUB.initialize;
3290: END IF;

Line 3485: -- Standard check of p_commit

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
3487: COMMIT WORK;
3488: END IF;
3489:

Line 3789: -- Standard IN Parameters :

3785: -- Version : Added for 115.10
3786: --
3787: -- Pre-reqs :
3788: -- Parameters :
3789: -- Standard IN Parameters :
3790: -- p_api_version IN NUMBER Required
3791: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
3792: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
3793: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 3795: -- Standard OUT Parameters :

3791: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
3792: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
3793: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
3794: --
3795: -- Standard OUT Parameters :
3796: -- x_return_status OUT VARCHAR2 Required
3797: -- x_msg_count OUT NUMBER Required
3798: -- x_msg_data OUT VARCHAR2 Required
3799:

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

3906:
3907: SAVEPOINT Approve_ItemGroups;
3908:
3909:
3910: -- Standard call to check for call compatibility.
3911:
3912: IF FND_API.to_boolean(l_init_msg_list) THEN
3913: FND_MSG_PUB.initialize;
3914: END IF;

Line 4279: -- Standard start of API savepoint

4275: l_junk VARCHAR2(1);
4276:
4277: BEGIN
4278:
4279: -- Standard start of API savepoint
4280: SAVEPOINT Modify_Position_Assos_SP;
4281:
4282: -- Standard call to check for call compatibility
4283: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)

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

4278:
4279: -- Standard start of API savepoint
4280: SAVEPOINT Modify_Position_Assos_SP;
4281:
4282: -- Standard call to check for call compatibility
4283: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
4284: THEN
4285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4286: END IF;

Line 4386: -- Standard check for p_commit

4382: IF x_msg_count > 0 THEN
4383: RAISE FND_API.G_EXC_ERROR;
4384: END IF;
4385:
4386: -- Standard check for p_commit
4387: IF FND_API.TO_BOOLEAN (p_commit)
4388: THEN
4389: COMMIT WORK;
4390: END IF;

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

4388: THEN
4389: COMMIT WORK;
4390: END IF;
4391:
4392: -- Standard call to get message count and if count is 1, get message info
4393: FND_MSG_PUB.count_and_get
4394: (
4395: p_count => x_msg_count,
4396: p_data => x_msg_data,