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_SYSTEM_ITEM_EVENT_PKG dependencies on CSM_SYSTEM_ITEM_EVENT_PKG

Line 1: PACKAGE BODY CSM_SYSTEM_ITEM_EVENT_PKG AS

1: PACKAGE BODY CSM_SYSTEM_ITEM_EVENT_PKG AS
2: /* $Header: csmemsib.pls 120.10.12020000.2 2013/04/09 10:56:26 saradhak ship $ */
3:
4: -- To modify this template, edit file PKGBODY.TXT in TEMPLATE
5: -- directory of SQL Navigator

Line 47: 'CSM_SYSTEM_ITEM_EVENT_PKG.DELETE_SYSTEM_ITEMS',FND_LOG.LEVEL_PROCEDURE);

43: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
44:
45: BEGIN
46: CSM_UTIL_PKG.LOG('Entering DELETE_SYSTEM_ITEMS ',
47: 'CSM_SYSTEM_ITEM_EVENT_PKG.DELETE_SYSTEM_ITEMS',FND_LOG.LEVEL_PROCEDURE);
48:
49: l_run_date := SYSDATE;
50:
51: l_tab_access_id.DELETE;

Line 86: 'CSM_SYSTEM_ITEM_EVENT_PKG.DELETE_SYSTEM_ITEMS',FND_LOG.LEVEL_PROCEDURE);

82: DELETE FROM csm_system_items_acc WHERE access_id = l_tab_access_id(i);
83: END IF;
84:
85: CSM_UTIL_PKG.LOG('Leaving DELETE_SYSTEM_ITEMS ',
86: 'CSM_SYSTEM_ITEM_EVENT_PKG.DELETE_SYSTEM_ITEMS',FND_LOG.LEVEL_PROCEDURE);
87: EXCEPTION
88: WHEN others THEN
89: l_sqlerrno := TO_CHAR(SQLCODE);
90: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);

Line 92: 'csm_system_item_event_pkg.delete_system_items',FND_LOG.LEVEL_EXCEPTION);

88: WHEN others THEN
89: l_sqlerrno := TO_CHAR(SQLCODE);
90: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
91: CSM_UTIL_PKG.LOG('Exception in delete_system_items: ' || l_sqlerrno || ':' || l_sqlerrmsg,
92: 'csm_system_item_event_pkg.delete_system_items',FND_LOG.LEVEL_EXCEPTION);
93: RAISE;
94: END delete_system_items;
95:
96: /*

Line 124: CSM_UTIL_PKG.LOG('Entering CSM_SYSTEM_ITEM_EVENT_PKG.PURGE_SYSTEM_ITEMS ',

120: l_organization_id mtl_system_items.organization_id%TYPE;
121: l_userid NUMBER;
122:
123: BEGIN
124: CSM_UTIL_PKG.LOG('Entering CSM_SYSTEM_ITEM_EVENT_PKG.PURGE_SYSTEM_ITEMS ',
125: 'CSM_SYSTEM_ITEM_EVENT_PKG.PURGE_SYSTEM_ITEMS',FND_LOG.LEVEL_PROCEDURE);
126:
127: g_pub_item := 'CSF_M_SYSTEM_ITEMS';
128: l_current_run_date := SYSDATE;

Line 125: 'CSM_SYSTEM_ITEM_EVENT_PKG.PURGE_SYSTEM_ITEMS',FND_LOG.LEVEL_PROCEDURE);

121: l_userid NUMBER;
122:
123: BEGIN
124: CSM_UTIL_PKG.LOG('Entering CSM_SYSTEM_ITEM_EVENT_PKG.PURGE_SYSTEM_ITEMS ',
125: 'CSM_SYSTEM_ITEM_EVENT_PKG.PURGE_SYSTEM_ITEMS',FND_LOG.LEVEL_PROCEDURE);
126:
127: g_pub_item := 'CSF_M_SYSTEM_ITEMS';
128: l_current_run_date := SYSDATE;
129:

Line 176: CSM_UTIL_PKG.LOG('Leaving CSM_SYSTEM_ITEM_EVENT_PKG.PURGE_SYSTEM_ITEMS ',

172: END IF;
173:
174: END IF;
175:
176: CSM_UTIL_PKG.LOG('Leaving CSM_SYSTEM_ITEM_EVENT_PKG.PURGE_SYSTEM_ITEMS ',
177: 'CSM_SYSTEM_ITEM_EVENT_PKG.PURGE_SYSTEM_ITEMS',FND_LOG.LEVEL_PROCEDURE);
178:
179: EXCEPTION
180: WHEN OTHERS THEN

Line 177: 'CSM_SYSTEM_ITEM_EVENT_PKG.PURGE_SYSTEM_ITEMS',FND_LOG.LEVEL_PROCEDURE);

173:
174: END IF;
175:
176: CSM_UTIL_PKG.LOG('Leaving CSM_SYSTEM_ITEM_EVENT_PKG.PURGE_SYSTEM_ITEMS ',
177: 'CSM_SYSTEM_ITEM_EVENT_PKG.PURGE_SYSTEM_ITEMS',FND_LOG.LEVEL_PROCEDURE);
178:
179: EXCEPTION
180: WHEN OTHERS THEN
181: --logm('ErrorLog' || substr(SQLERRM, 1, 250));

Line 183: CSM_UTIL_PKG.LOG(x_result,'CSM_SYSTEM_ITEM_EVENT_PKG.PURGE_SYSTEM_ITEMS',FND_LOG.LEVEL_EXCEPTION);

179: EXCEPTION
180: WHEN OTHERS THEN
181: --logm('ErrorLog' || substr(SQLERRM, 1, 250));
182: x_result := ' FAILED PURGE_SYSTEM_ITEMS old_OrganizationId: ' || to_char(l_old_organization_id);
183: CSM_UTIL_PKG.LOG(x_result,'CSM_SYSTEM_ITEM_EVENT_PKG.PURGE_SYSTEM_ITEMS',FND_LOG.LEVEL_EXCEPTION);
184: wf_core.context('CSM_SYSTEM_ITEM_EVENT_PKG', 'PURGE_SYSTEM_ITEMS', p_itemtype, p_itemkey, to_char(p_actid),
185: 'Organization ID: ' || to_char(l_old_organization_id), p_funcmode);
186: RAISE;
187:

Line 184: wf_core.context('CSM_SYSTEM_ITEM_EVENT_PKG', 'PURGE_SYSTEM_ITEMS', p_itemtype, p_itemkey, to_char(p_actid),

180: WHEN OTHERS THEN
181: --logm('ErrorLog' || substr(SQLERRM, 1, 250));
182: x_result := ' FAILED PURGE_SYSTEM_ITEMS old_OrganizationId: ' || to_char(l_old_organization_id);
183: CSM_UTIL_PKG.LOG(x_result,'CSM_SYSTEM_ITEM_EVENT_PKG.PURGE_SYSTEM_ITEMS',FND_LOG.LEVEL_EXCEPTION);
184: wf_core.context('CSM_SYSTEM_ITEM_EVENT_PKG', 'PURGE_SYSTEM_ITEMS', p_itemtype, p_itemkey, to_char(p_actid),
185: 'Organization ID: ' || to_char(l_old_organization_id), p_funcmode);
186: RAISE;
187:
188: END PURGE_SYSTEM_ITEMS;

Line 242: CSM_UTIL_PKG.LOG('Entering CSM_SYSTEM_ITEM_EVENT_PKG.GET_NEW_SYSTEM_ITEMS ',

238: l_organization_id mtl_system_items.organization_id%TYPE;
239: l_user_id NUMBER;
240:
241: BEGIN
242: CSM_UTIL_PKG.LOG('Entering CSM_SYSTEM_ITEM_EVENT_PKG.GET_NEW_SYSTEM_ITEMS ',
243: 'CSM_SYSTEM_ITEM_EVENT_PKG.GET_NEW_SYSTEM_ITEMS',FND_LOG.LEVEL_PROCEDURE);
244:
245: g_pub_item := 'CSF_M_SYSTEM_ITEMS';
246: l_current_run_date := SYSDATE;

Line 243: 'CSM_SYSTEM_ITEM_EVENT_PKG.GET_NEW_SYSTEM_ITEMS',FND_LOG.LEVEL_PROCEDURE);

239: l_user_id NUMBER;
240:
241: BEGIN
242: CSM_UTIL_PKG.LOG('Entering CSM_SYSTEM_ITEM_EVENT_PKG.GET_NEW_SYSTEM_ITEMS ',
243: 'CSM_SYSTEM_ITEM_EVENT_PKG.GET_NEW_SYSTEM_ITEMS',FND_LOG.LEVEL_PROCEDURE);
244:
245: g_pub_item := 'CSF_M_SYSTEM_ITEMS';
246: l_current_run_date := SYSDATE;
247:

Line 307: CSM_UTIL_PKG.LOG('Leaving CSM_SYSTEM_ITEM_EVENT_PKG.GET_NEW_SYSTEM_ITEMS ',

303: END IF;
304:
305: END IF;
306:
307: CSM_UTIL_PKG.LOG('Leaving CSM_SYSTEM_ITEM_EVENT_PKG.GET_NEW_SYSTEM_ITEMS ',
308: 'CSM_SYSTEM_ITEM_EVENT_PKG.GET_NEW_SYSTEM_ITEMS',FND_LOG.LEVEL_PROCEDURE);
309:
310: EXCEPTION
311: WHEN OTHERS THEN

Line 308: 'CSM_SYSTEM_ITEM_EVENT_PKG.GET_NEW_SYSTEM_ITEMS',FND_LOG.LEVEL_PROCEDURE);

304:
305: END IF;
306:
307: CSM_UTIL_PKG.LOG('Leaving CSM_SYSTEM_ITEM_EVENT_PKG.GET_NEW_SYSTEM_ITEMS ',
308: 'CSM_SYSTEM_ITEM_EVENT_PKG.GET_NEW_SYSTEM_ITEMS',FND_LOG.LEVEL_PROCEDURE);
309:
310: EXCEPTION
311: WHEN OTHERS THEN
312: x_result := ' FAILED GET_NEW_SYSTEM_ITEMS OrganizationId: ' || to_char(l_organization_id);

Line 313: CSM_UTIL_PKG.LOG(x_result, 'CSM_SYSTEM_ITEM_EVENT_PKG.GET_NEW_SYSTEM_ITEMS',FND_LOG.LEVEL_EXCEPTION);

309:
310: EXCEPTION
311: WHEN OTHERS THEN
312: x_result := ' FAILED GET_NEW_SYSTEM_ITEMS OrganizationId: ' || to_char(l_organization_id);
313: CSM_UTIL_PKG.LOG(x_result, 'CSM_SYSTEM_ITEM_EVENT_PKG.GET_NEW_SYSTEM_ITEMS',FND_LOG.LEVEL_EXCEPTION);
314: wf_core.context('CSM_SYSTEM_ITEM_EVENT_PKG', 'GET_NEW_SYSTEM_ITEMS', p_itemtype, p_itemkey, to_char(p_actid),
315: 'Organization ID: ' || to_char(l_organization_id), p_funcmode);
316: RAISE;
317:

Line 314: wf_core.context('CSM_SYSTEM_ITEM_EVENT_PKG', 'GET_NEW_SYSTEM_ITEMS', p_itemtype, p_itemkey, to_char(p_actid),

310: EXCEPTION
311: WHEN OTHERS THEN
312: x_result := ' FAILED GET_NEW_SYSTEM_ITEMS OrganizationId: ' || to_char(l_organization_id);
313: CSM_UTIL_PKG.LOG(x_result, 'CSM_SYSTEM_ITEM_EVENT_PKG.GET_NEW_SYSTEM_ITEMS',FND_LOG.LEVEL_EXCEPTION);
314: wf_core.context('CSM_SYSTEM_ITEM_EVENT_PKG', 'GET_NEW_SYSTEM_ITEMS', p_itemtype, p_itemkey, to_char(p_actid),
315: 'Organization ID: ' || to_char(l_organization_id), p_funcmode);
316: RAISE;
317:
318: END GET_NEW_SYSTEM_ITEMS;

Line 350: WHERE package_name = 'CSM_SYSTEM_ITEM_EVENT_PKG'

346: CURSOR l_last_run_date_csr
347: IS
348: SELECT nvl(last_run_date, (sysdate - 365*50))
349: FROM jtm_con_request_data
350: WHERE package_name = 'CSM_SYSTEM_ITEM_EVENT_PKG'
351: AND procedure_name = 'REFRESH_ACC';
352:
353: CURSOR c_max_last_upd_date_b
354: IS

Line 534: p_message := 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_SYSTEM_ITEMS Executed successfully - No updates';

530:
531: IF l_max_last_update_date_tl < l_last_run_date THEN
532: -- no updates
533: p_status := 'FINE';
534: p_message := 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_SYSTEM_ITEMS Executed successfully - No updates';
535: csm_util_pkg.log('No updates for csm_system_items_event_new_pkg', 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_SYSTEM_ITEMS ');
536:
537: -- set the program update date in jtm_con_request_data to sysdate
538: UPDATE jtm_con_request_data

Line 535: csm_util_pkg.log('No updates for csm_system_items_event_new_pkg', 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_SYSTEM_ITEMS ');

531: IF l_max_last_update_date_tl < l_last_run_date THEN
532: -- no updates
533: p_status := 'FINE';
534: p_message := 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_SYSTEM_ITEMS Executed successfully - No updates';
535: csm_util_pkg.log('No updates for csm_system_items_event_new_pkg', 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_SYSTEM_ITEMS ');
536:
537: -- set the program update date in jtm_con_request_data to sysdate
538: UPDATE jtm_con_request_data
539: SET last_run_date = l_current_run_date

Line 540: WHERE package_name = 'CSM_SYSTEM_ITEM_EVENT_PKG'

536:
537: -- set the program update date in jtm_con_request_data to sysdate
538: UPDATE jtm_con_request_data
539: SET last_run_date = l_current_run_date
540: WHERE package_name = 'CSM_SYSTEM_ITEM_EVENT_PKG'
541: AND procedure_name = 'REFRESH_ACC';
542:
543: COMMIT;
544:

Line 686: WHERE package_name = 'CSM_SYSTEM_ITEM_EVENT_PKG'

682: END IF;
683: -- set the program update date in jtm_con_request_data to sysdate
684: UPDATE jtm_con_request_data
685: SET last_run_date = l_current_run_date
686: WHERE package_name = 'CSM_SYSTEM_ITEM_EVENT_PKG'
687: AND procedure_name = 'REFRESH_ACC';
688:
689: COMMIT;
690:

Line 692: p_message := 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_SYSTEM_ITEMS Executed successfully';

688:
689: COMMIT;
690:
691: p_status := 'FINE';
692: p_message := 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_SYSTEM_ITEMS Executed successfully';
693:
694: EXCEPTION
695: WHEN others THEN
696: l_sqlerrno := to_char(SQLCODE);

Line 699: p_message := 'Error in CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_SYSTEM_ITEMS: ' || l_sqlerrno || ':' || l_sqlerrmsg;

695: WHEN others THEN
696: l_sqlerrno := to_char(SQLCODE);
697: l_sqlerrmsg := substr(SQLERRM, 1,2000);
698: p_status := 'ERROR';
699: p_message := 'Error in CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_SYSTEM_ITEMS: ' || l_sqlerrno || ':' || l_sqlerrmsg;
700: ROLLBACK;
701: csm_util_pkg.log('CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_SYSTEM_ITEMS ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);
702: END Refresh_Acc;
703:

Line 701: csm_util_pkg.log('CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_SYSTEM_ITEMS ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);

697: l_sqlerrmsg := substr(SQLERRM, 1,2000);
698: p_status := 'ERROR';
699: p_message := 'Error in CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_SYSTEM_ITEMS: ' || l_sqlerrno || ':' || l_sqlerrmsg;
700: ROLLBACK;
701: csm_util_pkg.log('CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_SYSTEM_ITEMS ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);
702: END Refresh_Acc;
703:
704: /* concurrent program that refreshes inventory */
705: PROCEDURE Refresh_mtl_onhand_quantity(p_status OUT NOCOPY VARCHAR2,

Line 860: CSM_UTIL_PKG.LOG('Entering CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY ',

856: l_dml_tab user_idTab;
857: l_cnt NUMBER :=0;
858:
859: BEGIN
860: CSM_UTIL_PKG.LOG('Entering CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY ',
861: 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY',FND_LOG.LEVEL_PROCEDURE);
862:
863: l_current_run_date := SYSDATE;
864:

Line 861: 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY',FND_LOG.LEVEL_PROCEDURE);

857: l_cnt NUMBER :=0;
858:
859: BEGIN
860: CSM_UTIL_PKG.LOG('Entering CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY ',
861: 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY',FND_LOG.LEVEL_PROCEDURE);
862:
863: l_current_run_date := SYSDATE;
864:
865: --*** Push deleted records to client ***

Line 905: 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY',FND_LOG.LEVEL_STATEMENT);

901: EXIT WHEN acc_id_lst.COUNT = 0;
902:
903: IF acc_id_lst.COUNT > 0 THEN
904: CSM_UTIL_PKG.LOG('Pushing ' || acc_id_lst.COUNT || 'deleted records',
905: 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY',FND_LOG.LEVEL_STATEMENT);
906:
907: -- do bulk makedirty
908: l_dummy := asg_download.mark_dirty(
909: P_PUB_ITEM => g_pub_item

Line 970: 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY',FND_LOG.LEVEL_STATEMENT);

966:
967: IF user_id_lst.COUNT > 0 THEN
968: --*** push to oLite using asg_download ***
969: CSM_UTIL_PKG.LOG('Pushing ' || user_id_lst.COUNT || 'updated records',
970: 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY',FND_LOG.LEVEL_STATEMENT);
971:
972: FORALL i IN user_id_lst.FIRST..user_id_lst.LAST
973: UPDATE CSM_MTL_ONHAND_QTY_ACC
974: SET LAST_UPDATE_DATE = l_current_run_date,

Line 1048: 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY',FND_LOG.LEVEL_STATEMENT);

1044: -- check if there are any items to be downloaded
1045: IF inv_id.COUNT > 0 THEN
1046: --*** push to oLite using asg_download ***
1047: CSM_UTIL_PKG.LOG('Pushing ' || inv_id.COUNT || 'inserted records',
1048: 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY',FND_LOG.LEVEL_STATEMENT);
1049:
1050: FOR i IN inv_id.FIRST..inv_id.LAST LOOP
1051: SELECT csm_mtl_onhand_qty_acc_s.NEXTVAL INTO acc_id_lst(i) FROM dual;
1052: END LOOP;

Line 1088: AND package_name = 'CSM_SYSTEM_ITEM_EVENT_PKG'

1084: -- set the program update date in jtm_con_request_data to sysdate
1085: UPDATE jtm_con_request_data
1086: SET last_run_date = l_current_run_date
1087: WHERE product_code = 'CSM'
1088: AND package_name = 'CSM_SYSTEM_ITEM_EVENT_PKG'
1089: AND procedure_name = 'REFRESH_MTL_ONHAND_QUANTITY';
1090:
1091: -- Notify User of inventory update
1092: FOR i IN 1..l_pk_tab.COUNT

Line 1102: CSM_UTIL_PKG.LOG('Leaving CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY ',

1098: END IF;
1099: END LOOP;
1100:
1101:
1102: CSM_UTIL_PKG.LOG('Leaving CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY ',
1103: 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY',FND_LOG.LEVEL_PROCEDURE);
1104:
1105: p_status := 'FINE';
1106: p_message := 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY Executed successfully';

Line 1103: 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY',FND_LOG.LEVEL_PROCEDURE);

1099: END LOOP;
1100:
1101:
1102: CSM_UTIL_PKG.LOG('Leaving CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY ',
1103: 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY',FND_LOG.LEVEL_PROCEDURE);
1104:
1105: p_status := 'FINE';
1106: p_message := 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY Executed successfully';
1107:

Line 1106: p_message := 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY Executed successfully';

1102: CSM_UTIL_PKG.LOG('Leaving CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY ',
1103: 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY',FND_LOG.LEVEL_PROCEDURE);
1104:
1105: p_status := 'FINE';
1106: p_message := 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY Executed successfully';
1107:
1108: COMMIT;
1109:
1110: EXCEPTION

Line 1115: p_message := 'Error in CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY: ' || l_sqlerrno || ':' || l_sqlerrmsg;

1111: WHEN others THEN
1112: l_sqlerrno := to_char(SQLCODE);
1113: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1114: p_status := 'ERROR';
1115: p_message := 'Error in CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY: ' || l_sqlerrno || ':' || l_sqlerrmsg;
1116: ROLLBACK;
1117: csm_util_pkg.log('CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);
1118:
1119: END Refresh_mtl_onhand_quantity;

Line 1117: csm_util_pkg.log('CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);

1113: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1114: p_status := 'ERROR';
1115: p_message := 'Error in CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY: ' || l_sqlerrno || ':' || l_sqlerrmsg;
1116: ROLLBACK;
1117: csm_util_pkg.log('CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);
1118:
1119: END Refresh_mtl_onhand_quantity;
1120:
1121: PROCEDURE get_new_user_system_items(p_user_id IN NUMBER)

Line 1193: CSM_UTIL_PKG.LOG('Entering CSM_SYSTEM_ITEM_EVENT_PKG.get_new_user_system_items ',

1189: l_organization_id mtl_system_items.organization_id%TYPE;
1190: l_count NUMBER;
1191:
1192: BEGIN
1193: CSM_UTIL_PKG.LOG('Entering CSM_SYSTEM_ITEM_EVENT_PKG.get_new_user_system_items ',
1194: 'CSM_SYSTEM_ITEM_EVENT_PKG.get_new_user_system_items',FND_LOG.LEVEL_PROCEDURE);
1195:
1196: g_pub_item := 'CSF_M_SYSTEM_ITEMS';
1197: l_current_run_date := SYSDATE;

Line 1194: 'CSM_SYSTEM_ITEM_EVENT_PKG.get_new_user_system_items',FND_LOG.LEVEL_PROCEDURE);

1190: l_count NUMBER;
1191:
1192: BEGIN
1193: CSM_UTIL_PKG.LOG('Entering CSM_SYSTEM_ITEM_EVENT_PKG.get_new_user_system_items ',
1194: 'CSM_SYSTEM_ITEM_EVENT_PKG.get_new_user_system_items',FND_LOG.LEVEL_PROCEDURE);
1195:
1196: g_pub_item := 'CSF_M_SYSTEM_ITEMS';
1197: l_current_run_date := SYSDATE;
1198: l_organization_id := csm_profile_pkg.get_organization_id(p_user_id);

Line 1208: 'CSM_SYSTEM_ITEM_EVENT_PKG.get_new_user_system_items',FND_LOG.LEVEL_PROCEDURE);

1204: CLOSE l_prev_user_csr;
1205:
1206: IF l_user_id IS NOT NULL THEN
1207: CSM_UTIL_PKG.LOG(' Found MFS user created with organization_id: ' || l_organization_id,
1208: 'CSM_SYSTEM_ITEM_EVENT_PKG.get_new_user_system_items',FND_LOG.LEVEL_PROCEDURE);
1209:
1210: IF l_acc_id_lst.COUNT > 0 THEN
1211: l_acc_id_lst.DELETE;
1212: END IF;

Line 1252: 'CSM_SYSTEM_ITEM_EVENT_PKG.get_new_user_system_items',FND_LOG.LEVEL_PROCEDURE);

1248: CLOSE l_systemitems_ins_acc_csr;
1249: ELSE
1250: -- process inserts
1251: CSM_UTIL_PKG.LOG(' First user with organization_id: ' || l_organization_id,
1252: 'CSM_SYSTEM_ITEM_EVENT_PKG.get_new_user_system_items',FND_LOG.LEVEL_PROCEDURE);
1253:
1254: OPEN l_systemitems_ins_csr (p_organization_id=>l_organization_id, p_user_id=>p_user_id);
1255: LOOP
1256: IF l_acc_id_lst.COUNT > 0 THEN

Line 1291: CSM_UTIL_PKG.LOG('Leaving CSM_SYSTEM_ITEM_EVENT_PKG.get_new_user_system_items ',

1287: END LOOP;
1288: CLOSE l_systemitems_ins_csr;
1289: END IF;
1290:
1291: CSM_UTIL_PKG.LOG('Leaving CSM_SYSTEM_ITEM_EVENT_PKG.get_new_user_system_items ',
1292: 'CSM_SYSTEM_ITEM_EVENT_PKG.get_new_user_system_items',FND_LOG.LEVEL_PROCEDURE);
1293:
1294: EXCEPTION
1295: WHEN others THEN

Line 1292: 'CSM_SYSTEM_ITEM_EVENT_PKG.get_new_user_system_items',FND_LOG.LEVEL_PROCEDURE);

1288: CLOSE l_systemitems_ins_csr;
1289: END IF;
1290:
1291: CSM_UTIL_PKG.LOG('Leaving CSM_SYSTEM_ITEM_EVENT_PKG.get_new_user_system_items ',
1292: 'CSM_SYSTEM_ITEM_EVENT_PKG.get_new_user_system_items',FND_LOG.LEVEL_PROCEDURE);
1293:
1294: EXCEPTION
1295: WHEN others THEN
1296: l_sqlerrno := to_char(SQLCODE);

Line 1298: csm_util_pkg.log('CSM_SYSTEM_ITEM_EVENT_PKG.get_new_user_system_items ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg, FND_LOG.LEVEL_EXCEPTION);

1294: EXCEPTION
1295: WHEN others THEN
1296: l_sqlerrno := to_char(SQLCODE);
1297: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1298: csm_util_pkg.log('CSM_SYSTEM_ITEM_EVENT_PKG.get_new_user_system_items ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg, FND_LOG.LEVEL_EXCEPTION);
1299: RAISE;
1300: END get_new_user_system_items;
1301:
1302: PROCEDURE SYSTEM_ITEM_MDIRTY_I(p_inventory_item_id IN NUMBER,

Line 1313: 'CSM_SYSTEM_ITEM_EVENT_PKG.SYSTEM_ITEM_MDIRTY_I',FND_LOG.LEVEL_PROCEDURE);

1309: l_return_status VARCHAR2(2000);
1310:
1311: BEGIN
1312: CSM_UTIL_PKG.LOG('Entering SYSTEM_ITEM_MDIRTY_I for inventory_item_id: ' || p_inventory_item_id,
1313: 'CSM_SYSTEM_ITEM_EVENT_PKG.SYSTEM_ITEM_MDIRTY_I',FND_LOG.LEVEL_PROCEDURE);
1314:
1315: IF p_inventory_item_id IS NOT NULL AND p_organization_id IS NOT NULL THEN
1316: -- insert into csm_system_items_acc
1317: CSM_ACC_PKG.Insert_Acc

Line 1330: 'CSM_SYSTEM_ITEM_EVENT_PKG.SYSTEM_ITEM_MDIRTY_I',FND_LOG.LEVEL_PROCEDURE);

1326: );
1327: END IF;
1328:
1329: CSM_UTIL_PKG.LOG('Leaving SYSTEM_ITEM_MDIRTY_I for inventory_item_id: ' || p_inventory_item_id,
1330: 'CSM_SYSTEM_ITEM_EVENT_PKG.SYSTEM_ITEM_MDIRTY_I',FND_LOG.LEVEL_PROCEDURE);
1331: EXCEPTION
1332: WHEN OTHERS THEN
1333: l_sqlerrno := to_char(SQLCODE);
1334: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 1337: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SYSTEM_ITEM_EVENT_PKG.SYSTEM_ITEM_MDIRTY_I',FND_LOG.LEVEL_EXCEPTION);

1333: l_sqlerrno := to_char(SQLCODE);
1334: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1335: l_error_msg := ' Exception in SYSTEM_ITEM_MDIRTY_I for inventory_item_id: ' || p_inventory_item_id
1336: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
1337: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SYSTEM_ITEM_EVENT_PKG.SYSTEM_ITEM_MDIRTY_I',FND_LOG.LEVEL_EXCEPTION);
1338: RAISE;
1339: END SYSTEM_ITEM_MDIRTY_I;
1340:
1341: PROCEDURE SYSTEM_ITEM_MDIRTY_D(p_inventory_item_id IN NUMBER,

Line 1352: 'CSM_SYSTEM_ITEM_EVENT_PKG.SYSTEM_ITEM_MDIRTY_D',FND_LOG.LEVEL_PROCEDURE);

1348: l_return_status VARCHAR2(2000);
1349:
1350: BEGIN
1351: CSM_UTIL_PKG.LOG('Entering SYSTEM_ITEM_MDIRTY_D for inventory_item_id: ' || p_inventory_item_id,
1352: 'CSM_SYSTEM_ITEM_EVENT_PKG.SYSTEM_ITEM_MDIRTY_D',FND_LOG.LEVEL_PROCEDURE);
1353:
1354: IF p_inventory_item_id IS NOT NULL AND p_organization_id IS NOT NULL THEN
1355: -- delete from csm_system_items_acc
1356: CSM_ACC_PKG.Delete_Acc

Line 1368: 'CSM_SYSTEM_ITEM_EVENT_PKG.SYSTEM_ITEM_MDIRTY_D',FND_LOG.LEVEL_PROCEDURE);

1364: );
1365: END IF;
1366:
1367: CSM_UTIL_PKG.LOG('Leaving SYSTEM_ITEM_MDIRTY_D for inventory_item_id: ' || p_inventory_item_id,
1368: 'CSM_SYSTEM_ITEM_EVENT_PKG.SYSTEM_ITEM_MDIRTY_D',FND_LOG.LEVEL_PROCEDURE);
1369: EXCEPTION
1370: WHEN OTHERS THEN
1371: l_sqlerrno := to_char(SQLCODE);
1372: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 1375: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SYSTEM_ITEM_EVENT_PKG.SYSTEM_ITEM_MDIRTY_D',FND_LOG.LEVEL_EXCEPTION);

1371: l_sqlerrno := to_char(SQLCODE);
1372: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1373: l_error_msg := ' Exception in SYSTEM_ITEM_MDIRTY_D for inventory_item_id: ' || p_inventory_item_id
1374: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
1375: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SYSTEM_ITEM_EVENT_PKG.SYSTEM_ITEM_MDIRTY_D',FND_LOG.LEVEL_EXCEPTION);
1376: RAISE;
1377: END SYSTEM_ITEM_MDIRTY_D;
1378:
1379: PROCEDURE RECEIVED_MTL_ONHAND(p_org_id IN NUMBER,p_subinv_code IN VARCHAR2,p_item_id IN NUMBER,p_user_id IN NUMBER)

Line 1506: CSM_UTIL_PKG.LOG('Entered RECEIVED_MTL_ONHAND', 'CSM_SYSTEM_ITEM_EVENT_PKG.RECEIVED_MTL_ONHAND',FND_LOG.LEVEL_STATEMENT);

1502: l_return_status VARCHAR2(100);
1503: l_err_msg VARCHAR2(4000);
1504:
1505: BEGIN
1506: CSM_UTIL_PKG.LOG('Entered RECEIVED_MTL_ONHAND', 'CSM_SYSTEM_ITEM_EVENT_PKG.RECEIVED_MTL_ONHAND',FND_LOG.LEVEL_STATEMENT);
1507:
1508: OPEN l_onhand_update_csr;
1509: FETCH l_onhand_update_csr BULK COLLECT INTO user_id_lst, inv_id, org_id, sub_code, loc_id, rvsion, lot_num, dummy_qty, qty;
1510: CLOSE l_onhand_update_csr;

Line 1515: 'CSM_SYSTEM_ITEM_EVENT_PKG.RECEIVED_MTL_ONHAND',FND_LOG.LEVEL_STATEMENT);

1511:
1512: IF user_id_lst.COUNT > 0 THEN
1513: --*** push to oLite using asg_download ***
1514: CSM_UTIL_PKG.LOG('Pushing ' || user_id_lst.COUNT || ' updates',
1515: 'CSM_SYSTEM_ITEM_EVENT_PKG.RECEIVED_MTL_ONHAND',FND_LOG.LEVEL_STATEMENT);
1516:
1517: FORALL i IN 1..user_id_lst.COUNT
1518: UPDATE CSM_MTL_ONHAND_QTY_ACC
1519: SET LAST_UPDATE_DATE = sysdate, QUANTITY = qty(i)

Line 1563: 'CSM_SYSTEM_ITEM_EVENT_PKG.RECEIVED_MTL_ONHAND',FND_LOG.LEVEL_STATEMENT);

1559: -- check if there are any items to be downloaded
1560: IF inv_id.COUNT > 0 THEN
1561: --*** push to oLite using asg_download ***
1562: CSM_UTIL_PKG.LOG('Pushing ' || inv_id.COUNT || ' inserts',
1563: 'CSM_SYSTEM_ITEM_EVENT_PKG.RECEIVED_MTL_ONHAND',FND_LOG.LEVEL_STATEMENT);
1564:
1565: FOR i IN 1..inv_id.COUNT LOOP
1566: SELECT csm_mtl_onhand_qty_acc_s.NEXTVAL INTO acc_id_lst(i) FROM dual;
1567: END LOOP;

Line 1585: CSM_UTIL_PKG.LOG('Find and add instances if the received item is IB trackable', 'CSM_SYSTEM_ITEM_EVENT_PKG.RECEIVED_MTL_ONHAND',FND_LOG.LEVEL_STATEMENT);

1581: , P_TIMESTAMP => sysdate
1582: );
1583: END IF;
1584:
1585: CSM_UTIL_PKG.LOG('Find and add instances if the received item is IB trackable', 'CSM_SYSTEM_ITEM_EVENT_PKG.RECEIVED_MTL_ONHAND',FND_LOG.LEVEL_STATEMENT);
1586: FOR rec IN c_find_instances
1587: LOOP
1588: CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCES_ACC_PROCESSOR(rec.instance_id,rec.USER_ID,NULL,l_return_status,l_err_msg);
1589: END LOOP;

Line 1591: CSM_UTIL_PKG.LOG('Leaving RECEIVED_MTL_ONHAND', 'CSM_SYSTEM_ITEM_EVENT_PKG.RECEIVED_MTL_ONHAND',FND_LOG.LEVEL_STATEMENT);

1587: LOOP
1588: CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCES_ACC_PROCESSOR(rec.instance_id,rec.USER_ID,NULL,l_return_status,l_err_msg);
1589: END LOOP;
1590:
1591: CSM_UTIL_PKG.LOG('Leaving RECEIVED_MTL_ONHAND', 'CSM_SYSTEM_ITEM_EVENT_PKG.RECEIVED_MTL_ONHAND',FND_LOG.LEVEL_STATEMENT);
1592: END RECEIVED_MTL_ONHAND;
1593:
1594: END CSM_SYSTEM_ITEM_EVENT_PKG;
1595:

Line 1594: END CSM_SYSTEM_ITEM_EVENT_PKG;

1590:
1591: CSM_UTIL_PKG.LOG('Leaving RECEIVED_MTL_ONHAND', 'CSM_SYSTEM_ITEM_EVENT_PKG.RECEIVED_MTL_ONHAND',FND_LOG.LEVEL_STATEMENT);
1592: END RECEIVED_MTL_ONHAND;
1593:
1594: END CSM_SYSTEM_ITEM_EVENT_PKG;
1595: