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

Line 825: x_return_status := FND_API.G_RET_STS_SUCCESS;

821:
822: BEGIN
823:
824: -- Initialize API return status to success.
825: x_return_status := FND_API.G_RET_STS_SUCCESS;
826:
827: -- Choose the action to be performed
828:
829: new_party_sql := 'select int.party_id,int.party_orig_system,int.party_orig_system_reference '||

Line 878: x_return_status := FND_API.G_RET_STS_ERROR;

874: END IF;
875:
876: EXCEPTION
877: WHEN OTHERS THEN
878: x_return_status := FND_API.G_RET_STS_ERROR;
879:
880: END reg_action_on_party;
881:
882: /**

Line 932: x_return_status := FND_API.G_RET_STS_SUCCESS;

928:
929: BEGIN
930:
931: -- Initialize API return status to success.
932: x_return_status := FND_API.G_RET_STS_SUCCESS;
933:
934: -- Choose the action to be performed on sites
935:
936: new_site_sql := 'select int.site_orig_system,int.site_orig_system_reference '||

Line 973: x_return_status := FND_API.G_RET_STS_ERROR;

969: END IF;
970:
971: EXCEPTION
972: WHEN OTHERS THEN
973: x_return_status := FND_API.G_RET_STS_ERROR;
974: END reg_action_on_sites;
975:
976: /**
977: * PRIVATE PROCEDURE reg_action_on_cont

Line 1026: x_return_status := FND_API.G_RET_STS_SUCCESS;

1022:
1023: BEGIN
1024:
1025: -- Initialize API return status to success.
1026: x_return_status := FND_API.G_RET_STS_SUCCESS;
1027:
1028: -- Choose the action to be performed on sites
1029:
1030: new_cont_sql := 'select int.contact_orig_system,int.contact_orig_system_reference '||

Line 1067: x_return_status := FND_API.G_RET_STS_ERROR;

1063: END IF;
1064:
1065: EXCEPTION
1066: WHEN OTHERS THEN
1067: x_return_status := FND_API.G_RET_STS_ERROR;
1068: END reg_action_on_cont ;
1069:
1070:
1071: /**

Line 1120: x_return_status := FND_API.G_RET_STS_SUCCESS;

1116:
1117: BEGIN
1118:
1119: -- Initialize API return status to success.
1120: x_return_status := FND_API.G_RET_STS_SUCCESS;
1121:
1122: -- Choose the action to be performed on sites
1123:
1124: new_cpts_sql := 'select int.cp_orig_system,int.cp_orig_system_reference '||

Line 1161: x_return_status := FND_API.G_RET_STS_ERROR;

1157: END IF;
1158:
1159: EXCEPTION
1160: WHEN OTHERS THEN
1161: x_return_status := FND_API.G_RET_STS_ERROR;
1162: END reg_action_on_cpts ;
1163:
1164: /**
1165: * PRIVATE PROCEDURE reg_action_on_supents

Line 1208: x_return_status := FND_API.G_RET_STS_SUCCESS;

1204:
1205: BEGIN
1206:
1207: -- Initialize API return status to success.
1208: x_return_status := FND_API.G_RET_STS_SUCCESS;
1209:
1210: commit_counter := 1000;
1211:
1212: --// Site uses

Line 1254: x_return_status := FND_API.G_RET_STS_ERROR;

1250: END LOOP ;
1251:
1252: EXCEPTION
1253: WHEN OTHERS THEN
1254: x_return_status := FND_API.G_RET_STS_ERROR;
1255: END;
1256:
1257: --//CLASSIFICATIONS
1258:

Line 1300: x_return_status := FND_API.G_RET_STS_ERROR;

1296: END LOOP ;
1297:
1298: EXCEPTION
1299: WHEN OTHERS THEN
1300: x_return_status := FND_API.G_RET_STS_ERROR;
1301: END;
1302:
1303:
1304: --//Contact Roles

Line 1347: x_return_status := FND_API.G_RET_STS_ERROR;

1343: END LOOP ;
1344:
1345: EXCEPTION
1346: WHEN OTHERS THEN
1347: x_return_status := FND_API.G_RET_STS_ERROR;
1348: END;
1349:
1350: --//Relationships
1351:

Line 1393: x_return_status := FND_API.G_RET_STS_ERROR;

1389: END LOOP ;
1390:
1391: EXCEPTION
1392: WHEN OTHERS THEN
1393: x_return_status := FND_API.G_RET_STS_ERROR;
1394: END;
1395:
1396:
1397: END reg_action_on_supents;

Line 1444: x_return_status := FND_API.G_RET_STS_SUCCESS;

1440:
1441: BEGIN
1442:
1443: -- Initialize API return status to success.
1444: x_return_status := FND_API.G_RET_STS_SUCCESS;
1445:
1446: commit_counter := 1000;
1447:
1448: --// Financial Reports

Line 1491: x_return_status := FND_API.G_RET_STS_ERROR;

1487: END LOOP ;
1488:
1489: EXCEPTION
1490: WHEN OTHERS THEN
1491: x_return_status := FND_API.G_RET_STS_ERROR;
1492: END;
1493:
1494: --//Financial Numbers
1495: BEGIN

Line 1536: x_return_status := FND_API.G_RET_STS_ERROR;

1532: END LOOP ;
1533:
1534: EXCEPTION
1535: WHEN OTHERS THEN
1536: x_return_status := FND_API.G_RET_STS_ERROR;
1537: END;
1538:
1539:
1540: --//Credit Ratings

Line 1583: x_return_status := FND_API.G_RET_STS_ERROR;

1579: END LOOP ;
1580:
1581: EXCEPTION
1582: WHEN OTHERS THEN
1583: x_return_status := FND_API.G_RET_STS_ERROR;
1584: END;
1585:
1586: END reg_action_on_finents;
1587:

Line 1606: * be FND_API.G_RET_STS_SUCCESS (success),

1602: * p_batch_id Interface Batch ID.
1603: *
1604: * OUT:
1605: * x_return_status Return status after the call. The status can
1606: * be FND_API.G_RET_STS_SUCCESS (success),
1607: * FND_API.G_RET_STS_ERROR (error).
1608: * NOTES
1609: *
1610: * MODIFICATION HISTORY

Line 1607: * FND_API.G_RET_STS_ERROR (error).

1603: *
1604: * OUT:
1605: * x_return_status Return status after the call. The status can
1606: * be FND_API.G_RET_STS_SUCCESS (success),
1607: * FND_API.G_RET_STS_ERROR (error).
1608: * NOTES
1609: *
1610: * MODIFICATION HISTORY
1611: *

Line 1678: x_return_status := FND_API.G_RET_STS_SUCCESS;

1674: p_msg_level=>fnd_log.level_procedure);
1675: END IF;
1676:
1677: -- Initialize API return status to success.
1678: x_return_status := FND_API.G_RET_STS_SUCCESS;
1679:
1680: -- For entity= Party
1681: Begin
1682: Open select_party_rec( p_batch_id , 'PARTY' ) ;

Line 1885: x_return_status := FND_API.G_RET_STS_ERROR;

1881: END;
1882:
1883: EXCEPTION
1884: WHEN OTHERS THEN
1885: x_return_status := FND_API.G_RET_STS_ERROR;
1886:
1887: END clear_status;
1888:
1889: /**

Line 1913: * be FND_API.G_RET_STS_SUCCESS (success),

1909: * records in the interface tables.
1910: *
1911: * OUT:
1912: * x_return_status Return status after the call. The status can
1913: * be FND_API.G_RET_STS_SUCCESS (success),
1914: * FND_API.G_RET_STS_ERROR (error),
1915: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1916: * x_msg_count Number of messages in message stack.
1917: * x_msg_data Message text if x_msg_count is 1..

Line 1914: * FND_API.G_RET_STS_ERROR (error),

1910: *
1911: * OUT:
1912: * x_return_status Return status after the call. The status can
1913: * be FND_API.G_RET_STS_SUCCESS (success),
1914: * FND_API.G_RET_STS_ERROR (error),
1915: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1916: * x_msg_count Number of messages in message stack.
1917: * x_msg_data Message text if x_msg_count is 1..
1918: * NOTES

Line 1915: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

1911: * OUT:
1912: * x_return_status Return status after the call. The status can
1913: * be FND_API.G_RET_STS_SUCCESS (success),
1914: * FND_API.G_RET_STS_ERROR (error),
1915: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1916: * x_msg_count Number of messages in message stack.
1917: * x_msg_data Message text if x_msg_count is 1..
1918: * NOTES
1919: *

Line 1964: x_return_status := FND_API.G_RET_STS_SUCCESS;

1960: p_msg_level=>fnd_log.level_procedure);
1961: END IF;
1962:
1963: -- Initialize API return status to success.
1964: x_return_status := FND_API.G_RET_STS_SUCCESS;
1965: --3585887 Commented the code to fetch the previous actions.
1966: /*OPEN action( p_batch_id );
1967: FETCH action INTO
1968: l_action_on_parties,l_action_on_addresses,

Line 2014: x_return_status := FND_API.G_RET_STS_ERROR;

2010:
2011:
2012: EXCEPTION
2013: WHEN OTHERS THEN
2014: x_return_status := FND_API.G_RET_STS_ERROR;
2015:
2016: END batch_dedup_action;
2017:
2018: /**

Line 2051: * be FND_API.G_RET_STS_SUCCESS (success),

2047: * p_action_existing_finents Existing Finents,
2048: *
2049: * OUT:
2050: * x_return_status Return status after the call. The status can
2051: * be FND_API.G_RET_STS_SUCCESS (success),
2052: * FND_API.G_RET_STS_ERROR (error),
2053: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2054: * x_msg_count Number of messages in message stack.
2055: * x_msg_data Message text if x_msg_count is 1..

Line 2052: * FND_API.G_RET_STS_ERROR (error),

2048: *
2049: * OUT:
2050: * x_return_status Return status after the call. The status can
2051: * be FND_API.G_RET_STS_SUCCESS (success),
2052: * FND_API.G_RET_STS_ERROR (error),
2053: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2054: * x_msg_count Number of messages in message stack.
2055: * x_msg_data Message text if x_msg_count is 1..
2056: * NOTES

Line 2053: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

2049: * OUT:
2050: * x_return_status Return status after the call. The status can
2051: * be FND_API.G_RET_STS_SUCCESS (success),
2052: * FND_API.G_RET_STS_ERROR (error),
2053: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2054: * x_msg_count Number of messages in message stack.
2055: * x_msg_data Message text if x_msg_count is 1..
2056: * NOTES
2057: *

Line 2102: x_return_status := FND_API.G_RET_STS_SUCCESS;

2098: p_msg_level=>fnd_log.level_procedure);
2099: END IF;
2100:
2101: -- Initialize API return status to success.
2102: x_return_status := FND_API.G_RET_STS_SUCCESS;
2103:
2104: -- Choose the action to be performed on parties after registry de-duplication
2105: -- is done by DQM.
2106:

Line 2153: x_return_status := FND_API.G_RET_STS_ERROR;

2149:
2150:
2151: EXCEPTION
2152: WHEN OTHERS THEN
2153: x_return_status := FND_API.G_RET_STS_ERROR;
2154:
2155: END registry_dedup_action;
2156:
2157: /**

Line 2520: x_return_status := FND_API.G_RET_STS_ERROR;

2516: CLOSE sel_parties;
2517:
2518: EXCEPTION
2519: WHEN OTHERS THEN
2520: x_return_status := FND_API.G_RET_STS_ERROR;
2521: END action_on_parties;
2522:
2523: PROCEDURE action_on_sites(p_sql IN VARCHAR2,
2524: p_batch_id IN NUMBER,

Line 2613: x_return_status := FND_API.G_RET_STS_ERROR;

2609:
2610:
2611: EXCEPTION
2612: WHEN OTHERS THEN
2613: x_return_status := FND_API.G_RET_STS_ERROR;
2614: END action_on_sites;
2615:
2616: PROCEDURE action_on_contacts(p_sql IN VARCHAR2,
2617: p_batch_id IN NUMBER,

Line 2706: x_return_status := FND_API.G_RET_STS_ERROR;

2702:
2703:
2704: EXCEPTION
2705: WHEN OTHERS THEN
2706: x_return_status := FND_API.G_RET_STS_ERROR;
2707: END action_on_contacts;
2708:
2709: PROCEDURE action_on_contactpts(p_sql IN VARCHAR2,
2710: p_batch_id IN NUMBER,

Line 2791: x_return_status := FND_API.G_RET_STS_ERROR;

2787:
2788:
2789: EXCEPTION
2790: WHEN OTHERS THEN
2791: x_return_status := FND_API.G_RET_STS_ERROR;
2792: END action_on_contactpts ;
2793:
2794: END HZ_BATCH_ACTION_PUB;