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

Line 74: FND_MSG_PUB.initialize;

70: END IF;
71:
72: -- Initialize message list if p_init_msg_list is set to TRUE.
73: IF FND_API.to_Boolean( p_init_msg_list ) THEN
74: FND_MSG_PUB.initialize;
75: END IF;
76:
77: IF (lc_proc_level >= lc_debug_level) THEN
78: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.BEGIN',

Line 439: FND_MSG_PUB.Count_And_Get

435: COMMIT WORK;
436: END IF;
437:
438: -- Standard call to get message count and IF count is get message info.
439: FND_MSG_PUB.Count_And_Get
440: (p_count => x_msg_count,
441: p_data => x_msg_data );
442:
443: IF (lc_proc_level >= lc_debug_level) THEN

Line 463: FND_MSG_PUB.Add;

459: end if;
460: FND_MESSAGE.SET_NAME('CSD','CSD_API_MISSING_PARAM');
461: FND_MESSAGE.SET_TOKEN('API_NAME',lc_api_name);
462: FND_MESSAGE.SET_TOKEN('MISSING_PARAM','INVENTORY_ITEM_ID');
463: FND_MSG_PUB.Add;
464:
465: FND_MSG_PUB.Count_And_Get
466: (p_count => x_msg_count,
467: p_data => x_msg_data );

Line 465: FND_MSG_PUB.Count_And_Get

461: FND_MESSAGE.SET_TOKEN('API_NAME',lc_api_name);
462: FND_MESSAGE.SET_TOKEN('MISSING_PARAM','INVENTORY_ITEM_ID');
463: FND_MSG_PUB.Add;
464:
465: FND_MSG_PUB.Count_And_Get
466: (p_count => x_msg_count,
467: p_data => x_msg_data );
468:
469: -- save message in debug log

Line 489: FND_MSG_PUB.Add;

485: end if;
486: FND_MESSAGE.SET_NAME('CSD','CSD_API_MISSING_PARAM');
487: FND_MESSAGE.SET_TOKEN('API_NAME',lc_api_name);
488: FND_MESSAGE.SET_TOKEN('MISSING_PARAM','CATEGORY_SET_ID');
489: FND_MSG_PUB.Add;
490:
491: FND_MSG_PUB.Count_And_Get
492: (p_count => x_msg_count,
493: p_data => x_msg_data );

Line 491: FND_MSG_PUB.Count_And_Get

487: FND_MESSAGE.SET_TOKEN('API_NAME',lc_api_name);
488: FND_MESSAGE.SET_TOKEN('MISSING_PARAM','CATEGORY_SET_ID');
489: FND_MSG_PUB.Add;
490:
491: FND_MSG_PUB.Count_And_Get
492: (p_count => x_msg_count,
493: p_data => x_msg_data );
494:
495: -- save message in debug log

Line 515: FND_MSG_PUB.Add;

511: end if;
512: FND_MESSAGE.SET_NAME('CSD','CSD_API_MISSING_PARAM');
513: FND_MESSAGE.SET_TOKEN('API_NAME',lc_api_name);
514: FND_MESSAGE.SET_TOKEN('MISSING_PARAM','CATEGORY_ID');
515: FND_MSG_PUB.Add;
516:
517: FND_MSG_PUB.Count_And_Get
518: (p_count => x_msg_count,
519: p_data => x_msg_data );

Line 517: FND_MSG_PUB.Count_And_Get

513: FND_MESSAGE.SET_TOKEN('API_NAME',lc_api_name);
514: FND_MESSAGE.SET_TOKEN('MISSING_PARAM','CATEGORY_ID');
515: FND_MSG_PUB.Add;
516:
517: FND_MSG_PUB.Count_And_Get
518: (p_count => x_msg_count,
519: p_data => x_msg_data );
520:
521: -- save message in debug log

Line 540: FND_MSG_PUB.Add;

536: 'Adding message CSD_SCD_DOMAIN_EXISTS to FND_MSG stack');
537: end if;
538: FND_MESSAGE.SET_NAME('CSD','CSD_SCD_DOMAIN_EXISTS');
539: FND_MESSAGE.SET_TOKEN('SERVICE_CODE_ID',p_sc_domain_rec.service_code_id);
540: FND_MSG_PUB.Add;
541:
542: FND_MSG_PUB.Count_And_Get
543: (p_count => x_msg_count,
544: p_data => x_msg_data );

Line 542: FND_MSG_PUB.Count_And_Get

538: FND_MESSAGE.SET_NAME('CSD','CSD_SCD_DOMAIN_EXISTS');
539: FND_MESSAGE.SET_TOKEN('SERVICE_CODE_ID',p_sc_domain_rec.service_code_id);
540: FND_MSG_PUB.Add;
541:
542: FND_MSG_PUB.Count_And_Get
543: (p_count => x_msg_count,
544: p_data => x_msg_data );
545:
546: -- save message in debug log

Line 565: FND_MSG_PUB.Add;

561: 'Adding message CSD_SCD_INVALID_ITEM to FND_MSG stack');
562: end if;
563: FND_MESSAGE.SET_NAME('CSD','CSD_SCD_INVALID_ITEM');
564: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_sc_domain_rec.inventory_item_id);
565: FND_MSG_PUB.Add;
566:
567: FND_MSG_PUB.Count_And_Get
568: (p_count => x_msg_count,
569: p_data => x_msg_data );

Line 567: FND_MSG_PUB.Count_And_Get

563: FND_MESSAGE.SET_NAME('CSD','CSD_SCD_INVALID_ITEM');
564: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_sc_domain_rec.inventory_item_id);
565: FND_MSG_PUB.Add;
566:
567: FND_MSG_PUB.Count_And_Get
568: (p_count => x_msg_count,
569: p_data => x_msg_data );
570:
571: -- save message in debug log

Line 590: FND_MSG_PUB.Add;

586: 'Adding message CSD_SCD_INVALID_CAT_SET to FND_MSG stack');
587: end if;
588: FND_MESSAGE.SET_NAME('CSD','CSD_SCD_INVALID_CAT_SET');
589: FND_MESSAGE.SET_TOKEN('CATEGORY_SET_ID',p_sc_domain_rec.category_set_id);
590: FND_MSG_PUB.Add;
591:
592: FND_MSG_PUB.Count_And_Get
593: (p_count => x_msg_count,
594: p_data => x_msg_data );

Line 592: FND_MSG_PUB.Count_And_Get

588: FND_MESSAGE.SET_NAME('CSD','CSD_SCD_INVALID_CAT_SET');
589: FND_MESSAGE.SET_TOKEN('CATEGORY_SET_ID',p_sc_domain_rec.category_set_id);
590: FND_MSG_PUB.Add;
591:
592: FND_MSG_PUB.Count_And_Get
593: (p_count => x_msg_count,
594: p_data => x_msg_data );
595:
596: -- save message in debug log

Line 615: FND_MSG_PUB.Add;

611: 'Adding message CSD_SCD_INVALID_CATSET_FLAG to FND_MSG stack');
612: end if;
613: FND_MESSAGE.SET_NAME('CSD','CSD_SCD_INVALID_CATSET_FLAG');
614: FND_MESSAGE.SET_TOKEN('CATEGORY_SET_ID',p_sc_domain_rec.category_set_id);
615: FND_MSG_PUB.Add;
616:
617: FND_MSG_PUB.Count_And_Get
618: (p_count => x_msg_count,
619: p_data => x_msg_data );

Line 617: FND_MSG_PUB.Count_And_Get

613: FND_MESSAGE.SET_NAME('CSD','CSD_SCD_INVALID_CATSET_FLAG');
614: FND_MESSAGE.SET_TOKEN('CATEGORY_SET_ID',p_sc_domain_rec.category_set_id);
615: FND_MSG_PUB.Add;
616:
617: FND_MSG_PUB.Count_And_Get
618: (p_count => x_msg_count,
619: p_data => x_msg_data );
620:
621: -- save message in debug log

Line 640: FND_MSG_PUB.Add;

636: 'Adding message CSD_SCD_INVALID_CATEGORY to FND_MSG stack');
637: end if;
638: FND_MESSAGE.SET_NAME('CSD','CSD_SCD_INVALID_CATEGORY');
639: FND_MESSAGE.SET_TOKEN('CATEGORY_ID',p_sc_domain_rec.category_id);
640: FND_MSG_PUB.Add;
641:
642: FND_MSG_PUB.Count_And_Get
643: (p_count => x_msg_count,
644: p_data => x_msg_data );

Line 642: FND_MSG_PUB.Count_And_Get

638: FND_MESSAGE.SET_NAME('CSD','CSD_SCD_INVALID_CATEGORY');
639: FND_MESSAGE.SET_TOKEN('CATEGORY_ID',p_sc_domain_rec.category_id);
640: FND_MSG_PUB.Add;
641:
642: FND_MSG_PUB.Count_And_Get
643: (p_count => x_msg_count,
644: p_data => x_msg_data );
645:
646: -- save message in debug log

Line 657: FND_MSG_PUB.Count_And_Get

653: ROLLBACK TO Create_SC_Domain;
654:
655: x_return_status := FND_API.G_RET_STS_ERROR;
656:
657: FND_MSG_PUB.Count_And_Get
658: (p_count => x_msg_count,
659: p_data => x_msg_data );
660:
661: -- save message in debug log

Line 672: IF FND_MSG_PUB.Check_Msg_Level

668: ROLLBACK TO Create_SC_Domain;
669:
670: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
671:
672: IF FND_MSG_PUB.Check_Msg_Level
673: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
674: THEN
675: if (lc_stat_level >= lc_debug_level) then
676: FND_LOG.STRING(lc_stat_level, lc_mod_name,

Line 673: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

669:
670: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
671:
672: IF FND_MSG_PUB.Check_Msg_Level
673: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
674: THEN
675: if (lc_stat_level >= lc_debug_level) then
676: FND_LOG.STRING(lc_stat_level, lc_mod_name,
677: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

Line 677: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

673: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
674: THEN
675: if (lc_stat_level >= lc_debug_level) then
676: FND_LOG.STRING(lc_stat_level, lc_mod_name,
677: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
678: end if;
679: FND_MSG_PUB.Add_Exc_Msg
680: (G_PKG_NAME ,
681: lc_api_name );

Line 679: FND_MSG_PUB.Add_Exc_Msg

675: if (lc_stat_level >= lc_debug_level) then
676: FND_LOG.STRING(lc_stat_level, lc_mod_name,
677: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
678: end if;
679: FND_MSG_PUB.Add_Exc_Msg
680: (G_PKG_NAME ,
681: lc_api_name );
682: END IF;
683:

Line 684: FND_MSG_PUB.Count_And_Get

680: (G_PKG_NAME ,
681: lc_api_name );
682: END IF;
683:
684: FND_MSG_PUB.Count_And_Get
685: ( p_count => x_msg_count,
686: p_data => x_msg_data );
687:
688: -- save message in debug log

Line 700: IF FND_MSG_PUB.Check_Msg_Level

696:
697: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
698:
699: -- save message in fnd stack
700: IF FND_MSG_PUB.Check_Msg_Level
701: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
702: THEN
703: if (lc_stat_level >= lc_debug_level) then
704: FND_LOG.STRING(lc_stat_level, lc_mod_name,

Line 701: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

697: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
698:
699: -- save message in fnd stack
700: IF FND_MSG_PUB.Check_Msg_Level
701: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
702: THEN
703: if (lc_stat_level >= lc_debug_level) then
704: FND_LOG.STRING(lc_stat_level, lc_mod_name,
705: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

Line 705: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

701: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
702: THEN
703: if (lc_stat_level >= lc_debug_level) then
704: FND_LOG.STRING(lc_stat_level, lc_mod_name,
705: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
706: end if;
707: FND_MSG_PUB.Add_Exc_Msg
708: (G_PKG_NAME ,
709: lc_api_name );

Line 707: FND_MSG_PUB.Add_Exc_Msg

703: if (lc_stat_level >= lc_debug_level) then
704: FND_LOG.STRING(lc_stat_level, lc_mod_name,
705: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
706: end if;
707: FND_MSG_PUB.Add_Exc_Msg
708: (G_PKG_NAME ,
709: lc_api_name );
710: END IF;
711:

Line 712: FND_MSG_PUB.Count_And_Get

708: (G_PKG_NAME ,
709: lc_api_name );
710: END IF;
711:
712: FND_MSG_PUB.Count_And_Get
713: (p_count => x_msg_count,
714: p_data => x_msg_data );
715:
716: -- save message in debug log

Line 801: FND_MSG_PUB.initialize;

797: END IF;
798:
799: -- Initialize message list if p_init_msg_list is set to TRUE.
800: IF FND_API.to_Boolean( p_init_msg_list ) THEN
801: FND_MSG_PUB.initialize;
802: END IF;
803:
804: IF (lc_proc_level >= lc_debug_level) THEN
805: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.BEGIN',

Line 1361: FND_MSG_PUB.Count_And_Get

1357: COMMIT WORK;
1358: END IF;
1359:
1360: -- Standard call to get message count and IF count is get message info.
1361: FND_MSG_PUB.Count_And_Get
1362: (p_count => x_msg_count,
1363: p_data => x_msg_data );
1364:
1365: IF (lc_proc_level >= lc_debug_level) THEN

Line 1384: FND_MSG_PUB.Add;

1380: end if;
1381: FND_MESSAGE.SET_NAME('CSD','CSD_API_MISSING_PARAM');
1382: FND_MESSAGE.SET_TOKEN('API_NAME',lc_api_name);
1383: FND_MESSAGE.SET_TOKEN('MISSING_PARAM','SERVICE_CODE_ID');
1384: FND_MSG_PUB.Add;
1385:
1386: FND_MSG_PUB.Count_And_Get
1387: (p_count => x_msg_count,
1388: p_data => x_msg_data );

Line 1386: FND_MSG_PUB.Count_And_Get

1382: FND_MESSAGE.SET_TOKEN('API_NAME',lc_api_name);
1383: FND_MESSAGE.SET_TOKEN('MISSING_PARAM','SERVICE_CODE_ID');
1384: FND_MSG_PUB.Add;
1385:
1386: FND_MSG_PUB.Count_And_Get
1387: (p_count => x_msg_count,
1388: p_data => x_msg_data );
1389:
1390: -- save message in debug log

Line 1410: FND_MSG_PUB.Add;

1406: end if;
1407: FND_MESSAGE.SET_NAME('CSD','CSD_API_MISSING_PARAM');
1408: FND_MESSAGE.SET_TOKEN('API_NAME',lc_api_name);
1409: FND_MESSAGE.SET_TOKEN('MISSING_PARAM','DOMAIN_TYPE_CODE');
1410: FND_MSG_PUB.Add;
1411:
1412: FND_MSG_PUB.Count_And_Get
1413: (p_count => x_msg_count,
1414: p_data => x_msg_data );

Line 1412: FND_MSG_PUB.Count_And_Get

1408: FND_MESSAGE.SET_TOKEN('API_NAME',lc_api_name);
1409: FND_MESSAGE.SET_TOKEN('MISSING_PARAM','DOMAIN_TYPE_CODE');
1410: FND_MSG_PUB.Add;
1411:
1412: FND_MSG_PUB.Count_And_Get
1413: (p_count => x_msg_count,
1414: p_data => x_msg_data );
1415:
1416: -- save message in debug log

Line 1435: FND_MSG_PUB.Add;

1431: 'Adding message CSD_SCD_INVALID_ID to FND_MSG stack');
1432: end if;
1433: FND_MESSAGE.SET_NAME('CSD','CSD_SCD_INVALID_ID');
1434: FND_MESSAGE.SET_TOKEN('SC_DOMAIN_ID',p_sc_domain_rec.sc_domain_id);
1435: FND_MSG_PUB.Add;
1436:
1437: FND_MSG_PUB.Count_And_Get
1438: (p_count => x_msg_count,
1439: p_data => x_msg_data );

Line 1437: FND_MSG_PUB.Count_And_Get

1433: FND_MESSAGE.SET_NAME('CSD','CSD_SCD_INVALID_ID');
1434: FND_MESSAGE.SET_TOKEN('SC_DOMAIN_ID',p_sc_domain_rec.sc_domain_id);
1435: FND_MSG_PUB.Add;
1436:
1437: FND_MSG_PUB.Count_And_Get
1438: (p_count => x_msg_count,
1439: p_data => x_msg_data );
1440:
1441: -- save message in debug log

Line 1460: FND_MSG_PUB.Add;

1456: 'Adding message CSD_SCD_GET_OVN_ERROR to FND_MSG stack');
1457: end if;
1458: FND_MESSAGE.SET_NAME('CSD','CSD_SCD_GET_OVN_ERROR');
1459: FND_MESSAGE.SET_TOKEN('SC_DOMAIN_ID',p_sc_domain_rec.sc_domain_id);
1460: FND_MSG_PUB.Add;
1461:
1462: FND_MSG_PUB.Count_And_Get
1463: (p_count => x_msg_count,
1464: p_data => x_msg_data );

Line 1462: FND_MSG_PUB.Count_And_Get

1458: FND_MESSAGE.SET_NAME('CSD','CSD_SCD_GET_OVN_ERROR');
1459: FND_MESSAGE.SET_TOKEN('SC_DOMAIN_ID',p_sc_domain_rec.sc_domain_id);
1460: FND_MSG_PUB.Add;
1461:
1462: FND_MSG_PUB.Count_And_Get
1463: (p_count => x_msg_count,
1464: p_data => x_msg_data );
1465:
1466: -- save message in debug log

Line 1485: FND_MSG_PUB.Add;

1481: 'Adding message CSD_SCD_OVN_MISMATCH to FND_MSG stack');
1482: end if;
1483: FND_MESSAGE.SET_NAME('CSD','CSD_SCD_OVN_MISMATCH');
1484: FND_MESSAGE.SET_TOKEN('SC_DOMAIN_ID',p_sc_domain_rec.sc_domain_id);
1485: FND_MSG_PUB.Add;
1486:
1487: FND_MSG_PUB.Count_And_Get
1488: (p_count => x_msg_count,
1489: p_data => x_msg_data );

Line 1487: FND_MSG_PUB.Count_And_Get

1483: FND_MESSAGE.SET_NAME('CSD','CSD_SCD_OVN_MISMATCH');
1484: FND_MESSAGE.SET_TOKEN('SC_DOMAIN_ID',p_sc_domain_rec.sc_domain_id);
1485: FND_MSG_PUB.Add;
1486:
1487: FND_MSG_PUB.Count_And_Get
1488: (p_count => x_msg_count,
1489: p_data => x_msg_data );
1490:
1491: -- save message in debug log

Line 1510: FND_MSG_PUB.Add;

1506: 'Adding message CSD_SCD_DOMAIN_EXISTS to FND_MSG stack');
1507: end if;
1508: FND_MESSAGE.SET_NAME('CSD','CSD_SCD_DOMAIN_EXISTS');
1509: FND_MESSAGE.SET_TOKEN('SERVICE_CODE_ID',p_sc_domain_rec.service_code_id);
1510: FND_MSG_PUB.Add;
1511:
1512: FND_MSG_PUB.Count_And_Get
1513: (p_count => x_msg_count,
1514: p_data => x_msg_data );

Line 1512: FND_MSG_PUB.Count_And_Get

1508: FND_MESSAGE.SET_NAME('CSD','CSD_SCD_DOMAIN_EXISTS');
1509: FND_MESSAGE.SET_TOKEN('SERVICE_CODE_ID',p_sc_domain_rec.service_code_id);
1510: FND_MSG_PUB.Add;
1511:
1512: FND_MSG_PUB.Count_And_Get
1513: (p_count => x_msg_count,
1514: p_data => x_msg_data );
1515:
1516: -- save message in debug log

Line 1535: FND_MSG_PUB.Add;

1531: 'Adding message CSD_SCD_GET_ITEM_ERROR to FND_MSG stack');
1532: end if;
1533: FND_MESSAGE.SET_NAME('CSD','CSD_SCD_GET_ITEM_ERROR');
1534: FND_MESSAGE.SET_TOKEN('SC_DOMAIN_ID',p_sc_domain_rec.sc_domain_id);
1535: FND_MSG_PUB.Add;
1536:
1537: FND_MSG_PUB.Count_And_Get
1538: (p_count => x_msg_count,
1539: p_data => x_msg_data );

Line 1537: FND_MSG_PUB.Count_And_Get

1533: FND_MESSAGE.SET_NAME('CSD','CSD_SCD_GET_ITEM_ERROR');
1534: FND_MESSAGE.SET_TOKEN('SC_DOMAIN_ID',p_sc_domain_rec.sc_domain_id);
1535: FND_MSG_PUB.Add;
1536:
1537: FND_MSG_PUB.Count_And_Get
1538: (p_count => x_msg_count,
1539: p_data => x_msg_data );
1540:
1541: -- save message in debug log

Line 1560: FND_MSG_PUB.Add;

1556: 'Adding message CSD_SCD_INVALID_ITEM to FND_MSG stack');
1557: end if;
1558: FND_MESSAGE.SET_NAME('CSD','CSD_SCD_INVALID_ITEM');
1559: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_sc_domain_rec.inventory_item_id);
1560: FND_MSG_PUB.Add;
1561:
1562: FND_MSG_PUB.Count_And_Get
1563: (p_count => x_msg_count,
1564: p_data => x_msg_data );

Line 1562: FND_MSG_PUB.Count_And_Get

1558: FND_MESSAGE.SET_NAME('CSD','CSD_SCD_INVALID_ITEM');
1559: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_sc_domain_rec.inventory_item_id);
1560: FND_MSG_PUB.Add;
1561:
1562: FND_MSG_PUB.Count_And_Get
1563: (p_count => x_msg_count,
1564: p_data => x_msg_data );
1565:
1566: -- save message in debug log

Line 1585: FND_MSG_PUB.Add;

1581: 'Adding message CSD_SCD_GET_CAT_SET_ERROR to FND_MSG stack');
1582: end if;
1583: FND_MESSAGE.SET_NAME('CSD','CSD_SCD_GET_CAT_SET_ERROR');
1584: FND_MESSAGE.SET_TOKEN('SC_DOMAIN_ID',p_sc_domain_rec.sc_domain_id);
1585: FND_MSG_PUB.Add;
1586:
1587: FND_MSG_PUB.Count_And_Get
1588: (p_count => x_msg_count,
1589: p_data => x_msg_data );

Line 1587: FND_MSG_PUB.Count_And_Get

1583: FND_MESSAGE.SET_NAME('CSD','CSD_SCD_GET_CAT_SET_ERROR');
1584: FND_MESSAGE.SET_TOKEN('SC_DOMAIN_ID',p_sc_domain_rec.sc_domain_id);
1585: FND_MSG_PUB.Add;
1586:
1587: FND_MSG_PUB.Count_And_Get
1588: (p_count => x_msg_count,
1589: p_data => x_msg_data );
1590:
1591: -- save message in debug log

Line 1610: FND_MSG_PUB.Add;

1606: 'Adding message CSD_SCD_INVALID_CAT_SET to FND_MSG stack');
1607: end if;
1608: FND_MESSAGE.SET_NAME('CSD','CSD_SCD_INVALID_CAT_SET');
1609: FND_MESSAGE.SET_TOKEN('CATEGORY_SET_ID',p_sc_domain_rec.category_set_id);
1610: FND_MSG_PUB.Add;
1611:
1612: FND_MSG_PUB.Count_And_Get
1613: (p_count => x_msg_count,
1614: p_data => x_msg_data );

Line 1612: FND_MSG_PUB.Count_And_Get

1608: FND_MESSAGE.SET_NAME('CSD','CSD_SCD_INVALID_CAT_SET');
1609: FND_MESSAGE.SET_TOKEN('CATEGORY_SET_ID',p_sc_domain_rec.category_set_id);
1610: FND_MSG_PUB.Add;
1611:
1612: FND_MSG_PUB.Count_And_Get
1613: (p_count => x_msg_count,
1614: p_data => x_msg_data );
1615:
1616: -- save message in debug log

Line 1635: FND_MSG_PUB.Add;

1631: 'Adding message CSD_SCD_GET_CATSET_FLAG_ERROR to FND_MSG stack');
1632: end if;
1633: FND_MESSAGE.SET_NAME('CSD','CSD_SCD_GET_CATSET_FLAG_ERROR');
1634: FND_MESSAGE.SET_TOKEN('CATEGORY_SET_ID',p_sc_domain_rec.category_set_id);
1635: FND_MSG_PUB.Add;
1636:
1637: FND_MSG_PUB.Count_And_Get
1638: (p_count => x_msg_count,
1639: p_data => x_msg_data );

Line 1637: FND_MSG_PUB.Count_And_Get

1633: FND_MESSAGE.SET_NAME('CSD','CSD_SCD_GET_CATSET_FLAG_ERROR');
1634: FND_MESSAGE.SET_TOKEN('CATEGORY_SET_ID',p_sc_domain_rec.category_set_id);
1635: FND_MSG_PUB.Add;
1636:
1637: FND_MSG_PUB.Count_And_Get
1638: (p_count => x_msg_count,
1639: p_data => x_msg_data );
1640:
1641: -- save message in debug log

Line 1660: FND_MSG_PUB.Add;

1656: 'Adding message CSD_SCD_GET_CATEGORY_ERROR to FND_MSG stack');
1657: end if;
1658: FND_MESSAGE.SET_NAME('CSD','CSD_SCD_GET_CATEGORY_ERROR');
1659: FND_MESSAGE.SET_TOKEN('SC_DOMAIN_ID',p_sc_domain_rec.sc_domain_id);
1660: FND_MSG_PUB.Add;
1661:
1662: FND_MSG_PUB.Count_And_Get
1663: (p_count => x_msg_count,
1664: p_data => x_msg_data );

Line 1662: FND_MSG_PUB.Count_And_Get

1658: FND_MESSAGE.SET_NAME('CSD','CSD_SCD_GET_CATEGORY_ERROR');
1659: FND_MESSAGE.SET_TOKEN('SC_DOMAIN_ID',p_sc_domain_rec.sc_domain_id);
1660: FND_MSG_PUB.Add;
1661:
1662: FND_MSG_PUB.Count_And_Get
1663: (p_count => x_msg_count,
1664: p_data => x_msg_data );
1665:
1666: -- save message in debug log

Line 1685: FND_MSG_PUB.Add;

1681: 'Adding message CSD_SCD_INVALID_CATEGORY to FND_MSG stack');
1682: end if;
1683: FND_MESSAGE.SET_NAME('CSD','CSD_SCD_INVALID_CATEGORY');
1684: FND_MESSAGE.SET_TOKEN('CATEGORY_ID',p_sc_domain_rec.category_id);
1685: FND_MSG_PUB.Add;
1686:
1687: FND_MSG_PUB.Count_And_Get
1688: (p_count => x_msg_count,
1689: p_data => x_msg_data );

Line 1687: FND_MSG_PUB.Count_And_Get

1683: FND_MESSAGE.SET_NAME('CSD','CSD_SCD_INVALID_CATEGORY');
1684: FND_MESSAGE.SET_TOKEN('CATEGORY_ID',p_sc_domain_rec.category_id);
1685: FND_MSG_PUB.Add;
1686:
1687: FND_MSG_PUB.Count_And_Get
1688: (p_count => x_msg_count,
1689: p_data => x_msg_data );
1690:
1691: -- save message in debug log

Line 1702: FND_MSG_PUB.Count_And_Get

1698: ROLLBACK TO Update_SC_Domain;
1699:
1700: x_return_status := FND_API.G_RET_STS_ERROR;
1701:
1702: FND_MSG_PUB.Count_And_Get
1703: (p_count => x_msg_count,
1704: p_data => x_msg_data );
1705:
1706: -- save message in debug log

Line 1717: IF FND_MSG_PUB.Check_Msg_Level

1713: ROLLBACK TO Update_SC_Domain;
1714:
1715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1716:
1717: IF FND_MSG_PUB.Check_Msg_Level
1718: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1719: THEN
1720: if (lc_stat_level >= lc_debug_level) then
1721: FND_LOG.STRING(lc_stat_level, lc_mod_name,

Line 1718: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1714:
1715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1716:
1717: IF FND_MSG_PUB.Check_Msg_Level
1718: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1719: THEN
1720: if (lc_stat_level >= lc_debug_level) then
1721: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1722: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

Line 1722: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

1718: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1719: THEN
1720: if (lc_stat_level >= lc_debug_level) then
1721: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1722: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
1723: end if;
1724: FND_MSG_PUB.Add_Exc_Msg
1725: (G_PKG_NAME ,
1726: lc_api_name );

Line 1724: FND_MSG_PUB.Add_Exc_Msg

1720: if (lc_stat_level >= lc_debug_level) then
1721: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1722: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
1723: end if;
1724: FND_MSG_PUB.Add_Exc_Msg
1725: (G_PKG_NAME ,
1726: lc_api_name );
1727: END IF;
1728:

Line 1729: FND_MSG_PUB.Count_And_Get

1725: (G_PKG_NAME ,
1726: lc_api_name );
1727: END IF;
1728:
1729: FND_MSG_PUB.Count_And_Get
1730: ( p_count => x_msg_count,
1731: p_data => x_msg_data );
1732:
1733: -- save message in debug log

Line 1745: IF FND_MSG_PUB.Check_Msg_Level

1741:
1742: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1743:
1744: -- save message in fnd stack
1745: IF FND_MSG_PUB.Check_Msg_Level
1746: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1747: THEN
1748: if (lc_stat_level >= lc_debug_level) then
1749: FND_LOG.STRING(lc_stat_level, lc_mod_name,

Line 1746: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1742: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1743:
1744: -- save message in fnd stack
1745: IF FND_MSG_PUB.Check_Msg_Level
1746: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1747: THEN
1748: if (lc_stat_level >= lc_debug_level) then
1749: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1750: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

Line 1750: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

1746: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1747: THEN
1748: if (lc_stat_level >= lc_debug_level) then
1749: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1750: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
1751: end if;
1752: FND_MSG_PUB.Add_Exc_Msg
1753: (G_PKG_NAME ,
1754: lc_api_name );

Line 1752: FND_MSG_PUB.Add_Exc_Msg

1748: if (lc_stat_level >= lc_debug_level) then
1749: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1750: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
1751: end if;
1752: FND_MSG_PUB.Add_Exc_Msg
1753: (G_PKG_NAME ,
1754: lc_api_name );
1755: END IF;
1756:

Line 1757: FND_MSG_PUB.Count_And_Get

1753: (G_PKG_NAME ,
1754: lc_api_name );
1755: END IF;
1756:
1757: FND_MSG_PUB.Count_And_Get
1758: (p_count => x_msg_count,
1759: p_data => x_msg_data );
1760:
1761: -- save message in debug log

Line 1820: FND_MSG_PUB.initialize;

1816: END IF;
1817:
1818: -- Initialize message list if p_init_msg_list is set to TRUE.
1819: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1820: FND_MSG_PUB.initialize;
1821: END IF;
1822:
1823: IF (lc_proc_level >= lc_debug_level) THEN
1824: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.BEGIN',

Line 1882: FND_MSG_PUB.Count_And_Get

1878: COMMIT WORK;
1879: END IF;
1880:
1881: -- Standard call to get message count and IF count is get message info.
1882: FND_MSG_PUB.Count_And_Get
1883: (p_count => x_msg_count,
1884: p_data => x_msg_data );
1885:
1886: IF (lc_proc_level >= lc_debug_level) THEN

Line 1898: FND_MSG_PUB.Count_And_Get

1894: ROLLBACK TO Delete_SC_Domain;
1895:
1896: x_return_status := FND_API.G_RET_STS_ERROR;
1897:
1898: FND_MSG_PUB.Count_And_Get
1899: (p_count => x_msg_count,
1900: p_data => x_msg_data );
1901:
1902: -- save message in debug log

Line 1913: IF FND_MSG_PUB.Check_Msg_Level

1909: ROLLBACK TO Delete_SC_Domain;
1910:
1911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1912:
1913: IF FND_MSG_PUB.Check_Msg_Level
1914: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1915: THEN
1916: if (lc_stat_level >= lc_debug_level) then
1917: FND_LOG.STRING(lc_stat_level, lc_mod_name,

Line 1914: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1910:
1911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1912:
1913: IF FND_MSG_PUB.Check_Msg_Level
1914: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1915: THEN
1916: if (lc_stat_level >= lc_debug_level) then
1917: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1918: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

Line 1918: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

1914: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1915: THEN
1916: if (lc_stat_level >= lc_debug_level) then
1917: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1918: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
1919: end if;
1920: FND_MSG_PUB.Add_Exc_Msg
1921: (G_PKG_NAME ,
1922: lc_api_name );

Line 1920: FND_MSG_PUB.Add_Exc_Msg

1916: if (lc_stat_level >= lc_debug_level) then
1917: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1918: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
1919: end if;
1920: FND_MSG_PUB.Add_Exc_Msg
1921: (G_PKG_NAME ,
1922: lc_api_name );
1923: END IF;
1924:

Line 1925: FND_MSG_PUB.Count_And_Get

1921: (G_PKG_NAME ,
1922: lc_api_name );
1923: END IF;
1924:
1925: FND_MSG_PUB.Count_And_Get
1926: ( p_count => x_msg_count,
1927: p_data => x_msg_data );
1928:
1929: -- save message in debug log

Line 1941: IF FND_MSG_PUB.Check_Msg_Level

1937:
1938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1939:
1940: -- save message in fnd stack
1941: IF FND_MSG_PUB.Check_Msg_Level
1942: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1943: THEN
1944: if (lc_stat_level >= lc_debug_level) then
1945: FND_LOG.STRING(lc_stat_level, lc_mod_name,

Line 1942: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1939:
1940: -- save message in fnd stack
1941: IF FND_MSG_PUB.Check_Msg_Level
1942: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1943: THEN
1944: if (lc_stat_level >= lc_debug_level) then
1945: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1946: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

Line 1946: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

1942: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1943: THEN
1944: if (lc_stat_level >= lc_debug_level) then
1945: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1946: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
1947: end if;
1948: FND_MSG_PUB.Add_Exc_Msg
1949: (G_PKG_NAME ,
1950: lc_api_name );

Line 1948: FND_MSG_PUB.Add_Exc_Msg

1944: if (lc_stat_level >= lc_debug_level) then
1945: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1946: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
1947: end if;
1948: FND_MSG_PUB.Add_Exc_Msg
1949: (G_PKG_NAME ,
1950: lc_api_name );
1951: END IF;
1952:

Line 1953: FND_MSG_PUB.Count_And_Get

1949: (G_PKG_NAME ,
1950: lc_api_name );
1951: END IF;
1952:
1953: FND_MSG_PUB.Count_And_Get
1954: (p_count => x_msg_count,
1955: p_data => x_msg_data );
1956:
1957: -- save message in debug log

Line 2016: FND_MSG_PUB.initialize;

2012: END IF;
2013:
2014: -- Initialize message list if p_init_msg_list is set to TRUE.
2015: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2016: FND_MSG_PUB.initialize;
2017: END IF;
2018:
2019: IF (lc_proc_level >= lc_debug_level) THEN
2020: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.BEGIN',

Line 2117: FND_MSG_PUB.Count_And_Get

2113: COMMIT WORK;
2114: END IF;
2115:
2116: -- Standard call to get message count and IF count is get message info.
2117: FND_MSG_PUB.Count_And_Get
2118: (p_count => x_msg_count,
2119: p_data => x_msg_data );
2120:
2121: IF (lc_proc_level >= lc_debug_level) THEN

Line 2133: FND_MSG_PUB.Count_And_Get

2129: ROLLBACK TO Lock_SC_Domain;
2130:
2131: x_return_status := FND_API.G_RET_STS_ERROR;
2132:
2133: FND_MSG_PUB.Count_And_Get
2134: (p_count => x_msg_count,
2135: p_data => x_msg_data );
2136:
2137: -- save message in debug log

Line 2148: IF FND_MSG_PUB.Check_Msg_Level

2144: ROLLBACK TO Lock_SC_Domain;
2145:
2146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2147:
2148: IF FND_MSG_PUB.Check_Msg_Level
2149: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2150: THEN
2151: if (lc_stat_level >= lc_debug_level) then
2152: FND_LOG.STRING(lc_stat_level, lc_mod_name,

Line 2149: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2145:
2146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2147:
2148: IF FND_MSG_PUB.Check_Msg_Level
2149: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2150: THEN
2151: if (lc_stat_level >= lc_debug_level) then
2152: FND_LOG.STRING(lc_stat_level, lc_mod_name,
2153: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

Line 2153: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

2149: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2150: THEN
2151: if (lc_stat_level >= lc_debug_level) then
2152: FND_LOG.STRING(lc_stat_level, lc_mod_name,
2153: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
2154: end if;
2155: FND_MSG_PUB.Add_Exc_Msg
2156: (G_PKG_NAME ,
2157: lc_api_name );

Line 2155: FND_MSG_PUB.Add_Exc_Msg

2151: if (lc_stat_level >= lc_debug_level) then
2152: FND_LOG.STRING(lc_stat_level, lc_mod_name,
2153: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
2154: end if;
2155: FND_MSG_PUB.Add_Exc_Msg
2156: (G_PKG_NAME ,
2157: lc_api_name );
2158: END IF;
2159:

Line 2160: FND_MSG_PUB.Count_And_Get

2156: (G_PKG_NAME ,
2157: lc_api_name );
2158: END IF;
2159:
2160: FND_MSG_PUB.Count_And_Get
2161: ( p_count => x_msg_count,
2162: p_data => x_msg_data );
2163:
2164: -- save message in debug log

Line 2176: IF FND_MSG_PUB.Check_Msg_Level

2172:
2173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2174:
2175: -- save message in fnd stack
2176: IF FND_MSG_PUB.Check_Msg_Level
2177: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2178: THEN
2179: if (lc_stat_level >= lc_debug_level) then
2180: FND_LOG.STRING(lc_stat_level, lc_mod_name,

Line 2177: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2174:
2175: -- save message in fnd stack
2176: IF FND_MSG_PUB.Check_Msg_Level
2177: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2178: THEN
2179: if (lc_stat_level >= lc_debug_level) then
2180: FND_LOG.STRING(lc_stat_level, lc_mod_name,
2181: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

Line 2181: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

2177: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2178: THEN
2179: if (lc_stat_level >= lc_debug_level) then
2180: FND_LOG.STRING(lc_stat_level, lc_mod_name,
2181: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
2182: end if;
2183: FND_MSG_PUB.Add_Exc_Msg
2184: (G_PKG_NAME ,
2185: lc_api_name );

Line 2183: FND_MSG_PUB.Add_Exc_Msg

2179: if (lc_stat_level >= lc_debug_level) then
2180: FND_LOG.STRING(lc_stat_level, lc_mod_name,
2181: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
2182: end if;
2183: FND_MSG_PUB.Add_Exc_Msg
2184: (G_PKG_NAME ,
2185: lc_api_name );
2186: END IF;
2187:

Line 2188: FND_MSG_PUB.Count_And_Get

2184: (G_PKG_NAME ,
2185: lc_api_name );
2186: END IF;
2187:
2188: FND_MSG_PUB.Count_And_Get
2189: (p_count => x_msg_count,
2190: p_data => x_msg_data );
2191:
2192: -- save message in debug log