DBA Data[Home] [Help]

APPS.INV_INVKBCPR_XMLP_PKG dependencies on FND_FILE

Line 198: fnd_file.put_line (fnd_file.LOG, 'call_kanban_report');

194: l_language VARCHAR2 (10);
195: l_territory VARCHAR2 (10);
196: l_add_layout BOOLEAN;
197: BEGIN
198: fnd_file.put_line (fnd_file.LOG, 'call_kanban_report');
199: fnd_file.put_line (fnd_file.LOG,
200: 'P_PULL_SEQUENCE_ID: ' || P_PULL_SEQUENCE_ID
201: );
202: fnd_file.put_line (fnd_file.LOG,

Line 199: fnd_file.put_line (fnd_file.LOG,

195: l_territory VARCHAR2 (10);
196: l_add_layout BOOLEAN;
197: BEGIN
198: fnd_file.put_line (fnd_file.LOG, 'call_kanban_report');
199: fnd_file.put_line (fnd_file.LOG,
200: 'P_PULL_SEQUENCE_ID: ' || P_PULL_SEQUENCE_ID
201: );
202: fnd_file.put_line (fnd_file.LOG,
203: 'P_MUL_KBN_CARD_IDS: ' || p_mul_kbn_card_ids

Line 202: fnd_file.put_line (fnd_file.LOG,

198: fnd_file.put_line (fnd_file.LOG, 'call_kanban_report');
199: fnd_file.put_line (fnd_file.LOG,
200: 'P_PULL_SEQUENCE_ID: ' || P_PULL_SEQUENCE_ID
201: );
202: fnd_file.put_line (fnd_file.LOG,
203: 'P_MUL_KBN_CARD_IDS: ' || p_mul_kbn_card_ids
204: );
205:
206: IF P_PULL_SEQUENCE_ID IS NOT NULL THEN

Line 208: fnd_file.put_line (fnd_file.LOG,

204: );
205:
206: IF P_PULL_SEQUENCE_ID IS NOT NULL THEN
207: v_report_id:=0;
208: fnd_file.put_line (fnd_file.LOG,
209: 'Call from is 3 and Pull sequence is Passed'
210: );
211: IF v_report_id IS NULL
212: THEN

Line 229: fnd_file.put_line (fnd_file.LOG, 'no of kanban cards selceted : ' || l_count);

225: l_count :=
226: LENGTH (p_mul_kbn_card_ids)
227: - LENGTH (REPLACE (p_mul_kbn_card_ids, ',', ''))
228: + 1;
229: fnd_file.put_line (fnd_file.LOG, 'no of kanban cards selceted : ' || l_count);
230:
231: -- In oracle 11g use regexp_count to determine l_count
232: FOR i IN 1 .. l_count
233: LOOP

Line 251: fnd_file.put_line (fnd_file.LOG, 'v_report_id: ' || v_report_id);

247: VALUES (v_report_id, l_value
248: );
249: END LOOP;
250:
251: fnd_file.put_line (fnd_file.LOG, 'v_report_id: ' || v_report_id);
252: END IF;
253: -- call to report conc pgm report
254: IF v_report_id IS NOT NULL OR P_PULL_SEQUENCE_ID IS NOT NULL
255: THEN

Line 266: fnd_file.put_line(fnd_file.log, fnd_message.get);

262: AND NSP.value = FL.nls_language;
263: EXCEPTION
264: WHEN NO_DATA_FOUND THEN
265: FND_MESSAGE.set_name('FLM', 'FLM_SET_NLS_PARAM');
266: fnd_file.put_line(fnd_file.log, fnd_message.get);
267: END;
268: l_add_layout :=
269: fnd_request.add_layout ('INV', 'INVKBCPR_XML', l_language, l_territory, 'RTF');
270:

Line 309: fnd_file.put_line (fnd_file.LOG, 'request_id: ' || x_request_id);

305: END IF;
306: retcode := 0 ;
307: x_request_id := v_request_id;
308:
309: fnd_file.put_line (fnd_file.LOG, 'request_id: ' || x_request_id);
310: EXCEPTION
311: WHEN OTHERS
312: THEN
313: retcode := 2;

Line 315: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);

311: WHEN OTHERS
312: THEN
313: retcode := 2;
314: errbuf := SQLCODE || ':' || SQLERRM;
315: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
316: END call_kanban_report;
317: END INV_INVKBCPR_XMLP_PKG;
318: