APPS.ECECATI dependencies on EC_UTILS

Line 22: ec_utils.g_stack.DELETE;

18: END IF;
19: /**
20: Initialize the Stack Table
21: **/
22: ec_utils.g_stack.DELETE;
23: if EC_DEBUG.G_debug_level >= 1 then
24: ec_debug.pl(1,'EC','ECE_START_GENERIC_INBOUND','TRANSACTION_TYPE',i_transaction_type);
25: END IF;
26: ece_inbound.process_run_inbound

Line 35: m_var_found := ec_utils.find_variable

31: if EC_DEBUG.G_debug_level >= 1 then
32: ec_debug.pl(1,'EC','ECE_FINISH_GENERIC_INBOUND','TRANSACTION_TYPE',i_transaction_type);
33: END IF;
34: ---Get out variables from the Stack .
35: m_var_found := ec_utils.find_variable
36: (
37: 0,
38: 'P_PO_BATCH_ID',
39: m_stack_pos,

Line 44: o_po_batch_id := ec_utils.g_stack(m_stack_pos).variable_value;

40: m_plsql_pos
41: );
42: if ( m_var_found )
43: then
44: o_po_batch_id := ec_utils.g_stack(m_stack_pos).variable_value;
45: else
46: if EC_DEBUG.G_debug_level >= 3 then
47: ec_debug.pl(3,'EC','ECE_VARIABLE_NOT_ON_STACK','VARIABLE_NAME','P_PO_BATCH_ID');
48: end if;

Line 49: ec_utils.i_ret_code :=2;

45: else
46: if EC_DEBUG.G_debug_level >= 3 then
47: ec_debug.pl(3,'EC','ECE_VARIABLE_NOT_ON_STACK','VARIABLE_NAME','P_PO_BATCH_ID');
48: end if;
49: ec_utils.i_ret_code :=2;
50: raise ec_utils.program_exit;
51: end if;
52: if EC_DEBUG.G_debug_level >= 2 then
53: ec_debug.pl(3,'o_po_batch_id',o_po_batch_id);

Line 50: raise ec_utils.program_exit;

46: if EC_DEBUG.G_debug_level >= 3 then
47: ec_debug.pl(3,'EC','ECE_VARIABLE_NOT_ON_STACK','VARIABLE_NAME','P_PO_BATCH_ID');
48: end if;
49: ec_utils.i_ret_code :=2;
50: raise ec_utils.program_exit;
51: end if;
52: if EC_DEBUG.G_debug_level >= 2 then
53: ec_debug.pl(3,'o_po_batch_id',o_po_batch_id);
54: ec_debug.pop('ECECATI.PROCESS_CATI_DOCS');

Line 57: WHEN EC_UTILS.PROGRAM_EXIT then

53: ec_debug.pl(3,'o_po_batch_id',o_po_batch_id);
54: ec_debug.pop('ECECATI.PROCESS_CATI_DOCS');
55: end if;
56: EXCEPTION
57: WHEN EC_UTILS.PROGRAM_EXIT then
58: raise;
59: WHEN OTHERS THEN
60: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECECATI.PROCESS_CATI_DOCS');
61: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

Line 62: ec_utils.i_ret_code :=2;

58: raise;
59: WHEN OTHERS THEN
60: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECECATI.PROCESS_CATI_DOCS');
61: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
62: ec_utils.i_ret_code :=2;
63: raise ec_utils.program_exit;
64: end process_cati_docs;
65:
66: procedure process_cati_inbound

Line 63: raise ec_utils.program_exit;

59: WHEN OTHERS THEN
60: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECECATI.PROCESS_CATI_DOCS');
61: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
62: ec_utils.i_ret_code :=2;
63: raise ec_utils.program_exit;
64: end process_cati_docs;
65:
66: procedure process_cati_inbound
67: (

Line 283: retcode := ec_utils.i_ret_code;

279:
280: end if;
281: commit;
282:
283: retcode := ec_utils.i_ret_code;
284:
285: IF ec_mapping_utils.ec_get_trans_upgrade_status(i_transaction_type, i_map_id) = 'U' THEN
286: ec_debug.pl(0,'EC','ECE_REC_TRANS_PENDING',NULL);
287: retcode := 1;

Line 304: WHEN EC_UTILS.PROGRAM_EXIT then

300: retcode := 1;
301: ec_debug.disable_debug;
302: ROLLBACK WORK;
303:
304: WHEN EC_UTILS.PROGRAM_EXIT then
305: rollback work;
306: retcode := ec_utils.i_ret_code;
307: ece_flatfile_pvt.print_attributes;
308: ec_debug.disable_debug;

Line 306: retcode := ec_utils.i_ret_code;

302: ROLLBACK WORK;
303:
304: WHEN EC_UTILS.PROGRAM_EXIT then
305: rollback work;
306: retcode := ec_utils.i_ret_code;
307: ece_flatfile_pvt.print_attributes;
308: ec_debug.disable_debug;
309: WHEN OTHERS THEN
310: rollback work;

Line 528: retcode := ec_utils.i_ret_code;

524:
525: end if;
526: commit;
527:
528: retcode := ec_utils.i_ret_code;
529:
530: IF ec_mapping_utils.ec_get_trans_upgrade_status(i_transaction_type, i_map_id) = 'U' THEN
531: ec_debug.pl(0,'EC','ECE_REC_TRANS_PENDING',NULL);
532: retcode := 1;

Line 549: WHEN EC_UTILS.PROGRAM_EXIT then

545: retcode := 1;
546: ec_debug.disable_debug;
547: ROLLBACK WORK;
548:
549: WHEN EC_UTILS.PROGRAM_EXIT then
550: rollback work;
551: retcode := ec_utils.i_ret_code;
552: ece_flatfile_pvt.print_attributes;
553: ec_debug.disable_debug;

Line 551: retcode := ec_utils.i_ret_code;

547: ROLLBACK WORK;
548:
549: WHEN EC_UTILS.PROGRAM_EXIT then
550: rollback work;
551: retcode := ec_utils.i_ret_code;
552: ece_flatfile_pvt.print_attributes;
553: ec_debug.disable_debug;
554: WHEN OTHERS THEN
555: rollback work;