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_AM_RESTRUCTURE_QUOTE_PUB dependencies on FND_API

Line 6: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

2: /* $Header: OKLPRTQB.pls 115.4 2004/04/13 11:03:39 rnaik noship $ */
3:
4: PROCEDURE create_restructure_quote(
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_quot_rec IN quot_rec_type

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

45: ,l_msg_data
46: ,lp_quot_rec
47: ,lx_quot_rec);
48:
49: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
50: RAISE FND_API.G_EXC_ERROR;
51: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
52: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
53: END IF;

Line 50: RAISE FND_API.G_EXC_ERROR;

46: ,lp_quot_rec
47: ,lx_quot_rec);
48:
49: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
50: RAISE FND_API.G_EXC_ERROR;
51: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
52: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
53: END IF;
54:

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

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

Line 52: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 70: WHEN FND_API.G_EXC_ERROR THEN

66: x_msg_data := l_msg_data ;
67:
68: EXCEPTION
69:
70: WHEN FND_API.G_EXC_ERROR THEN
71: ROLLBACK TO restructure_quote_create;
72: x_return_status := FND_API.G_RET_STS_ERROR;
73: x_msg_count := l_msg_count ;
74: x_msg_data := l_msg_data ;

Line 72: x_return_status := FND_API.G_RET_STS_ERROR;

68: EXCEPTION
69:
70: WHEN FND_API.G_EXC_ERROR THEN
71: ROLLBACK TO restructure_quote_create;
72: x_return_status := FND_API.G_RET_STS_ERROR;
73: x_msg_count := l_msg_count ;
74: x_msg_data := l_msg_data ;
75: FND_MSG_PUB.count_and_get(
76: p_count => x_msg_count

Line 78: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

74: x_msg_data := l_msg_data ;
75: FND_MSG_PUB.count_and_get(
76: p_count => x_msg_count
77: ,p_data => x_msg_data);
78: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
79: ROLLBACK TO restructure_quote_create;
80: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
81: x_msg_count := l_msg_count ;
82: x_msg_data := l_msg_data ;

Line 80: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 88: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

84: p_count => x_msg_count
85: ,p_data => x_msg_data);
86: WHEN OTHERS THEN
87: ROLLBACK TO restructure_quote_create;
88: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
89: x_msg_count := l_msg_count ;
90: x_msg_data := l_msg_data ;
91: FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_RESTRUCTURE_QUOTE_PUB','create_restructure_quote');
92: FND_MSG_PUB.count_and_get(

Line 99: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

95: END create_restructure_quote;
96:
97: PROCEDURE create_restructure_quote(
98: p_api_version IN NUMBER
99: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
100: ,x_return_status OUT NOCOPY VARCHAR2
101: ,x_msg_count OUT NOCOPY NUMBER
102: ,x_msg_data OUT NOCOPY VARCHAR2
103: ,p_quot_tbl IN quot_tbl_type

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

134: ,l_msg_data
135: ,lp_quot_tbl
136: ,lx_quot_tbl);
137:
138: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
139: RAISE FND_API.G_EXC_ERROR;
140: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
142: END IF;

Line 139: RAISE FND_API.G_EXC_ERROR;

135: ,lp_quot_tbl
136: ,lx_quot_tbl);
137:
138: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
139: RAISE FND_API.G_EXC_ERROR;
140: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
142: END IF;
143:

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

136: ,lx_quot_tbl);
137:
138: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
139: RAISE FND_API.G_EXC_ERROR;
140: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
142: END IF;
143:
144: --Copy value of OUT variable in the IN record type

Line 141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

137:
138: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
139: RAISE FND_API.G_EXC_ERROR;
140: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
142: END IF;
143:
144: --Copy value of OUT variable in the IN record type
145: lp_quot_tbl := lx_quot_tbl;

Line 158: WHEN FND_API.G_EXC_ERROR THEN

154:
155:
156: EXCEPTION
157:
158: WHEN FND_API.G_EXC_ERROR THEN
159: ROLLBACK TO restructure_quote_create;
160: x_return_status := FND_API.G_RET_STS_ERROR;
161: x_msg_count := l_msg_count ;
162: x_msg_data := l_msg_data ;

Line 160: x_return_status := FND_API.G_RET_STS_ERROR;

156: EXCEPTION
157:
158: WHEN FND_API.G_EXC_ERROR THEN
159: ROLLBACK TO restructure_quote_create;
160: x_return_status := FND_API.G_RET_STS_ERROR;
161: x_msg_count := l_msg_count ;
162: x_msg_data := l_msg_data ;
163: FND_MSG_PUB.count_and_get(
164: p_count => x_msg_count

Line 166: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

162: x_msg_data := l_msg_data ;
163: FND_MSG_PUB.count_and_get(
164: p_count => x_msg_count
165: ,p_data => x_msg_data);
166: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
167: ROLLBACK TO restructure_quote_create;
168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
169: x_msg_count := l_msg_count ;
170: x_msg_data := l_msg_data ;

Line 168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

164: p_count => x_msg_count
165: ,p_data => x_msg_data);
166: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
167: ROLLBACK TO restructure_quote_create;
168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
169: x_msg_count := l_msg_count ;
170: x_msg_data := l_msg_data ;
171: FND_MSG_PUB.count_and_get(
172: p_count => x_msg_count

Line 176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

172: p_count => x_msg_count
173: ,p_data => x_msg_data);
174: WHEN OTHERS THEN
175: ROLLBACK TO restructure_quote_create;
176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
177: x_msg_count := l_msg_count ;
178: x_msg_data := l_msg_data ;
179: FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_RESTRUCTURE_QUOTE_PUB','create_restructure_quote');
180: FND_MSG_PUB.count_and_get(

Line 187: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

183: END create_restructure_quote;
184:
185: PROCEDURE update_restructure_quote(
186: p_api_version IN NUMBER
187: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
188: ,x_return_status OUT NOCOPY VARCHAR2
189: ,x_msg_count OUT NOCOPY NUMBER
190: ,x_msg_data OUT NOCOPY VARCHAR2
191: ,p_quot_rec IN quot_rec_type

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

224: ,l_msg_data
225: ,lp_quot_rec
226: ,lx_quot_rec);
227:
228: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
229: RAISE FND_API.G_EXC_ERROR;
230: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
232: END IF;

Line 229: RAISE FND_API.G_EXC_ERROR;

225: ,lp_quot_rec
226: ,lx_quot_rec);
227:
228: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
229: RAISE FND_API.G_EXC_ERROR;
230: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
232: END IF;
233:

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

226: ,lx_quot_rec);
227:
228: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
229: RAISE FND_API.G_EXC_ERROR;
230: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
232: END IF;
233:
234: --Copy value of OUT variable in the IN record type

Line 231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

227:
228: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
229: RAISE FND_API.G_EXC_ERROR;
230: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
232: END IF;
233:
234: --Copy value of OUT variable in the IN record type
235: lp_quot_rec := lx_quot_rec;

Line 249: WHEN FND_API.G_EXC_ERROR THEN

245:
246:
247: EXCEPTION
248:
249: WHEN FND_API.G_EXC_ERROR THEN
250: ROLLBACK TO restructure_quote_update;
251: x_return_status := FND_API.G_RET_STS_ERROR;
252: x_msg_count := l_msg_count ;
253: x_msg_data := l_msg_data ;

Line 251: x_return_status := FND_API.G_RET_STS_ERROR;

247: EXCEPTION
248:
249: WHEN FND_API.G_EXC_ERROR THEN
250: ROLLBACK TO restructure_quote_update;
251: x_return_status := FND_API.G_RET_STS_ERROR;
252: x_msg_count := l_msg_count ;
253: x_msg_data := l_msg_data ;
254: FND_MSG_PUB.count_and_get(
255: p_count => x_msg_count

Line 257: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

253: x_msg_data := l_msg_data ;
254: FND_MSG_PUB.count_and_get(
255: p_count => x_msg_count
256: ,p_data => x_msg_data);
257: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
258: ROLLBACK TO restructure_quote_update;
259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
260: x_msg_count := l_msg_count ;
261: x_msg_data := l_msg_data ;

Line 259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

255: p_count => x_msg_count
256: ,p_data => x_msg_data);
257: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
258: ROLLBACK TO restructure_quote_update;
259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
260: x_msg_count := l_msg_count ;
261: x_msg_data := l_msg_data ;
262: FND_MSG_PUB.count_and_get(
263: p_count => x_msg_count

Line 267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

263: p_count => x_msg_count
264: ,p_data => x_msg_data);
265: WHEN OTHERS THEN
266: ROLLBACK TO restructure_quote_update;
267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
268: x_msg_count := l_msg_count ;
269: x_msg_data := l_msg_data ;
270: FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_RESTRUCTURE_QUOTE_PUB','update_restructure_quote');
271: FND_MSG_PUB.count_and_get(

Line 278: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

274: END update_restructure_quote;
275:
276: PROCEDURE update_restructure_quote(
277: p_api_version IN NUMBER
278: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
279: ,x_return_status OUT NOCOPY VARCHAR2
280: ,x_msg_count OUT NOCOPY NUMBER
281: ,x_msg_data OUT NOCOPY VARCHAR2
282: ,p_quot_tbl IN quot_tbl_type

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

314: ,l_msg_data
315: ,lp_quot_tbl
316: ,lx_quot_tbl);
317:
318: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
319: RAISE FND_API.G_EXC_ERROR;
320: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
322: END IF;

Line 319: RAISE FND_API.G_EXC_ERROR;

315: ,lp_quot_tbl
316: ,lx_quot_tbl);
317:
318: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
319: RAISE FND_API.G_EXC_ERROR;
320: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
322: END IF;
323:

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

316: ,lx_quot_tbl);
317:
318: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
319: RAISE FND_API.G_EXC_ERROR;
320: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
322: END IF;
323:
324: --Copy value of OUT variable in the IN record type

Line 321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

317:
318: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
319: RAISE FND_API.G_EXC_ERROR;
320: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
322: END IF;
323:
324: --Copy value of OUT variable in the IN record type
325: lp_quot_tbl := lx_quot_tbl;

Line 338: WHEN FND_API.G_EXC_ERROR THEN

334:
335:
336: EXCEPTION
337:
338: WHEN FND_API.G_EXC_ERROR THEN
339: ROLLBACK TO restructure_quote_update;
340: x_return_status := FND_API.G_RET_STS_ERROR;
341: x_msg_count := l_msg_count ;
342: x_msg_data := l_msg_data ;

Line 340: x_return_status := FND_API.G_RET_STS_ERROR;

336: EXCEPTION
337:
338: WHEN FND_API.G_EXC_ERROR THEN
339: ROLLBACK TO restructure_quote_update;
340: x_return_status := FND_API.G_RET_STS_ERROR;
341: x_msg_count := l_msg_count ;
342: x_msg_data := l_msg_data ;
343: FND_MSG_PUB.count_and_get(
344: p_count => x_msg_count

Line 346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

342: x_msg_data := l_msg_data ;
343: FND_MSG_PUB.count_and_get(
344: p_count => x_msg_count
345: ,p_data => x_msg_data);
346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
347: ROLLBACK TO restructure_quote_update;
348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
349: x_msg_count := l_msg_count ;
350: x_msg_data := l_msg_data ;

Line 348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

344: p_count => x_msg_count
345: ,p_data => x_msg_data);
346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
347: ROLLBACK TO restructure_quote_update;
348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
349: x_msg_count := l_msg_count ;
350: x_msg_data := l_msg_data ;
351: FND_MSG_PUB.count_and_get(
352: p_count => x_msg_count

Line 356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

352: p_count => x_msg_count
353: ,p_data => x_msg_data);
354: WHEN OTHERS THEN
355: ROLLBACK TO restructure_quote_update;
356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
357: x_msg_count := l_msg_count ;
358: x_msg_data := l_msg_data ;
359: FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_RESTRUCTURE_QUOTE_PUB','update_restructure_quote');
360: FND_MSG_PUB.count_and_get(