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.JAI_CMN_GST_INV_GEN_PKG dependencies on FND_FILE

Line 204: Fnd_File.PUT_LINE(Fnd_File.LOG, ' 1. Entered in the proc with parameters :');

200: ln_current_party_site_id := -9999;
201: ln_current_order_number := -9999;
202:
203: IF lv_debug = 'Y' THEN
204: Fnd_File.PUT_LINE(Fnd_File.LOG, ' 1. Entered in the proc with parameters :');
205: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_ORGANIZATION_ID :' || P_ORGANIZATION_ID);
206: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_LOCATION_ID :' || P_LOCATION_ID);
207: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_ORDER_NUMBER_FROM :' || P_ORDER_NUMBER_FROM);
208: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_ORDER_NUMBER_TO :' || P_ORDER_NUMBER_TO);

Line 205: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_ORGANIZATION_ID :' || P_ORGANIZATION_ID);

201: ln_current_order_number := -9999;
202:
203: IF lv_debug = 'Y' THEN
204: Fnd_File.PUT_LINE(Fnd_File.LOG, ' 1. Entered in the proc with parameters :');
205: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_ORGANIZATION_ID :' || P_ORGANIZATION_ID);
206: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_LOCATION_ID :' || P_LOCATION_ID);
207: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_ORDER_NUMBER_FROM :' || P_ORDER_NUMBER_FROM);
208: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_ORDER_NUMBER_TO :' || P_ORDER_NUMBER_TO);
209: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_ID_FROM :' || P_DELIVERY_ID_FROM);

Line 206: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_LOCATION_ID :' || P_LOCATION_ID);

202:
203: IF lv_debug = 'Y' THEN
204: Fnd_File.PUT_LINE(Fnd_File.LOG, ' 1. Entered in the proc with parameters :');
205: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_ORGANIZATION_ID :' || P_ORGANIZATION_ID);
206: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_LOCATION_ID :' || P_LOCATION_ID);
207: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_ORDER_NUMBER_FROM :' || P_ORDER_NUMBER_FROM);
208: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_ORDER_NUMBER_TO :' || P_ORDER_NUMBER_TO);
209: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_ID_FROM :' || P_DELIVERY_ID_FROM);
210: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_ID_TO :' || P_DELIVERY_ID_TO);

Line 207: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_ORDER_NUMBER_FROM :' || P_ORDER_NUMBER_FROM);

203: IF lv_debug = 'Y' THEN
204: Fnd_File.PUT_LINE(Fnd_File.LOG, ' 1. Entered in the proc with parameters :');
205: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_ORGANIZATION_ID :' || P_ORGANIZATION_ID);
206: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_LOCATION_ID :' || P_LOCATION_ID);
207: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_ORDER_NUMBER_FROM :' || P_ORDER_NUMBER_FROM);
208: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_ORDER_NUMBER_TO :' || P_ORDER_NUMBER_TO);
209: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_ID_FROM :' || P_DELIVERY_ID_FROM);
210: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_ID_TO :' || P_DELIVERY_ID_TO);
211: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_DATE_FROM :' || P_DELIVERY_DATE_FROM);

Line 208: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_ORDER_NUMBER_TO :' || P_ORDER_NUMBER_TO);

204: Fnd_File.PUT_LINE(Fnd_File.LOG, ' 1. Entered in the proc with parameters :');
205: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_ORGANIZATION_ID :' || P_ORGANIZATION_ID);
206: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_LOCATION_ID :' || P_LOCATION_ID);
207: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_ORDER_NUMBER_FROM :' || P_ORDER_NUMBER_FROM);
208: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_ORDER_NUMBER_TO :' || P_ORDER_NUMBER_TO);
209: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_ID_FROM :' || P_DELIVERY_ID_FROM);
210: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_ID_TO :' || P_DELIVERY_ID_TO);
211: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_DATE_FROM :' || P_DELIVERY_DATE_FROM);
212: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_DATE_TO : ' || P_DELIVERY_DATE_TO);

Line 209: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_ID_FROM :' || P_DELIVERY_ID_FROM);

205: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_ORGANIZATION_ID :' || P_ORGANIZATION_ID);
206: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_LOCATION_ID :' || P_LOCATION_ID);
207: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_ORDER_NUMBER_FROM :' || P_ORDER_NUMBER_FROM);
208: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_ORDER_NUMBER_TO :' || P_ORDER_NUMBER_TO);
209: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_ID_FROM :' || P_DELIVERY_ID_FROM);
210: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_ID_TO :' || P_DELIVERY_ID_TO);
211: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_DATE_FROM :' || P_DELIVERY_DATE_FROM);
212: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_DATE_TO : ' || P_DELIVERY_DATE_TO);
213: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_PROCESS_ACTION :' || P_PROCESS_ACTION);

Line 210: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_ID_TO :' || P_DELIVERY_ID_TO);

206: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_LOCATION_ID :' || P_LOCATION_ID);
207: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_ORDER_NUMBER_FROM :' || P_ORDER_NUMBER_FROM);
208: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_ORDER_NUMBER_TO :' || P_ORDER_NUMBER_TO);
209: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_ID_FROM :' || P_DELIVERY_ID_FROM);
210: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_ID_TO :' || P_DELIVERY_ID_TO);
211: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_DATE_FROM :' || P_DELIVERY_DATE_FROM);
212: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_DATE_TO : ' || P_DELIVERY_DATE_TO);
213: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_PROCESS_ACTION :' || P_PROCESS_ACTION);
214: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_SINGLE_INVOICE_NUM :' || P_SINGLE_INVOICE_NUM);

Line 211: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_DATE_FROM :' || P_DELIVERY_DATE_FROM);

207: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_ORDER_NUMBER_FROM :' || P_ORDER_NUMBER_FROM);
208: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_ORDER_NUMBER_TO :' || P_ORDER_NUMBER_TO);
209: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_ID_FROM :' || P_DELIVERY_ID_FROM);
210: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_ID_TO :' || P_DELIVERY_ID_TO);
211: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_DATE_FROM :' || P_DELIVERY_DATE_FROM);
212: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_DATE_TO : ' || P_DELIVERY_DATE_TO);
213: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_PROCESS_ACTION :' || P_PROCESS_ACTION);
214: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_SINGLE_INVOICE_NUM :' || P_SINGLE_INVOICE_NUM);
215: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_OVERRIDE_INVOICE_DATE :' ||P_OVERRIDE_INVOICE_DATE);

Line 212: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_DATE_TO : ' || P_DELIVERY_DATE_TO);

208: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_ORDER_NUMBER_TO :' || P_ORDER_NUMBER_TO);
209: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_ID_FROM :' || P_DELIVERY_ID_FROM);
210: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_ID_TO :' || P_DELIVERY_ID_TO);
211: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_DATE_FROM :' || P_DELIVERY_DATE_FROM);
212: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_DATE_TO : ' || P_DELIVERY_DATE_TO);
213: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_PROCESS_ACTION :' || P_PROCESS_ACTION);
214: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_SINGLE_INVOICE_NUM :' || P_SINGLE_INVOICE_NUM);
215: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_OVERRIDE_INVOICE_DATE :' ||P_OVERRIDE_INVOICE_DATE);
216: END IF;

Line 213: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_PROCESS_ACTION :' || P_PROCESS_ACTION);

209: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_ID_FROM :' || P_DELIVERY_ID_FROM);
210: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_ID_TO :' || P_DELIVERY_ID_TO);
211: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_DATE_FROM :' || P_DELIVERY_DATE_FROM);
212: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_DATE_TO : ' || P_DELIVERY_DATE_TO);
213: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_PROCESS_ACTION :' || P_PROCESS_ACTION);
214: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_SINGLE_INVOICE_NUM :' || P_SINGLE_INVOICE_NUM);
215: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_OVERRIDE_INVOICE_DATE :' ||P_OVERRIDE_INVOICE_DATE);
216: END IF;
217: ln_conc_progam_id := FND_GLOBAL.conc_program_id;

Line 214: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_SINGLE_INVOICE_NUM :' || P_SINGLE_INVOICE_NUM);

210: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_ID_TO :' || P_DELIVERY_ID_TO);
211: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_DATE_FROM :' || P_DELIVERY_DATE_FROM);
212: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_DATE_TO : ' || P_DELIVERY_DATE_TO);
213: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_PROCESS_ACTION :' || P_PROCESS_ACTION);
214: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_SINGLE_INVOICE_NUM :' || P_SINGLE_INVOICE_NUM);
215: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_OVERRIDE_INVOICE_DATE :' ||P_OVERRIDE_INVOICE_DATE);
216: END IF;
217: ln_conc_progam_id := FND_GLOBAL.conc_program_id;
218: ln_conc_request_id := FND_GLOBAL.conc_request_id;

Line 215: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_OVERRIDE_INVOICE_DATE :' ||P_OVERRIDE_INVOICE_DATE);

211: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_DATE_FROM :' || P_DELIVERY_DATE_FROM);
212: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_DELIVERY_DATE_TO : ' || P_DELIVERY_DATE_TO);
213: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_PROCESS_ACTION :' || P_PROCESS_ACTION);
214: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_SINGLE_INVOICE_NUM :' || P_SINGLE_INVOICE_NUM);
215: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_OVERRIDE_INVOICE_DATE :' ||P_OVERRIDE_INVOICE_DATE);
216: END IF;
217: ln_conc_progam_id := FND_GLOBAL.conc_program_id;
218: ln_conc_request_id := FND_GLOBAL.conc_request_id;
219: ln_conc_prog_appl_id := FND_GLOBAL.prog_appl_id;

Line 231: Fnd_File.PUT_LINE(Fnd_File.LOG, ' +++ P_PROCESS_ACTION parameter IS NULL Hence returning +++ ' );

227: ln_success_delivery_Ctr :=0;
228: ln_interface_status :=0;
229:
230: IF P_PROCESS_ACTION IS NULL THEN
231: Fnd_File.PUT_LINE(Fnd_File.LOG, ' +++ P_PROCESS_ACTION parameter IS NULL Hence returning +++ ' );
232: RETURN;
233: END IF;
234:
235: /* only for the below two cases, non-shippable items will be ignored and don't be

Line 303: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Query SQL for shippable items only: '||lv_SQLStmt);

299: THEN
300: lv_SQLStmt := sql_stmt_shippable;
301: IF lv_debug = 'Y'
302: THEN
303: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Query SQL for shippable items only: '||lv_SQLStmt);
304: END IF; -- lv_debug = 'Y'
305: ELSE
306: lv_SQLStmt := sql_stmt_all;
307: IF lv_debug = 'Y'

Line 309: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Query SQL for shippable and non-shippable items: '||lv_SQLStmt);

305: ELSE
306: lv_SQLStmt := sql_stmt_all;
307: IF lv_debug = 'Y'
308: THEN
309: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Query SQL for shippable and non-shippable items: '||lv_SQLStmt);
310: END IF; -- lv_debug = 'Y'
311: END IF; -- p_delivery_id_from IS NOT NULL AND p_delivery_id_to IS NOT NULL
312:
313: OPEN v_main_rec_cur FOR lv_SQLStmt;

Line 318: --Fnd_File.PUT_LINE(Fnd_File.LOG, 'delivery_id: '||mainrec.delivery_id||' order_line_id: '||mainrec.order_line_id);

314: LOOP
315: FETCH v_main_rec_cur INTO mainrec;
316: EXIT WHEN v_main_rec_cur%NOTFOUND;
317:
318: --Fnd_File.PUT_LINE(Fnd_File.LOG, 'delivery_id: '||mainrec.delivery_id||' order_line_id: '||mainrec.order_line_id);
319:
320: -- start processing records
321: IF mainrec.delivery_id IS NOT NULL -- for shippable line
322: THEN

Line 331: Fnd_File.PUT_LINE(Fnd_File.LOG,

327: CLOSE c_check_interface_status;
328:
329: IF ln_interface_status = 1
330: THEN
331: Fnd_File.PUT_LINE(Fnd_File.LOG,
332: 'Delivery - ' || mainrec.delivery_id ||
333: ' Cannot be processed because all delivery details'||
334: ' are not inventory interfaced');
335: ln_failure_delivery_ctr := NVL(ln_failure_Delivery_ctr,0) + 1;

Line 339: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Processing Delivery - ' || mainrec.delivery_id);

335: ln_failure_delivery_ctr := NVL(ln_failure_Delivery_ctr,0) + 1;
336: goto NEXTDELIVERY;
337: END IF; -- ln_interface_status = 1
338: IF lv_debug = 'Y' THEN
339: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Processing Delivery - ' || mainrec.delivery_id);
340: END IF; -- lv_debug = 'Y'
341: ELSE -- else for non-shippable line
342: lv_p_source := jai_constants.source_nsh;
343: IF lv_debug = 'Y' THEN

Line 344: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Processing Non-shippable Order Line - ' ||

340: END IF; -- lv_debug = 'Y'
341: ELSE -- else for non-shippable line
342: lv_p_source := jai_constants.source_nsh;
343: IF lv_debug = 'Y' THEN
344: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Processing Non-shippable Order Line - ' ||
345: mainrec.order_line_id);
346: END IF; -- lv_debug = 'Y'
347: END IF; -- mainrec.delivery_id IS NOT NULL
348:

Line 358: Fnd_File.PUT_LINE(Fnd_File.LOG, ' ln_current_party_id : ' || ln_current_party_id);

354: END IF; -- check_reg_dealer(mainrec.party_id,mainrec.party_site_id)
355:
356: IF lv_Debug = 'Y'
357: THEN
358: Fnd_File.PUT_LINE(Fnd_File.LOG, ' ln_current_party_id : ' || ln_current_party_id);
359: Fnd_File.PUT_LINE(Fnd_File.LOG, ' mainrec.party_id : ' || mainrec.party_id);
360: Fnd_File.PUT_LINE(Fnd_File.LOG, ' ln_current_party_site_id : ' || ln_current_party_site_id);
361: Fnd_File.PUT_LINE(Fnd_File.LOG, ' mainrec.party_site_id :' || mainrec.party_site_id);
362: Fnd_File.PUT_LINE(Fnd_File.LOG, ' ln_current_order_number : ' || ln_current_order_number);

Line 359: Fnd_File.PUT_LINE(Fnd_File.LOG, ' mainrec.party_id : ' || mainrec.party_id);

355:
356: IF lv_Debug = 'Y'
357: THEN
358: Fnd_File.PUT_LINE(Fnd_File.LOG, ' ln_current_party_id : ' || ln_current_party_id);
359: Fnd_File.PUT_LINE(Fnd_File.LOG, ' mainrec.party_id : ' || mainrec.party_id);
360: Fnd_File.PUT_LINE(Fnd_File.LOG, ' ln_current_party_site_id : ' || ln_current_party_site_id);
361: Fnd_File.PUT_LINE(Fnd_File.LOG, ' mainrec.party_site_id :' || mainrec.party_site_id);
362: Fnd_File.PUT_LINE(Fnd_File.LOG, ' ln_current_order_number : ' || ln_current_order_number);
363: Fnd_File.PUT_LINE(Fnd_File.LOG, ' mainrec.order_number :' || mainrec.order_number);

Line 360: Fnd_File.PUT_LINE(Fnd_File.LOG, ' ln_current_party_site_id : ' || ln_current_party_site_id);

356: IF lv_Debug = 'Y'
357: THEN
358: Fnd_File.PUT_LINE(Fnd_File.LOG, ' ln_current_party_id : ' || ln_current_party_id);
359: Fnd_File.PUT_LINE(Fnd_File.LOG, ' mainrec.party_id : ' || mainrec.party_id);
360: Fnd_File.PUT_LINE(Fnd_File.LOG, ' ln_current_party_site_id : ' || ln_current_party_site_id);
361: Fnd_File.PUT_LINE(Fnd_File.LOG, ' mainrec.party_site_id :' || mainrec.party_site_id);
362: Fnd_File.PUT_LINE(Fnd_File.LOG, ' ln_current_order_number : ' || ln_current_order_number);
363: Fnd_File.PUT_LINE(Fnd_File.LOG, ' mainrec.order_number :' || mainrec.order_number);
364: Fnd_File.PUT_LINE(Fnd_File.LOG, 'lv_doc_type_class:' || lv_doc_type_class);

Line 361: Fnd_File.PUT_LINE(Fnd_File.LOG, ' mainrec.party_site_id :' || mainrec.party_site_id);

357: THEN
358: Fnd_File.PUT_LINE(Fnd_File.LOG, ' ln_current_party_id : ' || ln_current_party_id);
359: Fnd_File.PUT_LINE(Fnd_File.LOG, ' mainrec.party_id : ' || mainrec.party_id);
360: Fnd_File.PUT_LINE(Fnd_File.LOG, ' ln_current_party_site_id : ' || ln_current_party_site_id);
361: Fnd_File.PUT_LINE(Fnd_File.LOG, ' mainrec.party_site_id :' || mainrec.party_site_id);
362: Fnd_File.PUT_LINE(Fnd_File.LOG, ' ln_current_order_number : ' || ln_current_order_number);
363: Fnd_File.PUT_LINE(Fnd_File.LOG, ' mainrec.order_number :' || mainrec.order_number);
364: Fnd_File.PUT_LINE(Fnd_File.LOG, 'lv_doc_type_class:' || lv_doc_type_class);
365: END IF; -- lv_Debug = 'Y'

Line 362: Fnd_File.PUT_LINE(Fnd_File.LOG, ' ln_current_order_number : ' || ln_current_order_number);

358: Fnd_File.PUT_LINE(Fnd_File.LOG, ' ln_current_party_id : ' || ln_current_party_id);
359: Fnd_File.PUT_LINE(Fnd_File.LOG, ' mainrec.party_id : ' || mainrec.party_id);
360: Fnd_File.PUT_LINE(Fnd_File.LOG, ' ln_current_party_site_id : ' || ln_current_party_site_id);
361: Fnd_File.PUT_LINE(Fnd_File.LOG, ' mainrec.party_site_id :' || mainrec.party_site_id);
362: Fnd_File.PUT_LINE(Fnd_File.LOG, ' ln_current_order_number : ' || ln_current_order_number);
363: Fnd_File.PUT_LINE(Fnd_File.LOG, ' mainrec.order_number :' || mainrec.order_number);
364: Fnd_File.PUT_LINE(Fnd_File.LOG, 'lv_doc_type_class:' || lv_doc_type_class);
365: END IF; -- lv_Debug = 'Y'
366:

Line 363: Fnd_File.PUT_LINE(Fnd_File.LOG, ' mainrec.order_number :' || mainrec.order_number);

359: Fnd_File.PUT_LINE(Fnd_File.LOG, ' mainrec.party_id : ' || mainrec.party_id);
360: Fnd_File.PUT_LINE(Fnd_File.LOG, ' ln_current_party_site_id : ' || ln_current_party_site_id);
361: Fnd_File.PUT_LINE(Fnd_File.LOG, ' mainrec.party_site_id :' || mainrec.party_site_id);
362: Fnd_File.PUT_LINE(Fnd_File.LOG, ' ln_current_order_number : ' || ln_current_order_number);
363: Fnd_File.PUT_LINE(Fnd_File.LOG, ' mainrec.order_number :' || mainrec.order_number);
364: Fnd_File.PUT_LINE(Fnd_File.LOG, 'lv_doc_type_class:' || lv_doc_type_class);
365: END IF; -- lv_Debug = 'Y'
366:
367: IF ln_current_party_id <> mainrec.party_id OR

Line 364: Fnd_File.PUT_LINE(Fnd_File.LOG, 'lv_doc_type_class:' || lv_doc_type_class);

360: Fnd_File.PUT_LINE(Fnd_File.LOG, ' ln_current_party_site_id : ' || ln_current_party_site_id);
361: Fnd_File.PUT_LINE(Fnd_File.LOG, ' mainrec.party_site_id :' || mainrec.party_site_id);
362: Fnd_File.PUT_LINE(Fnd_File.LOG, ' ln_current_order_number : ' || ln_current_order_number);
363: Fnd_File.PUT_LINE(Fnd_File.LOG, ' mainrec.order_number :' || mainrec.order_number);
364: Fnd_File.PUT_LINE(Fnd_File.LOG, 'lv_doc_type_class:' || lv_doc_type_class);
365: END IF; -- lv_Debug = 'Y'
366:
367: IF ln_current_party_id <> mainrec.party_id OR
368: ln_current_party_site_id <> mainrec.party_site_id

Line 390: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_inv_gen_status = '||lv_inv_gen_status );

386: CLOSE c_inv_gen_status ;
387:
388:
389: IF lv_debug = 'Y' THEN
390: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_inv_gen_status = '||lv_inv_gen_status );
391: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Regime:CGST:SGST Regime Id - ' ||ln_cgst_regime_id||':'||ln_sgst_regime_id);
392: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Global:CGST:SGST Regime Id - ' ||gn_cgst_regime_id||':'||gn_sgst_regime_id);
393: END IF;
394:

Line 391: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Regime:CGST:SGST Regime Id - ' ||ln_cgst_regime_id||':'||ln_sgst_regime_id);

387:
388:
389: IF lv_debug = 'Y' THEN
390: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_inv_gen_status = '||lv_inv_gen_status );
391: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Regime:CGST:SGST Regime Id - ' ||ln_cgst_regime_id||':'||ln_sgst_regime_id);
392: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Global:CGST:SGST Regime Id - ' ||gn_cgst_regime_id||':'||gn_sgst_regime_id);
393: END IF;
394:
395:

Line 392: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Global:CGST:SGST Regime Id - ' ||gn_cgst_regime_id||':'||gn_sgst_regime_id);

388:
389: IF lv_debug = 'Y' THEN
390: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_inv_gen_status = '||lv_inv_gen_status );
391: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Regime:CGST:SGST Regime Id - ' ||ln_cgst_regime_id||':'||ln_sgst_regime_id);
392: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Global:CGST:SGST Regime Id - ' ||gn_cgst_regime_id||':'||gn_sgst_regime_id);
393: END IF;
394:
395:
396: /* IF (((ln_regime_id = ln_cgst_regime_id) and (mainrec.cgst_inv_gen_status = 'C' OR lv_inv_gen_status = 'C') ) OR

Line 420: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_party_has_changed :' || lv_party_has_changed);

416: , vat_inv_gen_status => 'C');
417: */
418: IF lv_Debug = 'Y'
419: THEN
420: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_party_has_changed :' || lv_party_has_changed);
421: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_inv_num_already_generated :' || lv_inv_num_already_generated);
422: END IF; -- lv_Debug = 'Y'
423: IF p_process_action in (jai_constants.om_action_gen_inv_n_accnt ,jai_constants.om_action_gen_invoice)
424: THEN

Line 421: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_inv_num_already_generated :' || lv_inv_num_already_generated);

417: */
418: IF lv_Debug = 'Y'
419: THEN
420: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_party_has_changed :' || lv_party_has_changed);
421: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_inv_num_already_generated :' || lv_inv_num_already_generated);
422: END IF; -- lv_Debug = 'Y'
423: IF p_process_action in (jai_constants.om_action_gen_inv_n_accnt ,jai_constants.om_action_gen_invoice)
424: THEN
425: IF lv_inv_num_already_generated = jai_constants.value_false

Line 428: Fnd_File.PUT_LINE(Fnd_File.LOG, ' before call to jai_cmn_rgm_setup_pkg.Gen_Invoice_number with ln_order_type_id' || ln_order_type_id || 'date ' || mainrec.delivery_date );

424: THEN
425: IF lv_inv_num_already_generated = jai_constants.value_false
426: THEN
427: IF lv_Debug = 'Y' THEN
428: Fnd_File.PUT_LINE(Fnd_File.LOG, ' before call to jai_cmn_rgm_setup_pkg.Gen_Invoice_number with ln_order_type_id' || ln_order_type_id || 'date ' || mainrec.delivery_date );
429: END IF; -- lv_Debug = 'Y'
430: jai_cmn_rgm_setup_pkg.Gen_Invoice_number(p_regime_id => ln_cgst_regime_id
431: , p_organization_id => mainrec.organization_id
432: , p_location_id => mainrec.location_id

Line 441: Fnd_File.PUT_LINE(Fnd_File.LOG, ' after call with lv_invoice_number:' || lv_invoice_number ||','|| lv_inv_gen_process_flag ||','||lv_inv_gen_process_message);

437: , p_process_flag => lv_inv_gen_process_flag
438: , p_process_msg => lv_inv_gen_process_message
439: );
440: IF lv_Debug = 'Y' THEN
441: Fnd_File.PUT_LINE(Fnd_File.LOG, ' after call with lv_invoice_number:' || lv_invoice_number ||','|| lv_inv_gen_process_flag ||','||lv_inv_gen_process_message);
442: END IF; -- lv_Debug = 'Y'
443:
444: -- check the return status and update the JAI_OM_WSH_LINES_ALL table to set the vat invoice number
445: IF lv_inv_gen_process_flag = jai_constants.successful

Line 546: Fnd_File.PUT_LINE(Fnd_File.LOG, 'No. of Deliveries updated in jai_vat_processing_t: ' || SQL%ROWCOUNT);

542:
543: ln_success_delivery_Ctr := NVL(ln_success_Delivery_Ctr,0) + sql%rowcount ;
544:
545: IF lv_Debug = 'Y' THEN
546: Fnd_File.PUT_LINE(Fnd_File.LOG, 'No. of Deliveries updated in jai_vat_processing_t: ' || SQL%ROWCOUNT);
547: END IF; -- lv_Debug = 'Y'
548: END IF; -- lv_invoice_number IS NOT NULL
549: END IF; -- lv_party_has_changed
550: ELSE -- single invoice number is false

Line 558: Fnd_File.PUT_LINE(Fnd_File.LOG, 'In the Else when p_single_invoice is not Y ');

554: table JAI_RGM_GST_INVOICE_GEN_T (vat_invoice_no => lv_vat_invoice_number,
555: vat_inv_gen_status => 'C');
556: */
557: IF lv_Debug = 'Y' THEN
558: Fnd_File.PUT_LINE(Fnd_File.LOG, 'In the Else when p_single_invoice is not Y ');
559: END IF;
560: /*
561: || This is the Else Part of the IF p_single_invoice_num = 'Y' THEN
562: || In this comes the code that is needed for different generating GST invoice number for every delivery

Line 565: Fnd_File.PUT_LINE(Fnd_File.LOG, '+++ before call to jai_cmn_rgm_setup_pkg.Gen_Invoice_number In the Else when p_single_invoice is not Y with order type = '

561: || This is the Else Part of the IF p_single_invoice_num = 'Y' THEN
562: || In this comes the code that is needed for different generating GST invoice number for every delivery
563: */
564: IF lv_Debug = 'Y' THEN
565: Fnd_File.PUT_LINE(Fnd_File.LOG, '+++ before call to jai_cmn_rgm_setup_pkg.Gen_Invoice_number In the Else when p_single_invoice is not Y with order type = '
566: || ln_order_type_id || ' +++ ' );
567:
568:
569: END IF; -- lv_Debug = 'Y'

Line 581: Fnd_File.PUT_LINE(Fnd_File.LOG, ' +++ after call to jai_cmn_rgm_setup_pkg.Gen_Invoice_number In the Else when p_single_invoice is not Y with lv_invoice_number = '

577: , p_process_flag => lv_inv_gen_process_flag
578: , p_process_msg => lv_inv_gen_process_message
579: );
580: IF lv_Debug = 'Y' THEN
581: Fnd_File.PUT_LINE(Fnd_File.LOG, ' +++ after call to jai_cmn_rgm_setup_pkg.Gen_Invoice_number In the Else when p_single_invoice is not Y with lv_invoice_number = '
582: || lv_invoice_number || '+++');
583: Fnd_File.PUT_LINE(Fnd_File.LOG, ' +++ after call to jai_cmn_rgm_setup_pkg.Gen_Invoice_number with lv_inv_gen_process_flag = '
584: || lv_inv_gen_process_flag || 'lv_inv_gen_process_message '|| lv_inv_gen_process_message || '+++');
585: END IF; -- lv_Debug = 'Y'

Line 583: Fnd_File.PUT_LINE(Fnd_File.LOG, ' +++ after call to jai_cmn_rgm_setup_pkg.Gen_Invoice_number with lv_inv_gen_process_flag = '

579: );
580: IF lv_Debug = 'Y' THEN
581: Fnd_File.PUT_LINE(Fnd_File.LOG, ' +++ after call to jai_cmn_rgm_setup_pkg.Gen_Invoice_number In the Else when p_single_invoice is not Y with lv_invoice_number = '
582: || lv_invoice_number || '+++');
583: Fnd_File.PUT_LINE(Fnd_File.LOG, ' +++ after call to jai_cmn_rgm_setup_pkg.Gen_Invoice_number with lv_inv_gen_process_flag = '
584: || lv_inv_gen_process_flag || 'lv_inv_gen_process_message '|| lv_inv_gen_process_message || '+++');
585: END IF; -- lv_Debug = 'Y'
586: IF lv_inv_gen_process_flag = jai_constants.successful
587: THEN

Line 591: fnd_file.put_line(fnd_file.log,'ln_regime_id:'||ln_regime_id);

587: THEN
588:
589: IF lv_invoice_number IS NOT NULL
590: THEN
591: fnd_file.put_line(fnd_file.log,'ln_regime_id:'||ln_regime_id);
592: fnd_file.put_line(fnd_file.log,'ln_cgst_regime_id:'||ln_cgst_regime_id);
593: fnd_file.put_line(fnd_file.log,'ln_cgst_regime_id:'||ln_sgst_regime_id);
594: fnd_file.put_line(fnd_file.log,'mainrec.delivery_id:'||mainrec.delivery_id);
595: fnd_file.put_line(fnd_file.log,'mainrec.lv_invoice_number:'||lv_invoice_number);

Line 592: fnd_file.put_line(fnd_file.log,'ln_cgst_regime_id:'||ln_cgst_regime_id);

588:
589: IF lv_invoice_number IS NOT NULL
590: THEN
591: fnd_file.put_line(fnd_file.log,'ln_regime_id:'||ln_regime_id);
592: fnd_file.put_line(fnd_file.log,'ln_cgst_regime_id:'||ln_cgst_regime_id);
593: fnd_file.put_line(fnd_file.log,'ln_cgst_regime_id:'||ln_sgst_regime_id);
594: fnd_file.put_line(fnd_file.log,'mainrec.delivery_id:'||mainrec.delivery_id);
595: fnd_file.put_line(fnd_file.log,'mainrec.lv_invoice_number:'||lv_invoice_number);
596: fnd_file.put_line(fnd_file.log,'ld_override_invoice_date:'||ld_override_invoice_date);

Line 593: fnd_file.put_line(fnd_file.log,'ln_cgst_regime_id:'||ln_sgst_regime_id);

589: IF lv_invoice_number IS NOT NULL
590: THEN
591: fnd_file.put_line(fnd_file.log,'ln_regime_id:'||ln_regime_id);
592: fnd_file.put_line(fnd_file.log,'ln_cgst_regime_id:'||ln_cgst_regime_id);
593: fnd_file.put_line(fnd_file.log,'ln_cgst_regime_id:'||ln_sgst_regime_id);
594: fnd_file.put_line(fnd_file.log,'mainrec.delivery_id:'||mainrec.delivery_id);
595: fnd_file.put_line(fnd_file.log,'mainrec.lv_invoice_number:'||lv_invoice_number);
596: fnd_file.put_line(fnd_file.log,'ld_override_invoice_date:'||ld_override_invoice_date);
597:

Line 594: fnd_file.put_line(fnd_file.log,'mainrec.delivery_id:'||mainrec.delivery_id);

590: THEN
591: fnd_file.put_line(fnd_file.log,'ln_regime_id:'||ln_regime_id);
592: fnd_file.put_line(fnd_file.log,'ln_cgst_regime_id:'||ln_cgst_regime_id);
593: fnd_file.put_line(fnd_file.log,'ln_cgst_regime_id:'||ln_sgst_regime_id);
594: fnd_file.put_line(fnd_file.log,'mainrec.delivery_id:'||mainrec.delivery_id);
595: fnd_file.put_line(fnd_file.log,'mainrec.lv_invoice_number:'||lv_invoice_number);
596: fnd_file.put_line(fnd_file.log,'ld_override_invoice_date:'||ld_override_invoice_date);
597:
598: ln_success_delivery_Ctr := NVL(ln_success_Delivery_Ctr,0) + 1;

Line 595: fnd_file.put_line(fnd_file.log,'mainrec.lv_invoice_number:'||lv_invoice_number);

591: fnd_file.put_line(fnd_file.log,'ln_regime_id:'||ln_regime_id);
592: fnd_file.put_line(fnd_file.log,'ln_cgst_regime_id:'||ln_cgst_regime_id);
593: fnd_file.put_line(fnd_file.log,'ln_cgst_regime_id:'||ln_sgst_regime_id);
594: fnd_file.put_line(fnd_file.log,'mainrec.delivery_id:'||mainrec.delivery_id);
595: fnd_file.put_line(fnd_file.log,'mainrec.lv_invoice_number:'||lv_invoice_number);
596: fnd_file.put_line(fnd_file.log,'ld_override_invoice_date:'||ld_override_invoice_date);
597:
598: ln_success_delivery_Ctr := NVL(ln_success_Delivery_Ctr,0) + 1;
599:

Line 596: fnd_file.put_line(fnd_file.log,'ld_override_invoice_date:'||ld_override_invoice_date);

592: fnd_file.put_line(fnd_file.log,'ln_cgst_regime_id:'||ln_cgst_regime_id);
593: fnd_file.put_line(fnd_file.log,'ln_cgst_regime_id:'||ln_sgst_regime_id);
594: fnd_file.put_line(fnd_file.log,'mainrec.delivery_id:'||mainrec.delivery_id);
595: fnd_file.put_line(fnd_file.log,'mainrec.lv_invoice_number:'||lv_invoice_number);
596: fnd_file.put_line(fnd_file.log,'ld_override_invoice_date:'||ld_override_invoice_date);
597:
598: ln_success_delivery_Ctr := NVL(ln_success_Delivery_Ctr,0) + 1;
599:
600: UPDATE JAI_OM_WSH_LINES_ALL

Line 653: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_party_has_changed :' || lv_party_has_changed);

649: ELSE
650: lv_order_has_changed := jai_constants.value_false;
651: END IF; -- ln_current_order_number <> mainrec.order_number
652:
653: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_party_has_changed :' || lv_party_has_changed);
654: Fnd_File.PUT_LINE(Fnd_File.LOG, ' p_single_invoice_num :' || p_single_invoice_num);
655:
656: IF NVL(p_single_invoice_num,jai_constants.No) = jai_constants.yes -- single invoice number is true
657: THEN

Line 654: Fnd_File.PUT_LINE(Fnd_File.LOG, ' p_single_invoice_num :' || p_single_invoice_num);

650: lv_order_has_changed := jai_constants.value_false;
651: END IF; -- ln_current_order_number <> mainrec.order_number
652:
653: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_party_has_changed :' || lv_party_has_changed);
654: Fnd_File.PUT_LINE(Fnd_File.LOG, ' p_single_invoice_num :' || p_single_invoice_num);
655:
656: IF NVL(p_single_invoice_num,jai_constants.No) = jai_constants.yes -- single invoice number is true
657: THEN
658: IF NVL(lv_party_has_changed,jai_constants.value_false) = jai_constants.value_true -- party has changed

Line 668: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_party_has_changed :' || lv_party_has_changed);

664: vat_inv_gen_status => 'C');
665: */
666: IF lv_Debug = 'Y'
667: THEN
668: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_party_has_changed :' || lv_party_has_changed);
669: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_inv_num_already_generated :' || lv_inv_num_already_generated);
670: END IF; -- lv_Debug = 'Y'
671: IF p_process_action in (jai_constants.om_action_gen_inv_n_accnt ,jai_constants.om_action_gen_invoice)
672: THEN

Line 669: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_inv_num_already_generated :' || lv_inv_num_already_generated);

665: */
666: IF lv_Debug = 'Y'
667: THEN
668: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_party_has_changed :' || lv_party_has_changed);
669: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_inv_num_already_generated :' || lv_inv_num_already_generated);
670: END IF; -- lv_Debug = 'Y'
671: IF p_process_action in (jai_constants.om_action_gen_inv_n_accnt ,jai_constants.om_action_gen_invoice)
672: THEN
673: --IF lv_inv_num_already_generated = jai_constants.value_false

Line 676: Fnd_File.PUT_LINE(Fnd_File.LOG, ' before call to jai_cmn_rgm_setup_pkg.Gen_Invoice_number with ln_order_type_id' || ln_order_type_id || 'date ' || mainrec.delivery_date );

672: THEN
673: --IF lv_inv_num_already_generated = jai_constants.value_false
674: --THEN
675: IF lv_Debug = 'Y' THEN
676: Fnd_File.PUT_LINE(Fnd_File.LOG, ' before call to jai_cmn_rgm_setup_pkg.Gen_Invoice_number with ln_order_type_id' || ln_order_type_id || 'date ' || mainrec.delivery_date );
677: END IF; -- lv_Debug = 'Y'
678: jai_cmn_rgm_setup_pkg.Gen_Invoice_number( p_regime_id => ln_cgst_regime_id
679: , p_organization_id => mainrec.organization_id
680: , p_location_id => mainrec.location_id

Line 689: Fnd_File.PUT_LINE(Fnd_File.LOG, ' after call with lv_invoice_number:' || lv_invoice_number || lv_inv_gen_process_flag ||lv_inv_gen_process_message);

685: , p_process_flag => lv_inv_gen_process_flag
686: , p_process_msg => lv_inv_gen_process_message
687: );
688: IF lv_Debug = 'Y' THEN
689: Fnd_File.PUT_LINE(Fnd_File.LOG, ' after call with lv_invoice_number:' || lv_invoice_number || lv_inv_gen_process_flag ||lv_inv_gen_process_message);
690: END IF; -- lv_Debug = 'Y'
691:
692: -- check the return status and update the JAI_OM_WSH_LINES_ALL table to set the vat invoice number
693: IF lv_inv_gen_process_flag = jai_constants.successful

Line 768: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_order_has_changed :' || lv_order_has_changed);

764: vat_inv_gen_status => 'C');
765: */
766: IF lv_Debug = 'Y'
767: THEN
768: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_order_has_changed :' || lv_order_has_changed);
769: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_inv_num_already_generated :' || lv_inv_num_already_generated);
770: END IF; -- lv_Debug = 'Y'
771: IF p_process_action in (jai_constants.om_action_gen_inv_n_accnt ,jai_constants.om_action_gen_invoice)
772: THEN

Line 769: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_inv_num_already_generated :' || lv_inv_num_already_generated);

765: */
766: IF lv_Debug = 'Y'
767: THEN
768: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_order_has_changed :' || lv_order_has_changed);
769: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_inv_num_already_generated :' || lv_inv_num_already_generated);
770: END IF; -- lv_Debug = 'Y'
771: IF p_process_action in (jai_constants.om_action_gen_inv_n_accnt ,jai_constants.om_action_gen_invoice)
772: THEN
773: --IF lv_inv_num_already_generated = jai_constants.value_false

Line 776: Fnd_File.PUT_LINE(Fnd_File.LOG, ' before call to jai_cmn_rgm_setup_pkg.Gen_Invoice_number with ln_order_type_id' || ln_order_type_id || 'date ' || mainrec.delivery_date );

772: THEN
773: --IF lv_inv_num_already_generated = jai_constants.value_false
774: --THEN
775: IF lv_Debug = 'Y' THEN
776: Fnd_File.PUT_LINE(Fnd_File.LOG, ' before call to jai_cmn_rgm_setup_pkg.Gen_Invoice_number with ln_order_type_id' || ln_order_type_id || 'date ' || mainrec.delivery_date );
777: END IF; -- lv_Debug = 'Y'
778: jai_cmn_rgm_setup_pkg.Gen_Invoice_number( p_regime_id => ln_cgst_regime_id
779: , p_organization_id => mainrec.organization_id
780: , p_location_id => mainrec.location_id

Line 789: Fnd_File.PUT_LINE(Fnd_File.LOG, ' after call with lv_invoice_number:' || lv_invoice_number || lv_inv_gen_process_flag ||lv_inv_gen_process_message);

785: , p_process_flag => lv_inv_gen_process_flag
786: , p_process_msg => lv_inv_gen_process_message
787: );
788: IF lv_Debug = 'Y' THEN
789: Fnd_File.PUT_LINE(Fnd_File.LOG, ' after call with lv_invoice_number:' || lv_invoice_number || lv_inv_gen_process_flag ||lv_inv_gen_process_message);
790: END IF; -- lv_Debug = 'Y'
791:
792: -- check the return status and update the JAI_OM_WSH_LINES_ALL table to set the vat invoice number
793: IF lv_inv_gen_process_flag = jai_constants.successful

Line 871: Fnd_File.PUT_LINE(Fnd_File.LOG, ' In process accounting section with p_process_action = ' || p_process_action);

867:
868: /* <>
869:
870: IF lv_debug = 'Y' THEN
871: Fnd_File.PUT_LINE(Fnd_File.LOG, ' In process accounting section with p_process_action = ' || p_process_action);
872: END IF;
873:
874: IF p_process_action in (jai_constants.om_action_gen_inv_n_accnt,jai_constants.om_action_gen_accounting) THEN
875: \*

Line 880: Fnd_File.PUT_LINE(Fnd_File.LOG, ' mainrec.vat_acct_status : ' || mainrec.vat_acct_status || ' lv_inv_gen_process_flag : ' || lv_inv_gen_process_flag );

876: || Only In case the parameter p_process_action in ('PROCESS ALL','PROCESS ACCOUNTING') AND
877: ||
878: *\
879: IF lv_Debug = 'Y' THEN
880: Fnd_File.PUT_LINE(Fnd_File.LOG, ' mainrec.vat_acct_status : ' || mainrec.vat_acct_status || ' lv_inv_gen_process_flag : ' || lv_inv_gen_process_flag );
881: END IF;
882: IF mainrec.vat_acct_status = 'C' THEN
883: GOTO NEXTDELIVERY;
884: END IF;

Line 886: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_inv_gen_process_flag = ' || lv_inv_gen_process_flag );

882: IF mainrec.vat_acct_status = 'C' THEN
883: GOTO NEXTDELIVERY;
884: END IF;
885: IF lv_Debug = 'Y' THEN
886: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_inv_gen_process_flag = ' || lv_inv_gen_process_flag );
887: END IF;
888: IF lv_inv_gen_process_flag = jai_constants.successful THEN
889:
890: IF lv_vat_invoice_number IS NULL THEN

Line 900: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Before Call to jai_cmn_rgm_vat_accnt_pkg.process_order_invoice ');

896: lv_vat_invoice_number := mainrec.vat_invoice_no;
897: END IF;
898:
899: IF lv_Debug = 'Y' THEN
900: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Before Call to jai_cmn_rgm_vat_accnt_pkg.process_order_invoice ');
901: END IF;
902: jai_cmn_rgm_vat_accnt_pkg.process_order_invoice(
903: P_REGIME_ID => ln_regime_id ,
904: -- modified by Allen Yang for bug 9485355 (12.1.3 non-shippable Enhancement), begin

Line 925: Fnd_File.PUT_LINE(Fnd_File.LOG, 'after Call to jai_cmn_rgm_vat_accnt_pkg.process_order_invoice with status = ' || lv_acct_process_flag);

921: P_PROCESS_FLAG => lv_acct_process_flag ,
922: P_PROCESS_MESSAGE => lv_acct_process_message
923: );
924: IF lv_Debug = 'Y' THEN
925: Fnd_File.PUT_LINE(Fnd_File.LOG, 'after Call to jai_cmn_rgm_vat_accnt_pkg.process_order_invoice with status = ' || lv_acct_process_flag);
926: END IF;
927: IF lv_acct_process_flag = jai_constants.successful THEN
928: \*
929: || If the control comes here it means that Accounting got processed successfully.

Line 955: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Error Encountered after call to process_order_invoice is ' || lv_acct_process_message);

951: COMMIT;
952: END IF;
953: ELSE
954: ln_failure_delivery_ctr := NVL(ln_failure_Delivery_ctr,0) + 1;
955: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Error Encountered after call to process_order_invoice is ' || lv_acct_process_message);
956: END IF;
957:
958: IF lv_inv_gen_process_flag <> jai_constants.successful OR lv_acct_process_flag <> jai_constants.successful THEN
959:

Line 1018: Fnd_File.PUT_LINE(Fnd_File.LOG, ' +++ Number of Successful deliveries : ' || ln_success_delivery_Ctr || '+++');

1014: /*
1015: || Coding here to mark the status of the concurrent and generating statictics.
1016: ||
1017: */
1018: Fnd_File.PUT_LINE(Fnd_File.LOG, ' +++ Number of Successful deliveries : ' || ln_success_delivery_Ctr || '+++');
1019: Fnd_File.PUT_LINE(Fnd_File.LOG, ' +++ Number of Failed deliveries : ' || ln_failure_delivery_ctr || '+++');
1020:
1021: IF ln_failure_delivery_ctr > 0 AND ln_success_delivery_Ctr > 0 then
1022: /*

Line 1019: Fnd_File.PUT_LINE(Fnd_File.LOG, ' +++ Number of Failed deliveries : ' || ln_failure_delivery_ctr || '+++');

1015: || Coding here to mark the status of the concurrent and generating statictics.
1016: ||
1017: */
1018: Fnd_File.PUT_LINE(Fnd_File.LOG, ' +++ Number of Successful deliveries : ' || ln_success_delivery_Ctr || '+++');
1019: Fnd_File.PUT_LINE(Fnd_File.LOG, ' +++ Number of Failed deliveries : ' || ln_failure_delivery_ctr || '+++');
1020:
1021: IF ln_failure_delivery_ctr > 0 AND ln_success_delivery_Ctr > 0 then
1022: /*
1023: || Atleast one delivery failed Atleast one delivery Succeeded

Line 1058: Fnd_File.PUT_LINE(Fnd_File.LOG,'Unexpected Error occured in procedure jai_cmn_rgm_processing_pkg.process '||substr(sqlerrm,1,300));

1054:
1055: EXCEPTION
1056: WHEN OTHERS THEN
1057: RETCODE := '2';
1058: Fnd_File.PUT_LINE(Fnd_File.LOG,'Unexpected Error occured in procedure jai_cmn_rgm_processing_pkg.process '||substr(sqlerrm,1,300));
1059: lb_completion_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',substr(sqlerrm,1,1000));
1060: ERRBUF := substr(sqlerrm,1,1000);
1061: lv_inv_gen_process_flag := jai_constants.unexpected_error;
1062: lv_acct_process_flag := jai_constants.unexpected_error;