DBA Data[Home] [Help]

APPS.EAM_WORKORDER_UTIL_PKG dependencies on APP_EXCEPTION

Line 741: APP_EXCEPTION.RAISE_EXCEPTION;

737: open C_RESPS ;
738: fetch C_RESPS into l_resp_key, l_resp_id, l_resp_app_id, l_menu_id;
739: if( C_RESPS%NOTFOUND ) then
740: FND_MESSAGE.SET_NAME('EAM', 'EAM_ORG_ACCESS_VIOLATION');
741: APP_EXCEPTION.RAISE_EXCEPTION;
742: end if;
743: x_out := l_resp_key;
744: x_resp_id := l_resp_id;
745: END;

Line 801: APP_EXCEPTION.RAISE_EXCEPTION;

797: where function_name = l_function_name;
798: EXCEPTION
799: WHEN NO_DATA_FOUND THEN
800: fnd_message.set_name('EAM','EAM_RESP_NOT_AVAILABLE'); --show message that resp. is not available
801: APP_EXCEPTION.RAISE_EXCEPTION;
802: END;
803:
804: -- EAM uses 426 as application id
805: l_eam_app_id := 426;

Line 811: APP_EXCEPTION.RAISE_EXCEPTION;

807: get_resp_for_func(l_eam_function_id,FND_GLOBAL.user_id, null, l_resp_id, l_resp_key);
808:
809: IF(l_resp_id = -1) THEN
810: fnd_message.set_name('EAM','EAM_RESP_NOT_AVAILABLE'); --show message that resp. is not available
811: APP_EXCEPTION.RAISE_EXCEPTION;
812: END IF;
813:
814: RETURN l_resp_id;
815:

Line 896: APP_EXCEPTION.RAISE_EXCEPTION;

892: ,p_rep_sched_id => x_rep_id
893: ,p_organization_id => x_org_id
894: ,p_entity_type => x_ent_type ) = TRUE) THEN
895: FND_MESSAGE.SET_NAME('WIP','WIP_UNRLS_JOB/SCHED_OPEN_PO');
896: APP_EXCEPTION.RAISE_EXCEPTION;
897: RETURN;
898: END IF;
899:
900: /* End of OSP Check */

Line 984: APP_EXCEPTION.RAISE_EXCEPTION;

980: -- group by work_order_number;
981:
982: if (quantity_left > 0) then
983: FND_MESSAGE.SET_NAME('WIP','WIP_UNRLS_JOB/SCHED_OPEN_PO');
984: APP_EXCEPTION.RAISE_EXCEPTION;
985: /* Bug#3022963: The 'RETURN' was placed outside the quantity_left check causing
986: the procedure to return without making other checks */
987: RETURN;
988: END IF;

Line 1032: APP_EXCEPTION.RAISE_EXCEPTION;

1028: AND ROWNUM <= 1;
1029:
1030: if charges_exist_1 = '1' then
1031: FND_MESSAGE.SET_NAME('WIP','WIP_UNRLS_JOB/SCHED');
1032: APP_EXCEPTION.RAISE_EXCEPTION;
1033: /* Bug#3022963: The 'RETURN' was placed outside the quantity_left check causing
1034: the procedure to return without making other checks */
1035: RETURN;
1036: end if;

Line 1063: APP_EXCEPTION.RAISE_EXCEPTION;

1059: AND WIP_ENTITY_ID = x_wip_id);
1060:
1061: if charges_exist_2 = '1' then
1062: FND_MESSAGE.SET_NAME('WIP','WIP_UNRLS_JOB/SCHED');
1063: APP_EXCEPTION.RAISE_EXCEPTION;
1064: /* Bug#3022963: The 'RETURN' was placed outside the quantity_left check causing
1065: the procedure to return without making other checks */
1066: RETURN;
1067: end if;

Line 1087: APP_EXCEPTION.RAISE_EXCEPTION;

1083: AND transaction_source_type_id = 5
1084: AND transaction_source_id = x_wip_id);
1085: if charges_exist_3 = '1' then
1086: FND_MESSAGE.SET_NAME('WIP','WIP_UNRLS_JOB/SCHED');
1087: APP_EXCEPTION.RAISE_EXCEPTION;
1088: /* Bug#3022963: The 'RETURN' was placed outside the quantity_left check causing
1089: the procedure to return without making other checks */
1090: RETURN;
1091: end if;

Line 1106: APP_EXCEPTION.RAISE_EXCEPTION;

1102: AND APPLIED_RESOURCE_UNITS <> 0);
1103:
1104: if charges_exist_3 = '1' then
1105: FND_MESSAGE.SET_NAME('WIP','WIP_UNRLS_JOB/SCHED');
1106: APP_EXCEPTION.RAISE_EXCEPTION;
1107: /* Bug#3022963: The 'RETURN' was placed outside the quantity_left check causing
1108: the procedure to return without making other checks */
1109: RETURN;
1110: end if;

Line 1132: APP_EXCEPTION.RAISE_EXCEPTION;

1128: WHERE WIP_ENTITY_ID = x_wip_id
1129: AND ORGANIZATION_ID = x_org_id;
1130: ELSE
1131: FND_MESSAGE.SET_NAME('WIP','WIP_UNRLS_JOB/SCHED');
1132: APP_EXCEPTION.RAISE_EXCEPTION;
1133: RETURN;
1134: END IF;
1135:
1136: /* End of Check for Material and Resource Transactions */

Line 1415: APP_EXCEPTION.RAISE_EXCEPTION;

1411:
1412: fnd_message.set_token(token => 'MESG',
1413: value =>mesg,
1414: translate =>FALSE);
1415: APP_EXCEPTION.RAISE_EXCEPTION;
1416: END IF;
1417:
1418: END show_mesg;
1419: