DBA Data[Home] [Help]

APPS.RCV_CORE_S dependencies on RCV_ERROR_PKG

Line 1352: rcv_error_pkg.set_sql_error_message('derive_shipment_info', '000');

1348: RETURN;
1349: END IF;
1350: EXCEPTION
1351: WHEN OTHERS THEN
1352: rcv_error_pkg.set_sql_error_message('derive_shipment_info', '000');
1353: x_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
1354: x_header_record.error_record.error_message := rcv_error_pkg.get_last_message;
1355: END derive_shipment_info;
1356:

Line 1353: x_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;

1349: END IF;
1350: EXCEPTION
1351: WHEN OTHERS THEN
1352: rcv_error_pkg.set_sql_error_message('derive_shipment_info', '000');
1353: x_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
1354: x_header_record.error_record.error_message := rcv_error_pkg.get_last_message;
1355: END derive_shipment_info;
1356:
1357: /* ==========================================================================

Line 1354: x_header_record.error_record.error_message := rcv_error_pkg.get_last_message;

1350: EXCEPTION
1351: WHEN OTHERS THEN
1352: rcv_error_pkg.set_sql_error_message('derive_shipment_info', '000');
1353: x_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
1354: x_header_record.error_record.error_message := rcv_error_pkg.get_last_message;
1355: END derive_shipment_info;
1356:
1357: /* ==========================================================================
1358:

Line 1425: rcv_error_pkg.set_sql_error_message('default_shipment_info', '000');

1421: RETURN;
1422: END IF;
1423: EXCEPTION
1424: WHEN OTHERS THEN
1425: rcv_error_pkg.set_sql_error_message('default_shipment_info', '000');
1426: x_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
1427: x_header_record.error_record.error_message := rcv_error_pkg.get_last_message;
1428: END default_shipment_info;
1429:

Line 1426: x_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;

1422: END IF;
1423: EXCEPTION
1424: WHEN OTHERS THEN
1425: rcv_error_pkg.set_sql_error_message('default_shipment_info', '000');
1426: x_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
1427: x_header_record.error_record.error_message := rcv_error_pkg.get_last_message;
1428: END default_shipment_info;
1429:
1430: /* ==========================================================================

Line 1427: x_header_record.error_record.error_message := rcv_error_pkg.get_last_message;

1423: EXCEPTION
1424: WHEN OTHERS THEN
1425: rcv_error_pkg.set_sql_error_message('default_shipment_info', '000');
1426: x_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
1427: x_header_record.error_record.error_message := rcv_error_pkg.get_last_message;
1428: END default_shipment_info;
1429:
1430: /* ==========================================================================
1431:

Line 1457: rcv_error_pkg.set_error_message('RCV_NO_SHIPMENT_NUM');

1453: ''
1454: ) IS NULL) THEN
1455: /*dbms_output.put_line(X_header_record.header_record.asn_type);
1456: dbms_output.put_line(X_header_record.header_record.shipment_num);*/
1457: rcv_error_pkg.set_error_message('RCV_NO_SHIPMENT_NUM');
1458: RAISE e_validation_error;
1459: END IF;
1460:
1461: -- Check for Receipts before ASN

Line 1493: rcv_error_pkg.set_error_message('RCV_RCV_BEFORE_ASN');

1489: AND ship_to_org_id = x_header_record.header_record.ship_to_organization_id
1490: AND receipt_num IS NOT NULL;
1491:
1492: IF x_count > 0 THEN
1493: rcv_error_pkg.set_error_message('RCV_RCV_BEFORE_ASN');
1494: rcv_error_pkg.set_token('SHIPMENT', x_header_record.header_record.shipment_num);
1495: rcv_error_pkg.set_token('ITEM', ' ');
1496: RAISE e_validation_error;
1497: END IF;

Line 1494: rcv_error_pkg.set_token('SHIPMENT', x_header_record.header_record.shipment_num);

1490: AND receipt_num IS NOT NULL;
1491:
1492: IF x_count > 0 THEN
1493: rcv_error_pkg.set_error_message('RCV_RCV_BEFORE_ASN');
1494: rcv_error_pkg.set_token('SHIPMENT', x_header_record.header_record.shipment_num);
1495: rcv_error_pkg.set_token('ITEM', ' ');
1496: RAISE e_validation_error;
1497: END IF;
1498: END IF;

Line 1495: rcv_error_pkg.set_token('ITEM', ' ');

1491:
1492: IF x_count > 0 THEN
1493: rcv_error_pkg.set_error_message('RCV_RCV_BEFORE_ASN');
1494: rcv_error_pkg.set_token('SHIPMENT', x_header_record.header_record.shipment_num);
1495: rcv_error_pkg.set_token('ITEM', ' ');
1496: RAISE e_validation_error;
1497: END IF;
1498: END IF;
1499:

Line 1564: rcv_error_pkg.set_error_message('PO_PDOI_SHIPMENT_NUM_UNIQUE');

1560: IF x_count > 0 THEN
1561: /* Bug# 1413880
1562: As per the manual Shipment number should be unique for one year period for
1563: given supplier.Changing Warning to Error. */
1564: rcv_error_pkg.set_error_message('PO_PDOI_SHIPMENT_NUM_UNIQUE');
1565: rcv_error_pkg.set_token('VALUE', x_header_record.header_record.shipment_num);
1566: RAISE e_validation_error;
1567: END IF;
1568: END IF;

Line 1565: rcv_error_pkg.set_token('VALUE', x_header_record.header_record.shipment_num);

1561: /* Bug# 1413880
1562: As per the manual Shipment number should be unique for one year period for
1563: given supplier.Changing Warning to Error. */
1564: rcv_error_pkg.set_error_message('PO_PDOI_SHIPMENT_NUM_UNIQUE');
1565: rcv_error_pkg.set_token('VALUE', x_header_record.header_record.shipment_num);
1566: RAISE e_validation_error;
1567: END IF;
1568: END IF;
1569:

Line 1577: rcv_error_pkg.set_error_message('PO_PDOI_SHIPMENT_NUM_UNIQUE');

1573: the uniqueness */
1574: IF x_header_record.header_record.transaction_type = 'NEW'
1575: AND x_header_record.header_record.asn_type IN('STD') THEN
1576: IF NOT val_unique_shipment_num(x_header_record.header_record.shipment_num, x_header_record.header_record.vendor_id) THEN
1577: rcv_error_pkg.set_error_message('PO_PDOI_SHIPMENT_NUM_UNIQUE');
1578: rcv_error_pkg.set_token('VALUE', x_header_record.header_record.shipment_num);
1579: RAISE e_validation_error;
1580: END IF;
1581: END IF;

Line 1578: rcv_error_pkg.set_token('VALUE', x_header_record.header_record.shipment_num);

1574: IF x_header_record.header_record.transaction_type = 'NEW'
1575: AND x_header_record.header_record.asn_type IN('STD') THEN
1576: IF NOT val_unique_shipment_num(x_header_record.header_record.shipment_num, x_header_record.header_record.vendor_id) THEN
1577: rcv_error_pkg.set_error_message('PO_PDOI_SHIPMENT_NUM_UNIQUE');
1578: rcv_error_pkg.set_token('VALUE', x_header_record.header_record.shipment_num);
1579: RAISE e_validation_error;
1580: END IF;
1581: END IF;
1582:

Line 1609: rcv_error_pkg.set_error_message('RCV_NO_MATCHING_ASN');

1605: AND TRUNC(shipped_date) = TRUNC(x_header_record.header_record.shipped_date)
1606: AND shipped_date >= ADD_MONTHS(x_sysdate, -12);
1607:
1608: IF x_count = 0 THEN
1609: rcv_error_pkg.set_error_message('RCV_NO_MATCHING_ASN');
1610: rcv_error_pkg.set_token('SHIPMENT', x_header_record.header_record.shipment_num);
1611: RAISE e_validation_error;
1612: END IF;
1613: END IF;

Line 1610: rcv_error_pkg.set_token('SHIPMENT', x_header_record.header_record.shipment_num);

1606: AND shipped_date >= ADD_MONTHS(x_sysdate, -12);
1607:
1608: IF x_count = 0 THEN
1609: rcv_error_pkg.set_error_message('RCV_NO_MATCHING_ASN');
1610: rcv_error_pkg.set_token('SHIPMENT', x_header_record.header_record.shipment_num);
1611: RAISE e_validation_error;
1612: END IF;
1613: END IF;
1614:

Line 1655: rcv_error_pkg.set_error_message('RCV_ASN_QTY_RECEIVED');

1651: IF (g_asn_debug = 'Y') THEN
1652: asn_debug.put_line('There are receipts against the ASN ' || x_header_record.header_record.shipment_num);
1653: END IF;
1654:
1655: rcv_error_pkg.set_error_message('RCV_ASN_QTY_RECEIVED');
1656: rcv_error_pkg.set_token('SHIPMENT', x_header_record.header_record.shipment_num);
1657: RAISE e_validation_error;
1658: END IF;
1659: END IF;

Line 1656: rcv_error_pkg.set_token('SHIPMENT', x_header_record.header_record.shipment_num);

1652: asn_debug.put_line('There are receipts against the ASN ' || x_header_record.header_record.shipment_num);
1653: END IF;
1654:
1655: rcv_error_pkg.set_error_message('RCV_ASN_QTY_RECEIVED');
1656: rcv_error_pkg.set_token('SHIPMENT', x_header_record.header_record.shipment_num);
1657: RAISE e_validation_error;
1658: END IF;
1659: END IF;
1660:

Line 1720: rcv_error_pkg.set_error_message('RCV_ASN_MISMATCH_SHIP_ID');

1716: IF (g_asn_debug = 'Y') THEN
1717: asn_debug.put_line('The shipment_header_id do not match ');
1718: END IF;
1719:
1720: rcv_error_pkg.set_error_message('RCV_ASN_MISMATCH_SHIP_ID');
1721: rcv_error_pkg.set_token('SHIPMENT', x_header_record.header_record.shipment_num);
1722: RAISE e_validation_error;
1723: END IF;
1724: END IF;

Line 1721: rcv_error_pkg.set_token('SHIPMENT', x_header_record.header_record.shipment_num);

1717: asn_debug.put_line('The shipment_header_id do not match ');
1718: END IF;
1719:
1720: rcv_error_pkg.set_error_message('RCV_ASN_MISMATCH_SHIP_ID');
1721: rcv_error_pkg.set_token('SHIPMENT', x_header_record.header_record.shipment_num);
1722: RAISE e_validation_error;
1723: END IF;
1724: END IF;
1725: EXCEPTION

Line 1727: x_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;

1723: END IF;
1724: END IF;
1725: EXCEPTION
1726: WHEN e_validation_error THEN
1727: x_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1728: x_header_record.error_record.error_message := rcv_error_pkg.get_last_message;
1729: WHEN OTHERS THEN
1730: rcv_error_pkg.set_sql_error_message('validate_shipment_number', '000');
1731: x_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;

Line 1728: x_header_record.error_record.error_message := rcv_error_pkg.get_last_message;

1724: END IF;
1725: EXCEPTION
1726: WHEN e_validation_error THEN
1727: x_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1728: x_header_record.error_record.error_message := rcv_error_pkg.get_last_message;
1729: WHEN OTHERS THEN
1730: rcv_error_pkg.set_sql_error_message('validate_shipment_number', '000');
1731: x_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
1732: x_header_record.error_record.error_message := rcv_error_pkg.get_last_message;

Line 1730: rcv_error_pkg.set_sql_error_message('validate_shipment_number', '000');

1726: WHEN e_validation_error THEN
1727: x_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1728: x_header_record.error_record.error_message := rcv_error_pkg.get_last_message;
1729: WHEN OTHERS THEN
1730: rcv_error_pkg.set_sql_error_message('validate_shipment_number', '000');
1731: x_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
1732: x_header_record.error_record.error_message := rcv_error_pkg.get_last_message;
1733: END validate_shipment_number;
1734: END rcv_core_s;

Line 1731: x_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;

1727: x_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1728: x_header_record.error_record.error_message := rcv_error_pkg.get_last_message;
1729: WHEN OTHERS THEN
1730: rcv_error_pkg.set_sql_error_message('validate_shipment_number', '000');
1731: x_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
1732: x_header_record.error_record.error_message := rcv_error_pkg.get_last_message;
1733: END validate_shipment_number;
1734: END rcv_core_s;

Line 1732: x_header_record.error_record.error_message := rcv_error_pkg.get_last_message;

1728: x_header_record.error_record.error_message := rcv_error_pkg.get_last_message;
1729: WHEN OTHERS THEN
1730: rcv_error_pkg.set_sql_error_message('validate_shipment_number', '000');
1731: x_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
1732: x_header_record.error_record.error_message := rcv_error_pkg.get_last_message;
1733: END validate_shipment_number;
1734: END rcv_core_s;