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.

[Home] [Help]

APPS.OKL_INSURANCE_POLICIES_PVT dependencies on FND_API

Line 4585: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN

4581: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug call Okl_Trx_Ar_Invoices_Pub.insert_trx_ar_invoices');
4582: END;
4583: END IF;
4584: -- End of wraper code generated automatically by Debug code generator for Okl_Trx_Ar_Invoices_Pub.insert_trx_ar_invoices
4585: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
4586: RAISE Fnd_Api.G_EXC_ERROR;
4587: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
4588: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
4589: END IF;

Line 4586: RAISE Fnd_Api.G_EXC_ERROR;

4582: END;
4583: END IF;
4584: -- End of wraper code generated automatically by Debug code generator for Okl_Trx_Ar_Invoices_Pub.insert_trx_ar_invoices
4585: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
4586: RAISE Fnd_Api.G_EXC_ERROR;
4587: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
4588: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
4589: END IF;
4590: --Line Level

Line 4587: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN

4583: END IF;
4584: -- End of wraper code generated automatically by Debug code generator for Okl_Trx_Ar_Invoices_Pub.insert_trx_ar_invoices
4585: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
4586: RAISE Fnd_Api.G_EXC_ERROR;
4587: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
4588: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
4589: END IF;
4590: --Line Level
4591: l_tilv_rec.description := 'Insurance manual invoice';

Line 4588: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

4584: -- End of wraper code generated automatically by Debug code generator for Okl_Trx_Ar_Invoices_Pub.insert_trx_ar_invoices
4585: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
4586: RAISE Fnd_Api.G_EXC_ERROR;
4587: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
4588: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
4589: END IF;
4590: --Line Level
4591: l_tilv_rec.description := 'Insurance manual invoice';
4592: l_tilv_rec.sfwt_flag := 'Y';

Line 4624: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN

4620: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug call okl_txl_ar_inv_lns_pub.insert_txl_ar_inv_lns');
4621: END;
4622: END IF;
4623: -- End of wraper code generated automatically by Debug code generator for Okl_txl_ar_inv_lns_pub.insert_txl_ar_inv_lns
4624: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
4625: RAISE Fnd_Api.G_EXC_ERROR;
4626: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
4627: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
4628: END IF;

Line 4625: RAISE Fnd_Api.G_EXC_ERROR;

4621: END;
4622: END IF;
4623: -- End of wraper code generated automatically by Debug code generator for Okl_txl_ar_inv_lns_pub.insert_txl_ar_inv_lns
4624: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
4625: RAISE Fnd_Api.G_EXC_ERROR;
4626: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
4627: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
4628: END IF;
4629: p_bpd_acc_rec.id := lx_tilv_rec.id;

Line 4626: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN

4622: END IF;
4623: -- End of wraper code generated automatically by Debug code generator for Okl_txl_ar_inv_lns_pub.insert_txl_ar_inv_lns
4624: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
4625: RAISE Fnd_Api.G_EXC_ERROR;
4626: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
4627: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
4628: END IF;
4629: p_bpd_acc_rec.id := lx_tilv_rec.id;
4630: p_bpd_acc_rec.source_table := 'OKL_TXL_AR_INV_LNS_B';

Line 4627: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

4623: -- End of wraper code generated automatically by Debug code generator for Okl_txl_ar_inv_lns_pub.insert_txl_ar_inv_lns
4624: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
4625: RAISE Fnd_Api.G_EXC_ERROR;
4626: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
4627: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
4628: END IF;
4629: p_bpd_acc_rec.id := lx_tilv_rec.id;
4630: p_bpd_acc_rec.source_table := 'OKL_TXL_AR_INV_LNS_B';
4631: ----------------------------------------------------

Line 4900: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN

4896: END;
4897: END IF;
4898: l_return_status := x_return_status;
4899: -- End of wraper code generated automatically by Debug code generator for Rebook_manual_invoice
4900: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
4901: RAISE Fnd_Api.G_EXC_ERROR;
4902: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
4903: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
4904: END IF;

Line 4901: RAISE Fnd_Api.G_EXC_ERROR;

4897: END IF;
4898: l_return_status := x_return_status;
4899: -- End of wraper code generated automatically by Debug code generator for Rebook_manual_invoice
4900: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
4901: RAISE Fnd_Api.G_EXC_ERROR;
4902: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
4903: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
4904: END IF;
4905: END IF ;

Line 4902: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN

4898: l_return_status := x_return_status;
4899: -- End of wraper code generated automatically by Debug code generator for Rebook_manual_invoice
4900: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
4901: RAISE Fnd_Api.G_EXC_ERROR;
4902: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
4903: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
4904: END IF;
4905: END IF ;
4906: ------------------------------------------

Line 4903: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

4899: -- End of wraper code generated automatically by Debug code generator for Rebook_manual_invoice
4900: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
4901: RAISE Fnd_Api.G_EXC_ERROR;
4902: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
4903: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
4904: END IF;
4905: END IF ;
4906: ------------------------------------------
4907: --- PAY or clawback from vendor

Line 5011: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN

5007: p_refund_amount =>l_cust_refund_amount,
5008: p_src_trx_id => p_src_trx_id
5009: );
5010:
5011: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
5012: RAISE Fnd_Api.G_EXC_ERROR;
5013: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
5014: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
5015: END IF;

Line 5012: RAISE Fnd_Api.G_EXC_ERROR;

5008: p_src_trx_id => p_src_trx_id
5009: );
5010:
5011: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
5012: RAISE Fnd_Api.G_EXC_ERROR;
5013: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
5014: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
5015: END IF;
5016: ------------------------------------------

Line 5013: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN

5009: );
5010:
5011: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
5012: RAISE Fnd_Api.G_EXC_ERROR;
5013: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
5014: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
5015: END IF;
5016: ------------------------------------------
5017: --- Expense Adjustment

Line 5014: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

5010:
5011: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
5012: RAISE Fnd_Api.G_EXC_ERROR;
5013: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
5014: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
5015: END IF;
5016: ------------------------------------------
5017: --- Expense Adjustment
5018: ------------------------------------------

Line 5028: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN

5024: p_ipyv_rec =>l_ipyv_rec,
5025: lp_vendor_refund_amount =>l_vendor_refund_amount,
5026: p_src_trx_id => p_src_trx_id
5027: );
5028: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
5029: RAISE Fnd_Api.G_EXC_ERROR;
5030: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
5031: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
5032: END IF;

Line 5029: RAISE Fnd_Api.G_EXC_ERROR;

5025: lp_vendor_refund_amount =>l_vendor_refund_amount,
5026: p_src_trx_id => p_src_trx_id
5027: );
5028: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
5029: RAISE Fnd_Api.G_EXC_ERROR;
5030: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
5031: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
5032: END IF;
5033: l_ipyv_rec.iss_code := 'CANCELED';

Line 5030: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN

5026: p_src_trx_id => p_src_trx_id
5027: );
5028: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
5029: RAISE Fnd_Api.G_EXC_ERROR;
5030: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
5031: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
5032: END IF;
5033: l_ipyv_rec.iss_code := 'CANCELED';
5034: -- Create entry for adjustment

Line 5031: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

5027: );
5028: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
5029: RAISE Fnd_Api.G_EXC_ERROR;
5030: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
5031: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
5032: END IF;
5033: l_ipyv_rec.iss_code := 'CANCELED';
5034: -- Create entry for adjustment
5035: --Update Policy

Line 7290: x_return_status := FND_API.G_RET_STS_SUCCESS;

7286: fnd_file.put_line(fnd_file.log, 'OKL_INSURANCE_POLICIES_PVT.OKL_INSURANCE_PARTY_MERGE');
7287: --
7288: arp_message.set_line('OKL_INSURANCE_POLICIES_PVT.OKL_INSURANCE_PARTY_MERGE()+');
7289:
7290: x_return_status := FND_API.G_RET_STS_SUCCESS;
7291:
7292:
7293: --
7294: select merge_reason_code

Line 7348: x_return_status := FND_API.G_RET_STS_ERROR;

7344: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
7345: 'OKL_INS_POLICIES for = '|| p_from_id));
7346: --
7347: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
7348: x_return_status := FND_API.G_RET_STS_ERROR;
7349: end;
7350: end if;
7351: END OKL_INSURANCE_PARTY_MERGE ;
7352:

Line 7377: x_return_status := FND_API.G_RET_STS_SUCCESS;

7373: fnd_file.put_line(fnd_file.log, 'OKL_INSURANCE_POLICIES_PVT.OKL_INSURANCE_PARTY_SITE_MERGE');
7374: --
7375: arp_message.set_line('OKL_INSURANCE_POLICIES_PVT.OKL_INSURANCE_PARTY_SITE_MERGE()+');
7376:
7377: x_return_status := FND_API.G_RET_STS_SUCCESS;
7378:
7379:
7380: --
7381: select merge_reason_code

Line 7435: x_return_status := FND_API.G_RET_STS_ERROR;

7431: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
7432: 'OKL_INS_POLICIES for = '|| p_from_id));
7433: --
7434: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
7435: x_return_status := FND_API.G_RET_STS_ERROR;
7436: end;
7437: end if;
7438: END OKL_INSURANCE_PARTY_SITE_MERGE ;
7439:

Line 7463: x_return_status := FND_API.G_RET_STS_SUCCESS;

7459: fnd_file.put_line(fnd_file.log, 'OKL_INSURANCE_POLICIES_PVT.OKL_INSURANCE_AGENT_MERGE');
7460: --
7461: arp_message.set_line('OKL_INSURANCE_POLICIES_PVT.OKL_INSURANCE_AGENT_MERGE()+');
7462:
7463: x_return_status := FND_API.G_RET_STS_SUCCESS;
7464:
7465:
7466: --
7467: select merge_reason_code

Line 7521: x_return_status := FND_API.G_RET_STS_ERROR;

7517: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
7518: 'OKL_INS_POLICIES for = '|| p_from_id));
7519: --
7520: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
7521: x_return_status := FND_API.G_RET_STS_ERROR;
7522: end;
7523: end if;
7524: END OKL_INSURANCE_AGENT_MERGE ;
7525: -----------------------------------------------------------------------------

Line 7548: x_return_status := FND_API.G_RET_STS_SUCCESS;

7544: fnd_file.put_line(fnd_file.log, 'OKL_INSURANCE_POLICIES_PVT.OKL_INSURANCE_AGENT_SITE_MERGE');
7545: --
7546: arp_message.set_line('OKL_INSURANCE_POLICIES_PVT.OKL_INSURANCE_AGENT_SITE_MERGE()+');
7547:
7548: x_return_status := FND_API.G_RET_STS_SUCCESS;
7549:
7550:
7551: --
7552: select merge_reason_code

Line 7606: x_return_status := FND_API.G_RET_STS_ERROR;

7602: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
7603: 'OKL_INS_POLICIES for = '|| p_from_id));
7604: --
7605: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
7606: x_return_status := FND_API.G_RET_STS_ERROR;
7607: end;
7608: end if;
7609: END OKL_INSURANCE_AGENT_SITE_MERGE ;
7610: