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

Line 5: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */

1: PACKAGE BODY pa_assignments_pub AS
2: /*$Header: PARAPUBB.pls 120.28 2011/11/24 11:28:15 krkondur ship $*/
3: --
4:
5: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */
6: li_message_level NUMBER := 1;
7:
8: PROCEDURE Execute_Create_Assignment
9: ( p_asgn_creation_mode IN VARCHAR2 := 'FULL'

Line 146: PA_DEBUG.init_err_stack('PA_ASSIGNMENTS_PUB.Exceute_Create_Assignment');

142: AND NVL(end_date_active,TRUNC(SYSDATE));
143: BEGIN
144:
145: -- Initialize the Error Stack
146: PA_DEBUG.init_err_stack('PA_ASSIGNMENTS_PUB.Exceute_Create_Assignment');
147:
148: -- Initialize the return status to success
149: x_return_status := FND_API.G_RET_STS_SUCCESS;
150:

Line 159: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Exceute_Create_Assignment.begin'

155: END IF;
156:
157: --Log Message
158: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
159: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Exceute_Create_Assignment.begin'
160: ,x_msg => 'Beginning of the Execute_Create_Assignment'
161: ,x_log_level => 5);
162: END IF;
163: /*

Line 173: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Exceute_Create_Assignment.begin'

169: close c_validate_work_type;
170:
171: IF l_work_type_exixts='Y' then
172:
173: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Exceute_Create_Assignment.begin'
174: ,x_msg => 'Work type is valid'
175: ,x_log_level => 5);
176: ELSE
177: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Exceute_Create_Assignment.begin'

Line 177: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Exceute_Create_Assignment.begin'

173: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Exceute_Create_Assignment.begin'
174: ,x_msg => 'Work type is valid'
175: ,x_log_level => 5);
176: ELSE
177: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Exceute_Create_Assignment.begin'
178: ,x_msg => 'Work type is not valid'
179: ,x_log_level => 5);
180:
181: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'

Line 264: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Exceute_Create_Assignment'

260: l_assignment_rec.calendar_id := p_calendar_id;
261: l_assignment_rec.resource_calendar_percent := p_resource_calendar_percent;
262:
263: IF P_DEBUG_MODE = 'Y' THEN
264: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Exceute_Create_Assignment'
265: ,x_msg => 'Execute_Create_Assignment before L'
266: ,x_log_level => li_message_level);
267: END IF;
268:

Line 282: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Exceute_Create_Assignment'

278: l_assignment_rec.tp_percent_applied_override := p_tp_percent_applied_override;
279: l_assignment_rec.staffing_owner_person_id := p_staffing_owner_person_id;
280:
281: IF P_DEBUG_MODE = 'Y' THEN
282: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Exceute_Create_Assignment'
283: ,x_msg => 'Execute_Create_Assignment before M'
284: ,x_log_level => li_message_level);
285: END IF;
286: -- FP.M Development

Line 328: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Exceute_Create_Assignment.create_asgmt'

324: --End Bug 3249669 : Check for profile option PA: Global Week Start Day being set.
325:
326: --Log Message
327: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
328: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Exceute_Create_Assignment.create_asgmt'
329: ,x_msg => 'Calling Create_Assignment'
330: ,x_log_level => 5);
331: END IF;
332:

Line 356: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Exceute_Create_Assignment'

352:
353: END IF;
354:
355: IF P_DEBUG_MODE = 'Y' THEN
356: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Exceute_Create_Assignment'
357: ,x_msg => 'before calling pub.Create_Assignment'
358: ,x_log_level => li_message_level);
359: END IF;
360:

Line 401: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Exceute_Create_Assignment'

397: ,x_msg_data => x_msg_data
398: );
399:
400: IF P_DEBUG_MODE = 'Y' THEN
401: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Exceute_Create_Assignment'
402: ,x_msg => 'after calling pub.Create_Assignment'
403: ,x_log_level => li_message_level);
404: END IF;
405:

Line 407: PA_DEBUG.Reset_Err_Stack;

403: ,x_log_level => li_message_level);
404: END IF;
405:
406: -- Reset the error stack when returning to the calling program
407: PA_DEBUG.Reset_Err_Stack;
408:
409: -- If there are any messages in the stack then set x_return_status
410:
411: IF FND_MSG_PUB.Count_Msg > 0 THEN

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

433: EXCEPTION
434: WHEN OTHERS THEN
435: -- Set the excetption Message and the stack
436: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Execute_Create_Assignment'
437: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
438: --
439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
440: RAISE; -- This is optional depending on the needs
441:

Line 482: PA_DEBUG.init_err_stack('PA_ASSIGNMENTS_PUB.Exec_Create_Assign_With_Def');

478: BEGIN
479:
480:
481: -- Initialize the Error Stack
482: PA_DEBUG.init_err_stack('PA_ASSIGNMENTS_PUB.Exec_Create_Assign_With_Def');
483:
484: -- Initialize the return status to success
485: x_return_status := FND_API.G_RET_STS_SUCCESS;
486:

Line 494: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Exec_Create_Assign_With_Def.begin'

490: END IF;
491:
492: --Log Message
493: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
494: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Exec_Create_Assign_With_Def.begin'
495: ,x_msg => 'Beginning of the Exec_Create_Assign_With_Def'
496: ,x_log_level => 5);
497: END IF;
498:

Line 526: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Exec_Create_Assign_With_Def.begin'

522: ,x_error_message_code => l_err_msg_code);
523:
524: --Log Message
525: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
526: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Exec_Create_Assign_With_Def.begin'
527: ,x_msg => 'Calling Create_Assign_With_Def'
528: ,x_log_level => 5);
529: END IF;
530: --

Line 555: PA_DEBUG.Reset_Err_Stack;

551: );
552:
553:
554: -- Reset the error stack when returning to the calling program
555: PA_DEBUG.Reset_Err_Stack;
556:
557: -- Put any message text from message stack into the Message ARRAY
558: EXCEPTION
559: WHEN OTHERS THEN

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

559: WHEN OTHERS THEN
560:
561: -- Set the excetption Message and the stack
562: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Execute_Create_Assignment'
563: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
564: --
565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
566: RAISE; -- This is optional depending on the needs
567:

Line 635: PA_DEBUG.init_err_stack('PA_ASSIGNMENTS_PUB.Create_Assign_With_Def');

631:
632: l_assignment_rec := p_assignment_rec;
633:
634: -- Initialize the Error Stack
635: PA_DEBUG.init_err_stack('PA_ASSIGNMENTS_PUB.Create_Assign_With_Def');
636:
637: -- Initialize the error flag
638: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_FALSE;
639:

Line 655: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Create_Assign_With_Def.begin'

651: FND_MSG_PUB.initialize;
652: END IF;
653: --Log Message
654: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
655: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Create_Assign_With_Def.begin'
656: ,x_msg => 'Beginning of Create_Assign_With_Def'
657: ,x_log_level => 5);
658: END IF;
659:

Line 728: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Create_Assign_With_Def.role_defaults'

724: END IF;
725:
726: --Log Message
727: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
728: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Create_Assign_With_Def.role_defaults'
729: ,x_msg => 'After gettting role defaults'
730: ,x_log_level => 5);
731: END IF;
732:

Line 760: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Create_Assign_With_Def.utilization_defaults'

756: END IF;
757:
758: --Log Message
759: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
760: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Create_Assign_With_Def.utilization_defaults'
761: ,x_msg => 'After gettting utilization defaults'
762: ,x_log_level => 5);
763: END IF;
764: END IF;

Line 805: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Create_Assign_With_Def.create_asgmt'

801: ,x_error_message_code => l_err_msg_code);
802:
803: --Log Message
804: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
805: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Create_Assign_With_Def.create_asgmt'
806: ,x_msg => 'Calling Create_Assignment'
807: ,x_log_level => 5);
808: END IF;
809:

Line 851: PA_DEBUG.Reset_Err_Stack;

847: END IF;
848:
849: -- Reset the error stack when returning to the calling program
850:
851: PA_DEBUG.Reset_Err_Stack;
852:
853: -- If g_error_exists is TRUE then set the x_return_status to 'E'
854:
855: IF FND_MSG_PUB.Count_Msg >0 THEN

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

874: ROLLBACK TO ASG_PUB_CREATE_ASGMT_WITH_DEF;
875: END IF;
876: -- Set the excetption Message and the stack
877: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Create_Assignment'
878: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
879: --
880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
881: RAISE; -- This is optional depending on the needs
882: --

Line 1002: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Create_Assignment'

998:
999: BEGIN
1000:
1001: IF P_DEBUG_MODE = 'Y' THEN
1002: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Create_Assignment'
1003: ,x_msg => 'Entrance of pub.Create_Assignment'
1004: ,x_log_level => li_message_level);
1005: END IF;
1006:

Line 1011: PA_DEBUG.init_err_stack('PA_ASSIGNMENTS_PUB.Create_Assignment');

1007: --dbms_output.put_line('PA_ASSIGNMENTS_PUB.Create_Assignment');
1008: /* Moved the call for deleting the global table from below to above for bug 3079906*/
1009: PA_ASSIGNMENTS_PUB.g_assignment_id_tbl.DELETE;
1010: -- Initialize the Error Stack
1011: PA_DEBUG.init_err_stack('PA_ASSIGNMENTS_PUB.Create_Assignment');
1012:
1013: -- Initialize the error flag
1014: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_FALSE;
1015:

Line 1031: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Create_Assignment.begin'

1027: END IF;
1028:
1029: --Log Message
1030: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1031: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Create_Assignment.begin'
1032: ,x_msg => 'Beginning of Create_Assignment'
1033: ,x_log_level => 5);
1034: END IF;
1035:

Line 1079: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Create_Assignment'

1075:
1076: --Assumption: Add Template Requirement does not pass in Project Number
1077:
1078: IF P_DEBUG_MODE = 'Y' THEN
1079: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Create_Assignment'
1080: ,x_msg => 'before check project number'
1081: ,x_log_level => li_message_level);
1082: END IF;
1083:

Line 1088: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Create_Assignment'

1084: --Check to see if project number is passed in
1085: IF (p_project_number IS NOT NULL AND p_project_number <> FND_API.G_MISS_CHAR )THEN
1086:
1087: IF P_DEBUG_MODE = 'Y' THEN
1088: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Create_Assignment'
1089: ,x_msg => 'project number is ok'
1090: ,x_log_level => li_message_level);
1091: END IF;
1092:

Line 1122: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Create_Assignment'

1118:
1119: --dbms_output.put_line('Before Get project_number_info');
1120:
1121: IF P_DEBUG_MODE = 'Y' THEN
1122: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Create_Assignment'
1123: ,x_msg => 'before get calendar id'
1124: ,x_log_level => li_message_level);
1125: END IF;
1126:

Line 1148: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Create_Assignment'

1144: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1145: END IF; --staffed admin or staffed assignment with admin project
1146:
1147: IF P_DEBUG_MODE = 'Y' THEN
1148: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Create_Assignment'
1149: ,x_msg => 'before calendar=PROJECT?'
1150: ,x_log_level => li_message_level);
1151: END IF;
1152:

Line 1332: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Create_Assignment'

1328:
1329: END IF;
1330:
1331: IF P_DEBUG_MODE = 'Y' THEN
1332: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Create_Assignment'
1333: ,x_msg => 'before calendar = resource'
1334: ,x_log_level => li_message_level);
1335: END IF;
1336:

Line 1546: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Create_Assignment'

1542: END IF;
1543: --dbms_output.put_line('Project Subteam Id'||l_subteam_id);
1544:
1545: IF P_DEBUG_MODE = 'Y' THEN
1546: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Create_Assignment'
1547: ,x_msg => 'before calendar = project'
1548: ,x_log_level => li_message_level);
1549: END IF;
1550:

Line 1569: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Create_Assignment'

1565: IF ((l_assignment_rec.calendar_type = 'OTHER' AND PA_STARTUP.G_Calling_Application = 'SELF_SERVICE')
1566: OR (l_assignment_rec.calendar_type <> 'RESOURCE' AND PA_STARTUP.G_Calling_Application <> 'SELF_SERVICE')) THEN
1567:
1568: IF P_DEBUG_MODE = 'Y' THEN
1569: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Create_Assignment'
1570: ,x_msg => 'cal_id='||l_assignment_rec.calendar_id||
1571: ', cal_name=' ||p_calendar_name
1572: ,x_log_level => li_message_level);
1573: END IF;

Line 1622: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Create_Assignment'

1618: -- Validate Work Type
1619: -- If work type name is valid and work_type_id is null then returns the work_type_id
1620: --
1621: IF P_DEBUG_MODE = 'Y' THEN
1622: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Create_Assignment'
1623: ,x_msg => 'work_type_id='||l_assignment_rec.work_type_id||
1624: ', work_type_name='||p_work_type_name||
1625: ', flag='||PA_STARTUP.G_Check_ID_Flag
1626: ,x_log_level => li_message_level);

Line 1806: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Create_Assignment.after_validation'

1802: END IF; --if source_assignment_id IS NULL
1803:
1804: --Log Message
1805: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1806: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Create_Assignment.after_validation'
1807: ,x_msg => 'Finished Validation, calling private create_assignment'
1808: ,x_log_level => 5);
1809: END IF;
1810:

Line 1814: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Create_Assignment'

1810:
1811: IF p_asgn_creation_mode <> 'MASS' OR (p_asgn_creation_mode = 'MASS' AND p_validate_only = FND_API.G_FALSE) THEN
1812:
1813: IF P_DEBUG_MODE = 'Y' THEN
1814: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Create_Assignment'
1815: ,x_msg => 'before call pvt.create_assignment'
1816: ,x_log_level => li_message_level);
1817: END IF;
1818:

Line 1842: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Create_Assignment'

1838: ,x_resource_id => x_resource_id
1839: ,x_return_status => l_return_status
1840: );
1841: IF P_DEBUG_MODE = 'Y' THEN
1842: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Create_Assignment'
1843: ,x_msg => 'after call pvt.create_assignment'
1844: ,x_log_level => li_message_level);
1845: END IF;
1846:

Line 1870: PA_DEBUG.Reset_Err_Stack;

1866:
1867:
1868: -- Reset the error stack when returning to the calling program
1869:
1870: PA_DEBUG.Reset_Err_Stack;
1871:
1872: -- If g_error_exists is TRUE then set the x_return_status to 'E'
1873:
1874: IF FND_MSG_PUB.Count_Msg > 0 THEN

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

1922: PA_ASSIGNMENTS_PUB.g_assignment_id_tbl.DELETE;
1923:
1924: -- Set the excetption Message and the stack
1925: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Create_Assignment'
1926: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1927: --
1928: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1929: RAISE;
1930: --

Line 1974: PA_DEBUG.init_err_stack('PA_ASSIGNMENTS_PUB.Execute_Staff_Assign_From_Open');

1970:
1971: BEGIN
1972:
1973: -- Initialize the Error Stack
1974: PA_DEBUG.init_err_stack('PA_ASSIGNMENTS_PUB.Execute_Staff_Assign_From_Open');
1975:
1976: -- Initialize the return status to success
1977: x_return_status := FND_API.G_RET_STS_SUCCESS;
1978:

Line 1986: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Execute_Staff_Assign_From_Open.begin'

1982: END IF;
1983:
1984: --Log Message
1985: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1986: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Execute_Staff_Assign_From_Open.begin'
1987: ,x_msg => 'Beginning of Execute_Staff_Assign_From_Open'
1988: ,x_log_level => 5);
1989: END IF;
1990:

Line 2008: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Execute_Staff_Assign_From_Open.staff_assign'

2004: END;
2005:
2006: --Log Message
2007: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2008: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Execute_Staff_Assign_From_Open.staff_assign'
2009: ,x_msg => 'Calling Staff_Assign_From_Open'
2010: ,x_log_level => 5);
2011: END IF;
2012: --

Line 2061: PA_DEBUG.Reset_Err_Stack;

2057: END IF;
2058: END IF;
2059:
2060: -- Reset the error stack when returning to the calling program
2061: PA_DEBUG.Reset_Err_Stack;
2062:
2063: EXCEPTION
2064: WHEN OTHERS THEN
2065:

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

2064: WHEN OTHERS THEN
2065:
2066: -- Set the excetption Message and the stack
2067: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Exec_Staff_Assign_From_Open'
2068: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
2069: --
2070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2071: RAISE; -- This is optional depending on the needs
2072:

Line 2340: PA_DEBUG.init_err_stack('PA_ASSIGNMENTS_PUB.Staff_Assign_From_Open');

2336:
2337: BEGIN
2338:
2339: -- Initialize the Error Stack
2340: PA_DEBUG.init_err_stack('PA_ASSIGNMENTS_PUB.Staff_Assign_From_Open');
2341: --dbms_output.put_line('PA_ASSIGNMENTS_PUB.Staff_Assign_From_Open');
2342:
2343: -- Initialize the error flag
2344: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_FALSE;

Line 2361: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Staff_Assign_From_Open.begin'

2357: END IF;
2358:
2359: --Log Message
2360: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2361: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Staff_Assign_From_Open.begin'
2362: ,x_msg => 'Staff_Assign_From_Open, src_asgmt_id='||p_assignment_rec.source_assignment_id
2363: ,x_log_level => 5);
2364: END IF;
2365: l_assignment_rec := p_assignment_rec;

Line 2562: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Staff_Assign_From_Open.after_source'

2558: IF l_status_controls_valid = 'Y' THEN
2559:
2560: --Log Message
2561: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2562: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Staff_Assign_From_Open.after_source'
2563: ,x_msg => 'After getting requirement details, now assign requirement details'
2564: ,x_log_level => 5);
2565: END IF;
2566:

Line 2626: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Staff_Assign_From_Open.dates_compare'

2622: l_assignment_rec.staffing_owner_person_id := l_source_assignment_rec.staffing_owner_person_id;
2623:
2624: --Log Message
2625: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2626: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Staff_Assign_From_Open.dates_compare'
2627: ,x_msg => 'Differentiate between 4 possibility for Dates'
2628: ,x_log_level => 5);
2629: END IF;
2630:

Line 2755: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Staff_Assign_From_Open.create_open'

2751:
2752:
2753: --Log Message
2754: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2755: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Staff_Assign_From_Open.create_open'
2756: ,x_msg => 'Creating Requirement.'
2757: ,x_log_level => 5);
2758: END IF;
2759:

Line 2808: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Staff_Assign_From_Open.create_staff'

2804: --create the new staffed assignment
2805:
2806: --Log Message
2807: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2808: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Staff_Assign_From_Open.create_staff'
2809: ,x_msg => 'Creating Assignment'
2810: ,x_log_level => 5);
2811: END IF;
2812:

Line 2833: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Staff_Assign_From_Open'

2829: ,x_msg_data => x_msg_data
2830: );
2831:
2832: IF P_DEBUG_MODE = 'Y' THEN
2833: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Staff_Assign_From_Open'
2834: ,x_msg => 'Create new staffed assignment,status='||l_return_status
2835: ,x_log_level => li_message_level);
2836: END IF;
2837:

Line 2843: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Staff_Assign_From_Open'

2839: -- FP.M Development
2840:
2841: -- 1. get the new staffed assignment's derived rlm and person ids
2842: IF P_DEBUG_MODE = 'Y' THEN
2843: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Staff_Assign_From_Open'
2844: ,x_msg => 'x_new_assignment_id='||x_new_assignment_id
2845: ,x_log_level => li_message_level);
2846: END IF;
2847:

Line 2853: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Staff_Assign_From_Open'

2849: FETCH get_staffed_asgmt_rlm INTO l_new_rlm_id, l_new_person_id;
2850: CLOSE get_staffed_asgmt_rlm;
2851:
2852: IF P_DEBUG_MODE = 'Y' THEN
2853: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Staff_Assign_From_Open'
2854: ,x_msg => 'l_new_rlm_id='||l_new_rlm_id||
2855: ' l_new_person_id='||l_new_person_id
2856: ,x_log_level => li_message_level);
2857: END IF;

Line 2876: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Staff_Assign_From_Open'

2872: l_rlm_id := l_new_rlm_id;
2873: END IF;
2874:
2875: IF P_DEBUG_MODE = 'Y' THEN
2876: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Staff_Assign_From_Open'
2877: ,x_msg => 'l_rlm_id='||l_rlm_id
2878: ,x_log_level => li_message_level);
2879: END IF;
2880:

Line 2969: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Staffed_Assign_From_Open'

2965: ,x_return_status => l_return_status
2966: );
2967: --Log Message
2968: IF P_DEBUG_MODE = 'Y' THEN
2969: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Staffed_Assign_From_Open'
2970: ,x_msg => 'Update_task_assignments(case 1), status='||l_return_status
2971: ,x_log_level => 5);
2972: END IF;
2973:

Line 3010: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Staffed_Assign_From_Open'

3006: CLOSE get_res_mand_attributes;
3007:
3008: --Log Message
3009: IF P_DEBUG_MODE = 'Y' THEN
3010: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Staffed_Assign_From_Open'
3011: ,x_msg => 'Update_task_assignments(case 2), status='||l_return_status
3012: ,x_log_level => 5);
3013: END IF;
3014:

Line 3044: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Staffed_Assign_From_Open'

3040: ,x_return_status => l_return_status
3041: );
3042: --Log Message
3043: IF P_DEBUG_MODE = 'Y' THEN
3044: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Staffed_Assign_From_Open'
3045: ,x_msg => 'Update_task_assignments(case 3), status='||l_return_status
3046: ,x_log_level => 5);
3047: END IF;
3048:

Line 3055: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Staff_Assign_From_Open.change_status'

3051: -- End of FP.M Development
3052:
3053: --Log Message
3054: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3055: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Staff_Assign_From_Open.change_status'
3056: ,x_msg => 'calling schedule change_status'
3057: ,x_log_level => 5);
3058: END IF;
3059:

Line 3150: PA_DEBUG.Reset_Err_Stack;

3146: END IF;
3147:
3148: -- Reset the error stack when returning to the calling program
3149:
3150: PA_DEBUG.Reset_Err_Stack;
3151:
3152: IF x_msg_count > 0 THEN
3153: x_return_status := FND_API.G_RET_STS_ERROR;
3154: END IF;

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

3169: ROLLBACK TO ASG_PUB_STAFF_ASSIGN_FROM_OPEN;
3170: END IF;
3171: -- Set the excetption Message and the stack
3172: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Staff_Assign_From_Open'
3173: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
3174: --
3175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3176: RAISE; -- This is optional depending on the needs
3177: --

Line 3316: PA_DEBUG.init_err_stack('PA_ASSIGNMENTS_PUB.Execute_Update_Assignment');

3312:
3313:
3314: --dbms_output.put_line('Beginning Execute_Update_Assignment');
3315: -- Initialize the Error Stack
3316: PA_DEBUG.init_err_stack('PA_ASSIGNMENTS_PUB.Execute_Update_Assignment');
3317:
3318: --Log Message
3319: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3320: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Execute_Update_Assignment.begin'

Line 3320: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Execute_Update_Assignment.begin'

3316: PA_DEBUG.init_err_stack('PA_ASSIGNMENTS_PUB.Execute_Update_Assignment');
3317:
3318: --Log Message
3319: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3320: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Execute_Update_Assignment.begin'
3321: ,x_msg => 'Beginning of Execute_Update_Assignment'
3322: ,x_log_level => 5);
3323: END IF;
3324:

Line 3451: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Execute_Update_Assignment.update_assignment'

3447: l_assignment_rec.end_date := p_end_date;
3448: END IF;
3449: --Log Message
3450: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3451: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Execute_Update_Assignment.update_assignment'
3452: ,x_msg => 'After record assignment, Calling Update_Assignment'
3453: ,x_log_level => 5);
3454: END IF;
3455: -- Call the update assignment public API

Line 3495: PA_DEBUG.Reset_Err_Stack;

3491: ,x_msg_data => x_msg_data
3492: );
3493:
3494: -- Reset the error stack when returning to the calling program
3495: PA_DEBUG.Reset_Err_Stack;
3496:
3497:
3498: -- Put any message text from message stack into the Message ARRAY
3499: EXCEPTION

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

3500: WHEN OTHERS THEN
3501:
3502: -- Set the excetption Message and the stack
3503: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ASSIGNMENT_PUB.Execute_Update_Assignment'
3504: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
3505: --
3506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3507: RAISE; -- This is optional depending on the needs
3508: --

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

4330: WHEN OTHERS THEN
4331:
4332: -- Set the excetption Message and the stack
4333: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ASSIGNMENT_PUB.Execute_Update_Assignment'
4334: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
4335: --
4336: x_return_status_tbl(i) := FND_API.G_RET_STS_UNEXP_ERROR ;
4337: RAISE; -- This is optional depending on the needs
4338: --

Line 4489: PA_DEBUG.init_err_stack('PA_ASSIGNMENTS_PUB.Update_Assignment');

4485: /* Bug 2590938 End */
4486:
4487: BEGIN
4488: -- Initialize the Error Stack
4489: PA_DEBUG.init_err_stack('PA_ASSIGNMENTS_PUB.Update_Assignment');
4490: --Log Message
4491: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
4492: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Update_Assignment.begin'
4493: ,x_msg => 'Beginning of Update_Assignment'

Line 4492: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Update_Assignment.begin'

4488: -- Initialize the Error Stack
4489: PA_DEBUG.init_err_stack('PA_ASSIGNMENTS_PUB.Update_Assignment');
4490: --Log Message
4491: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
4492: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Update_Assignment.begin'
4493: ,x_msg => 'Beginning of Update_Assignment'
4494: ,x_log_level => 5);
4495: END IF;
4496:

Line 4773: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Update_Assignment.Id_validation'

4769: l_error_message_code := FND_API.G_MISS_CHAR;
4770: END IF;
4771: --Log Message
4772: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
4773: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Update_Assignment.Id_validation'
4774: ,x_msg => 'Do Value to ID conversion.'
4775: ,x_log_level => 5);
4776: END IF;
4777:

Line 5780: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Update_Assignment.pvt_update_asgmt'

5776: --dbms_output.put_line('Finish Validation');
5777:
5778: --Log Message
5779: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
5780: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Update_Assignment.pvt_update_asgmt'
5781: ,x_msg => 'Calling PVT Update_Assignment'
5782: ,x_log_level => 5);
5783: END IF;
5784:

Line 5827: PA_DEBUG.Reset_Err_Stack;

5823: );
5824: END IF;
5825:
5826: -- Reset the error stack when returning to the calling program
5827: PA_DEBUG.Reset_Err_Stack;
5828:
5829: -- If g_error_exists is TRUE then set the x_return_status to 'E'
5830:
5831: --IF PA_ASSIGNMENTS_PUB.g_error_exists = FND_API.G_TRUE THEN

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

5853: ROLLBACK TO ASG_PUB_UPDATE_ASSIGNMENT;
5854: END IF;
5855: -- Set the excetption Message and the stack
5856: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Update_Assignment'
5857: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
5858: --
5859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5860: RAISE; -- This is optional depending on the needs
5861: --

Line 5919: PA_DEBUG.init_err_stack('PA_ASSIGNMENTS_PUB.Delete_Assignment');

5915:
5916: BEGIN
5917:
5918: -- Initialize the Error Stack
5919: PA_DEBUG.init_err_stack('PA_ASSIGNMENTS_PUB.Delete_Assignment');
5920: --dbms_output.put_line('PA_ASSIGNMENTS_PUB.delete assignment');
5921:
5922: --Log Message
5923: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */

Line 5924: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Delete_Assignment.begin'

5920: --dbms_output.put_line('PA_ASSIGNMENTS_PUB.delete assignment');
5921:
5922: --Log Message
5923: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
5924: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Delete_Assignment.begin'
5925: ,x_msg => 'Beginning of Delete_Assignment'
5926: ,x_log_level => 5);
5927: END IF;
5928:

Line 6015: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Delete_Assignment.pvt_delete_asgmt'

6011: END IF;
6012:
6013: --Log Message
6014: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
6015: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Delete_Assignment.pvt_delete_asgmt'
6016: ,x_msg => 'Calling PVT Delete_Assignment'
6017: ,x_log_level => 5);
6018: END IF;
6019:

Line 6051: PA_DEBUG.Reset_Err_Stack;

6047: );
6048: END IF;
6049:
6050: -- Reset the error stack when returning to the calling program
6051: PA_DEBUG.Reset_Err_Stack;
6052:
6053: -- If any errors exist then set the x_return_status to 'E'
6054:
6055: IF x_msg_count > 0 THEN

Line 6062: PA_DEBUG.Reset_Err_Stack;

6058:
6059: END IF;
6060:
6061: -- Reset the error stack when returning to the calling program
6062: PA_DEBUG.Reset_Err_Stack;
6063:
6064: IF p_commit = FND_API.G_TRUE THEN
6065: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
6066: COMMIT;

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

6077: ROLLBACK TO ASG_PUB_DELETE_ASSIGNMENT;
6078: END IF;
6079: -- Set the excetption Message and the stack
6080: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Delete_Assignment'
6081: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
6082: --
6083: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6084: RAISE; -- This is optional depending on the needs
6085: --

Line 6120: PA_DEBUG.init_err_stack('PA_ASSIGNMENTS_PUB.Copy_Team_Role');

6116:
6117: --dbms_output.put_line('PA_ASSIGNMENTS_PUB.Copy_Team_Role');
6118:
6119: -- Initialize the Error Stack
6120: PA_DEBUG.init_err_stack('PA_ASSIGNMENTS_PUB.Copy_Team_Role');
6121: --dbms_output.put_line('PA_ASSIGNMENTS_PUB.Copy_Team_Role');
6122:
6123: --Log Message
6124: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */

Line 6125: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Copy_Team_Role'

6121: --dbms_output.put_line('PA_ASSIGNMENTS_PUB.Copy_Team_Role');
6122:
6123: --Log Message
6124: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
6125: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Copy_Team_Role'
6126: ,x_msg => 'Beginning of Copy_Team_Role'
6127: ,x_log_level => 5);
6128: END IF;
6129:

Line 6319: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Copy_Team_Role'

6315:
6316: -- Create the requirement
6317: --Log Message
6318: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
6319: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Copy_Team_Role'
6320: ,x_msg => 'Calling create assignment'
6321: ,x_log_level => 5);
6322: END IF;
6323:

Line 6356: PA_DEBUG.Reset_Err_Stack;

6352: );
6353: END IF;
6354:
6355: -- Reset the error stack when returning to the calling program
6356: PA_DEBUG.Reset_Err_Stack;
6357:
6358: -- If any errors exist then set the x_return_status to 'E'
6359:
6360: IF x_msg_count > 0 THEN

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

6366: EXCEPTION
6367: WHEN OTHERS THEN
6368: -- Set the excetption Message and the stack
6369: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Copy_Team_Role'
6370: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
6371: --
6372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6373: RAISE;
6374:

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

6662: EXCEPTION
6663: WHEN OTHERS THEN
6664: -- Set the exception Message and the stack
6665: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Mass_Exec_Create_Assignments'
6666: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
6667: --
6668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6669:
6670: END Mass_Exec_Create_Assignments;

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

6902: EXCEPTION
6903: WHEN OTHERS THEN
6904: -- Set the exception Message and the stack
6905: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Mass_Create_Assignments'
6906: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
6907: --
6908: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6909: RAISE;
6910:

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

7145: EXCEPTION
7146: WHEN OTHERS THEN
7147: -- Set the exception Message and the stack
7148: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Mass_Exec_Update_Assignments'
7149: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
7150: --
7151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7152: RAISE;
7153:

Line 7508: PA_DEBUG.Reset_Err_Stack;

7504: );
7505: END IF;
7506:
7507: -- Reset the error stack when returning to the calling program
7508: PA_DEBUG.Reset_Err_Stack;
7509:
7510: -- If any errors exist then set the x_return_status to 'E'
7511:
7512: IF x_msg_count > 0 THEN

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

7518: EXCEPTION
7519: WHEN OTHERS THEN
7520: -- Set the exception Message and the stack
7521: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Mass_Update_Assignment'
7522: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
7523: --
7524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7525: RAISE;
7526:

Line 7652: PA_DEBUG.init_err_stack('PA_ASSIGNMENTS_PUB.Execute_Update_Assignment');

7648: BEGIN
7649:
7650: --dbms_output.put_line('Beginning Execute_Update_Assignment');
7651: -- Initialize the Error Stack
7652: PA_DEBUG.init_err_stack('PA_ASSIGNMENTS_PUB.Execute_Update_Assignment');
7653:
7654:
7655: --Log Message
7656: IF P_DEBUG_MODE = 'Y' THEN

Line 7657: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Execute_Update_Requirement.begin'

7653:
7654:
7655: --Log Message
7656: IF P_DEBUG_MODE = 'Y' THEN
7657: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Execute_Update_Requirement.begin'
7658: ,x_msg => 'Beginning of Execute_Update_Assignment'
7659: ,x_log_level => 5);
7660: END IF;
7661:

Line 7958: PA_DEBUG.init_err_stack('PA_ASSIGNMENTS_PUB.Delete_PJR_Txns');

7954:
7955: BEGIN
7956:
7957: -- Initialize the Error Stack
7958: PA_DEBUG.init_err_stack('PA_ASSIGNMENTS_PUB.Delete_PJR_Txns');
7959:
7960: --Log Message
7961: IF P_DEBUG_MODE = 'Y' THEN
7962: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Delete_PJR_Txns.begin'

Line 7962: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Delete_PJR_Txns.begin'

7958: PA_DEBUG.init_err_stack('PA_ASSIGNMENTS_PUB.Delete_PJR_Txns');
7959:
7960: --Log Message
7961: IF P_DEBUG_MODE = 'Y' THEN
7962: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Delete_PJR_Txns.begin'
7963: ,x_msg => 'Beginning of Delete_PJR_Txns'
7964: ,x_log_level => 5);
7965: END IF;
7966:

Line 7986: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Delete_PJR_Txns.pvt_delete_asgmt'

7982: LOOP
7983:
7984: --Log Message
7985: IF P_DEBUG_MODE = 'Y' THEN
7986: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Delete_PJR_Txns.pvt_delete_asgmt'
7987: ,x_msg => 'Calling PVT Delete_Assignment'
7988: ,x_log_level => 5);
7989: END IF;
7990:

Line 8023: PA_DEBUG.Reset_Err_Stack;

8019: );
8020: END IF;
8021:
8022: -- Reset the error stack when returning to the calling program
8023: PA_DEBUG.Reset_Err_Stack;
8024:
8025: -- If any errors exist then set the x_return_status to 'E'
8026:
8027: IF x_msg_count > 0 THEN

Line 8034: PA_DEBUG.Reset_Err_Stack;

8030:
8031: END IF;
8032:
8033: -- Reset the error stack when returning to the calling program
8034: PA_DEBUG.Reset_Err_Stack;
8035:
8036: IF p_commit = FND_API.G_TRUE THEN
8037: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
8038: COMMIT;

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

8050: ROLLBACK TO ASG_PUB_DELETE_PJR_TXNS;
8051: END IF;
8052: -- Set the exception Message and the stack
8053: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Delete_PJR_Txns'
8054: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
8055: --
8056: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8057: RAISE; -- This is optional depending on the needs
8058: --