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.PAY_AU_GENERIC_CODE_CALLER dependencies on HR_UTILITY

Line 110: hr_utility.trace('In: ' || l_procedure_name) ;

106: pm.process_sequence ;
107:
108: begin
109:
110: hr_utility.trace('In: ' || l_procedure_name) ;
111: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
112: hr_utility.trace(' p_effective_date: ' || fnd_date.date_to_canonical(p_effective_date)) ;
113: hr_utility.trace(' p_process_id: ' || to_char(p_process_id)) ;
114: hr_utility.trace(' p_assignment_action_id: ' || to_char(p_assignment_action_id)) ;

Line 111: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;

107:
108: begin
109:
110: hr_utility.trace('In: ' || l_procedure_name) ;
111: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
112: hr_utility.trace(' p_effective_date: ' || fnd_date.date_to_canonical(p_effective_date)) ;
113: hr_utility.trace(' p_process_id: ' || to_char(p_process_id)) ;
114: hr_utility.trace(' p_assignment_action_id: ' || to_char(p_assignment_action_id)) ;
115:

Line 112: hr_utility.trace(' p_effective_date: ' || fnd_date.date_to_canonical(p_effective_date)) ;

108: begin
109:
110: hr_utility.trace('In: ' || l_procedure_name) ;
111: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
112: hr_utility.trace(' p_effective_date: ' || fnd_date.date_to_canonical(p_effective_date)) ;
113: hr_utility.trace(' p_process_id: ' || to_char(p_process_id)) ;
114: hr_utility.trace(' p_assignment_action_id: ' || to_char(p_assignment_action_id)) ;
115:
116: -- check that there's a record in fnd_sessions (the Oracle

Line 113: hr_utility.trace(' p_process_id: ' || to_char(p_process_id)) ;

109:
110: hr_utility.trace('In: ' || l_procedure_name) ;
111: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
112: hr_utility.trace(' p_effective_date: ' || fnd_date.date_to_canonical(p_effective_date)) ;
113: hr_utility.trace(' p_process_id: ' || to_char(p_process_id)) ;
114: hr_utility.trace(' p_assignment_action_id: ' || to_char(p_assignment_action_id)) ;
115:
116: -- check that there's a record in fnd_sessions (the Oracle
117: -- FastFormula harness crashes if no fnd_sessions record present).

Line 114: hr_utility.trace(' p_assignment_action_id: ' || to_char(p_assignment_action_id)) ;

110: hr_utility.trace('In: ' || l_procedure_name) ;
111: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
112: hr_utility.trace(' p_effective_date: ' || fnd_date.date_to_canonical(p_effective_date)) ;
113: hr_utility.trace(' p_process_id: ' || to_char(p_process_id)) ;
114: hr_utility.trace(' p_assignment_action_id: ' || to_char(p_assignment_action_id)) ;
115:
116: -- check that there's a record in fnd_sessions (the Oracle
117: -- FastFormula harness crashes if no fnd_sessions record present).
118:

Line 229: hr_utility.trace(' exec procedure: ' || r_module.package_name

225:
226: if r_module.module_type = 'PROCEDURE'
227: then
228:
229: hr_utility.trace(' exec procedure: ' || r_module.package_name
230: || '.' || r_module.procedure_function_name) ;
231:
232: execute_procedure(r_module.module_id
233: ,r_module.package_name

Line 239: hr_utility.trace(' exec function: ' || r_module.package_name

235:
236: elsif r_module.module_type = 'FUNCTION'
237: then
238:
239: hr_utility.trace(' exec function: ' || r_module.package_name
240: || '.' || r_module.procedure_function_name) ;
241:
242: execute_function(r_module.module_id
243: ,r_module.package_name

Line 249: hr_utility.trace(' exec formula: ' || r_module.formula_name) ;

245:
246: elsif r_module.module_type = 'FORMULA'
247: then
248:
249: hr_utility.trace(' exec formula: ' || r_module.formula_name) ;
250:
251: execute_formula(r_module.module_id
252: ,r_module.formula_name) ;
253:

Line 262: hr_utility.trace('Out: ' || l_procedure_name) ;

258: end if ;
259:
260: end loop ; -- c_modules
261:
262: hr_utility.trace('Out: ' || l_procedure_name) ;
263:
264: exception
265: when e_bad_process
266: then

Line 267: hr_utility.set_message(801, 'HR_AU_INVALID_PROCESS') ;

263:
264: exception
265: when e_bad_process
266: then
267: hr_utility.set_message(801, 'HR_AU_INVALID_PROCESS') ;
268: hr_utility.raise_error ;
269:
270: when e_missing_session_record
271: then

Line 268: hr_utility.raise_error ;

264: exception
265: when e_bad_process
266: then
267: hr_utility.set_message(801, 'HR_AU_INVALID_PROCESS') ;
268: hr_utility.raise_error ;
269:
270: when e_missing_session_record
271: then
272: hr_utility.set_message(801, 'HR_AU_MISSING_SESSION_DATE') ;

Line 272: hr_utility.set_message(801, 'HR_AU_MISSING_SESSION_DATE') ;

268: hr_utility.raise_error ;
269:
270: when e_missing_session_record
271: then
272: hr_utility.set_message(801, 'HR_AU_MISSING_SESSION_DATE') ;
273: hr_utility.raise_error ;
274:
275: when e_missing_legislation_code
276: then

Line 273: hr_utility.raise_error ;

269:
270: when e_missing_session_record
271: then
272: hr_utility.set_message(801, 'HR_AU_MISSING_SESSION_DATE') ;
273: hr_utility.raise_error ;
274:
275: when e_missing_legislation_code
276: then
277: hr_utility.set_message(801, 'HR_AU_MISSING_LEGISLATION_CODE') ;

Line 277: hr_utility.set_message(801, 'HR_AU_MISSING_LEGISLATION_CODE') ;

273: hr_utility.raise_error ;
274:
275: when e_missing_legislation_code
276: then
277: hr_utility.set_message(801, 'HR_AU_MISSING_LEGISLATION_CODE') ;
278: hr_utility.raise_error ;
279:
280: when e_missing_process_parameter
281: then

Line 278: hr_utility.raise_error ;

274:
275: when e_missing_legislation_code
276: then
277: hr_utility.set_message(801, 'HR_AU_MISSING_LEGISLATION_CODE') ;
278: hr_utility.raise_error ;
279:
280: when e_missing_process_parameter
281: then
282: hr_utility.set_message(801, 'HR_AU_MISSING_PROC_PARAMETER') ;

Line 282: hr_utility.set_message(801, 'HR_AU_MISSING_PROC_PARAMETER') ;

278: hr_utility.raise_error ;
279:
280: when e_missing_process_parameter
281: then
282: hr_utility.set_message(801, 'HR_AU_MISSING_PROC_PARAMETER') ;
283: hr_utility.raise_error ;
284:
285: when e_bad_module_type
286: then

Line 283: hr_utility.raise_error ;

279:
280: when e_missing_process_parameter
281: then
282: hr_utility.set_message(801, 'HR_AU_MISSING_PROC_PARAMETER') ;
283: hr_utility.raise_error ;
284:
285: when e_bad_module_type
286: then
287: hr_utility.set_message(801, 'HR_AU_INVALID_MODULE_TYPE') ;

Line 287: hr_utility.set_message(801, 'HR_AU_INVALID_MODULE_TYPE') ;

283: hr_utility.raise_error ;
284:
285: when e_bad_module_type
286: then
287: hr_utility.set_message(801, 'HR_AU_INVALID_MODULE_TYPE') ;
288: hr_utility.raise_error ;
289:
290: end execute_process ;
291:

Line 288: hr_utility.raise_error ;

284:
285: when e_bad_module_type
286: then
287: hr_utility.set_message(801, 'HR_AU_INVALID_MODULE_TYPE') ;
288: hr_utility.raise_error ;
289:
290: end execute_process ;
291:
292: -----------------------------------------------------------------------------

Line 312: hr_utility.trace('In: ' || l_procedure_name) ;

308: e_data_type_mismatch exception ;
309:
310: begin
311:
312: hr_utility.trace('In: ' || l_procedure_name) ;
313:
314: -- loop through the records in the PL/SQL table. Only start
315: -- the loop if there are some records and stop when the variable
316: -- has been found or we've reached the last record.

Line 343: hr_utility.trace(' ' || p_name || ' -> ' || nvl(p_value,'null')) ;

339: end if ;
340:
341: -- store the variable and set the variable not found flag
342:
343: hr_utility.trace(' ' || p_name || ' -> ' || nvl(p_value,'null')) ;
344: v_variable_store(l_counter).name := p_name ;
345: v_variable_store(l_counter).data_type := p_data_type ;
346: v_variable_store(l_counter).value := p_value ;
347: l_variable_notfound_flag := false ;

Line 361: hr_utility.trace(' ' || p_name || ' -> ' || nvl(p_value,'null')) ;

357:
358: if l_variable_notfound_flag
359: then
360:
361: hr_utility.trace(' ' || p_name || ' -> ' || nvl(p_value,'null')) ;
362: v_variable_store(l_counter).name := p_name ;
363: v_variable_store(l_counter).data_type := p_data_type ;
364: v_variable_store(l_counter).value := p_value ;
365:

Line 368: hr_utility.trace('Out: ' || l_procedure_name) ;

364: v_variable_store(l_counter).value := p_value ;
365:
366: end if ;
367:
368: hr_utility.trace('Out: ' || l_procedure_name) ;
369:
370: exception
371: when e_data_type_mismatch
372: then

Line 373: hr_utility.set_message(801, 'HR_AU_DATA_TYPE_MISMATCH') ;

369:
370: exception
371: when e_data_type_mismatch
372: then
373: hr_utility.set_message(801, 'HR_AU_DATA_TYPE_MISMATCH') ;
374: hr_utility.set_message_token('PROCEDURE', l_procedure_name) ;
375: hr_utility.raise_error ;
376:
377: end store_variable ;

Line 374: hr_utility.set_message_token('PROCEDURE', l_procedure_name) ;

370: exception
371: when e_data_type_mismatch
372: then
373: hr_utility.set_message(801, 'HR_AU_DATA_TYPE_MISMATCH') ;
374: hr_utility.set_message_token('PROCEDURE', l_procedure_name) ;
375: hr_utility.raise_error ;
376:
377: end store_variable ;
378:

Line 375: hr_utility.raise_error ;

371: when e_data_type_mismatch
372: then
373: hr_utility.set_message(801, 'HR_AU_DATA_TYPE_MISMATCH') ;
374: hr_utility.set_message_token('PROCEDURE', l_procedure_name) ;
375: hr_utility.raise_error ;
376:
377: end store_variable ;
378:
379: -----------------------------------------------------------------------------

Line 400: hr_utility.trace('In: ' || l_procedure_name) ;

396: e_data_type_mismatch exception ;
397:
398: begin
399:
400: hr_utility.trace('In: ' || l_procedure_name) ;
401:
402: -- loop through the records in the PL/SQL table. Only start
403: -- the loop if there are some records and stop when the variable
404: -- has been found or we've reached the last record.

Line 439: hr_utility.trace(' ' || p_name || ' -> ' || nvl(l_variable_value,'null')) ;

435: end loop ;
436:
437: -- set the output parameter
438:
439: hr_utility.trace(' ' || p_name || ' -> ' || nvl(l_variable_value,'null')) ;
440: p_value := l_variable_value ;
441:
442: hr_utility.trace('Out: ' || l_procedure_name) ;
443:

Line 442: hr_utility.trace('Out: ' || l_procedure_name) ;

438:
439: hr_utility.trace(' ' || p_name || ' -> ' || nvl(l_variable_value,'null')) ;
440: p_value := l_variable_value ;
441:
442: hr_utility.trace('Out: ' || l_procedure_name) ;
443:
444: exception
445: when e_data_type_mismatch
446: then

Line 447: hr_utility.set_message(801, 'HR_AU_DATA_TYPE_MISMATCH') ;

443:
444: exception
445: when e_data_type_mismatch
446: then
447: hr_utility.set_message(801, 'HR_AU_DATA_TYPE_MISMATCH') ;
448: hr_utility.set_message_token('PROCEDURE', l_procedure_name) ;
449: hr_utility.raise_error ;
450:
451: end retrieve_variable ;

Line 448: hr_utility.set_message_token('PROCEDURE', l_procedure_name) ;

444: exception
445: when e_data_type_mismatch
446: then
447: hr_utility.set_message(801, 'HR_AU_DATA_TYPE_MISMATCH') ;
448: hr_utility.set_message_token('PROCEDURE', l_procedure_name) ;
449: hr_utility.raise_error ;
450:
451: end retrieve_variable ;
452:

Line 449: hr_utility.raise_error ;

445: when e_data_type_mismatch
446: then
447: hr_utility.set_message(801, 'HR_AU_DATA_TYPE_MISMATCH') ;
448: hr_utility.set_message_token('PROCEDURE', l_procedure_name) ;
449: hr_utility.raise_error ;
450:
451: end retrieve_variable ;
452:
453: -----------------------------------------------------------------------------

Line 469: hr_utility.trace('In: ' || l_procedure_name) ;

465: l_procedure_name varchar2(61) := 'pay_au_generic_code_caller.execute_procedure' ;
466:
467: begin
468:
469: hr_utility.trace('In: ' || l_procedure_name) ;
470:
471: execute_procedure_function
472: (p_module_id
473: ,p_package_name

Line 477: hr_utility.trace('Out: ' || l_procedure_name) ;

473: ,p_package_name
474: ,p_procedure_name
475: ,'PROCEDURE') ;
476:
477: hr_utility.trace('Out: ' || l_procedure_name) ;
478:
479: end execute_procedure ;
480:
481: -----------------------------------------------------------------------------

Line 497: hr_utility.trace('In: ' || l_procedure_name) ;

493: l_procedure_name varchar2(61) := 'pay_au_generic_code_caller.execute_procedure_function' ;
494:
495: begin
496:
497: hr_utility.trace('In: ' || l_procedure_name) ;
498:
499: execute_procedure_function
500: (p_module_id
501: ,p_package_name

Line 505: hr_utility.trace('Out: ' || l_procedure_name) ;

501: ,p_package_name
502: ,p_function_name
503: ,'FUNCTION') ;
504:
505: hr_utility.trace('Out: ' || l_procedure_name) ;
506:
507: end execute_function ;
508:
509: -----------------------------------------------------------------------------

Line 548: hr_utility.trace('In: ' || l_procedure_name) ;

544: e_module_error exception ;
545:
546: begin
547:
548: hr_utility.trace('In: ' || l_procedure_name) ;
549:
550: if not (p_mode = 'FUNCTION' or p_mode = 'PROCEDURE')
551: then
552:

Line 722: hr_utility.trace(' ' || l_sql_stmt) ;

718: else
719: l_sql_stmt := l_sql_stmt || '); end;' ;
720: end if ;
721:
722: hr_utility.trace(' ' || l_sql_stmt) ;
723:
724: -- open a cursor for the the dynamic pl/sql block
725:
726: l_cursor_id := dbms_sql.open_cursor ;

Line 946: hr_utility.trace('Out: ' || l_procedure_name) ;

942: -- is now finished with so release it
943:
944: dbms_sql.close_cursor(l_cursor_id) ;
945:
946: hr_utility.trace('Out: ' || l_procedure_name) ;
947:
948: exception
949: when e_module_error
950: then

Line 951: hr_utility.set_message(801, 'HR_AU_MODULE_ERROR') ;

947:
948: exception
949: when e_module_error
950: then
951: hr_utility.set_message(801, 'HR_AU_MODULE_ERROR') ;
952: hr_utility.set_message_token('MODULE', l_module) ;
953: hr_utility.set_message_token('ERROR', l_error) ;
954: hr_utility.raise_error ;
955:

Line 952: hr_utility.set_message_token('MODULE', l_module) ;

948: exception
949: when e_module_error
950: then
951: hr_utility.set_message(801, 'HR_AU_MODULE_ERROR') ;
952: hr_utility.set_message_token('MODULE', l_module) ;
953: hr_utility.set_message_token('ERROR', l_error) ;
954: hr_utility.raise_error ;
955:
956: when e_bad_data_type

Line 953: hr_utility.set_message_token('ERROR', l_error) ;

949: when e_module_error
950: then
951: hr_utility.set_message(801, 'HR_AU_MODULE_ERROR') ;
952: hr_utility.set_message_token('MODULE', l_module) ;
953: hr_utility.set_message_token('ERROR', l_error) ;
954: hr_utility.raise_error ;
955:
956: when e_bad_data_type
957: then

Line 954: hr_utility.raise_error ;

950: then
951: hr_utility.set_message(801, 'HR_AU_MODULE_ERROR') ;
952: hr_utility.set_message_token('MODULE', l_module) ;
953: hr_utility.set_message_token('ERROR', l_error) ;
954: hr_utility.raise_error ;
955:
956: when e_bad_data_type
957: then
958: hr_utility.set_message(801, 'HR_AU_INVALID_DATA_TYPE') ;

Line 958: hr_utility.set_message(801, 'HR_AU_INVALID_DATA_TYPE') ;

954: hr_utility.raise_error ;
955:
956: when e_bad_data_type
957: then
958: hr_utility.set_message(801, 'HR_AU_INVALID_DATA_TYPE') ;
959: hr_utility.set_message_token('PROCEDURE', l_procedure_name) ;
960: hr_utility.raise_error ;
961:
962: when e_bad_mode

Line 959: hr_utility.set_message_token('PROCEDURE', l_procedure_name) ;

955:
956: when e_bad_data_type
957: then
958: hr_utility.set_message(801, 'HR_AU_INVALID_DATA_TYPE') ;
959: hr_utility.set_message_token('PROCEDURE', l_procedure_name) ;
960: hr_utility.raise_error ;
961:
962: when e_bad_mode
963: then

Line 960: hr_utility.raise_error ;

956: when e_bad_data_type
957: then
958: hr_utility.set_message(801, 'HR_AU_INVALID_DATA_TYPE') ;
959: hr_utility.set_message_token('PROCEDURE', l_procedure_name) ;
960: hr_utility.raise_error ;
961:
962: when e_bad_mode
963: then
964: hr_utility.set_message(801, 'HR_AU_INVALID_MODE') ;

Line 964: hr_utility.set_message(801, 'HR_AU_INVALID_MODE') ;

960: hr_utility.raise_error ;
961:
962: when e_bad_mode
963: then
964: hr_utility.set_message(801, 'HR_AU_INVALID_MODE') ;
965: hr_utility.raise_error ;
966:
967: when e_missing_function_return
968: then

Line 965: hr_utility.raise_error ;

961:
962: when e_bad_mode
963: then
964: hr_utility.set_message(801, 'HR_AU_INVALID_MODE') ;
965: hr_utility.raise_error ;
966:
967: when e_missing_function_return
968: then
969: hr_utility.set_message(801, 'HR_AU_MISSING_FN_RETURN') ;

Line 969: hr_utility.set_message(801, 'HR_AU_MISSING_FN_RETURN') ;

965: hr_utility.raise_error ;
966:
967: when e_missing_function_return
968: then
969: hr_utility.set_message(801, 'HR_AU_MISSING_FN_RETURN') ;
970: hr_utility.raise_error ;
971:
972: when e_multiple_function_return
973: then

Line 970: hr_utility.raise_error ;

966:
967: when e_missing_function_return
968: then
969: hr_utility.set_message(801, 'HR_AU_MISSING_FN_RETURN') ;
970: hr_utility.raise_error ;
971:
972: when e_multiple_function_return
973: then
974: hr_utility.set_message(801, 'HR_AU_MULTIPLE_FN_RETURNS') ;

Line 974: hr_utility.set_message(801, 'HR_AU_MULTIPLE_FN_RETURNS') ;

970: hr_utility.raise_error ;
971:
972: when e_multiple_function_return
973: then
974: hr_utility.set_message(801, 'HR_AU_MULTIPLE_FN_RETURNS') ;
975: hr_utility.raise_error ;
976:
977: end execute_procedure_function ;
978:

Line 975: hr_utility.raise_error ;

971:
972: when e_multiple_function_return
973: then
974: hr_utility.set_message(801, 'HR_AU_MULTIPLE_FN_RETURNS') ;
975: hr_utility.raise_error ;
976:
977: end execute_procedure_function ;
978:
979: -----------------------------------------------------------------------------

Line 1029: hr_utility.trace(' In: ' || l_procedure_name) ;

1025: l_output_value pay_au_module_parameters.constant_value%type := null ;
1026:
1027: begin
1028:
1029: hr_utility.trace(' In: ' || l_procedure_name) ;
1030:
1031: for i in l_ff_outputs.first..l_ff_outputs.last
1032: loop
1033:

Line 1044: hr_utility.trace(' Out: ' || l_procedure_name) ;

1040: end if ;
1041:
1042: end loop ;
1043:
1044: hr_utility.trace(' Out: ' || l_procedure_name) ;
1045:
1046: return l_output_value ;
1047:
1048: end get_ff_output ;

Line 1052: hr_utility.trace('In: ' || l_procedure_name) ;

1048: end get_ff_output ;
1049:
1050: begin
1051:
1052: hr_utility.trace('In: ' || l_procedure_name) ;
1053: hr_utility.trace(' p_module_id: ' || to_char(p_module_id)) ;
1054: hr_utility.trace(' p_formula_name: ' || p_formula_name) ;
1055:
1056: -- Get the business group ID and legislation code variables and then check

Line 1053: hr_utility.trace(' p_module_id: ' || to_char(p_module_id)) ;

1049:
1050: begin
1051:
1052: hr_utility.trace('In: ' || l_procedure_name) ;
1053: hr_utility.trace(' p_module_id: ' || to_char(p_module_id)) ;
1054: hr_utility.trace(' p_formula_name: ' || p_formula_name) ;
1055:
1056: -- Get the business group ID and legislation code variables and then check
1057: -- that the formula is valid within this business group/legislation context.

Line 1054: hr_utility.trace(' p_formula_name: ' || p_formula_name) ;

1050: begin
1051:
1052: hr_utility.trace('In: ' || l_procedure_name) ;
1053: hr_utility.trace(' p_module_id: ' || to_char(p_module_id)) ;
1054: hr_utility.trace(' p_formula_name: ' || p_formula_name) ;
1055:
1056: -- Get the business group ID and legislation code variables and then check
1057: -- that the formula is valid within this business group/legislation context.
1058:

Line 1059: hr_utility.set_location(l_procedure_name, 10) ;

1055:
1056: -- Get the business group ID and legislation code variables and then check
1057: -- that the formula is valid within this business group/legislation context.
1058:
1059: hr_utility.set_location(l_procedure_name, 10) ;
1060: retrieve_variable('BUSINESS_GROUP_ID'
1061: ,'NUMBER'
1062: ,l_business_group_id) ;
1063:

Line 1064: hr_utility.set_location(l_procedure_name, 20) ;

1060: retrieve_variable('BUSINESS_GROUP_ID'
1061: ,'NUMBER'
1062: ,l_business_group_id) ;
1063:
1064: hr_utility.set_location(l_procedure_name, 20) ;
1065: retrieve_variable('LEGISLATION_CODE'
1066: ,'TEXT'
1067: ,l_legislation_code) ;
1068:

Line 1069: hr_utility.set_location(l_procedure_name, 30) ;

1065: retrieve_variable('LEGISLATION_CODE'
1066: ,'TEXT'
1067: ,l_legislation_code) ;
1068:
1069: hr_utility.set_location(l_procedure_name, 30) ;
1070: open c_formula(p_formula_name, l_business_group_id, l_legislation_code) ;
1071: fetch c_formula
1072: into l_formula_id ;
1073: if c_formula%notfound

Line 1086: hr_utility.set_location(l_procedure_name, 40) ;

1082: -- call get_module_parameters to populate a PL/SQL table with the
1083: -- data from the pay_au_module_parameters table for the module
1084: -- beinmg executed. This saves on database table accesses.
1085:
1086: hr_utility.set_location(l_procedure_name, 40) ;
1087: get_module_parameters(p_module_id, l_parameter_store) ;
1088:
1089: -- the Oracle FastFormula execution harness requires inputs
1090: -- to be passed in using a PL/SQL table and outputs to be passed

Line 1094: hr_utility.set_location(l_procedure_name, 50) ;

1090: -- to be passed in using a PL/SQL table and outputs to be passed
1091: -- out using another PL/SQL table. Set up the FastFormula inputs
1092: -- and outputs tables.
1093:
1094: hr_utility.set_location(l_procedure_name, 50) ;
1095: for i in l_parameter_store.first..l_parameter_store.last
1096: loop
1097:
1098: -- look for inputs or contexts

Line 1100: hr_utility.set_location(l_procedure_name, 60) ;

1096: loop
1097:
1098: -- look for inputs or contexts
1099:
1100: hr_utility.set_location(l_procedure_name, 60) ;
1101: if l_parameter_store(i).input_flag = 'Y'
1102: or l_parameter_store(i).context_flag = 'Y'
1103: then
1104:

Line 1108: hr_utility.set_location(l_procedure_name, 70) ;

1104:
1105: -- if there is a constant value defined for the parameter
1106: -- use it, otherwise get the value from the variable store
1107:
1108: hr_utility.set_location(l_procedure_name, 70) ;
1109: if l_parameter_store(i).constant_value is not null
1110: then
1111:
1112: hr_utility.set_location(l_procedure_name, 80) ;

Line 1112: hr_utility.set_location(l_procedure_name, 80) ;

1108: hr_utility.set_location(l_procedure_name, 70) ;
1109: if l_parameter_store(i).constant_value is not null
1110: then
1111:
1112: hr_utility.set_location(l_procedure_name, 80) ;
1113: l_parameter_value := l_parameter_store(i).constant_value ;
1114:
1115: else
1116:

Line 1117: hr_utility.set_location(l_procedure_name, 90) ;

1113: l_parameter_value := l_parameter_store(i).constant_value ;
1114:
1115: else
1116:
1117: hr_utility.set_location(l_procedure_name, 90) ;
1118: retrieve_variable(l_parameter_store(i).internal_name
1119: ,l_parameter_store(i).data_type
1120: ,l_parameter_value) ;
1121:

Line 1126: hr_utility.set_location(l_procedure_name, 100) ;

1122: end if ;
1123:
1124: -- set up the FF inputs table fields
1125:
1126: hr_utility.set_location(l_procedure_name, 100) ;
1127: l_ff_inputs(l_inputs_counter).name := l_parameter_store(i).external_name ;
1128: l_ff_inputs(l_inputs_counter).datatype := l_parameter_store(i).data_type ;
1129: l_ff_inputs(l_inputs_counter).value := l_parameter_value ;
1130:

Line 1131: hr_utility.set_location(l_procedure_name, 110) ;

1127: l_ff_inputs(l_inputs_counter).name := l_parameter_store(i).external_name ;
1128: l_ff_inputs(l_inputs_counter).datatype := l_parameter_store(i).data_type ;
1129: l_ff_inputs(l_inputs_counter).value := l_parameter_value ;
1130:
1131: hr_utility.set_location(l_procedure_name, 110) ;
1132: if l_parameter_store(i).input_flag = 'Y'
1133: then
1134:
1135: hr_utility.set_location(l_procedure_name, 120) ;

Line 1135: hr_utility.set_location(l_procedure_name, 120) ;

1131: hr_utility.set_location(l_procedure_name, 110) ;
1132: if l_parameter_store(i).input_flag = 'Y'
1133: then
1134:
1135: hr_utility.set_location(l_procedure_name, 120) ;
1136: l_ff_inputs(l_inputs_counter).class := 'INPUT' ;
1137:
1138: else
1139:

Line 1140: hr_utility.set_location(l_procedure_name, 130) ;

1136: l_ff_inputs(l_inputs_counter).class := 'INPUT' ;
1137:
1138: else
1139:
1140: hr_utility.set_location(l_procedure_name, 130) ;
1141: l_ff_inputs(l_inputs_counter).class := 'CONTEXT' ;
1142:
1143: end if ;
1144:

Line 1145: hr_utility.set_location(l_procedure_name, 140) ;

1141: l_ff_inputs(l_inputs_counter).class := 'CONTEXT' ;
1142:
1143: end if ;
1144:
1145: hr_utility.set_location(l_procedure_name, 140) ;
1146: l_inputs_counter := l_inputs_counter + 1 ;
1147:
1148: end if ;
1149:

Line 1152: hr_utility.set_location(l_procedure_name, 150) ;

1148: end if ;
1149:
1150: -- look for outputs
1151:
1152: hr_utility.set_location(l_procedure_name, 150) ;
1153: if l_parameter_store(i).output_flag = 'Y'
1154: then
1155:
1156: hr_utility.set_location(l_procedure_name, 160) ;

Line 1156: hr_utility.set_location(l_procedure_name, 160) ;

1152: hr_utility.set_location(l_procedure_name, 150) ;
1153: if l_parameter_store(i).output_flag = 'Y'
1154: then
1155:
1156: hr_utility.set_location(l_procedure_name, 160) ;
1157: l_ff_outputs(l_outputs_counter).name := l_parameter_store(i).external_name ;
1158: l_outputs_counter := l_outputs_counter + 1 ;
1159:
1160: end if ;

Line 1167: hr_utility.set_location(l_procedure_name, 170) ;

1163:
1164: -- the FF harness has an effective date parameter so get the
1165: -- effective date from the variable store
1166:
1167: hr_utility.set_location(l_procedure_name, 170) ;
1168: retrieve_variable('EFFECTIVE_DATE'
1169: ,'DATE'
1170: ,l_effective_date) ;
1171:

Line 1174: hr_utility.set_location(l_procedure_name, 180) ;

1170: ,l_effective_date) ;
1171:
1172: -- call the FF harness
1173:
1174: hr_utility.set_location(l_procedure_name, 180) ;
1175: per_formula_functions.run_formula
1176: (p_formula_name => p_formula_name
1177: ,p_business_group_id => l_business_group_id
1178: ,p_calculation_date => fnd_date.canonical_to_date(l_effective_date)

Line 1184: hr_utility.set_location(l_procedure_name, 190) ;

1180: ,p_outputs => l_ff_outputs) ;
1181:
1182: -- check the outputs
1183:
1184: hr_utility.set_location(l_procedure_name, 190) ;
1185: for i in l_parameter_store.first..l_parameter_store.last
1186: loop
1187:
1188: hr_utility.set_location(l_procedure_name, 200) ;

Line 1188: hr_utility.set_location(l_procedure_name, 200) ;

1184: hr_utility.set_location(l_procedure_name, 190) ;
1185: for i in l_parameter_store.first..l_parameter_store.last
1186: loop
1187:
1188: hr_utility.set_location(l_procedure_name, 200) ;
1189: if l_parameter_store(i).output_flag = 'Y'
1190: then
1191:
1192: -- get the parameter value from the FF outputs PL/SQL table

Line 1194: hr_utility.set_location(l_procedure_name, 210) ;

1190: then
1191:
1192: -- get the parameter value from the FF outputs PL/SQL table
1193:
1194: hr_utility.set_location(l_procedure_name, 210) ;
1195: l_parameter_value := get_ff_output(l_parameter_store(i).external_name) ;
1196:
1197: -- if the output is flagged as an error message and is not null
1198: -- then raise an error

Line 1200: hr_utility.set_location(l_procedure_name, 220) ;

1196:
1197: -- if the output is flagged as an error message and is not null
1198: -- then raise an error
1199:
1200: hr_utility.set_location(l_procedure_name, 220) ;
1201: if l_parameter_store(i).error_message_flag = 'Y'
1202: and l_parameter_value is not null
1203: then
1204:

Line 1205: hr_utility.set_location(l_procedure_name, 230) ;

1201: if l_parameter_store(i).error_message_flag = 'Y'
1202: and l_parameter_value is not null
1203: then
1204:
1205: hr_utility.set_location(l_procedure_name, 230) ;
1206: l_error := l_parameter_value ;
1207: retrieve_variable('MODULE_NAME'
1208: ,'TEXT'
1209: ,l_module) ;

Line 1219: hr_utility.set_location(l_procedure_name, 240) ;

1215: -- table (so that it can be used as an input to subsequent modules).
1216: -- If the parameter is marked as a result it must also be written to
1217: -- the database.
1218:
1219: hr_utility.set_location(l_procedure_name, 240) ;
1220: store_variable
1221: (l_parameter_store(i).internal_name
1222: ,l_parameter_store(i).data_type
1223: ,l_parameter_value) ;

Line 1225: hr_utility.set_location(l_procedure_name, 250) ;

1221: (l_parameter_store(i).internal_name
1222: ,l_parameter_store(i).data_type
1223: ,l_parameter_value) ;
1224:
1225: hr_utility.set_location(l_procedure_name, 250) ;
1226: if l_parameter_store(i).result_flag = 'Y'
1227: then
1228:
1229: hr_utility.set_location(l_procedure_name, 260) ;

Line 1229: hr_utility.set_location(l_procedure_name, 260) ;

1225: hr_utility.set_location(l_procedure_name, 250) ;
1226: if l_parameter_store(i).result_flag = 'Y'
1227: then
1228:
1229: hr_utility.set_location(l_procedure_name, 260) ;
1230: save_result
1231: (l_parameter_store(i).database_item_name
1232: ,l_parameter_value) ;
1233:

Line 1240: hr_utility.set_location(l_procedure_name, 260) ;

1236: end if ;
1237:
1238: end loop ;
1239:
1240: hr_utility.set_location(l_procedure_name, 260) ;
1241: hr_utility.trace('Out: ' || l_procedure_name) ;
1242:
1243: exception
1244: when e_bad_formula

Line 1241: hr_utility.trace('Out: ' || l_procedure_name) ;

1237:
1238: end loop ;
1239:
1240: hr_utility.set_location(l_procedure_name, 260) ;
1241: hr_utility.trace('Out: ' || l_procedure_name) ;
1242:
1243: exception
1244: when e_bad_formula
1245: then

Line 1246: hr_utility.set_message(801, 'HR_AU_INVALID_FORMULA') ;

1242:
1243: exception
1244: when e_bad_formula
1245: then
1246: hr_utility.set_message(801, 'HR_AU_INVALID_FORMULA') ;
1247: hr_utility.set_message_token('FORMULA', p_formula_name) ;
1248: hr_utility.raise_error ;
1249: when e_module_error
1250: then

Line 1247: hr_utility.set_message_token('FORMULA', p_formula_name) ;

1243: exception
1244: when e_bad_formula
1245: then
1246: hr_utility.set_message(801, 'HR_AU_INVALID_FORMULA') ;
1247: hr_utility.set_message_token('FORMULA', p_formula_name) ;
1248: hr_utility.raise_error ;
1249: when e_module_error
1250: then
1251: hr_utility.set_message(801, 'HR_AU_MODULE_ERROR') ;

Line 1248: hr_utility.raise_error ;

1244: when e_bad_formula
1245: then
1246: hr_utility.set_message(801, 'HR_AU_INVALID_FORMULA') ;
1247: hr_utility.set_message_token('FORMULA', p_formula_name) ;
1248: hr_utility.raise_error ;
1249: when e_module_error
1250: then
1251: hr_utility.set_message(801, 'HR_AU_MODULE_ERROR') ;
1252: hr_utility.set_message_token('MODULE', l_module) ;

Line 1251: hr_utility.set_message(801, 'HR_AU_MODULE_ERROR') ;

1247: hr_utility.set_message_token('FORMULA', p_formula_name) ;
1248: hr_utility.raise_error ;
1249: when e_module_error
1250: then
1251: hr_utility.set_message(801, 'HR_AU_MODULE_ERROR') ;
1252: hr_utility.set_message_token('MODULE', l_module) ;
1253: hr_utility.set_message_token('ERROR', l_error) ;
1254: hr_utility.raise_error ;
1255:

Line 1252: hr_utility.set_message_token('MODULE', l_module) ;

1248: hr_utility.raise_error ;
1249: when e_module_error
1250: then
1251: hr_utility.set_message(801, 'HR_AU_MODULE_ERROR') ;
1252: hr_utility.set_message_token('MODULE', l_module) ;
1253: hr_utility.set_message_token('ERROR', l_error) ;
1254: hr_utility.raise_error ;
1255:
1256: end execute_formula ;

Line 1253: hr_utility.set_message_token('ERROR', l_error) ;

1249: when e_module_error
1250: then
1251: hr_utility.set_message(801, 'HR_AU_MODULE_ERROR') ;
1252: hr_utility.set_message_token('MODULE', l_module) ;
1253: hr_utility.set_message_token('ERROR', l_error) ;
1254: hr_utility.raise_error ;
1255:
1256: end execute_formula ;
1257:

Line 1254: hr_utility.raise_error ;

1250: then
1251: hr_utility.set_message(801, 'HR_AU_MODULE_ERROR') ;
1252: hr_utility.set_message_token('MODULE', l_module) ;
1253: hr_utility.set_message_token('ERROR', l_error) ;
1254: hr_utility.raise_error ;
1255:
1256: end execute_formula ;
1257:
1258: -----------------------------------------------------------------------------

Line 1322: hr_utility.trace('In: ' || l_procedure_name) ;

1318: rcu.sequence_no ;
1319:
1320: begin
1321:
1322: hr_utility.trace('In: ' || l_procedure_name) ;
1323: hr_utility.trace(' p_database_item_name: ' || p_database_item_name) ;
1324: hr_utility.trace(' p_result_value: ' || p_result_value) ;
1325:
1326: -- get the legislation code and assignment action ID for later use

Line 1323: hr_utility.trace(' p_database_item_name: ' || p_database_item_name) ;

1319:
1320: begin
1321:
1322: hr_utility.trace('In: ' || l_procedure_name) ;
1323: hr_utility.trace(' p_database_item_name: ' || p_database_item_name) ;
1324: hr_utility.trace(' p_result_value: ' || p_result_value) ;
1325:
1326: -- get the legislation code and assignment action ID for later use
1327:

Line 1324: hr_utility.trace(' p_result_value: ' || p_result_value) ;

1320: begin
1321:
1322: hr_utility.trace('In: ' || l_procedure_name) ;
1323: hr_utility.trace(' p_database_item_name: ' || p_database_item_name) ;
1324: hr_utility.trace(' p_result_value: ' || p_result_value) ;
1325:
1326: -- get the legislation code and assignment action ID for later use
1327:
1328: retrieve_variable('LEGISLATION_CODE'

Line 1452: hr_utility.trace('Out: ' || l_procedure_name) ;

1448: ,p_context_name31 => l_context_store(31).name
1449: ,p_context31 => l_context_store(31).value
1450: ,p_some_warning => l_some_warning) ;
1451:
1452: hr_utility.trace('Out: ' || l_procedure_name) ;
1453:
1454: exception
1455: when e_bad_user_entity
1456: then

Line 1457: hr_utility.set_message(801, 'HR_AU_INVALID_USER_ENTITY') ;

1453:
1454: exception
1455: when e_bad_user_entity
1456: then
1457: hr_utility.set_message(801, 'HR_AU_INVALID_USER_ENTITY') ;
1458: hr_utility.set_message_token('USER_ENTITY', p_database_item_name) ;
1459: hr_utility.raise_error ;
1460:
1461: end save_result ;

Line 1458: hr_utility.set_message_token('USER_ENTITY', p_database_item_name) ;

1454: exception
1455: when e_bad_user_entity
1456: then
1457: hr_utility.set_message(801, 'HR_AU_INVALID_USER_ENTITY') ;
1458: hr_utility.set_message_token('USER_ENTITY', p_database_item_name) ;
1459: hr_utility.raise_error ;
1460:
1461: end save_result ;
1462:

Line 1459: hr_utility.raise_error ;

1455: when e_bad_user_entity
1456: then
1457: hr_utility.set_message(801, 'HR_AU_INVALID_USER_ENTITY') ;
1458: hr_utility.set_message_token('USER_ENTITY', p_database_item_name) ;
1459: hr_utility.raise_error ;
1460:
1461: end save_result ;
1462:
1463: -----------------------------------------------------------------------------

Line 1496: hr_utility.trace('In: ' || l_procedure_name) ;

1492: and mp.enabled_flag = 'Y' ;
1493:
1494: begin
1495:
1496: hr_utility.trace('In: ' || l_procedure_name) ;
1497:
1498: for r_module_parameter in c_module_parameters(p_module_id)
1499: loop
1500:

Line 1517: hr_utility.trace('Out: ' || l_procedure_name) ;

1513: l_counter := l_counter + 1 ;
1514:
1515: end loop ; -- c_module_parameters
1516:
1517: hr_utility.trace('Out: ' || l_procedure_name) ;
1518:
1519: end get_module_parameters ;
1520:
1521: end pay_au_generic_code_caller ;