DBA Data[Home] [Help]

APPS.EAM_CONSTRUCTION_UNIT_PVT dependencies on FND_MSG_PUB

Line 64: FND_MSG_PUB.initialize;

60: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
61: END IF;
62:
63: -- Initialize message list if p_init_msg_list is set to TRUE.
64: FND_MSG_PUB.initialize;
65:
66:
67: l_cu_rec := p_cu_rec;
68: l_cu_activity_tbl := p_cu_activity_tbl;

Line 194: FND_MSG_PUB.Add;

190: x_return_status := fnd_api.g_ret_sts_error;
191: fnd_message.set_name('EAM','EAM_CU_UNEXP_SQL_ERROR');
192: fnd_message.set_token('API_NAME',l_api_name);
193: fnd_message.set_token('SQL_ERROR',SQLERRM);
194: FND_MSG_PUB.Add;
195: x_msg_data := fnd_message.get;
196: END create_construction_unit;
197:
198: PROCEDURE update_construction_unit(

Line 235: FND_MSG_PUB.initialize;

231: l_cu_activity_tbl := p_cu_activity_tbl;
232: x_return_status := fnd_api.G_RET_STS_SUCCESS;
233:
234: -- Initialize message list if p_init_msg_list is set to TRUE.
235: FND_MSG_PUB.initialize;
236:
237: IF (l_debug_level > 0) THEN
238: debug('UPDATE_CONSTRUCTION_UNIT');
239: END IF;

Line 289: FND_MSG_PUB.Add;

285: END IF;
286:
287: IF l_cu_rec.CU_ID IS NULL OR l_cu_rec.CU_ID = FND_API.G_MISS_NUM THEN
288: FND_MESSAGE.SET_NAME('EAM','EAM_CU_INVALID_CUID');
289: FND_MSG_PUB.Add;
290: RAISE FND_API.G_EXC_ERROR;
291: ELSE
292: l_cu_id := l_cu_rec.CU_ID;
293: END IF;

Line 377: FND_MSG_PUB.Add;

373: x_return_status := fnd_api.g_ret_sts_error;
374: fnd_message.set_name('EAM','EAM_CU_UNEXP_SQL_ERROR');
375: fnd_message.set_token('API_NAME',l_api_name);
376: fnd_message.set_token('SQL_ERROR',SQLERRM);
377: FND_MSG_PUB.Add;
378: x_msg_data := fnd_message.get;
379: END update_construction_unit;
380:
381:

Line 408: FND_MSG_PUB.initialize;

404:
405: x_return_status := fnd_api.G_RET_STS_SUCCESS;
406:
407: -- Initialize message list if p_init_msg_list is set to TRUE.
408: FND_MSG_PUB.initialize;
409:
410: IF (l_debug_level > 0) THEN
411: debug('copy_construction_unit');
412: END IF;

Line 446: FND_MSG_PUB.Add;

442: END IF;
443:
444: IF p_cu_activity_tbl.Count < 1 THEN
445: FND_MESSAGE.SET_NAME('EAM','EAM_CU_ATLEAST_ONE_ACTIVITY');
446: FND_MSG_PUB.Add;
447: RAISE FND_API.G_EXC_ERROR;
448: END IF;
449:
450: FOR l_assign_count IN p_cu_activity_tbl.FIRST..p_cu_activity_tbl.LAST

Line 531: FND_MSG_PUB.Add;

527: x_return_status := fnd_api.g_ret_sts_error;
528: fnd_message.set_name('EAM','EAM_CU_UNEXP_SQL_ERROR');
529: fnd_message.set_token('API_NAME',l_api_name);
530: fnd_message.set_token('SQL_ERROR',SQLERRM);
531: FND_MSG_PUB.Add;
532: x_msg_data := fnd_message.get;
533:
534: END copy_construction_unit;
535:

Line 574: FND_MSG_PUB.Add;

570: l_cu_rec := p_cu_rec;
571:
572: IF (l_cu_rec.CU_NAME IS NULL OR l_cu_rec.CU_NAME = FND_API.G_MISS_CHAR) THEN
573: FND_MESSAGE.SET_NAME('EAM','EAM_CU_NAME_NULL');
574: FND_MSG_PUB.Add;
575: RAISE FND_API.G_EXC_ERROR;
576: ELSE
577: BEGIN
578: SELECT 'X'

Line 585: FND_MSG_PUB.Add;

581: WHERE cu_name = l_cu_rec.CU_NAME
582: AND cu_id <> Nvl(l_cu_rec.CU_ID, FND_API.G_MISS_NUM);
583:
584: FND_MESSAGE.SET_NAME('EAM','EAM_CU_NAME_DUPLICATE');
585: FND_MSG_PUB.Add;
586: RAISE FND_API.G_EXC_ERROR;
587: EXCEPTION
588: WHEN No_Data_Found THEN
589: NULL;

Line 598: FND_MSG_PUB.Add;

594: IF p_action = 'CREATE' THEN
595: l_cu_rec.cu_effective_from := SYSDATE;
596: ELSE
597: FND_MESSAGE.SET_NAME('EAM','EAM_CU_EFFECTIVE_FROM_NULL');
598: FND_MSG_PUB.Add;
599: RAISE FND_API.G_EXC_ERROR;
600: END IF;
601: END IF;
602:

Line 606: FND_MSG_PUB.Add;

602:
603: IF Nvl(l_cu_rec.cu_effective_to,FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
604: IF l_cu_rec.cu_effective_to < l_cu_rec.cu_effective_from THEN
605: FND_MESSAGE.SET_NAME('EAM','EAM_CU_EFFECTIVE_TO_FROM_ERROR');
606: FND_MSG_PUB.Add;
607: RAISE FND_API.G_EXC_ERROR;
608: END IF;
609: END IF;
610:

Line 613: FND_MSG_PUB.Add;

609: END IF;
610:
611: IF p_cu_activity_tbl.Count < 1 THEN
612: FND_MESSAGE.SET_NAME('EAM','EAM_CU_ATLEAST_ONE_ACTIVITY');
613: FND_MSG_PUB.Add;
614: RAISE FND_API.G_EXC_ERROR;
615: END IF;
616:
617: l_cu_activity_tbl := p_cu_activity_tbl;

Line 655: FND_MSG_PUB.Add;

651: EXCEPTION
652: WHEN No_Data_Found THEN
653: FND_MESSAGE.SET_NAME('EAM','EAM_CU_INVALID_ACTIVITY');
654: FND_MESSAGE.SET_TOKEN('ACTIVITY',l_cu_activity_rec.ACTIVITY_ID);
655: FND_MSG_PUB.Add;
656: RAISE FND_API.G_EXC_ERROR;
657: WHEN OTHERS THEN
658: NULL;
659: END;

Line 673: FND_MSG_PUB.Add;

669: WHEN No_Data_Found THEN
670: FND_MESSAGE.SET_NAME('EAM','EAM_CU_ACTIVITY_NOT_ASSIGNED');
671: FND_MESSAGE.SET_TOKEN('ACTIVITY',l_activity_name);
672: FND_MESSAGE.SET_TOKEN('ORG',l_org_code);
673: FND_MSG_PUB.Add;
674: RAISE FND_API.G_EXC_ERROR;
675: END;
676:
677: IF Nvl(l_cu_activity_rec.ACCT_CLASS_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

Line 692: FND_MSG_PUB.Add;

688: WHEN No_Data_Found THEN
689: FND_MESSAGE.SET_NAME('EAM','EAM_CU_ACCTCLASS_NOT_ASSIGNED');
690: FND_MESSAGE.SET_TOKEN('ACCTCLASS',l_cu_activity_rec.ACCT_CLASS_CODE);
691: FND_MESSAGE.SET_TOKEN('ORG',l_org_code);
692: FND_MSG_PUB.Add;
693: RAISE FND_API.G_EXC_ERROR;
694: END;
695: END IF;
696:

Line 700: FND_MSG_PUB.Add;

696:
697: l_qtantity := l_cu_activity_rec.CU_ACTIVITY_QTY;
698: IF l_qtantity*100 <> Round(l_qtantity*100) THEN
699: FND_MESSAGE.SET_NAME('EAM','EAM_CU_ACT_QTY_DECIMAL');
700: FND_MSG_PUB.Add;
701: RAISE FND_API.G_EXC_ERROR;
702: END IF;
703:
704: IF l_qtantity < 0 THEN

Line 706: FND_MSG_PUB.Add;

702: END IF;
703:
704: IF l_qtantity < 0 THEN
705: FND_MESSAGE.SET_NAME('EAM','EAM_CU_ACT_QTY_POSITIVE');
706: FND_MSG_PUB.Add;
707: RAISE FND_API.G_EXC_ERROR;
708: END IF;
709:
710: IF Nvl(l_cu_activity_rec.CU_ACTIVITY_EFFECTIVE_FROM, FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE THEN

Line 712: FND_MSG_PUB.Add;

708: END IF;
709:
710: IF Nvl(l_cu_activity_rec.CU_ACTIVITY_EFFECTIVE_FROM, FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE THEN
711: FND_MESSAGE.SET_NAME('EAM','EAM_CU_ACT_EFFECTIVE_FROM_NULL');
712: FND_MSG_PUB.Add;
713: RAISE FND_API.G_EXC_ERROR;
714: END IF;
715:
716: IF l_cu_rec.CU_EFFECTIVE_FROM > l_cu_activity_rec.CU_ACTIVITY_EFFECTIVE_FROM THEN

Line 718: FND_MSG_PUB.Add;

714: END IF;
715:
716: IF l_cu_rec.CU_EFFECTIVE_FROM > l_cu_activity_rec.CU_ACTIVITY_EFFECTIVE_FROM THEN
717: FND_MESSAGE.SET_NAME('EAM','EAM_CU_ACT_CU_EFFECTIVE_FROM');
718: FND_MSG_PUB.Add;
719: RAISE FND_API.G_EXC_ERROR;
720: END IF;
721:
722: IF Nvl(l_cu_activity_rec.CU_ACTIVITY_EFFECTIVE_TO,FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN

Line 725: FND_MSG_PUB.Add;

721:
722: IF Nvl(l_cu_activity_rec.CU_ACTIVITY_EFFECTIVE_TO,FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
723: IF l_cu_activity_rec.CU_ACTIVITY_EFFECTIVE_TO < l_cu_activity_rec.CU_ACTIVITY_EFFECTIVE_FROM THEN
724: FND_MESSAGE.SET_NAME('EAM','EAM_CU_ACT_EFFT_TO_FROM_ERROR');
725: FND_MSG_PUB.Add;
726: RAISE FND_API.G_EXC_ERROR;
727: END IF;
728: END IF;
729: END LOOP;

Line 741: FND_MSG_PUB.Add;

737: x_return_status := fnd_api.g_ret_sts_error;
738: fnd_message.set_name('EAM','EAM_CU_UNEXP_SQL_ERROR');
739: fnd_message.set_token('API_NAME',l_api_name);
740: fnd_message.set_token('SQL_ERROR',SQLERRM);
741: FND_MSG_PUB.Add;
742: x_msg_data := fnd_message.get;
743: END validate_cu_details;
744:
745: FUNCTION dump_error_stack RETURN varchar2

Line 753: fnd_msg_pub.count_and_get(

749: l_msg_index_out number;
750: x_msg_data varchar2(4000);
751: BEGIN
752: x_msg_data := null;
753: fnd_msg_pub.count_and_get(
754: p_count => l_msg_count,
755: p_data => l_msg_data);
756:
757: FOR l_ind IN 1..l_msg_count

Line 759: fnd_msg_pub.get(

755: p_data => l_msg_data);
756:
757: FOR l_ind IN 1..l_msg_count
758: LOOP
759: fnd_msg_pub.get(
760: p_msg_index => l_ind,
761: p_encoded => fnd_api.g_false,
762: p_data => l_msg_data,
763: p_msg_index_out => l_msg_index_out);