508: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
509: p_data => X_msg_data );
510:
511: IF ( g_unexp_level >= g_debug_level ) THEN
512: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
513: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
514: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
515: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
516: END IF;
509: p_data => X_msg_data );
510:
511: IF ( g_unexp_level >= g_debug_level ) THEN
512: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
513: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
514: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
515: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
516: END IF;
517:
510:
511: IF ( g_unexp_level >= g_debug_level ) THEN
512: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
513: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
514: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
515: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
516: END IF;
517:
518: END Insert_Row;
948:
949: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
950: p_data => X_msg_data );
951: IF ( g_unexp_level >= g_debug_level ) THEN
952: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
953: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
954: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
955: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
956: END IF;
949: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
950: p_data => X_msg_data );
951: IF ( g_unexp_level >= g_debug_level ) THEN
952: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
953: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
954: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
955: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
956: END IF;
957:
950: p_data => X_msg_data );
951: IF ( g_unexp_level >= g_debug_level ) THEN
952: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
953: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
954: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
955: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
956: END IF;
957:
958: END Insert_Row;
1081: INTO Recinfo;
1082:
1083: IF (C%NOTFOUND) THEN
1084: CLOSE C;
1085: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
1086: FND_MSG_PUB.Add;
1087: IF (g_excep_level >= g_debug_level ) THEN
1088: FND_LOG.MESSAGE (g_excep_level ,l_full_path,FALSE);
1089: END IF;
1226: g_debug_msg := ' IGCCHDRB -- Failed Lock Row Header ID .....' || p_cc_header_id;
1227: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
1228: END IF;
1229:
1230: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1231: FND_MSG_PUB.Add;
1232: IF (g_excep_level >= g_debug_level ) THEN
1233: FND_LOG.MESSAGE (g_excep_level , l_full_path,FALSE);
1234: END IF;
1324:
1325: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
1326: p_data => X_msg_data );
1327: IF ( g_unexp_level >= g_debug_level ) THEN
1328: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
1329: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1330: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1331: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
1332: END IF;
1325: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
1326: p_data => X_msg_data );
1327: IF ( g_unexp_level >= g_debug_level ) THEN
1328: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
1329: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1330: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1331: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
1332: END IF;
1333:
1326: p_data => X_msg_data );
1327: IF ( g_unexp_level >= g_debug_level ) THEN
1328: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
1329: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1330: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1331: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
1332: END IF;
1333:
1334: END Lock_Row;
1688:
1689: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
1690: p_data => X_msg_data );
1691: IF ( g_unexp_level >= g_debug_level ) THEN
1692: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
1693: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1694: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1695: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
1696: END IF;
1689: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
1690: p_data => X_msg_data );
1691: IF ( g_unexp_level >= g_debug_level ) THEN
1692: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
1693: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1694: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1695: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
1696: END IF;
1697:
1690: p_data => X_msg_data );
1691: IF ( g_unexp_level >= g_debug_level ) THEN
1692: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
1693: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1694: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1695: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
1696: END IF;
1697:
1698: END Update_Row;
2050: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
2051: p_data => X_msg_data );
2052:
2053: IF ( g_unexp_level >= g_debug_level ) THEN
2054: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
2055: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
2056: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
2057: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
2058: END IF;
2051: p_data => X_msg_data );
2052:
2053: IF ( g_unexp_level >= g_debug_level ) THEN
2054: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
2055: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
2056: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
2057: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
2058: END IF;
2059:
2052:
2053: IF ( g_unexp_level >= g_debug_level ) THEN
2054: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
2055: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
2056: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
2057: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
2058: END IF;
2059:
2060:
2568:
2569: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
2570: p_data => X_msg_data );
2571: IF ( g_unexp_level >= g_debug_level ) THEN
2572: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
2573: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
2574: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
2575: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
2576: END IF;
2569: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
2570: p_data => X_msg_data );
2571: IF ( g_unexp_level >= g_debug_level ) THEN
2572: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
2573: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
2574: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
2575: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
2576: END IF;
2577:
2570: p_data => X_msg_data );
2571: IF ( g_unexp_level >= g_debug_level ) THEN
2572: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
2573: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
2574: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
2575: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
2576: END IF;
2577:
2578: