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

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

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

Line 79: FND_MSG_PUB.initialize;

75: END IF;
76:
77:
78: IF FND_API.to_boolean(p_init_msg_list) THEN
79: FND_MSG_PUB.initialize;
80: END IF;
81:
82: IF NOT FND_API.compatible_api_call(
83: l_api_version,

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

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

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

118: END IF;
119:
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 235: FND_MSG_PUB.count_and_get(

231: IF FND_API.to_boolean(p_commit) THEN
232: COMMIT;
233: END IF;
234:
235: FND_MSG_PUB.count_and_get(
236: p_encoded => FND_API.g_false,
237: p_count => x_msg_count,
238: p_data => x_msg_data
239: );

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

237: p_count => x_msg_count,
238: p_data => x_msg_data
239: );
240:
241: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
242: PVX_Utility_PVT.debug_message(l_full_name ||': end');
243: END IF;
244:
245:

Line 251: FND_MSG_PUB.count_and_get (

247:
248: WHEN FND_API.g_exc_error THEN
249: ROLLBACK TO Create_lead_pss_line;
250: x_return_status := FND_API.g_ret_sts_error;
251: FND_MSG_PUB.count_and_get (
252: p_encoded => FND_API.g_false
253: ,p_count => x_msg_count
254: ,p_data => x_msg_data
255: );

Line 260: FND_MSG_PUB.count_and_get (

256:
257: WHEN FND_API.g_exc_unexpected_error THEN
258: ROLLBACK TO Create_lead_pss_line;
259: x_return_status := FND_API.g_ret_sts_unexp_error ;
260: FND_MSG_PUB.count_and_get (
261: p_encoded => FND_API.g_false
262: ,p_count => x_msg_count
263: ,p_data => x_msg_data
264: );

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

267: WHEN OTHERS THEN
268: ROLLBACK TO Create_lead_pss_line;
269: x_return_status := FND_API.g_ret_sts_unexp_error ;
270:
271: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
272: THEN
273: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
274: END IF;
275:

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

269: x_return_status := FND_API.g_ret_sts_unexp_error ;
270:
271: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
272: THEN
273: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
274: END IF;
275:
276: FND_MSG_PUB.count_and_get(
277: p_encoded => FND_API.g_false

Line 276: FND_MSG_PUB.count_and_get(

272: THEN
273: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
274: END IF;
275:
276: FND_MSG_PUB.count_and_get(
277: p_encoded => FND_API.g_false
278: ,p_count => x_msg_count
279: ,p_data => x_msg_data
280: );

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

310:
311: --------------------- initialize -----------------------
312: SAVEPOINT Delete_lead_pss_line;
313:
314: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
315: PVX_Utility_PVT.debug_message(l_full_name||': start');
316: END IF;
317:
318:

Line 321: FND_MSG_PUB.initialize;

317:
318:
319:
320: IF FND_API.to_boolean(p_init_msg_list) THEN
321: FND_MSG_PUB.initialize;
322: END IF;
323:
324: IF NOT FND_API.compatible_api_call(
325: l_api_version,

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

332:
333: x_return_status := FND_API.G_RET_STS_SUCCESS;
334:
335: ------------------------ delete ------------------------
336: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
337: PVX_Utility_PVT.debug_message(l_full_name ||': delete');
338: END IF;
339:
340:

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

342: WHERE lead_pss_line_id = p_lead_pss_line_id
343: AND object_version_number = p_object_version;
344:
345: IF (SQL%NOTFOUND) THEN
346: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
347: THEN
348: FND_MESSAGE.set_name('PV', 'PV_RECORD_NOT_FOUND');
349: FND_MSG_PUB.add;
350: END IF;

Line 349: FND_MSG_PUB.add;

345: IF (SQL%NOTFOUND) THEN
346: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
347: THEN
348: FND_MESSAGE.set_name('PV', 'PV_RECORD_NOT_FOUND');
349: FND_MSG_PUB.add;
350: END IF;
351: RAISE FND_API.g_exc_error;
352: END IF;
353:

Line 359: FND_MSG_PUB.count_and_get(

355: IF FND_API.to_boolean(p_commit) THEN
356: COMMIT;
357: END IF;
358:
359: FND_MSG_PUB.count_and_get(
360: p_encoded => FND_API.g_false,
361: p_count => x_msg_count,
362: p_data => x_msg_data
363: );

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

361: p_count => x_msg_count,
362: p_data => x_msg_data
363: );
364:
365: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
366: PVX_Utility_PVT.debug_message(l_full_name ||': end');
367: END IF;
368:
369:

Line 376: FND_MSG_PUB.count_and_get(

372:
373: WHEN FND_API.g_exc_error THEN
374: ROLLBACK TO Delete_lead_pss_line;
375: x_return_status := FND_API.g_ret_sts_error;
376: FND_MSG_PUB.count_and_get(
377: p_encoded => FND_API.g_false,
378: p_count => x_msg_count,
379: p_data => x_msg_data
380: );

Line 385: FND_MSG_PUB.count_and_get(

381:
382: WHEN FND_API.g_exc_unexpected_error THEN
383: ROLLBACK TO Delete_lead_pss_line;
384: x_return_status := FND_API.g_ret_sts_unexp_error ;
385: FND_MSG_PUB.count_and_get(
386: p_encoded => FND_API.g_false,
387: p_count => x_msg_count,
388: p_data => x_msg_data
389: );

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

391: WHEN OTHERS THEN
392: ROLLBACK TO Delete_lead_pss_line;
393: x_return_status := FND_API.g_ret_sts_unexp_error ;
394:
395: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
396: THEN
397: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
398: END IF;
399:

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

393: x_return_status := FND_API.g_ret_sts_unexp_error ;
394:
395: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
396: THEN
397: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
398: END IF;
399:
400: FND_MSG_PUB.count_and_get(
401: p_encoded => FND_API.g_false,

Line 400: FND_MSG_PUB.count_and_get(

396: THEN
397: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
398: END IF;
399:
400: FND_MSG_PUB.count_and_get(
401: p_encoded => FND_API.g_false,
402: p_count => x_msg_count,
403: p_data => x_msg_data
404: );

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

439:
440: BEGIN
441:
442: -------------------- initialize ------------------------
443: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
444: PVX_Utility_PVT.debug_message(l_full_name||': start');
445: END IF;
446:
447:

Line 449: FND_MSG_PUB.initialize;

445: END IF;
446:
447:
448: IF FND_API.to_boolean(p_init_msg_list) THEN
449: FND_MSG_PUB.initialize;
450: END IF;
451:
452: IF NOT FND_API.compatible_api_call(
453: l_api_version,

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

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

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

469: OPEN c_lead_pss_line;
470: FETCH c_lead_pss_line INTO l_lead_pss_line_id;
471: IF (c_lead_pss_line%NOTFOUND) THEN
472: CLOSE c_lead_pss_line;
473: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
474: FND_MESSAGE.set_name('PV', 'PV_RECORD_NOT_FOUND');
475: FND_MSG_PUB.add;
476: END IF;
477: RAISE FND_API.g_exc_error;

Line 475: FND_MSG_PUB.add;

471: IF (c_lead_pss_line%NOTFOUND) THEN
472: CLOSE c_lead_pss_line;
473: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
474: FND_MESSAGE.set_name('PV', 'PV_RECORD_NOT_FOUND');
475: FND_MSG_PUB.add;
476: END IF;
477: RAISE FND_API.g_exc_error;
478: END IF;
479: CLOSE c_lead_pss_line;

Line 483: FND_MSG_PUB.count_and_get(

479: CLOSE c_lead_pss_line;
480:
481:
482: -------------------- finish --------------------------
483: FND_MSG_PUB.count_and_get(
484: p_encoded => FND_API.g_false,
485: p_count => x_msg_count,
486: p_data => x_msg_data
487: );

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

486: p_data => x_msg_data
487: );
488:
489:
490: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
491: PVX_Utility_PVT.debug_message(l_full_name ||': end');
492: END IF;
493:
494:

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

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

Line 502: FND_MSG_PUB.add;

498: WHEN PVX_Utility_PVT.resource_locked THEN
499: x_return_status := FND_API.g_ret_sts_error;
500: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
501: FND_MESSAGE.set_name('PV', 'PV_RESOURCE_LOCKED');
502: FND_MSG_PUB.add;
503: END IF;
504:
505: FND_MSG_PUB.count_and_get(
506: p_encoded => FND_API.g_false,

Line 505: FND_MSG_PUB.count_and_get(

501: FND_MESSAGE.set_name('PV', 'PV_RESOURCE_LOCKED');
502: FND_MSG_PUB.add;
503: END IF;
504:
505: FND_MSG_PUB.count_and_get(
506: p_encoded => FND_API.g_false,
507: p_count => x_msg_count,
508: p_data => x_msg_data
509: );

Line 513: FND_MSG_PUB.count_and_get(

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

Line 521: FND_MSG_PUB.count_and_get(

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

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

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

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

527: WHEN OTHERS THEN
528: x_return_status := FND_API.g_ret_sts_unexp_error ;
529: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
530: THEN
531: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
532: END IF;
533:
534: FND_MSG_PUB.count_and_get(
535: p_encoded => FND_API.g_false,

Line 534: FND_MSG_PUB.count_and_get(

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

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

571:
572: -------------------- initialize -------------------------
573: SAVEPOINT Update_lead_pss_line;
574:
575: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
576: PVX_Utility_PVT.debug_message(l_full_name||': start');
577: END IF;
578:
579:

Line 581: FND_MSG_PUB.initialize;

577: END IF;
578:
579:
580: IF FND_API.to_boolean(p_init_msg_list) THEN
581: FND_MSG_PUB.initialize;
582: END IF;
583:
584: IF NOT FND_API.compatible_api_call(
585: l_api_version,

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

592:
593: x_return_status := FND_API.G_RET_STS_SUCCESS;
594:
595: ----------------------- validate ----------------------
596: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
597: PVX_Utility_PVT.debug_message(l_full_name ||': validate');
598: END IF;
599:
600:

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

636: END IF;
637: END IF;
638:
639: -------------------------- update --------------------
640: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
641: PVX_Utility_PVT.debug_message(l_full_name ||': update');
642: END IF;
643:
644:

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

680: AND object_version_number = l_lead_pss_lines_rec.object_version_number;
681:
682:
683: IF (SQL%NOTFOUND) THEN
684: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
685: FND_MESSAGE.set_name('PV', 'PV_NO_RECORD_FOUND');
686: FND_MSG_PUB.add;
687: END IF;
688: RAISE FND_API.g_exc_error;

Line 686: FND_MSG_PUB.add;

682:
683: IF (SQL%NOTFOUND) THEN
684: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
685: FND_MESSAGE.set_name('PV', 'PV_NO_RECORD_FOUND');
686: FND_MSG_PUB.add;
687: END IF;
688: RAISE FND_API.g_exc_error;
689: END IF;
690:

Line 704: FND_MSG_PUB.count_and_get(

700: END IF;
701:
702:
703:
704: FND_MSG_PUB.count_and_get(
705: p_encoded => FND_API.g_false,
706: p_count => x_msg_count,
707: p_data => x_msg_data
708: );

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

706: p_count => x_msg_count,
707: p_data => x_msg_data
708: );
709:
710: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
711: PVX_Utility_PVT.debug_message(l_full_name ||': end');
712: END IF;
713:
714:

Line 722: FND_MSG_PUB.count_and_get(

718:
719: WHEN FND_API.g_exc_error THEN
720: ROLLBACK TO Update_lead_pss_line;
721: x_return_status := FND_API.g_ret_sts_error;
722: FND_MSG_PUB.count_and_get(
723: p_encoded => FND_API.g_false,
724: p_count => x_msg_count,
725: p_data => x_msg_data
726: );

Line 731: FND_MSG_PUB.count_and_get(

727:
728: WHEN FND_API.g_exc_unexpected_error THEN
729: ROLLBACK TO Update_lead_pss_line;
730: x_return_status := FND_API.g_ret_sts_unexp_error ;
731: FND_MSG_PUB.count_and_get(
732: p_encoded => FND_API.g_false,
733: p_count => x_msg_count,
734: p_data => x_msg_data
735: );

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

737: WHEN OTHERS THEN
738: ROLLBACK TO Update_lead_pss_line;
739: x_return_status := FND_API.g_ret_sts_unexp_error ;
740:
741: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
742: THEN
743: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
744: END IF;
745:

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

739: x_return_status := FND_API.g_ret_sts_unexp_error ;
740:
741: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
742: THEN
743: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
744: END IF;
745:
746: FND_MSG_PUB.count_and_get(
747: p_encoded => FND_API.g_false,

Line 746: FND_MSG_PUB.count_and_get(

742: THEN
743: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
744: END IF;
745:
746: FND_MSG_PUB.count_and_get(
747: p_encoded => FND_API.g_false,
748: p_count => x_msg_count,
749: p_data => x_msg_data
750: );

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

779:
780:
781:
782: ----------------------- initialize --------------------
783: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
784: PVX_Utility_PVT.debug_message(l_full_name||': start');
785: END IF;
786:
787:

Line 789: FND_MSG_PUB.initialize;

785: END IF;
786:
787:
788: IF FND_API.to_boolean(p_init_msg_list) THEN
789: FND_MSG_PUB.initialize;
790: END IF;
791:
792: IF NOT FND_API.compatible_api_call(
793: l_api_version,

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

800:
801: x_return_status := FND_API.g_ret_sts_success;
802:
803: ---------------------- validate ------------------------
804: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
805: PVX_Utility_PVT.debug_message(l_full_name||': check items');
806: END IF;
807:
808:

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

824: END IF;
825:
826:
827:
828: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
829: PVX_Utility_PVT.debug_message(l_full_name||': check record');
830: END IF;
831:
832:

Line 856: FND_MSG_PUB.count_and_get(

852:
853:
854:
855: -------------------- finish --------------------------
856: FND_MSG_PUB.count_and_get(
857: p_encoded => FND_API.g_false,
858: p_count => x_msg_count,
859: p_data => x_msg_data
860: );

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

858: p_count => x_msg_count,
859: p_data => x_msg_data
860: );
861:
862: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
863: PVX_Utility_PVT.debug_message(l_full_name ||': end');
864: END IF;
865:
866:

Line 874: FND_MSG_PUB.count_and_get(

870: EXCEPTION
871:
872: WHEN FND_API.g_exc_error THEN
873: x_return_status := FND_API.g_ret_sts_error;
874: FND_MSG_PUB.count_and_get(
875: p_encoded => FND_API.g_false,
876: p_count => x_msg_count,
877: p_data => x_msg_data
878: );

Line 882: FND_MSG_PUB.count_and_get(

878: );
879:
880: WHEN FND_API.g_exc_unexpected_error THEN
881: x_return_status := FND_API.g_ret_sts_unexp_error ;
882: FND_MSG_PUB.count_and_get(
883: p_encoded => FND_API.g_false,
884: p_count => x_msg_count,
885: p_data => x_msg_data
886: );

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

886: );
887:
888: WHEN OTHERS THEN
889: x_return_status := FND_API.g_ret_sts_unexp_error;
890: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
891: THEN
892: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
893: END IF;
894:

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

888: WHEN OTHERS THEN
889: x_return_status := FND_API.g_ret_sts_unexp_error;
890: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
891: THEN
892: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
893: END IF;
894:
895: FND_MSG_PUB.count_and_get(
896: p_encoded => FND_API.g_false,

Line 895: FND_MSG_PUB.count_and_get(

891: THEN
892: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
893: END IF;
894:
895: FND_MSG_PUB.count_and_get(
896: p_encoded => FND_API.g_false,
897: p_count => x_msg_count,
898: p_data => x_msg_data
899: );

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

917:
918:
919: ------------------------ entity --------------------------
920: IF p_lead_pss_lines_rec.object_id IS NULL THEN
921: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
922: FND_MESSAGE.set_name('PV', 'PV_NO_OBJECT_ID');
923: FND_MSG_PUB.add;
924: END IF;
925:

Line 923: FND_MSG_PUB.add;

919: ------------------------ entity --------------------------
920: IF p_lead_pss_lines_rec.object_id IS NULL THEN
921: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
922: FND_MESSAGE.set_name('PV', 'PV_NO_OBJECT_ID');
923: FND_MSG_PUB.add;
924: END IF;
925:
926: x_return_status := FND_API.g_ret_sts_error;
927: RETURN;

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

926: x_return_status := FND_API.g_ret_sts_error;
927: RETURN;
928: ------------------------ attribute id -------------------------------
929: ELSIF p_lead_pss_lines_rec.attr_code_id IS NULL THEN
930: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
931: FND_MESSAGE.set_name('PV', 'PV_NO_ATTR_CODE_ID');
932: FND_MSG_PUB.add;
933: END IF;
934:

Line 932: FND_MSG_PUB.add;

928: ------------------------ attribute id -------------------------------
929: ELSIF p_lead_pss_lines_rec.attr_code_id IS NULL THEN
930: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
931: FND_MESSAGE.set_name('PV', 'PV_NO_ATTR_CODE_ID');
932: FND_MSG_PUB.add;
933: END IF;
934:
935: x_return_status := FND_API.g_ret_sts_error;
936: RETURN;

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

935: x_return_status := FND_API.g_ret_sts_error;
936: RETURN;
937: ------------------------ Object_name -------------------------------
938: ELSIF p_lead_pss_lines_rec.object_name IS NULL THEN
939: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
940: FND_MESSAGE.set_name('PV', 'PV_NO_OBJECT_NAME');
941: FND_MSG_PUB.add;
942: END IF;
943:

Line 941: FND_MSG_PUB.add;

937: ------------------------ Object_name -------------------------------
938: ELSIF p_lead_pss_lines_rec.object_name IS NULL THEN
939: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
940: FND_MESSAGE.set_name('PV', 'PV_NO_OBJECT_NAME');
941: FND_MSG_PUB.add;
942: END IF;
943:
944: x_return_status := FND_API.g_ret_sts_error;
945: RETURN;

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

973: 'PV_lead_pss_lines',
974: 'lead_pss_line_id = ' || p_lead_pss_lines_rec.lead_pss_line_id
975: ) = FND_API.g_false
976: THEN
977: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
978: THEN
979: FND_MESSAGE.set_name('PV', 'PV_DUPLICATE_ID');
980: FND_MSG_PUB.add;
981: END IF;

Line 980: FND_MSG_PUB.add;

976: THEN
977: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
978: THEN
979: FND_MESSAGE.set_name('PV', 'PV_DUPLICATE_ID');
980: FND_MSG_PUB.add;
981: END IF;
982: x_return_status := FND_API.g_ret_sts_error;
983: RETURN;
984: END IF;

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

1012: p_lead_pss_lines_rec.object_id, -- Value of fk to be validated against the parent object's pk column
1013: PVX_utility_PVT.g_number -- datatype of fk
1014: ) = FND_API.g_false
1015: THEN
1016: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1017: THEN
1018: FND_MESSAGE.set_name('PV', 'PV_NOT_A_VALID_LEAD_ID');
1019: FND_MSG_PUB.add;
1020: END IF;

Line 1019: FND_MSG_PUB.add;

1015: THEN
1016: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1017: THEN
1018: FND_MESSAGE.set_name('PV', 'PV_NOT_A_VALID_LEAD_ID');
1019: FND_MSG_PUB.add;
1020: END IF;
1021:
1022: x_return_status := FND_API.g_ret_sts_error;
1023: RETURN;

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

1031: p_lead_pss_lines_rec.object_id, -- Value of fk to be validated against the parent object's pk column
1032: PVX_utility_PVT.g_number -- datatype of fk
1033: ) = FND_API.g_false
1034: THEN
1035: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1036: THEN
1037: FND_MESSAGE.set_name('PV', 'PV_NOT_A_VALID_SALES_LEAD_ID');
1038: FND_MSG_PUB.add;
1039: END IF;

Line 1038: FND_MSG_PUB.add;

1034: THEN
1035: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1036: THEN
1037: FND_MESSAGE.set_name('PV', 'PV_NOT_A_VALID_SALES_LEAD_ID');
1038: FND_MSG_PUB.add;
1039: END IF;
1040: x_return_status := FND_API.g_ret_sts_error;
1041: RETURN;
1042:

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

1052: p_lead_pss_lines_rec.attr_code_id, -- Value of fk to be validated against the parent object's pk column
1053: PVX_utility_PVT.g_number -- datatype of fk
1054: ) = FND_API.g_false
1055: THEN
1056: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1057: THEN
1058: FND_MESSAGE.set_name('PV', 'PV_NOT_A_VALID_ATTRIBUTE_CODE_ID');
1059: FND_MSG_PUB.add;
1060: END IF;

Line 1059: FND_MSG_PUB.add;

1055: THEN
1056: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1057: THEN
1058: FND_MESSAGE.set_name('PV', 'PV_NOT_A_VALID_ATTRIBUTE_CODE_ID');
1059: FND_MSG_PUB.add;
1060: END IF;
1061: x_return_status := FND_API.g_ret_sts_error;
1062: RETURN;
1063:

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

1092: 'PV_OBJECT_NAME', -- Lookup Type
1093: p_lead_pss_lines_rec.object_name -- Lookup Code
1094: ) = FND_API.g_false
1095: THEN
1096: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1097: THEN
1098: FND_MESSAGE.set_name('PV', 'PV_NOT_A_VALID_OBJECT_NAME_CODE');
1099: FND_MSG_PUB.add;
1100: END IF;

Line 1099: FND_MSG_PUB.add;

1095: THEN
1096: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1097: THEN
1098: FND_MESSAGE.set_name('PV', 'PV_NOT_A_VALID_OBJECT_NAME_CODE');
1099: FND_MSG_PUB.add;
1100: END IF;
1101: x_return_status := FND_API.g_ret_sts_error;
1102: RETURN;
1103:

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

1310: OPEN c_lead_pss_line;
1311: FETCH c_lead_pss_line INTO l_lead_pss_lines_rec;
1312: IF c_lead_pss_line%NOTFOUND THEN
1313: CLOSE c_lead_pss_line;
1314: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1315: FND_MESSAGE.set_name('PV', 'PV_NO_RECORD_FOUND');
1316: FND_MSG_PUB.add;
1317: END IF;
1318: RAISE FND_API.g_exc_error;

Line 1316: FND_MSG_PUB.add;

1312: IF c_lead_pss_line%NOTFOUND THEN
1313: CLOSE c_lead_pss_line;
1314: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1315: FND_MESSAGE.set_name('PV', 'PV_NO_RECORD_FOUND');
1316: FND_MSG_PUB.add;
1317: END IF;
1318: RAISE FND_API.g_exc_error;
1319: END IF;
1320: CLOSE c_lead_pss_line;