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 505: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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