DBA Data[Home] [Help]

APPS.OZF_BUDGETAPPROVAL_PVT dependencies on FND_MSG_PUB

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

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

Line 171: FND_MSG_PUB.initialize;

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

Line 643: fnd_msg_pub.count_and_get (

639: EXCEPTION
640: WHEN OTHERS THEN
641: ROLLBACK TO revert_approved_request;
642: x_return_status := fnd_api.g_ret_sts_error;
643: fnd_msg_pub.count_and_get (
644: p_count => x_msg_count
645: , p_data => x_msg_data
646: , p_encoded => fnd_api.g_false
647: );

Line 1343: FND_MSG_PUB.Add;

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

Line 1360: FND_MSG_PUB.Add;

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

Line 1376: FND_MSG_PUB.Add;

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

Line 1661: FND_MSG_PUB.Add;

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

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

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

Line 1852: FND_MSG_PUB.Add;

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

Line 1855: FND_MSG_PUB.Add;

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

Line 1873: FND_MSG_PUB.Add;

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

Line 1889: FND_MSG_PUB.Add;

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

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

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

Line 2221: FND_MSG_PUB.Add;

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

Line 2224: FND_MSG_PUB.Add;

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

Line 2240: FND_MSG_PUB.Add;

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

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

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

Line 2358: FND_MSG_PUB.Add;

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

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

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

Line 2385: FND_MSG_PUB.Add;

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

Line 2400: fnd_msg_pub.count_and_get(

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

Line 2407: fnd_msg_pub.count_and_get(

2403: ,p_data => x_msg_data);
2404: WHEN fnd_api.g_exc_unexpected_error THEN
2405: ROLLBACK TO validate_object_budget;
2406: x_return_status := fnd_api.g_ret_sts_unexp_error;
2407: fnd_msg_pub.count_and_get(
2408: p_encoded => fnd_api.g_false
2409: ,p_count => x_msg_count
2410: ,p_data => x_msg_data);
2411:

Line 2415: fnd_msg_pub.count_and_get (

2411:
2412: WHEN OTHERS THEN
2413: ROLLBACK TO validate_object_budget;
2414: x_return_status := fnd_api.g_ret_sts_error;
2415: fnd_msg_pub.count_and_get (
2416: p_count => x_msg_count
2417: , p_data => x_msg_data
2418: , p_encoded => fnd_api.g_false
2419: );

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

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

Line 2497: FND_MSG_PUB.Add;

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

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

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

Line 2536: FND_MSG_PUB.Add;

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

Line 2560: fnd_msg_pub.count_and_get(

2556:
2557: EXCEPTION
2558: WHEN fnd_api.g_exc_error THEN
2559: x_return_status := fnd_api.g_ret_sts_error;
2560: fnd_msg_pub.count_and_get(
2561: p_encoded => fnd_api.g_false
2562: ,p_count => x_msg_count
2563: ,p_data => x_msg_data);
2564: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2566: fnd_msg_pub.count_and_get(

2562: ,p_count => x_msg_count
2563: ,p_data => x_msg_data);
2564: WHEN fnd_api.g_exc_unexpected_error THEN
2565: x_return_status := fnd_api.g_ret_sts_unexp_error;
2566: fnd_msg_pub.count_and_get(
2567: p_encoded => fnd_api.g_false
2568: ,p_count => x_msg_count
2569: ,p_data => x_msg_data);
2570:

Line 2573: fnd_msg_pub.count_and_get (

2569: ,p_data => x_msg_data);
2570:
2571: WHEN OTHERS THEN
2572: x_return_status := fnd_api.g_ret_sts_error;
2573: fnd_msg_pub.count_and_get (
2574: p_count => x_msg_count
2575: , p_data => x_msg_data
2576: , p_encoded => fnd_api.g_false
2577: );

Line 2754: fnd_msg_pub.count_and_get (

2750:
2751: EXCEPTION
2752: WHEN OTHERS THEN
2753: x_return_status := fnd_api.g_ret_sts_error;
2754: fnd_msg_pub.count_and_get (
2755: p_count => x_msg_count
2756: , p_data => x_msg_data
2757: , p_encoded => fnd_api.g_false
2758: );

Line 2846: Fnd_Msg_Pub.ADD;

2842: FROM ams_deliverables_vl
2843: WHERE deliverable_id = p_object_id;
2844: ELSE
2845: Fnd_Message.Set_Name('OZF','OZF_BAD_APPROVAL_OBJECT_TYPE');
2846: Fnd_Msg_Pub.ADD;
2847: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2848: RETURN;
2849: END IF ;
2850:

Line 2855: Fnd_Msg_Pub.ADD;

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

Line 2899: fnd_msg_pub.count_and_get (

2895:
2896: EXCEPTION
2897: WHEN OTHERS THEN
2898: x_return_status := fnd_api.g_ret_sts_error;
2899: fnd_msg_pub.count_and_get (
2900: p_count => l_msg_count
2901: , p_data => l_msg_data
2902: , p_encoded => fnd_api.g_false
2903: );

Line 2985: fnd_msg_pub.initialize;

2981: SAVEPOINT conc_validate_offer_budget;
2982:
2983: x_errbuf := null;
2984: x_retcode := 0;
2985: fnd_msg_pub.initialize;
2986:
2987: l_modifier_list_rec.QP_LIST_HEADER_ID := p_object_id;
2988:
2989: OPEN c_offer_info(p_object_id);

Line 3060: Fnd_Msg_Pub.Get

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

Line 3169: Fnd_Msg_Pub.Get

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

Line 3341: Fnd_Msg_Pub.Get

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

Line 3368: Fnd_Msg_Pub.Get

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

Line 3618: fnd_msg_pub.count_and_get(

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

Line 3626: fnd_msg_pub.count_and_get(

3622:
3623: EXCEPTION
3624: WHEN fnd_api.g_exc_error THEN
3625: x_return_status := fnd_api.g_ret_sts_error;
3626: fnd_msg_pub.count_and_get(
3627: p_encoded => fnd_api.g_false
3628: ,p_count => x_msg_count
3629: ,p_data => x_msg_data);
3630: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3632: fnd_msg_pub.count_and_get(

3628: ,p_count => x_msg_count
3629: ,p_data => x_msg_data);
3630: WHEN fnd_api.g_exc_unexpected_error THEN
3631: x_return_status := fnd_api.g_ret_sts_unexp_error;
3632: fnd_msg_pub.count_and_get(
3633: p_encoded => fnd_api.g_false
3634: ,p_count => x_msg_count
3635: ,p_data => x_msg_data);
3636: WHEN OTHERS THEN

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

3635: ,p_data => x_msg_data);
3636: WHEN OTHERS THEN
3637: x_return_status := fnd_api.g_ret_sts_unexp_error;
3638:
3639: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3640: fnd_msg_pub.add_exc_msg(G_PACKAGE_NAME, l_api_name);
3641: END IF;
3642:
3643: fnd_msg_pub.count_and_get(

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

3636: WHEN OTHERS THEN
3637: x_return_status := fnd_api.g_ret_sts_unexp_error;
3638:
3639: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3640: fnd_msg_pub.add_exc_msg(G_PACKAGE_NAME, l_api_name);
3641: END IF;
3642:
3643: fnd_msg_pub.count_and_get(
3644: p_encoded => fnd_api.g_false

Line 3643: fnd_msg_pub.count_and_get(

3639: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3640: fnd_msg_pub.add_exc_msg(G_PACKAGE_NAME, l_api_name);
3641: END IF;
3642:
3643: fnd_msg_pub.count_and_get(
3644: p_encoded => fnd_api.g_false
3645: ,p_count => x_msg_count
3646: ,p_data => x_msg_data);
3647: END budget_request_approval;