eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_OPT_RUL_TMP_PUB dependencies on FND_API

Line 6: ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE

2: /* $Header: OKLPRTMB.pls 115.5 2004/04/13 11:03:27 rnaik noship $ */
3:
4: PROCEDURE insert_Opt_Rul_Tmp(
5: p_api_version IN NUMBER
6: ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE
7: ,x_return_status OUT NOCOPY VARCHAR2
8: ,x_msg_count OUT NOCOPY NUMBER
9: ,x_msg_data OUT NOCOPY VARCHAR2
10: ,p_ovd_id IN NUMBER

Line 51: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN

47: ,p_ovd_id
48: ,lp_rgrv_rec
49: ,lx_rgrv_rec);
50:
51: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
52: RAISE Fnd_Api.G_EXC_ERROR;
53: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
54: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
55: END IF;

Line 52: RAISE Fnd_Api.G_EXC_ERROR;

48: ,lp_rgrv_rec
49: ,lx_rgrv_rec);
50:
51: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
52: RAISE Fnd_Api.G_EXC_ERROR;
53: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
54: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
55: END IF;
56:

Line 53: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN

49: ,lx_rgrv_rec);
50:
51: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
52: RAISE Fnd_Api.G_EXC_ERROR;
53: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
54: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
55: END IF;
56:
57: --Copy value of OUT variable in the IN record type

Line 54: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

50:
51: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
52: RAISE Fnd_Api.G_EXC_ERROR;
53: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
54: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
55: END IF;
56:
57: --Copy value of OUT variable in the IN record type
58: lp_rgrv_rec := lx_rgrv_rec;

Line 72: WHEN Fnd_Api.G_EXC_ERROR THEN

68: x_msg_data := l_msg_data ;
69:
70: EXCEPTION
71:
72: WHEN Fnd_Api.G_EXC_ERROR THEN
73: ROLLBACK TO Opt_Rul_Tmp_insert;
74: x_return_status := Fnd_Api.G_RET_STS_ERROR;
75: x_msg_count := l_msg_count ;
76: x_msg_data := l_msg_data ;

Line 74: x_return_status := Fnd_Api.G_RET_STS_ERROR;

70: EXCEPTION
71:
72: WHEN Fnd_Api.G_EXC_ERROR THEN
73: ROLLBACK TO Opt_Rul_Tmp_insert;
74: x_return_status := Fnd_Api.G_RET_STS_ERROR;
75: x_msg_count := l_msg_count ;
76: x_msg_data := l_msg_data ;
77: Fnd_Msg_Pub.count_and_get(
78: p_count => x_msg_count

Line 80: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

76: x_msg_data := l_msg_data ;
77: Fnd_Msg_Pub.count_and_get(
78: p_count => x_msg_count
79: ,p_data => x_msg_data);
80: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
81: ROLLBACK TO Opt_Rul_Tmp_insert;
82: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
83: x_msg_count := l_msg_count ;
84: x_msg_data := l_msg_data ;

Line 82: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

78: p_count => x_msg_count
79: ,p_data => x_msg_data);
80: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
81: ROLLBACK TO Opt_Rul_Tmp_insert;
82: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
83: x_msg_count := l_msg_count ;
84: x_msg_data := l_msg_data ;
85: Fnd_Msg_Pub.count_and_get(
86: p_count => x_msg_count

Line 90: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

86: p_count => x_msg_count
87: ,p_data => x_msg_data);
88: WHEN OTHERS THEN
89: ROLLBACK TO Opt_Rul_Tmp_insert;
90: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
91: x_msg_count := l_msg_count ;
92: x_msg_data := l_msg_data ;
93: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_Opt_Rul_Tmp_PUB','insert_Opt_Rul_Tmp');
94: Fnd_Msg_Pub.count_and_get(

Line 101: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

97: END insert_Opt_Rul_Tmp;
98:
99: PROCEDURE insert_Opt_Rul_Tmp(
100: p_api_version IN NUMBER
101: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
102: ,x_return_status OUT NOCOPY VARCHAR2
103: ,x_msg_count OUT NOCOPY NUMBER
104: ,x_msg_data OUT NOCOPY VARCHAR2
105: ,p_ovd_id IN NUMBER

Line 143: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN

139: ,p_ovd_id
140: ,lp_rgrv_tbl
141: ,lx_rgrv_tbl);
142:
143: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
144: RAISE Fnd_Api.G_EXC_ERROR;
145: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
146: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
147: END IF;

Line 144: RAISE Fnd_Api.G_EXC_ERROR;

140: ,lp_rgrv_tbl
141: ,lx_rgrv_tbl);
142:
143: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
144: RAISE Fnd_Api.G_EXC_ERROR;
145: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
146: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
147: END IF;
148:

Line 145: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN

141: ,lx_rgrv_tbl);
142:
143: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
144: RAISE Fnd_Api.G_EXC_ERROR;
145: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
146: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
147: END IF;
148:
149: --Copy value of OUT variable in the IN record type

Line 146: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

142:
143: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
144: RAISE Fnd_Api.G_EXC_ERROR;
145: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
146: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
147: END IF;
148:
149: --Copy value of OUT variable in the IN record type
150: lp_rgrv_tbl := lx_rgrv_tbl;

Line 165: WHEN Fnd_Api.G_EXC_ERROR THEN

161:
162:
163: EXCEPTION
164:
165: WHEN Fnd_Api.G_EXC_ERROR THEN
166: ROLLBACK TO Opt_Rul_Tmp_insert;
167: x_return_status := Fnd_Api.G_RET_STS_ERROR;
168: x_msg_count := l_msg_count ;
169: x_msg_data := l_msg_data ;

Line 167: x_return_status := Fnd_Api.G_RET_STS_ERROR;

163: EXCEPTION
164:
165: WHEN Fnd_Api.G_EXC_ERROR THEN
166: ROLLBACK TO Opt_Rul_Tmp_insert;
167: x_return_status := Fnd_Api.G_RET_STS_ERROR;
168: x_msg_count := l_msg_count ;
169: x_msg_data := l_msg_data ;
170: Fnd_Msg_Pub.count_and_get(
171: p_count => x_msg_count

Line 173: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

169: x_msg_data := l_msg_data ;
170: Fnd_Msg_Pub.count_and_get(
171: p_count => x_msg_count
172: ,p_data => x_msg_data);
173: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
174: ROLLBACK TO Opt_Rul_Tmp_insert;
175: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
176: x_msg_count := l_msg_count ;
177: x_msg_data := l_msg_data ;

Line 175: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

171: p_count => x_msg_count
172: ,p_data => x_msg_data);
173: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
174: ROLLBACK TO Opt_Rul_Tmp_insert;
175: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
176: x_msg_count := l_msg_count ;
177: x_msg_data := l_msg_data ;
178: Fnd_Msg_Pub.count_and_get(
179: p_count => x_msg_count

Line 183: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

179: p_count => x_msg_count
180: ,p_data => x_msg_data);
181: WHEN OTHERS THEN
182: ROLLBACK TO Opt_Rul_Tmp_insert;
183: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
184: x_msg_count := l_msg_count ;
185: x_msg_data := l_msg_data ;
186: Fnd_Msg_Pub.ADD_EXC_MSG('Okl_Opt_Rul_Tmp_Pub','insert_Opt_Rul_Tmp');
187: Fnd_Msg_Pub.count_and_get(

Line 195: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

191: END insert_Opt_Rul_Tmp;
192:
193: PROCEDURE lock_Opt_Rul_Tmp(
194: p_api_version IN NUMBER
195: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
196: ,x_return_status OUT NOCOPY VARCHAR2
197: ,x_msg_count OUT NOCOPY NUMBER
198: ,x_msg_data OUT NOCOPY VARCHAR2
199: ,p_rgrv_rec IN rgrv_rec_type) IS

Line 207: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

203: END lock_Opt_Rul_Tmp;
204:
205: PROCEDURE lock_Opt_Rul_Tmp(
206: p_api_version IN NUMBER
207: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
208: ,x_return_status OUT NOCOPY VARCHAR2
209: ,x_msg_count OUT NOCOPY NUMBER
210: ,x_msg_data OUT NOCOPY VARCHAR2
211: ,p_rgrv_tbl IN rgrv_tbl_type) IS

Line 219: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

215: END lock_Opt_Rul_Tmp;
216:
217: PROCEDURE update_Opt_Rul_Tmp(
218: p_api_version IN NUMBER
219: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
220: ,x_return_status OUT NOCOPY VARCHAR2
221: ,x_msg_count OUT NOCOPY NUMBER
222: ,x_msg_data OUT NOCOPY VARCHAR2
223: ,p_rgrv_rec IN rgrv_rec_type

Line 232: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

228: END update_Opt_Rul_Tmp;
229:
230: PROCEDURE update_Opt_Rul_Tmp(
231: p_api_version IN NUMBER
232: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
233: ,x_return_status OUT NOCOPY VARCHAR2
234: ,x_msg_count OUT NOCOPY NUMBER
235: ,x_msg_data OUT NOCOPY VARCHAR2
236: ,p_rgrv_tbl IN rgrv_tbl_type

Line 246: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

242:
243: --Put custom code for cascade delete by developer
244: PROCEDURE delete_Opt_Rul_Tmp(
245: p_api_version IN NUMBER
246: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
247: ,x_return_status OUT NOCOPY VARCHAR2
248: ,x_msg_count OUT NOCOPY NUMBER
249: ,x_msg_data OUT NOCOPY VARCHAR2
250: ,p_rgrv_rec IN rgrv_rec_type) IS

Line 257: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

253: END delete_Opt_Rul_Tmp;
254:
255: PROCEDURE delete_Opt_Rul_Tmp(
256: p_api_version IN NUMBER
257: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
258: ,x_return_status OUT NOCOPY VARCHAR2
259: ,x_msg_count OUT NOCOPY NUMBER
260: ,x_msg_data OUT NOCOPY VARCHAR2
261: ,p_rgrv_tbl IN rgrv_tbl_type) IS

Line 269: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

265: END delete_Opt_Rul_Tmp;
266:
267: PROCEDURE validate_Opt_Rul_Tmp(
268: p_api_version IN NUMBER
269: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
270: ,x_return_status OUT NOCOPY VARCHAR2
271: ,x_msg_count OUT NOCOPY NUMBER
272: ,x_msg_data OUT NOCOPY VARCHAR2
273: ,p_rgrv_rec IN rgrv_rec_type) IS

Line 281: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

277: END validate_Opt_Rul_Tmp;
278:
279: PROCEDURE validate_Opt_Rul_Tmp(
280: p_api_version IN NUMBER,
281: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
282: x_return_status OUT NOCOPY VARCHAR2,
283: x_msg_count OUT NOCOPY NUMBER,
284: x_msg_data OUT NOCOPY VARCHAR2,
285: p_rgrv_tbl IN rgrv_tbl_type) IS