[Home] [Help]
129: l_lotTbl system.wip_txn_lot_tbl_t;
130: l_params wip_logger.param_tbl_t;
131: l_errMsg VARCHAR2(80);
132: l_entryType NUMBER;
133: l_logLevel NUMBER := to_number(fnd_log.g_current_runtime_level);
134: begin
135: x_returnStatus := fnd_api.g_ret_sts_success;
136: if (l_logLevel <= wip_constants.trace_logging) then
137: l_params(1).paramName := 'p_orgID';
265: l_tempReturnStatus VARCHAR2(1);
266: l_errMsg VARCHAR2(80);
267: l_params wip_logger.param_tbl_t;
268: l_returnStatus VARCHAR2(1);
269: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
270: cursor c_cplItems return itemInfo_rec_t is
271: select mmtt.transaction_temp_id,
272: mmtt.operation_seq_num,
273: mmtt.inventory_item_id,
630: l_tempReturnStatus VARCHAR2(1);
631: l_errMsg VARCHAR2(80);
632: l_params wip_logger.param_tbl_t;
633: l_returnStatus VARCHAR2(1);
634: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
635: l_itemRecTbl itemInfo_recTbl_t;
636: l_supType NUMBER;
637:
638: cursor c_allItems is
1112: l_params wip_logger.param_tbl_t;
1113: l_errMsg VARCHAR2(80);
1114: l_returnStatus VARCHAR2(1);
1115: l_enabled VARCHAR2(1);
1116: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1117: begin
1118: x_returnStatus := fnd_api.g_ret_sts_success;
1119: l_cond := x_compLots.getCurrentItem(l_item);
1120:
1283: l_qtyAvailToTxt2 NUMBER;
1284: l_params wip_logger.param_tbl_t;
1285: l_cond boolean;
1286: l_enabled VARCHAR2(1);
1287: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1288: /* Added for Wilson Greatbatch Enhancement */
1289: l_alt_lot_selection_method NUMBER ;
1290: l_flag NUMBER ;
1291: l_lot_qty_selected NUMBER ; /* Fix for Bug#4956543 */
1688: l_errMsg VARCHAR2(80);
1689: l_params wip_logger.param_tbl_t;
1690: l_returnStatus VARCHAR2(1);
1691: l_item system.wip_component_obj_t;
1692: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1693: begin
1694:
1695: x_returnStatus := fnd_api.g_ret_sts_success;
1696: if (l_logLevel <= wip_constants.trace_logging) then
1859: l_params wip_logger.param_tbl_t;
1860: l_returnStatus VARCHAR2(1);
1861: l_errMsg VARCHAR2(80);
1862: l_txnTypeID NUMBER;
1863: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1864: begin
1865:
1866: x_returnStatus := fnd_api.g_ret_sts_success;
1867: if (l_logLevel <= wip_constants.trace_logging) then
2031: l_returnStatus VARCHAR2(1);
2032: l_params wip_logger.param_tbl_t;
2033: l_fmSerial VARCHAR2(30);
2034: l_toSerial VARCHAR2(30);
2035: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2036: cursor c_tmpSerials is
2037: select fm_serial_number fmSerial,
2038: to_serial_number toSerial
2039: from mtl_serial_numbers_temp
2215: x_returnStatus OUT NOCOPY VARCHAR2) is
2216: l_qty NUMBER ;
2217: l_returnStatus varchar2(1) ;
2218: l_params wip_logger.param_tbl_t;
2219: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2220: begin
2221:
2222: l_qty := 0 ;
2223:
2303: WIP_CONSTANTS.RETCOMP_ACTION)
2304: AND mmt.operation_seq_num = p_item.operation_seq_num;
2305:
2306: l_derivedQty NUMBER := 0;
2307: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2308: l_errMsg VARCHAR2(240);
2309: l_returnStatus VARCHAR2(1);
2310: l_lotComp c_lotComp%ROWTYPE;
2311: l_params wip_logger.param_tbl_t;
2428: AND mmt.operation_seq_num = p_item.operation_seq_num;
2429:
2430: l_errMsg VARCHAR2(240);
2431: l_returnStatus VARCHAR2(1);
2432: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2433: l_params wip_logger.param_tbl_t;
2434: l_revisionComp c_revisionComp%ROWTYPE;
2435: BEGIN
2436:
2504: l_returnStatus VARCHAR2(1);
2505: l_errMsg VARCHAR2(80);
2506: l_params wip_logger.param_tbl_t;
2507: l_curItem system.wip_component_obj_t;
2508: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2509: BEGIN
2510: IF (l_logLevel <= wip_constants.trace_logging) THEN
2511: l_params(1).paramName := 'p_orgID';
2512: l_params(1).paramValue := p_orgID;