The following lines contain the word 'select', 'insert', 'update' or 'delete':
Update qp_interface_list_headers ih
set (currency_header_id, process_status_flag, attribute_status)=
(select c.currency_header_id,
decode(c.currency_header_id, null, null, 'P'),
decode(c.currency_header_id, null, ih.attribute_status||'001', ih.attribute_status)
from qp_currency_lists_vl c,
qp_interface_list_headers iih
where iih.currency_header = c.name(+)
and iih.currency_code = c.base_currency_code(+)
and ih.rowid = iih.rowid
)
Where ih.request_id = p_request_id
and ih.process_status_flag = 'P' --IS NOT NULL
and ih.currency_header is not null
--Bug# 5412029
--Don't do conversion if Value is G_NULL_CHAR
and ih.currency_header <> QP_BULK_LOADER_PUB.G_NULL_CHAR
and ih.currency_header_id is null
and ih.interface_action_code in ('INSERT','UPDATE');
Update qp_interface_list_headers ih
set (freight_terms_code, process_status_flag, attribute_status)=
(select c.freight_terms_code,
decode(c.freight_terms_code, null, null, 'P'),
decode(c.freight_terms_code, null, ih.attribute_status||'002', ih.attribute_status)
from OE_FRGHT_TERMS_ACTIVE_V c,
qp_interface_list_headers iih
where iih.freight_terms = c.freight_terms(+)
and sysdate between nvl(c.start_date_active, sysdate)
and nvl(c.end_date_active, sysdate)
and ih.rowid = iih.rowid
)
Where ih.request_id = p_request_id
and ih.process_status_flag = 'P' --IS NOT NULL
and ih.freight_terms is not null
--Bug# 5412029
--Don't do conversion if Value is G_NULL_CHAR
and ih.freight_terms <> QP_BULK_LOADER_PUB.G_NULL_CHAR
and ih.freight_terms_code is null
and ih.interface_action_code in ('INSERT','UPDATE');
Update qp_interface_list_headers ih
set (ship_method_code, process_status_flag, attribute_status)=
(select c.lookup_code,
decode(c.lookup_code, null, null, 'P'),
decode(c.lookup_code, null, ih.attribute_status||'003', ih.attribute_status)
from OE_SHIP_METHODS_V c,
qp_interface_list_headers iih
where iih.ship_method = c.meaning(+)
and c.lookup_type(+) = 'SHIP_METHOD'
and sysdate between nvl(c.start_date_active, sysdate)
and nvl(c.end_date_active, sysdate)
and ih.rowid = iih.rowid
)
Where ih.request_id = p_request_id
and ih.process_status_flag = 'P' --IS NOT NULL
and ih.ship_method is not null
--Bug# 5412029
--Don't do conversion if Value is G_NULL_CHAR
and ih.ship_method <> QP_BULK_LOADER_PUB.G_NULL_CHAR
and ih.ship_method_code is null
and ih.interface_action_code in ('INSERT','UPDATE');
Update qp_interface_list_headers ih
set (terms_id, process_status_flag, attribute_status)=
(select c.term_id,
decode(c.term_id, null, null, 'P'),
decode(c.term_id, null, ih.attribute_status||'004', ih.attribute_status)
from RA_TERMS c,
qp_interface_list_headers iih
where iih.terms = c.name(+)
and sysdate between nvl(c.start_date_active, sysdate)
and nvl(c.end_date_active, sysdate)
and ih.rowid = iih.rowid
)
Where ih.request_id = p_request_id
and ih.process_status_flag = 'P' --IS NOT NULL
and ih.terms is not null
--Bug# 5412029
--Don't do conversion if Value is G_NULL_CHAR
and ih.terms <> QP_BULK_LOADER_PUB.G_NULL_CHAR
and ih.terms_id is null
and ih.interface_action_code in ('INSERT','UPDATE');
UPDATE QP_INTERFACE_QUALIFIERS a
SET(CREATED_FROM_RULE_ID, PROCESS_STATUS_FLAG, ATTRIBUTE_STATUS)=
(SELECT b.QUALIFIER_RULE_ID,
DECODE(b.QUALIFIER_RULE_ID, NULL, null, 'P'),
DECODE(b.QUALIFIER_RULE_ID,NULL, a.ATTRIBUTE_STATUS||'001', a.ATTRIBUTE_STATUS)
FROM QP_QUALIFIER_RULES b, QP_INTERFACE_QUALIFIERS c
WHERE c.CREATED_FROM_RULE = b.NAME(+)
AND a.rowid = c.rowid
)
WHERE a.REQUEST_ID = P_REQUEST_ID
and a.process_status_flag = 'P' --IS NOT NULL
AND a.CREATED_FROM_RULE_ID IS NULL
--Bug# 5456164
--Don't do conversion if Value is G_NULL_CHAR
AND a.CREATED_FROM_RULE <> QP_BULK_LOADER_PUB.G_NULL_CHAR
AND a.CREATED_FROM_RULE IS NOT NULL
AND a.INTERFACE_ACTION_CODE IN ('INSERT','UPDATE');
UPDATE QP_INTERFACE_QUALIFIERS a
SET(QUALIFIER_RULE_ID, PROCESS_STATUS_FLAG, ATTRIBUTE_STATUS)=
(SELECT b.QUALIFIER_RULE_ID,
DECODE(b.QUALIFIER_RULE_ID, NULL, null, 'P'),
DECODE(b.QUALIFIER_RULE_ID,NULL, a.ATTRIBUTE_STATUS||'002', a.ATTRIBUTE_STATUS)
FROM QP_QUALIFIER_RULES b, QP_INTERFACE_QUALIFIERS c
WHERE c.QUALIFIER_RULE = b.NAME(+)
AND a.rowid = c.rowid
)
WHERE a.REQUEST_ID = P_REQUEST_ID
and a.process_status_flag = 'P' --IS NOT NULL
AND a.QUALIFIER_RULE_ID IS NULL
--Bug# 5456164
--Don't do conversion if Value is G_NULL_CHAR
AND a.QUALIFIER_RULE <> QP_BULK_LOADER_PUB.G_NULL_CHAR
AND a.QUALIFIER_RULE IS NOT NULL
AND a.INTERFACE_ACTION_CODE IN ('INSERT','UPDATE');
UPDATE QP_INTERFACE_QUALIFIERS qiq
SET(QUALIFIER_ATTRIBUTE, PROCESS_STATUS_FLAG, ATTRIBUTE_STATUS)=
(SELECT a.segment_mapping_column,
DECODE(a.segment_mapping_column, NULL, null, 'P'),
DECODE(a.segment_mapping_column, NULL, qiq.ATTRIBUTE_STATUS||'003',qiq.ATTRIBUTE_STATUS)
FROM qp_segments_v a, qp_prc_contexts_b b, qp_interface_qualifiers c
WHERE b.prc_context_id = a.prc_context_id
AND b.prc_context_code = c.QUALIFIER_CONTEXT
AND a.segment_code = c.QUALIFIER_ATTRIBUTE_CODE
AND a.segment_mapping_column like 'QUALIFIER%'
AND qiq.rowid = c.rowid)
WHERE qiq.REQUEST_ID = P_REQUEST_ID
and qiq.process_status_flag = 'P' --IS NOT NULL
AND qiq.QUALIFIER_ATTRIBUTE IS NULL
--Bug# 5456164
--Don't do conversion if Value is G_NULL_CHAR
AND qiq.QUALIFIER_ATTRIBUTE_CODE <> QP_BULK_LOADER_PUB.G_NULL_CHAR
AND qiq.QUALIFIER_ATTRIBUTE_CODE IS NOT NULL
AND qiq.INTERFACE_ACTION_CODE IN ('INSERT','UPDATE');
SELECT orig_sys_pricing_attr_ref,
orig_sys_header_ref,
orig_sys_line_ref,
product_attribute_context,
product_attribute,
product_attr_code,
product_attr_value,
product_attr_val_disp,
pricing_attribute_context,
pricing_attribute,
pricing_attr_code,
pricing_attr_value_from,
pricing_attr_value_from_disp,
pricing_attr_value_to,
pricing_attr_value_to_disp
FROM qp_interface_pricing_attribs pa
WHERE pa.request_id = p_request_id
AND pa.process_status_flag = 'P'
AND pa.interface_action_code IN ('INSERT','UPDATE');
UPDATE QP_INTERFACE_LIST_LINES a
SET(PRICE_BY_FORMULA_ID, PROCESS_STATUS_FLAG, ATTRIBUTE_STATUS)=
(SELECT b.PRICE_FORMULA_ID,
DECODE(b.PRICE_FORMULA_ID, NULL, null, 'P'),
DECODE(b.PRICE_FORMULA_ID,NULL, a.ATTRIBUTE_STATUS||'001', a.ATTRIBUTE_STATUS)
FROM QP_PRICE_FORMULAS_VL b, QP_INTERFACE_LIST_LINES c
WHERE c.PRICE_BY_FORMULA = b.NAME(+)
AND a.rowid = c.rowid
)
WHERE a.REQUEST_ID = P_REQUEST_ID
AND a.PRICE_BY_FORMULA_ID IS NULL
AND a.PRICE_BY_FORMULA IS NOT NULL
--Bug# 5412029
--Don't do conversion if Value is G_NULL_CHAR
and a.PRICE_BY_FORMULA <> QP_BULK_LOADER_PUB.G_NULL_CHAR
AND a.INTERFACE_ACTION_CODE IN ('INSERT','UPDATE');
UPDATE QP_INTERFACE_LIST_LINES a
SET(GENERATE_USING_FORMULA_ID, PROCESS_STATUS_FLAG, ATTRIBUTE_STATUS)=
(SELECT b.PRICE_FORMULA_ID,
DECODE(b.PRICE_FORMULA_ID, NULL, null, 'P'),
DECODE(b.PRICE_FORMULA_ID,NULL, a.ATTRIBUTE_STATUS||'002', a.ATTRIBUTE_STATUS)
FROM QP_PRICE_FORMULAS_VL b, QP_INTERFACE_LIST_LINES c
WHERE c.GENERATE_USING_FORMULA = b.NAME(+)
AND a.rowid = c.rowid
)
WHERE a.REQUEST_ID = P_REQUEST_ID
AND a.GENERATE_USING_FORMULA_ID IS NULL
AND a.GENERATE_USING_FORMULA IS NOT NULL
--Bug# 5412029
--Don't do conversion if Value is G_NULL_CHAR
and a.GENERATE_USING_FORMULA <> QP_BULK_LOADER_PUB.G_NULL_CHAR
AND a.INTERFACE_ACTION_CODE IN ('INSERT','UPDATE');
UPDATE QP_INTERFACE_PRICING_ATTRIBS qipa
SET (PRODUCT_ATTRIBUTE, PROCESS_STATUS_FLAG, ATTRIBUTE_STATUS)=
(SELECT a.segment_mapping_column,
DECODE(a.segment_mapping_column, NULL, null, 'P'),
DECODE(a.segment_mapping_column, NULL, qipa.ATTRIBUTE_STATUS||'003',qipa.ATTRIBUTE_STATUS)
FROM qp_segments_v a, qp_prc_contexts_b b, qp_interface_pricing_attribs c
WHERE b.prc_context_id = a.prc_context_id
AND b.prc_context_code = c.PRODUCT_ATTRIBUTE_CONTEXT
AND a.segment_code = c.PRODUCT_ATTR_CODE
AND a.segment_mapping_column like 'PRICING%'
AND qipa.rowid = c.rowid)
WHERE qipa.REQUEST_ID = P_REQUEST_ID
AND qipa.process_status_flag = 'P' --IS NOT NULL
AND qipa.PRODUCT_ATTRIBUTE IS NULL
--Bug# 5456164
--Don't do conversion if Value is G_NULL_CHAR
AND qipa.PRODUCT_ATTR_CODE <> QP_BULK_LOADER_PUB.G_NULL_CHAR
AND qipa.PRODUCT_ATTR_CODE IS NOT NULL
AND qipa.INTERFACE_ACTION_CODE IN ('INSERT','UPDATE');
UPDATE QP_INTERFACE_LIST_LINES qill
SET PRODUCT_PRECEDENCE=
(SELECT NVL(a.USER_PRECEDENCE, a.SEEDED_PRECEDENCE)
FROM qp_segments_v a, qp_prc_contexts_b b, qp_interface_pricing_attribs c
WHERE b.prc_context_id = a.prc_context_id
AND b.prc_context_code = c.PRODUCT_ATTRIBUTE_CONTEXT
AND a.segment_code = c.PRODUCT_ATTR_CODE
AND a.segment_mapping_column like 'PRICING%'
AND qill.orig_sys_line_ref = c.orig_sys_line_ref
AND c.PRICING_ATTRIBUTE_CONTEXT is NULL
AND c.PRICING_ATTRIBUTE is NULL
AND c.PROCESS_STATUS_FLAG = 'P'
AND c.request_id = p_request_id ) --Bug No 6235177
WHERE qill.REQUEST_ID = P_REQUEST_ID
AND qill.process_status_flag = 'P' --IS NOT NULL
AND qill.PRODUCT_PRECEDENCE IS NULL
AND qill.INTERFACE_ACTION_CODE IN ('INSERT','UPDATE');
UPDATE QP_INTERFACE_PRICING_ATTRIBS qipa
SET (PRICING_ATTRIBUTE, PROCESS_STATUS_FLAG, ATTRIBUTE_STATUS)=
(SELECT a.segment_mapping_column,
DECODE(a.segment_mapping_column, NULL, null, 'P'),
DECODE(a.segment_mapping_column, NULL, qipa.ATTRIBUTE_STATUS||'005',qipa.ATTRIBUTE_STATUS)
FROM qp_segments_v a, qp_prc_contexts_b b, qp_interface_pricing_attribs c
WHERE b.prc_context_id = a.prc_context_id
AND b.prc_context_code = c.PRICING_ATTRIBUTE_CONTEXT
AND a.segment_code = c.PRICING_ATTR_CODE
AND a.segment_mapping_column like 'PRICING%'
AND qipa.rowid = c.rowid)
WHERE qipa.REQUEST_ID = P_REQUEST_ID
AND qipa.process_status_flag = 'P' --IS NOT NULL
AND qipa.PRICING_ATTRIBUTE IS NULL
--Bug# 5456164
--Don't do conversion if Value is G_NULL_CHAR
AND qipa.PRICING_ATTR_CODE <> QP_BULK_LOADER_PUB.G_NULL_CHAR
AND qipa.PRICING_ATTR_CODE IS NOT NULL
AND qipa.INTERFACE_ACTION_CODE IN ('INSERT','UPDATE');
UPDATE /*+ index(qipa QP_INTERFACE_PRCNG_ATTRIBS_N1) */ QP_INTERFACE_PRICING_ATTRIBS qipa --7323577
SET (PRODUCT_ATTR_VALUE, PROCESS_STATUS_FLAG, ATTRIBUTE_STATUS)=
(SELECT a.inventory_item_id,
DECODE(a.inventory_item_id, NULL, null, 'P'),
DECODE(a.inventory_item_id, NULL, qipa.ATTRIBUTE_STATUS||'004',qipa.ATTRIBUTE_STATUS)
FROM mtl_system_items_vl a, qp_interface_pricing_attribs c
WHERE (c.product_attr_value IS NULL and
a.concatenated_segments= c.product_attr_val_disp
OR c.product_attr_value IS NOT NULL and
a.inventory_item_id = c.product_attr_value)
AND qipa.rowid = c.rowid
AND rownum <2)
WHERE qipa.REQUEST_ID = P_REQUEST_ID
AND qipa.process_status_flag = 'P' --IS NOT NULL
AND qipa.product_attribute_context='ITEM'
AND qipa.product_attribute = 'PRICING_ATTRIBUTE1'
AND qipa.INTERFACE_ACTION_CODE IN ('INSERT','UPDATE');
UPDATE QP_INTERFACE_PRICING_ATTRIBS qipa
SET (PRODUCT_ATTR_VALUE, PROCESS_STATUS_FLAG, ATTRIBUTE_STATUS)=
(SELECT a.category_id,
DECODE(a.category_id, NULL, null, 'P'),
DECODE(a.category_id, NULL, qipa.ATTRIBUTE_STATUS||'004',qipa.ATTRIBUTE_STATUS)
FROM qp_item_categories_v a, qp_interface_pricing_attribs c
WHERE (c.product_attr_value IS NULL and
a.category_name = c.product_attr_val_disp
OR c.product_attr_value IS NOT NULL and
a.category_id = c.product_attr_value)
AND qipa.rowid = c.rowid
AND rownum <2)
WHERE qipa.REQUEST_ID = P_REQUEST_ID
AND qipa.process_status_flag = 'P' --IS NOT NULL
AND qipa.product_attribute_context='ITEM'
AND qipa.product_attribute = 'PRICING_ATTRIBUTE2'
AND qipa.INTERFACE_ACTION_CODE IN ('INSERT','UPDATE');
UPDATE QP_INTERFACE_PRICING_ATTRIBS
SET PROCESS_STATUS_FLAG=NULL, ATTRIBUTE_STATUS=ATTRIBUTE_STATUS||'004'
WHERE ORIG_SYS_PRICING_ATTR_REF = REC.ORIG_SYS_PRICING_ATTR_REF
AND ORIG_SYS_HEADER_REF = REC.ORIG_SYS_HEADER_REF
AND ORIG_SYS_LINE_REF = REC.ORIG_SYS_LINE_REF;
UPDATE QP_INTERFACE_PRICING_ATTRIBS
SET PRODUCT_ATTR_VALUE = l_product_attr_value
WHERE ORIG_SYS_PRICING_ATTR_REF = REC.ORIG_SYS_PRICING_ATTR_REF
AND ORIG_SYS_HEADER_REF = REC.ORIG_SYS_HEADER_REF
AND ORIG_SYS_LINE_REF = REC.ORIG_SYS_LINE_REF;
UPDATE QP_INTERFACE_PRICING_ATTRIBS
SET PROCESS_STATUS_FLAG=NULL, ATTRIBUTE_STATUS=ATTRIBUTE_STATUS||'004'
WHERE ORIG_SYS_PRICING_ATTR_REF = REC.ORIG_SYS_PRICING_ATTR_REF
AND ORIG_SYS_HEADER_REF = REC.ORIG_SYS_HEADER_REF
AND ORIG_SYS_LINE_REF = REC.ORIG_SYS_LINE_REF;
UPDATE QP_INTERFACE_LIST_LINES
SET PRODUCT_PRECEDENCE = l_precedence
WHERE ORIG_SYS_LINE_REF = REC.ORIG_SYS_LINE_REF
AND PROCESS_STATUS_FLAG = 'P'
AND PRODUCT_PRECEDENCE IS NULL;
UPDATE QP_INTERFACE_LIST_LINES
SET PROCESS_STATUS_FLAG = NULL,
ATTRIBUTE_STATUS=ATTRIBUTE_STATUS||'004'
WHERE ORIG_SYS_LINE_REF = REC.ORIG_SYS_LINE_REF
AND PROCESS_STATUS_FLAG = 'P'; --IS NULL;
UPDATE QP_INTERFACE_PRICING_ATTRIBS
SET PRICING_ATTR_VALUE_FROM = l_pricing_attr_value_from
WHERE ORIG_SYS_PRICING_ATTR_REF = REC.ORIG_SYS_PRICING_ATTR_REF
AND ORIG_SYS_HEADER_REF = REC.ORIG_SYS_HEADER_REF
AND ORIG_SYS_LINE_REF = REC.ORIG_SYS_LINE_REF;
UPDATE QP_INTERFACE_PRICING_ATTRIBS
SET PROCESS_STATUS_FLAG=NULL, ATTRIBUTE_STATUS=ATTRIBUTE_STATUS||'006'
WHERE ORIG_SYS_PRICING_ATTR_REF = REC.ORIG_SYS_PRICING_ATTR_REF
AND ORIG_SYS_HEADER_REF = REC.ORIG_SYS_HEADER_REF
AND ORIG_SYS_LINE_REF = REC.ORIG_SYS_LINE_REF;
UPDATE QP_INTERFACE_PRICING_ATTRIBS
SET PRICING_ATTR_VALUE_TO = l_pricing_attr_value_to
WHERE ORIG_SYS_PRICING_ATTR_REF = REC.ORIG_SYS_PRICING_ATTR_REF
AND ORIG_SYS_HEADER_REF = REC.ORIG_SYS_HEADER_REF
AND ORIG_SYS_LINE_REF = REC.ORIG_SYS_LINE_REF;
UPDATE QP_INTERFACE_PRICING_ATTRIBS
SET PROCESS_STATUS_FLAG=NULL, ATTRIBUTE_STATUS=ATTRIBUTE_STATUS||'007'
WHERE ORIG_SYS_PRICING_ATTR_REF = REC.ORIG_SYS_PRICING_ATTR_REF
AND ORIG_SYS_HEADER_REF = REC.ORIG_SYS_HEADER_REF
AND ORIG_SYS_LINE_REF = REC.ORIG_SYS_LINE_REF;
PROCEDURE INSERT_HEADER_ERROR_MESSAGES
(p_request_id NUMBER)
IS
CURSOR c_error_records IS
SELECT orig_sys_header_ref,
attribute_status
FROM qp_interface_list_headers
WHERE request_id = p_request_id
AND process_status_flag is null
AND attribute_status IS NOT NULL;
qp_bulk_loader_pub.write_log( 'Entering Insert Header Error Messages');
INSERT INTO QP_INTERFACE_ERRORS
(error_id,last_update_date, last_updated_by, creation_date,
created_by, last_update_login, request_id, program_application_id,
program_id, program_update_date, entity_type, table_name, column_name,
orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
orig_sys_pricing_attr_ref,error_message)
VALUES
(qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,
NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', NULL,
l_err.orig_sys_header_ref,null,null,null,l_msg_txt);
qp_bulk_loader_pub.write_log( 'Leaving Insert Header Error Messages');
'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.INSERT_HEADER_ERROR_MESSAGES:'||sqlerrm);
'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.INSERT_HEADER_ERROR_MESSAGES:'||sqlerrm);
END INSERT_HEADER_ERROR_MESSAGES;
PROCEDURE INSERT_QUAL_ERROR_MESSAGE
(p_request_id NUMBER)
IS
CURSOR c_error_records IS
SELECT orig_sys_qualifier_ref,
orig_sys_header_ref,
attribute_status
FROM qp_interface_qualifiers
WHERE request_id = p_request_id
AND process_status_flag is null;
qp_bulk_loader_pub.write_log( 'Entering Insert Qualifier Error Messages');
INSERT INTO QP_INTERFACE_ERRORS
(error_id,last_update_date, last_updated_by, creation_date,
created_by, last_update_login, request_id, program_application_id,
program_id, program_update_date, entity_type, table_name, column_name,
orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
orig_sys_pricing_attr_ref, error_message)
VALUES
(qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,
NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', NULL,
l_err.orig_sys_header_ref,null,l_err.orig_sys_qualifier_ref,null,l_msg_txt);
INSERT INTO QP_INTERFACE_ERRORS
(error_id,last_update_date, last_updated_by, creation_date,
created_by, last_update_login, request_id, program_application_id,
program_id, program_update_date, entity_type, table_name, column_name,
orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
orig_sys_pricing_attr_ref, error_message)
VALUES
(qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,
NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', NULL,
l_err.orig_sys_header_ref,null,l_err.orig_sys_qualifier_ref,null,l_msg_txt);
qp_bulk_loader_pub.write_log( 'Leaving Insert Qualifier Error Messages');
'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.INSERT_QUAL_ERROR_MESSAGES:'||sqlerrm);
'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.INSERT_QUAL_ERROR_MESSAGES:'||sqlerrm);
END INSERT_QUAL_ERROR_MESSAGE;
PROCEDURE INSERT_LINE_ERROR_MESSAGE
(p_request_id NUMBER)
IS
CURSOR c_error_records IS
SELECT orig_sys_header_ref orig_header_ref,
orig_sys_line_ref orig_line_ref,
null orig_attr_ref,
attribute_status, null pac, null pa, null pcac, null pca, null pav, null pavd,
'QP_INTERFACE_LIST_LINES' table_name
FROM qp_interface_list_lines
WHERE request_id = p_request_id
AND process_status_flag is null
AND attribute_status IS NOT NULL
UNION
SELECT orig_sys_header_ref orig_header_ref,
orig_sys_line_ref orig_line_ref,
orig_sys_pricing_attr_ref orig_attr_ref,
attribute_status, product_attr_code pac, product_attribute pa,
pricing_attr_code pcac, pricing_attribute pca,
product_attr_value pav, product_attr_val_disp pavd,
'QP_INTERFACE_PRICING_ATTRIBS' table_name
FROM qp_interface_pricing_attribs
WHERE request_id = p_request_id
AND process_status_flag is null;
qp_bulk_loader_pub.write_log( 'Entering Insert Line Error Messages');
INSERT INTO QP_INTERFACE_ERRORS
(error_id,last_update_date, last_updated_by, creation_date,
created_by, last_update_login, request_id, program_application_id,
program_id, program_update_date, entity_type, table_name, column_name,
orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
orig_sys_pricing_attr_ref,error_message)
VALUES
(qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,
NULL,NULL, 'PRL',l_err.table_name, NULL,
l_err.orig_header_ref,l_err.orig_line_ref,null,l_err.orig_attr_ref,l_msg_txt);
INSERT INTO QP_INTERFACE_ERRORS
(error_id,last_update_date, last_updated_by, creation_date,
created_by, last_update_login, request_id, program_application_id,
program_id, program_update_date, entity_type, table_name, column_name,
orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
orig_sys_pricing_attr_ref,error_message)
VALUES
(qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,
NULL,NULL, 'PRL',l_err.table_name, NULL,
l_err.orig_header_ref,l_err.orig_line_ref,null,l_err.orig_attr_ref,l_msg_txt);
INSERT INTO QP_INTERFACE_ERRORS
(error_id,last_update_date, last_updated_by, creation_date,
created_by, last_update_login, request_id, program_application_id,
program_id, program_update_date, entity_type, table_name, column_name,
orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
orig_sys_pricing_attr_ref,error_message)
VALUES
(qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,
NULL,NULL, 'PRL',l_err.table_name, NULL,
l_err.orig_header_ref,l_err.orig_line_ref,null,l_err.orig_attr_ref,l_msg_txt);
INSERT INTO QP_INTERFACE_ERRORS
(error_id,last_update_date, last_updated_by, creation_date,
created_by, last_update_login, request_id, program_application_id,
program_id, program_update_date, entity_type, table_name, column_name,
orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
orig_sys_pricing_attr_ref,error_message)
VALUES
(qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,
NULL,NULL, 'PRL',l_err.table_name, NULL,
l_err.orig_header_ref,l_err.orig_line_ref,null,l_err.orig_attr_ref,l_msg_txt);
INSERT INTO QP_INTERFACE_ERRORS
(error_id,last_update_date, last_updated_by, creation_date,
created_by, last_update_login, request_id, program_application_id,
program_id, program_update_date, entity_type, table_name, column_name,
orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
orig_sys_pricing_attr_ref,error_message)
VALUES
(qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,
NULL,NULL, 'PRL',l_err.table_name, NULL,
l_err.orig_header_ref,l_err.orig_line_ref,null,l_err.orig_attr_ref,l_msg_txt);
qp_bulk_loader_pub.write_log( 'Leaving Insert Line Error Messages');
'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.INSERT_LINE_ERROR_MESSAGES:'||sqlerrm);
'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.INSERT_LINE_ERROR_MESSAGES:'||sqlerrm);
END INSERT_LINE_ERROR_MESSAGE;