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.

[Home] [Help]

APPS.WMS_ATF_REG_CUST_APIS dependencies on WMS_API_HOOK_CALLS

Line 628: from wms_api_hook_calls

624:
625: cursor c_api_hook_calls(l_module_hook_id number) is
626: select hook_call_id, enabled_flag, called_package, called_procedure,
627: effective_from_date, effective_to_date
628: from wms_api_hook_calls
629: where module_hook_id = l_module_hook_id
630: and enabled_flag = 'Y'
631: and (effective_to_date >= sysdate or effective_to_date is null)
632: order by hook_call_id;

Line 763: -- no records found in wms_api_hook_calls table

759: end if;
760: end loop;
761:
762: if l_inner_loop = 0 then
763: -- no records found in wms_api_hook_calls table
764: -- Hence insert a null between the begin and end in the body so that the
765: -- package generation will not fail. There can be cases where all relationships
766: -- for a parent may be disabled and this cursor will not return records.
767: add_to_string(c_new_line, 'B');

Line 1260: -- WMS_API_HOOK_CALLS table. Not in

1256: -- error for the call package
1257: -- procedure.
1258: l_encoded_err_text varchar2(2000); -- Set to the encoded error text
1259: -- when an error is written to the
1260: -- WMS_API_HOOK_CALLS table. Not in
1261: -- patchset 'J'.
1262: l_call_code varchar2(32767) := null;
1263: l_proc varchar2(72) := 'VALIDATE_CALL_SIGNATURE :';
1264: l_prog float;

Line 1748: wms_api_hook_calls wahc

1744: wahe.sysgen_custom_package, wahe.sysgen_custom_procedure,
1745: wahc.called_package, wahc.called_procedure, wahc.hook_call_id,
1746: wahc.enabled_flag, wahc.seed_flag
1747: from wms_api_hooked_entities wahe,
1748: wms_api_hook_calls wahc
1749: where wahe.module_hook_id = wahc.module_hook_id(+)
1750: and wahe.short_name_id = p_hook_short_name_id
1751: and wahc.called_package(+) = p_call_package
1752: and wahc.called_procedure(+) = p_call_procedure;

Line 1847: -- Delete records in the WMS_API_HOOK_CALLS table..

1843: trace(l_proc||' Hook Call ID ' || l_hook_call_id);
1844: end if;
1845:
1846: --
1847: -- Delete records in the WMS_API_HOOK_CALLS table..
1848: --
1849: l_prog := 45;
1850: delete from wms_api_hook_calls
1851: where module_hook_id = l_module_hook_id

Line 1850: delete from wms_api_hook_calls

1846: --
1847: -- Delete records in the WMS_API_HOOK_CALLS table..
1848: --
1849: l_prog := 45;
1850: delete from wms_api_hook_calls
1851: where module_hook_id = l_module_hook_id
1852: and hook_call_id = l_hook_call_id
1853: and called_package = p_call_package
1854: and called_procedure = p_call_procedure;

Line 2014: -- a record in the wms_api_hook_calls.

2010: -- Signature Validity check...
2011: --
2012: if l_sign_valid then
2013: -- Now that all the checks have been done we are ready to create
2014: -- a record in the wms_api_hook_calls.
2015: l_prog := 55;
2016: select wms_api_hook_calls_s.nextval
2017: into l_hook_call_id_seq
2018: from dual;

Line 2016: select wms_api_hook_calls_s.nextval

2012: if l_sign_valid then
2013: -- Now that all the checks have been done we are ready to create
2014: -- a record in the wms_api_hook_calls.
2015: l_prog := 55;
2016: select wms_api_hook_calls_s.nextval
2017: into l_hook_call_id_seq
2018: from dual;
2019:
2020: if (l_debug = 1) then

Line 2023: trace(l_proc||' Inserting records into the wms_api_hook_calls table....', 4);

2019:
2020: if (l_debug = 1) then
2021: trace(l_proc||' Passed Progress :'|| l_prog);
2022: trace(l_proc||' Hook Call ID sequence to be inserted : ' || l_hook_call_id_seq);
2023: trace(l_proc||' Inserting records into the wms_api_hook_calls table....', 4);
2024: end if;
2025:
2026:
2027: insert into wms_api_hook_calls(

Line 2027: insert into wms_api_hook_calls(

2023: trace(l_proc||' Inserting records into the wms_api_hook_calls table....', 4);
2024: end if;
2025:
2026:
2027: insert into wms_api_hook_calls(
2028: hook_call_id
2029: , module_hook_id
2030: , enabled_flag
2031: , called_package

Line 2061: trace(l_proc||' After Calling Insert into wms_api_hook_calls..', 4);

2057:
2058: l_prog := 57;
2059: if (l_debug = 1) then
2060: trace(l_proc||' Passed Progress :'|| l_prog);
2061: trace(l_proc||' After Calling Insert into wms_api_hook_calls..', 4);
2062: end if;
2063:
2064: if (l_debug = 1) then
2065: trace(l_proc||' Record Inserted into wms_api_hook_calls successfully.....', 4);

Line 2065: trace(l_proc||' Record Inserted into wms_api_hook_calls successfully.....', 4);

2061: trace(l_proc||' After Calling Insert into wms_api_hook_calls..', 4);
2062: end if;
2063:
2064: if (l_debug = 1) then
2065: trace(l_proc||' Record Inserted into wms_api_hook_calls successfully.....', 4);
2066: end if;
2067:
2068: l_prog := 58;
2069: if (l_debug = 1) then

Line 2179: trace(l_proc||' Error Deleting WMS_API_HOOK_CALLS table due to error: ' || sqlerrm(sqlcode), 4);

2175: return;
2176: when others then
2177: if (l_debug = 1) then
2178: if (l_prog = 45) then
2179: trace(l_proc||' Error Deleting WMS_API_HOOK_CALLS table due to error: ' || sqlerrm(sqlcode), 4);
2180: end if;
2181:
2182: if (l_prog = 56) then
2183: trace(l_proc||' Insert into wms_api_hook_calls failed with ' || sqlerrm(sqlcode), 4);

Line 2183: trace(l_proc||' Insert into wms_api_hook_calls failed with ' || sqlerrm(sqlcode), 4);

2179: trace(l_proc||' Error Deleting WMS_API_HOOK_CALLS table due to error: ' || sqlerrm(sqlcode), 4);
2180: end if;
2181:
2182: if (l_prog = 56) then
2183: trace(l_proc||' Insert into wms_api_hook_calls failed with ' || sqlerrm(sqlcode), 4);
2184: end if;
2185:
2186: if (l_prog = 55) then
2187: trace(l_proc||' Select from Sequence wms_api_hook_calls_s failed with ' || sqlerrm(sqlcode), 4);

Line 2187: trace(l_proc||' Select from Sequence wms_api_hook_calls_s failed with ' || sqlerrm(sqlcode), 4);

2183: trace(l_proc||' Insert into wms_api_hook_calls failed with ' || sqlerrm(sqlcode), 4);
2184: end if;
2185:
2186: if (l_prog = 55) then
2187: trace(l_proc||' Select from Sequence wms_api_hook_calls_s failed with ' || sqlerrm(sqlcode), 4);
2188: end if;
2189:
2190: if (l_prog = 51) then
2191: trace(l_proc||' Invalid package/procedure combination ', 4);