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 FND_LOG

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 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 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 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 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 768: 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY',FND_LOG.LEVEL_PROCEDURE);

764: l_current_run_date DATE;
765:
766: BEGIN
767: CSM_UTIL_PKG.LOG('Entering CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY ',
768: 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY',FND_LOG.LEVEL_PROCEDURE);
769:
770: l_current_run_date := SYSDATE;
771:
772: --*** Push deleted records to client ***

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

808: EXIT WHEN acc_id_lst.COUNT = 0;
809:
810: IF acc_id_lst.COUNT > 0 THEN
811: CSM_UTIL_PKG.LOG('Pushing ' || acc_id_lst.COUNT || 'deleted records',
812: 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY',FND_LOG.LEVEL_STATEMENT);
813:
814: -- do bulk makedirty
815: l_dummy := asg_download.mark_dirty(
816: P_PUB_ITEM => g_pub_item

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

873:
874: IF user_id_lst.COUNT > 0 THEN
875: --*** push to oLite using asg_download ***
876: CSM_UTIL_PKG.LOG('Pushing ' || user_id_lst.COUNT || 'updated records',
877: 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY',FND_LOG.LEVEL_STATEMENT);
878:
879: FORALL i IN user_id_lst.FIRST..user_id_lst.LAST
880: UPDATE CSM_MTL_ONHAND_QTY_ACC
881: SET LAST_UPDATE_DATE = l_current_run_date,

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

943: -- check if there are any items to be downloaded
944: IF inv_id.COUNT > 0 THEN
945: --*** push to oLite using asg_download ***
946: CSM_UTIL_PKG.LOG('Pushing ' || inv_id.COUNT || 'inserted records',
947: 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY',FND_LOG.LEVEL_STATEMENT);
948:
949: FOR i IN inv_id.FIRST..inv_id.LAST LOOP
950: SELECT csm_mtl_onhand_qty_acc_s.NEXTVAL INTO acc_id_lst(i) FROM dual;
951: END LOOP;

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

978:
979: COMMIT;
980:
981: CSM_UTIL_PKG.LOG('Leaving CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY ',
982: 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY',FND_LOG.LEVEL_PROCEDURE);
983:
984: p_status := 'FINE';
985: p_message := 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY Executed successfully';
986:

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

1041: l_organization_id mtl_system_items.organization_id%TYPE;
1042:
1043: BEGIN
1044: CSM_UTIL_PKG.LOG('Entering CSM_SYSTEM_ITEM_EVENT_PKG.get_new_user_system_items ',
1045: 'CSM_SYSTEM_ITEM_EVENT_PKG.get_new_user_system_items',FND_LOG.LEVEL_PROCEDURE);
1046:
1047: g_pub_item := 'CSF_M_SYSTEM_ITEMS';
1048: l_current_run_date := SYSDATE;
1049: l_organization_id := csm_profile_pkg.get_organization_id(p_user_id);

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

1077: END LOOP;
1078: CLOSE l_systemitems_ins_csr;
1079:
1080: CSM_UTIL_PKG.LOG('Leaving CSM_SYSTEM_ITEM_EVENT_PKG.get_new_user_system_items ',
1081: 'CSM_SYSTEM_ITEM_EVENT_PKG.get_new_user_system_items',FND_LOG.LEVEL_PROCEDURE);
1082:
1083: EXCEPTION
1084: WHEN others THEN
1085: l_sqlerrno := to_char(SQLCODE);

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

1083: EXCEPTION
1084: WHEN others THEN
1085: l_sqlerrno := to_char(SQLCODE);
1086: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1087: csm_util_pkg.log('CSM_SYSTEM_ITEM_EVENT_PKG.get_new_user_system_items ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg, FND_LOG.LEVEL_EXCEPTION);
1088: RAISE;
1089: END get_new_user_system_items;
1090:
1091: PROCEDURE SYSTEM_ITEM_MDIRTY_I(p_inventory_item_id IN NUMBER,

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

1098: l_return_status VARCHAR2(2000);
1099:
1100: BEGIN
1101: CSM_UTIL_PKG.LOG('Entering SYSTEM_ITEM_MDIRTY_I for inventory_item_id: ' || p_inventory_item_id,
1102: 'CSM_SYSTEM_ITEM_EVENT_PKG.SYSTEM_ITEM_MDIRTY_I',FND_LOG.LEVEL_PROCEDURE);
1103:
1104: IF p_inventory_item_id IS NOT NULL AND p_organization_id IS NOT NULL THEN
1105: -- insert into csm_system_items_acc
1106: CSM_ACC_PKG.Insert_Acc

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

1115: );
1116: END IF;
1117:
1118: CSM_UTIL_PKG.LOG('Leaving SYSTEM_ITEM_MDIRTY_I for inventory_item_id: ' || p_inventory_item_id,
1119: 'CSM_SYSTEM_ITEM_EVENT_PKG.SYSTEM_ITEM_MDIRTY_I',FND_LOG.LEVEL_PROCEDURE);
1120: EXCEPTION
1121: WHEN OTHERS THEN
1122: l_sqlerrno := to_char(SQLCODE);
1123: l_sqlerrmsg := substr(SQLERRM, 1,2000);

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

1122: l_sqlerrno := to_char(SQLCODE);
1123: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1124: l_error_msg := ' Exception in SYSTEM_ITEM_MDIRTY_I for inventory_item_id: ' || p_inventory_item_id
1125: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
1126: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SYSTEM_ITEM_EVENT_PKG.SYSTEM_ITEM_MDIRTY_I',FND_LOG.LEVEL_EXCEPTION);
1127: RAISE;
1128: END SYSTEM_ITEM_MDIRTY_I;
1129:
1130: PROCEDURE SYSTEM_ITEM_MDIRTY_D(p_inventory_item_id IN NUMBER,

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

1137: l_return_status VARCHAR2(2000);
1138:
1139: BEGIN
1140: CSM_UTIL_PKG.LOG('Entering SYSTEM_ITEM_MDIRTY_D for inventory_item_id: ' || p_inventory_item_id,
1141: 'CSM_SYSTEM_ITEM_EVENT_PKG.SYSTEM_ITEM_MDIRTY_D',FND_LOG.LEVEL_PROCEDURE);
1142:
1143: IF p_inventory_item_id IS NOT NULL AND p_organization_id IS NOT NULL THEN
1144: -- delete from csm_system_items_acc
1145: CSM_ACC_PKG.Delete_Acc

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

1153: );
1154: END IF;
1155:
1156: CSM_UTIL_PKG.LOG('Leaving SYSTEM_ITEM_MDIRTY_D for inventory_item_id: ' || p_inventory_item_id,
1157: 'CSM_SYSTEM_ITEM_EVENT_PKG.SYSTEM_ITEM_MDIRTY_D',FND_LOG.LEVEL_PROCEDURE);
1158: EXCEPTION
1159: WHEN OTHERS THEN
1160: l_sqlerrno := to_char(SQLCODE);
1161: l_sqlerrmsg := substr(SQLERRM, 1,2000);

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

1160: l_sqlerrno := to_char(SQLCODE);
1161: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1162: l_error_msg := ' Exception in SYSTEM_ITEM_MDIRTY_D for inventory_item_id: ' || p_inventory_item_id
1163: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
1164: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SYSTEM_ITEM_EVENT_PKG.SYSTEM_ITEM_MDIRTY_D',FND_LOG.LEVEL_EXCEPTION);
1165: RAISE;
1166: END SYSTEM_ITEM_MDIRTY_D;
1167:
1168: END CSM_SYSTEM_ITEM_EVENT_PKG;