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.OKS_BILLING_PUB dependencies on OKC_API

Line 230: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

226:
227: EXCEPTION
228: WHEN G_EXCEPTION_HALT_VALIDATION THEN
229: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error in Level Procedure --G_exception_halt_validation raised' || sqlerrm);
230: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
231: WHEN OTHERS THEN
232: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error in Level Procedure --OTHERS Exception raised' || sqlerrm);
233: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
234: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);

Line 233: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

229: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error in Level Procedure --G_exception_halt_validation raised' || sqlerrm);
230: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
231: WHEN OTHERS THEN
232: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error in Level Procedure --OTHERS Exception raised' || sqlerrm);
233: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
234: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
235:
236: END level;
237:

Line 234: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);

230: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
231: WHEN OTHERS THEN
232: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error in Level Procedure --OTHERS Exception raised' || sqlerrm);
233: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
234: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
235:
236: END level;
237:
238:

Line 277: x_Return_Status := OKC_API.G_RET_STS_SUCCESS;

273:
274: BEGIN
275: x_Volume := 0;
276: l_totvol := 0;
277: x_Return_Status := OKC_API.G_RET_STS_SUCCESS;
278:
279:
280: OPEN l_date_csr;
281: FETCH l_date_csr into l_date_billed_from,l_date_billed_to;

Line 297: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

293:
294: EXCEPTION
295: WHEN G_EXCEPTION_HALT_VALIDATION THEN
296: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error in OKS_REG_GET_AMCV -- G_Exception_halt_validation raised' );
297: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
298: WHEN OTHERS THEN
299: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error in OKS_REG_GET_AMCV -- Others Exception raised' );
300: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,
301: G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);

Line 300: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,

296: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error in OKS_REG_GET_AMCV -- G_Exception_halt_validation raised' );
297: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
298: WHEN OTHERS THEN
299: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error in OKS_REG_GET_AMCV -- Others Exception raised' );
300: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,
301: G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
302: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
303:
304:

Line 302: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

298: WHEN OTHERS THEN
299: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error in OKS_REG_GET_AMCV -- Others Exception raised' );
300: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,
301: G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
302: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
303:
304:
305:
306: END OKS_REG_GET_AMCV;

Line 1602: p_init_msg_list => okc_api.g_false,

1598: p_modifier_details (i).override_flag;
1599: l_in_tbl (1).updated_flag := p_modifier_details (i).updated_flag;
1600: okc_price_adjustment_pub.create_price_adjustment
1601: (p_api_version => 1.0,
1602: p_init_msg_list => okc_api.g_false,
1603: x_return_status => l_return_status,
1604: x_msg_count => l_msg_count,
1605: x_msg_data => l_msg_data,
1606: p_patv_tbl => l_in_tbl,

Line 1613: okc_api.set_message

1609:
1610: IF l_return_status <> 'S'
1611: THEN
1612: x_return_status := l_return_status;
1613: okc_api.set_message
1614: (g_app_name,
1615: g_required_value,
1616: g_col_name_token,
1617: 'Usage Modifier creation Error bsl id ' ||

Line 1684: P_INIT_MSG_LIST => OKC_API.G_TRUE,

1680:
1681: OKC_CONTRACT_PUB.update_contract_header(
1682: P_API_VERSION => l_api_version,
1683: X_RETURN_STATUS => l_return_status,
1684: P_INIT_MSG_LIST => OKC_API.G_TRUE,
1685: X_MSG_COUNT => l_msg_cnt,
1686: X_MSG_DATA => l_msg_data,
1687: P_RESTRICTED_UPDATE => OKC_API.G_TRUE,
1688: P_CHRV_REC => l_chrv_rec,

Line 1687: P_RESTRICTED_UPDATE => OKC_API.G_TRUE,

1683: X_RETURN_STATUS => l_return_status,
1684: P_INIT_MSG_LIST => OKC_API.G_TRUE,
1685: X_MSG_COUNT => l_msg_cnt,
1686: X_MSG_DATA => l_msg_data,
1687: P_RESTRICTED_UPDATE => OKC_API.G_TRUE,
1688: P_CHRV_REC => l_chrv_rec,
1689: X_CHRV_REC => l_chrv_out_rec);
1690:
1691: IF l_write_log THEN

Line 3433: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then

3429: P_BILLREP_ERR_TBL => p_billrep_err_tbl,
3430: P_BILLREP_ERR_TBL_IDX => p_billrep_err_tbl_idx
3431: );
3432:
3433: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then
3434: oks_bill_rec_pub.get_message (
3435: l_msg_cnt => l_msg_count,
3436: l_msg_data => l_msg_data);
3437: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => Failed in AR FEEDER :'||' '||usage_line_rec.line_id);

Line 5914: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then

5910: P_BILLREP_ERR_TBL => l_billrep_err_tbl,
5911: P_BILLREP_ERR_TBL_IDX => l_billrep_errtbl_idx
5912: );
5913:
5914: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then
5915: oks_bill_rec_pub.get_message (
5916: l_msg_cnt => l_msg_count,
5917: l_msg_data => l_msg_data);
5918: l_processed_lines_tbl(l_pr_tbl_idx).Billed_YN := 'N' ;

Line 6037: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

6033: ,p_line_from => P_process_from
6034: ,p_line_to => P_process_to
6035: ,x_return_status => l_return_status);
6036:
6037: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
6038: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_BILLING_PUB.Calculate_bill => *** Failed to create Billing Report ***' );
6039: END IF;
6040: End If;
6041:

Line 6054: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

6050:
6051: EXCEPTION
6052:
6053: WHEN G_EXCEPTION_HALT_VALIDATION THEN
6054: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
6055: RETCODE := 2;
6056: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => when g_exception_rollback raised'||sqlerrm);
6057: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
6058: WHEN G_EXCEPTION_ROLLBACK THEN

Line 6063: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

6059: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => when g_exception_rollback raised'||sqlerrm);
6060: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
6061:
6062: WHEN OTHERS THEN
6063: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
6064: RETCODE := 2;
6065: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => when others raised'||sqlerrm);
6066: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,
6067: G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);

Line 6066: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,

6062: WHEN OTHERS THEN
6063: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
6064: RETCODE := 2;
6065: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => when others raised'||sqlerrm);
6066: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,
6067: G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
6068: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
6069:
6070: END Calculate_bill;

Line 7243: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,

7239: WHEN OTHERS THEN
7240: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Supress credit completed with Errors');
7241: conc_ret_code := ERROR;
7242: RETCODE := 2;
7243: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,
7244: G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
7245: End Process_Suppress_Credits;
7246:
7247: End OKS_BILLING_PUB;