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 2078: PA_DEBUG.Reset_Err_Stack;

2074: );
2075: END IF;
2076:
2077: -- Reset the error stack when returning to the calling program
2078: PA_DEBUG.Reset_Err_Stack;
2079:
2080:
2081: IF x_msg_count > 0 THEN
2082:

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

2093: ROLLBACK TO ASG_PUB_CHANGE_STATUS;
2094: END IF;
2095: -- Set the excetption Message and the stack
2096: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PUB.Change_Assignment_Status'
2097: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
2098: --
2099: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2100: RAISE; -- This is optional depending on the needs
2101:

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

2146: AND pwnp.current_approver_flag = 'Y'
2147: AND pwnp.user_name = fu.user_name;
2148: BEGIN
2149: -- Initialize the Error Stack
2150: PA_DEBUG.init_err_stack('PA_ASSIGNMENT_APPROVAL_PUB.Get_Current_Approver');
2151:
2152: --Log Message
2153: IF P_DEBUG_MODE = 'Y' THEN
2154: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Get_Current_Approver.begin'

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

2150: PA_DEBUG.init_err_stack('PA_ASSIGNMENT_APPROVAL_PUB.Get_Current_Approver');
2151:
2152: --Log Message
2153: IF P_DEBUG_MODE = 'Y' THEN
2154: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Get_Current_Approver.begin'
2155: ,x_msg => 'Beginning of Get_Current_Approver'
2156: ,x_log_level => 5);
2157: END IF;
2158:

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

2186: EXCEPTION
2187: WHEN OTHERS THEN
2188: -- Set the excetption Message and the stack
2189: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PUB.Get_Current_Approver'
2190: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
2191: RAISE; -- This is optional depending on the needs
2192:
2193: END Get_Current_Approver;
2194:

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

2226: AND rownum=1;
2227:
2228: BEGIN
2229: -- Initialize the Error Stack
2230: PA_DEBUG.init_err_stack('PA_ASSIGNMENT_APPROVAL_PUB.Cancel_Assignment');
2231:
2232: --Log Message
2233: IF P_DEBUG_MODE = 'Y' THEN
2234: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Cancel_Assignment.begin'

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

2230: PA_DEBUG.init_err_stack('PA_ASSIGNMENT_APPROVAL_PUB.Cancel_Assignment');
2231:
2232: --Log Message
2233: IF P_DEBUG_MODE = 'Y' THEN
2234: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Cancel_Assignment.begin'
2235: ,x_msg => 'Beginning of Cancel_Assignment'
2236: ,x_log_level => 5);
2237: END IF;
2238:

Line 2312: PA_DEBUG.Reset_Err_Stack;

2308: );
2309: END IF;
2310:
2311: -- Reset the error stack when returning to the calling program
2312: PA_DEBUG.Reset_Err_Stack;
2313:
2314:
2315: IF x_msg_count > 0 THEN
2316:

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

2321: EXCEPTION
2322: WHEN OTHERS THEN
2323: -- Set the excetption Message and the stack
2324: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PUB.Cancel_Assignment'
2325: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
2326: --
2327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2328: RAISE; -- This is optional depending on the needs
2329:

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

2505:
2506: BEGIN
2507:
2508: -- Initialize the Error Stack
2509: PA_DEBUG.init_err_stack('PA_ASSIGNMENT_APPROVAL_PUB.mass_submit_for_assignment_approval');
2510:
2511: --Log Message
2512: IF P_DEBUG_MODE = 'Y' THEN
2513: PA_DEBUG.write_log

Line 2513: PA_DEBUG.write_log

2509: PA_DEBUG.init_err_stack('PA_ASSIGNMENT_APPROVAL_PUB.mass_submit_for_assignment_approval');
2510:
2511: --Log Message
2512: IF P_DEBUG_MODE = 'Y' THEN
2513: PA_DEBUG.write_log
2514: ( x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.mass_submit_for_assignment_approval.begin'
2515: ,x_msg => 'Beginning of mass_submit_for_assignment_approval'
2516: ,x_log_level => 1);
2517: END IF;

Line 2567: PA_DEBUG.write_log

2563: IF l_admin_project = 'N' THEN
2564:
2565: --Log Message
2566: IF P_DEBUG_MODE = 'Y' THEN
2567: PA_DEBUG.write_log
2568: (x_module => 'PA_ASSIGNMENT_APPROVAL_PUB.mass_submit_for_assignment_approval.check_prj_manager.'
2569: ,x_msg => 'Check if project manger exists.'
2570: ,x_log_level => 1);
2571: END IF;

Line 2722: PA_DEBUG.Reset_Err_Stack;

2718: ,p_msg_index_out => l_msg_index_out );
2719: END IF;
2720:
2721: -- Reset the error stack when returning to the calling program
2722: PA_DEBUG.Reset_Err_Stack;
2723:
2724: -- If g_error_exists is TRUE then set the x_return_status to 'E'
2725: IF FND_MSG_PUB.Count_Msg >0 THEN
2726: x_return_status := FND_API.G_RET_STS_ERROR;

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

2735:
2736: -- Set the excetption Message and the stack
2737: FND_MSG_PUB.add_exc_msg
2738: ( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PUB.mass_submit_for_asgmt_aprvl'
2739: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
2740:
2741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2742: RAISE;
2743:

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

2894:
2895: BEGIN
2896:
2897: -- Initialize the Error Stack
2898: PA_DEBUG.init_err_stack('PA_ASSIGNMENT_APPROVAL_PUB.mass_assignment_approval');
2899:
2900: --Log Message
2901: IF P_DEBUG_MODE = 'Y' THEN
2902: PA_DEBUG.write_log

Line 2902: PA_DEBUG.write_log

2898: PA_DEBUG.init_err_stack('PA_ASSIGNMENT_APPROVAL_PUB.mass_assignment_approval');
2899:
2900: --Log Message
2901: IF P_DEBUG_MODE = 'Y' THEN
2902: PA_DEBUG.write_log
2903: ( x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.mass_assignment_approval.begin'
2904: ,x_msg => 'Beginning of mass_assignment_approval'
2905: ,x_log_level => 1);
2906: END IF;

Line 3706: PA_DEBUG.Reset_Err_Stack;

3702: ,p_msg_index_out => l_msg_index_out );
3703: END IF;
3704:
3705: -- Reset the error stack when returning to the calling program
3706: PA_DEBUG.Reset_Err_Stack;
3707:
3708: -- If g_error_exists is TRUE then set the x_return_status to 'E'
3709: IF FND_MSG_PUB.Count_Msg >0 THEN
3710: x_return_status := FND_API.G_RET_STS_ERROR;

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

3723:
3724: -- Set the excetption Message and the stack
3725: FND_MSG_PUB.add_exc_msg
3726: ( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PUB.mass_assignment_approval'
3727: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
3728:
3729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3730: RAISE;
3731:

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

3737:
3738: -- Set the excetption Message and the stack
3739: FND_MSG_PUB.add_exc_msg
3740: ( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PUB.mass_assignment_approval'
3741: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
3742:
3743: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3744: RAISE;
3745: END mass_assignment_approval;

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

3800:
3801: BEGIN
3802:
3803: -- Initialize the Error Stack
3804: PA_DEBUG.init_err_stack('PA_ASSIGNMENT_APPROVAL_PUB.mass_process_approval_result');
3805:
3806: log_message('Inside mass_process_approval_result');
3807:
3808: --Log Message

Line 3810: PA_DEBUG.write_log

3806: log_message('Inside mass_process_approval_result');
3807:
3808: --Log Message
3809: IF P_DEBUG_MODE = 'Y' THEN
3810: PA_DEBUG.write_log
3811: ( x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.mass_process_approval_result.begin'
3812: ,x_msg => 'Beginning of mass_assignment_approval'
3813: ,x_log_level => 1);
3814: END IF;

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

4026:
4027: -- Set the excetption Message and the stack
4028: FND_MSG_PUB.add_exc_msg
4029: ( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PUB.mass_process_approval_result'
4030: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
4031:
4032: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4033: RAISE;
4034: END mass_process_approval_result;

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

4075:
4076: BEGIN
4077:
4078: -- Initialize the Error Stack
4079: PA_DEBUG.init_err_stack('PA_ASSIGNMENT_APPROVAL_PUB.validate_approver_name_id');
4080:
4081: --Log Message
4082: IF P_DEBUG_MODE = 'Y' THEN
4083: PA_DEBUG.write_log

Line 4083: PA_DEBUG.write_log

4079: PA_DEBUG.init_err_stack('PA_ASSIGNMENT_APPROVAL_PUB.validate_approver_name_id');
4080:
4081: --Log Message
4082: IF P_DEBUG_MODE = 'Y' THEN
4083: PA_DEBUG.write_log
4084: ( x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.validate_approver_name_id.begin'
4085: ,x_msg => 'Beginning of approver name id validation'
4086: ,x_log_level => 1);
4087: END IF;

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

4300:
4301: -- Set the excetption Message and the stack
4302: FND_MSG_PUB.add_exc_msg
4303: ( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PUB.validate_approver_name_id'
4304: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
4305:
4306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4307: RAISE;
4308: END validate_approver_name_id;