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
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;
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:
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');
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;
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:
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
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;
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:
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');
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;
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:
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
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;
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:
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');
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;
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:
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
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;
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:
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');
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;
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: