[Home] [Help]
1: PACKAGE BODY ECEPOI AS
2: /* $Header: ECPOIB.pls 120.5.12010000.2 2008/11/24 17:26:01 akemiset ship $ */
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;
361: fnd_message.set_name ('ONT', 'OE_OI_IFACE');
362: ELSIF l_processing = 'OUTBOUND_SENT' THEN
363: fnd_message.set_name ('ONT', 'OE_OA_ACKNOWLEDGMENT_SENT');
364: END IF;
365: fnd_message.set_token ('TRANSACTION', ECEPOI.EM_Transaction_Type (p_txn_code => l_transaction_type));
366: l_message_text := fnd_message.get;
367: END IF;
368: -----------------------------------------------------------
369: -- Non-CLN params
554: oe_debug_pub.add('Unable to get Item Description '||SQLERRM,1);
555: NULL;
556: END Get_Item_Description;
557:
558: END ECEPOI;