[Home] [Help]
1565:
1566: FND_MESSAGE.SET_NAME('QP', 'HDR_NOT_ALLOWED_TO_DLT');
1567: l_msg_txt := FND_MESSAGE.GET;
1568:
1569: INSERT INTO QP_INTERFACE_ERRORS
1570: (error_id,last_update_date, last_updated_by, creation_date,
1571: created_by, last_update_login, request_id, program_application_id,
1572: program_id, program_update_date, entity_type, table_name, column_name,
1573: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
1572: program_id, program_update_date, entity_type, table_name, column_name,
1573: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
1574: orig_sys_pricing_attr_ref,error_message)
1575: SELECT
1576: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
1577: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,
1578: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', NULL,
1579: orig_sys_header_ref,null,null, null,l_msg_txt
1580: FROM QP_INTERFACE_LIST_HEADERS
1611: FND_MESSAGE.SET_TOKEN('RECORD' , 'QUALIFIER');
1612: l_msg_txt := FND_MESSAGE.GET;
1613:
1614: --check for existance of the record
1615: INSERT INTO QP_INTERFACE_ERRORS
1616: (error_id,last_update_date, last_updated_by, creation_date,
1617: created_by, last_update_login, request_id, program_application_id,
1618: program_id, program_update_date, entity_type, table_name, column_name,
1619: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
1618: program_id, program_update_date, entity_type, table_name, column_name,
1619: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
1620: orig_sys_pricing_attr_ref, error_message)
1621: SELECT
1622: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
1623: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,
1624: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', NULL,
1625: orig_sys_header_ref,null,orig_sys_qualifier_ref,null, l_msg_txt
1626: FROM QP_INTERFACE_QUALIFIERS qpiq
1683: FND_MESSAGE.SET_TOKEN('RECORD' , 'LINE');
1684: l_msg_txt := FND_MESSAGE.GET;
1685:
1686: --check for existance of the record
1687: INSERT INTO QP_INTERFACE_ERRORS
1688: (error_id,last_update_date, last_updated_by, creation_date,
1689: created_by, last_update_login, request_id, program_application_id,
1690: program_id, program_update_date, entity_type, table_name, column_name,
1691: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
1690: program_id, program_update_date, entity_type, table_name, column_name,
1691: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
1692: orig_sys_pricing_attr_ref,error_message)
1693: SELECT
1694: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
1695: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,
1696: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
1697: orig_sys_header_ref,orig_sys_line_ref,null,null, l_msg_txt
1698: FROM QP_INTERFACE_LIST_LINES qpil
1799: FND_MESSAGE.SET_TOKEN('RECORD' , 'PRICING ATTRIBUTE');
1800: l_msg_txt := FND_MESSAGE.GET;
1801:
1802: --check for existance of the record
1803: INSERT INTO QP_INTERFACE_ERRORS
1804: (error_id,last_update_date, last_updated_by, creation_date,
1805: created_by, last_update_login, request_id, program_application_id,
1806: program_id, program_update_date, entity_type, table_name, column_name,
1807: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
1806: program_id, program_update_date, entity_type, table_name, column_name,
1807: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
1808: orig_sys_pricing_attr_ref,error_message)
1809: SELECT
1810: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
1811: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,
1812: NULL,NULL, 'PRL', 'QP_INTERFACE_PRICING_ATTRIBS', NULL,
1813: orig_sys_header_ref,orig_sys_line_ref,null,orig_sys_pricing_attr_ref, l_msg_txt
1814: FROM QP_INTERFACE_PRICING_ATTRIBS qpip
1838: qp_bulk_loader_pub.write_log('Cannot delete a Price Break child line if it is not the highest break.');
1839: FND_MESSAGE.SET_NAME('QP', 'QP_NO_DELETE_PB_CHILD_LINE');
1840: l_msg_txt := FND_MESSAGE.GET;
1841:
1842: INSERT INTO QP_INTERFACE_ERRORS
1843: (error_id,last_update_date, last_updated_by, creation_date,
1844: created_by, last_update_login, request_id, program_application_id,
1845: program_id, program_update_date, entity_type, table_name, column_name,
1846: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
1845: program_id, program_update_date, entity_type, table_name, column_name,
1846: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
1847: orig_sys_pricing_attr_ref,error_message)
1848: SELECT
1849: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
1850: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,
1851: NULL,NULL, 'PRL', 'QP_INTERFACE_PRICING_ATTRIBS', NULL,
1852: orig_sys_header_ref,orig_sys_line_ref,null,orig_sys_pricing_attr_ref, l_msg_txt
1853: FROM QP_INTERFACE_PRICING_ATTRIBS qpip