31:
32: x_return_status := FND_API.G_RET_STS_SUCCESS;
33:
34: IF p_org_id is NULL THEN
35: FND_MESSAGE.SET_NAME('AR','AR_MAND_PARAMETER_NULL');
36: FND_MESSAGE.SET_TOKEN('PARAM','p_org_id');
37: x_msg_data := FND_MESSAGE.GET;
38: x_return_status := FND_API.G_RET_STS_ERROR;
39: RETURN;
32: x_return_status := FND_API.G_RET_STS_SUCCESS;
33:
34: IF p_org_id is NULL THEN
35: FND_MESSAGE.SET_NAME('AR','AR_MAND_PARAMETER_NULL');
36: FND_MESSAGE.SET_TOKEN('PARAM','p_org_id');
37: x_msg_data := FND_MESSAGE.GET;
38: x_return_status := FND_API.G_RET_STS_ERROR;
39: RETURN;
40: END IF;
33:
34: IF p_org_id is NULL THEN
35: FND_MESSAGE.SET_NAME('AR','AR_MAND_PARAMETER_NULL');
36: FND_MESSAGE.SET_TOKEN('PARAM','p_org_id');
37: x_msg_data := FND_MESSAGE.GET;
38: x_return_status := FND_API.G_RET_STS_ERROR;
39: RETURN;
40: END IF;
41: IF p_bill_to_customer_account_id IS NULL THEN
38: x_return_status := FND_API.G_RET_STS_ERROR;
39: RETURN;
40: END IF;
41: IF p_bill_to_customer_account_id IS NULL THEN
42: FND_MESSAGE.SET_NAME('AR','AR_MAND_PARAMETER_NULL');
43: FND_MESSAGE.SET_TOKEN('PARAM','p_bill_to_customer_account_id');
44: x_msg_data := FND_MESSAGE.GET;
45: x_return_status := FND_API.G_RET_STS_ERROR;
46: RETURN;
39: RETURN;
40: END IF;
41: IF p_bill_to_customer_account_id IS NULL THEN
42: FND_MESSAGE.SET_NAME('AR','AR_MAND_PARAMETER_NULL');
43: FND_MESSAGE.SET_TOKEN('PARAM','p_bill_to_customer_account_id');
44: x_msg_data := FND_MESSAGE.GET;
45: x_return_status := FND_API.G_RET_STS_ERROR;
46: RETURN;
47: END IF;
40: END IF;
41: IF p_bill_to_customer_account_id IS NULL THEN
42: FND_MESSAGE.SET_NAME('AR','AR_MAND_PARAMETER_NULL');
43: FND_MESSAGE.SET_TOKEN('PARAM','p_bill_to_customer_account_id');
44: x_msg_data := FND_MESSAGE.GET;
45: x_return_status := FND_API.G_RET_STS_ERROR;
46: RETURN;
47: END IF;
48:
143:
144: EXCEPTION
145: WHEN OTHERS THEN
146: x_return_status := fnd_api.g_ret_sts_unexp_error;
147: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
148: fnd_message.set_token('ERROR' ,SQLERRM);
149: x_msg_data := fnd_message.get;
150:
151: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
144: EXCEPTION
145: WHEN OTHERS THEN
146: x_return_status := fnd_api.g_ret_sts_unexp_error;
147: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
148: fnd_message.set_token('ERROR' ,SQLERRM);
149: x_msg_data := fnd_message.get;
150:
151: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
152: fnd_log.string(fnd_log.LEVEL_EXCEPTION,G_PKG_NAME||l_procedure_name,'SQLERRM :'||SQLERRM);
145: WHEN OTHERS THEN
146: x_return_status := fnd_api.g_ret_sts_unexp_error;
147: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
148: fnd_message.set_token('ERROR' ,SQLERRM);
149: x_msg_data := fnd_message.get;
150:
151: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
152: fnd_log.string(fnd_log.LEVEL_EXCEPTION,G_PKG_NAME||l_procedure_name,'SQLERRM :'||SQLERRM);
153: END IF;