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 313: --Get from mfg lookups

309: 'After Calling Mrp Atp Pub. Error Code = ' || x_error_code ||
310: ', Available Quantity : '||x_available_qty);
311: END IF;
312:
313: --Get from mfg lookups
314: OPEN Error_Message_Cur(x_error_code);
315: FETCH Error_Message_Cur INTO x_error_message;
316: CLOSE Error_Message_Cur;
317:

Line 342: --Get from mfg lookups

338: fnd_log.string(l_log_statement,
339: L_DEBUG_KEY,
340: 'After ERROR CODE : '||x_error_code);
341: END IF;
342: --Get from mfg lookups
343: OPEN Error_Message_Cur(x_error_code);
344: FETCH Error_Message_Cur INTO x_error_message;
345: CLOSE Error_Message_Cur;
346:

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

346:
347: IF (l_log_statement >= l_log_current_level) THEN
348: fnd_log.string(l_log_statement,
349: L_DEBUG_KEY,
350: 'Interface Error Message from mfg lookups : '||x_error_message);
351:
352: END IF;
353: --
354: END IF;--Error code

Line 958: FROM mfg_lookups

954:
955: CURSOR Error_Message_Cur(c_error_code IN NUMBER)
956: IS
957: SELECT meaning
958: FROM mfg_lookups
959: WHERE lookup_type = 'MTL_DEMAND_INTERFACE_ERRORS'
960: AND lookup_code = C_Error_Code;
961:
962: CURSOR Planned_Order_Cur(c_sch_mat_id IN NUMBER) IS

Line 1929: FROM mfg_lookups

1925: IS
1926:
1927: CURSOR Error_Message_Cur(c_error_code IN NUMBER) IS
1928: SELECT meaning
1929: FROM mfg_lookups
1930: WHERE lookup_type = 'MTL_DEMAND_INTERFACE_ERRORS'
1931: AND lookup_code = C_Error_Code;
1932:
1933: CURSOR Order_Number_Cur(c_visit_task_id IN NUMBER) IS