[Home] [Help]
1: PACKAGE BODY ECEPOI AS
2: /* $Header: OEPOIB.pls 120.1 2011/11/17 05:38:43 slagiset noship $ */
3:
4: PROCEDURE Process_POI_Inbound (
5: errbuf OUT NOCOPY varchar2,
23:
24: begin
25: ec_debug.enable_debug(i_debug_mode);
26: ec_debug.pl(0,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
27: ec_debug.push('ECEPOI.PROCESS_POI_INBOUND');
28: ec_debug.pl(3,'i_file_path',i_file_path);
29: ec_debug.pl(3,'i_file_name',i_file_name);
30: ec_debug.pl(3,'i_run_import',i_run_import);
31: ec_debug.pl(3,'i_map_id',i_map_id);
107:
108: ec_debug.pl(3,'i_submit_id',i_submit_id);
109: ec_debug.pl(3,'retcode',retcode);
110: ec_debug.pl(3,'errbuf',errbuf);
111: ec_debug.pop('ECEPOI.PROCESS_POI_INBOUND');
112:
113: ec_debug.pl(0,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
114: ec_debug.disable_debug;
115:
128: ec_debug.disable_debug;
129:
130: WHEN OTHERS THEN
131: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',
132: 'ECEPOI.PROCESS_POI_INBOUND');
133: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
134: retcode := 2;
135: rollback work;
136: ece_flatfile_pvt.print_attributes;
363: fnd_message.set_name ('ONT', 'OE_OI_IFACE');
364: ELSIF l_processing = 'OUTBOUND_SENT' THEN
365: fnd_message.set_name ('ONT', 'OE_OA_ACKNOWLEDGMENT_SENT');
366: END IF;
367: fnd_message.set_token ('TRANSACTION', ECEPOI.EM_Transaction_Type (p_txn_code => l_transaction_type));
368: l_message_text := fnd_message.get;
369: END IF;
370: -----------------------------------------------------------
371: -- Non-CLN params
562: oe_debug_pub.add('Unable to get Item Description '||SQLERRM,1);
563: NULL;
564: END Get_Item_Description;
565:
566: END ECEPOI;