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 805: csi_gen_utility_pvt.put_line('Calling INV API to update Serial Number...');

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

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

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

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

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

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

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

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

1621: FND_MSG_PUB.ADD;
1622: RAISE comp_error;
1623: ELSE
1624: l_return_value := TRUE;
1625: csi_gen_utility_pvt.put_line('Lot Number created successfully in MTL_LOT_NUMBERS..');
1626: END IF;
1627: END IF; -- l_temp is null
1628: --
1629: EXCEPTION

Line 3590: csi_gen_utility_pvt.populate_install_param_rec;

3586: l_count NUMBER := 0 ;
3587:
3588: BEGIN
3589: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
3590: csi_gen_utility_pvt.populate_install_param_rec;
3591: END IF;
3592: --
3593: l_int_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
3594: --

Line 3716: 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'));

3712: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_END_DATE');
3713: FND_MESSAGE.SET_TOKEN('END_DATE_ACTIVE',to_char(p_end_date,'DD-MON-YYYY HH24:MI:SS'));
3714: FND_MSG_PUB.Add;
3715: RETURN l_return_value;
3716: 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'));
3717: csi_gen_utility_pvt.put_line('value of sysdate:'||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
3718: ELSIF p_end_date < sysdate THEN -- srramakr
3719: BEGIN
3720: SELECT MAX(source_transaction_date)

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

3713: FND_MESSAGE.SET_TOKEN('END_DATE_ACTIVE',to_char(p_end_date,'DD-MON-YYYY HH24:MI:SS'));
3714: FND_MSG_PUB.Add;
3715: RETURN l_return_value;
3716: 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'));
3717: csi_gen_utility_pvt.put_line('value of sysdate:'||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
3718: ELSIF p_end_date < sysdate THEN -- srramakr
3719: BEGIN
3720: SELECT MAX(source_transaction_date)
3721: INTO l_txn_date

Line 3725: 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'));

3721: INTO l_txn_date
3722: FROM csi_inst_transactions_v
3723: WHERE instance_id=p_instance_id
3724: AND source_transaction_date>p_end_date;
3725: 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'));
3726: 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'));
3727: csi_gen_utility_pvt.put_line('value of instance_id in ITEM_VLD_PVT:'||p_instance_id);
3728: EXCEPTION
3729: WHEN NO_DATA_FOUND THEN

Line 3726: 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'));

3722: FROM csi_inst_transactions_v
3723: WHERE instance_id=p_instance_id
3724: AND source_transaction_date>p_end_date;
3725: 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'));
3726: 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'));
3727: csi_gen_utility_pvt.put_line('value of instance_id in ITEM_VLD_PVT:'||p_instance_id);
3728: EXCEPTION
3729: WHEN NO_DATA_FOUND THEN
3730: l_return_value := TRUE;

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

3723: WHERE instance_id=p_instance_id
3724: AND source_transaction_date>p_end_date;
3725: 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'));
3726: 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'));
3727: csi_gen_utility_pvt.put_line('value of instance_id in ITEM_VLD_PVT:'||p_instance_id);
3728: EXCEPTION
3729: WHEN NO_DATA_FOUND THEN
3730: l_return_value := TRUE;
3731: RETURN l_return_value;

Line 3736: 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'));

3732: END;
3733:
3734: IF l_txn_date IS NOT NULL
3735: THEN
3736: 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'));
3737: 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'));
3738: csi_gen_utility_pvt.put_line('value of instance_id in ITEM_VLD_PVT, if there are any txns:'||p_instance_id);
3739: l_return_value := FALSE;
3740: FND_MESSAGE.Set_Name('CSI', 'CSI_PARENT_HAS_TXN');

Line 3737: 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'));

3733:
3734: IF l_txn_date IS NOT NULL
3735: THEN
3736: 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'));
3737: 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'));
3738: csi_gen_utility_pvt.put_line('value of instance_id in ITEM_VLD_PVT, if there are any txns:'||p_instance_id);
3739: l_return_value := FALSE;
3740: FND_MESSAGE.Set_Name('CSI', 'CSI_PARENT_HAS_TXN');
3741: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id );

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

3734: IF l_txn_date IS NOT NULL
3735: THEN
3736: 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'));
3737: 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'));
3738: csi_gen_utility_pvt.put_line('value of instance_id in ITEM_VLD_PVT, if there are any txns:'||p_instance_id);
3739: l_return_value := FALSE;
3740: FND_MESSAGE.Set_Name('CSI', 'CSI_PARENT_HAS_TXN');
3741: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id );
3742: FND_MESSAGE.SET_TOKEN('TXN_DATE',to_char(l_txn_date, 'DD-MON-YYYY HH24:MI:SS'));

Line 4229: csi_gen_utility_pvt.populate_install_param_rec;

4225: l_location_lookup_type VARCHAR2(30) := 'CSI_INST_LOCATION_SOURCE_CODE';
4226: l_location_source_table VARCHAR2(30);
4227: BEGIN
4228: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
4229: csi_gen_utility_pvt.populate_install_param_rec;
4230: END IF;
4231: --
4232: IF csi_datastructures_pub.g_install_param_rec.fetch_flag = 'N' THEN
4233: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');

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

4858: p_config_inst_hdr_id => p_instance_rec.config_inst_hdr_id ,
4859: x_xml_hdr => l_xml_hdr,
4860: x_return_status => x_return_status);
4861:
4862: csi_gen_utility_pvt.put_line('Status after calling Create_hdr_xml is '||x_return_status);
4863:
4864: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4865: RAISE FND_API.G_EXC_ERROR;
4866: END IF;

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

4869: ( p_xml_hdr => l_xml_hdr,
4870: x_out_xml_msg => l_xml_message,
4871: x_return_status => x_return_status);
4872:
4873: csi_gen_utility_pvt.put_line('Status after calling Send_Input_xml is '||x_return_status);
4874:
4875: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4876: RAISE FND_API.G_EXC_ERROR;
4877: END IF;

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

4882: x_config_rev_nbr => x_config_rev_nbr,
4883: x_return_status => x_return_status );
4884:
4885:
4886: csi_gen_utility_pvt.put_line('Status after calling Parse_output_xml is '||x_return_status);
4887:
4888: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4889: RAISE FND_API.G_EXC_ERROR;
4890: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

4893:
4894: EXCEPTION
4895: WHEN FND_API.G_EXC_ERROR THEN
4896: x_return_status := FND_API.G_RET_STS_ERROR;
4897: csi_gen_utility_pvt.put_line('An exp error raised');
4898:
4899: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4901: csi_gen_utility_pvt.put_line('An unexp error raised');

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

4897: csi_gen_utility_pvt.put_line('An exp error raised');
4898:
4899: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4901: csi_gen_utility_pvt.put_line('An unexp error raised');
4902:
4903: WHEN OTHERS THEN
4904: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4905: csi_gen_utility_pvt.put_line( 'Send_input_xml error: ' ||substr(sqlerrm,1,100));

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

4901: csi_gen_utility_pvt.put_line('An unexp error raised');
4902:
4903: WHEN OTHERS THEN
4904: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4905: csi_gen_utility_pvt.put_line( 'Send_input_xml error: ' ||substr(sqlerrm,1,100));
4906:
4907: END Call_batch_validate;
4908: --
4909: PROCEDURE decode_queue(p_pending_txn_tbl OUT NOCOPY csi_item_instance_pvt.T_NUM

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

5009: l_err_mtl_txn_date DATE;
5010: BEGIN
5011: x_return_status := FND_API.G_RET_STS_SUCCESS;
5012: --
5013: csi_gen_utility_pvt.put_line('inside check_prior_txn');
5014:
5015: IF p_instance_rec.inventory_item_id is NOT NULL AND p_instance_rec.inventory_item_id <> FND_API.G_MISS_NUM
5016: AND p_instance_rec.serial_number is NOT NULL AND p_instance_rec.serial_number <> FND_API.G_MISS_CHAR
5017: THEN

Line 5019: csi_gen_utility_pvt.populate_install_param_rec;

5015: IF p_instance_rec.inventory_item_id is NOT NULL AND p_instance_rec.inventory_item_id <> FND_API.G_MISS_NUM
5016: AND p_instance_rec.serial_number is NOT NULL AND p_instance_rec.serial_number <> FND_API.G_MISS_CHAR
5017: THEN
5018: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
5019: csi_gen_utility_pvt.populate_install_param_rec;
5020: END IF;
5021:
5022: l_txn_seq_start_date := nvl(csi_datastructures_pub.g_install_param_rec.txn_seq_start_date,
5023: csi_datastructures_pub.g_install_param_rec.freeze_date);

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

5049: ELSE
5050: l_cur_mtl_txn_date := sysdate;
5051: END IF;
5052: -- Added debug lines for bug 6755879, FP of bug 6680634
5053: csi_gen_utility_pvt.put_line(' l_cur_mtl_txn_id : '||l_cur_mtl_txn_id);
5054: csi_gen_utility_pvt.put_line(' l_cur_mtl_txn_date : '||l_cur_mtl_txn_date);
5055:
5056: IF p_mode = 'CREATE' THEN
5057: decode_queue(p_pending_txn_tbl => l_pending_txn_tbl

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

5050: l_cur_mtl_txn_date := sysdate;
5051: END IF;
5052: -- Added debug lines for bug 6755879, FP of bug 6680634
5053: csi_gen_utility_pvt.put_line(' l_cur_mtl_txn_id : '||l_cur_mtl_txn_id);
5054: csi_gen_utility_pvt.put_line(' l_cur_mtl_txn_date : '||l_cur_mtl_txn_date);
5055:
5056: IF p_mode = 'CREATE' THEN
5057: decode_queue(p_pending_txn_tbl => l_pending_txn_tbl
5058: ,p_freeze_date => csi_datastructures_pub.g_install_param_rec.freeze_date);

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

5092: p_inventory_item_id => p_instance_rec.inventory_item_id,
5093: p_serial_number => p_instance_rec.serial_number,
5094: x_mtl_txn_tbl => l_mtl_txn_tbl
5095: );
5096: csi_gen_utility_pvt.put_line('l_mtl_txn_tbl.count : '||l_mtl_txn_tbl.count);
5097:
5098: IF l_mtl_txn_tbl.count > 0 THEN
5099: FOR l_ind IN l_mtl_txn_tbl.FIRST .. l_mtl_txn_tbl.LAST
5100: LOOP

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

5098: IF l_mtl_txn_tbl.count > 0 THEN
5099: FOR l_ind IN l_mtl_txn_tbl.FIRST .. l_mtl_txn_tbl.LAST
5100: LOOP
5101: -- Added debug lines for bug 6755879, FP of bug 6680634
5102: csi_gen_utility_pvt.put_line('l_mtl_txn_tbl('||l_ind||').transaction_id : '
5103: ||l_mtl_txn_tbl(l_ind).transaction_id);
5104: csi_gen_utility_pvt.put_line('l_mtl_txn_tbl('||l_ind||').transfer_transaction_id : '
5105: ||l_mtl_txn_tbl(l_ind).transfer_transaction_id);
5106: IF l_mtl_txn_tbl(l_ind).creation_date > l_txn_seq_start_date

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

5100: LOOP
5101: -- Added debug lines for bug 6755879, FP of bug 6680634
5102: csi_gen_utility_pvt.put_line('l_mtl_txn_tbl('||l_ind||').transaction_id : '
5103: ||l_mtl_txn_tbl(l_ind).transaction_id);
5104: csi_gen_utility_pvt.put_line('l_mtl_txn_tbl('||l_ind||').transfer_transaction_id : '
5105: ||l_mtl_txn_tbl(l_ind).transfer_transaction_id);
5106: IF l_mtl_txn_tbl(l_ind).creation_date > l_txn_seq_start_date
5107: AND l_mtl_txn_tbl(l_ind).creation_date < l_cur_mtl_txn_date
5108: AND l_mtl_txn_tbl(l_ind).transaction_id <> l_cur_mtl_txn_id

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

5152: WHEN NO_DATA_FOUND THEN
5153: NULL;
5154: END;
5155:
5156: csi_gen_utility_pvt.put_line(' l_err_mtl_txn_id : '||l_err_mtl_txn_id);
5157: csi_gen_utility_pvt.put_line(' l_err_mtl_txn_date : '||l_err_mtl_txn_date);
5158:
5159: IF (l_err_mtl_txn_date <> FND_API.G_MISS_DATE
5160: AND l_err_mtl_txn_date <= l_cur_mtl_txn_date)

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

5153: NULL;
5154: END;
5155:
5156: csi_gen_utility_pvt.put_line(' l_err_mtl_txn_id : '||l_err_mtl_txn_id);
5157: csi_gen_utility_pvt.put_line(' l_err_mtl_txn_date : '||l_err_mtl_txn_date);
5158:
5159: IF (l_err_mtl_txn_date <> FND_API.G_MISS_DATE
5160: AND l_err_mtl_txn_date <= l_cur_mtl_txn_date)
5161: OR (l_err_mtl_txn_date = FND_API.G_MISS_DATE) THEN

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

5253: IF p_instance_id IS NOT NULL AND
5254: p_instance_id <> FND_API.G_MISS_NUM THEN
5255: l_recount := 0;
5256: IF nvl(p_stop_all_txn,FND_API.G_TRUE) = FND_API.G_TRUE THEN
5257: csi_gen_utility_pvt.put_line('Stop All Txns..');
5258: BEGIN
5259: select count(*)
5260: into l_recount
5261: from CSI_II_FORWARD_SYNC_TEMP

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

5267: l_recount := 0;
5268: END;
5269: --
5270: ELSE
5271: csi_gen_utility_pvt.put_line('Stop Later Txns..');
5272: IF l_mtl_txn_id <> fnd_api.g_miss_num THEN
5273: Begin
5274: select creation_date
5275: into l_mtl_txn_cr_date

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

5378: l_config_header_id := to_char(p_config_hdr_id);
5379: l_config_rev_nbr := to_char(p_config_rev_nbr);
5380:
5381:
5382: csi_gen_utility_pvt.put_line('Queried from oe_lines: ' ||
5383: ' config-hdr: ' || l_config_header_id ||
5384: ' config-rev: ' || l_config_rev_nbr );
5385:
5386: -- profiles and env. variables.

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

5386: -- profiles and env. variables.
5387: l_database_id := fnd_web_config.database_id;
5388: l_icx_session_ticket := cz_cf_api.icx_session_ticket;
5389:
5390: csi_gen_utility_pvt.put_line('database_id: '||l_database_id);--,2);
5391:
5392: -- Set param_names
5393: -- Always required
5394: param_name(1) := 'ui_type'; -- we are passing null

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

5435: param_value(11) := 'TRUE';
5436: param_value(12) := l_icx_session_ticket;
5437:
5438:
5439: csi_gen_utility_pvt.put_line('Inside Create_hdr_xml, parameters are set');
5440: l_rec_index := 1;
5441: LOOP
5442: IF (param_value(l_rec_index) IS NOT NULL) THEN
5443: l_dummy := '

5453:
5454: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
5455:
5456: IF (l_debug_level > 0) THEN
5457: csi_gen_utility_pvt.put_line( 'Call to batch validation ');
5458: END IF;
5459:
5460: IF (l_debug_level > 1) THEN
5461: csi_gen_utility_pvt.dump_call_batch_val

Line 5461: csi_gen_utility_pvt.dump_call_batch_val

5457: csi_gen_utility_pvt.put_line( 'Call to batch validation ');
5458: END IF;
5459:
5460: IF (l_debug_level > 1) THEN
5461: csi_gen_utility_pvt.dump_call_batch_val
5462: ( p_api_version => 1.0
5463: ,p_init_msg_list => fnd_api.g_false
5464: ,p_parameter_name => param_name
5465: ,p_parameter_value => param_value

Line 5477: csi_gen_utility_pvt.put_line(' ');

5473: -- add termination tags
5474: l_xml_hdr := l_xml_hdr || '';
5475: l_xml_hdr := REPLACE(l_xml_hdr, ' ' , '+');
5476:
5477: csi_gen_utility_pvt.put_line(' ');
5478: csi_gen_utility_pvt.put_line
5479: ('1st Part of Create_hdr_xml is : '||SUBSTR(l_xml_hdr, 1, 200) );
5480: csi_gen_utility_pvt.put_line(' ');
5481: csi_gen_utility_pvt.put_line

Line 5478: csi_gen_utility_pvt.put_line

5474: l_xml_hdr := l_xml_hdr || '';
5475: l_xml_hdr := REPLACE(l_xml_hdr, ' ' , '+');
5476:
5477: csi_gen_utility_pvt.put_line(' ');
5478: csi_gen_utility_pvt.put_line
5479: ('1st Part of Create_hdr_xml is : '||SUBSTR(l_xml_hdr, 1, 200) );
5480: csi_gen_utility_pvt.put_line(' ');
5481: csi_gen_utility_pvt.put_line
5482: ('2nd Part of Create_hdr_xml is : '||SUBSTR(l_xml_hdr, 201, 200) );

Line 5480: csi_gen_utility_pvt.put_line(' ');

5476:
5477: csi_gen_utility_pvt.put_line(' ');
5478: csi_gen_utility_pvt.put_line
5479: ('1st Part of Create_hdr_xml is : '||SUBSTR(l_xml_hdr, 1, 200) );
5480: csi_gen_utility_pvt.put_line(' ');
5481: csi_gen_utility_pvt.put_line
5482: ('2nd Part of Create_hdr_xml is : '||SUBSTR(l_xml_hdr, 201, 200) );
5483: csi_gen_utility_pvt.put_line(' ');
5484: csi_gen_utility_pvt.put_line

Line 5481: csi_gen_utility_pvt.put_line

5477: csi_gen_utility_pvt.put_line(' ');
5478: csi_gen_utility_pvt.put_line
5479: ('1st Part of Create_hdr_xml is : '||SUBSTR(l_xml_hdr, 1, 200) );
5480: csi_gen_utility_pvt.put_line(' ');
5481: csi_gen_utility_pvt.put_line
5482: ('2nd Part of Create_hdr_xml is : '||SUBSTR(l_xml_hdr, 201, 200) );
5483: csi_gen_utility_pvt.put_line(' ');
5484: csi_gen_utility_pvt.put_line
5485: ('3rd Part of Create_hdr_xml is : '||SUBSTR(l_xml_hdr, 401, 200) );

Line 5483: csi_gen_utility_pvt.put_line(' ');

5479: ('1st Part of Create_hdr_xml is : '||SUBSTR(l_xml_hdr, 1, 200) );
5480: csi_gen_utility_pvt.put_line(' ');
5481: csi_gen_utility_pvt.put_line
5482: ('2nd Part of Create_hdr_xml is : '||SUBSTR(l_xml_hdr, 201, 200) );
5483: csi_gen_utility_pvt.put_line(' ');
5484: csi_gen_utility_pvt.put_line
5485: ('3rd Part of Create_hdr_xml is : '||SUBSTR(l_xml_hdr, 401, 200) );
5486: csi_gen_utility_pvt.put_line(' ');
5487: csi_gen_utility_pvt.put_line

Line 5484: csi_gen_utility_pvt.put_line

5480: csi_gen_utility_pvt.put_line(' ');
5481: csi_gen_utility_pvt.put_line
5482: ('2nd Part of Create_hdr_xml is : '||SUBSTR(l_xml_hdr, 201, 200) );
5483: csi_gen_utility_pvt.put_line(' ');
5484: csi_gen_utility_pvt.put_line
5485: ('3rd Part of Create_hdr_xml is : '||SUBSTR(l_xml_hdr, 401, 200) );
5486: csi_gen_utility_pvt.put_line(' ');
5487: csi_gen_utility_pvt.put_line
5488: ('4th Part of Create_hdr_xml is : '||SUBSTR(l_xml_hdr, 601, 200) );

Line 5486: csi_gen_utility_pvt.put_line(' ');

5482: ('2nd Part of Create_hdr_xml is : '||SUBSTR(l_xml_hdr, 201, 200) );
5483: csi_gen_utility_pvt.put_line(' ');
5484: csi_gen_utility_pvt.put_line
5485: ('3rd Part of Create_hdr_xml is : '||SUBSTR(l_xml_hdr, 401, 200) );
5486: csi_gen_utility_pvt.put_line(' ');
5487: csi_gen_utility_pvt.put_line
5488: ('4th Part of Create_hdr_xml is : '||SUBSTR(l_xml_hdr, 601, 200) );
5489:
5490: x_xml_hdr := l_xml_hdr;

Line 5487: csi_gen_utility_pvt.put_line

5483: csi_gen_utility_pvt.put_line(' ');
5484: csi_gen_utility_pvt.put_line
5485: ('3rd Part of Create_hdr_xml is : '||SUBSTR(l_xml_hdr, 401, 200) );
5486: csi_gen_utility_pvt.put_line(' ');
5487: csi_gen_utility_pvt.put_line
5488: ('4th Part of Create_hdr_xml is : '||SUBSTR(l_xml_hdr, 601, 200) );
5489:
5490: x_xml_hdr := l_xml_hdr;
5491: csi_gen_utility_pvt.put_line(' ');

Line 5491: csi_gen_utility_pvt.put_line(' ');

5487: csi_gen_utility_pvt.put_line
5488: ('4th Part of Create_hdr_xml is : '||SUBSTR(l_xml_hdr, 601, 200) );
5489:
5490: x_xml_hdr := l_xml_hdr;
5491: csi_gen_utility_pvt.put_line(' ');
5492: csi_gen_utility_pvt.put_line('length of ini msg:' || length(l_xml_hdr));
5493: csi_gen_utility_pvt.put_line('Leaving Create_hdr_xml');
5494: csi_gen_utility_pvt.put_line('------------------------------------- ');
5495: EXCEPTION

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

5488: ('4th Part of Create_hdr_xml is : '||SUBSTR(l_xml_hdr, 601, 200) );
5489:
5490: x_xml_hdr := l_xml_hdr;
5491: csi_gen_utility_pvt.put_line(' ');
5492: csi_gen_utility_pvt.put_line('length of ini msg:' || length(l_xml_hdr));
5493: csi_gen_utility_pvt.put_line('Leaving Create_hdr_xml');
5494: csi_gen_utility_pvt.put_line('------------------------------------- ');
5495: EXCEPTION
5496: WHEN OTHERS THEN

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

5489:
5490: x_xml_hdr := l_xml_hdr;
5491: csi_gen_utility_pvt.put_line(' ');
5492: csi_gen_utility_pvt.put_line('length of ini msg:' || length(l_xml_hdr));
5493: csi_gen_utility_pvt.put_line('Leaving Create_hdr_xml');
5494: csi_gen_utility_pvt.put_line('------------------------------------- ');
5495: EXCEPTION
5496: WHEN OTHERS THEN
5497: csi_gen_utility_pvt.put_line('exception in create_hdr_xml '|| sqlerrm);

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

5490: x_xml_hdr := l_xml_hdr;
5491: csi_gen_utility_pvt.put_line(' ');
5492: csi_gen_utility_pvt.put_line('length of ini msg:' || length(l_xml_hdr));
5493: csi_gen_utility_pvt.put_line('Leaving Create_hdr_xml');
5494: csi_gen_utility_pvt.put_line('------------------------------------- ');
5495: EXCEPTION
5496: WHEN OTHERS THEN
5497: csi_gen_utility_pvt.put_line('exception in create_hdr_xml '|| sqlerrm);
5498: x_return_status := FND_API.G_RET_STS_ERROR;

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

5493: csi_gen_utility_pvt.put_line('Leaving Create_hdr_xml');
5494: csi_gen_utility_pvt.put_line('------------------------------------- ');
5495: EXCEPTION
5496: WHEN OTHERS THEN
5497: csi_gen_utility_pvt.put_line('exception in create_hdr_xml '|| sqlerrm);
5498: x_return_status := FND_API.G_RET_STS_ERROR;
5499: END Create_hdr_xml;
5500:
5501:

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

5533:
5534: BEGIN
5535: l_return_status := FND_API.G_RET_STS_SUCCESS;
5536:
5537: csi_gen_utility_pvt.put_line('Entering Send_input_xml');
5538: csi_gen_utility_pvt.put_line('UImanager url: ' || l_url );
5539:
5540: l_xml_hdr := p_xml_hdr;
5541: csi_gen_utility_pvt.put_line('length of ini msg: ' || length(l_xml_hdr));

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

5534: BEGIN
5535: l_return_status := FND_API.G_RET_STS_SUCCESS;
5536:
5537: csi_gen_utility_pvt.put_line('Entering Send_input_xml');
5538: csi_gen_utility_pvt.put_line('UImanager url: ' || l_url );
5539:
5540: l_xml_hdr := p_xml_hdr;
5541: csi_gen_utility_pvt.put_line('length of ini msg: ' || length(l_xml_hdr));
5542:

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

5537: csi_gen_utility_pvt.put_line('Entering Send_input_xml');
5538: csi_gen_utility_pvt.put_line('UImanager url: ' || l_url );
5539:
5540: l_xml_hdr := p_xml_hdr;
5541: csi_gen_utility_pvt.put_line('length of ini msg: ' || length(l_xml_hdr));
5542:
5543:
5544: -- delete previous data.
5545: IF (l_html_pieces.COUNT <> 0) THEN

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

5553: URL => l_url ,
5554: p_validation_type => cz_api_pub.validate_fulfillment
5555: );
5556:
5557: csi_gen_utility_pvt.put_line('After call to batch validation the status is : '||l_validation_status );
5558:
5559:
5560: IF l_validation_status <> 0 THEN
5561: l_return_status := FND_API.G_RET_STS_ERROR;

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

5575: IF l_html_pieces.COUNT >0
5576: THEN
5577: l_rec_index := l_html_pieces.FIRST;
5578: LOOP
5579: csi_gen_utility_pvt.put_line(l_rec_index ||': Part of output_message: ' ||
5580: SUBSTR(l_html_pieces(l_rec_index), 1, 100) );
5581:
5582: l_long_xml := l_long_xml || l_html_pieces(l_rec_index);
5583:

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

5589:
5590: -- if everything ok, set out values
5591: x_out_xml_msg := l_long_xml;
5592: x_return_status := l_return_status;
5593: csi_gen_utility_pvt.put_line('Exiting csi_config_util.Send_input_xml');
5594: EXCEPTION
5595: WHEN OTHERS THEN
5596: x_return_status := FND_API.G_RET_STS_ERROR;
5597: csi_gen_utility_pvt.put_line( 'Inside Send_input_xml when others exception: ' ||substr(sqlerrm,1,100));

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

5593: csi_gen_utility_pvt.put_line('Exiting csi_config_util.Send_input_xml');
5594: EXCEPTION
5595: WHEN OTHERS THEN
5596: x_return_status := FND_API.G_RET_STS_ERROR;
5597: csi_gen_utility_pvt.put_line( 'Inside Send_input_xml when others exception: ' ||substr(sqlerrm,1,100));
5598: END Send_input_xml;
5599:
5600: PROCEDURE Parse_output_xml
5601: ( p_xml IN LONG,

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

5663: l_flag VARCHAR2(1) := 'N';
5664:
5665: BEGIN
5666:
5667: csi_gen_utility_pvt.put_line('Entering Parse_output_xml');
5668:
5669: l_exit_start_pos :=
5670: INSTR(p_xml, l_exit_start_tag,1, 1) +
5671: length(l_exit_start_tag);

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

5675:
5676: l_exit := SUBSTR (p_xml, l_exit_start_pos,
5677: l_exit_end_pos - l_exit_start_pos + 1);
5678:
5679: csi_gen_utility_pvt.put_line('l_exit: '||l_exit);
5680:
5681: -- if error go to msg etc.
5682: IF nvl(l_exit,'error') <> 'error' THEN
5683:

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

5690: l_valid_config := SUBSTR( p_xml, l_valid_config_start_pos,
5691: l_valid_config_end_pos -
5692: l_valid_config_start_pos + 1);
5693:
5694: csi_gen_utility_pvt.put_line('l_valid_config: '|| l_valid_config);
5695:
5696: l_complete_config_start_pos :=
5697: INSTR(p_xml, l_complete_config_start_tag,1, 1)+length(l_complete_config_start_tag);
5698: l_complete_config_end_pos :=

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

5701: l_complete_config := SUBSTR( p_xml, l_complete_config_start_pos,
5702: l_complete_config_end_pos -
5703: l_complete_config_start_pos + 1);
5704:
5705: csi_gen_utility_pvt.put_line('l_complete_config '|| l_complete_config);
5706:
5707:
5708: IF (nvl(l_valid_config, 'N') <> 'true') THEN
5709: csi_gen_utility_pvt.put_line(' Returned valid_flag as null/false');

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

5705: csi_gen_utility_pvt.put_line('l_complete_config '|| l_complete_config);
5706:
5707:
5708: IF (nvl(l_valid_config, 'N') <> 'true') THEN
5709: csi_gen_utility_pvt.put_line(' Returned valid_flag as null/false');
5710: l_flag := 'Y';
5711: END IF ;
5712:
5713:

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

5711: END IF ;
5712:
5713:
5714: IF (nvl(l_complete_config, 'N') <> 'true' ) THEN
5715: csi_gen_utility_pvt.put_line('Returned complete_flag as null/false');
5716: l_flag := 'Y';
5717: END IF;
5718:
5719:

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

5729: l_message_text := SUBSTR( p_xml, l_message_text_start_pos,
5730: l_message_text_end_pos -
5731: l_message_text_start_pos + 1);
5732:
5733: csi_gen_utility_pvt.put_line('l_message_text is: '||l_message_text);
5734:
5735: l_message_type_start_pos :=
5736: INSTR(p_xml, l_message_type_start_tag,1, 1)+length(l_message_type_start_tag);
5737: l_message_type_end_pos :=

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

5745: -- get the latest config_header_id, and rev_nbr to get
5746: -- messages if any.
5747:
5748:
5749: csi_gen_utility_pvt.put_line('l_message_type is : '|| l_message_type);
5750:
5751:
5752: l_config_header_id_start_pos :=
5753: INSTR(p_xml, l_config_header_id_start_tag, 1, 1)+length(l_config_header_id_start_tag);

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

5771: to_number(SUBSTR( p_xml,l_config_rev_nbr_start_pos,
5772: l_config_rev_nbr_end_pos -
5773: l_config_rev_nbr_start_pos + 1));
5774:
5775: csi_gen_utility_pvt.put_line('Returned config_header_id as:' ||to_char(l_config_header_id));
5776: csi_gen_utility_pvt.put_line('Returned config_rev_nbr as:' ||to_char(l_config_rev_nbr));
5777:
5778:
5779:

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

5772: l_config_rev_nbr_end_pos -
5773: l_config_rev_nbr_start_pos + 1));
5774:
5775: csi_gen_utility_pvt.put_line('Returned config_header_id as:' ||to_char(l_config_header_id));
5776: csi_gen_utility_pvt.put_line('Returned config_rev_nbr as:' ||to_char(l_config_rev_nbr));
5777:
5778:
5779:
5780:

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

5781: IF (l_flag = 'Y' ) OR
5782: l_exit is NULL OR
5783: l_exit = 'error' THEN
5784:
5785: csi_gen_utility_pvt.put_line('Getting messages from cz_config_messages');
5786:
5787: OPEN messages(l_config_header_id, l_config_rev_nbr);
5788:
5789: LOOP

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

5789: LOOP
5790: FETCH messages INTO l_constraint,l_msg;
5791: EXIT WHEN messages%notfound;
5792:
5793: csi_gen_utility_pvt.put_line('msg : '|| substr(l_msg, 1, 250));
5794: END LOOP;
5795: /*
5796: IF nvl(l_valid_config, 'false') = 'false'
5797: OR l_exit = 'error'

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

5799: l_return_status:=FND_API.G_RET_STS_ERROR;
5800: FND_MESSAGE.Set_Name('CSI', 'CSI_BATCH_VALIDATE');
5801: FND_MESSAGE.Set_token('ERR_TEXT' , 'Error returned from cz_network_api_pub.Validate, from Parse_output_xml ' );
5802: FND_MSG_PUB.ADD;
5803: csi_gen_utility_pvt.put_line('Configuration is invalid/incomplete');
5804: END IF;
5805: */
5806:
5807:

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

5814: -- if everything ok, set return values
5815: x_return_status := l_return_status;
5816:
5817:
5818: csi_gen_utility_pvt.put_line('Exiting parse_output_xml');
5819:
5820: EXCEPTION
5821: WHEN OTHERS THEN
5822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

5819:
5820: EXCEPTION
5821: WHEN OTHERS THEN
5822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5823: csi_gen_utility_pvt.put_line( 'Parse_Output_xml error: ' || substr(sqlerrm,1,100));
5824:
5825: END Parse_output_xml;
5826:
5827: -- End addition by sguthiva for att enhancements

Line 6166: csi_gen_utility_pvt.populate_install_param_rec;

6162:
6163: BEGIN
6164:
6165: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
6166: csi_gen_utility_pvt.populate_install_param_rec;
6167: END IF;
6168:
6169: l_txn_seq_start_date := csi_datastructures_pub.g_install_param_rec.txn_seq_start_date;
6170: IF l_txn_seq_start_date is null THEN