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.OKS_EXTWAR_UTIL_PUB dependencies on OKC_API

Line 21: l_return_status Varchar2(1) := OKC_API.G_RET_STS_SUCCESS;

17: x_warranty_tbl OUT NOCOPY War_tbl
18: )
19: IS
20:
21: l_return_status Varchar2(1) := OKC_API.G_RET_STS_SUCCESS;
22: l_api_name CONSTANT VARCHAR2(30) := 'Get_Warranty_Info';
23: BEGIN
24:
25: l_return_status := OKC_API.START_ACTIVITY(l_api_name

Line 25: l_return_status := OKC_API.START_ACTIVITY(l_api_name

21: l_return_status Varchar2(1) := OKC_API.G_RET_STS_SUCCESS;
22: l_api_name CONSTANT VARCHAR2(30) := 'Get_Warranty_Info';
23: BEGIN
24:
25: l_return_status := OKC_API.START_ACTIVITY(l_api_name
26: ,p_init_msg_list
27: ,'_PUB'
28: ,x_return_status
29: );

Line 30: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

26: ,p_init_msg_list
27: ,'_PUB'
28: ,x_return_status
29: );
30: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
31: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
32: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
33: RAISE OKC_API.G_EXCEPTION_ERROR;
34: END IF;

Line 31: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

27: ,'_PUB'
28: ,x_return_status
29: );
30: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
31: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
32: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
33: RAISE OKC_API.G_EXCEPTION_ERROR;
34: END IF;
35:

Line 32: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

28: ,x_return_status
29: );
30: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
31: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
32: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
33: RAISE OKC_API.G_EXCEPTION_ERROR;
34: END IF;
35:
36:

Line 33: RAISE OKC_API.G_EXCEPTION_ERROR;

29: );
30: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
31: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
32: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
33: RAISE OKC_API.G_EXCEPTION_ERROR;
34: END IF;
35:
36:
37: OKS_EXTWAR_UTIL_PVT.Get_Warranty_Info

Line 44: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

40: ,p_date => p_date
41: ,x_return_status => l_return_status
42: ,x_warranty_tbl => x_warranty_tbl);
43:
44: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
45: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
46: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
47: RAISE OKC_API.G_EXCEPTION_ERROR;
48: END IF;

Line 45: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

41: ,x_return_status => l_return_status
42: ,x_warranty_tbl => x_warranty_tbl);
43:
44: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
45: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
46: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
47: RAISE OKC_API.G_EXCEPTION_ERROR;
48: END IF;
49:

Line 46: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

42: ,x_warranty_tbl => x_warranty_tbl);
43:
44: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
45: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
46: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
47: RAISE OKC_API.G_EXCEPTION_ERROR;
48: END IF;
49:
50: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

Line 47: RAISE OKC_API.G_EXCEPTION_ERROR;

43:
44: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
45: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
46: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
47: RAISE OKC_API.G_EXCEPTION_ERROR;
48: END IF;
49:
50: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
51:

Line 50: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

46: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
47: RAISE OKC_API.G_EXCEPTION_ERROR;
48: END IF;
49:
50: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
51:
52: x_return_status := l_return_status;
53:
54: EXCEPTION

Line 55: WHEN OKC_API.G_EXCEPTION_ERROR THEN

51:
52: x_return_status := l_return_status;
53:
54: EXCEPTION
55: WHEN OKC_API.G_EXCEPTION_ERROR THEN
56: x_return_status := OKC_API.HANDLE_EXCEPTIONS
57: (l_api_name,
58: G_PKG_NAME,
59: 'OKC_API.G_RET_STS_ERROR',

Line 56: x_return_status := OKC_API.HANDLE_EXCEPTIONS

52: x_return_status := l_return_status;
53:
54: EXCEPTION
55: WHEN OKC_API.G_EXCEPTION_ERROR THEN
56: x_return_status := OKC_API.HANDLE_EXCEPTIONS
57: (l_api_name,
58: G_PKG_NAME,
59: 'OKC_API.G_RET_STS_ERROR',
60: x_msg_count,

Line 59: 'OKC_API.G_RET_STS_ERROR',

55: WHEN OKC_API.G_EXCEPTION_ERROR THEN
56: x_return_status := OKC_API.HANDLE_EXCEPTIONS
57: (l_api_name,
58: G_PKG_NAME,
59: 'OKC_API.G_RET_STS_ERROR',
60: x_msg_count,
61: x_msg_data,
62: '_PUB');
63: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 63: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

59: 'OKC_API.G_RET_STS_ERROR',
60: x_msg_count,
61: x_msg_data,
62: '_PUB');
63: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
64: x_return_status := OKC_API.HANDLE_EXCEPTIONS
65: (l_api_name,
66: G_PKG_NAME,
67: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 64: x_return_status := OKC_API.HANDLE_EXCEPTIONS

60: x_msg_count,
61: x_msg_data,
62: '_PUB');
63: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
64: x_return_status := OKC_API.HANDLE_EXCEPTIONS
65: (l_api_name,
66: G_PKG_NAME,
67: 'OKC_API.G_RET_STS_UNEXP_ERROR',
68: x_msg_count,

Line 67: 'OKC_API.G_RET_STS_UNEXP_ERROR',

63: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
64: x_return_status := OKC_API.HANDLE_EXCEPTIONS
65: (l_api_name,
66: G_PKG_NAME,
67: 'OKC_API.G_RET_STS_UNEXP_ERROR',
68: x_msg_count,
69: x_msg_data,
70: '_PUB');
71: WHEN OTHERS THEN

Line 72: x_return_status := OKC_API.HANDLE_EXCEPTIONS

68: x_msg_count,
69: x_msg_data,
70: '_PUB');
71: WHEN OTHERS THEN
72: x_return_status := OKC_API.HANDLE_EXCEPTIONS
73: (l_api_name,
74: G_PKG_NAME,
75: 'OTHERS',
76: x_msg_count,

Line 94: l_return_status Varchar2(1) := OKC_API.G_RET_STS_SUCCESS;

90: x_msg_data OUT NOCOPY Varchar2
91: )
92: IS
93:
94: l_return_status Varchar2(1) := OKC_API.G_RET_STS_SUCCESS;
95: l_api_name CONSTANT VARCHAR2(30) := 'Update_Hdr_Amount';
96: l_api_version Number := 1.0;
97:
98: --Contract Header

Line 112: l_return_status := OKC_API.START_ACTIVITY(l_api_name

108: l_hdr_amount Number;
109:
110: BEGIN
111:
112: l_return_status := OKC_API.START_ACTIVITY(l_api_name
113: ,p_init_msg_list
114: ,'_PUB'
115: ,x_return_status
116: );

Line 117: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

113: ,p_init_msg_list
114: ,'_PUB'
115: ,x_return_status
116: );
117: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
118: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
119: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
120: RAISE OKC_API.G_EXCEPTION_ERROR;
121: END IF;

Line 118: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

114: ,'_PUB'
115: ,x_return_status
116: );
117: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
118: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
119: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
120: RAISE OKC_API.G_EXCEPTION_ERROR;
121: END IF;
122:

Line 119: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

115: ,x_return_status
116: );
117: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
118: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
119: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
120: RAISE OKC_API.G_EXCEPTION_ERROR;
121: END IF;
122:
123: Open l_line_csr;

Line 120: RAISE OKC_API.G_EXCEPTION_ERROR;

116: );
117: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
118: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
119: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
120: RAISE OKC_API.G_EXCEPTION_ERROR;
121: END IF;
122:
123: Open l_line_csr;
124: Fetch l_line_csr into l_hdr_amount;

Line 142: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

138: p_chrv_tbl => l_chrv_tbl_in,
139: x_chrv_tbl => l_chrv_tbl_out
140: );
141:
142: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
143: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
144: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
145: RAISE OKC_API.G_EXCEPTION_ERROR;
146: END IF;

Line 143: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

139: x_chrv_tbl => l_chrv_tbl_out
140: );
141:
142: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
143: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
144: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
145: RAISE OKC_API.G_EXCEPTION_ERROR;
146: END IF;
147:

Line 144: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

140: );
141:
142: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
143: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
144: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
145: RAISE OKC_API.G_EXCEPTION_ERROR;
146: END IF;
147:
148: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

Line 145: RAISE OKC_API.G_EXCEPTION_ERROR;

141:
142: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
143: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
144: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
145: RAISE OKC_API.G_EXCEPTION_ERROR;
146: END IF;
147:
148: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
149:

Line 148: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

144: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
145: RAISE OKC_API.G_EXCEPTION_ERROR;
146: END IF;
147:
148: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
149:
150: x_return_status := l_return_status;
151:
152: EXCEPTION

Line 153: WHEN OKC_API.G_EXCEPTION_ERROR THEN

149:
150: x_return_status := l_return_status;
151:
152: EXCEPTION
153: WHEN OKC_API.G_EXCEPTION_ERROR THEN
154: x_return_status := OKC_API.HANDLE_EXCEPTIONS
155: (l_api_name,
156: G_PKG_NAME,
157: 'OKC_API.G_RET_STS_ERROR',

Line 154: x_return_status := OKC_API.HANDLE_EXCEPTIONS

150: x_return_status := l_return_status;
151:
152: EXCEPTION
153: WHEN OKC_API.G_EXCEPTION_ERROR THEN
154: x_return_status := OKC_API.HANDLE_EXCEPTIONS
155: (l_api_name,
156: G_PKG_NAME,
157: 'OKC_API.G_RET_STS_ERROR',
158: x_msg_count,

Line 157: 'OKC_API.G_RET_STS_ERROR',

153: WHEN OKC_API.G_EXCEPTION_ERROR THEN
154: x_return_status := OKC_API.HANDLE_EXCEPTIONS
155: (l_api_name,
156: G_PKG_NAME,
157: 'OKC_API.G_RET_STS_ERROR',
158: x_msg_count,
159: x_msg_data,
160: '_PUB');
161: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 161: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

157: 'OKC_API.G_RET_STS_ERROR',
158: x_msg_count,
159: x_msg_data,
160: '_PUB');
161: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
162: x_return_status := OKC_API.HANDLE_EXCEPTIONS
163: (l_api_name,
164: G_PKG_NAME,
165: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 162: x_return_status := OKC_API.HANDLE_EXCEPTIONS

158: x_msg_count,
159: x_msg_data,
160: '_PUB');
161: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
162: x_return_status := OKC_API.HANDLE_EXCEPTIONS
163: (l_api_name,
164: G_PKG_NAME,
165: 'OKC_API.G_RET_STS_UNEXP_ERROR',
166: x_msg_count,

Line 165: 'OKC_API.G_RET_STS_UNEXP_ERROR',

161: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
162: x_return_status := OKC_API.HANDLE_EXCEPTIONS
163: (l_api_name,
164: G_PKG_NAME,
165: 'OKC_API.G_RET_STS_UNEXP_ERROR',
166: x_msg_count,
167: x_msg_data,
168: '_PUB');
169: WHEN OTHERS THEN

Line 170: x_return_status := OKC_API.HANDLE_EXCEPTIONS

166: x_msg_count,
167: x_msg_data,
168: '_PUB');
169: WHEN OTHERS THEN
170: x_return_status := OKC_API.HANDLE_EXCEPTIONS
171: (l_api_name,
172: G_PKG_NAME,
173: 'OTHERS',
174: x_msg_count,

Line 281: IF (p_party_id = OKC_API.G_MISS_NUM OR p_party_id IS NULL) THEN

277: BEGIN
278:
279: fnd_msg_pub.initialize;
280:
281: IF (p_party_id = OKC_API.G_MISS_NUM OR p_party_id IS NULL) THEN
282: null;
283: -- Handle missing party ID
284: END IF;
285:

Line 304: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

300: x_msg_count => l_msg_count, -- OUT
301: x_msg_data => l_msg_data, -- OUT
302: x_terrresource_tbl => l_terrresource_tbl); -- OUT
303:
304: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
305: -- Handle error from territory API
306: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
307: null;
308: END IF;

Line 306: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

302: x_terrresource_tbl => l_terrresource_tbl); -- OUT
303:
304: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
305: -- Handle error from territory API
306: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
307: null;
308: END IF;
309:
310: ----dbms_output.put_line('count res: '||l_terrresource_tbl.count);

Line 317: OKC_API.set_message

313: ----dbms_output.put_line('v_msg_data: '||l_msg_data);
314:
315: IF l_terrresource_tbl.count = 0 THEN
316:
317: OKC_API.set_message
318: (
319: G_APP_NAME,
320: G_UNEXPECTED_ERROR,
321: G_SQLCODE_TOKEN,

Line 331: OKC_API.set_message

327: null;
328: -- Handle no resource returned
329:
330: ELSIF l_terrresource_tbl.count > 1 THEN
331: OKC_API.set_message
332: (
333: G_APP_NAME,
334: G_UNEXPECTED_ERROR,
335: G_SQLCODE_TOKEN,

Line 360: l_return_status := OKC_API.G_RET_STS_SUCCESS;

356:
357: -- Set OUT parameters
358: x_winning_res_id := l_terrresource_tbl(0).resource_id;
359: x_winning_user_id := l_user_id;
360: l_return_status := OKC_API.G_RET_STS_SUCCESS;
361:
362: END IF;
363: x_return_status := l_return_status;
364:

Line 369: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

365: EXCEPTION
366:
367: WHEN OTHERS THEN
368:
369: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
370: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
371: p_data => x_msg_data);
372: END GET_OKS_RESOURCE;
373:

Line 451: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;

447: p_user_id IN NUMBER,
448: p_sales_group_id IN NUMBER
449: ) IS
450: l_api_version CONSTANT NUMBER := 1.0;
451: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
452: l_return_status VARCHAR2(1);
453: l_msg_count NUMBER;
454: l_msg_data VARCHAR2(2000);
455: l_msg_index_out NUMBER;

Line 474: l_return_status := OKC_API.G_RET_STS_SUCCESS;

470: l_cpl_id NUMBER;
471:
472: BEGIN
473:
474: l_return_status := OKC_API.G_RET_STS_SUCCESS;
475:
476: FOR C_GET_CPL_ID in GET_CPL_ID LOOP
477: l_cpl_id := C_GET_CPL_ID.id;
478: END LOOP;

Line 504: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

500: p_object1_id1 => p_salesrep_id,
501: p_sales_group_id => p_sales_group_id
502: );
503:
504: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
505: NOTIFY_SALESREP
506: (
507: p_user_id,
508: p_contract_header_id,

Line 559: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;

555: l_obj_id2 Varchar2(2000);
556: l_jtot_cd Varchar2(2000);
557:
558: l_api_version CONSTANT NUMBER := 1.0;
559: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
560: l_return_status VARCHAR2(1);
561: l_msg_count NUMBER;
562: l_msg_data VARCHAR2(2000);
563: l_msg_index_out NUMBER;

Line 605: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

601: );
602: if x_return_status = 'S' then
603: l_rgp_id := l_rgpv_tbl_out(1).id;
604: else
605: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
606: LOG_MESSAGES('okc_rule_pub.create_rule_group - EAB rule l_msg_data = ' || l_msg_data);
607: -- RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
608: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
609: LOG_MESSAGES('okc_rule_pub.create_rule_group - EAB rule l_msg_data = ' || l_msg_data);

Line 607: -- RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

603: l_rgp_id := l_rgpv_tbl_out(1).id;
604: else
605: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
606: LOG_MESSAGES('okc_rule_pub.create_rule_group - EAB rule l_msg_data = ' || l_msg_data);
607: -- RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
608: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
609: LOG_MESSAGES('okc_rule_pub.create_rule_group - EAB rule l_msg_data = ' || l_msg_data);
610: -- RAISE OKC_API.G_EXCEPTION_ERROR;
611: END IF;

Line 608: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

604: else
605: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
606: LOG_MESSAGES('okc_rule_pub.create_rule_group - EAB rule l_msg_data = ' || l_msg_data);
607: -- RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
608: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
609: LOG_MESSAGES('okc_rule_pub.create_rule_group - EAB rule l_msg_data = ' || l_msg_data);
610: -- RAISE OKC_API.G_EXCEPTION_ERROR;
611: END IF;
612:

Line 610: -- RAISE OKC_API.G_EXCEPTION_ERROR;

606: LOG_MESSAGES('okc_rule_pub.create_rule_group - EAB rule l_msg_data = ' || l_msg_data);
607: -- RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
608: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
609: LOG_MESSAGES('okc_rule_pub.create_rule_group - EAB rule l_msg_data = ' || l_msg_data);
610: -- RAISE OKC_API.G_EXCEPTION_ERROR;
611: END IF;
612:
613: end if;
614: End If;

Line 635: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

631: p_rulv_tbl => l_rulv_tbl_in,
632: x_rulv_tbl => l_rulv_tbl_out
633: );
634:
635: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
636: LOG_MESSAGES('okc_rule_pub.create_rule - EAB rule l_msg_data = ' || l_msg_data);
637: -- RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
638: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
639: LOG_MESSAGES('okc_rule_pub.create_rule - EAB rule l_msg_data = ' || l_msg_data);

Line 637: -- RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

633: );
634:
635: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
636: LOG_MESSAGES('okc_rule_pub.create_rule - EAB rule l_msg_data = ' || l_msg_data);
637: -- RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
638: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
639: LOG_MESSAGES('okc_rule_pub.create_rule - EAB rule l_msg_data = ' || l_msg_data);
640: -- RAISE OKC_API.G_EXCEPTION_ERROR;
641: END IF;

Line 638: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

634:
635: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
636: LOG_MESSAGES('okc_rule_pub.create_rule - EAB rule l_msg_data = ' || l_msg_data);
637: -- RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
638: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
639: LOG_MESSAGES('okc_rule_pub.create_rule - EAB rule l_msg_data = ' || l_msg_data);
640: -- RAISE OKC_API.G_EXCEPTION_ERROR;
641: END IF;
642:

Line 640: -- RAISE OKC_API.G_EXCEPTION_ERROR;

636: LOG_MESSAGES('okc_rule_pub.create_rule - EAB rule l_msg_data = ' || l_msg_data);
637: -- RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
638: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
639: LOG_MESSAGES('okc_rule_pub.create_rule - EAB rule l_msg_data = ' || l_msg_data);
640: -- RAISE OKC_API.G_EXCEPTION_ERROR;
641: END IF;
642:
643: */
644: l_ctcv_tbl_in(1).id := p_contact_id;

Line 654: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

650: x_msg_count => l_msg_count,
651: x_msg_data => l_msg_data,
652: p_ctcv_tbl => l_ctcv_tbl_in
653: );
654: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
655: LOG_MESSAGES('okc_contract_party_pub.delete_contact l_msg_data = ' || l_msg_data);
656: -- RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
657: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
658: LOG_MESSAGES('okc_contract_party_pub.delete_contact l_msg_data = ' || l_msg_data);

Line 656: -- RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

652: p_ctcv_tbl => l_ctcv_tbl_in
653: );
654: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
655: LOG_MESSAGES('okc_contract_party_pub.delete_contact l_msg_data = ' || l_msg_data);
656: -- RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
657: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
658: LOG_MESSAGES('okc_contract_party_pub.delete_contact l_msg_data = ' || l_msg_data);
659: -- RAISE OKC_API.G_EXCEPTION_ERROR;
660: END IF;

Line 657: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

653: );
654: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
655: LOG_MESSAGES('okc_contract_party_pub.delete_contact l_msg_data = ' || l_msg_data);
656: -- RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
657: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
658: LOG_MESSAGES('okc_contract_party_pub.delete_contact l_msg_data = ' || l_msg_data);
659: -- RAISE OKC_API.G_EXCEPTION_ERROR;
660: END IF;
661: x_return_status := l_return_status;

Line 659: -- RAISE OKC_API.G_EXCEPTION_ERROR;

655: LOG_MESSAGES('okc_contract_party_pub.delete_contact l_msg_data = ' || l_msg_data);
656: -- RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
657: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
658: LOG_MESSAGES('okc_contract_party_pub.delete_contact l_msg_data = ' || l_msg_data);
659: -- RAISE OKC_API.G_EXCEPTION_ERROR;
660: END IF;
661: x_return_status := l_return_status;
662: END DELETE_CONTACT;
663:

Line 673: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;

669: p_object1_id1 IN NUMBER,
670: p_sales_group_id IN NUMBER
671: ) IS
672: l_api_version CONSTANT NUMBER := 1.0;
673: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
674: l_return_status VARCHAR2(1);
675: l_msg_count NUMBER;
676: l_msg_data VARCHAR2(2000);
677: l_msg_index_out NUMBER;

Line 689: l_ctcv_tbl_in(1).object_version_number := OKC_API.G_MISS_NUM;

685: l_ctcv_tbl_in(1).dnz_chr_id := p_dnz_chr_id;
686: l_ctcv_tbl_in(1).OBJECT1_ID1 := p_object1_id1;
687: l_ctcv_tbl_in(1).object1_id2 := '#';
688: l_ctcv_tbl_in(1).JTOT_OBJECT1_CODE := p_jtot_object1_code;
689: l_ctcv_tbl_in(1).object_version_number := OKC_API.G_MISS_NUM;
690: l_ctcv_tbl_in(1).created_by := OKC_API.G_MISS_NUM;
691: l_ctcv_tbl_in(1).creation_date := SYSDATE;
692: l_ctcv_tbl_in(1).last_updated_by := OKC_API.G_MISS_NUM;
693: l_ctcv_tbl_in(1).last_update_date := SYSDATE;

Line 690: l_ctcv_tbl_in(1).created_by := OKC_API.G_MISS_NUM;

686: l_ctcv_tbl_in(1).OBJECT1_ID1 := p_object1_id1;
687: l_ctcv_tbl_in(1).object1_id2 := '#';
688: l_ctcv_tbl_in(1).JTOT_OBJECT1_CODE := p_jtot_object1_code;
689: l_ctcv_tbl_in(1).object_version_number := OKC_API.G_MISS_NUM;
690: l_ctcv_tbl_in(1).created_by := OKC_API.G_MISS_NUM;
691: l_ctcv_tbl_in(1).creation_date := SYSDATE;
692: l_ctcv_tbl_in(1).last_updated_by := OKC_API.G_MISS_NUM;
693: l_ctcv_tbl_in(1).last_update_date := SYSDATE;
694: l_ctcv_tbl_in(1).last_update_login := OKC_API.G_MISS_NUM;

Line 692: l_ctcv_tbl_in(1).last_updated_by := OKC_API.G_MISS_NUM;

688: l_ctcv_tbl_in(1).JTOT_OBJECT1_CODE := p_jtot_object1_code;
689: l_ctcv_tbl_in(1).object_version_number := OKC_API.G_MISS_NUM;
690: l_ctcv_tbl_in(1).created_by := OKC_API.G_MISS_NUM;
691: l_ctcv_tbl_in(1).creation_date := SYSDATE;
692: l_ctcv_tbl_in(1).last_updated_by := OKC_API.G_MISS_NUM;
693: l_ctcv_tbl_in(1).last_update_date := SYSDATE;
694: l_ctcv_tbl_in(1).last_update_login := OKC_API.G_MISS_NUM;
695: l_ctcv_tbl_in(1).sales_group_id := p_sales_group_id;
696:

Line 694: l_ctcv_tbl_in(1).last_update_login := OKC_API.G_MISS_NUM;

690: l_ctcv_tbl_in(1).created_by := OKC_API.G_MISS_NUM;
691: l_ctcv_tbl_in(1).creation_date := SYSDATE;
692: l_ctcv_tbl_in(1).last_updated_by := OKC_API.G_MISS_NUM;
693: l_ctcv_tbl_in(1).last_update_date := SYSDATE;
694: l_ctcv_tbl_in(1).last_update_login := OKC_API.G_MISS_NUM;
695: l_ctcv_tbl_in(1).sales_group_id := p_sales_group_id;
696:
697: okc_contract_party_pub.create_contact (
698: p_api_version => l_api_version,

Line 707: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

703: p_ctcv_tbl => l_ctcv_tbl_in,
704: x_ctcv_tbl => l_ctcv_tbl_out
705: );
706:
707: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
708: LOG_MESSAGES('okc_contract_party_pub.delete_contact l_msg_data = ' || l_msg_data);
709: -- RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
710: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
711: LOG_MESSAGES('okc_contract_party_pub.delete_contact l_msg_data = ' || l_msg_data);

Line 709: -- RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

705: );
706:
707: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
708: LOG_MESSAGES('okc_contract_party_pub.delete_contact l_msg_data = ' || l_msg_data);
709: -- RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
710: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
711: LOG_MESSAGES('okc_contract_party_pub.delete_contact l_msg_data = ' || l_msg_data);
712: -- RAISE OKC_API.G_EXCEPTION_ERROR;
713: END IF;

Line 710: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

706:
707: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
708: LOG_MESSAGES('okc_contract_party_pub.delete_contact l_msg_data = ' || l_msg_data);
709: -- RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
710: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
711: LOG_MESSAGES('okc_contract_party_pub.delete_contact l_msg_data = ' || l_msg_data);
712: -- RAISE OKC_API.G_EXCEPTION_ERROR;
713: END IF;
714:

Line 712: -- RAISE OKC_API.G_EXCEPTION_ERROR;

708: LOG_MESSAGES('okc_contract_party_pub.delete_contact l_msg_data = ' || l_msg_data);
709: -- RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
710: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
711: LOG_MESSAGES('okc_contract_party_pub.delete_contact l_msg_data = ' || l_msg_data);
712: -- RAISE OKC_API.G_EXCEPTION_ERROR;
713: END IF;
714:
715: x_return_status := l_return_status;
716: END CREATE_CONTACT;

Line 851: x_return_status := OKC_API.G_RET_STS_SUCCESS;

847:
848: PROCEDURE SET_MSG (x_return_Status OUT Nocopy Varchar2, p_msg Varchar2)
849: Is
850: Begin
851: x_return_status := OKC_API.G_RET_STS_SUCCESS;
852:
853: OKC_API.set_message(p_app_name => g_app_name,
854: p_msg_name => 'CONTRACTS RE-ASSIGNED'
855: );

Line 853: OKC_API.set_message(p_app_name => g_app_name,

849: Is
850: Begin
851: x_return_status := OKC_API.G_RET_STS_SUCCESS;
852:
853: OKC_API.set_message(p_app_name => g_app_name,
854: p_msg_name => 'CONTRACTS RE-ASSIGNED'
855: );
856:
857: OKC_API.set_message(p_app_name => g_app_name,

Line 857: OKC_API.set_message(p_app_name => g_app_name,

853: OKC_API.set_message(p_app_name => g_app_name,
854: p_msg_name => 'CONTRACTS RE-ASSIGNED'
855: );
856:
857: OKC_API.set_message(p_app_name => g_app_name,
858: p_msg_name => p_msg
859: );
860:
861:

Line 968: OKC_API.init_msg_list(p_init_msg_list);

964: IS
965:
966:
967: Begin
968: OKC_API.init_msg_list(p_init_msg_list);
969: OKC_TIME_UTIL_PUB.get_duration(p_start_date => p_line_start_date,
970: p_end_date => p_line_end_date,
971: x_duration => x_line_duration,
972: x_timeunit => x_line_timeunit,

Line 1003: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;

999: p_org_id IN NUMBER,
1000: p_salesrep_id IN NUMBER ) IS
1001:
1002: l_api_version CONSTANT NUMBER := 1.0;
1003: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
1004: l_return_status VARCHAR2(1);
1005: l_msg_count NUMBER;
1006: l_msg_data VARCHAR2(2000);
1007: l_gen_bulk_Rec JTF_TERR_ASSIGN_PUB.bulk_trans_rec_type;

Line 2255: p_init_msg_list => OKC_API.G_FALSE,

2251:
2252: -- Call JTT API to get the winners
2253: JTF_TERR_ASSIGN_PUB.get_winners
2254: ( p_api_version_number => 1.0,
2255: p_init_msg_list => OKC_API.G_FALSE,
2256: p_use_type => l_use_type,
2257: p_source_id => -1500,
2258: p_trans_id => -1501,
2259: p_trans_rec => l_gen_bulk_rec,

Line 2271: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

2267: x_winners_rec => l_gen_return_rec
2268: );
2269:
2270: fnd_file.put_line(FND_FILE.LOG,'After JTF API Call : ' || l_return_status ) ;
2271: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
2272: -- Handle error from territory API
2273: fnd_file.put_line(FND_FILE.LOG,'Exception in JTF Territory call');
2274: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2275: ELSE

Line 2274: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2270: fnd_file.put_line(FND_FILE.LOG,'After JTF API Call : ' || l_return_status ) ;
2271: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
2272: -- Handle error from territory API
2273: fnd_file.put_line(FND_FILE.LOG,'Exception in JTF Territory call');
2274: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2275: ELSE
2276: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2277: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2278: 'JTF_TERR_ASSIGN_PUB.get_winners end :'

Line 2472: l_ctcv_tbl_in(idx1).object_version_number := OKC_API.G_MISS_NUM;

2468: l_ctcv_tbl_in(idx1).object1_id2 := '#';
2469: l_ctcv_tbl_in(idx1).JTOT_OBJECT1_CODE := 'OKX_SALEPERS';
2470: l_ctcv_tbl_in(idx1).attribute1 := lj_user_id(i2);
2471: l_ctcv_tbl_in(idx1).attribute2 := l_contract_number;
2472: l_ctcv_tbl_in(idx1).object_version_number := OKC_API.G_MISS_NUM;
2473: l_ctcv_tbl_in(idx1).created_by := OKC_API.G_MISS_NUM;
2474: l_ctcv_tbl_in(idx1).creation_date := SYSDATE;
2475: l_ctcv_tbl_in(idx1).last_updated_by := OKC_API.G_MISS_NUM;
2476: l_ctcv_tbl_in(idx1).last_update_date := SYSDATE;

Line 2473: l_ctcv_tbl_in(idx1).created_by := OKC_API.G_MISS_NUM;

2469: l_ctcv_tbl_in(idx1).JTOT_OBJECT1_CODE := 'OKX_SALEPERS';
2470: l_ctcv_tbl_in(idx1).attribute1 := lj_user_id(i2);
2471: l_ctcv_tbl_in(idx1).attribute2 := l_contract_number;
2472: l_ctcv_tbl_in(idx1).object_version_number := OKC_API.G_MISS_NUM;
2473: l_ctcv_tbl_in(idx1).created_by := OKC_API.G_MISS_NUM;
2474: l_ctcv_tbl_in(idx1).creation_date := SYSDATE;
2475: l_ctcv_tbl_in(idx1).last_updated_by := OKC_API.G_MISS_NUM;
2476: l_ctcv_tbl_in(idx1).last_update_date := SYSDATE;
2477: l_ctcv_tbl_in(idx1).last_update_login := OKC_API.G_MISS_NUM;

Line 2475: l_ctcv_tbl_in(idx1).last_updated_by := OKC_API.G_MISS_NUM;

2471: l_ctcv_tbl_in(idx1).attribute2 := l_contract_number;
2472: l_ctcv_tbl_in(idx1).object_version_number := OKC_API.G_MISS_NUM;
2473: l_ctcv_tbl_in(idx1).created_by := OKC_API.G_MISS_NUM;
2474: l_ctcv_tbl_in(idx1).creation_date := SYSDATE;
2475: l_ctcv_tbl_in(idx1).last_updated_by := OKC_API.G_MISS_NUM;
2476: l_ctcv_tbl_in(idx1).last_update_date := SYSDATE;
2477: l_ctcv_tbl_in(idx1).last_update_login := OKC_API.G_MISS_NUM;
2478: l_ctcv_tbl_in(idx1).start_date := SYSDATE;
2479: l_ctcv_tbl_in(idx1).attribute3 := lj_org_id(i2);

Line 2477: l_ctcv_tbl_in(idx1).last_update_login := OKC_API.G_MISS_NUM;

2473: l_ctcv_tbl_in(idx1).created_by := OKC_API.G_MISS_NUM;
2474: l_ctcv_tbl_in(idx1).creation_date := SYSDATE;
2475: l_ctcv_tbl_in(idx1).last_updated_by := OKC_API.G_MISS_NUM;
2476: l_ctcv_tbl_in(idx1).last_update_date := SYSDATE;
2477: l_ctcv_tbl_in(idx1).last_update_login := OKC_API.G_MISS_NUM;
2478: l_ctcv_tbl_in(idx1).start_date := SYSDATE;
2479: l_ctcv_tbl_in(idx1).attribute3 := lj_org_id(i2);
2480: -- Bug Fix 4749200
2481: IF l_current_salesrep_id <> lj_salesrep_id(i2) THEN

Line 2600: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

2596: idx5 := l_ctcv_tbl_in_upd.NEXT(idx5);
2597: END LOOP;
2598: END IF;
2599:
2600: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
2601: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2602: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2603: 'Exception in update contact ');
2604: END IF;

Line 2606: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2602: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2603: 'Exception in update contact ');
2604: END IF;
2605: fnd_file.put_line(FND_FILE.LOG,'Exception in update contact');
2606: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2607: END IF;
2608:
2609: IF (l_ctcv_tbl_in_del.count > 0 ) THEN
2610: idx6 := l_ctcv_tbl_in_del.FIRST;

Line 2629: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

2625: idx6 := l_ctcv_tbl_in_del.NEXT(idx6);
2626: END LOOP;
2627: END IF;
2628:
2629: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
2630: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2631: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2632: 'Exception in delete contact ');
2633: END IF;

Line 2635: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2631: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2632: 'Exception in delete contact ');
2633: END IF;
2634: fnd_file.put_line(FND_FILE.LOG,'Exception in delete contact');
2635: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2636: END IF;
2637:
2638: IF (l_ctcv_tbl_in.count > 0 ) THEN
2639: idx3 := l_ctcv_tbl_in.FIRST;

Line 2653: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS ) THEN

2649: x_msg_data => l_msg_data,
2650: p_ctcv_rec => l_ctcv_tbl_in(idx3),
2651: x_ctcv_rec => l_ctcv_rec_out_ins);
2652:
2653: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS ) THEN
2654: okc_cvm_pvt.g_trans_id := 'XXX';
2655: l_cvmv_rec.chr_id := l_ctcv_rec_out_ins.dnz_chr_id;
2656: OKC_CVM_PVT.update_contract_version(p_api_version => l_api_version,
2657: p_init_msg_list => l_init_msg_list,

Line 2674: p_init_msg_list => OKC_API.G_TRUE,

2670: END IF;
2671: l_chrv_rec.id := l_ctcv_rec_out_ins.dnz_chr_id;
2672: l_chrv_rec.last_update_date := sysdate;
2673: OKC_CONTRACT_PUB.update_contract_header(p_api_version => l_api_version,
2674: p_init_msg_list => OKC_API.G_TRUE,
2675: x_return_status => l_return_status,
2676: x_msg_count => l_msg_count,
2677: x_msg_data => l_msg_data,
2678: p_restricted_update => OKC_API.G_TRUE,

Line 2678: p_restricted_update => OKC_API.G_TRUE,

2674: p_init_msg_list => OKC_API.G_TRUE,
2675: x_return_status => l_return_status,
2676: x_msg_count => l_msg_count,
2677: x_msg_data => l_msg_data,
2678: p_restricted_update => OKC_API.G_TRUE,
2679: p_chrv_rec => l_chrv_rec,
2680: x_chrv_rec => l_chrv_out_rec);
2681:
2682: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2823: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2819: END IF;
2820: fnd_file.put_line(FND_FILE.LOG,'Program completed successfully ' || to_char(sysdate,'HH:MI:SS'));
2821: EXCEPTION
2822:
2823: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2824: fnd_file.put_line(FND_FILE.LOG,'Exception occured');
2825: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2826: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2827: 'Error occured : ' || get_fnd_message() );

Line 2831: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2827: 'Error occured : ' || get_fnd_message() );
2828: END IF;
2829: rollback;
2830: RAISE_APPLICATION_ERROR(-20001, 'Exception occured');
2831: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2832: fnd_file.put_line(FND_FILE.LOG,'Exception occured');
2833: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2834: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2835: 'Unexpected Error : ' || get_fnd_message() );

Line 2841: OKC_API.set_message(p_app_name => g_app_name,

2837: rollback;
2838: RAISE_APPLICATION_ERROR(-20001, 'Exception occured');
2839: WHEN OTHERS THEN
2840: fnd_file.put_line(FND_FILE.LOG,'Exception occured');
2841: OKC_API.set_message(p_app_name => g_app_name,
2842: p_msg_name => g_unexpected_error,
2843: p_token1 => g_sqlcode_token,
2844: p_token1_value => sqlcode,
2845: p_token2 => g_sqlerrm_token,