1: PACKAGE BODY fun_net_arap_pkg AS
2: /* $Header: funnttxb.pls 120.112.12020000.3 2012/12/19 06:42:01 srampure ship $ */
3: --===========================FND_LOG.START=====================================
4: g_state_level NUMBER;
5: g_proc_level NUMBER;
6: g_event_level NUMBER;
7: g_excep_level NUMBER;
7: g_excep_level NUMBER;
8: g_error_level NUMBER;
9: g_unexp_level NUMBER;
10: g_path VARCHAR2(100);
11: --===========================FND_LOG.END=======================================
12: --Declare all required global variables
13: TYPE batch_rec IS RECORD
14: (batch_id fun_net_batches_all.batch_id%TYPE,
15: agreement_id fun_net_agreements_all.agreement_id%TYPE,
4903: RETURN 'N';
4904: END get_esd_flag;
4905: BEGIN
4906: g_today := TRUNC(sysdate);
4907: --===========================FND_LOG.START=====================================
4908: g_state_level := FND_LOG.LEVEL_STATEMENT;
4909: g_proc_level := FND_LOG.LEVEL_PROCEDURE;
4910: g_event_level := FND_LOG.LEVEL_EVENT;
4911: g_excep_level := FND_LOG.LEVEL_EXCEPTION;
4904: END get_esd_flag;
4905: BEGIN
4906: g_today := TRUNC(sysdate);
4907: --===========================FND_LOG.START=====================================
4908: g_state_level := FND_LOG.LEVEL_STATEMENT;
4909: g_proc_level := FND_LOG.LEVEL_PROCEDURE;
4910: g_event_level := FND_LOG.LEVEL_EVENT;
4911: g_excep_level := FND_LOG.LEVEL_EXCEPTION;
4912: g_error_level := FND_LOG.LEVEL_ERROR;
4905: BEGIN
4906: g_today := TRUNC(sysdate);
4907: --===========================FND_LOG.START=====================================
4908: g_state_level := FND_LOG.LEVEL_STATEMENT;
4909: g_proc_level := FND_LOG.LEVEL_PROCEDURE;
4910: g_event_level := FND_LOG.LEVEL_EVENT;
4911: g_excep_level := FND_LOG.LEVEL_EXCEPTION;
4912: g_error_level := FND_LOG.LEVEL_ERROR;
4913: g_unexp_level := FND_LOG.LEVEL_UNEXPECTED;
4906: g_today := TRUNC(sysdate);
4907: --===========================FND_LOG.START=====================================
4908: g_state_level := FND_LOG.LEVEL_STATEMENT;
4909: g_proc_level := FND_LOG.LEVEL_PROCEDURE;
4910: g_event_level := FND_LOG.LEVEL_EVENT;
4911: g_excep_level := FND_LOG.LEVEL_EXCEPTION;
4912: g_error_level := FND_LOG.LEVEL_ERROR;
4913: g_unexp_level := FND_LOG.LEVEL_UNEXPECTED;
4914: g_path := 'FUN.PLSQL.funnttxb.FUN_NET_ARAP_PKG.';
4907: --===========================FND_LOG.START=====================================
4908: g_state_level := FND_LOG.LEVEL_STATEMENT;
4909: g_proc_level := FND_LOG.LEVEL_PROCEDURE;
4910: g_event_level := FND_LOG.LEVEL_EVENT;
4911: g_excep_level := FND_LOG.LEVEL_EXCEPTION;
4912: g_error_level := FND_LOG.LEVEL_ERROR;
4913: g_unexp_level := FND_LOG.LEVEL_UNEXPECTED;
4914: g_path := 'FUN.PLSQL.funnttxb.FUN_NET_ARAP_PKG.';
4915: --===========================FND_LOG.END=======================================
4908: g_state_level := FND_LOG.LEVEL_STATEMENT;
4909: g_proc_level := FND_LOG.LEVEL_PROCEDURE;
4910: g_event_level := FND_LOG.LEVEL_EVENT;
4911: g_excep_level := FND_LOG.LEVEL_EXCEPTION;
4912: g_error_level := FND_LOG.LEVEL_ERROR;
4913: g_unexp_level := FND_LOG.LEVEL_UNEXPECTED;
4914: g_path := 'FUN.PLSQL.funnttxb.FUN_NET_ARAP_PKG.';
4915: --===========================FND_LOG.END=======================================
4916: END FUN_NET_ARAP_PKG;
4909: g_proc_level := FND_LOG.LEVEL_PROCEDURE;
4910: g_event_level := FND_LOG.LEVEL_EVENT;
4911: g_excep_level := FND_LOG.LEVEL_EXCEPTION;
4912: g_error_level := FND_LOG.LEVEL_ERROR;
4913: g_unexp_level := FND_LOG.LEVEL_UNEXPECTED;
4914: g_path := 'FUN.PLSQL.funnttxb.FUN_NET_ARAP_PKG.';
4915: --===========================FND_LOG.END=======================================
4916: END FUN_NET_ARAP_PKG;
4911: g_excep_level := FND_LOG.LEVEL_EXCEPTION;
4912: g_error_level := FND_LOG.LEVEL_ERROR;
4913: g_unexp_level := FND_LOG.LEVEL_UNEXPECTED;
4914: g_path := 'FUN.PLSQL.funnttxb.FUN_NET_ARAP_PKG.';
4915: --===========================FND_LOG.END=======================================
4916: END FUN_NET_ARAP_PKG;