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.OKL_PAY_CURE_REFUNDS_PVT dependencies on OKL_API

Line 18: fnd_message.set_name('OKL', 'OKL_API_ALL_MISSING_PARAM');

14: PROCEDURE AddMissingArgMsg
15: ( p_api_name IN VARCHAR2,
16: p_param_name IN VARCHAR2 )IS
17: BEGIN
18: fnd_message.set_name('OKL', 'OKL_API_ALL_MISSING_PARAM');
19: fnd_message.set_token('API_NAME', p_api_name);
20: fnd_message.set_token('MISSING_PARAM', p_param_name);
21: fnd_msg_pub.add;
22:

Line 1869: OKL_API.SET_MESSAGE (p_app_name => 'OKL',

1865: LOOP
1866: l_tmpl_identify_tbl(1).product_id := i.pdt_id;
1867: l_scs_code := i.scs_code;
1868: IF l_tmpl_identify_tbl(1).product_id IS NULL THEN
1869: OKL_API.SET_MESSAGE (p_app_name => 'OKL',
1870: p_msg_name => 'OKL_NO_PRODUCT_FOUND');
1871: raise FND_API.G_EXC_ERROR;
1872: END IF;
1873: IF PG_DEBUG < 11 THEN

Line 2002: p_init_msg_list => OKL_API.G_FALSE,

1998:
1999: --Bug# 4622198 :For special accounting treatment - START
2000: OKL_SECURITIZATION_PVT.Check_Khr_ia_associated(
2001: p_api_version => 1.0,
2002: p_init_msg_list => OKL_API.G_FALSE,
2003: x_return_status => x_return_status,
2004: x_msg_count => x_msg_count,
2005: x_msg_data => x_msg_data,
2006: p_khr_id => j.khr_id,

Line 2013: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2009: x_fact_synd_code => l_fact_synd_code,
2010: x_inv_acct_code => l_inv_acct_code
2011: );
2012:
2013: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2014: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2015: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2016: RAISE OKL_API.G_EXCEPTION_ERROR;
2017: END IF;

Line 2014: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2010: x_inv_acct_code => l_inv_acct_code
2011: );
2012:
2013: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2014: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2015: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2016: RAISE OKL_API.G_EXCEPTION_ERROR;
2017: END IF;
2018:

Line 2015: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

2011: );
2012:
2013: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2014: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2015: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2016: RAISE OKL_API.G_EXCEPTION_ERROR;
2017: END IF;
2018:
2019: l_tmpl_identify_tbl(1).factoring_synd_flag := l_fact_synd_code;

Line 2016: RAISE OKL_API.G_EXCEPTION_ERROR;

2012:
2013: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2014: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2015: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2016: RAISE OKL_API.G_EXCEPTION_ERROR;
2017: END IF;
2018:
2019: l_tmpl_identify_tbl(1).factoring_synd_flag := l_fact_synd_code;
2020: l_tmpl_identify_tbl(1).investor_code := l_inv_acct_code;

Line 2048: p_init_msg_list => OKL_API.G_FALSE,

2044: */
2045: -- R12 CHANGE - START
2046: okl_account_dist_pvt.create_accounting_dist(
2047: p_api_version => 1.0,
2048: p_init_msg_list => OKL_API.G_FALSE,
2049: x_return_status => l_return_status,
2050: x_msg_count => l_msg_count,
2051: x_msg_data => l_msg_data,
2052: p_tmpl_identify_tbl => l_tmpl_identify_tbl,

Line 2590: p_init_msg_list => OKL_API.G_FALSE,

2586:
2587: -- R12 CHANGE - START
2588: okl_account_dist_pvt.create_accounting_dist(
2589: p_api_version => 1.0,
2590: p_init_msg_list => OKL_API.G_FALSE,
2591: x_return_status => l_return_status,
2592: x_msg_count => l_msg_count,
2593: x_msg_data => l_msg_data,
2594: p_tmpl_identify_tbl => l_tmpl_identify_tbl,

Line 3131: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

3127: -- End of comments
3128: ----------------------------------------------------------------------------------
3129: PROCEDURE additional_tld_attr(
3130: p_api_version IN NUMBER
3131: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
3132: ,x_return_status OUT NOCOPY VARCHAR2
3133: ,x_msg_count OUT NOCOPY NUMBER
3134: ,x_msg_data OUT NOCOPY VARCHAR2
3135: ,p_tldv_rec IN okl_tld_pvt.tldv_rec_type

Line 3141: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

3137: )
3138: is
3139: l_api_name CONSTANT VARCHAR2(30) := 'additional_tld_attr';
3140: l_api_version CONSTANT NUMBER := 1.0;
3141: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3142: /*
3143: l_recv_inv_id NUMBER;
3144: CURSOR reverse_csr1(p_tld_id NUMBER) IS
3145: SELECT receivables_invoice_id

Line 3199: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3195: p_api_version,
3196: l_api_name,
3197: G_PKG_NAME ))
3198: THEN
3199: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3200: END IF;
3201:
3202: -- Initialize message list if requested
3203: IF (FND_API.to_Boolean(p_init_msg_list)) THEN

Line 3208: x_return_status := OKL_API.G_RET_STS_SUCCESS;

3204: FND_MSG_PUB.initialize;
3205: END IF;
3206:
3207: -- Initialize API status to success
3208: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3209:
3210:
3211: /*** Begin API body ****************************************************/
3212: -- assign all passed in attributes from IN to OUT record

Line 3276: WHEN OKL_API.G_EXCEPTION_ERROR THEN

3272: (p_count => x_msg_count,
3273: p_data => x_msg_data);
3274:
3275: EXCEPTION
3276: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3277: ROLLBACK TO additional_tld_attr;
3278: x_return_status := OKL_API.G_RET_STS_ERROR;
3279: FND_MSG_PUB.Count_And_Get
3280: (p_count => x_msg_count,

Line 3278: x_return_status := OKL_API.G_RET_STS_ERROR;

3274:
3275: EXCEPTION
3276: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3277: ROLLBACK TO additional_tld_attr;
3278: x_return_status := OKL_API.G_RET_STS_ERROR;
3279: FND_MSG_PUB.Count_And_Get
3280: (p_count => x_msg_count,
3281: p_data => x_msg_data);
3282:

Line 3283: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

3279: FND_MSG_PUB.Count_And_Get
3280: (p_count => x_msg_count,
3281: p_data => x_msg_data);
3282:
3283: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3284: ROLLBACK TO additional_tld_attr;
3285: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
3286: FND_MSG_PUB.Count_And_Get
3287: (p_count => x_msg_count,

Line 3285: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

3281: p_data => x_msg_data);
3282:
3283: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3284: ROLLBACK TO additional_tld_attr;
3285: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
3286: FND_MSG_PUB.Count_And_Get
3287: (p_count => x_msg_count,
3288: p_data => x_msg_data);
3289:

Line 3292: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;

3288: p_data => x_msg_data);
3289:
3290: WHEN OTHERS THEN
3291: ROLLBACK TO additional_tld_attr;
3292: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
3293: OKL_API.Set_Message(p_app_name => G_APP_NAME,
3294: p_msg_name => G_UNEXPECTED_ERROR,
3295: p_token1 => G_SQLCODE_TOKEN,
3296: p_token1_value => SQLCODE,

Line 3293: OKL_API.Set_Message(p_app_name => G_APP_NAME,

3289:
3290: WHEN OTHERS THEN
3291: ROLLBACK TO additional_tld_attr;
3292: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
3293: OKL_API.Set_Message(p_app_name => G_APP_NAME,
3294: p_msg_name => G_UNEXPECTED_ERROR,
3295: p_token1 => G_SQLCODE_TOKEN,
3296: p_token1_value => SQLCODE,
3297: p_token2 => G_SQLERRM_TOKEN,

Line 3456: OKL_API.SET_MESSAGE (

3452: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'trxid '||lp_taiv_rec.try_id);
3453:
3454: END IF;
3455: IF lp_taiv_rec.try_id IS NULL THEN
3456: OKL_API.SET_MESSAGE (
3457: p_app_name => 'OKL',
3458: p_msg_name => 'OKL_REQUIRED_VALUE',
3459: p_token1 => 'COL_NAME',
3460: p_token1_value => 'Transaction Type');

Line 3482: OKL_API.SET_MESSAGE (

3478: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'sty_id '||lp_tilv_rec.sty_id);
3479:
3480: END IF;
3481: IF lp_tilv_rec.sty_id IS NULL THEN
3482: OKL_API.SET_MESSAGE (
3483: p_app_name => 'OKL',
3484: p_msg_name => 'OKL_REQUIRED_VALUE',
3485: p_token1 => 'COL_NAME',
3486: p_token1_value => 'Transaction Type');

Line 3499: OKL_API.SET_MESSAGE (

3495: OPEN c_program_id(lp_taiv_rec.khr_id);
3496: FETCH c_program_id INTO l_program_id;
3497: CLOSE c_program_id;
3498: IF l_program_id IS NULL THEN
3499: OKL_API.SET_MESSAGE (
3500: p_app_name => 'OKL',
3501: p_msg_name => 'OKL_REQUIRED_VALUE',
3502: p_token1 => 'COL_NAME',
3503: p_token1_value => 'Vendor Program');

Line 3521: OKL_API.SET_MESSAGE (

3517: IF trunc(l_bill_to_address_id) IS NULL THEN
3518: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3519: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Retrieval of Bill To Address Id failed');
3520: END IF;
3521: OKL_API.SET_MESSAGE (
3522: p_app_name => 'OKL',
3523: p_msg_name => 'OKL_REQUIRED_VALUE',
3524: p_token1 => 'COL_NAME',
3525: p_token1_value => 'Bill To Address Id');

Line 3557: OKL_API.SET_MESSAGE (

3553:
3554:
3555: IF lp_taiv_rec.ixx_id IS NULL
3556: OR lp_taiv_rec.ixx_id = FND_API.G_MISS_NUM THEN
3557: OKL_API.SET_MESSAGE (
3558: p_app_name => 'OKL',
3559: p_msg_name => 'OKL_REQUIRED_VALUE',
3560: p_token1 => 'COL_NAME',
3561: p_token1_value => 'Customer Account Id');

Line 3567: OKL_API.SET_MESSAGE (

3563: END IF;
3564:
3565: IF lp_taiv_rec.ibt_id IS NULL
3566: OR lp_taiv_rec.ibt_id = FND_API.G_MISS_NUM THEN
3567: OKL_API.SET_MESSAGE (
3568: p_app_name => 'OKL',
3569: p_msg_name => 'OKL_REQUIRED_VALUE',
3570: p_token1 => 'COL_NAME',
3571: p_token1_value => 'Bill To Address Id');

Line 3577: OKL_API.SET_MESSAGE (

3573: END IF;
3574:
3575: IF lp_taiv_rec.irt_id IS NULL
3576: OR lp_taiv_rec.irt_id = FND_API.G_MISS_NUM THEN
3577: OKL_API.SET_MESSAGE (
3578: p_app_name => 'OKL',
3579: p_msg_name => 'OKL_REQUIRED_VALUE',
3580: p_token1 => 'COL_NAME',
3581: p_token1_value => 'Payment Term Id');

Line 3610: OKL_API.SET_MESSAGE (

3606: else
3607: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3608: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Retrieval of Payment Method Id failed');
3609: END IF;
3610: OKL_API.SET_MESSAGE (
3611: p_app_name => 'OKL',
3612: p_msg_name => 'OKL_REQUIRED_VALUE',
3613: p_token1 => 'COL_NAME',
3614: p_token1_value => 'Payment Method ');

Line 3627: OKL_API.SET_MESSAGE (

3623: OR lp_taiv_rec.irm_id = FND_API.G_MISS_NUM THEN
3624: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3625: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'receipt method id is not found');
3626: END IF;
3627: OKL_API.SET_MESSAGE (
3628: p_app_name => 'OKL',
3629: p_msg_name => 'OKL_REQUIRED_VALUE',
3630: p_token1 => 'COL_NAME',
3631: p_token1_value => 'receipt method id ');

Line 3764: ,p_init_msg_list => OKL_API.G_FALSE

3760:
3761:
3762: okl_internal_billing_pvt.Get_Invoice_format(
3763: p_api_version => 1.0
3764: ,p_init_msg_list => OKL_API.G_FALSE
3765: ,x_return_status => l_return_status
3766: ,x_msg_count => x_msg_count
3767: ,x_msg_data => x_msg_data
3768: ,p_inf_id => lp_taiv_rec.inf_id

Line 3774: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)

3770: ,x_invoice_format_type => lp_tldv_rec.invoice_format_type
3771: ,x_invoice_format_line_type => lp_tldv_rec.invoice_format_line_type);
3772: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_credit_memo : okl_internal_billing_pvt.Get_Invoice_format : '||l_return_status);
3773:
3774: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)
3775: THEN
3776: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
3777: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR)
3778: THEN

Line 3777: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR)

3773:
3774: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)
3775: THEN
3776: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
3777: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR)
3778: THEN
3779: RAISE Fnd_Api.G_EXC_ERROR;
3780: END IF;
3781:

Line 3784: p_init_msg_list => OKL_API.G_FALSE,

3780: END IF;
3781:
3782: additional_tld_attr(
3783: p_api_version => 1.0,
3784: p_init_msg_list => OKL_API.G_FALSE,
3785: x_return_status => l_return_status,
3786: x_msg_count => x_msg_count,
3787: x_msg_data => x_msg_data,
3788: p_tldv_rec => lp_tldv_rec,

Line 3793: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

3789: x_tldv_rec => xp_tldv_rec);
3790: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_credit_memo : additional_tld_attr : '||l_return_status);
3791: lp_tldv_rec := xp_tldv_rec;
3792:
3793: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3794: IF (l_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3795: x_return_status := l_return_status;
3796: END IF;
3797: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

Line 3794: IF (l_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN

3790: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_credit_memo : additional_tld_attr : '||l_return_status);
3791: lp_tldv_rec := xp_tldv_rec;
3792:
3793: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3794: IF (l_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3795: x_return_status := l_return_status;
3796: END IF;
3797: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
3798: END IF;

Line 3802: p_init_msg_list => OKL_API.G_FALSE,

3798: END IF;
3799:
3800: okl_tld_pvt.insert_row(
3801: p_api_version => 1.0,
3802: p_init_msg_list => OKL_API.G_FALSE,
3803: x_return_status => l_return_status,
3804: x_msg_count => x_msg_count,
3805: x_msg_data => x_msg_data,
3806: p_tldv_rec => lp_tldv_rec,

Line 3811: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

3807: x_tldv_rec => xp_tldv_rec);
3808:
3809: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_credit_memo : okl_tld_pvt.insert_row : '||l_return_status);
3810:
3811: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3812: IF (l_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3813: x_return_status := l_return_status;
3814: END IF;
3815: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

Line 3812: IF (l_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN

3808:
3809: okl_debug_pub.logmessage ('OKL_PAY_CURE_REFUNDS_PVT: create_credit_memo : okl_tld_pvt.insert_row : '||l_return_status);
3810:
3811: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3812: IF (l_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3813: x_return_status := l_return_status;
3814: END IF;
3815: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
3816: ELSE