DBA Data[Home] [Help]

APPS.IGC_CC_DET_PF_PKG dependencies on FND_LOG

Line 10: --following variables added for bug 3199488: fnd logging changes: sdixit

6: g_debug_msg VARCHAR2(10000) := NULL;
7:
8: --g_debug_mode VARCHAR2(1):= NVL(FND_PROFILE.VALUE('IGC_DEBUG_ENABLED'),'N');
9: g_debug_mode VARCHAR2(1):= NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
10: --following variables added for bug 3199488: fnd logging changes: sdixit
11: g_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
12: g_state_level number := FND_LOG.LEVEL_STATEMENT;
13: g_proc_level number := FND_LOG.LEVEL_PROCEDURE;
14: g_event_level number := FND_LOG.LEVEL_EVENT;

Line 11: g_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

7:
8: --g_debug_mode VARCHAR2(1):= NVL(FND_PROFILE.VALUE('IGC_DEBUG_ENABLED'),'N');
9: g_debug_mode VARCHAR2(1):= NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
10: --following variables added for bug 3199488: fnd logging changes: sdixit
11: g_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
12: g_state_level number := FND_LOG.LEVEL_STATEMENT;
13: g_proc_level number := FND_LOG.LEVEL_PROCEDURE;
14: g_event_level number := FND_LOG.LEVEL_EVENT;
15: g_excep_level number := FND_LOG.LEVEL_EXCEPTION;

Line 12: g_state_level number := FND_LOG.LEVEL_STATEMENT;

8: --g_debug_mode VARCHAR2(1):= NVL(FND_PROFILE.VALUE('IGC_DEBUG_ENABLED'),'N');
9: g_debug_mode VARCHAR2(1):= NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
10: --following variables added for bug 3199488: fnd logging changes: sdixit
11: g_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
12: g_state_level number := FND_LOG.LEVEL_STATEMENT;
13: g_proc_level number := FND_LOG.LEVEL_PROCEDURE;
14: g_event_level number := FND_LOG.LEVEL_EVENT;
15: g_excep_level number := FND_LOG.LEVEL_EXCEPTION;
16: g_error_level number := FND_LOG.LEVEL_ERROR;

Line 13: g_proc_level number := FND_LOG.LEVEL_PROCEDURE;

9: g_debug_mode VARCHAR2(1):= NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
10: --following variables added for bug 3199488: fnd logging changes: sdixit
11: g_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
12: g_state_level number := FND_LOG.LEVEL_STATEMENT;
13: g_proc_level number := FND_LOG.LEVEL_PROCEDURE;
14: g_event_level number := FND_LOG.LEVEL_EVENT;
15: g_excep_level number := FND_LOG.LEVEL_EXCEPTION;
16: g_error_level number := FND_LOG.LEVEL_ERROR;
17: g_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;

Line 14: g_event_level number := FND_LOG.LEVEL_EVENT;

10: --following variables added for bug 3199488: fnd logging changes: sdixit
11: g_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
12: g_state_level number := FND_LOG.LEVEL_STATEMENT;
13: g_proc_level number := FND_LOG.LEVEL_PROCEDURE;
14: g_event_level number := FND_LOG.LEVEL_EVENT;
15: g_excep_level number := FND_LOG.LEVEL_EXCEPTION;
16: g_error_level number := FND_LOG.LEVEL_ERROR;
17: g_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
18: g_path CONSTANT varchar2(500) := 'igc.plsql.igccdpfb.igc_cc_det_pf_pkg.';

Line 15: g_excep_level number := FND_LOG.LEVEL_EXCEPTION;

11: g_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
12: g_state_level number := FND_LOG.LEVEL_STATEMENT;
13: g_proc_level number := FND_LOG.LEVEL_PROCEDURE;
14: g_event_level number := FND_LOG.LEVEL_EVENT;
15: g_excep_level number := FND_LOG.LEVEL_EXCEPTION;
16: g_error_level number := FND_LOG.LEVEL_ERROR;
17: g_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
18: g_path CONSTANT varchar2(500) := 'igc.plsql.igccdpfb.igc_cc_det_pf_pkg.';
19:

Line 16: g_error_level number := FND_LOG.LEVEL_ERROR;

12: g_state_level number := FND_LOG.LEVEL_STATEMENT;
13: g_proc_level number := FND_LOG.LEVEL_PROCEDURE;
14: g_event_level number := FND_LOG.LEVEL_EVENT;
15: g_excep_level number := FND_LOG.LEVEL_EXCEPTION;
16: g_error_level number := FND_LOG.LEVEL_ERROR;
17: g_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
18: g_path CONSTANT varchar2(500) := 'igc.plsql.igccdpfb.igc_cc_det_pf_pkg.';
19:
20: /* ================================================================================

Line 17: g_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;

13: g_proc_level number := FND_LOG.LEVEL_PROCEDURE;
14: g_event_level number := FND_LOG.LEVEL_EVENT;
15: g_excep_level number := FND_LOG.LEVEL_EXCEPTION;
16: g_error_level number := FND_LOG.LEVEL_ERROR;
17: g_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
18: g_path CONSTANT varchar2(500) := 'igc.plsql.igccdpfb.igc_cc_det_pf_pkg.';
19:
20: /* ================================================================================
21: PROCEDURE Output_Debug

Line 23: /*modifed for 3199488 - fnd logging changes*/

19:
20: /* ================================================================================
21: PROCEDURE Output_Debug
22: ===============================================================================*/
23: /*modifed for 3199488 - fnd logging changes*/
24: PROCEDURE Output_Debug (
25: p_path IN VARCHAR2,
26: p_debug_msg IN VARCHAR2,
27: p_sev_level IN VARCHAR2 := g_state_level

Line 32: fnd_log.string(p_sev_level, p_path, p_debug_msg);

28: ) IS
29: BEGIN
30:
31: IF p_sev_level >= g_debug_level THEN
32: fnd_log.string(p_sev_level, p_path, p_debug_msg);
33: END IF;
34: END;
35: /*********************
36: PROCEDURE Output_Debug (p_path => l_full_path ,

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

612: IF ( g_unexp_level >= g_debug_level ) THEN
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: END Insert_Row;
620:

Line 730: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);

726: IF (C%NOTFOUND) THEN
727: CLOSE C;
728: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
729: IF(g_excep_level >= g_debug_level) THEN
730: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
731: END IF;
732: FND_MSG_PUB.Add;
733: RAISE FND_API.G_EXC_ERROR ;
734: END IF;

Line 835: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);

831: Output_Debug (p_path => l_full_path ,p_debug_msg => g_debug_msg);
832: END IF;
833: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
834: IF(g_excep_level >= g_debug_level) THEN
835: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
836: END IF;
837: FND_MSG_PUB.Add;
838: RAISE FND_API.G_EXC_ERROR ;
839:

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

920: IF ( g_unexp_level >= g_debug_level ) THEN
921: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
922: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
923: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
924: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
925: END IF;
926:
927: END Lock_Row;
928:

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

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

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

1706: IF ( g_unexp_level >= g_debug_level ) THEN
1707: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
1708: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1709: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1710: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
1711: END IF;
1712:
1713: END Delete_Row;
1714: