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.PV_CONTACT_USER_BATCH_PUB dependencies on FND_MESSAGE

Line 126: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_index));

122:
123:
124: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
125: /*FOR l_msg_index IN 1..l_msg_count LOOP
126: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_index));
127: -- dbms_output.put_line(fnd_message.get);
128: l_log_count:= l_log_count + 1;
129: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
130: END LOOP;

Line 127: -- dbms_output.put_line(fnd_message.get);

123:
124: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
125: /*FOR l_msg_index IN 1..l_msg_count LOOP
126: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_index));
127: -- dbms_output.put_line(fnd_message.get);
128: l_log_count:= l_log_count + 1;
129: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
130: END LOOP;
131: */

Line 129: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);

125: /*FOR l_msg_index IN 1..l_msg_count LOOP
126: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_index));
127: -- dbms_output.put_line(fnd_message.get);
128: l_log_count:= l_log_count + 1;
129: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
130: END LOOP;
131: */
132:
133: l_log_count:= l_log_count + 1;

Line 134: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_count));

130: END LOOP;
131: */
132:
133: l_log_count:= l_log_count + 1;
134: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_count));
135: x_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
136:
137: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
138: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');

Line 135: x_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);

131: */
132:
133: l_log_count:= l_log_count + 1;
134: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_count));
135: x_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
136:
137: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
138: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
139: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_ENTY_ATTR_VALUE_PUB.Upsert_Attr_Value');

Line 138: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');

134: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_count));
135: x_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
136:
137: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
138: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
139: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_ENTY_ATTR_VALUE_PUB.Upsert_Attr_Value');
140: l_log_count:= l_log_count + 1;
141: x_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
142: END IF;

Line 139: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_ENTY_ATTR_VALUE_PUB.Upsert_Attr_Value');

135: x_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
136:
137: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
138: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
139: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_ENTY_ATTR_VALUE_PUB.Upsert_Attr_Value');
140: l_log_count:= l_log_count + 1;
141: x_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
142: END IF;
143: END IF;

Line 141: x_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);

137: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
138: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
139: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_ENTY_ATTR_VALUE_PUB.Upsert_Attr_Value');
140: l_log_count:= l_log_count + 1;
141: x_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
142: END IF;
143: END IF;
144:
145:

Line 440: fnd_message.set_name('PV', 'PV_INVALID_PARTNER_ORG_REF');

436:
437:
438: if p_contact_details_rec.Prtnr_orig_system is null OR p_contact_details_rec.Prtnr_orig_system_reference is null then
439: l_contact_create_ok:= 'FALSE';
440: fnd_message.set_name('PV', 'PV_INVALID_PARTNER_ORG_REF');
441: l_log_count:= l_log_count + 1;
442: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
443: else
444: OPEN get_party_id_from_ref(p_contact_details_rec.Prtnr_orig_system, p_contact_details_rec.Prtnr_orig_system_reference,'ORGANIZATION' ) ;

Line 442: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);

438: if p_contact_details_rec.Prtnr_orig_system is null OR p_contact_details_rec.Prtnr_orig_system_reference is null then
439: l_contact_create_ok:= 'FALSE';
440: fnd_message.set_name('PV', 'PV_INVALID_PARTNER_ORG_REF');
441: l_log_count:= l_log_count + 1;
442: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
443: else
444: OPEN get_party_id_from_ref(p_contact_details_rec.Prtnr_orig_system, p_contact_details_rec.Prtnr_orig_system_reference,'ORGANIZATION' ) ;
445: FETCH get_party_id_from_ref INTO l_partner_party_id;
446: CLOSE get_party_id_from_ref;

Line 486: fnd_message.set_name('PV', 'PV_INVALID_CONTACT_REF');

482:
483:
484: if p_contact_details_rec.Cnt_orig_system is null OR p_contact_details_rec.Cnt_orig_system_reference is null then
485: l_contact_create_ok:= 'FALSE';
486: fnd_message.set_name('PV', 'PV_INVALID_CONTACT_REF');
487: l_log_count:= l_log_count + 1;
488: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
489: else
490: OPEN get_party_id_from_ref(p_contact_details_rec.Cnt_orig_system, p_contact_details_rec.Cnt_orig_system_reference,'PERSON' ) ;

Line 488: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);

484: if p_contact_details_rec.Cnt_orig_system is null OR p_contact_details_rec.Cnt_orig_system_reference is null then
485: l_contact_create_ok:= 'FALSE';
486: fnd_message.set_name('PV', 'PV_INVALID_CONTACT_REF');
487: l_log_count:= l_log_count + 1;
488: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
489: else
490: OPEN get_party_id_from_ref(p_contact_details_rec.Cnt_orig_system, p_contact_details_rec.Cnt_orig_system_reference,'PERSON' ) ;
491: FETCH get_party_id_from_ref INTO l_person_party_id;
492: CLOSE get_party_id_from_ref;

Line 527: fnd_message.set_name('PV', 'PV_INVALID_PARTNER_ORG_REF');

523:
524:
525: if l_partner_party_id is null then
526: l_contact_create_ok:= 'FALSE';
527: fnd_message.set_name('PV', 'PV_INVALID_PARTNER_ORG_REF');
528: l_log_count:= l_log_count + 1;
529: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
530:
531: END IF;

Line 529: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);

525: if l_partner_party_id is null then
526: l_contact_create_ok:= 'FALSE';
527: fnd_message.set_name('PV', 'PV_INVALID_PARTNER_ORG_REF');
528: l_log_count:= l_log_count + 1;
529: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
530:
531: END IF;
532:
533: if l_person_party_id is null then

Line 535: fnd_message.set_name('PV', 'PV_INVALID_CONTACT_REF');

531: END IF;
532:
533: if l_person_party_id is null then
534: l_contact_create_ok:= 'FALSE';
535: fnd_message.set_name('PV', 'PV_INVALID_CONTACT_REF');
536: l_log_count:= l_log_count + 1;
537: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
538: END IF;
539:

Line 537: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);

533: if l_person_party_id is null then
534: l_contact_create_ok:= 'FALSE';
535: fnd_message.set_name('PV', 'PV_INVALID_CONTACT_REF');
536: l_log_count:= l_log_count + 1;
537: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
538: END IF;
539:
540:
541: -- dbms_output.put_line('Check if partner exists');

Line 550: fnd_message.set_name('PV', 'PV_MISSING_PARTNER_ID');

546:
547:
548: if l_partner_id is null then
549: l_contact_create_ok:= 'FALSE';
550: fnd_message.set_name('PV', 'PV_MISSING_PARTNER_ID');
551: l_log_count:= l_log_count + 1;
552: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
553:
554: END IF;

Line 552: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);

548: if l_partner_id is null then
549: l_contact_create_ok:= 'FALSE';
550: fnd_message.set_name('PV', 'PV_MISSING_PARTNER_ID');
551: l_log_count:= l_log_count + 1;
552: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
553:
554: END IF;
555:
556: -- dbms_output.put_line('Before check relationship');

Line 574: fnd_message.set_name('PV', 'PV_MISSING_EMAIL_ID');

570: if l_mode='CREATE' then
571:
572: if p_contact_details_rec.email_rec.email_address is null then
573: l_contact_create_ok:= 'FALSE';
574: fnd_message.set_name('PV', 'PV_MISSING_EMAIL_ID');
575: l_log_count:= l_log_count + 1;
576: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
577:
578: END IF;

Line 576: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);

572: if p_contact_details_rec.email_rec.email_address is null then
573: l_contact_create_ok:= 'FALSE';
574: fnd_message.set_name('PV', 'PV_MISSING_EMAIL_ID');
575: l_log_count:= l_log_count + 1;
576: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
577:
578: END IF;
579:
580:

Line 583: fnd_message.set_name('PV', 'PV_MISSING_PHONE');

579:
580:
581: if p_contact_details_rec.business_phone_rec.phone_number is null then
582: l_contact_create_ok:= 'FALSE';
583: fnd_message.set_name('PV', 'PV_MISSING_PHONE');
584: l_log_count:= l_log_count + 1;
585: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
586:
587: END IF;

Line 585: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);

581: if p_contact_details_rec.business_phone_rec.phone_number is null then
582: l_contact_create_ok:= 'FALSE';
583: fnd_message.set_name('PV', 'PV_MISSING_PHONE');
584: l_log_count:= l_log_count + 1;
585: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
586:
587: END IF;
588:
589: end if;

Line 607: fnd_message.set_name('PV', 'PV_CONTACT_EXISTS_ALREADY');

603: -- dbms_output.put_line('l_update_allowed = ' || l_update_allowed);
604:
605: if l_mode = 'UPDATE' and l_update_allowed = FND_API.G_FALSE then
606: l_contact_create_ok:= 'FALSE';
607: fnd_message.set_name('PV', 'PV_CONTACT_EXISTS_ALREADY');
608: l_log_count:= l_log_count + 1;
609: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
610:
611: x_contact_output_rec.return_status:='ERROR';

Line 609: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);

605: if l_mode = 'UPDATE' and l_update_allowed = FND_API.G_FALSE then
606: l_contact_create_ok:= 'FALSE';
607: fnd_message.set_name('PV', 'PV_CONTACT_EXISTS_ALREADY');
608: l_log_count:= l_log_count + 1;
609: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
610:
611: x_contact_output_rec.return_status:='ERROR';
612: x_log_msg:=l_log_msg;
613: RETURN;

Line 663: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_index));

659:
660:
661: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
662: /* FOR l_msg_index IN 1..l_msg_count LOOP
663: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_index));
664: -- dbms_output.put_line(fnd_message.get);
665: l_log_count:= l_log_count + 1;
666: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
667: END LOOP;

Line 664: -- dbms_output.put_line(fnd_message.get);

660:
661: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
662: /* FOR l_msg_index IN 1..l_msg_count LOOP
663: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_index));
664: -- dbms_output.put_line(fnd_message.get);
665: l_log_count:= l_log_count + 1;
666: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
667: END LOOP;
668: */

Line 666: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);

662: /* FOR l_msg_index IN 1..l_msg_count LOOP
663: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_index));
664: -- dbms_output.put_line(fnd_message.get);
665: l_log_count:= l_log_count + 1;
666: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
667: END LOOP;
668: */
669:
670: l_log_count:= l_log_count + 1;

Line 671: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_count));

667: END LOOP;
668: */
669:
670: l_log_count:= l_log_count + 1;
671: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_count));
672: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
673:
674:
675: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 672: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);

668: */
669:
670: l_log_count:= l_log_count + 1;
671: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_count));
672: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
673:
674:
675: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
676: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');

Line 676: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');

672: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
673:
674:
675: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
676: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
677: FND_MESSAGE.SET_TOKEN('API_NAME', 'HZ_PARTY_CONTACT_V2PUB.create_org_contact');
678: l_log_count:= l_log_count + 1;
679: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
680: END IF;

Line 677: FND_MESSAGE.SET_TOKEN('API_NAME', 'HZ_PARTY_CONTACT_V2PUB.create_org_contact');

673:
674:
675: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
676: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
677: FND_MESSAGE.SET_TOKEN('API_NAME', 'HZ_PARTY_CONTACT_V2PUB.create_org_contact');
678: l_log_count:= l_log_count + 1;
679: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
680: END IF;
681:

Line 679: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);

675: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
676: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
677: FND_MESSAGE.SET_TOKEN('API_NAME', 'HZ_PARTY_CONTACT_V2PUB.create_org_contact');
678: l_log_count:= l_log_count + 1;
679: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
680: END IF;
681:
682:
683:

Line 724: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_index));

720: l_contact_create_ok := 'FALSE';
721: x_contact_output_rec.return_status:='ERROR';
722: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
723: FOR l_msg_index IN 1..l_msg_count LOOP
724: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_index));
725: -- dbms_output.put_line(fnd_message.get);
726: l_log_count:= l_log_count + 1;
727: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
728: END LOOP;

Line 725: -- dbms_output.put_line(fnd_message.get);

721: x_contact_output_rec.return_status:='ERROR';
722: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
723: FOR l_msg_index IN 1..l_msg_count LOOP
724: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_index));
725: -- dbms_output.put_line(fnd_message.get);
726: l_log_count:= l_log_count + 1;
727: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
728: END LOOP;
729: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 727: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);

723: FOR l_msg_index IN 1..l_msg_count LOOP
724: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_index));
725: -- dbms_output.put_line(fnd_message.get);
726: l_log_count:= l_log_count + 1;
727: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
728: END LOOP;
729: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
730: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
731: FND_MESSAGE.SET_TOKEN('API_NAME', 'HZ_LOCATION_V2PUB.create_location');

Line 730: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');

726: l_log_count:= l_log_count + 1;
727: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
728: END LOOP;
729: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
730: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
731: FND_MESSAGE.SET_TOKEN('API_NAME', 'HZ_LOCATION_V2PUB.create_location');
732: l_log_count:= l_log_count + 1;
733: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
734: END IF;

Line 731: FND_MESSAGE.SET_TOKEN('API_NAME', 'HZ_LOCATION_V2PUB.create_location');

727: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
728: END LOOP;
729: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
730: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
731: FND_MESSAGE.SET_TOKEN('API_NAME', 'HZ_LOCATION_V2PUB.create_location');
732: l_log_count:= l_log_count + 1;
733: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
734: END IF;
735: END IF;

Line 733: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);

729: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
730: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
731: FND_MESSAGE.SET_TOKEN('API_NAME', 'HZ_LOCATION_V2PUB.create_location');
732: l_log_count:= l_log_count + 1;
733: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
734: END IF;
735: END IF;
736:
737:

Line 763: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_index));

759: l_contact_create_ok := 'FALSE';
760: x_contact_output_rec.return_status:='ERROR';
761: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
762: FOR l_msg_index IN 1..l_msg_count LOOP
763: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_index));
764: -- dbms_output.put_line(fnd_message.get);
765: l_log_count:= l_log_count + 1;
766: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
767: END LOOP;

Line 764: -- dbms_output.put_line(fnd_message.get);

760: x_contact_output_rec.return_status:='ERROR';
761: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
762: FOR l_msg_index IN 1..l_msg_count LOOP
763: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_index));
764: -- dbms_output.put_line(fnd_message.get);
765: l_log_count:= l_log_count + 1;
766: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
767: END LOOP;
768: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 766: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);

762: FOR l_msg_index IN 1..l_msg_count LOOP
763: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_index));
764: -- dbms_output.put_line(fnd_message.get);
765: l_log_count:= l_log_count + 1;
766: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
767: END LOOP;
768: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
769: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
770: FND_MESSAGE.SET_TOKEN('API_NAME', 'HZ_PARTY_SITE_V2PUB.create_party_site');

Line 769: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');

765: l_log_count:= l_log_count + 1;
766: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
767: END LOOP;
768: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
769: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
770: FND_MESSAGE.SET_TOKEN('API_NAME', 'HZ_PARTY_SITE_V2PUB.create_party_site');
771: l_log_count:= l_log_count + 1;
772: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
773: END IF;

Line 770: FND_MESSAGE.SET_TOKEN('API_NAME', 'HZ_PARTY_SITE_V2PUB.create_party_site');

766: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
767: END LOOP;
768: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
769: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
770: FND_MESSAGE.SET_TOKEN('API_NAME', 'HZ_PARTY_SITE_V2PUB.create_party_site');
771: l_log_count:= l_log_count + 1;
772: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
773: END IF;
774: END IF;

Line 772: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);

768: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
769: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
770: FND_MESSAGE.SET_TOKEN('API_NAME', 'HZ_PARTY_SITE_V2PUB.create_party_site');
771: l_log_count:= l_log_count + 1;
772: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
773: END IF;
774: END IF;
775:
776:

Line 820: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_index));

816: l_contact_create_ok := 'FALSE';
817: x_contact_output_rec.return_status:='ERROR';
818: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
819: FOR l_msg_index IN 1..l_msg_count LOOP
820: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_index));
821: -- -- dbms_output.put_line('Printing first time' || fnd_message.get);
822: l_log_count:= l_log_count + 1;
823: -- l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
824: l_log_msg(l_log_count):=fnd_message.get;

Line 821: -- -- dbms_output.put_line('Printing first time' || fnd_message.get);

817: x_contact_output_rec.return_status:='ERROR';
818: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
819: FOR l_msg_index IN 1..l_msg_count LOOP
820: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_index));
821: -- -- dbms_output.put_line('Printing first time' || fnd_message.get);
822: l_log_count:= l_log_count + 1;
823: -- l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
824: l_log_msg(l_log_count):=fnd_message.get;
825: -- dbms_output.put_line('printing log ' || l_log_msg(l_log_count));

Line 823: -- l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);

819: FOR l_msg_index IN 1..l_msg_count LOOP
820: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_index));
821: -- -- dbms_output.put_line('Printing first time' || fnd_message.get);
822: l_log_count:= l_log_count + 1;
823: -- l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
824: l_log_msg(l_log_count):=fnd_message.get;
825: -- dbms_output.put_line('printing log ' || l_log_msg(l_log_count));
826: END LOOP;
827: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 824: l_log_msg(l_log_count):=fnd_message.get;

820: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_index));
821: -- -- dbms_output.put_line('Printing first time' || fnd_message.get);
822: l_log_count:= l_log_count + 1;
823: -- l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
824: l_log_msg(l_log_count):=fnd_message.get;
825: -- dbms_output.put_line('printing log ' || l_log_msg(l_log_count));
826: END LOOP;
827: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
828: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');

Line 828: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');

824: l_log_msg(l_log_count):=fnd_message.get;
825: -- dbms_output.put_line('printing log ' || l_log_msg(l_log_count));
826: END LOOP;
827: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
828: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
829: FND_MESSAGE.SET_TOKEN('API_NAME', 'HZ_CONTACT_POINT_V2PUB.create_phone_contact_point');
830: l_log_count:= l_log_count + 1;
831: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
832: END IF;

Line 829: FND_MESSAGE.SET_TOKEN('API_NAME', 'HZ_CONTACT_POINT_V2PUB.create_phone_contact_point');

825: -- dbms_output.put_line('printing log ' || l_log_msg(l_log_count));
826: END LOOP;
827: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
828: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
829: FND_MESSAGE.SET_TOKEN('API_NAME', 'HZ_CONTACT_POINT_V2PUB.create_phone_contact_point');
830: l_log_count:= l_log_count + 1;
831: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
832: END IF;
833: END IF;

Line 831: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);

827: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
828: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
829: FND_MESSAGE.SET_TOKEN('API_NAME', 'HZ_CONTACT_POINT_V2PUB.create_phone_contact_point');
830: l_log_count:= l_log_count + 1;
831: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
832: END IF;
833: END IF;
834:
835: -- dbms_output.put_line('after create phone' || l_contact_point_id);

Line 872: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_index));

868: l_contact_create_ok := 'FALSE';
869: x_contact_output_rec.return_status:='ERROR';
870: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
871: FOR l_msg_index IN 1..l_msg_count LOOP
872: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_index));
873: -- dbms_output.put_line(fnd_message.get);
874: l_log_count:= l_log_count + 1;
875: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
876: END LOOP;

Line 873: -- dbms_output.put_line(fnd_message.get);

869: x_contact_output_rec.return_status:='ERROR';
870: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
871: FOR l_msg_index IN 1..l_msg_count LOOP
872: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_index));
873: -- dbms_output.put_line(fnd_message.get);
874: l_log_count:= l_log_count + 1;
875: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
876: END LOOP;
877: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 875: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);

871: FOR l_msg_index IN 1..l_msg_count LOOP
872: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_index));
873: -- dbms_output.put_line(fnd_message.get);
874: l_log_count:= l_log_count + 1;
875: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
876: END LOOP;
877: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
878: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
879: FND_MESSAGE.SET_TOKEN('API_NAME', 'HZ_CONTACT_POINT_V2PUB.create_email_contact_point');

Line 878: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');

874: l_log_count:= l_log_count + 1;
875: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
876: END LOOP;
877: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
878: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
879: FND_MESSAGE.SET_TOKEN('API_NAME', 'HZ_CONTACT_POINT_V2PUB.create_email_contact_point');
880: l_log_count:= l_log_count + 1;
881: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
882: END IF;

Line 879: FND_MESSAGE.SET_TOKEN('API_NAME', 'HZ_CONTACT_POINT_V2PUB.create_email_contact_point');

875: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
876: END LOOP;
877: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
878: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
879: FND_MESSAGE.SET_TOKEN('API_NAME', 'HZ_CONTACT_POINT_V2PUB.create_email_contact_point');
880: l_log_count:= l_log_count + 1;
881: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
882: END IF;
883: END IF;

Line 881: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);

877: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
878: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
879: FND_MESSAGE.SET_TOKEN('API_NAME', 'HZ_CONTACT_POINT_V2PUB.create_email_contact_point');
880: l_log_count:= l_log_count + 1;
881: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
882: END IF;
883: END IF;
884:
885: -- dbms_output.put_line('after create email' || l_contact_point_id);

Line 969: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_index));

965: l_contact_create_ok := 'FALSE';
966: x_contact_output_rec.return_status:='ERROR';
967: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
968: FOR l_msg_index IN 1..l_msg_count LOOP
969: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_index));
970: -- dbms_output.put_line(fnd_message.get);
971: l_log_count:= l_log_count + 1;
972: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
973: END LOOP;

Line 970: -- dbms_output.put_line(fnd_message.get);

966: x_contact_output_rec.return_status:='ERROR';
967: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
968: FOR l_msg_index IN 1..l_msg_count LOOP
969: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_index));
970: -- dbms_output.put_line(fnd_message.get);
971: l_log_count:= l_log_count + 1;
972: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
973: END LOOP;
974: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 972: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);

968: FOR l_msg_index IN 1..l_msg_count LOOP
969: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_index));
970: -- dbms_output.put_line(fnd_message.get);
971: l_log_count:= l_log_count + 1;
972: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
973: END LOOP;
974: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
975: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
976: FND_MESSAGE.SET_TOKEN('API_NAME', 'HZ_CONTACT_POINT_V2PUB.create_email_contact_point');

Line 975: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');

971: l_log_count:= l_log_count + 1;
972: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
973: END LOOP;
974: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
975: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
976: FND_MESSAGE.SET_TOKEN('API_NAME', 'HZ_CONTACT_POINT_V2PUB.create_email_contact_point');
977: l_log_count:= l_log_count + 1;
978: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
979: END IF;

Line 976: FND_MESSAGE.SET_TOKEN('API_NAME', 'HZ_CONTACT_POINT_V2PUB.create_email_contact_point');

972: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
973: END LOOP;
974: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
975: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
976: FND_MESSAGE.SET_TOKEN('API_NAME', 'HZ_CONTACT_POINT_V2PUB.create_email_contact_point');
977: l_log_count:= l_log_count + 1;
978: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
979: END IF;
980: END IF;

Line 978: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);

974: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
975: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
976: FND_MESSAGE.SET_TOKEN('API_NAME', 'HZ_CONTACT_POINT_V2PUB.create_email_contact_point');
977: l_log_count:= l_log_count + 1;
978: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
979: END IF;
980: END IF;
981:
982:

Line 1017: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_index));

1013: l_contact_create_ok := 'FALSE';
1014: x_contact_output_rec.return_status:='ERROR';
1015: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1016: FOR l_msg_index IN 1..l_msg_count LOOP
1017: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_index));
1018: -- dbms_output.put_line(fnd_message.get);
1019: l_log_count:= l_log_count + 1;
1020: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
1021: END LOOP;

Line 1018: -- dbms_output.put_line(fnd_message.get);

1014: x_contact_output_rec.return_status:='ERROR';
1015: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1016: FOR l_msg_index IN 1..l_msg_count LOOP
1017: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_index));
1018: -- dbms_output.put_line(fnd_message.get);
1019: l_log_count:= l_log_count + 1;
1020: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
1021: END LOOP;
1022: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1020: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);

1016: FOR l_msg_index IN 1..l_msg_count LOOP
1017: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_index));
1018: -- dbms_output.put_line(fnd_message.get);
1019: l_log_count:= l_log_count + 1;
1020: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
1021: END LOOP;
1022: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1023: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
1024: FND_MESSAGE.SET_TOKEN('API_NAME', 'HZ_CUST_ACCOUNT_ROLE_V2PUB.create_cust_account_role');

Line 1023: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');

1019: l_log_count:= l_log_count + 1;
1020: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
1021: END LOOP;
1022: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1023: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
1024: FND_MESSAGE.SET_TOKEN('API_NAME', 'HZ_CUST_ACCOUNT_ROLE_V2PUB.create_cust_account_role');
1025: l_log_count:= l_log_count + 1;
1026: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
1027: END IF;

Line 1024: FND_MESSAGE.SET_TOKEN('API_NAME', 'HZ_CUST_ACCOUNT_ROLE_V2PUB.create_cust_account_role');

1020: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
1021: END LOOP;
1022: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1023: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
1024: FND_MESSAGE.SET_TOKEN('API_NAME', 'HZ_CUST_ACCOUNT_ROLE_V2PUB.create_cust_account_role');
1025: l_log_count:= l_log_count + 1;
1026: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
1027: END IF;
1028: END IF;

Line 1026: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);

1022: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1023: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
1024: FND_MESSAGE.SET_TOKEN('API_NAME', 'HZ_CUST_ACCOUNT_ROLE_V2PUB.create_cust_account_role');
1025: l_log_count:= l_log_count + 1;
1026: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
1027: END IF;
1028: END IF;
1029:
1030:

Line 1098: fnd_message.set_name('PV', 'PV_SSO_CREATE_USER_NOT_ALLOWED');

1094: l_sso_enabled := fnd_profile.value('APPS_SSO_USER_CREATE_UPDATE');
1095: if l_sso_enabled = 'N' OR l_sso_enabled = 'FTTT' OR l_sso_enabled = 'FFFF' then
1096: l_contact_create_ok:= 'FALSE';
1097: x_contact_output_rec.return_status:='ERROR';
1098: fnd_message.set_name('PV', 'PV_SSO_CREATE_USER_NOT_ALLOWED');
1099: l_log_count:= l_log_count + 1;
1100: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
1101:
1102: end if;

Line 1100: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);

1096: l_contact_create_ok:= 'FALSE';
1097: x_contact_output_rec.return_status:='ERROR';
1098: fnd_message.set_name('PV', 'PV_SSO_CREATE_USER_NOT_ALLOWED');
1099: l_log_count:= l_log_count + 1;
1100: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
1101:
1102: end if;
1103:
1104: -- dbms_output.put_line('after sso check ');

Line 1119: fnd_message.set_name('PV', 'PV_CONTACT_USER_EXISTS');

1115:
1116: if l_exists_user_name is not null then
1117: l_contact_create_ok:= 'FALSE';
1118: x_contact_output_rec.return_status:='ERROR';
1119: fnd_message.set_name('PV', 'PV_CONTACT_USER_EXISTS');
1120: l_log_count:= l_log_count + 1;
1121: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
1122:
1123:

Line 1121: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);

1117: l_contact_create_ok:= 'FALSE';
1118: x_contact_output_rec.return_status:='ERROR';
1119: fnd_message.set_name('PV', 'PV_CONTACT_USER_EXISTS');
1120: l_log_count:= l_log_count + 1;
1121: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
1122:
1123:
1124: end if;
1125:

Line 1131: fnd_message.set_name('PV', 'PV_USER_DIFFERENT');

1127:
1128: if l_contact_details_rec.user_name <> l_exists_user_name then
1129: l_contact_create_ok:= 'FALSE';
1130: x_contact_output_rec.return_status:='ERROR';
1131: fnd_message.set_name('PV', 'PV_USER_DIFFERENT');
1132: l_log_count:= l_log_count + 1;
1133: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
1134: end if;
1135: end if;

Line 1133: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);

1129: l_contact_create_ok:= 'FALSE';
1130: x_contact_output_rec.return_status:='ERROR';
1131: fnd_message.set_name('PV', 'PV_USER_DIFFERENT');
1132: l_log_count:= l_log_count + 1;
1133: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
1134: end if;
1135: end if;
1136: -- dbms_output.put_line('after user exists for contact check ');
1137:

Line 1148: fnd_message.set_name('PV', 'PV_USER_TYPE_REQUIRED');

1144: if l_user_type is null then
1145: l_contact_create_ok:= 'FALSE';
1146: x_contact_output_rec.return_status:='ERROR';
1147:
1148: fnd_message.set_name('PV', 'PV_USER_TYPE_REQUIRED');
1149: l_log_count:= l_log_count + 1;
1150: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
1151: end if;
1152:

Line 1150: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);

1146: x_contact_output_rec.return_status:='ERROR';
1147:
1148: fnd_message.set_name('PV', 'PV_USER_TYPE_REQUIRED');
1149: l_log_count:= l_log_count + 1;
1150: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
1151: end if;
1152:
1153: -- dbms_output.put_line('after user type check ');
1154:

Line 1165: fnd_message.set_name('FND','INVALID_USER_NAME');

1161: l_test_user_return_code := FND_USER_PKG.TestUserName(l_contact_details_rec.user_name);
1162: if l_test_user_return_code = 1 then
1163: l_contact_create_ok:= 'FALSE';
1164: x_contact_output_rec.return_status:='ERROR';
1165: fnd_message.set_name('FND','INVALID_USER_NAME');
1166: l_log_count:= l_log_count + 1;
1167: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
1168:
1169: elsif l_test_user_return_code = 2 then

Line 1167: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);

1163: l_contact_create_ok:= 'FALSE';
1164: x_contact_output_rec.return_status:='ERROR';
1165: fnd_message.set_name('FND','INVALID_USER_NAME');
1166: l_log_count:= l_log_count + 1;
1167: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
1168:
1169: elsif l_test_user_return_code = 2 then
1170: l_contact_create_ok:= 'FALSE';
1171: x_contact_output_rec.return_status:='ERROR';

Line 1172: fnd_message.set_name('FND','FND_USER_EXISTS_IN_FND');

1168:
1169: elsif l_test_user_return_code = 2 then
1170: l_contact_create_ok:= 'FALSE';
1171: x_contact_output_rec.return_status:='ERROR';
1172: fnd_message.set_name('FND','FND_USER_EXISTS_IN_FND');
1173: l_log_count:= l_log_count + 1;
1174: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
1175:
1176: elsif l_test_user_return_code = 4 then

Line 1174: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);

1170: l_contact_create_ok:= 'FALSE';
1171: x_contact_output_rec.return_status:='ERROR';
1172: fnd_message.set_name('FND','FND_USER_EXISTS_IN_FND');
1173: l_log_count:= l_log_count + 1;
1174: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
1175:
1176: elsif l_test_user_return_code = 4 then
1177: l_contact_create_ok:= 'FALSE';
1178: x_contact_output_rec.return_status:='ERROR';

Line 1179: fnd_message.set_name('FND','FND_USER_EXISTS_NO_LINK');

1175:
1176: elsif l_test_user_return_code = 4 then
1177: l_contact_create_ok:= 'FALSE';
1178: x_contact_output_rec.return_status:='ERROR';
1179: fnd_message.set_name('FND','FND_USER_EXISTS_NO_LINK');
1180: l_log_count:= l_log_count + 1;
1181: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
1182:
1183: end if;

Line 1181: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);

1177: l_contact_create_ok:= 'FALSE';
1178: x_contact_output_rec.return_status:='ERROR';
1179: fnd_message.set_name('FND','FND_USER_EXISTS_NO_LINK');
1180: l_log_count:= l_log_count + 1;
1181: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
1182:
1183: end if;
1184: end if;
1185:

Line 1249: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_index));

1245: l_contact_create_ok := 'FALSE';
1246: x_contact_output_rec.return_status:='ERROR';
1247: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1248: FOR l_msg_index IN 1..l_msg_count LOOP
1249: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_index));
1250: -- dbms_output.put_line(fnd_message.get);
1251: l_log_count:= l_log_count + 1;
1252: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
1253: END LOOP;

Line 1250: -- dbms_output.put_line(fnd_message.get);

1246: x_contact_output_rec.return_status:='ERROR';
1247: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1248: FOR l_msg_index IN 1..l_msg_count LOOP
1249: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_index));
1250: -- dbms_output.put_line(fnd_message.get);
1251: l_log_count:= l_log_count + 1;
1252: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
1253: END LOOP;
1254: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1252: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);

1248: FOR l_msg_index IN 1..l_msg_count LOOP
1249: fnd_message.set_encoded(fnd_msg_pub.get(l_msg_index));
1250: -- dbms_output.put_line(fnd_message.get);
1251: l_log_count:= l_log_count + 1;
1252: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
1253: END LOOP;
1254: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1255: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
1256: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_CONTACT_USER_BATCH_PUB.user_create');

Line 1255: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');

1251: l_log_count:= l_log_count + 1;
1252: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
1253: END LOOP;
1254: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1255: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
1256: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_CONTACT_USER_BATCH_PUB.user_create');
1257: l_log_count:= l_log_count + 1;
1258: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
1259: END IF;

Line 1256: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_CONTACT_USER_BATCH_PUB.user_create');

1252: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
1253: END LOOP;
1254: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1255: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
1256: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_CONTACT_USER_BATCH_PUB.user_create');
1257: l_log_count:= l_log_count + 1;
1258: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
1259: END IF;
1260: END IF;

Line 1258: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);

1254: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1255: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
1256: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_CONTACT_USER_BATCH_PUB.user_create');
1257: l_log_count:= l_log_count + 1;
1258: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
1259: END IF;
1260: END IF;
1261:
1262:

Line 1277: fnd_message.set_name('PV', 'PV_CONTACT_USER_SUCCESS');

1273: x_contact_output_rec.contact_rel_party_id:=l_rel_party_id;
1274: x_contact_output_rec.return_status:='SUCCESS';
1275: x_contact_output_rec.user_name:=l_contact_details_rec.user_name;
1276: x_contact_output_rec.password:=l_password;
1277: fnd_message.set_name('PV', 'PV_CONTACT_USER_SUCCESS');
1278: l_log_count:= l_log_count + 1;
1279: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
1280: END IF;
1281:

Line 1279: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);

1275: x_contact_output_rec.user_name:=l_contact_details_rec.user_name;
1276: x_contact_output_rec.password:=l_password;
1277: fnd_message.set_name('PV', 'PV_CONTACT_USER_SUCCESS');
1278: l_log_count:= l_log_count + 1;
1279: l_log_msg(l_log_count):=substrb(fnd_message.get, 1, 1000);
1280: END IF;
1281:
1282: x_log_msg:=l_log_msg;
1283: RETURN;

Line 1522: fnd_message.SET_NAME ('PV', 'PV_CONTACT_ID_INVALID');

1518:
1519:
1520:
1521: if l_contact_rel_id is null then
1522: fnd_message.SET_NAME ('PV', 'PV_CONTACT_ID_INVALID');
1523: fnd_msg_pub.ADD;
1524: raise FND_API.G_EXC_ERROR;
1525: END IF;
1526:

Line 1534: fnd_message.SET_NAME ('PV', 'PV_CONTACT_ID_INVALID');

1530: CLOSE CHECK_CONTACT;
1531:
1532:
1533: if l_contact_party_id is null then
1534: fnd_message.SET_NAME ('PV', 'PV_CONTACT_ID_INVALID');
1535: fnd_msg_pub.ADD;
1536: raise FND_API.G_EXC_ERROR;
1537:
1538: END IF;

Line 1543: fnd_message.SET_NAME ('PV', 'PV_USER_NAME_MISSING');

1539:
1540:
1541:
1542: if l_user_name is null then
1543: fnd_message.SET_NAME ('PV', 'PV_USER_NAME_MISSING');
1544: fnd_msg_pub.ADD;
1545: raise FND_API.G_EXC_ERROR;
1546:
1547: END IF;

Line 1556: fnd_message.set_name('PV', 'PV_SSO_CREATE_USER_NOT_ALLOWED');

1552:
1553: /**************** CHECK FOR SSO ************************************************************************/
1554: l_sso_enabled := fnd_profile.value('APPS_SSO_USER_CREATE_UPDATE');
1555: if l_sso_enabled = 'N' OR l_sso_enabled = 'FTTT' OR l_sso_enabled = 'FFFF' then
1556: fnd_message.set_name('PV', 'PV_SSO_CREATE_USER_NOT_ALLOWED');
1557: fnd_msg_pub.ADD;
1558: raise FND_API.G_EXC_ERROR;
1559: end if;
1560:

Line 1579: fnd_message.SET_NAME ('PV', 'PV_NOT_EMPLOYEE_REL');

1575:
1576:
1577:
1578: if l_relationship_code is null or l_relationship_code <> 'EMPLOYEE_OF' then
1579: fnd_message.SET_NAME ('PV', 'PV_NOT_EMPLOYEE_REL');
1580: fnd_msg_pub.ADD;
1581: RAISE FND_API.G_EXC_ERROR;
1582: END IF;
1583:

Line 1596: fnd_message.SET_NAME ('PV', 'PV_CONTACT_NOT_ACTIVE');

1592:
1593: -- dbms_output.put_line('before party status check');
1594:
1595: if l_party_status is null or l_party_status <> 'A' then
1596: fnd_message.SET_NAME ('PV', 'PV_CONTACT_NOT_ACTIVE');
1597: fnd_msg_pub.ADD;
1598: RAISE FND_API.G_EXC_ERROR;
1599:
1600: END IF;

Line 1675: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');

1671: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1672: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1673: RAISE FND_API.G_EXC_ERROR;
1674: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1675: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
1676: FND_MESSAGE.SET_TOKEN('API_NAME', 'JTF_UM_PASSWORD_PVT.generate_password ');
1677: FND_MSG_PUB.Add;
1678: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1679: END IF;

Line 1676: FND_MESSAGE.SET_TOKEN('API_NAME', 'JTF_UM_PASSWORD_PVT.generate_password ');

1672: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1673: RAISE FND_API.G_EXC_ERROR;
1674: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1675: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
1676: FND_MESSAGE.SET_TOKEN('API_NAME', 'JTF_UM_PASSWORD_PVT.generate_password ');
1677: FND_MSG_PUB.Add;
1678: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1679: END IF;
1680: END IF;

Line 1752: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');

1748: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1749: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1750: RAISE FND_API.G_EXC_ERROR;
1751: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1752: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
1753: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_USER_MGMT_PVT.register_partner_user ');
1754: FND_MSG_PUB.Add;
1755: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1756: END IF;

Line 1753: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_USER_MGMT_PVT.register_partner_user ');

1749: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1750: RAISE FND_API.G_EXC_ERROR;
1751: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1752: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
1753: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_USER_MGMT_PVT.register_partner_user ');
1754: FND_MSG_PUB.Add;
1755: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1756: END IF;
1757: END IF;

Line 1790: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');

1786: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1787: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1788: RAISE FND_API.G_EXC_ERROR;
1789: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1790: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
1791: FND_MESSAGE.SET_TOKEN('API_NAME', 'pv_user_resp_pvt.assign_resp');
1792: FND_MSG_PUB.Add;
1793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1794: END IF;

Line 1791: FND_MESSAGE.SET_TOKEN('API_NAME', 'pv_user_resp_pvt.assign_resp');

1787: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1788: RAISE FND_API.G_EXC_ERROR;
1789: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1790: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
1791: FND_MESSAGE.SET_TOKEN('API_NAME', 'pv_user_resp_pvt.assign_resp');
1792: FND_MSG_PUB.Add;
1793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1794: END IF;
1795: END IF;

Line 2124: fnd_message.SET_NAME ('PV', 'PV_CONTACT_ID_INVALID');

2120:
2121: -- dbms_output.put_line('l_contact_rel_id ' || l_contact_rel_id);
2122:
2123: if l_contact_rel_id is null then
2124: fnd_message.SET_NAME ('PV', 'PV_CONTACT_ID_INVALID');
2125: fnd_msg_pub.ADD;
2126: raise FND_API.G_EXC_ERROR;
2127: END IF;
2128:

Line 2136: fnd_message.SET_NAME ('PV', 'PV_CONTACT_ID_INVALID');

2132: CLOSE CHECK_CONTACT;
2133:
2134:
2135: if l_contact_party_id is null then
2136: fnd_message.SET_NAME ('PV', 'PV_CONTACT_ID_INVALID');
2137: fnd_msg_pub.ADD;
2138: raise FND_API.G_EXC_ERROR;
2139:
2140: END IF;

Line 2145: fnd_message.SET_NAME ('PV', 'PV_USER_NAME_MISSING');

2141:
2142:
2143:
2144: if l_user_name is null then
2145: fnd_message.SET_NAME ('PV', 'PV_USER_NAME_MISSING');
2146: fnd_msg_pub.ADD;
2147: raise FND_API.G_EXC_ERROR;
2148:
2149: END IF;

Line 2158: fnd_message.set_name('PV', 'PV_SSO_CREATE_USER_NOT_ALLOWED');

2154:
2155: /**************** CHECK FOR SSO ************************************************************************/
2156: l_sso_enabled := fnd_profile.value('APPS_SSO_USER_CREATE_UPDATE');
2157: if l_sso_enabled = 'N' OR l_sso_enabled = 'FTTT' OR l_sso_enabled = 'FFFF' then
2158: fnd_message.set_name('PV', 'PV_SSO_CREATE_USER_NOT_ALLOWED');
2159: fnd_msg_pub.ADD;
2160: raise FND_API.G_EXC_ERROR;
2161: end if;
2162:

Line 2177: fnd_message.SET_NAME ('PV', 'PV_NOT_EMPLOYEE_REL');

2173:
2174:
2175:
2176: if l_relationship_code is null or l_relationship_code <> 'EMPLOYEE_OF' then
2177: fnd_message.SET_NAME ('PV', 'PV_NOT_EMPLOYEE_REL');
2178: fnd_msg_pub.ADD;
2179: RAISE FND_API.G_EXC_ERROR;
2180: END IF;
2181:

Line 2194: fnd_message.SET_NAME ('PV', 'PV_CONTACT_NOT_ACTIVE');

2190:
2191: -- dbms_output.put_line('before party status check');
2192:
2193: if l_party_status is null or l_party_status <> 'A' then
2194: fnd_message.SET_NAME ('PV', 'PV_CONTACT_NOT_ACTIVE');
2195: fnd_msg_pub.ADD;
2196: RAISE FND_API.G_EXC_ERROR;
2197:
2198: END IF;

Line 2282: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');

2278: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2279: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2280: RAISE FND_API.G_EXC_ERROR;
2281: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2282: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
2283: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_USER_MGMT_PVT.register_partner_user ');
2284: FND_MSG_PUB.Add;
2285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2286: END IF;

Line 2283: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_USER_MGMT_PVT.register_partner_user ');

2279: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2280: RAISE FND_API.G_EXC_ERROR;
2281: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2282: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
2283: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_USER_MGMT_PVT.register_partner_user ');
2284: FND_MSG_PUB.Add;
2285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2286: END IF;
2287: END IF;

Line 2318: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');

2314: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2315: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2316: RAISE FND_API.G_EXC_ERROR;
2317: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2318: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
2319: FND_MESSAGE.SET_TOKEN('API_NAME', 'pv_user_resp_pvt.assign_resp');
2320: FND_MSG_PUB.Add;
2321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2322: END IF;

Line 2319: FND_MESSAGE.SET_TOKEN('API_NAME', 'pv_user_resp_pvt.assign_resp');

2315: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2316: RAISE FND_API.G_EXC_ERROR;
2317: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2318: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
2319: FND_MESSAGE.SET_TOKEN('API_NAME', 'pv_user_resp_pvt.assign_resp');
2320: FND_MSG_PUB.Add;
2321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2322: END IF;
2323: END IF;

Line 2511: fnd_message.set_name('PV', 'PV_IMP_NO_CONTACT');

2507:
2508:
2509: if l_contact_details_tbl.count = 0 then
2510:
2511: fnd_message.set_name('PV', 'PV_IMP_NO_CONTACT');
2512: utl_file.put_line(L_LOG_FILE, substrb(fnd_message.get, 1, 1000));
2513: x_return_status:='S';
2514:
2515:

Line 2512: utl_file.put_line(L_LOG_FILE, substrb(fnd_message.get, 1, 1000));

2508:
2509: if l_contact_details_tbl.count = 0 then
2510:
2511: fnd_message.set_name('PV', 'PV_IMP_NO_CONTACT');
2512: utl_file.put_line(L_LOG_FILE, substrb(fnd_message.get, 1, 1000));
2513: x_return_status:='S';
2514:
2515:
2516:

Line 2556: fnd_message.set_name('PV', 'PV_CONTACT_IMPORT_LOG');

2552: if l_contact_details_tbl.LAST < l_last_rec then
2553: l_last_rec := l_contact_details_tbl.LAST;
2554: end if ;
2555:
2556: fnd_message.set_name('PV', 'PV_CONTACT_IMPORT_LOG');
2557: utl_file.put_line(L_LOG_FILE, substrb(fnd_message.get, 1, 1000));
2558:
2559: utl_file.put_line(L_LOG_FILE, '-----------------------------------------------------------------------------------------------------'
2560: || '-----------------------------------------------------------------------------------------------------------------------------------------------');

Line 2557: utl_file.put_line(L_LOG_FILE, substrb(fnd_message.get, 1, 1000));

2553: l_last_rec := l_contact_details_tbl.LAST;
2554: end if ;
2555:
2556: fnd_message.set_name('PV', 'PV_CONTACT_IMPORT_LOG');
2557: utl_file.put_line(L_LOG_FILE, substrb(fnd_message.get, 1, 1000));
2558:
2559: utl_file.put_line(L_LOG_FILE, '-----------------------------------------------------------------------------------------------------'
2560: || '-----------------------------------------------------------------------------------------------------------------------------------------------');
2561: -- dbms_output.put_line('just after writing to file');

Line 2611: fnd_message.set_name('PV', 'PV_CONTACT_REC_SUCCESS');

2607:
2608: */
2609: log_return_status:=null;
2610: if l_contact_output_rec.return_status = 'SUCCESS' then
2611: fnd_message.set_name('PV', 'PV_CONTACT_REC_SUCCESS');
2612: elsif l_contact_output_rec.return_status = 'ERROR' then
2613: fnd_message.set_name('PV', 'PV_CONTACT_REC_ERROR');
2614: elsif l_contact_output_rec.return_status = 'NOT_PROCESSED' then
2615: fnd_message.set_name('PV', 'PV_CONTACT_REC_NOT_PROCESSED');

Line 2613: fnd_message.set_name('PV', 'PV_CONTACT_REC_ERROR');

2609: log_return_status:=null;
2610: if l_contact_output_rec.return_status = 'SUCCESS' then
2611: fnd_message.set_name('PV', 'PV_CONTACT_REC_SUCCESS');
2612: elsif l_contact_output_rec.return_status = 'ERROR' then
2613: fnd_message.set_name('PV', 'PV_CONTACT_REC_ERROR');
2614: elsif l_contact_output_rec.return_status = 'NOT_PROCESSED' then
2615: fnd_message.set_name('PV', 'PV_CONTACT_REC_NOT_PROCESSED');
2616: end if;
2617: log_return_status:=substrb(fnd_message.get, 1, 1000);

Line 2615: fnd_message.set_name('PV', 'PV_CONTACT_REC_NOT_PROCESSED');

2611: fnd_message.set_name('PV', 'PV_CONTACT_REC_SUCCESS');
2612: elsif l_contact_output_rec.return_status = 'ERROR' then
2613: fnd_message.set_name('PV', 'PV_CONTACT_REC_ERROR');
2614: elsif l_contact_output_rec.return_status = 'NOT_PROCESSED' then
2615: fnd_message.set_name('PV', 'PV_CONTACT_REC_NOT_PROCESSED');
2616: end if;
2617: log_return_status:=substrb(fnd_message.get, 1, 1000);
2618:
2619:

Line 2617: log_return_status:=substrb(fnd_message.get, 1, 1000);

2613: fnd_message.set_name('PV', 'PV_CONTACT_REC_ERROR');
2614: elsif l_contact_output_rec.return_status = 'NOT_PROCESSED' then
2615: fnd_message.set_name('PV', 'PV_CONTACT_REC_NOT_PROCESSED');
2616: end if;
2617: log_return_status:=substrb(fnd_message.get, 1, 1000);
2618:
2619:
2620:
2621: -- dbms_output.put_line('just before writing to file');