eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_UTILITY_PVT dependencies on FND_API

Line 65: RAISE Fnd_Api.g_exc_unexpected_error;

61: -- operator.
62: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_unexp_error) THEN
63: Fnd_Message.set_name('AHL', 'AHL_UTIL_NO_WHERE_OPERATOR');
64: Fnd_Msg_Pub.ADD;
65: RAISE Fnd_Api.g_exc_unexpected_error;
66: END IF;
67: ELSIF l_eq_pos > 0 AND l_not_pos = 0 THEN
68: l_curr_pos := l_eq_pos;
69: x_col_val_tbl(i).col_op := '=';

Line 141: RETURN Fnd_Api.g_false;

137: l_count := 0;
138: END;
139:
140: IF l_count = 0 THEN
141: RETURN Fnd_Api.g_false;
142: ELSE
143: RETURN Fnd_Api.g_true;
144: END IF;
145:

Line 143: RETURN Fnd_Api.g_true;

139:
140: IF l_count = 0 THEN
141: RETURN Fnd_Api.g_false;
142: ELSE
143: RETURN Fnd_Api.g_true;
144: END IF;
145:
146: END check_fk_exists;
147:

Line 186: RETURN Fnd_Api.g_false;

182: l_count := 0;
183: END;
184:
185: IF l_count = 0 THEN
186: RETURN Fnd_Api.g_false;
187: ELSE
188: RETURN Fnd_Api.g_true;
189: END IF;
190:

Line 188: RETURN Fnd_Api.g_true;

184:
185: IF l_count = 0 THEN
186: RETURN Fnd_Api.g_false;
187: ELSE
188: RETURN Fnd_Api.g_true;
189: END IF;
190:
191: END check_lookup_exists;
192:

Line 260: RETURN Fnd_Api.g_true;

256: l_count := 0;
257: END;
258:
259: IF l_count = 0 THEN
260: RETURN Fnd_Api.g_true;
261: ELSE
262: RETURN Fnd_Api.g_false;
263: END IF;
264:

Line 262: RETURN Fnd_Api.g_false;

258:
259: IF l_count = 0 THEN
260: RETURN Fnd_Api.g_true;
261: ELSE
262: RETURN Fnd_Api.g_false;
263: END IF;
264:
265: END check_uniqueness;
266:

Line 281: RETURN Fnd_Api.g_true;

277: RETURN VARCHAR2
278: IS
279: BEGIN
280: IF p_value = 'Y' OR p_value = 'N' THEN
281: RETURN Fnd_Api.g_true;
282: ELSE
283: RETURN Fnd_Api.g_false;
284: END IF;
285: END is_Y_or_N;

Line 283: RETURN Fnd_Api.g_false;

279: BEGIN
280: IF p_value = 'Y' OR p_value = 'N' THEN
281: RETURN Fnd_Api.g_true;
282: ELSE
283: RETURN Fnd_Api.g_false;
284: END IF;
285: END is_Y_or_N;
286:
287:

Line 367: RETURN Fnd_Api.G_FALSE;

363: FETCH cur_usr_stat_det INTO l_dummy;
364: CLOSE cur_usr_stat_det;
365:
366: IF l_dummy IS NULL THEN
367: RETURN Fnd_Api.G_FALSE;
368: ELSE
369: RETURN Fnd_Api.G_TRUE;
370: END IF;
371: END Check_User_Status;

Line 369: RETURN Fnd_Api.G_TRUE;

365:
366: IF l_dummy IS NULL THEN
367: RETURN Fnd_Api.G_FALSE;
368: ELSE
369: RETURN Fnd_Api.G_TRUE;
370: END IF;
371: END Check_User_Status;
372:
373: --======================================================================

Line 437: x_return_status:= Fnd_Api.G_RET_STS_SUCCESS;

433: OPEN cur_stat_det;
434: FETCH cur_stat_det INTO l_dummy;
435: CLOSE cur_stat_det;
436: IF l_dummy IS NOT NULL THEN
437: x_return_status:= Fnd_Api.G_RET_STS_SUCCESS;
438: ELSE
439: x_return_status := Fnd_Api.G_RET_STS_ERROR;
440: END IF;
441: EXCEPTION

Line 439: x_return_status := Fnd_Api.G_RET_STS_ERROR;

435: CLOSE cur_stat_det;
436: IF l_dummy IS NOT NULL THEN
437: x_return_status:= Fnd_Api.G_RET_STS_SUCCESS;
438: ELSE
439: x_return_status := Fnd_Api.G_RET_STS_ERROR;
440: END IF;
441: EXCEPTION
442: WHEN NO_DATA_FOUND THEN
443: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 443: x_return_status := Fnd_Api.G_RET_STS_ERROR;

439: x_return_status := Fnd_Api.G_RET_STS_ERROR;
440: END IF;
441: EXCEPTION
442: WHEN NO_DATA_FOUND THEN
443: x_return_status := Fnd_Api.G_RET_STS_ERROR;
444: WHEN TOO_MANY_ROWS THEN
445: x_return_status := Fnd_Api.G_RET_STS_ERROR;
446: WHEN OTHERS THEN
447: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 445: x_return_status := Fnd_Api.G_RET_STS_ERROR;

441: EXCEPTION
442: WHEN NO_DATA_FOUND THEN
443: x_return_status := Fnd_Api.G_RET_STS_ERROR;
444: WHEN TOO_MANY_ROWS THEN
445: x_return_status := Fnd_Api.G_RET_STS_ERROR;
446: WHEN OTHERS THEN
447: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
448: RAISE;
449:

Line 447: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

443: x_return_status := Fnd_Api.G_RET_STS_ERROR;
444: WHEN TOO_MANY_ROWS THEN
445: x_return_status := Fnd_Api.G_RET_STS_ERROR;
446: WHEN OTHERS THEN
447: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
448: RAISE;
449:
450: END check_status_change;
451:

Line 500: x_return_status:= Fnd_Api.G_RET_STS_ERROR;

496: FETCH cur_stat_det INTO l_dummy;
497: IF l_dummy IS NULL THEN
498: Fnd_Message.set_name('AHL', 'AHL_INVALID_STATUS');
499: Fnd_Msg_Pub.ADD;
500: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
501: ELSE
502: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
503: END IF;
504: CLOSE cur_stat_det;

Line 502: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

498: Fnd_Message.set_name('AHL', 'AHL_INVALID_STATUS');
499: Fnd_Msg_Pub.ADD;
500: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
501: ELSE
502: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
503: END IF;
504: CLOSE cur_stat_det;
505: --
506: EXCEPTION

Line 508: x_return_status := Fnd_Api.G_RET_STS_ERROR;

504: CLOSE cur_stat_det;
505: --
506: EXCEPTION
507: WHEN NO_DATA_FOUND THEN
508: x_return_status := Fnd_Api.G_RET_STS_ERROR;
509: WHEN TOO_MANY_ROWS THEN
510: x_return_status := Fnd_Api.G_RET_STS_ERROR;
511: WHEN OTHERS THEN
512: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 510: x_return_status := Fnd_Api.G_RET_STS_ERROR;

506: EXCEPTION
507: WHEN NO_DATA_FOUND THEN
508: x_return_status := Fnd_Api.G_RET_STS_ERROR;
509: WHEN TOO_MANY_ROWS THEN
510: x_return_status := Fnd_Api.G_RET_STS_ERROR;
511: WHEN OTHERS THEN
512: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
513: RAISE;
514:

Line 512: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

508: x_return_status := Fnd_Api.G_RET_STS_ERROR;
509: WHEN TOO_MANY_ROWS THEN
510: x_return_status := Fnd_Api.G_RET_STS_ERROR;
511: WHEN OTHERS THEN
512: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
513: RAISE;
514:
515: END check_status_order_change;
516:

Line 569: x_return_status := Fnd_Api.g_ret_sts_error;

565: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
566: Fnd_Message.set_name ('AHL', 'AHL_APPR_APPUSG_INVALID');
567: Fnd_Msg_Pub.ADD;
568: END IF;
569: x_return_status := Fnd_Api.g_ret_sts_error;
570: RETURN;
571: ELSE
572: CLOSE chk_appl_usg_code;
573: END IF;

Line 583: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

579:
580: x_active := l_active;
581: x_process_name := l_process_name;
582: x_item_type := l_item_type;
583: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
584: RETURN;
585: ELSE
586: CLOSE c_wf_data;
587: OPEN c_wf_data_null(p_application_usg_code);

Line 595: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

591: x_active := 'E';
592: x_process_name := NULL;
593: x_item_type := NULL;
594: --should not return error if no wf is found as this condition is not an error, and each module should handle it as they see fit.
595: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
596: RETURN;
597: ELSE
598: CLOSE c_wf_data_null;
599:

Line 603: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

599:
600: x_active := l_active;
601: x_process_name := l_process_name;
602: x_item_type := l_item_type;
603: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
604: RETURN;
605: END IF;
606: END IF;
607:

Line 609: p_encoded => Fnd_Api.g_false,

605: END IF;
606: END IF;
607:
608: Fnd_Msg_Pub.count_and_get (
609: p_encoded => Fnd_Api.g_false,
610: p_count => x_msg_count,
611: p_data => x_msg_data
612: );
613:

Line 665: -- Returns FND_API.G_TRUE if the org belongs to user's operating unit

661: -- Is_Org_In_User_Ou
662: --
663: -- PURPOSE
664: -- Created to check if the Organization is in users operating unit or not.
665: -- Returns FND_API.G_TRUE if the org belongs to user's operating unit
666: -- Returns FND_API.G_FALSE if the org doesnt belong to user's operating unit
667: -- Returns 'X' on error.
668: --======================================================================
669: -- Function added for transit check.

Line 666: -- Returns FND_API.G_FALSE if the org doesnt belong to user's operating unit

662: --
663: -- PURPOSE
664: -- Created to check if the Organization is in users operating unit or not.
665: -- Returns FND_API.G_TRUE if the org belongs to user's operating unit
666: -- Returns FND_API.G_FALSE if the org doesnt belong to user's operating unit
667: -- Returns 'X' on error.
668: --======================================================================
669: -- Function added for transit check.
670: FUNCTION IS_ORG_IN_USER_OU

Line 713: x_return_status := FND_API.G_RET_STS_SUCCESS;

709: l_ou_org_id NUMBER;
710:
711: BEGIN
712: --Initialize return status to success.
713: x_return_status := FND_API.G_RET_STS_SUCCESS;
714: IF p_org_id IS NULL AND
715: p_org_name IS NULL
716: THEN
717: x_return_status := FND_API.G_RET_STS_ERROR;

Line 717: x_return_status := FND_API.G_RET_STS_ERROR;

713: x_return_status := FND_API.G_RET_STS_SUCCESS;
714: IF p_org_id IS NULL AND
715: p_org_name IS NULL
716: THEN
717: x_return_status := FND_API.G_RET_STS_ERROR;
718: x_msg_data := 'AHL_UA_ORG_INFO_NULL';
719: RETURN 'X';
720: END IF;
721:

Line 737: RETURN FND_API.G_TRUE;

733: FETCH is_user_in_ou_csr INTO l_ou_org_id;
734: CLOSE is_user_in_ou_csr;
735: IF l_ou_org_id IS NOT NULL
736: THEN
737: RETURN FND_API.G_TRUE;
738: ELSE
739: RETURN FND_API.G_FALSE;
740: END IF;
741: ELSE

Line 739: RETURN FND_API.G_FALSE;

735: IF l_ou_org_id IS NOT NULL
736: THEN
737: RETURN FND_API.G_TRUE;
738: ELSE
739: RETURN FND_API.G_FALSE;
740: END IF;
741: ELSE
742: x_return_status := FND_API.G_RET_STS_ERROR;
743: x_msg_data := 'AHL_UA_ORG_INFO_NULL';

Line 742: x_return_status := FND_API.G_RET_STS_ERROR;

738: ELSE
739: RETURN FND_API.G_FALSE;
740: END IF;
741: ELSE
742: x_return_status := FND_API.G_RET_STS_ERROR;
743: x_msg_data := 'AHL_UA_ORG_INFO_NULL';
744: RETURN 'X';
745: END IF;
746: