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_PVT dependencies on PA_ASSIGNMENT_APPROVAL_PVT

Line 1: PACKAGE BODY PA_ASSIGNMENT_APPROVAL_PVT AS

1: PACKAGE BODY PA_ASSIGNMENT_APPROVAL_PVT AS
2: /*$Header: PARAAPVB.pls 120.1.12000000.2 2007/11/23 12:39:09 kjai ship $*/
3:
4: --
5: --Organize the approvers in the table in sequential order.

Line 22: PA_DEBUG.set_err_stack('PA_ASSIGNMENT_APPROVAL_PVT.Validate_approver_orders');

18: l_first BINARY_INTEGER;
19: l_before_last BINARY_INTEGER;
20: BEGIN
21: -- Initialize the Error Stack
22: PA_DEBUG.set_err_stack('PA_ASSIGNMENT_APPROVAL_PVT.Validate_approver_orders');
23:
24: --Log Message
25: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
26: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PVT.Validate_approver_orders.begin'

Line 26: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PVT.Validate_approver_orders.begin'

22: PA_DEBUG.set_err_stack('PA_ASSIGNMENT_APPROVAL_PVT.Validate_approver_orders');
23:
24: --Log Message
25: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
26: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PVT.Validate_approver_orders.begin'
27: ,x_msg => 'Beginning of Validate_approver_orders'
28: ,x_log_level => 5);
29: END IF;
30: -- Initialize

Line 45: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PVT.Validate_approver_orders.bubble_sort'

41: ELSE
42:
43: --Log Message
44: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
45: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PVT.Validate_approver_orders.bubble_sort'
46: ,x_msg => 'Starting bubble sort.'
47: ,x_log_level => 5);
48: END IF;
49:

Line 75: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PVT.Validate_approver_orders.check_duplicate'

71: END LOOP;
72:
73: --Log Message
74: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
75: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PVT.Validate_approver_orders.check_duplicate'
76: ,x_msg => 'Checking duplicate orders.'
77: ,x_log_level => 5);
78: END IF;
79: --Check if any duplicate orders exist.

Line 101: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PVT.Validate_approver_orders'

97:
98: EXCEPTION
99: WHEN OTHERS THEN
100: -- Set the excetption Message and the stack
101: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PVT.Validate_approver_orders'
102: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
103: --
104: RAISE; -- This is optional depending on the needs
105: END Validate_approver_orders;

Line 150: PA_DEBUG.set_err_stack('PA_ASSIGNMENT_APPROVAL_PVT.Is_New_Assignment');

146: AND ppa.apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_approved;
147:
148: BEGIN
149: -- Initialize the Error Stack
150: PA_DEBUG.set_err_stack('PA_ASSIGNMENT_APPROVAL_PVT.Is_New_Assignment');
151:
152: --Log Message
153: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
154: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PVT.Is_New_Assignment.begin'

Line 154: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PVT.Is_New_Assignment.begin'

150: PA_DEBUG.set_err_stack('PA_ASSIGNMENT_APPROVAL_PVT.Is_New_Assignment');
151:
152: --Log Message
153: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
154: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PVT.Is_New_Assignment.begin'
155: ,x_msg => 'Beginning of Is_New_Assignment'
156: ,x_log_level => 5);
157: END IF;
158:

Line 178: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PVT.Is_New_Assignment'

174:
175: EXCEPTION
176: WHEN OTHERS THEN
177: -- Set the excetption Message and the stack
178: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PVT.Is_New_Assignment'
179: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
180: --
181: RAISE; -- This is optional depending on the needs
182:

Line 210: PA_DEBUG.set_err_stack('PA_ASSIGNMENT_APPROVAL_PVT.Get_Change_Id');

206: BEGIN
207:
208:
209: -- Initialize the Error Stack
210: PA_DEBUG.set_err_stack('PA_ASSIGNMENT_APPROVAL_PVT.Get_Change_Id');
211:
212: --Log Message
213: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
214: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PVT.Get_Change_Id.begin'

Line 214: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PVT.Get_Change_Id.begin'

210: PA_DEBUG.set_err_stack('PA_ASSIGNMENT_APPROVAL_PVT.Get_Change_Id');
211:
212: --Log Message
213: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
214: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PVT.Get_Change_Id.begin'
215: ,x_msg => 'Beginning of Get_Change_Id'
216: ,x_log_level => 5);
217: END IF;
218: OPEN get_change_id;

Line 233: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PVT.Get_Change_Id'

229:
230: EXCEPTION
231: WHEN OTHERS THEN
232: -- Set the excetption Message and the stack
233: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PVT.Get_Change_Id'
234: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
235: --
236: RAISE; -- This is optional depending on the needs
237:

Line 259: PA_DEBUG.set_err_stack('PA_ASSIGNMENT_APPROVAL_PVT.Check_Approval_Required');

255: l_approval_required_flag VARCHAR2(1);
256:
257: BEGIN
258: -- Initialize the Error Stack
259: PA_DEBUG.set_err_stack('PA_ASSIGNMENT_APPROVAL_PVT.Check_Approval_Required');
260:
261: --Log Message
262: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
263: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PVT.Check_Approval_Required.begin'

Line 263: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PVT.Check_Approval_Required.begin'

259: PA_DEBUG.set_err_stack('PA_ASSIGNMENT_APPROVAL_PVT.Check_Approval_Required');
260:
261: --Log Message
262: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
263: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PVT.Check_Approval_Required.begin'
264: ,x_msg => 'Beginning of Check_Approval_Required'
265: ,x_log_level => 5);
266: END IF;
267:

Line 285: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PVT.Check_Approval_Required.items_changed'

281:
282: ELSE
283: --Log Message
284: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
285: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PVT.Check_Approval_Required.items_changed'
286: ,x_msg => 'Checking if Assignment Approval Items are changed.'
287: ,x_log_level => 5);
288: END IF;
289:

Line 304: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PVT.Check_Approval_Required'

300:
301: EXCEPTION
302: WHEN OTHERS THEN
303: -- Set the excetption Message and the stack
304: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PVT.Check_Approval_Required'
305: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
307: --
308: RAISE; -- This is optional depending on the needs

Line 354: PA_DEBUG.set_err_stack('PA_ASSIGNMENT_APPROVAL_PVT.Update_Approval_Status');

350:
351: BEGIN
352:
353: -- Initialize the Error Stack
354: PA_DEBUG.set_err_stack('PA_ASSIGNMENT_APPROVAL_PVT.Update_Approval_Status');
355:
356: --Log Message
357: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
358: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PVT.Update_Approval_Status.begin'

Line 358: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PVT.Update_Approval_Status.begin'

354: PA_DEBUG.set_err_stack('PA_ASSIGNMENT_APPROVAL_PVT.Update_Approval_Status');
355:
356: --Log Message
357: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
358: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PVT.Update_Approval_Status.begin'
359: ,x_msg => 'Beginning of Update_Approval_Status.'
360: ,x_log_level => 5);
361: END IF;
362:

Line 385: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PVT.Update_Approval_Status.insert_history'

381: AND p_action_code =PA_ASSIGNMENT_APPROVAL_PUB.g_update_action THEN
382:
383: --Log Message
384: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
385: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PVT.Update_Approval_Status.insert_history'
386: ,x_msg => 'Inserting record into assignment history table.'
387: ,x_log_level => 5);
388: END IF;
389:

Line 390: PA_ASSIGNMENT_APPROVAL_PVT.Insert_Into_Assignment_History ( p_assignment_id => p_assignment_id

386: ,x_msg => 'Inserting record into assignment history table.'
387: ,x_log_level => 5);
388: END IF;
389:
390: PA_ASSIGNMENT_APPROVAL_PVT.Insert_Into_Assignment_History ( p_assignment_id => p_assignment_id
391: ,x_change_id => x_change_id
392: ,x_return_status => l_return_status);
393: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
394: x_return_status := l_return_status;

Line 400: x_change_id:=PA_ASSIGNMENT_APPROVAL_PVT.get_change_id(p_assignment_id);

396: l_return_status := FND_API.G_MISS_CHAR;
397:
398: /* Changed bug 1635170*/
399: ELSE
400: x_change_id:=PA_ASSIGNMENT_APPROVAL_PVT.get_change_id(p_assignment_id);
401: END IF;
402: /* End bug 1635170*/
403:
404: --Log Message

Line 406: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PVT.Update_Approval_Status.get_next_stus'

402: /* End bug 1635170*/
403:
404: --Log Message
405: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
406: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PVT.Update_Approval_Status.get_next_stus'
407: ,x_msg => 'Get next assignment approval status.'
408: ,x_log_level => 5);
409: END IF;
410:

Line 412: PA_ASSIGNMENT_APPROVAL_PVT.Get_Next_Status_After_Action ( p_action_code => p_action_code

408: ,x_log_level => 5);
409: END IF;
410:
411: -- Get the status code after action performed.
412: PA_ASSIGNMENT_APPROVAL_PVT.Get_Next_Status_After_Action ( p_action_code => p_action_code
413: ,p_status_code => l_apprvl_status_code
414: ,x_status_code => x_apprvl_status_code
415: ,x_return_status => l_return_status);
416: --dbms_output.put_line('next status:'|| x_apprvl_status_code);

Line 452: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PVT.Update_Approval_Status.schedule_success'

448: IF p_action_code = PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action THEN
449: --call schedule's success method
450: --Log Message
451: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
452: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PVT.Update_Approval_Status.schedule_success'
453: ,x_msg => 'Calling schedule success method.'
454: ,x_log_level => 5);
455: END IF;
456:

Line 470: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PVT.Update_Approval_Status.schedule_failure'

466: ELSIF p_action_code = PA_ASSIGNMENT_APPROVAL_PUB.g_reject_action THEN
467: --call schedule's failure method
468: --Log Message
469: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
470: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PVT.Update_Approval_Status.schedule_failure'
471: ,x_msg => 'Calling schedule failure method.'
472: ,x_log_level => 5);
473: END IF;
474:

Line 500: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PVT.Update_Approval_Status.update_status'

496: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
497:
498: --Log Message
499: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
500: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PVT.Update_Approval_Status.update_status'
501: ,x_msg => 'update current approval status.'
502: ,x_log_level => 5);
503: END IF;
504:

Line 548: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PVT.Update_Approval_Status'

544:
545: EXCEPTION
546: WHEN OTHERS THEN
547: -- Set the exception Message and the stack
548: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PVT.Update_Approval_Status'
549: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
551:
552: RAISE; -- This is optional depending on the needs

Line 581: PA_DEBUG.set_err_stack('PA_ASSIGNMENT_APPROVAL_PVT.Get_Next_Status_After_Action');

577:
578: BEGIN
579:
580: -- Initialize the Error Stack
581: PA_DEBUG.set_err_stack('PA_ASSIGNMENT_APPROVAL_PVT.Get_Next_Status_After_Action');
582:
583: --Log Message
584: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
585: PA_DEBUG.write_log (x_module => 'Get_Next_Status_After_Action.begin'

Line 690: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PVT.Get_Next_Status_After_Action'

686: pa_debug.reset_err_stack; /* 3148857 */
687: EXCEPTION
688: WHEN OTHERS THEN
689: -- Set the exception Message and the stack
690: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PVT.Get_Next_Status_After_Action'
691: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
693:
694: RAISE; -- This is optional depending on the needs

Line 727: PA_DEBUG.set_err_stack('PA_ASSIGNMENT_APPROVAL_PVT.Insert_Into_Assignment_History');

723: AND primary_subteam_flag = 'Y';
724:
725: BEGIN
726: -- Initialize the Error Stack
727: PA_DEBUG.set_err_stack('PA_ASSIGNMENT_APPROVAL_PVT.Insert_Into_Assignment_History');
728:
729: --Log Message
730: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
731: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PVT.Insert_Into_Assignment_History.begin'

Line 731: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PVT.Insert_Into_Assignment_History.begin'

727: PA_DEBUG.set_err_stack('PA_ASSIGNMENT_APPROVAL_PVT.Insert_Into_Assignment_History');
728:
729: --Log Message
730: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
731: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PVT.Insert_Into_Assignment_History.begin'
732: ,x_msg => 'Beginning of Insert_Into_Assignment_History'
733: ,x_log_level => 5);
734: END IF;
735:

Line 924: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PVT.Insert_Into_Assignment_History.last_approved_flag'

920: END IF;
921: CLOSE get_project_subteam_id;
922:
923: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
924: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PVT.Insert_Into_Assignment_History.last_approved_flag'
925: ,x_msg => 'update previously last approved record flag to N'
926: ,x_log_level => 5);
927: END IF;
928: --

Line 947: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PVT.Insert_Into_Assignment_History.insert_row'

943: --If no errors, insert the approved assignment record into the history table.
944: IF (FND_MSG_PUB.Count_Msg = 0) THEN
945: --Log Message
946: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
947: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PVT.Insert_Into_Assignment_History.insert_row'
948: ,x_msg => 'insert last approved record into assignment history table.'
949: ,x_log_level => 5);
950: END IF;
951:

Line 1053: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PVT.Insert_Into_Assignment_History.schedule_history'

1049:
1050:
1051: IF (FND_MSG_PUB.Count_Msg = 0) THEN
1052: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1053: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PVT.Insert_Into_Assignment_History.schedule_history'
1054: ,x_msg => 'Updating Schedule history table.'
1055: ,x_log_level => 5);
1056: END IF;
1057:

Line 1078: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PVT.Insert_Into_Assignment_History'

1074:
1075: EXCEPTION
1076: WHEN OTHERS THEN
1077: -- Set the exception Message and the stack
1078: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PVT.Insert_Into_Assignment_History'
1079: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1080: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1081:
1082: RAISE; -- This is optional depending on the needs

Line 1117: PA_DEBUG.set_err_stack('PA_ASSIGNMENT_APPROVAL_PVT.Insert_Into_Assignment_History');

1113:
1114: BEGIN
1115:
1116: -- Initialize the Error Stack
1117: PA_DEBUG.set_err_stack('PA_ASSIGNMENT_APPROVAL_PVT.Insert_Into_Assignment_History');
1118:
1119: --Log Message
1120: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1121: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PVT.Abort_Assignment_Approval.begin'

Line 1121: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PVT.Abort_Assignment_Approval.begin'

1117: PA_DEBUG.set_err_stack('PA_ASSIGNMENT_APPROVAL_PVT.Insert_Into_Assignment_History');
1118:
1119: --Log Message
1120: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1121: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PVT.Abort_Assignment_Approval.begin'
1122: ,x_msg => 'Beginning of Abort_Assignment_Approval'
1123: ,x_log_level => 5);
1124: END IF;
1125:

Line 1156: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PVT.Abort_Assignment_Approval'

1152:
1153: EXCEPTION
1154: WHEN OTHERS THEN
1155: -- Set the exception Message and the stack
1156: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PVT.Abort_Assignment_Approval'
1157: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1159:
1160: RAISE; -- This is optional depending on the needs

Line 1187: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning'

1183: WHEN NO_DATA_FOUND THEN
1184: return null;
1185: WHEN OTHERS THEN
1186: -- Set the exception Message and the stack
1187: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning'
1188: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1189:
1190: RAISE; -- This is optional depending on the needs
1191:

Line 1354: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PVT.get_asmt_and_asmt_history_rec'

1350:
1351: EXCEPTION
1352: WHEN OTHERS THEN
1353: -- Set the exception Message and the stack
1354: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PVT.get_asmt_and_asmt_history_rec'
1355: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1357:
1358: RAISE; -- This is optional depending on the needs

Line 1361: END PA_ASSIGNMENT_APPROVAL_PVT ;

1357:
1358: RAISE; -- This is optional depending on the needs
1359: END get_asmt_and_asmt_history_rec;
1360:
1361: END PA_ASSIGNMENT_APPROVAL_PVT ;