35: OPEN c1;
36: FETCH c1 INTO l_dummy;
37: IF c1%NOTFOUND THEN
38: CLOSE c1;
39: FND_MESSAGE.SET_NAME('ASO','ASO_API_ALL_LOOKUP_FAILURE');
40: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
41: FND_MESSAGE.SET_TOKEN('LOOKUP_CODE',p_lookup_code);
42: FND_MESSAGE.SET_TOKEN('LOOKUP_TYPE',p_lookup_type);
43: FND_MESSAGE.SET_TOKEN('PARAMETER',p_param_name);
36: FETCH c1 INTO l_dummy;
37: IF c1%NOTFOUND THEN
38: CLOSE c1;
39: FND_MESSAGE.SET_NAME('ASO','ASO_API_ALL_LOOKUP_FAILURE');
40: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
41: FND_MESSAGE.SET_TOKEN('LOOKUP_CODE',p_lookup_code);
42: FND_MESSAGE.SET_TOKEN('LOOKUP_TYPE',p_lookup_type);
43: FND_MESSAGE.SET_TOKEN('PARAMETER',p_param_name);
44: FND_MSG_PUB.Add;
37: IF c1%NOTFOUND THEN
38: CLOSE c1;
39: FND_MESSAGE.SET_NAME('ASO','ASO_API_ALL_LOOKUP_FAILURE');
40: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
41: FND_MESSAGE.SET_TOKEN('LOOKUP_CODE',p_lookup_code);
42: FND_MESSAGE.SET_TOKEN('LOOKUP_TYPE',p_lookup_type);
43: FND_MESSAGE.SET_TOKEN('PARAMETER',p_param_name);
44: FND_MSG_PUB.Add;
45: RAISE FND_API.G_EXC_ERROR;
38: CLOSE c1;
39: FND_MESSAGE.SET_NAME('ASO','ASO_API_ALL_LOOKUP_FAILURE');
40: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
41: FND_MESSAGE.SET_TOKEN('LOOKUP_CODE',p_lookup_code);
42: FND_MESSAGE.SET_TOKEN('LOOKUP_TYPE',p_lookup_type);
43: FND_MESSAGE.SET_TOKEN('PARAMETER',p_param_name);
44: FND_MSG_PUB.Add;
45: RAISE FND_API.G_EXC_ERROR;
46: END IF;
39: FND_MESSAGE.SET_NAME('ASO','ASO_API_ALL_LOOKUP_FAILURE');
40: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
41: FND_MESSAGE.SET_TOKEN('LOOKUP_CODE',p_lookup_code);
42: FND_MESSAGE.SET_TOKEN('LOOKUP_TYPE',p_lookup_type);
43: FND_MESSAGE.SET_TOKEN('PARAMETER',p_param_name);
44: FND_MSG_PUB.Add;
45: RAISE FND_API.G_EXC_ERROR;
46: END IF;
47: END Check_LookupCode;
53: p_api_name IN VARCHAR2
54: ) IS
55: BEGIN
56: IF (NVL(p_var1,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM) THEN
57: FND_MESSAGE.SET_NAME('ASO','ASO_API_ALL_MISSING_PARAM');
58: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
59: FND_MESSAGE.SET_TOKEN('PARAMETER',p_param_name);
60: FND_MSG_PUB.Add;
61: RAISE FND_API.G_EXC_ERROR;
54: ) IS
55: BEGIN
56: IF (NVL(p_var1,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM) THEN
57: FND_MESSAGE.SET_NAME('ASO','ASO_API_ALL_MISSING_PARAM');
58: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
59: FND_MESSAGE.SET_TOKEN('PARAMETER',p_param_name);
60: FND_MSG_PUB.Add;
61: RAISE FND_API.G_EXC_ERROR;
62: END IF;
55: BEGIN
56: IF (NVL(p_var1,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM) THEN
57: FND_MESSAGE.SET_NAME('ASO','ASO_API_ALL_MISSING_PARAM');
58: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
59: FND_MESSAGE.SET_TOKEN('PARAMETER',p_param_name);
60: FND_MSG_PUB.Add;
61: RAISE FND_API.G_EXC_ERROR;
62: END IF;
63: END Check_Reqd_Param;
70: p_api_name IN VARCHAR2
71: ) IS
72: BEGIN
73: IF (NVL(p_var1,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR) THEN
74: FND_MESSAGE.SET_NAME('ASO','ASO_API_ALL_MISSING_PARAM');
75: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
76: FND_MESSAGE.SET_TOKEN('PARAMETER',p_param_name);
77: FND_MSG_PUB.Add;
78: RAISE FND_API.G_EXC_ERROR;
71: ) IS
72: BEGIN
73: IF (NVL(p_var1,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR) THEN
74: FND_MESSAGE.SET_NAME('ASO','ASO_API_ALL_MISSING_PARAM');
75: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
76: FND_MESSAGE.SET_TOKEN('PARAMETER',p_param_name);
77: FND_MSG_PUB.Add;
78: RAISE FND_API.G_EXC_ERROR;
79: END IF;
72: BEGIN
73: IF (NVL(p_var1,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR) THEN
74: FND_MESSAGE.SET_NAME('ASO','ASO_API_ALL_MISSING_PARAM');
75: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
76: FND_MESSAGE.SET_TOKEN('PARAMETER',p_param_name);
77: FND_MSG_PUB.Add;
78: RAISE FND_API.G_EXC_ERROR;
79: END IF;
80: END Check_Reqd_Param;
86: p_api_name IN VARCHAR2
87: ) IS
88: BEGIN
89: IF (NVL(p_var1,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE) THEN
90: FND_MESSAGE.SET_NAME('ASO','ASO_API_ALL_MISSING_PARAM');
91: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
92: FND_MESSAGE.SET_TOKEN('PARAMETER',p_param_name);
93: FND_MSG_PUB.Add;
94: RAISE FND_API.G_EXC_ERROR;
87: ) IS
88: BEGIN
89: IF (NVL(p_var1,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE) THEN
90: FND_MESSAGE.SET_NAME('ASO','ASO_API_ALL_MISSING_PARAM');
91: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
92: FND_MESSAGE.SET_TOKEN('PARAMETER',p_param_name);
93: FND_MSG_PUB.Add;
94: RAISE FND_API.G_EXC_ERROR;
95: END IF;
88: BEGIN
89: IF (NVL(p_var1,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE) THEN
90: FND_MESSAGE.SET_NAME('ASO','ASO_API_ALL_MISSING_PARAM');
91: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
92: FND_MESSAGE.SET_TOKEN('PARAMETER',p_param_name);
93: FND_MSG_PUB.Add;
94: RAISE FND_API.G_EXC_ERROR;
95: END IF;
96: END Check_Reqd_Param;