APPS.CSM_MTL_TXN_REASONS_EVENT_PKG dependencies on CSM_UTIL_PKG

Line 89: CSM_UTIL_PKG.LOG('Entering CSM_MTL_TXN_REASONS_EVENT_PKG.Refresh_mtl_txn_reasons_acc ',

85: l_reason_id_tbl reason_id_tbl_typ;
86:
87: BEGIN
88:
89: CSM_UTIL_PKG.LOG('Entering CSM_MTL_TXN_REASONS_EVENT_PKG.Refresh_mtl_txn_reasons_acc ',
90: 'CSM_MTL_TXN_REASONS_EVENT_PKG.Refresh_mtl_txn_reasons_acc',FND_LOG.LEVEL_PROCEDURE);
91:
92: -- data program is run
93: l_run_date := SYSDATE;

Line 106: l_all_omfs_palm_resource_list := csm_util_pkg.get_all_omfs_palm_res_list;

102: END IF;
103:
104: -- get resource list of all omfs palm users
105: l_all_omfs_palm_resource_list := l_null_palm_omfs_resource_list;
106: l_all_omfs_palm_resource_list := csm_util_pkg.get_all_omfs_palm_res_list;
107:
108: CSM_UTIL_PKG.LOG('Entering deletes ', 'CSM_MTL_TXN_REASONS_EVENT_PKG.Refresh_mtl_txn_reasons_acc',FND_LOG.LEVEL_PROCEDURE);
109:
110: -- process all deletes

Line 108: CSM_UTIL_PKG.LOG('Entering deletes ', 'CSM_MTL_TXN_REASONS_EVENT_PKG.Refresh_mtl_txn_reasons_acc',FND_LOG.LEVEL_PROCEDURE);

104: -- get resource list of all omfs palm users
105: l_all_omfs_palm_resource_list := l_null_palm_omfs_resource_list;
106: l_all_omfs_palm_resource_list := csm_util_pkg.get_all_omfs_palm_res_list;
107:
108: CSM_UTIL_PKG.LOG('Entering deletes ', 'CSM_MTL_TXN_REASONS_EVENT_PKG.Refresh_mtl_txn_reasons_acc',FND_LOG.LEVEL_PROCEDURE);
109:
110: -- process all deletes
111: OPEN l_del_mtl_txn_reasons_csr(l_prog_update_date);
112: FETCH l_del_mtl_txn_reasons_csr BULK COLLECT INTO l_access_id_tbl;

Line 118: l_mark_dirty := csm_util_pkg.MakeDirtyForResource(g_pub_item,

114:
115: IF l_access_id_tbl.count > 0 THEN
116: FOR i IN 1..l_access_id_tbl.count LOOP
117: FOR j IN 1..l_all_omfs_palm_resource_list.count LOOP
118: l_mark_dirty := csm_util_pkg.MakeDirtyForResource(g_pub_item,
119: l_access_id_tbl(i),
120: l_all_omfs_palm_resource_list(j),
121: asg_download.del,
122: l_run_date);

Line 134: CSM_UTIL_PKG.LOG('Leaving deletes and entering updates', 'CSM_MTL_TXN_REASONS_EVENT_PKG.Refresh_mtl_txn_reasons_acc',FND_LOG.LEVEL_PROCEDURE);

130:
131: l_access_id_tbl.delete;
132: END IF; -- end of process deletes
133:
134: CSM_UTIL_PKG.LOG('Leaving deletes and entering updates', 'CSM_MTL_TXN_REASONS_EVENT_PKG.Refresh_mtl_txn_reasons_acc',FND_LOG.LEVEL_PROCEDURE);
135:
136: -- process all updates
137: OPEN l_upd_mtl_txn_reasons_csr(l_prog_update_date);
138: FETCH l_upd_mtl_txn_reasons_csr BULK COLLECT INTO l_access_id_tbl;

Line 144: l_mark_dirty := csm_util_pkg.MakeDirtyForResource(g_pub_item,

140:
141: IF l_access_id_tbl.count > 0 THEN
142: FOR i IN 1..l_access_id_tbl.count LOOP
143: FOR j IN 1..l_all_omfs_palm_resource_list.count LOOP
144: l_mark_dirty := csm_util_pkg.MakeDirtyForResource(g_pub_item,
145: l_access_id_tbl(i),
146: l_all_omfs_palm_resource_list(j),
147: asg_download.upd,
148: l_run_date);

Line 160: CSM_UTIL_PKG.LOG('Leaving updates and entering inserts', 'CSM_MTL_TXN_REASONS_EVENT_PKG.Refresh_mtl_txn_reasons_acc',FND_LOG.LEVEL_PROCEDURE);

156: IF l_reason_id_tbl.count > 0 THEN
157: l_reason_id_tbl.delete;
158: END IF;
159:
160: CSM_UTIL_PKG.LOG('Leaving updates and entering inserts', 'CSM_MTL_TXN_REASONS_EVENT_PKG.Refresh_mtl_txn_reasons_acc',FND_LOG.LEVEL_PROCEDURE);
161:
162: --process all inserts
163: OPEN l_ins_mtl_txn_reasons_csr(l_prog_update_date);
164: FETCH l_ins_mtl_txn_reasons_csr BULK COLLECT INTO l_access_id_tbl, l_reason_id_tbl;

Line 172: l_mark_dirty := csm_util_pkg.MakeDirtyForResource(g_pub_item,

168:
169: IF l_access_id_tbl.count > 0 THEN
170: FOR i IN 1..l_access_id_tbl.count LOOP
171: FOR j IN 1..l_all_omfs_palm_resource_list.count LOOP
172: l_mark_dirty := csm_util_pkg.MakeDirtyForResource(g_pub_item,
173: l_access_id_tbl(i),
174: l_all_omfs_palm_resource_list(j),
175: asg_download.ins,
176: l_run_date);

Line 199: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_TXN_REASONS_EVENT_PKG.Refresh_mtl_txn_reasons_acc ',

195:
196: p_status := 'FINE';
197: p_message := 'CSM_MTL_TXN_REASONS_EVENT_PKG.REFRESH_MTL_TXN_REASONS_ACC Executed successfully';
198:
199: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_TXN_REASONS_EVENT_PKG.Refresh_mtl_txn_reasons_acc ',
200: 'CSM_MTL_TXN_REASONS_EVENT_PKG.Refresh_mtl_txn_reasons_acc',FND_LOG.LEVEL_PROCEDURE);
201:
202: EXCEPTION
203: WHEN others THEN

Line 209: CSM_UTIL_PKG.LOG('Exception in CSM_MTL_TXN_REASONS_EVENT_PKG.REFRESH_MTL_TXN_REASONS_ACC: ' || l_sqlerrno || ':' || l_sqlerrmsg,

205: l_sqlerrmsg := substr(SQLERRM, 1,2000);
206: p_status := 'ERROR';
207: p_message := 'Error in CSM_MTL_TXN_REASONS_EVENT_PKG.REFRESH_MTL_TXN_REASONS_ACC: '|| l_sqlerrno || ':' || l_sqlerrmsg;
208: ROLLBACK;
209: CSM_UTIL_PKG.LOG('Exception in CSM_MTL_TXN_REASONS_EVENT_PKG.REFRESH_MTL_TXN_REASONS_ACC: ' || l_sqlerrno || ':' || l_sqlerrmsg,
210: 'CSM_MTL_TXN_REASONS_EVENT_PKG.REFRESH_MTL_TXN_REASONS_ACC',FND_LOG.LEVEL_EXCEPTION);
211: END REFRESH_MTL_TXN_REASONS_ACC;
212:
213: END CSM_MTL_TXN_REASONS_EVENT_PKG;