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

Line 430: x_return_status := FND_API.G_RET_STS_SUCCESS;

426: )
427: );
428: d_progress := 200;
429: PON_UDA_IMPORT_PKG.DEBUG('After constructing Class codes Array with template id : ' || l_uda_template_id, d_progress);
430: x_return_status := FND_API.G_RET_STS_SUCCESS;
431: EXCEPTION
432: WHEN OTHERS THEN
433: l_err_txt := 'Exception in POPULATE_STRUCTURES with ERROR : ' || SQLERRM;
434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

430: x_return_status := FND_API.G_RET_STS_SUCCESS;
431: EXCEPTION
432: WHEN OTHERS THEN
433: l_err_txt := 'Exception in POPULATE_STRUCTURES with ERROR : ' || SQLERRM;
434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
435: PON_UDA_IMPORT_PKG.HANDLE_ERROR
436: (
437: p_msg => l_err_txt
438: ,p_msg_code => 'UNEXPECTED_POPULATE_STRUCTURES'

Line 679: x_return_status := FND_API.G_RET_STS_SUCCESS;

675: d_progress := 290;
676: END LOOP;
677: END IF;
678: d_progress := 300;
679: x_return_status := FND_API.G_RET_STS_SUCCESS;
680: EXCEPTION
681: WHEN OTHERS THEN
682: l_err_txt := 'Exception in POPULATE_REMAINING_ATTRIBUTES with ERROR : ' || SQLERRM;
683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

679: x_return_status := FND_API.G_RET_STS_SUCCESS;
680: EXCEPTION
681: WHEN OTHERS THEN
682: l_err_txt := 'Exception in POPULATE_REMAINING_ATTRIBUTES with ERROR : ' || SQLERRM;
683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
684: PON_UDA_IMPORT_PKG.HANDLE_ERROR
685: (
686: p_msg => l_err_txt
687: ,p_msg_code => 'UNEXPECTED_POPULATE_REMAINING_ATTRIBUTES'

Line 1139: x_return_status := FND_API.G_RET_STS_SUCCESS;

1135: d_progress := 760;
1136: PON_UDA_IMPORT_PKG.DEBUG('USAGE object array does not have any objects', d_progress);
1137: END IF;
1138: d_progress := 770;
1139: x_return_status := FND_API.G_RET_STS_SUCCESS;
1140: EXCEPTION
1141: WHEN OTHERS THEN
1142: l_err_txt := 'Exception in POPULATE_EMPTY_AGS with ERROR : ' || SQLERRM;
1143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1139: x_return_status := FND_API.G_RET_STS_SUCCESS;
1140: EXCEPTION
1141: WHEN OTHERS THEN
1142: l_err_txt := 'Exception in POPULATE_EMPTY_AGS with ERROR : ' || SQLERRM;
1143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1144: PON_UDA_IMPORT_PKG.HANDLE_ERROR
1145: (
1146: p_msg => l_err_txt
1147: ,p_msg_code => 'UNEXPECTED_POPULATE_EMPTY_AGS'

Line 1295: x_return_status := FND_API.G_RET_STS_SUCCESS;

1291: PON_UDA_IMPORT_PKG.DEBUG(x_attr_name_value_pairs, d_progress);
1292: PON_UDA_IMPORT_PKG.DEBUG('x_attributes_row_table is as follows', d_progress);
1293: PON_UDA_IMPORT_PKG.DEBUG(x_attributes_row_table, d_progress);
1294:
1295: x_return_status := FND_API.G_RET_STS_SUCCESS;
1296: g_uda_return_status := FND_API.G_RET_STS_SUCCESS;
1297: IF (x_attributes_row_table IS NOT NULL AND x_attributes_row_table.COUNT > 0) THEN
1298: d_progress := 20;
1299: l_attr_group_id_index := x_attributes_row_table.FIRST;

Line 1296: g_uda_return_status := FND_API.G_RET_STS_SUCCESS;

1292: PON_UDA_IMPORT_PKG.DEBUG('x_attributes_row_table is as follows', d_progress);
1293: PON_UDA_IMPORT_PKG.DEBUG(x_attributes_row_table, d_progress);
1294:
1295: x_return_status := FND_API.G_RET_STS_SUCCESS;
1296: g_uda_return_status := FND_API.G_RET_STS_SUCCESS;
1297: IF (x_attributes_row_table IS NOT NULL AND x_attributes_row_table.COUNT > 0) THEN
1298: d_progress := 20;
1299: l_attr_group_id_index := x_attributes_row_table.FIRST;
1300: d_progress := 30;

Line 1407: IF uda_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1403: PON_UDA_IMPORT_PKG.GET_EXT_ATTR_NAME_VALUE_PAIR('x_msg_data', x_external_attr_value_pairs, ext_name_val_obj);
1404: uda_msg_data := ext_name_val_obj.VALUE ;
1405:
1406: d_progress := 260;
1407: IF uda_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1408: g_uda_return_status := uda_return_status;
1409: END IF;
1410:
1411: d_progress := 270;

Line 1412: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1408: g_uda_return_status := uda_return_status;
1409: END IF;
1410:
1411: d_progress := 270;
1412: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1413: d_progress := 280;
1414: EXIT;
1415: END IF;
1416:

Line 1469: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1465: x_return_status := ext_name_val_obj.VALUE ;
1466: PON_UDA_IMPORT_PKG.DEBUG('Return status for action is ' || x_return_status, d_progress);
1467:
1468: d_progress := 420;
1469: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1470: d_progress := 43;
1471: PON_UDA_IMPORT_PKG.HANDLE_ERROR
1472: (
1473: p_msg => 'There was an error in EXECUTE_IMPORT_UDA_FUNCTION for Action ID :' || l_action_id

Line 1510: IF g_uda_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1506: d_progress := 530;
1507: END LOOP;
1508: CLOSE c_get_action_id;
1509:
1510: IF g_uda_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1511: d_progress := 540;
1512: PON_UDA_IMPORT_PKG.DEBUG('g_uda_return_status is a failure', d_progress);
1513: PON_UDA_IMPORT_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_return_status', g_uda_return_status, x_external_attr_value_pairs);
1514: END IF;

Line 1516: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1512: PON_UDA_IMPORT_PKG.DEBUG('g_uda_return_status is a failure', d_progress);
1513: PON_UDA_IMPORT_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_return_status', g_uda_return_status, x_external_attr_value_pairs);
1514: END IF;
1515: d_progress := 550;
1516: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1517: PON_UDA_IMPORT_PKG.DEBUG('x_return_status is a failure', d_progress);
1518: d_progress := 560;
1519: EXIT;
1520: END IF;

Line 1528: x_return_status := FND_API.G_RET_STS_SUCCESS;

1524: l_attr_group_id_index := x_attributes_row_table.NEXT(l_attr_group_id_index);
1525: END LOOP;
1526: IF x_return_status IS NULL THEN
1527: d_progress := 600;
1528: x_return_status := FND_API.G_RET_STS_SUCCESS;
1529: END IF;
1530: d_progress := 610;
1531: END IF;
1532:

Line 1536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1532:
1533: EXCEPTION
1534: WHEN OTHERS THEN
1535: l_err_txt := 'Exception in EXECUTE_IMPORT_UDA_FUNCTION with ERROR : ' || SQLERRM;
1536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1537: PON_UDA_IMPORT_PKG.HANDLE_ERROR
1538: (
1539: p_msg => l_err_txt
1540: ,p_msg_code => 'UNEXPECTED_EXECUTE_IMPORT_UDA_FUNCTION'

Line 1668: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1664: PON_UDA_IMPORT_PKG.DEBUG('x_msg_count ' || x_msg_count, d_progress);
1665: PON_UDA_IMPORT_PKG.DEBUG('x_msg_data ' || x_msg_data, d_progress);
1666:
1667: PON_UDA_IMPORT_PKG.DEBUG('Template ID is :: ' || l_class_code_name_value_pairs(l_class_code_name_value_pairs.FIRST).VALUE, d_progress);
1668: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1669: d_progress := 70;
1670: PON_UDA_IMPORT_PKG.DEBUG('Before POPULATE_REMAINING_ATTRIBUTES ' || x_return_status, d_progress);
1671: PON_UDA_IMPORT_PKG.DEBUG(l_attr_name_value_pairs, d_progress);
1672:

Line 1712: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1708: );
1709: d_progress := 110;
1710: END IF;
1711: d_progress := 120;
1712: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1713: d_progress := 130;
1714: PON_UDA_IMPORT_PKG.DEBUG('Before POPULATE_EMPTY_AGS ' || x_return_status, d_progress);
1715: PON_UDA_IMPORT_PKG.POPULATE_EMPTY_AGS
1716: (

Line 1756: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1752: );
1753: d_progress := 170;
1754: END IF;
1755:
1756: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1757: d_progress := 180;
1758: PON_UDA_IMPORT_PKG.UPDATE_STATUS
1759: (
1760: p_process_status => PON_UDA_IMPORT_PKG.IN_PROGRESS

Line 1817: /*IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1813: );
1814: d_progress := 230;
1815: END IF;
1816:
1817: /*IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1818: d_progress := 240;
1819: PON_UDA_IMPORT_PKG.DEBUG('Before EXECUTE_IMPORT_UDA_FUNCTION (XLE) ' || x_return_status, d_progress);
1820: PON_UDA_IMPORT_PKG.EXECUTE_IMPORT_UDA_FUNCTION
1821: (

Line 1861: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1857: );
1858: d_progress := 280;
1859: END IF;*/
1860:
1861: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1862: d_progress := 290;
1863: PON_UDA_IMPORT_PKG.UPDATE_STATUS
1864: (
1865: p_process_status => PON_UDA_IMPORT_PKG.IN_PROGRESS

Line 1898: ,p_validate_only => FND_API.G_TRUE

1894: ,p_attributes_row_table => l_attributes_row_table
1895: ,p_attributes_data_table => l_attr_name_value_pairs
1896: ,p_pk_column_name_value_pairs => l_pk_column_name_value_pairs
1897: ,p_class_code_name_value_pairs => l_class_code_name_value_pairs
1898: ,p_validate_only => FND_API.G_TRUE
1899: ,x_failed_row_id_list => l_failed_row_id_list
1900: ,x_return_status => x_return_status
1901: ,x_errorcode => x_errorcode
1902: ,x_msg_count => x_msg_count

Line 1936: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1932: );
1933: d_progress := 360;
1934: END IF;
1935: d_progress := 370;
1936: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1937: d_progress := 380;
1938:
1939: PON_UDA_IMPORT_PKG.UPDATE_STATUS
1940: (

Line 2008: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

2004: );
2005: d_progress := 470;
2006: END IF;
2007:
2008: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2009: d_progress := 560;
2010: PON_UDA_IMPORT_PKG.DEBUG('Before EXECUTE_IMPORT_UDA_FUNCTION (XPD) ' || x_return_status, d_progress);
2011: IF l_attributes_row_table.COUNT > 0 THEN
2012: d_progress := 570;

Line 2059: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

2055: );
2056: d_progress := 620;
2057: END IF;
2058:
2059: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2060: d_progress := 480;
2061:
2062: PON_UDA_IMPORT_PKG.UPDATE_STATUS
2063: (

Line 2134: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

2130: );
2131: d_progress := 550;
2132: END IF;
2133:
2134: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2135: d_progress := 560;
2136: PON_UDA_IMPORT_PKG.DEBUG('Before EXECUTE_IMPORT_UDA_FUNCTION (XPD) ' || x_return_status, d_progress);
2137: IF l_attributes_row_table.COUNT > 0 THEN
2138: d_progress := 570;

Line 2185: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

2181: );
2182: d_progress := 620;
2183: END IF;
2184: d_progress := 630;
2185: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2186: d_progress := 640;
2187: PON_UDA_IMPORT_PKG.UPDATE_STATUS
2188: (
2189: p_process_status => PON_UDA_IMPORT_PKG.COMPLETED

Line 2204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2200:
2201: EXCEPTION
2202: WHEN OTHERS THEN
2203: l_err_txt := 'Exception in IMPORT_UDA_ATTRS with ERROR : ' || SQLERRM;
2204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2205:
2206: UPDATE PO_UDA_INTERFACE
2207: SET PK1_VALUE = NULL, PK2_VALUE=NULL, PROCESS_STATUS = 1, PROCESS_PHASE = NULL
2208: WHERE PK1_VALUE = p_pk1_value;