APPS.AMW_FINSTMT_CERT_BES_PKG dependencies on AMW_FINSTMT_CERT_BES_PKG

Line 1: PACKAGE BODY AMW_FINSTMT_CERT_BES_PKG AS

1: PACKAGE BODY AMW_FINSTMT_CERT_BES_PKG AS
2: /* $Header: amwfbusb.pls 120.28 2007/12/10 06:41:35 srbalasu noship $ */
3:
4: --G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
5: --G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

Line 7: G_PKG_NAME CONSTANT VARCHAR2 (30) := 'AMW_FINSTMT_CERT_BES_PKG';

3:
4: --G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
5: --G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
6:
7: G_PKG_NAME CONSTANT VARCHAR2 (30) := 'AMW_FINSTMT_CERT_BES_PKG';
8: G_API_NAME CONSTANT VARCHAR2 (15) := 'amwfbusb.pls';
9:
10:
11: G_START_DATE DATE;

Line 2728: AMW_FINSTMT_CERT_BES_PKG.Master_Fin_Proc_Eval_Sum

2724:
2725: fnd_file.put_line(fnd_file.LOG, 'fin_certification_id = ' || l_fin_cert_id || to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
2726:
2727: IF (l_fin_cert_id IS NOT NULL) THEN
2728: AMW_FINSTMT_CERT_BES_PKG.Master_Fin_Proc_Eval_Sum
2729: ( p_certification_id => l_fin_cert_id,
2730: --p_start_date => c_cert_Rec.start_date,
2731: p_commit => FND_API.g_true,
2732: x_return_status => l_return_status,

Line 2744: WF_CORE.CONTEXT('AMW_FINSTMT_CERT_BES_PKG', 'Populate_Fin_Stmt_Cert_Sum', p_event.getEventName(), p_subscription_guid);

2740:
2741: EXCEPTION
2742: WHEN OTHERS THEN
2743: ROLLBACK TO Populate_Fin_Stmt_Cert_Sum;
2744: WF_CORE.CONTEXT('AMW_FINSTMT_CERT_BES_PKG', 'Populate_Fin_Stmt_Cert_Sum', p_event.getEventName(), p_subscription_guid);
2745: WF_EVENT.setErrorInfo(p_event, 'ERROR');
2746: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
2747:
2748: end Populate_Fin_Stmt_Cert_Sum;

Line 2803: WF_CORE.CONTEXT('AMW_FINSTMT_CERT_BES_PKG', 'Certification_Update', p_event.getEventName(), p_subscription_guid);

2799:
2800:
2801: EXCEPTION
2802: WHEN OTHERS THEN
2803: WF_CORE.CONTEXT('AMW_FINSTMT_CERT_BES_PKG', 'Certification_Update', p_event.getEventName(), p_subscription_guid);
2804: WF_EVENT.setErrorInfo(p_event, FND_API.G_RET_STS_UNEXP_ERROR);
2805: RETURN l_return_status;
2806:
2807: END Certification_Update;

Line 2862: WF_CORE.CONTEXT('AMW_FINSTMT_CERT_BES_PKG', 'Evaluation_Update', p_event.getEventName(), p_subscription_guid);

2858:
2859:
2860: EXCEPTION
2861: WHEN OTHERS THEN
2862: WF_CORE.CONTEXT('AMW_FINSTMT_CERT_BES_PKG', 'Evaluation_Update', p_event.getEventName(), p_subscription_guid);
2863: WF_EVENT.setErrorInfo(p_event, FND_API.G_RET_STS_UNEXP_ERROR);
2864: RETURN l_return_status;
2865:
2866: END Evaluation_Update;

Line 3226: --AMW_FINSTMT_CERT_BES_PKG.Master_Fin_Proc_Eval_Sum

3222: --IF (G_REFRESH_FLAG = 'Y') THEN
3223: --l_index := m_certification_list.FIRST;
3224: --WHILE l_index <= m_certification_list.LAST LOOP
3225:
3226: --AMW_FINSTMT_CERT_BES_PKG.Master_Fin_Proc_Eval_Sum
3227: -- ( p_certification_id => m_certification_list(l_index),
3228: -- p_mode => 'REFRESH',
3229: -- x_return_status => l_return_status,
3230: -- x_msg_count => l_msg_count,

Line 3321: AMW_FINSTMT_CERT_BES_PKG.Master_Fin_Proc_Eval_Sum

3317: l_fin_cert_id := p_event.GetValueForParameter('FIN_CERTIFICATION_ID');
3318:
3319: fnd_file.put_line(fnd_file.LOG, 'fin_certification_id = ' || l_fin_cert_id || to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
3320:
3321: AMW_FINSTMT_CERT_BES_PKG.Master_Fin_Proc_Eval_Sum
3322: (p_certification_id => l_fin_cert_id,
3323: p_commit => FND_API.g_true,
3324: x_return_status => l_return_status,
3325: x_msg_count => l_msg_count,

Line 3334: WF_CORE.CONTEXT('AMW_FINSTMT_CERT_BES_PKG', 'Update_Fin_Stmt_Cert_Sum', p_event.getEventName(), p_subscription_guid);

3330: RETURN FND_API.G_RET_STS_SUCCESS;
3331:
3332: EXCEPTION
3333: WHEN OTHERS THEN
3334: WF_CORE.CONTEXT('AMW_FINSTMT_CERT_BES_PKG', 'Update_Fin_Stmt_Cert_Sum', p_event.getEventName(), p_subscription_guid);
3335: WF_EVENT.setErrorInfo(p_event, 'ERROR' || l_msg_data);
3336: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
3337:
3338: END Update_Fin_Stmt_Cert_Sum;

Line 10917: END AMW_FINSTMT_CERT_BES_PKG;

10913:
10914: END Get_CONTROLS_VERIFIED_M;
10915:
10916:
10917: END AMW_FINSTMT_CERT_BES_PKG;