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.19.12020000.3 2013/01/30 09:37:03 anupgupt 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.19.12020000.3 2013/01/30 09:37:03 anupgupt ship $ */
3: /* --------------------------------------------------------------------------------------
4: Filename: jai_rcv_third_party_pkg_b.sql
5:
6: Change History:
7:
8: Date Bug Remarks

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

228: fnd_file.put_line(fnd_file.log, 'Operating unit ln_org_id is -> '||ln_org_id);
229:
230: /*End of bug 5490479 */
231: /* This is to identify the path in SQL TRACE file if any problem occured */
232: SELECT 'jai_rcv_third_party_pkg.process_pending_receipts' INTO lv_temp FROM DUAL;
233:
234: open c_get_tp_batch_id;
235: fetch c_get_tp_batch_id into ln_batch_id;
236: close c_get_tp_batch_id;

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

235: fetch c_get_tp_batch_id into ln_batch_id;
236: close c_get_tp_batch_id;
237:
238: if p_debug >= 1 then
239: Fnd_File.put_line(Fnd_File.LOG, '**** Debug Level 1 : Start of procedure jai_rcv_third_party_pkg.process_pending_receipts ****');
240: end if;
241:
242: /* Get all receipts where third party needs to be processed. Here only
243: RECEIVE or CORRECT to RECEIVE type of transactions are considered */

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

389:
390: << exit_from_procedure >>
391:
392: if p_debug >= 1 then
393: Fnd_File.put_line(Fnd_File.LOG, '**** Debug Level 1 : End of procedure jai_rcv_third_party_pkg.process_pending_receipts ****');
394: end if;
395:
396: return;
397:

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

397:
398: exception
399: when others then
400: retcode := 2;
401: errbuf := 'jai_rcv_third_party_pkg.process_pending_receipts:' || sqlerrm;
402: FND_FILE.put_line(FND_FILE.log, 'Error in jai_rcv_third_party_pkg.process_pending_receipts :'||sqlerrm);
403: return;
404: end process_batch;
405: /****************************** End process_pending_receipts ****************************/

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

398: exception
399: when others then
400: retcode := 2;
401: errbuf := 'jai_rcv_third_party_pkg.process_pending_receipts:' || sqlerrm;
402: FND_FILE.put_line(FND_FILE.log, 'Error in jai_rcv_third_party_pkg.process_pending_receipts :'||sqlerrm);
403: return;
404: end process_batch;
405: /****************************** End process_pending_receipts ****************************/
406:

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

747: lb_tp_taxes_processed := 'FALSE';
748: ln_line_number := 1; /* modified by vumaasha for bug 8965721 */
749:
750: -- This is to identify the path in SQL TRACE file if any problem occured
751: select 'jai_rcv_third_party_pkg.process_receipt : shipment header - ' || to_char(p_shipment_header_id)
752: into lv_temp from dual;
753:
754: if p_debug >= 1 then
755: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 1 : ' ||

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

752: into lv_temp from dual;
753:
754: if p_debug >= 1 then
755: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 1 : ' ||
756: 'Start of procedure jai_rcv_third_party_pkg.process_receipt for shipment header :' ||
757: to_char(p_shipment_header_id)
758: );
759: end if;
760:

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

1619: end if;
1620:
1621: if p_debug >= 1 then
1622: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 1 : ' ||
1623: 'End of procedure jai_rcv_third_party_pkg.process_receipt for shipment header :' ||
1624: to_char(p_shipment_header_id)
1625: );
1626: end if;
1627:

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

1629:
1630: exception
1631: when others then
1632: p_process_flag := 'E';
1633: p_process_message := 'jai_rcv_third_party_pkg.process_receipt:' || sqlerrm;
1634: fnd_file.put_line( fnd_file.log, '******** Error in '||p_process_message);
1635: raise;
1636:
1637: end process_receipt;

Line 1678: end jai_rcv_third_party_pkg;

1674:
1675: /****************************** End populate_tp_invoice_id ****************************/
1676:
1677:
1678: end jai_rcv_third_party_pkg;