eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSI_ITEM_INSTANCE_VLD_PVT dependencies on CSI_GEN_UTILITY_PVT

Line 806: csi_gen_utility_pvt.put_line('Calling INV API to update Serial Number...');

802: OPEN ser_upd_csr (p_inv_id => p_inv_item_id
803: ,p_ser_number => p_serial_number);
804: FETCH ser_upd_csr INTO l_ser_upd_csr;
805: CLOSE ser_upd_csr;
806: csi_gen_utility_pvt.put_line('Calling INV API to update Serial Number...');
807: inv_serial_number_pub.updateserial(
808: p_api_version => 1.0
809: ,p_init_msg_list => fnd_api.g_false
810: ,p_commit => fnd_api.g_false

Line 856: csi_gen_utility_pvt.put_line('Serial Number updated successfully in MTL_SERIAL_NUMBERS..');

852: FND_MSG_PUB.ADD;
853: RAISE comp_error;
854: ELSE
855: l_return_value := TRUE;
856: csi_gen_utility_pvt.put_line('Serial Number updated successfully in MTL_SERIAL_NUMBERS..');
857: RAISE comp_error;
858: END IF;
859: END IF;
860: ELSIF l_temp IS NULL -- Record is not found in MSN so we will validate and create a record in MSN

Line 1014: csi_gen_utility_pvt.put_line('Calling INV API to create Serial Number...');

1010: -- If there is no corresonding serial# in INV,
1011: IF l_temp IS NULL
1012: THEN
1013: -- call the Inventory API to insert serial no. into the MSN table
1014: csi_gen_utility_pvt.put_line('Calling INV API to create Serial Number...');
1015: inv_serial_number_pub.insertSerial(
1016: p_api_version => 1.0,
1017: p_init_msg_list => fnd_api.g_false,
1018: p_commit => fnd_api.g_false,

Line 1068: csi_gen_utility_pvt.put_line('Serial Number created successfully in MTL_SERIAL_NUMBERS..');

1064: FND_MSG_PUB.ADD;
1065: ELSE
1066: l_return_value := TRUE;
1067: p_ins_flag := FND_API.G_TRUE;
1068: csi_gen_utility_pvt.put_line('Serial Number created successfully in MTL_SERIAL_NUMBERS..');
1069: END IF;
1070: END IF; -- (l_temp is null)
1071: END IF;
1072:

Line 1147: csi_gen_utility_pvt.put_line('Serial Tagging Control - '||l_serial_tagged);

1143: p_mtl_transaction_id => p_txn_rec.inv_material_transaction_id,
1144: p_serial_tagged => l_serial_tagged,
1145: p_inv_txn_typeid_from_cs => l_inv_txn_typeid_from_cs);
1146:
1147: csi_gen_utility_pvt.put_line('Serial Tagging Control - '||l_serial_tagged);
1148: -- End 9977630
1149:
1150: IF serialized is not null THEN
1151: -- Item is under serial control but serial_number is NULL

Line 1669: csi_gen_utility_pvt.put_line('Lot Number created successfully in MTL_LOT_NUMBERS..');

1665: FND_MSG_PUB.ADD;
1666: RAISE comp_error;
1667: ELSE
1668: l_return_value := TRUE;
1669: csi_gen_utility_pvt.put_line('Lot Number created successfully in MTL_LOT_NUMBERS..');
1670: END IF;
1671: END IF; -- l_temp is null
1672: --
1673: EXCEPTION

Line 3464: csi_gen_utility_pvt.put_line('Serial Tagging Control - '||l_serial_tagged);

3460: p_mtl_transaction_id => p_txn_rec.inv_material_transaction_id,
3461: p_serial_tagged => l_serial_tagged,
3462: p_inv_txn_typeid_from_cs => l_inv_txn_typeid_from_cs);
3463:
3464: csi_gen_utility_pvt.put_line('Serial Tagging Control - '||l_serial_tagged);
3465: -- End 9977630
3466:
3467: --
3468: IF Serialized is not null THEN

Line 3669: csi_gen_utility_pvt.populate_install_param_rec;

3665: l_count NUMBER := 0 ;
3666:
3667: BEGIN
3668: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
3669: csi_gen_utility_pvt.populate_install_param_rec;
3670: END IF;
3671: --
3672: l_int_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
3673: --

Line 3796: csi_gen_utility_pvt.put_line('value of end date in ITEM_VLD_PVT before check for p_end_date < sysdate:'||to_char(p_end_date, 'DD-MON-YYYY HH24:MI:SS'));

3792: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_END_DATE');
3793: FND_MESSAGE.SET_TOKEN('END_DATE_ACTIVE',to_char(p_end_date,'DD-MON-YYYY HH24:MI:SS'));
3794: FND_MSG_PUB.Add;
3795: RETURN l_return_value;
3796: csi_gen_utility_pvt.put_line('value of end date in ITEM_VLD_PVT before check for p_end_date < sysdate:'||to_char(p_end_date, 'DD-MON-YYYY HH24:MI:SS'));
3797: csi_gen_utility_pvt.put_line('value of sysdate:'||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
3798: ELSIF p_end_date < sysdate THEN -- srramakr
3799: BEGIN
3800: SELECT MAX(source_transaction_date)

Line 3797: csi_gen_utility_pvt.put_line('value of sysdate:'||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));

3793: FND_MESSAGE.SET_TOKEN('END_DATE_ACTIVE',to_char(p_end_date,'DD-MON-YYYY HH24:MI:SS'));
3794: FND_MSG_PUB.Add;
3795: RETURN l_return_value;
3796: csi_gen_utility_pvt.put_line('value of end date in ITEM_VLD_PVT before check for p_end_date < sysdate:'||to_char(p_end_date, 'DD-MON-YYYY HH24:MI:SS'));
3797: csi_gen_utility_pvt.put_line('value of sysdate:'||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
3798: ELSIF p_end_date < sysdate THEN -- srramakr
3799: BEGIN
3800: SELECT MAX(source_transaction_date)
3801: INTO l_txn_date

Line 3806: csi_gen_utility_pvt.put_line('value of end date in ITEM_VLD_PVT after check for p_end_date < sysdate:'||to_char(p_end_date, 'DD-MON-YYYY HH24:MI:SS'));

3802: FROM csi_inst_transactions_v
3803: WHERE instance_id=p_instance_id
3804: AND transaction_id <> p_transaction_id -- Bug 9081875
3805: AND source_transaction_date>p_end_date;
3806: csi_gen_utility_pvt.put_line('value of end date in ITEM_VLD_PVT after check for p_end_date < sysdate:'||to_char(p_end_date, 'DD-MON-YYYY HH24:MI:SS'));
3807: csi_gen_utility_pvt.put_line('value of l_instance_end_date :'||to_char(l_instance_end_date, 'DD-MON-YYYY HH24:MI:SS')); -- Bug 9081875
3808: csi_gen_utility_pvt.put_line('value of MAX(transaction_date) in ITEM_VLD_PVT:'||to_char(l_txn_date, 'DD-MON-YYYY HH24:MI:SS'));
3809: csi_gen_utility_pvt.put_line('value of instance_id in ITEM_VLD_PVT:'||p_instance_id);
3810: EXCEPTION

Line 3807: csi_gen_utility_pvt.put_line('value of l_instance_end_date :'||to_char(l_instance_end_date, 'DD-MON-YYYY HH24:MI:SS')); -- Bug 9081875

3803: WHERE instance_id=p_instance_id
3804: AND transaction_id <> p_transaction_id -- Bug 9081875
3805: AND source_transaction_date>p_end_date;
3806: csi_gen_utility_pvt.put_line('value of end date in ITEM_VLD_PVT after check for p_end_date < sysdate:'||to_char(p_end_date, 'DD-MON-YYYY HH24:MI:SS'));
3807: csi_gen_utility_pvt.put_line('value of l_instance_end_date :'||to_char(l_instance_end_date, 'DD-MON-YYYY HH24:MI:SS')); -- Bug 9081875
3808: csi_gen_utility_pvt.put_line('value of MAX(transaction_date) in ITEM_VLD_PVT:'||to_char(l_txn_date, 'DD-MON-YYYY HH24:MI:SS'));
3809: csi_gen_utility_pvt.put_line('value of instance_id in ITEM_VLD_PVT:'||p_instance_id);
3810: EXCEPTION
3811: WHEN NO_DATA_FOUND THEN

Line 3808: csi_gen_utility_pvt.put_line('value of MAX(transaction_date) in ITEM_VLD_PVT:'||to_char(l_txn_date, 'DD-MON-YYYY HH24:MI:SS'));

3804: AND transaction_id <> p_transaction_id -- Bug 9081875
3805: AND source_transaction_date>p_end_date;
3806: csi_gen_utility_pvt.put_line('value of end date in ITEM_VLD_PVT after check for p_end_date < sysdate:'||to_char(p_end_date, 'DD-MON-YYYY HH24:MI:SS'));
3807: csi_gen_utility_pvt.put_line('value of l_instance_end_date :'||to_char(l_instance_end_date, 'DD-MON-YYYY HH24:MI:SS')); -- Bug 9081875
3808: csi_gen_utility_pvt.put_line('value of MAX(transaction_date) in ITEM_VLD_PVT:'||to_char(l_txn_date, 'DD-MON-YYYY HH24:MI:SS'));
3809: csi_gen_utility_pvt.put_line('value of instance_id in ITEM_VLD_PVT:'||p_instance_id);
3810: EXCEPTION
3811: WHEN NO_DATA_FOUND THEN
3812: l_return_value := TRUE;

Line 3809: csi_gen_utility_pvt.put_line('value of instance_id in ITEM_VLD_PVT:'||p_instance_id);

3805: AND source_transaction_date>p_end_date;
3806: csi_gen_utility_pvt.put_line('value of end date in ITEM_VLD_PVT after check for p_end_date < sysdate:'||to_char(p_end_date, 'DD-MON-YYYY HH24:MI:SS'));
3807: csi_gen_utility_pvt.put_line('value of l_instance_end_date :'||to_char(l_instance_end_date, 'DD-MON-YYYY HH24:MI:SS')); -- Bug 9081875
3808: csi_gen_utility_pvt.put_line('value of MAX(transaction_date) in ITEM_VLD_PVT:'||to_char(l_txn_date, 'DD-MON-YYYY HH24:MI:SS'));
3809: csi_gen_utility_pvt.put_line('value of instance_id in ITEM_VLD_PVT:'||p_instance_id);
3810: EXCEPTION
3811: WHEN NO_DATA_FOUND THEN
3812: l_return_value := TRUE;
3813: RETURN l_return_value;

Line 3818: csi_gen_utility_pvt.put_line('value of end date in ITEM_VLD_PVT if there are any txns:'||to_char(p_end_date, 'DD-MON-YYYY HH24:MI:SS'));

3814: END;
3815:
3816: IF l_txn_date IS NOT NULL
3817: THEN
3818: csi_gen_utility_pvt.put_line('value of end date in ITEM_VLD_PVT if there are any txns:'||to_char(p_end_date, 'DD-MON-YYYY HH24:MI:SS'));
3819: csi_gen_utility_pvt.put_line('value of MAX(source_transaction_date) in ITEM_VLD_PVT if there are any txns:'||to_char(l_txn_date, 'DD-MON-YYYY HH24:MI:SS'));
3820: csi_gen_utility_pvt.put_line('value of instance_id in ITEM_VLD_PVT, if there are any txns:'||p_instance_id);
3821: l_return_value := FALSE;
3822: FND_MESSAGE.Set_Name('CSI', 'CSI_PARENT_HAS_TXN');

Line 3819: csi_gen_utility_pvt.put_line('value of MAX(source_transaction_date) in ITEM_VLD_PVT if there are any txns:'||to_char(l_txn_date, 'DD-MON-YYYY HH24:MI:SS'));

3815:
3816: IF l_txn_date IS NOT NULL
3817: THEN
3818: csi_gen_utility_pvt.put_line('value of end date in ITEM_VLD_PVT if there are any txns:'||to_char(p_end_date, 'DD-MON-YYYY HH24:MI:SS'));
3819: csi_gen_utility_pvt.put_line('value of MAX(source_transaction_date) in ITEM_VLD_PVT if there are any txns:'||to_char(l_txn_date, 'DD-MON-YYYY HH24:MI:SS'));
3820: csi_gen_utility_pvt.put_line('value of instance_id in ITEM_VLD_PVT, if there are any txns:'||p_instance_id);
3821: l_return_value := FALSE;
3822: FND_MESSAGE.Set_Name('CSI', 'CSI_PARENT_HAS_TXN');
3823: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id );

Line 3820: csi_gen_utility_pvt.put_line('value of instance_id in ITEM_VLD_PVT, if there are any txns:'||p_instance_id);

3816: IF l_txn_date IS NOT NULL
3817: THEN
3818: csi_gen_utility_pvt.put_line('value of end date in ITEM_VLD_PVT if there are any txns:'||to_char(p_end_date, 'DD-MON-YYYY HH24:MI:SS'));
3819: csi_gen_utility_pvt.put_line('value of MAX(source_transaction_date) in ITEM_VLD_PVT if there are any txns:'||to_char(l_txn_date, 'DD-MON-YYYY HH24:MI:SS'));
3820: csi_gen_utility_pvt.put_line('value of instance_id in ITEM_VLD_PVT, if there are any txns:'||p_instance_id);
3821: l_return_value := FALSE;
3822: FND_MESSAGE.Set_Name('CSI', 'CSI_PARENT_HAS_TXN');
3823: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id );
3824: FND_MESSAGE.SET_TOKEN('TXN_DATE',to_char(l_txn_date, 'DD-MON-YYYY HH24:MI:SS'));

Line 4315: csi_gen_utility_pvt.populate_install_param_rec;

4311: l_location_lookup_type VARCHAR2(30) := 'CSI_INST_LOCATION_SOURCE_CODE';
4312: l_location_source_table VARCHAR2(30);
4313: BEGIN
4314: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
4315: csi_gen_utility_pvt.populate_install_param_rec;
4316: END IF;
4317: --
4318: IF csi_datastructures_pub.g_install_param_rec.fetch_flag = 'N' THEN
4319: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');

Line 4948: csi_gen_utility_pvt.put_line('Status after calling Create_hdr_xml is '||x_return_status);

4944: p_config_inst_hdr_id => p_instance_rec.config_inst_hdr_id ,
4945: x_xml_hdr => l_xml_hdr,
4946: x_return_status => x_return_status);
4947:
4948: csi_gen_utility_pvt.put_line('Status after calling Create_hdr_xml is '||x_return_status);
4949:
4950: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4951: RAISE FND_API.G_EXC_ERROR;
4952: END IF;

Line 4959: csi_gen_utility_pvt.put_line('Status after calling Send_Input_xml is '||x_return_status);

4955: ( p_xml_hdr => l_xml_hdr,
4956: x_out_xml_msg => l_xml_message,
4957: x_return_status => x_return_status);
4958:
4959: csi_gen_utility_pvt.put_line('Status after calling Send_Input_xml is '||x_return_status);
4960:
4961: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4962: RAISE FND_API.G_EXC_ERROR;
4963: END IF;

Line 4972: csi_gen_utility_pvt.put_line('Status after calling Parse_output_xml is '||x_return_status);

4968: x_config_rev_nbr => x_config_rev_nbr,
4969: x_return_status => x_return_status );
4970:
4971:
4972: csi_gen_utility_pvt.put_line('Status after calling Parse_output_xml is '||x_return_status);
4973:
4974: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4975: RAISE FND_API.G_EXC_ERROR;
4976: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 4983: csi_gen_utility_pvt.put_line('An exp error raised');

4979:
4980: EXCEPTION
4981: WHEN FND_API.G_EXC_ERROR THEN
4982: x_return_status := FND_API.G_RET_STS_ERROR;
4983: csi_gen_utility_pvt.put_line('An exp error raised');
4984:
4985: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4987: csi_gen_utility_pvt.put_line('An unexp error raised');

Line 4987: csi_gen_utility_pvt.put_line('An unexp error raised');

4983: csi_gen_utility_pvt.put_line('An exp error raised');
4984:
4985: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4987: csi_gen_utility_pvt.put_line('An unexp error raised');
4988:
4989: WHEN OTHERS THEN
4990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4991: csi_gen_utility_pvt.put_line( 'Send_input_xml error: ' ||substr(sqlerrm,1,100));

Line 4991: csi_gen_utility_pvt.put_line( 'Send_input_xml error: ' ||substr(sqlerrm,1,100));

4987: csi_gen_utility_pvt.put_line('An unexp error raised');
4988:
4989: WHEN OTHERS THEN
4990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4991: csi_gen_utility_pvt.put_line( 'Send_input_xml error: ' ||substr(sqlerrm,1,100));
4992:
4993: END Call_batch_validate;
4994: --
4995: PROCEDURE decode_queue(p_pending_txn_tbl OUT NOCOPY csi_item_instance_pvt.T_NUM

Line 5050: csi_gen_utility_pvt.put_line('end decode_queue');

5046: l_ctr := l_ctr + 1;
5047: p_pending_txn_tbl(l_ctr) := to_number(l_source_id);
5048: END IF;
5049: END LOOP;
5050: csi_gen_utility_pvt.put_line('end decode_queue');
5051: END decode_queue;
5052: --
5053: /*-----------------------------------------------------------*/
5054: /* Procedure name: Check_Prior_Txn */

Line 5184: csi_gen_utility_pvt.put_line('inside check_prior_txn');

5180: l_max_inv_mtl_txn_id NUMBER:=FND_API.G_MISS_NUM;
5181: BEGIN
5182: x_return_status := FND_API.G_RET_STS_SUCCESS;
5183: --
5184: csi_gen_utility_pvt.put_line('inside check_prior_txn');
5185:
5186: IF p_instance_rec.inventory_item_id is NOT NULL AND p_instance_rec.inventory_item_id <> FND_API.G_MISS_NUM
5187: AND p_instance_rec.serial_number is NOT NULL AND p_instance_rec.serial_number <> FND_API.G_MISS_CHAR
5188: THEN

Line 5190: csi_gen_utility_pvt.populate_install_param_rec;

5186: IF p_instance_rec.inventory_item_id is NOT NULL AND p_instance_rec.inventory_item_id <> FND_API.G_MISS_NUM
5187: AND p_instance_rec.serial_number is NOT NULL AND p_instance_rec.serial_number <> FND_API.G_MISS_CHAR
5188: THEN
5189: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
5190: csi_gen_utility_pvt.populate_install_param_rec;
5191: END IF;
5192:
5193: l_txn_seq_start_date := nvl(csi_datastructures_pub.g_install_param_rec.txn_seq_start_date,
5194: csi_datastructures_pub.g_install_param_rec.freeze_date);

Line 5224: csi_gen_utility_pvt.put_line(' l_cur_mtl_txn_id : '||l_cur_mtl_txn_id);

5220: ELSE
5221: l_cur_mtl_txn_date := sysdate;
5222: END IF;
5223: -- Added debug lines for bug 6755879, FP of bug 6680634
5224: csi_gen_utility_pvt.put_line(' l_cur_mtl_txn_id : '||l_cur_mtl_txn_id);
5225: csi_gen_utility_pvt.put_line(' l_cur_mtl_txn_date : '||l_cur_mtl_txn_date);
5226:
5227: IF p_mode <> 'CREATE' THEN -- Bug 14712665
5228: -- decode_queue(p_pending_txn_tbl => l_pending_txn_tbl

Line 5225: csi_gen_utility_pvt.put_line(' l_cur_mtl_txn_date : '||l_cur_mtl_txn_date);

5221: l_cur_mtl_txn_date := sysdate;
5222: END IF;
5223: -- Added debug lines for bug 6755879, FP of bug 6680634
5224: csi_gen_utility_pvt.put_line(' l_cur_mtl_txn_id : '||l_cur_mtl_txn_id);
5225: csi_gen_utility_pvt.put_line(' l_cur_mtl_txn_date : '||l_cur_mtl_txn_date);
5226:
5227: IF p_mode <> 'CREATE' THEN -- Bug 14712665
5228: -- decode_queue(p_pending_txn_tbl => l_pending_txn_tbl
5229: -- ,p_freeze_date => csi_datastructures_pub.g_install_param_rec.freeze_date);

Line 5323: csi_gen_utility_pvt.put_line('l_mtl_txn_tbl.count : '||l_mtl_txn_tbl.count);

5319: x_mtl_txn_tbl => l_mtl_txn_tbl
5320: );*/
5321: -- Commented for bug#14336404
5322:
5323: csi_gen_utility_pvt.put_line('l_mtl_txn_tbl.count : '||l_mtl_txn_tbl.count);
5324:
5325: IF l_mtl_txn_tbl.count > 0 THEN
5326: IF p_mode = 'CREATE' THEN -- Bug 14712665
5327: FOR l_ind_c IN l_mtl_txn_tbl.FIRST .. l_mtl_txn_tbl.LAST

Line 5345: csi_gen_utility_pvt.put_line('l_mtl_txn_tbl('||l_ind||').transaction_id : '

5341:
5342: FOR l_ind IN l_mtl_txn_tbl.FIRST .. l_mtl_txn_tbl.LAST
5343: LOOP
5344: -- Added debug lines for bug 6755879, FP of bug 6680634
5345: csi_gen_utility_pvt.put_line('l_mtl_txn_tbl('||l_ind||').transaction_id : '
5346: ||l_mtl_txn_tbl(l_ind).transaction_id);
5347: csi_gen_utility_pvt.put_line('l_mtl_txn_tbl('||l_ind||').transfer_transaction_id : '
5348: ||l_mtl_txn_tbl(l_ind).transfer_transaction_id);
5349: IF l_mtl_txn_tbl(l_ind).creation_date > l_txn_seq_start_date

Line 5347: csi_gen_utility_pvt.put_line('l_mtl_txn_tbl('||l_ind||').transfer_transaction_id : '

5343: LOOP
5344: -- Added debug lines for bug 6755879, FP of bug 6680634
5345: csi_gen_utility_pvt.put_line('l_mtl_txn_tbl('||l_ind||').transaction_id : '
5346: ||l_mtl_txn_tbl(l_ind).transaction_id);
5347: csi_gen_utility_pvt.put_line('l_mtl_txn_tbl('||l_ind||').transfer_transaction_id : '
5348: ||l_mtl_txn_tbl(l_ind).transfer_transaction_id);
5349: IF l_mtl_txn_tbl(l_ind).creation_date > l_txn_seq_start_date
5350: AND l_mtl_txn_tbl(l_ind).creation_date < l_cur_mtl_txn_date
5351: AND l_mtl_txn_tbl(l_ind).transaction_id <> l_cur_mtl_txn_id

Line 5399: csi_gen_utility_pvt.put_line(' l_err_mtl_txn_id : '||l_err_mtl_txn_id);

5395: WHEN NO_DATA_FOUND THEN
5396: NULL;
5397: END;
5398:
5399: csi_gen_utility_pvt.put_line(' l_err_mtl_txn_id : '||l_err_mtl_txn_id);
5400: csi_gen_utility_pvt.put_line(' l_err_mtl_txn_date : '||l_err_mtl_txn_date);
5401:
5402: IF (l_err_mtl_txn_date <> FND_API.G_MISS_DATE
5403: AND l_err_mtl_txn_date <= l_cur_mtl_txn_date)

Line 5400: csi_gen_utility_pvt.put_line(' l_err_mtl_txn_date : '||l_err_mtl_txn_date);

5396: NULL;
5397: END;
5398:
5399: csi_gen_utility_pvt.put_line(' l_err_mtl_txn_id : '||l_err_mtl_txn_id);
5400: csi_gen_utility_pvt.put_line(' l_err_mtl_txn_date : '||l_err_mtl_txn_date);
5401:
5402: IF (l_err_mtl_txn_date <> FND_API.G_MISS_DATE
5403: AND l_err_mtl_txn_date <= l_cur_mtl_txn_date)
5404: OR (l_err_mtl_txn_date = FND_API.G_MISS_DATE) THEN

Line 5510: csi_gen_utility_pvt.put_line('Stop All Txns..');

5506: IF p_instance_id IS NOT NULL AND
5507: p_instance_id <> FND_API.G_MISS_NUM THEN
5508: l_recount := 0;
5509: IF nvl(p_stop_all_txn,FND_API.G_TRUE) = FND_API.G_TRUE THEN
5510: csi_gen_utility_pvt.put_line('Stop All Txns..');
5511: BEGIN
5512: select count(*)
5513: into l_recount
5514: from CSI_II_FORWARD_SYNC_TEMP

Line 5524: csi_gen_utility_pvt.put_line('Stop Later Txns..');

5520: l_recount := 0;
5521: END;
5522: --
5523: ELSE
5524: csi_gen_utility_pvt.put_line('Stop Later Txns..');
5525: IF l_mtl_txn_id <> fnd_api.g_miss_num THEN
5526: Begin
5527: select creation_date
5528: into l_mtl_txn_cr_date

Line 5635: csi_gen_utility_pvt.put_line('Queried from oe_lines: ' ||

5631: l_config_header_id := to_char(p_config_hdr_id);
5632: l_config_rev_nbr := to_char(p_config_rev_nbr);
5633:
5634:
5635: csi_gen_utility_pvt.put_line('Queried from oe_lines: ' ||
5636: ' config-hdr: ' || l_config_header_id ||
5637: ' config-rev: ' || l_config_rev_nbr );
5638:
5639: -- profiles and env. variables.

Line 5643: csi_gen_utility_pvt.put_line('database_id: '||l_database_id);--,2);

5639: -- profiles and env. variables.
5640: l_database_id := fnd_web_config.database_id;
5641: l_icx_session_ticket := cz_cf_api.icx_session_ticket;
5642:
5643: csi_gen_utility_pvt.put_line('database_id: '||l_database_id);--,2);
5644:
5645: -- Set param_names
5646: -- Always required
5647: param_name(1) := 'ui_type'; -- we are passing null

Line 5692: csi_gen_utility_pvt.put_line('Inside Create_hdr_xml, parameters are set');

5688: param_value(11) := 'TRUE';
5689: param_value(12) := l_icx_session_ticket;
5690:
5691:
5692: csi_gen_utility_pvt.put_line('Inside Create_hdr_xml, parameters are set');
5693: l_rec_index := 1;
5694: LOOP
5695: IF (param_value(l_rec_index) IS NOT NULL) THEN
5696: l_dummy := '

5706:
5707: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
5708:
5709: IF (l_debug_level > 0) THEN
5710: csi_gen_utility_pvt.put_line( 'Call to batch validation ');
5711: END IF;
5712:
5713: IF (l_debug_level > 1) THEN
5714: csi_gen_utility_pvt.dump_call_batch_val

Line 5714: csi_gen_utility_pvt.dump_call_batch_val

5710: csi_gen_utility_pvt.put_line( 'Call to batch validation ');
5711: END IF;
5712:
5713: IF (l_debug_level > 1) THEN
5714: csi_gen_utility_pvt.dump_call_batch_val
5715: ( p_api_version => 1.0
5716: ,p_init_msg_list => fnd_api.g_false
5717: ,p_parameter_name => param_name
5718: ,p_parameter_value => param_value

Line 5730: csi_gen_utility_pvt.put_line(' ');

5726: -- add termination tags
5727: l_xml_hdr := l_xml_hdr || '';
5728: l_xml_hdr := REPLACE(l_xml_hdr, ' ' , '+');
5729:
5730: csi_gen_utility_pvt.put_line(' ');
5731: csi_gen_utility_pvt.put_line
5732: ('1st Part of Create_hdr_xml is : '||SUBSTR(l_xml_hdr, 1, 200) );
5733: csi_gen_utility_pvt.put_line(' ');
5734: csi_gen_utility_pvt.put_line

Line 5731: csi_gen_utility_pvt.put_line

5727: l_xml_hdr := l_xml_hdr || '';
5728: l_xml_hdr := REPLACE(l_xml_hdr, ' ' , '+');
5729:
5730: csi_gen_utility_pvt.put_line(' ');
5731: csi_gen_utility_pvt.put_line
5732: ('1st Part of Create_hdr_xml is : '||SUBSTR(l_xml_hdr, 1, 200) );
5733: csi_gen_utility_pvt.put_line(' ');
5734: csi_gen_utility_pvt.put_line
5735: ('2nd Part of Create_hdr_xml is : '||SUBSTR(l_xml_hdr, 201, 200) );

Line 5733: csi_gen_utility_pvt.put_line(' ');

5729:
5730: csi_gen_utility_pvt.put_line(' ');
5731: csi_gen_utility_pvt.put_line
5732: ('1st Part of Create_hdr_xml is : '||SUBSTR(l_xml_hdr, 1, 200) );
5733: csi_gen_utility_pvt.put_line(' ');
5734: csi_gen_utility_pvt.put_line
5735: ('2nd Part of Create_hdr_xml is : '||SUBSTR(l_xml_hdr, 201, 200) );
5736: csi_gen_utility_pvt.put_line(' ');
5737: csi_gen_utility_pvt.put_line

Line 5734: csi_gen_utility_pvt.put_line

5730: csi_gen_utility_pvt.put_line(' ');
5731: csi_gen_utility_pvt.put_line
5732: ('1st Part of Create_hdr_xml is : '||SUBSTR(l_xml_hdr, 1, 200) );
5733: csi_gen_utility_pvt.put_line(' ');
5734: csi_gen_utility_pvt.put_line
5735: ('2nd Part of Create_hdr_xml is : '||SUBSTR(l_xml_hdr, 201, 200) );
5736: csi_gen_utility_pvt.put_line(' ');
5737: csi_gen_utility_pvt.put_line
5738: ('3rd Part of Create_hdr_xml is : '||SUBSTR(l_xml_hdr, 401, 200) );

Line 5736: csi_gen_utility_pvt.put_line(' ');

5732: ('1st Part of Create_hdr_xml is : '||SUBSTR(l_xml_hdr, 1, 200) );
5733: csi_gen_utility_pvt.put_line(' ');
5734: csi_gen_utility_pvt.put_line
5735: ('2nd Part of Create_hdr_xml is : '||SUBSTR(l_xml_hdr, 201, 200) );
5736: csi_gen_utility_pvt.put_line(' ');
5737: csi_gen_utility_pvt.put_line
5738: ('3rd Part of Create_hdr_xml is : '||SUBSTR(l_xml_hdr, 401, 200) );
5739: csi_gen_utility_pvt.put_line(' ');
5740: csi_gen_utility_pvt.put_line

Line 5737: csi_gen_utility_pvt.put_line

5733: csi_gen_utility_pvt.put_line(' ');
5734: csi_gen_utility_pvt.put_line
5735: ('2nd Part of Create_hdr_xml is : '||SUBSTR(l_xml_hdr, 201, 200) );
5736: csi_gen_utility_pvt.put_line(' ');
5737: csi_gen_utility_pvt.put_line
5738: ('3rd Part of Create_hdr_xml is : '||SUBSTR(l_xml_hdr, 401, 200) );
5739: csi_gen_utility_pvt.put_line(' ');
5740: csi_gen_utility_pvt.put_line
5741: ('4th Part of Create_hdr_xml is : '||SUBSTR(l_xml_hdr, 601, 200) );

Line 5739: csi_gen_utility_pvt.put_line(' ');

5735: ('2nd Part of Create_hdr_xml is : '||SUBSTR(l_xml_hdr, 201, 200) );
5736: csi_gen_utility_pvt.put_line(' ');
5737: csi_gen_utility_pvt.put_line
5738: ('3rd Part of Create_hdr_xml is : '||SUBSTR(l_xml_hdr, 401, 200) );
5739: csi_gen_utility_pvt.put_line(' ');
5740: csi_gen_utility_pvt.put_line
5741: ('4th Part of Create_hdr_xml is : '||SUBSTR(l_xml_hdr, 601, 200) );
5742:
5743: x_xml_hdr := l_xml_hdr;

Line 5740: csi_gen_utility_pvt.put_line

5736: csi_gen_utility_pvt.put_line(' ');
5737: csi_gen_utility_pvt.put_line
5738: ('3rd Part of Create_hdr_xml is : '||SUBSTR(l_xml_hdr, 401, 200) );
5739: csi_gen_utility_pvt.put_line(' ');
5740: csi_gen_utility_pvt.put_line
5741: ('4th Part of Create_hdr_xml is : '||SUBSTR(l_xml_hdr, 601, 200) );
5742:
5743: x_xml_hdr := l_xml_hdr;
5744: csi_gen_utility_pvt.put_line(' ');

Line 5744: csi_gen_utility_pvt.put_line(' ');

5740: csi_gen_utility_pvt.put_line
5741: ('4th Part of Create_hdr_xml is : '||SUBSTR(l_xml_hdr, 601, 200) );
5742:
5743: x_xml_hdr := l_xml_hdr;
5744: csi_gen_utility_pvt.put_line(' ');
5745: csi_gen_utility_pvt.put_line('length of ini msg:' || length(l_xml_hdr));
5746: csi_gen_utility_pvt.put_line('Leaving Create_hdr_xml');
5747: csi_gen_utility_pvt.put_line('------------------------------------- ');
5748: EXCEPTION

Line 5745: csi_gen_utility_pvt.put_line('length of ini msg:' || length(l_xml_hdr));

5741: ('4th Part of Create_hdr_xml is : '||SUBSTR(l_xml_hdr, 601, 200) );
5742:
5743: x_xml_hdr := l_xml_hdr;
5744: csi_gen_utility_pvt.put_line(' ');
5745: csi_gen_utility_pvt.put_line('length of ini msg:' || length(l_xml_hdr));
5746: csi_gen_utility_pvt.put_line('Leaving Create_hdr_xml');
5747: csi_gen_utility_pvt.put_line('------------------------------------- ');
5748: EXCEPTION
5749: WHEN OTHERS THEN

Line 5746: csi_gen_utility_pvt.put_line('Leaving Create_hdr_xml');

5742:
5743: x_xml_hdr := l_xml_hdr;
5744: csi_gen_utility_pvt.put_line(' ');
5745: csi_gen_utility_pvt.put_line('length of ini msg:' || length(l_xml_hdr));
5746: csi_gen_utility_pvt.put_line('Leaving Create_hdr_xml');
5747: csi_gen_utility_pvt.put_line('------------------------------------- ');
5748: EXCEPTION
5749: WHEN OTHERS THEN
5750: csi_gen_utility_pvt.put_line('exception in create_hdr_xml '|| sqlerrm);

Line 5747: csi_gen_utility_pvt.put_line('------------------------------------- ');

5743: x_xml_hdr := l_xml_hdr;
5744: csi_gen_utility_pvt.put_line(' ');
5745: csi_gen_utility_pvt.put_line('length of ini msg:' || length(l_xml_hdr));
5746: csi_gen_utility_pvt.put_line('Leaving Create_hdr_xml');
5747: csi_gen_utility_pvt.put_line('------------------------------------- ');
5748: EXCEPTION
5749: WHEN OTHERS THEN
5750: csi_gen_utility_pvt.put_line('exception in create_hdr_xml '|| sqlerrm);
5751: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5750: csi_gen_utility_pvt.put_line('exception in create_hdr_xml '|| sqlerrm);

5746: csi_gen_utility_pvt.put_line('Leaving Create_hdr_xml');
5747: csi_gen_utility_pvt.put_line('------------------------------------- ');
5748: EXCEPTION
5749: WHEN OTHERS THEN
5750: csi_gen_utility_pvt.put_line('exception in create_hdr_xml '|| sqlerrm);
5751: x_return_status := FND_API.G_RET_STS_ERROR;
5752: END Create_hdr_xml;
5753:
5754:

Line 5790: csi_gen_utility_pvt.put_line('Entering Send_input_xml');

5786:
5787: BEGIN
5788: l_return_status := FND_API.G_RET_STS_SUCCESS;
5789:
5790: csi_gen_utility_pvt.put_line('Entering Send_input_xml');
5791: csi_gen_utility_pvt.put_line('UImanager url: ' || l_url );
5792:
5793: l_xml_hdr := p_xml_hdr;
5794: csi_gen_utility_pvt.put_line('length of ini msg: ' || length(l_xml_hdr));

Line 5791: csi_gen_utility_pvt.put_line('UImanager url: ' || l_url );

5787: BEGIN
5788: l_return_status := FND_API.G_RET_STS_SUCCESS;
5789:
5790: csi_gen_utility_pvt.put_line('Entering Send_input_xml');
5791: csi_gen_utility_pvt.put_line('UImanager url: ' || l_url );
5792:
5793: l_xml_hdr := p_xml_hdr;
5794: csi_gen_utility_pvt.put_line('length of ini msg: ' || length(l_xml_hdr));
5795:

Line 5794: csi_gen_utility_pvt.put_line('length of ini msg: ' || length(l_xml_hdr));

5790: csi_gen_utility_pvt.put_line('Entering Send_input_xml');
5791: csi_gen_utility_pvt.put_line('UImanager url: ' || l_url );
5792:
5793: l_xml_hdr := p_xml_hdr;
5794: csi_gen_utility_pvt.put_line('length of ini msg: ' || length(l_xml_hdr));
5795:
5796:
5797: -- delete previous data.
5798: IF (l_html_pieces.COUNT <> 0) THEN

Line 5810: csi_gen_utility_pvt.put_line('After call to batch validation the status is : '||l_validation_status );

5806: URL => l_url ,
5807: p_validation_type => cz_api_pub.validate_fulfillment
5808: );
5809:
5810: csi_gen_utility_pvt.put_line('After call to batch validation the status is : '||l_validation_status );
5811:
5812:
5813: IF l_validation_status <> 0 THEN
5814: l_return_status := FND_API.G_RET_STS_ERROR;

Line 5832: csi_gen_utility_pvt.put_line(l_rec_index ||': Part of output_message: ' ||

5828: IF l_html_pieces.COUNT >0
5829: THEN
5830: l_rec_index := l_html_pieces.FIRST;
5831: LOOP
5832: csi_gen_utility_pvt.put_line(l_rec_index ||': Part of output_message: ' ||
5833: SUBSTR(l_html_pieces(l_rec_index), 1, 100) );
5834:
5835: l_long_xml := l_long_xml || l_html_pieces(l_rec_index);
5836:

Line 5846: csi_gen_utility_pvt.put_line('Exiting csi_config_util.Send_input_xml');

5842:
5843: -- if everything ok, set out values
5844: x_out_xml_msg := l_long_xml;
5845: x_return_status := l_return_status;
5846: csi_gen_utility_pvt.put_line('Exiting csi_config_util.Send_input_xml');
5847: EXCEPTION
5848: WHEN OTHERS THEN
5849: x_return_status := FND_API.G_RET_STS_ERROR;
5850: csi_gen_utility_pvt.put_line( 'Inside Send_input_xml when others exception: ' ||substr(sqlerrm,1,100));

Line 5850: csi_gen_utility_pvt.put_line( 'Inside Send_input_xml when others exception: ' ||substr(sqlerrm,1,100));

5846: csi_gen_utility_pvt.put_line('Exiting csi_config_util.Send_input_xml');
5847: EXCEPTION
5848: WHEN OTHERS THEN
5849: x_return_status := FND_API.G_RET_STS_ERROR;
5850: csi_gen_utility_pvt.put_line( 'Inside Send_input_xml when others exception: ' ||substr(sqlerrm,1,100));
5851: END Send_input_xml;
5852:
5853: PROCEDURE Parse_output_xml
5854: ( p_xml IN LONG,

Line 5920: csi_gen_utility_pvt.put_line('Entering Parse_output_xml');

5916: l_flag VARCHAR2(1) := 'N';
5917:
5918: BEGIN
5919:
5920: csi_gen_utility_pvt.put_line('Entering Parse_output_xml');
5921:
5922: l_exit_start_pos :=
5923: INSTR(p_xml, l_exit_start_tag,1, 1) +
5924: length(l_exit_start_tag);

Line 5932: csi_gen_utility_pvt.put_line('l_exit: '||l_exit);

5928:
5929: l_exit := SUBSTR (p_xml, l_exit_start_pos,
5930: l_exit_end_pos - l_exit_start_pos + 1);
5931:
5932: csi_gen_utility_pvt.put_line('l_exit: '||l_exit);
5933:
5934: -- if error go to msg etc.
5935: IF nvl(l_exit,'error') <> 'error' THEN
5936:

Line 5947: csi_gen_utility_pvt.put_line('l_valid_config: '|| l_valid_config);

5943: l_valid_config := SUBSTR( p_xml, l_valid_config_start_pos,
5944: l_valid_config_end_pos -
5945: l_valid_config_start_pos + 1);
5946:
5947: csi_gen_utility_pvt.put_line('l_valid_config: '|| l_valid_config);
5948:
5949: l_complete_config_start_pos :=
5950: INSTR(p_xml, l_complete_config_start_tag,1, 1)+length(l_complete_config_start_tag);
5951: l_complete_config_end_pos :=

Line 5958: csi_gen_utility_pvt.put_line('l_complete_config '|| l_complete_config);

5954: l_complete_config := SUBSTR( p_xml, l_complete_config_start_pos,
5955: l_complete_config_end_pos -
5956: l_complete_config_start_pos + 1);
5957:
5958: csi_gen_utility_pvt.put_line('l_complete_config '|| l_complete_config);
5959:
5960:
5961: IF (nvl(l_valid_config, 'N') <> 'true') THEN
5962: csi_gen_utility_pvt.put_line(' Returned valid_flag as null/false');

Line 5962: csi_gen_utility_pvt.put_line(' Returned valid_flag as null/false');

5958: csi_gen_utility_pvt.put_line('l_complete_config '|| l_complete_config);
5959:
5960:
5961: IF (nvl(l_valid_config, 'N') <> 'true') THEN
5962: csi_gen_utility_pvt.put_line(' Returned valid_flag as null/false');
5963: l_flag := 'Y';
5964: END IF ;
5965:
5966:

Line 5968: csi_gen_utility_pvt.put_line('Returned complete_flag as null/false');

5964: END IF ;
5965:
5966:
5967: IF (nvl(l_complete_config, 'N') <> 'true' ) THEN
5968: csi_gen_utility_pvt.put_line('Returned complete_flag as null/false');
5969: l_flag := 'Y';
5970: END IF;
5971:
5972:

Line 5986: csi_gen_utility_pvt.put_line('l_message_text is: '||l_message_text);

5982: l_message_text := SUBSTR( p_xml, l_message_text_start_pos,
5983: l_message_text_end_pos -
5984: l_message_text_start_pos + 1);
5985:
5986: csi_gen_utility_pvt.put_line('l_message_text is: '||l_message_text);
5987:
5988: l_message_type_start_pos :=
5989: INSTR(p_xml, l_message_type_start_tag,1, 1)+length(l_message_type_start_tag);
5990: l_message_type_end_pos :=

Line 6002: csi_gen_utility_pvt.put_line('l_message_type is : '|| l_message_type);

5998: -- get the latest config_header_id, and rev_nbr to get
5999: -- messages if any.
6000:
6001:
6002: csi_gen_utility_pvt.put_line('l_message_type is : '|| l_message_type);
6003:
6004:
6005: l_config_header_id_start_pos :=
6006: INSTR(p_xml, l_config_header_id_start_tag, 1, 1)+length(l_config_header_id_start_tag);

Line 6028: csi_gen_utility_pvt.put_line('Returned config_header_id as:' ||to_char(l_config_header_id));

6024: to_number(SUBSTR( p_xml,l_config_rev_nbr_start_pos,
6025: l_config_rev_nbr_end_pos -
6026: l_config_rev_nbr_start_pos + 1));
6027:
6028: csi_gen_utility_pvt.put_line('Returned config_header_id as:' ||to_char(l_config_header_id));
6029: csi_gen_utility_pvt.put_line('Returned config_rev_nbr as:' ||to_char(l_config_rev_nbr));
6030:
6031:
6032:

Line 6029: csi_gen_utility_pvt.put_line('Returned config_rev_nbr as:' ||to_char(l_config_rev_nbr));

6025: l_config_rev_nbr_end_pos -
6026: l_config_rev_nbr_start_pos + 1));
6027:
6028: csi_gen_utility_pvt.put_line('Returned config_header_id as:' ||to_char(l_config_header_id));
6029: csi_gen_utility_pvt.put_line('Returned config_rev_nbr as:' ||to_char(l_config_rev_nbr));
6030:
6031:
6032:
6033:

Line 6038: csi_gen_utility_pvt.put_line('Getting messages from cz_config_messages');

6034: IF (l_flag = 'Y' ) OR
6035: l_exit is NULL OR
6036: l_exit = 'error' THEN
6037:
6038: csi_gen_utility_pvt.put_line('Getting messages from cz_config_messages');
6039:
6040: OPEN messages(l_config_header_id, l_config_rev_nbr);
6041:
6042: LOOP

Line 6046: csi_gen_utility_pvt.put_line('msg : '|| substr(l_msg, 1, 250));

6042: LOOP
6043: FETCH messages INTO l_constraint,l_msg;
6044: EXIT WHEN messages%notfound;
6045:
6046: csi_gen_utility_pvt.put_line('msg : '|| substr(l_msg, 1, 250));
6047: END LOOP;
6048: /*
6049: IF nvl(l_valid_config, 'false') = 'false'
6050: OR l_exit = 'error'

Line 6056: csi_gen_utility_pvt.put_line('Configuration is invalid/incomplete');

6052: l_return_status:=FND_API.G_RET_STS_ERROR;
6053: FND_MESSAGE.Set_Name('CSI', 'CSI_BATCH_VALIDATE');
6054: FND_MESSAGE.Set_token('ERR_TEXT' , 'Error returned from cz_network_api_pub.Validate, from Parse_output_xml ' );
6055: FND_MSG_PUB.ADD;
6056: csi_gen_utility_pvt.put_line('Configuration is invalid/incomplete');
6057: END IF;
6058: */
6059:
6060:

Line 6071: csi_gen_utility_pvt.put_line('Exiting parse_output_xml');

6067: -- if everything ok, set return values
6068: x_return_status := l_return_status;
6069:
6070:
6071: csi_gen_utility_pvt.put_line('Exiting parse_output_xml');
6072:
6073: EXCEPTION
6074: WHEN OTHERS THEN
6075: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 6076: csi_gen_utility_pvt.put_line( 'Parse_Output_xml error: ' || substr(sqlerrm,1,100));

6072:
6073: EXCEPTION
6074: WHEN OTHERS THEN
6075: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6076: csi_gen_utility_pvt.put_line( 'Parse_Output_xml error: ' || substr(sqlerrm,1,100));
6077:
6078: END Parse_output_xml;
6079:
6080: -- End addition by sguthiva for att enhancements

Line 6243: csi_gen_utility_pvt.put_line('p_txn_rec.transaction_type_id : ' ||p_txn_rec.transaction_type_id);

6239: --
6240: BEGIN
6241:
6242: x_return_status := fnd_api.g_ret_sts_success;
6243: csi_gen_utility_pvt.put_line('p_txn_rec.transaction_type_id : ' ||p_txn_rec.transaction_type_id);
6244: IF p_txn_rec.transaction_type_id not in (205,127,10082) THEN --Added condition and uncommented the code for bug 6965008
6245: IF p_txn_rec.inv_material_transaction_id IS NULL OR
6246: p_txn_rec.inv_material_transaction_id = FND_API.G_MISS_NUM THEN
6247: l_current_txn_id := -99999;

Line 6453: csi_gen_utility_pvt.populate_install_param_rec;

6449:
6450: BEGIN
6451:
6452: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
6453: csi_gen_utility_pvt.populate_install_param_rec;
6454: END IF;
6455:
6456: l_txn_seq_start_date := csi_datastructures_pub.g_install_param_rec.txn_seq_start_date;
6457: IF l_txn_seq_start_date is null THEN