DBA Data[Home] [Help]

APPS.WIP_OSP dependencies on WIP_LOGGER

Line 1567: l_params wip_logger.param_tbl_t;

1563: p_new_NBD IN DATE,
1564: p_ou_id IN NUMBER,
1565: x_return_status OUT NOCOPY VARCHAR2) IS
1566:
1567: l_params wip_logger.param_tbl_t;
1568: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1569: l_returnStatus VARCHAR2(1);
1570: l_errMsg VARCHAR2(240);
1571: l_msgCount NUMBER;

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

1594: l_params(8).paramName := 'p_new_NBD';
1595: l_params(8).paramValue := p_new_NBD;
1596: l_params(9).paramName := 'p_ou_id';
1597: l_params(9).paramValue := p_ou_id;
1598: wip_logger.entryPoint(p_procName => 'wip_osp.updatePOReqNBD',
1599: p_params => l_params,
1600: x_returnStatus => l_returnStatus);
1601: END IF;
1602:

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

1683: END IF;
1684: END IF; -- PO or Requisition
1685: -- write to the log file
1686: IF (l_logLevel <= wip_constants.trace_logging) THEN
1687: wip_logger.exitPoint(p_procName => 'wip_osp.updatePOReqNBD',
1688: p_procReturnStatus => x_return_status,
1689: p_msg => 'procedure complete',
1690: x_returnStatus => l_returnStatus);
1691: END IF;

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

1693: WHEN fnd_api.g_exc_unexpected_error THEN
1694: ROLLBACK TO SAVEPOINT s_update_po_nbd;
1695: x_return_status := fnd_api.g_ret_sts_unexp_error;
1696: IF (l_logLevel <= wip_constants.trace_logging) THEN
1697: wip_logger.exitPoint(p_procName => 'wip_osp.updatePOReqNBD',
1698: p_procReturnStatus => x_return_status,
1699: p_msg => l_errMsg,
1700: x_returnStatus => l_returnStatus);
1701: END IF;

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

1704: ROLLBACK TO SAVEPOINT s_update_po_nbd;
1705: x_return_status := fnd_api.g_ret_sts_unexp_error;
1706: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1707: IF (l_logLevel <= wip_constants.trace_logging) THEN
1708: wip_logger.exitPoint(p_procName => 'wip_osp.updatePOReqNBD',
1709: p_procReturnStatus => x_return_status,
1710: p_msg => l_errMsg,
1711: x_returnStatus => l_returnStatus);
1712: END IF;

Line 2027: l_params wip_logger.param_tbl_t;

2023:
2024: l_pending_recs NUMBER;
2025: l_multiple_po c_multiple_po%ROWTYPE;
2026: l_update_po_qty c_update_po_qty%ROWTYPE;
2027: l_params wip_logger.param_tbl_t;
2028: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2029: l_returnStatus VARCHAR2(1);
2030: l_errMsg VARCHAR2(240);
2031: l_debugMsg VARCHAR2(240);

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

2047: l_params(4).paramName := 'p_changed_qty';
2048: l_params(4).paramValue := p_changed_qty;
2049: l_params(5).paramName := 'p_fm_op';
2050: l_params(5).paramValue := p_fm_op;
2051: wip_logger.entryPoint(p_procName => 'wip_osp.updatePOReqQuantity',
2052: p_params => l_params,
2053: x_returnStatus => l_returnStatus);
2054: END IF;
2055:

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

2132: 'po_distribution_id = ' ||
2133: l_update_po_qty.po_distribution_id || ' ; ' ||
2134: 'new_po_qty = ' || l_update_po_qty.new_po_qty;
2135:
2136: wip_logger.log(p_msg => l_debugMsg,
2137: x_returnStatus => l_returnStatus);
2138: END IF;
2139:
2140: po_wip_integration_grp.update_document(

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

2185: || ' ; ' || 'req_line_id = ' ||
2186: l_update_po_qty.req_line_id || ' ; ' ||
2187: 'new_po_qty = ' || l_update_po_qty.new_po_qty;
2188:
2189: wip_logger.log(p_msg => l_debugMsg,
2190: x_returnStatus => l_returnStatus);
2191: END IF;
2192:
2193: po_wip_integration_grp.update_requisition(

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

2214: END IF;
2215:
2216: -- write to the log file
2217: IF (l_logLevel <= wip_constants.trace_logging) THEN
2218: wip_logger.exitPoint(p_procName => 'wip_osp.updatePOReqQuantity',
2219: p_procReturnStatus => x_return_status,
2220: p_msg => 'procedure complete',
2221: x_returnStatus => l_returnStatus);
2222: END IF;

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

2227: CLOSE c_multiple_po;
2228: END IF;
2229: x_return_status := fnd_api.g_ret_sts_unexp_error;
2230: IF (l_logLevel <= wip_constants.trace_logging) THEN
2231: wip_logger.exitPoint(p_procName => 'wip_osp.updatePOReqQuantity',
2232: p_procReturnStatus => x_return_status,
2233: p_msg => l_errMsg,
2234: x_returnStatus => l_returnStatus);
2235: END IF;

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

2241: END IF;
2242: x_return_status := fnd_api.g_ret_sts_unexp_error;
2243: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
2244: IF (l_logLevel <= wip_constants.trace_logging) THEN
2245: wip_logger.exitPoint(p_procName => 'wip_osp.updatePOReqQuantity',
2246: p_procReturnStatus => x_return_status,
2247: p_msg => l_errMsg,
2248: x_returnStatus => l_returnStatus);
2249: END IF;

Line 2358: l_params wip_logger.param_tbl_t;

2354:
2355: l_po_req c_po_req%ROWTYPE;
2356: l_err_count NUMBER := 0;
2357: l_pending_recs NUMBER;
2358: l_params wip_logger.param_tbl_t;
2359: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2360: l_returnStatus VARCHAR2(1);
2361: l_errMsg VARCHAR2(240);
2362: l_debugMsg VARCHAR2(240);

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

2372: l_params(3).paramName := 'p_org_id';
2373: l_params(3).paramValue := p_org_id;
2374: l_params(4).paramName := 'p_op_seq_num';
2375: l_params(4).paramValue := p_op_seq_num;
2376: wip_logger.entryPoint(p_procName => 'wip_osp.cancelPOReq',
2377: p_params => l_params,
2378: x_returnStatus => l_returnStatus);
2379: END IF;
2380:

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

2394: 'po_line_id = ' || l_po_req.po_line_id || ' ; ' ||
2395: 'po_line_location_id = ' ||
2396: l_po_req.po_line_location_id;
2397:
2398: wip_logger.log(p_msg => l_debugMsg,
2399: x_returnStatus => l_returnStatus);
2400: END IF;
2401:
2402: -- Call PO API to cancel requisition

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

2436: IF (l_logLevel <= wip_constants.full_logging) THEN
2437: l_debugMsg := 'req_header_id = ' || l_po_req.req_header_id|| ' ; '
2438: || 'req_line_id = ' || l_po_req.req_line_id;
2439:
2440: wip_logger.log(p_msg => l_debugMsg,
2441: x_returnStatus => l_returnStatus);
2442: END IF;
2443: -- Call PO API to cancel requisition
2444: po_wip_integration_grp.cancel_requisition

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

2483: END IF;
2484: END IF;
2485: -- write to the log file
2486: IF (l_logLevel <= wip_constants.trace_logging) THEN
2487: wip_logger.exitPoint(p_procName => 'wip_osp.cancelPOReq',
2488: p_procReturnStatus => x_return_status,
2489: p_msg => 'procedure complete',
2490: x_returnStatus => l_returnStatus);
2491: END IF;

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

2493: WHEN others THEN
2494: x_return_status := fnd_api.g_ret_sts_unexp_error;
2495: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
2496: IF (l_logLevel <= wip_constants.trace_logging) THEN
2497: wip_logger.exitPoint(p_procName => 'wip_osp.cancelPOReq',
2498: p_procReturnStatus => x_return_status,
2499: p_msg => l_errMsg,
2500: x_returnStatus => l_returnStatus);
2501: END IF;