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.11.12020000.4 2012/11/09 11:22:55 mvaradam 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 126: debug('******Start of csi_inv_interorg_pkg.intransit_shipment Transaction procedure******');

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

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

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

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

1199: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)
1200: IS
1201:
1202: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
1203: l_api_name VARCHAR2(100) := 'CSI_INV_INTERORG_PKG.INTRANSIT_RECEIPT';
1204: l_api_version NUMBER := 1.0;
1205: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1206: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
1207: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;

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

1318:
1319: x_return_status := l_fnd_success;
1320: l_error_message := NULL;
1321:
1322: debug('******Start of csi_inv_interorg_pkg.intransit_receipt Transaction procedure******');
1323: debug('Start time: '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
1324: debug('csiorgtb.pls 115.23');
1325: debug('Transaction ID with is: '||p_transaction_id);
1326:

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

2952: END LOOP; -- End of For Loop
2953:
2954:
2955: debug('End time: '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
2956: debug('******End of csi_inv_interorg_pkg.intransit_receipt Transaction******');
2957:
2958: EXCEPTION
2959: WHEN fnd_api.g_exc_error THEN
2960: debug('You have encountered a "fnd_api.g_exc_error" exception in the Inter-Organization Transaction In Transit Receipt');

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

3030: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)
3031: IS
3032:
3033: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
3034: l_api_name VARCHAR2(100) := 'CSI_INV_INTERORG_PKG.DIRECT_SHIPMENT';
3035: l_api_version NUMBER := 1.0;
3036: l_commit VARCHAR2(1) := FND_API.G_FALSE;
3037: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
3038: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;

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

3166:
3167: x_return_status := l_fnd_success;
3168: l_error_message := NULL;
3169:
3170: debug('******Start of csi_inv_interorg_pkg.direct_shipment Transaction procedure******');
3171: debug('Start time: '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
3172: debug('csiorgtb.pls 115.23');
3173: debug('Transaction ID with is: '||p_transaction_id);
3174:

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

4154: END IF; -- End of Serial Control IF
4155: END LOOP; -- End of main For Inv Loop
4156:
4157: debug('End time: '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
4158: debug('******End of csi_inv_interorg_pkg.direct_shipment Transaction******');
4159:
4160: EXCEPTION
4161: WHEN fnd_api.g_exc_error THEN
4162: debug('You have encountered a "fnd_api.g_exc_error" exception in the Direct Inter Org Transaction');

Line 4229: END csi_inv_interorg_pkg;

4225:
4226: END direct_shipment;
4227:
4228:
4229: END csi_inv_interorg_pkg;