DBA Data[Home] [Help]

APPS.CSE_GL_INTERFACE_PKG dependencies on CSE_UTIL_PKG

Line 173: CSE_UTIL_PKG.write_log('Error in GET_GL_INTERF_CD : ' || SQLERRM);

169:
170: EXCEPTION
171: WHEN OTHERS
172: THEN
173: CSE_UTIL_PKG.write_log('Error in GET_GL_INTERF_CD : ' || SQLERRM);
174: END get_gl_interface_code ;
175:
176: PROCEDURE CREATE_GL_ENTRIES (
177: x_return_status OUT NOCOPY VARCHAR2,

Line 504: -- CSE_UTIL_PKG.CHECK_DEPRECIABLE( p_inventory_item_id => l_cii_inventory_item_id,

500: If l_total_txn_qty = 0 then
501: l_total_txn_qty := 1;
502: END IF;
503:
504: -- CSE_UTIL_PKG.CHECK_DEPRECIABLE( p_inventory_item_id => l_cii_inventory_item_id,
505: -- p_depreciable => l_depreciable );
506:
507: -- IF (l_debug = 'Y')
508: -- THEN

Line 526: cse_util_pkg.get_redeploy_flag (

522: -- l_srl_flag := 'Y';
523: -- for redeploy , already cursor csi_srl_rec filters for expired CIA
524: FOR csi_srl_rec in csi_srl_cur(csi_pending_txn_rec.transaction_id)
525: LOOP
526: cse_util_pkg.get_redeploy_flag (
527: p_inventory_item_id => csi_srl_rec.inventory_item_id
528: ,p_serial_number => csi_srl_rec.serial_number
529: ,p_transaction_date => csi_srl_rec.transaction_date
530: ,x_redeploy_flag => l_redeploy_flag

Line 966: CSE_UTIL_PKG.write_log('Error in CREATE_GL_ENTRIES CSI_TXN_ID: '

962: -- This exception would catch no_data_found on MMT and other tables and skip
963: -- to next cursor record.
964: WHEN no_data_found
965: THEN
966: CSE_UTIL_PKG.write_log('Error in CREATE_GL_ENTRIES CSI_TXN_ID: '
967: ||to_char(csi_pending_txn_rec.transaction_id)
968: || ' CSI_MMT_TXN_ID: '
969: || to_char(csi_pending_txn_rec.inv_material_transaction_id)
970: || l_error_message ) ;

Line 973: CSE_UTIL_PKG.write_log('Error in CREATE_GL_ENTRIES Redeploy CSI_TXN_ID: '

969: || to_char(csi_pending_txn_rec.inv_material_transaction_id)
970: || l_error_message ) ;
971: WHEN e_redeploy_error
972: THEN
973: CSE_UTIL_PKG.write_log('Error in CREATE_GL_ENTRIES Redeploy CSI_TXN_ID: '
974: || to_char(csi_pending_txn_rec.transaction_id)
975: || ' CSI_MMT_TXN_ID: '
976: || to_char(csi_pending_txn_rec.inv_material_transaction_id)
977: || l_error_message);

Line 985: CSE_UTIL_PKG.write_log('Error in CREATE_GL_ENTRIES :' || l_error_message);

981: debug(' End date : '||to_char(sysdate,'dd-mon-yyyy hh24:mi:ss'));
982: EXCEPTION
983: WHEN e_error
984: THEN
985: CSE_UTIL_PKG.write_log('Error in CREATE_GL_ENTRIES :' || l_error_message);
986: WHEN OTHERS
987: THEN
988: CSE_UTIL_PKG.write_log('Error in CREATE_GL_ENTRIES : ' || SQLERRM);
989: END CREATE_GL_ENTRIES ;

Line 988: CSE_UTIL_PKG.write_log('Error in CREATE_GL_ENTRIES : ' || SQLERRM);

984: THEN
985: CSE_UTIL_PKG.write_log('Error in CREATE_GL_ENTRIES :' || l_error_message);
986: WHEN OTHERS
987: THEN
988: CSE_UTIL_PKG.write_log('Error in CREATE_GL_ENTRIES : ' || SQLERRM);
989: END CREATE_GL_ENTRIES ;
990:
991: END CSE_GL_INTERFACE_PKG ;