[Home] [Help]
90: l_params wip_logger.param_tbl_t;
91:
92: l_fromUI NUMBER;--> 0 if the record originated from oracle user interfaces
93:
94: l_logLevel NUMBER := to_number(fnd_log.g_current_runtime_level);
95: l_src_code VARCHAR2(2000);
96: l_errMsg VARCHAR2(50); /* Fix for Bug#5187500. Changed it to 50 */
97: l_bf_count NUMBER ; /* Fix for Bug#5187500 */
98: l_lot_ser_count NUMBER ; /* Fix for Bug#5187500 */
745: l_service_item_flag varchar2(1) ; /*BUG 6134576*/
746:
747: l_params wip_logger.param_tbl_t;
748: l_returnStatus varchar2(1);
749: l_logLevel NUMBER := to_number(fnd_log.g_current_runtime_level);
750: l_errMsg VARCHAR2(2000);
751:
752: cursor wfs_info_cursor(wipEntityId number) is
753: select wip_entity_id,
1467: l_overheadVarianceAccount number ;
1468:
1469: l_params wip_logger.param_tbl_t;
1470: l_returnStatus varchar2(1);
1471: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1472:
1473: l_prjID NUMBER;
1474: l_tskID NUMBER;
1475:
1838: l_newCompletedQty number;
1839:
1840: l_params wip_logger.param_tbl_t;
1841: l_returnStatus varchar2(1);
1842: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1843: begin
1844:
1845: if (l_logLevel <= wip_constants.trace_logging) then
1846: l_params(1).paramName := 'p_txnTempID';
2014: l_commonRoutSeqID number;
2015: l_checkPass boolean;
2016: l_lineOpTbl bom_rtg_network_api.op_tbl_type;
2017: l_constructed boolean := false;
2018: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2019: l_success boolean;
2020: l_locatorID number := null;
2021:
2022: l_includeYield NUMBER; /*Component Yield Enhancement(Bug 4369064)*/
2314: l_openPastPeriod boolean := false;
2315:
2316: l_params wip_logger.param_tbl_t;
2317: l_returnStatus varchar2(1);
2318: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2319: begin
2320:
2321: if (l_logLevel <= wip_constants.trace_logging) then
2322: l_params(1).paramName := 'p_txnTempID';
2722: l_srcTaskID number;
2723: l_wipEntityID number;
2724: l_projRefEnabled number;
2725: l_orgLocControl number := 0;
2726: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2727: begin
2728: if (l_logLevel <= wip_constants.trace_logging) then
2729: l_params(1).paramName := 'p_parentID';
2730: l_params(1).paramValue := p_parentID;