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.AHL_UC_ACL_WF_APPR_PVT dependencies on AHL_DEBUG_PUB

Line 5: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;

1: PACKAGE BODY AHL_UC_ACL_WF_APPR_PVT AS
2: /* $Header: AHLVQWFB.pls 120.0 2005/06/29 08:52 sagarwal noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_UC_ACL_WF_APPR_PVT';
5: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
6:
7: CURSOR get_uc_header_det(c_uc_header_id in number)
8: IS
9: SELECT unit_config_header_id

Line 48: AHL_DEBUG_PUB.ENABLE_DEBUG;

44: l_uc_header_rec get_uc_header_det%rowtype;
45: BEGIN
46:
47: IF G_DEBUG='Y' THEN
48: AHL_DEBUG_PUB.ENABLE_DEBUG;
49: AHL_DEBUG_PUB.debug( 'UC-ACL:Start Set Actvity Details');
50: END IF;
51:
52: --Initiliaze message list

Line 49: AHL_DEBUG_PUB.debug( 'UC-ACL:Start Set Actvity Details');

45: BEGIN
46:
47: IF G_DEBUG='Y' THEN
48: AHL_DEBUG_PUB.ENABLE_DEBUG;
49: AHL_DEBUG_PUB.debug( 'UC-ACL:Start Set Actvity Details');
50: END IF;
51:
52: --Initiliaze message list
53: fnd_msg_pub.initialize;

Line 67: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS --> l_object_id = '||l_object_id);

63: aname => 'OBJECT_VER');
64:
65:
66: IF G_DEBUG='Y' THEN
67: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS --> l_object_id = '||l_object_id);
68: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS --> l_object_version_number = '||l_object_version_number);
69: END IF;
70:
71: l_object_details.operating_unit_id := NULL;

Line 68: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS --> l_object_version_number = '||l_object_version_number);

64:
65:
66: IF G_DEBUG='Y' THEN
67: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS --> l_object_id = '||l_object_id);
68: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS --> l_object_version_number = '||l_object_version_number);
69: END IF;
70:
71: l_object_details.operating_unit_id := NULL;
72: l_object_details.priority := NULL;

Line 103: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS -- FORWARD_SUBJECT='||l_subject);

99: ,avalue => l_subject
100: );
101:
102: IF G_DEBUG='Y' THEN
103: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS -- FORWARD_SUBJECT='||l_subject);
104: END IF;
105: --
106:
107: --

Line 122: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS -- APPROVAL_SUBJECT='||l_subject);

118: ,avalue => l_subject
119: );
120:
121: IF G_DEBUG='Y' THEN
122: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS -- APPROVAL_SUBJECT='||l_subject);
123: END IF;
124: --
125:
126: --

Line 141: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS -- REJECT_SUBJECT='||l_subject);

137: ,avalue => l_subject
138: );
139:
140: IF G_DEBUG='Y' THEN
141: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS -- REJECT_SUBJECT='||l_subject);
142: END IF;
143: --
144:
145: --

Line 159: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS -- APPROVED_SUBJECT='||l_subject);

155: ,aname => 'APPROVED_SUBJECT'
156: ,avalue => l_subject
157: );
158: IF G_DEBUG='Y' THEN
159: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS -- APPROVED_SUBJECT='||l_subject);
160: END IF;
161: --
162:
163: --

Line 177: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS -- FINAL_SUBJECT='||l_subject);

173: ,aname => 'FINAL_SUBJECT'
174: ,avalue => l_subject
175: );
176: IF G_DEBUG='Y' THEN
177: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS -- FINAL_SUBJECT='||l_subject);
178: END IF;
179: --
180:
181: --

Line 195: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS -- REMIND_SUBJECT='||l_subject);

191: ,aname => 'REMIND_SUBJECT'
192: ,avalue => l_subject
193: );
194: IF G_DEBUG='Y' THEN
195: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS -- REMIND_SUBJECT='||l_subject);
196: END IF;
197: --
198:
199: --

Line 213: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS -- ERROR_SUBJECT='||l_subject);

209: ,aname => 'ERROR_SUBJECT'
210: ,avalue => l_subject
211: );
212: IF G_DEBUG='Y' THEN
213: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS -- ERROR_SUBJECT='||l_subject);
214: END IF;
215:
216: IF G_DEBUG='Y' THEN
217: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS -- l_object='||l_object);

Line 217: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS -- l_object='||l_object);

213: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS -- ERROR_SUBJECT='||l_subject);
214: END IF;
215:
216: IF G_DEBUG='Y' THEN
217: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS -- l_object='||l_object);
218: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS -- l_approval_type='||l_approval_type);
219: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS -- l_object_details.priority='||l_object_details.priority);
220: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS -- l_object_details.operating_unit_id='||l_object_details.operating_unit_id);
221: END IF;

Line 218: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS -- l_approval_type='||l_approval_type);

214: END IF;
215:
216: IF G_DEBUG='Y' THEN
217: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS -- l_object='||l_object);
218: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS -- l_approval_type='||l_approval_type);
219: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS -- l_object_details.priority='||l_object_details.priority);
220: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS -- l_object_details.operating_unit_id='||l_object_details.operating_unit_id);
221: END IF;
222:

Line 219: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS -- l_object_details.priority='||l_object_details.priority);

215:
216: IF G_DEBUG='Y' THEN
217: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS -- l_object='||l_object);
218: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS -- l_approval_type='||l_approval_type);
219: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS -- l_object_details.priority='||l_object_details.priority);
220: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS -- l_object_details.operating_unit_id='||l_object_details.operating_unit_id);
221: END IF;
222:
223: AHL_GENERIC_APRV_PVT.GET_APPROVAL_DETAILS

Line 220: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS -- l_object_details.operating_unit_id='||l_object_details.operating_unit_id);

216: IF G_DEBUG='Y' THEN
217: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS -- l_object='||l_object);
218: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS -- l_approval_type='||l_approval_type);
219: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS -- l_object_details.priority='||l_object_details.priority);
220: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS -- l_object_details.operating_unit_id='||l_object_details.operating_unit_id);
221: END IF;
222:
223: AHL_GENERIC_APRV_PVT.GET_APPROVAL_DETAILS
224: (

Line 234: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS -- l_approval_rule_id='||l_approval_rule_id);

230: x_return_status => l_return_status
231: );
232:
233: IF G_DEBUG='Y' THEN
234: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS -- l_approval_rule_id='||l_approval_rule_id);
235: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS -- l_approver_seq='||l_approver_seq);
236: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS -- l_return_status='||l_return_status);
237: END IF;
238:

Line 235: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS -- l_approver_seq='||l_approver_seq);

231: );
232:
233: IF G_DEBUG='Y' THEN
234: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS -- l_approval_rule_id='||l_approval_rule_id);
235: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS -- l_approver_seq='||l_approver_seq);
236: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS -- l_return_status='||l_return_status);
237: END IF;
238:
239: IF l_return_status = FND_API.g_ret_sts_success THEN

Line 236: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS -- l_return_status='||l_return_status);

232:
233: IF G_DEBUG='Y' THEN
234: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS -- l_approval_rule_id='||l_approval_rule_id);
235: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS -- l_approver_seq='||l_approver_seq);
236: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS -- l_return_status='||l_return_status);
237: END IF;
238:
239: IF l_return_status = FND_API.g_ret_sts_success THEN
240:

Line 249: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS -- RULE_ID='||l_approval_rule_id);

245: aname => 'RULE_ID',
246: avalue => l_approval_rule_id
247: );
248: IF G_DEBUG='Y' THEN
249: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS -- RULE_ID='||l_approval_rule_id);
250: END IF;
251:
252: wf_engine.setitemattrnumber
253: (

Line 260: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS -- APPROVER_SEQ='||l_approver_seq);

256: aname => 'APPROVER_SEQ',
257: avalue => l_approver_seq
258: );
259: IF G_DEBUG='Y' THEN
260: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS -- APPROVER_SEQ='||l_approver_seq);
261: AHL_DEBUG_PUB.debug('UC-ACL:End Set Actvity Details');
262: AHL_DEBUG_PUB.disable_debug;
263: END IF;
264:

Line 261: AHL_DEBUG_PUB.debug('UC-ACL:End Set Actvity Details');

257: avalue => l_approver_seq
258: );
259: IF G_DEBUG='Y' THEN
260: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS -- APPROVER_SEQ='||l_approver_seq);
261: AHL_DEBUG_PUB.debug('UC-ACL:End Set Actvity Details');
262: AHL_DEBUG_PUB.disable_debug;
263: END IF;
264:
265: resultout := 'COMPLETE:SUCCESS';

Line 262: AHL_DEBUG_PUB.disable_debug;

258: );
259: IF G_DEBUG='Y' THEN
260: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS -- APPROVER_SEQ='||l_approver_seq);
261: AHL_DEBUG_PUB.debug('UC-ACL:End Set Actvity Details');
262: AHL_DEBUG_PUB.disable_debug;
263: END IF;
264:
265: resultout := 'COMPLETE:SUCCESS';
266: RETURN;

Line 279: AHL_DEBUG_PUB.disable_debug;

275: --
276: IF (funcmode = 'CANCEL') THEN
277: resultout := 'COMPLETE:';
278: IF G_DEBUG='Y' THEN
279: AHL_DEBUG_PUB.disable_debug;
280: END IF;
281: RETURN;
282: END IF;
283:

Line 290: AHL_DEBUG_PUB.disable_debug;

286: --
287: IF (funcmode = 'TIMEOUT') THEN
288: resultout := 'COMPLETE:';
289: IF G_DEBUG='Y' THEN
290: AHL_DEBUG_PUB.disable_debug;
291: END IF;
292: RETURN;
293: END IF;
294:

Line 367: AHL_DEBUG_PUB.ENABLE_DEBUG;

363:
364: BEGIN
365:
366: IF G_DEBUG='Y' THEN
367: AHL_DEBUG_PUB.ENABLE_DEBUG;
368: AHL_DEBUG_PUB.debug( 'UC-ACL:Start Notify Forward');
369: END IF;
370:
371: document_type := 'text/plain';

Line 368: AHL_DEBUG_PUB.debug( 'UC-ACL:Start Notify Forward');

364: BEGIN
365:
366: IF G_DEBUG='Y' THEN
367: AHL_DEBUG_PUB.ENABLE_DEBUG;
368: AHL_DEBUG_PUB.debug( 'UC-ACL:Start Notify Forward');
369: END IF;
370:
371: document_type := 'text/plain';
372:

Line 403: AHL_DEBUG_PUB.debug('UC-ACL: NTF_FORWARD_FYI -- l_approver='||l_approver);

399: ,aname => 'APPROVER'
400: );
401:
402: IF G_DEBUG='Y' THEN
403: AHL_DEBUG_PUB.debug('UC-ACL: NTF_FORWARD_FYI -- l_approver='||l_approver);
404: END IF;
405:
406: OPEN get_uc_header_det(l_object_id);
407: FETCH get_uc_header_det into l_uc_header_rec;

Line 425: AHL_DEBUG_PUB.debug('UC-ACL: NTF_FORWARD_FYI -- document='||document);

421:
422: document := document || l_body;
423:
424: IF G_DEBUG='Y' THEN
425: AHL_DEBUG_PUB.debug('UC-ACL: NTF_FORWARD_FYI -- document='||document);
426: AHL_DEBUG_PUB.debug( 'UC-ACL:END Notify Forward, l_object_id =' || l_object_id );
427: AHL_DEBUG_PUB.DISABLE_DEBUG;
428: END IF;
429:

Line 426: AHL_DEBUG_PUB.debug( 'UC-ACL:END Notify Forward, l_object_id =' || l_object_id );

422: document := document || l_body;
423:
424: IF G_DEBUG='Y' THEN
425: AHL_DEBUG_PUB.debug('UC-ACL: NTF_FORWARD_FYI -- document='||document);
426: AHL_DEBUG_PUB.debug( 'UC-ACL:END Notify Forward, l_object_id =' || l_object_id );
427: AHL_DEBUG_PUB.DISABLE_DEBUG;
428: END IF;
429:
430: COMMIT;

Line 427: AHL_DEBUG_PUB.DISABLE_DEBUG;

423:
424: IF G_DEBUG='Y' THEN
425: AHL_DEBUG_PUB.debug('UC-ACL: NTF_FORWARD_FYI -- document='||document);
426: AHL_DEBUG_PUB.debug( 'UC-ACL:END Notify Forward, l_object_id =' || l_object_id );
427: AHL_DEBUG_PUB.DISABLE_DEBUG;
428: END IF;
429:
430: COMMIT;
431: RETURN;

Line 501: AHL_DEBUG_PUB.ENABLE_DEBUG;

497:
498: BEGIN
499:
500: IF G_DEBUG='Y' THEN
501: AHL_DEBUG_PUB.ENABLE_DEBUG;
502: AHL_DEBUG_PUB.debug( 'UC-ACL:Start Notify Approved FYI');
503: END IF;
504:
505: document_type := 'text/plain';

Line 502: AHL_DEBUG_PUB.debug( 'UC-ACL:Start Notify Approved FYI');

498: BEGIN
499:
500: IF G_DEBUG='Y' THEN
501: AHL_DEBUG_PUB.ENABLE_DEBUG;
502: AHL_DEBUG_PUB.debug( 'UC-ACL:Start Notify Approved FYI');
503: END IF;
504:
505: document_type := 'text/plain';
506:

Line 537: AHL_DEBUG_PUB.debug('UC-ACL: NTF_APPROVED_FYI -- l_approver='||l_approver);

533: ,aname => 'APPROVER'
534: );
535:
536: IF G_DEBUG='Y' THEN
537: AHL_DEBUG_PUB.debug('UC-ACL: NTF_APPROVED_FYI -- l_approver='||l_approver);
538: END IF;
539:
540: OPEN get_uc_header_det(l_object_id);
541: FETCH get_uc_header_det into l_uc_header_rec;

Line 560: AHL_DEBUG_PUB.debug('UC-ACL: NTF_APPROVED_FYI -- document='||document);

556:
557: document := document || l_body;
558:
559: IF G_DEBUG='Y' THEN
560: AHL_DEBUG_PUB.debug('UC-ACL: NTF_APPROVED_FYI -- document='||document);
561: AHL_DEBUG_PUB.debug( 'UC-ACL:END Notify Approved FYI, l_object_id =' || l_object_id );
562: AHL_DEBUG_PUB.DISABLE_DEBUG;
563: END IF;
564:

Line 561: AHL_DEBUG_PUB.debug( 'UC-ACL:END Notify Approved FYI, l_object_id =' || l_object_id );

557: document := document || l_body;
558:
559: IF G_DEBUG='Y' THEN
560: AHL_DEBUG_PUB.debug('UC-ACL: NTF_APPROVED_FYI -- document='||document);
561: AHL_DEBUG_PUB.debug( 'UC-ACL:END Notify Approved FYI, l_object_id =' || l_object_id );
562: AHL_DEBUG_PUB.DISABLE_DEBUG;
563: END IF;
564:
565: RETURN;

Line 562: AHL_DEBUG_PUB.DISABLE_DEBUG;

558:
559: IF G_DEBUG='Y' THEN
560: AHL_DEBUG_PUB.debug('UC-ACL: NTF_APPROVED_FYI -- document='||document);
561: AHL_DEBUG_PUB.debug( 'UC-ACL:END Notify Approved FYI, l_object_id =' || l_object_id );
562: AHL_DEBUG_PUB.DISABLE_DEBUG;
563: END IF;
564:
565: RETURN;
566:

Line 633: AHL_DEBUG_PUB.ENABLE_DEBUG;

629:
630: BEGIN
631:
632: IF G_DEBUG='Y' THEN
633: AHL_DEBUG_PUB.ENABLE_DEBUG;
634: AHL_DEBUG_PUB.debug( 'Start NTF Final approval');
635: END IF;
636:
637: document_type := 'text/plain';

Line 634: AHL_DEBUG_PUB.debug( 'Start NTF Final approval');

630: BEGIN
631:
632: IF G_DEBUG='Y' THEN
633: AHL_DEBUG_PUB.ENABLE_DEBUG;
634: AHL_DEBUG_PUB.debug( 'Start NTF Final approval');
635: END IF;
636:
637: document_type := 'text/plain';
638:

Line 669: AHL_DEBUG_PUB.debug('UC-ACL: NTF_FINAL_APPROVAL_FYI -- l_approver='||l_approver);

665: ,aname => 'APPROVER'
666: );
667:
668: IF G_DEBUG='Y' THEN
669: AHL_DEBUG_PUB.debug('UC-ACL: NTF_FINAL_APPROVAL_FYI -- l_approver='||l_approver);
670: END IF;
671:
672: OPEN get_uc_header_det(l_object_id);
673: FETCH get_uc_header_det into l_uc_header_rec;

Line 690: AHL_DEBUG_PUB.debug('UC-ACL: NTF_FINAL_APPROVAL_FYI -- document='||document);

686:
687: document := document || l_body;
688:
689: IF G_DEBUG='Y' THEN
690: AHL_DEBUG_PUB.debug('UC-ACL: NTF_FINAL_APPROVAL_FYI -- document='||document);
691: AHL_DEBUG_PUB.debug( 'END UC NTF Final approval , l_object_id =' || l_object_id );
692: AHL_DEBUG_PUB.DISABLE_DEBUG;
693: END IF;
694:

Line 691: AHL_DEBUG_PUB.debug( 'END UC NTF Final approval , l_object_id =' || l_object_id );

687: document := document || l_body;
688:
689: IF G_DEBUG='Y' THEN
690: AHL_DEBUG_PUB.debug('UC-ACL: NTF_FINAL_APPROVAL_FYI -- document='||document);
691: AHL_DEBUG_PUB.debug( 'END UC NTF Final approval , l_object_id =' || l_object_id );
692: AHL_DEBUG_PUB.DISABLE_DEBUG;
693: END IF;
694:
695: RETURN;

Line 692: AHL_DEBUG_PUB.DISABLE_DEBUG;

688:
689: IF G_DEBUG='Y' THEN
690: AHL_DEBUG_PUB.debug('UC-ACL: NTF_FINAL_APPROVAL_FYI -- document='||document);
691: AHL_DEBUG_PUB.debug( 'END UC NTF Final approval , l_object_id =' || l_object_id );
692: AHL_DEBUG_PUB.DISABLE_DEBUG;
693: END IF;
694:
695: RETURN;
696:

Line 763: AHL_DEBUG_PUB.ENABLE_DEBUG;

759:
760: BEGIN
761:
762: IF G_DEBUG='Y' THEN
763: AHL_DEBUG_PUB.ENABLE_DEBUG;
764: AHL_DEBUG_PUB.debug( 'UC-ACL:Start Notify Rejected');
765: END IF;
766:
767: document_type := 'text/plain';

Line 764: AHL_DEBUG_PUB.debug( 'UC-ACL:Start Notify Rejected');

760: BEGIN
761:
762: IF G_DEBUG='Y' THEN
763: AHL_DEBUG_PUB.ENABLE_DEBUG;
764: AHL_DEBUG_PUB.debug( 'UC-ACL:Start Notify Rejected');
765: END IF;
766:
767: document_type := 'text/plain';
768:

Line 799: AHL_DEBUG_PUB.debug('UC-ACL:NTF_REJECTED_FYI -- l_approver='||l_approver);

795: ,aname => 'APPROVER'
796: );
797:
798: IF G_DEBUG='Y' THEN
799: AHL_DEBUG_PUB.debug('UC-ACL:NTF_REJECTED_FYI -- l_approver='||l_approver);
800: END IF;
801:
802:
803: OPEN get_uc_header_det(l_object_id);

Line 822: AHL_DEBUG_PUB.debug('UC-ACL:NTF_REJECTED_FYI -- document='||document);

818:
819: document := document || l_body;
820:
821: IF G_DEBUG='Y' THEN
822: AHL_DEBUG_PUB.debug('UC-ACL:NTF_REJECTED_FYI -- document='||document);
823: AHL_DEBUG_PUB.debug( 'UC-ACL:End Notify Rejected, l_object_id =' || l_object_id );
824: AHL_DEBUG_PUB.DISABLE_DEBUG;
825: END IF;
826:

Line 823: AHL_DEBUG_PUB.debug( 'UC-ACL:End Notify Rejected, l_object_id =' || l_object_id );

819: document := document || l_body;
820:
821: IF G_DEBUG='Y' THEN
822: AHL_DEBUG_PUB.debug('UC-ACL:NTF_REJECTED_FYI -- document='||document);
823: AHL_DEBUG_PUB.debug( 'UC-ACL:End Notify Rejected, l_object_id =' || l_object_id );
824: AHL_DEBUG_PUB.DISABLE_DEBUG;
825: END IF;
826:
827: RETURN;

Line 824: AHL_DEBUG_PUB.DISABLE_DEBUG;

820:
821: IF G_DEBUG='Y' THEN
822: AHL_DEBUG_PUB.debug('UC-ACL:NTF_REJECTED_FYI -- document='||document);
823: AHL_DEBUG_PUB.debug( 'UC-ACL:End Notify Rejected, l_object_id =' || l_object_id );
824: AHL_DEBUG_PUB.DISABLE_DEBUG;
825: END IF;
826:
827: RETURN;
828:

Line 895: AHL_DEBUG_PUB.ENABLE_DEBUG;

891:
892: BEGIN
893:
894: IF G_DEBUG='Y' THEN
895: AHL_DEBUG_PUB.ENABLE_DEBUG;
896: AHL_DEBUG_PUB.debug( 'UC-ACL: Start Nty_approval');
897: END IF;
898:
899: document_type := 'text/plain';

Line 896: AHL_DEBUG_PUB.debug( 'UC-ACL: Start Nty_approval');

892: BEGIN
893:
894: IF G_DEBUG='Y' THEN
895: AHL_DEBUG_PUB.ENABLE_DEBUG;
896: AHL_DEBUG_PUB.debug( 'UC-ACL: Start Nty_approval');
897: END IF;
898:
899: document_type := 'text/plain';
900:

Line 938: AHL_DEBUG_PUB.debug('UC-ACL: NTF_APPROVAL --> l_object='||l_object);

934: ,aname => 'REQUESTER_NOTE'
935: );
936:
937: IF G_DEBUG='Y' THEN
938: AHL_DEBUG_PUB.debug('UC-ACL: NTF_APPROVAL --> l_object='||l_object);
939: AHL_DEBUG_PUB.debug('UC-ACL: NTF_APPROVAL --> l_object_id='||l_object_id);
940: AHL_DEBUG_PUB.debug('UC-ACL: NTF_APPROVAL --> l_requester='||l_requester);
941: AHL_DEBUG_PUB.debug('UC-ACL: NTF_APPROVAL --> l_requester_note='||l_requester_note);
942: END IF;

Line 939: AHL_DEBUG_PUB.debug('UC-ACL: NTF_APPROVAL --> l_object_id='||l_object_id);

935: );
936:
937: IF G_DEBUG='Y' THEN
938: AHL_DEBUG_PUB.debug('UC-ACL: NTF_APPROVAL --> l_object='||l_object);
939: AHL_DEBUG_PUB.debug('UC-ACL: NTF_APPROVAL --> l_object_id='||l_object_id);
940: AHL_DEBUG_PUB.debug('UC-ACL: NTF_APPROVAL --> l_requester='||l_requester);
941: AHL_DEBUG_PUB.debug('UC-ACL: NTF_APPROVAL --> l_requester_note='||l_requester_note);
942: END IF;
943:

Line 940: AHL_DEBUG_PUB.debug('UC-ACL: NTF_APPROVAL --> l_requester='||l_requester);

936:
937: IF G_DEBUG='Y' THEN
938: AHL_DEBUG_PUB.debug('UC-ACL: NTF_APPROVAL --> l_object='||l_object);
939: AHL_DEBUG_PUB.debug('UC-ACL: NTF_APPROVAL --> l_object_id='||l_object_id);
940: AHL_DEBUG_PUB.debug('UC-ACL: NTF_APPROVAL --> l_requester='||l_requester);
941: AHL_DEBUG_PUB.debug('UC-ACL: NTF_APPROVAL --> l_requester_note='||l_requester_note);
942: END IF;
943:
944: OPEN get_uc_header_det(l_object_id);

Line 941: AHL_DEBUG_PUB.debug('UC-ACL: NTF_APPROVAL --> l_requester_note='||l_requester_note);

937: IF G_DEBUG='Y' THEN
938: AHL_DEBUG_PUB.debug('UC-ACL: NTF_APPROVAL --> l_object='||l_object);
939: AHL_DEBUG_PUB.debug('UC-ACL: NTF_APPROVAL --> l_object_id='||l_object_id);
940: AHL_DEBUG_PUB.debug('UC-ACL: NTF_APPROVAL --> l_requester='||l_requester);
941: AHL_DEBUG_PUB.debug('UC-ACL: NTF_APPROVAL --> l_requester_note='||l_requester_note);
942: END IF;
943:
944: OPEN get_uc_header_det(l_object_id);
945: FETCH get_uc_header_det into l_uc_header_rec;

Line 964: AHL_DEBUG_PUB.debug('UC-ACL: NTF_APPROVAL -- document='||document);

960:
961: document := document || l_body;
962:
963: IF G_DEBUG='Y' THEN
964: AHL_DEBUG_PUB.debug('UC-ACL: NTF_APPROVAL -- document='||document);
965: AHL_DEBUG_PUB.debug( 'UC-ACL: END Nty_approval, l_object_id =' || l_object_id );
966: AHL_DEBUG_PUB.DISABLE_DEBUG;
967: END IF;
968:

Line 965: AHL_DEBUG_PUB.debug( 'UC-ACL: END Nty_approval, l_object_id =' || l_object_id );

961: document := document || l_body;
962:
963: IF G_DEBUG='Y' THEN
964: AHL_DEBUG_PUB.debug('UC-ACL: NTF_APPROVAL -- document='||document);
965: AHL_DEBUG_PUB.debug( 'UC-ACL: END Nty_approval, l_object_id =' || l_object_id );
966: AHL_DEBUG_PUB.DISABLE_DEBUG;
967: END IF;
968:
969: RETURN;

Line 966: AHL_DEBUG_PUB.DISABLE_DEBUG;

962:
963: IF G_DEBUG='Y' THEN
964: AHL_DEBUG_PUB.debug('UC-ACL: NTF_APPROVAL -- document='||document);
965: AHL_DEBUG_PUB.debug( 'UC-ACL: END Nty_approval, l_object_id =' || l_object_id );
966: AHL_DEBUG_PUB.DISABLE_DEBUG;
967: END IF;
968:
969: RETURN;
970:

Line 1037: AHL_DEBUG_PUB.ENABLE_DEBUG;

1033:
1034: BEGIN
1035:
1036: IF G_DEBUG='Y' THEN
1037: AHL_DEBUG_PUB.ENABLE_DEBUG;
1038: AHL_DEBUG_PUB.debug( 'Start ntfy Apprvl remainder');
1039: END IF;
1040:
1041: document_type := 'text/plain';

Line 1038: AHL_DEBUG_PUB.debug( 'Start ntfy Apprvl remainder');

1034: BEGIN
1035:
1036: IF G_DEBUG='Y' THEN
1037: AHL_DEBUG_PUB.ENABLE_DEBUG;
1038: AHL_DEBUG_PUB.debug( 'Start ntfy Apprvl remainder');
1039: END IF;
1040:
1041: document_type := 'text/plain';
1042:

Line 1080: AHL_DEBUG_PUB.debug('UC-ACL: NTF_APPROVAL_REMINDER -- l_object='||l_object);

1076: ,aname => 'REQUESTER_NOTE'
1077: );
1078:
1079: IF G_DEBUG='Y' THEN
1080: AHL_DEBUG_PUB.debug('UC-ACL: NTF_APPROVAL_REMINDER -- l_object='||l_object);
1081: AHL_DEBUG_PUB.debug('UC-ACL: NTF_APPROVAL_REMINDER -- l_object_id='||l_object_id);
1082: AHL_DEBUG_PUB.debug('UC-ACL: NTF_APPROVAL_REMINDER -- l_requester='||l_requester);
1083: AHL_DEBUG_PUB.debug('UC-ACL: NTF_APPROVAL_REMINDER -- l_requester_note='||l_requester_note);
1084: END IF;

Line 1081: AHL_DEBUG_PUB.debug('UC-ACL: NTF_APPROVAL_REMINDER -- l_object_id='||l_object_id);

1077: );
1078:
1079: IF G_DEBUG='Y' THEN
1080: AHL_DEBUG_PUB.debug('UC-ACL: NTF_APPROVAL_REMINDER -- l_object='||l_object);
1081: AHL_DEBUG_PUB.debug('UC-ACL: NTF_APPROVAL_REMINDER -- l_object_id='||l_object_id);
1082: AHL_DEBUG_PUB.debug('UC-ACL: NTF_APPROVAL_REMINDER -- l_requester='||l_requester);
1083: AHL_DEBUG_PUB.debug('UC-ACL: NTF_APPROVAL_REMINDER -- l_requester_note='||l_requester_note);
1084: END IF;
1085:

Line 1082: AHL_DEBUG_PUB.debug('UC-ACL: NTF_APPROVAL_REMINDER -- l_requester='||l_requester);

1078:
1079: IF G_DEBUG='Y' THEN
1080: AHL_DEBUG_PUB.debug('UC-ACL: NTF_APPROVAL_REMINDER -- l_object='||l_object);
1081: AHL_DEBUG_PUB.debug('UC-ACL: NTF_APPROVAL_REMINDER -- l_object_id='||l_object_id);
1082: AHL_DEBUG_PUB.debug('UC-ACL: NTF_APPROVAL_REMINDER -- l_requester='||l_requester);
1083: AHL_DEBUG_PUB.debug('UC-ACL: NTF_APPROVAL_REMINDER -- l_requester_note='||l_requester_note);
1084: END IF;
1085:
1086: OPEN get_uc_header_det(l_object_id);

Line 1083: AHL_DEBUG_PUB.debug('UC-ACL: NTF_APPROVAL_REMINDER -- l_requester_note='||l_requester_note);

1079: IF G_DEBUG='Y' THEN
1080: AHL_DEBUG_PUB.debug('UC-ACL: NTF_APPROVAL_REMINDER -- l_object='||l_object);
1081: AHL_DEBUG_PUB.debug('UC-ACL: NTF_APPROVAL_REMINDER -- l_object_id='||l_object_id);
1082: AHL_DEBUG_PUB.debug('UC-ACL: NTF_APPROVAL_REMINDER -- l_requester='||l_requester);
1083: AHL_DEBUG_PUB.debug('UC-ACL: NTF_APPROVAL_REMINDER -- l_requester_note='||l_requester_note);
1084: END IF;
1085:
1086: OPEN get_uc_header_det(l_object_id);
1087: FETCH get_uc_header_det into l_uc_header_rec;

Line 1106: AHL_DEBUG_PUB.debug('UC-ACL: NTF_APPROVAL_REMINDER -- document='||document);

1102:
1103: document := document || l_body;
1104:
1105: IF G_DEBUG='Y' THEN
1106: AHL_DEBUG_PUB.debug('UC-ACL: NTF_APPROVAL_REMINDER -- document='||document);
1107: AHL_DEBUG_PUB.debug( 'END ntfy Apprvl remainder, l_object_id =' || l_object_id );
1108: AHL_DEBUG_PUB.DISABLE_DEBUG;
1109: END IF;
1110:

Line 1107: AHL_DEBUG_PUB.debug( 'END ntfy Apprvl remainder, l_object_id =' || l_object_id );

1103: document := document || l_body;
1104:
1105: IF G_DEBUG='Y' THEN
1106: AHL_DEBUG_PUB.debug('UC-ACL: NTF_APPROVAL_REMINDER -- document='||document);
1107: AHL_DEBUG_PUB.debug( 'END ntfy Apprvl remainder, l_object_id =' || l_object_id );
1108: AHL_DEBUG_PUB.DISABLE_DEBUG;
1109: END IF;
1110:
1111: RETURN;

Line 1108: AHL_DEBUG_PUB.DISABLE_DEBUG;

1104:
1105: IF G_DEBUG='Y' THEN
1106: AHL_DEBUG_PUB.debug('UC-ACL: NTF_APPROVAL_REMINDER -- document='||document);
1107: AHL_DEBUG_PUB.debug( 'END ntfy Apprvl remainder, l_object_id =' || l_object_id );
1108: AHL_DEBUG_PUB.DISABLE_DEBUG;
1109: END IF;
1110:
1111: RETURN;
1112:

Line 1177: AHL_DEBUG_PUB.ENABLE_DEBUG;

1173:
1174: BEGIN
1175:
1176: IF G_DEBUG='Y' THEN
1177: AHL_DEBUG_PUB.ENABLE_DEBUG;
1178: AHL_DEBUG_PUB.debug( 'Start Ntfy error');
1179: END IF;
1180:
1181: document_type := 'text/plain';

Line 1178: AHL_DEBUG_PUB.debug( 'Start Ntfy error');

1174: BEGIN
1175:
1176: IF G_DEBUG='Y' THEN
1177: AHL_DEBUG_PUB.ENABLE_DEBUG;
1178: AHL_DEBUG_PUB.debug( 'Start Ntfy error');
1179: END IF;
1180:
1181: document_type := 'text/plain';
1182:

Line 1213: AHL_DEBUG_PUB.debug('UC-ACL: NTF_ERROR_ACT -- l_error_msg='||l_error_msg);

1209: ,aname => 'ERROR_MSG'
1210: );
1211:
1212: IF G_DEBUG='Y' THEN
1213: AHL_DEBUG_PUB.debug('UC-ACL: NTF_ERROR_ACT -- l_error_msg='||l_error_msg);
1214: END IF;
1215:
1216: OPEN get_uc_header_det(l_object_id);
1217: FETCH get_uc_header_det into l_uc_header_rec;

Line 1235: AHL_DEBUG_PUB.debug('UC-ACL: NTF_ERROR_ACT -- document='||document);

1231:
1232: document := document || l_body;
1233:
1234: IF G_DEBUG='Y' THEN
1235: AHL_DEBUG_PUB.debug('UC-ACL: NTF_ERROR_ACT -- document='||document);
1236: AHL_DEBUG_PUB.debug( 'END UC Ntfy error , l_object_id =' || l_object_id );
1237: AHL_DEBUG_PUB.DISABLE_DEBUG;
1238: END IF;
1239:

Line 1236: AHL_DEBUG_PUB.debug( 'END UC Ntfy error , l_object_id =' || l_object_id );

1232: document := document || l_body;
1233:
1234: IF G_DEBUG='Y' THEN
1235: AHL_DEBUG_PUB.debug('UC-ACL: NTF_ERROR_ACT -- document='||document);
1236: AHL_DEBUG_PUB.debug( 'END UC Ntfy error , l_object_id =' || l_object_id );
1237: AHL_DEBUG_PUB.DISABLE_DEBUG;
1238: END IF;
1239:
1240: RETURN;

Line 1237: AHL_DEBUG_PUB.DISABLE_DEBUG;

1233:
1234: IF G_DEBUG='Y' THEN
1235: AHL_DEBUG_PUB.debug('UC-ACL: NTF_ERROR_ACT -- document='||document);
1236: AHL_DEBUG_PUB.debug( 'END UC Ntfy error , l_object_id =' || l_object_id );
1237: AHL_DEBUG_PUB.DISABLE_DEBUG;
1238: END IF;
1239:
1240: RETURN;
1241:

Line 1323: AHL_DEBUG_PUB.ENABLE_DEBUG;

1319:
1320: BEGIN
1321:
1322: IF G_DEBUG='Y' THEN
1323: AHL_DEBUG_PUB.ENABLE_DEBUG;
1324: AHL_DEBUG_PUB.debug( 'UC-ACL:Start Update Status API');
1325: END IF;
1326:
1327: --

Line 1324: AHL_DEBUG_PUB.debug( 'UC-ACL:Start Update Status API');

1320: BEGIN
1321:
1322: IF G_DEBUG='Y' THEN
1323: AHL_DEBUG_PUB.ENABLE_DEBUG;
1324: AHL_DEBUG_PUB.debug( 'UC-ACL:Start Update Status API');
1325: END IF;
1326:
1327: --
1328: -- RUN Mode

Line 1341: AHL_DEBUG_PUB.debug('UC-ACL: UPDATE_STATUS -- l_approval_status='||l_approval_status);

1337: );
1338:
1339:
1340: IF G_DEBUG='Y' THEN
1341: AHL_DEBUG_PUB.debug('UC-ACL: UPDATE_STATUS -- l_approval_status='||l_approval_status);
1342: END IF;
1343:
1344: l_object_version_number := wf_engine.getitemattrnumber
1345: (

Line 1352: AHL_DEBUG_PUB.debug('UC-ACL: UPDATE_STATUS --> l_object_version_number='||l_object_version_number);

1348: aname => 'OBJECT_VER'
1349: );
1350:
1351: IF G_DEBUG='Y' THEN
1352: AHL_DEBUG_PUB.debug('UC-ACL: UPDATE_STATUS --> l_object_version_number='||l_object_version_number);
1353: END IF;
1354:
1355: l_object_id := wf_engine.getitemattrnumber
1356: (

Line 1363: AHL_DEBUG_PUB.debug('UC-ACL: UPDATE_STATUS --> l_object_id='||l_object_id);

1359: aname => 'OBJECT_ID'
1360: );
1361:
1362: IF G_DEBUG='Y' THEN
1363: AHL_DEBUG_PUB.debug('UC-ACL: UPDATE_STATUS --> l_object_id='||l_object_id);
1364: END IF;
1365:
1366: OPEN get_uc_header_det(l_object_id);
1367: FETCH get_uc_header_det into l_uc_header_rec;

Line 1383: AHL_DEBUG_PUB.debug('UC-ACL: UPDATE_STATUS check_uc_ovn --> fnd_message='||fnd_message.get );

1379:
1380: IF check_uc_ovn%NOTFOUND THEN
1381: fnd_message.set_name('AHL', 'AHL_COM_RECORD_CHANGED');
1382: IF G_DEBUG='Y' THEN
1383: AHL_DEBUG_PUB.debug('UC-ACL: UPDATE_STATUS check_uc_ovn --> fnd_message='||fnd_message.get );
1384: END IF;
1385: RAISE FND_API.G_EXC_ERROR;
1386: END IF;
1387: CLOSE check_uc_ovn;

Line 1400: AHL_DEBUG_PUB.debug('UC-ACL:AHL_UC_WF_APPR_PVT.update_status -->l_msg_count...... ' || l_msg_count);

1396: x_error_msg => l_error_msg
1397: );
1398:
1399: IF G_DEBUG='Y' THEN
1400: AHL_DEBUG_PUB.debug('UC-ACL:AHL_UC_WF_APPR_PVT.update_status -->l_msg_count...... ' || l_msg_count);
1401: AHL_DEBUG_PUB.debug('UC-ACL:AHL_UC_WF_APPR_PVT.update_status -->l_error_msg...... ' || l_error_msg);
1402: AHL_DEBUG_PUB.debug('UC-ACL:AHL_UC_WF_APPR_PVT.update_status -->l_msg_data...... ' || l_msg_data);
1403: AHL_DEBUG_PUB.debug('UC-ACL:AHL_UC_WF_APPR_PVT.update_status --> Before call to complete_quarantine_approval ');
1404: END IF;

Line 1401: AHL_DEBUG_PUB.debug('UC-ACL:AHL_UC_WF_APPR_PVT.update_status -->l_error_msg...... ' || l_error_msg);

1397: );
1398:
1399: IF G_DEBUG='Y' THEN
1400: AHL_DEBUG_PUB.debug('UC-ACL:AHL_UC_WF_APPR_PVT.update_status -->l_msg_count...... ' || l_msg_count);
1401: AHL_DEBUG_PUB.debug('UC-ACL:AHL_UC_WF_APPR_PVT.update_status -->l_error_msg...... ' || l_error_msg);
1402: AHL_DEBUG_PUB.debug('UC-ACL:AHL_UC_WF_APPR_PVT.update_status -->l_msg_data...... ' || l_msg_data);
1403: AHL_DEBUG_PUB.debug('UC-ACL:AHL_UC_WF_APPR_PVT.update_status --> Before call to complete_quarantine_approval ');
1404: END IF;
1405:

Line 1402: AHL_DEBUG_PUB.debug('UC-ACL:AHL_UC_WF_APPR_PVT.update_status -->l_msg_data...... ' || l_msg_data);

1398:
1399: IF G_DEBUG='Y' THEN
1400: AHL_DEBUG_PUB.debug('UC-ACL:AHL_UC_WF_APPR_PVT.update_status -->l_msg_count...... ' || l_msg_count);
1401: AHL_DEBUG_PUB.debug('UC-ACL:AHL_UC_WF_APPR_PVT.update_status -->l_error_msg...... ' || l_error_msg);
1402: AHL_DEBUG_PUB.debug('UC-ACL:AHL_UC_WF_APPR_PVT.update_status -->l_msg_data...... ' || l_msg_data);
1403: AHL_DEBUG_PUB.debug('UC-ACL:AHL_UC_WF_APPR_PVT.update_status --> Before call to complete_quarantine_approval ');
1404: END IF;
1405:
1406: --CALL AHL_UC_APPROVALS_PVT.complete_quarantine_approval

Line 1403: AHL_DEBUG_PUB.debug('UC-ACL:AHL_UC_WF_APPR_PVT.update_status --> Before call to complete_quarantine_approval ');

1399: IF G_DEBUG='Y' THEN
1400: AHL_DEBUG_PUB.debug('UC-ACL:AHL_UC_WF_APPR_PVT.update_status -->l_msg_count...... ' || l_msg_count);
1401: AHL_DEBUG_PUB.debug('UC-ACL:AHL_UC_WF_APPR_PVT.update_status -->l_error_msg...... ' || l_error_msg);
1402: AHL_DEBUG_PUB.debug('UC-ACL:AHL_UC_WF_APPR_PVT.update_status -->l_msg_data...... ' || l_msg_data);
1403: AHL_DEBUG_PUB.debug('UC-ACL:AHL_UC_WF_APPR_PVT.update_status --> Before call to complete_quarantine_approval ');
1404: END IF;
1405:
1406: --CALL AHL_UC_APPROVALS_PVT.complete_quarantine_approval
1407: AHL_UC_APPROVALS_PVT.complete_quarantine_approval(

Line 1421: AHL_DEBUG_PUB.debug('SQLERRM' || SQLERRM );

1417: x_msg_data => l_msg_data
1418: );
1419:
1420: IF G_DEBUG='Y' THEN
1421: AHL_DEBUG_PUB.debug('SQLERRM' || SQLERRM );
1422: AHL_DEBUG_PUB.debug('l_return_status' || l_return_status);
1423: AHL_DEBUG_PUB.debug('l_msg_count' || l_msg_count);
1424: AHL_DEBUG_PUB.debug('l_msg_data' || l_msg_data);
1425: AHL_DEBUG_PUB.debug('UC-ACL:AHL_UC_WF_APPR_PVT.update_status -- Completed call to complete_uc_approval ');

Line 1422: AHL_DEBUG_PUB.debug('l_return_status' || l_return_status);

1418: );
1419:
1420: IF G_DEBUG='Y' THEN
1421: AHL_DEBUG_PUB.debug('SQLERRM' || SQLERRM );
1422: AHL_DEBUG_PUB.debug('l_return_status' || l_return_status);
1423: AHL_DEBUG_PUB.debug('l_msg_count' || l_msg_count);
1424: AHL_DEBUG_PUB.debug('l_msg_data' || l_msg_data);
1425: AHL_DEBUG_PUB.debug('UC-ACL:AHL_UC_WF_APPR_PVT.update_status -- Completed call to complete_uc_approval ');
1426: END IF;

Line 1423: AHL_DEBUG_PUB.debug('l_msg_count' || l_msg_count);

1419:
1420: IF G_DEBUG='Y' THEN
1421: AHL_DEBUG_PUB.debug('SQLERRM' || SQLERRM );
1422: AHL_DEBUG_PUB.debug('l_return_status' || l_return_status);
1423: AHL_DEBUG_PUB.debug('l_msg_count' || l_msg_count);
1424: AHL_DEBUG_PUB.debug('l_msg_data' || l_msg_data);
1425: AHL_DEBUG_PUB.debug('UC-ACL:AHL_UC_WF_APPR_PVT.update_status -- Completed call to complete_uc_approval ');
1426: END IF;
1427:

Line 1424: AHL_DEBUG_PUB.debug('l_msg_data' || l_msg_data);

1420: IF G_DEBUG='Y' THEN
1421: AHL_DEBUG_PUB.debug('SQLERRM' || SQLERRM );
1422: AHL_DEBUG_PUB.debug('l_return_status' || l_return_status);
1423: AHL_DEBUG_PUB.debug('l_msg_count' || l_msg_count);
1424: AHL_DEBUG_PUB.debug('l_msg_data' || l_msg_data);
1425: AHL_DEBUG_PUB.debug('UC-ACL:AHL_UC_WF_APPR_PVT.update_status -- Completed call to complete_uc_approval ');
1426: END IF;
1427:
1428: IF G_DEBUG='Y' THEN

Line 1425: AHL_DEBUG_PUB.debug('UC-ACL:AHL_UC_WF_APPR_PVT.update_status -- Completed call to complete_uc_approval ');

1421: AHL_DEBUG_PUB.debug('SQLERRM' || SQLERRM );
1422: AHL_DEBUG_PUB.debug('l_return_status' || l_return_status);
1423: AHL_DEBUG_PUB.debug('l_msg_count' || l_msg_count);
1424: AHL_DEBUG_PUB.debug('l_msg_data' || l_msg_data);
1425: AHL_DEBUG_PUB.debug('UC-ACL:AHL_UC_WF_APPR_PVT.update_status -- Completed call to complete_uc_approval ');
1426: END IF;
1427:
1428: IF G_DEBUG='Y' THEN
1429: AHL_DEBUG_PUB.debug( 'UC-ACL:End Update Status API, l_object_id =' || l_object_id );

Line 1429: AHL_DEBUG_PUB.debug( 'UC-ACL:End Update Status API, l_object_id =' || l_object_id );

1425: AHL_DEBUG_PUB.debug('UC-ACL:AHL_UC_WF_APPR_PVT.update_status -- Completed call to complete_uc_approval ');
1426: END IF;
1427:
1428: IF G_DEBUG='Y' THEN
1429: AHL_DEBUG_PUB.debug( 'UC-ACL:End Update Status API, l_object_id =' || l_object_id );
1430: AHL_DEBUG_PUB.DISABLE_DEBUG;
1431: END IF;
1432:
1433: resultout := 'COMPLETE:SUCCESS';

Line 1430: AHL_DEBUG_PUB.DISABLE_DEBUG;

1426: END IF;
1427:
1428: IF G_DEBUG='Y' THEN
1429: AHL_DEBUG_PUB.debug( 'UC-ACL:End Update Status API, l_object_id =' || l_object_id );
1430: AHL_DEBUG_PUB.DISABLE_DEBUG;
1431: END IF;
1432:
1433: resultout := 'COMPLETE:SUCCESS';
1434: RETURN;

Line 1538: AHL_DEBUG_PUB.ENABLE_DEBUG;

1534:
1535: BEGIN
1536:
1537: IF G_DEBUG='Y' THEN
1538: AHL_DEBUG_PUB.ENABLE_DEBUG;
1539: AHL_DEBUG_PUB.debug( 'UC-ACL:Start Revert Status');
1540: END IF;
1541:
1542: --

Line 1539: AHL_DEBUG_PUB.debug( 'UC-ACL:Start Revert Status');

1535: BEGIN
1536:
1537: IF G_DEBUG='Y' THEN
1538: AHL_DEBUG_PUB.ENABLE_DEBUG;
1539: AHL_DEBUG_PUB.debug( 'UC-ACL:Start Revert Status');
1540: END IF;
1541:
1542: --
1543: -- RUN mode

Line 1553: AHL_DEBUG_PUB.debug('UC-ACL: REVERT_STATUS -- l_next_status'||l_next_status);

1549: ,itemkey => itemkey
1550: ,aname => 'ORG_STATUS_ID'
1551: );
1552: IF G_DEBUG='Y' THEN
1553: AHL_DEBUG_PUB.debug('UC-ACL: REVERT_STATUS -- l_next_status'||l_next_status);
1554: END IF;
1555:
1556: -- if l_next_status is not APPROVED, force assign to APPROVED.
1557: -- This is done for ACL flow, as Approval Rejected Status in ACL Approval Flow

Line 1569: AHL_DEBUG_PUB.debug('UC-ACL: REVERT_STATUS -- l_object_version_number'||l_object_version_number);

1565: ,aname => 'OBJECT_VER'
1566: );
1567:
1568: IF G_DEBUG='Y' THEN
1569: AHL_DEBUG_PUB.debug('UC-ACL: REVERT_STATUS -- l_object_version_number'||l_object_version_number);
1570: END IF;
1571:
1572: l_object_id := wf_engine.getitemattrnumber
1573: (

Line 1580: AHL_DEBUG_PUB.debug('UC-ACL: REVERT_STATUS -- l_object_id'||l_object_id);

1576: ,aname => 'OBJECT_ID'
1577: );
1578:
1579: IF G_DEBUG='Y' THEN
1580: AHL_DEBUG_PUB.debug('UC-ACL: REVERT_STATUS -- l_object_id'||l_object_id);
1581: END IF;
1582:
1583: OPEN get_uc_header_det(l_object_id);
1584: FETCH get_uc_header_det into l_uc_header_rec;

Line 1613: AHL_DEBUG_PUB.debug('UC-ACL: REVERT_STATUS --> Completed resetting of status');

1609:
1610: CLOSE check_uc_ovn;
1611:
1612: IF G_DEBUG='Y' THEN
1613: AHL_DEBUG_PUB.debug('UC-ACL: REVERT_STATUS --> Completed resetting of status');
1614: AHL_DEBUG_PUB.debug('UC-ACL:END Revert Status, l_object_id =' || l_object_id );
1615: AHL_DEBUG_PUB.DISABLE_DEBUG;
1616: END IF;
1617:

Line 1614: AHL_DEBUG_PUB.debug('UC-ACL:END Revert Status, l_object_id =' || l_object_id );

1610: CLOSE check_uc_ovn;
1611:
1612: IF G_DEBUG='Y' THEN
1613: AHL_DEBUG_PUB.debug('UC-ACL: REVERT_STATUS --> Completed resetting of status');
1614: AHL_DEBUG_PUB.debug('UC-ACL:END Revert Status, l_object_id =' || l_object_id );
1615: AHL_DEBUG_PUB.DISABLE_DEBUG;
1616: END IF;
1617:
1618: resultout := 'COMPLETE:';

Line 1615: AHL_DEBUG_PUB.DISABLE_DEBUG;

1611:
1612: IF G_DEBUG='Y' THEN
1613: AHL_DEBUG_PUB.debug('UC-ACL: REVERT_STATUS --> Completed resetting of status');
1614: AHL_DEBUG_PUB.debug('UC-ACL:END Revert Status, l_object_id =' || l_object_id );
1615: AHL_DEBUG_PUB.DISABLE_DEBUG;
1616: END IF;
1617:
1618: resultout := 'COMPLETE:';
1619: RETURN;