DBA Data[Home] [Help]

APPS.AR_CHARGE_SCHEDULE_PKG dependencies on FND_MESSAGE

Line 89: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

85: arp_standard.debug('Insert_schedule_Row -');
86: EXCEPTION
87: WHEN OTHERS THEN
88: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
89: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
90: FND_MESSAGE.SET_TOKEN('ERROR' ,'Insert_schedule_Row:'||SQLERRM);
91: FND_MSG_PUB.ADD;
92: END Insert_schedule_Row;
93:

Line 90: FND_MESSAGE.SET_TOKEN('ERROR' ,'Insert_schedule_Row:'||SQLERRM);

86: EXCEPTION
87: WHEN OTHERS THEN
88: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
89: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
90: FND_MESSAGE.SET_TOKEN('ERROR' ,'Insert_schedule_Row:'||SQLERRM);
91: FND_MSG_PUB.ADD;
92: END Insert_schedule_Row;
93:
94:

Line 182: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

178: arp_standard.debug('Insert_schedule_Row -');
179: EXCEPTION
180: WHEN OTHERS THEN
181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
182: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
183: FND_MESSAGE.SET_TOKEN('ERROR' ,'Insert_schedule_Row:'||SQLERRM);
184: FND_MSG_PUB.ADD;
185: END Update_schedule_Row;
186:

Line 183: FND_MESSAGE.SET_TOKEN('ERROR' ,'Insert_schedule_Row:'||SQLERRM);

179: EXCEPTION
180: WHEN OTHERS THEN
181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
182: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
183: FND_MESSAGE.SET_TOKEN('ERROR' ,'Insert_schedule_Row:'||SQLERRM);
184: FND_MSG_PUB.ADD;
185: END Update_schedule_Row;
186:
187:

Line 286: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

282: arp_standard.debug('Insert_Head_Row -');
283: EXCEPTION
284: WHEN OTHERS THEN
285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
286: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
287: FND_MESSAGE.SET_TOKEN('ERROR' ,'Insert_Head_Row:'||SQLERRM);
288: FND_MSG_PUB.ADD;
289: END Insert_Head_Row;
290:

Line 287: FND_MESSAGE.SET_TOKEN('ERROR' ,'Insert_Head_Row:'||SQLERRM);

283: EXCEPTION
284: WHEN OTHERS THEN
285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
286: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
287: FND_MESSAGE.SET_TOKEN('ERROR' ,'Insert_Head_Row:'||SQLERRM);
288: FND_MSG_PUB.ADD;
289: END Insert_Head_Row;
290:
291:

Line 392: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

388: arp_standard.debug('Update_Head_Row -');
389: EXCEPTION
390: WHEN OTHERS THEN
391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
392: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
393: FND_MESSAGE.SET_TOKEN('ERROR' ,'Update_Head_Row:'||SQLERRM);
394: FND_MSG_PUB.ADD;
395: END Update_Head_Row;
396:

Line 393: FND_MESSAGE.SET_TOKEN('ERROR' ,'Update_Head_Row:'||SQLERRM);

389: EXCEPTION
390: WHEN OTHERS THEN
391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
392: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
393: FND_MESSAGE.SET_TOKEN('ERROR' ,'Update_Head_Row:'||SQLERRM);
394: FND_MSG_PUB.ADD;
395: END Update_Head_Row;
396:
397:

Line 496: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

492: arp_standard.debug('Insert_Line_Row -');
493: EXCEPTION
494: WHEN OTHERS THEN
495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
496: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
497: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
498: FND_MSG_PUB.ADD;
499: END Insert_Line_Row;
500:

Line 497: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

493: EXCEPTION
494: WHEN OTHERS THEN
495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
496: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
497: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
498: FND_MSG_PUB.ADD;
499: END Insert_Line_Row;
500:
501:

Line 594: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

590: arp_standard.debug('Update_Line_Row -');
591: EXCEPTION
592: WHEN OTHERS THEN
593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
594: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
595: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
596: FND_MSG_PUB.ADD;
597: END Update_Line_Row;
598:

Line 595: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

591: EXCEPTION
592: WHEN OTHERS THEN
593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
594: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
595: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
596: FND_MSG_PUB.ADD;
597: END Update_Line_Row;
598:
599:

Line 673: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

669: -------------------------
670: arp_standard.debug(' Validate schedule_name +');
671: IF p_mode = 'INSERT' THEN
672: IF p_schedule_name IS NULL OR p_schedule_name = FND_API.G_MISS_CHAR THEN
673: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
674: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'schedule_name' );
675: FND_MSG_PUB.ADD;
676: x_return_status := FND_API.G_RET_STS_ERROR;
677: END IF;

Line 674: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'schedule_name' );

670: arp_standard.debug(' Validate schedule_name +');
671: IF p_mode = 'INSERT' THEN
672: IF p_schedule_name IS NULL OR p_schedule_name = FND_API.G_MISS_CHAR THEN
673: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
674: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'schedule_name' );
675: FND_MSG_PUB.ADD;
676: x_return_status := FND_API.G_RET_STS_ERROR;
677: END IF;
678: END IF;

Line 737: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

733: -- Validate schedule_id
734: -------------------------------------
735: arp_standard.debug(' Validate schedule_id +');
736: IF P_SCHEDULE_ID IS NULL OR P_SCHEDULE_ID = fnd_api.g_miss_num THEN
737: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
738: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'SCHEDULE_ID' );
739: FND_MSG_PUB.ADD;
740: x_return_status := FND_API.G_RET_STS_ERROR;
741: END IF;

Line 738: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'SCHEDULE_ID' );

734: -------------------------------------
735: arp_standard.debug(' Validate schedule_id +');
736: IF P_SCHEDULE_ID IS NULL OR P_SCHEDULE_ID = fnd_api.g_miss_num THEN
737: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
738: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'SCHEDULE_ID' );
739: FND_MSG_PUB.ADD;
740: x_return_status := FND_API.G_RET_STS_ERROR;
741: END IF;
742: OPEN c_schedule_id;

Line 745: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');

741: END IF;
742: OPEN c_schedule_id;
743: FETCH c_schedule_id INTO l_c;
744: IF c_schedule_id%NOTFOUND THEN
745: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
746: FND_MESSAGE.SET_TOKEN('FK', 'ar charge schedules');
747: FND_MESSAGE.SET_TOKEN('COLUMN', 'schedule_id');
748: FND_MESSAGE.SET_TOKEN('TABLE', 'ar_charge_schedules');
749: FND_MSG_PUB.ADD;

Line 746: FND_MESSAGE.SET_TOKEN('FK', 'ar charge schedules');

742: OPEN c_schedule_id;
743: FETCH c_schedule_id INTO l_c;
744: IF c_schedule_id%NOTFOUND THEN
745: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
746: FND_MESSAGE.SET_TOKEN('FK', 'ar charge schedules');
747: FND_MESSAGE.SET_TOKEN('COLUMN', 'schedule_id');
748: FND_MESSAGE.SET_TOKEN('TABLE', 'ar_charge_schedules');
749: FND_MSG_PUB.ADD;
750: x_return_status := FND_API.G_RET_STS_ERROR;

Line 747: FND_MESSAGE.SET_TOKEN('COLUMN', 'schedule_id');

743: FETCH c_schedule_id INTO l_c;
744: IF c_schedule_id%NOTFOUND THEN
745: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
746: FND_MESSAGE.SET_TOKEN('FK', 'ar charge schedules');
747: FND_MESSAGE.SET_TOKEN('COLUMN', 'schedule_id');
748: FND_MESSAGE.SET_TOKEN('TABLE', 'ar_charge_schedules');
749: FND_MSG_PUB.ADD;
750: x_return_status := FND_API.G_RET_STS_ERROR;
751: END IF;

Line 748: FND_MESSAGE.SET_TOKEN('TABLE', 'ar_charge_schedules');

744: IF c_schedule_id%NOTFOUND THEN
745: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
746: FND_MESSAGE.SET_TOKEN('FK', 'ar charge schedules');
747: FND_MESSAGE.SET_TOKEN('COLUMN', 'schedule_id');
748: FND_MESSAGE.SET_TOKEN('TABLE', 'ar_charge_schedules');
749: FND_MSG_PUB.ADD;
750: x_return_status := FND_API.G_RET_STS_ERROR;
751: END IF;
752: CLOSE c_schedule_id;

Line 760: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

756: -- Validate SCHEDULE_HEADER_TYPE lookup code in lookup type SCHEDULE_HEADER_TYPE
757: --------------------------------------------------------------------------
758: arp_standard.debug(' Validate schedule_header_type +');
759: IF p_schedule_header_type IS NULL OR p_schedule_header_type = fnd_api.g_miss_char THEN
760: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
761: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'schedule_header_type' );
762: FND_MSG_PUB.ADD;
763: x_return_status := FND_API.G_RET_STS_ERROR;
764: END IF;

Line 761: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'schedule_header_type' );

757: --------------------------------------------------------------------------
758: arp_standard.debug(' Validate schedule_header_type +');
759: IF p_schedule_header_type IS NULL OR p_schedule_header_type = fnd_api.g_miss_char THEN
760: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
761: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'schedule_header_type' );
762: FND_MSG_PUB.ADD;
763: x_return_status := FND_API.G_RET_STS_ERROR;
764: END IF;
765:

Line 768: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_LOOKUP' );

764: END IF;
765:
766: IF validate_lookup('SCHEDULE_HEADER_TYPE',p_schedule_header_type) = FALSE THEN
767: arp_standard.debug(' schedule type should be lookup code for the lookup type SCHEDULE_HEADER_TYPE');
768: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_LOOKUP' );
769: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'schedule header type' );
770: FND_MESSAGE.SET_TOKEN( 'LOOKUP_TYPE', 'SCHEDULE_HEADER_TYPE' );
771: FND_MSG_PUB.ADD;
772: x_return_status := FND_API.G_RET_STS_ERROR;

Line 769: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'schedule header type' );

765:
766: IF validate_lookup('SCHEDULE_HEADER_TYPE',p_schedule_header_type) = FALSE THEN
767: arp_standard.debug(' schedule type should be lookup code for the lookup type SCHEDULE_HEADER_TYPE');
768: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_LOOKUP' );
769: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'schedule header type' );
770: FND_MESSAGE.SET_TOKEN( 'LOOKUP_TYPE', 'SCHEDULE_HEADER_TYPE' );
771: FND_MSG_PUB.ADD;
772: x_return_status := FND_API.G_RET_STS_ERROR;
773: END IF;

Line 770: FND_MESSAGE.SET_TOKEN( 'LOOKUP_TYPE', 'SCHEDULE_HEADER_TYPE' );

766: IF validate_lookup('SCHEDULE_HEADER_TYPE',p_schedule_header_type) = FALSE THEN
767: arp_standard.debug(' schedule type should be lookup code for the lookup type SCHEDULE_HEADER_TYPE');
768: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_LOOKUP' );
769: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'schedule header type' );
770: FND_MESSAGE.SET_TOKEN( 'LOOKUP_TYPE', 'SCHEDULE_HEADER_TYPE' );
771: FND_MSG_PUB.ADD;
772: x_return_status := FND_API.G_RET_STS_ERROR;
773: END IF;
774: arp_standard.debug(' Validate schedule_header_type -');

Line 782: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

778: -- Validate STATUS lookup code in lookup type REGISTRY_STATUS
779: -------------------------------------------------------------
780: arp_standard.debug(' Validate status +');
781: IF p_status IS NULL OR p_status = fnd_api.g_miss_char THEN
782: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
783: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'status' );
784: FND_MSG_PUB.ADD;
785: x_return_status := FND_API.G_RET_STS_ERROR;
786: END IF;

Line 783: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'status' );

779: -------------------------------------------------------------
780: arp_standard.debug(' Validate status +');
781: IF p_status IS NULL OR p_status = fnd_api.g_miss_char THEN
782: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
783: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'status' );
784: FND_MSG_PUB.ADD;
785: x_return_status := FND_API.G_RET_STS_ERROR;
786: END IF;
787:

Line 790: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_LOOKUP' );

786: END IF;
787:
788: IF validate_lookup('REGISTRY_STATUS',p_status) = FALSE THEN
789: arp_standard.debug(' status should be lookup code for the lookup type REGISTRY_STATUS');
790: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_LOOKUP' );
791: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'status' );
792: FND_MESSAGE.SET_TOKEN( 'LOOKUP_TYPE', 'REGISTRY_STATUS' );
793: FND_MSG_PUB.ADD;
794: x_return_status := FND_API.G_RET_STS_ERROR;

Line 791: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'status' );

787:
788: IF validate_lookup('REGISTRY_STATUS',p_status) = FALSE THEN
789: arp_standard.debug(' status should be lookup code for the lookup type REGISTRY_STATUS');
790: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_LOOKUP' );
791: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'status' );
792: FND_MESSAGE.SET_TOKEN( 'LOOKUP_TYPE', 'REGISTRY_STATUS' );
793: FND_MSG_PUB.ADD;
794: x_return_status := FND_API.G_RET_STS_ERROR;
795: END IF;

Line 792: FND_MESSAGE.SET_TOKEN( 'LOOKUP_TYPE', 'REGISTRY_STATUS' );

788: IF validate_lookup('REGISTRY_STATUS',p_status) = FALSE THEN
789: arp_standard.debug(' status should be lookup code for the lookup type REGISTRY_STATUS');
790: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_LOOKUP' );
791: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'status' );
792: FND_MESSAGE.SET_TOKEN( 'LOOKUP_TYPE', 'REGISTRY_STATUS' );
793: FND_MSG_PUB.ADD;
794: x_return_status := FND_API.G_RET_STS_ERROR;
795: END IF;
796: arp_standard.debug(' Validate status -');

Line 809: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');

805: ELSE
806: OPEN c_aging_bucket;
807: FETCH c_aging_bucket INTO l_c;
808: IF c_aging_bucket%NOTFOUND THEN
809: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
810: FND_MESSAGE.SET_TOKEN('FK', 'ar aging bucket id');
811: FND_MESSAGE.SET_TOKEN('COLUMN', 'aging_bucket_id');
812: FND_MESSAGE.SET_TOKEN('TABLE', 'ar_aging_bucket');
813: FND_MSG_PUB.ADD;

Line 810: FND_MESSAGE.SET_TOKEN('FK', 'ar aging bucket id');

806: OPEN c_aging_bucket;
807: FETCH c_aging_bucket INTO l_c;
808: IF c_aging_bucket%NOTFOUND THEN
809: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
810: FND_MESSAGE.SET_TOKEN('FK', 'ar aging bucket id');
811: FND_MESSAGE.SET_TOKEN('COLUMN', 'aging_bucket_id');
812: FND_MESSAGE.SET_TOKEN('TABLE', 'ar_aging_bucket');
813: FND_MSG_PUB.ADD;
814: x_return_status := FND_API.G_RET_STS_ERROR;

Line 811: FND_MESSAGE.SET_TOKEN('COLUMN', 'aging_bucket_id');

807: FETCH c_aging_bucket INTO l_c;
808: IF c_aging_bucket%NOTFOUND THEN
809: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
810: FND_MESSAGE.SET_TOKEN('FK', 'ar aging bucket id');
811: FND_MESSAGE.SET_TOKEN('COLUMN', 'aging_bucket_id');
812: FND_MESSAGE.SET_TOKEN('TABLE', 'ar_aging_bucket');
813: FND_MSG_PUB.ADD;
814: x_return_status := FND_API.G_RET_STS_ERROR;
815: END IF;

Line 812: FND_MESSAGE.SET_TOKEN('TABLE', 'ar_aging_bucket');

808: IF c_aging_bucket%NOTFOUND THEN
809: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
810: FND_MESSAGE.SET_TOKEN('FK', 'ar aging bucket id');
811: FND_MESSAGE.SET_TOKEN('COLUMN', 'aging_bucket_id');
812: FND_MESSAGE.SET_TOKEN('TABLE', 'ar_aging_bucket');
813: FND_MSG_PUB.ADD;
814: x_return_status := FND_API.G_RET_STS_ERROR;
815: END IF;
816: CLOSE c_aging_bucket;

Line 828: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

824: arp_standard.debug(' validate start and end dates +');
825:
826: IF p_start_date IS NULL OR p_start_date = fnd_api.g_miss_date THEN
827: arp_standard.debug(' validate start date is mandatory');
828: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
829: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'p_start_date' );
830: FND_MSG_PUB.ADD;
831: x_return_status := FND_API.G_RET_STS_ERROR;
832: END IF;

Line 829: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'p_start_date' );

825:
826: IF p_start_date IS NULL OR p_start_date = fnd_api.g_miss_date THEN
827: arp_standard.debug(' validate start date is mandatory');
828: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
829: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'p_start_date' );
830: FND_MSG_PUB.ADD;
831: x_return_status := FND_API.G_RET_STS_ERROR;
832: END IF;
833:

Line 839: fnd_message.set_name('AR', 'HZ_API_DATE_GREATER');

835: date2 => p_end_date );
836:
837: IF l_val = 1 THEN
838: arp_standard.debug(' end date should be greater than the start date');
839: fnd_message.set_name('AR', 'HZ_API_DATE_GREATER');
840: fnd_message.set_token('DATE2', 'end_date');
841: fnd_message.set_token('DATE1', 'start_date');
842: fnd_msg_pub.add;
843: x_return_status := fnd_api.g_ret_sts_error;

Line 840: fnd_message.set_token('DATE2', 'end_date');

836:
837: IF l_val = 1 THEN
838: arp_standard.debug(' end date should be greater than the start date');
839: fnd_message.set_name('AR', 'HZ_API_DATE_GREATER');
840: fnd_message.set_token('DATE2', 'end_date');
841: fnd_message.set_token('DATE1', 'start_date');
842: fnd_msg_pub.add;
843: x_return_status := fnd_api.g_ret_sts_error;
844: END IF;

Line 841: fnd_message.set_token('DATE1', 'start_date');

837: IF l_val = 1 THEN
838: arp_standard.debug(' end date should be greater than the start date');
839: fnd_message.set_name('AR', 'HZ_API_DATE_GREATER');
840: fnd_message.set_token('DATE2', 'end_date');
841: fnd_message.set_token('DATE1', 'start_date');
842: fnd_msg_pub.add;
843: x_return_status := fnd_api.g_ret_sts_error;
844: END IF;
845:

Line 865: fnd_message.set_name('AR', 'AR_DATE_OVERLAPP');

861: ELSE
862: arp_standard.debug(' overlapping issue :');
863: arp_standard.debug(' existing start :'||l_start_date|| ' end :'||l_end_date);
864: arp_standard.debug(' entered start :'||p_start_date|| ' end :'||p_end_date);
865: fnd_message.set_name('AR', 'AR_DATE_OVERLAPP');
866: --Int'l Calendar Project
867: fnd_message.set_token('START_DATE_PER_1', fnd_date.date_to_chardate(l_start_date, calendar_aware=> FND_DATE.calendar_aware_alt));
868: fnd_message.set_token('END_DATE_PER_1' , fnd_date.date_to_chardate(l_end_date, calendar_aware=> FND_DATE.calendar_aware_alt));
869: fnd_message.set_token('START_DATE_PER_2', fnd_date.date_to_chardate(p_start_date, calendar_aware=> FND_DATE.calendar_aware_alt));

Line 867: fnd_message.set_token('START_DATE_PER_1', fnd_date.date_to_chardate(l_start_date, calendar_aware=> FND_DATE.calendar_aware_alt));

863: arp_standard.debug(' existing start :'||l_start_date|| ' end :'||l_end_date);
864: arp_standard.debug(' entered start :'||p_start_date|| ' end :'||p_end_date);
865: fnd_message.set_name('AR', 'AR_DATE_OVERLAPP');
866: --Int'l Calendar Project
867: fnd_message.set_token('START_DATE_PER_1', fnd_date.date_to_chardate(l_start_date, calendar_aware=> FND_DATE.calendar_aware_alt));
868: fnd_message.set_token('END_DATE_PER_1' , fnd_date.date_to_chardate(l_end_date, calendar_aware=> FND_DATE.calendar_aware_alt));
869: fnd_message.set_token('START_DATE_PER_2', fnd_date.date_to_chardate(p_start_date, calendar_aware=> FND_DATE.calendar_aware_alt));
870: fnd_message.set_token('END_DATE_PER_2' , fnd_date.date_to_chardate(p_end_date, calendar_aware=> FND_DATE.calendar_aware_alt));
871: fnd_msg_pub.add;

Line 868: fnd_message.set_token('END_DATE_PER_1' , fnd_date.date_to_chardate(l_end_date, calendar_aware=> FND_DATE.calendar_aware_alt));

864: arp_standard.debug(' entered start :'||p_start_date|| ' end :'||p_end_date);
865: fnd_message.set_name('AR', 'AR_DATE_OVERLAPP');
866: --Int'l Calendar Project
867: fnd_message.set_token('START_DATE_PER_1', fnd_date.date_to_chardate(l_start_date, calendar_aware=> FND_DATE.calendar_aware_alt));
868: fnd_message.set_token('END_DATE_PER_1' , fnd_date.date_to_chardate(l_end_date, calendar_aware=> FND_DATE.calendar_aware_alt));
869: fnd_message.set_token('START_DATE_PER_2', fnd_date.date_to_chardate(p_start_date, calendar_aware=> FND_DATE.calendar_aware_alt));
870: fnd_message.set_token('END_DATE_PER_2' , fnd_date.date_to_chardate(p_end_date, calendar_aware=> FND_DATE.calendar_aware_alt));
871: fnd_msg_pub.add;
872: x_return_status := fnd_api.g_ret_sts_error;

Line 869: fnd_message.set_token('START_DATE_PER_2', fnd_date.date_to_chardate(p_start_date, calendar_aware=> FND_DATE.calendar_aware_alt));

865: fnd_message.set_name('AR', 'AR_DATE_OVERLAPP');
866: --Int'l Calendar Project
867: fnd_message.set_token('START_DATE_PER_1', fnd_date.date_to_chardate(l_start_date, calendar_aware=> FND_DATE.calendar_aware_alt));
868: fnd_message.set_token('END_DATE_PER_1' , fnd_date.date_to_chardate(l_end_date, calendar_aware=> FND_DATE.calendar_aware_alt));
869: fnd_message.set_token('START_DATE_PER_2', fnd_date.date_to_chardate(p_start_date, calendar_aware=> FND_DATE.calendar_aware_alt));
870: fnd_message.set_token('END_DATE_PER_2' , fnd_date.date_to_chardate(p_end_date, calendar_aware=> FND_DATE.calendar_aware_alt));
871: fnd_msg_pub.add;
872: x_return_status := fnd_api.g_ret_sts_error;
873: END IF;

Line 870: fnd_message.set_token('END_DATE_PER_2' , fnd_date.date_to_chardate(p_end_date, calendar_aware=> FND_DATE.calendar_aware_alt));

866: --Int'l Calendar Project
867: fnd_message.set_token('START_DATE_PER_1', fnd_date.date_to_chardate(l_start_date, calendar_aware=> FND_DATE.calendar_aware_alt));
868: fnd_message.set_token('END_DATE_PER_1' , fnd_date.date_to_chardate(l_end_date, calendar_aware=> FND_DATE.calendar_aware_alt));
869: fnd_message.set_token('START_DATE_PER_2', fnd_date.date_to_chardate(p_start_date, calendar_aware=> FND_DATE.calendar_aware_alt));
870: fnd_message.set_token('END_DATE_PER_2' , fnd_date.date_to_chardate(p_end_date, calendar_aware=> FND_DATE.calendar_aware_alt));
871: fnd_msg_pub.add;
872: x_return_status := fnd_api.g_ret_sts_error;
873: END IF;
874: END IF;

Line 892: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

888: -- Validate STATUS lookup code in lookup type REGISTRY_STATUS
889: -------------------------------------------------------------
890: arp_standard.debug(' Validate status +');
891: IF p_status = fnd_api.g_miss_char THEN
892: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
893: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'status' );
894: FND_MSG_PUB.ADD;
895: x_return_status := FND_API.G_RET_STS_ERROR;
896: END IF;

Line 893: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'status' );

889: -------------------------------------------------------------
890: arp_standard.debug(' Validate status +');
891: IF p_status = fnd_api.g_miss_char THEN
892: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
893: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'status' );
894: FND_MSG_PUB.ADD;
895: x_return_status := FND_API.G_RET_STS_ERROR;
896: END IF;
897:

Line 901: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_LOOKUP' );

897:
898: IF p_status IS NOT NULL THEN
899: IF validate_lookup('REGISTRY_STATUS',p_status) = FALSE THEN
900: arp_standard.debug(' status should be lookup code for the lookup type REGISTRY_STATUS');
901: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_LOOKUP' );
902: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'status' );
903: FND_MESSAGE.SET_TOKEN( 'LOOKUP_TYPE', 'REGISTRY_STATUS' );
904: FND_MSG_PUB.ADD;
905: x_return_status := FND_API.G_RET_STS_ERROR;

Line 902: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'status' );

898: IF p_status IS NOT NULL THEN
899: IF validate_lookup('REGISTRY_STATUS',p_status) = FALSE THEN
900: arp_standard.debug(' status should be lookup code for the lookup type REGISTRY_STATUS');
901: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_LOOKUP' );
902: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'status' );
903: FND_MESSAGE.SET_TOKEN( 'LOOKUP_TYPE', 'REGISTRY_STATUS' );
904: FND_MSG_PUB.ADD;
905: x_return_status := FND_API.G_RET_STS_ERROR;
906: END IF;

Line 903: FND_MESSAGE.SET_TOKEN( 'LOOKUP_TYPE', 'REGISTRY_STATUS' );

899: IF validate_lookup('REGISTRY_STATUS',p_status) = FALSE THEN
900: arp_standard.debug(' status should be lookup code for the lookup type REGISTRY_STATUS');
901: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_LOOKUP' );
902: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'status' );
903: FND_MESSAGE.SET_TOKEN( 'LOOKUP_TYPE', 'REGISTRY_STATUS' );
904: FND_MSG_PUB.ADD;
905: x_return_status := FND_API.G_RET_STS_ERROR;
906: END IF;
907: END IF;

Line 911: FND_MESSAGE.SET_NAME( 'AR', 'AR_NO_REACTIVATE_ALLOW' );

907: END IF;
908:
909: IF p_old_status = 'I' AND p_status = 'A' THEN
910: arp_standard.debug(' Schedule Header can not be reactivated');
911: FND_MESSAGE.SET_NAME( 'AR', 'AR_NO_REACTIVATE_ALLOW' );
912: FND_MSG_PUB.ADD;
913: x_return_status := FND_API.G_RET_STS_ERROR;
914: END IF;
915:

Line 927: fnd_message.set_name('AR', 'HZ_API_DATE_GREATER');

923: l_val := compare(date1 => p_start_date,
924: date2 => p_end_date );
925: IF l_val = 1 THEN
926: arp_standard.debug(' end date should be greater than the start date');
927: fnd_message.set_name('AR', 'HZ_API_DATE_GREATER');
928: fnd_message.set_token('DATE2', 'end_date');
929: fnd_message.set_token('DATE1', 'start_date');
930: fnd_msg_pub.add;
931: x_return_status := fnd_api.g_ret_sts_error;

Line 928: fnd_message.set_token('DATE2', 'end_date');

924: date2 => p_end_date );
925: IF l_val = 1 THEN
926: arp_standard.debug(' end date should be greater than the start date');
927: fnd_message.set_name('AR', 'HZ_API_DATE_GREATER');
928: fnd_message.set_token('DATE2', 'end_date');
929: fnd_message.set_token('DATE1', 'start_date');
930: fnd_msg_pub.add;
931: x_return_status := fnd_api.g_ret_sts_error;
932: END IF;

Line 929: fnd_message.set_token('DATE1', 'start_date');

925: IF l_val = 1 THEN
926: arp_standard.debug(' end date should be greater than the start date');
927: fnd_message.set_name('AR', 'HZ_API_DATE_GREATER');
928: fnd_message.set_token('DATE2', 'end_date');
929: fnd_message.set_token('DATE1', 'start_date');
930: fnd_msg_pub.add;
931: x_return_status := fnd_api.g_ret_sts_error;
932: END IF;
933: IF x_return_status = fnd_api.g_ret_sts_success THEN

Line 951: fnd_message.set_name('AR', 'AR_DATE_OVERLAPP');

947: ELSE
948: arp_standard.debug(' overlapping issue :');
949: arp_standard.debug(' existing start :'||l_start_date|| ' end :'||l_end_date);
950: arp_standard.debug(' entered start :'||p_start_date|| ' end :'||p_end_date);
951: fnd_message.set_name('AR', 'AR_DATE_OVERLAPP');
952: --Int'l Calendar Project
953: fnd_message.set_token('START_DATE_PER_1', fnd_date.date_to_chardate(l_start_date, calendar_aware=> FND_DATE.calendar_aware_alt));
954: fnd_message.set_token('END_DATE_PER_1' , fnd_date.date_to_chardate(l_end_date, calendar_aware=> FND_DATE.calendar_aware_alt));
955: fnd_message.set_token('START_DATE_PER_2', fnd_date.date_to_chardate(p_start_date, calendar_aware=> FND_DATE.calendar_aware_alt));

Line 953: fnd_message.set_token('START_DATE_PER_1', fnd_date.date_to_chardate(l_start_date, calendar_aware=> FND_DATE.calendar_aware_alt));

949: arp_standard.debug(' existing start :'||l_start_date|| ' end :'||l_end_date);
950: arp_standard.debug(' entered start :'||p_start_date|| ' end :'||p_end_date);
951: fnd_message.set_name('AR', 'AR_DATE_OVERLAPP');
952: --Int'l Calendar Project
953: fnd_message.set_token('START_DATE_PER_1', fnd_date.date_to_chardate(l_start_date, calendar_aware=> FND_DATE.calendar_aware_alt));
954: fnd_message.set_token('END_DATE_PER_1' , fnd_date.date_to_chardate(l_end_date, calendar_aware=> FND_DATE.calendar_aware_alt));
955: fnd_message.set_token('START_DATE_PER_2', fnd_date.date_to_chardate(p_start_date, calendar_aware=> FND_DATE.calendar_aware_alt));
956: fnd_message.set_token('END_DATE_PER_2' , fnd_date.date_to_chardate(p_end_date, calendar_aware=> FND_DATE.calendar_aware_alt));
957: fnd_msg_pub.add;

Line 954: fnd_message.set_token('END_DATE_PER_1' , fnd_date.date_to_chardate(l_end_date, calendar_aware=> FND_DATE.calendar_aware_alt));

950: arp_standard.debug(' entered start :'||p_start_date|| ' end :'||p_end_date);
951: fnd_message.set_name('AR', 'AR_DATE_OVERLAPP');
952: --Int'l Calendar Project
953: fnd_message.set_token('START_DATE_PER_1', fnd_date.date_to_chardate(l_start_date, calendar_aware=> FND_DATE.calendar_aware_alt));
954: fnd_message.set_token('END_DATE_PER_1' , fnd_date.date_to_chardate(l_end_date, calendar_aware=> FND_DATE.calendar_aware_alt));
955: fnd_message.set_token('START_DATE_PER_2', fnd_date.date_to_chardate(p_start_date, calendar_aware=> FND_DATE.calendar_aware_alt));
956: fnd_message.set_token('END_DATE_PER_2' , fnd_date.date_to_chardate(p_end_date, calendar_aware=> FND_DATE.calendar_aware_alt));
957: fnd_msg_pub.add;
958: x_return_status := fnd_api.g_ret_sts_error;

Line 955: fnd_message.set_token('START_DATE_PER_2', fnd_date.date_to_chardate(p_start_date, calendar_aware=> FND_DATE.calendar_aware_alt));

951: fnd_message.set_name('AR', 'AR_DATE_OVERLAPP');
952: --Int'l Calendar Project
953: fnd_message.set_token('START_DATE_PER_1', fnd_date.date_to_chardate(l_start_date, calendar_aware=> FND_DATE.calendar_aware_alt));
954: fnd_message.set_token('END_DATE_PER_1' , fnd_date.date_to_chardate(l_end_date, calendar_aware=> FND_DATE.calendar_aware_alt));
955: fnd_message.set_token('START_DATE_PER_2', fnd_date.date_to_chardate(p_start_date, calendar_aware=> FND_DATE.calendar_aware_alt));
956: fnd_message.set_token('END_DATE_PER_2' , fnd_date.date_to_chardate(p_end_date, calendar_aware=> FND_DATE.calendar_aware_alt));
957: fnd_msg_pub.add;
958: x_return_status := fnd_api.g_ret_sts_error;
959: END IF;

Line 956: fnd_message.set_token('END_DATE_PER_2' , fnd_date.date_to_chardate(p_end_date, calendar_aware=> FND_DATE.calendar_aware_alt));

952: --Int'l Calendar Project
953: fnd_message.set_token('START_DATE_PER_1', fnd_date.date_to_chardate(l_start_date, calendar_aware=> FND_DATE.calendar_aware_alt));
954: fnd_message.set_token('END_DATE_PER_1' , fnd_date.date_to_chardate(l_end_date, calendar_aware=> FND_DATE.calendar_aware_alt));
955: fnd_message.set_token('START_DATE_PER_2', fnd_date.date_to_chardate(p_start_date, calendar_aware=> FND_DATE.calendar_aware_alt));
956: fnd_message.set_token('END_DATE_PER_2' , fnd_date.date_to_chardate(p_end_date, calendar_aware=> FND_DATE.calendar_aware_alt));
957: fnd_msg_pub.add;
958: x_return_status := fnd_api.g_ret_sts_error;
959: END IF;
960: END IF;

Line 1031: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

1027: -------------------------------------
1028: arp_standard.debug(' Validate schedule_header_id +');
1029:
1030: IF p_schedule_header_id IS NULL OR p_schedule_header_id = fnd_api.g_miss_num THEN
1031: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
1032: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'schedule_header_id' );
1033: FND_MSG_PUB.ADD;
1034: x_return_status := FND_API.G_RET_STS_ERROR;
1035: END IF;

Line 1032: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'schedule_header_id' );

1028: arp_standard.debug(' Validate schedule_header_id +');
1029:
1030: IF p_schedule_header_id IS NULL OR p_schedule_header_id = fnd_api.g_miss_num THEN
1031: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
1032: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'schedule_header_id' );
1033: FND_MSG_PUB.ADD;
1034: x_return_status := FND_API.G_RET_STS_ERROR;
1035: END IF;
1036:

Line 1040: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');

1036:
1037: OPEN c_header;
1038: FETCH c_header INTO l_rec;
1039: IF c_header%NOTFOUND THEN
1040: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
1041: FND_MESSAGE.SET_TOKEN('FK', 'schedule header');
1042: FND_MESSAGE.SET_TOKEN('COLUMN', 'schedule_header_id');
1043: FND_MESSAGE.SET_TOKEN('TABLE', 'ar_charge_schedule_hdrs');
1044: FND_MSG_PUB.ADD;

Line 1041: FND_MESSAGE.SET_TOKEN('FK', 'schedule header');

1037: OPEN c_header;
1038: FETCH c_header INTO l_rec;
1039: IF c_header%NOTFOUND THEN
1040: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
1041: FND_MESSAGE.SET_TOKEN('FK', 'schedule header');
1042: FND_MESSAGE.SET_TOKEN('COLUMN', 'schedule_header_id');
1043: FND_MESSAGE.SET_TOKEN('TABLE', 'ar_charge_schedule_hdrs');
1044: FND_MSG_PUB.ADD;
1045: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1042: FND_MESSAGE.SET_TOKEN('COLUMN', 'schedule_header_id');

1038: FETCH c_header INTO l_rec;
1039: IF c_header%NOTFOUND THEN
1040: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
1041: FND_MESSAGE.SET_TOKEN('FK', 'schedule header');
1042: FND_MESSAGE.SET_TOKEN('COLUMN', 'schedule_header_id');
1043: FND_MESSAGE.SET_TOKEN('TABLE', 'ar_charge_schedule_hdrs');
1044: FND_MSG_PUB.ADD;
1045: x_return_status := FND_API.G_RET_STS_ERROR;
1046: END IF;

Line 1043: FND_MESSAGE.SET_TOKEN('TABLE', 'ar_charge_schedule_hdrs');

1039: IF c_header%NOTFOUND THEN
1040: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
1041: FND_MESSAGE.SET_TOKEN('FK', 'schedule header');
1042: FND_MESSAGE.SET_TOKEN('COLUMN', 'schedule_header_id');
1043: FND_MESSAGE.SET_TOKEN('TABLE', 'ar_charge_schedule_hdrs');
1044: FND_MSG_PUB.ADD;
1045: x_return_status := FND_API.G_RET_STS_ERROR;
1046: END IF;
1047: CLOSE c_header;

Line 1056: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

1052: -- Validate schedule_id
1053: ------------------------
1054: arp_standard.debug(' Validate schedule_id +');
1055: IF p_schedule_id IS NULL OR p_schedule_id = fnd_api.g_miss_num THEN
1056: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
1057: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'schedule_id' );
1058: FND_MSG_PUB.ADD;
1059: x_return_status := FND_API.G_RET_STS_ERROR;
1060: ELSE

Line 1057: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'schedule_id' );

1053: ------------------------
1054: arp_standard.debug(' Validate schedule_id +');
1055: IF p_schedule_id IS NULL OR p_schedule_id = fnd_api.g_miss_num THEN
1056: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
1057: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'schedule_id' );
1058: FND_MSG_PUB.ADD;
1059: x_return_status := FND_API.G_RET_STS_ERROR;
1060: ELSE
1061: IF p_schedule_id <> l_rec.schedule_id THEN

Line 1062: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');

1058: FND_MSG_PUB.ADD;
1059: x_return_status := FND_API.G_RET_STS_ERROR;
1060: ELSE
1061: IF p_schedule_id <> l_rec.schedule_id THEN
1062: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
1063: FND_MESSAGE.SET_TOKEN('FK', 'schedule header');
1064: FND_MESSAGE.SET_TOKEN('COLUMN', 'schedule_id');
1065: FND_MESSAGE.SET_TOKEN('TABLE', 'ar_charge_schedule_hdrs');
1066: FND_MSG_PUB.ADD;

Line 1063: FND_MESSAGE.SET_TOKEN('FK', 'schedule header');

1059: x_return_status := FND_API.G_RET_STS_ERROR;
1060: ELSE
1061: IF p_schedule_id <> l_rec.schedule_id THEN
1062: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
1063: FND_MESSAGE.SET_TOKEN('FK', 'schedule header');
1064: FND_MESSAGE.SET_TOKEN('COLUMN', 'schedule_id');
1065: FND_MESSAGE.SET_TOKEN('TABLE', 'ar_charge_schedule_hdrs');
1066: FND_MSG_PUB.ADD;
1067: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1064: FND_MESSAGE.SET_TOKEN('COLUMN', 'schedule_id');

1060: ELSE
1061: IF p_schedule_id <> l_rec.schedule_id THEN
1062: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
1063: FND_MESSAGE.SET_TOKEN('FK', 'schedule header');
1064: FND_MESSAGE.SET_TOKEN('COLUMN', 'schedule_id');
1065: FND_MESSAGE.SET_TOKEN('TABLE', 'ar_charge_schedule_hdrs');
1066: FND_MSG_PUB.ADD;
1067: x_return_status := FND_API.G_RET_STS_ERROR;
1068: END IF;

Line 1065: FND_MESSAGE.SET_TOKEN('TABLE', 'ar_charge_schedule_hdrs');

1061: IF p_schedule_id <> l_rec.schedule_id THEN
1062: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
1063: FND_MESSAGE.SET_TOKEN('FK', 'schedule header');
1064: FND_MESSAGE.SET_TOKEN('COLUMN', 'schedule_id');
1065: FND_MESSAGE.SET_TOKEN('TABLE', 'ar_charge_schedule_hdrs');
1066: FND_MSG_PUB.ADD;
1067: x_return_status := FND_API.G_RET_STS_ERROR;
1068: END IF;
1069: END IF;

Line 1078: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

1074: -- Validate aging_bucket_id
1075: ---------------------------
1076: arp_standard.debug(' Validate aging_bucket_id +');
1077: IF P_AGING_BUCKET_ID IS NULL OR P_AGING_BUCKET_ID = fnd_api.g_miss_num THEN
1078: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
1079: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'P_AGING_BUCKET_ID' );
1080: FND_MSG_PUB.ADD;
1081: x_return_status := FND_API.G_RET_STS_ERROR;
1082: ELSE

Line 1079: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'P_AGING_BUCKET_ID' );

1075: ---------------------------
1076: arp_standard.debug(' Validate aging_bucket_id +');
1077: IF P_AGING_BUCKET_ID IS NULL OR P_AGING_BUCKET_ID = fnd_api.g_miss_num THEN
1078: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
1079: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'P_AGING_BUCKET_ID' );
1080: FND_MSG_PUB.ADD;
1081: x_return_status := FND_API.G_RET_STS_ERROR;
1082: ELSE
1083: IF P_AGING_BUCKET_ID <> l_rec.aging_bucket_id THEN

Line 1084: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');

1080: FND_MSG_PUB.ADD;
1081: x_return_status := FND_API.G_RET_STS_ERROR;
1082: ELSE
1083: IF P_AGING_BUCKET_ID <> l_rec.aging_bucket_id THEN
1084: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
1085: FND_MESSAGE.SET_TOKEN('FK', 'schedule header');
1086: FND_MESSAGE.SET_TOKEN('COLUMN', 'aging_bucket_id');
1087: FND_MESSAGE.SET_TOKEN('TABLE', 'ar_charge_schedule_hdrs');
1088: FND_MSG_PUB.ADD;

Line 1085: FND_MESSAGE.SET_TOKEN('FK', 'schedule header');

1081: x_return_status := FND_API.G_RET_STS_ERROR;
1082: ELSE
1083: IF P_AGING_BUCKET_ID <> l_rec.aging_bucket_id THEN
1084: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
1085: FND_MESSAGE.SET_TOKEN('FK', 'schedule header');
1086: FND_MESSAGE.SET_TOKEN('COLUMN', 'aging_bucket_id');
1087: FND_MESSAGE.SET_TOKEN('TABLE', 'ar_charge_schedule_hdrs');
1088: FND_MSG_PUB.ADD;
1089: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1086: FND_MESSAGE.SET_TOKEN('COLUMN', 'aging_bucket_id');

1082: ELSE
1083: IF P_AGING_BUCKET_ID <> l_rec.aging_bucket_id THEN
1084: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
1085: FND_MESSAGE.SET_TOKEN('FK', 'schedule header');
1086: FND_MESSAGE.SET_TOKEN('COLUMN', 'aging_bucket_id');
1087: FND_MESSAGE.SET_TOKEN('TABLE', 'ar_charge_schedule_hdrs');
1088: FND_MSG_PUB.ADD;
1089: x_return_status := FND_API.G_RET_STS_ERROR;
1090: END IF;

Line 1087: FND_MESSAGE.SET_TOKEN('TABLE', 'ar_charge_schedule_hdrs');

1083: IF P_AGING_BUCKET_ID <> l_rec.aging_bucket_id THEN
1084: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
1085: FND_MESSAGE.SET_TOKEN('FK', 'schedule header');
1086: FND_MESSAGE.SET_TOKEN('COLUMN', 'aging_bucket_id');
1087: FND_MESSAGE.SET_TOKEN('TABLE', 'ar_charge_schedule_hdrs');
1088: FND_MSG_PUB.ADD;
1089: x_return_status := FND_API.G_RET_STS_ERROR;
1090: END IF;
1091: END IF;

Line 1107: fnd_message.set_name('AR', 'AR_API_REC_COMB_EXISTS');

1103: FETCH ar_schedule_line_u2 INTO l_c;
1104: IF ar_schedule_line_u2%FOUND THEN
1105: arp_standard.debug(' A Record in ar_charge_schedule_lines exists with '||
1106: ' schedule_header_id - aging_bucket_id - aging_bucket_line_id');
1107: fnd_message.set_name('AR', 'AR_API_REC_COMB_EXISTS');
1108: fnd_message.set_token('COLUMN1', 'schedule_header_id');
1109: fnd_message.set_token('COLUMN2', 'aging_bucket_id');
1110: fnd_message.set_token('COLUMN3', 'aging_bucket_line_id');
1111: fnd_msg_pub.add;

Line 1108: fnd_message.set_token('COLUMN1', 'schedule_header_id');

1104: IF ar_schedule_line_u2%FOUND THEN
1105: arp_standard.debug(' A Record in ar_charge_schedule_lines exists with '||
1106: ' schedule_header_id - aging_bucket_id - aging_bucket_line_id');
1107: fnd_message.set_name('AR', 'AR_API_REC_COMB_EXISTS');
1108: fnd_message.set_token('COLUMN1', 'schedule_header_id');
1109: fnd_message.set_token('COLUMN2', 'aging_bucket_id');
1110: fnd_message.set_token('COLUMN3', 'aging_bucket_line_id');
1111: fnd_msg_pub.add;
1112: x_return_status := fnd_api.g_ret_sts_error;

Line 1109: fnd_message.set_token('COLUMN2', 'aging_bucket_id');

1105: arp_standard.debug(' A Record in ar_charge_schedule_lines exists with '||
1106: ' schedule_header_id - aging_bucket_id - aging_bucket_line_id');
1107: fnd_message.set_name('AR', 'AR_API_REC_COMB_EXISTS');
1108: fnd_message.set_token('COLUMN1', 'schedule_header_id');
1109: fnd_message.set_token('COLUMN2', 'aging_bucket_id');
1110: fnd_message.set_token('COLUMN3', 'aging_bucket_line_id');
1111: fnd_msg_pub.add;
1112: x_return_status := fnd_api.g_ret_sts_error;
1113: END IF;

Line 1110: fnd_message.set_token('COLUMN3', 'aging_bucket_line_id');

1106: ' schedule_header_id - aging_bucket_id - aging_bucket_line_id');
1107: fnd_message.set_name('AR', 'AR_API_REC_COMB_EXISTS');
1108: fnd_message.set_token('COLUMN1', 'schedule_header_id');
1109: fnd_message.set_token('COLUMN2', 'aging_bucket_id');
1110: fnd_message.set_token('COLUMN3', 'aging_bucket_line_id');
1111: fnd_msg_pub.add;
1112: x_return_status := fnd_api.g_ret_sts_error;
1113: END IF;
1114: CLOSE ar_schedule_line_u2;

Line 1126: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

1122: IF p_aging_bucket_line_id IS NULL OR p_aging_bucket_line_id = fnd_api.g_miss_num
1123: THEN
1124: IF p_aging_bucket_line_id IS NULL or p_aging_bucket_line_id = fnd_api.g_miss_num THEN
1125: arp_standard.debug(' AGING_BUCKET_LINE_ID missing');
1126: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
1127: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'AGING_BUCKET_LINE_ID' );
1128: FND_MSG_PUB.ADD;
1129: x_return_status := FND_API.G_RET_STS_ERROR;
1130: END IF;

Line 1127: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'AGING_BUCKET_LINE_ID' );

1123: THEN
1124: IF p_aging_bucket_line_id IS NULL or p_aging_bucket_line_id = fnd_api.g_miss_num THEN
1125: arp_standard.debug(' AGING_BUCKET_LINE_ID missing');
1126: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
1127: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'AGING_BUCKET_LINE_ID' );
1128: FND_MSG_PUB.ADD;
1129: x_return_status := FND_API.G_RET_STS_ERROR;
1130: END IF;
1131: ELSE

Line 1137: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );

1133: OPEN c_aging_bucket_id(p_aging_bucket_id, p_aging_bucket_line_id);
1134: FETCH c_aging_bucket_id INTO l_c;
1135: IF c_aging_bucket_id%NOTFOUND THEN
1136: arp_standard.debug(' AGING_BUCKET_ID/AGING_BUCKET_LINE_ID are not valid');
1137: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
1138: FND_MESSAGE.SET_TOKEN( 'FK', 'aging_bucket_id' );
1139: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'aging_bucket_id' );
1140: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_aging_buckets');
1141: FND_MSG_PUB.ADD;

Line 1138: FND_MESSAGE.SET_TOKEN( 'FK', 'aging_bucket_id' );

1134: FETCH c_aging_bucket_id INTO l_c;
1135: IF c_aging_bucket_id%NOTFOUND THEN
1136: arp_standard.debug(' AGING_BUCKET_ID/AGING_BUCKET_LINE_ID are not valid');
1137: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
1138: FND_MESSAGE.SET_TOKEN( 'FK', 'aging_bucket_id' );
1139: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'aging_bucket_id' );
1140: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_aging_buckets');
1141: FND_MSG_PUB.ADD;
1142: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );

Line 1139: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'aging_bucket_id' );

1135: IF c_aging_bucket_id%NOTFOUND THEN
1136: arp_standard.debug(' AGING_BUCKET_ID/AGING_BUCKET_LINE_ID are not valid');
1137: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
1138: FND_MESSAGE.SET_TOKEN( 'FK', 'aging_bucket_id' );
1139: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'aging_bucket_id' );
1140: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_aging_buckets');
1141: FND_MSG_PUB.ADD;
1142: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
1143: FND_MESSAGE.SET_TOKEN( 'FK', 'aging_bucket_line_id' );

Line 1140: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_aging_buckets');

1136: arp_standard.debug(' AGING_BUCKET_ID/AGING_BUCKET_LINE_ID are not valid');
1137: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
1138: FND_MESSAGE.SET_TOKEN( 'FK', 'aging_bucket_id' );
1139: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'aging_bucket_id' );
1140: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_aging_buckets');
1141: FND_MSG_PUB.ADD;
1142: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
1143: FND_MESSAGE.SET_TOKEN( 'FK', 'aging_bucket_line_id' );
1144: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'aging_bucket_line_id' );

Line 1142: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );

1138: FND_MESSAGE.SET_TOKEN( 'FK', 'aging_bucket_id' );
1139: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'aging_bucket_id' );
1140: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_aging_buckets');
1141: FND_MSG_PUB.ADD;
1142: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
1143: FND_MESSAGE.SET_TOKEN( 'FK', 'aging_bucket_line_id' );
1144: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'aging_bucket_line_id' );
1145: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_aging_bucket_lines_b');
1146: FND_MSG_PUB.ADD;

Line 1143: FND_MESSAGE.SET_TOKEN( 'FK', 'aging_bucket_line_id' );

1139: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'aging_bucket_id' );
1140: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_aging_buckets');
1141: FND_MSG_PUB.ADD;
1142: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
1143: FND_MESSAGE.SET_TOKEN( 'FK', 'aging_bucket_line_id' );
1144: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'aging_bucket_line_id' );
1145: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_aging_bucket_lines_b');
1146: FND_MSG_PUB.ADD;
1147: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1144: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'aging_bucket_line_id' );

1140: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_aging_buckets');
1141: FND_MSG_PUB.ADD;
1142: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
1143: FND_MESSAGE.SET_TOKEN( 'FK', 'aging_bucket_line_id' );
1144: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'aging_bucket_line_id' );
1145: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_aging_bucket_lines_b');
1146: FND_MSG_PUB.ADD;
1147: x_return_status := FND_API.G_RET_STS_ERROR;
1148: END IF;

Line 1145: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_aging_bucket_lines_b');

1141: FND_MSG_PUB.ADD;
1142: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
1143: FND_MESSAGE.SET_TOKEN( 'FK', 'aging_bucket_line_id' );
1144: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'aging_bucket_line_id' );
1145: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_aging_bucket_lines_b');
1146: FND_MSG_PUB.ADD;
1147: x_return_status := FND_API.G_RET_STS_ERROR;
1148: END IF;
1149: CLOSE c_aging_bucket_id;

Line 1169: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');

1165: IF (p_amount IS NULL OR p_amount = FND_API.G_MISS_NUM) AND
1166: (l_c = 'AMOUNT')
1167: THEN
1168: arp_standard.debug(' The amount column is mandatory for SCHEDULE_HEADER_TYPE :'||l_c);
1169: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
1170: fnd_message.set_token('COLUMN', 'AMOUNT');
1171: FND_MSG_PUB.ADD;
1172: x_return_status := FND_API.G_RET_STS_ERROR;
1173: END IF;

Line 1170: fnd_message.set_token('COLUMN', 'AMOUNT');

1166: (l_c = 'AMOUNT')
1167: THEN
1168: arp_standard.debug(' The amount column is mandatory for SCHEDULE_HEADER_TYPE :'||l_c);
1169: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
1170: fnd_message.set_token('COLUMN', 'AMOUNT');
1171: FND_MSG_PUB.ADD;
1172: x_return_status := FND_API.G_RET_STS_ERROR;
1173: END IF;
1174:

Line 1179: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');

1175: IF (p_rate IS NULL OR p_rate = FND_API.G_MISS_NUM) AND
1176: (l_c = 'PERCENTAGE')
1177: THEN
1178: arp_standard.debug(' The rate column is mandatory for SCHEDULE_HEADER_TYPE:'||l_c);
1179: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
1180: fnd_message.set_token('COLUMN', 'RATE');
1181: fnd_msg_pub.add;
1182: FND_MSG_PUB.ADD;
1183: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1180: fnd_message.set_token('COLUMN', 'RATE');

1176: (l_c = 'PERCENTAGE')
1177: THEN
1178: arp_standard.debug(' The rate column is mandatory for SCHEDULE_HEADER_TYPE:'||l_c);
1179: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
1180: fnd_message.set_token('COLUMN', 'RATE');
1181: fnd_msg_pub.add;
1182: FND_MSG_PUB.ADD;
1183: x_return_status := FND_API.G_RET_STS_ERROR;
1184: END IF;

Line 1300: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

1296:
1297: WHEN OTHERS THEN
1298: ROLLBACK TO create_schedule;
1299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1300: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1301: FND_MESSAGE.SET_TOKEN('ERROR' ,l_n||' '||SQLERRM);
1302: FND_MSG_PUB.ADD;
1303: FND_MSG_PUB.Count_And_Get(
1304: p_encoded => FND_API.G_FALSE,

Line 1301: FND_MESSAGE.SET_TOKEN('ERROR' ,l_n||' '||SQLERRM);

1297: WHEN OTHERS THEN
1298: ROLLBACK TO create_schedule;
1299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1300: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1301: FND_MESSAGE.SET_TOKEN('ERROR' ,l_n||' '||SQLERRM);
1302: FND_MSG_PUB.ADD;
1303: FND_MSG_PUB.Count_And_Get(
1304: p_encoded => FND_API.G_FALSE,
1305: p_count => x_msg_count,

Line 1399: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');

1395: l_rec.OBJECT_VERSION_NUMBER;
1396: CLOSE c;
1397:
1398: IF l_rec.SCHEDULE_ID IS NULL THEN
1399: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1400: fnd_message.set_token('RECORD', 'ar_charge_schedules');
1401: fnd_message.set_token('VALUE',
1402: NVL(TO_CHAR(P_SCHEDULE_ID), 'null'));
1403: fnd_msg_pub.add;

Line 1400: fnd_message.set_token('RECORD', 'ar_charge_schedules');

1396: CLOSE c;
1397:
1398: IF l_rec.SCHEDULE_ID IS NULL THEN
1399: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1400: fnd_message.set_token('RECORD', 'ar_charge_schedules');
1401: fnd_message.set_token('VALUE',
1402: NVL(TO_CHAR(P_SCHEDULE_ID), 'null'));
1403: fnd_msg_pub.add;
1404: RAISE fnd_api.g_exc_error;

Line 1401: fnd_message.set_token('VALUE',

1397:
1398: IF l_rec.SCHEDULE_ID IS NULL THEN
1399: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1400: fnd_message.set_token('RECORD', 'ar_charge_schedules');
1401: fnd_message.set_token('VALUE',
1402: NVL(TO_CHAR(P_SCHEDULE_ID), 'null'));
1403: fnd_msg_pub.add;
1404: RAISE fnd_api.g_exc_error;
1405: END IF;

Line 1414: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');

1410: (x_object_version_number IS NOT NULL AND
1411: l_rec.OBJECT_VERSION_NUMBER IS NOT NULL AND
1412: x_object_version_number = l_rec.OBJECT_VERSION_NUMBER))
1413: THEN
1414: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
1415: fnd_message.set_token('TABLE', 'ar_charge_schedules');
1416: fnd_msg_pub.add;
1417: RAISE fnd_api.g_exc_error;
1418: END IF;

Line 1415: fnd_message.set_token('TABLE', 'ar_charge_schedules');

1411: l_rec.OBJECT_VERSION_NUMBER IS NOT NULL AND
1412: x_object_version_number = l_rec.OBJECT_VERSION_NUMBER))
1413: THEN
1414: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
1415: fnd_message.set_token('TABLE', 'ar_charge_schedules');
1416: fnd_msg_pub.add;
1417: RAISE fnd_api.g_exc_error;
1418: END IF;
1419:

Line 1471: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

1467:
1468: WHEN OTHERS THEN
1469: ROLLBACK TO Update_schedule;
1470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1471: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1472: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1473: FND_MSG_PUB.ADD;
1474: FND_MSG_PUB.Count_And_Get(
1475: p_encoded => FND_API.G_FALSE,

Line 1472: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

1468: WHEN OTHERS THEN
1469: ROLLBACK TO Update_schedule;
1470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1471: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1472: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1473: FND_MSG_PUB.ADD;
1474: FND_MSG_PUB.Count_And_Get(
1475: p_encoded => FND_API.G_FALSE,
1476: p_count => x_msg_count,

Line 1604: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

1600:
1601: WHEN OTHERS THEN
1602: ROLLBACK TO create_schedule_header;
1603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1604: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1605: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1606: FND_MSG_PUB.ADD;
1607: FND_MSG_PUB.Count_And_Get(
1608: p_encoded => FND_API.G_FALSE,

Line 1605: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

1601: WHEN OTHERS THEN
1602: ROLLBACK TO create_schedule_header;
1603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1604: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1605: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1606: FND_MSG_PUB.ADD;
1607: FND_MSG_PUB.Count_And_Get(
1608: p_encoded => FND_API.G_FALSE,
1609: p_count => x_msg_count,

Line 1714: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');

1710: l_rec.status;
1711: CLOSE c;
1712:
1713: IF l_rec.SCHEDULE_HEADER_ID IS NULL THEN
1714: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1715: fnd_message.set_token('RECORD', 'ar_charge_schedule_hdrs');
1716: fnd_message.set_token('VALUE',
1717: NVL(TO_CHAR(P_SCHEDULE_HEADER_ID), 'null'));
1718: fnd_msg_pub.add;

Line 1715: fnd_message.set_token('RECORD', 'ar_charge_schedule_hdrs');

1711: CLOSE c;
1712:
1713: IF l_rec.SCHEDULE_HEADER_ID IS NULL THEN
1714: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1715: fnd_message.set_token('RECORD', 'ar_charge_schedule_hdrs');
1716: fnd_message.set_token('VALUE',
1717: NVL(TO_CHAR(P_SCHEDULE_HEADER_ID), 'null'));
1718: fnd_msg_pub.add;
1719: RAISE fnd_api.g_exc_error;

Line 1716: fnd_message.set_token('VALUE',

1712:
1713: IF l_rec.SCHEDULE_HEADER_ID IS NULL THEN
1714: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1715: fnd_message.set_token('RECORD', 'ar_charge_schedule_hdrs');
1716: fnd_message.set_token('VALUE',
1717: NVL(TO_CHAR(P_SCHEDULE_HEADER_ID), 'null'));
1718: fnd_msg_pub.add;
1719: RAISE fnd_api.g_exc_error;
1720: END IF;

Line 1729: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');

1725: (x_object_version_number IS NOT NULL AND
1726: l_rec.OBJECT_VERSION_NUMBER IS NOT NULL AND
1727: x_object_version_number = l_rec.OBJECT_VERSION_NUMBER))
1728: THEN
1729: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
1730: fnd_message.set_token('TABLE', 'ar_charge_schedule_hdrs');
1731: fnd_msg_pub.add;
1732: RAISE fnd_api.g_exc_error;
1733: END IF;

Line 1730: fnd_message.set_token('TABLE', 'ar_charge_schedule_hdrs');

1726: l_rec.OBJECT_VERSION_NUMBER IS NOT NULL AND
1727: x_object_version_number = l_rec.OBJECT_VERSION_NUMBER))
1728: THEN
1729: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
1730: fnd_message.set_token('TABLE', 'ar_charge_schedule_hdrs');
1731: fnd_msg_pub.add;
1732: RAISE fnd_api.g_exc_error;
1733: END IF;
1734:

Line 1794: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

1790:
1791: WHEN OTHERS THEN
1792: ROLLBACK TO Update_schedule_header;
1793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1794: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1795: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1796: FND_MSG_PUB.ADD;
1797: FND_MSG_PUB.Count_And_Get(
1798: p_encoded => FND_API.G_FALSE,

Line 1795: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

1791: WHEN OTHERS THEN
1792: ROLLBACK TO Update_schedule_header;
1793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1794: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1795: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1796: FND_MSG_PUB.ADD;
1797: FND_MSG_PUB.Count_And_Get(
1798: p_encoded => FND_API.G_FALSE,
1799: p_count => x_msg_count,

Line 1925: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

1921:
1922: WHEN OTHERS THEN
1923: ROLLBACK TO create_schedule_line;
1924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1925: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1926: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1927: FND_MSG_PUB.ADD;
1928: FND_MSG_PUB.Count_And_Get(
1929: p_encoded => FND_API.G_FALSE,

Line 1926: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

1922: WHEN OTHERS THEN
1923: ROLLBACK TO create_schedule_line;
1924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1925: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1926: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1927: FND_MSG_PUB.ADD;
1928: FND_MSG_PUB.Count_And_Get(
1929: p_encoded => FND_API.G_FALSE,
1930: p_count => x_msg_count,

Line 2031: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');

2027: l_rec.OBJECT_VERSION_NUMBER;
2028: CLOSE c;
2029:
2030: IF l_rec.SCHEDULE_line_ID IS NULL THEN
2031: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
2032: fnd_message.set_token('RECORD', 'ar_charge_schedule_lines');
2033: fnd_message.set_token('VALUE',
2034: NVL(TO_CHAR(P_SCHEDULE_line_ID), 'null'));
2035: fnd_msg_pub.add;

Line 2032: fnd_message.set_token('RECORD', 'ar_charge_schedule_lines');

2028: CLOSE c;
2029:
2030: IF l_rec.SCHEDULE_line_ID IS NULL THEN
2031: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
2032: fnd_message.set_token('RECORD', 'ar_charge_schedule_lines');
2033: fnd_message.set_token('VALUE',
2034: NVL(TO_CHAR(P_SCHEDULE_line_ID), 'null'));
2035: fnd_msg_pub.add;
2036: RAISE fnd_api.g_exc_error;

Line 2033: fnd_message.set_token('VALUE',

2029:
2030: IF l_rec.SCHEDULE_line_ID IS NULL THEN
2031: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
2032: fnd_message.set_token('RECORD', 'ar_charge_schedule_lines');
2033: fnd_message.set_token('VALUE',
2034: NVL(TO_CHAR(P_SCHEDULE_line_ID), 'null'));
2035: fnd_msg_pub.add;
2036: RAISE fnd_api.g_exc_error;
2037: END IF;

Line 2046: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');

2042: (x_object_version_number IS NOT NULL AND
2043: l_rec.OBJECT_VERSION_NUMBER IS NOT NULL AND
2044: x_object_version_number = l_rec.OBJECT_VERSION_NUMBER))
2045: THEN
2046: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
2047: fnd_message.set_token('TABLE', 'ar_charge_schedule_lines');
2048: fnd_msg_pub.add;
2049: RAISE fnd_api.g_exc_error;
2050: END IF;

Line 2047: fnd_message.set_token('TABLE', 'ar_charge_schedule_lines');

2043: l_rec.OBJECT_VERSION_NUMBER IS NOT NULL AND
2044: x_object_version_number = l_rec.OBJECT_VERSION_NUMBER))
2045: THEN
2046: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
2047: fnd_message.set_token('TABLE', 'ar_charge_schedule_lines');
2048: fnd_msg_pub.add;
2049: RAISE fnd_api.g_exc_error;
2050: END IF;
2051:

Line 2110: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

2106:
2107: WHEN OTHERS THEN
2108: ROLLBACK TO Update_schedule_header;
2109: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2110: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2111: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2112: FND_MSG_PUB.ADD;
2113: FND_MSG_PUB.Count_And_Get(
2114: p_encoded => FND_API.G_FALSE,

Line 2111: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

2107: WHEN OTHERS THEN
2108: ROLLBACK TO Update_schedule_header;
2109: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2110: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2111: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2112: FND_MSG_PUB.ADD;
2113: FND_MSG_PUB.Count_And_Get(
2114: p_encoded => FND_API.G_FALSE,
2115: p_count => x_msg_count,