APPS.IBE_PROD_RELATION_GRP dependencies on IBE_PROD_RELATION_GRP

Line 1: PACKAGE BODY IBE_Prod_Relation_GRP AS

1: PACKAGE BODY IBE_Prod_Relation_GRP AS
2: /* $Header: IBEGCRLB.pls 120.1 2011/01/07 06:27:07 scnagara ship $ */
3: FUNCTION Is_Relationship_Valid(
4: p_relation_type_code VARCHAR2) RETURN BOOLEAN
5: IS

Line 208: IBE_UTIL.debug('IBE_Prod_Relation_GRP.Get_Related_Items(+)');

204: x_items_tbl := JTF_Number_Table();
205: l_items_tbl.extend();
206: l_items_tbl(1) := p_item_id;
207: IF (l_debug = 'Y') THEN
208: IBE_UTIL.debug('IBE_Prod_Relation_GRP.Get_Related_Items(+)');
209: IBE_UTIL.debug('p_org_id : p_item_id : p_rel_type_code : l_rule_type = '
210: || p_org_id || ' : ' || p_item_id || ' : '
211: || p_rel_type_code || ' : ' || l_rule_type);
212: END IF;

Line 222: IBE_UTIL.debug('IBE_Prod_Relation_GRP.Get_Related_Items(-)');

218: p_bind_arg5, p_bind_arg6, p_bind_arg7, p_bind_arg8, p_bind_arg9,
219: p_bind_arg10, x_items_tbl);
220:
221: IF (l_debug = 'Y') THEN
222: IBE_UTIL.debug('IBE_Prod_Relation_GRP.Get_Related_Items(-)');
223: END IF;
224: -- Standard call to get message count and if count is 1, get message info.
225: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
226: p_count => x_msg_count ,

Line 445: IBE_UTIL.debug('IBE_Prod_Relation_GRP.Get_Related_Items(+)');

441: x_return_status := FND_API.G_RET_STS_SUCCESS;
442: -- Initialize the return value table
443: x_items_tbl := JTF_Number_Table();
444: IF (l_debug = 'Y') THEN
445: IBE_UTIL.debug('IBE_Prod_Relation_GRP.Get_Related_Items(+)');
446: IBE_UTIL.debug('p_org_id : p_item_id : p_rel_type_code : l_rule_type = '
447: || p_org_id || ' : ' || p_item_id || ' : '
448: || p_rel_type_code || ' : ' || l_rule_type);
449: END IF;

Line 658: IBE_UTIL.debug('IBE_Prod_Relation_GRP.Get_Related_Items(-)');

654: END IF;
655: END IF;
656: -- End of API body.
657: IF (l_debug = 'Y') THEN
658: IBE_UTIL.debug('IBE_Prod_Relation_GRP.Get_Related_Items(-)');
659: END IF;
660: -- Standard call to get message count and if count is 1, get message info.
661: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
662: p_count => x_msg_count ,

Line 1149: IBE_UTIL.debug('IBE_Prod_Relation_GRP.Get_Related_Items(+)');

1145: -- Initialize the return value table
1146: x_items_tbl := JTF_Number_Table();
1147:
1148: IF (l_debug = 'Y') THEN
1149: IBE_UTIL.debug('IBE_Prod_Relation_GRP.Get_Related_Items(+)');
1150: IBE_UTIL.debug('p_org_id : p_rel_type_code : l_rule_type = '
1151: || p_org_id || ' : '
1152: || p_rel_type_code || ' : ' || l_rule_type);
1153: END IF;

Line 1178: IBE_UTIL.debug('IBE_Prod_Relation_GRP.Get_Related_Items(+)');

1174: IBE_UTIL.INSERT_INTO_TEMP_TABLE(p_item_ids(i), 'NUM',l_temp_key, x_query_string);
1175: END LOOP;
1176:
1177: IF (l_debug = 'Y') THEN
1178: IBE_UTIL.debug('IBE_Prod_Relation_GRP.Get_Related_Items(+)');
1179: IBE_UTIL.debug('l_item_ids : ' || l_item_ids );
1180: END IF;
1181: IF l_rule_type = 'SQL' THEN
1182: -- 2. Get the related items using the manual SQL.

Line 1567: IBE_UTIL.debug('IBE_Prod_Relation_GRP.Get_Related_Items(-)');

1563: --Remove the inserted ids from the temp table;
1564: l_status := IBE_UTIL.delete_from_temp_table(l_temp_key);
1565: -- End of API body.
1566: IF (l_debug = 'Y') THEN
1567: IBE_UTIL.debug('IBE_Prod_Relation_GRP.Get_Related_Items(-)');
1568: END IF;
1569: -- Standard call to get message count and if count is 1, get message info.
1570: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1571: p_count => x_msg_count ,

Line 1594: END IBE_Prod_Relation_GRP;

1590: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1591: p_count => x_msg_count ,
1592: p_data => x_msg_data );
1593: END Get_Related_Items;
1594: END IBE_Prod_Relation_GRP;