704:
705: EXCEPTION
706: WHEN NO_DATA_FOUND
707: THEN
708: fnd_file.put_line (fnd_file.LOG, SUBSTR ('No data found in Update_Next_Level_Proc_Info'
709: || SUBSTR (SQLERRM, 1, 100), 1, 200));
710:
711: WHEN OTHERS
712: THEN
709: || SUBSTR (SQLERRM, 1, 100), 1, 200));
710:
711: WHEN OTHERS
712: THEN
713: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in Update_Next_Level_Proc_Info'
714: || SUBSTR (SQLERRM, 1, 100), 1, 200));
715:
716: ---COMMIT;
717: end;
1415: WHEN NO_DATA_FOUND
1416: THEN
1417: --dbms_output.put_line('Objective - NO_DATA_FOUND');
1418:
1419: fnd_file.put_line (fnd_file.LOG, SUBSTR ('No data found in Update_Next_Level_Proc_Info'
1420: || SUBSTR (SQLERRM, 1, 100), 1, 200));
1421:
1422: WHEN OTHERS
1423: THEN
1422: WHEN OTHERS
1423: THEN
1424: --dbms_output.put_line('Objective -WHEN OTHERS');
1425:
1426: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in Update_Next_Level_Proc_Info'
1427: || SUBSTR (SQLERRM, 1, 100), 1, 200));
1428:
1429: ---COMMIT;
1430: end;
2271: WHEN NO_DATA_FOUND
2272: THEN
2273: --dbms_output.put_line('Objective - NO_DATA_FOUND');
2274:
2275: fnd_file.put_line (fnd_file.LOG, SUBSTR ('No data found in Update_Next_Level_Proc_Info'
2276: || SUBSTR (SQLERRM, 1, 100), 1, 200));
2277:
2278: WHEN OTHERS
2279: THEN
2278: WHEN OTHERS
2279: THEN
2280: --dbms_output.put_line('Objective -WHEN OTHERS');
2281:
2282: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in Update_Next_Level_Proc_Info'
2283: || SUBSTR (SQLERRM, 1, 100), 1, 200));
2284:
2285: ---COMMIT;
2286: end;
2306:
2307:
2308: EXCEPTION
2309: WHEN OTHERS THEN
2310: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
2311: -- dbms_output.put_line(SQLERRM);
2312: fnd_file.put_line(fnd_file.LOG, 'fin_certification_id ' || x_fin_certification_id );
2313:
2314: -- g_errbuf := SUBSTR (SQLERRM, 1, 2000) ;
2308: EXCEPTION
2309: WHEN OTHERS THEN
2310: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
2311: -- dbms_output.put_line(SQLERRM);
2312: fnd_file.put_line(fnd_file.LOG, 'fin_certification_id ' || x_fin_certification_id );
2313:
2314: -- g_errbuf := SUBSTR (SQLERRM, 1, 2000) ;
2315: -- g_retcode := '2';
2316:
2979: );
2980:
2981: EXCEPTION
2982: WHEN DUP_VAL_ON_INDEX THEN
2983: fnd_file.put_line(fnd_file.LOG, 'Duplicate row insert');
2984: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
2985: -- dbms_output.put_line(SQLERRM);
2986: fnd_file.put_line(fnd_file.LOG, 'natural_account_id' || x_natural_account_id );
2987: fnd_file.put_line(fnd_file.LOG, 'financial_item_id' || x_financial_item_id);
2980:
2981: EXCEPTION
2982: WHEN DUP_VAL_ON_INDEX THEN
2983: fnd_file.put_line(fnd_file.LOG, 'Duplicate row insert');
2984: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
2985: -- dbms_output.put_line(SQLERRM);
2986: fnd_file.put_line(fnd_file.LOG, 'natural_account_id' || x_natural_account_id );
2987: fnd_file.put_line(fnd_file.LOG, 'financial_item_id' || x_financial_item_id);
2988: fnd_file.put_line(fnd_file.LOG, 'fin_certification_id ' || x_fin_certification_id );
2982: WHEN DUP_VAL_ON_INDEX THEN
2983: fnd_file.put_line(fnd_file.LOG, 'Duplicate row insert');
2984: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
2985: -- dbms_output.put_line(SQLERRM);
2986: fnd_file.put_line(fnd_file.LOG, 'natural_account_id' || x_natural_account_id );
2987: fnd_file.put_line(fnd_file.LOG, 'financial_item_id' || x_financial_item_id);
2988: fnd_file.put_line(fnd_file.LOG, 'fin_certification_id ' || x_fin_certification_id );
2989:
2990: WHEN OTHERS THEN
2983: fnd_file.put_line(fnd_file.LOG, 'Duplicate row insert');
2984: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
2985: -- dbms_output.put_line(SQLERRM);
2986: fnd_file.put_line(fnd_file.LOG, 'natural_account_id' || x_natural_account_id );
2987: fnd_file.put_line(fnd_file.LOG, 'financial_item_id' || x_financial_item_id);
2988: fnd_file.put_line(fnd_file.LOG, 'fin_certification_id ' || x_fin_certification_id );
2989:
2990: WHEN OTHERS THEN
2991: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
2984: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
2985: -- dbms_output.put_line(SQLERRM);
2986: fnd_file.put_line(fnd_file.LOG, 'natural_account_id' || x_natural_account_id );
2987: fnd_file.put_line(fnd_file.LOG, 'financial_item_id' || x_financial_item_id);
2988: fnd_file.put_line(fnd_file.LOG, 'fin_certification_id ' || x_fin_certification_id );
2989:
2990: WHEN OTHERS THEN
2991: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
2992: -- dbms_output.put_line(SQLERRM);
2987: fnd_file.put_line(fnd_file.LOG, 'financial_item_id' || x_financial_item_id);
2988: fnd_file.put_line(fnd_file.LOG, 'fin_certification_id ' || x_fin_certification_id );
2989:
2990: WHEN OTHERS THEN
2991: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
2992: -- dbms_output.put_line(SQLERRM);
2993: fnd_file.put_line(fnd_file.LOG, 'natural_account_id' || x_natural_account_id );
2994: fnd_file.put_line(fnd_file.LOG, 'financial_item_id' || x_financial_item_id);
2995: fnd_file.put_line(fnd_file.LOG, 'fin_certification_id ' || x_fin_certification_id );
2989:
2990: WHEN OTHERS THEN
2991: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
2992: -- dbms_output.put_line(SQLERRM);
2993: fnd_file.put_line(fnd_file.LOG, 'natural_account_id' || x_natural_account_id );
2994: fnd_file.put_line(fnd_file.LOG, 'financial_item_id' || x_financial_item_id);
2995: fnd_file.put_line(fnd_file.LOG, 'fin_certification_id ' || x_fin_certification_id );
2996:
2997: --g_errbuf := SUBSTR (SQLERRM, 1, 2000) ;
2990: WHEN OTHERS THEN
2991: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
2992: -- dbms_output.put_line(SQLERRM);
2993: fnd_file.put_line(fnd_file.LOG, 'natural_account_id' || x_natural_account_id );
2994: fnd_file.put_line(fnd_file.LOG, 'financial_item_id' || x_financial_item_id);
2995: fnd_file.put_line(fnd_file.LOG, 'fin_certification_id ' || x_fin_certification_id );
2996:
2997: --g_errbuf := SUBSTR (SQLERRM, 1, 2000) ;
2998: --g_retcode := '2';
2991: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
2992: -- dbms_output.put_line(SQLERRM);
2993: fnd_file.put_line(fnd_file.LOG, 'natural_account_id' || x_natural_account_id );
2994: fnd_file.put_line(fnd_file.LOG, 'financial_item_id' || x_financial_item_id);
2995: fnd_file.put_line(fnd_file.LOG, 'fin_certification_id ' || x_fin_certification_id );
2996:
2997: --g_errbuf := SUBSTR (SQLERRM, 1, 2000) ;
2998: --g_retcode := '2';
2999:
3273:
3274: EXCEPTION
3275: WHEN NO_DATA_FOUND
3276: THEN
3277: fnd_file.put_line (fnd_file.LOG, SUBSTR ('No data found in Update_item_ctrl_components'
3278: || SUBSTR (SQLERRM, 1, 100), 1, 200));
3279:
3280: WHEN OTHERS
3281: THEN
3278: || SUBSTR (SQLERRM, 1, 100), 1, 200));
3279:
3280: WHEN OTHERS
3281: THEN
3282: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in Update_item_ctrl_components'
3283: || SUBSTR (SQLERRM, 1, 100), 1, 200));
3284:
3285:
3286: end;
3633:
3634: EXCEPTION
3635: WHEN NO_DATA_FOUND
3636: THEN
3637: fnd_file.put_line (fnd_file.LOG, SUBSTR ('No data found in Update_acc_ctrl_components'
3638: || SUBSTR (SQLERRM, 1, 100), 1, 200));
3639:
3640: WHEN OTHERS
3641: THEN
3638: || SUBSTR (SQLERRM, 1, 100), 1, 200));
3639:
3640: WHEN OTHERS
3641: THEN
3642: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in Update_acc_ctrl_components'
3643: || SUBSTR (SQLERRM, 1, 100), 1, 200));
3644:
3645:
3646: end;
3998:
3999: EXCEPTION
4000: WHEN NO_DATA_FOUND
4001: THEN
4002: fnd_file.put_line (fnd_file.LOG, SUBSTR ('No data found in Update_item_ctrl_components'
4003: || SUBSTR (SQLERRM, 1, 100), 1, 200));
4004:
4005: WHEN OTHERS
4006: THEN
4003: || SUBSTR (SQLERRM, 1, 100), 1, 200));
4004:
4005: WHEN OTHERS
4006: THEN
4007: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in Update_item_ctrl_components'
4008: || SUBSTR (SQLERRM, 1, 100), 1, 200));
4009:
4010:
4011: end;
4350:
4351: EXCEPTION
4352: WHEN NO_DATA_FOUND
4353: THEN
4354: fnd_file.put_line (fnd_file.LOG, SUBSTR ('No data found in Update_acc_ctrl_components'
4355: || SUBSTR (SQLERRM, 1, 100), 1, 200));
4356:
4357: WHEN OTHERS
4358: THEN
4355: || SUBSTR (SQLERRM, 1, 100), 1, 200));
4356:
4357: WHEN OTHERS
4358: THEN
4359: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in Update_acc_ctrl_components'
4360: || SUBSTR (SQLERRM, 1, 100), 1, 200));
4361:
4362:
4363: end;
4849:
4850: EXCEPTION
4851: WHEN NO_DATA_FOUND
4852: THEN
4853: fnd_file.put_line (fnd_file.LOG, SUBSTR ('No data found in Update_item_ctrl_components'
4854: || SUBSTR (SQLERRM, 1, 100), 1, 200));
4855:
4856: WHEN OTHERS
4857: THEN
4854: || SUBSTR (SQLERRM, 1, 100), 1, 200));
4855:
4856: WHEN OTHERS
4857: THEN
4858: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in Update_item_ctrl_components'
4859: || SUBSTR (SQLERRM, 1, 100), 1, 200));
4860:
4861:
4862: end;
5347:
5348: EXCEPTION
5349: WHEN NO_DATA_FOUND
5350: THEN
5351: fnd_file.put_line (fnd_file.LOG, SUBSTR ('No data found in Update_acc_ctrl_components'
5352: || SUBSTR (SQLERRM, 1, 100), 1, 200));
5353:
5354: WHEN OTHERS
5355: THEN
5352: || SUBSTR (SQLERRM, 1, 100), 1, 200));
5353:
5354: WHEN OTHERS
5355: THEN
5356: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in Update_acc_ctrl_components'
5357: || SUBSTR (SQLERRM, 1, 100), 1, 200));
5358:
5359:
5360: end;
5618: object_type = x_object_type ;
5619:
5620: /* EXCEPTION
5621: WHEN OTHERS THEN
5622: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
5623: fnd_file.put_line(fnd_file.LOG, 'natural_account_id' || x_natural_account_id );
5624: fnd_file.put_line(fnd_file.LOG, 'financial_item_id' || x_financial_item_id);
5625: fnd_file.put_line(fnd_file.LOG, 'fin_certification_id ' || x_fin_certification_id );
5626:
5619:
5620: /* EXCEPTION
5621: WHEN OTHERS THEN
5622: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
5623: fnd_file.put_line(fnd_file.LOG, 'natural_account_id' || x_natural_account_id );
5624: fnd_file.put_line(fnd_file.LOG, 'financial_item_id' || x_financial_item_id);
5625: fnd_file.put_line(fnd_file.LOG, 'fin_certification_id ' || x_fin_certification_id );
5626:
5627:
5620: /* EXCEPTION
5621: WHEN OTHERS THEN
5622: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
5623: fnd_file.put_line(fnd_file.LOG, 'natural_account_id' || x_natural_account_id );
5624: fnd_file.put_line(fnd_file.LOG, 'financial_item_id' || x_financial_item_id);
5625: fnd_file.put_line(fnd_file.LOG, 'fin_certification_id ' || x_fin_certification_id );
5626:
5627:
5628: RAISE ;
5621: WHEN OTHERS THEN
5622: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
5623: fnd_file.put_line(fnd_file.LOG, 'natural_account_id' || x_natural_account_id );
5624: fnd_file.put_line(fnd_file.LOG, 'financial_item_id' || x_financial_item_id);
5625: fnd_file.put_line(fnd_file.LOG, 'fin_certification_id ' || x_fin_certification_id );
5626:
5627:
5628: RAISE ;
5629: RETURN; */
5821: object_type = x_object_type ;
5822:
5823: /* EXCEPTION
5824: WHEN OTHERS THEN
5825: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
5826: fnd_file.put_line(fnd_file.LOG, 'natural_account_id' || x_natural_account_id );
5827: fnd_file.put_line(fnd_file.LOG, 'financial_item_id' || x_financial_item_id);
5828: fnd_file.put_line(fnd_file.LOG, 'fin_certification_id ' || x_fin_certification_id );
5829:
5822:
5823: /* EXCEPTION
5824: WHEN OTHERS THEN
5825: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
5826: fnd_file.put_line(fnd_file.LOG, 'natural_account_id' || x_natural_account_id );
5827: fnd_file.put_line(fnd_file.LOG, 'financial_item_id' || x_financial_item_id);
5828: fnd_file.put_line(fnd_file.LOG, 'fin_certification_id ' || x_fin_certification_id );
5829:
5830:
5823: /* EXCEPTION
5824: WHEN OTHERS THEN
5825: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
5826: fnd_file.put_line(fnd_file.LOG, 'natural_account_id' || x_natural_account_id );
5827: fnd_file.put_line(fnd_file.LOG, 'financial_item_id' || x_financial_item_id);
5828: fnd_file.put_line(fnd_file.LOG, 'fin_certification_id ' || x_fin_certification_id );
5829:
5830:
5831: RAISE ;
5824: WHEN OTHERS THEN
5825: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
5826: fnd_file.put_line(fnd_file.LOG, 'natural_account_id' || x_natural_account_id );
5827: fnd_file.put_line(fnd_file.LOG, 'financial_item_id' || x_financial_item_id);
5828: fnd_file.put_line(fnd_file.LOG, 'fin_certification_id ' || x_fin_certification_id );
5829:
5830:
5831: RAISE ;
5832: RETURN; */
6083: object_type = x_object_type ;
6084:
6085: /* EXCEPTION
6086: WHEN OTHERS THEN
6087: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
6088: fnd_file.put_line(fnd_file.LOG, 'natural_account_id' || x_natural_account_id );
6089: fnd_file.put_line(fnd_file.LOG, 'financial_item_id' || x_financial_item_id);
6090: fnd_file.put_line(fnd_file.LOG, 'fin_certification_id ' || x_fin_certification_id );
6091:
6084:
6085: /* EXCEPTION
6086: WHEN OTHERS THEN
6087: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
6088: fnd_file.put_line(fnd_file.LOG, 'natural_account_id' || x_natural_account_id );
6089: fnd_file.put_line(fnd_file.LOG, 'financial_item_id' || x_financial_item_id);
6090: fnd_file.put_line(fnd_file.LOG, 'fin_certification_id ' || x_fin_certification_id );
6091:
6092:
6085: /* EXCEPTION
6086: WHEN OTHERS THEN
6087: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
6088: fnd_file.put_line(fnd_file.LOG, 'natural_account_id' || x_natural_account_id );
6089: fnd_file.put_line(fnd_file.LOG, 'financial_item_id' || x_financial_item_id);
6090: fnd_file.put_line(fnd_file.LOG, 'fin_certification_id ' || x_fin_certification_id );
6091:
6092:
6093: RAISE ;
6086: WHEN OTHERS THEN
6087: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
6088: fnd_file.put_line(fnd_file.LOG, 'natural_account_id' || x_natural_account_id );
6089: fnd_file.put_line(fnd_file.LOG, 'financial_item_id' || x_financial_item_id);
6090: fnd_file.put_line(fnd_file.LOG, 'fin_certification_id ' || x_fin_certification_id );
6091:
6092:
6093: RAISE ;
6094: RETURN; */
6290: object_type = x_object_type ;
6291:
6292: /* EXCEPTION
6293: WHEN OTHERS THEN
6294: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
6295: fnd_file.put_line(fnd_file.LOG, 'natural_account_id' || x_natural_account_id );
6296: fnd_file.put_line(fnd_file.LOG, 'financial_item_id' || x_financial_item_id);
6297: fnd_file.put_line(fnd_file.LOG, 'fin_certification_id ' || x_fin_certification_id );
6298:
6291:
6292: /* EXCEPTION
6293: WHEN OTHERS THEN
6294: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
6295: fnd_file.put_line(fnd_file.LOG, 'natural_account_id' || x_natural_account_id );
6296: fnd_file.put_line(fnd_file.LOG, 'financial_item_id' || x_financial_item_id);
6297: fnd_file.put_line(fnd_file.LOG, 'fin_certification_id ' || x_fin_certification_id );
6298:
6299:
6292: /* EXCEPTION
6293: WHEN OTHERS THEN
6294: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
6295: fnd_file.put_line(fnd_file.LOG, 'natural_account_id' || x_natural_account_id );
6296: fnd_file.put_line(fnd_file.LOG, 'financial_item_id' || x_financial_item_id);
6297: fnd_file.put_line(fnd_file.LOG, 'fin_certification_id ' || x_fin_certification_id );
6298:
6299:
6300: RAISE ;
6293: WHEN OTHERS THEN
6294: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
6295: fnd_file.put_line(fnd_file.LOG, 'natural_account_id' || x_natural_account_id );
6296: fnd_file.put_line(fnd_file.LOG, 'financial_item_id' || x_financial_item_id);
6297: fnd_file.put_line(fnd_file.LOG, 'fin_certification_id ' || x_fin_certification_id );
6298:
6299:
6300: RAISE ;
6301: RETURN; */
6722:
6723: EXCEPTION
6724: WHEN NO_DATA_FOUND
6725: THEN
6726: fnd_file.put_line (fnd_file.LOG, SUBSTR ('No data found in Update_Next_Level_Proc_Info'
6727: || SUBSTR (SQLERRM, 1, 100), 1, 200));
6728:
6729: WHEN OTHERS
6730: THEN
6727: || SUBSTR (SQLERRM, 1, 100), 1, 200));
6728:
6729: WHEN OTHERS
6730: THEN
6731: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in Update_Next_Level_Proc_Info'
6732: || SUBSTR (SQLERRM, 1, 100), 1, 200));
6733:
6734: ---COMMIT;
6735: end;
7122:
7123: EXCEPTION
7124: WHEN NO_DATA_FOUND
7125: THEN
7126: fnd_file.put_line (fnd_file.LOG, SUBSTR ('No data found in Update_Next_Level_Proc_Info'
7127: || SUBSTR (SQLERRM, 1, 100), 1, 200));
7128:
7129: WHEN OTHERS
7130: THEN
7127: || SUBSTR (SQLERRM, 1, 100), 1, 200));
7128:
7129: WHEN OTHERS
7130: THEN
7131: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in Update_Next_Level_Proc_Info'
7132: || SUBSTR (SQLERRM, 1, 100), 1, 200));
7133:
7134: ---COMMIT;
7135: end;
7762:
7763: EXCEPTION
7764: WHEN NO_DATA_FOUND
7765: THEN
7766: fnd_file.put_line (fnd_file.LOG, SUBSTR ('No data found in Update_Next_Level_Proc_Info'
7767: || SUBSTR (SQLERRM, 1, 100), 1, 200));
7768:
7769: WHEN OTHERS
7770: THEN
7767: || SUBSTR (SQLERRM, 1, 100), 1, 200));
7768:
7769: WHEN OTHERS
7770: THEN
7771: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in Update_Next_Level_Proc_Info'
7772: || SUBSTR (SQLERRM, 1, 100), 1, 200));
7773:
7774: ---COMMIT;
7775: end;