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.PA_SUMMARIZE_ACTUAL_UTIL_PVT dependencies on PA_DEBUG

Line 49: l_debug varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

45: l_program_id NUMBER(15) := pa_rep_util_glob.G_who_columns.G_program_id;
46: l_program_application_id NUMBER(15) := pa_rep_util_glob.G_who_columns.G_program_application_id;
47: l_creation_date DATE := pa_rep_util_glob.G_who_columns.G_creation_date;
48: l_program_update_date DATE := pa_rep_util_glob.G_who_columns.G_last_update_date;
49: l_debug varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
50:
51: -------------------------------------------------------
52:
53: PROCEDURE insert_act_into_tmp_table

Line 56: PA_DEBUG.Set_Curr_Function( p_function => 'insert_act_into_tmp_table');

52:
53: PROCEDURE insert_act_into_tmp_table
54: IS
55: BEGIN
56: PA_DEBUG.Set_Curr_Function( p_function => 'insert_act_into_tmp_table');
57:
58: IF l_debug ='Y'THEN -- bug 2674619
59: PA_DEBUG.g_err_stage := '205: Before inserting recs into Temp Table';
60: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);

Line 59: PA_DEBUG.g_err_stage := '205: Before inserting recs into Temp Table';

55: BEGIN
56: PA_DEBUG.Set_Curr_Function( p_function => 'insert_act_into_tmp_table');
57:
58: IF l_debug ='Y'THEN -- bug 2674619
59: PA_DEBUG.g_err_stage := '205: Before inserting recs into Temp Table';
60: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
61: END IF;
62:
63:

Line 60: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);

56: PA_DEBUG.Set_Curr_Function( p_function => 'insert_act_into_tmp_table');
57:
58: IF l_debug ='Y'THEN -- bug 2674619
59: PA_DEBUG.g_err_stage := '205: Before inserting recs into Temp Table';
60: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
61: END IF;
62:
63:
64: --

Line 140: PA_DEBUG.g_err_stage := '210: After inserting recs into Temp Table';

136: --
137:
138:
139: IF l_debug ='Y'THEN -- bug 2674619
140: PA_DEBUG.g_err_stage := '210: After inserting recs into Temp Table';
141: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
142: END IF;
143: PA_DEBUG.Reset_Curr_Function;
144: EXCEPTION

Line 141: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);

137:
138:
139: IF l_debug ='Y'THEN -- bug 2674619
140: PA_DEBUG.g_err_stage := '210: After inserting recs into Temp Table';
141: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
142: END IF;
143: PA_DEBUG.Reset_Curr_Function;
144: EXCEPTION
145: WHEN OTHERS THEN

Line 143: PA_DEBUG.Reset_Curr_Function;

139: IF l_debug ='Y'THEN -- bug 2674619
140: PA_DEBUG.g_err_stage := '210: After inserting recs into Temp Table';
141: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
142: END IF;
143: PA_DEBUG.Reset_Curr_Function;
144: EXCEPTION
145: WHEN OTHERS THEN
146: RAISE;
147: END insert_act_into_tmp_table;

Line 159: PA_DEBUG.Set_Curr_Function( p_function => 'Summarize_Actual_Util');

155: l_records_updated PLS_INTEGER;
156: l_capacity_summarized NUMBER :=0;
157: BEGIN
158:
159: PA_DEBUG.Set_Curr_Function( p_function => 'Summarize_Actual_Util');
160:
161: IF (l_pa_period_flag = 'N') AND
162: (l_gl_period_flag = 'N') AND
163: (l_ge_period_flag = 'N') THEN

Line 167: PA_DEBUG.Reset_Curr_Function;

163: (l_ge_period_flag = 'N') THEN
164: /*
165: * None of the options are selected
166: */
167: PA_DEBUG.Reset_Curr_Function;
168: RETURN;
169: END IF;
170:
171: IF l_debug ='Y'THEN -- bug 2674619

Line 172: PA_DEBUG.g_err_stage := '10 : L_AC_START_DATE '||l_ac_start_date;

168: RETURN;
169: END IF;
170:
171: IF l_debug ='Y'THEN -- bug 2674619
172: PA_DEBUG.g_err_stage := '10 : L_AC_START_DATE '||l_ac_start_date;
173: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
174: PA_DEBUG.g_err_stage := '20 : L_AC_END_DATE '||l_ac_end_date;
175: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
176:

Line 173: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);

169: END IF;
170:
171: IF l_debug ='Y'THEN -- bug 2674619
172: PA_DEBUG.g_err_stage := '10 : L_AC_START_DATE '||l_ac_start_date;
173: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
174: PA_DEBUG.g_err_stage := '20 : L_AC_END_DATE '||l_ac_end_date;
175: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
176:
177: PA_DEBUG.g_err_stage := '100 : After checking the flags ';

Line 174: PA_DEBUG.g_err_stage := '20 : L_AC_END_DATE '||l_ac_end_date;

170:
171: IF l_debug ='Y'THEN -- bug 2674619
172: PA_DEBUG.g_err_stage := '10 : L_AC_START_DATE '||l_ac_start_date;
173: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
174: PA_DEBUG.g_err_stage := '20 : L_AC_END_DATE '||l_ac_end_date;
175: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
176:
177: PA_DEBUG.g_err_stage := '100 : After checking the flags ';
178: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);

Line 175: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);

171: IF l_debug ='Y'THEN -- bug 2674619
172: PA_DEBUG.g_err_stage := '10 : L_AC_START_DATE '||l_ac_start_date;
173: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
174: PA_DEBUG.g_err_stage := '20 : L_AC_END_DATE '||l_ac_end_date;
175: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
176:
177: PA_DEBUG.g_err_stage := '100 : After checking the flags ';
178: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
179: PA_DEBUG.g_err_stage := '110 : L_PA_PERIOD_FLAG '||l_pa_period_flag;

Line 177: PA_DEBUG.g_err_stage := '100 : After checking the flags ';

173: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
174: PA_DEBUG.g_err_stage := '20 : L_AC_END_DATE '||l_ac_end_date;
175: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
176:
177: PA_DEBUG.g_err_stage := '100 : After checking the flags ';
178: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
179: PA_DEBUG.g_err_stage := '110 : L_PA_PERIOD_FLAG '||l_pa_period_flag;
180: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
181: PA_DEBUG.g_err_stage := '120 : L_GL_PERIOD_FLAG '||l_gl_period_flag;

Line 178: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);

174: PA_DEBUG.g_err_stage := '20 : L_AC_END_DATE '||l_ac_end_date;
175: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
176:
177: PA_DEBUG.g_err_stage := '100 : After checking the flags ';
178: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
179: PA_DEBUG.g_err_stage := '110 : L_PA_PERIOD_FLAG '||l_pa_period_flag;
180: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
181: PA_DEBUG.g_err_stage := '120 : L_GL_PERIOD_FLAG '||l_gl_period_flag;
182: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);

Line 179: PA_DEBUG.g_err_stage := '110 : L_PA_PERIOD_FLAG '||l_pa_period_flag;

175: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
176:
177: PA_DEBUG.g_err_stage := '100 : After checking the flags ';
178: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
179: PA_DEBUG.g_err_stage := '110 : L_PA_PERIOD_FLAG '||l_pa_period_flag;
180: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
181: PA_DEBUG.g_err_stage := '120 : L_GL_PERIOD_FLAG '||l_gl_period_flag;
182: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
183: PA_DEBUG.g_err_stage := '130 : L_GE_PERIOD_FLAG '||l_ge_period_flag;

Line 180: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);

176:
177: PA_DEBUG.g_err_stage := '100 : After checking the flags ';
178: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
179: PA_DEBUG.g_err_stage := '110 : L_PA_PERIOD_FLAG '||l_pa_period_flag;
180: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
181: PA_DEBUG.g_err_stage := '120 : L_GL_PERIOD_FLAG '||l_gl_period_flag;
182: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
183: PA_DEBUG.g_err_stage := '130 : L_GE_PERIOD_FLAG '||l_ge_period_flag;
184: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);

Line 181: PA_DEBUG.g_err_stage := '120 : L_GL_PERIOD_FLAG '||l_gl_period_flag;

177: PA_DEBUG.g_err_stage := '100 : After checking the flags ';
178: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
179: PA_DEBUG.g_err_stage := '110 : L_PA_PERIOD_FLAG '||l_pa_period_flag;
180: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
181: PA_DEBUG.g_err_stage := '120 : L_GL_PERIOD_FLAG '||l_gl_period_flag;
182: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
183: PA_DEBUG.g_err_stage := '130 : L_GE_PERIOD_FLAG '||l_ge_period_flag;
184: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
185: END IF;

Line 182: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);

178: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
179: PA_DEBUG.g_err_stage := '110 : L_PA_PERIOD_FLAG '||l_pa_period_flag;
180: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
181: PA_DEBUG.g_err_stage := '120 : L_GL_PERIOD_FLAG '||l_gl_period_flag;
182: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
183: PA_DEBUG.g_err_stage := '130 : L_GE_PERIOD_FLAG '||l_ge_period_flag;
184: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
185: END IF;
186:

Line 183: PA_DEBUG.g_err_stage := '130 : L_GE_PERIOD_FLAG '||l_ge_period_flag;

179: PA_DEBUG.g_err_stage := '110 : L_PA_PERIOD_FLAG '||l_pa_period_flag;
180: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
181: PA_DEBUG.g_err_stage := '120 : L_GL_PERIOD_FLAG '||l_gl_period_flag;
182: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
183: PA_DEBUG.g_err_stage := '130 : L_GE_PERIOD_FLAG '||l_ge_period_flag;
184: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
185: END IF;
186:
187: /*

Line 184: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);

180: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
181: PA_DEBUG.g_err_stage := '120 : L_GL_PERIOD_FLAG '||l_gl_period_flag;
182: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
183: PA_DEBUG.g_err_stage := '130 : L_GE_PERIOD_FLAG '||l_ge_period_flag;
184: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
185: END IF;
186:
187: /*
188: * Calling a procedure for populating the initial temporary workspace

Line 195: PA_DEBUG.g_err_stage := '140 : Calling PAGLGE';

191: IF (l_pa_period_flag = 'Y') THEN
192: IF (l_gl_period_flag = 'Y') THEN
193: IF (l_ge_period_flag = 'Y') THEN
194: IF l_debug ='Y'THEN -- bug 2674619
195: PA_DEBUG.g_err_stage := '140 : Calling PAGLGE';
196: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
197: END IF;
198: insert_act_into_tmp_PAGLGE;
199: ELSE

Line 196: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);

192: IF (l_gl_period_flag = 'Y') THEN
193: IF (l_ge_period_flag = 'Y') THEN
194: IF l_debug ='Y'THEN -- bug 2674619
195: PA_DEBUG.g_err_stage := '140 : Calling PAGLGE';
196: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
197: END IF;
198: insert_act_into_tmp_PAGLGE;
199: ELSE
200: IF l_debug ='Y'THEN -- bug 2674619

Line 201: PA_DEBUG.g_err_stage := '150 : Calling PAGL';

197: END IF;
198: insert_act_into_tmp_PAGLGE;
199: ELSE
200: IF l_debug ='Y'THEN -- bug 2674619
201: PA_DEBUG.g_err_stage := '150 : Calling PAGL';
202: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
203: END IF;
204: insert_act_into_tmp_PAGL;
205: END IF;

Line 202: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);

198: insert_act_into_tmp_PAGLGE;
199: ELSE
200: IF l_debug ='Y'THEN -- bug 2674619
201: PA_DEBUG.g_err_stage := '150 : Calling PAGL';
202: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
203: END IF;
204: insert_act_into_tmp_PAGL;
205: END IF;
206: ELSIF (l_ge_period_flag = 'Y') THEN

Line 208: PA_DEBUG.g_err_stage := '160 : Calling PAGE';

204: insert_act_into_tmp_PAGL;
205: END IF;
206: ELSIF (l_ge_period_flag = 'Y') THEN
207: IF l_debug ='Y'THEN -- bug 2674619
208: PA_DEBUG.g_err_stage := '160 : Calling PAGE';
209: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
210: END IF;
211: insert_act_into_tmp_PAGE;
212: ELSE

Line 209: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);

205: END IF;
206: ELSIF (l_ge_period_flag = 'Y') THEN
207: IF l_debug ='Y'THEN -- bug 2674619
208: PA_DEBUG.g_err_stage := '160 : Calling PAGE';
209: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
210: END IF;
211: insert_act_into_tmp_PAGE;
212: ELSE
213: insert_act_into_tmp_PA;

Line 215: PA_DEBUG.g_err_stage := '170 : Calling PA';

211: insert_act_into_tmp_PAGE;
212: ELSE
213: insert_act_into_tmp_PA;
214: IF l_debug ='Y'THEN -- bug 2674619
215: PA_DEBUG.g_err_stage := '170 : Calling PA';
216: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
217: END IF;
218: END IF;
219: ELSIF (l_gl_period_flag = 'Y') THEN

Line 216: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);

212: ELSE
213: insert_act_into_tmp_PA;
214: IF l_debug ='Y'THEN -- bug 2674619
215: PA_DEBUG.g_err_stage := '170 : Calling PA';
216: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
217: END IF;
218: END IF;
219: ELSIF (l_gl_period_flag = 'Y') THEN
220: IF (l_ge_period_flag = 'Y') THEN

Line 222: PA_DEBUG.g_err_stage := '180 : Calling GLGE';

218: END IF;
219: ELSIF (l_gl_period_flag = 'Y') THEN
220: IF (l_ge_period_flag = 'Y') THEN
221: IF l_debug ='Y'THEN -- bug 2674619
222: PA_DEBUG.g_err_stage := '180 : Calling GLGE';
223: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
224: END IF;
225: insert_act_into_tmp_GLGE;
226: ELSE

Line 223: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);

219: ELSIF (l_gl_period_flag = 'Y') THEN
220: IF (l_ge_period_flag = 'Y') THEN
221: IF l_debug ='Y'THEN -- bug 2674619
222: PA_DEBUG.g_err_stage := '180 : Calling GLGE';
223: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
224: END IF;
225: insert_act_into_tmp_GLGE;
226: ELSE
227: IF l_debug ='Y'THEN -- bug 2674619

Line 228: PA_DEBUG.g_err_stage := '190 : Calling GL';

224: END IF;
225: insert_act_into_tmp_GLGE;
226: ELSE
227: IF l_debug ='Y'THEN -- bug 2674619
228: PA_DEBUG.g_err_stage := '190 : Calling GL';
229: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
230: END IF;
231: insert_act_into_tmp_GL;
232: END IF;

Line 229: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);

225: insert_act_into_tmp_GLGE;
226: ELSE
227: IF l_debug ='Y'THEN -- bug 2674619
228: PA_DEBUG.g_err_stage := '190 : Calling GL';
229: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
230: END IF;
231: insert_act_into_tmp_GL;
232: END IF;
233: ELSE

Line 235: PA_DEBUG.g_err_stage := '200 : Calling GE';

231: insert_act_into_tmp_GL;
232: END IF;
233: ELSE
234: IF l_debug ='Y'THEN -- bug 2674619
235: PA_DEBUG.g_err_stage := '200 : Calling GE';
236: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
237: END IF;
238: insert_act_into_tmp_GE;
239: END IF;

Line 236: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);

232: END IF;
233: ELSE
234: IF l_debug ='Y'THEN -- bug 2674619
235: PA_DEBUG.g_err_stage := '200 : Calling GE';
236: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
237: END IF;
238: insert_act_into_tmp_GE;
239: END IF;
240: /*

Line 264: PA_DEBUG.g_err_stage := '220 : After Calling the INSERT_PROC_[PA][GL][GE]';

260: * Check if ANY records have been inserted into the temporary table.
261: * If NO records are inserted, getout of the loop.
262: */
263: IF l_debug ='Y'THEN -- bug 2674619
264: PA_DEBUG.g_err_stage := '220 : After Calling the INSERT_PROC_[PA][GL][GE]';
265: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
266: END IF;
267:
268: l_records_inserted := SQL%ROWCOUNT;

Line 265: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);

261: * If NO records are inserted, getout of the loop.
262: */
263: IF l_debug ='Y'THEN -- bug 2674619
264: PA_DEBUG.g_err_stage := '220 : After Calling the INSERT_PROC_[PA][GL][GE]';
265: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
266: END IF;
267:
268: l_records_inserted := SQL%ROWCOUNT;
269:

Line 271: PA_DEBUG.g_err_stage := '225 : Records Inserted in Temp tab : '||l_records_inserted;

267:
268: l_records_inserted := SQL%ROWCOUNT;
269:
270: IF l_debug ='Y'THEN -- bug 2674619
271: PA_DEBUG.g_err_stage := '225 : Records Inserted in Temp tab : '||l_records_inserted;
272: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
273:
274: PA_DEBUG.G_Err_Stage := '753 : l_capacity_summarized: ' || l_capacity_summarized;
275: PA_DEBUG.Log_Message(p_message => pa_debug.G_Err_Stage);

Line 272: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);

268: l_records_inserted := SQL%ROWCOUNT;
269:
270: IF l_debug ='Y'THEN -- bug 2674619
271: PA_DEBUG.g_err_stage := '225 : Records Inserted in Temp tab : '||l_records_inserted;
272: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
273:
274: PA_DEBUG.G_Err_Stage := '753 : l_capacity_summarized: ' || l_capacity_summarized;
275: PA_DEBUG.Log_Message(p_message => pa_debug.G_Err_Stage);
276: END IF;

Line 274: PA_DEBUG.G_Err_Stage := '753 : l_capacity_summarized: ' || l_capacity_summarized;

270: IF l_debug ='Y'THEN -- bug 2674619
271: PA_DEBUG.g_err_stage := '225 : Records Inserted in Temp tab : '||l_records_inserted;
272: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
273:
274: PA_DEBUG.G_Err_Stage := '753 : l_capacity_summarized: ' || l_capacity_summarized;
275: PA_DEBUG.Log_Message(p_message => pa_debug.G_Err_Stage);
276: END IF;
277:
278: IF (l_records_inserted = 0 AND l_capacity_summarized = 1) THEN

Line 275: PA_DEBUG.Log_Message(p_message => pa_debug.G_Err_Stage);

271: PA_DEBUG.g_err_stage := '225 : Records Inserted in Temp tab : '||l_records_inserted;
272: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
273:
274: PA_DEBUG.G_Err_Stage := '753 : l_capacity_summarized: ' || l_capacity_summarized;
275: PA_DEBUG.Log_Message(p_message => pa_debug.G_Err_Stage);
276: END IF;
277:
278: IF (l_records_inserted = 0 AND l_capacity_summarized = 1) THEN
279: IF l_debug ='Y'THEN -- bug 2674619

Line 280: PA_DEBUG.G_Err_Stage := '757 : EXITING since l_records_inserted = 0 AND l_capacity_summarized = 1';

276: END IF;
277:
278: IF (l_records_inserted = 0 AND l_capacity_summarized = 1) THEN
279: IF l_debug ='Y'THEN -- bug 2674619
280: PA_DEBUG.G_Err_Stage := '757 : EXITING since l_records_inserted = 0 AND l_capacity_summarized = 1';
281: PA_DEBUG.Log_Message(p_message => pa_debug.G_Err_Stage);
282: END IF;
283: EXIT;
284: END IF;

Line 281: PA_DEBUG.Log_Message(p_message => pa_debug.G_Err_Stage);

277:
278: IF (l_records_inserted = 0 AND l_capacity_summarized = 1) THEN
279: IF l_debug ='Y'THEN -- bug 2674619
280: PA_DEBUG.G_Err_Stage := '757 : EXITING since l_records_inserted = 0 AND l_capacity_summarized = 1';
281: PA_DEBUG.Log_Message(p_message => pa_debug.G_Err_Stage);
282: END IF;
283: EXIT;
284: END IF;
285:

Line 294: PA_DEBUG.g_err_stage := '250 : Before Updating PA_CDL to UTIL_SUMM_FLAG to S';

290: * for which updation went thro' fine.
291: */
292:
293: IF l_debug ='Y'THEN -- bug 2674619
294: PA_DEBUG.g_err_stage := '250 : Before Updating PA_CDL to UTIL_SUMM_FLAG to S';
295: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
296: END IF;
297:
298: UPDATE pa_cost_distribution_lines_all

Line 295: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);

291: */
292:
293: IF l_debug ='Y'THEN -- bug 2674619
294: PA_DEBUG.g_err_stage := '250 : Before Updating PA_CDL to UTIL_SUMM_FLAG to S';
295: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
296: END IF;
297:
298: UPDATE pa_cost_distribution_lines_all
299: SET util_summarized_flag = 'S'

Line 323: PA_DEBUG.g_err_stage := '300 : After Updating PA_CDL to UTIL_SUMM_FLAG to S';

319: * records SHOULD processed and hence to be considered as
320: * NOT deleted.
321: */
322: IF l_debug ='Y'THEN -- bug 2674619
323: PA_DEBUG.g_err_stage := '300 : After Updating PA_CDL to UTIL_SUMM_FLAG to S';
324: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
325: PA_DEBUG.g_err_stage := '325 : Records Updated in PA_CDL : '||l_records_updated;
326: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
327: END IF;

Line 324: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);

320: * NOT deleted.
321: */
322: IF l_debug ='Y'THEN -- bug 2674619
323: PA_DEBUG.g_err_stage := '300 : After Updating PA_CDL to UTIL_SUMM_FLAG to S';
324: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
325: PA_DEBUG.g_err_stage := '325 : Records Updated in PA_CDL : '||l_records_updated;
326: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
327: END IF;
328:

Line 325: PA_DEBUG.g_err_stage := '325 : Records Updated in PA_CDL : '||l_records_updated;

321: */
322: IF l_debug ='Y'THEN -- bug 2674619
323: PA_DEBUG.g_err_stage := '300 : After Updating PA_CDL to UTIL_SUMM_FLAG to S';
324: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
325: PA_DEBUG.g_err_stage := '325 : Records Updated in PA_CDL : '||l_records_updated;
326: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
327: END IF;
328:
329: l_process_method := 'A';

Line 326: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);

322: IF l_debug ='Y'THEN -- bug 2674619
323: PA_DEBUG.g_err_stage := '300 : After Updating PA_CDL to UTIL_SUMM_FLAG to S';
324: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
325: PA_DEBUG.g_err_stage := '325 : Records Updated in PA_CDL : '||l_records_updated;
326: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
327: END IF;
328:
329: l_process_method := 'A';
330: IF (l_records_updated < l_records_inserted AND l_cdl_rowid_tab.COUNT > 0 ) THEN /* Added second condition 2084888 */

Line 343: PA_DEBUG.g_err_stage := '350: Process Method : '||l_process_method;

339: */
340: l_cdl_rowid_tab.DELETE;
341:
342: IF l_debug ='Y'THEN -- bug 2674619
343: PA_DEBUG.g_err_stage := '350: Process Method : '||l_process_method;
344: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
345: END IF;
346:
347: /*

Line 344: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);

340: l_cdl_rowid_tab.DELETE;
341:
342: IF l_debug ='Y'THEN -- bug 2674619
343: PA_DEBUG.g_err_stage := '350: Process Method : '||l_process_method;
344: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
345: END IF;
346:
347: /*
348: * Call Package PA_REP_UTILS_SUMM_PKG.populate_summ_entity to Summarize

Line 352: PA_DEBUG.g_err_stage := '400: Before calling PA_REP_UTILS_SUMM_PKG';

348: * Call Package PA_REP_UTILS_SUMM_PKG.populate_summ_entity to Summarize
349: Records and Populate the Objects and Balances
350: */
351: IF l_debug ='Y'THEN -- bug 2674619
352: PA_DEBUG.g_err_stage := '400: Before calling PA_REP_UTILS_SUMM_PKG';
353: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
354: END IF;
355:
356: PA_REP_UTILS_SUMM_PKG.populate_summ_entity( P_Balance_Type_Code => l_bal_type_actual

Line 353: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);

349: Records and Populate the Objects and Balances
350: */
351: IF l_debug ='Y'THEN -- bug 2674619
352: PA_DEBUG.g_err_stage := '400: Before calling PA_REP_UTILS_SUMM_PKG';
353: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
354: END IF;
355:
356: PA_REP_UTILS_SUMM_PKG.populate_summ_entity( P_Balance_Type_Code => l_bal_type_actual
357: ,P_process_method => l_process_method

Line 368: PA_DEBUG.g_err_stage := '450: After calling PA_REP_UTILS_SUMM_PKG';

364: * If process_method is 'A' (All), update all records in cdl with
365: * util_summarized_flag = 'S' to NULL.
366: */
367: IF l_debug ='Y'THEN -- bug 2674619
368: PA_DEBUG.g_err_stage := '450: After calling PA_REP_UTILS_SUMM_PKG';
369: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
370: END IF;
371:
372: IF l_process_method = 'F' THEN

Line 369: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);

365: * util_summarized_flag = 'S' to NULL.
366: */
367: IF l_debug ='Y'THEN -- bug 2674619
368: PA_DEBUG.g_err_stage := '450: After calling PA_REP_UTILS_SUMM_PKG';
369: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
370: END IF;
371:
372: IF l_process_method = 'F' THEN
373: UPDATE pa_cost_distribution_lines_all

Line 410: PA_DEBUG.g_err_stage := '500: After updating PA_CDL.UTIL_SUMM_FLAG to Y';

406: WHERE row_id IN (SELECT row_id FROM pa_rep_util_summ0_tmp);
407:
408:
409: IF l_debug ='Y'THEN -- bug 2674619
410: PA_DEBUG.g_err_stage := '500: After updating PA_CDL.UTIL_SUMM_FLAG to Y';
411: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
412: END IF;
413:
414: COMMIT;

Line 411: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);

407:
408:
409: IF l_debug ='Y'THEN -- bug 2674619
410: PA_DEBUG.g_err_stage := '500: After updating PA_CDL.UTIL_SUMM_FLAG to Y';
411: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
412: END IF;
413:
414: COMMIT;
415: END LOOP;

Line 419: PA_DEBUG.g_err_stage := '510: Before calling Rollup if rollup method is R';

415: END LOOP;
416: IF pa_rep_util_glob.G_input_parameters.G_org_rollup_method = 'R' THEN
417:
418: IF l_debug ='Y'THEN -- bug 2674619
419: PA_DEBUG.g_err_stage := '510: Before calling Rollup if rollup method is R';
420: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
421: END IF;
422:
423: PA_SUMMARIZE_ORG_ROLLUP_PVT.refresh_org_hierarchy_rollup(l_bal_type_actual);

Line 420: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);

416: IF pa_rep_util_glob.G_input_parameters.G_org_rollup_method = 'R' THEN
417:
418: IF l_debug ='Y'THEN -- bug 2674619
419: PA_DEBUG.g_err_stage := '510: Before calling Rollup if rollup method is R';
420: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
421: END IF;
422:
423: PA_SUMMARIZE_ORG_ROLLUP_PVT.refresh_org_hierarchy_rollup(l_bal_type_actual);
424:

Line 426: PA_DEBUG.g_err_stage := '520: After calling Org Hierarchy Rollup';

422:
423: PA_SUMMARIZE_ORG_ROLLUP_PVT.refresh_org_hierarchy_rollup(l_bal_type_actual);
424:
425: IF l_debug ='Y'THEN -- bug 2674619
426: PA_DEBUG.g_err_stage := '520: After calling Org Hierarchy Rollup';
427: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
428: END IF;
429: END IF;
430:

Line 427: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);

423: PA_SUMMARIZE_ORG_ROLLUP_PVT.refresh_org_hierarchy_rollup(l_bal_type_actual);
424:
425: IF l_debug ='Y'THEN -- bug 2674619
426: PA_DEBUG.g_err_stage := '520: After calling Org Hierarchy Rollup';
427: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
428: END IF;
429: END IF;
430:
431:

Line 433: PA_DEBUG.g_err_stage := '550: Before updating PA_UTILIZATION_OPTIONS_ALL';

429: END IF;
430:
431:
432: IF l_debug ='Y'THEN -- bug 2674619
433: PA_DEBUG.g_err_stage := '550: Before updating PA_UTILIZATION_OPTIONS_ALL';
434: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
435: END IF;
436:
437: /*

Line 434: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);

430:
431:
432: IF l_debug ='Y'THEN -- bug 2674619
433: PA_DEBUG.g_err_stage := '550: Before updating PA_UTILIZATION_OPTIONS_ALL';
434: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
435: END IF;
436:
437: /*
438: * Update pa_utilization_options with the dates for which

Line 457: PA_DEBUG.g_err_stage := '600: After updating PA_UTILIZATION_OPTIONS_ALL';

453: , actuals_last_run_date = sysdate
454: WHERE NVL(org_id,-99) = l_org_id;
455:
456: IF l_debug ='Y'THEN -- bug 2674619
457: PA_DEBUG.g_err_stage := '600: After updating PA_UTILIZATION_OPTIONS_ALL';
458: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
459: PA_DEBUG.g_err_stage := '700: Exiting the Package PA_SUMMARIZE_ACTUAL_UTIL_PVT';
460: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
461: END IF;

Line 458: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);

454: WHERE NVL(org_id,-99) = l_org_id;
455:
456: IF l_debug ='Y'THEN -- bug 2674619
457: PA_DEBUG.g_err_stage := '600: After updating PA_UTILIZATION_OPTIONS_ALL';
458: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
459: PA_DEBUG.g_err_stage := '700: Exiting the Package PA_SUMMARIZE_ACTUAL_UTIL_PVT';
460: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
461: END IF;
462: PA_DEBUG.Reset_Curr_Function;

Line 459: PA_DEBUG.g_err_stage := '700: Exiting the Package PA_SUMMARIZE_ACTUAL_UTIL_PVT';

455:
456: IF l_debug ='Y'THEN -- bug 2674619
457: PA_DEBUG.g_err_stage := '600: After updating PA_UTILIZATION_OPTIONS_ALL';
458: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
459: PA_DEBUG.g_err_stage := '700: Exiting the Package PA_SUMMARIZE_ACTUAL_UTIL_PVT';
460: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
461: END IF;
462: PA_DEBUG.Reset_Curr_Function;
463: COMMIT;

Line 460: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);

456: IF l_debug ='Y'THEN -- bug 2674619
457: PA_DEBUG.g_err_stage := '600: After updating PA_UTILIZATION_OPTIONS_ALL';
458: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
459: PA_DEBUG.g_err_stage := '700: Exiting the Package PA_SUMMARIZE_ACTUAL_UTIL_PVT';
460: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
461: END IF;
462: PA_DEBUG.Reset_Curr_Function;
463: COMMIT;
464: EXCEPTION

Line 462: PA_DEBUG.Reset_Curr_Function;

458: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
459: PA_DEBUG.g_err_stage := '700: Exiting the Package PA_SUMMARIZE_ACTUAL_UTIL_PVT';
460: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
461: END IF;
462: PA_DEBUG.Reset_Curr_Function;
463: COMMIT;
464: EXCEPTION
465: WHEN OTHERS THEN
466: IF l_debug ='Y'THEN -- bug 2674619

Line 467: PA_DEBUG.Log_Message(PA_DEBUG.g_err_stack);

463: COMMIT;
464: EXCEPTION
465: WHEN OTHERS THEN
466: IF l_debug ='Y'THEN -- bug 2674619
467: PA_DEBUG.Log_Message(PA_DEBUG.g_err_stack);
468: PA_DEBUG.Log_Message( SQLERRM);
469: END IF;
470: RAISE;
471:

Line 468: PA_DEBUG.Log_Message( SQLERRM);

464: EXCEPTION
465: WHEN OTHERS THEN
466: IF l_debug ='Y'THEN -- bug 2674619
467: PA_DEBUG.Log_Message(PA_DEBUG.g_err_stack);
468: PA_DEBUG.Log_Message( SQLERRM);
469: END IF;
470: RAISE;
471:
472: END summarize_actual_util;

Line 478: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_act_into_tmp_PA');

474: -------------------------------------------------------
475: PROCEDURE insert_act_into_tmp_PA
476: IS
477: BEGIN
478: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_act_into_tmp_PA');
479: IF l_debug ='Y'THEN -- bug 2674619
480: PA_DEBUG.g_err_stage := '205: Before inserting recs into Temp Table';
481: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
482: END IF;

Line 480: PA_DEBUG.g_err_stage := '205: Before inserting recs into Temp Table';

476: IS
477: BEGIN
478: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_act_into_tmp_PA');
479: IF l_debug ='Y'THEN -- bug 2674619
480: PA_DEBUG.g_err_stage := '205: Before inserting recs into Temp Table';
481: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
482: END IF;
483:
484: INSERT

Line 481: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);

477: BEGIN
478: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_act_into_tmp_PA');
479: IF l_debug ='Y'THEN -- bug 2674619
480: PA_DEBUG.g_err_stage := '205: Before inserting recs into Temp Table';
481: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
482: END IF;
483:
484: INSERT
485: INTO pa_rep_util_summ00_tmp(

Line 575: PA_DEBUG.g_err_stage := '210: After inserting recs into Temp Table';

571: AND cdl.util_summarized_flag = 'N'
572: AND NVL(cdl.org_id,-99) = l_org_id;
573: commit;
574: IF l_debug ='Y'THEN -- bug 2674619
575: PA_DEBUG.g_err_stage := '210: After inserting recs into Temp Table';
576: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
577: END IF;
578:
579: PA_DEBUG.Reset_Curr_Function;

Line 576: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);

572: AND NVL(cdl.org_id,-99) = l_org_id;
573: commit;
574: IF l_debug ='Y'THEN -- bug 2674619
575: PA_DEBUG.g_err_stage := '210: After inserting recs into Temp Table';
576: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
577: END IF;
578:
579: PA_DEBUG.Reset_Curr_Function;
580: EXCEPTION

Line 579: PA_DEBUG.Reset_Curr_Function;

575: PA_DEBUG.g_err_stage := '210: After inserting recs into Temp Table';
576: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
577: END IF;
578:
579: PA_DEBUG.Reset_Curr_Function;
580: EXCEPTION
581: WHEN OTHERS THEN
582: RAISE;
583:

Line 589: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_act_into_tmp_GL');

585: -------------------------------------------------------
586: PROCEDURE insert_act_into_tmp_GL
587: IS
588: BEGIN
589: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_act_into_tmp_GL');
590: IF l_debug ='Y'THEN -- bug 2674619
591: PA_DEBUG.g_err_stage := '205: Before inserting recs into Temp Table';
592: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
593: END IF;

Line 591: PA_DEBUG.g_err_stage := '205: Before inserting recs into Temp Table';

587: IS
588: BEGIN
589: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_act_into_tmp_GL');
590: IF l_debug ='Y'THEN -- bug 2674619
591: PA_DEBUG.g_err_stage := '205: Before inserting recs into Temp Table';
592: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
593: END IF;
594: INSERT
595: INTO pa_rep_util_summ00_tmp(

Line 592: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);

588: BEGIN
589: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_act_into_tmp_GL');
590: IF l_debug ='Y'THEN -- bug 2674619
591: PA_DEBUG.g_err_stage := '205: Before inserting recs into Temp Table';
592: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
593: END IF;
594: INSERT
595: INTO pa_rep_util_summ00_tmp(
596: Row_id

Line 684: PA_DEBUG.g_err_stage := '210: After inserting recs into Temp Table';

680: AND cdl.line_type = 'R'
681: AND cdl.util_summarized_flag = 'N'
682: AND NVL(cdl.org_id,-99) = l_org_id;
683: IF l_debug ='Y'THEN -- bug 2674619
684: PA_DEBUG.g_err_stage := '210: After inserting recs into Temp Table';
685: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
686: END IF;
687: PA_DEBUG.Reset_Curr_Function;
688: EXCEPTION

Line 685: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);

681: AND cdl.util_summarized_flag = 'N'
682: AND NVL(cdl.org_id,-99) = l_org_id;
683: IF l_debug ='Y'THEN -- bug 2674619
684: PA_DEBUG.g_err_stage := '210: After inserting recs into Temp Table';
685: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
686: END IF;
687: PA_DEBUG.Reset_Curr_Function;
688: EXCEPTION
689: WHEN OTHERS THEN

Line 687: PA_DEBUG.Reset_Curr_Function;

683: IF l_debug ='Y'THEN -- bug 2674619
684: PA_DEBUG.g_err_stage := '210: After inserting recs into Temp Table';
685: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
686: END IF;
687: PA_DEBUG.Reset_Curr_Function;
688: EXCEPTION
689: WHEN OTHERS THEN
690: RAISE;
691:

Line 697: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_act_into_tmp_PAGL');

693: -------------------------------------------------------
694: PROCEDURE insert_act_into_tmp_PAGL
695: IS
696: BEGIN
697: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_act_into_tmp_PAGL');
698: IF l_debug ='Y'THEN -- bug 2674619
699: PA_DEBUG.g_err_stage := '205: Before inserting recs into Temp Table';
700: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
701: END IF;

Line 699: PA_DEBUG.g_err_stage := '205: Before inserting recs into Temp Table';

695: IS
696: BEGIN
697: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_act_into_tmp_PAGL');
698: IF l_debug ='Y'THEN -- bug 2674619
699: PA_DEBUG.g_err_stage := '205: Before inserting recs into Temp Table';
700: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
701: END IF;
702:
703: INSERT

Line 700: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);

696: BEGIN
697: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_act_into_tmp_PAGL');
698: IF l_debug ='Y'THEN -- bug 2674619
699: PA_DEBUG.g_err_stage := '205: Before inserting recs into Temp Table';
700: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
701: END IF;
702:
703: INSERT
704: INTO pa_rep_util_summ00_tmp(

Line 797: PA_DEBUG.g_err_stage := '210: After inserting recs into Temp Table';

793: AND cdl.line_type = 'R'
794: AND cdl.util_summarized_flag = 'N'
795: AND NVL(cdl.org_id,-99) = l_org_id;
796: IF l_debug ='Y'THEN -- bug 2674619
797: PA_DEBUG.g_err_stage := '210: After inserting recs into Temp Table';
798: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
799: END IF;
800:
801: PA_DEBUG.Reset_Curr_Function;

Line 798: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);

794: AND cdl.util_summarized_flag = 'N'
795: AND NVL(cdl.org_id,-99) = l_org_id;
796: IF l_debug ='Y'THEN -- bug 2674619
797: PA_DEBUG.g_err_stage := '210: After inserting recs into Temp Table';
798: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
799: END IF;
800:
801: PA_DEBUG.Reset_Curr_Function;
802:

Line 801: PA_DEBUG.Reset_Curr_Function;

797: PA_DEBUG.g_err_stage := '210: After inserting recs into Temp Table';
798: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
799: END IF;
800:
801: PA_DEBUG.Reset_Curr_Function;
802:
803: EXCEPTION
804: WHEN OTHERS THEN
805: RAISE;

Line 811: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_act_into_tmp_PAGE');

807: -------------------------------------------------------
808: PROCEDURE insert_act_into_tmp_PAGE
809: IS
810: BEGIN
811: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_act_into_tmp_PAGE');
812: IF l_debug ='Y'THEN -- bug 2674619
813: PA_DEBUG.g_err_stage := '205: Before inserting recs into Temp Table';
814: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
815: END IF;

Line 813: PA_DEBUG.g_err_stage := '205: Before inserting recs into Temp Table';

809: IS
810: BEGIN
811: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_act_into_tmp_PAGE');
812: IF l_debug ='Y'THEN -- bug 2674619
813: PA_DEBUG.g_err_stage := '205: Before inserting recs into Temp Table';
814: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
815: END IF;
816: INSERT
817: INTO pa_rep_util_summ00_tmp(

Line 814: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);

810: BEGIN
811: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_act_into_tmp_PAGE');
812: IF l_debug ='Y'THEN -- bug 2674619
813: PA_DEBUG.g_err_stage := '205: Before inserting recs into Temp Table';
814: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
815: END IF;
816: INSERT
817: INTO pa_rep_util_summ00_tmp(
818: Row_id

Line 911: PA_DEBUG.g_err_stage := '210: After inserting recs into Temp Table';

907: AND cdl.line_type = 'R'
908: AND cdl.util_summarized_flag = 'N'
909: AND NVL(cdl.org_id,-99) = l_org_id;
910: IF l_debug ='Y'THEN -- bug 2674619
911: PA_DEBUG.g_err_stage := '210: After inserting recs into Temp Table';
912: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
913: END IF;
914:
915: PA_DEBUG.Reset_Curr_Function;

Line 912: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);

908: AND cdl.util_summarized_flag = 'N'
909: AND NVL(cdl.org_id,-99) = l_org_id;
910: IF l_debug ='Y'THEN -- bug 2674619
911: PA_DEBUG.g_err_stage := '210: After inserting recs into Temp Table';
912: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
913: END IF;
914:
915: PA_DEBUG.Reset_Curr_Function;
916:

Line 915: PA_DEBUG.Reset_Curr_Function;

911: PA_DEBUG.g_err_stage := '210: After inserting recs into Temp Table';
912: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
913: END IF;
914:
915: PA_DEBUG.Reset_Curr_Function;
916:
917: EXCEPTION
918: WHEN OTHERS THEN
919: RAISE;

Line 925: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_act_into_tmp_GE') ;

921: -------------------------------------------------------
922: PROCEDURE insert_act_into_tmp_GE
923: IS
924: BEGIN
925: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_act_into_tmp_GE') ;
926: IF l_debug ='Y'THEN -- bug 2674619
927: PA_DEBUG.g_err_stage := '205: Before inserting recs into Temp Table';
928: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
929: END IF;

Line 927: PA_DEBUG.g_err_stage := '205: Before inserting recs into Temp Table';

923: IS
924: BEGIN
925: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_act_into_tmp_GE') ;
926: IF l_debug ='Y'THEN -- bug 2674619
927: PA_DEBUG.g_err_stage := '205: Before inserting recs into Temp Table';
928: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
929: END IF;
930: INSERT
931: INTO pa_rep_util_summ00_tmp(

Line 928: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);

924: BEGIN
925: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_act_into_tmp_GE') ;
926: IF l_debug ='Y'THEN -- bug 2674619
927: PA_DEBUG.g_err_stage := '205: Before inserting recs into Temp Table';
928: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
929: END IF;
930: INSERT
931: INTO pa_rep_util_summ00_tmp(
932: Row_id

Line 1021: PA_DEBUG.g_err_stage := '210: After inserting recs into Temp Table';

1017: AND cdl.line_type = 'R'
1018: AND cdl.util_summarized_flag = 'N'
1019: AND NVL(cdl.org_id,-99) = l_org_id;
1020: IF l_debug ='Y'THEN -- bug 2674619
1021: PA_DEBUG.g_err_stage := '210: After inserting recs into Temp Table';
1022: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
1023: END IF;
1024:
1025: PA_DEBUG.Reset_Curr_Function;

Line 1022: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);

1018: AND cdl.util_summarized_flag = 'N'
1019: AND NVL(cdl.org_id,-99) = l_org_id;
1020: IF l_debug ='Y'THEN -- bug 2674619
1021: PA_DEBUG.g_err_stage := '210: After inserting recs into Temp Table';
1022: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
1023: END IF;
1024:
1025: PA_DEBUG.Reset_Curr_Function;
1026:

Line 1025: PA_DEBUG.Reset_Curr_Function;

1021: PA_DEBUG.g_err_stage := '210: After inserting recs into Temp Table';
1022: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
1023: END IF;
1024:
1025: PA_DEBUG.Reset_Curr_Function;
1026:
1027: EXCEPTION
1028: WHEN OTHERS THEN
1029: RAISE;

Line 1036: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_act_into_tmp_PAGLGE');

1032: -------------------------------------------------------
1033: PROCEDURE insert_act_into_tmp_PAGLGE
1034: IS
1035: BEGIN
1036: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_act_into_tmp_PAGLGE');
1037: IF l_debug ='Y'THEN -- bug 2674619
1038: PA_DEBUG.g_err_stage := '205: Before inserting recs into Temp Table';
1039: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
1040: END IF;

Line 1038: PA_DEBUG.g_err_stage := '205: Before inserting recs into Temp Table';

1034: IS
1035: BEGIN
1036: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_act_into_tmp_PAGLGE');
1037: IF l_debug ='Y'THEN -- bug 2674619
1038: PA_DEBUG.g_err_stage := '205: Before inserting recs into Temp Table';
1039: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
1040: END IF;
1041: INSERT
1042: INTO pa_rep_util_summ00_tmp(

Line 1039: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);

1035: BEGIN
1036: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_act_into_tmp_PAGLGE');
1037: IF l_debug ='Y'THEN -- bug 2674619
1038: PA_DEBUG.g_err_stage := '205: Before inserting recs into Temp Table';
1039: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
1040: END IF;
1041: INSERT
1042: INTO pa_rep_util_summ00_tmp(
1043: Row_id

Line 1140: PA_DEBUG.g_err_stage := '210: After inserting recs into Temp Table';

1136: AND cdl.line_type = 'R'
1137: AND cdl.util_summarized_flag = 'N'
1138: AND NVL(cdl.org_id,-99) = l_org_id;
1139: IF l_debug ='Y'THEN -- bug 2674619
1140: PA_DEBUG.g_err_stage := '210: After inserting recs into Temp Table';
1141: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
1142: END IF;
1143:
1144: PA_DEBUG.Reset_Curr_Function;

Line 1141: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);

1137: AND cdl.util_summarized_flag = 'N'
1138: AND NVL(cdl.org_id,-99) = l_org_id;
1139: IF l_debug ='Y'THEN -- bug 2674619
1140: PA_DEBUG.g_err_stage := '210: After inserting recs into Temp Table';
1141: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
1142: END IF;
1143:
1144: PA_DEBUG.Reset_Curr_Function;
1145:

Line 1144: PA_DEBUG.Reset_Curr_Function;

1140: PA_DEBUG.g_err_stage := '210: After inserting recs into Temp Table';
1141: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
1142: END IF;
1143:
1144: PA_DEBUG.Reset_Curr_Function;
1145:
1146: EXCEPTION
1147: WHEN OTHERS THEN
1148: RAISE;

Line 1154: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_act_into_tmp_GLGE');

1150: -------------------------------------------------------
1151: PROCEDURE insert_act_into_tmp_GLGE
1152: IS
1153: BEGIN
1154: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_act_into_tmp_GLGE');
1155: IF l_debug ='Y'THEN -- bug 2674619
1156: PA_DEBUG.g_err_stage := '205: Before inserting recs into Temp Table';
1157: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
1158: END IF;

Line 1156: PA_DEBUG.g_err_stage := '205: Before inserting recs into Temp Table';

1152: IS
1153: BEGIN
1154: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_act_into_tmp_GLGE');
1155: IF l_debug ='Y'THEN -- bug 2674619
1156: PA_DEBUG.g_err_stage := '205: Before inserting recs into Temp Table';
1157: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
1158: END IF;
1159: INSERT
1160: INTO pa_rep_util_summ00_tmp(

Line 1157: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);

1153: BEGIN
1154: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_act_into_tmp_GLGE');
1155: IF l_debug ='Y'THEN -- bug 2674619
1156: PA_DEBUG.g_err_stage := '205: Before inserting recs into Temp Table';
1157: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
1158: END IF;
1159: INSERT
1160: INTO pa_rep_util_summ00_tmp(
1161: Row_id

Line 1255: PA_DEBUG.g_err_stage := '210: After inserting recs into Temp Table';

1251: AND cdl.util_summarized_flag = 'N'
1252: AND NVL(cdl.org_id,-99) = l_org_id;
1253: -- AND ROWNUM <= l_fetch_size;
1254: IF l_debug ='Y'THEN -- bug 2674619
1255: PA_DEBUG.g_err_stage := '210: After inserting recs into Temp Table';
1256: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
1257: END IF;
1258:
1259: PA_DEBUG.Reset_Curr_Function;

Line 1256: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);

1252: AND NVL(cdl.org_id,-99) = l_org_id;
1253: -- AND ROWNUM <= l_fetch_size;
1254: IF l_debug ='Y'THEN -- bug 2674619
1255: PA_DEBUG.g_err_stage := '210: After inserting recs into Temp Table';
1256: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
1257: END IF;
1258:
1259: PA_DEBUG.Reset_Curr_Function;
1260:

Line 1259: PA_DEBUG.Reset_Curr_Function;

1255: PA_DEBUG.g_err_stage := '210: After inserting recs into Temp Table';
1256: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
1257: END IF;
1258:
1259: PA_DEBUG.Reset_Curr_Function;
1260:
1261: EXCEPTION
1262: WHEN OTHERS THEN
1263: RAISE;