DBA Data[Home] [Help]

APPS.GMF_LC_ADJ_TRANSACTIONS_PKG dependencies on FND_API

Line 221: x_return_status := FND_API.G_RET_STS_SUCCESS;

217: fnd_file.put_line(fnd_file.log,'Entered Procedure: '||l_proc_name);
218: END IF;
219:
220: -- Initialize API return status to success
221: x_return_status := FND_API.G_RET_STS_SUCCESS;
222:
223: p_validation_status:='S';
224:
225: IF l_debug_level >= l_debug_level_high THEN

Line 710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

706: WHEN OTHERS THEN
707: IF l_debug_level >= l_debug_level_medium THEN
708: fnd_file.put_line(fnd_file.log,'Error: '||SQLERRM);
709: END IF;
710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
711: p_validation_status := 'F';
712:
713: END validate_adjustments;
714:

Line 752: x_return_status := FND_API.G_RET_STS_SUCCESS;

748:
749: BEGIN
750:
751: -- Initialize API return status to success
752: x_return_status := FND_API.G_RET_STS_SUCCESS;
753:
754: IF l_debug_level >= l_debug_level_medium THEN
755: fnd_file.put_line(fnd_file.log,'Entered Procedure: '||l_proc_name);
756: END IF;

Line 877: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

873: IF l_debug_level >= l_debug_level_medium THEN
874: fnd_file.put_line(fnd_file.log,'Error: '||SQLERRM);
875: fnd_file.put_line(fnd_file.log,'Failed to insert into adjsutment transactions table in '||l_proc_name);
876: END IF;
877: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
878: END Create_AdjTrxLines;
879:
880: /************************************************************************
881: NAME

Line 1257: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1253: p_validation_status => l_ret_status,
1254: x_return_status => l_return_status);
1255:
1256: -- If any errors happen abort the process.
1257: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1258: RAISE FND_API.G_EXC_ERROR;
1259: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1261: END IF;

Line 1258: RAISE FND_API.G_EXC_ERROR;

1254: x_return_status => l_return_status);
1255:
1256: -- If any errors happen abort the process.
1257: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1258: RAISE FND_API.G_EXC_ERROR;
1259: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1261: END IF;
1262:

Line 1259: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1255:
1256: -- If any errors happen abort the process.
1257: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1258: RAISE FND_API.G_EXC_ERROR;
1259: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1261: END IF;
1262:
1263: IF l_debug_level >= l_debug_level_medium THEN

Line 1260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1256: -- If any errors happen abort the process.
1257: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1258: RAISE FND_API.G_EXC_ERROR;
1259: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1261: END IF;
1262:
1263: IF l_debug_level >= l_debug_level_medium THEN
1264: fnd_file.put_line(fnd_file.log,'Validate Adjustments Return Status: ' || l_ret_status);

Line 1277: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1273: p_ledger_id => l_ledger_id,
1274: p_adjustment_row => l_adjustment_row,
1275: x_return_status => l_return_status);
1276: -- If any errors happen abort the process.
1277: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1278: RAISE FND_API.G_EXC_ERROR;
1279: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1281: END IF;

Line 1278: RAISE FND_API.G_EXC_ERROR;

1274: p_adjustment_row => l_adjustment_row,
1275: x_return_status => l_return_status);
1276: -- If any errors happen abort the process.
1277: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1278: RAISE FND_API.G_EXC_ERROR;
1279: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1281: END IF;
1282: l_total_adj := l_total_adj + 1;

Line 1279: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1275: x_return_status => l_return_status);
1276: -- If any errors happen abort the process.
1277: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1278: RAISE FND_API.G_EXC_ERROR;
1279: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1281: END IF;
1282: l_total_adj := l_total_adj + 1;
1283: ELSE

Line 1280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1276: -- If any errors happen abort the process.
1277: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1278: RAISE FND_API.G_EXC_ERROR;
1279: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1281: END IF;
1282: l_total_adj := l_total_adj + 1;
1283: ELSE
1284: l_total_ln_error := l_total_ln_error + 1;

Line 1328: WHEN FND_API.G_EXC_ERROR THEN

1324: WHEN utl_file.write_error then
1325: retcode := 3;
1326: errbuf := 'Write error - '||to_char(SQLCODE) || ' ' || SQLERRM;
1327: l_tmp := fnd_concurrent.set_completion_status('ERROR',sqlerrm || ' in ' || l_proc_name);
1328: WHEN FND_API.G_EXC_ERROR THEN
1329: retcode := 3;
1330: errbuf := 'An error has ocurred: ' || SQLERRM;
1331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1332: retcode := 3;

Line 1331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1327: l_tmp := fnd_concurrent.set_completion_status('ERROR',sqlerrm || ' in ' || l_proc_name);
1328: WHEN FND_API.G_EXC_ERROR THEN
1329: retcode := 3;
1330: errbuf := 'An error has ocurred: ' || SQLERRM;
1331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1332: retcode := 3;
1333: errbuf := 'An unexpected error has ocurred: ' || SQLERRM;
1334: WHEN others THEN
1335: retcode := 3;