DBA Data[Home] [Help]

APPS.WIP_OSP dependencies on WIP_LOGGER

Line 1660: l_params wip_logger.param_tbl_t;

1656: p_new_NBD IN DATE,
1657: p_ou_id IN NUMBER,
1658: x_return_status OUT NOCOPY VARCHAR2) IS
1659:
1660: l_params wip_logger.param_tbl_t;
1661: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1662: l_returnStatus VARCHAR2(1);
1663: l_errMsg VARCHAR2(240);
1664: l_msgCount NUMBER;

Line 1691: wip_logger.entryPoint(p_procName => 'wip_osp.updatePOReqNBD',

1687: l_params(8).paramName := 'p_new_NBD';
1688: l_params(8).paramValue := p_new_NBD;
1689: l_params(9).paramName := 'p_ou_id';
1690: l_params(9).paramValue := p_ou_id;
1691: wip_logger.entryPoint(p_procName => 'wip_osp.updatePOReqNBD',
1692: p_params => l_params,
1693: x_returnStatus => l_returnStatus);
1694: END IF;
1695:

Line 1780: wip_logger.exitPoint(p_procName => 'wip_osp.updatePOReqNBD',

1776: END IF;
1777: END IF; -- PO or Requisition
1778: -- write to the log file
1779: IF (l_logLevel <= wip_constants.trace_logging) THEN
1780: wip_logger.exitPoint(p_procName => 'wip_osp.updatePOReqNBD',
1781: p_procReturnStatus => x_return_status,
1782: p_msg => 'procedure complete',
1783: x_returnStatus => l_returnStatus);
1784: END IF;

Line 1790: wip_logger.exitPoint(p_procName => 'wip_osp.updatePOReqNBD',

1786: WHEN fnd_api.g_exc_unexpected_error THEN
1787: ROLLBACK TO SAVEPOINT s_update_po_nbd;
1788: x_return_status := fnd_api.g_ret_sts_unexp_error;
1789: IF (l_logLevel <= wip_constants.trace_logging) THEN
1790: wip_logger.exitPoint(p_procName => 'wip_osp.updatePOReqNBD',
1791: p_procReturnStatus => x_return_status,
1792: p_msg => l_errMsg,
1793: x_returnStatus => l_returnStatus);
1794: END IF;

Line 1801: wip_logger.exitPoint(p_procName => 'wip_osp.updatePOReqNBD',

1797: ROLLBACK TO SAVEPOINT s_update_po_nbd;
1798: x_return_status := fnd_api.g_ret_sts_unexp_error;
1799: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1800: IF (l_logLevel <= wip_constants.trace_logging) THEN
1801: wip_logger.exitPoint(p_procName => 'wip_osp.updatePOReqNBD',
1802: p_procReturnStatus => x_return_status,
1803: p_msg => l_errMsg,
1804: x_returnStatus => l_returnStatus);
1805: END IF;

Line 2150: l_params wip_logger.param_tbl_t;

2146:
2147: l_pending_recs NUMBER;
2148: l_multiple_po c_multiple_po%ROWTYPE;
2149: l_update_po_qty c_update_po_qty%ROWTYPE;
2150: l_params wip_logger.param_tbl_t;
2151: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2152: l_returnStatus VARCHAR2(1);
2153: l_errMsg VARCHAR2(240);
2154: l_debugMsg VARCHAR2(240);

Line 2177: wip_logger.entryPoint(p_procName => 'wip_osp.updatePOReqQuantity',

2173: l_params(4).paramName := 'p_changed_qty';
2174: l_params(4).paramValue := p_changed_qty;
2175: l_params(5).paramName := 'p_fm_op';
2176: l_params(5).paramValue := p_fm_op;
2177: wip_logger.entryPoint(p_procName => 'wip_osp.updatePOReqQuantity',
2178: p_params => l_params,
2179: x_returnStatus => l_returnStatus);
2180: END IF;
2181:

Line 2267: wip_logger.log(p_msg => l_debugMsg,

2263: 'po_distribution_id = ' ||
2264: l_update_po_qty.po_distribution_id || ' ; ' ||
2265: 'new_po_qty = ' || l_update_po_qty.new_po_qty||';indx='||indx;
2266:
2267: wip_logger.log(p_msg => l_debugMsg,
2268: x_returnStatus => l_returnStatus);
2269: END IF;
2270: l_pochanges_tab(indx):=l_po_changes;
2271: /* Commented by tekang for FP bug 10383628

Line 2322: wip_logger.log(p_msg => l_debugMsg,

2318: || ' ; ' || 'req_line_id = ' ||
2319: l_update_po_qty.req_line_id || ' ; ' ||
2320: 'new_po_qty = ' || l_update_po_qty.new_po_qty;
2321:
2322: wip_logger.log(p_msg => l_debugMsg,
2323: x_returnStatus => l_returnStatus);
2324: END IF;
2325:
2326: po_wip_integration_grp.update_requisition(

Line 2378: wip_logger.exitPoint(p_procName => 'wip_osp.updatePOReqQuantity',

2374: END IF;
2375:
2376: -- write to the log file
2377: IF (l_logLevel <= wip_constants.trace_logging) THEN
2378: wip_logger.exitPoint(p_procName => 'wip_osp.updatePOReqQuantity',
2379: p_procReturnStatus => x_return_status,
2380: p_msg => 'procedure complete',
2381: x_returnStatus => l_returnStatus);
2382: END IF;

Line 2391: wip_logger.exitPoint(p_procName => 'wip_osp.updatePOReqQuantity',

2387: CLOSE c_multiple_po;
2388: END IF;
2389: x_return_status := fnd_api.g_ret_sts_unexp_error;
2390: IF (l_logLevel <= wip_constants.trace_logging) THEN
2391: wip_logger.exitPoint(p_procName => 'wip_osp.updatePOReqQuantity',
2392: p_procReturnStatus => x_return_status,
2393: p_msg => l_errMsg,
2394: x_returnStatus => l_returnStatus);
2395: END IF;

Line 2405: wip_logger.exitPoint(p_procName => 'wip_osp.updatePOReqQuantity',

2401: END IF;
2402: x_return_status := fnd_api.g_ret_sts_unexp_error;
2403: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
2404: IF (l_logLevel <= wip_constants.trace_logging) THEN
2405: wip_logger.exitPoint(p_procName => 'wip_osp.updatePOReqQuantity',
2406: p_procReturnStatus => x_return_status,
2407: p_msg => l_errMsg,
2408: x_returnStatus => l_returnStatus);
2409: END IF;

Line 2519: l_params wip_logger.param_tbl_t;

2515:
2516: l_po_req c_po_req%ROWTYPE;
2517: l_err_count NUMBER := 0;
2518: l_pending_recs NUMBER;
2519: l_params wip_logger.param_tbl_t;
2520: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2521: l_returnStatus VARCHAR2(1);
2522: l_errMsg VARCHAR2(240);
2523: l_debugMsg VARCHAR2(240);

Line 2537: wip_logger.entryPoint(p_procName => 'wip_osp.cancelPOReq',

2533: l_params(3).paramName := 'p_org_id';
2534: l_params(3).paramValue := p_org_id;
2535: l_params(4).paramName := 'p_op_seq_num';
2536: l_params(4).paramValue := p_op_seq_num;
2537: wip_logger.entryPoint(p_procName => 'wip_osp.cancelPOReq',
2538: p_params => l_params,
2539: x_returnStatus => l_returnStatus);
2540: END IF;
2541:

Line 2559: wip_logger.log(p_msg => l_debugMsg,

2555: 'po_line_id = ' || l_po_req.po_line_id || ' ; ' ||
2556: 'po_line_location_id = ' ||
2557: l_po_req.po_line_location_id;
2558:
2559: wip_logger.log(p_msg => l_debugMsg,
2560: x_returnStatus => l_returnStatus);
2561: END IF;
2562:
2563: -- Call PO API to cancel requisition

Line 2602: wip_logger.log(p_msg => l_debugMsg,

2598: IF (l_logLevel <= wip_constants.full_logging) THEN
2599: l_debugMsg := 'req_header_id = ' || l_po_req.req_header_id|| ' ; '
2600: || 'req_line_id = ' || l_po_req.req_line_id;
2601:
2602: wip_logger.log(p_msg => l_debugMsg,
2603: x_returnStatus => l_returnStatus);
2604: END IF;
2605: -- Call PO API to cancel requisition
2606: po_wip_integration_grp.cancel_requisition

Line 2649: wip_logger.exitPoint(p_procName => 'wip_osp.cancelPOReq',

2645: END IF;
2646: END IF;
2647: -- write to the log file
2648: IF (l_logLevel <= wip_constants.trace_logging) THEN
2649: wip_logger.exitPoint(p_procName => 'wip_osp.cancelPOReq',
2650: p_procReturnStatus => x_return_status,
2651: p_msg => 'procedure complete',
2652: x_returnStatus => l_returnStatus);
2653: END IF;

Line 2659: wip_logger.exitPoint(p_procName => 'wip_osp.cancelPOReq',

2655: WHEN others THEN
2656: x_return_status := fnd_api.g_ret_sts_unexp_error;
2657: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
2658: IF (l_logLevel <= wip_constants.trace_logging) THEN
2659: wip_logger.exitPoint(p_procName => 'wip_osp.cancelPOReq',
2660: p_procReturnStatus => x_return_status,
2661: p_msg => l_errMsg,
2662: x_returnStatus => l_returnStatus);
2663: END IF;