eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FV_FACTS_GL_PKG_EXT dependencies on FND_LOG

Line 56: --* : fnd_log.level_procedure *--

52: --* Global Vars : g_SUCCESS *--
53: --* : g_FAILURE *--
54: --* : g_enter *--
55: --* : g_exit *--
56: --* : fnd_log.level_procedure *--
57: --* : g_module_name *--
58: --* : fnd_log.g_current_runtime_level *--
59: --* : fnd_log.level_statement *--
60: --* : fnd_log.level_unexpected *--

Line 58: --* : fnd_log.g_current_runtime_level *--

54: --* : g_enter *--
55: --* : g_exit *--
56: --* : fnd_log.level_procedure *--
57: --* : g_module_name *--
58: --* : fnd_log.g_current_runtime_level *--
59: --* : fnd_log.level_statement *--
60: --* : fnd_log.level_unexpected *--
61: --* Called from : process_parameters *--
62: --* Calls : fv_utility.debug_mesg *--

Line 59: --* : fnd_log.level_statement *--

55: --* : g_exit *--
56: --* : fnd_log.level_procedure *--
57: --* : g_module_name *--
58: --* : fnd_log.g_current_runtime_level *--
59: --* : fnd_log.level_statement *--
60: --* : fnd_log.level_unexpected *--
61: --* Called from : process_parameters *--
62: --* Calls : fv_utility.debug_mesg *--
63: --* : fv_utility.log_mesg *--

Line 60: --* : fnd_log.level_unexpected *--

56: --* : fnd_log.level_procedure *--
57: --* : g_module_name *--
58: --* : fnd_log.g_current_runtime_level *--
59: --* : fnd_log.level_statement *--
60: --* : fnd_log.level_unexpected *--
61: --* Called from : process_parameters *--
62: --* Calls : fv_utility.debug_mesg *--
63: --* : fv_utility.log_mesg *--
64: --* Tables Used : fv_system_parameters SELECT *--

Line 82: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

78: BEGIN
79: l_module_name := g_module_name || 'get_fed_system_parameters';
80: p_retcode := g_SUCCESS;
81:
82: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
83: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_enter);
84: END IF;
85:
86: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 83: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_enter);

79: l_module_name := g_module_name || 'get_fed_system_parameters';
80: p_retcode := g_SUCCESS;
81:
82: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
83: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_enter);
84: END IF;
85:
86: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
87: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '*****INPUT PARAMETERS*******');

Line 86: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

82: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
83: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_enter);
84: END IF;
85:
86: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
87: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '*****INPUT PARAMETERS*******');
88: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'None');
89: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '****************************');
90: END IF;

Line 87: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '*INPUT PARAMETERS***');

83: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_enter);
84: END IF;
85:
86: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
87: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '*****INPUT PARAMETERS*******');
88: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'None');
89: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '****************************');
90: END IF;
91:

Line 88: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'None');

84: END IF;
85:
86: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
87: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '*****INPUT PARAMETERS*******');
88: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'None');
89: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '****************************');
90: END IF;
91:
92: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 89: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '****************************');

85:
86: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
87: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '*****INPUT PARAMETERS*******');
88: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'None');
89: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '****************************');
90: END IF;
91:
92: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
93: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'SELECT from fv_system_parameters');

Line 92: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

88: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'None');
89: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '****************************');
90: END IF;
91:
92: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
93: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'SELECT from fv_system_parameters');
94: END IF;
95: SELECT fsp.factsi_customer_attribute,
96: fsp.factsi_vendor_attribute

Line 93: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'SELECT from fv_system_parameters');

89: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '****************************');
90: END IF;
91:
92: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
93: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'SELECT from fv_system_parameters');
94: END IF;
95: SELECT fsp.factsi_customer_attribute,
96: fsp.factsi_vendor_attribute
97: INTO p_customer_attribute,

Line 101: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

97: INTO p_customer_attribute,
98: p_vendor_attribute
99: FROM fv_system_parameters fsp;
100:
101: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
102: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '*****OUTPUT PARAMETERS******');
103: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_attribute = '||p_vendor_attribute);
104: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_customer_attribute = '||p_customer_attribute);
105: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_errbuf = '||p_errbuf);

Line 102: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '*OUTPUT PARAMETERS**');

98: p_vendor_attribute
99: FROM fv_system_parameters fsp;
100:
101: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
102: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '*****OUTPUT PARAMETERS******');
103: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_attribute = '||p_vendor_attribute);
104: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_customer_attribute = '||p_customer_attribute);
105: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_errbuf = '||p_errbuf);
106: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_retcode = '||p_retcode);

Line 103: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_attribute = '||p_vendor_attribute);

99: FROM fv_system_parameters fsp;
100:
101: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
102: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '*****OUTPUT PARAMETERS******');
103: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_attribute = '||p_vendor_attribute);
104: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_customer_attribute = '||p_customer_attribute);
105: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_errbuf = '||p_errbuf);
106: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_retcode = '||p_retcode);
107: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '****************************');

Line 104: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_customer_attribute = '||p_customer_attribute);

100:
101: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
102: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '*****OUTPUT PARAMETERS******');
103: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_attribute = '||p_vendor_attribute);
104: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_customer_attribute = '||p_customer_attribute);
105: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_errbuf = '||p_errbuf);
106: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_retcode = '||p_retcode);
107: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '****************************');
108: END IF;

Line 105: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_errbuf = '||p_errbuf);

101: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
102: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '*****OUTPUT PARAMETERS******');
103: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_attribute = '||p_vendor_attribute);
104: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_customer_attribute = '||p_customer_attribute);
105: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_errbuf = '||p_errbuf);
106: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_retcode = '||p_retcode);
107: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '****************************');
108: END IF;
109:

Line 106: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_retcode = '||p_retcode);

102: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '*****OUTPUT PARAMETERS******');
103: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_attribute = '||p_vendor_attribute);
104: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_customer_attribute = '||p_customer_attribute);
105: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_errbuf = '||p_errbuf);
106: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_retcode = '||p_retcode);
107: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '****************************');
108: END IF;
109:
110: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

Line 107: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '****************************');

103: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_attribute = '||p_vendor_attribute);
104: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_customer_attribute = '||p_customer_attribute);
105: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_errbuf = '||p_errbuf);
106: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_retcode = '||p_retcode);
107: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '****************************');
108: END IF;
109:
110: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
111: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');

Line 110: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

106: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_retcode = '||p_retcode);
107: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '****************************');
108: END IF;
109:
110: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
111: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
112: END IF;
113: EXCEPTION
114: WHEN OTHERS THEN

Line 111: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');

107: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '****************************');
108: END IF;
109:
110: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
111: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
112: END IF;
113: EXCEPTION
114: WHEN OTHERS THEN
115: p_retcode := g_FAILURE;

Line 118: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;

114: WHEN OTHERS THEN
115: p_retcode := g_FAILURE;
116: p_errbuf := SQLERRM;
117: l_location := l_module_name||'.final_exception';
118: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
119: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
120: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
121: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
122: END IF;

Line 119: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;

115: p_retcode := g_FAILURE;
116: p_errbuf := SQLERRM;
117: l_location := l_module_name||'.final_exception';
118: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
119: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
120: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
121: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
122: END IF;
123: END;

Line 120: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

116: p_errbuf := SQLERRM;
117: l_location := l_module_name||'.final_exception';
118: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
119: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
120: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
121: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
122: END IF;
123: END;
124:

Line 121: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');

117: l_location := l_module_name||'.final_exception';
118: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
119: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
120: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
121: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
122: END IF;
123: END;
124:
125: --****************************************************************************************--

Line 144: --* : fnd_log.level_procedure *--

140: --* Global Vars : g_SUCCESS *--
141: --* : g_FAILURE *--
142: --* : g_enter *--
143: --* : g_exit *--
144: --* : fnd_log.level_procedure *--
145: --* : g_module_name *--
146: --* : fnd_log.g_current_runtime_level *--
147: --* : fnd_log.level_statement *--
148: --* : fnd_log.level_unexpected *--

Line 146: --* : fnd_log.g_current_runtime_level *--

142: --* : g_enter *--
143: --* : g_exit *--
144: --* : fnd_log.level_procedure *--
145: --* : g_module_name *--
146: --* : fnd_log.g_current_runtime_level *--
147: --* : fnd_log.level_statement *--
148: --* : fnd_log.level_unexpected *--
149: --* : g_conc_program_id *--
150: --* : g_conc_program_id WRITE *--

Line 147: --* : fnd_log.level_statement *--

143: --* : g_exit *--
144: --* : fnd_log.level_procedure *--
145: --* : g_module_name *--
146: --* : fnd_log.g_current_runtime_level *--
147: --* : fnd_log.level_statement *--
148: --* : fnd_log.level_unexpected *--
149: --* : g_conc_program_id *--
150: --* : g_conc_program_id WRITE *--
151: --* Called from : main *--

Line 148: --* : fnd_log.level_unexpected *--

144: --* : fnd_log.level_procedure *--
145: --* : g_module_name *--
146: --* : fnd_log.g_current_runtime_level *--
147: --* : fnd_log.level_statement *--
148: --* : fnd_log.level_unexpected *--
149: --* : g_conc_program_id *--
150: --* : g_conc_program_id WRITE *--
151: --* Called from : main *--
152: --* Calls : fv_utility.debug_mesg *--

Line 189: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

185: BEGIN
186: l_module_name := g_module_name || 'process_parameters';
187: p_retcode := g_SUCCESS;
188:
189: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
190: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_enter);
191: END IF;
192:
193: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 190: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_enter);

186: l_module_name := g_module_name || 'process_parameters';
187: p_retcode := g_SUCCESS;
188:
189: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
190: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_enter);
191: END IF;
192:
193: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
194: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '*****INPUT PARAMETERS*******');

Line 193: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

189: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
190: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_enter);
191: END IF;
192:
193: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
194: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '*****INPUT PARAMETERS*******');
195: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_ledger_id = '||p_ledger_id);
196: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_or_cust = '||p_vendor_or_cust);
197: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_or_cust_id = '||p_vendor_or_cust_id);

Line 194: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '*INPUT PARAMETERS***');

190: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_enter);
191: END IF;
192:
193: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
194: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '*****INPUT PARAMETERS*******');
195: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_ledger_id = '||p_ledger_id);
196: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_or_cust = '||p_vendor_or_cust);
197: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_or_cust_id = '||p_vendor_or_cust_id);
198: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_from_period = '||p_from_period);

Line 195: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_ledger_id = '||p_ledger_id);

191: END IF;
192:
193: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
194: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '*****INPUT PARAMETERS*******');
195: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_ledger_id = '||p_ledger_id);
196: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_or_cust = '||p_vendor_or_cust);
197: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_or_cust_id = '||p_vendor_or_cust_id);
198: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_from_period = '||p_from_period);
199: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_to_period = '||p_to_period);

Line 196: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_or_cust = '||p_vendor_or_cust);

192:
193: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
194: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '*****INPUT PARAMETERS*******');
195: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_ledger_id = '||p_ledger_id);
196: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_or_cust = '||p_vendor_or_cust);
197: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_or_cust_id = '||p_vendor_or_cust_id);
198: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_from_period = '||p_from_period);
199: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_to_period = '||p_to_period);
200: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '****************************');

Line 197: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_or_cust_id = '||p_vendor_or_cust_id);

193: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
194: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '*****INPUT PARAMETERS*******');
195: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_ledger_id = '||p_ledger_id);
196: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_or_cust = '||p_vendor_or_cust);
197: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_or_cust_id = '||p_vendor_or_cust_id);
198: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_from_period = '||p_from_period);
199: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_to_period = '||p_to_period);
200: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '****************************');
201: END IF;

Line 198: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_from_period = '||p_from_period);

194: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '*****INPUT PARAMETERS*******');
195: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_ledger_id = '||p_ledger_id);
196: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_or_cust = '||p_vendor_or_cust);
197: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_or_cust_id = '||p_vendor_or_cust_id);
198: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_from_period = '||p_from_period);
199: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_to_period = '||p_to_period);
200: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '****************************');
201: END IF;
202:

Line 199: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_to_period = '||p_to_period);

195: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_ledger_id = '||p_ledger_id);
196: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_or_cust = '||p_vendor_or_cust);
197: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_or_cust_id = '||p_vendor_or_cust_id);
198: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_from_period = '||p_from_period);
199: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_to_period = '||p_to_period);
200: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '****************************');
201: END IF;
202:
203: IF (NVL(p_vendor_or_cust, 'X') NOT IN ('V', 'C')) THEN

Line 200: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '****************************');

196: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_or_cust = '||p_vendor_or_cust);
197: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_or_cust_id = '||p_vendor_or_cust_id);
198: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_from_period = '||p_from_period);
199: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_to_period = '||p_to_period);
200: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '****************************');
201: END IF;
202:
203: IF (NVL(p_vendor_or_cust, 'X') NOT IN ('V', 'C')) THEN
204: p_retcode := g_FAILURE;

Line 207: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;

203: IF (NVL(p_vendor_or_cust, 'X') NOT IN ('V', 'C')) THEN
204: p_retcode := g_FAILURE;
205: p_errbuf := 'Unknown Vendor or Customer Type Idenfier. Should be either V or C.';
206: l_location := l_module_name||'p_vendor_or_cust_required';
207: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
208: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
209: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
210: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
211: END IF;

Line 208: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;

204: p_retcode := g_FAILURE;
205: p_errbuf := 'Unknown Vendor or Customer Type Idenfier. Should be either V or C.';
206: l_location := l_module_name||'p_vendor_or_cust_required';
207: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
208: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
209: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
210: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
211: END IF;
212: END IF;

Line 209: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

205: p_errbuf := 'Unknown Vendor or Customer Type Idenfier. Should be either V or C.';
206: l_location := l_module_name||'p_vendor_or_cust_required';
207: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
208: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
209: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
210: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
211: END IF;
212: END IF;
213:

Line 210: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');

206: l_location := l_module_name||'p_vendor_or_cust_required';
207: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
208: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
209: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
210: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
211: END IF;
212: END IF;
213:
214: IF (p_vendor_or_cust_id IS NULL) THEN

Line 218: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;

214: IF (p_vendor_or_cust_id IS NULL) THEN
215: p_retcode := g_FAILURE;
216: p_errbuf := 'Vendor or Customer Information is required';
217: l_location := l_module_name||'p_vendor_or_cust_id_required';
218: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
219: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
220: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
221: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
222: END IF;

Line 219: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;

215: p_retcode := g_FAILURE;
216: p_errbuf := 'Vendor or Customer Information is required';
217: l_location := l_module_name||'p_vendor_or_cust_id_required';
218: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
219: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
220: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
221: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
222: END IF;
223: END IF;

Line 220: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

216: p_errbuf := 'Vendor or Customer Information is required';
217: l_location := l_module_name||'p_vendor_or_cust_id_required';
218: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
219: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
220: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
221: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
222: END IF;
223: END IF;
224:

Line 221: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');

217: l_location := l_module_name||'p_vendor_or_cust_id_required';
218: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
219: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
220: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
221: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
222: END IF;
223: END IF;
224:
225: IF (p_from_period IS NULL) THEN

Line 229: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;

225: IF (p_from_period IS NULL) THEN
226: p_retcode := g_FAILURE;
227: p_errbuf := 'From Period is required';
228: l_location := l_module_name||'from_period_required';
229: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
230: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
231: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
232: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
233: END IF;

Line 230: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;

226: p_retcode := g_FAILURE;
227: p_errbuf := 'From Period is required';
228: l_location := l_module_name||'from_period_required';
229: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
230: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
231: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
232: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
233: END IF;
234: END IF;

Line 231: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

227: p_errbuf := 'From Period is required';
228: l_location := l_module_name||'from_period_required';
229: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
230: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
231: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
232: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
233: END IF;
234: END IF;
235:

Line 232: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');

228: l_location := l_module_name||'from_period_required';
229: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
230: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
231: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
232: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
233: END IF;
234: END IF;
235:
236: IF (p_to_period IS NULL) THEN

Line 240: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;

236: IF (p_to_period IS NULL) THEN
237: p_retcode := g_FAILURE;
238: p_errbuf := 'To Period is required';
239: l_location := l_module_name||'to_period_required';
240: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
241: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
242: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
243: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
244: END IF;

Line 241: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;

237: p_retcode := g_FAILURE;
238: p_errbuf := 'To Period is required';
239: l_location := l_module_name||'to_period_required';
240: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
241: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
242: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
243: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
244: END IF;
245: END IF;

Line 242: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

238: p_errbuf := 'To Period is required';
239: l_location := l_module_name||'to_period_required';
240: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
241: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
242: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
243: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
244: END IF;
245: END IF;
246:

Line 243: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');

239: l_location := l_module_name||'to_period_required';
240: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
241: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
242: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
243: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
244: END IF;
245: END IF;
246:
247: IF (p_retcode = g_SUCCESS) THEN

Line 262: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;

258: WHEN NO_DATA_FOUND THEN
259: p_retcode := g_FAILURE;
260: p_errbuf := 'No From Period found '||p_from_period;
261: l_location := l_module_name||'select_gl_period_statuses1';
262: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
263: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
264: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
265: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
266: END IF;

Line 263: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;

259: p_retcode := g_FAILURE;
260: p_errbuf := 'No From Period found '||p_from_period;
261: l_location := l_module_name||'select_gl_period_statuses1';
262: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
263: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
264: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
265: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
266: END IF;
267: WHEN OTHERS THEN

Line 264: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

260: p_errbuf := 'No From Period found '||p_from_period;
261: l_location := l_module_name||'select_gl_period_statuses1';
262: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
263: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
264: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
265: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
266: END IF;
267: WHEN OTHERS THEN
268: p_retcode := g_FAILURE;

Line 265: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');

261: l_location := l_module_name||'select_gl_period_statuses1';
262: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
263: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
264: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
265: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
266: END IF;
267: WHEN OTHERS THEN
268: p_retcode := g_FAILURE;
269: p_errbuf := SQLERRM;

Line 271: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;

267: WHEN OTHERS THEN
268: p_retcode := g_FAILURE;
269: p_errbuf := SQLERRM;
270: l_location := l_module_name||'select_gl_period_statuses1';
271: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
272: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
273: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
274: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
275: END IF;

Line 272: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;

268: p_retcode := g_FAILURE;
269: p_errbuf := SQLERRM;
270: l_location := l_module_name||'select_gl_period_statuses1';
271: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
272: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
273: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
274: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
275: END IF;
276: END;

Line 273: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

269: p_errbuf := SQLERRM;
270: l_location := l_module_name||'select_gl_period_statuses1';
271: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
272: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
273: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
274: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
275: END IF;
276: END;
277: END IF;

Line 274: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');

270: l_location := l_module_name||'select_gl_period_statuses1';
271: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
272: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
273: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
274: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
275: END IF;
276: END;
277: END IF;
278:

Line 294: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;

290: WHEN NO_DATA_FOUND THEN
291: p_retcode := g_FAILURE;
292: p_errbuf := 'No To Period found '||p_from_period;
293: l_location := l_module_name||'select_gl_period_statuses1';
294: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
295: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
296: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
297: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
298: END IF;

Line 295: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;

291: p_retcode := g_FAILURE;
292: p_errbuf := 'No To Period found '||p_from_period;
293: l_location := l_module_name||'select_gl_period_statuses1';
294: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
295: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
296: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
297: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
298: END IF;
299: WHEN OTHERS THEN

Line 296: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

292: p_errbuf := 'No To Period found '||p_from_period;
293: l_location := l_module_name||'select_gl_period_statuses1';
294: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
295: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
296: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
297: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
298: END IF;
299: WHEN OTHERS THEN
300: p_retcode := g_FAILURE;

Line 297: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');

293: l_location := l_module_name||'select_gl_period_statuses1';
294: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
295: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
296: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
297: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
298: END IF;
299: WHEN OTHERS THEN
300: p_retcode := g_FAILURE;
301: p_errbuf := SQLERRM;

Line 303: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;

299: WHEN OTHERS THEN
300: p_retcode := g_FAILURE;
301: p_errbuf := SQLERRM;
302: l_location := l_module_name||'select_gl_period_statuses1';
303: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
304: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
305: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
306: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
307: END IF;

Line 304: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;

300: p_retcode := g_FAILURE;
301: p_errbuf := SQLERRM;
302: l_location := l_module_name||'select_gl_period_statuses1';
303: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
304: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
305: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
306: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
307: END IF;
308: END;

Line 305: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

301: p_errbuf := SQLERRM;
302: l_location := l_module_name||'select_gl_period_statuses1';
303: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
304: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
305: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
306: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
307: END IF;
308: END;
309: END IF;

Line 306: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');

302: l_location := l_module_name||'select_gl_period_statuses1';
303: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
304: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
305: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
306: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
307: END IF;
308: END;
309: END IF;
310:

Line 315: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;

311: IF (p_period_year <> l_period_year) THEN
312: p_retcode := g_FAILURE;
313: p_errbuf := 'From Period Name and To Period Name are from 2 different fiscal years.';
314: l_location := l_module_name||'period_year_mismatch';
315: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
316: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
317: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
318: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
319: END IF;

Line 316: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;

312: p_retcode := g_FAILURE;
313: p_errbuf := 'From Period Name and To Period Name are from 2 different fiscal years.';
314: l_location := l_module_name||'period_year_mismatch';
315: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
316: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
317: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
318: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
319: END IF;
320: END IF;

Line 317: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

313: p_errbuf := 'From Period Name and To Period Name are from 2 different fiscal years.';
314: l_location := l_module_name||'period_year_mismatch';
315: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
316: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
317: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
318: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
319: END IF;
320: END IF;
321:

Line 318: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');

314: l_location := l_module_name||'period_year_mismatch';
315: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
316: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
317: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
318: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
319: END IF;
320: END IF;
321:
322: IF (p_from_period_num > p_to_period_num) THEN

Line 326: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;

322: IF (p_from_period_num > p_to_period_num) THEN
323: p_retcode := g_FAILURE;
324: p_errbuf := 'From Period Name is greater than To Period Name.';
325: l_location := l_module_name||'period_name_mismatch';
326: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
327: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
328: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
329: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
330: END IF;

Line 327: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;

323: p_retcode := g_FAILURE;
324: p_errbuf := 'From Period Name is greater than To Period Name.';
325: l_location := l_module_name||'period_name_mismatch';
326: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
327: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
328: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
329: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
330: END IF;
331: END IF;

Line 328: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

324: p_errbuf := 'From Period Name is greater than To Period Name.';
325: l_location := l_module_name||'period_name_mismatch';
326: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
327: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
328: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
329: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
330: END IF;
331: END IF;
332:

Line 329: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');

325: l_location := l_module_name||'period_name_mismatch';
326: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
327: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
328: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
329: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
330: END IF;
331: END IF;
332:
333: IF (p_retcode = g_SUCCESS) THEN

Line 334: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

330: END IF;
331: END IF;
332:
333: IF (p_retcode = g_SUCCESS) THEN
334: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
335: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Calling get_fed_system_parameters');
336: END IF;
337: get_fed_system_parameters
338: (

Line 335: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Calling get_fed_system_parameters');

331: END IF;
332:
333: IF (p_retcode = g_SUCCESS) THEN
334: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
335: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Calling get_fed_system_parameters');
336: END IF;
337: get_fed_system_parameters
338: (
339: p_vendor_attribute => l_vendor_attribute,

Line 344: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

340: p_customer_attribute => l_customer_attribute,
341: p_errbuf => p_errbuf,
342: p_retcode => p_retcode
343: );
344: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
345: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Returned from get_fed_system_parameters');
346: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_vendor_attribute = '||l_vendor_attribute);
347: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_customer_attribute = '||l_customer_attribute);
348: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_errbuf = '||p_errbuf);

Line 345: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Returned from get_fed_system_parameters');

341: p_errbuf => p_errbuf,
342: p_retcode => p_retcode
343: );
344: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
345: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Returned from get_fed_system_parameters');
346: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_vendor_attribute = '||l_vendor_attribute);
347: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_customer_attribute = '||l_customer_attribute);
348: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_errbuf = '||p_errbuf);
349: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_retcode = '||p_retcode);

Line 346: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_vendor_attribute = '||l_vendor_attribute);

342: p_retcode => p_retcode
343: );
344: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
345: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Returned from get_fed_system_parameters');
346: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_vendor_attribute = '||l_vendor_attribute);
347: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_customer_attribute = '||l_customer_attribute);
348: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_errbuf = '||p_errbuf);
349: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_retcode = '||p_retcode);
350: END IF;

Line 347: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_customer_attribute = '||l_customer_attribute);

343: );
344: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
345: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Returned from get_fed_system_parameters');
346: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_vendor_attribute = '||l_vendor_attribute);
347: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_customer_attribute = '||l_customer_attribute);
348: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_errbuf = '||p_errbuf);
349: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_retcode = '||p_retcode);
350: END IF;
351: END IF;

Line 348: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_errbuf = '||p_errbuf);

344: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
345: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Returned from get_fed_system_parameters');
346: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_vendor_attribute = '||l_vendor_attribute);
347: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_customer_attribute = '||l_customer_attribute);
348: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_errbuf = '||p_errbuf);
349: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_retcode = '||p_retcode);
350: END IF;
351: END IF;
352:

Line 349: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_retcode = '||p_retcode);

345: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Returned from get_fed_system_parameters');
346: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_vendor_attribute = '||l_vendor_attribute);
347: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_customer_attribute = '||l_customer_attribute);
348: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_errbuf = '||p_errbuf);
349: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_retcode = '||p_retcode);
350: END IF;
351: END IF;
352:
353: IF (p_retcode = g_SUCCESS) THEN

Line 388: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;

384: WHEN OTHERS THEN
385: p_retcode := g_FAILURE;
386: p_errbuf := SQLERRM;
387: l_location := l_module_name||'select_gl_period_statuses1';
388: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
389: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
390: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
391: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
392: END IF;

Line 389: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;

385: p_retcode := g_FAILURE;
386: p_errbuf := SQLERRM;
387: l_location := l_module_name||'select_gl_period_statuses1';
388: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
389: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
390: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
391: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
392: END IF;
393: END;

Line 390: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

386: p_errbuf := SQLERRM;
387: l_location := l_module_name||'select_gl_period_statuses1';
388: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
389: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
390: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
391: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
392: END IF;
393: END;
394: END IF;

Line 391: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');

387: l_location := l_module_name||'select_gl_period_statuses1';
388: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
389: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
390: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
391: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
392: END IF;
393: END;
394: END IF;
395:

Line 409: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;

405: WHEN OTHERS THEN
406: p_retcode := g_FAILURE;
407: p_errbuf := SQLERRM;
408: l_location := l_module_name||'select_fnd_concurrent_programs';
409: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
410: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
411: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
412: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
413: END IF;

Line 410: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;

406: p_retcode := g_FAILURE;
407: p_errbuf := SQLERRM;
408: l_location := l_module_name||'select_fnd_concurrent_programs';
409: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
410: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
411: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
412: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
413: END IF;
414: END;

Line 411: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

407: p_errbuf := SQLERRM;
408: l_location := l_module_name||'select_fnd_concurrent_programs';
409: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
410: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
411: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
412: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
413: END IF;
414: END;
415: END IF;

Line 412: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');

408: l_location := l_module_name||'select_fnd_concurrent_programs';
409: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
410: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
411: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
412: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
413: END IF;
414: END;
415: END IF;
416:

Line 417: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

413: END IF;
414: END;
415: END IF;
416:
417: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
418: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '*****OUTPUT PARAMETERS******');
419: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_type = '||p_vendor_type);
420: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_elimination_id = '||p_elimination_id);
421: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_period_year = '||p_period_year);

Line 418: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '*OUTPUT PARAMETERS**');

414: END;
415: END IF;
416:
417: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
418: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '*****OUTPUT PARAMETERS******');
419: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_type = '||p_vendor_type);
420: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_elimination_id = '||p_elimination_id);
421: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_period_year = '||p_period_year);
422: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_from_period_num = '||p_from_period_num);

Line 419: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_type = '||p_vendor_type);

415: END IF;
416:
417: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
418: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '*****OUTPUT PARAMETERS******');
419: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_type = '||p_vendor_type);
420: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_elimination_id = '||p_elimination_id);
421: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_period_year = '||p_period_year);
422: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_from_period_num = '||p_from_period_num);
423: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_to_period_num = '||p_to_period_num);

Line 420: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_elimination_id = '||p_elimination_id);

416:
417: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
418: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '*****OUTPUT PARAMETERS******');
419: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_type = '||p_vendor_type);
420: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_elimination_id = '||p_elimination_id);
421: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_period_year = '||p_period_year);
422: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_from_period_num = '||p_from_period_num);
423: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_to_period_num = '||p_to_period_num);
424: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_errbuf = '||p_errbuf);

Line 421: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_period_year = '||p_period_year);

417: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
418: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '*****OUTPUT PARAMETERS******');
419: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_type = '||p_vendor_type);
420: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_elimination_id = '||p_elimination_id);
421: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_period_year = '||p_period_year);
422: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_from_period_num = '||p_from_period_num);
423: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_to_period_num = '||p_to_period_num);
424: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_errbuf = '||p_errbuf);
425: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_retcode = '||p_retcode);

Line 422: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_from_period_num = '||p_from_period_num);

418: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '*****OUTPUT PARAMETERS******');
419: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_type = '||p_vendor_type);
420: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_elimination_id = '||p_elimination_id);
421: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_period_year = '||p_period_year);
422: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_from_period_num = '||p_from_period_num);
423: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_to_period_num = '||p_to_period_num);
424: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_errbuf = '||p_errbuf);
425: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_retcode = '||p_retcode);
426: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '****************************');

Line 423: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_to_period_num = '||p_to_period_num);

419: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_type = '||p_vendor_type);
420: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_elimination_id = '||p_elimination_id);
421: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_period_year = '||p_period_year);
422: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_from_period_num = '||p_from_period_num);
423: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_to_period_num = '||p_to_period_num);
424: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_errbuf = '||p_errbuf);
425: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_retcode = '||p_retcode);
426: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '****************************');
427: END IF;

Line 424: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_errbuf = '||p_errbuf);

420: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_elimination_id = '||p_elimination_id);
421: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_period_year = '||p_period_year);
422: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_from_period_num = '||p_from_period_num);
423: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_to_period_num = '||p_to_period_num);
424: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_errbuf = '||p_errbuf);
425: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_retcode = '||p_retcode);
426: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '****************************');
427: END IF;
428:

Line 425: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_retcode = '||p_retcode);

421: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_period_year = '||p_period_year);
422: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_from_period_num = '||p_from_period_num);
423: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_to_period_num = '||p_to_period_num);
424: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_errbuf = '||p_errbuf);
425: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_retcode = '||p_retcode);
426: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '****************************');
427: END IF;
428:
429: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

Line 426: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '****************************');

422: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_from_period_num = '||p_from_period_num);
423: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_to_period_num = '||p_to_period_num);
424: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_errbuf = '||p_errbuf);
425: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_retcode = '||p_retcode);
426: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '****************************');
427: END IF;
428:
429: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
430: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');

Line 429: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

425: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_retcode = '||p_retcode);
426: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '****************************');
427: END IF;
428:
429: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
430: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
431: END IF;
432: EXCEPTION
433: WHEN OTHERS THEN

Line 430: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');

426: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '****************************');
427: END IF;
428:
429: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
430: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
431: END IF;
432: EXCEPTION
433: WHEN OTHERS THEN
434: p_retcode := g_FAILURE;

Line 437: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;

433: WHEN OTHERS THEN
434: p_retcode := g_FAILURE;
435: p_errbuf := SQLERRM;
436: l_location := l_module_name||'.final_exception';
437: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
438: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
439: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
440: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
441: END IF;

Line 438: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;

434: p_retcode := g_FAILURE;
435: p_errbuf := SQLERRM;
436: l_location := l_module_name||'.final_exception';
437: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
438: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
439: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
440: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
441: END IF;
442: END;

Line 439: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

435: p_errbuf := SQLERRM;
436: l_location := l_module_name||'.final_exception';
437: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
438: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
439: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
440: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
441: END IF;
442: END;
443:

Line 440: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');

436: l_location := l_module_name||'.final_exception';
437: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
438: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
439: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
440: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
441: END IF;
442: END;
443:
444: --****************************************************************************************--

Line 460: --* : fnd_log.level_procedure *--

456: --* Global Vars : g_SUCCESS *--
457: --* : g_FAILURE *--
458: --* : g_enter *--
459: --* : g_exit *--
460: --* : fnd_log.level_procedure *--
461: --* : g_module_name *--
462: --* : fnd_log.g_current_runtime_level *--
463: --* : fnd_log.level_statement *--
464: --* : fnd_log.level_unexpected *--

Line 462: --* : fnd_log.g_current_runtime_level *--

458: --* : g_enter *--
459: --* : g_exit *--
460: --* : fnd_log.level_procedure *--
461: --* : g_module_name *--
462: --* : fnd_log.g_current_runtime_level *--
463: --* : fnd_log.level_statement *--
464: --* : fnd_log.level_unexpected *--
465: --* : g_conc_program_name *--
466: --* : g_user_id *--

Line 463: --* : fnd_log.level_statement *--

459: --* : g_exit *--
460: --* : fnd_log.level_procedure *--
461: --* : g_module_name *--
462: --* : fnd_log.g_current_runtime_level *--
463: --* : fnd_log.level_statement *--
464: --* : fnd_log.level_unexpected *--
465: --* : g_conc_program_name *--
466: --* : g_user_id *--
467: --* : g_login_id *--

Line 464: --* : fnd_log.level_unexpected *--

460: --* : fnd_log.level_procedure *--
461: --* : g_module_name *--
462: --* : fnd_log.g_current_runtime_level *--
463: --* : fnd_log.level_statement *--
464: --* : fnd_log.level_unexpected *--
465: --* : g_conc_program_name *--
466: --* : g_user_id *--
467: --* : g_login_id *--
468: --* : g_set_of_books_id *--

Line 504: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

500: BEGIN
501: l_module_name := g_module_name || 'main';
502: p_retcode := g_SUCCESS;
503:
504: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
505: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_enter);
506: END IF;
507:
508: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 505: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_enter);

501: l_module_name := g_module_name || 'main';
502: p_retcode := g_SUCCESS;
503:
504: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
505: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_enter);
506: END IF;
507:
508: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
509: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '*****INPUT PARAMETERS*******');

Line 508: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

504: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
505: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_enter);
506: END IF;
507:
508: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
509: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '*****INPUT PARAMETERS*******');
510: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_ledger_id = '||p_ledger_id);
511: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_or_cust = '||p_vendor_or_cust);
512: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_or_cust_id = '||p_vendor_or_cust_id);

Line 509: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '*INPUT PARAMETERS***');

505: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_enter);
506: END IF;
507:
508: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
509: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '*****INPUT PARAMETERS*******');
510: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_ledger_id = '||p_ledger_id);
511: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_or_cust = '||p_vendor_or_cust);
512: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_or_cust_id = '||p_vendor_or_cust_id);
513: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_from_period = '||p_from_period);

Line 510: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_ledger_id = '||p_ledger_id);

506: END IF;
507:
508: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
509: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '*****INPUT PARAMETERS*******');
510: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_ledger_id = '||p_ledger_id);
511: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_or_cust = '||p_vendor_or_cust);
512: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_or_cust_id = '||p_vendor_or_cust_id);
513: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_from_period = '||p_from_period);
514: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_to_period = '||p_to_period);

Line 511: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_or_cust = '||p_vendor_or_cust);

507:
508: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
509: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '*****INPUT PARAMETERS*******');
510: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_ledger_id = '||p_ledger_id);
511: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_or_cust = '||p_vendor_or_cust);
512: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_or_cust_id = '||p_vendor_or_cust_id);
513: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_from_period = '||p_from_period);
514: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_to_period = '||p_to_period);
515: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '****************************');

Line 512: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_or_cust_id = '||p_vendor_or_cust_id);

508: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
509: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '*****INPUT PARAMETERS*******');
510: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_ledger_id = '||p_ledger_id);
511: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_or_cust = '||p_vendor_or_cust);
512: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_or_cust_id = '||p_vendor_or_cust_id);
513: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_from_period = '||p_from_period);
514: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_to_period = '||p_to_period);
515: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '****************************');
516: END IF;

Line 513: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_from_period = '||p_from_period);

509: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '*****INPUT PARAMETERS*******');
510: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_ledger_id = '||p_ledger_id);
511: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_or_cust = '||p_vendor_or_cust);
512: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_or_cust_id = '||p_vendor_or_cust_id);
513: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_from_period = '||p_from_period);
514: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_to_period = '||p_to_period);
515: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '****************************');
516: END IF;
517:

Line 514: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_to_period = '||p_to_period);

510: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_ledger_id = '||p_ledger_id);
511: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_or_cust = '||p_vendor_or_cust);
512: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_or_cust_id = '||p_vendor_or_cust_id);
513: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_from_period = '||p_from_period);
514: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_to_period = '||p_to_period);
515: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '****************************');
516: END IF;
517:
518: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 515: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '****************************');

511: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_or_cust = '||p_vendor_or_cust);
512: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_or_cust_id = '||p_vendor_or_cust_id);
513: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_from_period = '||p_from_period);
514: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_to_period = '||p_to_period);
515: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '****************************');
516: END IF;
517:
518: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
519: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Calling process_parameters');

Line 518: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

514: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_to_period = '||p_to_period);
515: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '****************************');
516: END IF;
517:
518: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
519: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Calling process_parameters');
520: END IF;
521:
522: IF (p_retcode = g_SUCCESS) THEN

Line 519: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Calling process_parameters');

515: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '****************************');
516: END IF;
517:
518: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
519: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Calling process_parameters');
520: END IF;
521:
522: IF (p_retcode = g_SUCCESS) THEN
523: process_parameters

Line 540: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

536: p_retcode => p_retcode
537: );
538: END IF;
539:
540: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
541: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Returned from process_parameters');
542: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_vendor_type = '||l_vendor_type);
543: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_elimination_id = '||l_elimination_id);
544: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_period_year = '||l_period_year);

Line 541: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Returned from process_parameters');

537: );
538: END IF;
539:
540: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
541: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Returned from process_parameters');
542: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_vendor_type = '||l_vendor_type);
543: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_elimination_id = '||l_elimination_id);
544: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_period_year = '||l_period_year);
545: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_from_period_num = '||l_from_period_num);

Line 542: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_vendor_type = '||l_vendor_type);

538: END IF;
539:
540: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
541: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Returned from process_parameters');
542: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_vendor_type = '||l_vendor_type);
543: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_elimination_id = '||l_elimination_id);
544: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_period_year = '||l_period_year);
545: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_from_period_num = '||l_from_period_num);
546: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_to_period_num = '||l_to_period_num);

Line 543: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_elimination_id = '||l_elimination_id);

539:
540: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
541: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Returned from process_parameters');
542: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_vendor_type = '||l_vendor_type);
543: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_elimination_id = '||l_elimination_id);
544: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_period_year = '||l_period_year);
545: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_from_period_num = '||l_from_period_num);
546: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_to_period_num = '||l_to_period_num);
547: END IF;

Line 544: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_period_year = '||l_period_year);

540: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
541: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Returned from process_parameters');
542: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_vendor_type = '||l_vendor_type);
543: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_elimination_id = '||l_elimination_id);
544: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_period_year = '||l_period_year);
545: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_from_period_num = '||l_from_period_num);
546: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_to_period_num = '||l_to_period_num);
547: END IF;
548:

Line 545: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_from_period_num = '||l_from_period_num);

541: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Returned from process_parameters');
542: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_vendor_type = '||l_vendor_type);
543: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_elimination_id = '||l_elimination_id);
544: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_period_year = '||l_period_year);
545: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_from_period_num = '||l_from_period_num);
546: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_to_period_num = '||l_to_period_num);
547: END IF;
548:
549: IF (p_retcode = g_SUCCESS) THEN

Line 546: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_to_period_num = '||l_to_period_num);

542: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_vendor_type = '||l_vendor_type);
543: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_elimination_id = '||l_elimination_id);
544: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_period_year = '||l_period_year);
545: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_from_period_num = '||l_from_period_num);
546: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_to_period_num = '||l_to_period_num);
547: END IF;
548:
549: IF (p_retcode = g_SUCCESS) THEN
550: BEGIN

Line 551: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

547: END IF;
548:
549: IF (p_retcode = g_SUCCESS) THEN
550: BEGIN
551: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
552: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Updating fv_facts_period_balances');
553: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_elimination_id = '||l_elimination_id);
554: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_vendor_type = '||l_vendor_type);
555: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_period_year = '||l_period_year);

Line 552: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Updating fv_facts_period_balances');

548:
549: IF (p_retcode = g_SUCCESS) THEN
550: BEGIN
551: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
552: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Updating fv_facts_period_balances');
553: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_elimination_id = '||l_elimination_id);
554: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_vendor_type = '||l_vendor_type);
555: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_period_year = '||l_period_year);
556: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_from_period_num = '||l_from_period_num);

Line 553: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_elimination_id = '||l_elimination_id);

549: IF (p_retcode = g_SUCCESS) THEN
550: BEGIN
551: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
552: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Updating fv_facts_period_balances');
553: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_elimination_id = '||l_elimination_id);
554: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_vendor_type = '||l_vendor_type);
555: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_period_year = '||l_period_year);
556: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_from_period_num = '||l_from_period_num);
557: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_to_period_num = '||l_to_period_num);

Line 554: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_vendor_type = '||l_vendor_type);

550: BEGIN
551: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
552: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Updating fv_facts_period_balances');
553: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_elimination_id = '||l_elimination_id);
554: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_vendor_type = '||l_vendor_type);
555: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_period_year = '||l_period_year);
556: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_from_period_num = '||l_from_period_num);
557: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_to_period_num = '||l_to_period_num);
558: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'g_set_of_books_id = '||g_set_of_books_id);

Line 555: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_period_year = '||l_period_year);

551: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
552: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Updating fv_facts_period_balances');
553: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_elimination_id = '||l_elimination_id);
554: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_vendor_type = '||l_vendor_type);
555: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_period_year = '||l_period_year);
556: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_from_period_num = '||l_from_period_num);
557: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_to_period_num = '||l_to_period_num);
558: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'g_set_of_books_id = '||g_set_of_books_id);
559: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_or_cust = '||p_vendor_or_cust);

Line 556: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_from_period_num = '||l_from_period_num);

552: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Updating fv_facts_period_balances');
553: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_elimination_id = '||l_elimination_id);
554: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_vendor_type = '||l_vendor_type);
555: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_period_year = '||l_period_year);
556: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_from_period_num = '||l_from_period_num);
557: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_to_period_num = '||l_to_period_num);
558: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'g_set_of_books_id = '||g_set_of_books_id);
559: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_or_cust = '||p_vendor_or_cust);
560: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_ledger_id = '||p_ledger_id);

Line 557: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_to_period_num = '||l_to_period_num);

553: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_elimination_id = '||l_elimination_id);
554: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_vendor_type = '||l_vendor_type);
555: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_period_year = '||l_period_year);
556: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_from_period_num = '||l_from_period_num);
557: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_to_period_num = '||l_to_period_num);
558: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'g_set_of_books_id = '||g_set_of_books_id);
559: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_or_cust = '||p_vendor_or_cust);
560: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_ledger_id = '||p_ledger_id);
561: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_or_cust_id = '||p_vendor_or_cust_id);

Line 558: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'g_set_of_books_id = '||g_set_of_books_id);

554: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_vendor_type = '||l_vendor_type);
555: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_period_year = '||l_period_year);
556: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_from_period_num = '||l_from_period_num);
557: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_to_period_num = '||l_to_period_num);
558: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'g_set_of_books_id = '||g_set_of_books_id);
559: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_or_cust = '||p_vendor_or_cust);
560: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_ledger_id = '||p_ledger_id);
561: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_or_cust_id = '||p_vendor_or_cust_id);
562: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'g_conc_program_name = '||g_conc_program_name);

Line 559: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_or_cust = '||p_vendor_or_cust);

555: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_period_year = '||l_period_year);
556: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_from_period_num = '||l_from_period_num);
557: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_to_period_num = '||l_to_period_num);
558: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'g_set_of_books_id = '||g_set_of_books_id);
559: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_or_cust = '||p_vendor_or_cust);
560: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_ledger_id = '||p_ledger_id);
561: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_or_cust_id = '||p_vendor_or_cust_id);
562: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'g_conc_program_name = '||g_conc_program_name);
563: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'g_user_id = '||g_user_id);

Line 560: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_ledger_id = '||p_ledger_id);

556: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_from_period_num = '||l_from_period_num);
557: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_to_period_num = '||l_to_period_num);
558: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'g_set_of_books_id = '||g_set_of_books_id);
559: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_or_cust = '||p_vendor_or_cust);
560: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_ledger_id = '||p_ledger_id);
561: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_or_cust_id = '||p_vendor_or_cust_id);
562: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'g_conc_program_name = '||g_conc_program_name);
563: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'g_user_id = '||g_user_id);
564: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'g_login_id = '||g_login_id);

Line 561: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_or_cust_id = '||p_vendor_or_cust_id);

557: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'l_to_period_num = '||l_to_period_num);
558: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'g_set_of_books_id = '||g_set_of_books_id);
559: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_or_cust = '||p_vendor_or_cust);
560: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_ledger_id = '||p_ledger_id);
561: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_or_cust_id = '||p_vendor_or_cust_id);
562: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'g_conc_program_name = '||g_conc_program_name);
563: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'g_user_id = '||g_user_id);
564: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'g_login_id = '||g_login_id);
565: END IF;

Line 562: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'g_conc_program_name = '||g_conc_program_name);

558: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'g_set_of_books_id = '||g_set_of_books_id);
559: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_or_cust = '||p_vendor_or_cust);
560: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_ledger_id = '||p_ledger_id);
561: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_or_cust_id = '||p_vendor_or_cust_id);
562: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'g_conc_program_name = '||g_conc_program_name);
563: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'g_user_id = '||g_user_id);
564: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'g_login_id = '||g_login_id);
565: END IF;
566:

Line 563: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'g_user_id = '||g_user_id);

559: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_or_cust = '||p_vendor_or_cust);
560: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_ledger_id = '||p_ledger_id);
561: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_or_cust_id = '||p_vendor_or_cust_id);
562: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'g_conc_program_name = '||g_conc_program_name);
563: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'g_user_id = '||g_user_id);
564: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'g_login_id = '||g_login_id);
565: END IF;
566:
567: FOR sob_rec IN (SELECT set_of_books_id

Line 564: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'g_login_id = '||g_login_id);

560: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_ledger_id = '||p_ledger_id);
561: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_vendor_or_cust_id = '||p_vendor_or_cust_id);
562: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'g_conc_program_name = '||g_conc_program_name);
563: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'g_user_id = '||g_user_id);
564: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'g_login_id = '||g_login_id);
565: END IF;
566:
567: FOR sob_rec IN (SELECT set_of_books_id
568: FROM fv_facts1_run

Line 587: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

583: l_rows := SQL%ROWCOUNT;
584: l_tot_rows := l_tot_rows + SQL%ROWCOUNT;
585:
586:
587: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
588: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,
589: 'Updated fv_facts1_line_balances');
590: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,l_rows||' rows updated.');
591: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'for set of books id: '|| sob_rec.set_of_books_id);

Line 588: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,

584: l_tot_rows := l_tot_rows + SQL%ROWCOUNT;
585:
586:
587: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
588: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,
589: 'Updated fv_facts1_line_balances');
590: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,l_rows||' rows updated.');
591: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'for set of books id: '|| sob_rec.set_of_books_id);
592: END IF;

Line 590: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,l_rows||' rows updated.');

586:
587: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
588: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,
589: 'Updated fv_facts1_line_balances');
590: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,l_rows||' rows updated.');
591: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'for set of books id: '|| sob_rec.set_of_books_id);
592: END IF;
593:
594:

Line 591: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'for set of books id: '|| sob_rec.set_of_books_id);

587: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
588: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,
589: 'Updated fv_facts1_line_balances');
590: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,l_rows||' rows updated.');
591: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'for set of books id: '|| sob_rec.set_of_books_id);
592: END IF;
593:
594:
595: END LOOP;

Line 602: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;

598: WHEN OTHERS THEN
599: p_retcode := g_FAILURE;
600: p_errbuf := SQLERRM;
601: l_location := l_module_name||'update_fv_facts1_line_balances';
602: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
603: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
604: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
605: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
606: END IF;

Line 603: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;

599: p_retcode := g_FAILURE;
600: p_errbuf := SQLERRM;
601: l_location := l_module_name||'update_fv_facts1_line_balances';
602: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
603: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
604: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
605: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
606: END IF;
607: END;

Line 604: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

600: p_errbuf := SQLERRM;
601: l_location := l_module_name||'update_fv_facts1_line_balances';
602: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
603: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
604: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
605: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
606: END IF;
607: END;
608: END IF;

Line 605: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');

601: l_location := l_module_name||'update_fv_facts1_line_balances';
602: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
603: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
604: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
605: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
606: END IF;
607: END;
608: END IF;
609:

Line 610: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

606: END IF;
607: END;
608: END IF;
609:
610: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
611: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '*****OUTPUT PARAMETERS******');
612: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_errbuf = '||p_errbuf);
613: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_retcode = '||p_retcode);
614: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '****************************');

Line 611: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '*OUTPUT PARAMETERS**');

607: END;
608: END IF;
609:
610: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
611: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '*****OUTPUT PARAMETERS******');
612: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_errbuf = '||p_errbuf);
613: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_retcode = '||p_retcode);
614: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '****************************');
615: END IF;

Line 612: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_errbuf = '||p_errbuf);

608: END IF;
609:
610: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
611: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '*****OUTPUT PARAMETERS******');
612: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_errbuf = '||p_errbuf);
613: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_retcode = '||p_retcode);
614: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '****************************');
615: END IF;
616:

Line 613: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_retcode = '||p_retcode);

609:
610: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
611: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '*****OUTPUT PARAMETERS******');
612: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_errbuf = '||p_errbuf);
613: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_retcode = '||p_retcode);
614: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '****************************');
615: END IF;
616:
617: fv_utility.log_mesg(fnd_log.level_statement, l_module_name, 'UPDATED '||l_tot_rows||' ROWS IN FV_FACTS1_LINE_BALANCES.');

Line 614: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '****************************');

610: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
611: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '*****OUTPUT PARAMETERS******');
612: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_errbuf = '||p_errbuf);
613: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_retcode = '||p_retcode);
614: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '****************************');
615: END IF;
616:
617: fv_utility.log_mesg(fnd_log.level_statement, l_module_name, 'UPDATED '||l_tot_rows||' ROWS IN FV_FACTS1_LINE_BALANCES.');
618:

Line 617: fv_utility.log_mesg(fnd_log.level_statement, l_module_name, 'UPDATED '||l_tot_rows||' ROWS IN FV_FACTS1_LINE_BALANCES.');

613: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_retcode = '||p_retcode);
614: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '****************************');
615: END IF;
616:
617: fv_utility.log_mesg(fnd_log.level_statement, l_module_name, 'UPDATED '||l_tot_rows||' ROWS IN FV_FACTS1_LINE_BALANCES.');
618:
619: l_tot_rows := 0;
620:
621:

Line 622: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

618:
619: l_tot_rows := 0;
620:
621:
622: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
623: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
624: END IF;
625: EXCEPTION
626: WHEN OTHERS THEN

Line 623: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');

619: l_tot_rows := 0;
620:
621:
622: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
623: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
624: END IF;
625: EXCEPTION
626: WHEN OTHERS THEN
627: p_retcode := g_FAILURE;

Line 630: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;

626: WHEN OTHERS THEN
627: p_retcode := g_FAILURE;
628: p_errbuf := SQLERRM;
629: l_location := l_module_name||'.final_exception';
630: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
631: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
632: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
633: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
634: END IF;

Line 631: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;

627: p_retcode := g_FAILURE;
628: p_errbuf := SQLERRM;
629: l_location := l_module_name||'.final_exception';
630: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
631: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
632: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
633: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
634: END IF;
635: ROLLBACK;

Line 632: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

628: p_errbuf := SQLERRM;
629: l_location := l_module_name||'.final_exception';
630: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
631: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
632: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
633: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
634: END IF;
635: ROLLBACK;
636: END;

Line 633: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');

629: l_location := l_module_name||'.final_exception';
630: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
631: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
632: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
633: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_exit||'('||p_retcode||')');
634: END IF;
635: ROLLBACK;
636: END;
637: