DBA Data[Home] [Help]

APPS.AMS_EVTREGS_PVT dependencies on FND_MSG_PUB

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

42:
43: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_EvtRegs_PVT';
44: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amsvregb.pls';
45:
46: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
47: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
48: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
49:
50: FUNCTION get_user_id (

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

43: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_EvtRegs_PVT';
44: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amsvregb.pls';
45:
46: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
47: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
48: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
49:
50: FUNCTION get_user_id (
51: p_resource_id IN NUMBER

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

44: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amsvregb.pls';
45:
46: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
47: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
48: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
49:
50: FUNCTION get_user_id (
51: p_resource_id IN NUMBER
52: )

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

827: AMS_Utility_PVT.g_number,
828: 'party_relationship_id ='|| p_registrant_party_id
829: ) = FND_API.g_false
830: THEN
831: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
832: THEN
833: FND_MESSAGE.set_name('AMS', 'AMS_EVT_REG_BAD_CONTACT_ID');
834: FND_MSG_PUB.add;
835: END IF;

Line 834: FND_MSG_PUB.add;

830: THEN
831: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
832: THEN
833: FND_MESSAGE.set_name('AMS', 'AMS_EVT_REG_BAD_CONTACT_ID');
834: FND_MSG_PUB.add;
835: END IF;
836:
837: x_return_status := FND_API.g_ret_sts_error;
838: --RETURN;

Line 981: FND_MSG_PUB.initialize;

977: END IF;
978:
979: IF (FND_API.to_boolean(p_init_msg_list))
980: THEN
981: FND_MSG_PUB.initialize;
982: END IF; -- p_init_msg_list
983:
984: -- Standard call to check for call compatibility.
985: IF (NOT FND_API.Compatible_API_Call( l_api_version_number

Line 1060: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

1056: THEN
1057: COMMIT;
1058: END IF; -- p_commit
1059:
1060: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1061: , p_count => x_msg_count
1062: , p_data => x_msg_data
1063: );
1064:

Line 1079: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

1075: WHEN FND_API.g_exc_error
1076: THEN
1077: ROLLBACK TO transfer_insert_PVT;
1078: x_return_status := FND_API.g_ret_sts_error;
1079: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1080: , p_count => x_msg_count
1081: , p_data => x_msg_data
1082: );
1083:

Line 1088: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

1084: WHEN FND_API.g_exc_unexpected_error
1085: THEN
1086: ROLLBACK TO transfer_insert_PVT;
1087: x_return_status := FND_API.g_ret_sts_unexp_error;
1088: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1089: , p_count => x_msg_count
1090: , p_data => x_msg_data
1091: );
1092:

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

1094: THEN
1095: ROLLBACK TO transfer_insert_PVT;
1096: x_return_status := FND_API.g_ret_sts_unexp_error;
1097:
1098: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1099: THEN
1100: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1101: END IF; -- check_msg_level
1102:

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

1096: x_return_status := FND_API.g_ret_sts_unexp_error;
1097:
1098: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1099: THEN
1100: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1101: END IF; -- check_msg_level
1102:
1103: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1104: , p_count => x_msg_count

Line 1103: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

1099: THEN
1100: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1101: END IF; -- check_msg_level
1102:
1103: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1104: , p_count => x_msg_count
1105: , p_data => x_msg_data
1106: );
1107:

Line 1180: FND_MSG_PUB.initialize;

1176: END IF;
1177:
1178: IF FND_API.to_boolean(p_init_msg_list)
1179: THEN
1180: FND_MSG_PUB.initialize;
1181: END IF; -- p_init_msg_list
1182:
1183: -- Standard call to check for call compatibility.
1184: IF (NOT FND_API.Compatible_API_Call( l_api_version_number

Line 1395: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

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

Line 1414: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

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

Line 1423: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

1419: WHEN FND_API.g_exc_unexpected_error
1420: THEN
1421: ROLLBACK TO CREATE_EvtRegs_PVT;
1422: x_return_status := FND_API.g_ret_sts_unexp_error ;
1423: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1424: , p_count => x_msg_count
1425: , p_data => x_msg_data
1426: );
1427:

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

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

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

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

Line 1436: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

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

Line 1501: FND_MSG_PUB.initialize;

1497:
1498: -- Initialize message list if p_init_msg_list is set to TRUE.
1499: IF (FND_API.to_Boolean(p_init_msg_list))
1500: THEN
1501: FND_MSG_PUB.initialize;
1502: END IF; -- p_init_msg_list
1503:
1504: -- Initialize API return status to SUCCESS
1505: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1607: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

1603: WHEN FND_API.g_exc_error
1604: THEN
1605: ROLLBACK TO UPDATE_evtregs_wrapper;
1606: x_return_status := FND_API.g_ret_sts_error;
1607: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1608: , p_count => x_msg_count
1609: , p_data => x_msg_data
1610: );
1611:

Line 1616: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

1612: WHEN FND_API.g_exc_unexpected_error
1613: THEN
1614: ROLLBACK TO UPDATE_evtregs_wrapper;
1615: x_return_status := FND_API.g_ret_sts_unexp_error ;
1616: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1617: , p_count => x_msg_count
1618: , p_data => x_msg_data
1619: );
1620:

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

1621: WHEN OTHERS
1622: THEN
1623: ROLLBACK TO UPDATE_evtregs_wrapper;
1624: x_return_status := FND_API.g_ret_sts_unexp_error ;
1625: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1626: THEN
1627: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1628: END IF;
1629: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

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

1623: ROLLBACK TO UPDATE_evtregs_wrapper;
1624: x_return_status := FND_API.g_ret_sts_unexp_error ;
1625: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1626: THEN
1627: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1628: END IF;
1629: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1630: , p_count => x_msg_count
1631: , p_data => x_msg_data

Line 1629: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

1625: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1626: THEN
1627: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1628: END IF;
1629: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1630: , p_count => x_msg_count
1631: , p_data => x_msg_data
1632: );
1633: END Update_evtregs_wrapper;

Line 1737: FND_MSG_PUB.initialize;

1733:
1734: -- Initialize message list if p_init_msg_list is set to TRUE.
1735: IF (FND_API.to_Boolean(p_init_msg_list))
1736: THEN
1737: FND_MSG_PUB.initialize;
1738: END IF; -- p_init_msg_list
1739:
1740: -- Initialize API return status to SUCCESS
1741: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2005: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

2001: THEN
2002: COMMIT WORK;
2003: END IF; -- p_commit
2004:
2005: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2006: , p_count => x_msg_count
2007: , p_data => x_msg_data
2008: );
2009:

Line 2025: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

2021: WHEN FND_API.g_exc_error
2022: THEN
2023: ROLLBACK TO UPDATE_EvtRegs_PVT;
2024: x_return_status := FND_API.g_ret_sts_error;
2025: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2026: , p_count => x_msg_count
2027: , p_data => x_msg_data
2028: );
2029:

Line 2034: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

2030: WHEN FND_API.g_exc_unexpected_error
2031: THEN
2032: ROLLBACK TO UPDATE_EvtRegs_PVT;
2033: x_return_status := FND_API.g_ret_sts_unexp_error ;
2034: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2035: , p_count => x_msg_count
2036: , p_data => x_msg_data
2037: );
2038:

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

2039: WHEN OTHERS
2040: THEN
2041: ROLLBACK TO UPDATE_EvtRegs_PVT;
2042: x_return_status := FND_API.g_ret_sts_unexp_error ;
2043: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2044: THEN
2045: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2046: END IF; -- check_msg_level
2047: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

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

2041: ROLLBACK TO UPDATE_EvtRegs_PVT;
2042: x_return_status := FND_API.g_ret_sts_unexp_error ;
2043: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2044: THEN
2045: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2046: END IF; -- check_msg_level
2047: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2048: , p_count => x_msg_count
2049: , p_data => x_msg_data

Line 2047: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

2043: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2044: THEN
2045: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2046: END IF; -- check_msg_level
2047: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2048: , p_count => x_msg_count
2049: , p_data => x_msg_data
2050: );
2051:

Line 2213: FND_MSG_PUB.initialize;

2209:
2210: -- Initialize message list if p_init_msg_list is set to TRUE.
2211: IF (FND_API.to_Boolean(p_init_msg_list))
2212: THEN
2213: FND_MSG_PUB.initialize;
2214: END IF; -- p_init_msg_list
2215:
2216: -- Initialize API return status to SUCCESS
2217: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2792: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

2788: COMMIT WORK;
2789: END IF; -- p_commit
2790:
2791: -- Standard call to get message count and if count is 1, get message info.
2792: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2793: , p_count => x_msg_count
2794: , p_data => x_msg_data
2795: );
2796:

Line 2811: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

2807: WHEN FND_API.g_exc_error
2808: THEN
2809: ROLLBACK TO Cancel_EvtRegs_PVT;
2810: x_return_status := FND_API.g_ret_sts_error;
2811: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2812: , p_count => x_msg_count
2813: , p_data => x_msg_data
2814: );
2815:

Line 2820: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

2816: WHEN FND_API.g_exc_unexpected_error
2817: THEN
2818: ROLLBACK TO Cancel_EvtRegs_PVT;
2819: x_return_status := FND_API.g_ret_sts_unexp_error;
2820: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2821: , p_count => x_msg_count
2822: , p_data => x_msg_data
2823: );
2824:

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

2825: WHEN OTHERS
2826: THEN
2827: ROLLBACK TO Cancel_EvtRegs_PVT;
2828: x_return_status := FND_API.g_ret_sts_unexp_error;
2829: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2830: THEN
2831: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2832: END IF; -- check_msg_level
2833: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

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

2827: ROLLBACK TO Cancel_EvtRegs_PVT;
2828: x_return_status := FND_API.g_ret_sts_unexp_error;
2829: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2830: THEN
2831: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2832: END IF; -- check_msg_level
2833: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2834: , p_count => x_msg_count
2835: , p_data => x_msg_data

Line 2833: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

2829: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2830: THEN
2831: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2832: END IF; -- check_msg_level
2833: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2834: , p_count => x_msg_count
2835: , p_data => x_msg_data
2836: );
2837:

Line 2874: FND_MSG_PUB.initialize;

2870: END IF;
2871:
2872: IF FND_API.to_boolean(p_init_msg_list)
2873: THEN
2874: FND_MSG_PUB.initialize;
2875: END IF; -- p_init_msg_list
2876:
2877: IF (NOT FND_API.compatible_api_call( l_api_version_number
2878: , p_api_version_number

Line 2907: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

2903: END IF;
2904: CLOSE c_reg_b;
2905:
2906: -------------------- finish --------------------------
2907: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2908: , p_count => x_msg_count
2909: , p_data => x_msg_data
2910: );
2911:

Line 2926: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

2922: WHEN AMS_Utility_PVT.resource_locked
2923: THEN
2924: x_return_status := FND_API.g_ret_sts_error;
2925: AMS_Utility_PVT.error_message('AMS_API_RESOURCE_LOCKED');
2926: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2927: , p_count => x_msg_count
2928: , p_data => x_msg_data
2929: );
2930:

Line 2934: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

2930:
2931: WHEN FND_API.g_exc_error
2932: THEN
2933: x_return_status := FND_API.g_ret_sts_error;
2934: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2935: , p_count => x_msg_count
2936: , p_data => x_msg_data
2937: );
2938:

Line 2942: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

2938:
2939: WHEN FND_API.g_exc_unexpected_error
2940: THEN
2941: x_return_status := FND_API.g_ret_sts_unexp_error;
2942: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2943: , p_count => x_msg_count
2944: , p_data => x_msg_data
2945: );
2946:

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

2946:
2947: WHEN OTHERS
2948: THEN
2949: x_return_status := FND_API.g_ret_sts_unexp_error;
2950: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
2951: THEN
2952: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2953: END IF; -- check_msg_Level
2954: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

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

2948: THEN
2949: x_return_status := FND_API.g_ret_sts_unexp_error;
2950: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
2951: THEN
2952: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2953: END IF; -- check_msg_Level
2954: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2955: , p_count => x_msg_count
2956: , p_data => x_msg_data

Line 2954: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

2950: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
2951: THEN
2952: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2953: END IF; -- check_msg_Level
2954: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2955: , p_count => x_msg_count
2956: , p_data => x_msg_data
2957: );
2958:

Line 2988: FND_MSG_PUB.initialize;

2984: END IF;
2985:
2986: IF FND_API.to_boolean(p_init_msg_list)
2987: THEN
2988: FND_MSG_PUB.initialize;
2989: END IF; -- p_init_msg_list
2990:
2991: IF (NOT FND_API.compatible_api_call( l_api_version_number
2992: , p_api_version_number

Line 3026: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

3022: THEN
3023: COMMIT;
3024: END IF; -- p_commit
3025:
3026: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3027: , p_count => x_msg_count
3028: , p_data => x_msg_data
3029: );
3030:

Line 3045: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

3041: WHEN FND_API.g_exc_error
3042: THEN
3043: ROLLBACK TO delete_evtRegs;
3044: x_return_status := FND_API.g_ret_sts_error;
3045: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3046: , p_count => x_msg_count
3047: , p_data => x_msg_data
3048: );
3049:

Line 3054: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

3050: WHEN FND_API.g_exc_unexpected_error
3051: THEN
3052: ROLLBACK TO delete_evtRegs;
3053: x_return_status := FND_API.g_ret_sts_unexp_error ;
3054: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3055: , p_count => x_msg_count
3056: , p_data => x_msg_data
3057: );
3058:

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

3059: WHEN OTHERS
3060: THEN
3061: ROLLBACK TO delete_evtRegs;
3062: x_return_status := FND_API.g_ret_sts_unexp_error ;
3063: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
3064: THEN
3065: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3066: END IF; -- check_msg_level
3067: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

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

3061: ROLLBACK TO delete_evtRegs;
3062: x_return_status := FND_API.g_ret_sts_unexp_error ;
3063: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
3064: THEN
3065: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3066: END IF; -- check_msg_level
3067: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3068: , p_count => x_msg_count
3069: , p_data => x_msg_data

Line 3067: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

3063: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
3064: THEN
3065: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3066: END IF; -- check_msg_level
3067: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3068: , p_count => x_msg_count
3069: , p_data => x_msg_data
3070: );
3071:

Line 3176: FND_MSG_PUB.initialize;

3172: END IF;
3173:
3174: IF FND_API.to_boolean(p_init_msg_list)
3175: THEN
3176: FND_MSG_PUB.initialize;
3177: END IF; -- p_init_msg_list
3178:
3179: IF (NOT FND_API.compatible_api_call( l_api_version_number
3180: , p_api_version_number

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

3310: , x_task_id => l_task_id
3311: );
3312: IF (l_return_status = FND_API.g_ret_sts_error)
3313: THEN
3314: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
3315: THEN
3316: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3317: END IF; -- check_msg_level
3318: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

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

3312: IF (l_return_status = FND_API.g_ret_sts_error)
3313: THEN
3314: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
3315: THEN
3316: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3317: END IF; -- check_msg_level
3318: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3319: , p_count => x_msg_count
3320: , p_data => x_msg_data

Line 3318: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

3314: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
3315: THEN
3316: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3317: END IF; -- check_msg_level
3318: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3319: , p_count => x_msg_count
3320: , p_data => x_msg_data
3321: );
3322: RAISE FND_API.g_exc_error;

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

3321: );
3322: RAISE FND_API.g_exc_error;
3323: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error)
3324: THEN
3325: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
3326: THEN
3327: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3328: END IF; -- check_msg_level
3329: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

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

3323: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error)
3324: THEN
3325: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
3326: THEN
3327: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3328: END IF; -- check_msg_level
3329: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3330: , p_count => x_msg_count
3331: , p_data => x_msg_data

Line 3329: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

3325: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
3326: THEN
3327: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3328: END IF; -- check_msg_level
3329: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3330: , p_count => x_msg_count
3331: , p_data => x_msg_data
3332: );
3333: RAISE FND_API.g_exc_unexpected_error;

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

3350: , x_task_assignment_id => l_task_assignment_id
3351: );
3352: IF (l_return_status = FND_API.g_ret_sts_error)
3353: THEN
3354: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
3355: THEN
3356: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3357: END IF; -- check_msg_level
3358: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

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

3352: IF (l_return_status = FND_API.g_ret_sts_error)
3353: THEN
3354: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
3355: THEN
3356: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3357: END IF; -- check_msg_level
3358: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3359: , p_count => x_msg_count
3360: , p_data => x_msg_data

Line 3358: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

3354: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
3355: THEN
3356: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3357: END IF; -- check_msg_level
3358: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3359: , p_count => x_msg_count
3360: , p_data => x_msg_data
3361: );
3362: RAISE FND_API.g_exc_error;

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

3361: );
3362: RAISE FND_API.g_exc_error;
3363: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error)
3364: THEN
3365: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
3366: THEN
3367: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3368: END IF; -- check_msg_level
3369: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

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

3363: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error)
3364: THEN
3365: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
3366: THEN
3367: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3368: END IF; -- check_msg_level
3369: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3370: , p_count => x_msg_count
3371: , p_data => x_msg_data

Line 3369: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

3365: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
3366: THEN
3367: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3368: END IF; -- check_msg_level
3369: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3370: , p_count => x_msg_count
3371: , p_data => x_msg_data
3372: );
3373: RAISE FND_API.g_exc_unexpected_error;

Line 3461: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

3457: THEN
3458: COMMIT WORK;
3459: END IF; -- p_commit
3460:
3461: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3462: , p_count => x_msg_count
3463: , p_data => x_msg_data
3464: );
3465:

Line 3480: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

3476: WHEN FND_API.g_exc_error
3477: THEN
3478: ROLLBACK TO prioritize_waitlist;
3479: x_return_status := FND_API.g_ret_sts_error;
3480: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3481: , p_count => x_msg_count
3482: , p_data => x_msg_data
3483: );
3484:

Line 3489: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

3485: WHEN FND_API.g_exc_unexpected_error
3486: THEN
3487: ROLLBACK TO prioritize_waitlist;
3488: x_return_status := FND_API.g_ret_sts_unexp_error;
3489: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3490: , p_count => x_msg_count
3491: , p_data => x_msg_data
3492: );
3493:

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

3494: WHEN OTHERS
3495: THEN
3496: ROLLBACK TO prioritize_waitlist;
3497: x_return_status := FND_API.g_ret_sts_unexp_error;
3498: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
3499: THEN
3500: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3501: END IF; -- check_msg_level
3502: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

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

3496: ROLLBACK TO prioritize_waitlist;
3497: x_return_status := FND_API.g_ret_sts_unexp_error;
3498: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
3499: THEN
3500: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3501: END IF; -- check_msg_level
3502: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3503: , p_count => x_msg_count
3504: , p_data => x_msg_data

Line 3502: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

3498: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
3499: THEN
3500: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3501: END IF; -- check_msg_level
3502: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3503: , p_count => x_msg_count
3504: , p_data => x_msg_data
3505: );
3506:

Line 3561: FND_MSG_PUB.initialize;

3557: END IF;
3558:
3559: IF FND_API.to_boolean(p_init_msg_list)
3560: THEN
3561: FND_MSG_PUB.initialize;
3562: END IF; -- p_init_msg_list
3563:
3564: IF (NOT FND_API.compatible_api_call( l_api_version_number
3565: , p_api_version_number

Line 3633: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

3629: THEN
3630: COMMIT WORK;
3631: END IF; -- p_commit
3632:
3633: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3634: , p_count => x_msg_count
3635: , p_data => x_msg_data
3636: );
3637:

Line 3651: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

3647: WHEN FND_API.g_exc_error
3648: THEN
3649: ROLLBACK TO substitute_validate_PVT;
3650: x_return_status := FND_API.g_ret_sts_error;
3651: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3652: , p_count => x_msg_count
3653: , p_data => x_msg_data
3654: );
3655:

Line 3660: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

3656: WHEN FND_API.g_exc_unexpected_error
3657: THEN
3658: ROLLBACK TO substitute_validate_PVT;
3659: x_return_status := FND_API.g_ret_sts_unexp_error;
3660: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3661: , p_count => x_msg_count
3662: , p_data => x_msg_data
3663: );
3664:

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

3665: WHEN OTHERS
3666: THEN
3667: ROLLBACK TO substitute_validate_PVT;
3668: x_return_status := FND_API.g_ret_sts_unexp_error;
3669: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
3670: THEN
3671: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3672: END IF; -- check_msg_level
3673: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

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

3667: ROLLBACK TO substitute_validate_PVT;
3668: x_return_status := FND_API.g_ret_sts_unexp_error;
3669: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
3670: THEN
3671: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3672: END IF; -- check_msg_level
3673: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3674: , p_count => x_msg_count
3675: , p_data => x_msg_data

Line 3673: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

3669: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
3670: THEN
3671: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3672: END IF; -- check_msg_level
3673: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3674: , p_count => x_msg_count
3675: , p_data => x_msg_data
3676: );
3677:

Line 3765: FND_MSG_PUB.initialize;

3761: END IF;
3762:
3763: IF FND_API.to_boolean(p_init_msg_list)
3764: THEN
3765: FND_MSG_PUB.initialize;
3766: END IF; -- p_init_msg_list
3767:
3768: IF (NOT FND_API.compatible_api_call( l_api_version_number
3769: , p_api_version_number

Line 4048: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

4044: THEN
4045: COMMIT WORK;
4046: END IF; -- p_commit
4047:
4048: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
4049: , p_count => x_msg_count
4050: , p_data => x_msg_data
4051: );
4052:

Line 4066: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

4062: WHEN FND_API.g_exc_error
4063: THEN
4064: ROLLBACK TO transfer_validate_PVT;
4065: x_return_status := FND_API.g_ret_sts_error;
4066: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
4067: , p_count => x_msg_count
4068: , p_data => x_msg_data
4069: );
4070:

Line 4075: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

4071: WHEN FND_API.g_exc_unexpected_error
4072: THEN
4073: ROLLBACK TO transfer_validate_PVT;
4074: x_return_status := FND_API.g_ret_sts_unexp_error ;
4075: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
4076: , p_count => x_msg_count
4077: , p_data => x_msg_data
4078: );
4079:

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

4080: WHEN OTHERS
4081: THEN
4082: ROLLBACK TO transfer_validate_PVT;
4083: x_return_status := FND_API.g_ret_sts_unexp_error ;
4084: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
4085: THEN
4086: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
4087: END IF; -- check_msg_level
4088: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

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

4082: ROLLBACK TO transfer_validate_PVT;
4083: x_return_status := FND_API.g_ret_sts_unexp_error ;
4084: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
4085: THEN
4086: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
4087: END IF; -- check_msg_level
4088: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
4089: , p_count => x_msg_count
4090: , p_data => x_msg_data

Line 4088: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

4084: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
4085: THEN
4086: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
4087: END IF; -- check_msg_level
4088: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
4089: , p_count => x_msg_count
4090: , p_data => x_msg_data
4091: );
4092:

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

4124:
4125: /* Should user status be mandatory .. it wont be passed from screen, but derived from system status
4126: ------------------------ user_status_id --------------------------
4127: IF p_evt_Regs_rec.user_status_id IS NULL THEN
4128: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
4129: THEN
4130: FND_MESSAGE.set_name('AMS', 'AMS_EVT_REG_NO_USER_STATUS');
4131: FND_MSG_PUB.add;
4132: END IF;

Line 4131: FND_MSG_PUB.add;

4127: IF p_evt_Regs_rec.user_status_id IS NULL THEN
4128: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
4129: THEN
4130: FND_MESSAGE.set_name('AMS', 'AMS_EVT_REG_NO_USER_STATUS');
4131: FND_MSG_PUB.add;
4132: END IF;
4133:
4134: x_return_status := FND_API.g_ret_sts_error;
4135: RETURN;

Line 4671: FND_MSG_PUB.initialize;

4667: END IF;
4668:
4669: IF (FND_API.to_boolean(p_init_msg_list))
4670: THEN
4671: FND_MSG_PUB.initialize;
4672: END IF; -- p_init_msg_list
4673:
4674: IF (NOT FND_API.compatible_api_call( l_api_version_number
4675: , p_api_version_number

Line 4732: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false,

4728: END IF; -- l_return_status
4729: END IF; -- p_validation_level
4730:
4731: -------------------- finish --------------------------
4732: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false,
4733: , p_count => x_msg_count,
4734: , p_data => x_msg_data
4735: );
4736: */

Line 4747: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

4743:
4744: WHEN FND_API.g_exc_error
4745: THEN
4746: x_return_status := FND_API.g_ret_sts_error;
4747: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
4748: , p_count => x_msg_count
4749: , p_data => x_msg_data
4750: );
4751:

Line 4755: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

4751:
4752: WHEN FND_API.g_exc_unexpected_error
4753: THEN
4754: x_return_status := FND_API.g_ret_sts_unexp_error;
4755: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
4756: , p_count => x_msg_count
4757: , p_data => x_msg_data
4758: );
4759:

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

4759:
4760: WHEN OTHERS
4761: THEN
4762: x_return_status := FND_API.g_ret_sts_unexp_error;
4763: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
4764: THEN
4765: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
4766: END IF; -- check_msg_level
4767: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

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

4761: THEN
4762: x_return_status := FND_API.g_ret_sts_unexp_error;
4763: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
4764: THEN
4765: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
4766: END IF; -- check_msg_level
4767: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
4768: , p_count => x_msg_count
4769: , p_data => x_msg_data

Line 4767: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

4763: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
4764: THEN
4765: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
4766: END IF; -- check_msg_level
4767: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
4768: , p_count => x_msg_count
4769: , p_data => x_msg_data
4770: );
4771: