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