APPS.CS_CONBILLING_PVT dependencies on FND_API

Line 35: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

31:
32:
33: PROCEDURE update_billing(
34: p_api_version IN NUMBER,
35: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
36: p_commit IN VARCHAR2 := FND_API.G_FALSE,
37: p_cp_service_trx_id IN NUMBER,
38: p_contract_id IN NUMBER,
39: p_trx_type_id IN NUMBER,

Line 36: p_commit IN VARCHAR2 := FND_API.G_FALSE,

32:
33: PROCEDURE update_billing(
34: p_api_version IN NUMBER,
35: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
36: p_commit IN VARCHAR2 := FND_API.G_FALSE,
37: p_cp_service_trx_id IN NUMBER,
38: p_contract_id IN NUMBER,
39: p_trx_type_id IN NUMBER,
40: p_trx_number IN NUMBER,

Line 52: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

48: x_msg_data OUT NUMBER) IS
49:
50: l_api_name CONSTANT VARCHAR2(30):='Update_Billing_Api';
51: l_api_version CONSTANT NUMBER := 1;
52: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
53: l_msg_data VARCHAR2(2000);
54:
55: transaction_class VARCHAR2(4);
56: v_return_status VARCHAR2(1);

Line 73: IF (l_return_status=FND_API.G_RET_STS_UNEXP_ERROR) then

69: '_pvt',
70: x_return_status);
71:
72:
73: IF (l_return_status=FND_API.G_RET_STS_UNEXP_ERROR) then
74: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
75: END IF;
76:
77: SELECT type INTO transaction_class

Line 74: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

70: x_return_status);
71:
72:
73: IF (l_return_status=FND_API.G_RET_STS_UNEXP_ERROR) then
74: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
75: END IF;
76:
77: SELECT type INTO transaction_class
78: FROM ra_cust_trx_types

Line 83: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

79: WHERE cust_trx_type_id=p_trx_type_id;
80:
81: IF SQL%NOTFOUND THEN
82: fnd_message.set_name('CS','CS_CONTRACTS_CLASS_NOT_FOUND');
83: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
84:
85: END IF;
86:
87: /* update inv details in cs_contract_billing*/

Line 151: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

147: );
148:
149: END IF;
150:
151: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
152: fnd_message.set_name('CS','CS_CONTRACTS_ERR_UPD_BILL');
153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
154:
155: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

149: END IF;
150:
151: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
152: fnd_message.set_name('CS','CS_CONTRACTS_ERR_UPD_BILL');
153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
154:
155: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
156: fnd_message.set_name('CS','CS_CONTRACTS_ERR_UPD_BILL');
157: RAISE FND_API.G_EXC_ERROR;

Line 155: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

151: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
152: fnd_message.set_name('CS','CS_CONTRACTS_ERR_UPD_BILL');
153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
154:
155: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
156: fnd_message.set_name('CS','CS_CONTRACTS_ERR_UPD_BILL');
157: RAISE FND_API.G_EXC_ERROR;
158: END IF;
159:

Line 157: RAISE FND_API.G_EXC_ERROR;

153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
154:
155: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
156: fnd_message.set_name('CS','CS_CONTRACTS_ERR_UPD_BILL');
157: RAISE FND_API.G_EXC_ERROR;
158: END IF;
159:
160: IF (v_return_status <>'S' and v_msg_count >=1) then
161: fnd_file.put_line(fnd_file.log , 'message '|| v_msg_data);

Line 169: x_return_status := FND_API.G_RET_STS_SUCCESS;

165: TAPI_DEV_KIT.END_ACTIVITY(p_commit,
166: x_msg_count,
167: x_msg_data);
168:
169: x_return_status := FND_API.G_RET_STS_SUCCESS;
170:
171: --COMMIT;
172:
173: EXCEPTION

Line 174: WHEN FND_API.G_EXC_ERROR THEN

170:
171: --COMMIT;
172:
173: EXCEPTION
174: WHEN FND_API.G_EXC_ERROR THEN
175: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
176: ( l_api_name,
177: G_PKG_NAME,
178: 'FND_API.G_RET_STS_ERROR',

Line 178: 'FND_API.G_RET_STS_ERROR',

174: WHEN FND_API.G_EXC_ERROR THEN
175: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
176: ( l_api_name,
177: G_PKG_NAME,
178: 'FND_API.G_RET_STS_ERROR',
179: x_msg_count,
180: x_msg_data,
181: '_pvt');
182:

Line 183: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

179: x_msg_count,
180: x_msg_data,
181: '_pvt');
182:
183: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
184: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
185: ( l_api_name,
186: G_PKG_NAME,
187: 'FND_API.G_RET_STS_UNEXP_ERROR',

Line 187: 'FND_API.G_RET_STS_UNEXP_ERROR',

183: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
184: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
185: ( l_api_name,
186: G_PKG_NAME,
187: 'FND_API.G_RET_STS_UNEXP_ERROR',
188: x_msg_count,
189: x_msg_data,
190: '_pvt');
191: