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_UTIL_PKG

Line 46: CSM_UTIL_PKG.LOG('Entering DELETE_SYSTEM_ITEMS ',

42: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
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:

Line 85: CSM_UTIL_PKG.LOG('Leaving DELETE_SYSTEM_ITEMS ',

81: FORALL i IN 1..l_tab_access_id.COUNT
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);

Line 91: CSM_UTIL_PKG.LOG('Exception in delete_system_items: ' || l_sqlerrno || ':' || l_sqlerrmsg,

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

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 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 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 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 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 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 517: csm_util_pkg.log('No updates for csm_system_items_event_new_pkg', 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_SYSTEM_ITEMS ');

513: IF l_max_last_update_date_tl < l_last_run_date THEN
514: -- no updates
515: p_status := 'FINE';
516: p_message := 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_SYSTEM_ITEMS Executed successfully - No updates';
517: csm_util_pkg.log('No updates for csm_system_items_event_new_pkg', 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_SYSTEM_ITEMS ');
518:
519: -- set the program update date in jtm_con_request_data to sysdate
520: UPDATE jtm_con_request_data
521: SET last_run_date = l_current_run_date

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

608: l_sqlerrmsg := substr(SQLERRM, 1,2000);
609: p_status := 'ERROR';
610: p_message := 'Error in CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_SYSTEM_ITEMS: ' || l_sqlerrno || ':' || l_sqlerrmsg;
611: ROLLBACK;
612: csm_util_pkg.log('CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_SYSTEM_ITEMS ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);
613: END Refresh_Acc;
614:
615: /* concurrent program that refreshes inventory */
616: PROCEDURE Refresh_mtl_onhand_quantity(p_status OUT NOCOPY VARCHAR2,

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

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

Line 811: CSM_UTIL_PKG.LOG('Pushing ' || acc_id_lst.COUNT || 'deleted records',

807: FETCH l_onhand_delete_csr BULK COLLECT INTO user_id_lst, inv_id, org_id, acc_id_lst LIMIT 100;
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(

Line 876: CSM_UTIL_PKG.LOG('Pushing ' || user_id_lst.COUNT || 'updated records',

872: EXIT WHEN user_id_lst.COUNT = 0;
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

Line 946: CSM_UTIL_PKG.LOG('Pushing ' || inv_id.COUNT || 'inserted records',

942:
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;

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

977: AND procedure_name = 'REFRESH_MTL_ONHAND_QUANTITY';
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';

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

990: l_sqlerrmsg := substr(SQLERRM, 1,2000);
991: p_status := 'ERROR';
992: p_message := 'Error in CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY: ' || l_sqlerrno || ':' || l_sqlerrmsg;
993: ROLLBACK;
994: csm_util_pkg.log('CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);
995:
996: END Refresh_mtl_onhand_quantity;
997:
998: PROCEDURE get_new_user_system_items(p_user_id IN NUMBER)

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

1040: l_dummy BOOLEAN;
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;

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

1076: END IF;
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

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 1101: CSM_UTIL_PKG.LOG('Entering SYSTEM_ITEM_MDIRTY_I for inventory_item_id: ' || p_inventory_item_id,

1097: l_error_msg VARCHAR2(4000);
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

Line 1118: CSM_UTIL_PKG.LOG('Leaving SYSTEM_ITEM_MDIRTY_I for inventory_item_id: ' || p_inventory_item_id,

1114: ,P_USER_ID => p_user_id
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);

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 1140: CSM_UTIL_PKG.LOG('Entering SYSTEM_ITEM_MDIRTY_D for inventory_item_id: ' || p_inventory_item_id,

1136: l_error_msg VARCHAR2(4000);
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

Line 1156: CSM_UTIL_PKG.LOG('Leaving SYSTEM_ITEM_MDIRTY_D for inventory_item_id: ' || p_inventory_item_id,

1152: ,P_USER_ID => p_user_id
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);

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;