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 2066: --x_return_status := OKC_API.G_RET_STS_ERROR;

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

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

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

Line 2071: x_return_status := OKC_API.G_RET_STS_SUCCESS;

2067: --OKC_API.set_message( p_app_name => G_APP_NAME,
2068: -- p_msg_name => 'OKL_BPD_NO_PRORATED_STRMS');
2069: --RAISE OKL_API.G_EXCEPTION_ERROR;
2070: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Pro-rate invoice total is zero or null');
2071: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2072: x_appl_tbl.delete;
2073: RETURN;
2074: END IF;
2075:

Line 2300: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE

2296:
2297: --Receipt mismatch which will identify all the invoice lines
2298: --for the given customer based on CAR setup i.e. Newest invoices or Oldest invoices
2299: PROCEDURE receipt_mismatch(p_api_version IN NUMBER
2300: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
2301: ,x_return_status OUT NOCOPY VARCHAR2
2302: ,x_msg_count OUT NOCOPY NUMBER
2303: ,x_msg_data OUT NOCOPY VARCHAR2
2304: ,p_customer_num IN VARCHAR2 DEFAULT NULL

Line 2807: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE

2803: /* sosharma 30-jul-2007
2804: Added proceudure to handle cash application rules on consolidated Invoices
2805: */
2806: PROCEDURE auto_cashapp_for_consinv ( p_api_version IN NUMBER
2807: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
2808: ,x_return_status OUT NOCOPY VARCHAR2
2809: ,x_msg_count OUT NOCOPY NUMBER
2810: ,x_msg_data OUT NOCOPY VARCHAR2
2811: ,p_customer_num IN VARCHAR2 DEFAULT NULL

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

2913:
2914: l_valid_yn VARCHAR2(1);
2915:
2916: l_api_version NUMBER := 1.0;
2917: l_init_msg_list VARCHAR2(1) := Okc_Api.g_false;
2918: l_return_status VARCHAR2(1);
2919: l_msg_count NUMBER;
2920: l_msg_data VARCHAR2(2000);
2921:

Line 3063: x_return_status := OKC_API.G_RET_STS_SUCCESS;

3059:
3060: OPEN valid_consinv(l_cons_inv);
3061: FETCH valid_consinv into l_cons_bill_id;
3062: IF l_cons_bill_id IS NULL THEN
3063: x_return_status := OKC_API.G_RET_STS_SUCCESS;
3064: RETURN;
3065: END IF;
3066: CLOSE valid_consinv;
3067:

Line 3518: x_return_status := OKC_API.G_RET_STS_ERROR;

3514:
3515: IF l_pro_rate_inv_total IS NULL OR l_pro_rate_inv_total = 0 THEN
3516:
3517: -- Message Text: No prorated transaction types for contract.
3518: x_return_status := OKC_API.G_RET_STS_ERROR;
3519:
3520: OKC_API.set_message( p_app_name => G_APP_NAME
3521: ,p_msg_name => 'OKL_BPD_DEF_NO_PRO'
3522: );

Line 3520: OKC_API.set_message( p_app_name => G_APP_NAME

3516:
3517: -- Message Text: No prorated transaction types for contract.
3518: x_return_status := OKC_API.G_RET_STS_ERROR;
3519:
3520: OKC_API.set_message( p_app_name => G_APP_NAME
3521: ,p_msg_name => 'OKL_BPD_DEF_NO_PRO'
3522: );
3523:
3524: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 4011: x_return_status := OKC_API.G_RET_STS_ERROR;

4007:
4008: IF l_pro_rate_inv_total IS NULL OR l_pro_rate_inv_total = 0 THEN
4009:
4010: -- Message Text: No prorated transaction types
4011: x_return_status := OKC_API.G_RET_STS_ERROR;
4012: OKC_API.set_message( p_app_name => G_APP_NAME,
4013: p_msg_name => 'OKL_BPD_NO_PRORATED_STRMS');
4014:
4015: RAISE G_EXCEPTION_HALT_VALIDATION;

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

4008: IF l_pro_rate_inv_total IS NULL OR l_pro_rate_inv_total = 0 THEN
4009:
4010: -- Message Text: No prorated transaction types
4011: x_return_status := OKC_API.G_RET_STS_ERROR;
4012: OKC_API.set_message( p_app_name => G_APP_NAME,
4013: p_msg_name => 'OKL_BPD_NO_PRORATED_STRMS');
4014:
4015: RAISE G_EXCEPTION_HALT_VALIDATION;
4016: