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

Line 50: PV_DEBUG_HIGH_ON CONSTANT BOOLEAN := Fnd_Msg_Pub.CHECK_MSG_LEVEL(Fnd_Msg_Pub.G_MSG_LVL_DEBUG_HIGH);

46: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pvxvpurb.pls';
47:
48: G_APP_ID CONSTANT NUMBER := 691;
49:
50: PV_DEBUG_HIGH_ON CONSTANT BOOLEAN := Fnd_Msg_Pub.CHECK_MSG_LEVEL(Fnd_Msg_Pub.G_MSG_LVL_DEBUG_HIGH);
51: PV_DEBUG_LOW_ON CONSTANT BOOLEAN := Fnd_Msg_Pub.CHECK_MSG_LEVEL(Fnd_Msg_Pub.G_MSG_LVL_DEBUG_LOW);
52: PV_DEBUG_MEDIUM_ON CONSTANT BOOLEAN := Fnd_Msg_Pub.CHECK_MSG_LEVEL(Fnd_Msg_Pub.G_MSG_LVL_DEBUG_MEDIUM);
53: g_log_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
54: g_log_to_file VARCHAR2(5) := 'N';

Line 51: PV_DEBUG_LOW_ON CONSTANT BOOLEAN := Fnd_Msg_Pub.CHECK_MSG_LEVEL(Fnd_Msg_Pub.G_MSG_LVL_DEBUG_LOW);

47:
48: G_APP_ID CONSTANT NUMBER := 691;
49:
50: PV_DEBUG_HIGH_ON CONSTANT BOOLEAN := Fnd_Msg_Pub.CHECK_MSG_LEVEL(Fnd_Msg_Pub.G_MSG_LVL_DEBUG_HIGH);
51: PV_DEBUG_LOW_ON CONSTANT BOOLEAN := Fnd_Msg_Pub.CHECK_MSG_LEVEL(Fnd_Msg_Pub.G_MSG_LVL_DEBUG_LOW);
52: PV_DEBUG_MEDIUM_ON CONSTANT BOOLEAN := Fnd_Msg_Pub.CHECK_MSG_LEVEL(Fnd_Msg_Pub.G_MSG_LVL_DEBUG_MEDIUM);
53: g_log_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
54: g_log_to_file VARCHAR2(5) := 'N';
55:

Line 52: PV_DEBUG_MEDIUM_ON CONSTANT BOOLEAN := Fnd_Msg_Pub.CHECK_MSG_LEVEL(Fnd_Msg_Pub.G_MSG_LVL_DEBUG_MEDIUM);

48: G_APP_ID CONSTANT NUMBER := 691;
49:
50: PV_DEBUG_HIGH_ON CONSTANT BOOLEAN := Fnd_Msg_Pub.CHECK_MSG_LEVEL(Fnd_Msg_Pub.G_MSG_LVL_DEBUG_HIGH);
51: PV_DEBUG_LOW_ON CONSTANT BOOLEAN := Fnd_Msg_Pub.CHECK_MSG_LEVEL(Fnd_Msg_Pub.G_MSG_LVL_DEBUG_LOW);
52: PV_DEBUG_MEDIUM_ON CONSTANT BOOLEAN := Fnd_Msg_Pub.CHECK_MSG_LEVEL(Fnd_Msg_Pub.G_MSG_LVL_DEBUG_MEDIUM);
53: g_log_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
54: g_log_to_file VARCHAR2(5) := 'N';
55:
56: bad_action EXCEPTION;

Line 456: Fnd_Msg_Pub.initialize;

452:
453: -- Initialize message list if p_init_msg_list is set to TRUE.
454: IF Fnd_Api.to_Boolean( p_init_msg_list )
455: THEN
456: Fnd_Msg_Pub.initialize;
457: END IF;
458:
459: -- Debug Message
460: IF (PV_DEBUG_HIGH_ON) THEN

Line 469: FND_MSG_PUB.ADD;

465: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
466:
467: IF (p_user_id is null) THEN
468: FND_MESSAGE.SET_NAME ('PV', 'PV_USER_ID_NULL');
469: FND_MSG_PUB.ADD;
470: raise FND_API.G_EXC_ERROR;
471: END IF;
472:
473: IF (p_resp_id is null) THEN

Line 475: FND_MSG_PUB.ADD;

471: END IF;
472:
473: IF (p_resp_id is null) THEN
474: FND_MESSAGE.SET_NAME ('PV', 'PV_RESP_ID_NULL');
475: FND_MSG_PUB.ADD;
476: raise FND_API.G_EXC_ERROR;
477: END IF;
478:
479: IF (p_app_id is null) THEN

Line 481: FND_MSG_PUB.ADD;

477: END IF;
478:
479: IF (p_app_id is null) THEN
480: FND_MESSAGE.SET_NAME ('PV', 'PV_APPL_ID_NULL');
481: FND_MSG_PUB.ADD;
482: raise FND_API.G_EXC_ERROR;
483: END IF;
484:
485: Fnd_User_Resp_Groups_Api.UPLOAD_ASSIGNMENT(

Line 498: Fnd_Msg_Pub.count_and_get(

494: --IF Fnd_Api.to_boolean(p_commit) THEN
495: -- COMMIT;
496: --END IF;
497:
498: Fnd_Msg_Pub.count_and_get(
499: p_encoded => Fnd_Api.g_false
500: ,p_count => x_msg_count
501: ,p_data => x_msg_data
502: );

Line 515: Fnd_Msg_Pub.Count_And_Get (

511: WHEN Fnd_Api.G_EXC_ERROR THEN
512: ROLLBACK TO assign_resp;
513: x_return_status := Fnd_Api.G_RET_STS_ERROR;
514: -- Standard call to get message count and if count=1, get the message
515: Fnd_Msg_Pub.Count_And_Get (
516: p_encoded => Fnd_Api.G_FALSE
517: ,p_count => x_msg_count
518: ,p_data => x_msg_data
519: );

Line 525: Fnd_Msg_Pub.Count_And_Get (

521: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
522: ROLLBACK TO assign_resp;
523: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
524: -- Standard call to get message count and if count=1, get the message
525: Fnd_Msg_Pub.Count_And_Get (
526: p_encoded => Fnd_Api.G_FALSE
527: ,p_count => x_msg_count
528: ,p_data => x_msg_data
529: );

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

530:
531: WHEN OTHERS THEN
532: ROLLBACK TO assign_resp;
533: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
534: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
535: THEN
536: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
537: END IF;
538: -- Standard call to get message count and if count=1, get the message

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

532: ROLLBACK TO assign_resp;
533: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
534: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
535: THEN
536: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
537: END IF;
538: -- Standard call to get message count and if count=1, get the message
539: Fnd_Msg_Pub.Count_And_Get (
540: p_encoded => Fnd_Api.G_FALSE

Line 539: Fnd_Msg_Pub.Count_And_Get (

535: THEN
536: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
537: END IF;
538: -- Standard call to get message count and if count=1, get the message
539: Fnd_Msg_Pub.Count_And_Get (
540: p_encoded => Fnd_Api.G_FALSE
541: ,p_count => x_msg_count
542: ,p_data => x_msg_data
543: );

Line 592: Fnd_Msg_Pub.initialize;

588:
589: -- Initialize message list if p_init_msg_list is set to TRUE.
590: IF Fnd_Api.to_Boolean( p_init_msg_list )
591: THEN
592: Fnd_Msg_Pub.initialize;
593: END IF;
594:
595: -- Debug Message
596: IF (PV_DEBUG_HIGH_ON) THEN

Line 613: Fnd_Msg_Pub.count_and_get(

609: end_date => SYSDATE,
610: description => p_description
611: );
612:
613: Fnd_Msg_Pub.count_and_get(
614: p_encoded => Fnd_Api.g_false
615: ,p_count => x_msg_count
616: ,p_data => x_msg_data
617: );

Line 630: Fnd_Msg_Pub.Count_And_Get (

626: WHEN Fnd_Api.G_EXC_ERROR THEN
627: ROLLBACK TO revoke_resp;
628: x_return_status := Fnd_Api.G_RET_STS_ERROR;
629: -- Standard call to get message count and if count=1, get the message
630: Fnd_Msg_Pub.Count_And_Get (
631: p_encoded => Fnd_Api.G_FALSE
632: ,p_count => x_msg_count
633: ,p_data => x_msg_data
634: );

Line 640: Fnd_Msg_Pub.Count_And_Get (

636: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
637: ROLLBACK TO revoke_resp;
638: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
639: -- Standard call to get message count and if count=1, get the message
640: Fnd_Msg_Pub.Count_And_Get (
641: p_encoded => Fnd_Api.G_FALSE
642: ,p_count => x_msg_count
643: ,p_data => x_msg_data
644: );

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

645:
646: WHEN OTHERS THEN
647: ROLLBACK TO revoke_resp;
648: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
649: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
650: THEN
651: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
652: END IF;
653: -- Standard call to get message count and if count=1, get the message

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

647: ROLLBACK TO revoke_resp;
648: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
649: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
650: THEN
651: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
652: END IF;
653: -- Standard call to get message count and if count=1, get the message
654: Fnd_Msg_Pub.Count_And_Get (
655: p_encoded => Fnd_Api.G_FALSE

Line 654: Fnd_Msg_Pub.Count_And_Get (

650: THEN
651: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
652: END IF;
653: -- Standard call to get message count and if count=1, get the message
654: Fnd_Msg_Pub.Count_And_Get (
655: p_encoded => Fnd_Api.G_FALSE
656: ,p_count => x_msg_count
657: ,p_data => x_msg_data
658: );

Line 714: Fnd_Msg_Pub.initialize;

710:
711: -- Initialize message list if p_init_msg_list is set to TRUE.
712: IF Fnd_Api.to_Boolean( p_init_msg_list )
713: THEN
714: Fnd_Msg_Pub.initialize;
715: END IF;
716:
717: -- Initialize API return status to SUCCESS
718: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

Line 766: Fnd_Msg_Pub.count_and_get(

762: RAISE FND_API.G_EXC_ERROR;
763: END IF;
764: END LOOP;
765:
766: Fnd_Msg_Pub.count_and_get(
767: p_encoded => Fnd_Api.g_false
768: ,p_count => x_msg_count
769: ,p_data => x_msg_data
770: );

Line 783: Fnd_Msg_Pub.Count_And_Get (

779: WHEN Fnd_Api.G_EXC_ERROR THEN
780: ROLLBACK TO revoke_resp;
781: x_return_status := Fnd_Api.G_RET_STS_ERROR;
782: -- Standard call to get message count and if count=1, get the message
783: Fnd_Msg_Pub.Count_And_Get (
784: p_encoded => Fnd_Api.G_FALSE
785: ,p_count => x_msg_count
786: ,p_data => x_msg_data
787: );

Line 793: Fnd_Msg_Pub.Count_And_Get (

789: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
790: ROLLBACK TO revoke_resp;
791: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
792: -- Standard call to get message count and if count=1, get the message
793: Fnd_Msg_Pub.Count_And_Get (
794: p_encoded => Fnd_Api.G_FALSE
795: ,p_count => x_msg_count
796: ,p_data => x_msg_data
797: );

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

798:
799: WHEN OTHERS THEN
800: ROLLBACK TO revoke_resp;
801: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
802: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
803: THEN
804: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
805: END IF;
806: -- Standard call to get message count and if count=1, get the message

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

800: ROLLBACK TO revoke_resp;
801: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
802: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
803: THEN
804: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
805: END IF;
806: -- Standard call to get message count and if count=1, get the message
807: Fnd_Msg_Pub.Count_And_Get (
808: p_encoded => Fnd_Api.G_FALSE

Line 807: Fnd_Msg_Pub.Count_And_Get (

803: THEN
804: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
805: END IF;
806: -- Standard call to get message count and if count=1, get the message
807: Fnd_Msg_Pub.Count_And_Get (
808: p_encoded => Fnd_Api.G_FALSE
809: ,p_count => x_msg_count
810: ,p_data => x_msg_data
811: );

Line 861: FND_MSG_PUB.ADD;

857: END LOOP;
858:
859: IF((not is_partner_user) and (not is_primary_user)) THEN
860: FND_MESSAGE.SET_NAME ('PV', 'PV_NOT_VALID_PARTNER_USER');
861: FND_MSG_PUB.ADD;
862: raise FND_API.G_EXC_ERROR;
863: ELSIF (is_primary_user) THEN
864: x_user_role_code := G_PRIMARY;
865: ELSE

Line 932: Fnd_Msg_Pub.initialize;

928:
929: -- Initialize message list if p_init_msg_list is set to TRUE.
930: IF Fnd_Api.to_Boolean( p_init_msg_list )
931: THEN
932: Fnd_Msg_Pub.initialize;
933: END IF;
934:
935: -- Debug Message
936: IF (PV_DEBUG_HIGH_ON) THEN

Line 989: FND_MSG_PUB.add;

985: x_resp_map_rule_id := x.resp_map_rule_id;
986: END LOOP;
987: IF ((x_responsibility_id is null) or (x_resp_map_rule_id is null)) THEN
988: FND_MESSAGE.set_name('PV', 'PV_NO_DEFLT_RESP');
989: FND_MSG_PUB.add;
990: RAISE FND_API.G_EXC_ERROR;
991: END IF;
992: ELSE
993: IF (PV_DEBUG_HIGH_ON) THEN

Line 1016: FND_MSG_PUB.count_and_get(

1012: IF FND_API.to_boolean(p_commit) THEN
1013: COMMIT;
1014: END IF;
1015:
1016: FND_MSG_PUB.count_and_get(
1017: p_encoded => FND_API.g_false
1018: ,p_count => x_msg_count
1019: ,p_data => x_msg_data
1020: );

Line 1032: FND_MSG_PUB.Count_And_Get (

1028: WHEN FND_API.G_EXC_ERROR THEN
1029: ROLLBACK TO get_default_resp;
1030: x_return_status := FND_API.G_RET_STS_ERROR;
1031: -- Standard call to get message count and if count=1, get the message
1032: FND_MSG_PUB.Count_And_Get (
1033: p_encoded => FND_API.G_FALSE,
1034: p_count => x_msg_count,
1035: p_data => x_msg_data
1036: );

Line 1042: FND_MSG_PUB.Count_And_Get (

1038: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1039: ROLLBACK TO get_default_resp;
1040: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1041: -- Standard call to get message count and if count=1, get the message
1042: FND_MSG_PUB.Count_And_Get (
1043: p_encoded => FND_API.G_FALSE,
1044: p_count => x_msg_count,
1045: p_data => x_msg_data
1046: );

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

1047:
1048: WHEN OTHERS THEN
1049: ROLLBACK TO get_default_resp;
1050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1051: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1052: THEN
1053: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1054: END IF;
1055: -- Standard call to get message count and if count=1, get the message

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

1049: ROLLBACK TO get_default_resp;
1050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1051: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1052: THEN
1053: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1054: END IF;
1055: -- Standard call to get message count and if count=1, get the message
1056: FND_MSG_PUB.Count_And_Get (
1057: p_encoded => FND_API.G_FALSE,

Line 1056: FND_MSG_PUB.Count_And_Get (

1052: THEN
1053: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1054: END IF;
1055: -- Standard call to get message count and if count=1, get the message
1056: FND_MSG_PUB.Count_And_Get (
1057: p_encoded => FND_API.G_FALSE,
1058: p_count => x_msg_count,
1059: p_data => x_msg_data
1060: );

Line 1128: Fnd_Msg_Pub.initialize;

1124:
1125: -- Initialize message list if p_init_msg_list is set to TRUE.
1126: IF Fnd_Api.to_Boolean( p_init_msg_list )
1127: THEN
1128: Fnd_Msg_Pub.initialize;
1129: END IF;
1130:
1131: -- Debug Message
1132: IF (PV_DEBUG_HIGH_ON) THEN

Line 1185: FND_MSG_PUB.add;

1181: x_resp_map_rule_id := x.resp_map_rule_id;
1182: END LOOP;
1183: IF ((x_responsibility_id is null) or (x_resp_map_rule_id is null)) THEN
1184: FND_MESSAGE.set_name('PV', 'PV_NO_DEFLT_RESP');
1185: FND_MSG_PUB.add;
1186: RAISE FND_API.G_EXC_ERROR;
1187: END IF;
1188: ELSE
1189: IF (PV_DEBUG_HIGH_ON) THEN

Line 1212: FND_MSG_PUB.count_and_get(

1208: IF FND_API.to_boolean(p_commit) THEN
1209: COMMIT;
1210: END IF;
1211:
1212: FND_MSG_PUB.count_and_get(
1213: p_encoded => FND_API.g_false
1214: ,p_count => x_msg_count
1215: ,p_data => x_msg_data
1216: );

Line 1228: FND_MSG_PUB.Count_And_Get (

1224: WHEN FND_API.G_EXC_ERROR THEN
1225: ROLLBACK TO get_default_org_resp;
1226: x_return_status := FND_API.G_RET_STS_ERROR;
1227: -- Standard call to get message count and if count=1, get the message
1228: FND_MSG_PUB.Count_And_Get (
1229: p_encoded => FND_API.G_FALSE,
1230: p_count => x_msg_count,
1231: p_data => x_msg_data
1232: );

Line 1238: FND_MSG_PUB.Count_And_Get (

1234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1235: ROLLBACK TO get_default_org_resp;
1236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1237: -- Standard call to get message count and if count=1, get the message
1238: FND_MSG_PUB.Count_And_Get (
1239: p_encoded => FND_API.G_FALSE,
1240: p_count => x_msg_count,
1241: p_data => x_msg_data
1242: );

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

1243:
1244: WHEN OTHERS THEN
1245: ROLLBACK TO get_default_org_resp;
1246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1247: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1248: THEN
1249: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1250: END IF;
1251: -- Standard call to get message count and if count=1, get the message

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

1245: ROLLBACK TO get_default_org_resp;
1246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1247: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1248: THEN
1249: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1250: END IF;
1251: -- Standard call to get message count and if count=1, get the message
1252: FND_MSG_PUB.Count_And_Get (
1253: p_encoded => FND_API.G_FALSE,

Line 1252: FND_MSG_PUB.Count_And_Get (

1248: THEN
1249: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1250: END IF;
1251: -- Standard call to get message count and if count=1, get the message
1252: FND_MSG_PUB.Count_And_Get (
1253: p_encoded => FND_API.G_FALSE,
1254: p_count => x_msg_count,
1255: p_data => x_msg_data
1256: );

Line 1322: Fnd_Msg_Pub.initialize;

1318:
1319: -- Initialize message list if p_init_msg_list is set to TRUE.
1320: IF Fnd_Api.to_Boolean( p_init_msg_list )
1321: THEN
1322: Fnd_Msg_Pub.initialize;
1323: END IF;
1324:
1325: -- Debug Message
1326: IF (PV_DEBUG_HIGH_ON) THEN

Line 1400: FND_MSG_PUB.count_and_get(

1396: IF FND_API.to_boolean(p_commit) THEN
1397: COMMIT;
1398: END IF;
1399:
1400: FND_MSG_PUB.count_and_get(
1401: p_encoded => FND_API.g_false
1402: ,p_count => x_msg_count
1403: ,p_data => x_msg_data
1404: );

Line 1416: FND_MSG_PUB.Count_And_Get (

1412: WHEN FND_API.G_EXC_ERROR THEN
1413: ROLLBACK TO get_program_resp;
1414: x_return_status := FND_API.G_RET_STS_ERROR;
1415: -- Standard call to get message count and if count=1, get the message
1416: FND_MSG_PUB.Count_And_Get (
1417: p_encoded => FND_API.G_FALSE,
1418: p_count => x_msg_count,
1419: p_data => x_msg_data
1420: );

Line 1426: FND_MSG_PUB.Count_And_Get (

1422: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1423: ROLLBACK TO get_program_resp;
1424: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1425: -- Standard call to get message count and if count=1, get the message
1426: FND_MSG_PUB.Count_And_Get (
1427: p_encoded => FND_API.G_FALSE,
1428: p_count => x_msg_count,
1429: p_data => x_msg_data
1430: );

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

1431:
1432: WHEN OTHERS THEN
1433: ROLLBACK TO get_program_resp;
1434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1435: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1436: THEN
1437: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1438: END IF;
1439: -- Standard call to get message count and if count=1, get the message

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

1433: ROLLBACK TO get_program_resp;
1434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1435: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1436: THEN
1437: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1438: END IF;
1439: -- Standard call to get message count and if count=1, get the message
1440: FND_MSG_PUB.Count_And_Get (
1441: p_encoded => FND_API.G_FALSE,

Line 1440: FND_MSG_PUB.Count_And_Get (

1436: THEN
1437: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1438: END IF;
1439: -- Standard call to get message count and if count=1, get the message
1440: FND_MSG_PUB.Count_And_Get (
1441: p_encoded => FND_API.G_FALSE,
1442: p_count => x_msg_count,
1443: p_data => x_msg_data
1444: );

Line 1510: Fnd_Msg_Pub.initialize;

1506:
1507: -- Initialize message list if p_init_msg_list is set to TRUE.
1508: IF Fnd_Api.to_Boolean( p_init_msg_list )
1509: THEN
1510: Fnd_Msg_Pub.initialize;
1511: END IF;
1512:
1513: -- Debug Message
1514: IF (PV_DEBUG_HIGH_ON) THEN

Line 1542: FND_MSG_PUB.count_and_get(

1538: IF FND_API.to_boolean(p_commit) THEN
1539: COMMIT;
1540: END IF;
1541:
1542: FND_MSG_PUB.count_and_get(
1543: p_encoded => FND_API.g_false
1544: ,p_count => x_msg_count
1545: ,p_data => x_msg_data
1546: );

Line 1558: FND_MSG_PUB.Count_And_Get (

1554: WHEN FND_API.G_EXC_ERROR THEN
1555: ROLLBACK TO get_store_prgm_resps;
1556: x_return_status := FND_API.G_RET_STS_ERROR;
1557: -- Standard call to get message count and if count=1, get the message
1558: FND_MSG_PUB.Count_And_Get (
1559: p_encoded => FND_API.G_FALSE,
1560: p_count => x_msg_count,
1561: p_data => x_msg_data
1562: );

Line 1568: FND_MSG_PUB.Count_And_Get (

1564: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1565: ROLLBACK TO get_store_prgm_resps;
1566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1567: -- Standard call to get message count and if count=1, get the message
1568: FND_MSG_PUB.Count_And_Get (
1569: p_encoded => FND_API.G_FALSE,
1570: p_count => x_msg_count,
1571: p_data => x_msg_data
1572: );

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

1573:
1574: WHEN OTHERS THEN
1575: ROLLBACK TO get_store_prgm_resps;
1576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1577: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1578: THEN
1579: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1580: END IF;
1581: -- Standard call to get message count and if count=1, get the message

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

1575: ROLLBACK TO get_store_prgm_resps;
1576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1577: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1578: THEN
1579: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1580: END IF;
1581: -- Standard call to get message count and if count=1, get the message
1582: FND_MSG_PUB.Count_And_Get (
1583: p_encoded => FND_API.G_FALSE,

Line 1582: FND_MSG_PUB.Count_And_Get (

1578: THEN
1579: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1580: END IF;
1581: -- Standard call to get message count and if count=1, get the message
1582: FND_MSG_PUB.Count_And_Get (
1583: p_encoded => FND_API.G_FALSE,
1584: p_count => x_msg_count,
1585: p_data => x_msg_data
1586: );

Line 1645: Fnd_Msg_Pub.initialize;

1641:
1642: -- Initialize message list if p_init_msg_list is set to TRUE.
1643: IF Fnd_Api.to_Boolean( p_init_msg_list )
1644: THEN
1645: Fnd_Msg_Pub.initialize;
1646: END IF;
1647:
1648: -- Debug Message
1649: IF (PV_DEBUG_HIGH_ON) THEN

Line 1681: FND_MSG_PUB.count_and_get(

1677: IF FND_API.to_boolean(p_commit) THEN
1678: COMMIT;
1679: END IF;
1680:
1681: FND_MSG_PUB.count_and_get(
1682: p_encoded => FND_API.g_false
1683: ,p_count => x_msg_count
1684: ,p_data => x_msg_data
1685: );

Line 1697: FND_MSG_PUB.Count_And_Get (

1693: WHEN FND_API.G_EXC_ERROR THEN
1694: ROLLBACK TO get_store_prgm_resps;
1695: x_return_status := FND_API.G_RET_STS_ERROR;
1696: -- Standard call to get message count and if count=1, get the message
1697: FND_MSG_PUB.Count_And_Get (
1698: p_encoded => FND_API.G_FALSE,
1699: p_count => x_msg_count,
1700: p_data => x_msg_data
1701: );

Line 1707: FND_MSG_PUB.Count_And_Get (

1703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1704: ROLLBACK TO get_store_prgm_resps;
1705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1706: -- Standard call to get message count and if count=1, get the message
1707: FND_MSG_PUB.Count_And_Get (
1708: p_encoded => FND_API.G_FALSE,
1709: p_count => x_msg_count,
1710: p_data => x_msg_data
1711: );

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

1712:
1713: WHEN OTHERS THEN
1714: ROLLBACK TO get_store_prgm_resps;
1715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1716: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1717: THEN
1718: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1719: END IF;
1720: -- Standard call to get message count and if count=1, get the message

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

1714: ROLLBACK TO get_store_prgm_resps;
1715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1716: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1717: THEN
1718: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1719: END IF;
1720: -- Standard call to get message count and if count=1, get the message
1721: FND_MSG_PUB.Count_And_Get (
1722: p_encoded => FND_API.G_FALSE,

Line 1721: FND_MSG_PUB.Count_And_Get (

1717: THEN
1718: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1719: END IF;
1720: -- Standard call to get message count and if count=1, get the message
1721: FND_MSG_PUB.Count_And_Get (
1722: p_encoded => FND_API.G_FALSE,
1723: p_count => x_msg_count,
1724: p_data => x_msg_data
1725: );

Line 1761: Fnd_Msg_Pub.initialize;

1757:
1758: -- Initialize message list if p_init_msg_list is set to TRUE.
1759: IF Fnd_Api.to_Boolean( p_init_msg_list )
1760: THEN
1761: Fnd_Msg_Pub.initialize;
1762: END IF;
1763:
1764: -- Debug Message
1765: IF (PV_DEBUG_HIGH_ON) THEN

Line 1853: FND_MSG_PUB.add;

1849: RAISE FND_API.G_EXC_ERROR;
1850: END IF;
1851: ELSE
1852: FND_MESSAGE.set_name('PV', 'PV_NO_DEFAULT_RESP');
1853: FND_MSG_PUB.add;
1854: RAISE FND_API.G_EXC_ERROR;
1855: END IF;
1856:
1857: -- Check for commit

Line 1862: FND_MSG_PUB.count_and_get(

1858: IF FND_API.to_boolean(p_commit) THEN
1859: COMMIT;
1860: END IF;
1861:
1862: FND_MSG_PUB.count_and_get(
1863: p_encoded => FND_API.g_false
1864: ,p_count => x_msg_count
1865: ,p_data => x_msg_data
1866: );

Line 1877: FND_MSG_PUB.Count_And_Get (

1873:
1874: WHEN FND_API.G_EXC_ERROR THEN
1875: x_return_status := FND_API.G_RET_STS_ERROR;
1876: -- Standard call to get message count and if count=1, get the message
1877: FND_MSG_PUB.Count_And_Get (
1878: p_encoded => FND_API.G_FALSE,
1879: p_count => x_msg_count,
1880: p_data => x_msg_data
1881: );

Line 1886: FND_MSG_PUB.Count_And_Get (

1882:
1883: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1884: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1885: -- Standard call to get message count and if count=1, get the message
1886: FND_MSG_PUB.Count_And_Get (
1887: p_encoded => FND_API.G_FALSE,
1888: p_count => x_msg_count,
1889: p_data => x_msg_data
1890: );

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

1890: );
1891:
1892: WHEN OTHERS THEN
1893: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1894: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1895: THEN
1896: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1897: END IF;
1898: -- Standard call to get message count and if count=1, get the message

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

1892: WHEN OTHERS THEN
1893: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1894: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1895: THEN
1896: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1897: END IF;
1898: -- Standard call to get message count and if count=1, get the message
1899: FND_MSG_PUB.Count_And_Get (
1900: p_encoded => FND_API.G_FALSE,

Line 1899: FND_MSG_PUB.Count_And_Get (

1895: THEN
1896: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1897: END IF;
1898: -- Standard call to get message count and if count=1, get the message
1899: FND_MSG_PUB.Count_And_Get (
1900: p_encoded => FND_API.G_FALSE,
1901: p_count => x_msg_count,
1902: p_data => x_msg_data
1903: );

Line 1948: Fnd_Msg_Pub.initialize;

1944:
1945: -- Initialize message list if p_init_msg_list is set to TRUE.
1946: IF Fnd_Api.to_Boolean( p_init_msg_list )
1947: THEN
1948: Fnd_Msg_Pub.initialize;
1949: END IF;
1950:
1951: -- Debug Message
1952: IF (PV_DEBUG_HIGH_ON) THEN

Line 2018: FND_MSG_PUB.count_and_get(

2014: IF FND_API.to_boolean(p_commit) THEN
2015: COMMIT;
2016: END IF;
2017:
2018: FND_MSG_PUB.count_and_get(
2019: p_encoded => FND_API.g_false
2020: ,p_count => x_msg_count
2021: ,p_data => x_msg_data
2022: );

Line 2034: FND_MSG_PUB.Count_And_Get (

2030: WHEN FND_API.G_EXC_ERROR THEN
2031: ROLLBACK TO assign_first_user_resp;
2032: x_return_status := FND_API.G_RET_STS_ERROR;
2033: -- Standard call to get message count and if count=1, get the message
2034: FND_MSG_PUB.Count_And_Get (
2035: p_encoded => FND_API.G_FALSE,
2036: p_count => x_msg_count,
2037: p_data => x_msg_data
2038: );

Line 2044: FND_MSG_PUB.Count_And_Get (

2040: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2041: ROLLBACK TO assign_first_user_resp;
2042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2043: -- Standard call to get message count and if count=1, get the message
2044: FND_MSG_PUB.Count_And_Get (
2045: p_encoded => FND_API.G_FALSE,
2046: p_count => x_msg_count,
2047: p_data => x_msg_data
2048: );

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

2049:
2050: WHEN OTHERS THEN
2051: ROLLBACK TO assign_first_user_resp;
2052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2053: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2054: THEN
2055: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2056: END IF;
2057: -- Standard call to get message count and if count=1, get the message

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

2051: ROLLBACK TO assign_first_user_resp;
2052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2053: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2054: THEN
2055: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2056: END IF;
2057: -- Standard call to get message count and if count=1, get the message
2058: FND_MSG_PUB.Count_And_Get (
2059: p_encoded => FND_API.G_FALSE,

Line 2058: FND_MSG_PUB.Count_And_Get (

2054: THEN
2055: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2056: END IF;
2057: -- Standard call to get message count and if count=1, get the message
2058: FND_MSG_PUB.Count_And_Get (
2059: p_encoded => FND_API.G_FALSE,
2060: p_count => x_msg_count,
2061: p_data => x_msg_data
2062: );

Line 2127: Fnd_Msg_Pub.initialize;

2123:
2124: -- Initialize message list if p_init_msg_list is set to TRUE.
2125: IF Fnd_Api.to_Boolean( p_init_msg_list )
2126: THEN
2127: Fnd_Msg_Pub.initialize;
2128: END IF;
2129:
2130: -- Debug Message
2131: IF (PV_DEBUG_HIGH_ON) THEN

Line 2142: FND_MSG_PUB.add;

2138: l_partner_ids_tbl := get_partners(p_user_id);
2139:
2140: IF (l_partner_ids_tbl.count = 0) THEN
2141: FND_MESSAGE.set_name('PV', 'PV_INVALID_PTNR_USER');
2142: FND_MSG_PUB.add;
2143: RAISE FND_API.G_EXC_ERROR;
2144: END IF;
2145:
2146: IF (PV_DEBUG_HIGH_ON) THEN

Line 2307: FND_MSG_PUB.count_and_get(

2303: IF FND_API.to_boolean(p_commit) THEN
2304: COMMIT;
2305: END IF;
2306:
2307: FND_MSG_PUB.count_and_get(
2308: p_encoded => FND_API.g_false
2309: ,p_count => x_msg_count
2310: ,p_data => x_msg_data
2311: );

Line 2323: FND_MSG_PUB.Count_And_Get (

2319: WHEN FND_API.G_EXC_ERROR THEN
2320: ROLLBACK TO assign_user_resps;
2321: x_return_status := FND_API.G_RET_STS_ERROR;
2322: -- Standard call to get message count and if count=1, get the message
2323: FND_MSG_PUB.Count_And_Get (
2324: p_encoded => FND_API.G_FALSE,
2325: p_count => x_msg_count,
2326: p_data => x_msg_data
2327: );

Line 2333: FND_MSG_PUB.Count_And_Get (

2329: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2330: ROLLBACK TO assign_user_resps;
2331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2332: -- Standard call to get message count and if count=1, get the message
2333: FND_MSG_PUB.Count_And_Get (
2334: p_encoded => FND_API.G_FALSE,
2335: p_count => x_msg_count,
2336: p_data => x_msg_data
2337: );

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

2338:
2339: WHEN OTHERS THEN
2340: ROLLBACK TO assign_user_resps;
2341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2342: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2343: THEN
2344: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2345: END IF;
2346: -- Standard call to get message count and if count=1, get the message

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

2340: ROLLBACK TO assign_user_resps;
2341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2342: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2343: THEN
2344: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2345: END IF;
2346: -- Standard call to get message count and if count=1, get the message
2347: FND_MSG_PUB.Count_And_Get (
2348: p_encoded => FND_API.G_FALSE,

Line 2347: FND_MSG_PUB.Count_And_Get (

2343: THEN
2344: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2345: END IF;
2346: -- Standard call to get message count and if count=1, get the message
2347: FND_MSG_PUB.Count_And_Get (
2348: p_encoded => FND_API.G_FALSE,
2349: p_count => x_msg_count,
2350: p_data => x_msg_data
2351: );

Line 2400: Fnd_Msg_Pub.initialize;

2396:
2397: -- Initialize message list if p_init_msg_list is set to TRUE.
2398: IF Fnd_Api.to_Boolean( p_init_msg_list )
2399: THEN
2400: Fnd_Msg_Pub.initialize;
2401: END IF;
2402:
2403: -- Debug Message
2404: IF (PV_DEBUG_HIGH_ON) THEN

Line 2445: FND_MSG_PUB.count_and_get(

2441: IF FND_API.to_boolean(p_commit) THEN
2442: COMMIT;
2443: END IF;
2444:
2445: FND_MSG_PUB.count_and_get(
2446: p_encoded => FND_API.g_false
2447: ,p_count => x_msg_count
2448: ,p_data => x_msg_data
2449: );

Line 2461: FND_MSG_PUB.Count_And_Get (

2457: WHEN FND_API.G_EXC_ERROR THEN
2458: ROLLBACK TO assign_user_resps_2;
2459: x_return_status := FND_API.G_RET_STS_ERROR;
2460: -- Standard call to get message count and if count=1, get the message
2461: FND_MSG_PUB.Count_And_Get (
2462: p_encoded => FND_API.G_FALSE,
2463: p_count => x_msg_count,
2464: p_data => x_msg_data
2465: );

Line 2471: FND_MSG_PUB.Count_And_Get (

2467: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2468: ROLLBACK TO assign_user_resps_2;
2469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2470: -- Standard call to get message count and if count=1, get the message
2471: FND_MSG_PUB.Count_And_Get (
2472: p_encoded => FND_API.G_FALSE,
2473: p_count => x_msg_count,
2474: p_data => x_msg_data
2475: );

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

2476:
2477: WHEN OTHERS THEN
2478: ROLLBACK TO assign_user_resps_2;
2479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2480: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2481: THEN
2482: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2483: END IF;
2484: -- Standard call to get message count and if count=1, get the message

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

2478: ROLLBACK TO assign_user_resps_2;
2479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2480: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2481: THEN
2482: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2483: END IF;
2484: -- Standard call to get message count and if count=1, get the message
2485: FND_MSG_PUB.Count_And_Get (
2486: p_encoded => FND_API.G_FALSE,

Line 2485: FND_MSG_PUB.Count_And_Get (

2481: THEN
2482: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2483: END IF;
2484: -- Standard call to get message count and if count=1, get the message
2485: FND_MSG_PUB.Count_And_Get (
2486: p_encoded => FND_API.G_FALSE,
2487: p_count => x_msg_count,
2488: p_data => x_msg_data
2489: );

Line 2577: Fnd_Msg_Pub.initialize;

2573:
2574: -- Initialize message list if p_init_msg_list is set to TRUE.
2575: IF Fnd_Api.to_Boolean( p_init_msg_list )
2576: THEN
2577: Fnd_Msg_Pub.initialize;
2578: END IF;
2579:
2580: -- Debug Message
2581: IF (PV_DEBUG_HIGH_ON) THEN

Line 2592: FND_MSG_PUB.add;

2588: l_partner_ids_tbl := get_partners(p_user_id);
2589:
2590: IF (l_partner_ids_tbl.count = 0) THEN
2591: FND_MESSAGE.set_name('PV', 'PV_INVALID_PTNR_USER');
2592: FND_MSG_PUB.add;
2593: RAISE FND_API.G_EXC_ERROR;
2594: END IF;
2595:
2596: FOR x in c_get_respid_and_action (l_partner_ids_tbl, p_user_id, p_from_user_role_code, p_to_user_role_code)

Line 2675: FND_MSG_PUB.count_and_get(

2671: IF FND_API.to_boolean(p_commit) THEN
2672: COMMIT;
2673: END IF;
2674:
2675: FND_MSG_PUB.count_and_get(
2676: p_encoded => FND_API.g_false
2677: ,p_count => x_msg_count
2678: ,p_data => x_msg_data
2679: );

Line 2691: FND_MSG_PUB.Count_And_Get (

2687: WHEN FND_API.G_EXC_ERROR THEN
2688: ROLLBACK TO switch_user_resp;
2689: x_return_status := FND_API.G_RET_STS_ERROR;
2690: -- Standard call to get message count and if count=1, get the message
2691: FND_MSG_PUB.Count_And_Get (
2692: p_encoded => FND_API.G_FALSE,
2693: p_count => x_msg_count,
2694: p_data => x_msg_data
2695: );

Line 2701: FND_MSG_PUB.Count_And_Get (

2697: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2698: ROLLBACK TO switch_user_resp;
2699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2700: -- Standard call to get message count and if count=1, get the message
2701: FND_MSG_PUB.Count_And_Get (
2702: p_encoded => FND_API.G_FALSE,
2703: p_count => x_msg_count,
2704: p_data => x_msg_data
2705: );

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

2706:
2707: WHEN OTHERS THEN
2708: ROLLBACK TO switch_user_resp;
2709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2710: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2711: THEN
2712: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2713: END IF;
2714: -- Standard call to get message count and if count=1, get the message

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

2708: ROLLBACK TO switch_user_resp;
2709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2710: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2711: THEN
2712: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2713: END IF;
2714: -- Standard call to get message count and if count=1, get the message
2715: FND_MSG_PUB.Count_And_Get (
2716: p_encoded => FND_API.G_FALSE,

Line 2715: FND_MSG_PUB.Count_And_Get (

2711: THEN
2712: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2713: END IF;
2714: -- Standard call to get message count and if count=1, get the message
2715: FND_MSG_PUB.Count_And_Get (
2716: p_encoded => FND_API.G_FALSE,
2717: p_count => x_msg_count,
2718: p_data => x_msg_data
2719: );

Line 2759: Fnd_Msg_Pub.initialize;

2755:
2756: -- Initialize message list if p_init_msg_list is set to TRUE.
2757: IF Fnd_Api.to_Boolean( p_init_msg_list )
2758: THEN
2759: Fnd_Msg_Pub.initialize;
2760: END IF;
2761:
2762: -- Debug Message
2763: IF (PV_DEBUG_HIGH_ON) THEN

Line 2853: FND_MSG_PUB.count_and_get(

2849: IF FND_API.to_boolean(p_commit) THEN
2850: COMMIT;
2851: END IF;
2852:
2853: FND_MSG_PUB.count_and_get(
2854: p_encoded => FND_API.g_false
2855: ,p_count => x_msg_count
2856: ,p_data => x_msg_data
2857: );

Line 2869: FND_MSG_PUB.Count_And_Get (

2865: WHEN FND_API.G_EXC_ERROR THEN
2866: RAISE FND_API.G_EXC_ERROR;
2867: x_return_status := FND_API.G_RET_STS_ERROR;
2868: -- Standard call to get message count and if count=1, get the message
2869: FND_MSG_PUB.Count_And_Get (
2870: p_encoded => FND_API.G_FALSE,
2871: p_count => x_msg_count,
2872: p_data => x_msg_data
2873: );

Line 2879: FND_MSG_PUB.Count_And_Get (

2875: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2876: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2877: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2878: -- Standard call to get message count and if count=1, get the message
2879: FND_MSG_PUB.Count_And_Get (
2880: p_encoded => FND_API.G_FALSE,
2881: p_count => x_msg_count,
2882: p_data => x_msg_data
2883: );

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

2884:
2885: WHEN OTHERS THEN
2886: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2887: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2888: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2889: THEN
2890: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2891: END IF;
2892: -- Standard call to get message count and if count=1, get the message

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

2886: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2887: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2888: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2889: THEN
2890: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2891: END IF;
2892: -- Standard call to get message count and if count=1, get the message
2893: FND_MSG_PUB.Count_And_Get (
2894: p_encoded => FND_API.G_FALSE,

Line 2893: FND_MSG_PUB.Count_And_Get (

2889: THEN
2890: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2891: END IF;
2892: -- Standard call to get message count and if count=1, get the message
2893: FND_MSG_PUB.Count_And_Get (
2894: p_encoded => FND_API.G_FALSE,
2895: p_count => x_msg_count,
2896: p_data => x_msg_data
2897: );

Line 2983: Fnd_Msg_Pub.initialize;

2979:
2980: -- Initialize message list if p_init_msg_list is set to TRUE.
2981: IF Fnd_Api.to_Boolean( p_init_msg_list )
2982: THEN
2983: Fnd_Msg_Pub.initialize;
2984: END IF;
2985:
2986: -- Debug Message
2987: IF (PV_DEBUG_HIGH_ON) THEN

Line 3190: FND_MSG_PUB.count_and_get(

3186: RAISE FND_API.G_EXC_ERROR;
3187: END IF;
3188: END LOOP; -- End of FOR x IN c_get_partner_resp_info(G_STORE) LOOP
3189:
3190: FND_MSG_PUB.count_and_get(
3191: p_encoded => FND_API.g_false
3192: ,p_count => x_msg_count
3193: ,p_data => x_msg_data
3194: );

Line 3211: FND_MSG_PUB.Count_And_Get (

3207: WHEN FND_API.G_EXC_ERROR THEN
3208: ROLLBACK TO manage_ter_exp_memb_resp;
3209: x_return_status := FND_API.G_RET_STS_ERROR;
3210: -- Standard call to get message count and if count=1, get the message
3211: FND_MSG_PUB.Count_And_Get (
3212: p_encoded => FND_API.G_FALSE,
3213: p_count => x_msg_count,
3214: p_data => x_msg_data
3215: );

Line 3221: FND_MSG_PUB.Count_And_Get (

3217: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3218: ROLLBACK TO manage_ter_exp_memb_resp;
3219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3220: -- Standard call to get message count and if count=1, get the message
3221: FND_MSG_PUB.Count_And_Get (
3222: p_encoded => FND_API.G_FALSE,
3223: p_count => x_msg_count,
3224: p_data => x_msg_data
3225: );

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

3226:
3227: WHEN OTHERS THEN
3228: ROLLBACK TO manage_ter_exp_memb_resp;
3229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3230: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3231: THEN
3232: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3233: END IF;
3234: -- Standard call to get message count and if count=1, get the message

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

3228: ROLLBACK TO manage_ter_exp_memb_resp;
3229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3230: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3231: THEN
3232: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3233: END IF;
3234: -- Standard call to get message count and if count=1, get the message
3235: FND_MSG_PUB.Count_And_Get (
3236: p_encoded => FND_API.G_FALSE,

Line 3235: FND_MSG_PUB.Count_And_Get (

3231: THEN
3232: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3233: END IF;
3234: -- Standard call to get message count and if count=1, get the message
3235: FND_MSG_PUB.Count_And_Get (
3236: p_encoded => FND_API.G_FALSE,
3237: p_count => x_msg_count,
3238: p_data => x_msg_data
3239: );

Line 3304: Fnd_Msg_Pub.initialize;

3300:
3301: -- Initialize message list if p_init_msg_list is set to TRUE.
3302: IF Fnd_Api.to_Boolean( p_init_msg_list )
3303: THEN
3304: Fnd_Msg_Pub.initialize;
3305: END IF;
3306:
3307: -- Debug Message
3308: IF (PV_DEBUG_HIGH_ON) THEN

Line 3710: FND_MSG_PUB.count_and_get(

3706: IF FND_API.to_boolean(p_commit) THEN
3707: COMMIT;
3708: END IF;
3709:
3710: FND_MSG_PUB.count_and_get(
3711: p_encoded => FND_API.g_false
3712: ,p_count => x_msg_count
3713: ,p_data => x_msg_data
3714: );

Line 3726: FND_MSG_PUB.Count_And_Get (

3722: WHEN FND_API.G_EXC_ERROR THEN
3723: ROLLBACK TO manage_active_memb_resp;
3724: x_return_status := FND_API.G_RET_STS_ERROR;
3725: -- Standard call to get message count and if count=1, get the message
3726: FND_MSG_PUB.Count_And_Get (
3727: p_encoded => FND_API.G_FALSE,
3728: p_count => x_msg_count,
3729: p_data => x_msg_data
3730: );

Line 3736: FND_MSG_PUB.Count_And_Get (

3732: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3733: ROLLBACK TO manage_active_memb_resp;
3734: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3735: -- Standard call to get message count and if count=1, get the message
3736: FND_MSG_PUB.Count_And_Get (
3737: p_encoded => FND_API.G_FALSE,
3738: p_count => x_msg_count,
3739: p_data => x_msg_data
3740: );

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

3741:
3742: WHEN OTHERS THEN
3743: ROLLBACK TO manage_active_memb_resp;
3744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3745: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3746: THEN
3747: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3748: END IF;
3749: -- Standard call to get message count and if count=1, get the message

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

3743: ROLLBACK TO manage_active_memb_resp;
3744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3745: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3746: THEN
3747: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3748: END IF;
3749: -- Standard call to get message count and if count=1, get the message
3750: FND_MSG_PUB.Count_And_Get (
3751: p_encoded => FND_API.G_FALSE,

Line 3750: FND_MSG_PUB.Count_And_Get (

3746: THEN
3747: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3748: END IF;
3749: -- Standard call to get message count and if count=1, get the message
3750: FND_MSG_PUB.Count_And_Get (
3751: p_encoded => FND_API.G_FALSE,
3752: p_count => x_msg_count,
3753: p_data => x_msg_data
3754: );

Line 3806: Fnd_Msg_Pub.initialize;

3802:
3803: -- Initialize message list if p_init_msg_list is set to TRUE.
3804: IF Fnd_Api.to_Boolean( p_init_msg_list )
3805: THEN
3806: Fnd_Msg_Pub.initialize;
3807: END IF;
3808:
3809: -- Debug Message
3810: IF (PV_DEBUG_HIGH_ON) THEN

Line 3863: FND_MSG_PUB.count_and_get(

3859: IF FND_API.to_boolean(p_commit) THEN
3860: COMMIT;
3861: END IF;
3862:
3863: FND_MSG_PUB.count_and_get(
3864: p_encoded => FND_API.g_false
3865: ,p_count => x_msg_count
3866: ,p_data => x_msg_data
3867: );

Line 3879: FND_MSG_PUB.Count_And_Get (

3875: WHEN FND_API.G_EXC_ERROR THEN
3876: ROLLBACK TO manage_memb_resp;
3877: x_return_status := FND_API.G_RET_STS_ERROR;
3878: -- Standard call to get message count and if count=1, get the message
3879: FND_MSG_PUB.Count_And_Get (
3880: p_encoded => FND_API.G_FALSE,
3881: p_count => x_msg_count,
3882: p_data => x_msg_data
3883: );

Line 3889: FND_MSG_PUB.Count_And_Get (

3885: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3886: ROLLBACK TO manage_memb_resp;
3887: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3888: -- Standard call to get message count and if count=1, get the message
3889: FND_MSG_PUB.Count_And_Get (
3890: p_encoded => FND_API.G_FALSE,
3891: p_count => x_msg_count,
3892: p_data => x_msg_data
3893: );

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

3894:
3895: WHEN OTHERS THEN
3896: ROLLBACK TO manage_memb_resp;
3897: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3898: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3899: THEN
3900: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3901: END IF;
3902: -- Standard call to get message count and if count=1, get the message

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

3896: ROLLBACK TO manage_memb_resp;
3897: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3898: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3899: THEN
3900: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3901: END IF;
3902: -- Standard call to get message count and if count=1, get the message
3903: FND_MSG_PUB.Count_And_Get (
3904: p_encoded => FND_API.G_FALSE,

Line 3903: FND_MSG_PUB.Count_And_Get (

3899: THEN
3900: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3901: END IF;
3902: -- Standard call to get message count and if count=1, get the message
3903: FND_MSG_PUB.Count_And_Get (
3904: p_encoded => FND_API.G_FALSE,
3905: p_count => x_msg_count,
3906: p_data => x_msg_data
3907: );

Line 3977: Fnd_Msg_Pub.initialize;

3973:
3974: -- Initialize message list if p_init_msg_list is set to TRUE.
3975: IF Fnd_Api.to_Boolean( p_init_msg_list )
3976: THEN
3977: Fnd_Msg_Pub.initialize;
3978: END IF;
3979:
3980: -- Debug Message
3981: IF (PV_DEBUG_HIGH_ON) THEN

Line 4228: FND_MSG_PUB.count_and_get(

4224: IF FND_API.to_boolean(p_commit) THEN
4225: COMMIT;
4226: END IF;
4227:
4228: FND_MSG_PUB.count_and_get(
4229: p_encoded => FND_API.g_false
4230: ,p_count => x_msg_count
4231: ,p_data => x_msg_data
4232: );

Line 4244: FND_MSG_PUB.Count_And_Get (

4240: WHEN FND_API.G_EXC_ERROR THEN
4241: ROLLBACK TO delete_resp_mapping;
4242: x_return_status := FND_API.G_RET_STS_ERROR;
4243: -- Standard call to get message count and if count=1, get the message
4244: FND_MSG_PUB.Count_And_Get (
4245: p_encoded => FND_API.G_FALSE,
4246: p_count => x_msg_count,
4247: p_data => x_msg_data
4248: );

Line 4254: FND_MSG_PUB.Count_And_Get (

4250: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4251: ROLLBACK TO delete_resp_mapping;
4252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4253: -- Standard call to get message count and if count=1, get the message
4254: FND_MSG_PUB.Count_And_Get (
4255: p_encoded => FND_API.G_FALSE,
4256: p_count => x_msg_count,
4257: p_data => x_msg_data
4258: );

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

4259:
4260: WHEN OTHERS THEN
4261: ROLLBACK TO delete_resp_mapping;
4262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4263: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4264: THEN
4265: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4266: END IF;
4267: -- Standard call to get message count and if count=1, get the message

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

4261: ROLLBACK TO delete_resp_mapping;
4262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4263: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4264: THEN
4265: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4266: END IF;
4267: -- Standard call to get message count and if count=1, get the message
4268: FND_MSG_PUB.Count_And_Get (
4269: p_encoded => FND_API.G_FALSE,

Line 4268: FND_MSG_PUB.Count_And_Get (

4264: THEN
4265: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4266: END IF;
4267: -- Standard call to get message count and if count=1, get the message
4268: FND_MSG_PUB.Count_And_Get (
4269: p_encoded => FND_API.G_FALSE,
4270: p_count => x_msg_count,
4271: p_data => x_msg_data
4272: );

Line 4338: Fnd_Msg_Pub.initialize;

4334:
4335: -- Initialize message list if p_init_msg_list is set to TRUE.
4336: IF Fnd_Api.to_Boolean( p_init_msg_list )
4337: THEN
4338: Fnd_Msg_Pub.initialize;
4339: END IF;
4340:
4341: -- Debug Message
4342: IF (PV_DEBUG_HIGH_ON) THEN

Line 4465: FND_MSG_PUB.count_and_get(

4461: IF FND_API.to_boolean(p_commit) THEN
4462: COMMIT;
4463: END IF;
4464:
4465: FND_MSG_PUB.count_and_get(
4466: p_encoded => FND_API.g_false
4467: ,p_count => x_msg_count
4468: ,p_data => x_msg_data
4469: );

Line 4481: FND_MSG_PUB.Count_And_Get (

4477: WHEN FND_API.G_EXC_ERROR THEN
4478: ROLLBACK TO update_resp_mapping;
4479: x_return_status := FND_API.G_RET_STS_ERROR;
4480: -- Standard call to get message count and if count=1, get the message
4481: FND_MSG_PUB.Count_And_Get (
4482: p_encoded => FND_API.G_FALSE,
4483: p_count => x_msg_count,
4484: p_data => x_msg_data
4485: );

Line 4491: FND_MSG_PUB.Count_And_Get (

4487: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4488: ROLLBACK TO update_resp_mapping;
4489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4490: -- Standard call to get message count and if count=1, get the message
4491: FND_MSG_PUB.Count_And_Get (
4492: p_encoded => FND_API.G_FALSE,
4493: p_count => x_msg_count,
4494: p_data => x_msg_data
4495: );

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

4496:
4497: WHEN OTHERS THEN
4498: ROLLBACK TO update_resp_mapping;
4499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4500: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4501: THEN
4502: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4503: END IF;
4504: -- Standard call to get message count and if count=1, get the message

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

4498: ROLLBACK TO update_resp_mapping;
4499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4500: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4501: THEN
4502: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4503: END IF;
4504: -- Standard call to get message count and if count=1, get the message
4505: FND_MSG_PUB.Count_And_Get (
4506: p_encoded => FND_API.G_FALSE,

Line 4505: FND_MSG_PUB.Count_And_Get (

4501: THEN
4502: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4503: END IF;
4504: -- Standard call to get message count and if count=1, get the message
4505: FND_MSG_PUB.Count_And_Get (
4506: p_encoded => FND_API.G_FALSE,
4507: p_count => x_msg_count,
4508: p_data => x_msg_data
4509: );

Line 4602: Fnd_Msg_Pub.initialize;

4598:
4599: -- Initialize message list if p_init_msg_list is set to TRUE.
4600: IF Fnd_Api.to_Boolean( p_init_msg_list )
4601: THEN
4602: Fnd_Msg_Pub.initialize;
4603: END IF;
4604:
4605: -- Debug Message
4606: IF (PV_DEBUG_HIGH_ON) THEN

Line 4879: FND_MSG_PUB.count_and_get(

4875: IF FND_API.to_boolean(p_commit) THEN
4876: COMMIT;
4877: END IF;
4878:
4879: FND_MSG_PUB.count_and_get(
4880: p_encoded => FND_API.g_false
4881: ,p_count => x_msg_count
4882: ,p_data => x_msg_data
4883: );

Line 4895: FND_MSG_PUB.Count_And_Get (

4891: WHEN FND_API.G_EXC_ERROR THEN
4892: ROLLBACK TO create_resp_mapping;
4893: x_return_status := FND_API.G_RET_STS_ERROR;
4894: -- Standard call to get message count and if count=1, get the message
4895: FND_MSG_PUB.Count_And_Get (
4896: p_encoded => FND_API.G_FALSE,
4897: p_count => x_msg_count,
4898: p_data => x_msg_data
4899: );

Line 4905: FND_MSG_PUB.Count_And_Get (

4901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4902: ROLLBACK TO create_resp_mapping;
4903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4904: -- Standard call to get message count and if count=1, get the message
4905: FND_MSG_PUB.Count_And_Get (
4906: p_encoded => FND_API.G_FALSE,
4907: p_count => x_msg_count,
4908: p_data => x_msg_data
4909: );

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

4910:
4911: WHEN OTHERS THEN
4912: ROLLBACK TO create_resp_mapping;
4913: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4914: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4915: THEN
4916: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4917: END IF;
4918: -- Standard call to get message count and if count=1, get the message

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

4912: ROLLBACK TO create_resp_mapping;
4913: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4914: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4915: THEN
4916: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4917: END IF;
4918: -- Standard call to get message count and if count=1, get the message
4919: FND_MSG_PUB.Count_And_Get (
4920: p_encoded => FND_API.G_FALSE,

Line 4919: FND_MSG_PUB.Count_And_Get (

4915: THEN
4916: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4917: END IF;
4918: -- Standard call to get message count and if count=1, get the message
4919: FND_MSG_PUB.Count_And_Get (
4920: p_encoded => FND_API.G_FALSE,
4921: p_count => x_msg_count,
4922: p_data => x_msg_data
4923: );

Line 4993: Fnd_Msg_Pub.initialize;

4989:
4990: -- Initialize message list if p_init_msg_list is set to TRUE.
4991: IF Fnd_Api.to_Boolean( p_init_msg_list )
4992: THEN
4993: Fnd_Msg_Pub.initialize;
4994: END IF;
4995:
4996: -- Debug Message
4997: IF (PV_DEBUG_HIGH_ON) THEN

Line 5008: FND_MSG_PUB.add;

5004: l_partner_ids_tbl := get_partners(p_user_id);
5005:
5006: IF (l_partner_ids_tbl.count = 0) THEN
5007: FND_MESSAGE.set_name('PV', 'PV_INVALID_PTNR_USER');
5008: FND_MSG_PUB.add;
5009: RAISE FND_API.G_EXC_ERROR;
5010: END IF;
5011:
5012: -- Get the program and store responsibility_id

Line 5047: FND_MSG_PUB.count_and_get(

5043: IF FND_API.to_boolean(p_commit) THEN
5044: COMMIT;
5045: END IF;
5046:
5047: FND_MSG_PUB.count_and_get(
5048: p_encoded => FND_API.g_false
5049: ,p_count => x_msg_count
5050: ,p_data => x_msg_data
5051: );

Line 5063: FND_MSG_PUB.Count_And_Get (

5059: WHEN FND_API.G_EXC_ERROR THEN
5060: ROLLBACK TO revoke_user_resps;
5061: x_return_status := FND_API.G_RET_STS_ERROR;
5062: -- Standard call to get message count and if count=1, get the message
5063: FND_MSG_PUB.Count_And_Get (
5064: p_encoded => FND_API.G_FALSE,
5065: p_count => x_msg_count,
5066: p_data => x_msg_data
5067: );

Line 5073: FND_MSG_PUB.Count_And_Get (

5069: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5070: ROLLBACK TO revoke_user_resps;
5071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5072: -- Standard call to get message count and if count=1, get the message
5073: FND_MSG_PUB.Count_And_Get (
5074: p_encoded => FND_API.G_FALSE,
5075: p_count => x_msg_count,
5076: p_data => x_msg_data
5077: );

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

5078:
5079: WHEN OTHERS THEN
5080: ROLLBACK TO revoke_user_resps;
5081: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5082: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5083: THEN
5084: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5085: END IF;
5086: -- Standard call to get message count and if count=1, get the message

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

5080: ROLLBACK TO revoke_user_resps;
5081: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5082: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5083: THEN
5084: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5085: END IF;
5086: -- Standard call to get message count and if count=1, get the message
5087: FND_MSG_PUB.Count_And_Get (
5088: p_encoded => FND_API.G_FALSE,

Line 5087: FND_MSG_PUB.Count_And_Get (

5083: THEN
5084: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5085: END IF;
5086: -- Standard call to get message count and if count=1, get the message
5087: FND_MSG_PUB.Count_And_Get (
5088: p_encoded => FND_API.G_FALSE,
5089: p_count => x_msg_count,
5090: p_data => x_msg_data
5091: );

Line 5140: Fnd_Msg_Pub.initialize;

5136:
5137: -- Initialize message list if p_init_msg_list is set to TRUE.
5138: IF Fnd_Api.to_Boolean( p_init_msg_list )
5139: THEN
5140: Fnd_Msg_Pub.initialize;
5141: END IF;
5142:
5143: -- Debug Message
5144: IF (PV_DEBUG_HIGH_ON) THEN

Line 5178: FND_MSG_PUB.count_and_get(

5174: IF FND_API.to_boolean(p_commit) THEN
5175: COMMIT;
5176: END IF;
5177:
5178: FND_MSG_PUB.count_and_get(
5179: p_encoded => FND_API.g_false
5180: ,p_count => x_msg_count
5181: ,p_data => x_msg_data
5182: );

Line 5194: FND_MSG_PUB.Count_And_Get (

5190: WHEN FND_API.G_EXC_ERROR THEN
5191: ROLLBACK TO revoke_user_resps;
5192: x_return_status := FND_API.G_RET_STS_ERROR;
5193: -- Standard call to get message count and if count=1, get the message
5194: FND_MSG_PUB.Count_And_Get (
5195: p_encoded => FND_API.G_FALSE,
5196: p_count => x_msg_count,
5197: p_data => x_msg_data
5198: );

Line 5204: FND_MSG_PUB.Count_And_Get (

5200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5201: ROLLBACK TO revoke_user_resps;
5202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5203: -- Standard call to get message count and if count=1, get the message
5204: FND_MSG_PUB.Count_And_Get (
5205: p_encoded => FND_API.G_FALSE,
5206: p_count => x_msg_count,
5207: p_data => x_msg_data
5208: );

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

5209:
5210: WHEN OTHERS THEN
5211: ROLLBACK TO revoke_user_resps;
5212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5213: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5214: THEN
5215: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5216: END IF;
5217: -- Standard call to get message count and if count=1, get the message

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

5211: ROLLBACK TO revoke_user_resps;
5212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5213: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5214: THEN
5215: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5216: END IF;
5217: -- Standard call to get message count and if count=1, get the message
5218: FND_MSG_PUB.Count_And_Get (
5219: p_encoded => FND_API.G_FALSE,

Line 5218: FND_MSG_PUB.Count_And_Get (

5214: THEN
5215: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5216: END IF;
5217: -- Standard call to get message count and if count=1, get the message
5218: FND_MSG_PUB.Count_And_Get (
5219: p_encoded => FND_API.G_FALSE,
5220: p_count => x_msg_count,
5221: p_data => x_msg_data
5222: );

Line 5280: Fnd_Msg_Pub.initialize;

5276:
5277: -- Initialize message list if p_init_msg_list is set to TRUE.
5278: IF Fnd_Api.to_Boolean( p_init_msg_list )
5279: THEN
5280: Fnd_Msg_Pub.initialize;
5281: END IF;
5282:
5283: -- Initialize API return status to SUCCESS
5284: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

Line 5289: FND_MSG_PUB.add;

5285:
5286: IF (p_resp_map_rule_id is null) THEN
5287: x_return_status := FND_API.G_RET_STS_ERROR;
5288: FND_MESSAGE.set_name('PV', 'PV_NO_RESP_MAP_RULE_ID');
5289: FND_MSG_PUB.add;
5290: RAISE FND_API.G_EXC_ERROR;
5291: END IF;
5292:
5293: IF (p_resp_id is null) THEN

Line 5296: FND_MSG_PUB.add;

5292:
5293: IF (p_resp_id is null) THEN
5294: x_return_status := FND_API.G_RET_STS_ERROR;
5295: FND_MESSAGE.set_name('PV', 'PV_NO_RESP_ID');
5296: FND_MSG_PUB.add;
5297: RAISE FND_API.G_EXC_ERROR;
5298: END IF;
5299:
5300: IF (p_program_id is null) THEN

Line 5303: FND_MSG_PUB.add;

5299:
5300: IF (p_program_id is null) THEN
5301: x_return_status := FND_API.G_RET_STS_ERROR;
5302: FND_MESSAGE.set_name('PV', 'PV_NO_PROGRAM_ID');
5303: FND_MSG_PUB.add;
5304: RAISE FND_API.G_EXC_ERROR;
5305: END IF;
5306:
5307: FOR x IN c_get_partner_and_program LOOP

Line 5372: FND_MSG_PUB.count_and_get(

5368: IF FND_API.to_boolean(p_commit) THEN
5369: COMMIT;
5370: END IF;
5371:
5372: FND_MSG_PUB.count_and_get(
5373: p_encoded => FND_API.g_false
5374: ,p_count => x_msg_count
5375: ,p_data => x_msg_data
5376: );

Line 5388: FND_MSG_PUB.Count_And_Get (

5384: WHEN FND_API.G_EXC_ERROR THEN
5385: ROLLBACK TO manage_store_resp_on_create;
5386: x_return_status := FND_API.G_RET_STS_ERROR;
5387: -- Standard call to get message count and if count=1, get the message
5388: FND_MSG_PUB.Count_And_Get (
5389: p_encoded => FND_API.G_FALSE,
5390: p_count => x_msg_count,
5391: p_data => x_msg_data
5392: );

Line 5398: FND_MSG_PUB.Count_And_Get (

5394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5395: ROLLBACK TO manage_store_resp_on_create;
5396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5397: -- Standard call to get message count and if count=1, get the message
5398: FND_MSG_PUB.Count_And_Get (
5399: p_encoded => FND_API.G_FALSE,
5400: p_count => x_msg_count,
5401: p_data => x_msg_data
5402: );

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

5403:
5404: WHEN OTHERS THEN
5405: ROLLBACK TO manage_store_resp_on_create;
5406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5407: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5408: THEN
5409: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5410: END IF;
5411: -- Standard call to get message count and if count=1, get the message

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

5405: ROLLBACK TO manage_store_resp_on_create;
5406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5407: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5408: THEN
5409: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5410: END IF;
5411: -- Standard call to get message count and if count=1, get the message
5412: FND_MSG_PUB.Count_And_Get (
5413: p_encoded => FND_API.G_FALSE,

Line 5412: FND_MSG_PUB.Count_And_Get (

5408: THEN
5409: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5410: END IF;
5411: -- Standard call to get message count and if count=1, get the message
5412: FND_MSG_PUB.Count_And_Get (
5413: p_encoded => FND_API.G_FALSE,
5414: p_count => x_msg_count,
5415: p_data => x_msg_data
5416: );

Line 5498: Fnd_Msg_Pub.initialize;

5494:
5495: -- Initialize message list if p_init_msg_list is set to TRUE.
5496: IF Fnd_Api.to_Boolean( p_init_msg_list )
5497: THEN
5498: Fnd_Msg_Pub.initialize;
5499: END IF;
5500:
5501: --Debug_Log('priflie: ' || fnd_profile.VALUE('FND_AS_MSG_LEVEL_THRESHOLD'));
5502: -- Debug Message

Line 5513: FND_MSG_PUB.add;

5509:
5510: IF (p_resp_map_rule_id is null) THEN
5511: x_return_status := FND_API.G_RET_STS_ERROR;
5512: FND_MESSAGE.set_name('PV', 'PV_NO_RESP_MAP_RULE_ID');
5513: FND_MSG_PUB.add;
5514: RAISE FND_API.G_EXC_ERROR;
5515: END IF;
5516:
5517: FOR x IN c_get_ptnr_resps_info LOOP

Line 5597: FND_MSG_PUB.count_and_get(

5593: IF FND_API.to_boolean(p_commit) THEN
5594: COMMIT;
5595: END IF;
5596:
5597: FND_MSG_PUB.count_and_get(
5598: p_encoded => FND_API.g_false
5599: ,p_count => x_msg_count
5600: ,p_data => x_msg_data
5601: );

Line 5613: FND_MSG_PUB.Count_And_Get (

5609: WHEN FND_API.G_EXC_ERROR THEN
5610: ROLLBACK TO manage_store_resp_on_delete;
5611: x_return_status := FND_API.G_RET_STS_ERROR;
5612: -- Standard call to get message count and if count=1, get the message
5613: FND_MSG_PUB.Count_And_Get (
5614: p_encoded => FND_API.G_FALSE,
5615: p_count => x_msg_count,
5616: p_data => x_msg_data
5617: );

Line 5623: FND_MSG_PUB.Count_And_Get (

5619: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5620: ROLLBACK TO manage_store_resp_on_delete;
5621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5622: -- Standard call to get message count and if count=1, get the message
5623: FND_MSG_PUB.Count_And_Get (
5624: p_encoded => FND_API.G_FALSE,
5625: p_count => x_msg_count,
5626: p_data => x_msg_data
5627: );

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

5628:
5629: WHEN OTHERS THEN
5630: ROLLBACK TO manage_store_resp_on_delete;
5631: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5632: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5633: THEN
5634: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5635: END IF;
5636: -- Standard call to get message count and if count=1, get the message

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

5630: ROLLBACK TO manage_store_resp_on_delete;
5631: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5632: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5633: THEN
5634: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5635: END IF;
5636: -- Standard call to get message count and if count=1, get the message
5637: FND_MSG_PUB.Count_And_Get (
5638: p_encoded => FND_API.G_FALSE,

Line 5637: FND_MSG_PUB.Count_And_Get (

5633: THEN
5634: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5635: END IF;
5636: -- Standard call to get message count and if count=1, get the message
5637: FND_MSG_PUB.Count_And_Get (
5638: p_encoded => FND_API.G_FALSE,
5639: p_count => x_msg_count,
5640: p_data => x_msg_data
5641: );

Line 5773: Fnd_Msg_Pub.initialize;

5769:
5770: -- Initialize message list if p_init_msg_list is set to TRUE.
5771: IF Fnd_Api.to_Boolean( p_init_msg_list )
5772: THEN
5773: Fnd_Msg_Pub.initialize;
5774: END IF;
5775:
5776: -- Debug Message
5777: IF (PV_DEBUG_HIGH_ON) THEN

Line 5856: FND_MSG_PUB.add;

5852: ,x_ptnr_resp_id => l_ptnr_resp_id
5853: );
5854: ELSE
5855: FND_MESSAGE.set_name('PV', 'PV_NO_DEFAULT_RESP');
5856: FND_MSG_PUB.add;
5857: RAISE FND_API.G_EXC_ERROR;
5858: END IF;
5859:
5860: -- Get the default resp for business users

Line 5931: FND_MSG_PUB.add;

5927: ,x_ptnr_resp_id => l_ptnr_resp_id
5928: );
5929: ELSE
5930: FND_MESSAGE.set_name('PV', 'PV_NO_DEFAULT_RESP');
5931: FND_MSG_PUB.add;
5932: RAISE FND_API.G_EXC_ERROR;
5933: END IF;
5934:
5935: EXCEPTION

Line 5945: FND_MSG_PUB.Count_And_Get (

5941: WHEN FND_API.G_EXC_ERROR THEN
5942: ROLLBACK TO assign_default_resp;
5943: x_return_status := FND_API.G_RET_STS_ERROR;
5944: -- Standard call to get message count and if count=1, get the message
5945: FND_MSG_PUB.Count_And_Get (
5946: p_encoded => FND_API.G_FALSE,
5947: p_count => x_msg_count,
5948: p_data => x_msg_data
5949: );

Line 5955: FND_MSG_PUB.Count_And_Get (

5951: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5952: ROLLBACK TO assign_default_resp;
5953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5954: -- Standard call to get message count and if count=1, get the message
5955: FND_MSG_PUB.Count_And_Get (
5956: p_encoded => FND_API.G_FALSE,
5957: p_count => x_msg_count,
5958: p_data => x_msg_data
5959: );

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

5960:
5961: WHEN OTHERS THEN
5962: ROLLBACK TO assign_default_resp;
5963: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5964: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5965: THEN
5966: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5967: END IF;
5968: -- Standard call to get message count and if count=1, get the message

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

5962: ROLLBACK TO assign_default_resp;
5963: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5964: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5965: THEN
5966: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5967: END IF;
5968: -- Standard call to get message count and if count=1, get the message
5969: FND_MSG_PUB.Count_And_Get (
5970: p_encoded => FND_API.G_FALSE,

Line 5969: FND_MSG_PUB.Count_And_Get (

5965: THEN
5966: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5967: END IF;
5968: -- Standard call to get message count and if count=1, get the message
5969: FND_MSG_PUB.Count_And_Get (
5970: p_encoded => FND_API.G_FALSE,
5971: p_count => x_msg_count,
5972: p_data => x_msg_data
5973: );

Line 6039: Fnd_Msg_Pub.initialize;

6035:
6036: -- Initialize message list if p_init_msg_list is set to TRUE.
6037: IF Fnd_Api.to_Boolean( p_init_msg_list )
6038: THEN
6039: Fnd_Msg_Pub.initialize;
6040: END IF;
6041:
6042: -- Debug Message
6043: IF (PV_DEBUG_HIGH_ON) THEN

Line 6316: FND_MSG_PUB.count_and_get(

6312: IF FND_API.to_boolean(p_commit) THEN
6313: COMMIT;
6314: END IF;
6315:
6316: FND_MSG_PUB.count_and_get(
6317: p_encoded => FND_API.g_false
6318: ,p_count => x_msg_count
6319: ,p_data => x_msg_data
6320: );

Line 6331: FND_MSG_PUB.Count_And_Get (

6327: WHEN FND_API.G_EXC_ERROR THEN
6328: ROLLBACK TO manage_resp_on_address_change;
6329: x_return_status := FND_API.G_RET_STS_ERROR;
6330: -- Standard call to get message count and if count=1, get the message
6331: FND_MSG_PUB.Count_And_Get (
6332: p_encoded => FND_API.G_FALSE,
6333: p_count => x_msg_count,
6334: p_data => x_msg_data
6335: );

Line 6341: FND_MSG_PUB.Count_And_Get (

6337: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6338: ROLLBACK TO manage_resp_on_address_change;
6339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6340: -- Standard call to get message count and if count=1, get the message
6341: FND_MSG_PUB.Count_And_Get (
6342: p_encoded => FND_API.G_FALSE,
6343: p_count => x_msg_count,
6344: p_data => x_msg_data
6345: );

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

6346:
6347: WHEN OTHERS THEN
6348: ROLLBACK TO manage_resp_on_address_change;
6349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6350: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6351: THEN
6352: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6353: END IF;
6354: -- Standard call to get message count and if count=1, get the message

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

6348: ROLLBACK TO manage_resp_on_address_change;
6349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6350: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6351: THEN
6352: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6353: END IF;
6354: -- Standard call to get message count and if count=1, get the message
6355: FND_MSG_PUB.Count_And_Get (
6356: p_encoded => FND_API.G_FALSE,

Line 6355: FND_MSG_PUB.Count_And_Get (

6351: THEN
6352: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6353: END IF;
6354: -- Standard call to get message count and if count=1, get the message
6355: FND_MSG_PUB.Count_And_Get (
6356: p_encoded => FND_API.G_FALSE,
6357: p_count => x_msg_count,
6358: p_data => x_msg_data
6359: );

Line 6411: Fnd_Msg_Pub.initialize;

6407:
6408: -- Initialize message list if p_init_msg_list is set to TRUE.
6409: IF Fnd_Api.to_Boolean( p_init_msg_list )
6410: THEN
6411: Fnd_Msg_Pub.initialize;
6412: END IF;
6413: /*
6414: Pvx_Utility_Pvt.debug_message('g_log_to_file... = ' || g_log_to_file);
6415:

Line 6418: FND_MSG_PUB.add;

6414: Pvx_Utility_Pvt.debug_message('g_log_to_file... = ' || g_log_to_file);
6415:
6416: FND_MESSAGE.set_name('PV', 'PV_DEBUG_MESSAGE');
6417: FND_MESSAGE.set_token('TEXT', g_log_to_file);
6418: FND_MSG_PUB.add;
6419: */
6420: -- Debug Message
6421: IF (PV_DEBUG_HIGH_ON) THEN
6422: Debug_Log('PRIVATE API: ' || l_api_name || ' - START');

Line 6503: FND_MSG_PUB.count_and_get(

6499: IF FND_API.to_boolean(p_commit) THEN
6500: COMMIT;
6501: END IF;
6502:
6503: FND_MSG_PUB.count_and_get(
6504: p_encoded => FND_API.g_false
6505: ,p_count => x_msg_count
6506: ,p_data => x_msg_data
6507: );

Line 6519: FND_MSG_PUB.Count_And_Get (

6515: WHEN FND_API.G_EXC_ERROR THEN
6516: ROLLBACK TO revoke_default_resp;
6517: x_return_status := FND_API.G_RET_STS_ERROR;
6518: -- Standard call to get message count and if count=1, get the message
6519: FND_MSG_PUB.Count_And_Get (
6520: p_encoded => FND_API.G_FALSE,
6521: p_count => x_msg_count,
6522: p_data => x_msg_data
6523: );

Line 6529: FND_MSG_PUB.Count_And_Get (

6525: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6526: ROLLBACK TO revoke_default_resp;
6527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6528: -- Standard call to get message count and if count=1, get the message
6529: FND_MSG_PUB.Count_And_Get (
6530: p_encoded => FND_API.G_FALSE,
6531: p_count => x_msg_count,
6532: p_data => x_msg_data
6533: );

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

6534:
6535: WHEN OTHERS THEN
6536: ROLLBACK TO revoke_default_resp;
6537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6538: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6539: THEN
6540: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6541: END IF;
6542: -- Standard call to get message count and if count=1, get the message

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

6536: ROLLBACK TO revoke_default_resp;
6537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6538: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6539: THEN
6540: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6541: END IF;
6542: -- Standard call to get message count and if count=1, get the message
6543: FND_MSG_PUB.Count_And_Get (
6544: p_encoded => FND_API.G_FALSE,

Line 6543: FND_MSG_PUB.Count_And_Get (

6539: THEN
6540: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6541: END IF;
6542: -- Standard call to get message count and if count=1, get the message
6543: FND_MSG_PUB.Count_And_Get (
6544: p_encoded => FND_API.G_FALSE,
6545: p_count => x_msg_count,
6546: p_data => x_msg_data
6547: );

Line 6607: Fnd_Msg_Pub.initialize;

6603:
6604: -- Initialize message list if p_init_msg_list is set to TRUE.
6605: IF Fnd_Api.to_Boolean( p_init_msg_list )
6606: THEN
6607: Fnd_Msg_Pub.initialize;
6608: END IF;
6609:
6610: -- Debug Message
6611: IF (PV_DEBUG_HIGH_ON) THEN

Line 6688: FND_MSG_PUB.count_and_get(

6684: IF FND_API.to_boolean(p_commit) THEN
6685: COMMIT;
6686: END IF;
6687:
6688: FND_MSG_PUB.count_and_get(
6689: p_encoded => FND_API.g_false
6690: ,p_count => x_msg_count
6691: ,p_data => x_msg_data
6692: );

Line 6704: FND_MSG_PUB.Count_And_Get (

6700: WHEN FND_API.G_EXC_ERROR THEN
6701: ROLLBACK TO assign_user_resps;
6702: x_return_status := FND_API.G_RET_STS_ERROR;
6703: -- Standard call to get message count and if count=1, get the message
6704: FND_MSG_PUB.Count_And_Get (
6705: p_encoded => FND_API.G_FALSE,
6706: p_count => x_msg_count,
6707: p_data => x_msg_data
6708: );

Line 6714: FND_MSG_PUB.Count_And_Get (

6710: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6711: ROLLBACK TO assign_user_resps;
6712: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6713: -- Standard call to get message count and if count=1, get the message
6714: FND_MSG_PUB.Count_And_Get (
6715: p_encoded => FND_API.G_FALSE,
6716: p_count => x_msg_count,
6717: p_data => x_msg_data
6718: );

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

6719:
6720: WHEN OTHERS THEN
6721: ROLLBACK TO assign_user_resps;
6722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6723: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6724: THEN
6725: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6726: END IF;
6727: -- Standard call to get message count and if count=1, get the message

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

6721: ROLLBACK TO assign_user_resps;
6722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6723: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6724: THEN
6725: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6726: END IF;
6727: -- Standard call to get message count and if count=1, get the message
6728: FND_MSG_PUB.Count_And_Get (
6729: p_encoded => FND_API.G_FALSE,

Line 6728: FND_MSG_PUB.Count_And_Get (

6724: THEN
6725: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6726: END IF;
6727: -- Standard call to get message count and if count=1, get the message
6728: FND_MSG_PUB.Count_And_Get (
6729: p_encoded => FND_API.G_FALSE,
6730: p_count => x_msg_count,
6731: p_data => x_msg_data
6732: );

Line 6819: fnd_msg_pub.reset;

6815:
6816: WHEN exc_error THEN
6817: Debug_Log('------------exc_error-----------------');
6818: IF l_msg_count > 1 THEN
6819: fnd_msg_pub.reset;
6820: FOR i IN 1..l_msg_count LOOP
6821: Debug_Log(fnd_msg_pub.get(p_encoded => fnd_api.g_false));
6822: END LOOP;
6823: ELSE

Line 6821: Debug_Log(fnd_msg_pub.get(p_encoded => fnd_api.g_false));

6817: Debug_Log('------------exc_error-----------------');
6818: IF l_msg_count > 1 THEN
6819: fnd_msg_pub.reset;
6820: FOR i IN 1..l_msg_count LOOP
6821: Debug_Log(fnd_msg_pub.get(p_encoded => fnd_api.g_false));
6822: END LOOP;
6823: ELSE
6824: Debug_Log(l_msg_data);
6825: END IF;

Line 6911: fnd_msg_pub.reset;

6907:
6908: WHEN exc_error THEN
6909: Debug_Log('------------exc_error-----------------');
6910: IF l_msg_count > 1 THEN
6911: fnd_msg_pub.reset;
6912: FOR i IN 1..l_msg_count LOOP
6913: Debug_Log(fnd_msg_pub.get(p_encoded => fnd_api.g_false));
6914: END LOOP;
6915: ELSE

Line 6913: Debug_Log(fnd_msg_pub.get(p_encoded => fnd_api.g_false));

6909: Debug_Log('------------exc_error-----------------');
6910: IF l_msg_count > 1 THEN
6911: fnd_msg_pub.reset;
6912: FOR i IN 1..l_msg_count LOOP
6913: Debug_Log(fnd_msg_pub.get(p_encoded => fnd_api.g_false));
6914: END LOOP;
6915: ELSE
6916: Debug_Log(l_msg_data);
6917: END IF;

Line 6971: FND_MSG_PUB.initialize;

6967: AND ppp.partner_party_id = hzps.party_id
6968: AND ppp.status = 'A';
6969:
6970: BEGIN
6971: FND_MSG_PUB.initialize;
6972:
6973: IF (PV_DEBUG_HIGH_ON) THEN
6974: WRITE_LOG(l_api_name, 'Start manage_resp_on_address_change');
6975: END IF;

Line 7137: Fnd_Msg_Pub.initialize;

7133:
7134: -- Initialize message list if p_init_msg_list is set to TRUE.
7135: IF Fnd_Api.to_Boolean( p_init_msg_list )
7136: THEN
7137: Fnd_Msg_Pub.initialize;
7138: END IF;
7139:
7140: -- Debug Message
7141: Debug_Log('PRIVATE API: ' || l_api_name || ' - START');

Line 7281: FND_MSG_PUB.add;

7277: RAISE FND_API.G_EXC_ERROR;
7278: END IF;
7279: ELSE
7280: FND_MESSAGE.set_name('PV', 'PV_NO_DEFAULT_RESP');
7281: FND_MSG_PUB.add;
7282: RAISE FND_API.G_EXC_ERROR;
7283: END IF; -- End of IF (l_responsibility_id is not null) and (l_resp_map_rule_id is not null)
7284: END IF; -- End of IF (l_resp_exist = 'N')
7285: END IF; -- End of IF (c_is_business_user_exist%NOTFOUND)

Line 7359: FND_MSG_PUB.count_and_get(

7355: IF FND_API.to_boolean(p_commit) THEN
7356: COMMIT;
7357: END IF;
7358:
7359: FND_MSG_PUB.count_and_get(
7360: p_encoded => FND_API.g_false
7361: ,p_count => x_msg_count
7362: ,p_data => x_msg_data
7363: );

Line 7375: FND_MSG_PUB.Count_And_Get (

7371: WHEN FND_API.G_EXC_ERROR THEN
7372: ROLLBACK TO manage_merged_party_memb_resp;
7373: x_return_status := FND_API.G_RET_STS_ERROR;
7374: -- Standard call to get message count and if count=1, get the message
7375: FND_MSG_PUB.Count_And_Get (
7376: p_encoded => FND_API.G_FALSE,
7377: p_count => x_msg_count,
7378: p_data => x_msg_data
7379: );

Line 7385: FND_MSG_PUB.Count_And_Get (

7381: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7382: ROLLBACK TO manage_merged_party_memb_resp;
7383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7384: -- Standard call to get message count and if count=1, get the message
7385: FND_MSG_PUB.Count_And_Get (
7386: p_encoded => FND_API.G_FALSE,
7387: p_count => x_msg_count,
7388: p_data => x_msg_data
7389: );

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

7390:
7391: WHEN OTHERS THEN
7392: ROLLBACK TO manage_merged_party_memb_resp;
7393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7394: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7395: THEN
7396: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
7397: END IF;
7398: -- Standard call to get message count and if count=1, get the message

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

7392: ROLLBACK TO manage_merged_party_memb_resp;
7393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7394: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7395: THEN
7396: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
7397: END IF;
7398: -- Standard call to get message count and if count=1, get the message
7399: FND_MSG_PUB.Count_And_Get (
7400: p_encoded => FND_API.G_FALSE,

Line 7399: FND_MSG_PUB.Count_And_Get (

7395: THEN
7396: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
7397: END IF;
7398: -- Standard call to get message count and if count=1, get the message
7399: FND_MSG_PUB.Count_And_Get (
7400: p_encoded => FND_API.G_FALSE,
7401: p_count => x_msg_count,
7402: p_data => x_msg_data
7403: );