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

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

23: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PV_PRGM_PTR_TYPES_PVT';
24: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pvxvprpb.pls';
25:
26:
27: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
28: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
29: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
30:
31: PROCEDURE Create_Prgm_Ptr_Type(

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

24: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pvxvprpb.pls';
25:
26:
27: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
28: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
29: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
30:
31: PROCEDURE Create_Prgm_Ptr_Type(
32: p_api_version_number IN NUMBER

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

25:
26:
27: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
28: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
29: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
30:
31: PROCEDURE Create_Prgm_Ptr_Type(
32: p_api_version_number IN NUMBER
33: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

Line 73: FND_MSG_PUB.initialize;

69:
70: -- Initialize message list if p_init_msg_list is set to TRUE.
71: IF FND_API.to_Boolean( p_init_msg_list )
72: THEN
73: FND_MSG_PUB.initialize;
74: END IF;
75:
76: -- Standard call to check for call compatibility.
77: IF NOT FND_API.Compatible_API_Call (

Line 101: FND_MSG_PUB.add;

97: --------------- validate -------------------------
98:
99: IF FND_GLOBAL.User_Id IS NULL THEN
100: FND_MESSAGE.set_name('PV', 'PV_API_USER_PROFILE_MISSING');
101: FND_MSG_PUB.add;
102: RAISE FND_API.G_EXC_ERROR;
103: END IF;
104:
105:

Line 196: FND_MSG_PUB.count_and_get(

192: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
193: RAISE FND_API.g_exc_unexpected_error;
194: END IF;
195:
196: FND_MSG_PUB.count_and_get(
197: p_encoded => FND_API.g_false
198: ,p_count => x_msg_count
199: ,p_data => x_msg_data
200: );

Line 219: FND_MSG_PUB.Count_And_Get (

215: WHEN FND_API.G_EXC_ERROR THEN
216: ROLLBACK TO CREATE_PGM_TGT_PTR_TYP_PVT;
217: x_return_status := FND_API.G_RET_STS_ERROR;
218: -- Standard call to get message count and if count=1, get the message
219: FND_MSG_PUB.Count_And_Get (
220: p_encoded => FND_API.G_FALSE
221: ,p_count => x_msg_count
222: ,p_data => x_msg_data
223: );

Line 229: FND_MSG_PUB.Count_And_Get (

225: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
226: ROLLBACK TO CREATE_PGM_TGT_PTR_TYP_PVT;
227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
228: -- Standard call to get message count and if count=1, get the message
229: FND_MSG_PUB.Count_And_Get (
230: p_encoded => FND_API.G_FALSE
231: ,p_count => x_msg_count
232: ,p_data => x_msg_data
233: );

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

234:
235: WHEN OTHERS THEN
236: ROLLBACK TO CREATE_PGM_TGT_PTR_TYP_PVT;
237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
238: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
239: THEN
240: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
241: END IF;
242: -- Standard call to get message count and if count=1, get the message

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

236: ROLLBACK TO CREATE_PGM_TGT_PTR_TYP_PVT;
237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
238: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
239: THEN
240: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
241: END IF;
242: -- Standard call to get message count and if count=1, get the message
243: FND_MSG_PUB.Count_And_Get (
244: p_encoded => FND_API.G_FALSE

Line 243: FND_MSG_PUB.Count_And_Get (

239: THEN
240: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
241: END IF;
242: -- Standard call to get message count and if count=1, get the message
243: FND_MSG_PUB.Count_And_Get (
244: p_encoded => FND_API.G_FALSE
245: ,p_count => x_msg_count
246: ,p_data => x_msg_data
247: );

Line 305: FND_MSG_PUB.initialize;

301:
302: -- Initialize message list if p_init_msg_list is set to TRUE.
303: IF FND_API.to_Boolean( p_init_msg_list )
304: THEN
305: FND_MSG_PUB.initialize;
306: END IF;
307:
308: -- Initialize API return status to SUCCESS
309: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 325: FND_MSG_PUB.add;

321: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
322: FND_MESSAGE.set_token('MODE','Update');
323: FND_MESSAGE.set_token('ENTITY','Pgm_Tgt_Ptr_Typ');
324: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_prgm_ptr_types_rec.program_partner_types_id));
325: FND_MSG_PUB.add;
326: RAISE FND_API.G_EXC_ERROR;
327: END IF;
328:
329: -- Debug Message

Line 342: FND_MSG_PUB.add;

338: l_tar_prgm_ptr_types_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
339:
340: FND_MESSAGE.set_name('PV', 'PV_API_VERSION_MISSING');
341: FND_MESSAGE.set_token('COLUMN','OBJECT_VERSION_NUMBER');
342: FND_MSG_PUB.add;
343: RAISE FND_API.G_EXC_ERROR;
344: End if;
345:
346: -- Check Whether record has been changed by someone else

Line 350: FND_MSG_PUB.add;

346: -- Check Whether record has been changed by someone else
347: If (l_tar_prgm_ptr_types_rec.object_version_number <> l_ref_prgm_ptr_types_rec.object_version_number) Then
348: FND_MESSAGE.set_name('PV', 'PV_API_RECORD_CHANGED');
349: FND_MESSAGE.set_token('VALUE','Pgm_Tgt_Ptr_Typ');
350: FND_MSG_PUB.add;
351: RAISE FND_API.G_EXC_ERROR;
352: End if;
353:
354: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN

Line 409: FND_MSG_PUB.count_and_get(

405: IF FND_API.to_boolean(p_commit) THEN
406: COMMIT;
407: END IF;
408:
409: FND_MSG_PUB.count_and_get(
410: p_encoded => FND_API.g_false
411: ,p_count => x_msg_count
412: ,p_data => x_msg_data
413: );

Line 426: FND_MSG_PUB.Count_And_Get (

422: WHEN FND_API.G_EXC_ERROR THEN
423: ROLLBACK TO UPDATE_PGM_TGT_PTR_TYP_PVT;
424: x_return_status := FND_API.G_RET_STS_ERROR;
425: -- Standard call to get message count and if count=1, get the message
426: FND_MSG_PUB.Count_And_Get (
427: p_encoded => FND_API.G_FALSE
428: ,p_count => x_msg_count
429: ,p_data => x_msg_data
430: );

Line 436: FND_MSG_PUB.Count_And_Get (

432: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
433: ROLLBACK TO UPDATE_PGM_TGT_PTR_TYP_PVT;
434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
435: -- Standard call to get message count and if count=1, get the message
436: FND_MSG_PUB.Count_And_Get (
437: p_encoded => FND_API.G_FALSE
438: ,p_count => x_msg_count
439: ,p_data => x_msg_data
440: );

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

441:
442: WHEN OTHERS THEN
443: ROLLBACK TO UPDATE_PGM_TGT_PTR_TYP_PVT;
444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
445: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
446: THEN
447: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
448: END IF;
449: -- Standard call to get message count and if count=1, get the message

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

443: ROLLBACK TO UPDATE_PGM_TGT_PTR_TYP_PVT;
444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
445: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
446: THEN
447: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
448: END IF;
449: -- Standard call to get message count and if count=1, get the message
450: FND_MSG_PUB.Count_And_Get (
451: p_encoded => FND_API.G_FALSE

Line 450: FND_MSG_PUB.Count_And_Get (

446: THEN
447: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
448: END IF;
449: -- Standard call to get message count and if count=1, get the message
450: FND_MSG_PUB.Count_And_Get (
451: p_encoded => FND_API.G_FALSE
452: ,p_count => x_msg_count
453: ,p_data => x_msg_data
454: );

Line 504: FND_MSG_PUB.initialize;

500:
501: -- Initialize message list if p_init_msg_list is set to TRUE.
502: IF FND_API.to_Boolean( p_init_msg_list )
503: THEN
504: FND_MSG_PUB.initialize;
505: END IF;
506:
507: -- Initialize API return status to SUCCESS
508: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 527: FND_MSG_PUB.count_and_get(

523: IF FND_API.to_boolean(p_commit) THEN
524: COMMIT;
525: END IF;
526:
527: FND_MSG_PUB.count_and_get(
528: p_encoded => FND_API.g_false
529: ,p_count => x_msg_count
530: ,p_data => x_msg_data
531: );

Line 545: FND_MSG_PUB.Count_And_Get (

541: --ROLLBACK TO DELETE_PGM_TGT_PTR_TYP_PVT;
542: ROLLBACK TO DELETE_PGM_TGT_PTR_TYP_PVT;
543: x_return_status := FND_API.G_RET_STS_ERROR;
544: -- Standard call to get message count and if count=1, get the message
545: FND_MSG_PUB.Count_And_Get (
546: p_encoded => FND_API.G_FALSE
547: ,p_count => x_msg_count
548: ,p_data => x_msg_data
549: );

Line 555: FND_MSG_PUB.Count_And_Get (

551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
552: ROLLBACK TO DELETE_PGM_TGT_PTR_TYP_PVT;
553: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
554: -- Standard call to get message count and if count=1, get the message
555: FND_MSG_PUB.Count_And_Get (
556: p_encoded => FND_API.G_FALSE
557: ,p_count => x_msg_count
558: ,p_data => x_msg_data
559: );

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

560:
561: WHEN OTHERS THEN
562: ROLLBACK TO DELETE_PGM_TGT_PTR_TYP_PVT;
563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
564: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
565: THEN
566: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
567: END IF;
568: -- Standard call to get message count and if count=1, get the message

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

562: ROLLBACK TO DELETE_PGM_TGT_PTR_TYP_PVT;
563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
564: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
565: THEN
566: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
567: END IF;
568: -- Standard call to get message count and if count=1, get the message
569: FND_MSG_PUB.Count_And_Get (
570: p_encoded => FND_API.G_FALSE

Line 569: FND_MSG_PUB.Count_And_Get (

565: THEN
566: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
567: END IF;
568: -- Standard call to get message count and if count=1, get the message
569: FND_MSG_PUB.Count_And_Get (
570: p_encoded => FND_API.G_FALSE
571: ,p_count => x_msg_count
572: ,p_data => x_msg_data
573: );

Line 616: FND_MSG_PUB.initialize;

612:
613: -- Initialize message list if p_init_msg_list is set to TRUE.
614: IF FND_API.to_Boolean( p_init_msg_list )
615: THEN
616: FND_MSG_PUB.initialize;
617: END IF;
618:
619: -- Standard call to check for call compatibility.
620: IF NOT FND_API.Compatible_API_Call (

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

638: FETCH c_Pgm_Tgt_Ptr_Typ INTO l_program_partner_types_id;
639:
640: IF (c_Pgm_Tgt_Ptr_Typ%NOTFOUND) THEN
641: CLOSE c_Pgm_Tgt_Ptr_Typ;
642: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
643: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
644: FND_MSG_PUB.add;
645: END IF;
646: RAISE FND_API.g_exc_error;

Line 644: FND_MSG_PUB.add;

640: IF (c_Pgm_Tgt_Ptr_Typ%NOTFOUND) THEN
641: CLOSE c_Pgm_Tgt_Ptr_Typ;
642: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
643: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
644: FND_MSG_PUB.add;
645: END IF;
646: RAISE FND_API.g_exc_error;
647: END IF;
648:

Line 652: FND_MSG_PUB.count_and_get(

648:
649: CLOSE c_Pgm_Tgt_Ptr_Typ;
650:
651: -------------------- finish --------------------------
652: FND_MSG_PUB.count_and_get(
653: p_encoded => FND_API.g_false
654: ,p_count => x_msg_count
655: ,p_data => x_msg_data
656: );

Line 674: FND_MSG_PUB.Count_And_Get (

670: WHEN FND_API.G_EXC_ERROR THEN
671: ROLLBACK TO LOCK_PGM_TGT_PTR_TYP_PVT;
672: x_return_status := FND_API.G_RET_STS_ERROR;
673: -- Standard call to get message count and if count=1, get the message
674: FND_MSG_PUB.Count_And_Get (
675: p_encoded => FND_API.G_FALSE
676: ,p_count => x_msg_count
677: ,p_data => x_msg_data
678: );

Line 684: FND_MSG_PUB.Count_And_Get (

680: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
681: ROLLBACK TO LOCK_Pgm_Tgt_Ptr_Typ_PVT;
682: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
683: -- Standard call to get message count and if count=1, get the message
684: FND_MSG_PUB.Count_And_Get (
685: p_encoded => FND_API.G_FALSE
686: ,p_count => x_msg_count
687: ,p_data => x_msg_data
688: );

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

689:
690: WHEN OTHERS THEN
691: ROLLBACK TO LOCK_PGM_TGT_PTR_TYP_PVT;
692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
693: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
694: THEN
695: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
696: END IF;
697: -- Standard call to get message count and if count=1, get the message

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

691: ROLLBACK TO LOCK_PGM_TGT_PTR_TYP_PVT;
692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
693: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
694: THEN
695: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
696: END IF;
697: -- Standard call to get message count and if count=1, get the message
698: FND_MSG_PUB.Count_And_Get (
699: p_encoded => FND_API.G_FALSE

Line 698: FND_MSG_PUB.Count_And_Get (

694: THEN
695: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
696: END IF;
697: -- Standard call to get message count and if count=1, get the message
698: FND_MSG_PUB.Count_And_Get (
699: p_encoded => FND_API.G_FALSE
700: ,p_count => x_msg_count
701: ,p_data => x_msg_data
702: );

Line 730: FND_MSG_PUB.add;

726: IF l_valid_flag = FND_API.g_false THEN
727: FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
728: FND_MESSAGE.set_token('ID',to_char(p_prgm_ptr_types_rec.PROGRAM_PARTNER_TYPES_ID) );
729: FND_MESSAGE.set_token('ENTITY','Pgm_Tgt_Ptr_Typ');
730: FND_MSG_PUB.add;
731: x_return_status := FND_API.g_ret_sts_error;
732: RETURN;
733: END IF;
734:

Line 750: FND_MSG_PUB.add;

746: IF l_valid_flag = FND_API.g_false THEN
747: FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
748: FND_MESSAGE.set_token('ID',to_char(p_prgm_ptr_types_rec.PROGRAM_TYPE_ID) );
749: FND_MESSAGE.set_token('ENTITY','Pgm_Tgt_Ptr_Typ');
750: FND_MSG_PUB.add;
751: x_return_status := FND_API.g_ret_sts_error;
752: RETURN;
753: END IF;
754: END IF;

Line 778: FND_MSG_PUB.add;

774: IF p_prgm_ptr_types_rec.program_partner_types_id = FND_API.g_miss_num
775: OR p_prgm_ptr_types_rec.program_partner_types_id IS NULL THEN
776: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
777: FND_MESSAGE.set_token('COLUMN','PROGRAM_PARTNER_TYPES_ID');
778: FND_MSG_PUB.add;
779: x_return_status := FND_API.g_ret_sts_error;
780: RETURN;
781: END IF;
782:

Line 788: FND_MSG_PUB.add;

784: IF p_prgm_ptr_types_rec.PROGRAM_TYPE_ID = FND_API.g_miss_num
785: OR p_prgm_ptr_types_rec.PROGRAM_TYPE_ID IS NULL THEN
786: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
787: FND_MESSAGE.set_token('COLUMN','PROGRAM_TYPE_ID');
788: FND_MSG_PUB.add;
789: x_return_status := FND_API.g_ret_sts_error;
790: RETURN;
791: END IF;
792:

Line 798: FND_MSG_PUB.add;

794: IF p_prgm_ptr_types_rec.partner_type = FND_API.g_miss_char
795: OR p_prgm_ptr_types_rec.partner_type IS NULL THEN
796: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
797: FND_MESSAGE.set_token('COLUMN','PARTNER_TYPE');
798: FND_MSG_PUB.add;
799: x_return_status := FND_API.g_ret_sts_error;
800: RETURN;
801: END IF;
802:

Line 808: FND_MSG_PUB.add;

804: IF p_prgm_ptr_types_rec.last_update_date = FND_API.g_miss_date
805: OR p_prgm_ptr_types_rec.last_update_date IS NULL THEN
806: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
807: FND_MESSAGE.set_token('COLUMN','LAST_UPDATE_DATE');
808: FND_MSG_PUB.add;
809: x_return_status := FND_API.g_ret_sts_error;
810: RETURN;
811: END IF;
812:

Line 818: FND_MSG_PUB.add;

814: IF p_prgm_ptr_types_rec.last_updated_by = FND_API.g_miss_num
815: OR p_prgm_ptr_types_rec.last_updated_by IS NULL THEN
816: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
817: FND_MESSAGE.set_token('COLUMN','LAST_UPDATED_BY');
818: FND_MSG_PUB.add;
819: x_return_status := FND_API.g_ret_sts_error;
820: RETURN;
821: END IF;
822:

Line 828: FND_MSG_PUB.add;

824: IF p_prgm_ptr_types_rec.creation_date = FND_API.g_miss_date
825: OR p_prgm_ptr_types_rec.creation_date IS NULL THEN
826: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
827: FND_MESSAGE.set_token('COLUMN','CREATION_DATE');
828: FND_MSG_PUB.add;
829: x_return_status := FND_API.g_ret_sts_error;
830: RETURN;
831: END IF;
832:

Line 839: FND_MSG_PUB.add;

835: OR p_prgm_ptr_types_rec.created_by IS NULL THEN
836:
837: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
838: FND_MESSAGE.set_token('COLUMN','CREATED_BY');
839: FND_MSG_PUB.add;
840: x_return_status := FND_API.g_ret_sts_error;
841: RETURN;
842: END IF;
843:

Line 849: FND_MSG_PUB.add;

845: IF p_prgm_ptr_types_rec.last_update_login = FND_API.g_miss_num
846: OR p_prgm_ptr_types_rec.last_update_login IS NULL THEN
847: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
848: FND_MESSAGE.set_token('COLUMN','LAST_UPDATE_LOGIN');
849: FND_MSG_PUB.add;
850: x_return_status := FND_API.g_ret_sts_error;
851: RETURN;
852: END IF;
853:

Line 859: FND_MSG_PUB.add;

855: IF p_prgm_ptr_types_rec.object_version_number = FND_API.g_miss_num
856: OR p_prgm_ptr_types_rec.object_version_number IS NULL THEN
857: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
858: FND_MESSAGE.set_token('COLUMN','OBJECT_VERSION_NUMBER');
859: FND_MSG_PUB.add;
860: x_return_status := FND_API.g_ret_sts_error;
861: RETURN;
862: END IF;
863: ELSE

Line 869: FND_MSG_PUB.add;

865:
866: IF p_prgm_ptr_types_rec.program_partner_types_id IS NULL THEN
867: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
868: FND_MESSAGE.set_token('COLUMN','PROGRAM_PARTNER_TYPES_ID');
869: FND_MSG_PUB.add;
870: x_return_status := FND_API.g_ret_sts_error;
871: RETURN;
872: END IF;
873:

Line 878: FND_MSG_PUB.add;

874:
875: IF p_prgm_ptr_types_rec.object_version_number IS NULL THEN
876: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
877: FND_MESSAGE.set_token('COLUMN','OBJECT_VERSION_NUMBER');
878: FND_MSG_PUB.add;
879: x_return_status := FND_API.g_ret_sts_error;
880: RETURN;
881: END IF;
882: END IF;

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

910: PVX_utility_PVT.g_number, -- datatype of fk
911: NULL
912: ) = FND_API.g_false
913: THEN
914: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
915: THEN
916: FND_MESSAGE.set_name('PV', 'PV_NOT_A_VALID_PRGM_PTR_TYPE');
917: FND_MSG_PUB.add;
918: END IF;

Line 917: FND_MSG_PUB.add;

913: THEN
914: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
915: THEN
916: FND_MESSAGE.set_name('PV', 'PV_NOT_A_VALID_PRGM_PTR_TYPE');
917: FND_MSG_PUB.add;
918: END IF;
919:
920: x_return_status := FND_API.g_ret_sts_error;
921: RETURN;

Line 1182: FND_MSG_PUB.initialize;

1178: END IF;
1179:
1180: -- Initialize message list if p_init_msg_list is set to TRUE.
1181: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1182: FND_MSG_PUB.initialize;
1183: END IF;
1184:
1185: -- Debug Message
1186: IF (PV_DEBUG_HIGH_ON) THEN

Line 1242: FND_MSG_PUB.Count_And_Get

1238: PVX_UTILITY_PVT.debug_message('Private API: ' || l_full_name || ' - end');
1239: END IF;
1240:
1241: -- Standard call to get message count and if count is 1, get message info.
1242: FND_MSG_PUB.Count_And_Get
1243: ( p_encoded => FND_API.G_FALSE,
1244: p_count => x_msg_count,
1245: p_data => x_msg_data
1246: );

Line 1254: FND_MSG_PUB.Count_And_Get (

1250: WHEN FND_API.G_EXC_ERROR THEN
1251: ROLLBACK TO VALIDATE_PGM_TGT_PTR_TYP_PVT;
1252: x_return_status := FND_API.G_RET_STS_ERROR;
1253: -- Standard call to get message count and if count=1, get the message
1254: FND_MSG_PUB.Count_And_Get (
1255: p_encoded => FND_API.G_FALSE
1256: ,p_count => x_msg_count
1257: ,p_data => x_msg_data
1258: );

Line 1264: FND_MSG_PUB.Count_And_Get (

1260: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1261: ROLLBACK TO VALIDATE_PGM_TGT_PTR_TYP_PVT;
1262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1263: -- Standard call to get message count and if count=1, get the message
1264: FND_MSG_PUB.Count_And_Get (
1265: p_encoded => FND_API.G_FALSE
1266: ,p_count => x_msg_count
1267: ,p_data => x_msg_data
1268: );

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

1269:
1270: WHEN OTHERS THEN
1271: ROLLBACK TO VALIDATE_PGM_TGT_PTR_TYP_PVT;
1272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1273: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1274: THEN
1275: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1276: END IF;
1277: -- Standard call to get message count and if count=1, get the message

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

1271: ROLLBACK TO VALIDATE_PGM_TGT_PTR_TYP_PVT;
1272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1273: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1274: THEN
1275: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1276: END IF;
1277: -- Standard call to get message count and if count=1, get the message
1278: FND_MSG_PUB.Count_And_Get (
1279: p_encoded => FND_API.G_FALSE

Line 1278: FND_MSG_PUB.Count_And_Get (

1274: THEN
1275: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1276: END IF;
1277: -- Standard call to get message count and if count=1, get the message
1278: FND_MSG_PUB.Count_And_Get (
1279: p_encoded => FND_API.G_FALSE
1280: ,p_count => x_msg_count
1281: ,p_data => x_msg_data
1282: );

Line 1304: FND_MSG_PUB.initialize;

1300:
1301: -- Initialize message list if p_init_msg_list is set to TRUE.
1302: IF FND_API.to_Boolean( p_init_msg_list )
1303: THEN
1304: FND_MSG_PUB.initialize;
1305: END IF;
1306:
1307: -- Initialize API return status to SUCCESS
1308: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1321: FND_MSG_PUB.Count_And_Get

1317:
1318: PVX_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1319: END IF;
1320: -- Standard call to get message count and if count is 1, get message info.
1321: FND_MSG_PUB.Count_And_Get
1322: ( p_count => x_msg_count
1323: ,p_data => x_msg_data
1324: );
1325: END Validate_Rec;