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 617: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);

613: IF ( g_unexp_level >= g_debug_level ) THEN
614: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
615: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
616: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
617: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
618: END IF;
619:
620: END Execute_Exceptions_Report;
621:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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