[Home] [Help]
1: PACKAGE BODY CS_CHARGE_DETAILS_PVT AS
2: /* $Header: csxvestb.pls 120.101.12020000.7 2013/05/20 09:33:42 bkanimoz ship $ */
3:
4: --==========================================================
5: -- Global Variables Decalaration
1819: -- Make the preprocessing call to the user hooks
1820: --
1821: -- Pre call to the customer type user hook
1822: --
1823: IF jtf_usr_hks.Ok_To_Execute('CS_CHARGE_DETAILS_PVT',
1824: 'Create_Charge_Details',
1825: 'B','C') THEN
1826:
1827: CS_CHARGE_DETAILS_CUHK.Create_Charge_Details_Pre(
1854:
1855: --
1856: -- Pre call to the Vertical Type User Hook
1857: --
1858: IF jtf_usr_hks.Ok_To_Execute('CS_CHARGE_DETAILS_PVT',
1859: 'Create_Charge_Details',
1860: 'B', 'V') THEN
1861:
1862: CS_CHARGE_DETAILS_VUHK.Create_Charge_Details_Pre(
2266: -- Make the postprocessing call to the user hooks
2267: --
2268: -- Post call to the customer type user hook
2269: --
2270: IF jtf_usr_hks.Ok_To_Execute('CS_CHARGE_DETAILS_PVT',
2271: 'Create_Charge_Details',
2272: 'A','C') THEN
2273:
2274: CS_CHARGE_DETAILS_CUHK.Create_Charge_Details_Post(
2302: --
2303: --
2304: -- Post call to the Vertical Type User Hook
2305: --
2306: IF jtf_usr_hks.Ok_To_Execute('CS_CHARGE_DETAILS_PVT',
2307: 'Create_Charge_Details',
2308: 'A', 'V') THEN
2309:
2310: CS_CHARGE_DETAILS_VUHK.Create_Charge_Details_Post(
2511: -- Make the preprocessing call to the user hooks
2512: --
2513: -- Pre call to the customer type user hook
2514: --
2515: IF jtf_usr_hks.Ok_To_Execute('CS_CHARGE_DETAILS_PVT',
2516: 'Update_Charge_Details',
2517: 'B','C') THEN
2518:
2519: CS_CHARGE_DETAILS_CUHK.Update_Charge_Details_Pre(
2544: --
2545: --
2546: -- Pre call to the Vertical Type User Hook
2547: --
2548: IF jtf_usr_hks.Ok_To_Execute('CS_CHARGE_DETAILS_PVT',
2549: 'Update_Charge_Details',
2550: 'B', 'V') THEN
2551:
2552: CS_CHARGE_DETAILS_VUHK.Update_Charge_Details_Pre(
2893: -- Make the postprocessing call to the user hooks
2894: --
2895: -- Post call to the customer type user hook
2896: --
2897: IF jtf_usr_hks.Ok_To_Execute('CS_CHARGE_DETAILS_PVT',
2898: 'Update_Charge_Details',
2899: 'A','C') THEN
2900:
2901: CS_CHARGE_DETAILS_CUHK.Update_Charge_Details_Post(
2927: --
2928: --
2929: -- Post call to the Vertical Type User Hook
2930: --
2931: IF jtf_usr_hks.Ok_To_Execute('CS_CHARGE_DETAILS_PVT',
2932: 'Update_Charge_Details',
2933: 'A', 'V') THEN
2934:
2935: CS_CHARGE_DETAILS_VUHK.Update_Charge_Details_Post(
15944: x_numerator OUT NOCOPY NUMBER,
15945: x_rate OUT NOCOPY NUMBER,
15946: x_return_status OUT NOCOPY VARCHAR) IS
15947:
15948: l_api_name VARCHAR2(80) := 'CS_Charge_Details_PVT.Get_Conversion_Rate';
15949: l_api_name_full CONSTANT VARCHAR2(100) := G_PKG_NAME || '.' || l_api_name ;
15950: l_log_module CONSTANT VARCHAR2(255) := 'cs.plsql.' || l_api_name_full || '.';
15951: l_conversion_type VARCHAR2(30) := FND_PROFILE.VALUE('CS_CHG_DEFAULT_CONVERSION_TYPE');
15952: l_max_roll_days NUMBER := to_number(FND_PROFILE.VALUE('CS_CHG_MAX_ROLL_DAYS'));
16206: FOR UPDATE OF ESTIMATE_DETAIL_ID NOWAIT ;
16207:
16208: EXCEPTION
16209: WHEN NO_DATA_FOUND THEN
16210: CS_Charge_Details_PVT.Add_Invalid_Argument_Msg(
16211: p_token_an => p_api_name,
16212: p_token_v => to_char(p_estimate_detail_id) ,
16213: p_token_p => 'p_estimate_detail_id') ;
16214: fnd_msg_pub.count_and_get(
16217:
16218: WHEN RECORD_LOCK_EXCEPTION THEN
16219: --p_return_status := FND_API.G_RET_STS_ERROR ;
16220: x_return_status := FND_API.G_RET_STS_ERROR ;
16221: CS_Charge_Details_PVT.Record_Is_Locked_Msg(
16222: p_token_an => p_api_name);
16223:
16224: WHEN OTHERS THEN
16225: x_return_status := FND_API.G_RET_STS_ERROR;
16345:
16346: EXCEPTION
16347:
16348: WHEN NO_DATA_FOUND THEN
16349: CS_Charge_Details_PVT.Add_Invalid_Argument_Msg(
16350: p_token_an => p_api_name,
16351: p_token_v => to_char(p_org_id) ,
16352: p_token_p => 'p_org_id') ;
16353:
17262: END IF ;
17263: END Purge_Charges;
17264: --------------------------------------------------------------------------------
17265:
17266: END CS_Charge_Details_PVT;