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.GMD_SPEC_GRP dependencies on FND_MSG_PUB

Line 481: FND_MSG_PUB.ADD;

477: IF l_test_type IN ('U','T','V') THEN
478:
479: IF (x_spec_tests.display_precision IS NOT NULL OR x_spec_tests.report_precision IS NOT NULL) THEN
480: FND_MESSAGE.SET_NAME('GMD','GMD_PRECISION_NOT_REQD');
481: FND_MSG_PUB.ADD;
482: RAISE FND_API.G_EXC_ERROR;
483: END IF;
484:
485: IF (x_spec_tests.min_value_num IS NOT NULL OR x_spec_tests.max_value_num IS NOT NULL) THEN

Line 487: FND_MSG_PUB.ADD;

483: END IF;
484:
485: IF (x_spec_tests.min_value_num IS NOT NULL OR x_spec_tests.max_value_num IS NOT NULL) THEN
486: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_NUM_RANGE_NOT_REQD');
487: FND_MSG_PUB.ADD;
488: RAISE FND_API.G_EXC_ERROR;
489: END IF;
490:
491: IF x_spec_tests.target_value_num IS NOT NULL THEN

Line 493: FND_MSG_PUB.ADD;

489: END IF;
490:
491: IF x_spec_tests.target_value_num IS NOT NULL THEN
492: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_NUM_TARGET_NOT_REQD');
493: FND_MSG_PUB.ADD;
494: RAISE FND_API.G_EXC_ERROR;
495: END IF;
496: --BEGIN BUG#3545701
497: --Commented the code for Non-validated tests.

Line 500: FND_MSG_PUB.ADD;

496: --BEGIN BUG#3545701
497: --Commented the code for Non-validated tests.
498: /* IF l_test_type = 'U' and x_spec_tests.target_value_char IS NOT NULL THEN
499: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_CHAR_TARGET_NOT_REQD');
500: FND_MSG_PUB.ADD;
501: RAISE FND_API.G_EXC_ERROR; */
502: --END BUG#3545701
503: IF l_test_type = 'V' and x_spec_tests.target_value_char IS NULL THEN
504: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_CHAR_TARGET_REQD');

Line 505: FND_MSG_PUB.ADD;

501: RAISE FND_API.G_EXC_ERROR; */
502: --END BUG#3545701
503: IF l_test_type = 'V' and x_spec_tests.target_value_char IS NULL THEN
504: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_CHAR_TARGET_REQD');
505: FND_MSG_PUB.ADD;
506: RAISE FND_API.G_EXC_ERROR;
507: END IF;
508:
509: IF (l_test_type = 'T') THEN

Line 512: FND_MSG_PUB.ADD;

508:
509: IF (l_test_type = 'T') THEN
510: IF (x_spec_tests.min_value_char IS NULL OR x_spec_tests.max_value_char IS NULL) THEN
511: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_RANGE_REQ');
512: FND_MSG_PUB.ADD;
513: RAISE FND_API.G_EXC_ERROR;
514: END IF;
515: ELSE
516: IF (x_spec_tests.min_value_char IS NOT NULL OR x_spec_tests.max_value_char IS NOT NULL) THEN

Line 518: FND_MSG_PUB.ADD;

514: END IF;
515: ELSE
516: IF (x_spec_tests.min_value_char IS NOT NULL OR x_spec_tests.max_value_char IS NOT NULL) THEN
517: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_CHAR_RANGE_NOT_REQD');
518: FND_MSG_PUB.ADD;
519: RAISE FND_API.G_EXC_ERROR;
520: END IF;
521: END IF;
522:

Line 527: FND_MSG_PUB.ADD;

523: --BEGIN BUG#3545701
524: --Commented the code for Non-validated tests.
525: /* IF l_test_type = 'U' and x_spec_tests.out_of_spec_action IS NOT NULL THEN
526: FND_MESSAGE.SET_NAME('GMD','GMD_ACTION_CODE_NOT_REQD');
527: FND_MSG_PUB.ADD;
528: RAISE FND_API.G_EXC_ERROR;
529: END IF; */
530: --END BUG#3545701
531:

Line 534: FND_MSG_PUB.ADD;

530: --END BUG#3545701
531:
532: IF x_spec_tests.exp_error_type IS NOT NULL THEN
533: FND_MESSAGE.SET_NAME('GMD','GMD_INVALID_EXP_ERROR_TYPE');
534: FND_MSG_PUB.ADD;
535: RAISE FND_API.G_EXC_ERROR;
536: END IF;
537:
538: IF (x_spec_tests.below_spec_min IS NOT NULL OR x_spec_tests.below_min_action_code IS NOT NULL )

Line 543: FND_MSG_PUB.ADD;

539: OR (x_spec_tests.above_spec_min IS NOT NULL OR x_spec_tests.above_min_action_code IS NOT NULL )
540: OR (x_spec_tests.below_spec_max IS NOT NULL OR x_spec_tests.below_max_action_code IS NOT NULL )
541: OR (x_spec_tests.above_spec_max IS NOT NULL OR x_spec_tests.above_max_action_code IS NOT NULL ) THEN
542: FND_MESSAGE.SET_NAME('GMD', 'GMD_EXP_ERROR_NOT_REQD');
543: FND_MSG_PUB.ADD;
544: RAISE FND_API.G_EXC_ERROR;
545: END IF;
546: ELSE
547: IF (x_spec_tests.display_precision IS NULL OR x_spec_tests.report_precision IS NULL ) THEN

Line 564: FND_MSG_PUB.ADD;

560: END IF;
561:
562: IF (x_spec_tests.min_value_num IS NULL AND x_spec_tests.max_value_num IS NULL) THEN
563: FND_MESSAGE.SET_NAME('GMD','GMD_MIN_MAX_REQ');
564: FND_MSG_PUB.ADD;
565: RAISE FND_API.G_EXC_ERROR;
566: END IF;
567:
568: IF ((x_spec_tests.min_value_num IS NULL AND l_test_min_value_num IS NOT NULL)

Line 571: FND_MSG_PUB.ADD;

567:
568: IF ((x_spec_tests.min_value_num IS NULL AND l_test_min_value_num IS NOT NULL)
569: OR (x_spec_tests.max_value_num IS NULL AND l_test_max_value_num IS NOT NULL)) THEN
570: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_RANGE_REQ');
571: FND_MSG_PUB.ADD;
572: RAISE FND_API.G_EXC_ERROR;
573: END IF;
574:
575: IF (x_spec_tests.min_value_char IS NOT NULL OR x_spec_tests.max_value_char IS NOT NULL) THEN

Line 577: FND_MSG_PUB.ADD;

573: END IF;
574:
575: IF (x_spec_tests.min_value_char IS NOT NULL OR x_spec_tests.max_value_char IS NOT NULL) THEN
576: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_CHAR_RANGE_NOT_REQD');
577: FND_MSG_PUB.ADD;
578: RAISE FND_API.G_EXC_ERROR;
579: END IF;
580:
581: IF x_spec_tests.target_value_char IS NOT NULL THEN

Line 583: FND_MSG_PUB.ADD;

579: END IF;
580:
581: IF x_spec_tests.target_value_char IS NOT NULL THEN
582: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_CHAR_TARGET_NOT_REQD');
583: FND_MSG_PUB.ADD;
584: RAISE FND_API.G_EXC_ERROR;
585: END IF;
586:
587: IF ((x_spec_tests.exp_error_type IN ('N','P')) OR (x_spec_tests.exp_error_type IS NULL)) THEN

Line 591: FND_MSG_PUB.ADD;

587: IF ((x_spec_tests.exp_error_type IN ('N','P')) OR (x_spec_tests.exp_error_type IS NULL)) THEN
588: NULL ;
589: ELSE
590: FND_MESSAGE.SET_NAME('GMD','GMD_INVALID_EXP_ERROR_TYPE');
591: FND_MSG_PUB.ADD;
592: RAISE FND_API.G_EXC_ERROR;
593: END IF;
594:
595: IF x_spec_tests.exp_error_type IS NULL AND

Line 600: FND_MSG_PUB.ADD;

596: (x_spec_tests.below_spec_min IS NOT NULL OR x_spec_tests.above_spec_min IS NOT NULL
597: OR x_spec_tests.below_spec_max IS NOT NULL OR x_spec_tests.above_spec_max IS NOT NULL)
598: THEN
599: FND_MESSAGE.SET_NAME('GMD', 'GMD_EXP_ERROR_TYPE_REQ');
600: FND_MSG_PUB.ADD;
601: RAISE FND_API.G_EXC_ERROR;
602: END IF;
603:
604: IF x_spec_tests.exp_error_type IS NOT NULL AND

Line 609: FND_MSG_PUB.ADD;

605: (x_spec_tests.below_spec_min IS NULL AND x_spec_tests.above_spec_min IS NULL
606: AND x_spec_tests.below_spec_max IS NULL AND x_spec_tests.above_spec_max IS NULL)
607: THEN
608: FND_MESSAGE.SET_NAME('GMD', 'GMD_EXP_ERR_TYPE_NULL');
609: FND_MSG_PUB.ADD;
610: RAISE FND_API.G_EXC_ERROR;
611: END IF;
612:
613: END IF;

Line 1248: FND_MSG_PUB.ADD;

1244: uom_rate => l_dummy );
1245:
1246: EXCEPTION WHEN OTHERS
1247: THEN
1248: FND_MSG_PUB.ADD;
1249: RAISE FND_API.G_EXC_ERROR;
1250: END ;
1251: END IF;
1252:

Line 1484: FND_MSG_PUB.ADD;

1480: WHERE spec_id = p_spec_id ;
1481:
1482: IF l_test_count = 0 THEN
1483: FND_MESSAGE.SET_NAME('GMD','GMD_SPEC_NO_TEST');
1484: FND_MSG_PUB.ADD;
1485: RAISE FND_API.G_EXC_ERROR;
1486: END IF;
1487:
1488: -- validate expression based tests.

Line 1549: FND_MSG_PUB.ADD;

1545: -- validate for primary key
1546: -- ========================
1547: IF p_spec_id IS NULL THEN
1548: FND_MESSAGE.SET_NAME('GMD','GMD_SPEC_ID_REQUIRED'); -- New Message
1549: FND_MSG_PUB.ADD;
1550: RAISE FND_API.G_EXC_ERROR;
1551: ELSE
1552: l_spec.spec_id := p_spec_id;
1553: END IF;

Line 1563: fnd_msg_pub.ADD;

1559: fnd_message.set_name('GMD','GMD_FAILED_TO_FETCH_ROW');
1560: fnd_message.set_token('L_TABLE_NAME','GMD_SPECIFICATIONS');
1561: fnd_message.set_token('L_COLUMN_NAME','SPEC_ID');
1562: fnd_message.set_token('L_KEY_VALUE',l_spec.spec_id);
1563: fnd_msg_pub.ADD;
1564: RAISE FND_API.G_EXC_ERROR;
1565: END IF;
1566:
1567: l_spec := l_spec_out ;

Line 1577: fnd_msg_pub.ADD;

1573: fnd_message.set_name('GMD','GMD_RECORD_DELETE_MARKED');
1574: fnd_message.set_token('L_TABLE_NAME','GMD_SPECIFICATIONS');
1575: fnd_message.set_token('L_COLUMN_NAME','SPEC_ID');
1576: fnd_message.set_token('L_KEY_VALUE',l_spec.spec_id);
1577: fnd_msg_pub.ADD;
1578: RAISE FND_API.G_EXC_ERROR;
1579: END IF;
1580:
1581: -- BUG 2698311

Line 1588: fnd_msg_pub.ADD;

1584: -- ============================================================
1585: IF l_spec.spec_status in (400,700)
1586: THEN
1587: fnd_message.set_name('GMD','GMD_SPEC_STATUS_BLOCKS_DELETE');
1588: fnd_msg_pub.ADD;
1589: RAISE FND_API.G_EXC_ERROR;
1590: END IF;
1591:
1592: -- Ensure that the status permits updates

Line 1597: fnd_msg_pub.ADD;

1593: -- ======================================
1594: IF NOT GMD_SPEC_GRP.Record_Updateable_With_Status(l_spec.spec_status)
1595: THEN
1596: fnd_message.set_name('GMD','GMD_SPEC_STATUS_BLOCKS_UPDATE');
1597: fnd_msg_pub.ADD;
1598: RAISE FND_API.G_EXC_ERROR;
1599: END IF;
1600:
1601: EXCEPTION

Line 1604: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

1600:
1601: EXCEPTION
1602: WHEN FND_API.G_EXC_ERROR THEN
1603: x_return_status := FND_API.G_RET_STS_ERROR ;
1604: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1605:
1606: WHEN OTHERS THEN
1607: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
1608: FND_MESSAGE.Set_Token('PACKAGE','GMD_SPEC_GRP.VALIDATE_BEFORE_DELETE');

Line 1611: FND_MSG_PUB.ADD;

1607: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
1608: FND_MESSAGE.Set_Token('PACKAGE','GMD_SPEC_GRP.VALIDATE_BEFORE_DELETE');
1609: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
1610: FND_MESSAGE.Set_Token('POSITION',l_progress );
1611: FND_MSG_PUB.ADD;
1612: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1614:
1615: END VALIDATE_BEFORE_DELETE ;

Line 1612: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

1608: FND_MESSAGE.Set_Token('PACKAGE','GMD_SPEC_GRP.VALIDATE_BEFORE_DELETE');
1609: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
1610: FND_MESSAGE.Set_Token('POSITION',l_progress );
1611: FND_MSG_PUB.ADD;
1612: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1614:
1615: END VALIDATE_BEFORE_DELETE ;
1616:

Line 1649: FND_MSG_PUB.ADD;

1645: -- validate for primary key
1646: -- ========================
1647: IF p_spec_id IS NULL THEN
1648: FND_MESSAGE.SET_NAME('GMD','GMD_SPEC_ID_REQUIRED');
1649: FND_MSG_PUB.ADD;
1650: RAISE FND_API.G_EXC_ERROR;
1651: ELSE
1652: l_spec_tests.spec_id := p_spec_id;
1653: END IF;

Line 1657: FND_MSG_PUB.ADD;

1653: END IF;
1654:
1655: IF p_test_id IS NULL THEN
1656: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_ID_CODE_NULL');
1657: FND_MSG_PUB.ADD;
1658: RAISE FND_API.G_EXC_ERROR;
1659: ELSE
1660: l_spec_tests.test_id := p_test_id;
1661: END IF;

Line 1671: fnd_msg_pub.ADD;

1667: fnd_message.set_name('GMD','GMD_FAILED_TO_FETCH_ROW');
1668: fnd_message.set_token('L_TABLE_NAME','GMD_SPEC_TESTS');
1669: fnd_message.set_token('L_COLUMN_NAME','TEST_ID');
1670: fnd_message.set_token('L_KEY_VALUE',l_spec_tests.test_id);
1671: fnd_msg_pub.ADD;
1672: RAISE FND_API.G_EXC_ERROR;
1673: END IF;
1674:
1675: l_spec_tests := l_spec_tests_out ;

Line 1687: fnd_msg_pub.ADD;

1683: fnd_message.set_name('GMD','GMD_RECORD_DELETE_MARKED');
1684: fnd_message.set_token('L_TABLE_NAME','GMD_SPECIFICATIONS');
1685: fnd_message.set_token('L_COLUMN_NAME','SPEC_ID');
1686: fnd_message.set_token('L_KEY_VALUE',p_spec_id);
1687: fnd_msg_pub.ADD;
1688: RAISE FND_API.G_EXC_ERROR;
1689: END IF;
1690:
1691: EXCEPTION

Line 1694: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

1690:
1691: EXCEPTION
1692: WHEN FND_API.G_EXC_ERROR THEN
1693: x_return_status := FND_API.G_RET_STS_ERROR ;
1694: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1695:
1696: WHEN OTHERS THEN
1697: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
1698: FND_MESSAGE.Set_Token('PACKAGE','GMD_SPEC_GRP.VALIDATE_BEFORE_DELETE');

Line 1701: FND_MSG_PUB.ADD;

1697: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
1698: FND_MESSAGE.Set_Token('PACKAGE','GMD_SPEC_GRP.VALIDATE_BEFORE_DELETE');
1699: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
1700: FND_MESSAGE.Set_Token('POSITION',l_progress );
1701: FND_MSG_PUB.ADD;
1702: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1704:
1705: END VALIDATE_BEFORE_DELETE ;

Line 1702: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

1698: FND_MESSAGE.Set_Token('PACKAGE','GMD_SPEC_GRP.VALIDATE_BEFORE_DELETE');
1699: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
1700: FND_MESSAGE.Set_Token('POSITION',l_progress );
1701: FND_MSG_PUB.ADD;
1702: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1704:
1705: END VALIDATE_BEFORE_DELETE ;
1706:

Line 1910: FND_MSG_PUB.initialize;

1906:
1907: BEGIN
1908:
1909: x_return_status := FND_API.G_RET_STS_SUCCESS;
1910: FND_MSG_PUB.initialize;
1911: l_position := '010';
1912:
1913: IF p_test_id IS NULL OR p_value IS NULL THEN
1914: RAISE REQ_FIELDS_MISSING;

Line 1972: FND_MSG_PUB.initialize;

1968: l_val_missing NUMBER;
1969:
1970: BEGIN
1971:
1972: FND_MSG_PUB.initialize;
1973: l_position := '010';
1974:
1975:
1976: IF p_test_id IS NULL OR p_test_type IS NULL OR p_test_type IN ('U','V') THEN

Line 2094: FND_MSG_PUB.initialize;

2090: l_spec_num NUMBER;
2091: l_max_value NUMBER;
2092: l_position NUMBER;
2093: BEGIN
2094: FND_MSG_PUB.initialize;
2095: l_position := '010';
2096:
2097: IF p_exp_error_type IS NULL THEN
2098: RETURN TRUE;

Line 2543: FND_MSG_PUB.initialize; -- clear the message stack.

2539:
2540: -- Initialize API return status to success
2541: x_return_status := FND_API.G_RET_STS_SUCCESS;
2542:
2543: FND_MSG_PUB.initialize; -- clear the message stack.
2544:
2545: l_progress := '010';
2546:
2547: OPEN Cur_get_hdr;

Line 2728: FND_MSG_PUB.ADD;

2724: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
2725: FND_MESSAGE.Set_Token('PACKAGE','GMD_SPEC_GRP.CREATE_SPECIFICATION');
2726: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
2727: FND_MESSAGE.Set_Token('POSITION',l_progress );
2728: FND_MSG_PUB.ADD;
2729: END create_specification ;
2730:
2731:
2732: