DBA Data[Home] [Help]

APPS.XDP_MACROS dependencies on XDPCORE

Line 106: xdpcore.context('XDP_MACROS',

102: x_ErrorCode => SFM_SQLCODE,
103: x_ErrorString => SFM_SQLERRM);
104:
105: if SFM_SQLCODE <> 0 then
106: xdpcore.context('XDP_MACROS',
107: 'SEND.ReplaceOrderParameters',
108: p_Command, SFM_SQLCODE, SFM_SQLERRM);
109: xdpcore.raise(SFM_SQLCODE, SFM_SQLERRM);
110: end if;

Line 109: xdpcore.raise(SFM_SQLCODE, SFM_SQLERRM);

105: if SFM_SQLCODE <> 0 then
106: xdpcore.context('XDP_MACROS',
107: 'SEND.ReplaceOrderParameters',
108: p_Command, SFM_SQLCODE, SFM_SQLERRM);
109: xdpcore.raise(SFM_SQLCODE, SFM_SQLERRM);
110: end if;
111:
112: -- Get the Prompt String to be sent out...
113: if p_Prompt is not null and p_Prompt <> 'IGNORE' then

Line 126: xdpcore.context('XDP_MACROS',

122: x_ErrorCode => SFM_SQLCODE,
123: x_ErrorString => SFM_SQLERRM);
124:
125: if SFM_SQLCODE <> 0 then
126: xdpcore.context('XDP_MACROS',
127: 'SEND.ReplaceOrderParameters',
128: p_Prompt, SFM_SQLCODE, SFM_SQLERRM);
129: xdpcore.raise(SFM_SQLCODE, SFM_SQLERRM);
130: end if;

Line 129: xdpcore.raise(SFM_SQLCODE, SFM_SQLERRM);

125: if SFM_SQLCODE <> 0 then
126: xdpcore.context('XDP_MACROS',
127: 'SEND.ReplaceOrderParameters',
128: p_Prompt, SFM_SQLCODE, SFM_SQLERRM);
129: xdpcore.raise(SFM_SQLCODE, SFM_SQLERRM);
130: end if;
131: else
132: l_PromptValue := p_Prompt;
133: end if;

Line 265: xdpcore.context('XDP_MACROS',

261: LogAuditTrail( LogCmd => l_LogCmd,
262: EncryptFlag => p_EncryptFlag,
263: ErrorMessage => sqlerrm);
264:
265: xdpcore.context('XDP_MACROS',
266: 'SEND',
267: l_ActualStr, SQLCODE, SQLERRM);
268: xdpcore.raise(g_Unhandled);
269:

Line 268: xdpcore.raise(g_Unhandled);

264:
265: xdpcore.context('XDP_MACROS',
266: 'SEND',
267: l_ActualStr, SQLCODE, SQLERRM);
268: xdpcore.raise(g_Unhandled);
269:
270: end;
271:
272: -- Strip any PL/SQL offending characters

Line 290: xdpcore.context('XDP_MACROS',

286: if l_Status = g_StatusSuccess then
287: null;
288: else
289: -- Set the Context
290: xdpcore.context('XDP_MACROS',
291: 'Send',
292: l_Status,
293: pv_ReturnChannelName,
294: l_ActualStr,

Line 301: xdpcore.raise(xdp_adapter.pv_AdapterFailure, SFM_SQLERRM);

297: SFM_int_response_buffer);
298:
299: if (l_Status = g_StatusFailure) then
300: SFM_SQLCODE := xdp_adapter.pv_AdapterFailure;
301: xdpcore.raise(xdp_adapter.pv_AdapterFailure, SFM_SQLERRM);
302:
303: elsif (l_Status = g_StatusTimeout) then
304: SFM_SQLCODE := xdp_adapter.pv_AdapterTimeOut;
305: xdpcore.raise(xdp_adapter.pv_AdapterTimeOut, SFM_SQLERRM);

Line 305: xdpcore.raise(xdp_adapter.pv_AdapterTimeOut, SFM_SQLERRM);

301: xdpcore.raise(xdp_adapter.pv_AdapterFailure, SFM_SQLERRM);
302:
303: elsif (l_Status = g_StatusTimeout) then
304: SFM_SQLCODE := xdp_adapter.pv_AdapterTimeOut;
305: xdpcore.raise(xdp_adapter.pv_AdapterTimeOut, SFM_SQLERRM);
306:
307: elsif (l_Status = g_StatusWarning) then
308: SFM_SQLCODE := xdp_adapter.pv_AdapterWarning;
309: xdpcore.raise(xdp_adapter.pv_AdapterWarning, SFM_SQLERRM);

Line 309: xdpcore.raise(xdp_adapter.pv_AdapterWarning, SFM_SQLERRM);

305: xdpcore.raise(xdp_adapter.pv_AdapterTimeOut, SFM_SQLERRM);
306:
307: elsif (l_Status = g_StatusWarning) then
308: SFM_SQLCODE := xdp_adapter.pv_AdapterWarning;
309: xdpcore.raise(xdp_adapter.pv_AdapterWarning, SFM_SQLERRM);
310:
311: elsif (l_Status = g_StatusSessionLost) then
312: SFM_SQLCODE := xdp_adapter.pv_AdapterSessionLost;
313: xdpcore.raise(xdp_adapter.pv_AdapterSessionLost, SFM_SQLERRM);

Line 313: xdpcore.raise(xdp_adapter.pv_AdapterSessionLost, SFM_SQLERRM);

309: xdpcore.raise(xdp_adapter.pv_AdapterWarning, SFM_SQLERRM);
310:
311: elsif (l_Status = g_StatusSessionLost) then
312: SFM_SQLCODE := xdp_adapter.pv_AdapterSessionLost;
313: xdpcore.raise(xdp_adapter.pv_AdapterSessionLost, SFM_SQLERRM);
314: else
315: xdpcore.raise(g_Unhandled, SFM_SQLERRM);
316: end if;
317: end if;

Line 315: xdpcore.raise(g_Unhandled, SFM_SQLERRM);

311: elsif (l_Status = g_StatusSessionLost) then
312: SFM_SQLCODE := xdp_adapter.pv_AdapterSessionLost;
313: xdpcore.raise(xdp_adapter.pv_AdapterSessionLost, SFM_SQLERRM);
314: else
315: xdpcore.raise(g_Unhandled, SFM_SQLERRM);
316: end if;
317: end if;
318:
319: -- DBMS_LOB.freetemporary(pv_ResponseLob);

Line 428: xdpcore.context('XDP_MACROS',

424: x_ErrorCode => SFM_SQLCODE,
425: x_ErrorString => SFM_SQLERRM);
426:
427: if SFM_SQLCODE <> 0 then
428: xdpcore.context('XDP_MACROS',
429: 'SEND_HTTP.ReplaceOrderParameters',
430: p_Url, SFM_SQLCODE, SFM_SQLERRM);
431: xdpcore.raise;
432: end if;

Line 431: xdpcore.raise;

427: if SFM_SQLCODE <> 0 then
428: xdpcore.context('XDP_MACROS',
429: 'SEND_HTTP.ReplaceOrderParameters',
430: p_Url, SFM_SQLCODE, SFM_SQLERRM);
431: xdpcore.raise;
432: end if;
433:
434: -- Do a Get Depending on the input
435: -- GET is the ONLY option supported as of now

Line 510: xdpcore.context('XDP_MACROS',

506:
507: SFM_SQLCODE := sqlcode;
508: SFM_SQLCODE := sqlerrm;
509:
510: xdpcore.context('XDP_MACROS',
511: 'SEND_HTTP.doGet.UTL_HTTP.Request_pieces',
512: p_Url, SQLCODE, SQLERRM);
513: xdpcore.raise(g_Unhandled);
514: end;

Line 513: xdpcore.raise(g_Unhandled);

509:
510: xdpcore.context('XDP_MACROS',
511: 'SEND_HTTP.doGet.UTL_HTTP.Request_pieces',
512: p_Url, SQLCODE, SQLERRM);
513: xdpcore.raise(g_Unhandled);
514: end;
515:
516: -- Log the response
517: LogAuditTrail( LogCmd => p_LogCommand,

Line 551: xdpcore.context('XDP_MACROS',

547: x_ErrorCode => SFM_SQLCODE,
548: x_ErrorString => SFM_SQLERRM);
549:
550: if SFM_SQLCODE <> 0 then
551: xdpcore.context('XDP_MACROS',
552: 'GET_PARAM_VALUE.ReplaceOrderParameters',
553: p_ParamName, SFM_SQLCODE, SFM_SQLERRM);
554: xdpcore.raise;
555: end if;

Line 554: xdpcore.raise;

550: if SFM_SQLCODE <> 0 then
551: xdpcore.context('XDP_MACROS',
552: 'GET_PARAM_VALUE.ReplaceOrderParameters',
553: p_ParamName, SFM_SQLCODE, SFM_SQLERRM);
554: xdpcore.raise;
555: end if;
556:
557: -- dbms_output.put_line('SFMCODE: ' || SFM_SQLCODE);
558: return (l_ActualStr);

Line 577: xdpcore.context('XDP_MACROS',

573: x_ErrorString => SFM_SQLERRM);
574:
575: if SFM_SQLCODE <> 0 then
576: -- dbms_output.put_line('Error: ' || SFM_SQLERRM);
577: xdpcore.context('XDP_MACROS',
578: 'GET_ATTR_VALUE.RepalceFEAttributes',
579: p_AttrName, SFM_SQLCODE, SFM_SQLERRM);
580: xdpcore.raise;
581: end if;

Line 580: xdpcore.raise;

576: -- dbms_output.put_line('Error: ' || SFM_SQLERRM);
577: xdpcore.context('XDP_MACROS',
578: 'GET_ATTR_VALUE.RepalceFEAttributes',
579: p_AttrName, SFM_SQLCODE, SFM_SQLERRM);
580: xdpcore.raise;
581: end if;
582:
583: return (l_ActualCmd);
584:

Line 689: xdpcore.context('XDP_MACROS',

685: x_ErrorString => SFM_SQLERRM);
686:
687: if SFM_SQLCODE <> 0 then
688: -- dbms_output.put_line('Error: ' || SFM_SQLERRM);
689: xdpcore.context('XDP_MACROS',
690: 'SEND_CONNET.RepalceFEAttributes',
691: p_Command, SFM_SQLCODE, SFM_SQLERRM);
692: xdpcore.raise;
693: end if;

Line 692: xdpcore.raise;

688: -- dbms_output.put_line('Error: ' || SFM_SQLERRM);
689: xdpcore.context('XDP_MACROS',
690: 'SEND_CONNET.RepalceFEAttributes',
691: p_Command, SFM_SQLCODE, SFM_SQLERRM);
692: xdpcore.raise;
693: end if;
694:
695: -- Replace the FE Attributes in the Prompt by their values
696: xdp_procedure_builder_util.ReplaceFEAttributes(

Line 705: xdpcore.context('XDP_MACROS',

701: x_ErrorString => SFM_SQLERRM);
702:
703: if SFM_SQLCODE <> 0 then
704: -- dbms_output.put_line('Error: ' || SFM_SQLERRM);
705: xdpcore.context('XDP_MACROS',
706: 'SEND_CONNET.RepalceFEAttributes',
707: p_Command, SFM_SQLCODE, SFM_SQLERRM);
708: xdpcore.raise;
709: end if;

Line 708: xdpcore.raise;

704: -- dbms_output.put_line('Error: ' || SFM_SQLERRM);
705: xdpcore.context('XDP_MACROS',
706: 'SEND_CONNET.RepalceFEAttributes',
707: p_Command, SFM_SQLCODE, SFM_SQLERRM);
708: xdpcore.raise;
709: end if;
710:
711: -- dbms_output.put_line('Command: ' || l_ActualCmd);
712: -- dbms_output.put_line('Response: ' || l_ActualPrompt);