DBA Data[Home] [Help]

APPS.RCV_CORE_S dependencies on RCV_ERROR_PKG

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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