8442: no_txn_det_error EXCEPTION;
8443:
8444: -- Variables for eAM support in PAC
8445:
8446: l_return_status VARCHAR(1) := FND_API.G_RET_STS_SUCCESS;
8447: l_msg_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
8448: l_msg_count NUMBER := 0;
8449: l_msg_data VARCHAR2(8000) := '';
8450: l_api_message VARCHAR2(1000) := '';
8443:
8444: -- Variables for eAM support in PAC
8445:
8446: l_return_status VARCHAR(1) := FND_API.G_RET_STS_SUCCESS;
8447: l_msg_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
8448: l_msg_count NUMBER := 0;
8449: l_msg_data VARCHAR2(8000) := '';
8450: l_api_message VARCHAR2(1000) := '';
8451: l_cost_element NUMBER;
8555: p_pac_or_perp => 1,
8556: x_cost_element_id => l_cost_element
8557: );
8558:
8559: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
8560: FND_FILE.put_line(FND_FILE.log, l_msg_data);
8561: l_api_message := 'get_CostEle_for_DirectItem returned unexpected error';
8562: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
8563: FND_MESSAGE.set_token('TEXT', l_api_message);
8561: l_api_message := 'get_CostEle_for_DirectItem returned unexpected error';
8562: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
8563: FND_MESSAGE.set_token('TEXT', l_api_message);
8564: FND_MSG_pub.add;
8565: raise fnd_api.g_exc_unexpected_error;
8566: END IF;
8567:
8568: IF (g_debug_flag = 'Y') THEN
8569: FND_FILE.PUT_LINE(FND_FILE.LOG, 'mfg cost_element_id: '||
9606: l_concat_seg,
9607: l_concat_id,
9608: l_concat_desc,
9609: l_msg_count,
9610: l_msg_data) <> FND_API.g_ret_sts_success) then
9611: l_stmt_num := 90;
9612:
9613: SELECT nvl(MSI.cost_of_sales_account, MP.cost_of_sales_account)
9614: INTO l_cogs_ccid