DBA Data[Home] [Help]

APPS.AMS_STATUS_PVT dependencies on FND_API

Line 123: RETURN fnd_api.g_true;

119: FETCH c_approval_rules INTO l_count;
120: CLOSE c_approval_rules;
121:
122: IF l_count > 0 THEN
123: RETURN fnd_api.g_true;
124: ELSE
125: RETURN fnd_api.g_false;
126: END IF;
127:

Line 125: RETURN fnd_api.g_false;

121:
122: IF l_count > 0 THEN
123: RETURN fnd_api.g_true;
124: ELSE
125: RETURN fnd_api.g_false;
126: END IF;
127:
128: END is_approval_needed;
129:

Line 143: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

139: -- The client side may use it to populate list items.
140: --
141: ----------------------- END of comments ----------------------------
142: PROCEDURE Get_Next_Statuses(
143: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
144: x_msg_count OUT NOCOPY NUMBER,
145: x_msg_data OUT NOCOPY VARCHAR2,
146:
147: p_arc_status_for IN VARCHAR2,

Line 188: l_approval_flag VARCHAR2(1); -- fnd_api.g_true, fnd_api.g_false

184:
185: l_index BINARY_INTEGER;
186: l_total BINARY_INTEGER;
187:
188: l_approval_flag VARCHAR2(1); -- fnd_api.g_true, fnd_api.g_false
189: l_lookup_type VARCHAR(30);
190: l_api_name CONSTANT VARCHAR2(30) := 'get_next_statuses';
191:
192: BEGIN

Line 195: x_return_status := fnd_api.g_ret_sts_success;

191:
192: BEGIN
193:
194: ----------------------- initialize -----------------------------
195: x_return_status := fnd_api.g_ret_sts_success;
196:
197: l_lookup_type := get_status_lookup_type(p_arc_status_for);
198: IF l_lookup_type IS NULL THEN
199: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

200: fnd_message.set_name('AMS', 'INVALID_ARC_QUALIFIER');
201: fnd_message.set_token('ARG', p_arc_status_for, FALSE);
202: fnd_msg_pub.add;
203: END IF;
204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
205: RETURN ;
206: END IF;
207:
208: --------------------- Get System Status Code --------------------

Line 242: -- l_approval_flag := fnd_api.g_false;

238: -- RETURN;
239: -- END IF;
240: --
241: -- IF l_index = 0 THEN -- no approval needed
242: -- l_approval_flag := fnd_api.g_false;
243: -- ELSE
244: -- l_approval_flag := Is_Approval_Needed(
245: -- p_arc_status_for,
246: -- l_temp_status_tbl(l_index).approval_type,

Line 256: -- AND l_approval_flag = fnd_api.g_false)

252:
253: -- l_index := 0; -- the index for l_next_status_tbl
254: -- FOR i IN 1..l_total LOOP
255: -- IF (l_temp_status_tbl(i).no_approval_flag = 'Y'
256: -- AND l_approval_flag = fnd_api.g_false)
257: -- or (l_temp_status_tbl(i).approval_flag = 'Y'
258: -- AND l_approval_flag = fnd_api.g_true)
259: -- THEN
260: -- l_index := l_index + 1;

Line 258: -- AND l_approval_flag = fnd_api.g_true)

254: -- FOR i IN 1..l_total LOOP
255: -- IF (l_temp_status_tbl(i).no_approval_flag = 'Y'
256: -- AND l_approval_flag = fnd_api.g_false)
257: -- or (l_temp_status_tbl(i).approval_flag = 'Y'
258: -- AND l_approval_flag = fnd_api.g_true)
259: -- THEN
260: -- l_index := l_index + 1;
261: -- l_next_status_tbl(l_index) := l_temp_status_tbl(i);
262: -- END IF;

Line 294: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

290: --
291: --------------- END of comments ----------------------------
292:
293: PROCEDURE validate_status_change(
294: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
295: x_msg_count OUT NOCOPY NUMBER,
296: x_msg_data OUT NOCOPY VARCHAR2,
297:
298: p_arc_status_for IN VARCHAR2,

Line 302: x_valid_flag OUT NOCOPY VARCHAR2, -- fnd_api.g_true, fnd_api.g_false

298: p_arc_status_for IN VARCHAR2,
299: p_current_status_id IN VARCHAR2,
300: p_next_status_id IN VARCHAR2,
301: p_activity_type_code IN VARCHAR2 := NULL,
302: x_valid_flag OUT NOCOPY VARCHAR2, -- fnd_api.g_true, fnd_api.g_false
303: x_return_status OUT NOCOPY VARCHAR2
304: )
305: IS
306:

Line 317: x_return_status := fnd_api.g_ret_sts_success;

313: l_api_name constant VARCHAR2(30) := 'validate_status_change';
314:
315: BEGIN
316:
317: x_return_status := fnd_api.g_ret_sts_success;
318: x_valid_flag := fnd_api.g_false;
319:
320: l_lookup_type := get_status_lookup_type(p_arc_status_for);
321: IF l_lookup_type IS NULL THEN

Line 318: x_valid_flag := fnd_api.g_false;

314:
315: BEGIN
316:
317: x_return_status := fnd_api.g_ret_sts_success;
318: x_valid_flag := fnd_api.g_false;
319:
320: l_lookup_type := get_status_lookup_type(p_arc_status_for);
321: IF l_lookup_type IS NULL THEN
322: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

323: fnd_message.set_name('AMS', 'INVALID_ARC_QUALIFIER');
324: fnd_message.set_token('ARG', p_arc_status_for, FALSE);
325: fnd_msg_pub.add;
326: END IF;
327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
328: RETURN ;
329: END IF;
330:
331: -- Get the Valid Next Statuses

Line 343: IF x_return_status <> FND_API.g_ret_sts_success THEN

339: x_next_status_tbl => l_temp_status_tbl,
340: x_return_status => x_return_status
341: );
342:
343: IF x_return_status <> FND_API.g_ret_sts_success THEN
344: RETURN;
345: END IF;
346:
347: FOR i IN 1..l_temp_status_tbl.last LOOP

Line 350: x_valid_flag := fnd_api.g_true;

346:
347: FOR i IN 1..l_temp_status_tbl.last LOOP
348: IF (l_temp_status_tbl(i).user_status_id = p_next_status_id)
349: THEN
350: x_valid_flag := fnd_api.g_true;
351: RETURN;
352: END IF;
353: END LOOP;
354: