eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGC_CC_ARCHIVE_PURGE_PKG dependencies on FND_LOG

Line 29: g_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

25: -- g_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.VALUE('IGC_DEBUG_ENABLED'),'N');
26: g_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
27: g_ledger_name GL_LEDGERS.Name%TYPE; /*Added this param during MOAC uptake to just call MO_UTILS.GET_LEDGER_INFO.*/
28: --Variables for ATG Central logging
29: g_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
30: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
31: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
32: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
33: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;

Line 30: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;

26: g_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
27: g_ledger_name GL_LEDGERS.Name%TYPE; /*Added this param during MOAC uptake to just call MO_UTILS.GET_LEDGER_INFO.*/
28: --Variables for ATG Central logging
29: g_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
30: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
31: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
32: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
33: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
34: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;

Line 31: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

27: g_ledger_name GL_LEDGERS.Name%TYPE; /*Added this param during MOAC uptake to just call MO_UTILS.GET_LEDGER_INFO.*/
28: --Variables for ATG Central logging
29: g_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
30: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
31: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
32: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
33: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
34: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
35: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;

Line 32: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;

28: --Variables for ATG Central logging
29: g_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
30: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
31: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
32: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
33: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
34: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
35: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
36: g_path VARCHAR2(255) := 'IGC.PLSQL.IGCCAPRB.IGC_CC_ARCHIVE_PURGE_PKG.';

Line 33: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;

29: g_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
30: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
31: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
32: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
33: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
34: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
35: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
36: g_path VARCHAR2(255) := 'IGC.PLSQL.IGCCAPRB.IGC_CC_ARCHIVE_PURGE_PKG.';
37:

Line 34: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;

30: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
31: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
32: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
33: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
34: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
35: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
36: g_path VARCHAR2(255) := 'IGC.PLSQL.IGCCAPRB.IGC_CC_ARCHIVE_PURGE_PKG.';
37:
38: -- ---------------------------------------------------------------------

Line 35: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;

31: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
32: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
33: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
34: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
35: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
36: g_path VARCHAR2(255) := 'IGC.PLSQL.IGCCAPRB.IGC_CC_ARCHIVE_PURGE_PKG.';
37:
38: -- ---------------------------------------------------------------------
39: -- Private Function Definition:

Line 269: FND_LOG.MESSAGE (g_error_level , l_full_path,FALSE);

265: FND_MESSAGE.SET_NAME('IGI', 'IGI_GEN_PROD_NOT_INSTALLED');
266: FND_MESSAGE.SET_TOKEN('OPTION_NAME', l_option_name);
267: lv_message := fnd_message.get;
268: IF (g_error_level >= g_debug_level ) THEN
269: FND_LOG.MESSAGE (g_error_level , l_full_path,FALSE);
270: END IF;
271: errbuf := lv_message;
272: retcode := 2;
273: return;

Line 318: FND_LOG.STRING (g_excep_level,l_full_path,l_error_text);

314: FOR l_cur IN 1..l_msg_count LOOP
315: -- l_error_text := ' Mesg No : '|| l_cur ||' '|| FND_MSG_PUB.GET(l_cur, FND_API.G_FALSE);
316: l_error_text := l_cur ||' '|| FND_MSG_PUB.GET(l_cur, FND_API.G_FALSE);
317: IF (g_excep_level >= g_debug_level ) THEN
318: FND_LOG.STRING (g_excep_level,l_full_path,l_error_text);
319: END IF;
320: fnd_file.put_line (FND_FILE.LOG,
321: l_error_text);
322: END LOOP;

Line 329: FND_LOG.STRING (g_excep_level,l_full_path,l_error_text);

325:
326: IF (g_validation_error) THEN
327: l_error_text := 'Error Returned but Error stack has no data';
328: IF (g_excep_level >= g_debug_level ) THEN
329: FND_LOG.STRING (g_excep_level,l_full_path,l_error_text);
330: END IF;
331: fnd_file.put_line (FND_FILE.LOG,
332: l_error_text);
333: END IF;

Line 362: FND_LOG.STRING (g_excep_level,l_full_path,l_error_text);

358: FOR l_cur IN 1..l_msg_count LOOP
359: -- l_error_text := ' Mesg No : '|| l_cur ||' '|| FND_MSG_PUB.GET(l_cur, FND_API.G_FALSE);
360: l_error_text := l_cur ||' '|| FND_MSG_PUB.GET(l_cur, FND_API.G_FALSE);
361: IF (g_excep_level >= g_debug_level ) THEN
362: FND_LOG.STRING (g_excep_level,l_full_path,l_error_text);
363: END IF;
364: fnd_file.put_line (FND_FILE.LOG,
365: l_error_text);
366: END LOOP;

Line 600: FND_LOG.STRING(g_event_level, l_full_path, 'IGC_CC_ARCHIVE_PURGE_PKG - IGCCAPRR request Submitted ');

596: IF (l_stage1_parent_req > 0) THEN
597: /*FND_FILE.PUT_LINE (FND_FILE.LOG,
598: 'IGC_CC_ARCHIVE_PURGE_PKG - IGCCAPRR request Submitted ');*/
599: IF(g_event_level >= g_debug_level) THEN
600: FND_LOG.STRING(g_event_level, l_full_path, 'IGC_CC_ARCHIVE_PURGE_PKG - IGCCAPRR request Submitted ');
601: END IF;
602: COMMIT;
603: ELSE
604:

Line 616: FND_LOG.MESSAGE ( g_unexp_level,l_full_path,TRUE);

612:
613: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
614: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
615: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
616: FND_LOG.MESSAGE ( g_unexp_level,l_full_path,TRUE);
617: END IF;
618:
619: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_USER_ERROR');
620: l_error_text := FND_MESSAGE.GET;

Line 628: FND_LOG.STRING(g_state_level, l_full_path, 'IGC_CC_ARCHIVE_PURGE_PKG - waiting for IGCCAPRR request to finish... ');

624:
625: /*FND_FILE.PUT_LINE (FND_FILE.LOG,
626: 'IGC_CC_ARCHIVE_PURGE_PKG - waiting for IGCCAPRR request to finish... ');*/
627: IF(g_state_level >= g_debug_level) THEN
628: FND_LOG.STRING(g_state_level, l_full_path, 'IGC_CC_ARCHIVE_PURGE_PKG - waiting for IGCCAPRR request to finish... ');
629: END IF;
630:
631: l_stage1_wait_for_request := FND_CONCURRENT.WAIT_FOR_REQUEST (l_stage1_parent_req,
632: 05,

Line 643: FND_LOG.STRING(g_event_level, l_full_path, 'IGC_CC_ARCHIVE_PURGE_PKG - finished... checking status of IGCCAPRR request');

639: /*FND_FILE.PUT_LINE (FND_FILE.LOG,
640: 'IGC_CC_ARCHIVE_PURGE_PKG - finished... checking status of IGCCAPRR request');*/
641:
642: IF(g_event_level >= g_debug_level) THEN
643: FND_LOG.STRING(g_event_level, l_full_path, 'IGC_CC_ARCHIVE_PURGE_PKG - finished... checking status of IGCCAPRR request');
644: END IF;
645:
646: IF ((l_stage1_dev_phase = 'COMPLETE') AND
647: (l_stage1_dev_status = 'NORMAL')) THEN

Line 652: FND_LOG.STRING(g_event_level, l_full_path, 'IGC_CC_ARCHIVE_PURGE_PKG - COMPLETE / NORMAL status of IGCCAPRR request');

648: FND_FILE.PUT_LINE (FND_FILE.LOG,
649: 'IGC_CC_ARCHIVE_PURGE_PKG - COMPLETE / NORMAL status of IGCCAPRR request');
650:
651: IF(g_event_level >= g_debug_level) THEN
652: FND_LOG.STRING(g_event_level, l_full_path, 'IGC_CC_ARCHIVE_PURGE_PKG - COMPLETE / NORMAL status of IGCCAPRR request');
653: END IF;
654: ELSE
655: /*FND_FILE.PUT_LINE (FND_FILE.LOG,
656: 'IGC_CC_ARCHIVE_PURGE_PKG - FAILED status of IGCCAPRR request');*/

Line 697: FND_LOG.STRING(g_event_level, l_full_path, 'IGC_CC_ARCHIVE_PURGE_PKG - IGCCAPRR_XML request Submitted ');

693: IF (l_stage1_parent_req > 0) THEN
694: /*FND_FILE.PUT_LINE (FND_FILE.LOG,
695: 'IGC_CC_ARCHIVE_PURGE_PKG - IGCCAPRR request Submitted ');*/
696: IF(g_event_level >= g_debug_level) THEN
697: FND_LOG.STRING(g_event_level, l_full_path, 'IGC_CC_ARCHIVE_PURGE_PKG - IGCCAPRR_XML request Submitted ');
698: END IF;
699: COMMIT;
700: ELSE
701:

Line 713: FND_LOG.MESSAGE ( g_unexp_level,l_full_path,TRUE);

709:
710: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
711: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
712: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
713: FND_LOG.MESSAGE ( g_unexp_level,l_full_path,TRUE);
714: END IF;
715:
716: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_USER_ERROR');
717: l_error_text := FND_MESSAGE.GET;

Line 723: FND_LOG.STRING(g_state_level, l_full_path, 'IGC_CC_ARCHIVE_PURGE_PKG - waiting for IGCCAPRR_XML request to finish... ');

719: END IF;
720: /*FND_FILE.PUT_LINE (FND_FILE.LOG,
721: 'IGC_CC_ARCHIVE_PURGE_PKG - waiting for IGCCAPRR_XML request to finish... ');*/
722: IF(g_state_level >= g_debug_level) THEN
723: FND_LOG.STRING(g_state_level, l_full_path, 'IGC_CC_ARCHIVE_PURGE_PKG - waiting for IGCCAPRR_XML request to finish... ');
724: END IF;
725:
726: l_stage1_wait_for_request := FND_CONCURRENT.WAIT_FOR_REQUEST (l_stage1_parent_req,
727: 05,

Line 738: FND_LOG.STRING(g_event_level, l_full_path, 'IGC_CC_ARCHIVE_PURGE_PKG - finished... checking status of IGCCAPRR_XML request');

734: /*FND_FILE.PUT_LINE (FND_FILE.LOG,
735: 'IGC_CC_ARCHIVE_PURGE_PKG - finished... checking status of IGCCAPRR_XML request');*/
736:
737: IF(g_event_level >= g_debug_level) THEN
738: FND_LOG.STRING(g_event_level, l_full_path, 'IGC_CC_ARCHIVE_PURGE_PKG - finished... checking status of IGCCAPRR_XML request');
739: END IF;
740:
741: IF ((l_stage1_dev_phase = 'COMPLETE') AND
742: (l_stage1_dev_status = 'NORMAL')) THEN

Line 746: FND_LOG.STRING(g_event_level, l_full_path, 'IGC_CC_ARCHIVE_PURGE_PKG - COMPLETE / NORMAL status of IGCCAPRR_XML request');

742: (l_stage1_dev_status = 'NORMAL')) THEN
743: FND_FILE.PUT_LINE (FND_FILE.LOG,'IGC_CC_ARCHIVE_PURGE_PKG - COMPLETE / NORMAL status of IGCCAPRR_XML request');
744:
745: IF(g_event_level >= g_debug_level) THEN
746: FND_LOG.STRING(g_event_level, l_full_path, 'IGC_CC_ARCHIVE_PURGE_PKG - COMPLETE / NORMAL status of IGCCAPRR_XML request');
747: END IF;
748: ELSE
749: /*FND_FILE.PUT_LINE (FND_FILE.LOG,
750: 'IGC_CC_ARCHIVE_PURGE_PKG - FAILED status of IGCCAPRR_XML request');*/

Line 782: FND_LOG.STRING (g_excep_level,l_full_path,'NO_DATA_FOUND Exception Raised');

778: WHEN NO_DATA_FOUND THEN
779: x_Return_Status := FND_API.G_RET_STS_ERROR;
780: ROLLBACK TO Archive_Purge_CC_PVT;
781: IF (g_excep_level >= g_debug_level ) THEN
782: FND_LOG.STRING (g_excep_level,l_full_path,'NO_DATA_FOUND Exception Raised');
783: END IF;
784: RETURN;
785:
786: WHEN FND_API.G_EXC_ERROR THEN

Line 790: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');

786: WHEN FND_API.G_EXC_ERROR THEN
787: x_Return_Status := FND_API.G_RET_STS_ERROR;
788: ROLLBACK TO Archive_Purge_CC_PVT;
789: IF (g_excep_level >= g_debug_level ) THEN
790: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');
791: END IF;
792: RETURN;
793:
794: WHEN OTHERS THEN

Line 804: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);

800: IF ( g_unexp_level >= g_debug_level ) THEN
801: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
802: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
803: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
804: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
805: END IF;
806: RETURN;
807:
808: END Arch_Pur_CC;

Line 935: FND_LOG.STRING (g_excep_level,l_full_path,'NO_DATA_FOUND Exception Raised');

931:
932: WHEN NO_DATA_FOUND THEN
933: x_Return_Status := FND_API.G_RET_STS_ERROR;
934: IF (g_excep_level >= g_debug_level ) THEN
935: FND_LOG.STRING (g_excep_level,l_full_path,'NO_DATA_FOUND Exception Raised');
936: END IF;
937: RETURN;
938:
939: WHEN FND_API.G_EXC_ERROR THEN

Line 942: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');

938:
939: WHEN FND_API.G_EXC_ERROR THEN
940: x_Return_Status := FND_API.G_RET_STS_ERROR;
941: IF (g_excep_level >= g_debug_level ) THEN
942: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');
943: END IF;
944: RETURN;
945:
946: WHEN OTHERS THEN

Line 955: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);

951: IF ( g_unexp_level >= g_debug_level ) THEN
952: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
953: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
954: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
955: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
956: END IF;
957: RETURN;
958:
959: END Archive_CC;

Line 1308: FND_LOG.STRING (g_excep_level,l_full_path,'NO_DATA_FOUND Exception Raised');

1304:
1305: WHEN NO_DATA_FOUND THEN
1306: x_Return_Status := FND_API.G_RET_STS_ERROR;
1307: IF (g_excep_level >= g_debug_level ) THEN
1308: FND_LOG.STRING (g_excep_level,l_full_path,'NO_DATA_FOUND Exception Raised');
1309: END IF;
1310: RETURN;
1311:
1312: WHEN FND_API.G_EXC_ERROR THEN

Line 1315: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');

1311:
1312: WHEN FND_API.G_EXC_ERROR THEN
1313: x_Return_Status := FND_API.G_RET_STS_ERROR;
1314: IF (g_excep_level >= g_debug_level ) THEN
1315: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');
1316: END IF;
1317: RETURN;
1318:
1319: WHEN OTHERS THEN

Line 1328: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);

1324: IF ( g_unexp_level >= g_debug_level ) THEN
1325: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
1326: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1327: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1328: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
1329: END IF;
1330: RETURN;
1331:
1332: END Archive_MRC_Tbls;

Line 3088: FND_LOG.STRING (g_excep_level,l_full_path,'NO_DATA_FOUND Exception Raised');

3084:
3085: WHEN NO_DATA_FOUND THEN
3086: x_Return_Status := FND_API.G_RET_STS_ERROR;
3087: IF (g_excep_level >= g_debug_level ) THEN
3088: FND_LOG.STRING (g_excep_level,l_full_path,'NO_DATA_FOUND Exception Raised');
3089: END IF;
3090: RETURN;
3091:
3092: WHEN FND_API.G_EXC_ERROR THEN

Line 3095: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');

3091:
3092: WHEN FND_API.G_EXC_ERROR THEN
3093: x_Return_Status := FND_API.G_RET_STS_ERROR;
3094: IF (g_excep_level >= g_debug_level ) THEN
3095: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');
3096: END IF;
3097: RETURN;
3098:
3099: WHEN OTHERS THEN

Line 3108: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);

3104: IF ( g_unexp_level >= g_debug_level ) THEN
3105: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
3106: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
3107: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
3108: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
3109: END IF;
3110: RETURN;
3111:
3112: END Archive_NON_MRC_Tbls;

Line 3289: FND_LOG.STRING (g_excep_level,l_full_path,'NO_DATA_FOUND Exception Raised');

3285: IF (c_cand_count%ISOPEN) THEN
3286: CLOSE c_cand_count;
3287: END IF;
3288: IF (g_excep_level >= g_debug_level ) THEN
3289: FND_LOG.STRING (g_excep_level,l_full_path,'NO_DATA_FOUND Exception Raised');
3290: END IF;
3291: RETURN;
3292:
3293: WHEN FND_API.G_EXC_ERROR THEN

Line 3299: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');

3295: IF (c_cand_count%ISOPEN) THEN
3296: CLOSE c_cand_count;
3297: END IF;
3298: IF (g_excep_level >= g_debug_level ) THEN
3299: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');
3300: END IF;
3301: RETURN;
3302:
3303: WHEN OTHERS THEN

Line 3315: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);

3311: IF ( g_unexp_level >= g_debug_level ) THEN
3312: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
3313: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
3314: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
3315: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
3316: END IF;
3317: RETURN;
3318:
3319: END Build_Candidate_List;

Line 3392: FND_LOG.STRING (g_excep_level,l_full_path,'NO_DATA_FOUND Exception Raised');

3388:
3389: WHEN NO_DATA_FOUND THEN
3390: x_Return_Status := FND_API.G_RET_STS_ERROR;
3391: IF (g_excep_level >= g_debug_level ) THEN
3392: FND_LOG.STRING (g_excep_level,l_full_path,'NO_DATA_FOUND Exception Raised');
3393: END IF;
3394: RETURN;
3395:
3396: WHEN FND_API.G_EXC_ERROR THEN

Line 3399: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');

3395:
3396: WHEN FND_API.G_EXC_ERROR THEN
3397: x_Return_Status := FND_API.G_RET_STS_ERROR;
3398: IF (g_excep_level >= g_debug_level ) THEN
3399: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');
3400: END IF;
3401: RETURN;
3402:
3403: WHEN OTHERS THEN

Line 3412: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);

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

Line 3653: FND_LOG.STRING (g_excep_level,l_full_path,'NO_DATA_FOUND Exception Raised');

3649:
3650: WHEN NO_DATA_FOUND THEN
3651: x_Return_Status := FND_API.G_RET_STS_ERROR;
3652: IF (g_excep_level >= g_debug_level ) THEN
3653: FND_LOG.STRING (g_excep_level,l_full_path,'NO_DATA_FOUND Exception Raised');
3654: END IF;
3655: RETURN;
3656:
3657: WHEN FND_API.G_EXC_ERROR THEN

Line 3660: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');

3656:
3657: WHEN FND_API.G_EXC_ERROR THEN
3658: x_Return_Status := FND_API.G_RET_STS_ERROR;
3659: IF (g_excep_level >= g_debug_level ) THEN
3660: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');
3661: END IF;
3662: RETURN;
3663:
3664: WHEN OTHERS THEN

Line 3673: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);

3669: IF ( g_unexp_level >= g_debug_level ) THEN
3670: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
3671: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
3672: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
3673: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
3674: END IF;
3675: RETURN;
3676:
3677: END Cleanup_MRC_Arc_Tbls;

Line 3943: FND_LOG.STRING (g_excep_level,l_full_path,'NO_DATA_FOUND Exception Raised');

3939:
3940: WHEN NO_DATA_FOUND THEN
3941: x_Return_Status := FND_API.G_RET_STS_ERROR;
3942: IF (g_excep_level >= g_debug_level ) THEN
3943: FND_LOG.STRING (g_excep_level,l_full_path,'NO_DATA_FOUND Exception Raised');
3944: END IF;
3945: RETURN;
3946:
3947: WHEN FND_API.G_EXC_ERROR THEN

Line 3950: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');

3946:
3947: WHEN FND_API.G_EXC_ERROR THEN
3948: x_Return_Status := FND_API.G_RET_STS_ERROR;
3949: IF (g_excep_level >= g_debug_level ) THEN
3950: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');
3951: END IF;
3952: RETURN;
3953:
3954: WHEN OTHERS THEN

Line 3963: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);

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

Line 4174: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);

4170: IF ( g_unexp_level >= g_debug_level ) THEN
4171: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
4172: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
4173: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
4174: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
4175: END IF;
4176: RETURN;
4177:
4178: END Initialize_History_Record;

Line 4478: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');

4474: IF (c_mc_pf_line_count%ISOPEN) THEN
4475: CLOSE c_mc_pf_line_count;
4476: END IF;
4477: IF (g_excep_level >= g_debug_level ) THEN
4478: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');
4479: END IF;
4480: RETURN;
4481:
4482: WHEN OTHERS THEN

Line 4509: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);

4505: IF ( g_unexp_level >= g_debug_level ) THEN
4506: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
4507: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
4508: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
4509: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
4510: END IF;
4511: RETURN;
4512:
4513: END Insert_Archive_History;

Line 4573: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');

4569: IF (c_lock_candidates%ISOPEN) THEN
4570: CLOSE c_lock_candidates;
4571: END IF;
4572: IF (g_excep_level >= g_debug_level ) THEN
4573: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');
4574: END IF;
4575: RETURN FALSE;
4576:
4577: WHEN OTHERS THEN

Line 4612: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);

4608: IF ( g_unexp_level >= g_debug_level ) THEN
4609: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
4610: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
4611: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
4612: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
4613: END IF;
4614:
4615: END; -- inner block
4616:

Line 4632: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);

4628: IF ( g_unexp_level >= g_debug_level ) THEN
4629: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
4630: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
4631: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
4632: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
4633: END IF;
4634: RETURN FALSE;
4635:
4636: END Lock_Candidates;

Line 4674: FND_LOG.STRING(g_state_level, p_path, p_debug_msg);

4670: raise FND_API.G_EXC_ERROR;
4671: END IF;*/
4672:
4673: IF(g_state_level >= g_debug_level) THEN
4674: FND_LOG.STRING(g_state_level, p_path, p_debug_msg);
4675: END IF;
4676:
4677: RETURN;
4678:

Line 4792: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');

4788:
4789: WHEN FND_API.G_EXC_ERROR THEN
4790: x_Return_Status := FND_API.G_RET_STS_ERROR;
4791: IF (g_excep_level >= g_debug_level ) THEN
4792: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');
4793: END IF;
4794: RETURN;
4795:
4796: WHEN OTHERS THEN

Line 4805: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);

4801: IF ( g_unexp_level >= g_debug_level ) THEN
4802: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
4803: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
4804: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
4805: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
4806: END IF;
4807: RETURN;
4808:
4809: END Purge_CC;

Line 5151: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');

5147: IF (c_get_arc_hist_info%ISOPEN) THEN
5148: CLOSE c_get_arc_hist_info;
5149: END IF;
5150: IF (g_excep_level >= g_debug_level ) THEN
5151: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');
5152: END IF;
5153: RETURN;
5154:
5155: WHEN OTHERS THEN

Line 5170: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);

5166: IF ( g_unexp_level >= g_debug_level ) THEN
5167: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
5168: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
5169: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
5170: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
5171: END IF;
5172: RETURN;
5173:
5174: END Purge_MRC_Tbls;

Line 5635: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');

5631: IF (c_get_arc_hist_info%ISOPEN) THEN
5632: CLOSE c_get_arc_hist_info;
5633: END IF;
5634: IF (g_excep_level >= g_debug_level ) THEN
5635: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');
5636: END IF;
5637: RETURN;
5638:
5639: WHEN OTHERS THEN

Line 5654: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);

5650: IF ( g_unexp_level >= g_debug_level ) THEN
5651: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
5652: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
5653: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
5654: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
5655: END IF;
5656: RETURN;
5657:
5658: END Purge_NON_MRC_Tbls;

Line 5865: FND_LOG.STRING (g_excep_level,l_full_path,'NO_DATA_FOUND Exception Raised');

5861: IF (c_archive_history%ISOPEN) THEN
5862: CLOSE c_archive_history;
5863: END IF;
5864: IF (g_excep_level >= g_debug_level ) THEN
5865: FND_LOG.STRING (g_excep_level,l_full_path,'NO_DATA_FOUND Exception Raised');
5866: END IF;
5867: RETURN;
5868:
5869: WHEN FND_API.G_EXC_ERROR THEN

Line 5875: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');

5871: IF (c_archive_history%ISOPEN) THEN
5872: CLOSE c_archive_history;
5873: END IF;
5874: IF (g_excep_level >= g_debug_level ) THEN
5875: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');
5876: END IF;
5877: RETURN;
5878:
5879: WHEN OTHERS THEN

Line 5891: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);

5887: IF ( g_unexp_level >= g_debug_level ) THEN
5888: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
5889: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
5890: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
5891: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
5892: END IF;
5893: RETURN;
5894:
5895: END Update_History;

Line 6049: FND_LOG.STRING (g_excep_level,l_full_path,'NO_DATA_FOUND Exception Raised');

6045: IF (c_validate_sob_org%ISOPEN) THEN
6046: CLOSE c_validate_sob_org;
6047: END IF;
6048: IF (g_excep_level >= g_debug_level ) THEN
6049: FND_LOG.STRING (g_excep_level,l_full_path,'NO_DATA_FOUND Exception Raised');
6050: END IF;
6051: RETURN;
6052:
6053: WHEN FND_API.G_EXC_ERROR THEN

Line 6059: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');

6055: IF (c_validate_sob_org%ISOPEN) THEN
6056: CLOSE c_validate_sob_org;
6057: END IF;
6058: IF (g_excep_level >= g_debug_level ) THEN
6059: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');
6060: END IF;
6061: RETURN;
6062:
6063: WHEN OTHERS THEN

Line 6075: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);

6071: IF ( g_unexp_level >= g_debug_level ) THEN
6072: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
6073: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
6074: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
6075: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
6076: END IF;
6077: RETURN;
6078:
6079: END Validate_Inputs;