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.13.12010000.5 2009/02/23 11:10:49 jcgeorge 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 138: PA_DEBUG.init_err_stack('PA_ASSIGNMENTS_PUB.Exceute_Create_Assignment');

134:
135: BEGIN
136:
137: -- Initialize the Error Stack
138: PA_DEBUG.init_err_stack('PA_ASSIGNMENTS_PUB.Exceute_Create_Assignment');
139:
140: -- Initialize the return status to success
141: x_return_status := FND_API.G_RET_STS_SUCCESS;
142:

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

147: END IF;
148:
149: --Log Message
150: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
151: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Exceute_Create_Assignment.begin'
152: ,x_msg => 'Beginning of the Execute_Create_Assignment'
153: ,x_log_level => 5);
154: END IF;
155:

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

225: l_assignment_rec.calendar_id := p_calendar_id;
226: l_assignment_rec.resource_calendar_percent := p_resource_calendar_percent;
227:
228: IF P_DEBUG_MODE = 'Y' THEN
229: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Exceute_Create_Assignment'
230: ,x_msg => 'Execute_Create_Assignment before L'
231: ,x_log_level => li_message_level);
232: END IF;
233:

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

243: l_assignment_rec.tp_percent_applied_override := p_tp_percent_applied_override;
244: l_assignment_rec.staffing_owner_person_id := p_staffing_owner_person_id;
245:
246: IF P_DEBUG_MODE = 'Y' THEN
247: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Exceute_Create_Assignment'
248: ,x_msg => 'Execute_Create_Assignment before M'
249: ,x_log_level => li_message_level);
250: END IF;
251: -- FP.M Development

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

289: --End Bug 3249669 : Check for profile option PA: Global Week Start Day being set.
290:
291: --Log Message
292: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
293: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Exceute_Create_Assignment.create_asgmt'
294: ,x_msg => 'Calling Create_Assignment'
295: ,x_log_level => 5);
296: END IF;
297:

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

317:
318: END IF;
319:
320: IF P_DEBUG_MODE = 'Y' THEN
321: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Exceute_Create_Assignment'
322: ,x_msg => 'before calling pub.Create_Assignment'
323: ,x_log_level => li_message_level);
324: END IF;
325:

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

362: ,x_msg_data => x_msg_data
363: );
364:
365: IF P_DEBUG_MODE = 'Y' THEN
366: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Exceute_Create_Assignment'
367: ,x_msg => 'after calling pub.Create_Assignment'
368: ,x_log_level => li_message_level);
369: END IF;
370:

Line 372: PA_DEBUG.Reset_Err_Stack;

368: ,x_log_level => li_message_level);
369: END IF;
370:
371: -- Reset the error stack when returning to the calling program
372: PA_DEBUG.Reset_Err_Stack;
373:
374: -- If there are any messages in the stack then set x_return_status
375:
376: IF FND_MSG_PUB.Count_Msg > 0 THEN

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

398: EXCEPTION
399: WHEN OTHERS THEN
400: -- Set the excetption Message and the stack
401: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Execute_Create_Assignment'
402: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
403: --
404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
405: RAISE; -- This is optional depending on the needs
406:

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

443: BEGIN
444:
445:
446: -- Initialize the Error Stack
447: PA_DEBUG.init_err_stack('PA_ASSIGNMENTS_PUB.Exec_Create_Assign_With_Def');
448:
449: -- Initialize the return status to success
450: x_return_status := FND_API.G_RET_STS_SUCCESS;
451:

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

455: END IF;
456:
457: --Log Message
458: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
459: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Exec_Create_Assign_With_Def.begin'
460: ,x_msg => 'Beginning of the Exec_Create_Assign_With_Def'
461: ,x_log_level => 5);
462: END IF;
463:

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

487: ,x_error_message_code => l_err_msg_code);
488:
489: --Log Message
490: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
491: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Exec_Create_Assign_With_Def.begin'
492: ,x_msg => 'Calling Create_Assign_With_Def'
493: ,x_log_level => 5);
494: END IF;
495: --

Line 520: PA_DEBUG.Reset_Err_Stack;

516: );
517:
518:
519: -- Reset the error stack when returning to the calling program
520: PA_DEBUG.Reset_Err_Stack;
521:
522: -- Put any message text from message stack into the Message ARRAY
523: EXCEPTION
524: WHEN OTHERS THEN

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

524: WHEN OTHERS THEN
525:
526: -- Set the excetption Message and the stack
527: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Execute_Create_Assignment'
528: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
529: --
530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
531: RAISE; -- This is optional depending on the needs
532:

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

596:
597: l_assignment_rec := p_assignment_rec;
598:
599: -- Initialize the Error Stack
600: PA_DEBUG.init_err_stack('PA_ASSIGNMENTS_PUB.Create_Assign_With_Def');
601:
602: -- Initialize the error flag
603: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_FALSE;
604:

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

616: FND_MSG_PUB.initialize;
617: END IF;
618: --Log Message
619: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
620: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Create_Assign_With_Def.begin'
621: ,x_msg => 'Beginning of Create_Assign_With_Def'
622: ,x_log_level => 5);
623: END IF;
624:

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

689: END IF;
690:
691: --Log Message
692: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
693: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Create_Assign_With_Def.role_defaults'
694: ,x_msg => 'After gettting role defaults'
695: ,x_log_level => 5);
696: END IF;
697:

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

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

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

766: ,x_error_message_code => l_err_msg_code);
767:
768: --Log Message
769: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
770: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Create_Assign_With_Def.create_asgmt'
771: ,x_msg => 'Calling Create_Assignment'
772: ,x_log_level => 5);
773: END IF;
774:

Line 816: PA_DEBUG.Reset_Err_Stack;

812: END IF;
813:
814: -- Reset the error stack when returning to the calling program
815:
816: PA_DEBUG.Reset_Err_Stack;
817:
818: -- If g_error_exists is TRUE then set the x_return_status to 'E'
819:
820: IF FND_MSG_PUB.Count_Msg >0 THEN

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

839: ROLLBACK TO ASG_PUB_CREATE_ASGMT_WITH_DEF;
840: END IF;
841: -- Set the excetption Message and the stack
842: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Create_Assignment'
843: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
844: --
845: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
846: RAISE; -- This is optional depending on the needs
847: --

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

963:
964: BEGIN
965:
966: IF P_DEBUG_MODE = 'Y' THEN
967: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Create_Assignment'
968: ,x_msg => 'Entrance of pub.Create_Assignment'
969: ,x_log_level => li_message_level);
970: END IF;
971:

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

972: --dbms_output.put_line('PA_ASSIGNMENTS_PUB.Create_Assignment');
973: /* Moved the call for deleting the global table from below to above for bug 3079906*/
974: PA_ASSIGNMENTS_PUB.g_assignment_id_tbl.DELETE;
975: -- Initialize the Error Stack
976: PA_DEBUG.init_err_stack('PA_ASSIGNMENTS_PUB.Create_Assignment');
977:
978: -- Initialize the error flag
979: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_FALSE;
980:

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

992: END IF;
993:
994: --Log Message
995: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
996: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Create_Assignment.begin'
997: ,x_msg => 'Beginning of Create_Assignment'
998: ,x_log_level => 5);
999: END IF;
1000:

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

1040:
1041: --Assumption: Add Template Requirement does not pass in Project Number
1042:
1043: IF P_DEBUG_MODE = 'Y' THEN
1044: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Create_Assignment'
1045: ,x_msg => 'before check project number'
1046: ,x_log_level => li_message_level);
1047: END IF;
1048:

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

1049: --Check to see if project number is passed in
1050: IF (p_project_number IS NOT NULL AND p_project_number <> FND_API.G_MISS_CHAR )THEN
1051:
1052: IF P_DEBUG_MODE = 'Y' THEN
1053: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Create_Assignment'
1054: ,x_msg => 'project number is ok'
1055: ,x_log_level => li_message_level);
1056: END IF;
1057:

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

1083:
1084: --dbms_output.put_line('Before Get project_number_info');
1085:
1086: IF P_DEBUG_MODE = 'Y' THEN
1087: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Create_Assignment'
1088: ,x_msg => 'before get calendar id'
1089: ,x_log_level => li_message_level);
1090: END IF;
1091:

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

1109: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1110: END IF; --staffed admin or staffed assignment with admin project
1111:
1112: IF P_DEBUG_MODE = 'Y' THEN
1113: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Create_Assignment'
1114: ,x_msg => 'before calendar=PROJECT?'
1115: ,x_log_level => li_message_level);
1116: END IF;
1117:

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

1293:
1294: END IF;
1295:
1296: IF P_DEBUG_MODE = 'Y' THEN
1297: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Create_Assignment'
1298: ,x_msg => 'before calendar = resource'
1299: ,x_log_level => li_message_level);
1300: END IF;
1301:

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

1507: END IF;
1508: --dbms_output.put_line('Project Subteam Id'||l_subteam_id);
1509:
1510: IF P_DEBUG_MODE = 'Y' THEN
1511: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Create_Assignment'
1512: ,x_msg => 'before calendar = project'
1513: ,x_log_level => li_message_level);
1514: END IF;
1515:

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

1530: IF ((l_assignment_rec.calendar_type = 'OTHER' AND PA_STARTUP.G_Calling_Application = 'SELF_SERVICE')
1531: OR (l_assignment_rec.calendar_type <> 'RESOURCE' AND PA_STARTUP.G_Calling_Application <> 'SELF_SERVICE')) THEN
1532:
1533: IF P_DEBUG_MODE = 'Y' THEN
1534: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Create_Assignment'
1535: ,x_msg => 'cal_id='||l_assignment_rec.calendar_id||
1536: ', cal_name=' ||p_calendar_name
1537: ,x_log_level => li_message_level);
1538: END IF;

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

1569: -- Validate Work Type
1570: -- If work type name is valid and work_type_id is null then returns the work_type_id
1571: --
1572: IF P_DEBUG_MODE = 'Y' THEN
1573: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Create_Assignment'
1574: ,x_msg => 'work_type_id='||l_assignment_rec.work_type_id||
1575: ', work_type_name='||p_work_type_name||
1576: ', flag='||PA_STARTUP.G_Check_ID_Flag
1577: ,x_log_level => li_message_level);

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

1753: END IF; --if source_assignment_id IS NULL
1754:
1755: --Log Message
1756: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1757: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Create_Assignment.after_validation'
1758: ,x_msg => 'Finished Validation, calling private create_assignment'
1759: ,x_log_level => 5);
1760: END IF;
1761:

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

1761:
1762: IF p_asgn_creation_mode <> 'MASS' OR (p_asgn_creation_mode = 'MASS' AND p_validate_only = FND_API.G_FALSE) THEN
1763:
1764: IF P_DEBUG_MODE = 'Y' THEN
1765: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Create_Assignment'
1766: ,x_msg => 'before call pvt.create_assignment'
1767: ,x_log_level => li_message_level);
1768: END IF;
1769:

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

1789: ,x_resource_id => x_resource_id
1790: ,x_return_status => l_return_status
1791: );
1792: IF P_DEBUG_MODE = 'Y' THEN
1793: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Create_Assignment'
1794: ,x_msg => 'after call pvt.create_assignment'
1795: ,x_log_level => li_message_level);
1796: END IF;
1797:

Line 1821: PA_DEBUG.Reset_Err_Stack;

1817:
1818:
1819: -- Reset the error stack when returning to the calling program
1820:
1821: PA_DEBUG.Reset_Err_Stack;
1822:
1823: -- If g_error_exists is TRUE then set the x_return_status to 'E'
1824:
1825: IF FND_MSG_PUB.Count_Msg > 0 THEN

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

1859: PA_ASSIGNMENTS_PUB.g_assignment_id_tbl.DELETE;
1860:
1861: -- Set the excetption Message and the stack
1862: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Create_Assignment'
1863: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1864: --
1865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1866: RAISE;
1867: --

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

1907:
1908: BEGIN
1909:
1910: -- Initialize the Error Stack
1911: PA_DEBUG.init_err_stack('PA_ASSIGNMENTS_PUB.Execute_Staff_Assign_From_Open');
1912:
1913: -- Initialize the return status to success
1914: x_return_status := FND_API.G_RET_STS_SUCCESS;
1915:

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

1919: END IF;
1920:
1921: --Log Message
1922: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1923: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Execute_Staff_Assign_From_Open.begin'
1924: ,x_msg => 'Beginning of Execute_Staff_Assign_From_Open'
1925: ,x_log_level => 5);
1926: END IF;
1927:

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

1941: END;
1942:
1943: --Log Message
1944: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1945: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Execute_Staff_Assign_From_Open.staff_assign'
1946: ,x_msg => 'Calling Staff_Assign_From_Open'
1947: ,x_log_level => 5);
1948: END IF;
1949: --

Line 1998: PA_DEBUG.Reset_Err_Stack;

1994: END IF;
1995: END IF;
1996:
1997: -- Reset the error stack when returning to the calling program
1998: PA_DEBUG.Reset_Err_Stack;
1999:
2000: EXCEPTION
2001: WHEN OTHERS THEN
2002:

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

2001: WHEN OTHERS THEN
2002:
2003: -- Set the excetption Message and the stack
2004: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Exec_Staff_Assign_From_Open'
2005: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
2006: --
2007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2008: RAISE; -- This is optional depending on the needs
2009:

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

2271:
2272: BEGIN
2273:
2274: -- Initialize the Error Stack
2275: PA_DEBUG.init_err_stack('PA_ASSIGNMENTS_PUB.Staff_Assign_From_Open');
2276: --dbms_output.put_line('PA_ASSIGNMENTS_PUB.Staff_Assign_From_Open');
2277:
2278: -- Initialize the error flag
2279: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_FALSE;

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

2292: END IF;
2293:
2294: --Log Message
2295: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2296: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Staff_Assign_From_Open.begin'
2297: ,x_msg => 'Staff_Assign_From_Open, src_asgmt_id='||p_assignment_rec.source_assignment_id
2298: ,x_log_level => 5);
2299: END IF;
2300: l_assignment_rec := p_assignment_rec;

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

2493: IF l_status_controls_valid = 'Y' THEN
2494:
2495: --Log Message
2496: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2497: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Staff_Assign_From_Open.after_source'
2498: ,x_msg => 'After getting requirement details, now assign requirement details'
2499: ,x_log_level => 5);
2500: END IF;
2501:

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

2557: l_assignment_rec.staffing_owner_person_id := l_source_assignment_rec.staffing_owner_person_id;
2558:
2559: --Log Message
2560: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2561: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Staff_Assign_From_Open.dates_compare'
2562: ,x_msg => 'Differentiate between 4 possibility for Dates'
2563: ,x_log_level => 5);
2564: END IF;
2565:

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

2686:
2687:
2688: --Log Message
2689: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2690: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Staff_Assign_From_Open.create_open'
2691: ,x_msg => 'Creating Requirement.'
2692: ,x_log_level => 5);
2693: END IF;
2694:

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

2739: --create the new staffed assignment
2740:
2741: --Log Message
2742: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2743: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Staff_Assign_From_Open.create_staff'
2744: ,x_msg => 'Creating Assignment'
2745: ,x_log_level => 5);
2746: END IF;
2747:

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

2764: ,x_msg_data => x_msg_data
2765: );
2766:
2767: IF P_DEBUG_MODE = 'Y' THEN
2768: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Staff_Assign_From_Open'
2769: ,x_msg => 'Create new staffed assignment,status='||l_return_status
2770: ,x_log_level => li_message_level);
2771: END IF;
2772:

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

2774: -- FP.M Development
2775:
2776: -- 1. get the new staffed assignment's derived rlm and person ids
2777: IF P_DEBUG_MODE = 'Y' THEN
2778: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Staff_Assign_From_Open'
2779: ,x_msg => 'x_new_assignment_id='||x_new_assignment_id
2780: ,x_log_level => li_message_level);
2781: END IF;
2782:

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

2784: FETCH get_staffed_asgmt_rlm INTO l_new_rlm_id, l_new_person_id;
2785: CLOSE get_staffed_asgmt_rlm;
2786:
2787: IF P_DEBUG_MODE = 'Y' THEN
2788: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Staff_Assign_From_Open'
2789: ,x_msg => 'l_new_rlm_id='||l_new_rlm_id||
2790: ' l_new_person_id='||l_new_person_id
2791: ,x_log_level => li_message_level);
2792: END IF;

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

2807: l_rlm_id := l_new_rlm_id;
2808: END IF;
2809:
2810: IF P_DEBUG_MODE = 'Y' THEN
2811: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Staff_Assign_From_Open'
2812: ,x_msg => 'l_rlm_id='||l_rlm_id
2813: ,x_log_level => li_message_level);
2814: END IF;
2815:

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

2900: ,x_return_status => l_return_status
2901: );
2902: --Log Message
2903: IF P_DEBUG_MODE = 'Y' THEN
2904: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Staffed_Assign_From_Open'
2905: ,x_msg => 'Update_task_assignments(case 1), status='||l_return_status
2906: ,x_log_level => 5);
2907: END IF;
2908:

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

2941: CLOSE get_res_mand_attributes;
2942:
2943: --Log Message
2944: IF P_DEBUG_MODE = 'Y' THEN
2945: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Staffed_Assign_From_Open'
2946: ,x_msg => 'Update_task_assignments(case 2), status='||l_return_status
2947: ,x_log_level => 5);
2948: END IF;
2949:

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

2975: ,x_return_status => l_return_status
2976: );
2977: --Log Message
2978: IF P_DEBUG_MODE = 'Y' THEN
2979: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Staffed_Assign_From_Open'
2980: ,x_msg => 'Update_task_assignments(case 3), status='||l_return_status
2981: ,x_log_level => 5);
2982: END IF;
2983:

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

2986: -- End of FP.M Development
2987:
2988: --Log Message
2989: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2990: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Staff_Assign_From_Open.change_status'
2991: ,x_msg => 'calling schedule change_status'
2992: ,x_log_level => 5);
2993: END IF;
2994:

Line 3068: PA_DEBUG.Reset_Err_Stack;

3064: END IF;
3065:
3066: -- Reset the error stack when returning to the calling program
3067:
3068: PA_DEBUG.Reset_Err_Stack;
3069:
3070: IF x_msg_count > 0 THEN
3071: x_return_status := FND_API.G_RET_STS_ERROR;
3072: END IF;

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

3087: ROLLBACK TO ASG_PUB_STAFF_ASSIGN_FROM_OPEN;
3088: END IF;
3089: -- Set the excetption Message and the stack
3090: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Staff_Assign_From_Open'
3091: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
3092: --
3093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3094: RAISE; -- This is optional depending on the needs
3095: --

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

3228:
3229:
3230: --dbms_output.put_line('Beginning Execute_Update_Assignment');
3231: -- Initialize the Error Stack
3232: PA_DEBUG.init_err_stack('PA_ASSIGNMENTS_PUB.Execute_Update_Assignment');
3233:
3234: --Log Message
3235: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3236: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Execute_Update_Assignment.begin'

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

3232: PA_DEBUG.init_err_stack('PA_ASSIGNMENTS_PUB.Execute_Update_Assignment');
3233:
3234: --Log Message
3235: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3236: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Execute_Update_Assignment.begin'
3237: ,x_msg => 'Beginning of Execute_Update_Assignment'
3238: ,x_log_level => 5);
3239: END IF;
3240:

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

3355: END IF;
3356:
3357: --Log Message
3358: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3359: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Execute_Update_Assignment.update_assignment'
3360: ,x_msg => 'After record assignment, Calling Update_Assignment'
3361: ,x_log_level => 5);
3362: END IF;
3363:

Line 3404: PA_DEBUG.Reset_Err_Stack;

3400: );
3401:
3402:
3403: -- Reset the error stack when returning to the calling program
3404: PA_DEBUG.Reset_Err_Stack;
3405:
3406:
3407: -- Put any message text from message stack into the Message ARRAY
3408: EXCEPTION

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

3409: WHEN OTHERS THEN
3410:
3411: -- Set the excetption Message and the stack
3412: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ASSIGNMENT_PUB.Execute_Update_Assignment'
3413: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
3414: --
3415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3416: RAISE; -- This is optional depending on the needs
3417: --

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

3558:
3559: BEGIN
3560:
3561: -- Initialize the Error Stack
3562: PA_DEBUG.init_err_stack('PA_ASSIGNMENTS_PUB.Update_Assignment');
3563:
3564: --Log Message
3565: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3566: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Update_Assignment.begin'

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

3562: PA_DEBUG.init_err_stack('PA_ASSIGNMENTS_PUB.Update_Assignment');
3563:
3564: --Log Message
3565: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3566: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Update_Assignment.begin'
3567: ,x_msg => 'Beginning of Update_Assignment'
3568: ,x_log_level => 5);
3569: END IF;
3570:

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

3830: END IF;
3831:
3832: --Log Message
3833: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3834: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Update_Assignment.Id_validation'
3835: ,x_msg => 'Do Value to ID conversion.'
3836: ,x_log_level => 5);
3837: END IF;
3838:

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

4805: --dbms_output.put_line('Finish Validation');
4806:
4807: --Log Message
4808: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
4809: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Update_Assignment.pvt_update_asgmt'
4810: ,x_msg => 'Calling PVT Update_Assignment'
4811: ,x_log_level => 5);
4812: END IF;
4813:

Line 4851: PA_DEBUG.Reset_Err_Stack;

4847: );
4848: END IF;
4849:
4850: -- Reset the error stack when returning to the calling program
4851: PA_DEBUG.Reset_Err_Stack;
4852:
4853: -- If g_error_exists is TRUE then set the x_return_status to 'E'
4854:
4855: --IF PA_ASSIGNMENTS_PUB.g_error_exists = FND_API.G_TRUE THEN

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

4876: ROLLBACK TO ASG_PUB_UPDATE_ASSIGNMENT;
4877: END IF;
4878: -- Set the excetption Message and the stack
4879: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Update_Assignment'
4880: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
4881: --
4882: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4883: RAISE; -- This is optional depending on the needs
4884: --

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

4939:
4940: BEGIN
4941:
4942: -- Initialize the Error Stack
4943: PA_DEBUG.init_err_stack('PA_ASSIGNMENTS_PUB.Delete_Assignment');
4944: --dbms_output.put_line('PA_ASSIGNMENTS_PUB.delete assignment');
4945:
4946: --Log Message
4947: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */

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

4944: --dbms_output.put_line('PA_ASSIGNMENTS_PUB.delete assignment');
4945:
4946: --Log Message
4947: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
4948: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Delete_Assignment.begin'
4949: ,x_msg => 'Beginning of Delete_Assignment'
4950: ,x_log_level => 5);
4951: END IF;
4952:

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

5035: END IF;
5036:
5037: --Log Message
5038: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
5039: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Delete_Assignment.pvt_delete_asgmt'
5040: ,x_msg => 'Calling PVT Delete_Assignment'
5041: ,x_log_level => 5);
5042: END IF;
5043:

Line 5075: PA_DEBUG.Reset_Err_Stack;

5071: );
5072: END IF;
5073:
5074: -- Reset the error stack when returning to the calling program
5075: PA_DEBUG.Reset_Err_Stack;
5076:
5077: -- If any errors exist then set the x_return_status to 'E'
5078:
5079: IF x_msg_count > 0 THEN

Line 5086: PA_DEBUG.Reset_Err_Stack;

5082:
5083: END IF;
5084:
5085: -- Reset the error stack when returning to the calling program
5086: PA_DEBUG.Reset_Err_Stack;
5087:
5088: IF p_commit = FND_API.G_TRUE THEN
5089: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
5090: COMMIT;

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

5101: ROLLBACK TO ASG_PUB_DELETE_ASSIGNMENT;
5102: END IF;
5103: -- Set the excetption Message and the stack
5104: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Delete_Assignment'
5105: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
5106: --
5107: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5108: RAISE; -- This is optional depending on the needs
5109: --

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

5140:
5141: --dbms_output.put_line('PA_ASSIGNMENTS_PUB.Copy_Team_Role');
5142:
5143: -- Initialize the Error Stack
5144: PA_DEBUG.init_err_stack('PA_ASSIGNMENTS_PUB.Copy_Team_Role');
5145: --dbms_output.put_line('PA_ASSIGNMENTS_PUB.Copy_Team_Role');
5146:
5147: --Log Message
5148: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */

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

5145: --dbms_output.put_line('PA_ASSIGNMENTS_PUB.Copy_Team_Role');
5146:
5147: --Log Message
5148: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
5149: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Copy_Team_Role'
5150: ,x_msg => 'Beginning of Copy_Team_Role'
5151: ,x_log_level => 5);
5152: END IF;
5153:

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

5339:
5340: -- Create the requirement
5341: --Log Message
5342: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
5343: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Copy_Team_Role'
5344: ,x_msg => 'Calling create assignment'
5345: ,x_log_level => 5);
5346: END IF;
5347:

Line 5380: PA_DEBUG.Reset_Err_Stack;

5376: );
5377: END IF;
5378:
5379: -- Reset the error stack when returning to the calling program
5380: PA_DEBUG.Reset_Err_Stack;
5381:
5382: -- If any errors exist then set the x_return_status to 'E'
5383:
5384: IF x_msg_count > 0 THEN

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

5390: EXCEPTION
5391: WHEN OTHERS THEN
5392: -- Set the excetption Message and the stack
5393: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Copy_Team_Role'
5394: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
5395: --
5396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5397: RAISE;
5398:

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

5686: EXCEPTION
5687: WHEN OTHERS THEN
5688: -- Set the exception Message and the stack
5689: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Mass_Exec_Create_Assignments'
5690: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
5691: --
5692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5693:
5694: END Mass_Exec_Create_Assignments;

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

5926: EXCEPTION
5927: WHEN OTHERS THEN
5928: -- Set the exception Message and the stack
5929: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Mass_Create_Assignments'
5930: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
5931: --
5932: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5933: RAISE;
5934:

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

6169: EXCEPTION
6170: WHEN OTHERS THEN
6171: -- Set the exception Message and the stack
6172: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Mass_Exec_Update_Assignments'
6173: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
6174: --
6175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6176: RAISE;
6177:

Line 6532: PA_DEBUG.Reset_Err_Stack;

6528: );
6529: END IF;
6530:
6531: -- Reset the error stack when returning to the calling program
6532: PA_DEBUG.Reset_Err_Stack;
6533:
6534: -- If any errors exist then set the x_return_status to 'E'
6535:
6536: IF x_msg_count > 0 THEN

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

6542: EXCEPTION
6543: WHEN OTHERS THEN
6544: -- Set the exception Message and the stack
6545: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Mass_Update_Assignment'
6546: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
6547: --
6548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6549: RAISE;
6550:

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

6672: BEGIN
6673:
6674: --dbms_output.put_line('Beginning Execute_Update_Assignment');
6675: -- Initialize the Error Stack
6676: PA_DEBUG.init_err_stack('PA_ASSIGNMENTS_PUB.Execute_Update_Assignment');
6677:
6678:
6679: --Log Message
6680: IF P_DEBUG_MODE = 'Y' THEN

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

6677:
6678:
6679: --Log Message
6680: IF P_DEBUG_MODE = 'Y' THEN
6681: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Execute_Update_Requirement.begin'
6682: ,x_msg => 'Beginning of Execute_Update_Assignment'
6683: ,x_log_level => 5);
6684: END IF;
6685:

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

6978:
6979: BEGIN
6980:
6981: -- Initialize the Error Stack
6982: PA_DEBUG.init_err_stack('PA_ASSIGNMENTS_PUB.Delete_PJR_Txns');
6983:
6984: --Log Message
6985: IF P_DEBUG_MODE = 'Y' THEN
6986: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Delete_PJR_Txns.begin'

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

6982: PA_DEBUG.init_err_stack('PA_ASSIGNMENTS_PUB.Delete_PJR_Txns');
6983:
6984: --Log Message
6985: IF P_DEBUG_MODE = 'Y' THEN
6986: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Delete_PJR_Txns.begin'
6987: ,x_msg => 'Beginning of Delete_PJR_Txns'
6988: ,x_log_level => 5);
6989: END IF;
6990:

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

7006: LOOP
7007:
7008: --Log Message
7009: IF P_DEBUG_MODE = 'Y' THEN
7010: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Delete_PJR_Txns.pvt_delete_asgmt'
7011: ,x_msg => 'Calling PVT Delete_Assignment'
7012: ,x_log_level => 5);
7013: END IF;
7014:

Line 7047: PA_DEBUG.Reset_Err_Stack;

7043: );
7044: END IF;
7045:
7046: -- Reset the error stack when returning to the calling program
7047: PA_DEBUG.Reset_Err_Stack;
7048:
7049: -- If any errors exist then set the x_return_status to 'E'
7050:
7051: IF x_msg_count > 0 THEN

Line 7058: PA_DEBUG.Reset_Err_Stack;

7054:
7055: END IF;
7056:
7057: -- Reset the error stack when returning to the calling program
7058: PA_DEBUG.Reset_Err_Stack;
7059:
7060: IF p_commit = FND_API.G_TRUE THEN
7061: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
7062: COMMIT;

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

7074: ROLLBACK TO ASG_PUB_DELETE_PJR_TXNS;
7075: END IF;
7076: -- Set the exception Message and the stack
7077: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_PUB.Delete_PJR_Txns'
7078: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
7079: --
7080: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7081: RAISE; -- This is optional depending on the needs
7082: --