DBA Data[Home] [Help]

APPS.PA_BUDGET_ACCOUNT_PKG dependencies on PA_BUDGET_ACCOUNT_PKG

Line 1: PACKAGE BODY PA_BUDGET_ACCOUNT_PKG AS

1: PACKAGE BODY PA_BUDGET_ACCOUNT_PKG AS
2: -- $Header: PABDACGB.pls 120.6.12000000.3 2007/10/26 05:42:44 pvishnoi ship $
3:
4: -- ## Forward Declaration
5: PROCEDURE Upd_Budget_Acct_Line (

Line 21: -- Package : PA_BUDGET_ACCOUNT_PKG

17: X_Msg_Data OUT NOCOPY VARCHAR2
18: );
19:
20: ----------------------------------------------------------------------------------------+
21: -- Package : PA_BUDGET_ACCOUNT_PKG
22: --
23: -- Purpose : 1) Generate the Account Code CCID for every Budget Line
24: -- depending upon the calling mode parameter.
25: -- 2) Update the Budget Line Data with generated CCID

Line 91: PA_BUDGET_ACCOUNT_PKG.Gen_Acct_All_Lines (

87: -----------------------------------------------------------------+
88: -- If found then call API Gen_Acct_All_Lines() to generate CCID
89: -- for all its Budget Lines
90: -----------------------------------------------------------------+
91: PA_BUDGET_ACCOUNT_PKG.Gen_Acct_All_Lines (
92: P_Budget_Version_ID, -- Current version of the Budget
93: P_Calling_Mode, -- Input from SQL*Form
94: l_Budget_Type_Code,
95: l_Budget_Entry_Level_Code,

Line 116: FND_MSG_PUB.add_Exc_msg( P_Pkg_Name => 'PA_BUDGET_ACCOUNT_PKG',

112: WHEN OTHERS THEN
113: X_Msg_Count := 1;
114: X_Msg_Data := SUBSTR(SQLERRM, 1, 240);
115: X_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
116: FND_MSG_PUB.add_Exc_msg( P_Pkg_Name => 'PA_BUDGET_ACCOUNT_PKG',
117: P_Procedure_Name => 'Gen_Account');
118: END Gen_Account; /* End of Gen_Account API */
119:
120: PROCEDURE Gen_Acct_All_Lines (

Line 363: PA_BUDGET_ACCOUNT_PKG.Insert_Into_Budget_Lines (

359: -- whose GL Periods are not existing ...
360: -- NOT REQUIRED TO GENERATE : 04/23/01
361: --------------------------------------------------+
362: PA_FCK_UTIL.debug_msg(' before calling .... Insert_Into_Budget_Lines ');
363: PA_BUDGET_ACCOUNT_PKG.Insert_Into_Budget_Lines (
364: P_Budget_Version_ID,
365: P_Project_ID,
366: l_Project_Start_Date,
367: l_Project_End_Date,

Line 446: PA_BUDGET_ACCOUNT_PKG.Gen_Acct_Line (

442: (P_Calling_Mode = 'GENERATE_ACCOUNT')
443: THEN
444:
445: PA_FCK_UTIL.debug_msg('before calling gen_acct_line ..........');
446: PA_BUDGET_ACCOUNT_PKG.Gen_Acct_Line (
447: P_Budget_Entry_Level_Code,
448: P_Budget_Type_Code,
449: P_Budget_Version_ID,
450:

Line 627: PA_BUDGET_ACCOUNT_PKG.Upd_Budget_Acct_Line (

623: (P_Calling_Mode in ('SUBMIT','GENERATE_ACCOUNT')
624: or (P_Calling_Mode in ('BASELINE') and l_is_cc_budget = 'Y'))) then
625:
626: -- Update the Budget and Available balance amounts
627: PA_BUDGET_ACCOUNT_PKG.Upd_Budget_Acct_Line (
628: p_Budget_Type_Code,
629: p_Project_ID,
630: bl.Period_Name,
631: bl.Start_Date,

Line 734: FND_MSG_PUB.add_Exc_msg( P_Pkg_Name => 'PA_BUDGET_ACCOUNT_PKG',

730: WHEN OTHERS THEN
731: X_Msg_Count := 1;
732: X_Msg_Data := SUBSTR(SQLERRM, 1, 240);
733: X_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
734: FND_MSG_PUB.add_Exc_msg( P_Pkg_Name => 'PA_BUDGET_ACCOUNT_PKG',
735: P_Procedure_Name => 'Gen_Acct_All_Lines');
736:
737: END Gen_Acct_All_Lines ; /* End of Gen_Acct_All_Lines API */
738:

Line 855: PA_BUDGET_ACCOUNT_PKG.Derive_Task_Params (

851: PA_FCK_UTIL.debug_msg(l_return_status||' gen before calling Derive_Task_Params ..........');
852: ------------------------------------------------+
853: -- Now Derive Task Parameters and their Details
854: ------------------------------------------------+
855: PA_BUDGET_ACCOUNT_PKG.Derive_Task_Params (
856: p_project_Id => p_project_Id,
857: p_top_task_Id => l_top_task_Id,
858: p_low_task_Id => l_low_task_Id,
859: x_top_task_number => l_top_task_number,

Line 875: PA_BUDGET_ACCOUNT_PKG.Derive_Resource_Params (

871: PA_FCK_UTIL.debug_msg(l_return_status||' gen before calling derive_res_para ..........');
872: ------------------------------------------------+
873: -- Derive Resource Parameters and their Details
874: ------------------------------------------------+
875: PA_BUDGET_ACCOUNT_PKG.Derive_Resource_Params (
876: p_person_Id => p_person_Id,
877: p_Job_Id => p_Job_Id,
878: p_organization_Id => p_organization_Id,
879: p_supplier_Id => p_supplier_Id,

Line 1214: FND_MSG_PUB.add_Exc_msg( P_Pkg_Name => 'PA_BUDGET_ACCOUNT_PKG',

1210: X_Msg_Count := 1;
1211: X_Msg_Data := SUBSTR(SQLERRM, 1, 240);
1212: X_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1213:
1214: FND_MSG_PUB.add_Exc_msg( P_Pkg_Name => 'PA_BUDGET_ACCOUNT_PKG',
1215: P_Procedure_Name => 'Gen_Acct_Line');
1216:
1217: ------------------------------------------------------------------------------+
1218: -- W/F related Error:

Line 1221: wf_Core.context( pkg_name => 'PA_BUDGET_ACCOUNT_PKG',

1217: ------------------------------------------------------------------------------+
1218: -- W/F related Error:
1219: -- Record error using generic error message routine for debugging and raise it
1220: ------------------------------------------------------------------------------+
1221: wf_Core.context( pkg_name => 'PA_BUDGET_ACCOUNT_PKG',
1222: proc_name => 'Gen_Acct_Line',
1223: arg1 => 'Budget Version ID : '|| p_Budget_version_Id,
1224: arg2 => 'Project ID : '|| p_project_Id,
1225: arg3 => null,

Line 1369: FND_MSG_PUB.add_Exc_msg( P_Pkg_Name => 'PA_BUDGET_ACCOUNT_PKG',

1365: X_Msg_Count := 1;
1366: X_Msg_Data := SUBSTR(SQLERRM, 1, 240);
1367: X_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1368:
1369: FND_MSG_PUB.add_Exc_msg( P_Pkg_Name => 'PA_BUDGET_ACCOUNT_PKG',
1370: P_Procedure_Name => 'Upd_Budget_Acct_Line');
1371:
1372: END Upd_Budget_Acct_Line; /* End API UPD_Budget_Acct_Line */
1373:

Line 1648: FND_MSG_PUB.add_Exc_msg( P_Pkg_Name => 'PA_BUDGET_ACCOUNT_PKG',

1644: X_Msg_Count := 1;
1645: X_Msg_Data := SUBSTR(SQLERRM, 1, 240);
1646: X_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1647:
1648: FND_MSG_PUB.add_Exc_msg( P_Pkg_Name => 'PA_BUDGET_ACCOUNT_PKG',
1649: P_Procedure_Name => 'Insert_Into_Budget_Lines');
1650: END Insert_Into_Budget_Lines ; /* End API Insert_Into_Budget_Lines */
1651:
1652: PROCEDURE Derive_Resource_Params (

Line 1772: FND_MSG_PUB.add_Exc_msg( p_pkg_name => 'PA_BUDGET_ACCOUNT_PKG',

1768: x_msg_Count := 1;
1769: x_msg_Data := substr(SQLERRM, 1, 240);
1770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1771:
1772: FND_MSG_PUB.add_Exc_msg( p_pkg_name => 'PA_BUDGET_ACCOUNT_PKG',
1773: p_procedure_name => 'Derive_Resource_Params');
1774:
1775: END Derive_Resource_Params ; /* End API Derive_Resource_Params */
1776:

Line 1857: FND_MSG_PUB.add_Exc_msg( p_pkg_name => 'PA_BUDGET_ACCOUNT_PKG',

1853: x_msg_Count := 1;
1854: x_msg_Data := substr(SQLERRM, 1, 240);
1855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1856:
1857: FND_MSG_PUB.add_Exc_msg( p_pkg_name => 'PA_BUDGET_ACCOUNT_PKG',
1858: p_procedure_name => 'Derive_Task_Params');
1859:
1860: END Derive_Task_Params ; /* End API Derive_Task_Params */
1861:

Line 1862: END PA_BUDGET_ACCOUNT_PKG ; /* End Package Body PA_BUDGET_ACCOUNT_PKG */

1858: p_procedure_name => 'Derive_Task_Params');
1859:
1860: END Derive_Task_Params ; /* End API Derive_Task_Params */
1861:
1862: END PA_BUDGET_ACCOUNT_PKG ; /* End Package Body PA_BUDGET_ACCOUNT_PKG */