1: PACKAGE BODY CSI_ITEM_INSTANCE_VUHK AS
2: /* $Header: jtmitemb.pls 120.2 2005/08/24 02:15:22 saradhak noship $ */
3:
4: PROCEDURE create_item_instance_pre
5: (
49: l_strBuffer VARCHAR2(2000);
50: l_strLogBuffer VARCHAR2(2000) := ' begin ' ||
51: ' JTM_MESSAGE_LOG_PKG.log_msg(' ||
52: ' ''CREATE_ITEM_INSTANCE_POST'', ' ||
53: ' ''CSI_ITEM_INSTANCE_VUHK'', ' ||
54: ' ''Error:'' || SQLERRM ' || ',' ||
55: ' 1,' ||
56: ' ''JTM.CSI_ITEM_INSTANCE_VUHK.CREATE_ITEM_INSTANCE_POST''); ' ||
57: ' exception ' ||
52: ' ''CREATE_ITEM_INSTANCE_POST'', ' ||
53: ' ''CSI_ITEM_INSTANCE_VUHK'', ' ||
54: ' ''Error:'' || SQLERRM ' || ',' ||
55: ' 1,' ||
56: ' ''JTM.CSI_ITEM_INSTANCE_VUHK.CREATE_ITEM_INSTANCE_POST''); ' ||
57: ' exception ' ||
58: ' when others then null;' ||
59: ' end; ';
60: BEGIN
63: begin
64: EXECUTE IMMEDIATE
65: ' begin JTM_MESSAGE_LOG_PKG.log_msg(' ||
66: ' ''CREATE_ITEM_INSTANCE_POST'', ' ||
67: ' ''CSI_ITEM_INSTANCE_VUHK'', ' ||
68: ' ''The procedure is called.'', ' ||
69: ' 4,' ||
70: ' ''JTM.CSI_ITEM_INSTANCE_VUHK.CREATE_ITEM_INSTANCE_POST''); ' ||
71: ' end; ';
66: ' ''CREATE_ITEM_INSTANCE_POST'', ' ||
67: ' ''CSI_ITEM_INSTANCE_VUHK'', ' ||
68: ' ''The procedure is called.'', ' ||
69: ' 4,' ||
70: ' ''JTM.CSI_ITEM_INSTANCE_VUHK.CREATE_ITEM_INSTANCE_POST''); ' ||
71: ' end; ';
72: exception
73: when others then
74: null;
144: l_strLogBuffer VARCHAR2(2000) :=
145: ' begin ' ||
146: ' JTM_MESSAGE_LOG_PKG.log_msg(' ||
147: ' ''UPDATE_ITEM_INSTANCE_PRE'', ' ||
148: ' ''CSI_ITEM_INSTANCE_VUHK'', ' ||
149: ' ''Error:'' || SQLERRM ' || ',' ||
150: ' 1,' ||
151: ' ''JTM.CSI_ITEM_INSTANCE_VUHK.UPDATE_ITEM_INSTANCE_PRE''); ' ||
152: ' exception ' ||
147: ' ''UPDATE_ITEM_INSTANCE_PRE'', ' ||
148: ' ''CSI_ITEM_INSTANCE_VUHK'', ' ||
149: ' ''Error:'' || SQLERRM ' || ',' ||
150: ' 1,' ||
151: ' ''JTM.CSI_ITEM_INSTANCE_VUHK.UPDATE_ITEM_INSTANCE_PRE''); ' ||
152: ' exception ' ||
153: ' when others then null;' ||
154: ' end; ';
155: BEGIN
158: begin
159: EXECUTE IMMEDIATE
160: ' begin JTM_MESSAGE_LOG_PKG.log_msg(' ||
161: ' ''UPDATE_ITEM_INSTANCE_PRE'', ' ||
162: ' ''CSI_ITEM_INSTANCE_VUHK'', ' ||
163: ' ''The procedure is called.'', ' ||
164: ' 4,' ||
165: ' ''JTM.CSI_ITEM_INSTANCE_VUHK.UPDATE_ITEM_INSTANCE_PRE''); ' ||
166: ' end; ';
161: ' ''UPDATE_ITEM_INSTANCE_PRE'', ' ||
162: ' ''CSI_ITEM_INSTANCE_VUHK'', ' ||
163: ' ''The procedure is called.'', ' ||
164: ' 4,' ||
165: ' ''JTM.CSI_ITEM_INSTANCE_VUHK.UPDATE_ITEM_INSTANCE_PRE''); ' ||
166: ' end; ';
167: exception
168: when others then
169: null;
238: l_strLogBuffer VARCHAR2(2000)
239: := ' begin ' ||
240: ' JTM_MESSAGE_LOG_PKG.log_msg(' ||
241: ' ''UPDATE_ITEM_INSTANCE_POST'', ' ||
242: ' ''CSI_ITEM_INSTANCE_VUHK'', ' ||
243: ' ''Error:'' || SQLERRM ' || ',' ||
244: ' 1,' ||
245: ' ''JTM.CSI_ITEM_INSTANCE_VUHK.UPDATE_ITEM_INSTANCE_POST''); ' ||
246: ' exception ' ||
241: ' ''UPDATE_ITEM_INSTANCE_POST'', ' ||
242: ' ''CSI_ITEM_INSTANCE_VUHK'', ' ||
243: ' ''Error:'' || SQLERRM ' || ',' ||
244: ' 1,' ||
245: ' ''JTM.CSI_ITEM_INSTANCE_VUHK.UPDATE_ITEM_INSTANCE_POST''); ' ||
246: ' exception ' ||
247: ' when others then null;' ||
248: ' end; ';
249:
253: begin
254: EXECUTE IMMEDIATE
255: ' begin JTM_MESSAGE_LOG_PKG.log_msg(' ||
256: ' ''UPDATE_ITEM_INSTANCE_POST'', ' ||
257: ' ''CSI_ITEM_INSTANCE_VUHK'', ' ||
258: ' ''The procedure is called.'', ' ||
259: ' 4,' ||
260: ' ''JTM.CSI_ITEM_INSTANCE_VUHK.UPDATE_ITEM_INSTANCE_POST''); ' ||
261: ' end; ';
256: ' ''UPDATE_ITEM_INSTANCE_POST'', ' ||
257: ' ''CSI_ITEM_INSTANCE_VUHK'', ' ||
258: ' ''The procedure is called.'', ' ||
259: ' 4,' ||
260: ' ''JTM.CSI_ITEM_INSTANCE_VUHK.UPDATE_ITEM_INSTANCE_POST''); ' ||
261: ' end; ';
262: exception
263: when others then
264: null;
343: BEGIN
344: x_return_status := FND_API.G_RET_STS_SUCCESS;
345: END;
346:
347: END CSI_ITEM_INSTANCE_VUHK;