DBA Data[Home] [Help]

APPS.QP_BULK_VALIDATE dependencies on FND_GLOBAL

Line 183: (l_error_id, sysdate ,FND_GLOBAL.USER_ID, sysdate,

179: program_id, program_update_date, entity_type, table_name, column_name,
180: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
181: orig_sys_pricing_attr_ref, error_message)
182: VALUES
183: (l_error_id, sysdate ,FND_GLOBAL.USER_ID, sysdate,
184: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 661,
185: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
186: p_orig_sys_header_ref,p_orig_sys_line_ref1,null,null,l_msg);
187: return FALSE;

Line 184: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 661,

180: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
181: orig_sys_pricing_attr_ref, error_message)
182: VALUES
183: (l_error_id, sysdate ,FND_GLOBAL.USER_ID, sysdate,
184: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 661,
185: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
186: p_orig_sys_header_ref,p_orig_sys_line_ref1,null,null,l_msg);
187: return FALSE;
188: END IF;

Line 3762: IF fnd_global.resp_appl_id=178 OR fnd_global.resp_appl_id=201

3758: IF p_pricing_attr_rec.product_attribute_context(I)='ITEM' AND
3759: p_pricing_attr_rec.product_attribute(I)= 'PRICING_ATTRIBUTE1'
3760: THEN
3761: l_pa_count :=0;
3762: IF fnd_global.resp_appl_id=178 OR fnd_global.resp_appl_id=201
3763: THEN --Check if item is purchasing enabled
3764: Begin
3765: select count(*) into l_pa_count
3766: from qp_interface_pricing_attribs qipa, mtl_system_items msi

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

4396: program_id, program_update_date, entity_type, table_name, column_name,
4397: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
4398: orig_sys_pricing_attr_ref, error_message)
4399: VALUES
4400: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
4401: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I),661,
4402: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
4403: p_pricing_attr_rec.orig_sys_header_ref(I),p_pricing_attr_rec.orig_sys_line_ref(I),null,
4404: null,l_msg_txt);

Line 4401: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I),661,

4397: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
4398: orig_sys_pricing_attr_ref, error_message)
4399: VALUES
4400: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
4401: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I),661,
4402: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
4403: p_pricing_attr_rec.orig_sys_header_ref(I),p_pricing_attr_rec.orig_sys_line_ref(I),null,
4404: null,l_msg_txt);
4405:

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

4460: program_id, program_update_date, entity_type, table_name, column_name,
4461: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
4462: orig_sys_pricing_attr_ref, error_message)
4463: VALUES
4464: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
4465: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I),661,
4466: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
4467: p_pricing_attr_rec.orig_sys_header_ref(I),p_pricing_attr_rec.orig_sys_line_ref(I),null,
4468: null,l_msg_txt);

Line 4465: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I),661,

4461: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
4462: orig_sys_pricing_attr_ref, error_message)
4463: VALUES
4464: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
4465: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I),661,
4466: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
4467: p_pricing_attr_rec.orig_sys_header_ref(I),p_pricing_attr_rec.orig_sys_line_ref(I),null,
4468: null,l_msg_txt);
4469:

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

4581: program_id, program_update_date, entity_type, table_name, column_name,
4582: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
4583: orig_sys_pricing_attr_ref, error_message)
4584: VALUES
4585: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
4586: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I), 661,
4587: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
4588: p_pricing_attr_rec.orig_sys_header_ref(I),p_pricing_attr_rec.orig_sys_line_ref(I),null,
4589: null,l_msg_txt);

Line 4586: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I), 661,

4582: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
4583: orig_sys_pricing_attr_ref, error_message)
4584: VALUES
4585: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
4586: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I), 661,
4587: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
4588: p_pricing_attr_rec.orig_sys_header_ref(I),p_pricing_attr_rec.orig_sys_line_ref(I),null,
4589: null,l_msg_txt);
4590:

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

4716: program_id, program_update_date, entity_type, table_name, column_name,
4717: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
4718: orig_sys_pricing_attr_ref, error_message)
4719: VALUES
4720: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
4721: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I), 661,
4722: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
4723: p_pricing_attr_rec.orig_sys_header_ref(I),p_pricing_attr_rec.orig_sys_line_ref(I),null,
4724: null,l_msg_txt);

Line 4721: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I), 661,

4717: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
4718: orig_sys_pricing_attr_ref, error_message)
4719: VALUES
4720: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
4721: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I), 661,
4722: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
4723: p_pricing_attr_rec.orig_sys_header_ref(I),p_pricing_attr_rec.orig_sys_line_ref(I),null,
4724: null,l_msg_txt);
4725: END IF;

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

4743: program_id, program_update_date, entity_type, table_name, column_name,
4744: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
4745: orig_sys_pricing_attr_ref, error_message)
4746: VALUES
4747: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
4748: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I), 661,
4749: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
4750: p_pricing_attr_rec.orig_sys_header_ref(I),p_pricing_attr_rec.orig_sys_line_ref(I),null,
4751: null,l_msg_txt);

Line 4748: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I), 661,

4744: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
4745: orig_sys_pricing_attr_ref, error_message)
4746: VALUES
4747: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
4748: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I), 661,
4749: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
4750: p_pricing_attr_rec.orig_sys_header_ref(I),p_pricing_attr_rec.orig_sys_line_ref(I),null,
4751: null,l_msg_txt);
4752: END IF;

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

4779: program_id, program_update_date, entity_type, table_name, column_name,
4780: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
4781: orig_sys_pricing_attr_ref, error_message)
4782: VALUES
4783: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
4784: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I), 661,
4785: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
4786: p_pricing_attr_rec.orig_sys_header_ref(I),p_pricing_attr_rec.orig_sys_line_ref(I),null,
4787: null,l_msg_txt);

Line 4784: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I), 661,

4780: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
4781: orig_sys_pricing_attr_ref, error_message)
4782: VALUES
4783: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
4784: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I), 661,
4785: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
4786: p_pricing_attr_rec.orig_sys_header_ref(I),p_pricing_attr_rec.orig_sys_line_ref(I),null,
4787: null,l_msg_txt);
4788: END IF;

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

4820: program_id, program_update_date, entity_type, table_name, column_name,
4821: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
4822: orig_sys_pricing_attr_ref, error_message)
4823: VALUES
4824: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
4825: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I), 661,
4826: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
4827: p_pricing_attr_rec.orig_sys_header_ref(I),p_pricing_attr_rec.orig_sys_line_ref(I),null,
4828: null,l_msg_txt);

Line 4825: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I), 661,

4821: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
4822: orig_sys_pricing_attr_ref, error_message)
4823: VALUES
4824: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
4825: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I), 661,
4826: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
4827: p_pricing_attr_rec.orig_sys_header_ref(I),p_pricing_attr_rec.orig_sys_line_ref(I),null,
4828: null,l_msg_txt);
4829:

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

5115: program_id, program_update_date, entity_type, table_name, column_name,
5116: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5117: orig_sys_pricing_attr_ref, error_message)
5118: SELECT
5119: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5120: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5121: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'CURRENCY_CODE',
5122: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5123: FROM QP_INTERFACE_LIST_HEADERS qpih

Line 5120: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,

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

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

5146: program_id, program_update_date, entity_type, table_name, column_name,
5147: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5148: orig_sys_pricing_attr_ref, error_message)
5149: SELECT
5150: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5151: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5152: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FREIGHT TERMS',
5153: qpih.orig_sys_header_ref,null,null,null, l_msg_txt
5154: FROM QP_INTERFACE_LIST_HEADERS qpih

Line 5151: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,

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

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

5171: program_id, program_update_date, entity_type, table_name, column_name,
5172: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5173: orig_sys_pricing_attr_ref, error_message)
5174: SELECT
5175: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5176: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5177: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FREIGHT TERMS',
5178: qpih.orig_sys_header_ref,null,null,null, l_msg_txt
5179: FROM QP_INTERFACE_LIST_HEADERS qpih

Line 5176: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,

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

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

5194: program_id, program_update_date, entity_type, table_name, column_name,
5195: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5196: orig_sys_pricing_attr_ref, error_message)
5197: SELECT
5198: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5199: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5200: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FREIGHT TERMS',
5201: qpih.orig_sys_header_ref,null,null,null, l_msg_txt
5202: FROM QP_INTERFACE_LIST_HEADERS qpih

Line 5199: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,

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

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

5225: program_id, program_update_date, entity_type, table_name, column_name,
5226: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5227: orig_sys_pricing_attr_ref, error_message)
5228: SELECT
5229: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5230: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5231: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'LIST_TYPE_CODE',
5232: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5233: FROM QP_INTERFACE_LIST_HEADERS qpih

Line 5230: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,

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

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

5254: program_id, program_update_date, entity_type, table_name, column_name,
5255: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5256: orig_sys_pricing_attr_ref, error_message)
5257: SELECT
5258: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5259: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5260: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FRIEGHT CARRIER',
5261: qpih.orig_sys_header_ref, null,null,null,l_msg_txt
5262: FROM QP_INTERFACE_LIST_HEADERS qpih

Line 5259: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,

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

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

5280: program_id, program_update_date, entity_type, table_name, column_name,
5281: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5282: orig_sys_pricing_attr_ref, error_message)
5283: SELECT
5284: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5285: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5286: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FRIEGHT CARRIER',
5287: qpih.orig_sys_header_ref, null,null,null,l_msg_txt
5288: FROM QP_INTERFACE_LIST_HEADERS qpih

Line 5285: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,

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

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

5305: program_id, program_update_date, entity_type, table_name, column_name,
5306: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5307: orig_sys_pricing_attr_ref, error_message)
5308: SELECT
5309: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5310: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5311: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FRIEGHT CARRIER',
5312: qpih.orig_sys_header_ref, null,null,null,l_msg_txt
5313: FROM QP_INTERFACE_LIST_HEADERS qpih

Line 5310: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,

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

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

5337: program_id, program_update_date, entity_type, table_name, column_name,
5338: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5339: orig_sys_pricing_attr_ref, error_message)
5340: SELECT
5341: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5342: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5343: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'PAYMENT TERMS',
5344: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5345: FROM QP_INTERFACE_LIST_HEADERS qpih

Line 5342: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,

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

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

5364: program_id, program_update_date, entity_type, table_name, column_name,
5365: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5366: orig_sys_pricing_attr_ref, error_message)
5367: SELECT
5368: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5369: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5370: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'PAYMENT TERMS',
5371: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5372: FROM QP_INTERFACE_LIST_HEADERS qpih

Line 5369: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,

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

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

5389: program_id, program_update_date, entity_type, table_name, column_name,
5390: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5391: orig_sys_pricing_attr_ref, error_message)
5392: SELECT
5393: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5394: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5395: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'PAYMENT TERMS',
5396: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5397: FROM QP_INTERFACE_LIST_HEADERS qpih

Line 5394: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,

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

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

5427: program_id, program_update_date, entity_type, table_name, column_name,
5428: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5429: orig_sys_pricing_attr_ref, error_message)
5430: SELECT
5431: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5432: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5433: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'CURRENCY_HEADER',
5434: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5435: FROM QP_INTERFACE_LIST_HEADERS qpih

Line 5432: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,

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

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

5453: program_id, program_update_date, entity_type, table_name, column_name,
5454: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5455: orig_sys_pricing_attr_ref, error_message)
5456: SELECT
5457: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5458: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5459: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'CURRENCY_HEADER',
5460: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5461: FROM QP_INTERFACE_LIST_HEADERS qpih

Line 5458: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,

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

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

5478: program_id, program_update_date, entity_type, table_name, column_name,
5479: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5480: orig_sys_pricing_attr_ref, error_message)
5481: SELECT
5482: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5483: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5484: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'CURRENCY_HEADER',
5485: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5486: FROM QP_INTERFACE_LIST_HEADERS qpih

Line 5483: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,

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

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

5507: program_id, program_update_date, entity_type, table_name, column_name,
5508: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5509: orig_sys_pricing_attr_ref, error_message)
5510: SELECT
5511: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5512: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5513: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',
5514: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5515: FROM QP_INTERFACE_LIST_HEADERS qpih

Line 5512: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,

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

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

5532: program_id, program_update_date, entity_type, table_name, column_name,
5533: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5534: orig_sys_pricing_attr_ref, error_message)
5535: SELECT
5536: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5537: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5538: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',
5539: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5540: FROM QP_INTERFACE_LIST_HEADERS qpih

Line 5537: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,

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

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

5558: program_id, program_update_date, entity_type, table_name, column_name,
5559: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5560: orig_sys_pricing_attr_ref, error_message)
5561: SELECT
5562: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5563: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5564: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',
5565: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5566: FROM QP_INTERFACE_LIST_HEADERS qpih

Line 5563: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,

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

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

5587: program_id, program_update_date, entity_type, table_name, column_name,
5588: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5589: orig_sys_pricing_attr_ref, error_message)
5590: SELECT
5591: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5592: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5593: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'pte_code',
5594: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5595: FROM QP_INTERFACE_LIST_HEADERS qpih

Line 5592: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,

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

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

5614: program_id, program_update_date, entity_type, table_name, column_name,
5615: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5616: orig_sys_pricing_attr_ref, error_message)
5617: SELECT
5618: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5619: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5620: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',
5621: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5622: FROM QP_INTERFACE_LIST_HEADERS qpih

Line 5619: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,

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

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

5636: program_id, program_update_date, entity_type, table_name, column_name,
5637: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5638: orig_sys_pricing_attr_ref, error_message)
5639: SELECT
5640: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5641: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5642: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',
5643: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5644: FROM QP_INTERFACE_LIST_HEADERS qpih

Line 5641: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,

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

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

5662: program_id, program_update_date, entity_type, table_name, column_name,
5663: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5664: orig_sys_pricing_attr_ref, error_message)
5665: SELECT
5666: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5667: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5668: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',
5669: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5670: FROM QP_INTERFACE_LIST_HEADERS qpih

Line 5667: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,

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

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

5686: program_id, program_update_date, entity_type, table_name, column_name,
5687: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5688: orig_sys_pricing_attr_ref, error_message)
5689: SELECT
5690: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5691: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5692: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'ROUNDING_FACTOR',
5693: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5694: FROM QP_INTERFACE_LIST_HEADERS qpih

Line 5691: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,

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

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

5716: program_id, program_update_date, entity_type, table_name, column_name,
5717: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5718: orig_sys_pricing_attr_ref, error_message)
5719: SELECT
5720: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5721: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5722: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'ORIG_SYS_HEADER_REF',
5723: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5724: FROM QP_INTERFACE_LIST_HEADERS qpih

Line 5721: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,

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

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

5768: program_id, program_update_date, entity_type, table_name, column_name,
5769: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5770: orig_sys_pricing_attr_ref, error_message)
5771: SELECT
5772: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5773: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,
5774: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', 'COMPARISON_OPERATOR',
5775: qpiq.orig_sys_header_ref,null,qpiq.orig_sys_qualifier_ref,null, l_msg_txt
5776: FROM QP_INTERFACE_QUALIFIERS qpiq

Line 5773: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,

5769: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5770: orig_sys_pricing_attr_ref, error_message)
5771: SELECT
5772: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5773: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,
5774: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', 'COMPARISON_OPERATOR',
5775: qpiq.orig_sys_header_ref,null,qpiq.orig_sys_qualifier_ref,null, l_msg_txt
5776: FROM QP_INTERFACE_QUALIFIERS qpiq
5777: WHERE qpiq.request_id = p_request_id

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

5795: program_id, program_update_date, entity_type, table_name, column_name,
5796: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5797: orig_sys_pricing_attr_ref,error_message)
5798: SELECT
5799: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5800: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,
5801: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', 'ORIG_SYS_HEADER_REF',
5802: qpiq.orig_sys_header_ref,null,qpiq.orig_sys_qualifier_ref,null,l_msg_txt
5803: FROM QP_INTERFACE_QUALIFIERS qpiq

Line 5800: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,

5796: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5797: orig_sys_pricing_attr_ref,error_message)
5798: SELECT
5799: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5800: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,
5801: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', 'ORIG_SYS_HEADER_REF',
5802: qpiq.orig_sys_header_ref,null,qpiq.orig_sys_qualifier_ref,null,l_msg_txt
5803: FROM QP_INTERFACE_QUALIFIERS qpiq
5804: WHERE qpiq.request_id = p_request_id

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

5827: program_id, program_update_date, entity_type, table_name,
5828: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5829: orig_sys_pricing_attr_ref, error_message)
5830: SELECT
5831: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5832: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,
5833: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS',
5834: qpiq.orig_sys_header_ref,null,qpiq.orig_sys_qualifier_ref,null, l_msg_txt
5835: FROM QP_INTERFACE_QUALIFIERS qpiq

Line 5832: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,

5828: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5829: orig_sys_pricing_attr_ref, error_message)
5830: SELECT
5831: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5832: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,
5833: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS',
5834: qpiq.orig_sys_header_ref,null,qpiq.orig_sys_qualifier_ref,null, l_msg_txt
5835: FROM QP_INTERFACE_QUALIFIERS qpiq
5836: WHERE qpiq.request_id = p_request_id

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

5853: program_id, program_update_date, entity_type, table_name,
5854: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5855: orig_sys_pricing_attr_ref, error_message)
5856: SELECT
5857: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5858: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,
5859: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS',
5860: qpiq.orig_sys_header_ref,null,qpiq.orig_sys_qualifier_ref,null, l_msg_txt
5861: FROM QP_INTERFACE_QUALIFIERS qpiq

Line 5858: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,

5854: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5855: orig_sys_pricing_attr_ref, error_message)
5856: SELECT
5857: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5858: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,
5859: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS',
5860: qpiq.orig_sys_header_ref,null,qpiq.orig_sys_qualifier_ref,null, l_msg_txt
5861: FROM QP_INTERFACE_QUALIFIERS qpiq
5862: WHERE qpiq.request_id = p_request_id

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

5878: program_id, program_update_date, entity_type, table_name, column_name,
5879: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5880: orig_sys_pricing_attr_ref,error_message)
5881: SELECT
5882: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5883: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,
5884: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', 'QUALIFIER_ATTRIBUTE',
5885: qpiq.orig_sys_header_ref,null,qpiq.orig_sys_qualifier_ref,null,l_msg_txt
5886: FROM QP_INTERFACE_QUALIFIERS qpiq

Line 5883: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,

5879: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5880: orig_sys_pricing_attr_ref,error_message)
5881: SELECT
5882: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5883: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,
5884: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', 'QUALIFIER_ATTRIBUTE',
5885: qpiq.orig_sys_header_ref,null,qpiq.orig_sys_qualifier_ref,null,l_msg_txt
5886: FROM QP_INTERFACE_QUALIFIERS qpiq
5887: WHERE qpiq.request_id = p_request_id

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

5912: program_id, program_update_date, entity_type, table_name, column_name,
5913: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5914: orig_sys_pricing_attr_ref,error_message)
5915: SELECT
5916: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5917: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,
5918: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', 'QUALIFIER_ATTRIBUTE',
5919: qpiq.orig_sys_header_ref,null,qpiq.orig_sys_qualifier_ref,null,l_msg_txt
5920: FROM QP_INTERFACE_QUALIFIERS qpiq

Line 5917: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,

5913: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5914: orig_sys_pricing_attr_ref,error_message)
5915: SELECT
5916: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5917: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,
5918: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', 'QUALIFIER_ATTRIBUTE',
5919: qpiq.orig_sys_header_ref,null,qpiq.orig_sys_qualifier_ref,null,l_msg_txt
5920: FROM QP_INTERFACE_QUALIFIERS qpiq
5921: WHERE qpiq.request_id = p_request_id

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

5945: program_id, program_update_date, entity_type, table_name, column_name,
5946: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5947: orig_sys_pricing_attr_ref,error_message)
5948: SELECT
5949: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5950: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,
5951: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', 'QUALIFIER_ATTRIBUTE',
5952: qpiq.orig_sys_header_ref,null,qpiq.orig_sys_qualifier_ref,null,l_msg_txt
5953: FROM QP_INTERFACE_QUALIFIERS qpiq

Line 5950: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,

5946: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5947: orig_sys_pricing_attr_ref,error_message)
5948: SELECT
5949: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5950: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,
5951: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', 'QUALIFIER_ATTRIBUTE',
5952: qpiq.orig_sys_header_ref,null,qpiq.orig_sys_qualifier_ref,null,l_msg_txt
5953: FROM QP_INTERFACE_QUALIFIERS qpiq
5954: WHERE qpiq.request_id = p_request_id

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

6028: program_id, program_update_date, entity_type, table_name, column_name,
6029: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6030: orig_sys_pricing_attr_ref,error_message)
6031: SELECT
6032: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6033: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6034: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'LIST_LINE_TYPE_CODE',
6035: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null, l_msg_txt
6036: FROM QP_INTERFACE_LIST_LINES qpil

Line 6033: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,

6029: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6030: orig_sys_pricing_attr_ref,error_message)
6031: SELECT
6032: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6033: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6034: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'LIST_LINE_TYPE_CODE',
6035: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null, l_msg_txt
6036: FROM QP_INTERFACE_LIST_LINES qpil
6037: WHERE qpil.request_id = p_request_id

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

6055: program_id, program_update_date, entity_type, table_name, column_name,
6056: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6057: orig_sys_pricing_attr_ref,error_message)
6058: SELECT
6059: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6060: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6061: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'ARITHMETIC_OPERATOR',
6062: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6063: FROM QP_INTERFACE_LIST_LINES qpil

Line 6060: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,

6056: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6057: orig_sys_pricing_attr_ref,error_message)
6058: SELECT
6059: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6060: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6061: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'ARITHMETIC_OPERATOR',
6062: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6063: FROM QP_INTERFACE_LIST_LINES qpil
6064: WHERE qpil.request_id = p_request_id

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

6081: program_id, program_update_date, entity_type, table_name, column_name,
6082: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6083: orig_sys_pricing_attr_ref,error_message)
6084: SELECT
6085: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6086: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6087: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRICE_BREAK_TYPE_CODE',
6088: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6089: FROM QP_INTERFACE_LIST_LINES qpil

Line 6086: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,

6082: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6083: orig_sys_pricing_attr_ref,error_message)
6084: SELECT
6085: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6086: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6087: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRICE_BREAK_TYPE_CODE',
6088: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6089: FROM QP_INTERFACE_LIST_LINES qpil
6090: WHERE qpil.request_id = p_request_id

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

6109: program_id, program_update_date, entity_type, table_name, column_name,
6110: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6111: orig_sys_pricing_attr_ref,error_message)
6112: SELECT /*+ index(qpip QP_INTERFACE_PRCNG_ATTRIBS_N4) */
6113: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6114: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6115: NULL,NULL, 'PRL', 'QP_INTERFACE_PRICING_ATTRIBS', 'PRODUCT_UOM_CODE',
6116: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6117: qpip.orig_sys_pricing_attr_ref, l_msg_txt

Line 6114: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,

6110: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6111: orig_sys_pricing_attr_ref,error_message)
6112: SELECT /*+ index(qpip QP_INTERFACE_PRCNG_ATTRIBS_N4) */
6113: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6114: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6115: NULL,NULL, 'PRL', 'QP_INTERFACE_PRICING_ATTRIBS', 'PRODUCT_UOM_CODE',
6116: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6117: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6118: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip, QP_LIST_HEADERS_B qplh

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

6195: program_id, program_update_date, entity_type, table_name, column_name,
6196: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6197: orig_sys_pricing_attr_ref,error_message)
6198: SELECT
6199: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6200: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6201: NULL,NULL, 'PRL', 'QP_INTERFACE_PRICING_ATTRIBS', 'PRODUCT_UOM_CODE',
6202: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6203: qpip.orig_sys_pricing_attr_ref, l_msg_txt

Line 6200: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,

6196: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6197: orig_sys_pricing_attr_ref,error_message)
6198: SELECT
6199: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6200: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6201: NULL,NULL, 'PRL', 'QP_INTERFACE_PRICING_ATTRIBS', 'PRODUCT_UOM_CODE',
6202: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6203: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6204: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip, QP_LIST_HEADERS_B qplh

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

6238: program_id, program_update_date, entity_type, table_name, column_name,
6239: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6240: orig_sys_pricing_attr_ref,error_message)
6241: SELECT
6242: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6243: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6244: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRICE_BY_AND_GENERATE_FORMULA_ID',
6245: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6246: FROM QP_INTERFACE_LIST_LINES qpil

Line 6243: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,

6239: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6240: orig_sys_pricing_attr_ref,error_message)
6241: SELECT
6242: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6243: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6244: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRICE_BY_AND_GENERATE_FORMULA_ID',
6245: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6246: FROM QP_INTERFACE_LIST_LINES qpil
6247: WHERE qpil.request_id = p_request_id

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

6267: program_id, program_update_date, entity_type, table_name, column_name,
6268: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6269: orig_sys_pricing_attr_ref,error_message)
6270: SELECT
6271: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6272: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6273: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRICE_BY_FORMULA_ID',
6274: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6275: FROM QP_INTERFACE_LIST_LINES qpil

Line 6272: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,

6268: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6269: orig_sys_pricing_attr_ref,error_message)
6270: SELECT
6271: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6272: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6273: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRICE_BY_FORMULA_ID',
6274: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6275: FROM QP_INTERFACE_LIST_LINES qpil
6276: WHERE qpil.request_id = p_request_id

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

6290: program_id, program_update_date, entity_type, table_name, column_name,
6291: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6292: orig_sys_pricing_attr_ref,error_message)
6293: SELECT
6294: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6295: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6296: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRICE_BY_FORMULA_ID',
6297: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6298: FROM QP_INTERFACE_LIST_LINES qpil

Line 6295: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,

6291: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6292: orig_sys_pricing_attr_ref,error_message)
6293: SELECT
6294: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6295: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6296: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRICE_BY_FORMULA_ID',
6297: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6298: FROM QP_INTERFACE_LIST_LINES qpil
6299: WHERE qpil.request_id = p_request_id

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

6311: program_id, program_update_date, entity_type, table_name, column_name,
6312: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6313: orig_sys_pricing_attr_ref,error_message)
6314: SELECT
6315: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6316: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6317: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRICE_BY_FORMULA_ID',
6318: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6319: FROM QP_INTERFACE_LIST_LINES qpil

Line 6316: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,

6312: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6313: orig_sys_pricing_attr_ref,error_message)
6314: SELECT
6315: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6316: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6317: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRICE_BY_FORMULA_ID',
6318: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6319: FROM QP_INTERFACE_LIST_LINES qpil
6320: WHERE qpil.request_id = p_request_id

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

6341: program_id, program_update_date, entity_type, table_name, column_name,
6342: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6343: orig_sys_pricing_attr_ref,error_message)
6344: SELECT
6345: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6346: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6347: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'GENERATE_USING_FORMULA_ID',
6348: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6349: FROM QP_INTERFACE_LIST_LINES qpil

Line 6346: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,

6342: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6343: orig_sys_pricing_attr_ref,error_message)
6344: SELECT
6345: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6346: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6347: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'GENERATE_USING_FORMULA_ID',
6348: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6349: FROM QP_INTERFACE_LIST_LINES qpil
6350: WHERE qpil.request_id = p_request_id

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

6373: program_id, program_update_date, entity_type, table_name, column_name,
6374: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6375: orig_sys_pricing_attr_ref,error_message)
6376: SELECT
6377: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6378: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6379: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'GENERATE_USING_FORMULA_ID',
6380: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6381: FROM QP_INTERFACE_LIST_LINES qpil

Line 6378: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,

6374: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6375: orig_sys_pricing_attr_ref,error_message)
6376: SELECT
6377: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6378: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6379: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'GENERATE_USING_FORMULA_ID',
6380: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6381: FROM QP_INTERFACE_LIST_LINES qpil
6382: WHERE qpil.request_id = p_request_id

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

6394: program_id, program_update_date, entity_type, table_name, column_name,
6395: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6396: orig_sys_pricing_attr_ref,error_message)
6397: SELECT
6398: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6399: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6400: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'GENERATE_USING_FORMULA_ID',
6401: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6402: FROM QP_INTERFACE_LIST_LINES qpil

Line 6399: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,

6395: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6396: orig_sys_pricing_attr_ref,error_message)
6397: SELECT
6398: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6399: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6400: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'GENERATE_USING_FORMULA_ID',
6401: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6402: FROM QP_INTERFACE_LIST_LINES qpil
6403: WHERE qpil.request_id = p_request_id

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

6429: program_id, program_update_date, entity_type, table_name,
6430: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6431: orig_sys_pricing_attr_ref,error_message)
6432: SELECT
6433: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6434: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6435: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES',
6436: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6437: FROM QP_INTERFACE_LIST_LINES qpil

Line 6434: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,

6430: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6431: orig_sys_pricing_attr_ref,error_message)
6432: SELECT
6433: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6434: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6435: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES',
6436: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6437: FROM QP_INTERFACE_LIST_LINES qpil
6438: WHERE qpil.request_id = p_request_id

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

6454: program_id, program_update_date, entity_type, table_name, column_name,
6455: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6456: orig_sys_pricing_attr_ref,error_message)
6457: SELECT
6458: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6459: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6460: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6461: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6462: qpip.orig_sys_pricing_attr_ref, l_msg_txt

Line 6459: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,

6455: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6456: orig_sys_pricing_attr_ref,error_message)
6457: SELECT
6458: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6459: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6460: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6461: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6462: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6463: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip

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

6503: program_id, program_update_date, entity_type, table_name, column_name,
6504: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6505: orig_sys_pricing_attr_ref,error_message)
6506: SELECT
6507: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6508: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6509: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6510: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6511: qpip.orig_sys_pricing_attr_ref, l_msg_txt

Line 6508: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,

6504: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6505: orig_sys_pricing_attr_ref,error_message)
6506: SELECT
6507: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6508: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6509: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6510: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6511: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6512: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip

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

6536: program_id, program_update_date, entity_type, table_name, column_name,
6537: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6538: orig_sys_pricing_attr_ref,error_message)
6539: SELECT
6540: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6541: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6542: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6543: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6544: qpip.orig_sys_pricing_attr_ref, l_msg_txt

Line 6541: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,

6537: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6538: orig_sys_pricing_attr_ref,error_message)
6539: SELECT
6540: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6541: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6542: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6543: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6544: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6545: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip

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

6568: program_id, program_update_date, entity_type, table_name, column_name,
6569: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6570: orig_sys_pricing_attr_ref,error_message)
6571: SELECT
6572: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6573: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6574: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6575: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6576: qpip.orig_sys_pricing_attr_ref, l_msg_txt

Line 6573: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,

6569: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6570: orig_sys_pricing_attr_ref,error_message)
6571: SELECT
6572: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6573: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6574: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6575: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6576: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6577: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip

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

6605: program_id, program_update_date, entity_type, table_name, column_name,
6606: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6607: orig_sys_pricing_attr_ref,error_message)
6608: SELECT
6609: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6610: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6611: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6612: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6613: qpip.orig_sys_pricing_attr_ref, l_msg_txt

Line 6610: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,

6606: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6607: orig_sys_pricing_attr_ref,error_message)
6608: SELECT
6609: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6610: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6611: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6612: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6613: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6614: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip

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

6638: program_id, program_update_date, entity_type, table_name, column_name,
6639: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6640: orig_sys_pricing_attr_ref,error_message)
6641: SELECT
6642: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6643: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6644: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6645: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6646: qpip.orig_sys_pricing_attr_ref, l_msg_txt

Line 6643: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,

6639: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6640: orig_sys_pricing_attr_ref,error_message)
6641: SELECT
6642: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6643: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6644: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6645: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6646: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6647: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip

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

6670: program_id, program_update_date, entity_type, table_name, column_name,
6671: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6672: orig_sys_pricing_attr_ref,error_message)
6673: SELECT
6674: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6675: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6676: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6677: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6678: qpip.orig_sys_pricing_attr_ref, l_msg_txt

Line 6675: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,

6671: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6672: orig_sys_pricing_attr_ref,error_message)
6673: SELECT
6674: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6675: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6676: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6677: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6678: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6679: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip