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 100: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error Message = '||l_msg_data);

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

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

2746:
2747:
2748:
2749: IF (x_bank_account_id IS NULL) THEN
2750: FND_FILE.PUT_LINE( FND_FILE.LOG, 'AR API returns with failure');
2751: x_status := 'E';
2752: Raise G_EXCEPTION_HALT_VALIDATION;
2753: ELSE
2754:

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

2785: p_bank_account_uses_id => x_bank_account_uses_id
2786: );
2787:
2788: IF (x_bank_account_id IS NULL) THEN
2789: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error in getting bank account for line '||line_cur.line_id);
2790: x_status := 'E';
2791: Raise G_EXCEPTION_HALT_VALIDATION;
2792: ELSE
2793: UPDATE oks_k_lines_b

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

5687: x_Volume := l_TotVol / l_prddays;
5688:
5689: EXCEPTION
5690: WHEN G_EXCEPTION_HALT_VALIDATION THEN
5691: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error in OKS_REG_GET_AMCV -- G_Exception_halt_validation raised' );
5692: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
5693: WHEN OTHERS THEN
5694: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error in OKS_REG_GET_AMCV -- Others Exception raised' );
5695: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,

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

5690: WHEN G_EXCEPTION_HALT_VALIDATION THEN
5691: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error in OKS_REG_GET_AMCV -- G_Exception_halt_validation raised' );
5692: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
5693: WHEN OTHERS THEN
5694: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error in OKS_REG_GET_AMCV -- Others Exception raised' );
5695: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,
5696: G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
5697: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
5698:

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

6793: END IF;
6794: END IF;
6795:
6796: IF G_LOG_YES_NO = 'YES' THEN --- g_log_yes_no added by ansraj for 14016663
6797: FND_FILE.PUT_LINE(FND_FILE.LOG, 'counter '||l_counter_qty);
6798: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_qty '||l_qty);
6799: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_init '||l_init);
6800: END IF;
6801:

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

6794: END IF;
6795:
6796: IF G_LOG_YES_NO = 'YES' THEN --- g_log_yes_no added by ansraj for 14016663
6797: FND_FILE.PUT_LINE(FND_FILE.LOG, 'counter '||l_counter_qty);
6798: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_qty '||l_qty);
6799: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_init '||l_init);
6800: END IF;
6801:
6802: X_start_reading := nvl(l_end_read,l_init);

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

6795:
6796: IF G_LOG_YES_NO = 'YES' THEN --- g_log_yes_no added by ansraj for 14016663
6797: FND_FILE.PUT_LINE(FND_FILE.LOG, 'counter '||l_counter_qty);
6798: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_qty '||l_qty);
6799: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_init '||l_init);
6800: END IF;
6801:
6802: X_start_reading := nvl(l_end_read,l_init);
6803: /* Counter values should not be honored till it is greater than intial reading */

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

6902: ELSE
6903: l_bill_amount := (p_con_amount - (l_prorate_amount * l_diff))/l_num_of_full_periods;
6904: END IF;
6905:
6906: --FND_FILE.PUT_LINE(FND_FILE.LOG,'bill_amount '||l_bill_amount);
6907:
6908: IF (p_stat = Null) THEN
6909: x_amount := Null;
6910: END If;

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

7995: ELSE
7996: x_return_status := l_return_status;
7997: FOR I IN 1..FND_MSG_PUB.Count_Msg
7998: LOOP
7999: FND_FILE.PUT_LINE( FND_FILE.LOG,(FND_MSG_PUB.Get(p_encoded =>FND_API.G_FALSE )));
8000: END LOOP;
8001: END If;
8002: ELSIf l_return_status = OKC_API.G_RET_STS_SUCCESS Then
8003: Open get_bcl_id_cur(l_billed_cle_id, l_date_billed_to) ;

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

8063: p_msg_count => l_msg_count ,
8064: p_msg_data => l_msg_data
8065: );
8066:
8067: FND_FILE.PUT_LINE( FND_FILE.LOG, 'after insert into sublines '||' '||l_return_status );
8068:
8069: If (l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then
8070: If (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) Then
8071: x_return_status := l_return_status;

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

8068:
8069: If (l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then
8070: If (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) Then
8071: x_return_status := l_return_status;
8072: FND_FILE.PUT_LINE( FND_FILE.LOG, 'insert into table failed Contract line id :'||' '||l_bill_rec.id);
8073: l_error := 'T';
8074: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
8075: raise G_EXCEPTION_HALT_VALIDATION;
8076: ELSE

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

8076: ELSE
8077: x_return_status := l_return_status;
8078: FOR I IN 1..FND_MSG_PUB.Count_Msg
8079: LOOP
8080: FND_FILE.PUT_LINE( FND_FILE.LOG,(FND_MSG_PUB.Get(p_encoded =>FND_API.G_FALSE )));
8081: END LOOP;
8082:
8083: FND_FILE.PUT_LINE( FND_FILE.LOG, 'insert into table failed Contract line id :'||' '||l_bill_rec.id);
8084: l_error := 'T';

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

8079: LOOP
8080: FND_FILE.PUT_LINE( FND_FILE.LOG,(FND_MSG_PUB.Get(p_encoded =>FND_API.G_FALSE )));
8081: END LOOP;
8082:
8083: FND_FILE.PUT_LINE( FND_FILE.LOG, 'insert into table failed Contract line id :'||' '||l_bill_rec.id);
8084: l_error := 'T';
8085: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
8086: END If;
8087: End If;

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

10977: p_period_type => p_period_type,
10978: p_round_dec => 18
10979: );
10980:
10981: --FND_FILE.PUT_LINE( FND_FILE.LOG,'l_usage_quantity '||l_usage_quantity);
10982: IF l_usage_quantity <= 0 THEN
10983: RAISE G_EXCEPTION_HALT_VALIDATION;
10984: END IF;
10985:

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

10983: RAISE G_EXCEPTION_HALT_VALIDATION;
10984: END IF;
10985:
10986: l_prorated_qty := p_qty * l_usage_quantity;
10987: --FND_FILE.PUT_LINE( FND_FILE.LOG,'l_prorated_qty '||l_prorated_qty);
10988: RETURN l_prorated_qty;
10989:
10990: EXCEPTION
10991: WHEN INVALID_PERIOD_TYPE_EXCEPTION THEN

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

10988: RETURN l_prorated_qty;
10989:
10990: EXCEPTION
10991: WHEN INVALID_PERIOD_TYPE_EXCEPTION THEN
10992: FND_FILE.PUT_LINE( FND_FILE.LOG,'Invalid Period type '||p_period_type);
10993: return NULL;
10994: WHEN INVALID_UOM_EXCEPTION THEN
10995: FND_FILE.PUT_LINE( FND_FILE.LOG,'Invalid unit of measure code');
10996: IF cs_validate_uom%ISOPEN THEN

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

10991: WHEN INVALID_PERIOD_TYPE_EXCEPTION THEN
10992: FND_FILE.PUT_LINE( FND_FILE.LOG,'Invalid Period type '||p_period_type);
10993: return NULL;
10994: WHEN INVALID_UOM_EXCEPTION THEN
10995: FND_FILE.PUT_LINE( FND_FILE.LOG,'Invalid unit of measure code');
10996: IF cs_validate_uom%ISOPEN THEN
10997: CLOSE cs_validate_uom;
10998: END IF;
10999: return NULL;

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

10997: CLOSE cs_validate_uom;
10998: END IF;
10999: return NULL;
11000: WHEN INVALID_DATE_EXCEPTION THEN
11001: FND_FILE.PUT_LINE( FND_FILE.LOG,'Invalid Effective Dates');
11002: return NULL;
11003: WHEN G_EXCEPTION_HALT_VALIDATION THEN
11004: FND_MSG_PUB.Count_And_Get
11005: (

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

11005: (
11006: p_count => x_msg_count,
11007: p_data => x_msg_data
11008: );
11009: FND_FILE.PUT_LINE( FND_FILE.LOG,'x_msg_count '||x_msg_count||'x_msg_data: '||x_msg_data);
11010: RETURN NULL;
11011: WHEN OTHERS THEN
11012: --set the error message and return with NULL to notify the
11013: --caller of error

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

11010: RETURN NULL;
11011: WHEN OTHERS THEN
11012: --set the error message and return with NULL to notify the
11013: --caller of error
11014: FND_FILE.PUT_LINE( FND_FILE.LOG,'sqlcode '||sqlcode||' with error message '||sqlerrm);
11015: RETURN NULL;
11016: END Get_Prorated_Usage_Qty;
11017: -------------------------------------------------------------------------
11018: