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_MESSAGE

Line 480: FND_MESSAGE.SET_NAME('GMD','GMD_PRECISION_NOT_REQD');

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

Line 486: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_NUM_RANGE_NOT_REQD');

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

Line 492: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_NUM_TARGET_NOT_REQD');

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

Line 499: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_CHAR_TARGET_NOT_REQD');

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

Line 504: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_CHAR_TARGET_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');
505: FND_MSG_PUB.ADD;
506: RAISE FND_API.G_EXC_ERROR;
507: END IF;
508:

Line 511: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_RANGE_REQ');

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

Line 517: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_CHAR_RANGE_NOT_REQD');

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

Line 526: FND_MESSAGE.SET_NAME('GMD','GMD_ACTION_CODE_NOT_REQD');

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

Line 533: FND_MESSAGE.SET_NAME('GMD','GMD_INVALID_EXP_ERROR_TYPE');

529: END IF; */
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:

Line 542: FND_MESSAGE.SET_NAME('GMD', 'GMD_EXP_ERROR_NOT_REQD');

538: IF (x_spec_tests.below_spec_min IS NOT NULL OR x_spec_tests.below_min_action_code IS NOT NULL )
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

Line 563: FND_MESSAGE.SET_NAME('GMD','GMD_MIN_MAX_REQ');

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

Line 570: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_RANGE_REQ');

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

Line 576: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_CHAR_RANGE_NOT_REQD');

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

Line 582: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_CHAR_TARGET_NOT_REQD');

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

Line 590: FND_MESSAGE.SET_NAME('GMD','GMD_INVALID_EXP_ERROR_TYPE');

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

Line 599: FND_MESSAGE.SET_NAME('GMD', 'GMD_EXP_ERROR_TYPE_REQ');

595: IF x_spec_tests.exp_error_type IS NULL AND
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:

Line 608: FND_MESSAGE.SET_NAME('GMD', 'GMD_EXP_ERR_TYPE_NULL');

604: IF x_spec_tests.exp_error_type IS NOT NULL AND
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:

Line 1483: FND_MESSAGE.SET_NAME('GMD','GMD_SPEC_NO_TEST');

1479: FROM GMD_SPEC_TESTS_B
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:

Line 1548: FND_MESSAGE.SET_NAME('GMD','GMD_SPEC_ID_REQUIRED'); -- New Message

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

Line 1559: fnd_message.set_name('GMD','GMD_FAILED_TO_FETCH_ROW');

1555: -- Fetch the row
1556: -- =============
1557: IF NOT GMD_Specifications_PVT.Fetch_Row(l_spec,l_spec_out)
1558: THEN
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;

Line 1560: fnd_message.set_token('L_TABLE_NAME','GMD_SPECIFICATIONS');

1556: -- =============
1557: IF NOT GMD_Specifications_PVT.Fetch_Row(l_spec,l_spec_out)
1558: THEN
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;

Line 1561: fnd_message.set_token('L_COLUMN_NAME','SPEC_ID');

1557: IF NOT GMD_Specifications_PVT.Fetch_Row(l_spec,l_spec_out)
1558: THEN
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;

Line 1562: fnd_message.set_token('L_KEY_VALUE',l_spec.spec_id);

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

Line 1573: fnd_message.set_name('GMD','GMD_RECORD_DELETE_MARKED');

1569: -- Terminate if the row is already delete marked
1570: -- =============================================
1571: IF l_spec.delete_mark <> 0
1572: THEN
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;

Line 1574: fnd_message.set_token('L_TABLE_NAME','GMD_SPECIFICATIONS');

1570: -- =============================================
1571: IF l_spec.delete_mark <> 0
1572: THEN
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;

Line 1575: fnd_message.set_token('L_COLUMN_NAME','SPEC_ID');

1571: IF l_spec.delete_mark <> 0
1572: THEN
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;

Line 1576: fnd_message.set_token('L_KEY_VALUE',l_spec.spec_id);

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

Line 1587: fnd_message.set_name('GMD','GMD_SPEC_STATUS_BLOCKS_DELETE');

1583: -- ============================== 700 (Approved for General Use)
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:

Line 1596: fnd_message.set_name('GMD','GMD_SPEC_STATUS_BLOCKS_UPDATE');

1592: -- Ensure that the status permits updates
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:

Line 1607: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');

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');
1609: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
1610: FND_MESSAGE.Set_Token('POSITION',l_progress );
1611: FND_MSG_PUB.ADD;

Line 1608: FND_MESSAGE.Set_Token('PACKAGE','GMD_SPEC_GRP.VALIDATE_BEFORE_DELETE');

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');
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);

Line 1609: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));

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');
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;

Line 1610: FND_MESSAGE.Set_Token('POSITION',l_progress );

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');
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:

Line 1648: FND_MESSAGE.SET_NAME('GMD','GMD_SPEC_ID_REQUIRED');

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

Line 1656: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_ID_CODE_NULL');

1652: l_spec_tests.spec_id := p_spec_id;
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;

Line 1667: fnd_message.set_name('GMD','GMD_FAILED_TO_FETCH_ROW');

1663: -- Fetch the row
1664: -- =============
1665: IF NOT GMD_Spec_Tests_PVT.Fetch_Row(l_spec_tests,l_spec_tests_out)
1666: THEN
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;

Line 1668: fnd_message.set_token('L_TABLE_NAME','GMD_SPEC_TESTS');

1664: -- =============
1665: IF NOT GMD_Spec_Tests_PVT.Fetch_Row(l_spec_tests,l_spec_tests_out)
1666: THEN
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;

Line 1669: fnd_message.set_token('L_COLUMN_NAME','TEST_ID');

1665: IF NOT GMD_Spec_Tests_PVT.Fetch_Row(l_spec_tests,l_spec_tests_out)
1666: THEN
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;

Line 1670: fnd_message.set_token('L_KEY_VALUE',l_spec_tests.test_id);

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

Line 1683: fnd_message.set_name('GMD','GMD_RECORD_DELETE_MARKED');

1679: WHERE spec_id = p_spec_id ;
1680:
1681: IF l_spec_delete_mark <> 0
1682: THEN
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;

Line 1684: fnd_message.set_token('L_TABLE_NAME','GMD_SPECIFICATIONS');

1680:
1681: IF l_spec_delete_mark <> 0
1682: THEN
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;

Line 1685: fnd_message.set_token('L_COLUMN_NAME','SPEC_ID');

1681: IF l_spec_delete_mark <> 0
1682: THEN
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;

Line 1686: fnd_message.set_token('L_KEY_VALUE',p_spec_id);

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

Line 1697: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');

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');
1699: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
1700: FND_MESSAGE.Set_Token('POSITION',l_progress );
1701: FND_MSG_PUB.ADD;

Line 1698: FND_MESSAGE.Set_Token('PACKAGE','GMD_SPEC_GRP.VALIDATE_BEFORE_DELETE');

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');
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);

Line 1699: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));

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');
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;

Line 1700: FND_MESSAGE.Set_Token('POSITION',l_progress );

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');
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:

Line 2724: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');

2720:
2721: EXCEPTION
2722: WHEN OTHERS THEN
2723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
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;

Line 2725: FND_MESSAGE.Set_Token('PACKAGE','GMD_SPEC_GRP.CREATE_SPECIFICATION');

2721: EXCEPTION
2722: WHEN OTHERS THEN
2723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
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 ;

Line 2726: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));

2722: WHEN OTHERS THEN
2723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
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:

Line 2727: FND_MESSAGE.Set_Token('POSITION',l_progress );

2723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
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:

Line 2800: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_PARAMETERS');

2796: -- Validate Input Parameters for NULLs
2797: IF (p_table_name IS NULL OR p_id IS NULL OR p_source_status IS NULL OR
2798: p_target_status IS NULL OR p_mode IS NULL) THEN
2799: x_return_status := 'E';
2800: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_PARAMETERS');
2801: x_message := FND_MESSAGE.GET;
2802: RETURN;
2803: END IF;
2804:

Line 2801: x_message := FND_MESSAGE.GET;

2797: IF (p_table_name IS NULL OR p_id IS NULL OR p_source_status IS NULL OR
2798: p_target_status IS NULL OR p_mode IS NULL) THEN
2799: x_return_status := 'E';
2800: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_PARAMETERS');
2801: x_message := FND_MESSAGE.GET;
2802: RETURN;
2803: END IF;
2804:
2805:

Line 2808: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_PARAMETERS');

2804:
2805:
2806: IF NOT (p_mode in ('P', 'R', 'A', 'S')) THEN
2807: x_return_status := 'E';
2808: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_PARAMETERS');
2809: x_message := FND_MESSAGE.GET;
2810: RETURN;
2811: END IF;
2812:

Line 2809: x_message := FND_MESSAGE.GET;

2805:
2806: IF NOT (p_mode in ('P', 'R', 'A', 'S')) THEN
2807: x_return_status := 'E';
2808: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_PARAMETERS');
2809: x_message := FND_MESSAGE.GET;
2810: RETURN;
2811: END IF;
2812:
2813: IF (l_debug = 'Y') THEN

Line 2826: FND_MESSAGE.SET_NAME('GMD', 'GMD_STATUS_NOT_FOUND');

2822: FETCH c_all_status INTO l_status;
2823: IF c_all_status%NOTFOUND THEN
2824: CLOSE c_all_status;
2825: x_return_status := 'E';
2826: FND_MESSAGE.SET_NAME('GMD', 'GMD_STATUS_NOT_FOUND');
2827: x_message := FND_MESSAGE.GET;
2828: RETURN;
2829: END IF;
2830: CLOSE c_all_status;

Line 2827: x_message := FND_MESSAGE.GET;

2823: IF c_all_status%NOTFOUND THEN
2824: CLOSE c_all_status;
2825: x_return_status := 'E';
2826: FND_MESSAGE.SET_NAME('GMD', 'GMD_STATUS_NOT_FOUND');
2827: x_message := FND_MESSAGE.GET;
2828: RETURN;
2829: END IF;
2830: CLOSE c_all_status;
2831:

Line 2876: FND_MESSAGE.SET_NAME('GMD', 'GMD_API_ERROR');

2872: RETURN;
2873:
2874: EXCEPTION
2875: WHEN OTHERS THEN
2876: FND_MESSAGE.SET_NAME('GMD', 'GMD_API_ERROR');
2877: FND_MESSAGE.SET_TOKEN('PACKAGE','GMD_SPEC_GRP.change_status');
2878: FND_MESSAGE.SET_TOKEN('ERROR', SUBSTR(SQLERRM,1,100));
2879: x_message := FND_MESSAGE.GET;
2880: x_return_status := 'E';

Line 2877: FND_MESSAGE.SET_TOKEN('PACKAGE','GMD_SPEC_GRP.change_status');

2873:
2874: EXCEPTION
2875: WHEN OTHERS THEN
2876: FND_MESSAGE.SET_NAME('GMD', 'GMD_API_ERROR');
2877: FND_MESSAGE.SET_TOKEN('PACKAGE','GMD_SPEC_GRP.change_status');
2878: FND_MESSAGE.SET_TOKEN('ERROR', SUBSTR(SQLERRM,1,100));
2879: x_message := FND_MESSAGE.GET;
2880: x_return_status := 'E';
2881: RETURN;

Line 2878: FND_MESSAGE.SET_TOKEN('ERROR', SUBSTR(SQLERRM,1,100));

2874: EXCEPTION
2875: WHEN OTHERS THEN
2876: FND_MESSAGE.SET_NAME('GMD', 'GMD_API_ERROR');
2877: FND_MESSAGE.SET_TOKEN('PACKAGE','GMD_SPEC_GRP.change_status');
2878: FND_MESSAGE.SET_TOKEN('ERROR', SUBSTR(SQLERRM,1,100));
2879: x_message := FND_MESSAGE.GET;
2880: x_return_status := 'E';
2881: RETURN;
2882:

Line 2879: x_message := FND_MESSAGE.GET;

2875: WHEN OTHERS THEN
2876: FND_MESSAGE.SET_NAME('GMD', 'GMD_API_ERROR');
2877: FND_MESSAGE.SET_TOKEN('PACKAGE','GMD_SPEC_GRP.change_status');
2878: FND_MESSAGE.SET_TOKEN('ERROR', SUBSTR(SQLERRM,1,100));
2879: x_message := FND_MESSAGE.GET;
2880: x_return_status := 'E';
2881: RETURN;
2882:
2883: END change_status;