156: raise G_EXCEPTION_HALT_VALIDATION;
157: ELSE
158: x_return_status := l_return_status;
159:
160: FND_MESSAGE.set_name('OKC','OKC_AUTO_RENEW_FAILURE');
161: FND_MESSAGE.set_token('NUMBER',auto_renew_rec.contract_number);
162: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
163:
164: FND_MESSAGE.set_name('OKC','OKC_GET_DURATION_ERROR');
157: ELSE
158: x_return_status := l_return_status;
159:
160: FND_MESSAGE.set_name('OKC','OKC_AUTO_RENEW_FAILURE');
161: FND_MESSAGE.set_token('NUMBER',auto_renew_rec.contract_number);
162: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
163:
164: FND_MESSAGE.set_name('OKC','OKC_GET_DURATION_ERROR');
165: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
158: x_return_status := l_return_status;
159:
160: FND_MESSAGE.set_name('OKC','OKC_AUTO_RENEW_FAILURE');
161: FND_MESSAGE.set_token('NUMBER',auto_renew_rec.contract_number);
162: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
163:
164: FND_MESSAGE.set_name('OKC','OKC_GET_DURATION_ERROR');
165: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
166: END IF;
160: FND_MESSAGE.set_name('OKC','OKC_AUTO_RENEW_FAILURE');
161: FND_MESSAGE.set_token('NUMBER',auto_renew_rec.contract_number);
162: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
163:
164: FND_MESSAGE.set_name('OKC','OKC_GET_DURATION_ERROR');
165: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
166: END IF;
167: ELSE
168:
161: FND_MESSAGE.set_token('NUMBER',auto_renew_rec.contract_number);
162: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
163:
164: FND_MESSAGE.set_name('OKC','OKC_GET_DURATION_ERROR');
165: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
166: END IF;
167: ELSE
168:
169: p_auto_renew_rec.p_contract_id := auto_renew_rec.id;
213: Fnd_File.Put_Line(FND_FILE.LOG, l_msg);
214:
215: END LOOP;
216:
217: FND_MESSAGE.set_name('OKC','OKC_AUTO_RENEW_FAILURE');
218: FND_MESSAGE.set_token('NUMBER',auto_renew_rec.contract_number);
219: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
220: END IF;
221: ELSE
214:
215: END LOOP;
216:
217: FND_MESSAGE.set_name('OKC','OKC_AUTO_RENEW_FAILURE');
218: FND_MESSAGE.set_token('NUMBER',auto_renew_rec.contract_number);
219: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
220: END IF;
221: ELSE
222: FND_MESSAGE.set_name('OKC','OKC_AUTO_RENEW_SUCCESS');
215: END LOOP;
216:
217: FND_MESSAGE.set_name('OKC','OKC_AUTO_RENEW_FAILURE');
218: FND_MESSAGE.set_token('NUMBER',auto_renew_rec.contract_number);
219: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
220: END IF;
221: ELSE
222: FND_MESSAGE.set_name('OKC','OKC_AUTO_RENEW_SUCCESS');
223: FND_MESSAGE.set_token('NUMBER',auto_renew_rec.contract_number);
218: FND_MESSAGE.set_token('NUMBER',auto_renew_rec.contract_number);
219: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
220: END IF;
221: ELSE
222: FND_MESSAGE.set_name('OKC','OKC_AUTO_RENEW_SUCCESS');
223: FND_MESSAGE.set_token('NUMBER',auto_renew_rec.contract_number);
224: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
225: END IF;
226:
219: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
220: END IF;
221: ELSE
222: FND_MESSAGE.set_name('OKC','OKC_AUTO_RENEW_SUCCESS');
223: FND_MESSAGE.set_token('NUMBER',auto_renew_rec.contract_number);
224: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
225: END IF;
226:
227: END IF;
220: END IF;
221: ELSE
222: FND_MESSAGE.set_name('OKC','OKC_AUTO_RENEW_SUCCESS');
223: FND_MESSAGE.set_token('NUMBER',auto_renew_rec.contract_number);
224: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
225: END IF;
226:
227: END IF;
228:
242: END IF;
243:
244: retcode := '2';
245:
246: FND_MESSAGE.set_name('OKC','OKC_AUTO_RENEW_FAILURE');
247: FND_MESSAGE.set_token('NUMBER',l_contract_number);
248: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
249:
250: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
243:
244: retcode := '2';
245:
246: FND_MESSAGE.set_name('OKC','OKC_AUTO_RENEW_FAILURE');
247: FND_MESSAGE.set_token('NUMBER',l_contract_number);
248: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
249:
250: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
251: FND_FILE.PUT_LINE( FND_FILE.LOG,(FND_MSG_PUB.Get(I,p_encoded =>FND_API.G_FALSE )));
244: retcode := '2';
245:
246: FND_MESSAGE.set_name('OKC','OKC_AUTO_RENEW_FAILURE');
247: FND_MESSAGE.set_token('NUMBER',l_contract_number);
248: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
249:
250: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
251: FND_FILE.PUT_LINE( FND_FILE.LOG,(FND_MSG_PUB.Get(I,p_encoded =>FND_API.G_FALSE )));
252: END LOOP;