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.ECX_ACTIONS dependencies on ECX_ACTIONS

Line 1: package body ecx_actions as

1: package body ecx_actions as
2: -- $Header: ECXACTNB.pls 120.12 2006/07/07 10:00:09 gsingh ship $
3:
4: l_procedure PLS_INTEGER := ecx_debug.g_procedure;
5: l_statement PLS_INTEGER := ecx_debug.g_statement;

Line 48: i_method_name varchar2(2000) := 'ecx_actions.get_var_attr';

44: x_value OUT NOCOPY Varchar2,
45: x_stack_var OUT NOCOPY Boolean,
46: x_stack_pos OUT NOCOPY pls_integer) IS
47:
48: i_method_name varchar2(2000) := 'ecx_actions.get_var_attr';
49: l_var_present Boolean := FALSE;
50: l_dummy pls_integer;
51:
52: BEGIN

Line 110: 'ECX_ACTIONS.GET_VAR_ATTR');

106:
107: WHEN OTHERS THEN
108: if(l_unexpectedEnabled) then
109: ecx_debug.log(l_unexpected,'ECX', 'ECX_PROGRAM_ERROR', i_method_name,'PROGRESS_LEVEL',
110: 'ECX_ACTIONS.GET_VAR_ATTR');
111: ecx_debug.log(l_unexpected,'ECX', 'ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE', SQLERRM);
112: end if;
113: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.GET_VAR_ATTR');
114: if (l_procedureEnabled) then

Line 113: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.GET_VAR_ATTR');

109: ecx_debug.log(l_unexpected,'ECX', 'ECX_PROGRAM_ERROR', i_method_name,'PROGRESS_LEVEL',
110: 'ECX_ACTIONS.GET_VAR_ATTR');
111: ecx_debug.log(l_unexpected,'ECX', 'ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE', SQLERRM);
112: end if;
113: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.GET_VAR_ATTR');
114: if (l_procedureEnabled) then
115: ecx_debug.pop(i_method_name);
116: end if;
117: raise ecx_utils.PROGRAM_EXIT;

Line 127: i_method_name varchar2(2000) := 'ecx_actions.assign_value';

123: i_stack_pos IN pls_integer,
124: i_plsql_pos IN pls_integer,
125: i_direction IN varchar2,
126: i_value IN Varchar2) IS
127: i_method_name varchar2(2000) := 'ecx_actions.assign_value';
128: BEGIN
129: if (l_procedureEnabled) then
130: ecx_debug.push(i_method_name);
131: end if;

Line 162: 'ECX_ACTIONS.ASSIGN_VALUE');

158: EXCEPTION
159: WHEN OTHERS THEN
160: if(l_unexpectedEnabled) then
161: ecx_debug.log(l_unexpected,'ECX', 'ECX_PROGRAM_ERROR', i_method_name,'PROGRESS_LEVEL',
162: 'ECX_ACTIONS.ASSIGN_VALUE');
163: ecx_debug.log(l_unexpected,'ECX', 'ECX_ERROR_MESSAGE',i_method_name, 'ERROR_MESSAGE', SQLERRM);
164: end if;
165: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.ASSIGN_VALUE');
166: if (l_procedureEnabled) then

Line 165: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.ASSIGN_VALUE');

161: ecx_debug.log(l_unexpected,'ECX', 'ECX_PROGRAM_ERROR', i_method_name,'PROGRESS_LEVEL',
162: 'ECX_ACTIONS.ASSIGN_VALUE');
163: ecx_debug.log(l_unexpected,'ECX', 'ECX_ERROR_MESSAGE',i_method_name, 'ERROR_MESSAGE', SQLERRM);
164: end if;
165: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.ASSIGN_VALUE');
166: if (l_procedureEnabled) then
167: ecx_debug.pop(i_method_name);
168: end if;
169:

Line 184: i_method_name varchar2(2000) := 'ecx_actions.assign_value';

180: i_plsql_pos IN pls_integer,
181: i_direction IN varchar2,
182: i_c_value IN Clob) IS
183:
184: i_method_name varchar2(2000) := 'ecx_actions.assign_value';
185:
186: BEGIN
187: if (l_procedureEnabled) then
188: ecx_debug.push(i_method_name);

Line 224: 'ECX_ACTIONS.ASSIGN_VALUE');

220: EXCEPTION
221: WHEN OTHERS THEN
222: if(l_unexpectedEnabled) then
223: ecx_debug.log(l_unexpected,'ECX', 'ECX_PROGRAM_ERROR',i_method_name, 'PROGRESS_LEVEL',
224: 'ECX_ACTIONS.ASSIGN_VALUE');
225: ecx_debug.log(l_unexpected,'ECX', 'ECX_ERROR_MESSAGE', i_method_name, 'ERROR_MESSAGE', SQLERRM);
226: end if;
227: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.ASSIGN_VALUE');
228: if (l_procedureEnabled) then

Line 227: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.ASSIGN_VALUE');

223: ecx_debug.log(l_unexpected,'ECX', 'ECX_PROGRAM_ERROR',i_method_name, 'PROGRESS_LEVEL',
224: 'ECX_ACTIONS.ASSIGN_VALUE');
225: ecx_debug.log(l_unexpected,'ECX', 'ECX_ERROR_MESSAGE', i_method_name, 'ERROR_MESSAGE', SQLERRM);
226: end if;
227: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.ASSIGN_VALUE');
228: if (l_procedureEnabled) then
229: ecx_debug.pop(i_method_name);
230: end if;
231:

Line 240: i_method_name varchar2(2000) := 'ecx_actions.find_stack_variable';

236: function find_stack_variable (
237: i_variable_name IN Varchar2,
238: i_stack_pos OUT NOCOPY pls_integer) return Boolean IS
239:
240: i_method_name varchar2(2000) := 'ecx_actions.find_stack_variable';
241: bFound Boolean := FALSE;
242:
243: BEGIN
244: if (l_procedureEnabled) then

Line 274: 'ECX_ACTIONS.FIND_STACK_VARIABLE');

270: EXCEPTION
271: WHEN OTHERS THEN
272: if(l_unexpectedEnabled) then
273: ecx_debug.log(l_unexpected,'ECX', 'ECX_PROGRAM_ERROR', i_method_name,'PROGRESS_LEVEL',
274: 'ECX_ACTIONS.FIND_STACK_VARIABLE');
275: ecx_debug.log(l_unexpected,'ECX', 'ECX_ERROR_MESSAGE',i_method_name, 'ERROR_MESSAGE', SQLERRM);
276: end if;
277: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.FIND_STACK_VARIABLE');
278: if (l_procedureEnabled) then

Line 277: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.FIND_STACK_VARIABLE');

273: ecx_debug.log(l_unexpected,'ECX', 'ECX_PROGRAM_ERROR', i_method_name,'PROGRESS_LEVEL',
274: 'ECX_ACTIONS.FIND_STACK_VARIABLE');
275: ecx_debug.log(l_unexpected,'ECX', 'ECX_ERROR_MESSAGE',i_method_name, 'ERROR_MESSAGE', SQLERRM);
276: end if;
277: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.FIND_STACK_VARIABLE');
278: if (l_procedureEnabled) then
279: ecx_debug.pop(i_method_name);
280: end if;
281: raise ecx_utils.PROGRAM_EXIT;

Line 290: i_method_name varchar2(2000) := 'ecx_actions.build_insert_stmt';

286: procedure build_insert_stmt (
287: p_insert_cursor IN OUT NOCOPY pls_integer,
288: p_level IN pls_integer) IS
289:
290: i_method_name varchar2(2000) := 'ecx_actions.build_insert_stmt';
291:
292: cInsert_stmt varchar2(32000) := 'INSERT INTO ';
293: cValue_stmt varchar2(32000) := 'VALUES ( ';
294: i pls_integer;

Line 351: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.BUILD_INSERT_STMT');

347: if(l_unexpectedEnabled) then
348: ecx_debug.log(l_unexpected,'ECX', 'ECX_PROGRAM_ERROR', 'PROGRESS_LEVEL',i_method_name);
349: ecx_debug.log(l_unexpected,'ECX', 'ECX_ERROR_MESSAGE', i_method_name, 'ERROR_MESSAGE', SQLERRM);
350: end if;
351: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.BUILD_INSERT_STMT');
352: if (l_procedureEnabled) then
353: ecx_debug.pop(i_method_name);
354: end if;
355: raise ecx_utils.program_exit;

Line 365: ecx_debug.log(l_unexpected,'ECX', 'ECX_PROGRAM_ERROR', 'PROGRESS_LEVEL', 'ECX_ACTIONS.BUILD_INSERT_STMT');

361: raise;
362:
363: WHEN others then
364: if(l_unexpectedEnabled) then
365: ecx_debug.log(l_unexpected,'ECX', 'ECX_PROGRAM_ERROR', 'PROGRESS_LEVEL', 'ECX_ACTIONS.BUILD_INSERT_STMT');
366: ecx_debug.log(l_unexpected,'ECX', 'ECX_ERROR_MESSAGE', i_method_name, 'ERROR_MESSAGE', SQLERRM);
367: end if;
368: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.BUILD_INSERT_STMT');
369:

Line 368: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.BUILD_INSERT_STMT');

364: if(l_unexpectedEnabled) then
365: ecx_debug.log(l_unexpected,'ECX', 'ECX_PROGRAM_ERROR', 'PROGRESS_LEVEL', 'ECX_ACTIONS.BUILD_INSERT_STMT');
366: ecx_debug.log(l_unexpected,'ECX', 'ECX_ERROR_MESSAGE', i_method_name, 'ERROR_MESSAGE', SQLERRM);
367: end if;
368: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.BUILD_INSERT_STMT');
369:
370: if (l_procedureEnabled) then
371: ecx_debug.pop(i_method_name);
372: end if;

Line 381: i_method_name varchar2(2000) := 'ecx_actions.insert_level_into_table';

377:
378: procedure insert_level_into_table (
379: p_level IN pls_integer) IS
380:
381: i_method_name varchar2(2000) := 'ecx_actions.insert_level_into_table';
382:
383: l_dummy pls_integer;
384: k pls_integer;
385: l_date DATE;

Line 534: ecx_debug.log(l_unexpected, 'ECX', 'ECX_PROGRAM_ERROR',i_method_name, 'PROGRESS_LEVEL', 'ECX_ACTIONS.INSERT_LEVEL_INTO_TABLE');

530:
531: WHEN l_insert_failed then
532: if(l_unexpectedEnabled) then
533: ecx_debug.log(l_unexpected ,'ECX', 'ECX_STAGE_INSERT_FAILED',i_method_name, 'LEVEL', p_level);
534: ecx_debug.log(l_unexpected, 'ECX', 'ECX_PROGRAM_ERROR',i_method_name, 'PROGRESS_LEVEL', 'ECX_ACTIONS.INSERT_LEVEL_INTO_TABLE');
535: ecx_debug.log(l_unexpected,'ECX', 'ECX_ERROR_MESSAGE',i_method_name, 'ERROR_MESSAGE', SQLERRM);
536: end if;
537: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.INSERT_LEVEL_INTO_TABLE');
538: if (l_procedureEnabled) then

Line 537: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.INSERT_LEVEL_INTO_TABLE');

533: ecx_debug.log(l_unexpected ,'ECX', 'ECX_STAGE_INSERT_FAILED',i_method_name, 'LEVEL', p_level);
534: ecx_debug.log(l_unexpected, 'ECX', 'ECX_PROGRAM_ERROR',i_method_name, 'PROGRESS_LEVEL', 'ECX_ACTIONS.INSERT_LEVEL_INTO_TABLE');
535: ecx_debug.log(l_unexpected,'ECX', 'ECX_ERROR_MESSAGE',i_method_name, 'ERROR_MESSAGE', SQLERRM);
536: end if;
537: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.INSERT_LEVEL_INTO_TABLE');
538: if (l_procedureEnabled) then
539: ecx_debug.pop(i_method_name);
540: end if;
541: raise ecx_utils.program_exit;

Line 551: ecx_debug.log(l_unexpected,'ECX', 'ECX_PROGRAM_ERROR',i_method_name, 'PROGRESS_LEVEL', 'ECX_ACTIONS.INSERT_LEVEL_INTO_TABLE');

547: raise;
548:
549: WHEN others then
550: if(l_unexpectedEnabled) then
551: ecx_debug.log(l_unexpected,'ECX', 'ECX_PROGRAM_ERROR',i_method_name, 'PROGRESS_LEVEL', 'ECX_ACTIONS.INSERT_LEVEL_INTO_TABLE');
552: ecx_debug.log(l_unexpected,'ECX', 'ECX_ERROR_MESSAGE',i_method_name, 'ERROR_MESSAGE', SQLERRM);
553: end if;
554: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.INSERT_LEVEL_INTO_TABLE');
555:

Line 554: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.INSERT_LEVEL_INTO_TABLE');

550: if(l_unexpectedEnabled) then
551: ecx_debug.log(l_unexpected,'ECX', 'ECX_PROGRAM_ERROR',i_method_name, 'PROGRESS_LEVEL', 'ECX_ACTIONS.INSERT_LEVEL_INTO_TABLE');
552: ecx_debug.log(l_unexpected,'ECX', 'ECX_ERROR_MESSAGE',i_method_name, 'ERROR_MESSAGE', SQLERRM);
553: end if;
554: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.INSERT_LEVEL_INTO_TABLE');
555:
556: if (l_procedureEnabled) then
557: ecx_debug.pop(i_method_name);
558: end if;

Line 572: i_method_name varchar2(2000) := 'ecx_actions.execute_string';

568: procedure execute_string (
569: cString IN Varchar2,
570: o_value OUT NOCOPY Varchar2) IS
571:
572: i_method_name varchar2(2000) := 'ecx_actions.execute_string';
573:
574: cursor_handle pls_integer;
575: ret_query pls_integer;
576: m_value Varchar2(20000);

Line 619: ecx_debug.log(l_unexpected, 'ECX', 'ECX_PROGRAM_ERROR', i_method_name, 'PROGRESS_LEVEL', 'ECX_ACTIONS.EXECUTE_STRING');

615: WHEN PARSE_ERROR then
616: error_position := dbms_sql.last_error_position;
617: ecx_error_handling_pvt.print_parse_error (error_position,cString);
618: if(l_unexpectedEnabled) then
619: ecx_debug.log(l_unexpected, 'ECX', 'ECX_PROGRAM_ERROR', i_method_name, 'PROGRESS_LEVEL', 'ECX_ACTIONS.EXECUTE_STRING');
620: ecx_debug.log(l_unexpected, 'ECX', 'ECX_ERROR_MESSAGE', i_method_name, 'ERROR_MESSAGE', SQLERRM);
621: end if;
622: if dbms_sql.is_open(cursor_handle) then
623: dbms_sql.close_cursor(cursor_handle);

Line 640: 'ECX_ACTIONS.EXECUTE_STRING');

636: dbms_sql.close_cursor(cursor_handle);
637: end if;
638: if(l_unexpectedEnabled) then
639: ecx_debug.log(l_unexpected,'ECX', 'ECX_PROGRAM_ERROR', i_method_name,'PROGRESS_LEVEL',
640: 'ECX_ACTIONS.EXECUTE_STRING');
641: ecx_debug.log(l_unexpected, 'ECX', 'ECX_ERROR_MESSAGE', i_method_name, 'ERROR_MESSAGE', SQLERRM);
642: end if;
643: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.EXECUTE_STRING');
644: if (l_procedureEnabled) then

Line 643: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.EXECUTE_STRING');

639: ecx_debug.log(l_unexpected,'ECX', 'ECX_PROGRAM_ERROR', i_method_name,'PROGRESS_LEVEL',
640: 'ECX_ACTIONS.EXECUTE_STRING');
641: ecx_debug.log(l_unexpected, 'ECX', 'ECX_ERROR_MESSAGE', i_method_name, 'ERROR_MESSAGE', SQLERRM);
642: end if;
643: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.EXECUTE_STRING');
644: if (l_procedureEnabled) then
645: ecx_debug.pop(i_method_name);
646: end if;
647: raise ecx_utils.PROGRAM_EXIT;

Line 656: i_method_name varchar2(2000) := 'ecx_actions.get_nextval_seq';

652: procedure get_nextval_seq (
653: i_seq_name IN Varchar2,
654: o_value OUT NOCOPY Varchar2) IS
655:
656: i_method_name varchar2(2000) := 'ecx_actions.get_nextval_seq';
657: cString Varchar2(2000);
658:
659: BEGIN
660: if (l_procedureEnabled) then

Line 682: 'ECX_ACTIONS.GET_NEXTVAL_SEQ');

678:
679: WHEN OTHERS then
680: if(l_unexpectedEnabled) then
681: ecx_debug.log(l_unexpected, 'ECX', 'ECX_PROGRAM_ERROR',i_method_name, 'PROGRESS_LEVEL',
682: 'ECX_ACTIONS.GET_NEXTVAL_SEQ');
683: ecx_debug.log(l_unexpected, 'ECX', 'ECX_ERROR_MESSAGE',i_method_name, 'ERROR_MESSAGE', SQLERRM);
684: end if;
685: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.GET_NEXTVAL_SEQ');
686: if (l_procedureEnabled) then

Line 685: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.GET_NEXTVAL_SEQ');

681: ecx_debug.log(l_unexpected, 'ECX', 'ECX_PROGRAM_ERROR',i_method_name, 'PROGRESS_LEVEL',
682: 'ECX_ACTIONS.GET_NEXTVAL_SEQ');
683: ecx_debug.log(l_unexpected, 'ECX', 'ECX_ERROR_MESSAGE',i_method_name, 'ERROR_MESSAGE', SQLERRM);
684: end if;
685: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.GET_NEXTVAL_SEQ');
686: if (l_procedureEnabled) then
687: ecx_debug.pop(i_method_name);
688: end if;
689: raise ecx_utils.PROGRAM_EXIT;

Line 702: i_method_name varchar2(2000) := 'ecx_actions.get_function_value';

698: procedure get_function_value (
699: i_function_name IN Varchar2,
700: o_value OUT NOCOPY Varchar2) IS
701:
702: i_method_name varchar2(2000) := 'ecx_actions.get_function_value';
703: cString Varchar2(2000);
704:
705: BEGIN
706: if (l_procedureEnabled) then

Line 733: 'ECX_ACTIONS.GET_FUNCTION_VALUE');

729:
730: WHEN OTHERS then
731: if(l_unexpectedEnabled) then
732: ecx_debug.log(l_unexpected,'ECX', 'ECX_PROGRAM_ERROR', i_method_name,'PROGRESS_LEVEL',
733: 'ECX_ACTIONS.GET_FUNCTION_VALUE');
734: ecx_debug.log(l_unexpected, 'ECX', 'ECX_ERROR_MESSAGE',i_method_name, 'ERROR_MESSAGE', SQLERRM);
735: end if;
736: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.GET_FUNCTION_VALUE');
737: if (l_procedureEnabled) then

Line 736: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.GET_FUNCTION_VALUE');

732: ecx_debug.log(l_unexpected,'ECX', 'ECX_PROGRAM_ERROR', i_method_name,'PROGRESS_LEVEL',
733: 'ECX_ACTIONS.GET_FUNCTION_VALUE');
734: ecx_debug.log(l_unexpected, 'ECX', 'ECX_ERROR_MESSAGE',i_method_name, 'ERROR_MESSAGE', SQLERRM);
735: end if;
736: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.GET_FUNCTION_VALUE');
737: if (l_procedureEnabled) then
738: ecx_debug.pop(i_method_name);
739: end if;
740: raise ecx_utils.PROGRAM_EXIT;

Line 747: i_method_name varchar2(2000) := 'ecx_actions.dump_stack';

743:
744:
745: procedure dump_stack IS
746:
747: i_method_name varchar2(2000) := 'ecx_actions.dump_stack';
748: m_count pls_integer := ecx_utils.g_stack.COUNT;
749:
750: BEGIN
751: if (l_procedureEnabled) then

Line 776: ecx_debug.log(l_unexpected,'ECX', 'ECX_PROGRAM_ERROR', i_method_name,'PROGRESS_LEVEL', 'ECX_ACTIONS.DUMP_STACK');

772:
773: EXCEPTION
774: WHEN OTHERS then
775: if(l_unexpectedEnabled) then
776: ecx_debug.log(l_unexpected,'ECX', 'ECX_PROGRAM_ERROR', i_method_name,'PROGRESS_LEVEL', 'ECX_ACTIONS.DUMP_STACK');
777: ecx_debug.log(l_unexpected, 'ECX', 'ECX_ERROR_MESSAGE', i_method_name,'ERROR_MESSAGE',SQLERRM);
778: end if;
779: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.DUMP_STACK');
780: if (l_procedureEnabled) then

Line 779: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.DUMP_STACK');

775: if(l_unexpectedEnabled) then
776: ecx_debug.log(l_unexpected,'ECX', 'ECX_PROGRAM_ERROR', i_method_name,'PROGRESS_LEVEL', 'ECX_ACTIONS.DUMP_STACK');
777: ecx_debug.log(l_unexpected, 'ECX', 'ECX_ERROR_MESSAGE', i_method_name,'ERROR_MESSAGE',SQLERRM);
778: end if;
779: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.DUMP_STACK');
780: if (l_procedureEnabled) then
781: ecx_debug.pop(i_method_name);
782: end if;
783: raise ecx_utils.PROGRAM_EXIT;

Line 806: i_method_name varchar2(2000) := 'ecx_actions.concat_variables';

802: i_next_default_value IN varchar2
803: )
804: IS
805:
806: i_method_name varchar2(2000) := 'ecx_actions.concat_variables';
807:
808: var_value Varchar2(4000);
809: var_on_stack Boolean := FALSE;
810: var_stack_pos pls_integer;

Line 896: 'PROGRESS_LEVEL', 'ECX_ACTIONS.CONCAT_VAR');

892: raise ecx_utils.PROGRAM_EXIT;
893: WHEN OTHERS THEN
894: if(l_unexpectedEnabled) then
895: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,
896: 'PROGRESS_LEVEL', 'ECX_ACTIONS.CONCAT_VAR');
897: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
898: end if;
899: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.CONCAT_VAR');
900: if (l_procedureEnabled) then

Line 899: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.CONCAT_VAR');

895: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,
896: 'PROGRESS_LEVEL', 'ECX_ACTIONS.CONCAT_VAR');
897: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
898: end if;
899: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.CONCAT_VAR');
900: if (l_procedureEnabled) then
901: ecx_debug.pop(i_method_name);
902: end if;
903: raise ecx_utils.PROGRAM_EXIT;

Line 931: i_method_name varchar2(2000) := 'ecx_actions.substr_variables';

927: i_operand3_constant IN varchar2
928: )
929: IS
930:
931: i_method_name varchar2(2000) := 'ecx_actions.substr_variables';
932: var_value Varchar2(4000);
933: var_on_stack Boolean := FALSE;
934: var_stack_pos pls_integer;
935: pre_var_value Varchar2(4000);

Line 1021: 'PROGRESS_LEVEL', 'ECX_ACTIONS.SUBSTR_VAR');

1017:
1018: WHEN OTHERS THEN
1019: if(l_unexpectedEnabled) then
1020: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,
1021: 'PROGRESS_LEVEL', 'ECX_ACTIONS.SUBSTR_VAR');
1022: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,
1023: 'ERROR_MESSAGE',SQLERRM);
1024: end if;
1025: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.SUBSTR_VAR');

Line 1025: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.SUBSTR_VAR');

1021: 'PROGRESS_LEVEL', 'ECX_ACTIONS.SUBSTR_VAR');
1022: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,
1023: 'ERROR_MESSAGE',SQLERRM);
1024: end if;
1025: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.SUBSTR_VAR');
1026: if (l_procedureEnabled) then
1027: ecx_debug.pop(i_method_name);
1028: end if;
1029: raise ecx_utils.PROGRAM_EXIT;

Line 1049: i_method_name varchar2(2000) := 'ecx_actions.assign_pre_defined_variables';

1045: i_previous_variable_direction IN Varchar2,
1046: i_previous_variable_pos IN pls_integer,
1047: i_previous_variable_constant IN varchar2) IS
1048:
1049: i_method_name varchar2(2000) := 'ecx_actions.assign_pre_defined_variables';
1050:
1051: var_value Varchar2(4000);
1052: var_on_stack Boolean := FALSE;
1053: var_stack_pos pls_integer;

Line 1101: 'ECX_ACTIONS.ASSIGN_PRE_DEFINED_VARIABLES');

1097: WHEN OTHERS THEN
1098: if(l_unexpectedEnabled) then
1099: ecx_debug.log(l_unexpected,'ECX', 'ECX_PROGRAM_ERROR', i_method_name,
1100: 'PROGRESS_LEVEL',
1101: 'ECX_ACTIONS.ASSIGN_PRE_DEFINED_VARIABLES');
1102: ecx_debug.log(l_unexpected, 'ECX', 'ECX_ERROR_MESSAGE',i_method_name,
1103: 'ERROR_MESSAGE', SQLERRM);
1104: end if;
1105: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.ASSIGN_PRE_DEFINED_VARIABLES');

Line 1105: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.ASSIGN_PRE_DEFINED_VARIABLES');

1101: 'ECX_ACTIONS.ASSIGN_PRE_DEFINED_VARIABLES');
1102: ecx_debug.log(l_unexpected, 'ECX', 'ECX_ERROR_MESSAGE',i_method_name,
1103: 'ERROR_MESSAGE', SQLERRM);
1104: end if;
1105: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.ASSIGN_PRE_DEFINED_VARIABLES');
1106: if (l_procedureEnabled) then
1107: ecx_debug.pop(i_method_name);
1108: end if;
1109: raise ecx_utils.PROGRAM_EXIT;

Line 1125: i_method_name varchar2(2000) := 'ecx_actions.assign_nextval_from_sequence';

1121: i_variable_direction IN Varchar2,
1122: i_variable_pos IN pls_integer,
1123: i_sequence_name IN Varchar2) IS
1124:
1125: i_method_name varchar2(2000) := 'ecx_actions.assign_nextval_from_sequence';
1126:
1127: var_value Varchar2(4000);
1128: var_on_stack Boolean := FALSE;
1129: var_stack_pos pls_integer;

Line 1162: 'ECX_ACTIONS.ASSIGN_NEXTVAL_FROM_SEQUENCE');

1158:
1159: WHEN OTHERS THEN
1160: if(l_unexpectedEnabled) then
1161: ecx_debug.log(l_unexpected,'ECX', 'ECX_PROGRAM_ERROR', i_method_name,'PROGRESS_LEVEL',
1162: 'ECX_ACTIONS.ASSIGN_NEXTVAL_FROM_SEQUENCE');
1163: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
1164: end if;
1165: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.ASSIGN_NEXTVAL_FROM_SEQUENCE');
1166: if (l_procedureEnabled) then

Line 1165: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.ASSIGN_NEXTVAL_FROM_SEQUENCE');

1161: ecx_debug.log(l_unexpected,'ECX', 'ECX_PROGRAM_ERROR', i_method_name,'PROGRESS_LEVEL',
1162: 'ECX_ACTIONS.ASSIGN_NEXTVAL_FROM_SEQUENCE');
1163: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
1164: end if;
1165: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.ASSIGN_NEXTVAL_FROM_SEQUENCE');
1166: if (l_procedureEnabled) then
1167: ecx_debug.pop(i_method_name);
1168: end if;
1169: raise ecx_utils.PROGRAM_EXIT;

Line 1184: i_method_name varchar2(2000) := 'ecx_actions.assign_function_value';

1180: i_variable_direction IN Varchar2,
1181: i_variable_pos IN pls_integer,
1182: i_function_name IN Varchar2) IS
1183:
1184: i_method_name varchar2(2000) := 'ecx_actions.assign_function_value';
1185:
1186: var_value Varchar2(4000);
1187: var_on_stack Boolean := FALSE;
1188: var_stack_pos pls_integer;

Line 1219: 'PROGRESS_LEVEL', 'ECX_ACTIONS.ASSIGN_FUNCTION_VALUE');

1215:
1216: WHEN OTHERS THEN
1217: if(l_unexpectedEnabled) then
1218: ecx_debug.log(l_unexpected,'ECX', 'ECX_PROGRAM_ERROR',i_method_name,
1219: 'PROGRESS_LEVEL', 'ECX_ACTIONS.ASSIGN_FUNCTION_VALUE');
1220: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,
1221: 'ERROR_MESSAGE',SQLERRM);
1222: end if;
1223: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.ASSIGN_FUNCTION_VALUE');

Line 1223: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.ASSIGN_FUNCTION_VALUE');

1219: 'PROGRESS_LEVEL', 'ECX_ACTIONS.ASSIGN_FUNCTION_VALUE');
1220: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,
1221: 'ERROR_MESSAGE',SQLERRM);
1222: end if;
1223: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.ASSIGN_FUNCTION_VALUE');
1224: if (l_procedureEnabled) then
1225: ecx_debug.pop(i_method_name);
1226: end if;
1227: raise ecx_utils.PROGRAM_EXIT;

Line 1236: i_method_name varchar2(2000) := 'ecx_actions.append_clause';

1232: procedure append_clause (
1233: i_level IN pls_integer,
1234: i_where_clause IN Varchar2) IS
1235:
1236: i_method_name varchar2(2000) := 'ecx_actions.append_clause';
1237:
1238:
1239: BEGIN
1240: if (l_procedureEnabled) then

Line 1271: 'ECX_ACTIONS.APPEND_CLAUSE');

1267: WHEN OTHERS THEN
1268: if(l_unexpectedEnabled) then
1269: ecx_debug.log(l_unexpected, 'ECX', 'ECX_PROGRAM_ERROR', i_method_name,
1270: 'PROGRESS_LEVEL',
1271: 'ECX_ACTIONS.APPEND_CLAUSE');
1272: ecx_debug.log(l_unexpected, 'ECX', 'ECX_ERROR_MESSAGE', i_method_name,
1273: 'ERROR_MESSAGE',SQLERRM);
1274: end if;
1275: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.APPEND_CLAUSE');

Line 1275: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.APPEND_CLAUSE');

1271: 'ECX_ACTIONS.APPEND_CLAUSE');
1272: ecx_debug.log(l_unexpected, 'ECX', 'ECX_ERROR_MESSAGE', i_method_name,
1273: 'ERROR_MESSAGE',SQLERRM);
1274: end if;
1275: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.APPEND_CLAUSE');
1276: if (l_procedureEnabled) then
1277: ecx_debug.pop(i_method_name);
1278: end if;
1279: raise ecx_utils.PROGRAM_EXIT;

Line 1288: i_method_name varchar2(2000) := 'ecx_actions.get_var_attr';

1284: i_stage IN pls_integer,
1285: i_level IN pls_integer
1286: ) IS
1287:
1288: i_method_name varchar2(2000) := 'ecx_actions.get_var_attr';
1289: pre_var_value Varchar2(2000);
1290: pre_var_on_stack Boolean;
1291: pre_var_stack_pos pls_integer;
1292: i_date date;

Line 1338: 'PROGRESS_LEVEL','ECX_ACTIONS.APPEND_CLAUSE_FOR_VIEW');

1334:
1335: WHEN OTHERS THEN
1336: if(l_statementEnabled) then
1337: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,
1338: 'PROGRESS_LEVEL','ECX_ACTIONS.APPEND_CLAUSE_FOR_VIEW');
1339: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
1340: end if;
1341: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.APPEND_CLAUSE_FOR_VIEW');
1342: if (l_procedureEnabled) then

Line 1341: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.APPEND_CLAUSE_FOR_VIEW');

1337: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,
1338: 'PROGRESS_LEVEL','ECX_ACTIONS.APPEND_CLAUSE_FOR_VIEW');
1339: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
1340: end if;
1341: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.APPEND_CLAUSE_FOR_VIEW');
1342: if (l_procedureEnabled) then
1343: ecx_debug.pop(i_method_name);
1344: end if;
1345: raise ecx_utils.PROGRAM_EXIT;

Line 1354: i_method_name varchar2(2000) := 'ecx_actions.bind_variables_for_view';

1350: i_stage IN pls_integer,
1351: i_level IN pls_integer
1352: ) IS
1353:
1354: i_method_name varchar2(2000) := 'ecx_actions.bind_variables_for_view';
1355: pre_var_value Varchar2(4000);
1356: pre_var_on_stack Boolean;
1357: pre_var_stack_pos pls_integer;
1358: i_date date;

Line 1472: 'PROGRESS_LEVEL','ECX_ACTIONS.BIND_VARIABLES_FOR_VIEW');

1468:
1469: WHEN OTHERS THEN
1470: if(l_unexpectedEnabled) then
1471: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,
1472: 'PROGRESS_LEVEL','ECX_ACTIONS.BIND_VARIABLES_FOR_VIEW');
1473: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,
1474: 'ERROR_MESSAGE',SQLERRM);
1475: end if;
1476: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.BIND_VARIABLES_FOR_VIEW');

Line 1476: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.BIND_VARIABLES_FOR_VIEW');

1472: 'PROGRESS_LEVEL','ECX_ACTIONS.BIND_VARIABLES_FOR_VIEW');
1473: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,
1474: 'ERROR_MESSAGE',SQLERRM);
1475: end if;
1476: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.BIND_VARIABLES_FOR_VIEW');
1477: if (l_procedureEnabled) then
1478: ecx_debug.pop(i_method_name);
1479: end if;
1480: raise ecx_utils.PROGRAM_EXIT;

Line 1490: i_method_name varchar2(2000) := 'ecx_actions.build_procedure_call';

1486: p_transtage_id IN pls_integer,
1487: p_procedure_name IN Varchar2,
1488: x_proc_cursor OUT NOCOPY pls_integer) IS
1489:
1490: i_method_name varchar2(2000) := 'ecx_actions.build_procedure_call';
1491:
1492: error_position pls_integer;
1493: l_proc_call Varchar2(32000);
1494: l_first_param Boolean := True;

Line 1547: 'PROGRESS_LEVEL','ECX_ACTIONS.BUILD_PROCEDURE_CALL');

1543: WHEN PARSE_ERROR then
1544: error_position := dbms_sql.last_error_position;
1545: if(l_unexpectedEnabled) then
1546: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,
1547: 'PROGRESS_LEVEL','ECX_ACTIONS.BUILD_PROCEDURE_CALL');
1548: end if;
1549: ecx_error_handling_pvt.print_parse_error (error_position, l_proc_call);
1550: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.BUILD_PROCEDURE_CALL');
1551: if (l_procedureEnabled) then

Line 1550: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.BUILD_PROCEDURE_CALL');

1546: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,
1547: 'PROGRESS_LEVEL','ECX_ACTIONS.BUILD_PROCEDURE_CALL');
1548: end if;
1549: ecx_error_handling_pvt.print_parse_error (error_position, l_proc_call);
1550: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.BUILD_PROCEDURE_CALL');
1551: if (l_procedureEnabled) then
1552: ecx_debug.pop(i_method_name);
1553: end if;
1554: raise ecx_utils.program_exit;

Line 1565: 'PROGRESS_LEVEL','ECX_ACTIONS.BUILD_PROCEDURE_CALL');

1561:
1562: WHEN OTHERS THEN
1563: if(l_unexpectedEnabled) then
1564: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,
1565: 'PROGRESS_LEVEL','ECX_ACTIONS.BUILD_PROCEDURE_CALL');
1566: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
1567: end if;
1568: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.BUILD_PROCEDURE_CALL');
1569: if (l_procedureEnabled) then

Line 1568: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.BUILD_PROCEDURE_CALL');

1564: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,
1565: 'PROGRESS_LEVEL','ECX_ACTIONS.BUILD_PROCEDURE_CALL');
1566: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
1567: end if;
1568: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.BUILD_PROCEDURE_CALL');
1569: if (l_procedureEnabled) then
1570: ecx_debug.pop(i_method_name);
1571: end if;
1572: raise ecx_utils.PROGRAM_EXIT;

Line 1581: i_method_name varchar2(2000) := 'ecx_actions.bind_proc_variables';

1577: p_transtage_id IN pls_integer,
1578: p_procedure_name IN Varchar2,
1579: p_proc_cursor IN pls_integer) IS
1580:
1581: i_method_name varchar2(2000) := 'ecx_actions.bind_proc_variables';
1582: l_stack_found Boolean;
1583: l_var_value Varchar2(32767);
1584: l_stack_pos pls_integer;
1585: l_numrows pls_integer;

Line 1799: 'PROGRESS_LEVEL','ECX_ACTIONS.BIND_PROC_VARIABLES');

1795:
1796: WHEN OTHERS THEN
1797: if(l_unexpectedEnabled) then
1798: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,
1799: 'PROGRESS_LEVEL','ECX_ACTIONS.BIND_PROC_VARIABLES');
1800: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
1801: end if;
1802: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.BIND_PROC_VARIABLES');
1803: if dbms_lob.istemporary(l_temp_loc) = 1 Then

Line 1802: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.BIND_PROC_VARIABLES');

1798: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,
1799: 'PROGRESS_LEVEL','ECX_ACTIONS.BIND_PROC_VARIABLES');
1800: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
1801: end if;
1802: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.BIND_PROC_VARIABLES');
1803: if dbms_lob.istemporary(l_temp_loc) = 1 Then
1804: dbms_lob.freetemporary(l_temp_loc);
1805: end if;
1806: if dbms_lob.istemporary(l_clob_value) = 1 Then

Line 1822: i_method_name varchar2(2000) := 'ecx_actions.assign_out_variables';

1818: p_transtage_id IN pls_integer,
1819: p_procedure_name IN Varchar2,
1820: p_proc_cursor IN pls_integer) IS
1821:
1822: i_method_name varchar2(2000) := 'ecx_actions.assign_out_variables';
1823:
1824: l_stack_var Boolean;
1825: l_var_pos pls_integer;
1826: l_stack_pos pls_integer;

Line 2039: 'PROGRESS_LEVEL','ECX_ACTIONS.ASSIGN_OUT_VARIABLES');

2035:
2036: WHEN OTHERS THEN
2037: if(l_unexpectedEnabled) then
2038: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,
2039: 'PROGRESS_LEVEL','ECX_ACTIONS.ASSIGN_OUT_VARIABLES');
2040: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
2041: end if;
2042: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.ASSIGN_OUT_VARIABLES');
2043: if (l_procedureEnabled) then

Line 2042: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.ASSIGN_OUT_VARIABLES');

2038: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,
2039: 'PROGRESS_LEVEL','ECX_ACTIONS.ASSIGN_OUT_VARIABLES');
2040: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
2041: end if;
2042: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.ASSIGN_OUT_VARIABLES');
2043: if (l_procedureEnabled) then
2044: ecx_debug.pop(i_method_name);
2045: end if;
2046: raise ecx_utils.PROGRAM_EXIT;

Line 2065: i_method_name varchar2(2000) := 'ecx_actions.execute_proc';

2061: procedure execute_proc (
2062: i_transtage_id IN pls_integer,
2063: i_procedure_name IN Varchar2) IS
2064:
2065: i_method_name varchar2(2000) := 'ecx_actions.execute_proc';
2066:
2067: BEGIN
2068: if (l_procedureEnabled) then
2069: ecx_debug.push(i_method_name);

Line 2095: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL','ECX_ACTIONS.EXECUTE_PROC');

2091: raise;
2092:
2093: WHEN OTHERS THEN
2094: if(l_unexpectedEnabled) then
2095: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL','ECX_ACTIONS.EXECUTE_PROC');
2096: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
2097: end if;
2098: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.EXECUTE_PROC');
2099: if (l_procedureEnabled) then

Line 2098: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.EXECUTE_PROC');

2094: if(l_unexpectedEnabled) then
2095: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL','ECX_ACTIONS.EXECUTE_PROC');
2096: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
2097: end if;
2098: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.EXECUTE_PROC');
2099: if (l_procedureEnabled) then
2100: ecx_debug.pop(i_method_name);
2101: end if;
2102: raise ecx_utils.PROGRAM_EXIT;

Line 2108: i_method_name varchar2(2000) := 'ecx_actions.exit_program';

2104: END execute_proc;
2105:
2106: procedure exit_program
2107: IS
2108: i_method_name varchar2(2000) := 'ecx_actions.exit_program';
2109: begin
2110: ecx_debug.setErrorInfo(1,20,'ECX_USER_INVOKED_EXIT');
2111: raise ecx_utils.program_exit;
2112: exception

Line 2117: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL','ECX_ACTIONS.EXIT_PROGRAM');

2113: WHEN ecx_utils.PROGRAM_EXIT then
2114: raise ecx_utils.program_exit;
2115: WHEN OTHERS THEN
2116: if(l_unexpectedEnabled) then
2117: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL','ECX_ACTIONS.EXIT_PROGRAM');
2118: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
2119: end if;
2120: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.EXIT_PROGRAM');
2121: raise ecx_utils.PROGRAM_EXIT;

Line 2120: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.EXIT_PROGRAM');

2116: if(l_unexpectedEnabled) then
2117: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL','ECX_ACTIONS.EXIT_PROGRAM');
2118: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
2119: end if;
2120: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.EXIT_PROGRAM');
2121: raise ecx_utils.PROGRAM_EXIT;
2122: end exit_program;
2123:
2124: /** This procedure is overloaded below **/

Line 2132: i_method_name varchar2(2000) := 'ecx_actions.set_error_exit_program';

2128: i_err_msg in varchar2
2129: )
2130: IS
2131:
2132: i_method_name varchar2(2000) := 'ecx_actions.set_error_exit_program';
2133: i_len pls_integer := 0;
2134: i_prod_code_cnt pls_integer :=0;
2135:
2136: /* Start of Bug 2186358 */

Line 2196: 'PROGRESS_LEVEL','ECX_ACTIONS.SET_ERR_EXIT_PROGRAM');

2192: ecx_debug.pop(i_method_name);
2193: end if;
2194: /*if(l_statementEnabled) then
2195: ecx_debug.log(l_statement,'ECX','ECX_PROGRAM_ERROR',i_method_name,
2196: 'PROGRESS_LEVEL','ECX_ACTIONS.SET_ERR_EXIT_PROGRAM');
2197: ecx_debug.log(l_statement,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
2198: end if;*/
2199: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.SET_ERR_EXIT_PROGRAM');
2200: raise ecx_utils.PROGRAM_EXIT;

Line 2199: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.SET_ERR_EXIT_PROGRAM');

2195: ecx_debug.log(l_statement,'ECX','ECX_PROGRAM_ERROR',i_method_name,
2196: 'PROGRESS_LEVEL','ECX_ACTIONS.SET_ERR_EXIT_PROGRAM');
2197: ecx_debug.log(l_statement,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
2198: end if;*/
2199: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.SET_ERR_EXIT_PROGRAM');
2200: raise ecx_utils.PROGRAM_EXIT;
2201: end set_error_exit_program;
2202:
2203: /** Overloaded for enabling MLS for user invoked error

Line 2231: i_method_name varchar2(2000) := 'ecx_actions.set_error_exit_program';

2227: p_token10 in varchar2,
2228: p_value10 in varchar2
2229: )
2230: IS
2231: i_method_name varchar2(2000) := 'ecx_actions.set_error_exit_program';
2232: i_len pls_integer := 0;
2233: i_prod_code_cnt pls_integer :=0;
2234:
2235: /* Start of Bug 2186358 */

Line 2335: 'PROGRESS_LEVEL','ECX_ACTIONS.SET_ERR_EXIT_PROGRAM');

2331: ecx_debug.pop(i_method_name);
2332: end if;
2333: if(l_unexpectedEnabled) then
2334: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,
2335: 'PROGRESS_LEVEL','ECX_ACTIONS.SET_ERR_EXIT_PROGRAM');
2336: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
2337: end if;
2338: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.SET_ERR_EXIT_PROGRAM');
2339: raise ecx_utils.PROGRAM_EXIT;

Line 2338: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.SET_ERR_EXIT_PROGRAM');

2334: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,
2335: 'PROGRESS_LEVEL','ECX_ACTIONS.SET_ERR_EXIT_PROGRAM');
2336: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
2337: end if;
2338: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.SET_ERR_EXIT_PROGRAM');
2339: raise ecx_utils.PROGRAM_EXIT;
2340: end set_error_exit_program;
2341:
2342:

Line 2365: i_method_name varchar2(2000) := 'ecx_actions.send_err';

2361: pre_var_stack_pos pls_integer;
2362: o_ret_code pls_integer;
2363: o_ret_msg Varchar2(2000);
2364:
2365: i_method_name varchar2(2000) := 'ecx_actions.send_err';
2366: BEGIN
2367: if (l_procedureEnabled) then
2368: ecx_debug.push(i_method_name);
2369: end if;

Line 2423: 'PROGRESS_LEVEL','ECX_ACTIONS.SEND_ERR');

2419:
2420: WHEN OTHERS THEN
2421: if(l_unexpectedEnabled) then
2422: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,
2423: 'PROGRESS_LEVEL','ECX_ACTIONS.SEND_ERR');
2424: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
2425: end if;
2426: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.SEND_ERR');
2427: if (l_procedureEnabled) then

Line 2426: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.SEND_ERR');

2422: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,
2423: 'PROGRESS_LEVEL','ECX_ACTIONS.SEND_ERR');
2424: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
2425: end if;
2426: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.SEND_ERR');
2427: if (l_procedureEnabled) then
2428: ecx_debug.pop(i_method_name);
2429: end if;
2430: raise ecx_utils.PROGRAM_EXIT;

Line 2446: i_method_name varchar2(2000) := 'ecx_actions.get_api_retcode';

2442: i_previous_variable_direction IN varchar2,
2443: i_previous_variable_pos IN pls_integer,
2444: i_function_name IN varchar2) IS
2445:
2446: i_method_name varchar2(2000) := 'ecx_actions.get_api_retcode';
2447:
2448: var_value Varchar2(2000);
2449: var_on_stack Boolean := FALSE;
2450: var_stack_pos pls_integer;

Line 2527: 'PROGRESS_LEVEL','ECX_ACTIONS.GET_API_RETCODE');

2523:
2524: WHEN OTHERS THEN
2525: if(l_unexpectedEnabled) then
2526: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,
2527: 'PROGRESS_LEVEL','ECX_ACTIONS.GET_API_RETCODE');
2528: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
2529: end if;
2530: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.GET_API_RETCODE');
2531: if (l_procedureEnabled) then

Line 2530: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.GET_API_RETCODE');

2526: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,
2527: 'PROGRESS_LEVEL','ECX_ACTIONS.GET_API_RETCODE');
2528: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
2529: end if;
2530: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.GET_API_RETCODE');
2531: if (l_procedureEnabled) then
2532: ecx_debug.pop(i_method_name);
2533: end if;
2534: raise ecx_utils.PROGRAM_EXIT;

Line 2544: i_method_name varchar2(2000) := 'ecx_actions.split_number';

2540: p_value OUT NOCOPY VARCHAR2,
2541: p_sign OUT NOCOPY VARCHAR2,
2542: p_numofdec OUT NOCOPY VARCHAR2) IS
2543:
2544: i_method_name varchar2(2000) := 'ecx_actions.split_number';
2545:
2546: num1 NUMBER := 0;
2547: num2 NUMBER := 0;
2548: numchar VARCHAR2(40);

Line 2652: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL','ECX_ACTIONS.SPLIT_NUMBER');

2648: raise;
2649:
2650: WHEN OTHERS THEN
2651: if(l_unexpectedEnabled) then
2652: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL','ECX_ACTIONS.SPLIT_NUMBER');
2653: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
2654: end if;
2655: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.SPLIT_NUMBER');
2656: if (l_procedureEnabled) then

Line 2655: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.SPLIT_NUMBER');

2651: if(l_unexpectedEnabled) then
2652: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL','ECX_ACTIONS.SPLIT_NUMBER');
2653: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
2654: end if;
2655: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.SPLIT_NUMBER');
2656: if (l_procedureEnabled) then
2657: ecx_debug.pop(i_method_name);
2658: end if;
2659: raise ecx_utils.PROGRAM_EXIT;

Line 2677: i_method_name varchar2(2000) := 'ecx_actions.gmt_offset';

2673:
2674: ) return varchar2
2675: is
2676:
2677: i_method_name varchar2(2000) := 'ecx_actions.gmt_offset';
2678: i_server_offset number;
2679: i_server_offset_hours number;
2680: i_server_offset_mins number;
2681: i_timezone varchar2(500);

Line 2689: if (ecx_actions.g_server_timezone is null) then

2685: if (l_procedureEnabled) then
2686: ecx_debug.push(i_method_name);
2687: end if;
2688:
2689: if (ecx_actions.g_server_timezone is null) then
2690: --- Check for the Installation Type ( Standalone or Embedded );
2691: if (ecx_utils.g_install_mode is null) then
2692: ecx_utils.g_install_mode := wf_core.translate('WF_INSTALL');
2693: end if;

Line 2698: fnd_profile.get('||'''ECX_SERVER_TIMEZONE'''||',ecx_actions.g_server_timezone);

2694:
2695: if ecx_utils.g_install_mode = 'EMBEDDED'
2696: then
2697: i_string := 'begin
2698: fnd_profile.get('||'''ECX_SERVER_TIMEZONE'''||',ecx_actions.g_server_timezone);
2699: end;';
2700: execute immediate i_string ;
2701: else
2702: ecx_actions.g_server_timezone:= wf_core.translate('ECX_SERVER_TIMEZONE');

Line 2702: ecx_actions.g_server_timezone:= wf_core.translate('ECX_SERVER_TIMEZONE');

2698: fnd_profile.get('||'''ECX_SERVER_TIMEZONE'''||',ecx_actions.g_server_timezone);
2699: end;';
2700: execute immediate i_string ;
2701: else
2702: ecx_actions.g_server_timezone:= wf_core.translate('ECX_SERVER_TIMEZONE');
2703: end if;
2704: end if;
2705:
2706:

Line 2708: if (ecx_actions.g_server_timezone is null) then

2704: end if;
2705:
2706:
2707: -- if profile option is not set assume gmt
2708: if (ecx_actions.g_server_timezone is null) then
2709: ecx_actions.g_server_timezone := 'GMT';
2710: end if;
2711:
2712: -- get the DB server offset from the Java API

Line 2709: ecx_actions.g_server_timezone := 'GMT';

2705:
2706:
2707: -- if profile option is not set assume gmt
2708: if (ecx_actions.g_server_timezone is null) then
2709: ecx_actions.g_server_timezone := 'GMT';
2710: end if;
2711:
2712: -- get the DB server offset from the Java API
2713: i_server_offset := getTimeZoneOffset(to_number(i_year), to_number(i_month),

Line 2716: ecx_actions.g_server_timezone);

2712: -- get the DB server offset from the Java API
2713: i_server_offset := getTimeZoneOffset(to_number(i_year), to_number(i_month),
2714: to_number(i_day), to_number(i_hour),
2715: to_number(i_minute), to_number(i_second),
2716: ecx_actions.g_server_timezone);
2717: if i_server_offset >= 0 then
2718: i_timezone_sign := '+';
2719: end if;
2720:

Line 2745: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL','ECX_ACTIONS.GMT_OFFSET');

2741: return(i_timezone);
2742: exception
2743: WHEN OTHERS THEN
2744: if(l_unexpectedEnabled) then
2745: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL','ECX_ACTIONS.GMT_OFFSET');
2746: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
2747: end if;
2748: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.GMT_OFFSET');
2749: if (l_procedureEnabled) then

Line 2748: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.GMT_OFFSET');

2744: if(l_unexpectedEnabled) then
2745: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL','ECX_ACTIONS.GMT_OFFSET');
2746: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
2747: end if;
2748: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.GMT_OFFSET');
2749: if (l_procedureEnabled) then
2750: ecx_debug.pop(i_method_name);
2751: end if;
2752: raise ecx_utils.PROGRAM_EXIT;

Line 2767: i_method_name varchar2(2000) := 'ecx_actions.convert_to_oag_date';

2763: i_opr1_direction IN varchar2,
2764: i_opr1_constant in varchar2
2765: ) IS
2766:
2767: i_method_name varchar2(2000) := 'ecx_actions.convert_to_oag_date';
2768: TYPE oag_dt_tbl is table of varchar2(10) index by BINARY_INTEGER;
2769:
2770: variable_value varchar2(2000);
2771: var date;

Line 2867: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL','ECX_ACTIONS.CONVERT_TO_OAG_DATE');

2863: raise;
2864:
2865: WHEN OTHERS THEN
2866: if(l_unexpectedEnabled) then
2867: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL','ECX_ACTIONS.CONVERT_TO_OAG_DATE');
2868: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
2869: end if;
2870: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.CONVERT_TO_OAG_DATE');
2871: if (l_procedureEnabled) then

Line 2870: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.CONVERT_TO_OAG_DATE');

2866: if(l_unexpectedEnabled) then
2867: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL','ECX_ACTIONS.CONVERT_TO_OAG_DATE');
2868: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
2869: end if;
2870: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.CONVERT_TO_OAG_DATE');
2871: if (l_procedureEnabled) then
2872: ecx_debug.pop(i_method_name);
2873: end if;
2874: raise ecx_utils.PROGRAM_EXIT;

Line 2900: i_method_name varchar2(2000) := 'ecx_actions.convert_to_oag_operamt';

2896: i_opr3_direction IN Varchar2,
2897: i_opr3_constant IN varchar2
2898: ) IS
2899:
2900: i_method_name varchar2(2000) := 'ecx_actions.convert_to_oag_operamt';
2901: TYPE oag_oamt_tbl is table of VARCHAR2(2000) index by BINARY_INTEGER;
2902: /** For Resultant **/
2903:
2904: var_value varchar2(2000);

Line 3056: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL','ECX_ACTIONS.CONVERT_TO_OAG_OPERAMT');

3052: raise;
3053:
3054: WHEN OTHERS THEN
3055: if(l_unexpectedEnabled) then
3056: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL','ECX_ACTIONS.CONVERT_TO_OAG_OPERAMT');
3057: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
3058: end if;
3059: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.CONVERT_TO_OAG_OPERAMT');
3060: if (l_procedureEnabled) then

Line 3059: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.CONVERT_TO_OAG_OPERAMT');

3055: if(l_unexpectedEnabled) then
3056: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL','ECX_ACTIONS.CONVERT_TO_OAG_OPERAMT');
3057: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
3058: end if;
3059: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.CONVERT_TO_OAG_OPERAMT');
3060: if (l_procedureEnabled) then
3061: ecx_debug.pop(i_method_name);
3062: end if;
3063: raise ecx_utils.PROGRAM_EXIT;

Line 3089: i_method_name varchar2(2000) := 'ecx_actions.convert_to_oag_amt';

3085: i_opr3_constant IN varchar2
3086: )
3087: is
3088:
3089: i_method_name varchar2(2000) := 'ecx_actions.convert_to_oag_amt';
3090: TYPE oag_oamt_tbl is table of VARCHAR2(2000) index by BINARY_INTEGER;
3091:
3092: var_value varchar2(2000);
3093: stack_var boolean := FALSE;

Line 3259: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL','ECX_ACTIONS.CONVERT_TO_OAG_AMT');

3255: raise;
3256:
3257: WHEN OTHERS THEN
3258: if(l_unexpectedEnabled) then
3259: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL','ECX_ACTIONS.CONVERT_TO_OAG_AMT');
3260: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
3261: end if;
3262: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.CONVERT_TO_OAG_AMT');
3263: if (l_procedureEnabled) then

Line 3262: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.CONVERT_TO_OAG_AMT');

3258: if(l_unexpectedEnabled) then
3259: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL','ECX_ACTIONS.CONVERT_TO_OAG_AMT');
3260: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
3261: end if;
3262: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.CONVERT_TO_OAG_AMT');
3263: if (l_procedureEnabled) then
3264: ecx_debug.pop(i_method_name);
3265: end if;
3266: raise ecx_utils.PROGRAM_EXIT;

Line 3286: i_method_name varchar2(2000) := 'ecx_actions.convert_to_oag_quantity';

3282: i_opr2_pos IN pls_integer,
3283: i_opr2_direction IN Varchar2,
3284: i_opr2_constant IN varchar2
3285: ) is
3286: i_method_name varchar2(2000) := 'ecx_actions.convert_to_oag_quantity';
3287: var_value varchar2(2000);
3288: stack_var boolean := FALSE;
3289: stack_pos pls_integer;
3290:

Line 3394: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL','ECX_ACTIONS.CONVERT_TO_OAG_QUANTITY');

3390: raise;
3391:
3392: WHEN OTHERS THEN
3393: if(l_unexpectedEnabled) then
3394: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL','ECX_ACTIONS.CONVERT_TO_OAG_QUANTITY');
3395: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
3396: end if;
3397: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.CONVERT_TO_OAG_QUANTITY');
3398: if (l_procedureEnabled) then

Line 3397: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.CONVERT_TO_OAG_QUANTITY');

3393: if(l_unexpectedEnabled) then
3394: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL','ECX_ACTIONS.CONVERT_TO_OAG_QUANTITY');
3395: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
3396: end if;
3397: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.CONVERT_TO_OAG_QUANTITY');
3398: if (l_procedureEnabled) then
3399: ecx_debug.pop(i_method_name);
3400: end if;
3401: raise ecx_utils.PROGRAM_EXIT;

Line 3411: i_method_name varchar2(2000) := 'ecx_actions.combine_number';

3407: p_value in varchar2,
3408: p_sign in varchar2,
3409: p_numofdec in varchar2) IS
3410:
3411: i_method_name varchar2(2000) := 'ecx_actions.combine_number';
3412:
3413: begin
3414:
3415: if (to_number(ltrim(rtrim(p_numofdec))) > 0) then

Line 3428: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL','ECX_ACTIONS.COMBINE_NUMBER');

3424:
3425: EXCEPTION
3426: WHEN OTHERS THEN
3427: if(l_unexpectedEnabled) then
3428: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL','ECX_ACTIONS.COMBINE_NUMBER');
3429: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
3430: end if;
3431: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.COMBINE_NUMBER');
3432: if (l_procedureEnabled) then

Line 3431: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.COMBINE_NUMBER');

3427: if(l_unexpectedEnabled) then
3428: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL','ECX_ACTIONS.COMBINE_NUMBER');
3429: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
3430: end if;
3431: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.COMBINE_NUMBER');
3432: if (l_procedureEnabled) then
3433: ecx_debug.pop(i_method_name);
3434: end if;
3435: raise ecx_utils.PROGRAM_EXIT;

Line 3453: i_method_name varchar2(2000) := 'ecx_actions.get_converted_date';

3449: i_timezone IN varchar2
3450: ) return date
3451: is
3452:
3453: i_method_name varchar2(2000) := 'ecx_actions.get_converted_date';
3454: v_datetime varchar2(500);
3455: x_date Date := null;
3456: i_server_offset number;
3457: i_offset_diff number;

Line 3487: if (ecx_actions.g_server_timezone is null) then

3483:
3484: if (v_datetime is not null) then
3485: x_date := to_date(v_datetime,'YYYYMMDD HH24MISS');
3486:
3487: if (ecx_actions.g_server_timezone is null) then
3488: --- Check for the Installation Type ( Standalone or Embedded );
3489: if (ecx_utils.g_install_mode is null) then
3490: ecx_utils.g_install_mode := wf_core.translate('WF_INSTALL');
3491: end if;

Line 3496: fnd_profile.get('||'''ECX_SERVER_TIMEZONE'''||',ecx_actions.g_server_timezone);

3492:
3493: if ecx_utils.g_install_mode = 'EMBEDDED'
3494: then
3495: i_string := 'begin
3496: fnd_profile.get('||'''ECX_SERVER_TIMEZONE'''||',ecx_actions.g_server_timezone);
3497: end;';
3498: execute immediate i_string ;
3499: else
3500: ecx_actions.g_server_timezone:= wf_core.translate('ECX_SERVER_TIMEZONE');

Line 3500: ecx_actions.g_server_timezone:= wf_core.translate('ECX_SERVER_TIMEZONE');

3496: fnd_profile.get('||'''ECX_SERVER_TIMEZONE'''||',ecx_actions.g_server_timezone);
3497: end;';
3498: execute immediate i_string ;
3499: else
3500: ecx_actions.g_server_timezone:= wf_core.translate('ECX_SERVER_TIMEZONE');
3501: end if;
3502: end if;
3503:
3504: -- if profile option is not set assume gmt

Line 3505: if (ecx_actions.g_server_timezone is null) then

3501: end if;
3502: end if;
3503:
3504: -- if profile option is not set assume gmt
3505: if (ecx_actions.g_server_timezone is null) then
3506: ecx_actions.g_server_timezone := 'GMT';
3507: end if;
3508:
3509: -- get the DB server offset from the Java API

Line 3506: ecx_actions.g_server_timezone := 'GMT';

3502: end if;
3503:
3504: -- if profile option is not set assume gmt
3505: if (ecx_actions.g_server_timezone is null) then
3506: ecx_actions.g_server_timezone := 'GMT';
3507: end if;
3508:
3509: -- get the DB server offset from the Java API
3510: i_server_offset := getTimeZoneOffset(to_number(i_year), to_number(i_month), to_number(i_day),

Line 3512: ecx_actions.g_server_timezone);

3508:
3509: -- get the DB server offset from the Java API
3510: i_server_offset := getTimeZoneOffset(to_number(i_year), to_number(i_month), to_number(i_day),
3511: to_number(i_hour), to_number(i_minute), to_number(i_second),
3512: ecx_actions.g_server_timezone);
3513:
3514: -- get the time in hours from the input xml
3515: i_timezone_hours := to_number(substr(i_timezone, 1, length(i_timezone) - 2)) +
3516: (to_number(substr(i_timezone, length(i_timezone) - 1)) / 60);

Line 3522: ecx_debug.log(l_statement, 'g_server_timezone', ecx_actions.g_server_timezone,i_method_name);

3518: -- get the offset difference
3519: i_offset_diff := i_server_offset - i_timezone_hours;
3520:
3521: if(l_statementEnabled) then
3522: ecx_debug.log(l_statement, 'g_server_timezone', ecx_actions.g_server_timezone,i_method_name);
3523: ecx_debug.log(l_statement, 'i_server_offset', i_server_offset,i_method_name);
3524: ecx_debug.log(l_statement, 'i_timezone_hours', i_timezone_hours,i_method_name);
3525: ecx_debug.log(l_statement, 'i_offset_diff', i_offset_diff,i_method_name);
3526: end if;

Line 3542: 'PROGRESS_LEVEL', 'ECX_ACTIONS.GET_CONVERTED_DATE');

3538: ecx_debug.setErrorInfo(1,20,'ECX_INCOMPLETE_OAG_DATE',
3539: 'p_datetime',v_datetime);
3540: if(l_unexpectedEnabled) then
3541: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,
3542: 'PROGRESS_LEVEL', 'ECX_ACTIONS.GET_CONVERTED_DATE');
3543: ecx_debug.log(l_unexpected,'ECX','ECX_INCOMPLETE_OAG_DATE',i_method_name,'p_datetime',
3544: v_datetime);
3545: end if;
3546: if (l_procedureEnabled) then

Line 3559: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL','ECX_ACTIONS.GET_CONVERTED_DATE');

3555: raise;
3556:
3557: WHEN OTHERS THEN
3558: if(l_unexpectedEnabled) then
3559: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL','ECX_ACTIONS.GET_CONVERTED_DATE');
3560: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
3561: end if;
3562: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.GET_CONVERTED_DATE');
3563: if (l_procedureEnabled) then

Line 3562: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.GET_CONVERTED_DATE');

3558: if(l_unexpectedEnabled) then
3559: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL','ECX_ACTIONS.GET_CONVERTED_DATE');
3560: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
3561: end if;
3562: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.GET_CONVERTED_DATE');
3563: if (l_procedureEnabled) then
3564: ecx_debug.pop(i_method_name);
3565: end if;
3566: raise ecx_utils.PROGRAM_EXIT;

Line 3582: i_method_name varchar2(2000) := 'ecx_actions.convert_from_oag_date';

3578: i_opr1_direction IN Varchar2,
3579: i_opr1_constant IN varchar2
3580: ) is
3581:
3582: i_method_name varchar2(2000) := 'ecx_actions.convert_from_oag_date';
3583:
3584: i_year varchar2(4);
3585: i_month varchar2(2);
3586: i_day varchar2(2);

Line 3698: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL','ECX_ACTIONS.CONVERT_FROM_OAG_DATE');

3694: raise;
3695:
3696: WHEN OTHERS THEN
3697: if(l_unexpectedEnabled) then
3698: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL','ECX_ACTIONS.CONVERT_FROM_OAG_DATE');
3699: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
3700: end if;
3701: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.CONVERT_FROM_OAG_DATE');
3702: if (l_procedureEnabled) then

Line 3701: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.CONVERT_FROM_OAG_DATE');

3697: if(l_unexpectedEnabled) then
3698: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL','ECX_ACTIONS.CONVERT_FROM_OAG_DATE');
3699: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
3700: end if;
3701: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.CONVERT_FROM_OAG_DATE');
3702: if (l_procedureEnabled) then
3703: ecx_debug.pop(i_method_name);
3704: end if;
3705: raise ecx_utils.PROGRAM_EXIT;

Line 3731: i_method_name varchar2(2000) := 'ecx_actions.convert_from_oag_operamt';

3727: i_opr3_direction IN Varchar2,
3728: i_opr3_constant IN varchar2
3729: ) IS
3730:
3731: i_method_name varchar2(2000) := 'ecx_actions.convert_from_oag_operamt';
3732:
3733: i_number number;
3734: i_value varchar2(250);
3735: i_numofdec varchar2(100);

Line 3853: 'PROGRESS_LEVEL','ECX_ACTIONS.CONVERT_FROM_OAG_OPERAMT');

3849:
3850: WHEN OTHERS THEN
3851: if(l_unexpectedEnabled) then
3852: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,
3853: 'PROGRESS_LEVEL','ECX_ACTIONS.CONVERT_FROM_OAG_OPERAMT');
3854: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
3855: end if;
3856: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.CONVERT_FROM_OAG_OPERAMT');
3857: if (l_procedureEnabled) then

Line 3856: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.CONVERT_FROM_OAG_OPERAMT');

3852: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,
3853: 'PROGRESS_LEVEL','ECX_ACTIONS.CONVERT_FROM_OAG_OPERAMT');
3854: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
3855: end if;
3856: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.CONVERT_FROM_OAG_OPERAMT');
3857: if (l_procedureEnabled) then
3858: ecx_debug.pop(i_method_name);
3859: end if;
3860: raise ecx_utils.PROGRAM_EXIT;

Line 3885: i_method_name varchar2(2000) := 'ecx_actions.convert_from_oag_amt';

3881: i_opr3_direction IN Varchar2,
3882: i_opr3_constant IN varchar2
3883: ) IS
3884:
3885: i_method_name varchar2(2000) := 'ecx_actions.convert_from_oag_amt';
3886: i_number number;
3887: i_value varchar2(250);
3888: i_numofdec varchar2(100);
3889: i_sign varchar2(1);

Line 4029: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL','ECX_ACTIONS.CONVERT_FROM_OAG_AMT');

4025: raise;
4026:
4027: WHEN OTHERS THEN
4028: if(l_unexpectedEnabled) then
4029: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL','ECX_ACTIONS.CONVERT_FROM_OAG_AMT');
4030: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
4031: end if;
4032: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.CONVERT_FROM_OAG_AMT');
4033: if (l_procedureEnabled) then

Line 4032: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.CONVERT_FROM_OAG_AMT');

4028: if(l_unexpectedEnabled) then
4029: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL','ECX_ACTIONS.CONVERT_FROM_OAG_AMT');
4030: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
4031: end if;
4032: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.CONVERT_FROM_OAG_AMT');
4033: if (l_procedureEnabled) then
4034: ecx_debug.pop(i_method_name);
4035: end if;
4036: raise ecx_utils.PROGRAM_EXIT;

Line 4058: i_method_name varchar2(2000) := 'ecx_actions.derive_address_id';

4054: i_opr3_direction IN Varchar2
4055: )
4056: is
4057:
4058: i_method_name varchar2(2000) := 'ecx_actions.derive_address_id';
4059: i_variable_value varchar2(2000);
4060: i_value varchar2(2000);
4061: i_value3 varchar2(2000);
4062: i_info_type varchar2(2000);

Line 4167: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL','ECX_ACTIONS.DERIVE_ADDRESS_ID');

4163: raise;
4164:
4165: WHEN OTHERS THEN
4166: if(l_unexpectedEnabled) then
4167: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL','ECX_ACTIONS.DERIVE_ADDRESS_ID');
4168: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
4169: end if;
4170: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.DERIVE_ADDRESS_ID');
4171: if (l_procedureEnabled) then

Line 4170: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.DERIVE_ADDRESS_ID');

4166: if(l_unexpectedEnabled) then
4167: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL','ECX_ACTIONS.DERIVE_ADDRESS_ID');
4168: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
4169: end if;
4170: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.DERIVE_ADDRESS_ID');
4171: if (l_procedureEnabled) then
4172: ecx_debug.pop(i_method_name);
4173: end if;
4174: raise ecx_utils.PROGRAM_EXIT;

Line 4195: i_method_name varchar2(2000) := 'ecx_actions.convert_from_oag_quantity';

4191: i_opr2_constant IN varchar2
4192: )IS
4193:
4194:
4195: i_method_name varchar2(2000) := 'ecx_actions.convert_from_oag_quantity';
4196:
4197: var_value varchar2(2000);
4198: stack_var boolean := FALSE;
4199: stack_pos pls_integer := null;

Line 4284: 'PROGRESS_LEVEL','ECX_ACTIONS.CONVERT_FROM_OAG_QUANTITY');

4280:
4281: WHEN OTHERS THEN
4282: if(l_unexpectedEnabled) then
4283: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,
4284: 'PROGRESS_LEVEL','ECX_ACTIONS.CONVERT_FROM_OAG_QUANTITY');
4285: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
4286: end if;
4287: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.CONVERT_FROM_AG_QUANTITY');
4288: if (l_procedureEnabled) then

Line 4287: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.CONVERT_FROM_AG_QUANTITY');

4283: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,
4284: 'PROGRESS_LEVEL','ECX_ACTIONS.CONVERT_FROM_OAG_QUANTITY');
4285: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
4286: end if;
4287: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.CONVERT_FROM_AG_QUANTITY');
4288: if (l_procedureEnabled) then
4289: ecx_debug.pop(i_method_name);
4290: end if;
4291: raise ecx_utils.PROGRAM_EXIT;

Line 4314: i_method_name varchar2(2000) := 'ecx_actions.execute_math_functions';

4310: z_def in varchar2
4311: )
4312: is
4313:
4314: i_method_name varchar2(2000) := 'ecx_actions.execute_math_functions';
4315:
4316: x varchar2(2000);
4317: y varchar2(2000);
4318: z varchar2(2000);

Line 4454: 'PROGRESS_LEVEL','ECX_ACTIONS.EXECUTE_MATH_FUNCTIONS');

4450: raise;
4451: WHEN OTHERS THEN
4452: if(l_unexpectedEnabled) then
4453: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,
4454: 'PROGRESS_LEVEL','ECX_ACTIONS.EXECUTE_MATH_FUNCTIONS');
4455: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,
4456: 'ERROR_MESSAGE',SQLERRM);
4457: end if;
4458: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.EXECUTE_MATH_FUNCTIONS');

Line 4458: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.EXECUTE_MATH_FUNCTIONS');

4454: 'PROGRESS_LEVEL','ECX_ACTIONS.EXECUTE_MATH_FUNCTIONS');
4455: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,
4456: 'ERROR_MESSAGE',SQLERRM);
4457: end if;
4458: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.EXECUTE_MATH_FUNCTIONS');
4459: if (l_procedureEnabled) then
4460: ecx_debug.pop(i_method_name);
4461: end if;
4462: raise ecx_utils.PROGRAM_EXIT;

Line 4518: i_method_name varchar2(2000) := 'ecx_actions.transform_xml_with_xslt';

4514: i_version in number,
4515: i_application_code in varchar2
4516: )
4517: is
4518: i_method_name varchar2(2000) := 'ecx_actions.transform_xml_with_xslt';
4519:
4520: i_stylesheet xslprocessor.Stylesheet;
4521: i_processor xslprocessor.Processor;
4522: i_xmlDocFrag xmlDOM.DOMDocumentFragment;

Line 4588: if (ecx_actions.g_xslt_dir is null) then

4584: ecx_debug.log(l_statement,'XSLT file not loaded in the DB. Checking the file system...',
4585: i_method_name);
4586: end if;
4587:
4588: if (ecx_actions.g_xslt_dir is null) then
4589: --- Check for the Installation Type ( Standalone or Embedded );
4590: if (ecx_utils.g_install_mode is null) then
4591: ecx_utils.g_install_mode := wf_core.translate('WF_INSTALL');
4592: end if;

Line 4597: fnd_profile.get('||'''ECX_UTL_XSLT_DIR'''||',ecx_actions.g_xslt_dir);

4593:
4594: if ecx_utils.g_install_mode = 'EMBEDDED'
4595: then
4596: i_string := 'begin
4597: fnd_profile.get('||'''ECX_UTL_XSLT_DIR'''||',ecx_actions.g_xslt_dir);
4598: end;';
4599: execute immediate i_string ;
4600: else
4601: ecx_actions.g_xslt_dir:= wf_core.translate('ECX_UTL_XSLT_DIR');

Line 4601: ecx_actions.g_xslt_dir:= wf_core.translate('ECX_UTL_XSLT_DIR');

4597: fnd_profile.get('||'''ECX_UTL_XSLT_DIR'''||',ecx_actions.g_xslt_dir);
4598: end;';
4599: execute immediate i_string ;
4600: else
4601: ecx_actions.g_xslt_dir:= wf_core.translate('ECX_UTL_XSLT_DIR');
4602: end if;
4603: end if;
4604:
4605: i_fullpath := ecx_actions.g_xslt_dir||ecx_utils.getFileSeparator()||i_filename;

Line 4605: i_fullpath := ecx_actions.g_xslt_dir||ecx_utils.getFileSeparator()||i_filename;

4601: ecx_actions.g_xslt_dir:= wf_core.translate('ECX_UTL_XSLT_DIR');
4602: end if;
4603: end if;
4604:
4605: i_fullpath := ecx_actions.g_xslt_dir||ecx_utils.getFileSeparator()||i_filename;
4606: if(l_statementEnabled) then
4607: ecx_debug.log(l_statement, 'XSLT Fullpath', i_fullpath,i_method_name);
4608: end if;
4609: l_parser := xmlparser.newParser;

Line 4880: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL','ECX_ACTIONS.TRANSFORM_XML_WITH_XSLT');

4876: raise ecx_utils.program_exit;
4877:
4878: WHEN OTHERS THEN
4879: if(l_unexpectedEnabled) then
4880: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL','ECX_ACTIONS.TRANSFORM_XML_WITH_XSLT');
4881: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
4882: end if;
4883: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.TRANSFORM_XML_WITH_XSLT');
4884: -- free all the used variables

Line 4883: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.TRANSFORM_XML_WITH_XSLT');

4879: if(l_unexpectedEnabled) then
4880: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL','ECX_ACTIONS.TRANSFORM_XML_WITH_XSLT');
4881: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
4882: end if;
4883: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.TRANSFORM_XML_WITH_XSLT');
4884: -- free all the used variables
4885: if (l_parser.id <> -1)
4886: then
4887: xmlParser.freeParser(l_parser);

Line 4907: i_method_name varchar2(2000) := 'ecx_actions.execute_stage_data';

4903: i_stage IN pls_integer,
4904: i_level IN pls_integer,
4905: i_direction IN varchar2 ) IS
4906:
4907: i_method_name varchar2(2000) := 'ecx_actions.execute_stage_data';
4908:
4909: /* Cursor to get all the Level 0 Stack Data */
4910: cursor stack_data is
4911: select variable_name,

Line 4953: ecx_actions.g_server_timezone := null;

4949: if i_stage = 10 then
4950:
4951: if (i_level = 0) then
4952:
4953: ecx_actions.g_server_timezone := null;
4954: ecx_actions.g_xslt_dir := null;
4955:
4956: ecx_utils.g_stack.DELETE;
4957:

Line 4954: ecx_actions.g_xslt_dir := null;

4950:
4951: if (i_level = 0) then
4952:
4953: ecx_actions.g_server_timezone := null;
4954: ecx_actions.g_xslt_dir := null;
4955:
4956: ecx_utils.g_stack.DELETE;
4957:
4958: for get_stack_data in stack_data loop

Line 5614: 'PROGRESS_LEVEL','ECX_ACTIONS.EXECUTE_STAGE_DATA');

5610:
5611: WHEN OTHERS THEN
5612: if(l_unexpectedEnabled) then
5613: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,
5614: 'PROGRESS_LEVEL','ECX_ACTIONS.EXECUTE_STAGE_DATA');
5615: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
5616: end if;
5617: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.EXECUTE_STAGE_DATA');
5618: if (l_procedureEnabled) then

Line 5617: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.EXECUTE_STAGE_DATA');

5613: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,
5614: 'PROGRESS_LEVEL','ECX_ACTIONS.EXECUTE_STAGE_DATA');
5615: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
5616: end if;
5617: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.EXECUTE_STAGE_DATA');
5618: if (l_procedureEnabled) then
5619: ecx_debug.pop(i_method_name);
5620: end if;
5621: raise ecx_utils.PROGRAM_EXIT;

Line 5638: i_method_name varchar2(2000) := 'ecx_actions.get_clob';

5634: java.lang.String) returns float';
5635:
5636:
5637: Procedure get_clob(clobValue in clob , value in Varchar2 , clobOut out nocopy clob) as
5638: i_method_name varchar2(2000) := 'ecx_actions.get_clob';
5639: begin
5640:
5641: if (l_procedureEnabled) then
5642: ecx_debug.push(i_method_name);

Line 5667: 'ECX_ACTIONS.GET_CLOB');

5663: WHEN OTHERS THEN
5664: if(l_unexpectedEnabled) then
5665: ecx_debug.log(l_unexpected,'ECX', 'ECX_PROGRAM_ERROR',i_method_name,
5666: 'PROGRESS_LEVEL',
5667: 'ECX_ACTIONS.GET_CLOB');
5668: end if;
5669: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.GET_CLOB');
5670: if (l_procedureEnabled) then
5671: ecx_debug.pop(i_method_name);

Line 5669: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.GET_CLOB');

5665: ecx_debug.log(l_unexpected,'ECX', 'ECX_PROGRAM_ERROR',i_method_name,
5666: 'PROGRESS_LEVEL',
5667: 'ECX_ACTIONS.GET_CLOB');
5668: end if;
5669: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.GET_CLOB');
5670: if (l_procedureEnabled) then
5671: ecx_debug.pop(i_method_name);
5672: end if;
5673: raise ecx_utils.PROGRAM_EXIT;

Line 5677: i_method_name varchar2(2000) := 'ecx_actions.get_varchar';

5673: raise ecx_utils.PROGRAM_EXIT;
5674: end;
5675:
5676: procedure get_varchar(clobValue in clob , value in Varchar2 , valueOut out nocopy varchar2) as
5677: i_method_name varchar2(2000) := 'ecx_actions.get_varchar';
5678: begin
5679: if (l_procedureEnabled) then
5680: ecx_debug.push(i_method_name);
5681: end if;

Line 5698: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL','ECX_ACTIONS.GET_VARCHAR');

5694: end if;
5695: raise;
5696: WHEN OTHERS THEN
5697: if(l_unexpectedEnabled) then
5698: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL','ECX_ACTIONS.GET_VARCHAR');
5699: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
5700: end if;
5701: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.GET_VARCHAR');
5702: if (l_procedureEnabled) then

Line 5701: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.GET_VARCHAR');

5697: if(l_unexpectedEnabled) then
5698: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL','ECX_ACTIONS.GET_VARCHAR');
5699: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
5700: end if;
5701: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.GET_VARCHAR');
5702: if (l_procedureEnabled) then
5703: ecx_debug.pop(i_method_name);
5704: end if;
5705: raise ecx_utils.PROGRAM_EXIT;

Line 5718: i_method_name varchar2(2000) := 'ecx_actions.get_xml_fragment';

5714: PROCEDURE get_xml_fragment
5715: ( proc_name IN varchar2,
5716: xml_fragment OUT NOCOPY varchar2
5717: ) as
5718: i_method_name varchar2(2000) := 'ecx_actions.get_xml_fragment';
5719: proc_call varchar2(32767);
5720: temp_xml varchar2(32767);
5721: temp_parser xmlparser.parser;
5722: v_name varchar2(32767);

Line 5781: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL','ECX_ACTIONS.GET_XML_FRAGMENT');

5777: if (temp_parser.id not in (-1)) then
5778: xmlparser.freeparser(temp_parser);
5779: end if;
5780: if(l_unexpectedEnabled) then
5781: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL','ECX_ACTIONS.GET_XML_FRAGMENT');
5782: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
5783: end if;
5784: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.GET_XML_FRAGMENT');
5785: if (l_procedureEnabled) then

Line 5784: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.GET_XML_FRAGMENT');

5780: if(l_unexpectedEnabled) then
5781: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL','ECX_ACTIONS.GET_XML_FRAGMENT');
5782: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
5783: end if;
5784: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_ACTIONS.GET_XML_FRAGMENT');
5785: if (l_procedureEnabled) then
5786: ecx_debug.pop(i_method_name);
5787: end if;
5788: raise ecx_utils.PROGRAM_EXIT;

Line 5791: end ecx_actions;

5787: end if;
5788: raise ecx_utils.PROGRAM_EXIT;
5789: end;
5790:
5791: end ecx_actions;