eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EC_EXECUTION_UTILS dependencies on EC_EXECUTION_UTILS

Line 1: PACKAGE BODY ec_execution_utils as

1: PACKAGE BODY ec_execution_utils as
2: -- $Header: ECXUTILB.pls 115.24 2003/04/04 07:26:50 hgandiko ship $
3:
4: -- Internal DBMS_DESCRIBE.DESCRIBE_PROCEDURE variables
5: v_overload dbms_describe.number_table;

Line 25: ec_debug.push('EC_EXECUTION_UTILS.PRINTPARAMS');

21: )
22: is
23: BEGIN
24: if EC_DEBUG.G_debug_level >= 2 then
25: ec_debug.push('EC_EXECUTION_UTILS.PRINTPARAMS');
26: ec_debug.pl(3,'i_procedure_name',i_procedure_name);
27: end if;
28: for i in 1..ec_utils.g_parameter_stack.COUNT
29: loop

Line 38: ec_debug.pop('EC_EXECUTION_UTILS.PRINTPARAMS');

34: end if;
35: end if;
36: end loop;
37: if EC_DEBUG.G_debug_level >= 2 then
38: ec_debug.pop('EC_EXECUTION_UTILS.PRINTPARAMS');
39: end if;
40: exception
41: WHEN EC_UTILS.PROGRAM_EXIT then
42: raise;

Line 44: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.PRINTPARAMS');

40: exception
41: WHEN EC_UTILS.PROGRAM_EXIT then
42: raise;
43: WHEN OTHERS THEN
44: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.PRINTPARAMS');
45: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
46: ec_utils.i_ret_code :=2;
47: raise EC_UTILS.PROGRAM_EXIT;
48: end printparams;

Line 66: ec_debug.push('EC_EXECUTION_UTILS.DESCRIBEPROC');

62: is_function BOOLEAN := FALSE;
63: i_return_value varchar2(32000);
64: BEGIN
65: if EC_DEBUG.G_debug_level >= 2 then
66: ec_debug.push('EC_EXECUTION_UTILS.DESCRIBEPROC');
67: ec_debug.pl(3,'i_procedure_name',i_procedure_name);
68: end if;
69:
70:

Line 73: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.DESCRIBEPROC');

69:
70:
71: -- This code is added for NULL procedure name
72: if nvl(length(replace(i_procedure_name, ' ')),0) < 1 then
73: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.DESCRIBEPROC');
74: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',' ===> NULL supplied as procedure name');
75: ec_utils.i_ret_code :=2;
76: raise EC_UTILS.PROGRAM_EXIT;
77: end if;

Line 115: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.DESCRIBEPROC');

111: );
112: EXCEPTION
113: WHEN OTHERS THEN
114: ec_debug.pl(0,'EC','ECE_PROCEDURE_EXECUTION','PROCEDURE_NAME',i_procedure_name);
115: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.DESCRIBEPROC');
116: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
117: ec_utils.i_ret_code :=2;
118: raise EC_UTILS.PROGRAM_EXIT;
119: END;

Line 154: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.DESCRIBEPROC');

150: if v_datatype(v_argcounter) not in ( 1,2,12,96)
151: then
152: ec_debug.pl(0,'EC','ECE_PROCEDURE_EXECUTION','PROCEDURE_NAME',i_procedure_name);
153: ec_debug.pl(0,'EC','ECE_UNSUPPORTED_DATATYPE','Unsupported Data Type');
154: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.DESCRIBEPROC');
155: ec_utils.i_ret_code :=2;
156: raise EC_UTILS.PROGRAM_EXIT;
157: end if;
158:

Line 257: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.RUNPROC');

253: EXCEPTION
254: WHEN OTHERS THEN
255: ec_debug.pl(0,'EC','ECE_PROCEDURE_EXECUTION','PROCEDURE_NAME',i_procedure_name);
256: error_position := dbms_sql.last_error_position;
257: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.RUNPROC');
258: ece_error_handling_pvt.print_parse_error (error_position,v_proc_string);
259: ec_utils.i_ret_code :=2;
260: raise EC_UTILS.PROGRAM_EXIT;
261: END;

Line 274: ec_debug.pop('EC_EXECUTION_UTILS.DESCRIBEPROC');

270: );
271: end if;
272:
273: if EC_DEBUG.G_debug_level >= 2 then
274: ec_debug.pop('EC_EXECUTION_UTILS.DESCRIBEPROC');
275: end if;
276: exception
277: WHEN EC_UTILS.PROGRAM_EXIT then
278: raise;

Line 280: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.DESCRIBEPROC');

276: exception
277: WHEN EC_UTILS.PROGRAM_EXIT then
278: raise;
279: WHEN OTHERS THEN
280: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.DESCRIBEPROC');
281: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
282: ec_utils.i_ret_code :=2;
283: raise EC_UTILS.PROGRAM_EXIT;
284: end describeproc;

Line 307: ec_debug.push('EC_EXECUTION_UTILS.RUNPROC');

303: i_char char(500);
304:
305: BEGIN
306: if EC_DEBUG.G_debug_level >= 2 then
307: ec_debug.push('EC_EXECUTION_UTILS.RUNPROC');
308: ec_debug.pl(3,'i_procedure_name',i_procedure_name);
309: end if;
310:
311: -- Bug 2340691

Line 391: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.RUNPROC');

387: end if;
388: else
389: ec_debug.pl(0,'EC','ECE_PROCEDURE_EXECUTION','PROCEDURE_NAME',i_procedure_name);
390: ec_debug.pl(0,'EC','ECE_UNSUPPORTED_DATATYPE','Unsupported Data Type');
391: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.RUNPROC');
392: ec_utils.i_ret_code :=2;
393: raise EC_UTILS.PROGRAM_EXIT;
394: end if;
395:

Line 467: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.RUNPROC');

463: ec_debug.pl(3,ec_utils.g_parameter_stack(j).parameter_name,ec_utils.g_parameter_stack(j).value);
464: end if;
465: else
466: ec_debug.pl(0,'EC','ECE_UNSUPPORTED_DATATYPE','Unsupported Data Type');
467: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.RUNPROC');
468: ec_utils.i_ret_code :=2;
469: raise EC_UTILS.PROGRAM_EXIT;
470: end if;
471:

Line 490: ec_debug.pop('EC_EXECUTION_UTILS.RUNPROC');

486: );
487: end if;
488:
489: if EC_DEBUG.G_debug_level >= 2 then
490: ec_debug.pop('EC_EXECUTION_UTILS.RUNPROC');
491: end if;
492: exception
493: WHEN EC_UTILS.PROGRAM_EXIT then
494: raise;

Line 497: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.RUNPROC');

493: WHEN EC_UTILS.PROGRAM_EXIT then
494: raise;
495: WHEN OTHERS THEN
496: ec_debug.pl(0,'EC','ECE_PROCEDURE_ERROR','PROCEDURE_NAME',i_procedure_name);
497: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.RUNPROC');
498: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
499: ec_utils.i_ret_code :=2;
500: raise EC_UTILS.PROGRAM_EXIT;
501: end runproc;

Line 507: ec_debug.push('EC_EXECUTION_UTILS.LOAD_PROCEDURE_DEFINITIONS');

503: procedure load_procedure_definitions
504: is
505: BEGIN
506: if EC_DEBUG.G_debug_level >= 2 then
507: ec_debug.push('EC_EXECUTION_UTILS.LOAD_PROCEDURE_DEFINITIONS');
508: end if;
509: for i in 1..ec_utils.g_stage_data.COUNT
510: loop
511: if (

Line 528: ec_debug.pop('EC_EXECUTION_UTILS.LOAD_PROCEDURE_DEFINITIONS');

524: end if;
525: end loop;
526:
527: if EC_DEBUG.G_debug_level >= 2 then
528: ec_debug.pop('EC_EXECUTION_UTILS.LOAD_PROCEDURE_DEFINITIONS');
529: end if;
530: exception
531: WHEN EC_UTILS.PROGRAM_EXIT then
532: raise;

Line 534: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.LOAD_PROCEDURE_DEFINITIONS');

530: exception
531: WHEN EC_UTILS.PROGRAM_EXIT then
532: raise;
533: WHEN OTHERS THEN
534: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.LOAD_PROCEDURE_DEFINITIONS');
535: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
536: ec_utils.i_ret_code :=2;
537: raise EC_UTILS.PROGRAM_EXIT;
538: end load_procedure_definitions;

Line 547: ec_debug.push('EC_EXECUTION_UTILS.LOAD_MANDATORY_COLUMNS');

543: )
544: is
545: BEGIN
546: if EC_DEBUG.G_debug_level >= 2 then
547: ec_debug.push('EC_EXECUTION_UTILS.LOAD_MANDATORY_COLUMNS');
548: ec_debug.pl(3,'i_level',i_level);
549: end if;
550:
551: for i in 1..ec_utils.g_stage_data.COUNT

Line 571: ec_debug.pop('EC_EXECUTION_UTILS.LOAD_MANDATORY_COLUMNS');

567: end if;
568: end loop;
569:
570: if EC_DEBUG.G_debug_level >= 2 then
571: ec_debug.pop('EC_EXECUTION_UTILS.LOAD_MANDATORY_COLUMNS');
572: end if;
573: exception
574: WHEN EC_UTILS.PROGRAM_EXIT then
575: raise;

Line 577: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.LOAD_MANDATORY_COLUMNS');

573: exception
574: WHEN EC_UTILS.PROGRAM_EXIT then
575: raise;
576: WHEN OTHERS THEN
577: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.LOAD_MANDATORY_COLUMNS');
578: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
579: ec_utils.i_ret_code :=2;
580: raise EC_UTILS.PROGRAM_EXIT;
581: end load_mandatory_columns;

Line 607: ec_debug.push('EC_EXECUTION_UTILS.LOAD_PROCEDURE_MAPPINGS');

603: and etsd.map_id = ec_utils.g_map_id;
604: i pls_integer := ec_utils.g_procedure_mappings.COUNT;
605: BEGIN
606: if EC_DEBUG.G_debug_level >= 2 then
607: ec_debug.push('EC_EXECUTION_UTILS.LOAD_PROCEDURE_MAPPINGS');
608: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
609: end if;
610:
611: for proc_map in proc_mapping

Line 636: ec_debug.pop('EC_EXECUTION_UTILS.LOAD_PROCEDURE_MAPPINGS');

632: end if;
633: end loop;
634:
635: if EC_DEBUG.G_debug_level >= 2 then
636: ec_debug.pop('EC_EXECUTION_UTILS.LOAD_PROCEDURE_MAPPINGS');
637: end if;
638: exception
639: WHEN EC_UTILS.PROGRAM_EXIT then
640: raise;

Line 642: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.LOAD_PROCEDURE_MAPPINGS');

638: exception
639: WHEN EC_UTILS.PROGRAM_EXIT then
640: raise;
641: WHEN OTHERS THEN
642: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.LOAD_PROCEDURE_MAPPINGS');
643: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
644: ec_utils.i_ret_code :=2;
645: raise EC_UTILS.PROGRAM_EXIT;
646: end load_procedure_mappings;

Line 660: ec_debug.push('EC_EXECUTION_UTILS.ASSIGN_VALUES');

656: i_stack_pos pls_integer;
657: i_plsql_pos pls_integer;
658: BEGIN
659: if EC_DEBUG.G_debug_level >= 2 then
660: ec_debug.push('EC_EXECUTION_UTILS.ASSIGN_VALUES');
661: ec_debug.pl(3,'i_transtage_id',i_transtage_id);
662: ec_debug.pl(3,'i_procedure_name',i_procedure_name);
663: ec_debug.pl(3,'i_action_type',i_action_type);
664: end if;

Line 787: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.ASSIGN_VALUES');

783: end if;
784:
785: else
786: ec_debug.pl(0,'EC','ECE_PROCEDURE_EXECUTION','PROCEDURE_NAME',i_procedure_name);
787: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.ASSIGN_VALUES');
788: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
789: ec_utils.i_ret_code :=2;
790: raise EC_UTILS.PROGRAM_EXIT;
791: end if; -- For Action Types

Line 822: ec_debug.pop('EC_EXECUTION_UTILS.ASSIGN_VALUES');

818: end if;
819: end loop; --- i
820:
821: if EC_DEBUG.G_debug_level >= 2 then
822: ec_debug.pop('EC_EXECUTION_UTILS.ASSIGN_VALUES');
823: end if;
824: exception
825: WHEN EC_UTILS.PROGRAM_EXIT then
826: raise;

Line 828: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.ASSIGN_VALUES');

824: exception
825: WHEN EC_UTILS.PROGRAM_EXIT then
826: raise;
827: WHEN OTHERS THEN
828: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.ASSIGN_VALUES');
829: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
830: ec_utils.i_ret_code :=2;
831: raise EC_UTILS.PROGRAM_EXIT;
832: end assign_values;

Line 940: ec_debug.push('EC_EXECUTION_UTILS.LOAD_MAPPINGS');

936: p_count pls_integer := 0;
937: begin
938:
939: if EC_DEBUG.G_debug_level >= 2 then
940: ec_debug.push('EC_EXECUTION_UTILS.LOAD_MAPPINGS');
941: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
942: ec_debug.pl(3,'i_map_id',i_map_id);
943:
944: ec_debug.pl(3,'EC','ECE_LOADING_LEVELS','LEVEL','Loading External levels');

Line 1309: ec_debug.pop('EC_EXECUTION_UTILS.LOAD_MAPPINGS');

1305: ec_utils.g_transaction_type
1306: );
1307:
1308: if EC_DEBUG.G_debug_level >= 2 then
1309: ec_debug.pop('EC_EXECUTION_UTILS.LOAD_MAPPINGS');
1310: end if;
1311: EXCEPTION
1312: WHEN EC_UTILS.PROGRAM_EXIT then
1313: raise;

Line 1315: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.LOAD_MAPPINGS');

1311: EXCEPTION
1312: WHEN EC_UTILS.PROGRAM_EXIT then
1313: raise;
1314: WHEN OTHERS THEN
1315: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.LOAD_MAPPINGS');
1316: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1317: ec_utils.i_ret_code :=2;
1318: raise EC_UTILS.PROGRAM_EXIT;
1319: end load_mappings;

Line 1321: end ec_execution_utils;

1317: ec_utils.i_ret_code :=2;
1318: raise EC_UTILS.PROGRAM_EXIT;
1319: end load_mappings;
1320:
1321: end ec_execution_utils;