622: RETURN VARCHAR2 IS
623:
624: CURSOR Ml_Cur IS
625: SELECT Meaning
626: FROM MFG_Lookups
627: WHERE Lookup_Code = P_Lookup_Code
628: AND Lookup_Type = P_Lookup_Type;
629:
630: CURSOR Wl_Cur Is
2321: l_message := fnd_message.get;
2322: END IF;
2323: ELSE
2324: SELECT ml.meaning INTO l_message
2325: FROM mfg_lookups ml, mst_exception_details med
2326: WHERE med.exception_type = ml.lookup_code
2327: AND ml.lookup_type = 'MST_EXCEPTION_TYPE'
2328: and med.exception_detail_id = P_EXCEPTION_DETAIL_ID;
2329: END IF;
4395: l_lookup_code := 1;
4396: End If;
4397: SELECT meaning
4398: INTO l_str
4399: FROM mfg_lookups
4400: WHERE lookup_type = 'MST_TRIP_LOADING_STATUS'
4401: AND lookup_code = l_lookup_code;
4402:
4403: RETURN l_str;
5621: l_message := fnd_message.get;
5622: ELSE
5623: SELECT meaning
5624: INTO l_message
5625: FROM mfg_lookups
5626: WHERE lookup_type = 'MST_EXCEPTION_TYPE'
5627: AND lookup_code = P_EXCEPTION_TYPE;
5628: END IF;
5629: return l_message;