DBA Data[Home] [Help]

APPS.HZ_COMMON_PUB dependencies on FND_MESSAGE

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

191: CLOSE c_exist;
192: END IF;
193:
194: IF l_error THEN
195: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_LOOKUP');
196: FND_MESSAGE.SET_TOKEN('COLUMN', p_column);
197: FND_MESSAGE.SET_TOKEN('LOOKUP_TYPE', p_lookup_type);
198: FND_MSG_PUB.ADD;
199: x_return_status := FND_API.G_RET_STS_ERROR;

Line 196: FND_MESSAGE.SET_TOKEN('COLUMN', p_column);

192: END IF;
193:
194: IF l_error THEN
195: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_LOOKUP');
196: FND_MESSAGE.SET_TOKEN('COLUMN', p_column);
197: FND_MESSAGE.SET_TOKEN('LOOKUP_TYPE', p_lookup_type);
198: FND_MSG_PUB.ADD;
199: x_return_status := FND_API.G_RET_STS_ERROR;
200: END IF;

Line 197: FND_MESSAGE.SET_TOKEN('LOOKUP_TYPE', p_lookup_type);

193:
194: IF l_error THEN
195: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_LOOKUP');
196: FND_MESSAGE.SET_TOKEN('COLUMN', p_column);
197: FND_MESSAGE.SET_TOKEN('LOOKUP_TYPE', p_lookup_type);
198: FND_MSG_PUB.ADD;
199: x_return_status := FND_API.G_RET_STS_ERROR;
200: END IF;
201:

Line 226: fnd_message.set_name('AR','HZ_API_INVALID_LOOKUP');

222: AND p_column_value <> fnd_api.g_miss_char ) THEN
223: OPEN c1;
224: FETCH c1 INTO l_exist;
225: IF c1%NOTFOUND THEN
226: fnd_message.set_name('AR','HZ_API_INVALID_LOOKUP');
227: fnd_message.set_token('COLUMN',p_column);
228: fnd_message.set_token('LOOKUP_TYPE',p_lookup_type);
229: fnd_msg_pub.add;
230: x_return_status := fnd_api.g_ret_sts_error;

Line 227: fnd_message.set_token('COLUMN',p_column);

223: OPEN c1;
224: FETCH c1 INTO l_exist;
225: IF c1%NOTFOUND THEN
226: fnd_message.set_name('AR','HZ_API_INVALID_LOOKUP');
227: fnd_message.set_token('COLUMN',p_column);
228: fnd_message.set_token('LOOKUP_TYPE',p_lookup_type);
229: fnd_msg_pub.add;
230: x_return_status := fnd_api.g_ret_sts_error;
231: END IF;

Line 228: fnd_message.set_token('LOOKUP_TYPE',p_lookup_type);

224: FETCH c1 INTO l_exist;
225: IF c1%NOTFOUND THEN
226: fnd_message.set_name('AR','HZ_API_INVALID_LOOKUP');
227: fnd_message.set_token('COLUMN',p_column);
228: fnd_message.set_token('LOOKUP_TYPE',p_lookup_type);
229: fnd_msg_pub.add;
230: x_return_status := fnd_api.g_ret_sts_error;
231: END IF;
232: CLOSE c1;

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

499: x_return_status IN OUT NOCOPY VARCHAR2)
500: IS
501: BEGIN
502: IF (p_col_val IS NULL) THEN
503: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
504: fnd_message.set_token('COLUMN', p_col_name);
505: fnd_msg_pub.add;
506: x_return_status := fnd_api.g_ret_sts_error;
507: RETURN;

Line 504: fnd_message.set_token('COLUMN', p_col_name);

500: IS
501: BEGIN
502: IF (p_col_val IS NULL) THEN
503: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
504: fnd_message.set_token('COLUMN', p_col_name);
505: fnd_msg_pub.add;
506: x_return_status := fnd_api.g_ret_sts_error;
507: RETURN;
508: END IF;

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

510: IF (create_update_flag = 'C') THEN
511: IF ((NOT p_miss_allowed_in_c) AND
512: p_col_val = fnd_api.G_MISS_CHAR )
513: THEN
514: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
515: fnd_message.set_token('COLUMN', p_col_name);
516: fnd_msg_pub.add;
517: x_return_status := fnd_api.g_ret_sts_error;
518: END IF;

Line 515: fnd_message.set_token('COLUMN', p_col_name);

511: IF ((NOT p_miss_allowed_in_c) AND
512: p_col_val = fnd_api.G_MISS_CHAR )
513: THEN
514: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
515: fnd_message.set_token('COLUMN', p_col_name);
516: fnd_msg_pub.add;
517: x_return_status := fnd_api.g_ret_sts_error;
518: END IF;
519: ELSE

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

519: ELSE
520: IF ((NOT p_miss_allowed_in_u) AND
521: p_col_val = fnd_api.G_MISS_CHAR )
522: THEN
523: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
524: fnd_message.set_token('COLUMN', p_col_name);
525: fnd_msg_pub.add;
526: x_return_status := fnd_api.g_ret_sts_error;
527: END IF;

Line 524: fnd_message.set_token('COLUMN', p_col_name);

520: IF ((NOT p_miss_allowed_in_u) AND
521: p_col_val = fnd_api.G_MISS_CHAR )
522: THEN
523: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
524: fnd_message.set_token('COLUMN', p_col_name);
525: fnd_msg_pub.add;
526: x_return_status := fnd_api.g_ret_sts_error;
527: END IF;
528: END IF;

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

544: x_return_status IN OUT NOCOPY VARCHAR2)
545: IS
546: BEGIN
547: IF (p_col_val IS NULL) THEN
548: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
549: fnd_message.set_token('COLUMN', p_col_name);
550: fnd_msg_pub.add;
551: x_return_status := fnd_api.g_ret_sts_error;
552: RETURN;

Line 549: fnd_message.set_token('COLUMN', p_col_name);

545: IS
546: BEGIN
547: IF (p_col_val IS NULL) THEN
548: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
549: fnd_message.set_token('COLUMN', p_col_name);
550: fnd_msg_pub.add;
551: x_return_status := fnd_api.g_ret_sts_error;
552: RETURN;
553: END IF;

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

555: IF (create_update_flag = 'C') THEN
556: IF ((NOT p_miss_allowed_in_c) AND
557: p_col_val = fnd_api.G_MISS_DATE )
558: THEN
559: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
560: fnd_message.set_token('COLUMN', p_col_name);
561: fnd_msg_pub.add;
562: x_return_status := fnd_api.g_ret_sts_error;
563: END IF;

Line 560: fnd_message.set_token('COLUMN', p_col_name);

556: IF ((NOT p_miss_allowed_in_c) AND
557: p_col_val = fnd_api.G_MISS_DATE )
558: THEN
559: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
560: fnd_message.set_token('COLUMN', p_col_name);
561: fnd_msg_pub.add;
562: x_return_status := fnd_api.g_ret_sts_error;
563: END IF;
564: ELSE

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

564: ELSE
565: IF ((NOT p_miss_allowed_in_u) AND
566: p_col_val = fnd_api.G_MISS_DATE )
567: THEN
568: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
569: fnd_message.set_token('COLUMN', p_col_name);
570: fnd_msg_pub.add;
571: x_return_status := fnd_api.g_ret_sts_error;
572: END IF;

Line 569: fnd_message.set_token('COLUMN', p_col_name);

565: IF ((NOT p_miss_allowed_in_u) AND
566: p_col_val = fnd_api.G_MISS_DATE )
567: THEN
568: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
569: fnd_message.set_token('COLUMN', p_col_name);
570: fnd_msg_pub.add;
571: x_return_status := fnd_api.g_ret_sts_error;
572: END IF;
573: END IF;

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

589: x_return_status IN OUT NOCOPY VARCHAR2)
590: IS
591: BEGIN
592: IF (p_col_val IS NULL) THEN
593: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
594: fnd_message.set_token('COLUMN', p_col_name);
595: fnd_msg_pub.add;
596: x_return_status := fnd_api.g_ret_sts_error;
597: RETURN;

Line 594: fnd_message.set_token('COLUMN', p_col_name);

590: IS
591: BEGIN
592: IF (p_col_val IS NULL) THEN
593: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
594: fnd_message.set_token('COLUMN', p_col_name);
595: fnd_msg_pub.add;
596: x_return_status := fnd_api.g_ret_sts_error;
597: RETURN;
598: END IF;

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

600: IF (create_update_flag = 'C') THEN
601: IF ((NOT p_miss_allowed_in_c) AND
602: p_col_val = fnd_api.G_MISS_NUM )
603: THEN
604: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
605: fnd_message.set_token('COLUMN', p_col_name);
606: fnd_msg_pub.add;
607: x_return_status := fnd_api.g_ret_sts_error;
608: END IF;

Line 605: fnd_message.set_token('COLUMN', p_col_name);

601: IF ((NOT p_miss_allowed_in_c) AND
602: p_col_val = fnd_api.G_MISS_NUM )
603: THEN
604: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
605: fnd_message.set_token('COLUMN', p_col_name);
606: fnd_msg_pub.add;
607: x_return_status := fnd_api.g_ret_sts_error;
608: END IF;
609: ELSE

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

609: ELSE
610: IF ((NOT p_miss_allowed_in_u) AND
611: p_col_val = fnd_api.G_MISS_NUM )
612: THEN
613: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
614: fnd_message.set_token('COLUMN', p_col_name);
615: fnd_msg_pub.add;
616: x_return_status := fnd_api.g_ret_sts_error;
617: END IF;

Line 614: fnd_message.set_token('COLUMN', p_col_name);

610: IF ((NOT p_miss_allowed_in_u) AND
611: p_col_val = fnd_api.G_MISS_NUM )
612: THEN
613: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
614: fnd_message.set_token('COLUMN', p_col_name);
615: fnd_msg_pub.add;
616: x_return_status := fnd_api.g_ret_sts_error;
617: END IF;
618: END IF;