APPS.M4U_DMD_REQUESTS dependencies on M4U_DMD_REQUESTS

Line 1: PACKAGE BODY m4u_dmd_requests AS

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

Line 27: l_err_api VARCHAR2(50) := 'm4u_dmd_requests.create_request';

23: x_ret_msg OUT NOCOPY VARCHAR2
24: )
25: IS
26: l_msg_id VARCHAR2(30);
27: l_err_api VARCHAR2(50) := 'm4u_dmd_requests.create_request';
28: l_err_msg VARCHAR2(2000);
29: l_param VARCHAR2(100);
30: l_value VARCHAR2(4000);
31: l_orig_msg_id VARCHAR2(80);

Line 171: l_err_api VARCHAR2(50) := 'm4u_dmd_requests.create_payload';

167: IS
168: l_payload_id NUMBER;
169: l_payload_evt_key VARCHAR2(100);
170: l_params wf_parameter_list_t;
171: l_err_api VARCHAR2(50) := 'm4u_dmd_requests.create_payload';
172: l_err_msg VARCHAR2(2000);
173: l_param VARCHAR2(100);
174: l_value VARCHAR2(4000);
175:

Line 308: l_err_api VARCHAR2(50) := 'm4u_dmd_requests.create_document';

304: IS
305: l_doc_id VARCHAR2(30);
306: l_cln_evt_key VARCHAR2(30);
307: l_cln_evt_params wf_parameter_list_t;
308: l_err_api VARCHAR2(50) := 'm4u_dmd_requests.create_document';
309: l_err_msg VARCHAR2(2000);
310: l_param VARCHAR2(100);
311: l_value VARCHAR2(4000);
312: l_orig_doc_id VARCHAR2(80);

Line 549: l_err_api VARCHAR2(50) := 'm4u_dmd_requests.rerty_request';

545: )
546: IS
547: l_ret_sts VARCHAR2(30);
548: l_ret_msg VARCHAR2(50);
549: l_err_api VARCHAR2(50) := 'm4u_dmd_requests.rerty_request';
550: l_err_msg VARCHAR2(2000);
551: l_retry_count NUMBER;
552: l_param VARCHAR2(100);
553: l_value VARCHAR2(4000);

Line 626: m4u_dmd_requests.update_document

622: OR (p_mode = m4u_dmd_utils.c_retry_err AND
623: l_doc_rec.doc_status = m4u_dmd_utils.c_sts_error)) THEN
624:
625:
626: m4u_dmd_requests.update_document
627: (
628: p_doc_id => l_doc_rec.doc_id,
629: p_retry_count => l_retry_count,
630: p_orig_doc_id => 'GENERATE',

Line 704: l_err_api VARCHAR2(50) := 'm4u_dmd_requests.update_request';

700: l_payload_id VARCHAR2(30);
701: l_msg_id VARCHAR2(30);
702: l_ret_sts VARCHAR2(5);
703: l_ret_msg VARCHAR2(400);
704: l_err_api VARCHAR2(50) := 'm4u_dmd_requests.update_request';
705: l_err_msg VARCHAR2(2000);
706: l_param VARCHAR2(100);
707: l_value VARCHAR2(4000);
708: l_retry_count NUMBER;

Line 844: m4u_dmd_utils.log('Call m4u_dmd_requests.create_payload' ,2);

840:
841: l_payload_id := null;
842:
843: IF p_payload IS NOT NULL THEN
844: m4u_dmd_utils.log('Call m4u_dmd_requests.create_payload' ,2);
845: l_ret_msg := '';
846: l_ret_sts := '';
847: m4u_dmd_requests.create_payload
848: (

Line 847: m4u_dmd_requests.create_payload

843: IF p_payload IS NOT NULL THEN
844: m4u_dmd_utils.log('Call m4u_dmd_requests.create_payload' ,2);
845: l_ret_msg := '';
846: l_ret_sts := '';
847: m4u_dmd_requests.create_payload
848: (
849: p_xml => p_payload,
850: p_type => p_payload_type,
851: p_dir => p_payload_dir,

Line 884: m4u_dmd_requests.update_document

880:
881: m4u_dmd_utils.log('Call update_document - ' || l_doc_rec.doc_id,1);
882: l_ret_msg := '';
883: l_ret_sts := '';
884: m4u_dmd_requests.update_document
885: (
886: p_doc_id => l_doc_rec.doc_id,
887: p_ref_doc_id => l_doc_rec.ref_doc_id,
888: p_doc_status => p_doc_status,

Line 960: l_err_api VARCHAR2(50) := 'm4u_dmd_requests.update_document';

956: )
957: IS
958: l_cln_evt_params wf_parameter_list_t;
959: l_cln_evt_key VARCHAR2(30);
960: l_err_api VARCHAR2(50) := 'm4u_dmd_requests.update_document';
961: l_err_msg VARCHAR2(2000);
962: l_param VARCHAR2(100);
963: l_value VARCHAR2(2000);
964: l_orig_doc_id VARCHAR2(80);

Line 1249: END m4u_dmd_requests;

1245: m4u_dmd_utils.handle_error(l_err_api,l_err_msg,
1246: SQLCODE,SQLERRM,x_ret_sts,x_ret_msg);
1247: END update_document;
1248:
1249: END m4u_dmd_requests;