DBA Data[Home] [Help]

APPS.CSD_DEPOT_UPDATE_PVT dependencies on FND_MESSAGE

Line 1360: fnd_message.set_name('CSD','CSD_INVALID_ITEM_ID');

1356: IF (g_debug > 0 ) THEN
1357: csd_gen_utility_pvt.ADD('Invalid Inv item Id ');
1358: END IF;
1359:
1360: fnd_message.set_name('CSD','CSD_INVALID_ITEM_ID');
1361: fnd_message.set_token('INVENTORY_ITEM_ID',C1.inventory_item_id);
1362: fnd_msg_pub.add;
1363: RAISE FND_API.G_EXC_ERROR;
1364: End;

Line 1361: fnd_message.set_token('INVENTORY_ITEM_ID',C1.inventory_item_id);

1357: csd_gen_utility_pvt.ADD('Invalid Inv item Id ');
1358: END IF;
1359:
1360: fnd_message.set_name('CSD','CSD_INVALID_ITEM_ID');
1361: fnd_message.set_token('INVENTORY_ITEM_ID',C1.inventory_item_id);
1362: fnd_msg_pub.add;
1363: RAISE FND_API.G_EXC_ERROR;
1364: End;
1365:

Line 1430: fnd_message.set_name('CSD','CSD_INVALID_SERIAL_NUMBER');

1426: IF (g_debug > 0 ) THEN
1427: csd_gen_utility_pvt.ADD('Invalid Serial Number ');
1428: END IF;
1429:
1430: fnd_message.set_name('CSD','CSD_INVALID_SERIAL_NUMBER');
1431: fnd_message.set_token('SERIAL_NUMBER',C1.serial_number );
1432: fnd_msg_pub.add;
1433: RAISE FND_API.G_EXC_ERROR;
1434: End;

Line 1431: fnd_message.set_token('SERIAL_NUMBER',C1.serial_number );

1427: csd_gen_utility_pvt.ADD('Invalid Serial Number ');
1428: END IF;
1429:
1430: fnd_message.set_name('CSD','CSD_INVALID_SERIAL_NUMBER');
1431: fnd_message.set_token('SERIAL_NUMBER',C1.serial_number );
1432: fnd_msg_pub.add;
1433: RAISE FND_API.G_EXC_ERROR;
1434: End;
1435:

Line 1460: fnd_message.set_name('CSD','CSD_DRC_RMA_RECEIPT');

1456: Update csd_product_transactions
1457: set prod_txn_status = 'RECEIVED'
1458: where product_transaction_id = C1.product_transaction_id;
1459:
1460: fnd_message.set_name('CSD','CSD_DRC_RMA_RECEIPT');
1461: fnd_message.set_token('RMA_NO',C1.rma_number);
1462: fnd_message.set_token('REP_NO',C1.repair_number);
1463: fnd_message.set_token('QTY_RCVD',to_char(C1.received_quantity));
1464: IF (g_debug > 0 ) THEN

Line 1461: fnd_message.set_token('RMA_NO',C1.rma_number);

1457: set prod_txn_status = 'RECEIVED'
1458: where product_transaction_id = C1.product_transaction_id;
1459:
1460: fnd_message.set_name('CSD','CSD_DRC_RMA_RECEIPT');
1461: fnd_message.set_token('RMA_NO',C1.rma_number);
1462: fnd_message.set_token('REP_NO',C1.repair_number);
1463: fnd_message.set_token('QTY_RCVD',to_char(C1.received_quantity));
1464: IF (g_debug > 0 ) THEN
1465: csd_gen_utility_pvt.add(fnd_message.get);

Line 1462: fnd_message.set_token('REP_NO',C1.repair_number);

1458: where product_transaction_id = C1.product_transaction_id;
1459:
1460: fnd_message.set_name('CSD','CSD_DRC_RMA_RECEIPT');
1461: fnd_message.set_token('RMA_NO',C1.rma_number);
1462: fnd_message.set_token('REP_NO',C1.repair_number);
1463: fnd_message.set_token('QTY_RCVD',to_char(C1.received_quantity));
1464: IF (g_debug > 0 ) THEN
1465: csd_gen_utility_pvt.add(fnd_message.get);
1466: END IF;

Line 1463: fnd_message.set_token('QTY_RCVD',to_char(C1.received_quantity));

1459:
1460: fnd_message.set_name('CSD','CSD_DRC_RMA_RECEIPT');
1461: fnd_message.set_token('RMA_NO',C1.rma_number);
1462: fnd_message.set_token('REP_NO',C1.repair_number);
1463: fnd_message.set_token('QTY_RCVD',to_char(C1.received_quantity));
1464: IF (g_debug > 0 ) THEN
1465: csd_gen_utility_pvt.add(fnd_message.get);
1466: END IF;
1467:

Line 1465: csd_gen_utility_pvt.add(fnd_message.get);

1461: fnd_message.set_token('RMA_NO',C1.rma_number);
1462: fnd_message.set_token('REP_NO',C1.repair_number);
1463: fnd_message.set_token('QTY_RCVD',to_char(C1.received_quantity));
1464: IF (g_debug > 0 ) THEN
1465: csd_gen_utility_pvt.add(fnd_message.get);
1466: END IF;
1467:
1468:
1469: IF (g_debug > 0 ) THEN

Line 1566: fnd_message.set_name('CSD','CSD_DRC_WIP_TOT_REC_PROC');

1562: v_total_records := v_total_records + 1;
1563:
1564: End loop;
1565:
1566: fnd_message.set_name('CSD','CSD_DRC_WIP_TOT_REC_PROC');
1567: fnd_message.set_token('TOT_REC',to_char(v_total_records));
1568: IF (g_debug > 0 ) THEN
1569: csd_gen_utility_pvt.add(fnd_message.get);
1570: END IF;

Line 1567: fnd_message.set_token('TOT_REC',to_char(v_total_records));

1563:
1564: End loop;
1565:
1566: fnd_message.set_name('CSD','CSD_DRC_WIP_TOT_REC_PROC');
1567: fnd_message.set_token('TOT_REC',to_char(v_total_records));
1568: IF (g_debug > 0 ) THEN
1569: csd_gen_utility_pvt.add(fnd_message.get);
1570: END IF;
1571:

Line 1569: csd_gen_utility_pvt.add(fnd_message.get);

1565:
1566: fnd_message.set_name('CSD','CSD_DRC_WIP_TOT_REC_PROC');
1567: fnd_message.set_token('TOT_REC',to_char(v_total_records));
1568: IF (g_debug > 0 ) THEN
1569: csd_gen_utility_pvt.add(fnd_message.get);
1570: END IF;
1571:
1572:
1573: -- Return the count of number of records updated

Line 1760: fnd_message.set_name('CSD','CSD_DRC_QTY_SHIPPED');

1756: csd_gen_utility_pvt.add('Updated csd_repairs table');
1757: END IF;
1758:
1759:
1760: fnd_message.set_name('CSD','CSD_DRC_QTY_SHIPPED');
1761: fnd_message.set_token('ORDER_NO',i.order_number);
1762: fnd_message.set_token('REP_NO',i.repair_number);
1763: fnd_message.set_token('QTY_SHIP',to_char(p_result_ship_quantity));
1764: IF (g_debug > 0 ) THEN

Line 1761: fnd_message.set_token('ORDER_NO',i.order_number);

1757: END IF;
1758:
1759:
1760: fnd_message.set_name('CSD','CSD_DRC_QTY_SHIPPED');
1761: fnd_message.set_token('ORDER_NO',i.order_number);
1762: fnd_message.set_token('REP_NO',i.repair_number);
1763: fnd_message.set_token('QTY_SHIP',to_char(p_result_ship_quantity));
1764: IF (g_debug > 0 ) THEN
1765: csd_gen_utility_pvt.add(fnd_message.get);

Line 1762: fnd_message.set_token('REP_NO',i.repair_number);

1758:
1759:
1760: fnd_message.set_name('CSD','CSD_DRC_QTY_SHIPPED');
1761: fnd_message.set_token('ORDER_NO',i.order_number);
1762: fnd_message.set_token('REP_NO',i.repair_number);
1763: fnd_message.set_token('QTY_SHIP',to_char(p_result_ship_quantity));
1764: IF (g_debug > 0 ) THEN
1765: csd_gen_utility_pvt.add(fnd_message.get);
1766: END IF;

Line 1763: fnd_message.set_token('QTY_SHIP',to_char(p_result_ship_quantity));

1759:
1760: fnd_message.set_name('CSD','CSD_DRC_QTY_SHIPPED');
1761: fnd_message.set_token('ORDER_NO',i.order_number);
1762: fnd_message.set_token('REP_NO',i.repair_number);
1763: fnd_message.set_token('QTY_SHIP',to_char(p_result_ship_quantity));
1764: IF (g_debug > 0 ) THEN
1765: csd_gen_utility_pvt.add(fnd_message.get);
1766: END IF;
1767:

Line 1765: csd_gen_utility_pvt.add(fnd_message.get);

1761: fnd_message.set_token('ORDER_NO',i.order_number);
1762: fnd_message.set_token('REP_NO',i.repair_number);
1763: fnd_message.set_token('QTY_SHIP',to_char(p_result_ship_quantity));
1764: IF (g_debug > 0 ) THEN
1765: csd_gen_utility_pvt.add(fnd_message.get);
1766: END IF;
1767:
1768:
1769: IF (g_debug > 0 ) THEN

Line 1865: fnd_message.set_name('CSD','CSD_DRC_SHIP_TOTAL_REC_PROC');

1861: END IF;
1862:
1863: End loop;
1864:
1865: fnd_message.set_name('CSD','CSD_DRC_SHIP_TOTAL_REC_PROC');
1866: fnd_message.set_token('TOT_REC',to_char(v_total_records));
1867: IF (g_debug > 0 ) THEN
1868: csd_gen_utility_pvt.add(fnd_message.get);
1869: END IF;

Line 1866: fnd_message.set_token('TOT_REC',to_char(v_total_records));

1862:
1863: End loop;
1864:
1865: fnd_message.set_name('CSD','CSD_DRC_SHIP_TOTAL_REC_PROC');
1866: fnd_message.set_token('TOT_REC',to_char(v_total_records));
1867: IF (g_debug > 0 ) THEN
1868: csd_gen_utility_pvt.add(fnd_message.get);
1869: END IF;
1870:

Line 1868: csd_gen_utility_pvt.add(fnd_message.get);

1864:
1865: fnd_message.set_name('CSD','CSD_DRC_SHIP_TOTAL_REC_PROC');
1866: fnd_message.set_token('TOT_REC',to_char(v_total_records));
1867: IF (g_debug > 0 ) THEN
1868: csd_gen_utility_pvt.add(fnd_message.get);
1869: END IF;
1870:
1871:
1872: x_update_count := v_total_records;