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.AMS_PARTYIMPORT_PVT dependencies on FND_MSG_PUB

Line 35: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

31:
32: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AMS_PartyImport_PVT';
33:
34:
35: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
36: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
37: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
38:
39: PROCEDURE Check_Party_Req_Items (

Line 36: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

32: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AMS_PartyImport_PVT';
33:
34:
35: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
36: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
37: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
38:
39: PROCEDURE Check_Party_Req_Items (
40: p_party_rec IN Party_Rec_Type,

Line 37: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

33:
34:
35: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
36: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
37: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
38:
39: PROCEDURE Check_Party_Req_Items (
40: p_party_rec IN Party_Rec_Type,
41: x_return_status OUT NOCOPY VARCHAR2

Line 127: FND_MSG_PUB.initialize;

123:
124: END IF;
125:
126: IF FND_API.to_boolean (p_init_msg_list) THEN
127: FND_MSG_PUB.initialize;
128: END IF;
129:
130: IF NOT FND_API.compatible_api_call(
131: l_api_version,

Line 737: FND_MSG_PUB.count_and_get(

733: IF FND_API.to_boolean(p_commit) THEN
734: COMMIT;
735: END IF;
736:
737: FND_MSG_PUB.count_and_get(
738: p_encoded => FND_API.g_false,
739: p_count => x_msg_count,
740: p_data => x_msg_data
741: );

Line 755: FND_MSG_PUB.count_and_get (

751: EXCEPTION
752: WHEN FND_API.g_exc_error THEN
753: ROLLBACK TO Create_Party;
754: x_return_status := FND_API.g_ret_sts_error;
755: FND_MSG_PUB.count_and_get (
756: p_encoded => FND_API.g_false,
757: p_count => x_msg_count,
758: p_data => x_msg_data
759: );

Line 763: FND_MSG_PUB.count_and_get (

759: );
760: WHEN FND_API.g_exc_unexpected_error THEN
761: ROLLBACK TO Create_Party;
762: x_return_status := FND_API.g_ret_sts_unexp_error ;
763: FND_MSG_PUB.count_and_get (
764: p_encoded => FND_API.g_false,
765: p_count => x_msg_count,
766: p_data => x_msg_data
767: );

Line 772: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error)

768: WHEN OTHERS THEN
769: ROLLBACK TO Create_Party;
770: x_return_status := FND_API.g_ret_sts_unexp_error ;
771:
772: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error)
773: THEN
774: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
775: END IF;
776:

Line 774: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

770: x_return_status := FND_API.g_ret_sts_unexp_error ;
771:
772: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error)
773: THEN
774: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
775: END IF;
776:
777: FND_MSG_PUB.count_and_get(
778: p_encoded => FND_API.g_false,

Line 777: FND_MSG_PUB.count_and_get(

773: THEN
774: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
775: END IF;
776:
777: FND_MSG_PUB.count_and_get(
778: p_encoded => FND_API.g_false,
779: p_count => x_msg_count,
780: p_data => x_msg_data
781: );

Line 818: FND_MSG_PUB.initialize;

814:
815: END IF;
816:
817: IF FND_API.to_boolean (p_init_msg_list) THEN
818: FND_MSG_PUB.initialize;
819: END IF;
820:
821: IF NOT FND_API.compatible_api_call (
822: l_api_version,

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

834: WHERE party_sources_id = p_party_sources_id
835: AND object_version_number = p_object_version;
836:
837: IF (SQL%NOTFOUND) THEN
838: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
839: THEN
840: FND_MESSAGE.set_name ('AMS', 'AMS_API_RECORD_NOT_FOUND');
841: FND_MSG_PUB.add;
842: END IF;

Line 841: FND_MSG_PUB.add;

837: IF (SQL%NOTFOUND) THEN
838: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
839: THEN
840: FND_MESSAGE.set_name ('AMS', 'AMS_API_RECORD_NOT_FOUND');
841: FND_MSG_PUB.add;
842: END IF;
843: RAISE FND_API.g_exc_error;
844: END IF;
845:

Line 851: FND_MSG_PUB.count_and_get (

847: IF FND_API.to_boolean (p_commit) THEN
848: COMMIT;
849: END IF;
850:
851: FND_MSG_PUB.count_and_get (
852: p_encoded => FND_API.g_false,
853: p_count => x_msg_count,
854: p_data => x_msg_data
855: );

Line 869: FND_MSG_PUB.count_and_get (

865: EXCEPTION
866: WHEN FND_API.g_exc_error THEN
867: ROLLBACK TO Delete_Party;
868: x_return_status := FND_API.g_ret_sts_error;
869: FND_MSG_PUB.count_and_get (
870: p_encoded => FND_API.g_false,
871: p_count => x_msg_count,
872: p_data => x_msg_data
873: );

Line 877: FND_MSG_PUB.count_and_get (

873: );
874: WHEN FND_API.g_exc_unexpected_error THEN
875: ROLLBACK TO Delete_Party;
876: x_return_status := FND_API.g_ret_sts_unexp_error ;
877: FND_MSG_PUB.count_and_get (
878: p_encoded => FND_API.g_false,
879: p_count => x_msg_count,
880: p_data => x_msg_data
881: );

Line 886: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error)

882: WHEN OTHERS THEN
883: ROLLBACK TO Delete_Party;
884: x_return_status := FND_API.g_ret_sts_unexp_error ;
885:
886: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error)
887: THEN
888: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
889: END IF;
890:

Line 888: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

884: x_return_status := FND_API.g_ret_sts_unexp_error ;
885:
886: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error)
887: THEN
888: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
889: END IF;
890:
891: FND_MSG_PUB.count_and_get (
892: p_encoded => FND_API.g_false,

Line 891: FND_MSG_PUB.count_and_get (

887: THEN
888: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
889: END IF;
890:
891: FND_MSG_PUB.count_and_get (
892: p_encoded => FND_API.g_false,
893: p_count => x_msg_count,
894: p_data => x_msg_data
895: );

Line 943: FND_MSG_PUB.initialize;

939: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
940: END IF;
941:
942: IF FND_API.to_boolean (p_init_msg_list) THEN
943: FND_MSG_PUB.initialize;
944: END IF;
945:
946: IF NOT FND_API.compatible_api_call (
947: l_api_version,

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

958: OPEN c_lock_req;
959: FETCH c_lock_req INTO l_dummy;
960: IF c_lock_req%NOTFOUND THEN
961: CLOSE c_lock_req;
962: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
963: FND_MESSAGE.set_name ('AMS', 'AMS_API_RECORD_NOT_FOUND');
964: FND_MSG_PUB.add;
965: END IF;
966: RAISE FND_API.g_exc_error;

Line 964: FND_MSG_PUB.add;

960: IF c_lock_req%NOTFOUND THEN
961: CLOSE c_lock_req;
962: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
963: FND_MESSAGE.set_name ('AMS', 'AMS_API_RECORD_NOT_FOUND');
964: FND_MSG_PUB.add;
965: END IF;
966: RAISE FND_API.g_exc_error;
967: END IF;
968: CLOSE c_lock_req;

Line 971: FND_MSG_PUB.count_and_get (

967: END IF;
968: CLOSE c_lock_req;
969:
970: -------------------- finish --------------------------
971: FND_MSG_PUB.count_and_get (
972: p_encoded => FND_API.g_false,
973: p_count => x_msg_count,
974: p_data => x_msg_data
975: );

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

984:
985: EXCEPTION
986: WHEN AMS_Utility_PVT.resource_locked THEN
987: x_return_status := FND_API.g_ret_sts_error;
988: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
989: FND_MESSAGE.set_name ('AMS', 'AMS_API_RESOURCE_LOCKED');
990: FND_MSG_PUB.add;
991: END IF;
992:

Line 990: FND_MSG_PUB.add;

986: WHEN AMS_Utility_PVT.resource_locked THEN
987: x_return_status := FND_API.g_ret_sts_error;
988: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
989: FND_MESSAGE.set_name ('AMS', 'AMS_API_RESOURCE_LOCKED');
990: FND_MSG_PUB.add;
991: END IF;
992:
993: FND_MSG_PUB.count_and_get(
994: p_encoded => FND_API.g_false,

Line 993: FND_MSG_PUB.count_and_get(

989: FND_MESSAGE.set_name ('AMS', 'AMS_API_RESOURCE_LOCKED');
990: FND_MSG_PUB.add;
991: END IF;
992:
993: FND_MSG_PUB.count_and_get(
994: p_encoded => FND_API.g_false,
995: p_count => x_msg_count,
996: p_data => x_msg_data
997: );

Line 1000: FND_MSG_PUB.count_and_get (

996: p_data => x_msg_data
997: );
998: WHEN FND_API.g_exc_error THEN
999: x_return_status := FND_API.g_ret_sts_error;
1000: FND_MSG_PUB.count_and_get (
1001: p_encoded => FND_API.g_false,
1002: p_count => x_msg_count,
1003: p_data => x_msg_data
1004: );

Line 1007: FND_MSG_PUB.count_and_get (

1003: p_data => x_msg_data
1004: );
1005: WHEN FND_API.g_exc_unexpected_error THEN
1006: x_return_status := FND_API.g_ret_sts_unexp_error ;
1007: FND_MSG_PUB.count_and_get (
1008: p_encoded => FND_API.g_false,
1009: p_count => x_msg_count,
1010: p_data => x_msg_data
1011: );

Line 1014: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error)

1010: p_data => x_msg_data
1011: );
1012: WHEN OTHERS THEN
1013: x_return_status := FND_API.g_ret_sts_unexp_error ;
1014: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error)
1015: THEN
1016: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1017: END IF;
1018:

Line 1016: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

1012: WHEN OTHERS THEN
1013: x_return_status := FND_API.g_ret_sts_unexp_error ;
1014: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error)
1015: THEN
1016: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1017: END IF;
1018:
1019: FND_MSG_PUB.count_and_get (
1020: p_encoded => FND_API.g_false,

Line 1019: FND_MSG_PUB.count_and_get (

1015: THEN
1016: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1017: END IF;
1018:
1019: FND_MSG_PUB.count_and_get (
1020: p_encoded => FND_API.g_false,
1021: p_count => x_msg_count,
1022: p_data => x_msg_data
1023: );

Line 1062: FND_MSG_PUB.initialize;

1058:
1059: END IF;
1060:
1061: IF FND_API.to_boolean (p_init_msg_list) THEN
1062: FND_MSG_PUB.initialize;
1063: END IF;
1064:
1065: IF NOT FND_API.compatible_api_call(
1066: l_api_version,

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

1378: WHERE party_sources_id = l_party_rec.party_sources_id
1379: AND object_version_number = l_party_rec.object_version_number;
1380:
1381: IF (SQL%NOTFOUND) THEN
1382: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1383: FND_MESSAGE.set_name ('AMS', 'AMS_API_RECORD_NOT_FOUND');
1384: FND_MSG_PUB.add;
1385: END IF;
1386: RAISE FND_API.g_exc_error;

Line 1384: FND_MSG_PUB.add;

1380:
1381: IF (SQL%NOTFOUND) THEN
1382: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1383: FND_MESSAGE.set_name ('AMS', 'AMS_API_RECORD_NOT_FOUND');
1384: FND_MSG_PUB.add;
1385: END IF;
1386: RAISE FND_API.g_exc_error;
1387: END IF;
1388:

Line 1394: FND_MSG_PUB.count_and_get (

1390: IF FND_API.to_boolean (p_commit) THEN
1391: COMMIT;
1392: END IF;
1393:
1394: FND_MSG_PUB.count_and_get (
1395: p_encoded => FND_API.g_false,
1396: p_count => x_msg_count,
1397: p_data => x_msg_data
1398: );

Line 1412: FND_MSG_PUB.count_and_get (

1408: EXCEPTION
1409: WHEN FND_API.g_exc_error THEN
1410: ROLLBACK TO Update_Party;
1411: x_return_status := FND_API.g_ret_sts_error;
1412: FND_MSG_PUB.count_and_get (
1413: p_encoded => FND_API.g_false,
1414: p_count => x_msg_count,
1415: p_data => x_msg_data
1416: );

Line 1420: FND_MSG_PUB.count_and_get (

1416: );
1417: WHEN FND_API.g_exc_unexpected_error THEN
1418: ROLLBACK TO Update_Party;
1419: x_return_status := FND_API.g_ret_sts_unexp_error ;
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 1429: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error)

1425: WHEN OTHERS THEN
1426: ROLLBACK TO Update_Party;
1427: x_return_status := FND_API.g_ret_sts_unexp_error ;
1428:
1429: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error)
1430: THEN
1431: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1432: END IF;
1433:

Line 1431: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

1427: x_return_status := FND_API.g_ret_sts_unexp_error ;
1428:
1429: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error)
1430: THEN
1431: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1432: END IF;
1433:
1434: FND_MSG_PUB.count_and_get (
1435: p_encoded => FND_API.g_false,

Line 1434: FND_MSG_PUB.count_and_get (

1430: THEN
1431: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1432: END IF;
1433:
1434: FND_MSG_PUB.count_and_get (
1435: p_encoded => FND_API.g_false,
1436: p_count => x_msg_count,
1437: p_data => x_msg_data
1438: );

Line 1471: FND_MSG_PUB.initialize;

1467: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
1468: END IF;
1469:
1470: IF FND_API.to_boolean (p_init_msg_list) THEN
1471: FND_MSG_PUB.initialize;
1472: END IF;
1473:
1474: IF NOT FND_API.compatible_api_call (
1475: l_api_version,

Line 1528: FND_MSG_PUB.count_and_get (

1524: END IF;
1525: END IF;
1526:
1527: -------------------- finish --------------------------
1528: FND_MSG_PUB.count_and_get (
1529: p_encoded => FND_API.g_false,
1530: p_count => x_msg_count,
1531: p_data => x_msg_data
1532: );

Line 1545: FND_MSG_PUB.count_and_get (

1541:
1542: EXCEPTION
1543: WHEN FND_API.g_exc_error THEN
1544: x_return_status := FND_API.g_ret_sts_error;
1545: FND_MSG_PUB.count_and_get (
1546: p_encoded => FND_API.g_false,
1547: p_count => x_msg_count,
1548: p_data => x_msg_data
1549: );

Line 1552: FND_MSG_PUB.count_and_get (

1548: p_data => x_msg_data
1549: );
1550: WHEN FND_API.g_exc_unexpected_error THEN
1551: x_return_status := FND_API.g_ret_sts_unexp_error ;
1552: FND_MSG_PUB.count_and_get (
1553: p_encoded => FND_API.g_false,
1554: p_count => x_msg_count,
1555: p_data => x_msg_data
1556: );

Line 1559: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error)

1555: p_data => x_msg_data
1556: );
1557: WHEN OTHERS THEN
1558: x_return_status := FND_API.g_ret_sts_unexp_error;
1559: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error)
1560: THEN
1561: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1562: END IF;
1563:

Line 1561: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

1557: WHEN OTHERS THEN
1558: x_return_status := FND_API.g_ret_sts_unexp_error;
1559: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error)
1560: THEN
1561: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1562: END IF;
1563:
1564: FND_MSG_PUB.count_and_get (
1565: p_encoded => FND_API.g_false,

Line 1564: FND_MSG_PUB.count_and_get (

1560: THEN
1561: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1562: END IF;
1563:
1564: FND_MSG_PUB.count_and_get (
1565: p_encoded => FND_API.g_false,
1566: p_count => x_msg_count,
1567: p_data => x_msg_data
1568: );

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

2004: OPEN c_party;
2005: FETCH c_party INTO l_party_rec;
2006: IF c_party%NOTFOUND THEN
2007: CLOSE c_party;
2008: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2009: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2010: FND_MSG_PUB.add;
2011: END IF;
2012: RAISE FND_API.g_exc_error;

Line 2010: FND_MSG_PUB.add;

2006: IF c_party%NOTFOUND THEN
2007: CLOSE c_party;
2008: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2009: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2010: FND_MSG_PUB.add;
2011: END IF;
2012: RAISE FND_API.g_exc_error;
2013: END IF;
2014: CLOSE c_party;

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

3359: x_return_status := FND_API.g_ret_sts_success;
3360:
3361: -- PARTY_ID
3362: IF p_party_rec.party_id IS NULL THEN
3363: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
3364: FND_MESSAGE.set_name ('AMS', 'AMS_PARTY_NO_PARTY_ID');
3365: FND_MSG_PUB.add;
3366: END IF;
3367:

Line 3365: FND_MSG_PUB.add;

3361: -- PARTY_ID
3362: IF p_party_rec.party_id IS NULL THEN
3363: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
3364: FND_MESSAGE.set_name ('AMS', 'AMS_PARTY_NO_PARTY_ID');
3365: FND_MSG_PUB.add;
3366: END IF;
3367:
3368: x_return_status := FND_API.g_ret_sts_error;
3369: RETURN;

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

3370: END IF;
3371:
3372: -- IMPORT_SOURCE_LINE_ID
3373: IF p_party_rec.import_source_line_id IS NULL THEN
3374: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
3375: FND_MESSAGE.set_name ('AMS', 'AMS_PARTY_NO_IMP_SRC_LINE_ID');
3376: FND_MSG_PUB.add;
3377: END IF;
3378:

Line 3376: FND_MSG_PUB.add;

3372: -- IMPORT_SOURCE_LINE_ID
3373: IF p_party_rec.import_source_line_id IS NULL THEN
3374: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
3375: FND_MESSAGE.set_name ('AMS', 'AMS_PARTY_NO_IMP_SRC_LINE_ID');
3376: FND_MSG_PUB.add;
3377: END IF;
3378:
3379: x_return_status := FND_API.g_ret_sts_error;
3380: RETURN;

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

3381: END IF;
3382:
3383: -- IMPORT_LIST_HEADER_ID
3384: IF p_party_rec.import_list_header_id IS NULL THEN
3385: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
3386: FND_MESSAGE.set_name ('AMS', 'AMS_PARTY_NO_IMP_LIST_HDR_ID');
3387: FND_MSG_PUB.add;
3388: END IF;
3389:

Line 3387: FND_MSG_PUB.add;

3383: -- IMPORT_LIST_HEADER_ID
3384: IF p_party_rec.import_list_header_id IS NULL THEN
3385: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
3386: FND_MESSAGE.set_name ('AMS', 'AMS_PARTY_NO_IMP_LIST_HDR_ID');
3387: FND_MSG_PUB.add;
3388: END IF;
3389:
3390: x_return_status := FND_API.g_ret_sts_error;
3391: RETURN;

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

3392: END IF;
3393:
3394: -- LIST_SOURCE_TYPE_ID
3395: IF p_party_rec.list_source_type_id IS NULL THEN
3396: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
3397: FND_MESSAGE.set_name ('AMS', 'AMS_PARTY_NO_LST_SRC_TYPE_ID');
3398: FND_MSG_PUB.add;
3399: END IF;
3400:

Line 3398: FND_MSG_PUB.add;

3394: -- LIST_SOURCE_TYPE_ID
3395: IF p_party_rec.list_source_type_id IS NULL THEN
3396: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
3397: FND_MESSAGE.set_name ('AMS', 'AMS_PARTY_NO_LST_SRC_TYPE_ID');
3398: FND_MSG_PUB.add;
3399: END IF;
3400:
3401: x_return_status := FND_API.g_ret_sts_error;
3402: RETURN;

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

3435: 'ams_party_sources',
3436: 'party_sources_id = ' || p_party_rec.party_sources_id
3437: ) = FND_API.g_false
3438: THEN
3439: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
3440: FND_MESSAGE.set_name ('AMS', 'AMS_PARTY_DUP_ID');
3441: FND_MSG_PUB.add;
3442: END IF;
3443: x_return_status := FND_API.g_ret_sts_error;

Line 3441: FND_MSG_PUB.add;

3437: ) = FND_API.g_false
3438: THEN
3439: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
3440: FND_MESSAGE.set_name ('AMS', 'AMS_PARTY_DUP_ID');
3441: FND_MSG_PUB.add;
3442: END IF;
3443: x_return_status := FND_API.g_ret_sts_error;
3444: RETURN;
3445: END IF;

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

3476: p_pk_name => 'PARTY_ID',
3477: p_pk_value => p_party_rec.party_id,
3478: p_pk_data_type => AMS_Utility_PVT.g_number
3479: ) = FND_API.g_false THEN
3480: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3481: FND_MESSAGE.set_name('AMS', 'AMS_PARTY_BAD_PARTY_ID');
3482: FND_MSG_PUB.add;
3483: END IF;
3484:

Line 3482: FND_MSG_PUB.add;

3478: p_pk_data_type => AMS_Utility_PVT.g_number
3479: ) = FND_API.g_false THEN
3480: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3481: FND_MESSAGE.set_name('AMS', 'AMS_PARTY_BAD_PARTY_ID');
3482: FND_MSG_PUB.add;
3483: END IF;
3484:
3485: x_return_status := FND_API.g_ret_sts_error;
3486: RETURN;

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

3495: p_pk_name => 'IMPORT_SOURCE_LINE_ID',
3496: p_pk_value => p_party_rec.import_source_line_id,
3497: p_pk_data_type => AMS_Utility_PVT.g_number
3498: ) = FND_API.g_false THEN
3499: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3500: FND_MESSAGE.set_name('AMS', 'AMS_PARTY_BAD_IMP_SRC_LINE_ID');
3501: FND_MSG_PUB.add;
3502: END IF;
3503:

Line 3501: FND_MSG_PUB.add;

3497: p_pk_data_type => AMS_Utility_PVT.g_number
3498: ) = FND_API.g_false THEN
3499: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3500: FND_MESSAGE.set_name('AMS', 'AMS_PARTY_BAD_IMP_SRC_LINE_ID');
3501: FND_MSG_PUB.add;
3502: END IF;
3503:
3504: x_return_status := FND_API.g_ret_sts_error;
3505: RETURN;

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

3514: p_pk_name => 'IMPORT_LIST_HEADER_ID',
3515: p_pk_value => p_party_rec.import_list_header_id,
3516: p_pk_data_type => AMS_Utility_PVT.g_number
3517: ) = FND_API.g_false THEN
3518: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3519: FND_MESSAGE.set_name('AMS', 'AMS_PARTY_BAD_IMP_LIST_HDR_ID');
3520: FND_MSG_PUB.add;
3521: END IF;
3522:

Line 3520: FND_MSG_PUB.add;

3516: p_pk_data_type => AMS_Utility_PVT.g_number
3517: ) = FND_API.g_false THEN
3518: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3519: FND_MESSAGE.set_name('AMS', 'AMS_PARTY_BAD_IMP_LIST_HDR_ID');
3520: FND_MSG_PUB.add;
3521: END IF;
3522:
3523: x_return_status := FND_API.g_ret_sts_error;
3524: RETURN;

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

3533: p_pk_name => 'LIST_SOURCE_TYPE_ID',
3534: p_pk_value => p_party_rec.list_source_type_id,
3535: p_pk_data_type => AMS_Utility_PVT.g_number
3536: ) = FND_API.g_false THEN
3537: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3538: FND_MESSAGE.set_name('AMS', 'AMS_PARTY_BAD_LST_SRC_TYPE_ID');
3539: FND_MSG_PUB.add;
3540: END IF;
3541:

Line 3539: FND_MSG_PUB.add;

3535: p_pk_data_type => AMS_Utility_PVT.g_number
3536: ) = FND_API.g_false THEN
3537: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3538: FND_MESSAGE.set_name('AMS', 'AMS_PARTY_BAD_LST_SRC_TYPE_ID');
3539: FND_MSG_PUB.add;
3540: END IF;
3541:
3542: x_return_status := FND_API.g_ret_sts_error;
3543: RETURN;

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

3589: --
3590: -- USED_FLAG
3591: IF p_party_rec.used_flag <> FND_API.g_miss_char AND p_party_rec.used_flag IS NOT NULL THEN
3592: IF AMS_Utility_PVT.is_Y_or_N (p_party_rec.used_flag) = FND_API.g_false THEN
3593: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
3594: FND_MESSAGE.set_name ('AMS', 'AMS_PARTY_BAD_USED_FLAG');
3595: FND_MSG_PUB.add;
3596: END IF;
3597:

Line 3595: FND_MSG_PUB.add;

3591: IF p_party_rec.used_flag <> FND_API.g_miss_char AND p_party_rec.used_flag IS NOT NULL THEN
3592: IF AMS_Utility_PVT.is_Y_or_N (p_party_rec.used_flag) = FND_API.g_false THEN
3593: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
3594: FND_MESSAGE.set_name ('AMS', 'AMS_PARTY_BAD_USED_FLAG');
3595: FND_MSG_PUB.add;
3596: END IF;
3597:
3598: x_return_status := FND_API.g_ret_sts_error;
3599: RETURN;

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

3603: --
3604: -- OVERLAY_FLAG
3605: IF p_party_rec.overlay_flag <> FND_API.g_miss_char AND p_party_rec.overlay_flag IS NOT NULL THEN
3606: IF AMS_Utility_PVT.is_Y_or_N (p_party_rec.overlay_flag) = FND_API.g_false THEN
3607: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
3608: FND_MESSAGE.set_name ('AMS', 'AMS_PARTY_BAD_OVERLAY_FLAG');
3609: FND_MSG_PUB.add;
3610: END IF;
3611:

Line 3609: FND_MSG_PUB.add;

3605: IF p_party_rec.overlay_flag <> FND_API.g_miss_char AND p_party_rec.overlay_flag IS NOT NULL THEN
3606: IF AMS_Utility_PVT.is_Y_or_N (p_party_rec.overlay_flag) = FND_API.g_false THEN
3607: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
3608: FND_MESSAGE.set_name ('AMS', 'AMS_PARTY_BAD_OVERLAY_FLAG');
3609: FND_MSG_PUB.add;
3610: END IF;
3611:
3612: x_return_status := FND_API.g_ret_sts_error;
3613: RETURN;

Line 3654: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

3650: errbuf := SUBSTR (FND_MESSAGE.get, 1, L_MAX_BUFFER_LENGTH);
3651: retcode := 0; -- no problems.
3652: EXCEPTION
3653: WHEN OTHERS THEN
3654: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3655: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
3656: END IF;
3657: retcode := 2;
3658: errbuf := SUBSTR (FND_MESSAGE.get, 1, L_MAX_BUFFER_LENGTH);

Line 3655: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

3651: retcode := 0; -- no problems.
3652: EXCEPTION
3653: WHEN OTHERS THEN
3654: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3655: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
3656: END IF;
3657: retcode := 2;
3658: errbuf := SUBSTR (FND_MESSAGE.get, 1, L_MAX_BUFFER_LENGTH);
3659: END Refresh_Key;

Line 3867: FND_MSG_PUB.initialize;

3863: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
3864: END IF;
3865:
3866: IF FND_API.to_boolean (p_init_msg_list) THEN
3867: FND_MSG_PUB.initialize;
3868: END IF;
3869:
3870: IF NOT FND_API.compatible_api_call (
3871: l_api_version,

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

3906: -- The list rule used for generating
3907: -- of the dedupe key for source imports
3908: -- was not found.
3909: CLOSE c_rule;
3910: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
3911: FND_MESSAGE.set_name ('AMS', 'AMS_LIST_BAD_DEDUPE_RULE');
3912: FND_MSG_PUB.add;
3913: END IF;
3914: RAISE FND_API.g_exc_error;

Line 3912: FND_MSG_PUB.add;

3908: -- was not found.
3909: CLOSE c_rule;
3910: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
3911: FND_MESSAGE.set_name ('AMS', 'AMS_LIST_BAD_DEDUPE_RULE');
3912: FND_MSG_PUB.add;
3913: END IF;
3914: RAISE FND_API.g_exc_error;
3915: END IF;
3916: CLOSE c_rule;

Line 4275: FND_MSG_PUB.count_and_get (

4271: x_party_sources_id => l_party_sources_id
4272: );
4273:
4274: -------------------- finish --------------------------
4275: FND_MSG_PUB.count_and_get (
4276: p_encoded => FND_API.g_false,
4277: p_count => x_msg_count,
4278: p_data => x_msg_data
4279: );

Line 4292: FND_MSG_PUB.count_and_get (

4288:
4289: EXCEPTION
4290: WHEN FND_API.g_exc_error THEN
4291: x_return_status := FND_API.g_ret_sts_error;
4292: FND_MSG_PUB.count_and_get (
4293: p_encoded => FND_API.g_false,
4294: p_count => x_msg_count,
4295: p_data => x_msg_data
4296: );

Line 4299: FND_MSG_PUB.count_and_get (

4295: p_data => x_msg_data
4296: );
4297: WHEN FND_API.g_exc_unexpected_error THEN
4298: x_return_status := FND_API.g_ret_sts_unexp_error ;
4299: FND_MSG_PUB.count_and_get (
4300: p_encoded => FND_API.g_false,
4301: p_count => x_msg_count,
4302: p_data => x_msg_data
4303: );

Line 4306: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error)

4302: p_data => x_msg_data
4303: );
4304: WHEN OTHERS THEN
4305: x_return_status := FND_API.g_ret_sts_unexp_error ;
4306: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error)
4307: THEN
4308: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
4309: END IF;
4310:

Line 4308: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

4304: WHEN OTHERS THEN
4305: x_return_status := FND_API.g_ret_sts_unexp_error ;
4306: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error)
4307: THEN
4308: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
4309: END IF;
4310:
4311: FND_MSG_PUB.count_and_get (
4312: p_encoded => FND_API.g_false,

Line 4311: FND_MSG_PUB.count_and_get (

4307: THEN
4308: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
4309: END IF;
4310:
4311: FND_MSG_PUB.count_and_get (
4312: p_encoded => FND_API.g_false,
4313: p_count => x_msg_count,
4314: p_data => x_msg_data
4315: );