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_ERRORS

Line 106: --mark duplicate line - insert into qp_interface_errors

102: qp_bulk_loader_pub.write_log(l_routine || '#200 Unexpected exception ' || SQLERRM);
103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
104: END CHECK_DATES_OVERLAP; --check_dates_overlap;
105:
106: --mark duplicate line - insert into qp_interface_errors
107: PROCEDURE mark_dup_line(p_request_id NUMBER,
108: p_orig_sys_header_ref VARCHAR2,
109: p_orig_sys_line_ref VARCHAR2)
110: IS

Line 125: SELECT qp_interface_errors_s.NEXTVAL

121:
122: fnd_message.set_name('QP', 'QP_DUPLICATE_LIST_LINES');
123: l_msg := fnd_message.Get;
124:
125: SELECT qp_interface_errors_s.NEXTVAL
126: INTO l_error_id
127: FROM dual;
128:
129: INSERT INTO qp_interface_errors(error_id, last_update_date, last_updated_by,

Line 129: INSERT INTO qp_interface_errors(error_id, last_update_date, last_updated_by,

125: SELECT qp_interface_errors_s.NEXTVAL
126: INTO l_error_id
127: FROM dual;
128:
129: INSERT INTO qp_interface_errors(error_id, last_update_date, last_updated_by,
130: creation_date, created_by, last_update_login, request_id,
131: program_application_id, program_id, program_update_date, entity_type,
132: table_name, column_name, orig_sys_header_ref, orig_sys_line_ref,
133: orig_sys_qualifier_ref, orig_sys_pricing_attr_ref, error_message)

Line 4379: INSERT INTO QP_INTERFACE_ERRORS

4375:
4376: FND_MESSAGE.SET_NAME('QP','QP_UNIQUE_PRIMARY_UOM');
4377: l_msg_txt:= FND_MESSAGE.GET;
4378:
4379: INSERT INTO QP_INTERFACE_ERRORS
4380: (error_id,last_update_date, last_updated_by, creation_date,
4381: created_by, last_update_login, request_id, program_application_id,
4382: program_id, program_update_date, entity_type, table_name, column_name,
4383: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 4386: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

4382: program_id, program_update_date, entity_type, table_name, column_name,
4383: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
4384: orig_sys_pricing_attr_ref, error_message)
4385: VALUES
4386: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
4387: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I),661,
4388: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
4389: p_pricing_attr_rec.orig_sys_header_ref(I),p_pricing_attr_rec.orig_sys_line_ref(I),null,
4390: null,l_msg_txt);

Line 4445: INSERT INTO QP_INTERFACE_ERRORS

4441:
4442: FND_MESSAGE.SET_NAME('QP','QP_UNIQUE_PRIMARY_UOM');
4443: l_msg_txt:= FND_MESSAGE.GET;
4444:
4445: INSERT INTO QP_INTERFACE_ERRORS
4446: (error_id,last_update_date, last_updated_by, creation_date,
4447: created_by, last_update_login, request_id, program_application_id,
4448: program_id, program_update_date, entity_type, table_name, column_name,
4449: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 4452: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

4448: program_id, program_update_date, entity_type, table_name, column_name,
4449: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
4450: orig_sys_pricing_attr_ref, error_message)
4451: VALUES
4452: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
4453: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I),661,
4454: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
4455: p_pricing_attr_rec.orig_sys_header_ref(I),p_pricing_attr_rec.orig_sys_line_ref(I),null,
4456: null,l_msg_txt);

Line 4566: INSERT INTO QP_INTERFACE_ERRORS

4562: AND orig_sys_header_ref = p_pricing_attr_rec.orig_sys_header_ref(I);
4563:
4564: l_msg_txt:= FND_MESSAGE.GET;
4565:
4566: INSERT INTO QP_INTERFACE_ERRORS
4567: (error_id,last_update_date, last_updated_by, creation_date,
4568: created_by, last_update_login, request_id, program_application_id,
4569: program_id, program_update_date, entity_type, table_name, column_name,
4570: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 4573: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

4569: program_id, program_update_date, entity_type, table_name, column_name,
4570: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
4571: orig_sys_pricing_attr_ref, error_message)
4572: VALUES
4573: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
4574: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I), 661,
4575: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
4576: p_pricing_attr_rec.orig_sys_header_ref(I),p_pricing_attr_rec.orig_sys_line_ref(I),null,
4577: null,l_msg_txt);

Line 4701: INSERT INTO QP_INTERFACE_ERRORS

4697:
4698: FND_MESSAGE.SET_NAME('QP', 'QP_PBK_CRSPNDNG_TO_FROM');
4699: l_msg_txt:= FND_MESSAGE.GET;
4700:
4701: INSERT INTO QP_INTERFACE_ERRORS
4702: (error_id,last_update_date, last_updated_by, creation_date,
4703: created_by, last_update_login, request_id, program_application_id,
4704: program_id, program_update_date, entity_type, table_name, column_name,
4705: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 4708: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

4704: program_id, program_update_date, entity_type, table_name, column_name,
4705: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
4706: orig_sys_pricing_attr_ref, error_message)
4707: VALUES
4708: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
4709: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I), 661,
4710: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
4711: p_pricing_attr_rec.orig_sys_header_ref(I),p_pricing_attr_rec.orig_sys_line_ref(I),null,
4712: null,l_msg_txt);

Line 4728: INSERT INTO QP_INTERFACE_ERRORS

4724:
4725: FND_MESSAGE.SET_NAME('QP', 'QP_PBK_CRSPNDNG_FROM_TO');
4726: l_msg_txt:= FND_MESSAGE.GET;
4727:
4728: INSERT INTO QP_INTERFACE_ERRORS
4729: (error_id,last_update_date, last_updated_by, creation_date,
4730: created_by, last_update_login, request_id, program_application_id,
4731: program_id, program_update_date, entity_type, table_name, column_name,
4732: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 4735: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

4731: program_id, program_update_date, entity_type, table_name, column_name,
4732: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
4733: orig_sys_pricing_attr_ref, error_message)
4734: VALUES
4735: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
4736: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I), 661,
4737: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
4738: p_pricing_attr_rec.orig_sys_header_ref(I),p_pricing_attr_rec.orig_sys_line_ref(I),null,
4739: null,l_msg_txt);

Line 4764: INSERT INTO QP_INTERFACE_ERRORS

4760:
4761: FND_MESSAGE.SET_NAME('QP', 'QP_PBK_ZERO_FROM');
4762: l_msg_txt:= FND_MESSAGE.GET;
4763:
4764: INSERT INTO QP_INTERFACE_ERRORS
4765: (error_id,last_update_date, last_updated_by, creation_date,
4766: created_by, last_update_login, request_id, program_application_id,
4767: program_id, program_update_date, entity_type, table_name, column_name,
4768: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 4771: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

4767: program_id, program_update_date, entity_type, table_name, column_name,
4768: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
4769: orig_sys_pricing_attr_ref, error_message)
4770: VALUES
4771: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
4772: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I), 661,
4773: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
4774: p_pricing_attr_rec.orig_sys_header_ref(I),p_pricing_attr_rec.orig_sys_line_ref(I),null,
4775: null,l_msg_txt);

Line 4805: INSERT INTO QP_INTERFACE_ERRORS

4801:
4802: FND_MESSAGE.SET_NAME('QP', 'QP_OVERLAP_PRICE_BREAK_RANGE');
4803: l_msg_txt:= FND_MESSAGE.GET;
4804:
4805: INSERT INTO QP_INTERFACE_ERRORS
4806: (error_id,last_update_date, last_updated_by, creation_date,
4807: created_by, last_update_login, request_id, program_application_id,
4808: program_id, program_update_date, entity_type, table_name, column_name,
4809: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 4812: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

4808: program_id, program_update_date, entity_type, table_name, column_name,
4809: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
4810: orig_sys_pricing_attr_ref, error_message)
4811: VALUES
4812: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
4813: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I), 661,
4814: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
4815: p_pricing_attr_rec.orig_sys_header_ref(I),p_pricing_attr_rec.orig_sys_line_ref(I),null,
4816: null,l_msg_txt);

Line 5100: INSERT INTO QP_INTERFACE_ERRORS

5096: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CURRENCY CODE');
5097: l_msg_txt := FND_MESSAGE.GET;
5098:
5099:
5100: INSERT INTO QP_INTERFACE_ERRORS
5101: (error_id,last_update_date, last_updated_by, creation_date,
5102: created_by, last_update_login, request_id, program_application_id,
5103: program_id, program_update_date, entity_type, table_name, column_name,
5104: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 5107: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5103: program_id, program_update_date, entity_type, table_name, column_name,
5104: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
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

Line 5131: INSERT INTO QP_INTERFACE_ERRORS

5127: l_msg_txt := FND_MESSAGE.GET;
5128:
5129: --Bug# 5412029 START RAVI
5130: --Check if the frieght terms are valid
5131: INSERT INTO QP_INTERFACE_ERRORS
5132: (error_id,last_update_date, last_updated_by, creation_date,
5133: created_by, last_update_login, request_id, program_application_id,
5134: program_id, program_update_date, entity_type, table_name, column_name,
5135: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 5138: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5134: program_id, program_update_date, entity_type, table_name, column_name,
5135: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
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

Line 5156: INSERT INTO QP_INTERFACE_ERRORS

5152: AND freight_terms = qpih.freight_terms
5153: AND sysdate BETWEEN nvl(start_date_active, sysdate)
5154: AND nvl(end_date_active, sysdate));
5155:
5156: INSERT INTO QP_INTERFACE_ERRORS
5157: (error_id,last_update_date, last_updated_by, creation_date,
5158: created_by, last_update_login, request_id, program_application_id,
5159: program_id, program_update_date, entity_type, table_name, column_name,
5160: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 5163: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5159: program_id, program_update_date, entity_type, table_name, column_name,
5160: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
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

Line 5179: INSERT INTO QP_INTERFACE_ERRORS

5175: WHERE freight_terms = qpih.freight_terms
5176: AND sysdate BETWEEN nvl(start_date_active, sysdate)
5177: AND nvl(end_date_active, sysdate));
5178:
5179: INSERT INTO QP_INTERFACE_ERRORS
5180: (error_id,last_update_date, last_updated_by, creation_date,
5181: created_by, last_update_login, request_id, program_application_id,
5182: program_id, program_update_date, entity_type, table_name, column_name,
5183: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 5186: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5182: program_id, program_update_date, entity_type, table_name, column_name,
5183: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
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

Line 5210: INSERT INTO QP_INTERFACE_ERRORS

5206: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
5207: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','LIST TYPE CODE');
5208: l_msg_txt := FND_MESSAGE.GET;
5209:
5210: INSERT INTO QP_INTERFACE_ERRORS
5211: (error_id,last_update_date, last_updated_by, creation_date,
5212: created_by, last_update_login, request_id, program_application_id,
5213: program_id, program_update_date, entity_type, table_name, column_name,
5214: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 5217: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5213: program_id, program_update_date, entity_type, table_name, column_name,
5214: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
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

Line 5239: INSERT INTO QP_INTERFACE_ERRORS

5235: l_msg_txt := FND_MESSAGE.GET;
5236:
5237: --Bug# 5412029 START RAVI
5238: --Check if the ship method are valid
5239: INSERT INTO QP_INTERFACE_ERRORS
5240: (error_id,last_update_date, last_updated_by, creation_date,
5241: created_by, last_update_login, request_id, program_application_id,
5242: program_id, program_update_date, entity_type, table_name, column_name,
5243: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 5246: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5242: program_id, program_update_date, entity_type, table_name, column_name,
5243: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
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

Line 5265: INSERT INTO QP_INTERFACE_ERRORS

5261: AND MEANING = qpih.ship_method
5262: AND sysdate BETWEEN nvl(start_date_active, sysdate)
5263: AND nvl(end_date_active, sysdate) );
5264:
5265: INSERT INTO QP_INTERFACE_ERRORS
5266: (error_id,last_update_date, last_updated_by, creation_date,
5267: created_by, last_update_login, request_id, program_application_id,
5268: program_id, program_update_date, entity_type, table_name, column_name,
5269: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 5272: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5268: program_id, program_update_date, entity_type, table_name, column_name,
5269: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
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

Line 5290: INSERT INTO QP_INTERFACE_ERRORS

5286: AND LOOKUP_CODE = qpih.ship_method_code
5287: AND sysdate BETWEEN nvl(start_date_active, sysdate)
5288: AND nvl(end_date_active, sysdate) );
5289:
5290: INSERT INTO QP_INTERFACE_ERRORS
5291: (error_id,last_update_date, last_updated_by, creation_date,
5292: created_by, last_update_login, request_id, program_application_id,
5293: program_id, program_update_date, entity_type, table_name, column_name,
5294: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 5297: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5293: program_id, program_update_date, entity_type, table_name, column_name,
5294: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
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

Line 5322: INSERT INTO QP_INTERFACE_ERRORS

5318: l_msg_txt := FND_MESSAGE.GET;
5319:
5320: --Bug# 5412029 START RAVI
5321: --Check if the payment terms are valid
5322: INSERT INTO QP_INTERFACE_ERRORS
5323: (error_id,last_update_date, last_updated_by, creation_date,
5324: created_by, last_update_login, request_id, program_application_id,
5325: program_id, program_update_date, entity_type, table_name, column_name,
5326: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 5329: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5325: program_id, program_update_date, entity_type, table_name, column_name,
5326: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
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

Line 5349: INSERT INTO QP_INTERFACE_ERRORS

5345: AND name = qpih.terms
5346: AND sysdate BETWEEN nvl(start_date_active, sysdate)
5347: AND nvl(end_date_active, sysdate) );
5348:
5349: INSERT INTO QP_INTERFACE_ERRORS
5350: (error_id,last_update_date, last_updated_by, creation_date,
5351: created_by, last_update_login, request_id, program_application_id,
5352: program_id, program_update_date, entity_type, table_name, column_name,
5353: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 5356: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5352: program_id, program_update_date, entity_type, table_name, column_name,
5353: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
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

Line 5374: INSERT INTO QP_INTERFACE_ERRORS

5370: WHERE TERM_ID = qpih.terms_id
5371: AND sysdate BETWEEN nvl(start_date_active, sysdate)
5372: AND nvl(end_date_active, sysdate) );
5373:
5374: INSERT INTO QP_INTERFACE_ERRORS
5375: (error_id,last_update_date, last_updated_by, creation_date,
5376: created_by, last_update_login, request_id, program_application_id,
5377: program_id, program_update_date, entity_type, table_name, column_name,
5378: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 5381: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5377: program_id, program_update_date, entity_type, table_name, column_name,
5378: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
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

Line 5412: INSERT INTO QP_INTERFACE_ERRORS

5408: /**
5409: Currency Header and Header ID validation
5410: **/
5411:
5412: INSERT INTO QP_INTERFACE_ERRORS
5413: (error_id,last_update_date, last_updated_by, creation_date,
5414: created_by, last_update_login, request_id, program_application_id,
5415: program_id, program_update_date, entity_type, table_name, column_name,
5416: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 5419: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5415: program_id, program_update_date, entity_type, table_name, column_name,
5416: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
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

Line 5438: INSERT INTO QP_INTERFACE_ERRORS

5434: AND qpclt.currency_header_id = qpclb.currency_header_id
5435: AND qpclt.language = nvl(qpih.language,'US')
5436: AND qpclt.name = qpih.currency_header);
5437:
5438: INSERT INTO QP_INTERFACE_ERRORS
5439: (error_id,last_update_date, last_updated_by, creation_date,
5440: created_by, last_update_login, request_id, program_application_id,
5441: program_id, program_update_date, entity_type, table_name, column_name,
5442: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 5445: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5441: program_id, program_update_date, entity_type, table_name, column_name,
5442: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
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

Line 5463: INSERT INTO QP_INTERFACE_ERRORS

5459: AND qpclt.currency_header_id = qpclb.currency_header_id
5460: AND qpclt.language = nvl(qpih.language,'US')
5461: AND qpclt.name = qpih.currency_header);
5462:
5463: INSERT INTO QP_INTERFACE_ERRORS
5464: (error_id,last_update_date, last_updated_by, creation_date,
5465: created_by, last_update_login, request_id, program_application_id,
5466: program_id, program_update_date, entity_type, table_name, column_name,
5467: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 5470: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5466: program_id, program_update_date, entity_type, table_name, column_name,
5467: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
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

Line 5492: INSERT INTO QP_INTERFACE_ERRORS

5488: fnd_message.set_name('QP', 'QP_ATTRIBUTE_REQUIRED');
5489: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'NAME');
5490: l_msg_txt := FND_MESSAGE.GET;
5491:
5492: INSERT INTO QP_INTERFACE_ERRORS
5493: (error_id,last_update_date, last_updated_by, creation_date,
5494: created_by, last_update_login, request_id, program_application_id,
5495: program_id, program_update_date, entity_type, table_name, column_name,
5496: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 5499: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5495: program_id, program_update_date, entity_type, table_name, column_name,
5496: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
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

Line 5517: INSERT INTO QP_INTERFACE_ERRORS

5513: l_msg_txt := FND_MESSAGE.GET;
5514:
5515: qp_bulk_loader_pub.write_log('Name check in TL table '||userenv('LANG')||' '||to_char(p_request_id));
5516:
5517: INSERT INTO QP_INTERFACE_ERRORS
5518: (error_id,last_update_date, last_updated_by, creation_date,
5519: created_by, last_update_login, request_id, program_application_id,
5520: program_id, program_update_date, entity_type, table_name, column_name,
5521: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 5524: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5520: program_id, program_update_date, entity_type, table_name, column_name,
5521: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
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

Line 5543: INSERT INTO QP_INTERFACE_ERRORS

5539:
5540: fnd_message.set_name('QP', 'SO_OTHER_NAME_ALREADY_IN_USE');
5541: l_msg_txt := FND_MESSAGE.GET;
5542:
5543: INSERT INTO QP_INTERFACE_ERRORS
5544: (error_id,last_update_date, last_updated_by, creation_date,
5545: created_by, last_update_login, request_id, program_application_id,
5546: program_id, program_update_date, entity_type, table_name, column_name,
5547: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 5550: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5546: program_id, program_update_date, entity_type, table_name, column_name,
5547: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
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

Line 5572: INSERT INTO QP_INTERFACE_ERRORS

5568: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
5569: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Pricing Transaction Entity');
5570: l_msg_txt := FND_MESSAGE.GET;
5571:
5572: INSERT INTO QP_INTERFACE_ERRORS
5573: (error_id,last_update_date, last_updated_by, creation_date,
5574: created_by, last_update_login, request_id, program_application_id,
5575: program_id, program_update_date, entity_type, table_name, column_name,
5576: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 5579: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5575: program_id, program_update_date, entity_type, table_name, column_name,
5576: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
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

Line 5599: INSERT INTO QP_INTERFACE_ERRORS

5595: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
5596: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Source System Code');
5597: l_msg_txt := FND_MESSAGE.GET;
5598:
5599: INSERT INTO QP_INTERFACE_ERRORS
5600: (error_id,last_update_date, last_updated_by, creation_date,
5601: created_by, last_update_login, request_id, program_application_id,
5602: program_id, program_update_date, entity_type, table_name, column_name,
5603: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 5606: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5602: program_id, program_update_date, entity_type, table_name, column_name,
5603: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
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

Line 5621: INSERT INTO QP_INTERFACE_ERRORS

5617: WHERE lookup_type = 'SOURCE_SYSTEM'
5618: AND lookup_code = qpih.source_system_code);
5619:
5620: -- Bug 5208365 RAVI
5621: INSERT INTO QP_INTERFACE_ERRORS
5622: (error_id,last_update_date, last_updated_by, creation_date,
5623: created_by, last_update_login, request_id, program_application_id,
5624: program_id, program_update_date, entity_type, table_name, column_name,
5625: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 5628: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5624: program_id, program_update_date, entity_type, table_name, column_name,
5625: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
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

Line 5647: INSERT INTO QP_INTERFACE_ERRORS

5643: FND_MESSAGE.SET_NAME('FND','FND_MO_ORG_INVALID');
5644: --FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Source System Code');
5645: l_msg_txt := FND_MESSAGE.GET;
5646:
5647: INSERT INTO QP_INTERFACE_ERRORS
5648: (error_id,last_update_date, last_updated_by, creation_date,
5649: created_by, last_update_login, request_id, program_application_id,
5650: program_id, program_update_date, entity_type, table_name, column_name,
5651: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 5654: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5650: program_id, program_update_date, entity_type, table_name, column_name,
5651: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
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

Line 5671: INSERT INTO QP_INTERFACE_ERRORS

5667:
5668: FND_MESSAGE.SET_NAME('QP','QP_ROUNDING_FACTOR_NO_UPDATE');
5669: l_msg_txt := FND_MESSAGE.GET;
5670:
5671: INSERT INTO QP_INTERFACE_ERRORS
5672: (error_id,last_update_date, last_updated_by, creation_date,
5673: created_by, last_update_login, request_id, program_application_id,
5674: program_id, program_update_date, entity_type, table_name, column_name,
5675: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 5678: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5674: program_id, program_update_date, entity_type, table_name, column_name,
5675: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
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

Line 5701: INSERT INTO QP_INTERFACE_ERRORS

5697:
5698: /*fnd_message.set_name('QP', 'QP_HDR_REF_MULTIPLE_UPDATE');
5699: l_msg_txt := FND_MESSAGE.GET;
5700:
5701: INSERT INTO QP_INTERFACE_ERRORS
5702: (error_id,last_update_date, last_updated_by, creation_date,
5703: created_by, last_update_login, request_id, program_application_id,
5704: program_id, program_update_date, entity_type, table_name, column_name,
5705: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 5708: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5704: program_id, program_update_date, entity_type, table_name, column_name,
5705: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_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

Line 5753: INSERT INTO QP_INTERFACE_ERRORS

5749: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
5750: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','COMPARISON OPERATOR');
5751: l_msg_txt := FND_MESSAGE.GET;
5752:
5753: INSERT INTO QP_INTERFACE_ERRORS
5754: (error_id,last_update_date, last_updated_by, creation_date,
5755: created_by, last_update_login, request_id, program_application_id,
5756: program_id, program_update_date, entity_type, table_name, column_name,
5757: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 5760: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5756: program_id, program_update_date, entity_type, table_name, column_name,
5757: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5758: orig_sys_pricing_attr_ref, error_message)
5759: SELECT
5760: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5761: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,
5762: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', 'COMPARISON_OPERATOR',
5763: qpiq.orig_sys_header_ref,null,qpiq.orig_sys_qualifier_ref,null, l_msg_txt
5764: FROM QP_INTERFACE_QUALIFIERS qpiq

Line 5780: INSERT INTO QP_INTERFACE_ERRORS

5776: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
5777: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ORIG SYS HEADER REF');
5778: l_msg_txt := FND_MESSAGE.GET;
5779:
5780: INSERT INTO QP_INTERFACE_ERRORS
5781: (error_id,last_update_date, last_updated_by, creation_date,
5782: created_by, last_update_login, request_id, program_application_id,
5783: program_id, program_update_date, entity_type, table_name, column_name,
5784: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 5787: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5783: program_id, program_update_date, entity_type, table_name, column_name,
5784: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5785: orig_sys_pricing_attr_ref,error_message)
5786: SELECT
5787: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5788: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,
5789: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', 'ORIG_SYS_HEADER_REF',
5790: qpiq.orig_sys_header_ref,null,qpiq.orig_sys_qualifier_ref,null,l_msg_txt
5791: FROM QP_INTERFACE_QUALIFIERS qpiq

Line 5812: INSERT INTO QP_INTERFACE_ERRORS

5808: FND_MESSAGE.SET_NAME('QP','QP_QUAL_NA_BASIC');
5809: --Qualifiers not allowed in Basic Pricing
5810: l_msg_txt := FND_MESSAGE.GET;
5811:
5812: INSERT INTO QP_INTERFACE_ERRORS
5813: (error_id,last_update_date, last_updated_by, creation_date,
5814: created_by, last_update_login, request_id, program_application_id,
5815: program_id, program_update_date, entity_type, table_name,
5816: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 5819: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5815: program_id, program_update_date, entity_type, table_name,
5816: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5817: orig_sys_pricing_attr_ref, error_message)
5818: SELECT
5819: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5820: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,
5821: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS',
5822: qpiq.orig_sys_header_ref,null,qpiq.orig_sys_qualifier_ref,null, l_msg_txt
5823: FROM QP_INTERFACE_QUALIFIERS qpiq

Line 5838: INSERT INTO QP_INTERFACE_ERRORS

5834: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'QUALIFIER CONTEXT');
5835:
5836: l_msg_txt := FND_MESSAGE.GET;
5837:
5838: INSERT INTO QP_INTERFACE_ERRORS
5839: (error_id,last_update_date, last_updated_by, creation_date,
5840: created_by, last_update_login, request_id, program_application_id,
5841: program_id, program_update_date, entity_type, table_name,
5842: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 5845: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5841: program_id, program_update_date, entity_type, table_name,
5842: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5843: orig_sys_pricing_attr_ref, error_message)
5844: SELECT
5845: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5846: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,
5847: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS',
5848: qpiq.orig_sys_header_ref,null,qpiq.orig_sys_qualifier_ref,null, l_msg_txt
5849: FROM QP_INTERFACE_QUALIFIERS qpiq

Line 5863: INSERT INTO QP_INTERFACE_ERRORS

5859: l_msg_txt := FND_MESSAGE.GET;
5860:
5861: --Bug# 5456164 START RAVI
5862: --Validate qualifier attribute
5863: INSERT INTO QP_INTERFACE_ERRORS
5864: (error_id,last_update_date, last_updated_by, creation_date,
5865: created_by, last_update_login, request_id, program_application_id,
5866: program_id, program_update_date, entity_type, table_name, column_name,
5867: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 5870: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5866: program_id, program_update_date, entity_type, table_name, column_name,
5867: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5868: orig_sys_pricing_attr_ref,error_message)
5869: SELECT
5870: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5871: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,
5872: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', 'QUALIFIER_ATTRIBUTE',
5873: qpiq.orig_sys_header_ref,null,qpiq.orig_sys_qualifier_ref,null,l_msg_txt
5874: FROM QP_INTERFACE_QUALIFIERS qpiq

Line 5897: INSERT INTO QP_INTERFACE_ERRORS

5893: AND f.pte_code = l_pte_code
5894: -- AND f.segment_level NOT IN ('LINE') bug#12710486
5895: AND qpiq.rowid = b.rowid);
5896:
5897: INSERT INTO QP_INTERFACE_ERRORS
5898: (error_id,last_update_date, last_updated_by, creation_date,
5899: created_by, last_update_login, request_id, program_application_id,
5900: program_id, program_update_date, entity_type, table_name, column_name,
5901: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 5904: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5900: program_id, program_update_date, entity_type, table_name, column_name,
5901: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5902: orig_sys_pricing_attr_ref,error_message)
5903: SELECT
5904: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5905: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,
5906: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', 'QUALIFIER_ATTRIBUTE',
5907: qpiq.orig_sys_header_ref,null,qpiq.orig_sys_qualifier_ref,null,l_msg_txt
5908: FROM QP_INTERFACE_QUALIFIERS qpiq

Line 5930: INSERT INTO QP_INTERFACE_ERRORS

5926: AND f.pte_code = l_pte_code
5927: -- AND f.segment_level NOT IN ('LINE') bug#12710486
5928: AND qpiq.rowid = b.rowid);
5929:
5930: INSERT INTO QP_INTERFACE_ERRORS
5931: (error_id,last_update_date, last_updated_by, creation_date,
5932: created_by, last_update_login, request_id, program_application_id,
5933: program_id, program_update_date, entity_type, table_name, column_name,
5934: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 5937: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5933: program_id, program_update_date, entity_type, table_name, column_name,
5934: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5935: orig_sys_pricing_attr_ref,error_message)
5936: SELECT
5937: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5938: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,
5939: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', 'QUALIFIER_ATTRIBUTE',
5940: qpiq.orig_sys_header_ref,null,qpiq.orig_sys_qualifier_ref,null,l_msg_txt
5941: FROM QP_INTERFACE_QUALIFIERS qpiq

Line 6013: INSERT INTO QP_INTERFACE_ERRORS

6009: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
6010: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','LIST_LINE_TYPE_CODE');
6011: l_msg_txt := FND_MESSAGE.GET;
6012:
6013: INSERT INTO QP_INTERFACE_ERRORS
6014: (error_id,last_update_date, last_updated_by, creation_date,
6015: created_by, last_update_login, request_id, program_application_id,
6016: program_id, program_update_date, entity_type, table_name, column_name,
6017: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 6020: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

6016: program_id, program_update_date, entity_type, table_name, column_name,
6017: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6018: orig_sys_pricing_attr_ref,error_message)
6019: SELECT
6020: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6021: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6022: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'LIST_LINE_TYPE_CODE',
6023: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null, l_msg_txt
6024: FROM QP_INTERFACE_LIST_LINES qpil

Line 6040: INSERT INTO QP_INTERFACE_ERRORS

6036: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
6037: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ARITHMETIC_OPERATOR 5');
6038: l_msg_txt := FND_MESSAGE.GET;
6039:
6040: INSERT INTO QP_INTERFACE_ERRORS
6041: (error_id,last_update_date, last_updated_by, creation_date,
6042: created_by, last_update_login, request_id, program_application_id,
6043: program_id, program_update_date, entity_type, table_name, column_name,
6044: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 6047: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

6043: program_id, program_update_date, entity_type, table_name, column_name,
6044: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6045: orig_sys_pricing_attr_ref,error_message)
6046: SELECT
6047: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6048: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6049: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'ARITHMETIC_OPERATOR',
6050: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6051: FROM QP_INTERFACE_LIST_LINES qpil

Line 6066: INSERT INTO QP_INTERFACE_ERRORS

6062: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
6063: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','PRICE_BREAK_TYPE_CODE');
6064: l_msg_txt := FND_MESSAGE.GET;
6065:
6066: INSERT INTO QP_INTERFACE_ERRORS
6067: (error_id,last_update_date, last_updated_by, creation_date,
6068: created_by, last_update_login, request_id, program_application_id,
6069: program_id, program_update_date, entity_type, table_name, column_name,
6070: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 6073: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

6069: program_id, program_update_date, entity_type, table_name, column_name,
6070: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6071: orig_sys_pricing_attr_ref,error_message)
6072: SELECT
6073: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6074: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6075: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRICE_BREAK_TYPE_CODE',
6076: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6077: FROM QP_INTERFACE_LIST_LINES qpil

Line 6094: INSERT INTO QP_INTERFACE_ERRORS

6090: l_msg_txt := FND_MESSAGE.GET;
6091:
6092: -- Bug# 5412045
6093: -- Validate UOM for a category line
6094: INSERT INTO QP_INTERFACE_ERRORS
6095: (error_id,last_update_date, last_updated_by, creation_date,
6096: created_by, last_update_login, request_id, program_application_id,
6097: program_id, program_update_date, entity_type, table_name, column_name,
6098: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 6101: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

6097: program_id, program_update_date, entity_type, table_name, column_name,
6098: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6099: orig_sys_pricing_attr_ref,error_message)
6100: SELECT /*+ index(qpip QP_INTERFACE_PRCNG_ATTRIBS_N4) */
6101: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6102: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6103: NULL,NULL, 'PRL', 'QP_INTERFACE_PRICING_ATTRIBS', 'PRODUCT_UOM_CODE',
6104: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6105: qpip.orig_sys_pricing_attr_ref, l_msg_txt

Line 6180: INSERT INTO QP_INTERFACE_ERRORS

6176:
6177:
6178: -- Bug# 5412045
6179: -- Validate UOM for a category line
6180: INSERT INTO QP_INTERFACE_ERRORS
6181: (error_id,last_update_date, last_updated_by, creation_date,
6182: created_by, last_update_login, request_id, program_application_id,
6183: program_id, program_update_date, entity_type, table_name, column_name,
6184: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 6187: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

6183: program_id, program_update_date, entity_type, table_name, column_name,
6184: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6185: orig_sys_pricing_attr_ref,error_message)
6186: SELECT
6187: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6188: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6189: NULL,NULL, 'PRL', 'QP_INTERFACE_PRICING_ATTRIBS', 'PRODUCT_UOM_CODE',
6190: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6191: qpip.orig_sys_pricing_attr_ref, l_msg_txt

Line 6223: INSERT INTO QP_INTERFACE_ERRORS

6219: **/
6220: FND_MESSAGE.SET_NAME('QP','QP_STATIC_OR_DYNAMIC_FORMULA');
6221: l_msg_txt := FND_MESSAGE.GET;
6222:
6223: INSERT INTO QP_INTERFACE_ERRORS
6224: (error_id,last_update_date, last_updated_by, creation_date,
6225: created_by, last_update_login, request_id, program_application_id,
6226: program_id, program_update_date, entity_type, table_name, column_name,
6227: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 6230: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

6226: program_id, program_update_date, entity_type, table_name, column_name,
6227: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6228: orig_sys_pricing_attr_ref,error_message)
6229: SELECT
6230: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6231: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6232: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRICE_BY_AND_GENERATE_FORMULA_ID',
6233: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6234: FROM QP_INTERFACE_LIST_LINES qpil

Line 6252: INSERT INTO QP_INTERFACE_ERRORS

6248:
6249: FND_MESSAGE.SET_NAME('QP','QP_PRC_FOR_NAME_ID_INCMPTBLE');
6250: l_msg_txt := FND_MESSAGE.GET;
6251:
6252: INSERT INTO QP_INTERFACE_ERRORS
6253: (error_id,last_update_date, last_updated_by, creation_date,
6254: created_by, last_update_login, request_id, program_application_id,
6255: program_id, program_update_date, entity_type, table_name, column_name,
6256: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 6259: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

6255: program_id, program_update_date, entity_type, table_name, column_name,
6256: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6257: orig_sys_pricing_attr_ref,error_message)
6258: SELECT
6259: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6260: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6261: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRICE_BY_FORMULA_ID',
6262: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6263: FROM QP_INTERFACE_LIST_LINES qpil

Line 6275: INSERT INTO QP_INTERFACE_ERRORS

6271: FROM qp_price_formulas_vl
6272: WHERE price_formula_id = qpil.price_by_formula_id
6273: AND name = qpil.price_by_formula);
6274:
6275: INSERT INTO QP_INTERFACE_ERRORS
6276: (error_id,last_update_date, last_updated_by, creation_date,
6277: created_by, last_update_login, request_id, program_application_id,
6278: program_id, program_update_date, entity_type, table_name, column_name,
6279: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 6282: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

6278: program_id, program_update_date, entity_type, table_name, column_name,
6279: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6280: orig_sys_pricing_attr_ref,error_message)
6281: SELECT
6282: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6283: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6284: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRICE_BY_FORMULA_ID',
6285: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6286: FROM QP_INTERFACE_LIST_LINES qpil

Line 6296: INSERT INTO QP_INTERFACE_ERRORS

6292: AND NOT EXISTS ( SELECT name
6293: FROM qp_price_formulas_vl
6294: WHERE price_formula_id = qpil.price_by_formula_id);
6295:
6296: INSERT INTO QP_INTERFACE_ERRORS
6297: (error_id,last_update_date, last_updated_by, creation_date,
6298: created_by, last_update_login, request_id, program_application_id,
6299: program_id, program_update_date, entity_type, table_name, column_name,
6300: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 6303: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

6299: program_id, program_update_date, entity_type, table_name, column_name,
6300: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6301: orig_sys_pricing_attr_ref,error_message)
6302: SELECT
6303: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6304: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6305: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRICE_BY_FORMULA_ID',
6306: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6307: FROM QP_INTERFACE_LIST_LINES qpil

Line 6326: INSERT INTO QP_INTERFACE_ERRORS

6322:
6323: FND_MESSAGE.SET_NAME('QP','QP_GEN_FOR_NAME_ID_INCMPTBLE');
6324: l_msg_txt := FND_MESSAGE.GET;
6325:
6326: INSERT INTO QP_INTERFACE_ERRORS
6327: (error_id,last_update_date, last_updated_by, creation_date,
6328: created_by, last_update_login, request_id, program_application_id,
6329: program_id, program_update_date, entity_type, table_name, column_name,
6330: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 6333: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

6329: program_id, program_update_date, entity_type, table_name, column_name,
6330: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6331: orig_sys_pricing_attr_ref,error_message)
6332: SELECT
6333: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6334: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6335: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'GENERATE_USING_FORMULA_ID',
6336: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6337: FROM QP_INTERFACE_LIST_LINES qpil

Line 6358: INSERT INTO QP_INTERFACE_ERRORS

6354: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_FORMULA_FOR_PL');
6355: --l_msg_txt := FND_MESSAGE.GET;
6356: -- Bug# 5236656 RAVI END
6357:
6358: INSERT INTO QP_INTERFACE_ERRORS
6359: (error_id,last_update_date, last_updated_by, creation_date,
6360: created_by, last_update_login, request_id, program_application_id,
6361: program_id, program_update_date, entity_type, table_name, column_name,
6362: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 6365: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

6361: program_id, program_update_date, entity_type, table_name, column_name,
6362: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6363: orig_sys_pricing_attr_ref,error_message)
6364: SELECT
6365: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6366: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6367: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'GENERATE_USING_FORMULA_ID',
6368: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6369: FROM QP_INTERFACE_LIST_LINES qpil

Line 6379: INSERT INTO QP_INTERFACE_ERRORS

6375: AND NOT EXISTS ( SELECT name
6376: FROM qp_price_formulas_vl
6377: WHERE price_formula_id = qpil.generate_using_formula_id);
6378:
6379: INSERT INTO QP_INTERFACE_ERRORS
6380: (error_id,last_update_date, last_updated_by, creation_date,
6381: created_by, last_update_login, request_id, program_application_id,
6382: program_id, program_update_date, entity_type, table_name, column_name,
6383: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 6386: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

6382: program_id, program_update_date, entity_type, table_name, column_name,
6383: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6384: orig_sys_pricing_attr_ref,error_message)
6385: SELECT
6386: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6387: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6388: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'GENERATE_USING_FORMULA_ID',
6389: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6390: FROM QP_INTERFACE_LIST_LINES qpil

Line 6414: INSERT INTO QP_INTERFACE_ERRORS

6410: FND_MESSAGE.SET_NAME('QP','QP_PBH_NA_BASIC');
6411: --Price Break Header not allowed in Basic Pricing
6412: l_msg_txt := FND_MESSAGE.GET;
6413:
6414: INSERT INTO QP_INTERFACE_ERRORS
6415: (error_id,last_update_date, last_updated_by, creation_date,
6416: created_by, last_update_login, request_id, program_application_id,
6417: program_id, program_update_date, entity_type, table_name,
6418: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 6421: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

6417: program_id, program_update_date, entity_type, table_name,
6418: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6419: orig_sys_pricing_attr_ref,error_message)
6420: SELECT
6421: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6422: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6423: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES',
6424: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6425: FROM QP_INTERFACE_LIST_LINES qpil

Line 6439: INSERT INTO QP_INTERFACE_ERRORS

6435: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
6436: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Product Attribute ');
6437: l_msg_txt := FND_MESSAGE.GET;
6438:
6439: INSERT INTO QP_INTERFACE_ERRORS
6440: (error_id,last_update_date, last_updated_by, creation_date,
6441: created_by, last_update_login, request_id, program_application_id,
6442: program_id, program_update_date, entity_type, table_name, column_name,
6443: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 6446: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

6442: program_id, program_update_date, entity_type, table_name, column_name,
6443: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6444: orig_sys_pricing_attr_ref,error_message)
6445: SELECT
6446: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6447: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6448: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6449: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6450: qpip.orig_sys_pricing_attr_ref, l_msg_txt

Line 6488: INSERT INTO QP_INTERFACE_ERRORS

6484: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
6485: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Product Attribute ');
6486: l_msg_txt := FND_MESSAGE.GET;
6487:
6488: INSERT INTO QP_INTERFACE_ERRORS
6489: (error_id,last_update_date, last_updated_by, creation_date,
6490: created_by, last_update_login, request_id, program_application_id,
6491: program_id, program_update_date, entity_type, table_name, column_name,
6492: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 6495: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

6491: program_id, program_update_date, entity_type, table_name, column_name,
6492: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6493: orig_sys_pricing_attr_ref,error_message)
6494: SELECT
6495: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6496: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6497: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6498: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6499: qpip.orig_sys_pricing_attr_ref, l_msg_txt

Line 6521: INSERT INTO QP_INTERFACE_ERRORS

6517: AND e.segment_id = f.segment_id
6518: AND f.pte_code = l_pte_code
6519: AND qpip.rowid = b.rowid);
6520:
6521: INSERT INTO QP_INTERFACE_ERRORS
6522: (error_id,last_update_date, last_updated_by, creation_date,
6523: created_by, last_update_login, request_id, program_application_id,
6524: program_id, program_update_date, entity_type, table_name, column_name,
6525: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 6528: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

6524: program_id, program_update_date, entity_type, table_name, column_name,
6525: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6526: orig_sys_pricing_attr_ref,error_message)
6527: SELECT
6528: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6529: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6530: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6531: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6532: qpip.orig_sys_pricing_attr_ref, l_msg_txt

Line 6553: INSERT INTO QP_INTERFACE_ERRORS

6549: AND e.segment_id = f.segment_id
6550: AND f.pte_code = l_pte_code
6551: AND qpip.rowid = b.rowid);
6552:
6553: INSERT INTO QP_INTERFACE_ERRORS
6554: (error_id,last_update_date, last_updated_by, creation_date,
6555: created_by, last_update_login, request_id, program_application_id,
6556: program_id, program_update_date, entity_type, table_name, column_name,
6557: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 6560: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

6556: program_id, program_update_date, entity_type, table_name, column_name,
6557: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6558: orig_sys_pricing_attr_ref,error_message)
6559: SELECT
6560: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6561: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6562: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6563: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6564: qpip.orig_sys_pricing_attr_ref, l_msg_txt

Line 6590: INSERT INTO QP_INTERFACE_ERRORS

6586: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
6587: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Pricing Attribute ');
6588: l_msg_txt := FND_MESSAGE.GET;
6589:
6590: INSERT INTO QP_INTERFACE_ERRORS
6591: (error_id,last_update_date, last_updated_by, creation_date,
6592: created_by, last_update_login, request_id, program_application_id,
6593: program_id, program_update_date, entity_type, table_name, column_name,
6594: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 6597: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

6593: program_id, program_update_date, entity_type, table_name, column_name,
6594: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6595: orig_sys_pricing_attr_ref,error_message)
6596: SELECT
6597: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6598: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6599: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6600: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6601: qpip.orig_sys_pricing_attr_ref, l_msg_txt

Line 6623: INSERT INTO QP_INTERFACE_ERRORS

6619: AND e.segment_id = f.segment_id
6620: AND f.pte_code = l_pte_code
6621: AND qpip.rowid = b.rowid);
6622:
6623: INSERT INTO QP_INTERFACE_ERRORS
6624: (error_id,last_update_date, last_updated_by, creation_date,
6625: created_by, last_update_login, request_id, program_application_id,
6626: program_id, program_update_date, entity_type, table_name, column_name,
6627: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 6630: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

6626: program_id, program_update_date, entity_type, table_name, column_name,
6627: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6628: orig_sys_pricing_attr_ref,error_message)
6629: SELECT
6630: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6631: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6632: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6633: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6634: qpip.orig_sys_pricing_attr_ref, l_msg_txt

Line 6655: INSERT INTO QP_INTERFACE_ERRORS

6651: AND e.segment_id = f.segment_id
6652: AND f.pte_code = l_pte_code
6653: AND qpip.rowid = b.rowid);
6654:
6655: INSERT INTO QP_INTERFACE_ERRORS
6656: (error_id,last_update_date, last_updated_by, creation_date,
6657: created_by, last_update_login, request_id, program_application_id,
6658: program_id, program_update_date, entity_type, table_name, column_name,
6659: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,

Line 6662: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

6658: program_id, program_update_date, entity_type, table_name, column_name,
6659: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6660: orig_sys_pricing_attr_ref,error_message)
6661: SELECT
6662: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6663: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6664: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6665: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6666: qpip.orig_sys_pricing_attr_ref, l_msg_txt

Line 6713: FROM qp_interface_errors e

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

Line 6725: FROM qp_interface_errors e

6721: SET process_status_flag = NULL --'E'
6722: WHERE q.request_id =p_request_id
6723: AND EXISTS
6724: (SELECT orig_sys_qualifier_ref
6725: FROM qp_interface_errors e
6726: WHERE e.orig_sys_qualifier_ref = q.orig_sys_qualifier_ref
6727: AND e.orig_sys_header_ref = q.orig_sys_header_ref
6728: AND e.table_name ='QP_INTERFACE_QUALIFIERS'
6729: AND e.request_id = p_request_id);

Line 6738: FROM qp_interface_errors e

6734: SET process_status_flag = NULL --'E'
6735: WHERE l.request_id =p_request_id
6736: AND EXISTS
6737: (SELECT orig_sys_line_ref
6738: FROM qp_interface_errors e
6739: WHERE e.orig_sys_line_ref = l.orig_sys_line_ref
6740: AND e.orig_sys_header_ref = l.orig_sys_header_ref
6741: AND table_name ='QP_INTERFACE_LIST_LINES'
6742: AND e.request_id = p_request_id );

Line 6751: FROM qp_interface_errors e

6747: SET process_status_flag = NULL --'E'
6748: WHERE a.request_id =p_request_id
6749: AND EXISTS
6750: (SELECT orig_sys_pricing_attr_ref
6751: FROM qp_interface_errors e
6752: WHERE e.orig_sys_line_ref = a.orig_sys_line_ref
6753: AND e.orig_sys_header_ref = a.orig_sys_header_ref
6754: AND e.orig_sys_pricing_attr_ref = a.orig_sys_pricing_attr_ref
6755: AND table_name ='QP_INTERFACE_PRICING_ATTRIBS'