572: where product_transaction_id = P.product_transaction_id;
573:
574: End Loop;
575:
576: fnd_message.set_name('CSD','CSD_DRC_RMA_RECEIPT');
577: fnd_message.set_token('RMA_NO',i.rma_number);
578: fnd_message.set_token('REP_NO',l_repair_number);
579: fnd_message.set_token('QTY_RCVD',to_char(i.received_quantity));
580: IF (g_debug > 0 ) THEN
573:
574: End Loop;
575:
576: fnd_message.set_name('CSD','CSD_DRC_RMA_RECEIPT');
577: fnd_message.set_token('RMA_NO',i.rma_number);
578: fnd_message.set_token('REP_NO',l_repair_number);
579: fnd_message.set_token('QTY_RCVD',to_char(i.received_quantity));
580: IF (g_debug > 0 ) THEN
581: csd_gen_utility_pvt.add(fnd_message.get);
574: End Loop;
575:
576: fnd_message.set_name('CSD','CSD_DRC_RMA_RECEIPT');
577: fnd_message.set_token('RMA_NO',i.rma_number);
578: fnd_message.set_token('REP_NO',l_repair_number);
579: fnd_message.set_token('QTY_RCVD',to_char(i.received_quantity));
580: IF (g_debug > 0 ) THEN
581: csd_gen_utility_pvt.add(fnd_message.get);
582: END IF;
575:
576: fnd_message.set_name('CSD','CSD_DRC_RMA_RECEIPT');
577: fnd_message.set_token('RMA_NO',i.rma_number);
578: fnd_message.set_token('REP_NO',l_repair_number);
579: fnd_message.set_token('QTY_RCVD',to_char(i.received_quantity));
580: IF (g_debug > 0 ) THEN
581: csd_gen_utility_pvt.add(fnd_message.get);
582: END IF;
583:
577: fnd_message.set_token('RMA_NO',i.rma_number);
578: fnd_message.set_token('REP_NO',l_repair_number);
579: fnd_message.set_token('QTY_RCVD',to_char(i.received_quantity));
580: IF (g_debug > 0 ) THEN
581: csd_gen_utility_pvt.add(fnd_message.get);
582: END IF;
583:
584:
585: IF (g_debug > 0 ) THEN
684: End if;
685:
686: End loop;
687:
688: fnd_message.set_name('CSD','CSD_DRC_WIP_TOT_REC_PROC');
689: fnd_message.set_token('TOT_REC',to_char(v_total_records));
690: IF (g_debug > 0 ) THEN
691: csd_gen_utility_pvt.add(fnd_message.get);
692: END IF;
685:
686: End loop;
687:
688: fnd_message.set_name('CSD','CSD_DRC_WIP_TOT_REC_PROC');
689: fnd_message.set_token('TOT_REC',to_char(v_total_records));
690: IF (g_debug > 0 ) THEN
691: csd_gen_utility_pvt.add(fnd_message.get);
692: END IF;
693:
687:
688: fnd_message.set_name('CSD','CSD_DRC_WIP_TOT_REC_PROC');
689: fnd_message.set_token('TOT_REC',to_char(v_total_records));
690: IF (g_debug > 0 ) THEN
691: csd_gen_utility_pvt.add(fnd_message.get);
692: END IF;
693:
694:
695: -- travi check for call from tools
932: from wip_entities
933: where wip_entity_id = i.wip_entity_id;
934: Exception
935: When no_data_found then
936: fnd_message.set_name('CSD','CSD_INVALID_WIP_ENTITY');
937: fnd_message.set_token('REP_NO',i.repair_number);
938: fnd_message.set_token('WIP_JOB_ID',i.wip_entity_id);
939: if (g_debug > 0) then
940: csd_gen_utility_pvt.add(fnd_message.get);
933: where wip_entity_id = i.wip_entity_id;
934: Exception
935: When no_data_found then
936: fnd_message.set_name('CSD','CSD_INVALID_WIP_ENTITY');
937: fnd_message.set_token('REP_NO',i.repair_number);
938: fnd_message.set_token('WIP_JOB_ID',i.wip_entity_id);
939: if (g_debug > 0) then
940: csd_gen_utility_pvt.add(fnd_message.get);
941: end if;
934: Exception
935: When no_data_found then
936: fnd_message.set_name('CSD','CSD_INVALID_WIP_ENTITY');
937: fnd_message.set_token('REP_NO',i.repair_number);
938: fnd_message.set_token('WIP_JOB_ID',i.wip_entity_id);
939: if (g_debug > 0) then
940: csd_gen_utility_pvt.add(fnd_message.get);
941: end if;
942: v_completed_qty := 0;
936: fnd_message.set_name('CSD','CSD_INVALID_WIP_ENTITY');
937: fnd_message.set_token('REP_NO',i.repair_number);
938: fnd_message.set_token('WIP_JOB_ID',i.wip_entity_id);
939: if (g_debug > 0) then
940: csd_gen_utility_pvt.add(fnd_message.get);
941: end if;
942: v_completed_qty := 0;
943: when others then
944: if (g_debug > 0) then
971: set quantity_completed =v_completed_qty
972: where repair_line_id = i.repair_line_id
973: and repair_job_xref_id = i.repair_job_xref_id;
974:
975: fnd_message.set_name('CSD','CSD_DRC_WIP_JOB_UPDATE');
976: fnd_message.set_token('REP_NO',i.repair_number);
977: fnd_message.set_token('WIP_JOB',v_wip_entity_name);
978: fnd_message.set_token('QTY_COMPLETE',to_char(v_transaction_quantity));
979: IF (g_debug > 0 ) THEN
972: where repair_line_id = i.repair_line_id
973: and repair_job_xref_id = i.repair_job_xref_id;
974:
975: fnd_message.set_name('CSD','CSD_DRC_WIP_JOB_UPDATE');
976: fnd_message.set_token('REP_NO',i.repair_number);
977: fnd_message.set_token('WIP_JOB',v_wip_entity_name);
978: fnd_message.set_token('QTY_COMPLETE',to_char(v_transaction_quantity));
979: IF (g_debug > 0 ) THEN
980: csd_gen_utility_pvt.add(fnd_message.get);
973: and repair_job_xref_id = i.repair_job_xref_id;
974:
975: fnd_message.set_name('CSD','CSD_DRC_WIP_JOB_UPDATE');
976: fnd_message.set_token('REP_NO',i.repair_number);
977: fnd_message.set_token('WIP_JOB',v_wip_entity_name);
978: fnd_message.set_token('QTY_COMPLETE',to_char(v_transaction_quantity));
979: IF (g_debug > 0 ) THEN
980: csd_gen_utility_pvt.add(fnd_message.get);
981: END IF;
974:
975: fnd_message.set_name('CSD','CSD_DRC_WIP_JOB_UPDATE');
976: fnd_message.set_token('REP_NO',i.repair_number);
977: fnd_message.set_token('WIP_JOB',v_wip_entity_name);
978: fnd_message.set_token('QTY_COMPLETE',to_char(v_transaction_quantity));
979: IF (g_debug > 0 ) THEN
980: csd_gen_utility_pvt.add(fnd_message.get);
981: END IF;
982:
976: fnd_message.set_token('REP_NO',i.repair_number);
977: fnd_message.set_token('WIP_JOB',v_wip_entity_name);
978: fnd_message.set_token('QTY_COMPLETE',to_char(v_transaction_quantity));
979: IF (g_debug > 0 ) THEN
980: csd_gen_utility_pvt.add(fnd_message.get);
981: END IF;
982:
983:
984: v_total_rec := v_total_rec + 1;
1084: End loop;
1085:
1086: commit;
1087:
1088: fnd_message.set_name('CSD','CSD_DRC_WIP_REC_PROC');
1089: fnd_message.set_token('TOT_REC',to_char(v_total_rec));
1090: IF (g_debug > 0 ) THEN
1091: csd_gen_utility_pvt.add(fnd_message.get);
1092: END IF;
1085:
1086: commit;
1087:
1088: fnd_message.set_name('CSD','CSD_DRC_WIP_REC_PROC');
1089: fnd_message.set_token('TOT_REC',to_char(v_total_rec));
1090: IF (g_debug > 0 ) THEN
1091: csd_gen_utility_pvt.add(fnd_message.get);
1092: END IF;
1093:
1087:
1088: fnd_message.set_name('CSD','CSD_DRC_WIP_REC_PROC');
1089: fnd_message.set_token('TOT_REC',to_char(v_total_rec));
1090: IF (g_debug > 0 ) THEN
1091: csd_gen_utility_pvt.add(fnd_message.get);
1092: END IF;
1093:
1094:
1095: if ( p_repair_line_id is not null ) then
1275: End if;
1276:
1277: -- Added jkuruvil to skip,display records with null shipped date
1278: IF I.date_shipped is null then
1279: fnd_message.set_name('CSD','CSD_DRC_SHIP_PICKUP_DATE_PROC');
1280: fnd_message.set_token('ORDER_NO',I.order_number);
1281: fnd_message.set_token('REP_NO',I.repair_number);
1282: fnd_message.set_token('QTY_SHIP',to_char(I.shipped_quantity));
1283: fnd_message.set_token('DT_SHIP',to_char(I.date_shipped));
1276:
1277: -- Added jkuruvil to skip,display records with null shipped date
1278: IF I.date_shipped is null then
1279: fnd_message.set_name('CSD','CSD_DRC_SHIP_PICKUP_DATE_PROC');
1280: fnd_message.set_token('ORDER_NO',I.order_number);
1281: fnd_message.set_token('REP_NO',I.repair_number);
1282: fnd_message.set_token('QTY_SHIP',to_char(I.shipped_quantity));
1283: fnd_message.set_token('DT_SHIP',to_char(I.date_shipped));
1284: IF (g_debug > 0 ) THEN
1277: -- Added jkuruvil to skip,display records with null shipped date
1278: IF I.date_shipped is null then
1279: fnd_message.set_name('CSD','CSD_DRC_SHIP_PICKUP_DATE_PROC');
1280: fnd_message.set_token('ORDER_NO',I.order_number);
1281: fnd_message.set_token('REP_NO',I.repair_number);
1282: fnd_message.set_token('QTY_SHIP',to_char(I.shipped_quantity));
1283: fnd_message.set_token('DT_SHIP',to_char(I.date_shipped));
1284: IF (g_debug > 0 ) THEN
1285: csd_gen_utility_pvt.add(fnd_message.get);
1278: IF I.date_shipped is null then
1279: fnd_message.set_name('CSD','CSD_DRC_SHIP_PICKUP_DATE_PROC');
1280: fnd_message.set_token('ORDER_NO',I.order_number);
1281: fnd_message.set_token('REP_NO',I.repair_number);
1282: fnd_message.set_token('QTY_SHIP',to_char(I.shipped_quantity));
1283: fnd_message.set_token('DT_SHIP',to_char(I.date_shipped));
1284: IF (g_debug > 0 ) THEN
1285: csd_gen_utility_pvt.add(fnd_message.get);
1286: END IF;
1279: fnd_message.set_name('CSD','CSD_DRC_SHIP_PICKUP_DATE_PROC');
1280: fnd_message.set_token('ORDER_NO',I.order_number);
1281: fnd_message.set_token('REP_NO',I.repair_number);
1282: fnd_message.set_token('QTY_SHIP',to_char(I.shipped_quantity));
1283: fnd_message.set_token('DT_SHIP',to_char(I.date_shipped));
1284: IF (g_debug > 0 ) THEN
1285: csd_gen_utility_pvt.add(fnd_message.get);
1286: END IF;
1287:
1281: fnd_message.set_token('REP_NO',I.repair_number);
1282: fnd_message.set_token('QTY_SHIP',to_char(I.shipped_quantity));
1283: fnd_message.set_token('DT_SHIP',to_char(I.date_shipped));
1284: IF (g_debug > 0 ) THEN
1285: csd_gen_utility_pvt.add(fnd_message.get);
1286: END IF;
1287:
1288: fnd_message.clear;
1289: v_skip_record := true;
1284: IF (g_debug > 0 ) THEN
1285: csd_gen_utility_pvt.add(fnd_message.get);
1286: END IF;
1287:
1288: fnd_message.clear;
1289: v_skip_record := true;
1290: End if;
1291:
1292: if not v_skip_record then
1457: csd_gen_utility_pvt.add('Updated csd_repairs table');
1458: END IF;
1459:
1460:
1461: fnd_message.set_name('CSD','CSD_DRC_QTY_SHIPPED');
1462: fnd_message.set_token('ORDER_NO',i.order_number);
1463: fnd_message.set_token('REP_NO',i.repair_number);
1464: fnd_message.set_token('QTY_SHIP',to_char(p_result_ship_quantity));
1465: IF (g_debug > 0 ) THEN
1458: END IF;
1459:
1460:
1461: fnd_message.set_name('CSD','CSD_DRC_QTY_SHIPPED');
1462: fnd_message.set_token('ORDER_NO',i.order_number);
1463: fnd_message.set_token('REP_NO',i.repair_number);
1464: fnd_message.set_token('QTY_SHIP',to_char(p_result_ship_quantity));
1465: IF (g_debug > 0 ) THEN
1466: csd_gen_utility_pvt.add(fnd_message.get);
1459:
1460:
1461: fnd_message.set_name('CSD','CSD_DRC_QTY_SHIPPED');
1462: fnd_message.set_token('ORDER_NO',i.order_number);
1463: fnd_message.set_token('REP_NO',i.repair_number);
1464: fnd_message.set_token('QTY_SHIP',to_char(p_result_ship_quantity));
1465: IF (g_debug > 0 ) THEN
1466: csd_gen_utility_pvt.add(fnd_message.get);
1467: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.depot_shipment_update before CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write call for PS event');
1460:
1461: fnd_message.set_name('CSD','CSD_DRC_QTY_SHIPPED');
1462: fnd_message.set_token('ORDER_NO',i.order_number);
1463: fnd_message.set_token('REP_NO',i.repair_number);
1464: fnd_message.set_token('QTY_SHIP',to_char(p_result_ship_quantity));
1465: IF (g_debug > 0 ) THEN
1466: csd_gen_utility_pvt.add(fnd_message.get);
1467: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.depot_shipment_update before CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write call for PS event');
1468: csd_gen_utility_pvt.add('Calling CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write');
1462: fnd_message.set_token('ORDER_NO',i.order_number);
1463: fnd_message.set_token('REP_NO',i.repair_number);
1464: fnd_message.set_token('QTY_SHIP',to_char(p_result_ship_quantity));
1465: IF (g_debug > 0 ) THEN
1466: csd_gen_utility_pvt.add(fnd_message.get);
1467: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.depot_shipment_update before CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write call for PS event');
1468: csd_gen_utility_pvt.add('Calling CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write');
1469: END IF;
1470:
1553: End if;
1554:
1555: End loop;
1556:
1557: fnd_message.set_name('CSD','CSD_DRC_SHIP_TOTAL_REC_PROC');
1558: fnd_message.set_token('TOT_REC',to_char(v_total_records));
1559: IF (g_debug > 0 ) THEN
1560: csd_gen_utility_pvt.add(fnd_message.get);
1561: END IF;
1554:
1555: End loop;
1556:
1557: fnd_message.set_name('CSD','CSD_DRC_SHIP_TOTAL_REC_PROC');
1558: fnd_message.set_token('TOT_REC',to_char(v_total_records));
1559: IF (g_debug > 0 ) THEN
1560: csd_gen_utility_pvt.add(fnd_message.get);
1561: END IF;
1562:
1556:
1557: fnd_message.set_name('CSD','CSD_DRC_SHIP_TOTAL_REC_PROC');
1558: fnd_message.set_token('TOT_REC',to_char(v_total_records));
1559: IF (g_debug > 0 ) THEN
1560: csd_gen_utility_pvt.add(fnd_message.get);
1561: END IF;
1562:
1563:
1564: if ( p_repair_line_id is not null ) then