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 140: CSM_UTIL_PKG.LOG('Entering CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.INSERT_MTL_SYSTEM_ITEMS ',

136: )
137: );
138:
139: BEGIN
140: CSM_UTIL_PKG.LOG('Entering CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.INSERT_MTL_SYSTEM_ITEMS ',
141: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.INSERT_MTL_SYSTEM_ITEMS',FND_LOG.LEVEL_PROCEDURE);
142:
143: l_run_date := SYSDATE;
144:

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

264: l_organization_id_tbl, l_tab_user_id LIMIT 200;
265: EXIT WHEN l_tab_access_id.COUNT = 0;
266:
267: IF l_tab_access_id.COUNT > 0 THEN
268: CSM_UTIL_PKG.LOG('Bulk inserted ' || l_tab_access_id.count
269: || ' records into csm_mtl_system_items_acc for user ' || p_user_id ,
270: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.INSERT_MTL_SYSTEM_ITEMS',FND_LOG.LEVEL_EVENT);
271:
272: FORALL i IN 1..l_tab_access_id.COUNT

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

305: l_organization_id_tbl, l_tab_user_id LIMIT 200;
306: EXIT WHEN l_tab_access_id.COUNT = 0;
307:
308: IF l_tab_access_id.COUNT > 0 THEN
309: CSM_UTIL_PKG.LOG('Bulk inserted ' || l_tab_access_id.count
310: || ' records into csm_mtl_system_items_acc for user ' || p_user_id ,
311: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.INSERT_MTL_SYSTEM_ITEMS',FND_LOG.LEVEL_EVENT);
312:
313: FORALL i IN 1..l_tab_access_id.COUNT

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

346: l_organization_id_tbl, l_tab_user_id LIMIT 200;
347: EXIT WHEN l_tab_access_id.COUNT = 0;
348:
349: IF l_tab_access_id.COUNT > 0 THEN
350: CSM_UTIL_PKG.LOG('Bulk inserted ' || l_tab_access_id.count
351: || ' records into csm_mtl_system_items_acc for user ' || p_user_id ,
352: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.INSERT_MTL_SYSTEM_ITEMS',FND_LOG.LEVEL_EVENT);
353:
354: FORALL i IN 1..l_tab_access_id.COUNT

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

387: l_organization_id_tbl, l_tab_user_id LIMIT 200;
388: EXIT WHEN l_tab_access_id.COUNT = 0;
389:
390: IF l_tab_access_id.COUNT > 0 THEN
391: CSM_UTIL_PKG.LOG('Bulk inserted ' || l_tab_access_id.count
392: || ' records into csm_mtl_system_items_acc for user ' || p_user_id ,
393: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.INSERT_MTL_SYSTEM_ITEMS',FND_LOG.LEVEL_EVENT);
394:
395: FORALL i IN 1..l_tab_access_id.COUNT

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

414: CLOSE c_items_Cat_Set_Cat;
415:
416: END IF;
417:
418: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.INSERT_MTL_SYSTEM_ITEMS ',
419: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.INSERT_MTL_SYSTEM_ITEMS',FND_LOG.LEVEL_PROCEDURE);
420: EXCEPTION
421: WHEN others THEN
422: l_sqlerrno := TO_CHAR(SQLCODE);

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

422: l_sqlerrno := TO_CHAR(SQLCODE);
423: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
424: l_error_msg := ' Exception in INSERT_MTL_SYSTEM_ITEMS for user_id :'
425: || to_char(p_user_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
426: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.INSERT_MTL_SYSTEM_ITEMS',FND_LOG.LEVEL_EXCEPTION);
427: RAISE;
428: END INSERT_MTL_SYSTEM_ITEMS;
429:
430: PROCEDURE update_mtl_system_items(p_last_run_date IN DATE)

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

449: AND msi.organization_id = acc.organization_id
450: AND (msi.last_update_date >= b_last_date);
451:
452: BEGIN
453: CSM_UTIL_PKG.LOG('Entering CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.UPDATE_MTL_SYSTEM_ITEMS ',
454: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.UPDATE_MTL_SYSTEM_ITEMS',FND_LOG.LEVEL_PROCEDURE);
455:
456: l_run_date := SYSDATE;
457:

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

463: SELECT MAX(last_update_date) INTO l_max_last_update_date_tl
464: FROM mtl_system_items_tl;
465: IF(l_max_last_update_date_tl < p_last_run_date) THEN
466: -- No updates
467: CSM_UTIL_PKG.LOG('Leaving UPDATE_MTL_SYSTEM_ITEMS - No Updates ',
468: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.UPDATE_MTL_SYSTEM_ITEMS',FND_LOG.LEVEL_PROCEDURE);
469: RETURN;
470: END IF;
471: END IF;

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

478: FETCH c_changed BULK COLLECT INTO l_tab_access_id, l_tab_user_id LIMIT 200;
479: EXIT WHEN l_tab_access_id.COUNT = 0;
480:
481: IF l_tab_access_id.COUNT > 0 THEN
482: CSM_UTIL_PKG.LOG(l_tab_access_id.COUNT || ' records sent to olite for updating csm_mtl_system_items',
483: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.UPDATE_MTL_SYSTEM_ITEMS',FND_LOG.LEVEL_EVENT);
484:
485: -- do bulk makedirty
486: l_markdirty := asg_download.mark_dirty(

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

493: END IF;
494: END LOOP;
495: CLOSE c_changed;
496:
497: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.UPDATE_MTL_SYSTEM_ITEMS ',
498: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.UPDATE_MTL_SYSTEM_ITEMS',FND_LOG.LEVEL_PROCEDURE);
499: EXCEPTION
500: WHEN OTHERS THEN
501: l_sqlerrno := TO_CHAR(SQLCODE);

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

500: WHEN OTHERS THEN
501: l_sqlerrno := TO_CHAR(SQLCODE);
502: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
503: l_error_msg := ' Exception in UPDATE_MTL_SYSTEM_ITEMS :' || l_sqlerrno || ':' || l_sqlerrmsg;
504: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.UPDATE_MTL_SYSTEM_ITEMS',FND_LOG.LEVEL_EXCEPTION);
505: RAISE;
506: END UPDATE_MTL_SYSTEM_ITEMS;
507:
508: PROCEDURE delete_mtl_system_items(p_user_id IN NUMBER,

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

521: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
522: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
523:
524: BEGIN
525: CSM_UTIL_PKG.LOG('Entering CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.DELETE_MTL_SYSTEM_ITEMS ',
526: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.DELETE_MTL_SYSTEM_ITEMS',FND_LOG.LEVEL_PROCEDURE);
527:
528: l_run_date := SYSDATE;
529:

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

586: FORALL i IN 1..l_tab_access_id.COUNT
587: DELETE FROM csm_mtl_system_items_acc WHERE access_id = l_tab_access_id(i);
588: END IF;
589:
590: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.DELETE_MTL_SYSTEM_ITEMS ',
591: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.DELETE_MTL_SYSTEM_ITEMS',FND_LOG.LEVEL_PROCEDURE);
592: EXCEPTION
593: WHEN others THEN
594: l_sqlerrno := TO_CHAR(SQLCODE);

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

592: EXCEPTION
593: WHEN others THEN
594: l_sqlerrno := TO_CHAR(SQLCODE);
595: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
596: CSM_UTIL_PKG.LOG('Exception in CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.DELETE_MTL_SYSTEM_ITEMS: ' || l_sqlerrno || ':' || l_sqlerrmsg,
597: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.DELETE_MTL_SYSTEM_ITEMS',FND_LOG.LEVEL_EXCEPTION);
598: RAISE;
599: END DELETE_MTL_SYSTEM_ITEMS;
600:

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

621:
622: r_org c_org%ROWTYPE;
623:
624: BEGIN
625: CSM_UTIL_PKG.LOG('Entering CONCURRENT_PROCESS_USER for user_id: ' || TO_CHAR(p_user_id),
626: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.CONCURRENT_PROCESS_USER',FND_LOG.LEVEL_PROCEDURE);
627:
628: /* Get old profile settings */
629: OPEN c_org( p_user_id );

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

628: /* Get old profile settings */
629: OPEN c_org( p_user_id );
630: FETCH c_org INTO r_org;
631: IF c_org%NOTFOUND THEN -- should not occur
632: CSM_UTIL_PKG.LOG('Profile record not found in csm_user_inventory_org for user_id: ' || TO_CHAR(p_user_id)
633: || ' - Inserting all mtl_system_items',
634: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.CONCURRENT_PROCESS_USER',FND_LOG.LEVEL_PROCEDURE);
635: get_new_user_mtl_system_items(p_user_id=>p_user_id, p_organization_id=>p_organization_id,
636: p_category_set_id=>p_category_set_id, p_category_id=>p_category_id);

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

673: END IF;
674:
675: IF NVL(p_organization_id, -1) <> NVL(r_org.organization_id, -1)
676: OR l_cat_filter_changed THEN
677: CSM_UTIL_PKG.LOG('Deleting records for old profile settings for user_id: ' || TO_CHAR(p_user_id),
678: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.CONCURRENT_PROCESS_USER',FND_LOG.LEVEL_PROCEDURE);
679:
680: -- delete labor/expense items only and then re-insert for the new orgif org changes
681: IF NVL(p_organization_id, -1) <> NVL(r_org.organization_id,-1) THEN

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

690: p_organization_id=>r_org.organization_id,
691: p_category_set_id=>r_org.category_set_id,
692: p_category_id=>r_org.category_id);
693:
694: CSM_UTIL_PKG.LOG('Inserting records for new profile settings for user_id: ' || TO_CHAR(p_user_id),
695: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.CONCURRENT_PROCESS_USER',FND_LOG.LEVEL_PROCEDURE);
696:
697: insert_mtl_system_items(p_user_id=>p_user_id,
698: p_organization_id=>p_organization_id,

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

700: p_category_id=>p_category_id,
701: p_last_run_date=>NULL,
702: p_changed=>'Y');
703:
704: CSM_UTIL_PKG.LOG('Update csm_user_inventory_org with new profile settings for user_id: ' || TO_CHAR(p_user_id),
705: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.CONCURRENT_PROCESS_USER',FND_LOG.LEVEL_PROCEDURE);
706:
707: UPDATE csm_user_inventory_org
708: SET organization_id = p_organization_id

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

713:
714: ELSE
715: -- profiles are the same
716: -- get any new changes
717: CSM_UTIL_PKG.LOG('Getting new items for same profile settings for user_id: ' || TO_CHAR(p_user_id),
718: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.CONCURRENT_PROCESS_USER',FND_LOG.LEVEL_PROCEDURE);
719:
720: insert_mtl_system_items(p_user_id=>p_user_id,
721: p_organization_id=>p_organization_id,

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

726: END IF;
727: END IF;
728: CLOSE c_org;
729:
730: CSM_UTIL_PKG.LOG('Leaving CONCURRENT_PROCESS_USER for user_id: ' || TO_CHAR(p_user_id),
731: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.CONCURRENT_PROCESS_USER',FND_LOG.LEVEL_PROCEDURE);
732: EXCEPTION
733: WHEN OTHERS THEN
734: l_sqlerrno := TO_CHAR(SQLCODE);

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

734: l_sqlerrno := TO_CHAR(SQLCODE);
735: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
736: l_error_msg := ' Exception in concurrent_process_user for user_id :'
737: || TO_CHAR(p_user_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
738: CSM_UTIL_PKG.LOG(l_error_msg, 'csm_mtl_system_items_event_pkg.concurrent_process_user',FND_LOG.LEVEL_EXCEPTION);
739: RAISE;
740: END CONCURRENT_PROCESS_USER;
741:
742: PROCEDURE Refresh_mtl_system_items_acc(p_status OUT NOCOPY VARCHAR2,

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

761: WHERE package_name = 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG'
762: AND procedure_name = 'REFRESH_MTL_SYSTEM_ITEMS_ACC';
763:
764: BEGIN
765: CSM_UTIL_PKG.LOG('Entering CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.Refresh_mtl_system_items_acc ',
766: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.Refresh_mtl_system_items_acc',FND_LOG.LEVEL_PROCEDURE);
767:
768: l_run_date := SYSDATE;
769:

Line 781: l_all_omfs_user_list := csm_util_pkg.get_all_omfs_palm_user_list;

777: COMMIT;
778:
779: -- get user list of all omfs users
780: l_all_omfs_user_list := l_null_omfs_user_list;
781: l_all_omfs_user_list := csm_util_pkg.get_all_omfs_palm_user_list;
782:
783: FOR i IN 1..l_all_omfs_user_list.COUNT LOOP
784: l_user_id := l_all_omfs_user_list(i);
785: l_user_organization_id := csm_profile_pkg.get_organization_id(l_user_id);

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

804:
805: p_status := 'FINE';
806: p_message := 'csm_mtl_system_items_event_pkg.refresh_system_items executed successfully';
807:
808: CSM_UTIL_PKG.LOG('Leaving csm_mtl_system_items_event_pkg.Refresh_mtl_system_items_acc ',
809: 'csm_mtl_system_items_event_pkg.Refresh_mtl_system_items_acc',FND_LOG.LEVEL_PROCEDURE);
810: EXCEPTION
811: WHEN others THEN
812: l_sqlerrno := TO_CHAR(SQLCODE);

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

813: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
814: p_status := 'ERROR';
815: p_message := 'Error in CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.REFRESH_MTL_SYSTEM_ITEMS_ACC: ' || l_sqlerrno || ':' || l_sqlerrmsg;
816: ROLLBACK;
817: csm_util_pkg.log('CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.REFRESH_MTL_SYSTEM_ITEMS_ACC ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);
818: END REFRESH_MTL_SYSTEM_ITEMS_ACC;
819:
820: PROCEDURE get_new_user_mtl_system_items(p_user_id IN NUMBER, p_organization_id IN NUMBER,
821: p_category_set_id IN NUMBER, p_category_id IN NUMBER)

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

825: l_error_msg VARCHAR2(4000);
826: l_return_status VARCHAR2(2000);
827:
828: BEGIN
829: CSM_UTIL_PKG.LOG('Entering CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.get_new_user_mtl_system_items ',
830: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.get_new_user_mtl_system_items',FND_LOG.LEVEL_PROCEDURE);
831:
832: insert_mtl_system_items(p_user_id=>p_user_id,
833: p_organization_id=>p_organization_id,

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

835: p_category_id=>p_category_id,
836: p_last_run_date=>NULL,
837: p_changed=>'N'); -- new user, no profiles are changed
838:
839: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.get_new_user_mtl_system_items ',
840: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.get_new_user_mtl_system_items',FND_LOG.LEVEL_PROCEDURE);
841:
842: EXCEPTION
843: WHEN others THEN

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

844: l_sqlerrno := TO_CHAR(SQLCODE);
845: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
846: l_error_msg := ' Exception in get_new_user_mtl_system_items for user_id :'
847: || to_char(p_user_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
848: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.get_new_user_mtl_system_items',FND_LOG.LEVEL_EXCEPTION);
849: RAISE;
850: END get_new_user_mtl_system_items;
851:
852: PROCEDURE mtl_system_items_acc_i(p_inventory_item_id IN NUMBER,

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

856: x_return_status IN OUT NOCOPY VARCHAR2)
857: IS
858: BEGIN
859: x_return_status := FND_API.G_RET_STS_SUCCESS;
860: CSM_UTIL_PKG.LOG('Entering CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.MTL_SYSTEM_ITEMS_ACC_I ',
861: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.MTL_SYSTEM_ITEMS_ACC_I',FND_LOG.LEVEL_PROCEDURE);
862:
863: IF p_inventory_item_id IS NOT NULL AND p_organization_id IS NOT NULL THEN
864: CSM_ACC_PKG.Insert_Acc

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

874:
875: END IF;
876:
877: p_error_msg := 'SUCCESS';
878: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.MTL_SYSTEM_ITEMS_ACC_I ',
879: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.MTL_SYSTEM_ITEMS_ACC_I',FND_LOG.LEVEL_PROCEDURE);
880: EXCEPTION
881: WHEN others THEN
882: x_return_status := FND_API.G_RET_STS_ERROR;

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

880: EXCEPTION
881: WHEN others THEN
882: x_return_status := FND_API.G_RET_STS_ERROR;
883: p_error_msg := ' FAILED MTL_SYSTEM_ITEMS_ACC_I INVENTORY_ITEM_ID: ' || to_char(p_inventory_item_id) || SUBSTR(SQLERRM,1,2000);
884: CSM_UTIL_PKG.LOG(p_error_msg, 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.MTL_SYSTEM_ITEMS_ACC_I',FND_LOG.LEVEL_EXCEPTION);
885: RAISE;
886: END MTL_SYSTEM_ITEMS_ACC_I;
887:
888: PROCEDURE mtl_system_items_acc_d(p_inventory_item_id IN NUMBER,

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

892: x_return_status IN OUT NOCOPY VARCHAR2)
893: IS
894: BEGIN
895: x_return_status := FND_API.G_RET_STS_SUCCESS;
896: CSM_UTIL_PKG.LOG('Entering CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.MTL_SYSTEM_ITEMS_ACC_D',
897: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.MTL_SYSTEM_ITEMS_ACC_D',FND_LOG.LEVEL_PROCEDURE);
898:
899: IF p_inventory_item_id IS NOT NULL AND p_organization_id IS NOT NULL THEN
900: CSM_ACC_PKG.Delete_Acc

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

908: );
909: END IF;
910:
911: p_error_msg := 'SUCCESS';
912: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.MTL_SYSTEM_ITEMS_ACC_D ',
913: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.MTL_SYSTEM_ITEMS_ACC_D',FND_LOG.LEVEL_PROCEDURE);
914: EXCEPTION
915: WHEN others THEN
916: x_return_status := FND_API.G_RET_STS_ERROR;

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

914: EXCEPTION
915: WHEN others THEN
916: x_return_status := FND_API.G_RET_STS_ERROR;
917: p_error_msg := ' FAILED MTL_SYSTEM_ITEMS_ACC_D INVENTORY_ITEM_ID: ' || to_char(p_inventory_item_id) || SUBSTR(SQLERRM,1,2000);
918: CSM_UTIL_PKG.LOG(p_error_msg, 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.MTL_SYSTEM_ITEMS_ACC_D',FND_LOG.LEVEL_EXCEPTION);
919: RAISE;
920: END MTL_SYSTEM_ITEMS_ACC_D;
921:
922: END CSM_MTL_SYSTEM_ITEMS_EVENT_PKG;