DBA Data[Home] [Help]

APPS.OKC_RENEW_PVT dependencies on FND_FILE

Line 128: /* FND_FILE.PUT_LINE( FND_FILE.LOG, 'Start Auto Renew');

124: END IF;
125:
126: retcode := '0';
127: fnd_msg_pub.initialize;
128: /* FND_FILE.PUT_LINE( FND_FILE.LOG, 'Start Auto Renew');
129: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Id ' || to_char(p_chr_id));
130: FND_FILE.PUT_LINE( FND_FILE.LOG, 'timeunit ' || p_uom_code);
131: FND_FILE.PUT_LINE( FND_FILE.LOG, 'duration ' || to_char(p_duration)); */
132:

Line 129: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Id ' || to_char(p_chr_id));

125:
126: retcode := '0';
127: fnd_msg_pub.initialize;
128: /* FND_FILE.PUT_LINE( FND_FILE.LOG, 'Start Auto Renew');
129: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Id ' || to_char(p_chr_id));
130: FND_FILE.PUT_LINE( FND_FILE.LOG, 'timeunit ' || p_uom_code);
131: FND_FILE.PUT_LINE( FND_FILE.LOG, 'duration ' || to_char(p_duration)); */
132:
133: FOR auto_renew_rec IN cur_auto_renew

Line 130: FND_FILE.PUT_LINE( FND_FILE.LOG, 'timeunit ' || p_uom_code);

126: retcode := '0';
127: fnd_msg_pub.initialize;
128: /* FND_FILE.PUT_LINE( FND_FILE.LOG, 'Start Auto Renew');
129: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Id ' || to_char(p_chr_id));
130: FND_FILE.PUT_LINE( FND_FILE.LOG, 'timeunit ' || p_uom_code);
131: FND_FILE.PUT_LINE( FND_FILE.LOG, 'duration ' || to_char(p_duration)); */
132:
133: FOR auto_renew_rec IN cur_auto_renew
134: LOOP

Line 131: FND_FILE.PUT_LINE( FND_FILE.LOG, 'duration ' || to_char(p_duration)); */

127: fnd_msg_pub.initialize;
128: /* FND_FILE.PUT_LINE( FND_FILE.LOG, 'Start Auto Renew');
129: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Id ' || to_char(p_chr_id));
130: FND_FILE.PUT_LINE( FND_FILE.LOG, 'timeunit ' || p_uom_code);
131: FND_FILE.PUT_LINE( FND_FILE.LOG, 'duration ' || to_char(p_duration)); */
132:
133: FOR auto_renew_rec IN cur_auto_renew
134: LOOP
135: l_contract_number := auto_renew_rec.contract_number;

Line 162: 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;

Line 165: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);

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;

Line 182: -- FND_FILE.PUT_LINE( FND_FILE.LOG, 'Before Pre_Renew');

178: p_auto_renew_rec.p_contract_number := auto_renew_rec.contract_number;
179: p_auto_renew_rec.p_contract_modifier := auto_renew_rec.contract_number_modifier;
180: p_auto_renew_rec.p_perpetual_flag := OKC_API.G_FALSE;
181:
182: -- FND_FILE.PUT_LINE( FND_FILE.LOG, 'Before Pre_Renew');
183: IF (l_debug = 'Y') THEN
184: okc_debug.log('300: Before Pre_Renew');
185: END IF;
186: OKC_RENEW_PUB.PRE_Renew(p_api_version => 1,

Line 199: -- FND_FILE.PUT_LINE( FND_FILE.LOG, 'After Pre_Renew');

195: IF (l_debug = 'Y') THEN
196: okc_debug.log('400: After Pre_Renew');
197: END IF;
198:
199: -- FND_FILE.PUT_LINE( FND_FILE.LOG, 'After Pre_Renew');
200: -- FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_return_status ' || l_return_status)
201: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
202: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
203: x_return_status := l_return_status;

Line 200: -- FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_return_status ' || l_return_status)

196: okc_debug.log('400: After Pre_Renew');
197: END IF;
198:
199: -- FND_FILE.PUT_LINE( FND_FILE.LOG, 'After Pre_Renew');
200: -- FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_return_status ' || l_return_status)
201: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
202: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
203: x_return_status := l_return_status;
204: raise G_EXCEPTION_HALT_VALIDATION;

Line 213: Fnd_File.Put_Line(FND_FILE.LOG, l_msg);

209: p_data => l_msg);
210: For I In 1..l_msg_count LOOP
211: l_msg := FND_MSG_PUB.Get(p_msg_index => i,
212: p_encoded => 'F');
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');

Line 219: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);

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);

Line 224: 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;
228:

Line 248: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);

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;

Line 251: FND_FILE.PUT_LINE( FND_FILE.LOG,(FND_MSG_PUB.Get(I,p_encoded =>FND_API.G_FALSE )));

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;
253:
254: WHEN OTHERS THEN
255:

Line 269: FND_FILE.PUT_LINE( FND_FILE.LOG,(FND_MSG_PUB.Get(I,p_encoded =>FND_API.G_FALSE )));

265: p_token1_value => sqlcode,
266: p_token2 => g_sqlerrm_token,
267: p_token2_value => sqlerrm);
268: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
269: FND_FILE.PUT_LINE( FND_FILE.LOG,(FND_MSG_PUB.Get(I,p_encoded =>FND_API.G_FALSE )));
270: END LOOP;
271:
272: END Auto_Renew;
273: --------------------------------------------------------------------------------------------