DBA Data[Home] [Help]

APPS.CSTPAPBR dependencies on FND_API

Line 8060: l_return_status VARCHAR(1) := FND_API.G_RET_STS_SUCCESS;

8056: no_txn_det_error EXCEPTION;
8057:
8058: -- Variables for eAM support in PAC
8059:
8060: l_return_status VARCHAR(1) := FND_API.G_RET_STS_SUCCESS;
8061: l_msg_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
8062: l_msg_count NUMBER := 0;
8063: l_msg_data VARCHAR2(8000) := '';
8064: l_api_message VARCHAR2(1000) := '';

Line 8061: l_msg_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

8057:
8058: -- Variables for eAM support in PAC
8059:
8060: l_return_status VARCHAR(1) := FND_API.G_RET_STS_SUCCESS;
8061: l_msg_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
8062: l_msg_count NUMBER := 0;
8063: l_msg_data VARCHAR2(8000) := '';
8064: l_api_message VARCHAR2(1000) := '';
8065: l_cost_element NUMBER;

Line 8173: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

8169: p_pac_or_perp => 1,
8170: x_cost_element_id => l_cost_element
8171: );
8172:
8173: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
8174: FND_FILE.put_line(FND_FILE.log, l_msg_data);
8175: l_api_message := 'get_CostEle_for_DirectItem returned unexpected error';
8176: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
8177: FND_MESSAGE.set_token('TEXT', l_api_message);

Line 8179: raise fnd_api.g_exc_unexpected_error;

8175: l_api_message := 'get_CostEle_for_DirectItem returned unexpected error';
8176: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
8177: FND_MESSAGE.set_token('TEXT', l_api_message);
8178: FND_MSG_pub.add;
8179: raise fnd_api.g_exc_unexpected_error;
8180: END IF;
8181:
8182: IF (g_debug_flag = 'Y') THEN
8183: FND_FILE.PUT_LINE(FND_FILE.LOG, 'mfg cost_element_id: '||

Line 9169: l_msg_data) <> FND_API.g_ret_sts_success) then

9165: l_concat_seg,
9166: l_concat_id,
9167: l_concat_desc,
9168: l_msg_count,
9169: l_msg_data) <> FND_API.g_ret_sts_success) then
9170: l_stmt_num := 90;
9171:
9172: SELECT nvl(MSI.cost_of_sales_account, MP.cost_of_sales_account)
9173: INTO l_cogs_ccid