APPS.WIP_RESERVATIONS_GRP dependencies on FND_API

Line 23: , p_supply_demand_line_detail IN NUMBER default FND_API.G_MISS_NUM

19: , p_supply_demand_code IN NUMBER
20: , p_supply_demand_type_id IN NUMBER
21: , p_supply_demand_header_id IN NUMBER
22: , p_supply_demand_line_id IN NUMBER
23: , p_supply_demand_line_detail IN NUMBER default FND_API.G_MISS_NUM
24: , p_lpn_id IN NUMBER default FND_API.G_MISS_NUM
25: , p_project_id IN NUMBER default null
26: , p_task_id IN NUMBER default null
27: , p_return_txn IN NUMBER default 0

Line 24: , p_lpn_id IN NUMBER default FND_API.G_MISS_NUM

20: , p_supply_demand_type_id IN NUMBER
21: , p_supply_demand_header_id IN NUMBER
22: , p_supply_demand_line_id IN NUMBER
23: , p_supply_demand_line_detail IN NUMBER default FND_API.G_MISS_NUM
24: , p_lpn_id IN NUMBER default FND_API.G_MISS_NUM
25: , p_project_id IN NUMBER default null
26: , p_task_id IN NUMBER default null
27: , p_return_txn IN NUMBER default 0
28: ) IS

Line 67: x_return_status := fnd_api.g_ret_sts_success;

63: p_params => l_params,
64: x_returnStatus => l_returnStatus);
65: END IF;
66:
67: x_return_status := fnd_api.g_ret_sts_success;
68:
69: /* If API is called with parameter p_supply_demand_code being demand */
70: IF ( p_supply_demand_code = 1 ) THEN
71: IF ( p_return_txn = 0) THEN -- If it is normal transaction

Line 118: x_return_status := fnd_api.g_ret_sts_error;

114:
115: ELSE
116: fnd_message.set_name('WIP', 'WIP_SUPPLY_SOURCE');
117: fnd_msg_pub.ADD;
118: x_return_status := fnd_api.g_ret_sts_error;
119: END IF;
120: IF (l_logLevel <= wip_constants.trace_logging) THEN
121: wip_logger.exitPoint(p_procName => 'wip_reservations_grp.get_available_supply_demand',
122: p_procReturnStatus => x_return_status,

Line 128: x_return_status := fnd_api.g_ret_sts_unexp_error;

124: x_returnStatus => l_returnStatus);
125: END IF;
126: EXCEPTION
127: WHEN OTHERS THEN
128: x_return_status := fnd_api.g_ret_sts_unexp_error;
129: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
130: IF (l_logLevel <= wip_constants.trace_logging) THEN
131: wip_logger.exitPoint(p_procName => 'wip_reservations_grp.get_available_supply_demand',
132: p_procReturnStatus => x_return_status,

Line 153: , p_supply_demand_line_detail IN NUMBER default FND_API.G_MISS_NUM

149: , p_supply_demand_code IN NUMBER
150: , p_supply_demand_type_id IN NUMBER
151: , p_supply_demand_header_id IN NUMBER
152: , p_supply_demand_line_id IN NUMBER
153: , p_supply_demand_line_detail IN NUMBER default FND_API.G_MISS_NUM
154: , p_demand_ship_date IN DATE
155: , p_expected_receipt_date IN DATE
156: , p_api_version_number IN NUMBER default 1.0
157: ,p_init_msg_lst IN VARCHAR2

Line 188: x_return_status := fnd_api.g_ret_sts_success;

184: p_params => l_params,
185: x_returnStatus => l_returnStatus);
186: END IF;
187:
188: x_return_status := fnd_api.g_ret_sts_success;
189:
190: /* If API is called with parameter p_supply_demand_code being demand */
191:
192: IF ( p_supply_demand_code = 1 ) then

Line 245: x_return_status := FND_API.G_RET_STS_ERROR;

241: /* If API is called with parameter p_supply_demand_code being Supply
242: Error Out with appropriate error message */
243: fnd_message.set_name('WIP', 'WIP_SUPPLY_SOURCE');
244: fnd_msg_pub.ADD;
245: x_return_status := FND_API.G_RET_STS_ERROR;
246: END IF ; -- p_supply_demand_code if condition
247:
248: -- Fixed bug 5371701. x_valid_status was not set and there is no call to
249: -- wip_logger.exitPoint().

Line 262: x_return_status := fnd_api.g_ret_sts_unexp_error;

258: END IF;
259: /* Need to handle exceptions and return unexpected error to the return status */
260: EXCEPTION
261: WHEN OTHERS THEN
262: x_return_status := fnd_api.g_ret_sts_unexp_error;
263: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
264: IF (l_logLevel <= wip_constants.trace_logging) THEN
265: wip_logger.exitPoint(p_procName => 'wip_reservations_grp.validate_supply_demand',
266: p_procReturnStatus => x_return_status,