APPS.PVX_PRTNR_PRFLS_PVT dependencies on FND_API

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

23: -- the sequence.
24: -- 4. If a flag column is passed in, check if it is 'Y' or 'N'.
25: -- Raise exception for invalid flag.
26: -- 5. If a flag column is not passed in, default it to 'Y' or 'N'.
27: -- 6. Please don't pass in any FND_API.g_mess_char/num/date.
28: ---------------------------------------------------------------------
29: PROCEDURE Create_Prtnr_Prfls(
30: p_api_version IN NUMBER
31: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

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

27: -- 6. Please don't pass in any FND_API.g_mess_char/num/date.
28: ---------------------------------------------------------------------
29: PROCEDURE Create_Prtnr_Prfls(
30: p_api_version IN NUMBER
31: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
32: ,p_commit IN VARCHAR2 := FND_API.g_false
33: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
34:
35: ,x_return_status OUT NOCOPY VARCHAR2

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

28: ---------------------------------------------------------------------
29: PROCEDURE Create_Prtnr_Prfls(
30: p_api_version IN NUMBER
31: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
32: ,p_commit IN VARCHAR2 := FND_API.g_false
33: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
34:
35: ,x_return_status OUT NOCOPY VARCHAR2
36: ,x_msg_count OUT NOCOPY NUMBER

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

29: PROCEDURE Create_Prtnr_Prfls(
30: p_api_version IN NUMBER
31: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
32: ,p_commit IN VARCHAR2 := FND_API.g_false
33: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
34:
35: ,x_return_status OUT NOCOPY VARCHAR2
36: ,x_msg_count OUT NOCOPY NUMBER
37: ,x_msg_data OUT NOCOPY VARCHAR2

Line 80: IF FND_API.to_boolean(p_init_msg_list) THEN

76: END IF;
77:
78: --dbms_output.put_line(l_full_name||': start');
79:
80: IF FND_API.to_boolean(p_init_msg_list) THEN
81: FND_MSG_PUB.initialize;
82: END IF;
83:
84: IF NOT FND_API.compatible_api_call(

Line 84: IF NOT FND_API.compatible_api_call(

80: IF FND_API.to_boolean(p_init_msg_list) THEN
81: FND_MSG_PUB.initialize;
82: END IF;
83:
84: IF NOT FND_API.compatible_api_call(
85: l_api_version,
86: p_api_version,
87: l_api_name,
88: g_pkg_name

Line 90: RAISE FND_API.g_exc_unexpected_error;

86: p_api_version,
87: l_api_name,
88: g_pkg_name
89: ) THEN
90: RAISE FND_API.g_exc_unexpected_error;
91: END IF;
92:
93: x_return_status := FND_API.g_ret_sts_success;
94:

Line 93: x_return_status := FND_API.g_ret_sts_success;

89: ) THEN
90: RAISE FND_API.g_exc_unexpected_error;
91: END IF;
92:
93: x_return_status := FND_API.g_ret_sts_success;
94:
95: ----------------------- validate -----------------------
96: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
97: PVX_Utility_PVT.debug_message(l_full_name ||': validate');

Line 112: IF l_return_status = FND_API.g_ret_sts_error THEN

108: p_prtnr_prfls_rec => l_prtnr_prfls_rec
109: );
110:
111:
112: IF l_return_status = FND_API.g_ret_sts_error THEN
113: RAISE FND_API.g_exc_error;
114: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
115: RAISE FND_API.g_exc_unexpected_error;
116: END IF;

Line 113: RAISE FND_API.g_exc_error;

109: );
110:
111:
112: IF l_return_status = FND_API.g_ret_sts_error THEN
113: RAISE FND_API.g_exc_error;
114: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
115: RAISE FND_API.g_exc_unexpected_error;
116: END IF;
117:

Line 114: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

110:
111:
112: IF l_return_status = FND_API.g_ret_sts_error THEN
113: RAISE FND_API.g_exc_error;
114: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
115: RAISE FND_API.g_exc_unexpected_error;
116: END IF;
117:
118:

Line 115: RAISE FND_API.g_exc_unexpected_error;

111:
112: IF l_return_status = FND_API.g_ret_sts_error THEN
113: RAISE FND_API.g_exc_error;
114: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
115: RAISE FND_API.g_exc_unexpected_error;
116: END IF;
117:
118:
119: --dbms_output.put_line(l_full_name||': back validate');

Line 147: IF l_prtnr_prfls_rec.status IS NULL OR l_prtnr_prfls_rec.status = FND_API.G_MISS_CHAR THEN

143: IF c_count%ISOPEN THEN
144: CLOSE c_count;
145: END IF;
146:
147: IF l_prtnr_prfls_rec.status IS NULL OR l_prtnr_prfls_rec.status = FND_API.G_MISS_CHAR THEN
148: Determine_Partner_Status(l_prtnr_prfls_rec, l_status);
149: ELSE
150: l_status := l_prtnr_prfls_rec.status;
151: END IF;

Line 236: IF l_return_status = FND_API.g_ret_sts_error THEN

232:
233: ------------------------- finish -------------------------------
234: x_partner_profile_id := l_prtnr_prfls_rec.partner_profile_id;
235:
236: IF l_return_status = FND_API.g_ret_sts_error THEN
237: RAISE FND_API.g_exc_error;
238: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
239: RAISE FND_API.g_exc_unexpected_error;
240: END IF;

Line 237: RAISE FND_API.g_exc_error;

233: ------------------------- finish -------------------------------
234: x_partner_profile_id := l_prtnr_prfls_rec.partner_profile_id;
235:
236: IF l_return_status = FND_API.g_ret_sts_error THEN
237: RAISE FND_API.g_exc_error;
238: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
239: RAISE FND_API.g_exc_unexpected_error;
240: END IF;
241:

Line 238: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

234: x_partner_profile_id := l_prtnr_prfls_rec.partner_profile_id;
235:
236: IF l_return_status = FND_API.g_ret_sts_error THEN
237: RAISE FND_API.g_exc_error;
238: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
239: RAISE FND_API.g_exc_unexpected_error;
240: END IF;
241:
242:

Line 239: RAISE FND_API.g_exc_unexpected_error;

235:
236: IF l_return_status = FND_API.g_ret_sts_error THEN
237: RAISE FND_API.g_exc_error;
238: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
239: RAISE FND_API.g_exc_unexpected_error;
240: END IF;
241:
242:
243: -- Check for commit

Line 244: IF FND_API.to_boolean(p_commit) THEN

240: END IF;
241:
242:
243: -- Check for commit
244: IF FND_API.to_boolean(p_commit) THEN
245: COMMIT;
246: END IF;
247:
248: FND_MSG_PUB.count_and_get(

Line 249: p_encoded => FND_API.g_false,

245: COMMIT;
246: END IF;
247:
248: FND_MSG_PUB.count_and_get(
249: p_encoded => FND_API.g_false,
250: p_count => x_msg_count,
251: p_data => x_msg_data
252: );
253:

Line 260: WHEN FND_API.g_exc_error THEN

256: END IF;
257:
258: EXCEPTION
259:
260: WHEN FND_API.g_exc_error THEN
261: ROLLBACK TO Create_Prtnr_Prfls;
262: x_return_status := FND_API.g_ret_sts_error;
263: FND_MSG_PUB.count_and_get (
264: p_encoded => FND_API.g_false

Line 262: x_return_status := FND_API.g_ret_sts_error;

258: EXCEPTION
259:
260: WHEN FND_API.g_exc_error THEN
261: ROLLBACK TO Create_Prtnr_Prfls;
262: x_return_status := FND_API.g_ret_sts_error;
263: FND_MSG_PUB.count_and_get (
264: p_encoded => FND_API.g_false
265: ,p_count => x_msg_count
266: ,p_data => x_msg_data

Line 264: p_encoded => FND_API.g_false

260: WHEN FND_API.g_exc_error THEN
261: ROLLBACK TO Create_Prtnr_Prfls;
262: x_return_status := FND_API.g_ret_sts_error;
263: FND_MSG_PUB.count_and_get (
264: p_encoded => FND_API.g_false
265: ,p_count => x_msg_count
266: ,p_data => x_msg_data
267: );
268:

Line 269: WHEN FND_API.g_exc_unexpected_error THEN

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

Line 271: x_return_status := FND_API.g_ret_sts_unexp_error ;

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

Line 273: p_encoded => FND_API.g_false

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

Line 281: x_return_status := FND_API.g_ret_sts_unexp_error ;

277:
278:
279: WHEN OTHERS THEN
280: ROLLBACK TO Create_Prtnr_Prfls;
281: x_return_status := FND_API.g_ret_sts_unexp_error ;
282:
283: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
284: THEN
285: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 289: p_encoded => FND_API.g_false

285: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
286: END IF;
287:
288: FND_MSG_PUB.count_and_get(
289: p_encoded => FND_API.g_false
290: ,p_count => x_msg_count
291: ,p_data => x_msg_data
292: );
293:

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

300: --
301: ---------------------------------------------------------------
302: PROCEDURE Delete_Prtnr_Prfls(
303: p_api_version IN NUMBER
304: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
305: ,p_commit IN VARCHAR2 := FND_API.g_false
306:
307: ,x_return_status OUT NOCOPY VARCHAR2
308: ,x_msg_count OUT NOCOPY NUMBER

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

301: ---------------------------------------------------------------
302: PROCEDURE Delete_Prtnr_Prfls(
303: p_api_version IN NUMBER
304: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
305: ,p_commit IN VARCHAR2 := FND_API.g_false
306:
307: ,x_return_status OUT NOCOPY VARCHAR2
308: ,x_msg_count OUT NOCOPY NUMBER
309: ,x_msg_data OUT NOCOPY VARCHAR2

Line 329: IF FND_API.to_boolean(p_init_msg_list) THEN

325: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
326: PVX_Utility_PVT.debug_message(l_full_name||': start');
327: END IF;
328:
329: IF FND_API.to_boolean(p_init_msg_list) THEN
330: FND_MSG_PUB.initialize;
331: END IF;
332:
333: IF NOT FND_API.compatible_api_call(

Line 333: IF NOT FND_API.compatible_api_call(

329: IF FND_API.to_boolean(p_init_msg_list) THEN
330: FND_MSG_PUB.initialize;
331: END IF;
332:
333: IF NOT FND_API.compatible_api_call(
334: l_api_version,
335: p_api_version,
336: l_api_name,
337: g_pkg_name

Line 339: RAISE FND_API.g_exc_unexpected_error;

335: p_api_version,
336: l_api_name,
337: g_pkg_name
338: ) THEN
339: RAISE FND_API.g_exc_unexpected_error;
340: END IF;
341:
342: x_return_status := FND_API.G_RET_STS_SUCCESS;
343:

Line 342: x_return_status := FND_API.G_RET_STS_SUCCESS;

338: ) THEN
339: RAISE FND_API.g_exc_unexpected_error;
340: END IF;
341:
342: x_return_status := FND_API.G_RET_STS_SUCCESS;
343:
344: ------------------------ delete ------------------------
345: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
346: PVX_Utility_PVT.debug_message(l_full_name ||': delete');

Line 359: RAISE FND_API.g_exc_error;

355: THEN
356: FND_MESSAGE.set_name('PV', 'PV_NO_RECORD_FOUND');
357: FND_MSG_PUB.add;
358: END IF;
359: RAISE FND_API.g_exc_error;
360: END IF;
361:
362: -------------------- finish --------------------------
363: IF FND_API.to_boolean(p_commit) THEN

Line 363: IF FND_API.to_boolean(p_commit) THEN

359: RAISE FND_API.g_exc_error;
360: END IF;
361:
362: -------------------- finish --------------------------
363: IF FND_API.to_boolean(p_commit) THEN
364: COMMIT;
365: END IF;
366:
367: FND_MSG_PUB.count_and_get(

Line 368: p_encoded => FND_API.g_false,

364: COMMIT;
365: END IF;
366:
367: FND_MSG_PUB.count_and_get(
368: p_encoded => FND_API.g_false,
369: p_count => x_msg_count,
370: p_data => x_msg_data
371: );
372:

Line 379: WHEN FND_API.g_exc_error THEN

375: END IF;
376:
377: EXCEPTION
378:
379: WHEN FND_API.g_exc_error THEN
380: ROLLBACK TO Delete_Prtnr_Prfls;
381: x_return_status := FND_API.g_ret_sts_error;
382: FND_MSG_PUB.count_and_get(
383: p_encoded => FND_API.g_false,

Line 381: x_return_status := FND_API.g_ret_sts_error;

377: EXCEPTION
378:
379: WHEN FND_API.g_exc_error THEN
380: ROLLBACK TO Delete_Prtnr_Prfls;
381: x_return_status := FND_API.g_ret_sts_error;
382: FND_MSG_PUB.count_and_get(
383: p_encoded => FND_API.g_false,
384: p_count => x_msg_count,
385: p_data => x_msg_data

Line 383: p_encoded => FND_API.g_false,

379: WHEN FND_API.g_exc_error THEN
380: ROLLBACK TO Delete_Prtnr_Prfls;
381: x_return_status := FND_API.g_ret_sts_error;
382: FND_MSG_PUB.count_and_get(
383: p_encoded => FND_API.g_false,
384: p_count => x_msg_count,
385: p_data => x_msg_data
386: );
387:

Line 388: WHEN FND_API.g_exc_unexpected_error THEN

384: p_count => x_msg_count,
385: p_data => x_msg_data
386: );
387:
388: WHEN FND_API.g_exc_unexpected_error THEN
389: ROLLBACK TO Delete_Prtnr_Prfls;
390: x_return_status := FND_API.g_ret_sts_unexp_error ;
391: FND_MSG_PUB.count_and_get(
392: p_encoded => FND_API.g_false,

Line 390: x_return_status := FND_API.g_ret_sts_unexp_error ;

386: );
387:
388: WHEN FND_API.g_exc_unexpected_error THEN
389: ROLLBACK TO Delete_Prtnr_Prfls;
390: x_return_status := FND_API.g_ret_sts_unexp_error ;
391: FND_MSG_PUB.count_and_get(
392: p_encoded => FND_API.g_false,
393: p_count => x_msg_count,
394: p_data => x_msg_data

Line 392: p_encoded => FND_API.g_false,

388: WHEN FND_API.g_exc_unexpected_error THEN
389: ROLLBACK TO Delete_Prtnr_Prfls;
390: x_return_status := FND_API.g_ret_sts_unexp_error ;
391: FND_MSG_PUB.count_and_get(
392: p_encoded => FND_API.g_false,
393: p_count => x_msg_count,
394: p_data => x_msg_data
395: );
396:

Line 399: x_return_status := FND_API.g_ret_sts_unexp_error ;

395: );
396:
397: WHEN OTHERS THEN
398: ROLLBACK TO Delete_Prtnr_Prfls;
399: x_return_status := FND_API.g_ret_sts_unexp_error ;
400:
401: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
402: THEN
403: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 407: p_encoded => FND_API.g_false,

403: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
404: END IF;
405:
406: FND_MSG_PUB.count_and_get(
407: p_encoded => FND_API.g_false,
408: p_count => x_msg_count,
409: p_data => x_msg_data
410: );
411:

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

418: --
419: --------------------------------------------------------------------
420: PROCEDURE Lock_Prtnr_Prfls(
421: p_api_version IN NUMBER
422: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
423:
424: ,x_return_status OUT NOCOPY VARCHAR2
425: ,x_msg_count OUT NOCOPY NUMBER
426: ,x_msg_data OUT NOCOPY VARCHAR2

Line 453: IF FND_API.to_boolean(p_init_msg_list) THEN

449: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
450: PVX_Utility_PVT.debug_message(l_full_name||': start');
451: END IF;
452:
453: IF FND_API.to_boolean(p_init_msg_list) THEN
454: FND_MSG_PUB.initialize;
455: END IF;
456:
457: IF NOT FND_API.compatible_api_call(

Line 457: IF NOT FND_API.compatible_api_call(

453: IF FND_API.to_boolean(p_init_msg_list) THEN
454: FND_MSG_PUB.initialize;
455: END IF;
456:
457: IF NOT FND_API.compatible_api_call(
458: l_api_version,
459: p_api_version,
460: l_api_name,
461: g_pkg_name

Line 463: RAISE FND_API.g_exc_unexpected_error;

459: p_api_version,
460: l_api_name,
461: g_pkg_name
462: ) THEN
463: RAISE FND_API.g_exc_unexpected_error;
464: END IF;
465:
466: x_return_status := FND_API.G_RET_STS_SUCCESS;
467:

Line 466: x_return_status := FND_API.G_RET_STS_SUCCESS;

462: ) THEN
463: RAISE FND_API.g_exc_unexpected_error;
464: END IF;
465:
466: x_return_status := FND_API.G_RET_STS_SUCCESS;
467:
468: ------------------------ lock -------------------------
469: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
470: PVX_Utility_PVT.debug_message(l_full_name||': lock');

Line 481: RAISE FND_API.g_exc_error;

477: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
478: FND_MESSAGE.set_name('PV', 'PV_NO_RECORD_FOUND');
479: FND_MSG_PUB.add;
480: END IF;
481: RAISE FND_API.g_exc_error;
482: END IF;
483: CLOSE c_prtnr_prfls;
484:
485:

Line 488: p_encoded => FND_API.g_false,

484:
485:
486: -------------------- finish --------------------------
487: FND_MSG_PUB.count_and_get(
488: p_encoded => FND_API.g_false,
489: p_count => x_msg_count,
490: p_data => x_msg_data
491: );
492:

Line 500: x_return_status := FND_API.g_ret_sts_error;

496:
497: EXCEPTION
498:
499: WHEN PVX_Utility_PVT.resource_locked THEN
500: x_return_status := FND_API.g_ret_sts_error;
501: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
502: FND_MESSAGE.set_name('PV', 'PV_RESOURCE_LOCKED');
503: FND_MSG_PUB.add;
504: END IF;

Line 507: p_encoded => FND_API.g_false,

503: FND_MSG_PUB.add;
504: END IF;
505:
506: FND_MSG_PUB.count_and_get(
507: p_encoded => FND_API.g_false,
508: p_count => x_msg_count,
509: p_data => x_msg_data
510: );
511:

Line 512: WHEN FND_API.g_exc_error THEN

508: p_count => x_msg_count,
509: p_data => x_msg_data
510: );
511:
512: WHEN FND_API.g_exc_error THEN
513: x_return_status := FND_API.g_ret_sts_error;
514: FND_MSG_PUB.count_and_get(
515: p_encoded => FND_API.g_false,
516: p_count => x_msg_count,

Line 513: x_return_status := FND_API.g_ret_sts_error;

509: p_data => x_msg_data
510: );
511:
512: WHEN FND_API.g_exc_error THEN
513: x_return_status := FND_API.g_ret_sts_error;
514: FND_MSG_PUB.count_and_get(
515: p_encoded => FND_API.g_false,
516: p_count => x_msg_count,
517: p_data => x_msg_data

Line 515: p_encoded => FND_API.g_false,

511:
512: WHEN FND_API.g_exc_error THEN
513: x_return_status := FND_API.g_ret_sts_error;
514: FND_MSG_PUB.count_and_get(
515: p_encoded => FND_API.g_false,
516: p_count => x_msg_count,
517: p_data => x_msg_data
518: );
519:

Line 520: WHEN FND_API.g_exc_unexpected_error THEN

516: p_count => x_msg_count,
517: p_data => x_msg_data
518: );
519:
520: WHEN FND_API.g_exc_unexpected_error THEN
521: x_return_status := FND_API.g_ret_sts_unexp_error ;
522: FND_MSG_PUB.count_and_get(
523: p_encoded => FND_API.g_false,
524: p_count => x_msg_count,

Line 521: x_return_status := FND_API.g_ret_sts_unexp_error ;

517: p_data => x_msg_data
518: );
519:
520: WHEN FND_API.g_exc_unexpected_error THEN
521: x_return_status := FND_API.g_ret_sts_unexp_error ;
522: FND_MSG_PUB.count_and_get(
523: p_encoded => FND_API.g_false,
524: p_count => x_msg_count,
525: p_data => x_msg_data

Line 523: p_encoded => FND_API.g_false,

519:
520: WHEN FND_API.g_exc_unexpected_error THEN
521: x_return_status := FND_API.g_ret_sts_unexp_error ;
522: FND_MSG_PUB.count_and_get(
523: p_encoded => FND_API.g_false,
524: p_count => x_msg_count,
525: p_data => x_msg_data
526: );
527:

Line 529: x_return_status := FND_API.g_ret_sts_unexp_error ;

525: p_data => x_msg_data
526: );
527:
528: WHEN OTHERS THEN
529: x_return_status := FND_API.g_ret_sts_unexp_error ;
530: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
531: THEN
532: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
533: END IF;

Line 536: p_encoded => FND_API.g_false,

532: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
533: END IF;
534:
535: FND_MSG_PUB.count_and_get(
536: p_encoded => FND_API.g_false,
537: p_count => x_msg_count,
538: p_data => x_msg_data
539: );
540:

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

546: -- Update_Prtnr_Prfls
547: ----------------------------------------------------------------------
548: PROCEDURE Update_Prtnr_Prfls(
549: p_api_version IN NUMBER
550: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
551: ,p_commit IN VARCHAR2 := FND_API.g_false
552: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
553:
554: ,x_return_status OUT NOCOPY VARCHAR2

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

547: ----------------------------------------------------------------------
548: PROCEDURE Update_Prtnr_Prfls(
549: p_api_version IN NUMBER
550: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
551: ,p_commit IN VARCHAR2 := FND_API.g_false
552: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
553:
554: ,x_return_status OUT NOCOPY VARCHAR2
555: ,x_msg_count OUT NOCOPY NUMBER

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

548: PROCEDURE Update_Prtnr_Prfls(
549: p_api_version IN NUMBER
550: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
551: ,p_commit IN VARCHAR2 := FND_API.g_false
552: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
553:
554: ,x_return_status OUT NOCOPY VARCHAR2
555: ,x_msg_count OUT NOCOPY NUMBER
556: ,x_msg_data OUT NOCOPY VARCHAR2

Line 604: IF FND_API.to_boolean(p_init_msg_list) THEN

600: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
601: PVX_Utility_PVT.debug_message(l_full_name||': start');
602: END IF;
603:
604: IF FND_API.to_boolean(p_init_msg_list) THEN
605: FND_MSG_PUB.initialize;
606: END IF;
607:
608: IF NOT FND_API.compatible_api_call(

Line 608: IF NOT FND_API.compatible_api_call(

604: IF FND_API.to_boolean(p_init_msg_list) THEN
605: FND_MSG_PUB.initialize;
606: END IF;
607:
608: IF NOT FND_API.compatible_api_call(
609: l_api_version,
610: p_api_version,
611: l_api_name,
612: g_pkg_name

Line 614: RAISE FND_API.g_exc_unexpected_error;

610: p_api_version,
611: l_api_name,
612: g_pkg_name
613: ) THEN
614: RAISE FND_API.g_exc_unexpected_error;
615: END IF;
616:
617: x_return_status := FND_API.G_RET_STS_SUCCESS;
618:

Line 617: x_return_status := FND_API.G_RET_STS_SUCCESS;

613: ) THEN
614: RAISE FND_API.g_exc_unexpected_error;
615: END IF;
616:
617: x_return_status := FND_API.G_RET_STS_SUCCESS;
618:
619: --dbms_output.put_line('Before Validate');
620:
621: ----------------------- validate ----------------------

Line 633: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

629: p_validation_mode => JTF_PLSQL_API.g_update,
630: x_return_status => l_return_status
631: );
632:
633: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
634: RAISE FND_API.g_exc_unexpected_error;
635: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
636: RAISE FND_API.g_exc_error;
637: END IF;

Line 634: RAISE FND_API.g_exc_unexpected_error;

630: x_return_status => l_return_status
631: );
632:
633: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
634: RAISE FND_API.g_exc_unexpected_error;
635: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
636: RAISE FND_API.g_exc_error;
637: END IF;
638: END IF;

Line 635: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

631: );
632:
633: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
634: RAISE FND_API.g_exc_unexpected_error;
635: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
636: RAISE FND_API.g_exc_error;
637: END IF;
638: END IF;
639:

Line 636: RAISE FND_API.g_exc_error;

632:
633: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
634: RAISE FND_API.g_exc_unexpected_error;
635: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
636: RAISE FND_API.g_exc_error;
637: END IF;
638: END IF;
639:
640: -- replace g_miss_char/num/date with current column values

Line 656: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

652: p_mode => l_mode,
653: x_return_status => l_return_status
654: );
655:
656: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
657: RAISE FND_API.g_exc_unexpected_error;
658: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
659: RAISE FND_API.g_exc_error;
660: END IF;

Line 657: RAISE FND_API.g_exc_unexpected_error;

653: x_return_status => l_return_status
654: );
655:
656: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
657: RAISE FND_API.g_exc_unexpected_error;
658: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
659: RAISE FND_API.g_exc_error;
660: END IF;
661: END IF;

Line 658: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

654: );
655:
656: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
657: RAISE FND_API.g_exc_unexpected_error;
658: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
659: RAISE FND_API.g_exc_error;
660: END IF;
661: END IF;
662:

Line 659: RAISE FND_API.g_exc_error;

655:
656: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
657: RAISE FND_API.g_exc_unexpected_error;
658: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
659: RAISE FND_API.g_exc_error;
660: END IF;
661: END IF;
662:
663:

Line 673: IF l_prtnr_prfls_rec.status IS NULL OR l_prtnr_prfls_rec.status = FND_API.G_MISS_CHAR THEN

669: --dbms_output.put_line('partner_profile_id = '||TO_CHAR(l_prtnr_prfls_rec.partner_profile_id));
670: --dbms_output.put_line('object_version_number = '||TO_CHAR(l_prtnr_prfls_rec.object_version_number));
671:
672:
673: IF l_prtnr_prfls_rec.status IS NULL OR l_prtnr_prfls_rec.status = FND_API.G_MISS_CHAR THEN
674: Determine_Partner_Status(l_prtnr_prfls_rec, l_status);
675: ELSE
676: l_status := l_prtnr_prfls_rec.status;
677: END IF;

Line 766: RAISE FND_API.g_exc_error;

762: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
763: FND_MESSAGE.set_name('PV', 'PV_NO_RECORD_FOUND');
764: FND_MSG_PUB.add;
765: END IF;
766: RAISE FND_API.g_exc_error;
767: END IF;
768:
769: -- Call the PVX_PRTNR_PRFLS_PVT.Update_Prtnr_Prfls recursively
770: -- if partner_id also happens to be a related_partner_id for some records

Line 815: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

811: ,p_prtnr_prfls_rec => rel_prtnr_prfls_rec
812: );
813:
814: /*
815: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
816: FND_MESSAGE.set_name('PV', 'PV_MISC_ERROR_LOGD_RES_ID');
817: FND_MESSAGE.set_token('ID',to_char(l_admin_rec.logged_resource_id) );
818: FND_MSG_PUB.add;
819: END IF;

Line 822: IF x_return_status = FND_API.g_ret_sts_error THEN

818: FND_MSG_PUB.add;
819: END IF;
820: */
821:
822: IF x_return_status = FND_API.g_ret_sts_error THEN
823: RAISE FND_API.g_exc_error;
824: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
825: RAISE FND_API.g_exc_unexpected_error;
826: END IF;

Line 823: RAISE FND_API.g_exc_error;

819: END IF;
820: */
821:
822: IF x_return_status = FND_API.g_ret_sts_error THEN
823: RAISE FND_API.g_exc_error;
824: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
825: RAISE FND_API.g_exc_unexpected_error;
826: END IF;
827:

Line 824: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

820: */
821:
822: IF x_return_status = FND_API.g_ret_sts_error THEN
823: RAISE FND_API.g_exc_error;
824: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
825: RAISE FND_API.g_exc_unexpected_error;
826: END IF;
827:
828:

Line 825: RAISE FND_API.g_exc_unexpected_error;

821:
822: IF x_return_status = FND_API.g_ret_sts_error THEN
823: RAISE FND_API.g_exc_error;
824: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
825: RAISE FND_API.g_exc_unexpected_error;
826: END IF;
827:
828:
829: --dbms_output.put_line('After updating the related_partner_id record');

Line 836: IF FND_API.to_boolean(p_commit) THEN

832:
833: -------------------- finish --------------------------
834:
835: -- Check for commit
836: IF FND_API.to_boolean(p_commit) THEN
837: COMMIT;
838: END IF;
839:
840: FND_MSG_PUB.count_and_get(

Line 841: p_encoded => FND_API.g_false,

837: COMMIT;
838: END IF;
839:
840: FND_MSG_PUB.count_and_get(
841: p_encoded => FND_API.g_false,
842: p_count => x_msg_count,
843: p_data => x_msg_data
844: );
845:

Line 852: WHEN FND_API.g_exc_error THEN

848: END IF;
849:
850: EXCEPTION
851:
852: WHEN FND_API.g_exc_error THEN
853: ROLLBACK TO Update_Prtnr_Prfls;
854: x_return_status := FND_API.g_ret_sts_error;
855: FND_MSG_PUB.count_and_get(
856: p_encoded => FND_API.g_false,

Line 854: x_return_status := FND_API.g_ret_sts_error;

850: EXCEPTION
851:
852: WHEN FND_API.g_exc_error THEN
853: ROLLBACK TO Update_Prtnr_Prfls;
854: x_return_status := FND_API.g_ret_sts_error;
855: FND_MSG_PUB.count_and_get(
856: p_encoded => FND_API.g_false,
857: p_count => x_msg_count,
858: p_data => x_msg_data

Line 856: p_encoded => FND_API.g_false,

852: WHEN FND_API.g_exc_error THEN
853: ROLLBACK TO Update_Prtnr_Prfls;
854: x_return_status := FND_API.g_ret_sts_error;
855: FND_MSG_PUB.count_and_get(
856: p_encoded => FND_API.g_false,
857: p_count => x_msg_count,
858: p_data => x_msg_data
859: );
860:

Line 861: WHEN FND_API.g_exc_unexpected_error THEN

857: p_count => x_msg_count,
858: p_data => x_msg_data
859: );
860:
861: WHEN FND_API.g_exc_unexpected_error THEN
862: ROLLBACK TO Update_Prtnr_Prfls;
863: x_return_status := FND_API.g_ret_sts_unexp_error ;
864: FND_MSG_PUB.count_and_get(
865: p_encoded => FND_API.g_false,

Line 863: x_return_status := FND_API.g_ret_sts_unexp_error ;

859: );
860:
861: WHEN FND_API.g_exc_unexpected_error THEN
862: ROLLBACK TO Update_Prtnr_Prfls;
863: x_return_status := FND_API.g_ret_sts_unexp_error ;
864: FND_MSG_PUB.count_and_get(
865: p_encoded => FND_API.g_false,
866: p_count => x_msg_count,
867: p_data => x_msg_data

Line 865: p_encoded => FND_API.g_false,

861: WHEN FND_API.g_exc_unexpected_error THEN
862: ROLLBACK TO Update_Prtnr_Prfls;
863: x_return_status := FND_API.g_ret_sts_unexp_error ;
864: FND_MSG_PUB.count_and_get(
865: p_encoded => FND_API.g_false,
866: p_count => x_msg_count,
867: p_data => x_msg_data
868: );
869:

Line 872: x_return_status := FND_API.g_ret_sts_unexp_error ;

868: );
869:
870: WHEN OTHERS THEN
871: ROLLBACK TO Update_Prtnr_Prfls;
872: x_return_status := FND_API.g_ret_sts_unexp_error ;
873:
874: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
875: THEN
876: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 880: p_encoded => FND_API.g_false,

876: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
877: END IF;
878:
879: FND_MSG_PUB.count_and_get(
880: p_encoded => FND_API.g_false,
881: p_count => x_msg_count,
882: p_data => x_msg_data
883: );
884:

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

891: --
892: --------------------------------------------------------------------
893: PROCEDURE Validate_Prtnr_Prfls(
894: p_api_version IN NUMBER
895: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
896: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
897:
898: ,x_return_status OUT NOCOPY VARCHAR2
899: ,x_msg_count OUT NOCOPY NUMBER

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

892: --------------------------------------------------------------------
893: PROCEDURE Validate_Prtnr_Prfls(
894: p_api_version IN NUMBER
895: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
896: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
897:
898: ,x_return_status OUT NOCOPY VARCHAR2
899: ,x_msg_count OUT NOCOPY NUMBER
900: ,x_msg_data OUT NOCOPY VARCHAR2

Line 918: IF FND_API.to_boolean(p_init_msg_list) THEN

914: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
915: PVX_Utility_PVT.debug_message(l_full_name||': start');
916: END IF;
917:
918: IF FND_API.to_boolean(p_init_msg_list) THEN
919: FND_MSG_PUB.initialize;
920: END IF;
921:
922: IF NOT FND_API.compatible_api_call(

Line 922: IF NOT FND_API.compatible_api_call(

918: IF FND_API.to_boolean(p_init_msg_list) THEN
919: FND_MSG_PUB.initialize;
920: END IF;
921:
922: IF NOT FND_API.compatible_api_call(
923: l_api_version,
924: p_api_version,
925: l_api_name,
926: g_pkg_name

Line 928: RAISE FND_API.g_exc_unexpected_error;

924: p_api_version,
925: l_api_name,
926: g_pkg_name
927: ) THEN
928: RAISE FND_API.g_exc_unexpected_error;
929: END IF;
930:
931: x_return_status := FND_API.g_ret_sts_success;
932:

Line 931: x_return_status := FND_API.g_ret_sts_success;

927: ) THEN
928: RAISE FND_API.g_exc_unexpected_error;
929: END IF;
930:
931: x_return_status := FND_API.g_ret_sts_success;
932:
933: ---------------------- validate ------------------------
934: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
935: PVX_Utility_PVT.debug_message(l_full_name||': check items');

Line 946: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

942: p_validation_mode => JTF_PLSQL_API.g_create,
943: x_return_status => l_return_status
944: );
945:
946: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
947: RAISE FND_API.g_exc_unexpected_error;
948: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
949: RAISE FND_API.g_exc_error;
950: END IF;

Line 947: RAISE FND_API.g_exc_unexpected_error;

943: x_return_status => l_return_status
944: );
945:
946: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
947: RAISE FND_API.g_exc_unexpected_error;
948: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
949: RAISE FND_API.g_exc_error;
950: END IF;
951: END IF;

Line 948: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

944: );
945:
946: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
947: RAISE FND_API.g_exc_unexpected_error;
948: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
949: RAISE FND_API.g_exc_error;
950: END IF;
951: END IF;
952:

Line 949: RAISE FND_API.g_exc_error;

945:
946: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
947: RAISE FND_API.g_exc_unexpected_error;
948: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
949: RAISE FND_API.g_exc_error;
950: END IF;
951: END IF;
952:
953: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

Line 966: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

962: p_complete_rec => NULL,
963: x_return_status => l_return_status
964: );
965:
966: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
967: RAISE FND_API.g_exc_unexpected_error;
968: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
969: RAISE FND_API.g_exc_error;
970: END IF;

Line 967: RAISE FND_API.g_exc_unexpected_error;

963: x_return_status => l_return_status
964: );
965:
966: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
967: RAISE FND_API.g_exc_unexpected_error;
968: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
969: RAISE FND_API.g_exc_error;
970: END IF;
971: END IF;

Line 968: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

964: );
965:
966: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
967: RAISE FND_API.g_exc_unexpected_error;
968: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
969: RAISE FND_API.g_exc_error;
970: END IF;
971: END IF;
972:

Line 969: RAISE FND_API.g_exc_error;

965:
966: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
967: RAISE FND_API.g_exc_unexpected_error;
968: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
969: RAISE FND_API.g_exc_error;
970: END IF;
971: END IF;
972:
973: -------------------- finish --------------------------

Line 975: p_encoded => FND_API.g_false,

971: END IF;
972:
973: -------------------- finish --------------------------
974: FND_MSG_PUB.count_and_get(
975: p_encoded => FND_API.g_false,
976: p_count => x_msg_count,
977: p_data => x_msg_data
978: );
979:

Line 986: WHEN FND_API.g_exc_error THEN

982: END IF;
983:
984: EXCEPTION
985:
986: WHEN FND_API.g_exc_error THEN
987: x_return_status := FND_API.g_ret_sts_error;
988: FND_MSG_PUB.count_and_get(
989: p_encoded => FND_API.g_false,
990: p_count => x_msg_count,

Line 987: x_return_status := FND_API.g_ret_sts_error;

983:
984: EXCEPTION
985:
986: WHEN FND_API.g_exc_error THEN
987: x_return_status := FND_API.g_ret_sts_error;
988: FND_MSG_PUB.count_and_get(
989: p_encoded => FND_API.g_false,
990: p_count => x_msg_count,
991: p_data => x_msg_data

Line 989: p_encoded => FND_API.g_false,

985:
986: WHEN FND_API.g_exc_error THEN
987: x_return_status := FND_API.g_ret_sts_error;
988: FND_MSG_PUB.count_and_get(
989: p_encoded => FND_API.g_false,
990: p_count => x_msg_count,
991: p_data => x_msg_data
992: );
993:

Line 994: WHEN FND_API.g_exc_unexpected_error THEN

990: p_count => x_msg_count,
991: p_data => x_msg_data
992: );
993:
994: WHEN FND_API.g_exc_unexpected_error THEN
995: x_return_status := FND_API.g_ret_sts_unexp_error ;
996: FND_MSG_PUB.count_and_get(
997: p_encoded => FND_API.g_false,
998: p_count => x_msg_count,

Line 995: x_return_status := FND_API.g_ret_sts_unexp_error ;

991: p_data => x_msg_data
992: );
993:
994: WHEN FND_API.g_exc_unexpected_error THEN
995: x_return_status := FND_API.g_ret_sts_unexp_error ;
996: FND_MSG_PUB.count_and_get(
997: p_encoded => FND_API.g_false,
998: p_count => x_msg_count,
999: p_data => x_msg_data

Line 997: p_encoded => FND_API.g_false,

993:
994: WHEN FND_API.g_exc_unexpected_error THEN
995: x_return_status := FND_API.g_ret_sts_unexp_error ;
996: FND_MSG_PUB.count_and_get(
997: p_encoded => FND_API.g_false,
998: p_count => x_msg_count,
999: p_data => x_msg_data
1000: );
1001:

Line 1003: x_return_status := FND_API.g_ret_sts_unexp_error;

999: p_data => x_msg_data
1000: );
1001:
1002: WHEN OTHERS THEN
1003: x_return_status := FND_API.g_ret_sts_unexp_error;
1004: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1005: THEN
1006: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1007: END IF;

Line 1010: p_encoded => FND_API.g_false,

1006: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1007: END IF;
1008:
1009: FND_MSG_PUB.count_and_get(
1010: p_encoded => FND_API.g_false,
1011: p_count => x_msg_count,
1012: p_data => x_msg_data
1013: );
1014:

Line 1119: x_return_status := FND_API.g_ret_sts_success;

1115: )
1116: IS
1117: BEGIN
1118:
1119: x_return_status := FND_API.g_ret_sts_success;
1120:
1121: ------------------------ partner_id --------------------------
1122: IF p_prtnr_prfls_rec.partner_id IS NULL THEN
1123: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

Line 1130: x_return_status := FND_API.g_ret_sts_error;

1126: FND_MESSAGE.set_token('ID',to_char(p_prtnr_prfls_rec.partner_id) );
1127: FND_MSG_PUB.add;
1128: END IF;
1129:
1130: x_return_status := FND_API.g_ret_sts_error;
1131: RETURN;
1132: ------------------------ cm_id -------------------------------
1133: /*ELSIF p_prtnr_prfls_rec.cm_id IS NULL THEN
1134: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

Line 1141: x_return_status := FND_API.g_ret_sts_error;

1137: FND_MESSAGE.set_token('ID',to_char(p_prtnr_prfls_rec.cm_id) );
1138: FND_MSG_PUB.add;
1139: END IF;
1140:
1141: x_return_status := FND_API.g_ret_sts_error;
1142: RETURN; */
1143: END IF;
1144:
1145: END Check_Req_Items;

Line 1162: x_return_status := FND_API.g_ret_sts_success;

1158: IS
1159: l_valid_flag VARCHAR2(1);
1160: BEGIN
1161:
1162: x_return_status := FND_API.g_ret_sts_success;
1163:
1164: -- when attr_val_id is passed in, we need to
1165: -- check if this is unique.
1166: IF p_validation_mode = JTF_PLSQL_API.g_create

Line 1172: ) = FND_API.g_false

1168: THEN
1169: IF PVX_Utility_PVT.check_uniqueness(
1170: 'PV_PARTNER_PROFILES',
1171: 'partner_profile_id = ' || p_prtnr_prfls_rec.partner_profile_id
1172: ) = FND_API.g_false
1173: THEN
1174: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1175: THEN
1176: FND_MESSAGE.set_name('PV', 'PV_DUPLICATE_ID');

Line 1180: x_return_status := FND_API.g_ret_sts_error;

1176: FND_MESSAGE.set_name('PV', 'PV_DUPLICATE_ID');
1177: FND_MESSAGE.set_token('ID',to_char(p_prtnr_prfls_rec.partner_profile_id) );
1178: FND_MSG_PUB.add;
1179: END IF;
1180: x_return_status := FND_API.g_ret_sts_error;
1181: RETURN;
1182: END IF;
1183: END IF;
1184:

Line 1202: x_return_status := FND_API.g_ret_sts_success;

1198: )
1199: IS
1200: BEGIN
1201:
1202: x_return_status := FND_API.g_ret_sts_success;
1203:
1204:
1205: ----------------------- partner_id ------------------------
1206: IF p_prtnr_prfls_rec.partner_id <> FND_API.g_miss_num THEN

Line 1206: IF p_prtnr_prfls_rec.partner_id <> FND_API.g_miss_num THEN

1202: x_return_status := FND_API.g_ret_sts_success;
1203:
1204:
1205: ----------------------- partner_id ------------------------
1206: IF p_prtnr_prfls_rec.partner_id <> FND_API.g_miss_num THEN
1207: IF PVX_Utility_PVT.check_fk_exists(
1208: 'HZ_PARTIES', -- Parent schema object having the primary key
1209: 'PARTY_ID', -- Column name in the parent object that maps to the fk value
1210: p_prtnr_prfls_rec.partner_id, -- Value of fk to be validated against the parent object's pk column

Line 1212: ) = FND_API.g_false

1208: 'HZ_PARTIES', -- Parent schema object having the primary key
1209: 'PARTY_ID', -- Column name in the parent object that maps to the fk value
1210: p_prtnr_prfls_rec.partner_id, -- Value of fk to be validated against the parent object's pk column
1211: PVX_utility_PVT.g_number -- datatype of fk
1212: ) = FND_API.g_false
1213: THEN
1214: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1215: THEN
1216: FND_MESSAGE.set_name('PV', 'PV_BAD_PARTNER_ID');

Line 1221: x_return_status := FND_API.g_ret_sts_error;

1217: FND_MESSAGE.set_token('ID',to_char(p_prtnr_prfls_rec.partner_id) );
1218: FND_MSG_PUB.add;
1219: END IF;
1220:
1221: x_return_status := FND_API.g_ret_sts_error;
1222: RETURN;
1223: END IF;
1224: END IF;
1225:

Line 1243: x_return_status := FND_API.g_ret_sts_success;

1239: )
1240: IS
1241: BEGIN
1242:
1243: x_return_status := FND_API.g_ret_sts_success;
1244:
1245:
1246: -- check other lookup codes
1247:

Line 1263: x_return_status := FND_API.g_ret_sts_success;

1259: )
1260: IS
1261: BEGIN
1262:
1263: x_return_status := FND_API.g_ret_sts_success;
1264: ----------------------- lead_share_appr_flag ------------------------
1265: IF p_prtnr_prfls_rec.lead_share_appr_flag <> FND_API.g_miss_char
1266: AND p_prtnr_prfls_rec.lead_share_appr_flag IS NOT NULL
1267: THEN

Line 1265: IF p_prtnr_prfls_rec.lead_share_appr_flag <> FND_API.g_miss_char

1261: BEGIN
1262:
1263: x_return_status := FND_API.g_ret_sts_success;
1264: ----------------------- lead_share_appr_flag ------------------------
1265: IF p_prtnr_prfls_rec.lead_share_appr_flag <> FND_API.g_miss_char
1266: AND p_prtnr_prfls_rec.lead_share_appr_flag IS NOT NULL
1267: THEN
1268: IF PVX_Utility_PVT.is_Y_or_N(p_prtnr_prfls_rec.lead_share_appr_flag) = FND_API.g_false
1269: THEN

Line 1268: IF PVX_Utility_PVT.is_Y_or_N(p_prtnr_prfls_rec.lead_share_appr_flag) = FND_API.g_false

1264: ----------------------- lead_share_appr_flag ------------------------
1265: IF p_prtnr_prfls_rec.lead_share_appr_flag <> FND_API.g_miss_char
1266: AND p_prtnr_prfls_rec.lead_share_appr_flag IS NOT NULL
1267: THEN
1268: IF PVX_Utility_PVT.is_Y_or_N(p_prtnr_prfls_rec.lead_share_appr_flag) = FND_API.g_false
1269: THEN
1270: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1271: THEN
1272: FND_MESSAGE.set_name('PV', 'PV_INVALID_FLAG');

Line 1276: x_return_status := FND_API.g_ret_sts_error;

1272: FND_MESSAGE.set_name('PV', 'PV_INVALID_FLAG');
1273: FND_MSG_PUB.add;
1274: END IF;
1275:
1276: x_return_status := FND_API.g_ret_sts_error;
1277: RETURN;
1278: END IF;
1279: END IF;
1280:

Line 1305: IF x_return_status <> FND_API.g_ret_sts_success THEN

1301: p_prtnr_prfls_rec => p_prtnr_prfls_rec
1302: ,x_return_status => x_return_status
1303: );
1304:
1305: IF x_return_status <> FND_API.g_ret_sts_success THEN
1306: RETURN;
1307: END IF;
1308:
1309: --dbms_output.put_line(': start uk record validate');

Line 1316: IF x_return_status <> FND_API.g_ret_sts_success THEN

1312: ,p_validation_mode => p_validation_mode
1313: ,x_return_status => x_return_status
1314: );
1315:
1316: IF x_return_status <> FND_API.g_ret_sts_success THEN
1317: RETURN;
1318: END IF;
1319:
1320: --dbms_output.put_line(': start fk record validate');

Line 1326: IF x_return_status <> FND_API.g_ret_sts_success THEN

1322: p_prtnr_prfls_rec => p_prtnr_prfls_rec
1323: ,x_return_status => x_return_status
1324: );
1325:
1326: IF x_return_status <> FND_API.g_ret_sts_success THEN
1327: RETURN;
1328: END IF;
1329:
1330: --dbms_output.put_line(': start lookup record validate');

Line 1336: IF x_return_status <> FND_API.g_ret_sts_success THEN

1332: p_prtnr_prfls_rec => p_prtnr_prfls_rec
1333: ,x_return_status => x_return_status
1334: );
1335:
1336: IF x_return_status <> FND_API.g_ret_sts_success THEN
1337: RETURN;
1338: END IF;
1339:
1340: --dbms_output.put_line(': start flag record validate');

Line 1346: IF x_return_status <> FND_API.g_ret_sts_success THEN

1342: p_prtnr_prfls_rec => p_prtnr_prfls_rec
1343: ,x_return_status => x_return_status
1344: );
1345:
1346: IF x_return_status <> FND_API.g_ret_sts_success THEN
1347: RETURN;
1348: END IF;
1349:
1350: END Check_Prtnr_Prfls_Items;

Line 1368: x_return_status := FND_API.g_ret_sts_success;

1364: )
1365: IS
1366: BEGIN
1367:
1368: x_return_status := FND_API.g_ret_sts_success;
1369: /* Raise an error if already NOT NULL value for CM_ID is being updated to null.
1370: */
1371: IF p_complete_rec.cm_id IS NOT NULL THEN
1372: IF p_prtnr_prfls_rec.cm_id IS NULL THEN

Line 1373: --OR p_prtnr_prfls_rec.cm_id = FND_API.G_MISS_NUM

1369: /* Raise an error if already NOT NULL value for CM_ID is being updated to null.
1370: */
1371: IF p_complete_rec.cm_id IS NOT NULL THEN
1372: IF p_prtnr_prfls_rec.cm_id IS NULL THEN
1373: --OR p_prtnr_prfls_rec.cm_id = FND_API.G_MISS_NUM
1374: FND_MESSAGE.Set_name('PV','PV_CM_ID_UPDATE_VIOLATION');
1375: FND_MESSAGE.Set_Token('ID', TO_CHAR(p_complete_rec.cm_id));
1376: FND_MSG_PUB.ADD;
1377: x_return_status := FND_API.g_ret_sts_error;

Line 1377: x_return_status := FND_API.g_ret_sts_error;

1373: --OR p_prtnr_prfls_rec.cm_id = FND_API.G_MISS_NUM
1374: FND_MESSAGE.Set_name('PV','PV_CM_ID_UPDATE_VIOLATION');
1375: FND_MESSAGE.Set_Token('ID', TO_CHAR(p_complete_rec.cm_id));
1376: FND_MSG_PUB.ADD;
1377: x_return_status := FND_API.g_ret_sts_error;
1378: RETURN;
1379: END IF;
1380: END IF;
1381:

Line 1397: x_prtnr_prfls_rec.PARTNER_PROFILE_ID := FND_API.G_MISS_NUM;

1393: x_prtnr_prfls_rec OUT NOCOPY prtnr_prfls_rec_type
1394: )
1395: IS
1396: BEGIN
1397: x_prtnr_prfls_rec.PARTNER_PROFILE_ID := FND_API.G_MISS_NUM;
1398: x_prtnr_prfls_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
1399: x_prtnr_prfls_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
1400: x_prtnr_prfls_rec.CREATION_DATE := FND_API.G_MISS_DATE;
1401: x_prtnr_prfls_rec.CREATED_BY := FND_API.G_MISS_NUM;

Line 1398: x_prtnr_prfls_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;

1394: )
1395: IS
1396: BEGIN
1397: x_prtnr_prfls_rec.PARTNER_PROFILE_ID := FND_API.G_MISS_NUM;
1398: x_prtnr_prfls_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
1399: x_prtnr_prfls_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
1400: x_prtnr_prfls_rec.CREATION_DATE := FND_API.G_MISS_DATE;
1401: x_prtnr_prfls_rec.CREATED_BY := FND_API.G_MISS_NUM;
1402: x_prtnr_prfls_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;

Line 1399: x_prtnr_prfls_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;

1395: IS
1396: BEGIN
1397: x_prtnr_prfls_rec.PARTNER_PROFILE_ID := FND_API.G_MISS_NUM;
1398: x_prtnr_prfls_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
1399: x_prtnr_prfls_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
1400: x_prtnr_prfls_rec.CREATION_DATE := FND_API.G_MISS_DATE;
1401: x_prtnr_prfls_rec.CREATED_BY := FND_API.G_MISS_NUM;
1402: x_prtnr_prfls_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
1403: x_prtnr_prfls_rec.PARTNER_ID := FND_API.G_MISS_NUM;

Line 1400: x_prtnr_prfls_rec.CREATION_DATE := FND_API.G_MISS_DATE;

1396: BEGIN
1397: x_prtnr_prfls_rec.PARTNER_PROFILE_ID := FND_API.G_MISS_NUM;
1398: x_prtnr_prfls_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
1399: x_prtnr_prfls_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
1400: x_prtnr_prfls_rec.CREATION_DATE := FND_API.G_MISS_DATE;
1401: x_prtnr_prfls_rec.CREATED_BY := FND_API.G_MISS_NUM;
1402: x_prtnr_prfls_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
1403: x_prtnr_prfls_rec.PARTNER_ID := FND_API.G_MISS_NUM;
1404: x_prtnr_prfls_rec.TARGET_REVENUE_AMT := FND_API.G_MISS_NUM;

Line 1401: x_prtnr_prfls_rec.CREATED_BY := FND_API.G_MISS_NUM;

1397: x_prtnr_prfls_rec.PARTNER_PROFILE_ID := FND_API.G_MISS_NUM;
1398: x_prtnr_prfls_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
1399: x_prtnr_prfls_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
1400: x_prtnr_prfls_rec.CREATION_DATE := FND_API.G_MISS_DATE;
1401: x_prtnr_prfls_rec.CREATED_BY := FND_API.G_MISS_NUM;
1402: x_prtnr_prfls_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
1403: x_prtnr_prfls_rec.PARTNER_ID := FND_API.G_MISS_NUM;
1404: x_prtnr_prfls_rec.TARGET_REVENUE_AMT := FND_API.G_MISS_NUM;
1405: x_prtnr_prfls_rec.ACTUAL_REVENUE_AMT := FND_API.G_MISS_NUM;

Line 1402: x_prtnr_prfls_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;

1398: x_prtnr_prfls_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
1399: x_prtnr_prfls_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
1400: x_prtnr_prfls_rec.CREATION_DATE := FND_API.G_MISS_DATE;
1401: x_prtnr_prfls_rec.CREATED_BY := FND_API.G_MISS_NUM;
1402: x_prtnr_prfls_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
1403: x_prtnr_prfls_rec.PARTNER_ID := FND_API.G_MISS_NUM;
1404: x_prtnr_prfls_rec.TARGET_REVENUE_AMT := FND_API.G_MISS_NUM;
1405: x_prtnr_prfls_rec.ACTUAL_REVENUE_AMT := FND_API.G_MISS_NUM;
1406: x_prtnr_prfls_rec.TARGET_REVENUE_PCT := FND_API.G_MISS_NUM;

Line 1403: x_prtnr_prfls_rec.PARTNER_ID := FND_API.G_MISS_NUM;

1399: x_prtnr_prfls_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
1400: x_prtnr_prfls_rec.CREATION_DATE := FND_API.G_MISS_DATE;
1401: x_prtnr_prfls_rec.CREATED_BY := FND_API.G_MISS_NUM;
1402: x_prtnr_prfls_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
1403: x_prtnr_prfls_rec.PARTNER_ID := FND_API.G_MISS_NUM;
1404: x_prtnr_prfls_rec.TARGET_REVENUE_AMT := FND_API.G_MISS_NUM;
1405: x_prtnr_prfls_rec.ACTUAL_REVENUE_AMT := FND_API.G_MISS_NUM;
1406: x_prtnr_prfls_rec.TARGET_REVENUE_PCT := FND_API.G_MISS_NUM;
1407: x_prtnr_prfls_rec.ACTUAL_REVENUE_PCT := FND_API.G_MISS_NUM;

Line 1404: x_prtnr_prfls_rec.TARGET_REVENUE_AMT := FND_API.G_MISS_NUM;

1400: x_prtnr_prfls_rec.CREATION_DATE := FND_API.G_MISS_DATE;
1401: x_prtnr_prfls_rec.CREATED_BY := FND_API.G_MISS_NUM;
1402: x_prtnr_prfls_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
1403: x_prtnr_prfls_rec.PARTNER_ID := FND_API.G_MISS_NUM;
1404: x_prtnr_prfls_rec.TARGET_REVENUE_AMT := FND_API.G_MISS_NUM;
1405: x_prtnr_prfls_rec.ACTUAL_REVENUE_AMT := FND_API.G_MISS_NUM;
1406: x_prtnr_prfls_rec.TARGET_REVENUE_PCT := FND_API.G_MISS_NUM;
1407: x_prtnr_prfls_rec.ACTUAL_REVENUE_PCT := FND_API.G_MISS_NUM;
1408: x_prtnr_prfls_rec.ORIG_SYSTEM_REFERENCE := FND_API.G_MISS_CHAR;

Line 1405: x_prtnr_prfls_rec.ACTUAL_REVENUE_AMT := FND_API.G_MISS_NUM;

1401: x_prtnr_prfls_rec.CREATED_BY := FND_API.G_MISS_NUM;
1402: x_prtnr_prfls_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
1403: x_prtnr_prfls_rec.PARTNER_ID := FND_API.G_MISS_NUM;
1404: x_prtnr_prfls_rec.TARGET_REVENUE_AMT := FND_API.G_MISS_NUM;
1405: x_prtnr_prfls_rec.ACTUAL_REVENUE_AMT := FND_API.G_MISS_NUM;
1406: x_prtnr_prfls_rec.TARGET_REVENUE_PCT := FND_API.G_MISS_NUM;
1407: x_prtnr_prfls_rec.ACTUAL_REVENUE_PCT := FND_API.G_MISS_NUM;
1408: x_prtnr_prfls_rec.ORIG_SYSTEM_REFERENCE := FND_API.G_MISS_CHAR;
1409: x_prtnr_prfls_rec.ORIG_SYSTEM_TYPE := FND_API.G_MISS_CHAR;

Line 1406: x_prtnr_prfls_rec.TARGET_REVENUE_PCT := FND_API.G_MISS_NUM;

1402: x_prtnr_prfls_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
1403: x_prtnr_prfls_rec.PARTNER_ID := FND_API.G_MISS_NUM;
1404: x_prtnr_prfls_rec.TARGET_REVENUE_AMT := FND_API.G_MISS_NUM;
1405: x_prtnr_prfls_rec.ACTUAL_REVENUE_AMT := FND_API.G_MISS_NUM;
1406: x_prtnr_prfls_rec.TARGET_REVENUE_PCT := FND_API.G_MISS_NUM;
1407: x_prtnr_prfls_rec.ACTUAL_REVENUE_PCT := FND_API.G_MISS_NUM;
1408: x_prtnr_prfls_rec.ORIG_SYSTEM_REFERENCE := FND_API.G_MISS_CHAR;
1409: x_prtnr_prfls_rec.ORIG_SYSTEM_TYPE := FND_API.G_MISS_CHAR;
1410: x_prtnr_prfls_rec.CAPACITY_SIZE := FND_API.G_MISS_CHAR;

Line 1407: x_prtnr_prfls_rec.ACTUAL_REVENUE_PCT := FND_API.G_MISS_NUM;

1403: x_prtnr_prfls_rec.PARTNER_ID := FND_API.G_MISS_NUM;
1404: x_prtnr_prfls_rec.TARGET_REVENUE_AMT := FND_API.G_MISS_NUM;
1405: x_prtnr_prfls_rec.ACTUAL_REVENUE_AMT := FND_API.G_MISS_NUM;
1406: x_prtnr_prfls_rec.TARGET_REVENUE_PCT := FND_API.G_MISS_NUM;
1407: x_prtnr_prfls_rec.ACTUAL_REVENUE_PCT := FND_API.G_MISS_NUM;
1408: x_prtnr_prfls_rec.ORIG_SYSTEM_REFERENCE := FND_API.G_MISS_CHAR;
1409: x_prtnr_prfls_rec.ORIG_SYSTEM_TYPE := FND_API.G_MISS_CHAR;
1410: x_prtnr_prfls_rec.CAPACITY_SIZE := FND_API.G_MISS_CHAR;
1411: x_prtnr_prfls_rec.CAPACITY_AMOUNT := FND_API.G_MISS_CHAR;

Line 1408: x_prtnr_prfls_rec.ORIG_SYSTEM_REFERENCE := FND_API.G_MISS_CHAR;

1404: x_prtnr_prfls_rec.TARGET_REVENUE_AMT := FND_API.G_MISS_NUM;
1405: x_prtnr_prfls_rec.ACTUAL_REVENUE_AMT := FND_API.G_MISS_NUM;
1406: x_prtnr_prfls_rec.TARGET_REVENUE_PCT := FND_API.G_MISS_NUM;
1407: x_prtnr_prfls_rec.ACTUAL_REVENUE_PCT := FND_API.G_MISS_NUM;
1408: x_prtnr_prfls_rec.ORIG_SYSTEM_REFERENCE := FND_API.G_MISS_CHAR;
1409: x_prtnr_prfls_rec.ORIG_SYSTEM_TYPE := FND_API.G_MISS_CHAR;
1410: x_prtnr_prfls_rec.CAPACITY_SIZE := FND_API.G_MISS_CHAR;
1411: x_prtnr_prfls_rec.CAPACITY_AMOUNT := FND_API.G_MISS_CHAR;
1412: x_prtnr_prfls_rec.AUTO_MATCH_ALLOWED_FLAG := FND_API.G_MISS_CHAR;

Line 1409: x_prtnr_prfls_rec.ORIG_SYSTEM_TYPE := FND_API.G_MISS_CHAR;

1405: x_prtnr_prfls_rec.ACTUAL_REVENUE_AMT := FND_API.G_MISS_NUM;
1406: x_prtnr_prfls_rec.TARGET_REVENUE_PCT := FND_API.G_MISS_NUM;
1407: x_prtnr_prfls_rec.ACTUAL_REVENUE_PCT := FND_API.G_MISS_NUM;
1408: x_prtnr_prfls_rec.ORIG_SYSTEM_REFERENCE := FND_API.G_MISS_CHAR;
1409: x_prtnr_prfls_rec.ORIG_SYSTEM_TYPE := FND_API.G_MISS_CHAR;
1410: x_prtnr_prfls_rec.CAPACITY_SIZE := FND_API.G_MISS_CHAR;
1411: x_prtnr_prfls_rec.CAPACITY_AMOUNT := FND_API.G_MISS_CHAR;
1412: x_prtnr_prfls_rec.AUTO_MATCH_ALLOWED_FLAG := FND_API.G_MISS_CHAR;
1413: x_prtnr_prfls_rec.PURCHASE_METHOD := FND_API.G_MISS_CHAR;

Line 1410: x_prtnr_prfls_rec.CAPACITY_SIZE := FND_API.G_MISS_CHAR;

1406: x_prtnr_prfls_rec.TARGET_REVENUE_PCT := FND_API.G_MISS_NUM;
1407: x_prtnr_prfls_rec.ACTUAL_REVENUE_PCT := FND_API.G_MISS_NUM;
1408: x_prtnr_prfls_rec.ORIG_SYSTEM_REFERENCE := FND_API.G_MISS_CHAR;
1409: x_prtnr_prfls_rec.ORIG_SYSTEM_TYPE := FND_API.G_MISS_CHAR;
1410: x_prtnr_prfls_rec.CAPACITY_SIZE := FND_API.G_MISS_CHAR;
1411: x_prtnr_prfls_rec.CAPACITY_AMOUNT := FND_API.G_MISS_CHAR;
1412: x_prtnr_prfls_rec.AUTO_MATCH_ALLOWED_FLAG := FND_API.G_MISS_CHAR;
1413: x_prtnr_prfls_rec.PURCHASE_METHOD := FND_API.G_MISS_CHAR;
1414: x_prtnr_prfls_rec.CM_ID := FND_API.G_MISS_NUM;

Line 1411: x_prtnr_prfls_rec.CAPACITY_AMOUNT := FND_API.G_MISS_CHAR;

1407: x_prtnr_prfls_rec.ACTUAL_REVENUE_PCT := FND_API.G_MISS_NUM;
1408: x_prtnr_prfls_rec.ORIG_SYSTEM_REFERENCE := FND_API.G_MISS_CHAR;
1409: x_prtnr_prfls_rec.ORIG_SYSTEM_TYPE := FND_API.G_MISS_CHAR;
1410: x_prtnr_prfls_rec.CAPACITY_SIZE := FND_API.G_MISS_CHAR;
1411: x_prtnr_prfls_rec.CAPACITY_AMOUNT := FND_API.G_MISS_CHAR;
1412: x_prtnr_prfls_rec.AUTO_MATCH_ALLOWED_FLAG := FND_API.G_MISS_CHAR;
1413: x_prtnr_prfls_rec.PURCHASE_METHOD := FND_API.G_MISS_CHAR;
1414: x_prtnr_prfls_rec.CM_ID := FND_API.G_MISS_NUM;
1415: x_prtnr_prfls_rec.PH_SUPPORT_REP := FND_API.G_MISS_NUM;

Line 1412: x_prtnr_prfls_rec.AUTO_MATCH_ALLOWED_FLAG := FND_API.G_MISS_CHAR;

1408: x_prtnr_prfls_rec.ORIG_SYSTEM_REFERENCE := FND_API.G_MISS_CHAR;
1409: x_prtnr_prfls_rec.ORIG_SYSTEM_TYPE := FND_API.G_MISS_CHAR;
1410: x_prtnr_prfls_rec.CAPACITY_SIZE := FND_API.G_MISS_CHAR;
1411: x_prtnr_prfls_rec.CAPACITY_AMOUNT := FND_API.G_MISS_CHAR;
1412: x_prtnr_prfls_rec.AUTO_MATCH_ALLOWED_FLAG := FND_API.G_MISS_CHAR;
1413: x_prtnr_prfls_rec.PURCHASE_METHOD := FND_API.G_MISS_CHAR;
1414: x_prtnr_prfls_rec.CM_ID := FND_API.G_MISS_NUM;
1415: x_prtnr_prfls_rec.PH_SUPPORT_REP := FND_API.G_MISS_NUM;
1416: --x_prtnr_prfls_rec.SECURITY_GROUP_ID := FND_API.G_MISS_NUM;

Line 1413: x_prtnr_prfls_rec.PURCHASE_METHOD := FND_API.G_MISS_CHAR;

1409: x_prtnr_prfls_rec.ORIG_SYSTEM_TYPE := FND_API.G_MISS_CHAR;
1410: x_prtnr_prfls_rec.CAPACITY_SIZE := FND_API.G_MISS_CHAR;
1411: x_prtnr_prfls_rec.CAPACITY_AMOUNT := FND_API.G_MISS_CHAR;
1412: x_prtnr_prfls_rec.AUTO_MATCH_ALLOWED_FLAG := FND_API.G_MISS_CHAR;
1413: x_prtnr_prfls_rec.PURCHASE_METHOD := FND_API.G_MISS_CHAR;
1414: x_prtnr_prfls_rec.CM_ID := FND_API.G_MISS_NUM;
1415: x_prtnr_prfls_rec.PH_SUPPORT_REP := FND_API.G_MISS_NUM;
1416: --x_prtnr_prfls_rec.SECURITY_GROUP_ID := FND_API.G_MISS_NUM;
1417: x_prtnr_prfls_rec.OBJECT_VERSION_NUMBER := FND_API.G_MISS_NUM;

Line 1414: x_prtnr_prfls_rec.CM_ID := FND_API.G_MISS_NUM;

1410: x_prtnr_prfls_rec.CAPACITY_SIZE := FND_API.G_MISS_CHAR;
1411: x_prtnr_prfls_rec.CAPACITY_AMOUNT := FND_API.G_MISS_CHAR;
1412: x_prtnr_prfls_rec.AUTO_MATCH_ALLOWED_FLAG := FND_API.G_MISS_CHAR;
1413: x_prtnr_prfls_rec.PURCHASE_METHOD := FND_API.G_MISS_CHAR;
1414: x_prtnr_prfls_rec.CM_ID := FND_API.G_MISS_NUM;
1415: x_prtnr_prfls_rec.PH_SUPPORT_REP := FND_API.G_MISS_NUM;
1416: --x_prtnr_prfls_rec.SECURITY_GROUP_ID := FND_API.G_MISS_NUM;
1417: x_prtnr_prfls_rec.OBJECT_VERSION_NUMBER := FND_API.G_MISS_NUM;
1418: x_prtnr_prfls_rec.LEAD_SHARING_STATUS := FND_API.G_MISS_CHAR;

Line 1415: x_prtnr_prfls_rec.PH_SUPPORT_REP := FND_API.G_MISS_NUM;

1411: x_prtnr_prfls_rec.CAPACITY_AMOUNT := FND_API.G_MISS_CHAR;
1412: x_prtnr_prfls_rec.AUTO_MATCH_ALLOWED_FLAG := FND_API.G_MISS_CHAR;
1413: x_prtnr_prfls_rec.PURCHASE_METHOD := FND_API.G_MISS_CHAR;
1414: x_prtnr_prfls_rec.CM_ID := FND_API.G_MISS_NUM;
1415: x_prtnr_prfls_rec.PH_SUPPORT_REP := FND_API.G_MISS_NUM;
1416: --x_prtnr_prfls_rec.SECURITY_GROUP_ID := FND_API.G_MISS_NUM;
1417: x_prtnr_prfls_rec.OBJECT_VERSION_NUMBER := FND_API.G_MISS_NUM;
1418: x_prtnr_prfls_rec.LEAD_SHARING_STATUS := FND_API.G_MISS_CHAR;
1419: x_prtnr_prfls_rec.LEAD_SHARE_APPR_FLAG := FND_API.G_MISS_CHAR;

Line 1416: --x_prtnr_prfls_rec.SECURITY_GROUP_ID := FND_API.G_MISS_NUM;

1412: x_prtnr_prfls_rec.AUTO_MATCH_ALLOWED_FLAG := FND_API.G_MISS_CHAR;
1413: x_prtnr_prfls_rec.PURCHASE_METHOD := FND_API.G_MISS_CHAR;
1414: x_prtnr_prfls_rec.CM_ID := FND_API.G_MISS_NUM;
1415: x_prtnr_prfls_rec.PH_SUPPORT_REP := FND_API.G_MISS_NUM;
1416: --x_prtnr_prfls_rec.SECURITY_GROUP_ID := FND_API.G_MISS_NUM;
1417: x_prtnr_prfls_rec.OBJECT_VERSION_NUMBER := FND_API.G_MISS_NUM;
1418: x_prtnr_prfls_rec.LEAD_SHARING_STATUS := FND_API.G_MISS_CHAR;
1419: x_prtnr_prfls_rec.LEAD_SHARE_APPR_FLAG := FND_API.G_MISS_CHAR;
1420: x_prtnr_prfls_rec.PARTNER_RELATIONSHIP_ID := FND_API.G_MISS_NUM;

Line 1417: x_prtnr_prfls_rec.OBJECT_VERSION_NUMBER := FND_API.G_MISS_NUM;

1413: x_prtnr_prfls_rec.PURCHASE_METHOD := FND_API.G_MISS_CHAR;
1414: x_prtnr_prfls_rec.CM_ID := FND_API.G_MISS_NUM;
1415: x_prtnr_prfls_rec.PH_SUPPORT_REP := FND_API.G_MISS_NUM;
1416: --x_prtnr_prfls_rec.SECURITY_GROUP_ID := FND_API.G_MISS_NUM;
1417: x_prtnr_prfls_rec.OBJECT_VERSION_NUMBER := FND_API.G_MISS_NUM;
1418: x_prtnr_prfls_rec.LEAD_SHARING_STATUS := FND_API.G_MISS_CHAR;
1419: x_prtnr_prfls_rec.LEAD_SHARE_APPR_FLAG := FND_API.G_MISS_CHAR;
1420: x_prtnr_prfls_rec.PARTNER_RELATIONSHIP_ID := FND_API.G_MISS_NUM;
1421: x_prtnr_prfls_rec.PARTNER_LEVEL := FND_API.G_MISS_CHAR;

Line 1418: x_prtnr_prfls_rec.LEAD_SHARING_STATUS := FND_API.G_MISS_CHAR;

1414: x_prtnr_prfls_rec.CM_ID := FND_API.G_MISS_NUM;
1415: x_prtnr_prfls_rec.PH_SUPPORT_REP := FND_API.G_MISS_NUM;
1416: --x_prtnr_prfls_rec.SECURITY_GROUP_ID := FND_API.G_MISS_NUM;
1417: x_prtnr_prfls_rec.OBJECT_VERSION_NUMBER := FND_API.G_MISS_NUM;
1418: x_prtnr_prfls_rec.LEAD_SHARING_STATUS := FND_API.G_MISS_CHAR;
1419: x_prtnr_prfls_rec.LEAD_SHARE_APPR_FLAG := FND_API.G_MISS_CHAR;
1420: x_prtnr_prfls_rec.PARTNER_RELATIONSHIP_ID := FND_API.G_MISS_NUM;
1421: x_prtnr_prfls_rec.PARTNER_LEVEL := FND_API.G_MISS_CHAR;
1422: x_prtnr_prfls_rec.PREFERRED_VAD_ID := FND_API.G_MISS_NUM;

Line 1419: x_prtnr_prfls_rec.LEAD_SHARE_APPR_FLAG := FND_API.G_MISS_CHAR;

1415: x_prtnr_prfls_rec.PH_SUPPORT_REP := FND_API.G_MISS_NUM;
1416: --x_prtnr_prfls_rec.SECURITY_GROUP_ID := FND_API.G_MISS_NUM;
1417: x_prtnr_prfls_rec.OBJECT_VERSION_NUMBER := FND_API.G_MISS_NUM;
1418: x_prtnr_prfls_rec.LEAD_SHARING_STATUS := FND_API.G_MISS_CHAR;
1419: x_prtnr_prfls_rec.LEAD_SHARE_APPR_FLAG := FND_API.G_MISS_CHAR;
1420: x_prtnr_prfls_rec.PARTNER_RELATIONSHIP_ID := FND_API.G_MISS_NUM;
1421: x_prtnr_prfls_rec.PARTNER_LEVEL := FND_API.G_MISS_CHAR;
1422: x_prtnr_prfls_rec.PREFERRED_VAD_ID := FND_API.G_MISS_NUM;
1423: x_prtnr_prfls_rec.partner_group_id := FND_API.G_MISS_NUM;

Line 1420: x_prtnr_prfls_rec.PARTNER_RELATIONSHIP_ID := FND_API.G_MISS_NUM;

1416: --x_prtnr_prfls_rec.SECURITY_GROUP_ID := FND_API.G_MISS_NUM;
1417: x_prtnr_prfls_rec.OBJECT_VERSION_NUMBER := FND_API.G_MISS_NUM;
1418: x_prtnr_prfls_rec.LEAD_SHARING_STATUS := FND_API.G_MISS_CHAR;
1419: x_prtnr_prfls_rec.LEAD_SHARE_APPR_FLAG := FND_API.G_MISS_CHAR;
1420: x_prtnr_prfls_rec.PARTNER_RELATIONSHIP_ID := FND_API.G_MISS_NUM;
1421: x_prtnr_prfls_rec.PARTNER_LEVEL := FND_API.G_MISS_CHAR;
1422: x_prtnr_prfls_rec.PREFERRED_VAD_ID := FND_API.G_MISS_NUM;
1423: x_prtnr_prfls_rec.partner_group_id := FND_API.G_MISS_NUM;
1424: x_prtnr_prfls_rec.partner_resource_id := FND_API.G_MISS_NUM;

Line 1421: x_prtnr_prfls_rec.PARTNER_LEVEL := FND_API.G_MISS_CHAR;

1417: x_prtnr_prfls_rec.OBJECT_VERSION_NUMBER := FND_API.G_MISS_NUM;
1418: x_prtnr_prfls_rec.LEAD_SHARING_STATUS := FND_API.G_MISS_CHAR;
1419: x_prtnr_prfls_rec.LEAD_SHARE_APPR_FLAG := FND_API.G_MISS_CHAR;
1420: x_prtnr_prfls_rec.PARTNER_RELATIONSHIP_ID := FND_API.G_MISS_NUM;
1421: x_prtnr_prfls_rec.PARTNER_LEVEL := FND_API.G_MISS_CHAR;
1422: x_prtnr_prfls_rec.PREFERRED_VAD_ID := FND_API.G_MISS_NUM;
1423: x_prtnr_prfls_rec.partner_group_id := FND_API.G_MISS_NUM;
1424: x_prtnr_prfls_rec.partner_resource_id := FND_API.G_MISS_NUM;
1425: x_prtnr_prfls_rec.partner_group_number := FND_API.G_MISS_CHAR;

Line 1422: x_prtnr_prfls_rec.PREFERRED_VAD_ID := FND_API.G_MISS_NUM;

1418: x_prtnr_prfls_rec.LEAD_SHARING_STATUS := FND_API.G_MISS_CHAR;
1419: x_prtnr_prfls_rec.LEAD_SHARE_APPR_FLAG := FND_API.G_MISS_CHAR;
1420: x_prtnr_prfls_rec.PARTNER_RELATIONSHIP_ID := FND_API.G_MISS_NUM;
1421: x_prtnr_prfls_rec.PARTNER_LEVEL := FND_API.G_MISS_CHAR;
1422: x_prtnr_prfls_rec.PREFERRED_VAD_ID := FND_API.G_MISS_NUM;
1423: x_prtnr_prfls_rec.partner_group_id := FND_API.G_MISS_NUM;
1424: x_prtnr_prfls_rec.partner_resource_id := FND_API.G_MISS_NUM;
1425: x_prtnr_prfls_rec.partner_group_number := FND_API.G_MISS_CHAR;
1426: x_prtnr_prfls_rec.partner_resource_number := FND_API.G_MISS_CHAR;

Line 1423: x_prtnr_prfls_rec.partner_group_id := FND_API.G_MISS_NUM;

1419: x_prtnr_prfls_rec.LEAD_SHARE_APPR_FLAG := FND_API.G_MISS_CHAR;
1420: x_prtnr_prfls_rec.PARTNER_RELATIONSHIP_ID := FND_API.G_MISS_NUM;
1421: x_prtnr_prfls_rec.PARTNER_LEVEL := FND_API.G_MISS_CHAR;
1422: x_prtnr_prfls_rec.PREFERRED_VAD_ID := FND_API.G_MISS_NUM;
1423: x_prtnr_prfls_rec.partner_group_id := FND_API.G_MISS_NUM;
1424: x_prtnr_prfls_rec.partner_resource_id := FND_API.G_MISS_NUM;
1425: x_prtnr_prfls_rec.partner_group_number := FND_API.G_MISS_CHAR;
1426: x_prtnr_prfls_rec.partner_resource_number := FND_API.G_MISS_CHAR;
1427: x_prtnr_prfls_rec.sales_partner_flag := FND_API.G_MISS_CHAR;

Line 1424: x_prtnr_prfls_rec.partner_resource_id := FND_API.G_MISS_NUM;

1420: x_prtnr_prfls_rec.PARTNER_RELATIONSHIP_ID := FND_API.G_MISS_NUM;
1421: x_prtnr_prfls_rec.PARTNER_LEVEL := FND_API.G_MISS_CHAR;
1422: x_prtnr_prfls_rec.PREFERRED_VAD_ID := FND_API.G_MISS_NUM;
1423: x_prtnr_prfls_rec.partner_group_id := FND_API.G_MISS_NUM;
1424: x_prtnr_prfls_rec.partner_resource_id := FND_API.G_MISS_NUM;
1425: x_prtnr_prfls_rec.partner_group_number := FND_API.G_MISS_CHAR;
1426: x_prtnr_prfls_rec.partner_resource_number := FND_API.G_MISS_CHAR;
1427: x_prtnr_prfls_rec.sales_partner_flag := FND_API.G_MISS_CHAR;
1428: x_prtnr_prfls_rec.indirectly_managed_flag := FND_API.G_MISS_CHAR;

Line 1425: x_prtnr_prfls_rec.partner_group_number := FND_API.G_MISS_CHAR;

1421: x_prtnr_prfls_rec.PARTNER_LEVEL := FND_API.G_MISS_CHAR;
1422: x_prtnr_prfls_rec.PREFERRED_VAD_ID := FND_API.G_MISS_NUM;
1423: x_prtnr_prfls_rec.partner_group_id := FND_API.G_MISS_NUM;
1424: x_prtnr_prfls_rec.partner_resource_id := FND_API.G_MISS_NUM;
1425: x_prtnr_prfls_rec.partner_group_number := FND_API.G_MISS_CHAR;
1426: x_prtnr_prfls_rec.partner_resource_number := FND_API.G_MISS_CHAR;
1427: x_prtnr_prfls_rec.sales_partner_flag := FND_API.G_MISS_CHAR;
1428: x_prtnr_prfls_rec.indirectly_managed_flag := FND_API.G_MISS_CHAR;
1429: x_prtnr_prfls_rec.channel_marketing_manager := FND_API.G_MISS_NUM;

Line 1426: x_prtnr_prfls_rec.partner_resource_number := FND_API.G_MISS_CHAR;

1422: x_prtnr_prfls_rec.PREFERRED_VAD_ID := FND_API.G_MISS_NUM;
1423: x_prtnr_prfls_rec.partner_group_id := FND_API.G_MISS_NUM;
1424: x_prtnr_prfls_rec.partner_resource_id := FND_API.G_MISS_NUM;
1425: x_prtnr_prfls_rec.partner_group_number := FND_API.G_MISS_CHAR;
1426: x_prtnr_prfls_rec.partner_resource_number := FND_API.G_MISS_CHAR;
1427: x_prtnr_prfls_rec.sales_partner_flag := FND_API.G_MISS_CHAR;
1428: x_prtnr_prfls_rec.indirectly_managed_flag := FND_API.G_MISS_CHAR;
1429: x_prtnr_prfls_rec.channel_marketing_manager := FND_API.G_MISS_NUM;
1430: x_prtnr_prfls_rec.related_partner_id := FND_API.G_MISS_NUM;

Line 1427: x_prtnr_prfls_rec.sales_partner_flag := FND_API.G_MISS_CHAR;

1423: x_prtnr_prfls_rec.partner_group_id := FND_API.G_MISS_NUM;
1424: x_prtnr_prfls_rec.partner_resource_id := FND_API.G_MISS_NUM;
1425: x_prtnr_prfls_rec.partner_group_number := FND_API.G_MISS_CHAR;
1426: x_prtnr_prfls_rec.partner_resource_number := FND_API.G_MISS_CHAR;
1427: x_prtnr_prfls_rec.sales_partner_flag := FND_API.G_MISS_CHAR;
1428: x_prtnr_prfls_rec.indirectly_managed_flag := FND_API.G_MISS_CHAR;
1429: x_prtnr_prfls_rec.channel_marketing_manager := FND_API.G_MISS_NUM;
1430: x_prtnr_prfls_rec.related_partner_id := FND_API.G_MISS_NUM;
1431: x_prtnr_prfls_rec.max_users := FND_API.G_MISS_NUM;

Line 1428: x_prtnr_prfls_rec.indirectly_managed_flag := FND_API.G_MISS_CHAR;

1424: x_prtnr_prfls_rec.partner_resource_id := FND_API.G_MISS_NUM;
1425: x_prtnr_prfls_rec.partner_group_number := FND_API.G_MISS_CHAR;
1426: x_prtnr_prfls_rec.partner_resource_number := FND_API.G_MISS_CHAR;
1427: x_prtnr_prfls_rec.sales_partner_flag := FND_API.G_MISS_CHAR;
1428: x_prtnr_prfls_rec.indirectly_managed_flag := FND_API.G_MISS_CHAR;
1429: x_prtnr_prfls_rec.channel_marketing_manager := FND_API.G_MISS_NUM;
1430: x_prtnr_prfls_rec.related_partner_id := FND_API.G_MISS_NUM;
1431: x_prtnr_prfls_rec.max_users := FND_API.G_MISS_NUM;
1432: x_prtnr_prfls_rec.partner_party_id := FND_API.G_MISS_NUM;

Line 1429: x_prtnr_prfls_rec.channel_marketing_manager := FND_API.G_MISS_NUM;

1425: x_prtnr_prfls_rec.partner_group_number := FND_API.G_MISS_CHAR;
1426: x_prtnr_prfls_rec.partner_resource_number := FND_API.G_MISS_CHAR;
1427: x_prtnr_prfls_rec.sales_partner_flag := FND_API.G_MISS_CHAR;
1428: x_prtnr_prfls_rec.indirectly_managed_flag := FND_API.G_MISS_CHAR;
1429: x_prtnr_prfls_rec.channel_marketing_manager := FND_API.G_MISS_NUM;
1430: x_prtnr_prfls_rec.related_partner_id := FND_API.G_MISS_NUM;
1431: x_prtnr_prfls_rec.max_users := FND_API.G_MISS_NUM;
1432: x_prtnr_prfls_rec.partner_party_id := FND_API.G_MISS_NUM;
1433: x_prtnr_prfls_rec.status := FND_API.G_MISS_CHAR;

Line 1430: x_prtnr_prfls_rec.related_partner_id := FND_API.G_MISS_NUM;

1426: x_prtnr_prfls_rec.partner_resource_number := FND_API.G_MISS_CHAR;
1427: x_prtnr_prfls_rec.sales_partner_flag := FND_API.G_MISS_CHAR;
1428: x_prtnr_prfls_rec.indirectly_managed_flag := FND_API.G_MISS_CHAR;
1429: x_prtnr_prfls_rec.channel_marketing_manager := FND_API.G_MISS_NUM;
1430: x_prtnr_prfls_rec.related_partner_id := FND_API.G_MISS_NUM;
1431: x_prtnr_prfls_rec.max_users := FND_API.G_MISS_NUM;
1432: x_prtnr_prfls_rec.partner_party_id := FND_API.G_MISS_NUM;
1433: x_prtnr_prfls_rec.status := FND_API.G_MISS_CHAR;
1434:

Line 1431: x_prtnr_prfls_rec.max_users := FND_API.G_MISS_NUM;

1427: x_prtnr_prfls_rec.sales_partner_flag := FND_API.G_MISS_CHAR;
1428: x_prtnr_prfls_rec.indirectly_managed_flag := FND_API.G_MISS_CHAR;
1429: x_prtnr_prfls_rec.channel_marketing_manager := FND_API.G_MISS_NUM;
1430: x_prtnr_prfls_rec.related_partner_id := FND_API.G_MISS_NUM;
1431: x_prtnr_prfls_rec.max_users := FND_API.G_MISS_NUM;
1432: x_prtnr_prfls_rec.partner_party_id := FND_API.G_MISS_NUM;
1433: x_prtnr_prfls_rec.status := FND_API.G_MISS_CHAR;
1434:
1435: END Init_Prtnr_Prfls_Rec;

Line 1432: x_prtnr_prfls_rec.partner_party_id := FND_API.G_MISS_NUM;

1428: x_prtnr_prfls_rec.indirectly_managed_flag := FND_API.G_MISS_CHAR;
1429: x_prtnr_prfls_rec.channel_marketing_manager := FND_API.G_MISS_NUM;
1430: x_prtnr_prfls_rec.related_partner_id := FND_API.G_MISS_NUM;
1431: x_prtnr_prfls_rec.max_users := FND_API.G_MISS_NUM;
1432: x_prtnr_prfls_rec.partner_party_id := FND_API.G_MISS_NUM;
1433: x_prtnr_prfls_rec.status := FND_API.G_MISS_CHAR;
1434:
1435: END Init_Prtnr_Prfls_Rec;
1436:

Line 1433: x_prtnr_prfls_rec.status := FND_API.G_MISS_CHAR;

1429: x_prtnr_prfls_rec.channel_marketing_manager := FND_API.G_MISS_NUM;
1430: x_prtnr_prfls_rec.related_partner_id := FND_API.G_MISS_NUM;
1431: x_prtnr_prfls_rec.max_users := FND_API.G_MISS_NUM;
1432: x_prtnr_prfls_rec.partner_party_id := FND_API.G_MISS_NUM;
1433: x_prtnr_prfls_rec.status := FND_API.G_MISS_CHAR;
1434:
1435: END Init_Prtnr_Prfls_Rec;
1436:
1437:

Line 1468: RAISE FND_API.g_exc_error;

1464: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1465: FND_MESSAGE.set_name('PV', 'PV_NO_RECORD_FOUND');
1466: FND_MSG_PUB.add;
1467: END IF;
1468: RAISE FND_API.g_exc_error;
1469: END IF;
1470: CLOSE c_prtnr_prfls;
1471:
1472: IF p_prtnr_prfls_rec.partner_id = FND_API.G_MISS_NUM THEN

Line 1472: IF p_prtnr_prfls_rec.partner_id = FND_API.G_MISS_NUM THEN

1468: RAISE FND_API.g_exc_error;
1469: END IF;
1470: CLOSE c_prtnr_prfls;
1471:
1472: IF p_prtnr_prfls_rec.partner_id = FND_API.G_MISS_NUM THEN
1473: x_complete_rec.partner_id := l_prtnr_prfls_rec.partner_id;
1474: END IF;
1475:
1476: IF p_prtnr_prfls_rec.target_revenue_amt = FND_API.G_MISS_NUM THEN

Line 1476: IF p_prtnr_prfls_rec.target_revenue_amt = FND_API.G_MISS_NUM THEN

1472: IF p_prtnr_prfls_rec.partner_id = FND_API.G_MISS_NUM THEN
1473: x_complete_rec.partner_id := l_prtnr_prfls_rec.partner_id;
1474: END IF;
1475:
1476: IF p_prtnr_prfls_rec.target_revenue_amt = FND_API.G_MISS_NUM THEN
1477: x_complete_rec.target_revenue_amt := l_prtnr_prfls_rec.target_revenue_amt;
1478: END IF;
1479:
1480: IF p_prtnr_prfls_rec.actual_revenue_amt = FND_API.G_MISS_NUM THEN

Line 1480: IF p_prtnr_prfls_rec.actual_revenue_amt = FND_API.G_MISS_NUM THEN

1476: IF p_prtnr_prfls_rec.target_revenue_amt = FND_API.G_MISS_NUM THEN
1477: x_complete_rec.target_revenue_amt := l_prtnr_prfls_rec.target_revenue_amt;
1478: END IF;
1479:
1480: IF p_prtnr_prfls_rec.actual_revenue_amt = FND_API.G_MISS_NUM THEN
1481: x_complete_rec.actual_revenue_amt := l_prtnr_prfls_rec.actual_revenue_amt;
1482: END IF;
1483:
1484: IF p_prtnr_prfls_rec.target_revenue_pct = FND_API.G_MISS_NUM THEN

Line 1484: IF p_prtnr_prfls_rec.target_revenue_pct = FND_API.G_MISS_NUM THEN

1480: IF p_prtnr_prfls_rec.actual_revenue_amt = FND_API.G_MISS_NUM THEN
1481: x_complete_rec.actual_revenue_amt := l_prtnr_prfls_rec.actual_revenue_amt;
1482: END IF;
1483:
1484: IF p_prtnr_prfls_rec.target_revenue_pct = FND_API.G_MISS_NUM THEN
1485: x_complete_rec.target_revenue_pct := l_prtnr_prfls_rec.target_revenue_pct;
1486: END IF;
1487:
1488: IF p_prtnr_prfls_rec.actual_revenue_pct = FND_API.G_MISS_NUM THEN

Line 1488: IF p_prtnr_prfls_rec.actual_revenue_pct = FND_API.G_MISS_NUM THEN

1484: IF p_prtnr_prfls_rec.target_revenue_pct = FND_API.G_MISS_NUM THEN
1485: x_complete_rec.target_revenue_pct := l_prtnr_prfls_rec.target_revenue_pct;
1486: END IF;
1487:
1488: IF p_prtnr_prfls_rec.actual_revenue_pct = FND_API.G_MISS_NUM THEN
1489: x_complete_rec.actual_revenue_pct := l_prtnr_prfls_rec.actual_revenue_pct;
1490: END IF;
1491:
1492: IF p_prtnr_prfls_rec.orig_system_reference = FND_API.G_MISS_CHAR THEN

Line 1492: IF p_prtnr_prfls_rec.orig_system_reference = FND_API.G_MISS_CHAR THEN

1488: IF p_prtnr_prfls_rec.actual_revenue_pct = FND_API.G_MISS_NUM THEN
1489: x_complete_rec.actual_revenue_pct := l_prtnr_prfls_rec.actual_revenue_pct;
1490: END IF;
1491:
1492: IF p_prtnr_prfls_rec.orig_system_reference = FND_API.G_MISS_CHAR THEN
1493: x_complete_rec.orig_system_reference := l_prtnr_prfls_rec.orig_system_reference;
1494: END IF;
1495:
1496: IF p_prtnr_prfls_rec.orig_system_type = FND_API.G_MISS_CHAR THEN

Line 1496: IF p_prtnr_prfls_rec.orig_system_type = FND_API.G_MISS_CHAR THEN

1492: IF p_prtnr_prfls_rec.orig_system_reference = FND_API.G_MISS_CHAR THEN
1493: x_complete_rec.orig_system_reference := l_prtnr_prfls_rec.orig_system_reference;
1494: END IF;
1495:
1496: IF p_prtnr_prfls_rec.orig_system_type = FND_API.G_MISS_CHAR THEN
1497: x_complete_rec.orig_system_type := l_prtnr_prfls_rec.orig_system_type;
1498: END IF;
1499:
1500: IF p_prtnr_prfls_rec.capacity_size = FND_API.G_MISS_CHAR THEN

Line 1500: IF p_prtnr_prfls_rec.capacity_size = FND_API.G_MISS_CHAR THEN

1496: IF p_prtnr_prfls_rec.orig_system_type = FND_API.G_MISS_CHAR THEN
1497: x_complete_rec.orig_system_type := l_prtnr_prfls_rec.orig_system_type;
1498: END IF;
1499:
1500: IF p_prtnr_prfls_rec.capacity_size = FND_API.G_MISS_CHAR THEN
1501: x_complete_rec.capacity_size := l_prtnr_prfls_rec.capacity_size;
1502: END IF;
1503:
1504: IF p_prtnr_prfls_rec.capacity_amount = FND_API.G_MISS_CHAR THEN

Line 1504: IF p_prtnr_prfls_rec.capacity_amount = FND_API.G_MISS_CHAR THEN

1500: IF p_prtnr_prfls_rec.capacity_size = FND_API.G_MISS_CHAR THEN
1501: x_complete_rec.capacity_size := l_prtnr_prfls_rec.capacity_size;
1502: END IF;
1503:
1504: IF p_prtnr_prfls_rec.capacity_amount = FND_API.G_MISS_CHAR THEN
1505: x_complete_rec.capacity_amount := l_prtnr_prfls_rec.capacity_amount;
1506: END IF;
1507:
1508: IF p_prtnr_prfls_rec.auto_match_allowed_flag = FND_API.G_MISS_CHAR THEN

Line 1508: IF p_prtnr_prfls_rec.auto_match_allowed_flag = FND_API.G_MISS_CHAR THEN

1504: IF p_prtnr_prfls_rec.capacity_amount = FND_API.G_MISS_CHAR THEN
1505: x_complete_rec.capacity_amount := l_prtnr_prfls_rec.capacity_amount;
1506: END IF;
1507:
1508: IF p_prtnr_prfls_rec.auto_match_allowed_flag = FND_API.G_MISS_CHAR THEN
1509: x_complete_rec.auto_match_allowed_flag := l_prtnr_prfls_rec.auto_match_allowed_flag;
1510: END IF;
1511:
1512: IF p_prtnr_prfls_rec.purchase_method = FND_API.G_MISS_CHAR THEN

Line 1512: IF p_prtnr_prfls_rec.purchase_method = FND_API.G_MISS_CHAR THEN

1508: IF p_prtnr_prfls_rec.auto_match_allowed_flag = FND_API.G_MISS_CHAR THEN
1509: x_complete_rec.auto_match_allowed_flag := l_prtnr_prfls_rec.auto_match_allowed_flag;
1510: END IF;
1511:
1512: IF p_prtnr_prfls_rec.purchase_method = FND_API.G_MISS_CHAR THEN
1513: x_complete_rec.purchase_method := l_prtnr_prfls_rec.purchase_method;
1514: END IF;
1515:
1516: IF p_prtnr_prfls_rec.cm_id = FND_API.G_MISS_NUM THEN

Line 1516: IF p_prtnr_prfls_rec.cm_id = FND_API.G_MISS_NUM THEN

1512: IF p_prtnr_prfls_rec.purchase_method = FND_API.G_MISS_CHAR THEN
1513: x_complete_rec.purchase_method := l_prtnr_prfls_rec.purchase_method;
1514: END IF;
1515:
1516: IF p_prtnr_prfls_rec.cm_id = FND_API.G_MISS_NUM THEN
1517: x_complete_rec.cm_id := l_prtnr_prfls_rec.cm_id;
1518: END IF;
1519:
1520: IF p_prtnr_prfls_rec.ph_support_rep = FND_API.G_MISS_NUM THEN

Line 1520: IF p_prtnr_prfls_rec.ph_support_rep = FND_API.G_MISS_NUM THEN

1516: IF p_prtnr_prfls_rec.cm_id = FND_API.G_MISS_NUM THEN
1517: x_complete_rec.cm_id := l_prtnr_prfls_rec.cm_id;
1518: END IF;
1519:
1520: IF p_prtnr_prfls_rec.ph_support_rep = FND_API.G_MISS_NUM THEN
1521: x_complete_rec.ph_support_rep := l_prtnr_prfls_rec.ph_support_rep;
1522: END IF;
1523: /*
1524: IF p_prtnr_prfls_rec.security_group_id = FND_API.G_MISS_NUM THEN

Line 1524: IF p_prtnr_prfls_rec.security_group_id = FND_API.G_MISS_NUM THEN

1520: IF p_prtnr_prfls_rec.ph_support_rep = FND_API.G_MISS_NUM THEN
1521: x_complete_rec.ph_support_rep := l_prtnr_prfls_rec.ph_support_rep;
1522: END IF;
1523: /*
1524: IF p_prtnr_prfls_rec.security_group_id = FND_API.G_MISS_NUM THEN
1525: x_complete_rec.security_group_id := l_prtnr_prfls_rec.security_group_id;
1526: END IF;
1527: */
1528: IF p_prtnr_prfls_rec.object_version_number = FND_API.G_MISS_NUM THEN

Line 1528: IF p_prtnr_prfls_rec.object_version_number = FND_API.G_MISS_NUM THEN

1524: IF p_prtnr_prfls_rec.security_group_id = FND_API.G_MISS_NUM THEN
1525: x_complete_rec.security_group_id := l_prtnr_prfls_rec.security_group_id;
1526: END IF;
1527: */
1528: IF p_prtnr_prfls_rec.object_version_number = FND_API.G_MISS_NUM THEN
1529: x_complete_rec.object_version_number := l_prtnr_prfls_rec.object_version_number;
1530: END IF;
1531:
1532: IF p_prtnr_prfls_rec.lead_sharing_status = FND_API.G_MISS_CHAR THEN

Line 1532: IF p_prtnr_prfls_rec.lead_sharing_status = FND_API.G_MISS_CHAR THEN

1528: IF p_prtnr_prfls_rec.object_version_number = FND_API.G_MISS_NUM THEN
1529: x_complete_rec.object_version_number := l_prtnr_prfls_rec.object_version_number;
1530: END IF;
1531:
1532: IF p_prtnr_prfls_rec.lead_sharing_status = FND_API.G_MISS_CHAR THEN
1533: x_complete_rec.lead_sharing_status := l_prtnr_prfls_rec.lead_sharing_status;
1534: END IF;
1535:
1536: IF p_prtnr_prfls_rec.lead_share_appr_flag = FND_API.G_MISS_CHAR THEN

Line 1536: IF p_prtnr_prfls_rec.lead_share_appr_flag = FND_API.G_MISS_CHAR THEN

1532: IF p_prtnr_prfls_rec.lead_sharing_status = FND_API.G_MISS_CHAR THEN
1533: x_complete_rec.lead_sharing_status := l_prtnr_prfls_rec.lead_sharing_status;
1534: END IF;
1535:
1536: IF p_prtnr_prfls_rec.lead_share_appr_flag = FND_API.G_MISS_CHAR THEN
1537: x_complete_rec.lead_share_appr_flag := l_prtnr_prfls_rec.lead_share_appr_flag;
1538: END IF;
1539:
1540: IF p_prtnr_prfls_rec.partner_relationship_id = FND_API.G_MISS_NUM THEN

Line 1540: IF p_prtnr_prfls_rec.partner_relationship_id = FND_API.G_MISS_NUM THEN

1536: IF p_prtnr_prfls_rec.lead_share_appr_flag = FND_API.G_MISS_CHAR THEN
1537: x_complete_rec.lead_share_appr_flag := l_prtnr_prfls_rec.lead_share_appr_flag;
1538: END IF;
1539:
1540: IF p_prtnr_prfls_rec.partner_relationship_id = FND_API.G_MISS_NUM THEN
1541: x_complete_rec.partner_relationship_id := l_prtnr_prfls_rec.partner_relationship_id;
1542: END IF;
1543:
1544: IF p_prtnr_prfls_rec.partner_level = FND_API.G_MISS_CHAR THEN

Line 1544: IF p_prtnr_prfls_rec.partner_level = FND_API.G_MISS_CHAR THEN

1540: IF p_prtnr_prfls_rec.partner_relationship_id = FND_API.G_MISS_NUM THEN
1541: x_complete_rec.partner_relationship_id := l_prtnr_prfls_rec.partner_relationship_id;
1542: END IF;
1543:
1544: IF p_prtnr_prfls_rec.partner_level = FND_API.G_MISS_CHAR THEN
1545: x_complete_rec.partner_level := l_prtnr_prfls_rec.partner_level;
1546: END IF;
1547:
1548: IF p_prtnr_prfls_rec.preferred_vad_id = FND_API.G_MISS_NUM THEN

Line 1548: IF p_prtnr_prfls_rec.preferred_vad_id = FND_API.G_MISS_NUM THEN

1544: IF p_prtnr_prfls_rec.partner_level = FND_API.G_MISS_CHAR THEN
1545: x_complete_rec.partner_level := l_prtnr_prfls_rec.partner_level;
1546: END IF;
1547:
1548: IF p_prtnr_prfls_rec.preferred_vad_id = FND_API.G_MISS_NUM THEN
1549: x_complete_rec.preferred_vad_id := l_prtnr_prfls_rec.preferred_vad_id;
1550: END IF;
1551:
1552: IF p_prtnr_prfls_rec.partner_group_id = FND_API.G_MISS_NUM THEN

Line 1552: IF p_prtnr_prfls_rec.partner_group_id = FND_API.G_MISS_NUM THEN

1548: IF p_prtnr_prfls_rec.preferred_vad_id = FND_API.G_MISS_NUM THEN
1549: x_complete_rec.preferred_vad_id := l_prtnr_prfls_rec.preferred_vad_id;
1550: END IF;
1551:
1552: IF p_prtnr_prfls_rec.partner_group_id = FND_API.G_MISS_NUM THEN
1553: x_complete_rec.partner_group_id := l_prtnr_prfls_rec.partner_group_id;
1554: END IF;
1555:
1556: IF p_prtnr_prfls_rec.partner_resource_id = FND_API.G_MISS_NUM THEN

Line 1556: IF p_prtnr_prfls_rec.partner_resource_id = FND_API.G_MISS_NUM THEN

1552: IF p_prtnr_prfls_rec.partner_group_id = FND_API.G_MISS_NUM THEN
1553: x_complete_rec.partner_group_id := l_prtnr_prfls_rec.partner_group_id;
1554: END IF;
1555:
1556: IF p_prtnr_prfls_rec.partner_resource_id = FND_API.G_MISS_NUM THEN
1557: x_complete_rec.partner_resource_id := l_prtnr_prfls_rec.partner_resource_id;
1558: END IF;
1559:
1560: IF p_prtnr_prfls_rec.partner_group_number = FND_API.G_MISS_CHAR THEN

Line 1560: IF p_prtnr_prfls_rec.partner_group_number = FND_API.G_MISS_CHAR THEN

1556: IF p_prtnr_prfls_rec.partner_resource_id = FND_API.G_MISS_NUM THEN
1557: x_complete_rec.partner_resource_id := l_prtnr_prfls_rec.partner_resource_id;
1558: END IF;
1559:
1560: IF p_prtnr_prfls_rec.partner_group_number = FND_API.G_MISS_CHAR THEN
1561: x_complete_rec.partner_group_number := l_prtnr_prfls_rec.partner_group_number;
1562: END IF;
1563:
1564: IF p_prtnr_prfls_rec.partner_resource_number = FND_API.G_MISS_CHAR THEN

Line 1564: IF p_prtnr_prfls_rec.partner_resource_number = FND_API.G_MISS_CHAR THEN

1560: IF p_prtnr_prfls_rec.partner_group_number = FND_API.G_MISS_CHAR THEN
1561: x_complete_rec.partner_group_number := l_prtnr_prfls_rec.partner_group_number;
1562: END IF;
1563:
1564: IF p_prtnr_prfls_rec.partner_resource_number = FND_API.G_MISS_CHAR THEN
1565: x_complete_rec.partner_resource_number := l_prtnr_prfls_rec.partner_resource_number;
1566: END IF;
1567:
1568: IF p_prtnr_prfls_rec.sales_partner_flag = FND_API.G_MISS_CHAR THEN

Line 1568: IF p_prtnr_prfls_rec.sales_partner_flag = FND_API.G_MISS_CHAR THEN

1564: IF p_prtnr_prfls_rec.partner_resource_number = FND_API.G_MISS_CHAR THEN
1565: x_complete_rec.partner_resource_number := l_prtnr_prfls_rec.partner_resource_number;
1566: END IF;
1567:
1568: IF p_prtnr_prfls_rec.sales_partner_flag = FND_API.G_MISS_CHAR THEN
1569: x_complete_rec.sales_partner_flag := l_prtnr_prfls_rec.sales_partner_flag;
1570: END IF;
1571:
1572: IF p_prtnr_prfls_rec.indirectly_managed_flag = FND_API.G_MISS_CHAR THEN

Line 1572: IF p_prtnr_prfls_rec.indirectly_managed_flag = FND_API.G_MISS_CHAR THEN

1568: IF p_prtnr_prfls_rec.sales_partner_flag = FND_API.G_MISS_CHAR THEN
1569: x_complete_rec.sales_partner_flag := l_prtnr_prfls_rec.sales_partner_flag;
1570: END IF;
1571:
1572: IF p_prtnr_prfls_rec.indirectly_managed_flag = FND_API.G_MISS_CHAR THEN
1573: x_complete_rec.indirectly_managed_flag := l_prtnr_prfls_rec.indirectly_managed_flag;
1574: END IF;
1575:
1576: IF p_prtnr_prfls_rec.channel_marketing_manager = FND_API.G_MISS_NUM THEN

Line 1576: IF p_prtnr_prfls_rec.channel_marketing_manager = FND_API.G_MISS_NUM THEN

1572: IF p_prtnr_prfls_rec.indirectly_managed_flag = FND_API.G_MISS_CHAR THEN
1573: x_complete_rec.indirectly_managed_flag := l_prtnr_prfls_rec.indirectly_managed_flag;
1574: END IF;
1575:
1576: IF p_prtnr_prfls_rec.channel_marketing_manager = FND_API.G_MISS_NUM THEN
1577: x_complete_rec.channel_marketing_manager := l_prtnr_prfls_rec.channel_marketing_manager;
1578: END IF;
1579:
1580: IF p_prtnr_prfls_rec.related_partner_id = FND_API.G_MISS_NUM THEN

Line 1580: IF p_prtnr_prfls_rec.related_partner_id = FND_API.G_MISS_NUM THEN

1576: IF p_prtnr_prfls_rec.channel_marketing_manager = FND_API.G_MISS_NUM THEN
1577: x_complete_rec.channel_marketing_manager := l_prtnr_prfls_rec.channel_marketing_manager;
1578: END IF;
1579:
1580: IF p_prtnr_prfls_rec.related_partner_id = FND_API.G_MISS_NUM THEN
1581: x_complete_rec.related_partner_id := l_prtnr_prfls_rec.related_partner_id;
1582: END IF;
1583:
1584: IF p_prtnr_prfls_rec.max_users = FND_API.G_MISS_NUM THEN

Line 1584: IF p_prtnr_prfls_rec.max_users = FND_API.G_MISS_NUM THEN

1580: IF p_prtnr_prfls_rec.related_partner_id = FND_API.G_MISS_NUM THEN
1581: x_complete_rec.related_partner_id := l_prtnr_prfls_rec.related_partner_id;
1582: END IF;
1583:
1584: IF p_prtnr_prfls_rec.max_users = FND_API.G_MISS_NUM THEN
1585: x_complete_rec.max_users := l_prtnr_prfls_rec.max_users;
1586: END IF;
1587:
1588: IF p_prtnr_prfls_rec.partner_party_id = FND_API.G_MISS_NUM THEN

Line 1588: IF p_prtnr_prfls_rec.partner_party_id = FND_API.G_MISS_NUM THEN

1584: IF p_prtnr_prfls_rec.max_users = FND_API.G_MISS_NUM THEN
1585: x_complete_rec.max_users := l_prtnr_prfls_rec.max_users;
1586: END IF;
1587:
1588: IF p_prtnr_prfls_rec.partner_party_id = FND_API.G_MISS_NUM THEN
1589: x_complete_rec.partner_party_id := l_prtnr_prfls_rec.partner_party_id;
1590: END IF;
1591:
1592: