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.IBE_PROD_RELATION_GRP dependencies on IBE_UTIL

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 209: IBE_UTIL.debug('p_org_id : p_item_id : p_rel_type_code : l_rule_type = '

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;
213:

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 446: IBE_UTIL.debug('p_org_id : p_item_id : p_rel_type_code : l_rule_type = '

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;
450: -- API body

Line 454: IBE_UTIL.debug('Relationship is not valid.');

450: -- API body
451: -- 1. Check if the relationship exists and is active
452: IF NOT Is_Relationship_Valid(p_rel_type_code) THEN
453: IF (l_debug = 'Y') THEN
454: IBE_UTIL.debug('Relationship is not valid.');
455: END IF;
456: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_NOT_VALID');
457: FND_MESSAGE.Set_Token('RELATIONSHIP', p_rel_type_code);
458: FND_MSG_PUB.Add;

Line 560: IBE_UTIL.debug('SQL execution caused an error.');

556: RETURN;
557: EXCEPTION
558: WHEN OTHERS THEN
559: IF (l_debug = 'Y') THEN
560: IBE_UTIL.debug('SQL execution caused an error.');
561: END IF;
562: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_SQL_RULE_ERROR');
563: FND_MESSAGE.Set_Token('RELATIONSHIP', p_rel_type_code);
564: FND_MSG_PUB.Add;

Line 573: IBE_UTIL.debug('Mapping rule: p_max_ret_num is NULL: relationship NOT in MTL: l_include_self_ref is TRUE.');

569: include_mtl := Exists_In_MTL(p_rel_type_code);
570: IF (p_max_ret_num IS NULL) AND (NOT include_mtl) THEN -- Can use bulk fetching
571: IF FND_API.to_Boolean( l_include_self_ref ) THEN -- include self referral
572: IF (l_debug = 'Y') THEN
573: IBE_UTIL.debug('Mapping rule: p_max_ret_num is NULL: relationship NOT in MTL: l_include_self_ref is TRUE.');
574: END IF;
575: EXECUTE IMMEDIATE l_without_mtl_bulk_stmt ||
576: '; END;'
577: USING OUT x_items_tbl, p_rel_type_code, p_item_id, p_org_id;

Line 580: IBE_UTIL.debug('Mapping rule: p_max_ret_num is NULL: relationship NOT in MTL: l_include_self_ref is FALSE.');

576: '; END;'
577: USING OUT x_items_tbl, p_rel_type_code, p_item_id, p_org_id;
578: ELSE -- exclude self referral
579: IF (l_debug = 'Y') THEN
580: IBE_UTIL.debug('Mapping rule: p_max_ret_num is NULL: relationship NOT in MTL: l_include_self_ref is FALSE.');
581: END IF;
582: EXECUTE IMMEDIATE l_without_mtl_bulk_stmt ||
583: ' AND ICRI.related_item_id <> :item_id5 ' ||
584: '; END;'

Line 591: IBE_UTIL.debug('Mapping rule: relationship in MTL: l_include_self_ref is TRUE.');

587: ELSE -- Cannot use bulk fetching
588: IF include_mtl THEN -- must do union with mtl_related_items
589: IF FND_API.to_Boolean( l_include_self_ref ) THEN -- include self referral
590: IF (l_debug = 'Y') THEN
591: IBE_UTIL.debug('Mapping rule: relationship in MTL: l_include_self_ref is TRUE.');
592: END IF;
593: OPEN l_rel_items_csr FOR l_with_mtl_stmt1 ||
594: l_with_mtl_stmt2 ||
595: l_with_mtl_stmt3 ||

Line 603: IBE_UTIL.debug('Mapping rule: relationship in MTL: l_include_self_ref is FALSE.');

599: p_rel_type_code, p_item_id, p_org_id,
600: p_rel_type_code, p_item_id, p_org_id; --Bug 2922902
601: ELSE -- exclude self referral
602: IF (l_debug = 'Y') THEN
603: IBE_UTIL.debug('Mapping rule: relationship in MTL: l_include_self_ref is FALSE.');
604: END IF;
605: OPEN l_rel_items_csr FOR l_with_mtl_stmt1 ||
606: ' AND ICRI.related_item_id <> :item_id4 ' ||
607: l_with_mtl_stmt2 ||

Line 620: IBE_UTIL.debug('Mapping rule: p_max_ret_num is NOT NULL: relationship NOT in MTL: l_include_self_ref is TRUE.');

616: END IF;
617: ELSE -- don't need to do union with mtl_related_items
618: IF FND_API.to_Boolean( l_include_self_ref ) THEN -- include self referral
619: IF (l_debug = 'Y') THEN
620: IBE_UTIL.debug('Mapping rule: p_max_ret_num is NOT NULL: relationship NOT in MTL: l_include_self_ref is TRUE.');
621: END IF;
622: OPEN l_rel_items_csr FOR l_without_mtl_stmt
623: USING p_rel_type_code, p_item_id, p_org_id;
624: ELSE -- exclude self referral

Line 626: IBE_UTIL.debug('Mapping rule: p_max_ret_num is NOT NULL: relationship NOT in MTL: l_include_self_ref is FALSE.');

622: OPEN l_rel_items_csr FOR l_without_mtl_stmt
623: USING p_rel_type_code, p_item_id, p_org_id;
624: ELSE -- exclude self referral
625: IF (l_debug = 'Y') THEN
626: IBE_UTIL.debug('Mapping rule: p_max_ret_num is NOT NULL: relationship NOT in MTL: l_include_self_ref is FALSE.');
627: END IF;
628: OPEN l_rel_items_csr FOR l_without_mtl_stmt ||
629: ' AND ICRI.related_item_id <> :item_id4 '
630: USING p_org_id, p_rel_type_code, p_item_id, p_item_id;

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 1150: IBE_UTIL.debug('p_org_id : p_rel_type_code : l_rule_type = '

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;
1154:

Line 1159: IBE_UTIL.debug('Relationship is not valid.');

1155: -- API body
1156: -- 1. Check if the relationship exists and is active
1157: IF NOT Is_Relationship_Valid(p_rel_type_code) THEN
1158: IF (l_debug = 'Y') THEN
1159: IBE_UTIL.debug('Relationship is not valid.');
1160: END IF;
1161: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_NOT_VALID');
1162: FND_MESSAGE.Set_Token('RELATIONSHIP', p_rel_type_code);
1163: FND_MSG_PUB.Add;

Line 1169: IBE_UTIL.debug('Inserting to ibe_temp_table.');

1165: END IF;
1166:
1167: -- Populate the itemIds into a temporary table.
1168: IF (l_debug = 'Y') THEN
1169: IBE_UTIL.debug('Inserting to ibe_temp_table.');
1170: END IF;
1171:
1172: FOR i in p_item_ids.FIRST .. p_item_ids.LAST
1173: LOOP

Line 1174: IBE_UTIL.INSERT_INTO_TEMP_TABLE(p_item_ids(i), 'NUM',l_temp_key, x_query_string);

1170: END IF;
1171:
1172: FOR i in p_item_ids.FIRST .. p_item_ids.LAST
1173: LOOP
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(+)');

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 1179: IBE_UTIL.debug('l_item_ids : ' || l_item_ids );

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.
1183: BEGIN -- begin sub-block to handle the SELECT statement's exception

Line 1284: IBE_UTIL.debug('SQL execution caused an error.');

1280: RETURN;
1281: EXCEPTION
1282: WHEN OTHERS THEN
1283: IF (l_debug = 'Y') THEN
1284: IBE_UTIL.debug('SQL execution caused an error.');
1285: END IF;
1286: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_SQL_RULE_ERROR');
1287: FND_MESSAGE.Set_Token('RELATIONSHIP', p_rel_type_code);
1288: FND_MSG_PUB.Add;

Line 1299: IBE_UTIL.debug('Mapping rule: p_max_ret_num is NULL: relationship NOT in MTL: l_include_self_ref is TRUE.');

1295: IF (p_max_ret_num IS NULL) AND (NOT include_mtl) THEN -- Can use bulk fetching
1296:
1297: IF FND_API.to_Boolean( l_include_self_ref ) THEN -- include self referral
1298: IF (l_debug = 'Y') THEN
1299: IBE_UTIL.debug('Mapping rule: p_max_ret_num is NULL: relationship NOT in MTL: l_include_self_ref is TRUE.');
1300: END IF;
1301: IF FND_API.to_Boolean(l_preview_flag) THEN --preview mode
1302: IF (p_item_ids.LAST > 1) THEN -- multiple items as input
1303: EXECUTE IMMEDIATE l_pv_wout_mtl_bulk_mult_stmt || l_minisite_stmt || '; END;'

Line 1320: IBE_UTIL.debug('Mapping rule: p_max_ret_num is NULL: relationship NOT in MTL: l_include_self_ref is FALSE.');

1316: END IF;
1317: END IF;
1318: ELSE -- exclude self referral
1319: IF (l_debug = 'Y') THEN
1320: IBE_UTIL.debug('Mapping rule: p_max_ret_num is NULL: relationship NOT in MTL: l_include_self_ref is FALSE.');
1321: END IF;
1322: IF FND_API.to_Boolean(l_preview_flag) THEN --preview mode
1323: IF (p_item_ids.LAST > 1) THEN -- multiple items
1324: EXECUTE IMMEDIATE l_pv_wout_mtl_bulk_mult_stmt || l_minisite_stmt ||

Line 1357: IBE_UTIL.debug('Mapping rule: relationship in MTL: l_include_self_ref is TRUE.');

1353:
1354: IF FND_API.to_Boolean( l_include_self_ref ) THEN -- include self referral
1355:
1356: IF (l_debug = 'Y') THEN
1357: IBE_UTIL.debug('Mapping rule: relationship in MTL: l_include_self_ref is TRUE.');
1358:
1359: END IF;
1360: IF FND_API.to_Boolean(l_preview_flag) THEN -- preview mode
1361: IF (p_item_ids.LAST > 1) THEN --multiple items

Line 1413: IBE_UTIL.debug('Mapping rule: relationship in MTL: l_include_self_ref is FALSE.');

1409: END IF;
1410: ELSE -- exclude self referral
1411:
1412: IF (l_debug = 'Y') THEN
1413: IBE_UTIL.debug('Mapping rule: relationship in MTL: l_include_self_ref is FALSE.');
1414: END IF;
1415:
1416: IF FND_API.to_Boolean(l_preview_flag) THEN -- preview mode
1417: IF (p_item_ids.LAST > 1) THEN --multiple items

Line 1449: IBE_UTIL.debug('B4 QUERY '||l_dummy||'type code '||p_rel_type_code ||'key '||l_temp_key||'org id '||p_org_id||'msite id' ||p_msite_id);

1445: END IF;
1446: ELSE -- Cust UI Mode
1447: SELECT COUNT(*) INTO l_dummy from ibe_temp_table;
1448: IF (l_debug = 'Y') THEN
1449: IBE_UTIL.debug('B4 QUERY '||l_dummy||'type code '||p_rel_type_code ||'key '||l_temp_key||'org id '||p_org_id||'msite id' ||p_msite_id);
1450: END IF;
1451:
1452: IF (p_item_ids.LAST > 1) THEN --multiple items
1453: OPEN l_rel_items_csr FOR l_with_mtl_mult_stmt1 ||

Line 1467: IBE_UTIL.debug('Mapping rule: relationship in MTL: l_include_self_ref is FALSE. finished query'|| l_rel_items_csr%ROWCOUNT);

1463: p_rel_type_code, l_temp_key, p_org_id, l_temp_key,
1464: p_rel_type_code, l_temp_key, p_org_id, l_temp_key ,
1465: p_rel_type_code, l_temp_key, p_org_id; --Bug 2922902
1466: IF (l_debug = 'Y') THEN
1467: IBE_UTIL.debug('Mapping rule: relationship in MTL: l_include_self_ref is FALSE. finished query'|| l_rel_items_csr%ROWCOUNT);
1468: END IF;
1469:
1470: ELSE --single item
1471: OPEN l_rel_items_csr FOR l_with_mtl_stmt1 ||

Line 1490: IBE_UTIL.debug('Mapping rule: p_max_ret_num is NOT NULL: relationship NOT in MTL: l_include_self_ref is TRUE.');

1486: END IF; --exclude self- referral
1487: ELSE -- don't need to do union with mtl_related_items
1488: IF FND_API.to_Boolean( l_include_self_ref ) THEN -- include self referral
1489: IF (l_debug = 'Y') THEN
1490: IBE_UTIL.debug('Mapping rule: p_max_ret_num is NOT NULL: relationship NOT in MTL: l_include_self_ref is TRUE.');
1491: END IF;
1492:
1493: IF FND_API.to_Boolean(l_preview_flag) THEN -- preview mode
1494: IF (p_item_ids.LAST > 1) THEN --multiple items

Line 1512: IBE_UTIL.debug('Mapping rule: p_max_ret_num is NOT NULL: relationship NOT in MTL: l_include_self_ref is FALSE.');

1508: END IF;
1509: END IF;
1510: ELSE -- exclude self referral
1511: IF (l_debug = 'Y') THEN
1512: IBE_UTIL.debug('Mapping rule: p_max_ret_num is NOT NULL: relationship NOT in MTL: l_include_self_ref is FALSE.');
1513: END IF;
1514:
1515: IF FND_API.to_Boolean(l_preview_flag) THEN -- preview mode
1516: IF (p_item_ids.LAST > 1) THEN --multiple items

Line 1564: l_status := IBE_UTIL.delete_from_temp_table(l_temp_key);

1560: END IF;
1561: END IF;
1562:
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;

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 ,