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

Line 464: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );

460: BEGIN
461: GML_SYNCH_BPOS.next_bpo_id(v_new_bpo_id, int_rec.orgn_code,
462: v_next_id_status);
463: IF v_next_id_status=FALSE THEN
464: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
465: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error getting next bpo_id');
466: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
467: err_num := SQLCODE;
468: err_msg := SUBSTRB (SQLERRM, 1, 100);

Line 465: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error getting next bpo_id');

461: GML_SYNCH_BPOS.next_bpo_id(v_new_bpo_id, int_rec.orgn_code,
462: v_next_id_status);
463: IF v_next_id_status=FALSE THEN
464: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
465: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error getting next bpo_id');
466: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
467: err_num := SQLCODE;
468: err_msg := SUBSTRB (SQLERRM, 1, 100);
469: FND_FILE.PUT_LINE(FND_FILE.LOG, err_msg);

Line 466: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );

462: v_next_id_status);
463: IF v_next_id_status=FALSE THEN
464: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
465: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error getting next bpo_id');
466: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
467: err_num := SQLCODE;
468: err_msg := SUBSTRB (SQLERRM, 1, 100);
469: FND_FILE.PUT_LINE(FND_FILE.LOG, err_msg);
470: retcode :=1;

Line 469: FND_FILE.PUT_LINE(FND_FILE.LOG, err_msg);

465: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error getting next bpo_id');
466: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
467: err_num := SQLCODE;
468: err_msg := SUBSTRB (SQLERRM, 1, 100);
469: FND_FILE.PUT_LINE(FND_FILE.LOG, err_msg);
470: retcode :=1;
471: raise_application_error(-20001, err_msg);
472: END IF;
473:

Line 570: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );

566: int_rec.orgnaddr_id /* KYH 24/AUG/98 integ const change*/
567: );
568: EXCEPTION
569: WHEN OTHERS THEN
570: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
571: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error inserting into po_bpos_hdr');
572: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
573: err_num := SQLCODE;
574: err_msg := SUBSTRB (SQLERRM, 1, 100);

Line 571: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error inserting into po_bpos_hdr');

567: );
568: EXCEPTION
569: WHEN OTHERS THEN
570: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
571: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error inserting into po_bpos_hdr');
572: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
573: err_num := SQLCODE;
574: err_msg := SUBSTRB (SQLERRM, 1, 100);
575: FND_FILE.PUT_LINE(FND_FILE.LOG, err_msg);

Line 572: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );

568: EXCEPTION
569: WHEN OTHERS THEN
570: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
571: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error inserting into po_bpos_hdr');
572: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
573: err_num := SQLCODE;
574: err_msg := SUBSTRB (SQLERRM, 1, 100);
575: FND_FILE.PUT_LINE(FND_FILE.LOG, err_msg);
576: retcode :=1;

Line 575: FND_FILE.PUT_LINE(FND_FILE.LOG, err_msg);

571: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error inserting into po_bpos_hdr');
572: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
573: err_num := SQLCODE;
574: err_msg := SUBSTRB (SQLERRM, 1, 100);
575: FND_FILE.PUT_LINE(FND_FILE.LOG, err_msg);
576: retcode :=1;
577: raise_application_error(-20001, err_msg);
578: END;
579: END;

Line 613: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );

609: int_rec.po_line_location_id) THEN
610:
611: GML_PO_SYNCH.next_line_id('BPO', v_new_line_id, v_next_id_status);
612: IF v_next_id_status=FALSE THEN
613: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
614: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error getting next line_id');
615: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
616: err_num := SQLCODE;
617: err_msg := SUBSTRB (SQLERRM, 1, 100);

Line 614: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error getting next line_id');

610:
611: GML_PO_SYNCH.next_line_id('BPO', v_new_line_id, v_next_id_status);
612: IF v_next_id_status=FALSE THEN
613: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
614: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error getting next line_id');
615: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
616: err_num := SQLCODE;
617: err_msg := SUBSTRB (SQLERRM, 1, 100);
618: FND_FILE.PUT_LINE(FND_FILE.LOG, err_msg);

Line 615: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );

611: GML_PO_SYNCH.next_line_id('BPO', v_new_line_id, v_next_id_status);
612: IF v_next_id_status=FALSE THEN
613: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
614: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error getting next line_id');
615: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
616: err_num := SQLCODE;
617: err_msg := SUBSTRB (SQLERRM, 1, 100);
618: FND_FILE.PUT_LINE(FND_FILE.LOG, err_msg);
619: retcode :=1;

Line 618: FND_FILE.PUT_LINE(FND_FILE.LOG, err_msg);

614: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error getting next line_id');
615: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
616: err_num := SQLCODE;
617: err_msg := SUBSTRB (SQLERRM, 1, 100);
618: FND_FILE.PUT_LINE(FND_FILE.LOG, err_msg);
619: retcode :=1;
620: raise_application_error(-20001, err_msg);
621: retcode :=1;
622: raise_application_error(-20001, err_msg);

Line 733: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );

729: nvl(int_rec.match_type,3)
730: );
731: EXCEPTION
732: WHEN OTHERS THEN
733: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
734: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error inserting into po_bpos_dtl');
735: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
736: err_num := SQLCODE;
737: err_msg := SUBSTRB (SQLERRM, 1, 100);

Line 734: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error inserting into po_bpos_dtl');

730: );
731: EXCEPTION
732: WHEN OTHERS THEN
733: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
734: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error inserting into po_bpos_dtl');
735: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
736: err_num := SQLCODE;
737: err_msg := SUBSTRB (SQLERRM, 1, 100);
738: FND_FILE.PUT_LINE(FND_FILE.LOG, err_msg);

Line 735: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );

731: EXCEPTION
732: WHEN OTHERS THEN
733: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
734: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error inserting into po_bpos_dtl');
735: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
736: err_num := SQLCODE;
737: err_msg := SUBSTRB (SQLERRM, 1, 100);
738: FND_FILE.PUT_LINE(FND_FILE.LOG, err_msg);
739: retcode :=1;

Line 738: FND_FILE.PUT_LINE(FND_FILE.LOG, err_msg);

734: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error inserting into po_bpos_dtl');
735: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
736: err_num := SQLCODE;
737: err_msg := SUBSTRB (SQLERRM, 1, 100);
738: FND_FILE.PUT_LINE(FND_FILE.LOG, err_msg);
739: retcode :=1;
740: raise_application_error(-20001, err_msg);
741: END;
742:

Line 801: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );

797: nvl(int_rec.delete_mark,0)
798: );
799: EXCEPTION
800: WHEN OTHERS THEN
801: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
802: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error inserting into po_rels_sch');
803: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
804: err_num := SQLCODE;
805: err_msg := SUBSTRB (SQLERRM, 1, 100);

Line 802: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error inserting into po_rels_sch');

798: );
799: EXCEPTION
800: WHEN OTHERS THEN
801: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
802: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error inserting into po_rels_sch');
803: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
804: err_num := SQLCODE;
805: err_msg := SUBSTRB (SQLERRM, 1, 100);
806: FND_FILE.PUT_LINE(FND_FILE.LOG, err_msg);

Line 803: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );

799: EXCEPTION
800: WHEN OTHERS THEN
801: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
802: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error inserting into po_rels_sch');
803: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
804: err_num := SQLCODE;
805: err_msg := SUBSTRB (SQLERRM, 1, 100);
806: FND_FILE.PUT_LINE(FND_FILE.LOG, err_msg);
807: retcode :=1;

Line 806: FND_FILE.PUT_LINE(FND_FILE.LOG, err_msg);

802: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error inserting into po_rels_sch');
803: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
804: err_num := SQLCODE;
805: err_msg := SUBSTRB (SQLERRM, 1, 100);
806: FND_FILE.PUT_LINE(FND_FILE.LOG, err_msg);
807: retcode :=1;
808: raise_application_error(-20001, err_msg);
809: END;
810:

Line 871: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );

867: orgnaddr_id = int_rec.orgnaddr_id /*KYH nullable*/
868: WHERE bpo_id = v_bpo_id;
869: EXCEPTION
870: WHEN OTHERS THEN
871: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
872: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error updating po_bpos_hdr');
873: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
874: err_num := SQLCODE;
875: err_msg := SUBSTRB (SQLERRM, 1, 100);

Line 872: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error updating po_bpos_hdr');

868: WHERE bpo_id = v_bpo_id;
869: EXCEPTION
870: WHEN OTHERS THEN
871: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
872: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error updating po_bpos_hdr');
873: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
874: err_num := SQLCODE;
875: err_msg := SUBSTRB (SQLERRM, 1, 100);
876: FND_FILE.PUT_LINE(FND_FILE.LOG, err_msg);

Line 873: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );

869: EXCEPTION
870: WHEN OTHERS THEN
871: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
872: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error updating po_bpos_hdr');
873: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
874: err_num := SQLCODE;
875: err_msg := SUBSTRB (SQLERRM, 1, 100);
876: FND_FILE.PUT_LINE(FND_FILE.LOG, err_msg);
877: retcode :=1;

Line 876: FND_FILE.PUT_LINE(FND_FILE.LOG, err_msg);

872: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error updating po_bpos_hdr');
873: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
874: err_num := SQLCODE;
875: err_msg := SUBSTRB (SQLERRM, 1, 100);
876: FND_FILE.PUT_LINE(FND_FILE.LOG, err_msg);
877: retcode :=1;
878: raise_application_error(-20001, err_msg);
879: END;
880:

Line 925: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );

921: WHERE bpo_id = v_bpo_id
922: AND line_id = v_bpo_line_id;
923: EXCEPTION
924: WHEN OTHERS THEN
925: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
926: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error updating po_bpos_dtl');
927: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
928: err_num := SQLCODE;
929: err_msg := SUBSTRB (SQLERRM, 1, 100);

Line 926: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error updating po_bpos_dtl');

922: AND line_id = v_bpo_line_id;
923: EXCEPTION
924: WHEN OTHERS THEN
925: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
926: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error updating po_bpos_dtl');
927: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
928: err_num := SQLCODE;
929: err_msg := SUBSTRB (SQLERRM, 1, 100);
930: FND_FILE.PUT_LINE(FND_FILE.LOG, err_msg);

Line 927: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );

923: EXCEPTION
924: WHEN OTHERS THEN
925: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
926: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error updating po_bpos_dtl');
927: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
928: err_num := SQLCODE;
929: err_msg := SUBSTRB (SQLERRM, 1, 100);
930: FND_FILE.PUT_LINE(FND_FILE.LOG, err_msg);
931: retcode :=1;

Line 930: FND_FILE.PUT_LINE(FND_FILE.LOG, err_msg);

926: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error updating po_bpos_dtl');
927: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
928: err_num := SQLCODE;
929: err_msg := SUBSTRB (SQLERRM, 1, 100);
930: FND_FILE.PUT_LINE(FND_FILE.LOG, err_msg);
931: retcode :=1;
932: raise_application_error(-20001, err_msg);
933: END;
934:

Line 960: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );

956: trans_cnt = nvl(int_rec.trans_cnt,1) + 1
957: WHERE bpoline_id = v_bpo_line_id;
958: EXCEPTION
959: WHEN OTHERS THEN
960: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
961: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error updating po_rels_sch');
962: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
963: err_num := SQLCODE;
964: err_msg := SUBSTRB (SQLERRM, 1, 100);

Line 961: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error updating po_rels_sch');

957: WHERE bpoline_id = v_bpo_line_id;
958: EXCEPTION
959: WHEN OTHERS THEN
960: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
961: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error updating po_rels_sch');
962: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
963: err_num := SQLCODE;
964: err_msg := SUBSTRB (SQLERRM, 1, 100);
965: FND_FILE.PUT_LINE(FND_FILE.LOG, err_msg);

Line 962: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );

958: EXCEPTION
959: WHEN OTHERS THEN
960: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
961: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error updating po_rels_sch');
962: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
963: err_num := SQLCODE;
964: err_msg := SUBSTRB (SQLERRM, 1, 100);
965: FND_FILE.PUT_LINE(FND_FILE.LOG, err_msg);
966: retcode :=1;

Line 965: FND_FILE.PUT_LINE(FND_FILE.LOG, err_msg);

961: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error updating po_rels_sch');
962: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
963: err_num := SQLCODE;
964: err_msg := SUBSTRB (SQLERRM, 1, 100);
965: FND_FILE.PUT_LINE(FND_FILE.LOG, err_msg);
966: retcode :=1;
967: raise_application_error(-20001, err_msg);
968: END;
969:

Line 1006: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

1002:
1003: EXCEPTION
1004: WHEN OTHERS THEN
1005: err_msg := SUBSTRB(SQLERRM, 1, 100);
1006: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
1007: FND_FILE.PUT_LINE(FND_FILE.LOG, err_msg);
1008: retcode := 1;
1009: RAISE_APPLICATION_ERROR(-20000, err_msg);
1010:

Line 1007: FND_FILE.PUT_LINE(FND_FILE.LOG, err_msg);

1003: EXCEPTION
1004: WHEN OTHERS THEN
1005: err_msg := SUBSTRB(SQLERRM, 1, 100);
1006: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
1007: FND_FILE.PUT_LINE(FND_FILE.LOG, err_msg);
1008: retcode := 1;
1009: RAISE_APPLICATION_ERROR(-20000, err_msg);
1010:
1011: END cpg_bint2gms ;