DBA Data[Home] [Help]

APPS.CN_SRP_PERIOD_QUOTAS_PKG dependencies on FND_API

Line 1097: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS ;

1093: x_end_period_id NUMBER ,
1094: x_start_date DATE := NULL ,
1095: x_end_date DATE := NULL )
1096: IS
1097: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS ;
1098: l_msg_count NUMBER;
1099: l_msg_data VARCHAR2(2000);
1100: l_loading_status VARCHAR2(2000);
1101: l_org_id NUMBER;

Line 1267: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1263: IF l_last_salesrep_id <> -1 THEN
1264: cn_srp_periods_pvt.sync_accum_balances_start_pd (p_salesrep_id => l_last_salesrep_id, p_org_id => l_org_id, p_credit_type_id => l_last_ct_id, p_role_id => l_last_role_id, p_start_period_id => l_last_period_id);
1265: END IF;
1266: -- done with changes for bug 4019235
1267: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1269: END IF;
1270: -- quota date range changed. remove the old periods in preparation
1271: -- for insert of new range

Line 1268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1264: cn_srp_periods_pvt.sync_accum_balances_start_pd (p_salesrep_id => l_last_salesrep_id, p_org_id => l_org_id, p_credit_type_id => l_last_ct_id, p_role_id => l_last_role_id, p_start_period_id => l_last_period_id);
1265: END IF;
1266: -- done with changes for bug 4019235
1267: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1269: END IF;
1270: -- quota date range changed. remove the old periods in preparation
1271: -- for insert of new range
1272: DELETE