DBA Data[Home] [Help]

APPS.IGC_CBC_PO_YEAR_END_PKG dependencies on FND_LOG

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

25: g_login NUMBER := FND_GLOBAL.login_id;
26: g_resp_id NUMBER := FND_GLOBAL.resp_id ;
27:
28:
29: --following variables added for bug 3199488: fnd logging changes: sdixit
30: g_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
31: g_state_level number := FND_LOG.LEVEL_STATEMENT;
32: g_proc_level number := FND_LOG.LEVEL_PROCEDURE;
33: g_event_level number := FND_LOG.LEVEL_EVENT;

Line 30: g_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

26: g_resp_id NUMBER := FND_GLOBAL.resp_id ;
27:
28:
29: --following variables added for bug 3199488: fnd logging changes: sdixit
30: g_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
31: g_state_level number := FND_LOG.LEVEL_STATEMENT;
32: g_proc_level number := FND_LOG.LEVEL_PROCEDURE;
33: g_event_level number := FND_LOG.LEVEL_EVENT;
34: g_excep_level number := FND_LOG.LEVEL_EXCEPTION;

Line 31: g_state_level number := FND_LOG.LEVEL_STATEMENT;

27:
28:
29: --following variables added for bug 3199488: fnd logging changes: sdixit
30: g_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
31: g_state_level number := FND_LOG.LEVEL_STATEMENT;
32: g_proc_level number := FND_LOG.LEVEL_PROCEDURE;
33: g_event_level number := FND_LOG.LEVEL_EVENT;
34: g_excep_level number := FND_LOG.LEVEL_EXCEPTION;
35: g_error_level number := FND_LOG.LEVEL_ERROR;

Line 32: g_proc_level number := FND_LOG.LEVEL_PROCEDURE;

28:
29: --following variables added for bug 3199488: fnd logging changes: sdixit
30: g_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
31: g_state_level number := FND_LOG.LEVEL_STATEMENT;
32: g_proc_level number := FND_LOG.LEVEL_PROCEDURE;
33: g_event_level number := FND_LOG.LEVEL_EVENT;
34: g_excep_level number := FND_LOG.LEVEL_EXCEPTION;
35: g_error_level number := FND_LOG.LEVEL_ERROR;
36: g_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;

Line 33: g_event_level number := FND_LOG.LEVEL_EVENT;

29: --following variables added for bug 3199488: fnd logging changes: sdixit
30: g_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
31: g_state_level number := FND_LOG.LEVEL_STATEMENT;
32: g_proc_level number := FND_LOG.LEVEL_PROCEDURE;
33: g_event_level number := FND_LOG.LEVEL_EVENT;
34: g_excep_level number := FND_LOG.LEVEL_EXCEPTION;
35: g_error_level number := FND_LOG.LEVEL_ERROR;
36: g_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
37: g_path varchar2(500) := 'igc.plsql.igcpoyeb.igc_cbc_po_year_end_pkg.';

Line 34: g_excep_level number := FND_LOG.LEVEL_EXCEPTION;

30: g_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
31: g_state_level number := FND_LOG.LEVEL_STATEMENT;
32: g_proc_level number := FND_LOG.LEVEL_PROCEDURE;
33: g_event_level number := FND_LOG.LEVEL_EVENT;
34: g_excep_level number := FND_LOG.LEVEL_EXCEPTION;
35: g_error_level number := FND_LOG.LEVEL_ERROR;
36: g_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
37: g_path varchar2(500) := 'igc.plsql.igcpoyeb.igc_cbc_po_year_end_pkg.';
38:

Line 35: g_error_level number := FND_LOG.LEVEL_ERROR;

31: g_state_level number := FND_LOG.LEVEL_STATEMENT;
32: g_proc_level number := FND_LOG.LEVEL_PROCEDURE;
33: g_event_level number := FND_LOG.LEVEL_EVENT;
34: g_excep_level number := FND_LOG.LEVEL_EXCEPTION;
35: g_error_level number := FND_LOG.LEVEL_ERROR;
36: g_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
37: g_path varchar2(500) := 'igc.plsql.igcpoyeb.igc_cbc_po_year_end_pkg.';
38:
39: -- NOTE that in all of the following processing, the return code value signifies the following:

Line 36: g_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;

32: g_proc_level number := FND_LOG.LEVEL_PROCEDURE;
33: g_event_level number := FND_LOG.LEVEL_EVENT;
34: g_excep_level number := FND_LOG.LEVEL_EXCEPTION;
35: g_error_level number := FND_LOG.LEVEL_ERROR;
36: g_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
37: g_path varchar2(500) := 'igc.plsql.igcpoyeb.igc_cbc_po_year_end_pkg.';
38:
39: -- NOTE that in all of the following processing, the return code value signifies the following:
40: -- 0 - Processing should terminate successfully

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

56: -- OUT Parameters
57: -- --------------
58: --
59: --
60: /*modifed for 3199488 - fnd logging changes*/
61: PROCEDURE Put_Debug_Msg (
62: p_path IN VARCHAR2,
63: p_debug_msg IN VARCHAR2,
64: p_sev_level IN VARCHAR2 := g_state_level

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

65: ) IS
66: BEGIN
67:
68: IF p_sev_level >= g_debug_level THEN
69: fnd_log.string(p_sev_level, p_path, p_debug_msg);
70: END IF;
71: END;
72: /****************
73: PROCEDURE Put_Debug_Msg (l_full_path,

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

299: IF ( g_unexp_level >= g_debug_level ) THEN
300: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
301: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
302: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
303: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
304: END IF;
305: APP_EXCEPTION.Raise_Exception;
306: END Lock_Documents;
307:

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

406: IF ( g_unexp_level >= g_debug_level ) THEN
407: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
408: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
409: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
410: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
411: END IF;
412: APP_EXCEPTION.Raise_Exception;
413: END Log_Error;
414:

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 Execute_Exceptions_Report;
620:

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

675: IF ( g_unexp_level >= g_debug_level ) THEN
676: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
677: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
678: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
679: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
680: END IF;
681: APP_EXCEPTION.Raise_Exception;
682:
683: END Insert_Exception_Record;

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

927: WHEN E_IGC_CBC_PO_DISABLE_YEP THEN
928: l_err_code := 'IGC_CBC_PO_DISABLE_YEP';
929: FND_MESSAGE.set_name('IGC',l_err_code);
930: IF(g_excep_level >= g_debug_level) THEN
931: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
932: END IF;
933: x_msg_buf := FND_MESSAGE.Get;
934: x_return_code := 2 ;
935: WHEN E_IGC_CBC_PO_ON_SBC_OFF THEN

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

935: WHEN E_IGC_CBC_PO_ON_SBC_OFF THEN
936: l_err_code := 'IGC_CBC_PO_ON_SBC_OFF';
937: FND_MESSAGE.set_name('IGC',l_err_code);
938: IF(g_excep_level >= g_debug_level) THEN
939: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
940: END IF;
941: x_msg_buf := FND_MESSAGE.Get;
942: x_return_code := 2 ;
943: WHEN E_IGC_CC_INVALID_SET_UP THEN

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

943: WHEN E_IGC_CC_INVALID_SET_UP THEN
944: l_err_code := 'IGC_CC_INVALID_SET_UP';
945: FND_MESSAGE.set_name('IGC',l_err_code);
946: IF(g_excep_level >= g_debug_level) THEN
947: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
948: END IF;
949: x_msg_buf := FND_MESSAGE.Get;
950: x_return_code := 2 ;
951: WHEN OTHERS THEN

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

958: IF ( g_unexp_level >= g_debug_level ) THEN
959: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
960: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
961: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
962: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
963: END IF;
964:
965:
966: END Validate_BC_Params;

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

1235: IF ( g_unexp_level >= g_debug_level ) THEN
1236: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
1237: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1238: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1239: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
1240: END IF;
1241: APP_EXCEPTION.Raise_Exception;
1242:
1243: END Validate_Period_Status ;

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

1344: IF ( g_unexp_level >= g_debug_level ) THEN
1345: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
1346: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1347: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1348: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
1349: END IF;
1350: APP_EXCEPTION.Raise_Exception;
1351:
1352: END Fetch_PO_And_Releases;

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

1447: IF ( g_unexp_level >= g_debug_level ) THEN
1448: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
1449: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1450: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1451: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
1452: END IF;
1453: APP_EXCEPTION.Raise_Exception;
1454:
1455: END Fetch_Requisitions ;

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

1544: IF ( g_unexp_level >= g_debug_level ) THEN
1545: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
1546: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1547: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1548: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
1549: END IF;
1550: APP_EXCEPTION.Raise_Exception;
1551:
1552: END Fetch_BPAs ;

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

1727: IF ( g_unexp_level >= g_debug_level ) THEN
1728: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
1729: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1730: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1731: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
1732: END IF;
1733: APP_EXCEPTION.Raise_Exception;
1734:
1735:

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

3118: IF ( g_unexp_level >= g_debug_level ) THEN
3119: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
3120: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
3121: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
3122: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
3123: END IF;
3124: APP_EXCEPTION.Raise_Exception;
3125: END Create_Journal_Adjustments;
3126:

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

3472: IF ( g_unexp_level >= g_debug_level ) THEN
3473: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
3474: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
3475: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
3476: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
3477: END IF;
3478: -- Terminate processing with error
3479: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
3480: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Process_Document');

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

3500: IF ( g_unexp_level >= g_debug_level ) THEN
3501: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
3502: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
3503: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
3504: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
3505: END IF;
3506: -- Terminate processing with error
3507: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
3508: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Process_Document');

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

3678: IF ( g_unexp_level >= g_debug_level ) THEN
3679: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
3680: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
3681: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
3682: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
3683: END IF;
3684: -- Terminate processing with error
3685: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
3686: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Process_Document');

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

3706: IF ( g_unexp_level >= g_debug_level ) THEN
3707: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
3708: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
3709: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
3710: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
3711: END IF;
3712: -- Terminate processing with error
3713: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
3714: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Process_Document');

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

3786: IF ( g_unexp_level >= g_debug_level ) THEN
3787: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
3788: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
3789: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
3790: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
3791: END IF;
3792: x_return_code := 2;
3793: fnd_message.set_name('IGC','IGC_LOGGING_USER_ERROR');
3794: x_msg_buf := fnd_message.get;

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

4729: IF ( g_unexp_level >= g_debug_level ) THEN
4730: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
4731: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
4732: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
4733: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
4734: END IF;
4735: x_return_code := 2 ;
4736: fnd_message.set_name('IGC','IGC_LOGGIN_USER_ERROR');
4737: x_msg_buf := fnd_message.get;

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

5083: IF ( g_unexp_level >= g_debug_level ) THEN
5084: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
5085: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
5086: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
5087: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
5088: END IF;
5089: APP_EXCEPTION.Raise_Exception;
5090: retcode := 2 ;
5091: fnd_message.set_name('IGC','IGC_LOGGING_USER_ERROR');