DBA Data[Home] [Help]

APPS.OKL_AUTO_INSURANCE_PVT dependencies on JTF_PLSQL_API

Line 185: JTF_PLSQL_API.get_messages(i,l_msg_data);

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;
188: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
189: ELSIF(l_return_status = OKC_API.G_RET_STS_ERROR) THEN --<4

Line 192: JTF_PLSQL_API.get_messages(i,l_msg_data);

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 );
194: END LOOP;
195: ROLLBACK TO pay_ins_payments;
196: ELSE

Line 211: JTF_PLSQL_API.get_messages(i,l_msg_data);

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;
214: ROLLBACK TO pay_ins_payments;
215: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 219: JTF_PLSQL_API.get_messages(i,l_msg_data);

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 );
221: END LOOP;
222: ROLLBACK TO pay_ins_payments;
223: END IF;

Line 852: JTF_PLSQL_API.get_messages(i,l_msg_data);

848: x_msg_count => l_msg_count,
849: x_msg_data => l_msg_data);
850: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
851: FOR i IN 1..l_msg_count LOOP
852: JTF_PLSQL_API.get_messages(i,l_msg_data);
853: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,l_msg_data );
854: END LOOP;
855: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
856: FOR i IN 1..l_msg_count LOOP

Line 857: JTF_PLSQL_API.get_messages(i,l_msg_data);

853: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,l_msg_data );
854: END LOOP;
855: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
856: FOR i IN 1..l_msg_count LOOP
857: JTF_PLSQL_API.get_messages(i,l_msg_data);
858: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,l_msg_data );
859: END LOOP;
860: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
861: END IF;

Line 1266: JTF_PLSQL_API.get_messages(i,l_msg_data);

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;
1269: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1270: ELSIF(l_return_status = OKC_API.G_RET_STS_ERROR) THEN --<4

Line 1274: JTF_PLSQL_API.get_messages(i,l_msg_data);

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);
1275: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,l_msg_data );
1276: END LOOP;
1277: EXIT;
1278: ELSIF(x_message = OKL_INS_QUOTE_PVT.G_NOT_ABLE ) THEN--<5

Line 1285: JTF_PLSQL_API.get_messages(i,l_msg_data);

1281: NULL;
1282: ELSE --<5
1283:
1284: FOR i IN 1..l_msg_count LOOP
1285: JTF_PLSQL_API.get_messages(i,l_msg_data);
1286: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,l_msg_data );
1287: END LOOP;
1288: K := k + 1 ;
1289: error_tbl_type(k).CONTRACT_NUMBER := l_khr_number ;

Line 1310: JTF_PLSQL_API.get_messages(i,l_msg_data);

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 );
1312: END LOOP;
1313: EXIT;
1314: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 1317: JTF_PLSQL_API.get_messages(i,l_msg_data);

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 );
1319: END LOOP;
1320: EXIT;
1321: END IF;

Line 1348: JTF_PLSQL_API.get_messages(i,l_msg_data);

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);
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

Line 1356: JTF_PLSQL_API.get_messages(i,l_msg_data);

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);
1357: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,l_msg_data );
1358: END LOOP;
1359: EXIT;
1360: END IF;