DBA Data[Home] [Help]

APPS.CSM_CSP_REQ_LINES_EVENT_PKG dependencies on FND_GLOBAL

Line 283: , 'Caught exception in CONC_ORDER_UPDATE hook:' || fnd_global.local_chr(10) || sqlerrm

279: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
280: jtm_message_log_pkg.Log_Msg
281: ( 1
282: , g_table_name1
283: , 'Caught exception in CONC_ORDER_UPDATE hook:' || fnd_global.local_chr(10) || sqlerrm
284: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
285: END IF;
286: fnd_msg_pub.Add_Exc_Msg('CSM_CSP_REQ_LINES_EVENT_PKG','CONC_ORDER_UPDATE',sqlerrm);
287: END CONC_ORDER_UPDATE;

Line 332: CSM_UTIL_PKG.LOG('Processing req_line_id:'||l_req_line_id||fnd_global.local_chr(10)||'req line detail_id:'||l_req_line_detail_id

328: 'CSM_CSP_REQ_LINES_EVENT_PKG.REQ_LINE_DTL_IUD',FND_LOG.LEVEL_PROCEDURE);
329:
330: SELECT REQUIREMENT_LINE_ID,SOURCE_TYPE,SOURCE_ID INTO l_req_line_id,l_src,l_src_id FROM CSP_REQ_LINE_DETAILS WHERE req_line_detail_id=l_req_line_detail_id;
331:
332: CSM_UTIL_PKG.LOG('Processing req_line_id:'||l_req_line_id||fnd_global.local_chr(10)||'req line detail_id:'||l_req_line_detail_id
333: ||fnd_global.local_chr(10)||'src type:'||l_src
334: ||fnd_global.local_chr(10)||'src id:'||l_src_id, 'CSM_CSP_REQ_LINES_EVENT_PKG.REQ_LINE_DTL_IUD', FND_LOG.LEVEL_PROCEDURE );
335:
336: OPEN c_get_dtl;

Line 333: ||fnd_global.local_chr(10)||'src type:'||l_src

329:
330: SELECT REQUIREMENT_LINE_ID,SOURCE_TYPE,SOURCE_ID INTO l_req_line_id,l_src,l_src_id FROM CSP_REQ_LINE_DETAILS WHERE req_line_detail_id=l_req_line_detail_id;
331:
332: CSM_UTIL_PKG.LOG('Processing req_line_id:'||l_req_line_id||fnd_global.local_chr(10)||'req line detail_id:'||l_req_line_detail_id
333: ||fnd_global.local_chr(10)||'src type:'||l_src
334: ||fnd_global.local_chr(10)||'src id:'||l_src_id, 'CSM_CSP_REQ_LINES_EVENT_PKG.REQ_LINE_DTL_IUD', FND_LOG.LEVEL_PROCEDURE );
335:
336: OPEN c_get_dtl;
337: FETCH c_get_dtl BULK COLLECT INTO l_tab_access_id,l_tab_user_id,l_tab_old_src_id;

Line 334: ||fnd_global.local_chr(10)||'src id:'||l_src_id, 'CSM_CSP_REQ_LINES_EVENT_PKG.REQ_LINE_DTL_IUD', FND_LOG.LEVEL_PROCEDURE );

330: SELECT REQUIREMENT_LINE_ID,SOURCE_TYPE,SOURCE_ID INTO l_req_line_id,l_src,l_src_id FROM CSP_REQ_LINE_DETAILS WHERE req_line_detail_id=l_req_line_detail_id;
331:
332: CSM_UTIL_PKG.LOG('Processing req_line_id:'||l_req_line_id||fnd_global.local_chr(10)||'req line detail_id:'||l_req_line_detail_id
333: ||fnd_global.local_chr(10)||'src type:'||l_src
334: ||fnd_global.local_chr(10)||'src id:'||l_src_id, 'CSM_CSP_REQ_LINES_EVENT_PKG.REQ_LINE_DTL_IUD', FND_LOG.LEVEL_PROCEDURE );
335:
336: OPEN c_get_dtl;
337: FETCH c_get_dtl BULK COLLECT INTO l_tab_access_id,l_tab_user_id,l_tab_old_src_id;
338: CLOSE c_get_dtl;

Line 463: VALUES (l_access_id, l_tab_user_id(I),l_tab_item_id(I), l_tab_org_id(I), 1,fnd_global.user_id, sysdate, fnd_global.user_id, sysdate, fnd_global.login_id);

459: select csm_mtl_system_items_acc_s.NEXTVAL INTO l_access_id from dual;
460:
461: INSERT INTO csm_mtl_system_items_acc(access_id , user_id, inventory_item_id, organization_id, counter,
462: created_by, creation_date, last_updated_by, last_update_date, last_update_login)
463: VALUES (l_access_id, l_tab_user_id(I),l_tab_item_id(I), l_tab_org_id(I), 1,fnd_global.user_id, sysdate, fnd_global.user_id, sysdate, fnd_global.login_id);
464:
465: doMarkDirty('CSM_MTL_SYSTEM_ITEMS',l_access_id,l_tab_user_id(I),'I');
466:
467: END IF;