423: OR NVL(p_commit,G_MISS_CHAR)
424: NOT IN (G_TRUE, G_FALSE)
425: THEN
426: x_return_status := G_CONC_RET_STS_ERROR;
427: FND_MESSAGE.Set_Name('ZX', 'ZX_API_INVALID_PARAM');
428: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
429: FND_MESSAGE.Set_Token('API_NAME', G_PROC_NAME);
430: x_msg_data := FND_MESSAGE.get();
431: RETURN;
424: NOT IN (G_TRUE, G_FALSE)
425: THEN
426: x_return_status := G_CONC_RET_STS_ERROR;
427: FND_MESSAGE.Set_Name('ZX', 'ZX_API_INVALID_PARAM');
428: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
429: FND_MESSAGE.Set_Token('API_NAME', G_PROC_NAME);
430: x_msg_data := FND_MESSAGE.get();
431: RETURN;
432: END IF;
425: THEN
426: x_return_status := G_CONC_RET_STS_ERROR;
427: FND_MESSAGE.Set_Name('ZX', 'ZX_API_INVALID_PARAM');
428: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
429: FND_MESSAGE.Set_Token('API_NAME', G_PROC_NAME);
430: x_msg_data := FND_MESSAGE.get();
431: RETURN;
432: END IF;
433:
426: x_return_status := G_CONC_RET_STS_ERROR;
427: FND_MESSAGE.Set_Name('ZX', 'ZX_API_INVALID_PARAM');
428: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
429: FND_MESSAGE.Set_Token('API_NAME', G_PROC_NAME);
430: x_msg_data := FND_MESSAGE.get();
431: RETURN;
432: END IF;
433:
434: G_DEBUG_STATEMENT:='Validated mandatory API parameters';
676: NVL(G_BATCH_ID,NVL(batch_id,G_MISS_NUM))
677: AND ROWNUM = 1;
678: EXCEPTION
679: WHEN NO_DATA_FOUND THEN
680: FND_MESSAGE.Set_Name('ZX', 'ZX_BULK_NO_ROWS');
681: FND_MESSAGE.Set_Token('TABLE_NAME', G_INTF_PTP_TABLE_NAME);
682: log_now (p_log_level => FND_FILE.LOG
683: ,p_message => FND_MESSAGE.get()
684: );
677: AND ROWNUM = 1;
678: EXCEPTION
679: WHEN NO_DATA_FOUND THEN
680: FND_MESSAGE.Set_Name('ZX', 'ZX_BULK_NO_ROWS');
681: FND_MESSAGE.Set_Token('TABLE_NAME', G_INTF_PTP_TABLE_NAME);
682: log_now (p_log_level => FND_FILE.LOG
683: ,p_message => FND_MESSAGE.get()
684: );
685: RAISE NO_ROWS_IN_INTF_TABLE;
679: WHEN NO_DATA_FOUND THEN
680: FND_MESSAGE.Set_Name('ZX', 'ZX_BULK_NO_ROWS');
681: FND_MESSAGE.Set_Token('TABLE_NAME', G_INTF_PTP_TABLE_NAME);
682: log_now (p_log_level => FND_FILE.LOG
683: ,p_message => FND_MESSAGE.get()
684: );
685: RAISE NO_ROWS_IN_INTF_TABLE;
686: END;
687: G_DEBUG_STATEMENT:='Validate Mode : There are records to Process in PTP';
700: AND record_status = G_RS_VALID
701: AND ROWNUM = 1;
702: EXCEPTION
703: WHEN NO_DATA_FOUND THEN
704: FND_MESSAGE.Set_Name('ZX', 'ZX_BULK_NO_ROWS');
705: FND_MESSAGE.Set_Token('TABLE_NAME', G_INTF_PTP_TABLE_NAME);
706: log_now (p_log_level => FND_FILE.LOG
707: ,p_message => FND_MESSAGE.get()
708: );
701: AND ROWNUM = 1;
702: EXCEPTION
703: WHEN NO_DATA_FOUND THEN
704: FND_MESSAGE.Set_Name('ZX', 'ZX_BULK_NO_ROWS');
705: FND_MESSAGE.Set_Token('TABLE_NAME', G_INTF_PTP_TABLE_NAME);
706: log_now (p_log_level => FND_FILE.LOG
707: ,p_message => FND_MESSAGE.get()
708: );
709: RAISE NO_ROWS_IN_INTF_TABLE;
703: WHEN NO_DATA_FOUND THEN
704: FND_MESSAGE.Set_Name('ZX', 'ZX_BULK_NO_ROWS');
705: FND_MESSAGE.Set_Token('TABLE_NAME', G_INTF_PTP_TABLE_NAME);
706: log_now (p_log_level => FND_FILE.LOG
707: ,p_message => FND_MESSAGE.get()
708: );
709: RAISE NO_ROWS_IN_INTF_TABLE;
710: END;
711: G_DEBUG_STATEMENT:='Insert Mode : There are records to Process in PTP';
773:
774: EXCEPTION
775: WHEN NO_DATA_FOUND THEN
776: l_temp_char_30 := NULL;
777: FND_MESSAGE.Set_Name('ZX', 'ZX_BULK_NO_ROWS');
778: FND_MESSAGE.Set_Token('TABLE_NAME', G_INTF_REG_TABLE_NAME);
779: log_now (p_log_level => FND_FILE.LOG
780: ,p_message => fnd_message.get()
781: );
774: EXCEPTION
775: WHEN NO_DATA_FOUND THEN
776: l_temp_char_30 := NULL;
777: FND_MESSAGE.Set_Name('ZX', 'ZX_BULK_NO_ROWS');
778: FND_MESSAGE.Set_Token('TABLE_NAME', G_INTF_REG_TABLE_NAME);
779: log_now (p_log_level => FND_FILE.LOG
780: ,p_message => fnd_message.get()
781: );
782: END;
776: l_temp_char_30 := NULL;
777: FND_MESSAGE.Set_Name('ZX', 'ZX_BULK_NO_ROWS');
778: FND_MESSAGE.Set_Token('TABLE_NAME', G_INTF_REG_TABLE_NAME);
779: log_now (p_log_level => FND_FILE.LOG
780: ,p_message => fnd_message.get()
781: );
782: END;
783:
784: G_DEBUG_STATEMENT:='Completed Processing Registration Records';
837:
838: EXCEPTION
839: WHEN NO_DATA_FOUND THEN
840: l_temp_char_30 := NULL;
841: FND_MESSAGE.Set_Name('ZX', 'ZX_BULK_NO_ROWS');
842: FND_MESSAGE.Set_Token('TABLE_NAME', G_INTF_EXE_TABLE_NAME);
843: log_now (p_log_level => FND_FILE.LOG
844: ,p_message => fnd_message.get()
845: );
838: EXCEPTION
839: WHEN NO_DATA_FOUND THEN
840: l_temp_char_30 := NULL;
841: FND_MESSAGE.Set_Name('ZX', 'ZX_BULK_NO_ROWS');
842: FND_MESSAGE.Set_Token('TABLE_NAME', G_INTF_EXE_TABLE_NAME);
843: log_now (p_log_level => FND_FILE.LOG
844: ,p_message => fnd_message.get()
845: );
846: END;
840: l_temp_char_30 := NULL;
841: FND_MESSAGE.Set_Name('ZX', 'ZX_BULK_NO_ROWS');
842: FND_MESSAGE.Set_Token('TABLE_NAME', G_INTF_EXE_TABLE_NAME);
843: log_now (p_log_level => FND_FILE.LOG
844: ,p_message => fnd_message.get()
845: );
846: END;
847:
848: G_DEBUG_STATEMENT:='Completed Exemptions record processing';
870:
871: EXCEPTION
872: WHEN NO_DATA_FOUND THEN
873: l_temp_char_30 := NULL;
874: FND_MESSAGE.Set_Name('ZX', 'ZX_BULK_NO_ROWS');
875: FND_MESSAGE.Set_Token('TABLE_NAME', G_INTF_RCA_TABLE_NAME);
876: log_now (p_log_level => FND_FILE.LOG
877: ,p_message => fnd_message.get()
878: );
871: EXCEPTION
872: WHEN NO_DATA_FOUND THEN
873: l_temp_char_30 := NULL;
874: FND_MESSAGE.Set_Name('ZX', 'ZX_BULK_NO_ROWS');
875: FND_MESSAGE.Set_Token('TABLE_NAME', G_INTF_RCA_TABLE_NAME);
876: log_now (p_log_level => FND_FILE.LOG
877: ,p_message => fnd_message.get()
878: );
879: END;
873: l_temp_char_30 := NULL;
874: FND_MESSAGE.Set_Name('ZX', 'ZX_BULK_NO_ROWS');
875: FND_MESSAGE.Set_Token('TABLE_NAME', G_INTF_RCA_TABLE_NAME);
876: log_now (p_log_level => FND_FILE.LOG
877: ,p_message => fnd_message.get()
878: );
879: END;
880:
881: G_DEBUG_STATEMENT:='Completed Reporting Code Association record processing';
6550:
6551: l_rec_index := 0;
6552: FOR cr in c_ptp_errors LOOP
6553: IF BITAND(cr.error_number,G_ES_PTP_MAND_PARAM_MISSING) <> 0 THEN
6554: fnd_message.set_name('ZX','ZX_INTF_MAND_VALUE_MISSING');
6555: l_rec_index := l_rec_index +1;
6556: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6557: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6558: l_error_table(l_rec_index).party_id := cr.party_id;
6555: l_rec_index := l_rec_index +1;
6556: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6557: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6558: l_error_table(l_rec_index).party_id := cr.party_id;
6559: l_error_table(l_rec_index).message_text := fnd_message.get();
6560: END IF;
6561: IF BITAND(cr.error_number,G_ES_PTP_DUP_INTF_RECORD) <> 0 THEN
6562: fnd_message.set_name('ZX','ZX_BULK_DUP_PTP_REF');
6563: l_rec_index := l_rec_index +1;
6558: l_error_table(l_rec_index).party_id := cr.party_id;
6559: l_error_table(l_rec_index).message_text := fnd_message.get();
6560: END IF;
6561: IF BITAND(cr.error_number,G_ES_PTP_DUP_INTF_RECORD) <> 0 THEN
6562: fnd_message.set_name('ZX','ZX_BULK_DUP_PTP_REF');
6563: l_rec_index := l_rec_index +1;
6564: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6565: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6566: l_error_table(l_rec_index).party_id := cr.party_id;
6563: l_rec_index := l_rec_index +1;
6564: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6565: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6566: l_error_table(l_rec_index).party_id := cr.party_id;
6567: l_error_table(l_rec_index).message_text := fnd_message.get();
6568: END IF;
6569: IF BITAND(cr.error_number,G_ES_PTP_TRANS_TYPE_INVALID) <> 0 THEN
6570: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6571: fnd_message.set_token('VALUE_NAME',cr.dml_type );
6566: l_error_table(l_rec_index).party_id := cr.party_id;
6567: l_error_table(l_rec_index).message_text := fnd_message.get();
6568: END IF;
6569: IF BITAND(cr.error_number,G_ES_PTP_TRANS_TYPE_INVALID) <> 0 THEN
6570: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6571: fnd_message.set_token('VALUE_NAME',cr.dml_type );
6572: fnd_message.set_token('COLUMN_NAME','DML_TYPE' );
6573: l_rec_index := l_rec_index +1;
6574: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6567: l_error_table(l_rec_index).message_text := fnd_message.get();
6568: END IF;
6569: IF BITAND(cr.error_number,G_ES_PTP_TRANS_TYPE_INVALID) <> 0 THEN
6570: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6571: fnd_message.set_token('VALUE_NAME',cr.dml_type );
6572: fnd_message.set_token('COLUMN_NAME','DML_TYPE' );
6573: l_rec_index := l_rec_index +1;
6574: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6575: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6568: END IF;
6569: IF BITAND(cr.error_number,G_ES_PTP_TRANS_TYPE_INVALID) <> 0 THEN
6570: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6571: fnd_message.set_token('VALUE_NAME',cr.dml_type );
6572: fnd_message.set_token('COLUMN_NAME','DML_TYPE' );
6573: l_rec_index := l_rec_index +1;
6574: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6575: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6576: l_error_table(l_rec_index).party_id := cr.party_id;
6573: l_rec_index := l_rec_index +1;
6574: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6575: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6576: l_error_table(l_rec_index).party_id := cr.party_id;
6577: l_error_table(l_rec_index).message_text := fnd_message.get();
6578: END IF;
6579: IF BITAND(cr.error_number,G_ES_PTP_PARTY_TYPE_INVALID) <> 0 THEN
6580: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6581: fnd_message.set_token('VALUE_NAME',cr.party_type_code );
6576: l_error_table(l_rec_index).party_id := cr.party_id;
6577: l_error_table(l_rec_index).message_text := fnd_message.get();
6578: END IF;
6579: IF BITAND(cr.error_number,G_ES_PTP_PARTY_TYPE_INVALID) <> 0 THEN
6580: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6581: fnd_message.set_token('VALUE_NAME',cr.party_type_code );
6582: fnd_message.set_token('COLUMN_NAME','PARTY_TYPE_CODE' );
6583: l_rec_index := l_rec_index +1;
6584: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6577: l_error_table(l_rec_index).message_text := fnd_message.get();
6578: END IF;
6579: IF BITAND(cr.error_number,G_ES_PTP_PARTY_TYPE_INVALID) <> 0 THEN
6580: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6581: fnd_message.set_token('VALUE_NAME',cr.party_type_code );
6582: fnd_message.set_token('COLUMN_NAME','PARTY_TYPE_CODE' );
6583: l_rec_index := l_rec_index +1;
6584: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6585: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6578: END IF;
6579: IF BITAND(cr.error_number,G_ES_PTP_PARTY_TYPE_INVALID) <> 0 THEN
6580: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6581: fnd_message.set_token('VALUE_NAME',cr.party_type_code );
6582: fnd_message.set_token('COLUMN_NAME','PARTY_TYPE_CODE' );
6583: l_rec_index := l_rec_index +1;
6584: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6585: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6586: l_error_table(l_rec_index).party_id := cr.party_id;
6583: l_rec_index := l_rec_index +1;
6584: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6585: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6586: l_error_table(l_rec_index).party_id := cr.party_id;
6587: l_error_table(l_rec_index).message_text := fnd_message.get();
6588: END IF;
6589: IF BITAND(cr.error_number,G_ES_PTP_PARTY_INVALID) <> 0 THEN
6590: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6591: fnd_message.set_token('VALUE_NAME',cr.party_type_code );
6586: l_error_table(l_rec_index).party_id := cr.party_id;
6587: l_error_table(l_rec_index).message_text := fnd_message.get();
6588: END IF;
6589: IF BITAND(cr.error_number,G_ES_PTP_PARTY_INVALID) <> 0 THEN
6590: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6591: fnd_message.set_token('VALUE_NAME',cr.party_type_code );
6592: fnd_message.set_token('COLUMN_NAME','PARTY_TYPE_CODE' );
6593: l_rec_index := l_rec_index +1;
6594: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6587: l_error_table(l_rec_index).message_text := fnd_message.get();
6588: END IF;
6589: IF BITAND(cr.error_number,G_ES_PTP_PARTY_INVALID) <> 0 THEN
6590: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6591: fnd_message.set_token('VALUE_NAME',cr.party_type_code );
6592: fnd_message.set_token('COLUMN_NAME','PARTY_TYPE_CODE' );
6593: l_rec_index := l_rec_index +1;
6594: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6595: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6588: END IF;
6589: IF BITAND(cr.error_number,G_ES_PTP_PARTY_INVALID) <> 0 THEN
6590: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6591: fnd_message.set_token('VALUE_NAME',cr.party_type_code );
6592: fnd_message.set_token('COLUMN_NAME','PARTY_TYPE_CODE' );
6593: l_rec_index := l_rec_index +1;
6594: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6595: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6596: l_error_table(l_rec_index).party_id := cr.party_id;
6593: l_rec_index := l_rec_index +1;
6594: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6595: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6596: l_error_table(l_rec_index).party_id := cr.party_id;
6597: l_error_table(l_rec_index).message_text := fnd_message.get();
6598: END IF;
6599: IF BITAND(cr.error_number,G_ES_PTP_PARTY_NAME_DUP) <> 0 THEN
6600: fnd_message.set_name('ZX','ZX_PTP_PARTY_NAME_DUP');
6601: l_rec_index := l_rec_index +1;
6596: l_error_table(l_rec_index).party_id := cr.party_id;
6597: l_error_table(l_rec_index).message_text := fnd_message.get();
6598: END IF;
6599: IF BITAND(cr.error_number,G_ES_PTP_PARTY_NAME_DUP) <> 0 THEN
6600: fnd_message.set_name('ZX','ZX_PTP_PARTY_NAME_DUP');
6601: l_rec_index := l_rec_index +1;
6602: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6603: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6604: l_error_table(l_rec_index).party_id := cr.party_id;
6601: l_rec_index := l_rec_index +1;
6602: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6603: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6604: l_error_table(l_rec_index).party_id := cr.party_id;
6605: l_error_table(l_rec_index).message_text := fnd_message.get();
6606: END IF;
6607: IF BITAND(cr.error_number,G_ES_PTP_COUNTRY_INVALID) <> 0 THEN
6608: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6609: IF cr.country_code IS NOT NULL THEN
6604: l_error_table(l_rec_index).party_id := cr.party_id;
6605: l_error_table(l_rec_index).message_text := fnd_message.get();
6606: END IF;
6607: IF BITAND(cr.error_number,G_ES_PTP_COUNTRY_INVALID) <> 0 THEN
6608: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6609: IF cr.country_code IS NOT NULL THEN
6610: fnd_message.set_token('VALUE_NAME',cr.country_code );
6611: fnd_message.set_token('COLUMN_NAME','COUNTRY_CODE' );
6612: ELSE
6606: END IF;
6607: IF BITAND(cr.error_number,G_ES_PTP_COUNTRY_INVALID) <> 0 THEN
6608: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6609: IF cr.country_code IS NOT NULL THEN
6610: fnd_message.set_token('VALUE_NAME',cr.country_code );
6611: fnd_message.set_token('COLUMN_NAME','COUNTRY_CODE' );
6612: ELSE
6613: fnd_message.set_token('VALUE_NAME',cr.country_name );
6614: fnd_message.set_token('COLUMN_NAME','COUNTRY_NAME' );
6607: IF BITAND(cr.error_number,G_ES_PTP_COUNTRY_INVALID) <> 0 THEN
6608: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6609: IF cr.country_code IS NOT NULL THEN
6610: fnd_message.set_token('VALUE_NAME',cr.country_code );
6611: fnd_message.set_token('COLUMN_NAME','COUNTRY_CODE' );
6612: ELSE
6613: fnd_message.set_token('VALUE_NAME',cr.country_name );
6614: fnd_message.set_token('COLUMN_NAME','COUNTRY_NAME' );
6615: END IF;
6609: IF cr.country_code IS NOT NULL THEN
6610: fnd_message.set_token('VALUE_NAME',cr.country_code );
6611: fnd_message.set_token('COLUMN_NAME','COUNTRY_CODE' );
6612: ELSE
6613: fnd_message.set_token('VALUE_NAME',cr.country_name );
6614: fnd_message.set_token('COLUMN_NAME','COUNTRY_NAME' );
6615: END IF;
6616: l_rec_index := l_rec_index +1;
6617: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6610: fnd_message.set_token('VALUE_NAME',cr.country_code );
6611: fnd_message.set_token('COLUMN_NAME','COUNTRY_CODE' );
6612: ELSE
6613: fnd_message.set_token('VALUE_NAME',cr.country_name );
6614: fnd_message.set_token('COLUMN_NAME','COUNTRY_NAME' );
6615: END IF;
6616: l_rec_index := l_rec_index +1;
6617: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6618: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6616: l_rec_index := l_rec_index +1;
6617: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6618: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6619: l_error_table(l_rec_index).party_id := cr.party_id;
6620: l_error_table(l_rec_index).message_text := fnd_message.get();
6621: END IF;
6622: IF BITAND(cr.error_number,G_ES_PTP_REG_NUM_INVALID) <> 0 THEN
6623: fnd_message.set_name('ZX','ZX_REG_NUM_INVALID');
6624: l_rec_index := l_rec_index +1;
6619: l_error_table(l_rec_index).party_id := cr.party_id;
6620: l_error_table(l_rec_index).message_text := fnd_message.get();
6621: END IF;
6622: IF BITAND(cr.error_number,G_ES_PTP_REG_NUM_INVALID) <> 0 THEN
6623: fnd_message.set_name('ZX','ZX_REG_NUM_INVALID');
6624: l_rec_index := l_rec_index +1;
6625: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6626: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6627: l_error_table(l_rec_index).party_id := cr.party_id;
6624: l_rec_index := l_rec_index +1;
6625: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6626: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6627: l_error_table(l_rec_index).party_id := cr.party_id;
6628: l_error_table(l_rec_index).message_text := fnd_message.get();
6629: END IF;
6630: IF BITAND(cr.error_number,G_ES_PTP_REG_TYPE_INVALID) <> 0 THEN
6631: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6632: IF cr.registration_type_code IS NOT NULL THEN
6627: l_error_table(l_rec_index).party_id := cr.party_id;
6628: l_error_table(l_rec_index).message_text := fnd_message.get();
6629: END IF;
6630: IF BITAND(cr.error_number,G_ES_PTP_REG_TYPE_INVALID) <> 0 THEN
6631: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6632: IF cr.registration_type_code IS NOT NULL THEN
6633: fnd_message.set_token('VALUE_NAME',cr.registration_type_code );
6634: fnd_message.set_token('COLUMN_NAME','REGISTRATION_TYPE_CODE' );
6635: ELSE
6629: END IF;
6630: IF BITAND(cr.error_number,G_ES_PTP_REG_TYPE_INVALID) <> 0 THEN
6631: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6632: IF cr.registration_type_code IS NOT NULL THEN
6633: fnd_message.set_token('VALUE_NAME',cr.registration_type_code );
6634: fnd_message.set_token('COLUMN_NAME','REGISTRATION_TYPE_CODE' );
6635: ELSE
6636: fnd_message.set_token('VALUE_NAME',cr.registration_type_name );
6637: fnd_message.set_token('COLUMN_NAME','REGISTRATION_TYPE_NAME' );
6630: IF BITAND(cr.error_number,G_ES_PTP_REG_TYPE_INVALID) <> 0 THEN
6631: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6632: IF cr.registration_type_code IS NOT NULL THEN
6633: fnd_message.set_token('VALUE_NAME',cr.registration_type_code );
6634: fnd_message.set_token('COLUMN_NAME','REGISTRATION_TYPE_CODE' );
6635: ELSE
6636: fnd_message.set_token('VALUE_NAME',cr.registration_type_name );
6637: fnd_message.set_token('COLUMN_NAME','REGISTRATION_TYPE_NAME' );
6638: END IF;
6632: IF cr.registration_type_code IS NOT NULL THEN
6633: fnd_message.set_token('VALUE_NAME',cr.registration_type_code );
6634: fnd_message.set_token('COLUMN_NAME','REGISTRATION_TYPE_CODE' );
6635: ELSE
6636: fnd_message.set_token('VALUE_NAME',cr.registration_type_name );
6637: fnd_message.set_token('COLUMN_NAME','REGISTRATION_TYPE_NAME' );
6638: END IF;
6639: l_rec_index := l_rec_index +1;
6640: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6633: fnd_message.set_token('VALUE_NAME',cr.registration_type_code );
6634: fnd_message.set_token('COLUMN_NAME','REGISTRATION_TYPE_CODE' );
6635: ELSE
6636: fnd_message.set_token('VALUE_NAME',cr.registration_type_name );
6637: fnd_message.set_token('COLUMN_NAME','REGISTRATION_TYPE_NAME' );
6638: END IF;
6639: l_rec_index := l_rec_index +1;
6640: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6641: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6639: l_rec_index := l_rec_index +1;
6640: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6641: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6642: l_error_table(l_rec_index).party_id := cr.party_id;
6643: l_error_table(l_rec_index).message_text := fnd_message.get();
6644: END IF;
6645:
6646: IF BITAND(cr.error_number,G_ES_PTP_ROUND_LEVEL_INVALID) <> 0 THEN
6647: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6643: l_error_table(l_rec_index).message_text := fnd_message.get();
6644: END IF;
6645:
6646: IF BITAND(cr.error_number,G_ES_PTP_ROUND_LEVEL_INVALID) <> 0 THEN
6647: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6648: IF cr.rounding_level_code IS NOT NULL THEN
6649: fnd_message.set_token('VALUE_NAME',cr.rounding_level_code );
6650: fnd_message.set_token('COLUMN_NAME','ROUNDING_LEVEL_CODE' );
6651: ELSE
6645:
6646: IF BITAND(cr.error_number,G_ES_PTP_ROUND_LEVEL_INVALID) <> 0 THEN
6647: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6648: IF cr.rounding_level_code IS NOT NULL THEN
6649: fnd_message.set_token('VALUE_NAME',cr.rounding_level_code );
6650: fnd_message.set_token('COLUMN_NAME','ROUNDING_LEVEL_CODE' );
6651: ELSE
6652: fnd_message.set_token('VALUE_NAME',cr.rounding_level_name );
6653: fnd_message.set_token('COLUMN_NAME','ROUNDING_LEVEL_NAME' );
6646: IF BITAND(cr.error_number,G_ES_PTP_ROUND_LEVEL_INVALID) <> 0 THEN
6647: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6648: IF cr.rounding_level_code IS NOT NULL THEN
6649: fnd_message.set_token('VALUE_NAME',cr.rounding_level_code );
6650: fnd_message.set_token('COLUMN_NAME','ROUNDING_LEVEL_CODE' );
6651: ELSE
6652: fnd_message.set_token('VALUE_NAME',cr.rounding_level_name );
6653: fnd_message.set_token('COLUMN_NAME','ROUNDING_LEVEL_NAME' );
6654: END IF;
6648: IF cr.rounding_level_code IS NOT NULL THEN
6649: fnd_message.set_token('VALUE_NAME',cr.rounding_level_code );
6650: fnd_message.set_token('COLUMN_NAME','ROUNDING_LEVEL_CODE' );
6651: ELSE
6652: fnd_message.set_token('VALUE_NAME',cr.rounding_level_name );
6653: fnd_message.set_token('COLUMN_NAME','ROUNDING_LEVEL_NAME' );
6654: END IF;
6655: l_rec_index := l_rec_index +1;
6656: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6649: fnd_message.set_token('VALUE_NAME',cr.rounding_level_code );
6650: fnd_message.set_token('COLUMN_NAME','ROUNDING_LEVEL_CODE' );
6651: ELSE
6652: fnd_message.set_token('VALUE_NAME',cr.rounding_level_name );
6653: fnd_message.set_token('COLUMN_NAME','ROUNDING_LEVEL_NAME' );
6654: END IF;
6655: l_rec_index := l_rec_index +1;
6656: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6657: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6655: l_rec_index := l_rec_index +1;
6656: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6657: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6658: l_error_table(l_rec_index).party_id := cr.party_id;
6659: l_error_table(l_rec_index).message_text := fnd_message.get();
6660: END IF;
6661:
6662: IF BITAND(cr.error_number,G_ES_PTP_ROUND_RULE_INVALID) <> 0 THEN
6663: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6659: l_error_table(l_rec_index).message_text := fnd_message.get();
6660: END IF;
6661:
6662: IF BITAND(cr.error_number,G_ES_PTP_ROUND_RULE_INVALID) <> 0 THEN
6663: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6664: IF cr.rounding_rule_code IS NOT NULL THEN
6665: fnd_message.set_token('VALUE_NAME',cr.rounding_rule_code );
6666: fnd_message.set_token('COLUMN_NAME','ROUNDING_RULE_CODE' );
6667: ELSE
6661:
6662: IF BITAND(cr.error_number,G_ES_PTP_ROUND_RULE_INVALID) <> 0 THEN
6663: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6664: IF cr.rounding_rule_code IS NOT NULL THEN
6665: fnd_message.set_token('VALUE_NAME',cr.rounding_rule_code );
6666: fnd_message.set_token('COLUMN_NAME','ROUNDING_RULE_CODE' );
6667: ELSE
6668: fnd_message.set_token('VALUE_NAME',cr.rounding_rule_name );
6669: fnd_message.set_token('COLUMN_NAME','ROUNDING_RULE_NAME' );
6662: IF BITAND(cr.error_number,G_ES_PTP_ROUND_RULE_INVALID) <> 0 THEN
6663: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6664: IF cr.rounding_rule_code IS NOT NULL THEN
6665: fnd_message.set_token('VALUE_NAME',cr.rounding_rule_code );
6666: fnd_message.set_token('COLUMN_NAME','ROUNDING_RULE_CODE' );
6667: ELSE
6668: fnd_message.set_token('VALUE_NAME',cr.rounding_rule_name );
6669: fnd_message.set_token('COLUMN_NAME','ROUNDING_RULE_NAME' );
6670: END IF;
6664: IF cr.rounding_rule_code IS NOT NULL THEN
6665: fnd_message.set_token('VALUE_NAME',cr.rounding_rule_code );
6666: fnd_message.set_token('COLUMN_NAME','ROUNDING_RULE_CODE' );
6667: ELSE
6668: fnd_message.set_token('VALUE_NAME',cr.rounding_rule_name );
6669: fnd_message.set_token('COLUMN_NAME','ROUNDING_RULE_NAME' );
6670: END IF;
6671: l_rec_index := l_rec_index +1;
6672: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6665: fnd_message.set_token('VALUE_NAME',cr.rounding_rule_code );
6666: fnd_message.set_token('COLUMN_NAME','ROUNDING_RULE_CODE' );
6667: ELSE
6668: fnd_message.set_token('VALUE_NAME',cr.rounding_rule_name );
6669: fnd_message.set_token('COLUMN_NAME','ROUNDING_RULE_NAME' );
6670: END IF;
6671: l_rec_index := l_rec_index +1;
6672: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6673: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6671: l_rec_index := l_rec_index +1;
6672: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6673: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6674: l_error_table(l_rec_index).party_id := cr.party_id;
6675: l_error_table(l_rec_index).message_text := fnd_message.get();
6676: END IF;
6677: IF BITAND(cr.error_number,G_ES_PTP_TAX_CLASS_INVALID) <> 0 THEN
6678: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6679: IF cr.tax_classification_code IS NOT NULL THEN
6674: l_error_table(l_rec_index).party_id := cr.party_id;
6675: l_error_table(l_rec_index).message_text := fnd_message.get();
6676: END IF;
6677: IF BITAND(cr.error_number,G_ES_PTP_TAX_CLASS_INVALID) <> 0 THEN
6678: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6679: IF cr.tax_classification_code IS NOT NULL THEN
6680: fnd_message.set_token('VALUE_NAME',cr.tax_classification_code );
6681: fnd_message.set_token('COLUMN_NAME','TAX_CLASSIFICATION_CODE' );
6682: ELSE
6676: END IF;
6677: IF BITAND(cr.error_number,G_ES_PTP_TAX_CLASS_INVALID) <> 0 THEN
6678: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6679: IF cr.tax_classification_code IS NOT NULL THEN
6680: fnd_message.set_token('VALUE_NAME',cr.tax_classification_code );
6681: fnd_message.set_token('COLUMN_NAME','TAX_CLASSIFICATION_CODE' );
6682: ELSE
6683: fnd_message.set_token('VALUE_NAME',cr.tax_classification_name );
6684: fnd_message.set_token('COLUMN_NAME','TAX_CLASSIFICATION_NAME' );
6677: IF BITAND(cr.error_number,G_ES_PTP_TAX_CLASS_INVALID) <> 0 THEN
6678: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6679: IF cr.tax_classification_code IS NOT NULL THEN
6680: fnd_message.set_token('VALUE_NAME',cr.tax_classification_code );
6681: fnd_message.set_token('COLUMN_NAME','TAX_CLASSIFICATION_CODE' );
6682: ELSE
6683: fnd_message.set_token('VALUE_NAME',cr.tax_classification_name );
6684: fnd_message.set_token('COLUMN_NAME','TAX_CLASSIFICATION_NAME' );
6685: END IF;
6679: IF cr.tax_classification_code IS NOT NULL THEN
6680: fnd_message.set_token('VALUE_NAME',cr.tax_classification_code );
6681: fnd_message.set_token('COLUMN_NAME','TAX_CLASSIFICATION_CODE' );
6682: ELSE
6683: fnd_message.set_token('VALUE_NAME',cr.tax_classification_name );
6684: fnd_message.set_token('COLUMN_NAME','TAX_CLASSIFICATION_NAME' );
6685: END IF;
6686: l_rec_index := l_rec_index +1;
6687: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6680: fnd_message.set_token('VALUE_NAME',cr.tax_classification_code );
6681: fnd_message.set_token('COLUMN_NAME','TAX_CLASSIFICATION_CODE' );
6682: ELSE
6683: fnd_message.set_token('VALUE_NAME',cr.tax_classification_name );
6684: fnd_message.set_token('COLUMN_NAME','TAX_CLASSIFICATION_NAME' );
6685: END IF;
6686: l_rec_index := l_rec_index +1;
6687: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6688: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6686: l_rec_index := l_rec_index +1;
6687: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6688: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6689: l_error_table(l_rec_index).party_id := cr.party_id;
6690: l_error_table(l_rec_index).message_text := fnd_message.get();
6691: END IF;
6692: IF BITAND(cr.error_number,G_ES_PTP_INC_FLG_INVALID) <> 0 THEN
6693: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6694: fnd_message.set_token('VALUE_NAME',cr.inclusive_tax_flag );
6689: l_error_table(l_rec_index).party_id := cr.party_id;
6690: l_error_table(l_rec_index).message_text := fnd_message.get();
6691: END IF;
6692: IF BITAND(cr.error_number,G_ES_PTP_INC_FLG_INVALID) <> 0 THEN
6693: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6694: fnd_message.set_token('VALUE_NAME',cr.inclusive_tax_flag );
6695: fnd_message.set_token('COLUMN_NAME','INCLUSIVE_TAX_FLAG' );
6696: l_rec_index := l_rec_index +1;
6697: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6690: l_error_table(l_rec_index).message_text := fnd_message.get();
6691: END IF;
6692: IF BITAND(cr.error_number,G_ES_PTP_INC_FLG_INVALID) <> 0 THEN
6693: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6694: fnd_message.set_token('VALUE_NAME',cr.inclusive_tax_flag );
6695: fnd_message.set_token('COLUMN_NAME','INCLUSIVE_TAX_FLAG' );
6696: l_rec_index := l_rec_index +1;
6697: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6698: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6691: END IF;
6692: IF BITAND(cr.error_number,G_ES_PTP_INC_FLG_INVALID) <> 0 THEN
6693: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6694: fnd_message.set_token('VALUE_NAME',cr.inclusive_tax_flag );
6695: fnd_message.set_token('COLUMN_NAME','INCLUSIVE_TAX_FLAG' );
6696: l_rec_index := l_rec_index +1;
6697: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6698: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6699: l_error_table(l_rec_index).party_id := cr.party_id;
6696: l_rec_index := l_rec_index +1;
6697: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6698: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6699: l_error_table(l_rec_index).party_id := cr.party_id;
6700: l_error_table(l_rec_index).message_text := fnd_message.get();
6701: END IF;
6702: IF BITAND(cr.error_number,G_ES_PTP_APP_FLG_INVALID) <> 0 THEN
6703: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6704: fnd_message.set_token('VALUE_NAME',cr.process_for_applicability_flag );
6699: l_error_table(l_rec_index).party_id := cr.party_id;
6700: l_error_table(l_rec_index).message_text := fnd_message.get();
6701: END IF;
6702: IF BITAND(cr.error_number,G_ES_PTP_APP_FLG_INVALID) <> 0 THEN
6703: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6704: fnd_message.set_token('VALUE_NAME',cr.process_for_applicability_flag );
6705: fnd_message.set_token('COLUMN_NAME','PROCESS_FOR_APPLICABILITY_FLAG' );
6706: l_rec_index := l_rec_index +1;
6707: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6700: l_error_table(l_rec_index).message_text := fnd_message.get();
6701: END IF;
6702: IF BITAND(cr.error_number,G_ES_PTP_APP_FLG_INVALID) <> 0 THEN
6703: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6704: fnd_message.set_token('VALUE_NAME',cr.process_for_applicability_flag );
6705: fnd_message.set_token('COLUMN_NAME','PROCESS_FOR_APPLICABILITY_FLAG' );
6706: l_rec_index := l_rec_index +1;
6707: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6708: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6701: END IF;
6702: IF BITAND(cr.error_number,G_ES_PTP_APP_FLG_INVALID) <> 0 THEN
6703: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6704: fnd_message.set_token('VALUE_NAME',cr.process_for_applicability_flag );
6705: fnd_message.set_token('COLUMN_NAME','PROCESS_FOR_APPLICABILITY_FLAG' );
6706: l_rec_index := l_rec_index +1;
6707: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6708: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6709: l_error_table(l_rec_index).party_id := cr.party_id;
6706: l_rec_index := l_rec_index +1;
6707: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6708: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6709: l_error_table(l_rec_index).party_id := cr.party_id;
6710: l_error_table(l_rec_index).message_text := fnd_message.get();
6711: END IF;
6712: IF BITAND(cr.error_number,G_ES_PTP_OFF_FLG_RECORD) <> 0 THEN
6713: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6714: fnd_message.set_token('VALUE_NAME',cr.allow_offset_tax_flag );
6709: l_error_table(l_rec_index).party_id := cr.party_id;
6710: l_error_table(l_rec_index).message_text := fnd_message.get();
6711: END IF;
6712: IF BITAND(cr.error_number,G_ES_PTP_OFF_FLG_RECORD) <> 0 THEN
6713: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6714: fnd_message.set_token('VALUE_NAME',cr.allow_offset_tax_flag );
6715: fnd_message.set_token('COLUMN_NAME','ALLOW_OFFSET_TAX_FLAG' );
6716: l_rec_index := l_rec_index +1;
6717: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6710: l_error_table(l_rec_index).message_text := fnd_message.get();
6711: END IF;
6712: IF BITAND(cr.error_number,G_ES_PTP_OFF_FLG_RECORD) <> 0 THEN
6713: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6714: fnd_message.set_token('VALUE_NAME',cr.allow_offset_tax_flag );
6715: fnd_message.set_token('COLUMN_NAME','ALLOW_OFFSET_TAX_FLAG' );
6716: l_rec_index := l_rec_index +1;
6717: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6718: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6711: END IF;
6712: IF BITAND(cr.error_number,G_ES_PTP_OFF_FLG_RECORD) <> 0 THEN
6713: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6714: fnd_message.set_token('VALUE_NAME',cr.allow_offset_tax_flag );
6715: fnd_message.set_token('COLUMN_NAME','ALLOW_OFFSET_TAX_FLAG' );
6716: l_rec_index := l_rec_index +1;
6717: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6718: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6719: l_error_table(l_rec_index).party_id := cr.party_id;
6716: l_rec_index := l_rec_index +1;
6717: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6718: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6719: l_error_table(l_rec_index).party_id := cr.party_id;
6720: l_error_table(l_rec_index).message_text := fnd_message.get();
6721: END IF;
6722: IF BITAND(cr.error_number,G_ES_PTP_REG_NUM_DUP) <> 0 THEN
6723: fnd_message.set_name('ZX','ZX_BULK_DUP_REG_NUM');
6724: fnd_message.set_token('REGISTRATION_NUMBER',cr.registration_number );
6719: l_error_table(l_rec_index).party_id := cr.party_id;
6720: l_error_table(l_rec_index).message_text := fnd_message.get();
6721: END IF;
6722: IF BITAND(cr.error_number,G_ES_PTP_REG_NUM_DUP) <> 0 THEN
6723: fnd_message.set_name('ZX','ZX_BULK_DUP_REG_NUM');
6724: fnd_message.set_token('REGISTRATION_NUMBER',cr.registration_number );
6725: l_rec_index := l_rec_index +1;
6726: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6727: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6720: l_error_table(l_rec_index).message_text := fnd_message.get();
6721: END IF;
6722: IF BITAND(cr.error_number,G_ES_PTP_REG_NUM_DUP) <> 0 THEN
6723: fnd_message.set_name('ZX','ZX_BULK_DUP_REG_NUM');
6724: fnd_message.set_token('REGISTRATION_NUMBER',cr.registration_number );
6725: l_rec_index := l_rec_index +1;
6726: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6727: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6728: l_error_table(l_rec_index).party_id := cr.party_id;
6725: l_rec_index := l_rec_index +1;
6726: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6727: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6728: l_error_table(l_rec_index).party_id := cr.party_id;
6729: l_error_table(l_rec_index).message_text := fnd_message.get();
6730: END IF;
6731:
6732: FOR loop_index IN NVL(l_error_table.FIRST,0)..NVL(l_error_table.LAST,-1) LOOP
6733: INSERT INTO zx_errors_int
6762: --
6763: l_rec_index := 0;
6764: FOR cr in c_reg_errors LOOP
6765: IF BITAND(cr.error_number,G_ES_REG_MAND_PARAM_MISSING) <> 0 THEN
6766: fnd_message.set_name('ZX','ZX_INTF_MAND_VALUE_MISSING');
6767: l_rec_index := l_rec_index +1;
6768: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6769: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6770: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
6768: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6769: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6770: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
6771: l_error_table(l_rec_index).party_id := cr.party_id;
6772: l_error_table(l_rec_index).message_text := fnd_message.get();
6773: END IF;
6774: IF BITAND(cr.error_number,G_ES_REG_DUP_INTF_RECORD) <> 0 THEN
6775: fnd_message.set_name('ZX','ZX_BULK_DUP_REG_REF');
6776: l_rec_index := l_rec_index +1;
6771: l_error_table(l_rec_index).party_id := cr.party_id;
6772: l_error_table(l_rec_index).message_text := fnd_message.get();
6773: END IF;
6774: IF BITAND(cr.error_number,G_ES_REG_DUP_INTF_RECORD) <> 0 THEN
6775: fnd_message.set_name('ZX','ZX_BULK_DUP_REG_REF');
6776: l_rec_index := l_rec_index +1;
6777: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6778: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6779: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
6777: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6778: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6779: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
6780: l_error_table(l_rec_index).party_id := cr.party_id;
6781: l_error_table(l_rec_index).message_text := fnd_message.get();
6782: END IF;
6783: IF BITAND(cr.error_number,G_ES_REG_DATE_OVERLAP) <> 0 THEN
6784: fnd_message.set_name('ZX','ZX_PERIOD_OVERLAP');
6785: l_rec_index := l_rec_index +1;
6780: l_error_table(l_rec_index).party_id := cr.party_id;
6781: l_error_table(l_rec_index).message_text := fnd_message.get();
6782: END IF;
6783: IF BITAND(cr.error_number,G_ES_REG_DATE_OVERLAP) <> 0 THEN
6784: fnd_message.set_name('ZX','ZX_PERIOD_OVERLAP');
6785: l_rec_index := l_rec_index +1;
6786: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6787: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6788: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
6786: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6787: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6788: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
6789: l_error_table(l_rec_index).party_id := cr.party_id;
6790: l_error_table(l_rec_index).message_text := fnd_message.get();
6791: END IF;
6792: IF BITAND(cr.error_number,G_ES_REG_TRANS_TYPE_INVALID) <> 0 THEN
6793: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6794: fnd_message.set_token('VALUE_NAME',cr.dml_type );
6789: l_error_table(l_rec_index).party_id := cr.party_id;
6790: l_error_table(l_rec_index).message_text := fnd_message.get();
6791: END IF;
6792: IF BITAND(cr.error_number,G_ES_REG_TRANS_TYPE_INVALID) <> 0 THEN
6793: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6794: fnd_message.set_token('VALUE_NAME',cr.dml_type );
6795: fnd_message.set_token('COLUMN_NAME','DML_TYPE' );
6796: l_rec_index := l_rec_index +1;
6797: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6790: l_error_table(l_rec_index).message_text := fnd_message.get();
6791: END IF;
6792: IF BITAND(cr.error_number,G_ES_REG_TRANS_TYPE_INVALID) <> 0 THEN
6793: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6794: fnd_message.set_token('VALUE_NAME',cr.dml_type );
6795: fnd_message.set_token('COLUMN_NAME','DML_TYPE' );
6796: l_rec_index := l_rec_index +1;
6797: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6798: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6791: END IF;
6792: IF BITAND(cr.error_number,G_ES_REG_TRANS_TYPE_INVALID) <> 0 THEN
6793: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6794: fnd_message.set_token('VALUE_NAME',cr.dml_type );
6795: fnd_message.set_token('COLUMN_NAME','DML_TYPE' );
6796: l_rec_index := l_rec_index +1;
6797: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6798: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6799: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
6797: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6798: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6799: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
6800: l_error_table(l_rec_index).party_id := cr.party_id;
6801: l_error_table(l_rec_index).message_text := fnd_message.get();
6802: END IF;
6803: IF BITAND(cr.error_number,G_ES_REG_DATE_RANGE_INVALID) <> 0 THEN
6804: fnd_message.set_name('ZX','ZX_DATE_RANGE_INVALID');
6805: l_rec_index := l_rec_index +1;
6800: l_error_table(l_rec_index).party_id := cr.party_id;
6801: l_error_table(l_rec_index).message_text := fnd_message.get();
6802: END IF;
6803: IF BITAND(cr.error_number,G_ES_REG_DATE_RANGE_INVALID) <> 0 THEN
6804: fnd_message.set_name('ZX','ZX_DATE_RANGE_INVALID');
6805: l_rec_index := l_rec_index +1;
6806: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6807: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6808: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
6806: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6807: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6808: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
6809: l_error_table(l_rec_index).party_id := cr.party_id;
6810: l_error_table(l_rec_index).message_text := fnd_message.get();
6811: END IF;
6812: IF BITAND(cr.error_number,G_ES_REG_REG_TYPE_INVALID) <> 0 THEN
6813: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6814: IF cr.registration_type_code IS NOT NULL THEN
6809: l_error_table(l_rec_index).party_id := cr.party_id;
6810: l_error_table(l_rec_index).message_text := fnd_message.get();
6811: END IF;
6812: IF BITAND(cr.error_number,G_ES_REG_REG_TYPE_INVALID) <> 0 THEN
6813: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6814: IF cr.registration_type_code IS NOT NULL THEN
6815: fnd_message.set_token('VALUE_NAME',cr.registration_type_code );
6816: fnd_message.set_token('COLUMN_NAME','REGISTRATION_TYPE_CODE' );
6817: ELSE
6811: END IF;
6812: IF BITAND(cr.error_number,G_ES_REG_REG_TYPE_INVALID) <> 0 THEN
6813: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6814: IF cr.registration_type_code IS NOT NULL THEN
6815: fnd_message.set_token('VALUE_NAME',cr.registration_type_code );
6816: fnd_message.set_token('COLUMN_NAME','REGISTRATION_TYPE_CODE' );
6817: ELSE
6818: fnd_message.set_token('VALUE_NAME',cr.registration_type_name );
6819: fnd_message.set_token('COLUMN_NAME','REGISTRATION_TYPE_NAME' );
6812: IF BITAND(cr.error_number,G_ES_REG_REG_TYPE_INVALID) <> 0 THEN
6813: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6814: IF cr.registration_type_code IS NOT NULL THEN
6815: fnd_message.set_token('VALUE_NAME',cr.registration_type_code );
6816: fnd_message.set_token('COLUMN_NAME','REGISTRATION_TYPE_CODE' );
6817: ELSE
6818: fnd_message.set_token('VALUE_NAME',cr.registration_type_name );
6819: fnd_message.set_token('COLUMN_NAME','REGISTRATION_TYPE_NAME' );
6820: END IF;
6814: IF cr.registration_type_code IS NOT NULL THEN
6815: fnd_message.set_token('VALUE_NAME',cr.registration_type_code );
6816: fnd_message.set_token('COLUMN_NAME','REGISTRATION_TYPE_CODE' );
6817: ELSE
6818: fnd_message.set_token('VALUE_NAME',cr.registration_type_name );
6819: fnd_message.set_token('COLUMN_NAME','REGISTRATION_TYPE_NAME' );
6820: END IF;
6821: l_rec_index := l_rec_index +1;
6822: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6815: fnd_message.set_token('VALUE_NAME',cr.registration_type_code );
6816: fnd_message.set_token('COLUMN_NAME','REGISTRATION_TYPE_CODE' );
6817: ELSE
6818: fnd_message.set_token('VALUE_NAME',cr.registration_type_name );
6819: fnd_message.set_token('COLUMN_NAME','REGISTRATION_TYPE_NAME' );
6820: END IF;
6821: l_rec_index := l_rec_index +1;
6822: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6823: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6822: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6823: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6824: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
6825: l_error_table(l_rec_index).party_id := cr.party_id;
6826: l_error_table(l_rec_index).message_text := fnd_message.get();
6827: END IF;
6828: IF BITAND(cr.error_number,G_ES_REG_REG_STAT_INVALID) <> 0 THEN
6829: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6830: IF cr.registration_status_code IS NOT NULL THEN
6825: l_error_table(l_rec_index).party_id := cr.party_id;
6826: l_error_table(l_rec_index).message_text := fnd_message.get();
6827: END IF;
6828: IF BITAND(cr.error_number,G_ES_REG_REG_STAT_INVALID) <> 0 THEN
6829: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6830: IF cr.registration_status_code IS NOT NULL THEN
6831: fnd_message.set_token('VALUE_NAME',cr.registration_status_code );
6832: fnd_message.set_token('COLUMN_NAME','REGISTRATION_STATUS_CODE' );
6833: ELSE
6827: END IF;
6828: IF BITAND(cr.error_number,G_ES_REG_REG_STAT_INVALID) <> 0 THEN
6829: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6830: IF cr.registration_status_code IS NOT NULL THEN
6831: fnd_message.set_token('VALUE_NAME',cr.registration_status_code );
6832: fnd_message.set_token('COLUMN_NAME','REGISTRATION_STATUS_CODE' );
6833: ELSE
6834: fnd_message.set_token('VALUE_NAME',cr.registration_status_name );
6835: fnd_message.set_token('COLUMN_NAME','REGISTRATION_STATUS_NAME' );
6828: IF BITAND(cr.error_number,G_ES_REG_REG_STAT_INVALID) <> 0 THEN
6829: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6830: IF cr.registration_status_code IS NOT NULL THEN
6831: fnd_message.set_token('VALUE_NAME',cr.registration_status_code );
6832: fnd_message.set_token('COLUMN_NAME','REGISTRATION_STATUS_CODE' );
6833: ELSE
6834: fnd_message.set_token('VALUE_NAME',cr.registration_status_name );
6835: fnd_message.set_token('COLUMN_NAME','REGISTRATION_STATUS_NAME' );
6836: END IF;
6830: IF cr.registration_status_code IS NOT NULL THEN
6831: fnd_message.set_token('VALUE_NAME',cr.registration_status_code );
6832: fnd_message.set_token('COLUMN_NAME','REGISTRATION_STATUS_CODE' );
6833: ELSE
6834: fnd_message.set_token('VALUE_NAME',cr.registration_status_name );
6835: fnd_message.set_token('COLUMN_NAME','REGISTRATION_STATUS_NAME' );
6836: END IF;
6837: l_rec_index := l_rec_index +1;
6838: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6831: fnd_message.set_token('VALUE_NAME',cr.registration_status_code );
6832: fnd_message.set_token('COLUMN_NAME','REGISTRATION_STATUS_CODE' );
6833: ELSE
6834: fnd_message.set_token('VALUE_NAME',cr.registration_status_name );
6835: fnd_message.set_token('COLUMN_NAME','REGISTRATION_STATUS_NAME' );
6836: END IF;
6837: l_rec_index := l_rec_index +1;
6838: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6839: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6838: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6839: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6840: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
6841: l_error_table(l_rec_index).party_id := cr.party_id;
6842: l_error_table(l_rec_index).message_text := fnd_message.get();
6843: END IF;
6844: IF BITAND(cr.error_number,G_ES_REG_REG_SRC_INVALID) <> 0 THEN
6845: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6846: IF cr.registration_source_code IS NOT NULL THEN
6841: l_error_table(l_rec_index).party_id := cr.party_id;
6842: l_error_table(l_rec_index).message_text := fnd_message.get();
6843: END IF;
6844: IF BITAND(cr.error_number,G_ES_REG_REG_SRC_INVALID) <> 0 THEN
6845: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6846: IF cr.registration_source_code IS NOT NULL THEN
6847: fnd_message.set_token('VALUE_NAME',cr.registration_source_code );
6848: fnd_message.set_token('COLUMN_NAME','REGISTRATION_SOURCE_CODE' );
6849: ELSE
6843: END IF;
6844: IF BITAND(cr.error_number,G_ES_REG_REG_SRC_INVALID) <> 0 THEN
6845: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6846: IF cr.registration_source_code IS NOT NULL THEN
6847: fnd_message.set_token('VALUE_NAME',cr.registration_source_code );
6848: fnd_message.set_token('COLUMN_NAME','REGISTRATION_SOURCE_CODE' );
6849: ELSE
6850: fnd_message.set_token('VALUE_NAME',cr.registration_source_name );
6851: fnd_message.set_token('COLUMN_NAME','REGISTRATION_SOURCE_NAME' );
6844: IF BITAND(cr.error_number,G_ES_REG_REG_SRC_INVALID) <> 0 THEN
6845: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6846: IF cr.registration_source_code IS NOT NULL THEN
6847: fnd_message.set_token('VALUE_NAME',cr.registration_source_code );
6848: fnd_message.set_token('COLUMN_NAME','REGISTRATION_SOURCE_CODE' );
6849: ELSE
6850: fnd_message.set_token('VALUE_NAME',cr.registration_source_name );
6851: fnd_message.set_token('COLUMN_NAME','REGISTRATION_SOURCE_NAME' );
6852: END IF;
6846: IF cr.registration_source_code IS NOT NULL THEN
6847: fnd_message.set_token('VALUE_NAME',cr.registration_source_code );
6848: fnd_message.set_token('COLUMN_NAME','REGISTRATION_SOURCE_CODE' );
6849: ELSE
6850: fnd_message.set_token('VALUE_NAME',cr.registration_source_name );
6851: fnd_message.set_token('COLUMN_NAME','REGISTRATION_SOURCE_NAME' );
6852: END IF;
6853: l_rec_index := l_rec_index +1;
6854: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6847: fnd_message.set_token('VALUE_NAME',cr.registration_source_code );
6848: fnd_message.set_token('COLUMN_NAME','REGISTRATION_SOURCE_CODE' );
6849: ELSE
6850: fnd_message.set_token('VALUE_NAME',cr.registration_source_name );
6851: fnd_message.set_token('COLUMN_NAME','REGISTRATION_SOURCE_NAME' );
6852: END IF;
6853: l_rec_index := l_rec_index +1;
6854: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6855: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6854: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6855: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6856: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
6857: l_error_table(l_rec_index).party_id := cr.party_id;
6858: l_error_table(l_rec_index).message_text := fnd_message.get();
6859: END IF;
6860: IF BITAND(cr.error_number,G_ES_REG_REG_RSN_INVALID) <> 0 THEN
6861: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6862: IF cr.registration_reason_code IS NOT NULL THEN
6857: l_error_table(l_rec_index).party_id := cr.party_id;
6858: l_error_table(l_rec_index).message_text := fnd_message.get();
6859: END IF;
6860: IF BITAND(cr.error_number,G_ES_REG_REG_RSN_INVALID) <> 0 THEN
6861: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6862: IF cr.registration_reason_code IS NOT NULL THEN
6863: fnd_message.set_token('VALUE_NAME',cr.registration_reason_code );
6864: fnd_message.set_token('COLUMN_NAME','REGISTRATION_REASON_CODE' );
6865: ELSE
6859: END IF;
6860: IF BITAND(cr.error_number,G_ES_REG_REG_RSN_INVALID) <> 0 THEN
6861: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6862: IF cr.registration_reason_code IS NOT NULL THEN
6863: fnd_message.set_token('VALUE_NAME',cr.registration_reason_code );
6864: fnd_message.set_token('COLUMN_NAME','REGISTRATION_REASON_CODE' );
6865: ELSE
6866: fnd_message.set_token('VALUE_NAME',cr.registration_reason_name );
6867: fnd_message.set_token('COLUMN_NAME','REGISTRATION_REASON_NAME' );
6860: IF BITAND(cr.error_number,G_ES_REG_REG_RSN_INVALID) <> 0 THEN
6861: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6862: IF cr.registration_reason_code IS NOT NULL THEN
6863: fnd_message.set_token('VALUE_NAME',cr.registration_reason_code );
6864: fnd_message.set_token('COLUMN_NAME','REGISTRATION_REASON_CODE' );
6865: ELSE
6866: fnd_message.set_token('VALUE_NAME',cr.registration_reason_name );
6867: fnd_message.set_token('COLUMN_NAME','REGISTRATION_REASON_NAME' );
6868: END IF;
6862: IF cr.registration_reason_code IS NOT NULL THEN
6863: fnd_message.set_token('VALUE_NAME',cr.registration_reason_code );
6864: fnd_message.set_token('COLUMN_NAME','REGISTRATION_REASON_CODE' );
6865: ELSE
6866: fnd_message.set_token('VALUE_NAME',cr.registration_reason_name );
6867: fnd_message.set_token('COLUMN_NAME','REGISTRATION_REASON_NAME' );
6868: END IF;
6869: l_rec_index := l_rec_index +1;
6870: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6863: fnd_message.set_token('VALUE_NAME',cr.registration_reason_code );
6864: fnd_message.set_token('COLUMN_NAME','REGISTRATION_REASON_CODE' );
6865: ELSE
6866: fnd_message.set_token('VALUE_NAME',cr.registration_reason_name );
6867: fnd_message.set_token('COLUMN_NAME','REGISTRATION_REASON_NAME' );
6868: END IF;
6869: l_rec_index := l_rec_index +1;
6870: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6871: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6870: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6871: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6872: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
6873: l_error_table(l_rec_index).party_id := cr.party_id;
6874: l_error_table(l_rec_index).message_text := fnd_message.get();
6875: END IF;
6876: IF BITAND(cr.error_number,G_ES_REG_TAX_AUT_INVALID) <> 0 THEN
6877: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6878: IF cr.tax_authority_id IS NOT NULL THEN
6873: l_error_table(l_rec_index).party_id := cr.party_id;
6874: l_error_table(l_rec_index).message_text := fnd_message.get();
6875: END IF;
6876: IF BITAND(cr.error_number,G_ES_REG_TAX_AUT_INVALID) <> 0 THEN
6877: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6878: IF cr.tax_authority_id IS NOT NULL THEN
6879: fnd_message.set_token('VALUE_NAME',cr.tax_authority_id );
6880: fnd_message.set_token('COLUMN_NAME','TAX_AUTHORITY_ID' );
6881: ELSE
6875: END IF;
6876: IF BITAND(cr.error_number,G_ES_REG_TAX_AUT_INVALID) <> 0 THEN
6877: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6878: IF cr.tax_authority_id IS NOT NULL THEN
6879: fnd_message.set_token('VALUE_NAME',cr.tax_authority_id );
6880: fnd_message.set_token('COLUMN_NAME','TAX_AUTHORITY_ID' );
6881: ELSE
6882: fnd_message.set_token('VALUE_NAME',cr.tax_authority_name );
6883: fnd_message.set_token('COLUMN_NAME','TAX_AUTHORITY_NAME' );
6876: IF BITAND(cr.error_number,G_ES_REG_TAX_AUT_INVALID) <> 0 THEN
6877: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6878: IF cr.tax_authority_id IS NOT NULL THEN
6879: fnd_message.set_token('VALUE_NAME',cr.tax_authority_id );
6880: fnd_message.set_token('COLUMN_NAME','TAX_AUTHORITY_ID' );
6881: ELSE
6882: fnd_message.set_token('VALUE_NAME',cr.tax_authority_name );
6883: fnd_message.set_token('COLUMN_NAME','TAX_AUTHORITY_NAME' );
6884: END IF;
6878: IF cr.tax_authority_id IS NOT NULL THEN
6879: fnd_message.set_token('VALUE_NAME',cr.tax_authority_id );
6880: fnd_message.set_token('COLUMN_NAME','TAX_AUTHORITY_ID' );
6881: ELSE
6882: fnd_message.set_token('VALUE_NAME',cr.tax_authority_name );
6883: fnd_message.set_token('COLUMN_NAME','TAX_AUTHORITY_NAME' );
6884: END IF;
6885: l_rec_index := l_rec_index +1;
6886: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6879: fnd_message.set_token('VALUE_NAME',cr.tax_authority_id );
6880: fnd_message.set_token('COLUMN_NAME','TAX_AUTHORITY_ID' );
6881: ELSE
6882: fnd_message.set_token('VALUE_NAME',cr.tax_authority_name );
6883: fnd_message.set_token('COLUMN_NAME','TAX_AUTHORITY_NAME' );
6884: END IF;
6885: l_rec_index := l_rec_index +1;
6886: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6887: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6886: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6887: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6888: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
6889: l_error_table(l_rec_index).party_id := cr.party_id;
6890: l_error_table(l_rec_index).message_text := fnd_message.get();
6891: END IF;
6892: IF BITAND(cr.error_number,G_ES_REG_ROUND_RULE_INVALID) <> 0 THEN
6893: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6894: IF cr.registration_type_code IS NOT NULL THEN
6889: l_error_table(l_rec_index).party_id := cr.party_id;
6890: l_error_table(l_rec_index).message_text := fnd_message.get();
6891: END IF;
6892: IF BITAND(cr.error_number,G_ES_REG_ROUND_RULE_INVALID) <> 0 THEN
6893: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6894: IF cr.registration_type_code IS NOT NULL THEN
6895: fnd_message.set_token('VALUE_NAME',cr.rounding_rule_code );
6896: fnd_message.set_token('COLUMN_NAME','ROUNDING_RULE_CODE' );
6897: ELSE
6891: END IF;
6892: IF BITAND(cr.error_number,G_ES_REG_ROUND_RULE_INVALID) <> 0 THEN
6893: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6894: IF cr.registration_type_code IS NOT NULL THEN
6895: fnd_message.set_token('VALUE_NAME',cr.rounding_rule_code );
6896: fnd_message.set_token('COLUMN_NAME','ROUNDING_RULE_CODE' );
6897: ELSE
6898: fnd_message.set_token('VALUE_NAME',cr.rounding_rule_name );
6899: fnd_message.set_token('COLUMN_NAME','ROUNDING_RULE_NAME' );
6892: IF BITAND(cr.error_number,G_ES_REG_ROUND_RULE_INVALID) <> 0 THEN
6893: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6894: IF cr.registration_type_code IS NOT NULL THEN
6895: fnd_message.set_token('VALUE_NAME',cr.rounding_rule_code );
6896: fnd_message.set_token('COLUMN_NAME','ROUNDING_RULE_CODE' );
6897: ELSE
6898: fnd_message.set_token('VALUE_NAME',cr.rounding_rule_name );
6899: fnd_message.set_token('COLUMN_NAME','ROUNDING_RULE_NAME' );
6900: END IF;
6894: IF cr.registration_type_code IS NOT NULL THEN
6895: fnd_message.set_token('VALUE_NAME',cr.rounding_rule_code );
6896: fnd_message.set_token('COLUMN_NAME','ROUNDING_RULE_CODE' );
6897: ELSE
6898: fnd_message.set_token('VALUE_NAME',cr.rounding_rule_name );
6899: fnd_message.set_token('COLUMN_NAME','ROUNDING_RULE_NAME' );
6900: END IF;
6901: l_rec_index := l_rec_index +1;
6902: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6895: fnd_message.set_token('VALUE_NAME',cr.rounding_rule_code );
6896: fnd_message.set_token('COLUMN_NAME','ROUNDING_RULE_CODE' );
6897: ELSE
6898: fnd_message.set_token('VALUE_NAME',cr.rounding_rule_name );
6899: fnd_message.set_token('COLUMN_NAME','ROUNDING_RULE_NAME' );
6900: END IF;
6901: l_rec_index := l_rec_index +1;
6902: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6903: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6902: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6903: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6904: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
6905: l_error_table(l_rec_index).party_id := cr.party_id;
6906: l_error_table(l_rec_index).message_text := fnd_message.get();
6907: END IF;
6908: IF BITAND(cr.error_number,G_ES_REG_INC_FLG_INVALID) <> 0 THEN
6909: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6910: fnd_message.set_token('VALUE_NAME',cr.inclusive_tax_flag );
6905: l_error_table(l_rec_index).party_id := cr.party_id;
6906: l_error_table(l_rec_index).message_text := fnd_message.get();
6907: END IF;
6908: IF BITAND(cr.error_number,G_ES_REG_INC_FLG_INVALID) <> 0 THEN
6909: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6910: fnd_message.set_token('VALUE_NAME',cr.inclusive_tax_flag );
6911: fnd_message.set_token('COLUMN_NAME','INCLUSIVE_TAX_FLAG' );
6912: l_rec_index := l_rec_index +1;
6913: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6906: l_error_table(l_rec_index).message_text := fnd_message.get();
6907: END IF;
6908: IF BITAND(cr.error_number,G_ES_REG_INC_FLG_INVALID) <> 0 THEN
6909: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6910: fnd_message.set_token('VALUE_NAME',cr.inclusive_tax_flag );
6911: fnd_message.set_token('COLUMN_NAME','INCLUSIVE_TAX_FLAG' );
6912: l_rec_index := l_rec_index +1;
6913: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6914: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6907: END IF;
6908: IF BITAND(cr.error_number,G_ES_REG_INC_FLG_INVALID) <> 0 THEN
6909: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6910: fnd_message.set_token('VALUE_NAME',cr.inclusive_tax_flag );
6911: fnd_message.set_token('COLUMN_NAME','INCLUSIVE_TAX_FLAG' );
6912: l_rec_index := l_rec_index +1;
6913: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6914: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6915: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
6913: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6914: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6915: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
6916: l_error_table(l_rec_index).party_id := cr.party_id;
6917: l_error_table(l_rec_index).message_text := fnd_message.get();
6918: END IF;
6919: IF BITAND(cr.error_number,G_ES_REG_LGL_LOC_INVALID) <> 0 THEN
6920: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6921: IF cr.legal_location_id IS NOT NULL THEN
6916: l_error_table(l_rec_index).party_id := cr.party_id;
6917: l_error_table(l_rec_index).message_text := fnd_message.get();
6918: END IF;
6919: IF BITAND(cr.error_number,G_ES_REG_LGL_LOC_INVALID) <> 0 THEN
6920: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6921: IF cr.legal_location_id IS NOT NULL THEN
6922: fnd_message.set_token('VALUE_NAME',cr.legal_location_id );
6923: fnd_message.set_token('COLUMN_NAME','LEGAL_LOCATION_ID' );
6924: ELSE
6918: END IF;
6919: IF BITAND(cr.error_number,G_ES_REG_LGL_LOC_INVALID) <> 0 THEN
6920: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6921: IF cr.legal_location_id IS NOT NULL THEN
6922: fnd_message.set_token('VALUE_NAME',cr.legal_location_id );
6923: fnd_message.set_token('COLUMN_NAME','LEGAL_LOCATION_ID' );
6924: ELSE
6925: fnd_message.set_token('VALUE_NAME',cr.legal_location_code||':'
6926: ||cr.address_line_1||':'||cr.town_or_city||':'||cr.region_1 );
6919: IF BITAND(cr.error_number,G_ES_REG_LGL_LOC_INVALID) <> 0 THEN
6920: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6921: IF cr.legal_location_id IS NOT NULL THEN
6922: fnd_message.set_token('VALUE_NAME',cr.legal_location_id );
6923: fnd_message.set_token('COLUMN_NAME','LEGAL_LOCATION_ID' );
6924: ELSE
6925: fnd_message.set_token('VALUE_NAME',cr.legal_location_code||':'
6926: ||cr.address_line_1||':'||cr.town_or_city||':'||cr.region_1 );
6927: fnd_message.set_token('COLUMN_NAME','LEGAL_LOCATION_CODE'||':'
6921: IF cr.legal_location_id IS NOT NULL THEN
6922: fnd_message.set_token('VALUE_NAME',cr.legal_location_id );
6923: fnd_message.set_token('COLUMN_NAME','LEGAL_LOCATION_ID' );
6924: ELSE
6925: fnd_message.set_token('VALUE_NAME',cr.legal_location_code||':'
6926: ||cr.address_line_1||':'||cr.town_or_city||':'||cr.region_1 );
6927: fnd_message.set_token('COLUMN_NAME','LEGAL_LOCATION_CODE'||':'
6928: ||'ADDRESS_LINE_1'||':'||'TOWN_OR_CITY'||':'||'REGION_1');
6929: END IF;
6923: fnd_message.set_token('COLUMN_NAME','LEGAL_LOCATION_ID' );
6924: ELSE
6925: fnd_message.set_token('VALUE_NAME',cr.legal_location_code||':'
6926: ||cr.address_line_1||':'||cr.town_or_city||':'||cr.region_1 );
6927: fnd_message.set_token('COLUMN_NAME','LEGAL_LOCATION_CODE'||':'
6928: ||'ADDRESS_LINE_1'||':'||'TOWN_OR_CITY'||':'||'REGION_1');
6929: END IF;
6930: l_rec_index := l_rec_index +1;
6931: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6931: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6932: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6933: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
6934: l_error_table(l_rec_index).party_id := cr.party_id;
6935: l_error_table(l_rec_index).message_text := fnd_message.get();
6936: END IF;
6937: IF BITAND(cr.error_number,G_ES_REG_DEFREG_FLG_INVALID) <> 0 THEN
6938: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6939: fnd_message.set_token('VALUE_NAME',cr.default_registration_flag );
6934: l_error_table(l_rec_index).party_id := cr.party_id;
6935: l_error_table(l_rec_index).message_text := fnd_message.get();
6936: END IF;
6937: IF BITAND(cr.error_number,G_ES_REG_DEFREG_FLG_INVALID) <> 0 THEN
6938: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6939: fnd_message.set_token('VALUE_NAME',cr.default_registration_flag );
6940: fnd_message.set_token('COLUMN_NAME','DEFAULT_REGISTRATION_FLAG' );
6941: l_rec_index := l_rec_index +1;
6942: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6935: l_error_table(l_rec_index).message_text := fnd_message.get();
6936: END IF;
6937: IF BITAND(cr.error_number,G_ES_REG_DEFREG_FLG_INVALID) <> 0 THEN
6938: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6939: fnd_message.set_token('VALUE_NAME',cr.default_registration_flag );
6940: fnd_message.set_token('COLUMN_NAME','DEFAULT_REGISTRATION_FLAG' );
6941: l_rec_index := l_rec_index +1;
6942: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6943: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6936: END IF;
6937: IF BITAND(cr.error_number,G_ES_REG_DEFREG_FLG_INVALID) <> 0 THEN
6938: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6939: fnd_message.set_token('VALUE_NAME',cr.default_registration_flag );
6940: fnd_message.set_token('COLUMN_NAME','DEFAULT_REGISTRATION_FLAG' );
6941: l_rec_index := l_rec_index +1;
6942: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6943: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6944: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
6942: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6943: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6944: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
6945: l_error_table(l_rec_index).party_id := cr.party_id;
6946: l_error_table(l_rec_index).message_text := fnd_message.get();
6947: END IF;
6948: IF BITAND(cr.error_number,G_ES_REG_TAX_REG_INVALID) <> 0 THEN
6949: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6950: IF cr.tax_regime_code IS NOT NULL THEN
6945: l_error_table(l_rec_index).party_id := cr.party_id;
6946: l_error_table(l_rec_index).message_text := fnd_message.get();
6947: END IF;
6948: IF BITAND(cr.error_number,G_ES_REG_TAX_REG_INVALID) <> 0 THEN
6949: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6950: IF cr.tax_regime_code IS NOT NULL THEN
6951: fnd_message.set_token('VALUE_NAME',cr.tax_regime_code );
6952: fnd_message.set_token('COLUMN_NAME','TAX_REGIME_CODE' );
6953: ELSE
6947: END IF;
6948: IF BITAND(cr.error_number,G_ES_REG_TAX_REG_INVALID) <> 0 THEN
6949: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6950: IF cr.tax_regime_code IS NOT NULL THEN
6951: fnd_message.set_token('VALUE_NAME',cr.tax_regime_code );
6952: fnd_message.set_token('COLUMN_NAME','TAX_REGIME_CODE' );
6953: ELSE
6954: fnd_message.set_token('VALUE_NAME',cr.tax_regime_name );
6955: fnd_message.set_token('COLUMN_NAME','TAX_REGIME_NAME' );
6948: IF BITAND(cr.error_number,G_ES_REG_TAX_REG_INVALID) <> 0 THEN
6949: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
6950: IF cr.tax_regime_code IS NOT NULL THEN
6951: fnd_message.set_token('VALUE_NAME',cr.tax_regime_code );
6952: fnd_message.set_token('COLUMN_NAME','TAX_REGIME_CODE' );
6953: ELSE
6954: fnd_message.set_token('VALUE_NAME',cr.tax_regime_name );
6955: fnd_message.set_token('COLUMN_NAME','TAX_REGIME_NAME' );
6956: END IF;
6950: IF cr.tax_regime_code IS NOT NULL THEN
6951: fnd_message.set_token('VALUE_NAME',cr.tax_regime_code );
6952: fnd_message.set_token('COLUMN_NAME','TAX_REGIME_CODE' );
6953: ELSE
6954: fnd_message.set_token('VALUE_NAME',cr.tax_regime_name );
6955: fnd_message.set_token('COLUMN_NAME','TAX_REGIME_NAME' );
6956: END IF;
6957: l_rec_index := l_rec_index +1;
6958: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6951: fnd_message.set_token('VALUE_NAME',cr.tax_regime_code );
6952: fnd_message.set_token('COLUMN_NAME','TAX_REGIME_CODE' );
6953: ELSE
6954: fnd_message.set_token('VALUE_NAME',cr.tax_regime_name );
6955: fnd_message.set_token('COLUMN_NAME','TAX_REGIME_NAME' );
6956: END IF;
6957: l_rec_index := l_rec_index +1;
6958: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6959: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6958: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6959: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6960: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
6961: l_error_table(l_rec_index).party_id := cr.party_id;
6962: l_error_table(l_rec_index).message_text := fnd_message.get();
6963: END IF;
6964: IF BITAND(cr.error_number,G_ES_REG_TAX_PARAM_INVALID) <> 0 THEN
6965: fnd_message.set_name('ZX','ZX_BULK_TAX_INVALID');
6966: IF cr.tax_code IS NOT NULL THEN
6961: l_error_table(l_rec_index).party_id := cr.party_id;
6962: l_error_table(l_rec_index).message_text := fnd_message.get();
6963: END IF;
6964: IF BITAND(cr.error_number,G_ES_REG_TAX_PARAM_INVALID) <> 0 THEN
6965: fnd_message.set_name('ZX','ZX_BULK_TAX_INVALID');
6966: IF cr.tax_code IS NOT NULL THEN
6967: fnd_message.set_token('TAX',cr.tax_code );
6968: ELSE
6969: fnd_message.set_token('TAX',cr.tax_name );
6963: END IF;
6964: IF BITAND(cr.error_number,G_ES_REG_TAX_PARAM_INVALID) <> 0 THEN
6965: fnd_message.set_name('ZX','ZX_BULK_TAX_INVALID');
6966: IF cr.tax_code IS NOT NULL THEN
6967: fnd_message.set_token('TAX',cr.tax_code );
6968: ELSE
6969: fnd_message.set_token('TAX',cr.tax_name );
6970: END IF;
6971: IF cr.tax_regime_name IS NULL THEN
6965: fnd_message.set_name('ZX','ZX_BULK_TAX_INVALID');
6966: IF cr.tax_code IS NOT NULL THEN
6967: fnd_message.set_token('TAX',cr.tax_code );
6968: ELSE
6969: fnd_message.set_token('TAX',cr.tax_name );
6970: END IF;
6971: IF cr.tax_regime_name IS NULL THEN
6972: fnd_message.set_token('TAX_REGIME',cr.tax_regime_code );
6973: ELSE
6968: ELSE
6969: fnd_message.set_token('TAX',cr.tax_name );
6970: END IF;
6971: IF cr.tax_regime_name IS NULL THEN
6972: fnd_message.set_token('TAX_REGIME',cr.tax_regime_code );
6973: ELSE
6974: fnd_message.set_token('TAX_REGIME',cr.tax_regime_name );
6975: END IF;
6976: l_rec_index := l_rec_index +1;
6970: END IF;
6971: IF cr.tax_regime_name IS NULL THEN
6972: fnd_message.set_token('TAX_REGIME',cr.tax_regime_code );
6973: ELSE
6974: fnd_message.set_token('TAX_REGIME',cr.tax_regime_name );
6975: END IF;
6976: l_rec_index := l_rec_index +1;
6977: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6978: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6977: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
6978: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
6979: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
6980: l_error_table(l_rec_index).party_id := cr.party_id;
6981: l_error_table(l_rec_index).message_text := fnd_message.get();
6982: END IF;
6983: IF BITAND(cr.error_number,G_ES_REG_TAX_JUR_INVALID) <> 0 THEN
6984: fnd_message.set_name('ZX','ZX_BULK_TAX_JUR_INVALID');
6985: IF cr.tax_jurisdiction_code IS NOT NULL THEN
6980: l_error_table(l_rec_index).party_id := cr.party_id;
6981: l_error_table(l_rec_index).message_text := fnd_message.get();
6982: END IF;
6983: IF BITAND(cr.error_number,G_ES_REG_TAX_JUR_INVALID) <> 0 THEN
6984: fnd_message.set_name('ZX','ZX_BULK_TAX_JUR_INVALID');
6985: IF cr.tax_jurisdiction_code IS NOT NULL THEN
6986: fnd_message.set_token('TAX_JURISDICTION',cr.tax_jurisdiction_code );
6987: ELSE
6988: fnd_message.set_token('TAX_JURISDICTION',cr.tax_jurisdiction_name );
6982: END IF;
6983: IF BITAND(cr.error_number,G_ES_REG_TAX_JUR_INVALID) <> 0 THEN
6984: fnd_message.set_name('ZX','ZX_BULK_TAX_JUR_INVALID');
6985: IF cr.tax_jurisdiction_code IS NOT NULL THEN
6986: fnd_message.set_token('TAX_JURISDICTION',cr.tax_jurisdiction_code );
6987: ELSE
6988: fnd_message.set_token('TAX_JURISDICTION',cr.tax_jurisdiction_name );
6989: END IF;
6990: IF cr.tax_name IS NULL THEN
6984: fnd_message.set_name('ZX','ZX_BULK_TAX_JUR_INVALID');
6985: IF cr.tax_jurisdiction_code IS NOT NULL THEN
6986: fnd_message.set_token('TAX_JURISDICTION',cr.tax_jurisdiction_code );
6987: ELSE
6988: fnd_message.set_token('TAX_JURISDICTION',cr.tax_jurisdiction_name );
6989: END IF;
6990: IF cr.tax_name IS NULL THEN
6991: fnd_message.set_token('TAX',cr.tax_code );
6992: ELSE
6987: ELSE
6988: fnd_message.set_token('TAX_JURISDICTION',cr.tax_jurisdiction_name );
6989: END IF;
6990: IF cr.tax_name IS NULL THEN
6991: fnd_message.set_token('TAX',cr.tax_code );
6992: ELSE
6993: fnd_message.set_token('TAX',cr.tax_name );
6994: END IF;
6995: IF cr.tax_regime_name IS NULL THEN
6989: END IF;
6990: IF cr.tax_name IS NULL THEN
6991: fnd_message.set_token('TAX',cr.tax_code );
6992: ELSE
6993: fnd_message.set_token('TAX',cr.tax_name );
6994: END IF;
6995: IF cr.tax_regime_name IS NULL THEN
6996: fnd_message.set_token('TAX_REGIME',cr.tax_regime_code );
6997: ELSE
6992: ELSE
6993: fnd_message.set_token('TAX',cr.tax_name );
6994: END IF;
6995: IF cr.tax_regime_name IS NULL THEN
6996: fnd_message.set_token('TAX_REGIME',cr.tax_regime_code );
6997: ELSE
6998: fnd_message.set_token('TAX_REGIME',cr.tax_regime_name );
6999: END IF;
7000: l_rec_index := l_rec_index +1;
6994: END IF;
6995: IF cr.tax_regime_name IS NULL THEN
6996: fnd_message.set_token('TAX_REGIME',cr.tax_regime_code );
6997: ELSE
6998: fnd_message.set_token('TAX_REGIME',cr.tax_regime_name );
6999: END IF;
7000: l_rec_index := l_rec_index +1;
7001: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7002: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7001: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7002: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7003: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
7004: l_error_table(l_rec_index).party_id := cr.party_id;
7005: l_error_table(l_rec_index).message_text := fnd_message.get();
7006: END IF;
7007: IF BITAND(cr.error_number,G_ES_REG_REG_NUM_DUP) <> 0 THEN
7008: fnd_message.set_name('ZX','ZX_BULK_DUP_REG_NUM');
7009: fnd_message.set_token('REGISTRATION_NUMBER',cr.registration_number );
7004: l_error_table(l_rec_index).party_id := cr.party_id;
7005: l_error_table(l_rec_index).message_text := fnd_message.get();
7006: END IF;
7007: IF BITAND(cr.error_number,G_ES_REG_REG_NUM_DUP) <> 0 THEN
7008: fnd_message.set_name('ZX','ZX_BULK_DUP_REG_NUM');
7009: fnd_message.set_token('REGISTRATION_NUMBER',cr.registration_number );
7010: l_rec_index := l_rec_index +1;
7011: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7012: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7005: l_error_table(l_rec_index).message_text := fnd_message.get();
7006: END IF;
7007: IF BITAND(cr.error_number,G_ES_REG_REG_NUM_DUP) <> 0 THEN
7008: fnd_message.set_name('ZX','ZX_BULK_DUP_REG_NUM');
7009: fnd_message.set_token('REGISTRATION_NUMBER',cr.registration_number );
7010: l_rec_index := l_rec_index +1;
7011: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7012: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7013: l_error_table(l_rec_index).party_id := cr.party_id;
7010: l_rec_index := l_rec_index +1;
7011: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7012: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7013: l_error_table(l_rec_index).party_id := cr.party_id;
7014: l_error_table(l_rec_index).message_text := fnd_message.get();
7015: END IF;
7016: IF BITAND(cr.error_number,G_ES_REG_REG_NUM_INVALID) <> 0 THEN
7017: fnd_message.set_name('ZX','ZX_REG_NUM_INVALID');
7018: l_rec_index := l_rec_index +1;
7013: l_error_table(l_rec_index).party_id := cr.party_id;
7014: l_error_table(l_rec_index).message_text := fnd_message.get();
7015: END IF;
7016: IF BITAND(cr.error_number,G_ES_REG_REG_NUM_INVALID) <> 0 THEN
7017: fnd_message.set_name('ZX','ZX_REG_NUM_INVALID');
7018: l_rec_index := l_rec_index +1;
7019: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7020: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7021: l_error_table(l_rec_index).party_id := cr.party_id;
7018: l_rec_index := l_rec_index +1;
7019: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7020: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7021: l_error_table(l_rec_index).party_id := cr.party_id;
7022: l_error_table(l_rec_index).message_text := fnd_message.get();
7023: END IF;
7024: IF BITAND(cr.error_number,G_ES_REG_TAX_AUT_REQ) <> 0 THEN
7025: fnd_message.set_name('ZX','ZX_REG_TAX_AUTHORITY_REQUIRED');
7026: l_rec_index := l_rec_index +1;
7021: l_error_table(l_rec_index).party_id := cr.party_id;
7022: l_error_table(l_rec_index).message_text := fnd_message.get();
7023: END IF;
7024: IF BITAND(cr.error_number,G_ES_REG_TAX_AUT_REQ) <> 0 THEN
7025: fnd_message.set_name('ZX','ZX_REG_TAX_AUTHORITY_REQUIRED');
7026: l_rec_index := l_rec_index +1;
7027: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7028: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7029: l_error_table(l_rec_index).party_id := cr.party_id;
7026: l_rec_index := l_rec_index +1;
7027: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7028: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7029: l_error_table(l_rec_index).party_id := cr.party_id;
7030: l_error_table(l_rec_index).message_text := fnd_message.get();
7031: END IF;
7032: IF BITAND(cr.error_number,G_ES_REG_MULT_DEF_FLAG) <> 0 THEN
7033: fnd_message.set_name('ZX','ZX_REG_MULT_DEF_REG');
7034: l_rec_index := l_rec_index +1;
7029: l_error_table(l_rec_index).party_id := cr.party_id;
7030: l_error_table(l_rec_index).message_text := fnd_message.get();
7031: END IF;
7032: IF BITAND(cr.error_number,G_ES_REG_MULT_DEF_FLAG) <> 0 THEN
7033: fnd_message.set_name('ZX','ZX_REG_MULT_DEF_REG');
7034: l_rec_index := l_rec_index +1;
7035: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7036: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7037: l_error_table(l_rec_index).party_id := cr.party_id;
7034: l_rec_index := l_rec_index +1;
7035: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7036: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7037: l_error_table(l_rec_index).party_id := cr.party_id;
7038: l_error_table(l_rec_index).message_text := fnd_message.get();
7039: END IF;
7040:
7041: FOR loop_index IN NVL(l_error_table.FIRST,0)..NVL(l_error_table.LAST,-1) LOOP
7042: INSERT INTO zx_errors_int
7072: --
7073: l_rec_index := 0;
7074: FOR cr in c_exe_errors LOOP
7075: IF BITAND(cr.error_number,G_ES_EXE_MAND_PARAM_MISSING) <> 0 THEN
7076: fnd_message.set_name('ZX','ZX_INTF_MAND_VALUE_MISSING');
7077: l_rec_index := l_rec_index +1;
7078: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7079: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7080: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
7078: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7079: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7080: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
7081: l_error_table(l_rec_index).party_id := cr.party_id;
7082: l_error_table(l_rec_index).message_text := fnd_message.get();
7083: END IF;
7084: IF BITAND(cr.error_number,G_ES_EXE_TRANS_TYPE_INVALID) <> 0 THEN
7085: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
7086: fnd_message.set_token('VALUE_NAME',cr.dml_type );
7081: l_error_table(l_rec_index).party_id := cr.party_id;
7082: l_error_table(l_rec_index).message_text := fnd_message.get();
7083: END IF;
7084: IF BITAND(cr.error_number,G_ES_EXE_TRANS_TYPE_INVALID) <> 0 THEN
7085: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
7086: fnd_message.set_token('VALUE_NAME',cr.dml_type );
7087: fnd_message.set_token('COLUMN_NAME','DML_TYPE' );
7088: l_rec_index := l_rec_index +1;
7089: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7082: l_error_table(l_rec_index).message_text := fnd_message.get();
7083: END IF;
7084: IF BITAND(cr.error_number,G_ES_EXE_TRANS_TYPE_INVALID) <> 0 THEN
7085: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
7086: fnd_message.set_token('VALUE_NAME',cr.dml_type );
7087: fnd_message.set_token('COLUMN_NAME','DML_TYPE' );
7088: l_rec_index := l_rec_index +1;
7089: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7090: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7083: END IF;
7084: IF BITAND(cr.error_number,G_ES_EXE_TRANS_TYPE_INVALID) <> 0 THEN
7085: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
7086: fnd_message.set_token('VALUE_NAME',cr.dml_type );
7087: fnd_message.set_token('COLUMN_NAME','DML_TYPE' );
7088: l_rec_index := l_rec_index +1;
7089: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7090: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7091: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
7089: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7090: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7091: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
7092: l_error_table(l_rec_index).party_id := cr.party_id;
7093: l_error_table(l_rec_index).message_text := fnd_message.get();
7094: END IF;
7095: IF BITAND(cr.error_number,G_ES_EXE_DATE_RANGE_INVALID) <> 0 THEN
7096: fnd_message.set_name('ZX','ZX_DATE_RANGE_INVALID');
7097: l_rec_index := l_rec_index +1;
7092: l_error_table(l_rec_index).party_id := cr.party_id;
7093: l_error_table(l_rec_index).message_text := fnd_message.get();
7094: END IF;
7095: IF BITAND(cr.error_number,G_ES_EXE_DATE_RANGE_INVALID) <> 0 THEN
7096: fnd_message.set_name('ZX','ZX_DATE_RANGE_INVALID');
7097: l_rec_index := l_rec_index +1;
7098: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7099: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7100: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
7098: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7099: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7100: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
7101: l_error_table(l_rec_index).party_id := cr.party_id;
7102: l_error_table(l_rec_index).message_text := fnd_message.get();
7103: END IF;
7104: IF BITAND(cr.error_number,G_ES_EXE_DFF_INVALID) <> 0 THEN
7105: l_rec_index := l_rec_index +1;
7106: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7109: l_error_table(l_rec_index).party_id := cr.party_id;
7110: l_error_table(l_rec_index).message_text := cr.prog_int_char1;
7111: END IF;
7112: IF BITAND(cr.error_number,G_ES_EXE_EXMPT_RSN_INVALID) <> 0 THEN
7113: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
7114: IF cr.exempt_reason_code IS NOT NULL THEN
7115: fnd_message.set_token('VALUE_NAME',cr.exempt_reason_code );
7116: fnd_message.set_token('COLUMN_NAME','EXEMPT_REASON_CODE' );
7117: ELSE
7111: END IF;
7112: IF BITAND(cr.error_number,G_ES_EXE_EXMPT_RSN_INVALID) <> 0 THEN
7113: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
7114: IF cr.exempt_reason_code IS NOT NULL THEN
7115: fnd_message.set_token('VALUE_NAME',cr.exempt_reason_code );
7116: fnd_message.set_token('COLUMN_NAME','EXEMPT_REASON_CODE' );
7117: ELSE
7118: fnd_message.set_token('VALUE_NAME',cr.exempt_reason_name );
7119: fnd_message.set_token('COLUMN_NAME','EXEMPT_REASON_NAME' );
7112: IF BITAND(cr.error_number,G_ES_EXE_EXMPT_RSN_INVALID) <> 0 THEN
7113: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
7114: IF cr.exempt_reason_code IS NOT NULL THEN
7115: fnd_message.set_token('VALUE_NAME',cr.exempt_reason_code );
7116: fnd_message.set_token('COLUMN_NAME','EXEMPT_REASON_CODE' );
7117: ELSE
7118: fnd_message.set_token('VALUE_NAME',cr.exempt_reason_name );
7119: fnd_message.set_token('COLUMN_NAME','EXEMPT_REASON_NAME' );
7120: END IF;
7114: IF cr.exempt_reason_code IS NOT NULL THEN
7115: fnd_message.set_token('VALUE_NAME',cr.exempt_reason_code );
7116: fnd_message.set_token('COLUMN_NAME','EXEMPT_REASON_CODE' );
7117: ELSE
7118: fnd_message.set_token('VALUE_NAME',cr.exempt_reason_name );
7119: fnd_message.set_token('COLUMN_NAME','EXEMPT_REASON_NAME' );
7120: END IF;
7121: l_rec_index := l_rec_index +1;
7122: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7115: fnd_message.set_token('VALUE_NAME',cr.exempt_reason_code );
7116: fnd_message.set_token('COLUMN_NAME','EXEMPT_REASON_CODE' );
7117: ELSE
7118: fnd_message.set_token('VALUE_NAME',cr.exempt_reason_name );
7119: fnd_message.set_token('COLUMN_NAME','EXEMPT_REASON_NAME' );
7120: END IF;
7121: l_rec_index := l_rec_index +1;
7122: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7123: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7122: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7123: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7124: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
7125: l_error_table(l_rec_index).party_id := cr.party_id;
7126: l_error_table(l_rec_index).message_text := fnd_message.get();
7127: END IF;
7128: IF BITAND(cr.error_number,G_ES_EXE_EXMPT_STS_INVALID) <> 0 THEN
7129: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
7130: IF cr.exemption_status_code IS NOT NULL THEN
7125: l_error_table(l_rec_index).party_id := cr.party_id;
7126: l_error_table(l_rec_index).message_text := fnd_message.get();
7127: END IF;
7128: IF BITAND(cr.error_number,G_ES_EXE_EXMPT_STS_INVALID) <> 0 THEN
7129: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
7130: IF cr.exemption_status_code IS NOT NULL THEN
7131: fnd_message.set_token('VALUE_NAME',cr.exemption_status_code );
7132: fnd_message.set_token('COLUMN_NAME','EXEMPTION_STATUS_CODE' );
7133: ELSE
7127: END IF;
7128: IF BITAND(cr.error_number,G_ES_EXE_EXMPT_STS_INVALID) <> 0 THEN
7129: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
7130: IF cr.exemption_status_code IS NOT NULL THEN
7131: fnd_message.set_token('VALUE_NAME',cr.exemption_status_code );
7132: fnd_message.set_token('COLUMN_NAME','EXEMPTION_STATUS_CODE' );
7133: ELSE
7134: fnd_message.set_token('VALUE_NAME',cr.exemption_status_name );
7135: fnd_message.set_token('COLUMN_NAME','EXEMPTION_STATUS_NAME' );
7128: IF BITAND(cr.error_number,G_ES_EXE_EXMPT_STS_INVALID) <> 0 THEN
7129: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
7130: IF cr.exemption_status_code IS NOT NULL THEN
7131: fnd_message.set_token('VALUE_NAME',cr.exemption_status_code );
7132: fnd_message.set_token('COLUMN_NAME','EXEMPTION_STATUS_CODE' );
7133: ELSE
7134: fnd_message.set_token('VALUE_NAME',cr.exemption_status_name );
7135: fnd_message.set_token('COLUMN_NAME','EXEMPTION_STATUS_NAME' );
7136: END IF;
7130: IF cr.exemption_status_code IS NOT NULL THEN
7131: fnd_message.set_token('VALUE_NAME',cr.exemption_status_code );
7132: fnd_message.set_token('COLUMN_NAME','EXEMPTION_STATUS_CODE' );
7133: ELSE
7134: fnd_message.set_token('VALUE_NAME',cr.exemption_status_name );
7135: fnd_message.set_token('COLUMN_NAME','EXEMPTION_STATUS_NAME' );
7136: END IF;
7137: l_rec_index := l_rec_index +1;
7138: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7131: fnd_message.set_token('VALUE_NAME',cr.exemption_status_code );
7132: fnd_message.set_token('COLUMN_NAME','EXEMPTION_STATUS_CODE' );
7133: ELSE
7134: fnd_message.set_token('VALUE_NAME',cr.exemption_status_name );
7135: fnd_message.set_token('COLUMN_NAME','EXEMPTION_STATUS_NAME' );
7136: END IF;
7137: l_rec_index := l_rec_index +1;
7138: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7139: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7138: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7139: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7140: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
7141: l_error_table(l_rec_index).party_id := cr.party_id;
7142: l_error_table(l_rec_index).message_text := fnd_message.get();
7143: END IF;
7144: IF BITAND(cr.error_number,G_ES_EXE_TAX_REG_INVALID) <> 0 THEN
7145: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
7146: IF cr.tax_regime_code IS NOT NULL THEN
7141: l_error_table(l_rec_index).party_id := cr.party_id;
7142: l_error_table(l_rec_index).message_text := fnd_message.get();
7143: END IF;
7144: IF BITAND(cr.error_number,G_ES_EXE_TAX_REG_INVALID) <> 0 THEN
7145: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
7146: IF cr.tax_regime_code IS NOT NULL THEN
7147: fnd_message.set_token('VALUE_NAME',cr.tax_regime_code );
7148: fnd_message.set_token('COLUMN_NAME','TAX_REGIME_CODE' );
7149: ELSE
7143: END IF;
7144: IF BITAND(cr.error_number,G_ES_EXE_TAX_REG_INVALID) <> 0 THEN
7145: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
7146: IF cr.tax_regime_code IS NOT NULL THEN
7147: fnd_message.set_token('VALUE_NAME',cr.tax_regime_code );
7148: fnd_message.set_token('COLUMN_NAME','TAX_REGIME_CODE' );
7149: ELSE
7150: fnd_message.set_token('VALUE_NAME',cr.tax_regime_name );
7151: fnd_message.set_token('COLUMN_NAME','TAX_REGIME_NAME' );
7144: IF BITAND(cr.error_number,G_ES_EXE_TAX_REG_INVALID) <> 0 THEN
7145: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
7146: IF cr.tax_regime_code IS NOT NULL THEN
7147: fnd_message.set_token('VALUE_NAME',cr.tax_regime_code );
7148: fnd_message.set_token('COLUMN_NAME','TAX_REGIME_CODE' );
7149: ELSE
7150: fnd_message.set_token('VALUE_NAME',cr.tax_regime_name );
7151: fnd_message.set_token('COLUMN_NAME','TAX_REGIME_NAME' );
7152: END IF;
7146: IF cr.tax_regime_code IS NOT NULL THEN
7147: fnd_message.set_token('VALUE_NAME',cr.tax_regime_code );
7148: fnd_message.set_token('COLUMN_NAME','TAX_REGIME_CODE' );
7149: ELSE
7150: fnd_message.set_token('VALUE_NAME',cr.tax_regime_name );
7151: fnd_message.set_token('COLUMN_NAME','TAX_REGIME_NAME' );
7152: END IF;
7153: l_rec_index := l_rec_index +1;
7154: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7147: fnd_message.set_token('VALUE_NAME',cr.tax_regime_code );
7148: fnd_message.set_token('COLUMN_NAME','TAX_REGIME_CODE' );
7149: ELSE
7150: fnd_message.set_token('VALUE_NAME',cr.tax_regime_name );
7151: fnd_message.set_token('COLUMN_NAME','TAX_REGIME_NAME' );
7152: END IF;
7153: l_rec_index := l_rec_index +1;
7154: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7155: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7154: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7155: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7156: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
7157: l_error_table(l_rec_index).party_id := cr.party_id;
7158: l_error_table(l_rec_index).message_text := fnd_message.get();
7159: END IF;
7160: IF BITAND(cr.error_number,G_ES_EXE_CNT_OWN_INVALID) <> 0 THEN
7161: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
7162: IF cr.content_owner_id IS NOT NULL THEN
7157: l_error_table(l_rec_index).party_id := cr.party_id;
7158: l_error_table(l_rec_index).message_text := fnd_message.get();
7159: END IF;
7160: IF BITAND(cr.error_number,G_ES_EXE_CNT_OWN_INVALID) <> 0 THEN
7161: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
7162: IF cr.content_owner_id IS NOT NULL THEN
7163: fnd_message.set_token('VALUE_NAME',cr.content_owner_id );
7164: fnd_message.set_token('COLUMN_NAME','CONTENT_OWNER_ID' );
7165: ELSE
7159: END IF;
7160: IF BITAND(cr.error_number,G_ES_EXE_CNT_OWN_INVALID) <> 0 THEN
7161: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
7162: IF cr.content_owner_id IS NOT NULL THEN
7163: fnd_message.set_token('VALUE_NAME',cr.content_owner_id );
7164: fnd_message.set_token('COLUMN_NAME','CONTENT_OWNER_ID' );
7165: ELSE
7166: fnd_message.set_token('VALUE_NAME',cr.content_owner_name );
7167: fnd_message.set_token('COLUMN_NAME','CONTENT_OWNER_NAME' );
7160: IF BITAND(cr.error_number,G_ES_EXE_CNT_OWN_INVALID) <> 0 THEN
7161: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
7162: IF cr.content_owner_id IS NOT NULL THEN
7163: fnd_message.set_token('VALUE_NAME',cr.content_owner_id );
7164: fnd_message.set_token('COLUMN_NAME','CONTENT_OWNER_ID' );
7165: ELSE
7166: fnd_message.set_token('VALUE_NAME',cr.content_owner_name );
7167: fnd_message.set_token('COLUMN_NAME','CONTENT_OWNER_NAME' );
7168: END IF;
7162: IF cr.content_owner_id IS NOT NULL THEN
7163: fnd_message.set_token('VALUE_NAME',cr.content_owner_id );
7164: fnd_message.set_token('COLUMN_NAME','CONTENT_OWNER_ID' );
7165: ELSE
7166: fnd_message.set_token('VALUE_NAME',cr.content_owner_name );
7167: fnd_message.set_token('COLUMN_NAME','CONTENT_OWNER_NAME' );
7168: END IF;
7169: l_rec_index := l_rec_index +1;
7170: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7163: fnd_message.set_token('VALUE_NAME',cr.content_owner_id );
7164: fnd_message.set_token('COLUMN_NAME','CONTENT_OWNER_ID' );
7165: ELSE
7166: fnd_message.set_token('VALUE_NAME',cr.content_owner_name );
7167: fnd_message.set_token('COLUMN_NAME','CONTENT_OWNER_NAME' );
7168: END IF;
7169: l_rec_index := l_rec_index +1;
7170: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7171: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7170: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7171: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7172: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
7173: l_error_table(l_rec_index).party_id := cr.party_id;
7174: l_error_table(l_rec_index).message_text := fnd_message.get();
7175: END IF;
7176: IF BITAND(cr.error_number,G_ES_EXE_TAX_PARAM_INVALID) <> 0 THEN
7177: fnd_message.set_name('ZX','ZX_BULK_TAX_INVALID');
7178: IF cr.tax_code IS NOT NULL THEN
7173: l_error_table(l_rec_index).party_id := cr.party_id;
7174: l_error_table(l_rec_index).message_text := fnd_message.get();
7175: END IF;
7176: IF BITAND(cr.error_number,G_ES_EXE_TAX_PARAM_INVALID) <> 0 THEN
7177: fnd_message.set_name('ZX','ZX_BULK_TAX_INVALID');
7178: IF cr.tax_code IS NOT NULL THEN
7179: fnd_message.set_token('TAX',cr.tax_code );
7180: ELSE
7181: fnd_message.set_token('TAX',cr.tax_name );
7175: END IF;
7176: IF BITAND(cr.error_number,G_ES_EXE_TAX_PARAM_INVALID) <> 0 THEN
7177: fnd_message.set_name('ZX','ZX_BULK_TAX_INVALID');
7178: IF cr.tax_code IS NOT NULL THEN
7179: fnd_message.set_token('TAX',cr.tax_code );
7180: ELSE
7181: fnd_message.set_token('TAX',cr.tax_name );
7182: END IF;
7183: IF cr.tax_regime_name IS NULL THEN
7177: fnd_message.set_name('ZX','ZX_BULK_TAX_INVALID');
7178: IF cr.tax_code IS NOT NULL THEN
7179: fnd_message.set_token('TAX',cr.tax_code );
7180: ELSE
7181: fnd_message.set_token('TAX',cr.tax_name );
7182: END IF;
7183: IF cr.tax_regime_name IS NULL THEN
7184: fnd_message.set_token('TAX_REGIME',cr.tax_regime_code );
7185: ELSE
7180: ELSE
7181: fnd_message.set_token('TAX',cr.tax_name );
7182: END IF;
7183: IF cr.tax_regime_name IS NULL THEN
7184: fnd_message.set_token('TAX_REGIME',cr.tax_regime_code );
7185: ELSE
7186: fnd_message.set_token('TAX_REGIME',cr.tax_regime_name );
7187: END IF;
7188: l_rec_index := l_rec_index +1;
7182: END IF;
7183: IF cr.tax_regime_name IS NULL THEN
7184: fnd_message.set_token('TAX_REGIME',cr.tax_regime_code );
7185: ELSE
7186: fnd_message.set_token('TAX_REGIME',cr.tax_regime_name );
7187: END IF;
7188: l_rec_index := l_rec_index +1;
7189: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7190: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7189: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7190: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7191: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
7192: l_error_table(l_rec_index).party_id := cr.party_id;
7193: l_error_table(l_rec_index).message_text := fnd_message.get();
7194: END IF;
7195: IF BITAND(cr.error_number,G_ES_EXE_TAX_STS_INVALID) <> 0 THEN
7196: fnd_message.set_name('ZX','ZX_BULK_TAX_STATUS_INVALID');
7197: IF cr.tax_status_code IS NOT NULL THEN
7192: l_error_table(l_rec_index).party_id := cr.party_id;
7193: l_error_table(l_rec_index).message_text := fnd_message.get();
7194: END IF;
7195: IF BITAND(cr.error_number,G_ES_EXE_TAX_STS_INVALID) <> 0 THEN
7196: fnd_message.set_name('ZX','ZX_BULK_TAX_STATUS_INVALID');
7197: IF cr.tax_status_code IS NOT NULL THEN
7198: fnd_message.set_token('TAX_STATUS',cr.tax_status_code );
7199: ELSE
7200: fnd_message.set_token('TAX_STATUS',cr.tax_status_name );
7194: END IF;
7195: IF BITAND(cr.error_number,G_ES_EXE_TAX_STS_INVALID) <> 0 THEN
7196: fnd_message.set_name('ZX','ZX_BULK_TAX_STATUS_INVALID');
7197: IF cr.tax_status_code IS NOT NULL THEN
7198: fnd_message.set_token('TAX_STATUS',cr.tax_status_code );
7199: ELSE
7200: fnd_message.set_token('TAX_STATUS',cr.tax_status_name );
7201: END IF;
7202: IF cr.tax_regime_name IS NULL THEN
7196: fnd_message.set_name('ZX','ZX_BULK_TAX_STATUS_INVALID');
7197: IF cr.tax_status_code IS NOT NULL THEN
7198: fnd_message.set_token('TAX_STATUS',cr.tax_status_code );
7199: ELSE
7200: fnd_message.set_token('TAX_STATUS',cr.tax_status_name );
7201: END IF;
7202: IF cr.tax_regime_name IS NULL THEN
7203: fnd_message.set_token('TAX_REGIME',cr.tax_regime_code );
7204: ELSE
7199: ELSE
7200: fnd_message.set_token('TAX_STATUS',cr.tax_status_name );
7201: END IF;
7202: IF cr.tax_regime_name IS NULL THEN
7203: fnd_message.set_token('TAX_REGIME',cr.tax_regime_code );
7204: ELSE
7205: fnd_message.set_token('TAX_REGIME',cr.tax_regime_name );
7206: END IF;
7207: IF cr.tax_name IS NULL THEN
7201: END IF;
7202: IF cr.tax_regime_name IS NULL THEN
7203: fnd_message.set_token('TAX_REGIME',cr.tax_regime_code );
7204: ELSE
7205: fnd_message.set_token('TAX_REGIME',cr.tax_regime_name );
7206: END IF;
7207: IF cr.tax_name IS NULL THEN
7208: fnd_message.set_token('TAX',cr.tax_code );
7209: ELSE
7204: ELSE
7205: fnd_message.set_token('TAX_REGIME',cr.tax_regime_name );
7206: END IF;
7207: IF cr.tax_name IS NULL THEN
7208: fnd_message.set_token('TAX',cr.tax_code );
7209: ELSE
7210: fnd_message.set_token('TAX',cr.tax_name );
7211: END IF;
7212: l_rec_index := l_rec_index +1;
7206: END IF;
7207: IF cr.tax_name IS NULL THEN
7208: fnd_message.set_token('TAX',cr.tax_code );
7209: ELSE
7210: fnd_message.set_token('TAX',cr.tax_name );
7211: END IF;
7212: l_rec_index := l_rec_index +1;
7213: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7214: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7213: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7214: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7215: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
7216: l_error_table(l_rec_index).party_id := cr.party_id;
7217: l_error_table(l_rec_index).message_text := fnd_message.get();
7218: END IF;
7219: IF BITAND(cr.error_number,G_ES_EXE_TAX_JUR_INVALID) <> 0 THEN
7220: fnd_message.set_name('ZX','ZX_BULK_TAX_JUR_INVALID');
7221: IF cr.tax_jurisdiction_id IS NOT NULL THEN
7216: l_error_table(l_rec_index).party_id := cr.party_id;
7217: l_error_table(l_rec_index).message_text := fnd_message.get();
7218: END IF;
7219: IF BITAND(cr.error_number,G_ES_EXE_TAX_JUR_INVALID) <> 0 THEN
7220: fnd_message.set_name('ZX','ZX_BULK_TAX_JUR_INVALID');
7221: IF cr.tax_jurisdiction_id IS NOT NULL THEN
7222: fnd_message.set_token('TAX_JURISDICTION',cr.tax_jurisdiction_id );
7223: ELSE
7224: fnd_message.set_token('TAX_JURISDICTION',cr.tax_jurisdiction_name );
7218: END IF;
7219: IF BITAND(cr.error_number,G_ES_EXE_TAX_JUR_INVALID) <> 0 THEN
7220: fnd_message.set_name('ZX','ZX_BULK_TAX_JUR_INVALID');
7221: IF cr.tax_jurisdiction_id IS NOT NULL THEN
7222: fnd_message.set_token('TAX_JURISDICTION',cr.tax_jurisdiction_id );
7223: ELSE
7224: fnd_message.set_token('TAX_JURISDICTION',cr.tax_jurisdiction_name );
7225: END IF;
7226: IF cr.tax_name IS NULL THEN
7220: fnd_message.set_name('ZX','ZX_BULK_TAX_JUR_INVALID');
7221: IF cr.tax_jurisdiction_id IS NOT NULL THEN
7222: fnd_message.set_token('TAX_JURISDICTION',cr.tax_jurisdiction_id );
7223: ELSE
7224: fnd_message.set_token('TAX_JURISDICTION',cr.tax_jurisdiction_name );
7225: END IF;
7226: IF cr.tax_name IS NULL THEN
7227: fnd_message.set_token('TAX',cr.tax_code );
7228: ELSE
7223: ELSE
7224: fnd_message.set_token('TAX_JURISDICTION',cr.tax_jurisdiction_name );
7225: END IF;
7226: IF cr.tax_name IS NULL THEN
7227: fnd_message.set_token('TAX',cr.tax_code );
7228: ELSE
7229: fnd_message.set_token('TAX',cr.tax_name );
7230: END IF;
7231: IF cr.tax_regime_name IS NULL THEN
7225: END IF;
7226: IF cr.tax_name IS NULL THEN
7227: fnd_message.set_token('TAX',cr.tax_code );
7228: ELSE
7229: fnd_message.set_token('TAX',cr.tax_name );
7230: END IF;
7231: IF cr.tax_regime_name IS NULL THEN
7232: fnd_message.set_token('TAX_REGIME',cr.tax_regime_code );
7233: ELSE
7228: ELSE
7229: fnd_message.set_token('TAX',cr.tax_name );
7230: END IF;
7231: IF cr.tax_regime_name IS NULL THEN
7232: fnd_message.set_token('TAX_REGIME',cr.tax_regime_code );
7233: ELSE
7234: fnd_message.set_token('TAX_REGIME',cr.tax_regime_name );
7235: END IF;
7236: l_rec_index := l_rec_index +1;
7230: END IF;
7231: IF cr.tax_regime_name IS NULL THEN
7232: fnd_message.set_token('TAX_REGIME',cr.tax_regime_code );
7233: ELSE
7234: fnd_message.set_token('TAX_REGIME',cr.tax_regime_name );
7235: END IF;
7236: l_rec_index := l_rec_index +1;
7237: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7238: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7237: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7238: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7239: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
7240: l_error_table(l_rec_index).party_id := cr.party_id;
7241: l_error_table(l_rec_index).message_text := fnd_message.get();
7242: END IF;
7243: IF BITAND(cr.error_number,G_ES_EXE_TAX_RATE_INVALID) <> 0 THEN
7244: fnd_message.set_name('ZX','ZX_BULK_TAX_RATE_INVALID');
7245: IF cr.tax_rate_code IS NOT NULL THEN
7240: l_error_table(l_rec_index).party_id := cr.party_id;
7241: l_error_table(l_rec_index).message_text := fnd_message.get();
7242: END IF;
7243: IF BITAND(cr.error_number,G_ES_EXE_TAX_RATE_INVALID) <> 0 THEN
7244: fnd_message.set_name('ZX','ZX_BULK_TAX_RATE_INVALID');
7245: IF cr.tax_rate_code IS NOT NULL THEN
7246: fnd_message.set_token('TAX_RATE',cr.tax_rate_code );
7247: ELSE
7248: fnd_message.set_token('TAX_RATE',cr.tax_rate_name );
7242: END IF;
7243: IF BITAND(cr.error_number,G_ES_EXE_TAX_RATE_INVALID) <> 0 THEN
7244: fnd_message.set_name('ZX','ZX_BULK_TAX_RATE_INVALID');
7245: IF cr.tax_rate_code IS NOT NULL THEN
7246: fnd_message.set_token('TAX_RATE',cr.tax_rate_code );
7247: ELSE
7248: fnd_message.set_token('TAX_RATE',cr.tax_rate_name );
7249: END IF;
7250: IF cr.tax_regime_name IS NULL THEN
7244: fnd_message.set_name('ZX','ZX_BULK_TAX_RATE_INVALID');
7245: IF cr.tax_rate_code IS NOT NULL THEN
7246: fnd_message.set_token('TAX_RATE',cr.tax_rate_code );
7247: ELSE
7248: fnd_message.set_token('TAX_RATE',cr.tax_rate_name );
7249: END IF;
7250: IF cr.tax_regime_name IS NULL THEN
7251: fnd_message.set_token('TAX_REGIME',cr.tax_regime_code );
7252: ELSE
7247: ELSE
7248: fnd_message.set_token('TAX_RATE',cr.tax_rate_name );
7249: END IF;
7250: IF cr.tax_regime_name IS NULL THEN
7251: fnd_message.set_token('TAX_REGIME',cr.tax_regime_code );
7252: ELSE
7253: fnd_message.set_token('TAX_REGIME',cr.tax_regime_name );
7254: END IF;
7255: IF cr.tax_name IS NULL THEN
7249: END IF;
7250: IF cr.tax_regime_name IS NULL THEN
7251: fnd_message.set_token('TAX_REGIME',cr.tax_regime_code );
7252: ELSE
7253: fnd_message.set_token('TAX_REGIME',cr.tax_regime_name );
7254: END IF;
7255: IF cr.tax_name IS NULL THEN
7256: fnd_message.set_token('TAX',cr.tax_code );
7257: ELSE
7252: ELSE
7253: fnd_message.set_token('TAX_REGIME',cr.tax_regime_name );
7254: END IF;
7255: IF cr.tax_name IS NULL THEN
7256: fnd_message.set_token('TAX',cr.tax_code );
7257: ELSE
7258: fnd_message.set_token('TAX',cr.tax_name );
7259: END IF;
7260: IF cr.tax_status_name IS NULL THEN
7254: END IF;
7255: IF cr.tax_name IS NULL THEN
7256: fnd_message.set_token('TAX',cr.tax_code );
7257: ELSE
7258: fnd_message.set_token('TAX',cr.tax_name );
7259: END IF;
7260: IF cr.tax_status_name IS NULL THEN
7261: fnd_message.set_token('TAX_STATUS',cr.tax_status_code );
7262: ELSE
7257: ELSE
7258: fnd_message.set_token('TAX',cr.tax_name );
7259: END IF;
7260: IF cr.tax_status_name IS NULL THEN
7261: fnd_message.set_token('TAX_STATUS',cr.tax_status_code );
7262: ELSE
7263: fnd_message.set_token('TAX_STATUS',cr.tax_status_name );
7264: END IF;
7265: IF cr.tax_jurisdiction_name IS NULL THEN
7259: END IF;
7260: IF cr.tax_status_name IS NULL THEN
7261: fnd_message.set_token('TAX_STATUS',cr.tax_status_code );
7262: ELSE
7263: fnd_message.set_token('TAX_STATUS',cr.tax_status_name );
7264: END IF;
7265: IF cr.tax_jurisdiction_name IS NULL THEN
7266: fnd_message.set_token('TAX_JURISDICTION',cr.tax_jurisdiction_id );
7267: ELSE
7262: ELSE
7263: fnd_message.set_token('TAX_STATUS',cr.tax_status_name );
7264: END IF;
7265: IF cr.tax_jurisdiction_name IS NULL THEN
7266: fnd_message.set_token('TAX_JURISDICTION',cr.tax_jurisdiction_id );
7267: ELSE
7268: fnd_message.set_token('TAX_JURISDICTION',cr.tax_jurisdiction_name );
7269: END IF;
7270: l_rec_index := l_rec_index +1;
7264: END IF;
7265: IF cr.tax_jurisdiction_name IS NULL THEN
7266: fnd_message.set_token('TAX_JURISDICTION',cr.tax_jurisdiction_id );
7267: ELSE
7268: fnd_message.set_token('TAX_JURISDICTION',cr.tax_jurisdiction_name );
7269: END IF;
7270: l_rec_index := l_rec_index +1;
7271: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7272: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7271: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7272: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7273: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
7274: l_error_table(l_rec_index).party_id := cr.party_id;
7275: l_error_table(l_rec_index).message_text := fnd_message.get();
7276: END IF;
7277: IF BITAND(cr.error_number,G_ES_EXE_LWR_LVL_FLG_INVALID) <> 0 THEN
7278: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
7279: fnd_message.set_token('VALUE_NAME',cr.apply_to_lower_levels_flag );
7274: l_error_table(l_rec_index).party_id := cr.party_id;
7275: l_error_table(l_rec_index).message_text := fnd_message.get();
7276: END IF;
7277: IF BITAND(cr.error_number,G_ES_EXE_LWR_LVL_FLG_INVALID) <> 0 THEN
7278: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
7279: fnd_message.set_token('VALUE_NAME',cr.apply_to_lower_levels_flag );
7280: fnd_message.set_token('COLUMN_NAME','APPLY_TO_LOWER_LEVELS_FLAG' );
7281: l_rec_index := l_rec_index +1;
7282: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7275: l_error_table(l_rec_index).message_text := fnd_message.get();
7276: END IF;
7277: IF BITAND(cr.error_number,G_ES_EXE_LWR_LVL_FLG_INVALID) <> 0 THEN
7278: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
7279: fnd_message.set_token('VALUE_NAME',cr.apply_to_lower_levels_flag );
7280: fnd_message.set_token('COLUMN_NAME','APPLY_TO_LOWER_LEVELS_FLAG' );
7281: l_rec_index := l_rec_index +1;
7282: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7283: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7276: END IF;
7277: IF BITAND(cr.error_number,G_ES_EXE_LWR_LVL_FLG_INVALID) <> 0 THEN
7278: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
7279: fnd_message.set_token('VALUE_NAME',cr.apply_to_lower_levels_flag );
7280: fnd_message.set_token('COLUMN_NAME','APPLY_TO_LOWER_LEVELS_FLAG' );
7281: l_rec_index := l_rec_index +1;
7282: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7283: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7284: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
7282: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7283: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7284: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
7285: l_error_table(l_rec_index).party_id := cr.party_id;
7286: l_error_table(l_rec_index).message_text := fnd_message.get();
7287: END IF;
7288: IF BITAND(cr.error_number,G_ES_EXE_INV_ORG_INVALID) <> 0 THEN
7289: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
7290: IF cr.inventory_org_id IS NOT NULL THEN
7285: l_error_table(l_rec_index).party_id := cr.party_id;
7286: l_error_table(l_rec_index).message_text := fnd_message.get();
7287: END IF;
7288: IF BITAND(cr.error_number,G_ES_EXE_INV_ORG_INVALID) <> 0 THEN
7289: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
7290: IF cr.inventory_org_id IS NOT NULL THEN
7291: fnd_message.set_token('VALUE_NAME',cr.inventory_org_id );
7292: fnd_message.set_token('COLUMN_NAME','INVENTORY_ORG_ID' );
7293: ELSE
7287: END IF;
7288: IF BITAND(cr.error_number,G_ES_EXE_INV_ORG_INVALID) <> 0 THEN
7289: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
7290: IF cr.inventory_org_id IS NOT NULL THEN
7291: fnd_message.set_token('VALUE_NAME',cr.inventory_org_id );
7292: fnd_message.set_token('COLUMN_NAME','INVENTORY_ORG_ID' );
7293: ELSE
7294: fnd_message.set_token('VALUE_NAME',cr.inventory_org_name );
7295: fnd_message.set_token('COLUMN_NAME','INVENTORY_ORG_NAME' );
7288: IF BITAND(cr.error_number,G_ES_EXE_INV_ORG_INVALID) <> 0 THEN
7289: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
7290: IF cr.inventory_org_id IS NOT NULL THEN
7291: fnd_message.set_token('VALUE_NAME',cr.inventory_org_id );
7292: fnd_message.set_token('COLUMN_NAME','INVENTORY_ORG_ID' );
7293: ELSE
7294: fnd_message.set_token('VALUE_NAME',cr.inventory_org_name );
7295: fnd_message.set_token('COLUMN_NAME','INVENTORY_ORG_NAME' );
7296: END IF;
7290: IF cr.inventory_org_id IS NOT NULL THEN
7291: fnd_message.set_token('VALUE_NAME',cr.inventory_org_id );
7292: fnd_message.set_token('COLUMN_NAME','INVENTORY_ORG_ID' );
7293: ELSE
7294: fnd_message.set_token('VALUE_NAME',cr.inventory_org_name );
7295: fnd_message.set_token('COLUMN_NAME','INVENTORY_ORG_NAME' );
7296: END IF;
7297: l_rec_index := l_rec_index +1;
7298: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7291: fnd_message.set_token('VALUE_NAME',cr.inventory_org_id );
7292: fnd_message.set_token('COLUMN_NAME','INVENTORY_ORG_ID' );
7293: ELSE
7294: fnd_message.set_token('VALUE_NAME',cr.inventory_org_name );
7295: fnd_message.set_token('COLUMN_NAME','INVENTORY_ORG_NAME' );
7296: END IF;
7297: l_rec_index := l_rec_index +1;
7298: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7299: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7298: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7299: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7300: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
7301: l_error_table(l_rec_index).party_id := cr.party_id;
7302: l_error_table(l_rec_index).message_text := fnd_message.get();
7303: END IF;
7304: IF BITAND(cr.error_number,G_ES_EXE_INV_ITM_INVALID) <> 0 THEN
7305: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
7306: IF cr.inventory_item_id IS NOT NULL THEN
7301: l_error_table(l_rec_index).party_id := cr.party_id;
7302: l_error_table(l_rec_index).message_text := fnd_message.get();
7303: END IF;
7304: IF BITAND(cr.error_number,G_ES_EXE_INV_ITM_INVALID) <> 0 THEN
7305: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
7306: IF cr.inventory_item_id IS NOT NULL THEN
7307: fnd_message.set_token('VALUE_NAME',cr.inventory_item_id );
7308: fnd_message.set_token('COLUMN_NAME','inventory_item_id' );
7309: ELSE
7303: END IF;
7304: IF BITAND(cr.error_number,G_ES_EXE_INV_ITM_INVALID) <> 0 THEN
7305: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
7306: IF cr.inventory_item_id IS NOT NULL THEN
7307: fnd_message.set_token('VALUE_NAME',cr.inventory_item_id );
7308: fnd_message.set_token('COLUMN_NAME','inventory_item_id' );
7309: ELSE
7310: fnd_message.set_token('VALUE_NAME',cr.Item_number );
7311: fnd_message.set_token('COLUMN_NAME','ITEM_NUMBER' );
7304: IF BITAND(cr.error_number,G_ES_EXE_INV_ITM_INVALID) <> 0 THEN
7305: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
7306: IF cr.inventory_item_id IS NOT NULL THEN
7307: fnd_message.set_token('VALUE_NAME',cr.inventory_item_id );
7308: fnd_message.set_token('COLUMN_NAME','inventory_item_id' );
7309: ELSE
7310: fnd_message.set_token('VALUE_NAME',cr.Item_number );
7311: fnd_message.set_token('COLUMN_NAME','ITEM_NUMBER' );
7312: END IF;
7306: IF cr.inventory_item_id IS NOT NULL THEN
7307: fnd_message.set_token('VALUE_NAME',cr.inventory_item_id );
7308: fnd_message.set_token('COLUMN_NAME','inventory_item_id' );
7309: ELSE
7310: fnd_message.set_token('VALUE_NAME',cr.Item_number );
7311: fnd_message.set_token('COLUMN_NAME','ITEM_NUMBER' );
7312: END IF;
7313: l_rec_index := l_rec_index +1;
7314: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7307: fnd_message.set_token('VALUE_NAME',cr.inventory_item_id );
7308: fnd_message.set_token('COLUMN_NAME','inventory_item_id' );
7309: ELSE
7310: fnd_message.set_token('VALUE_NAME',cr.Item_number );
7311: fnd_message.set_token('COLUMN_NAME','ITEM_NUMBER' );
7312: END IF;
7313: l_rec_index := l_rec_index +1;
7314: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7315: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7314: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7315: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7316: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
7317: l_error_table(l_rec_index).party_id := cr.party_id;
7318: l_error_table(l_rec_index).message_text := fnd_message.get();
7319: END IF;
7320: IF BITAND(cr.error_number,G_ES_EXE_TAX_AUT_INVALID) <> 0 THEN
7321: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
7322: IF cr.issuing_tax_authority_id IS NOT NULL THEN
7317: l_error_table(l_rec_index).party_id := cr.party_id;
7318: l_error_table(l_rec_index).message_text := fnd_message.get();
7319: END IF;
7320: IF BITAND(cr.error_number,G_ES_EXE_TAX_AUT_INVALID) <> 0 THEN
7321: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
7322: IF cr.issuing_tax_authority_id IS NOT NULL THEN
7323: fnd_message.set_token('VALUE_NAME',cr.issuing_tax_authority_id );
7324: fnd_message.set_token('COLUMN_NAME','issuing_tax_authority_id' );
7325: ELSE
7319: END IF;
7320: IF BITAND(cr.error_number,G_ES_EXE_TAX_AUT_INVALID) <> 0 THEN
7321: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
7322: IF cr.issuing_tax_authority_id IS NOT NULL THEN
7323: fnd_message.set_token('VALUE_NAME',cr.issuing_tax_authority_id );
7324: fnd_message.set_token('COLUMN_NAME','issuing_tax_authority_id' );
7325: ELSE
7326: fnd_message.set_token('VALUE_NAME',cr.issuing_tax_authority_name );
7327: fnd_message.set_token('COLUMN_NAME','issuing_tax_authority_name' );
7320: IF BITAND(cr.error_number,G_ES_EXE_TAX_AUT_INVALID) <> 0 THEN
7321: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
7322: IF cr.issuing_tax_authority_id IS NOT NULL THEN
7323: fnd_message.set_token('VALUE_NAME',cr.issuing_tax_authority_id );
7324: fnd_message.set_token('COLUMN_NAME','issuing_tax_authority_id' );
7325: ELSE
7326: fnd_message.set_token('VALUE_NAME',cr.issuing_tax_authority_name );
7327: fnd_message.set_token('COLUMN_NAME','issuing_tax_authority_name' );
7328: END IF;
7322: IF cr.issuing_tax_authority_id IS NOT NULL THEN
7323: fnd_message.set_token('VALUE_NAME',cr.issuing_tax_authority_id );
7324: fnd_message.set_token('COLUMN_NAME','issuing_tax_authority_id' );
7325: ELSE
7326: fnd_message.set_token('VALUE_NAME',cr.issuing_tax_authority_name );
7327: fnd_message.set_token('COLUMN_NAME','issuing_tax_authority_name' );
7328: END IF;
7329: l_rec_index := l_rec_index +1;
7330: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7323: fnd_message.set_token('VALUE_NAME',cr.issuing_tax_authority_id );
7324: fnd_message.set_token('COLUMN_NAME','issuing_tax_authority_id' );
7325: ELSE
7326: fnd_message.set_token('VALUE_NAME',cr.issuing_tax_authority_name );
7327: fnd_message.set_token('COLUMN_NAME','issuing_tax_authority_name' );
7328: END IF;
7329: l_rec_index := l_rec_index +1;
7330: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7331: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7330: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7331: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7332: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
7333: l_error_table(l_rec_index).party_id := cr.party_id;
7334: l_error_table(l_rec_index).message_text := fnd_message.get();
7335: END IF;
7336: IF BITAND(cr.error_number,G_ES_EXE_EXMPT_TYP_INVALID) <> 0 THEN
7337: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
7338: IF cr.exemption_type_code IS NOT NULL THEN
7333: l_error_table(l_rec_index).party_id := cr.party_id;
7334: l_error_table(l_rec_index).message_text := fnd_message.get();
7335: END IF;
7336: IF BITAND(cr.error_number,G_ES_EXE_EXMPT_TYP_INVALID) <> 0 THEN
7337: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
7338: IF cr.exemption_type_code IS NOT NULL THEN
7339: fnd_message.set_token('VALUE_NAME',cr.exemption_type_code );
7340: fnd_message.set_token('COLUMN_NAME','EXEMPTION_TYPE_CODE' );
7341: ELSE
7335: END IF;
7336: IF BITAND(cr.error_number,G_ES_EXE_EXMPT_TYP_INVALID) <> 0 THEN
7337: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
7338: IF cr.exemption_type_code IS NOT NULL THEN
7339: fnd_message.set_token('VALUE_NAME',cr.exemption_type_code );
7340: fnd_message.set_token('COLUMN_NAME','EXEMPTION_TYPE_CODE' );
7341: ELSE
7342: fnd_message.set_token('VALUE_NAME',cr.exemption_type_name );
7343: fnd_message.set_token('COLUMN_NAME','EXEMPTION_TYPE_NAME' );
7336: IF BITAND(cr.error_number,G_ES_EXE_EXMPT_TYP_INVALID) <> 0 THEN
7337: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
7338: IF cr.exemption_type_code IS NOT NULL THEN
7339: fnd_message.set_token('VALUE_NAME',cr.exemption_type_code );
7340: fnd_message.set_token('COLUMN_NAME','EXEMPTION_TYPE_CODE' );
7341: ELSE
7342: fnd_message.set_token('VALUE_NAME',cr.exemption_type_name );
7343: fnd_message.set_token('COLUMN_NAME','EXEMPTION_TYPE_NAME' );
7344: END IF;
7338: IF cr.exemption_type_code IS NOT NULL THEN
7339: fnd_message.set_token('VALUE_NAME',cr.exemption_type_code );
7340: fnd_message.set_token('COLUMN_NAME','EXEMPTION_TYPE_CODE' );
7341: ELSE
7342: fnd_message.set_token('VALUE_NAME',cr.exemption_type_name );
7343: fnd_message.set_token('COLUMN_NAME','EXEMPTION_TYPE_NAME' );
7344: END IF;
7345: l_rec_index := l_rec_index +1;
7346: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7339: fnd_message.set_token('VALUE_NAME',cr.exemption_type_code );
7340: fnd_message.set_token('COLUMN_NAME','EXEMPTION_TYPE_CODE' );
7341: ELSE
7342: fnd_message.set_token('VALUE_NAME',cr.exemption_type_name );
7343: fnd_message.set_token('COLUMN_NAME','EXEMPTION_TYPE_NAME' );
7344: END IF;
7345: l_rec_index := l_rec_index +1;
7346: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7347: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7346: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7347: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7348: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
7349: l_error_table(l_rec_index).party_id := cr.party_id;
7350: l_error_table(l_rec_index).message_text := fnd_message.get();
7351: END IF;
7352: IF BITAND(cr.error_number,G_ES_EXE_DATE_OVERLAP) <> 0 THEN
7353: fnd_message.set_name('ZX','ZX_PERIOD_OVERLAP');
7354: l_rec_index := l_rec_index +1;
7349: l_error_table(l_rec_index).party_id := cr.party_id;
7350: l_error_table(l_rec_index).message_text := fnd_message.get();
7351: END IF;
7352: IF BITAND(cr.error_number,G_ES_EXE_DATE_OVERLAP) <> 0 THEN
7353: fnd_message.set_name('ZX','ZX_PERIOD_OVERLAP');
7354: l_rec_index := l_rec_index +1;
7355: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7356: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7357: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
7355: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7356: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7357: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
7358: l_error_table(l_rec_index).party_id := cr.party_id;
7359: l_error_table(l_rec_index).message_text := fnd_message.get();
7360: END IF;
7361:
7362: FOR loop_index IN NVL(l_error_table.FIRST,0)..NVL(l_error_table.LAST,-1) LOOP
7363: INSERT INTO zx_errors_int
7391: --
7392: l_rec_index := 0;
7393: FOR cr in c_rca_errors LOOP
7394: IF BITAND(cr.error_number,G_ES_RCA_MAND_PARAM_MISSING) <> 0 THEN
7395: fnd_message.set_name('ZX','ZX_INTF_MAND_VALUE_MISSING');
7396: l_rec_index := l_rec_index +1;
7397: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7398: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7399: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
7397: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7398: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7399: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
7400: l_error_table(l_rec_index).party_id := cr.party_id;
7401: l_error_table(l_rec_index).message_text := fnd_message.get();
7402: END IF;
7403: IF BITAND(cr.error_number,G_ES_RCA_DUP_INTF_RECORD) <> 0 THEN
7404: fnd_message.set_name('ZX','ZX_BULK_DUP_RCA_REF');
7405: l_rec_index := l_rec_index +1;
7400: l_error_table(l_rec_index).party_id := cr.party_id;
7401: l_error_table(l_rec_index).message_text := fnd_message.get();
7402: END IF;
7403: IF BITAND(cr.error_number,G_ES_RCA_DUP_INTF_RECORD) <> 0 THEN
7404: fnd_message.set_name('ZX','ZX_BULK_DUP_RCA_REF');
7405: l_rec_index := l_rec_index +1;
7406: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7407: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7408: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
7406: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7407: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7408: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
7409: l_error_table(l_rec_index).party_id := cr.party_id;
7410: l_error_table(l_rec_index).message_text := fnd_message.get();
7411: END IF;
7412: IF BITAND(cr.error_number,G_ES_RCA_TRANS_TYPE_INVALID) <> 0 THEN
7413: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
7414: fnd_message.set_token('VALUE_NAME',cr.dml_type );
7409: l_error_table(l_rec_index).party_id := cr.party_id;
7410: l_error_table(l_rec_index).message_text := fnd_message.get();
7411: END IF;
7412: IF BITAND(cr.error_number,G_ES_RCA_TRANS_TYPE_INVALID) <> 0 THEN
7413: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
7414: fnd_message.set_token('VALUE_NAME',cr.dml_type );
7415: fnd_message.set_token('COLUMN_NAME','DML_TYPE' );
7416: l_rec_index := l_rec_index +1;
7417: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7410: l_error_table(l_rec_index).message_text := fnd_message.get();
7411: END IF;
7412: IF BITAND(cr.error_number,G_ES_RCA_TRANS_TYPE_INVALID) <> 0 THEN
7413: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
7414: fnd_message.set_token('VALUE_NAME',cr.dml_type );
7415: fnd_message.set_token('COLUMN_NAME','DML_TYPE' );
7416: l_rec_index := l_rec_index +1;
7417: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7418: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7411: END IF;
7412: IF BITAND(cr.error_number,G_ES_RCA_TRANS_TYPE_INVALID) <> 0 THEN
7413: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
7414: fnd_message.set_token('VALUE_NAME',cr.dml_type );
7415: fnd_message.set_token('COLUMN_NAME','DML_TYPE' );
7416: l_rec_index := l_rec_index +1;
7417: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7418: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7419: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
7417: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7418: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7419: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
7420: l_error_table(l_rec_index).party_id := cr.party_id;
7421: l_error_table(l_rec_index).message_text := fnd_message.get();
7422: END IF;
7423: IF BITAND(cr.error_number,G_ES_RCA_ENTY_CD_INVALID) <> 0 THEN
7424: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
7425: fnd_message.set_token('VALUE_NAME',cr.entity_code );
7420: l_error_table(l_rec_index).party_id := cr.party_id;
7421: l_error_table(l_rec_index).message_text := fnd_message.get();
7422: END IF;
7423: IF BITAND(cr.error_number,G_ES_RCA_ENTY_CD_INVALID) <> 0 THEN
7424: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
7425: fnd_message.set_token('VALUE_NAME',cr.entity_code );
7426: fnd_message.set_token('COLUMN_NAME','ENTITY_CODE' );
7427: l_rec_index := l_rec_index +1;
7428: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7421: l_error_table(l_rec_index).message_text := fnd_message.get();
7422: END IF;
7423: IF BITAND(cr.error_number,G_ES_RCA_ENTY_CD_INVALID) <> 0 THEN
7424: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
7425: fnd_message.set_token('VALUE_NAME',cr.entity_code );
7426: fnd_message.set_token('COLUMN_NAME','ENTITY_CODE' );
7427: l_rec_index := l_rec_index +1;
7428: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7429: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7422: END IF;
7423: IF BITAND(cr.error_number,G_ES_RCA_ENTY_CD_INVALID) <> 0 THEN
7424: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
7425: fnd_message.set_token('VALUE_NAME',cr.entity_code );
7426: fnd_message.set_token('COLUMN_NAME','ENTITY_CODE' );
7427: l_rec_index := l_rec_index +1;
7428: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7429: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7430: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
7428: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7429: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7430: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
7431: l_error_table(l_rec_index).party_id := cr.party_id;
7432: l_error_table(l_rec_index).message_text := fnd_message.get();
7433: END IF;
7434: IF BITAND(cr.error_number,G_ES_RCA_DATE_RANGE_INVALID) <> 0 THEN
7435: fnd_message.set_name('ZX','ZX_DATE_RANGE_INVALID');
7436: l_rec_index := l_rec_index +1;
7431: l_error_table(l_rec_index).party_id := cr.party_id;
7432: l_error_table(l_rec_index).message_text := fnd_message.get();
7433: END IF;
7434: IF BITAND(cr.error_number,G_ES_RCA_DATE_RANGE_INVALID) <> 0 THEN
7435: fnd_message.set_name('ZX','ZX_DATE_RANGE_INVALID');
7436: l_rec_index := l_rec_index +1;
7437: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7438: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7439: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
7437: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7438: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7439: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
7440: l_error_table(l_rec_index).party_id := cr.party_id;
7441: l_error_table(l_rec_index).message_text := fnd_message.get();
7442: END IF;
7443: IF BITAND(cr.error_number,G_ES_RCA_REP_TYPE_INVALID) <> 0 THEN
7444: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
7445: IF cr.reporting_type_id IS NOT NULL THEN
7440: l_error_table(l_rec_index).party_id := cr.party_id;
7441: l_error_table(l_rec_index).message_text := fnd_message.get();
7442: END IF;
7443: IF BITAND(cr.error_number,G_ES_RCA_REP_TYPE_INVALID) <> 0 THEN
7444: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
7445: IF cr.reporting_type_id IS NOT NULL THEN
7446: fnd_message.set_token('VALUE_NAME',cr.reporting_type_id );
7447: fnd_message.set_token('COLUMN_NAME','REPORTING_TYPE_ID' );
7448: ELSE
7442: END IF;
7443: IF BITAND(cr.error_number,G_ES_RCA_REP_TYPE_INVALID) <> 0 THEN
7444: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
7445: IF cr.reporting_type_id IS NOT NULL THEN
7446: fnd_message.set_token('VALUE_NAME',cr.reporting_type_id );
7447: fnd_message.set_token('COLUMN_NAME','REPORTING_TYPE_ID' );
7448: ELSE
7449: fnd_message.set_token('VALUE_NAME',cr.reporting_type_name );
7450: fnd_message.set_token('COLUMN_NAME','REPORTING_TYPE_NAME' );
7443: IF BITAND(cr.error_number,G_ES_RCA_REP_TYPE_INVALID) <> 0 THEN
7444: fnd_message.set_name('ZX','ZX_BULK_INVALID_VALUE');
7445: IF cr.reporting_type_id IS NOT NULL THEN
7446: fnd_message.set_token('VALUE_NAME',cr.reporting_type_id );
7447: fnd_message.set_token('COLUMN_NAME','REPORTING_TYPE_ID' );
7448: ELSE
7449: fnd_message.set_token('VALUE_NAME',cr.reporting_type_name );
7450: fnd_message.set_token('COLUMN_NAME','REPORTING_TYPE_NAME' );
7451: END IF;
7445: IF cr.reporting_type_id IS NOT NULL THEN
7446: fnd_message.set_token('VALUE_NAME',cr.reporting_type_id );
7447: fnd_message.set_token('COLUMN_NAME','REPORTING_TYPE_ID' );
7448: ELSE
7449: fnd_message.set_token('VALUE_NAME',cr.reporting_type_name );
7450: fnd_message.set_token('COLUMN_NAME','REPORTING_TYPE_NAME' );
7451: END IF;
7452: l_rec_index := l_rec_index +1;
7453: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7446: fnd_message.set_token('VALUE_NAME',cr.reporting_type_id );
7447: fnd_message.set_token('COLUMN_NAME','REPORTING_TYPE_ID' );
7448: ELSE
7449: fnd_message.set_token('VALUE_NAME',cr.reporting_type_name );
7450: fnd_message.set_token('COLUMN_NAME','REPORTING_TYPE_NAME' );
7451: END IF;
7452: l_rec_index := l_rec_index +1;
7453: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7454: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7453: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7454: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7455: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
7456: l_error_table(l_rec_index).party_id := cr.party_id;
7457: l_error_table(l_rec_index).message_text := fnd_message.get();
7458: END IF;
7459: IF BITAND(cr.error_number,G_ES_RCA_REP_CODE_INVALID) <> 0 THEN
7460: fnd_message.set_name('ZX','ZX_BULK_RC_INVALID');
7461: IF cr.reporting_code_id IS NOT NULL THEN
7456: l_error_table(l_rec_index).party_id := cr.party_id;
7457: l_error_table(l_rec_index).message_text := fnd_message.get();
7458: END IF;
7459: IF BITAND(cr.error_number,G_ES_RCA_REP_CODE_INVALID) <> 0 THEN
7460: fnd_message.set_name('ZX','ZX_BULK_RC_INVALID');
7461: IF cr.reporting_code_id IS NOT NULL THEN
7462: fnd_message.set_token('REP_CODE',cr.reporting_code_id );
7463: ELSE
7464: fnd_message.set_token('REP_CODE',cr.reporting_code_name );
7458: END IF;
7459: IF BITAND(cr.error_number,G_ES_RCA_REP_CODE_INVALID) <> 0 THEN
7460: fnd_message.set_name('ZX','ZX_BULK_RC_INVALID');
7461: IF cr.reporting_code_id IS NOT NULL THEN
7462: fnd_message.set_token('REP_CODE',cr.reporting_code_id );
7463: ELSE
7464: fnd_message.set_token('REP_CODE',cr.reporting_code_name );
7465: END IF;
7466: IF cr.reporting_type_name IS NULL THEN
7460: fnd_message.set_name('ZX','ZX_BULK_RC_INVALID');
7461: IF cr.reporting_code_id IS NOT NULL THEN
7462: fnd_message.set_token('REP_CODE',cr.reporting_code_id );
7463: ELSE
7464: fnd_message.set_token('REP_CODE',cr.reporting_code_name );
7465: END IF;
7466: IF cr.reporting_type_name IS NULL THEN
7467: fnd_message.set_token('REP_TYPE',cr.reporting_type_id );
7468: ELSE
7463: ELSE
7464: fnd_message.set_token('REP_CODE',cr.reporting_code_name );
7465: END IF;
7466: IF cr.reporting_type_name IS NULL THEN
7467: fnd_message.set_token('REP_TYPE',cr.reporting_type_id );
7468: ELSE
7469: fnd_message.set_token('REP_TYPE',cr.reporting_type_name );
7470: END IF;
7471: l_rec_index := l_rec_index +1;
7465: END IF;
7466: IF cr.reporting_type_name IS NULL THEN
7467: fnd_message.set_token('REP_TYPE',cr.reporting_type_id );
7468: ELSE
7469: fnd_message.set_token('REP_TYPE',cr.reporting_type_name );
7470: END IF;
7471: l_rec_index := l_rec_index +1;
7472: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7473: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7472: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7473: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7474: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
7475: l_error_table(l_rec_index).party_id := cr.party_id;
7476: l_error_table(l_rec_index).message_text := fnd_message.get();
7477: END IF;
7478: IF BITAND(cr.error_number,G_ES_RCA_REP_CODE_VAL_INVALID) <> 0 THEN
7479: fnd_message.set_name('ZX','ZX_BULK_RV_INVALID');
7480: IF cr.reporting_code_name IS NULL THEN
7475: l_error_table(l_rec_index).party_id := cr.party_id;
7476: l_error_table(l_rec_index).message_text := fnd_message.get();
7477: END IF;
7478: IF BITAND(cr.error_number,G_ES_RCA_REP_CODE_VAL_INVALID) <> 0 THEN
7479: fnd_message.set_name('ZX','ZX_BULK_RV_INVALID');
7480: IF cr.reporting_code_name IS NULL THEN
7481: fnd_message.set_token('REP_CODE',cr.reporting_code_id );
7482: ELSE
7483: fnd_message.set_token('REP_CODE',cr.reporting_code_name );
7477: END IF;
7478: IF BITAND(cr.error_number,G_ES_RCA_REP_CODE_VAL_INVALID) <> 0 THEN
7479: fnd_message.set_name('ZX','ZX_BULK_RV_INVALID');
7480: IF cr.reporting_code_name IS NULL THEN
7481: fnd_message.set_token('REP_CODE',cr.reporting_code_id );
7482: ELSE
7483: fnd_message.set_token('REP_CODE',cr.reporting_code_name );
7484: END IF;
7485: IF cr.reporting_code_char_value IS NOT NULL THEN
7479: fnd_message.set_name('ZX','ZX_BULK_RV_INVALID');
7480: IF cr.reporting_code_name IS NULL THEN
7481: fnd_message.set_token('REP_CODE',cr.reporting_code_id );
7482: ELSE
7483: fnd_message.set_token('REP_CODE',cr.reporting_code_name );
7484: END IF;
7485: IF cr.reporting_code_char_value IS NOT NULL THEN
7486: fnd_message.set_token('REP_VALUE',cr.reporting_code_char_value );
7487: ELSIF cr.reporting_code_num_value IS NOT NULL THEN
7482: ELSE
7483: fnd_message.set_token('REP_CODE',cr.reporting_code_name );
7484: END IF;
7485: IF cr.reporting_code_char_value IS NOT NULL THEN
7486: fnd_message.set_token('REP_VALUE',cr.reporting_code_char_value );
7487: ELSIF cr.reporting_code_num_value IS NOT NULL THEN
7488: fnd_message.set_token('REP_VALUE',cr.reporting_code_num_value );
7489: ELSE
7490: fnd_message.set_token('REP_VALUE',cr.reporting_code_date_value );
7484: END IF;
7485: IF cr.reporting_code_char_value IS NOT NULL THEN
7486: fnd_message.set_token('REP_VALUE',cr.reporting_code_char_value );
7487: ELSIF cr.reporting_code_num_value IS NOT NULL THEN
7488: fnd_message.set_token('REP_VALUE',cr.reporting_code_num_value );
7489: ELSE
7490: fnd_message.set_token('REP_VALUE',cr.reporting_code_date_value );
7491: END IF;
7492: l_rec_index := l_rec_index +1;
7486: fnd_message.set_token('REP_VALUE',cr.reporting_code_char_value );
7487: ELSIF cr.reporting_code_num_value IS NOT NULL THEN
7488: fnd_message.set_token('REP_VALUE',cr.reporting_code_num_value );
7489: ELSE
7490: fnd_message.set_token('REP_VALUE',cr.reporting_code_date_value );
7491: END IF;
7492: l_rec_index := l_rec_index +1;
7493: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7494: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7493: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7494: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7495: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
7496: l_error_table(l_rec_index).party_id := cr.party_id;
7497: l_error_table(l_rec_index).message_text := fnd_message.get();
7498: END IF;
7499: IF BITAND(cr.error_number,G_ES_RCA_DATE_OVERLAP) <> 0 THEN
7500: fnd_message.set_name('ZX','ZX_PERIOD_OVERLAP');
7501: l_rec_index := l_rec_index +1;
7496: l_error_table(l_rec_index).party_id := cr.party_id;
7497: l_error_table(l_rec_index).message_text := fnd_message.get();
7498: END IF;
7499: IF BITAND(cr.error_number,G_ES_RCA_DATE_OVERLAP) <> 0 THEN
7500: fnd_message.set_name('ZX','ZX_PERIOD_OVERLAP');
7501: l_rec_index := l_rec_index +1;
7502: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7503: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7504: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
7502: l_error_table(l_rec_index).intf_ptp_reference := cr.intf_ptp_reference;
7503: l_error_table(l_rec_index).party_type_code := cr.party_type_code;
7504: l_error_table(l_rec_index).prog_int_record_ref := cr.prog_int_record_ref;
7505: l_error_table(l_rec_index).party_id := cr.party_id;
7506: l_error_table(l_rec_index).message_text := fnd_message.get();
7507: END IF;
7508:
7509: FOR loop_index IN NVL(l_error_table.FIRST,0)..NVL(l_error_table.LAST,-1) LOOP
7510: INSERT INTO zx_errors_int
7664: OR NVL(p_commit,G_MISS_CHAR)
7665: NOT IN (G_TRUE, G_FALSE)
7666: THEN
7667: x_return_status := G_CONC_RET_STS_ERROR;
7668: FND_MESSAGE.Set_Name('ZX', 'ZX_API_INVALID_PARAM');
7669: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
7670: FND_MESSAGE.Set_Token('API_NAME', G_PROC_NAME);
7671: x_msg_data := FND_MESSAGE.get();
7672: RETURN;
7665: NOT IN (G_TRUE, G_FALSE)
7666: THEN
7667: x_return_status := G_CONC_RET_STS_ERROR;
7668: FND_MESSAGE.Set_Name('ZX', 'ZX_API_INVALID_PARAM');
7669: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
7670: FND_MESSAGE.Set_Token('API_NAME', G_PROC_NAME);
7671: x_msg_data := FND_MESSAGE.get();
7672: RETURN;
7673: END IF;
7666: THEN
7667: x_return_status := G_CONC_RET_STS_ERROR;
7668: FND_MESSAGE.Set_Name('ZX', 'ZX_API_INVALID_PARAM');
7669: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
7670: FND_MESSAGE.Set_Token('API_NAME', G_PROC_NAME);
7671: x_msg_data := FND_MESSAGE.get();
7672: RETURN;
7673: END IF;
7674:
7667: x_return_status := G_CONC_RET_STS_ERROR;
7668: FND_MESSAGE.Set_Name('ZX', 'ZX_API_INVALID_PARAM');
7669: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
7670: FND_MESSAGE.Set_Token('API_NAME', G_PROC_NAME);
7671: x_msg_data := FND_MESSAGE.get();
7672: RETURN;
7673: END IF;
7674:
7675: G_DEBUG_STATEMENT:= 'Completed validating mandatory API parameters';
8118: )
8119: )
8120: THEN
8121: x_return_status := G_CONC_RET_STS_ERROR;
8122: FND_MESSAGE.Set_Name('ZX', 'ZX_API_INVALID_PARAM');
8123: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
8124: FND_MESSAGE.Set_Token('API_NAME', G_PROC_NAME);
8125: x_msg_data := FND_MESSAGE.get();
8126: RETURN;
8119: )
8120: THEN
8121: x_return_status := G_CONC_RET_STS_ERROR;
8122: FND_MESSAGE.Set_Name('ZX', 'ZX_API_INVALID_PARAM');
8123: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
8124: FND_MESSAGE.Set_Token('API_NAME', G_PROC_NAME);
8125: x_msg_data := FND_MESSAGE.get();
8126: RETURN;
8127: END IF;
8120: THEN
8121: x_return_status := G_CONC_RET_STS_ERROR;
8122: FND_MESSAGE.Set_Name('ZX', 'ZX_API_INVALID_PARAM');
8123: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
8124: FND_MESSAGE.Set_Token('API_NAME', G_PROC_NAME);
8125: x_msg_data := FND_MESSAGE.get();
8126: RETURN;
8127: END IF;
8128:
8121: x_return_status := G_CONC_RET_STS_ERROR;
8122: FND_MESSAGE.Set_Name('ZX', 'ZX_API_INVALID_PARAM');
8123: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
8124: FND_MESSAGE.Set_Token('API_NAME', G_PROC_NAME);
8125: x_msg_data := FND_MESSAGE.get();
8126: RETURN;
8127: END IF;
8128:
8129: G_DEBUG_STATEMENT:= 'Completed validating mandatory API parameters';
8139: SELECT NVL(SUM(DECODE(NVL(record_status,G_RS_ERROR),G_RS_ERROR,1,0)),0), NVL(SUM(1),0)
8140: INTO l_count_exception_records, l_count_success_records
8141: FROM zx_party_tax_profile_int
8142: WHERE request_id = G_REQUEST_ID;
8143: fnd_message.set_name('ZX','ZX_TOT_IMPORTED_RECORDS');
8144: l_tot_records_msg := fnd_message.get();
8145: fnd_message.set_name('ZX','ZX_TOT_EXCEPTION_RECORDS');
8146: l_exe_records_msg := fnd_message.get();
8147: --
8140: INTO l_count_exception_records, l_count_success_records
8141: FROM zx_party_tax_profile_int
8142: WHERE request_id = G_REQUEST_ID;
8143: fnd_message.set_name('ZX','ZX_TOT_IMPORTED_RECORDS');
8144: l_tot_records_msg := fnd_message.get();
8145: fnd_message.set_name('ZX','ZX_TOT_EXCEPTION_RECORDS');
8146: l_exe_records_msg := fnd_message.get();
8147: --
8148: -- start print the summary for party tax profile
8141: FROM zx_party_tax_profile_int
8142: WHERE request_id = G_REQUEST_ID;
8143: fnd_message.set_name('ZX','ZX_TOT_IMPORTED_RECORDS');
8144: l_tot_records_msg := fnd_message.get();
8145: fnd_message.set_name('ZX','ZX_TOT_EXCEPTION_RECORDS');
8146: l_exe_records_msg := fnd_message.get();
8147: --
8148: -- start print the summary for party tax profile
8149: --
8142: WHERE request_id = G_REQUEST_ID;
8143: fnd_message.set_name('ZX','ZX_TOT_IMPORTED_RECORDS');
8144: l_tot_records_msg := fnd_message.get();
8145: fnd_message.set_name('ZX','ZX_TOT_EXCEPTION_RECORDS');
8146: l_exe_records_msg := fnd_message.get();
8147: --
8148: -- start print the summary for party tax profile
8149: --
8150: log_now (p_log_level => FND_FILE.OUTPUT
8261: --
8262:
8263: l_date1 := SYSDATE;
8264:
8265: fnd_message.set_name('ZX','ZX_PTP_ERROR_HEADER');
8266: fnd_message.set_token('TABLE_NAME', G_INTF_PTP_TABLE_NAME);
8267: l_message_line1 := fnd_message.get();
8268:
8269: log_now (p_log_level => FND_FILE.OUTPUT
8262:
8263: l_date1 := SYSDATE;
8264:
8265: fnd_message.set_name('ZX','ZX_PTP_ERROR_HEADER');
8266: fnd_message.set_token('TABLE_NAME', G_INTF_PTP_TABLE_NAME);
8267: l_message_line1 := fnd_message.get();
8268:
8269: log_now (p_log_level => FND_FILE.OUTPUT
8270: ,p_message => l_message_line1
8263: l_date1 := SYSDATE;
8264:
8265: fnd_message.set_name('ZX','ZX_PTP_ERROR_HEADER');
8266: fnd_message.set_token('TABLE_NAME', G_INTF_PTP_TABLE_NAME);
8267: l_message_line1 := fnd_message.get();
8268:
8269: log_now (p_log_level => FND_FILE.OUTPUT
8270: ,p_message => l_message_line1
8271: );
8278: log_now (p_log_level => FND_FILE.OUTPUT
8279: ,p_message => p_message_header_string_2
8280: );
8281:
8282: fnd_message.set_name('ZX','ZX_PTP_ERR_CATEGORY_NAME');
8283: l_msg_ptp_table := fnd_message.get();
8284:
8285: fnd_message.set_name('ZX','ZX_EXE_ERR_CATEGORY_NAME');
8286: l_msg_exe_table := fnd_message.get();
8279: ,p_message => p_message_header_string_2
8280: );
8281:
8282: fnd_message.set_name('ZX','ZX_PTP_ERR_CATEGORY_NAME');
8283: l_msg_ptp_table := fnd_message.get();
8284:
8285: fnd_message.set_name('ZX','ZX_EXE_ERR_CATEGORY_NAME');
8286: l_msg_exe_table := fnd_message.get();
8287:
8281:
8282: fnd_message.set_name('ZX','ZX_PTP_ERR_CATEGORY_NAME');
8283: l_msg_ptp_table := fnd_message.get();
8284:
8285: fnd_message.set_name('ZX','ZX_EXE_ERR_CATEGORY_NAME');
8286: l_msg_exe_table := fnd_message.get();
8287:
8288: fnd_message.set_name('ZX','ZX_REG_ERR_CATEGORY_NAME');
8289: l_msg_reg_table := fnd_message.get();
8282: fnd_message.set_name('ZX','ZX_PTP_ERR_CATEGORY_NAME');
8283: l_msg_ptp_table := fnd_message.get();
8284:
8285: fnd_message.set_name('ZX','ZX_EXE_ERR_CATEGORY_NAME');
8286: l_msg_exe_table := fnd_message.get();
8287:
8288: fnd_message.set_name('ZX','ZX_REG_ERR_CATEGORY_NAME');
8289: l_msg_reg_table := fnd_message.get();
8290:
8284:
8285: fnd_message.set_name('ZX','ZX_EXE_ERR_CATEGORY_NAME');
8286: l_msg_exe_table := fnd_message.get();
8287:
8288: fnd_message.set_name('ZX','ZX_REG_ERR_CATEGORY_NAME');
8289: l_msg_reg_table := fnd_message.get();
8290:
8291: fnd_message.set_name('ZX','ZX_RCA_ERR_CATEGORY_NAME');
8292: l_msg_rca_table := fnd_message.get();
8285: fnd_message.set_name('ZX','ZX_EXE_ERR_CATEGORY_NAME');
8286: l_msg_exe_table := fnd_message.get();
8287:
8288: fnd_message.set_name('ZX','ZX_REG_ERR_CATEGORY_NAME');
8289: l_msg_reg_table := fnd_message.get();
8290:
8291: fnd_message.set_name('ZX','ZX_RCA_ERR_CATEGORY_NAME');
8292: l_msg_rca_table := fnd_message.get();
8293:
8287:
8288: fnd_message.set_name('ZX','ZX_REG_ERR_CATEGORY_NAME');
8289: l_msg_reg_table := fnd_message.get();
8290:
8291: fnd_message.set_name('ZX','ZX_RCA_ERR_CATEGORY_NAME');
8292: l_msg_rca_table := fnd_message.get();
8293:
8294: ---------------------------------------------
8295: -- the message format will have 4 columns
8288: fnd_message.set_name('ZX','ZX_REG_ERR_CATEGORY_NAME');
8289: l_msg_reg_table := fnd_message.get();
8290:
8291: fnd_message.set_name('ZX','ZX_RCA_ERR_CATEGORY_NAME');
8292: l_msg_rca_table := fnd_message.get();
8293:
8294: ---------------------------------------------
8295: -- the message format will have 4 columns
8296: -- party_reference max 27 characters