168: okc_debug.Reset_Indentation;
169: END IF;
170: x_return_status:='U';
171:
172: fnd_message.set_name('OKC','OKC_CATASTROPHIC_ERROR');
173: fnd_message.set_token('ROUTINE',l_proc);
174: fnd_message.set_token('REASON',SQLERRM);
175: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
176: End ;
169: END IF;
170: x_return_status:='U';
171:
172: fnd_message.set_name('OKC','OKC_CATASTROPHIC_ERROR');
173: fnd_message.set_token('ROUTINE',l_proc);
174: fnd_message.set_token('REASON',SQLERRM);
175: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
176: End ;
177:
170: x_return_status:='U';
171:
172: fnd_message.set_name('OKC','OKC_CATASTROPHIC_ERROR');
173: fnd_message.set_token('ROUTINE',l_proc);
174: fnd_message.set_token('REASON',SQLERRM);
175: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
176: End ;
177:
178:
171:
172: fnd_message.set_name('OKC','OKC_CATASTROPHIC_ERROR');
173: fnd_message.set_token('ROUTINE',l_proc);
174: fnd_message.set_token('REASON',SQLERRM);
175: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
176: End ;
177:
178:
179: ----This procecure is added for rules migration, conversion data now resides in okc_k_headers_b
280: okc_debug.log('800: Exiting Add_Conversion_data:others Exception', 2);
281: okc_debug.Reset_Indentation;
282: END IF;
283:
284: fnd_message.set_name('OKC','OKC_CATASTROPHIC_ERROR');
285: fnd_message.set_token('ROUTINE',l_proc);
286: fnd_message.set_token('REASON',SQLERRM);
287: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
288:
281: okc_debug.Reset_Indentation;
282: END IF;
283:
284: fnd_message.set_name('OKC','OKC_CATASTROPHIC_ERROR');
285: fnd_message.set_token('ROUTINE',l_proc);
286: fnd_message.set_token('REASON',SQLERRM);
287: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
288:
289: END;
282: END IF;
283:
284: fnd_message.set_name('OKC','OKC_CATASTROPHIC_ERROR');
285: fnd_message.set_token('ROUTINE',l_proc);
286: fnd_message.set_token('REASON',SQLERRM);
287: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
288:
289: END;
290:
283:
284: fnd_message.set_name('OKC','OKC_CATASTROPHIC_ERROR');
285: fnd_message.set_token('ROUTINE',l_proc);
286: fnd_message.set_token('REASON',SQLERRM);
287: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
288:
289: END;
290:
291:
459: IF (l_debug = 'Y') THEN
460: okc_debug.log('1100: Upgrade not required ', 2);
461: END IF;
462: Else
463: fnd_message.set_name('OKC','OKC_K_CONV_ERROR');
464: fnd_message.set_token('CONTRACT_NUMBER',contracts_rec.contract_number);
465: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
466: IF (l_debug = 'Y') THEN
467: okc_debug.log('1100: Record not Updated ', 2);
460: okc_debug.log('1100: Upgrade not required ', 2);
461: END IF;
462: Else
463: fnd_message.set_name('OKC','OKC_K_CONV_ERROR');
464: fnd_message.set_token('CONTRACT_NUMBER',contracts_rec.contract_number);
465: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
466: IF (l_debug = 'Y') THEN
467: okc_debug.log('1100: Record not Updated ', 2);
468: END IF;
461: END IF;
462: Else
463: fnd_message.set_name('OKC','OKC_K_CONV_ERROR');
464: fnd_message.set_token('CONTRACT_NUMBER',contracts_rec.contract_number);
465: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
466: IF (l_debug = 'Y') THEN
467: okc_debug.log('1100: Record not Updated ', 2);
468: END IF;
469: k_failure_counter := k_failure_counter+1;
542: okc_debug.log('1200: Exiting CONVERT_CONTRACTS:NO_CONVERSION_RQD Exception', 2);
543: okc_debug.Reset_Indentation;
544: END IF;
545:
546: fnd_message.set_name('OKC','OKC_CONV_NOT_REQD');
547: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
548:
549: WHEN others THEN
550:
543: okc_debug.Reset_Indentation;
544: END IF;
545:
546: fnd_message.set_name('OKC','OKC_CONV_NOT_REQD');
547: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
548:
549: WHEN others THEN
550:
551: IF (l_debug = 'Y') THEN
552: okc_debug.log('1200: Exiting CONVERT_CONTRACTS:others Exception', 2);
553: okc_debug.Reset_Indentation;
554: END IF;
555:
556: fnd_message.set_name('OKC','OKC_CATASTROPHIC_ERROR');
557: fnd_message.set_token('ROUTINE',l_proc);
558: fnd_message.set_token('REASON',SQLERRM);
559: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
560: raise;
553: okc_debug.Reset_Indentation;
554: END IF;
555:
556: fnd_message.set_name('OKC','OKC_CATASTROPHIC_ERROR');
557: fnd_message.set_token('ROUTINE',l_proc);
558: fnd_message.set_token('REASON',SQLERRM);
559: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
560: raise;
561:
554: END IF;
555:
556: fnd_message.set_name('OKC','OKC_CATASTROPHIC_ERROR');
557: fnd_message.set_token('ROUTINE',l_proc);
558: fnd_message.set_token('REASON',SQLERRM);
559: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
560: raise;
561:
562:
555:
556: fnd_message.set_name('OKC','OKC_CATASTROPHIC_ERROR');
557: fnd_message.set_token('ROUTINE',l_proc);
558: fnd_message.set_token('REASON',SQLERRM);
559: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
560: raise;
561:
562:
563: END CONVERT_CONTRACTS;