eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_CONTINTF_PVT dependencies on TAPI_DEV_KIT

Line 24: IF p_contintf_rec.cp_service_transaction_id = TAPI_DEV_KIT.G_MISS_NUM OR

20: RETURN VARCHAR2
21: IS
22: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
23: BEGIN
24: IF p_contintf_rec.cp_service_transaction_id = TAPI_DEV_KIT.G_MISS_NUM OR
25: p_contintf_rec.cp_service_transaction_id IS NULL
26: THEN
27: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'cp_service_transaction_id');
28: l_return_status := FND_API.G_RET_STS_ERROR;

Line 27: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'cp_service_transaction_id');

23: BEGIN
24: IF p_contintf_rec.cp_service_transaction_id = TAPI_DEV_KIT.G_MISS_NUM OR
25: p_contintf_rec.cp_service_transaction_id IS NULL
26: THEN
27: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'cp_service_transaction_id');
28: l_return_status := FND_API.G_RET_STS_ERROR;
29: ELSIF p_contintf_rec.cp_service_id = TAPI_DEV_KIT.G_MISS_NUM OR
30: p_contintf_rec.cp_service_id IS NULL
31: THEN

Line 29: ELSIF p_contintf_rec.cp_service_id = TAPI_DEV_KIT.G_MISS_NUM OR

25: p_contintf_rec.cp_service_transaction_id IS NULL
26: THEN
27: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'cp_service_transaction_id');
28: l_return_status := FND_API.G_RET_STS_ERROR;
29: ELSIF p_contintf_rec.cp_service_id = TAPI_DEV_KIT.G_MISS_NUM OR
30: p_contintf_rec.cp_service_id IS NULL
31: THEN
32: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'cp_service_id');
33: l_return_status := FND_API.G_RET_STS_ERROR;

Line 32: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'cp_service_id');

28: l_return_status := FND_API.G_RET_STS_ERROR;
29: ELSIF p_contintf_rec.cp_service_id = TAPI_DEV_KIT.G_MISS_NUM OR
30: p_contintf_rec.cp_service_id IS NULL
31: THEN
32: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'cp_service_id');
33: l_return_status := FND_API.G_RET_STS_ERROR;
34: ELSIF p_contintf_rec.contract_id = TAPI_DEV_KIT.G_MISS_NUM OR
35: p_contintf_rec.contract_id IS NULL
36: THEN

Line 34: ELSIF p_contintf_rec.contract_id = TAPI_DEV_KIT.G_MISS_NUM OR

30: p_contintf_rec.cp_service_id IS NULL
31: THEN
32: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'cp_service_id');
33: l_return_status := FND_API.G_RET_STS_ERROR;
34: ELSIF p_contintf_rec.contract_id = TAPI_DEV_KIT.G_MISS_NUM OR
35: p_contintf_rec.contract_id IS NULL
36: THEN
37: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'contract_id');
38: l_return_status := FND_API.G_RET_STS_ERROR;

Line 37: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'contract_id');

33: l_return_status := FND_API.G_RET_STS_ERROR;
34: ELSIF p_contintf_rec.contract_id = TAPI_DEV_KIT.G_MISS_NUM OR
35: p_contintf_rec.contract_id IS NULL
36: THEN
37: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'contract_id');
38: l_return_status := FND_API.G_RET_STS_ERROR;
39: ELSIF p_contintf_rec.ar_trx_type = TAPI_DEV_KIT.G_MISS_CHAR OR
40: p_contintf_rec.ar_trx_type IS NULL
41: THEN

Line 39: ELSIF p_contintf_rec.ar_trx_type = TAPI_DEV_KIT.G_MISS_CHAR OR

35: p_contintf_rec.contract_id IS NULL
36: THEN
37: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'contract_id');
38: l_return_status := FND_API.G_RET_STS_ERROR;
39: ELSIF p_contintf_rec.ar_trx_type = TAPI_DEV_KIT.G_MISS_CHAR OR
40: p_contintf_rec.ar_trx_type IS NULL
41: THEN
42: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'ar_trx_type');
43: l_return_status := FND_API.G_RET_STS_ERROR;

Line 42: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'ar_trx_type');

38: l_return_status := FND_API.G_RET_STS_ERROR;
39: ELSIF p_contintf_rec.ar_trx_type = TAPI_DEV_KIT.G_MISS_CHAR OR
40: p_contintf_rec.ar_trx_type IS NULL
41: THEN
42: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'ar_trx_type');
43: l_return_status := FND_API.G_RET_STS_ERROR;
44: ELSIF p_contintf_rec.trx_start_date = TAPI_DEV_KIT.G_MISS_DATE OR
45: p_contintf_rec.trx_start_date IS NULL
46: THEN

Line 44: ELSIF p_contintf_rec.trx_start_date = TAPI_DEV_KIT.G_MISS_DATE OR

40: p_contintf_rec.ar_trx_type IS NULL
41: THEN
42: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'ar_trx_type');
43: l_return_status := FND_API.G_RET_STS_ERROR;
44: ELSIF p_contintf_rec.trx_start_date = TAPI_DEV_KIT.G_MISS_DATE OR
45: p_contintf_rec.trx_start_date IS NULL
46: THEN
47: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'trx_start_date');
48: l_return_status := FND_API.G_RET_STS_ERROR;

Line 47: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'trx_start_date');

43: l_return_status := FND_API.G_RET_STS_ERROR;
44: ELSIF p_contintf_rec.trx_start_date = TAPI_DEV_KIT.G_MISS_DATE OR
45: p_contintf_rec.trx_start_date IS NULL
46: THEN
47: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'trx_start_date');
48: l_return_status := FND_API.G_RET_STS_ERROR;
49: ELSIF p_contintf_rec.trx_end_date = TAPI_DEV_KIT.G_MISS_DATE OR
50: p_contintf_rec.trx_end_date IS NULL
51: THEN

Line 49: ELSIF p_contintf_rec.trx_end_date = TAPI_DEV_KIT.G_MISS_DATE OR

45: p_contintf_rec.trx_start_date IS NULL
46: THEN
47: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'trx_start_date');
48: l_return_status := FND_API.G_RET_STS_ERROR;
49: ELSIF p_contintf_rec.trx_end_date = TAPI_DEV_KIT.G_MISS_DATE OR
50: p_contintf_rec.trx_end_date IS NULL
51: THEN
52: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'trx_end_date');
53: l_return_status := FND_API.G_RET_STS_ERROR;

Line 52: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'trx_end_date');

48: l_return_status := FND_API.G_RET_STS_ERROR;
49: ELSIF p_contintf_rec.trx_end_date = TAPI_DEV_KIT.G_MISS_DATE OR
50: p_contintf_rec.trx_end_date IS NULL
51: THEN
52: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'trx_end_date');
53: l_return_status := FND_API.G_RET_STS_ERROR;
54: ELSIF p_contintf_rec.trx_date = TAPI_DEV_KIT.G_MISS_DATE OR
55: p_contintf_rec.trx_date IS NULL
56: THEN

Line 54: ELSIF p_contintf_rec.trx_date = TAPI_DEV_KIT.G_MISS_DATE OR

50: p_contintf_rec.trx_end_date IS NULL
51: THEN
52: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'trx_end_date');
53: l_return_status := FND_API.G_RET_STS_ERROR;
54: ELSIF p_contintf_rec.trx_date = TAPI_DEV_KIT.G_MISS_DATE OR
55: p_contintf_rec.trx_date IS NULL
56: THEN
57: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'trx_date');
58: l_return_status := FND_API.G_RET_STS_ERROR;

Line 57: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'trx_date');

53: l_return_status := FND_API.G_RET_STS_ERROR;
54: ELSIF p_contintf_rec.trx_date = TAPI_DEV_KIT.G_MISS_DATE OR
55: p_contintf_rec.trx_date IS NULL
56: THEN
57: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'trx_date');
58: l_return_status := FND_API.G_RET_STS_ERROR;
59: ELSIF p_contintf_rec.trx_amount = TAPI_DEV_KIT.G_MISS_NUM OR
60: p_contintf_rec.trx_amount IS NULL
61: THEN

Line 59: ELSIF p_contintf_rec.trx_amount = TAPI_DEV_KIT.G_MISS_NUM OR

55: p_contintf_rec.trx_date IS NULL
56: THEN
57: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'trx_date');
58: l_return_status := FND_API.G_RET_STS_ERROR;
59: ELSIF p_contintf_rec.trx_amount = TAPI_DEV_KIT.G_MISS_NUM OR
60: p_contintf_rec.trx_amount IS NULL
61: THEN
62: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'trx_amount');
63: l_return_status := FND_API.G_RET_STS_ERROR;

Line 62: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'trx_amount');

58: l_return_status := FND_API.G_RET_STS_ERROR;
59: ELSIF p_contintf_rec.trx_amount = TAPI_DEV_KIT.G_MISS_NUM OR
60: p_contintf_rec.trx_amount IS NULL
61: THEN
62: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'trx_amount');
63: l_return_status := FND_API.G_RET_STS_ERROR;
64: ELSIF p_contintf_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR
65: p_contintf_rec.created_by IS NULL
66: THEN

Line 64: ELSIF p_contintf_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR

60: p_contintf_rec.trx_amount IS NULL
61: THEN
62: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'trx_amount');
63: l_return_status := FND_API.G_RET_STS_ERROR;
64: ELSIF p_contintf_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR
65: p_contintf_rec.created_by IS NULL
66: THEN
67: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'created_by');
68: l_return_status := FND_API.G_RET_STS_ERROR;

Line 67: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'created_by');

63: l_return_status := FND_API.G_RET_STS_ERROR;
64: ELSIF p_contintf_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR
65: p_contintf_rec.created_by IS NULL
66: THEN
67: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'created_by');
68: l_return_status := FND_API.G_RET_STS_ERROR;
69: ELSIF p_contintf_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR
70: p_contintf_rec.creation_date IS NULL
71: THEN

Line 69: ELSIF p_contintf_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR

65: p_contintf_rec.created_by IS NULL
66: THEN
67: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'created_by');
68: l_return_status := FND_API.G_RET_STS_ERROR;
69: ELSIF p_contintf_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR
70: p_contintf_rec.creation_date IS NULL
71: THEN
72: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'creation_date');
73: l_return_status := FND_API.G_RET_STS_ERROR;

Line 72: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'creation_date');

68: l_return_status := FND_API.G_RET_STS_ERROR;
69: ELSIF p_contintf_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR
70: p_contintf_rec.creation_date IS NULL
71: THEN
72: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'creation_date');
73: l_return_status := FND_API.G_RET_STS_ERROR;
74: END IF;
75: RETURN(l_return_status);
76: END Validate_Item_Attributes;

Line 154: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

150: END migrate;
151: PROCEDURE insert_row
152: (
153: p_api_version IN NUMBER,
154: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
155: p_validation_level IN NUMBER,
156: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
157: x_return_status OUT VARCHAR2,
158: x_msg_count OUT NUMBER,

Line 156: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

152: (
153: p_api_version IN NUMBER,
154: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
155: p_validation_level IN NUMBER,
156: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
157: x_return_status OUT VARCHAR2,
158: x_msg_count OUT NUMBER,
159: x_msg_data OUT VARCHAR2,
160: p_contintf_rec IN ContIntf_Rec_Type := G_MISS_CONTINTF_REC,

Line 169: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

165: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
166: l_contintf_rec ContIntf_Rec_Type;
167: l_def_contintf_rec ContIntf_Rec_Type;
168: BEGIN
169: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
170: G_PKG_NAME,
171: l_api_version,
172: p_api_version,
173: p_init_msg_list,

Line 256: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);

252: l_def_contintf_rec.object_version_number);
253: -- Set OUT values
254: x_contracts_interface_id := l_def_contintf_rec.contracts_interface_id;
255: x_object_version_number := l_def_contintf_rec.OBJECT_VERSION_NUMBER;
256: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
257: EXCEPTION
258: WHEN FND_API.G_EXC_ERROR THEN
259: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
260: (

Line 259: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS

255: x_object_version_number := l_def_contintf_rec.OBJECT_VERSION_NUMBER;
256: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
257: EXCEPTION
258: WHEN FND_API.G_EXC_ERROR THEN
259: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
260: (
261: l_api_name,
262: G_PKG_NAME,
263: 'FND_API.G_RET_STS_ERROR',

Line 270: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

266: '_Pvt'
267: );
268: APP_EXCEPTION.RAISE_EXCEPTION;
269: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
270: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
271: (
272: l_api_name,
273: G_PKG_NAME,
274: 'FND_API.G_RET_STS_UNEXP_ERROR',

Line 280: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN

276: x_msg_data,
277: '_Pvt'
278: );
279: APP_EXCEPTION.RAISE_EXCEPTION;
280: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
281: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
282: (
283: l_api_name,
284: G_PKG_NAME,

Line 281: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

277: '_Pvt'
278: );
279: APP_EXCEPTION.RAISE_EXCEPTION;
280: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
281: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
282: (
283: l_api_name,
284: G_PKG_NAME,
285: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

Line 285: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

281: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
282: (
283: l_api_name,
284: G_PKG_NAME,
285: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
286: x_msg_count,
287: x_msg_data,
288: '_Pvt'
289: );

Line 295: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

291: END insert_row;
292: PROCEDURE insert_row
293: (
294: p_api_version IN NUMBER,
295: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
296: p_validation_level IN NUMBER,
297: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
298: x_return_status OUT VARCHAR2,
299: x_msg_count OUT NUMBER,

Line 297: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

293: (
294: p_api_version IN NUMBER,
295: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
296: p_validation_level IN NUMBER,
297: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
298: x_return_status OUT VARCHAR2,
299: x_msg_count OUT NUMBER,
300: x_msg_data OUT VARCHAR2,
301: p_cp_service_transaction_id IN NUMBER := NULL,

Line 324: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

320: l_api_version CONSTANT NUMBER := 1;
321: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
322: l_contintf_rec ContIntf_Rec_Type;
323: BEGIN
324: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
325: G_PKG_NAME,
326: l_api_version,
327: p_api_version,
328: p_init_msg_list,

Line 364: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);

360: l_contintf_rec,
361: x_contracts_interface_id,
362: x_object_version_number
363: );
364: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
365: EXCEPTION
366: WHEN FND_API.G_EXC_ERROR THEN
367: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
368: (

Line 367: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS

363: );
364: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
365: EXCEPTION
366: WHEN FND_API.G_EXC_ERROR THEN
367: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
368: (
369: l_api_name,
370: G_PKG_NAME,
371: 'FND_API.G_RET_STS_ERROR',

Line 378: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

374: '_Pvt'
375: );
376: APP_EXCEPTION.RAISE_EXCEPTION;
377: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
378: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
379: (
380: l_api_name,
381: G_PKG_NAME,
382: 'FND_API.G_RET_STS_UNEXP_ERROR',

Line 388: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN

384: x_msg_data,
385: '_Pvt'
386: );
387: APP_EXCEPTION.RAISE_EXCEPTION;
388: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
389: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
390: (
391: l_api_name,
392: G_PKG_NAME,

Line 389: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

385: '_Pvt'
386: );
387: APP_EXCEPTION.RAISE_EXCEPTION;
388: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
389: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
390: (
391: l_api_name,
392: G_PKG_NAME,
393: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

Line 393: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

389: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
390: (
391: l_api_name,
392: G_PKG_NAME,
393: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
394: x_msg_count,
395: x_msg_data,
396: '_Pvt'
397: );

Line 403: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

399: END insert_row;
400: Procedure lock_row
401: (
402: p_api_version IN NUMBER,
403: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
404: p_validation_level IN NUMBER,
405: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
406: x_return_status OUT VARCHAR2,
407: x_msg_count OUT NUMBER,

Line 405: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

401: (
402: p_api_version IN NUMBER,
403: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
404: p_validation_level IN NUMBER,
405: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
406: x_return_status OUT VARCHAR2,
407: x_msg_count OUT NUMBER,
408: x_msg_data OUT VARCHAR2,
409: p_contracts_interface_id IN NUMBER,

Line 435: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

431: lc_object_version_number CS_CONT_BILL_IFACE.OBJECT_VERSION_NUMBER%TYPE;
432: l_row_notfound BOOLEAN := FALSE;
433: lc_row_notfound BOOLEAN := FALSE;
434: BEGIN
435: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
436: G_PKG_NAME,
437: l_api_version,
438: p_api_version,
439: p_init_msg_list,

Line 457: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);

453: WHEN E_Resource_Busy THEN
454: IF (lock_csr%ISOPEN) THEN
455: CLOSE lock_csr;
456: END IF;
457: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
458: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
459: END;
460:
461: IF ( l_row_notfound ) THEN

Line 468: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

464: lc_row_notfound := lchk_csr%NOTFOUND;
465: CLOSE lchk_csr;
466: END IF;
467: IF (lc_row_notfound) THEN
468: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
469: RAISE FND_API.G_EXC_ERROR;
470: ELSIF lc_object_version_number > p_object_version_number THEN
471: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
472: RAISE FND_API.G_EXC_ERROR;

Line 471: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

467: IF (lc_row_notfound) THEN
468: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
469: RAISE FND_API.G_EXC_ERROR;
470: ELSIF lc_object_version_number > p_object_version_number THEN
471: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
472: RAISE FND_API.G_EXC_ERROR;
473: ELSIF lc_object_version_number <> p_object_version_number THEN
474: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
475: RAISE FND_API.G_EXC_ERROR;

Line 474: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

470: ELSIF lc_object_version_number > p_object_version_number THEN
471: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
472: RAISE FND_API.G_EXC_ERROR;
473: ELSIF lc_object_version_number <> p_object_version_number THEN
474: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
475: RAISE FND_API.G_EXC_ERROR;
476: ELSIF lc_object_version_number = -1 THEN
477: TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
478: RAISE FND_API.G_EXC_ERROR;

Line 477: TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

473: ELSIF lc_object_version_number <> p_object_version_number THEN
474: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
475: RAISE FND_API.G_EXC_ERROR;
476: ELSIF lc_object_version_number = -1 THEN
477: TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
478: RAISE FND_API.G_EXC_ERROR;
479: END IF;
480: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
481: EXCEPTION

Line 480: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);

476: ELSIF lc_object_version_number = -1 THEN
477: TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
478: RAISE FND_API.G_EXC_ERROR;
479: END IF;
480: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
481: EXCEPTION
482: WHEN FND_API.G_EXC_ERROR THEN
483: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
484: (

Line 483: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS

479: END IF;
480: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
481: EXCEPTION
482: WHEN FND_API.G_EXC_ERROR THEN
483: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
484: (
485: l_api_name,
486: G_PKG_NAME,
487: 'FND_API.G_RET_STS_ERROR',

Line 494: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

490: '_Pvt'
491: );
492: APP_EXCEPTION.RAISE_EXCEPTION;
493: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
494: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
495: (
496: l_api_name,
497: G_PKG_NAME,
498: 'FND_API.G_RET_STS_UNEXP_ERROR',

Line 504: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN

500: x_msg_data,
501: '_Pvt'
502: );
503: APP_EXCEPTION.RAISE_EXCEPTION;
504: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
505: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
506: (
507: l_api_name,
508: G_PKG_NAME,

Line 505: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

501: '_Pvt'
502: );
503: APP_EXCEPTION.RAISE_EXCEPTION;
504: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
505: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
506: (
507: l_api_name,
508: G_PKG_NAME,
509: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

Line 509: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

505: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
506: (
507: l_api_name,
508: G_PKG_NAME,
509: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
510: x_msg_count,
511: x_msg_data,
512: '_Pvt'
513: );

Line 519: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

515: END lock_row;
516: Procedure update_row
517: (
518: p_api_version IN NUMBER,
519: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
520: p_validation_level IN NUMBER,
521: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
522: x_return_status OUT VARCHAR2,
523: x_msg_count OUT NUMBER,

Line 521: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

517: (
518: p_api_version IN NUMBER,
519: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
520: p_validation_level IN NUMBER,
521: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
522: x_return_status OUT VARCHAR2,
523: x_msg_count OUT NUMBER,
524: x_msg_data OUT VARCHAR2,
525: p_contintf_val_rec IN ContIntf_Val_Rec_Type := G_MISS_CONTINTF_VAL_REC,

Line 553: IF (x_contintf_rec.contracts_interface_id = TAPI_DEV_KIT.G_MISS_NUM)

549: CLOSE oco_26638_csr;
550: IF (l_row_notfound) THEN
551: l_return_status := FND_API.G_RET_STS_ERROR;
552: END IF;
553: IF (x_contintf_rec.contracts_interface_id = TAPI_DEV_KIT.G_MISS_NUM)
554: THEN
555: x_contintf_rec.contracts_interface_id := l_oco_26638.contracts_interface_id;
556: END IF;
557: IF (x_contintf_rec.cp_service_transaction_id = TAPI_DEV_KIT.G_MISS_NUM)

Line 557: IF (x_contintf_rec.cp_service_transaction_id = TAPI_DEV_KIT.G_MISS_NUM)

553: IF (x_contintf_rec.contracts_interface_id = TAPI_DEV_KIT.G_MISS_NUM)
554: THEN
555: x_contintf_rec.contracts_interface_id := l_oco_26638.contracts_interface_id;
556: END IF;
557: IF (x_contintf_rec.cp_service_transaction_id = TAPI_DEV_KIT.G_MISS_NUM)
558: THEN
559: x_contintf_rec.cp_service_transaction_id := l_oco_26638.cp_service_transaction_id;
560: END IF;
561: IF (x_contintf_rec.cp_service_id = TAPI_DEV_KIT.G_MISS_NUM)

Line 561: IF (x_contintf_rec.cp_service_id = TAPI_DEV_KIT.G_MISS_NUM)

557: IF (x_contintf_rec.cp_service_transaction_id = TAPI_DEV_KIT.G_MISS_NUM)
558: THEN
559: x_contintf_rec.cp_service_transaction_id := l_oco_26638.cp_service_transaction_id;
560: END IF;
561: IF (x_contintf_rec.cp_service_id = TAPI_DEV_KIT.G_MISS_NUM)
562: THEN
563: x_contintf_rec.cp_service_id := l_oco_26638.cp_service_id;
564: END IF;
565: IF (x_contintf_rec.contract_id = TAPI_DEV_KIT.G_MISS_NUM)

Line 565: IF (x_contintf_rec.contract_id = TAPI_DEV_KIT.G_MISS_NUM)

561: IF (x_contintf_rec.cp_service_id = TAPI_DEV_KIT.G_MISS_NUM)
562: THEN
563: x_contintf_rec.cp_service_id := l_oco_26638.cp_service_id;
564: END IF;
565: IF (x_contintf_rec.contract_id = TAPI_DEV_KIT.G_MISS_NUM)
566: THEN
567: x_contintf_rec.contract_id := l_oco_26638.contract_id;
568: END IF;
569: IF (x_contintf_rec.ar_trx_type = TAPI_DEV_KIT.G_MISS_CHAR)

Line 569: IF (x_contintf_rec.ar_trx_type = TAPI_DEV_KIT.G_MISS_CHAR)

565: IF (x_contintf_rec.contract_id = TAPI_DEV_KIT.G_MISS_NUM)
566: THEN
567: x_contintf_rec.contract_id := l_oco_26638.contract_id;
568: END IF;
569: IF (x_contintf_rec.ar_trx_type = TAPI_DEV_KIT.G_MISS_CHAR)
570: THEN
571: x_contintf_rec.ar_trx_type := l_oco_26638.ar_trx_type;
572: END IF;
573: IF (x_contintf_rec.trx_start_date = TAPI_DEV_KIT.G_MISS_DATE)

Line 573: IF (x_contintf_rec.trx_start_date = TAPI_DEV_KIT.G_MISS_DATE)

569: IF (x_contintf_rec.ar_trx_type = TAPI_DEV_KIT.G_MISS_CHAR)
570: THEN
571: x_contintf_rec.ar_trx_type := l_oco_26638.ar_trx_type;
572: END IF;
573: IF (x_contintf_rec.trx_start_date = TAPI_DEV_KIT.G_MISS_DATE)
574: THEN
575: x_contintf_rec.trx_start_date := l_oco_26638.trx_start_date;
576: END IF;
577: IF (x_contintf_rec.trx_end_date = TAPI_DEV_KIT.G_MISS_DATE)

Line 577: IF (x_contintf_rec.trx_end_date = TAPI_DEV_KIT.G_MISS_DATE)

573: IF (x_contintf_rec.trx_start_date = TAPI_DEV_KIT.G_MISS_DATE)
574: THEN
575: x_contintf_rec.trx_start_date := l_oco_26638.trx_start_date;
576: END IF;
577: IF (x_contintf_rec.trx_end_date = TAPI_DEV_KIT.G_MISS_DATE)
578: THEN
579: x_contintf_rec.trx_end_date := l_oco_26638.trx_end_date;
580: END IF;
581: IF (x_contintf_rec.trx_date = TAPI_DEV_KIT.G_MISS_DATE)

Line 581: IF (x_contintf_rec.trx_date = TAPI_DEV_KIT.G_MISS_DATE)

577: IF (x_contintf_rec.trx_end_date = TAPI_DEV_KIT.G_MISS_DATE)
578: THEN
579: x_contintf_rec.trx_end_date := l_oco_26638.trx_end_date;
580: END IF;
581: IF (x_contintf_rec.trx_date = TAPI_DEV_KIT.G_MISS_DATE)
582: THEN
583: x_contintf_rec.trx_date := l_oco_26638.trx_date;
584: END IF;
585: IF (x_contintf_rec.trx_amount = TAPI_DEV_KIT.G_MISS_NUM)

Line 585: IF (x_contintf_rec.trx_amount = TAPI_DEV_KIT.G_MISS_NUM)

581: IF (x_contintf_rec.trx_date = TAPI_DEV_KIT.G_MISS_DATE)
582: THEN
583: x_contintf_rec.trx_date := l_oco_26638.trx_date;
584: END IF;
585: IF (x_contintf_rec.trx_amount = TAPI_DEV_KIT.G_MISS_NUM)
586: THEN
587: x_contintf_rec.trx_amount := l_oco_26638.trx_amount;
588: END IF;
589: IF (x_contintf_rec.reason_code = TAPI_DEV_KIT.G_MISS_CHAR)

Line 589: IF (x_contintf_rec.reason_code = TAPI_DEV_KIT.G_MISS_CHAR)

585: IF (x_contintf_rec.trx_amount = TAPI_DEV_KIT.G_MISS_NUM)
586: THEN
587: x_contintf_rec.trx_amount := l_oco_26638.trx_amount;
588: END IF;
589: IF (x_contintf_rec.reason_code = TAPI_DEV_KIT.G_MISS_CHAR)
590: THEN
591: x_contintf_rec.reason_code := l_oco_26638.reason_code;
592: END IF;
593: IF (x_contintf_rec.reason_comments = TAPI_DEV_KIT.G_MISS_CHAR)

Line 593: IF (x_contintf_rec.reason_comments = TAPI_DEV_KIT.G_MISS_CHAR)

589: IF (x_contintf_rec.reason_code = TAPI_DEV_KIT.G_MISS_CHAR)
590: THEN
591: x_contintf_rec.reason_code := l_oco_26638.reason_code;
592: END IF;
593: IF (x_contintf_rec.reason_comments = TAPI_DEV_KIT.G_MISS_CHAR)
594: THEN
595: x_contintf_rec.reason_comments := l_oco_26638.reason_comments;
596: END IF;
597: IF (x_contintf_rec.contract_billing_id = TAPI_DEV_KIT.G_MISS_NUM)

Line 597: IF (x_contintf_rec.contract_billing_id = TAPI_DEV_KIT.G_MISS_NUM)

593: IF (x_contintf_rec.reason_comments = TAPI_DEV_KIT.G_MISS_CHAR)
594: THEN
595: x_contintf_rec.reason_comments := l_oco_26638.reason_comments;
596: END IF;
597: IF (x_contintf_rec.contract_billing_id = TAPI_DEV_KIT.G_MISS_NUM)
598: THEN
599: x_contintf_rec.contract_billing_id := l_oco_26638.contract_billing_id;
600: END IF;
601: IF (x_contintf_rec.cp_quantity = TAPI_DEV_KIT.G_MISS_NUM)

Line 601: IF (x_contintf_rec.cp_quantity = TAPI_DEV_KIT.G_MISS_NUM)

597: IF (x_contintf_rec.contract_billing_id = TAPI_DEV_KIT.G_MISS_NUM)
598: THEN
599: x_contintf_rec.contract_billing_id := l_oco_26638.contract_billing_id;
600: END IF;
601: IF (x_contintf_rec.cp_quantity = TAPI_DEV_KIT.G_MISS_NUM)
602: THEN
603: x_contintf_rec.cp_quantity := l_oco_26638.cp_quantity;
604: END IF;
605: IF (x_contintf_rec.concurrent_process_id = TAPI_DEV_KIT.G_MISS_NUM)

Line 605: IF (x_contintf_rec.concurrent_process_id = TAPI_DEV_KIT.G_MISS_NUM)

601: IF (x_contintf_rec.cp_quantity = TAPI_DEV_KIT.G_MISS_NUM)
602: THEN
603: x_contintf_rec.cp_quantity := l_oco_26638.cp_quantity;
604: END IF;
605: IF (x_contintf_rec.concurrent_process_id = TAPI_DEV_KIT.G_MISS_NUM)
606: THEN
607: x_contintf_rec.concurrent_process_id := l_oco_26638.concurrent_process_id;
608: END IF;
609: IF (x_contintf_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM)

Line 609: IF (x_contintf_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM)

605: IF (x_contintf_rec.concurrent_process_id = TAPI_DEV_KIT.G_MISS_NUM)
606: THEN
607: x_contintf_rec.concurrent_process_id := l_oco_26638.concurrent_process_id;
608: END IF;
609: IF (x_contintf_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM)
610: THEN
611: x_contintf_rec.created_by := l_oco_26638.created_by;
612: END IF;
613: IF (x_contintf_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE)

Line 613: IF (x_contintf_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE)

609: IF (x_contintf_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM)
610: THEN
611: x_contintf_rec.created_by := l_oco_26638.created_by;
612: END IF;
613: IF (x_contintf_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE)
614: THEN
615: x_contintf_rec.creation_date := l_oco_26638.creation_date;
616: END IF;
617: IF (x_contintf_rec.object_version_number = TAPI_DEV_KIT.G_MISS_NUM)

Line 617: IF (x_contintf_rec.object_version_number = TAPI_DEV_KIT.G_MISS_NUM)

613: IF (x_contintf_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE)
614: THEN
615: x_contintf_rec.creation_date := l_oco_26638.creation_date;
616: END IF;
617: IF (x_contintf_rec.object_version_number = TAPI_DEV_KIT.G_MISS_NUM)
618: THEN
619: x_contintf_rec.object_version_number := l_oco_26638.object_version_number;
620: END IF;
621: RETURN(l_return_status);

Line 624: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

620: END IF;
621: RETURN(l_return_status);
622: END populate_new_record;
623: BEGIN
624: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
625: G_PKG_NAME,
626: l_api_version,
627: p_api_version,
628: p_init_msg_list,

Line 699: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);

695: WHERE
696: CONTRACTS_INTERFACE_ID = l_def_contintf_rec.contracts_interface_id
697: ;
698: x_object_version_number := l_def_contintf_rec.OBJECT_VERSION_NUMBER;
699: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
700: EXCEPTION
701: WHEN FND_API.G_EXC_ERROR THEN
702: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
703: (

Line 702: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS

698: x_object_version_number := l_def_contintf_rec.OBJECT_VERSION_NUMBER;
699: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
700: EXCEPTION
701: WHEN FND_API.G_EXC_ERROR THEN
702: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
703: (
704: l_api_name,
705: G_PKG_NAME,
706: 'FND_API.G_RET_STS_ERROR',

Line 713: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

709: '_Pvt'
710: );
711: APP_EXCEPTION.RAISE_EXCEPTION;
712: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
713: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
714: (
715: l_api_name,
716: G_PKG_NAME,
717: 'FND_API.G_RET_STS_UNEXP_ERROR',

Line 723: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN

719: x_msg_data,
720: '_Pvt'
721: );
722: APP_EXCEPTION.RAISE_EXCEPTION;
723: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
724: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
725: (
726: l_api_name,
727: G_PKG_NAME,

Line 724: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

720: '_Pvt'
721: );
722: APP_EXCEPTION.RAISE_EXCEPTION;
723: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
724: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
725: (
726: l_api_name,
727: G_PKG_NAME,
728: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

Line 728: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

724: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
725: (
726: l_api_name,
727: G_PKG_NAME,
728: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
729: x_msg_count,
730: x_msg_data,
731: '_Pvt'
732: );

Line 738: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

734: END update_row;
735: Procedure update_row
736: (
737: p_api_version IN NUMBER,
738: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
739: p_validation_level IN NUMBER,
740: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
741: x_return_status OUT VARCHAR2,
742: x_msg_count OUT NUMBER,

Line 740: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

736: (
737: p_api_version IN NUMBER,
738: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
739: p_validation_level IN NUMBER,
740: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
741: x_return_status OUT VARCHAR2,
742: x_msg_count OUT NUMBER,
743: x_msg_data OUT VARCHAR2,
744: p_contracts_interface_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 744: p_contracts_interface_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

740: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
741: x_return_status OUT VARCHAR2,
742: x_msg_count OUT NUMBER,
743: x_msg_data OUT VARCHAR2,
744: p_contracts_interface_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
745: p_cp_service_transaction_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
746: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
747: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
748: p_ar_trx_type IN CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 745: p_cp_service_transaction_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

741: x_return_status OUT VARCHAR2,
742: x_msg_count OUT NUMBER,
743: x_msg_data OUT VARCHAR2,
744: p_contracts_interface_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
745: p_cp_service_transaction_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
746: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
747: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
748: p_ar_trx_type IN CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
749: p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 746: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

742: x_msg_count OUT NUMBER,
743: x_msg_data OUT VARCHAR2,
744: p_contracts_interface_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
745: p_cp_service_transaction_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
746: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
747: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
748: p_ar_trx_type IN CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
749: p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
750: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 747: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

743: x_msg_data OUT VARCHAR2,
744: p_contracts_interface_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
745: p_cp_service_transaction_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
746: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
747: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
748: p_ar_trx_type IN CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
749: p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
750: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
751: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 748: p_ar_trx_type IN CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

744: p_contracts_interface_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
745: p_cp_service_transaction_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
746: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
747: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
748: p_ar_trx_type IN CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
749: p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
750: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
751: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
752: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 749: p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

745: p_cp_service_transaction_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
746: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
747: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
748: p_ar_trx_type IN CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
749: p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
750: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
751: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
752: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
753: p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 750: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

746: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
747: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
748: p_ar_trx_type IN CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
749: p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
750: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
751: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
752: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
753: p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
754: p_reason_comments IN CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 751: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

747: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
748: p_ar_trx_type IN CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
749: p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
750: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
751: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
752: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
753: p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
754: p_reason_comments IN CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
755: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 752: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

748: p_ar_trx_type IN CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
749: p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
750: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
751: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
752: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
753: p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
754: p_reason_comments IN CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
755: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
756: p_cp_quantity IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 753: p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

749: p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
750: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
751: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
752: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
753: p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
754: p_reason_comments IN CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
755: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
756: p_cp_quantity IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
757: p_concurrent_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 754: p_reason_comments IN CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

750: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
751: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
752: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
753: p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
754: p_reason_comments IN CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
755: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
756: p_cp_quantity IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
757: p_concurrent_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
758: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 755: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

751: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
752: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
753: p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
754: p_reason_comments IN CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
755: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
756: p_cp_quantity IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
757: p_concurrent_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
758: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
759: p_creation_date IN CS_CONT_BILL_IFACE.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 756: p_cp_quantity IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

752: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
753: p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
754: p_reason_comments IN CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
755: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
756: p_cp_quantity IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
757: p_concurrent_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
758: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
759: p_creation_date IN CS_CONT_BILL_IFACE.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
760: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 757: p_concurrent_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

753: p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
754: p_reason_comments IN CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
755: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
756: p_cp_quantity IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
757: p_concurrent_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
758: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
759: p_creation_date IN CS_CONT_BILL_IFACE.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
760: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
761: x_object_version_number OUT NUMBER) IS

Line 758: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

754: p_reason_comments IN CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
755: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
756: p_cp_quantity IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
757: p_concurrent_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
758: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
759: p_creation_date IN CS_CONT_BILL_IFACE.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
760: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
761: x_object_version_number OUT NUMBER) IS
762: l_api_name CONSTANT VARCHAR2(30) := 'update_row';

Line 759: p_creation_date IN CS_CONT_BILL_IFACE.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

755: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
756: p_cp_quantity IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
757: p_concurrent_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
758: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
759: p_creation_date IN CS_CONT_BILL_IFACE.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
760: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
761: x_object_version_number OUT NUMBER) IS
762: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
763: l_api_version CONSTANT NUMBER := 1;

Line 760: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

756: p_cp_quantity IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
757: p_concurrent_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
758: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
759: p_creation_date IN CS_CONT_BILL_IFACE.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
760: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
761: x_object_version_number OUT NUMBER) IS
762: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
763: l_api_version CONSTANT NUMBER := 1;
764: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 767: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

763: l_api_version CONSTANT NUMBER := 1;
764: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
765: l_contintf_rec ContIntf_Val_Rec_Type;
766: BEGIN
767: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
768: G_PKG_NAME,
769: l_api_version,
770: p_api_version,
771: p_init_msg_list,

Line 807: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);

803: x_msg_data,
804: l_contintf_rec,
805: x_object_version_number
806: );
807: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
808: EXCEPTION
809: WHEN FND_API.G_EXC_ERROR THEN
810: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
811: (

Line 810: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS

806: );
807: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
808: EXCEPTION
809: WHEN FND_API.G_EXC_ERROR THEN
810: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
811: (
812: l_api_name,
813: G_PKG_NAME,
814: 'FND_API.G_RET_STS_ERROR',

Line 821: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

817: '_Pvt'
818: );
819: APP_EXCEPTION.RAISE_EXCEPTION;
820: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
821: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
822: (
823: l_api_name,
824: G_PKG_NAME,
825: 'FND_API.G_RET_STS_UNEXP_ERROR',

Line 831: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN

827: x_msg_data,
828: '_Pvt'
829: );
830: APP_EXCEPTION.RAISE_EXCEPTION;
831: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
832: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
833: (
834: l_api_name,
835: G_PKG_NAME,

Line 832: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

828: '_Pvt'
829: );
830: APP_EXCEPTION.RAISE_EXCEPTION;
831: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
832: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
833: (
834: l_api_name,
835: G_PKG_NAME,
836: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

Line 836: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

832: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
833: (
834: l_api_name,
835: G_PKG_NAME,
836: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
837: x_msg_count,
838: x_msg_data,
839: '_Pvt'
840: );

Line 846: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

842: END update_row;
843: Procedure delete_row
844: (
845: p_api_version IN NUMBER,
846: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
847: p_validation_level IN NUMBER,
848: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
849: x_return_status OUT VARCHAR2,
850: x_msg_count OUT NUMBER,

Line 848: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

844: (
845: p_api_version IN NUMBER,
846: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
847: p_validation_level IN NUMBER,
848: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
849: x_return_status OUT VARCHAR2,
850: x_msg_count OUT NUMBER,
851: x_msg_data OUT VARCHAR2,
852: p_contracts_interface_id IN NUMBER) IS

Line 857: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

853: l_api_name CONSTANT VARCHAR2(30) := 'delete_row';
854: l_api_version CONSTANT NUMBER := 1;
855: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
856: BEGIN
857: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
858: G_PKG_NAME,
859: l_api_version,
860: p_api_version,
861: p_init_msg_list,

Line 873: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);

869: DELETE FROM CS_CONT_BILL_IFACE
870: WHERE
871: CONTRACTS_INTERFACE_ID = p_contracts_interface_id
872: ;
873: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
874: EXCEPTION
875: WHEN FND_API.G_EXC_ERROR THEN
876: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
877: (

Line 876: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS

872: ;
873: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
874: EXCEPTION
875: WHEN FND_API.G_EXC_ERROR THEN
876: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
877: (
878: l_api_name,
879: G_PKG_NAME,
880: 'FND_API.G_RET_STS_ERROR',

Line 887: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

883: '_Pvt'
884: );
885: APP_EXCEPTION.RAISE_EXCEPTION;
886: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
887: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
888: (
889: l_api_name,
890: G_PKG_NAME,
891: 'FND_API.G_RET_STS_UNEXP_ERROR',

Line 897: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN

893: x_msg_data,
894: '_Pvt'
895: );
896: APP_EXCEPTION.RAISE_EXCEPTION;
897: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
898: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
899: (
900: l_api_name,
901: G_PKG_NAME,

Line 898: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

894: '_Pvt'
895: );
896: APP_EXCEPTION.RAISE_EXCEPTION;
897: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
898: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
899: (
900: l_api_name,
901: G_PKG_NAME,
902: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

Line 902: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

898: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
899: (
900: l_api_name,
901: G_PKG_NAME,
902: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
903: x_msg_count,
904: x_msg_data,
905: '_Pvt'
906: );

Line 912: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

908: END delete_row;
909: PROCEDURE validate_row
910: (
911: p_api_version IN NUMBER,
912: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
913: p_validation_level IN NUMBER,
914: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
915: x_return_status OUT VARCHAR2,
916: x_msg_count OUT NUMBER,

Line 914: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

910: (
911: p_api_version IN NUMBER,
912: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
913: p_validation_level IN NUMBER,
914: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
915: x_return_status OUT VARCHAR2,
916: x_msg_count OUT NUMBER,
917: x_msg_data OUT VARCHAR2,
918: p_contintf_val_rec IN ContIntf_Val_Rec_Type := G_MISS_CONTINTF_VAL_REC) IS

Line 925: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

921: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
922: l_contintf_rec ContIntf_Rec_Type;
923: l_def_contintf_rec ContIntf_Rec_Type;
924: BEGIN
925: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
926: G_PKG_NAME,
927: l_api_version,
928: p_api_version,
929: p_init_msg_list,

Line 959: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);

955: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
956: RAISE FND_API.G_EXC_ERROR;
957: END IF;
958: END IF;
959: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
960: EXCEPTION
961: WHEN FND_API.G_EXC_ERROR THEN
962: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
963: (

Line 962: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS

958: END IF;
959: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
960: EXCEPTION
961: WHEN FND_API.G_EXC_ERROR THEN
962: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
963: (
964: l_api_name,
965: G_PKG_NAME,
966: 'FND_API.G_RET_STS_ERROR',

Line 973: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

969: '_Pvt'
970: );
971: APP_EXCEPTION.RAISE_EXCEPTION;
972: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
973: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
974: (
975: l_api_name,
976: G_PKG_NAME,
977: 'FND_API.G_RET_STS_UNEXP_ERROR',

Line 983: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN

979: x_msg_data,
980: '_Pvt'
981: );
982: APP_EXCEPTION.RAISE_EXCEPTION;
983: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
984: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
985: (
986: l_api_name,
987: G_PKG_NAME,

Line 984: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

980: '_Pvt'
981: );
982: APP_EXCEPTION.RAISE_EXCEPTION;
983: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
984: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
985: (
986: l_api_name,
987: G_PKG_NAME,
988: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

Line 988: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

984: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
985: (
986: l_api_name,
987: G_PKG_NAME,
988: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
989: x_msg_count,
990: x_msg_data,
991: '_Pvt'
992: );

Line 998: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

994: END validate_row;
995: PROCEDURE validate_row
996: (
997: p_api_version IN NUMBER,
998: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
999: p_validation_level IN NUMBER,
1000: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1001: x_return_status OUT VARCHAR2,
1002: x_msg_count OUT NUMBER,

Line 1000: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

996: (
997: p_api_version IN NUMBER,
998: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
999: p_validation_level IN NUMBER,
1000: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1001: x_return_status OUT VARCHAR2,
1002: x_msg_count OUT NUMBER,
1003: x_msg_data OUT VARCHAR2,
1004: p_contracts_interface_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1004: p_contracts_interface_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1000: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1001: x_return_status OUT VARCHAR2,
1002: x_msg_count OUT NUMBER,
1003: x_msg_data OUT VARCHAR2,
1004: p_contracts_interface_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1005: p_cp_service_transaction_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1006: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1007: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1008: p_ar_trx_type IN CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1005: p_cp_service_transaction_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1001: x_return_status OUT VARCHAR2,
1002: x_msg_count OUT NUMBER,
1003: x_msg_data OUT VARCHAR2,
1004: p_contracts_interface_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1005: p_cp_service_transaction_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1006: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1007: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1008: p_ar_trx_type IN CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1009: p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1006: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1002: x_msg_count OUT NUMBER,
1003: x_msg_data OUT VARCHAR2,
1004: p_contracts_interface_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1005: p_cp_service_transaction_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1006: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1007: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1008: p_ar_trx_type IN CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1009: p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1010: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1007: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1003: x_msg_data OUT VARCHAR2,
1004: p_contracts_interface_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1005: p_cp_service_transaction_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1006: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1007: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1008: p_ar_trx_type IN CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1009: p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1010: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1011: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1008: p_ar_trx_type IN CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1004: p_contracts_interface_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1005: p_cp_service_transaction_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1006: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1007: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1008: p_ar_trx_type IN CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1009: p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1010: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1011: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1012: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1009: p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1005: p_cp_service_transaction_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1006: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1007: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1008: p_ar_trx_type IN CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1009: p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1010: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1011: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1012: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1013: p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1010: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1006: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1007: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1008: p_ar_trx_type IN CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1009: p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1010: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1011: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1012: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1013: p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1014: p_reason_comments IN CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1011: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1007: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1008: p_ar_trx_type IN CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1009: p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1010: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1011: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1012: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1013: p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1014: p_reason_comments IN CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1015: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1012: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1008: p_ar_trx_type IN CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1009: p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1010: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1011: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1012: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1013: p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1014: p_reason_comments IN CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1015: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1016: p_cp_quantity IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1013: p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1009: p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1010: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1011: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1012: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1013: p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1014: p_reason_comments IN CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1015: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1016: p_cp_quantity IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1017: p_concurrent_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1014: p_reason_comments IN CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1010: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1011: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1012: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1013: p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1014: p_reason_comments IN CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1015: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1016: p_cp_quantity IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1017: p_concurrent_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1018: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1015: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1011: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1012: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1013: p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1014: p_reason_comments IN CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1015: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1016: p_cp_quantity IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1017: p_concurrent_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1018: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1019: p_creation_date IN CS_CONT_BILL_IFACE.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1016: p_cp_quantity IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1012: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1013: p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1014: p_reason_comments IN CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1015: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1016: p_cp_quantity IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1017: p_concurrent_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1018: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1019: p_creation_date IN CS_CONT_BILL_IFACE.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1020: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS

Line 1017: p_concurrent_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1013: p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1014: p_reason_comments IN CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1015: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1016: p_cp_quantity IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1017: p_concurrent_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1018: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1019: p_creation_date IN CS_CONT_BILL_IFACE.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1020: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1021: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';

Line 1018: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1014: p_reason_comments IN CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1015: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1016: p_cp_quantity IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1017: p_concurrent_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1018: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1019: p_creation_date IN CS_CONT_BILL_IFACE.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1020: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1021: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1022: l_api_version CONSTANT NUMBER := 1;

Line 1019: p_creation_date IN CS_CONT_BILL_IFACE.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1015: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1016: p_cp_quantity IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1017: p_concurrent_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1018: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1019: p_creation_date IN CS_CONT_BILL_IFACE.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1020: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1021: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1022: l_api_version CONSTANT NUMBER := 1;
1023: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 1020: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS

1016: p_cp_quantity IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1017: p_concurrent_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1018: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1019: p_creation_date IN CS_CONT_BILL_IFACE.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1020: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1021: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1022: l_api_version CONSTANT NUMBER := 1;
1023: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1024: l_contintf_rec ContIntf_Val_Rec_Type;

Line 1026: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

1022: l_api_version CONSTANT NUMBER := 1;
1023: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1024: l_contintf_rec ContIntf_Val_Rec_Type;
1025: BEGIN
1026: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1027: G_PKG_NAME,
1028: l_api_version,
1029: p_api_version,
1030: p_init_msg_list,

Line 1065: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);

1061: x_msg_count,
1062: x_msg_data,
1063: l_contintf_rec
1064: );
1065: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1066: EXCEPTION
1067: WHEN FND_API.G_EXC_ERROR THEN
1068: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1069: (

Line 1068: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1064: );
1065: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1066: EXCEPTION
1067: WHEN FND_API.G_EXC_ERROR THEN
1068: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1069: (
1070: l_api_name,
1071: G_PKG_NAME,
1072: 'FND_API.G_RET_STS_ERROR',

Line 1079: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1075: '_Pvt'
1076: );
1077: APP_EXCEPTION.RAISE_EXCEPTION;
1078: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1079: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1080: (
1081: l_api_name,
1082: G_PKG_NAME,
1083: 'FND_API.G_RET_STS_UNEXP_ERROR',

Line 1089: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN

1085: x_msg_data,
1086: '_Pvt'
1087: );
1088: APP_EXCEPTION.RAISE_EXCEPTION;
1089: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1090: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1091: (
1092: l_api_name,
1093: G_PKG_NAME,

Line 1090: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1086: '_Pvt'
1087: );
1088: APP_EXCEPTION.RAISE_EXCEPTION;
1089: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1090: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1091: (
1092: l_api_name,
1093: G_PKG_NAME,
1094: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

Line 1094: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

1090: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1091: (
1092: l_api_name,
1093: G_PKG_NAME,
1094: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1095: x_msg_count,
1096: x_msg_data,
1097: '_Pvt'
1098: );