DBA Data[Home] [Help]

APPS.AHL_WARRANTY_CONTRACTS_PVT dependencies on FND_FILE

Line 103: FND_FILE.put_line(FND_FILE.LOG, 'p_api_version -> '|| p_api_version);

99: -- Initialize error message stack by default
100: FND_MSG_PUB.Initialize;
101:
102: -- Standard call to check for call compatibility
103: FND_FILE.put_line(FND_FILE.LOG, 'p_api_version -> '|| p_api_version);
104: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
105: FND_FILE.put_line(FND_FILE.LOG, 'l_api_version -> '|| l_api_version);
106: FND_FILE.NEW_LINE(FND_FILE.LOG, 2);
107: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

Line 104: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

100: FND_MSG_PUB.Initialize;
101:
102: -- Standard call to check for call compatibility
103: FND_FILE.put_line(FND_FILE.LOG, 'p_api_version -> '|| p_api_version);
104: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
105: FND_FILE.put_line(FND_FILE.LOG, 'l_api_version -> '|| l_api_version);
106: FND_FILE.NEW_LINE(FND_FILE.LOG, 2);
107: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
108: retcode := 2;

Line 105: FND_FILE.put_line(FND_FILE.LOG, 'l_api_version -> '|| l_api_version);

101:
102: -- Standard call to check for call compatibility
103: FND_FILE.put_line(FND_FILE.LOG, 'p_api_version -> '|| p_api_version);
104: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
105: FND_FILE.put_line(FND_FILE.LOG, 'l_api_version -> '|| l_api_version);
106: FND_FILE.NEW_LINE(FND_FILE.LOG, 2);
107: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
108: retcode := 2;
109: errbuf := FND_MSG_PUB.Get;

Line 106: FND_FILE.NEW_LINE(FND_FILE.LOG, 2);

102: -- Standard call to check for call compatibility
103: FND_FILE.put_line(FND_FILE.LOG, 'p_api_version -> '|| p_api_version);
104: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
105: FND_FILE.put_line(FND_FILE.LOG, 'l_api_version -> '|| l_api_version);
106: FND_FILE.NEW_LINE(FND_FILE.LOG, 2);
107: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
108: retcode := 2;
109: errbuf := FND_MSG_PUB.Get;
110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 121: FND_FILE.put_line(FND_FILE.LOG, 'before calling AHL_SW_CONTRACTS_PVT.Create_Contract');

117: LOOP
118: FETCH auto_assign_item_instances_csr INTO auto_create_details_rec ;
119: EXIT WHEN auto_assign_item_instances_csr%NOTFOUND;
120:
121: FND_FILE.put_line(FND_FILE.LOG, 'before calling AHL_SW_CONTRACTS_PVT.Create_Contract');
122: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
123: FND_FILE.put_line(FND_FILE.LOG, 'p_warranty_template_id -> '|| auto_create_details_rec.WARRANTY_TEMPLATE_ID );
124: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
125: FND_FILE.put_line(FND_FILE.LOG, 'p_item_instance_id -> '|| auto_create_details_rec.INSTANCE_ID);

Line 122: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

118: FETCH auto_assign_item_instances_csr INTO auto_create_details_rec ;
119: EXIT WHEN auto_assign_item_instances_csr%NOTFOUND;
120:
121: FND_FILE.put_line(FND_FILE.LOG, 'before calling AHL_SW_CONTRACTS_PVT.Create_Contract');
122: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
123: FND_FILE.put_line(FND_FILE.LOG, 'p_warranty_template_id -> '|| auto_create_details_rec.WARRANTY_TEMPLATE_ID );
124: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
125: FND_FILE.put_line(FND_FILE.LOG, 'p_item_instance_id -> '|| auto_create_details_rec.INSTANCE_ID);
126: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

Line 123: FND_FILE.put_line(FND_FILE.LOG, 'p_warranty_template_id -> '|| auto_create_details_rec.WARRANTY_TEMPLATE_ID );

119: EXIT WHEN auto_assign_item_instances_csr%NOTFOUND;
120:
121: FND_FILE.put_line(FND_FILE.LOG, 'before calling AHL_SW_CONTRACTS_PVT.Create_Contract');
122: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
123: FND_FILE.put_line(FND_FILE.LOG, 'p_warranty_template_id -> '|| auto_create_details_rec.WARRANTY_TEMPLATE_ID );
124: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
125: FND_FILE.put_line(FND_FILE.LOG, 'p_item_instance_id -> '|| auto_create_details_rec.INSTANCE_ID);
126: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
127:

Line 124: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

120:
121: FND_FILE.put_line(FND_FILE.LOG, 'before calling AHL_SW_CONTRACTS_PVT.Create_Contract');
122: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
123: FND_FILE.put_line(FND_FILE.LOG, 'p_warranty_template_id -> '|| auto_create_details_rec.WARRANTY_TEMPLATE_ID );
124: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
125: FND_FILE.put_line(FND_FILE.LOG, 'p_item_instance_id -> '|| auto_create_details_rec.INSTANCE_ID);
126: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
127:
128: -- NOTE: p_init_msg_list, p_commit and p_validation_level will take their default values, and

Line 125: FND_FILE.put_line(FND_FILE.LOG, 'p_item_instance_id -> '|| auto_create_details_rec.INSTANCE_ID);

121: FND_FILE.put_line(FND_FILE.LOG, 'before calling AHL_SW_CONTRACTS_PVT.Create_Contract');
122: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
123: FND_FILE.put_line(FND_FILE.LOG, 'p_warranty_template_id -> '|| auto_create_details_rec.WARRANTY_TEMPLATE_ID );
124: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
125: FND_FILE.put_line(FND_FILE.LOG, 'p_item_instance_id -> '|| auto_create_details_rec.INSTANCE_ID);
126: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
127:
128: -- NOTE: p_init_msg_list, p_commit and p_validation_level will take their default values, and
129: -- commit will take place only after all the contracts have been created

Line 126: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

122: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
123: FND_FILE.put_line(FND_FILE.LOG, 'p_warranty_template_id -> '|| auto_create_details_rec.WARRANTY_TEMPLATE_ID );
124: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
125: FND_FILE.put_line(FND_FILE.LOG, 'p_item_instance_id -> '|| auto_create_details_rec.INSTANCE_ID);
126: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
127:
128: -- NOTE: p_init_msg_list, p_commit and p_validation_level will take their default values, and
129: -- commit will take place only after all the contracts have been created
130: AHL_WARRANTY_CONTRACTS_PVT.Create_Contract (

Line 142: FND_FILE.put_line(FND_FILE.LOG, 'l_index -> '||(l_index-1)||', x_warranty_contract_id -> '|| l_warranty_contract_id);

138:
139: l_warranty_cont_id_tbl(l_index) := l_warranty_contract_id;
140: l_index := l_index + 1;
141:
142: FND_FILE.put_line(FND_FILE.LOG, 'l_index -> '||(l_index-1)||', x_warranty_contract_id -> '|| l_warranty_contract_id);
143: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
144:
145: l_msg_count := FND_MSG_PUB.Count_Msg;
146: IF (l_msg_count > 0) THEN

Line 143: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

139: l_warranty_cont_id_tbl(l_index) := l_warranty_contract_id;
140: l_index := l_index + 1;
141:
142: FND_FILE.put_line(FND_FILE.LOG, 'l_index -> '||(l_index-1)||', x_warranty_contract_id -> '|| l_warranty_contract_id);
143: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
144:
145: l_msg_count := FND_MSG_PUB.Count_Msg;
146: IF (l_msg_count > 0) THEN
147: CLOSE auto_assign_item_instances_csr;

Line 155: FND_FILE.put_line(FND_FILE.LOG, 'after calling AHL_SW_CONTRACTS_PVT.Create_Contract');

151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
152: END IF;
153: END IF;
154:
155: FND_FILE.put_line(FND_FILE.LOG, 'after calling AHL_SW_CONTRACTS_PVT.Create_Contract');
156: FND_FILE.NEW_LINE(FND_FILE.LOG, 2);
157: END LOOP;
158: CLOSE auto_assign_item_instances_csr;
159:

Line 156: FND_FILE.NEW_LINE(FND_FILE.LOG, 2);

152: END IF;
153: END IF;
154:
155: FND_FILE.put_line(FND_FILE.LOG, 'after calling AHL_SW_CONTRACTS_PVT.Create_Contract');
156: FND_FILE.NEW_LINE(FND_FILE.LOG, 2);
157: END LOOP;
158: CLOSE auto_assign_item_instances_csr;
159:
160: IF (l_warranty_cont_id_tbl.COUNT > 0) THEN

Line 163: FND_FILE.put_line(FND_FILE.LOG, 'before calling AHL_WARRANTY_UTILS_PVT.Calc_Contract_Exp_Date');

159:
160: IF (l_warranty_cont_id_tbl.COUNT > 0) THEN
161: -- call AHL_WARRANTY_UTILS_PVT.Calc_Contract_Exp_Date API to calculate the expiration date
162: -- of the created contracts, including all their counters
163: FND_FILE.put_line(FND_FILE.LOG, 'before calling AHL_WARRANTY_UTILS_PVT.Calc_Contract_Exp_Date');
164: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
165: FND_FILE.put_line(FND_FILE.LOG, 'l_warranty_cont_id_tbl.COUNT -> '||l_warranty_cont_id_tbl.COUNT);
166: FND_FILE.NEW_LINE(FND_FILE.LOG, 2);
167:

Line 164: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

160: IF (l_warranty_cont_id_tbl.COUNT > 0) THEN
161: -- call AHL_WARRANTY_UTILS_PVT.Calc_Contract_Exp_Date API to calculate the expiration date
162: -- of the created contracts, including all their counters
163: FND_FILE.put_line(FND_FILE.LOG, 'before calling AHL_WARRANTY_UTILS_PVT.Calc_Contract_Exp_Date');
164: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
165: FND_FILE.put_line(FND_FILE.LOG, 'l_warranty_cont_id_tbl.COUNT -> '||l_warranty_cont_id_tbl.COUNT);
166: FND_FILE.NEW_LINE(FND_FILE.LOG, 2);
167:
168: AHL_WARRANTY_UTILS_PVT.Calc_Contract_Exp_Date(

Line 165: FND_FILE.put_line(FND_FILE.LOG, 'l_warranty_cont_id_tbl.COUNT -> '||l_warranty_cont_id_tbl.COUNT);

161: -- call AHL_WARRANTY_UTILS_PVT.Calc_Contract_Exp_Date API to calculate the expiration date
162: -- of the created contracts, including all their counters
163: FND_FILE.put_line(FND_FILE.LOG, 'before calling AHL_WARRANTY_UTILS_PVT.Calc_Contract_Exp_Date');
164: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
165: FND_FILE.put_line(FND_FILE.LOG, 'l_warranty_cont_id_tbl.COUNT -> '||l_warranty_cont_id_tbl.COUNT);
166: FND_FILE.NEW_LINE(FND_FILE.LOG, 2);
167:
168: AHL_WARRANTY_UTILS_PVT.Calc_Contract_Exp_Date(
169: p_api_version => l_api_version,

Line 166: FND_FILE.NEW_LINE(FND_FILE.LOG, 2);

162: -- of the created contracts, including all their counters
163: FND_FILE.put_line(FND_FILE.LOG, 'before calling AHL_WARRANTY_UTILS_PVT.Calc_Contract_Exp_Date');
164: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
165: FND_FILE.put_line(FND_FILE.LOG, 'l_warranty_cont_id_tbl.COUNT -> '||l_warranty_cont_id_tbl.COUNT);
166: FND_FILE.NEW_LINE(FND_FILE.LOG, 2);
167:
168: AHL_WARRANTY_UTILS_PVT.Calc_Contract_Exp_Date(
169: p_api_version => l_api_version,
170: p_warranty_contract_id_tbl => l_warranty_cont_id_tbl,

Line 184: FND_FILE.put_line(FND_FILE.LOG, 'after calling AHL_WARRANTY_UTILS_PVT.Calc_Contract_Exp_Date');

180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
181: END IF;
182: END IF;
183:
184: FND_FILE.put_line(FND_FILE.LOG, 'after calling AHL_WARRANTY_UTILS_PVT.Calc_Contract_Exp_Date');
185: FND_FILE.NEW_LINE(FND_FILE.LOG, 2);
186: END IF;
187:
188: -- set the output

Line 185: FND_FILE.NEW_LINE(FND_FILE.LOG, 2);

181: END IF;
182: END IF;
183:
184: FND_FILE.put_line(FND_FILE.LOG, 'after calling AHL_WARRANTY_UTILS_PVT.Calc_Contract_Exp_Date');
185: FND_FILE.NEW_LINE(FND_FILE.LOG, 2);
186: END IF;
187:
188: -- set the output
189: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, (l_index-1) || ' warranty contracts auto-created successfully.');

Line 189: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, (l_index-1) || ' warranty contracts auto-created successfully.');

185: FND_FILE.NEW_LINE(FND_FILE.LOG, 2);
186: END IF;
187:
188: -- set the output
189: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, (l_index-1) || ' warranty contracts auto-created successfully.');
190:
191: -- commit the work
192: COMMIT;
193:

Line 203: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Contract auto-creation process failed. Please refer the program logs for details.');

199: l_msg_count := FND_MSG_PUB.Count_Msg;
200: retcode := 2;
201:
202: -- set the output
203: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Contract auto-creation process failed. Please refer the program logs for details.');
204:
205: FND_FILE.put_line(FND_FILE.LOG, 'Following expected error(s) occured while creating warranty contract records..');
206: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
207: FOR i IN 1..l_msg_count

Line 205: FND_FILE.put_line(FND_FILE.LOG, 'Following expected error(s) occured while creating warranty contract records..');

201:
202: -- set the output
203: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Contract auto-creation process failed. Please refer the program logs for details.');
204:
205: FND_FILE.put_line(FND_FILE.LOG, 'Following expected error(s) occured while creating warranty contract records..');
206: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
207: FOR i IN 1..l_msg_count
208: LOOP
209: FND_MSG_PUB.get(

Line 206: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

202: -- set the output
203: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Contract auto-creation process failed. Please refer the program logs for details.');
204:
205: FND_FILE.put_line(FND_FILE.LOG, 'Following expected error(s) occured while creating warranty contract records..');
206: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
207: FOR i IN 1..l_msg_count
208: LOOP
209: FND_MSG_PUB.get(
210: p_msg_index => i,

Line 215: FND_FILE.put_line(FND_FILE.LOG, 'Err message-'||l_msg_index_out||':' || l_err_msg);

211: p_encoded => FND_API.G_FALSE,
212: p_data => l_err_msg,
213: p_msg_index_out => l_msg_index_out);
214:
215: FND_FILE.put_line(FND_FILE.LOG, 'Err message-'||l_msg_index_out||':' || l_err_msg);
216: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
217: END LOOP;
218:
219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 216: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

212: p_data => l_err_msg,
213: p_msg_index_out => l_msg_index_out);
214:
215: FND_FILE.put_line(FND_FILE.LOG, 'Err message-'||l_msg_index_out||':' || l_err_msg);
216: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
217: END LOOP;
218:
219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
220: ROLLBACK TO Auto_Create_Warranty_Contracts;

Line 225: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Contract auto-creation process failed. Please refer the program logs for details.');

221: l_msg_count := FND_MSG_PUB.Count_Msg;
222: retcode := 2;
223:
224: -- set the output
225: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Contract auto-creation process failed. Please refer the program logs for details.');
226:
227: FND_FILE.put_line(FND_FILE.LOG, 'Following unexpected error(s) occured while creating warranty contract records..');
228: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
229: FOR i IN 1..l_msg_count

Line 227: FND_FILE.put_line(FND_FILE.LOG, 'Following unexpected error(s) occured while creating warranty contract records..');

223:
224: -- set the output
225: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Contract auto-creation process failed. Please refer the program logs for details.');
226:
227: FND_FILE.put_line(FND_FILE.LOG, 'Following unexpected error(s) occured while creating warranty contract records..');
228: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
229: FOR i IN 1..l_msg_count
230: LOOP
231: FND_MSG_PUB.get(

Line 228: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

224: -- set the output
225: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Contract auto-creation process failed. Please refer the program logs for details.');
226:
227: FND_FILE.put_line(FND_FILE.LOG, 'Following unexpected error(s) occured while creating warranty contract records..');
228: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
229: FOR i IN 1..l_msg_count
230: LOOP
231: FND_MSG_PUB.get(
232: p_msg_index => i,

Line 237: FND_FILE.put_line(FND_FILE.LOG, 'Err message-'||l_msg_index_out||':' || l_err_msg);

233: p_encoded => FND_API.G_FALSE,
234: p_data => l_err_msg,
235: p_msg_index_out => l_msg_index_out);
236:
237: FND_FILE.put_line(FND_FILE.LOG, 'Err message-'||l_msg_index_out||':' || l_err_msg);
238: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
239: END LOOP;
240:
241: WHEN OTHERS THEN

Line 238: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

234: p_data => l_err_msg,
235: p_msg_index_out => l_msg_index_out);
236:
237: FND_FILE.put_line(FND_FILE.LOG, 'Err message-'||l_msg_index_out||':' || l_err_msg);
238: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
239: END LOOP;
240:
241: WHEN OTHERS THEN
242: ROLLBACK TO Auto_Create_Warranty_Contracts;

Line 254: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Contract auto-creation process failed. Please refer the program logs for details.');

250:
251: l_msg_count := Fnd_Msg_Pub.count_msg;
252:
253: -- set the output
254: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Contract auto-creation process failed. Please refer the program logs for details.');
255:
256: FND_FILE.put_line(FND_FILE.LOG, 'Following error occured while creating warranty contract records..');
257: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
258: FOR i IN 1..l_msg_count

Line 256: FND_FILE.put_line(FND_FILE.LOG, 'Following error occured while creating warranty contract records..');

252:
253: -- set the output
254: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Contract auto-creation process failed. Please refer the program logs for details.');
255:
256: FND_FILE.put_line(FND_FILE.LOG, 'Following error occured while creating warranty contract records..');
257: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
258: FOR i IN 1..l_msg_count
259: LOOP
260: fnd_msg_pub.get(

Line 257: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

253: -- set the output
254: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Contract auto-creation process failed. Please refer the program logs for details.');
255:
256: FND_FILE.put_line(FND_FILE.LOG, 'Following error occured while creating warranty contract records..');
257: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
258: FOR i IN 1..l_msg_count
259: LOOP
260: fnd_msg_pub.get(
261: p_msg_index => i,

Line 266: FND_FILE.put_line(FND_FILE.LOG, 'Err message-'||l_msg_index_out||':' || l_err_msg);

262: p_encoded => FND_API.G_FALSE,
263: p_data => l_err_msg,
264: p_msg_index_out => l_msg_index_out);
265:
266: FND_FILE.put_line(FND_FILE.LOG, 'Err message-'||l_msg_index_out||':' || l_err_msg);
267: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
268: END LOOP;
269:
270: END Auto_Create_Warranty_Contracts;

Line 267: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

263: p_data => l_err_msg,
264: p_msg_index_out => l_msg_index_out);
265:
266: FND_FILE.put_line(FND_FILE.LOG, 'Err message-'||l_msg_index_out||':' || l_err_msg);
267: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
268: END LOOP;
269:
270: END Auto_Create_Warranty_Contracts;
271: