APPS.AHL_UC_WF_APPR_PVT dependencies on AHL_DEBUG_PUB

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

4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_UC_WF_APPR_PVT';
5:
6: -- To check if AHL DEBUG is turned ON
7: --G_DEBUG VARCHAR2(1) := FND_PROFILE.VALUE('AHL_API_FILE_DEBUG_ON');
8: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
9:
10:
11: CURSOR get_uc_header_det(c_uc_header_id in number)
12: IS

Line 48: AHL_DEBUG_PUB.ENABLE_DEBUG;

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

Line 49: AHL_DEBUG_PUB.debug( 'UC: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:Start Set Actvity Details');
50: END IF;
51:
52: --Initiliaze message list
53: fnd_msg_pub.initialize;

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

61: ,itemkey => itemkey
62: ,aname => 'OBJECT_ID'
63: );
64: IF G_DEBUG='Y' THEN
65: AHL_DEBUG_PUB.debug('UC: SET_ACTIVITY_DETAILS --> l_object_id='||l_object_id);
66: END IF;
67:
68: l_object_version_number := wf_engine.getitemattrnumber
69: (

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

71: itemkey => itemkey,
72: aname => 'OBJECT_VER'
73: );
74: IF G_DEBUG='Y' THEN
75: AHL_DEBUG_PUB.debug('UC: SET_ACTIVITY_DETAILS --> l_object_version_number='||l_object_version_number);
76: END IF;
77:
78:
79: l_object_details.operating_unit_id := NULL;

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

127: ,aname => 'APPROVAL_SUBJECT'
128: ,avalue => l_subject
129: );
130: IF G_DEBUG='Y' THEN
131: AHL_DEBUG_PUB.debug('UC: SET_ACTIVITY_DETAILS -- APPROVAL_SUBJECT='||l_subject);
132: END IF;
133:
134: fnd_message.set_name('AHL', 'AHL_UC_NTF_REJECT_SUBJECT');
135: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);

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

143: ,aname => 'REJECT_SUBJECT'
144: ,avalue => l_subject
145: );
146: IF G_DEBUG='Y' THEN
147: AHL_DEBUG_PUB.debug('UC: SET_ACTIVITY_DETAILS -- REJECT_SUBJECT='||l_subject);
148: END IF;
149:
150: fnd_message.set_name('AHL', 'AHL_UC_NTF_APPROVED_SUBJECT');
151: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);

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

159: ,aname => 'APPROVED_SUBJECT'
160: ,avalue => l_subject
161: );
162: IF G_DEBUG='Y' THEN
163: AHL_DEBUG_PUB.debug('UC: SET_ACTIVITY_DETAILS -- APPROVED_SUBJECT='||l_subject);
164: END IF;
165:
166: fnd_message.set_name('AHL', 'AHL_UC_NTF_FINAL_SUBJECT');
167: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);

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

175: ,aname => 'FINAL_SUBJECT'
176: ,avalue => l_subject
177: );
178: IF G_DEBUG='Y' THEN
179: AHL_DEBUG_PUB.debug('UC: SET_ACTIVITY_DETAILS -- FINAL_SUBJECT='||l_subject);
180: END IF;
181:
182: fnd_message.set_name('AHL', 'AHL_UC_NTF_REMIND_SUBJECT');
183: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);

Line 195: AHL_DEBUG_PUB.debug('UC: 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: SET_ACTIVITY_DETAILS -- REMIND_SUBJECT='||l_subject);
196: END IF;
197:
198: fnd_message.set_name('AHL', 'AHL_UC_NTF_ERROR_SUBJECT');
199: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);

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

207: ,aname => 'ERROR_SUBJECT'
208: ,avalue => l_subject
209: );
210: IF G_DEBUG='Y' THEN
211: AHL_DEBUG_PUB.debug('UC: SET_ACTIVITY_DETAILS -- ERROR_SUBJECT='||l_subject);
212: END IF;
213:
214: AHL_GENERIC_APRV_PVT.GET_APPROVAL_DETAILS
215: (

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

231: aname => 'RULE_ID',
232: avalue => l_approval_rule_id
233: );
234: IF G_DEBUG='Y' THEN
235: AHL_DEBUG_PUB.debug('UC: SET_ACTIVITY_DETAILS -- RULE_ID='||l_approval_rule_id);
236: END IF;
237:
238: wf_engine.setitemattrnumber
239: (

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

242: aname => 'APPROVER_SEQ',
243: avalue => l_approver_seq
244: );
245: IF G_DEBUG='Y' THEN
246: AHL_DEBUG_PUB.debug('UC: SET_ACTIVITY_DETAILS -- APPROVER_SEQ='||l_approver_seq);
247: AHL_DEBUG_PUB.debug('UC:End Set Actvity Details');
248: AHL_DEBUG_PUB.disable_debug;
249: END IF;
250:

Line 247: AHL_DEBUG_PUB.debug('UC:End Set Actvity Details');

243: avalue => l_approver_seq
244: );
245: IF G_DEBUG='Y' THEN
246: AHL_DEBUG_PUB.debug('UC: SET_ACTIVITY_DETAILS -- APPROVER_SEQ='||l_approver_seq);
247: AHL_DEBUG_PUB.debug('UC:End Set Actvity Details');
248: AHL_DEBUG_PUB.disable_debug;
249: END IF;
250:
251: resultout := 'COMPLETE:SUCCESS';

Line 248: AHL_DEBUG_PUB.disable_debug;

244: );
245: IF G_DEBUG='Y' THEN
246: AHL_DEBUG_PUB.debug('UC: SET_ACTIVITY_DETAILS -- APPROVER_SEQ='||l_approver_seq);
247: AHL_DEBUG_PUB.debug('UC:End Set Actvity Details');
248: AHL_DEBUG_PUB.disable_debug;
249: END IF;
250:
251: resultout := 'COMPLETE:SUCCESS';
252: RETURN;

Line 267: AHL_DEBUG_PUB.disable_debug;

263: IF (funcmode = 'CANCEL')
264: THEN
265: resultout := 'COMPLETE:';
266: IF G_DEBUG='Y' THEN
267: AHL_DEBUG_PUB.disable_debug;
268: END IF;
269:
270: RETURN;
271: END IF;

Line 282: AHL_DEBUG_PUB.disable_debug;

278: THEN
279: resultout := 'COMPLETE:';
280:
281: IF G_DEBUG='Y' THEN
282: AHL_DEBUG_PUB.disable_debug;
283: END IF;
284:
285: RETURN;
286: END IF;

Line 361: AHL_DEBUG_PUB.ENABLE_DEBUG;

357:
358: BEGIN
359:
360: IF G_DEBUG='Y' THEN
361: AHL_DEBUG_PUB.ENABLE_DEBUG;
362: AHL_DEBUG_PUB.debug( 'UC:Start Notify Forward');
363: END IF;
364:
365: document_type := 'text/plain';

Line 362: AHL_DEBUG_PUB.debug( 'UC:Start Notify Forward');

358: BEGIN
359:
360: IF G_DEBUG='Y' THEN
361: AHL_DEBUG_PUB.ENABLE_DEBUG;
362: AHL_DEBUG_PUB.debug( 'UC:Start Notify Forward');
363: END IF;
364:
365: document_type := 'text/plain';
366:

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

392: ,itemkey => l_item_key
393: ,aname => 'APPROVER'
394: );
395: IF G_DEBUG='Y' THEN
396: AHL_DEBUG_PUB.debug('UC: NTF_FORWARD_FYI -- l_approver='||l_approver);
397: END IF;
398:
399: OPEN get_uc_header_det(l_object_id);
400: FETCH get_uc_header_det into l_uc_header_rec;

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

414: CLOSE get_uc_header_det;
415:
416: document := document || l_body;
417: IF G_DEBUG='Y' THEN
418: AHL_DEBUG_PUB.debug('UC: NTF_FORWARD_FYI -- document='||document);
419: END IF;
420:
421:
422: IF G_DEBUG='Y' THEN

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

419: END IF;
420:
421:
422: IF G_DEBUG='Y' THEN
423: AHL_DEBUG_PUB.debug( 'UC:END Notify Forward, l_object_id =' || l_object_id );
424: AHL_DEBUG_PUB.DISABLE_DEBUG;
425: END IF;
426:
427: COMMIT;

Line 424: AHL_DEBUG_PUB.DISABLE_DEBUG;

420:
421:
422: IF G_DEBUG='Y' THEN
423: AHL_DEBUG_PUB.debug( 'UC:END Notify Forward, l_object_id =' || l_object_id );
424: AHL_DEBUG_PUB.DISABLE_DEBUG;
425: END IF;
426:
427: COMMIT;
428: RETURN;

Line 497: AHL_DEBUG_PUB.ENABLE_DEBUG;

493:
494: BEGIN
495:
496: IF G_DEBUG='Y' THEN
497: AHL_DEBUG_PUB.ENABLE_DEBUG;
498: AHL_DEBUG_PUB.debug( 'UC:Start Notify Approved FYI');
499: END IF;
500:
501: document_type := 'text/plain';

Line 498: AHL_DEBUG_PUB.debug( 'UC:Start Notify Approved FYI');

494: BEGIN
495:
496: IF G_DEBUG='Y' THEN
497: AHL_DEBUG_PUB.ENABLE_DEBUG;
498: AHL_DEBUG_PUB.debug( 'UC:Start Notify Approved FYI');
499: END IF;
500:
501: document_type := 'text/plain';
502:

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

528: ,itemkey => l_item_key
529: ,aname => 'APPROVER'
530: );
531: IF G_DEBUG='Y' THEN
532: AHL_DEBUG_PUB.debug('UC: NTF_APPROVED_FYI -- l_approver='||l_approver);
533: END IF;
534:
535: OPEN get_uc_header_det(l_object_id);
536: FETCH get_uc_header_det into l_uc_header_rec;

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

550: CLOSE get_uc_header_det;
551:
552: document := document || l_body;
553: IF G_DEBUG='Y' THEN
554: AHL_DEBUG_PUB.debug('UC: NTF_APPROVED_FYI -- document='||document);
555: END IF;
556:
557: IF G_DEBUG='Y' THEN
558: AHL_DEBUG_PUB.debug( 'UC:END Notify Approved FYI, l_object_id =' || l_object_id );

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

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

Line 559: AHL_DEBUG_PUB.DISABLE_DEBUG;

555: END IF;
556:
557: IF G_DEBUG='Y' THEN
558: AHL_DEBUG_PUB.debug( 'UC:END Notify Approved FYI, l_object_id =' || l_object_id );
559: AHL_DEBUG_PUB.DISABLE_DEBUG;
560: END IF;
561:
562: RETURN;
563:

Line 630: AHL_DEBUG_PUB.ENABLE_DEBUG;

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

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

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

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

661: ,itemkey => l_item_key
662: ,aname => 'APPROVER'
663: );
664: IF G_DEBUG='Y' THEN
665: AHL_DEBUG_PUB.debug('UC: NTF_FINAL_APPROVAL_FYI -- l_approver='||l_approver);
666: END IF;
667:
668: OPEN get_uc_header_det(l_object_id);
669: FETCH get_uc_header_det into l_uc_header_rec;

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

682: CLOSE get_uc_header_det;
683:
684: document := document || l_body;
685: IF G_DEBUG='Y' THEN
686: AHL_DEBUG_PUB.debug('UC: NTF_FINAL_APPROVAL_FYI -- document='||document);
687: END IF;
688:
689: IF G_DEBUG='Y' THEN
690: AHL_DEBUG_PUB.debug( 'END UC NTF Final approval , l_object_id =' || l_object_id );

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

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

Line 691: AHL_DEBUG_PUB.DISABLE_DEBUG;

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

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:Start Notify Rejected');
765: END IF;
766:
767: document_type := 'text/plain';

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

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

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

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

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

816: CLOSE get_uc_header_det;
817:
818: document := document || l_body;
819: IF G_DEBUG='Y' THEN
820: AHL_DEBUG_PUB.debug('UC:NTF_REJECTED_FYI -- document='||document);
821: END IF;
822:
823:
824: IF G_DEBUG='Y' THEN

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

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

Line 826: AHL_DEBUG_PUB.DISABLE_DEBUG;

822:
823:
824: IF G_DEBUG='Y' THEN
825: AHL_DEBUG_PUB.debug( 'UC:End Notify Rejected, l_object_id =' || l_object_id );
826: AHL_DEBUG_PUB.DISABLE_DEBUG;
827: END IF;
828:
829: RETURN;
830:

Line 897: AHL_DEBUG_PUB.ENABLE_DEBUG;

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

Line 898: AHL_DEBUG_PUB.debug( 'UC: Start Nty_approval');

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

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

928: ,itemkey => l_item_key
929: ,aname => 'REQUESTER'
930: );
931: IF G_DEBUG='Y' THEN
932: AHL_DEBUG_PUB.debug('UC: NTF_APPROVAL --> l_requester='||l_requester);
933: END IF;
934: l_requester_note := wf_engine.getitemattrtext
935: (
936: itemtype => l_item_type

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

958: CLOSE get_uc_header_det;
959:
960: document := document || l_body;
961: IF G_DEBUG='Y' THEN
962: AHL_DEBUG_PUB.debug('UC: NTF_APPROVAL -- document='||document);
963: END IF;
964:
965: IF G_DEBUG='Y' THEN
966: AHL_DEBUG_PUB.debug( 'UC: END Nty_approval, l_object_id =' || l_object_id );

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

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

Line 967: AHL_DEBUG_PUB.DISABLE_DEBUG;

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

Line 1038: AHL_DEBUG_PUB.ENABLE_DEBUG;

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

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

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

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

1069: ,itemkey => l_item_key
1070: ,aname => 'REQUESTER'
1071: );
1072: IF G_DEBUG='Y' THEN
1073: AHL_DEBUG_PUB.debug('UC: NTF_APPROVAL_REMINDER -- l_requester='||l_requester);
1074: END IF;
1075:
1076: l_requester_note := wf_engine.getitemattrtext
1077: (

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

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

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

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

Line 1109: AHL_DEBUG_PUB.DISABLE_DEBUG;

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

Line 1178: AHL_DEBUG_PUB.ENABLE_DEBUG;

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

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

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

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

1209: ,itemkey => l_item_key
1210: ,aname => 'ERROR_MSG'
1211: );
1212: IF G_DEBUG='Y' THEN
1213: AHL_DEBUG_PUB.debug('UC: 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: NTF_ERROR_ACT -- document='||document);

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

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

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

Line 1240: AHL_DEBUG_PUB.DISABLE_DEBUG;

1236: END IF;
1237:
1238: IF G_DEBUG='Y' THEN
1239: AHL_DEBUG_PUB.debug( 'END UC Ntfy error , l_object_id =' || l_object_id );
1240: AHL_DEBUG_PUB.DISABLE_DEBUG;
1241: END IF;
1242:
1243: RETURN;
1244:

Line 1324: AHL_DEBUG_PUB.ENABLE_DEBUG;

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

Line 1325: AHL_DEBUG_PUB.debug( 'UC:Start Update Status API');

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

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

1338: );
1339:
1340:
1341: IF G_DEBUG='Y' THEN
1342: AHL_DEBUG_PUB.debug('UC: UPDATE_STATUS -- l_approval_status='||l_approval_status);
1343: END IF;
1344:
1345: /* l_original_status := wf_engine.getitemattrtext
1346: (

Line 1352: AHL_DEBUG_PUB.debug('UC: UPDATE_STATUS -- l_original_status='||l_original_status);

1348: itemkey => itemkey,
1349: aname => 'ORIG_STATUS_ID'
1350: );
1351: IF G_DEBUG='Y' THEN
1352: AHL_DEBUG_PUB.debug('UC: UPDATE_STATUS -- l_original_status='||l_original_status);
1353: END IF;
1354: */
1355: l_object_version_number := wf_engine.getitemattrnumber
1356: (

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

1359: aname => 'OBJECT_VER'
1360: );
1361:
1362: IF G_DEBUG='Y' THEN
1363: AHL_DEBUG_PUB.debug('UC: UPDATE_STATUS --> l_object_version_number='||l_object_version_number);
1364: END IF;
1365:
1366: l_object_id := wf_engine.getitemattrnumber
1367: (

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

1370: aname => 'OBJECT_ID'
1371: );
1372:
1373: IF G_DEBUG='Y' THEN
1374: AHL_DEBUG_PUB.debug('UC: UPDATE_STATUS --> l_object_id='||l_object_id);
1375: END IF;
1376:
1377: OPEN get_uc_header_det(l_object_id);
1378: FETCH get_uc_header_det into l_uc_header_rec;

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

1393:
1394: fnd_message.set_name('AHL', 'AHL_COM_RECORD_CHANGED');
1395:
1396: IF G_DEBUG='Y' THEN
1397: AHL_DEBUG_PUB.debug('UC: UPDATE_STATUS check_uc_ovn --> fnd_message='||fnd_message.get );
1398: END IF;
1399:
1400: RAISE FND_API.G_EXC_ERROR;
1401: END IF;

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

1411: x_error_msg => l_error_msg
1412: );
1413:
1414: IF G_DEBUG='Y' THEN
1415: AHL_DEBUG_PUB.debug('UC:AHL_UC_WF_APPR_PVT.update_status -->l_msg_count...... ' || l_msg_count);
1416: AHL_DEBUG_PUB.debug('UC:AHL_UC_WF_APPR_PVT.update_status -->l_error_msg...... ' || l_error_msg);
1417: AHL_DEBUG_PUB.debug('UC:AHL_UC_WF_APPR_PVT.update_status -->l_msg_data...... ' || l_msg_data);
1418: AHL_DEBUG_PUB.debug('UC:AHL_UC_WF_APPR_PVT.update_status --> Before call to complete_uc_approval ');
1419: END IF;

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

1412: );
1413:
1414: IF G_DEBUG='Y' THEN
1415: AHL_DEBUG_PUB.debug('UC:AHL_UC_WF_APPR_PVT.update_status -->l_msg_count...... ' || l_msg_count);
1416: AHL_DEBUG_PUB.debug('UC:AHL_UC_WF_APPR_PVT.update_status -->l_error_msg...... ' || l_error_msg);
1417: AHL_DEBUG_PUB.debug('UC:AHL_UC_WF_APPR_PVT.update_status -->l_msg_data...... ' || l_msg_data);
1418: AHL_DEBUG_PUB.debug('UC:AHL_UC_WF_APPR_PVT.update_status --> Before call to complete_uc_approval ');
1419: END IF;
1420:

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

1413:
1414: IF G_DEBUG='Y' THEN
1415: AHL_DEBUG_PUB.debug('UC:AHL_UC_WF_APPR_PVT.update_status -->l_msg_count...... ' || l_msg_count);
1416: AHL_DEBUG_PUB.debug('UC:AHL_UC_WF_APPR_PVT.update_status -->l_error_msg...... ' || l_error_msg);
1417: AHL_DEBUG_PUB.debug('UC:AHL_UC_WF_APPR_PVT.update_status -->l_msg_data...... ' || l_msg_data);
1418: AHL_DEBUG_PUB.debug('UC:AHL_UC_WF_APPR_PVT.update_status --> Before call to complete_uc_approval ');
1419: END IF;
1420:
1421: --CALL AHL_UC_APPROVALS_PVT.complete_uc_approvals

Line 1418: AHL_DEBUG_PUB.debug('UC:AHL_UC_WF_APPR_PVT.update_status --> Before call to complete_uc_approval ');

1414: IF G_DEBUG='Y' THEN
1415: AHL_DEBUG_PUB.debug('UC:AHL_UC_WF_APPR_PVT.update_status -->l_msg_count...... ' || l_msg_count);
1416: AHL_DEBUG_PUB.debug('UC:AHL_UC_WF_APPR_PVT.update_status -->l_error_msg...... ' || l_error_msg);
1417: AHL_DEBUG_PUB.debug('UC:AHL_UC_WF_APPR_PVT.update_status -->l_msg_data...... ' || l_msg_data);
1418: AHL_DEBUG_PUB.debug('UC:AHL_UC_WF_APPR_PVT.update_status --> Before call to complete_uc_approval ');
1419: END IF;
1420:
1421: --CALL AHL_UC_APPROVALS_PVT.complete_uc_approvals
1422: AHL_UC_APPROVALS_PVT.complete_uc_approval(

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

1433: );
1434:
1435:
1436: IF G_DEBUG='Y' THEN
1437: AHL_DEBUG_PUB.debug('SQLERRM' || SQLERRM );
1438: AHL_DEBUG_PUB.debug('l_return_status' || l_return_status);
1439: AHL_DEBUG_PUB.debug('l_msg_count' || l_msg_count);
1440: AHL_DEBUG_PUB.debug('l_msg_data' || l_msg_data);
1441: AHL_DEBUG_PUB.debug('UC:AHL_UC_WF_APPR_PVT.update_status -- Completed call to complete_uc_approval ');

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

1434:
1435:
1436: IF G_DEBUG='Y' THEN
1437: AHL_DEBUG_PUB.debug('SQLERRM' || SQLERRM );
1438: AHL_DEBUG_PUB.debug('l_return_status' || l_return_status);
1439: AHL_DEBUG_PUB.debug('l_msg_count' || l_msg_count);
1440: AHL_DEBUG_PUB.debug('l_msg_data' || l_msg_data);
1441: AHL_DEBUG_PUB.debug('UC:AHL_UC_WF_APPR_PVT.update_status -- Completed call to complete_uc_approval ');
1442: END IF;

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

1435:
1436: IF G_DEBUG='Y' THEN
1437: AHL_DEBUG_PUB.debug('SQLERRM' || SQLERRM );
1438: AHL_DEBUG_PUB.debug('l_return_status' || l_return_status);
1439: AHL_DEBUG_PUB.debug('l_msg_count' || l_msg_count);
1440: AHL_DEBUG_PUB.debug('l_msg_data' || l_msg_data);
1441: AHL_DEBUG_PUB.debug('UC:AHL_UC_WF_APPR_PVT.update_status -- Completed call to complete_uc_approval ');
1442: END IF;
1443:

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

1436: IF G_DEBUG='Y' THEN
1437: AHL_DEBUG_PUB.debug('SQLERRM' || SQLERRM );
1438: AHL_DEBUG_PUB.debug('l_return_status' || l_return_status);
1439: AHL_DEBUG_PUB.debug('l_msg_count' || l_msg_count);
1440: AHL_DEBUG_PUB.debug('l_msg_data' || l_msg_data);
1441: AHL_DEBUG_PUB.debug('UC:AHL_UC_WF_APPR_PVT.update_status -- Completed call to complete_uc_approval ');
1442: END IF;
1443:
1444: IF G_DEBUG='Y' THEN

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

1437: AHL_DEBUG_PUB.debug('SQLERRM' || SQLERRM );
1438: AHL_DEBUG_PUB.debug('l_return_status' || l_return_status);
1439: AHL_DEBUG_PUB.debug('l_msg_count' || l_msg_count);
1440: AHL_DEBUG_PUB.debug('l_msg_data' || l_msg_data);
1441: AHL_DEBUG_PUB.debug('UC:AHL_UC_WF_APPR_PVT.update_status -- Completed call to complete_uc_approval ');
1442: END IF;
1443:
1444: IF G_DEBUG='Y' THEN
1445: AHL_DEBUG_PUB.debug( 'UC:End Update Status API, l_object_id =' || l_object_id );

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

1441: AHL_DEBUG_PUB.debug('UC:AHL_UC_WF_APPR_PVT.update_status -- Completed call to complete_uc_approval ');
1442: END IF;
1443:
1444: IF G_DEBUG='Y' THEN
1445: AHL_DEBUG_PUB.debug( 'UC:End Update Status API, l_object_id =' || l_object_id );
1446: AHL_DEBUG_PUB.DISABLE_DEBUG;
1447: END IF;
1448:
1449: resultout := 'COMPLETE:SUCCESS';

Line 1446: AHL_DEBUG_PUB.DISABLE_DEBUG;

1442: END IF;
1443:
1444: IF G_DEBUG='Y' THEN
1445: AHL_DEBUG_PUB.debug( 'UC:End Update Status API, l_object_id =' || l_object_id );
1446: AHL_DEBUG_PUB.DISABLE_DEBUG;
1447: END IF;
1448:
1449: resultout := 'COMPLETE:SUCCESS';
1450: RETURN;

Line 1555: AHL_DEBUG_PUB.ENABLE_DEBUG;

1551:
1552: BEGIN
1553:
1554: IF G_DEBUG='Y' THEN
1555: AHL_DEBUG_PUB.ENABLE_DEBUG;
1556: AHL_DEBUG_PUB.debug( 'UC:Start Revert Status');
1557: END IF;
1558:
1559: --

Line 1556: AHL_DEBUG_PUB.debug( 'UC:Start Revert Status');

1552: BEGIN
1553:
1554: IF G_DEBUG='Y' THEN
1555: AHL_DEBUG_PUB.ENABLE_DEBUG;
1556: AHL_DEBUG_PUB.debug( 'UC:Start Revert Status');
1557: END IF;
1558:
1559: --
1560: -- RUN mode

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

1567: ,itemkey => itemkey
1568: ,aname => 'ORG_STATUS_ID'
1569: );
1570: IF G_DEBUG='Y' THEN
1571: AHL_DEBUG_PUB.debug('UC: REVERT_STATUS -- l_next_status'||l_next_status);
1572: END IF;
1573:
1574: l_object_version_number := wf_engine.getitemattrnumber
1575: (

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

1578: ,aname => 'OBJECT_VER'
1579: );
1580:
1581: IF G_DEBUG='Y' THEN
1582: AHL_DEBUG_PUB.debug('UC: REVERT_STATUS -- l_object_version_number'||l_object_version_number);
1583: END IF;
1584:
1585: l_object_id := wf_engine.getitemattrnumber
1586: (

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

1589: ,aname => 'OBJECT_ID'
1590: );
1591:
1592: IF G_DEBUG='Y' THEN
1593: AHL_DEBUG_PUB.debug('UC: REVERT_STATUS -- l_object_id'||l_object_id);
1594: END IF;
1595:
1596: OPEN get_uc_header_det(l_object_id);
1597: FETCH get_uc_header_det into l_uc_header_rec;

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

1638: END IF;
1639: CLOSE check_uc_ovn;
1640:
1641: IF G_DEBUG='Y' THEN
1642: AHL_DEBUG_PUB.debug('UC: REVERT_STATUS --> Completed resetting of status');
1643: AHL_DEBUG_PUB.debug('UC:END Revert Status, l_object_id =' || l_object_id );
1644: AHL_DEBUG_PUB.DISABLE_DEBUG;
1645: END IF;
1646:

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

1639: CLOSE check_uc_ovn;
1640:
1641: IF G_DEBUG='Y' THEN
1642: AHL_DEBUG_PUB.debug('UC: REVERT_STATUS --> Completed resetting of status');
1643: AHL_DEBUG_PUB.debug('UC:END Revert Status, l_object_id =' || l_object_id );
1644: AHL_DEBUG_PUB.DISABLE_DEBUG;
1645: END IF;
1646:
1647: resultout := 'COMPLETE:';

Line 1644: AHL_DEBUG_PUB.DISABLE_DEBUG;

1640:
1641: IF G_DEBUG='Y' THEN
1642: AHL_DEBUG_PUB.debug('UC: REVERT_STATUS --> Completed resetting of status');
1643: AHL_DEBUG_PUB.debug('UC:END Revert Status, l_object_id =' || l_object_id );
1644: AHL_DEBUG_PUB.DISABLE_DEBUG;
1645: END IF;
1646:
1647: resultout := 'COMPLETE:';
1648: RETURN;