171:
172: FND_MESSAGE.Set_Name('GMI','GMI_SQL_ERROR');
173: FND_MESSAGE.Set_Token('SQL_CODE', err_num);
174: FND_MESSAGE.Set_Token('SQL_ERRM', sqlerrm);
175: FND_MSG_PUB.Add;
176:
177:
178: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
179: , 'insert_ic_tran_pnd'
174: FND_MESSAGE.Set_Token('SQL_ERRM', sqlerrm);
175: FND_MSG_PUB.Add;
176:
177:
178: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
179: , 'insert_ic_tran_pnd'
180: );
181: RETURN FALSE;
182:
348:
349: WHEN OTHERS THEN
350:
351:
352: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
353: , 'fetch_ic_tran_pnd'
354: );
355: RETURN FALSE;
356:
387:
388: WHEN OTHERS THEN
389:
390:
391: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
392: , 'delete_ic_tran_pnd'
393: );
394: RETURN FALSE;
395:
457: RETURN FALSE;
458:
459: WHEN OTHERS THEN
460:
461: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
462: , 'UPDATE_ic_tran_pnd'
463: );
464: RETURN FALSE;
465: