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 439: FND_MSG_PUB.ADD;

435: IF l_test_type IN ('U','T','V') THEN
436:
437: IF (x_spec_tests.display_precision IS NOT NULL OR x_spec_tests.report_precision IS NOT NULL) THEN
438: FND_MESSAGE.SET_NAME('GMD','GMD_PRECISION_NOT_REQD');
439: FND_MSG_PUB.ADD;
440: RAISE FND_API.G_EXC_ERROR;
441: END IF;
442:
443: IF (x_spec_tests.min_value_num IS NOT NULL OR x_spec_tests.max_value_num IS NOT NULL) THEN

Line 445: FND_MSG_PUB.ADD;

441: END IF;
442:
443: IF (x_spec_tests.min_value_num IS NOT NULL OR x_spec_tests.max_value_num IS NOT NULL) THEN
444: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_NUM_RANGE_NOT_REQD');
445: FND_MSG_PUB.ADD;
446: RAISE FND_API.G_EXC_ERROR;
447: END IF;
448:
449: IF x_spec_tests.target_value_num IS NOT NULL THEN

Line 451: FND_MSG_PUB.ADD;

447: END IF;
448:
449: IF x_spec_tests.target_value_num IS NOT NULL THEN
450: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_NUM_TARGET_NOT_REQD');
451: FND_MSG_PUB.ADD;
452: RAISE FND_API.G_EXC_ERROR;
453: END IF;
454: --BEGIN BUG#3545701
455: --Commented the code for Non-validated tests.

Line 458: FND_MSG_PUB.ADD;

454: --BEGIN BUG#3545701
455: --Commented the code for Non-validated tests.
456: /* IF l_test_type = 'U' and x_spec_tests.target_value_char IS NOT NULL THEN
457: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_CHAR_TARGET_NOT_REQD');
458: FND_MSG_PUB.ADD;
459: RAISE FND_API.G_EXC_ERROR; */
460: --END BUG#3545701
461: IF l_test_type = 'V' and x_spec_tests.target_value_char IS NULL THEN
462: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_CHAR_TARGET_REQD');

Line 463: FND_MSG_PUB.ADD;

459: RAISE FND_API.G_EXC_ERROR; */
460: --END BUG#3545701
461: IF l_test_type = 'V' and x_spec_tests.target_value_char IS NULL THEN
462: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_CHAR_TARGET_REQD');
463: FND_MSG_PUB.ADD;
464: RAISE FND_API.G_EXC_ERROR;
465: END IF;
466:
467: IF (l_test_type = 'T') THEN

Line 470: FND_MSG_PUB.ADD;

466:
467: IF (l_test_type = 'T') THEN
468: IF (x_spec_tests.min_value_char IS NULL OR x_spec_tests.max_value_char IS NULL) THEN
469: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_RANGE_REQ');
470: FND_MSG_PUB.ADD;
471: RAISE FND_API.G_EXC_ERROR;
472: END IF;
473: ELSE
474: IF (x_spec_tests.min_value_char IS NOT NULL OR x_spec_tests.max_value_char IS NOT NULL) THEN

Line 476: FND_MSG_PUB.ADD;

472: END IF;
473: ELSE
474: IF (x_spec_tests.min_value_char IS NOT NULL OR x_spec_tests.max_value_char IS NOT NULL) THEN
475: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_CHAR_RANGE_NOT_REQD');
476: FND_MSG_PUB.ADD;
477: RAISE FND_API.G_EXC_ERROR;
478: END IF;
479: END IF;
480:

Line 485: FND_MSG_PUB.ADD;

481: --BEGIN BUG#3545701
482: --Commented the code for Non-validated tests.
483: /* IF l_test_type = 'U' and x_spec_tests.out_of_spec_action IS NOT NULL THEN
484: FND_MESSAGE.SET_NAME('GMD','GMD_ACTION_CODE_NOT_REQD');
485: FND_MSG_PUB.ADD;
486: RAISE FND_API.G_EXC_ERROR;
487: END IF; */
488: --END BUG#3545701
489:

Line 492: FND_MSG_PUB.ADD;

488: --END BUG#3545701
489:
490: IF x_spec_tests.exp_error_type IS NOT NULL THEN
491: FND_MESSAGE.SET_NAME('GMD','GMD_INVALID_EXP_ERROR_TYPE');
492: FND_MSG_PUB.ADD;
493: RAISE FND_API.G_EXC_ERROR;
494: END IF;
495:
496: IF (x_spec_tests.below_spec_min IS NOT NULL OR x_spec_tests.below_min_action_code IS NOT NULL )

Line 501: FND_MSG_PUB.ADD;

497: OR (x_spec_tests.above_spec_min IS NOT NULL OR x_spec_tests.above_min_action_code IS NOT NULL )
498: OR (x_spec_tests.below_spec_max IS NOT NULL OR x_spec_tests.below_max_action_code IS NOT NULL )
499: OR (x_spec_tests.above_spec_max IS NOT NULL OR x_spec_tests.above_max_action_code IS NOT NULL ) THEN
500: FND_MESSAGE.SET_NAME('GMD', 'GMD_EXP_ERROR_NOT_REQD');
501: FND_MSG_PUB.ADD;
502: RAISE FND_API.G_EXC_ERROR;
503: END IF;
504: ELSE
505: IF (x_spec_tests.display_precision IS NULL OR x_spec_tests.report_precision IS NULL ) THEN

Line 522: FND_MSG_PUB.ADD;

518: END IF;
519:
520: IF (x_spec_tests.min_value_num IS NULL AND x_spec_tests.max_value_num IS NULL) THEN
521: FND_MESSAGE.SET_NAME('GMD','GMD_MIN_MAX_REQ');
522: FND_MSG_PUB.ADD;
523: RAISE FND_API.G_EXC_ERROR;
524: END IF;
525:
526: IF ((x_spec_tests.min_value_num IS NULL AND l_test_min_value_num IS NOT NULL)

Line 529: FND_MSG_PUB.ADD;

525:
526: IF ((x_spec_tests.min_value_num IS NULL AND l_test_min_value_num IS NOT NULL)
527: OR (x_spec_tests.max_value_num IS NULL AND l_test_max_value_num IS NOT NULL)) THEN
528: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_RANGE_REQ');
529: FND_MSG_PUB.ADD;
530: RAISE FND_API.G_EXC_ERROR;
531: END IF;
532:
533: IF (x_spec_tests.min_value_char IS NOT NULL OR x_spec_tests.max_value_char IS NOT NULL) THEN

Line 535: FND_MSG_PUB.ADD;

531: END IF;
532:
533: IF (x_spec_tests.min_value_char IS NOT NULL OR x_spec_tests.max_value_char IS NOT NULL) THEN
534: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_CHAR_RANGE_NOT_REQD');
535: FND_MSG_PUB.ADD;
536: RAISE FND_API.G_EXC_ERROR;
537: END IF;
538:
539: IF x_spec_tests.target_value_char IS NOT NULL THEN

Line 541: FND_MSG_PUB.ADD;

537: END IF;
538:
539: IF x_spec_tests.target_value_char IS NOT NULL THEN
540: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_CHAR_TARGET_NOT_REQD');
541: FND_MSG_PUB.ADD;
542: RAISE FND_API.G_EXC_ERROR;
543: END IF;
544:
545: IF ((x_spec_tests.exp_error_type IN ('N','P')) OR (x_spec_tests.exp_error_type IS NULL)) THEN

Line 549: FND_MSG_PUB.ADD;

545: IF ((x_spec_tests.exp_error_type IN ('N','P')) OR (x_spec_tests.exp_error_type IS NULL)) THEN
546: NULL ;
547: ELSE
548: FND_MESSAGE.SET_NAME('GMD','GMD_INVALID_EXP_ERROR_TYPE');
549: FND_MSG_PUB.ADD;
550: RAISE FND_API.G_EXC_ERROR;
551: END IF;
552:
553: IF x_spec_tests.exp_error_type IS NULL AND

Line 558: FND_MSG_PUB.ADD;

554: (x_spec_tests.below_spec_min IS NOT NULL OR x_spec_tests.above_spec_min IS NOT NULL
555: OR x_spec_tests.below_spec_max IS NOT NULL OR x_spec_tests.above_spec_max IS NOT NULL)
556: THEN
557: FND_MESSAGE.SET_NAME('GMD', 'GMD_EXP_ERROR_TYPE_REQ');
558: FND_MSG_PUB.ADD;
559: RAISE FND_API.G_EXC_ERROR;
560: END IF;
561:
562: IF x_spec_tests.exp_error_type IS NOT NULL AND

Line 567: FND_MSG_PUB.ADD;

563: (x_spec_tests.below_spec_min IS NULL AND x_spec_tests.above_spec_min IS NULL
564: AND x_spec_tests.below_spec_max IS NULL AND x_spec_tests.above_spec_max IS NULL)
565: THEN
566: FND_MESSAGE.SET_NAME('GMD', 'GMD_EXP_ERR_TYPE_NULL');
567: FND_MSG_PUB.ADD;
568: RAISE FND_API.G_EXC_ERROR;
569: END IF;
570:
571: END IF;

Line 1196: FND_MSG_PUB.ADD;

1192: uom_rate => l_dummy );
1193:
1194: EXCEPTION WHEN OTHERS
1195: THEN
1196: FND_MSG_PUB.ADD;
1197: RAISE FND_API.G_EXC_ERROR;
1198: END ;
1199: END IF;
1200:

Line 1412: FND_MSG_PUB.ADD;

1408: WHERE spec_id = p_spec_id ;
1409:
1410: IF l_test_count = 0 THEN
1411: FND_MESSAGE.SET_NAME('GMD','GMD_SPEC_NO_TEST');
1412: FND_MSG_PUB.ADD;
1413: RAISE FND_API.G_EXC_ERROR;
1414: END IF;
1415:
1416: -- validate expression based tests.

Line 1477: FND_MSG_PUB.ADD;

1473: -- validate for primary key
1474: -- ========================
1475: IF p_spec_id IS NULL THEN
1476: FND_MESSAGE.SET_NAME('GMD','GMD_SPEC_ID_REQUIRED'); -- New Message
1477: FND_MSG_PUB.ADD;
1478: RAISE FND_API.G_EXC_ERROR;
1479: ELSE
1480: l_spec.spec_id := p_spec_id;
1481: END IF;

Line 1491: fnd_msg_pub.ADD;

1487: fnd_message.set_name('GMD','GMD_FAILED_TO_FETCH_ROW');
1488: fnd_message.set_token('L_TABLE_NAME','GMD_SPECIFICATIONS');
1489: fnd_message.set_token('L_COLUMN_NAME','SPEC_ID');
1490: fnd_message.set_token('L_KEY_VALUE',l_spec.spec_id);
1491: fnd_msg_pub.ADD;
1492: RAISE FND_API.G_EXC_ERROR;
1493: END IF;
1494:
1495: l_spec := l_spec_out ;

Line 1505: fnd_msg_pub.ADD;

1501: fnd_message.set_name('GMD','GMD_RECORD_DELETE_MARKED');
1502: fnd_message.set_token('L_TABLE_NAME','GMD_SPECIFICATIONS');
1503: fnd_message.set_token('L_COLUMN_NAME','SPEC_ID');
1504: fnd_message.set_token('L_KEY_VALUE',l_spec.spec_id);
1505: fnd_msg_pub.ADD;
1506: RAISE FND_API.G_EXC_ERROR;
1507: END IF;
1508:
1509: -- BUG 2698311

Line 1516: fnd_msg_pub.ADD;

1512: -- ============================================================
1513: IF l_spec.spec_status in (400,700)
1514: THEN
1515: fnd_message.set_name('GMD','GMD_SPEC_STATUS_BLOCKS_DELETE');
1516: fnd_msg_pub.ADD;
1517: RAISE FND_API.G_EXC_ERROR;
1518: END IF;
1519:
1520: -- Ensure that the status permits updates

Line 1525: fnd_msg_pub.ADD;

1521: -- ======================================
1522: IF NOT GMD_SPEC_GRP.Record_Updateable_With_Status(l_spec.spec_status)
1523: THEN
1524: fnd_message.set_name('GMD','GMD_SPEC_STATUS_BLOCKS_UPDATE');
1525: fnd_msg_pub.ADD;
1526: RAISE FND_API.G_EXC_ERROR;
1527: END IF;
1528:
1529: EXCEPTION

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

1528:
1529: EXCEPTION
1530: WHEN FND_API.G_EXC_ERROR THEN
1531: x_return_status := FND_API.G_RET_STS_ERROR ;
1532: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1533:
1534: WHEN OTHERS THEN
1535: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
1536: FND_MESSAGE.Set_Token('PACKAGE','GMD_SPEC_GRP.VALIDATE_BEFORE_DELETE');

Line 1539: FND_MSG_PUB.ADD;

1535: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
1536: FND_MESSAGE.Set_Token('PACKAGE','GMD_SPEC_GRP.VALIDATE_BEFORE_DELETE');
1537: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
1538: FND_MESSAGE.Set_Token('POSITION',l_progress );
1539: FND_MSG_PUB.ADD;
1540: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1541: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1542:
1543: END VALIDATE_BEFORE_DELETE ;

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

1536: FND_MESSAGE.Set_Token('PACKAGE','GMD_SPEC_GRP.VALIDATE_BEFORE_DELETE');
1537: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
1538: FND_MESSAGE.Set_Token('POSITION',l_progress );
1539: FND_MSG_PUB.ADD;
1540: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1541: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1542:
1543: END VALIDATE_BEFORE_DELETE ;
1544:

Line 1577: FND_MSG_PUB.ADD;

1573: -- validate for primary key
1574: -- ========================
1575: IF p_spec_id IS NULL THEN
1576: FND_MESSAGE.SET_NAME('GMD','GMD_SPEC_ID_REQUIRED');
1577: FND_MSG_PUB.ADD;
1578: RAISE FND_API.G_EXC_ERROR;
1579: ELSE
1580: l_spec_tests.spec_id := p_spec_id;
1581: END IF;

Line 1585: FND_MSG_PUB.ADD;

1581: END IF;
1582:
1583: IF p_test_id IS NULL THEN
1584: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_ID_CODE_NULL');
1585: FND_MSG_PUB.ADD;
1586: RAISE FND_API.G_EXC_ERROR;
1587: ELSE
1588: l_spec_tests.test_id := p_test_id;
1589: END IF;

Line 1599: fnd_msg_pub.ADD;

1595: fnd_message.set_name('GMD','GMD_FAILED_TO_FETCH_ROW');
1596: fnd_message.set_token('L_TABLE_NAME','GMD_SPEC_TESTS');
1597: fnd_message.set_token('L_COLUMN_NAME','TEST_ID');
1598: fnd_message.set_token('L_KEY_VALUE',l_spec_tests.test_id);
1599: fnd_msg_pub.ADD;
1600: RAISE FND_API.G_EXC_ERROR;
1601: END IF;
1602:
1603: l_spec_tests := l_spec_tests_out ;

Line 1615: fnd_msg_pub.ADD;

1611: fnd_message.set_name('GMD','GMD_RECORD_DELETE_MARKED');
1612: fnd_message.set_token('L_TABLE_NAME','GMD_SPECIFICATIONS');
1613: fnd_message.set_token('L_COLUMN_NAME','SPEC_ID');
1614: fnd_message.set_token('L_KEY_VALUE',p_spec_id);
1615: fnd_msg_pub.ADD;
1616: RAISE FND_API.G_EXC_ERROR;
1617: END IF;
1618:
1619: EXCEPTION

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

1618:
1619: EXCEPTION
1620: WHEN FND_API.G_EXC_ERROR THEN
1621: x_return_status := FND_API.G_RET_STS_ERROR ;
1622: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1623:
1624: WHEN OTHERS THEN
1625: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
1626: FND_MESSAGE.Set_Token('PACKAGE','GMD_SPEC_GRP.VALIDATE_BEFORE_DELETE');

Line 1629: FND_MSG_PUB.ADD;

1625: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
1626: FND_MESSAGE.Set_Token('PACKAGE','GMD_SPEC_GRP.VALIDATE_BEFORE_DELETE');
1627: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
1628: FND_MESSAGE.Set_Token('POSITION',l_progress );
1629: FND_MSG_PUB.ADD;
1630: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1631: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1632:
1633: END VALIDATE_BEFORE_DELETE ;

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

1626: FND_MESSAGE.Set_Token('PACKAGE','GMD_SPEC_GRP.VALIDATE_BEFORE_DELETE');
1627: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
1628: FND_MESSAGE.Set_Token('POSITION',l_progress );
1629: FND_MSG_PUB.ADD;
1630: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1631: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1632:
1633: END VALIDATE_BEFORE_DELETE ;
1634:

Line 1838: FND_MSG_PUB.initialize;

1834:
1835: BEGIN
1836:
1837: x_return_status := FND_API.G_RET_STS_SUCCESS;
1838: FND_MSG_PUB.initialize;
1839: l_position := '010';
1840:
1841: IF p_test_id IS NULL OR p_value IS NULL THEN
1842: RAISE REQ_FIELDS_MISSING;

Line 1900: FND_MSG_PUB.initialize;

1896: l_val_missing NUMBER;
1897:
1898: BEGIN
1899:
1900: FND_MSG_PUB.initialize;
1901: l_position := '010';
1902:
1903:
1904: IF p_test_id IS NULL OR p_test_type IS NULL OR p_test_type IN ('U','V') THEN

Line 2022: FND_MSG_PUB.initialize;

2018: l_spec_num NUMBER;
2019: l_max_value NUMBER;
2020: l_position NUMBER;
2021: BEGIN
2022: FND_MSG_PUB.initialize;
2023: l_position := '010';
2024:
2025: IF p_exp_error_type IS NULL THEN
2026: RETURN TRUE;

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

2467:
2468: -- Initialize API return status to success
2469: x_return_status := FND_API.G_RET_STS_SUCCESS;
2470:
2471: FND_MSG_PUB.initialize; -- clear the message stack.
2472:
2473: l_progress := '010';
2474:
2475: OPEN Cur_get_hdr;

Line 2656: FND_MSG_PUB.ADD;

2652: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
2653: FND_MESSAGE.Set_Token('PACKAGE','GMD_SPEC_GRP.CREATE_SPECIFICATION');
2654: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
2655: FND_MESSAGE.Set_Token('POSITION',l_progress );
2656: FND_MSG_PUB.ADD;
2657: END create_specification ;
2658:
2659:
2660: