DBA Data[Home] [Help]

APPS.AHL_UMP_FORECAST_REQ_PVT dependencies on FND_MESSAGE

Line 705: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_INSTID_NOTFOUND');

701: -- validate item instance.
702: OPEN csi_item_instances_csr (p_item_instance_id);
703: FETCH csi_item_instances_csr INTO l_instance_number, l_active_end_date;
704: IF (csi_item_instances_csr%NOTFOUND) THEN
705: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_INSTID_NOTFOUND');
706: FND_MESSAGE.Set_Token('INST_ID', p_item_instance_id);
707: FND_MSG_PUB.ADD;
708: CLOSE csi_item_instances_csr;
709: --dbms_output.put_line('Instance not found');

Line 706: FND_MESSAGE.Set_Token('INST_ID', p_item_instance_id);

702: OPEN csi_item_instances_csr (p_item_instance_id);
703: FETCH csi_item_instances_csr INTO l_instance_number, l_active_end_date;
704: IF (csi_item_instances_csr%NOTFOUND) THEN
705: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_INSTID_NOTFOUND');
706: FND_MESSAGE.Set_Token('INST_ID', p_item_instance_id);
707: FND_MSG_PUB.ADD;
708: CLOSE csi_item_instances_csr;
709: --dbms_output.put_line('Instance not found');
710: errbuf := FND_MSG_PUB.GET;

Line 713: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_INST_EXPIRED');

709: --dbms_output.put_line('Instance not found');
710: errbuf := FND_MSG_PUB.GET;
711: retcode := 2;
712: ELSIF (trunc(l_active_end_date) < trunc(sysdate)) THEN
713: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_INST_EXPIRED');
714: FND_MESSAGE.Set_Token('NUMBER', l_instance_number);
715: FND_MSG_PUB.ADD;
716: --dbms_output.put_line('Instance has expired');
717: errbuf := FND_MSG_PUB.GET;

Line 714: FND_MESSAGE.Set_Token('NUMBER', l_instance_number);

710: errbuf := FND_MSG_PUB.GET;
711: retcode := 2;
712: ELSIF (trunc(l_active_end_date) < trunc(sysdate)) THEN
713: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_INST_EXPIRED');
714: FND_MESSAGE.Set_Token('NUMBER', l_instance_number);
715: FND_MSG_PUB.ADD;
716: --dbms_output.put_line('Instance has expired');
717: errbuf := FND_MSG_PUB.GET;
718: retcode := 2;

Line 730: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_STATUS_INVALID');

726: OPEN ahl_unit_config_header_csr(l_csi_item_instance_id);
727: FETCH ahl_unit_config_header_csr INTO l_name, l_master_config_id, l_config_status_code;
728: IF (ahl_unit_config_header_csr%FOUND) THEN
729: IF (l_config_status_code = 'DRAFT') THEN
730: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_STATUS_INVALID');
731: FND_MESSAGE.Set_Token('NAME',l_name);
732: FND_MSG_PUB.ADD;
733: errbuf := FND_MSG_PUB.GET;
734: retcode := 2;

Line 731: FND_MESSAGE.Set_Token('NAME',l_name);

727: FETCH ahl_unit_config_header_csr INTO l_name, l_master_config_id, l_config_status_code;
728: IF (ahl_unit_config_header_csr%FOUND) THEN
729: IF (l_config_status_code = 'DRAFT') THEN
730: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_STATUS_INVALID');
731: FND_MESSAGE.Set_Token('NAME',l_name);
732: FND_MSG_PUB.ADD;
733: errbuf := FND_MSG_PUB.GET;
734: retcode := 2;
735: END IF;

Line 752: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_UNIT_NOTFOUND');

748: OPEN ahl_unit_config_headers_csr (p_unit_config_hdr_id);
749: FETCH ahl_unit_config_headers_csr INTO l_name, l_csi_item_instance_id, l_master_config_id,
750: l_config_status_code ;
751: IF (ahl_unit_config_headers_csr%NOTFOUND) THEN
752: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_UNIT_NOTFOUND');
753: FND_MESSAGE.Set_Token('UNIT_ID',p_unit_config_hdr_id);
754: FND_MSG_PUB.ADD;
755: errbuf := FND_MSG_PUB.GET;
756: retcode := 2;

Line 753: FND_MESSAGE.Set_Token('UNIT_ID',p_unit_config_hdr_id);

749: FETCH ahl_unit_config_headers_csr INTO l_name, l_csi_item_instance_id, l_master_config_id,
750: l_config_status_code ;
751: IF (ahl_unit_config_headers_csr%NOTFOUND) THEN
752: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_UNIT_NOTFOUND');
753: FND_MESSAGE.Set_Token('UNIT_ID',p_unit_config_hdr_id);
754: FND_MSG_PUB.ADD;
755: errbuf := FND_MSG_PUB.GET;
756: retcode := 2;
757: --dbms_output.put_line('Unit not found');

Line 760: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_STATUS_INVALID');

756: retcode := 2;
757: --dbms_output.put_line('Unit not found');
758: ELSE
759: IF (l_config_status_code = 'DRAFT') THEN
760: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_STATUS_INVALID');
761: FND_MESSAGE.Set_Token('NAME',l_name);
762: FND_MSG_PUB.ADD;
763: CLOSE ahl_unit_config_headers_csr;
764:

Line 761: FND_MESSAGE.Set_Token('NAME',l_name);

757: --dbms_output.put_line('Unit not found');
758: ELSE
759: IF (l_config_status_code = 'DRAFT') THEN
760: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_STATUS_INVALID');
761: FND_MESSAGE.Set_Token('NAME',l_name);
762: FND_MSG_PUB.ADD;
763: CLOSE ahl_unit_config_headers_csr;
764:
765: errbuf := FND_MSG_PUB.GET;