101: m4u_dmd_utils.log('l_ret_sts - |' || l_ret_sts || '|',1);
102: m4u_dmd_utils.log('l_ret_msg - |' || l_ret_msg || '|',1);
103: m4u_dmd_utils.log('l_msg_id - |' || l_msg_id || '|',1);
104:
105: IF l_ret_sts <> fnd_api.g_ret_sts_success THEN
106: l_err_msg := l_ret_msg;
107: RAISE fnd_api.g_exc_error;
108: END IF;
109:
103: m4u_dmd_utils.log('l_msg_id - |' || l_msg_id || '|',1);
104:
105: IF l_ret_sts <> fnd_api.g_ret_sts_success THEN
106: l_err_msg := l_ret_msg;
107: RAISE fnd_api.g_exc_error;
108: END IF;
109:
110: m4u_dmd_utils.log('Call m4u_dmd_requests.create_document' ,1);
111:
138: m4u_dmd_utils.log('l_ret_sts - |' || l_ret_sts || '|',1);
139: m4u_dmd_utils.log('l_ret_msg - |' || l_ret_msg || '|',1);
140: m4u_dmd_utils.log('l_doc_id - |' || l_doc_id || '|',1);
141:
142: IF l_ret_sts <> fnd_api.g_ret_sts_success THEN
143: l_err_msg := l_ret_msg;
144: RAISE fnd_api.g_exc_error;
145: END IF;
146:
140: m4u_dmd_utils.log('l_doc_id - |' || l_doc_id || '|',1);
141:
142: IF l_ret_sts <> fnd_api.g_ret_sts_success THEN
143: l_err_msg := l_ret_msg;
144: RAISE fnd_api.g_exc_error;
145: END IF;
146:
147: x_ret_sts := fnd_api.g_ret_sts_success;
148: x_ret_msg := '';
143: l_err_msg := l_ret_msg;
144: RAISE fnd_api.g_exc_error;
145: END IF;
146:
147: x_ret_sts := fnd_api.g_ret_sts_success;
148: x_ret_msg := '';
149: x_msg_id := l_msg_id;
150:
151: m4u_dmd_utils.log('Exiting m4u_dmd_request.send_rfcin - Success' ,2);
231: m4u_dmd_utils.log('l_ret_sts - |' || l_ret_sts || '|',1);
232: m4u_dmd_utils.log('l_ret_msg - |' || l_ret_msg || '|',1);
233: m4u_dmd_utils.log('l_msg_id - |' || l_msg_id || '|',1);
234:
235: IF l_ret_sts <> fnd_api.g_ret_sts_success THEN
236: l_err_msg := l_ret_msg;
237: RAISE fnd_api.g_exc_error;
238: END IF;
239:
233: m4u_dmd_utils.log('l_msg_id - |' || l_msg_id || '|',1);
234:
235: IF l_ret_sts <> fnd_api.g_ret_sts_success THEN
236: l_err_msg := l_ret_msg;
237: RAISE fnd_api.g_exc_error;
238: END IF;
239:
240: m4u_dmd_utils.log('Call m4u_dmd_requests.create_document' ,1);
241: m4u_dmd_requests.create_document
267: m4u_dmd_utils.log('l_ret_sts - |' || l_ret_sts || '|',1);
268: m4u_dmd_utils.log('l_ret_msg - |' || l_ret_msg || '|',1);
269: m4u_dmd_utils.log('l_doc_id - |' || l_doc_id || '|',1);
270:
271: IF l_ret_sts <> fnd_api.g_ret_sts_success THEN
272: l_err_msg := l_ret_msg;
273: RAISE fnd_api.g_exc_error;
274: END IF;
275:
269: m4u_dmd_utils.log('l_doc_id - |' || l_doc_id || '|',1);
270:
271: IF l_ret_sts <> fnd_api.g_ret_sts_success THEN
272: l_err_msg := l_ret_msg;
273: RAISE fnd_api.g_exc_error;
274: END IF;
275:
276: x_ret_sts := fnd_api.g_ret_sts_success;
277: x_ret_msg := '';
272: l_err_msg := l_ret_msg;
273: RAISE fnd_api.g_exc_error;
274: END IF;
275:
276: x_ret_sts := fnd_api.g_ret_sts_success;
277: x_ret_msg := '';
278: x_msg_id := l_msg_id;
279:
280: m4u_dmd_utils.log('Exiting m4u_dmd_request.send_cis - Success' ,2);
347: m4u_dmd_utils.log('l_ret_msg - |' || l_ret_msg || '|',1);
348: m4u_dmd_utils.log('l_msg_id - |' || l_msg_id || '|',1);
349:
350:
351: IF l_ret_sts <> fnd_api.g_ret_sts_success THEN
352: l_err_msg := l_ret_msg;
353: RAISE fnd_api.g_exc_error;
354: END IF;
355:
349:
350:
351: IF l_ret_sts <> fnd_api.g_ret_sts_success THEN
352: l_err_msg := l_ret_msg;
353: RAISE fnd_api.g_exc_error;
354: END IF;
355:
356: x_ret_sts := fnd_api.g_ret_sts_success;
357: x_ret_msg := '';
352: l_err_msg := l_ret_msg;
353: RAISE fnd_api.g_exc_error;
354: END IF;
355:
356: x_ret_sts := fnd_api.g_ret_sts_success;
357: x_ret_msg := '';
358:
359: m4u_dmd_utils.log('Exiting m4u_dmd_request.send_cin_ack - Success' ,2);
360: RETURN; --success
422: m4u_dmd_utils.log('l_ret_sts - |' || l_ret_sts || '|',1);
423: m4u_dmd_utils.log('l_ret_msg - |' || l_ret_msg || '|',1);
424: m4u_dmd_utils.log('l_payload_id - |' || l_payload_id|| '|',1);
425:
426: IF l_ret_sts <> fnd_api.g_ret_sts_success THEN
427: l_err_msg := l_ret_msg;
428: RAISE fnd_api.g_exc_error;
429: END IF;
430:
424: m4u_dmd_utils.log('l_payload_id - |' || l_payload_id|| '|',1);
425:
426: IF l_ret_sts <> fnd_api.g_ret_sts_success THEN
427: l_err_msg := l_ret_msg;
428: RAISE fnd_api.g_exc_error;
429: END IF;
430:
431: m4u_dmd_utils.log('Call create_dom_from_clob_pvt' ,1);
432: create_dom_from_clob_pvt
499: m4u_dmd_utils.log('l_ret_msg - |' || l_ret_msg || '|',1);
500: m4u_dmd_utils.log('l_msg_id - |' || l_msg_id || '|',1);
501:
502:
503: IF l_ret_sts <> fnd_api.g_ret_sts_success THEN
504: l_err_msg := l_ret_msg;
505: RAISE fnd_api.g_exc_error;
506: END IF;
507:
501:
502:
503: IF l_ret_sts <> fnd_api.g_ret_sts_success THEN
504: l_err_msg := l_ret_msg;
505: RAISE fnd_api.g_exc_error;
506: END IF;
507:
508: l_doc_nodes := xslprocessor.selectnodes (l_msg_node,
509: './*[local-name()="ItemPublicationLineConfirmation"]');
575: m4u_dmd_utils.log('l_ret_msg - |' || l_ret_msg || '|',1);
576: m4u_dmd_utils.log('l_doc_id - |' || l_doc_id || '|',1);
577:
578:
579: IF l_ret_sts <> fnd_api.g_ret_sts_success THEN
580: l_err_msg := l_ret_msg;
581: RAISE fnd_api.g_exc_error;
582: END IF;
583: END LOOP;
577:
578:
579: IF l_ret_sts <> fnd_api.g_ret_sts_success THEN
580: l_err_msg := l_ret_msg;
581: RAISE fnd_api.g_exc_error;
582: END IF;
583: END LOOP;
584:
585: m4u_dmd_utils.log('Processed l_msg_idx -|' ||l_msg_idx || ' |' ,1);
587:
588: END LOOP;
589:
590:
591: x_ret_sts := fnd_api.g_ret_sts_success;
592: x_ret_msg := '';
593:
594: m4u_dmd_utils.log('Exiting m4u_dmd_request.send_cic - Success' ,2);
595: COMMIT;
663: m4u_dmd_utils.log('l_ret_sts - |' || l_ret_sts || '|',1);
664: m4u_dmd_utils.log('l_ret_msg - |' || l_ret_msg || '|',1);
665: m4u_dmd_utils.log('l_payload_id - |' || l_payload_id|| '|',1);
666:
667: IF l_ret_sts <> fnd_api.g_ret_sts_success THEN
668: l_err_msg := l_ret_msg;
669: RAISE fnd_api.g_exc_error;
670: END IF;
671:
665: m4u_dmd_utils.log('l_payload_id - |' || l_payload_id|| '|',1);
666:
667: IF l_ret_sts <> fnd_api.g_ret_sts_success THEN
668: l_err_msg := l_ret_msg;
669: RAISE fnd_api.g_exc_error;
670: END IF;
671:
672: m4u_dmd_utils.log('Call create_dom_from_clob_pvt' ,1);
673: create_dom_from_clob_pvt
724: m4u_dmd_utils.log('l_ret_msg - |' || l_ret_msg || '|',1);
725: m4u_dmd_utils.log('l_msg_id - |' || l_cin_msg_id|| '|',1);
726:
727:
728: IF l_ret_sts <> fnd_api.g_ret_sts_success THEN
729: l_err_msg := l_ret_msg;
730: RAISE fnd_api.g_exc_error;
731: END IF;
732:
726:
727:
728: IF l_ret_sts <> fnd_api.g_ret_sts_success THEN
729: l_err_msg := l_ret_msg;
730: RAISE fnd_api.g_exc_error;
731: END IF;
732:
733:
734: l_doc_nodes := xslprocessor.selectnodes (l_node,'/*[local-name()="envelope"]/*[local-name()="catalogueItemNotification"]/*[local-name()="document"]');
788: m4u_dmd_utils.log('l_ret_msg - |' || l_ret_msg || '|',1);
789: m4u_dmd_utils.log('l_doc_id - |' || l_doc_id || '|',1);
790:
791:
792: IF l_ret_sts <> fnd_api.g_ret_sts_success THEN
793: l_err_msg := l_ret_msg;
794: RAISE fnd_api.g_exc_error;
795: END IF;
796: END LOOP;
790:
791:
792: IF l_ret_sts <> fnd_api.g_ret_sts_success THEN
793: l_err_msg := l_ret_msg;
794: RAISE fnd_api.g_exc_error;
795: END IF;
796: END LOOP;
797:
798:
809: m4u_dmd_utils.log('l_ret_sts - |' || l_ret_sts || '|',1);
810: m4u_dmd_utils.log('l_ret_msg - |' || l_ret_msg || '|',1);
811: m4u_dmd_utils.log('l_cin_ack_msg_id - |' || l_cin_ack_msg_id|| '|',1);
812:
813: IF l_ret_sts <> fnd_api.g_ret_sts_success THEN
814: l_err_msg := l_ret_msg;
815: RAISE fnd_api.g_exc_error;
816: END IF;
817:
811: m4u_dmd_utils.log('l_cin_ack_msg_id - |' || l_cin_ack_msg_id|| '|',1);
812:
813: IF l_ret_sts <> fnd_api.g_ret_sts_success THEN
814: l_err_msg := l_ret_msg;
815: RAISE fnd_api.g_exc_error;
816: END IF;
817:
818: x_ret_sts := fnd_api.g_ret_sts_success;
819: x_ret_msg := '';
814: l_err_msg := l_ret_msg;
815: RAISE fnd_api.g_exc_error;
816: END IF;
817:
818: x_ret_sts := fnd_api.g_ret_sts_success;
819: x_ret_msg := '';
820: x_msg_id := l_cin_msg_id;
821:
822: m4u_dmd_utils.log('Exiting m4u_dmd_request.send_cic - Success' ,2);