DBA Data[Home] [Help]

APPS.ARI_SELF_REGISTRATION_PKG dependencies on FND_API

Line 224: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

220: p_phone_country_code IN VARCHAR2 DEFAULT NULL,
221: p_area_code IN VARCHAR2 DEFAULT NULL,
222: p_phone_number IN VARCHAR2 DEFAULT NULL,
223: p_extension IN VARCHAR2 DEFAULT NULL,
224: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
225: p_reg_service_code IN VARCHAR2 DEFAULT 'FND_RESP|AR|ARI_EXTERNAL|STAND',
226: p_identity_verification_reqd IN VARCHAR2 DEFAULT NULL,
227: p_requested_username IN VARCHAR2 DEFAULT NULL,
228: p_justification IN VARCHAR2 DEFAULT NULL,

Line 252: IF (FND_API.to_Boolean(p_init_msg_list)) THEN

248: IF (PG_DEBUG = 'Y') THEN
249: arp_standard.debug(G_PKG_NAME || l_procedure_name || '+');
250: END IF;
251:
252: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
253: -----------------------------------------------------------------------
254: l_debug_info := 'Initialize message list if requested by calling api';
255: -----------------------------------------------------------------------
256: FND_MSG_PUB.initialize;

Line 280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

276: WHEN OTHERS THEN
277: FND_MESSAGE.SET_NAME ('AR','ARI_REG_PROCESS_TYPE_ERROR');
278: FND_MESSAGE.SET_TOKEN('REG_PROCESS', p_reg_service_code);
279: FND_MSG_PUB.ADD;
280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
281: END;
282:
283: --Reg Service Type should be SELF_SERVICE when calling from Collections
284: IF l_reg_service_type <> 'SELF_SERVICE' THEN

Line 288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

284: IF l_reg_service_type <> 'SELF_SERVICE' THEN
285: FND_MESSAGE.SET_NAME ('AR','ARI_REG_PROCESS_TYPE_ERROR');
286: FND_MESSAGE.SET_TOKEN('REG_PROCESS', p_reg_service_code);
287: FND_MSG_PUB.ADD;
288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
289: END IF;
290:
291: ----------------------------------------------------------------------------
292: l_debug_info := 'Set up UMX parameters';

Line 374: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

370: arp_standard.debug(G_PKG_NAME || l_procedure_name || '-');
371: END IF;
372:
373: EXCEPTION
374: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
375: x_return_status := FND_API.G_RET_STS_ERROR;
376: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
377: p_data => x_msg_data);
378: WHEN OTHERS THEN

Line 375: x_return_status := FND_API.G_RET_STS_ERROR;

371: END IF;
372:
373: EXCEPTION
374: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
375: x_return_status := FND_API.G_RET_STS_ERROR;
376: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
377: p_data => x_msg_data);
378: WHEN OTHERS THEN
379: x_return_status := FND_API.G_RET_STS_ERROR;

Line 379: x_return_status := FND_API.G_RET_STS_ERROR;

375: x_return_status := FND_API.G_RET_STS_ERROR;
376: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
377: p_data => x_msg_data);
378: WHEN OTHERS THEN
379: x_return_status := FND_API.G_RET_STS_ERROR;
380: IF (SQLCODE <> -20001) THEN
381: IF (PG_DEBUG = 'Y') THEN
382: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
383: arp_standard.debug('Debug Info: ' || l_debug_info);

Line 881: p_init_msg_list => FND_API.G_FALSE,

877: p_cust_account_role_rec_type.status := 'I'; --Inactive
878: --p_cust_account_role_rec_type.end_date := sysdate;
879:
880: HZ_CUST_ACCOUNT_ROLE_V2PUB.update_cust_account_role (
881: p_init_msg_list => FND_API.G_FALSE,
882: p_cust_account_role_rec => p_cust_account_role_rec_type,
883: p_object_version_number => l_object_version_number,
884: x_return_status => l_return_status,
885: x_msg_count => l_msg_count,

Line 889: --IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

885: x_msg_count => l_msg_count,
886: x_msg_data => l_msg_data);
887:
888: x_return_status := l_return_status;
889: --IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
890: -- RETURN;
891: --END IF;
892:
893: END LOOP;

Line 899: x_return_status := FND_API.G_RET_STS_ERROR;

895: COMMIT;
896:
897: EXCEPTION
898: WHEN OTHERS THEN
899: x_return_status := FND_API.G_RET_STS_ERROR;
900: ROLLBACK TO RemoveAccessStart;
901: END RemoveRoleAccess;
902:
903: /* =======================================================================

Line 1117: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

1113: IF (PG_DEBUG = 'Y') THEN
1114: arp_standard.debug(l_debug_info);
1115: END IF;
1116:
1117: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
1118: ----------------------------------------------------------------------------
1119: l_debug_info := 'Completed Hz_party_v2_pub.createperson: Message'||X_Msg_Data;
1120: ----------------------------------------------------------------------------
1121: IF (PG_DEBUG = 'Y') THEN

Line 1124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1120: ----------------------------------------------------------------------------
1121: IF (PG_DEBUG = 'Y') THEN
1122: arp_standard.debug(l_debug_info);
1123: END IF;
1124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1125: end if;
1126:
1127: ----------------------------------------------------------------------------
1128: l_debug_info := 'After creating person party, if this is an Additional Access flow,

Line 1394: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

1390: x_msg_count => X_Msg_Count,
1391: x_msg_data => X_Msg_data
1392: );
1393:
1394: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
1395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1396: end if;
1397:
1398: END IF;

Line 1395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1391: x_msg_data => X_Msg_data
1392: );
1393:
1394: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
1395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1396: end if;
1397:
1398: END IF;
1399:

Line 1526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1522: AND contact_point_type = 'EMAIL';
1523: EXCEPTION
1524: WHEN TOO_MANY_ROWS THEN
1525: --Not possible
1526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1527: WHEN OTHERS THEN
1528: NULL;
1529: END;
1530:

Line 1578: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

1574: IF (PG_DEBUG = 'Y') THEN
1575: arp_standard.debug(l_debug_info);
1576: END IF;
1577:
1578: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
1579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1580: end if;
1581:
1582: end if; --mail address not null

Line 1579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1575: arp_standard.debug(l_debug_info);
1576: END IF;
1577:
1578: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
1579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1580: end if;
1581:
1582: end if; --mail address not null
1583:

Line 1623: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1619: AND contact_point_type = 'PHONE';
1620: EXCEPTION
1621: WHEN TOO_MANY_ROWS THEN
1622: --Not possible
1623: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1624: WHEN OTHERS THEN
1625: NULL;
1626: END;
1627:

Line 1674: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

1670: IF (PG_DEBUG = 'Y') THEN
1671: arp_standard.debug(l_debug_info);
1672: END IF;
1673:
1674: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
1675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1676: end if;
1677:
1678: end if;

Line 1675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1671: arp_standard.debug(l_debug_info);
1672: END IF;
1673:
1674: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
1675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1676: end if;
1677:
1678: end if;
1679:

Line 1789: p_init_msg_list => FND_API.G_TRUE,

1785: l_cust_acct_roles_rec.cust_account_role_id := p_cust_acct_role_id;
1786: l_cust_acct_roles_rec.status := 'A';
1787:
1788: HZ_CUST_ACCOUNT_ROLE_V2PUB.update_cust_account_role (
1789: p_init_msg_list => FND_API.G_TRUE,
1790: p_cust_account_role_rec => l_cust_acct_roles_rec,
1791: x_return_status => l_return_status,
1792: x_msg_count => l_msg_count,
1793: x_msg_data => l_msg_data,

Line 1796: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1792: x_msg_count => l_msg_count,
1793: x_msg_data => l_msg_data,
1794: p_object_version_number => l_version_number);
1795:
1796: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1797:
1798: ----------------------------------------------------------------------
1799: l_debug_info := 'Error Calling HZ Update Cust Acct Roles API: ' || l_msg_data;
1800: ----------------------------------------------------------------------

Line 1801: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1797:
1798: ----------------------------------------------------------------------
1799: l_debug_info := 'Error Calling HZ Update Cust Acct Roles API: ' || l_msg_data;
1800: ----------------------------------------------------------------------
1801: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1802:
1803: END IF;
1804: END IF;
1805: EXCEPTION

Line 1832: p_init_msg_list => FND_API.G_TRUE,

1828: ------------------------------------------------------------------------
1829: l_debug_info := 'Call hz_cust_account_v2pub.Create_Cust_Acct_Roles';
1830: ------------------------------------------------------------------------
1831: HZ_CUST_ACCOUNT_ROLE_V2PUB.Create_Cust_Account_Role(
1832: p_init_msg_list => FND_API.G_TRUE,
1833: p_cust_account_role_rec => l_cust_acct_roles_rec,
1834: x_return_status => l_return_status,
1835: x_msg_count => l_msg_count,
1836: x_msg_data => l_msg_data,

Line 1839: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1835: x_msg_count => l_msg_count,
1836: x_msg_data => l_msg_data,
1837: x_cust_account_role_id => l_cust_acct_role_id);
1838:
1839: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1840: ----------------------------------------------------------------------
1841: l_debug_info := 'Return cust acct role id';
1842: ----------------------------------------------------------------------
1843: p_cust_acct_role_id := l_cust_acct_role_id;

Line 1849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1845:
1846: ----------------------------------------------------------------------
1847: l_debug_info := 'Error Calling HZ Create Cust Acct Roles API: ' || l_msg_data;
1848: ----------------------------------------------------------------------
1849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1850:
1851: END IF;
1852:
1853: END IF;

Line 1952: p_init_msg_list => FND_API.G_TRUE,

1948: IF (PG_DEBUG = 'Y') THEN
1949: arp_standard.debug(l_debug_info);
1950: END IF;
1951: HZ_CUST_ACCOUNT_ROLE_V2PUB.create_role_responsibility(
1952: p_init_msg_list => FND_API.G_TRUE,
1953: p_role_responsibility_rec => l_role_resp_rec,
1954: x_return_status => l_return_status,
1955: x_msg_count => l_msg_count,
1956: x_msg_data => l_msg_data,

Line 1959: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1955: x_msg_count => l_msg_count,
1956: x_msg_data => l_msg_data,
1957: x_responsibility_id => l_responsibility_id);
1958:
1959: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1960: ----------------------------------------------------------------------
1961: l_debug_info := 'Return role responsibility id';
1962: ----------------------------------------------------------------------
1963: IF (PG_DEBUG = 'Y') THEN

Line 1974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1970: ----------------------------------------------------------------------
1971: IF (PG_DEBUG = 'Y') THEN
1972: arp_standard.debug(l_debug_info);
1973: END IF;
1974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1975:
1976: END IF;
1977:
1978: END IF;

Line 2139: IF x_return_status <> FND_API.G_RET_STS_SUCCESS then

2135: x_msg_count => x_msg_count,
2136: x_msg_data => x_msg_data
2137: );
2138:
2139: IF x_return_status <> FND_API.G_RET_STS_SUCCESS then
2140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2141: END IF;
2142: END IF;
2143:

Line 2140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2136: x_msg_data => x_msg_data
2137: );
2138:
2139: IF x_return_status <> FND_API.G_RET_STS_SUCCESS then
2140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2141: END IF;
2142: END IF;
2143:
2144: ----------------------------------------------------------------------------