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 1608: IF g_TXN_SOURCE_TYPE_CODE_sqltab(i) = fnd_api.g_miss_char Then

1604: FOR i IN g_TXN_SOURCE_ID_sqlTab.FIRST .. g_TXN_SOURCE_ID_sqlTab.LAST LOOP
1605: If NOT g_TXN_SOURCE_TYPE_CODE_sqltab.EXISTS(i) Then
1606: g_TXN_SOURCE_TYPE_CODE_sqltab(i) := null;
1607: Else
1608: IF g_TXN_SOURCE_TYPE_CODE_sqltab(i) = fnd_api.g_miss_char Then
1609: g_TXN_SOURCE_TYPE_CODE_sqltab(i) := null;
1610: End If;
1611: End If;
1612: If NOT g_PERSON_ID_sqltab.EXISTS(i) Then

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

1611: End If;
1612: If NOT g_PERSON_ID_sqltab.EXISTS(i) Then
1613: g_PERSON_ID_sqltab(i) := null;
1614: Else
1615: IF g_PERSON_ID_sqltab(i) = fnd_api.g_miss_num Then
1616: g_PERSON_ID_sqltab(i) := null;
1617: End If;
1618: End If;
1619: If NOT g_JOB_ID_sqltab.EXISTS(i) Then

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

1618: End If;
1619: If NOT g_JOB_ID_sqltab.EXISTS(i) Then
1620: g_JOB_ID_sqltab(i) := null;
1621: Else
1622: IF g_JOB_ID_sqltab(i) = fnd_api.g_miss_num Then
1623: g_JOB_ID_sqltab(i) := null;
1624: End If;
1625: End If;
1626: If NOT g_ORGANIZATION_ID_sqltab.EXISTS(i) Then

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

1625: End If;
1626: If NOT g_ORGANIZATION_ID_sqltab.EXISTS(i) Then
1627: g_ORGANIZATION_ID_sqltab(i) := null;
1628: Else
1629: If g_ORGANIZATION_ID_sqltab(i) = fnd_api.g_miss_num Then
1630: g_ORGANIZATION_ID_sqltab(i) := null;
1631: End If;
1632: End If;
1633: If NOT g_VENDOR_ID_sqltab.EXISTS(i) Then

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

1632: End If;
1633: If NOT g_VENDOR_ID_sqltab.EXISTS(i) Then
1634: g_VENDOR_ID_sqltab(i) := null;
1635: Else
1636: IF g_VENDOR_ID_sqltab(i) = fnd_api.g_miss_num Then
1637: g_VENDOR_ID_sqltab(i) := null;
1638: End If;
1639: End If;
1640: If NOT g_EXPENDITURE_TYPE_sqltab.EXISTS(i) Then

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

1639: End If;
1640: If NOT g_EXPENDITURE_TYPE_sqltab.EXISTS(i) Then
1641: g_EXPENDITURE_TYPE_sqltab(i) := null;
1642: Else
1643: If g_EXPENDITURE_TYPE_sqltab(i) = fnd_api.g_miss_char Then
1644: g_EXPENDITURE_TYPE_sqltab(i) := null;
1645: End If;
1646: End If;
1647: If NOT g_EVENT_TYPE_sqltab.EXISTS(i) Then

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

1646: End If;
1647: If NOT g_EVENT_TYPE_sqltab.EXISTS(i) Then
1648: g_EVENT_TYPE_sqltab(i) := null;
1649: Else
1650: If g_EVENT_TYPE_sqltab(i) = fnd_api.g_miss_char Then
1651: g_EVENT_TYPE_sqltab(i) := null;
1652: End If;
1653: End If;
1654: If NOT g_NON_LABOR_RESOURCE_sqltab.EXISTS(i) Then

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

1653: End If;
1654: If NOT g_NON_LABOR_RESOURCE_sqltab.EXISTS(i) Then
1655: g_NON_LABOR_RESOURCE_sqltab(i) := null;
1656: Else
1657: IF g_NON_LABOR_RESOURCE_sqltab(i) = fnd_api.g_miss_char Then
1658: g_NON_LABOR_RESOURCE_sqltab(i) := null;
1659: End If;
1660: End If;
1661: If NOT g_EXPENDITURE_CATEGORY_sqltab.EXISTS(i) Then

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

1660: End If;
1661: If NOT g_EXPENDITURE_CATEGORY_sqltab.EXISTS(i) Then
1662: g_EXPENDITURE_CATEGORY_sqltab(i) := null;
1663: Else
1664: IF g_EXPENDITURE_CATEGORY_sqltab(i) = fnd_api.g_miss_char Then
1665: g_EXPENDITURE_CATEGORY_sqltab(i) := null;
1666: End If;
1667: End If;
1668: If NOT g_REVENUE_CATEGORY_CODE_sqltab.EXISTS(i) Then

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

1667: End If;
1668: If NOT g_REVENUE_CATEGORY_CODE_sqltab.EXISTS(i) Then
1669: g_REVENUE_CATEGORY_CODE_sqltab(i) := null;
1670: Else
1671: IF g_REVENUE_CATEGORY_CODE_sqltab(i) = fnd_api.g_miss_char Then
1672: g_REVENUE_CATEGORY_CODE_sqltab(i) := null;
1673: End If;
1674: End If;
1675: If NOT g_NLR_ORGANIZATION_ID_sqltab.EXISTS(i) Then

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

1674: End If;
1675: If NOT g_NLR_ORGANIZATION_ID_sqltab.EXISTS(i) Then
1676: g_NLR_ORGANIZATION_ID_sqltab(i) := null;
1677: Else
1678: If g_NLR_ORGANIZATION_ID_sqltab(i) = fnd_api.g_miss_num Then
1679: g_NLR_ORGANIZATION_ID_sqltab(i) := null;
1680: End If;
1681: End If;
1682: If NOT g_EVENT_CLASSIFICATION_sqltab.EXISTS(i) Then

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

1681: End If;
1682: If NOT g_EVENT_CLASSIFICATION_sqltab.EXISTS(i) Then
1683: g_EVENT_CLASSIFICATION_sqltab(i) := null;
1684: Else
1685: IF g_EVENT_CLASSIFICATION_sqltab(i) = fnd_api.g_miss_char Then
1686: g_EVENT_CLASSIFICATION_sqltab(i) := null;
1687: End If;
1688: End If;
1689: If NOT g_SYS_LINK_FUNCTION_sqltab.EXISTS(i) Then

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

1688: End If;
1689: If NOT g_SYS_LINK_FUNCTION_sqltab.EXISTS(i) Then
1690: g_SYS_LINK_FUNCTION_sqltab(i) := null;
1691: Else
1692: IF g_SYS_LINK_FUNCTION_sqltab(i) = fnd_api.g_miss_char Then
1693: g_SYS_LINK_FUNCTION_sqltab(i) := null;
1694: End If;
1695: End If;
1696: If NOT g_PROJECT_ROLE_ID_sqltab.EXISTS(i) Then

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

1695: End If;
1696: If NOT g_PROJECT_ROLE_ID_sqltab.EXISTS(i) Then
1697: g_PROJECT_ROLE_ID_sqltab(i) := null;
1698: Else
1699: IF g_PROJECT_ROLE_ID_sqltab(i) = fnd_api.g_miss_num Then
1700: g_PROJECT_ROLE_ID_sqltab(i) := null;
1701: End If;
1702: End If;
1703: If NOT g_RESOURCE_CLASS_CODE_sqltab.EXISTS(i) Then

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

1702: End If;
1703: If NOT g_RESOURCE_CLASS_CODE_sqltab.EXISTS(i) Then
1704: g_RESOURCE_CLASS_CODE_sqltab(i) := null;
1705: Else
1706: IF g_RESOURCE_CLASS_CODE_sqltab(i) = fnd_api.g_miss_char Then
1707: g_RESOURCE_CLASS_CODE_sqltab(i) := null;
1708: End If;
1709: End If;
1710: IF NOT g_MFC_COST_TYPE_ID_sqltab.EXISTS(i) Then

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

1709: End If;
1710: IF NOT g_MFC_COST_TYPE_ID_sqltab.EXISTS(i) Then
1711: g_MFC_COST_TYPE_ID_sqltab(i) := null;
1712: Else
1713: IF g_MFC_COST_TYPE_ID_sqltab(i) = fnd_api.g_miss_num Then
1714: g_MFC_COST_TYPE_ID_sqltab(i) := null;
1715: End If;
1716: End If;
1717: If NOT g_RESOURCE_CLASS_FLAG_sqltab.EXISTS(i) Then

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

1716: End If;
1717: If NOT g_RESOURCE_CLASS_FLAG_sqltab.EXISTS(i) Then
1718: g_RESOURCE_CLASS_FLAG_sqltab(i) := null;
1719: Else
1720: If g_RESOURCE_CLASS_FLAG_sqltab(i) = fnd_api.g_miss_char Then
1721: g_RESOURCE_CLASS_FLAG_sqltab(i) := null;
1722: End If;
1723: End If;
1724: If NOT g_FC_RES_TYPE_CODE_sqltab.EXISTS(i) Then

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

1723: End If;
1724: If NOT g_FC_RES_TYPE_CODE_sqltab.EXISTS(i) Then
1725: g_FC_RES_TYPE_CODE_sqltab(i) := null;
1726: Else
1727: IF g_FC_RES_TYPE_CODE_sqltab(i) = fnd_api.g_miss_char Then
1728: g_FC_RES_TYPE_CODE_sqltab(i) := null;
1729: End If;
1730: End If;
1731: If NOT g_INVENTORY_ITEM_ID_sqltab.EXISTS(i) Then

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

1730: End If;
1731: If NOT g_INVENTORY_ITEM_ID_sqltab.EXISTS(i) Then
1732: g_INVENTORY_ITEM_ID_sqltab(i) := null;
1733: Else
1734: IF g_INVENTORY_ITEM_ID_sqltab(i) = fnd_api.g_miss_num Then
1735: g_INVENTORY_ITEM_ID_sqltab(i) := null;
1736: End If;
1737: End If;
1738: IF NOT g_ITEM_CATEGORY_ID_sqltab.EXISTS(i) Then

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

1737: End If;
1738: IF NOT g_ITEM_CATEGORY_ID_sqltab.EXISTS(i) Then
1739: g_ITEM_CATEGORY_ID_sqltab(i) := null;
1740: Else
1741: IF g_ITEM_CATEGORY_ID_sqltab(i) = fnd_api.g_miss_num Then
1742: g_ITEM_CATEGORY_ID_sqltab(i) := null;
1743: End If;
1744: End If;
1745: IF NOT g_PERSON_TYPE_CODE_sqltab.EXISTS(i) Then

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

1744: End If;
1745: IF NOT g_PERSON_TYPE_CODE_sqltab.EXISTS(i) Then
1746: g_PERSON_TYPE_CODE_sqltab(i) := null;
1747: Else
1748: IF g_PERSON_TYPE_CODE_sqltab(i) = fnd_api.g_miss_char Then
1749: g_PERSON_TYPE_CODE_sqltab(i) := null;
1750: End if;
1751: End If;
1752: IF NOT g_BOM_RESOURCE_ID_sqltab.EXISTS(i) Then

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

1751: End If;
1752: IF NOT g_BOM_RESOURCE_ID_sqltab.EXISTS(i) Then
1753: g_BOM_RESOURCE_ID_sqltab(i) := null;
1754: Else
1755: IF g_BOM_RESOURCE_ID_sqltab(i) = fnd_api.g_miss_num Then
1756: g_BOM_RESOURCE_ID_sqltab(i) := null;
1757: End IF;
1758: End IF;
1759: IF NOT g_NAMED_ROLE_sqltab.EXISTS(i) Then

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

1758: End IF;
1759: IF NOT g_NAMED_ROLE_sqltab.EXISTS(i) Then
1760: g_NAMED_ROLE_sqltab(i) := null;
1761: Else
1762: IF g_NAMED_ROLE_sqltab(i) = fnd_api.g_miss_char Then
1763: g_NAMED_ROLE_sqltab(i) := null;
1764: End IF;
1765: End If;
1766: IF NOT g_INCURRED_BY_RES_FLAG_sqltab.EXISTS(i) Then

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

1765: End If;
1766: IF NOT g_INCURRED_BY_RES_FLAG_sqltab.EXISTS(i) Then
1767: g_INCURRED_BY_RES_FLAG_sqltab(i) := null;
1768: Else
1769: IF g_INCURRED_BY_RES_FLAG_sqltab(i) = fnd_api.g_miss_char Then
1770: g_INCURRED_BY_RES_FLAG_sqltab(i) := null;
1771: End IF;
1772: End If;
1773: IF NOT g_RATE_BASED_FLAG_sqltab.EXISTS(i) Then

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

1772: End If;
1773: IF NOT g_RATE_BASED_FLAG_sqltab.EXISTS(i) Then
1774: g_RATE_BASED_FLAG_sqltab(i) := null;
1775: Else
1776: IF g_RATE_BASED_FLAG_sqltab(i) = fnd_api.g_miss_char Then
1777: g_RATE_BASED_FLAG_sqltab(i) := null;
1778: End IF;
1779: End IF;
1780: If NOT g_TXN_TASK_ID_sqltab.EXISTS(i) Then

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

1779: End IF;
1780: If NOT g_TXN_TASK_ID_sqltab.EXISTS(i) Then
1781: g_TXN_TASK_ID_sqltab(i) := null;
1782: Else
1783: IF g_TXN_TASK_ID_sqltab(i) = fnd_api.g_miss_num Then
1784: g_TXN_TASK_ID_sqltab(i) := null;
1785: End IF;
1786: end if;
1787: If NOT g_TXN_WBS_ELE_VER_ID_sqltab.EXISTS(i) Then

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

1786: end if;
1787: If NOT g_TXN_WBS_ELE_VER_ID_sqltab.EXISTS(i) Then
1788: g_TXN_WBS_ELE_VER_ID_sqltab(i) := null;
1789: Else
1790: IF g_TXN_WBS_ELE_VER_ID_sqltab(i) = fnd_api.g_miss_num Then
1791: g_TXN_WBS_ELE_VER_ID_sqltab(i) := null;
1792: End IF;
1793: End IF;
1794: IF NOT g_TXN_RBS_ELEMENT_ID_sqltab.EXISTS(i) Then

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

1793: End IF;
1794: IF NOT g_TXN_RBS_ELEMENT_ID_sqltab.EXISTS(i) Then
1795: g_TXN_RBS_ELEMENT_ID_sqltab(i) := null;
1796: Else
1797: IF g_TXN_RBS_ELEMENT_ID_sqltab(i) = fnd_api.g_miss_num Then
1798: g_TXN_RBS_ELEMENT_ID_sqltab(i) := null;
1799: End IF;
1800: End IF;
1801: If NOT g_TXN_PLAN_START_DATE_sqltab.EXISTS(i) Then

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

1800: End IF;
1801: If NOT g_TXN_PLAN_START_DATE_sqltab.EXISTS(i) Then
1802: g_TXN_PLAN_START_DATE_sqltab(i) := null;
1803: Else
1804: IF g_TXN_PLAN_START_DATE_sqltab(i) = fnd_api.g_miss_date Then
1805: g_TXN_PLAN_START_DATE_sqltab(i) := null;
1806: End IF;
1807: End IF;
1808: If NOT g_TXN_PLAN_END_DATE_sqltab.EXISTS(i) Then

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

1807: End IF;
1808: If NOT g_TXN_PLAN_END_DATE_sqltab.EXISTS(i) Then
1809: g_TXN_PLAN_END_DATE_sqltab(i) := null;
1810: Else
1811: IF g_TXN_PLAN_END_DATE_sqltab(i) = fnd_api.g_miss_date Then
1812: g_TXN_PLAN_END_DATE_sqltab(i) := null;
1813: End If;
1814: End If;
1815: END LOOP;

Line 1990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1986: End If;
1987: FND_MSG_PUB.add_exc_msg
1988: ( p_pkg_name => 'PA_RLMI_RBS_MAP_PUB'
1989: ,p_procedure_name => 'Map_Rlmi_Rbs');
1990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1991: PA_DEBUG.reset_err_stack;
1992: RAISE;
1993:
1994: END Map_Rlmi_Rbs;

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

2154: If NOT g_TXN_SOURCE_TYPE_CODE_systab.EXISTS(i) Then
2155: g_TXN_SOURCE_TYPE_CODE_systab.Extend;
2156: g_TXN_SOURCE_TYPE_CODE_systab(i) := null;
2157: Else
2158: If g_TXN_SOURCE_TYPE_CODE_systab(i) = fnd_api.g_miss_char Then
2159: g_TXN_SOURCE_TYPE_CODE_systab(i) := null;
2160: End If;
2161: End If;
2162: If NOT g_PERSON_ID_systab.EXISTS(i) Then

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

2162: If NOT g_PERSON_ID_systab.EXISTS(i) Then
2163: g_PERSON_ID_systab.Extend;
2164: g_PERSON_ID_systab(i) := null;
2165: Else
2166: IF g_PERSON_ID_systab(i) = fnd_api.g_miss_num Then
2167: g_PERSON_ID_systab(i) := null;
2168: End IF;
2169: End If;
2170: If NOT g_JOB_ID_systab.EXISTS(i) Then

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

2170: If NOT g_JOB_ID_systab.EXISTS(i) Then
2171: g_JOB_ID_systab.Extend;
2172: g_JOB_ID_systab(i) := null;
2173: Else
2174: If g_JOB_ID_systab(i) = fnd_api.g_miss_num Then
2175: g_JOB_ID_systab(i) := null;
2176: End if;
2177: End If;
2178: If NOT g_ORGANIZATION_ID_systab.EXISTS(i) Then

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

2178: If NOT g_ORGANIZATION_ID_systab.EXISTS(i) Then
2179: g_ORGANIZATION_ID_systab.Extend;
2180: g_ORGANIZATION_ID_systab(i) := null;
2181: Else
2182: If g_ORGANIZATION_ID_systab(i) = fnd_api.g_miss_num Then
2183: g_ORGANIZATION_ID_systab(i) := null;
2184: End IF;
2185: End If;
2186: If NOT g_VENDOR_ID_systab.EXISTS(i) Then

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

2186: If NOT g_VENDOR_ID_systab.EXISTS(i) Then
2187: g_VENDOR_ID_systab.Extend;
2188: g_VENDOR_ID_systab(i) := null;
2189: Else
2190: If g_VENDOR_ID_systab(i) = fnd_api.g_miss_num Then
2191: g_VENDOR_ID_systab(i) := null;
2192: End if;
2193: End If;
2194: If NOT g_EXPENDITURE_TYPE_systab.EXISTS(i) Then

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

2194: If NOT g_EXPENDITURE_TYPE_systab.EXISTS(i) Then
2195: g_EXPENDITURE_TYPE_systab.Extend;
2196: g_EXPENDITURE_TYPE_systab(i) := null;
2197: Else
2198: If g_EXPENDITURE_TYPE_systab(i) = fnd_api.g_miss_char Then
2199: g_EXPENDITURE_TYPE_systab(i) := null;
2200: End IF;
2201: End If;
2202: If NOT g_EVENT_TYPE_systab.EXISTS(i) Then

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

2202: If NOT g_EVENT_TYPE_systab.EXISTS(i) Then
2203: g_EVENT_TYPE_systab.Extend;
2204: g_EVENT_TYPE_systab(i) := null;
2205: Else
2206: If g_EVENT_TYPE_systab(i) = fnd_api.g_miss_char Then
2207: g_EVENT_TYPE_systab(i) := null;
2208: End IF;
2209: End If;
2210: If NOT g_NON_LABOR_RESOURCE_systab.EXISTS(i) Then

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

2210: If NOT g_NON_LABOR_RESOURCE_systab.EXISTS(i) Then
2211: g_NON_LABOR_RESOURCE_systab.Extend;
2212: g_NON_LABOR_RESOURCE_systab(i) := null;
2213: Else
2214: IF g_NON_LABOR_RESOURCE_systab(i) = fnd_api.g_miss_char Then
2215: g_NON_LABOR_RESOURCE_systab(i) := null;
2216: End If;
2217: End If;
2218: If NOT g_EXPENDITURE_CATEGORY_systab.EXISTS(i) Then

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

2218: If NOT g_EXPENDITURE_CATEGORY_systab.EXISTS(i) Then
2219: g_EXPENDITURE_CATEGORY_systab.Extend;
2220: g_EXPENDITURE_CATEGORY_systab(i) := null;
2221: Else
2222: If g_EXPENDITURE_CATEGORY_systab(i) = fnd_api.g_miss_char Then
2223: g_EXPENDITURE_CATEGORY_systab(i) := null;
2224: End if;
2225:
2226: End If;

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

2228: g_REVENUE_CATEGORY_CODE_systab.Extend;
2229: g_REVENUE_CATEGORY_CODE_systab(i) := null;
2230:
2231: Else
2232: IF g_REVENUE_CATEGORY_CODE_systab(i) = fnd_api.g_miss_char Then
2233: g_REVENUE_CATEGORY_CODE_systab(i) := null;
2234: End IF;
2235: End If;
2236: If NOT g_NLR_ORGANIZATION_ID_systab.EXISTS(i) Then

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

2236: If NOT g_NLR_ORGANIZATION_ID_systab.EXISTS(i) Then
2237: g_NLR_ORGANIZATION_ID_systab.Extend;
2238: g_NLR_ORGANIZATION_ID_systab(i) := null;
2239: Else
2240: IF g_NLR_ORGANIZATION_ID_systab(i) = fnd_api.g_miss_num Then
2241: g_NLR_ORGANIZATION_ID_systab(i) := null;
2242: End IF;
2243: End If;
2244: If NOT g_EVENT_CLASSIFICATION_systab.EXISTS(i) Then

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

2244: If NOT g_EVENT_CLASSIFICATION_systab.EXISTS(i) Then
2245: g_EVENT_CLASSIFICATION_systab.Extend;
2246: g_EVENT_CLASSIFICATION_systab(i) := null;
2247: Else
2248: If g_EVENT_CLASSIFICATION_systab(i) = fnd_api.g_miss_char Then
2249: g_EVENT_CLASSIFICATION_systab(i) := null;
2250: End IF;
2251: End If;
2252: If NOT g_SYS_LINK_FUNCTION_systab.EXISTS(i) Then

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

2252: If NOT g_SYS_LINK_FUNCTION_systab.EXISTS(i) Then
2253: g_SYS_LINK_FUNCTION_systab.Extend;
2254: g_SYS_LINK_FUNCTION_systab(i) := null;
2255: Else
2256: If g_SYS_LINK_FUNCTION_systab(i) = fnd_api.g_miss_char Then
2257: g_SYS_LINK_FUNCTION_systab(i) := null;
2258: End IF;
2259: End If;
2260: If NOT g_PROJECT_ROLE_ID_systab.EXISTS(i) Then

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

2260: If NOT g_PROJECT_ROLE_ID_systab.EXISTS(i) Then
2261: g_PROJECT_ROLE_ID_systab.Extend;
2262: g_PROJECT_ROLE_ID_systab(i) := null;
2263: Else
2264: IF g_PROJECT_ROLE_ID_systab(i) = fnd_api.g_miss_num Then
2265: g_PROJECT_ROLE_ID_systab(i) := null;
2266: End If;
2267: End If;
2268: If NOT g_RESOURCE_CLASS_CODE_systab.EXISTS(i) Then

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

2268: If NOT g_RESOURCE_CLASS_CODE_systab.EXISTS(i) Then
2269: g_RESOURCE_CLASS_CODE_systab.Extend;
2270: g_RESOURCE_CLASS_CODE_systab(i) := null;
2271: Else
2272: IF g_RESOURCE_CLASS_CODE_systab(i) = fnd_api.g_miss_char Then
2273: g_RESOURCE_CLASS_CODE_systab(i) := null;
2274: End IF;
2275: End If;
2276: IF NOT g_MFC_COST_TYPE_ID_systab.EXISTS(i) Then

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

2276: IF NOT g_MFC_COST_TYPE_ID_systab.EXISTS(i) Then
2277: g_MFC_COST_TYPE_ID_systab.Extend;
2278: g_MFC_COST_TYPE_ID_systab(i) := null;
2279: Else
2280: IF g_MFC_COST_TYPE_ID_systab(i) = fnd_api.g_miss_num Then
2281: g_MFC_COST_TYPE_ID_systab(i) := null;
2282: End IF;
2283: End If;
2284: If NOT g_RESOURCE_CLASS_FLAG_systab.EXISTS(i) Then

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

2284: If NOT g_RESOURCE_CLASS_FLAG_systab.EXISTS(i) Then
2285: g_RESOURCE_CLASS_FLAG_systab.Extend;
2286: g_RESOURCE_CLASS_FLAG_systab(i) := null;
2287: Else
2288: IF g_RESOURCE_CLASS_FLAG_systab(i) = fnd_api.g_miss_char Then
2289: g_RESOURCE_CLASS_FLAG_systab(i) := null;
2290: End IF;
2291: End If;
2292: If NOT g_FC_RES_TYPE_CODE_systab.EXISTS(i) Then

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

2292: If NOT g_FC_RES_TYPE_CODE_systab.EXISTS(i) Then
2293: g_FC_RES_TYPE_CODE_systab.Extend;
2294: g_FC_RES_TYPE_CODE_systab(i) := null;
2295: Else
2296: IF g_FC_RES_TYPE_CODE_systab(i) = fnd_api.g_miss_char Then
2297: g_FC_RES_TYPE_CODE_systab(i) := null;
2298: End If;
2299: End If;
2300: If NOT g_INVENTORY_ITEM_ID_systab.EXISTS(i) Then

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

2300: If NOT g_INVENTORY_ITEM_ID_systab.EXISTS(i) Then
2301: g_INVENTORY_ITEM_ID_systab.Extend;
2302: g_INVENTORY_ITEM_ID_systab(i) := null;
2303: Else
2304: IF g_INVENTORY_ITEM_ID_systab(i) = fnd_api.g_miss_num Then
2305: g_INVENTORY_ITEM_ID_systab(i) := null;
2306: End IF;
2307: End If;
2308: IF NOT g_ITEM_CATEGORY_ID_systab.EXISTS(i) Then

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

2308: IF NOT g_ITEM_CATEGORY_ID_systab.EXISTS(i) Then
2309: g_ITEM_CATEGORY_ID_systab.Extend;
2310: g_ITEM_CATEGORY_ID_systab(i) := null;
2311: Else
2312: If g_ITEM_CATEGORY_ID_systab(i) = fnd_api.g_miss_num Then
2313: g_ITEM_CATEGORY_ID_systab(i) := null;
2314: End IF;
2315: End If;
2316: IF NOT g_PERSON_TYPE_CODE_systab.EXISTS(i) Then

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

2316: IF NOT g_PERSON_TYPE_CODE_systab.EXISTS(i) Then
2317: g_PERSON_TYPE_CODE_systab.Extend;
2318: g_PERSON_TYPE_CODE_systab(i) := null;
2319: Else
2320: IF g_PERSON_TYPE_CODE_systab(i) = fnd_api.g_miss_char Then
2321: g_PERSON_TYPE_CODE_systab(i) := null;
2322: End IF;
2323: End If;
2324: IF NOT g_BOM_RESOURCE_ID_systab.EXISTS(i) Then

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

2324: IF NOT g_BOM_RESOURCE_ID_systab.EXISTS(i) Then
2325: g_BOM_RESOURCE_ID_systab.Extend;
2326: g_BOM_RESOURCE_ID_systab(i) := null;
2327: Else
2328: IF g_BOM_RESOURCE_ID_systab(i) = fnd_api.g_miss_num Then
2329: g_BOM_RESOURCE_ID_systab(i) := null;
2330: End IF;
2331: End IF;
2332: IF NOT g_NAMED_ROLE_systab.EXISTS(i) Then

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

2332: IF NOT g_NAMED_ROLE_systab.EXISTS(i) Then
2333: g_NAMED_ROLE_systab.Extend;
2334: g_NAMED_ROLE_systab(i) := null;
2335: Else
2336: IF g_NAMED_ROLE_systab(i) = fnd_api.g_miss_char Then
2337: g_NAMED_ROLE_systab(i) := null;
2338: End IF;
2339: End If;
2340: IF NOT g_INCURRED_BY_RES_FLAG_systab.EXISTS(i) Then

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

2340: IF NOT g_INCURRED_BY_RES_FLAG_systab.EXISTS(i) Then
2341: g_INCURRED_BY_RES_FLAG_systab.Extend;
2342: g_INCURRED_BY_RES_FLAG_systab(i) := null;
2343: Else
2344: IF g_INCURRED_BY_RES_FLAG_systab(i) = fnd_api.g_miss_char Then
2345: g_INCURRED_BY_RES_FLAG_systab(i) := null;
2346: End IF;
2347: End If;
2348: IF NOT g_RATE_BASED_FLAG_systab.EXISTS(i) Then

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

2348: IF NOT g_RATE_BASED_FLAG_systab.EXISTS(i) Then
2349: g_RATE_BASED_FLAG_systab.Extend;
2350: g_RATE_BASED_FLAG_systab(i) := null;
2351: Else
2352: IF g_RATE_BASED_FLAG_systab(i) = fnd_api.g_miss_char Then
2353: g_RATE_BASED_FLAG_systab(i) := null;
2354: End IF;
2355: End IF;
2356: If NOT g_TXN_TASK_ID_systab.EXISTS(i) Then

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

2356: If NOT g_TXN_TASK_ID_systab.EXISTS(i) Then
2357: g_TXN_TASK_ID_systab.Extend;
2358: g_TXN_TASK_ID_systab(i) := null;
2359: Else
2360: IF g_TXN_TASK_ID_systab(i) = fnd_api.g_miss_num Then
2361: g_TXN_TASK_ID_systab(i) := null;
2362: End IF;
2363: end if;
2364: If NOT g_TXN_WBS_ELE_VER_ID_systab.EXISTS(i) Then

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

2364: If NOT g_TXN_WBS_ELE_VER_ID_systab.EXISTS(i) Then
2365: g_TXN_WBS_ELE_VER_ID_systab.Extend;
2366: g_TXN_WBS_ELE_VER_ID_systab(i) := null;
2367: Else
2368: IF g_TXN_WBS_ELE_VER_ID_systab(i) = fnd_api.g_miss_num Then
2369: g_TXN_WBS_ELE_VER_ID_systab(i) := null;
2370: End if;
2371: End IF;
2372: IF NOT g_TXN_RBS_ELEMENT_ID_systab.EXISTS(i) Then

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

2372: IF NOT g_TXN_RBS_ELEMENT_ID_systab.EXISTS(i) Then
2373: g_TXN_RBS_ELEMENT_ID_systab.Extend;
2374: g_TXN_RBS_ELEMENT_ID_systab(i) := null;
2375: Else
2376: IF g_TXN_RBS_ELEMENT_ID_systab(i) = fnd_api.g_miss_num Then
2377: g_TXN_RBS_ELEMENT_ID_systab(i) := null;
2378: End IF;
2379: End IF;
2380: If NOT g_TXN_PLAN_START_DATE_systab.EXISTS(i) Then

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

2380: If NOT g_TXN_PLAN_START_DATE_systab.EXISTS(i) Then
2381: g_TXN_PLAN_START_DATE_systab.Extend;
2382: g_TXN_PLAN_START_DATE_systab(i) := null;
2383: Else
2384: IF g_TXN_PLAN_START_DATE_systab(i) = fnd_api.g_miss_date Then
2385: g_TXN_PLAN_START_DATE_systab(i) := null;
2386: End IF;
2387: End IF;
2388: If NOT g_TXN_PLAN_END_DATE_systab.EXISTS(i) Then

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

2388: If NOT g_TXN_PLAN_END_DATE_systab.EXISTS(i) Then
2389: g_TXN_PLAN_END_DATE_systab.Extend;
2390: g_TXN_PLAN_END_DATE_systab(i) := null;
2391: Else
2392: IF g_TXN_PLAN_END_DATE_systab(i) = fnd_api.g_miss_date Then
2393: g_TXN_PLAN_END_DATE_systab(i) := null;
2394: End IF;
2395: End If;
2396: END LOOP;

Line 2581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2577: End If;
2578: FND_MSG_PUB.add_exc_msg
2579: ( p_pkg_name => 'PA_RLMI_RBS_MAP_PUB'
2580: ,p_procedure_name => 'Map_Rlmi_Rbs');
2581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2582: PA_DEBUG.reset_err_stack;
2583: RAISE;
2584: END Map_Rlmi_Rbs;
2585:

Line 2836: ( p_encoded => FND_API.G_TRUE

2832: x_msg_count := fnd_msg_pub.count_msg;
2833: If x_msg_count is NULL then x_msg_count := 0; End if;
2834: IF x_msg_count = 1 THEN
2835: pa_interface_utils_pub.get_messages
2836: ( p_encoded => FND_API.G_TRUE
2837: ,p_msg_index => 1
2838: ,p_data => x_msg_data
2839: ,p_msg_index_out => l_msg_index_out
2840: );

Line 2864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2860: PA_DEBUG.WRITE_FILE('LOG','SQLERROR:'||SQLCODE||SQLERRM);
2861: FND_MSG_PUB.add_exc_msg
2862: ( p_pkg_name => 'PA_RLMI_RBS_MAP_PUB'
2863: ,p_procedure_name => 'Push_RBS_Version');
2864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2865: x_msg_data := 'INVALID_PARAMS';
2866: PA_DEBUG.reset_err_stack;
2867: WHEN OTHERS THEN
2868: print_msg(g_debug_flag,l_stage||':'||SQLCODE||SQLERRM,l_proc_name);

Line 2874: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2870: PA_DEBUG.WRITE_FILE('LOG','SQLERROR:'||SQLCODE||SQLERRM);
2871: FND_MSG_PUB.add_exc_msg
2872: ( p_pkg_name => 'PA_RLMI_RBS_MAP_PUB'
2873: ,p_procedure_name => 'Push_RBS_Version');
2874: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2875: PA_DEBUG.reset_err_stack;
2876: RAISE;
2877:
2878: END Push_RBS_Version;