1561: BEGIN
1562:
1563: qp_bulk_loader_pub.write_log('Entering Delete Header');
1564:
1565: FND_MESSAGE.SET_NAME('QP', 'HDR_NOT_ALLOWED_TO_DLT');
1566: l_msg_txt := FND_MESSAGE.GET;
1567:
1568: INSERT INTO QP_INTERFACE_ERRORS
1569: (error_id,last_update_date, last_updated_by, creation_date,
1562:
1563: qp_bulk_loader_pub.write_log('Entering Delete Header');
1564:
1565: FND_MESSAGE.SET_NAME('QP', 'HDR_NOT_ALLOWED_TO_DLT');
1566: l_msg_txt := FND_MESSAGE.GET;
1567:
1568: INSERT INTO QP_INTERFACE_ERRORS
1569: (error_id,last_update_date, last_updated_by, creation_date,
1570: created_by, last_update_login, request_id, program_application_id,
1605: BEGIN
1606:
1607: qp_bulk_loader_pub.write_log('Entering Delete Qualifier');
1608:
1609: FND_MESSAGE.SET_NAME('QP', 'NO_RECORD');
1610: FND_MESSAGE.SET_TOKEN('RECORD' , 'QUALIFIER');
1611: l_msg_txt := FND_MESSAGE.GET;
1612:
1613: --check for existance of the record
1606:
1607: qp_bulk_loader_pub.write_log('Entering Delete Qualifier');
1608:
1609: FND_MESSAGE.SET_NAME('QP', 'NO_RECORD');
1610: FND_MESSAGE.SET_TOKEN('RECORD' , 'QUALIFIER');
1611: l_msg_txt := FND_MESSAGE.GET;
1612:
1613: --check for existance of the record
1614: INSERT INTO QP_INTERFACE_ERRORS
1607: qp_bulk_loader_pub.write_log('Entering Delete Qualifier');
1608:
1609: FND_MESSAGE.SET_NAME('QP', 'NO_RECORD');
1610: FND_MESSAGE.SET_TOKEN('RECORD' , 'QUALIFIER');
1611: l_msg_txt := FND_MESSAGE.GET;
1612:
1613: --check for existance of the record
1614: INSERT INTO QP_INTERFACE_ERRORS
1615: (error_id,last_update_date, last_updated_by, creation_date,
1677: BEGIN
1678:
1679: qp_bulk_loader_pub.write_log('Entering Delete Line');
1680:
1681: FND_MESSAGE.SET_NAME('QP', 'NO_RECORD');
1682: FND_MESSAGE.SET_TOKEN('RECORD' , 'LINE');
1683: l_msg_txt := FND_MESSAGE.GET;
1684:
1685: --check for existance of the record
1678:
1679: qp_bulk_loader_pub.write_log('Entering Delete Line');
1680:
1681: FND_MESSAGE.SET_NAME('QP', 'NO_RECORD');
1682: FND_MESSAGE.SET_TOKEN('RECORD' , 'LINE');
1683: l_msg_txt := FND_MESSAGE.GET;
1684:
1685: --check for existance of the record
1686: INSERT INTO QP_INTERFACE_ERRORS
1679: qp_bulk_loader_pub.write_log('Entering Delete Line');
1680:
1681: FND_MESSAGE.SET_NAME('QP', 'NO_RECORD');
1682: FND_MESSAGE.SET_TOKEN('RECORD' , 'LINE');
1683: l_msg_txt := FND_MESSAGE.GET;
1684:
1685: --check for existance of the record
1686: INSERT INTO QP_INTERFACE_ERRORS
1687: (error_id,last_update_date, last_updated_by, creation_date,
1793:
1794: BEGIN
1795:
1796: qp_bulk_loader_pub.write_log('Entering Delete Pricing Attribute');
1797: FND_MESSAGE.SET_NAME('QP', 'NO_RECORD');
1798: FND_MESSAGE.SET_TOKEN('RECORD' , 'PRICING ATTRIBUTE');
1799: l_msg_txt := FND_MESSAGE.GET;
1800:
1801: --check for existance of the record
1794: BEGIN
1795:
1796: qp_bulk_loader_pub.write_log('Entering Delete Pricing Attribute');
1797: FND_MESSAGE.SET_NAME('QP', 'NO_RECORD');
1798: FND_MESSAGE.SET_TOKEN('RECORD' , 'PRICING ATTRIBUTE');
1799: l_msg_txt := FND_MESSAGE.GET;
1800:
1801: --check for existance of the record
1802: INSERT INTO QP_INTERFACE_ERRORS
1795:
1796: qp_bulk_loader_pub.write_log('Entering Delete Pricing Attribute');
1797: FND_MESSAGE.SET_NAME('QP', 'NO_RECORD');
1798: FND_MESSAGE.SET_TOKEN('RECORD' , 'PRICING ATTRIBUTE');
1799: l_msg_txt := FND_MESSAGE.GET;
1800:
1801: --check for existance of the record
1802: INSERT INTO QP_INTERFACE_ERRORS
1803: (error_id,last_update_date, last_updated_by, creation_date,
1834:
1835: --Bug# 5253114 RAVI START
1836:
1837: qp_bulk_loader_pub.write_log('Cannot delete a Price Break child line if it is not the highest break.');
1838: FND_MESSAGE.SET_NAME('QP', 'QP_NO_DELETE_PB_CHILD_LINE');
1839: l_msg_txt := FND_MESSAGE.GET;
1840:
1841: INSERT INTO QP_INTERFACE_ERRORS
1842: (error_id,last_update_date, last_updated_by, creation_date,
1835: --Bug# 5253114 RAVI START
1836:
1837: qp_bulk_loader_pub.write_log('Cannot delete a Price Break child line if it is not the highest break.');
1838: FND_MESSAGE.SET_NAME('QP', 'QP_NO_DELETE_PB_CHILD_LINE');
1839: l_msg_txt := FND_MESSAGE.GET;
1840:
1841: INSERT INTO QP_INTERFACE_ERRORS
1842: (error_id,last_update_date, last_updated_by, creation_date,
1843: created_by, last_update_login, request_id, program_application_id,