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 1177: FND_MSG_PUB.initialize;

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

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

1376: THEN
1377: COMMIT;
1378: END IF; -- p_commit
1379:
1380: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1381: , p_count => x_msg_count
1382: , p_data => x_msg_data
1383: );
1384:

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

1395: WHEN FND_API.g_exc_error
1396: THEN
1397: ROLLBACK TO CREATE_EvtRegs_PVT;
1398: x_return_status := FND_API.g_ret_sts_error;
1399: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1400: , p_count => x_msg_count
1401: , p_data => x_msg_data
1402: );
1403:

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

1404: WHEN FND_API.g_exc_unexpected_error
1405: THEN
1406: ROLLBACK TO CREATE_EvtRegs_PVT;
1407: x_return_status := FND_API.g_ret_sts_unexp_error ;
1408: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1409: , p_count => x_msg_count
1410: , p_data => x_msg_data
1411: );
1412:

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

1413: WHEN OTHERS
1414: THEN
1415: ROLLBACK TO CREATE_EvtRegs_PVT;
1416: x_return_status := FND_API.g_ret_sts_unexp_error ;
1417: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1418: THEN
1419: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1420: END IF;
1421: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

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

1415: ROLLBACK TO CREATE_EvtRegs_PVT;
1416: x_return_status := FND_API.g_ret_sts_unexp_error ;
1417: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1418: THEN
1419: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1420: END IF;
1421: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1422: , p_count => x_msg_count
1423: , p_data => x_msg_data

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

1417: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1418: THEN
1419: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1420: END IF;
1421: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1422: , p_count => x_msg_count
1423: , p_data => x_msg_data
1424: );
1425:

Line 1486: FND_MSG_PUB.initialize;

1482:
1483: -- Initialize message list if p_init_msg_list is set to TRUE.
1484: IF (FND_API.to_Boolean(p_init_msg_list))
1485: THEN
1486: FND_MSG_PUB.initialize;
1487: END IF; -- p_init_msg_list
1488:
1489: -- Initialize API return status to SUCCESS
1490: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1588: WHEN FND_API.g_exc_error
1589: THEN
1590: ROLLBACK TO UPDATE_evtregs_wrapper;
1591: x_return_status := FND_API.g_ret_sts_error;
1592: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1593: , p_count => x_msg_count
1594: , p_data => x_msg_data
1595: );
1596:

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

1597: WHEN FND_API.g_exc_unexpected_error
1598: THEN
1599: ROLLBACK TO UPDATE_evtregs_wrapper;
1600: x_return_status := FND_API.g_ret_sts_unexp_error ;
1601: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1602: , p_count => x_msg_count
1603: , p_data => x_msg_data
1604: );
1605:

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

1606: WHEN OTHERS
1607: THEN
1608: ROLLBACK TO UPDATE_evtregs_wrapper;
1609: x_return_status := FND_API.g_ret_sts_unexp_error ;
1610: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1611: THEN
1612: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1613: END IF;
1614: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

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

1608: ROLLBACK TO UPDATE_evtregs_wrapper;
1609: x_return_status := FND_API.g_ret_sts_unexp_error ;
1610: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1611: THEN
1612: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1613: END IF;
1614: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1615: , p_count => x_msg_count
1616: , p_data => x_msg_data

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

1610: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1611: THEN
1612: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1613: END IF;
1614: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1615: , p_count => x_msg_count
1616: , p_data => x_msg_data
1617: );
1618: END Update_evtregs_wrapper;

Line 1722: FND_MSG_PUB.initialize;

1718:
1719: -- Initialize message list if p_init_msg_list is set to TRUE.
1720: IF (FND_API.to_Boolean(p_init_msg_list))
1721: THEN
1722: FND_MSG_PUB.initialize;
1723: END IF; -- p_init_msg_list
1724:
1725: -- Initialize API return status to SUCCESS
1726: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1986: THEN
1987: COMMIT WORK;
1988: END IF; -- p_commit
1989:
1990: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
1991: , p_count => x_msg_count
1992: , p_data => x_msg_data
1993: );
1994:

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

2006: WHEN FND_API.g_exc_error
2007: THEN
2008: ROLLBACK TO UPDATE_EvtRegs_PVT;
2009: x_return_status := FND_API.g_ret_sts_error;
2010: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2011: , p_count => x_msg_count
2012: , p_data => x_msg_data
2013: );
2014:

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

2015: WHEN FND_API.g_exc_unexpected_error
2016: THEN
2017: ROLLBACK TO UPDATE_EvtRegs_PVT;
2018: x_return_status := FND_API.g_ret_sts_unexp_error ;
2019: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2020: , p_count => x_msg_count
2021: , p_data => x_msg_data
2022: );
2023:

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

2024: WHEN OTHERS
2025: THEN
2026: ROLLBACK TO UPDATE_EvtRegs_PVT;
2027: x_return_status := FND_API.g_ret_sts_unexp_error ;
2028: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2029: THEN
2030: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2031: END IF; -- check_msg_level
2032: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

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

2026: ROLLBACK TO UPDATE_EvtRegs_PVT;
2027: x_return_status := FND_API.g_ret_sts_unexp_error ;
2028: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2029: THEN
2030: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2031: END IF; -- check_msg_level
2032: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2033: , p_count => x_msg_count
2034: , p_data => x_msg_data

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

2028: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2029: THEN
2030: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2031: END IF; -- check_msg_level
2032: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2033: , p_count => x_msg_count
2034: , p_data => x_msg_data
2035: );
2036:

Line 2198: FND_MSG_PUB.initialize;

2194:
2195: -- Initialize message list if p_init_msg_list is set to TRUE.
2196: IF (FND_API.to_Boolean(p_init_msg_list))
2197: THEN
2198: FND_MSG_PUB.initialize;
2199: END IF; -- p_init_msg_list
2200:
2201: -- Initialize API return status to SUCCESS
2202: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2773: COMMIT WORK;
2774: END IF; -- p_commit
2775:
2776: -- Standard call to get message count and if count is 1, get message info.
2777: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2778: , p_count => x_msg_count
2779: , p_data => x_msg_data
2780: );
2781:

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

2792: WHEN FND_API.g_exc_error
2793: THEN
2794: ROLLBACK TO Cancel_EvtRegs_PVT;
2795: x_return_status := FND_API.g_ret_sts_error;
2796: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2797: , p_count => x_msg_count
2798: , p_data => x_msg_data
2799: );
2800:

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

2801: WHEN FND_API.g_exc_unexpected_error
2802: THEN
2803: ROLLBACK TO Cancel_EvtRegs_PVT;
2804: x_return_status := FND_API.g_ret_sts_unexp_error;
2805: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2806: , p_count => x_msg_count
2807: , p_data => x_msg_data
2808: );
2809:

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

2810: WHEN OTHERS
2811: THEN
2812: ROLLBACK TO Cancel_EvtRegs_PVT;
2813: x_return_status := FND_API.g_ret_sts_unexp_error;
2814: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2815: THEN
2816: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2817: END IF; -- check_msg_level
2818: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

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

2812: ROLLBACK TO Cancel_EvtRegs_PVT;
2813: x_return_status := FND_API.g_ret_sts_unexp_error;
2814: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2815: THEN
2816: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2817: END IF; -- check_msg_level
2818: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2819: , p_count => x_msg_count
2820: , p_data => x_msg_data

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

2814: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2815: THEN
2816: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2817: END IF; -- check_msg_level
2818: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2819: , p_count => x_msg_count
2820: , p_data => x_msg_data
2821: );
2822:

Line 2859: FND_MSG_PUB.initialize;

2855: END IF;
2856:
2857: IF FND_API.to_boolean(p_init_msg_list)
2858: THEN
2859: FND_MSG_PUB.initialize;
2860: END IF; -- p_init_msg_list
2861:
2862: IF (NOT FND_API.compatible_api_call( l_api_version_number
2863: , p_api_version_number

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

2888: END IF;
2889: CLOSE c_reg_b;
2890:
2891: -------------------- finish --------------------------
2892: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2893: , p_count => x_msg_count
2894: , p_data => x_msg_data
2895: );
2896:

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

2907: WHEN AMS_Utility_PVT.resource_locked
2908: THEN
2909: x_return_status := FND_API.g_ret_sts_error;
2910: AMS_Utility_PVT.error_message('AMS_API_RESOURCE_LOCKED');
2911: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2912: , p_count => x_msg_count
2913: , p_data => x_msg_data
2914: );
2915:

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

2915:
2916: WHEN FND_API.g_exc_error
2917: THEN
2918: x_return_status := FND_API.g_ret_sts_error;
2919: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2920: , p_count => x_msg_count
2921: , p_data => x_msg_data
2922: );
2923:

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

2923:
2924: WHEN FND_API.g_exc_unexpected_error
2925: THEN
2926: x_return_status := FND_API.g_ret_sts_unexp_error;
2927: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2928: , p_count => x_msg_count
2929: , p_data => x_msg_data
2930: );
2931:

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

2931:
2932: WHEN OTHERS
2933: THEN
2934: x_return_status := FND_API.g_ret_sts_unexp_error;
2935: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
2936: THEN
2937: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2938: END IF; -- check_msg_Level
2939: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

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

2933: THEN
2934: x_return_status := FND_API.g_ret_sts_unexp_error;
2935: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
2936: THEN
2937: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2938: END IF; -- check_msg_Level
2939: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2940: , p_count => x_msg_count
2941: , p_data => x_msg_data

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

2935: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
2936: THEN
2937: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2938: END IF; -- check_msg_Level
2939: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
2940: , p_count => x_msg_count
2941: , p_data => x_msg_data
2942: );
2943:

Line 2973: FND_MSG_PUB.initialize;

2969: END IF;
2970:
2971: IF FND_API.to_boolean(p_init_msg_list)
2972: THEN
2973: FND_MSG_PUB.initialize;
2974: END IF; -- p_init_msg_list
2975:
2976: IF (NOT FND_API.compatible_api_call( l_api_version_number
2977: , p_api_version_number

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

3007: THEN
3008: COMMIT;
3009: END IF; -- p_commit
3010:
3011: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3012: , p_count => x_msg_count
3013: , p_data => x_msg_data
3014: );
3015:

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

3026: WHEN FND_API.g_exc_error
3027: THEN
3028: ROLLBACK TO delete_evtRegs;
3029: x_return_status := FND_API.g_ret_sts_error;
3030: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3031: , p_count => x_msg_count
3032: , p_data => x_msg_data
3033: );
3034:

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

3035: WHEN FND_API.g_exc_unexpected_error
3036: THEN
3037: ROLLBACK TO delete_evtRegs;
3038: x_return_status := FND_API.g_ret_sts_unexp_error ;
3039: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3040: , p_count => x_msg_count
3041: , p_data => x_msg_data
3042: );
3043:

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

3044: WHEN OTHERS
3045: THEN
3046: ROLLBACK TO delete_evtRegs;
3047: x_return_status := FND_API.g_ret_sts_unexp_error ;
3048: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
3049: THEN
3050: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3051: END IF; -- check_msg_level
3052: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

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

3046: ROLLBACK TO delete_evtRegs;
3047: x_return_status := FND_API.g_ret_sts_unexp_error ;
3048: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
3049: THEN
3050: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3051: END IF; -- check_msg_level
3052: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3053: , p_count => x_msg_count
3054: , p_data => x_msg_data

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

3048: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
3049: THEN
3050: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3051: END IF; -- check_msg_level
3052: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3053: , p_count => x_msg_count
3054: , p_data => x_msg_data
3055: );
3056:

Line 3161: FND_MSG_PUB.initialize;

3157: END IF;
3158:
3159: IF FND_API.to_boolean(p_init_msg_list)
3160: THEN
3161: FND_MSG_PUB.initialize;
3162: END IF; -- p_init_msg_list
3163:
3164: IF (NOT FND_API.compatible_api_call( l_api_version_number
3165: , p_api_version_number

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

3295: , x_task_id => l_task_id
3296: );
3297: IF (l_return_status = FND_API.g_ret_sts_error)
3298: THEN
3299: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
3300: THEN
3301: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3302: END IF; -- check_msg_level
3303: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

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

3297: IF (l_return_status = FND_API.g_ret_sts_error)
3298: THEN
3299: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
3300: THEN
3301: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3302: END IF; -- check_msg_level
3303: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3304: , p_count => x_msg_count
3305: , p_data => x_msg_data

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

3299: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
3300: THEN
3301: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3302: END IF; -- check_msg_level
3303: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3304: , p_count => x_msg_count
3305: , p_data => x_msg_data
3306: );
3307: RAISE FND_API.g_exc_error;

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

3306: );
3307: RAISE FND_API.g_exc_error;
3308: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error)
3309: THEN
3310: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
3311: THEN
3312: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3313: END IF; -- check_msg_level
3314: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

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

3308: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error)
3309: THEN
3310: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
3311: THEN
3312: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3313: END IF; -- check_msg_level
3314: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3315: , p_count => x_msg_count
3316: , p_data => x_msg_data

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

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

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

3335: , x_task_assignment_id => l_task_assignment_id
3336: );
3337: IF (l_return_status = FND_API.g_ret_sts_error)
3338: THEN
3339: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
3340: THEN
3341: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3342: END IF; -- check_msg_level
3343: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

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

3337: IF (l_return_status = FND_API.g_ret_sts_error)
3338: THEN
3339: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
3340: THEN
3341: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3342: END IF; -- check_msg_level
3343: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3344: , p_count => x_msg_count
3345: , p_data => x_msg_data

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

3339: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
3340: THEN
3341: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3342: END IF; -- check_msg_level
3343: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3344: , p_count => x_msg_count
3345: , p_data => x_msg_data
3346: );
3347: RAISE FND_API.g_exc_error;

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

3346: );
3347: RAISE FND_API.g_exc_error;
3348: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error)
3349: THEN
3350: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
3351: THEN
3352: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3353: END IF; -- check_msg_level
3354: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

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

3348: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error)
3349: THEN
3350: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
3351: THEN
3352: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3353: END IF; -- check_msg_level
3354: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3355: , p_count => x_msg_count
3356: , p_data => x_msg_data

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

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

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

3442: THEN
3443: COMMIT WORK;
3444: END IF; -- p_commit
3445:
3446: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3447: , p_count => x_msg_count
3448: , p_data => x_msg_data
3449: );
3450:

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

3461: WHEN FND_API.g_exc_error
3462: THEN
3463: ROLLBACK TO prioritize_waitlist;
3464: x_return_status := FND_API.g_ret_sts_error;
3465: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3466: , p_count => x_msg_count
3467: , p_data => x_msg_data
3468: );
3469:

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

3470: WHEN FND_API.g_exc_unexpected_error
3471: THEN
3472: ROLLBACK TO prioritize_waitlist;
3473: x_return_status := FND_API.g_ret_sts_unexp_error;
3474: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3475: , p_count => x_msg_count
3476: , p_data => x_msg_data
3477: );
3478:

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

3479: WHEN OTHERS
3480: THEN
3481: ROLLBACK TO prioritize_waitlist;
3482: x_return_status := FND_API.g_ret_sts_unexp_error;
3483: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
3484: THEN
3485: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3486: END IF; -- check_msg_level
3487: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

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

3481: ROLLBACK TO prioritize_waitlist;
3482: x_return_status := FND_API.g_ret_sts_unexp_error;
3483: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
3484: THEN
3485: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3486: END IF; -- check_msg_level
3487: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3488: , p_count => x_msg_count
3489: , p_data => x_msg_data

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

3483: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
3484: THEN
3485: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3486: END IF; -- check_msg_level
3487: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3488: , p_count => x_msg_count
3489: , p_data => x_msg_data
3490: );
3491:

Line 3546: FND_MSG_PUB.initialize;

3542: END IF;
3543:
3544: IF FND_API.to_boolean(p_init_msg_list)
3545: THEN
3546: FND_MSG_PUB.initialize;
3547: END IF; -- p_init_msg_list
3548:
3549: IF (NOT FND_API.compatible_api_call( l_api_version_number
3550: , p_api_version_number

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

3614: THEN
3615: COMMIT WORK;
3616: END IF; -- p_commit
3617:
3618: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3619: , p_count => x_msg_count
3620: , p_data => x_msg_data
3621: );
3622:

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

3632: WHEN FND_API.g_exc_error
3633: THEN
3634: ROLLBACK TO substitute_validate_PVT;
3635: x_return_status := FND_API.g_ret_sts_error;
3636: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3637: , p_count => x_msg_count
3638: , p_data => x_msg_data
3639: );
3640:

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

3641: WHEN FND_API.g_exc_unexpected_error
3642: THEN
3643: ROLLBACK TO substitute_validate_PVT;
3644: x_return_status := FND_API.g_ret_sts_unexp_error;
3645: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3646: , p_count => x_msg_count
3647: , p_data => x_msg_data
3648: );
3649:

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

3650: WHEN OTHERS
3651: THEN
3652: ROLLBACK TO substitute_validate_PVT;
3653: x_return_status := FND_API.g_ret_sts_unexp_error;
3654: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
3655: THEN
3656: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3657: END IF; -- check_msg_level
3658: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

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

3652: ROLLBACK TO substitute_validate_PVT;
3653: x_return_status := FND_API.g_ret_sts_unexp_error;
3654: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
3655: THEN
3656: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3657: END IF; -- check_msg_level
3658: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3659: , p_count => x_msg_count
3660: , p_data => x_msg_data

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

3654: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
3655: THEN
3656: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3657: END IF; -- check_msg_level
3658: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
3659: , p_count => x_msg_count
3660: , p_data => x_msg_data
3661: );
3662:

Line 3750: FND_MSG_PUB.initialize;

3746: END IF;
3747:
3748: IF FND_API.to_boolean(p_init_msg_list)
3749: THEN
3750: FND_MSG_PUB.initialize;
3751: END IF; -- p_init_msg_list
3752:
3753: IF (NOT FND_API.compatible_api_call( l_api_version_number
3754: , p_api_version_number

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

4029: THEN
4030: COMMIT WORK;
4031: END IF; -- p_commit
4032:
4033: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
4034: , p_count => x_msg_count
4035: , p_data => x_msg_data
4036: );
4037:

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

4047: WHEN FND_API.g_exc_error
4048: THEN
4049: ROLLBACK TO transfer_validate_PVT;
4050: x_return_status := FND_API.g_ret_sts_error;
4051: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
4052: , p_count => x_msg_count
4053: , p_data => x_msg_data
4054: );
4055:

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

4056: WHEN FND_API.g_exc_unexpected_error
4057: THEN
4058: ROLLBACK TO transfer_validate_PVT;
4059: x_return_status := FND_API.g_ret_sts_unexp_error ;
4060: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
4061: , p_count => x_msg_count
4062: , p_data => x_msg_data
4063: );
4064:

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

4065: WHEN OTHERS
4066: THEN
4067: ROLLBACK TO transfer_validate_PVT;
4068: x_return_status := FND_API.g_ret_sts_unexp_error ;
4069: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
4070: THEN
4071: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
4072: END IF; -- check_msg_level
4073: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

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

4067: ROLLBACK TO transfer_validate_PVT;
4068: x_return_status := FND_API.g_ret_sts_unexp_error ;
4069: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
4070: THEN
4071: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
4072: END IF; -- check_msg_level
4073: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
4074: , p_count => x_msg_count
4075: , p_data => x_msg_data

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

4069: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
4070: THEN
4071: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
4072: END IF; -- check_msg_level
4073: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
4074: , p_count => x_msg_count
4075: , p_data => x_msg_data
4076: );
4077:

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

4109:
4110: /* Should user status be mandatory .. it wont be passed from screen, but derived from system status
4111: ------------------------ user_status_id --------------------------
4112: IF p_evt_Regs_rec.user_status_id IS NULL THEN
4113: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
4114: THEN
4115: FND_MESSAGE.set_name('AMS', 'AMS_EVT_REG_NO_USER_STATUS');
4116: FND_MSG_PUB.add;
4117: END IF;

Line 4116: FND_MSG_PUB.add;

4112: IF p_evt_Regs_rec.user_status_id IS NULL THEN
4113: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
4114: THEN
4115: FND_MESSAGE.set_name('AMS', 'AMS_EVT_REG_NO_USER_STATUS');
4116: FND_MSG_PUB.add;
4117: END IF;
4118:
4119: x_return_status := FND_API.g_ret_sts_error;
4120: RETURN;

Line 4656: FND_MSG_PUB.initialize;

4652: END IF;
4653:
4654: IF (FND_API.to_boolean(p_init_msg_list))
4655: THEN
4656: FND_MSG_PUB.initialize;
4657: END IF; -- p_init_msg_list
4658:
4659: IF (NOT FND_API.compatible_api_call( l_api_version_number
4660: , p_api_version_number

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

4713: END IF; -- l_return_status
4714: END IF; -- p_validation_level
4715:
4716: -------------------- finish --------------------------
4717: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false,
4718: , p_count => x_msg_count,
4719: , p_data => x_msg_data
4720: );
4721: */

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

4728:
4729: WHEN FND_API.g_exc_error
4730: THEN
4731: x_return_status := FND_API.g_ret_sts_error;
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 4740: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

4736:
4737: WHEN FND_API.g_exc_unexpected_error
4738: THEN
4739: x_return_status := FND_API.g_ret_sts_unexp_error;
4740: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
4741: , p_count => x_msg_count
4742: , p_data => x_msg_data
4743: );
4744:

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

4744:
4745: WHEN OTHERS
4746: THEN
4747: x_return_status := FND_API.g_ret_sts_unexp_error;
4748: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
4749: THEN
4750: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
4751: END IF; -- check_msg_level
4752: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

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

4746: THEN
4747: x_return_status := FND_API.g_ret_sts_unexp_error;
4748: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
4749: THEN
4750: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
4751: END IF; -- check_msg_level
4752: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
4753: , p_count => x_msg_count
4754: , p_data => x_msg_data

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

4748: IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
4749: THEN
4750: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
4751: END IF; -- check_msg_level
4752: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
4753: , p_count => x_msg_count
4754: , p_data => x_msg_data
4755: );
4756: