DBA Data[Home] [Help]

APPS.CSI_INV_INTERORG_PKG dependencies on CSI_INV_INTERORG_PKG

Line 1: package body CSI_INV_INTERORG_PKG as

1: package body CSI_INV_INTERORG_PKG as
2: -- $Header: csiorgtb.pls 120.3.12000000.5 2007/07/06 15:31:23 ngoutam ship $
3:
4: PROCEDURE debug(p_message IN varchar2) IS
5:

Line 20: l_api_name VARCHAR2(100) := 'CSI_INV_INTERORG_PKG.INTRANSIT_SHIPMENT';

16: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)
17: IS
18:
19: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
20: l_api_name VARCHAR2(100) := 'CSI_INV_INTERORG_PKG.INTRANSIT_SHIPMENT';
21: l_api_version NUMBER := 1.0;
22: l_commit VARCHAR2(1) := FND_API.G_FALSE;
23: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
24: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;

Line 124: debug('******Start of csi_inv_interorg_pkg.intransit_shipment Transaction procedure******');

120:
121: x_return_status := l_fnd_success;
122: l_error_message := NULL;
123:
124: debug('******Start of csi_inv_interorg_pkg.intransit_shipment Transaction procedure******');
125: debug('Start time: '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
126: debug('csiorgtb.pls 115.23');
127: debug('Transaction ID with is: '||p_transaction_id);
128:

Line 1117: debug('******End of csi_inv_interorg_pkg.intransit_shipment Transaction******');

1113: END IF; -- End of Serial Control If
1114: END LOOP; -- End of For Loop
1115:
1116: debug('End time: '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
1117: debug('******End of csi_inv_interorg_pkg.intransit_shipment Transaction******');
1118:
1119: EXCEPTION
1120: WHEN fnd_api.g_exc_error THEN
1121: debug('You have encountered a "fnd_api.g_exc_error" exception in the Inter-Organization Transaction - In Transit Shipment');

Line 1197: l_api_name VARCHAR2(100) := 'CSI_INV_INTERORG_PKG.INTRANSIT_RECEIPT';

1193: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)
1194: IS
1195:
1196: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
1197: l_api_name VARCHAR2(100) := 'CSI_INV_INTERORG_PKG.INTRANSIT_RECEIPT';
1198: l_api_version NUMBER := 1.0;
1199: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1200: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
1201: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;

Line 1314: debug('******Start of csi_inv_interorg_pkg.intransit_receipt Transaction procedure******');

1310:
1311: x_return_status := l_fnd_success;
1312: l_error_message := NULL;
1313:
1314: debug('******Start of csi_inv_interorg_pkg.intransit_receipt Transaction procedure******');
1315: debug('Start time: '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
1316: debug('csiorgtb.pls 115.23');
1317: debug('Transaction ID with is: '||p_transaction_id);
1318:

Line 2900: debug('******End of csi_inv_interorg_pkg.intransit_receipt Transaction******');

2896: END LOOP; -- End of For Loop
2897:
2898:
2899: debug('End time: '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
2900: debug('******End of csi_inv_interorg_pkg.intransit_receipt Transaction******');
2901:
2902: EXCEPTION
2903: WHEN fnd_api.g_exc_error THEN
2904: debug('You have encountered a "fnd_api.g_exc_error" exception in the Inter-Organization Transaction In Transit Receipt');

Line 2978: l_api_name VARCHAR2(100) := 'CSI_INV_INTERORG_PKG.DIRECT_SHIPMENT';

2974: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)
2975: IS
2976:
2977: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
2978: l_api_name VARCHAR2(100) := 'CSI_INV_INTERORG_PKG.DIRECT_SHIPMENT';
2979: l_api_version NUMBER := 1.0;
2980: l_commit VARCHAR2(1) := FND_API.G_FALSE;
2981: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
2982: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;

Line 3112: debug('******Start of csi_inv_interorg_pkg.direct_shipment Transaction procedure******');

3108:
3109: x_return_status := l_fnd_success;
3110: l_error_message := NULL;
3111:
3112: debug('******Start of csi_inv_interorg_pkg.direct_shipment Transaction procedure******');
3113: debug('Start time: '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
3114: debug('csiorgtb.pls 115.23');
3115: debug('Transaction ID with is: '||p_transaction_id);
3116:

Line 4098: debug('******End of csi_inv_interorg_pkg.direct_shipment Transaction******');

4094: END IF; -- End of Serial Control IF
4095: END LOOP; -- End of main For Inv Loop
4096:
4097: debug('End time: '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
4098: debug('******End of csi_inv_interorg_pkg.direct_shipment Transaction******');
4099:
4100: EXCEPTION
4101: WHEN fnd_api.g_exc_error THEN
4102: debug('You have encountered a "fnd_api.g_exc_error" exception in the Direct Inter Org Transaction');

Line 4169: END csi_inv_interorg_pkg;

4165:
4166: END direct_shipment;
4167:
4168:
4169: END csi_inv_interorg_pkg;