97: /* */
98: /* This routine returns TRUE if successful; otherwise, it returns FALSE */
99: /* */
100: /* In case of failure, this routine will populate the global Message Stack */
101: /* using FND_MESSAGE. The calling routine will retrieve the message from */
102: /* the Stack */
103: /* */
104: /* External Packages which are being invoked include : */
105: /* */
555:
556: p_batch_result_code := NULL;
557:
558: IF ( g_unexp_level >= g_debug_level ) THEN
559: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
560: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
561: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
562: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
563: END IF;
556: p_batch_result_code := NULL;
557:
558: IF ( g_unexp_level >= g_debug_level ) THEN
559: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
560: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
561: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
562: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
563: END IF;
564:
557:
558: IF ( g_unexp_level >= g_debug_level ) THEN
559: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
560: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
561: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
562: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
563: END IF;
564:
565: RETURN (FALSE);
867: Put_Debug_Msg(l_full_path, 'No records with result code, H-code is null');
868: END IF;
869:
870: IF ( g_unexp_level >= g_debug_level ) THEN
871: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
872: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
873: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
874: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
875: END IF;
868: END IF;
869:
870: IF ( g_unexp_level >= g_debug_level ) THEN
871: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
872: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
873: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
874: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
875: END IF;
876:
869:
870: IF ( g_unexp_level >= g_debug_level ) THEN
871: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
872: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
873: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
874: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
875: END IF;
876:
877: RETURN '';