APPS.M4U_DMD_REQUESTS dependencies on M4U_DMD_MESSAGES

Line 4: -- Table handler for m4u_dmd_messages

1: PACKAGE BODY m4u_dmd_requests AS
2: /* $Header: M4UDREQB.pls 120.3 2007/09/12 06:57:29 bsaratna noship $ */
3:
4: -- Table handler for m4u_dmd_messages
5: -- create request record based on input paramters
6: -- returns created message_id, api return status
7: PROCEDURE create_request
8: (

Line 112: m4u_dmd_utils.log('insert into m4u_dmd_messages' ,1);

108: FROM DUAL;
109:
110:
111: m4u_dmd_utils.log('l_msg_id -|'|| l_msg_id ||'|',1);
112: m4u_dmd_utils.log('insert into m4u_dmd_messages' ,1);
113:
114:
115:
116: IF p_orig_msg_id = 'GENERATE' THEN

Line 123: INSERT INTO m4u_dmd_messages

119: ELSE
120: l_orig_msg_id := p_orig_msg_id;
121: END IF;
122:
123: INSERT INTO m4u_dmd_messages
124: (
125: msg_id, ref_msg_id, type, direction, status, retry_count,
126: orig_msg_id, sender_gln, receiver_gln, rep_party_gln,
127: user_gln,user_id, msg_timestamp, payload_id,

Line 249: m4u_dmd_utils.log('m4u_dmd_messages.create_payload', 6);

245:
246: m4u_dmd_utils.log('l_payload_evt_key - |' || l_payload_evt_key || '|',2);
247: EXCEPTION
248: WHEN OTHERS THEN
249: m4u_dmd_utils.log('m4u_dmd_messages.create_payload', 6);
250: m4u_dmd_utils.log('Unexpected error while raising payload event',6);
251: m4u_dmd_utils.log(SQLCODE || SQLERRM, 6);
252: END;
253:

Line 519: m4u_dmd_utils.log('m4u_dmd_messages.create_document', 6);

515: );
516: m4u_dmd_utils.log('l_cln_evt_key - |' || l_cln_evt_key || '|',2);
517: EXCEPTION
518: WHEN OTHERS THEN
519: m4u_dmd_utils.log('m4u_dmd_messages.create_document', 6);
520: m4u_dmd_utils.log('Unexpected error while raising payload event',6);
521: m4u_dmd_utils.log(SQLCODE || SQLERRM, 6);
522:
523: END;

Line 594: FROM m4u_dmd_messages

590: END;
591: --validation block ends
592: SELECT retry_count
593: INTO l_retry_count
594: FROM m4u_dmd_messages
595: WHERE msg_id = p_msg_id;
596:
597: m4u_dmd_utils.log('Old l_retry_count -|'|| l_retry_count ||'|',1);
598:

Line 601: UPDATE m4u_dmd_messages

597: m4u_dmd_utils.log('Old l_retry_count -|'|| l_retry_count ||'|',1);
598:
599: l_retry_count := l_retry_count+1;
600:
601: UPDATE m4u_dmd_messages
602: SET status = m4u_dmd_utils.c_sts_ready,
603: retry_count = l_retry_count,
604: orig_msg_id = type || '.' || sysdate || '.' ||
605: l_retry_count || '.' || p_msg_id

Line 799: FROM m4u_dmd_messages

795:
796:
797: SELECT msg_id, retry_count
798: INTO l_msg_id, l_retry_count
799: FROM m4u_dmd_messages
800: WHERE orig_msg_id = p_orig_msg_id
801: OR msg_id = p_msg_id;
802:
803: IF p_retry_count IS NOT NULL AND

Line 818: m4u_dmd_utils.log('UPDATE m4u_dmd_messages' ,1);

814: m4u_dmd_utils.log('Exiting validation block - success',2);
815: END;
816: -- validation block ends
817:
818: m4u_dmd_utils.log('UPDATE m4u_dmd_messages' ,1);
819: UPDATE m4u_dmd_messages
820: SET
821: ref_msg_id = NVL(p_ref_msg_id, ref_msg_id ),
822: orig_msg_id = NVL(p_orig_msg_id, orig_msg_id ),

Line 819: UPDATE m4u_dmd_messages

815: END;
816: -- validation block ends
817:
818: m4u_dmd_utils.log('UPDATE m4u_dmd_messages' ,1);
819: UPDATE m4u_dmd_messages
820: SET
821: ref_msg_id = NVL(p_ref_msg_id, ref_msg_id ),
822: orig_msg_id = NVL(p_orig_msg_id, orig_msg_id ),
823: status = NVL(p_status, status ),

Line 1231: m4u_dmd_utils.log('m4u_dmd_messages.create_document', 6);

1227: p_parameters => l_cln_evt_params
1228: );
1229: EXCEPTION
1230: WHEN OTHERS THEN
1231: m4u_dmd_utils.log('m4u_dmd_messages.create_document', 6);
1232: m4u_dmd_utils.log('Unexpected error while raising payload event',6);
1233: m4u_dmd_utils.log(SQLCODE || SQLERRM, 6);
1234:
1235: END;