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.QP_BULK_VALIDATE dependencies on QP_INTERFACE_LIST_HEADERS

Line 1127: l_msg_rec.TABLE_NAME :='QP_INTERFACE_LIST_HEADERS';

1123: --Initially setting the message context.
1124:
1125: l_msg_rec.REQUEST_ID := P_HEADER_REC.REQUEST_ID(I);
1126: l_msg_rec.ENTITY_TYPE :='PRL';
1127: l_msg_rec.TABLE_NAME :='QP_INTERFACE_LIST_HEADERS';
1128: l_msg_rec.ORIG_SYS_HEADER_REF := nvl(p_header_rec.orig_sys_header_ref(I),p_header_rec.list_header_id(I));
1129: l_msg_rec.LIST_HEADER_ID := p_header_rec.list_header_id(I);
1130: l_msg_rec.ORIG_SYS_LINE_REF := NULL;
1131: l_msg_rec.ORIG_SYS_QUALIFIER_REF := NULL;

Line 1553: from qp_interface_list_headers

1549: l_exist := NULL;
1550:
1551: IF p_header_rec.interface_action_code(I) = 'INSERT' THEN
1552: Select count(*) into l_exist
1553: from qp_interface_list_headers
1554: where request_id = p_header_rec.request_id(I)
1555: and name = p_header_rec.name(I)
1556: and orig_sys_header_ref <> p_header_rec.orig_sys_header_ref(I)
1557: and process_status_flag = 'P'; --is null;

Line 1567: --and qp_interface_list_headers

1563: END IF;
1564: END IF;
1565:
1566: --Checking for uniqueness of orig_sys_header_ref in qp_list_headers
1567: --and qp_interface_list_headers
1568:
1569: l_exist := NULL;
1570:
1571: BEGIN

Line 1620: from qp_interface_list_headers

1616: l_exist:= NULL;
1617:
1618: IF p_header_rec.interface_action_code(I) = 'INSERT' THEN
1619: select count(*) into l_exist
1620: from qp_interface_list_headers
1621: where request_id =p_header_rec.request_id(I)
1622: and (list_header_id = p_header_rec.list_header_id(I) or
1623: orig_sys_header_ref = p_header_rec.orig_sys_header_ref(I))
1624: and nvl(list_source_code,'*') =nvl(p_header_rec.list_source_code(I),'*');

Line 1637: from qp_interface_list_headers

1633: END IF;
1634: ELSIF p_header_rec.interface_action_code(I) = 'UPDATE' AND l_header_id_null = 'N' THEN
1635: qp_bulk_loader_pub.write_log('checking for unique orig_sys_header_ref: ' || p_header_rec.orig_sys_header_ref(I));
1636: select count(distinct list_header_id) into l_exist
1637: from qp_interface_list_headers
1638: where request_id =p_header_rec.request_id(I)
1639: and orig_sys_header_ref = p_header_rec.orig_sys_header_ref(I)
1640: and nvl(list_source_code,'*') =nvl(p_header_rec.list_source_code(I),'*');
1641: /* 1749 to 1764 commented to for the bug number 6961376 as the bug 3604226 and bug 6961376 are raised for the same problem and the fix for the

Line 1645: from qp_interface_list_headers

1641: /* 1749 to 1764 commented to for the bug number 6961376 as the bug 3604226 and bug 6961376 are raised for the same problem and the fix for the
1642: bug 6961376 is giving better result than the bug 3604226 we commented these lines and incorporated the new code */
1643:
1644: /* select count(*) into l_exist
1645: from qp_interface_list_headers
1646: where request_id =p_header_rec.request_id(I)
1647: -- Bug 3604226 RAVI
1648: /**
1649: Multiple headers for insert or delete action with same orig_sys_hdr_ref

Line 2486: from qp_interface_list_headers

2482: BEGIN
2483: select fnd_date.canonical_to_date(start_date_active),
2484: fnd_date.canonical_to_date(end_date_active)
2485: into l_header_start_date, l_header_end_date
2486: from qp_interface_list_headers
2487: where orig_sys_header_ref=p_line_rec.orig_sys_header_ref(I)
2488: and request_id=p_line_rec.request_id(I)
2489: and interface_action_code in ('INSERT','UPDATE');
2490: EXCEPTION

Line 3153: FROM QP_interface_list_headers qpilh, qp_list_headers qplh

3149: **/
3150: BEGIN
3151: SELECT qplh.list_header_id
3152: INTO l_list_header_id
3153: FROM QP_interface_list_headers qpilh, qp_list_headers qplh
3154: WHERE qplh.list_header_id = to_number(p_qualifier_rec.qualifier_attr_value(I))
3155: AND qpilh.ORIG_SYS_HEADER_REF = p_qualifier_rec.ORIG_SYS_HEADER_REF(I)
3156: AND qplh.currency_code = qpilh.currency_code;
3157: EXCEPTION

Line 3892: FROM qp_interface_list_headers

3888:
3889: SELECT nvl(pte_code, fnd_profile.value('QP_PRICING_TRANSACTION_ENTITY')),
3890: nvl(source_system_code, fnd_profile.value('QP_SOURCE_SYSTEM_CODE'))
3891: INTO l_pte_code, l_ss_code
3892: FROM qp_interface_list_headers
3893: WHERE orig_sys_header_ref = p_PRICING_ATTR_rec.orig_sys_header_ref(I);
3894:
3895: QP_UTIL.Get_Item_Cat_Info(
3896: p_PRICING_ATTR_rec.product_attr_value(I),

Line 5121: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'CURRENCY_CODE',

5117: orig_sys_pricing_attr_ref, error_message)
5118: SELECT
5119: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5120: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5121: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'CURRENCY_CODE',
5122: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5123: FROM QP_INTERFACE_LIST_HEADERS qpih
5124: WHERE qpih.request_id = p_request_id
5125: AND qpih.process_status_flag ='P' --is null

Line 5123: FROM QP_INTERFACE_LIST_HEADERS qpih

5119: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5120: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5121: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'CURRENCY_CODE',
5122: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5123: FROM QP_INTERFACE_LIST_HEADERS qpih
5124: WHERE qpih.request_id = p_request_id
5125: AND qpih.process_status_flag ='P' --is null
5126: AND qpih.currency_code is not null
5127: AND qpih.interface_action_code IN ('INSERT', 'UPDATE')

Line 5152: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FREIGHT TERMS',

5148: orig_sys_pricing_attr_ref, error_message)
5149: SELECT
5150: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5151: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5152: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FREIGHT TERMS',
5153: qpih.orig_sys_header_ref,null,null,null, l_msg_txt
5154: FROM QP_INTERFACE_LIST_HEADERS qpih
5155: WHERE qpih.request_id = p_request_id
5156: AND qpih.process_status_flag ='P' --is null

Line 5154: FROM QP_INTERFACE_LIST_HEADERS qpih

5150: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5151: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5152: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FREIGHT TERMS',
5153: qpih.orig_sys_header_ref,null,null,null, l_msg_txt
5154: FROM QP_INTERFACE_LIST_HEADERS qpih
5155: WHERE qpih.request_id = p_request_id
5156: AND qpih.process_status_flag ='P' --is null
5157: AND qpih.interface_action_code IN ('INSERT', 'UPDATE')
5158: AND qpih.freight_terms_code IS NOT NULL

Line 5177: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FREIGHT TERMS',

5173: orig_sys_pricing_attr_ref, error_message)
5174: SELECT
5175: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5176: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5177: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FREIGHT TERMS',
5178: qpih.orig_sys_header_ref,null,null,null, l_msg_txt
5179: FROM QP_INTERFACE_LIST_HEADERS qpih
5180: WHERE qpih.request_id = p_request_id
5181: AND qpih.process_status_flag ='P' --is null

Line 5179: FROM QP_INTERFACE_LIST_HEADERS qpih

5175: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5176: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5177: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FREIGHT TERMS',
5178: qpih.orig_sys_header_ref,null,null,null, l_msg_txt
5179: FROM QP_INTERFACE_LIST_HEADERS qpih
5180: WHERE qpih.request_id = p_request_id
5181: AND qpih.process_status_flag ='P' --is null
5182: AND qpih.interface_action_code IN ('INSERT', 'UPDATE')
5183: AND qpih.freight_terms IS NOT NULL

Line 5200: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FREIGHT TERMS',

5196: orig_sys_pricing_attr_ref, error_message)
5197: SELECT
5198: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5199: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5200: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FREIGHT TERMS',
5201: qpih.orig_sys_header_ref,null,null,null, l_msg_txt
5202: FROM QP_INTERFACE_LIST_HEADERS qpih
5203: WHERE qpih.request_id = p_request_id
5204: AND qpih.process_status_flag ='P' --is null

Line 5202: FROM QP_INTERFACE_LIST_HEADERS qpih

5198: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5199: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5200: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FREIGHT TERMS',
5201: qpih.orig_sys_header_ref,null,null,null, l_msg_txt
5202: FROM QP_INTERFACE_LIST_HEADERS qpih
5203: WHERE qpih.request_id = p_request_id
5204: AND qpih.process_status_flag ='P' --is null
5205: AND qpih.interface_action_code IN ('INSERT', 'UPDATE')
5206: AND qpih.freight_terms IS NULL

Line 5231: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'LIST_TYPE_CODE',

5227: orig_sys_pricing_attr_ref, error_message)
5228: SELECT
5229: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5230: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5231: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'LIST_TYPE_CODE',
5232: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5233: FROM QP_INTERFACE_LIST_HEADERS qpih
5234: WHERE qpih.request_id = p_request_id
5235: AND qpih.process_status_flag ='P' --is null

Line 5233: FROM QP_INTERFACE_LIST_HEADERS qpih

5229: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5230: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5231: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'LIST_TYPE_CODE',
5232: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5233: FROM QP_INTERFACE_LIST_HEADERS qpih
5234: WHERE qpih.request_id = p_request_id
5235: AND qpih.process_status_flag ='P' --is null
5236: AND qpih.interface_action_code IN ('INSERT', 'UPDATE')
5237: AND qpih.list_type_code IS NOT NULL

Line 5260: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FRIEGHT CARRIER',

5256: orig_sys_pricing_attr_ref, error_message)
5257: SELECT
5258: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5259: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5260: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FRIEGHT CARRIER',
5261: qpih.orig_sys_header_ref, null,null,null,l_msg_txt
5262: FROM QP_INTERFACE_LIST_HEADERS qpih
5263: WHERE qpih.request_id = p_request_id
5264: AND qpih.process_status_flag ='P' --is null

Line 5262: FROM QP_INTERFACE_LIST_HEADERS qpih

5258: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5259: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5260: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FRIEGHT CARRIER',
5261: qpih.orig_sys_header_ref, null,null,null,l_msg_txt
5262: FROM QP_INTERFACE_LIST_HEADERS qpih
5263: WHERE qpih.request_id = p_request_id
5264: AND qpih.process_status_flag ='P' --is null
5265: AND qpih.interface_action_code IN ('INSERT', 'UPDATE')
5266: AND qpih.ship_method IS NOT NULL

Line 5286: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FRIEGHT CARRIER',

5282: orig_sys_pricing_attr_ref, error_message)
5283: SELECT
5284: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5285: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5286: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FRIEGHT CARRIER',
5287: qpih.orig_sys_header_ref, null,null,null,l_msg_txt
5288: FROM QP_INTERFACE_LIST_HEADERS qpih
5289: WHERE qpih.request_id = p_request_id
5290: AND qpih.process_status_flag ='P' --is null

Line 5288: FROM QP_INTERFACE_LIST_HEADERS qpih

5284: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5285: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5286: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FRIEGHT CARRIER',
5287: qpih.orig_sys_header_ref, null,null,null,l_msg_txt
5288: FROM QP_INTERFACE_LIST_HEADERS qpih
5289: WHERE qpih.request_id = p_request_id
5290: AND qpih.process_status_flag ='P' --is null
5291: AND qpih.interface_action_code IN ('INSERT', 'UPDATE')
5292: AND qpih.ship_method IS NULL

Line 5311: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FRIEGHT CARRIER',

5307: orig_sys_pricing_attr_ref, error_message)
5308: SELECT
5309: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5310: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5311: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FRIEGHT CARRIER',
5312: qpih.orig_sys_header_ref, null,null,null,l_msg_txt
5313: FROM QP_INTERFACE_LIST_HEADERS qpih
5314: WHERE qpih.request_id = p_request_id
5315: AND qpih.process_status_flag ='P' --is null

Line 5313: FROM QP_INTERFACE_LIST_HEADERS qpih

5309: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5310: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5311: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FRIEGHT CARRIER',
5312: qpih.orig_sys_header_ref, null,null,null,l_msg_txt
5313: FROM QP_INTERFACE_LIST_HEADERS qpih
5314: WHERE qpih.request_id = p_request_id
5315: AND qpih.process_status_flag ='P' --is null
5316: AND qpih.interface_action_code IN ('INSERT', 'UPDATE')
5317: AND qpih.ship_method IS NOT NULL

Line 5343: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'PAYMENT TERMS',

5339: orig_sys_pricing_attr_ref, error_message)
5340: SELECT
5341: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5342: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5343: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'PAYMENT TERMS',
5344: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5345: FROM QP_INTERFACE_LIST_HEADERS qpih
5346: WHERE qpih.request_id = p_request_id
5347: AND qpih.process_status_flag ='P' --is null

Line 5345: FROM QP_INTERFACE_LIST_HEADERS qpih

5341: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5342: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5343: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'PAYMENT TERMS',
5344: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5345: FROM QP_INTERFACE_LIST_HEADERS qpih
5346: WHERE qpih.request_id = p_request_id
5347: AND qpih.process_status_flag ='P' --is null
5348: AND qpih.interface_action_code IN ('INSERT', 'UPDATE')
5349: AND qpih.terms_id IS NOT NULL

Line 5370: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'PAYMENT TERMS',

5366: orig_sys_pricing_attr_ref, error_message)
5367: SELECT
5368: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5369: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5370: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'PAYMENT TERMS',
5371: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5372: FROM QP_INTERFACE_LIST_HEADERS qpih
5373: WHERE qpih.request_id = p_request_id
5374: AND qpih.process_status_flag ='P' --is null

Line 5372: FROM QP_INTERFACE_LIST_HEADERS qpih

5368: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5369: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5370: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'PAYMENT TERMS',
5371: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5372: FROM QP_INTERFACE_LIST_HEADERS qpih
5373: WHERE qpih.request_id = p_request_id
5374: AND qpih.process_status_flag ='P' --is null
5375: AND qpih.interface_action_code IN ('INSERT', 'UPDATE')
5376: AND qpih.terms_id IS NOT NULL

Line 5395: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'PAYMENT TERMS',

5391: orig_sys_pricing_attr_ref, error_message)
5392: SELECT
5393: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5394: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5395: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'PAYMENT TERMS',
5396: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5397: FROM QP_INTERFACE_LIST_HEADERS qpih
5398: WHERE qpih.request_id = p_request_id
5399: AND qpih.process_status_flag ='P' --is null

Line 5397: FROM QP_INTERFACE_LIST_HEADERS qpih

5393: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5394: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5395: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'PAYMENT TERMS',
5396: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5397: FROM QP_INTERFACE_LIST_HEADERS qpih
5398: WHERE qpih.request_id = p_request_id
5399: AND qpih.process_status_flag ='P' --is null
5400: AND qpih.interface_action_code IN ('INSERT', 'UPDATE')
5401: AND qpih.terms_id IS NULL

Line 5433: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'CURRENCY_HEADER',

5429: orig_sys_pricing_attr_ref, error_message)
5430: SELECT
5431: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5432: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5433: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'CURRENCY_HEADER',
5434: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5435: FROM QP_INTERFACE_LIST_HEADERS qpih
5436: WHERE qpih.request_id = p_request_id
5437: AND qpih.process_status_flag ='P' --is null

Line 5435: FROM QP_INTERFACE_LIST_HEADERS qpih

5431: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5432: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5433: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'CURRENCY_HEADER',
5434: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5435: FROM QP_INTERFACE_LIST_HEADERS qpih
5436: WHERE qpih.request_id = p_request_id
5437: AND qpih.process_status_flag ='P' --is null
5438: AND qpih.interface_action_code IN ('INSERT', 'UPDATE')
5439: AND qpih.currency_header_id is NOT NULL

Line 5459: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'CURRENCY_HEADER',

5455: orig_sys_pricing_attr_ref, error_message)
5456: SELECT
5457: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5458: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5459: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'CURRENCY_HEADER',
5460: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5461: FROM QP_INTERFACE_LIST_HEADERS qpih
5462: WHERE qpih.request_id = p_request_id
5463: AND qpih.process_status_flag ='P' --is null

Line 5461: FROM QP_INTERFACE_LIST_HEADERS qpih

5457: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5458: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5459: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'CURRENCY_HEADER',
5460: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5461: FROM QP_INTERFACE_LIST_HEADERS qpih
5462: WHERE qpih.request_id = p_request_id
5463: AND qpih.process_status_flag ='P' --is null
5464: AND qpih.interface_action_code IN ('INSERT', 'UPDATE')
5465: AND qpih.currency_header is NOT NULL

Line 5484: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'CURRENCY_HEADER',

5480: orig_sys_pricing_attr_ref, error_message)
5481: SELECT
5482: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5483: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5484: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'CURRENCY_HEADER',
5485: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5486: FROM QP_INTERFACE_LIST_HEADERS qpih
5487: WHERE qpih.request_id = p_request_id
5488: AND qpih.process_status_flag ='P' --is null

Line 5486: FROM QP_INTERFACE_LIST_HEADERS qpih

5482: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5483: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5484: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'CURRENCY_HEADER',
5485: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5486: FROM QP_INTERFACE_LIST_HEADERS qpih
5487: WHERE qpih.request_id = p_request_id
5488: AND qpih.process_status_flag ='P' --is null
5489: AND qpih.interface_action_code IN ('INSERT', 'UPDATE')
5490: AND qpih.currency_header_id is NOT NULL

Line 5513: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',

5509: orig_sys_pricing_attr_ref, error_message)
5510: SELECT
5511: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5512: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5513: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',
5514: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5515: FROM QP_INTERFACE_LIST_HEADERS qpih
5516: WHERE qpih.request_id = p_request_id
5517: AND qpih.process_status_flag ='P' --is null

Line 5515: FROM QP_INTERFACE_LIST_HEADERS qpih

5511: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5512: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5513: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',
5514: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5515: FROM QP_INTERFACE_LIST_HEADERS qpih
5516: WHERE qpih.request_id = p_request_id
5517: AND qpih.process_status_flag ='P' --is null
5518: -- AND qpih.interface_action_code IN ('INSERT', 'UPDATE')
5519: AND qpih.interface_action_code IN ('INSERT')

Line 5538: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',

5534: orig_sys_pricing_attr_ref, error_message)
5535: SELECT
5536: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5537: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5538: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',
5539: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5540: FROM QP_INTERFACE_LIST_HEADERS qpih
5541: WHERE qpih.request_id = p_request_id
5542: AND qpih.process_status_flag ='P' --is null

Line 5540: FROM QP_INTERFACE_LIST_HEADERS qpih

5536: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5537: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5538: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',
5539: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5540: FROM QP_INTERFACE_LIST_HEADERS qpih
5541: WHERE qpih.request_id = p_request_id
5542: AND qpih.process_status_flag ='P' --is null
5543: AND qpih.interface_action_code IN ('INSERT')
5544: AND EXISTS ( Select qlht.name from qp_list_headers_tl qlht

Line 5564: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',

5560: orig_sys_pricing_attr_ref, error_message)
5561: SELECT
5562: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5563: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5564: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',
5565: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5566: FROM QP_INTERFACE_LIST_HEADERS qpih
5567: WHERE qpih.request_id = p_request_id
5568: AND qpih.process_status_flag ='P' --is null

Line 5566: FROM QP_INTERFACE_LIST_HEADERS qpih

5562: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5563: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5564: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',
5565: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5566: FROM QP_INTERFACE_LIST_HEADERS qpih
5567: WHERE qpih.request_id = p_request_id
5568: AND qpih.process_status_flag ='P' --is null
5569: AND qpih.interface_action_code IN ('INSERT')
5570: AND EXISTS ( Select 'x' from qp_interface_list_headers qpih1

Line 5570: AND EXISTS ( Select 'x' from qp_interface_list_headers qpih1

5566: FROM QP_INTERFACE_LIST_HEADERS qpih
5567: WHERE qpih.request_id = p_request_id
5568: AND qpih.process_status_flag ='P' --is null
5569: AND qpih.interface_action_code IN ('INSERT')
5570: AND EXISTS ( Select 'x' from qp_interface_list_headers qpih1
5571: where qpih1.request_id = p_request_id
5572: and qpih1.name = qpih.name
5573: and qpih1.process_status_flag is null
5574: and qpih1.rowid <> qpih.rowid

Line 5593: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'pte_code',

5589: orig_sys_pricing_attr_ref, error_message)
5590: SELECT
5591: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5592: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5593: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'pte_code',
5594: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5595: FROM QP_INTERFACE_LIST_HEADERS qpih
5596: WHERE qpih.request_id = p_request_id
5597: AND qpih.process_status_flag ='P' --is null

Line 5595: FROM QP_INTERFACE_LIST_HEADERS qpih

5591: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5592: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5593: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'pte_code',
5594: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5595: FROM QP_INTERFACE_LIST_HEADERS qpih
5596: WHERE qpih.request_id = p_request_id
5597: AND qpih.process_status_flag ='P' --is null
5598: AND qpih.interface_action_code IN ('INSERT', 'UPDATE')
5599: AND qpih.pte_code IS NOT NULL

Line 5620: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',

5616: orig_sys_pricing_attr_ref, error_message)
5617: SELECT
5618: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5619: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5620: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',
5621: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5622: FROM QP_INTERFACE_LIST_HEADERS qpih
5623: WHERE qpih.request_id = p_request_id
5624: AND qpih.process_status_flag ='P' --is null

Line 5622: FROM QP_INTERFACE_LIST_HEADERS qpih

5618: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5619: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5620: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',
5621: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5622: FROM QP_INTERFACE_LIST_HEADERS qpih
5623: WHERE qpih.request_id = p_request_id
5624: AND qpih.process_status_flag ='P' --is null
5625: AND qpih.interface_action_code IN ('INSERT', 'UPDATE')
5626: AND qpih.source_system_code IS NOT NULL

Line 5642: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',

5638: orig_sys_pricing_attr_ref, error_message)
5639: SELECT
5640: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5641: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5642: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',
5643: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5644: FROM QP_INTERFACE_LIST_HEADERS qpih
5645: WHERE qpih.request_id = p_request_id
5646: AND qpih.process_status_flag ='P' --is null

Line 5644: FROM QP_INTERFACE_LIST_HEADERS qpih

5640: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5641: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5642: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',
5643: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5644: FROM QP_INTERFACE_LIST_HEADERS qpih
5645: WHERE qpih.request_id = p_request_id
5646: AND qpih.process_status_flag ='P' --is null
5647: AND qpih.interface_action_code IN ('INSERT', 'UPDATE')
5648: -- Bug 5416556 RAVI

Line 5668: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',

5664: orig_sys_pricing_attr_ref, error_message)
5665: SELECT
5666: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5667: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5668: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',
5669: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5670: FROM QP_INTERFACE_LIST_HEADERS qpih
5671: WHERE qpih.request_id = p_request_id
5672: AND qpih.process_status_flag ='P' --is null

Line 5670: FROM QP_INTERFACE_LIST_HEADERS qpih

5666: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5667: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5668: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',
5669: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5670: FROM QP_INTERFACE_LIST_HEADERS qpih
5671: WHERE qpih.request_id = p_request_id
5672: AND qpih.process_status_flag ='P' --is null
5673: AND qpih.interface_action_code IN ('INSERT', 'UPDATE')
5674: AND qpih.global_flag = 'N' and qpih.orig_org_id IS NOT NULL

Line 5692: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'ROUNDING_FACTOR',

5688: orig_sys_pricing_attr_ref, error_message)
5689: SELECT
5690: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5691: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5692: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'ROUNDING_FACTOR',
5693: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5694: FROM QP_INTERFACE_LIST_HEADERS qpih
5695: WHERE qpih.request_id = p_request_id
5696: AND qpih.process_status_flag ='P' --is null

Line 5694: FROM QP_INTERFACE_LIST_HEADERS qpih

5690: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5691: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5692: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'ROUNDING_FACTOR',
5693: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5694: FROM QP_INTERFACE_LIST_HEADERS qpih
5695: WHERE qpih.request_id = p_request_id
5696: AND qpih.process_status_flag ='P' --is null
5697: AND qpih.interface_action_code ='UPDATE'
5698: AND EXISTS(

Line 5722: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'ORIG_SYS_HEADER_REF',

5718: orig_sys_pricing_attr_ref, error_message)
5719: SELECT
5720: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5721: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5722: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'ORIG_SYS_HEADER_REF',
5723: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5724: FROM QP_INTERFACE_LIST_HEADERS qpih
5725: WHERE qpih.request_id = p_request_id
5726: AND qpih.process_status_flag ='P' --is null

Line 5724: FROM QP_INTERFACE_LIST_HEADERS qpih

5720: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5721: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5722: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'ORIG_SYS_HEADER_REF',
5723: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5724: FROM QP_INTERFACE_LIST_HEADERS qpih
5725: WHERE qpih.request_id = p_request_id
5726: AND qpih.process_status_flag ='P' --is null
5727: AND qpih.interface_action_code IN ('UPDATE', 'DELETE')
5728: AND ( select count(*) from qp_interface_list_headers qplh

Line 5728: AND ( select count(*) from qp_interface_list_headers qplh

5724: FROM QP_INTERFACE_LIST_HEADERS qpih
5725: WHERE qpih.request_id = p_request_id
5726: AND qpih.process_status_flag ='P' --is null
5727: AND qpih.interface_action_code IN ('UPDATE', 'DELETE')
5728: AND ( select count(*) from qp_interface_list_headers qplh
5729: where qplh.orig_sys_header_ref=qpih.orig_sys_header_ref
5730: ) > 1;*/
5731: --Bug#3604226 RAVI END
5732:

Line 6720: UPDATE qp_interface_list_headers h

6716: qp_bulk_loader_pub.write_log('Entering Mark errored inreface record');
6717:
6718: IF p_table_type = 'HEADER' THEN
6719:
6720: UPDATE qp_interface_list_headers h
6721: SET h.process_status_flag = NULL --'E'
6722: WHERE h.request_id = p_request_id
6723: AND EXISTS
6724: (SELECT orig_sys_header_ref

Line 6727: AND e.table_name ='QP_INTERFACE_LIST_HEADERS'

6723: AND EXISTS
6724: (SELECT orig_sys_header_ref
6725: FROM qp_interface_errors e
6726: WHERE e.orig_sys_header_ref = h.orig_sys_header_ref
6727: AND e.table_name ='QP_INTERFACE_LIST_HEADERS'
6728: AND e.request_id = p_request_id );
6729:
6730: ELSIF p_table_type = 'QUALIFIER' THEN
6731: