DBA Data[Home] [Help]

APPS.OKL_LTE_PLCY_WRAP_PUB dependencies on FND_API

Line 47: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

43: ,p_lpov_rec => lp_lpov_rec
44: ,x_lpov_rec => lx_lpov_rec);
45:
46:
47: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
48: RAISE FND_API.G_EXC_ERROR;
49: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
50: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
51: END IF;

Line 48: RAISE FND_API.G_EXC_ERROR;

44: ,x_lpov_rec => lx_lpov_rec);
45:
46:
47: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
48: RAISE FND_API.G_EXC_ERROR;
49: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
50: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
51: END IF;
52:

Line 49: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

45:
46:
47: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
48: RAISE FND_API.G_EXC_ERROR;
49: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
50: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
51: END IF;
52:
53: --Copy value of OUT variable in the IN record type

Line 50: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

46:
47: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
48: RAISE FND_API.G_EXC_ERROR;
49: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
50: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
51: END IF;
52:
53: --Copy value of OUT variable in the IN record type
54: lp_lpov_rec := lx_lpov_rec;

Line 67: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

63: ,x_msg_data => l_msg_data
64: ,p_lpo_id => lp_lpov_rec.id);
65:
66:
67: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
68: RAISE FND_API.G_EXC_ERROR;
69: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
70: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
71: END IF;

Line 68: RAISE FND_API.G_EXC_ERROR;

64: ,p_lpo_id => lp_lpov_rec.id);
65:
66:
67: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
68: RAISE FND_API.G_EXC_ERROR;
69: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
70: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
71: END IF;
72:

Line 69: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

65:
66:
67: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
68: RAISE FND_API.G_EXC_ERROR;
69: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
70: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
71: END IF;
72:
73: --Assign value to OUT variables

Line 70: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

66:
67: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
68: RAISE FND_API.G_EXC_ERROR;
69: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
70: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
71: END IF;
72:
73: --Assign value to OUT variables
74: x_lpov_rec := lx_lpov_rec;

Line 81: WHEN FND_API.G_EXC_ERROR THEN

77: x_msg_data := l_msg_data ;
78:
79: EXCEPTION
80:
81: WHEN FND_API.G_EXC_ERROR THEN
82: ROLLBACK TO late_policies_create;
83: x_return_status := FND_API.G_RET_STS_ERROR;
84: x_msg_count := l_msg_count ;
85: x_msg_data := l_msg_data ;

Line 83: x_return_status := FND_API.G_RET_STS_ERROR;

79: EXCEPTION
80:
81: WHEN FND_API.G_EXC_ERROR THEN
82: ROLLBACK TO late_policies_create;
83: x_return_status := FND_API.G_RET_STS_ERROR;
84: x_msg_count := l_msg_count ;
85: x_msg_data := l_msg_data ;
86: Fnd_Msg_Pub.count_and_get(
87: p_count => x_msg_count

Line 89: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

85: x_msg_data := l_msg_data ;
86: Fnd_Msg_Pub.count_and_get(
87: p_count => x_msg_count
88: ,p_data => x_msg_data);
89: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
90: ROLLBACK TO late_policies_create;
91: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
92: x_msg_count := l_msg_count ;
93: x_msg_data := l_msg_data ;

Line 91: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

87: p_count => x_msg_count
88: ,p_data => x_msg_data);
89: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
90: ROLLBACK TO late_policies_create;
91: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
92: x_msg_count := l_msg_count ;
93: x_msg_data := l_msg_data ;
94: Fnd_Msg_Pub.count_and_get(
95: p_count => x_msg_count

Line 99: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

95: p_count => x_msg_count
96: ,p_data => x_msg_data);
97: WHEN OTHERS THEN
98: ROLLBACK TO late_policies_create;
99: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
100: x_msg_count := l_msg_count ;
101: x_msg_data := l_msg_data ;
102: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_LTE_PLCY_WRAP_PUB','create_late_policies');
103: Fnd_Msg_Pub.count_and_get(

Line 154: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

150: x_msg_data => l_msg_data,
151: p_lpov_rec => lp_lpov_tbl(i),
152: x_lpov_rec => lx_lpov_tbl(i));
153:
154: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
155: RAISE FND_API.G_EXC_ERROR;
156: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
158: END IF;

Line 155: RAISE FND_API.G_EXC_ERROR;

151: p_lpov_rec => lp_lpov_tbl(i),
152: x_lpov_rec => lx_lpov_tbl(i));
153:
154: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
155: RAISE FND_API.G_EXC_ERROR;
156: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
158: END IF;
159:

Line 156: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

152: x_lpov_rec => lx_lpov_tbl(i));
153:
154: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
155: RAISE FND_API.G_EXC_ERROR;
156: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
158: END IF;
159:
160: EXIT WHEN (i = lp_lpov_tbl.LAST);

Line 157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

153:
154: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
155: RAISE FND_API.G_EXC_ERROR;
156: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
158: END IF;
159:
160: EXIT WHEN (i = lp_lpov_tbl.LAST);
161: i := lp_lpov_tbl.NEXT(i);

Line 181: WHEN FND_API.G_EXC_ERROR THEN

177:
178:
179: EXCEPTION
180:
181: WHEN FND_API.G_EXC_ERROR THEN
182: ROLLBACK TO late_policies_create;
183: x_return_status := FND_API.G_RET_STS_ERROR;
184: x_msg_count := l_msg_count ;
185: x_msg_data := l_msg_data ;

Line 183: x_return_status := FND_API.G_RET_STS_ERROR;

179: EXCEPTION
180:
181: WHEN FND_API.G_EXC_ERROR THEN
182: ROLLBACK TO late_policies_create;
183: x_return_status := FND_API.G_RET_STS_ERROR;
184: x_msg_count := l_msg_count ;
185: x_msg_data := l_msg_data ;
186: Fnd_Msg_Pub.count_and_get(
187: p_count => x_msg_count

Line 189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

185: x_msg_data := l_msg_data ;
186: Fnd_Msg_Pub.count_and_get(
187: p_count => x_msg_count
188: ,p_data => x_msg_data);
189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
190: ROLLBACK TO late_policies_create;
191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
192: x_msg_count := l_msg_count ;
193: x_msg_data := l_msg_data ;

Line 191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

187: p_count => x_msg_count
188: ,p_data => x_msg_data);
189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
190: ROLLBACK TO late_policies_create;
191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
192: x_msg_count := l_msg_count ;
193: x_msg_data := l_msg_data ;
194: Fnd_Msg_Pub.count_and_get(
195: p_count => x_msg_count

Line 199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

195: p_count => x_msg_count
196: ,p_data => x_msg_data);
197: WHEN OTHERS THEN
198: ROLLBACK TO late_policies_create;
199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
200: x_msg_count := l_msg_count ;
201: x_msg_data := l_msg_data ;
202: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_LTE_PLCY_WRAP_PUB','create_late_policies');
203: Fnd_Msg_Pub.count_and_get(