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_DEBUG

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

5: --Organize the approvers in the table in sequential order.
6: --Validate that no duplicate order exists between the approvers.
7: --The pl/sql table should have at least one record.
8: --
9: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */
10:
11: PROCEDURE Validate_approver_orders (
12: x_return_status OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
13: IS

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 93: PA_DEBUG.Reset_err_stack; /* 3148857 */

89: END IF;-- end of check only one item in the table
90: END IF; --End of check table.
91:
92:
93: PA_DEBUG.Reset_err_stack; /* 3148857 */
94: --Assign out parameters
95: x_return_status := l_return_status;
96:
97:

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

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

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 171: PA_DEBUG.Reset_err_stack; /* 3148857 */

167: END IF;
168:
169: CLOSE get_assignment_id;
170:
171: PA_DEBUG.Reset_err_stack; /* 3148857 */
172:
173: RETURN l_new_assignment_flag;
174:
175: EXCEPTION

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

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:
183: END Is_New_Assignment;

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 227: PA_DEBUG.Reset_Err_Stack; /* 3148857 */

223: l_change_id := -1;
224: END IF;
225:
226: CLOSE get_change_id;
227: PA_DEBUG.Reset_Err_Stack; /* 3148857 */
228: RETURN l_change_id;
229:
230: EXCEPTION
231: WHEN OTHERS THEN

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

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

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 297: pa_debug.reset_err_stack; /* 3148857 */

293: END IF;
294:
295: END IF; -- end of checking new assignment flag
296:
297: pa_debug.reset_err_stack; /* 3148857 */
298:
299: x_approval_required_flag := l_approval_required_flag;
300:
301: EXCEPTION

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

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

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

539: END IF;
540:
541: -- Reset the error stack when returning to the calling program
542:
543: PA_DEBUG.Reset_Err_Stack;
544:
545: EXCEPTION
546: WHEN OTHERS THEN
547: -- Set the exception Message and the stack

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

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

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 585: PA_DEBUG.write_log (x_module => 'Get_Next_Status_After_Action.begin'

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'
586: ,x_msg => 'Beginning of Get_Next_Status_After_Action.'
587: ,x_log_level => 5);
588: END IF;
589:

Line 656: PA_DEBUG.write_log (x_module => 'Get_Next_Status_After_Action.get_wf_status_code'

652: ELSE
653:
654: --Log Message
655: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
656: PA_DEBUG.write_log (x_module => 'Get_Next_Status_After_Action.get_wf_status_code'
657: ,x_msg => 'Get success and failure status code'
658: ,x_log_level => 5);
659: END IF;
660: --

Line 686: pa_debug.reset_err_stack; /* 3148857 */

682: x_status_code := l_failure_status_code;
683: END IF;
684: END IF;
685: END IF; --end of checking p_action_code
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'

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

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
695: END Get_Next_Status_After_Action;

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 1073: PA_DEBUG.Reset_Err_Stack; /* 3148857 */

1069: END IF;
1070:
1071: x_change_id := l_change_id;
1072:
1073: PA_DEBUG.Reset_Err_Stack; /* 3148857 */
1074:
1075: EXCEPTION
1076: WHEN OTHERS THEN
1077: -- Set the exception Message and the stack

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

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

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 1151: PA_DEBUG.Reset_err_stack; /* 3148857 */

1147: PA_ASGMT_WFSTD.Maintain_wf_pending_flag (p_assignment_id => p_assignment_id
1148: ,p_mode => 'APPROVAL_PROCESS_COMPLETED');
1149: END IF;
1150:
1151: PA_DEBUG.Reset_err_stack; /* 3148857 */
1152:
1153: EXCEPTION
1154: WHEN OTHERS THEN
1155: -- Set the exception Message and the stack

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

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

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

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:
1192: END get_lookup_meaning;

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

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
1359: END get_asmt_and_asmt_history_rec;