eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSD_OM_INTERFACE_PVT dependencies on FND_API

Line 114: x_return_status := FND_API.G_RET_STS_SUCCESS ;

110: l_mod_name varchar2(2000) := 'csd.plsql.csd_om_interface_pvt.get_party_site_id';
111:
112: BEGIN
113: -- Initialize the return status
114: x_return_status := FND_API.G_RET_STS_SUCCESS ;
115:
116: -- Api body starts
117: Debug('At the Beginning of Get_Party_site_id',l_mod_name,1);
118: Debug('p_cust_site_use_id '||p_cust_site_use_id ,l_mod_name,1);

Line 139: Raise FND_API.G_EXC_ERROR ;

135: fnd_message.set_token('CUST_SITE_USE_ID',p_cust_site_use_id );
136: fnd_msg_pub.add;
137: END IF;
138: Debug('Party site does not exist for cust site use ID='||to_char(p_cust_site_use_id) ,l_mod_name,1);
139: Raise FND_API.G_EXC_ERROR ;
140: End;
141:
142: IF l_party_site_id is not null THEN
143: Begin

Line 166: Raise FND_API.G_EXC_ERROR ;

162: fnd_message.set_token('PTY_SITE_ID',l_party_site_id);
163: fnd_msg_pub.add;
164: END IF;
165: Debug('Party site does not exist for party site id='||to_char(l_party_site_id) ,l_mod_name,1);
166: Raise FND_API.G_EXC_ERROR ;
167: When TOO_MANY_ROWS then
168: IF ( l_error_level >= G_debug_level) THEN
169: fnd_message.set_name('CSD','CSD_INV_PTY_SITE_ID');
170: fnd_message.set_token('PTY_SITE_ID',l_party_site_id);

Line 178: Raise FND_API.G_EXC_ERROR ;

174: fnd_message.set_token('PTY_SITE_ID',l_party_site_id);
175: fnd_msg_pub.add;
176: END IF;
177: Debug('Too many rows found for party site id='||to_char(l_party_site_id) ,l_mod_name,1);
178: Raise FND_API.G_EXC_ERROR ;
179: End;
180: END IF;
181:
182: Debug('l_party_site_use_id='||to_char(l_party_site_use_id) ,l_mod_name,1);

Line 188: WHEN FND_API.G_EXC_ERROR THEN

184: --Return the party site use id
185: x_party_site_use_id := l_party_site_use_id;
186:
187: EXCEPTION
188: WHEN FND_API.G_EXC_ERROR THEN
189: x_return_status := FND_API.G_RET_STS_ERROR ;
190: WHEN OTHERS THEN
191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
192: END Get_party_site_id;

Line 189: x_return_status := FND_API.G_RET_STS_ERROR ;

185: x_party_site_use_id := l_party_site_use_id;
186:
187: EXCEPTION
188: WHEN FND_API.G_EXC_ERROR THEN
189: x_return_status := FND_API.G_RET_STS_ERROR ;
190: WHEN OTHERS THEN
191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
192: END Get_party_site_id;
193:

Line 191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

187: EXCEPTION
188: WHEN FND_API.G_EXC_ERROR THEN
189: x_return_status := FND_API.G_RET_STS_ERROR ;
190: WHEN OTHERS THEN
191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
192: END Get_party_site_id;
193:
194:
195: /*-------------------------------------------------------------------------------------*/

Line 369: Raise FND_API.G_EXC_ERROR ;

365: fnd_message.set_name('CSD','CSD_PARAMETERS_MISSING');
366: fnd_msg_pub.add;
367: END IF;
368: Debug( 'One of the IN parameters(Inv Org, Subinventory) is NULL',l_mod_name,1);
369: Raise FND_API.G_EXC_ERROR ;
370: END IF;
371:
372: l_approval_flag := FND_PROFILE.value('CSD_CUST_APPROVAL_REQD');
373:

Line 406: Raise FND_API.G_EXC_ERROR ;

402: fnd_message.set_name('CSD','CSD_PROF_SETUP_MISSING');
403: fnd_msg_pub.add;
404: END IF;
405: Debug( 'One of the profile for SR default values is not set',l_mod_name,1);
406: Raise FND_API.G_EXC_ERROR ;
407: END IF;
408:
409: Debug( 'Getting Repair Type Id and mode for standard repair',l_mod_name,1);
410:

Line 431: Raise FND_API.G_EXC_ERROR ;

427: fnd_message.set_name('CSD','CSD_STD_REP_TYPE_MISSING');
428: fnd_msg_pub.add;
429: END IF;
430: Debug( 'Standard Repair Type not found',l_mod_name,1);
431: Raise FND_API.G_EXC_ERROR ;
432: When TOO_MANY_ROWS then
433: IF ( l_error_level >= G_debug_level) THEN
434: fnd_message.set_name('CSD','CSD_STD_REP_TYPE_MISSING');
435: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

Line 441: Raise FND_API.G_EXC_ERROR ;

437: fnd_message.set_name('CSD','CSD_STD_REP_TYPE_MISSING');
438: fnd_msg_pub.add;
439: END IF;
440: Debug( 'Too many Standard Repair Types found',l_mod_name,1);
441: Raise FND_API.G_EXC_ERROR ;
442: End;
443:
444: Debug( 'Validating the Inv Org',l_mod_name,1);
445: -- Validate if the inv org id is set in inventory

Line 463: Raise FND_API.G_EXC_ERROR ;

459: fnd_message.set_token('INV_ORG_ID',p_inventory_org_id);
460: fnd_msg_pub.add;
461: END IF;
462: Debug( 'Inventory Org not found for INV Org ID='||to_char(p_inventory_org_id),l_mod_name,1);
463: Raise FND_API.G_EXC_ERROR ;
464: When TOO_MANY_ROWS then
465: IF ( l_error_level >= G_debug_level) THEN
466: fnd_message.set_name('CSD','CSD_INVALID_INV_ORG_ID');
467: fnd_message.set_token('INV_ORG_ID',p_inventory_org_id);

Line 475: Raise FND_API.G_EXC_ERROR ;

471: fnd_message.set_token('INV_ORG_ID',p_inventory_org_id);
472: fnd_msg_pub.add;
473: END IF;
474: Debug( 'Two many rows Inventory Org is defined for Inv Org ID='||to_char(p_inventory_org_id),l_mod_name,1);
475: Raise FND_API.G_EXC_ERROR ;
476: End;
477:
478: Debug( 'Validating the Subinventory',l_mod_name,1);
479: -- Validate the subinventory

Line 498: Raise FND_API.G_EXC_ERROR ;

494: fnd_message.set_token('SUB_INV',p_subinventory_name );
495: fnd_msg_pub.add;
496: END IF;
497: Debug( 'Subinventory Location not found='||p_subinventory_name,l_mod_name,1 );
498: Raise FND_API.G_EXC_ERROR ;
499: When TOO_MANY_ROWS then
500: IF ( l_error_level >= G_debug_level) THEN
501: fnd_message.set_name('CSD','CSD_INVALID_SUB_INV');
502: fnd_message.set_token('SUB_INV',p_subinventory_name );

Line 510: Raise FND_API.G_EXC_ERROR ;

506: fnd_message.set_token('SUB_INV',p_subinventory_name );
507: fnd_msg_pub.add;
508: END IF;
509: Debug( 'Too many rows found for subinventory ='||p_subinventory_name,l_mod_name,1 );
510: Raise FND_API.G_EXC_ERROR ;
511: End;
512:
513: l_sr_count := 0;
514: l_ro_count := 0;

Line 579: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

575: p_cust_site_use_id => C1.bill_to_site_use_id,
576: x_party_site_use_id => l_bill_to_party_site_use_id ,
577: x_return_status => l_return_status);
578:
579: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
580: Debug( 'Get_party_site_id failed for bill-to party site use Id ='||to_char(l_bill_to_party_site_use_id ),l_mod_name,1);
581: RAISE SKIP_RECORD;
582: END IF;
583:

Line 592: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

588: p_cust_site_use_id => C1.ship_to_site_use_id,
589: x_party_site_use_id => l_ship_to_party_site_use_id ,
590: x_return_status => l_return_status);
591:
592: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
593: Debug( 'Get_party_site_id failed for ship-to party site use Id = '||to_char(l_ship_to_party_site_use_id ),l_mod_name,1);
594: RAISE SKIP_RECORD;
595: END IF;
596:

Line 625: IF (nvl(l_service_request_rec.bill_to_site_use_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) THEN

621: l_service_request_rec.group_type := 'RS_GROUP';
622:
623: Debug( 'Getting Bill_to fields = ',l_mod_name,1);
624: -- Bill-To fields
625: IF (nvl(l_service_request_rec.bill_to_site_use_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) THEN
626: OPEN c_party_site_id(l_service_request_rec.bill_to_site_use_id);
627: FETCH c_party_site_id INTO l_service_request_rec.bill_to_site_id;
628: CLOSE c_party_site_id;
629: Debug('l_service_request_rec.bill_to_site_id ' ||l_service_request_rec.bill_to_site_id,l_mod_name,1);

Line 630: IF (nvl(l_service_request_rec.bill_to_site_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) THEN

626: OPEN c_party_site_id(l_service_request_rec.bill_to_site_use_id);
627: FETCH c_party_site_id INTO l_service_request_rec.bill_to_site_id;
628: CLOSE c_party_site_id;
629: Debug('l_service_request_rec.bill_to_site_id ' ||l_service_request_rec.bill_to_site_id,l_mod_name,1);
630: IF (nvl(l_service_request_rec.bill_to_site_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) THEN
631: OPEN c_party_id(l_service_request_rec.bill_to_site_id);
632: FETCH c_party_id INTO l_service_request_rec.bill_to_party_id;
633: CLOSE c_party_id;
634: Debug('l_service_request_rec.bill_to_party_id '||l_service_request_rec.bill_to_party_id,l_mod_name,1);

Line 640: IF (nvl(l_service_request_rec.ship_to_site_use_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) THEN

636: END IF;
637:
638: -- Ship-To fields
639: Debug('GETTING SHIP-TO FIELDS',l_mod_name,1);
640: IF (nvl(l_service_request_rec.ship_to_site_use_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) THEN
641: OPEN c_party_site_id(l_service_request_rec.ship_to_site_use_id);
642: FETCH c_party_site_id INTO l_service_request_rec.ship_to_site_id;
643: CLOSE c_party_site_id;
644: Debug('l_service_request_rec.ship_to_site_id ' ||l_service_request_rec.ship_to_site_id,l_mod_name,1);

Line 645: IF (nvl(l_service_request_rec.ship_to_site_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) THEN

641: OPEN c_party_site_id(l_service_request_rec.ship_to_site_use_id);
642: FETCH c_party_site_id INTO l_service_request_rec.ship_to_site_id;
643: CLOSE c_party_site_id;
644: Debug('l_service_request_rec.ship_to_site_id ' ||l_service_request_rec.ship_to_site_id,l_mod_name,1);
645: IF (nvl(l_service_request_rec.ship_to_site_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) THEN
646: OPEN c_party_id(l_service_request_rec.ship_to_site_id);
647: FETCH c_party_id INTO l_service_request_rec.ship_to_party_id;
648: CLOSE c_party_id;
649: Debug('l_service_request_rec.ship_to_party_id ' ||l_service_request_rec.ship_to_party_id,l_mod_name,1);

Line 690: p_init_msg_list => FND_API.G_TRUE,

686:
687: -- Call to Service Request API
688: CS_SERVICEREQUEST_PUB.Create_ServiceRequest(
689: p_api_version => 2.0,
690: p_init_msg_list => FND_API.G_TRUE,
691: p_commit => FND_API.G_FALSE,
692: x_return_status => l_return_status,
693: x_msg_count => l_msg_count,
694: x_msg_data => l_msg_data,

Line 691: p_commit => FND_API.G_FALSE,

687: -- Call to Service Request API
688: CS_SERVICEREQUEST_PUB.Create_ServiceRequest(
689: p_api_version => 2.0,
690: p_init_msg_list => FND_API.G_TRUE,
691: p_commit => FND_API.G_FALSE,
692: x_return_status => l_return_status,
693: x_msg_count => l_msg_count,
694: x_msg_data => l_msg_data,
695: p_resp_appl_id => NULL,

Line 710: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

706: x_request_number => l_incident_number,
707: x_interaction_id => ln_interaction_id,
708: x_workflow_process_id => ln_workflow_id);
709:
710: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
711: Debug( 'Create_servicerequest API failed',l_mod_name,1);
712: RAISE SKIP_RECORD;
713: END IF;
714: l_sr_count := l_sr_count + 1;

Line 759: l_rep_line_tbl(l_count).STATUS_REASON_CODE := FND_API.G_MISS_CHAR;

755: l_rep_line_tbl(l_count).UNIT_OF_MEASURE := C1.order_quantity_uom;
756: l_rep_line_tbl(l_count).REPAIR_TYPE_ID := l_repair_type_id ;
757: l_rep_line_tbl(l_count).REPAIR_MODE := l_repair_mode ;
758: l_rep_line_tbl(l_count).STATUS := 'O' ;
759: l_rep_line_tbl(l_count).STATUS_REASON_CODE := FND_API.G_MISS_CHAR;
760: l_rep_line_tbl(l_count).DATE_CLOSED := FND_API.G_MISS_DATE;
761: l_rep_line_tbl(l_count).APPROVAL_REQUIRED_FLAG := nvl(l_approval_flag,'N');
762: l_rep_line_tbl(l_count).APPROVAL_STATUS := FND_API.G_MISS_CHAR;
763: l_rep_line_tbl(l_count).QUANTITY := c1.shipped_quantity ;

Line 760: l_rep_line_tbl(l_count).DATE_CLOSED := FND_API.G_MISS_DATE;

756: l_rep_line_tbl(l_count).REPAIR_TYPE_ID := l_repair_type_id ;
757: l_rep_line_tbl(l_count).REPAIR_MODE := l_repair_mode ;
758: l_rep_line_tbl(l_count).STATUS := 'O' ;
759: l_rep_line_tbl(l_count).STATUS_REASON_CODE := FND_API.G_MISS_CHAR;
760: l_rep_line_tbl(l_count).DATE_CLOSED := FND_API.G_MISS_DATE;
761: l_rep_line_tbl(l_count).APPROVAL_REQUIRED_FLAG := nvl(l_approval_flag,'N');
762: l_rep_line_tbl(l_count).APPROVAL_STATUS := FND_API.G_MISS_CHAR;
763: l_rep_line_tbl(l_count).QUANTITY := c1.shipped_quantity ;
764: l_rep_line_tbl(l_count).QUANTITY_IN_WIP := FND_API.G_MISS_NUM;

Line 762: l_rep_line_tbl(l_count).APPROVAL_STATUS := FND_API.G_MISS_CHAR;

758: l_rep_line_tbl(l_count).STATUS := 'O' ;
759: l_rep_line_tbl(l_count).STATUS_REASON_CODE := FND_API.G_MISS_CHAR;
760: l_rep_line_tbl(l_count).DATE_CLOSED := FND_API.G_MISS_DATE;
761: l_rep_line_tbl(l_count).APPROVAL_REQUIRED_FLAG := nvl(l_approval_flag,'N');
762: l_rep_line_tbl(l_count).APPROVAL_STATUS := FND_API.G_MISS_CHAR;
763: l_rep_line_tbl(l_count).QUANTITY := c1.shipped_quantity ;
764: l_rep_line_tbl(l_count).QUANTITY_IN_WIP := FND_API.G_MISS_NUM;
765: l_rep_line_tbl(l_count).QUANTITY_RCVD := c1.shipped_quantity;
766: l_rep_line_tbl(l_count).QUANTITY_SHIPPED := FND_API.G_MISS_NUM;

Line 764: l_rep_line_tbl(l_count).QUANTITY_IN_WIP := FND_API.G_MISS_NUM;

760: l_rep_line_tbl(l_count).DATE_CLOSED := FND_API.G_MISS_DATE;
761: l_rep_line_tbl(l_count).APPROVAL_REQUIRED_FLAG := nvl(l_approval_flag,'N');
762: l_rep_line_tbl(l_count).APPROVAL_STATUS := FND_API.G_MISS_CHAR;
763: l_rep_line_tbl(l_count).QUANTITY := c1.shipped_quantity ;
764: l_rep_line_tbl(l_count).QUANTITY_IN_WIP := FND_API.G_MISS_NUM;
765: l_rep_line_tbl(l_count).QUANTITY_RCVD := c1.shipped_quantity;
766: l_rep_line_tbl(l_count).QUANTITY_SHIPPED := FND_API.G_MISS_NUM;
767: -- Vijay:3840775: change default for group id to null from g_miss_num
768: l_rep_line_tbl(l_count).REPAIR_GROUP_ID := null;

Line 766: l_rep_line_tbl(l_count).QUANTITY_SHIPPED := FND_API.G_MISS_NUM;

762: l_rep_line_tbl(l_count).APPROVAL_STATUS := FND_API.G_MISS_CHAR;
763: l_rep_line_tbl(l_count).QUANTITY := c1.shipped_quantity ;
764: l_rep_line_tbl(l_count).QUANTITY_IN_WIP := FND_API.G_MISS_NUM;
765: l_rep_line_tbl(l_count).QUANTITY_RCVD := c1.shipped_quantity;
766: l_rep_line_tbl(l_count).QUANTITY_SHIPPED := FND_API.G_MISS_NUM;
767: -- Vijay:3840775: change default for group id to null from g_miss_num
768: l_rep_line_tbl(l_count).REPAIR_GROUP_ID := null;
769: l_rep_line_tbl(l_count).RO_TXN_STATUS := 'OM_BOOKED' ;
770: l_rep_line_tbl(l_count).SERIAL_NUMBER := FND_API.G_MISS_CHAR;

Line 770: l_rep_line_tbl(l_count).SERIAL_NUMBER := FND_API.G_MISS_CHAR;

766: l_rep_line_tbl(l_count).QUANTITY_SHIPPED := FND_API.G_MISS_NUM;
767: -- Vijay:3840775: change default for group id to null from g_miss_num
768: l_rep_line_tbl(l_count).REPAIR_GROUP_ID := null;
769: l_rep_line_tbl(l_count).RO_TXN_STATUS := 'OM_BOOKED' ;
770: l_rep_line_tbl(l_count).SERIAL_NUMBER := FND_API.G_MISS_CHAR;
771: l_rep_line_tbl(l_count).REPAIR_NUMBER := FND_API.G_MISS_CHAR;
772: l_rep_line_tbl(l_count).original_source_reference := 'RMA';
773: l_rep_line_tbl(l_count).original_source_header_id := c1.rma_header_id;
774: l_rep_line_tbl(l_count).original_source_line_id := c1.line_id;

Line 771: l_rep_line_tbl(l_count).REPAIR_NUMBER := FND_API.G_MISS_CHAR;

767: -- Vijay:3840775: change default for group id to null from g_miss_num
768: l_rep_line_tbl(l_count).REPAIR_GROUP_ID := null;
769: l_rep_line_tbl(l_count).RO_TXN_STATUS := 'OM_BOOKED' ;
770: l_rep_line_tbl(l_count).SERIAL_NUMBER := FND_API.G_MISS_CHAR;
771: l_rep_line_tbl(l_count).REPAIR_NUMBER := FND_API.G_MISS_CHAR;
772: l_rep_line_tbl(l_count).original_source_reference := 'RMA';
773: l_rep_line_tbl(l_count).original_source_header_id := c1.rma_header_id;
774: l_rep_line_tbl(l_count).original_source_line_id := c1.line_id;
775: l_rep_line_tbl(l_count).currency_code := c1.transactional_curr_code;

Line 805: l_instance_id := FND_API.G_MISS_NUM;

801: fnd_message.set_token('SERIAL_NUM', C2.serial_num);
802: fnd_msg_pub.add;
803: END IF;
804: Debug( 'Instance Id could not be found='||c2.serial_num,l_mod_name,1);
805: l_instance_id := FND_API.G_MISS_NUM;
806: End;
807:
808: -- Increment the counter
809: l_count := l_count +1;

Line 817: l_rep_line_tbl(l_count).STATUS_REASON_CODE := FND_API.G_MISS_CHAR;

813: l_rep_line_tbl(l_count).UNIT_OF_MEASURE := C1.order_quantity_uom;
814: l_rep_line_tbl(l_count).REPAIR_TYPE_ID := l_repair_type_id ;
815: l_rep_line_tbl(l_count).REPAIR_MODE := l_repair_mode ;
816: l_rep_line_tbl(l_count).STATUS := 'O' ;
817: l_rep_line_tbl(l_count).STATUS_REASON_CODE := FND_API.G_MISS_CHAR;
818: l_rep_line_tbl(l_count).DATE_CLOSED := FND_API.G_MISS_DATE;
819: l_rep_line_tbl(l_count).APPROVAL_REQUIRED_FLAG := nvl(l_approval_flag,'N');
820: l_rep_line_tbl(l_count).APPROVAL_STATUS := FND_API.G_MISS_CHAR;
821: l_rep_line_tbl(l_count).QUANTITY := 1 ;

Line 818: l_rep_line_tbl(l_count).DATE_CLOSED := FND_API.G_MISS_DATE;

814: l_rep_line_tbl(l_count).REPAIR_TYPE_ID := l_repair_type_id ;
815: l_rep_line_tbl(l_count).REPAIR_MODE := l_repair_mode ;
816: l_rep_line_tbl(l_count).STATUS := 'O' ;
817: l_rep_line_tbl(l_count).STATUS_REASON_CODE := FND_API.G_MISS_CHAR;
818: l_rep_line_tbl(l_count).DATE_CLOSED := FND_API.G_MISS_DATE;
819: l_rep_line_tbl(l_count).APPROVAL_REQUIRED_FLAG := nvl(l_approval_flag,'N');
820: l_rep_line_tbl(l_count).APPROVAL_STATUS := FND_API.G_MISS_CHAR;
821: l_rep_line_tbl(l_count).QUANTITY := 1 ;
822: l_rep_line_tbl(l_count).QUANTITY_IN_WIP := FND_API.G_MISS_NUM;

Line 820: l_rep_line_tbl(l_count).APPROVAL_STATUS := FND_API.G_MISS_CHAR;

816: l_rep_line_tbl(l_count).STATUS := 'O' ;
817: l_rep_line_tbl(l_count).STATUS_REASON_CODE := FND_API.G_MISS_CHAR;
818: l_rep_line_tbl(l_count).DATE_CLOSED := FND_API.G_MISS_DATE;
819: l_rep_line_tbl(l_count).APPROVAL_REQUIRED_FLAG := nvl(l_approval_flag,'N');
820: l_rep_line_tbl(l_count).APPROVAL_STATUS := FND_API.G_MISS_CHAR;
821: l_rep_line_tbl(l_count).QUANTITY := 1 ;
822: l_rep_line_tbl(l_count).QUANTITY_IN_WIP := FND_API.G_MISS_NUM;
823: l_rep_line_tbl(l_count).QUANTITY_RCVD := 1;
824: l_rep_line_tbl(l_count).QUANTITY_SHIPPED := FND_API.G_MISS_NUM;

Line 822: l_rep_line_tbl(l_count).QUANTITY_IN_WIP := FND_API.G_MISS_NUM;

818: l_rep_line_tbl(l_count).DATE_CLOSED := FND_API.G_MISS_DATE;
819: l_rep_line_tbl(l_count).APPROVAL_REQUIRED_FLAG := nvl(l_approval_flag,'N');
820: l_rep_line_tbl(l_count).APPROVAL_STATUS := FND_API.G_MISS_CHAR;
821: l_rep_line_tbl(l_count).QUANTITY := 1 ;
822: l_rep_line_tbl(l_count).QUANTITY_IN_WIP := FND_API.G_MISS_NUM;
823: l_rep_line_tbl(l_count).QUANTITY_RCVD := 1;
824: l_rep_line_tbl(l_count).QUANTITY_SHIPPED := FND_API.G_MISS_NUM;
825: -- Vijay:3840775: change default for group id to null from g_miss_num
826: l_rep_line_tbl(l_count).REPAIR_GROUP_ID := null;

Line 824: l_rep_line_tbl(l_count).QUANTITY_SHIPPED := FND_API.G_MISS_NUM;

820: l_rep_line_tbl(l_count).APPROVAL_STATUS := FND_API.G_MISS_CHAR;
821: l_rep_line_tbl(l_count).QUANTITY := 1 ;
822: l_rep_line_tbl(l_count).QUANTITY_IN_WIP := FND_API.G_MISS_NUM;
823: l_rep_line_tbl(l_count).QUANTITY_RCVD := 1;
824: l_rep_line_tbl(l_count).QUANTITY_SHIPPED := FND_API.G_MISS_NUM;
825: -- Vijay:3840775: change default for group id to null from g_miss_num
826: l_rep_line_tbl(l_count).REPAIR_GROUP_ID := null;
827: l_rep_line_tbl(l_count).RO_TXN_STATUS := 'OM_BOOKED' ;
828: l_rep_line_tbl(l_count).SERIAL_NUMBER := C2.serial_num;

Line 830: l_rep_line_tbl(l_count).REPAIR_NUMBER := FND_API.G_MISS_CHAR;

826: l_rep_line_tbl(l_count).REPAIR_GROUP_ID := null;
827: l_rep_line_tbl(l_count).RO_TXN_STATUS := 'OM_BOOKED' ;
828: l_rep_line_tbl(l_count).SERIAL_NUMBER := C2.serial_num;
829: l_rep_line_tbl(l_count).CUSTOMER_PRODUCT_ID := l_instance_id;
830: l_rep_line_tbl(l_count).REPAIR_NUMBER := FND_API.G_MISS_CHAR;
831: l_rep_line_tbl(l_count).original_source_reference := 'RMA';
832: l_rep_line_tbl(l_count).original_source_header_id := c1.rma_header_id;
833: l_rep_line_tbl(l_count).original_source_line_id := c1.line_id;
834: l_rep_line_tbl(l_count).currency_code := c1.transactional_curr_code;

Line 854: P_Init_Msg_List => FND_API.G_TRUE,

850:
851: Debug( 'Calling CSD_REPAIRS_PVT.Create_Repair_Order',l_mod_name,1);
852: CSD_REPAIRS_PVT.Create_Repair_Order
853: ( P_Api_Version_Number => 1.0,
854: P_Init_Msg_List => FND_API.G_TRUE,
855: P_Commit => FND_API.G_FALSE,
856: p_validation_level => fnd_api.g_valid_level_full,
857: p_Repair_line_id => l_REPAIR_line_id,
858: P_REPLN_Rec => l_rep_line_tbl(i) ,

Line 855: P_Commit => FND_API.G_FALSE,

851: Debug( 'Calling CSD_REPAIRS_PVT.Create_Repair_Order',l_mod_name,1);
852: CSD_REPAIRS_PVT.Create_Repair_Order
853: ( P_Api_Version_Number => 1.0,
854: P_Init_Msg_List => FND_API.G_TRUE,
855: P_Commit => FND_API.G_FALSE,
856: p_validation_level => fnd_api.g_valid_level_full,
857: p_Repair_line_id => l_REPAIR_line_id,
858: P_REPLN_Rec => l_rep_line_tbl(i) ,
859: X_REPAIR_LINE_ID => l_REPAIR_LINE_ID,

Line 856: p_validation_level => fnd_api.g_valid_level_full,

852: CSD_REPAIRS_PVT.Create_Repair_Order
853: ( P_Api_Version_Number => 1.0,
854: P_Init_Msg_List => FND_API.G_TRUE,
855: P_Commit => FND_API.G_FALSE,
856: p_validation_level => fnd_api.g_valid_level_full,
857: p_Repair_line_id => l_REPAIR_line_id,
858: P_REPLN_Rec => l_rep_line_tbl(i) ,
859: X_REPAIR_LINE_ID => l_REPAIR_LINE_ID,
860: X_REPAIR_NUMBER => l_REPAIR_NUMBER,

Line 865: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

861: X_Return_Status => l_return_status,
862: X_Msg_Count => l_msg_count,
863: X_Msg_Data => l_msg_data );
864:
865: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
866: Debug( 'Create Repair Order API failed',l_mod_name,1);
867: RAISE SKIP_RO;
868: END IF;
869:

Line 945: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

941: X_Return_Status => l_return_status,
942: X_Msg_Count => l_msg_count,
943: X_Msg_Data => l_msg_data );
944:
945: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
946: Debug( 'Validate_And_Write failed ',l_mod_name,1);
947: RAISE SKIP_RO;
948: END IF;
949:

Line 1044: WHEN FND_API.G_EXC_ERROR THEN

1040: -- Commit
1041: COMMIT WORK;
1042:
1043: EXCEPTION
1044: WHEN FND_API.G_EXC_ERROR THEN
1045: ROLLBACK TO process_rma;
1046: if(fnd_msg_pub.count_msg > 0 ) then
1047: for i in 1..fnd_msg_pub.count_msg
1048: loop