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

Line 1823: IF g_TXN_SOURCE_TYPE_CODE_sqltab(i) = fnd_api.g_miss_char Then

1819: FOR i IN g_TXN_SOURCE_ID_sqlTab.FIRST .. g_TXN_SOURCE_ID_sqlTab.LAST LOOP
1820: If NOT g_TXN_SOURCE_TYPE_CODE_sqltab.EXISTS(i) Then
1821: g_TXN_SOURCE_TYPE_CODE_sqltab(i) := null;
1822: Else
1823: IF g_TXN_SOURCE_TYPE_CODE_sqltab(i) = fnd_api.g_miss_char Then
1824: g_TXN_SOURCE_TYPE_CODE_sqltab(i) := null;
1825: End If;
1826: End If;
1827: If NOT g_PERSON_ID_sqltab.EXISTS(i) Then

Line 1830: IF g_PERSON_ID_sqltab(i) = fnd_api.g_miss_num Then

1826: End If;
1827: If NOT g_PERSON_ID_sqltab.EXISTS(i) Then
1828: g_PERSON_ID_sqltab(i) := null;
1829: Else
1830: IF g_PERSON_ID_sqltab(i) = fnd_api.g_miss_num Then
1831: g_PERSON_ID_sqltab(i) := null;
1832: End If;
1833: End If;
1834: If NOT g_JOB_ID_sqltab.EXISTS(i) Then

Line 1837: IF g_JOB_ID_sqltab(i) = fnd_api.g_miss_num Then

1833: End If;
1834: If NOT g_JOB_ID_sqltab.EXISTS(i) Then
1835: g_JOB_ID_sqltab(i) := null;
1836: Else
1837: IF g_JOB_ID_sqltab(i) = fnd_api.g_miss_num Then
1838: g_JOB_ID_sqltab(i) := null;
1839: End If;
1840: End If;
1841: If NOT g_ORGANIZATION_ID_sqltab.EXISTS(i) Then

Line 1844: If g_ORGANIZATION_ID_sqltab(i) = fnd_api.g_miss_num Then

1840: End If;
1841: If NOT g_ORGANIZATION_ID_sqltab.EXISTS(i) Then
1842: g_ORGANIZATION_ID_sqltab(i) := null;
1843: Else
1844: If g_ORGANIZATION_ID_sqltab(i) = fnd_api.g_miss_num Then
1845: g_ORGANIZATION_ID_sqltab(i) := null;
1846: End If;
1847: End If;
1848: If NOT g_VENDOR_ID_sqltab.EXISTS(i) Then

Line 1851: IF g_VENDOR_ID_sqltab(i) = fnd_api.g_miss_num Then

1847: End If;
1848: If NOT g_VENDOR_ID_sqltab.EXISTS(i) Then
1849: g_VENDOR_ID_sqltab(i) := null;
1850: Else
1851: IF g_VENDOR_ID_sqltab(i) = fnd_api.g_miss_num Then
1852: g_VENDOR_ID_sqltab(i) := null;
1853: End If;
1854: End If;
1855: If NOT g_EXPENDITURE_TYPE_sqltab.EXISTS(i) Then

Line 1858: If g_EXPENDITURE_TYPE_sqltab(i) = fnd_api.g_miss_char Then

1854: End If;
1855: If NOT g_EXPENDITURE_TYPE_sqltab.EXISTS(i) Then
1856: g_EXPENDITURE_TYPE_sqltab(i) := null;
1857: Else
1858: If g_EXPENDITURE_TYPE_sqltab(i) = fnd_api.g_miss_char Then
1859: g_EXPENDITURE_TYPE_sqltab(i) := null;
1860: End If;
1861: End If;
1862: If NOT g_EVENT_TYPE_sqltab.EXISTS(i) Then

Line 1865: If g_EVENT_TYPE_sqltab(i) = fnd_api.g_miss_char Then

1861: End If;
1862: If NOT g_EVENT_TYPE_sqltab.EXISTS(i) Then
1863: g_EVENT_TYPE_sqltab(i) := null;
1864: Else
1865: If g_EVENT_TYPE_sqltab(i) = fnd_api.g_miss_char Then
1866: g_EVENT_TYPE_sqltab(i) := null;
1867: End If;
1868: End If;
1869: If NOT g_NON_LABOR_RESOURCE_sqltab.EXISTS(i) Then

Line 1872: IF g_NON_LABOR_RESOURCE_sqltab(i) = fnd_api.g_miss_char Then

1868: End If;
1869: If NOT g_NON_LABOR_RESOURCE_sqltab.EXISTS(i) Then
1870: g_NON_LABOR_RESOURCE_sqltab(i) := null;
1871: Else
1872: IF g_NON_LABOR_RESOURCE_sqltab(i) = fnd_api.g_miss_char Then
1873: g_NON_LABOR_RESOURCE_sqltab(i) := null;
1874: End If;
1875: End If;
1876: If NOT g_EXPENDITURE_CATEGORY_sqltab.EXISTS(i) Then

Line 1879: IF g_EXPENDITURE_CATEGORY_sqltab(i) = fnd_api.g_miss_char Then

1875: End If;
1876: If NOT g_EXPENDITURE_CATEGORY_sqltab.EXISTS(i) Then
1877: g_EXPENDITURE_CATEGORY_sqltab(i) := null;
1878: Else
1879: IF g_EXPENDITURE_CATEGORY_sqltab(i) = fnd_api.g_miss_char Then
1880: g_EXPENDITURE_CATEGORY_sqltab(i) := null;
1881: End If;
1882: End If;
1883: If NOT g_REVENUE_CATEGORY_CODE_sqltab.EXISTS(i) Then

Line 1886: IF g_REVENUE_CATEGORY_CODE_sqltab(i) = fnd_api.g_miss_char Then

1882: End If;
1883: If NOT g_REVENUE_CATEGORY_CODE_sqltab.EXISTS(i) Then
1884: g_REVENUE_CATEGORY_CODE_sqltab(i) := null;
1885: Else
1886: IF g_REVENUE_CATEGORY_CODE_sqltab(i) = fnd_api.g_miss_char Then
1887: g_REVENUE_CATEGORY_CODE_sqltab(i) := null;
1888: End If;
1889: End If;
1890: If NOT g_NLR_ORGANIZATION_ID_sqltab.EXISTS(i) Then

Line 1893: If g_NLR_ORGANIZATION_ID_sqltab(i) = fnd_api.g_miss_num Then

1889: End If;
1890: If NOT g_NLR_ORGANIZATION_ID_sqltab.EXISTS(i) Then
1891: g_NLR_ORGANIZATION_ID_sqltab(i) := null;
1892: Else
1893: If g_NLR_ORGANIZATION_ID_sqltab(i) = fnd_api.g_miss_num Then
1894: g_NLR_ORGANIZATION_ID_sqltab(i) := null;
1895: End If;
1896: End If;
1897: If NOT g_EVENT_CLASSIFICATION_sqltab.EXISTS(i) Then

Line 1900: IF g_EVENT_CLASSIFICATION_sqltab(i) = fnd_api.g_miss_char Then

1896: End If;
1897: If NOT g_EVENT_CLASSIFICATION_sqltab.EXISTS(i) Then
1898: g_EVENT_CLASSIFICATION_sqltab(i) := null;
1899: Else
1900: IF g_EVENT_CLASSIFICATION_sqltab(i) = fnd_api.g_miss_char Then
1901: g_EVENT_CLASSIFICATION_sqltab(i) := null;
1902: End If;
1903: End If;
1904: If NOT g_SYS_LINK_FUNCTION_sqltab.EXISTS(i) Then

Line 1907: IF g_SYS_LINK_FUNCTION_sqltab(i) = fnd_api.g_miss_char Then

1903: End If;
1904: If NOT g_SYS_LINK_FUNCTION_sqltab.EXISTS(i) Then
1905: g_SYS_LINK_FUNCTION_sqltab(i) := null;
1906: Else
1907: IF g_SYS_LINK_FUNCTION_sqltab(i) = fnd_api.g_miss_char Then
1908: g_SYS_LINK_FUNCTION_sqltab(i) := null;
1909: End If;
1910: End If;
1911: If NOT g_PROJECT_ROLE_ID_sqltab.EXISTS(i) Then

Line 1914: IF g_PROJECT_ROLE_ID_sqltab(i) = fnd_api.g_miss_num Then

1910: End If;
1911: If NOT g_PROJECT_ROLE_ID_sqltab.EXISTS(i) Then
1912: g_PROJECT_ROLE_ID_sqltab(i) := null;
1913: Else
1914: IF g_PROJECT_ROLE_ID_sqltab(i) = fnd_api.g_miss_num Then
1915: g_PROJECT_ROLE_ID_sqltab(i) := null;
1916: End If;
1917: End If;
1918: If NOT g_RESOURCE_CLASS_CODE_sqltab.EXISTS(i) Then

Line 1921: IF g_RESOURCE_CLASS_CODE_sqltab(i) = fnd_api.g_miss_char Then

1917: End If;
1918: If NOT g_RESOURCE_CLASS_CODE_sqltab.EXISTS(i) Then
1919: g_RESOURCE_CLASS_CODE_sqltab(i) := null;
1920: Else
1921: IF g_RESOURCE_CLASS_CODE_sqltab(i) = fnd_api.g_miss_char Then
1922: g_RESOURCE_CLASS_CODE_sqltab(i) := null;
1923: End If;
1924: End If;
1925: IF NOT g_MFC_COST_TYPE_ID_sqltab.EXISTS(i) Then

Line 1928: IF g_MFC_COST_TYPE_ID_sqltab(i) = fnd_api.g_miss_num Then

1924: End If;
1925: IF NOT g_MFC_COST_TYPE_ID_sqltab.EXISTS(i) Then
1926: g_MFC_COST_TYPE_ID_sqltab(i) := null;
1927: Else
1928: IF g_MFC_COST_TYPE_ID_sqltab(i) = fnd_api.g_miss_num Then
1929: g_MFC_COST_TYPE_ID_sqltab(i) := null;
1930: End If;
1931: End If;
1932: If NOT g_RESOURCE_CLASS_FLAG_sqltab.EXISTS(i) Then

Line 1935: If g_RESOURCE_CLASS_FLAG_sqltab(i) = fnd_api.g_miss_char Then

1931: End If;
1932: If NOT g_RESOURCE_CLASS_FLAG_sqltab.EXISTS(i) Then
1933: g_RESOURCE_CLASS_FLAG_sqltab(i) := null;
1934: Else
1935: If g_RESOURCE_CLASS_FLAG_sqltab(i) = fnd_api.g_miss_char Then
1936: g_RESOURCE_CLASS_FLAG_sqltab(i) := null;
1937: End If;
1938: End If;
1939: If NOT g_FC_RES_TYPE_CODE_sqltab.EXISTS(i) Then

Line 1942: IF g_FC_RES_TYPE_CODE_sqltab(i) = fnd_api.g_miss_char Then

1938: End If;
1939: If NOT g_FC_RES_TYPE_CODE_sqltab.EXISTS(i) Then
1940: g_FC_RES_TYPE_CODE_sqltab(i) := null;
1941: Else
1942: IF g_FC_RES_TYPE_CODE_sqltab(i) = fnd_api.g_miss_char Then
1943: g_FC_RES_TYPE_CODE_sqltab(i) := null;
1944: End If;
1945: End If;
1946: If NOT g_INVENTORY_ITEM_ID_sqltab.EXISTS(i) Then

Line 1949: IF g_INVENTORY_ITEM_ID_sqltab(i) = fnd_api.g_miss_num Then

1945: End If;
1946: If NOT g_INVENTORY_ITEM_ID_sqltab.EXISTS(i) Then
1947: g_INVENTORY_ITEM_ID_sqltab(i) := null;
1948: Else
1949: IF g_INVENTORY_ITEM_ID_sqltab(i) = fnd_api.g_miss_num Then
1950: g_INVENTORY_ITEM_ID_sqltab(i) := null;
1951: End If;
1952: End If;
1953: IF NOT g_ITEM_CATEGORY_ID_sqltab.EXISTS(i) Then

Line 1956: IF g_ITEM_CATEGORY_ID_sqltab(i) = fnd_api.g_miss_num Then

1952: End If;
1953: IF NOT g_ITEM_CATEGORY_ID_sqltab.EXISTS(i) Then
1954: g_ITEM_CATEGORY_ID_sqltab(i) := null;
1955: Else
1956: IF g_ITEM_CATEGORY_ID_sqltab(i) = fnd_api.g_miss_num Then
1957: g_ITEM_CATEGORY_ID_sqltab(i) := null;
1958: End If;
1959: End If;
1960: IF NOT g_PERSON_TYPE_CODE_sqltab.EXISTS(i) Then

Line 1963: IF g_PERSON_TYPE_CODE_sqltab(i) = fnd_api.g_miss_char Then

1959: End If;
1960: IF NOT g_PERSON_TYPE_CODE_sqltab.EXISTS(i) Then
1961: g_PERSON_TYPE_CODE_sqltab(i) := null;
1962: Else
1963: IF g_PERSON_TYPE_CODE_sqltab(i) = fnd_api.g_miss_char Then
1964: g_PERSON_TYPE_CODE_sqltab(i) := null;
1965: End if;
1966: End If;
1967: IF NOT g_BOM_RESOURCE_ID_sqltab.EXISTS(i) Then

Line 1970: IF g_BOM_RESOURCE_ID_sqltab(i) = fnd_api.g_miss_num Then

1966: End If;
1967: IF NOT g_BOM_RESOURCE_ID_sqltab.EXISTS(i) Then
1968: g_BOM_RESOURCE_ID_sqltab(i) := null;
1969: Else
1970: IF g_BOM_RESOURCE_ID_sqltab(i) = fnd_api.g_miss_num Then
1971: g_BOM_RESOURCE_ID_sqltab(i) := null;
1972: End IF;
1973: End IF;
1974: IF NOT g_NAMED_ROLE_sqltab.EXISTS(i) Then

Line 1977: IF g_NAMED_ROLE_sqltab(i) = fnd_api.g_miss_char Then

1973: End IF;
1974: IF NOT g_NAMED_ROLE_sqltab.EXISTS(i) Then
1975: g_NAMED_ROLE_sqltab(i) := null;
1976: Else
1977: IF g_NAMED_ROLE_sqltab(i) = fnd_api.g_miss_char Then
1978: g_NAMED_ROLE_sqltab(i) := null;
1979: End IF;
1980: End If;
1981: IF NOT g_INCURRED_BY_RES_FLAG_sqltab.EXISTS(i) Then

Line 1984: IF g_INCURRED_BY_RES_FLAG_sqltab(i) = fnd_api.g_miss_char Then

1980: End If;
1981: IF NOT g_INCURRED_BY_RES_FLAG_sqltab.EXISTS(i) Then
1982: g_INCURRED_BY_RES_FLAG_sqltab(i) := null;
1983: Else
1984: IF g_INCURRED_BY_RES_FLAG_sqltab(i) = fnd_api.g_miss_char Then
1985: g_INCURRED_BY_RES_FLAG_sqltab(i) := null;
1986: End IF;
1987: End If;
1988: IF NOT g_RATE_BASED_FLAG_sqltab.EXISTS(i) Then

Line 1991: IF g_RATE_BASED_FLAG_sqltab(i) = fnd_api.g_miss_char Then

1987: End If;
1988: IF NOT g_RATE_BASED_FLAG_sqltab.EXISTS(i) Then
1989: g_RATE_BASED_FLAG_sqltab(i) := null;
1990: Else
1991: IF g_RATE_BASED_FLAG_sqltab(i) = fnd_api.g_miss_char Then
1992: g_RATE_BASED_FLAG_sqltab(i) := null;
1993: End IF;
1994: End IF;
1995: If NOT g_TXN_TASK_ID_sqltab.EXISTS(i) Then

Line 1998: IF g_TXN_TASK_ID_sqltab(i) = fnd_api.g_miss_num Then

1994: End IF;
1995: If NOT g_TXN_TASK_ID_sqltab.EXISTS(i) Then
1996: g_TXN_TASK_ID_sqltab(i) := null;
1997: Else
1998: IF g_TXN_TASK_ID_sqltab(i) = fnd_api.g_miss_num Then
1999: g_TXN_TASK_ID_sqltab(i) := null;
2000: End IF;
2001: end if;
2002: If NOT g_TXN_WBS_ELE_VER_ID_sqltab.EXISTS(i) Then

Line 2005: IF g_TXN_WBS_ELE_VER_ID_sqltab(i) = fnd_api.g_miss_num Then

2001: end if;
2002: If NOT g_TXN_WBS_ELE_VER_ID_sqltab.EXISTS(i) Then
2003: g_TXN_WBS_ELE_VER_ID_sqltab(i) := null;
2004: Else
2005: IF g_TXN_WBS_ELE_VER_ID_sqltab(i) = fnd_api.g_miss_num Then
2006: g_TXN_WBS_ELE_VER_ID_sqltab(i) := null;
2007: End IF;
2008: End IF;
2009: IF NOT g_TXN_RBS_ELEMENT_ID_sqltab.EXISTS(i) Then

Line 2012: IF g_TXN_RBS_ELEMENT_ID_sqltab(i) = fnd_api.g_miss_num Then

2008: End IF;
2009: IF NOT g_TXN_RBS_ELEMENT_ID_sqltab.EXISTS(i) Then
2010: g_TXN_RBS_ELEMENT_ID_sqltab(i) := null;
2011: Else
2012: IF g_TXN_RBS_ELEMENT_ID_sqltab(i) = fnd_api.g_miss_num Then
2013: g_TXN_RBS_ELEMENT_ID_sqltab(i) := null;
2014: End IF;
2015: End IF;
2016:

Line 2022: IF g_CBS_ELEMENT_ID_sqltab(i) = fnd_api.g_miss_num Then

2018: IF NOT g_CBS_ELEMENT_ID_sqltab.EXISTS(i) Then
2019: g_CBS_ELEMENT_ID_sqltab(i) := null;
2020: Else
2021:
2022: IF g_CBS_ELEMENT_ID_sqltab(i) = fnd_api.g_miss_num Then
2023: g_CBS_ELEMENT_ID_sqltab(i) := null;
2024: End IF;
2025: End IF;
2026:

Line 2032: IF g_TXN_PLAN_START_DATE_sqltab(i) = fnd_api.g_miss_date Then

2028:
2029: If NOT g_TXN_PLAN_START_DATE_sqltab.EXISTS(i) Then
2030: g_TXN_PLAN_START_DATE_sqltab(i) := null;
2031: Else
2032: IF g_TXN_PLAN_START_DATE_sqltab(i) = fnd_api.g_miss_date Then
2033: g_TXN_PLAN_START_DATE_sqltab(i) := null;
2034: End IF;
2035: End IF;
2036: If NOT g_TXN_PLAN_END_DATE_sqltab.EXISTS(i) Then

Line 2039: IF g_TXN_PLAN_END_DATE_sqltab(i) = fnd_api.g_miss_date Then

2035: End IF;
2036: If NOT g_TXN_PLAN_END_DATE_sqltab.EXISTS(i) Then
2037: g_TXN_PLAN_END_DATE_sqltab(i) := null;
2038: Else
2039: IF g_TXN_PLAN_END_DATE_sqltab(i) = fnd_api.g_miss_date Then
2040: g_TXN_PLAN_END_DATE_sqltab(i) := null;
2041: End If;
2042: End If;
2043: END LOOP;

Line 2218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2214: End If;
2215: FND_MSG_PUB.add_exc_msg
2216: ( p_pkg_name => 'PA_RLMI_RBS_MAP_PUB'
2217: ,p_procedure_name => 'Map_Rlmi_Rbs');
2218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2219: PA_DEBUG.reset_err_stack;
2220: RAISE;
2221:
2222: END Map_Rlmi_Rbs;

Line 2392: If g_TXN_SOURCE_TYPE_CODE_systab(i) = fnd_api.g_miss_char Then

2388: If NOT g_TXN_SOURCE_TYPE_CODE_systab.EXISTS(i) Then
2389: g_TXN_SOURCE_TYPE_CODE_systab.Extend;
2390: g_TXN_SOURCE_TYPE_CODE_systab(i) := null;
2391: Else
2392: If g_TXN_SOURCE_TYPE_CODE_systab(i) = fnd_api.g_miss_char Then
2393: g_TXN_SOURCE_TYPE_CODE_systab(i) := null;
2394: End If;
2395: End If;
2396: If NOT g_PERSON_ID_systab.EXISTS(i) Then

Line 2400: IF g_PERSON_ID_systab(i) = fnd_api.g_miss_num Then

2396: If NOT g_PERSON_ID_systab.EXISTS(i) Then
2397: g_PERSON_ID_systab.Extend;
2398: g_PERSON_ID_systab(i) := null;
2399: Else
2400: IF g_PERSON_ID_systab(i) = fnd_api.g_miss_num Then
2401: g_PERSON_ID_systab(i) := null;
2402: End IF;
2403: End If;
2404: If NOT g_JOB_ID_systab.EXISTS(i) Then

Line 2408: If g_JOB_ID_systab(i) = fnd_api.g_miss_num Then

2404: If NOT g_JOB_ID_systab.EXISTS(i) Then
2405: g_JOB_ID_systab.Extend;
2406: g_JOB_ID_systab(i) := null;
2407: Else
2408: If g_JOB_ID_systab(i) = fnd_api.g_miss_num Then
2409: g_JOB_ID_systab(i) := null;
2410: End if;
2411: End If;
2412: If NOT g_ORGANIZATION_ID_systab.EXISTS(i) Then

Line 2416: If g_ORGANIZATION_ID_systab(i) = fnd_api.g_miss_num Then

2412: If NOT g_ORGANIZATION_ID_systab.EXISTS(i) Then
2413: g_ORGANIZATION_ID_systab.Extend;
2414: g_ORGANIZATION_ID_systab(i) := null;
2415: Else
2416: If g_ORGANIZATION_ID_systab(i) = fnd_api.g_miss_num Then
2417: g_ORGANIZATION_ID_systab(i) := null;
2418: End IF;
2419: End If;
2420: If NOT g_VENDOR_ID_systab.EXISTS(i) Then

Line 2424: If g_VENDOR_ID_systab(i) = fnd_api.g_miss_num Then

2420: If NOT g_VENDOR_ID_systab.EXISTS(i) Then
2421: g_VENDOR_ID_systab.Extend;
2422: g_VENDOR_ID_systab(i) := null;
2423: Else
2424: If g_VENDOR_ID_systab(i) = fnd_api.g_miss_num Then
2425: g_VENDOR_ID_systab(i) := null;
2426: End if;
2427: End If;
2428: If NOT g_EXPENDITURE_TYPE_systab.EXISTS(i) Then

Line 2432: If g_EXPENDITURE_TYPE_systab(i) = fnd_api.g_miss_char Then

2428: If NOT g_EXPENDITURE_TYPE_systab.EXISTS(i) Then
2429: g_EXPENDITURE_TYPE_systab.Extend;
2430: g_EXPENDITURE_TYPE_systab(i) := null;
2431: Else
2432: If g_EXPENDITURE_TYPE_systab(i) = fnd_api.g_miss_char Then
2433: g_EXPENDITURE_TYPE_systab(i) := null;
2434: End IF;
2435: End If;
2436: If NOT g_EVENT_TYPE_systab.EXISTS(i) Then

Line 2440: If g_EVENT_TYPE_systab(i) = fnd_api.g_miss_char Then

2436: If NOT g_EVENT_TYPE_systab.EXISTS(i) Then
2437: g_EVENT_TYPE_systab.Extend;
2438: g_EVENT_TYPE_systab(i) := null;
2439: Else
2440: If g_EVENT_TYPE_systab(i) = fnd_api.g_miss_char Then
2441: g_EVENT_TYPE_systab(i) := null;
2442: End IF;
2443: End If;
2444: If NOT g_NON_LABOR_RESOURCE_systab.EXISTS(i) Then

Line 2448: IF g_NON_LABOR_RESOURCE_systab(i) = fnd_api.g_miss_char Then

2444: If NOT g_NON_LABOR_RESOURCE_systab.EXISTS(i) Then
2445: g_NON_LABOR_RESOURCE_systab.Extend;
2446: g_NON_LABOR_RESOURCE_systab(i) := null;
2447: Else
2448: IF g_NON_LABOR_RESOURCE_systab(i) = fnd_api.g_miss_char Then
2449: g_NON_LABOR_RESOURCE_systab(i) := null;
2450: End If;
2451: End If;
2452: If NOT g_EXPENDITURE_CATEGORY_systab.EXISTS(i) Then

Line 2456: If g_EXPENDITURE_CATEGORY_systab(i) = fnd_api.g_miss_char Then

2452: If NOT g_EXPENDITURE_CATEGORY_systab.EXISTS(i) Then
2453: g_EXPENDITURE_CATEGORY_systab.Extend;
2454: g_EXPENDITURE_CATEGORY_systab(i) := null;
2455: Else
2456: If g_EXPENDITURE_CATEGORY_systab(i) = fnd_api.g_miss_char Then
2457: g_EXPENDITURE_CATEGORY_systab(i) := null;
2458: End if;
2459:
2460: End If;

Line 2466: IF g_REVENUE_CATEGORY_CODE_systab(i) = fnd_api.g_miss_char Then

2462: g_REVENUE_CATEGORY_CODE_systab.Extend;
2463: g_REVENUE_CATEGORY_CODE_systab(i) := null;
2464:
2465: Else
2466: IF g_REVENUE_CATEGORY_CODE_systab(i) = fnd_api.g_miss_char Then
2467: g_REVENUE_CATEGORY_CODE_systab(i) := null;
2468: End IF;
2469: End If;
2470: If NOT g_NLR_ORGANIZATION_ID_systab.EXISTS(i) Then

Line 2474: IF g_NLR_ORGANIZATION_ID_systab(i) = fnd_api.g_miss_num Then

2470: If NOT g_NLR_ORGANIZATION_ID_systab.EXISTS(i) Then
2471: g_NLR_ORGANIZATION_ID_systab.Extend;
2472: g_NLR_ORGANIZATION_ID_systab(i) := null;
2473: Else
2474: IF g_NLR_ORGANIZATION_ID_systab(i) = fnd_api.g_miss_num Then
2475: g_NLR_ORGANIZATION_ID_systab(i) := null;
2476: End IF;
2477: End If;
2478: If NOT g_EVENT_CLASSIFICATION_systab.EXISTS(i) Then

Line 2482: If g_EVENT_CLASSIFICATION_systab(i) = fnd_api.g_miss_char Then

2478: If NOT g_EVENT_CLASSIFICATION_systab.EXISTS(i) Then
2479: g_EVENT_CLASSIFICATION_systab.Extend;
2480: g_EVENT_CLASSIFICATION_systab(i) := null;
2481: Else
2482: If g_EVENT_CLASSIFICATION_systab(i) = fnd_api.g_miss_char Then
2483: g_EVENT_CLASSIFICATION_systab(i) := null;
2484: End IF;
2485: End If;
2486: If NOT g_SYS_LINK_FUNCTION_systab.EXISTS(i) Then

Line 2490: If g_SYS_LINK_FUNCTION_systab(i) = fnd_api.g_miss_char Then

2486: If NOT g_SYS_LINK_FUNCTION_systab.EXISTS(i) Then
2487: g_SYS_LINK_FUNCTION_systab.Extend;
2488: g_SYS_LINK_FUNCTION_systab(i) := null;
2489: Else
2490: If g_SYS_LINK_FUNCTION_systab(i) = fnd_api.g_miss_char Then
2491: g_SYS_LINK_FUNCTION_systab(i) := null;
2492: End IF;
2493: End If;
2494: If NOT g_PROJECT_ROLE_ID_systab.EXISTS(i) Then

Line 2498: IF g_PROJECT_ROLE_ID_systab(i) = fnd_api.g_miss_num Then

2494: If NOT g_PROJECT_ROLE_ID_systab.EXISTS(i) Then
2495: g_PROJECT_ROLE_ID_systab.Extend;
2496: g_PROJECT_ROLE_ID_systab(i) := null;
2497: Else
2498: IF g_PROJECT_ROLE_ID_systab(i) = fnd_api.g_miss_num Then
2499: g_PROJECT_ROLE_ID_systab(i) := null;
2500: End If;
2501: End If;
2502: If NOT g_RESOURCE_CLASS_CODE_systab.EXISTS(i) Then

Line 2506: IF g_RESOURCE_CLASS_CODE_systab(i) = fnd_api.g_miss_char Then

2502: If NOT g_RESOURCE_CLASS_CODE_systab.EXISTS(i) Then
2503: g_RESOURCE_CLASS_CODE_systab.Extend;
2504: g_RESOURCE_CLASS_CODE_systab(i) := null;
2505: Else
2506: IF g_RESOURCE_CLASS_CODE_systab(i) = fnd_api.g_miss_char Then
2507: g_RESOURCE_CLASS_CODE_systab(i) := null;
2508: End IF;
2509: End If;
2510: IF NOT g_MFC_COST_TYPE_ID_systab.EXISTS(i) Then

Line 2514: IF g_MFC_COST_TYPE_ID_systab(i) = fnd_api.g_miss_num Then

2510: IF NOT g_MFC_COST_TYPE_ID_systab.EXISTS(i) Then
2511: g_MFC_COST_TYPE_ID_systab.Extend;
2512: g_MFC_COST_TYPE_ID_systab(i) := null;
2513: Else
2514: IF g_MFC_COST_TYPE_ID_systab(i) = fnd_api.g_miss_num Then
2515: g_MFC_COST_TYPE_ID_systab(i) := null;
2516: End IF;
2517: End If;
2518: If NOT g_RESOURCE_CLASS_FLAG_systab.EXISTS(i) Then

Line 2522: IF g_RESOURCE_CLASS_FLAG_systab(i) = fnd_api.g_miss_char Then

2518: If NOT g_RESOURCE_CLASS_FLAG_systab.EXISTS(i) Then
2519: g_RESOURCE_CLASS_FLAG_systab.Extend;
2520: g_RESOURCE_CLASS_FLAG_systab(i) := null;
2521: Else
2522: IF g_RESOURCE_CLASS_FLAG_systab(i) = fnd_api.g_miss_char Then
2523: g_RESOURCE_CLASS_FLAG_systab(i) := null;
2524: End IF;
2525: End If;
2526: If NOT g_FC_RES_TYPE_CODE_systab.EXISTS(i) Then

Line 2530: IF g_FC_RES_TYPE_CODE_systab(i) = fnd_api.g_miss_char Then

2526: If NOT g_FC_RES_TYPE_CODE_systab.EXISTS(i) Then
2527: g_FC_RES_TYPE_CODE_systab.Extend;
2528: g_FC_RES_TYPE_CODE_systab(i) := null;
2529: Else
2530: IF g_FC_RES_TYPE_CODE_systab(i) = fnd_api.g_miss_char Then
2531: g_FC_RES_TYPE_CODE_systab(i) := null;
2532: End If;
2533: End If;
2534: If NOT g_INVENTORY_ITEM_ID_systab.EXISTS(i) Then

Line 2538: IF g_INVENTORY_ITEM_ID_systab(i) = fnd_api.g_miss_num Then

2534: If NOT g_INVENTORY_ITEM_ID_systab.EXISTS(i) Then
2535: g_INVENTORY_ITEM_ID_systab.Extend;
2536: g_INVENTORY_ITEM_ID_systab(i) := null;
2537: Else
2538: IF g_INVENTORY_ITEM_ID_systab(i) = fnd_api.g_miss_num Then
2539: g_INVENTORY_ITEM_ID_systab(i) := null;
2540: End IF;
2541: End If;
2542: IF NOT g_ITEM_CATEGORY_ID_systab.EXISTS(i) Then

Line 2546: If g_ITEM_CATEGORY_ID_systab(i) = fnd_api.g_miss_num Then

2542: IF NOT g_ITEM_CATEGORY_ID_systab.EXISTS(i) Then
2543: g_ITEM_CATEGORY_ID_systab.Extend;
2544: g_ITEM_CATEGORY_ID_systab(i) := null;
2545: Else
2546: If g_ITEM_CATEGORY_ID_systab(i) = fnd_api.g_miss_num Then
2547: g_ITEM_CATEGORY_ID_systab(i) := null;
2548: End IF;
2549: End If;
2550: IF NOT g_PERSON_TYPE_CODE_systab.EXISTS(i) Then

Line 2554: IF g_PERSON_TYPE_CODE_systab(i) = fnd_api.g_miss_char Then

2550: IF NOT g_PERSON_TYPE_CODE_systab.EXISTS(i) Then
2551: g_PERSON_TYPE_CODE_systab.Extend;
2552: g_PERSON_TYPE_CODE_systab(i) := null;
2553: Else
2554: IF g_PERSON_TYPE_CODE_systab(i) = fnd_api.g_miss_char Then
2555: g_PERSON_TYPE_CODE_systab(i) := null;
2556: End IF;
2557: End If;
2558: IF NOT g_BOM_RESOURCE_ID_systab.EXISTS(i) Then

Line 2562: IF g_BOM_RESOURCE_ID_systab(i) = fnd_api.g_miss_num Then

2558: IF NOT g_BOM_RESOURCE_ID_systab.EXISTS(i) Then
2559: g_BOM_RESOURCE_ID_systab.Extend;
2560: g_BOM_RESOURCE_ID_systab(i) := null;
2561: Else
2562: IF g_BOM_RESOURCE_ID_systab(i) = fnd_api.g_miss_num Then
2563: g_BOM_RESOURCE_ID_systab(i) := null;
2564: End IF;
2565: End IF;
2566: IF NOT g_NAMED_ROLE_systab.EXISTS(i) Then

Line 2570: IF g_NAMED_ROLE_systab(i) = fnd_api.g_miss_char Then

2566: IF NOT g_NAMED_ROLE_systab.EXISTS(i) Then
2567: g_NAMED_ROLE_systab.Extend;
2568: g_NAMED_ROLE_systab(i) := null;
2569: Else
2570: IF g_NAMED_ROLE_systab(i) = fnd_api.g_miss_char Then
2571: g_NAMED_ROLE_systab(i) := null;
2572: End IF;
2573: End If;
2574: IF NOT g_INCURRED_BY_RES_FLAG_systab.EXISTS(i) Then

Line 2578: IF g_INCURRED_BY_RES_FLAG_systab(i) = fnd_api.g_miss_char Then

2574: IF NOT g_INCURRED_BY_RES_FLAG_systab.EXISTS(i) Then
2575: g_INCURRED_BY_RES_FLAG_systab.Extend;
2576: g_INCURRED_BY_RES_FLAG_systab(i) := null;
2577: Else
2578: IF g_INCURRED_BY_RES_FLAG_systab(i) = fnd_api.g_miss_char Then
2579: g_INCURRED_BY_RES_FLAG_systab(i) := null;
2580: End IF;
2581: End If;
2582: IF NOT g_RATE_BASED_FLAG_systab.EXISTS(i) Then

Line 2586: IF g_RATE_BASED_FLAG_systab(i) = fnd_api.g_miss_char Then

2582: IF NOT g_RATE_BASED_FLAG_systab.EXISTS(i) Then
2583: g_RATE_BASED_FLAG_systab.Extend;
2584: g_RATE_BASED_FLAG_systab(i) := null;
2585: Else
2586: IF g_RATE_BASED_FLAG_systab(i) = fnd_api.g_miss_char Then
2587: g_RATE_BASED_FLAG_systab(i) := null;
2588: End IF;
2589: End IF;
2590: If NOT g_TXN_TASK_ID_systab.EXISTS(i) Then

Line 2594: IF g_TXN_TASK_ID_systab(i) = fnd_api.g_miss_num Then

2590: If NOT g_TXN_TASK_ID_systab.EXISTS(i) Then
2591: g_TXN_TASK_ID_systab.Extend;
2592: g_TXN_TASK_ID_systab(i) := null;
2593: Else
2594: IF g_TXN_TASK_ID_systab(i) = fnd_api.g_miss_num Then
2595: g_TXN_TASK_ID_systab(i) := null;
2596: End IF;
2597: end if;
2598: If NOT g_TXN_WBS_ELE_VER_ID_systab.EXISTS(i) Then

Line 2602: IF g_TXN_WBS_ELE_VER_ID_systab(i) = fnd_api.g_miss_num Then

2598: If NOT g_TXN_WBS_ELE_VER_ID_systab.EXISTS(i) Then
2599: g_TXN_WBS_ELE_VER_ID_systab.Extend;
2600: g_TXN_WBS_ELE_VER_ID_systab(i) := null;
2601: Else
2602: IF g_TXN_WBS_ELE_VER_ID_systab(i) = fnd_api.g_miss_num Then
2603: g_TXN_WBS_ELE_VER_ID_systab(i) := null;
2604: End if;
2605: End IF;
2606: IF NOT g_TXN_RBS_ELEMENT_ID_systab.EXISTS(i) Then

Line 2610: IF g_TXN_RBS_ELEMENT_ID_systab(i) = fnd_api.g_miss_num Then

2606: IF NOT g_TXN_RBS_ELEMENT_ID_systab.EXISTS(i) Then
2607: g_TXN_RBS_ELEMENT_ID_systab.Extend;
2608: g_TXN_RBS_ELEMENT_ID_systab(i) := null;
2609: Else
2610: IF g_TXN_RBS_ELEMENT_ID_systab(i) = fnd_api.g_miss_num Then
2611: g_TXN_RBS_ELEMENT_ID_systab(i) := null;
2612: End IF;
2613: End IF;
2614:

Line 2621: IF g_CBS_ELEMENT_ID_systab(i) = fnd_api.g_miss_num Then

2617: g_CBS_ELEMENT_ID_systab.Extend;
2618: g_CBS_ELEMENT_ID_systab(i) := null;
2619: Else
2620:
2621: IF g_CBS_ELEMENT_ID_systab(i) = fnd_api.g_miss_num Then
2622: g_CBS_ELEMENT_ID_systab(i) := null;
2623: End IF;
2624: End IF;
2625:

Line 2630: IF g_TXN_PLAN_START_DATE_systab(i) = fnd_api.g_miss_date Then

2626: If NOT g_TXN_PLAN_START_DATE_systab.EXISTS(i) Then
2627: g_TXN_PLAN_START_DATE_systab.Extend;
2628: g_TXN_PLAN_START_DATE_systab(i) := null;
2629: Else
2630: IF g_TXN_PLAN_START_DATE_systab(i) = fnd_api.g_miss_date Then
2631: g_TXN_PLAN_START_DATE_systab(i) := null;
2632: End IF;
2633: End IF;
2634: If NOT g_TXN_PLAN_END_DATE_systab.EXISTS(i) Then

Line 2638: IF g_TXN_PLAN_END_DATE_systab(i) = fnd_api.g_miss_date Then

2634: If NOT g_TXN_PLAN_END_DATE_systab.EXISTS(i) Then
2635: g_TXN_PLAN_END_DATE_systab.Extend;
2636: g_TXN_PLAN_END_DATE_systab(i) := null;
2637: Else
2638: IF g_TXN_PLAN_END_DATE_systab(i) = fnd_api.g_miss_date Then
2639: g_TXN_PLAN_END_DATE_systab(i) := null;
2640: End IF;
2641: End If;
2642: END LOOP;

Line 2831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2827: End If;
2828: FND_MSG_PUB.add_exc_msg
2829: ( p_pkg_name => 'PA_RLMI_RBS_MAP_PUB'
2830: ,p_procedure_name => 'Map_Rlmi_Rbs');
2831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2832: PA_DEBUG.reset_err_stack;
2833: RAISE;
2834: END Map_Rlmi_Rbs;
2835:

Line 3247: ( p_encoded => FND_API.G_TRUE

3243: x_msg_count := fnd_msg_pub.count_msg;
3244: If x_msg_count is NULL then x_msg_count := 0; End if;
3245: IF x_msg_count = 1 THEN
3246: pa_interface_utils_pub.get_messages
3247: ( p_encoded => FND_API.G_TRUE
3248: ,p_msg_index => 1
3249: ,p_data => x_msg_data
3250: ,p_msg_index_out => l_msg_index_out
3251: );

Line 3275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3271: PA_DEBUG.WRITE_FILE('LOG','SQLERROR:'||SQLCODE||SQLERRM);
3272: FND_MSG_PUB.add_exc_msg
3273: ( p_pkg_name => 'PA_RLMI_RBS_MAP_PUB'
3274: ,p_procedure_name => 'Push_RBS_Version');
3275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3276: x_msg_data := 'INVALID_PARAMS';
3277: PA_DEBUG.reset_err_stack;
3278: WHEN OTHERS THEN
3279: print_msg(g_debug_flag,l_stage||':'||SQLCODE||SQLERRM,l_proc_name);

Line 3285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3281: PA_DEBUG.WRITE_FILE('LOG','SQLERROR:'||SQLCODE||SQLERRM);
3282: FND_MSG_PUB.add_exc_msg
3283: ( p_pkg_name => 'PA_RLMI_RBS_MAP_PUB'
3284: ,p_procedure_name => 'Push_RBS_Version');
3285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3286: PA_DEBUG.reset_err_stack;
3287: RAISE;
3288:
3289: END Push_RBS_Version;