[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: l_serialTaggedCode NUMBER;
638:
1118: l_params wip_logger.param_tbl_t;
1119: l_errMsg VARCHAR2(80);
1120: l_returnStatus VARCHAR2(1);
1121: l_enabled VARCHAR2(1);
1122: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1123: begin
1124: x_returnStatus := fnd_api.g_ret_sts_success;
1125: l_cond := x_compLots.getCurrentItem(l_item);
1126:
1289: l_qtyAvailToTxt2 NUMBER;
1290: l_params wip_logger.param_tbl_t;
1291: l_cond boolean;
1292: l_enabled VARCHAR2(1);
1293: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1294: /* Added for Wilson Greatbatch Enhancement */
1295: l_alt_lot_selection_method NUMBER ;
1296: l_flag NUMBER ;
1297: l_lot_qty_selected NUMBER ; /* Fix for Bug#4956543 */
1752: l_errMsg VARCHAR2(80);
1753: l_params wip_logger.param_tbl_t;
1754: l_returnStatus VARCHAR2(1);
1755: l_item system.wip_component_obj_t;
1756: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1757: begin
1758:
1759: x_returnStatus := fnd_api.g_ret_sts_success;
1760: if (l_logLevel <= wip_constants.trace_logging) then
1930: l_params wip_logger.param_tbl_t;
1931: l_returnStatus VARCHAR2(1);
1932: l_errMsg VARCHAR2(80);
1933: l_txnTypeID NUMBER;
1934: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1935: begin
1936:
1937: x_returnStatus := fnd_api.g_ret_sts_success;
1938: if (l_logLevel <= wip_constants.trace_logging) then
2102: l_returnStatus VARCHAR2(1);
2103: l_params wip_logger.param_tbl_t;
2104: l_fmSerial VARCHAR2(30);
2105: l_toSerial VARCHAR2(30);
2106: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2107: cursor c_tmpSerials is
2108: select fm_serial_number fmSerial,
2109: to_serial_number toSerial
2110: from mtl_serial_numbers_temp
2286: x_returnStatus OUT NOCOPY VARCHAR2) is
2287: l_qty NUMBER ;
2288: l_returnStatus varchar2(1) ;
2289: l_params wip_logger.param_tbl_t;
2290: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2291: begin
2292:
2293: l_qty := 0 ;
2294:
2374: WIP_CONSTANTS.RETCOMP_ACTION)
2375: AND mmt.operation_seq_num = p_item.operation_seq_num;
2376:
2377: l_derivedQty NUMBER := 0;
2378: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2379: l_errMsg VARCHAR2(240);
2380: l_returnStatus VARCHAR2(1);
2381: l_lotComp c_lotComp%ROWTYPE;
2382: l_params wip_logger.param_tbl_t;
2499: AND mmt.operation_seq_num = p_item.operation_seq_num;
2500:
2501: l_errMsg VARCHAR2(240);
2502: l_returnStatus VARCHAR2(1);
2503: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2504: l_params wip_logger.param_tbl_t;
2505: l_revisionComp c_revisionComp%ROWTYPE;
2506: BEGIN
2507:
2575: l_returnStatus VARCHAR2(1);
2576: l_errMsg VARCHAR2(80);
2577: l_params wip_logger.param_tbl_t;
2578: l_curItem system.wip_component_obj_t;
2579: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2580: BEGIN
2581: IF (l_logLevel <= wip_constants.trace_logging) THEN
2582: l_params(1).paramName := 'p_orgID';
2583: l_params(1).paramValue := p_orgID;