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

Line 2306: FND_FILE.PUT_LINE( FND_FILE.LOG, '*** Billing Report:: delete_duplicate_lines Error ' || sqlerrm);

2302:
2303: Exception When Others Then
2304:
2305: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2306: FND_FILE.PUT_LINE( FND_FILE.LOG, '*** Billing Report:: delete_duplicate_lines Error ' || sqlerrm);
2307:
2308: OKC_API.SET_MESSAGE
2309: (P_App_Name => G_APP_NAME
2310: ,P_Msg_Name => G_UNEXPECTED_ERROR

Line 2356: FND_FILE.PUT_LINE( FND_FILE.LOG, '*** Billing Report:: delete_duplicate_sub_lines Error ' || sqlerrm);

2352: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2353:
2354: Exception When Others Then
2355:
2356: FND_FILE.PUT_LINE( FND_FILE.LOG, '*** Billing Report:: delete_duplicate_sub_lines Error ' || sqlerrm);
2357: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2358:
2359: OKC_API.SET_MESSAGE
2360: (P_App_Name => G_APP_NAME

Line 2419: FND_FILE.PUT_LINE( FND_FILE.LOG, '*** Billing Report:: sort_lines_table Error ' || sqlerrm);

2415: x_lines_table := l_lines_tbl_tmp ;
2416: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2417:
2418: Exception When Others Then
2419: FND_FILE.PUT_LINE( FND_FILE.LOG, '*** Billing Report:: sort_lines_table Error ' || sqlerrm);
2420: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2421: OKC_API.SET_MESSAGE
2422: (P_App_Name => G_APP_NAME
2423: ,P_Msg_Name => G_UNEXPECTED_ERROR

Line 2485: FND_FILE.PUT_LINE( FND_FILE.LOG, '*** Billing Report:: sort_sub_lines_table Error ' || sqlerrm);

2481: x_sub_lines_table := l_sub_lines_tbl_tmp ;
2482: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2483:
2484: Exception When Others Then
2485: FND_FILE.PUT_LINE( FND_FILE.LOG, '*** Billing Report:: sort_sub_lines_table Error ' || sqlerrm);
2486: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2487: OKC_API.SET_MESSAGE
2488: (P_App_Name => G_APP_NAME
2489: ,P_Msg_Name => G_UNEXPECTED_ERROR

Line 2544: FND_FILE.PUT_LINE( FND_FILE.LOG, '*** Billing Report:: sub_lines_bill_status Error ' || sqlerrm);

2540: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2541:
2542: Exception When Others Then
2543: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2544: FND_FILE.PUT_LINE( FND_FILE.LOG, '*** Billing Report:: sub_lines_bill_status Error ' || sqlerrm);
2545: OKC_API.SET_MESSAGE
2546: (P_App_Name => G_APP_NAME
2547: ,P_Msg_Name => G_UNEXPECTED_ERROR
2548: ,P_Token1 => G_SQLCODE_TOKEN

Line 2613: FND_FILE.PUT_LINE( FND_FILE.LOG, '*** Billing Report:: Get_Billig_Profile Error ' || sqlerrm);

2609:
2610: Return (l_bill_profile);
2611:
2612: Exception When Others then
2613: FND_FILE.PUT_LINE( FND_FILE.LOG, '*** Billing Report:: Get_Billig_Profile Error ' || sqlerrm);
2614: Return(OKC_API.G_RET_STS_UNEXP_ERROR );
2615: OKC_API.SET_MESSAGE
2616: (P_App_Name => G_APP_NAME
2617: ,P_Msg_Name => G_UNEXPECTED_ERROR

Line 2691: FND_FILE.PUT_LINE( FND_FILE.LOG, '*** Billing Report:: Set_Billing_Profile Error ' || sqlerrm);

2687:
2688:
2689: Exception When Others Then
2690: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR ;
2691: FND_FILE.PUT_LINE( FND_FILE.LOG, '*** Billing Report:: Set_Billing_Profile Error ' || sqlerrm);
2692: OKC_API.SET_MESSAGE
2693: (P_App_Name => G_APP_NAME
2694: ,P_Msg_Name => G_UNEXPECTED_ERROR
2695: ,P_Token1 => G_SQLCODE_TOKEN

Line 2802: FND_FILE.PUT_LINE( FND_FILE.LOG, '*** Billing Report:: Sub_Line_Name Error ' || sqlerrm);

2798: Return(l_name);
2799:
2800:
2801: Exception When Others then
2802: FND_FILE.PUT_LINE( FND_FILE.LOG, '*** Billing Report:: Sub_Line_Name Error ' || sqlerrm);
2803: Return(OKC_API.G_RET_STS_UNEXP_ERROR );
2804: OKC_API.SET_MESSAGE
2805: (P_App_Name => G_APP_NAME
2806: ,P_Msg_Name => G_UNEXPECTED_ERROR

Line 2854: FND_FILE.PUT_LINE( FND_FILE.LOG, '*** Billing Report:: delete_duplicate_currency_code Error ' || sqlerrm);

2850:
2851: Exception When Others Then
2852:
2853: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2854: FND_FILE.PUT_LINE( FND_FILE.LOG, '*** Billing Report:: delete_duplicate_currency_code Error ' || sqlerrm);
2855:
2856: OKC_API.SET_MESSAGE
2857: (P_App_Name => G_APP_NAME
2858: ,P_Msg_Name => G_UNEXPECTED_ERROR

Line 2917: FND_FILE.PUT_LINE( FND_FILE.LOG, '*** Billing Report:: sort_currency_table Error ' || sqlerrm);

2913: x_currency_table := l_currency_tbl_tmp ;
2914: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2915:
2916: Exception When Others Then
2917: FND_FILE.PUT_LINE( FND_FILE.LOG, '*** Billing Report:: sort_currency_table Error ' || sqlerrm);
2918: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2919: OKC_API.SET_MESSAGE
2920: (P_App_Name => G_APP_NAME
2921: ,P_Msg_Name => G_UNEXPECTED_ERROR

Line 3018: FND_FILE.PUT_LINE( FND_FILE.LOG, '*** Billing Report:: Get_Currency_code Error ' || sqlerrm);

3014:
3015: x_currency_table_out := l_currency_table_tmp ;
3016:
3017: Exception When Others then
3018: FND_FILE.PUT_LINE( FND_FILE.LOG, '*** Billing Report:: Get_Currency_code Error ' || sqlerrm);
3019: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
3020: OKC_API.SET_MESSAGE
3021: (P_App_Name => G_APP_NAME
3022: ,P_Msg_Name => G_UNEXPECTED_ERROR

Line 3088: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;

3084: l_contracts_total := nvl(p_lines_total,0) + nvl(p_slines_total,0) ;
3085: l_rejected_con_total := nvl(p_rejected_lines_total,0) + nvl(p_rejected_slines_total,0) ;
3086: l_length := length(l_currency_desc||l_msg);
3087:
3088: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;
3089: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;
3090: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, l_msg||' '||l_currency_desc ) ;
3091: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, rpad('====',l_length,'===' )) ;
3092: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;

Line 3089: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;

3085: l_rejected_con_total := nvl(p_rejected_lines_total,0) + nvl(p_rejected_slines_total,0) ;
3086: l_length := length(l_currency_desc||l_msg);
3087:
3088: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;
3089: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;
3090: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, l_msg||' '||l_currency_desc ) ;
3091: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, rpad('====',l_length,'===' )) ;
3092: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;
3093:

Line 3090: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, l_msg||' '||l_currency_desc ) ;

3086: l_length := length(l_currency_desc||l_msg);
3087:
3088: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;
3089: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;
3090: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, l_msg||' '||l_currency_desc ) ;
3091: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, rpad('====',l_length,'===' )) ;
3092: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;
3093:
3094:

Line 3091: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, rpad('====',l_length,'===' )) ;

3087:
3088: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;
3089: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;
3090: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, l_msg||' '||l_currency_desc ) ;
3091: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, rpad('====',l_length,'===' )) ;
3092: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;
3093:
3094:
3095: fnd_message.set_name ('OKS','OKS_BILLREP_CON_PROC');

Line 3092: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;

3088: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;
3089: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;
3090: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, l_msg||' '||l_currency_desc ) ;
3091: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, rpad('====',l_length,'===' )) ;
3092: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;
3093:
3094:
3095: fnd_message.set_name ('OKS','OKS_BILLREP_CON_PROC');
3096: l_msg := fnd_message.get;

Line 3103: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, rpad(l_msg||':',30,' ')||rpad(to_char(p_contracts_processed),10,' ')||' '||l_cur_msg||': '|| to_char (l_contracts_total, fnd_currency.get_format_mask(p_currency_code, 50)));

3099: l_msg := fnd_message.get;
3100:
3101: --bug#4323607 maanand
3102:
3103: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, rpad(l_msg||':',30,' ')||rpad(to_char(p_contracts_processed),10,' ')||' '||l_cur_msg||': '|| to_char (l_contracts_total, fnd_currency.get_format_mask(p_currency_code, 50)));
3104:
3105:
3106:
3107: fnd_message.set_name ('OKS','OKS_BILLREP_LINE_PROC');

Line 3109: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;

3105:
3106:
3107: fnd_message.set_name ('OKS','OKS_BILLREP_LINE_PROC');
3108: l_msg := fnd_message.get;
3109: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3110: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3111: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, rpad(l_msg||':',30,' ')||rpad(to_char(p_lines_processed),10,' ')||' '||l_cur_msg||': '|| to_char (p_lines_total, fnd_currency.get_format_mask(p_currency_code, 50)));
3112: fnd_message.set_name ('OKS','OKS_BILLREP_LINE_SUCC');
3113: l_msg := fnd_message.get;

Line 3110: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;

3106:
3107: fnd_message.set_name ('OKS','OKS_BILLREP_LINE_PROC');
3108: l_msg := fnd_message.get;
3109: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3110: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3111: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, rpad(l_msg||':',30,' ')||rpad(to_char(p_lines_processed),10,' ')||' '||l_cur_msg||': '|| to_char (p_lines_total, fnd_currency.get_format_mask(p_currency_code, 50)));
3112: fnd_message.set_name ('OKS','OKS_BILLREP_LINE_SUCC');
3113: l_msg := fnd_message.get;
3114: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, rpad(l_msg||':',30,' ')||rpad(to_char(p_lines_success),10,' ')||' '||l_cur_msg||': '|| to_char (p_lines_successtot, fnd_currency.get_format_mask(p_currency_code, 50)));

Line 3111: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, rpad(l_msg||':',30,' ')||rpad(to_char(p_lines_processed),10,' ')||' '||l_cur_msg||': '|| to_char (p_lines_total, fnd_currency.get_format_mask(p_currency_code, 50)));

3107: fnd_message.set_name ('OKS','OKS_BILLREP_LINE_PROC');
3108: l_msg := fnd_message.get;
3109: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3110: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3111: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, rpad(l_msg||':',30,' ')||rpad(to_char(p_lines_processed),10,' ')||' '||l_cur_msg||': '|| to_char (p_lines_total, fnd_currency.get_format_mask(p_currency_code, 50)));
3112: fnd_message.set_name ('OKS','OKS_BILLREP_LINE_SUCC');
3113: l_msg := fnd_message.get;
3114: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, rpad(l_msg||':',30,' ')||rpad(to_char(p_lines_success),10,' ')||' '||l_cur_msg||': '|| to_char (p_lines_successtot, fnd_currency.get_format_mask(p_currency_code, 50)));
3115: fnd_message.set_name ('OKS','OKS_BILLREP_LINE_REJ');

Line 3114: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, rpad(l_msg||':',30,' ')||rpad(to_char(p_lines_success),10,' ')||' '||l_cur_msg||': '|| to_char (p_lines_successtot, fnd_currency.get_format_mask(p_currency_code, 50)));

3110: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3111: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, rpad(l_msg||':',30,' ')||rpad(to_char(p_lines_processed),10,' ')||' '||l_cur_msg||': '|| to_char (p_lines_total, fnd_currency.get_format_mask(p_currency_code, 50)));
3112: fnd_message.set_name ('OKS','OKS_BILLREP_LINE_SUCC');
3113: l_msg := fnd_message.get;
3114: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, rpad(l_msg||':',30,' ')||rpad(to_char(p_lines_success),10,' ')||' '||l_cur_msg||': '|| to_char (p_lines_successtot, fnd_currency.get_format_mask(p_currency_code, 50)));
3115: fnd_message.set_name ('OKS','OKS_BILLREP_LINE_REJ');
3116: l_msg := fnd_message.get;
3117: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, rpad(l_msg||':',30,' ')||rpad(to_char(p_lines_rejected),10,' ')||' '||l_cur_msg||': '|| to_char (p_rejected_lines_total, fnd_currency.get_format_mask(p_currency_code, 50)));
3118:

Line 3117: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, rpad(l_msg||':',30,' ')||rpad(to_char(p_lines_rejected),10,' ')||' '||l_cur_msg||': '|| to_char (p_rejected_lines_total, fnd_currency.get_format_mask(p_currency_code, 50)));

3113: l_msg := fnd_message.get;
3114: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, rpad(l_msg||':',30,' ')||rpad(to_char(p_lines_success),10,' ')||' '||l_cur_msg||': '|| to_char (p_lines_successtot, fnd_currency.get_format_mask(p_currency_code, 50)));
3115: fnd_message.set_name ('OKS','OKS_BILLREP_LINE_REJ');
3116: l_msg := fnd_message.get;
3117: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, rpad(l_msg||':',30,' ')||rpad(to_char(p_lines_rejected),10,' ')||' '||l_cur_msg||': '|| to_char (p_rejected_lines_total, fnd_currency.get_format_mask(p_currency_code, 50)));
3118:
3119:
3120: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3121: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;

Line 3120: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;

3116: l_msg := fnd_message.get;
3117: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, rpad(l_msg||':',30,' ')||rpad(to_char(p_lines_rejected),10,' ')||' '||l_cur_msg||': '|| to_char (p_rejected_lines_total, fnd_currency.get_format_mask(p_currency_code, 50)));
3118:
3119:
3120: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3121: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3122: fnd_message.set_name ('OKS','OKS_BILLREP_SUBLINE_PROC');
3123: l_msg := fnd_message.get;
3124: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, rpad(l_msg||':',30,' ')||rpad(to_char(p_slines_processed),10,' ')||' '||l_cur_msg||': '|| to_char (p_slines_total, fnd_currency.get_format_mask(p_currency_code, 50)));

Line 3121: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;

3117: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, rpad(l_msg||':',30,' ')||rpad(to_char(p_lines_rejected),10,' ')||' '||l_cur_msg||': '|| to_char (p_rejected_lines_total, fnd_currency.get_format_mask(p_currency_code, 50)));
3118:
3119:
3120: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3121: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3122: fnd_message.set_name ('OKS','OKS_BILLREP_SUBLINE_PROC');
3123: l_msg := fnd_message.get;
3124: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, rpad(l_msg||':',30,' ')||rpad(to_char(p_slines_processed),10,' ')||' '||l_cur_msg||': '|| to_char (p_slines_total, fnd_currency.get_format_mask(p_currency_code, 50)));
3125: fnd_message.set_name ('OKS','OKS_BILLREP_SUBLINE_SUCC');

Line 3124: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, rpad(l_msg||':',30,' ')||rpad(to_char(p_slines_processed),10,' ')||' '||l_cur_msg||': '|| to_char (p_slines_total, fnd_currency.get_format_mask(p_currency_code, 50)));

3120: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3121: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3122: fnd_message.set_name ('OKS','OKS_BILLREP_SUBLINE_PROC');
3123: l_msg := fnd_message.get;
3124: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, rpad(l_msg||':',30,' ')||rpad(to_char(p_slines_processed),10,' ')||' '||l_cur_msg||': '|| to_char (p_slines_total, fnd_currency.get_format_mask(p_currency_code, 50)));
3125: fnd_message.set_name ('OKS','OKS_BILLREP_SUBLINE_SUCC');
3126: l_msg := fnd_message.get;
3127: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, rpad(l_msg||':',30,' ')||rpad(to_char(p_slines_success),10,' ')||' '||l_cur_msg||': '|| to_char (p_slines_successtot, fnd_currency.get_format_mask(p_currency_code, 50)));
3128: fnd_message.set_name ('OKS','OKS_BILLREP_SUBLINE_REJ');

Line 3127: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, rpad(l_msg||':',30,' ')||rpad(to_char(p_slines_success),10,' ')||' '||l_cur_msg||': '|| to_char (p_slines_successtot, fnd_currency.get_format_mask(p_currency_code, 50)));

3123: l_msg := fnd_message.get;
3124: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, rpad(l_msg||':',30,' ')||rpad(to_char(p_slines_processed),10,' ')||' '||l_cur_msg||': '|| to_char (p_slines_total, fnd_currency.get_format_mask(p_currency_code, 50)));
3125: fnd_message.set_name ('OKS','OKS_BILLREP_SUBLINE_SUCC');
3126: l_msg := fnd_message.get;
3127: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, rpad(l_msg||':',30,' ')||rpad(to_char(p_slines_success),10,' ')||' '||l_cur_msg||': '|| to_char (p_slines_successtot, fnd_currency.get_format_mask(p_currency_code, 50)));
3128: fnd_message.set_name ('OKS','OKS_BILLREP_SUBLINE_REJ');
3129: l_msg := fnd_message.get;
3130: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, rpad(l_msg||':',30,' ')||rpad(to_char(p_slines_rejected),10,' ')||' '||l_cur_msg||': '|| to_char (p_rejected_slines_total, fnd_currency.get_format_mask(p_currency_code, 50)));
3131:

Line 3130: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, rpad(l_msg||':',30,' ')||rpad(to_char(p_slines_rejected),10,' ')||' '||l_cur_msg||': '|| to_char (p_rejected_slines_total, fnd_currency.get_format_mask(p_currency_code, 50)));

3126: l_msg := fnd_message.get;
3127: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, rpad(l_msg||':',30,' ')||rpad(to_char(p_slines_success),10,' ')||' '||l_cur_msg||': '|| to_char (p_slines_successtot, fnd_currency.get_format_mask(p_currency_code, 50)));
3128: fnd_message.set_name ('OKS','OKS_BILLREP_SUBLINE_REJ');
3129: l_msg := fnd_message.get;
3130: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, rpad(l_msg||':',30,' ')||rpad(to_char(p_slines_rejected),10,' ')||' '||l_cur_msg||': '|| to_char (p_rejected_slines_total, fnd_currency.get_format_mask(p_currency_code, 50)));
3131:
3132:
3133: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;
3134: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;

Line 3133: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;

3129: l_msg := fnd_message.get;
3130: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, rpad(l_msg||':',30,' ')||rpad(to_char(p_slines_rejected),10,' ')||' '||l_cur_msg||': '|| to_char (p_rejected_slines_total, fnd_currency.get_format_mask(p_currency_code, 50)));
3131:
3132:
3133: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;
3134: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;
3135: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;
3136:
3137: Exception When Others Then

Line 3134: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;

3130: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, rpad(l_msg||':',30,' ')||rpad(to_char(p_slines_rejected),10,' ')||' '||l_cur_msg||': '|| to_char (p_rejected_slines_total, fnd_currency.get_format_mask(p_currency_code, 50)));
3131:
3132:
3133: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;
3134: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;
3135: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;
3136:
3137: Exception When Others Then
3138: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR ;

Line 3135: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;

3131:
3132:
3133: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;
3134: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;
3135: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;
3136:
3137: Exception When Others Then
3138: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR ;
3139: FND_FILE.PUT_LINE( FND_FILE.LOG, '*** Billing Report:: Print_currency_break Error ' || sqlerrm);

Line 3139: FND_FILE.PUT_LINE( FND_FILE.LOG, '*** Billing Report:: Print_currency_break Error ' || sqlerrm);

3135: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;
3136:
3137: Exception When Others Then
3138: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR ;
3139: FND_FILE.PUT_LINE( FND_FILE.LOG, '*** Billing Report:: Print_currency_break Error ' || sqlerrm);
3140: OKC_API.SET_MESSAGE
3141: (P_App_Name => G_APP_NAME
3142: ,P_Msg_Name => G_UNEXPECTED_ERROR
3143: ,P_Token1 => G_SQLCODE_TOKEN

Line 3285: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;

3281: /* *** ---- Print the error message ---- *** */
3282:
3283: If ((p_lines_rejected >= 1 AND p_billrep_error_tbl.count > 0 )or (p_slines_rejected >= 1 AND p_billrep_error_tbl.count > 0) ) then
3284:
3285: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3286: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3287: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3288: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' Following are the Lines Rejected by Billing Program ') ;
3289: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' *************************************************** ') ;

Line 3286: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;

3282:
3283: If ((p_lines_rejected >= 1 AND p_billrep_error_tbl.count > 0 )or (p_slines_rejected >= 1 AND p_billrep_error_tbl.count > 0) ) then
3284:
3285: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3286: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3287: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3288: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' Following are the Lines Rejected by Billing Program ') ;
3289: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' *************************************************** ') ;
3290: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;

Line 3287: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;

3283: If ((p_lines_rejected >= 1 AND p_billrep_error_tbl.count > 0 )or (p_slines_rejected >= 1 AND p_billrep_error_tbl.count > 0) ) then
3284:
3285: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3286: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3287: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3288: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' Following are the Lines Rejected by Billing Program ') ;
3289: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' *************************************************** ') ;
3290: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3291: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;

Line 3288: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' Following are the Lines Rejected by Billing Program ') ;

3284:
3285: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3286: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3287: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3288: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' Following are the Lines Rejected by Billing Program ') ;
3289: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' *************************************************** ') ;
3290: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3291: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3292:

Line 3289: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' *************************************************** ') ;

3285: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3286: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3287: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3288: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' Following are the Lines Rejected by Billing Program ') ;
3289: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' *************************************************** ') ;
3290: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3291: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3292:
3293: End If;

Line 3290: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;

3286: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3287: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3288: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' Following are the Lines Rejected by Billing Program ') ;
3289: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' *************************************************** ') ;
3290: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3291: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3292:
3293: End If;
3294:

Line 3291: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;

3287: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3288: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' Following are the Lines Rejected by Billing Program ') ;
3289: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' *************************************************** ') ;
3290: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3291: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3292:
3293: End If;
3294:
3295:

Line 3324: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'Contract: '||l_cont_num||' - '||l_cont_num_mod||' Group: '||l_group_name|| ' Customer: '||l_customer_number||' - '||l_customer_name);

3320: l_dnz_chr_id := detail_rec.dnz_chr_id ;
3321: l_cont_num := detail_rec.Contract_number ;
3322: l_cont_num_mod := detail_rec.Contract_number_modifier ;
3323:
3324: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'Contract: '||l_cont_num||' - '||l_cont_num_mod||' Group: '||l_group_name|| ' Customer: '||l_customer_number||' - '||l_customer_name);
3325:
3326: End If;
3327:
3328: Open l_line_name_csr (p_billrep_error_tbl(l_line_idx).Top_Line_id,detail_rec.Inv_organization_id );

Line 3340: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||'Service Line: '||l_line_num||' '||l_line_name||' Service Account: '||l_service_account||' For Amount: '|| to_char (l_bil_amt, fnd_currency.get_format_mask(detail_rec.currency_code, 50)));

3336: l_line_num := detail_rec.line_number ;
3337:
3338: -- bug#4323607 maanand
3339:
3340: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||'Service Line: '||l_line_num||' '||l_line_name||' Service Account: '||l_service_account||' For Amount: '|| to_char (l_bil_amt, fnd_currency.get_format_mask(detail_rec.currency_code, 50)));
3341:
3342: l_error_string1 := 'Reason: '||substr(p_billrep_error_tbl(l_line_idx).Error_Message,1,50);
3343: l_error_string2 := substr(p_billrep_error_tbl(l_line_idx).Error_Message,51,100);
3344: l_error_string3 := substr(p_billrep_error_tbl(l_line_idx).Error_Message,101,150);

Line 3351: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string1 );

3347: l_error_string6 := substr(p_billrep_error_tbl(l_line_idx).Error_Message,251,300);
3348: l_error_string7 := substr(p_billrep_error_tbl(l_line_idx).Error_Message,301,350);
3349:
3350: If length(l_error_string1) > 1 Then
3351: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string1 );
3352: End If;
3353: If length(l_error_string2) > 1 Then
3354: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string2);
3355: End If;

Line 3354: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string2);

3350: If length(l_error_string1) > 1 Then
3351: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string1 );
3352: End If;
3353: If length(l_error_string2) > 1 Then
3354: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string2);
3355: End If;
3356: If length(l_error_string3) > 1 Then
3357: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string3);
3358: End If;

Line 3357: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string3);

3353: If length(l_error_string2) > 1 Then
3354: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string2);
3355: End If;
3356: If length(l_error_string3) > 1 Then
3357: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string3);
3358: End If;
3359: If length(l_error_string4) > 1 Then
3360: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string4);
3361: End If;

Line 3360: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string4);

3356: If length(l_error_string3) > 1 Then
3357: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string3);
3358: End If;
3359: If length(l_error_string4) > 1 Then
3360: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string4);
3361: End If;
3362: If length(l_error_string5) > 1 Then
3363: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string5);
3364: End If;

Line 3363: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string5);

3359: If length(l_error_string4) > 1 Then
3360: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string4);
3361: End If;
3362: If length(l_error_string5) > 1 Then
3363: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string5);
3364: End If;
3365: If length(l_error_string6) > 1 Then
3366: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string6);
3367: End If;

Line 3366: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string6);

3362: If length(l_error_string5) > 1 Then
3363: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string5);
3364: End If;
3365: If length(l_error_string6) > 1 Then
3366: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string6);
3367: End If;
3368: If length(l_error_string7) > 1 Then
3369: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string7);
3370: End If;

Line 3369: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string7);

3365: If length(l_error_string6) > 1 Then
3366: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string6);
3367: End If;
3368: If length(l_error_string7) > 1 Then
3369: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string7);
3370: End If;
3371:
3372: End If;
3373: EXIT WHEN l_line_idx = p_billrep_error_tbl.LAST;

Line 3415: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'Contract: '||l_cont_num||' - '||l_cont_num_mod||' Group: '||l_group_name||' Customer: '||l_customer_number||' - '||l_customer_name);

3411: l_dnz_chr_id := detail_rec.dnz_chr_id ;
3412: l_cont_num := detail_rec.Contract_number ;
3413: l_cont_num_mod := detail_rec.Contract_number_modifier ;
3414:
3415: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'Contract: '||l_cont_num||' - '||l_cont_num_mod||' Group: '||l_group_name||' Customer: '||l_customer_number||' - '||l_customer_name);
3416:
3417: End If;
3418:
3419:

Line 3437: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||'Service Line: '||l_line_num||' '||l_line_name||' Service Account: '||l_service_account ) ;

3433:
3434: select line_number into l_line_num from okc_k_lines_b
3435: where id=p_billrep_error_tbl(l_sub_line_idx).Top_Line_id;
3436:
3437: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||'Service Line: '||l_line_num||' '||l_line_name||' Service Account: '||l_service_account ) ;
3438:
3439: l_line_id :=p_billrep_error_tbl(l_sub_line_idx).Top_Line_id;
3440:
3441:

Line 3457: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||'Covered Line: '||l_line_num||' '||l_covered_level||l_sub_line_name||' For Amount: '||l_bil_amt ) ;

3453: l_sub_line_name := ' Name: '||Sub_Line_Name (l_subline_jtot_code,to_number(l_subline_obj1_id1),l_subline_obj1_id2 );
3454: l_bil_amt := to_char(detail_rec.price_negotiated ) ;
3455: l_line_num := detail_rec.line_number;
3456:
3457: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||'Covered Line: '||l_line_num||' '||l_covered_level||l_sub_line_name||' For Amount: '||l_bil_amt ) ;
3458:
3459: l_error_string1 := 'Reason: '||substr(p_billrep_error_tbl(l_sub_line_idx).Error_Message,1,50);
3460: l_error_string2 := substr(p_billrep_error_tbl(l_sub_line_idx).Error_Message,51,100);
3461: l_error_string3 := substr(p_billrep_error_tbl(l_sub_line_idx).Error_Message,101,150);

Line 3468: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string1 );

3464: l_error_string6 := substr(p_billrep_error_tbl(l_sub_line_idx).Error_Message,251,300);
3465: l_error_string7 := substr(p_billrep_error_tbl(l_sub_line_idx).Error_Message,301,350);
3466:
3467: If length(l_error_string1) > 1 Then
3468: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string1 );
3469: End If;
3470: If length(l_error_string2) > 1 Then
3471: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string2);
3472: End If;

Line 3471: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string2);

3467: If length(l_error_string1) > 1 Then
3468: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string1 );
3469: End If;
3470: If length(l_error_string2) > 1 Then
3471: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string2);
3472: End If;
3473: If length(l_error_string3) > 1 Then
3474: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string3);
3475: End If;

Line 3474: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string3);

3470: If length(l_error_string2) > 1 Then
3471: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string2);
3472: End If;
3473: If length(l_error_string3) > 1 Then
3474: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string3);
3475: End If;
3476: If length(l_error_string4) > 1 Then
3477: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string4);
3478: End If;

Line 3477: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string4);

3473: If length(l_error_string3) > 1 Then
3474: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string3);
3475: End If;
3476: If length(l_error_string4) > 1 Then
3477: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string4);
3478: End If;
3479: If length(l_error_string5) > 1 Then
3480: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string5);
3481: End If;

Line 3480: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string5);

3476: If length(l_error_string4) > 1 Then
3477: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string4);
3478: End If;
3479: If length(l_error_string5) > 1 Then
3480: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string5);
3481: End If;
3482: If length(l_error_string6) > 1 Then
3483: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string6);
3484: End If;

Line 3483: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string6);

3479: If length(l_error_string5) > 1 Then
3480: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string5);
3481: End If;
3482: If length(l_error_string6) > 1 Then
3483: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string6);
3484: End If;
3485: If length(l_error_string7) > 1 Then
3486: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string7);
3487: End If;

Line 3486: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string7);

3482: If length(l_error_string6) > 1 Then
3483: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string6);
3484: End If;
3485: If length(l_error_string7) > 1 Then
3486: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string7);
3487: End If;
3488:
3489: End If;
3490: EXIT WHEN l_sub_line_idx = p_billrep_error_tbl.LAST;

Line 3499: FND_FILE.PUT_LINE( FND_FILE.LOG, '*** Billing Report:: Print_Error_Report ' || sqlerrm);

3495:
3496:
3497: Exception When Others Then
3498: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR ;
3499: FND_FILE.PUT_LINE( FND_FILE.LOG, '*** Billing Report:: Print_Error_Report ' || sqlerrm);
3500: OKC_API.SET_MESSAGE
3501: (P_App_Name => G_APP_NAME
3502: ,P_Msg_Name => G_UNEXPECTED_ERROR
3503: ,P_Token1 => G_SQLCODE_TOKEN

Line 3556: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;

3552:
3553:
3554: fnd_message.set_name('OKS','OKS_BILLREP_TITLE');
3555: l_msg := fnd_message.get;
3556: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3557: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3558: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3559: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' '|| l_msg ||' ') ;
3560: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' **************************************** ') ;

Line 3557: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;

3553:
3554: fnd_message.set_name('OKS','OKS_BILLREP_TITLE');
3555: l_msg := fnd_message.get;
3556: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3557: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3558: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3559: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' '|| l_msg ||' ') ;
3560: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' **************************************** ') ;
3561:

Line 3558: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;

3554: fnd_message.set_name('OKS','OKS_BILLREP_TITLE');
3555: l_msg := fnd_message.get;
3556: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3557: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3558: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3559: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' '|| l_msg ||' ') ;
3560: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' **************************************** ') ;
3561:
3562: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;

Line 3559: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' '|| l_msg ||' ') ;

3555: l_msg := fnd_message.get;
3556: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3557: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3558: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3559: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' '|| l_msg ||' ') ;
3560: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' **************************************** ') ;
3561:
3562: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3563: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;

Line 3560: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' **************************************** ') ;

3556: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3557: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3558: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3559: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' '|| l_msg ||' ') ;
3560: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' **************************************** ') ;
3561:
3562: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3563: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3564: /* *** Print the currency break up for each currency *** */

Line 3562: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;

3558: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3559: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' '|| l_msg ||' ') ;
3560: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' **************************************** ') ;
3561:
3562: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3563: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3564: /* *** Print the currency break up for each currency *** */
3565:
3566:

Line 3563: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;

3559: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' '|| l_msg ||' ') ;
3560: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' **************************************** ') ;
3561:
3562: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3563: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3564: /* *** Print the currency break up for each currency *** */
3565:
3566:
3567: --Start mchoudha Bug#3537100 17-APR-04

Line 3612: FND_FILE.PUT_LINE( FND_FILE.LOG, '*** Billing Report:: PRINT_CURRENCY_BREAK procedure failed for : ' || p_billrep_table(i).Currency_code ||' Error: '||sqlerrm);

3608: ,x_return_status => l_return_status
3609: ) ;
3610:
3611: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
3612: FND_FILE.PUT_LINE( FND_FILE.LOG, '*** Billing Report:: PRINT_CURRENCY_BREAK procedure failed for : ' || p_billrep_table(i).Currency_code ||' Error: '||sqlerrm);
3613: x_return_status := l_return_status ;
3614: Raise Create_Report_Exception ;
3615: END IF;
3616:

Line 3625: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_curr_break_line); /* print a line after the currency summary */

3621:
3622:
3623:
3624:
3625: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_curr_break_line); /* print a line after the currency summary */
3626:
3627:
3628: /* -- Procedure call to print the error report */
3629:

Line 3651: FND_FILE.PUT_LINE( FND_FILE.LOG, '* Billing Report has errors :: Report Exception * '||sqlerrm) ;

3647: EXCEPTION
3648:
3649: WHEN Create_Report_Exception Then
3650: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR ;
3651: FND_FILE.PUT_LINE( FND_FILE.LOG, '***** Billing Report has errors :: Report Exception ***** '||sqlerrm) ;
3652: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '*** Billing Report has errors **** '||sqlerrm);
3653: OKC_API.SET_MESSAGE
3654: (P_App_Name => G_APP_NAME
3655: ,P_Msg_Name => G_UNEXPECTED_ERROR

Line 3652: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '* Billing Report has errors ** '||sqlerrm);

3648:
3649: WHEN Create_Report_Exception Then
3650: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR ;
3651: FND_FILE.PUT_LINE( FND_FILE.LOG, '***** Billing Report has errors :: Report Exception ***** '||sqlerrm) ;
3652: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '*** Billing Report has errors **** '||sqlerrm);
3653: OKC_API.SET_MESSAGE
3654: (P_App_Name => G_APP_NAME
3655: ,P_Msg_Name => G_UNEXPECTED_ERROR
3656: ,P_Token1 => G_SQLCODE_TOKEN

Line 3663: FND_FILE.PUT_LINE( FND_FILE.LOG, '* Billing Report has errors :: When Others * '||sqlerrm) ;

3659: ,P_Token2_Value => SQLERRM);
3660:
3661: WHEN Others Then
3662: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR ;
3663: FND_FILE.PUT_LINE( FND_FILE.LOG, '***** Billing Report has errors :: When Others ***** '||sqlerrm) ;
3664: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '*** Billing Report has errors **** '||sqlerrm);
3665: OKC_API.SET_MESSAGE
3666: (P_App_Name => G_APP_NAME
3667: ,P_Msg_Name => G_UNEXPECTED_ERROR

Line 3664: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '* Billing Report has errors ** '||sqlerrm);

3660:
3661: WHEN Others Then
3662: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR ;
3663: FND_FILE.PUT_LINE( FND_FILE.LOG, '***** Billing Report has errors :: When Others ***** '||sqlerrm) ;
3664: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '*** Billing Report has errors **** '||sqlerrm);
3665: OKC_API.SET_MESSAGE
3666: (P_App_Name => G_APP_NAME
3667: ,P_Msg_Name => G_UNEXPECTED_ERROR
3668: ,P_Token1 => G_SQLCODE_TOKEN