APPS.HZ_IMP_LOAD_ORG_CONTACT_PKG dependencies on FND_API

Line 276: dss_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

272:
273: ************************************************/
274:
275: PROCEDURE validate_DSS_security IS
276: dss_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
277: dss_msg_count NUMBER := 0;
278: dss_msg_data VARCHAR2(2000):= null;
279: BEGIN
280:

Line 435: decode(l_dss_security_errors(j), FND_API.G_TRUE,'Y',null),

431: l_start_end_date_errors(j),
432: decode(l_flex_val_errors(j), 1, null, 'Y'),
433: 'Y',
434: l_dup_rel_errors(j),
435: decode(l_dss_security_errors(j), FND_API.G_TRUE,'Y',null),
436: l_start_date_errors(j),
437: 'Y',
438: 'Y',
439: l_exception_exists(j)

Line 1274: x_return_status := FND_API.G_RET_STS_SUCCESS;

1270:
1271: FND_MSG_PUB.initialize;
1272:
1273: --Initialize API return status to success.
1274: x_return_status := FND_API.G_RET_STS_SUCCESS;
1275:
1276: /*
1277: FND_FILE.PUT_LINE(FND_FILE.LOG, 'fetch data from cursor start ' || dbms_utility.get_time);
1278: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_no_end_date = ' || l_no_end_date);

Line 1413: x_return_status := FND_API.G_RET_STS_ERROR;

1409: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Insert contacts dup val exception: ' || SQLERRM);
1410: ROLLBACK to process_insert_contacts_pvt;
1411:
1412: populate_error_table(P_DML_RECORD, 'Y', SQLERRM);
1413: x_return_status := FND_API.G_RET_STS_ERROR;
1414:
1415: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1416: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1417: FND_MSG_PUB.ADD;

Line 1424: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1420: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Insert org contacts other exception: ' || SQLERRM);
1421: ROLLBACK to process_insert_contacts_pvt;
1422:
1423: populate_error_table(P_DML_RECORD, 'N', SQLERRM);
1424: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1425:
1426: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1427: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1428: FND_MSG_PUB.ADD;

Line 1618: x_return_status := FND_API.G_RET_STS_SUCCESS;

1614:
1615: FND_MSG_PUB.initialize;
1616:
1617: --Initialize API return status to success.
1618: x_return_status := FND_API.G_RET_STS_SUCCESS;
1619:
1620: IF P_DML_RECORD.RERUN = 'N' THEN
1621:
1622: -- First Run

Line 1970: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1966: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Other exceptions when updating hz_org_contacts');
1967: ROLLBACK to process_update_contacts_pvt;
1968:
1969: populate_error_table(P_DML_RECORD, 'N', SQLERRM);
1970: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1971:
1972: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1973: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1974: FND_MSG_PUB.ADD;

Line 2027: x_return_status := FND_API.G_RET_STS_SUCCESS;

2023: FND_MSG_PUB.initialize;
2024: FND_FILE.PUT_LINE(FND_FILE.LOG, 'load_org_contacts (+)');
2025:
2026: --Initialize API return status to success.
2027: x_return_status := FND_API.G_RET_STS_SUCCESS;
2028:
2029: l_no_end_date := TO_DATE('31-12-4712 00:00:01', 'DD-MM-YYYY HH24:MI:SS');
2030:
2031: process_insert_org_contacts(

Line 2038: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2034: ,x_msg_count => x_msg_count
2035: ,x_msg_data => x_msg_data
2036: );
2037:
2038: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2039: return;
2040: END IF;
2041:
2042: process_update_org_contacts(