[Home] [Help]
222:
223:
224:
225: BEGIN
226: -- Standard begin of API savepoint
227: SAVEPOINT Get_GL_Account_PVT;
228: -- Standard call to check for call compatibility.
229: IF NOT FND_API.Compatible_API_Call (
230: l_api_version,
224:
225: BEGIN
226: -- Standard begin of API savepoint
227: SAVEPOINT Get_GL_Account_PVT;
228: -- Standard call to check for call compatibility.
229: IF NOT FND_API.Compatible_API_Call (
230: l_api_version,
231: p_api_version,
232: l_api_name,
476: END IF;
477: END IF;
478: END LOOP;
479:
480: --Standard check of commit
481: IF FND_API.To_Boolean ( p_commit ) THEN
482: COMMIT WORK;
483: END IF;
484: -- Debug Message
486: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
487: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
488: FND_MSG_PUB.Add;
489: END IF;
490: --Standard call to get message count and if count=1, get the message
491: FND_MSG_PUB.Count_And_Get (
492: p_encoded => FND_API.G_FALSE,
493: p_count => x_msg_count,
494: p_data => x_msg_data
496: EXCEPTION
497: WHEN FND_API.G_EXC_ERROR THEN
498: ROLLBACK TO Get_GL_Account_PVT;
499: x_return_status := FND_API.G_RET_STS_ERROR;
500: -- Standard call to get message count and if count=1, get the message
501: FND_MSG_PUB.Count_And_Get (
502: p_encoded => FND_API.G_FALSE,
503: p_count => x_msg_count,
504: p_data => x_msg_data
505: );
506: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
507: ROLLBACK TO Get_GL_Account_PVT;
508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
509: -- Standard call to get message count and if count=1, get the message
510: FND_MSG_PUB.Count_And_Get (
511: p_encoded => FND_API.G_FALSE,
512: p_count => x_msg_count,
513: p_data => x_msg_data
518: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
519: THEN
520: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
521: END IF;
522: -- Standard call to get message count and if count=1, get the message
523: FND_MSG_PUB.Count_And_Get (
524: p_encoded => FND_API.G_FALSE,
525: p_count => x_msg_count,
526: p_data => x_msg_data
1785: l_api_version CONSTANT NUMBER := 1.0;
1786: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME ||'.'|| l_api_name;
1787: --
1788: BEGIN
1789: -- Standard call to check for call compatibility.
1790: IF NOT FND_API.Compatible_API_Call (
1791: l_api_version,
1792: p_api_version,
1793: l_api_name,
1865: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1866: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
1867: FND_MSG_PUB.Add;
1868: END IF;
1869: --Standard call to get message count and if count=1, get the message
1870: FND_MSG_PUB.Count_And_Get (
1871: p_encoded => FND_API.G_FALSE,
1872: p_count => x_msg_count,
1873: p_data => x_msg_data
1874: );
1875: EXCEPTION
1876: WHEN FND_API.G_EXC_ERROR THEN
1877: x_return_status := FND_API.G_RET_STS_ERROR;
1878: -- Standard call to get message count and if count=1, get the message
1879: FND_MSG_PUB.Count_And_Get (
1880: p_encoded => FND_API.G_FALSE,
1881: p_count => x_msg_count,
1882: p_data => x_msg_data
1882: p_data => x_msg_data
1883: );
1884: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1885: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1886: -- Standard call to get message count and if count=1, get the message
1887: FND_MSG_PUB.Count_And_Get (
1888: p_encoded => FND_API.G_FALSE,
1889: p_count => x_msg_count,
1890: p_data => x_msg_data
1894: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1895: THEN
1896: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1897: END IF;
1898: -- Standard call to get message count and if count=1, get the message
1899: FND_MSG_PUB.Count_And_Get (
1900: p_encoded => FND_API.G_FALSE,
1901: p_count => x_msg_count,
1902: p_data => x_msg_data
1981: FROM xla_event_types_vl
1982: WHERE application_id = 682
1983: AND event_type_Code = cv_event_type_code;
1984: BEGIN
1985: -- Standard begin of API savepoint
1986: SAVEPOINT Create_SLA_Accrual_Extract;
1987: -- Standard call to check for call compatibility.
1988: IF NOT FND_API.Compatible_API_Call (
1989: l_api_version,
1983: AND event_type_Code = cv_event_type_code;
1984: BEGIN
1985: -- Standard begin of API savepoint
1986: SAVEPOINT Create_SLA_Accrual_Extract;
1987: -- Standard call to check for call compatibility.
1988: IF NOT FND_API.Compatible_API_Call (
1989: l_api_version,
1990: p_api_version,
1991: l_api_name,
2150: ,l_actg_expense_ccid
2151: );
2152:
2153:
2154: --Standard check of commit
2155: IF FND_API.To_Boolean ( p_commit ) THEN
2156: COMMIT WORK;
2157: END IF;
2158: -- Debug Message
2160: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2161: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
2162: FND_MSG_PUB.Add;
2163: END IF;
2164: --Standard call to get message count and if count=1, get the message
2165: FND_MSG_PUB.Count_And_Get (
2166: p_encoded => FND_API.G_FALSE,
2167: p_count => x_msg_count,
2168: p_data => x_msg_data
2177:
2178: WHEN FND_API.G_EXC_ERROR THEN
2179: ROLLBACK TO Create_SLA_Accrual_Extract;
2180: x_return_status := FND_API.G_RET_STS_ERROR;
2181: -- Standard call to get message count and if count=1, get the message
2182: FND_MSG_PUB.Count_And_Get (
2183: p_encoded => FND_API.G_FALSE,
2184: p_count => x_msg_count,
2185: p_data => x_msg_data
2186: );
2187: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2188: ROLLBACK TO Create_SLA_Accrual_Extract;
2189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2190: -- Standard call to get message count and if count=1, get the message
2191: FND_MSG_PUB.Count_And_Get (
2192: p_encoded => FND_API.G_FALSE,
2193: p_count => x_msg_count,
2194: p_data => x_msg_data
2199: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2200: THEN
2201: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2202: END IF;
2203: -- Standard call to get message count and if count=1, get the message
2204: FND_MSG_PUB.Count_And_Get (
2205: p_encoded => FND_API.G_FALSE,
2206: p_count => x_msg_count,
2207: p_data => x_msg_data
2336: ORDER BY ap.creation_date desc;
2337:
2338:
2339: BEGIN
2340: -- Standard begin of API savepoint
2341: SAVEPOINT Create_SLA_Claim_Extract;
2342: -- Standard call to check for call compatibility.
2343: IF NOT FND_API.Compatible_API_Call (
2344: l_api_version,
2338:
2339: BEGIN
2340: -- Standard begin of API savepoint
2341: SAVEPOINT Create_SLA_Claim_Extract;
2342: -- Standard call to check for call compatibility.
2343: IF NOT FND_API.Compatible_API_Call (
2344: l_api_version,
2345: p_api_version,
2346: l_api_name,
2589:
2590: END IF;
2591:
2592: END IF;
2593: --Standard check of commit
2594: IF FND_API.To_Boolean ( p_commit ) THEN
2595: COMMIT WORK;
2596: END IF;
2597: -- Debug Message
2599: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2600: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
2601: FND_MSG_PUB.Add;
2602: END IF;
2603: --Standard call to get message count and if count=1, get the message
2604: FND_MSG_PUB.Count_And_Get (
2605: p_encoded => FND_API.G_FALSE,
2606: p_count => x_msg_count,
2607: p_data => x_msg_data
2617:
2618: WHEN FND_API.G_EXC_ERROR THEN
2619: ROLLBACK TO Create_SLA_Claim_Extract;
2620: x_return_status := FND_API.G_RET_STS_ERROR;
2621: -- Standard call to get message count and if count=1, get the message
2622: FND_MSG_PUB.Count_And_Get (
2623: p_encoded => FND_API.G_FALSE,
2624: p_count => x_msg_count,
2625: p_data => x_msg_data
2626: );
2627: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2628: ROLLBACK TO Create_SLA_Claim_Extract;
2629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2630: -- Standard call to get message count and if count=1, get the message
2631: FND_MSG_PUB.Count_And_Get (
2632: p_encoded => FND_API.G_FALSE,
2633: p_count => x_msg_count,
2634: p_data => x_msg_data
2639: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2640: THEN
2641: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2642: END IF;
2643: -- Standard call to get message count and if count=1, get the message
2644: FND_MSG_PUB.Count_And_Get (
2645: p_encoded => FND_API.G_FALSE,
2646: p_count => x_msg_count,
2647: p_data => x_msg_data
2717:
2718: l_offer_type varchar2(30) ;
2719:
2720: BEGIN
2721: -- Standard begin of API savepoint
2722: SAVEPOINT Create_Gl_Entry_PVT;
2723: -- Standard call to check for call compatibility.
2724: IF NOT FND_API.Compatible_API_Call (
2725: l_api_version,
2719:
2720: BEGIN
2721: -- Standard begin of API savepoint
2722: SAVEPOINT Create_Gl_Entry_PVT;
2723: -- Standard call to check for call compatibility.
2724: IF NOT FND_API.Compatible_API_Call (
2725: l_api_version,
2726: p_api_version,
2727: l_api_name,
3016:
3017: -- pass accounting event id
3018: --//ER#9382547 ChRM-SLA Uptake
3019:
3020: --Standard check of commit
3021: IF FND_API.To_Boolean ( p_commit ) THEN
3022: COMMIT WORK;
3023: END IF;
3024: -- Debug Message
3026: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
3027: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
3028: FND_MSG_PUB.Add;
3029: END IF;
3030: --Standard call to get message count and if count=1, get the message
3031: FND_MSG_PUB.Count_And_Get (
3032: p_encoded => FND_API.G_FALSE,
3033: p_count => x_msg_count,
3034: p_data => x_msg_data
3036: EXCEPTION
3037: WHEN FND_API.G_EXC_ERROR THEN
3038: ROLLBACK TO Create_Gl_Entry_PVT;
3039: x_return_status := FND_API.G_RET_STS_ERROR;
3040: -- Standard call to get message count and if count=1, get the message
3041: FND_MSG_PUB.Count_And_Get (
3042: p_encoded => FND_API.G_FALSE,
3043: p_count => x_msg_count,
3044: p_data => x_msg_data
3045: );
3046: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3047: ROLLBACK TO Create_Gl_Entry_PVT;
3048: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3049: -- Standard call to get message count and if count=1, get the message
3050: FND_MSG_PUB.Count_And_Get (
3051: p_encoded => FND_API.G_FALSE,
3052: p_count => x_msg_count,
3053: p_data => x_msg_data
3058: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3059: THEN
3060: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3061: END IF;
3062: -- Standard call to get message count and if count=1, get the message
3063: FND_MSG_PUB.Count_And_Get (
3064: p_encoded => FND_API.G_FALSE,
3065: p_count => x_msg_count,
3066: p_data => x_msg_data
3115: from ozf_acctng_events_all
3116: where accounting_event_id = p_id;
3117:
3118: BEGIN
3119: -- Standard begin of API savepoint
3120: SAVEPOINT Create_Acctng_Entries;
3121: -- Standard call to check for call compatibility.
3122: IF NOT FND_API.Compatible_API_Call (
3123: l_api_version,
3117:
3118: BEGIN
3119: -- Standard begin of API savepoint
3120: SAVEPOINT Create_Acctng_Entries;
3121: -- Standard call to check for call compatibility.
3122: IF NOT FND_API.Compatible_API_Call (
3123: l_api_version,
3124: p_api_version,
3125: l_api_name,
3227: UPDATE ozf_acctng_events_all
3228: SET event_status_code = 'ACCOUNTED'
3229: where accounting_event_id = l_accounting_event_id;
3230:
3231: --Standard check of commit
3232: IF FND_API.To_Boolean ( p_commit ) THEN
3233: COMMIT WORK;
3234: END IF;
3235: -- Debug Message
3237: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
3238: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
3239: FND_MSG_PUB.Add;
3240: END IF;
3241: --Standard call to get message count and if count=1, get the message
3242: FND_MSG_PUB.Count_And_Get (
3243: p_encoded => FND_API.G_FALSE,
3244: p_count => x_msg_count,
3245: p_data => x_msg_data
3247: EXCEPTION
3248: WHEN FND_API.G_EXC_ERROR THEN
3249: ROLLBACK TO Create_Acctng_Entries;
3250: x_return_status := FND_API.G_RET_STS_ERROR;
3251: -- Standard call to get message count and if count=1, get the message
3252: FND_MSG_PUB.Count_And_Get (
3253: p_encoded => FND_API.G_FALSE,
3254: p_count => x_msg_count,
3255: p_data => x_msg_data
3256: );
3257: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3258: ROLLBACK TO Create_Acctng_Entries;
3259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3260: -- Standard call to get message count and if count=1, get the message
3261: FND_MSG_PUB.Count_And_Get (
3262: p_encoded => FND_API.G_FALSE,
3263: p_count => x_msg_count,
3264: p_data => x_msg_data
3269: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3270: THEN
3271: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3272: END IF;
3273: -- Standard call to get message count and if count=1, get the message
3274: FND_MSG_PUB.Count_And_Get (
3275: p_encoded => FND_API.G_FALSE,
3276: p_count => x_msg_count,
3277: p_data => x_msg_data
3434: AND nvl(a.adjustment_period_flag,'N') = 'N'
3435: AND a.closing_status IN ( 'O','F');
3436:
3437: BEGIN
3438: -- Standard begin of API savepoint
3439: SAVEPOINT Revert_GL_Entry;
3440:
3441: -- Standard call to check for call compatibility.
3442: IF NOT FND_API.Compatible_API_Call (
3437: BEGIN
3438: -- Standard begin of API savepoint
3439: SAVEPOINT Revert_GL_Entry;
3440:
3441: -- Standard call to check for call compatibility.
3442: IF NOT FND_API.Compatible_API_Call (
3443: l_api_version,
3444: p_api_version,
3445: l_api_name,
3746: END IF;
3747:
3748: END IF;
3749:
3750: --Standard check of commit
3751: IF FND_API.To_Boolean ( p_commit ) THEN
3752: COMMIT WORK;
3753: END IF;
3754: -- Debug Message
3757: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
3758: FND_MSG_PUB.Add;
3759: FND_MSG_PUB.Add;
3760: END IF;
3761: --Standard call to get message count and if count=1, get the message
3762: FND_MSG_PUB.Count_And_Get (
3763: p_encoded => FND_API.G_FALSE,
3764: p_count => x_msg_count,
3765: p_data => x_msg_data
3767: EXCEPTION
3768: WHEN FND_API.G_EXC_ERROR THEN
3769: ROLLBACK TO Revert_GL_Entry;
3770: x_return_status := FND_API.G_RET_STS_ERROR;
3771: -- Standard call to get message count and if count=1, get the message
3772: FND_MSG_PUB.Count_And_Get (
3773: p_encoded => FND_API.G_FALSE,
3774: p_count => x_msg_count,
3775: p_data => x_msg_data
3776: );
3777: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3778: ROLLBACK TO Revert_GL_Entry;
3779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3780: -- Standard call to get message count and if count=1, get the message
3781: FND_MSG_PUB.Count_And_Get (
3782: p_encoded => FND_API.G_FALSE,
3783: p_count => x_msg_count,
3784: p_data => x_msg_data
3789: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3790: THEN
3791: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3792: END IF;
3793: -- Standard call to get message count and if count=1, get the message
3794: FND_MSG_PUB.Count_And_Get (
3795: p_encoded => FND_API.G_FALSE,
3796: p_count => x_msg_count,
3797: p_data => x_msg_data
3842:
3843: l_gl_rec OZF_GL_INTERFACE_PVT.gl_interface_rec_type;
3844:
3845: BEGIN
3846: -- Standard begin of API savepoint
3847: SAVEPOINT Post_Accrual_To_GL;
3848: -- Standard call to check for call compatibility.
3849: IF NOT FND_API.Compatible_API_Call (
3850: l_api_version,
3844:
3845: BEGIN
3846: -- Standard begin of API savepoint
3847: SAVEPOINT Post_Accrual_To_GL;
3848: -- Standard call to check for call compatibility.
3849: IF NOT FND_API.Compatible_API_Call (
3850: l_api_version,
3851: p_api_version,
3852: l_api_name,
3906: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
3907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3908: END IF;
3909:
3910: --Standard check of commit
3911: IF FND_API.To_Boolean ( p_commit ) THEN
3912: COMMIT WORK;
3913: END IF;
3914: -- Debug Message
3916: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
3917: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
3918: FND_MSG_PUB.Add;
3919: END IF;
3920: --Standard call to get message count and if count=1, get the message
3921: FND_MSG_PUB.Count_And_Get (
3922: p_encoded => FND_API.G_FALSE,
3923: p_count => x_msg_count,
3924: p_data => x_msg_data
3926: EXCEPTION
3927: WHEN FND_API.G_EXC_ERROR THEN
3928: ROLLBACK TO Post_Accrual_To_GL;
3929: x_return_status := FND_API.G_RET_STS_ERROR;
3930: -- Standard call to get message count and if count=1, get the message
3931: FND_MSG_PUB.Count_And_Get (
3932: p_encoded => FND_API.G_FALSE,
3933: p_count => x_msg_count,
3934: p_data => x_msg_data
3935: );
3936: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3937: ROLLBACK TO Post_Accrual_To_GL;
3938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3939: -- Standard call to get message count and if count=1, get the message
3940: FND_MSG_PUB.Count_And_Get (
3941: p_encoded => FND_API.G_FALSE,
3942: p_count => x_msg_count,
3943: p_data => x_msg_data
3948: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3949: THEN
3950: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3951: END IF;
3952: -- Standard call to get message count and if count=1, get the message
3953: FND_MSG_PUB.Count_And_Get (
3954: p_encoded => FND_API.G_FALSE,
3955: p_count => x_msg_count,
3956: p_data => x_msg_data
4008: l_gl_rec OZF_GL_INTERFACE_PVT.gl_interface_rec_type;
4009: l_taxfor VARCHAR2(2);
4010:
4011: BEGIN
4012: -- Standard begin of API savepoint
4013: SAVEPOINT Post_Claim_To_GL;
4014: -- Standard call to check for call compatibility.
4015: IF NOT FND_API.Compatible_API_Call (
4016: l_api_version,
4010:
4011: BEGIN
4012: -- Standard begin of API savepoint
4013: SAVEPOINT Post_Claim_To_GL;
4014: -- Standard call to check for call compatibility.
4015: IF NOT FND_API.Compatible_API_Call (
4016: l_api_version,
4017: p_api_version,
4018: l_api_name,
4096: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
4097: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4098: END IF;
4099:
4100: --Standard check of commit
4101: IF FND_API.To_Boolean ( p_commit ) THEN
4102: COMMIT WORK;
4103: END IF;
4104: -- Debug Message
4106: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
4107: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
4108: FND_MSG_PUB.Add;
4109: END IF;
4110: --Standard call to get message count and if count=1, get the message
4111: FND_MSG_PUB.Count_And_Get (
4112: p_encoded => FND_API.G_FALSE,
4113: p_count => x_msg_count,
4114: p_data => x_msg_data
4116: EXCEPTION
4117: WHEN FND_API.G_EXC_ERROR THEN
4118: ROLLBACK TO Post_Claim_To_GL;
4119: x_return_status := FND_API.G_RET_STS_ERROR;
4120: -- Standard call to get message count and if count=1, get the message
4121: FND_MSG_PUB.Count_And_Get (
4122: p_encoded => FND_API.G_FALSE,
4123: p_count => x_msg_count,
4124: p_data => x_msg_data
4125: );
4126: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4127: ROLLBACK TO Post_Claim_To_GL;
4128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4129: -- Standard call to get message count and if count=1, get the message
4130: FND_MSG_PUB.Count_And_Get (
4131: p_encoded => FND_API.G_FALSE,
4132: p_count => x_msg_count,
4133: p_data => x_msg_data
4138: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4139: THEN
4140: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4141: END IF;
4142: -- Standard call to get message count and if count=1, get the message
4143: FND_MSG_PUB.Count_And_Get (
4144: p_encoded => FND_API.G_FALSE,
4145: p_count => x_msg_count,
4146: p_data => x_msg_data