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.FEM_MIR_PKG dependencies on FND_API

Line 290: x_return_status := FND_API.G_RET_STS_SUCCESS;

286: ,p_module => c_module_pkg||'.'||l_api_name
287: ,p_msg_text => 'Begining Function'
288: );
289:
290: x_return_status := FND_API.G_RET_STS_SUCCESS;
291:
292: SELECT A.DIMENSION_GROUP_ID
293: INTO l_dimension_group_id
294: FROM fem_dimension_grps_b A,

Line 327: x_return_status := FND_API.G_RET_STS_ERROR;

323: ,p_token2 => 'DISPLAY_CODE'
324: ,p_value2 => p_dim_group_display_code
325: );
326:
327: x_return_status := FND_API.G_RET_STS_ERROR;
328: RETURN l_dimension_group_id;
329:
330: WHEN TOO_MANY_ROWS THEN
331: FEM_ENGINES_PKG.Tech_Message (

Line 347: x_return_status := FND_API.G_RET_STS_ERROR;

343: ,p_token2 => 'DISPLAY_CODE'
344: ,p_value2 => p_dim_group_display_code
345: );
346:
347: x_return_status := FND_API.G_RET_STS_ERROR;
348: RETURN l_dimension_group_id;
349:
350: WHEN OTHERS THEN
351:

Line 360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

356: ,p_module => c_module_pkg||'.'||l_api_name
357: ,p_msg_text => l_prg_msg
358: );
359:
360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
361: RETURN l_dimension_group_id;
362:
363: END Get_Dim_Group_Id;
364:

Line 402: x_return_status := FND_API.G_RET_STS_SUCCESS;

398: ,p_module => c_module_pkg||'.'||l_api_name
399: ,p_msg_text => 'Begining Function'
400: );
401:
402: x_return_status := FND_API.G_RET_STS_SUCCESS;
403:
404: SELECT A.DIMENSION_GROUP_ID
405: INTO l_dimension_group_id
406: FROM fem_dimension_grps_b A,

Line 439: x_return_status := FND_API.G_RET_STS_ERROR;

435: ,p_token2 => 'DISPLAY_CODE'
436: ,p_value2 => p_dim_group_display_code
437: );
438:
439: x_return_status := FND_API.G_RET_STS_ERROR;
440: RETURN l_dimension_group_id;
441:
442: WHEN TOO_MANY_ROWS THEN
443: FEM_ENGINES_PKG.Tech_Message (

Line 459: x_return_status := FND_API.G_RET_STS_ERROR;

455: ,p_token2 => 'DISPLAY_CODE'
456: ,p_value2 => p_dim_group_display_code
457: );
458:
459: x_return_status := FND_API.G_RET_STS_ERROR;
460: RETURN l_dimension_group_id;
461:
462: WHEN OTHERS THEN
463:

Line 472: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

468: ,p_module => c_module_pkg||'.'||l_api_name
469: ,p_msg_text => l_prg_msg
470: );
471:
472: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
473: RETURN l_dimension_group_id;
474:
475: END Get_Dim_Group_Id;
476:

Line 519: x_return_status := FND_API.G_RET_STS_SUCCESS;

515: ,p_module => c_module_pkg||'.'||l_api_name
516: ,p_msg_text => 'Begining Function'
517: );
518:
519: x_return_status := FND_API.G_RET_STS_SUCCESS;
520:
521: SELECT B.DIMENSION_GROUP_DISPLAY_CODE
522: INTO l_dim_group_display_code
523: FROM fem_object_catalog_vl A,

Line 564: x_return_status := FND_API.G_RET_STS_ERROR;

560: ,p_token3 => 'HIERARCHY'
561: ,p_value3 => p_hierarchy_name
562: );
563:
564: x_return_status := FND_API.G_RET_STS_ERROR;
565: RETURN l_hier_dim_grp_exists;
566:
567: WHEN TOO_MANY_ROWS THEN
568:

Line 576: x_return_status := FND_API.G_RET_STS_ERROR;

572: ,p_msg_text => 'More than 1 dim group display code exists with '||
573: 'given hierarchy and dimension '
574: );
575:
576: x_return_status := FND_API.G_RET_STS_ERROR;
577: RETURN l_hier_dim_grp_exists;
578:
579: WHEN OTHERS THEN
580:

Line 588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

584: p_severity => c_log_level_6
585: ,p_module => c_module_pkg||'.'||l_api_name
586: ,p_msg_text => l_prg_msg
587: );
588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
589: RETURN l_hier_dim_grp_exists;
590:
591: END Hier_Dim_Grp_Exists;
592:

Line 695: x_return_status := FND_API.G_RET_STS_ERROR;

691: ,p_token3 => 'HIERARCHY'
692: ,p_value3 => p_hierarchy_name
693: );
694:
695: x_return_status := FND_API.G_RET_STS_ERROR;
696: RETURN l_val_hier_dim_grps_order;
697:
698: WHEN TOO_MANY_ROWS THEN
699:

Line 706: x_return_status := FND_API.G_RET_STS_ERROR;

702: ,p_module => c_module_pkg||'.'||l_api_name
703: ,p_msg_text => 'More than 1 row returned for the given main query'
704: );
705:
706: x_return_status := FND_API.G_RET_STS_ERROR;
707: RETURN l_val_hier_dim_grps_order;
708:
709: WHEN OTHERS THEN
710:

Line 718: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

714: p_severity => c_log_level_6
715: ,p_module => c_module_pkg||'.'||l_api_name
716: ,p_msg_text => l_prg_msg
717: );
718: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
719: RETURN l_val_hier_dim_grps_order;
720:
721: END;
722:

Line 836: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

832:
833:
834: FUNCTION Get_Dim_Attribute_ID (
835: p_api_version IN NUMBER DEFAULT 1.0
836: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
837: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
838: ,p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE
839: ,x_return_status OUT NOCOPY VARCHAR2
840: ,x_msg_count OUT NOCOPY NUMBER

Line 837: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

833:
834: FUNCTION Get_Dim_Attribute_ID (
835: p_api_version IN NUMBER DEFAULT 1.0
836: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
837: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
838: ,p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE
839: ,x_return_status OUT NOCOPY VARCHAR2
840: ,x_msg_count OUT NOCOPY NUMBER
841: ,x_msg_data OUT NOCOPY VARCHAR2

Line 838: ,p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE

834: FUNCTION Get_Dim_Attribute_ID (
835: p_api_version IN NUMBER DEFAULT 1.0
836: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
837: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
838: ,p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE
839: ,x_return_status OUT NOCOPY VARCHAR2
840: ,x_msg_count OUT NOCOPY NUMBER
841: ,x_msg_data OUT NOCOPY VARCHAR2
842: ,p_dimension_varchar_label IN VARCHAR2

Line 860: x_return_status := FND_API.G_RET_STS_SUCCESS;

856: ,p_module => c_module_pkg||'.'||l_api_name
857: ,p_msg_text => 'Begining Function'
858: );
859:
860: x_return_status := FND_API.G_RET_STS_SUCCESS;
861:
862: SELECT B.attribute_id
863: INTO l_dim_attribute_id
864: FROM fem_dimensions_b A,

Line 898: x_return_status := FND_API.G_RET_STS_ERROR;

894: ,p_token2 => 'DISPLAY_CODE'
895: ,p_value2 => p_dim_attribute_varchar_label
896: );
897:
898: x_return_status := FND_API.G_RET_STS_ERROR;
899: RETURN l_dim_attribute_id;
900:
901: WHEN TOO_MANY_ROWS THEN
902:

Line 919: x_return_status := FND_API.G_RET_STS_ERROR;

915: ,p_token2 => 'DISPLAY_CODE'
916: ,p_value2 => p_dim_attribute_varchar_label
917: );
918:
919: x_return_status := FND_API.G_RET_STS_ERROR;
920: RETURN l_dim_attribute_id;
921:
922: WHEN OTHERS THEN
923:

Line 931: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

927: p_severity => c_log_level_6
928: ,p_module => c_module_pkg||'.'||l_api_name
929: ,p_msg_text => l_prg_msg
930: );
931: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
932: RETURN l_dim_attribute_id;
933:
934: END Get_Dim_Attribute_ID;
935:

Line 949: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

945: +============================================================================*/
946:
947: FUNCTION Get_Dim_Attribute_ID (
948: p_api_version IN NUMBER DEFAULT 1.0
949: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
950: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
951: ,p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE
952: ,x_return_status OUT NOCOPY VARCHAR2
953: ,x_msg_count OUT NOCOPY NUMBER

Line 950: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

946:
947: FUNCTION Get_Dim_Attribute_ID (
948: p_api_version IN NUMBER DEFAULT 1.0
949: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
950: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
951: ,p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE
952: ,x_return_status OUT NOCOPY VARCHAR2
953: ,x_msg_count OUT NOCOPY NUMBER
954: ,x_msg_data OUT NOCOPY VARCHAR2

Line 951: ,p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE

947: FUNCTION Get_Dim_Attribute_ID (
948: p_api_version IN NUMBER DEFAULT 1.0
949: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
950: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
951: ,p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE
952: ,x_return_status OUT NOCOPY VARCHAR2
953: ,x_msg_count OUT NOCOPY NUMBER
954: ,x_msg_data OUT NOCOPY VARCHAR2
955: ,p_dimension_id IN NUMBER

Line 973: x_return_status := FND_API.G_RET_STS_SUCCESS;

969: ,p_module => c_module_pkg||'.'||l_api_name
970: ,p_msg_text => 'Begining Function'
971: );
972:
973: x_return_status := FND_API.G_RET_STS_SUCCESS;
974:
975: SELECT attribute_id
976: INTO l_dim_attribute_id
977: FROM fem_dim_attributes_b

Line 1009: x_return_status := FND_API.G_RET_STS_ERROR;

1005: ,p_token2 => 'DISPLAY_CODE'
1006: ,p_value2 => p_dim_attribute_varchar_label
1007: );
1008:
1009: x_return_status := FND_API.G_RET_STS_ERROR;
1010: RETURN l_dim_attribute_id;
1011:
1012: WHEN TOO_MANY_ROWS THEN
1013:

Line 1030: x_return_status := FND_API.G_RET_STS_ERROR;

1026: ,p_token2 => 'DISPLAY_CODE'
1027: ,p_value2 => p_dim_attribute_varchar_label
1028: );
1029:
1030: x_return_status := FND_API.G_RET_STS_ERROR;
1031: RETURN l_dim_attribute_id;
1032:
1033: WHEN OTHERS THEN
1034:

Line 1042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1038: p_severity => c_log_level_6
1039: ,p_module => c_module_pkg||'.'||l_api_name
1040: ,p_msg_text => l_prg_msg
1041: );
1042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1043: RETURN l_dim_attribute_id;
1044:
1045: END Get_Dim_Attribute_ID;
1046:

Line 1263: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

1259: +============================================================================*/
1260:
1261: FUNCTION Get_Dim_Attr_Version_ID (
1262: p_api_version IN NUMBER DEFAULT 1.0
1263: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
1264: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
1265: ,p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE
1266: ,x_return_status OUT NOCOPY VARCHAR2
1267: ,x_msg_count OUT NOCOPY NUMBER

Line 1264: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

1260:
1261: FUNCTION Get_Dim_Attr_Version_ID (
1262: p_api_version IN NUMBER DEFAULT 1.0
1263: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
1264: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
1265: ,p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE
1266: ,x_return_status OUT NOCOPY VARCHAR2
1267: ,x_msg_count OUT NOCOPY NUMBER
1268: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1265: ,p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE

1261: FUNCTION Get_Dim_Attr_Version_ID (
1262: p_api_version IN NUMBER DEFAULT 1.0
1263: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
1264: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
1265: ,p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE
1266: ,x_return_status OUT NOCOPY VARCHAR2
1267: ,x_msg_count OUT NOCOPY NUMBER
1268: ,x_msg_data OUT NOCOPY VARCHAR2
1269: ,p_dim_attr_varchar_label IN VARCHAR2

Line 1287: x_return_status := FND_API.G_RET_STS_SUCCESS;

1283: ,p_module => c_module_pkg||'.'||l_api_name
1284: ,p_msg_text => 'Begining Function'
1285: );
1286:
1287: x_return_status := FND_API.G_RET_STS_SUCCESS;
1288:
1289: SELECT A.version_id
1290: INTO l_dim_attr_version_id
1291: FROM fem_dim_attr_versions_b A,

Line 1325: x_return_status := FND_API.G_RET_STS_ERROR;

1321: ,p_token2 => 'DISPLAY_CODE'
1322: ,p_value2 => p_dim_attr_ver_display_code
1323: );
1324:
1325: x_return_status := FND_API.G_RET_STS_ERROR;
1326: RETURN l_dim_attr_version_id;
1327:
1328: WHEN TOO_MANY_ROWS THEN
1329:

Line 1346: x_return_status := FND_API.G_RET_STS_ERROR;

1342: ,p_token2 => 'DISPLAY_CODE'
1343: ,p_value2 => p_dim_attr_ver_display_code
1344: );
1345:
1346: x_return_status := FND_API.G_RET_STS_ERROR;
1347: RETURN l_dim_attr_version_id;
1348:
1349: WHEN OTHERS THEN
1350:

Line 1358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1354: p_severity => c_log_level_6
1355: ,p_module => c_module_pkg||'.'||l_api_name
1356: ,p_msg_text => l_prg_msg
1357: );
1358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1359: RETURN l_dim_attr_version_id;
1360:
1361: END Get_Dim_Attr_Version_ID;
1362:

Line 1376: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

1372: +============================================================================*/
1373:
1374: FUNCTION Get_Dim_Attr_Version_ID (
1375: p_api_version IN NUMBER DEFAULT 1.0
1376: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
1377: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
1378: ,p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE
1379: ,x_return_status OUT NOCOPY VARCHAR2
1380: ,x_msg_count OUT NOCOPY NUMBER

Line 1377: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

1373:
1374: FUNCTION Get_Dim_Attr_Version_ID (
1375: p_api_version IN NUMBER DEFAULT 1.0
1376: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
1377: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
1378: ,p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE
1379: ,x_return_status OUT NOCOPY VARCHAR2
1380: ,x_msg_count OUT NOCOPY NUMBER
1381: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1378: ,p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE

1374: FUNCTION Get_Dim_Attr_Version_ID (
1375: p_api_version IN NUMBER DEFAULT 1.0
1376: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
1377: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
1378: ,p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE
1379: ,x_return_status OUT NOCOPY VARCHAR2
1380: ,x_msg_count OUT NOCOPY NUMBER
1381: ,x_msg_data OUT NOCOPY VARCHAR2
1382: ,p_dim_attribute_id IN NUMBER

Line 1400: x_return_status := FND_API.G_RET_STS_SUCCESS;

1396: ,p_module => c_module_pkg||'.'||l_api_name
1397: ,p_msg_text => 'Begining Function'
1398: );
1399:
1400: x_return_status := FND_API.G_RET_STS_SUCCESS;
1401:
1402: SELECT version_id
1403: INTO l_dim_attr_version_id
1404: FROM fem_dim_attr_versions_b

Line 1436: x_return_status := FND_API.G_RET_STS_ERROR;

1432: ,p_token2 => 'DISPLAY_CODE'
1433: ,p_value2 => p_dim_attr_ver_display_code
1434: );
1435:
1436: x_return_status := FND_API.G_RET_STS_ERROR;
1437: RETURN l_dim_attr_version_id;
1438:
1439: WHEN TOO_MANY_ROWS THEN
1440:

Line 1457: x_return_status := FND_API.G_RET_STS_ERROR;

1453: ,p_token2 => 'DISPLAY_CODE'
1454: ,p_value2 => p_dim_attr_ver_display_code
1455: );
1456:
1457: x_return_status := FND_API.G_RET_STS_ERROR;
1458: RETURN l_dim_attr_version_id;
1459:
1460: WHEN OTHERS THEN
1461:

Line 1469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1465: p_severity => c_log_level_6
1466: ,p_module => c_module_pkg||'.'||l_api_name
1467: ,p_msg_text => l_prg_msg
1468: );
1469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1470: RETURN l_dim_attr_version_id;
1471:
1472: END Get_Dim_Attr_Version_ID;
1473:

Line 1697: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

1693: +============================================================================*/
1694:
1695: FUNCTION Get_Dim_Member_ID (
1696: p_api_version IN NUMBER DEFAULT 1.0
1697: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
1698: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
1699: ,p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE
1700: ,x_return_status OUT NOCOPY VARCHAR2
1701: ,x_msg_count OUT NOCOPY NUMBER

Line 1698: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

1694:
1695: FUNCTION Get_Dim_Member_ID (
1696: p_api_version IN NUMBER DEFAULT 1.0
1697: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
1698: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
1699: ,p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE
1700: ,x_return_status OUT NOCOPY VARCHAR2
1701: ,x_msg_count OUT NOCOPY NUMBER
1702: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1699: ,p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE

1695: FUNCTION Get_Dim_Member_ID (
1696: p_api_version IN NUMBER DEFAULT 1.0
1697: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
1698: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
1699: ,p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE
1700: ,x_return_status OUT NOCOPY VARCHAR2
1701: ,x_msg_count OUT NOCOPY NUMBER
1702: ,x_msg_data OUT NOCOPY VARCHAR2
1703: ,p_dimension_varchar_label IN VARCHAR2

Line 1725: x_return_status := FND_API.G_RET_STS_SUCCESS;

1721: l_member_id := -1;
1722: l_value_set_id := NULL;
1723: l_value_set_display_code := NULL;
1724:
1725: x_return_status := FND_API.G_RET_STS_SUCCESS;
1726:
1727: FEM_ENGINES_PKG.Tech_Message (
1728: p_severity => c_log_level_2
1729: ,p_module => c_module_pkg||'.'||l_api_name

Line 1809: x_return_status := FND_API.G_RET_STS_ERROR;

1805: ,p_token1 => 'API_NAME'
1806: ,p_value1 => l_api_name
1807: );
1808:
1809: x_return_status := FND_API.G_RET_STS_ERROR;
1810: RETURN l_member_id;
1811:
1812: WHEN TOO_MANY_ROWS THEN
1813:

Line 1821: x_return_status := FND_API.G_RET_STS_ERROR;

1817: ,p_msg_text => 'Value Set ID returned more than 1 '||
1818: 'Value Set display code or Vice Versa'
1819: );
1820:
1821: x_return_status := FND_API.G_RET_STS_ERROR;
1822: RETURN l_member_id;
1823:
1824: WHEN OTHERS THEN
1825:

Line 1834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1830: ,p_module => c_module_pkg||'.'||l_api_name
1831: ,p_msg_text => l_prg_msg
1832: );
1833:
1834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1835: RETURN l_member_id;
1836:
1837: END Get_Dim_Member_ID;
1838:

Line 1852: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

1848: +============================================================================*/
1849:
1850: FUNCTION Get_Dim_Member_ID (
1851: p_api_version IN NUMBER DEFAULT 1.0
1852: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
1853: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
1854: ,p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE
1855: ,x_return_status OUT NOCOPY VARCHAR2
1856: ,x_msg_count OUT NOCOPY NUMBER

Line 1853: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

1849:
1850: FUNCTION Get_Dim_Member_ID (
1851: p_api_version IN NUMBER DEFAULT 1.0
1852: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
1853: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
1854: ,p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE
1855: ,x_return_status OUT NOCOPY VARCHAR2
1856: ,x_msg_count OUT NOCOPY NUMBER
1857: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1854: ,p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE

1850: FUNCTION Get_Dim_Member_ID (
1851: p_api_version IN NUMBER DEFAULT 1.0
1852: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
1853: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
1854: ,p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE
1855: ,x_return_status OUT NOCOPY VARCHAR2
1856: ,x_msg_count OUT NOCOPY NUMBER
1857: ,x_msg_data OUT NOCOPY VARCHAR2
1858: ,p_dimension_id IN NUMBER

Line 1885: x_return_status := FND_API.G_RET_STS_SUCCESS;

1881: l_member_id := -1;
1882: l_value_set_id := NULL;
1883: l_value_set_display_code := NULL;
1884:
1885: x_return_status := FND_API.G_RET_STS_SUCCESS;
1886:
1887: FEM_ENGINES_PKG.Tech_Message (
1888: p_severity => c_log_level_2
1889: ,p_module => c_module_pkg||'.'||l_api_name

Line 2008: x_return_status := FND_API.G_RET_STS_ERROR;

2004: ,p_token2 => 'DISPLAY_ID'
2005: ,p_value2 => p_dimension_id
2006: );
2007:
2008: x_return_status := FND_API.G_RET_STS_ERROR;
2009: RETURN l_member_id;
2010:
2011: WHEN e_bad_vs_id THEN
2012:

Line 2028: x_return_status := FND_API.G_RET_STS_ERROR;

2024: ,p_token2 => 'DISPLAY_ID'
2025: ,p_value2 => l_value_set_id
2026: );
2027:
2028: x_return_status := FND_API.G_RET_STS_ERROR;
2029: RETURN l_member_id;
2030:
2031: WHEN e_bad_vs_dim_id THEN
2032:

Line 2049: x_return_status := FND_API.G_RET_STS_ERROR;

2045: ,p_token2 => 'DIMENSION'
2046: ,p_value2 => p_dimension_id
2047: );
2048:
2049: x_return_status := FND_API.G_RET_STS_ERROR;
2050: RETURN l_member_id;
2051:
2052: WHEN e_too_many_vs_codes THEN
2053:

Line 2061: x_return_status := FND_API.G_RET_STS_ERROR;

2057: ,p_msg_text => 'Value Set ID returned more than 1 '||
2058: 'Value Set display code '
2059: );
2060:
2061: x_return_status := FND_API.G_RET_STS_ERROR;
2062: RETURN l_member_id;
2063:
2064: WHEN OTHERS THEN
2065:

Line 2073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2069: p_severity => c_log_level_6
2070: ,p_module => c_module_pkg||'.'||l_api_name
2071: ,p_msg_text => l_prg_msg
2072: );
2073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2074: RETURN l_member_id;
2075:
2076: END Get_Dim_Member_ID;
2077:

Line 2189: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

2185: +============================================================================*/
2186:
2187: FUNCTION Get_Value_Set_ID (
2188: p_api_version IN NUMBER DEFAULT 1.0
2189: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2190: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2191: ,p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE
2192: ,x_return_status OUT NOCOPY VARCHAR2
2193: ,x_msg_count OUT NOCOPY NUMBER

Line 2190: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

2186:
2187: FUNCTION Get_Value_Set_ID (
2188: p_api_version IN NUMBER DEFAULT 1.0
2189: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2190: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2191: ,p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE
2192: ,x_return_status OUT NOCOPY VARCHAR2
2193: ,x_msg_count OUT NOCOPY NUMBER
2194: ,x_msg_data OUT NOCOPY VARCHAR2

Line 2191: ,p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE

2187: FUNCTION Get_Value_Set_ID (
2188: p_api_version IN NUMBER DEFAULT 1.0
2189: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2190: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2191: ,p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE
2192: ,x_return_status OUT NOCOPY VARCHAR2
2193: ,x_msg_count OUT NOCOPY NUMBER
2194: ,x_msg_data OUT NOCOPY VARCHAR2
2195: ,p_value_set_display_code IN VARCHAR2

Line 2205: x_return_status := FND_API.G_RET_STS_SUCCESS;

2201: l_prg_msg VARCHAR2(2000);
2202:
2203: BEGIN
2204:
2205: x_return_status := FND_API.G_RET_STS_SUCCESS;
2206:
2207: FEM_ENGINES_PKG.Tech_Message (
2208: p_severity => c_log_level_2
2209: ,p_module => c_module_pkg||'.'||l_api_name

Line 2246: x_return_status := FND_API.G_RET_STS_ERROR;

2242: ,p_token2 => 'DISPLAY_CODE'
2243: ,p_value2 => p_value_set_display_code
2244: );
2245:
2246: x_return_status := FND_API.G_RET_STS_ERROR;
2247:
2248: RETURN l_value_set_id;
2249:
2250: WHEN TOO_MANY_ROWS THEN

Line 2267: x_return_status := FND_API.G_RET_STS_ERROR;

2263: ,p_token2 => 'DISPLAY_CODE'
2264: ,p_value2 => p_value_set_display_code
2265: );
2266:
2267: x_return_status := FND_API.G_RET_STS_ERROR;
2268:
2269: RETURN l_value_set_id;
2270:
2271: WHEN OTHERS THEN

Line 2281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2277: ,p_module => c_module_pkg||'.'||l_api_name
2278: ,p_msg_text => l_prg_msg
2279: );
2280:
2281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2282:
2283: RETURN l_value_set_id;
2284:
2285: END Get_Value_Set_ID;

Line 2493: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

2489: +============================================================================*/
2490:
2491: FUNCTION Get_Object_ID (
2492: p_api_version IN NUMBER DEFAULT 1.0
2493: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2494: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2495: ,p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE
2496: ,x_return_status OUT NOCOPY VARCHAR2
2497: ,x_msg_count OUT NOCOPY NUMBER

Line 2494: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

2490:
2491: FUNCTION Get_Object_ID (
2492: p_api_version IN NUMBER DEFAULT 1.0
2493: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2494: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2495: ,p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE
2496: ,x_return_status OUT NOCOPY VARCHAR2
2497: ,x_msg_count OUT NOCOPY NUMBER
2498: ,x_msg_data OUT NOCOPY VARCHAR2

Line 2495: ,p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE

2491: FUNCTION Get_Object_ID (
2492: p_api_version IN NUMBER DEFAULT 1.0
2493: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2494: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2495: ,p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE
2496: ,x_return_status OUT NOCOPY VARCHAR2
2497: ,x_msg_count OUT NOCOPY NUMBER
2498: ,x_msg_data OUT NOCOPY VARCHAR2
2499: ,p_object_def_id IN NUMBER

Line 2509: x_return_status := FND_API.G_RET_STS_SUCCESS;

2505: l_prg_msg VARCHAR2(2000);
2506:
2507: BEGIN
2508:
2509: x_return_status := FND_API.G_RET_STS_SUCCESS;
2510:
2511: FEM_ENGINES_PKG.Tech_Message (
2512: p_severity => c_log_level_2
2513: ,p_module => c_module_pkg||'.'||l_api_name

Line 2548: x_return_status := FND_API.G_RET_STS_ERROR;

2544: ,p_value1 => l_api_name
2545: ,p_token2 => 'OBJ_ID'
2546: ,p_value2 => p_object_def_id
2547: );
2548: x_return_status := FND_API.G_RET_STS_ERROR;
2549:
2550: RETURN l_object_id;
2551:
2552: WHEN TOO_MANY_ROWS THEN

Line 2560: x_return_status := FND_API.G_RET_STS_ERROR;

2556: ,p_msg_text => 'Object Def ID returned more than 1 '||
2557: 'Objects ID'
2558: );
2559:
2560: x_return_status := FND_API.G_RET_STS_ERROR;
2561:
2562: RETURN l_object_id;
2563:
2564: WHEN OTHERS THEN

Line 2574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2570: ,p_module => c_module_pkg||'.'||l_api_name
2571: ,p_msg_text => l_prg_msg
2572: );
2573:
2574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2575:
2576: RETURN l_object_id;
2577:
2578: END Get_Object_ID;

Line 2593: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

2589: +============================================================================*/
2590:
2591: FUNCTION Get_Dimension_Id(
2592: p_api_version IN NUMBER DEFAULT 1.0
2593: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2594: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2595: ,p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE
2596: ,x_return_status OUT NOCOPY VARCHAR2
2597: ,x_msg_count OUT NOCOPY NUMBER

Line 2594: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

2590:
2591: FUNCTION Get_Dimension_Id(
2592: p_api_version IN NUMBER DEFAULT 1.0
2593: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2594: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2595: ,p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE
2596: ,x_return_status OUT NOCOPY VARCHAR2
2597: ,x_msg_count OUT NOCOPY NUMBER
2598: ,x_msg_data OUT NOCOPY VARCHAR2

Line 2595: ,p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE

2591: FUNCTION Get_Dimension_Id(
2592: p_api_version IN NUMBER DEFAULT 1.0
2593: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2594: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2595: ,p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE
2596: ,x_return_status OUT NOCOPY VARCHAR2
2597: ,x_msg_count OUT NOCOPY NUMBER
2598: ,x_msg_data OUT NOCOPY VARCHAR2
2599: ,p_dimension_varchar_label IN VARCHAR2

Line 2615: x_return_status := FND_API.G_RET_STS_SUCCESS;

2611: p_severity => c_log_level_2
2612: ,p_module => c_module_pkg||'.'||l_api_name
2613: ,p_msg_text => 'Begining Function'
2614: );
2615: x_return_status := FND_API.G_RET_STS_SUCCESS;
2616:
2617: SELECT dimension_id
2618: INTO l_dimension_id
2619: FROM fem_dimensions_vl

Line 2628: x_return_status := FND_API.G_RET_STS_SUCCESS;

2624: ,p_module => c_module_pkg||'.'||l_api_name
2625: ,p_msg_text => 'Ending Function'
2626: );
2627:
2628: x_return_status := FND_API.G_RET_STS_SUCCESS;
2629:
2630: RETURN l_dimension_id;
2631:
2632: EXCEPTION

Line 2643: x_return_status := FND_API.G_RET_STS_ERROR;

2639: p_severity => c_log_level_6
2640: ,p_module => c_module_pkg||'.'||l_api_name
2641: ,p_msg_text => l_prg_msg
2642: );
2643: x_return_status := FND_API.G_RET_STS_ERROR;
2644: RETURN l_dimension_id;
2645:
2646: END Get_Dimension_Id;
2647: