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_MASS_EDIT_PVT dependencies on FND_MESSAGE

Line 144: FND_MESSAGE.set_name('CSI','CSI_MU_MISSING_INSTANCE');

140: LOOP
141: IF NVL(px_mass_edit_inst_tbl(i).instance_id , fnd_api.g_miss_num)
142: = fnd_api.g_miss_num
143: THEN
144: FND_MESSAGE.set_name('CSI','CSI_MU_MISSING_INSTANCE');
145: FND_MESSAGE.set_token('BATCH_NAME',px_mass_edit_rec.name) ;
146: FND_MESSAGE.set_token('TXN_LINE_DETAIL_ID',px_mass_edit_inst_tbl(i).txn_line_detail_id) ;
147: log_mu_error
148: (

Line 145: FND_MESSAGE.set_token('BATCH_NAME',px_mass_edit_rec.name) ;

141: IF NVL(px_mass_edit_inst_tbl(i).instance_id , fnd_api.g_miss_num)
142: = fnd_api.g_miss_num
143: THEN
144: FND_MESSAGE.set_name('CSI','CSI_MU_MISSING_INSTANCE');
145: FND_MESSAGE.set_token('BATCH_NAME',px_mass_edit_rec.name) ;
146: FND_MESSAGE.set_token('TXN_LINE_DETAIL_ID',px_mass_edit_inst_tbl(i).txn_line_detail_id) ;
147: log_mu_error
148: (
149: p_index => 1,

Line 146: FND_MESSAGE.set_token('TXN_LINE_DETAIL_ID',px_mass_edit_inst_tbl(i).txn_line_detail_id) ;

142: = fnd_api.g_miss_num
143: THEN
144: FND_MESSAGE.set_name('CSI','CSI_MU_MISSING_INSTANCE');
145: FND_MESSAGE.set_token('BATCH_NAME',px_mass_edit_rec.name) ;
146: FND_MESSAGE.set_token('TXN_LINE_DETAIL_ID',px_mass_edit_inst_tbl(i).txn_line_detail_id) ;
147: log_mu_error
148: (
149: p_index => 1,
150: p_instance_id => px_mass_edit_inst_tbl(i).instance_id,

Line 209: FND_MESSAGE.set_name('CSI','CSI_MU_INVALID_INSTANCE');

205: OPEN instance_csr (px_mass_edit_inst_tbl(inst_idx).instance_id);
206: FETCH instance_csr INTO l_instance_csr;
207: IF instance_csr%NOTFOUND Then
208: CLOSE instance_csr;
209: FND_MESSAGE.set_name('CSI','CSI_MU_INVALID_INSTANCE');
210: FND_MESSAGE.set_token('BATCH_NAME',px_mass_edit_rec.name) ;
211: FND_MESSAGE.set_token('INSTANCE_ID',px_mass_edit_inst_tbl(inst_idx).instance_id) ;
212: log_mu_error
213: (

Line 210: FND_MESSAGE.set_token('BATCH_NAME',px_mass_edit_rec.name) ;

206: FETCH instance_csr INTO l_instance_csr;
207: IF instance_csr%NOTFOUND Then
208: CLOSE instance_csr;
209: FND_MESSAGE.set_name('CSI','CSI_MU_INVALID_INSTANCE');
210: FND_MESSAGE.set_token('BATCH_NAME',px_mass_edit_rec.name) ;
211: FND_MESSAGE.set_token('INSTANCE_ID',px_mass_edit_inst_tbl(inst_idx).instance_id) ;
212: log_mu_error
213: (
214: p_index => nvl(l_mass_edit_error_tbl.last, 0) + 1,

Line 211: FND_MESSAGE.set_token('INSTANCE_ID',px_mass_edit_inst_tbl(inst_idx).instance_id) ;

207: IF instance_csr%NOTFOUND Then
208: CLOSE instance_csr;
209: FND_MESSAGE.set_name('CSI','CSI_MU_INVALID_INSTANCE');
210: FND_MESSAGE.set_token('BATCH_NAME',px_mass_edit_rec.name) ;
211: FND_MESSAGE.set_token('INSTANCE_ID',px_mass_edit_inst_tbl(inst_idx).instance_id) ;
212: log_mu_error
213: (
214: p_index => nvl(l_mass_edit_error_tbl.last, 0) + 1,
215: p_instance_id => px_mass_edit_inst_tbl(inst_idx).instance_id,

Line 296: FND_MESSAGE.set_name('CSI','CSI_INT_INST_OWNER_MISSING');

292: END IF; -- Check for Internal Party ID
293: Exception
294: When No_data_found Then
295: -- there has to be only one record here else an exception
296: FND_MESSAGE.set_name('CSI','CSI_INT_INST_OWNER_MISSING');
297: FND_MESSAGE.set_token('INSTANCE_ID',l_instance_csr.instance_id);
298: log_mu_error
299: (
300: p_index => nvl(l_mass_edit_error_tbl.last, 0) + 1,

Line 297: FND_MESSAGE.set_token('INSTANCE_ID',l_instance_csr.instance_id);

293: Exception
294: When No_data_found Then
295: -- there has to be only one record here else an exception
296: FND_MESSAGE.set_name('CSI','CSI_INT_INST_OWNER_MISSING');
297: FND_MESSAGE.set_token('INSTANCE_ID',l_instance_csr.instance_id);
298: log_mu_error
299: (
300: p_index => nvl(l_mass_edit_error_tbl.last, 0) + 1,
301: p_instance_id => l_instance_csr.instance_id,

Line 308: FND_MESSAGE.set_name('CSI','CSI_MANY_INST_OWNER_FOUND');

304: x_mass_edit_error_tbl => l_mass_edit_error_tbl
305: );
306: RAISE fnd_api.g_exc_error;
307: When too_many_rows Then
308: FND_MESSAGE.set_name('CSI','CSI_MANY_INST_OWNER_FOUND');
309: FND_MESSAGE.set_token('INSTANCE_ID',l_instance_csr.instance_id);
310: log_mu_error
311: (
312: p_index => nvl(l_mass_edit_error_tbl.last, 0) + 1,

Line 309: FND_MESSAGE.set_token('INSTANCE_ID',l_instance_csr.instance_id);

305: );
306: RAISE fnd_api.g_exc_error;
307: When too_many_rows Then
308: FND_MESSAGE.set_name('CSI','CSI_MANY_INST_OWNER_FOUND');
309: FND_MESSAGE.set_token('INSTANCE_ID',l_instance_csr.instance_id);
310: log_mu_error
311: (
312: p_index => nvl(l_mass_edit_error_tbl.last, 0) + 1,
313: p_instance_id => l_instance_csr.instance_id,

Line 320: FND_MESSAGE.set_name('CSI','CSI_API_OWNER_OTHERS_EXCEPTION');

316: x_mass_edit_error_tbl => l_mass_edit_error_tbl
317: );
318: RAISE fnd_api.g_exc_error;
319: When others Then
320: FND_MESSAGE.set_name('CSI','CSI_API_OWNER_OTHERS_EXCEPTION');
321: log_mu_error
322: (
323: p_index => nvl(l_mass_edit_error_tbl.last, 0) + 1,
324: p_instance_id => l_instance_csr.instance_id,

Line 524: FND_MESSAGE.set_name('CSI','CSI_MU_DUPLICATE_BATCH_NAME');

520: CLOSE dup_batch_name;
521:
522: IF l_dup_batch_name IS NOT NULL THEN
523: debug('Duplicate Batch Name: '||p_batch_name||' Batch ID: '||p_batch_id);
524: FND_MESSAGE.set_name('CSI','CSI_MU_DUPLICATE_BATCH_NAME');
525: FND_MESSAGE.set_token('BATCH_NAME',p_batch_name) ;
526: Return FALSE;
527: END IF;
528:

Line 525: FND_MESSAGE.set_token('BATCH_NAME',p_batch_name) ;

521:
522: IF l_dup_batch_name IS NOT NULL THEN
523: debug('Duplicate Batch Name: '||p_batch_name||' Batch ID: '||p_batch_id);
524: FND_MESSAGE.set_name('CSI','CSI_MU_DUPLICATE_BATCH_NAME');
525: FND_MESSAGE.set_token('BATCH_NAME',p_batch_name) ;
526: Return FALSE;
527: END IF;
528:
529: END IF;

Line 602: FND_MESSAGE.set_name('CSI','CSI_MU_DUPLICATE_BATCH_NAME');

598: END IF;
599:
600: EXCEPTION
601: WHEN fnd_api.g_exc_error THEN
602: FND_MESSAGE.set_name('CSI','CSI_MU_DUPLICATE_BATCH_NAME');
603: FND_MESSAGE.set_token('BATCH_NAME',p_batch_name) ;
604: log_mu_error
605: (
606: p_index => 1,

Line 603: FND_MESSAGE.set_token('BATCH_NAME',p_batch_name) ;

599:
600: EXCEPTION
601: WHEN fnd_api.g_exc_error THEN
602: FND_MESSAGE.set_name('CSI','CSI_MU_DUPLICATE_BATCH_NAME');
603: FND_MESSAGE.set_token('BATCH_NAME',p_batch_name) ;
604: log_mu_error
605: (
606: p_index => 1,
607: p_instance_id => null,

Line 614: fnd_message.set_name('CSI','CSI_INT_UNEXP_SQL_ERROR');

610: x_mass_edit_error_tbl => x_mass_edit_error_tbl
611: );
612: Raise;
613: WHEN OTHERS THEN
614: fnd_message.set_name('CSI','CSI_INT_UNEXP_SQL_ERROR');
615: fnd_message.set_token('SQL_ERROR',SQLERRM);
616: log_mu_error
617: (
618: p_index => 1,

Line 615: fnd_message.set_token('SQL_ERROR',SQLERRM);

611: );
612: Raise;
613: WHEN OTHERS THEN
614: fnd_message.set_name('CSI','CSI_INT_UNEXP_SQL_ERROR');
615: fnd_message.set_token('SQL_ERROR',SQLERRM);
616: log_mu_error
617: (
618: p_index => 1,
619: p_instance_id => null,

Line 654: FND_MESSAGE.set_name('CSI','CSI_MU_INVALID_BATCH_TYPE');

650: x_sub_type_id := l_sub_type_id;
651:
652: EXCEPTION
653: WHEN NO_DATA_FOUND THEN
654: FND_MESSAGE.set_name('CSI','CSI_MU_INVALID_BATCH_TYPE');
655: FND_MESSAGE.set_token('BATCH_TYPE',p_batch_type) ;
656: log_mu_error
657: (
658: p_index => 1,

Line 655: FND_MESSAGE.set_token('BATCH_TYPE',p_batch_type) ;

651:
652: EXCEPTION
653: WHEN NO_DATA_FOUND THEN
654: FND_MESSAGE.set_name('CSI','CSI_MU_INVALID_BATCH_TYPE');
655: FND_MESSAGE.set_token('BATCH_TYPE',p_batch_type) ;
656: log_mu_error
657: (
658: p_index => 1,
659: p_instance_id => null,

Line 666: fnd_message.set_name('CSI','CSI_INT_UNEXP_SQL_ERROR');

662: x_mass_edit_error_tbl => x_mass_edit_error_tbl
663: );
664: Raise;
665: WHEN OTHERS THEN
666: fnd_message.set_name('CSI','CSI_INT_UNEXP_SQL_ERROR');
667: fnd_message.set_token('SQL_ERROR',SQLERRM);
668: log_mu_error
669: (
670: p_index => 1,

Line 667: fnd_message.set_token('SQL_ERROR',SQLERRM);

663: );
664: Raise;
665: WHEN OTHERS THEN
666: fnd_message.set_name('CSI','CSI_INT_UNEXP_SQL_ERROR');
667: fnd_message.set_token('SQL_ERROR',SQLERRM);
668: log_mu_error
669: (
670: p_index => 1,
671: p_instance_id => null,

Line 712: FND_MESSAGE.set_name('CSI','CSI_MU_BATCH_UPD_DISALLOWED');

708: END IF;
709:
710: EXCEPTION
711: WHEN fnd_api.g_exc_error THEN
712: FND_MESSAGE.set_name('CSI','CSI_MU_BATCH_UPD_DISALLOWED');
713: FND_MESSAGE.set_token('BATCH_STATUS',l_status) ;
714: FND_MESSAGE.set_token('BATCH_NAME',g_batch_name) ;
715: log_mu_error
716: (

Line 713: FND_MESSAGE.set_token('BATCH_STATUS',l_status) ;

709:
710: EXCEPTION
711: WHEN fnd_api.g_exc_error THEN
712: FND_MESSAGE.set_name('CSI','CSI_MU_BATCH_UPD_DISALLOWED');
713: FND_MESSAGE.set_token('BATCH_STATUS',l_status) ;
714: FND_MESSAGE.set_token('BATCH_NAME',g_batch_name) ;
715: log_mu_error
716: (
717: p_index => 1,

Line 714: FND_MESSAGE.set_token('BATCH_NAME',g_batch_name) ;

710: EXCEPTION
711: WHEN fnd_api.g_exc_error THEN
712: FND_MESSAGE.set_name('CSI','CSI_MU_BATCH_UPD_DISALLOWED');
713: FND_MESSAGE.set_token('BATCH_STATUS',l_status) ;
714: FND_MESSAGE.set_token('BATCH_NAME',g_batch_name) ;
715: log_mu_error
716: (
717: p_index => 1,
718: p_instance_id => null,

Line 725: FND_MESSAGE.set_name('CSI','CSI_MU_INVALID_BATCH_STATUS');

721: x_mass_edit_error_tbl => x_mass_edit_error_tbl
722: );
723: Raise;
724: WHEN fnd_api.g_exc_unexpected_error THEN
725: FND_MESSAGE.set_name('CSI','CSI_MU_INVALID_BATCH_STATUS');
726: FND_MESSAGE.set_token('BATCH_STATUS',l_status) ;
727: FND_MESSAGE.set_token('BATCH_NAME',g_batch_name) ;
728: log_mu_error
729: (

Line 726: FND_MESSAGE.set_token('BATCH_STATUS',l_status) ;

722: );
723: Raise;
724: WHEN fnd_api.g_exc_unexpected_error THEN
725: FND_MESSAGE.set_name('CSI','CSI_MU_INVALID_BATCH_STATUS');
726: FND_MESSAGE.set_token('BATCH_STATUS',l_status) ;
727: FND_MESSAGE.set_token('BATCH_NAME',g_batch_name) ;
728: log_mu_error
729: (
730: p_index => 1,

Line 727: FND_MESSAGE.set_token('BATCH_NAME',g_batch_name) ;

723: Raise;
724: WHEN fnd_api.g_exc_unexpected_error THEN
725: FND_MESSAGE.set_name('CSI','CSI_MU_INVALID_BATCH_STATUS');
726: FND_MESSAGE.set_token('BATCH_STATUS',l_status) ;
727: FND_MESSAGE.set_token('BATCH_NAME',g_batch_name) ;
728: log_mu_error
729: (
730: p_index => 1,
731: p_instance_id => null,

Line 738: fnd_message.set_name('CSI','CSI_INT_UNEXP_SQL_ERROR');

734: x_mass_edit_error_tbl => x_mass_edit_error_tbl
735: );
736: Raise;
737: WHEN OTHERS THEN
738: fnd_message.set_name('CSI','CSI_INT_UNEXP_SQL_ERROR');
739: fnd_message.set_token('SQL_ERROR',SQLERRM);
740: log_mu_error
741: (
742: p_index => 1,

Line 739: fnd_message.set_token('SQL_ERROR',SQLERRM);

735: );
736: Raise;
737: WHEN OTHERS THEN
738: fnd_message.set_name('CSI','CSI_INT_UNEXP_SQL_ERROR');
739: fnd_message.set_token('SQL_ERROR',SQLERRM);
740: log_mu_error
741: (
742: p_index => 1,
743: p_instance_id => null,

Line 765: x_mass_edit_error_tbl(p_index).error_text := fnd_message.get;

761: x_mass_edit_error_tbl(p_index).name := g_batch_name;
762: x_mass_edit_error_tbl(p_index).txn_line_detail_id := p_txn_line_detail_id;
763: x_mass_edit_error_tbl(p_index).instance_id := p_instance_id;
764: x_mass_edit_error_tbl(p_index).error_code := p_error_code;
765: x_mass_edit_error_tbl(p_index).error_text := fnd_message.get;
766: END log_mu_error;
767:
768:
769: PROCEDURE UPDATE_MASS_EDIT_BATCH (

Line 865: FND_MESSAGE.set_name('CSI','CSI_MU_INVALID_BATCH_NAME');

861: x_mass_edit_rec => px_mass_edit_rec
862: )
863: THEN
864: IF nvl(px_mass_edit_rec.entry_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
865: FND_MESSAGE.set_name('CSI','CSI_MU_INVALID_BATCH_NAME');
866: FND_MESSAGE.set_token('BATCH_NAME',px_mass_edit_rec.name);
867: ELSE
868: FND_MESSAGE.set_name('CSI','CSI_MU_INVALID_BATCH_ID');
869: FND_MESSAGE.set_token('BATCH_ID',px_mass_edit_rec.entry_id);

Line 866: FND_MESSAGE.set_token('BATCH_NAME',px_mass_edit_rec.name);

862: )
863: THEN
864: IF nvl(px_mass_edit_rec.entry_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
865: FND_MESSAGE.set_name('CSI','CSI_MU_INVALID_BATCH_NAME');
866: FND_MESSAGE.set_token('BATCH_NAME',px_mass_edit_rec.name);
867: ELSE
868: FND_MESSAGE.set_name('CSI','CSI_MU_INVALID_BATCH_ID');
869: FND_MESSAGE.set_token('BATCH_ID',px_mass_edit_rec.entry_id);
870: END IF;

Line 868: FND_MESSAGE.set_name('CSI','CSI_MU_INVALID_BATCH_ID');

864: IF nvl(px_mass_edit_rec.entry_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
865: FND_MESSAGE.set_name('CSI','CSI_MU_INVALID_BATCH_NAME');
866: FND_MESSAGE.set_token('BATCH_NAME',px_mass_edit_rec.name);
867: ELSE
868: FND_MESSAGE.set_name('CSI','CSI_MU_INVALID_BATCH_ID');
869: FND_MESSAGE.set_token('BATCH_ID',px_mass_edit_rec.entry_id);
870: END IF;
871:
872: log_mu_error

Line 869: FND_MESSAGE.set_token('BATCH_ID',px_mass_edit_rec.entry_id);

865: FND_MESSAGE.set_name('CSI','CSI_MU_INVALID_BATCH_NAME');
866: FND_MESSAGE.set_token('BATCH_NAME',px_mass_edit_rec.name);
867: ELSE
868: FND_MESSAGE.set_name('CSI','CSI_MU_INVALID_BATCH_ID');
869: FND_MESSAGE.set_token('BATCH_ID',px_mass_edit_rec.entry_id);
870: END IF;
871:
872: log_mu_error
873: (

Line 890: FND_MESSAGE.SET_NAME('CSI','CSI_MU_BATCH_INST_ON_DTL_REC');

886: IF nvl(px_txn_line_detail_rec.txn_line_detail_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
887: IF nvl(px_txn_line_detail_rec.instance_id,fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
888: -- trying to provide an instance on the dummy line detail rec for mass update
889: l_invalid_operation := 'Y';
890: FND_MESSAGE.SET_NAME('CSI','CSI_MU_BATCH_INST_ON_DTL_REC');
891: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',px_txn_line_detail_rec.instance_id);
892: FND_MESSAGE.SET_TOKEN('TXN_LINE_DETAIL_ID',px_txn_line_detail_rec.txn_line_detail_id);
893: FND_MESSAGE.set_token('BATCH_NAME',px_mass_edit_rec.name);
894: ELSIF px_txn_line_detail_rec.txn_line_detail_id <> px_mass_edit_rec.txn_line_detail_id THEN

Line 891: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',px_txn_line_detail_rec.instance_id);

887: IF nvl(px_txn_line_detail_rec.instance_id,fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
888: -- trying to provide an instance on the dummy line detail rec for mass update
889: l_invalid_operation := 'Y';
890: FND_MESSAGE.SET_NAME('CSI','CSI_MU_BATCH_INST_ON_DTL_REC');
891: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',px_txn_line_detail_rec.instance_id);
892: FND_MESSAGE.SET_TOKEN('TXN_LINE_DETAIL_ID',px_txn_line_detail_rec.txn_line_detail_id);
893: FND_MESSAGE.set_token('BATCH_NAME',px_mass_edit_rec.name);
894: ELSIF px_txn_line_detail_rec.txn_line_detail_id <> px_mass_edit_rec.txn_line_detail_id THEN
895: l_invalid_operation := 'Y';

Line 892: FND_MESSAGE.SET_TOKEN('TXN_LINE_DETAIL_ID',px_txn_line_detail_rec.txn_line_detail_id);

888: -- trying to provide an instance on the dummy line detail rec for mass update
889: l_invalid_operation := 'Y';
890: FND_MESSAGE.SET_NAME('CSI','CSI_MU_BATCH_INST_ON_DTL_REC');
891: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',px_txn_line_detail_rec.instance_id);
892: FND_MESSAGE.SET_TOKEN('TXN_LINE_DETAIL_ID',px_txn_line_detail_rec.txn_line_detail_id);
893: FND_MESSAGE.set_token('BATCH_NAME',px_mass_edit_rec.name);
894: ELSIF px_txn_line_detail_rec.txn_line_detail_id <> px_mass_edit_rec.txn_line_detail_id THEN
895: l_invalid_operation := 'Y';
896: FND_MESSAGE.SET_NAME('CSI','CSI_MU_BATCH_INVALID_DATA');

Line 893: FND_MESSAGE.set_token('BATCH_NAME',px_mass_edit_rec.name);

889: l_invalid_operation := 'Y';
890: FND_MESSAGE.SET_NAME('CSI','CSI_MU_BATCH_INST_ON_DTL_REC');
891: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',px_txn_line_detail_rec.instance_id);
892: FND_MESSAGE.SET_TOKEN('TXN_LINE_DETAIL_ID',px_txn_line_detail_rec.txn_line_detail_id);
893: FND_MESSAGE.set_token('BATCH_NAME',px_mass_edit_rec.name);
894: ELSIF px_txn_line_detail_rec.txn_line_detail_id <> px_mass_edit_rec.txn_line_detail_id THEN
895: l_invalid_operation := 'Y';
896: FND_MESSAGE.SET_NAME('CSI','CSI_MU_BATCH_INVALID_DATA');
897: FND_MESSAGE.SET_TOKEN('TXN_LINE_DETAIL_ID1',px_mass_edit_rec.txn_line_detail_id);

Line 896: FND_MESSAGE.SET_NAME('CSI','CSI_MU_BATCH_INVALID_DATA');

892: FND_MESSAGE.SET_TOKEN('TXN_LINE_DETAIL_ID',px_txn_line_detail_rec.txn_line_detail_id);
893: FND_MESSAGE.set_token('BATCH_NAME',px_mass_edit_rec.name);
894: ELSIF px_txn_line_detail_rec.txn_line_detail_id <> px_mass_edit_rec.txn_line_detail_id THEN
895: l_invalid_operation := 'Y';
896: FND_MESSAGE.SET_NAME('CSI','CSI_MU_BATCH_INVALID_DATA');
897: FND_MESSAGE.SET_TOKEN('TXN_LINE_DETAIL_ID1',px_mass_edit_rec.txn_line_detail_id);
898: FND_MESSAGE.SET_TOKEN('TXN_LINE_DETAIL_ID2',px_txn_line_detail_rec.txn_line_detail_id);
899: FND_MESSAGE.set_token('BATCH_NAME',px_mass_edit_rec.name);
900: END IF;

Line 897: FND_MESSAGE.SET_TOKEN('TXN_LINE_DETAIL_ID1',px_mass_edit_rec.txn_line_detail_id);

893: FND_MESSAGE.set_token('BATCH_NAME',px_mass_edit_rec.name);
894: ELSIF px_txn_line_detail_rec.txn_line_detail_id <> px_mass_edit_rec.txn_line_detail_id THEN
895: l_invalid_operation := 'Y';
896: FND_MESSAGE.SET_NAME('CSI','CSI_MU_BATCH_INVALID_DATA');
897: FND_MESSAGE.SET_TOKEN('TXN_LINE_DETAIL_ID1',px_mass_edit_rec.txn_line_detail_id);
898: FND_MESSAGE.SET_TOKEN('TXN_LINE_DETAIL_ID2',px_txn_line_detail_rec.txn_line_detail_id);
899: FND_MESSAGE.set_token('BATCH_NAME',px_mass_edit_rec.name);
900: END IF;
901: IF l_invalid_operation = 'Y' THEN

Line 898: FND_MESSAGE.SET_TOKEN('TXN_LINE_DETAIL_ID2',px_txn_line_detail_rec.txn_line_detail_id);

894: ELSIF px_txn_line_detail_rec.txn_line_detail_id <> px_mass_edit_rec.txn_line_detail_id THEN
895: l_invalid_operation := 'Y';
896: FND_MESSAGE.SET_NAME('CSI','CSI_MU_BATCH_INVALID_DATA');
897: FND_MESSAGE.SET_TOKEN('TXN_LINE_DETAIL_ID1',px_mass_edit_rec.txn_line_detail_id);
898: FND_MESSAGE.SET_TOKEN('TXN_LINE_DETAIL_ID2',px_txn_line_detail_rec.txn_line_detail_id);
899: FND_MESSAGE.set_token('BATCH_NAME',px_mass_edit_rec.name);
900: END IF;
901: IF l_invalid_operation = 'Y' THEN
902: log_mu_error

Line 899: FND_MESSAGE.set_token('BATCH_NAME',px_mass_edit_rec.name);

895: l_invalid_operation := 'Y';
896: FND_MESSAGE.SET_NAME('CSI','CSI_MU_BATCH_INVALID_DATA');
897: FND_MESSAGE.SET_TOKEN('TXN_LINE_DETAIL_ID1',px_mass_edit_rec.txn_line_detail_id);
898: FND_MESSAGE.SET_TOKEN('TXN_LINE_DETAIL_ID2',px_txn_line_detail_rec.txn_line_detail_id);
899: FND_MESSAGE.set_token('BATCH_NAME',px_mass_edit_rec.name);
900: END IF;
901: IF l_invalid_operation = 'Y' THEN
902: log_mu_error
903: (

Line 1004: FND_MESSAGE.set_name('CSI','CSI_MU_INVALID_INSTANCE');

1000: OPEN instance_csr (px_mass_edit_inst_tbl(inst_idx).instance_id);
1001: FETCH instance_csr INTO l_instance_csr;
1002: IF instance_csr%NOTFOUND Then
1003: CLOSE instance_csr;
1004: FND_MESSAGE.set_name('CSI','CSI_MU_INVALID_INSTANCE');
1005: FND_MESSAGE.set_token('INSTANCE_ID',px_mass_edit_inst_tbl(inst_idx).instance_id) ;
1006: FND_MESSAGE.set_token('BATCH_NAME',px_mass_edit_rec.name);
1007: log_mu_error
1008: (

Line 1005: FND_MESSAGE.set_token('INSTANCE_ID',px_mass_edit_inst_tbl(inst_idx).instance_id) ;

1001: FETCH instance_csr INTO l_instance_csr;
1002: IF instance_csr%NOTFOUND Then
1003: CLOSE instance_csr;
1004: FND_MESSAGE.set_name('CSI','CSI_MU_INVALID_INSTANCE');
1005: FND_MESSAGE.set_token('INSTANCE_ID',px_mass_edit_inst_tbl(inst_idx).instance_id) ;
1006: FND_MESSAGE.set_token('BATCH_NAME',px_mass_edit_rec.name);
1007: log_mu_error
1008: (
1009: p_index => nvl(l_mass_edit_error_tbl.last, 0) + 1,

Line 1006: FND_MESSAGE.set_token('BATCH_NAME',px_mass_edit_rec.name);

1002: IF instance_csr%NOTFOUND Then
1003: CLOSE instance_csr;
1004: FND_MESSAGE.set_name('CSI','CSI_MU_INVALID_INSTANCE');
1005: FND_MESSAGE.set_token('INSTANCE_ID',px_mass_edit_inst_tbl(inst_idx).instance_id) ;
1006: FND_MESSAGE.set_token('BATCH_NAME',px_mass_edit_rec.name);
1007: log_mu_error
1008: (
1009: p_index => nvl(l_mass_edit_error_tbl.last, 0) + 1,
1010: p_instance_id => px_mass_edit_inst_tbl(inst_idx).instance_id,

Line 1094: FND_MESSAGE.set_name('CSI','CSI_INT_INST_OWNER_MISSING');

1090: tld_idx := tld_idx + 1;
1091: EXCEPTION
1092: When No_data_found Then
1093: -- there has to be only one record here else an exception
1094: FND_MESSAGE.set_name('CSI','CSI_INT_INST_OWNER_MISSING');
1095: FND_MESSAGE.set_token('INSTANCE_ID',l_instance_csr.instance_id);
1096: log_mu_error
1097: (
1098: p_index => nvl(l_mass_edit_error_tbl.last, 0) + 1,

Line 1095: FND_MESSAGE.set_token('INSTANCE_ID',l_instance_csr.instance_id);

1091: EXCEPTION
1092: When No_data_found Then
1093: -- there has to be only one record here else an exception
1094: FND_MESSAGE.set_name('CSI','CSI_INT_INST_OWNER_MISSING');
1095: FND_MESSAGE.set_token('INSTANCE_ID',l_instance_csr.instance_id);
1096: log_mu_error
1097: (
1098: p_index => nvl(l_mass_edit_error_tbl.last, 0) + 1,
1099: p_instance_id => l_instance_csr.instance_id,

Line 1106: FND_MESSAGE.set_name('CSI','CSI_MANY_INST_OWNER_FOUND');

1102: x_mass_edit_error_tbl => l_mass_edit_error_tbl
1103: );
1104: RAISE fnd_api.g_exc_error;
1105: When too_many_rows Then
1106: FND_MESSAGE.set_name('CSI','CSI_MANY_INST_OWNER_FOUND');
1107: FND_MESSAGE.set_token('INSTANCE_ID',l_instance_csr.instance_id);
1108: log_mu_error
1109: (
1110: p_index => nvl(l_mass_edit_error_tbl.last, 0) + 1,

Line 1107: FND_MESSAGE.set_token('INSTANCE_ID',l_instance_csr.instance_id);

1103: );
1104: RAISE fnd_api.g_exc_error;
1105: When too_many_rows Then
1106: FND_MESSAGE.set_name('CSI','CSI_MANY_INST_OWNER_FOUND');
1107: FND_MESSAGE.set_token('INSTANCE_ID',l_instance_csr.instance_id);
1108: log_mu_error
1109: (
1110: p_index => nvl(l_mass_edit_error_tbl.last, 0) + 1,
1111: p_instance_id => l_instance_csr.instance_id,

Line 1118: FND_MESSAGE.set_name('CSI','CSI_API_OWNER_OTHERS_EXCEPTION');

1114: x_mass_edit_error_tbl => l_mass_edit_error_tbl
1115: );
1116: RAISE fnd_api.g_exc_error;
1117: When others Then
1118: FND_MESSAGE.set_name('CSI','CSI_API_OWNER_OTHERS_EXCEPTION');
1119: log_mu_error
1120: (
1121: p_index => nvl(l_mass_edit_error_tbl.last, 0) + 1,
1122: p_instance_id => l_instance_csr.instance_id,

Line 1325: FND_MESSAGE.set_name('CSI','CSI_MU_INVALID_BATCH_NAME');

1321: x_mass_edit_rec => l_mass_edit_rec
1322: )
1323: THEN
1324: IF nvl(p_mass_edit_rec.entry_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
1325: FND_MESSAGE.set_name('CSI','CSI_MU_INVALID_BATCH_NAME');
1326: FND_MESSAGE.set_token('BATCH_NAME',p_mass_edit_rec.name);
1327: ELSE
1328: FND_MESSAGE.set_name('CSI','CSI_MU_INVALID_BATCH_ID');
1329: FND_MESSAGE.set_token('BATCH_ID',p_mass_edit_rec.entry_id);

Line 1326: FND_MESSAGE.set_token('BATCH_NAME',p_mass_edit_rec.name);

1322: )
1323: THEN
1324: IF nvl(p_mass_edit_rec.entry_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
1325: FND_MESSAGE.set_name('CSI','CSI_MU_INVALID_BATCH_NAME');
1326: FND_MESSAGE.set_token('BATCH_NAME',p_mass_edit_rec.name);
1327: ELSE
1328: FND_MESSAGE.set_name('CSI','CSI_MU_INVALID_BATCH_ID');
1329: FND_MESSAGE.set_token('BATCH_ID',p_mass_edit_rec.entry_id);
1330: END IF;

Line 1328: FND_MESSAGE.set_name('CSI','CSI_MU_INVALID_BATCH_ID');

1324: IF nvl(p_mass_edit_rec.entry_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
1325: FND_MESSAGE.set_name('CSI','CSI_MU_INVALID_BATCH_NAME');
1326: FND_MESSAGE.set_token('BATCH_NAME',p_mass_edit_rec.name);
1327: ELSE
1328: FND_MESSAGE.set_name('CSI','CSI_MU_INVALID_BATCH_ID');
1329: FND_MESSAGE.set_token('BATCH_ID',p_mass_edit_rec.entry_id);
1330: END IF;
1331: FND_MSG_PUB.add;
1332: Raise fnd_api.g_exc_error;

Line 1329: FND_MESSAGE.set_token('BATCH_ID',p_mass_edit_rec.entry_id);

1325: FND_MESSAGE.set_name('CSI','CSI_MU_INVALID_BATCH_NAME');
1326: FND_MESSAGE.set_token('BATCH_NAME',p_mass_edit_rec.name);
1327: ELSE
1328: FND_MESSAGE.set_name('CSI','CSI_MU_INVALID_BATCH_ID');
1329: FND_MESSAGE.set_token('BATCH_ID',p_mass_edit_rec.entry_id);
1330: END IF;
1331: FND_MSG_PUB.add;
1332: Raise fnd_api.g_exc_error;
1333: END IF;

Line 1336: FND_MESSAGE.set_name('CSI','CSI_MU_BATCH_UPD_DISALLOWED');

1332: Raise fnd_api.g_exc_error;
1333: END IF;
1334: IF nvl(l_mass_edit_rec.status_code, 'CREATED') = 'PROCESSING' THEN
1335: debug('Cannot Delete a Batch that is being Processed: '||l_mass_edit_rec.status_code);
1336: FND_MESSAGE.set_name('CSI','CSI_MU_BATCH_UPD_DISALLOWED');
1337: FND_MESSAGE.set_token('BATCH_NAME',l_mass_edit_rec.name);
1338: FND_MESSAGE.set_token('BATCH_STATUS',l_mass_edit_rec.status_code) ;
1339: FND_MSG_PUB.add;
1340: Raise fnd_api.g_exc_error;

Line 1337: FND_MESSAGE.set_token('BATCH_NAME',l_mass_edit_rec.name);

1333: END IF;
1334: IF nvl(l_mass_edit_rec.status_code, 'CREATED') = 'PROCESSING' THEN
1335: debug('Cannot Delete a Batch that is being Processed: '||l_mass_edit_rec.status_code);
1336: FND_MESSAGE.set_name('CSI','CSI_MU_BATCH_UPD_DISALLOWED');
1337: FND_MESSAGE.set_token('BATCH_NAME',l_mass_edit_rec.name);
1338: FND_MESSAGE.set_token('BATCH_STATUS',l_mass_edit_rec.status_code) ;
1339: FND_MSG_PUB.add;
1340: Raise fnd_api.g_exc_error;
1341: END IF;

Line 1338: FND_MESSAGE.set_token('BATCH_STATUS',l_mass_edit_rec.status_code) ;

1334: IF nvl(l_mass_edit_rec.status_code, 'CREATED') = 'PROCESSING' THEN
1335: debug('Cannot Delete a Batch that is being Processed: '||l_mass_edit_rec.status_code);
1336: FND_MESSAGE.set_name('CSI','CSI_MU_BATCH_UPD_DISALLOWED');
1337: FND_MESSAGE.set_token('BATCH_NAME',l_mass_edit_rec.name);
1338: FND_MESSAGE.set_token('BATCH_STATUS',l_mass_edit_rec.status_code) ;
1339: FND_MSG_PUB.add;
1340: Raise fnd_api.g_exc_error;
1341: END IF;
1342: END IF;

Line 1514: FND_MESSAGE.set_name('CSI','CSI_MU_INVALID_BATCH_NAME');

1510: x_mass_edit_rec => px_mass_edit_rec
1511: )
1512: THEN
1513: IF nvl(px_mass_edit_rec.entry_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
1514: FND_MESSAGE.set_name('CSI','CSI_MU_INVALID_BATCH_NAME');
1515: FND_MESSAGE.set_token('BATCH_NAME',px_mass_edit_rec.name);
1516: ELSE
1517: FND_MESSAGE.set_name('CSI','CSI_MU_INVALID_BATCH_ID');
1518: FND_MESSAGE.set_token('BATCH_ID',px_mass_edit_rec.entry_id);

Line 1515: FND_MESSAGE.set_token('BATCH_NAME',px_mass_edit_rec.name);

1511: )
1512: THEN
1513: IF nvl(px_mass_edit_rec.entry_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
1514: FND_MESSAGE.set_name('CSI','CSI_MU_INVALID_BATCH_NAME');
1515: FND_MESSAGE.set_token('BATCH_NAME',px_mass_edit_rec.name);
1516: ELSE
1517: FND_MESSAGE.set_name('CSI','CSI_MU_INVALID_BATCH_ID');
1518: FND_MESSAGE.set_token('BATCH_ID',px_mass_edit_rec.entry_id);
1519: END IF;

Line 1517: FND_MESSAGE.set_name('CSI','CSI_MU_INVALID_BATCH_ID');

1513: IF nvl(px_mass_edit_rec.entry_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
1514: FND_MESSAGE.set_name('CSI','CSI_MU_INVALID_BATCH_NAME');
1515: FND_MESSAGE.set_token('BATCH_NAME',px_mass_edit_rec.name);
1516: ELSE
1517: FND_MESSAGE.set_name('CSI','CSI_MU_INVALID_BATCH_ID');
1518: FND_MESSAGE.set_token('BATCH_ID',px_mass_edit_rec.entry_id);
1519: END IF;
1520:
1521: FND_MSG_PUB.add;

Line 1518: FND_MESSAGE.set_token('BATCH_ID',px_mass_edit_rec.entry_id);

1514: FND_MESSAGE.set_name('CSI','CSI_MU_INVALID_BATCH_NAME');
1515: FND_MESSAGE.set_token('BATCH_NAME',px_mass_edit_rec.name);
1516: ELSE
1517: FND_MESSAGE.set_name('CSI','CSI_MU_INVALID_BATCH_ID');
1518: FND_MESSAGE.set_token('BATCH_ID',px_mass_edit_rec.entry_id);
1519: END IF;
1520:
1521: FND_MSG_PUB.add;
1522: Raise fnd_api.g_exc_error;

Line 1639: FND_MESSAGE.SET_NAME('CSI','CSI_MU_INACTIVE_INSTANCE');

1635: FETCH inst_active INTO l_inst_active;
1636: CLOSE inst_active;
1637:
1638: IF l_inst_active is NULL THEN
1639: FND_MESSAGE.SET_NAME('CSI','CSI_MU_INACTIVE_INSTANCE');
1640: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
1641: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id_tab(ind));
1642: px_mass_edit_error_tbl(e_indx).instance_id := p_instance_id_tab(ind);
1643: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;

Line 1640: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);

1636: CLOSE inst_active;
1637:
1638: IF l_inst_active is NULL THEN
1639: FND_MESSAGE.SET_NAME('CSI','CSI_MU_INACTIVE_INSTANCE');
1640: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
1641: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id_tab(ind));
1642: px_mass_edit_error_tbl(e_indx).instance_id := p_instance_id_tab(ind);
1643: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;
1644: px_mass_edit_error_tbl(e_indx).name := g_batch_name;

Line 1641: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id_tab(ind));

1637:
1638: IF l_inst_active is NULL THEN
1639: FND_MESSAGE.SET_NAME('CSI','CSI_MU_INACTIVE_INSTANCE');
1640: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
1641: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id_tab(ind));
1642: px_mass_edit_error_tbl(e_indx).instance_id := p_instance_id_tab(ind);
1643: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;
1644: px_mass_edit_error_tbl(e_indx).name := g_batch_name;
1645: px_mass_edit_error_tbl(e_indx).txn_line_detail_id := p_txn_line_detail_id_tab(ind);

Line 1646: px_mass_edit_error_tbl(e_indx).error_text := fnd_message.get;

1642: px_mass_edit_error_tbl(e_indx).instance_id := p_instance_id_tab(ind);
1643: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;
1644: px_mass_edit_error_tbl(e_indx).name := g_batch_name;
1645: px_mass_edit_error_tbl(e_indx).txn_line_detail_id := p_txn_line_detail_id_tab(ind);
1646: px_mass_edit_error_tbl(e_indx).error_text := fnd_message.get;
1647: px_mass_edit_error_tbl(e_indx).error_code := fnd_api.g_ret_sts_error;
1648: e_indx := e_indx + 1;
1649: END IF;
1650:

Line 1732: FND_MESSAGE.SET_NAME('CSI','CSI_MU_BATCH_DIFF_OWNER_PTY');

1728: debug('New Party Source ID: '||l_party_source_id_tab(ind));
1729:
1730: IF l_old_party_id <> l_party_source_id_tab(ind) THEN
1731: debug('This instance party id does not match the other instances in the batch: '||l_instance_id_tab(ind));
1732: FND_MESSAGE.SET_NAME('CSI','CSI_MU_BATCH_DIFF_OWNER_PTY');
1733: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
1734: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_instance_id_tab(ind));
1735: px_mass_edit_error_tbl(e_indx).instance_id := l_instance_id_tab(ind);
1736: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;

Line 1733: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);

1729:
1730: IF l_old_party_id <> l_party_source_id_tab(ind) THEN
1731: debug('This instance party id does not match the other instances in the batch: '||l_instance_id_tab(ind));
1732: FND_MESSAGE.SET_NAME('CSI','CSI_MU_BATCH_DIFF_OWNER_PTY');
1733: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
1734: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_instance_id_tab(ind));
1735: px_mass_edit_error_tbl(e_indx).instance_id := l_instance_id_tab(ind);
1736: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;
1737: px_mass_edit_error_tbl(e_indx).name := g_batch_name;

Line 1734: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_instance_id_tab(ind));

1730: IF l_old_party_id <> l_party_source_id_tab(ind) THEN
1731: debug('This instance party id does not match the other instances in the batch: '||l_instance_id_tab(ind));
1732: FND_MESSAGE.SET_NAME('CSI','CSI_MU_BATCH_DIFF_OWNER_PTY');
1733: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
1734: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_instance_id_tab(ind));
1735: px_mass_edit_error_tbl(e_indx).instance_id := l_instance_id_tab(ind);
1736: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;
1737: px_mass_edit_error_tbl(e_indx).name := g_batch_name;
1738: px_mass_edit_error_tbl(e_indx).txn_line_detail_id := l_txn_line_detail_id_tab(ind);

Line 1739: px_mass_edit_error_tbl(e_indx).error_text := fnd_message.get;

1735: px_mass_edit_error_tbl(e_indx).instance_id := l_instance_id_tab(ind);
1736: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;
1737: px_mass_edit_error_tbl(e_indx).name := g_batch_name;
1738: px_mass_edit_error_tbl(e_indx).txn_line_detail_id := l_txn_line_detail_id_tab(ind);
1739: px_mass_edit_error_tbl(e_indx).error_text := fnd_message.get;
1740: px_mass_edit_error_tbl(e_indx).error_code := fnd_api.g_ret_sts_error;
1741: e_indx := e_indx + 1;
1742: END IF;
1743:

Line 1766: FND_MESSAGE.SET_NAME('CSI','CSI_MU_BATCH_DIFF_OWNER_ACCT');

1762: debug('New Account ID: '||l_account_id_tab(ind));
1763:
1764: IF l_old_account_id <> l_account_id_tab(ind) THEN
1765: debug(' Account This instance party id does not match the other instances in the batch: '||l_instance_id_tab(ind));
1766: FND_MESSAGE.SET_NAME('CSI','CSI_MU_BATCH_DIFF_OWNER_ACCT');
1767: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
1768: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_instance_id_tab(ind));
1769: px_mass_edit_error_tbl(e_indx).instance_id := l_instance_id_tab(ind);
1770: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;

Line 1767: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);

1763:
1764: IF l_old_account_id <> l_account_id_tab(ind) THEN
1765: debug(' Account This instance party id does not match the other instances in the batch: '||l_instance_id_tab(ind));
1766: FND_MESSAGE.SET_NAME('CSI','CSI_MU_BATCH_DIFF_OWNER_ACCT');
1767: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
1768: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_instance_id_tab(ind));
1769: px_mass_edit_error_tbl(e_indx).instance_id := l_instance_id_tab(ind);
1770: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;
1771: px_mass_edit_error_tbl(e_indx).name := g_batch_name;

Line 1768: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_instance_id_tab(ind));

1764: IF l_old_account_id <> l_account_id_tab(ind) THEN
1765: debug(' Account This instance party id does not match the other instances in the batch: '||l_instance_id_tab(ind));
1766: FND_MESSAGE.SET_NAME('CSI','CSI_MU_BATCH_DIFF_OWNER_ACCT');
1767: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
1768: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_instance_id_tab(ind));
1769: px_mass_edit_error_tbl(e_indx).instance_id := l_instance_id_tab(ind);
1770: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;
1771: px_mass_edit_error_tbl(e_indx).name := g_batch_name;
1772: px_mass_edit_error_tbl(e_indx).txn_line_detail_id := l_txn_line_detail_id_tab(ind);

Line 1773: px_mass_edit_error_tbl(e_indx).error_text := fnd_message.get;

1769: px_mass_edit_error_tbl(e_indx).instance_id := l_instance_id_tab(ind);
1770: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;
1771: px_mass_edit_error_tbl(e_indx).name := g_batch_name;
1772: px_mass_edit_error_tbl(e_indx).txn_line_detail_id := l_txn_line_detail_id_tab(ind);
1773: px_mass_edit_error_tbl(e_indx).error_text := fnd_message.get;
1774: px_mass_edit_error_tbl(e_indx).error_code := fnd_api.g_ret_sts_error;
1775: e_indx := e_indx + 1;
1776: END IF;
1777:

Line 1876: FND_MESSAGE.SET_NAME('CSI','CSI_MU_PTY_DIFF_OWNER_PTY');

1872: FOR party_rec IN party_csr (l_txn_line_detail_id_tab(ind)) LOOP
1873:
1874: IF party_rec.party_source_id <> l_owner_party_id_tab(ind) THEN
1875: -- Raise Error values have changed.
1876: FND_MESSAGE.SET_NAME('CSI','CSI_MU_PTY_DIFF_OWNER_PTY');
1877: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
1878: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_instance_id_tab(ind));
1879: px_mass_edit_error_tbl(e_indx).instance_id := l_instance_id_tab(ind);
1880: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;

Line 1877: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);

1873:
1874: IF party_rec.party_source_id <> l_owner_party_id_tab(ind) THEN
1875: -- Raise Error values have changed.
1876: FND_MESSAGE.SET_NAME('CSI','CSI_MU_PTY_DIFF_OWNER_PTY');
1877: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
1878: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_instance_id_tab(ind));
1879: px_mass_edit_error_tbl(e_indx).instance_id := l_instance_id_tab(ind);
1880: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;
1881: px_mass_edit_error_tbl(e_indx).name := g_batch_name;

Line 1878: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_instance_id_tab(ind));

1874: IF party_rec.party_source_id <> l_owner_party_id_tab(ind) THEN
1875: -- Raise Error values have changed.
1876: FND_MESSAGE.SET_NAME('CSI','CSI_MU_PTY_DIFF_OWNER_PTY');
1877: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
1878: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_instance_id_tab(ind));
1879: px_mass_edit_error_tbl(e_indx).instance_id := l_instance_id_tab(ind);
1880: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;
1881: px_mass_edit_error_tbl(e_indx).name := g_batch_name;
1882: px_mass_edit_error_tbl(e_indx).txn_line_detail_id := l_txn_line_detail_id_tab(ind);

Line 1883: px_mass_edit_error_tbl(e_indx).error_text := fnd_message.get;

1879: px_mass_edit_error_tbl(e_indx).instance_id := l_instance_id_tab(ind);
1880: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;
1881: px_mass_edit_error_tbl(e_indx).name := g_batch_name;
1882: px_mass_edit_error_tbl(e_indx).txn_line_detail_id := l_txn_line_detail_id_tab(ind);
1883: px_mass_edit_error_tbl(e_indx).error_text := fnd_message.get;
1884: px_mass_edit_error_tbl(e_indx).error_code := fnd_api.g_ret_sts_error;
1885: e_indx := e_indx + 1;
1886: END IF;
1887:

Line 1892: FND_MESSAGE.SET_NAME('CSI','CSI_MU_ACCT_DIFF_OWNER_ACCTT');

1888: FOR acct_rec IN acct_csr (party_rec.txn_party_detail_id) LOOP
1889:
1890: IF acct_rec.account_id <> l_owner_party_account_id_tab(ind) THEN
1891: -- Raise Error values have changed.
1892: FND_MESSAGE.SET_NAME('CSI','CSI_MU_ACCT_DIFF_OWNER_ACCTT');
1893: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
1894: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_instance_id_tab(ind));
1895: px_mass_edit_error_tbl(e_indx).instance_id := l_instance_id_tab(ind);
1896: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;

Line 1893: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);

1889:
1890: IF acct_rec.account_id <> l_owner_party_account_id_tab(ind) THEN
1891: -- Raise Error values have changed.
1892: FND_MESSAGE.SET_NAME('CSI','CSI_MU_ACCT_DIFF_OWNER_ACCTT');
1893: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
1894: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_instance_id_tab(ind));
1895: px_mass_edit_error_tbl(e_indx).instance_id := l_instance_id_tab(ind);
1896: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;
1897: px_mass_edit_error_tbl(e_indx).name := g_batch_name;

Line 1894: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_instance_id_tab(ind));

1890: IF acct_rec.account_id <> l_owner_party_account_id_tab(ind) THEN
1891: -- Raise Error values have changed.
1892: FND_MESSAGE.SET_NAME('CSI','CSI_MU_ACCT_DIFF_OWNER_ACCTT');
1893: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
1894: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_instance_id_tab(ind));
1895: px_mass_edit_error_tbl(e_indx).instance_id := l_instance_id_tab(ind);
1896: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;
1897: px_mass_edit_error_tbl(e_indx).name := g_batch_name;
1898: px_mass_edit_error_tbl(e_indx).txn_line_detail_id := l_txn_line_detail_id_tab(ind);

Line 1899: px_mass_edit_error_tbl(e_indx).error_text := fnd_message.get;

1895: px_mass_edit_error_tbl(e_indx).instance_id := l_instance_id_tab(ind);
1896: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;
1897: px_mass_edit_error_tbl(e_indx).name := g_batch_name;
1898: px_mass_edit_error_tbl(e_indx).txn_line_detail_id := l_txn_line_detail_id_tab(ind);
1899: px_mass_edit_error_tbl(e_indx).error_text := fnd_message.get;
1900: px_mass_edit_error_tbl(e_indx).error_code := fnd_api.g_ret_sts_error;
1901: e_indx := e_indx + 1;
1902: END IF;
1903:

Line 1960: FND_MESSAGE.SET_NAME('CSI','CSI_MU_PARENT_INST_NOT_EXISTS');

1956: END LOOP;
1957:
1958: IF l_parent_found = 'N' THEN
1959: -- Log error Parent Must be found
1960: FND_MESSAGE.SET_NAME('CSI','CSI_MU_PARENT_INST_NOT_EXISTS');
1961: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
1962: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id_tab(i));
1963: px_mass_edit_error_tbl(e_indx).instance_id := p_instance_id_tab(i);
1964: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;

Line 1961: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);

1957:
1958: IF l_parent_found = 'N' THEN
1959: -- Log error Parent Must be found
1960: FND_MESSAGE.SET_NAME('CSI','CSI_MU_PARENT_INST_NOT_EXISTS');
1961: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
1962: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id_tab(i));
1963: px_mass_edit_error_tbl(e_indx).instance_id := p_instance_id_tab(i);
1964: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;
1965: px_mass_edit_error_tbl(e_indx).name := g_batch_name;

Line 1962: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id_tab(i));

1958: IF l_parent_found = 'N' THEN
1959: -- Log error Parent Must be found
1960: FND_MESSAGE.SET_NAME('CSI','CSI_MU_PARENT_INST_NOT_EXISTS');
1961: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
1962: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id_tab(i));
1963: px_mass_edit_error_tbl(e_indx).instance_id := p_instance_id_tab(i);
1964: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;
1965: px_mass_edit_error_tbl(e_indx).name := g_batch_name;
1966: px_mass_edit_error_tbl(e_indx).txn_line_detail_id := p_txn_line_detail_id_tab(i);

Line 1967: px_mass_edit_error_tbl(e_indx).error_text := fnd_message.get;

1963: px_mass_edit_error_tbl(e_indx).instance_id := p_instance_id_tab(i);
1964: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;
1965: px_mass_edit_error_tbl(e_indx).name := g_batch_name;
1966: px_mass_edit_error_tbl(e_indx).txn_line_detail_id := p_txn_line_detail_id_tab(i);
1967: px_mass_edit_error_tbl(e_indx).error_text := fnd_message.get;
1968: px_mass_edit_error_tbl(e_indx).error_code := fnd_api.g_ret_sts_error;
1969: e_indx := e_indx + 1;
1970: END IF;
1971: END IF;

Line 2024: FND_MESSAGE.SET_NAME('CSI','CSI_MU_INVALID_INST_STATUS');

2020: END IF;
2021:
2022: IF inst_status_rec.terminated_flag = 'Y' THEN
2023: -- Status is Terminable so Log Error
2024: FND_MESSAGE.SET_NAME('CSI','CSI_MU_INVALID_INST_STATUS');
2025: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
2026: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id_tab(ind));
2027: px_mass_edit_error_tbl(e_indx).instance_id := p_instance_id_tab(ind);
2028: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;

Line 2025: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);

2021:
2022: IF inst_status_rec.terminated_flag = 'Y' THEN
2023: -- Status is Terminable so Log Error
2024: FND_MESSAGE.SET_NAME('CSI','CSI_MU_INVALID_INST_STATUS');
2025: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
2026: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id_tab(ind));
2027: px_mass_edit_error_tbl(e_indx).instance_id := p_instance_id_tab(ind);
2028: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;
2029: px_mass_edit_error_tbl(e_indx).name := g_batch_name;

Line 2026: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id_tab(ind));

2022: IF inst_status_rec.terminated_flag = 'Y' THEN
2023: -- Status is Terminable so Log Error
2024: FND_MESSAGE.SET_NAME('CSI','CSI_MU_INVALID_INST_STATUS');
2025: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
2026: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id_tab(ind));
2027: px_mass_edit_error_tbl(e_indx).instance_id := p_instance_id_tab(ind);
2028: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;
2029: px_mass_edit_error_tbl(e_indx).name := g_batch_name;
2030: px_mass_edit_error_tbl(e_indx).txn_line_detail_id := dummy_rec.txn_line_detail_id;

Line 2031: px_mass_edit_error_tbl(e_indx).error_text := fnd_message.get;

2027: px_mass_edit_error_tbl(e_indx).instance_id := p_instance_id_tab(ind);
2028: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;
2029: px_mass_edit_error_tbl(e_indx).name := g_batch_name;
2030: px_mass_edit_error_tbl(e_indx).txn_line_detail_id := dummy_rec.txn_line_detail_id;
2031: px_mass_edit_error_tbl(e_indx).error_text := fnd_message.get;
2032: px_mass_edit_error_tbl(e_indx).error_code := fnd_api.g_ret_sts_error;
2033: e_indx := e_indx + 1;
2034: END IF;
2035:

Line 2038: FND_MESSAGE.SET_NAME('CSI','CSI_MU_CANNOT_UPD_CURR_LOC');

2034: END IF;
2035:
2036: IF dummy_rec.location_id IS NOT NULL THEN
2037: -- Value cannot be provided log error
2038: FND_MESSAGE.SET_NAME('CSI','CSI_MU_CANNOT_UPD_CURR_LOC');
2039: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
2040: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id_tab(ind));
2041: px_mass_edit_error_tbl(e_indx).instance_id := p_instance_id_tab(ind);
2042: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;

Line 2039: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);

2035:
2036: IF dummy_rec.location_id IS NOT NULL THEN
2037: -- Value cannot be provided log error
2038: FND_MESSAGE.SET_NAME('CSI','CSI_MU_CANNOT_UPD_CURR_LOC');
2039: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
2040: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id_tab(ind));
2041: px_mass_edit_error_tbl(e_indx).instance_id := p_instance_id_tab(ind);
2042: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;
2043: px_mass_edit_error_tbl(e_indx).name := g_batch_name;

Line 2040: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id_tab(ind));

2036: IF dummy_rec.location_id IS NOT NULL THEN
2037: -- Value cannot be provided log error
2038: FND_MESSAGE.SET_NAME('CSI','CSI_MU_CANNOT_UPD_CURR_LOC');
2039: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
2040: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id_tab(ind));
2041: px_mass_edit_error_tbl(e_indx).instance_id := p_instance_id_tab(ind);
2042: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;
2043: px_mass_edit_error_tbl(e_indx).name := g_batch_name;
2044: px_mass_edit_error_tbl(e_indx).txn_line_detail_id := dummy_rec.txn_line_detail_id;

Line 2045: px_mass_edit_error_tbl(e_indx).error_text := fnd_message.get;

2041: px_mass_edit_error_tbl(e_indx).instance_id := p_instance_id_tab(ind);
2042: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;
2043: px_mass_edit_error_tbl(e_indx).name := g_batch_name;
2044: px_mass_edit_error_tbl(e_indx).txn_line_detail_id := dummy_rec.txn_line_detail_id;
2045: px_mass_edit_error_tbl(e_indx).error_text := fnd_message.get;
2046: px_mass_edit_error_tbl(e_indx).error_code := fnd_api.g_ret_sts_error;
2047: e_indx := e_indx + 1;
2048: END IF;
2049:

Line 2052: FND_MESSAGE.SET_NAME('CSI','CSI_MU_CANNOT_UPD_INSTALL_LOC');

2048: END IF;
2049:
2050: IF dummy_rec.install_location_id IS NOT NULL THEN
2051: -- Value cannot be provided so log error
2052: FND_MESSAGE.SET_NAME('CSI','CSI_MU_CANNOT_UPD_INSTALL_LOC');
2053: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
2054: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id_tab(ind));
2055: px_mass_edit_error_tbl(e_indx).instance_id := p_instance_id_tab(ind);
2056: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;

Line 2053: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);

2049:
2050: IF dummy_rec.install_location_id IS NOT NULL THEN
2051: -- Value cannot be provided so log error
2052: FND_MESSAGE.SET_NAME('CSI','CSI_MU_CANNOT_UPD_INSTALL_LOC');
2053: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
2054: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id_tab(ind));
2055: px_mass_edit_error_tbl(e_indx).instance_id := p_instance_id_tab(ind);
2056: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;
2057: px_mass_edit_error_tbl(e_indx).name := g_batch_name;

Line 2054: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id_tab(ind));

2050: IF dummy_rec.install_location_id IS NOT NULL THEN
2051: -- Value cannot be provided so log error
2052: FND_MESSAGE.SET_NAME('CSI','CSI_MU_CANNOT_UPD_INSTALL_LOC');
2053: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
2054: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id_tab(ind));
2055: px_mass_edit_error_tbl(e_indx).instance_id := p_instance_id_tab(ind);
2056: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;
2057: px_mass_edit_error_tbl(e_indx).name := g_batch_name;
2058: px_mass_edit_error_tbl(e_indx).txn_line_detail_id := dummy_rec.txn_line_detail_id;

Line 2059: px_mass_edit_error_tbl(e_indx).error_text := fnd_message.get;

2055: px_mass_edit_error_tbl(e_indx).instance_id := p_instance_id_tab(ind);
2056: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;
2057: px_mass_edit_error_tbl(e_indx).name := g_batch_name;
2058: px_mass_edit_error_tbl(e_indx).txn_line_detail_id := dummy_rec.txn_line_detail_id;
2059: px_mass_edit_error_tbl(e_indx).error_text := fnd_message.get;
2060: px_mass_edit_error_tbl(e_indx).error_code := fnd_api.g_ret_sts_error;
2061: e_indx := e_indx + 1;
2062: END IF;
2063:

Line 2095: FND_MESSAGE.SET_NAME('CSI','CSI_MU_TERM_DATE');

2091: FOR dummy_rec IN dummy_csr (p_txn_line_id_tab(1)) LOOP
2092:
2093: IF (dummy_rec.active_end_date > sysdate) OR
2094: (nvl(dummy_rec.active_end_date,fnd_api.g_miss_date) = fnd_api.g_miss_date) THEN
2095: FND_MESSAGE.SET_NAME('CSI','CSI_MU_TERM_DATE');
2096: FND_MESSAGE.SET_TOKEN('TERMINATION_DATE',dummy_rec.active_end_date);
2097: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
2098: FND_MESSAGE.SET_TOKEN('CURR_DATE',sysdate);
2099: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;

Line 2096: FND_MESSAGE.SET_TOKEN('TERMINATION_DATE',dummy_rec.active_end_date);

2092:
2093: IF (dummy_rec.active_end_date > sysdate) OR
2094: (nvl(dummy_rec.active_end_date,fnd_api.g_miss_date) = fnd_api.g_miss_date) THEN
2095: FND_MESSAGE.SET_NAME('CSI','CSI_MU_TERM_DATE');
2096: FND_MESSAGE.SET_TOKEN('TERMINATION_DATE',dummy_rec.active_end_date);
2097: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
2098: FND_MESSAGE.SET_TOKEN('CURR_DATE',sysdate);
2099: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;
2100: px_mass_edit_error_tbl(e_indx).name := g_batch_name;

Line 2097: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);

2093: IF (dummy_rec.active_end_date > sysdate) OR
2094: (nvl(dummy_rec.active_end_date,fnd_api.g_miss_date) = fnd_api.g_miss_date) THEN
2095: FND_MESSAGE.SET_NAME('CSI','CSI_MU_TERM_DATE');
2096: FND_MESSAGE.SET_TOKEN('TERMINATION_DATE',dummy_rec.active_end_date);
2097: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
2098: FND_MESSAGE.SET_TOKEN('CURR_DATE',sysdate);
2099: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;
2100: px_mass_edit_error_tbl(e_indx).name := g_batch_name;
2101: px_mass_edit_error_tbl(e_indx).txn_line_detail_id := dummy_rec.txn_line_detail_id;

Line 2098: FND_MESSAGE.SET_TOKEN('CURR_DATE',sysdate);

2094: (nvl(dummy_rec.active_end_date,fnd_api.g_miss_date) = fnd_api.g_miss_date) THEN
2095: FND_MESSAGE.SET_NAME('CSI','CSI_MU_TERM_DATE');
2096: FND_MESSAGE.SET_TOKEN('TERMINATION_DATE',dummy_rec.active_end_date);
2097: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
2098: FND_MESSAGE.SET_TOKEN('CURR_DATE',sysdate);
2099: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;
2100: px_mass_edit_error_tbl(e_indx).name := g_batch_name;
2101: px_mass_edit_error_tbl(e_indx).txn_line_detail_id := dummy_rec.txn_line_detail_id;
2102: px_mass_edit_error_tbl(e_indx).error_text := fnd_message.get;

Line 2102: px_mass_edit_error_tbl(e_indx).error_text := fnd_message.get;

2098: FND_MESSAGE.SET_TOKEN('CURR_DATE',sysdate);
2099: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;
2100: px_mass_edit_error_tbl(e_indx).name := g_batch_name;
2101: px_mass_edit_error_tbl(e_indx).txn_line_detail_id := dummy_rec.txn_line_detail_id;
2102: px_mass_edit_error_tbl(e_indx).error_text := fnd_message.get;
2103: px_mass_edit_error_tbl(e_indx).error_code := fnd_api.g_ret_sts_error;
2104: e_indx := e_indx + 1;
2105: END IF;
2106:

Line 2136: FND_MESSAGE.SET_NAME('CSI','CSI_MU_XFER_DATE');

2132:
2133: FOR party_rec IN party_csr (p_txn_line_id_tab(1)) LOOP
2134: IF (party_rec.active_start_date > sysdate) OR
2135: (nvl(party_rec.active_start_date,fnd_api.g_miss_date) = fnd_api.g_miss_date) THEN
2136: FND_MESSAGE.SET_NAME('CSI','CSI_MU_XFER_DATE');
2137: FND_MESSAGE.SET_TOKEN('TRANSFER_DATE',party_rec.active_start_date);
2138: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
2139: FND_MESSAGE.SET_TOKEN('CURR_DATE',sysdate);
2140: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;

Line 2137: FND_MESSAGE.SET_TOKEN('TRANSFER_DATE',party_rec.active_start_date);

2133: FOR party_rec IN party_csr (p_txn_line_id_tab(1)) LOOP
2134: IF (party_rec.active_start_date > sysdate) OR
2135: (nvl(party_rec.active_start_date,fnd_api.g_miss_date) = fnd_api.g_miss_date) THEN
2136: FND_MESSAGE.SET_NAME('CSI','CSI_MU_XFER_DATE');
2137: FND_MESSAGE.SET_TOKEN('TRANSFER_DATE',party_rec.active_start_date);
2138: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
2139: FND_MESSAGE.SET_TOKEN('CURR_DATE',sysdate);
2140: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;
2141: px_mass_edit_error_tbl(e_indx).name := g_batch_name;

Line 2138: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);

2134: IF (party_rec.active_start_date > sysdate) OR
2135: (nvl(party_rec.active_start_date,fnd_api.g_miss_date) = fnd_api.g_miss_date) THEN
2136: FND_MESSAGE.SET_NAME('CSI','CSI_MU_XFER_DATE');
2137: FND_MESSAGE.SET_TOKEN('TRANSFER_DATE',party_rec.active_start_date);
2138: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
2139: FND_MESSAGE.SET_TOKEN('CURR_DATE',sysdate);
2140: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;
2141: px_mass_edit_error_tbl(e_indx).name := g_batch_name;
2142: px_mass_edit_error_tbl(e_indx).txn_line_detail_id := party_rec.txn_line_detail_id;

Line 2139: FND_MESSAGE.SET_TOKEN('CURR_DATE',sysdate);

2135: (nvl(party_rec.active_start_date,fnd_api.g_miss_date) = fnd_api.g_miss_date) THEN
2136: FND_MESSAGE.SET_NAME('CSI','CSI_MU_XFER_DATE');
2137: FND_MESSAGE.SET_TOKEN('TRANSFER_DATE',party_rec.active_start_date);
2138: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
2139: FND_MESSAGE.SET_TOKEN('CURR_DATE',sysdate);
2140: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;
2141: px_mass_edit_error_tbl(e_indx).name := g_batch_name;
2142: px_mass_edit_error_tbl(e_indx).txn_line_detail_id := party_rec.txn_line_detail_id;
2143: px_mass_edit_error_tbl(e_indx).error_text := fnd_message.get;

Line 2143: px_mass_edit_error_tbl(e_indx).error_text := fnd_message.get;

2139: FND_MESSAGE.SET_TOKEN('CURR_DATE',sysdate);
2140: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;
2141: px_mass_edit_error_tbl(e_indx).name := g_batch_name;
2142: px_mass_edit_error_tbl(e_indx).txn_line_detail_id := party_rec.txn_line_detail_id;
2143: px_mass_edit_error_tbl(e_indx).error_text := fnd_message.get;
2144: px_mass_edit_error_tbl(e_indx).error_code := fnd_api.g_ret_sts_error;
2145: e_indx := e_indx + 1;
2146: END IF;
2147:

Line 2189: FND_MESSAGE.SET_NAME('CSI','CSI_MU_INSTALL_LOC_CHANGED');

2185: FETCH txn_det_csr INTO txn_det_rec;
2186: CLOSE txn_det_csr;
2187:
2188: IF txn_det_rec.install_location_id <> p_install_location_id_tab(ind) THEN
2189: FND_MESSAGE.SET_NAME('CSI','CSI_MU_INSTALL_LOC_CHANGED');
2190: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
2191: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id_tab(ind));
2192: px_mass_edit_error_tbl(e_indx).instance_id := p_instance_id_tab(ind);
2193: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;

Line 2190: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);

2186: CLOSE txn_det_csr;
2187:
2188: IF txn_det_rec.install_location_id <> p_install_location_id_tab(ind) THEN
2189: FND_MESSAGE.SET_NAME('CSI','CSI_MU_INSTALL_LOC_CHANGED');
2190: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
2191: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id_tab(ind));
2192: px_mass_edit_error_tbl(e_indx).instance_id := p_instance_id_tab(ind);
2193: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;
2194: px_mass_edit_error_tbl(e_indx).name := g_batch_name;

Line 2191: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id_tab(ind));

2187:
2188: IF txn_det_rec.install_location_id <> p_install_location_id_tab(ind) THEN
2189: FND_MESSAGE.SET_NAME('CSI','CSI_MU_INSTALL_LOC_CHANGED');
2190: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
2191: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id_tab(ind));
2192: px_mass_edit_error_tbl(e_indx).instance_id := p_instance_id_tab(ind);
2193: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;
2194: px_mass_edit_error_tbl(e_indx).name := g_batch_name;
2195: px_mass_edit_error_tbl(e_indx).txn_line_detail_id := p_txn_line_detail_id_tab(ind);

Line 2196: px_mass_edit_error_tbl(e_indx).error_text := fnd_message.get;

2192: px_mass_edit_error_tbl(e_indx).instance_id := p_instance_id_tab(ind);
2193: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;
2194: px_mass_edit_error_tbl(e_indx).name := g_batch_name;
2195: px_mass_edit_error_tbl(e_indx).txn_line_detail_id := p_txn_line_detail_id_tab(ind);
2196: px_mass_edit_error_tbl(e_indx).error_text := fnd_message.get;
2197: px_mass_edit_error_tbl(e_indx).error_code := fnd_api.g_ret_sts_error;
2198: e_indx := e_indx + 1;
2199: END IF;
2200:

Line 2202: FND_MESSAGE.SET_NAME('CSI','CSI_MU_CURR_LOCATION_CHANGED');

2198: e_indx := e_indx + 1;
2199: END IF;
2200:
2201: IF txn_det_rec.location_id <> p_location_id_tab(ind) THEN
2202: FND_MESSAGE.SET_NAME('CSI','CSI_MU_CURR_LOCATION_CHANGED');
2203: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
2204: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id_tab(ind));
2205: px_mass_edit_error_tbl(e_indx).instance_id := p_instance_id_tab(ind);
2206: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;

Line 2203: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);

2199: END IF;
2200:
2201: IF txn_det_rec.location_id <> p_location_id_tab(ind) THEN
2202: FND_MESSAGE.SET_NAME('CSI','CSI_MU_CURR_LOCATION_CHANGED');
2203: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
2204: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id_tab(ind));
2205: px_mass_edit_error_tbl(e_indx).instance_id := p_instance_id_tab(ind);
2206: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;
2207: px_mass_edit_error_tbl(e_indx).name := g_batch_name;

Line 2204: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id_tab(ind));

2200:
2201: IF txn_det_rec.location_id <> p_location_id_tab(ind) THEN
2202: FND_MESSAGE.SET_NAME('CSI','CSI_MU_CURR_LOCATION_CHANGED');
2203: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
2204: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id_tab(ind));
2205: px_mass_edit_error_tbl(e_indx).instance_id := p_instance_id_tab(ind);
2206: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;
2207: px_mass_edit_error_tbl(e_indx).name := g_batch_name;
2208: px_mass_edit_error_tbl(e_indx).txn_line_detail_id := p_txn_line_detail_id_tab(ind);

Line 2209: px_mass_edit_error_tbl(e_indx).error_text := fnd_message.get;

2205: px_mass_edit_error_tbl(e_indx).instance_id := p_instance_id_tab(ind);
2206: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;
2207: px_mass_edit_error_tbl(e_indx).name := g_batch_name;
2208: px_mass_edit_error_tbl(e_indx).txn_line_detail_id := p_txn_line_detail_id_tab(ind);
2209: px_mass_edit_error_tbl(e_indx).error_text := fnd_message.get;
2210: px_mass_edit_error_tbl(e_indx).error_code := 'W';
2211: e_indx := e_indx + 1;
2212: END IF;
2213:

Line 2215: FND_MESSAGE.SET_NAME('CSI','CSI_MU_INST_STATUS_CHANGED');

2211: e_indx := e_indx + 1;
2212: END IF;
2213:
2214: IF txn_det_rec.instance_status_id <> p_instance_status_id_tab(ind) THEN
2215: FND_MESSAGE.SET_NAME('CSI','CSI_MU_INST_STATUS_CHANGED');
2216: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
2217: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id_tab(ind));
2218: px_mass_edit_error_tbl(e_indx).instance_id := p_instance_id_tab(ind);
2219: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;

Line 2216: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);

2212: END IF;
2213:
2214: IF txn_det_rec.instance_status_id <> p_instance_status_id_tab(ind) THEN
2215: FND_MESSAGE.SET_NAME('CSI','CSI_MU_INST_STATUS_CHANGED');
2216: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
2217: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id_tab(ind));
2218: px_mass_edit_error_tbl(e_indx).instance_id := p_instance_id_tab(ind);
2219: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;
2220: px_mass_edit_error_tbl(e_indx).name := g_batch_name;

Line 2217: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id_tab(ind));

2213:
2214: IF txn_det_rec.instance_status_id <> p_instance_status_id_tab(ind) THEN
2215: FND_MESSAGE.SET_NAME('CSI','CSI_MU_INST_STATUS_CHANGED');
2216: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
2217: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id_tab(ind));
2218: px_mass_edit_error_tbl(e_indx).instance_id := p_instance_id_tab(ind);
2219: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;
2220: px_mass_edit_error_tbl(e_indx).name := g_batch_name;
2221: px_mass_edit_error_tbl(e_indx).txn_line_detail_id := p_txn_line_detail_id_tab(ind);

Line 2222: px_mass_edit_error_tbl(e_indx).error_text := fnd_message.get;

2218: px_mass_edit_error_tbl(e_indx).instance_id := p_instance_id_tab(ind);
2219: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;
2220: px_mass_edit_error_tbl(e_indx).name := g_batch_name;
2221: px_mass_edit_error_tbl(e_indx).txn_line_detail_id := p_txn_line_detail_id_tab(ind);
2222: px_mass_edit_error_tbl(e_indx).error_text := fnd_message.get;
2223: px_mass_edit_error_tbl(e_indx).error_code := 'W';
2224: e_indx := e_indx + 1;
2225: END IF;
2226:

Line 2228: FND_MESSAGE.SET_NAME('CSI','CSI_MU_EXT_REF_CHANGED');

2224: e_indx := e_indx + 1;
2225: END IF;
2226:
2227: IF txn_det_rec.external_reference <> p_external_reference_tab(ind) THEN
2228: FND_MESSAGE.SET_NAME('CSI','CSI_MU_EXT_REF_CHANGED');
2229: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
2230: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id_tab(ind));
2231: px_mass_edit_error_tbl(e_indx).instance_id := p_instance_id_tab(ind);
2232: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;

Line 2229: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);

2225: END IF;
2226:
2227: IF txn_det_rec.external_reference <> p_external_reference_tab(ind) THEN
2228: FND_MESSAGE.SET_NAME('CSI','CSI_MU_EXT_REF_CHANGED');
2229: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
2230: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id_tab(ind));
2231: px_mass_edit_error_tbl(e_indx).instance_id := p_instance_id_tab(ind);
2232: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;
2233: px_mass_edit_error_tbl(e_indx).name := g_batch_name;

Line 2230: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id_tab(ind));

2226:
2227: IF txn_det_rec.external_reference <> p_external_reference_tab(ind) THEN
2228: FND_MESSAGE.SET_NAME('CSI','CSI_MU_EXT_REF_CHANGED');
2229: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
2230: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id_tab(ind));
2231: px_mass_edit_error_tbl(e_indx).instance_id := p_instance_id_tab(ind);
2232: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;
2233: px_mass_edit_error_tbl(e_indx).name := g_batch_name;
2234: px_mass_edit_error_tbl(e_indx).txn_line_detail_id := p_txn_line_detail_id_tab(ind);

Line 2235: px_mass_edit_error_tbl(e_indx).error_text := fnd_message.get;

2231: px_mass_edit_error_tbl(e_indx).instance_id := p_instance_id_tab(ind);
2232: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;
2233: px_mass_edit_error_tbl(e_indx).name := g_batch_name;
2234: px_mass_edit_error_tbl(e_indx).txn_line_detail_id := p_txn_line_detail_id_tab(ind);
2235: px_mass_edit_error_tbl(e_indx).error_text := fnd_message.get;
2236: px_mass_edit_error_tbl(e_indx).error_code := 'W';
2237: e_indx := e_indx + 1;
2238: END IF;
2239:

Line 2241: FND_MESSAGE.SET_NAME('CSI','CSI_MU_INSTALL_DATE_CHANGED');

2237: e_indx := e_indx + 1;
2238: END IF;
2239:
2240: IF txn_det_rec.installation_date <> p_install_date_tab(ind) THEN
2241: FND_MESSAGE.SET_NAME('CSI','CSI_MU_INSTALL_DATE_CHANGED');
2242: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
2243: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id_tab(ind));
2244: px_mass_edit_error_tbl(e_indx).instance_id := p_instance_id_tab(ind);
2245: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;

Line 2242: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);

2238: END IF;
2239:
2240: IF txn_det_rec.installation_date <> p_install_date_tab(ind) THEN
2241: FND_MESSAGE.SET_NAME('CSI','CSI_MU_INSTALL_DATE_CHANGED');
2242: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
2243: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id_tab(ind));
2244: px_mass_edit_error_tbl(e_indx).instance_id := p_instance_id_tab(ind);
2245: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;
2246: px_mass_edit_error_tbl(e_indx).name := g_batch_name;

Line 2243: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id_tab(ind));

2239:
2240: IF txn_det_rec.installation_date <> p_install_date_tab(ind) THEN
2241: FND_MESSAGE.SET_NAME('CSI','CSI_MU_INSTALL_DATE_CHANGED');
2242: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
2243: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id_tab(ind));
2244: px_mass_edit_error_tbl(e_indx).instance_id := p_instance_id_tab(ind);
2245: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;
2246: px_mass_edit_error_tbl(e_indx).name := g_batch_name;
2247: px_mass_edit_error_tbl(e_indx).txn_line_detail_id := p_txn_line_detail_id_tab(ind);

Line 2248: px_mass_edit_error_tbl(e_indx).error_text := fnd_message.get;

2244: px_mass_edit_error_tbl(e_indx).instance_id := p_instance_id_tab(ind);
2245: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;
2246: px_mass_edit_error_tbl(e_indx).name := g_batch_name;
2247: px_mass_edit_error_tbl(e_indx).txn_line_detail_id := p_txn_line_detail_id_tab(ind);
2248: px_mass_edit_error_tbl(e_indx).error_text := fnd_message.get;
2249: px_mass_edit_error_tbl(e_indx).error_code := 'W';
2250: e_indx := e_indx + 1;
2251: END IF;
2252:

Line 2254: FND_MESSAGE.SET_NAME('CSI','CSI_MU_SYSTEM_CHANGED');

2250: e_indx := e_indx + 1;
2251: END IF;
2252:
2253: IF txn_det_rec.csi_system_id <> p_system_id_tab(ind) THEN
2254: FND_MESSAGE.SET_NAME('CSI','CSI_MU_SYSTEM_CHANGED');
2255: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
2256: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id_tab(ind));
2257: px_mass_edit_error_tbl(e_indx).instance_id := p_instance_id_tab(ind);
2258: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;

Line 2255: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);

2251: END IF;
2252:
2253: IF txn_det_rec.csi_system_id <> p_system_id_tab(ind) THEN
2254: FND_MESSAGE.SET_NAME('CSI','CSI_MU_SYSTEM_CHANGED');
2255: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
2256: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id_tab(ind));
2257: px_mass_edit_error_tbl(e_indx).instance_id := p_instance_id_tab(ind);
2258: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;
2259: px_mass_edit_error_tbl(e_indx).name := g_batch_name;

Line 2256: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id_tab(ind));

2252:
2253: IF txn_det_rec.csi_system_id <> p_system_id_tab(ind) THEN
2254: FND_MESSAGE.SET_NAME('CSI','CSI_MU_SYSTEM_CHANGED');
2255: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
2256: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id_tab(ind));
2257: px_mass_edit_error_tbl(e_indx).instance_id := p_instance_id_tab(ind);
2258: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;
2259: px_mass_edit_error_tbl(e_indx).name := g_batch_name;
2260: px_mass_edit_error_tbl(e_indx).txn_line_detail_id := p_txn_line_detail_id_tab(ind);

Line 2261: px_mass_edit_error_tbl(e_indx).error_text := fnd_message.get;

2257: px_mass_edit_error_tbl(e_indx).instance_id := p_instance_id_tab(ind);
2258: px_mass_edit_error_tbl(e_indx).entry_id := g_entry_id;
2259: px_mass_edit_error_tbl(e_indx).name := g_batch_name;
2260: px_mass_edit_error_tbl(e_indx).txn_line_detail_id := p_txn_line_detail_id_tab(ind);
2261: px_mass_edit_error_tbl(e_indx).error_text := fnd_message.get;
2262: px_mass_edit_error_tbl(e_indx).error_code := 'W';
2263: e_indx := e_indx + 1;
2264: END IF;
2265:

Line 2518: FND_MESSAGE.SET_NAME('CSI','CSI_MU_INACTIVE_SYSTEM');

2514: FETCH sys_active INTO l_sys_active;
2515: CLOSE sys_active;
2516:
2517: IF l_sys_active is NULL THEN
2518: FND_MESSAGE.SET_NAME('CSI','CSI_MU_INACTIVE_SYSTEM');
2519: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
2520: FND_MESSAGE.SET_TOKEN('SYSTEM_ID',p_system_id);
2521: p_mu_sys_error_tbl(e_indx).system_id := p_system_id;
2522: p_mu_sys_error_tbl(e_indx).entry_id := g_entry_id;

Line 2519: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);

2515: CLOSE sys_active;
2516:
2517: IF l_sys_active is NULL THEN
2518: FND_MESSAGE.SET_NAME('CSI','CSI_MU_INACTIVE_SYSTEM');
2519: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
2520: FND_MESSAGE.SET_TOKEN('SYSTEM_ID',p_system_id);
2521: p_mu_sys_error_tbl(e_indx).system_id := p_system_id;
2522: p_mu_sys_error_tbl(e_indx).entry_id := g_entry_id;
2523: p_mu_sys_error_tbl(e_indx).batch_name := g_batch_name;

Line 2520: FND_MESSAGE.SET_TOKEN('SYSTEM_ID',p_system_id);

2516:
2517: IF l_sys_active is NULL THEN
2518: FND_MESSAGE.SET_NAME('CSI','CSI_MU_INACTIVE_SYSTEM');
2519: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
2520: FND_MESSAGE.SET_TOKEN('SYSTEM_ID',p_system_id);
2521: p_mu_sys_error_tbl(e_indx).system_id := p_system_id;
2522: p_mu_sys_error_tbl(e_indx).entry_id := g_entry_id;
2523: p_mu_sys_error_tbl(e_indx).batch_name := g_batch_name;
2524: p_mu_sys_error_tbl(e_indx).txn_line_detail_id := p_txn_line_id;

Line 2525: p_mu_sys_error_tbl(e_indx).error_text := fnd_message.get;

2521: p_mu_sys_error_tbl(e_indx).system_id := p_system_id;
2522: p_mu_sys_error_tbl(e_indx).entry_id := g_entry_id;
2523: p_mu_sys_error_tbl(e_indx).batch_name := g_batch_name;
2524: p_mu_sys_error_tbl(e_indx).txn_line_detail_id := p_txn_line_id;
2525: p_mu_sys_error_tbl(e_indx).error_text := fnd_message.get;
2526: p_mu_sys_error_tbl(e_indx).error_code := fnd_api.g_ret_sts_error;
2527: e_indx := e_indx + 1;
2528: END IF;
2529:

Line 2565: FND_MESSAGE.SET_NAME('CSI','CSI_MU_SYS_CUST_DIFF');

2561: CLOSE sys_customer_csr;
2562:
2563: IF l_customer_id <> p_customer_id THEN
2564: -- Raise Error owner values have changed.
2565: FND_MESSAGE.SET_NAME('CSI','CSI_MU_SYS_CUST_DIFF');
2566: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
2567: FND_MESSAGE.SET_TOKEN('SYSTEM_ID',p_system_id);
2568: p_mu_sys_error_tbl(e_indx).system_id := p_system_id;
2569: p_mu_sys_error_tbl(e_indx).entry_id := g_entry_id;

Line 2566: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);

2562:
2563: IF l_customer_id <> p_customer_id THEN
2564: -- Raise Error owner values have changed.
2565: FND_MESSAGE.SET_NAME('CSI','CSI_MU_SYS_CUST_DIFF');
2566: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
2567: FND_MESSAGE.SET_TOKEN('SYSTEM_ID',p_system_id);
2568: p_mu_sys_error_tbl(e_indx).system_id := p_system_id;
2569: p_mu_sys_error_tbl(e_indx).entry_id := g_entry_id;
2570: p_mu_sys_error_tbl(e_indx).name := g_batch_name;

Line 2567: FND_MESSAGE.SET_TOKEN('SYSTEM_ID',p_system_id);

2563: IF l_customer_id <> p_customer_id THEN
2564: -- Raise Error owner values have changed.
2565: FND_MESSAGE.SET_NAME('CSI','CSI_MU_SYS_CUST_DIFF');
2566: FND_MESSAGE.SET_TOKEN('BATCH_NAME',g_batch_name);
2567: FND_MESSAGE.SET_TOKEN('SYSTEM_ID',p_system_id);
2568: p_mu_sys_error_tbl(e_indx).system_id := p_system_id;
2569: p_mu_sys_error_tbl(e_indx).entry_id := g_entry_id;
2570: p_mu_sys_error_tbl(e_indx).name := g_batch_name;
2571: p_mu_sys_error_tbl(e_indx).txn_line_detail_id := p_txn_line_id;

Line 2572: p_mu_sys_error_tbl(e_indx).error_text := fnd_message.get;

2568: p_mu_sys_error_tbl(e_indx).system_id := p_system_id;
2569: p_mu_sys_error_tbl(e_indx).entry_id := g_entry_id;
2570: p_mu_sys_error_tbl(e_indx).name := g_batch_name;
2571: p_mu_sys_error_tbl(e_indx).txn_line_detail_id := p_txn_line_id;
2572: p_mu_sys_error_tbl(e_indx).error_text := fnd_message.get;
2573: p_mu_sys_error_tbl(e_indx).error_code := fnd_api.g_ret_sts_error;
2574: e_indx := e_indx + 1;
2575: END IF;
2576: