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_PARTY_INFO_VAL dependencies on FND_MESSAGE

Line 178: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OBSOLETE_COLUMN' );

174: ( p_credit_ratings_rec.suit_judge_ind is null OR
175: p_credit_ratings_rec.suit_judge_ind <> FND_API.G_MISS_CHAR
176: ) )
177: THEN
178: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OBSOLETE_COLUMN' );
179: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'suit_judge_ind' );
180: FND_MSG_PUB.ADD;
181: x_return_status := FND_API.G_RET_STS_ERROR;
182: END IF;

Line 179: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'suit_judge_ind' );

175: p_credit_ratings_rec.suit_judge_ind <> FND_API.G_MISS_CHAR
176: ) )
177: THEN
178: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OBSOLETE_COLUMN' );
179: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'suit_judge_ind' );
180: FND_MSG_PUB.ADD;
181: x_return_status := FND_API.G_RET_STS_ERROR;
182: END IF;
183:

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

193: OR
194: (p_create_update_flag = 'U' AND
195: p_credit_ratings_rec.party_id IS NULL) THEN
196:
197: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
198: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');
199: FND_MSG_PUB.ADD;
200: x_return_status := FND_API.G_RET_STS_ERROR;
201:

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

194: (p_create_update_flag = 'U' AND
195: p_credit_ratings_rec.party_id IS NULL) THEN
196:
197: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
198: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');
199: FND_MSG_PUB.ADD;
200: x_return_status := FND_API.G_RET_STS_ERROR;
201:
202: END IF;

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

209: OR
210: (p_create_update_flag = 'U' AND
211: p_credit_ratings_rec.content_source_type IS NULL) THEN
212:
213: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
214: FND_MESSAGE.SET_TOKEN('COLUMN', 'content_source_type');
215: FND_MSG_PUB.ADD;
216: x_return_status := FND_API.G_RET_STS_ERROR;
217:

Line 214: FND_MESSAGE.SET_TOKEN('COLUMN', 'content_source_type');

210: (p_create_update_flag = 'U' AND
211: p_credit_ratings_rec.content_source_type IS NULL) THEN
212:
213: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
214: FND_MESSAGE.SET_TOKEN('COLUMN', 'content_source_type');
215: FND_MSG_PUB.ADD;
216: x_return_status := FND_API.G_RET_STS_ERROR;
217:
218: END IF;

Line 277: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NONUPDATEABLE_COLUMN');

273: where credit_rating_id = p_credit_ratings_rec.credit_rating_id;
274:
275: IF (p_credit_ratings_rec.party_id <> FND_API.G_MISS_NUM) AND
276: (p_credit_ratings_rec.party_id <> l_party_id) THEN
277: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NONUPDATEABLE_COLUMN');
278: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');
279: FND_MSG_PUB.ADD;
280: x_return_status := FND_API.G_RET_STS_ERROR;
281: end if;

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

274:
275: IF (p_credit_ratings_rec.party_id <> FND_API.G_MISS_NUM) AND
276: (p_credit_ratings_rec.party_id <> l_party_id) THEN
277: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NONUPDATEABLE_COLUMN');
278: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');
279: FND_MSG_PUB.ADD;
280: x_return_status := FND_API.G_RET_STS_ERROR;
281: end if;
282:

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

282:
283: -- Bug 2197181: removed validation for mix-n-match
284: /*
285: IF p_credit_ratings_rec.content_source_type <> l_content_source_type THEN
286: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NONUPDATEABLE_COLUMN');
287: FND_MESSAGE.SET_TOKEN('COLUMN', 'content_source_type');
288: FND_MSG_PUB.ADD;
289: x_return_status := FND_API.G_RET_STS_ERROR;
290: END IF;

Line 287: FND_MESSAGE.SET_TOKEN('COLUMN', 'content_source_type');

283: -- Bug 2197181: removed validation for mix-n-match
284: /*
285: IF p_credit_ratings_rec.content_source_type <> l_content_source_type THEN
286: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NONUPDATEABLE_COLUMN');
287: FND_MESSAGE.SET_TOKEN('COLUMN', 'content_source_type');
288: FND_MSG_PUB.ADD;
289: x_return_status := FND_API.G_RET_STS_ERROR;
290: END IF;
291: */

Line 294: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');

290: END IF;
291: */
292:
293: EXCEPTION WHEN NO_DATA_FOUND THEN
294: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
295: FND_MESSAGE.SET_TOKEN('RECORD', 'credit rating');
296: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_credit_ratings_rec.credit_rating_id));
297: FND_MSG_PUB.ADD;
298: x_return_status := FND_API.G_RET_STS_ERROR;

Line 295: FND_MESSAGE.SET_TOKEN('RECORD', 'credit rating');

291: */
292:
293: EXCEPTION WHEN NO_DATA_FOUND THEN
294: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
295: FND_MESSAGE.SET_TOKEN('RECORD', 'credit rating');
296: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_credit_ratings_rec.credit_rating_id));
297: FND_MSG_PUB.ADD;
298: x_return_status := FND_API.G_RET_STS_ERROR;
299: END;

Line 296: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_credit_ratings_rec.credit_rating_id));

292:
293: EXCEPTION WHEN NO_DATA_FOUND THEN
294: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
295: FND_MESSAGE.SET_TOKEN('RECORD', 'credit rating');
296: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_credit_ratings_rec.credit_rating_id));
297: FND_MSG_PUB.ADD;
298: x_return_status := FND_API.G_RET_STS_ERROR;
299: END;
300:

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

310: FROM hz_parties
311: WHERE party_id = p_credit_ratings_rec.party_id;
312:
313: IF l_count = 0 THEN
314: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
315: FND_MESSAGE.SET_TOKEN('FK', 'party_id');
316: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');
317: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_parties');
318: FND_MSG_PUB.ADD;

Line 315: FND_MESSAGE.SET_TOKEN('FK', 'party_id');

311: WHERE party_id = p_credit_ratings_rec.party_id;
312:
313: IF l_count = 0 THEN
314: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
315: FND_MESSAGE.SET_TOKEN('FK', 'party_id');
316: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');
317: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_parties');
318: FND_MSG_PUB.ADD;
319: x_return_status := FND_API.G_RET_STS_ERROR;

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

312:
313: IF l_count = 0 THEN
314: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
315: FND_MESSAGE.SET_TOKEN('FK', 'party_id');
316: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');
317: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_parties');
318: FND_MSG_PUB.ADD;
319: x_return_status := FND_API.G_RET_STS_ERROR;
320: END IF;

Line 317: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_parties');

313: IF l_count = 0 THEN
314: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
315: FND_MESSAGE.SET_TOKEN('FK', 'party_id');
316: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');
317: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_parties');
318: FND_MSG_PUB.ADD;
319: x_return_status := FND_API.G_RET_STS_ERROR;
320: END IF;
321:

Line 1255: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

1251: AND CURRENCY_FLAG = 'Y'
1252: AND ENABLED_FLAG in ('Y', 'N');
1253: EXCEPTION
1254: WHEN NO_DATA_FOUND THEN
1255: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
1256: fnd_message.set_token('FK', 'maximum_credit_currency_code');
1257: fnd_message.set_token('COLUMN', 'currency_code');
1258: fnd_message.set_token('TABLE', 'fnd_currencies');
1259: fnd_msg_pub.add;

Line 1256: fnd_message.set_token('FK', 'maximum_credit_currency_code');

1252: AND ENABLED_FLAG in ('Y', 'N');
1253: EXCEPTION
1254: WHEN NO_DATA_FOUND THEN
1255: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
1256: fnd_message.set_token('FK', 'maximum_credit_currency_code');
1257: fnd_message.set_token('COLUMN', 'currency_code');
1258: fnd_message.set_token('TABLE', 'fnd_currencies');
1259: fnd_msg_pub.add;
1260: x_return_status := fnd_api.g_ret_sts_error;

Line 1257: fnd_message.set_token('COLUMN', 'currency_code');

1253: EXCEPTION
1254: WHEN NO_DATA_FOUND THEN
1255: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
1256: fnd_message.set_token('FK', 'maximum_credit_currency_code');
1257: fnd_message.set_token('COLUMN', 'currency_code');
1258: fnd_message.set_token('TABLE', 'fnd_currencies');
1259: fnd_msg_pub.add;
1260: x_return_status := fnd_api.g_ret_sts_error;
1261: END;

Line 1258: fnd_message.set_token('TABLE', 'fnd_currencies');

1254: WHEN NO_DATA_FOUND THEN
1255: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
1256: fnd_message.set_token('FK', 'maximum_credit_currency_code');
1257: fnd_message.set_token('COLUMN', 'currency_code');
1258: fnd_message.set_token('TABLE', 'fnd_currencies');
1259: fnd_msg_pub.add;
1260: x_return_status := fnd_api.g_ret_sts_error;
1261: END;
1262:

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

1331: OR
1332: (p_create_update_flag = 'U' AND
1333: p_financial_profile_rec.party_id IS NULL) THEN
1334:
1335: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
1336: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');
1337: FND_MSG_PUB.ADD;
1338: x_return_status := FND_API.G_RET_STS_ERROR;
1339:

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

1332: (p_create_update_flag = 'U' AND
1333: p_financial_profile_rec.party_id IS NULL) THEN
1334:
1335: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
1336: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');
1337: FND_MSG_PUB.ADD;
1338: x_return_status := FND_API.G_RET_STS_ERROR;
1339:
1340: END IF;

Line 1354: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NONUPDATEABLE_COLUMN');

1350: where financial_profile_id
1351: = p_financial_profile_rec.financial_profile_id ;
1352:
1353: if l_party_id <> p_financial_profile_rec.party_id then
1354: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NONUPDATEABLE_COLUMN');
1355: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');
1356: FND_MSG_PUB.ADD;
1357: x_return_status := FND_API.G_RET_STS_ERROR;
1358: end if;

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

1351: = p_financial_profile_rec.financial_profile_id ;
1352:
1353: if l_party_id <> p_financial_profile_rec.party_id then
1354: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NONUPDATEABLE_COLUMN');
1355: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');
1356: FND_MSG_PUB.ADD;
1357: x_return_status := FND_API.G_RET_STS_ERROR;
1358: end if;
1359:

Line 1378: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_PARTY_TYPE');

1374: IF p_create_update_flag = 'C'
1375: AND l_party_type <> 'PERSON'
1376: AND l_party_type <> 'ORGANIZATION'
1377: THEN
1378: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_PARTY_TYPE');
1379: FND_MESSAGE.SET_TOKEN('PARTY_ID', to_char(p_financial_profile_rec.party_id));
1380: FND_MESSAGE.SET_TOKEN('TYPE', 'ORGANIZATION or PERSON');
1381: FND_MSG_PUB.ADD;
1382: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1379: FND_MESSAGE.SET_TOKEN('PARTY_ID', to_char(p_financial_profile_rec.party_id));

1375: AND l_party_type <> 'PERSON'
1376: AND l_party_type <> 'ORGANIZATION'
1377: THEN
1378: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_PARTY_TYPE');
1379: FND_MESSAGE.SET_TOKEN('PARTY_ID', to_char(p_financial_profile_rec.party_id));
1380: FND_MESSAGE.SET_TOKEN('TYPE', 'ORGANIZATION or PERSON');
1381: FND_MSG_PUB.ADD;
1382: x_return_status := FND_API.G_RET_STS_ERROR;
1383: END IF;

Line 1380: FND_MESSAGE.SET_TOKEN('TYPE', 'ORGANIZATION or PERSON');

1376: AND l_party_type <> 'ORGANIZATION'
1377: THEN
1378: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_PARTY_TYPE');
1379: FND_MESSAGE.SET_TOKEN('PARTY_ID', to_char(p_financial_profile_rec.party_id));
1380: FND_MESSAGE.SET_TOKEN('TYPE', 'ORGANIZATION or PERSON');
1381: FND_MSG_PUB.ADD;
1382: x_return_status := FND_API.G_RET_STS_ERROR;
1383: END IF;
1384:

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

1383: END IF;
1384:
1385: EXCEPTION
1386: WHEN NO_DATA_FOUND THEN
1387: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
1388: FND_MESSAGE.SET_TOKEN('FK', 'party_id');
1389: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');
1390: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_parties');
1391: FND_MSG_PUB.ADD;

Line 1388: FND_MESSAGE.SET_TOKEN('FK', 'party_id');

1384:
1385: EXCEPTION
1386: WHEN NO_DATA_FOUND THEN
1387: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
1388: FND_MESSAGE.SET_TOKEN('FK', 'party_id');
1389: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');
1390: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_parties');
1391: FND_MSG_PUB.ADD;
1392: x_return_status := FND_API.G_RET_STS_ERROR;

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

1385: EXCEPTION
1386: WHEN NO_DATA_FOUND THEN
1387: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
1388: FND_MESSAGE.SET_TOKEN('FK', 'party_id');
1389: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');
1390: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_parties');
1391: FND_MSG_PUB.ADD;
1392: x_return_status := FND_API.G_RET_STS_ERROR;
1393: END;

Line 1390: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_parties');

1386: WHEN NO_DATA_FOUND THEN
1387: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
1388: FND_MESSAGE.SET_TOKEN('FK', 'party_id');
1389: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');
1390: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_parties');
1391: FND_MSG_PUB.ADD;
1392: x_return_status := FND_API.G_RET_STS_ERROR;
1393: END;
1394: END IF;