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.MTL_CROSS_REFERENCES_PVT dependencies on FND_API

Line 39: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

35: -- -----------------------------------------------------------------------------
36:
37:
38: PROCEDURE Process_XRef(
39: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
40: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
41: ,p_XRef_Tbl IN OUT NOCOPY MTL_CROSS_REFERENCES_PUB.XRef_Tbl_Type
42: ,x_return_status OUT NOCOPY VARCHAR2
43: ,x_msg_count OUT NOCOPY NUMBER

Line 40: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

36:
37:
38: PROCEDURE Process_XRef(
39: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
40: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
41: ,p_XRef_Tbl IN OUT NOCOPY MTL_CROSS_REFERENCES_PUB.XRef_Tbl_Type
42: ,x_return_status OUT NOCOPY VARCHAR2
43: ,x_msg_count OUT NOCOPY NUMBER
44: ,x_message_list OUT NOCOPY Error_Handler.Error_Tbl_Type) IS

Line 137: X_return_status:= FND_API.G_RET_STS_SUCCESS ;

133:
134: BEGIN
135:
136: SAVEPOINT MTL_CROSS_REFERENCES_PVT;
137: X_return_status:= FND_API.G_RET_STS_SUCCESS ;
138:
139: l_gtin_msg_count := 0;
140:
141: l_XRef_Tbl := p_XRef_Tbl;

Line 146: IF FND_API.To_Boolean (p_init_msg_list) THEN

142: l_prod_exists := 'y';
143: l_pim_exists := 'y';
144:
145: -- Initialize message list
146: IF FND_API.To_Boolean (p_init_msg_list) THEN
147: Error_Handler.Initialize;
148: END IF;
149: G_Xref_Indx := 0; -- making sure record index is reset
150: Write_Debug('Starting to process cross reference records...');

Line 164: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;

160: IF (l_XRef_Rec.Transaction_Type IS NULL ) OR
161: (l_XRef_Rec.Transaction_Type <> 'CREATE' AND l_XRef_Rec.Transaction_Type <> 'UPDATE' AND
162: l_XRef_Rec.Transaction_Type <> 'DELETE') THEN
163:
164: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
165: Error_Handler.Add_Error_Message
166: (
167: p_message_name => 'INV_XREF_INVALID_TRANS_TYPE'
168: ,p_application_id => 'INV'

Line 231: AND l_XRef_Rec.Inventory_Item_Id<>FND_API.G_MISS_NUM then

227: END IF;
228: END IF;
229: -- checking for item existance in MSIB
230: IF l_XRef_Rec.Inventory_Item_Id IS NOT NULL
231: AND l_XRef_Rec.Inventory_Item_Id<>FND_API.G_MISS_NUM then
232:
233: BEGIN
234: SELECT 'x' INTO l_exists
235: FROM mtl_system_items_b

Line 239: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;

235: FROM mtl_system_items_b
236: WHERE inventory_item_id =l_XRef_Rec.Inventory_Item_Id;
237: EXCEPTION
238: WHEN NO_DATA_FOUND THEN
239: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
240: Error_Handler.Add_Error_Message
241: (
242: p_message_name => 'INV-NO ITEM RECORD'
243: ,p_application_id => 'INV'

Line 257: IF l_XRef_rec.org_independent_flag NOT IN ('Y','N',FND_API.G_MISS_CHAR) THEN

253: END IF;
254:
255: -- Invalid value for org_indep_flag
256:
257: IF l_XRef_rec.org_independent_flag NOT IN ('Y','N',FND_API.G_MISS_CHAR) THEN
258:
259: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
260: Error_Handler.Add_Error_Message
261: (

Line 259: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;

255: -- Invalid value for org_indep_flag
256:
257: IF l_XRef_rec.org_independent_flag NOT IN ('Y','N',FND_API.G_MISS_CHAR) THEN
258:
259: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
260: Error_Handler.Add_Error_Message
261: (
262: p_message_name => 'INV_XREF_INVALID_ORG_FLAG'
263: ,p_application_id => 'INV'

Line 275: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;

271:
272: -- SS_ITEM_XREF not supported.
273: IF l_XRef_rec.Cross_Reference_Type ='SS_ITEM_XREF' THEN
274:
275: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
276: Error_Handler.Add_Error_Message
277: (
278: p_message_name => 'INV_XREF_INVALID_TYPES'
279: ,p_application_id => 'INV'

Line 290: AND l_XRef_Rec.Cross_Reference_Type<> FND_API.G_MISS_CHAR THEN

286: END IF;
287:
288: -- cross reference type validations
289: IF l_XRef_Rec.Cross_Reference_Type IS NOT NULL
290: AND l_XRef_Rec.Cross_Reference_Type<> FND_API.G_MISS_CHAR THEN
291:
292: BEGIN -- cross reference type existance
293: SELECT 'x' INTO l_exists
294: FROM MTL_CROSS_REFERENCE_TYPES

Line 299: l_XRef_Rec.x_return_status :=FND_API.g_RET_STS_ERROR;

295: WHERE cross_reference_type =l_XRef_Rec.Cross_Reference_Type
296: AND trunc(nvl(disable_date,sysdate)) >= trunc(sysdate);
297: EXCEPTION
298: WHEN NO_DATA_FOUND THEN
299: l_XRef_Rec.x_return_status :=FND_API.g_RET_STS_ERROR;
300: l_Token_Tbl(1).Token_Name := 'CROSS_REFERENCE_TYPE';
301: l_Token_Tbl(1).Token_Value := l_XRef_Rec.Cross_Reference_Type;
302: l_Token_Tbl(1).Translate := FALSE;
303: Error_Handler.Add_Error_Message

Line 322: IF l_XRef_Rec.Inventory_Item_Id IS NULL OR l_XRef_Rec.Inventory_Item_Id =FND_API.G_MISS_NUM

318:
319: IF l_XRef_Rec.Transaction_Type = 'CREATE' THEN
320:
321: -- Should not leave PK columns blank and cannot pass NULL to these Columns.
322: IF l_XRef_Rec.Inventory_Item_Id IS NULL OR l_XRef_Rec.Inventory_Item_Id =FND_API.G_MISS_NUM
323: OR l_XRef_Rec.Cross_Reference_Type IS NULL OR l_XRef_Rec.Cross_Reference_Type =FND_API.G_MISS_CHAR
324: OR l_XRef_Rec.Cross_Reference IS NULL OR l_XRef_Rec.Cross_Reference=FND_API.G_MISS_CHAR THEN
325:
326: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;

Line 323: OR l_XRef_Rec.Cross_Reference_Type IS NULL OR l_XRef_Rec.Cross_Reference_Type =FND_API.G_MISS_CHAR

319: IF l_XRef_Rec.Transaction_Type = 'CREATE' THEN
320:
321: -- Should not leave PK columns blank and cannot pass NULL to these Columns.
322: IF l_XRef_Rec.Inventory_Item_Id IS NULL OR l_XRef_Rec.Inventory_Item_Id =FND_API.G_MISS_NUM
323: OR l_XRef_Rec.Cross_Reference_Type IS NULL OR l_XRef_Rec.Cross_Reference_Type =FND_API.G_MISS_CHAR
324: OR l_XRef_Rec.Cross_Reference IS NULL OR l_XRef_Rec.Cross_Reference=FND_API.G_MISS_CHAR THEN
325:
326: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
327: Error_Handler.Add_Error_Message

Line 324: OR l_XRef_Rec.Cross_Reference IS NULL OR l_XRef_Rec.Cross_Reference=FND_API.G_MISS_CHAR THEN

320:
321: -- Should not leave PK columns blank and cannot pass NULL to these Columns.
322: IF l_XRef_Rec.Inventory_Item_Id IS NULL OR l_XRef_Rec.Inventory_Item_Id =FND_API.G_MISS_NUM
323: OR l_XRef_Rec.Cross_Reference_Type IS NULL OR l_XRef_Rec.Cross_Reference_Type =FND_API.G_MISS_CHAR
324: OR l_XRef_Rec.Cross_Reference IS NULL OR l_XRef_Rec.Cross_Reference=FND_API.G_MISS_CHAR THEN
325:
326: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
327: Error_Handler.Add_Error_Message
328: (

Line 326: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;

322: IF l_XRef_Rec.Inventory_Item_Id IS NULL OR l_XRef_Rec.Inventory_Item_Id =FND_API.G_MISS_NUM
323: OR l_XRef_Rec.Cross_Reference_Type IS NULL OR l_XRef_Rec.Cross_Reference_Type =FND_API.G_MISS_CHAR
324: OR l_XRef_Rec.Cross_Reference IS NULL OR l_XRef_Rec.Cross_Reference=FND_API.G_MISS_CHAR THEN
325:
326: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
327: Error_Handler.Add_Error_Message
328: (
329: p_message_name => 'INV_XREF_NULL_COLS'
330: ,p_application_id => 'INV'

Line 341: AND l_XRef_Rec.Organization_Id <>FND_API.G_MISS_NUM THEN

337: END IF;
338:
339: -- organization validation -- both org_indp_flag and org_id should not be NOT NULL
340: IF l_XRef_Rec.Organization_Id IS NOT NULL
341: AND l_XRef_Rec.Organization_Id <>FND_API.G_MISS_NUM THEN
342:
343: IF l_XRef_Rec.Org_Independent_Flag='Y' THEN
344: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
345: Error_Handler.Add_Error_Message

Line 344: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;

340: IF l_XRef_Rec.Organization_Id IS NOT NULL
341: AND l_XRef_Rec.Organization_Id <>FND_API.G_MISS_NUM THEN
342:
343: IF l_XRef_Rec.Org_Independent_Flag='Y' THEN
344: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
345: Error_Handler.Add_Error_Message
346: (
347: p_message_name => 'INV_XREF_ORG_FLAG'
348: ,p_application_id => 'INV'

Line 360: OR l_XRef_Rec.Organization_Id = FND_API.G_MISS_NUM THEN

356: END IF;
357:
358: -- Org_Id and Org_Indp_Flag both NULL.
359: IF l_XRef_Rec.Organization_Id IS NULL
360: OR l_XRef_Rec.Organization_Id = FND_API.G_MISS_NUM THEN
361:
362: IF l_XRef_Rec.Org_Independent_Flag IS NULL
363: OR l_XRef_Rec.Org_Independent_Flag=FND_API.G_MISS_CHAR
364: OR l_XRef_Rec.Org_Independent_Flag <>'Y' THEN

Line 363: OR l_XRef_Rec.Org_Independent_Flag=FND_API.G_MISS_CHAR

359: IF l_XRef_Rec.Organization_Id IS NULL
360: OR l_XRef_Rec.Organization_Id = FND_API.G_MISS_NUM THEN
361:
362: IF l_XRef_Rec.Org_Independent_Flag IS NULL
363: OR l_XRef_Rec.Org_Independent_Flag=FND_API.G_MISS_CHAR
364: OR l_XRef_Rec.Org_Independent_Flag <>'Y' THEN
365:
366: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
367: Error_Handler.Add_Error_Message

Line 366: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;

362: IF l_XRef_Rec.Org_Independent_Flag IS NULL
363: OR l_XRef_Rec.Org_Independent_Flag=FND_API.G_MISS_CHAR
364: OR l_XRef_Rec.Org_Independent_Flag <>'Y' THEN
365:
366: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
367: Error_Handler.Add_Error_Message
368: (
369: p_message_name => 'INV_XREF_NULL_ORG'
370: ,p_application_id => 'INV'

Line 382: AND l_XRef_Rec.Organization_Id <>FND_API.G_MISS_NUM THEN

378: END IF;
379:
380: -- checking for Item existance for given org.
381: IF l_XRef_Rec.Organization_Id IS NOT NULL
382: AND l_XRef_Rec.Organization_Id <>FND_API.G_MISS_NUM THEN
383:
384: BEGIN
385: SELECT 'x' INTO l_exists
386: FROM mtl_system_items_b

Line 391: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;

387: WHERE Inventory_item_id = l_XRef_Rec.Inventory_Item_Id
388: AND Organization_id = l_XRef_Rec.Organization_Id;
389: EXCEPTION
390: WHEN NO_DATA_FOUND THEN
391: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
392: Error_Handler.Add_Error_Message
393: (
394: p_message_name => 'INV_INVALID_ITEM_ORG'
395: ,p_application_id => 'INV'

Line 408: AND l_XRef_Rec.Uom_Code <> FND_API.G_MISS_CHAR) THEN

404:
405: -- Checking for Revision_Id and UOM_Code Values
406:
407: IF (l_XRef_Rec.Uom_Code IS NOT NULL
408: AND l_XRef_Rec.Uom_Code <> FND_API.G_MISS_CHAR) THEN
409:
410: IF NVL(FND_PROFILE.VALUE('INV:GTIN_CROSS_REFERENCE_TYPE'),FND_API.G_MISS_CHAR) <> l_XRef_rec.Cross_Reference_Type THEN /* bug 14138918 */
411:
412: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;

Line 410: IF NVL(FND_PROFILE.VALUE('INV:GTIN_CROSS_REFERENCE_TYPE'),FND_API.G_MISS_CHAR) <> l_XRef_rec.Cross_Reference_Type THEN /* bug 14138918 */

406:
407: IF (l_XRef_Rec.Uom_Code IS NOT NULL
408: AND l_XRef_Rec.Uom_Code <> FND_API.G_MISS_CHAR) THEN
409:
410: IF NVL(FND_PROFILE.VALUE('INV:GTIN_CROSS_REFERENCE_TYPE'),FND_API.G_MISS_CHAR) <> l_XRef_rec.Cross_Reference_Type THEN /* bug 14138918 */
411:
412: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
413: Error_Handler.Add_Error_Message
414: (

Line 412: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;

408: AND l_XRef_Rec.Uom_Code <> FND_API.G_MISS_CHAR) THEN
409:
410: IF NVL(FND_PROFILE.VALUE('INV:GTIN_CROSS_REFERENCE_TYPE'),FND_API.G_MISS_CHAR) <> l_XRef_rec.Cross_Reference_Type THEN /* bug 14138918 */
411:
412: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
413: Error_Handler.Add_Error_Message
414: (
415: p_message_name => 'INV_XREF_INVALID_COLUMN_VALUE'
416: ,p_application_id => 'INV'

Line 434: and organization_id = Decode (l_XRef_Rec.organization_id,FND_API.G_MISS_CHAR,organization_id,NULL,organization_id,organization_id)

430: l_Xref_Rec.Uom_Code IN (
431: select Uom_code
432: from mtl_uom_conversions_view
433: where inventory_item_id = l_XRef_Rec.Inventory_Item_Id
434: and organization_id = Decode (l_XRef_Rec.organization_id,FND_API.G_MISS_CHAR,organization_id,NULL,organization_id,organization_id)
435: )
436: AND ROWNUM=1;
437:
438: EXCEPTION

Line 441: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;

437:
438: EXCEPTION
439: WHEN No_Data_Found THEN
440:
441: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
442: Error_Handler.Add_Error_Message
443: (
444: p_message_name => 'INV_CCEOI_INVALID_UOM'
445: ,p_application_id => 'INV'

Line 457: AND l_XRef_Rec.Revision_Id <> FND_API.G_MISS_NUM) THEN

453: END IF; /* bug 14138918 end */
454: END IF; /* end if of UOM_Code */
455:
456: IF (l_XRef_Rec.Revision_Id IS NOT NULL
457: AND l_XRef_Rec.Revision_Id <> FND_API.G_MISS_NUM) THEN
458:
459: -- revision id can only have valus when Cross_Reference_Type is equal to profile option INV:GTIN_CROSS_REFERENCE_TYPE value
460: -- and org_independent flag should not be checked
461: -- and organization_id should be provided.

Line 463: IF NVL(FND_PROFILE.VALUE('INV:GTIN_CROSS_REFERENCE_TYPE'),FND_API.G_MISS_CHAR) <> l_XRef_rec.Cross_Reference_Type

459: -- revision id can only have valus when Cross_Reference_Type is equal to profile option INV:GTIN_CROSS_REFERENCE_TYPE value
460: -- and org_independent flag should not be checked
461: -- and organization_id should be provided.
462:
463: IF NVL(FND_PROFILE.VALUE('INV:GTIN_CROSS_REFERENCE_TYPE'),FND_API.G_MISS_CHAR) <> l_XRef_rec.Cross_Reference_Type
464: OR (l_XRef_Rec.Org_Independent_Flag <>'N' OR l_XRef_Rec.Org_Independent_Flag IS NULL OR l_XRef_Rec.Org_Independent_Flag=FND_API.G_MISS_CHAR)
465: OR (l_XRef_Rec.Organization_Id IS NULL OR l_XRef_Rec.Organization_Id = FND_API.G_MISS_NUM)
466: THEN /* bug 14138918 */
467:

Line 464: OR (l_XRef_Rec.Org_Independent_Flag <>'N' OR l_XRef_Rec.Org_Independent_Flag IS NULL OR l_XRef_Rec.Org_Independent_Flag=FND_API.G_MISS_CHAR)

460: -- and org_independent flag should not be checked
461: -- and organization_id should be provided.
462:
463: IF NVL(FND_PROFILE.VALUE('INV:GTIN_CROSS_REFERENCE_TYPE'),FND_API.G_MISS_CHAR) <> l_XRef_rec.Cross_Reference_Type
464: OR (l_XRef_Rec.Org_Independent_Flag <>'N' OR l_XRef_Rec.Org_Independent_Flag IS NULL OR l_XRef_Rec.Org_Independent_Flag=FND_API.G_MISS_CHAR)
465: OR (l_XRef_Rec.Organization_Id IS NULL OR l_XRef_Rec.Organization_Id = FND_API.G_MISS_NUM)
466: THEN /* bug 14138918 */
467:
468: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;

Line 465: OR (l_XRef_Rec.Organization_Id IS NULL OR l_XRef_Rec.Organization_Id = FND_API.G_MISS_NUM)

461: -- and organization_id should be provided.
462:
463: IF NVL(FND_PROFILE.VALUE('INV:GTIN_CROSS_REFERENCE_TYPE'),FND_API.G_MISS_CHAR) <> l_XRef_rec.Cross_Reference_Type
464: OR (l_XRef_Rec.Org_Independent_Flag <>'N' OR l_XRef_Rec.Org_Independent_Flag IS NULL OR l_XRef_Rec.Org_Independent_Flag=FND_API.G_MISS_CHAR)
465: OR (l_XRef_Rec.Organization_Id IS NULL OR l_XRef_Rec.Organization_Id = FND_API.G_MISS_NUM)
466: THEN /* bug 14138918 */
467:
468: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
469: Error_Handler.Add_Error_Message

Line 468: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;

464: OR (l_XRef_Rec.Org_Independent_Flag <>'N' OR l_XRef_Rec.Org_Independent_Flag IS NULL OR l_XRef_Rec.Org_Independent_Flag=FND_API.G_MISS_CHAR)
465: OR (l_XRef_Rec.Organization_Id IS NULL OR l_XRef_Rec.Organization_Id = FND_API.G_MISS_NUM)
466: THEN /* bug 14138918 */
467:
468: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
469: Error_Handler.Add_Error_Message
470: (
471: p_message_name => 'INV_XREF_INVALID_COLUMN_VALUE'
472: ,p_application_id => 'INV'

Line 495: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;

491:
492: EXCEPTION
493: WHEN No_Data_Found THEN
494:
495: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
496: Error_Handler.Add_Error_Message
497: (
498: p_message_name => 'INV_INT_REVCODE'
499: ,p_application_id => 'INV'

Line 520: Decode(nvl(l_XRef_Rec.Organization_Id,FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_XRef_Rec.Org_Independent_Flag,l_XRef_Rec.Organization_Id);

516: WHERE Cross_Reference_Type = l_XRef_Rec.Cross_Reference_Type
517: AND Inventory_Item_Id = l_XRef_Rec.Inventory_Item_Id
518: AND Cross_Reference =l_XRef_Rec.Cross_Reference
519: AND Decode(Organization_Id,NULL,Org_Independent_Flag,Organization_Id) =
520: Decode(nvl(l_XRef_Rec.Organization_Id,FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_XRef_Rec.Org_Independent_Flag,l_XRef_Rec.Organization_Id);
521:
522: --record already Exists
523: IF l_XRef_exists='x' THEN
524:

Line 535: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;

531: l_Token_Tbl(3).Token_Name := 'CROSS_REFERENCE';
532: l_Token_Tbl(3).Token_Value := l_XRef_Rec.CROSS_REFERENCE;
533: l_Token_Tbl(3).Translate := FALSE;
534:
535: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
536: Error_Handler.Add_Error_Message
537: (
538: p_message_name => 'INV_XREF_PRIMARY_KEY_VIOLATED'
539: ,p_application_id => 'INV'

Line 558: p_init_msg_list => FND_API.G_FALSE

554: --
555: IF l_XRef_Rec.Cross_Reference_Type = 'GTIN' THEN
556:
557: Validate_GTIN_Rec(
558: p_init_msg_list => FND_API.G_FALSE
559: ,p_commit => FND_API.G_FALSE
560: ,p_GTIN_XRef_Rec => l_XRef_Rec
561: ,x_return_status => l_gtin_return_status
562: ,x_msg_count => l_gtin_msg_count);

Line 559: ,p_commit => FND_API.G_FALSE

555: IF l_XRef_Rec.Cross_Reference_Type = 'GTIN' THEN
556:
557: Validate_GTIN_Rec(
558: p_init_msg_list => FND_API.G_FALSE
559: ,p_commit => FND_API.G_FALSE
560: ,p_GTIN_XRef_Rec => l_XRef_Rec
561: ,x_return_status => l_gtin_return_status
562: ,x_msg_count => l_gtin_msg_count);
563: IF l_gtin_return_status = FND_API.G_RET_STS_ERROR THEN

Line 563: IF l_gtin_return_status = FND_API.G_RET_STS_ERROR THEN

559: ,p_commit => FND_API.G_FALSE
560: ,p_GTIN_XRef_Rec => l_XRef_Rec
561: ,x_return_status => l_gtin_return_status
562: ,x_msg_count => l_gtin_msg_count);
563: IF l_gtin_return_status = FND_API.G_RET_STS_ERROR THEN
564: RAISE VALIDATION_ERROR;
565: END IF;
566:
567: IF l_gtin_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 567: IF l_gtin_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

563: IF l_gtin_return_status = FND_API.G_RET_STS_ERROR THEN
564: RAISE VALIDATION_ERROR;
565: END IF;
566:
567: IF l_gtin_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
568: RAISE UNEXP_VALIDATION_ERROR;
569: END IF;
570:
571: END IF;

Line 574: SELECT Decode(l_XRef_Rec.Inventory_Item_Id,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Inventory_Item_Id),

570:
571: END IF;
572:
573: --Changing Gloabal variable back to NULL before inserting.
574: SELECT Decode(l_XRef_Rec.Inventory_Item_Id,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Inventory_Item_Id),
575: Decode(l_XRef_Rec.Organization_Id,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Organization_Id),
576: Decode(l_XRef_Rec.Cross_Reference_Type,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Cross_Reference_Type),
577: Decode(l_XRef_Rec.Cross_Reference,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Cross_Reference),
578: Decode(l_XRef_Rec.Description,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Description),

Line 575: Decode(l_XRef_Rec.Organization_Id,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Organization_Id),

571: END IF;
572:
573: --Changing Gloabal variable back to NULL before inserting.
574: SELECT Decode(l_XRef_Rec.Inventory_Item_Id,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Inventory_Item_Id),
575: Decode(l_XRef_Rec.Organization_Id,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Organization_Id),
576: Decode(l_XRef_Rec.Cross_Reference_Type,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Cross_Reference_Type),
577: Decode(l_XRef_Rec.Cross_Reference,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Cross_Reference),
578: Decode(l_XRef_Rec.Description,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Description),
579: Decode(l_XRef_Rec.Org_Independent_Flag,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Org_Independent_Flag),

Line 576: Decode(l_XRef_Rec.Cross_Reference_Type,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Cross_Reference_Type),

572:
573: --Changing Gloabal variable back to NULL before inserting.
574: SELECT Decode(l_XRef_Rec.Inventory_Item_Id,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Inventory_Item_Id),
575: Decode(l_XRef_Rec.Organization_Id,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Organization_Id),
576: Decode(l_XRef_Rec.Cross_Reference_Type,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Cross_Reference_Type),
577: Decode(l_XRef_Rec.Cross_Reference,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Cross_Reference),
578: Decode(l_XRef_Rec.Description,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Description),
579: Decode(l_XRef_Rec.Org_Independent_Flag,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Org_Independent_Flag),
580: Decode(l_XRef_Rec.Last_Update_Date,FND_API.G_MISS_DATE,NULL,l_XRef_Rec.Last_Update_Date),

Line 577: Decode(l_XRef_Rec.Cross_Reference,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Cross_Reference),

573: --Changing Gloabal variable back to NULL before inserting.
574: SELECT Decode(l_XRef_Rec.Inventory_Item_Id,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Inventory_Item_Id),
575: Decode(l_XRef_Rec.Organization_Id,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Organization_Id),
576: Decode(l_XRef_Rec.Cross_Reference_Type,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Cross_Reference_Type),
577: Decode(l_XRef_Rec.Cross_Reference,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Cross_Reference),
578: Decode(l_XRef_Rec.Description,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Description),
579: Decode(l_XRef_Rec.Org_Independent_Flag,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Org_Independent_Flag),
580: Decode(l_XRef_Rec.Last_Update_Date,FND_API.G_MISS_DATE,NULL,l_XRef_Rec.Last_Update_Date),
581: Decode(l_XRef_Rec.Last_Updated_By,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Last_Updated_By),

Line 578: Decode(l_XRef_Rec.Description,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Description),

574: SELECT Decode(l_XRef_Rec.Inventory_Item_Id,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Inventory_Item_Id),
575: Decode(l_XRef_Rec.Organization_Id,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Organization_Id),
576: Decode(l_XRef_Rec.Cross_Reference_Type,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Cross_Reference_Type),
577: Decode(l_XRef_Rec.Cross_Reference,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Cross_Reference),
578: Decode(l_XRef_Rec.Description,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Description),
579: Decode(l_XRef_Rec.Org_Independent_Flag,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Org_Independent_Flag),
580: Decode(l_XRef_Rec.Last_Update_Date,FND_API.G_MISS_DATE,NULL,l_XRef_Rec.Last_Update_Date),
581: Decode(l_XRef_Rec.Last_Updated_By,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Last_Updated_By),
582: Decode(l_XRef_Rec.Creation_Date,FND_API.G_MISS_DATE,NULL,l_XRef_Rec.Creation_Date),

Line 579: Decode(l_XRef_Rec.Org_Independent_Flag,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Org_Independent_Flag),

575: Decode(l_XRef_Rec.Organization_Id,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Organization_Id),
576: Decode(l_XRef_Rec.Cross_Reference_Type,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Cross_Reference_Type),
577: Decode(l_XRef_Rec.Cross_Reference,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Cross_Reference),
578: Decode(l_XRef_Rec.Description,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Description),
579: Decode(l_XRef_Rec.Org_Independent_Flag,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Org_Independent_Flag),
580: Decode(l_XRef_Rec.Last_Update_Date,FND_API.G_MISS_DATE,NULL,l_XRef_Rec.Last_Update_Date),
581: Decode(l_XRef_Rec.Last_Updated_By,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Last_Updated_By),
582: Decode(l_XRef_Rec.Creation_Date,FND_API.G_MISS_DATE,NULL,l_XRef_Rec.Creation_Date),
583: Decode(l_XRef_Rec.Created_By,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Created_By),

Line 580: Decode(l_XRef_Rec.Last_Update_Date,FND_API.G_MISS_DATE,NULL,l_XRef_Rec.Last_Update_Date),

576: Decode(l_XRef_Rec.Cross_Reference_Type,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Cross_Reference_Type),
577: Decode(l_XRef_Rec.Cross_Reference,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Cross_Reference),
578: Decode(l_XRef_Rec.Description,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Description),
579: Decode(l_XRef_Rec.Org_Independent_Flag,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Org_Independent_Flag),
580: Decode(l_XRef_Rec.Last_Update_Date,FND_API.G_MISS_DATE,NULL,l_XRef_Rec.Last_Update_Date),
581: Decode(l_XRef_Rec.Last_Updated_By,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Last_Updated_By),
582: Decode(l_XRef_Rec.Creation_Date,FND_API.G_MISS_DATE,NULL,l_XRef_Rec.Creation_Date),
583: Decode(l_XRef_Rec.Created_By,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Created_By),
584: Decode(l_XRef_Rec.Last_Update_Login,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Last_Update_Login),

Line 581: Decode(l_XRef_Rec.Last_Updated_By,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Last_Updated_By),

577: Decode(l_XRef_Rec.Cross_Reference,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Cross_Reference),
578: Decode(l_XRef_Rec.Description,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Description),
579: Decode(l_XRef_Rec.Org_Independent_Flag,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Org_Independent_Flag),
580: Decode(l_XRef_Rec.Last_Update_Date,FND_API.G_MISS_DATE,NULL,l_XRef_Rec.Last_Update_Date),
581: Decode(l_XRef_Rec.Last_Updated_By,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Last_Updated_By),
582: Decode(l_XRef_Rec.Creation_Date,FND_API.G_MISS_DATE,NULL,l_XRef_Rec.Creation_Date),
583: Decode(l_XRef_Rec.Created_By,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Created_By),
584: Decode(l_XRef_Rec.Last_Update_Login,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Last_Update_Login),
585: Decode(l_XRef_Rec.Request_id,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Request_id),

Line 582: Decode(l_XRef_Rec.Creation_Date,FND_API.G_MISS_DATE,NULL,l_XRef_Rec.Creation_Date),

578: Decode(l_XRef_Rec.Description,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Description),
579: Decode(l_XRef_Rec.Org_Independent_Flag,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Org_Independent_Flag),
580: Decode(l_XRef_Rec.Last_Update_Date,FND_API.G_MISS_DATE,NULL,l_XRef_Rec.Last_Update_Date),
581: Decode(l_XRef_Rec.Last_Updated_By,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Last_Updated_By),
582: Decode(l_XRef_Rec.Creation_Date,FND_API.G_MISS_DATE,NULL,l_XRef_Rec.Creation_Date),
583: Decode(l_XRef_Rec.Created_By,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Created_By),
584: Decode(l_XRef_Rec.Last_Update_Login,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Last_Update_Login),
585: Decode(l_XRef_Rec.Request_id,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Request_id),
586: Decode(l_XRef_Rec.Program_Application_Id,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Program_Application_Id),

Line 583: Decode(l_XRef_Rec.Created_By,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Created_By),

579: Decode(l_XRef_Rec.Org_Independent_Flag,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Org_Independent_Flag),
580: Decode(l_XRef_Rec.Last_Update_Date,FND_API.G_MISS_DATE,NULL,l_XRef_Rec.Last_Update_Date),
581: Decode(l_XRef_Rec.Last_Updated_By,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Last_Updated_By),
582: Decode(l_XRef_Rec.Creation_Date,FND_API.G_MISS_DATE,NULL,l_XRef_Rec.Creation_Date),
583: Decode(l_XRef_Rec.Created_By,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Created_By),
584: Decode(l_XRef_Rec.Last_Update_Login,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Last_Update_Login),
585: Decode(l_XRef_Rec.Request_id,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Request_id),
586: Decode(l_XRef_Rec.Program_Application_Id,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Program_Application_Id),
587: Decode(l_XRef_Rec.Program_Id,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Program_Id),

Line 584: Decode(l_XRef_Rec.Last_Update_Login,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Last_Update_Login),

580: Decode(l_XRef_Rec.Last_Update_Date,FND_API.G_MISS_DATE,NULL,l_XRef_Rec.Last_Update_Date),
581: Decode(l_XRef_Rec.Last_Updated_By,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Last_Updated_By),
582: Decode(l_XRef_Rec.Creation_Date,FND_API.G_MISS_DATE,NULL,l_XRef_Rec.Creation_Date),
583: Decode(l_XRef_Rec.Created_By,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Created_By),
584: Decode(l_XRef_Rec.Last_Update_Login,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Last_Update_Login),
585: Decode(l_XRef_Rec.Request_id,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Request_id),
586: Decode(l_XRef_Rec.Program_Application_Id,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Program_Application_Id),
587: Decode(l_XRef_Rec.Program_Id,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Program_Id),
588: Decode(l_XRef_Rec.Program_Update_Date,FND_API.G_MISS_DATE,NULL,l_XRef_Rec.Program_Update_Date),

Line 585: Decode(l_XRef_Rec.Request_id,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Request_id),

581: Decode(l_XRef_Rec.Last_Updated_By,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Last_Updated_By),
582: Decode(l_XRef_Rec.Creation_Date,FND_API.G_MISS_DATE,NULL,l_XRef_Rec.Creation_Date),
583: Decode(l_XRef_Rec.Created_By,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Created_By),
584: Decode(l_XRef_Rec.Last_Update_Login,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Last_Update_Login),
585: Decode(l_XRef_Rec.Request_id,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Request_id),
586: Decode(l_XRef_Rec.Program_Application_Id,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Program_Application_Id),
587: Decode(l_XRef_Rec.Program_Id,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Program_Id),
588: Decode(l_XRef_Rec.Program_Update_Date,FND_API.G_MISS_DATE,NULL,l_XRef_Rec.Program_Update_Date),
589: Decode(l_XRef_Rec.Attribute1,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute1),

Line 586: Decode(l_XRef_Rec.Program_Application_Id,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Program_Application_Id),

582: Decode(l_XRef_Rec.Creation_Date,FND_API.G_MISS_DATE,NULL,l_XRef_Rec.Creation_Date),
583: Decode(l_XRef_Rec.Created_By,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Created_By),
584: Decode(l_XRef_Rec.Last_Update_Login,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Last_Update_Login),
585: Decode(l_XRef_Rec.Request_id,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Request_id),
586: Decode(l_XRef_Rec.Program_Application_Id,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Program_Application_Id),
587: Decode(l_XRef_Rec.Program_Id,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Program_Id),
588: Decode(l_XRef_Rec.Program_Update_Date,FND_API.G_MISS_DATE,NULL,l_XRef_Rec.Program_Update_Date),
589: Decode(l_XRef_Rec.Attribute1,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute1),
590: Decode(l_XRef_Rec.Attribute2,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute2),

Line 587: Decode(l_XRef_Rec.Program_Id,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Program_Id),

583: Decode(l_XRef_Rec.Created_By,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Created_By),
584: Decode(l_XRef_Rec.Last_Update_Login,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Last_Update_Login),
585: Decode(l_XRef_Rec.Request_id,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Request_id),
586: Decode(l_XRef_Rec.Program_Application_Id,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Program_Application_Id),
587: Decode(l_XRef_Rec.Program_Id,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Program_Id),
588: Decode(l_XRef_Rec.Program_Update_Date,FND_API.G_MISS_DATE,NULL,l_XRef_Rec.Program_Update_Date),
589: Decode(l_XRef_Rec.Attribute1,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute1),
590: Decode(l_XRef_Rec.Attribute2,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute2),
591: Decode(l_XRef_Rec.Attribute3,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute3),

Line 588: Decode(l_XRef_Rec.Program_Update_Date,FND_API.G_MISS_DATE,NULL,l_XRef_Rec.Program_Update_Date),

584: Decode(l_XRef_Rec.Last_Update_Login,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Last_Update_Login),
585: Decode(l_XRef_Rec.Request_id,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Request_id),
586: Decode(l_XRef_Rec.Program_Application_Id,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Program_Application_Id),
587: Decode(l_XRef_Rec.Program_Id,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Program_Id),
588: Decode(l_XRef_Rec.Program_Update_Date,FND_API.G_MISS_DATE,NULL,l_XRef_Rec.Program_Update_Date),
589: Decode(l_XRef_Rec.Attribute1,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute1),
590: Decode(l_XRef_Rec.Attribute2,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute2),
591: Decode(l_XRef_Rec.Attribute3,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute3),
592: Decode(l_XRef_Rec.Attribute4,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute4),

Line 589: Decode(l_XRef_Rec.Attribute1,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute1),

585: Decode(l_XRef_Rec.Request_id,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Request_id),
586: Decode(l_XRef_Rec.Program_Application_Id,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Program_Application_Id),
587: Decode(l_XRef_Rec.Program_Id,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Program_Id),
588: Decode(l_XRef_Rec.Program_Update_Date,FND_API.G_MISS_DATE,NULL,l_XRef_Rec.Program_Update_Date),
589: Decode(l_XRef_Rec.Attribute1,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute1),
590: Decode(l_XRef_Rec.Attribute2,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute2),
591: Decode(l_XRef_Rec.Attribute3,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute3),
592: Decode(l_XRef_Rec.Attribute4,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute4),
593: Decode(l_XRef_Rec.Attribute5,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute5),

Line 590: Decode(l_XRef_Rec.Attribute2,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute2),

586: Decode(l_XRef_Rec.Program_Application_Id,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Program_Application_Id),
587: Decode(l_XRef_Rec.Program_Id,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Program_Id),
588: Decode(l_XRef_Rec.Program_Update_Date,FND_API.G_MISS_DATE,NULL,l_XRef_Rec.Program_Update_Date),
589: Decode(l_XRef_Rec.Attribute1,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute1),
590: Decode(l_XRef_Rec.Attribute2,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute2),
591: Decode(l_XRef_Rec.Attribute3,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute3),
592: Decode(l_XRef_Rec.Attribute4,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute4),
593: Decode(l_XRef_Rec.Attribute5,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute5),
594: Decode(l_XRef_Rec.Attribute6,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute6),

Line 591: Decode(l_XRef_Rec.Attribute3,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute3),

587: Decode(l_XRef_Rec.Program_Id,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Program_Id),
588: Decode(l_XRef_Rec.Program_Update_Date,FND_API.G_MISS_DATE,NULL,l_XRef_Rec.Program_Update_Date),
589: Decode(l_XRef_Rec.Attribute1,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute1),
590: Decode(l_XRef_Rec.Attribute2,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute2),
591: Decode(l_XRef_Rec.Attribute3,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute3),
592: Decode(l_XRef_Rec.Attribute4,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute4),
593: Decode(l_XRef_Rec.Attribute5,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute5),
594: Decode(l_XRef_Rec.Attribute6,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute6),
595: Decode(l_XRef_Rec.Attribute7,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute7),

Line 592: Decode(l_XRef_Rec.Attribute4,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute4),

588: Decode(l_XRef_Rec.Program_Update_Date,FND_API.G_MISS_DATE,NULL,l_XRef_Rec.Program_Update_Date),
589: Decode(l_XRef_Rec.Attribute1,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute1),
590: Decode(l_XRef_Rec.Attribute2,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute2),
591: Decode(l_XRef_Rec.Attribute3,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute3),
592: Decode(l_XRef_Rec.Attribute4,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute4),
593: Decode(l_XRef_Rec.Attribute5,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute5),
594: Decode(l_XRef_Rec.Attribute6,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute6),
595: Decode(l_XRef_Rec.Attribute7,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute7),
596: Decode(l_XRef_Rec.Attribute8,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute8),

Line 593: Decode(l_XRef_Rec.Attribute5,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute5),

589: Decode(l_XRef_Rec.Attribute1,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute1),
590: Decode(l_XRef_Rec.Attribute2,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute2),
591: Decode(l_XRef_Rec.Attribute3,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute3),
592: Decode(l_XRef_Rec.Attribute4,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute4),
593: Decode(l_XRef_Rec.Attribute5,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute5),
594: Decode(l_XRef_Rec.Attribute6,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute6),
595: Decode(l_XRef_Rec.Attribute7,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute7),
596: Decode(l_XRef_Rec.Attribute8,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute8),
597: Decode(l_XRef_Rec.Attribute9,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute9),

Line 594: Decode(l_XRef_Rec.Attribute6,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute6),

590: Decode(l_XRef_Rec.Attribute2,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute2),
591: Decode(l_XRef_Rec.Attribute3,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute3),
592: Decode(l_XRef_Rec.Attribute4,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute4),
593: Decode(l_XRef_Rec.Attribute5,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute5),
594: Decode(l_XRef_Rec.Attribute6,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute6),
595: Decode(l_XRef_Rec.Attribute7,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute7),
596: Decode(l_XRef_Rec.Attribute8,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute8),
597: Decode(l_XRef_Rec.Attribute9,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute9),
598: Decode(l_XRef_Rec.Attribute10,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute10),

Line 595: Decode(l_XRef_Rec.Attribute7,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute7),

591: Decode(l_XRef_Rec.Attribute3,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute3),
592: Decode(l_XRef_Rec.Attribute4,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute4),
593: Decode(l_XRef_Rec.Attribute5,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute5),
594: Decode(l_XRef_Rec.Attribute6,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute6),
595: Decode(l_XRef_Rec.Attribute7,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute7),
596: Decode(l_XRef_Rec.Attribute8,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute8),
597: Decode(l_XRef_Rec.Attribute9,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute9),
598: Decode(l_XRef_Rec.Attribute10,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute10),
599: Decode(l_XRef_Rec.Attribute11,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute11),

Line 596: Decode(l_XRef_Rec.Attribute8,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute8),

592: Decode(l_XRef_Rec.Attribute4,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute4),
593: Decode(l_XRef_Rec.Attribute5,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute5),
594: Decode(l_XRef_Rec.Attribute6,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute6),
595: Decode(l_XRef_Rec.Attribute7,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute7),
596: Decode(l_XRef_Rec.Attribute8,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute8),
597: Decode(l_XRef_Rec.Attribute9,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute9),
598: Decode(l_XRef_Rec.Attribute10,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute10),
599: Decode(l_XRef_Rec.Attribute11,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute11),
600: Decode(l_XRef_Rec.Attribute12,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute12),

Line 597: Decode(l_XRef_Rec.Attribute9,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute9),

593: Decode(l_XRef_Rec.Attribute5,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute5),
594: Decode(l_XRef_Rec.Attribute6,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute6),
595: Decode(l_XRef_Rec.Attribute7,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute7),
596: Decode(l_XRef_Rec.Attribute8,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute8),
597: Decode(l_XRef_Rec.Attribute9,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute9),
598: Decode(l_XRef_Rec.Attribute10,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute10),
599: Decode(l_XRef_Rec.Attribute11,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute11),
600: Decode(l_XRef_Rec.Attribute12,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute12),
601: Decode(l_XRef_Rec.Attribute13,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute13),

Line 598: Decode(l_XRef_Rec.Attribute10,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute10),

594: Decode(l_XRef_Rec.Attribute6,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute6),
595: Decode(l_XRef_Rec.Attribute7,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute7),
596: Decode(l_XRef_Rec.Attribute8,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute8),
597: Decode(l_XRef_Rec.Attribute9,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute9),
598: Decode(l_XRef_Rec.Attribute10,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute10),
599: Decode(l_XRef_Rec.Attribute11,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute11),
600: Decode(l_XRef_Rec.Attribute12,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute12),
601: Decode(l_XRef_Rec.Attribute13,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute13),
602: Decode(l_XRef_Rec.Attribute14,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute14),

Line 599: Decode(l_XRef_Rec.Attribute11,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute11),

595: Decode(l_XRef_Rec.Attribute7,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute7),
596: Decode(l_XRef_Rec.Attribute8,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute8),
597: Decode(l_XRef_Rec.Attribute9,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute9),
598: Decode(l_XRef_Rec.Attribute10,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute10),
599: Decode(l_XRef_Rec.Attribute11,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute11),
600: Decode(l_XRef_Rec.Attribute12,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute12),
601: Decode(l_XRef_Rec.Attribute13,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute13),
602: Decode(l_XRef_Rec.Attribute14,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute14),
603: Decode(l_XRef_Rec.Attribute15,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute15),

Line 600: Decode(l_XRef_Rec.Attribute12,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute12),

596: Decode(l_XRef_Rec.Attribute8,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute8),
597: Decode(l_XRef_Rec.Attribute9,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute9),
598: Decode(l_XRef_Rec.Attribute10,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute10),
599: Decode(l_XRef_Rec.Attribute11,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute11),
600: Decode(l_XRef_Rec.Attribute12,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute12),
601: Decode(l_XRef_Rec.Attribute13,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute13),
602: Decode(l_XRef_Rec.Attribute14,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute14),
603: Decode(l_XRef_Rec.Attribute15,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute15),
604: Decode(l_XRef_Rec.Attribute_category,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute_category),

Line 601: Decode(l_XRef_Rec.Attribute13,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute13),

597: Decode(l_XRef_Rec.Attribute9,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute9),
598: Decode(l_XRef_Rec.Attribute10,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute10),
599: Decode(l_XRef_Rec.Attribute11,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute11),
600: Decode(l_XRef_Rec.Attribute12,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute12),
601: Decode(l_XRef_Rec.Attribute13,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute13),
602: Decode(l_XRef_Rec.Attribute14,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute14),
603: Decode(l_XRef_Rec.Attribute15,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute15),
604: Decode(l_XRef_Rec.Attribute_category,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute_category),
605: Decode(l_XRef_Rec.Uom_Code,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Uom_Code),

Line 602: Decode(l_XRef_Rec.Attribute14,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute14),

598: Decode(l_XRef_Rec.Attribute10,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute10),
599: Decode(l_XRef_Rec.Attribute11,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute11),
600: Decode(l_XRef_Rec.Attribute12,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute12),
601: Decode(l_XRef_Rec.Attribute13,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute13),
602: Decode(l_XRef_Rec.Attribute14,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute14),
603: Decode(l_XRef_Rec.Attribute15,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute15),
604: Decode(l_XRef_Rec.Attribute_category,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute_category),
605: Decode(l_XRef_Rec.Uom_Code,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Uom_Code),
606: Decode(l_XRef_Rec.Revision_Id,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Revision_Id),

Line 603: Decode(l_XRef_Rec.Attribute15,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute15),

599: Decode(l_XRef_Rec.Attribute11,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute11),
600: Decode(l_XRef_Rec.Attribute12,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute12),
601: Decode(l_XRef_Rec.Attribute13,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute13),
602: Decode(l_XRef_Rec.Attribute14,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute14),
603: Decode(l_XRef_Rec.Attribute15,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute15),
604: Decode(l_XRef_Rec.Attribute_category,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute_category),
605: Decode(l_XRef_Rec.Uom_Code,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Uom_Code),
606: Decode(l_XRef_Rec.Revision_Id,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Revision_Id),
607: Decode(l_XRef_Rec.Epc_Gtin_Serial,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Epc_Gtin_Serial)

Line 604: Decode(l_XRef_Rec.Attribute_category,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute_category),

600: Decode(l_XRef_Rec.Attribute12,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute12),
601: Decode(l_XRef_Rec.Attribute13,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute13),
602: Decode(l_XRef_Rec.Attribute14,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute14),
603: Decode(l_XRef_Rec.Attribute15,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute15),
604: Decode(l_XRef_Rec.Attribute_category,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute_category),
605: Decode(l_XRef_Rec.Uom_Code,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Uom_Code),
606: Decode(l_XRef_Rec.Revision_Id,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Revision_Id),
607: Decode(l_XRef_Rec.Epc_Gtin_Serial,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Epc_Gtin_Serial)
608:

Line 605: Decode(l_XRef_Rec.Uom_Code,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Uom_Code),

601: Decode(l_XRef_Rec.Attribute13,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute13),
602: Decode(l_XRef_Rec.Attribute14,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute14),
603: Decode(l_XRef_Rec.Attribute15,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute15),
604: Decode(l_XRef_Rec.Attribute_category,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute_category),
605: Decode(l_XRef_Rec.Uom_Code,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Uom_Code),
606: Decode(l_XRef_Rec.Revision_Id,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Revision_Id),
607: Decode(l_XRef_Rec.Epc_Gtin_Serial,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Epc_Gtin_Serial)
608:
609: INTO l_XRef_Rec.Inventory_Item_Id,l_XRef_Rec.Organization_Id, l_XRef_Rec.Cross_Reference_Type,l_XRef_Rec.Cross_Reference,

Line 606: Decode(l_XRef_Rec.Revision_Id,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Revision_Id),

602: Decode(l_XRef_Rec.Attribute14,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute14),
603: Decode(l_XRef_Rec.Attribute15,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute15),
604: Decode(l_XRef_Rec.Attribute_category,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute_category),
605: Decode(l_XRef_Rec.Uom_Code,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Uom_Code),
606: Decode(l_XRef_Rec.Revision_Id,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Revision_Id),
607: Decode(l_XRef_Rec.Epc_Gtin_Serial,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Epc_Gtin_Serial)
608:
609: INTO l_XRef_Rec.Inventory_Item_Id,l_XRef_Rec.Organization_Id, l_XRef_Rec.Cross_Reference_Type,l_XRef_Rec.Cross_Reference,
610: l_XRef_Rec.Description,l_XRef_Rec.Org_Independent_Flag,l_XRef_Rec.Last_Update_Date,l_XRef_Rec.Last_Updated_By,l_XRef_Rec.Creation_Date,

Line 607: Decode(l_XRef_Rec.Epc_Gtin_Serial,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Epc_Gtin_Serial)

603: Decode(l_XRef_Rec.Attribute15,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute15),
604: Decode(l_XRef_Rec.Attribute_category,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute_category),
605: Decode(l_XRef_Rec.Uom_Code,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Uom_Code),
606: Decode(l_XRef_Rec.Revision_Id,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Revision_Id),
607: Decode(l_XRef_Rec.Epc_Gtin_Serial,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Epc_Gtin_Serial)
608:
609: INTO l_XRef_Rec.Inventory_Item_Id,l_XRef_Rec.Organization_Id, l_XRef_Rec.Cross_Reference_Type,l_XRef_Rec.Cross_Reference,
610: l_XRef_Rec.Description,l_XRef_Rec.Org_Independent_Flag,l_XRef_Rec.Last_Update_Date,l_XRef_Rec.Last_Updated_By,l_XRef_Rec.Creation_Date,
611: l_XRef_Rec.Created_By,l_XRef_Rec.Last_Update_Login,l_XRef_Rec.Request_id,l_XRef_Rec.Program_Application_Id,l_XRef_Rec.Program_Id,

Line 679: IF l_XRef_Rec.CROSS_REFERENCE_ID =FND_API.G_MISS_NUM THEN

675:
676: ELSIF l_XRef_Rec.Transaction_Type = 'UPDATE' THEN
677:
678: -- Current cols should not be NULL.
679: IF l_XRef_Rec.CROSS_REFERENCE_ID =FND_API.G_MISS_NUM THEN
680:
681: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR; -- assigning the record status as error
682: Error_Handler.Add_Error_Message
683: (

Line 681: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR; -- assigning the record status as error

677:
678: -- Current cols should not be NULL.
679: IF l_XRef_Rec.CROSS_REFERENCE_ID =FND_API.G_MISS_NUM THEN
680:
681: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR; -- assigning the record status as error
682: Error_Handler.Add_Error_Message
683: (
684: p_message_name => 'INV_XREF_ID_NULL'
685: ,p_application_id => 'INV'

Line 701: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR; -- assigning the record status as error

697: /*IF l_XRef_Rec.Inventory_Item_Id IS NULL
698: OR l_XRef_Rec.Cross_Reference_Type IS NULL
699: OR l_XRef_Rec.Cross_Reference IS NULL THEN
700:
701: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR; -- assigning the record status as error
702: Error_Handler.Add_Error_Message
703: (
704: p_message_name => 'INV_XREF_NULL_COLS'
705: ,p_application_id => 'INV'

Line 719: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;

715: -- getting original values and checking for existance of record
716: OPEN mtl_xref_cur(l_XRef_Rec.CROSS_REFERENCE_ID);
717: FETCH mtl_xref_cur INTO l_mtl_XRef_rec;
718: IF mtl_xref_cur%NOTFOUND THEN
719: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
720: Error_Handler.Add_Error_Message
721: (
722: p_message_name => 'INV_XREF_ID_NOTEXISTS'
723: ,p_application_id => 'INV'

Line 738: SELECT Decode(Nvl(l_XRef_Rec.Inventory_Item_Id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Inventory_Item_Id,-999999,NULL,l_XRef_Rec.Inventory_Item_Id),

734: --
735: -- Converting global values(values left blank) back to original values.
736: -- To nullify columns during update through interface route, use -999999 for numbers, '!' for chars, '31-Dec-1999' for dates
737: --
738: SELECT Decode(Nvl(l_XRef_Rec.Inventory_Item_Id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Inventory_Item_Id,-999999,NULL,l_XRef_Rec.Inventory_Item_Id),
739: Decode(Nvl(l_XRef_Rec.Organization_Id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Organization_Id,-999999,NULL,l_XRef_Rec.Organization_Id),
740: Decode(Nvl(l_XRef_Rec.Cross_Reference_Type, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Cross_Reference_Type,'!',NULL,l_XRef_Rec.Cross_Reference_Type),
741: Decode(Nvl(l_XRef_Rec.Cross_Reference, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Cross_Reference,'!',NULL,l_XRef_Rec.Cross_Reference),
742: Decode(Nvl(l_XRef_Rec.Description, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Description,'!',NULL,l_XRef_Rec.Description),

Line 739: Decode(Nvl(l_XRef_Rec.Organization_Id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Organization_Id,-999999,NULL,l_XRef_Rec.Organization_Id),

735: -- Converting global values(values left blank) back to original values.
736: -- To nullify columns during update through interface route, use -999999 for numbers, '!' for chars, '31-Dec-1999' for dates
737: --
738: SELECT Decode(Nvl(l_XRef_Rec.Inventory_Item_Id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Inventory_Item_Id,-999999,NULL,l_XRef_Rec.Inventory_Item_Id),
739: Decode(Nvl(l_XRef_Rec.Organization_Id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Organization_Id,-999999,NULL,l_XRef_Rec.Organization_Id),
740: Decode(Nvl(l_XRef_Rec.Cross_Reference_Type, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Cross_Reference_Type,'!',NULL,l_XRef_Rec.Cross_Reference_Type),
741: Decode(Nvl(l_XRef_Rec.Cross_Reference, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Cross_Reference,'!',NULL,l_XRef_Rec.Cross_Reference),
742: Decode(Nvl(l_XRef_Rec.Description, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Description,'!',NULL,l_XRef_Rec.Description),
743: Decode(Nvl(l_XRef_Rec.Org_Independent_Flag, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Org_Independent_Flag,'!',NULL,l_XRef_Rec.Org_Independent_Flag),

Line 740: Decode(Nvl(l_XRef_Rec.Cross_Reference_Type, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Cross_Reference_Type,'!',NULL,l_XRef_Rec.Cross_Reference_Type),

736: -- To nullify columns during update through interface route, use -999999 for numbers, '!' for chars, '31-Dec-1999' for dates
737: --
738: SELECT Decode(Nvl(l_XRef_Rec.Inventory_Item_Id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Inventory_Item_Id,-999999,NULL,l_XRef_Rec.Inventory_Item_Id),
739: Decode(Nvl(l_XRef_Rec.Organization_Id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Organization_Id,-999999,NULL,l_XRef_Rec.Organization_Id),
740: Decode(Nvl(l_XRef_Rec.Cross_Reference_Type, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Cross_Reference_Type,'!',NULL,l_XRef_Rec.Cross_Reference_Type),
741: Decode(Nvl(l_XRef_Rec.Cross_Reference, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Cross_Reference,'!',NULL,l_XRef_Rec.Cross_Reference),
742: Decode(Nvl(l_XRef_Rec.Description, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Description,'!',NULL,l_XRef_Rec.Description),
743: Decode(Nvl(l_XRef_Rec.Org_Independent_Flag, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Org_Independent_Flag,'!',NULL,l_XRef_Rec.Org_Independent_Flag),
744: Decode(Nvl(l_XRef_Rec.Last_Update_Date, FND_API.G_MISS_DATE),FND_API.G_MISS_DATE,NULL,l_XRef_Rec.Last_Update_Date),

Line 741: Decode(Nvl(l_XRef_Rec.Cross_Reference, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Cross_Reference,'!',NULL,l_XRef_Rec.Cross_Reference),

737: --
738: SELECT Decode(Nvl(l_XRef_Rec.Inventory_Item_Id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Inventory_Item_Id,-999999,NULL,l_XRef_Rec.Inventory_Item_Id),
739: Decode(Nvl(l_XRef_Rec.Organization_Id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Organization_Id,-999999,NULL,l_XRef_Rec.Organization_Id),
740: Decode(Nvl(l_XRef_Rec.Cross_Reference_Type, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Cross_Reference_Type,'!',NULL,l_XRef_Rec.Cross_Reference_Type),
741: Decode(Nvl(l_XRef_Rec.Cross_Reference, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Cross_Reference,'!',NULL,l_XRef_Rec.Cross_Reference),
742: Decode(Nvl(l_XRef_Rec.Description, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Description,'!',NULL,l_XRef_Rec.Description),
743: Decode(Nvl(l_XRef_Rec.Org_Independent_Flag, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Org_Independent_Flag,'!',NULL,l_XRef_Rec.Org_Independent_Flag),
744: Decode(Nvl(l_XRef_Rec.Last_Update_Date, FND_API.G_MISS_DATE),FND_API.G_MISS_DATE,NULL,l_XRef_Rec.Last_Update_Date),
745: Decode(Nvl(l_XRef_Rec.Last_Updated_By, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,NULL,-999999,NULL,l_XRef_Rec.Last_Updated_By),

Line 742: Decode(Nvl(l_XRef_Rec.Description, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Description,'!',NULL,l_XRef_Rec.Description),

738: SELECT Decode(Nvl(l_XRef_Rec.Inventory_Item_Id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Inventory_Item_Id,-999999,NULL,l_XRef_Rec.Inventory_Item_Id),
739: Decode(Nvl(l_XRef_Rec.Organization_Id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Organization_Id,-999999,NULL,l_XRef_Rec.Organization_Id),
740: Decode(Nvl(l_XRef_Rec.Cross_Reference_Type, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Cross_Reference_Type,'!',NULL,l_XRef_Rec.Cross_Reference_Type),
741: Decode(Nvl(l_XRef_Rec.Cross_Reference, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Cross_Reference,'!',NULL,l_XRef_Rec.Cross_Reference),
742: Decode(Nvl(l_XRef_Rec.Description, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Description,'!',NULL,l_XRef_Rec.Description),
743: Decode(Nvl(l_XRef_Rec.Org_Independent_Flag, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Org_Independent_Flag,'!',NULL,l_XRef_Rec.Org_Independent_Flag),
744: Decode(Nvl(l_XRef_Rec.Last_Update_Date, FND_API.G_MISS_DATE),FND_API.G_MISS_DATE,NULL,l_XRef_Rec.Last_Update_Date),
745: Decode(Nvl(l_XRef_Rec.Last_Updated_By, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,NULL,-999999,NULL,l_XRef_Rec.Last_Updated_By),
746: Decode(Nvl(l_XRef_Rec.Creation_Date, FND_API.G_MISS_DATE),FND_API.G_MISS_DATE,l_mtl_XRef_Rec.Creation_Date,l_XRef_Rec.Creation_Date),

Line 743: Decode(Nvl(l_XRef_Rec.Org_Independent_Flag, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Org_Independent_Flag,'!',NULL,l_XRef_Rec.Org_Independent_Flag),

739: Decode(Nvl(l_XRef_Rec.Organization_Id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Organization_Id,-999999,NULL,l_XRef_Rec.Organization_Id),
740: Decode(Nvl(l_XRef_Rec.Cross_Reference_Type, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Cross_Reference_Type,'!',NULL,l_XRef_Rec.Cross_Reference_Type),
741: Decode(Nvl(l_XRef_Rec.Cross_Reference, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Cross_Reference,'!',NULL,l_XRef_Rec.Cross_Reference),
742: Decode(Nvl(l_XRef_Rec.Description, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Description,'!',NULL,l_XRef_Rec.Description),
743: Decode(Nvl(l_XRef_Rec.Org_Independent_Flag, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Org_Independent_Flag,'!',NULL,l_XRef_Rec.Org_Independent_Flag),
744: Decode(Nvl(l_XRef_Rec.Last_Update_Date, FND_API.G_MISS_DATE),FND_API.G_MISS_DATE,NULL,l_XRef_Rec.Last_Update_Date),
745: Decode(Nvl(l_XRef_Rec.Last_Updated_By, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,NULL,-999999,NULL,l_XRef_Rec.Last_Updated_By),
746: Decode(Nvl(l_XRef_Rec.Creation_Date, FND_API.G_MISS_DATE),FND_API.G_MISS_DATE,l_mtl_XRef_Rec.Creation_Date,l_XRef_Rec.Creation_Date),
747: Decode(Nvl(l_XRef_Rec.Created_By, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Created_By,-999999,NULL,l_XRef_Rec.Created_By),

Line 744: Decode(Nvl(l_XRef_Rec.Last_Update_Date, FND_API.G_MISS_DATE),FND_API.G_MISS_DATE,NULL,l_XRef_Rec.Last_Update_Date),

740: Decode(Nvl(l_XRef_Rec.Cross_Reference_Type, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Cross_Reference_Type,'!',NULL,l_XRef_Rec.Cross_Reference_Type),
741: Decode(Nvl(l_XRef_Rec.Cross_Reference, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Cross_Reference,'!',NULL,l_XRef_Rec.Cross_Reference),
742: Decode(Nvl(l_XRef_Rec.Description, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Description,'!',NULL,l_XRef_Rec.Description),
743: Decode(Nvl(l_XRef_Rec.Org_Independent_Flag, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Org_Independent_Flag,'!',NULL,l_XRef_Rec.Org_Independent_Flag),
744: Decode(Nvl(l_XRef_Rec.Last_Update_Date, FND_API.G_MISS_DATE),FND_API.G_MISS_DATE,NULL,l_XRef_Rec.Last_Update_Date),
745: Decode(Nvl(l_XRef_Rec.Last_Updated_By, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,NULL,-999999,NULL,l_XRef_Rec.Last_Updated_By),
746: Decode(Nvl(l_XRef_Rec.Creation_Date, FND_API.G_MISS_DATE),FND_API.G_MISS_DATE,l_mtl_XRef_Rec.Creation_Date,l_XRef_Rec.Creation_Date),
747: Decode(Nvl(l_XRef_Rec.Created_By, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Created_By,-999999,NULL,l_XRef_Rec.Created_By),
748: Decode(Nvl(l_XRef_Rec.Last_Update_Login, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,NULL,-999999,NULL,l_XRef_Rec.Last_Update_Login),

Line 745: Decode(Nvl(l_XRef_Rec.Last_Updated_By, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,NULL,-999999,NULL,l_XRef_Rec.Last_Updated_By),

741: Decode(Nvl(l_XRef_Rec.Cross_Reference, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Cross_Reference,'!',NULL,l_XRef_Rec.Cross_Reference),
742: Decode(Nvl(l_XRef_Rec.Description, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Description,'!',NULL,l_XRef_Rec.Description),
743: Decode(Nvl(l_XRef_Rec.Org_Independent_Flag, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Org_Independent_Flag,'!',NULL,l_XRef_Rec.Org_Independent_Flag),
744: Decode(Nvl(l_XRef_Rec.Last_Update_Date, FND_API.G_MISS_DATE),FND_API.G_MISS_DATE,NULL,l_XRef_Rec.Last_Update_Date),
745: Decode(Nvl(l_XRef_Rec.Last_Updated_By, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,NULL,-999999,NULL,l_XRef_Rec.Last_Updated_By),
746: Decode(Nvl(l_XRef_Rec.Creation_Date, FND_API.G_MISS_DATE),FND_API.G_MISS_DATE,l_mtl_XRef_Rec.Creation_Date,l_XRef_Rec.Creation_Date),
747: Decode(Nvl(l_XRef_Rec.Created_By, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Created_By,-999999,NULL,l_XRef_Rec.Created_By),
748: Decode(Nvl(l_XRef_Rec.Last_Update_Login, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,NULL,-999999,NULL,l_XRef_Rec.Last_Update_Login),
749: Decode(Nvl(l_XRef_Rec.Request_id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Request_id,-999999,NULL,l_XRef_Rec.Request_id),

Line 746: Decode(Nvl(l_XRef_Rec.Creation_Date, FND_API.G_MISS_DATE),FND_API.G_MISS_DATE,l_mtl_XRef_Rec.Creation_Date,l_XRef_Rec.Creation_Date),

742: Decode(Nvl(l_XRef_Rec.Description, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Description,'!',NULL,l_XRef_Rec.Description),
743: Decode(Nvl(l_XRef_Rec.Org_Independent_Flag, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Org_Independent_Flag,'!',NULL,l_XRef_Rec.Org_Independent_Flag),
744: Decode(Nvl(l_XRef_Rec.Last_Update_Date, FND_API.G_MISS_DATE),FND_API.G_MISS_DATE,NULL,l_XRef_Rec.Last_Update_Date),
745: Decode(Nvl(l_XRef_Rec.Last_Updated_By, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,NULL,-999999,NULL,l_XRef_Rec.Last_Updated_By),
746: Decode(Nvl(l_XRef_Rec.Creation_Date, FND_API.G_MISS_DATE),FND_API.G_MISS_DATE,l_mtl_XRef_Rec.Creation_Date,l_XRef_Rec.Creation_Date),
747: Decode(Nvl(l_XRef_Rec.Created_By, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Created_By,-999999,NULL,l_XRef_Rec.Created_By),
748: Decode(Nvl(l_XRef_Rec.Last_Update_Login, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,NULL,-999999,NULL,l_XRef_Rec.Last_Update_Login),
749: Decode(Nvl(l_XRef_Rec.Request_id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Request_id,-999999,NULL,l_XRef_Rec.Request_id),
750: Decode(Nvl(l_XRef_Rec.Program_Application_Id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Program_Application_Id,-999999,NULL,l_XRef_Rec.Program_Application_Id),

Line 747: Decode(Nvl(l_XRef_Rec.Created_By, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Created_By,-999999,NULL,l_XRef_Rec.Created_By),

743: Decode(Nvl(l_XRef_Rec.Org_Independent_Flag, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Org_Independent_Flag,'!',NULL,l_XRef_Rec.Org_Independent_Flag),
744: Decode(Nvl(l_XRef_Rec.Last_Update_Date, FND_API.G_MISS_DATE),FND_API.G_MISS_DATE,NULL,l_XRef_Rec.Last_Update_Date),
745: Decode(Nvl(l_XRef_Rec.Last_Updated_By, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,NULL,-999999,NULL,l_XRef_Rec.Last_Updated_By),
746: Decode(Nvl(l_XRef_Rec.Creation_Date, FND_API.G_MISS_DATE),FND_API.G_MISS_DATE,l_mtl_XRef_Rec.Creation_Date,l_XRef_Rec.Creation_Date),
747: Decode(Nvl(l_XRef_Rec.Created_By, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Created_By,-999999,NULL,l_XRef_Rec.Created_By),
748: Decode(Nvl(l_XRef_Rec.Last_Update_Login, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,NULL,-999999,NULL,l_XRef_Rec.Last_Update_Login),
749: Decode(Nvl(l_XRef_Rec.Request_id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Request_id,-999999,NULL,l_XRef_Rec.Request_id),
750: Decode(Nvl(l_XRef_Rec.Program_Application_Id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Program_Application_Id,-999999,NULL,l_XRef_Rec.Program_Application_Id),
751: Decode(Nvl(l_XRef_Rec.Program_Id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_XRef_Rec.Program_Id,-999999,NULL,l_mtl_XRef_Rec.Program_Id),

Line 748: Decode(Nvl(l_XRef_Rec.Last_Update_Login, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,NULL,-999999,NULL,l_XRef_Rec.Last_Update_Login),

744: Decode(Nvl(l_XRef_Rec.Last_Update_Date, FND_API.G_MISS_DATE),FND_API.G_MISS_DATE,NULL,l_XRef_Rec.Last_Update_Date),
745: Decode(Nvl(l_XRef_Rec.Last_Updated_By, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,NULL,-999999,NULL,l_XRef_Rec.Last_Updated_By),
746: Decode(Nvl(l_XRef_Rec.Creation_Date, FND_API.G_MISS_DATE),FND_API.G_MISS_DATE,l_mtl_XRef_Rec.Creation_Date,l_XRef_Rec.Creation_Date),
747: Decode(Nvl(l_XRef_Rec.Created_By, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Created_By,-999999,NULL,l_XRef_Rec.Created_By),
748: Decode(Nvl(l_XRef_Rec.Last_Update_Login, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,NULL,-999999,NULL,l_XRef_Rec.Last_Update_Login),
749: Decode(Nvl(l_XRef_Rec.Request_id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Request_id,-999999,NULL,l_XRef_Rec.Request_id),
750: Decode(Nvl(l_XRef_Rec.Program_Application_Id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Program_Application_Id,-999999,NULL,l_XRef_Rec.Program_Application_Id),
751: Decode(Nvl(l_XRef_Rec.Program_Id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_XRef_Rec.Program_Id,-999999,NULL,l_mtl_XRef_Rec.Program_Id),
752: Decode(Nvl(l_XRef_Rec.Program_Update_Date, FND_API.G_MISS_DATE),FND_API.G_MISS_DATE,l_mtl_XRef_Rec.Program_Update_Date,l_XRef_Rec.Program_Update_Date),

Line 749: Decode(Nvl(l_XRef_Rec.Request_id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Request_id,-999999,NULL,l_XRef_Rec.Request_id),

745: Decode(Nvl(l_XRef_Rec.Last_Updated_By, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,NULL,-999999,NULL,l_XRef_Rec.Last_Updated_By),
746: Decode(Nvl(l_XRef_Rec.Creation_Date, FND_API.G_MISS_DATE),FND_API.G_MISS_DATE,l_mtl_XRef_Rec.Creation_Date,l_XRef_Rec.Creation_Date),
747: Decode(Nvl(l_XRef_Rec.Created_By, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Created_By,-999999,NULL,l_XRef_Rec.Created_By),
748: Decode(Nvl(l_XRef_Rec.Last_Update_Login, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,NULL,-999999,NULL,l_XRef_Rec.Last_Update_Login),
749: Decode(Nvl(l_XRef_Rec.Request_id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Request_id,-999999,NULL,l_XRef_Rec.Request_id),
750: Decode(Nvl(l_XRef_Rec.Program_Application_Id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Program_Application_Id,-999999,NULL,l_XRef_Rec.Program_Application_Id),
751: Decode(Nvl(l_XRef_Rec.Program_Id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_XRef_Rec.Program_Id,-999999,NULL,l_mtl_XRef_Rec.Program_Id),
752: Decode(Nvl(l_XRef_Rec.Program_Update_Date, FND_API.G_MISS_DATE),FND_API.G_MISS_DATE,l_mtl_XRef_Rec.Program_Update_Date,l_XRef_Rec.Program_Update_Date),
753: Decode(Nvl(l_XRef_Rec.Attribute1, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute1,'!',NULL,l_XRef_Rec.Attribute1),

Line 750: Decode(Nvl(l_XRef_Rec.Program_Application_Id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Program_Application_Id,-999999,NULL,l_XRef_Rec.Program_Application_Id),

746: Decode(Nvl(l_XRef_Rec.Creation_Date, FND_API.G_MISS_DATE),FND_API.G_MISS_DATE,l_mtl_XRef_Rec.Creation_Date,l_XRef_Rec.Creation_Date),
747: Decode(Nvl(l_XRef_Rec.Created_By, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Created_By,-999999,NULL,l_XRef_Rec.Created_By),
748: Decode(Nvl(l_XRef_Rec.Last_Update_Login, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,NULL,-999999,NULL,l_XRef_Rec.Last_Update_Login),
749: Decode(Nvl(l_XRef_Rec.Request_id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Request_id,-999999,NULL,l_XRef_Rec.Request_id),
750: Decode(Nvl(l_XRef_Rec.Program_Application_Id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Program_Application_Id,-999999,NULL,l_XRef_Rec.Program_Application_Id),
751: Decode(Nvl(l_XRef_Rec.Program_Id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_XRef_Rec.Program_Id,-999999,NULL,l_mtl_XRef_Rec.Program_Id),
752: Decode(Nvl(l_XRef_Rec.Program_Update_Date, FND_API.G_MISS_DATE),FND_API.G_MISS_DATE,l_mtl_XRef_Rec.Program_Update_Date,l_XRef_Rec.Program_Update_Date),
753: Decode(Nvl(l_XRef_Rec.Attribute1, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute1,'!',NULL,l_XRef_Rec.Attribute1),
754: Decode(Nvl(l_XRef_Rec.Attribute2, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute2,'!',NULL,l_XRef_Rec.Attribute2),

Line 751: Decode(Nvl(l_XRef_Rec.Program_Id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_XRef_Rec.Program_Id,-999999,NULL,l_mtl_XRef_Rec.Program_Id),

747: Decode(Nvl(l_XRef_Rec.Created_By, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Created_By,-999999,NULL,l_XRef_Rec.Created_By),
748: Decode(Nvl(l_XRef_Rec.Last_Update_Login, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,NULL,-999999,NULL,l_XRef_Rec.Last_Update_Login),
749: Decode(Nvl(l_XRef_Rec.Request_id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Request_id,-999999,NULL,l_XRef_Rec.Request_id),
750: Decode(Nvl(l_XRef_Rec.Program_Application_Id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Program_Application_Id,-999999,NULL,l_XRef_Rec.Program_Application_Id),
751: Decode(Nvl(l_XRef_Rec.Program_Id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_XRef_Rec.Program_Id,-999999,NULL,l_mtl_XRef_Rec.Program_Id),
752: Decode(Nvl(l_XRef_Rec.Program_Update_Date, FND_API.G_MISS_DATE),FND_API.G_MISS_DATE,l_mtl_XRef_Rec.Program_Update_Date,l_XRef_Rec.Program_Update_Date),
753: Decode(Nvl(l_XRef_Rec.Attribute1, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute1,'!',NULL,l_XRef_Rec.Attribute1),
754: Decode(Nvl(l_XRef_Rec.Attribute2, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute2,'!',NULL,l_XRef_Rec.Attribute2),
755: Decode(Nvl(l_XRef_Rec.Attribute3, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute3,'!',NULL,l_XRef_Rec.Attribute3),

Line 752: Decode(Nvl(l_XRef_Rec.Program_Update_Date, FND_API.G_MISS_DATE),FND_API.G_MISS_DATE,l_mtl_XRef_Rec.Program_Update_Date,l_XRef_Rec.Program_Update_Date),

748: Decode(Nvl(l_XRef_Rec.Last_Update_Login, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,NULL,-999999,NULL,l_XRef_Rec.Last_Update_Login),
749: Decode(Nvl(l_XRef_Rec.Request_id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Request_id,-999999,NULL,l_XRef_Rec.Request_id),
750: Decode(Nvl(l_XRef_Rec.Program_Application_Id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Program_Application_Id,-999999,NULL,l_XRef_Rec.Program_Application_Id),
751: Decode(Nvl(l_XRef_Rec.Program_Id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_XRef_Rec.Program_Id,-999999,NULL,l_mtl_XRef_Rec.Program_Id),
752: Decode(Nvl(l_XRef_Rec.Program_Update_Date, FND_API.G_MISS_DATE),FND_API.G_MISS_DATE,l_mtl_XRef_Rec.Program_Update_Date,l_XRef_Rec.Program_Update_Date),
753: Decode(Nvl(l_XRef_Rec.Attribute1, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute1,'!',NULL,l_XRef_Rec.Attribute1),
754: Decode(Nvl(l_XRef_Rec.Attribute2, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute2,'!',NULL,l_XRef_Rec.Attribute2),
755: Decode(Nvl(l_XRef_Rec.Attribute3, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute3,'!',NULL,l_XRef_Rec.Attribute3),
756: Decode(Nvl(l_XRef_Rec.Attribute4, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute4,'!',NULL,l_XRef_Rec.Attribute4),

Line 753: Decode(Nvl(l_XRef_Rec.Attribute1, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute1,'!',NULL,l_XRef_Rec.Attribute1),

749: Decode(Nvl(l_XRef_Rec.Request_id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Request_id,-999999,NULL,l_XRef_Rec.Request_id),
750: Decode(Nvl(l_XRef_Rec.Program_Application_Id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Program_Application_Id,-999999,NULL,l_XRef_Rec.Program_Application_Id),
751: Decode(Nvl(l_XRef_Rec.Program_Id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_XRef_Rec.Program_Id,-999999,NULL,l_mtl_XRef_Rec.Program_Id),
752: Decode(Nvl(l_XRef_Rec.Program_Update_Date, FND_API.G_MISS_DATE),FND_API.G_MISS_DATE,l_mtl_XRef_Rec.Program_Update_Date,l_XRef_Rec.Program_Update_Date),
753: Decode(Nvl(l_XRef_Rec.Attribute1, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute1,'!',NULL,l_XRef_Rec.Attribute1),
754: Decode(Nvl(l_XRef_Rec.Attribute2, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute2,'!',NULL,l_XRef_Rec.Attribute2),
755: Decode(Nvl(l_XRef_Rec.Attribute3, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute3,'!',NULL,l_XRef_Rec.Attribute3),
756: Decode(Nvl(l_XRef_Rec.Attribute4, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute4,'!',NULL,l_XRef_Rec.Attribute4),
757: Decode(Nvl(l_XRef_Rec.Attribute5, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute5,'!',NULL,l_XRef_Rec.Attribute5),

Line 754: Decode(Nvl(l_XRef_Rec.Attribute2, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute2,'!',NULL,l_XRef_Rec.Attribute2),

750: Decode(Nvl(l_XRef_Rec.Program_Application_Id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Program_Application_Id,-999999,NULL,l_XRef_Rec.Program_Application_Id),
751: Decode(Nvl(l_XRef_Rec.Program_Id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_XRef_Rec.Program_Id,-999999,NULL,l_mtl_XRef_Rec.Program_Id),
752: Decode(Nvl(l_XRef_Rec.Program_Update_Date, FND_API.G_MISS_DATE),FND_API.G_MISS_DATE,l_mtl_XRef_Rec.Program_Update_Date,l_XRef_Rec.Program_Update_Date),
753: Decode(Nvl(l_XRef_Rec.Attribute1, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute1,'!',NULL,l_XRef_Rec.Attribute1),
754: Decode(Nvl(l_XRef_Rec.Attribute2, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute2,'!',NULL,l_XRef_Rec.Attribute2),
755: Decode(Nvl(l_XRef_Rec.Attribute3, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute3,'!',NULL,l_XRef_Rec.Attribute3),
756: Decode(Nvl(l_XRef_Rec.Attribute4, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute4,'!',NULL,l_XRef_Rec.Attribute4),
757: Decode(Nvl(l_XRef_Rec.Attribute5, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute5,'!',NULL,l_XRef_Rec.Attribute5),
758: Decode(Nvl(l_XRef_Rec.Attribute6, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute6,'!',NULL,l_XRef_Rec.Attribute6),

Line 755: Decode(Nvl(l_XRef_Rec.Attribute3, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute3,'!',NULL,l_XRef_Rec.Attribute3),

751: Decode(Nvl(l_XRef_Rec.Program_Id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_XRef_Rec.Program_Id,-999999,NULL,l_mtl_XRef_Rec.Program_Id),
752: Decode(Nvl(l_XRef_Rec.Program_Update_Date, FND_API.G_MISS_DATE),FND_API.G_MISS_DATE,l_mtl_XRef_Rec.Program_Update_Date,l_XRef_Rec.Program_Update_Date),
753: Decode(Nvl(l_XRef_Rec.Attribute1, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute1,'!',NULL,l_XRef_Rec.Attribute1),
754: Decode(Nvl(l_XRef_Rec.Attribute2, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute2,'!',NULL,l_XRef_Rec.Attribute2),
755: Decode(Nvl(l_XRef_Rec.Attribute3, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute3,'!',NULL,l_XRef_Rec.Attribute3),
756: Decode(Nvl(l_XRef_Rec.Attribute4, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute4,'!',NULL,l_XRef_Rec.Attribute4),
757: Decode(Nvl(l_XRef_Rec.Attribute5, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute5,'!',NULL,l_XRef_Rec.Attribute5),
758: Decode(Nvl(l_XRef_Rec.Attribute6, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute6,'!',NULL,l_XRef_Rec.Attribute6),
759: Decode(Nvl(l_XRef_Rec.Attribute7, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute7,'!',NULL,l_XRef_Rec.Attribute7),

Line 756: Decode(Nvl(l_XRef_Rec.Attribute4, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute4,'!',NULL,l_XRef_Rec.Attribute4),

752: Decode(Nvl(l_XRef_Rec.Program_Update_Date, FND_API.G_MISS_DATE),FND_API.G_MISS_DATE,l_mtl_XRef_Rec.Program_Update_Date,l_XRef_Rec.Program_Update_Date),
753: Decode(Nvl(l_XRef_Rec.Attribute1, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute1,'!',NULL,l_XRef_Rec.Attribute1),
754: Decode(Nvl(l_XRef_Rec.Attribute2, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute2,'!',NULL,l_XRef_Rec.Attribute2),
755: Decode(Nvl(l_XRef_Rec.Attribute3, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute3,'!',NULL,l_XRef_Rec.Attribute3),
756: Decode(Nvl(l_XRef_Rec.Attribute4, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute4,'!',NULL,l_XRef_Rec.Attribute4),
757: Decode(Nvl(l_XRef_Rec.Attribute5, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute5,'!',NULL,l_XRef_Rec.Attribute5),
758: Decode(Nvl(l_XRef_Rec.Attribute6, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute6,'!',NULL,l_XRef_Rec.Attribute6),
759: Decode(Nvl(l_XRef_Rec.Attribute7, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute7,'!',NULL,l_XRef_Rec.Attribute7),
760: Decode(Nvl(l_XRef_Rec.Attribute8, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute8,'!',NULL,l_XRef_Rec.Attribute8),

Line 757: Decode(Nvl(l_XRef_Rec.Attribute5, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute5,'!',NULL,l_XRef_Rec.Attribute5),

753: Decode(Nvl(l_XRef_Rec.Attribute1, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute1,'!',NULL,l_XRef_Rec.Attribute1),
754: Decode(Nvl(l_XRef_Rec.Attribute2, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute2,'!',NULL,l_XRef_Rec.Attribute2),
755: Decode(Nvl(l_XRef_Rec.Attribute3, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute3,'!',NULL,l_XRef_Rec.Attribute3),
756: Decode(Nvl(l_XRef_Rec.Attribute4, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute4,'!',NULL,l_XRef_Rec.Attribute4),
757: Decode(Nvl(l_XRef_Rec.Attribute5, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute5,'!',NULL,l_XRef_Rec.Attribute5),
758: Decode(Nvl(l_XRef_Rec.Attribute6, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute6,'!',NULL,l_XRef_Rec.Attribute6),
759: Decode(Nvl(l_XRef_Rec.Attribute7, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute7,'!',NULL,l_XRef_Rec.Attribute7),
760: Decode(Nvl(l_XRef_Rec.Attribute8, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute8,'!',NULL,l_XRef_Rec.Attribute8),
761: Decode(Nvl(l_XRef_Rec.Attribute9, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute9,'!',NULL,l_XRef_Rec.Attribute9),

Line 758: Decode(Nvl(l_XRef_Rec.Attribute6, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute6,'!',NULL,l_XRef_Rec.Attribute6),

754: Decode(Nvl(l_XRef_Rec.Attribute2, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute2,'!',NULL,l_XRef_Rec.Attribute2),
755: Decode(Nvl(l_XRef_Rec.Attribute3, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute3,'!',NULL,l_XRef_Rec.Attribute3),
756: Decode(Nvl(l_XRef_Rec.Attribute4, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute4,'!',NULL,l_XRef_Rec.Attribute4),
757: Decode(Nvl(l_XRef_Rec.Attribute5, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute5,'!',NULL,l_XRef_Rec.Attribute5),
758: Decode(Nvl(l_XRef_Rec.Attribute6, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute6,'!',NULL,l_XRef_Rec.Attribute6),
759: Decode(Nvl(l_XRef_Rec.Attribute7, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute7,'!',NULL,l_XRef_Rec.Attribute7),
760: Decode(Nvl(l_XRef_Rec.Attribute8, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute8,'!',NULL,l_XRef_Rec.Attribute8),
761: Decode(Nvl(l_XRef_Rec.Attribute9, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute9,'!',NULL,l_XRef_Rec.Attribute9),
762: Decode(Nvl(l_XRef_Rec.Attribute10, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute10,'!',NULL,l_XRef_Rec.Attribute10),

Line 759: Decode(Nvl(l_XRef_Rec.Attribute7, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute7,'!',NULL,l_XRef_Rec.Attribute7),

755: Decode(Nvl(l_XRef_Rec.Attribute3, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute3,'!',NULL,l_XRef_Rec.Attribute3),
756: Decode(Nvl(l_XRef_Rec.Attribute4, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute4,'!',NULL,l_XRef_Rec.Attribute4),
757: Decode(Nvl(l_XRef_Rec.Attribute5, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute5,'!',NULL,l_XRef_Rec.Attribute5),
758: Decode(Nvl(l_XRef_Rec.Attribute6, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute6,'!',NULL,l_XRef_Rec.Attribute6),
759: Decode(Nvl(l_XRef_Rec.Attribute7, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute7,'!',NULL,l_XRef_Rec.Attribute7),
760: Decode(Nvl(l_XRef_Rec.Attribute8, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute8,'!',NULL,l_XRef_Rec.Attribute8),
761: Decode(Nvl(l_XRef_Rec.Attribute9, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute9,'!',NULL,l_XRef_Rec.Attribute9),
762: Decode(Nvl(l_XRef_Rec.Attribute10, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute10,'!',NULL,l_XRef_Rec.Attribute10),
763: Decode(Nvl(l_XRef_Rec.Attribute11, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute11,'!',NULL,l_XRef_Rec.Attribute11),

Line 760: Decode(Nvl(l_XRef_Rec.Attribute8, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute8,'!',NULL,l_XRef_Rec.Attribute8),

756: Decode(Nvl(l_XRef_Rec.Attribute4, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute4,'!',NULL,l_XRef_Rec.Attribute4),
757: Decode(Nvl(l_XRef_Rec.Attribute5, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute5,'!',NULL,l_XRef_Rec.Attribute5),
758: Decode(Nvl(l_XRef_Rec.Attribute6, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute6,'!',NULL,l_XRef_Rec.Attribute6),
759: Decode(Nvl(l_XRef_Rec.Attribute7, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute7,'!',NULL,l_XRef_Rec.Attribute7),
760: Decode(Nvl(l_XRef_Rec.Attribute8, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute8,'!',NULL,l_XRef_Rec.Attribute8),
761: Decode(Nvl(l_XRef_Rec.Attribute9, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute9,'!',NULL,l_XRef_Rec.Attribute9),
762: Decode(Nvl(l_XRef_Rec.Attribute10, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute10,'!',NULL,l_XRef_Rec.Attribute10),
763: Decode(Nvl(l_XRef_Rec.Attribute11, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute11,'!',NULL,l_XRef_Rec.Attribute11),
764: Decode(Nvl(l_XRef_Rec.Attribute12, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute12,'!',NULL,l_XRef_Rec.Attribute12),

Line 761: Decode(Nvl(l_XRef_Rec.Attribute9, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute9,'!',NULL,l_XRef_Rec.Attribute9),

757: Decode(Nvl(l_XRef_Rec.Attribute5, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute5,'!',NULL,l_XRef_Rec.Attribute5),
758: Decode(Nvl(l_XRef_Rec.Attribute6, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute6,'!',NULL,l_XRef_Rec.Attribute6),
759: Decode(Nvl(l_XRef_Rec.Attribute7, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute7,'!',NULL,l_XRef_Rec.Attribute7),
760: Decode(Nvl(l_XRef_Rec.Attribute8, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute8,'!',NULL,l_XRef_Rec.Attribute8),
761: Decode(Nvl(l_XRef_Rec.Attribute9, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute9,'!',NULL,l_XRef_Rec.Attribute9),
762: Decode(Nvl(l_XRef_Rec.Attribute10, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute10,'!',NULL,l_XRef_Rec.Attribute10),
763: Decode(Nvl(l_XRef_Rec.Attribute11, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute11,'!',NULL,l_XRef_Rec.Attribute11),
764: Decode(Nvl(l_XRef_Rec.Attribute12, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute12,'!',NULL,l_XRef_Rec.Attribute12),
765: Decode(Nvl(l_XRef_Rec.Attribute13, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute13,'!',NULL,l_XRef_Rec.Attribute13),

Line 762: Decode(Nvl(l_XRef_Rec.Attribute10, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute10,'!',NULL,l_XRef_Rec.Attribute10),

758: Decode(Nvl(l_XRef_Rec.Attribute6, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute6,'!',NULL,l_XRef_Rec.Attribute6),
759: Decode(Nvl(l_XRef_Rec.Attribute7, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute7,'!',NULL,l_XRef_Rec.Attribute7),
760: Decode(Nvl(l_XRef_Rec.Attribute8, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute8,'!',NULL,l_XRef_Rec.Attribute8),
761: Decode(Nvl(l_XRef_Rec.Attribute9, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute9,'!',NULL,l_XRef_Rec.Attribute9),
762: Decode(Nvl(l_XRef_Rec.Attribute10, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute10,'!',NULL,l_XRef_Rec.Attribute10),
763: Decode(Nvl(l_XRef_Rec.Attribute11, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute11,'!',NULL,l_XRef_Rec.Attribute11),
764: Decode(Nvl(l_XRef_Rec.Attribute12, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute12,'!',NULL,l_XRef_Rec.Attribute12),
765: Decode(Nvl(l_XRef_Rec.Attribute13, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute13,'!',NULL,l_XRef_Rec.Attribute13),
766: Decode(Nvl(l_XRef_Rec.Attribute14, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute14,'!',NULL,l_XRef_Rec.Attribute14),

Line 763: Decode(Nvl(l_XRef_Rec.Attribute11, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute11,'!',NULL,l_XRef_Rec.Attribute11),

759: Decode(Nvl(l_XRef_Rec.Attribute7, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute7,'!',NULL,l_XRef_Rec.Attribute7),
760: Decode(Nvl(l_XRef_Rec.Attribute8, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute8,'!',NULL,l_XRef_Rec.Attribute8),
761: Decode(Nvl(l_XRef_Rec.Attribute9, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute9,'!',NULL,l_XRef_Rec.Attribute9),
762: Decode(Nvl(l_XRef_Rec.Attribute10, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute10,'!',NULL,l_XRef_Rec.Attribute10),
763: Decode(Nvl(l_XRef_Rec.Attribute11, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute11,'!',NULL,l_XRef_Rec.Attribute11),
764: Decode(Nvl(l_XRef_Rec.Attribute12, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute12,'!',NULL,l_XRef_Rec.Attribute12),
765: Decode(Nvl(l_XRef_Rec.Attribute13, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute13,'!',NULL,l_XRef_Rec.Attribute13),
766: Decode(Nvl(l_XRef_Rec.Attribute14, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute14,'!',NULL,l_XRef_Rec.Attribute14),
767: Decode(Nvl(l_XRef_Rec.Attribute15, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute15,'!',NULL,l_XRef_Rec.Attribute15),

Line 764: Decode(Nvl(l_XRef_Rec.Attribute12, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute12,'!',NULL,l_XRef_Rec.Attribute12),

760: Decode(Nvl(l_XRef_Rec.Attribute8, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute8,'!',NULL,l_XRef_Rec.Attribute8),
761: Decode(Nvl(l_XRef_Rec.Attribute9, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute9,'!',NULL,l_XRef_Rec.Attribute9),
762: Decode(Nvl(l_XRef_Rec.Attribute10, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute10,'!',NULL,l_XRef_Rec.Attribute10),
763: Decode(Nvl(l_XRef_Rec.Attribute11, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute11,'!',NULL,l_XRef_Rec.Attribute11),
764: Decode(Nvl(l_XRef_Rec.Attribute12, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute12,'!',NULL,l_XRef_Rec.Attribute12),
765: Decode(Nvl(l_XRef_Rec.Attribute13, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute13,'!',NULL,l_XRef_Rec.Attribute13),
766: Decode(Nvl(l_XRef_Rec.Attribute14, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute14,'!',NULL,l_XRef_Rec.Attribute14),
767: Decode(Nvl(l_XRef_Rec.Attribute15, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute15,'!',NULL,l_XRef_Rec.Attribute15),
768: Decode(Nvl(l_XRef_Rec.Attribute_category, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute_category,'!',NULL,l_XRef_Rec.Attribute_category),

Line 765: Decode(Nvl(l_XRef_Rec.Attribute13, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute13,'!',NULL,l_XRef_Rec.Attribute13),

761: Decode(Nvl(l_XRef_Rec.Attribute9, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute9,'!',NULL,l_XRef_Rec.Attribute9),
762: Decode(Nvl(l_XRef_Rec.Attribute10, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute10,'!',NULL,l_XRef_Rec.Attribute10),
763: Decode(Nvl(l_XRef_Rec.Attribute11, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute11,'!',NULL,l_XRef_Rec.Attribute11),
764: Decode(Nvl(l_XRef_Rec.Attribute12, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute12,'!',NULL,l_XRef_Rec.Attribute12),
765: Decode(Nvl(l_XRef_Rec.Attribute13, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute13,'!',NULL,l_XRef_Rec.Attribute13),
766: Decode(Nvl(l_XRef_Rec.Attribute14, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute14,'!',NULL,l_XRef_Rec.Attribute14),
767: Decode(Nvl(l_XRef_Rec.Attribute15, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute15,'!',NULL,l_XRef_Rec.Attribute15),
768: Decode(Nvl(l_XRef_Rec.Attribute_category, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute_category,'!',NULL,l_XRef_Rec.Attribute_category),
769: Decode(Nvl(l_XRef_Rec.Uom_Code, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Uom_Code,'!',NULL,l_XRef_Rec.Uom_Code),

Line 766: Decode(Nvl(l_XRef_Rec.Attribute14, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute14,'!',NULL,l_XRef_Rec.Attribute14),

762: Decode(Nvl(l_XRef_Rec.Attribute10, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute10,'!',NULL,l_XRef_Rec.Attribute10),
763: Decode(Nvl(l_XRef_Rec.Attribute11, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute11,'!',NULL,l_XRef_Rec.Attribute11),
764: Decode(Nvl(l_XRef_Rec.Attribute12, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute12,'!',NULL,l_XRef_Rec.Attribute12),
765: Decode(Nvl(l_XRef_Rec.Attribute13, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute13,'!',NULL,l_XRef_Rec.Attribute13),
766: Decode(Nvl(l_XRef_Rec.Attribute14, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute14,'!',NULL,l_XRef_Rec.Attribute14),
767: Decode(Nvl(l_XRef_Rec.Attribute15, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute15,'!',NULL,l_XRef_Rec.Attribute15),
768: Decode(Nvl(l_XRef_Rec.Attribute_category, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute_category,'!',NULL,l_XRef_Rec.Attribute_category),
769: Decode(Nvl(l_XRef_Rec.Uom_Code, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Uom_Code,'!',NULL,l_XRef_Rec.Uom_Code),
770: Decode(Nvl(l_XRef_Rec.Revision_Id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Revision_Id,-999999,NULL,l_XRef_Rec.Revision_Id),

Line 767: Decode(Nvl(l_XRef_Rec.Attribute15, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute15,'!',NULL,l_XRef_Rec.Attribute15),

763: Decode(Nvl(l_XRef_Rec.Attribute11, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute11,'!',NULL,l_XRef_Rec.Attribute11),
764: Decode(Nvl(l_XRef_Rec.Attribute12, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute12,'!',NULL,l_XRef_Rec.Attribute12),
765: Decode(Nvl(l_XRef_Rec.Attribute13, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute13,'!',NULL,l_XRef_Rec.Attribute13),
766: Decode(Nvl(l_XRef_Rec.Attribute14, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute14,'!',NULL,l_XRef_Rec.Attribute14),
767: Decode(Nvl(l_XRef_Rec.Attribute15, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute15,'!',NULL,l_XRef_Rec.Attribute15),
768: Decode(Nvl(l_XRef_Rec.Attribute_category, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute_category,'!',NULL,l_XRef_Rec.Attribute_category),
769: Decode(Nvl(l_XRef_Rec.Uom_Code, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Uom_Code,'!',NULL,l_XRef_Rec.Uom_Code),
770: Decode(Nvl(l_XRef_Rec.Revision_Id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Revision_Id,-999999,NULL,l_XRef_Rec.Revision_Id),
771: Decode(Nvl(l_XRef_Rec.Epc_Gtin_Serial, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Epc_Gtin_Serial,-999999,NULL,l_XRef_Rec.Epc_Gtin_Serial)

Line 768: Decode(Nvl(l_XRef_Rec.Attribute_category, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute_category,'!',NULL,l_XRef_Rec.Attribute_category),

764: Decode(Nvl(l_XRef_Rec.Attribute12, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute12,'!',NULL,l_XRef_Rec.Attribute12),
765: Decode(Nvl(l_XRef_Rec.Attribute13, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute13,'!',NULL,l_XRef_Rec.Attribute13),
766: Decode(Nvl(l_XRef_Rec.Attribute14, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute14,'!',NULL,l_XRef_Rec.Attribute14),
767: Decode(Nvl(l_XRef_Rec.Attribute15, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute15,'!',NULL,l_XRef_Rec.Attribute15),
768: Decode(Nvl(l_XRef_Rec.Attribute_category, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute_category,'!',NULL,l_XRef_Rec.Attribute_category),
769: Decode(Nvl(l_XRef_Rec.Uom_Code, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Uom_Code,'!',NULL,l_XRef_Rec.Uom_Code),
770: Decode(Nvl(l_XRef_Rec.Revision_Id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Revision_Id,-999999,NULL,l_XRef_Rec.Revision_Id),
771: Decode(Nvl(l_XRef_Rec.Epc_Gtin_Serial, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Epc_Gtin_Serial,-999999,NULL,l_XRef_Rec.Epc_Gtin_Serial)
772: INTO l_XRef_Rec.Inventory_Item_Id,l_XRef_Rec.Organization_Id, l_XRef_Rec.Cross_Reference_Type,l_XRef_Rec.Cross_Reference,

Line 769: Decode(Nvl(l_XRef_Rec.Uom_Code, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Uom_Code,'!',NULL,l_XRef_Rec.Uom_Code),

765: Decode(Nvl(l_XRef_Rec.Attribute13, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute13,'!',NULL,l_XRef_Rec.Attribute13),
766: Decode(Nvl(l_XRef_Rec.Attribute14, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute14,'!',NULL,l_XRef_Rec.Attribute14),
767: Decode(Nvl(l_XRef_Rec.Attribute15, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute15,'!',NULL,l_XRef_Rec.Attribute15),
768: Decode(Nvl(l_XRef_Rec.Attribute_category, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute_category,'!',NULL,l_XRef_Rec.Attribute_category),
769: Decode(Nvl(l_XRef_Rec.Uom_Code, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Uom_Code,'!',NULL,l_XRef_Rec.Uom_Code),
770: Decode(Nvl(l_XRef_Rec.Revision_Id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Revision_Id,-999999,NULL,l_XRef_Rec.Revision_Id),
771: Decode(Nvl(l_XRef_Rec.Epc_Gtin_Serial, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Epc_Gtin_Serial,-999999,NULL,l_XRef_Rec.Epc_Gtin_Serial)
772: INTO l_XRef_Rec.Inventory_Item_Id,l_XRef_Rec.Organization_Id, l_XRef_Rec.Cross_Reference_Type,l_XRef_Rec.Cross_Reference,
773: l_XRef_Rec.Description,l_XRef_Rec.Org_Independent_Flag,l_XRef_Rec.Last_Update_Date,l_XRef_Rec.Last_Updated_By,l_XRef_Rec.Creation_Date,

Line 770: Decode(Nvl(l_XRef_Rec.Revision_Id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Revision_Id,-999999,NULL,l_XRef_Rec.Revision_Id),

766: Decode(Nvl(l_XRef_Rec.Attribute14, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute14,'!',NULL,l_XRef_Rec.Attribute14),
767: Decode(Nvl(l_XRef_Rec.Attribute15, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute15,'!',NULL,l_XRef_Rec.Attribute15),
768: Decode(Nvl(l_XRef_Rec.Attribute_category, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute_category,'!',NULL,l_XRef_Rec.Attribute_category),
769: Decode(Nvl(l_XRef_Rec.Uom_Code, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Uom_Code,'!',NULL,l_XRef_Rec.Uom_Code),
770: Decode(Nvl(l_XRef_Rec.Revision_Id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Revision_Id,-999999,NULL,l_XRef_Rec.Revision_Id),
771: Decode(Nvl(l_XRef_Rec.Epc_Gtin_Serial, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Epc_Gtin_Serial,-999999,NULL,l_XRef_Rec.Epc_Gtin_Serial)
772: INTO l_XRef_Rec.Inventory_Item_Id,l_XRef_Rec.Organization_Id, l_XRef_Rec.Cross_Reference_Type,l_XRef_Rec.Cross_Reference,
773: l_XRef_Rec.Description,l_XRef_Rec.Org_Independent_Flag,l_XRef_Rec.Last_Update_Date,l_XRef_Rec.Last_Updated_By,l_XRef_Rec.Creation_Date,
774: l_XRef_Rec.Created_By,l_XRef_Rec.Last_Update_Login,l_XRef_Rec.Request_id,l_XRef_Rec.Program_Application_Id,l_XRef_Rec.Program_Id,

Line 771: Decode(Nvl(l_XRef_Rec.Epc_Gtin_Serial, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Epc_Gtin_Serial,-999999,NULL,l_XRef_Rec.Epc_Gtin_Serial)

767: Decode(Nvl(l_XRef_Rec.Attribute15, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute15,'!',NULL,l_XRef_Rec.Attribute15),
768: Decode(Nvl(l_XRef_Rec.Attribute_category, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute_category,'!',NULL,l_XRef_Rec.Attribute_category),
769: Decode(Nvl(l_XRef_Rec.Uom_Code, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Uom_Code,'!',NULL,l_XRef_Rec.Uom_Code),
770: Decode(Nvl(l_XRef_Rec.Revision_Id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Revision_Id,-999999,NULL,l_XRef_Rec.Revision_Id),
771: Decode(Nvl(l_XRef_Rec.Epc_Gtin_Serial, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Epc_Gtin_Serial,-999999,NULL,l_XRef_Rec.Epc_Gtin_Serial)
772: INTO l_XRef_Rec.Inventory_Item_Id,l_XRef_Rec.Organization_Id, l_XRef_Rec.Cross_Reference_Type,l_XRef_Rec.Cross_Reference,
773: l_XRef_Rec.Description,l_XRef_Rec.Org_Independent_Flag,l_XRef_Rec.Last_Update_Date,l_XRef_Rec.Last_Updated_By,l_XRef_Rec.Creation_Date,
774: l_XRef_Rec.Created_By,l_XRef_Rec.Last_Update_Login,l_XRef_Rec.Request_id,l_XRef_Rec.Program_Application_Id,l_XRef_Rec.Program_Id,
775: l_XRef_Rec.Program_Update_Date,l_XRef_Rec.Attribute1,l_XRef_Rec.Attribute2,l_XRef_Rec.Attribute3,l_XRef_Rec.Attribute4,

Line 786: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;

782: -- organization validation -- both org_indp_flag and org_id NOT NULL
783: IF l_XRef_Rec.Organization_Id IS NOT NULL THEN
784:
785: IF l_XRef_Rec.Org_Independent_Flag='Y' THEN
786: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
787: Error_Handler.Add_Error_Message
788: (
789: p_message_name => 'INV_XREF_ORG_FLAG'
790: ,p_application_id => 'INV'

Line 804: OR l_XRef_Rec.Org_Independent_Flag = FND_API.G_MISS_CHAR THEN

800: -- if org_id and org_indp_flag both NULL
801: IF l_XRef_Rec.Organization_Id IS NULL THEN
802:
803: IF l_XRef_Rec.Org_Independent_Flag IS NULL
804: OR l_XRef_Rec.Org_Independent_Flag = FND_API.G_MISS_CHAR THEN
805:
806: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
807: Error_Handler.Add_Error_Message
808: (

Line 806: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;

802:
803: IF l_XRef_Rec.Org_Independent_Flag IS NULL
804: OR l_XRef_Rec.Org_Independent_Flag = FND_API.G_MISS_CHAR THEN
805:
806: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
807: Error_Handler.Add_Error_Message
808: (
809: p_message_name => 'INV_XREF_NULL_ORG'
810: ,p_application_id => 'INV'

Line 822: AND l_XRef_Rec.Organization_Id <>FND_API.G_MISS_NUM

818: END IF ;
819:
820: -- checking for Item existance for given org.
821: IF l_XRef_Rec.Organization_Id IS NOT NULL
822: AND l_XRef_Rec.Organization_Id <>FND_API.G_MISS_NUM
823: AND l_XRef_Rec.Inventory_Item_Id <>FND_API.G_MISS_NUM THEN
824:
825: BEGIN
826: SELECT 'x' INTO l_exists

Line 823: AND l_XRef_Rec.Inventory_Item_Id <>FND_API.G_MISS_NUM THEN

819:
820: -- checking for Item existance for given org.
821: IF l_XRef_Rec.Organization_Id IS NOT NULL
822: AND l_XRef_Rec.Organization_Id <>FND_API.G_MISS_NUM
823: AND l_XRef_Rec.Inventory_Item_Id <>FND_API.G_MISS_NUM THEN
824:
825: BEGIN
826: SELECT 'x' INTO l_exists
827: FROM mtl_system_items_b

Line 832: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;

828: WHERE Inventory_item_id = l_XRef_Rec.Inventory_Item_Id
829: AND Organization_id = l_XRef_Rec.Organization_Id;
830: EXCEPTION
831: WHEN NO_DATA_FOUND THEN
832: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
833: Error_Handler.Add_Error_Message
834: (
835: p_message_name => 'INV_INVALID_ITEM_ORG'
836: ,p_application_id => 'INV'

Line 849: AND l_XRef_Rec.Uom_Code <> FND_API.G_MISS_CHAR) THEN

845:
846: -- Checking for Revision_Id and UOM_Cde Values
847:
848: IF (l_XRef_Rec.Uom_Code IS NOT NULL
849: AND l_XRef_Rec.Uom_Code <> FND_API.G_MISS_CHAR) THEN
850:
851: IF NVL(FND_PROFILE.VALUE('INV:GTIN_CROSS_REFERENCE_TYPE'),FND_API.G_MISS_CHAR) <> l_mtl_XRef_rec.CROSS_REFERENCE_TYPE THEN /* bug 14138918 */
852: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
853: Error_Handler.Add_Error_Message

Line 851: IF NVL(FND_PROFILE.VALUE('INV:GTIN_CROSS_REFERENCE_TYPE'),FND_API.G_MISS_CHAR) <> l_mtl_XRef_rec.CROSS_REFERENCE_TYPE THEN /* bug 14138918 */

847:
848: IF (l_XRef_Rec.Uom_Code IS NOT NULL
849: AND l_XRef_Rec.Uom_Code <> FND_API.G_MISS_CHAR) THEN
850:
851: IF NVL(FND_PROFILE.VALUE('INV:GTIN_CROSS_REFERENCE_TYPE'),FND_API.G_MISS_CHAR) <> l_mtl_XRef_rec.CROSS_REFERENCE_TYPE THEN /* bug 14138918 */
852: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
853: Error_Handler.Add_Error_Message
854: (
855: p_message_name => 'INV_XREF_INVALID_COLUMN_VALUE'

Line 852: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;

848: IF (l_XRef_Rec.Uom_Code IS NOT NULL
849: AND l_XRef_Rec.Uom_Code <> FND_API.G_MISS_CHAR) THEN
850:
851: IF NVL(FND_PROFILE.VALUE('INV:GTIN_CROSS_REFERENCE_TYPE'),FND_API.G_MISS_CHAR) <> l_mtl_XRef_rec.CROSS_REFERENCE_TYPE THEN /* bug 14138918 */
852: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
853: Error_Handler.Add_Error_Message
854: (
855: p_message_name => 'INV_XREF_INVALID_COLUMN_VALUE'
856: ,p_application_id => 'INV'

Line 872: and organization_id = Decode (l_mtl_XRef_rec.Organization_Id,FND_API.G_MISS_CHAR,organization_id,NULL,organization_id,organization_id)

868: l_Xref_Rec.Uom_Code IN (
869: select Uom_code
870: from mtl_uom_conversions_view
871: where inventory_item_id = l_mtl_XRef_rec.INVENTORY_ITEM_ID
872: and organization_id = Decode (l_mtl_XRef_rec.Organization_Id,FND_API.G_MISS_CHAR,organization_id,NULL,organization_id,organization_id)
873: )
874: AND ROWNUM=1;
875: EXCEPTION
876: WHEN No_Data_Found THEN

Line 878: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;

874: AND ROWNUM=1;
875: EXCEPTION
876: WHEN No_Data_Found THEN
877:
878: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
879: Error_Handler.Add_Error_Message
880: (
881: p_message_name => 'INV_CCEOI_INVALID_UOM'
882: ,p_application_id => 'INV'

Line 895: AND l_XRef_Rec.Revision_Id <> FND_API.G_MISS_NUM) THEN

891: END IF; /* end if of uom_code*/
892:
893:
894: IF (l_XRef_Rec.Revision_Id IS NOT NULL
895: AND l_XRef_Rec.Revision_Id <> FND_API.G_MISS_NUM) THEN
896:
897: IF NVL(FND_PROFILE.VALUE('INV:GTIN_CROSS_REFERENCE_TYPE'),FND_API.G_MISS_CHAR) <> l_mtl_XRef_rec.CROSS_REFERENCE_TYPE
898: OR ((l_XRef_Rec.Org_Independent_Flag <>'N') AND (l_XRef_Rec.Org_Independent_Flag <>FND_API.G_MISS_CHAR))
899: OR ((l_XRef_Rec.Org_Independent_Flag IS NULL ))

Line 897: IF NVL(FND_PROFILE.VALUE('INV:GTIN_CROSS_REFERENCE_TYPE'),FND_API.G_MISS_CHAR) <> l_mtl_XRef_rec.CROSS_REFERENCE_TYPE

893:
894: IF (l_XRef_Rec.Revision_Id IS NOT NULL
895: AND l_XRef_Rec.Revision_Id <> FND_API.G_MISS_NUM) THEN
896:
897: IF NVL(FND_PROFILE.VALUE('INV:GTIN_CROSS_REFERENCE_TYPE'),FND_API.G_MISS_CHAR) <> l_mtl_XRef_rec.CROSS_REFERENCE_TYPE
898: OR ((l_XRef_Rec.Org_Independent_Flag <>'N') AND (l_XRef_Rec.Org_Independent_Flag <>FND_API.G_MISS_CHAR))
899: OR ((l_XRef_Rec.Org_Independent_Flag IS NULL ))
900: OR ((l_XRef_Rec.Org_Independent_Flag = FND_API.G_MISS_CHAR) AND (l_mtl_XRef_rec.Org_Independent_Flag <>'N'))
901: OR ((l_XRef_Rec.Organization_Id IS NULL))

Line 898: OR ((l_XRef_Rec.Org_Independent_Flag <>'N') AND (l_XRef_Rec.Org_Independent_Flag <>FND_API.G_MISS_CHAR))

894: IF (l_XRef_Rec.Revision_Id IS NOT NULL
895: AND l_XRef_Rec.Revision_Id <> FND_API.G_MISS_NUM) THEN
896:
897: IF NVL(FND_PROFILE.VALUE('INV:GTIN_CROSS_REFERENCE_TYPE'),FND_API.G_MISS_CHAR) <> l_mtl_XRef_rec.CROSS_REFERENCE_TYPE
898: OR ((l_XRef_Rec.Org_Independent_Flag <>'N') AND (l_XRef_Rec.Org_Independent_Flag <>FND_API.G_MISS_CHAR))
899: OR ((l_XRef_Rec.Org_Independent_Flag IS NULL ))
900: OR ((l_XRef_Rec.Org_Independent_Flag = FND_API.G_MISS_CHAR) AND (l_mtl_XRef_rec.Org_Independent_Flag <>'N'))
901: OR ((l_XRef_Rec.Organization_Id IS NULL))
902: OR ((l_XRef_Rec.Organization_Id = FND_API.G_MISS_NUM) AND (l_mtl_XRef_rec.Organization_Id IS NULL ))

Line 900: OR ((l_XRef_Rec.Org_Independent_Flag = FND_API.G_MISS_CHAR) AND (l_mtl_XRef_rec.Org_Independent_Flag <>'N'))

896:
897: IF NVL(FND_PROFILE.VALUE('INV:GTIN_CROSS_REFERENCE_TYPE'),FND_API.G_MISS_CHAR) <> l_mtl_XRef_rec.CROSS_REFERENCE_TYPE
898: OR ((l_XRef_Rec.Org_Independent_Flag <>'N') AND (l_XRef_Rec.Org_Independent_Flag <>FND_API.G_MISS_CHAR))
899: OR ((l_XRef_Rec.Org_Independent_Flag IS NULL ))
900: OR ((l_XRef_Rec.Org_Independent_Flag = FND_API.G_MISS_CHAR) AND (l_mtl_XRef_rec.Org_Independent_Flag <>'N'))
901: OR ((l_XRef_Rec.Organization_Id IS NULL))
902: OR ((l_XRef_Rec.Organization_Id = FND_API.G_MISS_NUM) AND (l_mtl_XRef_rec.Organization_Id IS NULL ))
903: THEN /* bug 14138918 */
904:

Line 902: OR ((l_XRef_Rec.Organization_Id = FND_API.G_MISS_NUM) AND (l_mtl_XRef_rec.Organization_Id IS NULL ))

898: OR ((l_XRef_Rec.Org_Independent_Flag <>'N') AND (l_XRef_Rec.Org_Independent_Flag <>FND_API.G_MISS_CHAR))
899: OR ((l_XRef_Rec.Org_Independent_Flag IS NULL ))
900: OR ((l_XRef_Rec.Org_Independent_Flag = FND_API.G_MISS_CHAR) AND (l_mtl_XRef_rec.Org_Independent_Flag <>'N'))
901: OR ((l_XRef_Rec.Organization_Id IS NULL))
902: OR ((l_XRef_Rec.Organization_Id = FND_API.G_MISS_NUM) AND (l_mtl_XRef_rec.Organization_Id IS NULL ))
903: THEN /* bug 14138918 */
904:
905: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
906: Error_Handler.Add_Error_Message

Line 905: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;

901: OR ((l_XRef_Rec.Organization_Id IS NULL))
902: OR ((l_XRef_Rec.Organization_Id = FND_API.G_MISS_NUM) AND (l_mtl_XRef_rec.Organization_Id IS NULL ))
903: THEN /* bug 14138918 */
904:
905: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
906: Error_Handler.Add_Error_Message
907: (
908: p_message_name => 'INV_XREF_INVALID_COLUMN_VALUE'
909: ,p_application_id => 'INV'

Line 924: where item_rev.inventory_item_id = Decode(l_XRef_Rec.Inventory_Item_Id,FND_API.G_MISS_NUM,l_mtl_XRef_rec.Inventory_Item_Id,l_XRef_Rec.Inventory_Item_Id)

920: WHERE
921: l_Xref_Rec.Revision_Id IN (
922: select item_rev.revision_id
923: from mtl_item_revisions_vl item_rev
924: where item_rev.inventory_item_id = Decode(l_XRef_Rec.Inventory_Item_Id,FND_API.G_MISS_NUM,l_mtl_XRef_rec.Inventory_Item_Id,l_XRef_Rec.Inventory_Item_Id)
925: and item_rev.organization_id = Decode(l_XRef_Rec.organization_id,FND_API.G_MISS_NUM, l_mtl_XRef_rec.Organization_Id,l_XRef_Rec.organization_id)
926: )
927: AND ROWNUM=1;
928:

Line 925: and item_rev.organization_id = Decode(l_XRef_Rec.organization_id,FND_API.G_MISS_NUM, l_mtl_XRef_rec.Organization_Id,l_XRef_Rec.organization_id)

921: l_Xref_Rec.Revision_Id IN (
922: select item_rev.revision_id
923: from mtl_item_revisions_vl item_rev
924: where item_rev.inventory_item_id = Decode(l_XRef_Rec.Inventory_Item_Id,FND_API.G_MISS_NUM,l_mtl_XRef_rec.Inventory_Item_Id,l_XRef_Rec.Inventory_Item_Id)
925: and item_rev.organization_id = Decode(l_XRef_Rec.organization_id,FND_API.G_MISS_NUM, l_mtl_XRef_rec.Organization_Id,l_XRef_Rec.organization_id)
926: )
927: AND ROWNUM=1;
928:
929: EXCEPTION

Line 931: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;

927: AND ROWNUM=1;
928:
929: EXCEPTION
930: WHEN No_Data_Found THEN
931: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
932: Error_Handler.Add_Error_Message
933: (
934: p_message_name => 'INV_INT_REVCODE'
935: ,p_application_id => 'INV'

Line 952: p_init_msg_list => FND_API.G_FALSE

948: --
949: IF l_XRef_Rec.Cross_Reference_Type = 'GTIN' THEN
950:
951: Validate_GTIN_Rec(
952: p_init_msg_list => FND_API.G_FALSE
953: ,p_commit => FND_API.G_FALSE
954: ,p_GTIN_XRef_Rec => l_XRef_Rec
955: ,x_return_status => l_gtin_return_status
956: ,x_msg_count => l_gtin_msg_count);

Line 953: ,p_commit => FND_API.G_FALSE

949: IF l_XRef_Rec.Cross_Reference_Type = 'GTIN' THEN
950:
951: Validate_GTIN_Rec(
952: p_init_msg_list => FND_API.G_FALSE
953: ,p_commit => FND_API.G_FALSE
954: ,p_GTIN_XRef_Rec => l_XRef_Rec
955: ,x_return_status => l_gtin_return_status
956: ,x_msg_count => l_gtin_msg_count);
957:

Line 958: IF l_gtin_return_status = FND_API.G_RET_STS_ERROR THEN

954: ,p_GTIN_XRef_Rec => l_XRef_Rec
955: ,x_return_status => l_gtin_return_status
956: ,x_msg_count => l_gtin_msg_count);
957:
958: IF l_gtin_return_status = FND_API.G_RET_STS_ERROR THEN
959: RAISE VALIDATION_ERROR;
960: END IF;
961:
962: IF l_gtin_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 962: IF l_gtin_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

958: IF l_gtin_return_status = FND_API.G_RET_STS_ERROR THEN
959: RAISE VALIDATION_ERROR;
960: END IF;
961:
962: IF l_gtin_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
963: RAISE UNEXP_VALIDATION_ERROR;
964: END IF;
965:
966: END IF;

Line 987: l_XRef_Rec.x_return_status := FND_API.g_RET_STS_ERROR;

983: AND Cross_Reference_Id <> l_XRef_Rec.Cross_Reference_Id;
984:
985: --record already Exists
986: IF l_XRef_exists='x' THEN
987: l_XRef_Rec.x_return_status := FND_API.g_RET_STS_ERROR;
988: l_Token_Tbl(1).Token_Name := 'INVENTORY_ITEM_ID';
989: l_Token_Tbl(1).Token_Value := l_XRef_Rec.Inventory_Item_Id;
990: l_Token_Tbl(1).Translate := FALSE;
991: l_Token_Tbl(2).Token_Name := 'CROSS_REFERENCE_TYPE';

Line 1080: IF l_XRef_Rec.CROSS_REFERENCE_ID =FND_API.G_MISS_NUM THEN

1076:
1077:
1078: ELSIF l_XRef_Rec.Transaction_Type = 'DELETE' THEN
1079: -- current cols should not be NULL.
1080: IF l_XRef_Rec.CROSS_REFERENCE_ID =FND_API.G_MISS_NUM THEN
1081:
1082: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR; -- assigning the record status as error
1083: Error_Handler.Add_Error_Message
1084: (

Line 1082: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR; -- assigning the record status as error

1078: ELSIF l_XRef_Rec.Transaction_Type = 'DELETE' THEN
1079: -- current cols should not be NULL.
1080: IF l_XRef_Rec.CROSS_REFERENCE_ID =FND_API.G_MISS_NUM THEN
1081:
1082: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR; -- assigning the record status as error
1083: Error_Handler.Add_Error_Message
1084: (
1085: p_message_name => 'INV_XREF_ID_NULL'
1086: ,p_application_id => 'INV'

Line 1100: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;

1096: OPEN mtl_xref_cur(l_XRef_Rec.CROSS_REFERENCE_ID);
1097: FETCH mtl_xref_cur INTO l_mtl_XRef_rec;
1098: IF mtl_xref_cur%NOTFOUND THEN
1099:
1100: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
1101: Error_Handler.Add_Error_Message
1102: (
1103: p_message_name => 'INV_XREF_ID_NOTEXISTS'
1104: ,p_application_id => 'INV'

Line 1148: X_return_status:= FND_API.g_RET_STS_ERROR;

1144: END IF; -- Transaction type
1145:
1146: EXCEPTION
1147: WHEN VALIDATION_ERROR THEN
1148: X_return_status:= FND_API.g_RET_STS_ERROR;
1149: l_msg_count := l_msg_count +1;
1150: Error_Handler.Get_Entity_Message(G_Entity_Code, x_message_list);
1151: ROLLBACK TO MTL_CROSS_REFERENCES_PVT; -- rolling back to savepoint
1152:

Line 1154: X_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

1150: Error_Handler.Get_Entity_Message(G_Entity_Code, x_message_list);
1151: ROLLBACK TO MTL_CROSS_REFERENCES_PVT; -- rolling back to savepoint
1152:
1153: WHEN UNEXP_VALIDATION_ERROR THEN
1154: X_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
1155: l_msg_count := l_msg_count +1;
1156: Error_Handler.Get_Entity_Message(G_Entity_Code, x_message_list);
1157: ROLLBACK TO MTL_CROSS_REFERENCES_PVT; -- rolling back to savepoint
1158:

Line 1170: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;

1166: ,p_entity_index => l_Xref_Indx
1167: ,p_table_name => G_Table_Name
1168: );
1169:
1170: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
1171: X_return_status:= FND_API.g_RET_STS_ERROR;
1172: l_msg_count := l_msg_count +1;
1173:
1174: WHEN others THEN

Line 1171: X_return_status:= FND_API.g_RET_STS_ERROR;

1167: ,p_table_name => G_Table_Name
1168: );
1169:
1170: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
1171: X_return_status:= FND_API.g_RET_STS_ERROR;
1172: l_msg_count := l_msg_count +1;
1173:
1174: WHEN others THEN
1175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1171: X_return_status:= FND_API.g_RET_STS_ERROR;
1172: l_msg_count := l_msg_count +1;
1173:
1174: WHEN others THEN
1175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1176: l_Token_Tbl(1).Token_Name := 'PACKAGE_NAME';
1177: l_Token_Tbl(1).Token_Value := G_PKG_NAME;
1178: l_Token_Tbl(1).Translate := FALSE;
1179: l_Token_Tbl(2).Token_Name := 'PROCEDURE_NAME';

Line 1196: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;

1192: ,p_entity_code => G_Entity_Code
1193: ,p_entity_index => l_Xref_Indx
1194: ,p_table_name => G_Table_Name
1195: );
1196: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
1197: X_return_status:= FND_API.g_RET_STS_ERROR;
1198: l_msg_count := l_msg_count +1;
1199: Error_Handler.Get_Entity_Message(G_Entity_Code, x_message_list);
1200: ROLLBACK TO MTL_CROSS_REFERENCES_PVT; -- rolling back to savepoint

Line 1197: X_return_status:= FND_API.g_RET_STS_ERROR;

1193: ,p_entity_index => l_Xref_Indx
1194: ,p_table_name => G_Table_Name
1195: );
1196: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
1197: X_return_status:= FND_API.g_RET_STS_ERROR;
1198: l_msg_count := l_msg_count +1;
1199: Error_Handler.Get_Entity_Message(G_Entity_Code, x_message_list);
1200: ROLLBACK TO MTL_CROSS_REFERENCES_PVT; -- rolling back to savepoint
1201:

Line 1208: IF (p_commit = FND_API.g_TRUE) THEN

1204:
1205: p_XRef_Tbl:=l_XRef_Tbl;
1206: x_msg_count:=l_msg_count;
1207:
1208: IF (p_commit = FND_API.g_TRUE) THEN
1209: Write_Debug('Commiting changes...');
1210: COMMIT;
1211: END IF;
1212:

Line 1222: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

1218: -- Description : Specific validations for Cross References that are of type GTIN
1219: -- -----------------------------------------------------------------------------
1220:
1221: PROCEDURE Validate_GTIN_Rec(
1222: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
1223: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
1224: ,p_GTIN_XRef_Rec IN OUT NOCOPY MTL_CROSS_REFERENCES_PUB.XRef_Rec_Type
1225: ,x_return_status OUT NOCOPY VARCHAR2
1226: ,x_msg_count OUT NOCOPY NUMBER) IS

Line 1223: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

1219: -- -----------------------------------------------------------------------------
1220:
1221: PROCEDURE Validate_GTIN_Rec(
1222: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
1223: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
1224: ,p_GTIN_XRef_Rec IN OUT NOCOPY MTL_CROSS_REFERENCES_PUB.XRef_Rec_Type
1225: ,x_return_status OUT NOCOPY VARCHAR2
1226: ,x_msg_count OUT NOCOPY NUMBER) IS
1227:

Line 1245: l_gtin_num_return_status := FND_API.G_RET_STS_SUCCESS;

1241:
1242: SAVEPOINT VALIDATE_GTIN_REC;
1243:
1244: l_GTIN_XRef_Rec := p_GTIN_XRef_Rec;
1245: l_gtin_num_return_status := FND_API.G_RET_STS_SUCCESS;
1246: x_return_status := FND_API.G_RET_STS_SUCCESS;
1247: l_master_org := -1;
1248: -- Initialize message list
1249: IF FND_API.To_Boolean (p_init_msg_list) THEN

Line 1246: x_return_status := FND_API.G_RET_STS_SUCCESS;

1242: SAVEPOINT VALIDATE_GTIN_REC;
1243:
1244: l_GTIN_XRef_Rec := p_GTIN_XRef_Rec;
1245: l_gtin_num_return_status := FND_API.G_RET_STS_SUCCESS;
1246: x_return_status := FND_API.G_RET_STS_SUCCESS;
1247: l_master_org := -1;
1248: -- Initialize message list
1249: IF FND_API.To_Boolean (p_init_msg_list) THEN
1250: Error_Handler.Initialize;

Line 1249: IF FND_API.To_Boolean (p_init_msg_list) THEN

1245: l_gtin_num_return_status := FND_API.G_RET_STS_SUCCESS;
1246: x_return_status := FND_API.G_RET_STS_SUCCESS;
1247: l_master_org := -1;
1248: -- Initialize message list
1249: IF FND_API.To_Boolean (p_init_msg_list) THEN
1250: Error_Handler.Initialize;
1251: END IF;
1252:
1253: -- if msg list is to be initialized and changes to be commited, then this procedure

Line 1257: IF FND_API.To_Boolean (p_init_msg_list)

1253: -- if msg list is to be initialized and changes to be commited, then this procedure
1254: -- is being called alone, therefore setting the the global index count to 1 for the
1255: -- one record taken in for error handling
1256:
1257: IF FND_API.To_Boolean (p_init_msg_list)
1258: AND FND_API.To_Boolean (p_commit) THEN
1259: G_Xref_Indx := 1;
1260: END IF;
1261:

Line 1258: AND FND_API.To_Boolean (p_commit) THEN

1254: -- is being called alone, therefore setting the the global index count to 1 for the
1255: -- one record taken in for error handling
1256:
1257: IF FND_API.To_Boolean (p_init_msg_list)
1258: AND FND_API.To_Boolean (p_commit) THEN
1259: G_Xref_Indx := 1;
1260: END IF;
1261:
1262:

Line 1266: IF (l_GTIN_XRef_Rec.UOM_CODE = FND_API.G_MISS_CHAR

1262:
1263: Write_Debug('Validating GTIN Cross Reference Record...');
1264:
1265:
1266: IF (l_GTIN_XRef_Rec.UOM_CODE = FND_API.G_MISS_CHAR
1267: OR l_GTIN_XRef_Rec.UOM_CODE IS NULL) AND
1268: l_GTIN_XRef_Rec.TRANSACTION_TYPE = 'CREATE' THEN
1269:
1270: Error_Handler.Add_Error_message

Line 1283: l_GTIN_XRef_Rec.UOM_CODE <> FND_API.G_MISS_CHAR THEN

1279: RAISE GTIN_VALIDATION_ERROR;
1280: END IF;
1281:
1282: IF l_GTIN_XRef_Rec.UOM_CODE IS NOT NULL AND
1283: l_GTIN_XRef_Rec.UOM_CODE <> FND_API.G_MISS_CHAR THEN
1284:
1285: --
1286: -- UOM Code validation
1287: --

Line 1361: IF l_gtin_num_return_status = FND_API.G_RET_STS_ERROR THEN

1357: --
1358: -- call GTIN number validations
1359: --
1360: Validate_GTIN_Number(l_GTIN_XRef_Rec.CROSS_REFERENCE, l_gtin_num_return_status);
1361: IF l_gtin_num_return_status = FND_API.G_RET_STS_ERROR THEN
1362: RAISE GTIN_VALIDATION_ERROR;
1363: END IF;
1364:
1365: -- GTIN can be duplicate for different items, but cannot have same UOM

Line 1405: l_GTIN_XRef_Rec.Revision_Id <> FND_API.G_MISS_NUM THEN

1401: -- begin check for whether item revision exists for item
1402: --
1403:
1404: IF l_GTIN_XRef_Rec.Revision_Id IS NOT NULL AND
1405: l_GTIN_XRef_Rec.Revision_Id <> FND_API.G_MISS_NUM THEN
1406: IF l_GTIN_XRef_Rec.ORGANIZATION_ID IS NOT NULL
1407: AND l_GTIN_XRef_Rec.ORGANIZATION_ID <> FND_API.G_MISS_NUM THEN
1408: BEGIN
1409: SELECT 'x' INTO l_item_revision_exists

Line 1407: AND l_GTIN_XRef_Rec.ORGANIZATION_ID <> FND_API.G_MISS_NUM THEN

1403:
1404: IF l_GTIN_XRef_Rec.Revision_Id IS NOT NULL AND
1405: l_GTIN_XRef_Rec.Revision_Id <> FND_API.G_MISS_NUM THEN
1406: IF l_GTIN_XRef_Rec.ORGANIZATION_ID IS NOT NULL
1407: AND l_GTIN_XRef_Rec.ORGANIZATION_ID <> FND_API.G_MISS_NUM THEN
1408: BEGIN
1409: SELECT 'x' INTO l_item_revision_exists
1410: FROM mtl_item_revisions
1411: WHERE INVENTORY_ITEM_ID = l_GTIN_XRef_Rec.INVENTORY_ITEM_ID

Line 1480: IF l_GTIN_XRef_Rec.EPC_GTIN_SERIAL = FND_API.G_MISS_NUM THEN

1476: -- end check for item revision
1477:
1478:
1479:
1480: IF l_GTIN_XRef_Rec.EPC_GTIN_SERIAL = FND_API.G_MISS_NUM THEN
1481: l_GTIN_XRef_Rec.EPC_GTIN_SERIAL := 0;
1482: END IF;
1483:
1484: p_GTIN_XRef_Rec := l_GTIN_XRef_Rec;

Line 1490: x_return_status := FND_API.G_RET_STS_ERROR;

1486: EXCEPTION
1487:
1488: WHEN GTIN_VALIDATION_ERROR THEN
1489: x_msg_count := x_msg_count + 1;
1490: x_return_status := FND_API.G_RET_STS_ERROR;
1491: l_GTIN_XRef_Rec.x_return_status := FND_API.G_RET_STS_ERROR;
1492: p_GTIN_XRef_Rec := l_GTIN_XRef_Rec;
1493:
1494: ROLLBACK TO VALIDATE_GTIN_REC;

Line 1491: l_GTIN_XRef_Rec.x_return_status := FND_API.G_RET_STS_ERROR;

1487:
1488: WHEN GTIN_VALIDATION_ERROR THEN
1489: x_msg_count := x_msg_count + 1;
1490: x_return_status := FND_API.G_RET_STS_ERROR;
1491: l_GTIN_XRef_Rec.x_return_status := FND_API.G_RET_STS_ERROR;
1492: p_GTIN_XRef_Rec := l_GTIN_XRef_Rec;
1493:
1494: ROLLBACK TO VALIDATE_GTIN_REC;
1495: WHEN OTHERS THEN

Line 1496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1492: p_GTIN_XRef_Rec := l_GTIN_XRef_Rec;
1493:
1494: ROLLBACK TO VALIDATE_GTIN_REC;
1495: WHEN OTHERS THEN
1496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1497: l_Token_Tbl(1).Token_Name := 'PACKAGE_NAME';
1498: l_Token_Tbl(1).Token_Value := G_PKG_NAME;
1499: l_Token_Tbl(1).Translate := FALSE;
1500: l_Token_Tbl(2).Token_Name := 'PROCEDURE_NAME';

Line 1672: x_return_status := FND_API.G_RET_STS_ERROR;

1668: END IF;
1669:
1670: EXCEPTION
1671: WHEN GTIN_NUM_VALIDATION_ERROR THEN
1672: x_return_status := FND_API.G_RET_STS_ERROR;
1673: ROLLBACK TO VALIDATE_GTIN_NUMBER;
1674: END Validate_GTIN_Number;
1675:
1676:

Line 1758: l_return_status := FND_API.G_RET_STS_SUCCESS;

1754: NULL;
1755: END;
1756: END IF;
1757: -- bug 14464655
1758: l_return_status := FND_API.G_RET_STS_SUCCESS;
1759:
1760: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1761: IF l_mtl_xref_rec.ORGANIZATION_CODE IS NOT NULL THEN
1762: BEGIN

Line 1760: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1756: END IF;
1757: -- bug 14464655
1758: l_return_status := FND_API.G_RET_STS_SUCCESS;
1759:
1760: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1761: IF l_mtl_xref_rec.ORGANIZATION_CODE IS NOT NULL THEN
1762: BEGIN
1763:
1764: SELECT mtp.organization_id into p_organization_id

Line 1772: l_return_status := FND_API.g_RET_STS_ERROR;

1768:
1769: IF l_mtl_xref_rec.ORGANIZATION_ID IS NOT NULL THEN
1770: IF (l_mtl_xref_rec.ORGANIZATION_ID <> p_organization_id) THEN
1771:
1772: l_return_status := FND_API.g_RET_STS_ERROR;
1773: Error_Handler.Add_Error_message
1774: (
1775: p_message_name => 'EGO_ASSOC_INVALID_ORG'
1776: ,p_application_id => 'EGO'

Line 1795: l_return_status := FND_API.g_RET_STS_ERROR;

1791:
1792: EXCEPTION
1793: WHEN NO_DATA_FOUND THEN
1794:
1795: l_return_status := FND_API.g_RET_STS_ERROR;
1796: Error_Handler.Add_Error_message
1797: (
1798: p_message_name => 'EGO_ASSOC_INVALID_ORG'
1799: ,p_application_id => 'EGO'

Line 1814: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1810:
1811: END IF;
1812: END IF;
1813: -- item number to id conversion
1814: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1815: IF l_mtl_xref_rec.item_number IS NOT NULL THEN
1816:
1817: BEGIN
1818:

Line 1828: l_return_status := FND_API.g_RET_STS_ERROR;

1824: IF l_mtl_xref_rec.INVENTORY_ITEM_ID IS NOT NULL THEN
1825: IF (l_mtl_xref_rec.INVENTORY_ITEM_ID <> p_inventory_item_id) THEN
1826:
1827:
1828: l_return_status := FND_API.g_RET_STS_ERROR;
1829:
1830: Error_Handler.Add_Error_message
1831: (
1832: p_message_name => 'EGO_INVALID_ITEM_SEGMENTS'

Line 1851: l_return_status := FND_API.g_RET_STS_ERROR;

1847:
1848: EXCEPTION
1849: WHEN NO_DATA_FOUND THEN
1850:
1851: l_return_status := FND_API.g_RET_STS_ERROR;
1852: Error_Handler.Add_Error_message
1853: (
1854: p_message_name => 'EGO_INVALID_ITEM_SEGMENTS'
1855: ,p_application_id => 'EGO'

Line 1871: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1867: END IF;
1868:
1869: -- getting revision id from revision
1870:
1871: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1872: IF l_mtl_xref_rec.revision IS NOT NULL THEN
1873:
1874: BEGIN
1875:

Line 1886: l_return_status := FND_API.g_RET_STS_ERROR;

1882:
1883: IF l_mtl_xref_rec.revision_id IS NOT NULL THEN
1884: IF (l_mtl_xref_rec.revision_id <> p_revision_id) THEN
1885:
1886: l_return_status := FND_API.g_RET_STS_ERROR;
1887:
1888: Error_Handler.Add_Error_message
1889: (
1890: p_message_name => 'INV_ITM_INVALID_REVISION_CODE'

Line 1908: l_return_status := FND_API.g_RET_STS_ERROR;

1904: l_mtl_xref_rec.revision_id := p_revision_id ;
1905: EXCEPTION
1906: WHEN NO_DATA_FOUND THEN
1907:
1908: l_return_status := FND_API.g_RET_STS_ERROR;
1909: Error_Handler.Add_Error_message
1910: (
1911: p_message_name => 'INV_ITM_INVALID_REVISION_CODE'
1912: ,p_application_id => 'INV'

Line 1926: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1922:
1923: END IF;
1924: END IF;
1925:
1926: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1927: -- bug 14464655
1928:
1929: l_XRef_Rec.TRANSACTION_TYPE := l_mtl_xref_rec.TRANSACTION_TYPE;
1930: -- bug 14403250

Line 1931: l_XRef_Rec.CROSS_REFERENCE_ID := nvl(l_mtl_xref_rec.CROSS_REFERENCE_ID,FND_API.G_MISS_NUM);

1927: -- bug 14464655
1928:
1929: l_XRef_Rec.TRANSACTION_TYPE := l_mtl_xref_rec.TRANSACTION_TYPE;
1930: -- bug 14403250
1931: l_XRef_Rec.CROSS_REFERENCE_ID := nvl(l_mtl_xref_rec.CROSS_REFERENCE_ID,FND_API.G_MISS_NUM);
1932: l_XRef_Rec.INVENTORY_ITEM_ID := l_mtl_xref_rec.INVENTORY_ITEM_ID;
1933: l_XRef_Rec.ORGANIZATION_ID := l_mtl_xref_rec.ORGANIZATION_ID;
1934: l_XRef_Rec.CROSS_REFERENCE_TYPE := l_mtl_xref_rec.CROSS_REFERENCE_TYPE;
1935: l_XRef_Rec.CROSS_REFERENCE := l_mtl_xref_rec.CROSS_REFERENCE;

Line 1969: (p_init_msg_list => FND_API.G_TRUE

1965:
1966: Write_Debug('Calling MTL_CROSS_REFERENCES_PVT.Process_Xref for Transaction ' ||To_Char(l_mtl_xref_rec.Transaction_Id));
1967:
1968: MTL_CROSS_REFERENCES_PVT.Process_Xref
1969: (p_init_msg_list => FND_API.G_TRUE
1970: ,p_commit => FND_API.G_TRUE
1971: ,p_XRef_Tbl => l_XRef_Tbl
1972: ,x_return_status => l_return_status
1973: ,x_msg_count => l_msg_count

Line 1970: ,p_commit => FND_API.G_TRUE

1966: Write_Debug('Calling MTL_CROSS_REFERENCES_PVT.Process_Xref for Transaction ' ||To_Char(l_mtl_xref_rec.Transaction_Id));
1967:
1968: MTL_CROSS_REFERENCES_PVT.Process_Xref
1969: (p_init_msg_list => FND_API.G_TRUE
1970: ,p_commit => FND_API.G_TRUE
1971: ,p_XRef_Tbl => l_XRef_Tbl
1972: ,x_return_status => l_return_status
1973: ,x_msg_count => l_msg_count
1974: ,x_message_list => l_msg_list

Line 1978: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1974: ,x_message_list => l_msg_list
1975: );
1976: END IF;
1977:
1978: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1979: UPDATE MTL_CROSS_REFERENCES_INTERFACE
1980: SET process_flag = 3
1981: WHERE Transaction_Id = l_mtl_xref_rec.Transaction_Id;
1982: