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 971: l_msg_rec.TABLE_NAME :='QP_INTERFACE_LIST_HEADERS';

967: --Initially setting the message context.
968:
969: l_msg_rec.REQUEST_ID := P_HEADER_REC.REQUEST_ID(I);
970: l_msg_rec.ENTITY_TYPE :='PRL';
971: l_msg_rec.TABLE_NAME :='QP_INTERFACE_LIST_HEADERS';
972: l_msg_rec.ORIG_SYS_HEADER_REF := nvl(p_header_rec.orig_sys_header_ref(I),p_header_rec.list_header_id(I));
973: l_msg_rec.LIST_HEADER_ID := p_header_rec.list_header_id(I);
974: l_msg_rec.ORIG_SYS_LINE_REF := NULL;
975: l_msg_rec.ORIG_SYS_QUALIFIER_REF := NULL;

Line 1397: from qp_interface_list_headers

1393: l_exist := NULL;
1394:
1395: IF p_header_rec.interface_action_code(I) = 'INSERT' THEN
1396: Select count(*) into l_exist
1397: from qp_interface_list_headers
1398: where request_id = p_header_rec.request_id(I)
1399: and name = p_header_rec.name(I)
1400: and orig_sys_header_ref <> p_header_rec.orig_sys_header_ref(I)
1401: and process_status_flag = 'P'; --is null;

Line 1411: --and qp_interface_list_headers

1407: END IF;
1408: END IF;
1409:
1410: --Checking for uniqueness of orig_sys_header_ref in qp_list_headers
1411: --and qp_interface_list_headers
1412:
1413: l_exist := NULL;
1414:
1415: BEGIN

Line 1464: from qp_interface_list_headers

1460: l_exist:= NULL;
1461:
1462: IF p_header_rec.interface_action_code(I) = 'INSERT' THEN
1463: select count(*) into l_exist
1464: from qp_interface_list_headers
1465: where request_id =p_header_rec.request_id(I)
1466: and (list_header_id = p_header_rec.list_header_id(I) or
1467: orig_sys_header_ref = p_header_rec.orig_sys_header_ref(I))
1468: and nvl(list_source_code,'*') =nvl(p_header_rec.list_source_code(I),'*');

Line 1481: from qp_interface_list_headers

1477: END IF;
1478: ELSIF p_header_rec.interface_action_code(I) = 'UPDATE' AND l_header_id_null = 'N' THEN
1479: qp_bulk_loader_pub.write_log('checking for unique orig_sys_header_ref: ' || p_header_rec.orig_sys_header_ref(I));
1480: select count(distinct list_header_id) into l_exist
1481: from qp_interface_list_headers
1482: where request_id =p_header_rec.request_id(I)
1483: and orig_sys_header_ref = p_header_rec.orig_sys_header_ref(I)
1484: and nvl(list_source_code,'*') =nvl(p_header_rec.list_source_code(I),'*');
1485: /* 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 1489: from qp_interface_list_headers

1485: /* 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
1486: bug 6961376 is giving better result than the bug 3604226 we commented these lines and incorporated the new code */
1487:
1488: /* select count(*) into l_exist
1489: from qp_interface_list_headers
1490: where request_id =p_header_rec.request_id(I)
1491: -- Bug 3604226 RAVI
1492: /**
1493: Multiple headers for insert or delete action with same orig_sys_hdr_ref

Line 2358: from qp_interface_list_headers

2354: BEGIN
2355: select fnd_date.canonical_to_date(start_date_active),
2356: fnd_date.canonical_to_date(end_date_active)
2357: into l_header_start_date, l_header_end_date
2358: from qp_interface_list_headers
2359: where orig_sys_header_ref=p_line_rec.orig_sys_header_ref(I)
2360: and request_id=p_line_rec.request_id(I)
2361: and interface_action_code in ('INSERT','UPDATE');
2362: EXCEPTION

Line 3026: FROM QP_interface_list_headers qpilh, qp_list_headers qplh

3022: **/
3023: BEGIN
3024: SELECT qplh.list_header_id
3025: INTO l_list_header_id
3026: FROM QP_interface_list_headers qpilh, qp_list_headers qplh
3027: WHERE qplh.list_header_id = to_number(p_qualifier_rec.qualifier_attr_value(I))
3028: AND qpilh.ORIG_SYS_HEADER_REF = p_qualifier_rec.ORIG_SYS_HEADER_REF(I)
3029: AND qplh.currency_code = qpilh.currency_code;
3030: EXCEPTION

Line 3780: FROM qp_interface_list_headers

3776:
3777: SELECT nvl(pte_code, fnd_profile.value('QP_PRICING_TRANSACTION_ENTITY')),
3778: nvl(source_system_code, fnd_profile.value('QP_SOURCE_SYSTEM_CODE'))
3779: INTO l_pte_code, l_ss_code
3780: FROM qp_interface_list_headers
3781: WHERE orig_sys_header_ref = p_PRICING_ATTR_rec.orig_sys_header_ref(I);
3782:
3783: QP_UTIL.Get_Item_Cat_Info(
3784: p_PRICING_ATTR_rec.product_attr_value(I),

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

5105: orig_sys_pricing_attr_ref, error_message)
5106: SELECT
5107: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5108: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5109: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'CURRENCY_CODE',
5110: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5111: FROM QP_INTERFACE_LIST_HEADERS qpih
5112: WHERE qpih.request_id = p_request_id
5113: AND qpih.process_status_flag ='P' --is null

Line 5111: FROM QP_INTERFACE_LIST_HEADERS qpih

5107: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5108: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5109: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'CURRENCY_CODE',
5110: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5111: FROM QP_INTERFACE_LIST_HEADERS qpih
5112: WHERE qpih.request_id = p_request_id
5113: AND qpih.process_status_flag ='P' --is null
5114: AND qpih.currency_code is not null
5115: AND qpih.interface_action_code IN ('INSERT', 'UPDATE')

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

5136: orig_sys_pricing_attr_ref, error_message)
5137: SELECT
5138: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5139: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5140: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FREIGHT TERMS',
5141: qpih.orig_sys_header_ref,null,null,null, l_msg_txt
5142: FROM QP_INTERFACE_LIST_HEADERS qpih
5143: WHERE qpih.request_id = p_request_id
5144: AND qpih.process_status_flag ='P' --is null

Line 5142: FROM QP_INTERFACE_LIST_HEADERS qpih

5138: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5139: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5140: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FREIGHT TERMS',
5141: qpih.orig_sys_header_ref,null,null,null, l_msg_txt
5142: FROM QP_INTERFACE_LIST_HEADERS qpih
5143: WHERE qpih.request_id = p_request_id
5144: AND qpih.process_status_flag ='P' --is null
5145: AND qpih.interface_action_code IN ('INSERT', 'UPDATE')
5146: AND qpih.freight_terms_code IS NOT NULL

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

5161: orig_sys_pricing_attr_ref, error_message)
5162: SELECT
5163: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5164: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5165: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FREIGHT TERMS',
5166: qpih.orig_sys_header_ref,null,null,null, l_msg_txt
5167: FROM QP_INTERFACE_LIST_HEADERS qpih
5168: WHERE qpih.request_id = p_request_id
5169: AND qpih.process_status_flag ='P' --is null

Line 5167: FROM QP_INTERFACE_LIST_HEADERS qpih

5163: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5164: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5165: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FREIGHT TERMS',
5166: qpih.orig_sys_header_ref,null,null,null, l_msg_txt
5167: FROM QP_INTERFACE_LIST_HEADERS qpih
5168: WHERE qpih.request_id = p_request_id
5169: AND qpih.process_status_flag ='P' --is null
5170: AND qpih.interface_action_code IN ('INSERT', 'UPDATE')
5171: AND qpih.freight_terms IS NOT NULL

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

5184: orig_sys_pricing_attr_ref, error_message)
5185: SELECT
5186: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5187: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5188: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FREIGHT TERMS',
5189: qpih.orig_sys_header_ref,null,null,null, l_msg_txt
5190: FROM QP_INTERFACE_LIST_HEADERS qpih
5191: WHERE qpih.request_id = p_request_id
5192: AND qpih.process_status_flag ='P' --is null

Line 5190: FROM QP_INTERFACE_LIST_HEADERS qpih

5186: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5187: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5188: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FREIGHT TERMS',
5189: qpih.orig_sys_header_ref,null,null,null, l_msg_txt
5190: FROM QP_INTERFACE_LIST_HEADERS qpih
5191: WHERE qpih.request_id = p_request_id
5192: AND qpih.process_status_flag ='P' --is null
5193: AND qpih.interface_action_code IN ('INSERT', 'UPDATE')
5194: AND qpih.freight_terms IS NULL

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

5215: orig_sys_pricing_attr_ref, error_message)
5216: SELECT
5217: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5218: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5219: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'LIST_TYPE_CODE',
5220: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5221: FROM QP_INTERFACE_LIST_HEADERS qpih
5222: WHERE qpih.request_id = p_request_id
5223: AND qpih.process_status_flag ='P' --is null

Line 5221: FROM QP_INTERFACE_LIST_HEADERS qpih

5217: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5218: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5219: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'LIST_TYPE_CODE',
5220: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5221: FROM QP_INTERFACE_LIST_HEADERS qpih
5222: WHERE qpih.request_id = p_request_id
5223: AND qpih.process_status_flag ='P' --is null
5224: AND qpih.interface_action_code IN ('INSERT', 'UPDATE')
5225: AND qpih.list_type_code IS NOT NULL

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

5244: orig_sys_pricing_attr_ref, error_message)
5245: SELECT
5246: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5247: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5248: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FRIEGHT CARRIER',
5249: qpih.orig_sys_header_ref, null,null,null,l_msg_txt
5250: FROM QP_INTERFACE_LIST_HEADERS qpih
5251: WHERE qpih.request_id = p_request_id
5252: AND qpih.process_status_flag ='P' --is null

Line 5250: FROM QP_INTERFACE_LIST_HEADERS qpih

5246: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5247: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5248: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FRIEGHT CARRIER',
5249: qpih.orig_sys_header_ref, null,null,null,l_msg_txt
5250: FROM QP_INTERFACE_LIST_HEADERS qpih
5251: WHERE qpih.request_id = p_request_id
5252: AND qpih.process_status_flag ='P' --is null
5253: AND qpih.interface_action_code IN ('INSERT', 'UPDATE')
5254: AND qpih.ship_method IS NOT NULL

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

5270: orig_sys_pricing_attr_ref, error_message)
5271: SELECT
5272: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5273: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5274: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FRIEGHT CARRIER',
5275: qpih.orig_sys_header_ref, null,null,null,l_msg_txt
5276: FROM QP_INTERFACE_LIST_HEADERS qpih
5277: WHERE qpih.request_id = p_request_id
5278: AND qpih.process_status_flag ='P' --is null

Line 5276: FROM QP_INTERFACE_LIST_HEADERS qpih

5272: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5273: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5274: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FRIEGHT CARRIER',
5275: qpih.orig_sys_header_ref, null,null,null,l_msg_txt
5276: FROM QP_INTERFACE_LIST_HEADERS qpih
5277: WHERE qpih.request_id = p_request_id
5278: AND qpih.process_status_flag ='P' --is null
5279: AND qpih.interface_action_code IN ('INSERT', 'UPDATE')
5280: AND qpih.ship_method IS NULL

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

5295: orig_sys_pricing_attr_ref, error_message)
5296: SELECT
5297: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5298: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5299: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FRIEGHT CARRIER',
5300: qpih.orig_sys_header_ref, null,null,null,l_msg_txt
5301: FROM QP_INTERFACE_LIST_HEADERS qpih
5302: WHERE qpih.request_id = p_request_id
5303: AND qpih.process_status_flag ='P' --is null

Line 5301: FROM QP_INTERFACE_LIST_HEADERS qpih

5297: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5298: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5299: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FRIEGHT CARRIER',
5300: qpih.orig_sys_header_ref, null,null,null,l_msg_txt
5301: FROM QP_INTERFACE_LIST_HEADERS qpih
5302: WHERE qpih.request_id = p_request_id
5303: AND qpih.process_status_flag ='P' --is null
5304: AND qpih.interface_action_code IN ('INSERT', 'UPDATE')
5305: AND qpih.ship_method IS NOT NULL

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

5327: orig_sys_pricing_attr_ref, error_message)
5328: SELECT
5329: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5330: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5331: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'PAYMENT TERMS',
5332: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5333: FROM QP_INTERFACE_LIST_HEADERS qpih
5334: WHERE qpih.request_id = p_request_id
5335: AND qpih.process_status_flag ='P' --is null

Line 5333: FROM QP_INTERFACE_LIST_HEADERS qpih

5329: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5330: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5331: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'PAYMENT TERMS',
5332: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5333: FROM QP_INTERFACE_LIST_HEADERS qpih
5334: WHERE qpih.request_id = p_request_id
5335: AND qpih.process_status_flag ='P' --is null
5336: AND qpih.interface_action_code IN ('INSERT', 'UPDATE')
5337: AND qpih.terms_id IS NOT NULL

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

5354: orig_sys_pricing_attr_ref, error_message)
5355: SELECT
5356: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5357: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5358: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'PAYMENT TERMS',
5359: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5360: FROM QP_INTERFACE_LIST_HEADERS qpih
5361: WHERE qpih.request_id = p_request_id
5362: AND qpih.process_status_flag ='P' --is null

Line 5360: FROM QP_INTERFACE_LIST_HEADERS qpih

5356: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5357: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5358: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'PAYMENT TERMS',
5359: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5360: FROM QP_INTERFACE_LIST_HEADERS qpih
5361: WHERE qpih.request_id = p_request_id
5362: AND qpih.process_status_flag ='P' --is null
5363: AND qpih.interface_action_code IN ('INSERT', 'UPDATE')
5364: AND qpih.terms_id IS NOT NULL

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

5379: orig_sys_pricing_attr_ref, error_message)
5380: SELECT
5381: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5382: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5383: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'PAYMENT TERMS',
5384: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5385: FROM QP_INTERFACE_LIST_HEADERS qpih
5386: WHERE qpih.request_id = p_request_id
5387: AND qpih.process_status_flag ='P' --is null

Line 5385: FROM QP_INTERFACE_LIST_HEADERS qpih

5381: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5382: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5383: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'PAYMENT TERMS',
5384: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5385: FROM QP_INTERFACE_LIST_HEADERS qpih
5386: WHERE qpih.request_id = p_request_id
5387: AND qpih.process_status_flag ='P' --is null
5388: AND qpih.interface_action_code IN ('INSERT', 'UPDATE')
5389: AND qpih.terms_id IS NULL

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

5417: orig_sys_pricing_attr_ref, error_message)
5418: SELECT
5419: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5420: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5421: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'CURRENCY_HEADER',
5422: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5423: FROM QP_INTERFACE_LIST_HEADERS qpih
5424: WHERE qpih.request_id = p_request_id
5425: AND qpih.process_status_flag ='P' --is null

Line 5423: FROM QP_INTERFACE_LIST_HEADERS qpih

5419: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5420: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5421: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'CURRENCY_HEADER',
5422: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5423: FROM QP_INTERFACE_LIST_HEADERS qpih
5424: WHERE qpih.request_id = p_request_id
5425: AND qpih.process_status_flag ='P' --is null
5426: AND qpih.interface_action_code IN ('INSERT', 'UPDATE')
5427: AND qpih.currency_header_id is NOT NULL

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

5443: orig_sys_pricing_attr_ref, error_message)
5444: SELECT
5445: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5446: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5447: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'CURRENCY_HEADER',
5448: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5449: FROM QP_INTERFACE_LIST_HEADERS qpih
5450: WHERE qpih.request_id = p_request_id
5451: AND qpih.process_status_flag ='P' --is null

Line 5449: FROM QP_INTERFACE_LIST_HEADERS qpih

5445: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5446: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5447: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'CURRENCY_HEADER',
5448: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5449: FROM QP_INTERFACE_LIST_HEADERS qpih
5450: WHERE qpih.request_id = p_request_id
5451: AND qpih.process_status_flag ='P' --is null
5452: AND qpih.interface_action_code IN ('INSERT', 'UPDATE')
5453: AND qpih.currency_header is NOT NULL

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

5468: orig_sys_pricing_attr_ref, error_message)
5469: SELECT
5470: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5471: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5472: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'CURRENCY_HEADER',
5473: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5474: FROM QP_INTERFACE_LIST_HEADERS qpih
5475: WHERE qpih.request_id = p_request_id
5476: AND qpih.process_status_flag ='P' --is null

Line 5474: FROM QP_INTERFACE_LIST_HEADERS qpih

5470: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5471: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5472: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'CURRENCY_HEADER',
5473: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5474: FROM QP_INTERFACE_LIST_HEADERS qpih
5475: WHERE qpih.request_id = p_request_id
5476: AND qpih.process_status_flag ='P' --is null
5477: AND qpih.interface_action_code IN ('INSERT', 'UPDATE')
5478: AND qpih.currency_header_id is NOT NULL

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

5497: orig_sys_pricing_attr_ref, error_message)
5498: SELECT
5499: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5500: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5501: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',
5502: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5503: FROM QP_INTERFACE_LIST_HEADERS qpih
5504: WHERE qpih.request_id = p_request_id
5505: AND qpih.process_status_flag ='P' --is null

Line 5503: FROM QP_INTERFACE_LIST_HEADERS qpih

5499: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5500: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5501: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',
5502: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5503: FROM QP_INTERFACE_LIST_HEADERS qpih
5504: WHERE qpih.request_id = p_request_id
5505: AND qpih.process_status_flag ='P' --is null
5506: -- AND qpih.interface_action_code IN ('INSERT', 'UPDATE')
5507: AND qpih.interface_action_code IN ('INSERT')

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

5522: orig_sys_pricing_attr_ref, error_message)
5523: SELECT
5524: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5525: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5526: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',
5527: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5528: FROM QP_INTERFACE_LIST_HEADERS qpih
5529: WHERE qpih.request_id = p_request_id
5530: AND qpih.process_status_flag ='P' --is null

Line 5528: FROM QP_INTERFACE_LIST_HEADERS qpih

5524: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5525: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5526: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',
5527: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5528: FROM QP_INTERFACE_LIST_HEADERS qpih
5529: WHERE qpih.request_id = p_request_id
5530: AND qpih.process_status_flag ='P' --is null
5531: AND qpih.interface_action_code IN ('INSERT')
5532: AND EXISTS ( Select qlht.name from qp_list_headers_tl qlht

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

5548: orig_sys_pricing_attr_ref, error_message)
5549: SELECT
5550: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5551: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5552: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',
5553: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5554: FROM QP_INTERFACE_LIST_HEADERS qpih
5555: WHERE qpih.request_id = p_request_id
5556: AND qpih.process_status_flag ='P' --is null

Line 5554: FROM QP_INTERFACE_LIST_HEADERS qpih

5550: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5551: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5552: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',
5553: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5554: FROM QP_INTERFACE_LIST_HEADERS qpih
5555: WHERE qpih.request_id = p_request_id
5556: AND qpih.process_status_flag ='P' --is null
5557: AND qpih.interface_action_code IN ('INSERT')
5558: AND EXISTS ( Select 'x' from qp_interface_list_headers qpih1

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

5554: FROM QP_INTERFACE_LIST_HEADERS qpih
5555: WHERE qpih.request_id = p_request_id
5556: AND qpih.process_status_flag ='P' --is null
5557: AND qpih.interface_action_code IN ('INSERT')
5558: AND EXISTS ( Select 'x' from qp_interface_list_headers qpih1
5559: where qpih1.request_id = p_request_id
5560: and qpih1.name = qpih.name
5561: and qpih1.process_status_flag is null
5562: and qpih1.rowid <> qpih.rowid

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

5577: orig_sys_pricing_attr_ref, error_message)
5578: SELECT
5579: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5580: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5581: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'pte_code',
5582: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5583: FROM QP_INTERFACE_LIST_HEADERS qpih
5584: WHERE qpih.request_id = p_request_id
5585: AND qpih.process_status_flag ='P' --is null

Line 5583: FROM QP_INTERFACE_LIST_HEADERS qpih

5579: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5580: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5581: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'pte_code',
5582: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5583: FROM QP_INTERFACE_LIST_HEADERS qpih
5584: WHERE qpih.request_id = p_request_id
5585: AND qpih.process_status_flag ='P' --is null
5586: AND qpih.interface_action_code IN ('INSERT', 'UPDATE')
5587: AND qpih.pte_code IS NOT NULL

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

5604: orig_sys_pricing_attr_ref, error_message)
5605: SELECT
5606: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5607: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5608: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',
5609: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5610: FROM QP_INTERFACE_LIST_HEADERS qpih
5611: WHERE qpih.request_id = p_request_id
5612: AND qpih.process_status_flag ='P' --is null

Line 5610: FROM QP_INTERFACE_LIST_HEADERS qpih

5606: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5607: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5608: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',
5609: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5610: FROM QP_INTERFACE_LIST_HEADERS qpih
5611: WHERE qpih.request_id = p_request_id
5612: AND qpih.process_status_flag ='P' --is null
5613: AND qpih.interface_action_code IN ('INSERT', 'UPDATE')
5614: AND qpih.source_system_code IS NOT NULL

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

5626: orig_sys_pricing_attr_ref, error_message)
5627: SELECT
5628: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5629: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5630: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',
5631: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5632: FROM QP_INTERFACE_LIST_HEADERS qpih
5633: WHERE qpih.request_id = p_request_id
5634: AND qpih.process_status_flag ='P' --is null

Line 5632: FROM QP_INTERFACE_LIST_HEADERS qpih

5628: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5629: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5630: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',
5631: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5632: FROM QP_INTERFACE_LIST_HEADERS qpih
5633: WHERE qpih.request_id = p_request_id
5634: AND qpih.process_status_flag ='P' --is null
5635: AND qpih.interface_action_code IN ('INSERT', 'UPDATE')
5636: -- Bug 5416556 RAVI

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

5652: orig_sys_pricing_attr_ref, error_message)
5653: SELECT
5654: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5655: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5656: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',
5657: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5658: FROM QP_INTERFACE_LIST_HEADERS qpih
5659: WHERE qpih.request_id = p_request_id
5660: AND qpih.process_status_flag ='P' --is null

Line 5658: FROM QP_INTERFACE_LIST_HEADERS qpih

5654: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5655: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5656: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',
5657: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5658: FROM QP_INTERFACE_LIST_HEADERS qpih
5659: WHERE qpih.request_id = p_request_id
5660: AND qpih.process_status_flag ='P' --is null
5661: AND qpih.interface_action_code IN ('INSERT', 'UPDATE')
5662: AND qpih.global_flag = 'N' and qpih.orig_org_id IS NOT NULL

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

5676: orig_sys_pricing_attr_ref, error_message)
5677: SELECT
5678: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5679: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5680: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'ROUNDING_FACTOR',
5681: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5682: FROM QP_INTERFACE_LIST_HEADERS qpih
5683: WHERE qpih.request_id = p_request_id
5684: AND qpih.process_status_flag ='P' --is null

Line 5682: FROM QP_INTERFACE_LIST_HEADERS qpih

5678: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5679: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5680: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'ROUNDING_FACTOR',
5681: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5682: FROM QP_INTERFACE_LIST_HEADERS qpih
5683: WHERE qpih.request_id = p_request_id
5684: AND qpih.process_status_flag ='P' --is null
5685: AND qpih.interface_action_code ='UPDATE'
5686: AND EXISTS(

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

5706: orig_sys_pricing_attr_ref, error_message)
5707: SELECT
5708: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5709: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5710: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'ORIG_SYS_HEADER_REF',
5711: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5712: FROM QP_INTERFACE_LIST_HEADERS qpih
5713: WHERE qpih.request_id = p_request_id
5714: AND qpih.process_status_flag ='P' --is null

Line 5712: FROM QP_INTERFACE_LIST_HEADERS qpih

5708: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5709: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5710: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'ORIG_SYS_HEADER_REF',
5711: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5712: FROM QP_INTERFACE_LIST_HEADERS qpih
5713: WHERE qpih.request_id = p_request_id
5714: AND qpih.process_status_flag ='P' --is null
5715: AND qpih.interface_action_code IN ('UPDATE', 'DELETE')
5716: AND ( select count(*) from qp_interface_list_headers qplh

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

5712: FROM QP_INTERFACE_LIST_HEADERS qpih
5713: WHERE qpih.request_id = p_request_id
5714: AND qpih.process_status_flag ='P' --is null
5715: AND qpih.interface_action_code IN ('UPDATE', 'DELETE')
5716: AND ( select count(*) from qp_interface_list_headers qplh
5717: where qplh.orig_sys_header_ref=qpih.orig_sys_header_ref
5718: ) > 1;*/
5719: --Bug#3604226 RAVI END
5720:

Line 6708: UPDATE qp_interface_list_headers h

6704: qp_bulk_loader_pub.write_log('Entering Mark errored inreface record');
6705:
6706: IF p_table_type = 'HEADER' THEN
6707:
6708: UPDATE qp_interface_list_headers h
6709: SET h.process_status_flag = NULL --'E'
6710: WHERE h.request_id = p_request_id
6711: AND EXISTS
6712: (SELECT orig_sys_header_ref

Line 6715: AND e.table_name ='QP_INTERFACE_LIST_HEADERS'

6711: AND EXISTS
6712: (SELECT orig_sys_header_ref
6713: FROM qp_interface_errors e
6714: WHERE e.orig_sys_header_ref = h.orig_sys_header_ref
6715: AND e.table_name ='QP_INTERFACE_LIST_HEADERS'
6716: AND e.request_id = p_request_id );
6717:
6718: ELSIF p_table_type = 'QUALIFIER' THEN
6719: