APPS.IBE_PROD_RELATION_PVT dependencies on IBE_PROD_RELATION_PVT

Line 1: PACKAGE BODY IBE_Prod_Relation_PVT AS

1: PACKAGE BODY IBE_Prod_Relation_PVT AS
2: /* $Header: IBEVCRLB.pls 120.0 2005/05/30 02:21:45 appldev noship $ */
3:
4:
5: PROCEDURE Insert_Relationship(

Line 48: IBE_UTIL.debug('IBE_Prod_Relation_PVT.Insert_Relationship(+)');

44: -- Initialize API return status to success
45: x_return_status := FND_API.G_RET_STS_SUCCESS;
46:
47: IF (l_debug = 'Y') THEN
48: IBE_UTIL.debug('IBE_Prod_Relation_PVT.Insert_Relationship(+)');
49: END IF;
50: -- API body
51: BEGIN
52:

Line 114: IBE_UTIL.debug('IBE_Prod_Relation_PVT.Insert_Relationship(-)');

110: END;
111:
112: -- End of API body.
113: IF (l_debug = 'Y') THEN
114: IBE_UTIL.debug('IBE_Prod_Relation_PVT.Insert_Relationship(-)');
115: END IF;
116:
117: -- Standard check of p_commit.
118: IF FND_API.To_Boolean( p_commit ) THEN

Line 199: IBE_UTIL.debug('IBE_Prod_Relation_PVT.Update_Relationship(+)');

195: -- Initialize API return status to success
196: x_return_status := FND_API.G_RET_STS_SUCCESS;
197:
198: IF (l_debug = 'Y') THEN
199: IBE_UTIL.debug('IBE_Prod_Relation_PVT.Update_Relationship(+)');
200: END IF;
201: -- API body
202: BEGIN
203: fnd_lookup_values_pkg.update_row

Line 260: IBE_UTIL.debug('IBE_Prod_Relation_PVT.Update_Relationship(-)');

256: END;
257:
258: -- End of API body.
259: IF (l_debug = 'Y') THEN
260: IBE_UTIL.debug('IBE_Prod_Relation_PVT.Update_Relationship(-)');
261: END IF;
262:
263: -- Standard check of p_commit.
264: IF FND_API.To_Boolean( p_commit ) THEN

Line 346: IBE_UTIL.debug('IBE_Prod_Relation_PVT.Update_Relationship_Detail(+)');

342: -- Initialize API return status to success
343: x_return_status := FND_API.G_RET_STS_SUCCESS;
344:
345: IF (l_debug = 'Y') THEN
346: IBE_UTIL.debug('IBE_Prod_Relation_PVT.Update_Relationship_Detail(+)');
347: END IF;
348: -- API body
349: BEGIN
350: fnd_lookup_values_pkg.update_row

Line 407: IBE_UTIL.debug('IBE_Prod_Relation_PVT.Update_Relationship_Detail(-)');

403: END;
404:
405: -- End of API body.
406: IF (l_debug = 'Y') THEN
407: IBE_UTIL.debug('IBE_Prod_Relation_PVT.Update_Relationship_Detail(-)');
408: END IF;
409:
410: -- Standard check of p_commit.
411: IF FND_API.To_Boolean( p_commit ) THEN

Line 492: IBE_UTIL.debug('IBE_Prod_Relation_PVT.Delete_Relationship(+)');

488: RETURN;
489: END IF;
490:
491: IF (l_debug = 'Y') THEN
492: IBE_UTIL.debug('IBE_Prod_Relation_PVT.Delete_Relationship(+)');
493: END IF;
494: -- API body
495: FOR i IN 1..p_rel_type_code_tbl.COUNT LOOP
496:

Line 555: IBE_UTIL.debug('IBE_Prod_Relation_PVT.Delete_Relationship(-)');

551: FROM ibe_ct_rel_exclusions
552: WHERE relation_type_code = p_rel_type_code_tbl(i);
553: -- End of API body.
554: IF (l_debug = 'Y') THEN
555: IBE_UTIL.debug('IBE_Prod_Relation_PVT.Delete_Relationship(-)');
556: END IF;
557:
558: -- Standard check of p_commit.
559: IF FND_API.To_Boolean( p_commit ) THEN

Line 638: IBE_UTIL.debug('IBE_Prod_Relation_PVT.Exclude_Related_Items(+)');

634: -- Initialize API return status to success
635: x_return_status := FND_API.G_RET_STS_SUCCESS;
636:
637: IF (l_debug = 'Y') THEN
638: IBE_UTIL.debug('IBE_Prod_Relation_PVT.Exclude_Related_Items(+)');
639: END IF;
640: -- API body
641: FORALL i IN p_inventory_item_id_tbl.FIRST..p_inventory_item_id_tbl.LAST
642: INSERT INTO IBE_CT_REL_EXCLUSIONS(

Line 654: IBE_UTIL.debug('IBE_Prod_Relation_PVT.Exclude_Related_Items(-)');

650: SYSDATE, L_USER_ID, SYSDATE
651: );
652: -- End of API body.
653: IF (l_debug = 'Y') THEN
654: IBE_UTIL.debug('IBE_Prod_Relation_PVT.Exclude_Related_Items(-)');
655: END IF;
656:
657: -- Standard check of p_commit.
658: IF FND_API.To_Boolean( p_commit ) THEN

Line 737: IBE_UTIL.debug('IBE_Prod_Relation_PVT.Include_Related_Items(+)');

733: -- Initialize API return status to success
734: x_return_status := FND_API.G_RET_STS_SUCCESS;
735:
736: IF (l_debug = 'Y') THEN
737: IBE_UTIL.debug('IBE_Prod_Relation_PVT.Include_Related_Items(+)');
738: END IF;
739: -- API body
740: FORALL i IN p_inventory_item_id_tbl.FIRST..p_inventory_item_id_tbl.LAST
741: DELETE

Line 749: IBE_UTIL.debug('IBE_Prod_Relation_PVT.Include_Related_Items(-)');

745: AND related_item_id = p_related_item_id_tbl(i)
746: AND organization_id = L_ORGANIZATION_ID; --Bug 2922902
747: -- End of API body.
748: IF (l_debug = 'Y') THEN
749: IBE_UTIL.debug('IBE_Prod_Relation_PVT.Include_Related_Items(-)');
750: END IF;
751:
752: -- Standard check of p_commit.
753: IF FND_API.To_Boolean( p_commit ) THEN

Line 1382: END IBE_Prod_Relation_PVT;

1378:
1379: Remove_Invalid_Exclusions();
1380: END Item_Deleted;
1381:
1382: END IBE_Prod_Relation_PVT;