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

Line 44: IBE_UTIL.debug('IBE_Prod_Relation_Rule_PVT.Insert_SQL_Rule(+)');

40: -- Initialize API return status to success
41: x_return_status := FND_API.G_RET_STS_SUCCESS;
42:
43: IF (l_debug = 'Y') THEN
44: IBE_UTIL.debug('IBE_Prod_Relation_Rule_PVT.Insert_SQL_Rule(+)');
45: END IF;
46: -- API body
47: IF NOT Is_SQL_Valid( p_sql_statement ) THEN
48: IF (l_debug = 'Y') THEN

Line 49: IBE_UTIL.debug('Invalid SQL statement');

45: END IF;
46: -- API body
47: IF NOT Is_SQL_Valid( p_sql_statement ) THEN
48: IF (l_debug = 'Y') THEN
49: IBE_UTIL.debug('Invalid SQL statement');
50: END IF;
51: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_INVALID_SQL_RULE');
52: FND_MSG_PUB.Add;
53: RAISE FND_API.G_EXC_ERROR;

Line 71: IBE_UTIL.debug('Failed to insert the SQL rule.');

67: );
68:
69: IF SQL%NOTFOUND THEN
70: IF (l_debug = 'Y') THEN
71: IBE_UTIL.debug('Failed to insert the SQL rule.');
72: END IF;
73: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_RULE_NOT_CREATED');
74: FND_MSG_PUB.Add;
75: RAISE FND_API.G_EXC_ERROR;

Line 79: IBE_UTIL.debug('IBE_Prod_Relation_Rule_PVT.Insert_SQL_Rule(-)');

75: RAISE FND_API.G_EXC_ERROR;
76: END IF;
77: -- End of API body.
78: IF (l_debug = 'Y') THEN
79: IBE_UTIL.debug('IBE_Prod_Relation_Rule_PVT.Insert_SQL_Rule(-)');
80: END IF;
81:
82: -- Standard check of p_commit.
83: IF FND_API.To_Boolean( p_commit ) THEN

Line 168: IBE_UTIL.debug('IBE_Prod_Relation_Rule_PVT.Insert_Mapping_Rules(+)');

164: -- Initialize API return status to success
165: x_return_status := FND_API.G_RET_STS_SUCCESS;
166:
167: IF (l_debug = 'Y') THEN
168: IBE_UTIL.debug('IBE_Prod_Relation_Rule_PVT.Insert_Mapping_Rules(+)');
169: END IF;
170: -- API body
171: IF FND_API.to_Boolean( p_preview ) THEN
172: IF (l_debug = 'Y') THEN

Line 173: IBE_UTIL.debug('Inserting the mapping rules from the Preview page.');

169: END IF;
170: -- API body
171: IF FND_API.to_Boolean( p_preview ) THEN
172: IF (l_debug = 'Y') THEN
173: IBE_UTIL.debug('Inserting the mapping rules from the Preview page.');
174: END IF;
175: FOR i IN 1..p_origin_object_type_tbl.COUNT LOOP
176: BEGIN
177: INSERT INTO IBE_CT_RELATION_RULES(

Line 213: IBE_UTIL.debug('Inserting the mapping rules from the Create Rules page.');

209: END;
210: END LOOP;
211: ELSE
212: IF (l_debug = 'Y') THEN
213: IBE_UTIL.debug('Inserting the mapping rules from the Create Rules page.');
214: END IF;
215: FOR i IN 1..p_origin_object_type_tbl.COUNT LOOP
216: FOR j IN 1..p_dest_object_type_tbl.COUNT LOOP
217: BEGIN

Line 256: IBE_UTIL.debug('IBE_Prod_Relation_Rule_PVT.Insert_Mapping_Rules(-)');

252: END LOOP;
253: END IF;
254: -- End of API body.
255: IF (l_debug = 'Y') THEN
256: IBE_UTIL.debug('IBE_Prod_Relation_Rule_PVT.Insert_Mapping_Rules(-)');
257: END IF;
258:
259: -- Standard check of p_commit.
260: IF FND_API.To_Boolean( p_commit ) THEN

Line 339: IBE_UTIL.debug('IBE_Prod_Relation_Rule_PVT.Update_Rule(+)');

335: -- Initialize API return status to success
336: x_return_status := FND_API.G_RET_STS_SUCCESS;
337:
338: IF (l_debug = 'Y') THEN
339: IBE_UTIL.debug('IBE_Prod_Relation_Rule_PVT.Update_Rule(+)');
340: END IF;
341: -- API body
342: IF p_sql_statement IS NOT NULL AND
343: NOT Is_SQL_Valid( p_sql_statement ) THEN

Line 345: IBE_UTIL.debug('Invalid SQL statement.');

341: -- API body
342: IF p_sql_statement IS NOT NULL AND
343: NOT Is_SQL_Valid( p_sql_statement ) THEN
344: IF (l_debug = 'Y') THEN
345: IBE_UTIL.debug('Invalid SQL statement.');
346: END IF;
347: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_INVALID_SQL_RULE');
348: FND_MSG_PUB.Add;
349: RAISE FND_API.G_EXC_ERROR;

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

356: AND object_version_number = p_obj_ver_num;
357:
358: IF SQL%NOTFOUND THEN
359: IF (l_debug = 'Y') THEN
360: IBE_UTIL.debug('Update statement failed.');
361: END IF;
362: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_RULE_NOT_UPDATED');
363: FND_MSG_PUB.Add;
364: RAISE FND_API.G_EXC_ERROR;

Line 368: IBE_UTIL.debug('IBE_Prod_Relation_Rule_PVT.Update_Rule(-)');

364: RAISE FND_API.G_EXC_ERROR;
365: END IF;
366: -- End of API body.
367: IF (l_debug = 'Y') THEN
368: IBE_UTIL.debug('IBE_Prod_Relation_Rule_PVT.Update_Rule(-)');
369: END IF;
370:
371: -- Standard check of p_commit.
372: IF FND_API.To_Boolean( p_commit ) THEN

Line 449: IBE_UTIL.debug('IBE_Prod_Relation_Rule_PVT.Delete_Rule(+)');

445: -- Initialize API return status to success
446: x_return_status := FND_API.G_RET_STS_SUCCESS;
447:
448: IF (l_debug = 'Y') THEN
449: IBE_UTIL.debug('IBE_Prod_Relation_Rule_PVT.Delete_Rule(+)');
450: END IF;
451: -- API body
452: IF (l_debug = 'Y') THEN
453: IBE_UTIL.debug('Deleting rows in IBE_CT_RELATION_RULES.');

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

449: IBE_UTIL.debug('IBE_Prod_Relation_Rule_PVT.Delete_Rule(+)');
450: END IF;
451: -- API body
452: IF (l_debug = 'Y') THEN
453: IBE_UTIL.debug('Deleting rows in IBE_CT_RELATION_RULES.');
454: END IF;
455: FORALL i IN p_rel_rule_id_tbl.FIRST..p_rel_rule_id_tbl.LAST
456: DELETE
457: FROM ibe_ct_relation_rules

Line 463: IBE_UTIL.debug('Failed delete statement for IBE_CT_RELATION_RULES.');

459: AND object_version_number = p_obj_ver_num_tbl(i);
460:
461: IF SQL%NOTFOUND THEN
462: IF (l_debug = 'Y') THEN
463: IBE_UTIL.debug('Failed delete statement for IBE_CT_RELATION_RULES.');
464: END IF;
465: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_RULE_NOT_DELETED');
466: FND_MSG_PUB.Add;
467: RAISE FND_API.G_EXC_ERROR;

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

467: RAISE FND_API.G_EXC_ERROR;
468: END IF;
469:
470: IF (l_debug = 'Y') THEN
471: IBE_UTIL.debug('Deleting rows in IBE_CT_RELATED_ITEMS.');
472: END IF;
473: FORALL i IN p_rel_rule_id_tbl.FIRST..p_rel_rule_id_tbl.LAST
474: DELETE
475: FROM ibe_ct_related_items

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

475: FROM ibe_ct_related_items
476: WHERE relation_rule_id = p_rel_rule_id_tbl(i);
477:
478: IF (l_debug = 'Y') THEN
479: IBE_UTIL.debug('Deleting rows in IBE_CT_REL_EXCLUSIONS.');
480: END IF;
481: IBE_Prod_Relation_PVT.Remove_Invalid_Exclusions();
482: -- End of API body.
483: IF (l_debug = 'Y') THEN

Line 484: IBE_UTIL.debug('IBE_Prod_Relation_Rule_PVT.Delete_Rule(-)');

480: END IF;
481: IBE_Prod_Relation_PVT.Remove_Invalid_Exclusions();
482: -- End of API body.
483: IF (l_debug = 'Y') THEN
484: IBE_UTIL.debug('IBE_Prod_Relation_Rule_PVT.Delete_Rule(-)');
485: END IF;
486:
487: -- Standard check of p_commit.
488: IF FND_API.To_Boolean( p_commit ) THEN