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

Line 70: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

66: --
67: -- End of Comments
68: -- ==============================================================================
69:
70: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
71: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
72: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
73:
74: PROCEDURE Create_Ptr_Enr_Temp_Appr(

Line 71: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

67: -- End of Comments
68: -- ==============================================================================
69:
70: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
71: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
72: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
73:
74: PROCEDURE Create_Ptr_Enr_Temp_Appr(
75: p_api_version_number IN NUMBER,

Line 72: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

68: -- ==============================================================================
69:
70: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
71: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
72: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
73:
74: PROCEDURE Create_Ptr_Enr_Temp_Appr(
75: p_api_version_number IN NUMBER,
76: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

Line 121: FND_MSG_PUB.initialize;

117:
118: -- Initialize message list if p_init_msg_list is set to TRUE.
119: IF FND_API.to_Boolean( p_init_msg_list )
120: THEN
121: FND_MSG_PUB.initialize;
122: END IF;
123:
124:
125:

Line 144: FND_MSG_PUB.Add;

140:
141: IF FND_GLOBAL.USER_ID IS NULL
142: THEN
143: FND_MESSAGE.Set_Name ('PV', 'USER_PROFILE_MISSING');
144: FND_MSG_PUB.Add;
145: RAISE FND_API.G_EXC_ERROR;
146: END IF;
147:
148:

Line 238: FND_MSG_PUB.Count_And_Get

234: END IF;
235:
236:
237: -- Standard call to get message count and if count is 1, get message info.
238: FND_MSG_PUB.Count_And_Get
239: (p_count => x_msg_count,
240: p_data => x_msg_data
241: );
242: EXCEPTION

Line 247: FND_MSG_PUB.Add;

243:
244: WHEN PVX_UTILITY_PVT.resource_locked THEN
245: x_return_status := FND_API.g_ret_sts_error;
246: FND_MESSAGE.Set_Name ('PV', 'PV_API_RESOURCE_LOCKED');
247: FND_MSG_PUB.Add;
248:
249: WHEN FND_API.G_EXC_ERROR THEN
250: ROLLBACK TO CREATE_Ptr_Enr_Temp_Appr_PVT;
251: x_return_status := FND_API.G_RET_STS_ERROR;

Line 253: FND_MSG_PUB.Count_And_Get (

249: WHEN FND_API.G_EXC_ERROR THEN
250: ROLLBACK TO CREATE_Ptr_Enr_Temp_Appr_PVT;
251: x_return_status := FND_API.G_RET_STS_ERROR;
252: -- Standard call to get message count and if count=1, get the message
253: FND_MSG_PUB.Count_And_Get (
254: p_encoded => FND_API.G_FALSE,
255: p_count => x_msg_count,
256: p_data => x_msg_data
257: );

Line 263: FND_MSG_PUB.Count_And_Get (

259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
260: ROLLBACK TO CREATE_Ptr_Enr_Temp_Appr_PVT;
261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
262: -- Standard call to get message count and if count=1, get the message
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: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

268:
269: WHEN OTHERS THEN
270: ROLLBACK TO CREATE_Ptr_Enr_Temp_Appr_PVT;
271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
272: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
273: THEN
274: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
275: END IF;
276: -- Standard call to get message count and if count=1, get the message

Line 274: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

270: ROLLBACK TO CREATE_Ptr_Enr_Temp_Appr_PVT;
271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
272: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
273: THEN
274: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
275: END IF;
276: -- Standard call to get message count and if count=1, get the message
277: FND_MSG_PUB.Count_And_Get (
278: p_encoded => FND_API.G_FALSE,

Line 277: FND_MSG_PUB.Count_And_Get (

273: THEN
274: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
275: END IF;
276: -- Standard call to get message count and if count=1, get the message
277: FND_MSG_PUB.Count_And_Get (
278: p_encoded => FND_API.G_FALSE,
279: p_count => x_msg_count,
280: p_data => x_msg_data
281: );

Line 367: FND_MSG_PUB.initialize;

363:
364: -- Initialize message list if p_init_msg_list is set to TRUE.
365: IF FND_API.to_Boolean( p_init_msg_list )
366: THEN
367: FND_MSG_PUB.initialize;
368: END IF;
369:
370:
371:

Line 403: FND_MSG_PUB.Add;

399: --RAISE FND_API.G_EXC_ERROR;
400:
401: FND_MESSAGE.Set_Name ('PV', 'API_MISSING_UPDATE_TARGET');
402: FND_MESSAGE.Set_Token('INFO', 'Ptr_Enr_Temp_Appr');
403: FND_MSG_PUB.Add;
404: x_return_status := FND_API.G_RET_STS_ERROR;
405: RAISE FND_API.G_EXC_ERROR;
406: END IF;
407:

Line 428: FND_MSG_PUB.Add;

424: --raise FND_API.G_EXC_ERROR;
425:
426: FND_MESSAGE.Set_Name ('PV', 'API_VERSION_MISSING');
427: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date');
428: FND_MSG_PUB.Add;
429: x_return_status := FND_API.G_RET_STS_ERROR;
430: RAISE FND_API.G_EXC_ERROR;
431:
432: End if;

Line 445: FND_MSG_PUB.Add;

441: --raise FND_API.G_EXC_ERROR;
442:
443: FND_MESSAGE.Set_Name ('PV', 'API_RECORD_CHANGED');
444: FND_MESSAGE.Set_Token('INFO', 'Ptr_Enr_Temp_Appr');
445: FND_MSG_PUB.Add;
446: x_return_status := FND_API.G_RET_STS_ERROR;
447: RAISE FND_API.G_EXC_ERROR;
448:
449: End if;

Line 516: FND_MSG_PUB.Count_And_Get

512: END IF;
513:
514:
515: -- Standard call to get message count and if count is 1, get message info.
516: FND_MSG_PUB.Count_And_Get
517: (p_count => x_msg_count,
518: p_data => x_msg_data
519: );
520: EXCEPTION

Line 531: FND_MSG_PUB.Add;

527: FETCH c_get_Ptr_Enr_Temp_Appr INTO l_ref_approver_rec ;
528: If ( c_get_Ptr_Enr_Temp_Appr%NOTFOUND) THEN
529: FND_MESSAGE.Set_Name ('PV', 'API_MISSING_UPDATE_TARGET');
530: FND_MESSAGE.Set_Token('INFO', 'Ptr_Enr_Temp_Appr');
531: FND_MSG_PUB.Add;
532: END IF;
533: -- Debug Message
534: IF (PV_DEBUG_HIGH_ON) THEN
535: Pvx_Utility_Pvt.debug_message('PRIVATE API: - CLOSE CURSOR');

Line 542: FND_MSG_PUB.Add;

538: If (l_tar_approver_rec.object_version_number <> l_ref_approver_rec.object_version_number) THEN
539: x_return_status := Fnd_Api.G_RET_STS_ERROR;
540: FND_MESSAGE.Set_Name ('PV', 'API_RECORD_CHANGED');
541: FND_MESSAGE.Set_Token('INFO', 'Ptr_Enr_Temp_Appr');
542: FND_MSG_PUB.Add;
543: END IF;
544: Fnd_Msg_Pub.Count_And_Get (
545: p_encoded => Fnd_Api.G_FALSE,
546: p_count => x_msg_count,

Line 544: Fnd_Msg_Pub.Count_And_Get (

540: FND_MESSAGE.Set_Name ('PV', 'API_RECORD_CHANGED');
541: FND_MESSAGE.Set_Token('INFO', 'Ptr_Enr_Temp_Appr');
542: FND_MSG_PUB.Add;
543: END IF;
544: Fnd_Msg_Pub.Count_And_Get (
545: p_encoded => Fnd_Api.G_FALSE,
546: p_count => x_msg_count,
547: p_data => x_msg_data
548: );

Line 557: FND_MSG_PUB.Add;

553: --x_return_status := FND_API.g_ret_sts_error;
554: --PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
555:
556: FND_MESSAGE.Set_Name ('PV', 'PV_API_RESOURCE_LOCKED');
557: FND_MSG_PUB.Add;
558: x_return_status := FND_API.G_RET_STS_ERROR;
559:
560: FND_MSG_PUB.Count_And_Get (
561: p_encoded => FND_API.G_FALSE,

Line 560: FND_MSG_PUB.Count_And_Get (

556: FND_MESSAGE.Set_Name ('PV', 'PV_API_RESOURCE_LOCKED');
557: FND_MSG_PUB.Add;
558: x_return_status := FND_API.G_RET_STS_ERROR;
559:
560: FND_MSG_PUB.Count_And_Get (
561: p_encoded => FND_API.G_FALSE,
562: p_count => x_msg_count,
563: p_data => x_msg_data
564: );

Line 571: FND_MSG_PUB.Count_And_Get (

567: WHEN FND_API.G_EXC_ERROR THEN
568: ROLLBACK TO UPDATE_Ptr_Enr_Temp_Appr_PVT;
569: x_return_status := FND_API.G_RET_STS_ERROR;
570: -- Standard call to get message count and if count=1, get the message
571: FND_MSG_PUB.Count_And_Get (
572: p_encoded => FND_API.G_FALSE,
573: p_count => x_msg_count,
574: p_data => x_msg_data
575: );

Line 581: FND_MSG_PUB.Count_And_Get (

577: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
578: ROLLBACK TO UPDATE_Ptr_Enr_Temp_Appr_PVT;
579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
580: -- Standard call to get message count and if count=1, get the message
581: FND_MSG_PUB.Count_And_Get (
582: p_encoded => FND_API.G_FALSE,
583: p_count => x_msg_count,
584: p_data => x_msg_data
585: );

Line 590: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

586:
587: WHEN OTHERS THEN
588: ROLLBACK TO UPDATE_Ptr_Enr_Temp_Appr_PVT;
589: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
590: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
591: THEN
592: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
593: END IF;
594: -- Standard call to get message count and if count=1, get the message

Line 592: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

588: ROLLBACK TO UPDATE_Ptr_Enr_Temp_Appr_PVT;
589: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
590: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
591: THEN
592: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
593: END IF;
594: -- Standard call to get message count and if count=1, get the message
595: FND_MSG_PUB.Count_And_Get (
596: p_encoded => FND_API.G_FALSE,

Line 595: FND_MSG_PUB.Count_And_Get (

591: THEN
592: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
593: END IF;
594: -- Standard call to get message count and if count=1, get the message
595: FND_MSG_PUB.Count_And_Get (
596: p_encoded => FND_API.G_FALSE,
597: p_count => x_msg_count,
598: p_data => x_msg_data
599: );

Line 671: FND_MSG_PUB.initialize;

667:
668: -- Initialize message list if p_init_msg_list is set to TRUE.
669: IF FND_API.to_Boolean( p_init_msg_list )
670: THEN
671: FND_MSG_PUB.initialize;
672: END IF;
673:
674:
675:

Line 719: FND_MSG_PUB.Count_And_Get

715: END IF;
716:
717:
718: -- Standard call to get message count and if count is 1, get message info.
719: FND_MSG_PUB.Count_And_Get
720: (p_count => x_msg_count,
721: p_data => x_msg_data
722: );
723: EXCEPTION

Line 728: FND_MSG_PUB.Add;

724:
725: WHEN PVX_UTILITY_PVT.resource_locked THEN
726: x_return_status := FND_API.g_ret_sts_error;
727: FND_MESSAGE.Set_Name ('PV', 'PV_API_RESOURCE_LOCKED');
728: FND_MSG_PUB.Add;
729:
730: WHEN FND_API.G_EXC_ERROR THEN
731: ROLLBACK TO DELETE_Ptr_Enr_Temp_Appr_PVT;
732: x_return_status := FND_API.G_RET_STS_ERROR;

Line 734: FND_MSG_PUB.Count_And_Get (

730: WHEN FND_API.G_EXC_ERROR THEN
731: ROLLBACK TO DELETE_Ptr_Enr_Temp_Appr_PVT;
732: x_return_status := FND_API.G_RET_STS_ERROR;
733: -- Standard call to get message count and if count=1, get the message
734: FND_MSG_PUB.Count_And_Get (
735: p_encoded => FND_API.G_FALSE,
736: p_count => x_msg_count,
737: p_data => x_msg_data
738: );

Line 744: FND_MSG_PUB.Count_And_Get (

740: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
741: ROLLBACK TO DELETE_Ptr_Enr_Temp_Appr_PVT;
742: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
743: -- Standard call to get message count and if count=1, get the message
744: FND_MSG_PUB.Count_And_Get (
745: p_encoded => FND_API.G_FALSE,
746: p_count => x_msg_count,
747: p_data => x_msg_data
748: );

Line 753: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

749:
750: WHEN OTHERS THEN
751: ROLLBACK TO DELETE_Ptr_Enr_Temp_Appr_PVT;
752: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
753: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
754: THEN
755: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
756: END IF;
757: -- Standard call to get message count and if count=1, get the message

Line 755: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

751: ROLLBACK TO DELETE_Ptr_Enr_Temp_Appr_PVT;
752: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
753: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
754: THEN
755: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
756: END IF;
757: -- Standard call to get message count and if count=1, get the message
758: FND_MSG_PUB.Count_And_Get (
759: p_encoded => FND_API.G_FALSE,

Line 758: FND_MSG_PUB.Count_And_Get (

754: THEN
755: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
756: END IF;
757: -- Standard call to get message count and if count=1, get the message
758: FND_MSG_PUB.Count_And_Get (
759: p_encoded => FND_API.G_FALSE,
760: p_count => x_msg_count,
761: p_data => x_msg_data
762: );

Line 831: FND_MSG_PUB.initialize;

827:
828: -- Initialize message list if p_init_msg_list is set to TRUE.
829: IF FND_API.to_Boolean( p_init_msg_list )
830: THEN
831: FND_MSG_PUB.initialize;
832: END IF;
833:
834:
835:

Line 856: FND_MSG_PUB.count_and_get(

852: Pv_Ge_Temp_Approvers_Pkg.Lock_Row(l_entity_approver_id,p_object_version);
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: IF (PV_DEBUG_HIGH_ON) THEN

Line 869: FND_MSG_PUB.Add;

865:
866: WHEN PVX_UTILITY_PVT.resource_locked THEN
867: x_return_status := FND_API.g_ret_sts_error;
868: FND_MESSAGE.Set_Name ('PV', 'PV_API_RESOURCE_LOCKED');
869: FND_MSG_PUB.Add;
870:
871: WHEN FND_API.G_EXC_ERROR THEN
872: ROLLBACK TO LOCK_Ptr_Enr_Temp_Appr_PVT;
873: x_return_status := FND_API.G_RET_STS_ERROR;

Line 875: FND_MSG_PUB.Count_And_Get (

871: WHEN FND_API.G_EXC_ERROR THEN
872: ROLLBACK TO LOCK_Ptr_Enr_Temp_Appr_PVT;
873: x_return_status := FND_API.G_RET_STS_ERROR;
874: -- Standard call to get message count and if count=1, get the message
875: FND_MSG_PUB.Count_And_Get (
876: p_encoded => FND_API.G_FALSE,
877: p_count => x_msg_count,
878: p_data => x_msg_data
879: );

Line 885: FND_MSG_PUB.Count_And_Get (

881: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
882: ROLLBACK TO LOCK_Ptr_Enr_Temp_Appr_PVT;
883: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
884: -- Standard call to get message count and if count=1, get the message
885: FND_MSG_PUB.Count_And_Get (
886: p_encoded => FND_API.G_FALSE,
887: p_count => x_msg_count,
888: p_data => x_msg_data
889: );

Line 894: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

890:
891: WHEN OTHERS THEN
892: ROLLBACK TO LOCK_Ptr_Enr_Temp_Appr_PVT;
893: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
894: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
895: THEN
896: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
897: END IF;
898: -- Standard call to get message count and if count=1, get the message

Line 896: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

892: ROLLBACK TO LOCK_Ptr_Enr_Temp_Appr_PVT;
893: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
894: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
895: THEN
896: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
897: END IF;
898: -- Standard call to get message count and if count=1, get the message
899: FND_MSG_PUB.Count_And_Get (
900: p_encoded => FND_API.G_FALSE,

Line 899: FND_MSG_PUB.Count_And_Get (

895: THEN
896: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
897: END IF;
898: -- Standard call to get message count and if count=1, get the message
899: FND_MSG_PUB.Count_And_Get (
900: p_encoded => FND_API.G_FALSE,
901: p_count => x_msg_count,
902: p_data => x_msg_data
903: );

Line 929: FND_MSG_PUB.Add;

925: END IF;
926:
927: IF l_valid_flag = FND_API.g_false THEN
928: FND_MESSAGE.Set_Name ('PV', 'PV_entity_approver_id_DUPLICATE');
929: FND_MSG_PUB.Add;
930: x_return_status := FND_API.g_ret_sts_error;
931: END IF;
932:
933: END check_Approver_Uk_Items;

Line 951: FND_MSG_PUB.Add;

947:
948: IF p_approver_rec.arc_appr_for_entity_code = FND_API.g_miss_char OR p_approver_rec.arc_appr_for_entity_code IS NULL THEN
949: FND_MESSAGE.Set_Name ('PV', 'AMS_API_MISSING_FIELD');
950: FND_MESSAGE.Set_Token('MISS_FIELD', 'ARC_APPR_FOR_ENTITY_CODE');
951: FND_MSG_PUB.Add;
952: x_return_status := FND_API.g_ret_sts_error;
953: END IF;
954:
955:

Line 959: FND_MSG_PUB.Add;

955:
956: IF p_approver_rec.appr_for_entity_id = FND_API.G_MISS_NUM OR p_approver_rec.appr_for_entity_id IS NULL THEN
957: FND_MESSAGE.Set_Name ('PV', 'AMS_API_MISSING_FIELD');
958: FND_MESSAGE.Set_Token('MISS_FIELD', 'APPR_FOR_ENTITY_ID');
959: FND_MSG_PUB.Add;
960: x_return_status := FND_API.g_ret_sts_error;
961: END IF;
962:
963:

Line 967: FND_MSG_PUB.Add;

963:
964: IF p_approver_rec.approval_status_code = FND_API.g_miss_char OR p_approver_rec.approval_status_code IS NULL THEN
965: FND_MESSAGE.Set_Name ('PV', 'AMS_API_MISSING_FIELD');
966: FND_MESSAGE.Set_Token('MISS_FIELD', 'APPROVAL_STATUS_CODE');
967: FND_MSG_PUB.Add;
968: x_return_status := FND_API.g_ret_sts_error;
969: END IF;
970:
971:

Line 978: FND_MSG_PUB.Add;

974:
975: IF p_approver_rec.entity_approver_id = FND_API.G_MISS_NUM THEN
976: FND_MESSAGE.Set_Name ('PV', 'AMS_API_MISSING_FIELD');
977: FND_MESSAGE.Set_Token('MISS_FIELD', 'ENTITY_APPROVER_ID');
978: FND_MSG_PUB.Add;
979: x_return_status := FND_API.g_ret_sts_error;
980: END IF;
981:
982:

Line 986: FND_MSG_PUB.Add;

982:
983: IF p_approver_rec.object_version_number = FND_API.G_MISS_NUM THEN
984: FND_MESSAGE.Set_Name ('PV', 'AMS_API_MISSING_FIELD');
985: FND_MESSAGE.Set_Token('MISS_FIELD', 'OBJECT_VERSION_NUMBER');
986: FND_MSG_PUB.Add;
987: x_return_status := FND_API.g_ret_sts_error;
988: END IF;
989:
990:

Line 994: FND_MSG_PUB.Add;

990:
991: IF p_approver_rec.arc_appr_for_entity_code = FND_API.g_miss_char THEN
992: FND_MESSAGE.Set_Name ('PV', 'AMS_API_MISSING_FIELD');
993: FND_MESSAGE.Set_Token('MISS_FIELD', 'ARC_APPR_FOR_ENTITY_CODE');
994: FND_MSG_PUB.Add;
995: x_return_status := FND_API.g_ret_sts_error;
996: END IF;
997:
998:

Line 1002: FND_MSG_PUB.Add;

998:
999: IF p_approver_rec.appr_for_entity_id = FND_API.G_MISS_NUM THEN
1000: FND_MESSAGE.Set_Name ('PV', 'AMS_API_MISSING_FIELD');
1001: FND_MESSAGE.Set_Token('MISS_FIELD', 'APPR_FOR_ENTITY_ID');
1002: FND_MSG_PUB.Add;
1003: x_return_status := FND_API.g_ret_sts_error;
1004: END IF;
1005:
1006:

Line 1010: FND_MSG_PUB.Add;

1006:
1007: IF p_approver_rec.approval_status_code = FND_API.g_miss_char THEN
1008: FND_MESSAGE.Set_Name ('PV', 'AMS_API_MISSING_FIELD');
1009: FND_MESSAGE.Set_Token('MISS_FIELD', 'APPROVAL_STATUS_CODE');
1010: FND_MSG_PUB.Add;
1011: x_return_status := FND_API.g_ret_sts_error;
1012: END IF;
1013: END IF;
1014:

Line 1242: FND_MSG_PUB.initialize;

1238:
1239: -- Initialize message list if p_init_msg_list is set to TRUE.
1240: IF FND_API.to_Boolean( p_init_msg_list )
1241: THEN
1242: FND_MSG_PUB.initialize;
1243: END IF;
1244:
1245:
1246: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

Line 1310: FND_MSG_PUB.Count_And_Get

1306: END IF;
1307:
1308:
1309: -- Standard call to get message count and if count is 1, get message info.
1310: FND_MSG_PUB.Count_And_Get
1311: (p_count => x_msg_count,
1312: p_data => x_msg_data
1313: );
1314: EXCEPTION

Line 1319: FND_MSG_PUB.Add;

1315:
1316: WHEN PVX_UTILITY_PVT.resource_locked THEN
1317: x_return_status := FND_API.g_ret_sts_error;
1318: FND_MESSAGE.Set_Name ('PV', 'PV_API_RESOURCE_LOCKED');
1319: FND_MSG_PUB.Add;
1320:
1321: WHEN FND_API.G_EXC_ERROR THEN
1322: ROLLBACK TO VALIDATE_Ptr_Enr_Temp_Appr_;
1323: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1325: FND_MSG_PUB.Count_And_Get (

1321: WHEN FND_API.G_EXC_ERROR THEN
1322: ROLLBACK TO VALIDATE_Ptr_Enr_Temp_Appr_;
1323: x_return_status := FND_API.G_RET_STS_ERROR;
1324: -- Standard call to get message count and if count=1, get the message
1325: FND_MSG_PUB.Count_And_Get (
1326: p_encoded => FND_API.G_FALSE,
1327: p_count => x_msg_count,
1328: p_data => x_msg_data
1329: );

Line 1335: FND_MSG_PUB.Count_And_Get (

1331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1332: ROLLBACK TO VALIDATE_Ptr_Enr_Temp_Appr_;
1333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1334: -- Standard call to get message count and if count=1, get the message
1335: FND_MSG_PUB.Count_And_Get (
1336: p_encoded => FND_API.G_FALSE,
1337: p_count => x_msg_count,
1338: p_data => x_msg_data
1339: );

Line 1344: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1340:
1341: WHEN OTHERS THEN
1342: ROLLBACK TO VALIDATE_Ptr_Enr_Temp_Appr_;
1343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1344: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1345: THEN
1346: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1347: END IF;
1348: -- Standard call to get message count and if count=1, get the message

Line 1346: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1342: ROLLBACK TO VALIDATE_Ptr_Enr_Temp_Appr_;
1343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1344: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1345: THEN
1346: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1347: END IF;
1348: -- Standard call to get message count and if count=1, get the message
1349: FND_MSG_PUB.Count_And_Get (
1350: p_encoded => FND_API.G_FALSE,

Line 1349: FND_MSG_PUB.Count_And_Get (

1345: THEN
1346: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1347: END IF;
1348: -- Standard call to get message count and if count=1, get the message
1349: FND_MSG_PUB.Count_And_Get (
1350: p_encoded => FND_API.G_FALSE,
1351: p_count => x_msg_count,
1352: p_data => x_msg_data
1353: );

Line 1370: FND_MSG_PUB.initialize;

1366: BEGIN
1367: -- Initialize message list if p_init_msg_list is set to TRUE.
1368: IF FND_API.to_Boolean( p_init_msg_list )
1369: THEN
1370: FND_MSG_PUB.initialize;
1371: END IF;
1372:
1373:
1374:

Line 1389: FND_MSG_PUB.Count_And_Get

1385:
1386: PVX_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1387: END IF;
1388: -- Standard call to get message count and if count is 1, get message info.
1389: FND_MSG_PUB.Count_And_Get
1390: (p_count => x_msg_count,
1391: p_data => x_msg_data
1392: );
1393: END Validate_approver_Rec;