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_BILL_REC_PUB dependencies on FND_FILE

Line 98: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error Message = '||l_msg_data);

94: p_encoded => 'F',
95: p_data => l_msg_data,
96: p_msg_index_out => l_msg_index_out);
97:
98: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error Message = '||l_msg_data);
99: END LOOP;
100: END IF;
101: END get_message;
102:

Line 2736: FND_FILE.PUT_LINE( FND_FILE.LOG, 'AR API returns with failure');

2732:
2733:
2734:
2735: IF (x_bank_account_id IS NULL) THEN
2736: FND_FILE.PUT_LINE( FND_FILE.LOG, 'AR API returns with failure');
2737: x_status := 'E';
2738: Raise G_EXCEPTION_HALT_VALIDATION;
2739: ELSE
2740:

Line 2775: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error in getting bank account for line '||line_cur.line_id);

2771: p_bank_account_uses_id => x_bank_account_uses_id
2772: );
2773:
2774: IF (x_bank_account_id IS NULL) THEN
2775: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error in getting bank account for line '||line_cur.line_id);
2776: x_status := 'E';
2777: Raise G_EXCEPTION_HALT_VALIDATION;
2778: ELSE
2779: UPDATE oks_k_lines_b

Line 5665: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error in OKS_REG_GET_AMCV -- G_Exception_halt_validation raised' );

5661: x_Volume := l_TotVol / l_prddays;
5662:
5663: EXCEPTION
5664: WHEN G_EXCEPTION_HALT_VALIDATION THEN
5665: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error in OKS_REG_GET_AMCV -- G_Exception_halt_validation raised' );
5666: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
5667: WHEN OTHERS THEN
5668: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error in OKS_REG_GET_AMCV -- Others Exception raised' );
5669: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,

Line 5668: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error in OKS_REG_GET_AMCV -- Others Exception raised' );

5664: WHEN G_EXCEPTION_HALT_VALIDATION THEN
5665: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error in OKS_REG_GET_AMCV -- G_Exception_halt_validation raised' );
5666: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
5667: WHEN OTHERS THEN
5668: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error in OKS_REG_GET_AMCV -- Others Exception raised' );
5669: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,
5670: G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
5671: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
5672:

Line 6767: FND_FILE.PUT_LINE(FND_FILE.LOG, 'counter '||l_counter_qty);

6763: X_base_reading := nvl(l_qty,0) ;
6764: END IF;
6765: END IF;
6766:
6767: FND_FILE.PUT_LINE(FND_FILE.LOG, 'counter '||l_counter_qty);
6768: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_qty '||l_qty);
6769: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_init '||l_init);
6770: X_start_reading := nvl(l_end_read,l_init);
6771: /* Counter values should not be honored till it is greater than intial reading */

Line 6768: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_qty '||l_qty);

6764: END IF;
6765: END IF;
6766:
6767: FND_FILE.PUT_LINE(FND_FILE.LOG, 'counter '||l_counter_qty);
6768: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_qty '||l_qty);
6769: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_init '||l_init);
6770: X_start_reading := nvl(l_end_read,l_init);
6771: /* Counter values should not be honored till it is greater than intial reading */
6772: IF ( nvl(l_counter_qty,0) < nvl(l_init,0)) THEN

Line 6769: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_init '||l_init);

6765: END IF;
6766:
6767: FND_FILE.PUT_LINE(FND_FILE.LOG, 'counter '||l_counter_qty);
6768: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_qty '||l_qty);
6769: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_init '||l_init);
6770: X_start_reading := nvl(l_end_read,l_init);
6771: /* Counter values should not be honored till it is greater than intial reading */
6772: IF ( nvl(l_counter_qty,0) < nvl(l_init,0)) THEN
6773: X_end_reading := nvl(l_end_read,nvl(l_init,0));

Line 6874: --FND_FILE.PUT_LINE(FND_FILE.LOG,'bill_amount '||l_bill_amount);

6870: ELSE
6871: l_bill_amount := (p_con_amount - (l_prorate_amount * l_diff))/l_num_of_full_periods;
6872: END IF;
6873:
6874: --FND_FILE.PUT_LINE(FND_FILE.LOG,'bill_amount '||l_bill_amount);
6875:
6876: IF (p_stat = Null) THEN
6877: x_amount := Null;
6878: END If;

Line 7967: FND_FILE.PUT_LINE( FND_FILE.LOG,(FND_MSG_PUB.Get(p_encoded =>FND_API.G_FALSE )));

7963: ELSE
7964: x_return_status := l_return_status;
7965: FOR I IN 1..FND_MSG_PUB.Count_Msg
7966: LOOP
7967: FND_FILE.PUT_LINE( FND_FILE.LOG,(FND_MSG_PUB.Get(p_encoded =>FND_API.G_FALSE )));
7968: END LOOP;
7969: END If;
7970: ELSIf l_return_status = OKC_API.G_RET_STS_SUCCESS Then
7971: Open get_bcl_id_cur(l_billed_cle_id, l_date_billed_to) ;

Line 8035: FND_FILE.PUT_LINE( FND_FILE.LOG, 'after insert into sublines '||' '||l_return_status );

8031: p_msg_count => l_msg_count ,
8032: p_msg_data => l_msg_data
8033: );
8034:
8035: FND_FILE.PUT_LINE( FND_FILE.LOG, 'after insert into sublines '||' '||l_return_status );
8036:
8037: If (l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then
8038: If (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) Then
8039: x_return_status := l_return_status;

Line 8040: FND_FILE.PUT_LINE( FND_FILE.LOG, 'insert into table failed Contract line id :'||' '||l_bill_rec.id);

8036:
8037: If (l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then
8038: If (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) Then
8039: x_return_status := l_return_status;
8040: FND_FILE.PUT_LINE( FND_FILE.LOG, 'insert into table failed Contract line id :'||' '||l_bill_rec.id);
8041: l_error := 'T';
8042: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
8043: raise G_EXCEPTION_HALT_VALIDATION;
8044: ELSE

Line 8048: FND_FILE.PUT_LINE( FND_FILE.LOG,(FND_MSG_PUB.Get(p_encoded =>FND_API.G_FALSE )));

8044: ELSE
8045: x_return_status := l_return_status;
8046: FOR I IN 1..FND_MSG_PUB.Count_Msg
8047: LOOP
8048: FND_FILE.PUT_LINE( FND_FILE.LOG,(FND_MSG_PUB.Get(p_encoded =>FND_API.G_FALSE )));
8049: END LOOP;
8050:
8051: FND_FILE.PUT_LINE( FND_FILE.LOG, 'insert into table failed Contract line id :'||' '||l_bill_rec.id);
8052: l_error := 'T';

Line 8051: FND_FILE.PUT_LINE( FND_FILE.LOG, 'insert into table failed Contract line id :'||' '||l_bill_rec.id);

8047: LOOP
8048: FND_FILE.PUT_LINE( FND_FILE.LOG,(FND_MSG_PUB.Get(p_encoded =>FND_API.G_FALSE )));
8049: END LOOP;
8050:
8051: FND_FILE.PUT_LINE( FND_FILE.LOG, 'insert into table failed Contract line id :'||' '||l_bill_rec.id);
8052: l_error := 'T';
8053: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
8054: END If;
8055: End If;

Line 10832: --FND_FILE.PUT_LINE( FND_FILE.LOG,'l_usage_quantity '||l_usage_quantity);

10828: p_period_type => p_period_type,
10829: p_round_dec => 18
10830: );
10831:
10832: --FND_FILE.PUT_LINE( FND_FILE.LOG,'l_usage_quantity '||l_usage_quantity);
10833: IF l_usage_quantity <= 0 THEN
10834: RAISE G_EXCEPTION_HALT_VALIDATION;
10835: END IF;
10836:

Line 10838: --FND_FILE.PUT_LINE( FND_FILE.LOG,'l_prorated_qty '||l_prorated_qty);

10834: RAISE G_EXCEPTION_HALT_VALIDATION;
10835: END IF;
10836:
10837: l_prorated_qty := p_qty * l_usage_quantity;
10838: --FND_FILE.PUT_LINE( FND_FILE.LOG,'l_prorated_qty '||l_prorated_qty);
10839: RETURN l_prorated_qty;
10840:
10841: EXCEPTION
10842: WHEN INVALID_PERIOD_TYPE_EXCEPTION THEN

Line 10843: FND_FILE.PUT_LINE( FND_FILE.LOG,'Invalid Period type '||p_period_type);

10839: RETURN l_prorated_qty;
10840:
10841: EXCEPTION
10842: WHEN INVALID_PERIOD_TYPE_EXCEPTION THEN
10843: FND_FILE.PUT_LINE( FND_FILE.LOG,'Invalid Period type '||p_period_type);
10844: return NULL;
10845: WHEN INVALID_UOM_EXCEPTION THEN
10846: FND_FILE.PUT_LINE( FND_FILE.LOG,'Invalid unit of measure code');
10847: IF cs_validate_uom%ISOPEN THEN

Line 10846: FND_FILE.PUT_LINE( FND_FILE.LOG,'Invalid unit of measure code');

10842: WHEN INVALID_PERIOD_TYPE_EXCEPTION THEN
10843: FND_FILE.PUT_LINE( FND_FILE.LOG,'Invalid Period type '||p_period_type);
10844: return NULL;
10845: WHEN INVALID_UOM_EXCEPTION THEN
10846: FND_FILE.PUT_LINE( FND_FILE.LOG,'Invalid unit of measure code');
10847: IF cs_validate_uom%ISOPEN THEN
10848: CLOSE cs_validate_uom;
10849: END IF;
10850: return NULL;

Line 10852: FND_FILE.PUT_LINE( FND_FILE.LOG,'Invalid Effective Dates');

10848: CLOSE cs_validate_uom;
10849: END IF;
10850: return NULL;
10851: WHEN INVALID_DATE_EXCEPTION THEN
10852: FND_FILE.PUT_LINE( FND_FILE.LOG,'Invalid Effective Dates');
10853: return NULL;
10854: WHEN G_EXCEPTION_HALT_VALIDATION THEN
10855: FND_MSG_PUB.Count_And_Get
10856: (

Line 10860: FND_FILE.PUT_LINE( FND_FILE.LOG,'x_msg_count '||x_msg_count||'x_msg_data: '||x_msg_data);

10856: (
10857: p_count => x_msg_count,
10858: p_data => x_msg_data
10859: );
10860: FND_FILE.PUT_LINE( FND_FILE.LOG,'x_msg_count '||x_msg_count||'x_msg_data: '||x_msg_data);
10861: RETURN NULL;
10862: WHEN OTHERS THEN
10863: --set the error message and return with NULL to notify the
10864: --caller of error

Line 10865: FND_FILE.PUT_LINE( FND_FILE.LOG,'sqlcode '||sqlcode||' with error message '||sqlerrm);

10861: RETURN NULL;
10862: WHEN OTHERS THEN
10863: --set the error message and return with NULL to notify the
10864: --caller of error
10865: FND_FILE.PUT_LINE( FND_FILE.LOG,'sqlcode '||sqlcode||' with error message '||sqlerrm);
10866: RETURN NULL;
10867: END Get_Prorated_Usage_Qty;
10868: -------------------------------------------------------------------------
10869: