APPS.CN_SRP_PERIOD_QUOTAS_PKG dependencies on FND_API

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

1131: ,x_end_period_id NUMBER
1132: ,x_start_date DATE := NULL
1133: ,x_end_date DATE := NULL ) IS
1134:
1135: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS ;
1136: l_msg_count NUMBER;
1137: l_msg_data VARCHAR2(2000);
1138: l_loading_status VARCHAR2(2000);
1139: l_org_id NUMBER;

Line 1299: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

1295: p_start_period_id => l_last_period_id);
1296: end if;
1297: -- done with changes for bug 4019235
1298:
1299: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1300: THEN
1301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1302: END IF;
1303:

Line 1301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1297: -- done with changes for bug 4019235
1298:
1299: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1300: THEN
1301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1302: END IF;
1303:
1304: -- quota date range changed. remove the old periods in preparation
1305: -- for insert of new range

Line 1405: x_number_dim NUMBER := fnd_api.g_miss_num) IS

1401: PROCEDURE populate_srp_period_quotas_ext
1402: (x_operation VARCHAR2,
1403: x_srp_period_quota_id NUMBER,
1404: x_org_id NUMBER,
1405: x_number_dim NUMBER := fnd_api.g_miss_num) IS
1406:
1407: l_user_id NUMBER(15);
1408: l_login_id NUMBER(15);
1409: l_number_dim NUMBER(15);

Line 1428: IF x_number_dim = fnd_api.g_miss_num THEN

1424: l_login_id := fnd_global.login_id;
1425:
1426: IF x_operation = 'INSERT' THEN
1427: -- get number dim if necessary
1428: IF x_number_dim = fnd_api.g_miss_num THEN
1429: l_number_dim := 0;
1430: OPEN dim_number_cur;
1431: FETCH dim_number_cur INTO l_number_dim;
1432: CLOSE dim_number_cur;