DBA Data[Home] [Help]

APPS.ARI_SELF_REGISTRATION_PKG dependencies on FND_API

Line 226: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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

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

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

Line 282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 377: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 378: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 382: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 915: p_init_msg_list => FND_API.G_FALSE,

911: p_cust_account_role_rec_type.status := 'I'; --Inactive
912: --p_cust_account_role_rec_type.end_date := sysdate;
913:
914: HZ_CUST_ACCOUNT_ROLE_V2PUB.update_cust_account_role (
915: p_init_msg_list => FND_API.G_FALSE,
916: p_cust_account_role_rec => p_cust_account_role_rec_type,
917: p_object_version_number => l_object_version_number,
918: x_return_status => l_return_status,
919: x_msg_count => l_msg_count,

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

919: x_msg_count => l_msg_count,
920: x_msg_data => l_msg_data);
921:
922: x_return_status := l_return_status;
923: --IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
924: -- RETURN;
925: --END IF;
926:
927: END LOOP;

Line 933: x_return_status := FND_API.G_RET_STS_ERROR;

929: COMMIT;
930:
931: EXCEPTION
932: WHEN OTHERS THEN
933: x_return_status := FND_API.G_RET_STS_ERROR;
934: ROLLBACK TO RemoveAccessStart;
935: END RemoveRoleAccess;
936:
937: /* =======================================================================

Line 1158: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

1154: IF (PG_DEBUG = 'Y') THEN
1155: arp_standard.debug(l_debug_info);
1156: END IF;
1157:
1158: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
1159: ----------------------------------------------------------------------------
1160: l_debug_info := 'Completed Hz_party_v2_pub.createperson: Message'||X_Msg_Data;
1161: ----------------------------------------------------------------------------
1162: IF (PG_DEBUG = 'Y') THEN

Line 1165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1161: ----------------------------------------------------------------------------
1162: IF (PG_DEBUG = 'Y') THEN
1163: arp_standard.debug(l_debug_info);
1164: END IF;
1165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1166: end if;
1167:
1168: ----------------------------------------------------------------------------
1169: l_debug_info := 'After creating person party, if this is an Additional Access flow,

Line 1493: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

1489: x_msg_count => X_Msg_Count,
1490: x_msg_data => X_Msg_data
1491: );
1492:
1493: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
1494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1495: end if;
1496:
1497: END IF;

Line 1494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1490: x_msg_data => X_Msg_data
1491: );
1492:
1493: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
1494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1495: end if;
1496:
1497: END IF;
1498:

Line 1641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1637:
1638: EXCEPTION
1639: WHEN TOO_MANY_ROWS THEN
1640: --Not possible
1641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1642: WHEN OTHERS THEN
1643: NULL;
1644: END;
1645: ----------------------------------------------------------------------------

Line 1703: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

1699: IF (PG_DEBUG = 'Y') THEN
1700: arp_standard.debug(l_debug_info);
1701: END IF;
1702:
1703: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
1704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1705: end if;
1706:
1707: end if; --mail address not null

Line 1704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1700: arp_standard.debug(l_debug_info);
1701: END IF;
1702:
1703: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
1704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1705: end if;
1706:
1707: end if; --mail address not null
1708:

Line 1748: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1744: AND contact_point_type = 'PHONE';
1745: EXCEPTION
1746: WHEN TOO_MANY_ROWS THEN
1747: --Not possible
1748: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1749: WHEN OTHERS THEN
1750: NULL;
1751: END;
1752:

Line 1808: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

1804: IF (PG_DEBUG = 'Y') THEN
1805: arp_standard.debug(l_debug_info);
1806: END IF;
1807:
1808: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
1809: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1810: end if;
1811:
1812: end if;

Line 1809: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1805: arp_standard.debug(l_debug_info);
1806: END IF;
1807:
1808: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
1809: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1810: end if;
1811:
1812: end if;
1813:

Line 1948: p_init_msg_list => FND_API.G_TRUE,

1944: l_cust_acct_roles_rec.cust_account_role_id := p_cust_acct_role_id;
1945: l_cust_acct_roles_rec.status := 'A';
1946:
1947: HZ_CUST_ACCOUNT_ROLE_V2PUB.update_cust_account_role (
1948: p_init_msg_list => FND_API.G_TRUE,
1949: p_cust_account_role_rec => l_cust_acct_roles_rec,
1950: x_return_status => l_return_status,
1951: x_msg_count => l_msg_count,
1952: x_msg_data => l_msg_data,

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

1951: x_msg_count => l_msg_count,
1952: x_msg_data => l_msg_data,
1953: p_object_version_number => l_version_number);
1954:
1955: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1956:
1957: ----------------------------------------------------------------------
1958: l_debug_info := 'Error Calling HZ Update Cust Acct Roles API: ' || l_msg_data;
1959: ----------------------------------------------------------------------

Line 1963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1959: ----------------------------------------------------------------------
1960: IF (PG_DEBUG = 'Y') THEN
1961: arp_standard.debug(l_debug_info);
1962: END IF;
1963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1964:
1965: END IF;
1966: END IF;
1967: EXCEPTION

Line 1997: p_init_msg_list => FND_API.G_TRUE,

1993: IF (PG_DEBUG = 'Y') THEN
1994: arp_standard.debug(l_debug_info);
1995: END IF;
1996: HZ_CUST_ACCOUNT_ROLE_V2PUB.Create_Cust_Account_Role(
1997: p_init_msg_list => FND_API.G_TRUE,
1998: p_cust_account_role_rec => l_cust_acct_roles_rec,
1999: x_return_status => l_return_status,
2000: x_msg_count => l_msg_count,
2001: x_msg_data => l_msg_data,

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

2000: x_msg_count => l_msg_count,
2001: x_msg_data => l_msg_data,
2002: x_cust_account_role_id => l_cust_acct_role_id);
2003:
2004: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2005: ----------------------------------------------------------------------
2006: l_debug_info := 'Return cust acct role id';
2007: ----------------------------------------------------------------------
2008: IF (PG_DEBUG = 'Y') THEN

Line 2026: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2022: ----------------------------------------------------------------------
2023: IF (PG_DEBUG = 'Y') THEN
2024: arp_standard.debug(l_debug_info);
2025: END IF;
2026: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2027:
2028: END IF;
2029:
2030: END IF;

Line 2134: p_init_msg_list => FND_API.G_TRUE,

2130: IF (PG_DEBUG = 'Y') THEN
2131: arp_standard.debug(l_debug_info);
2132: END IF;
2133: HZ_CUST_ACCOUNT_ROLE_V2PUB.create_role_responsibility(
2134: p_init_msg_list => FND_API.G_TRUE,
2135: p_role_responsibility_rec => l_role_resp_rec,
2136: x_return_status => l_return_status,
2137: x_msg_count => l_msg_count,
2138: x_msg_data => l_msg_data,

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

2137: x_msg_count => l_msg_count,
2138: x_msg_data => l_msg_data,
2139: x_responsibility_id => l_responsibility_id);
2140:
2141: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2142: ----------------------------------------------------------------------
2143: l_debug_info := 'Return role responsibility id';
2144: ----------------------------------------------------------------------
2145: IF (PG_DEBUG = 'Y') THEN

Line 2162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2158: ----------------------------------------------------------------------
2159: IF (PG_DEBUG = 'Y') THEN
2160: arp_standard.debug(l_debug_info);
2161: END IF;
2162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2163:
2164: END IF;
2165:
2166: END IF;

Line 2328: IF x_return_status <> FND_API.G_RET_STS_SUCCESS then

2324: x_msg_count => x_msg_count,
2325: x_msg_data => x_msg_data
2326: );
2327:
2328: IF x_return_status <> FND_API.G_RET_STS_SUCCESS then
2329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2330: END IF;
2331: END IF;
2332:

Line 2329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2325: x_msg_data => x_msg_data
2326: );
2327:
2328: IF x_return_status <> FND_API.G_RET_STS_SUCCESS then
2329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2330: END IF;
2331: END IF;
2332:
2333: ----------------------------------------------------------------------------

Line 3472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3468: ELSE
3469: --------------------------------------------------------------------
3470: l_debug_info := 'Invalid Mode passed to OpenRegistrationCur ' || p_mode;
3471: --------------------------------------------------------------------
3472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3473: END IF;
3474: --------------------------------------------------------------------
3475: l_debug_info := 'In debug mode, log we have exited this procedure';
3476: --------------------------------------------------------------------