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

Line 387: x_return_status := FND_API.G_RET_STS_SUCCESS;

383: )
384: );
385: d_progress := 200;
386: PO_UDA_DEFAULTING_PKG.DEBUG('After constructing Class codes Array with template id : ' || l_uda_template_id, d_progress);
387: x_return_status := FND_API.G_RET_STS_SUCCESS;
388: EXCEPTION
389: WHEN OTHERS THEN
390: l_err_txt := 'Exception in POPULATE_STRUCTURES with ERROR : ' || SQLERRM;
391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

387: x_return_status := FND_API.G_RET_STS_SUCCESS;
388: EXCEPTION
389: WHEN OTHERS THEN
390: l_err_txt := 'Exception in POPULATE_STRUCTURES with ERROR : ' || SQLERRM;
391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
392: PO_UDA_IMPORT_PKG.HANDLE_ERROR
393: (
394: p_msg => l_err_txt
395: ,p_msg_code => 'UNEXPECTED_POPULATE_STRUCTURES'

Line 585: x_return_status := FND_API.G_RET_STS_SUCCESS;

581: d_progress := 290;
582: END LOOP;
583: END IF;
584: d_progress := 300;
585: x_return_status := FND_API.G_RET_STS_SUCCESS;
586: EXCEPTION
587: WHEN OTHERS THEN
588: l_err_txt := 'Exception in POPULATE_REMAINING_ATTRIBUTES with ERROR : ' || SQLERRM;
589: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 589: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

585: x_return_status := FND_API.G_RET_STS_SUCCESS;
586: EXCEPTION
587: WHEN OTHERS THEN
588: l_err_txt := 'Exception in POPULATE_REMAINING_ATTRIBUTES with ERROR : ' || SQLERRM;
589: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
590: PO_UDA_IMPORT_PKG.HANDLE_ERROR
591: (
592: p_msg => l_err_txt
593: ,p_msg_code => 'UNEXPECTED_POPULATE_REMAINING_ATTRIBUTES'

Line 1065: x_return_status := FND_API.G_RET_STS_SUCCESS;

1061: d_progress := 760;
1062: PO_UDA_DEFAULTING_PKG.DEBUG('USAGE object array does not have any objects', d_progress);
1063: END IF;
1064: d_progress := 770;
1065: x_return_status := FND_API.G_RET_STS_SUCCESS;
1066: EXCEPTION
1067: WHEN OTHERS THEN
1068: l_err_txt := 'Exception in POPULATE_EMPTY_AGS with ERROR : ' || SQLERRM;
1069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1065: x_return_status := FND_API.G_RET_STS_SUCCESS;
1066: EXCEPTION
1067: WHEN OTHERS THEN
1068: l_err_txt := 'Exception in POPULATE_EMPTY_AGS with ERROR : ' || SQLERRM;
1069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1070:
1071: IF DBMS_SQL.is_open(v_query_hdl) THEN
1072: DBMS_SQL.close_cursor(v_query_hdl);
1073: END IF ;

Line 1226: x_return_status := FND_API.G_RET_STS_SUCCESS;

1222: PO_UDA_DEFAULTING_PKG.DEBUG(x_attr_name_value_pairs, d_progress);
1223: PO_UDA_DEFAULTING_PKG.DEBUG('x_attributes_row_table is as follows', d_progress);
1224: PO_UDA_DEFAULTING_PKG.DEBUG(x_attributes_row_table, d_progress);
1225:
1226: x_return_status := FND_API.G_RET_STS_SUCCESS;
1227: g_uda_return_status := FND_API.G_RET_STS_SUCCESS;
1228: IF (x_attributes_row_table IS NOT NULL AND x_attributes_row_table.COUNT > 0) THEN
1229: d_progress := 20;
1230: l_attr_group_id_index := x_attributes_row_table.FIRST;

Line 1227: g_uda_return_status := FND_API.G_RET_STS_SUCCESS;

1223: PO_UDA_DEFAULTING_PKG.DEBUG('x_attributes_row_table is as follows', d_progress);
1224: PO_UDA_DEFAULTING_PKG.DEBUG(x_attributes_row_table, d_progress);
1225:
1226: x_return_status := FND_API.G_RET_STS_SUCCESS;
1227: g_uda_return_status := FND_API.G_RET_STS_SUCCESS;
1228: IF (x_attributes_row_table IS NOT NULL AND x_attributes_row_table.COUNT > 0) THEN
1229: d_progress := 20;
1230: l_attr_group_id_index := x_attributes_row_table.FIRST;
1231: d_progress := 30;

Line 1339: IF uda_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1335: PO_UDA_DEFAULTING_PKG.GET_EXT_ATTR_NAME_VALUE_PAIR('x_msg_data', x_external_attr_value_pairs, ext_name_val_obj);
1336: uda_msg_data := ext_name_val_obj.VALUE ;
1337:
1338: d_progress := 260;
1339: IF uda_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1340: g_uda_return_status := uda_return_status;
1341: END IF;
1342:
1343: d_progress := 270;

Line 1344: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1340: g_uda_return_status := uda_return_status;
1341: END IF;
1342:
1343: d_progress := 270;
1344: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1345: d_progress := 280;
1346: EXIT;
1347: END IF;
1348:

Line 1401: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1397: x_return_status := ext_name_val_obj.VALUE ;
1398: PO_UDA_DEFAULTING_PKG.DEBUG('Return status for action is ' || x_return_status, d_progress);
1399:
1400: d_progress := 420;
1401: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1402: d_progress := 43;
1403: PO_UDA_IMPORT_PKG.HANDLE_ERROR
1404: (
1405: p_msg => 'There was an error in EXECUTE_IMPORT_UDA_FUNCTION for Action ID :' || l_action_id

Line 1442: IF g_uda_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1438: d_progress := 530;
1439: END LOOP;
1440: CLOSE c_get_action_id;
1441:
1442: IF g_uda_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1443: d_progress := 540;
1444: PO_UDA_DEFAULTING_PKG.DEBUG('g_uda_return_status is a failure', d_progress);
1445: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_return_status', g_uda_return_status, x_external_attr_value_pairs);
1446: END IF;

Line 1448: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1444: PO_UDA_DEFAULTING_PKG.DEBUG('g_uda_return_status is a failure', d_progress);
1445: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_return_status', g_uda_return_status, x_external_attr_value_pairs);
1446: END IF;
1447: d_progress := 550;
1448: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1449: PO_UDA_DEFAULTING_PKG.DEBUG('x_return_status is a failure', d_progress);
1450: d_progress := 560;
1451: EXIT;
1452: END IF;

Line 1460: x_return_status := FND_API.G_RET_STS_SUCCESS;

1456: l_attr_group_id_index := x_attributes_row_table.NEXT(l_attr_group_id_index);
1457: END LOOP;
1458: IF x_return_status IS NULL THEN
1459: d_progress := 600;
1460: x_return_status := FND_API.G_RET_STS_SUCCESS;
1461: END IF;
1462: d_progress := 610;
1463: END IF;
1464:

Line 1468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1464:
1465: EXCEPTION
1466: WHEN OTHERS THEN
1467: l_err_txt := 'Exception in EXECUTE_IMPORT_UDA_FUNCTION with ERROR : ' || SQLERRM;
1468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1469: PO_UDA_IMPORT_PKG.HANDLE_ERROR
1470: (
1471: p_msg => l_err_txt
1472: ,p_msg_code => 'UNEXPECTED_EXECUTE_IMPORT_UDA_FUNCTION'

Line 1603: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1599: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_count ' || x_msg_count, d_progress);
1600: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_data ' || x_msg_data, d_progress);
1601:
1602: PO_UDA_DEFAULTING_PKG.DEBUG('Template ID is :: ' || l_class_code_name_value_pairs(l_class_code_name_value_pairs.FIRST).VALUE, d_progress);
1603: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1604: d_progress := 70;
1605: PO_UDA_DEFAULTING_PKG.DEBUG('Before POPULATE_REMAINING_ATTRIBUTES ' || x_return_status, d_progress);
1606: PO_UDA_IMPORT_PKG.POPULATE_REMAINING_ATTRIBUTES
1607: (

Line 1644: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1640: );
1641: d_progress := 110;
1642: END IF;
1643: d_progress := 120;
1644: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1645: d_progress := 130;
1646: PO_UDA_DEFAULTING_PKG.DEBUG('Before POPULATE_EMPTY_AGS ' || x_return_status, d_progress);
1647: PO_UDA_IMPORT_PKG.POPULATE_EMPTY_AGS
1648: (

Line 1688: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1684: );
1685: d_progress := 170;
1686: END IF;
1687:
1688: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1689: d_progress := 180;
1690: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1691: (
1692: p_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS

Line 1745: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1741: );
1742: d_progress := 230;
1743: END IF;
1744:
1745: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1746: d_progress := 240;
1747: PO_UDA_DEFAULTING_PKG.DEBUG('Before EXECUTE_IMPORT_UDA_FUNCTION (XLE) ' || x_return_status, d_progress);
1748: PO_UDA_IMPORT_PKG.EXECUTE_IMPORT_UDA_FUNCTION
1749: (

Line 1816: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1812: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_data ' || x_msg_data, d_progress);
1813:
1814: END IF;
1815:
1816: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1817: d_progress := 290;
1818: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1819: (
1820: p_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS

Line 1854: ,p_validate_only => FND_API.G_TRUE

1850: ,p_attributes_row_table => l_attributes_row_table
1851: ,p_attributes_data_table => l_attr_name_value_pairs
1852: ,p_pk_column_name_value_pairs => l_pk_column_name_value_pairs
1853: ,p_class_code_name_value_pairs => l_class_code_name_value_pairs
1854: ,p_validate_only => FND_API.G_TRUE
1855: ,x_failed_row_id_list => l_failed_row_id_list
1856: ,x_return_status => x_return_status
1857: ,x_errorcode => x_errorcode
1858: ,x_msg_count => x_msg_count

Line 1892: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1888: );
1889: d_progress := 360;
1890: END IF;
1891: d_progress := 370;
1892: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1893: d_progress := 380;
1894:
1895: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1896: (

Line 1962: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1958: );
1959: d_progress := 470;
1960: END IF;
1961:
1962: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1963: d_progress := 480;
1964:
1965: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1966: (

Line 2038: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

2034: );
2035: d_progress := 550;
2036: END IF;
2037:
2038: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2039: d_progress := 560;
2040: PO_UDA_DEFAULTING_PKG.DEBUG('Before EXECUTE_IMPORT_UDA_FUNCTION (XPD) ' || x_return_status, d_progress);
2041: IF l_attributes_row_table.COUNT > 0 THEN
2042: d_progress := 570;

Line 2087: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

2083: );
2084: d_progress := 620;
2085: END IF;
2086: d_progress := 630;
2087: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2088: d_progress := 640;
2089: PO_UDA_IMPORT_PKG.UPDATE_STATUS
2090: (
2091: p_process_status => PO_UDA_IMPORT_PKG.COMPLETED

Line 2114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2110:
2111: EXCEPTION
2112: WHEN OTHERS THEN
2113: l_err_txt := 'Exception in IMPORT_UDA_ATTRS with ERROR : ' || SQLERRM;
2114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2115: PO_UDA_IMPORT_PKG.HANDLE_ERROR
2116: (
2117: p_msg => l_err_txt
2118: ,p_msg_code => 'UNEX_EXEC_IMPRT_UDA_FUNC'

Line 2301: IF Nvl(x_return_status, FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS

2297: IF (PO_LOG.d_stmt) THEN
2298: PO_LOG.stmt(d_module, d_position,'x_return_status after IMPORT_UDA_ATTRS : '|| x_return_status);
2299: END IF;
2300:
2301: IF Nvl(x_return_status, FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS
2302: THEN
2303: l_invalid_line_count := l_invalid_line_count + 1;
2304: END IF;
2305: END LOOP;

Line 2315: x_return_status := FND_API.G_RET_STS_ERROR;

2311:
2312: --Return in case of error
2313: IF l_invalid_line_count > 0
2314: THEN
2315: x_return_status := FND_API.G_RET_STS_ERROR;
2316: RETURN;
2317: END IF;
2318:
2319:

Line 2329: x_return_status := FND_API.G_RET_STS_ERROR;

2325: IF (PO_LOG.d_exc) THEN
2326: PO_LOG.exc(d_module, d_position,' Validation for mandatory attributes failed ');
2327: END IF;
2328:
2329: x_return_status := FND_API.G_RET_STS_ERROR;
2330: x_msg_data := 'Mandatory UDA attributes are missing';
2331: RETURN ;
2332:
2333: END IF;