232: END IF; -- end of IF ( l_flag = 1 )
233:
234: EXCEPTION
235: WHEN OTHERS THEN
236: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
237: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
238: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'After Insert trigger');
239: FND_MESSAGE.SET_TOKEN('PARAMETERS','Not Applicable');
240: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
233:
234: EXCEPTION
235: WHEN OTHERS THEN
236: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
237: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
238: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'After Insert trigger');
239: FND_MESSAGE.SET_TOKEN('PARAMETERS','Not Applicable');
240: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
241: RAISE_APPLICATION_ERROR(-20010, fnd_message.get);
234: EXCEPTION
235: WHEN OTHERS THEN
236: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
237: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
238: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'After Insert trigger');
239: FND_MESSAGE.SET_TOKEN('PARAMETERS','Not Applicable');
240: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
241: RAISE_APPLICATION_ERROR(-20010, fnd_message.get);
242:
235: WHEN OTHERS THEN
236: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
237: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
238: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'After Insert trigger');
239: FND_MESSAGE.SET_TOKEN('PARAMETERS','Not Applicable');
240: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
241: RAISE_APPLICATION_ERROR(-20010, fnd_message.get);
242:
243: END;
236: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
237: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
238: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'After Insert trigger');
239: FND_MESSAGE.SET_TOKEN('PARAMETERS','Not Applicable');
240: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
241: RAISE_APPLICATION_ERROR(-20010, fnd_message.get);
242:
243: END;
237: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
238: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'After Insert trigger');
239: FND_MESSAGE.SET_TOKEN('PARAMETERS','Not Applicable');
240: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
241: RAISE_APPLICATION_ERROR(-20010, fnd_message.get);
242:
243: END;