APPS.OKS_MASS_UPD_PVT dependencies on FND_API

Line 28: x_return_status := FND_API.G_RET_STS_SUCCESS;

24:
25: DELETE FROM oks_sublines_temp
26: WHERE dnz_chr_id = p_contract_id;
27:
28: x_return_status := FND_API.G_RET_STS_SUCCESS;
29: EXCEPTION
30: WHEN OTHERS
31: THEN
32: x_return_status := FND_API.G_RET_STS_ERROR;

Line 32: x_return_status := FND_API.G_RET_STS_ERROR;

28: x_return_status := FND_API.G_RET_STS_SUCCESS;
29: EXCEPTION
30: WHEN OTHERS
31: THEN
32: x_return_status := FND_API.G_RET_STS_ERROR;
33: END DELETE_CONTRACT_DATA;
34:
35:
36: /*validate the status change related data*/

Line 944: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

940: 'Leaving mass_update_price_prc because of EXCEPTION: ' ||
941: sqlerrm);
942: END IF;
943:
944: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
945: --fnd_file.put_line (fnd_file.log,'Unexpected error in mass_update_price_prc: '||x_return_status||' sqlerrm: '||sqlerrm);
946:
947: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
948: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

Line 1528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1524: 'Leaving mass_update_status_prc because of EXCEPTION: ' ||
1525: sqlerrm);
1526: END IF;
1527:
1528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1529: --fnd_file.put_line (fnd_file.log,'Unexpected error in mass_update_status_prc: '||x_return_status||' sqlerrm: '||sqlerrm);
1530:
1531: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1532: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

Line 1996: /* IF NOT (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1992: END IF;
1993:
1994:
1995: -- Bug 5227077 --
1996: /* IF NOT (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1997: FOR a in 1 .. fnd_msg_pub.count_msg Loop
1998: fnd_msg_pub.get(p_msg_index => a,
1999: p_encoded => 'F',
2000: p_data => l_msg_data,

Line 2022: p_encoded => fnd_api.g_false);

2018: p_token1 => 'Line No ',
2019: p_token1_value => l_line_number);
2020:
2021: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
2022: p_encoded => fnd_api.g_false);
2023: x_msg_tbl(l_tot_msg_count).status := 'E';
2024: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
2025: l_tot_msg_count := l_tot_msg_count + 1;
2026: l_msg_data := NULL;

Line 2154: /* IF NOT (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

2150: l_err_mu_eff_tbl(l_err_eff_idx).error_msg := x_msg_data ;
2151: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2152: END IF;
2153: -- Bug 5227077 --
2154: /* IF NOT (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2155: FOR a in 1 .. fnd_msg_pub.count_msg Loop
2156: fnd_msg_pub.get(p_msg_index => a,
2157: p_encoded => 'F',
2158: p_data => l_msg_data,

Line 2180: p_encoded => fnd_api.g_false);

2176: p_token1 => 'Line No ',
2177: p_token1_value => l_line_number);
2178:
2179: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
2180: p_encoded => fnd_api.g_false);
2181: x_msg_tbl(l_tot_msg_count).status := 'E';
2182: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
2183: l_tot_msg_count := l_tot_msg_count + 1;
2184: l_msg_data := NULL;

Line 2577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2573: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2574: l_api_name, ' Error while updating line' || SQLERRM);
2575:
2576: END IF;
2577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2578: --fnd_file.put_line (fnd_file.log,'Unexpected error in mass_update_effectivity_prc: '||x_return_status|| ' SQLERRM: '||SQLERRM);
2579: END mass_update_effectivity_prc;
2580:
2581: /*functions to be used internally*/