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.AHL_UC_UNITCONFIG_PVT dependencies on FND_MESSAGE

Line 145: FND_MESSAGE.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');

141: x_return_status := FND_API.G_RET_STS_SUCCESS;
142: OPEN get_uc_header( p_x_uc_header_rec.uc_header_id );
143: FETCH get_uc_header INTO l_old_uc_header_rec;
144: IF ( get_uc_header%NOTFOUND ) THEN
145: FND_MESSAGE.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
146: FND_MESSAGE.set_token('UC_HEADER_ID', p_x_uc_header_rec.uc_header_id);
147: FND_MSG_PUB.add;
148: x_return_status := FND_API.G_RET_STS_ERROR;
149: END IF;

Line 146: FND_MESSAGE.set_token('UC_HEADER_ID', p_x_uc_header_rec.uc_header_id);

142: OPEN get_uc_header( p_x_uc_header_rec.uc_header_id );
143: FETCH get_uc_header INTO l_old_uc_header_rec;
144: IF ( get_uc_header%NOTFOUND ) THEN
145: FND_MESSAGE.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
146: FND_MESSAGE.set_token('UC_HEADER_ID', p_x_uc_header_rec.uc_header_id);
147: FND_MSG_PUB.add;
148: x_return_status := FND_API.G_RET_STS_ERROR;
149: END IF;
150: IF ( l_old_uc_header_rec.object_version_number <>

Line 152: FND_MESSAGE.set_name('AHL', 'AHL_COM_RECORD_CHANGED');

148: x_return_status := FND_API.G_RET_STS_ERROR;
149: END IF;
150: IF ( l_old_uc_header_rec.object_version_number <>
151: p_x_uc_header_rec.object_version_number ) THEN
152: FND_MESSAGE.set_name('AHL', 'AHL_COM_RECORD_CHANGED');
153: FND_MSG_PUB.add;
154: x_return_status := FND_API.G_RET_STS_ERROR;
155: END IF;
156: CLOSE get_uc_header;

Line 306: FND_MESSAGE.set_name( 'AHL','AHL_UC_MC_NAME_REV_INVALID' );

302: IF (p_uc_header_rec.mc_name IS NULL AND
303: p_uc_header_rec.mc_revision IS NOT NULL) OR
304: (p_uc_header_rec.mc_name IS NOT NULL AND
305: p_uc_header_rec.mc_revision IS NULL) THEN
306: FND_MESSAGE.set_name( 'AHL','AHL_UC_MC_NAME_REV_INVALID' );
307: FND_MSG_PUB.add;
308: x_return_status := FND_API.G_RET_STS_ERROR;
309: END IF;
310: END;

Line 348: FND_MESSAGE.set_name('AHL', 'AHL_COM_INVALID_PROCEDURE_CALL');

344: x_return_status := FND_API.G_RET_STS_SUCCESS;
345: IF (p_mc_name IS NULL OR p_mc_revision IS NULL) AND
346: p_x_mc_header_id IS NULL THEN
347: x_return_status := FND_API.G_RET_STS_ERROR;
348: FND_MESSAGE.set_name('AHL', 'AHL_COM_INVALID_PROCEDURE_CALL');
349: FND_MSG_PUB.add;
350: ELSIF (p_mc_name IS NULL OR p_mc_revision IS NULL) AND
351: p_x_mc_header_id IS NOT NULL THEN
352: OPEN get_rec_from_id(p_x_mc_header_id);

Line 356: FND_MESSAGE.set_name('AHL', 'AHL_UC_MC_HEADER_ID_INVALID');

352: OPEN get_rec_from_id(p_x_mc_header_id);
353: FETCH get_rec_from_id INTO l_mc_header_id, l_relationship_id;
354: IF get_rec_from_id%NOTFOUND THEN
355: x_return_status := FND_API.G_RET_STS_ERROR;
356: FND_MESSAGE.set_name('AHL', 'AHL_UC_MC_HEADER_ID_INVALID');
357: FND_MESSAGE.set_token('MC_HEADER_ID', p_x_mc_header_id);
358: FND_MSG_PUB.add;
359: ELSE
360: p_x_mc_header_id := l_mc_header_id;

Line 357: FND_MESSAGE.set_token('MC_HEADER_ID', p_x_mc_header_id);

353: FETCH get_rec_from_id INTO l_mc_header_id, l_relationship_id;
354: IF get_rec_from_id%NOTFOUND THEN
355: x_return_status := FND_API.G_RET_STS_ERROR;
356: FND_MESSAGE.set_name('AHL', 'AHL_UC_MC_HEADER_ID_INVALID');
357: FND_MESSAGE.set_token('MC_HEADER_ID', p_x_mc_header_id);
358: FND_MSG_PUB.add;
359: ELSE
360: p_x_mc_header_id := l_mc_header_id;
361: x_relationship_id := l_relationship_id;

Line 372: FND_MESSAGE.set_name('AHL', 'AHL_UC_MC_HEADER_INVALID');

368: EXIT WHEN get_rec_from_value%NOTFOUND;
369: END LOOP;
370: IF ( get_rec_from_value%ROWCOUNT = 0 ) THEN
371: x_return_status := FND_API.G_RET_STS_ERROR;
372: FND_MESSAGE.set_name('AHL', 'AHL_UC_MC_HEADER_INVALID');
373: FND_MESSAGE.set_token('MC_NAME', p_mc_name);
374: FND_MESSAGE.set_token('MC_REV', p_mc_revision);
375: FND_MSG_PUB.add;
376: ELSIF ( get_rec_from_value%ROWCOUNT = 1 ) THEN

Line 373: FND_MESSAGE.set_token('MC_NAME', p_mc_name);

369: END LOOP;
370: IF ( get_rec_from_value%ROWCOUNT = 0 ) THEN
371: x_return_status := FND_API.G_RET_STS_ERROR;
372: FND_MESSAGE.set_name('AHL', 'AHL_UC_MC_HEADER_INVALID');
373: FND_MESSAGE.set_token('MC_NAME', p_mc_name);
374: FND_MESSAGE.set_token('MC_REV', p_mc_revision);
375: FND_MSG_PUB.add;
376: ELSIF ( get_rec_from_value%ROWCOUNT = 1 ) THEN
377: p_x_mc_header_id := l_mc_header_id;

Line 374: FND_MESSAGE.set_token('MC_REV', p_mc_revision);

370: IF ( get_rec_from_value%ROWCOUNT = 0 ) THEN
371: x_return_status := FND_API.G_RET_STS_ERROR;
372: FND_MESSAGE.set_name('AHL', 'AHL_UC_MC_HEADER_INVALID');
373: FND_MESSAGE.set_token('MC_NAME', p_mc_name);
374: FND_MESSAGE.set_token('MC_REV', p_mc_revision);
375: FND_MSG_PUB.add;
376: ELSIF ( get_rec_from_value%ROWCOUNT = 1 ) THEN
377: p_x_mc_header_id := l_mc_header_id;
378: x_relationship_id := l_relationship_id;

Line 381: FND_MESSAGE.set_name('AHL', 'AHL_UC_MC_HEADER_INVALID');

377: p_x_mc_header_id := l_mc_header_id;
378: x_relationship_id := l_relationship_id;
379: ELSE
380: x_return_status := FND_API.G_RET_STS_ERROR;
381: FND_MESSAGE.set_name('AHL', 'AHL_UC_MC_HEADER_INVALID');
382: FND_MESSAGE.set_token('MC_NAME', p_mc_name);
383: FND_MESSAGE.set_token('MC_REV', p_mc_revision);
384: FND_MSG_PUB.add;
385: END IF;

Line 382: FND_MESSAGE.set_token('MC_NAME', p_mc_name);

378: x_relationship_id := l_relationship_id;
379: ELSE
380: x_return_status := FND_API.G_RET_STS_ERROR;
381: FND_MESSAGE.set_name('AHL', 'AHL_UC_MC_HEADER_INVALID');
382: FND_MESSAGE.set_token('MC_NAME', p_mc_name);
383: FND_MESSAGE.set_token('MC_REV', p_mc_revision);
384: FND_MSG_PUB.add;
385: END IF;
386: CLOSE get_rec_from_value;

Line 383: FND_MESSAGE.set_token('MC_REV', p_mc_revision);

379: ELSE
380: x_return_status := FND_API.G_RET_STS_ERROR;
381: FND_MESSAGE.set_name('AHL', 'AHL_UC_MC_HEADER_INVALID');
382: FND_MESSAGE.set_token('MC_NAME', p_mc_name);
383: FND_MESSAGE.set_token('MC_REV', p_mc_revision);
384: FND_MSG_PUB.add;
385: END IF;
386: CLOSE get_rec_from_value;
387: END IF;

Line 470: FND_MESSAGE.set_name('AHL', 'AHL_COM_INVALID_PROCEDURE_CALL');

466: BEGIN
467: x_return_status := FND_API.G_RET_STS_SUCCESS;
468: IF p_instance_num IS NULL AND p_x_instance_id IS NULL THEN
469: x_return_status := FND_API.G_RET_STS_ERROR;
470: FND_MESSAGE.set_name('AHL', 'AHL_COM_INVALID_PROCEDURE_CALL');
471: FND_MSG_PUB.add;
472: ELSIF p_instance_num IS NULL AND p_x_instance_id IS NOT NULL THEN
473: OPEN get_rec_from_id(p_x_instance_id, p_relationship_id);
474: FETCH get_rec_from_id INTO l_instance_id;

Line 477: FND_MESSAGE.set_name('AHL', 'AHL_UC_CSII_INVALID');

473: OPEN get_rec_from_id(p_x_instance_id, p_relationship_id);
474: FETCH get_rec_from_id INTO l_instance_id;
475: IF get_rec_from_id%NOTFOUND THEN
476: x_return_status := FND_API.G_RET_STS_ERROR;
477: FND_MESSAGE.set_name('AHL', 'AHL_UC_CSII_INVALID');
478: FND_MESSAGE.set_token('CSII', p_x_instance_id);
479: FND_MSG_PUB.add;
480: END IF;
481: CLOSE get_rec_from_id;

Line 478: FND_MESSAGE.set_token('CSII', p_x_instance_id);

474: FETCH get_rec_from_id INTO l_instance_id;
475: IF get_rec_from_id%NOTFOUND THEN
476: x_return_status := FND_API.G_RET_STS_ERROR;
477: FND_MESSAGE.set_name('AHL', 'AHL_UC_CSII_INVALID');
478: FND_MESSAGE.set_token('CSII', p_x_instance_id);
479: FND_MSG_PUB.add;
480: END IF;
481: CLOSE get_rec_from_id;
482: ELSIF p_instance_num IS NOT NULL THEN

Line 490: FND_MESSAGE.set_name('AHL', 'AHL_UC_CSII_INVALID');

486: EXIT WHEN get_rec_from_value%NOTFOUND;
487: END LOOP;
488: IF ( get_rec_from_value%ROWCOUNT = 0 ) THEN
489: x_return_status := FND_API.G_RET_STS_ERROR;
490: FND_MESSAGE.set_name('AHL', 'AHL_UC_CSII_INVALID');
491: FND_MESSAGE.set_token('CSII', p_instance_num);
492: FND_MSG_PUB.add;
493: ELSIF ( get_rec_from_value%ROWCOUNT = 1 ) THEN
494: p_x_instance_id := l_instance_id;

Line 491: FND_MESSAGE.set_token('CSII', p_instance_num);

487: END LOOP;
488: IF ( get_rec_from_value%ROWCOUNT = 0 ) THEN
489: x_return_status := FND_API.G_RET_STS_ERROR;
490: FND_MESSAGE.set_name('AHL', 'AHL_UC_CSII_INVALID');
491: FND_MESSAGE.set_token('CSII', p_instance_num);
492: FND_MSG_PUB.add;
493: ELSIF ( get_rec_from_value%ROWCOUNT = 1 ) THEN
494: p_x_instance_id := l_instance_id;
495: ELSE

Line 497: FND_MESSAGE.set_name('AHL', 'AHL_UC_CSII_INVALID');

493: ELSIF ( get_rec_from_value%ROWCOUNT = 1 ) THEN
494: p_x_instance_id := l_instance_id;
495: ELSE
496: x_return_status := FND_API.G_RET_STS_ERROR;
497: FND_MESSAGE.set_name('AHL', 'AHL_UC_CSII_INVALID');
498: FND_MESSAGE.set_token('CSII', p_instance_num);
499: FND_MSG_PUB.add;
500: END IF;
501: CLOSE get_rec_from_value;

Line 498: FND_MESSAGE.set_token('CSII', p_instance_num);

494: p_x_instance_id := l_instance_id;
495: ELSE
496: x_return_status := FND_API.G_RET_STS_ERROR;
497: FND_MESSAGE.set_name('AHL', 'AHL_UC_CSII_INVALID');
498: FND_MESSAGE.set_token('CSII', p_instance_num);
499: FND_MSG_PUB.add;
500: END IF;
501: CLOSE get_rec_from_value;
502: END IF;

Line 534: FND_MESSAGE.set_name( 'AHL','AHL_UC_NAME_DUPLICATE' );

530: IF p_dml_operation = 'C' THEN
531: OPEN check_uc_name1(p_uc_header_rec.uc_name);
532: FETCH check_uc_name1 INTO l_dummy;
533: IF check_uc_name1%FOUND THEN
534: FND_MESSAGE.set_name( 'AHL','AHL_UC_NAME_DUPLICATE' );
535: FND_MESSAGE.set_token( 'NAME', p_uc_header_rec.uc_name );
536: FND_MSG_PUB.add;
537: x_return_status := FND_API.G_RET_STS_ERROR;
538: END IF;

Line 535: FND_MESSAGE.set_token( 'NAME', p_uc_header_rec.uc_name );

531: OPEN check_uc_name1(p_uc_header_rec.uc_name);
532: FETCH check_uc_name1 INTO l_dummy;
533: IF check_uc_name1%FOUND THEN
534: FND_MESSAGE.set_name( 'AHL','AHL_UC_NAME_DUPLICATE' );
535: FND_MESSAGE.set_token( 'NAME', p_uc_header_rec.uc_name );
536: FND_MSG_PUB.add;
537: x_return_status := FND_API.G_RET_STS_ERROR;
538: END IF;
539: CLOSE check_uc_name1;

Line 544: FND_MESSAGE.set_name( 'AHL','AHL_UC_NAME_DUPLICATE' );

540: ELSIF p_dml_operation = 'U' THEN
541: OPEN check_uc_name2(p_uc_header_rec.uc_name, p_uc_header_rec.uc_header_id);
542: FETCH check_uc_name2 INTO l_dummy;
543: IF check_uc_name2%FOUND THEN
544: FND_MESSAGE.set_name( 'AHL','AHL_UC_NAME_DUPLICATE' );
545: FND_MESSAGE.set_token( 'NAME', p_uc_header_rec.uc_name );
546: FND_MSG_PUB.add;
547: x_return_status := FND_API.G_RET_STS_ERROR;
548: END IF;

Line 545: FND_MESSAGE.set_token( 'NAME', p_uc_header_rec.uc_name );

541: OPEN check_uc_name2(p_uc_header_rec.uc_name, p_uc_header_rec.uc_header_id);
542: FETCH check_uc_name2 INTO l_dummy;
543: IF check_uc_name2%FOUND THEN
544: FND_MESSAGE.set_name( 'AHL','AHL_UC_NAME_DUPLICATE' );
545: FND_MESSAGE.set_token( 'NAME', p_uc_header_rec.uc_name );
546: FND_MSG_PUB.add;
547: x_return_status := FND_API.G_RET_STS_ERROR;
548: END IF;
549: CLOSE check_uc_name2;

Line 556: FND_MESSAGE.set_name( 'AHL','AHL_UC_NAME_CHANGE_UNALLOWED' );

552: IF p_uc_header_rec.unit_config_status_code NOT IN ('DRAFT', 'APPROVAL_REJECTED') THEN
553: OPEN check_uc_name3(p_uc_header_rec.uc_header_id);
554: FETCH check_uc_name3 INTO l_name;
555: IF check_uc_name3%FOUND AND (l_name.name <> p_uc_header_rec.uc_name) THEN
556: FND_MESSAGE.set_name( 'AHL','AHL_UC_NAME_CHANGE_UNALLOWED' );
557: FND_MSG_PUB.add;
558: x_return_status := FND_API.G_RET_STS_ERROR;
559: END IF;
560: CLOSE check_uc_name3;

Line 567: FND_MESSAGE.set_name('AHL','AHL_UC_NAME_NULL');

563: -- Check name is not null. This procedure is executed after nullify_attributes
564: -- (create) or convert_attributes(update), so the check is the same for creation
565: -- and update.
566: IF p_uc_header_rec.uc_name is NULL THEN
567: FND_MESSAGE.set_name('AHL','AHL_UC_NAME_NULL');
568: FND_MSG_PUB.add;
569: x_return_status := FND_API.G_RET_STS_ERROR;
570: END IF;
571: -- The following checks are actually not really necessary.

Line 574: FND_MESSAGE.set_name('AHL','AHL_MC_HEADER_ID_INVALID');

570: END IF;
571: -- The following checks are actually not really necessary.
572: -- Check if the master_config_id contains a null value.
573: IF p_uc_header_rec.mc_header_id IS NULL THEN
574: FND_MESSAGE.set_name('AHL','AHL_MC_HEADER_ID_INVALID');
575: FND_MESSAGE.set_token('MC_HEADER_ID', p_uc_header_rec.mc_header_id);
576: FND_MSG_PUB.add;
577: x_return_status := FND_API.G_RET_STS_ERROR;
578: END IF;

Line 575: FND_MESSAGE.set_token('MC_HEADER_ID', p_uc_header_rec.mc_header_id);

571: -- The following checks are actually not really necessary.
572: -- Check if the master_config_id contains a null value.
573: IF p_uc_header_rec.mc_header_id IS NULL THEN
574: FND_MESSAGE.set_name('AHL','AHL_MC_HEADER_ID_INVALID');
575: FND_MESSAGE.set_token('MC_HEADER_ID', p_uc_header_rec.mc_header_id);
576: FND_MSG_PUB.add;
577: x_return_status := FND_API.G_RET_STS_ERROR;
578: END IF;
579: -- Check if the csi_item_instance_id contains a null value.

Line 581: FND_MESSAGE.set_name('AHL','AHL_UC_INSTANCE_NULL');

577: x_return_status := FND_API.G_RET_STS_ERROR;
578: END IF;
579: -- Check if the csi_item_instance_id contains a null value.
580: IF p_uc_header_rec.instance_id IS NULL THEN
581: FND_MESSAGE.set_name('AHL','AHL_UC_INSTANCE_NULL');
582: FND_MSG_PUB.add;
583: x_return_status := FND_API.G_RET_STS_ERROR;
584: END IF;
585: -- Check if the unit_config_status_code contains a null value.

Line 587: FND_MESSAGE.set_name('AHL','AHL_UC_CONFIG_STATUS_NULL');

583: x_return_status := FND_API.G_RET_STS_ERROR;
584: END IF;
585: -- Check if the unit_config_status_code contains a null value.
586: IF p_uc_header_rec.unit_config_status_code IS NULL THEN
587: FND_MESSAGE.set_name('AHL','AHL_UC_CONFIG_STATUS_NULL');
588: FND_MSG_PUB.add;
589: x_return_status := FND_API.G_RET_STS_ERROR;
590: END IF;
591:

Line 801: FND_MESSAGE.set_name('AHL', 'AHL_UC_HISTORY_COPY_FAILED');

797: -- Insert into the exactly same record into ahl_unit_config_headers_h
798: ahl_util_uc_pkg.copy_uc_header_to_history(p_x_uc_header_rec.uc_header_id, l_return_status);
799: --IF history copy failed, then don't raise exception, just add the message to the message stack
800: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
801: FND_MESSAGE.set_name('AHL', 'AHL_UC_HISTORY_COPY_FAILED');
802: FND_MSG_PUB.add;
803: END IF;
804:
805: --Need to check if the instance picked from CSI with serial_number has a serial_no_tag, and

Line 812: FND_MESSAGE.set_name('AHL', 'AHL_UC_CSII_INVALID');

808: --mfg_searil_numbers, otherwise it is 'TEMPORARY'
809: OPEN get_serial_number(p_x_uc_header_rec.instance_id);
810: FETCH get_serial_number INTO l_serial_number, l_mfg_serial_number_flag;
811: IF get_serial_number%NOTFOUND THEN
812: FND_MESSAGE.set_name('AHL', 'AHL_UC_CSII_INVALID');
813: FND_MESSAGE.set_token('CSII', p_x_uc_header_rec.instance_id);
814: FND_MSG_PUB.add;
815: RAISE FND_API.G_EXC_ERROR;
816: CLOSE get_serial_number;

Line 813: FND_MESSAGE.set_token('CSII', p_x_uc_header_rec.instance_id);

809: OPEN get_serial_number(p_x_uc_header_rec.instance_id);
810: FETCH get_serial_number INTO l_serial_number, l_mfg_serial_number_flag;
811: IF get_serial_number%NOTFOUND THEN
812: FND_MESSAGE.set_name('AHL', 'AHL_UC_CSII_INVALID');
813: FND_MESSAGE.set_token('CSII', p_x_uc_header_rec.instance_id);
814: FND_MSG_PUB.add;
815: RAISE FND_API.G_EXC_ERROR;
816: CLOSE get_serial_number;
817: ELSE

Line 845: FND_MESSAGE.set_name('AHL','AHL_UC_ATTRIB_CODE_MISSING');

841: l_csi_transaction_rec.source_transaction_date := SYSDATE;
842: l_csi_transaction_rec.transaction_type_id := l_transaction_type_id;
843: AHL_Util_UC_Pkg.getcsi_attribute_id('AHL_TEMP_SERIAL_NUM', l_attribute_id,l_return_val);
844: IF NOT(l_return_val) THEN
845: FND_MESSAGE.set_name('AHL','AHL_UC_ATTRIB_CODE_MISSING');
846: FND_MESSAGE.set_token('CODE', 'AHL_TEMP_SERIAL_NUM');
847: FND_MSG_PUB.add;
848: ELSE
849: l_csi_extend_attrib_rec.attribute_id := l_attribute_id;

Line 846: FND_MESSAGE.set_token('CODE', 'AHL_TEMP_SERIAL_NUM');

842: l_csi_transaction_rec.transaction_type_id := l_transaction_type_id;
843: AHL_Util_UC_Pkg.getcsi_attribute_id('AHL_TEMP_SERIAL_NUM', l_attribute_id,l_return_val);
844: IF NOT(l_return_val) THEN
845: FND_MESSAGE.set_name('AHL','AHL_UC_ATTRIB_CODE_MISSING');
846: FND_MESSAGE.set_token('CODE', 'AHL_TEMP_SERIAL_NUM');
847: FND_MSG_PUB.add;
848: ELSE
849: l_csi_extend_attrib_rec.attribute_id := l_attribute_id;
850: l_csi_extend_attrib_rec.attribute_value := l_serial_number_tag;

Line 986: FND_MESSAGE.set_name( 'AHL','AHL_UC_INVALID_Q_ACTION' );

982: END IF;
983:
984: -- ACL :: Changes for R12
985: IF (ahl_util_uc_pkg.IS_UNIT_QUARANTINED(p_unit_header_id => p_x_uc_header_rec.uc_header_id , p_instance_id => null) = FND_API.G_TRUE) THEN
986: FND_MESSAGE.set_name( 'AHL','AHL_UC_INVALID_Q_ACTION' );
987: FND_MSG_PUB.add;
988: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
989: END IF;
990:

Line 1045: FND_MESSAGE.set_name('AHL', 'AHL_COM_RECORD_CHANGED');

1041: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1042: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1043: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': within API','ovn='||p_x_uc_header_rec.object_version_number);
1044: END IF;
1045: FND_MESSAGE.set_name('AHL', 'AHL_COM_RECORD_CHANGED');
1046: FND_MSG_PUB.add;
1047: x_return_status := FND_API.G_RET_STS_ERROR;
1048: RAISE FND_API.G_EXC_ERROR;
1049: END IF;

Line 1054: FND_MESSAGE.set_name('AHL', 'AHL_UC_HISTORY_COPY_FAILED');

1050:
1051: ahl_util_uc_pkg.copy_uc_header_to_history(p_x_uc_header_rec.uc_header_id, l_return_status);
1052: --IF history copy failed, then don't raise exception, just add the message to the message stack
1053: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1054: FND_MESSAGE.set_name('AHL', 'AHL_UC_HISTORY_COPY_FAILED');
1055: FND_MSG_PUB.add;
1056: END IF;
1057:
1058: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1256: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_PROCEDURE_CALL' );

1252:
1253: IF (p_uc_header_id IS NULL OR p_uc_header_id = FND_API.G_MISS_NUM OR
1254: p_object_version_number IS NULL OR p_object_version_number = FND_API.G_MISS_NUM OR
1255: p_csi_instance_ovn IS NULL OR p_csi_instance_ovn = FND_API.G_MISS_NUM ) THEN
1256: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_PROCEDURE_CALL' );
1257: FND_MSG_PUB.add;
1258: RAISE FND_API.G_EXC_ERROR;
1259: END IF;
1260:

Line 1267: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');

1263: OPEN get_top_unit(p_uc_header_id);
1264: FETCH get_top_unit INTO l_dummy_num, l_uc_status;
1265: IF get_top_unit%NOTFOUND THEN
1266: CLOSE get_top_unit;
1267: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
1268: FND_MESSAGE.set_token('NAME', 'uc_header_id');
1269: FND_MESSAGE.set_token('VALUE', p_uc_header_id);
1270: FND_MSG_PUB.add;
1271: RAISE FND_API.G_EXC_ERROR;

Line 1268: FND_MESSAGE.set_token('NAME', 'uc_header_id');

1264: FETCH get_top_unit INTO l_dummy_num, l_uc_status;
1265: IF get_top_unit%NOTFOUND THEN
1266: CLOSE get_top_unit;
1267: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
1268: FND_MESSAGE.set_token('NAME', 'uc_header_id');
1269: FND_MESSAGE.set_token('VALUE', p_uc_header_id);
1270: FND_MSG_PUB.add;
1271: RAISE FND_API.G_EXC_ERROR;
1272: ELSIF (l_uc_status IS NULL OR l_uc_status NOT IN ('DRAFT', 'APPROVAL_REJECTED')) THEN

Line 1269: FND_MESSAGE.set_token('VALUE', p_uc_header_id);

1265: IF get_top_unit%NOTFOUND THEN
1266: CLOSE get_top_unit;
1267: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
1268: FND_MESSAGE.set_token('NAME', 'uc_header_id');
1269: FND_MESSAGE.set_token('VALUE', p_uc_header_id);
1270: FND_MSG_PUB.add;
1271: RAISE FND_API.G_EXC_ERROR;
1272: ELSIF (l_uc_status IS NULL OR l_uc_status NOT IN ('DRAFT', 'APPROVAL_REJECTED')) THEN
1273: CLOSE get_top_unit;

Line 1274: FND_MESSAGE.set_name( 'AHL', 'AHL_UC_STATUS_NOT_DRAFT' );

1270: FND_MSG_PUB.add;
1271: RAISE FND_API.G_EXC_ERROR;
1272: ELSIF (l_uc_status IS NULL OR l_uc_status NOT IN ('DRAFT', 'APPROVAL_REJECTED')) THEN
1273: CLOSE get_top_unit;
1274: FND_MESSAGE.set_name( 'AHL', 'AHL_UC_STATUS_NOT_DRAFT' );
1275: FND_MSG_PUB.add;
1276: RAISE FND_API.G_EXC_ERROR;
1277: END IF;
1278:

Line 1284: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');

1280: OPEN get_uc_header(p_uc_header_id);
1281: FETCH get_uc_header INTO l_uc_header_rec;
1282: IF get_uc_header%NOTFOUND THEN
1283: CLOSE get_uc_header;
1284: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
1285: FND_MESSAGE.set_token('NAME', 'uc_header_id');
1286: FND_MESSAGE.set_token('VALUE', p_uc_header_id);
1287: FND_MSG_PUB.add;
1288: RAISE FND_API.G_EXC_ERROR;

Line 1285: FND_MESSAGE.set_token('NAME', 'uc_header_id');

1281: FETCH get_uc_header INTO l_uc_header_rec;
1282: IF get_uc_header%NOTFOUND THEN
1283: CLOSE get_uc_header;
1284: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
1285: FND_MESSAGE.set_token('NAME', 'uc_header_id');
1286: FND_MESSAGE.set_token('VALUE', p_uc_header_id);
1287: FND_MSG_PUB.add;
1288: RAISE FND_API.G_EXC_ERROR;
1289: ELSE

Line 1286: FND_MESSAGE.set_token('VALUE', p_uc_header_id);

1282: IF get_uc_header%NOTFOUND THEN
1283: CLOSE get_uc_header;
1284: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
1285: FND_MESSAGE.set_token('NAME', 'uc_header_id');
1286: FND_MESSAGE.set_token('VALUE', p_uc_header_id);
1287: FND_MSG_PUB.add;
1288: RAISE FND_API.G_EXC_ERROR;
1289: ELSE
1290: CLOSE get_uc_header;

Line 1305: FND_MESSAGE.set_name('AHL', 'AHL_COM_RECORD_CHANGED');

1301: WHERE unit_config_header_id = p_uc_header_id
1302: AND object_version_number = p_object_version_number;
1303:
1304: IF SQL%NOTFOUND THEN
1305: FND_MESSAGE.set_name('AHL', 'AHL_COM_RECORD_CHANGED');
1306: FND_MSG_PUB.add;
1307: x_return_status := FND_API.G_RET_STS_ERROR;
1308: RAISE FND_API.G_EXC_ERROR;
1309: END IF;

Line 1314: FND_MESSAGE.set_name('AHL', 'AHL_UC_HISTORY_COPY_FAILED');

1310:
1311: ahl_util_uc_pkg.copy_uc_header_to_history(p_uc_header_id, l_return_status);
1312: --IF history copy failed, then don't raise exception, just add the message tothe message stack
1313: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1314: FND_MESSAGE.set_name('AHL', 'AHL_UC_HISTORY_COPY_FAILED');
1315: FND_MSG_PUB.add;
1316: END IF;
1317:
1318: --The following lines are used to expire all the instances and subunits installed in this

Line 1341: FND_MESSAGE.set_name('AHL','AHL_COM_RECORD_DELETED');

1337: OPEN get_csi_obj_ver_num(l_uc_header_rec.csi_instance_id);
1338: FETCH get_csi_obj_ver_num INTO l_csi_instance_ovn;
1339: IF (get_csi_obj_ver_num%NOTFOUND) THEN
1340: CLOSE get_csi_obj_ver_num;
1341: FND_MESSAGE.set_name('AHL','AHL_COM_RECORD_DELETED');
1342: FND_MSG_PUB.add;
1343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1344: ELSIF (l_csi_instance_ovn <> p_csi_instance_ovn) THEN
1345: CLOSE get_csi_obj_ver_num;

Line 1346: FND_MESSAGE.set_name('AHL','AHL_COM_RECORD_CHANGED');

1342: FND_MSG_PUB.add;
1343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1344: ELSIF (l_csi_instance_ovn <> p_csi_instance_ovn) THEN
1345: CLOSE get_csi_obj_ver_num;
1346: FND_MESSAGE.set_name('AHL','AHL_COM_RECORD_CHANGED');
1347: FND_MSG_PUB.add;
1348: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1349: END IF;
1350:

Line 1358: FND_MESSAGE.set_name('AHL','AHL_UC_CSI_REL_REC_INVALID');

1354: OPEN get_csi_ii_relationship(l_uc_header_rec.csi_instance_id);
1355: FETCH get_csi_ii_relationship INTO l_csi_relationship_id, l_object_version_number;
1356: IF get_csi_ii_relationship%NOTFOUND THEN
1357: CLOSE get_csi_ii_relationship;
1358: FND_MESSAGE.set_name('AHL','AHL_UC_CSI_REL_REC_INVALID');
1359: FND_MESSAGE.set_token('INSTANCE', l_uc_header_rec.csi_instance_id);
1360: FND_MSG_PUB.add;
1361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1362: ELSE

Line 1359: FND_MESSAGE.set_token('INSTANCE', l_uc_header_rec.csi_instance_id);

1355: FETCH get_csi_ii_relationship INTO l_csi_relationship_id, l_object_version_number;
1356: IF get_csi_ii_relationship%NOTFOUND THEN
1357: CLOSE get_csi_ii_relationship;
1358: FND_MESSAGE.set_name('AHL','AHL_UC_CSI_REL_REC_INVALID');
1359: FND_MESSAGE.set_token('INSTANCE', l_uc_header_rec.csi_instance_id);
1360: FND_MSG_PUB.add;
1361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1362: ELSE
1363: CLOSE get_csi_ii_relationship;

Line 1422: FND_MESSAGE.set_name('AHL', 'AHL_UC_HISTORY_COPY_FAILED');

1418:
1419: ahl_util_uc_pkg.copy_uc_header_to_history(l_subunits.unit_config_header_id,l_return_status);
1420: --IF history copy failed, then don't raise exception, just add the messageto the message stack
1421: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1422: FND_MESSAGE.set_name('AHL', 'AHL_UC_HISTORY_COPY_FAILED');
1423: FND_MSG_PUB.add;
1424: END IF;
1425: END LOOP;
1426: