DBA Data[Home] [Help]

APPS.OZF_BUDGETAPPROVAL_PVT dependencies on FND_MSG_PUB

Line 34: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);

30: G_PACKAGE_NAME CONSTANT VARCHAR2(30) := 'OZF_BudgetApproval_PVT';
31: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozfvbdab.pls';
32: g_cons_fund_mode CONSTANT VARCHAR2(30) := 'WORKFLOW';
33: g_status_type CONSTANT VARCHAR2(30) := 'OZF_BUDGETSOURCE_STATUS';
34: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
35:
36: -------------------------------------------------------------------
37: -- NAME
38: -- Approve_ActBudget

Line 167: FND_MSG_PUB.initialize;

163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
164: END IF;
165: -- Initialize message list if p_init_msg_list is set to TRUE.
166: IF FND_API.to_Boolean( p_init_msg_list ) THEN
167: FND_MSG_PUB.initialize;
168: END IF;
169: -- Initialize API return status to success
170: x_return_status := FND_API.G_RET_STS_SUCCESS;
171:

Line 639: fnd_msg_pub.count_and_get (

635: EXCEPTION
636: WHEN OTHERS THEN
637: ROLLBACK TO revert_approved_request;
638: x_return_status := fnd_api.g_ret_sts_error;
639: fnd_msg_pub.count_and_get (
640: p_count => x_msg_count
641: , p_data => x_msg_data
642: , p_encoded => fnd_api.g_false
643: );

Line 1339: FND_MSG_PUB.Add;

1335: ozf_utility_pvt.write_conc_log('Number of products in offer: ' || l_count_offer_prod);
1336:
1337: IF l_count_offer_prod = 0 THEN
1338: FND_MESSAGE.Set_Name ('OZF', 'OZF_OFFER_NO_PROD');
1339: FND_MSG_PUB.Add;
1340: RAISE fnd_api.G_EXC_ERROR;
1341: END IF;
1342:
1343: IF p_mode = 'LOOSE' THEN

Line 1356: FND_MSG_PUB.Add;

1352: RAISE fnd_api.G_EXC_ERROR;
1353: ELSIF x_valid_flag <> fnd_api.G_TRUE THEN
1354: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
1355: FND_MESSAGE.SET_TOKEN('text', 'Product validation fails. Offer does not have a single product that matches the product of the budget');
1356: FND_MSG_PUB.Add;
1357: RAISE fnd_api.G_EXC_ERROR;
1358: END IF;
1359: ELSIF p_mode = 'STRICT' THEN
1360: check_product_market_strict(

Line 1372: FND_MSG_PUB.Add;

1368: RAISE fnd_api.G_EXC_ERROR;
1369: ELSIF x_valid_flag <> fnd_api.G_TRUE THEN
1370: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
1371: FND_MESSAGE.SET_TOKEN('text', 'Product validation fails. Offer has product that is not in budget product list');
1372: FND_MSG_PUB.Add;
1373: RAISE fnd_api.G_EXC_ERROR;
1374: END IF;
1375: END IF;
1376:

Line 1657: FND_MSG_PUB.Add;

1653: RAISE fnd_api.G_EXC_ERROR;
1654: ELSIF x_valid_flag <> fnd_api.G_TRUE THEN
1655: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
1656: FND_MESSAGE.SET_TOKEN('text', 'Product validation fails. Offer has product that is not in product list of all budgets');
1657: FND_MSG_PUB.Add;
1658: RAISE fnd_api.G_EXC_ERROR;
1659: END IF;
1660:
1661: EXCEPTION

Line 1845: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH) THEN

1841: l_ignore := DBMS_SQL.execute(l_denorm_csr);
1842: --dbms_output.put_line(l_ignore);
1843: END IF;
1844:
1845: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH) THEN
1846: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
1847: FND_MESSAGE.SET_TOKEN('text', 'Offer market sql: ' || l_offer_market_sql);
1848: FND_MSG_PUB.Add;
1849: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');

Line 1848: FND_MSG_PUB.Add;

1844:
1845: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH) THEN
1846: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
1847: FND_MESSAGE.SET_TOKEN('text', 'Offer market sql: ' || l_offer_market_sql);
1848: FND_MSG_PUB.Add;
1849: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
1850: FND_MESSAGE.SET_TOKEN('text', 'Budget market sql: ' || l_budget_market_sql);
1851: FND_MSG_PUB.Add;
1852: END IF;

Line 1851: FND_MSG_PUB.Add;

1847: FND_MESSAGE.SET_TOKEN('text', 'Offer market sql: ' || l_offer_market_sql);
1848: FND_MSG_PUB.Add;
1849: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
1850: FND_MESSAGE.SET_TOKEN('text', 'Budget market sql: ' || l_budget_market_sql);
1851: FND_MSG_PUB.Add;
1852: END IF;
1853:
1854: l_exist_number := NULL;
1855:

Line 1869: FND_MSG_PUB.Add;

1865: RAISE fnd_api.G_EXC_ERROR;
1866: ELSIF x_valid_flag <> fnd_api.G_TRUE THEN
1867: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
1868: FND_MESSAGE.SET_TOKEN('text', 'Market validation fails. Offer does not have a single party that matches the party of the budget');
1869: FND_MSG_PUB.Add;
1870: RAISE fnd_api.G_EXC_ERROR;
1871: END IF;
1872: ELSIF p_mode = 'STRICT' THEN
1873: check_product_market_strict(

Line 1885: FND_MSG_PUB.Add;

1881: RAISE fnd_api.G_EXC_ERROR;
1882: ELSIF x_valid_flag <> fnd_api.G_TRUE THEN
1883: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
1884: FND_MESSAGE.SET_TOKEN('text', 'Market validation fails. Offer has party that is not in budget market list');
1885: FND_MSG_PUB.Add;
1886: RAISE fnd_api.G_EXC_ERROR;
1887: END IF;
1888: END IF;
1889:

Line 2214: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH) THEN

2210: l_ignore := DBMS_SQL.execute(l_denorm_csr);
2211: --dbms_output.put_line(l_ignore);
2212: END IF;
2213:
2214: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH) THEN
2215: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
2216: FND_MESSAGE.SET_TOKEN('text', 'Offer market sql: ' || l_offer_market_sql);
2217: FND_MSG_PUB.Add;
2218: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');

Line 2217: FND_MSG_PUB.Add;

2213:
2214: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH) THEN
2215: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
2216: FND_MESSAGE.SET_TOKEN('text', 'Offer market sql: ' || l_offer_market_sql);
2217: FND_MSG_PUB.Add;
2218: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
2219: FND_MESSAGE.SET_TOKEN('text', 'Budget market sql: ' || l_budget_market_sql);
2220: FND_MSG_PUB.Add;
2221: END IF;

Line 2220: FND_MSG_PUB.Add;

2216: FND_MESSAGE.SET_TOKEN('text', 'Offer market sql: ' || l_offer_market_sql);
2217: FND_MSG_PUB.Add;
2218: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
2219: FND_MESSAGE.SET_TOKEN('text', 'Budget market sql: ' || l_budget_market_sql);
2220: FND_MSG_PUB.Add;
2221: END IF;
2222:
2223: l_exist_number := NULL;
2224: check_product_market_strict(

Line 2236: FND_MSG_PUB.Add;

2232: RAISE fnd_api.G_EXC_ERROR;
2233: ELSIF x_valid_flag <> fnd_api.G_TRUE THEN
2234: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
2235: FND_MESSAGE.SET_TOKEN('text', 'Market validation fails. Offer has party that is not in market list of all budgets');
2236: FND_MSG_PUB.Add;
2237: RAISE fnd_api.G_EXC_ERROR;
2238: END IF;
2239:
2240: EXCEPTION

Line 2352: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2348: x_return_status := l_return_status;
2349: RAISE fnd_api.G_EXC_ERROR;
2350: ELSIF l_valid_flag <> fnd_api.G_TRUE THEN
2351: -- how to return back message? through fnd_message?
2352: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2353: FND_MESSAGE.Set_Name ('OZF', 'OZF_PRODUCT_ELIG_MISMATCH');
2354: FND_MSG_PUB.Add;
2355: END IF;
2356: IF G_DEBUG THEN

Line 2354: FND_MSG_PUB.Add;

2350: ELSIF l_valid_flag <> fnd_api.G_TRUE THEN
2351: -- how to return back message? through fnd_message?
2352: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2353: FND_MESSAGE.Set_Name ('OZF', 'OZF_PRODUCT_ELIG_MISMATCH');
2354: FND_MSG_PUB.Add;
2355: END IF;
2356: IF G_DEBUG THEN
2357: ozf_utility_pvt.debug_message('FAILURE: budget product eligibility does not match that of offer');
2358: END IF;

Line 2379: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2375: x_return_status := l_return_status;
2376: RAISE fnd_api.G_EXC_ERROR;
2377: ELSIF l_valid_flag <> fnd_api.G_TRUE THEN
2378: -- how to return back message? through fnd_message?
2379: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2380: FND_MESSAGE.Set_Name ('OZF', 'OZF_MARKET_ELIG_MISMATCH');
2381: FND_MSG_PUB.Add;
2382: END IF;
2383: IF G_DEBUG THEN

Line 2381: FND_MSG_PUB.Add;

2377: ELSIF l_valid_flag <> fnd_api.G_TRUE THEN
2378: -- how to return back message? through fnd_message?
2379: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2380: FND_MESSAGE.Set_Name ('OZF', 'OZF_MARKET_ELIG_MISMATCH');
2381: FND_MSG_PUB.Add;
2382: END IF;
2383: IF G_DEBUG THEN
2384: ozf_utility_pvt.debug_message('FAILURE: budget market eligibility does not match that of offer');
2385: END IF;

Line 2396: fnd_msg_pub.count_and_get(

2392: EXCEPTION
2393: WHEN fnd_api.g_exc_error THEN
2394: ROLLBACK TO validate_object_budget;
2395: x_return_status := fnd_api.g_ret_sts_error;
2396: fnd_msg_pub.count_and_get(
2397: p_encoded => fnd_api.g_false
2398: ,p_count => x_msg_count
2399: ,p_data => x_msg_data);
2400: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2403: fnd_msg_pub.count_and_get(

2399: ,p_data => x_msg_data);
2400: WHEN fnd_api.g_exc_unexpected_error THEN
2401: ROLLBACK TO validate_object_budget;
2402: x_return_status := fnd_api.g_ret_sts_unexp_error;
2403: fnd_msg_pub.count_and_get(
2404: p_encoded => fnd_api.g_false
2405: ,p_count => x_msg_count
2406: ,p_data => x_msg_data);
2407:

Line 2411: fnd_msg_pub.count_and_get (

2407:
2408: WHEN OTHERS THEN
2409: ROLLBACK TO validate_object_budget;
2410: x_return_status := fnd_api.g_ret_sts_error;
2411: fnd_msg_pub.count_and_get (
2412: p_count => x_msg_count
2413: , p_data => x_msg_data
2414: , p_encoded => fnd_api.g_false
2415: );

Line 2491: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2487: );
2488: RAISE fnd_api.G_EXC_ERROR;
2489: ELSIF l_valid_flag <> fnd_api.G_TRUE THEN
2490: -- how to return back message? through fnd_message?
2491: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2492: FND_MESSAGE.Set_Name ('OZF', 'OZF_MARKET_ELIG_MISMATCH');
2493: FND_MSG_PUB.Add;
2494: END IF;
2495: IF G_DEBUG THEN

Line 2493: FND_MSG_PUB.Add;

2489: ELSIF l_valid_flag <> fnd_api.G_TRUE THEN
2490: -- how to return back message? through fnd_message?
2491: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2492: FND_MESSAGE.Set_Name ('OZF', 'OZF_MARKET_ELIG_MISMATCH');
2493: FND_MSG_PUB.Add;
2494: END IF;
2495: IF G_DEBUG THEN
2496: ozf_utility_pvt.debug_message('FAILURE: all budgets market eligibility does not match that of offer');
2497: END IF;

Line 2530: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2526: ,x_msg_data => l_msg_data
2527: );
2528: RAISE fnd_api.G_EXC_ERROR;
2529: ELSIF l_valid_flag <> fnd_api.G_TRUE THEN
2530: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2531: FND_MESSAGE.Set_Name ('OZF', 'OZF_PRODUCT_ELIG_MISMATCH');
2532: FND_MSG_PUB.Add;
2533: END IF;
2534: IF G_DEBUG THEN

Line 2532: FND_MSG_PUB.Add;

2528: RAISE fnd_api.G_EXC_ERROR;
2529: ELSIF l_valid_flag <> fnd_api.G_TRUE THEN
2530: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2531: FND_MESSAGE.Set_Name ('OZF', 'OZF_PRODUCT_ELIG_MISMATCH');
2532: FND_MSG_PUB.Add;
2533: END IF;
2534: IF G_DEBUG THEN
2535: ozf_utility_pvt.debug_message('FAILURE: all budgets product eligibility does not match that of offer');
2536: END IF;

Line 2556: fnd_msg_pub.count_and_get(

2552:
2553: EXCEPTION
2554: WHEN fnd_api.g_exc_error THEN
2555: x_return_status := fnd_api.g_ret_sts_error;
2556: fnd_msg_pub.count_and_get(
2557: p_encoded => fnd_api.g_false
2558: ,p_count => x_msg_count
2559: ,p_data => x_msg_data);
2560: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2562: fnd_msg_pub.count_and_get(

2558: ,p_count => x_msg_count
2559: ,p_data => x_msg_data);
2560: WHEN fnd_api.g_exc_unexpected_error THEN
2561: x_return_status := fnd_api.g_ret_sts_unexp_error;
2562: fnd_msg_pub.count_and_get(
2563: p_encoded => fnd_api.g_false
2564: ,p_count => x_msg_count
2565: ,p_data => x_msg_data);
2566:

Line 2569: fnd_msg_pub.count_and_get (

2565: ,p_data => x_msg_data);
2566:
2567: WHEN OTHERS THEN
2568: x_return_status := fnd_api.g_ret_sts_error;
2569: fnd_msg_pub.count_and_get (
2570: p_count => x_msg_count
2571: , p_data => x_msg_data
2572: , p_encoded => fnd_api.g_false
2573: );

Line 2750: fnd_msg_pub.count_and_get (

2746:
2747: EXCEPTION
2748: WHEN OTHERS THEN
2749: x_return_status := fnd_api.g_ret_sts_error;
2750: fnd_msg_pub.count_and_get (
2751: p_count => x_msg_count
2752: , p_data => x_msg_data
2753: , p_encoded => fnd_api.g_false
2754: );

Line 2842: Fnd_Msg_Pub.ADD;

2838: FROM ams_deliverables_vl
2839: WHERE deliverable_id = p_object_id;
2840: ELSE
2841: Fnd_Message.Set_Name('OZF','OZF_BAD_APPROVAL_OBJECT_TYPE');
2842: Fnd_Msg_Pub.ADD;
2843: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2844: RETURN;
2845: END IF ;
2846:

Line 2851: Fnd_Msg_Pub.ADD;

2847: FETCH l_obj_details INTO l_budget_amount,l_owner_id;
2848: IF l_obj_details%NOTFOUND THEN
2849: CLOSE l_obj_details;
2850: Fnd_Message.Set_Name('OZF','OZF_APPR_BAD_DETAILS');
2851: Fnd_Msg_Pub.ADD;
2852: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2853: RETURN;
2854: END IF;
2855: CLOSE l_obj_details;

Line 2895: fnd_msg_pub.count_and_get (

2891:
2892: EXCEPTION
2893: WHEN OTHERS THEN
2894: x_return_status := fnd_api.g_ret_sts_error;
2895: fnd_msg_pub.count_and_get (
2896: p_count => l_msg_count
2897: , p_data => l_msg_data
2898: , p_encoded => fnd_api.g_false
2899: );

Line 2981: fnd_msg_pub.initialize;

2977: SAVEPOINT conc_validate_offer_budget;
2978:
2979: x_errbuf := null;
2980: x_retcode := 0;
2981: fnd_msg_pub.initialize;
2982:
2983: l_modifier_list_rec.QP_LIST_HEADER_ID := p_object_id;
2984:
2985: OPEN c_offer_info(p_object_id);

Line 3056: Fnd_Msg_Pub.Get

3052: l_strBody := l_strBody || Substr(fnd_message.get,1,200);
3053:
3054: WHILE l_cnt < l_msg_count
3055: LOOP
3056: Fnd_Msg_Pub.Get
3057: (p_msg_index => l_cnt + 1,
3058: p_encoded => Fnd_Api.G_FALSE,
3059: p_data => l_msg_data,
3060: p_msg_index_out => l_msg_index );

Line 3165: Fnd_Msg_Pub.Get

3161: l_strBody := l_strBody || Substr(fnd_message.get,1,200);
3162:
3163: WHILE l_cnt < l_msg_count
3164: LOOP
3165: Fnd_Msg_Pub.Get
3166: (p_msg_index => l_cnt + 1,
3167: p_encoded => Fnd_Api.G_FALSE,
3168: p_data => l_msg_data,
3169: p_msg_index_out => l_msg_index );

Line 3337: Fnd_Msg_Pub.Get

3333:
3334: -- send notifiction.
3335: WHILE l_cnt < l_msg_count
3336: LOOP
3337: Fnd_Msg_Pub.Get
3338: (p_msg_index => l_cnt + 1,
3339: p_encoded => Fnd_Api.G_FALSE,
3340: p_data => l_msg_data,
3341: p_msg_index_out => l_msg_index );

Line 3364: Fnd_Msg_Pub.Get

3360: l_strBody := l_strBody || Substr(fnd_message.get,1,200);
3361:
3362: WHILE l_cnt < l_msg_count
3363: LOOP
3364: Fnd_Msg_Pub.Get
3365: (p_msg_index => l_cnt + 1,
3366: p_encoded => Fnd_Api.G_FALSE,
3367: p_data => l_msg_data,
3368: p_msg_index_out => l_msg_index );

Line 3614: fnd_msg_pub.count_and_get(

3610: IF G_DEBUG THEN
3611: ozf_utility_pvt.debug_message(l_full_name || ': end');
3612: END IF;
3613:
3614: fnd_msg_pub.count_and_get(
3615: p_encoded => fnd_api.g_false
3616: ,p_count => x_msg_count
3617: ,p_data => x_msg_data);
3618:

Line 3622: fnd_msg_pub.count_and_get(

3618:
3619: EXCEPTION
3620: WHEN fnd_api.g_exc_error THEN
3621: x_return_status := fnd_api.g_ret_sts_error;
3622: fnd_msg_pub.count_and_get(
3623: p_encoded => fnd_api.g_false
3624: ,p_count => x_msg_count
3625: ,p_data => x_msg_data);
3626: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3628: fnd_msg_pub.count_and_get(

3624: ,p_count => x_msg_count
3625: ,p_data => x_msg_data);
3626: WHEN fnd_api.g_exc_unexpected_error THEN
3627: x_return_status := fnd_api.g_ret_sts_unexp_error;
3628: fnd_msg_pub.count_and_get(
3629: p_encoded => fnd_api.g_false
3630: ,p_count => x_msg_count
3631: ,p_data => x_msg_data);
3632: WHEN OTHERS THEN

Line 3635: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

3631: ,p_data => x_msg_data);
3632: WHEN OTHERS THEN
3633: x_return_status := fnd_api.g_ret_sts_unexp_error;
3634:
3635: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3636: fnd_msg_pub.add_exc_msg(G_PACKAGE_NAME, l_api_name);
3637: END IF;
3638:
3639: fnd_msg_pub.count_and_get(

Line 3636: fnd_msg_pub.add_exc_msg(G_PACKAGE_NAME, l_api_name);

3632: WHEN OTHERS THEN
3633: x_return_status := fnd_api.g_ret_sts_unexp_error;
3634:
3635: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3636: fnd_msg_pub.add_exc_msg(G_PACKAGE_NAME, l_api_name);
3637: END IF;
3638:
3639: fnd_msg_pub.count_and_get(
3640: p_encoded => fnd_api.g_false

Line 3639: fnd_msg_pub.count_and_get(

3635: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3636: fnd_msg_pub.add_exc_msg(G_PACKAGE_NAME, l_api_name);
3637: END IF;
3638:
3639: fnd_msg_pub.count_and_get(
3640: p_encoded => fnd_api.g_false
3641: ,p_count => x_msg_count
3642: ,p_data => x_msg_data);
3643: END budget_request_approval;