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 436: nvl(l_sold_to_org_id, FND_API.G_MISS_NUM) = nvl(sold_to_org_id, FND_API.G_MISS_NUM)))

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

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

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

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

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

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

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

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

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

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

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

Line 624: 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

620: -- start of customer inclusive request_id updates
621:
622: UPDATE oe_lines_iface_all
623: SET request_id = l_request_id
624: 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
625: ( SELECT order_source_id, orig_sys_document_ref,
626: 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)
627: FROM oe_headers_iface_all
628: WHERE request_id = l_request_id);

Line 626: 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)

622: UPDATE oe_lines_iface_all
623: SET request_id = l_request_id
624: 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
625: ( SELECT order_source_id, orig_sys_document_ref,
626: 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)
627: FROM oe_headers_iface_all
628: WHERE request_id = l_request_id);
629: /*AND decode(p_perf_param, 'Y',
630: nvl(error_flag,'N'), ' ')

Line 643: 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

639:
640: UPDATE oe_price_adjs_iface_all
641: SET request_id = l_request_id
642: WHERE (order_source_id, orig_sys_document_ref,
643: 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
644: ( SELECT order_source_id, orig_sys_document_ref,
645: 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)
646: FROM oe_headers_iface_all
647: WHERE request_id = l_request_id) ;

Line 645: 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)

641: SET request_id = l_request_id
642: WHERE (order_source_id, orig_sys_document_ref,
643: 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
644: ( SELECT order_source_id, orig_sys_document_ref,
645: 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)
646: FROM oe_headers_iface_all
647: WHERE request_id = l_request_id) ;
648: /*AND decode(p_perf_param, 'Y',
649: nvl(error_flag,'N'), ' ')

Line 659: 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

655:
656: UPDATE oe_payments_iface_all
657: SET request_id = l_request_id
658: WHERE (order_source_id, orig_sys_document_ref,
659: 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
660: ( SELECT order_source_id, orig_sys_document_ref,
661: 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)
662: FROM oe_headers_iface_all
663: WHERE request_id = l_request_id) ;

Line 661: 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)

657: SET request_id = l_request_id
658: WHERE (order_source_id, orig_sys_document_ref,
659: 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
660: ( SELECT order_source_id, orig_sys_document_ref,
661: 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)
662: FROM oe_headers_iface_all
663: WHERE request_id = l_request_id) ;
664: /* AND decode(p_perf_param, 'Y',
665: nvl(error_flag,'N'), ' ')

Line 680: 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

676: /* Added for #1433292 */
677: UPDATE oe_price_atts_iface_all
678: SET request_id = l_request_id
679: WHERE (order_source_id, orig_sys_document_ref,
680: 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
681: ( SELECT order_source_id, orig_sys_document_ref,
682: 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)
683: FROM oe_headers_iface_all
684: WHERE request_id = l_request_id) ;

Line 682: 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)

678: SET request_id = l_request_id
679: WHERE (order_source_id, orig_sys_document_ref,
680: 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
681: ( SELECT order_source_id, orig_sys_document_ref,
682: 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)
683: FROM oe_headers_iface_all
684: WHERE request_id = l_request_id) ;
685: /* AND decode(p_perf_param, 'Y',
686: nvl(error_flag,'N'), ' ')

Line 696: 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

692:
693: UPDATE oe_credits_iface_all
694: SET request_id = l_request_id
695: WHERE (order_source_id, orig_sys_document_ref,
696: 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
697: ( SELECT order_source_id, orig_sys_document_ref,
698: 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)
699: FROM oe_headers_iface_all
700: WHERE request_id = l_request_id) ;

Line 698: 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)

694: SET request_id = l_request_id
695: WHERE (order_source_id, orig_sys_document_ref,
696: 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
697: ( SELECT order_source_id, orig_sys_document_ref,
698: 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)
699: FROM oe_headers_iface_all
700: WHERE request_id = l_request_id) ;
701: /*AND decode(p_perf_param, 'Y',
702: nvl(error_flag,'N'), ' ')

Line 711: 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

707:
708: UPDATE oe_lotserials_iface_all
709: SET request_id = l_request_id
710: WHERE (order_source_id, orig_sys_document_ref,
711: 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
712: ( SELECT order_source_id, orig_sys_document_ref,
713: 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)
714: FROM oe_headers_iface_all
715: WHERE request_id = l_request_id) ;

Line 713: 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)

709: SET request_id = l_request_id
710: WHERE (order_source_id, orig_sys_document_ref,
711: 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
712: ( SELECT order_source_id, orig_sys_document_ref,
713: 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)
714: FROM oe_headers_iface_all
715: WHERE request_id = l_request_id) ;
716: /*AND decode(p_perf_param, 'Y',
717: nvl(error_flag,'N'), ' ')

Line 726: 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

722:
723: UPDATE oe_reservtns_iface_all
724: SET request_id = l_request_id
725: WHERE (order_source_id, orig_sys_document_ref,
726: 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
727: ( SELECT order_source_id, orig_sys_document_ref,
728: 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)
729: FROM oe_headers_iface_all
730: WHERE request_id = l_request_id) ;

Line 728: 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)

724: SET request_id = l_request_id
725: WHERE (order_source_id, orig_sys_document_ref,
726: 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
727: ( SELECT order_source_id, orig_sys_document_ref,
728: 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)
729: FROM oe_headers_iface_all
730: WHERE request_id = l_request_id) ;
731: /* AND decode(p_perf_param, 'Y',
732: nvl(error_flag,'N'), ' ')

Line 741: 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

737:
738: UPDATE oe_actions_iface_all
739: SET request_id = l_request_id
740: WHERE (order_source_id, orig_sys_document_ref,
741: 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
742: ( SELECT order_source_id, orig_sys_document_ref,
743: 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)
744: FROM oe_headers_iface_all
745: WHERE request_id = l_request_id) ;

Line 743: 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)

739: SET request_id = l_request_id
740: WHERE (order_source_id, orig_sys_document_ref,
741: 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
742: ( SELECT order_source_id, orig_sys_document_ref,
743: 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)
744: FROM oe_headers_iface_all
745: WHERE request_id = l_request_id) ;
746: /* AND decode(p_perf_param, 'Y',
747: nvl(error_flag,'N'), ' ')

Line 808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1035: IF l_return_status = FND_API.G_RET_STS_ERROR OR

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

Line 1036: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

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

Line 1103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1203: p_request_id IN NUMBER DEFAULT FND_API.G_MISS_NUM

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

Line 1208: ,p_change_sequence IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR

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

Line 1210: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

Line 1211: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE

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