APPS.HZ_GNR_PUB dependencies on FND_API

Line 50: x_return_status := FND_API.G_RET_STS_SUCCESS;

46: FROM HZ_LOCATIONS WHERE LOCATION_ID = p_location_id;
47:
48: BEGIN
49: -- initializing the retun value
50: x_return_status := FND_API.G_RET_STS_SUCCESS;
51:
52: IF upper(p_location_table_name) = 'HR_LOCATIONS_ALL' THEN
53:
54: IF p_call_type = 'U' THEN

Line 106: WHEN FND_API.G_EXC_ERROR THEN

102: END LOOP;
103:
104: END IF;
105: EXCEPTION
106: WHEN FND_API.G_EXC_ERROR THEN
107: x_return_status := FND_API.G_RET_STS_SUCCESS;
108: WHEN OTHERS THEN
109: x_return_status := 'U';
110: END process_gnr;

Line 107: x_return_status := FND_API.G_RET_STS_SUCCESS;

103:
104: END IF;
105: EXCEPTION
106: WHEN FND_API.G_EXC_ERROR THEN
107: x_return_status := FND_API.G_RET_STS_SUCCESS;
108: WHEN OTHERS THEN
109: x_return_status := 'U';
110: END process_gnr;
111:

Line 166: x_is_validated := FND_API.G_FALSE;

162: BEGIN
163: OPEN c_gnr;
164: FETCH c_gnr INTO l_address_status;
165: IF c_gnr%NOTFOUND THEN
166: x_is_validated := FND_API.G_FALSE;
167: ELSE
168: x_is_validated := FND_API.G_TRUE;
169: x_address_status := l_address_status;
170: END IF;

Line 168: x_is_validated := FND_API.G_TRUE;

164: FETCH c_gnr INTO l_address_status;
165: IF c_gnr%NOTFOUND THEN
166: x_is_validated := FND_API.G_FALSE;
167: ELSE
168: x_is_validated := FND_API.G_TRUE;
169: x_address_status := l_address_status;
170: END IF;
171: CLOSE c_gnr;
172: END get_addr_val_status;

Line 176: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

172: END get_addr_val_status;
173:
174: PROCEDURE validateLoc (
175: p_location_id IN NUMBER,
176: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
177: x_addr_val_level OUT NOCOPY VARCHAR2,
178: x_addr_warn_msg OUT NOCOPY VARCHAR2,
179: x_addr_val_status OUT NOCOPY VARCHAR2,
180: x_return_status OUT NOCOPY VARCHAR2,

Line 315: P_LOCK_FLAG => FND_API.G_TRUE,

311: P_ATTRIBUTE8 => P_ATTRIBUTE8,
312: P_ATTRIBUTE9 => P_ATTRIBUTE9,
313: P_ATTRIBUTE10 => P_ATTRIBUTE10,
314: P_CALLED_FROM => 'VALIDATE',
315: P_LOCK_FLAG => FND_API.G_TRUE,
316: X_ADDR_VAL_LEVEL => x_addr_val_level,
317: X_ADDR_WARN_MSG => x_addr_warn_msg,
318: X_ADDR_VAL_STATUS => x_addr_val_status,
319: X_STATUS => l_status);

Line 346: IF (l_status = FND_API.G_RET_STS_SUCCESS AND

342: -- Message stack is not being cleared, so that if some one wants to read that
343: -- data, it is still available.
344: -- Nishant (for Bug 5262208 + convenience method as discussion with Vivek and Vinoo)
345: -- (15-Jun-2006)
346: IF (l_status = FND_API.G_RET_STS_SUCCESS AND
347: x_addr_val_status = 'W') THEN
348: x_msg_data := x_addr_warn_msg;
349: ELSIF
350: (l_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 350: (l_status <> FND_API.G_RET_STS_SUCCESS) THEN

346: IF (l_status = FND_API.G_RET_STS_SUCCESS AND
347: x_addr_val_status = 'W') THEN
348: x_msg_data := x_addr_warn_msg;
349: ELSIF
350: (l_status <> FND_API.G_RET_STS_SUCCESS) THEN
351:
352: IF (l_msg_count_after > l_msg_count_before) THEN
353: FOR i IN l_msg_count_before+1..l_msg_count_after LOOP
354: l_message_text := SUBSTR(l_message_text||fnd_msg_pub.get(p_msg_index => i ,

Line 381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

377: OTHERS THEN
378: IF (l_status IS NOT NULL) THEN
379: x_return_status := l_status;
380: ELSE
381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
382: END IF;
383:
384: IF (x_addr_val_status IS NULL) THEN
385: x_addr_val_status := x_return_status;

Line 388: IF (l_status = FND_API.G_RET_STS_SUCCESS AND

384: IF (x_addr_val_status IS NULL) THEN
385: x_addr_val_status := x_return_status;
386: END IF;
387:
388: IF (l_status = FND_API.G_RET_STS_SUCCESS AND
389: x_addr_val_status = 'W') THEN
390: x_msg_data := x_addr_warn_msg;
391: ELSE
392:

Line 399: p_encoded => FND_API.G_FALSE,

395: FND_MSG_PUB.ADD;
396:
397: --Standard call to get message count and if count is 1, get message info.
398: FND_MSG_PUB.Count_And_Get(
399: p_encoded => FND_API.G_FALSE,
400: p_count => x_msg_count,
401: p_data => x_msg_data );
402:
403: END IF;