DBA Data[Home] [Help]

APPS.AHL_LTP_MATRL_AVAL_PVT dependencies on MFG_LOOKUPS

Line 66: FROM mfg_lookups

62: )
63: IS
64: CURSOR Error_Message_Cur(c_error_code IN NUMBER) IS
65: SELECT meaning
66: FROM mfg_lookups
67: WHERE lookup_type = 'MTL_DEMAND_INTERFACE_ERRORS'
68: AND lookup_code = c_error_code;
69:
70: CURSOR Instance_Id_Cur IS

Line 296: --Get from mfg lookups

292: 'After Calling Mrp Atp Pub. Error Code = ' || x_error_code ||
293: ', Available Quantity : '||x_available_qty);
294: END IF;
295:
296: --Get from mfg lookups
297: OPEN Error_Message_Cur(x_error_code);
298: FETCH Error_Message_Cur INTO x_error_message;
299: CLOSE Error_Message_Cur;
300:

Line 325: --Get from mfg lookups

321: fnd_log.string(l_log_statement,
322: L_DEBUG_KEY,
323: 'After ERROR CODE : '||x_error_code);
324: END IF;
325: --Get from mfg lookups
326: OPEN Error_Message_Cur(x_error_code);
327: FETCH Error_Message_Cur INTO x_error_message;
328: CLOSE Error_Message_Cur;
329:

Line 333: 'Interface Error Message from mfg lookups : '||x_error_message);

329:
330: IF (l_log_statement >= l_log_current_level) THEN
331: fnd_log.string(l_log_statement,
332: L_DEBUG_KEY,
333: 'Interface Error Message from mfg lookups : '||x_error_message);
334:
335: END IF;
336: --
337: END IF;--Error code

Line 932: FROM mfg_lookups

928:
929: CURSOR Error_Message_Cur(c_error_code IN NUMBER)
930: IS
931: SELECT meaning
932: FROM mfg_lookups
933: WHERE lookup_type = 'MTL_DEMAND_INTERFACE_ERRORS'
934: AND lookup_code = C_Error_Code;
935:
936: CURSOR Planned_Order_Cur(c_sch_mat_id IN NUMBER) IS