DBA Data[Home] [Help]

APPS.WMS_ATF_REG_CUST_APIS dependencies on WMS_API_HOOK_CALLS_S

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 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 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);