1562: BEGIN
1563:
1564: qp_bulk_loader_pub.write_log('Entering Delete Header');
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,
1563:
1564: qp_bulk_loader_pub.write_log('Entering Delete Header');
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,
1606: BEGIN
1607:
1608: qp_bulk_loader_pub.write_log('Entering Delete Qualifier');
1609:
1610: FND_MESSAGE.SET_NAME('QP', 'NO_RECORD');
1611: FND_MESSAGE.SET_TOKEN('RECORD' , 'QUALIFIER');
1612: l_msg_txt := FND_MESSAGE.GET;
1613:
1614: --check for existance of the record
1607:
1608: qp_bulk_loader_pub.write_log('Entering Delete Qualifier');
1609:
1610: FND_MESSAGE.SET_NAME('QP', 'NO_RECORD');
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
1608: qp_bulk_loader_pub.write_log('Entering Delete Qualifier');
1609:
1610: FND_MESSAGE.SET_NAME('QP', 'NO_RECORD');
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,
1678: BEGIN
1679:
1680: qp_bulk_loader_pub.write_log('Entering Delete Line');
1681:
1682: FND_MESSAGE.SET_NAME('QP', 'NO_RECORD');
1683: FND_MESSAGE.SET_TOKEN('RECORD' , 'LINE');
1684: l_msg_txt := FND_MESSAGE.GET;
1685:
1686: --check for existance of the record
1679:
1680: qp_bulk_loader_pub.write_log('Entering Delete Line');
1681:
1682: FND_MESSAGE.SET_NAME('QP', 'NO_RECORD');
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
1680: qp_bulk_loader_pub.write_log('Entering Delete Line');
1681:
1682: FND_MESSAGE.SET_NAME('QP', 'NO_RECORD');
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,
1794:
1795: BEGIN
1796:
1797: qp_bulk_loader_pub.write_log('Entering Delete Pricing Attribute');
1798: FND_MESSAGE.SET_NAME('QP', 'NO_RECORD');
1799: FND_MESSAGE.SET_TOKEN('RECORD' , 'PRICING ATTRIBUTE');
1800: l_msg_txt := FND_MESSAGE.GET;
1801:
1802: --check for existance of the record
1795: BEGIN
1796:
1797: qp_bulk_loader_pub.write_log('Entering Delete Pricing Attribute');
1798: FND_MESSAGE.SET_NAME('QP', 'NO_RECORD');
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
1796:
1797: qp_bulk_loader_pub.write_log('Entering Delete Pricing Attribute');
1798: FND_MESSAGE.SET_NAME('QP', 'NO_RECORD');
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,
1835:
1836: --Bug# 5253114 RAVI START
1837:
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,
1836: --Bug# 5253114 RAVI START
1837:
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,