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.12010000.5 2010/06/14 07:05:54 kkorrapo 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 2002: PA_ASSIGNMENT_APPROVAL_PUB.Start_Assignment_Approvals( p_assignment_id => p_assignment_id

1998:
1999: -- update the assignment approval status and send notification when the canceled assignment
2000: -- has ever been approved.
2001:
2002: PA_ASSIGNMENT_APPROVAL_PUB.Start_Assignment_Approvals( p_assignment_id => p_assignment_id
2003: ,p_new_assignment_flag => l_new_assignment_flag
2004: ,p_action_code =>PA_ASSIGNMENT_APPROVAL_PUB.g_cancel_action
2005: ,p_record_version_number => NULL
2006: ,p_validate_only => FND_API.G_FALSE

Line 2004: ,p_action_code =>PA_ASSIGNMENT_APPROVAL_PUB.g_cancel_action

2000: -- has ever been approved.
2001:
2002: PA_ASSIGNMENT_APPROVAL_PUB.Start_Assignment_Approvals( p_assignment_id => p_assignment_id
2003: ,p_new_assignment_flag => l_new_assignment_flag
2004: ,p_action_code =>PA_ASSIGNMENT_APPROVAL_PUB.g_cancel_action
2005: ,p_record_version_number => NULL
2006: ,p_validate_only => FND_API.G_FALSE
2007: ,x_overcommitment_flag => l_overcommitment_flag
2008: ,x_conflict_group_id => l_conflict_group_id

Line 2020: ,P_ACTION_CODE => PA_ASSIGNMENT_APPROVAL_PUB.g_cancel_action

2016:
2017: -- Update apprvl_status_code
2018: PA_ASSIGNMENT_APPROVAL_PVT.Update_Approval_Status(
2019: P_ASSIGNMENT_ID => p_assignment_id
2020: ,P_ACTION_CODE => PA_ASSIGNMENT_APPROVAL_PUB.g_cancel_action
2021: ,P_RECORD_VERSION_NUMBER => NULL
2022: ,X_APPRVL_STATUS_CODE => l_apprvl_status_code
2023: ,X_CHANGE_ID => l_change_id
2024: ,X_RECORD_VERSION_NUMBER => l_record_version_number

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

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

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

2191: ,x_log_level => 5);
2192: END IF;
2193:
2194: --Check to see if assignment is pending approval
2195: IF p_apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_submitted THEN
2196: -- Added for Bug# 8296021
2197: OPEN get_wf_progress_flag;
2198: FETCH get_wf_progress_flag INTO wf_progress_flag;
2199: CLOSE get_wf_progress_flag;

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

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

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

2338:
2339: IF l_assignment_status_code IS NOT NULL THEN
2340:
2341: --call Change_Assignment_Status
2342: PA_ASSIGNMENT_APPROVAL_PUB.Change_Assignment_Status
2343: (
2344: p_record_version_number => p_record_version_number
2345: ,p_assignment_id => p_assignment_id
2346: ,p_assignment_type => p_assignment_type

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

2381: END IF; --end of if loop for Bug#8240018
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

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

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

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

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

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

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

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

2841: l_msg_index_out NUMBER;
2842: l_msg_count NUMBER;
2843: l_msg_data VARCHAR2(2000);
2844: l_data VARCHAR2(2000);
2845: l_assignment_status VARCHAR2(10) := PA_ASSIGNMENT_APPROVAL_PUB.g_submit_action;
2846: l_approver1_id_tbl SYSTEM.pa_num_tbl_type;
2847: l_approver1_name_tbl SYSTEM.pa_varchar2_240_tbl_type;
2848: l_approver2_id_tbl SYSTEM.pa_num_tbl_type;
2849: l_approver2_name_tbl SYSTEM.pa_varchar2_240_tbl_type;

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

2875:
2876: CURSOR l_stus_csr IS
2877: SELECT ps.enable_wf_flag
2878: FROM pa_project_statuses ps
2879: WHERE ps.project_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_submitted;
2880:
2881: l_stus_rec l_stus_csr%ROWTYPE;
2882:
2883: l_approvers_list_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;

Line 2898: AND asgn.apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_submitted

2894: FROM pa_wf_ntf_performers ntf,
2895: pa_project_assignments asgn
2896: WHERE ntf.group_id = l_group_id
2897: AND ntf.object_id1 = asgn.assignment_id
2898: AND asgn.apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_submitted
2899: AND ntf.routing_order = 1;
2900:
2901: l_customer_id NUMBER;
2902: l_customer_name VARCHAR2(2000);

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

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

Line 3145: l_assignment_status := PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action;

3141: END IF;
3142:
3143: IF l_resource_super_user = 'Y' OR
3144: pa_resource_utils.check_user_has_res_auth (l_submitter_person_id, l_resource_id) = 'Y' THEN
3145: l_assignment_status := PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action;
3146: ELSE --submitter does not have resource authority
3147:
3148: ----------------------------------------------------------------------
3149: --If submitter has no resource authority and both approvers are null

Line 3161: l_assignment_status := PA_ASSIGNMENT_APPROVAL_PUB.g_submit_action;

3157: ,p_msg_name => l_error_message_code);
3158:
3159: RAISE PROCESS_ASSIGNMENT_EXCEPTION;
3160: ELSE
3161: l_assignment_status := PA_ASSIGNMENT_APPROVAL_PUB.g_submit_action;
3162: END IF;
3163: END IF;
3164:
3165: ELSIF l_approver1_id_tbl(i) = l_submitter_person_id THEN

Line 3168: l_assignment_status := PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action;

3164:
3165: ELSIF l_approver1_id_tbl(i) = l_submitter_person_id THEN
3166:
3167: IF l_approver2_id_tbl(i) is null THEN
3168: l_assignment_status := PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action;
3169: ELSIF l_approver2_id_tbl(i) = l_submitter_person_id THEN
3170: l_assignment_status := PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action;
3171: ELSE
3172: l_approver1_id_tbl(i) := l_approver2_id_tbl(i);

Line 3170: l_assignment_status := PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action;

3166:
3167: IF l_approver2_id_tbl(i) is null THEN
3168: l_assignment_status := PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action;
3169: ELSIF l_approver2_id_tbl(i) = l_submitter_person_id THEN
3170: l_assignment_status := PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action;
3171: ELSE
3172: l_approver1_id_tbl(i) := l_approver2_id_tbl(i);
3173: l_approver1_name_tbl(i) := l_approver2_name_tbl(i);
3174: l_approver2_id_tbl(i) := null;

Line 3176: l_assignment_status := PA_ASSIGNMENT_APPROVAL_PUB.g_submit_action;

3172: l_approver1_id_tbl(i) := l_approver2_id_tbl(i);
3173: l_approver1_name_tbl(i) := l_approver2_name_tbl(i);
3174: l_approver2_id_tbl(i) := null;
3175: l_approver2_name_tbl(i):= null;
3176: l_assignment_status := PA_ASSIGNMENT_APPROVAL_PUB.g_submit_action;
3177: END IF;
3178:
3179: ELSIF l_approver1_id_tbl(i) is null AND l_approver2_id_tbl(i) is null THEN
3180:

Line 3209: IF l_assignment_status = PA_ASSIGNMENT_APPROVAL_PUB.g_submit_action THEN

3205: --Validate approver only if l_assignment_status = g_submit_action
3206: --Validate Approver One and Approver Two has resource authority over the resource
3207: --for that assignment, otherwise raise an error.
3208: ---------------------------------------------------------------------------------
3209: IF l_assignment_status = PA_ASSIGNMENT_APPROVAL_PUB.g_submit_action THEN
3210:
3211:
3212:
3213: log_message('Checkin resource authority');

Line 3238: IF l_assignment_status = PA_ASSIGNMENT_APPROVAL_PUB.g_submit_action THEN

3234: ------------------------------------------------------------------
3235: --When l_assignment_status is not null implies that the assignment
3236: --can be processed for assignment approval
3237: ------------------------------------------------------------------
3238: IF l_assignment_status = PA_ASSIGNMENT_APPROVAL_PUB.g_submit_action THEN
3239:
3240: l_new_asgmt_flag := PA_ASSIGNMENT_APPROVAL_PVT.Is_New_Assignment( l_assignment_id_tbl(i) );
3241:
3242: IF l_new_asgmt_flag = 'N' THEN

Line 3251: l_assignment_status := PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action;

3247: ,x_aprvl_required
3248: ,l_return_status );
3249:
3250: IF x_aprvl_required = 'N' THEN
3251: l_assignment_status := PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action;
3252: END IF;
3253:
3254: END IF;
3255:

Line 3272: IF l_assignment_status = PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action THEN

3268: WHEN NO_DATA_FOUND THEN
3269: l_asgn_approval_status := null;
3270: END;
3271:
3272: IF l_assignment_status = PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action THEN
3273:
3274: log_message('Approve action for loop' || i);
3275:
3276: OPEN get_rec_num ( l_assignment_id_tbl(i) );

Line 3282: ,p_action_code => PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action

3278: CLOSE get_rec_num;
3279:
3280: PA_ASSIGNMENT_APPROVAL_PVT.Update_Approval_Status
3281: ( p_assignment_id => l_assignment_id_tbl(i)
3282: ,p_action_code => PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action
3283: ,p_note_to_approver => p_note_to_all_approvers
3284: ,p_record_version_number => p_record_version_number
3285: ,x_apprvl_status_code => l_apprvl_status_code
3286: ,x_change_id => l_change_id

Line 3371: ,p_action_code => PA_ASSIGNMENT_APPROVAL_PUB.g_submit_action

3367: log_message('Record version number: ' || p_record_version_number );
3368:
3369: PA_ASSIGNMENT_APPROVAL_PVT.Update_Approval_Status
3370: ( p_assignment_id => l_assignment_id_tbl(i)
3371: ,p_action_code => PA_ASSIGNMENT_APPROVAL_PUB.g_submit_action
3372: ,p_note_to_approver => p_note_to_all_approvers
3373: ,p_record_version_number => p_record_version_number
3374: ,x_apprvl_status_code => l_apprvl_status_code
3375: ,x_change_id => l_change_id

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

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

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

3622: pa_project_assignments asgn
3623: WHERE ntf.group_id = l_group_id
3624: AND ntf.routing_order = 1
3625: AND ntf.object_id1 = asgn.assignment_id
3626: AND asgn.apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_rejected ;
3627:
3628: EXCEPTION
3629: WHEN NO_DATA_FOUND THEN
3630: null;

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

3670: pa_project_assignments asgn
3671: WHERE ntf.group_id = l_group_id
3672: AND ntf.routing_order = 1
3673: AND ntf.object_id1 = asgn.assignment_id
3674: AND asgn.apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_approved ;
3675:
3676: EXCEPTION
3677: WHEN NO_DATA_FOUND THEN
3678: null;

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

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

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

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

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

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

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

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

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

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

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

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

Line 4376: END PA_ASSIGNMENT_APPROVAL_PUB;

4372: RAISE;
4373: END validate_approver_name_id;
4374:
4375:
4376: END PA_ASSIGNMENT_APPROVAL_PUB;