DBA Data[Home] [Help]

APPS.IBE_PROD_RELATION_PVT dependencies on FND_MESSAGE

Line 94: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_NOT_CREATED');

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;
97: WHEN OTHERS THEN
98: IF (l_debug = 'Y') THEN

Line 101: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_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);
104: FND_MESSAGE.Set_Token('REASON', SQLERRM);
105: FND_MSG_PUB.Add;

Line 102: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

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);
104: FND_MESSAGE.Set_Token('REASON', SQLERRM);
105: FND_MSG_PUB.Add;
106:

Line 103: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

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);
104: FND_MESSAGE.Set_Token('REASON', SQLERRM);
105: FND_MSG_PUB.Add;
106:
107: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_NOT_CREATED');

Line 104: FND_MESSAGE.Set_Token('REASON', SQLERRM);

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);
104: FND_MESSAGE.Set_Token('REASON', SQLERRM);
105: FND_MSG_PUB.Add;
106:
107: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_NOT_CREATED');
108: FND_MSG_PUB.Add;

Line 107: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_NOT_CREATED');

103: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
104: FND_MESSAGE.Set_Token('REASON', SQLERRM);
105: FND_MSG_PUB.Add;
106:
107: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_NOT_CREATED');
108: FND_MSG_PUB.Add;
109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
110: END;
111:

Line 240: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_NOT_EXIST');

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;
243: WHEN OTHERS THEN
244: IF (l_debug = 'Y') THEN

Line 247: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_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);
250: FND_MESSAGE.Set_Token('REASON', SQLERRM);
251: FND_MSG_PUB.Add;

Line 248: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

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);
250: FND_MESSAGE.Set_Token('REASON', SQLERRM);
251: FND_MSG_PUB.Add;
252:

Line 249: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

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);
250: FND_MESSAGE.Set_Token('REASON', SQLERRM);
251: FND_MSG_PUB.Add;
252:
253: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_NOT_EXIST');

Line 250: FND_MESSAGE.Set_Token('REASON', SQLERRM);

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);
250: FND_MESSAGE.Set_Token('REASON', SQLERRM);
251: FND_MSG_PUB.Add;
252:
253: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_NOT_EXIST');
254: FND_MSG_PUB.Add;

Line 253: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_NOT_EXIST');

249: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
250: FND_MESSAGE.Set_Token('REASON', SQLERRM);
251: FND_MSG_PUB.Add;
252:
253: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_NOT_EXIST');
254: FND_MSG_PUB.Add;
255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
256: END;
257:

Line 387: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_NOT_EXIST');

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;
390: WHEN OTHERS THEN
391: IF (l_debug = 'Y') THEN

Line 394: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_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);
397: FND_MESSAGE.Set_Token('REASON', SQLERRM);
398: FND_MSG_PUB.Add;

Line 395: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

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);
397: FND_MESSAGE.Set_Token('REASON', SQLERRM);
398: FND_MSG_PUB.Add;
399:

Line 396: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

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);
397: FND_MESSAGE.Set_Token('REASON', SQLERRM);
398: FND_MSG_PUB.Add;
399:
400: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_NOT_EXIST');

Line 397: FND_MESSAGE.Set_Token('REASON', SQLERRM);

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);
397: FND_MESSAGE.Set_Token('REASON', SQLERRM);
398: FND_MSG_PUB.Add;
399:
400: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_NOT_EXIST');
401: FND_MSG_PUB.Add;

Line 400: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_NOT_EXIST');

396: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
397: FND_MESSAGE.Set_Token('REASON', SQLERRM);
398: FND_MSG_PUB.Add;
399:
400: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_NOT_EXIST');
401: FND_MSG_PUB.Add;
402: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
403: END;
404:

Line 510: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_NOT_EXIST');

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;
513: WHEN OTHERS THEN
514: IF (l_debug = 'Y') THEN

Line 517: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_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);
520: FND_MESSAGE.Set_Token('REASON', SQLERRM);
521: FND_MSG_PUB.Add;

Line 518: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

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);
520: FND_MESSAGE.Set_Token('REASON', SQLERRM);
521: FND_MSG_PUB.Add;
522:

Line 519: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

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);
520: FND_MESSAGE.Set_Token('REASON', SQLERRM);
521: FND_MSG_PUB.Add;
522:
523: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_NOT_EXIST');

Line 520: FND_MESSAGE.Set_Token('REASON', SQLERRM);

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);
520: FND_MESSAGE.Set_Token('REASON', SQLERRM);
521: FND_MSG_PUB.Add;
522:
523: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_NOT_EXIST');
524: FND_MSG_PUB.Add;

Line 523: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_NOT_EXIST');

519: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
520: FND_MESSAGE.Set_Token('REASON', SQLERRM);
521: FND_MSG_PUB.Add;
522:
523: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_NOT_EXIST');
524: FND_MSG_PUB.Add;
525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
526: END;
527: