[Home] [Help]
1: PACKAGE BODY CS_Charge_Details_PVT AS
2: /* $Header: csxvestb.pls 120.61.12010000.5 2008/10/08 11:20:15 sshilpam ship $ */
3:
4: --==========================================================
5: -- Global Variables Decalaration
1719: -- Make the preprocessing call to the user hooks
1720: --
1721: -- Pre call to the customer type user hook
1722: --
1723: IF jtf_usr_hks.Ok_To_Execute('CS_CHARGE_DETAILS_PVT',
1724: 'Create_Charge_Details',
1725: 'B','C') THEN
1726:
1727: CS_CHARGE_DETAILS_CUHK.Create_Charge_Details_Pre(
1754:
1755: --
1756: -- Pre call to the Vertical Type User Hook
1757: --
1758: IF jtf_usr_hks.Ok_To_Execute('CS_CHARGE_DETAILS_PVT',
1759: 'Create_Charge_Details',
1760: 'B', 'V') THEN
1761:
1762: CS_CHARGE_DETAILS_VUHK.Create_Charge_Details_Pre(
2131: -- Make the postprocessing call to the user hooks
2132: --
2133: -- Post call to the customer type user hook
2134: --
2135: IF jtf_usr_hks.Ok_To_Execute('CS_CHARGE_DETAILS_PVT',
2136: 'Create_Charge_Details',
2137: 'A','C') THEN
2138:
2139: CS_CHARGE_DETAILS_CUHK.Create_Charge_Details_Post(
2167: --
2168: --
2169: -- Post call to the Vertical Type User Hook
2170: --
2171: IF jtf_usr_hks.Ok_To_Execute('CS_CHARGE_DETAILS_PVT',
2172: 'Create_Charge_Details',
2173: 'A', 'V') THEN
2174:
2175: CS_CHARGE_DETAILS_VUHK.Create_Charge_Details_Post(
2376: -- Make the preprocessing call to the user hooks
2377: --
2378: -- Pre call to the customer type user hook
2379: --
2380: IF jtf_usr_hks.Ok_To_Execute('CS_CHARGE_DETAILS_PVT',
2381: 'Update_Charge_Details',
2382: 'B','C') THEN
2383:
2384: CS_CHARGE_DETAILS_CUHK.Update_Charge_Details_Pre(
2409: --
2410: --
2411: -- Pre call to the Vertical Type User Hook
2412: --
2413: IF jtf_usr_hks.Ok_To_Execute('CS_CHARGE_DETAILS_PVT',
2414: 'Update_Charge_Details',
2415: 'B', 'V') THEN
2416:
2417: CS_CHARGE_DETAILS_VUHK.Update_Charge_Details_Pre(
2745: -- Make the postprocessing call to the user hooks
2746: --
2747: -- Post call to the customer type user hook
2748: --
2749: IF jtf_usr_hks.Ok_To_Execute('CS_CHARGE_DETAILS_PVT',
2750: 'Update_Charge_Details',
2751: 'A','C') THEN
2752:
2753: CS_CHARGE_DETAILS_CUHK.Update_Charge_Details_Post(
2779: --
2780: --
2781: -- Post call to the Vertical Type User Hook
2782: --
2783: IF jtf_usr_hks.Ok_To_Execute('CS_CHARGE_DETAILS_PVT',
2784: 'Update_Charge_Details',
2785: 'A', 'V') THEN
2786:
2787: CS_CHARGE_DETAILS_VUHK.Update_Charge_Details_Post(
14407: x_numerator OUT NOCOPY NUMBER,
14408: x_rate OUT NOCOPY NUMBER,
14409: x_return_status OUT NOCOPY VARCHAR) IS
14410:
14411: l_api_name VARCHAR2(80) := 'CS_Charge_Details_PVT.Get_Conversion_Rate';
14412: l_api_name_full CONSTANT VARCHAR2(61) := G_PKG_NAME || '.' || l_api_name ;
14413: l_log_module CONSTANT VARCHAR2(255) := 'cs.plsql.' || l_api_name_full || '.';
14414: l_conversion_type VARCHAR2(30) := FND_PROFILE.VALUE('CS_CHG_DEFAULT_CONVERSION_TYPE');
14415: l_max_roll_days NUMBER := to_number(FND_PROFILE.VALUE('CS_CHG_MAX_ROLL_DAYS'));
14669: FOR UPDATE OF ESTIMATE_DETAIL_ID NOWAIT ;
14670:
14671: EXCEPTION
14672: WHEN NO_DATA_FOUND THEN
14673: CS_Charge_Details_PVT.Add_Invalid_Argument_Msg(
14674: p_token_an => p_api_name,
14675: p_token_v => to_char(p_estimate_detail_id) ,
14676: p_token_p => 'p_estimate_detail_id') ;
14677: fnd_msg_pub.count_and_get(
14680:
14681: WHEN RECORD_LOCK_EXCEPTION THEN
14682: --p_return_status := FND_API.G_RET_STS_ERROR ;
14683: x_return_status := FND_API.G_RET_STS_ERROR ;
14684: CS_Charge_Details_PVT.Record_Is_Locked_Msg(
14685: p_token_an => p_api_name);
14686:
14687: WHEN OTHERS THEN
14688: x_return_status := FND_API.G_RET_STS_ERROR;
14776:
14777: EXCEPTION
14778:
14779: WHEN NO_DATA_FOUND THEN
14780: CS_Charge_Details_PVT.Add_Invalid_Argument_Msg(
14781: p_token_an => p_api_name,
14782: p_token_v => to_char(p_org_id) ,
14783: p_token_p => 'p_org_id') ;
14784:
15690: END IF ;
15691: END Purge_Charges;
15692: --------------------------------------------------------------------------------
15693:
15694: END CS_Charge_Details_PVT;