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_FORECAST_UTIL_PVT dependencies on PA_DEBUG

Line 50: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */

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

Line 55: PA_DEBUG.Set_Curr_Function( p_function => 'insert_fct_into_tmp_table');

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;

Line 57: PA_DEBUG.g_err_stage := '205: Before inserting recs into Temp 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;
60: --
61: -- Coded as a performance fix by mpuvathi

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

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

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

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

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

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;

Line 136: PA_DEBUG.Reset_Curr_Function;

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;

Line 155: PA_DEBUG.Set_Curr_Function( p_function => 'Summarize_Forecast_Util');

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;

Line 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 */

Line 164: PA_DEBUG.G_Err_Stage := '50 : L_FC_START_DATE ' || l_fc_start_date;

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 ';

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

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);

Line 166: PA_DEBUG.G_Err_Stage := '100 : L_FC_END_DATE ' || l_fc_end_date;

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;

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

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);

Line 168: PA_DEBUG.G_Err_Stage := '150 : After checking the flags ';

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;

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

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);

Line 170: PA_DEBUG.G_Err_Stage := '200 : L_PA_PERIOD_FLAG ' || l_pa_period_flag;

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;

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

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);

Line 172: PA_DEBUG.G_Err_Stage := '250 : L_GL_PERIOD_FLAG ' || l_gl_period_flag;

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;

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

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:

Line 174: PA_DEBUG.G_Err_Stage := '300 : L_GE_PERIOD_FLAG ' || l_ge_period_flag;

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: /*

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

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

Line 186: PA_DEBUG.G_Err_Stage := '350 : Calling PAGLGE';

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

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

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 */

Line 192: PA_DEBUG.G_Err_Stage := '400 : Calling PAGL';

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;

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

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

Line 199: PA_DEBUG.G_Err_Stage := '450 : Calling PAGE';

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

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

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 */

Line 205: PA_DEBUG.G_Err_Stage := '500 : Calling PA';

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;

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

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

Line 213: PA_DEBUG.G_Err_Stage := '550 : Calling GLGE';

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

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

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 */

Line 219: PA_DEBUG.G_Err_Stage := '600 : Calling GL';

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;

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

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

Line 226: PA_DEBUG.G_Err_Stage := '650 : Calling GE';

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;

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

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 */

Line 232: PA_DEBUG.G_Err_Stage := '700 : After Calling the INSERT_PROC_[PA][GL][GE]';

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: /*

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

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

Line 253: PA_DEBUG.G_Err_Stage := '750 : Records Inserted in Temp tab : ' || l_records_inserted;

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;

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

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:

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

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

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

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 */

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

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;

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

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:

Line 283: PA_DEBUG.G_Err_Stage := '800 : Records Updated in PA_FORECAST_ITEMS_DETAILS : '|| l_records_updated;

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

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

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'.

Line 311: PA_DEBUG.G_Err_Stage := '850 : Process Method : ' || l_process_method;

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;

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

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:

Line 313: PA_DEBUG.G_Err_Stage := '900 : Before calling PA_REP_UTILS_SUMM_PKG';

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: --

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

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.

Line 325: PA_DEBUG.G_Err_Stage := '950 : After calling PA_REP_UTILS_SUMM_PKG';

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):

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

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

Line 349: PA_DEBUG.G_Err_Stage := '1000 : Records Deleted from PA_FORECAST_ITEM_DETAILS: ' || to_char(SQL%ROWCOUNT);

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 */

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

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 ;

Line 351: PA_DEBUG.G_Err_Stage := '1050 : After deleting from PA_FORECAST_ITEM_DETAILS for 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);

Line 352: 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 */

Line 354: PA_DEBUG.G_Err_Stage := '1050 : process method = ' || l_process_method ;

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: --

Line 355: 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: --
359: UPDATE pa_forecast_item_details

Line 373: PA_DEBUG.G_Err_Stage := '1100 : Records Updated in PA_FORECAST_ITEM_DETAILS: ' || to_char(SQL%ROWCOUNT);

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;

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

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: --

Line 375: PA_DEBUG.G_Err_Stage := '1150 : After Updating PA_FORECAST_ITEM_DETAILS for process method ' || l_process_method ;

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: /*

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

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

Line 387: PA_DEBUG.G_Err_Stage := '1300 : Records Deleted from PA_FORECAST_ITEM_DETAILS: ' || to_char(SQL%ROWCOUNT);

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:

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

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 */

Line 389: PA_DEBUG.G_Err_Stage := '1350 : After deleting from PA_FORECAST_ITEM_DETAILS for process method ' || l_process_method ;

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 ;

Line 390: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);*/

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);

Line 393: PA_DEBUG.G_Err_Stage := '1350 : process method = ' || l_process_method ;

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: --

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

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

Line 411: PA_DEBUG.G_Err_Stage := '1400 : Records Updated in PA_FORECAST_ITEM_DETAILS: ' || to_char(SQL%ROWCOUNT);

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;

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

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: --

Line 413: PA_DEBUG.G_Err_Stage := '1450 : After Updating PA_FORECAST_ITEM_DETAILS for process method ' || l_process_method ;

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: /*

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

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

Line 438: PA_DEBUG.G_Err_Stage := '1600 : After calling Organization Utilization Forecast Refresh Rollup';

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: --

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

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.

Line 470: PA_DEBUG.G_Err_Stage := '1650 : After updating PA_UTILIZATION_OPTIONS_ALL';

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

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

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;

Line 472: PA_DEBUG.g_err_stage := '1660: Exiting the Package PA_SUMMARIZE_FORECAST_UTIL';

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:

Line 475: PA_DEBUG.Reset_Curr_Function;

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 */

Line 480: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stack);

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:

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

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;

Line 496: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_Fcst_Into_Tmp_PA');

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

Line 498: PA_DEBUG.G_Err_Stage := '2000 : Before Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for PA';

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

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

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:

Line 580: PA_DEBUG.G_Err_Stage := '2050 : After Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for PA';

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

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

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;

Line 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;

Line 601: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_Fcst_Into_Tmp_GL');

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;

Line 603: PA_DEBUG.G_Err_Stage := '2100 : Before Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for GL';

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

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

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

Line 686: PA_DEBUG.G_Err_Stage := '2150 : After Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for GL';

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

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

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;

Line 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;

Line 707: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_Fcst_Into_Tmp_GE');

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);

Line 710: PA_DEBUG.G_Err_Stage := '2200 : Before Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for GE';

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

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

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

Line 786: PA_DEBUG.G_Err_Stage := '2250 : After Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for GE';

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

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

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;

Line 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;

Line 807: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_Fcst_Into_Tmp_PAGL');

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);

Line 810: PA_DEBUG.G_Err_Stage := '2300 : Before Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for PA and GL';

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

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

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

Line 897: PA_DEBUG.G_Err_Stage := '2350 : After Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for PA and GL';

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

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

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;

Line 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;

Line 918: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_Fcst_Into_Tmp_PAGE');

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);

Line 921: PA_DEBUG.G_Err_Stage := '2400 : Before Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for PA and GE';

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

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

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

Line 1002: PA_DEBUG.G_Err_Stage := '2450 : After Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for PA and GE';

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

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

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;

Line 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;

Line 1023: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_Fcst_Into_Tmp_GLGE');

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);

Line 1026: PA_DEBUG.G_Err_Stage := '2500 : Before Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for GL and GE';

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

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

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

Line 1107: PA_DEBUG.G_Err_Stage := '2550 : After Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for GL and GE';

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

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

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;

Line 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;

Line 1128: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_Fcst_Into_Tmp_PAGLGE');

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;

Line 1130: PA_DEBUG.G_Err_Stage := '2600 : Before Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for PA, GL and GE';

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

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

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

Line 1218: PA_DEBUG.G_Err_Stage := '2650 : After Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for PA, GL and GE';

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

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

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;

Line 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;