DBA Data[Home] [Help]

APPS.LNS_COND_ASSIGNMENT_PUB dependencies on FND_MSG_PUB

Line 108: FND_MSG_PUB.ADD;

104: WHERE cond_assignment_id = l_COND_ASSIGNMENT_id;
105:
106: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_DUPLICATE_COLUMN');
107: FND_MESSAGE.SET_TOKEN('COLUMN', 'cond_assignment_id');
108: FND_MSG_PUB.ADD;
109: RAISE FND_API.G_EXC_ERROR;
110:
111: EXCEPTION
112: WHEN NO_DATA_FOUND THEN

Line 218: FND_MSG_PUB.ADD;

214: )
215: THEN
216: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_RECORD_CHANGED');
217: FND_MESSAGE.SET_TOKEN('TABLE', 'lns_COND_ASSIGNMENTs');
218: FND_MSG_PUB.ADD;
219: RAISE FND_API.G_EXC_ERROR;
220: END IF;
221:
222: p_object_version_number := nvl(l_object_version_number, 1) + 1;

Line 228: FND_MSG_PUB.ADD;

224: EXCEPTION WHEN NO_DATA_FOUND THEN
225: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
226: FND_MESSAGE.SET_TOKEN('RECORD', 'cond_assignment_rec');
227: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_COND_ASSIGNMENT_rec.cond_assignment_id), 'null'));
228: FND_MSG_PUB.ADD;
229: RAISE FND_API.G_EXC_ERROR;
230: END;
231:
232: Set_Defaults(p_COND_ASSIGNMENT_rec);

Line 333: FND_MSG_PUB.ADD;

329: WHEN NO_DATA_FOUND THEN
330: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
331: FND_MESSAGE.SET_TOKEN('RECORD', 'cond_assignment_rec');
332: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_COND_ASSIGNMENT_id), 'null'));
333: FND_MSG_PUB.ADD;
334: RAISE FND_API.G_EXC_ERROR;
335: END;
336: END IF;
337:

Line 360: FND_MSG_PUB.ADD;

356: WHEN OTHERS THEN
357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
358: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
359: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
360: FND_MSG_PUB.ADD;
361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
362: END;
363:
364: /*

Line 452: FND_MSG_PUB.initialize;

448: SAVEPOINT create_COND_ASSIGNMENT;
449:
450: -- initialize message list if p_init_msg_list is set to TRUE.
451: IF FND_API.to_Boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) THEN
452: FND_MSG_PUB.initialize;
453: END IF;
454:
455: -- initialize API return status to success.
456: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 477: FND_MSG_PUB.Count_And_Get(

473: EXCEPTION
474: WHEN FND_API.G_EXC_ERROR THEN
475: ROLLBACK TO create_COND_ASSIGNMENT;
476: x_return_status := FND_API.G_RET_STS_ERROR;
477: FND_MSG_PUB.Count_And_Get(
478: p_encoded => FND_API.G_FALSE,
479: p_count => x_msg_count,
480: p_data => x_msg_data);
481:

Line 485: FND_MSG_PUB.Count_And_Get(

481:
482: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
483: ROLLBACK TO create_COND_ASSIGNMENT;
484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
485: FND_MSG_PUB.Count_And_Get(
486: p_encoded => FND_API.G_FALSE,
487: p_count => x_msg_count,
488: p_data => x_msg_data);
489:

Line 495: FND_MSG_PUB.ADD;

491: ROLLBACK TO create_COND_ASSIGNMENT;
492: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
493: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
494: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
495: FND_MSG_PUB.ADD;
496: FND_MSG_PUB.Count_And_Get(
497: p_encoded => FND_API.G_FALSE,
498: p_count => x_msg_count,
499: p_data => x_msg_data);

Line 496: FND_MSG_PUB.Count_And_Get(

492: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
493: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
494: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
495: FND_MSG_PUB.ADD;
496: FND_MSG_PUB.Count_And_Get(
497: p_encoded => FND_API.G_FALSE,
498: p_count => x_msg_count,
499: p_data => x_msg_data);
500:

Line 561: FND_MSG_PUB.initialize;

557: SAVEPOINT update_COND_ASSIGNMENT;
558:
559: -- initialize message list if p_init_msg_list is set to TRUE.
560: IF FND_API.to_Boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) THEN
561: FND_MSG_PUB.initialize;
562: END IF;
563:
564: -- initialize API return status to success.
565: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 600: FND_MSG_PUB.Count_And_Get(

596: EXCEPTION
597: WHEN FND_API.G_EXC_ERROR THEN
598: ROLLBACK TO update_COND_ASSIGNMENT;
599: x_return_status := FND_API.G_RET_STS_ERROR;
600: FND_MSG_PUB.Count_And_Get(
601: p_encoded => FND_API.G_FALSE,
602: p_count => x_msg_count,
603: p_data => x_msg_data);
604:

Line 608: FND_MSG_PUB.Count_And_Get(

604:
605: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
606: ROLLBACK TO update_COND_ASSIGNMENT;
607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
608: FND_MSG_PUB.Count_And_Get(
609: p_encoded => FND_API.G_FALSE,
610: p_count => x_msg_count,
611: p_data => x_msg_data);
612:

Line 618: FND_MSG_PUB.ADD;

614: ROLLBACK TO update_COND_ASSIGNMENT;
615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
616: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
617: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
618: FND_MSG_PUB.ADD;
619: FND_MSG_PUB.Count_And_Get(
620: p_encoded => FND_API.G_FALSE,
621: p_count => x_msg_count,
622: p_data => x_msg_data);

Line 619: FND_MSG_PUB.Count_And_Get(

615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
616: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
617: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
618: FND_MSG_PUB.ADD;
619: FND_MSG_PUB.Count_And_Get(
620: p_encoded => FND_API.G_FALSE,
621: p_count => x_msg_count,
622: p_data => x_msg_data);
623:

Line 681: FND_MSG_PUB.initialize;

677: SAVEPOINT delete_COND_ASSIGNMENT;
678:
679: -- initialize message list if p_init_msg_list is set to TRUE.
680: IF FND_API.to_Boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) THEN
681: FND_MSG_PUB.initialize;
682: END IF;
683:
684: -- initialize API return status to success.
685: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 705: FND_MSG_PUB.Count_And_Get(

701: EXCEPTION
702: WHEN FND_API.G_EXC_ERROR THEN
703: ROLLBACK TO delete_COND_ASSIGNMENT;
704: x_return_status := FND_API.G_RET_STS_ERROR;
705: FND_MSG_PUB.Count_And_Get(
706: p_encoded => FND_API.G_FALSE,
707: p_count => x_msg_count,
708: p_data => x_msg_data);
709:

Line 713: FND_MSG_PUB.Count_And_Get(

709:
710: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
711: ROLLBACK TO delete_COND_ASSIGNMENT;
712: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
713: FND_MSG_PUB.Count_And_Get(
714: p_encoded => FND_API.G_FALSE,
715: p_count => x_msg_count,
716: p_data => x_msg_data);
717:

Line 723: FND_MSG_PUB.ADD;

719: ROLLBACK TO delete_COND_ASSIGNMENT;
720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
721: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
722: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
723: FND_MSG_PUB.ADD;
724: FND_MSG_PUB.Count_And_Get(
725: p_encoded => FND_API.G_FALSE,
726: p_count => x_msg_count,
727: p_data => x_msg_data);

Line 724: FND_MSG_PUB.Count_And_Get(

720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
721: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
722: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
723: FND_MSG_PUB.ADD;
724: FND_MSG_PUB.Count_And_Get(
725: p_encoded => FND_API.G_FALSE,
726: p_count => x_msg_count,
727: p_data => x_msg_data);
728: