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

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

1: PACKAGE BODY pa_open_assignment_pvt AS
2: /*$Header: PAROPVTB.pls 120.3 2007/02/06 09:53:16 dthakker ship $*/
3: --
4: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
5: li_message_level NUMBER := 1;
6: PROCEDURE Create_Open_Assignment
7: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
8: ,p_asgn_creation_mode IN VARCHAR2

Line 154: PA_DEBUG.set_err_stack('PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment');

150: BEGIN
151:
152: --dbms_output.put_line('PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment');
153: -- Initialize the Error Stack
154: PA_DEBUG.set_err_stack('PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment');
155:
156: --Log Message
157: IF (P_DEBUG_MODE = 'Y') THEN
158: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment.begin'

Line 158: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment.begin'

154: PA_DEBUG.set_err_stack('PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment');
155:
156: --Log Message
157: IF (P_DEBUG_MODE = 'Y') THEN
158: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment.begin'
159: ,x_msg => 'Beginning of Create_Open_Assignment'
160: ,x_log_level => li_message_level);
161:
162: END IF;

Line 342: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment'

338:
339: --dbms_output.put_line('calling assignment default');
340: --Log Message
341: IF (P_DEBUG_MODE = 'Y') THEN
342: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment'
343: ,x_msg => 'Getting Utilization Defaults.'
344: ,x_log_level => li_message_level);
345: END IF;
346:

Line 428: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment'

424: l_assignment_rec.expenditure_organization_id IS NOT NULL AND l_assignment_rec.expenditure_organization_id <> FND_API.G_MISS_NUM THEN
425:
426: --Log Message
427: IF (P_DEBUG_MODE = 'Y') THEN
428: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment'
429: ,x_msg => 'Getting Revenue Bill Rate'
430: ,x_log_level => li_message_level);
431:
432: END IF;

Line 458: pa_debug.write(x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment'

454: --END IF;
455:
456: -- FP.M Development
457: IF P_DEBUG_MODE = 'Y' THEN
458: pa_debug.write(x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment'
459: ,x_msg => 'FP.M Development'
460: ,x_log_level => li_message_level);
461: END IF;
462:

Line 497: pa_debug.write(x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment'

493: l_assignment_name_tmp := NULL;
494: END IF;
495:
496: IF P_DEBUG_MODE = 'Y' THEN
497: pa_debug.write(x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment'
498: ,x_msg => 'proj_id='||p_assignment_rec.project_id||
499: ' res_format='||l_proj_req_res_format_id||
500: ' job_id='||l_fcst_job_id_tmp
501: ,x_log_level => li_message_level);

Line 502: pa_debug.write(x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment'

498: ,x_msg => 'proj_id='||p_assignment_rec.project_id||
499: ' res_format='||l_proj_req_res_format_id||
500: ' job_id='||l_fcst_job_id_tmp
501: ,x_log_level => li_message_level);
502: pa_debug.write(x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment'
503: ,x_msg => 'org_id='||l_expenditure_org_id_tmp||
504: ' exp_type='||l_expenditure_type_tmp||
505: ' role_id='||l_project_role_id_tmp||
506: ' named_role='||l_assignment_name_tmp

Line 520: pa_debug.write(x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment'

516: ,p_expenditure_type => l_expenditure_type_tmp
517: ,p_project_role_id => l_project_role_id_tmp
518: ,p_named_role => l_assignment_name_tmp);
519: IF P_DEBUG_MODE = 'Y' THEN
520: pa_debug.write(x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment'
521: ,x_msg => 'resource_list_member_id='||l_assignment_rec.resource_list_member_id
522: ,x_log_level => li_message_level);
523: END IF;
524:

Line 583: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment.location'

579: WHERE project_id = l_assignment_rec.project_id;
580: */
581: --Log Message
582: IF (P_DEBUG_MODE = 'Y') THEN
583: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment.location'
584: ,x_msg => 'No need to get location from project'
585: ,x_log_level => li_message_level);
586: END IF;
587:

Line 704: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment.insert_row'

700: IF p_validate_only = FND_API.G_FALSE AND FND_MSG_PUB.Count_Msg = 0 THEN
701:
702: --Log Message
703: IF (P_DEBUG_MODE = 'Y') THEN
704: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment.insert_row'
705: ,x_msg => 'Inserting record into pa_project_assignments.'
706: ,x_log_level => li_message_level);
707: END IF;
708:

Line 792: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment.insert_schedule'

788: x_new_assignment_id := l_assignment_id;
789:
790: --Log Message
791: IF (P_DEBUG_MODE = 'Y') THEN
792: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment.insert_schedule'
793: ,x_msg => 'Insert the schedule days for the open assignment.'
794: ,x_log_level => li_message_level);
795: END IF;
796:

Line 850: pa_debug.write(x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment'

846: IF p_assignment_rec.project_id <> FND_API.G_MISS_NUM AND
847: p_asgn_creation_mode <> 'COPY' THEN
848:
849: IF P_DEBUG_MODE = 'Y' THEN
850: pa_debug.write(x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment'
851: ,x_msg => 'FP.M Development'
852: ,x_log_level => li_message_level);
853:
854: pa_debug.write(x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment'

Line 854: pa_debug.write(x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment'

850: pa_debug.write(x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment'
851: ,x_msg => 'FP.M Development'
852: ,x_log_level => li_message_level);
853:
854: pa_debug.write(x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment'
855: ,x_msg => 'resource_list_member_id'||l_assignment_rec.resource_list_member_id
856: ,x_log_level => li_message_level);
857:
858: pa_debug.write(x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment'

Line 858: pa_debug.write(x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment'

854: pa_debug.write(x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment'
855: ,x_msg => 'resource_list_member_id'||l_assignment_rec.resource_list_member_id
856: ,x_log_level => li_message_level);
857:
858: pa_debug.write(x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment'
859: ,x_msg => 'budget_version_id'||p_budget_version_id
860: ,x_log_level => li_message_level);
861: END IF;
862:

Line 926: pa_debug.write(x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment'

922: ,x_msg_data => l_msg_data
923: );
924:
925: IF P_DEBUG_MODE = 'Y' THEN
926: pa_debug.write(x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment'
927: ,x_msg => 'create_opn_asg_schedule '||l_return_status
928: ,x_log_level => li_message_level);
929: END IF;
930:

Line 937: PA_DEBUG.WRITE('PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment', 'About to call .Calc_Init_Transfer_Price', 3);

933:
934: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
935:
936: IF p_debug_mode = 'Y' THEN
937: PA_DEBUG.WRITE('PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment', 'About to call .Calc_Init_Transfer_Price', 3);
938: PA_DEBUG.WRITE('PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment', 'Assignment_id is :'||l_assignment_id||' and start date:'||l_assignment_rec.start_date, 3);
939: END IF;
940:
941: FOR i IN PA_ASSIGNMENTS_PUB.g_assignment_id_tbl.FIRST .. PA_ASSIGNMENTS_PUB.g_assignment_id_tbl.LAST LOOP

Line 938: PA_DEBUG.WRITE('PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment', 'Assignment_id is :'||l_assignment_id||' and start date:'||l_assignment_rec.start_date, 3);

934: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
935:
936: IF p_debug_mode = 'Y' THEN
937: PA_DEBUG.WRITE('PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment', 'About to call .Calc_Init_Transfer_Price', 3);
938: PA_DEBUG.WRITE('PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment', 'Assignment_id is :'||l_assignment_id||' and start date:'||l_assignment_rec.start_date, 3);
939: END IF;
940:
941: FOR i IN PA_ASSIGNMENTS_PUB.g_assignment_id_tbl.FIRST .. PA_ASSIGNMENTS_PUB.g_assignment_id_tbl.LAST LOOP
942:

Line 951: pa_debug.write(x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment'

947: x_return_status => l_return_status,
948: x_msg_data => l_msg_data,
949: x_msg_count => l_msg_count );
950: IF P_DEBUG_MODE = 'Y' THEN
951: pa_debug.write(x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment'
952: ,x_msg => 'calc_init_transfer_price '||l_return_status
953: ,x_log_level => li_message_level);
954: END IF;
955: END LOOP;

Line 982: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment'

978: --dbms_output.put_line('start action set ? '||l_start_adv_action_set_flag);
979:
980: --Log Message
981: IF (P_DEBUG_MODE = 'Y') THEN
982: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment'
983: ,x_msg => 'calling PA_ACTION_SETS_PUB.Apply_Action_Set'
984: ,x_log_level => li_message_level);
985: END IF;
986:

Line 998: pa_debug.write(x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment'

994:
995: /*code change end for 2636577*/
996:
997: IF P_DEBUG_MODE = 'Y' THEN
998: pa_debug.write(x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment'
999: ,x_msg => 'before Apply_Action_Set, action_set_id='||l_adv_action_set_id||
1000: ' obj_id='||PA_ASSIGNMENTS_PUB.g_assignment_id_tbl(i).assignment_id||
1001: ' commit='||p_commit||
1002: ' val='||p_validate_only

Line 1020: pa_debug.write(x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment'

1016: ,x_msg_count => l_msg_count
1017: ,x_msg_data => l_msg_data);
1018:
1019: IF P_DEBUG_MODE = 'Y' THEN
1020: pa_debug.write(x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment'
1021: ,x_msg => 'Apply_Action_Set, status='||l_return_status
1022: ,x_log_level => li_message_level);
1023: END IF;
1024:

Line 1035: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment.create_competency'

1031:
1032:
1033: --Log Message
1034: IF (P_DEBUG_MODE = 'Y') THEN
1035: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment.create_competency'
1036: ,x_msg => 'Creating competencies.'
1037: ,x_log_level => li_message_level);
1038: END IF;
1039:

Line 1099: PA_DEBUG.Reset_Err_Stack;

1095:
1096:
1097:
1098: -- Reset the error stack when returning to the calling program
1099: PA_DEBUG.Reset_Err_Stack;
1100:
1101: -- If g_error_exists is TRUE then set the x_return_status to 'E'
1102:
1103: IF PA_ASSIGNMENTS_PUB.g_error_exists = FND_API.G_TRUE THEN

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

1117: x_assignment_row_id := NULL ;
1118:
1119: -- Set the excetption Message and the stack
1120: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment'
1121: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1122: --
1123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1124: RAISE; -- This is optional depending on the needs
1125: END Create_Open_Assignment;

Line 1313: PA_DEBUG.set_err_stack('PA_OPEN_ASSIGNMENT_PVT.Update_Open_Assignment');

1309: WHERE assignment_id = l_assignment_rec.assignment_id;
1310:
1311: BEGIN
1312: -- Initialize the Error Stack
1313: PA_DEBUG.set_err_stack('PA_OPEN_ASSIGNMENT_PVT.Update_Open_Assignment');
1314:
1315: --Log Message
1316: IF (P_DEBUG_MODE = 'Y') THEN
1317: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Update_Open_Assignment.begin'

Line 1317: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Update_Open_Assignment.begin'

1313: PA_DEBUG.set_err_stack('PA_OPEN_ASSIGNMENT_PVT.Update_Open_Assignment');
1314:
1315: --Log Message
1316: IF (P_DEBUG_MODE = 'Y') THEN
1317: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Update_Open_Assignment.begin'
1318: ,x_msg => 'Beginning of Update_Open_Assignment'
1319: ,x_log_level => li_message_level);
1320: END IF;
1321:

Line 1350: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Update_Open_Assignment.begin'

1346: END IF;
1347:
1348: --Log Message
1349: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1350: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Update_Open_Assignment.begin'
1351: ,x_msg => 'Old resource list member id='||l_cur_resource_list_member_id
1352: ,x_log_level => li_message_level);
1353: END IF;
1354:

Line 1389: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Update_Open_Assignment.begin'

1385: p_assignment_rec.assignment_name <> FND_API.G_MISS_CHAR AND
1386: p_assignment_rec.assignment_name <> l_cur_assignment_name) THEN
1387: --Log Message
1388: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1389: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Update_Open_Assignment.begin'
1390: ,x_msg => 'Mandatory attributes changed'
1391: ,x_log_level => li_message_level);
1392: END IF;
1393:

Line 1420: pa_debug.write(x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment'

1416: l_assignment_name_tmp := NULL;
1417: END IF;
1418:
1419: IF P_DEBUG_MODE = 'Y' THEN
1420: pa_debug.write(x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment'
1421: ,x_msg => 'proj_id='||p_assignment_rec.project_id||
1422: ' res_format='||l_proj_req_res_format_id||
1423: ' job_id='||l_fcst_job_id_tmp
1424: ,x_log_level => li_message_level);

Line 1425: pa_debug.write(x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment'

1421: ,x_msg => 'proj_id='||p_assignment_rec.project_id||
1422: ' res_format='||l_proj_req_res_format_id||
1423: ' job_id='||l_fcst_job_id_tmp
1424: ,x_log_level => li_message_level);
1425: pa_debug.write(x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment'
1426: ,x_msg => 'org_id='||l_expenditure_org_id_tmp||
1427: ' exp_type='||l_expenditure_type_tmp||
1428: ' role_id='||l_project_role_id_tmp||
1429: ' named_role='||l_assignment_name_tmp

Line 1444: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Update_Open_Assignment.begin'

1440: ,p_project_role_id => l_project_role_id_tmp
1441: ,p_named_role => l_assignment_name_tmp);
1442: --Log Message
1443: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1444: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Update_Open_Assignment.begin'
1445: ,x_msg => 'new resource list member id='||l_assignment_rec.resource_list_member_id
1446: ,x_log_level => li_message_level);
1447: END IF;
1448:

Line 1513: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Update_Open_Assignment.begin'

1509: ,X_return_status => l_return_status
1510: );
1511: --Log Message
1512: IF P_DEBUG_MODE = 'Y' THEN -- Added Debug Profile Option Check for bug#2674619
1513: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Update_Open_Assignment.begin'
1514: ,x_msg => 'Get resource defaults, status='||l_return_status
1515: ,x_log_level => li_message_level);
1516: END IF;
1517:

Line 1540: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Update_Open_Assignment.begin'

1536: ,x_return_status => l_return_status
1537: );
1538: --Log Message
1539: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1540: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Update_Open_Assignment.begin'
1541: ,x_msg => 'Update_task_assignments, status='||l_return_status
1542: ,x_log_level => li_message_level);
1543: END IF;
1544:

Line 1575: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Update_Open_Assignment.begin'

1571: ,x_return_status => l_return_status
1572: );
1573: --Log Message
1574: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1575: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Update_Open_Assignment.begin'
1576: ,x_msg => 'Update_task_assignments, status='||l_return_status
1577: ,x_log_level => li_message_level);
1578: END IF;
1579:

Line 1615: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Update_Open_Assignment.begin'

1611: END IF;
1612:
1613: --Log Message
1614: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1615: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Update_Open_Assignment.begin'
1616: ,x_msg => 'Update_task_assignments, status='||l_return_status
1617: ,x_log_level => li_message_level);
1618: END IF;
1619:

Line 1628: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Update_Open_Assignment.begin'

1624: p_assignment_rec.assignment_name <> l_cur_assignment_name THEN
1625:
1626: --Log Message
1627: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1628: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Update_Open_Assignment.begin'
1629: ,x_msg => 'Mandatory attributes not changed'
1630: ,x_log_level => li_message_level);
1631: END IF;
1632:

Line 1653: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Update_Open_Assignment.begin'

1649: ,x_return_status => l_return_status
1650: );
1651: --Log Message
1652: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1653: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Update_Open_Assignment.begin'
1654: ,x_msg => 'Update_task_assignments, status='||l_return_status
1655: ,x_log_level => li_message_level);
1656: END IF;
1657:

Line 1785: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Update_Open_Assignment.update_row'

1781: THEN
1782:
1783: --Log Message
1784: IF (P_DEBUG_MODE = 'Y') THEN
1785: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Update_Open_Assignment.update_row'
1786: ,x_msg => 'Update Assignment Record in the table'
1787: ,x_log_level => li_message_level);
1788: END IF;
1789:

Line 1872: PA_DEBUG.Reset_Err_Stack;

1868: END IF;
1869:
1870:
1871: -- Reset the error stack when returning to the calling program
1872: PA_DEBUG.Reset_Err_Stack;
1873:
1874: -- If g_error_exists is TRUE then set the x_return_status to 'E'
1875:
1876: IF PA_ASSIGNMENTS_PUB.g_error_exists = FND_API.G_TRUE THEN

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

1883: WHEN OTHERS THEN
1884:
1885: -- Set the excetption Message and the stack
1886: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_OPEN_ASSIGNMENT_PVT.Update_Open_Assignment'
1887: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1888: --
1889: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1890: RAISE; -- This is optional depending on the needs
1891: END Update_Open_Assignment;

Line 1928: PA_DEBUG.set_err_stack('PA_OPEN_ASSIGNMENT_PVT.Delete_Open_Assignment');

1924: AND status_code <> 'DELETED';
1925:
1926: BEGIN
1927: -- Initialize the Error Stack
1928: PA_DEBUG.set_err_stack('PA_OPEN_ASSIGNMENT_PVT.Delete_Open_Assignment');
1929:
1930: --Log Message
1931: IF (P_DEBUG_MODE = 'Y') THEN
1932: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Delete_Open_Assignment.begin'

Line 1932: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Delete_Open_Assignment.begin'

1928: PA_DEBUG.set_err_stack('PA_OPEN_ASSIGNMENT_PVT.Delete_Open_Assignment');
1929:
1930: --Log Message
1931: IF (P_DEBUG_MODE = 'Y') THEN
1932: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Delete_Open_Assignment.begin'
1933: ,x_msg => 'Beginning of Delete_Open_Assignment'
1934: ,x_log_level => li_message_level);
1935: END IF;
1936:

Line 1946: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Delete_Open_Assignment.delete_schedule'

1942: IF p_calling_module <> 'TEMPLATE_REQUIREMENT' THEN
1943:
1944: --Log Message
1945: IF (P_DEBUG_MODE = 'Y') THEN
1946: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Delete_Open_Assignment.delete_schedule'
1947: ,x_msg => 'Deleting Open Assignment schedules'
1948: ,x_log_level => li_message_level);
1949: END IF;
1950:

Line 2042: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Delete_Open_Assignment.del_competency'

2038: FOR i IN l_competency_tbl.FIRST .. l_competency_tbl.LAST LOOP
2039:
2040: --Log Message
2041: IF (P_DEBUG_MODE = 'Y') THEN
2042: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Delete_Open_Assignment.del_competency'
2043: ,x_msg => 'Deleting Requirement Competencies.'
2044: ,x_log_level => li_message_level);
2045: END IF;
2046:

Line 2069: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Delete_Open_Assignment.del_asgmt'

2065: ELSE
2066:
2067: --Log Message
2068: IF (P_DEBUG_MODE = 'Y') THEN
2069: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Delete_Open_Assignment.del_asgmt'
2070: ,x_msg => 'Deleting Requirement Record'
2071: ,x_log_level => li_message_level);
2072: END IF;
2073:

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

2113: WHEN OTHERS THEN
2114:
2115: -- Set the excetption Message and the stack
2116: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_OPEN_ASSIGNMENT_PVT.Delete_Open_Assignment'
2117: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
2118: --
2119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2120: RAISE;
2121: END Delete_Open_Assignment;