APPS.HZ_IMP_LOAD_CODE_ASSIGNMENTS dependencies on FND_API

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

77:
78: ************************************************/
79:
80: PROCEDURE validate_DSS_security IS
81: dss_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
82: dss_msg_count NUMBER := 0;
83: dss_msg_data VARCHAR2(2000):= null;
84: BEGIN
85:

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

230: l_identical_classcode_errors(j),
231: l_multi_assign_errors(j),
232: 'Y',
233: l_start_date_errors(j),
234: decode(l_dss_security_errors(j), FND_API.G_TRUE,'Y',null),
235: 'Y',
236: l_exception_exists(j)
237: from dual
238: where l_num_row_processed(j) = 0

Line 608: x_return_status := FND_API.G_RET_STS_SUCCESS;

604:
605: FND_MSG_PUB.initialize;
606:
607: --Initialize API return status to success.
608: x_return_status := FND_API.G_RET_STS_SUCCESS;
609:
610: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_BATCH_ID'||P_BATCH_ID);
611: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_wu_os'||p_wu_os);
612: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_from_osr'||p_from_osr);

Line 1046: x_return_status := FND_API.G_RET_STS_ERROR;

1042: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Insert code assignment dup val exception: ' || SQLERRM);
1043: ROLLBACK to process_insert_codeassigns_pvt;
1044:
1045: populate_error_table(P_DML_RECORD, 'Y', SQLERRM);
1046: x_return_status := FND_API.G_RET_STS_ERROR;
1047:
1048: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1049: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1050: FND_MSG_PUB.ADD;

Line 1057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1053: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Insert code assignment other exception: ' || SQLERRM);
1054: ROLLBACK to process_insert_codeassigns_pvt;
1055:
1056: populate_error_table(P_DML_RECORD, 'N', SQLERRM);
1057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1058:
1059: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1060: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1061: FND_MSG_PUB.ADD;

Line 1166: x_return_status := FND_API.G_RET_STS_SUCCESS;

1162:
1163: FND_MSG_PUB.initialize;
1164:
1165: --Initialize API return status to success.
1166: x_return_status := FND_API.G_RET_STS_SUCCESS;
1167:
1168: IF P_DML_RECORD.RERUN = 'N' THEN
1169: -- First Run
1170: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'First run');

Line 1281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1277: ROLLBACK to process_update_codeassigns_pvt;
1278:
1279: populate_error_table(P_DML_RECORD, 'N', SQLERRM);
1280:
1281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1282:
1283: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1284: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1285: FND_MSG_PUB.ADD;

Line 1314: x_return_status := FND_API.G_RET_STS_SUCCESS;

1310: FND_MSG_PUB.initialize;
1311: FND_FILE.PUT_LINE(FND_FILE.LOG, 'load_code_assignments (+)');
1312:
1313: --Initialize API return status to success.
1314: x_return_status := FND_API.G_RET_STS_SUCCESS;
1315:
1316: l_no_end_date := TO_DATE('31-12-4712 00:00:01', 'DD-MM-YYYY HH24:MI:SS');
1317:
1318:

Line 1348: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1344: ,x_msg_count => x_msg_count
1345: ,x_msg_data => x_msg_data
1346: );
1347:
1348: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1349: return;
1350: END IF;
1351:
1352: process_update_code_assignment(