APPS.IGC_CC_BUDGETARY_CTRL_PKG dependencies on FND_MESSAGE

Line 246: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

242: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
243: p_data => X_msg_data );
244:
245: IF ( g_unexp_level >= g_debug_level ) THEN
246: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
247: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
248: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
249: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
250: END IF;

Line 247: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

243: p_data => X_msg_data );
244:
245: IF ( g_unexp_level >= g_debug_level ) THEN
246: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
247: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
248: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
249: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
250: END IF;
251: RETURN;

Line 248: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

244:
245: IF ( g_unexp_level >= g_debug_level ) THEN
246: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
247: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
248: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
249: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
250: END IF;
251: RETURN;
252:

Line 356: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

352: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
353: p_data => X_msg_data );
354:
355: IF ( g_unexp_level >= g_debug_level ) THEN
356: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
357: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
358: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
359: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
360: END IF;

Line 357: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

353: p_data => X_msg_data );
354:
355: IF ( g_unexp_level >= g_debug_level ) THEN
356: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
357: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
358: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
359: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
360: END IF;
361: RETURN;

Line 358: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

354:
355: IF ( g_unexp_level >= g_debug_level ) THEN
356: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
357: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
358: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
359: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
360: END IF;
361: RETURN;
362:

Line 482: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

478: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
479: p_data => X_msg_data );
480:
481: IF ( g_unexp_level >= g_debug_level ) THEN
482: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
483: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
484: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
485: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
486: END IF;

Line 483: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

479: p_data => X_msg_data );
480:
481: IF ( g_unexp_level >= g_debug_level ) THEN
482: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
483: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
484: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
485: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
486: END IF;
487: RETURN;

Line 484: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

480:
481: IF ( g_unexp_level >= g_debug_level ) THEN
482: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
483: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
484: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
485: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
486: END IF;
487: RETURN;
488:

Line 868: fnd_message.set_name('IGC', 'IGC_INVALID_CC_HEADER_STATE');

864:
865: -- --------------------------------------------------------------------------------------
866: -- Unknown CC State in the Header record so abort the process for the Account Lines.
867: -- --------------------------------------------------------------------------------------
868: fnd_message.set_name('IGC', 'IGC_INVALID_CC_HEADER_STATE');
869: fnd_message.set_token('HEADER_STATE', l_cc_headers_rec.cc_state);
870: fnd_message.set_token('CC_NUM_VAL', l_cc_headers_rec.cc_num);
871: IF(g_error_level >= g_debug_level) THEN
872: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);

Line 869: fnd_message.set_token('HEADER_STATE', l_cc_headers_rec.cc_state);

865: -- --------------------------------------------------------------------------------------
866: -- Unknown CC State in the Header record so abort the process for the Account Lines.
867: -- --------------------------------------------------------------------------------------
868: fnd_message.set_name('IGC', 'IGC_INVALID_CC_HEADER_STATE');
869: fnd_message.set_token('HEADER_STATE', l_cc_headers_rec.cc_state);
870: fnd_message.set_token('CC_NUM_VAL', l_cc_headers_rec.cc_num);
871: IF(g_error_level >= g_debug_level) THEN
872: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
873: END IF;

Line 870: fnd_message.set_token('CC_NUM_VAL', l_cc_headers_rec.cc_num);

866: -- Unknown CC State in the Header record so abort the process for the Account Lines.
867: -- --------------------------------------------------------------------------------------
868: fnd_message.set_name('IGC', 'IGC_INVALID_CC_HEADER_STATE');
869: fnd_message.set_token('HEADER_STATE', l_cc_headers_rec.cc_state);
870: fnd_message.set_token('CC_NUM_VAL', l_cc_headers_rec.cc_num);
871: IF(g_error_level >= g_debug_level) THEN
872: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
873: END IF;
874: fnd_msg_pub.add;

Line 1077: fnd_message.set_name('IGC', 'IGC_INVALID_CC_HEADER_STATE');

1073:
1074: -- -----------------------------------------------------------------------------
1075: -- Unknown CC State in the Header record for the Det PF update. Exit Process.
1076: -- -----------------------------------------------------------------------------
1077: fnd_message.set_name('IGC', 'IGC_INVALID_CC_HEADER_STATE');
1078: fnd_message.set_token('HEADER_STATE', l_cc_headers_rec.cc_state);
1079: fnd_message.set_token('CC_NUM_VAL', l_cc_headers_rec.cc_num);
1080: IF(g_error_level >= g_debug_level) THEN
1081: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);

Line 1078: fnd_message.set_token('HEADER_STATE', l_cc_headers_rec.cc_state);

1074: -- -----------------------------------------------------------------------------
1075: -- Unknown CC State in the Header record for the Det PF update. Exit Process.
1076: -- -----------------------------------------------------------------------------
1077: fnd_message.set_name('IGC', 'IGC_INVALID_CC_HEADER_STATE');
1078: fnd_message.set_token('HEADER_STATE', l_cc_headers_rec.cc_state);
1079: fnd_message.set_token('CC_NUM_VAL', l_cc_headers_rec.cc_num);
1080: IF(g_error_level >= g_debug_level) THEN
1081: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
1082: END IF;

Line 1079: fnd_message.set_token('CC_NUM_VAL', l_cc_headers_rec.cc_num);

1075: -- Unknown CC State in the Header record for the Det PF update. Exit Process.
1076: -- -----------------------------------------------------------------------------
1077: fnd_message.set_name('IGC', 'IGC_INVALID_CC_HEADER_STATE');
1078: fnd_message.set_token('HEADER_STATE', l_cc_headers_rec.cc_state);
1079: fnd_message.set_token('CC_NUM_VAL', l_cc_headers_rec.cc_num);
1080: IF(g_error_level >= g_debug_level) THEN
1081: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
1082: END IF;
1083: fnd_msg_pub.add;

Line 1147: fnd_message.set_name('IGC', 'IGC_INVALID_CC_HEADER_STATE');

1143:
1144: -- -----------------------------------------------------------------------------
1145: -- Unknown CC State in the Header record for the Header update. Exit Process.
1146: -- -----------------------------------------------------------------------------
1147: fnd_message.set_name('IGC', 'IGC_INVALID_CC_HEADER_STATE');
1148: fnd_message.set_token('HEADER_STATE', l_cc_headers_rec.cc_state);
1149: fnd_message.set_token('CC_NUM_VAL', l_cc_headers_rec.cc_num);
1150: IF(g_error_level >= g_debug_level) THEN
1151: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);

Line 1148: fnd_message.set_token('HEADER_STATE', l_cc_headers_rec.cc_state);

1144: -- -----------------------------------------------------------------------------
1145: -- Unknown CC State in the Header record for the Header update. Exit Process.
1146: -- -----------------------------------------------------------------------------
1147: fnd_message.set_name('IGC', 'IGC_INVALID_CC_HEADER_STATE');
1148: fnd_message.set_token('HEADER_STATE', l_cc_headers_rec.cc_state);
1149: fnd_message.set_token('CC_NUM_VAL', l_cc_headers_rec.cc_num);
1150: IF(g_error_level >= g_debug_level) THEN
1151: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
1152: END IF;

Line 1149: fnd_message.set_token('CC_NUM_VAL', l_cc_headers_rec.cc_num);

1145: -- Unknown CC State in the Header record for the Header update. Exit Process.
1146: -- -----------------------------------------------------------------------------
1147: fnd_message.set_name('IGC', 'IGC_INVALID_CC_HEADER_STATE');
1148: fnd_message.set_token('HEADER_STATE', l_cc_headers_rec.cc_state);
1149: fnd_message.set_token('CC_NUM_VAL', l_cc_headers_rec.cc_num);
1150: IF(g_error_level >= g_debug_level) THEN
1151: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
1152: END IF;
1153: fnd_msg_pub.add;

Line 1283: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

1279:
1280: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1281: p_data => x_msg_data );
1282: IF ( g_unexp_level >= g_debug_level ) THEN
1283: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
1284: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1285: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1286: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
1287: END IF;

Line 1284: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

1280: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1281: p_data => x_msg_data );
1282: IF ( g_unexp_level >= g_debug_level ) THEN
1283: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
1284: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1285: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1286: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
1287: END IF;
1288:

Line 1285: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

1281: p_data => x_msg_data );
1282: IF ( g_unexp_level >= g_debug_level ) THEN
1283: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
1284: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1285: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1286: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
1287: END IF;
1288:
1289: END Execute_Rel_Budgetary_Ctrl;

Line 1418: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

1414:
1415: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1416: p_data => x_msg_data );
1417: IF ( g_unexp_level >= g_debug_level ) THEN
1418: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
1419: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1420: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1421: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
1422: END IF;

Line 1419: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

1415: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1416: p_data => x_msg_data );
1417: IF ( g_unexp_level >= g_debug_level ) THEN
1418: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
1419: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1420: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1421: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
1422: END IF;
1423:

Line 1420: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

1416: p_data => x_msg_data );
1417: IF ( g_unexp_level >= g_debug_level ) THEN
1418: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
1419: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1420: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1421: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
1422: END IF;
1423:
1424: END Insert_Interface_Row;

Line 1998: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

1994: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1995: p_data => x_msg_data );
1996:
1997: IF ( g_unexp_level >= g_debug_level ) THEN
1998: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
1999: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
2000: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
2001: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
2002: END IF;

Line 1999: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

1995: p_data => x_msg_data );
1996:
1997: IF ( g_unexp_level >= g_debug_level ) THEN
1998: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
1999: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
2000: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
2001: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
2002: END IF;
2003: RETURN;

Line 2000: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

1996:
1997: IF ( g_unexp_level >= g_debug_level ) THEN
1998: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
1999: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
2000: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
2001: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
2002: END IF;
2003: RETURN;
2004:

Line 2325: fnd_message.set_name('IGC', 'IGC_CC_INVALID_MODE');

2321: l_update_by := FND_GLOBAL.USER_ID;
2322:
2323: IF ( (p_mode <> 'C') AND (p_mode <> 'R') )
2324: THEN
2325: fnd_message.set_name('IGC', 'IGC_CC_INVALID_MODE');
2326: fnd_message.set_token('MODE', p_mode,TRUE);
2327: IF(g_error_level >= g_debug_level) THEN
2328: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
2329: END IF;

Line 2326: fnd_message.set_token('MODE', p_mode,TRUE);

2322:
2323: IF ( (p_mode <> 'C') AND (p_mode <> 'R') )
2324: THEN
2325: fnd_message.set_name('IGC', 'IGC_CC_INVALID_MODE');
2326: fnd_message.set_token('MODE', p_mode,TRUE);
2327: IF(g_error_level >= g_debug_level) THEN
2328: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
2329: END IF;
2330: fnd_msg_pub.add;

Line 2345: fnd_message.set_name('IGC', 'IGC_CC_NOT_FOUND');

2341: l_encumbrance_status_old := l_cc_headers_rec.cc_encmbrnc_status;
2342: EXCEPTION
2343: WHEN OTHERS
2344: THEN
2345: fnd_message.set_name('IGC', 'IGC_CC_NOT_FOUND');
2346: fnd_message.set_token('CC_NUM', to_char(p_cc_header_id),TRUE);
2347: IF(g_error_level >= g_debug_level) THEN
2348: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
2349: END IF;

Line 2346: fnd_message.set_token('CC_NUM', to_char(p_cc_header_id),TRUE);

2342: EXCEPTION
2343: WHEN OTHERS
2344: THEN
2345: fnd_message.set_name('IGC', 'IGC_CC_NOT_FOUND');
2346: fnd_message.set_token('CC_NUM', to_char(p_cc_header_id),TRUE);
2347: IF(g_error_level >= g_debug_level) THEN
2348: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
2349: END IF;
2350: fnd_msg_pub.add;

Line 2406: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

2402: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
2403: l_api_name);
2404: END IF;
2405: IF ( g_unexp_level >= g_debug_level ) THEN
2406: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
2407: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
2408: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
2409: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
2410: END IF;

Line 2407: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

2403: l_api_name);
2404: END IF;
2405: IF ( g_unexp_level >= g_debug_level ) THEN
2406: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
2407: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
2408: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
2409: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
2410: END IF;
2411: RAISE E_DELETE;

Line 2408: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

2404: END IF;
2405: IF ( g_unexp_level >= g_debug_level ) THEN
2406: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
2407: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
2408: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
2409: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
2410: END IF;
2411: RAISE E_DELETE;
2412: END;

Line 2462: fnd_message.set_name('IGC', 'IGC_CC_INVALID_GL_DATA');

2458: WHERE set_of_books_id = l_cc_headers_rec.set_of_books_id;
2459: EXCEPTION
2460: WHEN NO_DATA_FOUND
2461: THEN
2462: fnd_message.set_name('IGC', 'IGC_CC_INVALID_GL_DATA');
2463: IF(g_error_level >= g_debug_level) THEN
2464: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
2465: END IF;
2466: fnd_msg_pub.add;

Line 2544: fnd_message.set_name('IGC', 'IGC_CC_NOT_FOUND');

2540: FROM igc_cc_headers
2541: WHERE cc_header_id = p_cc_header_id;
2542: EXCEPTION
2543: WHEN OTHERS THEN
2544: fnd_message.set_name('IGC', 'IGC_CC_NOT_FOUND');
2545: fnd_message.set_token('CC_NUM', to_char(p_cc_header_id),TRUE);
2546: IF(g_error_level >= g_debug_level) THEN
2547: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
2548: END IF;

Line 2545: fnd_message.set_token('CC_NUM', to_char(p_cc_header_id),TRUE);

2541: WHERE cc_header_id = p_cc_header_id;
2542: EXCEPTION
2543: WHEN OTHERS THEN
2544: fnd_message.set_name('IGC', 'IGC_CC_NOT_FOUND');
2545: fnd_message.set_token('CC_NUM', to_char(p_cc_header_id),TRUE);
2546: IF(g_error_level >= g_debug_level) THEN
2547: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
2548: END IF;
2549: fnd_msg_pub.add;

Line 3353: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

3349: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
3350: l_api_name);
3351: END IF;
3352: IF ( g_unexp_level >= g_debug_level ) THEN
3353: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
3354: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
3355: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
3356: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
3357: END IF;

Line 3354: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

3350: l_api_name);
3351: END IF;
3352: IF ( g_unexp_level >= g_debug_level ) THEN
3353: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
3354: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
3355: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
3356: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
3357: END IF;
3358:

Line 3355: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

3351: END IF;
3352: IF ( g_unexp_level >= g_debug_level ) THEN
3353: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
3354: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
3355: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
3356: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
3357: END IF;
3358:
3359: RAISE E_UPDATE_CC_TABLES;

Line 3642: fnd_message.set_name('IGC', 'IGC_CC_CBC_RESULT_CODE_INVALID');

3638: IF ( (l_batch_result_code IS NOT NULL) AND (l_interface_row_count <> 0) )
3639: THEN
3640: IF (l_batch_result_code = 'HXX')
3641: THEN
3642: fnd_message.set_name('IGC', 'IGC_CC_CBC_RESULT_CODE_INVALID');
3643: IF(g_state_level >= g_debug_level) THEN
3644: FND_LOG.MESSAGE(g_state_level, l_full_path, FALSE);
3645: END IF;
3646: fnd_msg_pub.add;

Line 3648: fnd_message.set_name('IGC', 'IGC_CC_CBC_RESULT_CODE_'||l_batch_result_code);

3644: FND_LOG.MESSAGE(g_state_level, l_full_path, FALSE);
3645: END IF;
3646: fnd_msg_pub.add;
3647: ELSE
3648: fnd_message.set_name('IGC', 'IGC_CC_CBC_RESULT_CODE_'||l_batch_result_code);
3649: IF(g_state_level >= g_debug_level) THEN
3650: FND_LOG.MESSAGE(g_state_level, l_full_path, FALSE);
3651: END IF;
3652: fnd_msg_pub.add;

Line 3963: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

3959:
3960: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3961: p_data => x_msg_data );
3962: IF ( g_unexp_level >= g_debug_level ) THEN
3963: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
3964: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
3965: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
3966: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
3967: END IF;

Line 3964: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

3960: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3961: p_data => x_msg_data );
3962: IF ( g_unexp_level >= g_debug_level ) THEN
3963: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
3964: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
3965: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
3966: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
3967: END IF;
3968:

Line 3965: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

3961: p_data => x_msg_data );
3962: IF ( g_unexp_level >= g_debug_level ) THEN
3963: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
3964: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
3965: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
3966: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
3967: END IF;
3968:
3969: END Execute_Budgetary_Ctrl;

Line 4027: fnd_message.set_name('IGC', 'IGC_CC_NO_ORG_ID');

4023: END IF;
4024:
4025: IF (p_org_id IS NULL)
4026: THEN
4027: fnd_message.set_name('IGC', 'IGC_CC_NO_ORG_ID');
4028: IF(g_error_level >= g_debug_level) THEN
4029: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
4030: END IF;
4031: fnd_msg_pub.add;

Line 4037: fnd_message.set_name('IGC', 'IGC_CC_NO_SOB_ID');

4033: END IF;
4034:
4035: IF (p_sob_id IS NULL)
4036: THEN
4037: fnd_message.set_name('IGC', 'IGC_CC_NO_SOB_ID');
4038: IF(g_error_level >= g_debug_level) THEN
4039: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
4040: END IF;
4041: fnd_msg_pub.add;

Line 4047: fnd_message.set_name('IGC', 'IGC_CC_NO_CC_STATE');

4043: END IF;
4044:
4045: IF (p_cc_state IS NULL)
4046: THEN
4047: fnd_message.set_name('IGC', 'IGC_CC_NO_CC_STATE');
4048: IF(g_error_level >= g_debug_level) THEN
4049: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
4050: END IF;
4051: fnd_msg_pub.add;

Line 4068: fnd_message.set_name('IGC', 'IGC_CC_INVALID_GL_DATA');

4064: EXCEPTION
4065:
4066: WHEN NO_DATA_FOUND
4067: THEN
4068: fnd_message.set_name('IGC', 'IGC_CC_INVALID_GL_DATA');
4069: IF(g_error_level >= g_debug_level) THEN
4070: FND_LOG.MESSAGE(g_error_level, l_full_path || 'Msg4', FALSE);
4071: END IF;
4072: fnd_msg_pub.add;

Line 4164: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

4160:
4161: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
4162: p_data => x_msg_data );
4163: IF ( g_unexp_level >= g_debug_level ) THEN
4164: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
4165: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
4166: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
4167: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
4168: END IF;

Line 4165: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

4161: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
4162: p_data => x_msg_data );
4163: IF ( g_unexp_level >= g_debug_level ) THEN
4164: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
4165: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
4166: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
4167: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
4168: END IF;
4169:

Line 4166: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

4162: p_data => x_msg_data );
4163: IF ( g_unexp_level >= g_debug_level ) THEN
4164: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
4165: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
4166: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
4167: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
4168: END IF;
4169:
4170: END Check_Budgetary_Ctrl_On;

Line 4389: fnd_message.set_name('IGC', 'IGC_CC_INVALID_STATUS_CODE');

4385:
4386: IF ( (NVL(p_encumbrance_status_code,'X') <> 'P') AND
4387: (NVL(p_encumbrance_status_code,'X') <> 'T') )
4388: THEN
4389: fnd_message.set_name('IGC', 'IGC_CC_INVALID_STATUS_CODE');
4390: fnd_message.set_token('CODE', p_encumbrance_status_code,TRUE);
4391: IF(g_error_level >= g_debug_level) THEN
4392: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
4393: END IF;

Line 4390: fnd_message.set_token('CODE', p_encumbrance_status_code,TRUE);

4386: IF ( (NVL(p_encumbrance_status_code,'X') <> 'P') AND
4387: (NVL(p_encumbrance_status_code,'X') <> 'T') )
4388: THEN
4389: fnd_message.set_name('IGC', 'IGC_CC_INVALID_STATUS_CODE');
4390: fnd_message.set_token('CODE', p_encumbrance_status_code,TRUE);
4391: IF(g_error_level >= g_debug_level) THEN
4392: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
4393: END IF;
4394: fnd_msg_pub.add;

Line 4410: fnd_message.set_name('IGC', 'IGC_CC_NOT_FOUND');

4406: EXCEPTION
4407:
4408: WHEN no_data_found
4409: THEN
4410: fnd_message.set_name('IGC', 'IGC_CC_NOT_FOUND');
4411: fnd_message.set_token('CC_NUM', to_char(p_cc_header_id),TRUE);
4412: IF(g_excep_level >= g_debug_level) THEN
4413: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
4414: END IF;

Line 4411: fnd_message.set_token('CC_NUM', to_char(p_cc_header_id),TRUE);

4407:
4408: WHEN no_data_found
4409: THEN
4410: fnd_message.set_name('IGC', 'IGC_CC_NOT_FOUND');
4411: fnd_message.set_token('CC_NUM', to_char(p_cc_header_id),TRUE);
4412: IF(g_excep_level >= g_debug_level) THEN
4413: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
4414: END IF;
4415: fnd_msg_pub.add;

Line 4642: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

4638:
4639: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
4640: p_data => x_msg_data );
4641: IF ( g_unexp_level >= g_debug_level ) THEN
4642: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
4643: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
4644: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
4645: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
4646: END IF;

Line 4643: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

4639: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
4640: p_data => x_msg_data );
4641: IF ( g_unexp_level >= g_debug_level ) THEN
4642: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
4643: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
4644: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
4645: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
4646: END IF;
4647:

Line 4644: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

4640: p_data => x_msg_data );
4641: IF ( g_unexp_level >= g_debug_level ) THEN
4642: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
4643: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
4644: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
4645: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
4646: END IF;
4647:
4648: END Set_Encumbrance_Status;

Line 4888: fnd_message.set_name('IGC', 'IGC_CC_INVALID_GL_DATA');

4884: EXCEPTION
4885: WHEN NO_DATA_FOUND THEN
4886: x_valid_cc := FND_API.G_FALSE;
4887: x_return_status := FND_API.G_RET_STS_ERROR;
4888: fnd_message.set_name('IGC', 'IGC_CC_INVALID_GL_DATA');
4889: IF(g_error_level >= g_debug_level) THEN
4890: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
4891: END IF;
4892: fnd_msg_pub.add;

Line 4958: fnd_message.set_name('IGC', 'IGC_CC_EFFECTIVE_START_DATE');

4954: IF (p_end_date IS NOT NULL) THEN
4955: IF p_end_date < p_start_date THEN
4956: x_valid_cc := FND_API.G_FALSE;
4957: x_return_status := FND_API.G_RET_STS_ERROR;
4958: fnd_message.set_name('IGC', 'IGC_CC_EFFECTIVE_START_DATE');
4959: fnd_message.set_token('STARTDATE',FND_DATE.DATE_TO_CHARDATE (P_START_DATE),FALSE);
4960: IF(g_state_level >= g_debug_level) THEN
4961: FND_LOG.MESSAGE(g_state_level, l_full_path, FALSE);
4962: END IF;

Line 4959: fnd_message.set_token('STARTDATE',FND_DATE.DATE_TO_CHARDATE (P_START_DATE),FALSE);

4955: IF p_end_date < p_start_date THEN
4956: x_valid_cc := FND_API.G_FALSE;
4957: x_return_status := FND_API.G_RET_STS_ERROR;
4958: fnd_message.set_name('IGC', 'IGC_CC_EFFECTIVE_START_DATE');
4959: fnd_message.set_token('STARTDATE',FND_DATE.DATE_TO_CHARDATE (P_START_DATE),FALSE);
4960: IF(g_state_level >= g_debug_level) THEN
4961: FND_LOG.MESSAGE(g_state_level, l_full_path, FALSE);
4962: END IF;
4963: fnd_msg_pub.add;

Line 4995: fnd_message.set_name('IGC', 'IGC_CC_EFF_CCPER_START_DATE');

4991:
4992: IF (NVL(l_COUNT,0) = 0) THEN
4993: x_valid_cc := FND_API.G_FALSE;
4994: x_return_status := FND_API.G_RET_STS_ERROR;
4995: fnd_message.set_name('IGC', 'IGC_CC_EFF_CCPER_START_DATE');
4996: fnd_message.set_token('STARTDATE', FND_DATE.DATE_TO_CHARDATE (P_START_DATE),FALSE);
4997: IF(g_state_level >= g_debug_level) THEN
4998: FND_LOG.MESSAGE(g_state_level, l_full_path, FALSE);
4999: END IF;

Line 4996: fnd_message.set_token('STARTDATE', FND_DATE.DATE_TO_CHARDATE (P_START_DATE),FALSE);

4992: IF (NVL(l_COUNT,0) = 0) THEN
4993: x_valid_cc := FND_API.G_FALSE;
4994: x_return_status := FND_API.G_RET_STS_ERROR;
4995: fnd_message.set_name('IGC', 'IGC_CC_EFF_CCPER_START_DATE');
4996: fnd_message.set_token('STARTDATE', FND_DATE.DATE_TO_CHARDATE (P_START_DATE),FALSE);
4997: IF(g_state_level >= g_debug_level) THEN
4998: FND_LOG.MESSAGE(g_state_level, l_full_path, FALSE);
4999: END IF;
5000: fnd_msg_pub.add;

Line 5035: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

5031: EXCEPTION
5032: WHEN OTHERS THEN
5033: l_COUNT := 0;
5034: IF ( g_unexp_level >= g_debug_level ) THEN
5035: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
5036: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
5037: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
5038: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
5039: END IF;

Line 5036: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

5032: WHEN OTHERS THEN
5033: l_COUNT := 0;
5034: IF ( g_unexp_level >= g_debug_level ) THEN
5035: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
5036: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
5037: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
5038: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
5039: END IF;
5040: END;

Line 5037: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

5033: l_COUNT := 0;
5034: IF ( g_unexp_level >= g_debug_level ) THEN
5035: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
5036: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
5037: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
5038: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
5039: END IF;
5040: END;
5041:

Line 5045: fnd_message.set_name('IGC', 'IGC_CC_EFF_CCGLPER_START_DATE');

5041:
5042: IF (NVL(l_COUNT,0) = 0) THEN
5043: x_valid_cc := FND_API.G_FALSE;
5044: x_return_status := FND_API.G_RET_STS_ERROR;
5045: fnd_message.set_name('IGC', 'IGC_CC_EFF_CCGLPER_START_DATE');
5046: fnd_message.set_token('STARTDATE',FND_DATE.DATE_TO_CHARDATE(p_start_date),FALSE);
5047: IF(g_error_level >= g_debug_level) THEN
5048: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5049: END IF;

Line 5046: fnd_message.set_token('STARTDATE',FND_DATE.DATE_TO_CHARDATE(p_start_date),FALSE);

5042: IF (NVL(l_COUNT,0) = 0) THEN
5043: x_valid_cc := FND_API.G_FALSE;
5044: x_return_status := FND_API.G_RET_STS_ERROR;
5045: fnd_message.set_name('IGC', 'IGC_CC_EFF_CCGLPER_START_DATE');
5046: fnd_message.set_token('STARTDATE',FND_DATE.DATE_TO_CHARDATE(p_start_date),FALSE);
5047: IF(g_error_level >= g_debug_level) THEN
5048: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5049: END IF;
5050: fnd_msg_pub.add;

Line 5073: fnd_message.set_name('IGC', 'IGC_CC_EFF_COVER_START_DATE');

5069: IF (p_start_date > NVL(l_min_rel_start_date,p_start_date) )
5070: THEN
5071: x_valid_cc := FND_API.G_FALSE;
5072: x_return_status := FND_API.G_RET_STS_ERROR;
5073: fnd_message.set_name('IGC', 'IGC_CC_EFF_COVER_START_DATE');
5074: fnd_message.set_token('STARTDATE',FND_DATE.DATE_TO_CHARDATE(P_START_DATE),FALSE);
5075: IF(g_error_level >= g_debug_level) THEN
5076: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5077: END IF;

Line 5074: fnd_message.set_token('STARTDATE',FND_DATE.DATE_TO_CHARDATE(P_START_DATE),FALSE);

5070: THEN
5071: x_valid_cc := FND_API.G_FALSE;
5072: x_return_status := FND_API.G_RET_STS_ERROR;
5073: fnd_message.set_name('IGC', 'IGC_CC_EFF_COVER_START_DATE');
5074: fnd_message.set_token('STARTDATE',FND_DATE.DATE_TO_CHARDATE(P_START_DATE),FALSE);
5075: IF(g_error_level >= g_debug_level) THEN
5076: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5077: END IF;
5078: fnd_msg_pub.add;

Line 5099: fnd_message.set_name('IGC', 'IGC_CC_EFF_REL_START_DATE');

5095: IF (p_start_date < NVL(l_cover_start_date,p_start_date) )
5096: THEN
5097: x_valid_cc := FND_API.G_FALSE;
5098: x_return_status := FND_API.G_RET_STS_ERROR;
5099: fnd_message.set_name('IGC', 'IGC_CC_EFF_REL_START_DATE');
5100: fnd_message.set_token('STARTDATE',FND_DATE.DATE_TO_CHARDATE (P_START_DATE),FALSE);
5101: IF(g_error_level >= g_debug_level) THEN
5102: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5103: END IF;

Line 5100: fnd_message.set_token('STARTDATE',FND_DATE.DATE_TO_CHARDATE (P_START_DATE),FALSE);

5096: THEN
5097: x_valid_cc := FND_API.G_FALSE;
5098: x_return_status := FND_API.G_RET_STS_ERROR;
5099: fnd_message.set_name('IGC', 'IGC_CC_EFF_REL_START_DATE');
5100: fnd_message.set_token('STARTDATE',FND_DATE.DATE_TO_CHARDATE (P_START_DATE),FALSE);
5101: IF(g_error_level >= g_debug_level) THEN
5102: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5103: END IF;
5104: fnd_msg_pub.add;

Line 5111: fnd_message.set_name('IGC', 'IGC_CC_NO_START_DATE');

5107:
5108: ELSIF ( p_start_date IS NULL) THEN
5109: x_valid_cc := FND_API.G_FALSE;
5110: x_return_status := FND_API.G_RET_STS_ERROR;
5111: fnd_message.set_name('IGC', 'IGC_CC_NO_START_DATE');
5112: IF(g_error_level >= g_debug_level) THEN
5113: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5114: END IF;
5115: fnd_msg_pub.add;

Line 5126: fnd_message.set_name('IGC', 'IGC_CC_EFFECTIVE_END_DATE');

5122:
5123: IF p_end_date < p_start_date THEN
5124: x_valid_cc := FND_API.G_FALSE;
5125: x_return_status := FND_API.G_RET_STS_ERROR;
5126: fnd_message.set_name('IGC', 'IGC_CC_EFFECTIVE_END_DATE');
5127: fnd_message.set_token('STARTDATE',FND_DATE.DATE_TO_CHARDATE (P_START_DATE),FALSE);
5128: fnd_message.set_token('ENDDATE',FND_DATE.DATE_TO_CHARDATE (P_END_DATE),FALSE);
5129: IF(g_error_level >= g_debug_level) THEN
5130: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);

Line 5127: fnd_message.set_token('STARTDATE',FND_DATE.DATE_TO_CHARDATE (P_START_DATE),FALSE);

5123: IF p_end_date < p_start_date THEN
5124: x_valid_cc := FND_API.G_FALSE;
5125: x_return_status := FND_API.G_RET_STS_ERROR;
5126: fnd_message.set_name('IGC', 'IGC_CC_EFFECTIVE_END_DATE');
5127: fnd_message.set_token('STARTDATE',FND_DATE.DATE_TO_CHARDATE (P_START_DATE),FALSE);
5128: fnd_message.set_token('ENDDATE',FND_DATE.DATE_TO_CHARDATE (P_END_DATE),FALSE);
5129: IF(g_error_level >= g_debug_level) THEN
5130: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5131: END IF;

Line 5128: fnd_message.set_token('ENDDATE',FND_DATE.DATE_TO_CHARDATE (P_END_DATE),FALSE);

5124: x_valid_cc := FND_API.G_FALSE;
5125: x_return_status := FND_API.G_RET_STS_ERROR;
5126: fnd_message.set_name('IGC', 'IGC_CC_EFFECTIVE_END_DATE');
5127: fnd_message.set_token('STARTDATE',FND_DATE.DATE_TO_CHARDATE (P_START_DATE),FALSE);
5128: fnd_message.set_token('ENDDATE',FND_DATE.DATE_TO_CHARDATE (P_END_DATE),FALSE);
5129: IF(g_error_level >= g_debug_level) THEN
5130: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5131: END IF;
5132: fnd_msg_pub.add;

Line 5152: fnd_message.set_name('IGC', 'IGC_CC_EFF_COVER_END_DATE');

5148: IF (p_end_date < NVL(l_max_rel_end_date,p_end_date) )
5149: THEN
5150: x_valid_cc := FND_API.G_FALSE;
5151: x_return_status := FND_API.G_RET_STS_ERROR;
5152: fnd_message.set_name('IGC', 'IGC_CC_EFF_COVER_END_DATE');
5153: IF(g_error_level >= g_debug_level) THEN
5154: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5155: END IF;
5156: fnd_msg_pub.add;

Line 5176: fnd_message.set_name('IGC', 'IGC_CC_EFF_REL_END_DATE');

5172: IF (p_end_date > NVL(l_cover_end_date,p_end_date) )
5173: THEN
5174: x_valid_cc := FND_API.G_FALSE;
5175: x_return_status := FND_API.G_RET_STS_ERROR;
5176: fnd_message.set_name('IGC', 'IGC_CC_EFF_REL_END_DATE');
5177: IF(g_error_level >= g_debug_level) THEN
5178: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5179: END IF;
5180: fnd_msg_pub.add;

Line 5195: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_START_DATE');

5191:
5192: IF (p_cc_det_pf_date < p_start_date) THEN
5193: x_valid_cc := FND_API.G_FALSE;
5194: x_return_status := FND_API.G_RET_STS_ERROR;
5195: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_START_DATE');
5196: fnd_message.set_token('PFDATE',FND_DATE.DATE_TO_CHARDATE(p_cc_det_pf_date),FALSE);
5197: IF(g_error_level >= g_debug_level) THEN
5198: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5199: END IF;

Line 5196: fnd_message.set_token('PFDATE',FND_DATE.DATE_TO_CHARDATE(p_cc_det_pf_date),FALSE);

5192: IF (p_cc_det_pf_date < p_start_date) THEN
5193: x_valid_cc := FND_API.G_FALSE;
5194: x_return_status := FND_API.G_RET_STS_ERROR;
5195: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_START_DATE');
5196: fnd_message.set_token('PFDATE',FND_DATE.DATE_TO_CHARDATE(p_cc_det_pf_date),FALSE);
5197: IF(g_error_level >= g_debug_level) THEN
5198: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5199: END IF;
5200: fnd_msg_pub.add;

Line 5207: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_END_DATE');

5203: (p_end_date IS NOT NULL)
5204: ) THEN
5205: x_valid_cc := FND_API.G_FALSE;
5206: x_return_status := FND_API.G_RET_STS_ERROR;
5207: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_END_DATE');
5208: fnd_message.set_token('PFDATE',FND_DATE.DATE_TO_CHARDATE(p_cc_det_pf_date),FALSE);
5209: IF(g_error_level >= g_debug_level) THEN
5210: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5211: END IF;

Line 5208: fnd_message.set_token('PFDATE',FND_DATE.DATE_TO_CHARDATE(p_cc_det_pf_date),FALSE);

5204: ) THEN
5205: x_valid_cc := FND_API.G_FALSE;
5206: x_return_status := FND_API.G_RET_STS_ERROR;
5207: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_END_DATE');
5208: fnd_message.set_token('PFDATE',FND_DATE.DATE_TO_CHARDATE(p_cc_det_pf_date),FALSE);
5209: IF(g_error_level >= g_debug_level) THEN
5210: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5211: END IF;
5212: fnd_msg_pub.add;

Line 5240: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

5236: EXCEPTION
5237: WHEN OTHERS THEN
5238: l_COUNT := 0;
5239: IF ( g_unexp_level >= g_debug_level ) THEN
5240: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
5241: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
5242: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
5243: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
5244: END IF;

Line 5241: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

5237: WHEN OTHERS THEN
5238: l_COUNT := 0;
5239: IF ( g_unexp_level >= g_debug_level ) THEN
5240: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
5241: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
5242: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
5243: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
5244: END IF;
5245: END;

Line 5242: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

5238: l_COUNT := 0;
5239: IF ( g_unexp_level >= g_debug_level ) THEN
5240: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
5241: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
5242: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
5243: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
5244: END IF;
5245: END;
5246: IF NVL(l_COUNT,0) = 0 THEN

Line 5249: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_DATE');

5245: END;
5246: IF NVL(l_COUNT,0) = 0 THEN
5247: x_valid_cc := FND_API.G_FALSE;
5248: x_return_status := FND_API.G_RET_STS_ERROR;
5249: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_DATE');
5250: IF(g_error_level >= g_debug_level) THEN
5251: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5252: END IF;
5253: fnd_msg_pub.add;

Line 5275: fnd_message.set_name('IGC', 'IGC_CC_ACCT_DATE');

5271: p_prev_acct_date IS NOT NULL)
5272: THEN
5273: x_valid_cc := FND_API.G_FALSE;
5274: x_return_status := FND_API.G_RET_STS_ERROR;
5275: fnd_message.set_name('IGC', 'IGC_CC_ACCT_DATE');
5276: fnd_message.set_token('ACCTDATE',FND_DATE.DATE_TO_CHARDATE(P_ACCT_DATE),FALSE);
5277: fnd_message.set_token('STARTDATE',FND_DATE.DATE_TO_CHARDATE(P_START_DATE),FALSE);
5278: fnd_message.set_token('ENDDATE',FND_DATE.DATE_TO_CHARDATE(P_END_DATE),FALSE);
5279: IF(g_error_level >= g_debug_level) THEN

Line 5276: fnd_message.set_token('ACCTDATE',FND_DATE.DATE_TO_CHARDATE(P_ACCT_DATE),FALSE);

5272: THEN
5273: x_valid_cc := FND_API.G_FALSE;
5274: x_return_status := FND_API.G_RET_STS_ERROR;
5275: fnd_message.set_name('IGC', 'IGC_CC_ACCT_DATE');
5276: fnd_message.set_token('ACCTDATE',FND_DATE.DATE_TO_CHARDATE(P_ACCT_DATE),FALSE);
5277: fnd_message.set_token('STARTDATE',FND_DATE.DATE_TO_CHARDATE(P_START_DATE),FALSE);
5278: fnd_message.set_token('ENDDATE',FND_DATE.DATE_TO_CHARDATE(P_END_DATE),FALSE);
5279: IF(g_error_level >= g_debug_level) THEN
5280: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);

Line 5277: fnd_message.set_token('STARTDATE',FND_DATE.DATE_TO_CHARDATE(P_START_DATE),FALSE);

5273: x_valid_cc := FND_API.G_FALSE;
5274: x_return_status := FND_API.G_RET_STS_ERROR;
5275: fnd_message.set_name('IGC', 'IGC_CC_ACCT_DATE');
5276: fnd_message.set_token('ACCTDATE',FND_DATE.DATE_TO_CHARDATE(P_ACCT_DATE),FALSE);
5277: fnd_message.set_token('STARTDATE',FND_DATE.DATE_TO_CHARDATE(P_START_DATE),FALSE);
5278: fnd_message.set_token('ENDDATE',FND_DATE.DATE_TO_CHARDATE(P_END_DATE),FALSE);
5279: IF(g_error_level >= g_debug_level) THEN
5280: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5281: END IF;

Line 5278: fnd_message.set_token('ENDDATE',FND_DATE.DATE_TO_CHARDATE(P_END_DATE),FALSE);

5274: x_return_status := FND_API.G_RET_STS_ERROR;
5275: fnd_message.set_name('IGC', 'IGC_CC_ACCT_DATE');
5276: fnd_message.set_token('ACCTDATE',FND_DATE.DATE_TO_CHARDATE(P_ACCT_DATE),FALSE);
5277: fnd_message.set_token('STARTDATE',FND_DATE.DATE_TO_CHARDATE(P_START_DATE),FALSE);
5278: fnd_message.set_token('ENDDATE',FND_DATE.DATE_TO_CHARDATE(P_END_DATE),FALSE);
5279: IF(g_error_level >= g_debug_level) THEN
5280: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5281: END IF;
5282: fnd_msg_pub.add;

Line 5295: fnd_message.set_name('IGC', 'IGC_CC_ACCT_DATE_CL_CT');

5291: p_prev_acct_date < SYSDATE)
5292: THEN
5293: x_valid_cc := FND_API.G_FALSE;
5294: x_return_status := FND_API.G_RET_STS_ERROR;
5295: fnd_message.set_name('IGC', 'IGC_CC_ACCT_DATE_CL_CT');
5296: fnd_message.set_token('ACCTDATE',FND_DATE.DATE_TO_CHARDATE(P_ACCT_DATE),FALSE);
5297: fnd_message.set_token('PREV_ACCTDATE',FND_DATE.DATE_TO_CHARDATE(P_PREV_ACCT_DATE),FALSE);
5298: IF(g_error_level >= g_debug_level) THEN
5299: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);

Line 5296: fnd_message.set_token('ACCTDATE',FND_DATE.DATE_TO_CHARDATE(P_ACCT_DATE),FALSE);

5292: THEN
5293: x_valid_cc := FND_API.G_FALSE;
5294: x_return_status := FND_API.G_RET_STS_ERROR;
5295: fnd_message.set_name('IGC', 'IGC_CC_ACCT_DATE_CL_CT');
5296: fnd_message.set_token('ACCTDATE',FND_DATE.DATE_TO_CHARDATE(P_ACCT_DATE),FALSE);
5297: fnd_message.set_token('PREV_ACCTDATE',FND_DATE.DATE_TO_CHARDATE(P_PREV_ACCT_DATE),FALSE);
5298: IF(g_error_level >= g_debug_level) THEN
5299: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5300: END IF;

Line 5297: fnd_message.set_token('PREV_ACCTDATE',FND_DATE.DATE_TO_CHARDATE(P_PREV_ACCT_DATE),FALSE);

5293: x_valid_cc := FND_API.G_FALSE;
5294: x_return_status := FND_API.G_RET_STS_ERROR;
5295: fnd_message.set_name('IGC', 'IGC_CC_ACCT_DATE_CL_CT');
5296: fnd_message.set_token('ACCTDATE',FND_DATE.DATE_TO_CHARDATE(P_ACCT_DATE),FALSE);
5297: fnd_message.set_token('PREV_ACCTDATE',FND_DATE.DATE_TO_CHARDATE(P_PREV_ACCT_DATE),FALSE);
5298: IF(g_error_level >= g_debug_level) THEN
5299: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5300: END IF;
5301: fnd_msg_pub.add;

Line 5345: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

5341: EXCEPTION
5342: WHEN OTHERS THEN
5343: l_COUNT := 0;
5344: IF ( g_unexp_level >= g_debug_level ) THEN
5345: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
5346: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
5347: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
5348: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
5349: END IF;

Line 5346: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

5342: WHEN OTHERS THEN
5343: l_COUNT := 0;
5344: IF ( g_unexp_level >= g_debug_level ) THEN
5345: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
5346: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
5347: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
5348: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
5349: END IF;
5350:

Line 5347: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

5343: l_COUNT := 0;
5344: IF ( g_unexp_level >= g_debug_level ) THEN
5345: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
5346: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
5347: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
5348: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
5349: END IF;
5350:
5351: END;

Line 5355: fnd_message.set_name('IGC', 'IGC_CC_ACCT_DATE_OF');

5351: END;
5352: IF NVL(l_COUNT,0) = 0 THEN
5353: x_valid_cc := FND_API.G_FALSE;
5354: x_return_status := FND_API.G_RET_STS_ERROR;
5355: fnd_message.set_name('IGC', 'IGC_CC_ACCT_DATE_OF');
5356: IF(g_error_level >= g_debug_level) THEN
5357: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5358: END IF;
5359: fnd_msg_pub.add;

Line 5427: fnd_message.set_name('IGC', 'IGC_CC_ACCT_FISCAL_YRS_NE');

5423: IF l_orig_fiscal_year <> l_new_fiscal_year
5424: THEN
5425: x_valid_cc := FND_API.G_FALSE;
5426: x_return_status := FND_API.G_RET_STS_ERROR;
5427: fnd_message.set_name('IGC', 'IGC_CC_ACCT_FISCAL_YRS_NE');
5428: fnd_message.set_TOKEN('PREVACTDATE',FND_DATE.DATE_TO_CHARDATE (p_prev_acct_date),FALSE);
5429: IF(g_error_level >= g_debug_level) THEN
5430: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5431: END IF;

Line 5428: fnd_message.set_TOKEN('PREVACTDATE',FND_DATE.DATE_TO_CHARDATE (p_prev_acct_date),FALSE);

5424: THEN
5425: x_valid_cc := FND_API.G_FALSE;
5426: x_return_status := FND_API.G_RET_STS_ERROR;
5427: fnd_message.set_name('IGC', 'IGC_CC_ACCT_FISCAL_YRS_NE');
5428: fnd_message.set_TOKEN('PREVACTDATE',FND_DATE.DATE_TO_CHARDATE (p_prev_acct_date),FALSE);
5429: IF(g_error_level >= g_debug_level) THEN
5430: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5431: END IF;
5432: fnd_msg_pub.add;

Line 5460: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

5456: EXCEPTION
5457: WHEN OTHERS THEN
5458: l_COUNT := 0;
5459: IF ( g_unexp_level >= g_debug_level ) THEN
5460: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
5461: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
5462: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
5463: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
5464: END IF;

Line 5461: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

5457: WHEN OTHERS THEN
5458: l_COUNT := 0;
5459: IF ( g_unexp_level >= g_debug_level ) THEN
5460: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
5461: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
5462: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
5463: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
5464: END IF;
5465: END;

Line 5462: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

5458: l_COUNT := 0;
5459: IF ( g_unexp_level >= g_debug_level ) THEN
5460: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
5461: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
5462: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
5463: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
5464: END IF;
5465: END;
5466: IF NVL(l_COUNT,0) = 0 THEN

Line 5469: fnd_message.set_name('IGC', 'IGC_CC_ACCT_DATE_O');

5465: END;
5466: IF NVL(l_COUNT,0) = 0 THEN
5467: x_valid_cc := FND_API.G_FALSE;
5468: x_return_status := FND_API.G_RET_STS_ERROR;
5469: fnd_message.set_name('IGC', 'IGC_CC_ACCT_DATE_O');
5470: IF(g_error_level >= g_debug_level) THEN
5471: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5472: END IF;
5473: fnd_msg_pub.add;

Line 5496: fnd_message.set_name('IGC', 'IGC_CC_ACCT_DATE');

5492: p_prev_acct_date IS NOT NULL)
5493: THEN
5494: x_valid_cc := FND_API.G_FALSE;
5495: x_return_status := FND_API.G_RET_STS_ERROR;
5496: fnd_message.set_name('IGC', 'IGC_CC_ACCT_DATE');
5497: fnd_message.set_token('ACCTDATE',FND_DATE.DATE_TO_CHARDATE(P_ACCT_DATE),FALSE);
5498: fnd_message.set_token('STARTDATE',FND_DATE.DATE_TO_CHARDATE(P_START_DATE),FALSE);
5499: fnd_message.set_token('ENDDATE',FND_DATE.DATE_TO_CHARDATE(P_END_DATE),FALSE);
5500: IF(g_error_level >= g_debug_level) THEN

Line 5497: fnd_message.set_token('ACCTDATE',FND_DATE.DATE_TO_CHARDATE(P_ACCT_DATE),FALSE);

5493: THEN
5494: x_valid_cc := FND_API.G_FALSE;
5495: x_return_status := FND_API.G_RET_STS_ERROR;
5496: fnd_message.set_name('IGC', 'IGC_CC_ACCT_DATE');
5497: fnd_message.set_token('ACCTDATE',FND_DATE.DATE_TO_CHARDATE(P_ACCT_DATE),FALSE);
5498: fnd_message.set_token('STARTDATE',FND_DATE.DATE_TO_CHARDATE(P_START_DATE),FALSE);
5499: fnd_message.set_token('ENDDATE',FND_DATE.DATE_TO_CHARDATE(P_END_DATE),FALSE);
5500: IF(g_error_level >= g_debug_level) THEN
5501: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);

Line 5498: fnd_message.set_token('STARTDATE',FND_DATE.DATE_TO_CHARDATE(P_START_DATE),FALSE);

5494: x_valid_cc := FND_API.G_FALSE;
5495: x_return_status := FND_API.G_RET_STS_ERROR;
5496: fnd_message.set_name('IGC', 'IGC_CC_ACCT_DATE');
5497: fnd_message.set_token('ACCTDATE',FND_DATE.DATE_TO_CHARDATE(P_ACCT_DATE),FALSE);
5498: fnd_message.set_token('STARTDATE',FND_DATE.DATE_TO_CHARDATE(P_START_DATE),FALSE);
5499: fnd_message.set_token('ENDDATE',FND_DATE.DATE_TO_CHARDATE(P_END_DATE),FALSE);
5500: IF(g_error_level >= g_debug_level) THEN
5501: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5502: END IF;

Line 5499: fnd_message.set_token('ENDDATE',FND_DATE.DATE_TO_CHARDATE(P_END_DATE),FALSE);

5495: x_return_status := FND_API.G_RET_STS_ERROR;
5496: fnd_message.set_name('IGC', 'IGC_CC_ACCT_DATE');
5497: fnd_message.set_token('ACCTDATE',FND_DATE.DATE_TO_CHARDATE(P_ACCT_DATE),FALSE);
5498: fnd_message.set_token('STARTDATE',FND_DATE.DATE_TO_CHARDATE(P_START_DATE),FALSE);
5499: fnd_message.set_token('ENDDATE',FND_DATE.DATE_TO_CHARDATE(P_END_DATE),FALSE);
5500: IF(g_error_level >= g_debug_level) THEN
5501: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5502: END IF;
5503: fnd_msg_pub.add;

Line 5516: fnd_message.set_name('IGC', 'IGC_CC_ACCT_DATE_CL_CT');

5512: p_prev_acct_date < SYSDATE)
5513: THEN
5514: x_valid_cc := FND_API.G_FALSE;
5515: x_return_status := FND_API.G_RET_STS_ERROR;
5516: fnd_message.set_name('IGC', 'IGC_CC_ACCT_DATE_CL_CT');
5517: fnd_message.set_token('ACCTDATE',FND_DATE.DATE_TO_CHARDATE(P_ACCT_DATE),FALSE);
5518: fnd_message.set_token('PREV_ACCTDATE',FND_DATE.DATE_TO_CHARDATE(P_PREV_ACCT_DATE),FALSE);
5519: IF(g_error_level >= g_debug_level) THEN
5520: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);

Line 5517: fnd_message.set_token('ACCTDATE',FND_DATE.DATE_TO_CHARDATE(P_ACCT_DATE),FALSE);

5513: THEN
5514: x_valid_cc := FND_API.G_FALSE;
5515: x_return_status := FND_API.G_RET_STS_ERROR;
5516: fnd_message.set_name('IGC', 'IGC_CC_ACCT_DATE_CL_CT');
5517: fnd_message.set_token('ACCTDATE',FND_DATE.DATE_TO_CHARDATE(P_ACCT_DATE),FALSE);
5518: fnd_message.set_token('PREV_ACCTDATE',FND_DATE.DATE_TO_CHARDATE(P_PREV_ACCT_DATE),FALSE);
5519: IF(g_error_level >= g_debug_level) THEN
5520: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5521: END IF;

Line 5518: fnd_message.set_token('PREV_ACCTDATE',FND_DATE.DATE_TO_CHARDATE(P_PREV_ACCT_DATE),FALSE);

5514: x_valid_cc := FND_API.G_FALSE;
5515: x_return_status := FND_API.G_RET_STS_ERROR;
5516: fnd_message.set_name('IGC', 'IGC_CC_ACCT_DATE_CL_CT');
5517: fnd_message.set_token('ACCTDATE',FND_DATE.DATE_TO_CHARDATE(P_ACCT_DATE),FALSE);
5518: fnd_message.set_token('PREV_ACCTDATE',FND_DATE.DATE_TO_CHARDATE(P_PREV_ACCT_DATE),FALSE);
5519: IF(g_error_level >= g_debug_level) THEN
5520: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5521: END IF;
5522: fnd_msg_pub.add;

Line 5566: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

5562: EXCEPTION
5563: WHEN OTHERS THEN
5564: l_COUNT := 0;
5565: IF ( g_unexp_level >= g_debug_level ) THEN
5566: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
5567: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
5568: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
5569: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
5570: END IF;

Line 5567: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

5563: WHEN OTHERS THEN
5564: l_COUNT := 0;
5565: IF ( g_unexp_level >= g_debug_level ) THEN
5566: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
5567: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
5568: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
5569: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
5570: END IF;
5571: END;

Line 5568: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

5564: l_COUNT := 0;
5565: IF ( g_unexp_level >= g_debug_level ) THEN
5566: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
5567: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
5568: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
5569: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
5570: END IF;
5571: END;
5572: IF NVL(l_COUNT,0) = 0 THEN

Line 5575: fnd_message.set_name('IGC', 'IGC_CC_ACCT_DATE_OF');

5571: END;
5572: IF NVL(l_COUNT,0) = 0 THEN
5573: x_valid_cc := FND_API.G_FALSE;
5574: x_return_status := FND_API.G_RET_STS_ERROR;
5575: fnd_message.set_name('IGC', 'IGC_CC_ACCT_DATE_OF');
5576: IF(g_error_level >= g_debug_level) THEN
5577: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5578: END IF;
5579: fnd_msg_pub.add;

Line 5647: fnd_message.set_name('IGC', 'IGC_CC_ACCT_FISCAL_YRS_NE');

5643: IF l_orig_fiscal_year <> l_new_fiscal_year
5644: THEN
5645: x_valid_cc := FND_API.G_FALSE;
5646: x_return_status := FND_API.G_RET_STS_ERROR;
5647: fnd_message.set_name('IGC', 'IGC_CC_ACCT_FISCAL_YRS_NE');
5648: fnd_message.set_TOKEN('PREVACTDATE',FND_DATE.DATE_TO_CHARDATE (p_prev_acct_date),FALSE);
5649: IF(g_error_level >= g_debug_level) THEN
5650: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5651: END IF;

Line 5648: fnd_message.set_TOKEN('PREVACTDATE',FND_DATE.DATE_TO_CHARDATE (p_prev_acct_date),FALSE);

5644: THEN
5645: x_valid_cc := FND_API.G_FALSE;
5646: x_return_status := FND_API.G_RET_STS_ERROR;
5647: fnd_message.set_name('IGC', 'IGC_CC_ACCT_FISCAL_YRS_NE');
5648: fnd_message.set_TOKEN('PREVACTDATE',FND_DATE.DATE_TO_CHARDATE (p_prev_acct_date),FALSE);
5649: IF(g_error_level >= g_debug_level) THEN
5650: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5651: END IF;
5652: fnd_msg_pub.add;

Line 5680: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

5676: EXCEPTION
5677: WHEN OTHERS THEN
5678: l_COUNT := 0;
5679: IF ( g_unexp_level >= g_debug_level ) THEN
5680: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
5681: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
5682: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
5683: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
5684: END IF;

Line 5681: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

5677: WHEN OTHERS THEN
5678: l_COUNT := 0;
5679: IF ( g_unexp_level >= g_debug_level ) THEN
5680: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
5681: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
5682: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
5683: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
5684: END IF;
5685: END;

Line 5682: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

5678: l_COUNT := 0;
5679: IF ( g_unexp_level >= g_debug_level ) THEN
5680: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
5681: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
5682: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
5683: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
5684: END IF;
5685: END;
5686: IF NVL(l_COUNT,0) = 0 THEN

Line 5689: fnd_message.set_name('IGC', 'IGC_CC_ACCT_DATE_O');

5685: END;
5686: IF NVL(l_COUNT,0) = 0 THEN
5687: x_valid_cc := FND_API.G_FALSE;
5688: x_return_status := FND_API.G_RET_STS_ERROR;
5689: fnd_message.set_name('IGC', 'IGC_CC_ACCT_DATE_O');
5690: IF(g_error_level >= g_debug_level) THEN
5691: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5692: END IF;
5693: fnd_msg_pub.add;

Line 5712: fnd_message.set_name('IGC', 'IGC_CC_NOT_FOUND');

5708: EXCEPTION
5709: WHEN no_data_found THEN
5710: x_valid_cc := FND_API.G_FALSE;
5711: x_return_status := FND_API.G_RET_STS_ERROR;
5712: fnd_message.set_name('IGC', 'IGC_CC_NOT_FOUND');
5713: fnd_message.set_token('CC_NUM', to_char(p_cc_header_id),TRUE);
5714: IF(g_error_level >= g_debug_level) THEN
5715: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5716: END IF;

Line 5713: fnd_message.set_token('CC_NUM', to_char(p_cc_header_id),TRUE);

5709: WHEN no_data_found THEN
5710: x_valid_cc := FND_API.G_FALSE;
5711: x_return_status := FND_API.G_RET_STS_ERROR;
5712: fnd_message.set_name('IGC', 'IGC_CC_NOT_FOUND');
5713: fnd_message.set_token('CC_NUM', to_char(p_cc_header_id),TRUE);
5714: IF(g_error_level >= g_debug_level) THEN
5715: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5716: END IF;
5717: l_error_message := fnd_message.get;

Line 5717: l_error_message := fnd_message.get;

5713: fnd_message.set_token('CC_NUM', to_char(p_cc_header_id),TRUE);
5714: IF(g_error_level >= g_debug_level) THEN
5715: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5716: END IF;
5717: l_error_message := fnd_message.get;
5718: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name, l_error_message);
5719: RAISE E_CC_NOT_FOUND;
5720:
5721: END;

Line 5769: fnd_message.set_name('IGC', 'IGC_CC_NO_PF');

5765: -- the amount in the account line
5766: THEN
5767: x_valid_cc := FND_API.G_FALSE;
5768: x_return_status := FND_API.G_RET_STS_ERROR;
5769: fnd_message.set_name('IGC', 'IGC_CC_NO_PF');
5770: fnd_message.set_token('ACCT_NUM', to_char(l_cc_acct_lines_rec.cc_acct_line_num),TRUE);
5771: IF(g_error_level >= g_debug_level) THEN
5772: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5773: END IF;

Line 5770: fnd_message.set_token('ACCT_NUM', to_char(l_cc_acct_lines_rec.cc_acct_line_num),TRUE);

5766: THEN
5767: x_valid_cc := FND_API.G_FALSE;
5768: x_return_status := FND_API.G_RET_STS_ERROR;
5769: fnd_message.set_name('IGC', 'IGC_CC_NO_PF');
5770: fnd_message.set_token('ACCT_NUM', to_char(l_cc_acct_lines_rec.cc_acct_line_num),TRUE);
5771: IF(g_error_level >= g_debug_level) THEN
5772: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5773: END IF;
5774: fnd_msg_pub.add;

Line 5790: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_ACCT_DATE');

5786:
5787: IF (l_cc_det_pf_lines_rec.cc_det_pf_date < p_acct_date) THEN
5788: x_valid_cc := FND_API.G_FALSE;
5789: x_return_status := FND_API.G_RET_STS_ERROR;
5790: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_ACCT_DATE');
5791: fnd_message.set_TOKEN('PFDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_date),FALSE);
5792: fnd_message.set_TOKEN('ACCTDATE',FND_DATE.DATE_TO_CHARDATE (p_acct_date),FALSE);
5793: IF(g_error_level >= g_debug_level) THEN
5794: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);

Line 5791: fnd_message.set_TOKEN('PFDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_date),FALSE);

5787: IF (l_cc_det_pf_lines_rec.cc_det_pf_date < p_acct_date) THEN
5788: x_valid_cc := FND_API.G_FALSE;
5789: x_return_status := FND_API.G_RET_STS_ERROR;
5790: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_ACCT_DATE');
5791: fnd_message.set_TOKEN('PFDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_date),FALSE);
5792: fnd_message.set_TOKEN('ACCTDATE',FND_DATE.DATE_TO_CHARDATE (p_acct_date),FALSE);
5793: IF(g_error_level >= g_debug_level) THEN
5794: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5795: END IF;

Line 5792: fnd_message.set_TOKEN('ACCTDATE',FND_DATE.DATE_TO_CHARDATE (p_acct_date),FALSE);

5788: x_valid_cc := FND_API.G_FALSE;
5789: x_return_status := FND_API.G_RET_STS_ERROR;
5790: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_ACCT_DATE');
5791: fnd_message.set_TOKEN('PFDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_date),FALSE);
5792: fnd_message.set_TOKEN('ACCTDATE',FND_DATE.DATE_TO_CHARDATE (p_acct_date),FALSE);
5793: IF(g_error_level >= g_debug_level) THEN
5794: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5795: END IF;
5796: fnd_msg_pub.add;

Line 5813: fnd_message.set_name('IGC', 'IGC_CC_NO_ACCT_LINES');

5809:
5810: IF (l_cc_acct_cnt = 0) THEN
5811: x_valid_cc := FND_API.G_FALSE;
5812: x_return_status := FND_API.G_RET_STS_ERROR;
5813: fnd_message.set_name('IGC', 'IGC_CC_NO_ACCT_LINES');
5814: fnd_message.set_token('CC_NUM', l_cc_headers_rec.cc_num,TRUE);
5815: IF(g_error_level >= g_debug_level) THEN
5816: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5817: END IF;

Line 5814: fnd_message.set_token('CC_NUM', l_cc_headers_rec.cc_num,TRUE);

5810: IF (l_cc_acct_cnt = 0) THEN
5811: x_valid_cc := FND_API.G_FALSE;
5812: x_return_status := FND_API.G_RET_STS_ERROR;
5813: fnd_message.set_name('IGC', 'IGC_CC_NO_ACCT_LINES');
5814: fnd_message.set_token('CC_NUM', l_cc_headers_rec.cc_num,TRUE);
5815: IF(g_error_level >= g_debug_level) THEN
5816: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5817: END IF;
5818: fnd_msg_pub.add;

Line 5836: fnd_message.set_name('IGC', 'IGC_CC_NOT_FOUND');

5832: EXCEPTION
5833: WHEN no_data_found THEN
5834: x_valid_cc := FND_API.G_FALSE;
5835: x_return_status := FND_API.G_RET_STS_ERROR;
5836: fnd_message.set_name('IGC', 'IGC_CC_NOT_FOUND');
5837: fnd_message.set_token('CC_NUM', to_char(p_cc_header_id),TRUE);
5838: IF(g_error_level >= g_debug_level) THEN
5839: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5840: END IF;

Line 5837: fnd_message.set_token('CC_NUM', to_char(p_cc_header_id),TRUE);

5833: WHEN no_data_found THEN
5834: x_valid_cc := FND_API.G_FALSE;
5835: x_return_status := FND_API.G_RET_STS_ERROR;
5836: fnd_message.set_name('IGC', 'IGC_CC_NOT_FOUND');
5837: fnd_message.set_token('CC_NUM', to_char(p_cc_header_id),TRUE);
5838: IF(g_error_level >= g_debug_level) THEN
5839: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5840: END IF;
5841: l_error_message := fnd_message.get;

Line 5841: l_error_message := fnd_message.get;

5837: fnd_message.set_token('CC_NUM', to_char(p_cc_header_id),TRUE);
5838: IF(g_error_level >= g_debug_level) THEN
5839: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5840: END IF;
5841: l_error_message := fnd_message.get;
5842: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name, l_error_message);
5843: RAISE E_CC_NOT_FOUND;
5844:
5845: END;

Line 5886: fnd_message.set_name('IGC', 'IGC_CC_NO_PF');

5882: -- the amount in the account line
5883: THEN
5884: x_valid_cc := FND_API.G_FALSE;
5885: x_return_status := FND_API.G_RET_STS_ERROR;
5886: fnd_message.set_name('IGC', 'IGC_CC_NO_PF');
5887: fnd_message.set_token('ACCT_NUM', to_char(l_cc_acct_lines_rec.cc_acct_line_num),TRUE);
5888: IF(g_error_level >= g_debug_level) THEN
5889: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5890: END IF;

Line 5887: fnd_message.set_token('ACCT_NUM', to_char(l_cc_acct_lines_rec.cc_acct_line_num),TRUE);

5883: THEN
5884: x_valid_cc := FND_API.G_FALSE;
5885: x_return_status := FND_API.G_RET_STS_ERROR;
5886: fnd_message.set_name('IGC', 'IGC_CC_NO_PF');
5887: fnd_message.set_token('ACCT_NUM', to_char(l_cc_acct_lines_rec.cc_acct_line_num),TRUE);
5888: IF(g_error_level >= g_debug_level) THEN
5889: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5890: END IF;
5891: fnd_msg_pub.add;

Line 5907: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_START_DATE');

5903:
5904: IF (l_cc_det_pf_lines_rec.cc_det_pf_date < p_start_date) THEN
5905: x_valid_cc := FND_API.G_FALSE;
5906: x_return_status := FND_API.G_RET_STS_ERROR;
5907: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_START_DATE');
5908: fnd_message.set_TOKEN('PFDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_date),FALSE);
5909: IF (g_error_level >= g_debug_level) THEN
5910: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5911: END IF;

Line 5908: fnd_message.set_TOKEN('PFDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_date),FALSE);

5904: IF (l_cc_det_pf_lines_rec.cc_det_pf_date < p_start_date) THEN
5905: x_valid_cc := FND_API.G_FALSE;
5906: x_return_status := FND_API.G_RET_STS_ERROR;
5907: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_START_DATE');
5908: fnd_message.set_TOKEN('PFDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_date),FALSE);
5909: IF (g_error_level >= g_debug_level) THEN
5910: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5911: END IF;
5912: fnd_msg_pub.add;

Line 5922: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_END_DATE');

5918: (p_end_date IS NOT NULL)
5919: ) THEN
5920: x_valid_cc := FND_API.G_FALSE;
5921: x_return_status := FND_API.G_RET_STS_ERROR;
5922: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_END_DATE');
5923: fnd_message.set_TOKEN('PFDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_date),FALSE);
5924: IF(g_error_level >= g_debug_level) THEN
5925: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5926: END IF;

Line 5923: fnd_message.set_TOKEN('PFDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_date),FALSE);

5919: ) THEN
5920: x_valid_cc := FND_API.G_FALSE;
5921: x_return_status := FND_API.G_RET_STS_ERROR;
5922: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_END_DATE');
5923: fnd_message.set_TOKEN('PFDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_date),FALSE);
5924: IF(g_error_level >= g_debug_level) THEN
5925: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5926: END IF;
5927: fnd_msg_pub.add;

Line 5963: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

5959: EXCEPTION
5960: WHEN OTHERS THEN
5961: l_COUNT := 0;
5962: IF ( g_unexp_level >= g_debug_level ) THEN
5963: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
5964: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
5965: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
5966: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
5967: END IF;

Line 5964: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

5960: WHEN OTHERS THEN
5961: l_COUNT := 0;
5962: IF ( g_unexp_level >= g_debug_level ) THEN
5963: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
5964: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
5965: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
5966: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
5967: END IF;
5968: END;

Line 5965: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

5961: l_COUNT := 0;
5962: IF ( g_unexp_level >= g_debug_level ) THEN
5963: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
5964: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
5965: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
5966: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
5967: END IF;
5968: END;
5969: IF NVL(l_COUNT,0) = 0 THEN

Line 5972: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_DATE');

5968: END;
5969: IF NVL(l_COUNT,0) = 0 THEN
5970: x_valid_cc := FND_API.G_FALSE;
5971: x_return_status := FND_API.G_RET_STS_ERROR;
5972: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_DATE');
5973: IF(g_error_level >= g_debug_level) THEN
5974: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5975: END IF;
5976: fnd_msg_pub.add;

Line 6034: fnd_message.set_name('IGC','IGC_CC_DET_PF_DATE_NO_UPDATE');

6030: TRUNC(l_cc_det_pf_lines_rec.cc_det_pf_encmbrnc_date)
6031: THEN
6032: x_valid_cc := FND_API.G_FALSE;
6033: x_return_status := FND_API.G_RET_STS_ERROR;
6034: fnd_message.set_name('IGC','IGC_CC_DET_PF_DATE_NO_UPDATE');
6035: fnd_message.set_TOKEN('ENCMBRNCDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_encmbrnc_date),FALSE);
6036: IF(g_error_level >= g_debug_level) THEN
6037: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6038: END IF;

Line 6035: fnd_message.set_TOKEN('ENCMBRNCDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_encmbrnc_date),FALSE);

6031: THEN
6032: x_valid_cc := FND_API.G_FALSE;
6033: x_return_status := FND_API.G_RET_STS_ERROR;
6034: fnd_message.set_name('IGC','IGC_CC_DET_PF_DATE_NO_UPDATE');
6035: fnd_message.set_TOKEN('ENCMBRNCDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_encmbrnc_date),FALSE);
6036: IF(g_error_level >= g_debug_level) THEN
6037: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6038: END IF;
6039: fnd_msg_pub.add;

Line 6109: fnd_message.set_name('IGC', 'IGC_CC_FISCAL_YRS_NE');

6105: IF l_orig_fiscal_year <> l_new_fiscal_year
6106: THEN
6107: x_valid_cc := FND_API.G_FALSE;
6108: x_return_status := FND_API.G_RET_STS_ERROR;
6109: fnd_message.set_name('IGC', 'IGC_CC_FISCAL_YRS_NE');
6110: fnd_message.set_TOKEN('ENCMBRNCDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_encmbrnc_date),FALSE);
6111: IF(g_error_level >= g_debug_level) THEN
6112: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6113: END IF;

Line 6110: fnd_message.set_TOKEN('ENCMBRNCDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_encmbrnc_date),FALSE);

6106: THEN
6107: x_valid_cc := FND_API.G_FALSE;
6108: x_return_status := FND_API.G_RET_STS_ERROR;
6109: fnd_message.set_name('IGC', 'IGC_CC_FISCAL_YRS_NE');
6110: fnd_message.set_TOKEN('ENCMBRNCDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_encmbrnc_date),FALSE);
6111: IF(g_error_level >= g_debug_level) THEN
6112: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6113: END IF;
6114: fnd_msg_pub.add;

Line 6140: fnd_message.set_name('IGC', 'IGC_CC_AMT_MISMATCH');

6136: -- This validation now needs to include the withheld amount
6137: THEN
6138: x_valid_cc := FND_API.G_FALSE;
6139: x_return_status := FND_API.G_RET_STS_ERROR;
6140: fnd_message.set_name('IGC', 'IGC_CC_AMT_MISMATCH');
6141: fnd_message.set_token('ACCT_NUM',to_char(l_cc_acct_lines_rec.cc_acct_line_num),TRUE);
6142: IF(g_error_level >= g_debug_level) THEN
6143: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6144: END IF;

Line 6141: fnd_message.set_token('ACCT_NUM',to_char(l_cc_acct_lines_rec.cc_acct_line_num),TRUE);

6137: THEN
6138: x_valid_cc := FND_API.G_FALSE;
6139: x_return_status := FND_API.G_RET_STS_ERROR;
6140: fnd_message.set_name('IGC', 'IGC_CC_AMT_MISMATCH');
6141: fnd_message.set_token('ACCT_NUM',to_char(l_cc_acct_lines_rec.cc_acct_line_num),TRUE);
6142: IF(g_error_level >= g_debug_level) THEN
6143: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6144: END IF;
6145: fnd_msg_pub.add;

Line 6155: fnd_message.set_name('IGC', 'IGC_CC_NO_ACCT_LINES');

6151:
6152: IF (l_cc_acct_cnt = 0) THEN
6153: x_valid_cc := FND_API.G_FALSE;
6154: x_return_status := FND_API.G_RET_STS_ERROR;
6155: fnd_message.set_name('IGC', 'IGC_CC_NO_ACCT_LINES');
6156: fnd_message.set_token('CC_NUM', l_cc_headers_rec.cc_num,TRUE);
6157: IF(g_error_level >= g_debug_level) THEN
6158: FND_LOG.MESSAGE(g_error_level, g_debug_level, FALSE);
6159: END IF;

Line 6156: fnd_message.set_token('CC_NUM', l_cc_headers_rec.cc_num,TRUE);

6152: IF (l_cc_acct_cnt = 0) THEN
6153: x_valid_cc := FND_API.G_FALSE;
6154: x_return_status := FND_API.G_RET_STS_ERROR;
6155: fnd_message.set_name('IGC', 'IGC_CC_NO_ACCT_LINES');
6156: fnd_message.set_token('CC_NUM', l_cc_headers_rec.cc_num,TRUE);
6157: IF(g_error_level >= g_debug_level) THEN
6158: FND_LOG.MESSAGE(g_error_level, g_debug_level, FALSE);
6159: END IF;
6160: fnd_msg_pub.add;

Line 6181: fnd_message.set_name('IGC', 'IGC_CC_NOT_FOUND');

6177: EXCEPTION
6178: WHEN no_data_found THEN
6179: x_valid_cc := FND_API.G_FALSE;
6180: x_return_status := FND_API.G_RET_STS_ERROR;
6181: fnd_message.set_name('IGC', 'IGC_CC_NOT_FOUND');
6182: fnd_message.set_token('CC_NUM', to_char(p_cc_header_id),TRUE);
6183: IF(g_error_level >= g_debug_level) THEN
6184: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6185: END IF;

Line 6182: fnd_message.set_token('CC_NUM', to_char(p_cc_header_id),TRUE);

6178: WHEN no_data_found THEN
6179: x_valid_cc := FND_API.G_FALSE;
6180: x_return_status := FND_API.G_RET_STS_ERROR;
6181: fnd_message.set_name('IGC', 'IGC_CC_NOT_FOUND');
6182: fnd_message.set_token('CC_NUM', to_char(p_cc_header_id),TRUE);
6183: IF(g_error_level >= g_debug_level) THEN
6184: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6185: END IF;
6186: l_error_message := fnd_message.get;

Line 6186: l_error_message := fnd_message.get;

6182: fnd_message.set_token('CC_NUM', to_char(p_cc_header_id),TRUE);
6183: IF(g_error_level >= g_debug_level) THEN
6184: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6185: END IF;
6186: l_error_message := fnd_message.get;
6187: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name, l_error_message);
6188: RAISE E_CC_NOT_FOUND;
6189:
6190: END;

Line 6222: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

6218: EXCEPTION
6219: WHEN NO_DATA_FOUND THEN
6220: l_cc_det_pf_cnt := 0;
6221: IF ( g_unexp_level >= g_debug_level ) THEN
6222: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
6223: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
6224: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
6225: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
6226: END IF;

Line 6223: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

6219: WHEN NO_DATA_FOUND THEN
6220: l_cc_det_pf_cnt := 0;
6221: IF ( g_unexp_level >= g_debug_level ) THEN
6222: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
6223: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
6224: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
6225: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
6226: END IF;
6227: END;

Line 6224: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

6220: l_cc_det_pf_cnt := 0;
6221: IF ( g_unexp_level >= g_debug_level ) THEN
6222: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
6223: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
6224: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
6225: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
6226: END IF;
6227: END;
6228: IF (NVL(l_cc_det_pf_cnt ,0) = 0)

Line 6236: fnd_message.set_name('IGC', 'IGC_CC_NO_PF');

6232: -- the amount in the account line
6233: THEN
6234: x_valid_cc := FND_API.G_FALSE;
6235: x_return_status := FND_API.G_RET_STS_ERROR;
6236: fnd_message.set_name('IGC', 'IGC_CC_NO_PF');
6237: fnd_message.set_token('ACCT_NUM', to_char(l_cc_acct_lines_rec.cc_acct_line_num),TRUE);
6238: IF(g_error_level >= g_debug_level) THEN
6239: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6240: END IF;

Line 6237: fnd_message.set_token('ACCT_NUM', to_char(l_cc_acct_lines_rec.cc_acct_line_num),TRUE);

6233: THEN
6234: x_valid_cc := FND_API.G_FALSE;
6235: x_return_status := FND_API.G_RET_STS_ERROR;
6236: fnd_message.set_name('IGC', 'IGC_CC_NO_PF');
6237: fnd_message.set_token('ACCT_NUM', to_char(l_cc_acct_lines_rec.cc_acct_line_num),TRUE);
6238: IF(g_error_level >= g_debug_level) THEN
6239: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6240: END IF;
6241: fnd_msg_pub.add;

Line 6257: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_START_DATE');

6253:
6254: IF (l_cc_det_pf_lines_rec.cc_det_pf_date < p_start_date) THEN
6255: x_valid_cc := FND_API.G_FALSE;
6256: x_return_status := FND_API.G_RET_STS_ERROR;
6257: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_START_DATE');
6258: fnd_message.set_TOKEN('PFDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_date),FALSE);
6259: IF(g_error_level >= g_debug_level) THEN
6260: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6261: END IF;

Line 6258: fnd_message.set_TOKEN('PFDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_date),FALSE);

6254: IF (l_cc_det_pf_lines_rec.cc_det_pf_date < p_start_date) THEN
6255: x_valid_cc := FND_API.G_FALSE;
6256: x_return_status := FND_API.G_RET_STS_ERROR;
6257: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_START_DATE');
6258: fnd_message.set_TOKEN('PFDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_date),FALSE);
6259: IF(g_error_level >= g_debug_level) THEN
6260: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6261: END IF;
6262: fnd_msg_pub.add;

Line 6272: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_END_DATE');

6268: (p_end_date IS NOT NULL)
6269: ) THEN
6270: x_valid_cc := FND_API.G_FALSE;
6271: x_return_status := FND_API.G_RET_STS_ERROR;
6272: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_END_DATE');
6273: fnd_message.set_TOKEN('PFDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_date),FALSE);
6274: IF(g_error_level >= g_debug_level) THEN
6275: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6276: END IF;

Line 6273: fnd_message.set_TOKEN('PFDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_date),FALSE);

6269: ) THEN
6270: x_valid_cc := FND_API.G_FALSE;
6271: x_return_status := FND_API.G_RET_STS_ERROR;
6272: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_END_DATE');
6273: fnd_message.set_TOKEN('PFDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_date),FALSE);
6274: IF(g_error_level >= g_debug_level) THEN
6275: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6276: END IF;
6277: fnd_msg_pub.add;

Line 6313: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

6309: EXCEPTION
6310: WHEN OTHERS THEN
6311: l_COUNT := 0;
6312: IF ( g_unexp_level >= g_debug_level ) THEN
6313: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
6314: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
6315: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
6316: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
6317: END IF;

Line 6314: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

6310: WHEN OTHERS THEN
6311: l_COUNT := 0;
6312: IF ( g_unexp_level >= g_debug_level ) THEN
6313: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
6314: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
6315: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
6316: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
6317: END IF;
6318: END;

Line 6315: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

6311: l_COUNT := 0;
6312: IF ( g_unexp_level >= g_debug_level ) THEN
6313: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
6314: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
6315: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
6316: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
6317: END IF;
6318: END;
6319: IF NVL(l_COUNT,0) = 0 THEN

Line 6322: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_DATE');

6318: END;
6319: IF NVL(l_COUNT,0) = 0 THEN
6320: x_valid_cc := FND_API.G_FALSE;
6321: x_return_status := FND_API.G_RET_STS_ERROR;
6322: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_DATE');
6323: IF(g_error_level >= g_debug_level) THEN
6324: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6325: END IF;
6326: fnd_msg_pub.add;

Line 6383: fnd_message.set_name('IGC',

6379: TRUNC (l_cc_det_pf_lines_rec.cc_det_pf_encmbrnc_date)
6380: THEN
6381: x_valid_cc := FND_API.G_FALSE;
6382: x_return_status := FND_API.G_RET_STS_ERROR;
6383: fnd_message.set_name('IGC',
6384: 'IGC_CC_DET_PF_DATE_NO_UPDATE');
6385: fnd_message.set_TOKEN('ENCMBRNCDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_encmbrnc_date),FALSE);
6386: IF(g_error_level >= g_debug_level) THEN
6387: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);

Line 6385: fnd_message.set_TOKEN('ENCMBRNCDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_encmbrnc_date),FALSE);

6381: x_valid_cc := FND_API.G_FALSE;
6382: x_return_status := FND_API.G_RET_STS_ERROR;
6383: fnd_message.set_name('IGC',
6384: 'IGC_CC_DET_PF_DATE_NO_UPDATE');
6385: fnd_message.set_TOKEN('ENCMBRNCDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_encmbrnc_date),FALSE);
6386: IF(g_error_level >= g_debug_level) THEN
6387: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6388: END IF;
6389: fnd_msg_pub.add;

Line 6459: fnd_message.set_name('IGC', 'IGC_CC_FISCAL_YRS_NE');

6455: IF l_orig_fiscal_year <> l_new_fiscal_year
6456: THEN
6457: x_valid_cc := FND_API.G_FALSE;
6458: x_return_status := FND_API.G_RET_STS_ERROR;
6459: fnd_message.set_name('IGC', 'IGC_CC_FISCAL_YRS_NE');
6460: fnd_message.set_TOKEN('ENCMBRNCDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_encmbrnc_date),FALSE);
6461: IF(g_error_level >= g_debug_level) THEN
6462: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6463: END IF;

Line 6460: fnd_message.set_TOKEN('ENCMBRNCDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_encmbrnc_date),FALSE);

6456: THEN
6457: x_valid_cc := FND_API.G_FALSE;
6458: x_return_status := FND_API.G_RET_STS_ERROR;
6459: fnd_message.set_name('IGC', 'IGC_CC_FISCAL_YRS_NE');
6460: fnd_message.set_TOKEN('ENCMBRNCDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_encmbrnc_date),FALSE);
6461: IF(g_error_level >= g_debug_level) THEN
6462: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6463: END IF;
6464: fnd_msg_pub.add;

Line 6489: fnd_message.set_name('IGC', 'IGC_CC_AMT_MISMATCH');

6485: -- This validation now needs to include the withheld amount
6486: THEN
6487: x_valid_cc := FND_API.G_FALSE;
6488: x_return_status := FND_API.G_RET_STS_ERROR;
6489: fnd_message.set_name('IGC', 'IGC_CC_AMT_MISMATCH');
6490: fnd_message.set_token('ACCT_NUM',to_char(l_cc_acct_lines_rec.cc_acct_line_num),TRUE);
6491: IF(g_error_level >= g_debug_level) THEN
6492: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6493: END IF;

Line 6490: fnd_message.set_token('ACCT_NUM',to_char(l_cc_acct_lines_rec.cc_acct_line_num),TRUE);

6486: THEN
6487: x_valid_cc := FND_API.G_FALSE;
6488: x_return_status := FND_API.G_RET_STS_ERROR;
6489: fnd_message.set_name('IGC', 'IGC_CC_AMT_MISMATCH');
6490: fnd_message.set_token('ACCT_NUM',to_char(l_cc_acct_lines_rec.cc_acct_line_num),TRUE);
6491: IF(g_error_level >= g_debug_level) THEN
6492: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6493: END IF;
6494: fnd_msg_pub.add;

Line 6504: fnd_message.set_name('IGC', 'IGC_CC_NO_ACCT_LINES');

6500:
6501: IF (l_cc_acct_cnt = 0) THEN
6502: x_valid_cc := FND_API.G_FALSE;
6503: x_return_status := FND_API.G_RET_STS_ERROR;
6504: fnd_message.set_name('IGC', 'IGC_CC_NO_ACCT_LINES');
6505: fnd_message.set_token('CC_NUM', l_cc_headers_rec.cc_num,TRUE);
6506: IF(g_error_level >= g_debug_level) THEN
6507: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6508: END IF;

Line 6505: fnd_message.set_token('CC_NUM', l_cc_headers_rec.cc_num,TRUE);

6501: IF (l_cc_acct_cnt = 0) THEN
6502: x_valid_cc := FND_API.G_FALSE;
6503: x_return_status := FND_API.G_RET_STS_ERROR;
6504: fnd_message.set_name('IGC', 'IGC_CC_NO_ACCT_LINES');
6505: fnd_message.set_token('CC_NUM', l_cc_headers_rec.cc_num,TRUE);
6506: IF(g_error_level >= g_debug_level) THEN
6507: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6508: END IF;
6509: fnd_msg_pub.add;

Line 6553: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

6549: p_data => x_msg_data );
6550: CLOSE c_account_lines;
6551:
6552: IF ( g_unexp_level >= g_debug_level ) THEN
6553: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
6554: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
6555: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
6556: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
6557: END IF;

Line 6554: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

6550: CLOSE c_account_lines;
6551:
6552: IF ( g_unexp_level >= g_debug_level ) THEN
6553: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
6554: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
6555: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
6556: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
6557: END IF;
6558:

Line 6555: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

6551:
6552: IF ( g_unexp_level >= g_debug_level ) THEN
6553: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
6554: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
6555: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
6556: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
6557: END IF;
6558:
6559: END Validate_CC;

Line 6645: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

6641: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
6642: p_data => x_msg_data );
6643:
6644: IF ( g_unexp_level >= g_debug_level ) THEN
6645: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
6646: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
6647: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
6648: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
6649: END IF;

Line 6646: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

6642: p_data => x_msg_data );
6643:
6644: IF ( g_unexp_level >= g_debug_level ) THEN
6645: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
6646: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
6647: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
6648: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
6649: END IF;
6650:

Line 6647: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

6643:
6644: IF ( g_unexp_level >= g_debug_level ) THEN
6645: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
6646: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
6647: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
6648: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
6649: END IF;
6650:
6651: END calculate_nonrec_tax;