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_PVT dependencies on IBE_UTIL

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 92: IBE_UTIL.debug('Insert statement failed.');

88:
89: EXCEPTION
90: WHEN NO_DATA_FOUND THEN
91: IF (l_debug = 'Y') THEN
92: IBE_UTIL.debug('Insert statement failed.');
93: END IF;
94: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_NOT_CREATED');
95: FND_MSG_PUB.Add;
96: RAISE FND_API.G_EXC_ERROR;

Line 99: IBE_UTIL.debug('Insert statement failed.');

95: FND_MSG_PUB.Add;
96: RAISE FND_API.G_EXC_ERROR;
97: WHEN OTHERS THEN
98: IF (l_debug = 'Y') THEN
99: IBE_UTIL.debug('Insert statement failed.');
100: END IF;
101: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
102: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
103: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

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 238: IBE_UTIL.debug('Update statement failed.');

234: );
235: EXCEPTION
236: WHEN NO_DATA_FOUND THEN
237: IF (l_debug = 'Y') THEN
238: IBE_UTIL.debug('Update statement failed.');
239: END IF;
240: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_NOT_EXIST');
241: FND_MSG_PUB.Add;
242: RAISE FND_API.G_EXC_ERROR;

Line 245: IBE_UTIL.debug('Update statement failed.');

241: FND_MSG_PUB.Add;
242: RAISE FND_API.G_EXC_ERROR;
243: WHEN OTHERS THEN
244: IF (l_debug = 'Y') THEN
245: IBE_UTIL.debug('Update statement failed.');
246: END IF;
247: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
248: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
249: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

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 385: IBE_UTIL.debug('Update statement failed.');

381: );
382: EXCEPTION
383: WHEN NO_DATA_FOUND THEN
384: IF (l_debug = 'Y') THEN
385: IBE_UTIL.debug('Update statement failed.');
386: END IF;
387: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_NOT_EXIST');
388: FND_MSG_PUB.Add;
389: RAISE FND_API.G_EXC_ERROR;

Line 392: IBE_UTIL.debug('Update statement failed.');

388: FND_MSG_PUB.Add;
389: RAISE FND_API.G_EXC_ERROR;
390: WHEN OTHERS THEN
391: IF (l_debug = 'Y') THEN
392: IBE_UTIL.debug('Update statement failed.');
393: END IF;
394: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
395: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
396: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

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 508: IBE_UTIL.debug('Delete statement failed.');

504:
505: EXCEPTION
506: WHEN NO_DATA_FOUND THEN
507: IF (l_debug = 'Y') THEN
508: IBE_UTIL.debug('Delete statement failed.');
509: END IF;
510: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_NOT_EXIST');
511: FND_MSG_PUB.Add;
512: RAISE FND_API.G_EXC_ERROR;

Line 515: IBE_UTIL.debug('Delete statement failed.');

511: FND_MSG_PUB.Add;
512: RAISE FND_API.G_EXC_ERROR;
513: WHEN OTHERS THEN
514: IF (l_debug = 'Y') THEN
515: IBE_UTIL.debug('Delete statement failed.');
516: END IF;
517: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
518: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
519: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

Line 531: IBE_UTIL.debug('Deleting rows in IBE_CT_RELATION_RULES.');

527:
528: END LOOP;
529:
530: IF (l_debug = 'Y') THEN
531: IBE_UTIL.debug('Deleting rows in IBE_CT_RELATION_RULES.');
532: END IF;
533: FORALL i IN p_rel_type_code_tbl.FIRST..p_rel_type_code_tbl.LAST
534: DELETE
535: FROM ibe_ct_relation_rules

Line 539: IBE_UTIL.debug('Deleting rows in IBE_CT_RELATED_ITEMS.');

535: FROM ibe_ct_relation_rules
536: WHERE relation_type_code = p_rel_type_code_tbl(i);
537:
538: IF (l_debug = 'Y') THEN
539: IBE_UTIL.debug('Deleting rows in IBE_CT_RELATED_ITEMS.');
540: END IF;
541: FORALL i IN p_rel_type_code_tbl.FIRST..p_rel_type_code_tbl.LAST
542: DELETE
543: FROM ibe_ct_related_items

Line 547: IBE_UTIL.debug('Deleting rows in IBE_CT_REL_EXCLUSIONS.');

543: FROM ibe_ct_related_items
544: WHERE relation_type_code = p_rel_type_code_tbl(i);
545:
546: IF (l_debug = 'Y') THEN
547: IBE_UTIL.debug('Deleting rows in IBE_CT_REL_EXCLUSIONS.');
548: END IF;
549: FORALL i IN p_rel_type_code_tbl.FIRST..p_rel_type_code_tbl.LAST
550: DELETE
551: FROM ibe_ct_rel_exclusions

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 834: IBE_UTIL.debug('Category set id from the profile = '||l_category_set_id_str);

830: l_debug := NVL(FND_PROFILE.VALUE('IBE_DEBUG'),'N');
831:
832: l_category_set_id_str := FND_PROFILE.VALUE_SPECIFIC('IBE_CATEGORY_SET', null, null, 671);
833: IF (l_debug = 'Y') THEN
834: IBE_UTIL.debug('Category set id from the profile = '||l_category_set_id_str);
835: END IF;
836:
837: IF p_origin_object_type = 'N' AND p_dest_object_type = 'N' THEN
838: NULL;