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

APPS.AR_CHARGE_SCHEDULE_PKG dependencies on FND_MSG_PUB

Line 91: FND_MSG_PUB.ADD;

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:
95:

Line 184: FND_MSG_PUB.ADD;

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:
188:

Line 288: FND_MSG_PUB.ADD;

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:
292:

Line 394: FND_MSG_PUB.ADD;

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:
398:

Line 498: FND_MSG_PUB.ADD;

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:
502: PROCEDURE update_Line_Row

Line 596: FND_MSG_PUB.ADD;

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:
600:

Line 675: FND_MSG_PUB.ADD;

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;
679: arp_standard.debug(' Validate schedule_name -');

Line 739: FND_MSG_PUB.ADD;

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;
743: FETCH c_schedule_id INTO l_c;

Line 749: FND_MSG_PUB.ADD;

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;
753: arp_standard.debug(' Validate schedule_id -');

Line 762: FND_MSG_PUB.ADD;

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:
766: IF validate_lookup('SCHEDULE_HEADER_TYPE',p_schedule_header_type) = FALSE THEN

Line 771: FND_MSG_PUB.ADD;

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

Line 784: FND_MSG_PUB.ADD;

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:
788: IF validate_lookup('REGISTRY_STATUS',p_status) = FALSE THEN

Line 793: FND_MSG_PUB.ADD;

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

Line 813: FND_MSG_PUB.ADD;

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;
817: END IF;

Line 830: FND_MSG_PUB.ADD;

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:
834: l_val := compare(date1 => p_start_date,

Line 842: fnd_msg_pub.add;

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:
846:

Line 871: fnd_msg_pub.add;

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;
875: IF x_return_status <> fnd_api.g_ret_sts_success THEN

Line 894: FND_MSG_PUB.ADD;

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:
898: IF p_status IS NOT NULL THEN

Line 904: FND_MSG_PUB.ADD;

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;
908:

Line 912: FND_MSG_PUB.ADD;

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:
916: arp_standard.debug(' Validate status -');

Line 930: fnd_msg_pub.add;

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
934: arp_standard.debug(' Check overlappings of periods');

Line 957: fnd_msg_pub.add;

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;
961: IF x_return_status <> fnd_api.g_ret_sts_success THEN

Line 1033: FND_MSG_PUB.ADD;

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:
1037: OPEN c_header;

Line 1044: FND_MSG_PUB.ADD;

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;
1048: arp_standard.debug(' Validate schedule_header_id -');

Line 1058: FND_MSG_PUB.ADD;

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
1062: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');

Line 1066: FND_MSG_PUB.ADD;

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;
1070: arp_standard.debug(' Validate schedule_id -');

Line 1080: FND_MSG_PUB.ADD;

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
1084: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');

Line 1088: FND_MSG_PUB.ADD;

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;
1092: arp_standard.debug(' Validate aging_bucket_id -');

Line 1111: fnd_msg_pub.add;

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;
1115: arp_standard.debug(' unidicity of ar_schedule_line_u2 -');

Line 1128: FND_MSG_PUB.ADD;

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
1132: IF p_aging_bucket_id IS NOT NULL AND p_aging_bucket_id <> FND_API.G_MISS_NUM THEN

Line 1141: FND_MSG_PUB.ADD;

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' );
1145: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_aging_bucket_lines_b');

Line 1146: 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;
1150: END IF;

Line 1171: FND_MSG_PUB.ADD;

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:
1175: IF (p_rate IS NULL OR p_rate = FND_API.G_MISS_NUM) AND

Line 1181: fnd_msg_pub.add;

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;
1185: arp_standard.debug(' validate amount or rate -');

Line 1182: FND_MSG_PUB.ADD;

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;
1185: arp_standard.debug(' validate amount or rate -');
1186: END;

Line 1234: fnd_msg_pub.initialize;

1230:
1231: x_return_status := fnd_api.G_RET_STS_SUCCESS;
1232:
1233: IF fnd_api.to_boolean(p_init_msg_list) THEN
1234: fnd_msg_pub.initialize;
1235: END IF;
1236:
1237: l_n := 1;
1238:

Line 1291: FND_MSG_PUB.Count_And_Get(

1287:
1288: EXCEPTION
1289: WHEN FND_API.G_EXC_ERROR THEN
1290: ROLLBACK TO create_schedule;
1291: FND_MSG_PUB.Count_And_Get(
1292: p_encoded => FND_API.G_FALSE,
1293: p_count => x_msg_count,
1294: p_data => x_msg_data);
1295: arp_standard.debug('EXCEPTION create_schedule:'||x_msg_data);

Line 1302: FND_MSG_PUB.ADD;

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,
1306: p_data => x_msg_data);

Line 1303: FND_MSG_PUB.Count_And_Get(

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,
1306: p_data => x_msg_data);
1307: arp_standard.debug('EXCEPTION create_schedule:'||x_msg_data);

Line 1369: fnd_msg_pub.initialize;

1365:
1366: SAVEPOINT update_schedule;
1367:
1368: IF fnd_api.to_boolean(p_init_msg_list) THEN
1369: fnd_msg_pub.initialize;
1370: END IF;
1371:
1372: x_return_status := fnd_api.G_RET_STS_SUCCESS;
1373:

Line 1403: fnd_msg_pub.add;

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;
1406:
1407:

Line 1416: fnd_msg_pub.add;

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:
1420:

Line 1462: FND_MSG_PUB.Count_And_Get(

1458:
1459: EXCEPTION
1460: WHEN FND_API.G_EXC_ERROR THEN
1461: ROLLBACK TO Update_schedule;
1462: FND_MSG_PUB.Count_And_Get(
1463: p_encoded => FND_API.G_FALSE,
1464: p_count => x_msg_count,
1465: p_data => x_msg_data);
1466: arp_standard.debug('EXCEPTION Update_schedule:'||x_msg_data);

Line 1473: FND_MSG_PUB.ADD;

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,
1477: p_data => x_msg_data);

Line 1474: FND_MSG_PUB.Count_And_Get(

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,
1477: p_data => x_msg_data);
1478: arp_standard.debug('EXCEPTION Update_schedule:'||x_msg_data);

Line 1531: fnd_msg_pub.initialize;

1527:
1528: x_return_status := fnd_api.G_RET_STS_SUCCESS;
1529:
1530: IF fnd_api.to_boolean(p_init_msg_list) THEN
1531: fnd_msg_pub.initialize;
1532: END IF;
1533:
1534:
1535: validate_schedule_header

Line 1595: FND_MSG_PUB.Count_And_Get(

1591:
1592: EXCEPTION
1593: WHEN FND_API.G_EXC_ERROR THEN
1594: ROLLBACK TO create_schedule_header;
1595: FND_MSG_PUB.Count_And_Get(
1596: p_encoded => FND_API.G_FALSE,
1597: p_count => x_msg_count,
1598: p_data => x_msg_data);
1599: arp_standard.debug('EXCEPTION create_schedule_header:'||x_msg_data);

Line 1606: FND_MSG_PUB.ADD;

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,
1610: p_data => x_msg_data);

Line 1607: FND_MSG_PUB.Count_And_Get(

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,
1610: p_data => x_msg_data);
1611: arp_standard.debug('EXCEPTION create_schedule_header:'||x_msg_data);

Line 1680: fnd_msg_pub.initialize;

1676:
1677: savepoint Update_schedule_header;
1678:
1679: IF fnd_api.to_boolean(p_init_msg_list) THEN
1680: fnd_msg_pub.initialize;
1681: END IF;
1682:
1683: x_return_status := fnd_api.G_RET_STS_SUCCESS;
1684:

Line 1718: fnd_msg_pub.add;

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;
1721:
1722:

Line 1731: fnd_msg_pub.add;

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:
1735:

Line 1785: FND_MSG_PUB.Count_And_Get(

1781:
1782: EXCEPTION
1783: WHEN FND_API.G_EXC_ERROR THEN
1784: ROLLBACK TO Update_schedule_header;
1785: FND_MSG_PUB.Count_And_Get(
1786: p_encoded => FND_API.G_FALSE,
1787: p_count => x_msg_count,
1788: p_data => x_msg_data);
1789: arp_standard.debug('EXCEPTION Update_schedule_header:'||x_msg_data);

Line 1796: FND_MSG_PUB.ADD;

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,
1800: p_data => x_msg_data);

Line 1797: FND_MSG_PUB.Count_And_Get(

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,
1800: p_data => x_msg_data);
1801: arp_standard.debug('EXCEPTION Update_schedule_header:'||x_msg_data);

Line 1854: fnd_msg_pub.initialize;

1850:
1851: x_return_status := fnd_api.G_RET_STS_SUCCESS;
1852:
1853: IF fnd_api.to_boolean(p_init_msg_list) THEN
1854: fnd_msg_pub.initialize;
1855: END IF;
1856:
1857: validate_schedule_line
1858: (P_SCHEDULE_LINE_ID => l_line_id,

Line 1916: FND_MSG_PUB.Count_And_Get(

1912:
1913: EXCEPTION
1914: WHEN FND_API.G_EXC_ERROR THEN
1915: ROLLBACK TO create_schedule_line;
1916: FND_MSG_PUB.Count_And_Get(
1917: p_encoded => FND_API.G_FALSE,
1918: p_count => x_msg_count,
1919: p_data => x_msg_data);
1920: arp_standard.debug('EXCEPTION create_schedule_line :'||x_msg_data);

Line 1927: FND_MSG_PUB.ADD;

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,
1931: p_data => x_msg_data);

Line 1928: FND_MSG_PUB.Count_And_Get(

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,
1931: p_data => x_msg_data);
1932: arp_standard.debug('EXCEPTION create_schedule_line :'||x_msg_data);

Line 1999: fnd_msg_pub.initialize;

1995:
1996: savepoint Update_schedule_line;
1997:
1998: IF fnd_api.to_boolean(p_init_msg_list) THEN
1999: fnd_msg_pub.initialize;
2000: END IF;
2001:
2002: x_return_status := fnd_api.G_RET_STS_SUCCESS;
2003:

Line 2035: fnd_msg_pub.add;

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;
2038:
2039:

Line 2048: fnd_msg_pub.add;

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:
2052: /* This would be the place to call validate_line

Line 2101: FND_MSG_PUB.Count_And_Get(

2097:
2098: EXCEPTION
2099: WHEN FND_API.G_EXC_ERROR THEN
2100: ROLLBACK TO Update_schedule_line;
2101: FND_MSG_PUB.Count_And_Get(
2102: p_encoded => FND_API.G_FALSE,
2103: p_count => x_msg_count,
2104: p_data => x_msg_data);
2105: arp_standard.debug('EXCEPTION Update_schedule_line:'||x_msg_data);

Line 2112: FND_MSG_PUB.ADD;

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,
2116: p_data => x_msg_data);

Line 2113: FND_MSG_PUB.Count_And_Get(

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,
2116: p_data => x_msg_data);
2117: arp_standard.debug('EXCEPTION Update_schedule_line:'||x_msg_data);