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.HZ_PREFERENCE_PUB dependencies on FND_MESSAGE

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

63: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
64: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
65:
66: WHEN OTHERS THEN
67: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
68: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
69: FND_MSG_PUB.ADD;
70: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
71:

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

64: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
65:
66: WHEN OTHERS THEN
67: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
68: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
69: FND_MSG_PUB.ADD;
70: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
71:
72: END Contains_Value;

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

115: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
116: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
117:
118: WHEN OTHERS THEN
119: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
120: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
121: FND_MSG_PUB.ADD;
122: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
123:

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

116: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
117:
118: WHEN OTHERS THEN
119: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
120: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
121: FND_MSG_PUB.ADD;
122: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
123:
124: END Contains_Preference;

Line 154: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PREFERENCE');

150: p_value_number IS NULL) and
151: (p_value_date = FND_API.G_MISS_DATE OR
152: p_value_date IS NULL)
153: then
154: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PREFERENCE');
155: FND_MSG_PUB.ADD;
156: RAISE FND_API.G_EXC_ERROR;
157: end if;
158:

Line 173: FND_MESSAGE.SET_NAME('AR', 'HZ_MULTIPLE_PREFERENCES');

169: p_value_date IS NOT NULL AND
170: p_value_varchar2 <> FND_API.G_MISS_CHAR AND
171: p_value_varchar2 IS NOT NULL)
172: then
173: FND_MESSAGE.SET_NAME('AR', 'HZ_MULTIPLE_PREFERENCES');
174: FND_MSG_PUB.ADD;
175: RAISE FND_API.G_EXC_ERROR;
176: end if;
177:

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

202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
203: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
204:
205: WHEN OTHERS THEN
206: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
207: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
208: FND_MSG_PUB.ADD;
209: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
210:

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

203: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
204:
205: WHEN OTHERS THEN
206: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
207: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
208: FND_MSG_PUB.ADD;
209: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
210:
211: END Contains_Value;

Line 271: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PREFERENCE');

267: p_value_number IS NULL) AND
268: (p_value_date = FND_API.G_MISS_DATE OR
269: p_value_date IS NULL)
270: then
271: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PREFERENCE');
272: FND_MSG_PUB.ADD;
273: RAISE FND_API.G_EXC_ERROR;
274: end if;
275:

Line 290: FND_MESSAGE.SET_NAME('AR', 'HZ_MULTIPLE_PREFERENCES');

286: p_value_date IS NOT NULL AND
287: p_value_varchar2 <> FND_API.G_MISS_CHAR AND
288: p_value_varchar2 IS NOT NULL)
289: then
290: FND_MESSAGE.SET_NAME('AR', 'HZ_MULTIPLE_PREFERENCES');
291: FND_MSG_PUB.ADD;
292: RAISE FND_API.G_EXC_ERROR;
293: end if;
294:

Line 305: FND_MESSAGE.SET_NAME('AR', 'HZ_SINGLE_VALUE_PREFERENCE');

301: if l_multiple_value_flag = 'N' then -- single-value preference
302: if Contains_Preference(p_party_id,
303: p_category,
304: p_preference_code) = 'Y' then -- already one preference value set
305: FND_MESSAGE.SET_NAME('AR', 'HZ_SINGLE_VALUE_PREFERENCE');
306: FND_MSG_PUB.ADD;
307: RAISE FND_API.G_EXC_ERROR;
308: end if;
309: end if;

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

386: WHEN OTHERS THEN
387: ROLLBACK TO add_preference;
388:
389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
390: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
391: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
392: FND_MSG_PUB.ADD;
393:
394: FND_MSG_PUB.Count_And_Get(

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

387: ROLLBACK TO add_preference;
388:
389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
390: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
391: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
392: FND_MSG_PUB.ADD;
393:
394: FND_MSG_PUB.Count_And_Get(
395: p_encoded => FND_API.G_FALSE,

Line 461: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PREFERENCE');

457: p_value_number IS NULL) AND
458: (p_value_date = FND_API.G_MISS_DATE OR
459: p_value_date IS NULL)
460: then
461: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PREFERENCE');
462: FND_MSG_PUB.ADD;
463: RAISE FND_API.G_EXC_ERROR;
464: end if;
465:

Line 480: FND_MESSAGE.SET_NAME('AR', 'HZ_MULTIPLE_PREFERENCES');

476: p_value_date IS NOT NULL AND
477: p_value_varchar2 <> FND_API.G_MISS_CHAR AND
478: p_value_varchar2 IS NOT NULL)
479: then
480: FND_MESSAGE.SET_NAME('AR', 'HZ_MULTIPLE_PREFERENCES');
481: FND_MSG_PUB.ADD;
482: RAISE FND_API.G_EXC_ERROR;
483: end if;
484:

Line 547: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');

543:
544: -- check if the object_version_numbers match
545: if o_object_version_number <> p_object_version_number
546: then
547: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
548: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTY_PREFERENCES');
549: FND_MSG_PUB.ADD;
550: RAISE FND_API.G_EXC_ERROR;
551: end if;

Line 548: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTY_PREFERENCES');

544: -- check if the object_version_numbers match
545: if o_object_version_number <> p_object_version_number
546: then
547: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
548: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTY_PREFERENCES');
549: FND_MSG_PUB.ADD;
550: RAISE FND_API.G_EXC_ERROR;
551: end if;
552: l_object_version_number := o_object_version_number + 1;

Line 651: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');

647:
648: -- check if the object_version_numbers match
649: if o_object_version_number <> p_object_version_number
650: then
651: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
652: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTY_PREFERENCES');
653: FND_MSG_PUB.ADD;
654: RAISE FND_API.G_EXC_ERROR;
655: end if;

Line 652: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTY_PREFERENCES');

648: -- check if the object_version_numbers match
649: if o_object_version_number <> p_object_version_number
650: then
651: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
652: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTY_PREFERENCES');
653: FND_MSG_PUB.ADD;
654: RAISE FND_API.G_EXC_ERROR;
655: end if;
656: l_object_version_number := o_object_version_number + 1;

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

731: WHEN OTHERS THEN
732: ROLLBACK TO put_preference;
733:
734: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
735: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
736: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
737: FND_MSG_PUB.ADD;
738:
739: FND_MSG_PUB.Count_And_Get(

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

732: ROLLBACK TO put_preference;
733:
734: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
735: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
736: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
737: FND_MSG_PUB.ADD;
738:
739: FND_MSG_PUB.Count_And_Get(
740: p_encoded => FND_API.G_FALSE,

Line 794: FND_MESSAGE.SET_NAME('AR', 'HZ_MULTIPLE_PREFERENCES');

790: p_value_date IS NOT NULL AND
791: p_value_varchar2 <> FND_API.G_MISS_CHAR AND
792: p_value_varchar2 IS NOT NULL)
793: then
794: FND_MESSAGE.SET_NAME('AR', 'HZ_MULTIPLE_PREFERENCES');
795: FND_MSG_PUB.ADD;
796: RAISE FND_API.G_EXC_ERROR;
797: end if;
798:

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

894: WHEN OTHERS THEN
895: ROLLBACK TO remove_preference;
896:
897: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
898: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
899: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
900: FND_MSG_PUB.ADD;
901: FND_MSG_PUB.Count_And_Get(
902: p_encoded => FND_API.G_FALSE,

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

895: ROLLBACK TO remove_preference;
896:
897: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
898: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
899: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
900: FND_MSG_PUB.ADD;
901: FND_MSG_PUB.Count_And_Get(
902: p_encoded => FND_API.G_FALSE,
903: p_count => x_msg_count,

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

965: p_data => x_msg_data);
966:
967: WHEN OTHERS THEN
968: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
969: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
970: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
971: FND_MSG_PUB.ADD;
972: FND_MSG_PUB.Count_And_Get(
973: p_encoded => FND_API.G_FALSE,

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

966:
967: WHEN OTHERS THEN
968: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
969: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
970: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
971: FND_MSG_PUB.ADD;
972: FND_MSG_PUB.Count_And_Get(
973: p_encoded => FND_API.G_FALSE,
974: p_count => x_msg_count,

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

1027: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1028: RETURN NULL;
1029:
1030: WHEN OTHERS THEN
1031: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1032: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1033: FND_MSG_PUB.ADD;
1034: RETURN NULL;
1035:

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

1028: RETURN NULL;
1029:
1030: WHEN OTHERS THEN
1031: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1032: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1033: FND_MSG_PUB.ADD;
1034: RETURN NULL;
1035:
1036: END;

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

1085: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1086: RETURN NULL;
1087:
1088: WHEN OTHERS THEN
1089: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1090: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1091: FND_MSG_PUB.ADD;
1092: RETURN NULL;
1093:

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

1086: RETURN NULL;
1087:
1088: WHEN OTHERS THEN
1089: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1090: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1091: FND_MSG_PUB.ADD;
1092: RETURN NULL;
1093:
1094: END;

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

1144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1145: RETURN NULL;
1146:
1147: WHEN OTHERS THEN
1148: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1149: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1150: FND_MSG_PUB.ADD;
1151: RETURN NULL;
1152:

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

1145: RETURN NULL;
1146:
1147: WHEN OTHERS THEN
1148: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1149: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1150: FND_MSG_PUB.ADD;
1151: RETURN NULL;
1152:
1153: END;

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

1198: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1199: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
1200:
1201: WHEN OTHERS THEN
1202: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1203: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1204: FND_MSG_PUB.ADD;
1205: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
1206:

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

1199: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
1200:
1201: WHEN OTHERS THEN
1202: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1203: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1204: FND_MSG_PUB.ADD;
1205: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
1206:
1207: END Contains_Value;

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

1252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1253: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
1254:
1255: WHEN OTHERS THEN
1256: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1257: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1258: FND_MSG_PUB.ADD;
1259: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
1260:

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

1253: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
1254:
1255: WHEN OTHERS THEN
1256: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1257: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1258: FND_MSG_PUB.ADD;
1259: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
1260:
1261: END Contains_Value;

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

1274:
1275: -- check whether party id has been passed in.
1276: IF p_party_id IS NULL OR
1277: p_party_id = FND_API.G_MISS_NUM THEN
1278: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
1279: FND_MESSAGE.SET_TOKEN('COLUMN', 'party id');
1280: FND_MSG_PUB.ADD;
1281: RAISE FND_API.G_EXC_ERROR;
1282: END IF;

Line 1279: FND_MESSAGE.SET_TOKEN('COLUMN', 'party id');

1275: -- check whether party id has been passed in.
1276: IF p_party_id IS NULL OR
1277: p_party_id = FND_API.G_MISS_NUM THEN
1278: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
1279: FND_MESSAGE.SET_TOKEN('COLUMN', 'party id');
1280: FND_MSG_PUB.ADD;
1281: RAISE FND_API.G_EXC_ERROR;
1282: END IF;
1283:

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

1283:
1284: -- check whether category has been passed in.
1285: IF p_category IS NULL OR
1286: p_category = FND_API.G_MISS_CHAR THEN
1287: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
1288: FND_MESSAGE.SET_TOKEN('COLUMN', 'category');
1289: FND_MSG_PUB.ADD;
1290: RAISE FND_API.G_EXC_ERROR;
1291: END IF;

Line 1288: FND_MESSAGE.SET_TOKEN('COLUMN', 'category');

1284: -- check whether category has been passed in.
1285: IF p_category IS NULL OR
1286: p_category = FND_API.G_MISS_CHAR THEN
1287: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
1288: FND_MESSAGE.SET_TOKEN('COLUMN', 'category');
1289: FND_MSG_PUB.ADD;
1290: RAISE FND_API.G_EXC_ERROR;
1291: END IF;
1292:

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

1292:
1293: -- check whether preference code has been passed in.
1294: IF p_preference_code IS NULL OR
1295: p_preference_code = FND_API.G_MISS_CHAR THEN
1296: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
1297: FND_MESSAGE.SET_TOKEN('COLUMN', 'preference code');
1298: FND_MSG_PUB.ADD;
1299: RAISE FND_API.G_EXC_ERROR;
1300: END IF;

Line 1297: FND_MESSAGE.SET_TOKEN('COLUMN', 'preference code');

1293: -- check whether preference code has been passed in.
1294: IF p_preference_code IS NULL OR
1295: p_preference_code = FND_API.G_MISS_CHAR THEN
1296: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
1297: FND_MESSAGE.SET_TOKEN('COLUMN', 'preference code');
1298: FND_MSG_PUB.ADD;
1299: RAISE FND_API.G_EXC_ERROR;
1300: END IF;
1301:

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

1305: from hz_parties
1306: where party_id = p_party_id;
1307: exception
1308: when no_data_found then
1309: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
1310: FND_MESSAGE.SET_TOKEN('FK', 'party id');
1311: FND_MESSAGE.SET_TOKEN('COLUMN' ,'party_id');
1312: FND_MESSAGE.SET_TOKEN('TABLE' ,'HZ_PARTIES');
1313: FND_MSG_PUB.ADD;

Line 1310: FND_MESSAGE.SET_TOKEN('FK', 'party id');

1306: where party_id = p_party_id;
1307: exception
1308: when no_data_found then
1309: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
1310: FND_MESSAGE.SET_TOKEN('FK', 'party id');
1311: FND_MESSAGE.SET_TOKEN('COLUMN' ,'party_id');
1312: FND_MESSAGE.SET_TOKEN('TABLE' ,'HZ_PARTIES');
1313: FND_MSG_PUB.ADD;
1314: RAISE FND_API.G_EXC_ERROR;

Line 1311: FND_MESSAGE.SET_TOKEN('COLUMN' ,'party_id');

1307: exception
1308: when no_data_found then
1309: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
1310: FND_MESSAGE.SET_TOKEN('FK', 'party id');
1311: FND_MESSAGE.SET_TOKEN('COLUMN' ,'party_id');
1312: FND_MESSAGE.SET_TOKEN('TABLE' ,'HZ_PARTIES');
1313: FND_MSG_PUB.ADD;
1314: RAISE FND_API.G_EXC_ERROR;
1315: when others then

Line 1312: FND_MESSAGE.SET_TOKEN('TABLE' ,'HZ_PARTIES');

1308: when no_data_found then
1309: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
1310: FND_MESSAGE.SET_TOKEN('FK', 'party id');
1311: FND_MESSAGE.SET_TOKEN('COLUMN' ,'party_id');
1312: FND_MESSAGE.SET_TOKEN('TABLE' ,'HZ_PARTIES');
1313: FND_MSG_PUB.ADD;
1314: RAISE FND_API.G_EXC_ERROR;
1315: when others then
1316: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

1335: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1337:
1338: WHEN OTHERS THEN
1339: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1340: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1341: FND_MSG_PUB.ADD;
1342:
1343: END validate;

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

1336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1337:
1338: WHEN OTHERS THEN
1339: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1340: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1341: FND_MSG_PUB.ADD;
1342:
1343: END validate;
1344:

Line 1367: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');

1363: FETCH c_party INTO l_exists;
1364: CLOSE c_party;
1365: EXCEPTION
1366: WHEN OTHERS THEN
1367: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1368: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTIES');
1369: FND_MSG_PUB.ADD;
1370: RAISE FND_API.G_EXC_ERROR;
1371: END;

Line 1368: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTIES');

1364: CLOSE c_party;
1365: EXCEPTION
1366: WHEN OTHERS THEN
1367: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1368: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTIES');
1369: FND_MSG_PUB.ADD;
1370: RAISE FND_API.G_EXC_ERROR;
1371: END;
1372: