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 2056: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

2052: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2053: p_data => x_msg_data );
2054:
2055: IF ( g_unexp_level >= g_debug_level ) THEN
2056: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
2057: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
2058: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
2059: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
2060: END IF;

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

2053: p_data => x_msg_data );
2054:
2055: IF ( g_unexp_level >= g_debug_level ) THEN
2056: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
2057: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
2058: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
2059: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
2060: END IF;
2061: RETURN;

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

2054:
2055: IF ( g_unexp_level >= g_debug_level ) THEN
2056: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
2057: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
2058: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
2059: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
2060: END IF;
2061: RETURN;
2062:

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

2379: l_update_by := FND_GLOBAL.USER_ID;
2380:
2381: IF ( (p_mode <> 'C') AND (p_mode <> 'R') )
2382: THEN
2383: fnd_message.set_name('IGC', 'IGC_CC_INVALID_MODE');
2384: fnd_message.set_token('MODE', p_mode,TRUE);
2385: IF(g_error_level >= g_debug_level) THEN
2386: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
2387: END IF;

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

2380:
2381: IF ( (p_mode <> 'C') AND (p_mode <> 'R') )
2382: THEN
2383: fnd_message.set_name('IGC', 'IGC_CC_INVALID_MODE');
2384: fnd_message.set_token('MODE', p_mode,TRUE);
2385: IF(g_error_level >= g_debug_level) THEN
2386: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
2387: END IF;
2388: fnd_msg_pub.add;

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

2399: l_encumbrance_status_old := l_cc_headers_rec.cc_encmbrnc_status;
2400: EXCEPTION
2401: WHEN OTHERS
2402: THEN
2403: fnd_message.set_name('IGC', 'IGC_CC_NOT_FOUND');
2404: fnd_message.set_token('CC_NUM', to_char(p_cc_header_id),TRUE);
2405: IF(g_error_level >= g_debug_level) THEN
2406: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
2407: END IF;

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

2400: EXCEPTION
2401: WHEN OTHERS
2402: THEN
2403: fnd_message.set_name('IGC', 'IGC_CC_NOT_FOUND');
2404: fnd_message.set_token('CC_NUM', to_char(p_cc_header_id),TRUE);
2405: IF(g_error_level >= g_debug_level) THEN
2406: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
2407: END IF;
2408: fnd_msg_pub.add;

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

2460: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
2461: l_api_name);
2462: END IF;
2463: IF ( g_unexp_level >= g_debug_level ) THEN
2464: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
2465: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
2466: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
2467: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
2468: END IF;

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

2461: l_api_name);
2462: END IF;
2463: IF ( g_unexp_level >= g_debug_level ) THEN
2464: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
2465: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
2466: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
2467: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
2468: END IF;
2469: RAISE E_DELETE;

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

2462: END IF;
2463: IF ( g_unexp_level >= g_debug_level ) THEN
2464: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
2465: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
2466: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
2467: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
2468: END IF;
2469: RAISE E_DELETE;
2470: END;

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

2516: WHERE set_of_books_id = l_cc_headers_rec.set_of_books_id;
2517: EXCEPTION
2518: WHEN NO_DATA_FOUND
2519: THEN
2520: fnd_message.set_name('IGC', 'IGC_CC_INVALID_GL_DATA');
2521: IF(g_error_level >= g_debug_level) THEN
2522: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
2523: END IF;
2524: fnd_msg_pub.add;

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

2598: FROM igc_cc_headers
2599: WHERE cc_header_id = p_cc_header_id;
2600: EXCEPTION
2601: WHEN OTHERS THEN
2602: fnd_message.set_name('IGC', 'IGC_CC_NOT_FOUND');
2603: fnd_message.set_token('CC_NUM', to_char(p_cc_header_id),TRUE);
2604: IF(g_error_level >= g_debug_level) THEN
2605: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
2606: END IF;

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

2599: WHERE cc_header_id = p_cc_header_id;
2600: EXCEPTION
2601: WHEN OTHERS THEN
2602: fnd_message.set_name('IGC', 'IGC_CC_NOT_FOUND');
2603: fnd_message.set_token('CC_NUM', to_char(p_cc_header_id),TRUE);
2604: IF(g_error_level >= g_debug_level) THEN
2605: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
2606: END IF;
2607: fnd_msg_pub.add;

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

3407: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
3408: l_api_name);
3409: END IF;
3410: IF ( g_unexp_level >= g_debug_level ) THEN
3411: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
3412: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
3413: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
3414: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
3415: END IF;

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

3408: l_api_name);
3409: END IF;
3410: IF ( g_unexp_level >= g_debug_level ) THEN
3411: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
3412: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
3413: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
3414: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
3415: END IF;
3416:

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

3409: END IF;
3410: IF ( g_unexp_level >= g_debug_level ) THEN
3411: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
3412: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
3413: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
3414: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
3415: END IF;
3416:
3417: RAISE E_UPDATE_CC_TABLES;

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

3696: IF ( (l_batch_result_code IS NOT NULL) AND (l_interface_row_count <> 0) )
3697: THEN
3698: IF (l_batch_result_code = 'HXX')
3699: THEN
3700: fnd_message.set_name('IGC', 'IGC_CC_CBC_RESULT_CODE_INVALID');
3701: IF(g_state_level >= g_debug_level) THEN
3702: FND_LOG.MESSAGE(g_state_level, l_full_path, FALSE);
3703: END IF;
3704: fnd_msg_pub.add;

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

3702: FND_LOG.MESSAGE(g_state_level, l_full_path, FALSE);
3703: END IF;
3704: fnd_msg_pub.add;
3705: ELSE
3706: fnd_message.set_name('IGC', 'IGC_CC_CBC_RESULT_CODE_'||l_batch_result_code);
3707: IF(g_state_level >= g_debug_level) THEN
3708: FND_LOG.MESSAGE(g_state_level, l_full_path, FALSE);
3709: END IF;
3710: fnd_msg_pub.add;

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

4017:
4018: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
4019: p_data => x_msg_data );
4020: IF ( g_unexp_level >= g_debug_level ) THEN
4021: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
4022: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
4023: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
4024: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
4025: END IF;

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

4018: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
4019: p_data => x_msg_data );
4020: IF ( g_unexp_level >= g_debug_level ) THEN
4021: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
4022: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
4023: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
4024: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
4025: END IF;
4026:

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

4019: p_data => x_msg_data );
4020: IF ( g_unexp_level >= g_debug_level ) THEN
4021: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
4022: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
4023: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
4024: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
4025: END IF;
4026:
4027: END Execute_Budgetary_Ctrl;

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

4081: END IF;
4082:
4083: IF (p_org_id IS NULL)
4084: THEN
4085: fnd_message.set_name('IGC', 'IGC_CC_NO_ORG_ID');
4086: IF(g_error_level >= g_debug_level) THEN
4087: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
4088: END IF;
4089: fnd_msg_pub.add;

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

4091: END IF;
4092:
4093: IF (p_sob_id IS NULL)
4094: THEN
4095: fnd_message.set_name('IGC', 'IGC_CC_NO_SOB_ID');
4096: IF(g_error_level >= g_debug_level) THEN
4097: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
4098: END IF;
4099: fnd_msg_pub.add;

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

4101: END IF;
4102:
4103: IF (p_cc_state IS NULL)
4104: THEN
4105: fnd_message.set_name('IGC', 'IGC_CC_NO_CC_STATE');
4106: IF(g_error_level >= g_debug_level) THEN
4107: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
4108: END IF;
4109: fnd_msg_pub.add;

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

4122: EXCEPTION
4123:
4124: WHEN NO_DATA_FOUND
4125: THEN
4126: fnd_message.set_name('IGC', 'IGC_CC_INVALID_GL_DATA');
4127: IF(g_error_level >= g_debug_level) THEN
4128: FND_LOG.MESSAGE(g_error_level, l_full_path || 'Msg4', FALSE);
4129: END IF;
4130: fnd_msg_pub.add;

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

4218:
4219: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
4220: p_data => x_msg_data );
4221: IF ( g_unexp_level >= g_debug_level ) THEN
4222: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
4223: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
4224: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
4225: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
4226: END IF;

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

4219: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
4220: p_data => x_msg_data );
4221: IF ( g_unexp_level >= g_debug_level ) THEN
4222: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
4223: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
4224: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
4225: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
4226: END IF;
4227:

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

4220: p_data => x_msg_data );
4221: IF ( g_unexp_level >= g_debug_level ) THEN
4222: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
4223: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
4224: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
4225: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
4226: END IF;
4227:
4228: END Check_Budgetary_Ctrl_On;

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

4443:
4444: IF ( (NVL(p_encumbrance_status_code,'X') <> 'P') AND
4445: (NVL(p_encumbrance_status_code,'X') <> 'T') )
4446: THEN
4447: fnd_message.set_name('IGC', 'IGC_CC_INVALID_STATUS_CODE');
4448: fnd_message.set_token('CODE', p_encumbrance_status_code,TRUE);
4449: IF(g_error_level >= g_debug_level) THEN
4450: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
4451: END IF;

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

4444: IF ( (NVL(p_encumbrance_status_code,'X') <> 'P') AND
4445: (NVL(p_encumbrance_status_code,'X') <> 'T') )
4446: THEN
4447: fnd_message.set_name('IGC', 'IGC_CC_INVALID_STATUS_CODE');
4448: fnd_message.set_token('CODE', p_encumbrance_status_code,TRUE);
4449: IF(g_error_level >= g_debug_level) THEN
4450: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
4451: END IF;
4452: fnd_msg_pub.add;

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

4464: EXCEPTION
4465:
4466: WHEN no_data_found
4467: THEN
4468: fnd_message.set_name('IGC', 'IGC_CC_NOT_FOUND');
4469: fnd_message.set_token('CC_NUM', to_char(p_cc_header_id),TRUE);
4470: IF(g_excep_level >= g_debug_level) THEN
4471: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
4472: END IF;

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

4465:
4466: WHEN no_data_found
4467: THEN
4468: fnd_message.set_name('IGC', 'IGC_CC_NOT_FOUND');
4469: fnd_message.set_token('CC_NUM', to_char(p_cc_header_id),TRUE);
4470: IF(g_excep_level >= g_debug_level) THEN
4471: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
4472: END IF;
4473: fnd_msg_pub.add;

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

4696:
4697: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
4698: p_data => x_msg_data );
4699: IF ( g_unexp_level >= g_debug_level ) THEN
4700: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
4701: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
4702: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
4703: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
4704: END IF;

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

4697: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
4698: p_data => x_msg_data );
4699: IF ( g_unexp_level >= g_debug_level ) THEN
4700: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
4701: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
4702: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
4703: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
4704: END IF;
4705:

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

4698: p_data => x_msg_data );
4699: IF ( g_unexp_level >= g_debug_level ) THEN
4700: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
4701: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
4702: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
4703: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
4704: END IF;
4705:
4706: END Set_Encumbrance_Status;

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

4942: EXCEPTION
4943: WHEN NO_DATA_FOUND THEN
4944: x_valid_cc := FND_API.G_FALSE;
4945: x_return_status := FND_API.G_RET_STS_ERROR;
4946: fnd_message.set_name('IGC', 'IGC_CC_INVALID_GL_DATA');
4947: IF(g_error_level >= g_debug_level) THEN
4948: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
4949: END IF;
4950: fnd_msg_pub.add;

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

5012: IF (p_end_date IS NOT NULL) THEN
5013: IF p_end_date < p_start_date THEN
5014: x_valid_cc := FND_API.G_FALSE;
5015: x_return_status := FND_API.G_RET_STS_ERROR;
5016: fnd_message.set_name('IGC', 'IGC_CC_EFFECTIVE_START_DATE');
5017: fnd_message.set_token('STARTDATE',FND_DATE.DATE_TO_CHARDATE (P_START_DATE),FALSE);
5018: IF(g_state_level >= g_debug_level) THEN
5019: FND_LOG.MESSAGE(g_state_level, l_full_path, FALSE);
5020: END IF;

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

5013: IF p_end_date < p_start_date THEN
5014: x_valid_cc := FND_API.G_FALSE;
5015: x_return_status := FND_API.G_RET_STS_ERROR;
5016: fnd_message.set_name('IGC', 'IGC_CC_EFFECTIVE_START_DATE');
5017: fnd_message.set_token('STARTDATE',FND_DATE.DATE_TO_CHARDATE (P_START_DATE),FALSE);
5018: IF(g_state_level >= g_debug_level) THEN
5019: FND_LOG.MESSAGE(g_state_level, l_full_path, FALSE);
5020: END IF;
5021: fnd_msg_pub.add;

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

5049:
5050: IF (NVL(l_COUNT,0) = 0) THEN
5051: x_valid_cc := FND_API.G_FALSE;
5052: x_return_status := FND_API.G_RET_STS_ERROR;
5053: fnd_message.set_name('IGC', 'IGC_CC_EFF_CCPER_START_DATE');
5054: fnd_message.set_token('STARTDATE', FND_DATE.DATE_TO_CHARDATE (P_START_DATE),FALSE);
5055: IF(g_state_level >= g_debug_level) THEN
5056: FND_LOG.MESSAGE(g_state_level, l_full_path, FALSE);
5057: END IF;

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

5050: IF (NVL(l_COUNT,0) = 0) THEN
5051: x_valid_cc := FND_API.G_FALSE;
5052: x_return_status := FND_API.G_RET_STS_ERROR;
5053: fnd_message.set_name('IGC', 'IGC_CC_EFF_CCPER_START_DATE');
5054: fnd_message.set_token('STARTDATE', FND_DATE.DATE_TO_CHARDATE (P_START_DATE),FALSE);
5055: IF(g_state_level >= g_debug_level) THEN
5056: FND_LOG.MESSAGE(g_state_level, l_full_path, FALSE);
5057: END IF;
5058: fnd_msg_pub.add;

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

5089: EXCEPTION
5090: WHEN OTHERS THEN
5091: l_COUNT := 0;
5092: IF ( g_unexp_level >= g_debug_level ) THEN
5093: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
5094: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
5095: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
5096: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
5097: END IF;

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

5090: WHEN OTHERS THEN
5091: l_COUNT := 0;
5092: IF ( g_unexp_level >= g_debug_level ) THEN
5093: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
5094: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
5095: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
5096: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
5097: END IF;
5098: END;

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

5091: l_COUNT := 0;
5092: IF ( g_unexp_level >= g_debug_level ) THEN
5093: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
5094: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
5095: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
5096: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
5097: END IF;
5098: END;
5099:

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

5099:
5100: IF (NVL(l_COUNT,0) = 0) THEN
5101: x_valid_cc := FND_API.G_FALSE;
5102: x_return_status := FND_API.G_RET_STS_ERROR;
5103: fnd_message.set_name('IGC', 'IGC_CC_EFF_CCGLPER_START_DATE');
5104: fnd_message.set_token('STARTDATE',FND_DATE.DATE_TO_CHARDATE(p_start_date),FALSE);
5105: IF(g_error_level >= g_debug_level) THEN
5106: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5107: END IF;

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

5100: IF (NVL(l_COUNT,0) = 0) THEN
5101: x_valid_cc := FND_API.G_FALSE;
5102: x_return_status := FND_API.G_RET_STS_ERROR;
5103: fnd_message.set_name('IGC', 'IGC_CC_EFF_CCGLPER_START_DATE');
5104: fnd_message.set_token('STARTDATE',FND_DATE.DATE_TO_CHARDATE(p_start_date),FALSE);
5105: IF(g_error_level >= g_debug_level) THEN
5106: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5107: END IF;
5108: fnd_msg_pub.add;

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

5127: IF (p_start_date > NVL(l_min_rel_start_date,p_start_date) )
5128: THEN
5129: x_valid_cc := FND_API.G_FALSE;
5130: x_return_status := FND_API.G_RET_STS_ERROR;
5131: fnd_message.set_name('IGC', 'IGC_CC_EFF_COVER_START_DATE');
5132: fnd_message.set_token('STARTDATE',FND_DATE.DATE_TO_CHARDATE(P_START_DATE),FALSE);
5133: IF(g_error_level >= g_debug_level) THEN
5134: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5135: END IF;

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

5128: THEN
5129: x_valid_cc := FND_API.G_FALSE;
5130: x_return_status := FND_API.G_RET_STS_ERROR;
5131: fnd_message.set_name('IGC', 'IGC_CC_EFF_COVER_START_DATE');
5132: fnd_message.set_token('STARTDATE',FND_DATE.DATE_TO_CHARDATE(P_START_DATE),FALSE);
5133: IF(g_error_level >= g_debug_level) THEN
5134: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5135: END IF;
5136: fnd_msg_pub.add;

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

5153: IF (p_start_date < NVL(l_cover_start_date,p_start_date) )
5154: THEN
5155: x_valid_cc := FND_API.G_FALSE;
5156: x_return_status := FND_API.G_RET_STS_ERROR;
5157: fnd_message.set_name('IGC', 'IGC_CC_EFF_REL_START_DATE');
5158: fnd_message.set_token('STARTDATE',FND_DATE.DATE_TO_CHARDATE (P_START_DATE),FALSE);
5159: IF(g_error_level >= g_debug_level) THEN
5160: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5161: END IF;

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

5154: THEN
5155: x_valid_cc := FND_API.G_FALSE;
5156: x_return_status := FND_API.G_RET_STS_ERROR;
5157: fnd_message.set_name('IGC', 'IGC_CC_EFF_REL_START_DATE');
5158: fnd_message.set_token('STARTDATE',FND_DATE.DATE_TO_CHARDATE (P_START_DATE),FALSE);
5159: IF(g_error_level >= g_debug_level) THEN
5160: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5161: END IF;
5162: fnd_msg_pub.add;

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

5165:
5166: ELSIF ( p_start_date IS NULL) THEN
5167: x_valid_cc := FND_API.G_FALSE;
5168: x_return_status := FND_API.G_RET_STS_ERROR;
5169: fnd_message.set_name('IGC', 'IGC_CC_NO_START_DATE');
5170: IF(g_error_level >= g_debug_level) THEN
5171: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5172: END IF;
5173: fnd_msg_pub.add;

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

5180:
5181: IF p_end_date < p_start_date THEN
5182: x_valid_cc := FND_API.G_FALSE;
5183: x_return_status := FND_API.G_RET_STS_ERROR;
5184: fnd_message.set_name('IGC', 'IGC_CC_EFFECTIVE_END_DATE');
5185: fnd_message.set_token('STARTDATE',FND_DATE.DATE_TO_CHARDATE (P_START_DATE),FALSE);
5186: fnd_message.set_token('ENDDATE',FND_DATE.DATE_TO_CHARDATE (P_END_DATE),FALSE);
5187: IF(g_error_level >= g_debug_level) THEN
5188: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);

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

5181: IF p_end_date < p_start_date THEN
5182: x_valid_cc := FND_API.G_FALSE;
5183: x_return_status := FND_API.G_RET_STS_ERROR;
5184: fnd_message.set_name('IGC', 'IGC_CC_EFFECTIVE_END_DATE');
5185: fnd_message.set_token('STARTDATE',FND_DATE.DATE_TO_CHARDATE (P_START_DATE),FALSE);
5186: fnd_message.set_token('ENDDATE',FND_DATE.DATE_TO_CHARDATE (P_END_DATE),FALSE);
5187: IF(g_error_level >= g_debug_level) THEN
5188: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5189: END IF;

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

5182: x_valid_cc := FND_API.G_FALSE;
5183: x_return_status := FND_API.G_RET_STS_ERROR;
5184: fnd_message.set_name('IGC', 'IGC_CC_EFFECTIVE_END_DATE');
5185: fnd_message.set_token('STARTDATE',FND_DATE.DATE_TO_CHARDATE (P_START_DATE),FALSE);
5186: fnd_message.set_token('ENDDATE',FND_DATE.DATE_TO_CHARDATE (P_END_DATE),FALSE);
5187: IF(g_error_level >= g_debug_level) THEN
5188: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5189: END IF;
5190: fnd_msg_pub.add;

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

5206: IF (p_end_date < NVL(l_max_rel_end_date,p_end_date) )
5207: THEN
5208: x_valid_cc := FND_API.G_FALSE;
5209: x_return_status := FND_API.G_RET_STS_ERROR;
5210: fnd_message.set_name('IGC', 'IGC_CC_EFF_COVER_END_DATE');
5211: IF(g_error_level >= g_debug_level) THEN
5212: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5213: END IF;
5214: fnd_msg_pub.add;

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

5230: IF (p_end_date > NVL(l_cover_end_date,p_end_date) )
5231: THEN
5232: x_valid_cc := FND_API.G_FALSE;
5233: x_return_status := FND_API.G_RET_STS_ERROR;
5234: fnd_message.set_name('IGC', 'IGC_CC_EFF_REL_END_DATE');
5235: IF(g_error_level >= g_debug_level) THEN
5236: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5237: END IF;
5238: fnd_msg_pub.add;

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

5249:
5250: IF (p_cc_det_pf_date < p_start_date) THEN
5251: x_valid_cc := FND_API.G_FALSE;
5252: x_return_status := FND_API.G_RET_STS_ERROR;
5253: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_START_DATE');
5254: fnd_message.set_token('PFDATE',FND_DATE.DATE_TO_CHARDATE(p_cc_det_pf_date),FALSE);
5255: IF(g_error_level >= g_debug_level) THEN
5256: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5257: END IF;

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

5250: IF (p_cc_det_pf_date < p_start_date) THEN
5251: x_valid_cc := FND_API.G_FALSE;
5252: x_return_status := FND_API.G_RET_STS_ERROR;
5253: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_START_DATE');
5254: fnd_message.set_token('PFDATE',FND_DATE.DATE_TO_CHARDATE(p_cc_det_pf_date),FALSE);
5255: IF(g_error_level >= g_debug_level) THEN
5256: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5257: END IF;
5258: fnd_msg_pub.add;

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

5261: (p_end_date IS NOT NULL)
5262: ) THEN
5263: x_valid_cc := FND_API.G_FALSE;
5264: x_return_status := FND_API.G_RET_STS_ERROR;
5265: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_END_DATE');
5266: fnd_message.set_token('PFDATE',FND_DATE.DATE_TO_CHARDATE(p_cc_det_pf_date),FALSE);
5267: IF(g_error_level >= g_debug_level) THEN
5268: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5269: END IF;

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

5262: ) THEN
5263: x_valid_cc := FND_API.G_FALSE;
5264: x_return_status := FND_API.G_RET_STS_ERROR;
5265: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_END_DATE');
5266: fnd_message.set_token('PFDATE',FND_DATE.DATE_TO_CHARDATE(p_cc_det_pf_date),FALSE);
5267: IF(g_error_level >= g_debug_level) THEN
5268: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5269: END IF;
5270: fnd_msg_pub.add;

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

5294: EXCEPTION
5295: WHEN OTHERS THEN
5296: l_COUNT := 0;
5297: IF ( g_unexp_level >= g_debug_level ) THEN
5298: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
5299: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
5300: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
5301: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
5302: END IF;

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

5295: WHEN OTHERS THEN
5296: l_COUNT := 0;
5297: IF ( g_unexp_level >= g_debug_level ) THEN
5298: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
5299: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
5300: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
5301: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
5302: END IF;
5303: END;

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

5296: l_COUNT := 0;
5297: IF ( g_unexp_level >= g_debug_level ) THEN
5298: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
5299: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
5300: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
5301: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
5302: END IF;
5303: END;
5304: IF NVL(l_COUNT,0) = 0 THEN

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

5303: END;
5304: IF NVL(l_COUNT,0) = 0 THEN
5305: x_valid_cc := FND_API.G_FALSE;
5306: x_return_status := FND_API.G_RET_STS_ERROR;
5307: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_DATE');
5308: IF(g_error_level >= g_debug_level) THEN
5309: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5310: END IF;
5311: fnd_msg_pub.add;

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

5329: p_prev_acct_date IS NOT NULL)
5330: THEN
5331: x_valid_cc := FND_API.G_FALSE;
5332: x_return_status := FND_API.G_RET_STS_ERROR;
5333: fnd_message.set_name('IGC', 'IGC_CC_ACCT_DATE');
5334: fnd_message.set_token('ACCTDATE',FND_DATE.DATE_TO_CHARDATE(P_ACCT_DATE),FALSE);
5335: fnd_message.set_token('STARTDATE',FND_DATE.DATE_TO_CHARDATE(P_START_DATE),FALSE);
5336: fnd_message.set_token('ENDDATE',FND_DATE.DATE_TO_CHARDATE(P_END_DATE),FALSE);
5337: IF(g_error_level >= g_debug_level) THEN

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

5330: THEN
5331: x_valid_cc := FND_API.G_FALSE;
5332: x_return_status := FND_API.G_RET_STS_ERROR;
5333: fnd_message.set_name('IGC', 'IGC_CC_ACCT_DATE');
5334: fnd_message.set_token('ACCTDATE',FND_DATE.DATE_TO_CHARDATE(P_ACCT_DATE),FALSE);
5335: fnd_message.set_token('STARTDATE',FND_DATE.DATE_TO_CHARDATE(P_START_DATE),FALSE);
5336: fnd_message.set_token('ENDDATE',FND_DATE.DATE_TO_CHARDATE(P_END_DATE),FALSE);
5337: IF(g_error_level >= g_debug_level) THEN
5338: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);

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

5331: x_valid_cc := FND_API.G_FALSE;
5332: x_return_status := FND_API.G_RET_STS_ERROR;
5333: fnd_message.set_name('IGC', 'IGC_CC_ACCT_DATE');
5334: fnd_message.set_token('ACCTDATE',FND_DATE.DATE_TO_CHARDATE(P_ACCT_DATE),FALSE);
5335: fnd_message.set_token('STARTDATE',FND_DATE.DATE_TO_CHARDATE(P_START_DATE),FALSE);
5336: fnd_message.set_token('ENDDATE',FND_DATE.DATE_TO_CHARDATE(P_END_DATE),FALSE);
5337: IF(g_error_level >= g_debug_level) THEN
5338: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5339: END IF;

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

5332: x_return_status := FND_API.G_RET_STS_ERROR;
5333: fnd_message.set_name('IGC', 'IGC_CC_ACCT_DATE');
5334: fnd_message.set_token('ACCTDATE',FND_DATE.DATE_TO_CHARDATE(P_ACCT_DATE),FALSE);
5335: fnd_message.set_token('STARTDATE',FND_DATE.DATE_TO_CHARDATE(P_START_DATE),FALSE);
5336: fnd_message.set_token('ENDDATE',FND_DATE.DATE_TO_CHARDATE(P_END_DATE),FALSE);
5337: IF(g_error_level >= g_debug_level) THEN
5338: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5339: END IF;
5340: fnd_msg_pub.add;

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

5349: p_prev_acct_date < SYSDATE)
5350: THEN
5351: x_valid_cc := FND_API.G_FALSE;
5352: x_return_status := FND_API.G_RET_STS_ERROR;
5353: fnd_message.set_name('IGC', 'IGC_CC_ACCT_DATE_CL_CT');
5354: fnd_message.set_token('ACCTDATE',FND_DATE.DATE_TO_CHARDATE(P_ACCT_DATE),FALSE);
5355: fnd_message.set_token('PREV_ACCTDATE',FND_DATE.DATE_TO_CHARDATE(P_PREV_ACCT_DATE),FALSE);
5356: IF(g_error_level >= g_debug_level) THEN
5357: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);

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

5350: THEN
5351: x_valid_cc := FND_API.G_FALSE;
5352: x_return_status := FND_API.G_RET_STS_ERROR;
5353: fnd_message.set_name('IGC', 'IGC_CC_ACCT_DATE_CL_CT');
5354: fnd_message.set_token('ACCTDATE',FND_DATE.DATE_TO_CHARDATE(P_ACCT_DATE),FALSE);
5355: fnd_message.set_token('PREV_ACCTDATE',FND_DATE.DATE_TO_CHARDATE(P_PREV_ACCT_DATE),FALSE);
5356: IF(g_error_level >= g_debug_level) THEN
5357: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5358: END IF;

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

5351: x_valid_cc := FND_API.G_FALSE;
5352: x_return_status := FND_API.G_RET_STS_ERROR;
5353: fnd_message.set_name('IGC', 'IGC_CC_ACCT_DATE_CL_CT');
5354: fnd_message.set_token('ACCTDATE',FND_DATE.DATE_TO_CHARDATE(P_ACCT_DATE),FALSE);
5355: fnd_message.set_token('PREV_ACCTDATE',FND_DATE.DATE_TO_CHARDATE(P_PREV_ACCT_DATE),FALSE);
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 5403: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

5399: EXCEPTION
5400: WHEN OTHERS THEN
5401: l_COUNT := 0;
5402: IF ( g_unexp_level >= g_debug_level ) THEN
5403: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
5404: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
5405: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
5406: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
5407: END IF;

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

5400: WHEN OTHERS THEN
5401: l_COUNT := 0;
5402: IF ( g_unexp_level >= g_debug_level ) THEN
5403: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
5404: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
5405: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
5406: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
5407: END IF;
5408:

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

5401: l_COUNT := 0;
5402: IF ( g_unexp_level >= g_debug_level ) THEN
5403: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
5404: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
5405: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
5406: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
5407: END IF;
5408:
5409: END;

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

5409: END;
5410: IF NVL(l_COUNT,0) = 0 THEN
5411: x_valid_cc := FND_API.G_FALSE;
5412: x_return_status := FND_API.G_RET_STS_ERROR;
5413: fnd_message.set_name('IGC', 'IGC_CC_ACCT_DATE_OF');
5414: IF(g_error_level >= g_debug_level) THEN
5415: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5416: END IF;
5417: fnd_msg_pub.add;

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

5481: IF l_orig_fiscal_year <> l_new_fiscal_year
5482: THEN
5483: x_valid_cc := FND_API.G_FALSE;
5484: x_return_status := FND_API.G_RET_STS_ERROR;
5485: fnd_message.set_name('IGC', 'IGC_CC_ACCT_FISCAL_YRS_NE');
5486: fnd_message.set_TOKEN('PREVACTDATE',FND_DATE.DATE_TO_CHARDATE (p_prev_acct_date),FALSE);
5487: IF(g_error_level >= g_debug_level) THEN
5488: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5489: END IF;

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

5482: THEN
5483: x_valid_cc := FND_API.G_FALSE;
5484: x_return_status := FND_API.G_RET_STS_ERROR;
5485: fnd_message.set_name('IGC', 'IGC_CC_ACCT_FISCAL_YRS_NE');
5486: fnd_message.set_TOKEN('PREVACTDATE',FND_DATE.DATE_TO_CHARDATE (p_prev_acct_date),FALSE);
5487: IF(g_error_level >= g_debug_level) THEN
5488: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5489: END IF;
5490: fnd_msg_pub.add;

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

5514: EXCEPTION
5515: WHEN OTHERS THEN
5516: l_COUNT := 0;
5517: IF ( g_unexp_level >= g_debug_level ) THEN
5518: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
5519: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
5520: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
5521: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
5522: END IF;

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

5515: WHEN OTHERS THEN
5516: l_COUNT := 0;
5517: IF ( g_unexp_level >= g_debug_level ) THEN
5518: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
5519: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
5520: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
5521: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
5522: END IF;
5523: END;

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

5516: l_COUNT := 0;
5517: IF ( g_unexp_level >= g_debug_level ) THEN
5518: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
5519: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
5520: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
5521: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
5522: END IF;
5523: END;
5524: IF NVL(l_COUNT,0) = 0 THEN

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

5523: END;
5524: IF NVL(l_COUNT,0) = 0 THEN
5525: x_valid_cc := FND_API.G_FALSE;
5526: x_return_status := FND_API.G_RET_STS_ERROR;
5527: fnd_message.set_name('IGC', 'IGC_CC_ACCT_DATE_O');
5528: IF(g_error_level >= g_debug_level) THEN
5529: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5530: END IF;
5531: fnd_msg_pub.add;

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

5550: p_prev_acct_date IS NOT NULL)
5551: THEN
5552: x_valid_cc := FND_API.G_FALSE;
5553: x_return_status := FND_API.G_RET_STS_ERROR;
5554: fnd_message.set_name('IGC', 'IGC_CC_ACCT_DATE');
5555: fnd_message.set_token('ACCTDATE',FND_DATE.DATE_TO_CHARDATE(P_ACCT_DATE),FALSE);
5556: fnd_message.set_token('STARTDATE',FND_DATE.DATE_TO_CHARDATE(P_START_DATE),FALSE);
5557: fnd_message.set_token('ENDDATE',FND_DATE.DATE_TO_CHARDATE(P_END_DATE),FALSE);
5558: IF(g_error_level >= g_debug_level) THEN

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

5551: THEN
5552: x_valid_cc := FND_API.G_FALSE;
5553: x_return_status := FND_API.G_RET_STS_ERROR;
5554: fnd_message.set_name('IGC', 'IGC_CC_ACCT_DATE');
5555: fnd_message.set_token('ACCTDATE',FND_DATE.DATE_TO_CHARDATE(P_ACCT_DATE),FALSE);
5556: fnd_message.set_token('STARTDATE',FND_DATE.DATE_TO_CHARDATE(P_START_DATE),FALSE);
5557: fnd_message.set_token('ENDDATE',FND_DATE.DATE_TO_CHARDATE(P_END_DATE),FALSE);
5558: IF(g_error_level >= g_debug_level) THEN
5559: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);

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

5552: x_valid_cc := FND_API.G_FALSE;
5553: x_return_status := FND_API.G_RET_STS_ERROR;
5554: fnd_message.set_name('IGC', 'IGC_CC_ACCT_DATE');
5555: fnd_message.set_token('ACCTDATE',FND_DATE.DATE_TO_CHARDATE(P_ACCT_DATE),FALSE);
5556: fnd_message.set_token('STARTDATE',FND_DATE.DATE_TO_CHARDATE(P_START_DATE),FALSE);
5557: fnd_message.set_token('ENDDATE',FND_DATE.DATE_TO_CHARDATE(P_END_DATE),FALSE);
5558: IF(g_error_level >= g_debug_level) THEN
5559: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5560: END IF;

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

5553: x_return_status := FND_API.G_RET_STS_ERROR;
5554: fnd_message.set_name('IGC', 'IGC_CC_ACCT_DATE');
5555: fnd_message.set_token('ACCTDATE',FND_DATE.DATE_TO_CHARDATE(P_ACCT_DATE),FALSE);
5556: fnd_message.set_token('STARTDATE',FND_DATE.DATE_TO_CHARDATE(P_START_DATE),FALSE);
5557: fnd_message.set_token('ENDDATE',FND_DATE.DATE_TO_CHARDATE(P_END_DATE),FALSE);
5558: IF(g_error_level >= g_debug_level) THEN
5559: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5560: END IF;
5561: fnd_msg_pub.add;

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

5570: p_prev_acct_date < SYSDATE)
5571: THEN
5572: x_valid_cc := FND_API.G_FALSE;
5573: x_return_status := FND_API.G_RET_STS_ERROR;
5574: fnd_message.set_name('IGC', 'IGC_CC_ACCT_DATE_CL_CT');
5575: fnd_message.set_token('ACCTDATE',FND_DATE.DATE_TO_CHARDATE(P_ACCT_DATE),FALSE);
5576: fnd_message.set_token('PREV_ACCTDATE',FND_DATE.DATE_TO_CHARDATE(P_PREV_ACCT_DATE),FALSE);
5577: IF(g_error_level >= g_debug_level) THEN
5578: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);

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

5571: THEN
5572: x_valid_cc := FND_API.G_FALSE;
5573: x_return_status := FND_API.G_RET_STS_ERROR;
5574: fnd_message.set_name('IGC', 'IGC_CC_ACCT_DATE_CL_CT');
5575: fnd_message.set_token('ACCTDATE',FND_DATE.DATE_TO_CHARDATE(P_ACCT_DATE),FALSE);
5576: fnd_message.set_token('PREV_ACCTDATE',FND_DATE.DATE_TO_CHARDATE(P_PREV_ACCT_DATE),FALSE);
5577: IF(g_error_level >= g_debug_level) THEN
5578: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5579: END IF;

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

5572: x_valid_cc := FND_API.G_FALSE;
5573: x_return_status := FND_API.G_RET_STS_ERROR;
5574: fnd_message.set_name('IGC', 'IGC_CC_ACCT_DATE_CL_CT');
5575: fnd_message.set_token('ACCTDATE',FND_DATE.DATE_TO_CHARDATE(P_ACCT_DATE),FALSE);
5576: fnd_message.set_token('PREV_ACCTDATE',FND_DATE.DATE_TO_CHARDATE(P_PREV_ACCT_DATE),FALSE);
5577: IF(g_error_level >= g_debug_level) THEN
5578: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5579: END IF;
5580: fnd_msg_pub.add;

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

5620: EXCEPTION
5621: WHEN OTHERS THEN
5622: l_COUNT := 0;
5623: IF ( g_unexp_level >= g_debug_level ) THEN
5624: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
5625: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
5626: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
5627: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
5628: END IF;

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

5621: WHEN OTHERS THEN
5622: l_COUNT := 0;
5623: IF ( g_unexp_level >= g_debug_level ) THEN
5624: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
5625: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
5626: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
5627: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
5628: END IF;
5629: END;

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

5622: l_COUNT := 0;
5623: IF ( g_unexp_level >= g_debug_level ) THEN
5624: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
5625: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
5626: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
5627: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
5628: END IF;
5629: END;
5630: IF NVL(l_COUNT,0) = 0 THEN

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

5629: END;
5630: IF NVL(l_COUNT,0) = 0 THEN
5631: x_valid_cc := FND_API.G_FALSE;
5632: x_return_status := FND_API.G_RET_STS_ERROR;
5633: fnd_message.set_name('IGC', 'IGC_CC_ACCT_DATE_OF');
5634: IF(g_error_level >= g_debug_level) THEN
5635: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5636: END IF;
5637: fnd_msg_pub.add;

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

5701: IF l_orig_fiscal_year <> l_new_fiscal_year
5702: THEN
5703: x_valid_cc := FND_API.G_FALSE;
5704: x_return_status := FND_API.G_RET_STS_ERROR;
5705: fnd_message.set_name('IGC', 'IGC_CC_ACCT_FISCAL_YRS_NE');
5706: fnd_message.set_TOKEN('PREVACTDATE',FND_DATE.DATE_TO_CHARDATE (p_prev_acct_date),FALSE);
5707: IF(g_error_level >= g_debug_level) THEN
5708: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5709: END IF;

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

5702: THEN
5703: x_valid_cc := FND_API.G_FALSE;
5704: x_return_status := FND_API.G_RET_STS_ERROR;
5705: fnd_message.set_name('IGC', 'IGC_CC_ACCT_FISCAL_YRS_NE');
5706: fnd_message.set_TOKEN('PREVACTDATE',FND_DATE.DATE_TO_CHARDATE (p_prev_acct_date),FALSE);
5707: IF(g_error_level >= g_debug_level) THEN
5708: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5709: END IF;
5710: fnd_msg_pub.add;

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

5734: EXCEPTION
5735: WHEN OTHERS THEN
5736: l_COUNT := 0;
5737: IF ( g_unexp_level >= g_debug_level ) THEN
5738: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
5739: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
5740: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
5741: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
5742: END IF;

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

5735: WHEN OTHERS THEN
5736: l_COUNT := 0;
5737: IF ( g_unexp_level >= g_debug_level ) THEN
5738: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
5739: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
5740: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
5741: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
5742: END IF;
5743: END;

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

5736: l_COUNT := 0;
5737: IF ( g_unexp_level >= g_debug_level ) THEN
5738: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
5739: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
5740: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
5741: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
5742: END IF;
5743: END;
5744: IF NVL(l_COUNT,0) = 0 THEN

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

5743: END;
5744: IF NVL(l_COUNT,0) = 0 THEN
5745: x_valid_cc := FND_API.G_FALSE;
5746: x_return_status := FND_API.G_RET_STS_ERROR;
5747: fnd_message.set_name('IGC', 'IGC_CC_ACCT_DATE_O');
5748: IF(g_error_level >= g_debug_level) THEN
5749: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5750: END IF;
5751: fnd_msg_pub.add;

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

5766: EXCEPTION
5767: WHEN no_data_found THEN
5768: x_valid_cc := FND_API.G_FALSE;
5769: x_return_status := FND_API.G_RET_STS_ERROR;
5770: fnd_message.set_name('IGC', 'IGC_CC_NOT_FOUND');
5771: fnd_message.set_token('CC_NUM', to_char(p_cc_header_id),TRUE);
5772: IF(g_error_level >= g_debug_level) THEN
5773: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5774: END IF;

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

5767: WHEN no_data_found THEN
5768: x_valid_cc := FND_API.G_FALSE;
5769: x_return_status := FND_API.G_RET_STS_ERROR;
5770: fnd_message.set_name('IGC', 'IGC_CC_NOT_FOUND');
5771: fnd_message.set_token('CC_NUM', to_char(p_cc_header_id),TRUE);
5772: IF(g_error_level >= g_debug_level) THEN
5773: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5774: END IF;
5775: l_error_message := fnd_message.get;

Line 5775: l_error_message := fnd_message.get;

5771: fnd_message.set_token('CC_NUM', to_char(p_cc_header_id),TRUE);
5772: IF(g_error_level >= g_debug_level) THEN
5773: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5774: END IF;
5775: l_error_message := fnd_message.get;
5776: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name, l_error_message);
5777: RAISE E_CC_NOT_FOUND;
5778:
5779: END;

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

5823: -- the amount in the account line
5824: THEN
5825: x_valid_cc := FND_API.G_FALSE;
5826: x_return_status := FND_API.G_RET_STS_ERROR;
5827: fnd_message.set_name('IGC', 'IGC_CC_NO_PF');
5828: fnd_message.set_token('ACCT_NUM', to_char(l_cc_acct_lines_rec.cc_acct_line_num),TRUE);
5829: IF(g_error_level >= g_debug_level) THEN
5830: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5831: END IF;

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

5824: THEN
5825: x_valid_cc := FND_API.G_FALSE;
5826: x_return_status := FND_API.G_RET_STS_ERROR;
5827: fnd_message.set_name('IGC', 'IGC_CC_NO_PF');
5828: fnd_message.set_token('ACCT_NUM', to_char(l_cc_acct_lines_rec.cc_acct_line_num),TRUE);
5829: IF(g_error_level >= g_debug_level) THEN
5830: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5831: END IF;
5832: fnd_msg_pub.add;

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

5844:
5845: IF (l_cc_det_pf_lines_rec.cc_det_pf_date < p_acct_date) THEN
5846: x_valid_cc := FND_API.G_FALSE;
5847: x_return_status := FND_API.G_RET_STS_ERROR;
5848: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_ACCT_DATE');
5849: fnd_message.set_TOKEN('PFDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_date),FALSE);
5850: fnd_message.set_TOKEN('ACCTDATE',FND_DATE.DATE_TO_CHARDATE (p_acct_date),FALSE);
5851: IF(g_error_level >= g_debug_level) THEN
5852: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);

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

5845: IF (l_cc_det_pf_lines_rec.cc_det_pf_date < p_acct_date) THEN
5846: x_valid_cc := FND_API.G_FALSE;
5847: x_return_status := FND_API.G_RET_STS_ERROR;
5848: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_ACCT_DATE');
5849: fnd_message.set_TOKEN('PFDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_date),FALSE);
5850: fnd_message.set_TOKEN('ACCTDATE',FND_DATE.DATE_TO_CHARDATE (p_acct_date),FALSE);
5851: IF(g_error_level >= g_debug_level) THEN
5852: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5853: END IF;

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

5846: x_valid_cc := FND_API.G_FALSE;
5847: x_return_status := FND_API.G_RET_STS_ERROR;
5848: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_ACCT_DATE');
5849: fnd_message.set_TOKEN('PFDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_date),FALSE);
5850: fnd_message.set_TOKEN('ACCTDATE',FND_DATE.DATE_TO_CHARDATE (p_acct_date),FALSE);
5851: IF(g_error_level >= g_debug_level) THEN
5852: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5853: END IF;
5854: fnd_msg_pub.add;

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

5867:
5868: IF (l_cc_acct_cnt = 0) THEN
5869: x_valid_cc := FND_API.G_FALSE;
5870: x_return_status := FND_API.G_RET_STS_ERROR;
5871: fnd_message.set_name('IGC', 'IGC_CC_NO_ACCT_LINES');
5872: fnd_message.set_token('CC_NUM', l_cc_headers_rec.cc_num,TRUE);
5873: IF(g_error_level >= g_debug_level) THEN
5874: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5875: END IF;

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

5868: IF (l_cc_acct_cnt = 0) THEN
5869: x_valid_cc := FND_API.G_FALSE;
5870: x_return_status := FND_API.G_RET_STS_ERROR;
5871: fnd_message.set_name('IGC', 'IGC_CC_NO_ACCT_LINES');
5872: fnd_message.set_token('CC_NUM', l_cc_headers_rec.cc_num,TRUE);
5873: IF(g_error_level >= g_debug_level) THEN
5874: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5875: END IF;
5876: fnd_msg_pub.add;

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

5890: EXCEPTION
5891: WHEN no_data_found THEN
5892: x_valid_cc := FND_API.G_FALSE;
5893: x_return_status := FND_API.G_RET_STS_ERROR;
5894: fnd_message.set_name('IGC', 'IGC_CC_NOT_FOUND');
5895: fnd_message.set_token('CC_NUM', to_char(p_cc_header_id),TRUE);
5896: IF(g_error_level >= g_debug_level) THEN
5897: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5898: END IF;

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

5891: WHEN no_data_found THEN
5892: x_valid_cc := FND_API.G_FALSE;
5893: x_return_status := FND_API.G_RET_STS_ERROR;
5894: fnd_message.set_name('IGC', 'IGC_CC_NOT_FOUND');
5895: fnd_message.set_token('CC_NUM', to_char(p_cc_header_id),TRUE);
5896: IF(g_error_level >= g_debug_level) THEN
5897: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5898: END IF;
5899: l_error_message := fnd_message.get;

Line 5899: l_error_message := fnd_message.get;

5895: fnd_message.set_token('CC_NUM', to_char(p_cc_header_id),TRUE);
5896: IF(g_error_level >= g_debug_level) THEN
5897: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5898: END IF;
5899: l_error_message := fnd_message.get;
5900: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name, l_error_message);
5901: RAISE E_CC_NOT_FOUND;
5902:
5903: END;

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

5940: -- the amount in the account line
5941: THEN
5942: x_valid_cc := FND_API.G_FALSE;
5943: x_return_status := FND_API.G_RET_STS_ERROR;
5944: fnd_message.set_name('IGC', 'IGC_CC_NO_PF');
5945: fnd_message.set_token('ACCT_NUM', to_char(l_cc_acct_lines_rec.cc_acct_line_num),TRUE);
5946: IF(g_error_level >= g_debug_level) THEN
5947: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5948: END IF;

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

5941: THEN
5942: x_valid_cc := FND_API.G_FALSE;
5943: x_return_status := FND_API.G_RET_STS_ERROR;
5944: fnd_message.set_name('IGC', 'IGC_CC_NO_PF');
5945: fnd_message.set_token('ACCT_NUM', to_char(l_cc_acct_lines_rec.cc_acct_line_num),TRUE);
5946: IF(g_error_level >= g_debug_level) THEN
5947: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5948: END IF;
5949: fnd_msg_pub.add;

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

5961:
5962: IF (l_cc_det_pf_lines_rec.cc_det_pf_date < p_start_date) THEN
5963: x_valid_cc := FND_API.G_FALSE;
5964: x_return_status := FND_API.G_RET_STS_ERROR;
5965: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_START_DATE');
5966: fnd_message.set_TOKEN('PFDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_date),FALSE);
5967: IF (g_error_level >= g_debug_level) THEN
5968: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5969: END IF;

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

5962: IF (l_cc_det_pf_lines_rec.cc_det_pf_date < p_start_date) THEN
5963: x_valid_cc := FND_API.G_FALSE;
5964: x_return_status := FND_API.G_RET_STS_ERROR;
5965: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_START_DATE');
5966: fnd_message.set_TOKEN('PFDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_date),FALSE);
5967: IF (g_error_level >= g_debug_level) THEN
5968: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5969: END IF;
5970: fnd_msg_pub.add;

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

5976: (p_end_date IS NOT NULL)
5977: ) THEN
5978: x_valid_cc := FND_API.G_FALSE;
5979: x_return_status := FND_API.G_RET_STS_ERROR;
5980: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_END_DATE');
5981: fnd_message.set_TOKEN('PFDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_date),FALSE);
5982: IF(g_error_level >= g_debug_level) THEN
5983: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5984: END IF;

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

5977: ) THEN
5978: x_valid_cc := FND_API.G_FALSE;
5979: x_return_status := FND_API.G_RET_STS_ERROR;
5980: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_END_DATE');
5981: fnd_message.set_TOKEN('PFDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_date),FALSE);
5982: IF(g_error_level >= g_debug_level) THEN
5983: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5984: END IF;
5985: fnd_msg_pub.add;

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

6019: EXCEPTION
6020: WHEN OTHERS THEN
6021: l_COUNT := 0;
6022: IF ( g_unexp_level >= g_debug_level ) THEN
6023: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
6024: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
6025: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
6026: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
6027: END IF;

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

6020: WHEN OTHERS THEN
6021: l_COUNT := 0;
6022: IF ( g_unexp_level >= g_debug_level ) THEN
6023: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
6024: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
6025: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
6026: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
6027: END IF;
6028: END;

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

6021: l_COUNT := 0;
6022: IF ( g_unexp_level >= g_debug_level ) THEN
6023: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
6024: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
6025: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
6026: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
6027: END IF;
6028: END;
6029: IF NVL(l_COUNT,0) = 0 THEN

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

6028: END;
6029: IF NVL(l_COUNT,0) = 0 THEN
6030: x_valid_cc := FND_API.G_FALSE;
6031: x_return_status := FND_API.G_RET_STS_ERROR;
6032: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_DATE');
6033: IF(g_error_level >= g_debug_level) THEN
6034: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6035: END IF;
6036: fnd_msg_pub.add;

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

6090: TRUNC(l_cc_det_pf_lines_rec.cc_det_pf_encmbrnc_date)
6091: THEN
6092: x_valid_cc := FND_API.G_FALSE;
6093: x_return_status := FND_API.G_RET_STS_ERROR;
6094: fnd_message.set_name('IGC','IGC_CC_DET_PF_DATE_NO_UPDATE');
6095: fnd_message.set_TOKEN('ENCMBRNCDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_encmbrnc_date),FALSE);
6096: IF(g_error_level >= g_debug_level) THEN
6097: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6098: END IF;

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

6091: THEN
6092: x_valid_cc := FND_API.G_FALSE;
6093: x_return_status := FND_API.G_RET_STS_ERROR;
6094: fnd_message.set_name('IGC','IGC_CC_DET_PF_DATE_NO_UPDATE');
6095: fnd_message.set_TOKEN('ENCMBRNCDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_encmbrnc_date),FALSE);
6096: IF(g_error_level >= g_debug_level) THEN
6097: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6098: END IF;
6099: fnd_msg_pub.add;

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

6165: IF l_orig_fiscal_year <> l_new_fiscal_year
6166: THEN
6167: x_valid_cc := FND_API.G_FALSE;
6168: x_return_status := FND_API.G_RET_STS_ERROR;
6169: fnd_message.set_name('IGC', 'IGC_CC_FISCAL_YRS_NE');
6170: fnd_message.set_TOKEN('ENCMBRNCDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_encmbrnc_date),FALSE);
6171: IF(g_error_level >= g_debug_level) THEN
6172: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6173: END IF;

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

6166: THEN
6167: x_valid_cc := FND_API.G_FALSE;
6168: x_return_status := FND_API.G_RET_STS_ERROR;
6169: fnd_message.set_name('IGC', 'IGC_CC_FISCAL_YRS_NE');
6170: fnd_message.set_TOKEN('ENCMBRNCDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_encmbrnc_date),FALSE);
6171: IF(g_error_level >= g_debug_level) THEN
6172: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6173: END IF;
6174: fnd_msg_pub.add;

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

6196: -- This validation now needs to include the withheld amount
6197: THEN
6198: x_valid_cc := FND_API.G_FALSE;
6199: x_return_status := FND_API.G_RET_STS_ERROR;
6200: fnd_message.set_name('IGC', 'IGC_CC_AMT_MISMATCH');
6201: fnd_message.set_token('ACCT_NUM',to_char(l_cc_acct_lines_rec.cc_acct_line_num),TRUE);
6202: IF(g_error_level >= g_debug_level) THEN
6203: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6204: END IF;

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

6197: THEN
6198: x_valid_cc := FND_API.G_FALSE;
6199: x_return_status := FND_API.G_RET_STS_ERROR;
6200: fnd_message.set_name('IGC', 'IGC_CC_AMT_MISMATCH');
6201: fnd_message.set_token('ACCT_NUM',to_char(l_cc_acct_lines_rec.cc_acct_line_num),TRUE);
6202: IF(g_error_level >= g_debug_level) THEN
6203: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6204: END IF;
6205: fnd_msg_pub.add;

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

6211:
6212: IF (l_cc_acct_cnt = 0) THEN
6213: x_valid_cc := FND_API.G_FALSE;
6214: x_return_status := FND_API.G_RET_STS_ERROR;
6215: fnd_message.set_name('IGC', 'IGC_CC_NO_ACCT_LINES');
6216: fnd_message.set_token('CC_NUM', l_cc_headers_rec.cc_num,TRUE);
6217: IF(g_error_level >= g_debug_level) THEN
6218: FND_LOG.MESSAGE(g_error_level, g_debug_level, FALSE);
6219: END IF;

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

6212: IF (l_cc_acct_cnt = 0) THEN
6213: x_valid_cc := FND_API.G_FALSE;
6214: x_return_status := FND_API.G_RET_STS_ERROR;
6215: fnd_message.set_name('IGC', 'IGC_CC_NO_ACCT_LINES');
6216: fnd_message.set_token('CC_NUM', l_cc_headers_rec.cc_num,TRUE);
6217: IF(g_error_level >= g_debug_level) THEN
6218: FND_LOG.MESSAGE(g_error_level, g_debug_level, FALSE);
6219: END IF;
6220: fnd_msg_pub.add;

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

6237: EXCEPTION
6238: WHEN no_data_found THEN
6239: x_valid_cc := FND_API.G_FALSE;
6240: x_return_status := FND_API.G_RET_STS_ERROR;
6241: fnd_message.set_name('IGC', 'IGC_CC_NOT_FOUND');
6242: fnd_message.set_token('CC_NUM', to_char(p_cc_header_id),TRUE);
6243: IF(g_error_level >= g_debug_level) THEN
6244: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6245: END IF;

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

6238: WHEN no_data_found THEN
6239: x_valid_cc := FND_API.G_FALSE;
6240: x_return_status := FND_API.G_RET_STS_ERROR;
6241: fnd_message.set_name('IGC', 'IGC_CC_NOT_FOUND');
6242: fnd_message.set_token('CC_NUM', to_char(p_cc_header_id),TRUE);
6243: IF(g_error_level >= g_debug_level) THEN
6244: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6245: END IF;
6246: l_error_message := fnd_message.get;

Line 6246: l_error_message := fnd_message.get;

6242: fnd_message.set_token('CC_NUM', to_char(p_cc_header_id),TRUE);
6243: IF(g_error_level >= g_debug_level) THEN
6244: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6245: END IF;
6246: l_error_message := fnd_message.get;
6247: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name, l_error_message);
6248: RAISE E_CC_NOT_FOUND;
6249:
6250: END;

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

6278: EXCEPTION
6279: WHEN NO_DATA_FOUND THEN
6280: l_cc_det_pf_cnt := 0;
6281: IF ( g_unexp_level >= g_debug_level ) THEN
6282: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
6283: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
6284: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
6285: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
6286: END IF;

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

6279: WHEN NO_DATA_FOUND THEN
6280: l_cc_det_pf_cnt := 0;
6281: IF ( g_unexp_level >= g_debug_level ) THEN
6282: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
6283: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
6284: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
6285: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
6286: END IF;
6287: END;

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

6280: l_cc_det_pf_cnt := 0;
6281: IF ( g_unexp_level >= g_debug_level ) THEN
6282: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
6283: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
6284: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
6285: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
6286: END IF;
6287: END;
6288: IF (NVL(l_cc_det_pf_cnt ,0) = 0)

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

6292: -- the amount in the account line
6293: THEN
6294: x_valid_cc := FND_API.G_FALSE;
6295: x_return_status := FND_API.G_RET_STS_ERROR;
6296: fnd_message.set_name('IGC', 'IGC_CC_NO_PF');
6297: fnd_message.set_token('ACCT_NUM', to_char(l_cc_acct_lines_rec.cc_acct_line_num),TRUE);
6298: IF(g_error_level >= g_debug_level) THEN
6299: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6300: END IF;

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

6293: THEN
6294: x_valid_cc := FND_API.G_FALSE;
6295: x_return_status := FND_API.G_RET_STS_ERROR;
6296: fnd_message.set_name('IGC', 'IGC_CC_NO_PF');
6297: fnd_message.set_token('ACCT_NUM', to_char(l_cc_acct_lines_rec.cc_acct_line_num),TRUE);
6298: IF(g_error_level >= g_debug_level) THEN
6299: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6300: END IF;
6301: fnd_msg_pub.add;

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

6313:
6314: IF (l_cc_det_pf_lines_rec.cc_det_pf_date < p_start_date) THEN
6315: x_valid_cc := FND_API.G_FALSE;
6316: x_return_status := FND_API.G_RET_STS_ERROR;
6317: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_START_DATE');
6318: fnd_message.set_TOKEN('PFDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_date),FALSE);
6319: IF(g_error_level >= g_debug_level) THEN
6320: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6321: END IF;

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

6314: IF (l_cc_det_pf_lines_rec.cc_det_pf_date < p_start_date) THEN
6315: x_valid_cc := FND_API.G_FALSE;
6316: x_return_status := FND_API.G_RET_STS_ERROR;
6317: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_START_DATE');
6318: fnd_message.set_TOKEN('PFDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_date),FALSE);
6319: IF(g_error_level >= g_debug_level) THEN
6320: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6321: END IF;
6322: fnd_msg_pub.add;

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

6328: (p_end_date IS NOT NULL)
6329: ) THEN
6330: x_valid_cc := FND_API.G_FALSE;
6331: x_return_status := FND_API.G_RET_STS_ERROR;
6332: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_END_DATE');
6333: fnd_message.set_TOKEN('PFDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_date),FALSE);
6334: IF(g_error_level >= g_debug_level) THEN
6335: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6336: END IF;

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

6329: ) THEN
6330: x_valid_cc := FND_API.G_FALSE;
6331: x_return_status := FND_API.G_RET_STS_ERROR;
6332: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_END_DATE');
6333: fnd_message.set_TOKEN('PFDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_date),FALSE);
6334: IF(g_error_level >= g_debug_level) THEN
6335: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6336: END IF;
6337: fnd_msg_pub.add;

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

6371: EXCEPTION
6372: WHEN OTHERS THEN
6373: l_COUNT := 0;
6374: IF ( g_unexp_level >= g_debug_level ) THEN
6375: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
6376: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
6377: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
6378: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
6379: END IF;

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

6372: WHEN OTHERS THEN
6373: l_COUNT := 0;
6374: IF ( g_unexp_level >= g_debug_level ) THEN
6375: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
6376: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
6377: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
6378: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
6379: END IF;
6380: END;

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

6373: l_COUNT := 0;
6374: IF ( g_unexp_level >= g_debug_level ) THEN
6375: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
6376: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
6377: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
6378: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
6379: END IF;
6380: END;
6381: IF NVL(l_COUNT,0) = 0 THEN

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

6380: END;
6381: IF NVL(l_COUNT,0) = 0 THEN
6382: x_valid_cc := FND_API.G_FALSE;
6383: x_return_status := FND_API.G_RET_STS_ERROR;
6384: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_DATE');
6385: IF(g_error_level >= g_debug_level) THEN
6386: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6387: END IF;
6388: fnd_msg_pub.add;

Line 6445: fnd_message.set_name('IGC',

6441: TRUNC (l_cc_det_pf_lines_rec.cc_det_pf_encmbrnc_date)
6442: THEN
6443: x_valid_cc := FND_API.G_FALSE;
6444: x_return_status := FND_API.G_RET_STS_ERROR;
6445: fnd_message.set_name('IGC',
6446: 'IGC_CC_DET_PF_DATE_NO_UPDATE');
6447: fnd_message.set_TOKEN('ENCMBRNCDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_encmbrnc_date),FALSE);
6448: IF(g_error_level >= g_debug_level) THEN
6449: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);

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

6443: x_valid_cc := FND_API.G_FALSE;
6444: x_return_status := FND_API.G_RET_STS_ERROR;
6445: fnd_message.set_name('IGC',
6446: 'IGC_CC_DET_PF_DATE_NO_UPDATE');
6447: fnd_message.set_TOKEN('ENCMBRNCDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_encmbrnc_date),FALSE);
6448: IF(g_error_level >= g_debug_level) THEN
6449: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6450: END IF;
6451: fnd_msg_pub.add;

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

6517: IF l_orig_fiscal_year <> l_new_fiscal_year
6518: THEN
6519: x_valid_cc := FND_API.G_FALSE;
6520: x_return_status := FND_API.G_RET_STS_ERROR;
6521: fnd_message.set_name('IGC', 'IGC_CC_FISCAL_YRS_NE');
6522: fnd_message.set_TOKEN('ENCMBRNCDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_encmbrnc_date),FALSE);
6523: IF(g_error_level >= g_debug_level) THEN
6524: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6525: END IF;

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

6518: THEN
6519: x_valid_cc := FND_API.G_FALSE;
6520: x_return_status := FND_API.G_RET_STS_ERROR;
6521: fnd_message.set_name('IGC', 'IGC_CC_FISCAL_YRS_NE');
6522: fnd_message.set_TOKEN('ENCMBRNCDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_encmbrnc_date),FALSE);
6523: IF(g_error_level >= g_debug_level) THEN
6524: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6525: END IF;
6526: fnd_msg_pub.add;

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

6547: -- This validation now needs to include the withheld amount
6548: THEN
6549: x_valid_cc := FND_API.G_FALSE;
6550: x_return_status := FND_API.G_RET_STS_ERROR;
6551: fnd_message.set_name('IGC', 'IGC_CC_AMT_MISMATCH');
6552: fnd_message.set_token('ACCT_NUM',to_char(l_cc_acct_lines_rec.cc_acct_line_num),TRUE);
6553: IF(g_error_level >= g_debug_level) THEN
6554: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6555: END IF;

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

6548: THEN
6549: x_valid_cc := FND_API.G_FALSE;
6550: x_return_status := FND_API.G_RET_STS_ERROR;
6551: fnd_message.set_name('IGC', 'IGC_CC_AMT_MISMATCH');
6552: fnd_message.set_token('ACCT_NUM',to_char(l_cc_acct_lines_rec.cc_acct_line_num),TRUE);
6553: IF(g_error_level >= g_debug_level) THEN
6554: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6555: END IF;
6556: fnd_msg_pub.add;

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

6562:
6563: IF (l_cc_acct_cnt = 0) THEN
6564: x_valid_cc := FND_API.G_FALSE;
6565: x_return_status := FND_API.G_RET_STS_ERROR;
6566: fnd_message.set_name('IGC', 'IGC_CC_NO_ACCT_LINES');
6567: fnd_message.set_token('CC_NUM', l_cc_headers_rec.cc_num,TRUE);
6568: IF(g_error_level >= g_debug_level) THEN
6569: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6570: END IF;

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

6563: IF (l_cc_acct_cnt = 0) THEN
6564: x_valid_cc := FND_API.G_FALSE;
6565: x_return_status := FND_API.G_RET_STS_ERROR;
6566: fnd_message.set_name('IGC', 'IGC_CC_NO_ACCT_LINES');
6567: fnd_message.set_token('CC_NUM', l_cc_headers_rec.cc_num,TRUE);
6568: IF(g_error_level >= g_debug_level) THEN
6569: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6570: END IF;
6571: fnd_msg_pub.add;

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

6611: p_data => x_msg_data );
6612: CLOSE c_account_lines;
6613:
6614: IF ( g_unexp_level >= g_debug_level ) THEN
6615: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
6616: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
6617: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
6618: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
6619: END IF;

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

6612: CLOSE c_account_lines;
6613:
6614: IF ( g_unexp_level >= g_debug_level ) THEN
6615: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
6616: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
6617: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
6618: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
6619: END IF;
6620:

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

6613:
6614: IF ( g_unexp_level >= g_debug_level ) THEN
6615: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
6616: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
6617: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
6618: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
6619: END IF;
6620:
6621: END Validate_CC;

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

6703: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
6704: p_data => x_msg_data );
6705:
6706: IF ( g_unexp_level >= g_debug_level ) THEN
6707: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
6708: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
6709: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
6710: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
6711: END IF;

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

6704: p_data => x_msg_data );
6705:
6706: IF ( g_unexp_level >= g_debug_level ) THEN
6707: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
6708: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
6709: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
6710: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
6711: END IF;
6712:

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

6705:
6706: IF ( g_unexp_level >= g_debug_level ) THEN
6707: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
6708: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
6709: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
6710: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
6711: END IF;
6712:
6713: END calculate_nonrec_tax;