[Home] [Help]
84: */
85:
86: EXCEPTION
87: WHEN OTHERS THEN
88: dbms_output.put_line('exception occurred in delete_po_notif ');
89: PO_MESSAGE_S.SQL_ERROR('DELETE_PO_NOTIF', x_progress, sqlcode);
90: RAISE;
91: END;
92:
122: x_progress := '020';
123: FETCH C into x_notification_id;
124: EXIT WHEN C%NOTFOUND;
125:
126: dbms_output.put_line('before deleting notifications');
127:
128: -- Call the procedure to delete notifications.
129:
130: ntn.delete_notification(x_notification_id, x_return_code);
128: -- Call the procedure to delete notifications.
129:
130: ntn.delete_notification(x_notification_id, x_return_code);
131:
132: dbms_output.put_line('after deleting notifications');
133:
134: END LOOP;
135: CLOSE C;
136: */
136: */
137:
138: EXCEPTION
139: WHEN OTHERS THEN
140: dbms_output.put_line('exception occurred in delete_notif_by_id_type');
141: PO_MESSAGE_S.SQL_ERROR('DELETE_NOTIF_BY_ID_TYPE', x_progress, sqlcode);
142: RAISE;
143: END;
144:
355: END IF; */
356:
357: EXCEPTION
358: WHEN OTHERS THEN
359: dbms_output.put_line('Exception occurred in send_po_notif');
360: PO_MESSAGE_S.SQL_ERROR('SEND_PO_NOTIFICATION', x_progress, sqlcode);
361: RAISE;
362: END;
363:
598: END IF;
599:
600: EXCEPTION
601: WHEN OTHERS THEN
602: dbms_output.put_line('Exception occurred when selecting from header table');
603: dbms_output.put_line('Document is '||x_document_type_code||' '||TO_CHAR(x_object_id));
604: RAISE;
605: END;
606:
599:
600: EXCEPTION
601: WHEN OTHERS THEN
602: dbms_output.put_line('Exception occurred when selecting from header table');
603: dbms_output.put_line('Document is '||x_document_type_code||' '||TO_CHAR(x_object_id));
604: RAISE;
605: END;
606:
607: IF x_message_name IS NOT NULL THEN
605: END;
606:
607: IF x_message_name IS NOT NULL THEN
608:
609: dbms_output.put_line('Message name is '||x_message_name);
610:
611: -- Determine the type and subtype of the document based on
612: -- doc_type from the fnd_notifications table.
613:
610:
611: -- Determine the type and subtype of the document based on
612: -- doc_type from the fnd_notifications table.
613:
614: dbms_output.put_line('before call to get_doc_type_subtype');
615: po_notifications_sv2.get_doc_type_subtype(x_document_type_code,
616: x_type,
617: x_subtype);
618:
628: -- should only be necessary for release notifications (when the PO or PA becomes
629: -- unapproved and the notification for the release is updated) and
630: -- for notifications that are transfered from po_notifications.
631:
632: dbms_output.put_line('before select from po_action_history');
633:
634: BEGIN
635:
636: SELECT poa.employee_id,
668:
669: END IF;
670: END IF;
671:
672: dbms_output.put_line('Forward-from id = '||x_from_id);
673:
674: IF (x_message_name = 'AWAITING_YOUR_APPROVAL' and x_employee_id IS NULL) THEN
675:
676: -- Find the id of the recipient from po_action_history. This should only
687: AND action_code IS NULL;
688:
689: EXCEPTION
690: WHEN OTHERS THEN
691: dbms_output.put_line('Cannot get employee_id from po_action_history');
692: RAISE;
693: END;
694:
695: END IF;
696:
697: -- Copy value from local variable into OUT variable.
698:
699: x_employee_id := x_forward_to_id;
700: dbms_output.put_line('Forward-to id = '||x_employee_id);
701:
702: -- Document number is segment1-release_num
703:
704: IF x_attribute_array(RELEASE_NUM) IS NULL THEN
708: END IF;
709:
710: -- Determine the displayed value for document authorization_status
711:
712: dbms_output.put_line('before select from po_lookup_codes');
713:
714: BEGIN
715:
716: SELECT displayed_field
720: AND lookup_code = x_attribute_array(AUTHORIZATION_STATUS);
721:
722: EXCEPTION
723: WHEN OTHERS THEN
724: dbms_output.put_line('cannot get displayed value for authorization status');
725: x_attribute_array(AUTHORIZATION_STATUS_DISP) := NULL;
726: END;
727:
728: IF x_message_name = 'ACCEPTANCE_PAST_DUE' THEN
759: */
760:
761: EXCEPTION
762: WHEN OTHERS THEN
763: dbms_output.put_line('In Exception');
764: PO_MESSAGE_S.SQL_ERROR('GET_NOTIF_DATA', x_progress, sqlcode);
765: RAISE;
766: END;
767: