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.13.12020000.5 2013/04/30 18:51:44 sachandr 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 281: pa_debug.g_err_stage:='Entered ' || L_FuncProc ;

277: --Bug 4363092: MOAC Changes: Commenting beloew call as l_org_id is not used anywhere
278: --fnd_profile.get('ORG_ID', l_org_id);
279:
280: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
281: pa_debug.g_err_stage:='Entered ' || L_FuncProc ;
282: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
283: END IF;
284: --dbms_output.put_line('Entered Create Task Asgmts.');
285: -- Standard begin of API savepoint

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

278: --fnd_profile.get('ORG_ID', l_org_id);
279:
280: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
281: pa_debug.g_err_stage:='Entered ' || L_FuncProc ;
282: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
283: END IF;
284: --dbms_output.put_line('Entered Create Task Asgmts.');
285: -- Standard begin of API savepoint
286:

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

318:
319: --dbms_output.put_line('Initialized message table.');
320:
321: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
322: pa_debug.g_err_stage:='Checking p_pm_product_code ' || L_FuncProc;
323: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
324: END IF;
325:
326: IF p_pm_product_code IS NOT NULL

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

319: --dbms_output.put_line('Initialized message table.');
320:
321: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
322: pa_debug.g_err_stage:='Checking p_pm_product_code ' || L_FuncProc;
323: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
324: END IF;
325:
326: IF p_pm_product_code IS NOT NULL
327: AND p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

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

349:
350: --dbms_output.put_line('User id :' || l_user_id || 'l_resp_id' || l_resp_id);
351:
352: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
353: pa_debug.g_err_stage:=' p_pm_product_code check successful.' || L_FuncProc;
354: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
355: END IF;
356: --> Need sep. fn. for periods ? check..
357:

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

350: --dbms_output.put_line('User id :' || l_user_id || 'l_resp_id' || l_resp_id);
351:
352: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
353: pa_debug.g_err_stage:=' p_pm_product_code check successful.' || L_FuncProc;
354: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
355: END IF;
356: --> Need sep. fn. for periods ? check..
357:
358: l_module_name := 'PA_PM_ADD_TASK_ASSIGNMENT';

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

377: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
378:
379: --dbms_output.put_line('Project_id not successful ');
380: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
381: pa_debug.g_err_stage:=' Project ref to id check not successful.' || L_FuncProc;
382: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
383: END IF;
384: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
385:

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

378:
379: --dbms_output.put_line('Project_id not successful ');
380: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
381: pa_debug.g_err_stage:=' Project ref to id check not successful.' || L_FuncProc;
382: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
383: END IF;
384: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
385:
386: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

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

386: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
387:
388: --dbms_output.put_line('Project_id conv. not successful ');
389: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
390: pa_debug.g_err_stage:=' Project ref to id check not successful.' || L_FuncProc;
391: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
392: END IF;
393: RAISE FND_API.G_EXC_ERROR;
394:

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

387:
388: --dbms_output.put_line('Project_id conv. not successful ');
389: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
390: pa_debug.g_err_stage:=' Project ref to id check not successful.' || L_FuncProc;
391: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
392: END IF;
393: RAISE FND_API.G_EXC_ERROR;
394:
395: END IF;

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

396: END IF;
397:
398: --dbms_output.put_line('Project ref to id check successful for Project ' || l_Project_id);
399: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
400: pa_debug.g_err_stage:=' Project ref to id check successful.' || L_FuncProc;
401: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
402: END IF;
403: -- As part of enforcing project security, which would determine
404: -- whether the user has the necessary privileges to update the project

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

397:
398: --dbms_output.put_line('Project ref to id check successful for Project ' || l_Project_id);
399: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
400: pa_debug.g_err_stage:=' Project ref to id check successful.' || L_FuncProc;
401: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
402: END IF;
403: -- As part of enforcing project security, which would determine
404: -- whether the user has the necessary privileges to update the project
405: -- need to call the pa_security package

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

406:
407: pa_security.initialize (X_user_id => l_user_id,
408: X_calling_module => l_module_name);
409: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
410: pa_debug.g_err_stage:=' After initializing security..' || L_FuncProc;
411: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
412: END IF;
413: -- Actions performed using the APIs would be subject to
414: -- function security. If the responsibility does not allow

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

407: pa_security.initialize (X_user_id => l_user_id,
408: X_calling_module => l_module_name);
409: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
410: pa_debug.g_err_stage:=' After initializing security..' || L_FuncProc;
411: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
412: END IF;
413: -- Actions performed using the APIs would be subject to
414: -- function security. If the responsibility does not allow
415: -- such functions to be executed, the API should not proceed further

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

442: RAISE FND_API.G_EXC_ERROR;
443: END IF;
444:
445: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
446: pa_debug.g_err_stage:=' PA_PM_ADD_TASK_ASSIGNMENT function check successful.' || L_FuncProc;
447: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
448: END IF;
449: --dbms_output.put_line('PA_PM_ADD_TASK_ASSIGNMENT function check successful.');
450: IF l_function_allowed = 'N' THEN

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

443: END IF;
444:
445: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
446: pa_debug.g_err_stage:=' PA_PM_ADD_TASK_ASSIGNMENT function check successful.' || L_FuncProc;
447: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
448: END IF;
449: --dbms_output.put_line('PA_PM_ADD_TASK_ASSIGNMENT function check successful.');
450: IF l_function_allowed = 'N' THEN
451: pa_interface_utils_pub.map_new_amg_msg

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

461: RAISE FND_API.G_EXC_ERROR;
462: END IF;
463: --dbms_output.put_line('PA_FUNCTION_SECURITY_ENFORCED function check successful.');
464: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
465: pa_debug.g_err_stage:=' PA_FUNCTION_SECURITY_ENFORCED function check successful.' || L_FuncProc;
466: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
467: END IF;
468:
469:

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

462: END IF;
463: --dbms_output.put_line('PA_FUNCTION_SECURITY_ENFORCED function check successful.');
464: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
465: pa_debug.g_err_stage:=' PA_FUNCTION_SECURITY_ENFORCED function check successful.' || L_FuncProc;
466: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
467: END IF;
468:
469:
470: -- Now verify whether project security allows the user to update

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

494: END IF;
495:
496: --dbms_output.put_line('pa_security.allow_query or update successful..');
497: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
498: pa_debug.g_err_stage:='PA_PROJECT_SECURITY_ENFORCED function check successful.' || L_FuncProc;
499: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
500: END IF;
501: --dbms_output.put_line('Project Id:' || l_project_id);
502:

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

495:
496: --dbms_output.put_line('pa_security.allow_query or update successful..');
497: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
498: pa_debug.g_err_stage:='PA_PROJECT_SECURITY_ENFORCED function check successful.' || L_FuncProc;
499: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
500: END IF;
501: --dbms_output.put_line('Project Id:' || l_project_id);
502:
503: IF NVL(PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id ), 'N') = 'N' THEN

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

519: END IF;
520:
521: --dbms_output.put_line('PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS IS Fine..');
522: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
523: pa_debug.g_err_stage:='PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS function check successful.' || L_FuncProc;
524: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
525: END IF;
526:
527: IF p_pa_structure_version_id IS NOT NULL AND

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

520:
521: --dbms_output.put_line('PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS IS Fine..');
522: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
523: pa_debug.g_err_stage:='PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS function check successful.' || L_FuncProc;
524: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
525: END IF;
526:
527: IF p_pa_structure_version_id IS NOT NULL AND
528: (p_pa_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN

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

575: RAISE FND_API.G_EXC_ERROR;
576: END IF;
577:
578: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
579: pa_debug.g_err_stage:='struct_elem version id function check successful.' || L_FuncProc;
580: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
581: END IF;
582:
583:

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

576: END IF;
577:
578: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
579: pa_debug.g_err_stage:='struct_elem version id function check successful.' || L_FuncProc;
580: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
581: END IF;
582:
583:
584: OPEN C_Get_Budget_Version_Id(l_struct_elem_version_id, l_project_id);

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

604:
605: l_count := p_task_assignment_periods_in.COUNT;
606:
607: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
608: pa_debug.g_err_stage:='Count of task assignment periods' || l_count || ':' || L_FuncProc;
609: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
610: END IF;
611:
612: --dbms_output.put_line(' Input Count of Global Input Tables..: ' || l_count );

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

605: l_count := p_task_assignment_periods_in.COUNT;
606:
607: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
608: pa_debug.g_err_stage:='Count of task assignment periods' || l_count || ':' || L_FuncProc;
609: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
610: END IF;
611:
612: --dbms_output.put_line(' Input Count of Global Input Tables..: ' || l_count );
613:

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

681:
682: --dbms_output.put_line('l_d_task_id valid input:'|| l_d_task_id);
683:
684: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
685: pa_debug.g_err_stage:='task_id ' || l_d_task_id;
686: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
687: END IF;
688:
689: --dbms_output.put_line('l_d_task_id'|| l_d_task_id);

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

682: --dbms_output.put_line('l_d_task_id valid input:'|| l_d_task_id);
683:
684: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
685: pa_debug.g_err_stage:='task_id ' || l_d_task_id;
686: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
687: END IF;
688:
689: --dbms_output.put_line('l_d_task_id'|| l_d_task_id);
690:

Line 904: pa_debug.g_err_stage := 'ETC Start Date - ' || l_etc_start_date;

900:
901: -- Bug 8498316 - Raise an error if data is passed for a period which
902: -- is prior to the period on which the etc start date falls.
903: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
904: pa_debug.g_err_stage := 'ETC Start Date - ' || l_etc_start_date;
905: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
906: END IF;
907:
908: IF p_task_assignment_periods_in(i).resource_list_member_id IS NOT NULL AND

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

901: -- Bug 8498316 - Raise an error if data is passed for a period which
902: -- is prior to the period on which the etc start date falls.
903: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
904: pa_debug.g_err_stage := 'ETC Start Date - ' || l_etc_start_date;
905: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
906: END IF;
907:
908: IF p_task_assignment_periods_in(i).resource_list_member_id IS NOT NULL AND
909: p_task_assignment_periods_in(i).resource_list_member_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

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

1162:
1163: --dbms_output.put_line('End of Loop');
1164:
1165: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
1166: 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;
1167: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1168:
1169:
1170: 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 1167: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

1163: --dbms_output.put_line('End of Loop');
1164:
1165: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
1166: 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;
1167: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1168:
1169:
1170: 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;
1171: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

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

1166: 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;
1167: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1168:
1169:
1170: 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;
1171: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1172:
1173:
1174: 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 1171: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

1167: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1168:
1169:
1170: 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;
1171: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1172:
1173:
1174: 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;
1175: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

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

1170: 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;
1171: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1172:
1173:
1174: 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;
1175: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1176:
1177:
1178: 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 1175: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

1171: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1172:
1173:
1174: 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;
1175: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1176:
1177:
1178: 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;
1179: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

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

1174: 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;
1175: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1176:
1177:
1178: 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;
1179: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1180:
1181:
1182: 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 1179: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

1175: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1176:
1177:
1178: 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;
1179: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1180:
1181:
1182: 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;
1183: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

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

1178: 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;
1179: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1180:
1181:
1182: 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;
1183: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1184:
1185:
1186: 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 1183: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

1179: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1180:
1181:
1182: 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;
1183: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1184:
1185:
1186: 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;
1187: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

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

1182: 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;
1183: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1184:
1185:
1186: 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;
1187: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1188:
1189:
1190: 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 1187: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

1183: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1184:
1185:
1186: 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;
1187: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1188:
1189:
1190: 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;
1191: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

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

1186: 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;
1187: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1188:
1189:
1190: 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;
1191: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1192:
1193: 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;
1194: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

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

1187: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1188:
1189:
1190: 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;
1191: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1192:
1193: 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;
1194: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1195:

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

1189:
1190: 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;
1191: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1192:
1193: 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;
1194: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1195:
1196: 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;
1197: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

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

1190: 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;
1191: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1192:
1193: 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;
1194: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1195:
1196: 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;
1197: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1198: END IF;

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

1192:
1193: 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;
1194: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1195:
1196: 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;
1197: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1198: END IF;
1199:
1200: val_index := val_index + 1;

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

1193: 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;
1194: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1195:
1196: 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;
1197: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1198: END IF;
1199:
1200: val_index := val_index + 1;
1201:

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

1268:
1269:
1270:
1271: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
1272: pa_debug.g_err_stage:='Calling context.' ||l_calling_context;
1273: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1274:
1275: pa_debug.g_err_stage:='Return status B4 add fin plan lines:' ||x_return_status;
1276: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

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

1269:
1270:
1271: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
1272: pa_debug.g_err_stage:='Calling context.' ||l_calling_context;
1273: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1274:
1275: pa_debug.g_err_stage:='Return status B4 add fin plan lines:' ||x_return_status;
1276: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1277: END IF;

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

1271: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
1272: pa_debug.g_err_stage:='Calling context.' ||l_calling_context;
1273: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1274:
1275: pa_debug.g_err_stage:='Return status B4 add fin plan lines:' ||x_return_status;
1276: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1277: END IF;
1278:
1279: --dbms_output.put_line('Calling PA_FIN_PLAN_PVT.ADD_FIN_PLAN_LINES');

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

1272: pa_debug.g_err_stage:='Calling context.' ||l_calling_context;
1273: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1274:
1275: pa_debug.g_err_stage:='Return status B4 add fin plan lines:' ||x_return_status;
1276: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1277: END IF;
1278:
1279: --dbms_output.put_line('Calling PA_FIN_PLAN_PVT.ADD_FIN_PLAN_LINES');
1280: PA_FIN_PLAN_PVT.ADD_FIN_PLAN_LINES

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

1287:
1288: --dbms_output.put_line('After returning from returning from add fin plan lines. return status:' ||x_return_status );
1289:
1290: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
1291: pa_debug.g_err_stage:='Return status after add fin plan lines:' ||x_return_status;
1292: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1293: END IF;
1294:
1295: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

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

1288: --dbms_output.put_line('After returning from returning from add fin plan lines. return status:' ||x_return_status );
1289:
1290: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
1291: pa_debug.g_err_stage:='Return status after add fin plan lines:' ||x_return_status;
1292: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1293: END IF;
1294:
1295: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1393: PA_DEBUG.write_log (x_module => G_PKG_NAME

1389: ROLLBACK TO add_task_asgmt_periods;
1390:
1391: x_return_status := FND_API.G_RET_STS_ERROR;
1392: IF P_DEBUG_MODE = 'Y' THEN
1393: PA_DEBUG.write_log (x_module => G_PKG_NAME
1394: ,x_msg => 'Expected Error:' || L_FuncProc || SQLERRM
1395: ,x_log_level => 5);
1396: END IF;
1397: FND_MSG_PUB.Count_And_Get

Line 1407: PA_DEBUG.write_log (x_module => G_PKG_NAME

1403: ROLLBACK TO add_task_asgmt_periods;
1404:
1405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1406: IF P_DEBUG_MODE = 'Y' THEN
1407: PA_DEBUG.write_log (x_module => G_PKG_NAME
1408: ,x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM
1409: ,x_log_level => 5);
1410: END IF;
1411: FND_MSG_PUB.Count_And_Get

Line 1420: PA_DEBUG.write_log (x_module => G_PKG_NAME

1416: ROLLBACK TO add_task_asgmt_periods;
1417:
1418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1419: IF P_DEBUG_MODE = 'Y' THEN
1420: PA_DEBUG.write_log (x_module => G_PKG_NAME
1421: ,x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM
1422: ,x_log_level => 5);
1423: END IF;
1424: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

1615: L_FuncProc := 'lock_version';
1616:
1617: --dbms_output.put_line(' Entered lock version');
1618: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
1619: pa_debug.g_err_stage:='Entered ' || L_FuncProc ;
1620: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1621: END IF;
1622:
1623: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1616:
1617: --dbms_output.put_line(' Entered lock version');
1618: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
1619: pa_debug.g_err_stage:='Entered ' || L_FuncProc ;
1620: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1621: END IF;
1622:
1623: x_return_status := FND_API.G_RET_STS_SUCCESS;
1624:

Line 1674: PA_DEBUG.write_log (x_module => G_PKG_NAME

1670: THEN
1671:
1672: x_return_status := FND_API.G_RET_STS_ERROR;
1673: IF P_DEBUG_MODE = 'Y' THEN
1674: PA_DEBUG.write_log (x_module => G_PKG_NAME
1675: ,x_msg => 'Expected Error:' || L_FuncProc || SQLERRM
1676: ,x_log_level => 5);
1677: END IF;
1678: FND_MSG_PUB.Count_And_Get

Line 1687: PA_DEBUG.write_log (x_module => G_PKG_NAME

1683: THEN
1684:
1685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1686: IF P_DEBUG_MODE = 'Y' THEN
1687: PA_DEBUG.write_log (x_module => G_PKG_NAME
1688: ,x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM
1689: ,x_log_level => 5);
1690: END IF;
1691: FND_MSG_PUB.Count_And_Get

Line 1699: PA_DEBUG.write_log (x_module => G_PKG_NAME

1695: WHEN OTHERS THEN
1696:
1697: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1698: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
1699: PA_DEBUG.write_log (x_module => G_PKG_NAME
1700: ,x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM
1701: ,x_log_level => 5);
1702: END IF;
1703: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

2057: PA_TASK_ASSIGNMENT_UTILS.g_apply_progress_flag := 'N'; -- Bug 4286558
2058:
2059: -- Set the excetption Message and the stack
2060: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TASK_ASSIGNMENTS_PVT.Derive_Task_Assignments'
2061: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
2062: --
2063: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2064:
2065: -- Start 4537865

Line 2250: p_procedure_name => PA_DEBUG.G_Err_Stack );

2246: EXCEPTION
2247: WHEN OTHERS THEN
2248: -- Set the exception message and the stack
2249: FND_MSG_PUB.Add_Exc_Msg( p_pkg_name => 'PA_TASK_ASSIGNMENTS_PVT.Copy_Missing_Unplanned_Asgmts',
2250: p_procedure_name => PA_DEBUG.G_Err_Stack );
2251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2252: RAISE; -- This is optional depending on the needs
2253:
2254: END Copy_Missing_Unplanned_Asgmts;

Line 2374: p_procedure_name => PA_DEBUG.G_Err_Stack );

2370:
2371: WHEN OTHERS THEN
2372: -- Set the exception message and the stack
2373: FND_MSG_PUB.Add_Exc_Msg( p_pkg_name => 'PA_TASK_ASSIGNMENTS_PVT.Check_Period_Details',
2374: p_procedure_name => PA_DEBUG.G_Err_Stack );
2375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2376:
2377: P_PERIOD_NAME := NULL ; -- 4537865
2378: P_PERIOD_START_DATE := NULL ; -- 4537865