eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBE_ONECLK_PVT dependencies on FND_FILE

Line 82: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Starting ibe_oneclk_pvt.Submit_Quotes Concurrent Program for organization id ' || FND_PROFILE.VALUE('ASO_PRODUCT_ORGANIZATION_ID'));

78: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
79: IBE_Util.Debug('start Submit Quotes');
80: END IF;
81:
82: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Starting ibe_oneclk_pvt.Submit_Quotes Concurrent Program for organization id ' || FND_PROFILE.VALUE('ASO_PRODUCT_ORGANIZATION_ID'));
83: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Starting ibe_oneclk_pvt.Submit_Quotes Concurrent Program for MO organization id ' || MO_GLOBAL.get_current_org_id());
84: SAVEPOINT Submit_Quotes_Pvt;
85: -- Standard call to check for call compatibility.
86: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 83: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Starting ibe_oneclk_pvt.Submit_Quotes Concurrent Program for MO organization id ' || MO_GLOBAL.get_current_org_id());

79: IBE_Util.Debug('start Submit Quotes');
80: END IF;
81:
82: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Starting ibe_oneclk_pvt.Submit_Quotes Concurrent Program for organization id ' || FND_PROFILE.VALUE('ASO_PRODUCT_ORGANIZATION_ID'));
83: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Starting ibe_oneclk_pvt.Submit_Quotes Concurrent Program for MO organization id ' || MO_GLOBAL.get_current_org_id());
84: SAVEPOINT Submit_Quotes_Pvt;
85: -- Standard call to check for call compatibility.
86: IF NOT FND_API.Compatible_API_Call (l_api_version,
87: 1.0 ,

Line 102: FND_FILE.PUT_LINE(FND_FILE.LOG,'profile variable IBE_1CLICK_CONSOLIDATION_TIME:' || l_consolidation_time_s);

98: -- Initialize API rturn status to success
99: x_return_status := FND_API.g_ret_sts_success;
100:
101: FND_PROFILE.get('IBE_1CLICK_CONSOLIDATION_TIME',l_consolidation_time_s);
102: FND_FILE.PUT_LINE(FND_FILE.LOG,'profile variable IBE_1CLICK_CONSOLIDATION_TIME:' || l_consolidation_time_s);
103: -- convert to number and divide by minutes in a day to express in
104: -- terms of days or fraction thereof
105: if (l_consolidation_time_s is not null) then
106: l_consolidation_time_n := to_number(l_consolidation_time_s) / 1440;

Line 109: FND_FILE.PUT_LINE(FND_FILE.LOG,'Looking for quotes last updated before: ' || to_char(l_earliest_time,'DD-MON-YYYY:HH:MI:SS'));

105: if (l_consolidation_time_s is not null) then
106: l_consolidation_time_n := to_number(l_consolidation_time_s) / 1440;
107: end if;
108: l_earliest_time := sysdate - l_consolidation_time_n;
109: FND_FILE.PUT_LINE(FND_FILE.LOG,'Looking for quotes last updated before: ' || to_char(l_earliest_time,'DD-MON-YYYY:HH:MI:SS'));
110:
111: open c_quotes(l_earliest_time);
112: loop
113: -- give each loop a fair start

Line 123: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

119: l_qte_header_rec.cust_account_id,
120: l_qte_header_rec.org_id;
121: exit when c_quotes%NOTFOUND;
122:
123: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
124: FND_FILE.PUT_LINE(FND_FILE.LOG,'##### PROCESSING QUOTE ID:' || l_qte_header_rec.quote_header_id || ' #####');
125:
126:
127: -- if error check email and maybe insert a row for email notification

Line 124: FND_FILE.PUT_LINE(FND_FILE.LOG,'##### PROCESSING QUOTE ID:' || l_qte_header_rec.quote_header_id || ' #####');

120: l_qte_header_rec.org_id;
121: exit when c_quotes%NOTFOUND;
122:
123: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
124: FND_FILE.PUT_LINE(FND_FILE.LOG,'##### PROCESSING QUOTE ID:' || l_qte_header_rec.quote_header_id || ' #####');
125:
126:
127: -- if error check email and maybe insert a row for email notification
128: -- dbms_output.put_line('OneClick Concurrent Trying to Submit...');

Line 132: FND_FILE.PUT_LINE(FND_FILE.LOG,'calling IBE_QUOTE_CHECKOUT_PVT.submitQuote ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));

128: -- dbms_output.put_line('OneClick Concurrent Trying to Submit...');
129: -- Whether auth payment succeeds or not try to submit the quote
130: -- bug 2426483 - set to gmiss so proper defaulting will happen in IBE_QUOTE_CHECKOUT_PVT
131: l_control_rec.BOOK_FLAG := FND_API.G_MISS_CHAR;
132: FND_FILE.PUT_LINE(FND_FILE.LOG,'calling IBE_QUOTE_CHECKOUT_PVT.submitQuote ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
133: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_control_rec.BOOK_FLAG ' || l_control_rec.BOOK_FLAG);
134:
135: --Need to call Contracts expert engine before placing the order to refresh the template with latest terms
136: --if user has made any changes to the cart.

Line 133: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_control_rec.BOOK_FLAG ' || l_control_rec.BOOK_FLAG);

129: -- Whether auth payment succeeds or not try to submit the quote
130: -- bug 2426483 - set to gmiss so proper defaulting will happen in IBE_QUOTE_CHECKOUT_PVT
131: l_control_rec.BOOK_FLAG := FND_API.G_MISS_CHAR;
132: FND_FILE.PUT_LINE(FND_FILE.LOG,'calling IBE_QUOTE_CHECKOUT_PVT.submitQuote ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
133: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_control_rec.BOOK_FLAG ' || l_control_rec.BOOK_FLAG);
134:
135: --Need to call Contracts expert engine before placing the order to refresh the template with latest terms
136: --if user has made any changes to the cart.
137: --This needs to be done only if the quote status is not "APPROVED"

Line 197: FND_FILE.PUT_LINE(FND_FILE.LOG,'back from IBE_QUOTE_CHECKOUT_PVT.submitQuote ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));

193: x_Msg_Count => x_msg_count ,
194: x_Msg_Data => x_msg_data,
195: x_hold_flag => l_hold_flag );
196:
197: FND_FILE.PUT_LINE(FND_FILE.LOG,'back from IBE_QUOTE_CHECKOUT_PVT.submitQuote ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
198:
199: if x_return_status <> FND_API.g_ret_sts_success then
200: l_count_fail := l_count_fail + 1;
201: FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');

Line 212: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unsuccessful call to IBE_QUOTE_CHECKOUT_PVT.submitQuote');

208: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
209: null;
210: end if;
211:
212: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unsuccessful call to IBE_QUOTE_CHECKOUT_PVT.submitQuote');
213: FND_FILE.PUT_LINE(FND_FILE.LOG,'Messages from FND_MSG_PUB....(if any):');
214: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ' || fnd_msg_pub.get(p_encoded => FND_API.g_false));
215: FND_FILE.PUT_LINE(FND_FILE.LOG, ' IBE_QUOTE_CHECKOUT_PVT.submitQuote returned ' || x_msg_count || ' messages.');
216: if x_msg_count = 1 then

Line 213: FND_FILE.PUT_LINE(FND_FILE.LOG,'Messages from FND_MSG_PUB....(if any):');

209: null;
210: end if;
211:
212: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unsuccessful call to IBE_QUOTE_CHECKOUT_PVT.submitQuote');
213: FND_FILE.PUT_LINE(FND_FILE.LOG,'Messages from FND_MSG_PUB....(if any):');
214: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ' || fnd_msg_pub.get(p_encoded => FND_API.g_false));
215: FND_FILE.PUT_LINE(FND_FILE.LOG, ' IBE_QUOTE_CHECKOUT_PVT.submitQuote returned ' || x_msg_count || ' messages.');
216: if x_msg_count = 1 then
217: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ' || x_msg_data);

Line 214: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ' || fnd_msg_pub.get(p_encoded => FND_API.g_false));

210: end if;
211:
212: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unsuccessful call to IBE_QUOTE_CHECKOUT_PVT.submitQuote');
213: FND_FILE.PUT_LINE(FND_FILE.LOG,'Messages from FND_MSG_PUB....(if any):');
214: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ' || fnd_msg_pub.get(p_encoded => FND_API.g_false));
215: FND_FILE.PUT_LINE(FND_FILE.LOG, ' IBE_QUOTE_CHECKOUT_PVT.submitQuote returned ' || x_msg_count || ' messages.');
216: if x_msg_count = 1 then
217: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ' || x_msg_data);
218: else

Line 215: FND_FILE.PUT_LINE(FND_FILE.LOG, ' IBE_QUOTE_CHECKOUT_PVT.submitQuote returned ' || x_msg_count || ' messages.');

211:
212: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unsuccessful call to IBE_QUOTE_CHECKOUT_PVT.submitQuote');
213: FND_FILE.PUT_LINE(FND_FILE.LOG,'Messages from FND_MSG_PUB....(if any):');
214: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ' || fnd_msg_pub.get(p_encoded => FND_API.g_false));
215: FND_FILE.PUT_LINE(FND_FILE.LOG, ' IBE_QUOTE_CHECKOUT_PVT.submitQuote returned ' || x_msg_count || ' messages.');
216: if x_msg_count = 1 then
217: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ' || x_msg_data);
218: else
219:

Line 217: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ' || x_msg_data);

213: FND_FILE.PUT_LINE(FND_FILE.LOG,'Messages from FND_MSG_PUB....(if any):');
214: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ' || fnd_msg_pub.get(p_encoded => FND_API.g_false));
215: FND_FILE.PUT_LINE(FND_FILE.LOG, ' IBE_QUOTE_CHECKOUT_PVT.submitQuote returned ' || x_msg_count || ' messages.');
216: if x_msg_count = 1 then
217: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ' || x_msg_data);
218: else
219:
220: for i in 1..x_msg_count loop
221: FND_FILE.PUT_LINE(FND_FILE.LOG, ' msg ' || i || ': ' || fnd_msg_pub.get(p_encoded => FND_API.g_false));

Line 221: FND_FILE.PUT_LINE(FND_FILE.LOG, ' msg ' || i || ': ' || fnd_msg_pub.get(p_encoded => FND_API.g_false));

217: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ' || x_msg_data);
218: else
219:
220: for i in 1..x_msg_count loop
221: FND_FILE.PUT_LINE(FND_FILE.LOG, ' msg ' || i || ': ' || fnd_msg_pub.get(p_encoded => FND_API.g_false));
222: end loop;
223: end if;
224:
225: else

Line 226: FND_FILE.PUT_LINE(FND_FILE.LOG,'SUCCESSFUL SUBMISSION - order number: ' || l_order_header_rec.order_number || ' / order status: ' || l_order_header_rec.status);

222: end loop;
223: end if;
224:
225: else
226: FND_FILE.PUT_LINE(FND_FILE.LOG,'SUCCESSFUL SUBMISSION - order number: ' || l_order_header_rec.order_number || ' / order status: ' || l_order_header_rec.status);
227: l_count_good := l_count_good + 1;
228: FND_FILE.PUT_LINE(FND_FILE.LOG,'Hold_flag is '||l_hold_flag);
229: end if;
230:

Line 228: FND_FILE.PUT_LINE(FND_FILE.LOG,'Hold_flag is '||l_hold_flag);

224:
225: else
226: FND_FILE.PUT_LINE(FND_FILE.LOG,'SUCCESSFUL SUBMISSION - order number: ' || l_order_header_rec.order_number || ' / order status: ' || l_order_header_rec.status);
227: l_count_good := l_count_good + 1;
228: FND_FILE.PUT_LINE(FND_FILE.LOG,'Hold_flag is '||l_hold_flag);
229: end if;
230:
231: FND_FILE.PUT_LINE(FND_FILE.LOG,'##### DONE PROCESSING QUOTE ID:' || l_qte_header_rec.quote_header_id || ' #####');
232: IF FND_API.To_Boolean( p_commit ) THEN

Line 231: FND_FILE.PUT_LINE(FND_FILE.LOG,'##### DONE PROCESSING QUOTE ID:' || l_qte_header_rec.quote_header_id || ' #####');

227: l_count_good := l_count_good + 1;
228: FND_FILE.PUT_LINE(FND_FILE.LOG,'Hold_flag is '||l_hold_flag);
229: end if;
230:
231: FND_FILE.PUT_LINE(FND_FILE.LOG,'##### DONE PROCESSING QUOTE ID:' || l_qte_header_rec.quote_header_id || ' #####');
232: IF FND_API.To_Boolean( p_commit ) THEN
233: COMMIT WORK;
234: END IF;
235:

Line 240: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Finished running ibe_oneclk_pvt.Submit_Quotes Concurrent Program for organization id ' || FND_PROFILE.VALUE('ASO_PRODUCT_ORGANIZATION_ID') || ' ');

236: end loop L_BIG_LOOP;
237: close c_quotes;
238:
239:
240: FND_FILE.PUT_LINE(FND_FILE.LOG, '**** Finished running ibe_oneclk_pvt.Submit_Quotes Concurrent Program for organization id ' || FND_PROFILE.VALUE('ASO_PRODUCT_ORGANIZATION_ID') || ' ****');
241: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Successful submissions: ' || to_char(l_count_good) || ' Failed to submit: ' || to_char(l_count_fail));
242:
243: -- for the other log file
244: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '**** Ran ibe_oneclk_pvt.Submit_Quotes Concurrent Program for organization id ' || FND_PROFILE.VALUE('ASO_PRODUCT_ORGANIZATION_ID') || ' ****');

Line 241: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Successful submissions: ' || to_char(l_count_good) || ' Failed to submit: ' || to_char(l_count_fail));

237: close c_quotes;
238:
239:
240: FND_FILE.PUT_LINE(FND_FILE.LOG, '**** Finished running ibe_oneclk_pvt.Submit_Quotes Concurrent Program for organization id ' || FND_PROFILE.VALUE('ASO_PRODUCT_ORGANIZATION_ID') || ' ****');
241: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Successful submissions: ' || to_char(l_count_good) || ' Failed to submit: ' || to_char(l_count_fail));
242:
243: -- for the other log file
244: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '**** Ran ibe_oneclk_pvt.Submit_Quotes Concurrent Program for organization id ' || FND_PROFILE.VALUE('ASO_PRODUCT_ORGANIZATION_ID') || ' ****');
245: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Successful submissions: ' || to_char(l_count_good) || ' Failed to submit: ' || to_char(l_count_fail));

Line 244: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Ran ibe_oneclk_pvt.Submit_Quotes Concurrent Program for organization id ' || FND_PROFILE.VALUE('ASO_PRODUCT_ORGANIZATION_ID') || ' ');

240: FND_FILE.PUT_LINE(FND_FILE.LOG, '**** Finished running ibe_oneclk_pvt.Submit_Quotes Concurrent Program for organization id ' || FND_PROFILE.VALUE('ASO_PRODUCT_ORGANIZATION_ID') || ' ****');
241: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Successful submissions: ' || to_char(l_count_good) || ' Failed to submit: ' || to_char(l_count_fail));
242:
243: -- for the other log file
244: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '**** Ran ibe_oneclk_pvt.Submit_Quotes Concurrent Program for organization id ' || FND_PROFILE.VALUE('ASO_PRODUCT_ORGANIZATION_ID') || ' ****');
245: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Successful submissions: ' || to_char(l_count_good) || ' Failed to submit: ' || to_char(l_count_fail));
246:
247: IF FND_API.To_Boolean( p_commit ) THEN
248: COMMIT WORK;

Line 245: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Successful submissions: ' || to_char(l_count_good) || ' Failed to submit: ' || to_char(l_count_fail));

241: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Successful submissions: ' || to_char(l_count_good) || ' Failed to submit: ' || to_char(l_count_fail));
242:
243: -- for the other log file
244: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '**** Ran ibe_oneclk_pvt.Submit_Quotes Concurrent Program for organization id ' || FND_PROFILE.VALUE('ASO_PRODUCT_ORGANIZATION_ID') || ' ****');
245: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Successful submissions: ' || to_char(l_count_good) || ' Failed to submit: ' || to_char(l_count_fail));
246:
247: IF FND_API.To_Boolean( p_commit ) THEN
248: COMMIT WORK;
249: END IF;

Line 263: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Expected Error exception. Successful submissions: ' || to_char(l_count_good) || ' Failed to submit: ' || to_char(l_count_fail));

259: EXCEPTION
260: WHEN FND_API.G_EXC_ERROR THEN
261: ROLLBACK TO Submit_Quotes_Pvt;
262: x_return_status := FND_API.G_RET_STS_ERROR ;
263: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Expected Error exception. Successful submissions: ' || to_char(l_count_good) || ' Failed to submit: ' || to_char(l_count_fail));
264: errbuf := fnd_message.get;
265: retcode := 2;
266:
267: FND_MSG_PUB.Count_And_Get(

Line 275: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected Error exception. Successful submissions: ' || to_char(l_count_good) || ' Failed to submit: ' || to_char(l_count_fail));

271:
272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
273: ROLLBACK TO Submit_Quotes_Pvt;
274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
275: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected Error exception. Successful submissions: ' || to_char(l_count_good) || ' Failed to submit: ' || to_char(l_count_fail));
276: errbuf := fnd_message.get;
277: retcode := 2;
278:
279: FND_MSG_PUB.Count_And_Get(

Line 288: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Other Error exception. Successful submissions: ' || to_char(l_count_good) || ' Failed to submit: ' || to_char(l_count_fail));

284: WHEN OTHERS THEN
285: ROLLBACK TO Submit_Quotes_Pvt;
286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
287:
288: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Other Error exception. Successful submissions: ' || to_char(l_count_good) || ' Failed to submit: ' || to_char(l_count_fail));
289:
290: errbuf := fnd_message.get;
291: retcode := 2;
292: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)