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_SYSTEM_ITEMS_EVENT_PKG dependencies on CSM_UTIL_PKG

Line 151: CSM_UTIL_PKG.LOG('Entering CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.INSERT_MTL_SYSTEM_ITEMS ',

147: l_check_org VARCHAR2(10) := 'N';
148: l_profile_value VARCHAR2(10);
149: l_number NUMBER := -1;
150: BEGIN
151: CSM_UTIL_PKG.LOG('Entering CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.INSERT_MTL_SYSTEM_ITEMS ',
152: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.INSERT_MTL_SYSTEM_ITEMS',FND_LOG.LEVEL_PROCEDURE);
153:
154: l_run_date := SYSDATE;
155: --GEt the value for CSM: Download Organization Level Inventory

Line 224: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.INSERT_MTL_SYSTEM_ITEMS after common processing',

220: AND CATEGORY_ID IS NULL
221: AND USER_ID = p_user_id;
222: COMMIT;
223: END IF;--IF org has changed for the user.
224: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.INSERT_MTL_SYSTEM_ITEMS after common processing',
225: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.INSERT_MTL_SYSTEM_ITEMS',FND_LOG.LEVEL_PROCEDURE);
226:
227: RETURN;
228: END IF;--Profile to process only org

Line 363: CSM_UTIL_PKG.LOG('Bulk inserted ' || l_tab_access_id.count

359: l_organization_id_tbl, l_tab_user_id LIMIT 1000;
360: EXIT WHEN l_tab_access_id.COUNT = 0;
361:
362: IF l_tab_access_id.COUNT > 0 THEN
363: CSM_UTIL_PKG.LOG('Bulk inserted ' || l_tab_access_id.count
364: || ' records into csm_mtl_system_items_acc for user ' || p_user_id ,
365: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.INSERT_MTL_SYSTEM_ITEMS',FND_LOG.LEVEL_EVENT);
366:
367: FORALL i IN 1..l_tab_access_id.COUNT

Line 404: CSM_UTIL_PKG.LOG('Bulk inserted ' || l_tab_access_id.count

400: l_organization_id_tbl, l_tab_user_id LIMIT 1000;
401: EXIT WHEN l_tab_access_id.COUNT = 0;
402:
403: IF l_tab_access_id.COUNT > 0 THEN
404: CSM_UTIL_PKG.LOG('Bulk inserted ' || l_tab_access_id.count
405: || ' records into csm_mtl_system_items_acc for user ' || p_user_id ,
406: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.INSERT_MTL_SYSTEM_ITEMS',FND_LOG.LEVEL_EVENT);
407:
408: FORALL i IN 1..l_tab_access_id.COUNT

Line 445: CSM_UTIL_PKG.LOG('Bulk inserted ' || l_tab_access_id.count

441: l_organization_id_tbl, l_tab_user_id LIMIT 1000;
442: EXIT WHEN l_tab_access_id.COUNT = 0;
443:
444: IF l_tab_access_id.COUNT > 0 THEN
445: CSM_UTIL_PKG.LOG('Bulk inserted ' || l_tab_access_id.count
446: || ' records into csm_mtl_system_items_acc for user ' || p_user_id ,
447: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.INSERT_MTL_SYSTEM_ITEMS',FND_LOG.LEVEL_EVENT);
448:
449: FORALL i IN 1..l_tab_access_id.COUNT

Line 486: CSM_UTIL_PKG.LOG('Bulk inserted ' || l_tab_access_id.count

482: l_organization_id_tbl, l_tab_user_id LIMIT 1000;
483: EXIT WHEN l_tab_access_id.COUNT = 0;
484:
485: IF l_tab_access_id.COUNT > 0 THEN
486: CSM_UTIL_PKG.LOG('Bulk inserted ' || l_tab_access_id.count
487: || ' records into csm_mtl_system_items_acc for user ' || p_user_id ,
488: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.INSERT_MTL_SYSTEM_ITEMS',FND_LOG.LEVEL_EVENT);
489:
490: FORALL i IN 1..l_tab_access_id.COUNT

Line 517: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.INSERT_MTL_SYSTEM_ITEMS ',

513: SET TYPE = 'I'
514: WHERE USER_ID = p_user_id;
515: COMMIT;
516:
517: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.INSERT_MTL_SYSTEM_ITEMS ',
518: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.INSERT_MTL_SYSTEM_ITEMS',FND_LOG.LEVEL_PROCEDURE);
519: EXCEPTION
520: WHEN others THEN
521: l_sqlerrno := TO_CHAR(SQLCODE);

Line 525: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.INSERT_MTL_SYSTEM_ITEMS',FND_LOG.LEVEL_EXCEPTION);

521: l_sqlerrno := TO_CHAR(SQLCODE);
522: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
523: l_error_msg := ' Exception in INSERT_MTL_SYSTEM_ITEMS for user_id :'
524: || to_char(p_user_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
525: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.INSERT_MTL_SYSTEM_ITEMS',FND_LOG.LEVEL_EXCEPTION);
526: RAISE;
527: END INSERT_MTL_SYSTEM_ITEMS;
528:
529: PROCEDURE update_mtl_system_items(p_last_run_date IN DATE)

Line 611: CSM_UTIL_PKG.LOG('Entering CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.UPDATE_MTL_SYSTEM_ITEMS ',

607: AND msi.organization_id = acc.organization_id
608: AND (msi.enabled_flag = 'N' OR msi.end_date_active < b_last_date));
609:
610: BEGIN
611: CSM_UTIL_PKG.LOG('Entering CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.UPDATE_MTL_SYSTEM_ITEMS ',
612: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.UPDATE_MTL_SYSTEM_ITEMS',FND_LOG.LEVEL_PROCEDURE);
613:
614: l_run_date := SYSDATE;
615:

Line 625: CSM_UTIL_PKG.LOG('Leaving UPDATE_MTL_SYSTEM_ITEMS - No Updates ',

621: SELECT MAX(last_update_date) INTO l_max_last_update_date_tl
622: FROM mtl_system_items_tl;
623: IF(l_max_last_update_date_tl < p_last_run_date) THEN
624: -- No updates
625: CSM_UTIL_PKG.LOG('Leaving UPDATE_MTL_SYSTEM_ITEMS - No Updates ',
626: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.UPDATE_MTL_SYSTEM_ITEMS',FND_LOG.LEVEL_PROCEDURE);
627: RETURN;
628: END IF;
629: END IF;

Line 646: CSM_UTIL_PKG.LOG(l_tab_access_id.COUNT || ' records sent to olite for updating csm_mtl_system_items',

642:
643: FETCH c_del_org_based BULK COLLECT INTO l_tab_access_id, l_tab_user_id LIMIT 1000;
644: EXIT WHEN l_tab_access_id.COUNT = 0;
645:
646: CSM_UTIL_PKG.LOG(l_tab_access_id.COUNT || ' records sent to olite for updating csm_mtl_system_items',
647: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.UPDATE_MTL_SYSTEM_ITEMS',FND_LOG.LEVEL_EVENT);
648: l_transaction_flag :='Y'; --this flag is to save db access
649: -- do bulk makedirty
650: l_markdirty := asg_download.mark_dirty(

Line 684: CSM_UTIL_PKG.LOG(l_tab_access_id.COUNT || ' records sent to olite for updating csm_mtl_system_items',

680: FETCH c_changed_org_based BULK COLLECT INTO l_tab_access_id, l_tab_user_id LIMIT 1000;
681: EXIT WHEN l_tab_access_id.COUNT = 0;
682:
683: IF l_tab_access_id.COUNT > 0 THEN
684: CSM_UTIL_PKG.LOG(l_tab_access_id.COUNT || ' records sent to olite for updating csm_mtl_system_items',
685: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.UPDATE_MTL_SYSTEM_ITEMS',FND_LOG.LEVEL_EVENT);
686:
687: -- do bulk makedirty
688: l_markdirty := asg_download.mark_dirty(

Line 732: CSM_UTIL_PKG.LOG(l_tab_access_id.COUNT || ' records sent to olite for Inerting csm_mtl_system_items',

728: FETCH c_New_items_for_org BULK COLLECT INTO l_tab_access_id, l_tab_user_id LIMIT 1000;
729: EXIT WHEN l_tab_access_id.COUNT = 0;
730:
731: IF l_tab_access_id.COUNT > 0 THEN
732: CSM_UTIL_PKG.LOG(l_tab_access_id.COUNT || ' records sent to olite for Inerting csm_mtl_system_items',
733: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.UPDATE_MTL_SYSTEM_ITEMS',FND_LOG.LEVEL_EVENT);
734: l_transaction_flag := 'Y';
735: -- do bulk makedirty
736: l_markdirty := asg_download.mark_dirty(

Line 766: CSM_UTIL_PKG.LOG(l_tab_access_id.COUNT || ' records sent to olite for updating csm_mtl_system_items',

762: FETCH c_changed BULK COLLECT INTO l_tab_access_id, l_tab_user_id LIMIT 1000;
763: EXIT WHEN l_tab_access_id.COUNT = 0;
764:
765: IF l_tab_access_id.COUNT > 0 THEN
766: CSM_UTIL_PKG.LOG(l_tab_access_id.COUNT || ' records sent to olite for updating csm_mtl_system_items',
767: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.UPDATE_MTL_SYSTEM_ITEMS',FND_LOG.LEVEL_EVENT);
768:
769: -- do bulk makedirty
770: l_markdirty := asg_download.mark_dirty(

Line 784: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.UPDATE_MTL_SYSTEM_ITEMS ',

780: CLOSE c_changed;
781:
782: END IF;
783:
784: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.UPDATE_MTL_SYSTEM_ITEMS ',
785: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.UPDATE_MTL_SYSTEM_ITEMS',FND_LOG.LEVEL_PROCEDURE);
786:
787: EXCEPTION
788: WHEN OTHERS THEN

Line 792: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.UPDATE_MTL_SYSTEM_ITEMS',FND_LOG.LEVEL_EXCEPTION);

788: WHEN OTHERS THEN
789: l_sqlerrno := TO_CHAR(SQLCODE);
790: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
791: l_error_msg := ' Exception in UPDATE_MTL_SYSTEM_ITEMS :' || l_sqlerrno || ':' || l_sqlerrmsg;
792: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.UPDATE_MTL_SYSTEM_ITEMS',FND_LOG.LEVEL_EXCEPTION);
793: RAISE;
794: END UPDATE_MTL_SYSTEM_ITEMS;
795:
796: PROCEDURE delete_mtl_system_items(p_user_id IN NUMBER,

Line 829: CSM_UTIL_PKG.LOG('Entering CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.DELETE_MTL_SYSTEM_ITEMS ',

825:
826: l_profile_value VARCHAR2(100);
827: l_org_count NUMBER;
828: BEGIN
829: CSM_UTIL_PKG.LOG('Entering CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.DELETE_MTL_SYSTEM_ITEMS ',
830: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.DELETE_MTL_SYSTEM_ITEMS',FND_LOG.LEVEL_PROCEDURE);
831:
832: l_run_date := SYSDATE;
833: l_tab_access_id.DELETE;

Line 927: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.DELETE_MTL_SYSTEM_ITEMS ',

923: DELETE FROM csm_mtl_system_items_acc WHERE access_id = l_tab_access_id(i);
924: END IF;
925: END IF;
926:
927: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.DELETE_MTL_SYSTEM_ITEMS ',
928: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.DELETE_MTL_SYSTEM_ITEMS',FND_LOG.LEVEL_PROCEDURE);
929: EXCEPTION
930: WHEN others THEN
931: l_sqlerrno := TO_CHAR(SQLCODE);

Line 933: CSM_UTIL_PKG.LOG('Exception in CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.DELETE_MTL_SYSTEM_ITEMS: ' || l_sqlerrno || ':' || l_sqlerrmsg,

929: EXCEPTION
930: WHEN others THEN
931: l_sqlerrno := TO_CHAR(SQLCODE);
932: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
933: CSM_UTIL_PKG.LOG('Exception in CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.DELETE_MTL_SYSTEM_ITEMS: ' || l_sqlerrno || ':' || l_sqlerrmsg,
934: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.DELETE_MTL_SYSTEM_ITEMS',FND_LOG.LEVEL_EXCEPTION);
935: RAISE;
936: END DELETE_MTL_SYSTEM_ITEMS;
937:

Line 962: CSM_UTIL_PKG.LOG('Entering CONCURRENT_PROCESS_USER for user_id: ' || TO_CHAR(p_user_id),

958:
959: r_org c_org%ROWTYPE;
960: l_profile_value VARCHAR2(10);
961: BEGIN
962: CSM_UTIL_PKG.LOG('Entering CONCURRENT_PROCESS_USER for user_id: ' || TO_CHAR(p_user_id),
963: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.CONCURRENT_PROCESS_USER',FND_LOG.LEVEL_PROCEDURE);
964:
965: /* Get old profile settings */
966: g_download_inv_flag := NULL;

Line 973: CSM_UTIL_PKG.LOG('Profile record not found in csm_user_inventory_org for user_id: ' || TO_CHAR(p_user_id)

969:
970: OPEN c_org( p_user_id );
971: FETCH c_org INTO r_org;
972: IF c_org%NOTFOUND THEN -- should not occur
973: CSM_UTIL_PKG.LOG('Profile record not found in csm_user_inventory_org for user_id: ' || TO_CHAR(p_user_id)
974: || ' - Inserting all mtl_system_items',
975: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.CONCURRENT_PROCESS_USER',FND_LOG.LEVEL_PROCEDURE);
976: INSERT INTO csm_user_inventory_org (
977: user_id, organization_id, last_update_date, last_updated_by,

Line 1019: CSM_UTIL_PKG.LOG('Deleting records for old profile settings for user_id: ' || TO_CHAR(p_user_id),

1015: END IF;
1016:
1017: IF NVL(p_organization_id, -1) <> NVL(r_org.organization_id, -1)
1018: OR l_cat_filter_changed THEN
1019: CSM_UTIL_PKG.LOG('Deleting records for old profile settings for user_id: ' || TO_CHAR(p_user_id),
1020: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.CONCURRENT_PROCESS_USER',FND_LOG.LEVEL_PROCEDURE);
1021:
1022: -- delete labor/expense items only and then re-insert for the new orgif org changes
1023: IF NVL(p_organization_id, -1) <> NVL(r_org.organization_id,-1) THEN

Line 1036: CSM_UTIL_PKG.LOG('Inserting records for new profile settings for user_id: ' || TO_CHAR(p_user_id),

1032: p_organization_id=>r_org.organization_id,
1033: p_category_set_id=>r_org.category_set_id,
1034: p_category_id=>r_org.category_id);
1035:
1036: CSM_UTIL_PKG.LOG('Inserting records for new profile settings for user_id: ' || TO_CHAR(p_user_id),
1037: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.CONCURRENT_PROCESS_USER',FND_LOG.LEVEL_PROCEDURE);
1038:
1039: insert_mtl_system_items(p_user_id=>p_user_id,
1040: p_organization_id=>p_organization_id,

Line 1046: CSM_UTIL_PKG.LOG('Update csm_user_inventory_org with new profile settings for user_id: ' || TO_CHAR(p_user_id),

1042: p_category_id=>p_category_id,
1043: p_last_run_date=>NULL,
1044: p_changed=>'Y');
1045:
1046: CSM_UTIL_PKG.LOG('Update csm_user_inventory_org with new profile settings for user_id: ' || TO_CHAR(p_user_id),
1047: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.CONCURRENT_PROCESS_USER',FND_LOG.LEVEL_PROCEDURE);
1048:
1049: UPDATE csm_user_inventory_org
1050: SET organization_id = p_organization_id

Line 1059: CSM_UTIL_PKG.LOG('Getting new items for same profile settings for user_id: ' || TO_CHAR(p_user_id),

1055:
1056: ELSE
1057: -- profiles are the same
1058: -- get any new changes
1059: CSM_UTIL_PKG.LOG('Getting new items for same profile settings for user_id: ' || TO_CHAR(p_user_id),
1060: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.CONCURRENT_PROCESS_USER',FND_LOG.LEVEL_PROCEDURE);
1061:
1062: insert_mtl_system_items(p_user_id=>p_user_id,
1063: p_organization_id=>p_organization_id,

Line 1072: CSM_UTIL_PKG.LOG('Leaving CONCURRENT_PROCESS_USER for user_id: ' || TO_CHAR(p_user_id),

1068: END IF;
1069: END IF;
1070: CLOSE c_org;
1071:
1072: CSM_UTIL_PKG.LOG('Leaving CONCURRENT_PROCESS_USER for user_id: ' || TO_CHAR(p_user_id),
1073: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.CONCURRENT_PROCESS_USER',FND_LOG.LEVEL_PROCEDURE);
1074: EXCEPTION
1075: WHEN OTHERS THEN
1076: l_sqlerrno := TO_CHAR(SQLCODE);

Line 1080: CSM_UTIL_PKG.LOG(l_error_msg, 'csm_mtl_system_items_event_pkg.concurrent_process_user',FND_LOG.LEVEL_EXCEPTION);

1076: l_sqlerrno := TO_CHAR(SQLCODE);
1077: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
1078: l_error_msg := ' Exception in concurrent_process_user for user_id :'
1079: || TO_CHAR(p_user_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
1080: CSM_UTIL_PKG.LOG(l_error_msg, 'csm_mtl_system_items_event_pkg.concurrent_process_user',FND_LOG.LEVEL_EXCEPTION);
1081: RAISE;
1082: END CONCURRENT_PROCESS_USER;
1083:
1084: /*--NO LONGER USING THIS API */

Line 1133: CSM_UTIL_PKG.LOG('Bulk inserted ' || l_tab_access_id.count || ' records into csm_mtl_system_items_acc of requirement lines' ,

1129: FETCH c_htm5_mtl_items BULK COLLECT INTO l_tab_access_id,l_inventory_item_id_tbl,
1130: l_organization_id_tbl, l_tab_user_id LIMIT 1000;
1131: EXIT WHEN l_tab_access_id.COUNT = 0;
1132:
1133: CSM_UTIL_PKG.LOG('Bulk inserted ' || l_tab_access_id.count || ' records into csm_mtl_system_items_acc of requirement lines' ,
1134: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.process_htm5_ordered_items',FND_LOG.LEVEL_EVENT);
1135:
1136: FORALL i IN 1..l_tab_access_id.COUNT
1137: INSERT INTO csm_mtl_system_items_acc(access_id, user_id, inventory_item_id, organization_id, counter,

Line 1250: CSM_UTIL_PKG.LOG('Bulk deleted ' || l_tab_access_id.count || ' records from csm_mtl_system_items_acc','CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.process_htm5_user_items',FND_LOG.LEVEL_EVENT);

1246: l_tab_user_id.DELETE;
1247: FETCH c_get_del_items BULK COLLECT INTO l_tab_access_id,l_tab_user_id LIMIT 1000;
1248: EXIT WHEN l_tab_access_id.COUNT =0;
1249:
1250: CSM_UTIL_PKG.LOG('Bulk deleted ' || l_tab_access_id.count || ' records from csm_mtl_system_items_acc','CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.process_htm5_user_items',FND_LOG.LEVEL_EVENT);
1251:
1252: l_markdirty := asg_download.mark_dirty(
1253: P_PUB_ITEM => g_pub_item
1254: , p_accessList => l_tab_access_id

Line 1275: CSM_UTIL_PKG.LOG('Bulk updated ' || l_tab_access_id.count || ' records from csm_mtl_system_items_acc' ,'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.process_htm5_user_items',FND_LOG.LEVEL_EVENT);

1271: l_tab_access_id.DELETE;
1272: l_tab_user_id.DELETE;
1273: FETCH c_get_upd_items BULK COLLECT INTO l_tab_access_id,l_tab_user_id LIMIT 1000;
1274: EXIT WHEN l_tab_access_id.COUNT =0;
1275: CSM_UTIL_PKG.LOG('Bulk updated ' || l_tab_access_id.count || ' records from csm_mtl_system_items_acc' ,'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.process_htm5_user_items',FND_LOG.LEVEL_EVENT);
1276: l_markdirty := asg_download.mark_dirty(
1277: P_PUB_ITEM => g_pub_item
1278: , p_accessList => l_tab_access_id
1279: , p_userid_list => l_tab_user_id

Line 1302: CSM_UTIL_PKG.LOG('Bulk inserted ' || l_tab_access_id.count || ' records into csm_mtl_system_items_acc ' ,

1298: FETCH c_get_ins_items BULK COLLECT INTO l_tab_access_id, l_inventory_item_id_tbl,
1299: l_organization_id_tbl, l_tab_user_id LIMIT 2000;
1300: EXIT WHEN l_tab_access_id.COUNT = 0;
1301:
1302: CSM_UTIL_PKG.LOG('Bulk inserted ' || l_tab_access_id.count || ' records into csm_mtl_system_items_acc ' ,
1303: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.process_htm5_user_items',FND_LOG.LEVEL_EVENT);
1304:
1305: FORALL i IN 1..l_tab_access_id.COUNT
1306: INSERT INTO csm_mtl_system_items_acc(access_id, user_id, inventory_item_id, organization_id, counter,

Line 1353: CSM_UTIL_PKG.LOG('Entering CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.Refresh_mtl_system_items_acc ',

1349: WHERE package_name = 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG'
1350: AND procedure_name = 'REFRESH_MTL_SYSTEM_ITEMS_ACC';
1351:
1352: BEGIN
1353: CSM_UTIL_PKG.LOG('Entering CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.Refresh_mtl_system_items_acc ',
1354: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.Refresh_mtl_system_items_acc',FND_LOG.LEVEL_PROCEDURE);
1355:
1356: l_run_date := SYSDATE;
1357:

Line 1381: l_all_omfs_user_list := csm_util_pkg.get_all_omfs_palm_user_list;

1377: COMMIT;
1378:
1379: -- get user list of all omfs users
1380: l_all_omfs_user_list := l_null_omfs_user_list;
1381: l_all_omfs_user_list := csm_util_pkg.get_all_omfs_palm_user_list;
1382:
1383: FOR i IN 1..l_all_omfs_user_list.COUNT LOOP
1384: l_user_id := l_all_omfs_user_list(i);
1385:

Line 1386: IF NOT CSM_UTIL_PKG.IS_HTML5_USER(l_user_id) THEN

1382:
1383: FOR i IN 1..l_all_omfs_user_list.COUNT LOOP
1384: l_user_id := l_all_omfs_user_list(i);
1385:
1386: IF NOT CSM_UTIL_PKG.IS_HTML5_USER(l_user_id) THEN
1387:
1388: l_user_organization_id := csm_profile_pkg.get_organization_id(l_user_id);
1389: l_user_category_set_id := csm_profile_pkg.get_category_set_id(l_user_id);
1390: l_user_category_id := csm_profile_pkg.get_category_id(l_user_id);

Line 1415: CSM_UTIL_PKG.LOG('Leaving csm_mtl_system_items_event_pkg.Refresh_mtl_system_items_acc ',

1411:
1412: p_status := 'FINE';
1413: p_message := 'csm_mtl_system_items_event_pkg.refresh_system_items executed successfully';
1414:
1415: CSM_UTIL_PKG.LOG('Leaving csm_mtl_system_items_event_pkg.Refresh_mtl_system_items_acc ',
1416: 'csm_mtl_system_items_event_pkg.Refresh_mtl_system_items_acc',FND_LOG.LEVEL_PROCEDURE);
1417: EXCEPTION
1418: WHEN others THEN
1419: l_sqlerrno := TO_CHAR(SQLCODE);

Line 1424: csm_util_pkg.log('CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.REFRESH_MTL_SYSTEM_ITEMS_ACC ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);

1420: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
1421: p_status := 'ERROR';
1422: p_message := 'Error in CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.REFRESH_MTL_SYSTEM_ITEMS_ACC: ' || l_sqlerrno || ':' || l_sqlerrmsg;
1423: ROLLBACK;
1424: csm_util_pkg.log('CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.REFRESH_MTL_SYSTEM_ITEMS_ACC ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);
1425: END REFRESH_MTL_SYSTEM_ITEMS_ACC;
1426:
1427: PROCEDURE get_new_user_mtl_system_items(p_user_id IN NUMBER, p_organization_id IN NUMBER,
1428: p_category_set_id IN NUMBER, p_category_id IN NUMBER)

Line 1437: CSM_UTIL_PKG.LOG('Entering CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.get_new_user_mtl_system_items ',

1433: l_return_status VARCHAR2(2000);
1434: l_profile_value VARCHAR2(10);
1435: l_changed varchar2(10);
1436: BEGIN
1437: CSM_UTIL_PKG.LOG('Entering CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.get_new_user_mtl_system_items ',
1438: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.get_new_user_mtl_system_items',FND_LOG.LEVEL_PROCEDURE);
1439: --The flag can be null only when is called from csm_user_event_pkg during
1440: --User creation
1441: IF g_download_inv_flag IS NULL THEN

Line 1460: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.get_new_user_mtl_system_items ',

1456: p_category_id=>p_category_id,
1457: p_last_run_date=>NULL,
1458: p_changed=>l_changed); -- new user, no profiles are changed
1459:
1460: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.get_new_user_mtl_system_items ',
1461: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.get_new_user_mtl_system_items',FND_LOG.LEVEL_PROCEDURE);
1462:
1463: EXCEPTION
1464: WHEN others THEN

Line 1469: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.get_new_user_mtl_system_items',FND_LOG.LEVEL_EXCEPTION);

1465: l_sqlerrno := TO_CHAR(SQLCODE);
1466: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
1467: l_error_msg := ' Exception in get_new_user_mtl_system_items for user_id :'
1468: || to_char(p_user_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
1469: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.get_new_user_mtl_system_items',FND_LOG.LEVEL_EXCEPTION);
1470: RAISE;
1471: END get_new_user_mtl_system_items;
1472:
1473: PROCEDURE mtl_system_items_acc_i(p_inventory_item_id IN NUMBER,

Line 1481: CSM_UTIL_PKG.LOG('Entering CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.MTL_SYSTEM_ITEMS_ACC_I ',

1477: x_return_status IN OUT NOCOPY VARCHAR2)
1478: IS
1479: BEGIN
1480: x_return_status := FND_API.G_RET_STS_SUCCESS;
1481: CSM_UTIL_PKG.LOG('Entering CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.MTL_SYSTEM_ITEMS_ACC_I ',
1482: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.MTL_SYSTEM_ITEMS_ACC_I',FND_LOG.LEVEL_PROCEDURE);
1483:
1484: IF p_inventory_item_id IS NOT NULL AND p_organization_id IS NOT NULL THEN
1485: CSM_ACC_PKG.Insert_Acc

Line 1499: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.MTL_SYSTEM_ITEMS_ACC_I ',

1495:
1496: END IF;
1497:
1498: p_error_msg := 'SUCCESS';
1499: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.MTL_SYSTEM_ITEMS_ACC_I ',
1500: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.MTL_SYSTEM_ITEMS_ACC_I',FND_LOG.LEVEL_PROCEDURE);
1501: EXCEPTION
1502: WHEN others THEN
1503: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1505: CSM_UTIL_PKG.LOG(p_error_msg, 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.MTL_SYSTEM_ITEMS_ACC_I',FND_LOG.LEVEL_EXCEPTION);

1501: EXCEPTION
1502: WHEN others THEN
1503: x_return_status := FND_API.G_RET_STS_ERROR;
1504: p_error_msg := ' FAILED MTL_SYSTEM_ITEMS_ACC_I INVENTORY_ITEM_ID: ' || to_char(p_inventory_item_id) || SUBSTR(SQLERRM,1,2000);
1505: CSM_UTIL_PKG.LOG(p_error_msg, 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.MTL_SYSTEM_ITEMS_ACC_I',FND_LOG.LEVEL_EXCEPTION);
1506: RAISE;
1507: END MTL_SYSTEM_ITEMS_ACC_I;
1508:
1509: PROCEDURE mtl_system_items_acc_d(p_inventory_item_id IN NUMBER,

Line 1517: CSM_UTIL_PKG.LOG('Entering CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.MTL_SYSTEM_ITEMS_ACC_D',

1513: x_return_status IN OUT NOCOPY VARCHAR2)
1514: IS
1515: BEGIN
1516: x_return_status := FND_API.G_RET_STS_SUCCESS;
1517: CSM_UTIL_PKG.LOG('Entering CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.MTL_SYSTEM_ITEMS_ACC_D',
1518: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.MTL_SYSTEM_ITEMS_ACC_D',FND_LOG.LEVEL_PROCEDURE);
1519:
1520: IF p_inventory_item_id IS NOT NULL AND p_organization_id IS NOT NULL THEN
1521: CSM_ACC_PKG.Delete_Acc

Line 1533: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.MTL_SYSTEM_ITEMS_ACC_D ',

1529: );
1530: END IF;
1531:
1532: p_error_msg := 'SUCCESS';
1533: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.MTL_SYSTEM_ITEMS_ACC_D ',
1534: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.MTL_SYSTEM_ITEMS_ACC_D',FND_LOG.LEVEL_PROCEDURE);
1535: EXCEPTION
1536: WHEN others THEN
1537: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1539: CSM_UTIL_PKG.LOG(p_error_msg, 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.MTL_SYSTEM_ITEMS_ACC_D',FND_LOG.LEVEL_EXCEPTION);

1535: EXCEPTION
1536: WHEN others THEN
1537: x_return_status := FND_API.G_RET_STS_ERROR;
1538: p_error_msg := ' FAILED MTL_SYSTEM_ITEMS_ACC_D INVENTORY_ITEM_ID: ' || to_char(p_inventory_item_id) || SUBSTR(SQLERRM,1,2000);
1539: CSM_UTIL_PKG.LOG(p_error_msg, 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.MTL_SYSTEM_ITEMS_ACC_D',FND_LOG.LEVEL_EXCEPTION);
1540: RAISE;
1541: END MTL_SYSTEM_ITEMS_ACC_D;
1542:
1543: END CSM_MTL_SYSTEM_ITEMS_EVENT_PKG;