APPS.CSL_CSI_ITEM_INSTANCES_ACC_PKG dependencies on CSL_CSI_ITEM_INSTANCES_ACC_PKG

Line 1: PACKAGE BODY CSL_CSI_ITEM_INSTANCES_ACC_PKG AS

1: PACKAGE BODY CSL_CSI_ITEM_INSTANCES_ACC_PKG AS
2: /* $Header: csliiacb.pls 120.0 2005/05/25 11:05:37 appldev noship $ */
3:
4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_CSI_ITEM_INSTANCES_ACC';

Line 98: where package_name = 'CSL_CSI_ITEM_INSTANCES_ACC_PKG'

94: /*** get the last run date of the concurent program ***/
95: CURSOR c_LastRundate IS
96: select LAST_RUN_DATE
97: from JTM_CON_REQUEST_DATA
98: where package_name = 'CSL_CSI_ITEM_INSTANCES_ACC_PKG'
99: AND procedure_name = 'CON_ITEM_ATTR';
100: r_LastRundate c_LastRundate%ROWTYPE;
101:
102: CURSOR c_insert_diffs(b_last_run_date date) IS

Line 237: WHERE package_name = 'CSL_CSI_ITEM_INSTANCES_ACC_PKG'

233: */
234:
235: /*Update the last run date*/
236: UPDATE jtm_con_request_data SET last_run_date = l_current_run_date
237: WHERE package_name = 'CSL_CSI_ITEM_INSTANCES_ACC_PKG'
238: AND procedure_name = 'CON_ITEM_ATTR';
239:
240: COMMIT;
241:

Line 252: p_message := 'CSL_CSI_ITEM_INSTANCES_ACC_PKG.CON_ITEM_ATTR Executed successfully';

248: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
249: END IF;
250:
251: p_status := 'FINE';
252: p_message := 'CSL_CSI_ITEM_INSTANCES_ACC_PKG.CON_ITEM_ATTR Executed successfully';
253:
254: EXCEPTION
255:
256: WHEN OTHERS THEN

Line 258: p_message := 'Error in CSL_CSI_ITEM_INSTANCES_ACC_PKG.CON_ITEM_ATTR: ' || substr(SQLERRM, 1, 2000);

254: EXCEPTION
255:
256: WHEN OTHERS THEN
257: p_status := 'ERROR';
258: p_message := 'Error in CSL_CSI_ITEM_INSTANCES_ACC_PKG.CON_ITEM_ATTR: ' || substr(SQLERRM, 1, 2000);
259: jtm_message_log_pkg.Log_Msg
260: (0,
261: 'CSL_CSI_ITEM_ATTR_ACC',
262: 'Exception occured in CON_ITEM_ATTR ',

Line 1391: fnd_msg_pub.Add_Exc_Msg('CSL_CSI_ITEM_INSTANCES_ACC_PKG','POST_INSERT_ITEM_INSTANCE',sqlerrm);

1387: , g_table_name
1388: , 'Caught exception in POST_INSERT hook:' || fnd_global.local_chr(10) || sqlerrm
1389: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
1390: END IF;
1391: fnd_msg_pub.Add_Exc_Msg('CSL_CSI_ITEM_INSTANCES_ACC_PKG','POST_INSERT_ITEM_INSTANCE',sqlerrm);
1392: -- x_return_status := FND_API.G_RET_STS_ERROR;
1393: x_return_status := FND_API.G_RET_STS_SUCCESS;
1394: END POST_INSERT_ITEM_INSTANCE;
1395:

Line 1619: END CSL_CSI_ITEM_INSTANCES_ACC_PKG;

1615: END IF;
1616:
1617: END CONC_ITEM_INSTANCES;
1618:
1619: END CSL_CSI_ITEM_INSTANCES_ACC_PKG;