DBA Data[Home] [Help]

APPS.CSI_INV_HZ_PKG dependencies on CSI_INV_HZ_PKG

Line 1: package body CSI_INV_HZ_PKG as

1: package body CSI_INV_HZ_PKG as
2: -- $Header: csiivtzb.pls 120.13.12020000.2 2012/07/04 10:28:08 sjawaji ship $
3:
4: l_debug NUMBER := csi_t_gen_utility_pvt.g_debug_level;
5:

Line 13: l_api_name VARCHAR2(100) := 'CSI_INV_HZ_PKG.ISSUE_TO_HZ_LOC';

9: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)
10: IS
11:
12: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
13: l_api_name VARCHAR2(100) := 'CSI_INV_HZ_PKG.ISSUE_TO_HZ_LOC';
14: l_api_version NUMBER := 1.0;
15: l_commit VARCHAR2(1) := FND_API.G_FALSE;
16: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
17: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;

Line 103: csi_t_gen_utility_pvt.add('*****Start of csi_inv_hz_pkg.issue_to_hz_loc Transaction procedure*****');

99:
100: x_return_status := l_fnd_success;
101:
102: IF (l_debug > 0) THEN
103: csi_t_gen_utility_pvt.add('*****Start of csi_inv_hz_pkg.issue_to_hz_loc Transaction procedure*****');
104: csi_t_gen_utility_pvt.add('Start time: '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
105: csi_t_gen_utility_pvt.add('Transaction You are Processing is: '||p_transaction_id);
106: csi_t_gen_utility_pvt.add('csiivtzb.pls 115.14');
107: END IF;

Line 809: csi_t_gen_utility_pvt.add('*****End of csi_inv_hz_pkg.issue_to_hz_loc Transaction procedure*****');

805: END LOOP; -- End of For Loop
806:
807: IF (l_debug > 0) THEN
808: csi_t_gen_utility_pvt.add('End time: '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
809: csi_t_gen_utility_pvt.add('*****End of csi_inv_hz_pkg.issue_to_hz_loc Transaction procedure*****');
810: END IF;
811:
812: EXCEPTION
813: WHEN fnd_api.g_exc_error THEN

Line 881: l_api_name VARCHAR2(100) := 'CSI_INV_HZ_PKG.MISC_RECEIPT_HZ_LOC';

877: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)
878: IS
879:
880: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
881: l_api_name VARCHAR2(100) := 'CSI_INV_HZ_PKG.MISC_RECEIPT_HZ_LOC';
882: l_api_version NUMBER := 1.0;
883: l_commit VARCHAR2(1) := FND_API.G_FALSE;
884: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
885: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;

Line 978: csi_t_gen_utility_pvt.add('*****Start of csi_inv_hz_pkg.misc_receipt_hz_loc Transaction procedure*****');

974:
975: x_return_status := l_fnd_success;
976:
977: IF (l_debug > 0) THEN
978: csi_t_gen_utility_pvt.add('*****Start of csi_inv_hz_pkg.misc_receipt_hz_loc Transaction procedure*****');
979: csi_t_gen_utility_pvt.add('Start time: '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
980: csi_t_gen_utility_pvt.add('Transaction You are Processing is: '||p_transaction_id);
981: csi_t_gen_utility_pvt.add('csiivtzb.pls 115.14');
982: END IF;

Line 2207: csi_t_gen_utility_pvt.add('*****End of csi_inv_hz_pkg.misc_receipt_hz_loc Transaction procedure*****');

2203: END LOOP; -- End of For Loop
2204:
2205: IF (l_debug > 0) THEN
2206: csi_t_gen_utility_pvt.add('End time: '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
2207: csi_t_gen_utility_pvt.add('*****End of csi_inv_hz_pkg.misc_receipt_hz_loc Transaction procedure*****');
2208: END IF;
2209:
2210: EXCEPTION
2211: WHEN fnd_api.g_exc_error THEN

Line 2369: csi_t_gen_utility_pvt.add('*****Start of csi_inv_hz_pkg.misc_issue_hz_loc Transaction procedure*****');

2365:
2366: x_return_status := l_fnd_success;
2367:
2368: IF (l_debug > 0) THEN
2369: csi_t_gen_utility_pvt.add('*****Start of csi_inv_hz_pkg.misc_issue_hz_loc Transaction procedure*****');
2370: csi_t_gen_utility_pvt.add('Start time: '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
2371: csi_t_gen_utility_pvt.add('Transaction You are Processing is: '||p_transaction_id);
2372: csi_t_gen_utility_pvt.add('csiivtzb.pls 115.14');
2373: END IF;

Line 3066: csi_t_gen_utility_pvt.add('*****End of csi_inv_hz_pkg.misc_issue_hz_loc Transaction procedure*****');

3062: END LOOP; -- End of For Loop
3063:
3064: IF (l_debug > 0) THEN
3065: csi_t_gen_utility_pvt.add('End time: '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
3066: csi_t_gen_utility_pvt.add('*****End of csi_inv_hz_pkg.misc_issue_hz_loc Transaction procedure*****');
3067: END IF;
3068:
3069: EXCEPTION
3070: WHEN fnd_api.g_exc_error THEN

Line 3131: END CSI_INV_HZ_PKG;

3127: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
3128:
3129: END misc_issue_hz_loc;
3130:
3131: END CSI_INV_HZ_PKG;