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.CSM_MTL_SEC_INV_EVENT_PKG dependencies on CSM_MTL_SEC_INV_EVENT_PKG

Line 1: PACKAGE BODY CSM_MTL_SEC_INV_EVENT_PKG

1: PACKAGE BODY CSM_MTL_SEC_INV_EVENT_PKG
2: /* $Header: csmemsb.pls 120.1 2005/07/25 00:12:26 trajasek noship $*/
3: AS
4: --
5: -- To modify this template, edit file PKGBODY.TXT in TEMPLATE

Line 32: CSM_UTIL_PKG.LOG('Entering CSM_MTL_SEC_INV_EVENT_PKG.insert_mtl_sec_inventory ',

28: l_sqlerrno varchar2(20);
29: l_sqlerrmsg varchar2(2000);
30:
31: BEGIN
32: CSM_UTIL_PKG.LOG('Entering CSM_MTL_SEC_INV_EVENT_PKG.insert_mtl_sec_inventory ',
33: 'CSM_MTL_SEC_INV_EVENT_PKG.insert_mtl_sec_inventory',FND_LOG.LEVEL_PROCEDURE);
34:
35: CSM_ACC_PKG.Insert_Acc
36: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1

Line 33: 'CSM_MTL_SEC_INV_EVENT_PKG.insert_mtl_sec_inventory',FND_LOG.LEVEL_PROCEDURE);

29: l_sqlerrmsg varchar2(2000);
30:
31: BEGIN
32: CSM_UTIL_PKG.LOG('Entering CSM_MTL_SEC_INV_EVENT_PKG.insert_mtl_sec_inventory ',
33: 'CSM_MTL_SEC_INV_EVENT_PKG.insert_mtl_sec_inventory',FND_LOG.LEVEL_PROCEDURE);
34:
35: CSM_ACC_PKG.Insert_Acc
36: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
37: ,P_ACC_TABLE_NAME => g_acc_table_name1

Line 46: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_SEC_INV_EVENT_PKG.insert_mtl_sec_inventory ',

42: ,P_PK2_NUM_VALUE => p_organization_id
43: ,P_USER_ID => p_user_id
44: );
45:
46: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_SEC_INV_EVENT_PKG.insert_mtl_sec_inventory ',
47: 'CSM_MTL_SEC_INV_EVENT_PKG.insert_mtl_sec_inventory',FND_LOG.LEVEL_PROCEDURE);
48:
49: EXCEPTION
50: WHEN others THEN

Line 47: 'CSM_MTL_SEC_INV_EVENT_PKG.insert_mtl_sec_inventory',FND_LOG.LEVEL_PROCEDURE);

43: ,P_USER_ID => p_user_id
44: );
45:
46: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_SEC_INV_EVENT_PKG.insert_mtl_sec_inventory ',
47: 'CSM_MTL_SEC_INV_EVENT_PKG.insert_mtl_sec_inventory',FND_LOG.LEVEL_PROCEDURE);
48:
49: EXCEPTION
50: WHEN others THEN
51: l_sqlerrno := to_char(SQLCODE);

Line 53: CSM_UTIL_PKG.LOG('Exception in CSM_MTL_SEC_INV_EVENT_PKG.insert_mtl_sec_inventory: ' || l_sqlerrno || ':' || l_sqlerrmsg,

49: EXCEPTION
50: WHEN others THEN
51: l_sqlerrno := to_char(SQLCODE);
52: l_sqlerrmsg := substr(SQLERRM, 1,2000);
53: CSM_UTIL_PKG.LOG('Exception in CSM_MTL_SEC_INV_EVENT_PKG.insert_mtl_sec_inventory: ' || l_sqlerrno || ':' || l_sqlerrmsg,
54: 'CSM_MTL_SEC_INV_EVENT_PKG.insert_mtl_sec_inventory', FND_LOG.LEVEL_EXCEPTION);
55:
56: END insert_mtl_sec_inventory;
57:

Line 54: 'CSM_MTL_SEC_INV_EVENT_PKG.insert_mtl_sec_inventory', FND_LOG.LEVEL_EXCEPTION);

50: WHEN others THEN
51: l_sqlerrno := to_char(SQLCODE);
52: l_sqlerrmsg := substr(SQLERRM, 1,2000);
53: CSM_UTIL_PKG.LOG('Exception in CSM_MTL_SEC_INV_EVENT_PKG.insert_mtl_sec_inventory: ' || l_sqlerrno || ':' || l_sqlerrmsg,
54: 'CSM_MTL_SEC_INV_EVENT_PKG.insert_mtl_sec_inventory', FND_LOG.LEVEL_EXCEPTION);
55:
56: END insert_mtl_sec_inventory;
57:
58: PROCEDURE update_mtl_sec_inventory( p_user_id NUMBER

Line 67: CSM_UTIL_PKG.LOG('Entering CSM_MTL_SEC_INV_EVENT_PKG.update_mtl_sec_inventory ',

63: l_sqlerrmsg varchar2(2000);
64: l_access_id number;
65:
66: BEGIN
67: CSM_UTIL_PKG.LOG('Entering CSM_MTL_SEC_INV_EVENT_PKG.update_mtl_sec_inventory ',
68: 'CSM_MTL_SEC_INV_EVENT_PKG.update_mtl_sec_inventory',FND_LOG.LEVEL_PROCEDURE);
69:
70: l_access_id := CSM_ACC_PKG.Get_Acc_Id
71: ( P_ACC_TABLE_NAME => g_acc_table_name1

Line 68: 'CSM_MTL_SEC_INV_EVENT_PKG.update_mtl_sec_inventory',FND_LOG.LEVEL_PROCEDURE);

64: l_access_id number;
65:
66: BEGIN
67: CSM_UTIL_PKG.LOG('Entering CSM_MTL_SEC_INV_EVENT_PKG.update_mtl_sec_inventory ',
68: 'CSM_MTL_SEC_INV_EVENT_PKG.update_mtl_sec_inventory',FND_LOG.LEVEL_PROCEDURE);
69:
70: l_access_id := CSM_ACC_PKG.Get_Acc_Id
71: ( P_ACC_TABLE_NAME => g_acc_table_name1
72: ,P_PK1_NAME => g_pk1_name1

Line 86: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_SEC_INV_EVENT_PKG.update_mtl_sec_inventory ',

82: ,P_ACCESS_ID => l_access_id
83: ,P_USER_ID => p_user_id
84: );
85:
86: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_SEC_INV_EVENT_PKG.update_mtl_sec_inventory ',
87: 'CSM_MTL_SEC_INV_EVENT_PKG.update_mtl_sec_inventory',FND_LOG.LEVEL_PROCEDURE);
88:
89: EXCEPTION
90: WHEN others THEN

Line 87: 'CSM_MTL_SEC_INV_EVENT_PKG.update_mtl_sec_inventory',FND_LOG.LEVEL_PROCEDURE);

83: ,P_USER_ID => p_user_id
84: );
85:
86: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_SEC_INV_EVENT_PKG.update_mtl_sec_inventory ',
87: 'CSM_MTL_SEC_INV_EVENT_PKG.update_mtl_sec_inventory',FND_LOG.LEVEL_PROCEDURE);
88:
89: EXCEPTION
90: WHEN others THEN
91: l_sqlerrno := to_char(SQLCODE);

Line 93: CSM_UTIL_PKG.LOG('Exception in CSM_MTL_SEC_INV_EVENT_PKG.update_mtl_sec_inventory: ' || l_sqlerrno || ':' || l_sqlerrmsg,

89: EXCEPTION
90: WHEN others THEN
91: l_sqlerrno := to_char(SQLCODE);
92: l_sqlerrmsg := substr(SQLERRM, 1,2000);
93: CSM_UTIL_PKG.LOG('Exception in CSM_MTL_SEC_INV_EVENT_PKG.update_mtl_sec_inventory: ' || l_sqlerrno || ':' || l_sqlerrmsg,
94: 'CSM_MTL_SEC_INV_EVENT_PKG.update_mtl_sec_inventory', FND_LOG.LEVEL_EXCEPTION);
95:
96: END update_mtl_sec_inventory;
97:

Line 94: 'CSM_MTL_SEC_INV_EVENT_PKG.update_mtl_sec_inventory', FND_LOG.LEVEL_EXCEPTION);

90: WHEN others THEN
91: l_sqlerrno := to_char(SQLCODE);
92: l_sqlerrmsg := substr(SQLERRM, 1,2000);
93: CSM_UTIL_PKG.LOG('Exception in CSM_MTL_SEC_INV_EVENT_PKG.update_mtl_sec_inventory: ' || l_sqlerrno || ':' || l_sqlerrmsg,
94: 'CSM_MTL_SEC_INV_EVENT_PKG.update_mtl_sec_inventory', FND_LOG.LEVEL_EXCEPTION);
95:
96: END update_mtl_sec_inventory;
97:
98: PROCEDURE delete_mtl_sec_inventory( p_user_id NUMBER

Line 106: CSM_UTIL_PKG.LOG('Entering CSM_MTL_SEC_INV_EVENT_PKG.delete_mtl_sec_inventory ',

102: l_sqlerrno varchar2(20);
103: l_sqlerrmsg varchar2(2000);
104:
105: BEGIN
106: CSM_UTIL_PKG.LOG('Entering CSM_MTL_SEC_INV_EVENT_PKG.delete_mtl_sec_inventory ',
107: 'CSM_MTL_SEC_INV_EVENT_PKG.delete_mtl_sec_inventory',FND_LOG.LEVEL_PROCEDURE);
108:
109: CSM_ACC_PKG.Delete_Acc
110: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1

Line 107: 'CSM_MTL_SEC_INV_EVENT_PKG.delete_mtl_sec_inventory',FND_LOG.LEVEL_PROCEDURE);

103: l_sqlerrmsg varchar2(2000);
104:
105: BEGIN
106: CSM_UTIL_PKG.LOG('Entering CSM_MTL_SEC_INV_EVENT_PKG.delete_mtl_sec_inventory ',
107: 'CSM_MTL_SEC_INV_EVENT_PKG.delete_mtl_sec_inventory',FND_LOG.LEVEL_PROCEDURE);
108:
109: CSM_ACC_PKG.Delete_Acc
110: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
111: ,P_ACC_TABLE_NAME => g_acc_table_name1

Line 119: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_SEC_INV_EVENT_PKG.delete_mtl_sec_inventory ',

115: ,P_PK2_NUM_VALUE => p_organization_id
116: ,P_USER_ID => p_user_id
117: );
118:
119: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_SEC_INV_EVENT_PKG.delete_mtl_sec_inventory ',
120: 'CSM_MTL_SEC_INV_EVENT_PKG.delete_mtl_sec_inventory',FND_LOG.LEVEL_PROCEDURE);
121:
122: EXCEPTION
123: WHEN others THEN

Line 120: 'CSM_MTL_SEC_INV_EVENT_PKG.delete_mtl_sec_inventory',FND_LOG.LEVEL_PROCEDURE);

116: ,P_USER_ID => p_user_id
117: );
118:
119: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_SEC_INV_EVENT_PKG.delete_mtl_sec_inventory ',
120: 'CSM_MTL_SEC_INV_EVENT_PKG.delete_mtl_sec_inventory',FND_LOG.LEVEL_PROCEDURE);
121:
122: EXCEPTION
123: WHEN others THEN
124: l_sqlerrno := to_char(SQLCODE);

Line 126: CSM_UTIL_PKG.LOG('Exception in CSM_MTL_SEC_INV_EVENT_PKG.delete_mtl_sec_inventory: ' || l_sqlerrno || ':' || l_sqlerrmsg,

122: EXCEPTION
123: WHEN others THEN
124: l_sqlerrno := to_char(SQLCODE);
125: l_sqlerrmsg := substr(SQLERRM, 1,2000);
126: CSM_UTIL_PKG.LOG('Exception in CSM_MTL_SEC_INV_EVENT_PKG.delete_mtl_sec_inventory: ' || l_sqlerrno || ':' || l_sqlerrmsg,
127: 'CSM_MTL_SEC_INV_EVENT_PKG.delete_mtl_sec_inventory', FND_LOG.LEVEL_EXCEPTION);
128:
129: END delete_mtl_sec_inventory;
130:

Line 127: 'CSM_MTL_SEC_INV_EVENT_PKG.delete_mtl_sec_inventory', FND_LOG.LEVEL_EXCEPTION);

123: WHEN others THEN
124: l_sqlerrno := to_char(SQLCODE);
125: l_sqlerrmsg := substr(SQLERRM, 1,2000);
126: CSM_UTIL_PKG.LOG('Exception in CSM_MTL_SEC_INV_EVENT_PKG.delete_mtl_sec_inventory: ' || l_sqlerrno || ':' || l_sqlerrmsg,
127: 'CSM_MTL_SEC_INV_EVENT_PKG.delete_mtl_sec_inventory', FND_LOG.LEVEL_EXCEPTION);
128:
129: END delete_mtl_sec_inventory;
130:
131: PROCEDURE refresh_acc(p_status OUT NOCOPY VARCHAR2,

Line 145: WHERE package_name = 'CSM_MTL_SEC_INV_EVENT_PKG'

141: CURSOR l_last_run_date_csr
142: IS
143: SELECT nvl(last_run_date, (sysdate - 365*50))
144: FROM jtm_con_request_data
145: WHERE package_name = 'CSM_MTL_SEC_INV_EVENT_PKG'
146: AND procedure_name = 'REFRESH_ACC';
147:
148: CURSOR l_upd_mtl_sec_inv_csr(p_last_upd_date IN date)
149: IS

Line 158: CSM_UTIL_PKG.LOG('Entering CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc ',

154: AND msi.organization_id = acc.organization_id
155: AND msi.last_update_date >= p_last_upd_date;
156:
157: BEGIN
158: CSM_UTIL_PKG.LOG('Entering CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc ',
159: 'CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_PROCEDURE);
160:
161: -- data program is run
162: l_run_date := SYSDATE;

Line 159: 'CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_PROCEDURE);

155: AND msi.last_update_date >= p_last_upd_date;
156:
157: BEGIN
158: CSM_UTIL_PKG.LOG('Entering CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc ',
159: 'CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_PROCEDURE);
160:
161: -- data program is run
162: l_run_date := SYSDATE;
163:

Line 181: WHERE package_name = 'CSM_MTL_SEC_INV_EVENT_PKG'

177:
178: -- set the program update date in jtm_con_request_data to sysdate
179: UPDATE jtm_con_request_data
180: SET last_run_date = l_run_date
181: WHERE package_name = 'CSM_MTL_SEC_INV_EVENT_PKG'
182: AND procedure_name = 'REFRESH_ACC';
183:
184: COMMIT;
185:

Line 187: p_message := 'CSM_MTL_SEC_INV_EVENT_PKG.Refresh_Acc Executed successfully';

183:
184: COMMIT;
185:
186: p_status := 'FINE';
187: p_message := 'CSM_MTL_SEC_INV_EVENT_PKG.Refresh_Acc Executed successfully';
188:
189: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc ',
190: 'CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_PROCEDURE);
191:

Line 189: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc ',

185:
186: p_status := 'FINE';
187: p_message := 'CSM_MTL_SEC_INV_EVENT_PKG.Refresh_Acc Executed successfully';
188:
189: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc ',
190: 'CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_PROCEDURE);
191:
192: EXCEPTION
193: WHEN others THEN

Line 190: 'CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_PROCEDURE);

186: p_status := 'FINE';
187: p_message := 'CSM_MTL_SEC_INV_EVENT_PKG.Refresh_Acc Executed successfully';
188:
189: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc ',
190: 'CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_PROCEDURE);
191:
192: EXCEPTION
193: WHEN others THEN
194: l_sqlerrno := to_char(SQLCODE);

Line 197: p_message := 'Error in CSM_MTL_SEC_INV_EVENT_PKG.Refresh_Acc:' || l_sqlerrno || ':' || l_sqlerrmsg;

193: WHEN others THEN
194: l_sqlerrno := to_char(SQLCODE);
195: l_sqlerrmsg := substr(SQLERRM, 1,2000);
196: p_status := 'ERROR';
197: p_message := 'Error in CSM_MTL_SEC_INV_EVENT_PKG.Refresh_Acc:' || l_sqlerrno || ':' || l_sqlerrmsg;
198: ROLLBACK;
199: CSM_UTIL_PKG.LOG('Exception in CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc: ' || l_sqlerrno || ':' || l_sqlerrmsg,
200: 'CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EXCEPTION);
201: END refresh_acc;

Line 199: CSM_UTIL_PKG.LOG('Exception in CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc: ' || l_sqlerrno || ':' || l_sqlerrmsg,

195: l_sqlerrmsg := substr(SQLERRM, 1,2000);
196: p_status := 'ERROR';
197: p_message := 'Error in CSM_MTL_SEC_INV_EVENT_PKG.Refresh_Acc:' || l_sqlerrno || ':' || l_sqlerrmsg;
198: ROLLBACK;
199: CSM_UTIL_PKG.LOG('Exception in CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc: ' || l_sqlerrno || ':' || l_sqlerrmsg,
200: 'CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EXCEPTION);
201: END refresh_acc;
202:
203: END CSM_MTL_SEC_INV_EVENT_PKG;

Line 200: 'CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EXCEPTION);

196: p_status := 'ERROR';
197: p_message := 'Error in CSM_MTL_SEC_INV_EVENT_PKG.Refresh_Acc:' || l_sqlerrno || ':' || l_sqlerrmsg;
198: ROLLBACK;
199: CSM_UTIL_PKG.LOG('Exception in CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc: ' || l_sqlerrno || ':' || l_sqlerrmsg,
200: 'CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EXCEPTION);
201: END refresh_acc;
202:
203: END CSM_MTL_SEC_INV_EVENT_PKG;

Line 203: END CSM_MTL_SEC_INV_EVENT_PKG;

199: CSM_UTIL_PKG.LOG('Exception in CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc: ' || l_sqlerrno || ':' || l_sqlerrmsg,
200: 'CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EXCEPTION);
201: END refresh_acc;
202:
203: END CSM_MTL_SEC_INV_EVENT_PKG;