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 2340: FND_FILE.PUT_LINE( FND_FILE.LOG, '*** Billing Report:: delete_duplicate_lines Error ' || sqlerrm);

2336:
2337: Exception When Others Then
2338:
2339: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2340: FND_FILE.PUT_LINE( FND_FILE.LOG, '*** Billing Report:: delete_duplicate_lines Error ' || sqlerrm);
2341:
2342: OKC_API.SET_MESSAGE
2343: (P_App_Name => G_APP_NAME
2344: ,P_Msg_Name => G_UNEXPECTED_ERROR

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

2386: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2387:
2388: Exception When Others Then
2389:
2390: FND_FILE.PUT_LINE( FND_FILE.LOG, '*** Billing Report:: delete_duplicate_sub_lines Error ' || sqlerrm);
2391: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2392:
2393: OKC_API.SET_MESSAGE
2394: (P_App_Name => G_APP_NAME

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

2449: x_lines_table := l_lines_tbl_tmp ;
2450: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2451:
2452: Exception When Others Then
2453: FND_FILE.PUT_LINE( FND_FILE.LOG, '*** Billing Report:: sort_lines_table Error ' || sqlerrm);
2454: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2455: OKC_API.SET_MESSAGE
2456: (P_App_Name => G_APP_NAME
2457: ,P_Msg_Name => G_UNEXPECTED_ERROR

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

2515: x_sub_lines_table := l_sub_lines_tbl_tmp ;
2516: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2517:
2518: Exception When Others Then
2519: FND_FILE.PUT_LINE( FND_FILE.LOG, '*** Billing Report:: sort_sub_lines_table Error ' || sqlerrm);
2520: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2521: OKC_API.SET_MESSAGE
2522: (P_App_Name => G_APP_NAME
2523: ,P_Msg_Name => G_UNEXPECTED_ERROR

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

2574: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2575:
2576: Exception When Others Then
2577: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2578: FND_FILE.PUT_LINE( FND_FILE.LOG, '*** Billing Report:: sub_lines_bill_status Error ' || sqlerrm);
2579: OKC_API.SET_MESSAGE
2580: (P_App_Name => G_APP_NAME
2581: ,P_Msg_Name => G_UNEXPECTED_ERROR
2582: ,P_Token1 => G_SQLCODE_TOKEN

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

2643:
2644: Return (l_bill_profile);
2645:
2646: Exception When Others then
2647: FND_FILE.PUT_LINE( FND_FILE.LOG, '*** Billing Report:: Get_Billig_Profile Error ' || sqlerrm);
2648: Return(OKC_API.G_RET_STS_UNEXP_ERROR );
2649: OKC_API.SET_MESSAGE
2650: (P_App_Name => G_APP_NAME
2651: ,P_Msg_Name => G_UNEXPECTED_ERROR

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

2721:
2722:
2723: Exception When Others Then
2724: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR ;
2725: FND_FILE.PUT_LINE( FND_FILE.LOG, '*** Billing Report:: Set_Billing_Profile Error ' || sqlerrm);
2726: OKC_API.SET_MESSAGE
2727: (P_App_Name => G_APP_NAME
2728: ,P_Msg_Name => G_UNEXPECTED_ERROR
2729: ,P_Token1 => G_SQLCODE_TOKEN

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

2832: Return(l_name);
2833:
2834:
2835: Exception When Others then
2836: FND_FILE.PUT_LINE( FND_FILE.LOG, '*** Billing Report:: Sub_Line_Name Error ' || sqlerrm);
2837: Return(OKC_API.G_RET_STS_UNEXP_ERROR );
2838: OKC_API.SET_MESSAGE
2839: (P_App_Name => G_APP_NAME
2840: ,P_Msg_Name => G_UNEXPECTED_ERROR

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

2884:
2885: Exception When Others Then
2886:
2887: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2888: FND_FILE.PUT_LINE( FND_FILE.LOG, '*** Billing Report:: delete_duplicate_currency_code Error ' || sqlerrm);
2889:
2890: OKC_API.SET_MESSAGE
2891: (P_App_Name => G_APP_NAME
2892: ,P_Msg_Name => G_UNEXPECTED_ERROR

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

2947: x_currency_table := l_currency_tbl_tmp ;
2948: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2949:
2950: Exception When Others Then
2951: FND_FILE.PUT_LINE( FND_FILE.LOG, '*** Billing Report:: sort_currency_table Error ' || sqlerrm);
2952: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2953: OKC_API.SET_MESSAGE
2954: (P_App_Name => G_APP_NAME
2955: ,P_Msg_Name => G_UNEXPECTED_ERROR

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

3048:
3049: x_currency_table_out := l_currency_table_tmp ;
3050:
3051: Exception When Others then
3052: FND_FILE.PUT_LINE( FND_FILE.LOG, '*** Billing Report:: Get_Currency_code Error ' || sqlerrm);
3053: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
3054: OKC_API.SET_MESSAGE
3055: (P_App_Name => G_APP_NAME
3056: ,P_Msg_Name => G_UNEXPECTED_ERROR

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

3118: l_contracts_total := nvl(p_lines_total,0) + nvl(p_slines_total,0) ;
3119: l_rejected_con_total := nvl(p_rejected_lines_total,0) + nvl(p_rejected_slines_total,0) ;
3120: l_length := length(l_currency_desc||l_msg);
3121:
3122: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;
3123: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;
3124: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, l_msg||' '||l_currency_desc ) ;
3125: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, rpad('====',l_length,'===' )) ;
3126: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;

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

3119: l_rejected_con_total := nvl(p_rejected_lines_total,0) + nvl(p_rejected_slines_total,0) ;
3120: l_length := length(l_currency_desc||l_msg);
3121:
3122: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;
3123: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;
3124: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, l_msg||' '||l_currency_desc ) ;
3125: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, rpad('====',l_length,'===' )) ;
3126: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;
3127:

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

3120: l_length := length(l_currency_desc||l_msg);
3121:
3122: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;
3123: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;
3124: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, l_msg||' '||l_currency_desc ) ;
3125: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, rpad('====',l_length,'===' )) ;
3126: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;
3127:
3128:

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

3121:
3122: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;
3123: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;
3124: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, l_msg||' '||l_currency_desc ) ;
3125: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, rpad('====',l_length,'===' )) ;
3126: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;
3127:
3128:
3129: fnd_message.set_name ('OKS','OKS_BILLREP_CON_PROC');

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

3122: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;
3123: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;
3124: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, l_msg||' '||l_currency_desc ) ;
3125: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, rpad('====',l_length,'===' )) ;
3126: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;
3127:
3128:
3129: fnd_message.set_name ('OKS','OKS_BILLREP_CON_PROC');
3130: l_msg := fnd_message.get;

Line 3137: 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)));

3133: l_msg := fnd_message.get;
3134:
3135: --bug#4323607 maanand
3136:
3137: 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)));
3138:
3139:
3140:
3141: fnd_message.set_name ('OKS','OKS_BILLREP_LINE_PROC');

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

3139:
3140:
3141: fnd_message.set_name ('OKS','OKS_BILLREP_LINE_PROC');
3142: l_msg := fnd_message.get;
3143: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3144: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3145: 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)));
3146: fnd_message.set_name ('OKS','OKS_BILLREP_LINE_SUCC');
3147: l_msg := fnd_message.get;

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

3140:
3141: fnd_message.set_name ('OKS','OKS_BILLREP_LINE_PROC');
3142: l_msg := fnd_message.get;
3143: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3144: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3145: 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)));
3146: fnd_message.set_name ('OKS','OKS_BILLREP_LINE_SUCC');
3147: l_msg := fnd_message.get;
3148: 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 3145: 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)));

3141: fnd_message.set_name ('OKS','OKS_BILLREP_LINE_PROC');
3142: l_msg := fnd_message.get;
3143: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3144: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3145: 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)));
3146: fnd_message.set_name ('OKS','OKS_BILLREP_LINE_SUCC');
3147: l_msg := fnd_message.get;
3148: 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)));
3149: fnd_message.set_name ('OKS','OKS_BILLREP_LINE_REJ');

Line 3148: 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)));

3144: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3145: 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)));
3146: fnd_message.set_name ('OKS','OKS_BILLREP_LINE_SUCC');
3147: l_msg := fnd_message.get;
3148: 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)));
3149: fnd_message.set_name ('OKS','OKS_BILLREP_LINE_REJ');
3150: l_msg := fnd_message.get;
3151: 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)));
3152:

Line 3151: 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)));

3147: l_msg := fnd_message.get;
3148: 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)));
3149: fnd_message.set_name ('OKS','OKS_BILLREP_LINE_REJ');
3150: l_msg := fnd_message.get;
3151: 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)));
3152:
3153:
3154: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3155: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;

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

3150: l_msg := fnd_message.get;
3151: 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)));
3152:
3153:
3154: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3155: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3156: fnd_message.set_name ('OKS','OKS_BILLREP_SUBLINE_PROC');
3157: l_msg := fnd_message.get;
3158: 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 3155: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;

3151: 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)));
3152:
3153:
3154: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3155: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3156: fnd_message.set_name ('OKS','OKS_BILLREP_SUBLINE_PROC');
3157: l_msg := fnd_message.get;
3158: 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)));
3159: fnd_message.set_name ('OKS','OKS_BILLREP_SUBLINE_SUCC');

Line 3158: 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)));

3154: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3155: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3156: fnd_message.set_name ('OKS','OKS_BILLREP_SUBLINE_PROC');
3157: l_msg := fnd_message.get;
3158: 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)));
3159: fnd_message.set_name ('OKS','OKS_BILLREP_SUBLINE_SUCC');
3160: l_msg := fnd_message.get;
3161: 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)));
3162: fnd_message.set_name ('OKS','OKS_BILLREP_SUBLINE_REJ');

Line 3161: 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)));

3157: l_msg := fnd_message.get;
3158: 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)));
3159: fnd_message.set_name ('OKS','OKS_BILLREP_SUBLINE_SUCC');
3160: l_msg := fnd_message.get;
3161: 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)));
3162: fnd_message.set_name ('OKS','OKS_BILLREP_SUBLINE_REJ');
3163: l_msg := fnd_message.get;
3164: 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)));
3165:

Line 3164: 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)));

3160: l_msg := fnd_message.get;
3161: 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)));
3162: fnd_message.set_name ('OKS','OKS_BILLREP_SUBLINE_REJ');
3163: l_msg := fnd_message.get;
3164: 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)));
3165:
3166:
3167: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;
3168: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;

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

3163: l_msg := fnd_message.get;
3164: 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)));
3165:
3166:
3167: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;
3168: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;
3169: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;
3170:
3171: Exception When Others Then

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

3164: 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)));
3165:
3166:
3167: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;
3168: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;
3169: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;
3170:
3171: Exception When Others Then
3172: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR ;

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

3165:
3166:
3167: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;
3168: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;
3169: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;
3170:
3171: Exception When Others Then
3172: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR ;
3173: FND_FILE.PUT_LINE( FND_FILE.LOG, '*** Billing Report:: Print_currency_break Error ' || sqlerrm);

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

3169: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ' ) ;
3170:
3171: Exception When Others Then
3172: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR ;
3173: FND_FILE.PUT_LINE( FND_FILE.LOG, '*** Billing Report:: Print_currency_break Error ' || sqlerrm);
3174: OKC_API.SET_MESSAGE
3175: (P_App_Name => G_APP_NAME
3176: ,P_Msg_Name => G_UNEXPECTED_ERROR
3177: ,P_Token1 => G_SQLCODE_TOKEN

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

3315: /* *** ---- Print the error message ---- *** */
3316:
3317: 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
3318:
3319: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3320: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3321: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3322: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' Following are the Lines Rejected by Billing Program ') ;
3323: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' *************************************************** ') ;

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

3316:
3317: 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
3318:
3319: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3320: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3321: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3322: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' Following are the Lines Rejected by Billing Program ') ;
3323: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' *************************************************** ') ;
3324: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;

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

3317: 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
3318:
3319: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3320: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3321: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3322: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' Following are the Lines Rejected by Billing Program ') ;
3323: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' *************************************************** ') ;
3324: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3325: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;

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

3318:
3319: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3320: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3321: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3322: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' Following are the Lines Rejected by Billing Program ') ;
3323: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' *************************************************** ') ;
3324: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3325: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3326:

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

3319: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3320: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3321: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3322: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' Following are the Lines Rejected by Billing Program ') ;
3323: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' *************************************************** ') ;
3324: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3325: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3326:
3327: End If;

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

3320: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3321: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3322: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' Following are the Lines Rejected by Billing Program ') ;
3323: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' *************************************************** ') ;
3324: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3325: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3326:
3327: End If;
3328:

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

3321: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3322: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' Following are the Lines Rejected by Billing Program ') ;
3323: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' *************************************************** ') ;
3324: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3325: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3326:
3327: End If;
3328:
3329:

Line 3358: 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);

3354: l_dnz_chr_id := detail_rec.dnz_chr_id ;
3355: l_cont_num := detail_rec.Contract_number ;
3356: l_cont_num_mod := detail_rec.Contract_number_modifier ;
3357:
3358: 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);
3359:
3360: End If;
3361:
3362: Open l_line_name_csr (p_billrep_error_tbl(l_line_idx).Top_Line_id,detail_rec.Inv_organization_id );

Line 3374: 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)));

3370: l_line_num := detail_rec.line_number ;
3371:
3372: -- bug#4323607 maanand
3373:
3374: 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)));
3375:
3376: l_error_string1 := 'Reason: '||substr(p_billrep_error_tbl(l_line_idx).Error_Message,1,50);
3377: /* modified the substr for bug 10416595 skuchima */
3378: l_error_string2 := substr(p_billrep_error_tbl(l_line_idx).Error_Message,51,50);

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

3382: l_error_string6 := substr(p_billrep_error_tbl(l_line_idx).Error_Message,251,50);
3383: l_error_string7 := substr(p_billrep_error_tbl(l_line_idx).Error_Message,301,50);
3384:
3385: If length(l_error_string1) > 1 Then
3386: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string1 );
3387: End If;
3388: If length(l_error_string2) > 1 Then
3389: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string2);
3390: End If;

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

3385: If length(l_error_string1) > 1 Then
3386: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string1 );
3387: End If;
3388: If length(l_error_string2) > 1 Then
3389: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string2);
3390: End If;
3391: If length(l_error_string3) > 1 Then
3392: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string3);
3393: End If;

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

3388: If length(l_error_string2) > 1 Then
3389: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string2);
3390: End If;
3391: If length(l_error_string3) > 1 Then
3392: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string3);
3393: End If;
3394: If length(l_error_string4) > 1 Then
3395: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string4);
3396: End If;

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

3391: If length(l_error_string3) > 1 Then
3392: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string3);
3393: End If;
3394: If length(l_error_string4) > 1 Then
3395: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string4);
3396: End If;
3397: If length(l_error_string5) > 1 Then
3398: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string5);
3399: End If;

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

3394: If length(l_error_string4) > 1 Then
3395: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string4);
3396: End If;
3397: If length(l_error_string5) > 1 Then
3398: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string5);
3399: End If;
3400: If length(l_error_string6) > 1 Then
3401: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string6);
3402: End If;

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

3397: If length(l_error_string5) > 1 Then
3398: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string5);
3399: End If;
3400: If length(l_error_string6) > 1 Then
3401: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string6);
3402: End If;
3403: If length(l_error_string7) > 1 Then
3404: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string7);
3405: End If;

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

3400: If length(l_error_string6) > 1 Then
3401: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string6);
3402: End If;
3403: If length(l_error_string7) > 1 Then
3404: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string7);
3405: End If;
3406:
3407: End If;
3408: EXIT WHEN l_line_idx = p_billrep_error_tbl.LAST;

Line 3450: 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);

3446: l_dnz_chr_id := detail_rec.dnz_chr_id ;
3447: l_cont_num := detail_rec.Contract_number ;
3448: l_cont_num_mod := detail_rec.Contract_number_modifier ;
3449:
3450: 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);
3451:
3452: End If;
3453:
3454:

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

3468:
3469: select line_number into l_line_num from okc_k_lines_b
3470: where id=p_billrep_error_tbl(l_sub_line_idx).Top_Line_id;
3471:
3472: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||'Service Line: '||l_line_num||' '||l_line_name||' Service Account: '||l_service_account ) ;
3473:
3474: l_line_id :=p_billrep_error_tbl(l_sub_line_idx).Top_Line_id;
3475:
3476:

Line 3492: 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 ) ;

3488: l_sub_line_name := ' Name: '||Sub_Line_Name (l_subline_jtot_code,to_number(l_subline_obj1_id1),l_subline_obj1_id2 );
3489: l_bil_amt := to_char(detail_rec.price_negotiated ) ;
3490: l_line_num := detail_rec.line_number;
3491:
3492: 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 ) ;
3493: /* modified the substr for bug 10416595 skuchima */
3494: l_error_string1 := 'Reason: '||substr(p_billrep_error_tbl(l_sub_line_idx).Error_Message,1,50);
3495: l_error_string2 := substr(p_billrep_error_tbl(l_sub_line_idx).Error_Message,51,50);
3496: l_error_string3 := substr(p_billrep_error_tbl(l_sub_line_idx).Error_Message,101,50);

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

3499: l_error_string6 := substr(p_billrep_error_tbl(l_sub_line_idx).Error_Message,251,50);
3500: l_error_string7 := substr(p_billrep_error_tbl(l_sub_line_idx).Error_Message,301,50);
3501:
3502: If length(l_error_string1) > 1 Then
3503: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string1 );
3504: End If;
3505: If length(l_error_string2) > 1 Then
3506: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string2);
3507: End If;

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

3502: If length(l_error_string1) > 1 Then
3503: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string1 );
3504: End If;
3505: If length(l_error_string2) > 1 Then
3506: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string2);
3507: End If;
3508: If length(l_error_string3) > 1 Then
3509: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string3);
3510: End If;

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

3505: If length(l_error_string2) > 1 Then
3506: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string2);
3507: End If;
3508: If length(l_error_string3) > 1 Then
3509: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string3);
3510: End If;
3511: If length(l_error_string4) > 1 Then
3512: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string4);
3513: End If;

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

3508: If length(l_error_string3) > 1 Then
3509: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string3);
3510: End If;
3511: If length(l_error_string4) > 1 Then
3512: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string4);
3513: End If;
3514: If length(l_error_string5) > 1 Then
3515: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string5);
3516: End If;

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

3511: If length(l_error_string4) > 1 Then
3512: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string4);
3513: End If;
3514: If length(l_error_string5) > 1 Then
3515: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string5);
3516: End If;
3517: If length(l_error_string6) > 1 Then
3518: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string6);
3519: End If;

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

3514: If length(l_error_string5) > 1 Then
3515: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string5);
3516: End If;
3517: If length(l_error_string6) > 1 Then
3518: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string6);
3519: End If;
3520: If length(l_error_string7) > 1 Then
3521: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string7);
3522: End If;

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

3517: If length(l_error_string6) > 1 Then
3518: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string6);
3519: End If;
3520: If length(l_error_string7) > 1 Then
3521: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||l_string||l_string||l_error_string7);
3522: End If;
3523:
3524: End If;
3525: EXIT WHEN l_sub_line_idx = p_billrep_error_tbl.LAST;

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

3530:
3531:
3532: Exception When Others Then
3533: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR ;
3534: FND_FILE.PUT_LINE( FND_FILE.LOG, '*** Billing Report:: Print_Error_Report ' || sqlerrm);
3535: OKC_API.SET_MESSAGE
3536: (P_App_Name => G_APP_NAME
3537: ,P_Msg_Name => G_UNEXPECTED_ERROR
3538: ,P_Token1 => G_SQLCODE_TOKEN

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

3587:
3588:
3589: fnd_message.set_name('OKS','OKS_BILLREP_TITLE');
3590: l_msg := fnd_message.get;
3591: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3592: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3593: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3594: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' '|| l_msg ||' ') ;
3595: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' **************************************** ') ;

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

3588:
3589: fnd_message.set_name('OKS','OKS_BILLREP_TITLE');
3590: l_msg := fnd_message.get;
3591: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3592: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3593: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3594: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' '|| l_msg ||' ') ;
3595: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' **************************************** ') ;
3596:

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

3589: fnd_message.set_name('OKS','OKS_BILLREP_TITLE');
3590: l_msg := fnd_message.get;
3591: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3592: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3593: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3594: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' '|| l_msg ||' ') ;
3595: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' **************************************** ') ;
3596:
3597: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;

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

3590: l_msg := fnd_message.get;
3591: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3592: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3593: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3594: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' '|| l_msg ||' ') ;
3595: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' **************************************** ') ;
3596:
3597: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3598: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;

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

3591: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3592: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3593: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3594: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' '|| l_msg ||' ') ;
3595: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' **************************************** ') ;
3596:
3597: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3598: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3599: /* *** Print the currency break up for each currency *** */

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

3593: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3594: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' '|| l_msg ||' ') ;
3595: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' **************************************** ') ;
3596:
3597: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3598: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3599: /* *** Print the currency break up for each currency *** */
3600:
3601:

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

3594: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' '|| l_msg ||' ') ;
3595: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' **************************************** ') ;
3596:
3597: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3598: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
3599: /* *** Print the currency break up for each currency *** */
3600:
3601:
3602: --Start mchoudha Bug#3537100 17-APR-04

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

3643: ,x_return_status => l_return_status
3644: ) ;
3645:
3646: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
3647: FND_FILE.PUT_LINE( FND_FILE.LOG, '*** Billing Report:: PRINT_CURRENCY_BREAK procedure failed for : ' || p_billrep_table(i).Currency_code ||' Error: '||sqlerrm);
3648: x_return_status := l_return_status ;
3649: Raise Create_Report_Exception ;
3650: END IF;
3651:

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

3656:
3657:
3658:
3659:
3660: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_curr_break_line); /* print a line after the currency summary */
3661:
3662:
3663: /* -- Procedure call to print the error report */
3664:

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

3682: EXCEPTION
3683:
3684: WHEN Create_Report_Exception Then
3685: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR ;
3686: FND_FILE.PUT_LINE( FND_FILE.LOG, '***** Billing Report has errors :: Report Exception ***** '||sqlerrm) ;
3687: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '*** Billing Report has errors **** '||sqlerrm);
3688: OKC_API.SET_MESSAGE
3689: (P_App_Name => G_APP_NAME
3690: ,P_Msg_Name => G_UNEXPECTED_ERROR

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

3683:
3684: WHEN Create_Report_Exception Then
3685: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR ;
3686: FND_FILE.PUT_LINE( FND_FILE.LOG, '***** Billing Report has errors :: Report Exception ***** '||sqlerrm) ;
3687: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '*** Billing Report has errors **** '||sqlerrm);
3688: OKC_API.SET_MESSAGE
3689: (P_App_Name => G_APP_NAME
3690: ,P_Msg_Name => G_UNEXPECTED_ERROR
3691: ,P_Token1 => G_SQLCODE_TOKEN

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

3694: ,P_Token2_Value => SQLERRM);
3695:
3696: WHEN Others Then
3697: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR ;
3698: FND_FILE.PUT_LINE( FND_FILE.LOG, '***** Billing Report has errors :: When Others ***** '||sqlerrm) ;
3699: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '*** Billing Report has errors **** '||sqlerrm);
3700: OKC_API.SET_MESSAGE
3701: (P_App_Name => G_APP_NAME
3702: ,P_Msg_Name => G_UNEXPECTED_ERROR

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

3695:
3696: WHEN Others Then
3697: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR ;
3698: FND_FILE.PUT_LINE( FND_FILE.LOG, '***** Billing Report has errors :: When Others ***** '||sqlerrm) ;
3699: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '*** Billing Report has errors **** '||sqlerrm);
3700: OKC_API.SET_MESSAGE
3701: (P_App_Name => G_APP_NAME
3702: ,P_Msg_Name => G_UNEXPECTED_ERROR
3703: ,P_Token1 => G_SQLCODE_TOKEN

Line 4061: fnd_file.put_line (fnd_file.LOG,

4057: /*Added for ER 16039680*/
4058: OPEN get_line_dtls(P_LINE_ID);
4059: FETCH get_line_dtls INTO l_lse_id,l_start_date,l_end_date;
4060: CLOSE get_line_dtls;
4061: fnd_file.put_line (fnd_file.LOG,
4062: 'Create_Contract :- CREATE_BSL_FOR_OM l_start_date '
4063: || l_start_date ||' l_end_date '||l_end_date||' l_lse_id '||l_lse_id
4064: );
4065: IF l_lse_id = 46 THEN

Line 4070: fnd_file.put_line (fnd_file.LOG,

4066: OPEN L_LEVEL_ELEMENTS(P_LINE_ID);
4067: FETCH L_LEVEL_ELEMENTS INTO L_TOTAL_AMOUNT;
4068: IF L_LEVEL_ELEMENTS%FOUND THEN
4069: CLOSE L_LEVEL_ELEMENTS;
4070: fnd_file.put_line (fnd_file.LOG,
4071: 'Create_Contract :- CREATE_BSL_FOR_OM L_TOTAL_AMOUNT '
4072: || L_TOTAL_AMOUNT
4073: );
4074: L_BSLV_REC_IN.CLE_ID := P_LINE_ID;

Line 4093: fnd_file.put_line (fnd_file.LOG,

4089: X_MSG_DATA => L_MSG_DATA,
4090: P_BSLV_REC => L_BSLV_REC_IN,
4091: X_BSLV_REC => L_BSLV_REC_OUT
4092: );
4093: fnd_file.put_line (fnd_file.LOG,
4094: 'Create_Contract :- CREATE_BSL_FOR_OM L_RETURN_STATUS '
4095: || L_RETURN_STATUS
4096: );
4097: IF NOT L_RETURN_STATUS = OKC_API.G_RET_STS_SUCCESS THEN

Line 4484: fnd_file.put_line (fnd_file.LOG,

4480: END IF;
4481: ELSE
4482: FOR L_GET_COVERED_LEVELS_REC IN L_GET_COVERED_LEVELS_CSR(P_LINE_ID )
4483: LOOP
4484: fnd_file.put_line (fnd_file.LOG,
4485: 'Create_Contract :- CREATE_BSL_FOR_OM_OKS_SUBSCRIPTION SUBLINE_ID '
4486: || L_GET_COVERED_LEVELS_REC.ID
4487: );
4488: OPEN L_GET_BSL_CSR( L_GET_COVERED_LEVELS_REC.ID );

Line 4495: fnd_file.put_line (fnd_file.LOG,

4491: OPEN L_LEVEL_ELEMENTS(L_GET_COVERED_LEVELS_REC.ID,L_GET_COVERED_LEVELS_REC.COVERED_LEVEL_START_DATE);
4492: FETCH L_LEVEL_ELEMENTS INTO L_TOTAL_AMOUNT;
4493: IF L_LEVEL_ELEMENTS%FOUND THEN
4494: CLOSE L_LEVEL_ELEMENTS;
4495: fnd_file.put_line (fnd_file.LOG,
4496: 'Create_Contract :- CREATE_BSL_FOR_OM_OKS_SUBSCRIPTION L_TOTAL_AMOUNT'
4497: || L_TOTAL_AMOUNT
4498: );
4499: L_BSLV_REC_IN.CLE_ID := L_GET_COVERED_LEVELS_REC.ID;

Line 4518: fnd_file.put_line (fnd_file.LOG,

4514: X_MSG_DATA => L_MSG_DATA,
4515: P_BSLV_REC => L_BSLV_REC_IN,
4516: X_BSLV_REC => L_BSLV_REC_OUT
4517: );
4518: fnd_file.put_line (fnd_file.LOG,
4519: 'Create_Contract :- CREATE_BSL_FOR_OM_OKS_SUBSCRIPTION L_RETURN_STATUS'
4520: || L_RETURN_STATUS
4521: );
4522: IF NOT L_RETURN_STATUS = OKC_API.G_RET_STS_SUCCESS THEN

Line 4562: fnd_file.put_line (fnd_file.LOG,

4558: END IF;
4559: END LOOP ;
4560: X_TOTAL_AMOUNT := L_TOTAL_AMOUNT ;
4561: X_SUB_LINES_INSERTED := L_SUB_LINES_INSERTED ;
4562: fnd_file.put_line (fnd_file.LOG,
4563: 'Create_Contract :- CREATE_BSL_FOR_OM_OKS_SUBSCRIPTION L_SUB_LINES_INSERTED'
4564: || L_SUB_LINES_INSERTED
4565: );
4566: fnd_file.put_line (fnd_file.LOG,

Line 4566: fnd_file.put_line (fnd_file.LOG,

4562: fnd_file.put_line (fnd_file.LOG,
4563: 'Create_Contract :- CREATE_BSL_FOR_OM_OKS_SUBSCRIPTION L_SUB_LINES_INSERTED'
4564: || L_SUB_LINES_INSERTED
4565: );
4566: fnd_file.put_line (fnd_file.LOG,
4567: 'Create_Contract :- CREATE_BSL_FOR_OM_OKS_SUBSCRIPTION L_TOTAL_AMOUNT'
4568: || L_TOTAL_AMOUNT
4569: );
4570: END IF ;