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

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

43: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PV_PRGM_CONTRACTS_PVT';
44: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pvxvppcb.pls';
45:
46:
47: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
48: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
49: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
50:
51: PROCEDURE Create_Prgm_Contracts(

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

44: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pvxvppcb.pls';
45:
46:
47: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
48: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
49: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
50:
51: PROCEDURE Create_Prgm_Contracts(
52: p_api_version_number IN NUMBER

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

45:
46:
47: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
48: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
49: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
50:
51: PROCEDURE Create_Prgm_Contracts(
52: p_api_version_number IN NUMBER
53: ,p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE

Line 96: FND_MSG_PUB.initialize;

92:
93: -- Initialize message list if p_init_msg_list is set to TRUE.
94: IF FND_API.to_Boolean( p_init_msg_list )
95: THEN
96: FND_MSG_PUB.initialize;
97: END IF;
98:
99: -- Standard call to check for call compatibility.
100: IF NOT FND_API.Compatible_API_Call (

Line 132: FND_MSG_PUB.add;

128: END IF;
129:
130: IF FND_GLOBAL.User_Id IS NULL THEN
131: FND_MESSAGE.set_name('PV', 'PV_API_USER_PROFILE_MISSING');
132: FND_MSG_PUB.add;
133: RAISE FND_API.G_EXC_ERROR;
134: END IF;
135:
136:

Line 234: FND_MSG_PUB.count_and_get(

230: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
231: RAISE FND_API.g_exc_unexpected_error;
232: END IF;
233:
234: FND_MSG_PUB.count_and_get(
235: p_encoded => FND_API.g_false
236: ,p_count => x_msg_count
237: ,p_data => x_msg_data
238: );

Line 257: Fnd_Msg_Pub.Count_And_Get (

253: WHEN FND_API.G_EXC_ERROR THEN
254: ROLLBACK TO CREATE_PRGM_CONTRACTS_PVT;
255: x_return_status := Fnd_Api.G_RET_STS_ERROR;
256: -- Standard call to get message count and if count=1, get the message
257: Fnd_Msg_Pub.Count_And_Get (
258: p_encoded => Fnd_Api.G_FALSE
259: ,p_count => x_msg_count
260: ,p_data => x_msg_data
261: );

Line 267: Fnd_Msg_Pub.Count_And_Get (

263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
264: ROLLBACK TO CREATE_PRGM_CONTRACTS_PVT;
265: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
266: -- Standard call to get message count and if count=1, get the message
267: Fnd_Msg_Pub.Count_And_Get (
268: p_encoded => Fnd_Api.G_FALSE
269: ,p_count => x_msg_count
270: ,p_data => x_msg_data
271: );

Line 276: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)

272:
273: WHEN OTHERS THEN
274: ROLLBACK TO CREATE_PRGM_CONTRACTS_PVT;
275: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
276: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
277: THEN
278: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
279: END IF;
280: -- Standard call to get message count and if count=1, get the message

Line 278: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

274: ROLLBACK TO CREATE_PRGM_CONTRACTS_PVT;
275: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
276: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
277: THEN
278: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
279: END IF;
280: -- Standard call to get message count and if count=1, get the message
281: Fnd_Msg_Pub.Count_And_Get (
282: p_encoded => Fnd_Api.G_FALSE

Line 281: Fnd_Msg_Pub.Count_And_Get (

277: THEN
278: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
279: END IF;
280: -- Standard call to get message count and if count=1, get the message
281: Fnd_Msg_Pub.Count_And_Get (
282: p_encoded => Fnd_Api.G_FALSE
283: ,p_count => x_msg_count
284: ,p_data => x_msg_data
285: );

Line 338: FND_MSG_PUB.initialize;

334:
335: -- Initialize message list if p_init_msg_list is set to TRUE.
336: IF FND_API.to_Boolean( p_init_msg_list )
337: THEN
338: FND_MSG_PUB.initialize;
339: END IF;
340:
341: -- Initialize API return status to SUCCESS
342: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 352: FND_MSG_PUB.ADD;

348: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
349: FND_MESSAGE.set_token('MODE','Update');
350: FND_MESSAGE.set_token('ENTITY','Program_Contracts');
351: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_prgm_contracts_rec.program_contracts_id));
352: FND_MSG_PUB.ADD;
353: RAISE FND_API.G_EXC_ERROR;
354: END IF;
355:
356: -- Debug Message

Line 368: FND_MSG_PUB.add;

364: l_tar_prgm_contracts_rec.object_version_number = Fnd_Api.G_MISS_NUM ) THEN
365:
366: FND_MESSAGE.set_name('PV', 'PV_API_VERSION_MISSING');
367: FND_MESSAGE.set_token('COLUMN','OBJECT_VERSION_NUMBER');
368: FND_MSG_PUB.add;
369: RAISE FND_API.G_EXC_ERROR;
370: END IF;
371:
372: -- Check Whether record has been changed by someone else

Line 376: FND_MSG_PUB.ADD;

372: -- Check Whether record has been changed by someone else
373: IF (l_tar_prgm_contracts_rec.object_version_number <> l_ref_prgm_contracts_rec.object_version_number) THEN
374: FND_MESSAGE.set_name('PV', 'PV_API_RECORD_CHANGED');
375: FND_MESSAGE.set_token('VALUE','PROGRAM_CONTRACTS');
376: FND_MSG_PUB.ADD;
377: RAISE FND_API.G_EXC_ERROR;
378: END IF;
379:
380: IF ( p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN

Line 442: FND_MSG_PUB.count_and_get(

438: IF FND_API.to_boolean(p_commit) THEN
439: COMMIT;
440: END IF;
441:
442: FND_MSG_PUB.count_and_get(
443: p_encoded => FND_API.g_false
444: ,p_count => x_msg_count
445: ,p_data => x_msg_data
446: );

Line 454: Fnd_Msg_Pub.Count_And_Get (

450: WHEN Fnd_Api.G_EXC_ERROR THEN
451: ROLLBACK TO UPDATE_Prgm_Contracts_PVT;
452: x_return_status := Fnd_Api.G_RET_STS_ERROR;
453: -- Standard call to get message count and if count=1, get the message
454: Fnd_Msg_Pub.Count_And_Get (
455: p_encoded => Fnd_Api.G_FALSE
456: ,p_count => x_msg_count
457: ,p_data => x_msg_data
458: );

Line 464: Fnd_Msg_Pub.Count_And_Get (

460: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
461: ROLLBACK TO UPDATE_Prgm_Contracts_PVT;
462: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
463: -- Standard call to get message count and if count=1, get the message
464: Fnd_Msg_Pub.Count_And_Get (
465: p_encoded => Fnd_Api.G_FALSE
466: ,p_count => x_msg_count
467: ,p_data => x_msg_data
468: );

Line 473: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)

469:
470: WHEN OTHERS THEN
471: ROLLBACK TO UPDATE_Prgm_Contracts_PVT;
472: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
473: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
474: THEN
475: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
476: END IF;
477: -- Standard call to get message count and if count=1, get the message

Line 475: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

471: ROLLBACK TO UPDATE_Prgm_Contracts_PVT;
472: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
473: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
474: THEN
475: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
476: END IF;
477: -- Standard call to get message count and if count=1, get the message
478: Fnd_Msg_Pub.Count_And_Get (
479: p_encoded => Fnd_Api.G_FALSE

Line 478: Fnd_Msg_Pub.Count_And_Get (

474: THEN
475: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
476: END IF;
477: -- Standard call to get message count and if count=1, get the message
478: Fnd_Msg_Pub.Count_And_Get (
479: p_encoded => Fnd_Api.G_FALSE
480: ,p_count => x_msg_count
481: ,p_data => x_msg_data
482: );

Line 531: FND_MSG_PUB.initialize;

527:
528: -- Initialize message list if p_init_msg_list is set to TRUE.
529: IF FND_API.to_Boolean( p_init_msg_list )
530: THEN
531: FND_MSG_PUB.initialize;
532: END IF;
533:
534: -- Initialize API return status to SUCCESS
535: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 554: FND_MSG_PUB.count_and_get(

550: IF FND_API.to_boolean(p_commit) THEN
551: COMMIT;
552: END IF;
553:
554: FND_MSG_PUB.count_and_get(
555: p_encoded => FND_API.g_false
556: ,p_count => x_msg_count
557: ,p_data => x_msg_data
558: );

Line 571: Fnd_Msg_Pub.Count_And_Get (

567: WHEN Fnd_Api.G_EXC_ERROR THEN
568: ROLLBACK TO DELETE_Prgm_Contracts_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 DELETE_Prgm_Contracts_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 DELETE_Prgm_Contracts_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 DELETE_Prgm_Contracts_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 640: Fnd_Msg_Pub.initialize;

636:
637: -- Initialize message list if p_init_msg_list is set to TRUE.
638: IF Fnd_Api.to_Boolean( p_init_msg_list )
639: THEN
640: Fnd_Msg_Pub.initialize;
641: END IF;
642:
643: -- Standard call to check for call compatibility.
644: IF NOT Fnd_Api.Compatible_API_Call (

Line 674: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN

670: FETCH c_Prgm_Contracts INTO l_program_contracts_id;
671:
672: IF (c_Prgm_Contracts%NOTFOUND) THEN
673: CLOSE c_Prgm_Contracts;
674: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
675: Fnd_Message.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
676: Fnd_Msg_Pub.ADD;
677: END IF;
678: RAISE Fnd_Api.g_exc_error;

Line 676: Fnd_Msg_Pub.ADD;

672: IF (c_Prgm_Contracts%NOTFOUND) THEN
673: CLOSE c_Prgm_Contracts;
674: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
675: Fnd_Message.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
676: Fnd_Msg_Pub.ADD;
677: END IF;
678: RAISE Fnd_Api.g_exc_error;
679: END IF;
680:

Line 684: Fnd_Msg_Pub.count_and_get(

680:
681: CLOSE c_Prgm_Contracts;
682:
683: -------------------- finish --------------------------
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 706: Fnd_Msg_Pub.Count_And_Get (

702: WHEN Fnd_Api.G_EXC_ERROR THEN
703: ROLLBACK TO LOCK_Prgm_Contracts_PVT;
704: x_return_status := Fnd_Api.G_RET_STS_ERROR;
705: -- Standard call to get message count and if count=1, get the message
706: Fnd_Msg_Pub.Count_And_Get (
707: p_encoded => Fnd_Api.G_FALSE
708: ,p_count => x_msg_count
709: ,p_data => x_msg_data
710: );

Line 716: Fnd_Msg_Pub.Count_And_Get (

712: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
713: ROLLBACK TO LOCK_Prgm_Contracts_PVT;
714: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
715: -- Standard call to get message count and if count=1, get the message
716: Fnd_Msg_Pub.Count_And_Get (
717: p_encoded => Fnd_Api.G_FALSE
718: ,p_count => x_msg_count
719: ,p_data => x_msg_data
720: );

Line 725: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)

721:
722: WHEN OTHERS THEN
723: ROLLBACK TO LOCK_Prgm_Contracts_PVT;
724: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
725: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
726: THEN
727: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
728: END IF;
729: -- Standard call to get message count and if count=1, get the message

Line 727: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

723: ROLLBACK TO LOCK_Prgm_Contracts_PVT;
724: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
725: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
726: THEN
727: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
728: END IF;
729: -- Standard call to get message count and if count=1, get the message
730: Fnd_Msg_Pub.Count_And_Get (
731: p_encoded => Fnd_Api.G_FALSE

Line 730: Fnd_Msg_Pub.Count_And_Get (

726: THEN
727: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
728: END IF;
729: -- Standard call to get message count and if count=1, get the message
730: Fnd_Msg_Pub.Count_And_Get (
731: p_encoded => Fnd_Api.G_FALSE
732: ,p_count => x_msg_count
733: ,p_data => x_msg_data
734: );

Line 781: FND_MSG_PUB.ADD;

777: IF l_valid_flag = Fnd_Api.g_false THEN
778: FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
779: FND_MESSAGE.set_token('ID',TO_CHAR(p_prgm_contracts_rec.program_contracts_id) );
780: FND_MESSAGE.set_token('ENTITY','Program_Contracts');
781: FND_MSG_PUB.ADD;
782: x_return_status := Fnd_Api.g_ret_sts_error;
783: RETURN;
784: END IF;
785: END IF;

Line 812: FND_MSG_PUB.ADD;

808: FETCH c_geo_area_name into l_geo_area_name;
809: FND_MESSAGE.set_token('ID', l_geo_area_name);
810:
811: FND_MESSAGE.set_token('ENTITY','Program Contracts');
812: FND_MSG_PUB.ADD;
813: x_return_status := Fnd_Api.g_ret_sts_error;
814: RETURN;
815: END IF;
816: END IF;

Line 830: FND_MSG_PUB.ADD;

826: FETCH c_geo_area_name into l_geo_area_name;
827: FND_MESSAGE.set_token('ID', l_geo_area_name);
828:
829: FND_MESSAGE.set_token('ENTITY','Program_Contracts');
830: FND_MSG_PUB.ADD;
831: x_return_status := Fnd_Api.g_ret_sts_error;
832: RETURN;
833: END IF;
834: END IF;

Line 858: FND_MSG_PUB.add;

854: IF p_prgm_contracts_rec.program_contracts_id = Fnd_Api.g_miss_num
855: OR p_prgm_contracts_rec.program_contracts_id IS NULL THEN
856: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
857: Fnd_Message.set_token('COLUMN','PROGRAM_CONTRACTS_ID');
858: FND_MSG_PUB.add;
859: x_return_status := FND_API.g_ret_sts_error;
860: RETURN;
861: END IF;
862:

Line 868: FND_MSG_PUB.add;

864: IF p_prgm_contracts_rec.program_id = Fnd_Api.g_miss_num
865: OR p_prgm_contracts_rec.program_id IS NULL THEN
866: Fnd_Message.set_name('PV','PV_API_MISSING_REQ_COLUMN');
867: Fnd_Message.set_token('COLUMN','PROGRAM_ID');
868: FND_MSG_PUB.add;
869: x_return_status := FND_API.g_ret_sts_error;
870: RETURN;
871: END IF;
872:

Line 878: FND_MSG_PUB.add;

874: IF p_prgm_contracts_rec.geo_hierarchy_id = Fnd_Api.g_miss_num
875: OR p_prgm_contracts_rec.geo_hierarchy_id IS NULL THEN
876: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
877: Fnd_Message.set_token('COLUMN','GEO_HIERARCHY_ID');
878: FND_MSG_PUB.add;
879: x_return_status := FND_API.g_ret_sts_error;
880: RETURN;
881: END IF;
882:

Line 888: FND_MSG_PUB.add;

884: IF p_prgm_contracts_rec.contract_id = Fnd_Api.g_miss_num
885: OR p_prgm_contracts_rec.contract_id IS NULL THEN
886: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
887: Fnd_Message.set_token('COLUMN','CONTRACT_ID');
888: FND_MSG_PUB.add;
889: x_return_status := FND_API.g_ret_sts_error;
890: RETURN;
891: END IF;
892:

Line 898: FND_MSG_PUB.add;

894: IF p_prgm_contracts_rec.last_update_date = Fnd_Api.g_miss_date
895: OR p_prgm_contracts_rec.last_update_date IS NULL THEN
896: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
897: Fnd_Message.set_token('COLUMN','LAST_UPDATE_DATE');
898: FND_MSG_PUB.add;
899: x_return_status := FND_API.g_ret_sts_error;
900: RETURN;
901: END IF;
902:

Line 908: FND_MSG_PUB.add;

904: IF p_prgm_contracts_rec.last_updated_by = Fnd_Api.g_miss_num
905: OR p_prgm_contracts_rec.last_updated_by IS NULL THEN
906: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
907: Fnd_Message.set_token('COLUMN','LAST_UPDATED_BY');
908: FND_MSG_PUB.add;
909: x_return_status := FND_API.g_ret_sts_error;
910: RETURN;
911: END IF;
912:

Line 918: FND_MSG_PUB.add;

914: IF p_prgm_contracts_rec.creation_date = Fnd_Api.g_miss_date
915: OR p_prgm_contracts_rec.creation_date IS NULL THEN
916: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
917: Fnd_Message.set_token('COLUMN','CREATION_DATE');
918: FND_MSG_PUB.add;
919: x_return_status := FND_API.g_ret_sts_error;
920: RETURN;
921: END IF;
922:

Line 928: FND_MSG_PUB.add;

924: IF p_prgm_contracts_rec.created_by = Fnd_Api.g_miss_num
925: OR p_prgm_contracts_rec.created_by IS NULL THEN
926: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
927: Fnd_Message.set_token('COLUMN','CREATED_BY');
928: FND_MSG_PUB.add;
929: x_return_status := FND_API.g_ret_sts_error;
930: RETURN;
931: END IF;
932:

Line 938: FND_MSG_PUB.add;

934: IF p_prgm_contracts_rec.last_update_login = Fnd_Api.g_miss_num
935: OR p_prgm_contracts_rec.last_update_login IS NULL THEN
936: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
937: Fnd_Message.set_token('COLUMN','LAST_UPDATE_LOGIN');
938: FND_MSG_PUB.add;
939: x_return_status := FND_API.g_ret_sts_error;
940: RETURN;
941: END IF;
942:

Line 948: FND_MSG_PUB.add;

944: IF p_prgm_contracts_rec.object_version_number = Fnd_Api.g_miss_num
945: OR p_prgm_contracts_rec.object_version_number IS NULL THEN
946: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
947: Fnd_Message.set_token('COLUMN','OBJECT_VERSION_NUMBER');
948: FND_MSG_PUB.add;
949: x_return_status := FND_API.g_ret_sts_error;
950: RETURN;
951: END IF;
952:

Line 957: FND_MSG_PUB.add;

953: IF p_prgm_contracts_rec.member_type_code = Fnd_Api.g_miss_char
954: OR p_prgm_contracts_rec.member_type_code IS NULL THEN
955: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
956: Fnd_Message.set_token('COLUMN','MEMBER_TYPE_CODE');
957: FND_MSG_PUB.add;
958: x_return_status := FND_API.g_ret_sts_error;
959: RETURN;
960: END IF;
961:

Line 968: FND_MSG_PUB.add;

964:
965: IF p_prgm_contracts_rec.program_contracts_id IS NULL THEN
966: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
967: Fnd_Message.set_token('COLUMN','PROGRAM_CONTRACTS_ID');
968: FND_MSG_PUB.add;
969: x_return_status := FND_API.g_ret_sts_error;
970: RETURN;
971: END IF;
972:

Line 977: Fnd_Msg_Pub.ADD;

973:
974: IF p_prgm_contracts_rec.object_version_number IS NULL THEN
975: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
976: Fnd_Message.set_token('COLUMN','object_version_number');
977: Fnd_Msg_Pub.ADD;
978: x_return_status := Fnd_Api.g_ret_sts_error;
979: RETURN;
980: END IF;
981: END IF;

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

1011: PVX_UTILITY_PVT.g_number, -- datatype of fk
1012: NULL
1013: ) = FND_API.g_false
1014: THEN
1015: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1016: THEN
1017: FND_MESSAGE.set_name('PV', 'PV_NOT_A_VALID_PARTNER_PROGRAM');
1018: FND_MSG_PUB.add;
1019: END IF;

Line 1018: FND_MSG_PUB.add;

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

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

1048: PVX_UTILITY_PVT.g_number, -- datatype of fk
1049: NULL
1050: ) = FND_API.g_false
1051: THEN
1052: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1053: THEN
1054: FND_MESSAGE.set_name('PV', 'PV_NOT_A_GEO_HIERARCHY');
1055: FND_MSG_PUB.add;
1056: END IF;

Line 1055: FND_MSG_PUB.add;

1051: THEN
1052: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1053: THEN
1054: FND_MESSAGE.set_name('PV', 'PV_NOT_A_GEO_HIERARCHY');
1055: FND_MSG_PUB.add;
1056: END IF;
1057:
1058: x_return_status := FND_API.g_ret_sts_error;
1059: RETURN;

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

1077: PVX_UTILITY_PVT.g_number, -- datatype of fk
1078: NULL
1079: ) = FND_API.g_false
1080: THEN
1081: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1082: THEN
1083: FND_MESSAGE.set_name('PV', 'PV_NOT_A_VALID_CONTRACT');
1084: FND_MSG_PUB.add;
1085: END IF;

Line 1084: FND_MSG_PUB.add;

1080: THEN
1081: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1082: THEN
1083: FND_MESSAGE.set_name('PV', 'PV_NOT_A_VALID_CONTRACT');
1084: FND_MSG_PUB.add;
1085: END IF;
1086:
1087: x_return_status := FND_API.g_ret_sts_error;
1088: RETURN;

Line 1347: FND_MSG_PUB.initialize;

1343: END IF;
1344:
1345: -- Initialize message list if p_init_msg_list is set to TRUE.
1346: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1347: FND_MSG_PUB.initialize;
1348: END IF;
1349:
1350: -- Debug Message
1351: IF (PV_DEBUG_HIGH_ON) THEN

Line 1407: FND_MSG_PUB.Count_And_Get

1403: PVX_UTILITY_PVT.debug_message('Private API: ' || l_full_name || ' - end');
1404: END IF;
1405:
1406: -- Standard call to get message count and if count is 1, get message info.
1407: FND_MSG_PUB.Count_And_Get
1408: ( p_encoded => FND_API.G_FALSE,
1409: p_count => x_msg_count,
1410: p_data => x_msg_data
1411: );

Line 1420: Fnd_Msg_Pub.Count_And_Get (

1416: ROLLBACK TO VALIDATE_Prgm_Contracts_;
1417: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1418:
1419: -- Standard call to get message count and if count=1, get the message
1420: Fnd_Msg_Pub.Count_And_Get (
1421: p_encoded => Fnd_Api.G_FALSE
1422: ,p_count => x_msg_count
1423: ,p_data => x_msg_data
1424: );

Line 1430: Fnd_Msg_Pub.Count_And_Get (

1426: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1427: ROLLBACK TO VALIDATE_Prgm_Contracts_;
1428: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1429: -- Standard call to get message count and if count=1, get the message
1430: Fnd_Msg_Pub.Count_And_Get (
1431: p_encoded => Fnd_Api.G_FALSE
1432: ,p_count => x_msg_count
1433: ,p_data => x_msg_data
1434: );

Line 1439: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)

1435:
1436: WHEN OTHERS THEN
1437: ROLLBACK TO VALIDATE_Prgm_Contracts_;
1438: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1439: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
1440: THEN
1441: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1442: END IF;
1443: -- Standard call to get message count and if count=1, get the message

Line 1441: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1437: ROLLBACK TO VALIDATE_Prgm_Contracts_;
1438: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1439: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
1440: THEN
1441: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1442: END IF;
1443: -- Standard call to get message count and if count=1, get the message
1444: Fnd_Msg_Pub.Count_And_Get (
1445: p_encoded => Fnd_Api.G_FALSE

Line 1444: Fnd_Msg_Pub.Count_And_Get (

1440: THEN
1441: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1442: END IF;
1443: -- Standard call to get message count and if count=1, get the message
1444: Fnd_Msg_Pub.Count_And_Get (
1445: p_encoded => Fnd_Api.G_FALSE
1446: ,p_count => x_msg_count
1447: ,p_data => x_msg_data
1448: );

Line 1469: Fnd_Msg_Pub.initialize;

1465: BEGIN
1466: -- Initialize message list if p_init_msg_list is set to TRUE.
1467: IF Fnd_Api.to_Boolean( p_init_msg_list )
1468: THEN
1469: Fnd_Msg_Pub.initialize;
1470: END IF;
1471:
1472: -- Initialize API return status to SUCCESS
1473: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

Line 1487: Fnd_Msg_Pub.Count_And_Get(

1483: Pvx_Utility_Pvt.debug_message('Private API: Validate_dm_model_rec');
1484: END IF;
1485:
1486: -- Standard call to get message count and if count is 1, get message info.
1487: Fnd_Msg_Pub.Count_And_Get(
1488: p_count => x_msg_count
1489: ,p_data => x_msg_data
1490: );
1491: