DBA Data[Home] [Help]

APPS.RCV_CALL_LCM_WS dependencies on FND_API

Line 94: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.get (i, FND_API.g_false) );

90: -- /Bug 9411154
91: ELSIF l_msg_count > 1 THEN
92: FOR i IN 1 ..l_msg_count
93: LOOP
94: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.get (i, FND_API.g_false) );
95: END LOOP;
96: x_retcode := 1;
97: -- Bug 9411154
98: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', 'Warning');

Line 104: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

100: -- /Bug 9411154
101: END IF;
102:
103: -- If any errors happen abort the process.
104: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
105: RAISE FND_API.G_EXC_ERROR;
106: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
108: END IF;

Line 105: RAISE FND_API.G_EXC_ERROR;

101: END IF;
102:
103: -- If any errors happen abort the process.
104: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
105: RAISE FND_API.G_EXC_ERROR;
106: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
108: END IF;
109: END IF;

Line 106: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

102:
103: -- If any errors happen abort the process.
104: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
105: RAISE FND_API.G_EXC_ERROR;
106: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
108: END IF;
109: END IF;
110:

Line 107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

103: -- If any errors happen abort the process.
104: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
105: RAISE FND_API.G_EXC_ERROR;
106: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
108: END IF;
109: END IF;
110:
111: asn_debug.put_line('before closing the RSH cursor');

Line 150: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.get (i, FND_API.g_false) );

146: -- /Bug 9411154
147: ELSIF l_msg_count > 1 THEN
148: FOR i IN 1 ..l_msg_count
149: LOOP
150: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.get (i, FND_API.g_false) );
151: END LOOP;
152: x_retcode := 1;
153: -- Bug 9411154
154: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', 'Warning');

Line 160: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

156: -- /Bug 9411154
157: END IF;
158:
159: -- If any errors happen abort the process.
160: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
161: RAISE FND_API.G_EXC_ERROR;
162: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
164: END IF;

Line 161: RAISE FND_API.G_EXC_ERROR;

157: END IF;
158:
159: -- If any errors happen abort the process.
160: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
161: RAISE FND_API.G_EXC_ERROR;
162: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
164: END IF;
165: END IF;

Line 162: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

158:
159: -- If any errors happen abort the process.
160: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
161: RAISE FND_API.G_EXC_ERROR;
162: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
164: END IF;
165: END IF;
166:

Line 163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

159: -- If any errors happen abort the process.
160: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
161: RAISE FND_API.G_EXC_ERROR;
162: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
164: END IF;
165: END IF;
166:
167: asn_debug.put_line('before closing the RHI cursor');

Line 173: WHEN FND_API.G_EXC_ERROR THEN

169: CLOSE c_rhi_rti;
170: END IF;
171:
172: EXCEPTION
173: WHEN FND_API.G_EXC_ERROR THEN
174: IF c_rsh_rti%ISOPEN THEN
175: CLOSE c_rsh_rti;
176: END IF;
177: IF c_rhi_rti%ISOPEN THEN

Line 182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

178: CLOSE c_rhi_rti;
179: END IF;
180: asn_debug.put_line('the error is: ' || sqlcode ||' '||substr(SQLERRM, 1, 1000));
181: x_retcode := 1;
182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
183: IF c_rsh_rti%ISOPEN THEN
184: CLOSE c_rsh_rti;
185: END IF;
186: IF c_rhi_rti%ISOPEN THEN