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.WMS_ATF_REG_CUST_APIS dependencies on WMS_API_HOOK_CALLS

Line 635: from wms_api_hook_calls

631:
632: cursor c_api_hook_calls(l_module_hook_id number) is
633: select hook_call_id, enabled_flag, called_package, called_procedure,
634: effective_from_date, effective_to_date
635: from wms_api_hook_calls
636: where module_hook_id = l_module_hook_id
637: and enabled_flag = 'Y'
638: and (effective_to_date >= sysdate or effective_to_date is null)
639: order by hook_call_id;

Line 770: -- no records found in wms_api_hook_calls table

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

Line 1274: -- WMS_API_HOOK_CALLS table. Not in

1270: -- error for the call package
1271: -- procedure.
1272: l_encoded_err_text varchar2(2000); -- Set to the encoded error text
1273: -- when an error is written to the
1274: -- WMS_API_HOOK_CALLS table. Not in
1275: -- patchset 'J'.
1276: l_call_code varchar2(32767) := null;
1277: l_proc varchar2(72) := 'VALIDATE_CALL_SIGNATURE :';
1278: l_prog float;

Line 1762: wms_api_hook_calls wahc

1758: wahe.sysgen_custom_package, wahe.sysgen_custom_procedure,
1759: wahc.called_package, wahc.called_procedure, wahc.hook_call_id,
1760: wahc.enabled_flag, wahc.seed_flag
1761: from wms_api_hooked_entities wahe,
1762: wms_api_hook_calls wahc
1763: where wahe.module_hook_id = wahc.module_hook_id(+)
1764: and wahe.short_name_id = p_hook_short_name_id
1765: and wahc.called_package(+) = p_call_package
1766: and wahc.called_procedure(+) = p_call_procedure;

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

1857: trace(l_proc||' Hook Call ID ' || l_hook_call_id);
1858: end if;
1859:
1860: --
1861: -- Delete records in the WMS_API_HOOK_CALLS table..
1862: --
1863: l_prog := 45;
1864: delete from wms_api_hook_calls
1865: where module_hook_id = l_module_hook_id

Line 1864: delete from wms_api_hook_calls

1860: --
1861: -- Delete records in the WMS_API_HOOK_CALLS table..
1862: --
1863: l_prog := 45;
1864: delete from wms_api_hook_calls
1865: where module_hook_id = l_module_hook_id
1866: and hook_call_id = l_hook_call_id
1867: and called_package = p_call_package
1868: and called_procedure = p_call_procedure;

Line 2035: -- a record in the wms_api_hook_calls.

2031: -- Signature Validity check...
2032: --
2033: if l_sign_valid then
2034: -- Now that all the checks have been done we are ready to create
2035: -- a record in the wms_api_hook_calls.
2036: l_prog := 55;
2037: select wms_api_hook_calls_s.nextval
2038: into l_hook_call_id_seq
2039: from dual;

Line 2037: select wms_api_hook_calls_s.nextval

2033: if l_sign_valid then
2034: -- Now that all the checks have been done we are ready to create
2035: -- a record in the wms_api_hook_calls.
2036: l_prog := 55;
2037: select wms_api_hook_calls_s.nextval
2038: into l_hook_call_id_seq
2039: from dual;
2040:
2041: if (l_debug = 1) then

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

2040:
2041: if (l_debug = 1) then
2042: trace(l_proc||' Passed Progress :'|| l_prog);
2043: trace(l_proc||' Hook Call ID sequence to be inserted : ' || l_hook_call_id_seq);
2044: trace(l_proc||' Inserting records into the wms_api_hook_calls table....', 4);
2045: end if;
2046:
2047:
2048: insert into wms_api_hook_calls(

Line 2048: insert into wms_api_hook_calls(

2044: trace(l_proc||' Inserting records into the wms_api_hook_calls table....', 4);
2045: end if;
2046:
2047:
2048: insert into wms_api_hook_calls(
2049: hook_call_id
2050: , module_hook_id
2051: , enabled_flag
2052: , called_package

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

2078:
2079: l_prog := 57;
2080: if (l_debug = 1) then
2081: trace(l_proc||' Passed Progress :'|| l_prog);
2082: trace(l_proc||' After Calling Insert into wms_api_hook_calls..', 4);
2083: end if;
2084:
2085: if (l_debug = 1) then
2086: trace(l_proc||' Record Inserted into wms_api_hook_calls successfully.....', 4);

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

2082: trace(l_proc||' After Calling Insert into wms_api_hook_calls..', 4);
2083: end if;
2084:
2085: if (l_debug = 1) then
2086: trace(l_proc||' Record Inserted into wms_api_hook_calls successfully.....', 4);
2087: end if;
2088:
2089: l_prog := 58;
2090: if (l_debug = 1) then

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

2196: return;
2197: when others then
2198: if (l_debug = 1) then
2199: if (l_prog = 45) then
2200: trace(l_proc||' Error Deleting WMS_API_HOOK_CALLS table due to error: ' || sqlerrm(sqlcode), 4);
2201: end if;
2202:
2203: if (l_prog = 56) then
2204: trace(l_proc||' Insert into wms_api_hook_calls failed with ' || sqlerrm(sqlcode), 4);

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

2200: trace(l_proc||' Error Deleting WMS_API_HOOK_CALLS table due to error: ' || sqlerrm(sqlcode), 4);
2201: end if;
2202:
2203: if (l_prog = 56) then
2204: trace(l_proc||' Insert into wms_api_hook_calls failed with ' || sqlerrm(sqlcode), 4);
2205: end if;
2206:
2207: if (l_prog = 55) then
2208: trace(l_proc||' Select from Sequence wms_api_hook_calls_s failed with ' || sqlerrm(sqlcode), 4);

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

2204: trace(l_proc||' Insert into wms_api_hook_calls failed with ' || sqlerrm(sqlcode), 4);
2205: end if;
2206:
2207: if (l_prog = 55) then
2208: trace(l_proc||' Select from Sequence wms_api_hook_calls_s failed with ' || sqlerrm(sqlcode), 4);
2209: end if;
2210:
2211: if (l_prog = 51) then
2212: trace(l_proc||' Invalid package/procedure combination ', 4);