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.PVX_CHANNEL_TYPE_PVT dependencies on FND_API

Line 22: -- 3. Please don't pass in any FND_API.g_mess_char/num/date.

18: -- NOTES
19: -- 1. object_version_number will be set to 1.
20: -- 2. If channel_type_id is not passed in, generate a unique one from
21: -- the sequence.
22: -- 3. Please don't pass in any FND_API.g_mess_char/num/date.
23: ---------------------------------------------------------------------
24: PROCEDURE Create_channel_type(
25: p_api_version IN NUMBER := 1.0
26: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

Line 26: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

22: -- 3. Please don't pass in any FND_API.g_mess_char/num/date.
23: ---------------------------------------------------------------------
24: PROCEDURE Create_channel_type(
25: p_api_version IN NUMBER := 1.0
26: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
27: ,p_commit IN VARCHAR2 := FND_API.g_false
28: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
29: ,p_channel_type_rec IN channel_type_rec_type
30: ,x_channel_type_id OUT NOCOPY NUMBER

Line 27: ,p_commit IN VARCHAR2 := FND_API.g_false

23: ---------------------------------------------------------------------
24: PROCEDURE Create_channel_type(
25: p_api_version IN NUMBER := 1.0
26: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
27: ,p_commit IN VARCHAR2 := FND_API.g_false
28: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
29: ,p_channel_type_rec IN channel_type_rec_type
30: ,x_channel_type_id OUT NOCOPY NUMBER
31: ,x_return_status OUT NOCOPY VARCHAR2

Line 28: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full

24: PROCEDURE Create_channel_type(
25: p_api_version IN NUMBER := 1.0
26: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
27: ,p_commit IN VARCHAR2 := FND_API.g_false
28: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
29: ,p_channel_type_rec IN channel_type_rec_type
30: ,x_channel_type_id OUT NOCOPY NUMBER
31: ,x_return_status OUT NOCOPY VARCHAR2
32: ,x_msg_count OUT NOCOPY NUMBER

Line 62: IF FND_API.to_boolean(p_init_msg_list) THEN

58: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
59: PVX_Utility_PVT.debug_message(l_full_name||': start');
60: END IF;
61:
62: IF FND_API.to_boolean(p_init_msg_list) THEN
63: FND_MSG_PUB.initialize;
64: END IF;
65:
66: IF NOT FND_API.compatible_api_call( l_api_version,

Line 66: IF NOT FND_API.compatible_api_call( l_api_version,

62: IF FND_API.to_boolean(p_init_msg_list) THEN
63: FND_MSG_PUB.initialize;
64: END IF;
65:
66: IF NOT FND_API.compatible_api_call( l_api_version,
67: p_api_version,
68: l_api_name,
69: g_pkg_name) THEN
70: RAISE FND_API.g_exc_unexpected_error;

Line 70: RAISE FND_API.g_exc_unexpected_error;

66: IF NOT FND_API.compatible_api_call( l_api_version,
67: p_api_version,
68: l_api_name,
69: g_pkg_name) THEN
70: RAISE FND_API.g_exc_unexpected_error;
71: END IF;
72:
73: x_return_status := FND_API.g_ret_sts_success;
74:

Line 73: x_return_status := FND_API.g_ret_sts_success;

69: g_pkg_name) THEN
70: RAISE FND_API.g_exc_unexpected_error;
71: END IF;
72:
73: x_return_status := FND_API.g_ret_sts_success;
74:
75: -------------------------- insert --------------------------
76: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
77: PVX_Utility_PVT.debug_message(l_full_name ||': insert');

Line 97: RAISE FND_API.g_exc_unexpected_error;

93:
94: if l_uniqueness_check is not null then
95: FND_MESSAGE.set_name('PV', 'PV_DUPLICATE_RECORD');
96: FND_MSG_PUB.add;
97: RAISE FND_API.g_exc_unexpected_error;
98: end if;
99:
100: END IF;
101:

Line 131: IF FND_API.to_boolean(p_commit) THEN

127:
128: x_channel_type_id := l_channel_type_rec.channel_type_id;
129:
130: -- Check for commit
131: IF FND_API.to_boolean(p_commit) THEN
132: COMMIT;
133: END IF;
134:
135: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

Line 135: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

131: IF FND_API.to_boolean(p_commit) THEN
132: COMMIT;
133: END IF;
134:
135: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
136: p_count => x_msg_count,
137: p_data => x_msg_data);
138:
139: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

Line 145: WHEN FND_API.g_exc_error THEN

141: END IF;
142:
143: EXCEPTION
144:
145: WHEN FND_API.g_exc_error THEN
146:
147: ROLLBACK TO Create_channel_type;
148: x_return_status := FND_API.g_ret_sts_error;
149:

Line 148: x_return_status := FND_API.g_ret_sts_error;

144:
145: WHEN FND_API.g_exc_error THEN
146:
147: ROLLBACK TO Create_channel_type;
148: x_return_status := FND_API.g_ret_sts_error;
149:
150: FND_MSG_PUB.count_and_get ( p_encoded => FND_API.g_false
151: ,p_count => x_msg_count
152: ,p_data => x_msg_data);

Line 150: FND_MSG_PUB.count_and_get ( p_encoded => FND_API.g_false

146:
147: ROLLBACK TO Create_channel_type;
148: x_return_status := FND_API.g_ret_sts_error;
149:
150: FND_MSG_PUB.count_and_get ( p_encoded => FND_API.g_false
151: ,p_count => x_msg_count
152: ,p_data => x_msg_data);
153:
154: WHEN FND_API.g_exc_unexpected_error THEN

Line 154: WHEN FND_API.g_exc_unexpected_error THEN

150: FND_MSG_PUB.count_and_get ( p_encoded => FND_API.g_false
151: ,p_count => x_msg_count
152: ,p_data => x_msg_data);
153:
154: WHEN FND_API.g_exc_unexpected_error THEN
155:
156: ROLLBACK TO Create_channel_type;
157: x_return_status := FND_API.g_ret_sts_unexp_error ;
158:

Line 157: x_return_status := FND_API.g_ret_sts_unexp_error ;

153:
154: WHEN FND_API.g_exc_unexpected_error THEN
155:
156: ROLLBACK TO Create_channel_type;
157: x_return_status := FND_API.g_ret_sts_unexp_error ;
158:
159: FND_MSG_PUB.count_and_get ( p_encoded => FND_API.g_false
160: ,p_count => x_msg_count
161: ,p_data => x_msg_data);

Line 159: FND_MSG_PUB.count_and_get ( p_encoded => FND_API.g_false

155:
156: ROLLBACK TO Create_channel_type;
157: x_return_status := FND_API.g_ret_sts_unexp_error ;
158:
159: FND_MSG_PUB.count_and_get ( p_encoded => FND_API.g_false
160: ,p_count => x_msg_count
161: ,p_data => x_msg_data);
162:
163: WHEN OTHERS THEN

Line 166: x_return_status := FND_API.g_ret_sts_unexp_error ;

162:
163: WHEN OTHERS THEN
164:
165: ROLLBACK TO Create_channel_type;
166: x_return_status := FND_API.g_ret_sts_unexp_error ;
167:
168: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
169: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
170: END IF;

Line 172: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

168: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
169: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
170: END IF;
171:
172: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
173: ,p_count => x_msg_count
174: ,p_data => x_msg_data);
175:
176: END Create_channel_type;

Line 186: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

182: --
183: ---------------------------------------------------------------
184: PROCEDURE Delete_channel_type(
185: p_api_version IN NUMBER
186: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
187: ,p_commit IN VARCHAR2 := FND_API.g_false
188: ,p_channel_type_id IN NUMBER
189: ,p_object_version IN NUMBER
190: ,x_return_status OUT NOCOPY VARCHAR2

Line 187: ,p_commit IN VARCHAR2 := FND_API.g_false

183: ---------------------------------------------------------------
184: PROCEDURE Delete_channel_type(
185: p_api_version IN NUMBER
186: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
187: ,p_commit IN VARCHAR2 := FND_API.g_false
188: ,p_channel_type_id IN NUMBER
189: ,p_object_version IN NUMBER
190: ,x_return_status OUT NOCOPY VARCHAR2
191: ,x_msg_count OUT NOCOPY NUMBER

Line 209: IF FND_API.to_boolean(p_init_msg_list) THEN

205: PVX_Utility_PVT.debug_message(l_full_name||': start');
206: END IF;
207:
208:
209: IF FND_API.to_boolean(p_init_msg_list) THEN
210: FND_MSG_PUB.initialize;
211: END IF;
212:
213: IF NOT FND_API.compatible_api_call( l_api_version,

Line 213: IF NOT FND_API.compatible_api_call( l_api_version,

209: IF FND_API.to_boolean(p_init_msg_list) THEN
210: FND_MSG_PUB.initialize;
211: END IF;
212:
213: IF NOT FND_API.compatible_api_call( l_api_version,
214: p_api_version,
215: l_api_name,
216: g_pkg_name) THEN
217: RAISE FND_API.g_exc_unexpected_error;

Line 217: RAISE FND_API.g_exc_unexpected_error;

213: IF NOT FND_API.compatible_api_call( l_api_version,
214: p_api_version,
215: l_api_name,
216: g_pkg_name) THEN
217: RAISE FND_API.g_exc_unexpected_error;
218: END IF;
219:
220: x_return_status := FND_API.G_RET_STS_SUCCESS;
221:

Line 220: x_return_status := FND_API.G_RET_STS_SUCCESS;

216: g_pkg_name) THEN
217: RAISE FND_API.g_exc_unexpected_error;
218: END IF;
219:
220: x_return_status := FND_API.G_RET_STS_SUCCESS;
221:
222: ------------------------ delete ------------------------
223: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
224: PVX_Utility_PVT.debug_message(l_full_name ||': delete');

Line 232: RAISE FND_API.g_exc_error;

228:
229: FND_MESSAGE.set_name('PV', 'PV_DEBUG_MESSAGE');
230: FND_MESSAGE.set_token('TEXT', 'Cannot delete a seeded channel type');
231: FND_MSG_PUB.add;
232: RAISE FND_API.g_exc_error;
233:
234:
235: END IF;
236:

Line 247: RAISE FND_API.g_exc_error;

243: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
244: FND_MESSAGE.set_name('PV', 'PV_RECORD_NOT_FOUND');
245: FND_MSG_PUB.add;
246: END IF;
247: RAISE FND_API.g_exc_error;
248: END IF;
249:
250: -------------------- finish --------------------------
251: IF FND_API.to_boolean(p_commit) THEN

Line 251: IF FND_API.to_boolean(p_commit) THEN

247: RAISE FND_API.g_exc_error;
248: END IF;
249:
250: -------------------- finish --------------------------
251: IF FND_API.to_boolean(p_commit) THEN
252: COMMIT;
253: END IF;
254:
255: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false,

Line 255: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false,

251: IF FND_API.to_boolean(p_commit) THEN
252: COMMIT;
253: END IF;
254:
255: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false,
256: p_count => x_msg_count,
257: p_data => x_msg_data);
258:
259: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

Line 265: WHEN FND_API.g_exc_error THEN

261: END IF;
262:
263: EXCEPTION
264:
265: WHEN FND_API.g_exc_error THEN
266:
267: ROLLBACK TO Delete_channel_type;
268: x_return_status := FND_API.g_ret_sts_error;
269:

Line 268: x_return_status := FND_API.g_ret_sts_error;

264:
265: WHEN FND_API.g_exc_error THEN
266:
267: ROLLBACK TO Delete_channel_type;
268: x_return_status := FND_API.g_ret_sts_error;
269:
270: FND_MSG_PUB.count_and_get ( p_encoded => FND_API.g_false
271: ,p_count => x_msg_count
272: ,p_data => x_msg_data);

Line 270: FND_MSG_PUB.count_and_get ( p_encoded => FND_API.g_false

266:
267: ROLLBACK TO Delete_channel_type;
268: x_return_status := FND_API.g_ret_sts_error;
269:
270: FND_MSG_PUB.count_and_get ( p_encoded => FND_API.g_false
271: ,p_count => x_msg_count
272: ,p_data => x_msg_data);
273:
274: WHEN FND_API.g_exc_unexpected_error THEN

Line 274: WHEN FND_API.g_exc_unexpected_error THEN

270: FND_MSG_PUB.count_and_get ( p_encoded => FND_API.g_false
271: ,p_count => x_msg_count
272: ,p_data => x_msg_data);
273:
274: WHEN FND_API.g_exc_unexpected_error THEN
275:
276: ROLLBACK TO Delete_channel_type;
277: x_return_status := FND_API.g_ret_sts_unexp_error ;
278:

Line 277: x_return_status := FND_API.g_ret_sts_unexp_error ;

273:
274: WHEN FND_API.g_exc_unexpected_error THEN
275:
276: ROLLBACK TO Delete_channel_type;
277: x_return_status := FND_API.g_ret_sts_unexp_error ;
278:
279: FND_MSG_PUB.count_and_get ( p_encoded => FND_API.g_false
280: ,p_count => x_msg_count
281: ,p_data => x_msg_data);

Line 279: FND_MSG_PUB.count_and_get ( p_encoded => FND_API.g_false

275:
276: ROLLBACK TO Delete_channel_type;
277: x_return_status := FND_API.g_ret_sts_unexp_error ;
278:
279: FND_MSG_PUB.count_and_get ( p_encoded => FND_API.g_false
280: ,p_count => x_msg_count
281: ,p_data => x_msg_data);
282:
283: WHEN OTHERS THEN

Line 286: x_return_status := FND_API.g_ret_sts_unexp_error ;

282:
283: WHEN OTHERS THEN
284:
285: ROLLBACK TO Delete_channel_type;
286: x_return_status := FND_API.g_ret_sts_unexp_error ;
287:
288: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
289: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
290: END IF;

Line 292: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

288: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
289: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
290: END IF;
291:
292: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
293: ,p_count => x_msg_count
294: ,p_data => x_msg_data);
295:
296: END Delete_channel_type;

Line 305: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

301: -- Update_channel_type
302: ----------------------------------------------------------------------
303: PROCEDURE Update_channel_type(
304: p_api_version IN NUMBER := 1.0
305: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
306: ,p_commit IN VARCHAR2 := FND_API.g_false
307: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
308: ,p_channel_type_rec IN channel_type_rec_type
309: ,x_return_status OUT NOCOPY VARCHAR2

Line 306: ,p_commit IN VARCHAR2 := FND_API.g_false

302: ----------------------------------------------------------------------
303: PROCEDURE Update_channel_type(
304: p_api_version IN NUMBER := 1.0
305: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
306: ,p_commit IN VARCHAR2 := FND_API.g_false
307: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
308: ,p_channel_type_rec IN channel_type_rec_type
309: ,x_return_status OUT NOCOPY VARCHAR2
310: ,x_msg_count OUT NOCOPY NUMBER

Line 307: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full

303: PROCEDURE Update_channel_type(
304: p_api_version IN NUMBER := 1.0
305: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
306: ,p_commit IN VARCHAR2 := FND_API.g_false
307: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
308: ,p_channel_type_rec IN channel_type_rec_type
309: ,x_return_status OUT NOCOPY VARCHAR2
310: ,x_msg_count OUT NOCOPY NUMBER
311: ,x_msg_data OUT NOCOPY VARCHAR2)

Line 335: IF FND_API.to_boolean(p_init_msg_list) THEN

331: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
332: PVX_Utility_PVT.debug_message(l_full_name||': start');
333: END IF;
334:
335: IF FND_API.to_boolean(p_init_msg_list) THEN
336: FND_MSG_PUB.initialize;
337: END IF;
338:
339: IF NOT FND_API.compatible_api_call( l_api_version,

Line 339: IF NOT FND_API.compatible_api_call( l_api_version,

335: IF FND_API.to_boolean(p_init_msg_list) THEN
336: FND_MSG_PUB.initialize;
337: END IF;
338:
339: IF NOT FND_API.compatible_api_call( l_api_version,
340: p_api_version,
341: l_api_name,
342: g_pkg_name) THEN
343: RAISE FND_API.g_exc_unexpected_error;

Line 343: RAISE FND_API.g_exc_unexpected_error;

339: IF NOT FND_API.compatible_api_call( l_api_version,
340: p_api_version,
341: l_api_name,
342: g_pkg_name) THEN
343: RAISE FND_API.g_exc_unexpected_error;
344: END IF;
345:
346: x_return_status := FND_API.G_RET_STS_SUCCESS;
347:

Line 346: x_return_status := FND_API.G_RET_STS_SUCCESS;

342: g_pkg_name) THEN
343: RAISE FND_API.g_exc_unexpected_error;
344: END IF;
345:
346: x_return_status := FND_API.G_RET_STS_SUCCESS;
347:
348: ----------------------- validate ----------------------
349: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
350: PVX_Utility_PVT.debug_message(l_full_name ||': validate');

Line 373: RAISE FND_API.g_exc_error;

369:
370: FND_MESSAGE.set_name('PV', 'PV_DEBUG_MESSAGE');
371: FND_MESSAGE.set_token('TEXT', 'Cannot update a seeded channel type');
372: FND_MSG_PUB.add;
373: RAISE FND_API.g_exc_error;
374:
375: END IF;
376:
377: END IF;

Line 401: RAISE FND_API.g_exc_error;

397: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
398: FND_MESSAGE.set_name('PV', 'PV_NO_RECORD_FOUND');
399: FND_MSG_PUB.add;
400: END IF;
401: RAISE FND_API.g_exc_error;
402: END IF;
403:
404: -------------------- finish --------------------------
405:

Line 407: IF FND_API.to_boolean(p_commit) THEN

403:
404: -------------------- finish --------------------------
405:
406: -- Check for commit
407: IF FND_API.to_boolean(p_commit) THEN
408: COMMIT;
409: END IF;
410:
411: FND_MSG_PUB.count_and_get(

Line 412: p_encoded => FND_API.g_false,

408: COMMIT;
409: END IF;
410:
411: FND_MSG_PUB.count_and_get(
412: p_encoded => FND_API.g_false,
413: p_count => x_msg_count,
414: p_data => x_msg_data
415: );
416:

Line 424: WHEN FND_API.g_exc_error THEN

420:
421:
422: EXCEPTION
423:
424: WHEN FND_API.g_exc_error THEN
425:
426: ROLLBACK TO Update_channel_type;
427: x_return_status := FND_API.g_ret_sts_error;
428:

Line 427: x_return_status := FND_API.g_ret_sts_error;

423:
424: WHEN FND_API.g_exc_error THEN
425:
426: ROLLBACK TO Update_channel_type;
427: x_return_status := FND_API.g_ret_sts_error;
428:
429: FND_MSG_PUB.count_and_get ( p_encoded => FND_API.g_false
430: ,p_count => x_msg_count
431: ,p_data => x_msg_data);

Line 429: FND_MSG_PUB.count_and_get ( p_encoded => FND_API.g_false

425:
426: ROLLBACK TO Update_channel_type;
427: x_return_status := FND_API.g_ret_sts_error;
428:
429: FND_MSG_PUB.count_and_get ( p_encoded => FND_API.g_false
430: ,p_count => x_msg_count
431: ,p_data => x_msg_data);
432:
433: WHEN FND_API.g_exc_unexpected_error THEN

Line 433: WHEN FND_API.g_exc_unexpected_error THEN

429: FND_MSG_PUB.count_and_get ( p_encoded => FND_API.g_false
430: ,p_count => x_msg_count
431: ,p_data => x_msg_data);
432:
433: WHEN FND_API.g_exc_unexpected_error THEN
434:
435: ROLLBACK TO Update_channel_type;
436: x_return_status := FND_API.g_ret_sts_unexp_error ;
437:

Line 436: x_return_status := FND_API.g_ret_sts_unexp_error ;

432:
433: WHEN FND_API.g_exc_unexpected_error THEN
434:
435: ROLLBACK TO Update_channel_type;
436: x_return_status := FND_API.g_ret_sts_unexp_error ;
437:
438: FND_MSG_PUB.count_and_get ( p_encoded => FND_API.g_false
439: ,p_count => x_msg_count
440: ,p_data => x_msg_data);

Line 438: FND_MSG_PUB.count_and_get ( p_encoded => FND_API.g_false

434:
435: ROLLBACK TO Update_channel_type;
436: x_return_status := FND_API.g_ret_sts_unexp_error ;
437:
438: FND_MSG_PUB.count_and_get ( p_encoded => FND_API.g_false
439: ,p_count => x_msg_count
440: ,p_data => x_msg_data);
441:
442: WHEN OTHERS THEN

Line 445: x_return_status := FND_API.g_ret_sts_unexp_error ;

441:
442: WHEN OTHERS THEN
443:
444: ROLLBACK TO Update_channel_type;
445: x_return_status := FND_API.g_ret_sts_unexp_error ;
446:
447: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
448: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
449: END IF;

Line 451: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

447: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
448: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
449: END IF;
450:
451: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
452: ,p_count => x_msg_count
453: ,p_data => x_msg_data);
454:
455: END Update_channel_type;

Line 489: RAISE FND_API.g_exc_error;

485: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
486: FND_MESSAGE.set_name('PV', 'PV_NO_RECORD_FOUND');
487: FND_MSG_PUB.add;
488: END IF;
489: RAISE FND_API.g_exc_error;
490: END IF;
491:
492: CLOSE lc_get_channel_type;
493:

Line 494: IF p_channel_type_rec.channel_lookup_type = FND_API.G_MISS_CHAR THEN

490: END IF;
491:
492: CLOSE lc_get_channel_type;
493:
494: IF p_channel_type_rec.channel_lookup_type = FND_API.G_MISS_CHAR THEN
495: x_complete_rec.channel_lookup_type := l_channel_type_rec.channel_lookup_type;
496: END IF;
497:
498: IF p_channel_type_rec.channel_lookup_code = FND_API.G_MISS_CHAR THEN

Line 498: IF p_channel_type_rec.channel_lookup_code = FND_API.G_MISS_CHAR THEN

494: IF p_channel_type_rec.channel_lookup_type = FND_API.G_MISS_CHAR THEN
495: x_complete_rec.channel_lookup_type := l_channel_type_rec.channel_lookup_type;
496: END IF;
497:
498: IF p_channel_type_rec.channel_lookup_code = FND_API.G_MISS_CHAR THEN
499: x_complete_rec.channel_lookup_code := l_channel_type_rec.channel_lookup_code;
500: END IF;
501:
502: IF p_channel_type_rec.indirect_channel_flag = FND_API.G_MISS_CHAR THEN

Line 502: IF p_channel_type_rec.indirect_channel_flag = FND_API.G_MISS_CHAR THEN

498: IF p_channel_type_rec.channel_lookup_code = FND_API.G_MISS_CHAR THEN
499: x_complete_rec.channel_lookup_code := l_channel_type_rec.channel_lookup_code;
500: END IF;
501:
502: IF p_channel_type_rec.indirect_channel_flag = FND_API.G_MISS_CHAR THEN
503: x_complete_rec.indirect_channel_flag := l_channel_type_rec.indirect_channel_flag;
504: END IF;
505:
506: IF p_channel_type_rec.object_version_number = FND_API.G_MISS_NUM THEN

Line 506: IF p_channel_type_rec.object_version_number = FND_API.G_MISS_NUM THEN

502: IF p_channel_type_rec.indirect_channel_flag = FND_API.G_MISS_CHAR THEN
503: x_complete_rec.indirect_channel_flag := l_channel_type_rec.indirect_channel_flag;
504: END IF;
505:
506: IF p_channel_type_rec.object_version_number = FND_API.G_MISS_NUM THEN
507: x_complete_rec.object_version_number := l_channel_type_rec.object_version_number;
508: END IF;
509:
510: IF p_channel_type_rec.rank = FND_API.G_MISS_NUM THEN

Line 510: IF p_channel_type_rec.rank = FND_API.G_MISS_NUM THEN

506: IF p_channel_type_rec.object_version_number = FND_API.G_MISS_NUM THEN
507: x_complete_rec.object_version_number := l_channel_type_rec.object_version_number;
508: END IF;
509:
510: IF p_channel_type_rec.rank = FND_API.G_MISS_NUM THEN
511: x_complete_rec.rank := l_channel_type_rec.rank;
512: END IF;
513:
514: END Complete_channel_type_rec;