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

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

6: -- Parameters Type Required Description
7: -- p_log_msg VARCHAR2 YES It stores text which you want to print on screen
8: -- Out parameters
9: ----------------------------------------------------------------------------------------------------------------
10: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */
11:
12: PROCEDURE log_message (p_log_msg IN VARCHAR2)
13: IS
14: BEGIN

Line 17: pa_debug.write('log_message: ' || 'Assignment Approval', 'log: ' || p_log_msg, 3);

13: IS
14: BEGIN
15: --dbms_output.put_line('log: ' || p_log_msg);
16: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
17: pa_debug.write('log_message: ' || 'Assignment Approval', 'log: ' || p_log_msg, 3);
18: END IF;
19: NULL;
20: END log_message;
21:

Line 123: PA_DEBUG.init_err_stack('PA_ASSIGNMENT_APPROVAL_PUB.Start_Assignment_Approvals');

119:
120:
121: BEGIN
122: -- Initialize the Error Stack
123: PA_DEBUG.init_err_stack('PA_ASSIGNMENT_APPROVAL_PUB.Start_Assignment_Approvals');
124:
125: --Log Message
126: IF P_DEBUG_MODE = 'Y' THEN
127: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Start_Assignment_Approvals.begin'

Line 127: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Start_Assignment_Approvals.begin'

123: PA_DEBUG.init_err_stack('PA_ASSIGNMENT_APPROVAL_PUB.Start_Assignment_Approvals');
124:
125: --Log Message
126: IF P_DEBUG_MODE = 'Y' THEN
127: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Start_Assignment_Approvals.begin'
128: ,x_msg => 'Beginning of Start_Assignment_Approvals'
129: ,x_log_level => 5);
130: END IF;
131:

Line 173: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Start_Assignment_Approvals.check_resource'

169: l_approver_person_id := p_apr_person_id;
170:
171: --Log Message
172: IF P_DEBUG_MODE = 'Y' THEN
173: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Start_Assignment_Approvals.check_resource'
174: ,x_msg => 'Checking Resource.'
175: ,x_log_level => 5);
176: END IF;
177: /* A temporary fix:

Line 220: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Start_Assignment_Approvals.into_g_table'

216:
217: -- Put the Approver into record only exclude flag=N and submitter is not the approver
218: IF p_apr_person_exclude = 'N' AND l_submitter_person_id <> l_approver_person_id THEN
219: IF P_DEBUG_MODE = 'Y' THEN
220: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Start_Assignment_Approvals.into_g_table'
221: ,x_msg => 'Putting approver into global table.'
222: ,x_log_level => 5);
223: END IF;
224: l_approver_rec.person_id := l_approver_person_id;

Line 267: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Start_Assignment_Approvals.validate_false'

263: IF (p_validate_only = FND_API.G_FALSE AND (p_check_overcommitment_flag ='N'
264: OR (p_check_overcommitment_flag ='Y' AND l_overcommitment_flag = 'N'))) THEN
265:
266: IF P_DEBUG_MODE = 'Y' THEN
267: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Start_Assignment_Approvals.validate_false'
268: ,x_msg => 'Not just validating.'
269: ,x_log_level => 5);
270: END IF;
271: --------------------------------------------------------------------------------------------------------

Line 293: PA_DEBUG.write_log ('pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Start_Assignment_Approvals.submit'

289: --------------------------------------------------------------------------------------------------------
290: IF l_action_code = PA_ASSIGNMENT_APPROVAL_PUB.g_submit_action THEN
291:
292: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
293: PA_DEBUG.write_log ('pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Start_Assignment_Approvals.submit'
294: ,'Submitting an approval.', 5);
295: END IF;
296:
297: --Check if approval is required

Line 310: PA_DEBUG.write_log ('pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Start_Assignment_Approvals.appr_reqd'

306: -- If Approval Required
307: --------------------------------------------------------------------------------------------------------
308: IF l_approval_required_flag = 'Y' THEN
309: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
310: PA_DEBUG.write_log ('pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Start_Assignment_Approvals.appr_reqd'
311: ,'Approval Required.', 5);
312: END IF;
313:
314: --Check if workflow enabled

Line 332: PA_DEBUG.write_log ('pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Start_Assignment_Approvals.enabled'

328: --------------------------------------------------------------------------------------------------------
329: -- If Workflow is Enabled
330: --------------------------------------------------------------------------------------------------------
331: IF l_wf_type <> 'NOT_ENABLED' THEN
332: PA_DEBUG.write_log ('pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Start_Assignment_Approvals.enabled'
333: ,'Workflow is enabled. Now validating approvers order.',5);
334:
335: --Validate Approvers Order
336: PA_ASSIGNMENT_APPROVAL_PVT.Validate_Approver_Orders (x_return_status => l_return_status);

Line 411: PA_DEBUG.write_log ('pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Start_Assignment_Approvals.update_status',

407: -- if there is no error so far
408: IF FND_MSG_PUB.Count_Msg < 1 THEN
409:
410: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
411: PA_DEBUG.write_log ('pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Start_Assignment_Approvals.update_status',
412: 'Update Assignment Approval Status.', 5);
413: END IF;
414: --------------------------------------------------------------------------------------------------------
415: -- Update Approval Status

Line 462: PA_DEBUG.write_log ('pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Start_Assignment_Approvals.get_wf_info'

458: --If previously no workflow info has been obtained, then get it.
459: IF (l_wf_item_type IS NULL AND l_wf_process IS NULL AND l_wf_type IS NULL) THEN
460:
461: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
462: PA_DEBUG.write_log ('pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Start_Assignment_Approvals.get_wf_info'
463: ,'Getting workflow info.', 5);
464: END IF;
465:
466: --dbms_output.put_line('error before get_workflow_process_info'||FND_MSG_PUB.Count_Msg);

Line 496: PA_DEBUG.write_log ('pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Start_Assignment_Approvals.get_approvers',

492: (l_action_code <> PA_ASSIGNMENT_APPROVAL_PUB.g_cancel_action OR p_new_assignment_flag = 'N' )THEN
493:
494: --dbms_output.put_line('ready to launch');
495: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
496: PA_DEBUG.write_log ('pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Start_Assignment_Approvals.get_approvers',
497: 'Workflow enabled. Getting Approvers ready for start workflow.', 5);
498: END IF;
499:
500: --------------------------------------------------------------------------------------------------------

Line 523: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Start_Assignment_Approvals.check_prj_manager.'

519: -- Validate if a project manager exist for non-admin projects
520: --------------------------------------------------------------------------------------------------------
521: IF l_assignment_type <> 'STAFFED_ADMIN_ASSIGNMENT' THEN
522: IF P_DEBUG_MODE = 'Y' THEN
523: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Start_Assignment_Approvals.check_prj_manager.'
524: ,x_msg => 'Check if proj manger exists.'
525: ,x_log_level => 5);
526: END IF;
527: pa_project_parties_utils.get_curr_proj_mgr_details

Line 564: PA_DEBUG.write_log ('pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Start_Assignment_Approvals.launch_wf'

560: -- Launch workflow
561: --------------------------------------------------------------------------------------------------------
562: IF FND_MSG_PUB.Count_Msg < 1 THEN
563: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
564: PA_DEBUG.write_log ('pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Start_Assignment_Approvals.launch_wf'
565: ,'Launching workflow.', 5);
566: END IF;
567: --dbms_output.put_line('wf item type: '||l_wf_item_type ||', wf process: '||l_wf_process ||
568: -- 'apprvl_status_code'||l_apprvl_status_code);

Line 619: PA_DEBUG.Reset_Err_Stack;

615: END IF;
616: END IF;
617:
618: -- Reset the error stack when returning to the calling program
619: PA_DEBUG.Reset_Err_Stack;
620:
621: EXCEPTION
622: WHEN FND_API.G_EXC_ERROR THEN
623: x_return_status := FND_API.G_RET_STS_ERROR;

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

636: END IF;
637:
638: -- Set the exception Message and the stack
639: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PVT.Start_Assignment_Approvals'
640: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
642:
643: --clear PL/SQL table for next time
644: PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.DELETE;

Line 689: PA_DEBUG.init_err_stack('PA_ASSIGNMENT_APPROVAL_PUB.Revert_To_Last_Approved');

685:
686: BEGIN
687:
688: -- Initialize the Error Stack
689: PA_DEBUG.init_err_stack('PA_ASSIGNMENT_APPROVAL_PUB.Revert_To_Last_Approved');
690:
691: --Log Message
692: IF P_DEBUG_MODE = 'Y' THEN
693: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Revert_To_Last_Approved.begin'

Line 693: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Revert_To_Last_Approved.begin'

689: PA_DEBUG.init_err_stack('PA_ASSIGNMENT_APPROVAL_PUB.Revert_To_Last_Approved');
690:
691: --Log Message
692: IF P_DEBUG_MODE = 'Y' THEN
693: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Revert_To_Last_Approved.begin'
694: ,x_msg => 'Beginning of Revert_To_Last_Approved.'
695: ,x_log_level => 5);
696: END IF;
697:

Line 889: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Revert_To_Last_Approved.delete_row'

885:
886:
887: --Log Message
888: IF P_DEBUG_MODE = 'Y' THEN
889: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Revert_To_Last_Approved.delete_row'
890: ,x_msg => 'Deleting last approved record.'
891: ,x_log_level => 5);
892: END IF;
893:

Line 915: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Revert_To_Last_Approved.get_next_stus'

911:
912:
913: --Log Message
914: IF P_DEBUG_MODE = 'Y' THEN
915: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Revert_To_Last_Approved.get_next_stus'
916: ,x_msg => 'Get next assignment approval status..'
917: ,x_log_level => 5);
918: END IF;
919:

Line 937: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Revert_To_Last_Approved.update_row'

933: IF (FND_MSG_PUB.Count_Msg = 0) THEN
934:
935: --Log Message
936: IF P_DEBUG_MODE = 'Y' THEN
937: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Revert_To_Last_Approved.update_row'
938: ,x_msg => 'Update current record with history record details.'
939: ,x_log_level => 5);
940: END IF;
941:

Line 1025: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Revert_To_Last_Approved.revert_schedule'

1021: ,x_return_status => l_return_status);
1022:
1023: --Log Message
1024: IF P_DEBUG_MODE = 'Y' THEN
1025: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Revert_To_Last_Approved.revert_schedule'
1026: ,x_msg => 'Reverting Schedule.'
1027: ,x_log_level => 5);
1028: END IF;
1029: --

Line 1039: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Revert_To_Last_Approved.revert_subteam'

1035: ,x_msg_count => l_msg_count
1036: ,x_msg_data => l_msg_data);
1037: --Log Message
1038: IF P_DEBUG_MODE = 'Y' THEN
1039: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Revert_To_Last_Approved.revert_subteam'
1040: ,x_msg => 'Reverting Subteam.'
1041: ,x_log_level => 5);
1042: END IF;
1043:

Line 1083: PA_DEBUG.Reset_Err_Stack;

1079: END IF;
1080:
1081: -- Reset the error stack when returning to the calling program
1082:
1083: PA_DEBUG.Reset_Err_Stack;
1084:
1085: -- If g_error_exists is TRUE then set the x_return_status to 'E'
1086:
1087: IF FND_MSG_PUB.Count_Msg >0 THEN

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

1098: END IF;
1099:
1100: -- Set the exception Message and the stack
1101: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PUB.Revert_To_Last_Approved'
1102: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1104:
1105: RAISE; -- This is optional depending on the needs
1106:

Line 1232: PA_DEBUG.init_err_stack('PA_ASSIGNMENT_APPROVAL_PUB.Populate_Changed_Items_Table');

1228: --Issue rollback to clean up the Global Temporary Table PA_ASGMT_CHANGED_ITEMS
1229: ROLLBACK;
1230:
1231: -- Initialize the Error Stack
1232: PA_DEBUG.init_err_stack('PA_ASSIGNMENT_APPROVAL_PUB.Populate_Changed_Items_Table');
1233:
1234: -- Initialize the return status to success
1235: x_return_status := FND_API.G_RET_STS_SUCCESS;
1236:

Line 1575: PA_DEBUG.Reset_Err_Stack;

1571: END IF;
1572: END IF;
1573:
1574: -- Reset the error stack when returning to the calling program
1575: PA_DEBUG.Reset_Err_Stack;
1576:
1577: EXCEPTION
1578: WHEN OTHERS THEN
1579: -- Set the exception Message and the stack

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

1577: EXCEPTION
1578: WHEN OTHERS THEN
1579: -- Set the exception Message and the stack
1580: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PUB.Populate_Changed_Items_Table'
1581: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1582: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1583: RAISE; -- This is optional depending on the needs
1584:
1585: END Populate_Changed_Items_Table;

Line 1715: PA_DEBUG.init_err_stack('PA_ASSIGNMENT_APPROVAL_PUB.Cancel_Assignment');

1711: AND rlm.res_format_id = rf.res_format_id;
1712:
1713: BEGIN
1714: -- Initialize the Error Stack
1715: PA_DEBUG.init_err_stack('PA_ASSIGNMENT_APPROVAL_PUB.Cancel_Assignment');
1716:
1717: --Log Message
1718: IF P_DEBUG_MODE = 'Y' THEN
1719: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Cancel_Assignment.begin'

Line 1719: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Cancel_Assignment.begin'

1715: PA_DEBUG.init_err_stack('PA_ASSIGNMENT_APPROVAL_PUB.Cancel_Assignment');
1716:
1717: --Log Message
1718: IF P_DEBUG_MODE = 'Y' THEN
1719: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Cancel_Assignment.begin'
1720: ,x_msg => 'Beginning of Cancel_Assignment'
1721: ,x_log_level => 5);
1722: END IF;
1723:

Line 1765: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Cancel_Assignment'

1761:
1762:
1763: --Log Message
1764: IF P_DEBUG_MODE = 'Y' THEN
1765: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Cancel_Assignment'
1766: ,x_msg => 'calling PA_SCHEDULE_PUB.Change_Status'
1767: ,x_log_level => 5);
1768: END IF;
1769: PA_SCHEDULE_PUB.Change_Status(p_record_version_number => l_record_version_number,

Line 1834: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Cancel_Assignment'

1830: IF p_assignment_type = 'OPEN_ASSIGNMENT' THEN
1831:
1832: -- dbms_output.put_line('declining candidates');
1833: IF P_DEBUG_MODE = 'Y' THEN
1834: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Cancel_Assignment'
1835: ,x_msg => 'Calling PA_CANDIDATE_PUB.Decline_Candidates'
1836: ,x_log_level => 5);
1837: END IF;
1838:

Line 1854: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Cancel_Assignment'

1850: --dbms_output.put_line('before PA_ACTION_SETS_PUB.Update_Action_Set');
1851:
1852: --Log Message
1853: IF P_DEBUG_MODE = 'Y' THEN
1854: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Cancel_Assignment'
1855: ,x_msg => 'calling PA_ACTION_SETS_PUB.Update_Action_Set'
1856: ,x_log_level => 5);
1857: END IF;
1858:

Line 2089: PA_DEBUG.Reset_Err_Stack;

2085: );
2086: END IF;
2087:
2088: -- Reset the error stack when returning to the calling program
2089: PA_DEBUG.Reset_Err_Stack;
2090:
2091:
2092: IF x_msg_count > 0 THEN
2093:

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

2104: ROLLBACK TO ASG_PUB_CHANGE_STATUS;
2105: END IF;
2106: -- Set the excetption Message and the stack
2107: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PUB.Change_Assignment_Status'
2108: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
2109: --
2110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2111: RAISE; -- This is optional depending on the needs
2112:

Line 2185: PA_DEBUG.init_err_stack('PA_ASSIGNMENT_APPROVAL_PUB.Get_Current_Approver');

2181: -- End of Bug# 8296021
2182:
2183: BEGIN
2184: -- Initialize the Error Stack
2185: PA_DEBUG.init_err_stack('PA_ASSIGNMENT_APPROVAL_PUB.Get_Current_Approver');
2186:
2187: --Log Message
2188: IF P_DEBUG_MODE = 'Y' THEN
2189: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Get_Current_Approver.begin'

Line 2189: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Get_Current_Approver.begin'

2185: PA_DEBUG.init_err_stack('PA_ASSIGNMENT_APPROVAL_PUB.Get_Current_Approver');
2186:
2187: --Log Message
2188: IF P_DEBUG_MODE = 'Y' THEN
2189: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Get_Current_Approver.begin'
2190: ,x_msg => 'Beginning of Get_Current_Approver'
2191: ,x_log_level => 5);
2192: END IF;
2193:

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

2242: EXCEPTION
2243: WHEN OTHERS THEN
2244: -- Set the excetption Message and the stack
2245: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PUB.Get_Current_Approver'
2246: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
2247: RAISE; -- This is optional depending on the needs
2248:
2249: END Get_Current_Approver;
2250:

Line 2286: PA_DEBUG.init_err_stack('PA_ASSIGNMENT_APPROVAL_PUB.Cancel_Assignment');

2282: AND rownum=1;
2283:
2284: BEGIN
2285: -- Initialize the Error Stack
2286: PA_DEBUG.init_err_stack('PA_ASSIGNMENT_APPROVAL_PUB.Cancel_Assignment');
2287:
2288: --Log Message
2289: IF P_DEBUG_MODE = 'Y' THEN
2290: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Cancel_Assignment.begin'

Line 2290: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Cancel_Assignment.begin'

2286: PA_DEBUG.init_err_stack('PA_ASSIGNMENT_APPROVAL_PUB.Cancel_Assignment');
2287:
2288: --Log Message
2289: IF P_DEBUG_MODE = 'Y' THEN
2290: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Cancel_Assignment.begin'
2291: ,x_msg => 'Beginning of Cancel_Assignment'
2292: ,x_log_level => 5);
2293: END IF;
2294:

Line 2373: PA_DEBUG.Reset_Err_Stack;

2369: );
2370: END IF;
2371:
2372: -- Reset the error stack when returning to the calling program
2373: PA_DEBUG.Reset_Err_Stack;
2374:
2375:
2376: IF x_msg_count > 0 THEN
2377:

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

2382: EXCEPTION
2383: WHEN OTHERS THEN
2384: -- Set the excetption Message and the stack
2385: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PUB.Cancel_Assignment'
2386: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
2387: --
2388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2389: RAISE; -- This is optional depending on the needs
2390:

Line 2570: PA_DEBUG.init_err_stack('PA_ASSIGNMENT_APPROVAL_PUB.mass_submit_for_assignment_approval');

2566:
2567: BEGIN
2568:
2569: -- Initialize the Error Stack
2570: PA_DEBUG.init_err_stack('PA_ASSIGNMENT_APPROVAL_PUB.mass_submit_for_assignment_approval');
2571:
2572: --Log Message
2573: IF P_DEBUG_MODE = 'Y' THEN
2574: PA_DEBUG.write_log

Line 2574: PA_DEBUG.write_log

2570: PA_DEBUG.init_err_stack('PA_ASSIGNMENT_APPROVAL_PUB.mass_submit_for_assignment_approval');
2571:
2572: --Log Message
2573: IF P_DEBUG_MODE = 'Y' THEN
2574: PA_DEBUG.write_log
2575: ( x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.mass_submit_for_assignment_approval.begin'
2576: ,x_msg => 'Beginning of mass_submit_for_assignment_approval'
2577: ,x_log_level => 1);
2578: END IF;

Line 2628: PA_DEBUG.write_log

2624: IF l_admin_project = 'N' THEN
2625:
2626: --Log Message
2627: IF P_DEBUG_MODE = 'Y' THEN
2628: PA_DEBUG.write_log
2629: (x_module => 'PA_ASSIGNMENT_APPROVAL_PUB.mass_submit_for_assignment_approval.check_prj_manager.'
2630: ,x_msg => 'Check if project manger exists.'
2631: ,x_log_level => 1);
2632: END IF;

Line 2783: PA_DEBUG.Reset_Err_Stack;

2779: ,p_msg_index_out => l_msg_index_out );
2780: END IF;
2781:
2782: -- Reset the error stack when returning to the calling program
2783: PA_DEBUG.Reset_Err_Stack;
2784:
2785: -- If g_error_exists is TRUE then set the x_return_status to 'E'
2786: IF FND_MSG_PUB.Count_Msg >0 THEN
2787: x_return_status := FND_API.G_RET_STS_ERROR;

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

2796:
2797: -- Set the excetption Message and the stack
2798: FND_MSG_PUB.add_exc_msg
2799: ( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PUB.mass_submit_for_asgmt_aprvl'
2800: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
2801:
2802: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2803: RAISE;
2804:

Line 2959: PA_DEBUG.init_err_stack('PA_ASSIGNMENT_APPROVAL_PUB.mass_assignment_approval');

2955:
2956: BEGIN
2957:
2958: -- Initialize the Error Stack
2959: PA_DEBUG.init_err_stack('PA_ASSIGNMENT_APPROVAL_PUB.mass_assignment_approval');
2960:
2961: --Log Message
2962: IF P_DEBUG_MODE = 'Y' THEN
2963: PA_DEBUG.write_log

Line 2963: PA_DEBUG.write_log

2959: PA_DEBUG.init_err_stack('PA_ASSIGNMENT_APPROVAL_PUB.mass_assignment_approval');
2960:
2961: --Log Message
2962: IF P_DEBUG_MODE = 'Y' THEN
2963: PA_DEBUG.write_log
2964: ( x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.mass_assignment_approval.begin'
2965: ,x_msg => 'Beginning of mass_assignment_approval'
2966: ,x_log_level => 1);
2967: END IF;

Line 3771: PA_DEBUG.Reset_Err_Stack;

3767: ,p_msg_index_out => l_msg_index_out );
3768: END IF;
3769:
3770: -- Reset the error stack when returning to the calling program
3771: PA_DEBUG.Reset_Err_Stack;
3772:
3773: -- If g_error_exists is TRUE then set the x_return_status to 'E'
3774: IF FND_MSG_PUB.Count_Msg >0 THEN
3775: x_return_status := FND_API.G_RET_STS_ERROR;

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

3788:
3789: -- Set the excetption Message and the stack
3790: FND_MSG_PUB.add_exc_msg
3791: ( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PUB.mass_assignment_approval'
3792: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
3793:
3794: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3795: RAISE;
3796:

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

3802:
3803: -- Set the excetption Message and the stack
3804: FND_MSG_PUB.add_exc_msg
3805: ( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PUB.mass_assignment_approval'
3806: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
3807:
3808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3809: RAISE;
3810: END mass_assignment_approval;

Line 3869: PA_DEBUG.init_err_stack('PA_ASSIGNMENT_APPROVAL_PUB.mass_process_approval_result');

3865:
3866: BEGIN
3867:
3868: -- Initialize the Error Stack
3869: PA_DEBUG.init_err_stack('PA_ASSIGNMENT_APPROVAL_PUB.mass_process_approval_result');
3870:
3871: log_message('Inside mass_process_approval_result');
3872:
3873: --Log Message

Line 3875: PA_DEBUG.write_log

3871: log_message('Inside mass_process_approval_result');
3872:
3873: --Log Message
3874: IF P_DEBUG_MODE = 'Y' THEN
3875: PA_DEBUG.write_log
3876: ( x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.mass_process_approval_result.begin'
3877: ,x_msg => 'Beginning of mass_assignment_approval'
3878: ,x_log_level => 1);
3879: END IF;

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

4091:
4092: -- Set the excetption Message and the stack
4093: FND_MSG_PUB.add_exc_msg
4094: ( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PUB.mass_process_approval_result'
4095: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
4096:
4097: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4098: RAISE;
4099: END mass_process_approval_result;

Line 4144: PA_DEBUG.init_err_stack('PA_ASSIGNMENT_APPROVAL_PUB.validate_approver_name_id');

4140:
4141: BEGIN
4142:
4143: -- Initialize the Error Stack
4144: PA_DEBUG.init_err_stack('PA_ASSIGNMENT_APPROVAL_PUB.validate_approver_name_id');
4145:
4146: --Log Message
4147: IF P_DEBUG_MODE = 'Y' THEN
4148: PA_DEBUG.write_log

Line 4148: PA_DEBUG.write_log

4144: PA_DEBUG.init_err_stack('PA_ASSIGNMENT_APPROVAL_PUB.validate_approver_name_id');
4145:
4146: --Log Message
4147: IF P_DEBUG_MODE = 'Y' THEN
4148: PA_DEBUG.write_log
4149: ( x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.validate_approver_name_id.begin'
4150: ,x_msg => 'Beginning of approver name id validation'
4151: ,x_log_level => 1);
4152: END IF;

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

4365:
4366: -- Set the excetption Message and the stack
4367: FND_MSG_PUB.add_exc_msg
4368: ( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PUB.validate_approver_name_id'
4369: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
4370:
4371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4372: RAISE;
4373: END validate_approver_name_id;