APPS.CSI_ITEM_INSTANCE_VUHK dependencies on CSI_ITEM_INSTANCE_VUHK

Line 1: PACKAGE BODY CSI_ITEM_INSTANCE_VUHK AS

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: (

Line 53: ' ''CSI_ITEM_INSTANCE_VUHK'', ' ||

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 ' ||

Line 56: ' ''JTM.CSI_ITEM_INSTANCE_VUHK.CREATE_ITEM_INSTANCE_POST''); ' ||

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

Line 67: ' ''CSI_ITEM_INSTANCE_VUHK'', ' ||

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

Line 70: ' ''JTM.CSI_ITEM_INSTANCE_VUHK.CREATE_ITEM_INSTANCE_POST''); ' ||

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;

Line 148: ' ''CSI_ITEM_INSTANCE_VUHK'', ' ||

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 ' ||

Line 151: ' ''JTM.CSI_ITEM_INSTANCE_VUHK.UPDATE_ITEM_INSTANCE_PRE''); ' ||

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

Line 162: ' ''CSI_ITEM_INSTANCE_VUHK'', ' ||

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

Line 165: ' ''JTM.CSI_ITEM_INSTANCE_VUHK.UPDATE_ITEM_INSTANCE_PRE''); ' ||

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;

Line 242: ' ''CSI_ITEM_INSTANCE_VUHK'', ' ||

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 ' ||

Line 245: ' ''JTM.CSI_ITEM_INSTANCE_VUHK.UPDATE_ITEM_INSTANCE_POST''); ' ||

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:

Line 257: ' ''CSI_ITEM_INSTANCE_VUHK'', ' ||

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

Line 260: ' ''JTM.CSI_ITEM_INSTANCE_VUHK.UPDATE_ITEM_INSTANCE_POST''); ' ||

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;

Line 347: END CSI_ITEM_INSTANCE_VUHK;

343: BEGIN
344: x_return_status := FND_API.G_RET_STS_SUCCESS;
345: END;
346:
347: END CSI_ITEM_INSTANCE_VUHK;