DBA Data[Home] [Help]

APPS.IGC_CC_COMPLETE_COVER_PKG dependencies on FND_LOG

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

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

Line 9: g_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

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

Line 10: g_state_level number := FND_LOG.LEVEL_STATEMENT;

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

Line 11: g_proc_level number := FND_LOG.LEVEL_PROCEDURE;

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

Line 12: g_event_level number := FND_LOG.LEVEL_EVENT;

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

Line 13: g_excep_level number := FND_LOG.LEVEL_EXCEPTION;

9: g_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
10: g_state_level number := FND_LOG.LEVEL_STATEMENT;
11: g_proc_level number := FND_LOG.LEVEL_PROCEDURE;
12: g_event_level number := FND_LOG.LEVEL_EVENT;
13: g_excep_level number := FND_LOG.LEVEL_EXCEPTION;
14: g_error_level number := FND_LOG.LEVEL_ERROR;
15: g_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
16: g_path varchar2(500) := 'igc.plsql.igcccovb.igc_cc_complete_cover_pkg.';
17:

Line 14: g_error_level number := FND_LOG.LEVEL_ERROR;

10: g_state_level number := FND_LOG.LEVEL_STATEMENT;
11: g_proc_level number := FND_LOG.LEVEL_PROCEDURE;
12: g_event_level number := FND_LOG.LEVEL_EVENT;
13: g_excep_level number := FND_LOG.LEVEL_EXCEPTION;
14: g_error_level number := FND_LOG.LEVEL_ERROR;
15: g_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
16: g_path varchar2(500) := 'igc.plsql.igcccovb.igc_cc_complete_cover_pkg.';
17:
18: Procedure complete_cover ( errbuf OUT NOCOPY VARCHAR2

Line 15: g_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;

11: g_proc_level number := FND_LOG.LEVEL_PROCEDURE;
12: g_event_level number := FND_LOG.LEVEL_EVENT;
13: g_excep_level number := FND_LOG.LEVEL_EXCEPTION;
14: g_error_level number := FND_LOG.LEVEL_ERROR;
15: g_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
16: g_path varchar2(500) := 'igc.plsql.igcccovb.igc_cc_complete_cover_pkg.';
17:
18: Procedure complete_cover ( errbuf OUT NOCOPY VARCHAR2
19: ,retcode OUT NOCOPY NUMBER

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

127: from PO_HEADERS
128: where segment1 = x_cc_num
129: and type_lookup_code = 'STANDARD';
130:
131: /*modifed for 3199488 - fnd logging changes*/
132: /*ocedure Writelog (l_full_path, p_mesg in varchar2)IS
133: Begin
134: fnd_file.put_line( fnd_file.log , p_mesg ) ;
135: End Writelog;*/

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

140: ) IS
141: BEGIN
142:
143: IF p_sev_level >= g_debug_level THEN
144: fnd_log.string(p_sev_level, p_path, p_debug_msg);
145: END IF;
146: END;
147:
148: -- Procedure initialise_variables initialises the variables

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

386:
387: FND_MESSAGE.SET_NAME('IGI', 'IGI_GEN_PROD_NOT_INSTALLED');
388: FND_MESSAGE.SET_TOKEN('OPTION_NAME', l_option_name);
389: IF(g_error_level >= g_debug_level) THEN
390: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
391: END IF;
392: lv_message := fnd_message.get;
393: errbuf := lv_message;
394: retcode := 2;

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

440: If matched_releases ( C_purchase_orders_rec.po_header_id) then
441: If Igc_cc_rep_yep_pvt.Invoice_canc_or_paid(c_rel_rec.cc_header_id) then
442: fnd_message.set_name('IGC', 'IGC_CC_PURCHASE_ORDER_ERROR');
443: IF(g_excep_level >= g_debug_level) THEN
444: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
445: END IF;
446: l_msg_data := fnd_message.get;
447: l_validation_error_code := 'Y';
448: Insert_exception ( l_request_id

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

456: End if;
457: Else
458: fnd_message.set_name('IGC', 'IGC_CC_INVOICE_MATCH_ERROR');
459: IF(g_error_level >= g_debug_level) THEN
460: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
461: END IF;
462: l_msg_data := fnd_message.get;
463: l_validation_error_code := 'Y';
464: Insert_exception ( l_request_id

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

561: fnd_message.set_token('RELEASE_STATE', c_rel_rec.cc_state);
562: fnd_message.set_token('APPROVAL_STATUS', c_rel_rec.cc_apprvl_status);
563: l_msg_data := fnd_message.get;
564: IF(g_error_level >= g_debug_level) THEN
565: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
566: END IF;
567: l_validation_error_code := 'Y';
568: Insert_exception ( l_request_id
569: , c_rel_rec.set_of_books_id

Line 672: fnd_log.message(g_unexp_level,l_full_path,TRUE);

668: IF g_unexp_level >= g_debug_level THEN
669: fnd_message.set_name('IGC','IGC_LOGGING_UNEXP_ERROR');
670: fnd_message.set_token('CODE',SQLCODE);
671: fnd_message.set_token('MESG',SQLERRM);
672: fnd_log.message(g_unexp_level,l_full_path,TRUE);
673: END IF;
674: raise_application_error (-20000,'IGCCCOVB : '||SQLERRM ||'-'||SQLCODE);
675: --raise_application_error (-20000,errbuf);
676: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

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

684: l_error_text := '';
685: FOR l_cur IN 1..l_msg_count LOOP
686: l_error_text := l_cur ||' '|| FND_MSG_PUB.GET(l_cur, FND_API.G_FALSE);
687: IF(g_excep_level >= g_debug_level) THEN
688: FND_LOG.STRING(g_excep_level, l_full_path, l_error_text);
689: END IF;
690: fnd_file.put_line (FND_FILE.LOG,
691: l_error_text);
692: WriteLog(l_full_path, l_error_text, g_excep_level);

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

694: ELSE
695: l_error_text := 'Error Returned but Error stack has no data';
696:
697: if g_excep_level >= g_debug_level then
698: FND_LOG.STRING(g_excep_level, l_full_path, l_error_text);
699: end if;
700:
701: fnd_file.put_line (FND_FILE.LOG,
702: l_error_text);

Line 728: fnd_log.message(g_unexp_level,l_full_path,TRUE);

724: IF g_unexp_level >= g_debug_level THEN
725: fnd_message.set_name('IGC','IGC_LOGGING_UNEXP_ERROR');
726: fnd_message.set_token('CODE',SQLCODE);
727: fnd_message.set_token('MESG',SQLERRM);
728: fnd_log.message(g_unexp_level,l_full_path,TRUE);
729: END IF;
730: raise_application_error (-20000,'IGCCCOVB : '||SQLERRM ||'-'||SQLCODE);
731: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
732: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Complete_cover');