46: l_quantity_id pa_amount_types_b.amount_type_id%TYPE := PA_REP_UTIL_GLOB. G_amt_type_details.G_quantity_id;
47: l_org_rollup_method VARCHAR2(1) := PA_REP_UTIL_GLOB.G_input_parameters.G_org_rollup_method;
48:
49: -------------------------------------------------------
50: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */
51:
52: PROCEDURE insert_fct_into_tmp_table
53: IS
54: BEGIN
51:
52: PROCEDURE insert_fct_into_tmp_table
53: IS
54: BEGIN
55: PA_DEBUG.Set_Curr_Function( p_function => 'insert_fct_into_tmp_table');
56: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
57: PA_DEBUG.g_err_stage := '205: Before inserting recs into Temp Table';
58: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
59: END IF;
53: IS
54: BEGIN
55: PA_DEBUG.Set_Curr_Function( p_function => 'insert_fct_into_tmp_table');
56: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
57: PA_DEBUG.g_err_stage := '205: Before inserting recs into Temp Table';
58: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
59: END IF;
60: --
61: -- Coded as a performance fix by mpuvathi
54: BEGIN
55: PA_DEBUG.Set_Curr_Function( p_function => 'insert_fct_into_tmp_table');
56: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
57: PA_DEBUG.g_err_stage := '205: Before inserting recs into Temp Table';
58: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
59: END IF;
60: --
61: -- Coded as a performance fix by mpuvathi
62: -- Starts here
130: -- Coded as a performance fix by mpuvathi
131: -- Ends here
132: --
133:
134: -- PA_DEBUG.g_err_stage := '210: After inserting recs into Temp Table';
135: -- PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
136: PA_DEBUG.Reset_Curr_Function;
137: EXCEPTION
138: WHEN OTHERS THEN
131: -- Ends here
132: --
133:
134: -- PA_DEBUG.g_err_stage := '210: After inserting recs into Temp Table';
135: -- PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
136: PA_DEBUG.Reset_Curr_Function;
137: EXCEPTION
138: WHEN OTHERS THEN
139: RAISE;
132: --
133:
134: -- PA_DEBUG.g_err_stage := '210: After inserting recs into Temp Table';
135: -- PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
136: PA_DEBUG.Reset_Curr_Function;
137: EXCEPTION
138: WHEN OTHERS THEN
139: RAISE;
140: END insert_fct_into_tmp_table;
151: BEGIN
152: -- Initialize the Error Stack
153:
154:
155: PA_DEBUG.Set_Curr_Function( p_function => 'Summarize_Forecast_Util');
156:
157: IF (l_pa_period_flag = 'N') AND (l_gl_period_flag = 'N') AND (l_ge_period_flag = 'N') THEN
158: -- Reset the error stack when returning to the calling program
159: PA_DEBUG.Reset_Curr_Function;
155: PA_DEBUG.Set_Curr_Function( p_function => 'Summarize_Forecast_Util');
156:
157: IF (l_pa_period_flag = 'N') AND (l_gl_period_flag = 'N') AND (l_ge_period_flag = 'N') THEN
158: -- Reset the error stack when returning to the calling program
159: PA_DEBUG.Reset_Curr_Function;
160: RETURN;
161: END IF;
162:
163: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
160: RETURN;
161: END IF;
162:
163: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
164: PA_DEBUG.G_Err_Stage := '50 : L_FC_START_DATE ' || l_fc_start_date;
165: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
166: PA_DEBUG.G_Err_Stage := '100 : L_FC_END_DATE ' || l_fc_end_date;
167: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
168: PA_DEBUG.G_Err_Stage := '150 : After checking the flags ';
161: END IF;
162:
163: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
164: PA_DEBUG.G_Err_Stage := '50 : L_FC_START_DATE ' || l_fc_start_date;
165: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
166: PA_DEBUG.G_Err_Stage := '100 : L_FC_END_DATE ' || l_fc_end_date;
167: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
168: PA_DEBUG.G_Err_Stage := '150 : After checking the flags ';
169: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
162:
163: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
164: PA_DEBUG.G_Err_Stage := '50 : L_FC_START_DATE ' || l_fc_start_date;
165: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
166: PA_DEBUG.G_Err_Stage := '100 : L_FC_END_DATE ' || l_fc_end_date;
167: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
168: PA_DEBUG.G_Err_Stage := '150 : After checking the flags ';
169: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
170: PA_DEBUG.G_Err_Stage := '200 : L_PA_PERIOD_FLAG ' || l_pa_period_flag;
163: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
164: PA_DEBUG.G_Err_Stage := '50 : L_FC_START_DATE ' || l_fc_start_date;
165: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
166: PA_DEBUG.G_Err_Stage := '100 : L_FC_END_DATE ' || l_fc_end_date;
167: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
168: PA_DEBUG.G_Err_Stage := '150 : After checking the flags ';
169: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
170: PA_DEBUG.G_Err_Stage := '200 : L_PA_PERIOD_FLAG ' || l_pa_period_flag;
171: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
164: PA_DEBUG.G_Err_Stage := '50 : L_FC_START_DATE ' || l_fc_start_date;
165: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
166: PA_DEBUG.G_Err_Stage := '100 : L_FC_END_DATE ' || l_fc_end_date;
167: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
168: PA_DEBUG.G_Err_Stage := '150 : After checking the flags ';
169: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
170: PA_DEBUG.G_Err_Stage := '200 : L_PA_PERIOD_FLAG ' || l_pa_period_flag;
171: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
172: PA_DEBUG.G_Err_Stage := '250 : L_GL_PERIOD_FLAG ' || l_gl_period_flag;
165: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
166: PA_DEBUG.G_Err_Stage := '100 : L_FC_END_DATE ' || l_fc_end_date;
167: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
168: PA_DEBUG.G_Err_Stage := '150 : After checking the flags ';
169: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
170: PA_DEBUG.G_Err_Stage := '200 : L_PA_PERIOD_FLAG ' || l_pa_period_flag;
171: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
172: PA_DEBUG.G_Err_Stage := '250 : L_GL_PERIOD_FLAG ' || l_gl_period_flag;
173: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
166: PA_DEBUG.G_Err_Stage := '100 : L_FC_END_DATE ' || l_fc_end_date;
167: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
168: PA_DEBUG.G_Err_Stage := '150 : After checking the flags ';
169: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
170: PA_DEBUG.G_Err_Stage := '200 : L_PA_PERIOD_FLAG ' || l_pa_period_flag;
171: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
172: PA_DEBUG.G_Err_Stage := '250 : L_GL_PERIOD_FLAG ' || l_gl_period_flag;
173: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
174: PA_DEBUG.G_Err_Stage := '300 : L_GE_PERIOD_FLAG ' || l_ge_period_flag;
167: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
168: PA_DEBUG.G_Err_Stage := '150 : After checking the flags ';
169: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
170: PA_DEBUG.G_Err_Stage := '200 : L_PA_PERIOD_FLAG ' || l_pa_period_flag;
171: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
172: PA_DEBUG.G_Err_Stage := '250 : L_GL_PERIOD_FLAG ' || l_gl_period_flag;
173: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
174: PA_DEBUG.G_Err_Stage := '300 : L_GE_PERIOD_FLAG ' || l_ge_period_flag;
175: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
168: PA_DEBUG.G_Err_Stage := '150 : After checking the flags ';
169: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
170: PA_DEBUG.G_Err_Stage := '200 : L_PA_PERIOD_FLAG ' || l_pa_period_flag;
171: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
172: PA_DEBUG.G_Err_Stage := '250 : L_GL_PERIOD_FLAG ' || l_gl_period_flag;
173: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
174: PA_DEBUG.G_Err_Stage := '300 : L_GE_PERIOD_FLAG ' || l_ge_period_flag;
175: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
176: END IF;
169: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
170: PA_DEBUG.G_Err_Stage := '200 : L_PA_PERIOD_FLAG ' || l_pa_period_flag;
171: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
172: PA_DEBUG.G_Err_Stage := '250 : L_GL_PERIOD_FLAG ' || l_gl_period_flag;
173: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
174: PA_DEBUG.G_Err_Stage := '300 : L_GE_PERIOD_FLAG ' || l_ge_period_flag;
175: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
176: END IF;
177:
170: PA_DEBUG.G_Err_Stage := '200 : L_PA_PERIOD_FLAG ' || l_pa_period_flag;
171: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
172: PA_DEBUG.G_Err_Stage := '250 : L_GL_PERIOD_FLAG ' || l_gl_period_flag;
173: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
174: PA_DEBUG.G_Err_Stage := '300 : L_GE_PERIOD_FLAG ' || l_ge_period_flag;
175: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
176: END IF;
177:
178: /*
171: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
172: PA_DEBUG.G_Err_Stage := '250 : L_GL_PERIOD_FLAG ' || l_gl_period_flag;
173: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
174: PA_DEBUG.G_Err_Stage := '300 : L_GE_PERIOD_FLAG ' || l_ge_period_flag;
175: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
176: END IF;
177:
178: /*
179: * Calling a procedure for populating the initial temporary workspace
182: IF (l_pa_period_flag = 'Y') THEN
183: IF (l_gl_period_flag = 'Y') THEN
184: IF (l_ge_period_flag = 'Y') THEN
185: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
186: PA_DEBUG.G_Err_Stage := '350 : Calling PAGLGE';
187: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
188: END IF;
189: Insert_Fcst_Into_Tmp_PAGLGE;
190: ELSE
183: IF (l_gl_period_flag = 'Y') THEN
184: IF (l_ge_period_flag = 'Y') THEN
185: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
186: PA_DEBUG.G_Err_Stage := '350 : Calling PAGLGE';
187: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
188: END IF;
189: Insert_Fcst_Into_Tmp_PAGLGE;
190: ELSE
191: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
188: END IF;
189: Insert_Fcst_Into_Tmp_PAGLGE;
190: ELSE
191: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
192: PA_DEBUG.G_Err_Stage := '400 : Calling PAGL';
193: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
194: END IF;
195: Insert_Fcst_Into_Tmp_PAGL;
196: END IF;
189: Insert_Fcst_Into_Tmp_PAGLGE;
190: ELSE
191: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
192: PA_DEBUG.G_Err_Stage := '400 : Calling PAGL';
193: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
194: END IF;
195: Insert_Fcst_Into_Tmp_PAGL;
196: END IF;
197: ELSIF (l_ge_period_flag = 'Y') THEN
195: Insert_Fcst_Into_Tmp_PAGL;
196: END IF;
197: ELSIF (l_ge_period_flag = 'Y') THEN
198: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
199: PA_DEBUG.G_Err_Stage := '450 : Calling PAGE';
200: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
201: END IF;
202: Insert_Fcst_Into_Tmp_PAGE;
203: ELSE
196: END IF;
197: ELSIF (l_ge_period_flag = 'Y') THEN
198: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
199: PA_DEBUG.G_Err_Stage := '450 : Calling PAGE';
200: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
201: END IF;
202: Insert_Fcst_Into_Tmp_PAGE;
203: ELSE
204: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
201: END IF;
202: Insert_Fcst_Into_Tmp_PAGE;
203: ELSE
204: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
205: PA_DEBUG.G_Err_Stage := '500 : Calling PA';
206: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
207: END IF;
208: Insert_Fcst_Into_Tmp_PA;
209: END IF;
202: Insert_Fcst_Into_Tmp_PAGE;
203: ELSE
204: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
205: PA_DEBUG.G_Err_Stage := '500 : Calling PA';
206: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
207: END IF;
208: Insert_Fcst_Into_Tmp_PA;
209: END IF;
210: ELSIF (l_gl_period_flag = 'Y') THEN
209: END IF;
210: ELSIF (l_gl_period_flag = 'Y') THEN
211: IF (l_ge_period_flag = 'Y') THEN
212: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
213: PA_DEBUG.G_Err_Stage := '550 : Calling GLGE';
214: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
215: END IF;
216: Insert_Fcst_Into_Tmp_GLGE;
217: ELSE
210: ELSIF (l_gl_period_flag = 'Y') THEN
211: IF (l_ge_period_flag = 'Y') THEN
212: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
213: PA_DEBUG.G_Err_Stage := '550 : Calling GLGE';
214: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
215: END IF;
216: Insert_Fcst_Into_Tmp_GLGE;
217: ELSE
218: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
215: END IF;
216: Insert_Fcst_Into_Tmp_GLGE;
217: ELSE
218: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
219: PA_DEBUG.G_Err_Stage := '600 : Calling GL';
220: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
221: END IF;
222: Insert_Fcst_Into_Tmp_GL;
223: END IF;
216: Insert_Fcst_Into_Tmp_GLGE;
217: ELSE
218: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
219: PA_DEBUG.G_Err_Stage := '600 : Calling GL';
220: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
221: END IF;
222: Insert_Fcst_Into_Tmp_GL;
223: END IF;
224: ELSE
222: Insert_Fcst_Into_Tmp_GL;
223: END IF;
224: ELSE
225: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
226: PA_DEBUG.G_Err_Stage := '650 : Calling GE';
227: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
228: END IF;
229: Insert_Fcst_Into_Tmp_GE;
230: END IF;
223: END IF;
224: ELSE
225: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
226: PA_DEBUG.G_Err_Stage := '650 : Calling GE';
227: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
228: END IF;
229: Insert_Fcst_Into_Tmp_GE;
230: END IF;
231: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
228: END IF;
229: Insert_Fcst_Into_Tmp_GE;
230: END IF;
231: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
232: PA_DEBUG.G_Err_Stage := '700 : After Calling the INSERT_PROC_[PA][GL][GE]';
233: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
234: END IF;
235:
236: /*
229: Insert_Fcst_Into_Tmp_GE;
230: END IF;
231: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
232: PA_DEBUG.G_Err_Stage := '700 : After Calling the INSERT_PROC_[PA][GL][GE]';
233: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
234: END IF;
235:
236: /*
237: * Calling a procedure for populating the temporary workspace
249: insert_fct_into_tmp_table;
250: -- If NO records are inserted, getout of the loop.
251: l_records_inserted := SQL%ROWCOUNT;
252: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
253: PA_DEBUG.G_Err_Stage := '750 : Records Inserted in Temp tab : ' || l_records_inserted;
254: PA_DEBUG.Log_Message(p_message => pa_debug.G_Err_Stage);
255: PA_DEBUG.G_Err_Stage := '753 : l_capacity_summarized: ' || l_capacity_summarized;
256: PA_DEBUG.Log_Message(p_message => pa_debug.G_Err_Stage);
257: END IF;
250: -- If NO records are inserted, getout of the loop.
251: l_records_inserted := SQL%ROWCOUNT;
252: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
253: PA_DEBUG.G_Err_Stage := '750 : Records Inserted in Temp tab : ' || l_records_inserted;
254: PA_DEBUG.Log_Message(p_message => pa_debug.G_Err_Stage);
255: PA_DEBUG.G_Err_Stage := '753 : l_capacity_summarized: ' || l_capacity_summarized;
256: PA_DEBUG.Log_Message(p_message => pa_debug.G_Err_Stage);
257: END IF;
258:
251: l_records_inserted := SQL%ROWCOUNT;
252: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
253: PA_DEBUG.G_Err_Stage := '750 : Records Inserted in Temp tab : ' || l_records_inserted;
254: PA_DEBUG.Log_Message(p_message => pa_debug.G_Err_Stage);
255: PA_DEBUG.G_Err_Stage := '753 : l_capacity_summarized: ' || l_capacity_summarized;
256: PA_DEBUG.Log_Message(p_message => pa_debug.G_Err_Stage);
257: END IF;
258:
259: IF (l_records_inserted = 0 AND l_capacity_summarized= 1) THEN
252: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
253: PA_DEBUG.G_Err_Stage := '750 : Records Inserted in Temp tab : ' || l_records_inserted;
254: PA_DEBUG.Log_Message(p_message => pa_debug.G_Err_Stage);
255: PA_DEBUG.G_Err_Stage := '753 : l_capacity_summarized: ' || l_capacity_summarized;
256: PA_DEBUG.Log_Message(p_message => pa_debug.G_Err_Stage);
257: END IF;
258:
259: IF (l_records_inserted = 0 AND l_capacity_summarized= 1) THEN
260: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
257: END IF;
258:
259: IF (l_records_inserted = 0 AND l_capacity_summarized= 1) THEN
260: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
261: PA_DEBUG.G_Err_Stage := '757 : EXITING since l_records_inserted = 0 AND l_capacity_summarized= 1';
262: PA_DEBUG.Log_Message(p_message => pa_debug.G_Err_Stage);
263: END IF;
264: EXIT;
265: END IF;
258:
259: IF (l_records_inserted = 0 AND l_capacity_summarized= 1) THEN
260: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
261: PA_DEBUG.G_Err_Stage := '757 : EXITING since l_records_inserted = 0 AND l_capacity_summarized= 1';
262: PA_DEBUG.Log_Message(p_message => pa_debug.G_Err_Stage);
263: END IF;
264: EXIT;
265: END IF;
266:
279: RETURNING ROWID BULK COLLECT INTO l_fid_rowid_tab;
280:
281: l_records_updated := SQL%ROWCOUNT;
282: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
283: PA_DEBUG.G_Err_Stage := '800 : Records Updated in PA_FORECAST_ITEMS_DETAILS : '|| l_records_updated;
284: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
285: END IF;
286:
287: -- Check if the all the Forecast_Item_Detail records corresponding to the
280:
281: l_records_updated := SQL%ROWCOUNT;
282: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
283: PA_DEBUG.G_Err_Stage := '800 : Records Updated in PA_FORECAST_ITEMS_DETAILS : '|| l_records_updated;
284: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
285: END IF;
286:
287: -- Check if the all the Forecast_Item_Detail records corresponding to the
288: -- those in temp0 have been updated with util_summarized_code = 'S'.
307:
308: -- Delete the rowid plsql table.
309: l_fid_rowid_tab.DELETE;
310: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
311: PA_DEBUG.G_Err_Stage := '850 : Process Method : ' || l_process_method;
312: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
313: PA_DEBUG.G_Err_Stage := '900 : Before calling PA_REP_UTILS_SUMM_PKG';
314: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
315: END IF;
308: -- Delete the rowid plsql table.
309: l_fid_rowid_tab.DELETE;
310: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
311: PA_DEBUG.G_Err_Stage := '850 : Process Method : ' || l_process_method;
312: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
313: PA_DEBUG.G_Err_Stage := '900 : Before calling PA_REP_UTILS_SUMM_PKG';
314: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
315: END IF;
316:
309: l_fid_rowid_tab.DELETE;
310: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
311: PA_DEBUG.G_Err_Stage := '850 : Process Method : ' || l_process_method;
312: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
313: PA_DEBUG.G_Err_Stage := '900 : Before calling PA_REP_UTILS_SUMM_PKG';
314: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
315: END IF;
316:
317: --
310: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
311: PA_DEBUG.G_Err_Stage := '850 : Process Method : ' || l_process_method;
312: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
313: PA_DEBUG.G_Err_Stage := '900 : Before calling PA_REP_UTILS_SUMM_PKG';
314: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
315: END IF;
316:
317: --
318: -- Call the package which processes the data.
321:
322:
323: l_capacity_summarized := 1;
324: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
325: PA_DEBUG.G_Err_Stage := '950 : After calling PA_REP_UTILS_SUMM_PKG';
326: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
327: END IF;
328:
329: -- If the process_method is 'F' (Filter):
322:
323: l_capacity_summarized := 1;
324: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
325: PA_DEBUG.G_Err_Stage := '950 : After calling PA_REP_UTILS_SUMM_PKG';
326: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
327: END IF;
328:
329: -- If the process_method is 'F' (Filter):
330: -- 1. Delete those records from pa_forecast_item_details which have been processed
345:
346: IF l_process_method = 'F' THEN
347: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
348: /* Commented for Bug 2984871
349: PA_DEBUG.G_Err_Stage := '1000 : Records Deleted from PA_FORECAST_ITEM_DETAILS: ' || to_char(SQL%ROWCOUNT);
350: PA_DEBUG.Log_Message(p_message => pa_debug.G_Err_Stage);
351: PA_DEBUG.G_Err_Stage := '1050 : After deleting from PA_FORECAST_ITEM_DETAILS for process method ' || l_process_method ;
352: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);*/
353: /*Code Changes for Bug No.2984871 start */
346: IF l_process_method = 'F' THEN
347: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
348: /* Commented for Bug 2984871
349: PA_DEBUG.G_Err_Stage := '1000 : Records Deleted from PA_FORECAST_ITEM_DETAILS: ' || to_char(SQL%ROWCOUNT);
350: PA_DEBUG.Log_Message(p_message => pa_debug.G_Err_Stage);
351: PA_DEBUG.G_Err_Stage := '1050 : After deleting from PA_FORECAST_ITEM_DETAILS for process method ' || l_process_method ;
352: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);*/
353: /*Code Changes for Bug No.2984871 start */
354: PA_DEBUG.G_Err_Stage := '1050 : process method = ' || l_process_method ;
347: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
348: /* Commented for Bug 2984871
349: PA_DEBUG.G_Err_Stage := '1000 : Records Deleted from PA_FORECAST_ITEM_DETAILS: ' || to_char(SQL%ROWCOUNT);
350: PA_DEBUG.Log_Message(p_message => pa_debug.G_Err_Stage);
351: PA_DEBUG.G_Err_Stage := '1050 : After deleting from PA_FORECAST_ITEM_DETAILS for process method ' || l_process_method ;
352: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);*/
353: /*Code Changes for Bug No.2984871 start */
354: PA_DEBUG.G_Err_Stage := '1050 : process method = ' || l_process_method ;
355: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
348: /* Commented for Bug 2984871
349: PA_DEBUG.G_Err_Stage := '1000 : Records Deleted from PA_FORECAST_ITEM_DETAILS: ' || to_char(SQL%ROWCOUNT);
350: PA_DEBUG.Log_Message(p_message => pa_debug.G_Err_Stage);
351: PA_DEBUG.G_Err_Stage := '1050 : After deleting from PA_FORECAST_ITEM_DETAILS for process method ' || l_process_method ;
352: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);*/
353: /*Code Changes for Bug No.2984871 start */
354: PA_DEBUG.G_Err_Stage := '1050 : process method = ' || l_process_method ;
355: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
356: /*Code Changes for Bug No.2984871 end */
350: PA_DEBUG.Log_Message(p_message => pa_debug.G_Err_Stage);
351: PA_DEBUG.G_Err_Stage := '1050 : After deleting from PA_FORECAST_ITEM_DETAILS for process method ' || l_process_method ;
352: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);*/
353: /*Code Changes for Bug No.2984871 start */
354: PA_DEBUG.G_Err_Stage := '1050 : process method = ' || l_process_method ;
355: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
356: /*Code Changes for Bug No.2984871 end */
357: END IF;
358: --
351: PA_DEBUG.G_Err_Stage := '1050 : After deleting from PA_FORECAST_ITEM_DETAILS for process method ' || l_process_method ;
352: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);*/
353: /*Code Changes for Bug No.2984871 start */
354: PA_DEBUG.G_Err_Stage := '1050 : process method = ' || l_process_method ;
355: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
356: /*Code Changes for Bug No.2984871 end */
357: END IF;
358: --
359: UPDATE pa_forecast_item_details
369: FROM pa_rep_util_summ0_tmp
370: WHERE delete_flag = 'N'
371: );
372: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
373: PA_DEBUG.G_Err_Stage := '1100 : Records Updated in PA_FORECAST_ITEM_DETAILS: ' || to_char(SQL%ROWCOUNT);
374: PA_DEBUG.Log_Message(p_message => pa_debug.G_Err_Stage);
375: PA_DEBUG.G_Err_Stage := '1150 : After Updating PA_FORECAST_ITEM_DETAILS for process method ' || l_process_method ;
376: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
377: END IF;
370: WHERE delete_flag = 'N'
371: );
372: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
373: PA_DEBUG.G_Err_Stage := '1100 : Records Updated in PA_FORECAST_ITEM_DETAILS: ' || to_char(SQL%ROWCOUNT);
374: PA_DEBUG.Log_Message(p_message => pa_debug.G_Err_Stage);
375: PA_DEBUG.G_Err_Stage := '1150 : After Updating PA_FORECAST_ITEM_DETAILS for process method ' || l_process_method ;
376: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
377: END IF;
378: --
371: );
372: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
373: PA_DEBUG.G_Err_Stage := '1100 : Records Updated in PA_FORECAST_ITEM_DETAILS: ' || to_char(SQL%ROWCOUNT);
374: PA_DEBUG.Log_Message(p_message => pa_debug.G_Err_Stage);
375: PA_DEBUG.G_Err_Stage := '1150 : After Updating PA_FORECAST_ITEM_DETAILS for process method ' || l_process_method ;
376: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
377: END IF;
378: --
379: /*
372: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
373: PA_DEBUG.G_Err_Stage := '1100 : Records Updated in PA_FORECAST_ITEM_DETAILS: ' || to_char(SQL%ROWCOUNT);
374: PA_DEBUG.Log_Message(p_message => pa_debug.G_Err_Stage);
375: PA_DEBUG.G_Err_Stage := '1150 : After Updating PA_FORECAST_ITEM_DETAILS for process method ' || l_process_method ;
376: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
377: END IF;
378: --
379: /*
380: ** Bug 2263074
383: --
384: ELSIF l_process_method = 'A' THEN
385: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
386: /* Commented for Bug 2984871
387: PA_DEBUG.G_Err_Stage := '1300 : Records Deleted from PA_FORECAST_ITEM_DETAILS: ' || to_char(SQL%ROWCOUNT);
388: PA_DEBUG.Log_Message(p_message => pa_debug.G_Err_Stage);
389: PA_DEBUG.G_Err_Stage := '1350 : After deleting from PA_FORECAST_ITEM_DETAILS for process method ' || l_process_method ;
390: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);*/
391:
384: ELSIF l_process_method = 'A' THEN
385: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
386: /* Commented for Bug 2984871
387: PA_DEBUG.G_Err_Stage := '1300 : Records Deleted from PA_FORECAST_ITEM_DETAILS: ' || to_char(SQL%ROWCOUNT);
388: PA_DEBUG.Log_Message(p_message => pa_debug.G_Err_Stage);
389: PA_DEBUG.G_Err_Stage := '1350 : After deleting from PA_FORECAST_ITEM_DETAILS for process method ' || l_process_method ;
390: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);*/
391:
392: /*Code Changes for Bug No.2984871 start */
385: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
386: /* Commented for Bug 2984871
387: PA_DEBUG.G_Err_Stage := '1300 : Records Deleted from PA_FORECAST_ITEM_DETAILS: ' || to_char(SQL%ROWCOUNT);
388: PA_DEBUG.Log_Message(p_message => pa_debug.G_Err_Stage);
389: PA_DEBUG.G_Err_Stage := '1350 : After deleting from PA_FORECAST_ITEM_DETAILS for process method ' || l_process_method ;
390: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);*/
391:
392: /*Code Changes for Bug No.2984871 start */
393: PA_DEBUG.G_Err_Stage := '1350 : process method = ' || l_process_method ;
386: /* Commented for Bug 2984871
387: PA_DEBUG.G_Err_Stage := '1300 : Records Deleted from PA_FORECAST_ITEM_DETAILS: ' || to_char(SQL%ROWCOUNT);
388: PA_DEBUG.Log_Message(p_message => pa_debug.G_Err_Stage);
389: PA_DEBUG.G_Err_Stage := '1350 : After deleting from PA_FORECAST_ITEM_DETAILS for process method ' || l_process_method ;
390: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);*/
391:
392: /*Code Changes for Bug No.2984871 start */
393: PA_DEBUG.G_Err_Stage := '1350 : process method = ' || l_process_method ;
394: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
389: PA_DEBUG.G_Err_Stage := '1350 : After deleting from PA_FORECAST_ITEM_DETAILS for process method ' || l_process_method ;
390: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);*/
391:
392: /*Code Changes for Bug No.2984871 start */
393: PA_DEBUG.G_Err_Stage := '1350 : process method = ' || l_process_method ;
394: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
395: /*Code Changes for Bug No.2984871 end */
396: END IF;
397: --
390: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);*/
391:
392: /*Code Changes for Bug No.2984871 start */
393: PA_DEBUG.G_Err_Stage := '1350 : process method = ' || l_process_method ;
394: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
395: /*Code Changes for Bug No.2984871 end */
396: END IF;
397: --
398: UPDATE pa_forecast_item_details
407: AND ROWID IN (SELECT row_id
408: FROM pa_rep_util_summ0_tmp
409: );
410: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
411: PA_DEBUG.G_Err_Stage := '1400 : Records Updated in PA_FORECAST_ITEM_DETAILS: ' || to_char(SQL%ROWCOUNT);
412: PA_DEBUG.Log_Message(p_message => pa_debug.G_Err_Stage);
413: PA_DEBUG.G_Err_Stage := '1450 : After Updating PA_FORECAST_ITEM_DETAILS for process method ' || l_process_method ;
414: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
415: END IF;
408: FROM pa_rep_util_summ0_tmp
409: );
410: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
411: PA_DEBUG.G_Err_Stage := '1400 : Records Updated in PA_FORECAST_ITEM_DETAILS: ' || to_char(SQL%ROWCOUNT);
412: PA_DEBUG.Log_Message(p_message => pa_debug.G_Err_Stage);
413: PA_DEBUG.G_Err_Stage := '1450 : After Updating PA_FORECAST_ITEM_DETAILS for process method ' || l_process_method ;
414: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
415: END IF;
416: --
409: );
410: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
411: PA_DEBUG.G_Err_Stage := '1400 : Records Updated in PA_FORECAST_ITEM_DETAILS: ' || to_char(SQL%ROWCOUNT);
412: PA_DEBUG.Log_Message(p_message => pa_debug.G_Err_Stage);
413: PA_DEBUG.G_Err_Stage := '1450 : After Updating PA_FORECAST_ITEM_DETAILS for process method ' || l_process_method ;
414: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
415: END IF;
416: --
417: /*
410: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
411: PA_DEBUG.G_Err_Stage := '1400 : Records Updated in PA_FORECAST_ITEM_DETAILS: ' || to_char(SQL%ROWCOUNT);
412: PA_DEBUG.Log_Message(p_message => pa_debug.G_Err_Stage);
413: PA_DEBUG.G_Err_Stage := '1450 : After Updating PA_FORECAST_ITEM_DETAILS for process method ' || l_process_method ;
414: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
415: END IF;
416: --
417: /*
418: ** Bug 2263074
434: PA_SUMMARIZE_ORG_ROLLUP_PVT.refresh_org_hierarchy_rollup( p_balance_type_code => l_balance_type);
435: END IF;
436:
437: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
438: PA_DEBUG.G_Err_Stage := '1600 : After calling Organization Utilization Forecast Refresh Rollup';
439: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
440: END IF;
441:
442: --
435: END IF;
436:
437: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
438: PA_DEBUG.G_Err_Stage := '1600 : After calling Organization Utilization Forecast Refresh Rollup';
439: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
440: END IF;
441:
442: --
443: -- Update pa_utilization_options with the dates for which Balances exist.
466: */
467:
468: COMMIT;
469: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
470: PA_DEBUG.G_Err_Stage := '1650 : After updating PA_UTILIZATION_OPTIONS_ALL';
471: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
472: PA_DEBUG.g_err_stage := '1660: Exiting the Package PA_SUMMARIZE_FORECAST_UTIL';
473: END IF;
474: -- Reset the error stack when returning to the calling program
467:
468: COMMIT;
469: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
470: PA_DEBUG.G_Err_Stage := '1650 : After updating PA_UTILIZATION_OPTIONS_ALL';
471: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
472: PA_DEBUG.g_err_stage := '1660: Exiting the Package PA_SUMMARIZE_FORECAST_UTIL';
473: END IF;
474: -- Reset the error stack when returning to the calling program
475: PA_DEBUG.Reset_Curr_Function;
468: COMMIT;
469: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
470: PA_DEBUG.G_Err_Stage := '1650 : After updating PA_UTILIZATION_OPTIONS_ALL';
471: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
472: PA_DEBUG.g_err_stage := '1660: Exiting the Package PA_SUMMARIZE_FORECAST_UTIL';
473: END IF;
474: -- Reset the error stack when returning to the calling program
475: PA_DEBUG.Reset_Curr_Function;
476:
471: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
472: PA_DEBUG.g_err_stage := '1660: Exiting the Package PA_SUMMARIZE_FORECAST_UTIL';
473: END IF;
474: -- Reset the error stack when returning to the calling program
475: PA_DEBUG.Reset_Curr_Function;
476:
477: EXCEPTION
478: WHEN OTHERS THEN
479: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
476:
477: EXCEPTION
478: WHEN OTHERS THEN
479: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
480: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stack);
481: PA_DEBUG.Log_Message(p_message => SQLERRM);
482: END IF;
483: RAISE;
484:
477: EXCEPTION
478: WHEN OTHERS THEN
479: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
480: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stack);
481: PA_DEBUG.Log_Message(p_message => SQLERRM);
482: END IF;
483: RAISE;
484:
485: END Summarize_Forecast_Util;
492: PROCEDURE Insert_Fcst_Into_Tmp_PA
493: IS
494: BEGIN
495: -- Set the error stack
496: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_Fcst_Into_Tmp_PA');
497: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
498: PA_DEBUG.G_Err_Stage := '2000 : Before Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for PA';
499: END IF;
500: INSERT INTO pa_rep_util_summ00_tmp
494: BEGIN
495: -- Set the error stack
496: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_Fcst_Into_Tmp_PA');
497: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
498: PA_DEBUG.G_Err_Stage := '2000 : Before Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for PA';
499: END IF;
500: INSERT INTO pa_rep_util_summ00_tmp
501: ( row_id
502: ,parent_row_id
575: AND fi.item_date BETWEEN l_fc_start_date AND TRUNC(l_fc_end_date)+0.99999; /* BUG# 3118592 */
576:
577: commit;
578: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
579: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
580: PA_DEBUG.G_Err_Stage := '2050 : After Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for PA';
581: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
582: END IF;
583:
576:
577: commit;
578: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
579: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
580: PA_DEBUG.G_Err_Stage := '2050 : After Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for PA';
581: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
582: END IF;
583:
584: -- Reset the error stack
577: commit;
578: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
579: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
580: PA_DEBUG.G_Err_Stage := '2050 : After Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for PA';
581: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
582: END IF;
583:
584: -- Reset the error stack
585: PA_DEBUG.Reset_Curr_Function;
581: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
582: END IF;
583:
584: -- Reset the error stack
585: PA_DEBUG.Reset_Curr_Function;
586:
587: EXCEPTION
588: WHEN OTHERS THEN
589: RAISE;
597: PROCEDURE Insert_Fcst_Into_Tmp_GL
598: IS
599: BEGIN
600: -- Set the error satack
601: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_Fcst_Into_Tmp_GL');
602: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
603: PA_DEBUG.G_Err_Stage := '2100 : Before Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for GL';
604: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
605: END IF;
599: BEGIN
600: -- Set the error satack
601: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_Fcst_Into_Tmp_GL');
602: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
603: PA_DEBUG.G_Err_Stage := '2100 : Before Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for GL';
604: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
605: END IF;
606:
607: INSERT INTO pa_rep_util_summ00_tmp
600: -- Set the error satack
601: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_Fcst_Into_Tmp_GL');
602: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
603: PA_DEBUG.G_Err_Stage := '2100 : Before Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for GL';
604: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
605: END IF;
606:
607: INSERT INTO pa_rep_util_summ00_tmp
608: ( row_id
682: AND fi.item_date BETWEEN l_fc_start_date AND TRUNC(l_fc_end_date)+0.99999 ; /* BUG# 3118592 */
683:
684:
685: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
686: PA_DEBUG.G_Err_Stage := '2150 : After Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for GL';
687: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
688: END IF;
689:
690: -- Reset the error stack
683:
684:
685: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
686: PA_DEBUG.G_Err_Stage := '2150 : After Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for GL';
687: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
688: END IF;
689:
690: -- Reset the error stack
691: PA_DEBUG.Reset_Curr_Function;
687: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
688: END IF;
689:
690: -- Reset the error stack
691: PA_DEBUG.Reset_Curr_Function;
692:
693: EXCEPTION
694: WHEN OTHERS THEN
695: RAISE;
703: PROCEDURE Insert_Fcst_Into_Tmp_GE
704: IS
705: BEGIN
706: -- Set the error satack
707: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_Fcst_Into_Tmp_GE');
708:
709: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
710: PA_DEBUG.G_Err_Stage := '2200 : Before Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for GE';
711: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
706: -- Set the error satack
707: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_Fcst_Into_Tmp_GE');
708:
709: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
710: PA_DEBUG.G_Err_Stage := '2200 : Before Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for GE';
711: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
712: END IF;
713:
714: INSERT INTO pa_rep_util_summ00_tmp
707: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_Fcst_Into_Tmp_GE');
708:
709: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
710: PA_DEBUG.G_Err_Stage := '2200 : Before Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for GE';
711: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
712: END IF;
713:
714: INSERT INTO pa_rep_util_summ00_tmp
715: ( row_id
782: AND fid.amount_type_id = l_quantity_id
783: AND fi.item_date BETWEEN l_fc_start_date AND TRUNC(l_fc_end_date)+0.99999; /* BUG# 3118592 */
784:
785: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
786: PA_DEBUG.G_Err_Stage := '2250 : After Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for GE';
787: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
788: END IF;
789:
790: -- Reset the error stack
783: AND fi.item_date BETWEEN l_fc_start_date AND TRUNC(l_fc_end_date)+0.99999; /* BUG# 3118592 */
784:
785: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
786: PA_DEBUG.G_Err_Stage := '2250 : After Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for GE';
787: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
788: END IF;
789:
790: -- Reset the error stack
791: PA_DEBUG.Reset_Curr_Function;
787: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
788: END IF;
789:
790: -- Reset the error stack
791: PA_DEBUG.Reset_Curr_Function;
792:
793: EXCEPTION
794: WHEN OTHERS THEN
795: RAISE;
803: PROCEDURE Insert_Fcst_Into_Tmp_PAGL
804: IS
805: BEGIN
806: -- Set the error satack
807: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_Fcst_Into_Tmp_PAGL');
808:
809: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
810: PA_DEBUG.G_Err_Stage := '2300 : Before Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for PA and GL';
811: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
806: -- Set the error satack
807: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_Fcst_Into_Tmp_PAGL');
808:
809: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
810: PA_DEBUG.G_Err_Stage := '2300 : Before Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for PA and GL';
811: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
812: END IF;
813:
814: INSERT INTO pa_rep_util_summ00_tmp
807: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_Fcst_Into_Tmp_PAGL');
808:
809: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
810: PA_DEBUG.G_Err_Stage := '2300 : Before Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for PA and GL';
811: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
812: END IF;
813:
814: INSERT INTO pa_rep_util_summ00_tmp
815: ( row_id
893: --AND fi.pvdr_period_set_name = gp.period_set_name /* commented for bug 3488229 */
894: AND fi.pvdr_gl_period_name = gp.period_name
895: AND fi.item_date BETWEEN l_fc_start_date AND TRUNC(l_fc_end_date)+0.99999 ; /* BUG# 3118592 */
896: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
897: PA_DEBUG.G_Err_Stage := '2350 : After Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for PA and GL';
898: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
899: END IF;
900:
901: -- Reset the error stack
894: AND fi.pvdr_gl_period_name = gp.period_name
895: AND fi.item_date BETWEEN l_fc_start_date AND TRUNC(l_fc_end_date)+0.99999 ; /* BUG# 3118592 */
896: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
897: PA_DEBUG.G_Err_Stage := '2350 : After Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for PA and GL';
898: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
899: END IF;
900:
901: -- Reset the error stack
902: PA_DEBUG.Reset_Curr_Function;
898: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
899: END IF;
900:
901: -- Reset the error stack
902: PA_DEBUG.Reset_Curr_Function;
903:
904: EXCEPTION
905: WHEN OTHERS THEN
906: RAISE;
914: PROCEDURE Insert_Fcst_Into_Tmp_PAGE
915: IS
916: BEGIN
917: -- Set the error satack
918: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_Fcst_Into_Tmp_PAGE');
919:
920: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
921: PA_DEBUG.G_Err_Stage := '2400 : Before Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for PA and GE';
922: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
917: -- Set the error satack
918: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_Fcst_Into_Tmp_PAGE');
919:
920: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
921: PA_DEBUG.G_Err_Stage := '2400 : Before Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for PA and GE';
922: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
923: END IF;
924:
925: INSERT INTO pa_rep_util_summ00_tmp
918: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_Fcst_Into_Tmp_PAGE');
919:
920: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
921: PA_DEBUG.G_Err_Stage := '2400 : Before Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for PA and GE';
922: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
923: END IF;
924:
925: INSERT INTO pa_rep_util_summ00_tmp
926: ( row_id
998: --AND fi.pvdr_period_set_name = pp.period_set_name /* commented for bug 3488229 */
999: AND fi.pvdr_pa_period_name = pp.period_name
1000: AND fi.item_date BETWEEN l_fc_start_date AND TRUNC(l_fc_end_date)+0.99999 ; /* BUG# 3118592 */
1001: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1002: PA_DEBUG.G_Err_Stage := '2450 : After Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for PA and GE';
1003: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
1004: END IF;
1005:
1006: -- Reset the error stack
999: AND fi.pvdr_pa_period_name = pp.period_name
1000: AND fi.item_date BETWEEN l_fc_start_date AND TRUNC(l_fc_end_date)+0.99999 ; /* BUG# 3118592 */
1001: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1002: PA_DEBUG.G_Err_Stage := '2450 : After Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for PA and GE';
1003: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
1004: END IF;
1005:
1006: -- Reset the error stack
1007: PA_DEBUG.Reset_Curr_Function;
1003: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
1004: END IF;
1005:
1006: -- Reset the error stack
1007: PA_DEBUG.Reset_Curr_Function;
1008:
1009: EXCEPTION
1010: WHEN OTHERS THEN
1011: RAISE;
1019: PROCEDURE Insert_Fcst_Into_Tmp_GLGE
1020: IS
1021: BEGIN
1022: -- Set the error satack
1023: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_Fcst_Into_Tmp_GLGE');
1024:
1025: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1026: PA_DEBUG.G_Err_Stage := '2500 : Before Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for GL and GE';
1027: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
1022: -- Set the error satack
1023: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_Fcst_Into_Tmp_GLGE');
1024:
1025: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1026: PA_DEBUG.G_Err_Stage := '2500 : Before Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for GL and GE';
1027: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
1028: END IF;
1029:
1030: INSERT INTO pa_rep_util_summ00_tmp
1023: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_Fcst_Into_Tmp_GLGE');
1024:
1025: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1026: PA_DEBUG.G_Err_Stage := '2500 : Before Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for GL and GE';
1027: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
1028: END IF;
1029:
1030: INSERT INTO pa_rep_util_summ00_tmp
1031: ( row_id
1103: --AND fi.pvdr_period_set_name = gp.period_set_name /* commented for bug 3488229 */
1104: AND fi.pvdr_gl_period_name = gp.period_name
1105: AND fi.item_date BETWEEN l_fc_start_date AND TRUNC(l_fc_end_date)+0.99999; /* BUG# 3118592 */
1106: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1107: PA_DEBUG.G_Err_Stage := '2550 : After Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for GL and GE';
1108: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
1109: END IF;
1110:
1111: -- Reset the error stack
1104: AND fi.pvdr_gl_period_name = gp.period_name
1105: AND fi.item_date BETWEEN l_fc_start_date AND TRUNC(l_fc_end_date)+0.99999; /* BUG# 3118592 */
1106: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1107: PA_DEBUG.G_Err_Stage := '2550 : After Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for GL and GE';
1108: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
1109: END IF;
1110:
1111: -- Reset the error stack
1112: PA_DEBUG.Reset_Curr_Function;
1108: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
1109: END IF;
1110:
1111: -- Reset the error stack
1112: PA_DEBUG.Reset_Curr_Function;
1113:
1114: EXCEPTION
1115: WHEN OTHERS THEN
1116: RAISE;
1124: PROCEDURE Insert_Fcst_Into_Tmp_PAGLGE
1125: IS
1126: BEGIN
1127: -- Set the error satack
1128: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_Fcst_Into_Tmp_PAGLGE');
1129: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1130: PA_DEBUG.G_Err_Stage := '2600 : Before Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for PA, GL and GE';
1131: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
1132: END IF;
1126: BEGIN
1127: -- Set the error satack
1128: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_Fcst_Into_Tmp_PAGLGE');
1129: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1130: PA_DEBUG.G_Err_Stage := '2600 : Before Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for PA, GL and GE';
1131: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
1132: END IF;
1133:
1134: INSERT INTO pa_rep_util_summ00_tmp
1127: -- Set the error satack
1128: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_Fcst_Into_Tmp_PAGLGE');
1129: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1130: PA_DEBUG.G_Err_Stage := '2600 : Before Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for PA, GL and GE';
1131: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
1132: END IF;
1133:
1134: INSERT INTO pa_rep_util_summ00_tmp
1135: ( row_id
1214: AND fi.pvdr_gl_period_name = gp.period_name
1215: AND fi.item_date BETWEEN l_fc_start_date AND TRUNC(l_fc_end_date)+0.99999 ; /* BUG# 3118592 */
1216:
1217: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1218: PA_DEBUG.G_Err_Stage := '2650 : After Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for PA, GL and GE';
1219: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
1220: END IF;
1221:
1222: -- Reset the error stack
1215: AND fi.item_date BETWEEN l_fc_start_date AND TRUNC(l_fc_end_date)+0.99999 ; /* BUG# 3118592 */
1216:
1217: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1218: PA_DEBUG.G_Err_Stage := '2650 : After Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for PA, GL and GE';
1219: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
1220: END IF;
1221:
1222: -- Reset the error stack
1223: PA_DEBUG.Reset_Curr_Function;
1219: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
1220: END IF;
1221:
1222: -- Reset the error stack
1223: PA_DEBUG.Reset_Curr_Function;
1224:
1225: EXCEPTION
1226: WHEN OTHERS THEN
1227: RAISE;