APPS.JAI_RCV_THIRD_PARTY_PKG dependencies on JAI_RCV_THIRD_PARTY_PKG

Line 1: PACKAGE BODY jai_rcv_third_party_pkg AS

1: PACKAGE BODY jai_rcv_third_party_pkg AS
2: /* $Header: jai_rcv_3p_prc.plb 120.13.12010000.2 2008/10/20 14:19:58 vumaasha ship $ */
3: /* --------------------------------------------------------------------------------------
4: Filename: jai_rcv_third_party_pkg_b.sql
5:

Line 4: Filename: jai_rcv_third_party_pkg_b.sql

1: PACKAGE BODY jai_rcv_third_party_pkg AS
2: /* $Header: jai_rcv_3p_prc.plb 120.13.12010000.2 2008/10/20 14:19:58 vumaasha ship $ */
3: /* --------------------------------------------------------------------------------------
4: Filename: jai_rcv_third_party_pkg_b.sql
5:
6: Change History:
7:
8: Date Bug Remarks

Line 211: SELECT 'jai_rcv_third_party_pkg.process_pending_receipts' INTO lv_temp FROM DUAL;

207: fnd_file.put_line(fnd_file.log, 'Operating unit ln_org_id is -> '||ln_org_id);
208:
209: /*End of bug 5490479 */
210: /* This is to identify the path in SQL TRACE file if any problem occured */
211: SELECT 'jai_rcv_third_party_pkg.process_pending_receipts' INTO lv_temp FROM DUAL;
212:
213: open c_get_tp_batch_id;
214: fetch c_get_tp_batch_id into ln_batch_id;
215: close c_get_tp_batch_id;

Line 218: Fnd_File.put_line(Fnd_File.LOG, '**** Debug Level 1 : Start of procedure jai_rcv_third_party_pkg.process_pending_receipts ****');

214: fetch c_get_tp_batch_id into ln_batch_id;
215: close c_get_tp_batch_id;
216:
217: if p_debug >= 1 then
218: Fnd_File.put_line(Fnd_File.LOG, '**** Debug Level 1 : Start of procedure jai_rcv_third_party_pkg.process_pending_receipts ****');
219: end if;
220:
221: /* Get all receipts where third party needs to be processed. Here only
222: RECEIVE or CORRECT to RECEIVE type of transactions are considered */

Line 372: Fnd_File.put_line(Fnd_File.LOG, '**** Debug Level 1 : End of procedure jai_rcv_third_party_pkg.process_pending_receipts ****');

368:
369: << exit_from_procedure >>
370:
371: if p_debug >= 1 then
372: Fnd_File.put_line(Fnd_File.LOG, '**** Debug Level 1 : End of procedure jai_rcv_third_party_pkg.process_pending_receipts ****');
373: end if;
374:
375: return;
376:

Line 380: errbuf := 'jai_rcv_third_party_pkg.process_pending_receipts:' || sqlerrm;

376:
377: exception
378: when others then
379: retcode := 2;
380: errbuf := 'jai_rcv_third_party_pkg.process_pending_receipts:' || sqlerrm;
381: FND_FILE.put_line(FND_FILE.log, 'Error in jai_rcv_third_party_pkg.process_pending_receipts :'||sqlerrm);
382: return;
383: end process_batch;
384: /****************************** End process_pending_receipts ****************************/

Line 381: FND_FILE.put_line(FND_FILE.log, 'Error in jai_rcv_third_party_pkg.process_pending_receipts :'||sqlerrm);

377: exception
378: when others then
379: retcode := 2;
380: errbuf := 'jai_rcv_third_party_pkg.process_pending_receipts:' || sqlerrm;
381: FND_FILE.put_line(FND_FILE.log, 'Error in jai_rcv_third_party_pkg.process_pending_receipts :'||sqlerrm);
382: return;
383: end process_batch;
384: /****************************** End process_pending_receipts ****************************/
385:

Line 709: select 'jai_rcv_third_party_pkg.process_receipt : shipment header - ' || to_char(p_shipment_header_id)

705: lb_tp_taxes_processed := 'FALSE';
706: ln_line_number := 0;
707:
708: -- This is to identify the path in SQL TRACE file if any problem occured
709: select 'jai_rcv_third_party_pkg.process_receipt : shipment header - ' || to_char(p_shipment_header_id)
710: into lv_temp from dual;
711:
712: if p_debug >= 1 then
713: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 1 : ' ||

Line 714: 'Start of procedure jai_rcv_third_party_pkg.process_receipt for shipment header :' ||

710: into lv_temp from dual;
711:
712: if p_debug >= 1 then
713: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 1 : ' ||
714: 'Start of procedure jai_rcv_third_party_pkg.process_receipt for shipment header :' ||
715: to_char(p_shipment_header_id)
716: );
717: end if;
718:

Line 1445: 'End of procedure jai_rcv_third_party_pkg.process_receipt for shipment header :' ||

1441: end if;
1442:
1443: if p_debug >= 1 then
1444: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 1 : ' ||
1445: 'End of procedure jai_rcv_third_party_pkg.process_receipt for shipment header :' ||
1446: to_char(p_shipment_header_id)
1447: );
1448: end if;
1449:

Line 1455: p_process_message := 'jai_rcv_third_party_pkg.process_receipt:' || sqlerrm;

1451:
1452: exception
1453: when others then
1454: p_process_flag := 'E';
1455: p_process_message := 'jai_rcv_third_party_pkg.process_receipt:' || sqlerrm;
1456: fnd_file.put_line( fnd_file.log, '******** Error in '||p_process_message);
1457: raise;
1458:
1459: end process_receipt;

Line 1500: end jai_rcv_third_party_pkg;

1496:
1497: /****************************** End populate_tp_invoice_id ****************************/
1498:
1499:
1500: end jai_rcv_third_party_pkg;