APPS.OKL_AUTO_INSURANCE_PVT dependencies on OKC_API

Line 152: Okc_Api.set_message(G_APP_NAME, 'OKL_AM_NO_TRX_TYPE_FOUND','TRY_NAME',l_token_val); -- 3745151 Fix for Invalid error messages.

148: OPEN c_trx_lkup;
149: FETCH c_trx_lkup INTO l_token_val;
150: CLOSE c_trx_lkup;
151: -- 3927315 Fix for hard coded tokens
152: Okc_Api.set_message(G_APP_NAME, 'OKL_AM_NO_TRX_TYPE_FOUND','TRY_NAME',l_token_val); -- 3745151 Fix for Invalid error messages.
153: CLOSE c_trx_type ;
154: RAISE OKC_API.G_EXCEPTION_ERROR;
155: END if ;
156: CLOSE c_trx_type ;

Line 154: RAISE OKC_API.G_EXCEPTION_ERROR;

150: CLOSE c_trx_lkup;
151: -- 3927315 Fix for hard coded tokens
152: Okc_Api.set_message(G_APP_NAME, 'OKL_AM_NO_TRX_TYPE_FOUND','TRY_NAME',l_token_val); -- 3745151 Fix for Invalid error messages.
153: CLOSE c_trx_type ;
154: RAISE OKC_API.G_EXCEPTION_ERROR;
155: END if ;
156: CLOSE c_trx_type ;
157:
158: OPEN c_streams_rec_csr(l_from_bill_date,l_to_bill_date ) ;

Line 171: p_init_msg_list => Okc_Api.G_TRUE,

167: -- call ap_request
168:
169: OKL_INSURANCE_POLICIES_PUB.insert_ap_request(
170: p_api_version =>l_api_version,
171: p_init_msg_list => Okc_Api.G_TRUE,
172: x_return_status =>l_return_status,
173: x_msg_count => l_msg_count,
174: x_msg_data =>l_msg_data,
175: p_tap_id => NULL,

Line 183: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN --<4

179: p_kle_id =>c_streams_rec.kle_id,
180: p_invoice_date =>c_streams_rec.due_date,
181: p_trx_id => l_trx_type_id);
182:
183: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN --<4
184: FOR i IN 1..l_msg_count LOOP
185: JTF_PLSQL_API.get_messages(i,l_msg_data);
186: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,l_msg_data );
187: END LOOP;

Line 188: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

184: FOR i IN 1..l_msg_count LOOP
185: JTF_PLSQL_API.get_messages(i,l_msg_data);
186: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,l_msg_data );
187: END LOOP;
188: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
189: ELSIF(l_return_status = OKC_API.G_RET_STS_ERROR) THEN --<4
190:
191: FOR i IN 1..l_msg_count LOOP
192: JTF_PLSQL_API.get_messages(i,l_msg_data);

Line 189: ELSIF(l_return_status = OKC_API.G_RET_STS_ERROR) THEN --<4

185: JTF_PLSQL_API.get_messages(i,l_msg_data);
186: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,l_msg_data );
187: END LOOP;
188: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
189: ELSIF(l_return_status = OKC_API.G_RET_STS_ERROR) THEN --<4
190:
191: FOR i IN 1..l_msg_count LOOP
192: JTF_PLSQL_API.get_messages(i,l_msg_data);
193: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,l_msg_data );

Line 202: ,Okc_Api.G_TRUE

198: l_selv_rec.date_billed := sysdate;
199:
200: Okl_Streams_Pub.update_stream_elements
201: (l_api_version
202: ,Okc_Api.G_TRUE
203: ,l_return_status
204: ,l_msg_count
205: ,l_msg_data
206: ,l_selv_rec

Line 209: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN --<4

205: ,l_msg_data
206: ,l_selv_rec
207: ,x_selv_rec);
208:
209: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN --<4
210: FOR i IN 1..l_msg_count LOOP
211: JTF_PLSQL_API.get_messages(i,l_msg_data);
212: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,l_msg_data );
213: END LOOP;

Line 215: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

211: JTF_PLSQL_API.get_messages(i,l_msg_data);
212: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,l_msg_data );
213: END LOOP;
214: ROLLBACK TO pay_ins_payments;
215: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
216: ELSIF(l_return_status = OKC_API.G_RET_STS_ERROR) THEN --<4
217:
218: FOR i IN 1..l_msg_count LOOP
219: JTF_PLSQL_API.get_messages(i,l_msg_data);

Line 216: ELSIF(l_return_status = OKC_API.G_RET_STS_ERROR) THEN --<4

212: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,l_msg_data );
213: END LOOP;
214: ROLLBACK TO pay_ins_payments;
215: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
216: ELSIF(l_return_status = OKC_API.G_RET_STS_ERROR) THEN --<4
217:
218: FOR i IN 1..l_msg_count LOOP
219: JTF_PLSQL_API.get_messages(i,l_msg_data);
220: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,l_msg_data );

Line 290: x_retrun_status := OKC_API.G_RET_STS_SUCCESS ;

286: BEGIN
287:
288: SAVEPOINT create_third_party_task_event;
289:
290: x_retrun_status := OKC_API.G_RET_STS_SUCCESS ;
291: -- Test if there are any active subscritions
292: -- if it is the case then execute the subscriptions
293: l_yn := exist_subscription(l_event_name);
294:

Line 317: x_retrun_status := OKC_API.G_RET_STS_ERROR ;

313:
314: ELSE
315: FND_MESSAGE.SET_NAME('OKL', 'OKL_NO_EVENT');
316: FND_MSG_PUB.ADD;
317: x_retrun_status := OKC_API.G_RET_STS_ERROR ;
318: END IF;
319: EXCEPTION
320: WHEN OTHERS THEN
321: FND_MESSAGE.SET_NAME('OKL', 'OKL_API_OTHERS_EXCEP');

Line 325: x_retrun_status := OKC_API.G_RET_STS_UNEXP_ERROR ;

321: FND_MESSAGE.SET_NAME('OKL', 'OKL_API_OTHERS_EXCEP');
322: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
323: FND_MSG_PUB.ADD;
324: ROLLBACK TO create_third_party_task_event;
325: x_retrun_status := OKC_API.G_RET_STS_UNEXP_ERROR ;
326:
327: END create_third_party_task_event;
328:
329:

Line 339: l_init_msg_list VARCHAR2(1) := Okc_Api.G_FALSE ;

335: p_template_id IN NUMBER )
336: IS
337: l_chr_id number ;
338: lx_email varchar2(240);
339: l_init_msg_list VARCHAR2(1) := Okc_Api.G_FALSE ;
340: l_msg_count NUMBER ;
341: l_msg_data VARCHAR2(2000);
342: l_api_version CONSTANT NUMBER := 1;
343: l_return_status VARCHAR2(1) :=

Line 344: Okc_Api.G_RET_STS_SUCCESS;

340: l_msg_count NUMBER ;
341: l_msg_data VARCHAR2(2000);
342: l_api_version CONSTANT NUMBER := 1;
343: l_return_status VARCHAR2(1) :=
344: Okc_Api.G_RET_STS_SUCCESS;
345: ls_to_email varchar2(240);
346: ls_contract_number VARCHAR2(80);
347: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
348: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;

Line 407: IF l_content_id = Okc_Api.G_MISS_NUM OR l_content_id IS NULL THEN --Bug: 4177206

403: ls_remder_num_days := TO_NUMBER(ls_reminder_days);
404:
405: IF ls_reminder_yn = 'Y' THEN --Bug: 4177206
406: l_content_id := p_template_id ;
407: IF l_content_id = Okc_Api.G_MISS_NUM OR l_content_id IS NULL THEN --Bug: 4177206
408: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,'No Document is selected');
409: END IF;
410: -- Added by Skgautam for bug 4177206
411: --Obtain user profile option name for given profile option name

Line 440: IF ls_to_email = Okc_Api.G_MISS_CHAR OR ls_to_email IS NULL THEN

436: ls_to_email := lx_email;
437: ELSE
438: ls_to_email := fnd_profile.value('OKL_EMAIL_IDENTITY');
439: -- Check for NULL values and return if either of these is null
440: IF ls_to_email = Okc_Api.G_MISS_CHAR OR ls_to_email IS NULL THEN
441: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,'System profile value for ' || l_profile_name || ' is not defined');
442: RETURN;
443: END IF;
444: END IF;

Line 515: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

511: /*FUNCTION get_contract_status (
512: p_khr_id IN NUMBER,
513: x_contract_status OUT NOCOPY VARCHAR2
514: ) RETURN VARCHAR2 IS
515: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
516: CURSOR okc_k_status_csr(p_khr_id IN NUMBER) IS
517: SELECT STE_CODE
518: FROM OKC_K_HEADERS_V KHR , OKC_STATUSES_B OST
519: WHERE KHR.ID = p_khr_id

Line 531: l_return_status := OKC_API.G_RET_STS_ERROR;

527: OKL_API.set_message(G_APP_NAME,
528: 'OKL_INVALID_CONTRACT_STATUS'
529: );
530: CLOSE okc_k_status_csr ;
531: l_return_status := OKC_API.G_RET_STS_ERROR;
532: -- Change it to
533: RETURN(l_return_status);
534: END IF;
535: CLOSE okc_k_status_csr ;

Line 540: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE, G_SQLERRM_TOKEN, SQLERRM);

536: RETURN(l_return_status);
537: EXCEPTION
538: WHEN OTHERS THEN
539: -- store SQL error message on message stack for caller
540: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE, G_SQLERRM_TOKEN, SQLERRM);
541: -- notify caller of an UNEXPECTED error
542: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
543: -- verify that cursor was closed
544: IF okc_k_status_csr%ISOPEN THEN

Line 542: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

538: WHEN OTHERS THEN
539: -- store SQL error message on message stack for caller
540: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE, G_SQLERRM_TOKEN, SQLERRM);
541: -- notify caller of an UNEXPECTED error
542: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
543: -- verify that cursor was closed
544: IF okc_k_status_csr%ISOPEN THEN
545: CLOSE okc_k_status_csr;
546: END IF;

Line 773: l_init_msg_list VARCHAR2(1) := Okc_Api.G_FALSE ;

769:
770: l_profile_name FND_PROFILE_OPTIONS_TL.USER_PROFILE_OPTION_NAME%TYPE;
771:
772: lx_email varchar2(240);
773: l_init_msg_list VARCHAR2(1) := Okc_Api.G_FALSE ;
774: l_msg_count NUMBER ;
775: l_msg_data VARCHAR2(2000);
776: l_api_version CONSTANT NUMBER := 1;
777: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

Line 777: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

773: l_init_msg_list VARCHAR2(1) := Okc_Api.G_FALSE ;
774: l_msg_count NUMBER ;
775: l_msg_data VARCHAR2(2000);
776: l_api_version CONSTANT NUMBER := 1;
777: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
778: ls_to_email varchar2(240);
779: ls_contract_number VARCHAR2(80);
780: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
781: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;

Line 793: IF l_content_id = Okc_Api.G_MISS_NUM OR l_content_id IS NULL THEN --Bug: 4177206

789:
790: BEGIN
791:
792: l_content_id := p_template_id ;
793: IF l_content_id = Okc_Api.G_MISS_NUM OR l_content_id IS NULL THEN --Bug: 4177206
794: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,'No Document is Selected');
795: END IF;
796: -- Added by Skgautam for bug 4177206
797: --Obtain user profile option name for given profile option name

Line 822: IF ls_to_email = Okc_Api.G_MISS_CHAR OR ls_to_email IS NULL THEN --Bug: 4177206

818: ls_to_email := lx_email;
819: ELSE
820: ls_to_email := fnd_profile.value('OKL_EMAIL_IDENTITY');
821: -- Check for NULL values and return if either of these is null
822: IF ls_to_email = Okc_Api.G_MISS_CHAR OR ls_to_email IS NULL THEN --Bug: 4177206
823: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,'System profile value for ' || l_profile_name || ' is not defined');
824: RETURN;
825: END IF;
826: END IF;

Line 1023: l_init_msg_list VARCHAR2(1) := Okc_Api.G_FALSE ;

1019: l_end_date DATE;
1020: lb_provider BOOLEAN := FALSE ;
1021: l_afterlease_criteria NUMBER ;
1022: x_message VARCHAR2(100) ;
1023: l_init_msg_list VARCHAR2(1) := Okc_Api.G_FALSE ;
1024: l_msg_count NUMBER ;
1025: l_msg_data VARCHAR2(2000);
1026: l_api_version CONSTANT NUMBER := 1;
1027: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

Line 1027: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1023: l_init_msg_list VARCHAR2(1) := Okc_Api.G_FALSE ;
1024: l_msg_count NUMBER ;
1025: l_msg_data VARCHAR2(2000);
1026: l_api_version CONSTANT NUMBER := 1;
1027: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1028: px_ipyv_rec ipyv_rec_type;
1029: l_api_name CONSTANT VARCHAR2(30) := 'AUTO_INS_ESTABLISHMENT';
1030: x_iasset_tbl Okl_Ins_Quote_Pvt.iasset_tbl_type ;
1031: l_policy_id NUMBER ;

Line 1067: IF l_afterlease_criteria = Okc_Api.G_MISS_NUM OR l_afterlease_criteria IS NULL THEN

1063: FETCH l_profile_name_csr INTO l_profile_name;
1064: CLOSE l_profile_name_csr;
1065:
1066: -- Check for NULL values and return if either of these is null
1067: IF l_afterlease_criteria = Okc_Api.G_MISS_NUM OR l_afterlease_criteria IS NULL THEN
1068: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,'System profile value for ' || l_profile_name || ' is not defined');
1069: RETURN;
1070: END IF;
1071:

Line 1082: IF ls_payment_freq = Okc_Api.G_MISS_CHAR OR ls_payment_freq IS NULL THEN

1078: FETCH l_profile_name_csr INTO l_profile_name;
1079: CLOSE l_profile_name_csr;
1080:
1081: -- Check for NULL values and return if any of these is null
1082: IF ls_payment_freq = Okc_Api.G_MISS_CHAR OR ls_payment_freq IS NULL THEN
1083: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,'System profile value for ' || l_profile_name || ' is not defined');
1084: RETURN;
1085: END IF;
1086:

Line 1137: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) Then

1133: create_third_party_task_event
1134: ( p_contract_id => l_khr_id,
1135: p_org_id => l_khr_org_id,
1136: x_retrun_status => l_return_status);
1137: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) Then
1138: J:= J+ 1 ;
1139: workflow_tbl_type(j).CONTRACT_NUMBER := l_khr_number ;
1140: workflow_tbl_type(j).start_date := l_khr_start ;
1141: ELSE

Line 1158: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) Then

1154: create_third_party_task_event
1155: ( p_contract_id => l_khr_id,
1156: p_org_id => l_khr_org_id,
1157: x_retrun_status => l_return_status);
1158: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) Then
1159: J:= J+ 1 ;
1160: workflow_tbl_type(j).CONTRACT_NUMBER := l_khr_number ;
1161: workflow_tbl_type(j).start_date := l_khr_start ;
1162: ELSE

Line 1184: ELSIF (ls_fin_line = Okc_Api.G_MISS_NUM AND ls_fin_line IS NULL ) THEN -- <2

1180: error_tbl_type(k).CONTRACT_NUMBER := l_khr_number ;
1181: error_tbl_type(k).start_date := l_khr_start ;
1182: lb_provider := true;
1183: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,'Financial Line not setup for Contract Number '|| l_khr_number);
1184: ELSIF (ls_fin_line = Okc_Api.G_MISS_NUM AND ls_fin_line IS NULL ) THEN -- <2
1185: CLOSE okl_financial_line_csr;
1186: K := k + 1 ;
1187: lb_provider := true;
1188: error_tbl_type(k).CONTRACT_NUMBER := l_khr_number ;

Line 1196: IF (ls_country = Okc_Api.G_MISS_CHAR AND ls_country IS NULL ) THEN -- <2

1192: CLOSE okl_financial_line_csr;
1193: END IF;
1194: -- GET COUNTRY
1195: ls_country := OKL_UTIL.get_active_line_inst_country(ls_fin_line);
1196: IF (ls_country = Okc_Api.G_MISS_CHAR AND ls_country IS NULL ) THEN -- <2
1197: K := k + 1 ;
1198: lb_provider := true;
1199: error_tbl_type(k).CONTRACT_NUMBER := l_khr_number ;
1200: error_tbl_type(k).start_date := l_khr_start ;

Line 1256: p_init_msg_list => Okc_Api.G_TRUE,

1252: --Bug # 6318957 Changes End
1253:
1254: Okl_Ins_Quote_Pub.calc_lease_premium(
1255: p_api_version => l_api_version ,
1256: p_init_msg_list => Okc_Api.G_TRUE,
1257: x_return_status => l_return_status,
1258: x_msg_count => l_msg_count,
1259: x_msg_data => l_msg_data,
1260: px_ipyv_rec => px_ipyv_rec,

Line 1264: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN --<4

1260: px_ipyv_rec => px_ipyv_rec,
1261: x_message =>x_message,
1262: x_iasset_tbl => x_iasset_tbl );
1263:
1264: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN --<4
1265: FOR i IN 1..l_msg_count LOOP
1266: JTF_PLSQL_API.get_messages(i,l_msg_data);
1267: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,l_msg_data );
1268: END LOOP;

Line 1269: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1265: FOR i IN 1..l_msg_count LOOP
1266: JTF_PLSQL_API.get_messages(i,l_msg_data);
1267: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,l_msg_data );
1268: END LOOP;
1269: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1270: ELSIF(l_return_status = OKC_API.G_RET_STS_ERROR) THEN --<4
1271: IF(x_message = OKL_INS_QUOTE_PVT.G_NO_INS ) THEN --<5
1272: lb_provider := false;
1273: FOR i IN 1..l_msg_count LOOP

Line 1270: ELSIF(l_return_status = OKC_API.G_RET_STS_ERROR) THEN --<4

1266: JTF_PLSQL_API.get_messages(i,l_msg_data);
1267: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,l_msg_data );
1268: END LOOP;
1269: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1270: ELSIF(l_return_status = OKC_API.G_RET_STS_ERROR) THEN --<4
1271: IF(x_message = OKL_INS_QUOTE_PVT.G_NO_INS ) THEN --<5
1272: lb_provider := false;
1273: FOR i IN 1..l_msg_count LOOP
1274: JTF_PLSQL_API.get_messages(i,l_msg_data);

Line 1300: p_init_msg_list => Okc_Api.G_TRUE,

1296: lb_provider := TRUE ;
1297: px_ipyv_rec.ADJUSTMENT := 0 ;
1298: Okl_Ins_Quote_Pub.save_accept_quote(
1299: p_api_version => l_api_version ,
1300: p_init_msg_list => Okc_Api.G_TRUE,
1301: x_return_status => l_return_status,
1302: x_msg_count => l_msg_count,
1303: x_msg_data => l_msg_data,
1304: p_ipyv_rec => px_ipyv_rec,

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

1303: x_msg_data => l_msg_data,
1304: p_ipyv_rec => px_ipyv_rec,
1305: x_message =>x_message
1306: );
1307: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1308: ROLLBACK TO auto_insurance;
1309: FOR i IN 1..l_msg_count LOOP
1310: JTF_PLSQL_API.get_messages(i,l_msg_data);
1311: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,l_msg_data );

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

1310: JTF_PLSQL_API.get_messages(i,l_msg_data);
1311: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,l_msg_data );
1312: END LOOP;
1313: EXIT;
1314: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1315: ROLLBACK TO auto_insurance;
1316: FOR i IN 1..l_msg_count LOOP
1317: JTF_PLSQL_API.get_messages(i,l_msg_data);
1318: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,l_msg_data );

Line 1338: p_init_msg_list => Okc_Api.G_TRUE,

1334: COMMIT ;
1335: SAVEPOINT ACTIVATE ;
1336: Okl_Ins_Quote_Pub.activate_ins_policy(
1337: p_api_version => l_api_version ,
1338: p_init_msg_list => Okc_Api.G_TRUE,
1339: x_return_status => l_return_status,
1340: x_msg_count => l_msg_count,
1341: x_msg_data => l_msg_data,
1342: p_ins_policy_id => l_policy_id );

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

1340: x_msg_count => l_msg_count,
1341: x_msg_data => l_msg_data,
1342: p_ins_policy_id => l_policy_id );
1343:
1344: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1345: ROLLBACK TO ACTIVATE ;
1346: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,'Activate Policy for Contract' ||l_khr_number );
1347: FOR i IN 1..l_msg_count LOOP
1348: JTF_PLSQL_API.get_messages(i,l_msg_data);

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

1348: JTF_PLSQL_API.get_messages(i,l_msg_data);
1349: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,l_msg_data );
1350: END LOOP;
1351: EXIT;
1352: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1353: ROLLBACK TO ACTIVATE ;
1354: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,'Activate Policy for Contract' ||l_khr_number );
1355: FOR i IN 1..l_msg_count LOOP
1356: JTF_PLSQL_API.get_messages(i,l_msg_data);

Line 1377: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) Then

1373: create_third_party_task_event
1374: ( p_contract_id => l_khr_id,
1375: p_org_id => l_khr_org_id,
1376: x_retrun_status => l_return_status);
1377: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) Then
1378: J:= J+ 1 ;
1379: workflow_tbl_type(j).CONTRACT_NUMBER := l_khr_number ;
1380: workflow_tbl_type(j).start_date := l_khr_start ;
1381: ELSE

Line 1449: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR ;

1445: END IF;
1446: IF okl_eli_policies_csr%ISOPEN THEN
1447: CLOSE okl_eli_policies_csr;
1448: END IF;
1449: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR ;
1450: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR ;
1451: END;
1452: END auto_ins_establishment ;
1453: END OKL_AUTO_INSURANCE_PVT;

Line 1450: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR ;

1446: IF okl_eli_policies_csr%ISOPEN THEN
1447: CLOSE okl_eli_policies_csr;
1448: END IF;
1449: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR ;
1450: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR ;
1451: END;
1452: END auto_ins_establishment ;
1453: END OKL_AUTO_INSURANCE_PVT;