DBA Data[Home] [Help]

APPS.ECX_DOCUMENT dependencies on ECX_DOCUMENT

Line 1: PACKAGE BODY ecx_document AS

1: PACKAGE BODY ecx_document AS
2: -- $Header: ECXSENDB.pls 120.10.12020000.4 2013/01/22 09:35:21 dhragarw ship $
3:
4: l_procedure PLS_INTEGER := ecx_debug.g_procedure;
5: l_statement PLS_INTEGER := ecx_debug.g_statement;

Line 26: i_method_name varchar2(2000) := 'ecx_document.getConfirmation';

22: i_party_site_id OUT NOCOPY number
23: )
24: is
25:
26: i_method_name varchar2(2000) := 'ecx_document.getConfirmation';
27:
28: i_location_code varchar2(200);
29: i_transaction_type varchar2(200);
30: i_transaction_subtype varchar2(200);

Line 149: ecx_debug.setErrorInfo(2,30,SQLERRM ||'- ECX_DOCUMENT.getConfirmation');

145: ecx_debug.pop(i_method_name);
146: end if;
147: raise ecx_utils.program_exit;
148: when others then
149: ecx_debug.setErrorInfo(2,30,SQLERRM ||'- ECX_DOCUMENT.getConfirmation');
150: if (l_procedureEnabled) then
151: ecx_debug.pop(i_method_name);
152: end if;
153: raise ecx_utils.program_exit;

Line 192: i_method_name varchar2(2000) := 'ecx_document.put_on_engqueue';

188: o_msgid out NOCOPY raw
189: )
190: is
191:
192: i_method_name varchar2(2000) := 'ecx_document.put_on_engqueue';
193:
194: v_message system.ecx_outengobj;
195: v_enqueueoptions dbms_aq.enqueue_options_t;
196: v_messageproperties dbms_aq.message_properties_t;

Line 279: ecx_debug.setErrorInfo(2,30,SQLERRM ||'- ECX_DOCUMENT.PUT_ON_ENGQUEUE');

275: ecx_debug.pop(i_method_name);
276: end if;
277: exception
278: when others then
279: ecx_debug.setErrorInfo(2,30,SQLERRM ||'- ECX_DOCUMENT.PUT_ON_ENGQUEUE');
280: if (l_procedureEnabled) then
281: ecx_debug.pop(i_method_name);
282: end if;
283: raise ecx_utils.program_exit;

Line 310: i_method_name varchar2(2000) := 'ecx_document.get_delivery_attribs';

306: i_tp_header_id OUT NOCOPY pls_integer
307: )
308: IS
309:
310: i_method_name varchar2(2000) := 'ecx_document.get_delivery_attribs';
311:
312: i_hub_user_id number;
313: i_transaction_id number;
314: i_hub_id number;

Line 514: ecx_debug.setErrorInfo(2,30,SQLERRM ||'- ECX_DOCUMENT.GET_DELIVERY_ATTRIBS');

510: ecx_debug.pop(i_method_name);
511: end if;
512: raise ecx_utils.program_exit;
513: WHEN OTHERS THEN
514: ecx_debug.setErrorInfo(2,30,SQLERRM ||'- ECX_DOCUMENT.GET_DELIVERY_ATTRIBS');
515: if (l_procedureEnabled) then
516: ecx_debug.pop(i_method_name);
517: end if;
518: raise ecx_utils.program_exit;

Line 618: i_method_name varchar2(2000) := 'ecx_document.trigger_outbound';

614: p_queue_name OUT NOCOPY varchar2,
615: p_tp_header_id OUT NOCOPY varchar2
616: )
617: is
618: i_method_name varchar2(2000) := 'ecx_document.trigger_outbound';
619: begin
620: -- if (logging_mode = 'Y') then
621: ecx_errorlog.outbound_trigger (
622: trigger_id,

Line 699: ecx_debug.setErrorInfo(2,30,SQLERRM ||'- ECX_DOCUMENT.TRIGGER_OUTBOUND');

695: ecx_debug.pop(i_method_name);
696: end if;
697: raise ecx_utils.program_exit;
698: when others then
699: ecx_debug.setErrorInfo(2,30,SQLERRM ||'- ECX_DOCUMENT.TRIGGER_OUTBOUND');
700: if (l_procedureEnabled) then
701: ecx_debug.pop(i_method_name);
702: end if;
703: raise ecx_utils.program_exit;

Line 727: i_method_name varchar2(2000) := 'ecx_document.send';

723: errmsg OUT NOCOPY VARCHAR2
724: ) IS
725: g_instlmode VARCHAR2(100);
726: i_debug_level pls_integer;
727: i_method_name varchar2(2000) := 'ecx_document.send';
728:
729: i_path varchar2(80);
730: v_message system.ecx_outengobj;
731:

Line 948: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SEND',

944: retcode := ecx_utils.i_ret_code;
945: errmsg := ecx_utils.i_errbuf;
946: if(l_unexpectedEnabled) then
947: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
948: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SEND',
949: i_method_name);
950: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
951: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
952: ecx_utils.i_errparams),i_method_name); --MLS

Line 982: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf ||SQLERRM||' at ECX_DOCUMENT.SEND',

978: retcode := ecx_utils.i_ret_code;
979: errmsg := ecx_utils.i_errbuf;
980: if(l_unexpectedEnabled) then
981: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
982: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf ||SQLERRM||' at ECX_DOCUMENT.SEND',
983: i_method_name);
984: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
985: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
986: ecx_utils.i_errparams),i_method_name); --MLS

Line 1013: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_DOCUMENT.SEND');

1009: ecx_utils.i_errparams --MLS
1010: );
1011:
1012: WHEN OTHERS THEN
1013: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_DOCUMENT.SEND');
1014: retcode := ecx_utils.i_ret_code;
1015: errmsg := ecx_utils.i_errbuf;
1016: if(l_unexpectedEnabled) then
1017: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);

Line 1018: ecx_debug.log(l_unexpected,'i_errmsg',SQLERRM||' at ECX_DOCUMENT.SEND',i_method_name);

1014: retcode := ecx_utils.i_ret_code;
1015: errmsg := ecx_utils.i_errbuf;
1016: if(l_unexpectedEnabled) then
1017: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1018: ecx_debug.log(l_unexpected,'i_errmsg',SQLERRM||' at ECX_DOCUMENT.SEND',i_method_name);
1019: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name,i_method_name);
1020: ecx_debug.log(l_unexpected,'errmsg',errmsg,i_method_name,i_method_name);
1021: end if;
1022: if (l_procedureEnabled) then

Line 1062: i_method_name varchar2(2000) := 'ecx_document.sendDirect';

1058: errmsg OUT NOCOPY VARCHAR2
1059: ) IS
1060: g_instlmode VARCHAR2(100);
1061: i_debug_level pls_integer;
1062: i_method_name varchar2(2000) := 'ecx_document.sendDirect';
1063: i_path varchar2(80);
1064: v_message system.ecx_outengobj;
1065:
1066: p_message_type varchar2(200);

Line 1296: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',

1292: retcode := ecx_utils.i_ret_code;
1293: errmsg := ecx_utils.i_errbuf;
1294: if(l_unexpectedEnabled) then
1295: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1296: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',
1297: i_method_name);
1298: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1299: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
1300: ecx_utils.i_errparams),i_method_name); --MLS

Line 1330: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',

1326: retcode := ecx_utils.i_ret_code;
1327: errmsg := ecx_utils.i_errbuf;
1328: if(l_unexpectedEnabled) then
1329: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1330: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',
1331: i_method_name);
1332: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1333: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
1334: ecx_utils.i_errparams),i_method_name); --MLS

Line 1366: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',

1362: errmsg := ecx_utils.i_errbuf;
1363:
1364: if(l_unexpectedEnabled) then
1365: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1366: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',
1367: i_method_name);
1368: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1369: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
1370: ecx_utils.i_errparams),i_method_name); --MLS

Line 1403: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',

1399: errmsg := ecx_utils.i_errbuf;
1400:
1401: if(l_unexpectedEnabled) then
1402: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1403: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',
1404: i_method_name);
1405: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1406: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
1407: ecx_utils.i_errparams),i_method_name); --MLS

Line 1438: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',

1434: errmsg := ecx_utils.i_errbuf;
1435:
1436: if(l_unexpectedEnabled) then
1437: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1438: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',
1439: i_method_name);
1440: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1441: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
1442: ecx_utils.i_errparams),i_method_name); --MLS

Line 1468: ecx_debug.setErrorInfo(2,30, SQLERRM||' - ECX_DOCUMENT.SENDDIRECT');

1464: ecx_utils.i_errbuf,
1465: ecx_utils.i_errparams --MLS
1466: );
1467: WHEN OTHERS THEN
1468: ecx_debug.setErrorInfo(2,30, SQLERRM||' - ECX_DOCUMENT.SENDDIRECT');
1469: retcode := ecx_utils.i_ret_code;
1470: errmsg := ecx_utils.i_errbuf;
1471: if(l_unexpectedEnabled) then
1472: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);

Line 1473: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',

1469: retcode := ecx_utils.i_ret_code;
1470: errmsg := ecx_utils.i_errbuf;
1471: if(l_unexpectedEnabled) then
1472: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1473: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',
1474: i_method_name);
1475: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1476: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
1477: ecx_utils.i_errparams),i_method_name); --MLS

Line 2027: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_DOCUMENT.RESEND');

2023:
2024: if (ecx_out_wf_qh.retmsg is null AND ecx_out_wf_qh.retcode = 0)
2025: then
2026: -- MLS
2027: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_DOCUMENT.RESEND');
2028: retcode := ecx_utils.i_ret_code;
2029: errmsg := ecx_utils.i_errbuf;
2030: else
2031: -- MLS

Line 2092: ecx_debug.setErrorInfo(2,30, SQLERRM ||'- ECX_DOCUMENT.getConfirmationstatus');

2088: raise ecx_utils.program_exit;
2089:
2090:
2091: when others then
2092: ecx_debug.setErrorInfo(2,30, SQLERRM ||'- ECX_DOCUMENT.getConfirmationstatus');
2093: raise ecx_utils.program_exit;
2094: end getConfirmationstatus;
2095:
2096: end ecx_document;

Line 2096: end ecx_document;

2092: ecx_debug.setErrorInfo(2,30, SQLERRM ||'- ECX_DOCUMENT.getConfirmationstatus');
2093: raise ecx_utils.program_exit;
2094: end getConfirmationstatus;
2095:
2096: end ecx_document;