1548: print_debuginfo(l_module_name, 'EXIT');
1549:
1550: EXCEPTION
1551: WHEN OTHERS THEN
1552: FND_MESSAGE.SET_NAME('IBY', '');
1553: FND_MESSAGE.SET_TOKEN('SQLERR','applyDocumentValidationSets: '
1554: || substr(SQLERRM, 1, 300));
1555: FND_MSG_PUB.Add;
1556: print_debuginfo(l_module_name,substr(SQLERRM, 1, 300),
1549:
1550: EXCEPTION
1551: WHEN OTHERS THEN
1552: FND_MESSAGE.SET_NAME('IBY', '');
1553: FND_MESSAGE.SET_TOKEN('SQLERR','applyDocumentValidationSets: '
1554: || substr(SQLERRM, 1, 300));
1555: FND_MSG_PUB.Add;
1556: print_debuginfo(l_module_name,substr(SQLERRM, 1, 300),
1557: FND_LOG.LEVEL_UNEXPECTED);
2796: print_debuginfo(l_module_name, 'EXIT');
2797:
2798: EXCEPTION
2799: WHEN OTHERS THEN
2800: FND_MESSAGE.SET_NAME('IBY', '');
2801: FND_MESSAGE.SET_TOKEN('SQLERR','initDocumentData : '||
2802: substr(SQLERRM, 1, 300));
2803: FND_MSG_PUB.Add;
2804: print_debuginfo(l_module_name,' '||
2797:
2798: EXCEPTION
2799: WHEN OTHERS THEN
2800: FND_MESSAGE.SET_NAME('IBY', '');
2801: FND_MESSAGE.SET_TOKEN('SQLERR','initDocumentData : '||
2802: substr(SQLERRM, 1, 300));
2803: FND_MSG_PUB.Add;
2804: print_debuginfo(l_module_name,' '||
2805: substr(SQLERRM, 1, 300), FND_LOG.LEVEL_UNEXPECTED);
3010: CLOSE c_charval_fields;
3011:
3012: EXCEPTION
3013: WHEN OTHERS THEN
3014: FND_MESSAGE.SET_NAME('IBY', '');
3015: FND_MESSAGE.SET_TOKEN('SQLERR','initCharValData: '
3016: || substr(SQLERRM, 1, 300));
3017: FND_MSG_PUB.Add;
3018: print_debuginfo(l_module_name,' '
3011:
3012: EXCEPTION
3013: WHEN OTHERS THEN
3014: FND_MESSAGE.SET_NAME('IBY', '');
3015: FND_MESSAGE.SET_TOKEN('SQLERR','initCharValData: '
3016: || substr(SQLERRM, 1, 300));
3017: FND_MSG_PUB.Add;
3018: print_debuginfo(l_module_name,' '
3019: || substr(SQLERRM, 1, 300), FND_LOG.LEVEL_UNEXPECTED);
3102: CLOSE c_payment_rec;
3103:
3104: EXCEPTION
3105: WHEN OTHERS THEN
3106: FND_MESSAGE.SET_NAME('IBY', '');
3107: FND_MESSAGE.SET_TOKEN('SQLERR','initPaymentData : '||
3108: substr(SQLERRM, 1, 300));
3109: FND_MSG_PUB.Add;
3110: print_debuginfo(l_module_name,' '||
3103:
3104: EXCEPTION
3105: WHEN OTHERS THEN
3106: FND_MESSAGE.SET_NAME('IBY', '');
3107: FND_MESSAGE.SET_TOKEN('SQLERR','initPaymentData : '||
3108: substr(SQLERRM, 1, 300));
3109: FND_MSG_PUB.Add;
3110: print_debuginfo(l_module_name,' '||
3111: substr(SQLERRM, 1, 300), FND_LOG.LEVEL_UNEXPECTED);
3196: CLOSE c_instruction_rec;
3197:
3198: EXCEPTION
3199: WHEN OTHERS THEN
3200: FND_MESSAGE.SET_NAME('IBY', '');
3201: FND_MESSAGE.SET_TOKEN('SQLERR','initInstructionData : '||
3202: substr(SQLERRM, 1, 300));
3203: FND_MSG_PUB.Add;
3204: print_debuginfo(l_module_name,' '||
3197:
3198: EXCEPTION
3199: WHEN OTHERS THEN
3200: FND_MESSAGE.SET_NAME('IBY', '');
3201: FND_MESSAGE.SET_TOKEN('SQLERR','initInstructionData : '||
3202: substr(SQLERRM, 1, 300));
3203: FND_MSG_PUB.Add;
3204: print_debuginfo(l_module_name,' '||
3205: substr(SQLERRM, 1, 300), FND_LOG.LEVEL_UNEXPECTED);
3752: -- Need to raise Business Event here with error information
3753: --
3754: EXCEPTION
3755: WHEN OTHERS THEN
3756: FND_MESSAGE.SET_NAME('IBY', '');
3757: FND_MESSAGE.SET_TOKEN('SQLERR',
3758: 'insert_transaction_errors : ' || SQLERRM);
3759: FND_MSG_PUB.Add;
3760: print_debuginfo(l_module_name, SQLERRM, FND_LOG.LEVEL_UNEXPECTED);
3753: --
3754: EXCEPTION
3755: WHEN OTHERS THEN
3756: FND_MESSAGE.SET_NAME('IBY', '');
3757: FND_MESSAGE.SET_TOKEN('SQLERR',
3758: 'insert_transaction_errors : ' || SQLERRM);
3759: FND_MSG_PUB.Add;
3760: print_debuginfo(l_module_name, SQLERRM, FND_LOG.LEVEL_UNEXPECTED);
3761: RAISE g_abort_program;
3946: FROM fnd_lookups
3947: WHERE lookup_type = 'IBY_VALIDATION_FIELDS'
3948: AND lookup_code = p_object_code;
3949:
3950: FND_MESSAGE.SET_NAME('IBY', p_msg_name);
3951: FND_MESSAGE.SET_TOKEN('ERR_OBJECT', l_msg_token, false);
3952: p_message := fnd_message.get;
3953:
3954: EXCEPTION
3947: WHERE lookup_type = 'IBY_VALIDATION_FIELDS'
3948: AND lookup_code = p_object_code;
3949:
3950: FND_MESSAGE.SET_NAME('IBY', p_msg_name);
3951: FND_MESSAGE.SET_TOKEN('ERR_OBJECT', l_msg_token, false);
3952: p_message := fnd_message.get;
3953:
3954: EXCEPTION
3955: WHEN OTHERS THEN
3948: AND lookup_code = p_object_code;
3949:
3950: FND_MESSAGE.SET_NAME('IBY', p_msg_name);
3951: FND_MESSAGE.SET_TOKEN('ERR_OBJECT', l_msg_token, false);
3952: p_message := fnd_message.get;
3953:
3954: EXCEPTION
3955: WHEN OTHERS THEN
3956: print_debuginfo(G_PKG_NAME || '.retrieveErrorMSG',
4280: RETURN;
4281:
4282: EXCEPTION
4283: WHEN OTHERS THEN
4284: FND_MESSAGE.SET_NAME('IBY', '');
4285: FND_MESSAGE.SET_TOKEN('SQLERR','evaluateCondition : '||
4286: substr(SQLERRM, 1, 300));
4287: FND_MSG_PUB.Add;
4288: print_debuginfo(l_module_name,' '||
4281:
4282: EXCEPTION
4283: WHEN OTHERS THEN
4284: FND_MESSAGE.SET_NAME('IBY', '');
4285: FND_MESSAGE.SET_TOKEN('SQLERR','evaluateCondition : '||
4286: substr(SQLERRM, 1, 300));
4287: FND_MSG_PUB.Add;
4288: print_debuginfo(l_module_name,' '||
4289: substr(SQLERRM, 1, 300), FND_LOG.LEVEL_UNEXPECTED);