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_ASSIGNMENT_APPROVAL_PUB

Line 1: PACKAGE BODY PA_ASSIGNMENT_APPROVAL_PUB AS

1: PACKAGE BODY PA_ASSIGNMENT_APPROVAL_PUB AS
2: /*$Header: PARAAPBB.pls 120.7 2007/11/07 14:16:23 rthumma ship $*/
3: --------------------------------------------------------------------------------------------------------------
4: -- This procedure prints the text which is being passed as the input
5: -- Input parameters

Line 54: l_approver_rec PA_ASSIGNMENT_APPROVAL_PUB.Asgmt_Approvers_Rec_Type;

50: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
51: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
52: ) IS
53:
54: l_approver_rec PA_ASSIGNMENT_APPROVAL_PUB.Asgmt_Approvers_Rec_Type;
55: l_assignment_type pa_project_assignments.assignment_type%TYPE;
56: l_project_id pa_project_assignments.project_id%TYPE;
57: l_project_status_name pa_project_statuses.project_status_name%TYPE;
58: l_success_status_code pa_project_statuses.project_status_code%TYPE;

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 142: PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.delete;

138: --Clear the global PL/SQL message table
139: FND_MSG_PUB.initialize;
140:
141: -- delete all the records from the approver_tbl
142: PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.delete;
143: END IF;
144:
145: -- Issue API savepoint if the transaction is to be committed
146: IF p_commit = FND_API.G_TRUE THEN

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 228: PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl(PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.COUNT+1) := l_approver_rec;

224: l_approver_rec.person_id := l_approver_person_id;
225: l_approver_rec.approver_person_type := p_apr_person_type;
226: l_approver_rec.orders := p_apr_person_order;
227:
228: PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl(PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.COUNT+1) := l_approver_rec;
229: END IF; -- IF p_apr_person_exclude = 'N'
230:
231: END IF;-- end of valid resource
232:

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 275: IF l_action_code NOT IN (PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action, PA_ASSIGNMENT_APPROVAL_PUB.g_reject_action,

271: --------------------------------------------------------------------------------------------------------
272: -- Validate Action Code
273: --------------------------------------------------------------------------------------------------------
274: l_action_code := p_action_code;
275: IF l_action_code NOT IN (PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action, PA_ASSIGNMENT_APPROVAL_PUB.g_reject_action,
276: PA_ASSIGNMENT_APPROVAL_PUB.g_submit_action, PA_ASSIGNMENT_APPROVAL_PUB.g_cancel_action) THEN
277: PA_UTILS.Add_Message('PA', 'PA_UNEXP_APPRVL_ACTION');
278: END IF;
279:

Line 276: PA_ASSIGNMENT_APPROVAL_PUB.g_submit_action, PA_ASSIGNMENT_APPROVAL_PUB.g_cancel_action) THEN

272: -- Validate Action Code
273: --------------------------------------------------------------------------------------------------------
274: l_action_code := p_action_code;
275: IF l_action_code NOT IN (PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action, PA_ASSIGNMENT_APPROVAL_PUB.g_reject_action,
276: PA_ASSIGNMENT_APPROVAL_PUB.g_submit_action, PA_ASSIGNMENT_APPROVAL_PUB.g_cancel_action) THEN
277: PA_UTILS.Add_Message('PA', 'PA_UNEXP_APPRVL_ACTION');
278: END IF;
279:
280:

Line 290: IF l_action_code = PA_ASSIGNMENT_APPROVAL_PUB.g_submit_action THEN

286:
287: --------------------------------------------------------------------------------------------------------
288: -- If Action = 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);

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 315: PA_ASGMT_WFSTD.get_workflow_process_info(p_status_code => PA_ASSIGNMENT_APPROVAL_PUB.g_submitted,

311: ,'Approval Required.', 5);
312: END IF;
313:
314: --Check if workflow enabled
315: PA_ASGMT_WFSTD.get_workflow_process_info(p_status_code => PA_ASSIGNMENT_APPROVAL_PUB.g_submitted,
316: x_wf_item_type => l_wf_item_type,
317: x_wf_process => l_wf_process,
318: x_wf_type => l_wf_type,
319: x_msg_count => l_msg_count,

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 341: l_action_code := PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action;

337: END IF; --end of workflow enabled
338: */
339: -- if approval is not required
340: ELSE
341: l_action_code := PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action;
342: END IF; -- if l_approval_required_flag = 'Y'
343:
344: END IF; -- l_return_status = FND_API.G_RET_STS_SUCCESS
345:

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 434: IF (l_conflict_group_id IS NOT NULL AND l_action_code=PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action) THEN

430:
431: --------------------------------------------------------------------------------------------------------
432: -- Resolve Overcommitment conflict for Approve case
433: --------------------------------------------------------------------------------------------------------
434: IF (l_conflict_group_id IS NOT NULL AND l_action_code=PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action) THEN
435: -- resolve remaining conflicts by taking action chosen by user
436: PA_SCHEDULE_PVT.RESOLVE_CONFLICTS (p_conflict_group_id => l_conflict_group_id
437: ,p_assignment_id => p_assignment_id
438: ,x_return_status => l_return_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 492: (l_action_code <> PA_ASSIGNMENT_APPROVAL_PUB.g_cancel_action OR p_new_assignment_flag = 'N' )THEN

488: --------------------------------------------------------------------------------------------------------
489: --workflow enabled and no error when getting workflow info
490: --For Cancel option, do not launch workflow if the assignment have not been previously approved.
491: IF (l_wf_type <> 'NOT_ENABLED') AND
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',

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 597: PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.DELETE;

593: END IF; -- IF FND_MSG_PUB.Count_Msg < 1
594:
595:
596: --clear PL/SQL table for next time
597: PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.DELETE;
598:
599: END IF; -- IF p_validate_only = FND_API.G_FALSE
600:
601: --------------------------------------------------------------------------------------------------------

Line 644: PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.DELETE;

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;
645: RAISE; -- This is optional depending on the needs
646:
647: END Start_Assignment_Approvals;
648:

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 923: PA_ASSIGNMENT_APPROVAL_PVT.Get_Next_Status_After_Action ( p_action_code => PA_ASSIGNMENT_APPROVAL_PUB.g_revert_action

919:
920: --
921: --Get the Assignment Approval Status after reverting
922: --
923: PA_ASSIGNMENT_APPROVAL_PVT.Get_Next_Status_After_Action ( p_action_code => PA_ASSIGNMENT_APPROVAL_PUB.g_revert_action
924: ,p_status_code => l_apprvl_status_code
925: ,x_status_code => l_next_status_code
926: ,x_return_status => l_return_status);
927:

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 1101: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PUB.Revert_To_Last_Approved'

1097: ROLLBACK TO ASG_APR_PUB_REVERT;
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

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 1580: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PUB.Populate_Changed_Items_Table'

1576:
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:

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 1991: PA_ASSIGNMENT_APPROVAL_PUB.Start_Assignment_Approvals( p_assignment_id => p_assignment_id

1987:
1988: -- update the assignment approval status and send notification when the canceled assignment
1989: -- has ever been approved.
1990:
1991: PA_ASSIGNMENT_APPROVAL_PUB.Start_Assignment_Approvals( p_assignment_id => p_assignment_id
1992: ,p_new_assignment_flag => l_new_assignment_flag
1993: ,p_action_code =>PA_ASSIGNMENT_APPROVAL_PUB.g_cancel_action
1994: ,p_record_version_number => NULL
1995: ,p_validate_only => FND_API.G_FALSE

Line 1993: ,p_action_code =>PA_ASSIGNMENT_APPROVAL_PUB.g_cancel_action

1989: -- has ever been approved.
1990:
1991: PA_ASSIGNMENT_APPROVAL_PUB.Start_Assignment_Approvals( p_assignment_id => p_assignment_id
1992: ,p_new_assignment_flag => l_new_assignment_flag
1993: ,p_action_code =>PA_ASSIGNMENT_APPROVAL_PUB.g_cancel_action
1994: ,p_record_version_number => NULL
1995: ,p_validate_only => FND_API.G_FALSE
1996: ,x_overcommitment_flag => l_overcommitment_flag
1997: ,x_conflict_group_id => l_conflict_group_id

Line 2009: ,P_ACTION_CODE => PA_ASSIGNMENT_APPROVAL_PUB.g_cancel_action

2005:
2006: -- Update apprvl_status_code
2007: PA_ASSIGNMENT_APPROVAL_PVT.Update_Approval_Status(
2008: P_ASSIGNMENT_ID => p_assignment_id
2009: ,P_ACTION_CODE => PA_ASSIGNMENT_APPROVAL_PUB.g_cancel_action
2010: ,P_RECORD_VERSION_NUMBER => NULL
2011: ,X_APPRVL_STATUS_CODE => l_apprvl_status_code
2012: ,X_CHANGE_ID => l_change_id
2013: ,X_RECORD_VERSION_NUMBER => l_record_version_number

Line 2096: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PUB.Change_Assignment_Status'

2092: IF p_commit = FND_API.G_TRUE THEN
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

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 2160: IF p_apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_submitted THEN

2156: ,x_log_level => 5);
2157: END IF;
2158:
2159: --Check to see if assignment is pending approval
2160: IF p_apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_submitted THEN
2161:
2162: --Get the maximum item key
2163: OPEN get_item_key;
2164: FETCH get_item_key INTO l_item_key, l_item_type;

Line 2189: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PUB.Get_Current_Approver'

2185: --
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;

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 2281: PA_ASSIGNMENT_APPROVAL_PUB.Change_Assignment_Status

2277:
2278: IF l_assignment_status_code IS NOT NULL THEN
2279:
2280: --call Change_Assignment_Status
2281: PA_ASSIGNMENT_APPROVAL_PUB.Change_Assignment_Status
2282: (
2283: p_record_version_number => p_record_version_number
2284: ,p_assignment_id => p_assignment_id
2285: ,p_assignment_type => p_assignment_type

Line 2324: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PUB.Cancel_Assignment'

2320:
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

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 2514: ( x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.mass_submit_for_assignment_approval.begin'

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;
2518:

Line 2568: (x_module => 'PA_ASSIGNMENT_APPROVAL_PUB.mass_submit_for_assignment_approval.check_prj_manager.'

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;
2572:

Line 2738: ( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PUB.mass_submit_for_asgmt_aprvl'

2734: END IF;
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;

Line 2784: l_assignment_status VARCHAR2(10) := PA_ASSIGNMENT_APPROVAL_PUB.g_submit_action;

2780: l_msg_index_out NUMBER;
2781: l_msg_count NUMBER;
2782: l_msg_data VARCHAR2(2000);
2783: l_data VARCHAR2(2000);
2784: l_assignment_status VARCHAR2(10) := PA_ASSIGNMENT_APPROVAL_PUB.g_submit_action;
2785: l_approver1_id_tbl SYSTEM.pa_num_tbl_type;
2786: l_approver1_name_tbl SYSTEM.pa_varchar2_240_tbl_type;
2787: l_approver2_id_tbl SYSTEM.pa_num_tbl_type;
2788: l_approver2_name_tbl SYSTEM.pa_varchar2_240_tbl_type;

Line 2818: WHERE ps.project_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_submitted;

2814:
2815: CURSOR l_stus_csr IS
2816: SELECT ps.enable_wf_flag
2817: FROM pa_project_statuses ps
2818: WHERE ps.project_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_submitted;
2819:
2820: l_stus_rec l_stus_csr%ROWTYPE;
2821:
2822: l_approvers_list_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;

Line 2837: AND asgn.apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_submitted

2833: FROM pa_wf_ntf_performers ntf,
2834: pa_project_assignments asgn
2835: WHERE ntf.group_id = l_group_id
2836: AND ntf.object_id1 = asgn.assignment_id
2837: AND asgn.apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_submitted
2838: AND ntf.routing_order = 1;
2839:
2840: l_customer_id NUMBER;
2841: l_customer_name VARCHAR2(2000);

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 2903: ( x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.mass_assignment_approval.begin'

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;
2907:

Line 3084: l_assignment_status := PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action;

3080: END IF;
3081:
3082: IF l_resource_super_user = 'Y' OR
3083: pa_resource_utils.check_user_has_res_auth (l_submitter_person_id, l_resource_id) = 'Y' THEN
3084: l_assignment_status := PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action;
3085: ELSE --submitter does not have resource authority
3086:
3087: ----------------------------------------------------------------------
3088: --If submitter has no resource authority and both approvers are null

Line 3100: l_assignment_status := PA_ASSIGNMENT_APPROVAL_PUB.g_submit_action;

3096: ,p_msg_name => l_error_message_code);
3097:
3098: RAISE PROCESS_ASSIGNMENT_EXCEPTION;
3099: ELSE
3100: l_assignment_status := PA_ASSIGNMENT_APPROVAL_PUB.g_submit_action;
3101: END IF;
3102: END IF;
3103:
3104: ELSIF l_approver1_id_tbl(i) = l_submitter_person_id THEN

Line 3107: l_assignment_status := PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action;

3103:
3104: ELSIF l_approver1_id_tbl(i) = l_submitter_person_id THEN
3105:
3106: IF l_approver2_id_tbl(i) is null THEN
3107: l_assignment_status := PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action;
3108: ELSIF l_approver2_id_tbl(i) = l_submitter_person_id THEN
3109: l_assignment_status := PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action;
3110: ELSE
3111: l_approver1_id_tbl(i) := l_approver2_id_tbl(i);

Line 3109: l_assignment_status := PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action;

3105:
3106: IF l_approver2_id_tbl(i) is null THEN
3107: l_assignment_status := PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action;
3108: ELSIF l_approver2_id_tbl(i) = l_submitter_person_id THEN
3109: l_assignment_status := PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action;
3110: ELSE
3111: l_approver1_id_tbl(i) := l_approver2_id_tbl(i);
3112: l_approver1_name_tbl(i) := l_approver2_name_tbl(i);
3113: l_approver2_id_tbl(i) := null;

Line 3115: l_assignment_status := PA_ASSIGNMENT_APPROVAL_PUB.g_submit_action;

3111: l_approver1_id_tbl(i) := l_approver2_id_tbl(i);
3112: l_approver1_name_tbl(i) := l_approver2_name_tbl(i);
3113: l_approver2_id_tbl(i) := null;
3114: l_approver2_name_tbl(i):= null;
3115: l_assignment_status := PA_ASSIGNMENT_APPROVAL_PUB.g_submit_action;
3116: END IF;
3117:
3118: ELSIF l_approver1_id_tbl(i) is null AND l_approver2_id_tbl(i) is null THEN
3119:

Line 3148: IF l_assignment_status = PA_ASSIGNMENT_APPROVAL_PUB.g_submit_action THEN

3144: --Validate approver only if l_assignment_status = g_submit_action
3145: --Validate Approver One and Approver Two has resource authority over the resource
3146: --for that assignment, otherwise raise an error.
3147: ---------------------------------------------------------------------------------
3148: IF l_assignment_status = PA_ASSIGNMENT_APPROVAL_PUB.g_submit_action THEN
3149:
3150:
3151:
3152: log_message('Checkin resource authority');

Line 3177: IF l_assignment_status = PA_ASSIGNMENT_APPROVAL_PUB.g_submit_action THEN

3173: ------------------------------------------------------------------
3174: --When l_assignment_status is not null implies that the assignment
3175: --can be processed for assignment approval
3176: ------------------------------------------------------------------
3177: IF l_assignment_status = PA_ASSIGNMENT_APPROVAL_PUB.g_submit_action THEN
3178:
3179: l_new_asgmt_flag := PA_ASSIGNMENT_APPROVAL_PVT.Is_New_Assignment( l_assignment_id_tbl(i) );
3180:
3181: IF l_new_asgmt_flag = 'N' THEN

Line 3190: l_assignment_status := PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action;

3186: ,x_aprvl_required
3187: ,l_return_status );
3188:
3189: IF x_aprvl_required = 'N' THEN
3190: l_assignment_status := PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action;
3191: END IF;
3192:
3193: END IF;
3194:

Line 3211: IF l_assignment_status = PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action THEN

3207: WHEN NO_DATA_FOUND THEN
3208: l_asgn_approval_status := null;
3209: END;
3210:
3211: IF l_assignment_status = PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action THEN
3212:
3213: log_message('Approve action for loop' || i);
3214:
3215: OPEN get_rec_num ( l_assignment_id_tbl(i) );

Line 3221: ,p_action_code => PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action

3217: CLOSE get_rec_num;
3218:
3219: PA_ASSIGNMENT_APPROVAL_PVT.Update_Approval_Status
3220: ( p_assignment_id => l_assignment_id_tbl(i)
3221: ,p_action_code => PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action
3222: ,p_note_to_approver => p_note_to_all_approvers
3223: ,p_record_version_number => p_record_version_number
3224: ,x_apprvl_status_code => l_apprvl_status_code
3225: ,x_change_id => l_change_id

Line 3310: ,p_action_code => PA_ASSIGNMENT_APPROVAL_PUB.g_submit_action

3306: log_message('Record version number: ' || p_record_version_number );
3307:
3308: PA_ASSIGNMENT_APPROVAL_PVT.Update_Approval_Status
3309: ( p_assignment_id => l_assignment_id_tbl(i)
3310: ,p_action_code => PA_ASSIGNMENT_APPROVAL_PUB.g_submit_action
3311: ,p_note_to_approver => p_note_to_all_approvers
3312: ,p_record_version_number => p_record_version_number
3313: ,x_apprvl_status_code => l_apprvl_status_code
3314: ,x_change_id => l_change_id

Line 3543: AND asgn.apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_approved ;

3539: pa_project_assignments asgn
3540: WHERE ntf.group_id = l_group_id
3541: AND ntf.routing_order = 1
3542: AND ntf.object_id1 = asgn.assignment_id
3543: AND asgn.apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_approved ;
3544:
3545: EXCEPTION
3546: WHEN NO_DATA_FOUND THEN
3547: null;

Line 3561: AND asgn.apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_rejected ;

3557: pa_project_assignments asgn
3558: WHERE ntf.group_id = l_group_id
3559: AND ntf.routing_order = 1
3560: AND ntf.object_id1 = asgn.assignment_id
3561: AND asgn.apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_rejected ;
3562:
3563: EXCEPTION
3564: WHEN NO_DATA_FOUND THEN
3565: null;

Line 3609: AND asgn.apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_approved ;

3605: pa_project_assignments asgn
3606: WHERE ntf.group_id = l_group_id
3607: AND ntf.routing_order = 1
3608: AND ntf.object_id1 = asgn.assignment_id
3609: AND asgn.apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_approved ;
3610:
3611: EXCEPTION
3612: WHEN NO_DATA_FOUND THEN
3613: null;

Line 3726: ( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PUB.mass_assignment_approval'

3722: END IF;
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;

Line 3740: ( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PUB.mass_assignment_approval'

3736: END IF;
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;

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 3811: ( x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.mass_process_approval_result.begin'

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;
3815:

Line 4029: ( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PUB.mass_process_approval_result'

4025: wf_engine.threshold := l_save_threshold;
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;

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 4084: ( x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.validate_approver_name_id.begin'

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;
4088:

Line 4303: ( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PUB.validate_approver_name_id'

4299: END IF;
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;

Line 4311: END PA_ASSIGNMENT_APPROVAL_PUB;

4307: RAISE;
4308: END validate_approver_name_id;
4309:
4310:
4311: END PA_ASSIGNMENT_APPROVAL_PUB;