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 870: fnd_msg_pub.add;

866: fnd_message.set_token('START_DATE_PER_1', l_start_date);
867: fnd_message.set_token('END_DATE_PER_1' , l_end_date);
868: fnd_message.set_token('START_DATE_PER_2', p_start_date);
869: fnd_message.set_token('END_DATE_PER_2' , p_end_date);
870: fnd_msg_pub.add;
871: x_return_status := fnd_api.g_ret_sts_error;
872: END IF;
873: END IF;
874: IF x_return_status <> fnd_api.g_ret_sts_success THEN

Line 893: FND_MSG_PUB.ADD;

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

Line 903: FND_MSG_PUB.ADD;

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

Line 911: FND_MSG_PUB.ADD;

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

Line 929: fnd_msg_pub.add;

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

Line 955: fnd_msg_pub.add;

951: fnd_message.set_token('START_DATE_PER_1', l_start_date);
952: fnd_message.set_token('END_DATE_PER_1' , l_end_date);
953: fnd_message.set_token('START_DATE_PER_2', p_start_date);
954: fnd_message.set_token('END_DATE_PER_2' , p_end_date);
955: fnd_msg_pub.add;
956: x_return_status := fnd_api.g_ret_sts_error;
957: END IF;
958: END IF;
959: IF x_return_status <> fnd_api.g_ret_sts_success THEN

Line 1031: FND_MSG_PUB.ADD;

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

Line 1042: FND_MSG_PUB.ADD;

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

Line 1056: FND_MSG_PUB.ADD;

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

Line 1064: FND_MSG_PUB.ADD;

1060: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
1061: FND_MESSAGE.SET_TOKEN('FK', 'schedule header');
1062: FND_MESSAGE.SET_TOKEN('COLUMN', 'schedule_id');
1063: FND_MESSAGE.SET_TOKEN('TABLE', 'ar_charge_schedule_hdrs');
1064: FND_MSG_PUB.ADD;
1065: x_return_status := FND_API.G_RET_STS_ERROR;
1066: END IF;
1067: END IF;
1068: arp_standard.debug(' Validate schedule_id -');

Line 1078: FND_MSG_PUB.ADD;

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

Line 1086: FND_MSG_PUB.ADD;

1082: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
1083: FND_MESSAGE.SET_TOKEN('FK', 'schedule header');
1084: FND_MESSAGE.SET_TOKEN('COLUMN', 'aging_bucket_id');
1085: FND_MESSAGE.SET_TOKEN('TABLE', 'ar_charge_schedule_hdrs');
1086: FND_MSG_PUB.ADD;
1087: x_return_status := FND_API.G_RET_STS_ERROR;
1088: END IF;
1089: END IF;
1090: arp_standard.debug(' Validate aging_bucket_id -');

Line 1109: fnd_msg_pub.add;

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

Line 1126: FND_MSG_PUB.ADD;

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

Line 1139: FND_MSG_PUB.ADD;

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

Line 1144: FND_MSG_PUB.ADD;

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

Line 1169: FND_MSG_PUB.ADD;

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

Line 1179: fnd_msg_pub.add;

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

Line 1180: FND_MSG_PUB.ADD;

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

Line 1232: fnd_msg_pub.initialize;

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

Line 1289: FND_MSG_PUB.Count_And_Get(

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

Line 1300: FND_MSG_PUB.ADD;

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

Line 1301: FND_MSG_PUB.Count_And_Get(

1297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1298: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1299: FND_MESSAGE.SET_TOKEN('ERROR' ,l_n||' '||SQLERRM);
1300: FND_MSG_PUB.ADD;
1301: FND_MSG_PUB.Count_And_Get(
1302: p_encoded => FND_API.G_FALSE,
1303: p_count => x_msg_count,
1304: p_data => x_msg_data);
1305: arp_standard.debug('EXCEPTION create_schedule:'||x_msg_data);

Line 1367: fnd_msg_pub.initialize;

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

Line 1401: fnd_msg_pub.add;

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

Line 1414: fnd_msg_pub.add;

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

Line 1460: FND_MSG_PUB.Count_And_Get(

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

Line 1471: FND_MSG_PUB.ADD;

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

Line 1472: FND_MSG_PUB.Count_And_Get(

1468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1469: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1470: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1471: FND_MSG_PUB.ADD;
1472: FND_MSG_PUB.Count_And_Get(
1473: p_encoded => FND_API.G_FALSE,
1474: p_count => x_msg_count,
1475: p_data => x_msg_data);
1476: arp_standard.debug('EXCEPTION Update_schedule:'||x_msg_data);

Line 1529: fnd_msg_pub.initialize;

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

Line 1593: FND_MSG_PUB.Count_And_Get(

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

Line 1604: FND_MSG_PUB.ADD;

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

Line 1605: FND_MSG_PUB.Count_And_Get(

1601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1602: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1603: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1604: FND_MSG_PUB.ADD;
1605: FND_MSG_PUB.Count_And_Get(
1606: p_encoded => FND_API.G_FALSE,
1607: p_count => x_msg_count,
1608: p_data => x_msg_data);
1609: arp_standard.debug('EXCEPTION create_schedule_header:'||x_msg_data);

Line 1678: fnd_msg_pub.initialize;

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

Line 1716: fnd_msg_pub.add;

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

Line 1729: fnd_msg_pub.add;

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

Line 1783: FND_MSG_PUB.Count_And_Get(

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

Line 1794: FND_MSG_PUB.ADD;

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

Line 1795: FND_MSG_PUB.Count_And_Get(

1791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1792: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1793: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1794: FND_MSG_PUB.ADD;
1795: FND_MSG_PUB.Count_And_Get(
1796: p_encoded => FND_API.G_FALSE,
1797: p_count => x_msg_count,
1798: p_data => x_msg_data);
1799: arp_standard.debug('EXCEPTION Update_schedule_header:'||x_msg_data);

Line 1852: fnd_msg_pub.initialize;

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

Line 1914: FND_MSG_PUB.Count_And_Get(

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

Line 1925: FND_MSG_PUB.ADD;

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

Line 1926: FND_MSG_PUB.Count_And_Get(

1922: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1923: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1924: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1925: FND_MSG_PUB.ADD;
1926: FND_MSG_PUB.Count_And_Get(
1927: p_encoded => FND_API.G_FALSE,
1928: p_count => x_msg_count,
1929: p_data => x_msg_data);
1930: arp_standard.debug('EXCEPTION create_schedule_line :'||x_msg_data);

Line 1997: fnd_msg_pub.initialize;

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

Line 2033: fnd_msg_pub.add;

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

Line 2046: fnd_msg_pub.add;

2042: x_object_version_number = l_rec.OBJECT_VERSION_NUMBER))
2043: THEN
2044: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
2045: fnd_message.set_token('TABLE', 'ar_charge_schedule_lines');
2046: fnd_msg_pub.add;
2047: RAISE fnd_api.g_exc_error;
2048: END IF;
2049:
2050: /* This would be the place to call validate_line

Line 2099: FND_MSG_PUB.Count_And_Get(

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

Line 2110: FND_MSG_PUB.ADD;

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

Line 2111: FND_MSG_PUB.Count_And_Get(

2107: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2108: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2109: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2110: FND_MSG_PUB.ADD;
2111: FND_MSG_PUB.Count_And_Get(
2112: p_encoded => FND_API.G_FALSE,
2113: p_count => x_msg_count,
2114: p_data => x_msg_data);
2115: arp_standard.debug('EXCEPTION Update_schedule_line:'||x_msg_data);