126: AND hcsu.site_use_id = p_cust_site_use_id ;
127: Exception
128: When No_Data_found then
129: IF ( l_error_level >= G_debug_level) THEN
130: fnd_message.set_name('CSD','CSD_INV_PTY_SITE_USE_ID');
131: fnd_message.set_token('CUST_SITE_USE_ID',p_cust_site_use_id );
132: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
133: ELSE
134: fnd_message.set_name('CSD','CSD_INV_PTY_SITE_USE_ID');
127: Exception
128: When No_Data_found then
129: IF ( l_error_level >= G_debug_level) THEN
130: fnd_message.set_name('CSD','CSD_INV_PTY_SITE_USE_ID');
131: fnd_message.set_token('CUST_SITE_USE_ID',p_cust_site_use_id );
132: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
133: ELSE
134: fnd_message.set_name('CSD','CSD_INV_PTY_SITE_USE_ID');
135: fnd_message.set_token('CUST_SITE_USE_ID',p_cust_site_use_id );
130: fnd_message.set_name('CSD','CSD_INV_PTY_SITE_USE_ID');
131: fnd_message.set_token('CUST_SITE_USE_ID',p_cust_site_use_id );
132: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
133: ELSE
134: fnd_message.set_name('CSD','CSD_INV_PTY_SITE_USE_ID');
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);
131: fnd_message.set_token('CUST_SITE_USE_ID',p_cust_site_use_id );
132: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
133: ELSE
134: fnd_message.set_name('CSD','CSD_INV_PTY_SITE_USE_ID');
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 ;
153: AND hps.party_site_id = hpsu.party_site_id;
154: Exception
155: When No_Data_found then
156: IF ( l_error_level >= G_debug_level) THEN
157: fnd_message.set_name('CSD','CSD_INV_PTY_SITE_ID');
158: fnd_message.set_token('PTY_SITE_ID',l_party_site_id);
159: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
160: ELSE
161: fnd_message.set_name('CSD','CSD_INV_PTY_SITE_ID');
154: Exception
155: When No_Data_found then
156: IF ( l_error_level >= G_debug_level) THEN
157: fnd_message.set_name('CSD','CSD_INV_PTY_SITE_ID');
158: fnd_message.set_token('PTY_SITE_ID',l_party_site_id);
159: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
160: ELSE
161: fnd_message.set_name('CSD','CSD_INV_PTY_SITE_ID');
162: fnd_message.set_token('PTY_SITE_ID',l_party_site_id);
157: fnd_message.set_name('CSD','CSD_INV_PTY_SITE_ID');
158: fnd_message.set_token('PTY_SITE_ID',l_party_site_id);
159: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
160: ELSE
161: fnd_message.set_name('CSD','CSD_INV_PTY_SITE_ID');
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);
158: fnd_message.set_token('PTY_SITE_ID',l_party_site_id);
159: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
160: ELSE
161: fnd_message.set_name('CSD','CSD_INV_PTY_SITE_ID');
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 ;
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);
171: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
172: ELSE
173: fnd_message.set_name('CSD','CSD_INV_PTY_SITE_ID');
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);
171: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
172: ELSE
173: fnd_message.set_name('CSD','CSD_INV_PTY_SITE_ID');
174: fnd_message.set_token('PTY_SITE_ID',l_party_site_id);
169: fnd_message.set_name('CSD','CSD_INV_PTY_SITE_ID');
170: fnd_message.set_token('PTY_SITE_ID',l_party_site_id);
171: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
172: ELSE
173: fnd_message.set_name('CSD','CSD_INV_PTY_SITE_ID');
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);
170: fnd_message.set_token('PTY_SITE_ID',l_party_site_id);
171: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
172: ELSE
173: fnd_message.set_name('CSD','CSD_INV_PTY_SITE_ID');
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 ;
358:
359: IF p_inventory_org_id is NULL OR
360: p_subinventory_name is NULL then
361: IF ( l_error_level >= G_debug_level) THEN
362: fnd_message.set_name('CSD','CSD_PARAMETERS_MISSING');
363: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
364: ELSE
365: fnd_message.set_name('CSD','CSD_PARAMETERS_MISSING');
366: fnd_msg_pub.add;
361: IF ( l_error_level >= G_debug_level) THEN
362: fnd_message.set_name('CSD','CSD_PARAMETERS_MISSING');
363: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
364: ELSE
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 ;
380: -- when profile is not defined
381: -- l_inc_work_summary := FND_PROFILE.value('CSD_OM_SR_WORK_SUMMARY');
382: FND_PROFILE.Get('CSD_OM_SR_WORK_SUMMARY',l_Inc_Work_Summary);
383: if l_Inc_Work_Summary is Null Then
384: Fnd_Message.Set_Name('CSD','CSD_SR_WORK_SUMMARY_RMA');
385: l_Inc_Work_Summary := Fnd_Message.Get;
386: End If;
387:
388: -- Default values for RO
381: -- l_inc_work_summary := FND_PROFILE.value('CSD_OM_SR_WORK_SUMMARY');
382: FND_PROFILE.Get('CSD_OM_SR_WORK_SUMMARY',l_Inc_Work_Summary);
383: if l_Inc_Work_Summary is Null Then
384: Fnd_Message.Set_Name('CSD','CSD_SR_WORK_SUMMARY_RMA');
385: l_Inc_Work_Summary := Fnd_Message.Get;
386: End If;
387:
388: -- Default values for RO
389: l_ro_owner_id := FND_PROFILE.value('CSD_OM_RO_DEFAULT_OWNER');
395: l_inc_severity_id is NULL OR
396: l_inc_urgency_id is NULL OR
397: l_inc_work_summary is NULL THEN
398: IF ( l_error_level >= G_debug_level) THEN
399: fnd_message.set_name('CSD','CSD_PROF_SETUP_MISSING');
400: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
401: ELSE
402: fnd_message.set_name('CSD','CSD_PROF_SETUP_MISSING');
403: fnd_msg_pub.add;
398: IF ( l_error_level >= G_debug_level) THEN
399: fnd_message.set_name('CSD','CSD_PROF_SETUP_MISSING');
400: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
401: ELSE
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 ;
420: and seeded_flag = 'Y';
421: Exception
422: When No_Data_found then
423: IF ( l_error_level >= G_debug_level) THEN
424: fnd_message.set_name('CSD','CSD_STD_REP_TYPE_MISSING');
425: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
426: ELSE
427: fnd_message.set_name('CSD','CSD_STD_REP_TYPE_MISSING');
428: fnd_msg_pub.add;
423: IF ( l_error_level >= G_debug_level) THEN
424: fnd_message.set_name('CSD','CSD_STD_REP_TYPE_MISSING');
425: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
426: ELSE
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 ;
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);
436: ELSE
437: fnd_message.set_name('CSD','CSD_STD_REP_TYPE_MISSING');
438: fnd_msg_pub.add;
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);
436: ELSE
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 ;
450: where organization_id = p_inventory_org_id;
451: Exception
452: When No_Data_found then
453: IF ( l_error_level >= G_debug_level) THEN
454: fnd_message.set_name('CSD','CSD_INVALID_INV_ORG_ID');
455: fnd_message.set_token('INV_ORG_ID',p_inventory_org_id);
456: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
457: ELSE
458: fnd_message.set_name('CSD','CSD_INVALID_INV_ORG_ID');
451: Exception
452: When No_Data_found then
453: IF ( l_error_level >= G_debug_level) THEN
454: fnd_message.set_name('CSD','CSD_INVALID_INV_ORG_ID');
455: fnd_message.set_token('INV_ORG_ID',p_inventory_org_id);
456: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
457: ELSE
458: fnd_message.set_name('CSD','CSD_INVALID_INV_ORG_ID');
459: fnd_message.set_token('INV_ORG_ID',p_inventory_org_id);
454: fnd_message.set_name('CSD','CSD_INVALID_INV_ORG_ID');
455: fnd_message.set_token('INV_ORG_ID',p_inventory_org_id);
456: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
457: ELSE
458: fnd_message.set_name('CSD','CSD_INVALID_INV_ORG_ID');
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);
455: fnd_message.set_token('INV_ORG_ID',p_inventory_org_id);
456: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
457: ELSE
458: fnd_message.set_name('CSD','CSD_INVALID_INV_ORG_ID');
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 ;
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);
468: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
469: ELSE
470: fnd_message.set_name('CSD','CSD_INVALID_INV_ORG_ID');
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);
468: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
469: ELSE
470: fnd_message.set_name('CSD','CSD_INVALID_INV_ORG_ID');
471: fnd_message.set_token('INV_ORG_ID',p_inventory_org_id);
466: fnd_message.set_name('CSD','CSD_INVALID_INV_ORG_ID');
467: fnd_message.set_token('INV_ORG_ID',p_inventory_org_id);
468: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
469: ELSE
470: fnd_message.set_name('CSD','CSD_INVALID_INV_ORG_ID');
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);
467: fnd_message.set_token('INV_ORG_ID',p_inventory_org_id);
468: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
469: ELSE
470: fnd_message.set_name('CSD','CSD_INVALID_INV_ORG_ID');
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 ;
485: and secondary_inventory_name = p_subinventory_name ;
486: Exception
487: When No_Data_found then
488: IF ( l_error_level >= G_debug_level) THEN
489: fnd_message.set_name('CSD','CSD_INVALID_SUB_INV');
490: fnd_message.set_token('SUB_INV',p_subinventory_name );
491: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
492: ELSE
493: fnd_message.set_name('CSD','CSD_INVALID_SUB_INV');
486: Exception
487: When No_Data_found then
488: IF ( l_error_level >= G_debug_level) THEN
489: fnd_message.set_name('CSD','CSD_INVALID_SUB_INV');
490: fnd_message.set_token('SUB_INV',p_subinventory_name );
491: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
492: ELSE
493: fnd_message.set_name('CSD','CSD_INVALID_SUB_INV');
494: fnd_message.set_token('SUB_INV',p_subinventory_name );
489: fnd_message.set_name('CSD','CSD_INVALID_SUB_INV');
490: fnd_message.set_token('SUB_INV',p_subinventory_name );
491: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
492: ELSE
493: fnd_message.set_name('CSD','CSD_INVALID_SUB_INV');
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 );
490: fnd_message.set_token('SUB_INV',p_subinventory_name );
491: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
492: ELSE
493: fnd_message.set_name('CSD','CSD_INVALID_SUB_INV');
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 ;
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 );
503: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
504: ELSE
505: fnd_message.set_name('CSD','CSD_INVALID_SUB_INV');
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 );
503: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
504: ELSE
505: fnd_message.set_name('CSD','CSD_INVALID_SUB_INV');
506: fnd_message.set_token('SUB_INV',p_subinventory_name );
501: fnd_message.set_name('CSD','CSD_INVALID_SUB_INV');
502: fnd_message.set_token('SUB_INV',p_subinventory_name );
503: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
504: ELSE
505: fnd_message.set_name('CSD','CSD_INVALID_SUB_INV');
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 );
502: fnd_message.set_token('SUB_INV',p_subinventory_name );
503: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
504: ELSE
505: fnd_message.set_name('CSD','CSD_INVALID_SUB_INV');
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 ;
728: Debug( 'Inv Item is serialized Inv Item Id='||to_char(c1.inventory_item_id),l_mod_name,1);
729: Exception
730: When No_Data_Found then
731: IF ( l_error_level >= G_debug_level) THEN
732: fnd_message.set_name('CSD','CSD_INV_ITEM_ID');
733: fnd_message.set_token('ITEM_ID',c1.inventory_item_id);
734: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
735: ELSE
736: fnd_message.set_name('CSD','CSD_INV_ITEM_ID');
729: Exception
730: When No_Data_Found then
731: IF ( l_error_level >= G_debug_level) THEN
732: fnd_message.set_name('CSD','CSD_INV_ITEM_ID');
733: fnd_message.set_token('ITEM_ID',c1.inventory_item_id);
734: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
735: ELSE
736: fnd_message.set_name('CSD','CSD_INV_ITEM_ID');
737: fnd_message.set_token('ITEM_ID',c1.inventory_item_id);
732: fnd_message.set_name('CSD','CSD_INV_ITEM_ID');
733: fnd_message.set_token('ITEM_ID',c1.inventory_item_id);
734: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
735: ELSE
736: fnd_message.set_name('CSD','CSD_INV_ITEM_ID');
737: fnd_message.set_token('ITEM_ID',c1.inventory_item_id);
738: fnd_msg_pub.add;
739: END IF;
740: l_serialized_flag := FALSE;
733: fnd_message.set_token('ITEM_ID',c1.inventory_item_id);
734: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
735: ELSE
736: fnd_message.set_name('CSD','CSD_INV_ITEM_ID');
737: fnd_message.set_token('ITEM_ID',c1.inventory_item_id);
738: fnd_msg_pub.add;
739: END IF;
740: l_serialized_flag := FALSE;
741: Debug( 'Inv Item is Non-serialized Inv Item Id='||to_char(c1.inventory_item_id),l_mod_name,1);
792: and owner_party_id = C1.party_id;
793: Exception
794: When No_Data_Found then
795: IF ( l_error_level >= G_debug_level) THEN
796: fnd_message.set_name('CSD','CSD_IB_INSTANCE_MISSING');
797: fnd_message.set_token('SERIAL_NUM', C2.serial_num);
798: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
799: ELSE
800: fnd_message.set_name('CSD','CSD_IB_INSTANCE_MISSING');
793: Exception
794: When No_Data_Found then
795: IF ( l_error_level >= G_debug_level) THEN
796: fnd_message.set_name('CSD','CSD_IB_INSTANCE_MISSING');
797: fnd_message.set_token('SERIAL_NUM', C2.serial_num);
798: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
799: ELSE
800: fnd_message.set_name('CSD','CSD_IB_INSTANCE_MISSING');
801: fnd_message.set_token('SERIAL_NUM', C2.serial_num);
796: fnd_message.set_name('CSD','CSD_IB_INSTANCE_MISSING');
797: fnd_message.set_token('SERIAL_NUM', C2.serial_num);
798: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
799: ELSE
800: fnd_message.set_name('CSD','CSD_IB_INSTANCE_MISSING');
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);
797: fnd_message.set_token('SERIAL_NUM', C2.serial_num);
798: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
799: ELSE
800: fnd_message.set_name('CSD','CSD_IB_INSTANCE_MISSING');
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;