DBA Data[Home] [Help]

APPS.CSD_DEPOT_REPAIR_CNTR dependencies on FND_MESSAGE

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

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

Line 577: fnd_message.set_token('RMA_NO',i.rma_number);

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);

Line 578: fnd_message.set_token('REP_NO',l_repair_number);

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;

Line 579: fnd_message.set_token('QTY_RCVD',to_char(i.received_quantity));

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:

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

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

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

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;

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

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:

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

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

Line 936: fnd_message.set_name('CSD','CSD_INVALID_WIP_ENTITY');

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);

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

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;

Line 938: fnd_message.set_token('WIP_JOB_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;
942: v_completed_qty := 0;

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

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

Line 975: fnd_message.set_name('CSD','CSD_DRC_WIP_JOB_UPDATE');

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

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

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);

Line 977: fnd_message.set_token('WIP_JOB',v_wip_entity_name);

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;

Line 978: fnd_message.set_token('QTY_COMPLETE',to_char(v_transaction_quantity));

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:

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

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;

Line 1088: fnd_message.set_name('CSD','CSD_DRC_WIP_REC_PROC');

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;

Line 1089: fnd_message.set_token('TOT_REC',to_char(v_total_rec));

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:

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

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

Line 1279: fnd_message.set_name('CSD','CSD_DRC_SHIP_PICKUP_DATE_PROC');

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));

Line 1280: fnd_message.set_token('ORDER_NO',I.order_number);

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

Line 1281: fnd_message.set_token('REP_NO',I.repair_number);

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);

Line 1282: fnd_message.set_token('QTY_SHIP',to_char(I.shipped_quantity));

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;

Line 1283: fnd_message.set_token('DT_SHIP',to_char(I.date_shipped));

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:

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

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;

Line 1288: fnd_message.clear;

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

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

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

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

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);

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

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');

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

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');

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

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:

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

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;

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

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:

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

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