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

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

1: PACKAGE BODY PA_TASK_ASSIGNMENTS_PVT AS
2: -- $Header: PATAPVTB.pls 120.7.12010000.3 2008/09/10 18:22:11 skkoppul ship $
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_TASK_ASSIGNMENTS_PVT';
5: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
6: li_curr_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
7:
8:
9:

Line 243: pa_debug.g_err_stage:='Entered ' || L_FuncProc ;

239: --Bug 4363092: MOAC Changes: Commenting beloew call as l_org_id is not used anywhere
240: --fnd_profile.get('ORG_ID', l_org_id);
241:
242: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
243: pa_debug.g_err_stage:='Entered ' || L_FuncProc ;
244: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
245: END IF;
246: --dbms_output.put_line('Entered Create Task Asgmts.');
247: -- Standard begin of API savepoint

Line 244: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

240: --fnd_profile.get('ORG_ID', l_org_id);
241:
242: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
243: pa_debug.g_err_stage:='Entered ' || L_FuncProc ;
244: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
245: END IF;
246: --dbms_output.put_line('Entered Create Task Asgmts.');
247: -- Standard begin of API savepoint
248:

Line 284: pa_debug.g_err_stage:='Checking p_pm_product_code ' || L_FuncProc;

280:
281: --dbms_output.put_line('Initialized message table.');
282:
283: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
284: pa_debug.g_err_stage:='Checking p_pm_product_code ' || L_FuncProc;
285: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
286: END IF;
287:
288: IF p_pm_product_code IS NOT NULL

Line 285: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

281: --dbms_output.put_line('Initialized message table.');
282:
283: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
284: pa_debug.g_err_stage:='Checking p_pm_product_code ' || L_FuncProc;
285: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
286: END IF;
287:
288: IF p_pm_product_code IS NOT NULL
289: AND p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

Line 315: pa_debug.g_err_stage:=' p_pm_product_code check successful.' || L_FuncProc;

311:
312: --dbms_output.put_line('User id :' || l_user_id || 'l_resp_id' || l_resp_id);
313:
314: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
315: pa_debug.g_err_stage:=' p_pm_product_code check successful.' || L_FuncProc;
316: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
317: END IF;
318: --> Need sep. fn. for periods ? check..
319:

Line 316: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

312: --dbms_output.put_line('User id :' || l_user_id || 'l_resp_id' || l_resp_id);
313:
314: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
315: pa_debug.g_err_stage:=' p_pm_product_code check successful.' || L_FuncProc;
316: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
317: END IF;
318: --> Need sep. fn. for periods ? check..
319:
320: l_module_name := 'PA_PM_ADD_TASK_ASSIGNMENT';

Line 343: pa_debug.g_err_stage:=' Project ref to id check not successful.' || L_FuncProc;

339: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
340:
341: --dbms_output.put_line('Project_id not successful ');
342: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
343: pa_debug.g_err_stage:=' Project ref to id check not successful.' || L_FuncProc;
344: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
345: END IF;
346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
347:

Line 344: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

340:
341: --dbms_output.put_line('Project_id not successful ');
342: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
343: pa_debug.g_err_stage:=' Project ref to id check not successful.' || L_FuncProc;
344: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
345: END IF;
346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
347:
348: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 352: pa_debug.g_err_stage:=' Project ref to id check not successful.' || L_FuncProc;

348: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
349:
350: --dbms_output.put_line('Project_id conv. not successful ');
351: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
352: pa_debug.g_err_stage:=' Project ref to id check not successful.' || L_FuncProc;
353: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
354: END IF;
355: RAISE FND_API.G_EXC_ERROR;
356:

Line 353: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

349:
350: --dbms_output.put_line('Project_id conv. not successful ');
351: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
352: pa_debug.g_err_stage:=' Project ref to id check not successful.' || L_FuncProc;
353: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
354: END IF;
355: RAISE FND_API.G_EXC_ERROR;
356:
357: END IF;

Line 362: pa_debug.g_err_stage:=' Project ref to id check successful.' || L_FuncProc;

358: END IF;
359:
360: --dbms_output.put_line('Project ref to id check successful for Project ' || l_Project_id);
361: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
362: pa_debug.g_err_stage:=' Project ref to id check successful.' || L_FuncProc;
363: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
364: END IF;
365: -- As part of enforcing project security, which would determine
366: -- whether the user has the necessary privileges to update the project

Line 363: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

359:
360: --dbms_output.put_line('Project ref to id check successful for Project ' || l_Project_id);
361: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
362: pa_debug.g_err_stage:=' Project ref to id check successful.' || L_FuncProc;
363: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
364: END IF;
365: -- As part of enforcing project security, which would determine
366: -- whether the user has the necessary privileges to update the project
367: -- need to call the pa_security package

Line 372: pa_debug.g_err_stage:=' After initializing security..' || L_FuncProc;

368:
369: pa_security.initialize (X_user_id => l_user_id,
370: X_calling_module => l_module_name);
371: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
372: pa_debug.g_err_stage:=' After initializing security..' || L_FuncProc;
373: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
374: END IF;
375: -- Actions performed using the APIs would be subject to
376: -- function security. If the responsibility does not allow

Line 373: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

369: pa_security.initialize (X_user_id => l_user_id,
370: X_calling_module => l_module_name);
371: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
372: pa_debug.g_err_stage:=' After initializing security..' || L_FuncProc;
373: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
374: END IF;
375: -- Actions performed using the APIs would be subject to
376: -- function security. If the responsibility does not allow
377: -- such functions to be executed, the API should not proceed further

Line 405: pa_debug.g_err_stage:=' PA_PM_ADD_TASK_ASSIGNMENT function check successful.' || L_FuncProc;

401: RAISE FND_API.G_EXC_ERROR;
402: END IF;
403:
404: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
405: pa_debug.g_err_stage:=' PA_PM_ADD_TASK_ASSIGNMENT function check successful.' || L_FuncProc;
406: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
407: END IF;
408: --dbms_output.put_line('PA_PM_ADD_TASK_ASSIGNMENT function check successful.');
409: IF l_function_allowed = 'N' THEN

Line 406: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

402: END IF;
403:
404: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
405: pa_debug.g_err_stage:=' PA_PM_ADD_TASK_ASSIGNMENT function check successful.' || L_FuncProc;
406: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
407: END IF;
408: --dbms_output.put_line('PA_PM_ADD_TASK_ASSIGNMENT function check successful.');
409: IF l_function_allowed = 'N' THEN
410: pa_interface_utils_pub.map_new_amg_msg

Line 424: pa_debug.g_err_stage:=' PA_FUNCTION_SECURITY_ENFORCED function check successful.' || L_FuncProc;

420: RAISE FND_API.G_EXC_ERROR;
421: END IF;
422: --dbms_output.put_line('PA_FUNCTION_SECURITY_ENFORCED function check successful.');
423: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
424: pa_debug.g_err_stage:=' PA_FUNCTION_SECURITY_ENFORCED function check successful.' || L_FuncProc;
425: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
426: END IF;
427:
428:

Line 425: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

421: END IF;
422: --dbms_output.put_line('PA_FUNCTION_SECURITY_ENFORCED function check successful.');
423: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
424: pa_debug.g_err_stage:=' PA_FUNCTION_SECURITY_ENFORCED function check successful.' || L_FuncProc;
425: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
426: END IF;
427:
428:
429: -- Now verify whether project security allows the user to update

Line 457: pa_debug.g_err_stage:='PA_PROJECT_SECURITY_ENFORCED function check successful.' || L_FuncProc;

453: END IF;
454:
455: --dbms_output.put_line('pa_security.allow_query or update successful..');
456: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
457: pa_debug.g_err_stage:='PA_PROJECT_SECURITY_ENFORCED function check successful.' || L_FuncProc;
458: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
459: END IF;
460: --dbms_output.put_line('Project Id:' || l_project_id);
461:

Line 458: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

454:
455: --dbms_output.put_line('pa_security.allow_query or update successful..');
456: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
457: pa_debug.g_err_stage:='PA_PROJECT_SECURITY_ENFORCED function check successful.' || L_FuncProc;
458: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
459: END IF;
460: --dbms_output.put_line('Project Id:' || l_project_id);
461:
462: IF NVL(PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id ), 'N') = 'N' THEN

Line 482: pa_debug.g_err_stage:='PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS function check successful.' || L_FuncProc;

478: END IF;
479:
480: --dbms_output.put_line('PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS IS Fine..');
481: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
482: pa_debug.g_err_stage:='PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS function check successful.' || L_FuncProc;
483: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
484: END IF;
485:
486: IF p_pa_structure_version_id IS NOT NULL AND

Line 483: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

479:
480: --dbms_output.put_line('PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS IS Fine..');
481: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
482: pa_debug.g_err_stage:='PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS function check successful.' || L_FuncProc;
483: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
484: END IF;
485:
486: IF p_pa_structure_version_id IS NOT NULL AND
487: (p_pa_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN

Line 538: pa_debug.g_err_stage:='struct_elem version id function check successful.' || L_FuncProc;

534: RAISE FND_API.G_EXC_ERROR;
535: END IF;
536:
537: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
538: pa_debug.g_err_stage:='struct_elem version id function check successful.' || L_FuncProc;
539: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
540: END IF;
541:
542:

Line 539: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

535: END IF;
536:
537: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
538: pa_debug.g_err_stage:='struct_elem version id function check successful.' || L_FuncProc;
539: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
540: END IF;
541:
542:
543: OPEN C_Get_Budget_Version_Id(l_struct_elem_version_id, l_project_id);

Line 567: pa_debug.g_err_stage:='Count of task assignment periods' || l_count || ':' || L_FuncProc;

563:
564: l_count := p_task_assignment_periods_in.COUNT;
565:
566: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
567: pa_debug.g_err_stage:='Count of task assignment periods' || l_count || ':' || L_FuncProc;
568: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
569: END IF;
570:
571: --dbms_output.put_line(' Input Count of Global Input Tables..: ' || l_count );

Line 568: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

564: l_count := p_task_assignment_periods_in.COUNT;
565:
566: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
567: pa_debug.g_err_stage:='Count of task assignment periods' || l_count || ':' || L_FuncProc;
568: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
569: END IF;
570:
571: --dbms_output.put_line(' Input Count of Global Input Tables..: ' || l_count );
572:

Line 635: pa_debug.g_err_stage:='task_id ' || l_d_task_id;

631:
632: --dbms_output.put_line('l_d_task_id valid input:'|| l_d_task_id);
633:
634: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
635: pa_debug.g_err_stage:='task_id ' || l_d_task_id;
636: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
637: END IF;
638:
639: --dbms_output.put_line('l_d_task_id'|| l_d_task_id);

Line 636: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

632: --dbms_output.put_line('l_d_task_id valid input:'|| l_d_task_id);
633:
634: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
635: pa_debug.g_err_stage:='task_id ' || l_d_task_id;
636: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
637: END IF;
638:
639: --dbms_output.put_line('l_d_task_id'|| l_d_task_id);
640:

Line 1000: pa_debug.g_err_stage:='l_FINPLAN_LINES_TAB(l_finplan_line_count).resource_assignment_id: ' || l_FINPLAN_LINES_TAB(l_finplan_line_count).resource_assignment_id;

996:
997: --dbms_output.put_line('End of Loop');
998:
999: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
1000: pa_debug.g_err_stage:='l_FINPLAN_LINES_TAB(l_finplan_line_count).resource_assignment_id: ' || l_FINPLAN_LINES_TAB(l_finplan_line_count).resource_assignment_id;
1001: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1002:
1003:
1004: pa_debug.g_err_stage:='l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference1 (task_id): ' || l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference1;

Line 1001: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

997: --dbms_output.put_line('End of Loop');
998:
999: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
1000: pa_debug.g_err_stage:='l_FINPLAN_LINES_TAB(l_finplan_line_count).resource_assignment_id: ' || l_FINPLAN_LINES_TAB(l_finplan_line_count).resource_assignment_id;
1001: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1002:
1003:
1004: pa_debug.g_err_stage:='l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference1 (task_id): ' || l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference1;
1005: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

Line 1004: pa_debug.g_err_stage:='l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference1 (task_id): ' || l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference1;

1000: pa_debug.g_err_stage:='l_FINPLAN_LINES_TAB(l_finplan_line_count).resource_assignment_id: ' || l_FINPLAN_LINES_TAB(l_finplan_line_count).resource_assignment_id;
1001: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1002:
1003:
1004: pa_debug.g_err_stage:='l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference1 (task_id): ' || l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference1;
1005: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1006:
1007:
1008: pa_debug.g_err_stage:='l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference2 (resource_list_member_id): ' || l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference2;

Line 1005: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

1001: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1002:
1003:
1004: pa_debug.g_err_stage:='l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference1 (task_id): ' || l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference1;
1005: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1006:
1007:
1008: pa_debug.g_err_stage:='l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference2 (resource_list_member_id): ' || l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference2;
1009: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

Line 1008: pa_debug.g_err_stage:='l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference2 (resource_list_member_id): ' || l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference2;

1004: pa_debug.g_err_stage:='l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference1 (task_id): ' || l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference1;
1005: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1006:
1007:
1008: pa_debug.g_err_stage:='l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference2 (resource_list_member_id): ' || l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference2;
1009: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1010:
1011:
1012: pa_debug.g_err_stage:='l_FINPLAN_LINES_TAB(l_finplan_line_count).start_date: ' || l_FINPLAN_LINES_TAB(l_finplan_line_count).start_date;

Line 1009: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

1005: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1006:
1007:
1008: pa_debug.g_err_stage:='l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference2 (resource_list_member_id): ' || l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference2;
1009: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1010:
1011:
1012: pa_debug.g_err_stage:='l_FINPLAN_LINES_TAB(l_finplan_line_count).start_date: ' || l_FINPLAN_LINES_TAB(l_finplan_line_count).start_date;
1013: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

Line 1012: pa_debug.g_err_stage:='l_FINPLAN_LINES_TAB(l_finplan_line_count).start_date: ' || l_FINPLAN_LINES_TAB(l_finplan_line_count).start_date;

1008: pa_debug.g_err_stage:='l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference2 (resource_list_member_id): ' || l_FINPLAN_LINES_TAB(l_finplan_line_count).system_reference2;
1009: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1010:
1011:
1012: pa_debug.g_err_stage:='l_FINPLAN_LINES_TAB(l_finplan_line_count).start_date: ' || l_FINPLAN_LINES_TAB(l_finplan_line_count).start_date;
1013: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1014:
1015:
1016: pa_debug.g_err_stage:='l_FINPLAN_LINES_TAB(l_finplan_line_count).end_date: ' || l_FINPLAN_LINES_TAB(l_finplan_line_count).end_date;

Line 1013: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

1009: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1010:
1011:
1012: pa_debug.g_err_stage:='l_FINPLAN_LINES_TAB(l_finplan_line_count).start_date: ' || l_FINPLAN_LINES_TAB(l_finplan_line_count).start_date;
1013: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1014:
1015:
1016: pa_debug.g_err_stage:='l_FINPLAN_LINES_TAB(l_finplan_line_count).end_date: ' || l_FINPLAN_LINES_TAB(l_finplan_line_count).end_date;
1017: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

Line 1016: pa_debug.g_err_stage:='l_FINPLAN_LINES_TAB(l_finplan_line_count).end_date: ' || l_FINPLAN_LINES_TAB(l_finplan_line_count).end_date;

1012: pa_debug.g_err_stage:='l_FINPLAN_LINES_TAB(l_finplan_line_count).start_date: ' || l_FINPLAN_LINES_TAB(l_finplan_line_count).start_date;
1013: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1014:
1015:
1016: pa_debug.g_err_stage:='l_FINPLAN_LINES_TAB(l_finplan_line_count).end_date: ' || l_FINPLAN_LINES_TAB(l_finplan_line_count).end_date;
1017: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1018:
1019:
1020: pa_debug.g_err_stage:='l_FINPLAN_LINES_TAB(l_finplan_line_count).period_name: ' || l_FINPLAN_LINES_TAB(l_finplan_line_count).period_name;

Line 1017: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

1013: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1014:
1015:
1016: pa_debug.g_err_stage:='l_FINPLAN_LINES_TAB(l_finplan_line_count).end_date: ' || l_FINPLAN_LINES_TAB(l_finplan_line_count).end_date;
1017: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1018:
1019:
1020: pa_debug.g_err_stage:='l_FINPLAN_LINES_TAB(l_finplan_line_count).period_name: ' || l_FINPLAN_LINES_TAB(l_finplan_line_count).period_name;
1021: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

Line 1020: pa_debug.g_err_stage:='l_FINPLAN_LINES_TAB(l_finplan_line_count).period_name: ' || l_FINPLAN_LINES_TAB(l_finplan_line_count).period_name;

1016: pa_debug.g_err_stage:='l_FINPLAN_LINES_TAB(l_finplan_line_count).end_date: ' || l_FINPLAN_LINES_TAB(l_finplan_line_count).end_date;
1017: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1018:
1019:
1020: pa_debug.g_err_stage:='l_FINPLAN_LINES_TAB(l_finplan_line_count).period_name: ' || l_FINPLAN_LINES_TAB(l_finplan_line_count).period_name;
1021: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1022:
1023:
1024: pa_debug.g_err_stage:='l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_currency_code: ' || l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_currency_code;

Line 1021: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

1017: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1018:
1019:
1020: pa_debug.g_err_stage:='l_FINPLAN_LINES_TAB(l_finplan_line_count).period_name: ' || l_FINPLAN_LINES_TAB(l_finplan_line_count).period_name;
1021: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1022:
1023:
1024: pa_debug.g_err_stage:='l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_currency_code: ' || l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_currency_code;
1025: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

Line 1024: pa_debug.g_err_stage:='l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_currency_code: ' || l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_currency_code;

1020: pa_debug.g_err_stage:='l_FINPLAN_LINES_TAB(l_finplan_line_count).period_name: ' || l_FINPLAN_LINES_TAB(l_finplan_line_count).period_name;
1021: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1022:
1023:
1024: pa_debug.g_err_stage:='l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_currency_code: ' || l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_currency_code;
1025: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1026:
1027: pa_debug.g_err_stage:='l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_raw_cost: ' || l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_raw_cost;
1028: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

Line 1025: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

1021: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1022:
1023:
1024: pa_debug.g_err_stage:='l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_currency_code: ' || l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_currency_code;
1025: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1026:
1027: pa_debug.g_err_stage:='l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_raw_cost: ' || l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_raw_cost;
1028: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1029:

Line 1027: pa_debug.g_err_stage:='l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_raw_cost: ' || l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_raw_cost;

1023:
1024: pa_debug.g_err_stage:='l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_currency_code: ' || l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_currency_code;
1025: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1026:
1027: pa_debug.g_err_stage:='l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_raw_cost: ' || l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_raw_cost;
1028: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1029:
1030: pa_debug.g_err_stage:='l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_burdened_cost: ' || l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_burdened_cost;
1031: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

Line 1028: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

1024: pa_debug.g_err_stage:='l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_currency_code: ' || l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_currency_code;
1025: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1026:
1027: pa_debug.g_err_stage:='l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_raw_cost: ' || l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_raw_cost;
1028: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1029:
1030: pa_debug.g_err_stage:='l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_burdened_cost: ' || l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_burdened_cost;
1031: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1032: END IF;

Line 1030: pa_debug.g_err_stage:='l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_burdened_cost: ' || l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_burdened_cost;

1026:
1027: pa_debug.g_err_stage:='l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_raw_cost: ' || l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_raw_cost;
1028: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1029:
1030: pa_debug.g_err_stage:='l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_burdened_cost: ' || l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_burdened_cost;
1031: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1032: END IF;
1033:
1034: val_index := val_index + 1;

Line 1031: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

1027: pa_debug.g_err_stage:='l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_raw_cost: ' || l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_raw_cost;
1028: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1029:
1030: pa_debug.g_err_stage:='l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_burdened_cost: ' || l_FINPLAN_LINES_TAB(l_finplan_line_count).txn_burdened_cost;
1031: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1032: END IF;
1033:
1034: val_index := val_index + 1;
1035:

Line 1091: pa_debug.g_err_stage:='Calling context.' ||l_calling_context;

1087:
1088:
1089:
1090: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
1091: pa_debug.g_err_stage:='Calling context.' ||l_calling_context;
1092: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1093:
1094: pa_debug.g_err_stage:='Return status B4 add fin plan lines:' ||x_return_status;
1095: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

Line 1092: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

1088:
1089:
1090: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
1091: pa_debug.g_err_stage:='Calling context.' ||l_calling_context;
1092: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1093:
1094: pa_debug.g_err_stage:='Return status B4 add fin plan lines:' ||x_return_status;
1095: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1096: END IF;

Line 1094: pa_debug.g_err_stage:='Return status B4 add fin plan lines:' ||x_return_status;

1090: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
1091: pa_debug.g_err_stage:='Calling context.' ||l_calling_context;
1092: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1093:
1094: pa_debug.g_err_stage:='Return status B4 add fin plan lines:' ||x_return_status;
1095: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1096: END IF;
1097:
1098: --dbms_output.put_line('Calling PA_FIN_PLAN_PVT.ADD_FIN_PLAN_LINES');

Line 1095: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

1091: pa_debug.g_err_stage:='Calling context.' ||l_calling_context;
1092: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1093:
1094: pa_debug.g_err_stage:='Return status B4 add fin plan lines:' ||x_return_status;
1095: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1096: END IF;
1097:
1098: --dbms_output.put_line('Calling PA_FIN_PLAN_PVT.ADD_FIN_PLAN_LINES');
1099: PA_FIN_PLAN_PVT.ADD_FIN_PLAN_LINES

Line 1110: pa_debug.g_err_stage:='Return status after add fin plan lines:' ||x_return_status;

1106:
1107: --dbms_output.put_line('After returning from returning from add fin plan lines. return status:' ||x_return_status );
1108:
1109: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
1110: pa_debug.g_err_stage:='Return status after add fin plan lines:' ||x_return_status;
1111: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1112: END IF;
1113:
1114: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1111: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

1107: --dbms_output.put_line('After returning from returning from add fin plan lines. return status:' ||x_return_status );
1108:
1109: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
1110: pa_debug.g_err_stage:='Return status after add fin plan lines:' ||x_return_status;
1111: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1112: END IF;
1113:
1114: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1180: PA_DEBUG.write_log (x_module => G_PKG_NAME

1176: ROLLBACK TO add_task_asgmt_periods;
1177:
1178: x_return_status := FND_API.G_RET_STS_ERROR;
1179: IF P_DEBUG_MODE = 'Y' THEN
1180: PA_DEBUG.write_log (x_module => G_PKG_NAME
1181: ,x_msg => 'Expected Error:' || L_FuncProc || SQLERRM
1182: ,x_log_level => 5);
1183: END IF;
1184: FND_MSG_PUB.Count_And_Get

Line 1194: PA_DEBUG.write_log (x_module => G_PKG_NAME

1190: ROLLBACK TO add_task_asgmt_periods;
1191:
1192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1193: IF P_DEBUG_MODE = 'Y' THEN
1194: PA_DEBUG.write_log (x_module => G_PKG_NAME
1195: ,x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM
1196: ,x_log_level => 5);
1197: END IF;
1198: FND_MSG_PUB.Count_And_Get

Line 1207: PA_DEBUG.write_log (x_module => G_PKG_NAME

1203: ROLLBACK TO add_task_asgmt_periods;
1204:
1205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1206: IF P_DEBUG_MODE = 'Y' THEN
1207: PA_DEBUG.write_log (x_module => G_PKG_NAME
1208: ,x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM
1209: ,x_log_level => 5);
1210: END IF;
1211: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1406: pa_debug.g_err_stage:='Entered ' || L_FuncProc ;

1402: L_FuncProc := 'lock_version';
1403:
1404: --dbms_output.put_line(' Entered lock version');
1405: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
1406: pa_debug.g_err_stage:='Entered ' || L_FuncProc ;
1407: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1408: END IF;
1409:
1410: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1407: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

1403:
1404: --dbms_output.put_line(' Entered lock version');
1405: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
1406: pa_debug.g_err_stage:='Entered ' || L_FuncProc ;
1407: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1408: END IF;
1409:
1410: x_return_status := FND_API.G_RET_STS_SUCCESS;
1411:

Line 1461: PA_DEBUG.write_log (x_module => G_PKG_NAME

1457: THEN
1458:
1459: x_return_status := FND_API.G_RET_STS_ERROR;
1460: IF P_DEBUG_MODE = 'Y' THEN
1461: PA_DEBUG.write_log (x_module => G_PKG_NAME
1462: ,x_msg => 'Expected Error:' || L_FuncProc || SQLERRM
1463: ,x_log_level => 5);
1464: END IF;
1465: FND_MSG_PUB.Count_And_Get

Line 1474: PA_DEBUG.write_log (x_module => G_PKG_NAME

1470: THEN
1471:
1472: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1473: IF P_DEBUG_MODE = 'Y' THEN
1474: PA_DEBUG.write_log (x_module => G_PKG_NAME
1475: ,x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM
1476: ,x_log_level => 5);
1477: END IF;
1478: FND_MSG_PUB.Count_And_Get

Line 1486: PA_DEBUG.write_log (x_module => G_PKG_NAME

1482: WHEN OTHERS THEN
1483:
1484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1485: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
1486: PA_DEBUG.write_log (x_module => G_PKG_NAME
1487: ,x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM
1488: ,x_log_level => 5);
1489: END IF;
1490: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

1822: PA_TASK_ASSIGNMENT_UTILS.g_apply_progress_flag := 'N'; -- Bug 4286558
1823:
1824: -- Set the excetption Message and the stack
1825: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TASK_ASSIGNMENTS_PVT.Derive_Task_Assignments'
1826: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1827: --
1828: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1829:
1830: -- Start 4537865

Line 2010: p_procedure_name => PA_DEBUG.G_Err_Stack );

2006: EXCEPTION
2007: WHEN OTHERS THEN
2008: -- Set the exception message and the stack
2009: FND_MSG_PUB.Add_Exc_Msg( p_pkg_name => 'PA_TASK_ASSIGNMENTS_PVT.Copy_Missing_Unplanned_Asgmts',
2010: p_procedure_name => PA_DEBUG.G_Err_Stack );
2011: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2012: RAISE; -- This is optional depending on the needs
2013:
2014: END Copy_Missing_Unplanned_Asgmts;

Line 2134: p_procedure_name => PA_DEBUG.G_Err_Stack );

2130:
2131: WHEN OTHERS THEN
2132: -- Set the exception message and the stack
2133: FND_MSG_PUB.Add_Exc_Msg( p_pkg_name => 'PA_TASK_ASSIGNMENTS_PVT.Check_Period_Details',
2134: p_procedure_name => PA_DEBUG.G_Err_Stack );
2135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2136:
2137: P_PERIOD_NAME := NULL ; -- 4537865
2138: P_PERIOD_START_DATE := NULL ; -- 4537865