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

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

8: -- End of Comments
9:
10: /* 20-Mar-2002 SManivannan Added Procedure Get_Tp_Amount_Type */
11:
12: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
13:
14: PROCEDURE get_forecast_option_details
15: ( x_fcst_period_type OUT NOCOPY pa_forecasting_options_all.org_fcst_period_type%TYPE --File.Sql.39 bug 4440895
16: ,x_period_set_name OUT NOCOPY pa_implementations_all.period_set_name%TYPE --File.Sql.39 bug 4440895

Line 69: IF P_PA_DEBUG_MODE = 'Y' THEN

65: AND gp.adjustment_period_flag = 'N'
66: ORDER BY gp.start_date;
67:
68: BEGIN
69: IF P_PA_DEBUG_MODE = 'Y' THEN
70: pa_debug.init_err_stack('PA_FP_ORG_FCST_UTILS.get_forecast_option_details');
71: END IF;
72:
73: --fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

Line 70: pa_debug.init_err_stack('PA_FP_ORG_FCST_UTILS.get_forecast_option_details');

66: ORDER BY gp.start_date;
67:
68: BEGIN
69: IF P_PA_DEBUG_MODE = 'Y' THEN
70: pa_debug.init_err_stack('PA_FP_ORG_FCST_UTILS.get_forecast_option_details');
71: END IF;
72:
73: --fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
74: l_debug_mode := 'Y';

Line 73: --fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

69: IF P_PA_DEBUG_MODE = 'Y' THEN
70: pa_debug.init_err_stack('PA_FP_ORG_FCST_UTILS.get_forecast_option_details');
71: END IF;
72:
73: --fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
74: l_debug_mode := 'Y';
75:
76: IF P_PA_DEBUG_MODE = 'Y' THEN
77: pa_debug.set_process('get_forecast_option_details: ' || 'PLSQL','LOG',l_debug_mode);

Line 76: IF P_PA_DEBUG_MODE = 'Y' THEN

72:
73: --fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
74: l_debug_mode := 'Y';
75:
76: IF P_PA_DEBUG_MODE = 'Y' THEN
77: pa_debug.set_process('get_forecast_option_details: ' || 'PLSQL','LOG',l_debug_mode);
78: END IF;
79:
80: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 77: pa_debug.set_process('get_forecast_option_details: ' || 'PLSQL','LOG',l_debug_mode);

73: --fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
74: l_debug_mode := 'Y';
75:
76: IF P_PA_DEBUG_MODE = 'Y' THEN
77: pa_debug.set_process('get_forecast_option_details: ' || 'PLSQL','LOG',l_debug_mode);
78: END IF;
79:
80: x_return_status := FND_API.G_RET_STS_SUCCESS;
81:

Line 82: IF P_PA_DEBUG_MODE = 'Y' THEN

78: END IF;
79:
80: x_return_status := FND_API.G_RET_STS_SUCCESS;
81:
82: IF P_PA_DEBUG_MODE = 'Y' THEN
83: pa_debug.write_file('Entered PA_FP_ORG_FCST_UTILS.get_forecast_option_details');
84: pa_debug.write_file('get_forecast_option_details: ' || pa_debug.g_err_stage);
85: END IF;
86: l_stage := 100;

Line 83: pa_debug.write_file('Entered PA_FP_ORG_FCST_UTILS.get_forecast_option_details');

79:
80: x_return_status := FND_API.G_RET_STS_SUCCESS;
81:
82: IF P_PA_DEBUG_MODE = 'Y' THEN
83: pa_debug.write_file('Entered PA_FP_ORG_FCST_UTILS.get_forecast_option_details');
84: pa_debug.write_file('get_forecast_option_details: ' || pa_debug.g_err_stage);
85: END IF;
86: l_stage := 100;
87:

Line 84: pa_debug.write_file('get_forecast_option_details: ' || pa_debug.g_err_stage);

80: x_return_status := FND_API.G_RET_STS_SUCCESS;
81:
82: IF P_PA_DEBUG_MODE = 'Y' THEN
83: pa_debug.write_file('Entered PA_FP_ORG_FCST_UTILS.get_forecast_option_details');
84: pa_debug.write_file('get_forecast_option_details: ' || pa_debug.g_err_stage);
85: END IF;
86: l_stage := 100;
87:
88: SELECT nvl(org_id,-99),

Line 196: IF P_PA_DEBUG_MODE = 'Y' THEN

192: l_org_id IS NULL THEN
193: x_return_status := FND_API.G_RET_STS_ERROR;
194: x_err_code := -1;
195: END IF;
196: IF P_PA_DEBUG_MODE = 'Y' THEN
197: pa_debug.write_file('Leaving PA_FP_ORG_FCST_UTILS.get_forecast_option_details');
198: pa_debug.write_file('get_forecast_option_details: ' || pa_debug.g_err_stage);
199: END IF;
200: pa_debug.reset_err_stack;

Line 197: pa_debug.write_file('Leaving PA_FP_ORG_FCST_UTILS.get_forecast_option_details');

193: x_return_status := FND_API.G_RET_STS_ERROR;
194: x_err_code := -1;
195: END IF;
196: IF P_PA_DEBUG_MODE = 'Y' THEN
197: pa_debug.write_file('Leaving PA_FP_ORG_FCST_UTILS.get_forecast_option_details');
198: pa_debug.write_file('get_forecast_option_details: ' || pa_debug.g_err_stage);
199: END IF;
200: pa_debug.reset_err_stack;
201: EXCEPTION

Line 198: pa_debug.write_file('get_forecast_option_details: ' || pa_debug.g_err_stage);

194: x_err_code := -1;
195: END IF;
196: IF P_PA_DEBUG_MODE = 'Y' THEN
197: pa_debug.write_file('Leaving PA_FP_ORG_FCST_UTILS.get_forecast_option_details');
198: pa_debug.write_file('get_forecast_option_details: ' || pa_debug.g_err_stage);
199: END IF;
200: pa_debug.reset_err_stack;
201: EXCEPTION
202: WHEN OTHERS THEN

Line 200: pa_debug.reset_err_stack;

196: IF P_PA_DEBUG_MODE = 'Y' THEN
197: pa_debug.write_file('Leaving PA_FP_ORG_FCST_UTILS.get_forecast_option_details');
198: pa_debug.write_file('get_forecast_option_details: ' || pa_debug.g_err_stage);
199: END IF;
200: pa_debug.reset_err_stack;
201: EXCEPTION
202: WHEN OTHERS THEN
203: FND_MSG_PUB.add_exc_msg(
204: p_pkg_name => 'PA_FP_ORG_FCST_UTILS.get_forecast_options_details'

Line 205: ,p_procedure_name => PA_DEBUG.G_Err_Stack);

201: EXCEPTION
202: WHEN OTHERS THEN
203: FND_MSG_PUB.add_exc_msg(
204: p_pkg_name => 'PA_FP_ORG_FCST_UTILS.get_forecast_options_details'
205: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
206:
207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
208: x_err_code := SQLERRM;
209: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 209: IF P_PA_DEBUG_MODE = 'Y' THEN

205: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
206:
207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
208: x_err_code := SQLERRM;
209: IF P_PA_DEBUG_MODE = 'Y' THEN
210: pa_debug.write_file('get_forecast_option_details: ' || SQLERRM);
211: END IF;
212: pa_debug.reset_err_stack;
213: END get_forecast_option_details;

Line 210: pa_debug.write_file('get_forecast_option_details: ' || SQLERRM);

206:
207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
208: x_err_code := SQLERRM;
209: IF P_PA_DEBUG_MODE = 'Y' THEN
210: pa_debug.write_file('get_forecast_option_details: ' || SQLERRM);
211: END IF;
212: pa_debug.reset_err_stack;
213: END get_forecast_option_details;
214:

Line 212: pa_debug.reset_err_stack;

208: x_err_code := SQLERRM;
209: IF P_PA_DEBUG_MODE = 'Y' THEN
210: pa_debug.write_file('get_forecast_option_details: ' || SQLERRM);
211: END IF;
212: pa_debug.reset_err_stack;
213: END get_forecast_option_details;
214:
215: PROCEDURE get_org_project_info
216: ( p_organization_id IN hr_organization_units.organization_id%TYPE

Line 226: IF P_PA_DEBUG_MODE = 'Y' THEN

222: l_stage NUMBER := 0;
223: l_debug_mode VARCHAR2(30);
224:
225: BEGIN
226: IF P_PA_DEBUG_MODE = 'Y' THEN
227: pa_debug.init_err_stack('PA_FP_ORG_FCST_UTILS.get_org_project_info');
228: END IF;
229:
230: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

Line 227: pa_debug.init_err_stack('PA_FP_ORG_FCST_UTILS.get_org_project_info');

223: l_debug_mode VARCHAR2(30);
224:
225: BEGIN
226: IF P_PA_DEBUG_MODE = 'Y' THEN
227: pa_debug.init_err_stack('PA_FP_ORG_FCST_UTILS.get_org_project_info');
228: END IF;
229:
230: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
231: l_debug_mode := NVL(l_debug_mode, 'Y');

Line 230: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

226: IF P_PA_DEBUG_MODE = 'Y' THEN
227: pa_debug.init_err_stack('PA_FP_ORG_FCST_UTILS.get_org_project_info');
228: END IF;
229:
230: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
231: l_debug_mode := NVL(l_debug_mode, 'Y');
232:
233: IF P_PA_DEBUG_MODE = 'Y' THEN
234: pa_debug.set_process('get_org_project_info: ' || 'PLSQL','LOG',l_debug_mode);

Line 233: IF P_PA_DEBUG_MODE = 'Y' THEN

229:
230: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
231: l_debug_mode := NVL(l_debug_mode, 'Y');
232:
233: IF P_PA_DEBUG_MODE = 'Y' THEN
234: pa_debug.set_process('get_org_project_info: ' || 'PLSQL','LOG',l_debug_mode);
235: END IF;
236:
237: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 234: pa_debug.set_process('get_org_project_info: ' || 'PLSQL','LOG',l_debug_mode);

230: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
231: l_debug_mode := NVL(l_debug_mode, 'Y');
232:
233: IF P_PA_DEBUG_MODE = 'Y' THEN
234: pa_debug.set_process('get_org_project_info: ' || 'PLSQL','LOG',l_debug_mode);
235: END IF;
236:
237: x_return_status := FND_API.G_RET_STS_SUCCESS;
238:

Line 240: pa_debug.g_err_stage := 'Entered PA_FP_ORG_FCST_UTILS.get_org_project_info for Org ['||p_organization_id ||

236:
237: x_return_status := FND_API.G_RET_STS_SUCCESS;
238:
239: l_stage := 100;
240: pa_debug.g_err_stage := 'Entered PA_FP_ORG_FCST_UTILS.get_org_project_info for Org ['||p_organization_id ||
241: ']';
242: IF P_PA_DEBUG_MODE = 'Y' THEN
243: pa_debug.write_file('get_org_project_info: ' || pa_debug.g_err_stage);
244: END IF;

Line 242: IF P_PA_DEBUG_MODE = 'Y' THEN

238:
239: l_stage := 100;
240: pa_debug.g_err_stage := 'Entered PA_FP_ORG_FCST_UTILS.get_org_project_info for Org ['||p_organization_id ||
241: ']';
242: IF P_PA_DEBUG_MODE = 'Y' THEN
243: pa_debug.write_file('get_org_project_info: ' || pa_debug.g_err_stage);
244: END IF;
245:
246: /* bug 3106741 though template_flag is a nullable column care has been taken to populate the column always.

Line 243: pa_debug.write_file('get_org_project_info: ' || pa_debug.g_err_stage);

239: l_stage := 100;
240: pa_debug.g_err_stage := 'Entered PA_FP_ORG_FCST_UTILS.get_org_project_info for Org ['||p_organization_id ||
241: ']';
242: IF P_PA_DEBUG_MODE = 'Y' THEN
243: pa_debug.write_file('get_org_project_info: ' || pa_debug.g_err_stage);
244: END IF;
245:
246: /* bug 3106741 though template_flag is a nullable column care has been taken to populate the column always.
247: so removed NVL for performance reasons

Line 259: pa_debug.g_err_stage := 'Leaving PA_FP_ORG_FCST_UTILS.get_org_project_info';

255: WHERE ppt.org_project_flag = 'Y')
256: AND pp.template_flag = 'N';
257: -- bug 3106741 AND NVL(pp.template_flag,'N') = 'N';
258:
259: pa_debug.g_err_stage := 'Leaving PA_FP_ORG_FCST_UTILS.get_org_project_info';
260: IF P_PA_DEBUG_MODE = 'Y' THEN
261: pa_debug.write_file('get_org_project_info: ' || pa_debug.g_err_stage);
262: END IF;
263: pa_debug.reset_err_stack;

Line 260: IF P_PA_DEBUG_MODE = 'Y' THEN

256: AND pp.template_flag = 'N';
257: -- bug 3106741 AND NVL(pp.template_flag,'N') = 'N';
258:
259: pa_debug.g_err_stage := 'Leaving PA_FP_ORG_FCST_UTILS.get_org_project_info';
260: IF P_PA_DEBUG_MODE = 'Y' THEN
261: pa_debug.write_file('get_org_project_info: ' || pa_debug.g_err_stage);
262: END IF;
263: pa_debug.reset_err_stack;
264: EXCEPTION

Line 261: pa_debug.write_file('get_org_project_info: ' || pa_debug.g_err_stage);

257: -- bug 3106741 AND NVL(pp.template_flag,'N') = 'N';
258:
259: pa_debug.g_err_stage := 'Leaving PA_FP_ORG_FCST_UTILS.get_org_project_info';
260: IF P_PA_DEBUG_MODE = 'Y' THEN
261: pa_debug.write_file('get_org_project_info: ' || pa_debug.g_err_stage);
262: END IF;
263: pa_debug.reset_err_stack;
264: EXCEPTION
265: WHEN NO_DATA_FOUND THEN

Line 263: pa_debug.reset_err_stack;

259: pa_debug.g_err_stage := 'Leaving PA_FP_ORG_FCST_UTILS.get_org_project_info';
260: IF P_PA_DEBUG_MODE = 'Y' THEN
261: pa_debug.write_file('get_org_project_info: ' || pa_debug.g_err_stage);
262: END IF;
263: pa_debug.reset_err_stack;
264: EXCEPTION
265: WHEN NO_DATA_FOUND THEN
266: x_org_project_id := -9999;
267: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 267: IF P_PA_DEBUG_MODE = 'Y' THEN

263: pa_debug.reset_err_stack;
264: EXCEPTION
265: WHEN NO_DATA_FOUND THEN
266: x_org_project_id := -9999;
267: IF P_PA_DEBUG_MODE = 'Y' THEN
268: pa_debug.write_file('get_org_project_info: ' || 'Org Project Not Found for organization Id = '
269: ||p_organization_id);
270: END IF;
271: pa_debug.reset_err_stack;

Line 268: pa_debug.write_file('get_org_project_info: ' || 'Org Project Not Found for organization Id = '

264: EXCEPTION
265: WHEN NO_DATA_FOUND THEN
266: x_org_project_id := -9999;
267: IF P_PA_DEBUG_MODE = 'Y' THEN
268: pa_debug.write_file('get_org_project_info: ' || 'Org Project Not Found for organization Id = '
269: ||p_organization_id);
270: END IF;
271: pa_debug.reset_err_stack;
272: WHEN OTHERS THEN

Line 271: pa_debug.reset_err_stack;

267: IF P_PA_DEBUG_MODE = 'Y' THEN
268: pa_debug.write_file('get_org_project_info: ' || 'Org Project Not Found for organization Id = '
269: ||p_organization_id);
270: END IF;
271: pa_debug.reset_err_stack;
272: WHEN OTHERS THEN
273: FND_MSG_PUB.add_exc_msg(
274: p_pkg_name => 'PA_FP_ORG_FCST_UTILS.org_project_exists'
275: ,p_procedure_name => PA_DEBUG.G_Err_Stack);

Line 275: ,p_procedure_name => PA_DEBUG.G_Err_Stack);

271: pa_debug.reset_err_stack;
272: WHEN OTHERS THEN
273: FND_MSG_PUB.add_exc_msg(
274: p_pkg_name => 'PA_FP_ORG_FCST_UTILS.org_project_exists'
275: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
276:
277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
278: x_err_code := SQLERRM;
279: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 279: IF P_PA_DEBUG_MODE = 'Y' THEN

275: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
276:
277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
278: x_err_code := SQLERRM;
279: IF P_PA_DEBUG_MODE = 'Y' THEN
280: pa_debug.write_file('get_org_project_info: ' || SQLERRM);
281: END IF;
282: pa_debug.reset_err_stack;
283: END get_org_project_info;

Line 280: pa_debug.write_file('get_org_project_info: ' || SQLERRM);

276:
277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
278: x_err_code := SQLERRM;
279: IF P_PA_DEBUG_MODE = 'Y' THEN
280: pa_debug.write_file('get_org_project_info: ' || SQLERRM);
281: END IF;
282: pa_debug.reset_err_stack;
283: END get_org_project_info;
284:

Line 282: pa_debug.reset_err_stack;

278: x_err_code := SQLERRM;
279: IF P_PA_DEBUG_MODE = 'Y' THEN
280: pa_debug.write_file('get_org_project_info: ' || SQLERRM);
281: END IF;
282: pa_debug.reset_err_stack;
283: END get_org_project_info;
284:
285: PROCEDURE get_org_task_info
286: ( p_project_id IN pa_projects_all.project_id%TYPE

Line 306: IF P_PA_DEBUG_MODE = 'Y' THEN

302: l_stage NUMBER := 0;
303:
304: BEGIN
305: BEGIN
306: IF P_PA_DEBUG_MODE = 'Y' THEN
307: pa_debug.init_err_stack('PA_FP_ORG_FCST_UTILS.get_org_task_info');
308: END IF;
309:
310: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

Line 307: pa_debug.init_err_stack('PA_FP_ORG_FCST_UTILS.get_org_task_info');

303:
304: BEGIN
305: BEGIN
306: IF P_PA_DEBUG_MODE = 'Y' THEN
307: pa_debug.init_err_stack('PA_FP_ORG_FCST_UTILS.get_org_task_info');
308: END IF;
309:
310: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
311: l_debug_mode := NVL(l_debug_mode, 'Y');

Line 310: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

306: IF P_PA_DEBUG_MODE = 'Y' THEN
307: pa_debug.init_err_stack('PA_FP_ORG_FCST_UTILS.get_org_task_info');
308: END IF;
309:
310: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
311: l_debug_mode := NVL(l_debug_mode, 'Y');
312:
313: IF P_PA_DEBUG_MODE = 'Y' THEN
314: pa_debug.set_process('get_org_task_info: ' || 'PLSQL','LOG',l_debug_mode);

Line 313: IF P_PA_DEBUG_MODE = 'Y' THEN

309:
310: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
311: l_debug_mode := NVL(l_debug_mode, 'Y');
312:
313: IF P_PA_DEBUG_MODE = 'Y' THEN
314: pa_debug.set_process('get_org_task_info: ' || 'PLSQL','LOG',l_debug_mode);
315: END IF;
316:
317: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 314: pa_debug.set_process('get_org_task_info: ' || 'PLSQL','LOG',l_debug_mode);

310: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
311: l_debug_mode := NVL(l_debug_mode, 'Y');
312:
313: IF P_PA_DEBUG_MODE = 'Y' THEN
314: pa_debug.set_process('get_org_task_info: ' || 'PLSQL','LOG',l_debug_mode);
315: END IF;
316:
317: x_return_status := FND_API.G_RET_STS_SUCCESS;
318:

Line 320: pa_debug.g_err_stage := 'Entered PA_FP_ORG_FCST_UTILS.get_org_task_info for Project ['||p_project_id || ']';

316:
317: x_return_status := FND_API.G_RET_STS_SUCCESS;
318:
319: l_stage := 100;
320: pa_debug.g_err_stage := 'Entered PA_FP_ORG_FCST_UTILS.get_org_task_info for Project ['||p_project_id || ']';
321: IF P_PA_DEBUG_MODE = 'Y' THEN
322: pa_debug.write_file('get_org_task_info: ' || pa_debug.g_err_stage);
323: END IF;
324:

Line 321: IF P_PA_DEBUG_MODE = 'Y' THEN

317: x_return_status := FND_API.G_RET_STS_SUCCESS;
318:
319: l_stage := 100;
320: pa_debug.g_err_stage := 'Entered PA_FP_ORG_FCST_UTILS.get_org_task_info for Project ['||p_project_id || ']';
321: IF P_PA_DEBUG_MODE = 'Y' THEN
322: pa_debug.write_file('get_org_task_info: ' || pa_debug.g_err_stage);
323: END IF;
324:
325: OPEN own_task;

Line 322: pa_debug.write_file('get_org_task_info: ' || pa_debug.g_err_stage);

318:
319: l_stage := 100;
320: pa_debug.g_err_stage := 'Entered PA_FP_ORG_FCST_UTILS.get_org_task_info for Project ['||p_project_id || ']';
321: IF P_PA_DEBUG_MODE = 'Y' THEN
322: pa_debug.write_file('get_org_task_info: ' || pa_debug.g_err_stage);
323: END IF;
324:
325: OPEN own_task;
326: FETCH own_task into x_org_task_id, x_organization_id;

Line 329: pa_debug.g_err_stage := 'Leaving PA_FP_ORG_FCST_UTILS.get_org_task_info';

325: OPEN own_task;
326: FETCH own_task into x_org_task_id, x_organization_id;
327: CLOSE own_task;
328: l_stage := 200;
329: pa_debug.g_err_stage := 'Leaving PA_FP_ORG_FCST_UTILS.get_org_task_info';
330: IF P_PA_DEBUG_MODE = 'Y' THEN
331: pa_debug.write_file('get_org_task_info: ' || pa_debug.g_err_stage);
332: END IF;
333: pa_debug.reset_err_stack;

Line 330: IF P_PA_DEBUG_MODE = 'Y' THEN

326: FETCH own_task into x_org_task_id, x_organization_id;
327: CLOSE own_task;
328: l_stage := 200;
329: pa_debug.g_err_stage := 'Leaving PA_FP_ORG_FCST_UTILS.get_org_task_info';
330: IF P_PA_DEBUG_MODE = 'Y' THEN
331: pa_debug.write_file('get_org_task_info: ' || pa_debug.g_err_stage);
332: END IF;
333: pa_debug.reset_err_stack;
334:

Line 331: pa_debug.write_file('get_org_task_info: ' || pa_debug.g_err_stage);

327: CLOSE own_task;
328: l_stage := 200;
329: pa_debug.g_err_stage := 'Leaving PA_FP_ORG_FCST_UTILS.get_org_task_info';
330: IF P_PA_DEBUG_MODE = 'Y' THEN
331: pa_debug.write_file('get_org_task_info: ' || pa_debug.g_err_stage);
332: END IF;
333: pa_debug.reset_err_stack;
334:
335: EXCEPTION

Line 333: pa_debug.reset_err_stack;

329: pa_debug.g_err_stage := 'Leaving PA_FP_ORG_FCST_UTILS.get_org_task_info';
330: IF P_PA_DEBUG_MODE = 'Y' THEN
331: pa_debug.write_file('get_org_task_info: ' || pa_debug.g_err_stage);
332: END IF;
333: pa_debug.reset_err_stack;
334:
335: EXCEPTION
336: WHEN NO_DATA_FOUND THEN
337: x_org_task_id := -9999;

Line 341: IF P_PA_DEBUG_MODE = 'Y' THEN

337: x_org_task_id := -9999;
338: x_organization_id := -9999;
339: x_return_status := FND_API.G_RET_STS_ERROR;
340: x_err_code := SQLERRM;
341: IF P_PA_DEBUG_MODE = 'Y' THEN
342: pa_debug.write_file('get_org_task_info: ' || 'Org Own Task Not Found');
343: END IF;
344: pa_debug.reset_err_stack;
345: END;

Line 342: pa_debug.write_file('get_org_task_info: ' || 'Org Own Task Not Found');

338: x_organization_id := -9999;
339: x_return_status := FND_API.G_RET_STS_ERROR;
340: x_err_code := SQLERRM;
341: IF P_PA_DEBUG_MODE = 'Y' THEN
342: pa_debug.write_file('get_org_task_info: ' || 'Org Own Task Not Found');
343: END IF;
344: pa_debug.reset_err_stack;
345: END;
346: EXCEPTION

Line 344: pa_debug.reset_err_stack;

340: x_err_code := SQLERRM;
341: IF P_PA_DEBUG_MODE = 'Y' THEN
342: pa_debug.write_file('get_org_task_info: ' || 'Org Own Task Not Found');
343: END IF;
344: pa_debug.reset_err_stack;
345: END;
346: EXCEPTION
347: WHEN OTHERS THEN
348: FND_MSG_PUB.add_exc_msg(

Line 350: ,p_procedure_name => PA_DEBUG.G_Err_Stack);

346: EXCEPTION
347: WHEN OTHERS THEN
348: FND_MSG_PUB.add_exc_msg(
349: p_pkg_name => 'PA_FP_ORG_FCST_UTILS.org_project_exists'
350: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
351:
352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
353: x_err_code := SQLERRM;
354: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 354: IF P_PA_DEBUG_MODE = 'Y' THEN

350: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
351:
352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
353: x_err_code := SQLERRM;
354: IF P_PA_DEBUG_MODE = 'Y' THEN
355: pa_debug.write_file('get_org_task_info: ' || SQLERRM);
356: END IF;
357: pa_debug.reset_err_stack;
358: END get_org_task_info;

Line 355: pa_debug.write_file('get_org_task_info: ' || SQLERRM);

351:
352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
353: x_err_code := SQLERRM;
354: IF P_PA_DEBUG_MODE = 'Y' THEN
355: pa_debug.write_file('get_org_task_info: ' || SQLERRM);
356: END IF;
357: pa_debug.reset_err_stack;
358: END get_org_task_info;
359:

Line 357: pa_debug.reset_err_stack;

353: x_err_code := SQLERRM;
354: IF P_PA_DEBUG_MODE = 'Y' THEN
355: pa_debug.write_file('get_org_task_info: ' || SQLERRM);
356: END IF;
357: pa_debug.reset_err_stack;
358: END get_org_task_info;
359:
360: PROCEDURE get_utilization_details
361: ( p_org_id IN pa_implementations_all.org_id%TYPE

Line 416: IF P_PA_DEBUG_MODE = 'Y' THEN

412:
413: l_stage NUMBER := 0;
414:
415: BEGIN
416: IF P_PA_DEBUG_MODE = 'Y' THEN
417: pa_debug.init_err_stack('PA_FP_ORG_FCST_UTILS.get_utilization_details');
418: END IF;
419:
420: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

Line 417: pa_debug.init_err_stack('PA_FP_ORG_FCST_UTILS.get_utilization_details');

413: l_stage NUMBER := 0;
414:
415: BEGIN
416: IF P_PA_DEBUG_MODE = 'Y' THEN
417: pa_debug.init_err_stack('PA_FP_ORG_FCST_UTILS.get_utilization_details');
418: END IF;
419:
420: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
421: l_debug_mode := NVL(l_debug_mode, 'Y');

Line 420: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

416: IF P_PA_DEBUG_MODE = 'Y' THEN
417: pa_debug.init_err_stack('PA_FP_ORG_FCST_UTILS.get_utilization_details');
418: END IF;
419:
420: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
421: l_debug_mode := NVL(l_debug_mode, 'Y');
422:
423: IF P_PA_DEBUG_MODE = 'Y' THEN
424: pa_debug.set_process('get_utilization_details: ' || 'PLSQL','LOG',l_debug_mode);

Line 423: IF P_PA_DEBUG_MODE = 'Y' THEN

419:
420: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
421: l_debug_mode := NVL(l_debug_mode, 'Y');
422:
423: IF P_PA_DEBUG_MODE = 'Y' THEN
424: pa_debug.set_process('get_utilization_details: ' || 'PLSQL','LOG',l_debug_mode);
425: END IF;
426:
427: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 424: pa_debug.set_process('get_utilization_details: ' || 'PLSQL','LOG',l_debug_mode);

420: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
421: l_debug_mode := NVL(l_debug_mode, 'Y');
422:
423: IF P_PA_DEBUG_MODE = 'Y' THEN
424: pa_debug.set_process('get_utilization_details: ' || 'PLSQL','LOG',l_debug_mode);
425: END IF;
426:
427: x_return_status := FND_API.G_RET_STS_SUCCESS;
428:

Line 468: pa_debug.g_err_stage := 'x_utl_hours ['||x_utl_hours ||

464: x_utl_capacity := l_capacity - l_reduced_capacity;
465: x_utl_percent := (l_hours/(l_capacity-l_reduced_capacity))*100;
466: END IF;
467: /*
468: pa_debug.g_err_stage := 'x_utl_hours ['||x_utl_hours ||
469: '] x_utl_capacity ['||x_utl_capacity ||
470: '] x_utl_percent ['||x_utl_percent ||
471: ']';
472: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 472: IF P_PA_DEBUG_MODE = 'Y' THEN

468: pa_debug.g_err_stage := 'x_utl_hours ['||x_utl_hours ||
469: '] x_utl_capacity ['||x_utl_capacity ||
470: '] x_utl_percent ['||x_utl_percent ||
471: ']';
472: IF P_PA_DEBUG_MODE = 'Y' THEN
473: pa_debug.write_file('get_utilization_details: ' || pa_debug.g_err_stage);
474: END IF;
475: */
476: pa_debug.reset_err_stack;

Line 473: pa_debug.write_file('get_utilization_details: ' || pa_debug.g_err_stage);

469: '] x_utl_capacity ['||x_utl_capacity ||
470: '] x_utl_percent ['||x_utl_percent ||
471: ']';
472: IF P_PA_DEBUG_MODE = 'Y' THEN
473: pa_debug.write_file('get_utilization_details: ' || pa_debug.g_err_stage);
474: END IF;
475: */
476: pa_debug.reset_err_stack;
477: EXCEPTION

Line 476: pa_debug.reset_err_stack;

472: IF P_PA_DEBUG_MODE = 'Y' THEN
473: pa_debug.write_file('get_utilization_details: ' || pa_debug.g_err_stage);
474: END IF;
475: */
476: pa_debug.reset_err_stack;
477: EXCEPTION
478: WHEN OTHERS THEN
479: FND_MSG_PUB.add_exc_msg(
480: p_pkg_name => 'PA_FP_ORG_FCST_UTILS.get_utilization_details'

Line 481: ,p_procedure_name => PA_DEBUG.G_Err_Stack);

477: EXCEPTION
478: WHEN OTHERS THEN
479: FND_MSG_PUB.add_exc_msg(
480: p_pkg_name => 'PA_FP_ORG_FCST_UTILS.get_utilization_details'
481: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
482:
483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
484: x_err_code := SQLERRM;
485: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 485: IF P_PA_DEBUG_MODE = 'Y' THEN

481: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
482:
483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
484: x_err_code := SQLERRM;
485: IF P_PA_DEBUG_MODE = 'Y' THEN
486: pa_debug.write_file('get_utilization_details: ' || SQLERRM);
487: END IF;
488: pa_debug.reset_err_stack;
489: END get_utilization_details;

Line 486: pa_debug.write_file('get_utilization_details: ' || SQLERRM);

482:
483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
484: x_err_code := SQLERRM;
485: IF P_PA_DEBUG_MODE = 'Y' THEN
486: pa_debug.write_file('get_utilization_details: ' || SQLERRM);
487: END IF;
488: pa_debug.reset_err_stack;
489: END get_utilization_details;
490:

Line 488: pa_debug.reset_err_stack;

484: x_err_code := SQLERRM;
485: IF P_PA_DEBUG_MODE = 'Y' THEN
486: pa_debug.write_file('get_utilization_details: ' || SQLERRM);
487: END IF;
488: pa_debug.reset_err_stack;
489: END get_utilization_details;
490:
491: PROCEDURE get_headcount
492: ( p_organization_id IN hr_organization_units.organization_id%TYPE

Line 521: IF P_PA_DEBUG_MODE = 'Y' THEN

517: AND nvl(pps.actual_termination_date,p_effective_date) >= p_effective_date;
518:
519:
520: BEGIN
521: IF P_PA_DEBUG_MODE = 'Y' THEN
522: pa_debug.init_err_stack('get_headcount: ' || 'PA_FP_ORG_FCST_UTILS.get_utilization_details');
523: END IF;
524:
525: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

Line 522: pa_debug.init_err_stack('get_headcount: ' || 'PA_FP_ORG_FCST_UTILS.get_utilization_details');

518:
519:
520: BEGIN
521: IF P_PA_DEBUG_MODE = 'Y' THEN
522: pa_debug.init_err_stack('get_headcount: ' || 'PA_FP_ORG_FCST_UTILS.get_utilization_details');
523: END IF;
524:
525: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
526: l_debug_mode := NVL(l_debug_mode, 'Y');

Line 525: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

521: IF P_PA_DEBUG_MODE = 'Y' THEN
522: pa_debug.init_err_stack('get_headcount: ' || 'PA_FP_ORG_FCST_UTILS.get_utilization_details');
523: END IF;
524:
525: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
526: l_debug_mode := NVL(l_debug_mode, 'Y');
527:
528: IF P_PA_DEBUG_MODE = 'Y' THEN
529: pa_debug.set_process('get_headcount: ' || 'PLSQL','LOG',l_debug_mode);

Line 528: IF P_PA_DEBUG_MODE = 'Y' THEN

524:
525: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
526: l_debug_mode := NVL(l_debug_mode, 'Y');
527:
528: IF P_PA_DEBUG_MODE = 'Y' THEN
529: pa_debug.set_process('get_headcount: ' || 'PLSQL','LOG',l_debug_mode);
530: END IF;
531:
532: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 529: pa_debug.set_process('get_headcount: ' || 'PLSQL','LOG',l_debug_mode);

525: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
526: l_debug_mode := NVL(l_debug_mode, 'Y');
527:
528: IF P_PA_DEBUG_MODE = 'Y' THEN
529: pa_debug.set_process('get_headcount: ' || 'PLSQL','LOG',l_debug_mode);
530: END IF;
531:
532: x_return_status := FND_API.G_RET_STS_SUCCESS;
533: /*

Line 534: pa_debug.g_err_stage := 'p_organization_id ['||p_organization_id ||

530: END IF;
531:
532: x_return_status := FND_API.G_RET_STS_SUCCESS;
533: /*
534: pa_debug.g_err_stage := 'p_organization_id ['||p_organization_id ||
535: '] p_effective_date ['||p_effective_date ||
536: ']';
537: IF P_PA_DEBUG_MODE = 'Y' THEN
538: pa_debug.write_file('get_headcount: ' || pa_debug.g_err_stage);

Line 537: IF P_PA_DEBUG_MODE = 'Y' THEN

533: /*
534: pa_debug.g_err_stage := 'p_organization_id ['||p_organization_id ||
535: '] p_effective_date ['||p_effective_date ||
536: ']';
537: IF P_PA_DEBUG_MODE = 'Y' THEN
538: pa_debug.write_file('get_headcount: ' || pa_debug.g_err_stage);
539: END IF;
540: */
541:

Line 538: pa_debug.write_file('get_headcount: ' || pa_debug.g_err_stage);

534: pa_debug.g_err_stage := 'p_organization_id ['||p_organization_id ||
535: '] p_effective_date ['||p_effective_date ||
536: ']';
537: IF P_PA_DEBUG_MODE = 'Y' THEN
538: pa_debug.write_file('get_headcount: ' || pa_debug.g_err_stage);
539: END IF;
540: */
541:
542: OPEN get_headcount;

Line 547: pa_debug.g_err_stage := 'x_headcount ['||x_headcount ||

543: FETCH get_headcount INTO x_headcount;
544: CLOSE get_headcount;
545:
546: /*
547: pa_debug.g_err_stage := 'x_headcount ['||x_headcount ||
548: ']';
549: IF P_PA_DEBUG_MODE = 'Y' THEN
550: pa_debug.write_file('get_headcount: ' || pa_debug.g_err_stage);
551: END IF;

Line 549: IF P_PA_DEBUG_MODE = 'Y' THEN

545:
546: /*
547: pa_debug.g_err_stage := 'x_headcount ['||x_headcount ||
548: ']';
549: IF P_PA_DEBUG_MODE = 'Y' THEN
550: pa_debug.write_file('get_headcount: ' || pa_debug.g_err_stage);
551: END IF;
552: */
553: pa_debug.reset_err_stack;

Line 550: pa_debug.write_file('get_headcount: ' || pa_debug.g_err_stage);

546: /*
547: pa_debug.g_err_stage := 'x_headcount ['||x_headcount ||
548: ']';
549: IF P_PA_DEBUG_MODE = 'Y' THEN
550: pa_debug.write_file('get_headcount: ' || pa_debug.g_err_stage);
551: END IF;
552: */
553: pa_debug.reset_err_stack;
554: EXCEPTION

Line 553: pa_debug.reset_err_stack;

549: IF P_PA_DEBUG_MODE = 'Y' THEN
550: pa_debug.write_file('get_headcount: ' || pa_debug.g_err_stage);
551: END IF;
552: */
553: pa_debug.reset_err_stack;
554: EXCEPTION
555: WHEN OTHERS THEN
556: FND_MSG_PUB.add_exc_msg(
557: p_pkg_name => 'PA_FP_ORG_FCST_UTILS.get_headcount'

Line 558: ,p_procedure_name => PA_DEBUG.G_Err_Stack);

554: EXCEPTION
555: WHEN OTHERS THEN
556: FND_MSG_PUB.add_exc_msg(
557: p_pkg_name => 'PA_FP_ORG_FCST_UTILS.get_headcount'
558: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
559:
560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
561: x_err_code := SQLERRM;
562: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 562: IF P_PA_DEBUG_MODE = 'Y' THEN

558: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
559:
560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
561: x_err_code := SQLERRM;
562: IF P_PA_DEBUG_MODE = 'Y' THEN
563: pa_debug.write_file('get_headcount: ' || SQLERRM);
564: END IF;
565: pa_debug.reset_err_stack;
566: END get_headcount;

Line 563: pa_debug.write_file('get_headcount: ' || SQLERRM);

559:
560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
561: x_err_code := SQLERRM;
562: IF P_PA_DEBUG_MODE = 'Y' THEN
563: pa_debug.write_file('get_headcount: ' || SQLERRM);
564: END IF;
565: pa_debug.reset_err_stack;
566: END get_headcount;
567:

Line 565: pa_debug.reset_err_stack;

561: x_err_code := SQLERRM;
562: IF P_PA_DEBUG_MODE = 'Y' THEN
563: pa_debug.write_file('get_headcount: ' || SQLERRM);
564: END IF;
565: pa_debug.reset_err_stack;
566: END get_headcount;
567:
568: PROCEDURE get_probability_percent
569: ( p_project_id IN pa_projects_all.project_id%TYPE

Line 578: IF P_PA_DEBUG_MODE = 'Y' THEN

574: IS
575: l_debug_mode VARCHAR2(30);
576: l_probability_member_id pa_projects_all.probability_member_id%TYPE;
577: BEGIN
578: IF P_PA_DEBUG_MODE = 'Y' THEN
579: pa_debug.init_err_stack('PA_FP_ORG_FCST_UTILS.get_probability_percent');
580: END IF;
581:
582: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

Line 579: pa_debug.init_err_stack('PA_FP_ORG_FCST_UTILS.get_probability_percent');

575: l_debug_mode VARCHAR2(30);
576: l_probability_member_id pa_projects_all.probability_member_id%TYPE;
577: BEGIN
578: IF P_PA_DEBUG_MODE = 'Y' THEN
579: pa_debug.init_err_stack('PA_FP_ORG_FCST_UTILS.get_probability_percent');
580: END IF;
581:
582: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
583: l_debug_mode := NVL(l_debug_mode, 'Y');

Line 582: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

578: IF P_PA_DEBUG_MODE = 'Y' THEN
579: pa_debug.init_err_stack('PA_FP_ORG_FCST_UTILS.get_probability_percent');
580: END IF;
581:
582: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
583: l_debug_mode := NVL(l_debug_mode, 'Y');
584:
585: IF P_PA_DEBUG_MODE = 'Y' THEN
586: pa_debug.set_process('get_probability_percent: ' || 'PLSQL','LOG',l_debug_mode);

Line 585: IF P_PA_DEBUG_MODE = 'Y' THEN

581:
582: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
583: l_debug_mode := NVL(l_debug_mode, 'Y');
584:
585: IF P_PA_DEBUG_MODE = 'Y' THEN
586: pa_debug.set_process('get_probability_percent: ' || 'PLSQL','LOG',l_debug_mode);
587: END IF;
588:
589: SELECT nvl(probability_member_id,-99)

Line 586: pa_debug.set_process('get_probability_percent: ' || 'PLSQL','LOG',l_debug_mode);

582: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
583: l_debug_mode := NVL(l_debug_mode, 'Y');
584:
585: IF P_PA_DEBUG_MODE = 'Y' THEN
586: pa_debug.set_process('get_probability_percent: ' || 'PLSQL','LOG',l_debug_mode);
587: END IF;
588:
589: SELECT nvl(probability_member_id,-99)
590: INTO l_probability_member_id

Line 602: pa_debug.g_err_stage := 'Txn Project_id = ['||p_project_id ||']';

598: INTO x_prob_percent
599: FROM pa_probability_members
600: WHERE probability_member_id = l_probability_member_id;
601: END IF;
602: pa_debug.g_err_stage := 'Txn Project_id = ['||p_project_id ||']';
603: IF P_PA_DEBUG_MODE = 'Y' THEN
604: pa_debug.write_file('get_probability_percent: ' || pa_debug.g_err_stage);
605: END IF;
606: pa_debug.g_err_stage := 'Probability = ['||x_prob_percent||']';

Line 603: IF P_PA_DEBUG_MODE = 'Y' THEN

599: FROM pa_probability_members
600: WHERE probability_member_id = l_probability_member_id;
601: END IF;
602: pa_debug.g_err_stage := 'Txn Project_id = ['||p_project_id ||']';
603: IF P_PA_DEBUG_MODE = 'Y' THEN
604: pa_debug.write_file('get_probability_percent: ' || pa_debug.g_err_stage);
605: END IF;
606: pa_debug.g_err_stage := 'Probability = ['||x_prob_percent||']';
607: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 604: pa_debug.write_file('get_probability_percent: ' || pa_debug.g_err_stage);

600: WHERE probability_member_id = l_probability_member_id;
601: END IF;
602: pa_debug.g_err_stage := 'Txn Project_id = ['||p_project_id ||']';
603: IF P_PA_DEBUG_MODE = 'Y' THEN
604: pa_debug.write_file('get_probability_percent: ' || pa_debug.g_err_stage);
605: END IF;
606: pa_debug.g_err_stage := 'Probability = ['||x_prob_percent||']';
607: IF P_PA_DEBUG_MODE = 'Y' THEN
608: pa_debug.write_file('get_probability_percent: ' || pa_debug.g_err_stage);

Line 606: pa_debug.g_err_stage := 'Probability = ['||x_prob_percent||']';

602: pa_debug.g_err_stage := 'Txn Project_id = ['||p_project_id ||']';
603: IF P_PA_DEBUG_MODE = 'Y' THEN
604: pa_debug.write_file('get_probability_percent: ' || pa_debug.g_err_stage);
605: END IF;
606: pa_debug.g_err_stage := 'Probability = ['||x_prob_percent||']';
607: IF P_PA_DEBUG_MODE = 'Y' THEN
608: pa_debug.write_file('get_probability_percent: ' || pa_debug.g_err_stage);
609: END IF;
610: pa_debug.reset_err_stack;

Line 607: IF P_PA_DEBUG_MODE = 'Y' THEN

603: IF P_PA_DEBUG_MODE = 'Y' THEN
604: pa_debug.write_file('get_probability_percent: ' || pa_debug.g_err_stage);
605: END IF;
606: pa_debug.g_err_stage := 'Probability = ['||x_prob_percent||']';
607: IF P_PA_DEBUG_MODE = 'Y' THEN
608: pa_debug.write_file('get_probability_percent: ' || pa_debug.g_err_stage);
609: END IF;
610: pa_debug.reset_err_stack;
611: EXCEPTION

Line 608: pa_debug.write_file('get_probability_percent: ' || pa_debug.g_err_stage);

604: pa_debug.write_file('get_probability_percent: ' || pa_debug.g_err_stage);
605: END IF;
606: pa_debug.g_err_stage := 'Probability = ['||x_prob_percent||']';
607: IF P_PA_DEBUG_MODE = 'Y' THEN
608: pa_debug.write_file('get_probability_percent: ' || pa_debug.g_err_stage);
609: END IF;
610: pa_debug.reset_err_stack;
611: EXCEPTION
612: WHEN OTHERS THEN

Line 610: pa_debug.reset_err_stack;

606: pa_debug.g_err_stage := 'Probability = ['||x_prob_percent||']';
607: IF P_PA_DEBUG_MODE = 'Y' THEN
608: pa_debug.write_file('get_probability_percent: ' || pa_debug.g_err_stage);
609: END IF;
610: pa_debug.reset_err_stack;
611: EXCEPTION
612: WHEN OTHERS THEN
613: FND_MSG_PUB.add_exc_msg(
614: p_pkg_name => 'PA_FP_ORG_FCST_UTILS.get_probability_percent'

Line 615: ,p_procedure_name => PA_DEBUG.G_Err_Stack);

611: EXCEPTION
612: WHEN OTHERS THEN
613: FND_MSG_PUB.add_exc_msg(
614: p_pkg_name => 'PA_FP_ORG_FCST_UTILS.get_probability_percent'
615: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
616:
617: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
618: IF P_PA_DEBUG_MODE = 'Y' THEN
619: pa_debug.write_file('get_probability_percent: ' || SQLERRM);

Line 618: IF P_PA_DEBUG_MODE = 'Y' THEN

614: p_pkg_name => 'PA_FP_ORG_FCST_UTILS.get_probability_percent'
615: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
616:
617: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
618: IF P_PA_DEBUG_MODE = 'Y' THEN
619: pa_debug.write_file('get_probability_percent: ' || SQLERRM);
620: END IF;
621: x_err_code := SQLERRM;
622: pa_debug.reset_err_stack;

Line 619: pa_debug.write_file('get_probability_percent: ' || SQLERRM);

615: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
616:
617: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
618: IF P_PA_DEBUG_MODE = 'Y' THEN
619: pa_debug.write_file('get_probability_percent: ' || SQLERRM);
620: END IF;
621: x_err_code := SQLERRM;
622: pa_debug.reset_err_stack;
623: END get_probability_percent;

Line 622: pa_debug.reset_err_stack;

618: IF P_PA_DEBUG_MODE = 'Y' THEN
619: pa_debug.write_file('get_probability_percent: ' || SQLERRM);
620: END IF;
621: x_err_code := SQLERRM;
622: pa_debug.reset_err_stack;
623: END get_probability_percent;
624:
625: PROCEDURE get_period_profile
626: ( p_project_id IN pa_projects_all.project_id%TYPE

Line 645: IF P_PA_DEBUG_MODE = 'Y' THEN

641: ,x_err_code OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
642: IS
643: l_debug_mode VARCHAR2(30);
644: BEGIN
645: IF P_PA_DEBUG_MODE = 'Y' THEN
646: pa_debug.init_err_stack('PA_FP_ORG_FCST_UTILS.get_period_profile');
647: END IF;
648:
649: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

Line 646: pa_debug.init_err_stack('PA_FP_ORG_FCST_UTILS.get_period_profile');

642: IS
643: l_debug_mode VARCHAR2(30);
644: BEGIN
645: IF P_PA_DEBUG_MODE = 'Y' THEN
646: pa_debug.init_err_stack('PA_FP_ORG_FCST_UTILS.get_period_profile');
647: END IF;
648:
649: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
650: l_debug_mode := NVL(l_debug_mode, 'Y');

Line 649: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

645: IF P_PA_DEBUG_MODE = 'Y' THEN
646: pa_debug.init_err_stack('PA_FP_ORG_FCST_UTILS.get_period_profile');
647: END IF;
648:
649: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
650: l_debug_mode := NVL(l_debug_mode, 'Y');
651:
652: IF P_PA_DEBUG_MODE = 'Y' THEN
653: pa_debug.set_process('get_period_profile: ' || 'PLSQL','LOG',l_debug_mode);

Line 652: IF P_PA_DEBUG_MODE = 'Y' THEN

648:
649: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
650: l_debug_mode := NVL(l_debug_mode, 'Y');
651:
652: IF P_PA_DEBUG_MODE = 'Y' THEN
653: pa_debug.set_process('get_period_profile: ' || 'PLSQL','LOG',l_debug_mode);
654: END IF;
655:
656: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 653: pa_debug.set_process('get_period_profile: ' || 'PLSQL','LOG',l_debug_mode);

649: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
650: l_debug_mode := NVL(l_debug_mode, 'Y');
651:
652: IF P_PA_DEBUG_MODE = 'Y' THEN
653: pa_debug.set_process('get_period_profile: ' || 'PLSQL','LOG',l_debug_mode);
654: END IF;
655:
656: x_return_status := FND_API.G_RET_STS_SUCCESS;
657: BEGIN

Line 669: --pa_debug.write_file('Period_profile Found');

665: AND ppp.gl_period_type = p_act_period_type
666: AND ppp.period1_start_date = p_start_date
667: AND ppp.number_of_periods = p_number_of_periods;
668:
669: --pa_debug.write_file('Period_profile Found');
670: EXCEPTION
671: WHEN NO_DATA_FOUND THEN
672: x_period_profile_id := -99;
673: x_return_status := FND_API.G_RET_STS_ERROR;

Line 674: IF P_PA_DEBUG_MODE = 'Y' THEN

670: EXCEPTION
671: WHEN NO_DATA_FOUND THEN
672: x_period_profile_id := -99;
673: x_return_status := FND_API.G_RET_STS_ERROR;
674: IF P_PA_DEBUG_MODE = 'Y' THEN
675: pa_debug.write_file('get_period_profile: ' || 'Period_profile Not Found');
676: END IF;
677: x_err_code := SQLERRM;
678: END;

Line 675: pa_debug.write_file('get_period_profile: ' || 'Period_profile Not Found');

671: WHEN NO_DATA_FOUND THEN
672: x_period_profile_id := -99;
673: x_return_status := FND_API.G_RET_STS_ERROR;
674: IF P_PA_DEBUG_MODE = 'Y' THEN
675: pa_debug.write_file('get_period_profile: ' || 'Period_profile Not Found');
676: END IF;
677: x_err_code := SQLERRM;
678: END;
679: /*

Line 680: pa_debug.g_err_stage := 'x_period_profile_id ['||x_period_profile_id ||

676: END IF;
677: x_err_code := SQLERRM;
678: END;
679: /*
680: pa_debug.g_err_stage := 'x_period_profile_id ['||x_period_profile_id ||
681: ']';
682: IF P_PA_DEBUG_MODE = 'Y' THEN
683: pa_debug.write_file('get_period_profile: ' || pa_debug.g_err_stage);
684: END IF;

Line 682: IF P_PA_DEBUG_MODE = 'Y' THEN

678: END;
679: /*
680: pa_debug.g_err_stage := 'x_period_profile_id ['||x_period_profile_id ||
681: ']';
682: IF P_PA_DEBUG_MODE = 'Y' THEN
683: pa_debug.write_file('get_period_profile: ' || pa_debug.g_err_stage);
684: END IF;
685: */
686: pa_debug.reset_err_stack;

Line 683: pa_debug.write_file('get_period_profile: ' || pa_debug.g_err_stage);

679: /*
680: pa_debug.g_err_stage := 'x_period_profile_id ['||x_period_profile_id ||
681: ']';
682: IF P_PA_DEBUG_MODE = 'Y' THEN
683: pa_debug.write_file('get_period_profile: ' || pa_debug.g_err_stage);
684: END IF;
685: */
686: pa_debug.reset_err_stack;
687: EXCEPTION

Line 686: pa_debug.reset_err_stack;

682: IF P_PA_DEBUG_MODE = 'Y' THEN
683: pa_debug.write_file('get_period_profile: ' || pa_debug.g_err_stage);
684: END IF;
685: */
686: pa_debug.reset_err_stack;
687: EXCEPTION
688: WHEN OTHERS THEN
689: FND_MSG_PUB.add_exc_msg(
690: p_pkg_name => 'PA_FP_ORG_FCST_UTILS.get_period_profile'

Line 691: ,p_procedure_name => PA_DEBUG.G_Err_Stack);

687: EXCEPTION
688: WHEN OTHERS THEN
689: FND_MSG_PUB.add_exc_msg(
690: p_pkg_name => 'PA_FP_ORG_FCST_UTILS.get_period_profile'
691: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
693: x_err_code := SQLERRM;
694: IF P_PA_DEBUG_MODE = 'Y' THEN
695: pa_debug.write_file('get_period_profile: ' || SQLERRM);

Line 694: IF P_PA_DEBUG_MODE = 'Y' THEN

690: p_pkg_name => 'PA_FP_ORG_FCST_UTILS.get_period_profile'
691: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
693: x_err_code := SQLERRM;
694: IF P_PA_DEBUG_MODE = 'Y' THEN
695: pa_debug.write_file('get_period_profile: ' || SQLERRM);
696: END IF;
697: pa_debug.reset_err_stack;
698: END get_period_profile;

Line 695: pa_debug.write_file('get_period_profile: ' || SQLERRM);

691: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
693: x_err_code := SQLERRM;
694: IF P_PA_DEBUG_MODE = 'Y' THEN
695: pa_debug.write_file('get_period_profile: ' || SQLERRM);
696: END IF;
697: pa_debug.reset_err_stack;
698: END get_period_profile;
699:

Line 697: pa_debug.reset_err_stack;

693: x_err_code := SQLERRM;
694: IF P_PA_DEBUG_MODE = 'Y' THEN
695: pa_debug.write_file('get_period_profile: ' || SQLERRM);
696: END IF;
697: pa_debug.reset_err_stack;
698: END get_period_profile;
699:
700: FUNCTION check_org_proj_template
701: ( p_project_id IN pa_projects_all.project_id%TYPE

Line 710: IF P_PA_DEBUG_MODE = 'Y' THEN

706:
707: l_org_proj_template_exists varchar2(1);
708:
709: BEGIN
710: IF P_PA_DEBUG_MODE = 'Y' THEN
711: pa_debug.write_file('Entered PA_FP_ORG_FCST_UTILS.check_org_proj_template');
712: END IF;
713: x_return_status := FND_API.G_RET_STS_SUCCESS;
714:

Line 711: pa_debug.write_file('Entered PA_FP_ORG_FCST_UTILS.check_org_proj_template');

707: l_org_proj_template_exists varchar2(1);
708:
709: BEGIN
710: IF P_PA_DEBUG_MODE = 'Y' THEN
711: pa_debug.write_file('Entered PA_FP_ORG_FCST_UTILS.check_org_proj_template');
712: END IF;
713: x_return_status := FND_API.G_RET_STS_SUCCESS;
714:
715: l_org_proj_template_exists := 'N';

Line 724: IF P_PA_DEBUG_MODE = 'Y' THEN

720: WHERE org_fcst_project_template_id = p_project_id;
721:
722: x_return_status := FND_API.G_RET_STS_ERROR;
723:
724: IF P_PA_DEBUG_MODE = 'Y' THEN
725: pa_debug.write_file('Leaving PA_FP_ORG_FCST_UTILS.check_org_proj_template');
726: END IF;
727: pa_debug.reset_err_stack;
728: return(l_org_proj_template_exists);

Line 725: pa_debug.write_file('Leaving PA_FP_ORG_FCST_UTILS.check_org_proj_template');

721:
722: x_return_status := FND_API.G_RET_STS_ERROR;
723:
724: IF P_PA_DEBUG_MODE = 'Y' THEN
725: pa_debug.write_file('Leaving PA_FP_ORG_FCST_UTILS.check_org_proj_template');
726: END IF;
727: pa_debug.reset_err_stack;
728: return(l_org_proj_template_exists);
729:

Line 727: pa_debug.reset_err_stack;

723:
724: IF P_PA_DEBUG_MODE = 'Y' THEN
725: pa_debug.write_file('Leaving PA_FP_ORG_FCST_UTILS.check_org_proj_template');
726: END IF;
727: pa_debug.reset_err_stack;
728: return(l_org_proj_template_exists);
729:
730: EXCEPTION
731: WHEN NO_DATA_FOUND THEN

Line 741: IF P_PA_DEBUG_MODE = 'Y' THEN

737: p_pkg_name => 'PA_FP_ORG_FCST_UTILS'
738: ,p_procedure_name => 'check_org_proj_template');
739: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
740: x_err_code := SQLERRM;
741: IF P_PA_DEBUG_MODE = 'Y' THEN
742: pa_debug.write_file('check_org_proj_template: ' || SQLERRM);
743: END IF;
744: pa_debug.reset_err_stack;
745: END check_org_proj_template;

Line 742: pa_debug.write_file('check_org_proj_template: ' || SQLERRM);

738: ,p_procedure_name => 'check_org_proj_template');
739: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
740: x_err_code := SQLERRM;
741: IF P_PA_DEBUG_MODE = 'Y' THEN
742: pa_debug.write_file('check_org_proj_template: ' || SQLERRM);
743: END IF;
744: pa_debug.reset_err_stack;
745: END check_org_proj_template;
746:

Line 744: pa_debug.reset_err_stack;

740: x_err_code := SQLERRM;
741: IF P_PA_DEBUG_MODE = 'Y' THEN
742: pa_debug.write_file('check_org_proj_template: ' || SQLERRM);
743: END IF;
744: pa_debug.reset_err_stack;
745: END check_org_proj_template;
746:
747: PROCEDURE Get_Tp_Amount_Type(p_project_id IN NUMBER,
748: p_work_type_id IN NUMBER,

Line 814: IF P_PA_DEBUG_MODE = 'Y' THEN

810:
811: l_org_project_exists varchar2(1);
812:
813: BEGIN
814: IF P_PA_DEBUG_MODE = 'Y' THEN
815: pa_debug.write_file('Entered PA_FP_ORG_FCST_UTILS.check_org_project');
816: END IF;
817: x_return_status := FND_API.G_RET_STS_SUCCESS;
818:

Line 815: pa_debug.write_file('Entered PA_FP_ORG_FCST_UTILS.check_org_project');

811: l_org_project_exists varchar2(1);
812:
813: BEGIN
814: IF P_PA_DEBUG_MODE = 'Y' THEN
815: pa_debug.write_file('Entered PA_FP_ORG_FCST_UTILS.check_org_project');
816: END IF;
817: x_return_status := FND_API.G_RET_STS_SUCCESS;
818:
819: l_org_project_exists := 'N';

Line 829: IF P_PA_DEBUG_MODE = 'Y' THEN

825: WHERE pp.project_id = p_project_id
826: AND pt.project_type = pp.project_type
827: AND pt.org_project_flag = 'Y';
828:
829: IF P_PA_DEBUG_MODE = 'Y' THEN
830: pa_debug.write_file('Leaving PA_FP_ORG_FCST_UTILS.check_org_project');
831: END IF;
832: pa_debug.reset_err_stack;
833: return(l_org_project_exists);

Line 830: pa_debug.write_file('Leaving PA_FP_ORG_FCST_UTILS.check_org_project');

826: AND pt.project_type = pp.project_type
827: AND pt.org_project_flag = 'Y';
828:
829: IF P_PA_DEBUG_MODE = 'Y' THEN
830: pa_debug.write_file('Leaving PA_FP_ORG_FCST_UTILS.check_org_project');
831: END IF;
832: pa_debug.reset_err_stack;
833: return(l_org_project_exists);
834:

Line 832: pa_debug.reset_err_stack;

828:
829: IF P_PA_DEBUG_MODE = 'Y' THEN
830: pa_debug.write_file('Leaving PA_FP_ORG_FCST_UTILS.check_org_project');
831: END IF;
832: pa_debug.reset_err_stack;
833: return(l_org_project_exists);
834:
835: EXCEPTION
836: WHEN NO_DATA_FOUND THEN

Line 847: IF P_PA_DEBUG_MODE = 'Y' THEN

843: ,p_procedure_name => 'check_org_project');
844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
845: --x_err_code := SQLERRM; bug 4338407
846: x_err_code := SQLCODE;
847: IF P_PA_DEBUG_MODE = 'Y' THEN
848: pa_debug.write_file('check_org_project: ' || SQLERRM);
849: END IF;
850: pa_debug.reset_err_stack;
851: return('E'); -- bug 4338407

Line 848: pa_debug.write_file('check_org_project: ' || SQLERRM);

844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
845: --x_err_code := SQLERRM; bug 4338407
846: x_err_code := SQLCODE;
847: IF P_PA_DEBUG_MODE = 'Y' THEN
848: pa_debug.write_file('check_org_project: ' || SQLERRM);
849: END IF;
850: pa_debug.reset_err_stack;
851: return('E'); -- bug 4338407
852: END check_org_project;

Line 850: pa_debug.reset_err_stack;

846: x_err_code := SQLCODE;
847: IF P_PA_DEBUG_MODE = 'Y' THEN
848: pa_debug.write_file('check_org_project: ' || SQLERRM);
849: END IF;
850: pa_debug.reset_err_stack;
851: return('E'); -- bug 4338407
852: END check_org_project;
853:
854: FUNCTION calculate_gl_amount

Line 1523: IF P_PA_DEBUG_MODE = 'Y' THEN

1519: l_return_status VARCHAR2(1);
1520: l_err_code VARCHAR2(30);
1521:
1522: BEGIN
1523: IF P_PA_DEBUG_MODE = 'Y' THEN
1524: pa_debug.write_file('Entered PA_FIN_PLAN_UTILS.detect_org_project');
1525: END IF;
1526: x_return_status := FND_API.G_RET_STS_SUCCESS;
1527: l_is_org_project := PA_FP_ORG_FCST_UTILS.is_org_project

Line 1524: pa_debug.write_file('Entered PA_FIN_PLAN_UTILS.detect_org_project');

1520: l_err_code VARCHAR2(30);
1521:
1522: BEGIN
1523: IF P_PA_DEBUG_MODE = 'Y' THEN
1524: pa_debug.write_file('Entered PA_FIN_PLAN_UTILS.detect_org_project');
1525: END IF;
1526: x_return_status := FND_API.G_RET_STS_SUCCESS;
1527: l_is_org_project := PA_FP_ORG_FCST_UTILS.is_org_project
1528: (p_project_id => p_project_id);

Line 1544: pa_debug.reset_err_stack;

1540: p_msg_name => l_err_code);
1541: return;
1542: end if;
1543:
1544: pa_debug.reset_err_stack;
1545: return;
1546:
1547: EXCEPTION
1548: WHEN OTHERS THEN

Line 1554: IF P_PA_DEBUG_MODE = 'Y' THEN

1550: p_pkg_name => 'PA_FP_ORG_FCST_UTILS'
1551: ,p_procedure_name => 'detect_org_project');
1552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1553: x_err_code := SQLERRM;
1554: IF P_PA_DEBUG_MODE = 'Y' THEN
1555: pa_debug.write_file('detect_org_project: ' || SQLERRM);
1556: END IF;
1557: pa_debug.reset_err_stack;
1558: END detect_org_project;

Line 1555: pa_debug.write_file('detect_org_project: ' || SQLERRM);

1551: ,p_procedure_name => 'detect_org_project');
1552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1553: x_err_code := SQLERRM;
1554: IF P_PA_DEBUG_MODE = 'Y' THEN
1555: pa_debug.write_file('detect_org_project: ' || SQLERRM);
1556: END IF;
1557: pa_debug.reset_err_stack;
1558: END detect_org_project;
1559:

Line 1557: pa_debug.reset_err_stack;

1553: x_err_code := SQLERRM;
1554: IF P_PA_DEBUG_MODE = 'Y' THEN
1555: pa_debug.write_file('detect_org_project: ' || SQLERRM);
1556: END IF;
1557: pa_debug.reset_err_stack;
1558: END detect_org_project;
1559:
1560: /* dlai 04/25/02 added function same_org_id and procedure check_same_org_id
1561: * to ensure user login org_id is the same as the project org_id he/she is

Line 1576: IF P_PA_DEBUG_MODE = 'Y' THEN

1572: l_login_org_id_data VARCHAR2(1000);
1573: l_same_org_id VARCHAR2(1);
1574: org_id_endpoint NUMBER(15);
1575: BEGIN
1576: IF P_PA_DEBUG_MODE = 'Y' THEN
1577: pa_debug.init_err_stack('PA_FP_ORG_FCST_UTILS.same_org_id');
1578: pa_debug.set_process('same_org_id: ' || 'PLSQL','LOG', 'Y');
1579: pa_debug.write('plsql.pa.pa_fp_org_fcst_utils.same_org_id', 'Entered PA_FP_ORG_FCST_UTILS.same_org_id', 1);
1580: END IF;

Line 1577: pa_debug.init_err_stack('PA_FP_ORG_FCST_UTILS.same_org_id');

1573: l_same_org_id VARCHAR2(1);
1574: org_id_endpoint NUMBER(15);
1575: BEGIN
1576: IF P_PA_DEBUG_MODE = 'Y' THEN
1577: pa_debug.init_err_stack('PA_FP_ORG_FCST_UTILS.same_org_id');
1578: pa_debug.set_process('same_org_id: ' || 'PLSQL','LOG', 'Y');
1579: pa_debug.write('plsql.pa.pa_fp_org_fcst_utils.same_org_id', 'Entered PA_FP_ORG_FCST_UTILS.same_org_id', 1);
1580: END IF;
1581: l_same_org_id := 'N';

Line 1578: pa_debug.set_process('same_org_id: ' || 'PLSQL','LOG', 'Y');

1574: org_id_endpoint NUMBER(15);
1575: BEGIN
1576: IF P_PA_DEBUG_MODE = 'Y' THEN
1577: pa_debug.init_err_stack('PA_FP_ORG_FCST_UTILS.same_org_id');
1578: pa_debug.set_process('same_org_id: ' || 'PLSQL','LOG', 'Y');
1579: pa_debug.write('plsql.pa.pa_fp_org_fcst_utils.same_org_id', 'Entered PA_FP_ORG_FCST_UTILS.same_org_id', 1);
1580: END IF;
1581: l_same_org_id := 'N';
1582:

Line 1579: pa_debug.write('plsql.pa.pa_fp_org_fcst_utils.same_org_id', 'Entered PA_FP_ORG_FCST_UTILS.same_org_id', 1);

1575: BEGIN
1576: IF P_PA_DEBUG_MODE = 'Y' THEN
1577: pa_debug.init_err_stack('PA_FP_ORG_FCST_UTILS.same_org_id');
1578: pa_debug.set_process('same_org_id: ' || 'PLSQL','LOG', 'Y');
1579: pa_debug.write('plsql.pa.pa_fp_org_fcst_utils.same_org_id', 'Entered PA_FP_ORG_FCST_UTILS.same_org_id', 1);
1580: END IF;
1581: l_same_org_id := 'N';
1582:
1583: select org_id, USERENV('CLIENT_INFO')

Line 1594: pa_debug.reset_err_stack;

1590: l_login_org_id := TO_NUMBER(RTRIM(SUBSTR(l_login_org_id_data,1,org_id_endpoint)));
1591: if nvl(l_login_org_id,-99) = nvl(l_project_org_id,-99) then -- added nvl for bug # 2890558
1592: l_same_org_id := 'Y';
1593: end if;
1594: pa_debug.reset_err_stack;
1595: return(l_same_org_id);
1596: EXCEPTION
1597: WHEN NO_DATA_FOUND THEN
1598: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 1598: IF P_PA_DEBUG_MODE = 'Y' THEN

1594: pa_debug.reset_err_stack;
1595: return(l_same_org_id);
1596: EXCEPTION
1597: WHEN NO_DATA_FOUND THEN
1598: IF P_PA_DEBUG_MODE = 'Y' THEN
1599: pa_debug.write_file('same_org_id: ' || 'NO DATA FOUND EXCEPTION');
1600: END IF;
1601: l_same_org_id := 'E';
1602: return(l_same_org_id);

Line 1599: pa_debug.write_file('same_org_id: ' || 'NO DATA FOUND EXCEPTION');

1595: return(l_same_org_id);
1596: EXCEPTION
1597: WHEN NO_DATA_FOUND THEN
1598: IF P_PA_DEBUG_MODE = 'Y' THEN
1599: pa_debug.write_file('same_org_id: ' || 'NO DATA FOUND EXCEPTION');
1600: END IF;
1601: l_same_org_id := 'E';
1602: return(l_same_org_id);
1603: WHEN OTHERS THEN

Line 1607: pa_debug.reset_err_stack;

1603: WHEN OTHERS THEN
1604: FND_MSG_PUB.add_exc_msg(
1605: p_pkg_name => 'PA_FP_ORG_FCST_UTILS'
1606: ,p_procedure_name => 'same_org_id');
1607: pa_debug.reset_err_stack;
1608: return('U');
1609: END same_org_id;
1610:
1611: PROCEDURE check_same_org_id