eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EAM_CONSTRUCTION_UNIT_PVT dependencies on FND_MESSAGE

Line 191: fnd_message.set_name('EAM','EAM_CU_UNEXP_SQL_ERROR');

187: RETURN;
188: WHEN OTHERS THEN
189: ROLLBACK TO create_construction_unit;
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;

Line 192: fnd_message.set_token('API_NAME',l_api_name);

188: WHEN OTHERS THEN
189: ROLLBACK TO create_construction_unit;
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;

Line 193: fnd_message.set_token('SQL_ERROR',SQLERRM);

189: ROLLBACK TO create_construction_unit;
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:

Line 195: x_msg_data := fnd_message.get;

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(
199: p_api_version IN NUMBER

Line 288: FND_MESSAGE.SET_NAME('EAM','EAM_CU_INVALID_CUID');

284: RAISE FND_API.G_EXC_ERROR;
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;

Line 374: fnd_message.set_name('EAM','EAM_CU_UNEXP_SQL_ERROR');

370: RETURN;
371: WHEN OTHERS THEN
372: ROLLBACK TO update_construction_unit;
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;

Line 375: fnd_message.set_token('API_NAME',l_api_name);

371: WHEN OTHERS THEN
372: ROLLBACK TO update_construction_unit;
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;

Line 376: fnd_message.set_token('SQL_ERROR',SQLERRM);

372: ROLLBACK TO update_construction_unit;
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:

Line 378: x_msg_data := fnd_message.get;

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:
382: PROCEDURE copy_construction_unit(

Line 445: FND_MESSAGE.SET_NAME('EAM','EAM_CU_ATLEAST_ONE_ACTIVITY');

441: debug('ATTRIBUTE15 : ' || p_cu_rec.ATTRIBUTE15);
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:

Line 528: fnd_message.set_name('EAM','EAM_CU_UNEXP_SQL_ERROR');

524: RETURN;
525: WHEN OTHERS THEN
526: ROLLBACK TO copy_construction_unit;
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;

Line 529: fnd_message.set_token('API_NAME',l_api_name);

525: WHEN OTHERS THEN
526: ROLLBACK TO copy_construction_unit;
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:

Line 530: fnd_message.set_token('SQL_ERROR',SQLERRM);

526: ROLLBACK TO copy_construction_unit;
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;

Line 532: x_msg_data := fnd_message.get;

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:
536:

Line 573: FND_MESSAGE.SET_NAME('EAM','EAM_CU_NAME_NULL');

569: x_return_status := fnd_api.G_RET_STS_SUCCESS;
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

Line 584: FND_MESSAGE.SET_NAME('EAM','EAM_CU_NAME_DUPLICATE');

580: FROM eam_construction_units
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

Line 597: FND_MESSAGE.SET_NAME('EAM','EAM_CU_EFFECTIVE_FROM_NULL');

593: IF Nvl(l_cu_rec.cu_effective_from,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE THEN
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;

Line 605: FND_MESSAGE.SET_NAME('EAM','EAM_CU_EFFECTIVE_TO_FROM_ERROR');

601: END IF;
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;

Line 612: FND_MESSAGE.SET_NAME('EAM','EAM_CU_ATLEAST_ONE_ACTIVITY');

608: END IF;
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:

Line 653: FND_MESSAGE.SET_NAME('EAM','EAM_CU_INVALID_ACTIVITY');

649: AND ROWNUM < 2 ;
650:
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

Line 654: FND_MESSAGE.SET_TOKEN('ACTIVITY',l_cu_activity_rec.ACTIVITY_ID);

650:
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;

Line 670: FND_MESSAGE.SET_NAME('EAM','EAM_CU_ACTIVITY_NOT_ASSIGNED');

666: AND organization_id = l_cu_rec.ORGANIZATION_ID;
667:
668: EXCEPTION
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;

Line 671: FND_MESSAGE.SET_TOKEN('ACTIVITY',l_activity_name);

667:
668: EXCEPTION
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;

Line 672: FND_MESSAGE.SET_TOKEN('ORG',l_org_code);

668: EXCEPTION
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:

Line 689: FND_MESSAGE.SET_NAME('EAM','EAM_CU_ACCTCLASS_NOT_ASSIGNED');

685: AND class_type = 6;
686:
687: EXCEPTION
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;

Line 690: FND_MESSAGE.SET_TOKEN('ACCTCLASS',l_cu_activity_rec.ACCT_CLASS_CODE);

686:
687: EXCEPTION
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;

Line 691: FND_MESSAGE.SET_TOKEN('ORG',l_org_code);

687: EXCEPTION
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;

Line 699: FND_MESSAGE.SET_NAME('EAM','EAM_CU_ACT_QTY_DECIMAL');

695: END IF;
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:

Line 705: FND_MESSAGE.SET_NAME('EAM','EAM_CU_ACT_QTY_POSITIVE');

701: RAISE FND_API.G_EXC_ERROR;
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:

Line 711: FND_MESSAGE.SET_NAME('EAM','EAM_CU_ACT_EFFECTIVE_FROM_NULL');

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
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:

Line 717: FND_MESSAGE.SET_NAME('EAM','EAM_CU_ACT_CU_EFFECTIVE_FROM');

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
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:

Line 724: FND_MESSAGE.SET_NAME('EAM','EAM_CU_ACT_EFFT_TO_FROM_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
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;

Line 738: fnd_message.set_name('EAM','EAM_CU_UNEXP_SQL_ERROR');

734: x_return_status := fnd_api.g_ret_sts_error;
735: x_msg_data := dump_error_stack;
736: WHEN OTHERS THEN
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;

Line 739: fnd_message.set_token('API_NAME',l_api_name);

735: x_msg_data := dump_error_stack;
736: WHEN OTHERS THEN
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;

Line 740: fnd_message.set_token('SQL_ERROR',SQLERRM);

736: WHEN OTHERS THEN
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:

Line 742: x_msg_data := fnd_message.get;

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
746: IS