395: COMMIT;
396: EXCEPTION
397: WHEN invalid_parameter_combination THEN
398: fnd_file.put_line (fnd_file.LOG, 'SQL Error Message :' || SQLERRM);
399: fnd_file.put_line (fnd_file.LOG, fnd_message.get);
400: retcode := 2;
401: errbuf := fnd_message.get_string ('IGS', 'IGS_PR_RNK_INV_PRM');
402: igs_ge_msg_stack.conc_exception_hndl;
403: WHEN OTHERS THEN
397: WHEN invalid_parameter_combination THEN
398: fnd_file.put_line (fnd_file.LOG, 'SQL Error Message :' || SQLERRM);
399: fnd_file.put_line (fnd_file.LOG, fnd_message.get);
400: retcode := 2;
401: errbuf := fnd_message.get_string ('IGS', 'IGS_PR_RNK_INV_PRM');
402: igs_ge_msg_stack.conc_exception_hndl;
403: WHEN OTHERS THEN
404: fnd_file.put_line (fnd_file.LOG, 'SQL Error Message :' || SQLERRM);
405: fnd_file.put_line (fnd_file.LOG, fnd_message.get);
401: errbuf := fnd_message.get_string ('IGS', 'IGS_PR_RNK_INV_PRM');
402: igs_ge_msg_stack.conc_exception_hndl;
403: WHEN OTHERS THEN
404: fnd_file.put_line (fnd_file.LOG, 'SQL Error Message :' || SQLERRM);
405: fnd_file.put_line (fnd_file.LOG, fnd_message.get);
406: retcode := 2;
407: errbuf := fnd_message.get_string ('IGS', 'IGS_GE_UNHANDLED_EXP');
408: igs_ge_msg_stack.conc_exception_hndl;
409: END upload_external_stats;
403: WHEN OTHERS THEN
404: fnd_file.put_line (fnd_file.LOG, 'SQL Error Message :' || SQLERRM);
405: fnd_file.put_line (fnd_file.LOG, fnd_message.get);
406: retcode := 2;
407: errbuf := fnd_message.get_string ('IGS', 'IGS_GE_UNHANDLED_EXP');
408: igs_ge_msg_stack.conc_exception_hndl;
409: END upload_external_stats;
410:
411:
492: RETURN TRUE;
493: EXCEPTION
494: WHEN OTHERS THEN
495: fnd_file.put_line (fnd_file.LOG, 'SQL Error Message :' || SQLERRM);
496: fnd_file.put_line (fnd_file.LOG, fnd_message.get);
497: igs_ge_msg_stack.conc_exception_hndl;
498: END validate_spa_record;
499:
500:
570: RETURN TRUE;
571: EXCEPTION
572: WHEN OTHERS THEN
573: fnd_file.put_line (fnd_file.LOG, 'SQL Error Message :' || SQLERRM);
574: fnd_file.put_line (fnd_file.LOG, fnd_message.get);
575: igs_ge_msg_stack.conc_exception_hndl;
576: END validate_susa_record;
577:
578:
664: app_short_name VARCHAR2 (10);
665: message_name VARCHAR2 (100);
666: BEGIN
667: fnd_file.put_line (fnd_file.LOG, 'SQL Error Message :' || SQLERRM);
668: fnd_message.parse_encoded (
669: fnd_message.get_encoded,
670: app_short_name,
671: message_name
672: );
665: message_name VARCHAR2 (100);
666: BEGIN
667: fnd_file.put_line (fnd_file.LOG, 'SQL Error Message :' || SQLERRM);
668: fnd_message.parse_encoded (
669: fnd_message.get_encoded,
670: app_short_name,
671: message_name
672: );
673: retcode := 2;
792: app_short_name VARCHAR2 (10);
793: message_name VARCHAR2 (100);
794: BEGIN
795: fnd_file.put_line (fnd_file.LOG, 'SQL Error Message :' || SQLERRM);
796: fnd_message.parse_encoded (
797: fnd_message.get_encoded,
798: app_short_name,
799: message_name
800: );
793: message_name VARCHAR2 (100);
794: BEGIN
795: fnd_file.put_line (fnd_file.LOG, 'SQL Error Message :' || SQLERRM);
796: fnd_message.parse_encoded (
797: fnd_message.get_encoded,
798: app_short_name,
799: message_name
800: );
801: retcode := 2;
1016: fnd_file.put_line (
1017: fnd_file.LOG,
1018: 'SQL Error Message :' || SUBSTR (SQLERRM, 1, 200)
1019: );
1020: fnd_file.put_line (fnd_file.LOG, fnd_message.get);
1021: retcode := 2;
1022: errbuf := fnd_message.get_string ('IGS', 'IGS_PR_RNK_INV_PRM');
1023: igs_ge_msg_stack.conc_exception_hndl;
1024: WHEN OTHERS THEN
1018: 'SQL Error Message :' || SUBSTR (SQLERRM, 1, 200)
1019: );
1020: fnd_file.put_line (fnd_file.LOG, fnd_message.get);
1021: retcode := 2;
1022: errbuf := fnd_message.get_string ('IGS', 'IGS_PR_RNK_INV_PRM');
1023: igs_ge_msg_stack.conc_exception_hndl;
1024: WHEN OTHERS THEN
1025: fnd_file.put_line (
1026: fnd_file.LOG,
1025: fnd_file.put_line (
1026: fnd_file.LOG,
1027: 'SQL Error Message :' || SUBSTR (SQLERRM, 1, 200)
1028: );
1029: fnd_file.put_line (fnd_file.LOG, fnd_message.get);
1030: retcode := 2;
1031: errbuf := fnd_message.get_string ('IGS', 'IGS_GE_UNHANDLED_EXP');
1032: igs_ge_msg_stack.conc_exception_hndl;
1033: END upload_external_completion;
1027: 'SQL Error Message :' || SUBSTR (SQLERRM, 1, 200)
1028: );
1029: fnd_file.put_line (fnd_file.LOG, fnd_message.get);
1030: retcode := 2;
1031: errbuf := fnd_message.get_string ('IGS', 'IGS_GE_UNHANDLED_EXP');
1032: igs_ge_msg_stack.conc_exception_hndl;
1033: END upload_external_completion;
1034: END igs_pr_upload_ext_results;