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.OE_ORDER_IMPORT_MAIN_PVT dependencies on FND_API

Line 96: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;

92: ,p_default_org_id IN NUMBER
93: ,p_validate_desc_flex in varchar2 default 'Y' --bug4343612
94: )
95: IS
96: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
97: l_validate_only VARCHAR2(1) := p_validate_only;
98: l_order_source VARCHAR2(240) := p_order_source;
99: l_order_source_id NUMBER;
100: l_orig_sys_document_ref VARCHAR2(50) := p_orig_sys_document_ref;

Line 435: nvl(l_sold_to_org_id, FND_API.G_MISS_NUM) = nvl(sold_to_org_id, FND_API.G_MISS_NUM)))

431: (nvl(l_operation_code,' ') <> ' ' AND
432: nvl(l_operation_code,' ') = nvl(operation_code,' ')))
433: AND ( l_sold_to_org_id IS NULL OR
434: (l_sold_to_org_id IS NOT NULL AND
435: nvl(l_sold_to_org_id, FND_API.G_MISS_NUM) = nvl(sold_to_org_id, FND_API.G_MISS_NUM)))
436: AND
437: ( l_sold_to_org IS NULL OR
438: (l_sold_to_org IS NOT NULL AND
439: nvl(l_sold_to_org, FND_API.G_MISS_CHAR) = nvl(sold_to_org, FND_API.G_MISS_CHAR)))

Line 439: nvl(l_sold_to_org, FND_API.G_MISS_CHAR) = nvl(sold_to_org, FND_API.G_MISS_CHAR)))

435: nvl(l_sold_to_org_id, FND_API.G_MISS_NUM) = nvl(sold_to_org_id, FND_API.G_MISS_NUM)))
436: AND
437: ( l_sold_to_org IS NULL OR
438: (l_sold_to_org IS NOT NULL AND
439: nvl(l_sold_to_org, FND_API.G_MISS_CHAR) = nvl(sold_to_org, FND_API.G_MISS_CHAR)))
440: AND ( l_change_sequence IS NULL OR
441: (l_change_sequence IS NOT NULL AND
442: nvl(l_change_sequence, FND_API.G_MISS_CHAR) = nvl(change_sequence, FND_API.G_MISS_CHAR)))
443: AND request_id IS NULL

Line 442: nvl(l_change_sequence, FND_API.G_MISS_CHAR) = nvl(change_sequence, FND_API.G_MISS_CHAR)))

438: (l_sold_to_org IS NOT NULL AND
439: nvl(l_sold_to_org, FND_API.G_MISS_CHAR) = nvl(sold_to_org, FND_API.G_MISS_CHAR)))
440: AND ( l_change_sequence IS NULL OR
441: (l_change_sequence IS NOT NULL AND
442: nvl(l_change_sequence, FND_API.G_MISS_CHAR) = nvl(change_sequence, FND_API.G_MISS_CHAR)))
443: AND request_id IS NULL
444: AND nvl(error_flag,'N') = 'N';
445:
446: --MOAC

Line 468: nvl(l_sold_to_org_id, FND_API.G_MISS_NUM) = nvl(sold_to_org_id, FND_API.G_MISS_NUM)))

464: (nvl(l_operation_code,' ') <> ' ' AND
465: nvl(l_operation_code,' ') = nvl(operation_code,' ')))
466: AND ( l_sold_to_org_id IS NULL OR
467: (l_sold_to_org_id IS NOT NULL AND
468: nvl(l_sold_to_org_id, FND_API.G_MISS_NUM) = nvl(sold_to_org_id, FND_API.G_MISS_NUM)))
469: AND
470: ( l_sold_to_org IS NULL OR
471: (l_sold_to_org IS NOT NULL AND
472: nvl(l_sold_to_org, FND_API.G_MISS_CHAR) = nvl(sold_to_org, FND_API.G_MISS_CHAR)))

Line 472: nvl(l_sold_to_org, FND_API.G_MISS_CHAR) = nvl(sold_to_org, FND_API.G_MISS_CHAR)))

468: nvl(l_sold_to_org_id, FND_API.G_MISS_NUM) = nvl(sold_to_org_id, FND_API.G_MISS_NUM)))
469: AND
470: ( l_sold_to_org IS NULL OR
471: (l_sold_to_org IS NOT NULL AND
472: nvl(l_sold_to_org, FND_API.G_MISS_CHAR) = nvl(sold_to_org, FND_API.G_MISS_CHAR)))
473: AND ( l_change_sequence IS NULL OR
474: (l_change_sequence IS NOT NULL AND
475: nvl(l_change_sequence, FND_API.G_MISS_CHAR) = nvl(change_sequence, FND_API.G_MISS_CHAR)))
476: AND request_id IS NULL

Line 475: nvl(l_change_sequence, FND_API.G_MISS_CHAR) = nvl(change_sequence, FND_API.G_MISS_CHAR)))

471: (l_sold_to_org IS NOT NULL AND
472: nvl(l_sold_to_org, FND_API.G_MISS_CHAR) = nvl(sold_to_org, FND_API.G_MISS_CHAR)))
473: AND ( l_change_sequence IS NULL OR
474: (l_change_sequence IS NOT NULL AND
475: nvl(l_change_sequence, FND_API.G_MISS_CHAR) = nvl(change_sequence, FND_API.G_MISS_CHAR)))
476: AND request_id IS NULL
477: AND nvl(error_flag,'N') = 'N'
478: AND org_id IS NULL;
479:

Line 623: WHERE (order_source_id, orig_sys_document_ref, nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR),nvl(org_id,nvl(p_default_org_id,FND_API.G_MISS_NUM))) IN

619: -- start of customer inclusive request_id updates
620:
621: UPDATE oe_lines_iface_all
622: SET request_id = l_request_id
623: WHERE (order_source_id, orig_sys_document_ref, nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR),nvl(org_id,nvl(p_default_org_id,FND_API.G_MISS_NUM))) IN
624: ( SELECT order_source_id, orig_sys_document_ref,
625: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR), nvl(org_id,FND_API.G_MISS_NUM)
626: FROM oe_headers_iface_all
627: WHERE request_id = l_request_id);

Line 625: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR), nvl(org_id,FND_API.G_MISS_NUM)

621: UPDATE oe_lines_iface_all
622: SET request_id = l_request_id
623: WHERE (order_source_id, orig_sys_document_ref, nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR),nvl(org_id,nvl(p_default_org_id,FND_API.G_MISS_NUM))) IN
624: ( SELECT order_source_id, orig_sys_document_ref,
625: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR), nvl(org_id,FND_API.G_MISS_NUM)
626: FROM oe_headers_iface_all
627: WHERE request_id = l_request_id);
628: /*AND decode(p_perf_param, 'Y',
629: nvl(error_flag,'N'), ' ')

Line 642: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR),nvl(org_id,nvl(p_default_org_id,FND_API.G_MISS_NUM))) IN

638:
639: UPDATE oe_price_adjs_iface_all
640: SET request_id = l_request_id
641: WHERE (order_source_id, orig_sys_document_ref,
642: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR),nvl(org_id,nvl(p_default_org_id,FND_API.G_MISS_NUM))) IN
643: ( SELECT order_source_id, orig_sys_document_ref,
644: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR), nvl(org_id,FND_API.G_MISS_NUM)
645: FROM oe_headers_iface_all
646: WHERE request_id = l_request_id) ;

Line 644: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR), nvl(org_id,FND_API.G_MISS_NUM)

640: SET request_id = l_request_id
641: WHERE (order_source_id, orig_sys_document_ref,
642: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR),nvl(org_id,nvl(p_default_org_id,FND_API.G_MISS_NUM))) IN
643: ( SELECT order_source_id, orig_sys_document_ref,
644: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR), nvl(org_id,FND_API.G_MISS_NUM)
645: FROM oe_headers_iface_all
646: WHERE request_id = l_request_id) ;
647: /*AND decode(p_perf_param, 'Y',
648: nvl(error_flag,'N'), ' ')

Line 658: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR),nvl(org_id,nvl(p_default_org_id,FND_API.G_MISS_NUM))) IN

654:
655: UPDATE oe_payments_iface_all
656: SET request_id = l_request_id
657: WHERE (order_source_id, orig_sys_document_ref,
658: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR),nvl(org_id,nvl(p_default_org_id,FND_API.G_MISS_NUM))) IN
659: ( SELECT order_source_id, orig_sys_document_ref,
660: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR), nvl(org_id,FND_API.G_MISS_NUM)
661: FROM oe_headers_iface_all
662: WHERE request_id = l_request_id) ;

Line 660: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR), nvl(org_id,FND_API.G_MISS_NUM)

656: SET request_id = l_request_id
657: WHERE (order_source_id, orig_sys_document_ref,
658: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR),nvl(org_id,nvl(p_default_org_id,FND_API.G_MISS_NUM))) IN
659: ( SELECT order_source_id, orig_sys_document_ref,
660: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR), nvl(org_id,FND_API.G_MISS_NUM)
661: FROM oe_headers_iface_all
662: WHERE request_id = l_request_id) ;
663: /* AND decode(p_perf_param, 'Y',
664: nvl(error_flag,'N'), ' ')

Line 679: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR),nvl(org_id,nvl(p_default_org_id,FND_API.G_MISS_NUM))) IN

675: /* Added for #1433292 */
676: UPDATE oe_price_atts_iface_all
677: SET request_id = l_request_id
678: WHERE (order_source_id, orig_sys_document_ref,
679: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR),nvl(org_id,nvl(p_default_org_id,FND_API.G_MISS_NUM))) IN
680: ( SELECT order_source_id, orig_sys_document_ref,
681: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR), nvl(org_id,FND_API.G_MISS_NUM)
682: FROM oe_headers_iface_all
683: WHERE request_id = l_request_id) ;

Line 681: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR), nvl(org_id,FND_API.G_MISS_NUM)

677: SET request_id = l_request_id
678: WHERE (order_source_id, orig_sys_document_ref,
679: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR),nvl(org_id,nvl(p_default_org_id,FND_API.G_MISS_NUM))) IN
680: ( SELECT order_source_id, orig_sys_document_ref,
681: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR), nvl(org_id,FND_API.G_MISS_NUM)
682: FROM oe_headers_iface_all
683: WHERE request_id = l_request_id) ;
684: /* AND decode(p_perf_param, 'Y',
685: nvl(error_flag,'N'), ' ')

Line 695: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR),nvl(org_id,nvl(p_default_org_id,FND_API.G_MISS_NUM))) IN

691:
692: UPDATE oe_credits_iface_all
693: SET request_id = l_request_id
694: WHERE (order_source_id, orig_sys_document_ref,
695: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR),nvl(org_id,nvl(p_default_org_id,FND_API.G_MISS_NUM))) IN
696: ( SELECT order_source_id, orig_sys_document_ref,
697: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR), nvl(org_id,FND_API.G_MISS_NUM)
698: FROM oe_headers_iface_all
699: WHERE request_id = l_request_id) ;

Line 697: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR), nvl(org_id,FND_API.G_MISS_NUM)

693: SET request_id = l_request_id
694: WHERE (order_source_id, orig_sys_document_ref,
695: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR),nvl(org_id,nvl(p_default_org_id,FND_API.G_MISS_NUM))) IN
696: ( SELECT order_source_id, orig_sys_document_ref,
697: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR), nvl(org_id,FND_API.G_MISS_NUM)
698: FROM oe_headers_iface_all
699: WHERE request_id = l_request_id) ;
700: /*AND decode(p_perf_param, 'Y',
701: nvl(error_flag,'N'), ' ')

Line 710: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR),nvl(org_id,nvl(p_default_org_id,FND_API.G_MISS_NUM))) IN

706:
707: UPDATE oe_lotserials_iface_all
708: SET request_id = l_request_id
709: WHERE (order_source_id, orig_sys_document_ref,
710: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR),nvl(org_id,nvl(p_default_org_id,FND_API.G_MISS_NUM))) IN
711: ( SELECT order_source_id, orig_sys_document_ref,
712: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR), nvl(org_id,FND_API.G_MISS_NUM)
713: FROM oe_headers_iface_all
714: WHERE request_id = l_request_id) ;

Line 712: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR), nvl(org_id,FND_API.G_MISS_NUM)

708: SET request_id = l_request_id
709: WHERE (order_source_id, orig_sys_document_ref,
710: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR),nvl(org_id,nvl(p_default_org_id,FND_API.G_MISS_NUM))) IN
711: ( SELECT order_source_id, orig_sys_document_ref,
712: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR), nvl(org_id,FND_API.G_MISS_NUM)
713: FROM oe_headers_iface_all
714: WHERE request_id = l_request_id) ;
715: /*AND decode(p_perf_param, 'Y',
716: nvl(error_flag,'N'), ' ')

Line 725: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR),nvl(org_id,nvl(p_default_org_id,FND_API.G_MISS_NUM))) IN

721:
722: UPDATE oe_reservtns_iface_all
723: SET request_id = l_request_id
724: WHERE (order_source_id, orig_sys_document_ref,
725: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR),nvl(org_id,nvl(p_default_org_id,FND_API.G_MISS_NUM))) IN
726: ( SELECT order_source_id, orig_sys_document_ref,
727: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR), nvl(org_id,FND_API.G_MISS_NUM)
728: FROM oe_headers_iface_all
729: WHERE request_id = l_request_id) ;

Line 727: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR), nvl(org_id,FND_API.G_MISS_NUM)

723: SET request_id = l_request_id
724: WHERE (order_source_id, orig_sys_document_ref,
725: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR),nvl(org_id,nvl(p_default_org_id,FND_API.G_MISS_NUM))) IN
726: ( SELECT order_source_id, orig_sys_document_ref,
727: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR), nvl(org_id,FND_API.G_MISS_NUM)
728: FROM oe_headers_iface_all
729: WHERE request_id = l_request_id) ;
730: /* AND decode(p_perf_param, 'Y',
731: nvl(error_flag,'N'), ' ')

Line 740: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR),nvl(org_id,nvl(p_default_org_id,FND_API.G_MISS_NUM))) IN

736:
737: UPDATE oe_actions_iface_all
738: SET request_id = l_request_id
739: WHERE (order_source_id, orig_sys_document_ref,
740: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR),nvl(org_id,nvl(p_default_org_id,FND_API.G_MISS_NUM))) IN
741: ( SELECT order_source_id, orig_sys_document_ref,
742: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR), nvl(org_id,FND_API.G_MISS_NUM)
743: FROM oe_headers_iface_all
744: WHERE request_id = l_request_id) ;

Line 742: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR), nvl(org_id,FND_API.G_MISS_NUM)

738: SET request_id = l_request_id
739: WHERE (order_source_id, orig_sys_document_ref,
740: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR),nvl(org_id,nvl(p_default_org_id,FND_API.G_MISS_NUM))) IN
741: ( SELECT order_source_id, orig_sys_document_ref,
742: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR), nvl(org_id,FND_API.G_MISS_NUM)
743: FROM oe_headers_iface_all
744: WHERE request_id = l_request_id) ;
745: /* AND decode(p_perf_param, 'Y',
746: nvl(error_flag,'N'), ' ')

Line 807: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

803: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
804: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Order_Import_Conc_Pgm');
805: END IF;
806: fnd_file.put_line(FND_FILE.OUTPUT,'Unexpected error: ' || sqlerrm);
807: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
808:
809: end;
810:
811: end if;

Line 1034: IF l_return_status = FND_API.G_RET_STS_ERROR OR

1030: --
1031: END IF;
1032:
1033: --oe_debug_pub.add('after call Import_Order l_return_status ' || l_return_status);
1034: IF l_return_status = FND_API.G_RET_STS_ERROR OR
1035: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1036: THEN
1037: l_count_header_failure := l_count_header_failure + 1;
1038: ELSE

Line 1035: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

1031: END IF;
1032:
1033: --oe_debug_pub.add('after call Import_Order l_return_status ' || l_return_status);
1034: IF l_return_status = FND_API.G_RET_STS_ERROR OR
1035: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1036: THEN
1037: l_count_header_failure := l_count_header_failure + 1;
1038: ELSE
1039: l_count_header_success := l_count_header_success + 1;

Line 1102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1098: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1099: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Order_Import_Conc_Pgm');
1100: END IF;
1101: fnd_file.put_line(FND_FILE.OUTPUT,'Unexpected error: ' || sqlerrm);
1102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1103: end;
1104:
1105: END IF; -- p_perf_param was 'Y'
1106:

Line 1202: p_request_id IN NUMBER DEFAULT FND_API.G_MISS_NUM

1198: END ORDER_IMPORT_CONC_PGM;
1199:
1200:
1201: PROCEDURE ORDER_IMPORT_FORM(
1202: p_request_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
1203: ,p_order_source_id IN NUMBER
1204: ,p_orig_sys_document_ref IN VARCHAR2
1205: ,p_sold_to_org_id IN NUMBER
1206: ,p_sold_to_org IN VARCHAR2

Line 1207: ,p_change_sequence IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR

1203: ,p_order_source_id IN NUMBER
1204: ,p_orig_sys_document_ref IN VARCHAR2
1205: ,p_sold_to_org_id IN NUMBER
1206: ,p_sold_to_org IN VARCHAR2
1207: ,p_change_sequence IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
1208: ,p_org_id IN Number
1209: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_FALSE
1210: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE
1211: ,p_rtrim_data In Varchar2

Line 1209: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_FALSE

1205: ,p_sold_to_org_id IN NUMBER
1206: ,p_sold_to_org IN VARCHAR2
1207: ,p_change_sequence IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
1208: ,p_org_id IN Number
1209: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_FALSE
1210: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE
1211: ,p_rtrim_data In Varchar2
1212: ,p_msg_count OUT NOCOPY NUMBER
1213:

Line 1210: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE

1206: ,p_sold_to_org IN VARCHAR2
1207: ,p_change_sequence IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
1208: ,p_org_id IN Number
1209: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_FALSE
1210: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE
1211: ,p_rtrim_data In Varchar2
1212: ,p_msg_count OUT NOCOPY NUMBER
1213:
1214: ,p_msg_data OUT NOCOPY VARCHAR2