DBA Data[Home] [Help]

APPS.HZ_TAX_ASSIGNMENT_PUB dependencies on FND_MSG_PUB

Line 88: FND_MSG_PUB.ADD;

84: IF l_org_id is NULL or l_org_id = -99 THEN
85:
86: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
87: FND_MESSAGE.SET_TOKEN('COLUMN', 'org_id');
88: FND_MSG_PUB.ADD;
89: RAISE FND_API.G_EXC_ERROR;
90: END IF;
91: */
92:

Line 99: FND_MSG_PUB.ADD;

95: p_location_id = FND_API.G_MISS_NUM THEN
96:
97: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
98: FND_MESSAGE.SET_TOKEN('COLUMN', 'p_location_id');
99: FND_MSG_PUB.ADD;
100: RAISE FND_API.G_EXC_ERROR;
101: END IF;
102:
103: -- IF p_lock_flag is true then

Line 133: FND_MSG_PUB.ADD;

129: EXCEPTION WHEN NO_DATA_FOUND THEN
130: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
131: FND_MESSAGE.SET_TOKEN('RECORD', 'hz_locations');
132: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_location_id));
133: FND_MSG_PUB.ADD;
134: x_return_status := FND_API.G_RET_STS_ERROR;
135:
136: END; -- end of SELECT
137:

Line 159: FND_MSG_PUB.ADD;

155: EXCEPTION WHEN NO_DATA_FOUND THEN
156: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
157: FND_MESSAGE.SET_TOKEN('RECORD', 'hz_locations');
158: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_location_id));
159: FND_MSG_PUB.ADD;
160: x_return_status := FND_API.G_RET_STS_ERROR;
161:
162: END; -- end of SELECT ;
163:

Line 174: FND_MSG_PUB.ADD;

170: IF(l_allow_update_std = 'N' AND
171: l_date_validated IS NOT NULL AND
172: l_validation_status_code IS NOT NULL) THEN
173: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_NO_UPDATE');
174: FND_MSG_PUB.ADD;
175: RAISE fnd_api.g_exc_error;
176: END IF;
177: -- ACNG
178:

Line 468: FND_MSG_PUB.initialize;

464: END IF;
465:
466: --Initialize message list if p_init_msg_list is set to TRUE.
467: IF FND_API.to_Boolean(p_init_msg_list) THEN
468: FND_MSG_PUB.initialize;
469: END IF;
470:
471: --Initialize API return status to success.
472: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 509: FND_MSG_PUB.Count_And_Get(

505: Commit;
506: END IF;
507:
508: --Standard call to get message count and if count is 1, get message info.
509: FND_MSG_PUB.Count_And_Get(
510: p_encoded => FND_API.G_FALSE,
511: p_count => x_msg_count,
512: p_data => x_msg_data);
513: EXCEPTION

Line 517: FND_MSG_PUB.Count_And_Get(

513: EXCEPTION
514: WHEN FND_API.G_EXC_ERROR THEN
515: ROLLBACK TO create_loc_assignment_pub;
516: x_return_status := FND_API.G_RET_STS_ERROR;
517: FND_MSG_PUB.Count_And_Get(
518: p_encoded => FND_API.G_FALSE,
519: p_count => x_msg_count,
520: p_data => x_msg_data);
521:

Line 525: FND_MSG_PUB.Count_And_Get(

521:
522: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
523: ROLLBACK TO create_loc_assignment_pub;
524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
525: FND_MSG_PUB.Count_And_Get(
526: p_encoded => FND_API.G_FALSE,
527: p_count => x_msg_count,
528: p_data => x_msg_data);
529:

Line 535: FND_MSG_PUB.ADD;

531: ROLLBACK TO create_loc_assignment_pub;
532: x_return_status := FND_API.G_RET_STS_ERROR;
533: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
534: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
535: FND_MSG_PUB.ADD;
536: FND_MSG_PUB.Count_And_Get(
537: p_encoded => FND_API.G_FALSE,
538: p_count => x_msg_count,
539: p_data => x_msg_data);

Line 536: FND_MSG_PUB.Count_And_Get(

532: x_return_status := FND_API.G_RET_STS_ERROR;
533: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
534: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
535: FND_MSG_PUB.ADD;
536: FND_MSG_PUB.Count_And_Get(
537: p_encoded => FND_API.G_FALSE,
538: p_count => x_msg_count,
539: p_data => x_msg_data);
540: WHEN OTHERS THEN

Line 546: FND_MSG_PUB.ADD;

542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
543:
544: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
545: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
546: FND_MSG_PUB.ADD;
547:
548: FND_MSG_PUB.Count_And_Get(
549: p_encoded => FND_API.G_FALSE,
550: p_count => x_msg_count,

Line 548: FND_MSG_PUB.Count_And_Get(

544: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
545: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
546: FND_MSG_PUB.ADD;
547:
548: FND_MSG_PUB.Count_And_Get(
549: p_encoded => FND_API.G_FALSE,
550: p_count => x_msg_count,
551: p_data => x_msg_data);
552:

Line 588: FND_MSG_PUB.initialize;

584: END IF;
585:
586: --Initialize message list if p_init_msg_list is set to TRUE.
587: IF FND_API.to_Boolean(p_init_msg_list) THEN
588: FND_MSG_PUB.initialize;
589: END IF;
590:
591: --Initialize API return status to success.
592: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 628: FND_MSG_PUB.Count_And_Get(

624: Commit;
625: END IF;
626:
627: --Standard call to get message count and if count is 1, get message info.
628: FND_MSG_PUB.Count_And_Get(
629: p_encoded => FND_API.G_FALSE,
630: p_count => x_msg_count,
631: p_data => x_msg_data);
632: EXCEPTION

Line 636: FND_MSG_PUB.Count_And_Get(

632: EXCEPTION
633: WHEN FND_API.G_EXC_ERROR THEN
634: ROLLBACK TO update_loc_assignment_pub;
635: x_return_status := FND_API.G_RET_STS_ERROR;
636: FND_MSG_PUB.Count_And_Get(
637: p_encoded => FND_API.G_FALSE,
638: p_count => x_msg_count,
639: p_data => x_msg_data);
640:

Line 644: FND_MSG_PUB.Count_And_Get(

640:
641: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
642: ROLLBACK TO update_loc_assignment_pub;
643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
644: FND_MSG_PUB.Count_And_Get(
645: p_encoded => FND_API.G_FALSE,
646: p_count => x_msg_count,
647: p_data => x_msg_data);
648:

Line 654: FND_MSG_PUB.ADD;

650: ROLLBACK TO update_loc_assignment_pub;
651: x_return_status := FND_API.G_RET_STS_ERROR;
652: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
653: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
654: FND_MSG_PUB.ADD;
655: FND_MSG_PUB.Count_And_Get(
656: p_encoded => FND_API.G_FALSE,
657: p_count => x_msg_count,
658: p_data => x_msg_data);

Line 655: FND_MSG_PUB.Count_And_Get(

651: x_return_status := FND_API.G_RET_STS_ERROR;
652: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
653: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
654: FND_MSG_PUB.ADD;
655: FND_MSG_PUB.Count_And_Get(
656: p_encoded => FND_API.G_FALSE,
657: p_count => x_msg_count,
658: p_data => x_msg_data);
659:

Line 666: FND_MSG_PUB.ADD;

662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
663:
664: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
665: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
666: FND_MSG_PUB.ADD;
667:
668: FND_MSG_PUB.Count_And_Get(
669: p_encoded => FND_API.G_FALSE,
670: p_count => x_msg_count,

Line 668: FND_MSG_PUB.Count_And_Get(

664: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
665: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
666: FND_MSG_PUB.ADD;
667:
668: FND_MSG_PUB.Count_And_Get(
669: p_encoded => FND_API.G_FALSE,
670: p_count => x_msg_count,
671: p_data => x_msg_data);
672: