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_PRTNR_PRFLS_PVT dependencies on FND_MSG_PUB

Line 74: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

70:
71: --------------------- initialize -----------------------
72: SAVEPOINT Create_Prtnr_Prfls;
73:
74: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
75: PVX_Utility_PVT.debug_message(l_full_name||': start');
76: END IF;
77:
78: --dbms_output.put_line(l_full_name||': start');

Line 81: FND_MSG_PUB.initialize;

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(
85: l_api_version,

Line 96: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

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');
98: END IF;
99:
100: --dbms_output.put_line(l_full_name||': validate');

Line 122: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

118:
119: --dbms_output.put_line(l_full_name||': back validate');
120:
121: -------------------------- insert --------------------------
122: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
123: PVX_Utility_PVT.debug_message(l_full_name ||': insert');
124: END IF;
125:
126:

Line 248: FND_MSG_PUB.count_and_get(

244: IF FND_API.to_boolean(p_commit) THEN
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: );

Line 254: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

250: p_count => x_msg_count,
251: p_data => x_msg_data
252: );
253:
254: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
255: PVX_Utility_PVT.debug_message(l_full_name ||': end');
256: END IF;
257:
258: EXCEPTION

Line 263: FND_MSG_PUB.count_and_get (

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
267: );

Line 272: FND_MSG_PUB.count_and_get (

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
276: );

Line 283: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

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);
286: END IF;
287:

Line 285: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

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);
286: END IF;
287:
288: FND_MSG_PUB.count_and_get(
289: p_encoded => FND_API.g_false

Line 288: FND_MSG_PUB.count_and_get(

284: THEN
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: );

Line 325: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

321:
322: --------------------- initialize -----------------------
323: SAVEPOINT Delete_Prtnr_Prfls;
324:
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

Line 330: FND_MSG_PUB.initialize;

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(
334: l_api_version,

Line 345: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

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');
347: END IF;
348:
349: DELETE FROM PV_PARTNER_PROFILES

Line 354: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

350: WHERE partner_profile_id = p_partner_profile_id
351: AND object_version_number = p_object_version;
352:
353: IF (SQL%NOTFOUND) THEN
354: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
355: THEN
356: FND_MESSAGE.set_name('PV', 'PV_NO_RECORD_FOUND');
357: FND_MSG_PUB.add;
358: END IF;

Line 357: FND_MSG_PUB.add;

353: IF (SQL%NOTFOUND) THEN
354: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_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:

Line 367: FND_MSG_PUB.count_and_get(

363: IF FND_API.to_boolean(p_commit) THEN
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: );

Line 373: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

369: p_count => x_msg_count,
370: p_data => x_msg_data
371: );
372:
373: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
374: PVX_Utility_PVT.debug_message(l_full_name ||': end');
375: END IF;
376:
377: EXCEPTION

Line 382: FND_MSG_PUB.count_and_get(

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
386: );

Line 391: FND_MSG_PUB.count_and_get(

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
395: );

Line 401: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

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);
404: END IF;
405:

Line 403: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

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);
404: END IF;
405:
406: FND_MSG_PUB.count_and_get(
407: p_encoded => FND_API.g_false,

Line 406: FND_MSG_PUB.count_and_get(

402: THEN
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: );

Line 449: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

445:
446: BEGIN
447:
448: -------------------- initialize ------------------------
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

Line 454: FND_MSG_PUB.initialize;

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(
458: l_api_version,

Line 469: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

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');
471: END IF;
472:
473: OPEN c_prtnr_prfls;

Line 477: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

473: OPEN c_prtnr_prfls;
474: FETCH c_prtnr_prfls INTO l_partner_profile_id;
475: IF (c_prtnr_prfls%NOTFOUND) THEN
476: CLOSE c_prtnr_prfls;
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;

Line 479: FND_MSG_PUB.add;

475: IF (c_prtnr_prfls%NOTFOUND) THEN
476: CLOSE c_prtnr_prfls;
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;

Line 487: FND_MSG_PUB.count_and_get(

483: CLOSE c_prtnr_prfls;
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: );

Line 493: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

489: p_count => x_msg_count,
490: p_data => x_msg_data
491: );
492:
493: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
494: PVX_Utility_PVT.debug_message(l_full_name ||': end');
495: END IF;
496:
497: EXCEPTION

Line 501: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

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;
505:

Line 503: FND_MSG_PUB.add;

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;
505:
506: FND_MSG_PUB.count_and_get(
507: p_encoded => FND_API.g_false,

Line 506: FND_MSG_PUB.count_and_get(

502: FND_MESSAGE.set_name('PV', 'PV_RESOURCE_LOCKED');
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: );

Line 514: FND_MSG_PUB.count_and_get(

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
518: );

Line 522: FND_MSG_PUB.count_and_get(

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
526: );

Line 530: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

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;
534:

Line 532: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

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;
534:
535: FND_MSG_PUB.count_and_get(
536: p_encoded => FND_API.g_false,

Line 535: FND_MSG_PUB.count_and_get(

531: THEN
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: );

Line 600: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

596: --dbms_output.put_line('entered Update');
597: -------------------- initialize -------------------------
598: SAVEPOINT Update_Prtnr_Prfls;
599:
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

Line 605: FND_MSG_PUB.initialize;

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(
609: l_api_version,

Line 622: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

618:
619: --dbms_output.put_line('Before Validate');
620:
621: ----------------------- validate ----------------------
622: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
623: PVX_Utility_PVT.debug_message(l_full_name ||': validate');
624: END IF;
625:
626: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

Line 665: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

661: END IF;
662:
663:
664: -------------------------- update --------------------
665: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
666: PVX_Utility_PVT.debug_message(l_full_name ||': update');
667: END IF;
668:
669: --dbms_output.put_line('partner_profile_id = '||TO_CHAR(l_prtnr_prfls_rec.partner_profile_id));

Line 762: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

758: WHERE partner_profile_id = l_prtnr_prfls_rec.partner_profile_id
759: AND object_version_number = l_prtnr_prfls_rec.object_version_number;
760:
761: IF (SQL%NOTFOUND) THEN
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;

Line 764: FND_MSG_PUB.add;

760:
761: IF (SQL%NOTFOUND) THEN
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:

Line 818: FND_MSG_PUB.add;

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;
820: */
821:
822: IF x_return_status = FND_API.g_ret_sts_error THEN

Line 840: FND_MSG_PUB.count_and_get(

836: IF FND_API.to_boolean(p_commit) THEN
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: );

Line 846: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

842: p_count => x_msg_count,
843: p_data => x_msg_data
844: );
845:
846: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
847: PVX_Utility_PVT.debug_message(l_full_name ||': end');
848: END IF;
849:
850: EXCEPTION

Line 855: FND_MSG_PUB.count_and_get(

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
859: );

Line 864: FND_MSG_PUB.count_and_get(

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
868: );

Line 874: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

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);
877: END IF;
878:

Line 876: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

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);
877: END IF;
878:
879: FND_MSG_PUB.count_and_get(
880: p_encoded => FND_API.g_false,

Line 879: FND_MSG_PUB.count_and_get(

875: THEN
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: );

Line 914: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

910:
911: BEGIN
912:
913: ----------------------- initialize --------------------
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

Line 919: FND_MSG_PUB.initialize;

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(
923: l_api_version,

Line 934: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

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');
936: END IF;
937: --dbms_output.put_line(l_full_name||': start item validate');
938:

Line 953: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) 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
954: PVX_Utility_PVT.debug_message(l_full_name||': check record');
955: END IF;
956:
957: --dbms_output.put_line(l_full_name||': start record validate');

Line 974: FND_MSG_PUB.count_and_get(

970: END IF;
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: );

Line 980: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

976: p_count => x_msg_count,
977: p_data => x_msg_data
978: );
979:
980: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
981: PVX_Utility_PVT.debug_message(l_full_name ||': end');
982: END IF;
983:
984: EXCEPTION

Line 988: FND_MSG_PUB.count_and_get(

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
992: );

Line 996: FND_MSG_PUB.count_and_get(

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
1000: );

Line 1004: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

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;
1008:

Line 1006: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

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;
1008:
1009: FND_MSG_PUB.count_and_get(
1010: p_encoded => FND_API.g_false,

Line 1009: FND_MSG_PUB.count_and_get(

1005: THEN
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: );

Line 1123: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

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)
1124: THEN
1125: FND_MESSAGE.set_name('PV', 'PV_NO_PARTNER_ID');
1126: FND_MESSAGE.set_token('ID',to_char(p_prtnr_prfls_rec.partner_id) );
1127: FND_MSG_PUB.add;

Line 1127: FND_MSG_PUB.add;

1123: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1124: THEN
1125: FND_MESSAGE.set_name('PV', 'PV_NO_PARTNER_ID');
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;

Line 1134: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

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)
1135: THEN
1136: FND_MESSAGE.set_name('PV', 'PV_NO_CM_ID');
1137: FND_MESSAGE.set_token('ID',to_char(p_prtnr_prfls_rec.cm_id) );
1138: FND_MSG_PUB.add;

Line 1138: FND_MSG_PUB.add;

1134: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1135: THEN
1136: FND_MESSAGE.set_name('PV', 'PV_NO_CM_ID');
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; */

Line 1174: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

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');
1177: FND_MESSAGE.set_token('ID',to_char(p_prtnr_prfls_rec.partner_profile_id) );
1178: FND_MSG_PUB.add;

Line 1178: FND_MSG_PUB.add;

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');
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;

Line 1214: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

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');
1217: FND_MESSAGE.set_token('ID',to_char(p_prtnr_prfls_rec.partner_id) );
1218: FND_MSG_PUB.add;

Line 1218: FND_MSG_PUB.add;

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');
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;

Line 1270: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

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');
1273: FND_MSG_PUB.add;
1274: END IF;

Line 1273: FND_MSG_PUB.add;

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');
1273: FND_MSG_PUB.add;
1274: END IF;
1275:
1276: x_return_status := FND_API.g_ret_sts_error;
1277: RETURN;

Line 1376: FND_MSG_PUB.ADD;

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;
1378: RETURN;
1379: END IF;
1380: END IF;

Line 1464: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1460: OPEN c_prtnr_prfls;
1461: FETCH c_prtnr_prfls INTO l_prtnr_prfls_rec;
1462: IF c_prtnr_prfls%NOTFOUND THEN
1463: CLOSE c_prtnr_prfls;
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;

Line 1466: FND_MSG_PUB.add;

1462: IF c_prtnr_prfls%NOTFOUND THEN
1463: CLOSE c_prtnr_prfls;
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;