eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMW_FINSTMT_CERT_PVT dependencies on AMW_FINSTMT_CERT_PVT

Line 1: PACKAGE BODY AMW_FINSTMT_CERT_PVT as

1: PACKAGE BODY AMW_FINSTMT_CERT_PVT as
2: /* $Header: amwvfscb.pls 120.4 2006/05/25 23:52:58 npanandi noship $ */
3:
4: g_user_id NUMBER;
5: g_login_id NUMBER;

Line 9: G_PKG_NAME CONSTANT VARCHAR2 (30) := 'AMW_FINSTMT_CERT_PVT';

5: g_login_id NUMBER;
6: g_errbuf VARCHAR2(2000) := null;
7: g_retcode VARCHAR2(2);
8:
9: G_PKG_NAME CONSTANT VARCHAR2 (30) := 'AMW_FINSTMT_CERT_PVT';
10: G_API_NAME CONSTANT VARCHAR2 (15) := 'amwvfcsb.pls';
11:
12:
13: /************comment by dong ************************

Line 1943: fnd_file.put_line (fnd_file.LOG, SUBSTR ('No data found in AMW_FINSTMT_CERT_PVT.Populate_All_Fin_Process_Eval_Sum'

1939:
1940:
1941: EXCEPTION
1942: WHEN NO_DATA_FOUND THEN
1943: fnd_file.put_line (fnd_file.LOG, SUBSTR ('No data found in AMW_FINSTMT_CERT_PVT.Populate_All_Fin_Process_Eval_Sum'
1944: || SUBSTR (SQLERRM, 1, 100), 1, 200));
1945: WHEN OTHERS THEN
1946: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in AMW_FINSTMT_CERT_PVT.Populate_All_Fin_Proc_Eval_Sum'
1947: || SUBSTR (SQLERRM, 1, 100), 1, 200));

Line 1946: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in AMW_FINSTMT_CERT_PVT.Populate_All_Fin_Proc_Eval_Sum'

1942: WHEN NO_DATA_FOUND THEN
1943: fnd_file.put_line (fnd_file.LOG, SUBSTR ('No data found in AMW_FINSTMT_CERT_PVT.Populate_All_Fin_Process_Eval_Sum'
1944: || SUBSTR (SQLERRM, 1, 100), 1, 200));
1945: WHEN OTHERS THEN
1946: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in AMW_FINSTMT_CERT_PVT.Populate_All_Fin_Proc_Eval_Sum'
1947: || SUBSTR (SQLERRM, 1, 100), 1, 200));
1948: ROLLBACK TO Populate_All_Fin_Proc_Eval_Sum;
1949: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1950: FND_MSG_PUB.Count_And_Get(

Line 3246: AMW_FINSTMT_CERT_PVT.GetGLPeriodfor_FinCertEvalSum(

3242: M_FINANCIAL_STATEMENT_ID := certifications.FINANCIAL_STATEMENT_ID;
3243: M_STATEMENT_GROUP_ID := certifications.STATEMENT_GROUP_ID;
3244: M_OBJECT_TYPE := 'FINANCIAL STATEMENT';
3245:
3246: AMW_FINSTMT_CERT_PVT.GetGLPeriodfor_FinCertEvalSum(
3247: P_Certification_ID => M_CERTIFICATION_ID ,
3248: P_start_date => M_START_DATE,
3249: P_end_date => M_END_DATE);
3250:

Line 3252: AMW_FINSTMT_CERT_PVT.compute_values_for_eval_sum

3248: P_start_date => M_START_DATE,
3249: P_end_date => M_END_DATE);
3250:
3251:
3252: AMW_FINSTMT_CERT_PVT.compute_values_for_eval_sum
3253: (P_CERTIFICATION_ID => M_CERTIFICATION_ID,
3254: P_FINANCIAL_STATEMENT_ID => M_FINANCIAL_STATEMENT_ID ,
3255: P_STATEMENT_GROUP_ID => M_STATEMENT_GROUP_ID ,
3256: -- P_PARENT_FIN_ITEM_ID => null,

Line 3315: AMW_FINSTMT_CERT_PVT.GetGLPeriodfor_FinCertEvalSum(

3311: M_FINANCIAL_STATEMENT_ID := certifications.FINANCIAL_STATEMENT_ID;
3312: M_STATEMENT_GROUP_ID := certifications.STATEMENT_GROUP_ID;
3313: M_OBJECT_TYPE := 'FINANCIAL STATEMENT';
3314:
3315: AMW_FINSTMT_CERT_PVT.GetGLPeriodfor_FinCertEvalSum(
3316: P_Certification_ID => M_CERTIFICATION_ID ,
3317: P_start_date => M_START_DATE,
3318: P_end_date => M_END_DATE);
3319:

Line 3322: AMW_FINSTMT_CERT_PVT.compute_values_for_eval_sum

3318: P_end_date => M_END_DATE);
3319:
3320:
3321:
3322: AMW_FINSTMT_CERT_PVT.compute_values_for_eval_sum
3323: (P_CERTIFICATION_ID => M_CERTIFICATION_ID,
3324: P_FINANCIAL_STATEMENT_ID => M_FINANCIAL_STATEMENT_ID ,
3325: P_STATEMENT_GROUP_ID => M_STATEMENT_GROUP_ID ,
3326: -- P_PARENT_FIN_ITEM_ID => null,

Line 3676: AMW_FINSTMT_CERT_PVT.compute_values_for_eval_sum

3672:
3673: g_user_id := fnd_global.user_id;
3674: g_login_id := fnd_global.conc_login_id;
3675:
3676: AMW_FINSTMT_CERT_PVT.compute_values_for_eval_sum
3677: (P_CERTIFICATION_ID => M_CERTIFICATION_ID,
3678: P_FINANCIAL_STATEMENT_ID => M_FINANCIAL_STATEMENT_ID ,
3679: P_STATEMENT_GROUP_ID => M_STATEMENT_GROUP_ID ,
3680: -- P_PARENT_FIN_ITEM_ID => null,

Line 3761: AMW_FINSTMT_CERT_PVT.insert_fin_cert_eval_sum(

3757: end if;
3758:
3759:
3760: -- insert a fin item record
3761: AMW_FINSTMT_CERT_PVT.insert_fin_cert_eval_sum(
3762: X_FIN_CERTIFICATION_ID => M_CERTIFICATION_ID,
3763: X_FINANCIAL_STATEMENT_ID => M_FINANCIAL_STATEMENT_ID,
3764: X_FINANCIAL_ITEM_ID => M_FINANCIAL_ITEM_ID,
3765: X_ACCOUNT_GROUP_ID => NULL ,

Line 3945: AMW_FINSTMT_CERT_PVT.compute_values_for_eval_sum

3941: M_FINANCIAL_STATEMENT_ID := stmnt_child_items.FINANCIAL_STATEMENT_ID;
3942: M_FINANCIAL_ITEM_ID := stmnt_child_items.FINANCIAL_ITEM_ID;
3943:
3944:
3945: AMW_FINSTMT_CERT_PVT.compute_values_for_eval_sum
3946: (P_CERTIFICATION_ID => M_CERTIFICATION_ID,
3947: P_FINANCIAL_STATEMENT_ID => M_FINANCIAL_STATEMENT_ID ,
3948: P_STATEMENT_GROUP_ID => M_STATEMENT_GROUP_ID ,
3949: --P_PARENT_FIN_ITEM_ID => null;

Line 4032: AMW_FINSTMT_CERT_PVT.insert_fin_cert_eval_sum(

4028:
4029:
4030:
4031: -- insert a financial item record which will take care of the child financial items
4032: AMW_FINSTMT_CERT_PVT.insert_fin_cert_eval_sum(
4033: X_FIN_CERTIFICATION_ID => M_CERTIFICATION_ID,
4034: X_FINANCIAL_STATEMENT_ID => M_FINANCIAL_STATEMENT_ID,
4035: X_FINANCIAL_ITEM_ID => M_FINANCIAL_ITEM_ID,
4036: X_ACCOUNT_GROUP_ID => NULL,

Line 4085: AMW_FINSTMT_CERT_PVT.compute_values_for_eval_sum

4081: M_FINANCIAL_ITEM_ID := stmnt_accs.FINANCIAL_ITEM_ID;
4082: M_ACCOUNT_GROUP_ID := stmnt_accs.ACCOUNT_GROUP_ID;
4083: M_NATURAL_ACCOUNT_ID := stmnt_accs.NATURAL_ACCOUNT_ID;
4084:
4085: AMW_FINSTMT_CERT_PVT.compute_values_for_eval_sum
4086: (P_CERTIFICATION_ID => M_CERTIFICATION_ID,
4087: P_FINANCIAL_STATEMENT_ID => M_FINANCIAL_STATEMENT_ID ,
4088: P_STATEMENT_GROUP_ID => M_STATEMENT_GROUP_ID ,
4089: --P_PARENT_FIN_ITEM_ID => null;

Line 4171: AMW_FINSTMT_CERT_PVT.insert_fin_cert_eval_sum(

4167: end if;
4168:
4169: -- insert a KEY ACCOUNT record
4170:
4171: AMW_FINSTMT_CERT_PVT.insert_fin_cert_eval_sum(
4172: X_FIN_CERTIFICATION_ID => M_CERTIFICATION_ID,
4173: X_FINANCIAL_STATEMENT_ID => M_FINANCIAL_STATEMENT_ID,
4174: X_FINANCIAL_ITEM_ID => M_FINANCIAL_ITEM_ID,
4175: X_ACCOUNT_GROUP_ID => M_ACCOUNT_GROUP_ID ,

Line 4337: AMW_FINSTMT_CERT_PVT.compute_values_for_eval_sum

4333: M_FINANCIAL_ITEM_ID := P_FINANCIAL_ITEM_ID;
4334: M_ACCOUNT_GROUP_ID := stmnt_child_accs.ACCOUNT_GROUP_ID;
4335: M_NATURAL_ACCOUNT_ID_2 := stmnt_child_accs.NATURAL_ACCOUNT_ID;
4336:
4337: AMW_FINSTMT_CERT_PVT.compute_values_for_eval_sum
4338: (P_CERTIFICATION_ID => M_CERTIFICATION_ID,
4339: P_FINANCIAL_STATEMENT_ID => M_FINANCIAL_STATEMENT_ID ,
4340: P_STATEMENT_GROUP_ID => M_STATEMENT_GROUP_ID ,
4341: --P_PARENT_FIN_ITEM_ID => null;

Line 4421: AMW_FINSTMT_CERT_PVT.insert_fin_cert_eval_sum(

4417: end if;
4418:
4419: -- insert a KEY ACCOUNT record which will take care of all child accounts
4420:
4421: AMW_FINSTMT_CERT_PVT.insert_fin_cert_eval_sum(
4422: X_FIN_CERTIFICATION_ID => M_CERTIFICATION_ID,
4423: X_FINANCIAL_STATEMENT_ID => M_FINANCIAL_STATEMENT_ID,
4424: X_FINANCIAL_ITEM_ID => M_FINANCIAL_ITEM_ID,
4425: X_ACCOUNT_GROUP_ID => M_ACCOUNT_GROUP_ID ,

Line 8068: END AMW_FINSTMT_CERT_PVT;

8064: END Populate_Fin_Stmt_Cert_Sum;
8065:
8066:
8067:
8068: END AMW_FINSTMT_CERT_PVT;