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.5 2011/06/01 00:16:22 nisinha 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 157: PA_DEBUG.set_err_stack('PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

928: ,x_msg_data => l_msg_data
929: );
930:
931: IF P_DEBUG_MODE = 'Y' THEN
932: pa_debug.write(x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment'
933: ,x_msg => 'create_opn_asg_schedule '||l_return_status
934: ,x_log_level => li_message_level);
935: END IF;
936:

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

939:
940: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
941:
942: IF p_debug_mode = 'Y' THEN
943: PA_DEBUG.WRITE('PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment', 'About to call .Calc_Init_Transfer_Price', 3);
944: 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);
945: END IF;
946:
947: FOR i IN PA_ASSIGNMENTS_PUB.g_assignment_id_tbl.FIRST .. PA_ASSIGNMENTS_PUB.g_assignment_id_tbl.LAST LOOP

Line 944: 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);

940: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
941:
942: IF p_debug_mode = 'Y' THEN
943: PA_DEBUG.WRITE('PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment', 'About to call .Calc_Init_Transfer_Price', 3);
944: 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);
945: END IF;
946:
947: FOR i IN PA_ASSIGNMENTS_PUB.g_assignment_id_tbl.FIRST .. PA_ASSIGNMENTS_PUB.g_assignment_id_tbl.LAST LOOP
948:

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

953: x_return_status => l_return_status,
954: x_msg_data => l_msg_data,
955: x_msg_count => l_msg_count );
956: IF P_DEBUG_MODE = 'Y' THEN
957: pa_debug.write(x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment'
958: ,x_msg => 'calc_init_transfer_price '||l_return_status
959: ,x_log_level => li_message_level);
960: END IF;
961: END LOOP;

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

984: --dbms_output.put_line('start action set ? '||l_start_adv_action_set_flag);
985:
986: --Log Message
987: IF (P_DEBUG_MODE = 'Y') THEN
988: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment'
989: ,x_msg => 'calling PA_ACTION_SETS_PUB.Apply_Action_Set'
990: ,x_log_level => li_message_level);
991: END IF;
992:

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

1000:
1001: /*code change end for 2636577*/
1002:
1003: IF P_DEBUG_MODE = 'Y' THEN
1004: pa_debug.write(x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment'
1005: ,x_msg => 'before Apply_Action_Set, action_set_id='||l_adv_action_set_id||
1006: ' obj_id='||PA_ASSIGNMENTS_PUB.g_assignment_id_tbl(i).assignment_id||
1007: ' commit='||p_commit||
1008: ' val='||p_validate_only

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

1022: ,x_msg_count => l_msg_count
1023: ,x_msg_data => l_msg_data);
1024:
1025: IF P_DEBUG_MODE = 'Y' THEN
1026: pa_debug.write(x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment'
1027: ,x_msg => 'Apply_Action_Set, status='||l_return_status
1028: ,x_log_level => li_message_level);
1029: END IF;
1030:

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

1037:
1038:
1039: --Log Message
1040: IF (P_DEBUG_MODE = 'Y') THEN
1041: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment.create_competency'
1042: ,x_msg => 'Creating competencies.'
1043: ,x_log_level => li_message_level);
1044: END IF;
1045:

Line 1105: PA_DEBUG.Reset_Err_Stack;

1101:
1102:
1103:
1104: -- Reset the error stack when returning to the calling program
1105: PA_DEBUG.Reset_Err_Stack;
1106:
1107: -- If g_error_exists is TRUE then set the x_return_status to 'E'
1108:
1109: IF PA_ASSIGNMENTS_PUB.g_error_exists = FND_API.G_TRUE THEN

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

1123: x_assignment_row_id := NULL ;
1124:
1125: -- Set the excetption Message and the stack
1126: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment'
1127: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1128: --
1129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1130: RAISE; -- This is optional depending on the needs
1131: END Create_Open_Assignment;

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

1315: WHERE assignment_id = l_assignment_rec.assignment_id;
1316:
1317: BEGIN
1318: -- Initialize the Error Stack
1319: PA_DEBUG.set_err_stack('PA_OPEN_ASSIGNMENT_PVT.Update_Open_Assignment');
1320:
1321: --Log Message
1322: IF (P_DEBUG_MODE = 'Y') THEN
1323: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Update_Open_Assignment.begin'

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

1319: PA_DEBUG.set_err_stack('PA_OPEN_ASSIGNMENT_PVT.Update_Open_Assignment');
1320:
1321: --Log Message
1322: IF (P_DEBUG_MODE = 'Y') THEN
1323: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Update_Open_Assignment.begin'
1324: ,x_msg => 'Beginning of Update_Open_Assignment'
1325: ,x_log_level => li_message_level);
1326: END IF;
1327:

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

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

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

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

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

1422: l_assignment_name_tmp := NULL;
1423: END IF;
1424:
1425: IF P_DEBUG_MODE = 'Y' THEN
1426: pa_debug.write(x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment'
1427: ,x_msg => 'proj_id='||p_assignment_rec.project_id||
1428: ' res_format='||l_proj_req_res_format_id||
1429: ' job_id='||l_fcst_job_id_tmp
1430: ,x_log_level => li_message_level);

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

1427: ,x_msg => 'proj_id='||p_assignment_rec.project_id||
1428: ' res_format='||l_proj_req_res_format_id||
1429: ' job_id='||l_fcst_job_id_tmp
1430: ,x_log_level => li_message_level);
1431: pa_debug.write(x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment'
1432: ,x_msg => 'org_id='||l_expenditure_org_id_tmp||
1433: ' exp_type='||l_expenditure_type_tmp||
1434: ' role_id='||l_project_role_id_tmp||
1435: ' named_role='||l_assignment_name_tmp

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

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

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

1515: ,X_return_status => l_return_status
1516: );
1517: --Log Message
1518: IF P_DEBUG_MODE = 'Y' THEN -- Added Debug Profile Option Check for bug#2674619
1519: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Update_Open_Assignment.begin'
1520: ,x_msg => 'Get resource defaults, status='||l_return_status
1521: ,x_log_level => li_message_level);
1522: END IF;
1523:

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

1542: ,x_return_status => l_return_status
1543: );
1544: --Log Message
1545: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1546: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Update_Open_Assignment.begin'
1547: ,x_msg => 'Update_task_assignments, status='||l_return_status
1548: ,x_log_level => li_message_level);
1549: END IF;
1550:

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

1577: ,x_return_status => l_return_status
1578: );
1579: --Log Message
1580: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1581: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Update_Open_Assignment.begin'
1582: ,x_msg => 'Update_task_assignments, status='||l_return_status
1583: ,x_log_level => li_message_level);
1584: END IF;
1585:

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

1617: END IF;
1618:
1619: --Log Message
1620: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1621: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Update_Open_Assignment.begin'
1622: ,x_msg => 'Update_task_assignments, status='||l_return_status
1623: ,x_log_level => li_message_level);
1624: END IF;
1625:

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

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

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

1655: ,x_return_status => l_return_status
1656: );
1657: --Log Message
1658: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1659: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Update_Open_Assignment.begin'
1660: ,x_msg => 'Update_task_assignments, status='||l_return_status
1661: ,x_log_level => li_message_level);
1662: END IF;
1663:

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

1787: THEN
1788:
1789: --Log Message
1790: IF (P_DEBUG_MODE = 'Y') THEN
1791: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Update_Open_Assignment.update_row'
1792: ,x_msg => 'Update Assignment Record in the table'
1793: ,x_log_level => li_message_level);
1794: END IF;
1795:

Line 1878: PA_DEBUG.Reset_Err_Stack;

1874: END IF;
1875:
1876:
1877: -- Reset the error stack when returning to the calling program
1878: PA_DEBUG.Reset_Err_Stack;
1879:
1880: -- If g_error_exists is TRUE then set the x_return_status to 'E'
1881:
1882: IF PA_ASSIGNMENTS_PUB.g_error_exists = FND_API.G_TRUE THEN

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

1889: WHEN OTHERS THEN
1890:
1891: -- Set the excetption Message and the stack
1892: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_OPEN_ASSIGNMENT_PVT.Update_Open_Assignment'
1893: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1894: --
1895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1896: RAISE; -- This is optional depending on the needs
1897: END Update_Open_Assignment;

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

1930: AND status_code <> 'DELETED';
1931:
1932: BEGIN
1933: -- Initialize the Error Stack
1934: PA_DEBUG.set_err_stack('PA_OPEN_ASSIGNMENT_PVT.Delete_Open_Assignment');
1935:
1936: --Log Message
1937: IF (P_DEBUG_MODE = 'Y') THEN
1938: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Delete_Open_Assignment.begin'

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

1934: PA_DEBUG.set_err_stack('PA_OPEN_ASSIGNMENT_PVT.Delete_Open_Assignment');
1935:
1936: --Log Message
1937: IF (P_DEBUG_MODE = 'Y') THEN
1938: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Delete_Open_Assignment.begin'
1939: ,x_msg => 'Beginning of Delete_Open_Assignment'
1940: ,x_log_level => li_message_level);
1941: END IF;
1942:

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

1948: IF p_calling_module <> 'TEMPLATE_REQUIREMENT' THEN
1949:
1950: --Log Message
1951: IF (P_DEBUG_MODE = 'Y') THEN
1952: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Delete_Open_Assignment.delete_schedule'
1953: ,x_msg => 'Deleting Open Assignment schedules'
1954: ,x_log_level => li_message_level);
1955: END IF;
1956:

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

2044: FOR i IN l_competency_tbl.FIRST .. l_competency_tbl.LAST LOOP
2045:
2046: --Log Message
2047: IF (P_DEBUG_MODE = 'Y') THEN
2048: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Delete_Open_Assignment.del_competency'
2049: ,x_msg => 'Deleting Requirement Competencies.'
2050: ,x_log_level => li_message_level);
2051: END IF;
2052:

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

2071: ELSE
2072:
2073: --Log Message
2074: IF (P_DEBUG_MODE = 'Y') THEN
2075: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Delete_Open_Assignment.del_asgmt'
2076: ,x_msg => 'Deleting Requirement Record'
2077: ,x_log_level => li_message_level);
2078: END IF;
2079:

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

2119: WHEN OTHERS THEN
2120:
2121: -- Set the excetption Message and the stack
2122: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_OPEN_ASSIGNMENT_PVT.Delete_Open_Assignment'
2123: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
2124: --
2125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2126: RAISE;
2127: END Delete_Open_Assignment;