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_AUTO_CASH_APPL_RULES_PVT dependencies on OKC_API

Line 43: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE

39:
40: */
41: PROCEDURE auto_cashapp_for_arinv (
42: p_api_version IN NUMBER
43: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
44: ,x_return_status OUT NOCOPY VARCHAR2
45: ,x_msg_count OUT NOCOPY NUMBER
46: ,x_msg_data OUT NOCOPY VARCHAR2
47: ,p_customer_num IN VARCHAR2 DEFAULT NULL

Line 128: l_init_msg_list VARCHAR2(1) := Okc_Api.g_false;

124: l_under_payment OKL_CASH_ALLCTN_RLS.UNDER_PAYMENT_ALLOCATION_CODE%TYPE;
125: l_over_payment OKL_CASH_ALLCTN_RLS.OVER_PAYMENT_ALLOCATION_CODE%TYPE;
126: l_receipt_msmtch OKL_CASH_ALLCTN_RLS.RECEIPT_MSMTCH_ALLOCATION_CODE%TYPE;
127: l_api_version NUMBER := 1.0;
128: l_init_msg_list VARCHAR2(1) := Okc_Api.g_false;
129: l_return_status VARCHAR2(1);
130: l_msg_count NUMBER;
131: l_msg_data VARCHAR2(2000);
132:

Line 249: x_return_status:= OKC_API.G_RET_STS_SUCCESS;

245: BEGIN
246: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
247: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Cash Application Rules - AR Invoice Number - '||l_ar_inv_num);
248: END IF;
249: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
250: /* Begin - validate AR Invoice Reference and Org Id */
251: If p_arinv_number is Null and P_arinv_id Is Null Then
252: x_return_status := OKC_API.G_RET_STS_ERROR;
253: OKC_API.set_message( p_app_name => G_APP_NAME

Line 252: x_return_status := OKC_API.G_RET_STS_ERROR;

248: END IF;
249: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
250: /* Begin - validate AR Invoice Reference and Org Id */
251: If p_arinv_number is Null and P_arinv_id Is Null Then
252: x_return_status := OKC_API.G_RET_STS_ERROR;
253: OKC_API.set_message( p_app_name => G_APP_NAME
254: ,p_msg_name => 'OKL_REQUIRED_VALUE'
255: ,p_token1 => 'COL_NAME'
256: ,p_token1_value => 'Either p_arinv_number or P_arinv_id'

Line 253: OKC_API.set_message( p_app_name => G_APP_NAME

249: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
250: /* Begin - validate AR Invoice Reference and Org Id */
251: If p_arinv_number is Null and P_arinv_id Is Null Then
252: x_return_status := OKC_API.G_RET_STS_ERROR;
253: OKC_API.set_message( p_app_name => G_APP_NAME
254: ,p_msg_name => 'OKL_REQUIRED_VALUE'
255: ,p_token1 => 'COL_NAME'
256: ,p_token1_value => 'Either p_arinv_number or P_arinv_id'
257: );

Line 262: x_return_status := OKC_API.G_RET_STS_ERROR;

258: RAISE G_EXCEPTION_HALT_VALIDATION;
259: End If;
260:
261: If p_org_id Is Null Then
262: x_return_status := OKC_API.G_RET_STS_ERROR;
263: OKC_API.set_message( p_app_name => G_APP_NAME
264: ,p_msg_name => 'OKL_REQUIRED_VALUE'
265: ,p_token1 => 'COL_NAME'
266: ,p_token1_value => 'Org_Id'

Line 263: OKC_API.set_message( p_app_name => G_APP_NAME

259: End If;
260:
261: If p_org_id Is Null Then
262: x_return_status := OKC_API.G_RET_STS_ERROR;
263: OKC_API.set_message( p_app_name => G_APP_NAME
264: ,p_msg_name => 'OKL_REQUIRED_VALUE'
265: ,p_token1 => 'COL_NAME'
266: ,p_token1_value => 'Org_Id'
267: );

Line 685: x_return_status := OKC_API.G_RET_STS_ERROR;

681: -- only if total amount of prorated invoices is greater than receipt
682:
683: IF l_pro_rate_inv_total IS NULL OR l_pro_rate_inv_total = 0 THEN
684: -- Message Text: No prorated transaction types for contract.
685: x_return_status := OKC_API.G_RET_STS_ERROR;
686: OKC_API.set_message( p_app_name => G_APP_NAME
687: ,p_msg_name => 'OKL_BPD_DEF_NO_PRO'
688: );
689: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 686: OKC_API.set_message( p_app_name => G_APP_NAME

682:
683: IF l_pro_rate_inv_total IS NULL OR l_pro_rate_inv_total = 0 THEN
684: -- Message Text: No prorated transaction types for contract.
685: x_return_status := OKC_API.G_RET_STS_ERROR;
686: OKC_API.set_message( p_app_name => G_APP_NAME
687: ,p_msg_name => 'OKL_BPD_DEF_NO_PRO'
688: );
689: RAISE G_EXCEPTION_HALT_VALIDATION;
690: END IF;

Line 1221: x_return_status := OKC_API.G_RET_STS_ERROR;

1217: -- only if total amount of prorated invoices is greater than receipt
1218:
1219: IF l_pro_rate_inv_total IS NULL OR l_pro_rate_inv_total = 0 THEN
1220: -- Message Text: No prorated transaction types for contract.
1221: x_return_status := OKC_API.G_RET_STS_ERROR;
1222: OKC_API.set_message( p_app_name => G_APP_NAME
1223: ,p_msg_name => 'OKL_BPD_DEF_NO_PRO'
1224: );
1225: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1222: OKC_API.set_message( p_app_name => G_APP_NAME

1218:
1219: IF l_pro_rate_inv_total IS NULL OR l_pro_rate_inv_total = 0 THEN
1220: -- Message Text: No prorated transaction types for contract.
1221: x_return_status := OKC_API.G_RET_STS_ERROR;
1222: OKC_API.set_message( p_app_name => G_APP_NAME
1223: ,p_msg_name => 'OKL_BPD_DEF_NO_PRO'
1224: );
1225: RAISE G_EXCEPTION_HALT_VALIDATION;
1226: END IF;

Line 1461: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1457: x_return_status := OKL_API.G_RET_STS_ERROR;
1458: x_appl_tbl.delete;
1459:
1460: WHEN No_Open_Invoices_Exception THEN
1461: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1462: x_appl_tbl.delete;
1463:
1464: WHEN OTHERS THEN
1465: x_appl_tbl.DELETE;

Line 1483: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE

1479:
1480: --Identifies all invoice lines to be applied against for a given contract number
1481: --based on CAR setup for the contract
1482: PROCEDURE auto_cashapp_for_contract(p_api_version IN NUMBER
1483: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
1484: ,x_return_status OUT NOCOPY VARCHAR2
1485: ,x_msg_count OUT NOCOPY NUMBER
1486: ,x_msg_data OUT NOCOPY VARCHAR2
1487: ,p_customer_num IN VARCHAR2 DEFAULT NULL

Line 1662: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1658:
1659: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Contract is valid');
1660: IF (l_valid_contract = FALSE) THEN
1661: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Contract is not valid');
1662: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1663: RETURN;
1664: ELSE
1665: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Contract is valid');
1666: END IF;

Line 1699: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1695: CLOSE c_open_invoices_contract;
1696: END IF;
1697: IF (l_has_invoices = FALSE) THEN
1698: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Contract is having no open invoices');
1699: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1700: RETURN;
1701: ELSE
1702: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Contract is having open invoices');
1703: END IF;

Line 2072: --x_return_status := OKC_API.G_RET_STS_ERROR;

2068: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_pro_rate_inv_total: '||l_pro_rate_inv_total);
2069: END IF;
2070: IF l_pro_rate_inv_total IS NULL OR l_pro_rate_inv_total = 0 THEN
2071: -- Message Text: No prorated transaction types
2072: --x_return_status := OKC_API.G_RET_STS_ERROR;
2073: --OKC_API.set_message( p_app_name => G_APP_NAME,
2074: -- p_msg_name => 'OKL_BPD_NO_PRORATED_STRMS');
2075: --RAISE OKL_API.G_EXCEPTION_ERROR;
2076: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Pro-rate invoice total is zero or null');

Line 2073: --OKC_API.set_message( p_app_name => G_APP_NAME,

2069: END IF;
2070: IF l_pro_rate_inv_total IS NULL OR l_pro_rate_inv_total = 0 THEN
2071: -- Message Text: No prorated transaction types
2072: --x_return_status := OKC_API.G_RET_STS_ERROR;
2073: --OKC_API.set_message( p_app_name => G_APP_NAME,
2074: -- p_msg_name => 'OKL_BPD_NO_PRORATED_STRMS');
2075: --RAISE OKL_API.G_EXCEPTION_ERROR;
2076: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Pro-rate invoice total is zero or null');
2077: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 2077: x_return_status := OKC_API.G_RET_STS_SUCCESS;

2073: --OKC_API.set_message( p_app_name => G_APP_NAME,
2074: -- p_msg_name => 'OKL_BPD_NO_PRORATED_STRMS');
2075: --RAISE OKL_API.G_EXCEPTION_ERROR;
2076: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Pro-rate invoice total is zero or null');
2077: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2078: x_appl_tbl.delete;
2079: RETURN;
2080: END IF;
2081:

Line 2306: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE

2302:
2303: --Receipt mismatch which will identify all the invoice lines
2304: --for the given customer based on CAR setup i.e. Newest invoices or Oldest invoices
2305: PROCEDURE receipt_mismatch(p_api_version IN NUMBER
2306: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
2307: ,x_return_status OUT NOCOPY VARCHAR2
2308: ,x_msg_count OUT NOCOPY NUMBER
2309: ,x_msg_data OUT NOCOPY VARCHAR2
2310: ,p_customer_num IN VARCHAR2 DEFAULT NULL

Line 2817: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE

2813: /* sosharma 30-jul-2007
2814: Added proceudure to handle cash application rules on consolidated Invoices
2815: */
2816: PROCEDURE auto_cashapp_for_consinv ( p_api_version IN NUMBER
2817: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
2818: ,x_return_status OUT NOCOPY VARCHAR2
2819: ,x_msg_count OUT NOCOPY NUMBER
2820: ,x_msg_data OUT NOCOPY VARCHAR2
2821: ,p_customer_num IN VARCHAR2 DEFAULT NULL

Line 2927: l_init_msg_list VARCHAR2(1) := Okc_Api.g_false;

2923:
2924: l_valid_yn VARCHAR2(1);
2925:
2926: l_api_version NUMBER := 1.0;
2927: l_init_msg_list VARCHAR2(1) := Okc_Api.g_false;
2928: l_return_status VARCHAR2(1);
2929: l_msg_count NUMBER;
2930: l_msg_data VARCHAR2(2000);
2931:

Line 3073: x_return_status := OKC_API.G_RET_STS_SUCCESS;

3069:
3070: OPEN valid_consinv(l_cons_inv);
3071: FETCH valid_consinv into l_cons_bill_id;
3072: IF l_cons_bill_id IS NULL THEN
3073: x_return_status := OKC_API.G_RET_STS_SUCCESS;
3074: RETURN;
3075: END IF;
3076: CLOSE valid_consinv;
3077:

Line 3528: x_return_status := OKC_API.G_RET_STS_ERROR;

3524:
3525: IF l_pro_rate_inv_total IS NULL OR l_pro_rate_inv_total = 0 THEN
3526:
3527: -- Message Text: No prorated transaction types for contract.
3528: x_return_status := OKC_API.G_RET_STS_ERROR;
3529:
3530: OKC_API.set_message( p_app_name => G_APP_NAME
3531: ,p_msg_name => 'OKL_BPD_DEF_NO_PRO'
3532: );

Line 3530: OKC_API.set_message( p_app_name => G_APP_NAME

3526:
3527: -- Message Text: No prorated transaction types for contract.
3528: x_return_status := OKC_API.G_RET_STS_ERROR;
3529:
3530: OKC_API.set_message( p_app_name => G_APP_NAME
3531: ,p_msg_name => 'OKL_BPD_DEF_NO_PRO'
3532: );
3533:
3534: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 4021: x_return_status := OKC_API.G_RET_STS_ERROR;

4017:
4018: IF l_pro_rate_inv_total IS NULL OR l_pro_rate_inv_total = 0 THEN
4019:
4020: -- Message Text: No prorated transaction types
4021: x_return_status := OKC_API.G_RET_STS_ERROR;
4022: OKC_API.set_message( p_app_name => G_APP_NAME,
4023: p_msg_name => 'OKL_BPD_NO_PRORATED_STRMS');
4024:
4025: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 4022: OKC_API.set_message( p_app_name => G_APP_NAME,

4018: IF l_pro_rate_inv_total IS NULL OR l_pro_rate_inv_total = 0 THEN
4019:
4020: -- Message Text: No prorated transaction types
4021: x_return_status := OKC_API.G_RET_STS_ERROR;
4022: OKC_API.set_message( p_app_name => G_APP_NAME,
4023: p_msg_name => 'OKL_BPD_NO_PRORATED_STRMS');
4024:
4025: RAISE G_EXCEPTION_HALT_VALIDATION;
4026: