DBA Data[Home] [Help]

APPS.IBE_PROD_RELATION_RULE_PVT dependencies on FND_MESSAGE

Line 51: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_INVALID_SQL_RULE');

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;
54: END IF;
55:

Line 73: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_RULE_NOT_CREATED');

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;
76: END IF;
77: -- End of API body.

Line 192: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_RULE_NOT_CREATED');

188: )
189: RETURNING relation_rule_id INTO l_rule_id;
190:
191: IF SQL%NOTFOUND THEN
192: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_RULE_NOT_CREATED');
193: FND_MSG_PUB.Add;
194: RAISE FND_API.G_EXC_ERROR;
195: END IF;
196: -- bug fix 3676064

Line 233: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_RULE_NOT_CREATED');

229: )
230: RETURNING relation_rule_id INTO l_rule_id;
231:
232: IF SQL%NOTFOUND THEN
233: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_RULE_NOT_CREATED');
234: FND_MSG_PUB.Add;
235: RAISE FND_API.G_EXC_ERROR;
236: END IF;
237: -- bug fix 3676064

Line 347: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_INVALID_SQL_RULE');

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;
350: END IF;
351:

Line 362: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_RULE_NOT_UPDATED');

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;
365: END IF;
366: -- End of API body.

Line 465: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_RULE_NOT_DELETED');

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;
468: END IF;
469: