1: PACKAGE BODY FV_CCR_GRP as
2: /* $Header: FVGACCRB.pls 120.0.12000000.2 2007/09/28 15:03:33 sasukuma ship $*/
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):='FV_CCR_GRP';
5:
1: PACKAGE BODY FV_CCR_GRP as
2: /* $Header: FVGACCRB.pls 120.0.12000000.2 2007/09/28 15:03:33 sasukuma ship $*/
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):='FV_CCR_GRP';
5:
6: PROCEDURE FV_IS_CCR
7: ( p_api_version IN NUMBER,
8: p_init_msg_list IN VARCHAR2 ,
81: ELSE
82: x_return_status := FND_API.G_RET_STS_ERROR ;
83: END IF;
84:
85: FND_MESSAGE.SET_NAME('FV', 'FV_CCR_GRP_TOO_MANY_ROWS');
86: FND_MSG_PUB.ADD;
87:
88:
89: FND_MSG_PUB.Count_And_Get
186: );
187:
188: x_return_status := FND_API.G_RET_STS_ERROR ;
189: WHEN TOO_MANY_ROWS THEN
190: FND_MESSAGE.SET_NAME('FV', 'FV_CCR_GRP_TOO_MANY_ROWS');
191: FND_MSG_PUB.ADD;
192: x_error_code := 1;
193: x_return_status := FND_API.G_RET_STS_ERROR ;
194: FND_MSG_PUB.Count_And_Get
391:
392: WHEN TOO_MANY_ROWS THEN
393: x_error_code := 1;
394: x_return_status := FND_API.G_RET_STS_SUCCESS;
395: FND_MESSAGE.SET_NAME('FV', 'FV_CCR_GRP_TOO_MANY_ROWS');
396: FND_MSG_PUB.ADD;
397:
398:
399: FND_MSG_PUB.Count_And_Get
446: l_error_code number;
447: l_return_status varchar2(1);
448:
449: BEGIN
450: fv_ccr_grp.fv_ccr_reg_status
451: (
452: p_api_version => l_api_version,
453: p_vendor_site_id => p_vendor_site_id,
454: x_return_status => l_return_status,
483: l_return_status varchar2(1);
484: l_bank_account_id NUMBER;
485:
486: BEGIN
487: fv_ccr_grp.fv_ccr_reg_status
488: (
489: p_api_version => l_api_version,
490: p_vendor_site_id => p_vendor_site_id,
491: x_return_status => l_return_status,
521: END;
522:
523: -------------------------------------------
524:
525: END FV_CCR_GRP;