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_API

Line 64: IF NOT FND_API.Compatible_API_Call (lc_api_version,

60: -- Standard Start of API savepoint
61: SAVEPOINT Create_SC_Domain;
62:
63: -- Standard call to check for call compatibility.
64: IF NOT FND_API.Compatible_API_Call (lc_api_version,
65: p_api_version,
66: lc_api_name ,
67: G_PKG_NAME )
68: THEN

Line 69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

65: p_api_version,
66: lc_api_name ,
67: G_PKG_NAME )
68: THEN
69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 73: IF FND_API.to_Boolean( p_init_msg_list ) THEN

69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 89: x_return_status := FND_API.G_RET_STS_SUCCESS;

85: ( p_sc_domain_rec => p_sc_domain_rec);
86: END IF;
87:
88: -- Initialize API return status to success
89: x_return_status := FND_API.G_RET_STS_SUCCESS;
90:
91: -- Api body starts
92:
93: -- Check the required parameters

Line 119: and (p_sc_domain_rec.inventory_item_id = FND_API.G_MISS_NUM

115: end if;
116:
117: -- Check if required parameter is passed in as G_MISS
118: IF (p_sc_domain_rec.domain_type_code = 'ITEM'
119: and (p_sc_domain_rec.inventory_item_id = FND_API.G_MISS_NUM
120: or p_sc_domain_rec.inventory_item_id is null)) THEN
121: RAISE CSD_SCD_ITEM_MISSING;
122: END IF;
123:

Line 126: IF (p_sc_domain_rec.category_set_id = FND_API.G_MISS_NUM

122: END IF;
123:
124: -- Check if required parameter is passed in as G_MISS
125: IF (p_sc_domain_rec.domain_type_code = 'CAT') THEN
126: IF (p_sc_domain_rec.category_set_id = FND_API.G_MISS_NUM
127: or p_sc_domain_rec.category_set_id is null) THEN
128: RAISE CSD_SCD_CATEGORY_SET_MISSING;
129: END IF;
130: IF (p_sc_domain_rec.category_id = FND_API.G_MISS_NUM

Line 130: IF (p_sc_domain_rec.category_id = FND_API.G_MISS_NUM

126: IF (p_sc_domain_rec.category_set_id = FND_API.G_MISS_NUM
127: or p_sc_domain_rec.category_set_id is null) THEN
128: RAISE CSD_SCD_CATEGORY_SET_MISSING;
129: END IF;
130: IF (p_sc_domain_rec.category_id = FND_API.G_MISS_NUM
131: or p_sc_domain_rec.category_id is null) THEN
132: RAISE CSD_SCD_CATEGORY_MISSING;
133: END IF;
134: END IF;

Line 358: l_inventory_item_id := FND_API.G_MISS_NUM;

354: FND_LOG.STRING(lc_proc_level, lc_mod_name,
355: 'Domain type is CATEGORY, setting item id to G_MISS_NUM');
356: end if;
357:
358: l_inventory_item_id := FND_API.G_MISS_NUM;
359: l_category_id := p_sc_domain_rec.category_id;
360: l_category_set_id := p_sc_domain_rec.category_set_id;
361:
362: ELSIF (p_sc_domain_rec.domain_type_code = 'ITEM') then

Line 369: l_category_id := FND_API.G_MISS_NUM;

365: FND_LOG.STRING(lc_proc_level, lc_mod_name,
366: 'Domain type is ITEM, setting category set and category ids to G_MISS_NUM');
367: end if;
368:
369: l_category_id := FND_API.G_MISS_NUM;
370: l_category_set_id := FND_API.G_MISS_NUM;
371: l_inventory_item_id := p_sc_domain_rec.inventory_item_id;
372: END IF;
373:

Line 370: l_category_set_id := FND_API.G_MISS_NUM;

366: 'Domain type is ITEM, setting category set and category ids to G_MISS_NUM');
367: end if;
368:
369: l_category_id := FND_API.G_MISS_NUM;
370: l_category_set_id := FND_API.G_MISS_NUM;
371: l_inventory_item_id := p_sc_domain_rec.inventory_item_id;
372: END IF;
373:
374: -- Insert row

Line 419: x_return_status := FND_API.G_RET_STS_ERROR;

415: WHEN OTHERS THEN
416: IF ( lc_excep_level >= lc_debug_level) THEN
417: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_SC_DOMAINS_PKG.Insert_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
418: END IF;
419: x_return_status := FND_API.G_RET_STS_ERROR;
420: END;
421:
422: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
423: RAISE FND_API.G_EXC_ERROR;

Line 422: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

418: END IF;
419: x_return_status := FND_API.G_RET_STS_ERROR;
420: END;
421:
422: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
423: RAISE FND_API.G_EXC_ERROR;
424: END IF;
425:
426: if (lc_proc_level >= lc_debug_level) then

Line 423: RAISE FND_API.G_EXC_ERROR;

419: x_return_status := FND_API.G_RET_STS_ERROR;
420: END;
421:
422: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
423: RAISE FND_API.G_EXC_ERROR;
424: END IF;
425:
426: if (lc_proc_level >= lc_debug_level) then
427: FND_LOG.STRING(lc_proc_level, lc_mod_name,

Line 434: IF FND_API.To_Boolean( p_commit ) THEN

430:
431: -- Api body ends here
432:
433: -- Standard check of p_commit.
434: IF FND_API.To_Boolean( p_commit ) THEN
435: COMMIT WORK;
436: END IF;
437:
438: -- Standard call to get message count and IF count is get message info.

Line 453: x_return_status := FND_API.G_RET_STS_ERROR ;

449: WHEN CSD_SCD_ITEM_MISSING THEN
450: ROLLBACK TO Create_SC_Domain;
451:
452: -- Service code domain item is missing
453: x_return_status := FND_API.G_RET_STS_ERROR ;
454:
455: -- save message in fnd stack
456: if (lc_stat_level >= lc_debug_level) then
457: FND_LOG.STRING(lc_stat_level, lc_mod_name,

Line 479: x_return_status := FND_API.G_RET_STS_ERROR ;

475: WHEN CSD_SCD_CATEGORY_SET_MISSING THEN
476: ROLLBACK TO Create_SC_Domain;
477:
478: -- Service code domain category set is missing
479: x_return_status := FND_API.G_RET_STS_ERROR ;
480:
481: -- save message in fnd stack
482: if (lc_stat_level >= lc_debug_level) then
483: FND_LOG.STRING(lc_stat_level, lc_mod_name,

Line 505: x_return_status := FND_API.G_RET_STS_ERROR ;

501: WHEN CSD_SCD_CATEGORY_MISSING THEN
502: ROLLBACK TO Create_SC_Domain;
503:
504: -- Service code domain category is missing
505: x_return_status := FND_API.G_RET_STS_ERROR ;
506:
507: -- save message in fnd stack
508: if (lc_stat_level >= lc_debug_level) then
509: FND_LOG.STRING(lc_stat_level, lc_mod_name,

Line 531: x_return_status := FND_API.G_RET_STS_ERROR ;

527: WHEN CSD_SCD_DOMAIN_EXISTS THEN
528: ROLLBACK TO Create_SC_Domain;
529:
530: -- Service code domain already exists
531: x_return_status := FND_API.G_RET_STS_ERROR ;
532:
533: -- save message in fnd stack
534: if (lc_stat_level >= lc_debug_level) then
535: FND_LOG.STRING(lc_stat_level, lc_mod_name,

Line 556: x_return_status := FND_API.G_RET_STS_ERROR ;

552: WHEN CSD_SCD_INVALID_ITEM THEN
553: ROLLBACK TO Create_SC_Domain;
554:
555: -- Service code domain item is invalid
556: x_return_status := FND_API.G_RET_STS_ERROR ;
557:
558: -- save message in fnd stack
559: if (lc_stat_level >= lc_debug_level) then
560: FND_LOG.STRING(lc_stat_level, lc_mod_name,

Line 581: x_return_status := FND_API.G_RET_STS_ERROR ;

577: WHEN CSD_SCD_INVALID_CAT_SET THEN
578: ROLLBACK TO Create_SC_Domain;
579:
580: -- Service code domain category set is invalid
581: x_return_status := FND_API.G_RET_STS_ERROR ;
582:
583: -- save message in fnd stack
584: if (lc_stat_level >= lc_debug_level) then
585: FND_LOG.STRING(lc_stat_level, lc_mod_name,

Line 606: x_return_status := FND_API.G_RET_STS_ERROR ;

602: WHEN CSD_SCD_INVALID_CATSET_FLAG THEN
603: ROLLBACK TO Create_SC_Domain;
604:
605: -- Service code domain category set validate flag is invalid
606: x_return_status := FND_API.G_RET_STS_ERROR ;
607:
608: -- save message in fnd stack
609: if (lc_stat_level >= lc_debug_level) then
610: FND_LOG.STRING(lc_stat_level, lc_mod_name,

Line 631: x_return_status := FND_API.G_RET_STS_ERROR ;

627: WHEN CSD_SCD_INVALID_CATEGORY THEN
628: ROLLBACK TO Create_SC_Domain;
629:
630: -- Service code domain category is invalid
631: x_return_status := FND_API.G_RET_STS_ERROR ;
632:
633: -- save message in fnd stack
634: if (lc_stat_level >= lc_debug_level) then
635: FND_LOG.STRING(lc_stat_level, lc_mod_name,

Line 652: WHEN FND_API.G_EXC_ERROR THEN

648: FND_LOG.STRING(lc_excep_level, lc_mod_name,
649: 'Service code domain category is invalid');
650: END IF;
651:
652: WHEN FND_API.G_EXC_ERROR THEN
653: ROLLBACK TO Create_SC_Domain;
654:
655: x_return_status := FND_API.G_RET_STS_ERROR;
656:

Line 655: x_return_status := FND_API.G_RET_STS_ERROR;

651:
652: WHEN FND_API.G_EXC_ERROR THEN
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 );

Line 667: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

663: FND_LOG.STRING(lc_excep_level, lc_mod_name,
664: 'EXC_ERROR['||x_msg_data||']');
665: END IF;
666:
667: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
668: ROLLBACK TO Create_SC_Domain;
669:
670: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
671:

Line 670: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

666:
667: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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

Line 697: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

693:
694: WHEN OTHERS THEN
695: ROLLBACK TO Create_SC_Domain;
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)

Line 791: IF NOT FND_API.Compatible_API_Call (lc_api_version,

787: -- Standard Start of API savepoint
788: SAVEPOINT Update_SC_Domain;
789:
790: -- Standard call to check for call compatibility.
791: IF NOT FND_API.Compatible_API_Call (lc_api_version,
792: p_api_version,
793: lc_api_name ,
794: G_PKG_NAME )
795: THEN

Line 796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

792: p_api_version,
793: lc_api_name ,
794: G_PKG_NAME )
795: THEN
796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 800: IF FND_API.to_Boolean( p_init_msg_list ) THEN

796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 816: x_return_status := FND_API.G_RET_STS_SUCCESS;

812: ( p_sc_domain_rec => p_sc_domain_rec);
813: END IF;
814:
815: -- Initialize API return status to success
816: x_return_status := FND_API.G_RET_STS_SUCCESS;
817:
818: -- Api body starts
819:
820: -- Check the required parameters

Line 839: IF (p_sc_domain_rec.service_code_id = FND_API.G_MISS_NUM) THEN

835: 'Checking if required parameters are passed in as G_MISS');
836: end if;
837:
838: -- Check if required parameter is passed in as G_MISS
839: IF (p_sc_domain_rec.service_code_id = FND_API.G_MISS_NUM) THEN
840: RAISE CSD_SCD_SC_ID_MISSING;
841: END IF;
842:
843: -- Check if required parameter is passed in as G_MISS

Line 844: IF (p_sc_domain_rec.domain_type_code = FND_API.G_MISS_CHAR) THEN

840: RAISE CSD_SCD_SC_ID_MISSING;
841: END IF;
842:
843: -- Check if required parameter is passed in as G_MISS
844: IF (p_sc_domain_rec.domain_type_code = FND_API.G_MISS_CHAR) THEN
845: RAISE CSD_SCD_DOMAIN_TYPE_MISSING;
846: END IF;
847:
848: -- Check if required parameter is passed in as G_MISS

Line 850: and p_sc_domain_rec.inventory_item_id = FND_API.G_MISS_NUM) THEN

846: END IF;
847:
848: -- Check if required parameter is passed in as G_MISS
849: IF (p_sc_domain_rec.domain_type_code = 'ITEM'
850: and p_sc_domain_rec.inventory_item_id = FND_API.G_MISS_NUM) THEN
851: RAISE CSD_SCD_ITEM_MISSING;
852: END IF;
853:
854: -- Check if required parameter is passed in as G_MISS

Line 856: IF (p_sc_domain_rec.category_set_id = FND_API.G_MISS_NUM) THEN

852: END IF;
853:
854: -- Check if required parameter is passed in as G_MISS
855: IF (p_sc_domain_rec.domain_type_code = 'CAT') THEN
856: IF (p_sc_domain_rec.category_set_id = FND_API.G_MISS_NUM) THEN
857: RAISE CSD_SCD_CATEGORY_SET_MISSING;
858: END IF;
859:
860: IF (p_sc_domain_rec.category_id = FND_API.G_MISS_NUM) THEN

Line 860: IF (p_sc_domain_rec.category_id = FND_API.G_MISS_NUM) THEN

856: IF (p_sc_domain_rec.category_set_id = FND_API.G_MISS_NUM) THEN
857: RAISE CSD_SCD_CATEGORY_SET_MISSING;
858: END IF;
859:
860: IF (p_sc_domain_rec.category_id = FND_API.G_MISS_NUM) THEN
861: RAISE CSD_SCD_CATEGORY_MISSING;
862: END IF;
863: END IF;
864:

Line 931: IF NVL(p_sc_domain_rec.object_version_number,FND_API.G_MISS_NUM) <> l_obj_ver_num THEN

927: 'Validate object version number for service code domain');
928: end if;
929:
930: -- Validate if object version number for service code domain is same as the one passed in
931: IF NVL(p_sc_domain_rec.object_version_number,FND_API.G_MISS_NUM) <> l_obj_ver_num THEN
932: RAISE CSD_SCD_OVN_MISMATCH;
933: ELSE
934: if (lc_stat_level >= lc_debug_level) then
935: FND_LOG.STRING(lc_stat_level, lc_mod_name,

Line 1281: l_inventory_item_id := FND_API.G_MISS_NUM;

1277: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1278: 'Domain type is CATEGORY, setting item id to G_MISS_NUM');
1279: end if;
1280:
1281: l_inventory_item_id := FND_API.G_MISS_NUM;
1282:
1283: ELSIF (p_sc_domain_rec.domain_type_code = 'ITEM') then
1284:
1285: if (lc_proc_level >= lc_debug_level) then

Line 1290: l_category_id := FND_API.G_MISS_NUM;

1286: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1287: 'Domain type is ITEM, setting category set and category ids to G_MISS_NUM');
1288: end if;
1289:
1290: l_category_id := FND_API.G_MISS_NUM;
1291: l_category_set_id := FND_API.G_MISS_NUM;
1292: END IF;
1293:
1294: -- Update row

Line 1291: l_category_set_id := FND_API.G_MISS_NUM;

1287: 'Domain type is ITEM, setting category set and category ids to G_MISS_NUM');
1288: end if;
1289:
1290: l_category_id := FND_API.G_MISS_NUM;
1291: l_category_set_id := FND_API.G_MISS_NUM;
1292: END IF;
1293:
1294: -- Update row
1295: if (lc_proc_level >= lc_debug_level) then

Line 1341: x_return_status := FND_API.G_RET_STS_ERROR;

1337: WHEN OTHERS THEN
1338: IF ( lc_excep_level >= lc_debug_level) THEN
1339: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_SC_DOMAINS_PKG.Update_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
1340: END IF;
1341: x_return_status := FND_API.G_RET_STS_ERROR;
1342: END;
1343:
1344: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1345: RAISE FND_API.G_EXC_ERROR;

Line 1344: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1340: END IF;
1341: x_return_status := FND_API.G_RET_STS_ERROR;
1342: END;
1343:
1344: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1345: RAISE FND_API.G_EXC_ERROR;
1346: END IF;
1347:
1348: if (lc_proc_level >= lc_debug_level) then

Line 1345: RAISE FND_API.G_EXC_ERROR;

1341: x_return_status := FND_API.G_RET_STS_ERROR;
1342: END;
1343:
1344: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1345: RAISE FND_API.G_EXC_ERROR;
1346: END IF;
1347:
1348: if (lc_proc_level >= lc_debug_level) then
1349: FND_LOG.STRING(lc_proc_level, lc_mod_name,

Line 1356: IF FND_API.To_Boolean( p_commit ) THEN

1352:
1353: -- Api body ends here
1354:
1355: -- Standard check of p_commit.
1356: IF FND_API.To_Boolean( p_commit ) THEN
1357: COMMIT WORK;
1358: END IF;
1359:
1360: -- Standard call to get message count and IF count is get message info.

Line 1374: x_return_status := FND_API.G_RET_STS_ERROR ;

1370: EXCEPTION
1371: WHEN CSD_SCD_SC_ID_MISSING THEN
1372: ROLLBACK TO Update_SC_Domain;
1373: -- Service code id is missing
1374: x_return_status := FND_API.G_RET_STS_ERROR ;
1375:
1376: -- save message in fnd stack
1377: if (lc_stat_level >= lc_debug_level) then
1378: FND_LOG.STRING(lc_stat_level, lc_mod_name,

Line 1400: x_return_status := FND_API.G_RET_STS_ERROR ;

1396: WHEN CSD_SCD_DOMAIN_TYPE_MISSING THEN
1397: ROLLBACK TO Update_SC_Domain;
1398:
1399: -- Service code domain type is missing
1400: x_return_status := FND_API.G_RET_STS_ERROR ;
1401:
1402: -- save message in fnd stack
1403: if (lc_stat_level >= lc_debug_level) then
1404: FND_LOG.STRING(lc_stat_level, lc_mod_name,

Line 1426: x_return_status := FND_API.G_RET_STS_ERROR ;

1422: WHEN CSD_SCD_INVALID_ID THEN
1423: ROLLBACK TO Update_SC_Domain;
1424:
1425: -- Service code domain id is invalid
1426: x_return_status := FND_API.G_RET_STS_ERROR ;
1427:
1428: -- save message in fnd stack
1429: if (lc_stat_level >= lc_debug_level) then
1430: FND_LOG.STRING(lc_stat_level, lc_mod_name,

Line 1451: x_return_status := FND_API.G_RET_STS_ERROR ;

1447: WHEN CSD_SCD_GET_OVN_ERROR THEN
1448: ROLLBACK TO Update_SC_Domain;
1449:
1450: -- Service code domain get object version number error
1451: x_return_status := FND_API.G_RET_STS_ERROR ;
1452:
1453: -- save message in fnd stack
1454: if (lc_stat_level >= lc_debug_level) then
1455: FND_LOG.STRING(lc_stat_level, lc_mod_name,

Line 1476: x_return_status := FND_API.G_RET_STS_ERROR ;

1472: WHEN CSD_SCD_OVN_MISMATCH THEN
1473: ROLLBACK TO Update_SC_Domain;
1474:
1475: -- Service code domain object version number mismatch
1476: x_return_status := FND_API.G_RET_STS_ERROR ;
1477:
1478: -- save message in fnd stack
1479: if (lc_stat_level >= lc_debug_level) then
1480: FND_LOG.STRING(lc_stat_level, lc_mod_name,

Line 1501: x_return_status := FND_API.G_RET_STS_ERROR ;

1497: WHEN CSD_SCD_DOMAIN_EXISTS THEN
1498: ROLLBACK TO Update_SC_Domain;
1499:
1500: -- Service code domain already exists
1501: x_return_status := FND_API.G_RET_STS_ERROR ;
1502:
1503: -- save message in fnd stack
1504: if (lc_stat_level >= lc_debug_level) then
1505: FND_LOG.STRING(lc_stat_level, lc_mod_name,

Line 1526: x_return_status := FND_API.G_RET_STS_ERROR ;

1522: WHEN CSD_SCD_GET_ITEM_ERROR THEN
1523: ROLLBACK TO Update_SC_Domain;
1524:
1525: -- Service code domain get item error
1526: x_return_status := FND_API.G_RET_STS_ERROR ;
1527:
1528: -- save message in fnd stack
1529: if (lc_stat_level >= lc_debug_level) then
1530: FND_LOG.STRING(lc_stat_level, lc_mod_name,

Line 1551: x_return_status := FND_API.G_RET_STS_ERROR ;

1547: WHEN CSD_SCD_INVALID_ITEM THEN
1548: ROLLBACK TO Update_SC_Domain;
1549:
1550: -- Service code domain item is invalid
1551: x_return_status := FND_API.G_RET_STS_ERROR ;
1552:
1553: -- save message in fnd stack
1554: if (lc_stat_level >= lc_debug_level) then
1555: FND_LOG.STRING(lc_stat_level, lc_mod_name,

Line 1576: x_return_status := FND_API.G_RET_STS_ERROR ;

1572: WHEN CSD_SCD_GET_CAT_SET_ERROR THEN
1573: ROLLBACK TO Update_SC_Domain;
1574:
1575: -- Service code domain get category set error
1576: x_return_status := FND_API.G_RET_STS_ERROR ;
1577:
1578: -- save message in fnd stack
1579: if (lc_stat_level >= lc_debug_level) then
1580: FND_LOG.STRING(lc_stat_level, lc_mod_name,

Line 1601: x_return_status := FND_API.G_RET_STS_ERROR ;

1597: WHEN CSD_SCD_INVALID_CAT_SET THEN
1598: ROLLBACK TO Update_SC_Domain;
1599:
1600: -- Service code domain category set is invalid
1601: x_return_status := FND_API.G_RET_STS_ERROR ;
1602:
1603: -- save message in fnd stack
1604: if (lc_stat_level >= lc_debug_level) then
1605: FND_LOG.STRING(lc_stat_level, lc_mod_name,

Line 1626: x_return_status := FND_API.G_RET_STS_ERROR ;

1622: WHEN CSD_SCD_GET_CATSET_FLAG_ERROR THEN
1623: ROLLBACK TO Update_SC_Domain;
1624:
1625: -- Service code domain category set validate flag is invalid
1626: x_return_status := FND_API.G_RET_STS_ERROR ;
1627:
1628: -- save message in fnd stack
1629: if (lc_stat_level >= lc_debug_level) then
1630: FND_LOG.STRING(lc_stat_level, lc_mod_name,

Line 1651: x_return_status := FND_API.G_RET_STS_ERROR ;

1647: WHEN CSD_SCD_GET_CATEGORY_ERROR THEN
1648: ROLLBACK TO Update_SC_Domain;
1649:
1650: -- Service code domain get category error
1651: x_return_status := FND_API.G_RET_STS_ERROR ;
1652:
1653: -- save message in fnd stack
1654: if (lc_stat_level >= lc_debug_level) then
1655: FND_LOG.STRING(lc_stat_level, lc_mod_name,

Line 1676: x_return_status := FND_API.G_RET_STS_ERROR ;

1672: WHEN CSD_SCD_INVALID_CATEGORY THEN
1673: ROLLBACK TO Update_SC_Domain;
1674:
1675: -- Service code domain category is invalid
1676: x_return_status := FND_API.G_RET_STS_ERROR ;
1677:
1678: -- save message in fnd stack
1679: if (lc_stat_level >= lc_debug_level) then
1680: FND_LOG.STRING(lc_stat_level, lc_mod_name,

Line 1697: WHEN FND_API.G_EXC_ERROR THEN

1693: FND_LOG.STRING(lc_excep_level, lc_mod_name,
1694: 'Service code domain category is invalid');
1695: END IF;
1696:
1697: WHEN FND_API.G_EXC_ERROR THEN
1698: ROLLBACK TO Update_SC_Domain;
1699:
1700: x_return_status := FND_API.G_RET_STS_ERROR;
1701:

Line 1700: x_return_status := FND_API.G_RET_STS_ERROR;

1696:
1697: WHEN FND_API.G_EXC_ERROR THEN
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 );

Line 1712: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1708: FND_LOG.STRING(lc_excep_level, lc_mod_name,
1709: 'EXC_ERROR['||x_msg_data||']');
1710: END IF;
1711:
1712: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1713: ROLLBACK TO Update_SC_Domain;
1714:
1715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1716:

Line 1715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1711:
1712: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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

Line 1742: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1738:
1739: WHEN OTHERS THEN
1740: ROLLBACK TO Update_SC_Domain;
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)

Line 1810: IF NOT FND_API.Compatible_API_Call (lc_api_version,

1806: -- Standard Start of API savepoint
1807: SAVEPOINT Delete_SC_Domain;
1808:
1809: -- Standard call to check for call compatibility.
1810: IF NOT FND_API.Compatible_API_Call (lc_api_version,
1811: p_api_version,
1812: lc_api_name ,
1813: G_PKG_NAME )
1814: THEN

Line 1815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1811: p_api_version,
1812: lc_api_name ,
1813: G_PKG_NAME )
1814: THEN
1815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 1819: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 1829: x_return_status := FND_API.G_RET_STS_SUCCESS;

1825: 'Entered Delete_SC_Domain');
1826: END IF;
1827:
1828: -- Initialize API return status to success
1829: x_return_status := FND_API.G_RET_STS_SUCCESS;
1830:
1831: -- Api body starts
1832:
1833: -- Check the required parameters

Line 1862: x_return_status := FND_API.G_RET_STS_ERROR;

1858: WHEN OTHERS THEN
1859: IF ( lc_excep_level >= lc_debug_level) THEN
1860: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_SC_DOMAINS_PKG.Delete_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
1861: END IF;
1862: x_return_status := FND_API.G_RET_STS_ERROR;
1863: END;
1864:
1865: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1866: RAISE FND_API.G_EXC_ERROR;

Line 1865: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1861: END IF;
1862: x_return_status := FND_API.G_RET_STS_ERROR;
1863: END;
1864:
1865: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1866: RAISE FND_API.G_EXC_ERROR;
1867: END IF;
1868:
1869: if (lc_proc_level >= lc_debug_level) then

Line 1866: RAISE FND_API.G_EXC_ERROR;

1862: x_return_status := FND_API.G_RET_STS_ERROR;
1863: END;
1864:
1865: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1866: RAISE FND_API.G_EXC_ERROR;
1867: END IF;
1868:
1869: if (lc_proc_level >= lc_debug_level) then
1870: FND_LOG.STRING(lc_proc_level, lc_mod_name,

Line 1877: IF FND_API.To_Boolean( p_commit ) THEN

1873:
1874: -- Api body ends here
1875:
1876: -- Standard check of p_commit.
1877: IF FND_API.To_Boolean( p_commit ) THEN
1878: COMMIT WORK;
1879: END IF;
1880:
1881: -- Standard call to get message count and IF count is get message info.

Line 1893: WHEN FND_API.G_EXC_ERROR THEN

1889: END IF;
1890:
1891: EXCEPTION
1892:
1893: WHEN FND_API.G_EXC_ERROR THEN
1894: ROLLBACK TO Delete_SC_Domain;
1895:
1896: x_return_status := FND_API.G_RET_STS_ERROR;
1897:

Line 1896: x_return_status := FND_API.G_RET_STS_ERROR;

1892:
1893: WHEN FND_API.G_EXC_ERROR THEN
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 );

Line 1908: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1904: FND_LOG.STRING(lc_excep_level, lc_mod_name,
1905: 'EXC_ERROR['||x_msg_data||']');
1906: END IF;
1907:
1908: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1909: ROLLBACK TO Delete_SC_Domain;
1910:
1911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1912:

Line 1911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1907:
1908: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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

Line 1938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1934:
1935: WHEN OTHERS THEN
1936: ROLLBACK TO Delete_SC_Domain;
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)

Line 2006: IF NOT FND_API.Compatible_API_Call (lc_api_version,

2002: -- Standard Start of API savepoint
2003: SAVEPOINT Lock_SC_Domain;
2004:
2005: -- Standard call to check for call compatibility.
2006: IF NOT FND_API.Compatible_API_Call (lc_api_version,
2007: p_api_version,
2008: lc_api_name ,
2009: G_PKG_NAME )
2010: THEN

Line 2011: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2007: p_api_version,
2008: lc_api_name ,
2009: G_PKG_NAME )
2010: THEN
2011: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 2015: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2011: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 2025: x_return_status := FND_API.G_RET_STS_SUCCESS;

2021: 'Entered Lock_SC_Domain');
2022: END IF;
2023:
2024: -- Initialize API return status to success
2025: x_return_status := FND_API.G_RET_STS_SUCCESS;
2026:
2027: -- Api body starts
2028:
2029: -- Check the required parameters

Line 2097: x_return_status := FND_API.G_RET_STS_ERROR;

2093: WHEN OTHERS THEN
2094: IF ( lc_excep_level >= lc_debug_level) THEN
2095: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_SC_DOMAINS_PKG.Lock_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
2096: END IF;
2097: x_return_status := FND_API.G_RET_STS_ERROR;
2098: END;
2099:
2100: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2101: RAISE FND_API.G_EXC_ERROR;

Line 2100: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2096: END IF;
2097: x_return_status := FND_API.G_RET_STS_ERROR;
2098: END;
2099:
2100: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2101: RAISE FND_API.G_EXC_ERROR;
2102: END IF;
2103:
2104: if (lc_proc_level >= lc_debug_level) then

Line 2101: RAISE FND_API.G_EXC_ERROR;

2097: x_return_status := FND_API.G_RET_STS_ERROR;
2098: END;
2099:
2100: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2101: RAISE FND_API.G_EXC_ERROR;
2102: END IF;
2103:
2104: if (lc_proc_level >= lc_debug_level) then
2105: FND_LOG.STRING(lc_proc_level, lc_mod_name,

Line 2112: IF FND_API.To_Boolean( p_commit ) THEN

2108:
2109: -- Api body ends here
2110:
2111: -- Standard check of p_commit.
2112: IF FND_API.To_Boolean( p_commit ) THEN
2113: COMMIT WORK;
2114: END IF;
2115:
2116: -- Standard call to get message count and IF count is get message info.

Line 2128: WHEN FND_API.G_EXC_ERROR THEN

2124: END IF;
2125:
2126: EXCEPTION
2127:
2128: WHEN FND_API.G_EXC_ERROR THEN
2129: ROLLBACK TO Lock_SC_Domain;
2130:
2131: x_return_status := FND_API.G_RET_STS_ERROR;
2132:

Line 2131: x_return_status := FND_API.G_RET_STS_ERROR;

2127:
2128: WHEN FND_API.G_EXC_ERROR THEN
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 );

Line 2143: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2139: FND_LOG.STRING(lc_excep_level, lc_mod_name,
2140: 'EXC_ERROR['||x_msg_data||']');
2141: END IF;
2142:
2143: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2144: ROLLBACK TO Lock_SC_Domain;
2145:
2146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2147:

Line 2146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2142:
2143: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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

Line 2173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2169:
2170: WHEN OTHERS THEN
2171: ROLLBACK TO Lock_SC_Domain;
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)