[Home] [Help]
662: -- Creates source code for one package procedure call.
663: --
664: -- Post Failure:
665: -- Details of any application errors and some Oracle errors are written
666: -- to the HR_API_HOOK_CALLS table.
667: --
668: -- Access Status:
669: -- Internal Development Use Only.
670: --
709: -- error for the call package
710: -- procedure.
711: l_encoded_err_text varchar2(2000); -- Set to the encoded error text
712: -- when an error is written to the
713: -- HR_API_HOOK_CALLS table.
714: l_call_code varchar2(32767) := null;
715: l_proc varchar2(72) := g_package||'make_procedure_call';
716: begin
717: hr_utility.set_location('Entering:'|| l_proc, 10);
869: if l_param_valid then
870: --
871: -- If the last parameter processed was valid then all the parameters must
872: -- be valid. Add the calling code which has been built-up to the rest of
873: -- the source code. Update the HR_API_HOOK_CALLS table to note that the
874: -- call has been successfully created.
875: --
876: add_to_source(l_call_code);
877: -- Change the following update statement to
875: --
876: add_to_source(l_call_code);
877: -- Change the following update statement to
878: -- call the row handler, when it is available.
879: update hr_api_hook_calls
880: set pre_processor_date = sysdate
881: , encoded_error = null
882: , status = 'V'
883: , object_version_number = object_version_number + 1
891: -- not complete and it should not be added to the rest of the source code.
892: -- Either this procedure (for a hr_general.describe_procedure error) or
893: -- the chk_param_in_hook_proc_call function (for a parameter error) has set
894: -- the AOL message stack will details of the error. The error details should
895: -- be written to the HR_API_HOOK_CALLS using the encoded format. Some comment
896: -- text and a 'null' statement should be added to the hook package body
897: -- source code to show there is a problem.
898: --
899: if l_describe_error or (not l_param_valid) then
902: --
903: l_encoded_err_text := fnd_message.get_encoded;
904: -- Change the following update DML statement to
905: -- call the API when it is available.
906: update hr_api_hook_calls
907: set pre_processor_date = sysdate
908: , encoded_error = l_encoded_err_text
909: , status = 'I'
910: , object_version_number = object_version_number + 1
919: add_to_source('-- Details of the error, in FND encoded format, can ');
920: add_to_source('be obtained' || c_new_line);
921: add_to_source('-- with the following sql statement:' || c_new_line);
922: add_to_source('-- select c.encoded_error' || c_new_line);
923: add_to_source('-- from hr_api_hook_calls c' || c_new_line);
924: add_to_source('-- where c.api_hook_call_id = ');
925: add_to_source(to_char(p_api_hook_call_id) || ';' || c_new_line);
926: add_to_source('null;' || c_new_line);
927: --
1562: -- Creates source code to carry out legislation specific hook calls.
1563: --
1564: -- Post Failure:
1565: -- Any application errors and some system errors are written to the
1566: -- corresponding row in the HR_API_HOOKS or HR_API_HOOK_CALLS tables.
1567: --
1568: -- Access Status:
1569: -- Internal Development Use Only.
1570: --
1587: , object_version_number
1588: , legislation_code
1589: , call_package
1590: , call_procedure
1591: from hr_api_hook_calls
1592: where legislation_code is not null
1593: and enabled_flag = 'Y'
1594: and api_hook_id = p_api_hook_id
1595: order by legislation_code, sequence;
1727: -- Creates source code to carry out application specific hook calls.
1728: --
1729: -- Post Failure:
1730: -- Any application errors and some system errors are written to the
1731: -- corresponding row in the HR_API_HOOKS or HR_API_HOOK_CALLS tables.
1732: --
1733: -- Access Status:
1734: -- Internal Development Use Only.
1735: --
1748: select ahc.api_hook_call_id
1749: , ahc.object_version_number
1750: , ahc.call_package
1751: , ahc.call_procedure
1752: from hr_api_hook_calls ahc
1753: , fnd_product_installations fpi
1754: where ahc.api_hook_id = p_api_hook_id
1755: and ahc.enabled_flag = 'Y'
1756: and ahc.application_id is not null
1822: -- greater than zero, lists the
1823: -- parameter data types.
1824: -- p_sequence_number_range Yes varchar2 Affects which rows are
1825: -- selected from the
1826: -- HR_API_HOOK_CALLS table.
1827: -- Must be set to 'LOW', 'HIGH'
1828: -- or 'ALL'.
1829: --
1830: -- Post Success:
1832: -- specified sequence number range.
1833: --
1834: -- Post Failure:
1835: -- Any application errors and some Oracle errors are written to the
1836: -- corresponding row in the HR_API_HOOK_CALLS table.
1837: --
1838: -- Access Status:
1839: -- Internal Development Use Only.
1840: --
1870: l_dynamic_sql := 'select api_hook_call_id' ||
1871: ' , object_version_number' ||
1872: ' , call_package' ||
1873: ' , call_procedure' ||
1874: ' from hr_api_hook_calls' ||
1875: ' where legislation_code is null' ||
1876: ' and application_id is null' ||
1877: ' and enabled_flag = ' || '''' || 'Y' || '''' ||
1878: ' and api_hook_id = :p_api_hook_id ' ||
2004: -- p_api_hook_id Yes number ID of the hook details from
2005: -- the HR_API_HOOKS table.
2006: --
2007: -- Post Success:
2008: -- Updates all the rows in the HR_API_HOOK_CALLS table which match the
2009: -- api_hook_id and the enabled_flag is 'N'. Customer and legislation
2010: -- hook calls are updated. The encoded_error, status and pre_processor_date
2011: -- columns are populated.
2012: --
2026: --
2027: cursor csr_disabled is
2028: select api_hook_call_id
2029: , object_version_number
2030: from hr_api_hook_calls
2031: where enabled_flag = 'N'
2032: and api_hook_id = p_api_hook_id;
2033: --
2034: l_proc varchar2(72) := g_package||'update_disabled_calls';
2039: --
2040: for l_disabled in csr_disabled loop
2041: -- Change the following update statement to
2042: -- call the row handler, when it is available.
2043: update hr_api_hook_calls
2044: set pre_processor_date = sysdate
2045: , encoded_error = null
2046: , status = 'V'
2047: , object_version_number = object_version_number + 1
2100: -- Creates source code for the hook procedure in the source store.
2101: --
2102: -- Post Failure:
2103: -- Most application and some Oracle errors are written to the corresponding
2104: -- rows in the HR_API_HOOKS or HR_API_HOOK_CALLS tables. Some application
2105: -- or Oracle errors are raised from this procedure as PL/SQL exceptions.
2106: --
2107: -- Access Status:
2108: -- Internal Development Use Only.
2127: -- hook calls exist for this hook.
2128: --
2129: cursor csr_cus_call_exist is
2130: select 1
2131: from hr_api_hook_calls
2132: where enabled_flag = 'Y'
2133: and legislation_code is null
2134: and application_id is null
2135: and api_hook_id = p_api_hook_id;
2138: -- hook calls exist for this hook.
2139: --
2140: cursor csr_leg_call_exist is
2141: select 1
2142: from hr_api_hook_calls
2143: where enabled_flag = 'Y'
2144: and legislation_code is not null
2145: and api_hook_id = p_api_hook_id;
2146: --
2149: -- install status for this hook.
2150: --
2151: cursor csr_app_call_exist is
2152: select 1
2153: from hr_api_hook_calls ahc
2154: , fnd_product_installations fpi
2155: where ahc.api_hook_id = p_api_hook_id
2156: and ahc.enabled_flag = 'Y'
2157: and ahc.application_id is not null
2166: -- hook.
2167: --
2168: cursor csr_ap_leg_call_exist is
2169: select 1
2170: from hr_api_hook_calls ahc
2171: , hr_api_hooks ahk_ap
2172: , hr_api_modules amk
2173: , hr_api_hooks ahk_bp
2174: where ahc.enabled_flag = 'Y'
2855: -- Creates source code for the hook procedure in the source store.
2856: --
2857: -- Post Failure:
2858: -- Most application and some Oracle errors are written to the corresponding
2859: -- rows in the HR_API_HOOKS or HR_API_HOOK_CALLS tables. Some application
2860: -- or Oracle errors are raised from this procedure as PL/SQL exceptions.
2861: --
2862: -- Access Status:
2863: -- Internal Development Use Only.
2972: -- those procedures which have been listed in the the HR_API_HOOKS table.
2973: --
2974: -- Post Failure:
2975: -- Most application and some Oracle errors are written to the corresponding
2976: -- rows in the HR_API_HOOKS or HR_API_HOOK_CALLS tables. Some application
2977: -- or Oracle errors are raised from this procedure as PL/SQL exceptions.
2978: --
2979: -- Access Status:
2980: -- Internal Development Use Only.