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.GMIVITM dependencies on IC_ITEM_MST

Line 336: | x_ic_item_mst_row OUT ic_item_mst%ROWTYPE |

332: | PARAMETERS |
333: | p_api_version IN NUMBER - Api Version |
334: | p_validation_level IN VARCHAR2 - Validation Level Indicator |
335: | p_item_rec IN item_rec_typ - Item Master details |
336: | x_ic_item_mst_row OUT ic_item_mst%ROWTYPE |
337: | x_ic_item_cpg_row OUT ic_item_cpg%ROWTYPE |
338: | x_return_status OUT VARCHAR2 - Return Status |
339: | x_msg_count OUT NUMBER - Number of messages |
340: | x_msg_data OUT VARCHAR2 - Messages in encoded format |

Line 364: , x_ic_item_mst_row OUT NOCOPY ic_item_mst%ROWTYPE

360: PROCEDURE Validate_item
361: ( p_api_version IN NUMBER
362: , p_validation_level IN VARCHAR2 :=FND_API.G_VALID_LEVEL_FULL
363: , p_item_rec IN GMIGAPI.item_rec_typ
364: , x_ic_item_mst_row OUT NOCOPY ic_item_mst%ROWTYPE
365: , x_ic_item_cpg_row OUT NOCOPY ic_item_cpg%ROWTYPE
366: , x_return_status OUT NOCOPY VARCHAR2
367: , x_msg_count OUT NOCOPY NUMBER
368: , x_msg_data OUT NOCOPY VARCHAR2

Line 371: l_ic_item_mst_row ic_item_mst%ROWTYPE;

367: , x_msg_count OUT NOCOPY NUMBER
368: , x_msg_data OUT NOCOPY VARCHAR2
369: )
370: IS
371: l_ic_item_mst_row ic_item_mst%ROWTYPE;
372: l_ic_item_cpg_row ic_item_cpg%ROWTYPE;
373: l_sy_uoms_mst_row sy_uoms_mst%ROWTYPE;
374: l_sy_uoms_typ_row sy_uoms_typ%ROWTYPE;
375: l_qc_grad_mst_row qc_grad_mst%ROWTYPE;

Line 391: x_ic_item_mst_row.item_id := NULL;

387:
388: /* Validate input record and setup output rows */
389:
390: /* Item ID/Number/Descriptions/Alternatives */
391: x_ic_item_mst_row.item_id := NULL;
392: -- BEGIN BUG#2461984 VAK
393: x_ic_item_mst_row.item_no := UPPER(RTRIM(p_item_rec.item_no));
394: x_ic_item_mst_row.item_desc1 := RTRIM(p_item_rec.item_desc1);
395: IF NVL(p_item_rec.item_desc1, ' ') = ' '

Line 393: x_ic_item_mst_row.item_no := UPPER(RTRIM(p_item_rec.item_no));

389:
390: /* Item ID/Number/Descriptions/Alternatives */
391: x_ic_item_mst_row.item_id := NULL;
392: -- BEGIN BUG#2461984 VAK
393: x_ic_item_mst_row.item_no := UPPER(RTRIM(p_item_rec.item_no));
394: x_ic_item_mst_row.item_desc1 := RTRIM(p_item_rec.item_desc1);
395: IF NVL(p_item_rec.item_desc1, ' ') = ' '
396: THEN
397: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ITEM_DESC1');

Line 394: x_ic_item_mst_row.item_desc1 := RTRIM(p_item_rec.item_desc1);

390: /* Item ID/Number/Descriptions/Alternatives */
391: x_ic_item_mst_row.item_id := NULL;
392: -- BEGIN BUG#2461984 VAK
393: x_ic_item_mst_row.item_no := UPPER(RTRIM(p_item_rec.item_no));
394: x_ic_item_mst_row.item_desc1 := RTRIM(p_item_rec.item_desc1);
395: IF NVL(p_item_rec.item_desc1, ' ') = ' '
396: THEN
397: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ITEM_DESC1');
398:

Line 402: x_ic_item_mst_row.item_desc2 := RTRIM(p_item_rec.item_desc2);

398:
399: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);
400: FND_MSG_PUB.Add;
401: ELSE
402: x_ic_item_mst_row.item_desc2 := RTRIM(p_item_rec.item_desc2);
403: END IF;
404:
405: x_ic_item_mst_row.alt_itema := RTRIM(p_item_rec.alt_itema);
406: x_ic_item_mst_row.alt_itemb := RTRIM(p_item_rec.alt_itemb);

Line 405: x_ic_item_mst_row.alt_itema := RTRIM(p_item_rec.alt_itema);

401: ELSE
402: x_ic_item_mst_row.item_desc2 := RTRIM(p_item_rec.item_desc2);
403: END IF;
404:
405: x_ic_item_mst_row.alt_itema := RTRIM(p_item_rec.alt_itema);
406: x_ic_item_mst_row.alt_itemb := RTRIM(p_item_rec.alt_itemb);
407:
408: /* Unit of Measure */
409:

Line 406: x_ic_item_mst_row.alt_itemb := RTRIM(p_item_rec.alt_itemb);

402: x_ic_item_mst_row.item_desc2 := RTRIM(p_item_rec.item_desc2);
403: END IF;
404:
405: x_ic_item_mst_row.alt_itema := RTRIM(p_item_rec.alt_itema);
406: x_ic_item_mst_row.alt_itemb := RTRIM(p_item_rec.alt_itemb);
407:
408: /* Unit of Measure */
409:
410: GMIGUTL.get_um(RTRIM(p_item_rec.item_um), l_sy_uoms_mst_row, l_sy_uoms_typ_row);

Line 413: x_ic_item_mst_row.item_um := RTRIM(l_sy_uoms_mst_row.um_code);

409:
410: GMIGUTL.get_um(RTRIM(p_item_rec.item_um), l_sy_uoms_mst_row, l_sy_uoms_typ_row);
411: IF l_sy_uoms_mst_row.um_code IS NOT NULL
412: THEN
413: x_ic_item_mst_row.item_um := RTRIM(l_sy_uoms_mst_row.um_code);
414: ELSE
415: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_UOM');
416: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);
417: FND_MESSAGE.SET_TOKEN('UOM',p_item_rec.item_um);

Line 424: x_ic_item_mst_row.dualum_ind := p_item_rec.dualum_ind;

420: -- END BUG#2461984 VAK
421: /* Dual unit of measure indicator */
422: IF p_item_rec.dualum_ind BETWEEN 0 AND 3
423: THEN
424: x_ic_item_mst_row.dualum_ind := p_item_rec.dualum_ind;
425: ELSE
426: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_DUALUM_IND');
427: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);
428: FND_MSG_PUB.Add;

Line 437: x_ic_item_mst_row.deviation_lo := 0;

433: /* same as the primary um. If the unit of meaure conversion */
434: /* is not fixed then validate the deviations too. As these */
435: /* columns are not null, set them to zero before continuing. */
436:
437: x_ic_item_mst_row.deviation_lo := 0;
438: x_ic_item_mst_row.deviation_hi := 0;
439:
440: IF x_ic_item_mst_row.dualum_ind > 0
441: THEN

Line 438: x_ic_item_mst_row.deviation_hi := 0;

434: /* is not fixed then validate the deviations too. As these */
435: /* columns are not null, set them to zero before continuing. */
436:
437: x_ic_item_mst_row.deviation_lo := 0;
438: x_ic_item_mst_row.deviation_hi := 0;
439:
440: IF x_ic_item_mst_row.dualum_ind > 0
441: THEN
442: IF NVL(p_item_rec.item_um2, x_ic_item_mst_row.item_um) <>

Line 440: IF x_ic_item_mst_row.dualum_ind > 0

436:
437: x_ic_item_mst_row.deviation_lo := 0;
438: x_ic_item_mst_row.deviation_hi := 0;
439:
440: IF x_ic_item_mst_row.dualum_ind > 0
441: THEN
442: IF NVL(p_item_rec.item_um2, x_ic_item_mst_row.item_um) <>
443: x_ic_item_mst_row.item_um
444: THEN

Line 442: IF NVL(p_item_rec.item_um2, x_ic_item_mst_row.item_um) <>

438: x_ic_item_mst_row.deviation_hi := 0;
439:
440: IF x_ic_item_mst_row.dualum_ind > 0
441: THEN
442: IF NVL(p_item_rec.item_um2, x_ic_item_mst_row.item_um) <>
443: x_ic_item_mst_row.item_um
444: THEN
445: -- BUG#2461984 VAK
446: GMIGUTL.get_um(RTRIM(p_item_rec.item_um2), l_sy_uoms_mst_row, l_sy_uoms_typ_row);

Line 443: x_ic_item_mst_row.item_um

439:
440: IF x_ic_item_mst_row.dualum_ind > 0
441: THEN
442: IF NVL(p_item_rec.item_um2, x_ic_item_mst_row.item_um) <>
443: x_ic_item_mst_row.item_um
444: THEN
445: -- BUG#2461984 VAK
446: GMIGUTL.get_um(RTRIM(p_item_rec.item_um2), l_sy_uoms_mst_row, l_sy_uoms_typ_row);
447: IF l_sy_uoms_mst_row.um_code IS NOT NULL

Line 450: x_ic_item_mst_row.item_um2 := RTRIM(l_sy_uoms_mst_row.um_code);

446: GMIGUTL.get_um(RTRIM(p_item_rec.item_um2), l_sy_uoms_mst_row, l_sy_uoms_typ_row);
447: IF l_sy_uoms_mst_row.um_code IS NOT NULL
448: THEN
449: -- BUG#2461984 VAK
450: x_ic_item_mst_row.item_um2 := RTRIM(l_sy_uoms_mst_row.um_code);
451: END IF;
452: END IF;
453:
454: IF x_ic_item_mst_row.item_um2 IS NULL

Line 454: IF x_ic_item_mst_row.item_um2 IS NULL

450: x_ic_item_mst_row.item_um2 := RTRIM(l_sy_uoms_mst_row.um_code);
451: END IF;
452: END IF;
453:
454: IF x_ic_item_mst_row.item_um2 IS NULL
455: THEN
456: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_UOM');
457: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);
458: FND_MESSAGE.SET_TOKEN('UOM',p_item_rec.item_um2);

Line 461: IF x_ic_item_mst_row.dualum_ind > 1

457: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);
458: FND_MESSAGE.SET_TOKEN('UOM',p_item_rec.item_um2);
459: FND_MSG_PUB.Add;
460: ELSE
461: IF x_ic_item_mst_row.dualum_ind > 1
462: THEN
463: IF NVL(p_item_rec.deviation_lo,0) <= 0 OR
464: NVL(p_item_rec.deviation_hi,0) <= 0
465: THEN

Line 470: x_ic_item_mst_row.deviation_lo := p_item_rec.deviation_lo;

466: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_DEVIATION');
467: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);
468: FND_MSG_PUB.Add;
469: ELSE
470: x_ic_item_mst_row.deviation_lo := p_item_rec.deviation_lo;
471: x_ic_item_mst_row.deviation_hi := p_item_rec.deviation_hi;
472: END IF;
473: END IF;
474: END IF;

Line 471: x_ic_item_mst_row.deviation_hi := p_item_rec.deviation_hi;

467: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);
468: FND_MSG_PUB.Add;
469: ELSE
470: x_ic_item_mst_row.deviation_lo := p_item_rec.deviation_lo;
471: x_ic_item_mst_row.deviation_hi := p_item_rec.deviation_hi;
472: END IF;
473: END IF;
474: END IF;
475: ELSE

Line 476: x_ic_item_mst_row.deviation_lo := 0;

472: END IF;
473: END IF;
474: END IF;
475: ELSE
476: x_ic_item_mst_row.deviation_lo := 0;
477: x_ic_item_mst_row.deviation_hi := 0;
478: END IF;
479:
480: /* Level Code. Unused, so use 'as is' */

Line 477: x_ic_item_mst_row.deviation_hi := 0;

473: END IF;
474: END IF;
475: ELSE
476: x_ic_item_mst_row.deviation_lo := 0;
477: x_ic_item_mst_row.deviation_hi := 0;
478: END IF;
479:
480: /* Level Code. Unused, so use 'as is' */
481: x_ic_item_mst_row.level_code := p_item_rec.level_code;

Line 481: x_ic_item_mst_row.level_code := p_item_rec.level_code;

477: x_ic_item_mst_row.deviation_hi := 0;
478: END IF;
479:
480: /* Level Code. Unused, so use 'as is' */
481: x_ic_item_mst_row.level_code := p_item_rec.level_code;
482:
483: /* lot/sublot/indivisible/Noninv flags */
484:
485: x_ic_item_mst_row.noninv_ind := NVL(p_item_rec.noninv_ind,0);

Line 485: x_ic_item_mst_row.noninv_ind := NVL(p_item_rec.noninv_ind,0);

481: x_ic_item_mst_row.level_code := p_item_rec.level_code;
482:
483: /* lot/sublot/indivisible/Noninv flags */
484:
485: x_ic_item_mst_row.noninv_ind := NVL(p_item_rec.noninv_ind,0);
486:
487: IF x_ic_item_mst_row.noninv_ind BETWEEN 0 AND 1
488: THEN
489: NULL;

Line 487: IF x_ic_item_mst_row.noninv_ind BETWEEN 0 AND 1

483: /* lot/sublot/indivisible/Noninv flags */
484:
485: x_ic_item_mst_row.noninv_ind := NVL(p_item_rec.noninv_ind,0);
486:
487: IF x_ic_item_mst_row.noninv_ind BETWEEN 0 AND 1
488: THEN
489: NULL;
490: ELSE
491: x_ic_item_mst_row.noninv_ind:= NULL;

Line 491: x_ic_item_mst_row.noninv_ind:= NULL;

487: IF x_ic_item_mst_row.noninv_ind BETWEEN 0 AND 1
488: THEN
489: NULL;
490: ELSE
491: x_ic_item_mst_row.noninv_ind:= NULL;
492: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_NONINV_IND');
493: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);
494: FND_MSG_PUB.Add;
495: END IF;

Line 499: x_ic_item_mst_row.lot_ctl := p_item_rec.lot_ctl;

495: END IF;
496:
497: IF NVL(p_item_rec.lot_ctl, -1) BETWEEN 0 AND 1
498: THEN
499: x_ic_item_mst_row.lot_ctl := p_item_rec.lot_ctl;
500:
501: IF x_ic_item_mst_row.lot_ctl = 1
502: THEN
503: IF NVL(p_item_rec.sublot_ctl, -1) BETWEEN 0 AND 1

Line 501: IF x_ic_item_mst_row.lot_ctl = 1

497: IF NVL(p_item_rec.lot_ctl, -1) BETWEEN 0 AND 1
498: THEN
499: x_ic_item_mst_row.lot_ctl := p_item_rec.lot_ctl;
500:
501: IF x_ic_item_mst_row.lot_ctl = 1
502: THEN
503: IF NVL(p_item_rec.sublot_ctl, -1) BETWEEN 0 AND 1
504: THEN
505: x_ic_item_mst_row.sublot_ctl := p_item_rec.sublot_ctl;

Line 505: x_ic_item_mst_row.sublot_ctl := p_item_rec.sublot_ctl;

501: IF x_ic_item_mst_row.lot_ctl = 1
502: THEN
503: IF NVL(p_item_rec.sublot_ctl, -1) BETWEEN 0 AND 1
504: THEN
505: x_ic_item_mst_row.sublot_ctl := p_item_rec.sublot_ctl;
506: ELSE
507: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_SUBLOT_CTL');
508: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);
509: FND_MSG_PUB.Add;

Line 514: x_ic_item_mst_row.lot_indivisible := p_item_rec.lot_indivisible;

510: END IF;
511:
512: IF NVL(p_item_rec.lot_indivisible, -1) BETWEEN 0 AND 1
513: THEN
514: x_ic_item_mst_row.lot_indivisible := p_item_rec.lot_indivisible;
515: ELSE
516: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_INDIVISIBLE');
517: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);
518: FND_MSG_PUB.Add;

Line 521: IF x_ic_item_mst_row.noninv_ind = 1

517: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);
518: FND_MSG_PUB.Add;
519: END IF;
520:
521: IF x_ic_item_mst_row.noninv_ind = 1
522: THEN
523: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_NONINV_IND');
524: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);
525: FND_MSG_PUB.Add;

Line 528: x_ic_item_mst_row.sublot_ctl := 0;

524: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);
525: FND_MSG_PUB.Add;
526: END IF;
527: ELSE
528: x_ic_item_mst_row.sublot_ctl := 0;
529: x_ic_item_mst_row.lot_indivisible := 0;
530: END IF;
531: ELSE
532: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_CTL');

Line 529: x_ic_item_mst_row.lot_indivisible := 0;

525: FND_MSG_PUB.Add;
526: END IF;
527: ELSE
528: x_ic_item_mst_row.sublot_ctl := 0;
529: x_ic_item_mst_row.lot_indivisible := 0;
530: END IF;
531: ELSE
532: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_CTL');
533: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);

Line 538: x_ic_item_mst_row.match_type := 3;

534: FND_MSG_PUB.Add;
535: END IF;
536:
537: /* Match type is not used(?) */
538: x_ic_item_mst_row.match_type := 3;
539:
540: /* Inactive indicator */
541: x_ic_item_mst_row.inactive_ind := NVL(p_item_rec.inactive_ind,0);
542: IF x_ic_item_mst_row.inactive_ind BETWEEN 0 AND 1

Line 541: x_ic_item_mst_row.inactive_ind := NVL(p_item_rec.inactive_ind,0);

537: /* Match type is not used(?) */
538: x_ic_item_mst_row.match_type := 3;
539:
540: /* Inactive indicator */
541: x_ic_item_mst_row.inactive_ind := NVL(p_item_rec.inactive_ind,0);
542: IF x_ic_item_mst_row.inactive_ind BETWEEN 0 AND 1
543: THEN
544: NULL;
545: ELSE

Line 542: IF x_ic_item_mst_row.inactive_ind BETWEEN 0 AND 1

538: x_ic_item_mst_row.match_type := 3;
539:
540: /* Inactive indicator */
541: x_ic_item_mst_row.inactive_ind := NVL(p_item_rec.inactive_ind,0);
542: IF x_ic_item_mst_row.inactive_ind BETWEEN 0 AND 1
543: THEN
544: NULL;
545: ELSE
546: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_INACTIVE_IND');

Line 552: x_ic_item_mst_row.loct_ctl := NVL(p_item_rec.loct_ctl,0);

548: FND_MSG_PUB.Add;
549: END IF;
550:
551: /* Location control flag */
552: x_ic_item_mst_row.loct_ctl := NVL(p_item_rec.loct_ctl,0);
553: IF x_ic_item_mst_row.loct_ctl BETWEEN 0 AND 2
554: THEN
555: NULL;
556: ELSE

Line 553: IF x_ic_item_mst_row.loct_ctl BETWEEN 0 AND 2

549: END IF;
550:
551: /* Location control flag */
552: x_ic_item_mst_row.loct_ctl := NVL(p_item_rec.loct_ctl,0);
553: IF x_ic_item_mst_row.loct_ctl BETWEEN 0 AND 2
554: THEN
555: NULL;
556: ELSE
557: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOCT_CTL');

Line 565: IF x_ic_item_mst_row.lot_ctl = 1

561:
562: /* Grade, status control etc. If item is lot controlled, */
563: /* validate everything, else default it. */
564:
565: IF x_ic_item_mst_row.lot_ctl = 1
566: THEN
567: x_ic_item_mst_row.grade_ctl := NVL(p_item_rec.grade_ctl,0);
568: x_ic_item_mst_row.shelf_life := NVL(p_item_rec.shelf_life,0);
569: x_ic_item_mst_row.retest_interval := NVL(p_item_rec.retest_interval,0);

Line 567: x_ic_item_mst_row.grade_ctl := NVL(p_item_rec.grade_ctl,0);

563: /* validate everything, else default it. */
564:
565: IF x_ic_item_mst_row.lot_ctl = 1
566: THEN
567: x_ic_item_mst_row.grade_ctl := NVL(p_item_rec.grade_ctl,0);
568: x_ic_item_mst_row.shelf_life := NVL(p_item_rec.shelf_life,0);
569: x_ic_item_mst_row.retest_interval := NVL(p_item_rec.retest_interval,0);
570: x_ic_item_mst_row.expaction_interval := NVL(p_item_rec.expaction_interval,0);
571:

Line 568: x_ic_item_mst_row.shelf_life := NVL(p_item_rec.shelf_life,0);

564:
565: IF x_ic_item_mst_row.lot_ctl = 1
566: THEN
567: x_ic_item_mst_row.grade_ctl := NVL(p_item_rec.grade_ctl,0);
568: x_ic_item_mst_row.shelf_life := NVL(p_item_rec.shelf_life,0);
569: x_ic_item_mst_row.retest_interval := NVL(p_item_rec.retest_interval,0);
570: x_ic_item_mst_row.expaction_interval := NVL(p_item_rec.expaction_interval,0);
571:
572: IF x_ic_item_mst_row.grade_ctl BETWEEN 0 AND 1

Line 569: x_ic_item_mst_row.retest_interval := NVL(p_item_rec.retest_interval,0);

565: IF x_ic_item_mst_row.lot_ctl = 1
566: THEN
567: x_ic_item_mst_row.grade_ctl := NVL(p_item_rec.grade_ctl,0);
568: x_ic_item_mst_row.shelf_life := NVL(p_item_rec.shelf_life,0);
569: x_ic_item_mst_row.retest_interval := NVL(p_item_rec.retest_interval,0);
570: x_ic_item_mst_row.expaction_interval := NVL(p_item_rec.expaction_interval,0);
571:
572: IF x_ic_item_mst_row.grade_ctl BETWEEN 0 AND 1
573: THEN

Line 570: x_ic_item_mst_row.expaction_interval := NVL(p_item_rec.expaction_interval,0);

566: THEN
567: x_ic_item_mst_row.grade_ctl := NVL(p_item_rec.grade_ctl,0);
568: x_ic_item_mst_row.shelf_life := NVL(p_item_rec.shelf_life,0);
569: x_ic_item_mst_row.retest_interval := NVL(p_item_rec.retest_interval,0);
570: x_ic_item_mst_row.expaction_interval := NVL(p_item_rec.expaction_interval,0);
571:
572: IF x_ic_item_mst_row.grade_ctl BETWEEN 0 AND 1
573: THEN
574: IF x_ic_item_mst_row.grade_ctl = 1

Line 572: IF x_ic_item_mst_row.grade_ctl BETWEEN 0 AND 1

568: x_ic_item_mst_row.shelf_life := NVL(p_item_rec.shelf_life,0);
569: x_ic_item_mst_row.retest_interval := NVL(p_item_rec.retest_interval,0);
570: x_ic_item_mst_row.expaction_interval := NVL(p_item_rec.expaction_interval,0);
571:
572: IF x_ic_item_mst_row.grade_ctl BETWEEN 0 AND 1
573: THEN
574: IF x_ic_item_mst_row.grade_ctl = 1
575: THEN
576: IF NVL(p_item_rec.qc_grade, ' ') <> ' '

Line 574: IF x_ic_item_mst_row.grade_ctl = 1

570: x_ic_item_mst_row.expaction_interval := NVL(p_item_rec.expaction_interval,0);
571:
572: IF x_ic_item_mst_row.grade_ctl BETWEEN 0 AND 1
573: THEN
574: IF x_ic_item_mst_row.grade_ctl = 1
575: THEN
576: IF NVL(p_item_rec.qc_grade, ' ') <> ' '
577: THEN
578: -- BUG#2461984 VAK

Line 581: x_ic_item_mst_row.qc_grade := l_qc_grad_mst_row.qc_grade;

577: THEN
578: -- BUG#2461984 VAK
579: IF GMIGUTL.v_qc_grade(UPPER(RTRIM(p_item_rec.qc_grade)), l_qc_grad_mst_row)
580: THEN
581: x_ic_item_mst_row.qc_grade := l_qc_grad_mst_row.qc_grade;
582: END IF;
583: END IF;
584:
585: IF x_ic_item_mst_row.qc_grade IS NULL

Line 585: IF x_ic_item_mst_row.qc_grade IS NULL

581: x_ic_item_mst_row.qc_grade := l_qc_grad_mst_row.qc_grade;
582: END IF;
583: END IF;
584:
585: IF x_ic_item_mst_row.qc_grade IS NULL
586: THEN
587: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_QC_GRADE');
588: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);
589: FND_MSG_PUB.Add;

Line 593: x_ic_item_mst_row.retest_interval := NVL(p_item_rec.retest_interval,0);

589: FND_MSG_PUB.Add;
590: END IF;
591: END IF; /* moved here for bug#1653385 */
592:
593: x_ic_item_mst_row.retest_interval := NVL(p_item_rec.retest_interval,0);
594: IF x_ic_item_mst_row.retest_interval < 0
595: THEN
596: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_RETEST_INTERVAL');
597: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);

Line 594: IF x_ic_item_mst_row.retest_interval < 0

590: END IF;
591: END IF; /* moved here for bug#1653385 */
592:
593: x_ic_item_mst_row.retest_interval := NVL(p_item_rec.retest_interval,0);
594: IF x_ic_item_mst_row.retest_interval < 0
595: THEN
596: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_RETEST_INTERVAL');
597: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);
598: FND_MSG_PUB.Add;

Line 601: x_ic_item_mst_row.shelf_life := NVL(p_item_rec.shelf_life,0);

597: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);
598: FND_MSG_PUB.Add;
599: END IF;
600:
601: x_ic_item_mst_row.shelf_life := NVL(p_item_rec.shelf_life,0);
602: IF x_ic_item_mst_row.shelf_life < 0
603: THEN
604: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_SHELF_LIFE');
605: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);

Line 602: IF x_ic_item_mst_row.shelf_life < 0

598: FND_MSG_PUB.Add;
599: END IF;
600:
601: x_ic_item_mst_row.shelf_life := NVL(p_item_rec.shelf_life,0);
602: IF x_ic_item_mst_row.shelf_life < 0
603: THEN
604: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_SHELF_LIFE');
605: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);
606: FND_MSG_PUB.Add;

Line 614: x_ic_item_mst_row.expaction_code := l_qc_actn_mst_row.action_code;

610: THEN
611: -- BUG#2461984 VAK
612: IF GMIGUTL.v_expaction_code(UPPER(RTRIM(p_item_rec.expaction_code)),l_qc_actn_mst_row)
613: THEN
614: x_ic_item_mst_row.expaction_code := l_qc_actn_mst_row.action_code;
615: END IF;
616: END IF;
617:
618: --Jalaj Srivastava Bug 1617398

Line 620: /* IF x_ic_item_mst_row.expaction_code IS NULL

616: END IF;
617:
618: --Jalaj Srivastava Bug 1617398
619: --expaction code should not be a required field
620: /* IF x_ic_item_mst_row.expaction_code IS NULL
621: THEN
622: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_EXPACTION_CODE');
623: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);
624: FND_MSG_PUB.Add;

Line 627: x_ic_item_mst_row.expaction_interval := NVL(p_item_rec.expaction_interval,0);

623: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);
624: FND_MSG_PUB.Add;
625: END IF; */
626:
627: x_ic_item_mst_row.expaction_interval := NVL(p_item_rec.expaction_interval,0);
628: IF x_ic_item_mst_row.expaction_interval < 0
629: THEN
630: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_EXPACTION_INTERVAL');
631: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);

Line 628: IF x_ic_item_mst_row.expaction_interval < 0

624: FND_MSG_PUB.Add;
625: END IF; */
626:
627: x_ic_item_mst_row.expaction_interval := NVL(p_item_rec.expaction_interval,0);
628: IF x_ic_item_mst_row.expaction_interval < 0
629: THEN
630: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_EXPACTION_INTERVAL');
631: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);
632: FND_MSG_PUB.Add;

Line 644: x_ic_item_mst_row.status_ctl := NVL(p_item_rec.status_ctl,0);

640: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);
641: FND_MSG_PUB.Add;
642: END IF;
643:
644: x_ic_item_mst_row.status_ctl := NVL(p_item_rec.status_ctl,0);
645:
646: IF x_ic_item_mst_row.status_ctl BETWEEN 0 AND 1
647: THEN
648: IF x_ic_item_mst_row.status_ctl = 1

Line 646: IF x_ic_item_mst_row.status_ctl BETWEEN 0 AND 1

642: END IF;
643:
644: x_ic_item_mst_row.status_ctl := NVL(p_item_rec.status_ctl,0);
645:
646: IF x_ic_item_mst_row.status_ctl BETWEEN 0 AND 1
647: THEN
648: IF x_ic_item_mst_row.status_ctl = 1
649: THEN
650: IF NVL(p_item_rec.lot_status, ' ') <> ' '

Line 648: IF x_ic_item_mst_row.status_ctl = 1

644: x_ic_item_mst_row.status_ctl := NVL(p_item_rec.status_ctl,0);
645:
646: IF x_ic_item_mst_row.status_ctl BETWEEN 0 AND 1
647: THEN
648: IF x_ic_item_mst_row.status_ctl = 1
649: THEN
650: IF NVL(p_item_rec.lot_status, ' ') <> ' '
651: THEN
652: IF GMIGUTL.v_lot_status(UPPER(p_item_rec.lot_status), l_ic_lots_sts_row)

Line 654: x_ic_item_mst_row.lot_status := l_ic_lots_sts_row.lot_status;

650: IF NVL(p_item_rec.lot_status, ' ') <> ' '
651: THEN
652: IF GMIGUTL.v_lot_status(UPPER(p_item_rec.lot_status), l_ic_lots_sts_row)
653: THEN
654: x_ic_item_mst_row.lot_status := l_ic_lots_sts_row.lot_status;
655: END IF;
656: END IF;
657:
658: IF x_ic_item_mst_row.lot_status IS NULL

Line 658: IF x_ic_item_mst_row.lot_status IS NULL

654: x_ic_item_mst_row.lot_status := l_ic_lots_sts_row.lot_status;
655: END IF;
656: END IF;
657:
658: IF x_ic_item_mst_row.lot_status IS NULL
659: THEN
660: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_STATUS');
661: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);
662: FND_MESSAGE.SET_TOKEN('LOT_STATUS', p_item_rec.lot_status);

Line 672: x_ic_item_mst_row.grade_ctl := 0;

668: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);
669: FND_MSG_PUB.Add;
670: END IF;
671: ELSE
672: x_ic_item_mst_row.grade_ctl := 0;
673: x_ic_item_mst_row.qc_grade := NULL;
674: x_ic_item_mst_row.status_ctl := 0;
675: x_ic_item_mst_row.lot_status := NULL;
676: x_ic_item_mst_row.expaction_interval := 0;

Line 673: x_ic_item_mst_row.qc_grade := NULL;

669: FND_MSG_PUB.Add;
670: END IF;
671: ELSE
672: x_ic_item_mst_row.grade_ctl := 0;
673: x_ic_item_mst_row.qc_grade := NULL;
674: x_ic_item_mst_row.status_ctl := 0;
675: x_ic_item_mst_row.lot_status := NULL;
676: x_ic_item_mst_row.expaction_interval := 0;
677: x_ic_item_mst_row.retest_interval := 0;

Line 674: x_ic_item_mst_row.status_ctl := 0;

670: END IF;
671: ELSE
672: x_ic_item_mst_row.grade_ctl := 0;
673: x_ic_item_mst_row.qc_grade := NULL;
674: x_ic_item_mst_row.status_ctl := 0;
675: x_ic_item_mst_row.lot_status := NULL;
676: x_ic_item_mst_row.expaction_interval := 0;
677: x_ic_item_mst_row.retest_interval := 0;
678: x_ic_item_mst_row.expaction_code := NULL;

Line 675: x_ic_item_mst_row.lot_status := NULL;

671: ELSE
672: x_ic_item_mst_row.grade_ctl := 0;
673: x_ic_item_mst_row.qc_grade := NULL;
674: x_ic_item_mst_row.status_ctl := 0;
675: x_ic_item_mst_row.lot_status := NULL;
676: x_ic_item_mst_row.expaction_interval := 0;
677: x_ic_item_mst_row.retest_interval := 0;
678: x_ic_item_mst_row.expaction_code := NULL;
679: x_ic_item_mst_row.shelf_life := 0;

Line 676: x_ic_item_mst_row.expaction_interval := 0;

672: x_ic_item_mst_row.grade_ctl := 0;
673: x_ic_item_mst_row.qc_grade := NULL;
674: x_ic_item_mst_row.status_ctl := 0;
675: x_ic_item_mst_row.lot_status := NULL;
676: x_ic_item_mst_row.expaction_interval := 0;
677: x_ic_item_mst_row.retest_interval := 0;
678: x_ic_item_mst_row.expaction_code := NULL;
679: x_ic_item_mst_row.shelf_life := 0;
680: END IF;

Line 677: x_ic_item_mst_row.retest_interval := 0;

673: x_ic_item_mst_row.qc_grade := NULL;
674: x_ic_item_mst_row.status_ctl := 0;
675: x_ic_item_mst_row.lot_status := NULL;
676: x_ic_item_mst_row.expaction_interval := 0;
677: x_ic_item_mst_row.retest_interval := 0;
678: x_ic_item_mst_row.expaction_code := NULL;
679: x_ic_item_mst_row.shelf_life := 0;
680: END IF;
681:

Line 678: x_ic_item_mst_row.expaction_code := NULL;

674: x_ic_item_mst_row.status_ctl := 0;
675: x_ic_item_mst_row.lot_status := NULL;
676: x_ic_item_mst_row.expaction_interval := 0;
677: x_ic_item_mst_row.retest_interval := 0;
678: x_ic_item_mst_row.expaction_code := NULL;
679: x_ic_item_mst_row.shelf_life := 0;
680: END IF;
681:
682: /* Experimental Indicator */

Line 679: x_ic_item_mst_row.shelf_life := 0;

675: x_ic_item_mst_row.lot_status := NULL;
676: x_ic_item_mst_row.expaction_interval := 0;
677: x_ic_item_mst_row.retest_interval := 0;
678: x_ic_item_mst_row.expaction_code := NULL;
679: x_ic_item_mst_row.shelf_life := 0;
680: END IF;
681:
682: /* Experimental Indicator */
683:

Line 684: x_ic_item_mst_row.experimental_ind := NVL(p_item_rec.experimental_ind,0);

680: END IF;
681:
682: /* Experimental Indicator */
683:
684: x_ic_item_mst_row.experimental_ind := NVL(p_item_rec.experimental_ind,0);
685: IF x_ic_item_mst_row.experimental_ind BETWEEN 0 AND 1
686: THEN
687: NULL;
688: ELSE

Line 685: IF x_ic_item_mst_row.experimental_ind BETWEEN 0 AND 1

681:
682: /* Experimental Indicator */
683:
684: x_ic_item_mst_row.experimental_ind := NVL(p_item_rec.experimental_ind,0);
685: IF x_ic_item_mst_row.experimental_ind BETWEEN 0 AND 1
686: THEN
687: NULL;
688: ELSE
689: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_EXPERIMENTAL');

Line 702: x_ic_item_mst_row.item_abccode := UPPER(RTRIM(p_item_rec.item_abccode));

698:
699: IF GMIVITM.v_classes(p_item_rec)
700: THEN
701: --BEGIN BUG#2461984 VAK
702: x_ic_item_mst_row.item_abccode := UPPER(RTRIM(p_item_rec.item_abccode));
703: x_ic_item_mst_row.gl_class := UPPER(RTRIM(p_item_rec.gl_class));
704: x_ic_item_mst_row.inv_class := UPPER(RTRIM(p_item_rec.inv_class));
705: x_ic_item_mst_row.sales_class := UPPER(RTRIM(p_item_rec.sales_class));
706: x_ic_item_mst_row.ship_class := UPPER(RTRIM(p_item_rec.ship_class));

Line 703: x_ic_item_mst_row.gl_class := UPPER(RTRIM(p_item_rec.gl_class));

699: IF GMIVITM.v_classes(p_item_rec)
700: THEN
701: --BEGIN BUG#2461984 VAK
702: x_ic_item_mst_row.item_abccode := UPPER(RTRIM(p_item_rec.item_abccode));
703: x_ic_item_mst_row.gl_class := UPPER(RTRIM(p_item_rec.gl_class));
704: x_ic_item_mst_row.inv_class := UPPER(RTRIM(p_item_rec.inv_class));
705: x_ic_item_mst_row.sales_class := UPPER(RTRIM(p_item_rec.sales_class));
706: x_ic_item_mst_row.ship_class := UPPER(RTRIM(p_item_rec.ship_class));
707: x_ic_item_mst_row.frt_class := UPPER(RTRIM(p_item_rec.frt_class));

Line 704: x_ic_item_mst_row.inv_class := UPPER(RTRIM(p_item_rec.inv_class));

700: THEN
701: --BEGIN BUG#2461984 VAK
702: x_ic_item_mst_row.item_abccode := UPPER(RTRIM(p_item_rec.item_abccode));
703: x_ic_item_mst_row.gl_class := UPPER(RTRIM(p_item_rec.gl_class));
704: x_ic_item_mst_row.inv_class := UPPER(RTRIM(p_item_rec.inv_class));
705: x_ic_item_mst_row.sales_class := UPPER(RTRIM(p_item_rec.sales_class));
706: x_ic_item_mst_row.ship_class := UPPER(RTRIM(p_item_rec.ship_class));
707: x_ic_item_mst_row.frt_class := UPPER(RTRIM(p_item_rec.frt_class));
708: x_ic_item_mst_row.price_class := UPPER(RTRIM(p_item_rec.price_class));

Line 705: x_ic_item_mst_row.sales_class := UPPER(RTRIM(p_item_rec.sales_class));

701: --BEGIN BUG#2461984 VAK
702: x_ic_item_mst_row.item_abccode := UPPER(RTRIM(p_item_rec.item_abccode));
703: x_ic_item_mst_row.gl_class := UPPER(RTRIM(p_item_rec.gl_class));
704: x_ic_item_mst_row.inv_class := UPPER(RTRIM(p_item_rec.inv_class));
705: x_ic_item_mst_row.sales_class := UPPER(RTRIM(p_item_rec.sales_class));
706: x_ic_item_mst_row.ship_class := UPPER(RTRIM(p_item_rec.ship_class));
707: x_ic_item_mst_row.frt_class := UPPER(RTRIM(p_item_rec.frt_class));
708: x_ic_item_mst_row.price_class := UPPER(RTRIM(p_item_rec.price_class));
709: x_ic_item_mst_row.storage_class := UPPER(RTRIM(p_item_rec.storage_class));

Line 706: x_ic_item_mst_row.ship_class := UPPER(RTRIM(p_item_rec.ship_class));

702: x_ic_item_mst_row.item_abccode := UPPER(RTRIM(p_item_rec.item_abccode));
703: x_ic_item_mst_row.gl_class := UPPER(RTRIM(p_item_rec.gl_class));
704: x_ic_item_mst_row.inv_class := UPPER(RTRIM(p_item_rec.inv_class));
705: x_ic_item_mst_row.sales_class := UPPER(RTRIM(p_item_rec.sales_class));
706: x_ic_item_mst_row.ship_class := UPPER(RTRIM(p_item_rec.ship_class));
707: x_ic_item_mst_row.frt_class := UPPER(RTRIM(p_item_rec.frt_class));
708: x_ic_item_mst_row.price_class := UPPER(RTRIM(p_item_rec.price_class));
709: x_ic_item_mst_row.storage_class := UPPER(RTRIM(p_item_rec.storage_class));
710: x_ic_item_mst_row.purch_class := UPPER(RTRIM(p_item_rec.purch_class));

Line 707: x_ic_item_mst_row.frt_class := UPPER(RTRIM(p_item_rec.frt_class));

703: x_ic_item_mst_row.gl_class := UPPER(RTRIM(p_item_rec.gl_class));
704: x_ic_item_mst_row.inv_class := UPPER(RTRIM(p_item_rec.inv_class));
705: x_ic_item_mst_row.sales_class := UPPER(RTRIM(p_item_rec.sales_class));
706: x_ic_item_mst_row.ship_class := UPPER(RTRIM(p_item_rec.ship_class));
707: x_ic_item_mst_row.frt_class := UPPER(RTRIM(p_item_rec.frt_class));
708: x_ic_item_mst_row.price_class := UPPER(RTRIM(p_item_rec.price_class));
709: x_ic_item_mst_row.storage_class := UPPER(RTRIM(p_item_rec.storage_class));
710: x_ic_item_mst_row.purch_class := UPPER(RTRIM(p_item_rec.purch_class));
711: x_ic_item_mst_row.tax_class := UPPER(RTRIM(p_item_rec.tax_class));

Line 708: x_ic_item_mst_row.price_class := UPPER(RTRIM(p_item_rec.price_class));

704: x_ic_item_mst_row.inv_class := UPPER(RTRIM(p_item_rec.inv_class));
705: x_ic_item_mst_row.sales_class := UPPER(RTRIM(p_item_rec.sales_class));
706: x_ic_item_mst_row.ship_class := UPPER(RTRIM(p_item_rec.ship_class));
707: x_ic_item_mst_row.frt_class := UPPER(RTRIM(p_item_rec.frt_class));
708: x_ic_item_mst_row.price_class := UPPER(RTRIM(p_item_rec.price_class));
709: x_ic_item_mst_row.storage_class := UPPER(RTRIM(p_item_rec.storage_class));
710: x_ic_item_mst_row.purch_class := UPPER(RTRIM(p_item_rec.purch_class));
711: x_ic_item_mst_row.tax_class := UPPER(RTRIM(p_item_rec.tax_class));
712: x_ic_item_mst_row.customs_class := UPPER(RTRIM(p_item_rec.customs_class));

Line 709: x_ic_item_mst_row.storage_class := UPPER(RTRIM(p_item_rec.storage_class));

705: x_ic_item_mst_row.sales_class := UPPER(RTRIM(p_item_rec.sales_class));
706: x_ic_item_mst_row.ship_class := UPPER(RTRIM(p_item_rec.ship_class));
707: x_ic_item_mst_row.frt_class := UPPER(RTRIM(p_item_rec.frt_class));
708: x_ic_item_mst_row.price_class := UPPER(RTRIM(p_item_rec.price_class));
709: x_ic_item_mst_row.storage_class := UPPER(RTRIM(p_item_rec.storage_class));
710: x_ic_item_mst_row.purch_class := UPPER(RTRIM(p_item_rec.purch_class));
711: x_ic_item_mst_row.tax_class := UPPER(RTRIM(p_item_rec.tax_class));
712: x_ic_item_mst_row.customs_class := UPPER(RTRIM(p_item_rec.customs_class));
713: x_ic_item_mst_row.alloc_class := UPPER(RTRIM(p_item_rec.alloc_class));

Line 710: x_ic_item_mst_row.purch_class := UPPER(RTRIM(p_item_rec.purch_class));

706: x_ic_item_mst_row.ship_class := UPPER(RTRIM(p_item_rec.ship_class));
707: x_ic_item_mst_row.frt_class := UPPER(RTRIM(p_item_rec.frt_class));
708: x_ic_item_mst_row.price_class := UPPER(RTRIM(p_item_rec.price_class));
709: x_ic_item_mst_row.storage_class := UPPER(RTRIM(p_item_rec.storage_class));
710: x_ic_item_mst_row.purch_class := UPPER(RTRIM(p_item_rec.purch_class));
711: x_ic_item_mst_row.tax_class := UPPER(RTRIM(p_item_rec.tax_class));
712: x_ic_item_mst_row.customs_class := UPPER(RTRIM(p_item_rec.customs_class));
713: x_ic_item_mst_row.alloc_class := UPPER(RTRIM(p_item_rec.alloc_class));
714: x_ic_item_mst_row.planning_class := UPPER(RTRIM(p_item_rec.planning_class));

Line 711: x_ic_item_mst_row.tax_class := UPPER(RTRIM(p_item_rec.tax_class));

707: x_ic_item_mst_row.frt_class := UPPER(RTRIM(p_item_rec.frt_class));
708: x_ic_item_mst_row.price_class := UPPER(RTRIM(p_item_rec.price_class));
709: x_ic_item_mst_row.storage_class := UPPER(RTRIM(p_item_rec.storage_class));
710: x_ic_item_mst_row.purch_class := UPPER(RTRIM(p_item_rec.purch_class));
711: x_ic_item_mst_row.tax_class := UPPER(RTRIM(p_item_rec.tax_class));
712: x_ic_item_mst_row.customs_class := UPPER(RTRIM(p_item_rec.customs_class));
713: x_ic_item_mst_row.alloc_class := UPPER(RTRIM(p_item_rec.alloc_class));
714: x_ic_item_mst_row.planning_class := UPPER(RTRIM(p_item_rec.planning_class));
715: x_ic_item_mst_row.itemcost_class := UPPER(RTRIM(p_item_rec.itemcost_class));

Line 712: x_ic_item_mst_row.customs_class := UPPER(RTRIM(p_item_rec.customs_class));

708: x_ic_item_mst_row.price_class := UPPER(RTRIM(p_item_rec.price_class));
709: x_ic_item_mst_row.storage_class := UPPER(RTRIM(p_item_rec.storage_class));
710: x_ic_item_mst_row.purch_class := UPPER(RTRIM(p_item_rec.purch_class));
711: x_ic_item_mst_row.tax_class := UPPER(RTRIM(p_item_rec.tax_class));
712: x_ic_item_mst_row.customs_class := UPPER(RTRIM(p_item_rec.customs_class));
713: x_ic_item_mst_row.alloc_class := UPPER(RTRIM(p_item_rec.alloc_class));
714: x_ic_item_mst_row.planning_class := UPPER(RTRIM(p_item_rec.planning_class));
715: x_ic_item_mst_row.itemcost_class := UPPER(RTRIM(p_item_rec.itemcost_class));
716: x_ic_item_mst_row.cost_mthd_code := UPPER(RTRIM(p_item_rec.cost_mthd_code));

Line 713: x_ic_item_mst_row.alloc_class := UPPER(RTRIM(p_item_rec.alloc_class));

709: x_ic_item_mst_row.storage_class := UPPER(RTRIM(p_item_rec.storage_class));
710: x_ic_item_mst_row.purch_class := UPPER(RTRIM(p_item_rec.purch_class));
711: x_ic_item_mst_row.tax_class := UPPER(RTRIM(p_item_rec.tax_class));
712: x_ic_item_mst_row.customs_class := UPPER(RTRIM(p_item_rec.customs_class));
713: x_ic_item_mst_row.alloc_class := UPPER(RTRIM(p_item_rec.alloc_class));
714: x_ic_item_mst_row.planning_class := UPPER(RTRIM(p_item_rec.planning_class));
715: x_ic_item_mst_row.itemcost_class := UPPER(RTRIM(p_item_rec.itemcost_class));
716: x_ic_item_mst_row.cost_mthd_code := UPPER(RTRIM(p_item_rec.cost_mthd_code));
717: -- x_ic_item_mst_row.item_abccode := UPPER(p_item_rec.item_abccode);

Line 714: x_ic_item_mst_row.planning_class := UPPER(RTRIM(p_item_rec.planning_class));

710: x_ic_item_mst_row.purch_class := UPPER(RTRIM(p_item_rec.purch_class));
711: x_ic_item_mst_row.tax_class := UPPER(RTRIM(p_item_rec.tax_class));
712: x_ic_item_mst_row.customs_class := UPPER(RTRIM(p_item_rec.customs_class));
713: x_ic_item_mst_row.alloc_class := UPPER(RTRIM(p_item_rec.alloc_class));
714: x_ic_item_mst_row.planning_class := UPPER(RTRIM(p_item_rec.planning_class));
715: x_ic_item_mst_row.itemcost_class := UPPER(RTRIM(p_item_rec.itemcost_class));
716: x_ic_item_mst_row.cost_mthd_code := UPPER(RTRIM(p_item_rec.cost_mthd_code));
717: -- x_ic_item_mst_row.item_abccode := UPPER(p_item_rec.item_abccode);
718: x_ic_item_mst_row.qchold_res_code := UPPER(RTRIM(p_item_rec.qchold_res_code));

Line 715: x_ic_item_mst_row.itemcost_class := UPPER(RTRIM(p_item_rec.itemcost_class));

711: x_ic_item_mst_row.tax_class := UPPER(RTRIM(p_item_rec.tax_class));
712: x_ic_item_mst_row.customs_class := UPPER(RTRIM(p_item_rec.customs_class));
713: x_ic_item_mst_row.alloc_class := UPPER(RTRIM(p_item_rec.alloc_class));
714: x_ic_item_mst_row.planning_class := UPPER(RTRIM(p_item_rec.planning_class));
715: x_ic_item_mst_row.itemcost_class := UPPER(RTRIM(p_item_rec.itemcost_class));
716: x_ic_item_mst_row.cost_mthd_code := UPPER(RTRIM(p_item_rec.cost_mthd_code));
717: -- x_ic_item_mst_row.item_abccode := UPPER(p_item_rec.item_abccode);
718: x_ic_item_mst_row.qchold_res_code := UPPER(RTRIM(p_item_rec.qchold_res_code));
719: x_ic_item_mst_row.seq_dpnd_class := UPPER(RTRIM(p_item_rec.seq_dpnd_class));

Line 716: x_ic_item_mst_row.cost_mthd_code := UPPER(RTRIM(p_item_rec.cost_mthd_code));

712: x_ic_item_mst_row.customs_class := UPPER(RTRIM(p_item_rec.customs_class));
713: x_ic_item_mst_row.alloc_class := UPPER(RTRIM(p_item_rec.alloc_class));
714: x_ic_item_mst_row.planning_class := UPPER(RTRIM(p_item_rec.planning_class));
715: x_ic_item_mst_row.itemcost_class := UPPER(RTRIM(p_item_rec.itemcost_class));
716: x_ic_item_mst_row.cost_mthd_code := UPPER(RTRIM(p_item_rec.cost_mthd_code));
717: -- x_ic_item_mst_row.item_abccode := UPPER(p_item_rec.item_abccode);
718: x_ic_item_mst_row.qchold_res_code := UPPER(RTRIM(p_item_rec.qchold_res_code));
719: x_ic_item_mst_row.seq_dpnd_class := UPPER(RTRIM(p_item_rec.seq_dpnd_class));
720: x_ic_item_mst_row.inv_type := UPPER(RTRIM(p_item_rec.inv_type));

Line 717: -- x_ic_item_mst_row.item_abccode := UPPER(p_item_rec.item_abccode);

713: x_ic_item_mst_row.alloc_class := UPPER(RTRIM(p_item_rec.alloc_class));
714: x_ic_item_mst_row.planning_class := UPPER(RTRIM(p_item_rec.planning_class));
715: x_ic_item_mst_row.itemcost_class := UPPER(RTRIM(p_item_rec.itemcost_class));
716: x_ic_item_mst_row.cost_mthd_code := UPPER(RTRIM(p_item_rec.cost_mthd_code));
717: -- x_ic_item_mst_row.item_abccode := UPPER(p_item_rec.item_abccode);
718: x_ic_item_mst_row.qchold_res_code := UPPER(RTRIM(p_item_rec.qchold_res_code));
719: x_ic_item_mst_row.seq_dpnd_class := UPPER(RTRIM(p_item_rec.seq_dpnd_class));
720: x_ic_item_mst_row.inv_type := UPPER(RTRIM(p_item_rec.inv_type));
721: --END BUG#2461984

Line 718: x_ic_item_mst_row.qchold_res_code := UPPER(RTRIM(p_item_rec.qchold_res_code));

714: x_ic_item_mst_row.planning_class := UPPER(RTRIM(p_item_rec.planning_class));
715: x_ic_item_mst_row.itemcost_class := UPPER(RTRIM(p_item_rec.itemcost_class));
716: x_ic_item_mst_row.cost_mthd_code := UPPER(RTRIM(p_item_rec.cost_mthd_code));
717: -- x_ic_item_mst_row.item_abccode := UPPER(p_item_rec.item_abccode);
718: x_ic_item_mst_row.qchold_res_code := UPPER(RTRIM(p_item_rec.qchold_res_code));
719: x_ic_item_mst_row.seq_dpnd_class := UPPER(RTRIM(p_item_rec.seq_dpnd_class));
720: x_ic_item_mst_row.inv_type := UPPER(RTRIM(p_item_rec.inv_type));
721: --END BUG#2461984
722: ELSE

Line 719: x_ic_item_mst_row.seq_dpnd_class := UPPER(RTRIM(p_item_rec.seq_dpnd_class));

715: x_ic_item_mst_row.itemcost_class := UPPER(RTRIM(p_item_rec.itemcost_class));
716: x_ic_item_mst_row.cost_mthd_code := UPPER(RTRIM(p_item_rec.cost_mthd_code));
717: -- x_ic_item_mst_row.item_abccode := UPPER(p_item_rec.item_abccode);
718: x_ic_item_mst_row.qchold_res_code := UPPER(RTRIM(p_item_rec.qchold_res_code));
719: x_ic_item_mst_row.seq_dpnd_class := UPPER(RTRIM(p_item_rec.seq_dpnd_class));
720: x_ic_item_mst_row.inv_type := UPPER(RTRIM(p_item_rec.inv_type));
721: --END BUG#2461984
722: ELSE
723: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_CLASS');

Line 720: x_ic_item_mst_row.inv_type := UPPER(RTRIM(p_item_rec.inv_type));

716: x_ic_item_mst_row.cost_mthd_code := UPPER(RTRIM(p_item_rec.cost_mthd_code));
717: -- x_ic_item_mst_row.item_abccode := UPPER(p_item_rec.item_abccode);
718: x_ic_item_mst_row.qchold_res_code := UPPER(RTRIM(p_item_rec.qchold_res_code));
719: x_ic_item_mst_row.seq_dpnd_class := UPPER(RTRIM(p_item_rec.seq_dpnd_class));
720: x_ic_item_mst_row.inv_type := UPPER(RTRIM(p_item_rec.inv_type));
721: --END BUG#2461984
722: ELSE
723: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_CLASS');
724: FND_MSG_PUB.Add;

Line 732: x_ic_item_mst_row.commodity_code := NULL;

728: Joe DiIorio 10/23/2001 BUG#1989860 11.5.1H
729: Removed intrastat check and always set commodity
730: code to null.
731: ================================================*/
732: x_ic_item_mst_row.commodity_code := NULL;
733:
734:
735: /*=====================================================
736: Joe DiIorio 01/02/2001 BUG#2106212

Line 740: x_ic_item_mst_row.upc_code := UPPER(RTRIM(p_item_rec.upc_code));

736: Joe DiIorio 01/02/2001 BUG#2106212
737: Changed this line to get input upccode..
738: ====================================================*/
739: -- BUG#2461984 VAK
740: x_ic_item_mst_row.upc_code := UPPER(RTRIM(p_item_rec.upc_code));
741:
742: /* Unused columns, although some of these are not null on the databse */
743: x_ic_item_mst_row.bulk_id := NULL;
744: x_ic_item_mst_row.pkg_id := NULL;

Line 743: x_ic_item_mst_row.bulk_id := NULL;

739: -- BUG#2461984 VAK
740: x_ic_item_mst_row.upc_code := UPPER(RTRIM(p_item_rec.upc_code));
741:
742: /* Unused columns, although some of these are not null on the databse */
743: x_ic_item_mst_row.bulk_id := NULL;
744: x_ic_item_mst_row.pkg_id := NULL;
745: x_ic_item_mst_row.fill_qty := 0;
746: x_ic_item_mst_row.fill_um := NULL;
747: x_ic_item_mst_row.phantom_type := 0;

Line 744: x_ic_item_mst_row.pkg_id := NULL;

740: x_ic_item_mst_row.upc_code := UPPER(RTRIM(p_item_rec.upc_code));
741:
742: /* Unused columns, although some of these are not null on the databse */
743: x_ic_item_mst_row.bulk_id := NULL;
744: x_ic_item_mst_row.pkg_id := NULL;
745: x_ic_item_mst_row.fill_qty := 0;
746: x_ic_item_mst_row.fill_um := NULL;
747: x_ic_item_mst_row.phantom_type := 0;
748:

Line 745: x_ic_item_mst_row.fill_qty := 0;

741:
742: /* Unused columns, although some of these are not null on the databse */
743: x_ic_item_mst_row.bulk_id := NULL;
744: x_ic_item_mst_row.pkg_id := NULL;
745: x_ic_item_mst_row.fill_qty := 0;
746: x_ic_item_mst_row.fill_um := NULL;
747: x_ic_item_mst_row.phantom_type := 0;
748:
749:

Line 746: x_ic_item_mst_row.fill_um := NULL;

742: /* Unused columns, although some of these are not null on the databse */
743: x_ic_item_mst_row.bulk_id := NULL;
744: x_ic_item_mst_row.pkg_id := NULL;
745: x_ic_item_mst_row.fill_qty := 0;
746: x_ic_item_mst_row.fill_um := NULL;
747: x_ic_item_mst_row.phantom_type := 0;
748:
749:
750: /* warehouse item and QC reference item */

Line 747: x_ic_item_mst_row.phantom_type := 0;

743: x_ic_item_mst_row.bulk_id := NULL;
744: x_ic_item_mst_row.pkg_id := NULL;
745: x_ic_item_mst_row.fill_qty := 0;
746: x_ic_item_mst_row.fill_um := NULL;
747: x_ic_item_mst_row.phantom_type := 0;
748:
749:
750: /* warehouse item and QC reference item */
751:

Line 754: x_ic_item_mst_row.whse_item_id:= NULL;

750: /* warehouse item and QC reference item */
751:
752: IF NVL(p_item_rec.whse_item_no,p_item_rec.item_no) = p_item_rec.item_no
753: THEN
754: x_ic_item_mst_row.whse_item_id:= NULL;
755: ELSE
756: -- BUG#2461984 VAK
757: GMIGUTL.get_item(UPPER(RTRIM(p_item_rec.whse_item_no)), l_ic_item_mst_row, l_ic_item_cpg_row);
758: IF l_ic_item_mst_row.item_id IS NOT NULL

Line 757: GMIGUTL.get_item(UPPER(RTRIM(p_item_rec.whse_item_no)), l_ic_item_mst_row, l_ic_item_cpg_row);

753: THEN
754: x_ic_item_mst_row.whse_item_id:= NULL;
755: ELSE
756: -- BUG#2461984 VAK
757: GMIGUTL.get_item(UPPER(RTRIM(p_item_rec.whse_item_no)), l_ic_item_mst_row, l_ic_item_cpg_row);
758: IF l_ic_item_mst_row.item_id IS NOT NULL
759: THEN
760: x_ic_item_mst_row.whse_item_id := l_ic_item_mst_row.item_id;
761: ELSE

Line 758: IF l_ic_item_mst_row.item_id IS NOT NULL

754: x_ic_item_mst_row.whse_item_id:= NULL;
755: ELSE
756: -- BUG#2461984 VAK
757: GMIGUTL.get_item(UPPER(RTRIM(p_item_rec.whse_item_no)), l_ic_item_mst_row, l_ic_item_cpg_row);
758: IF l_ic_item_mst_row.item_id IS NOT NULL
759: THEN
760: x_ic_item_mst_row.whse_item_id := l_ic_item_mst_row.item_id;
761: ELSE
762: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_WHSE_ITEM_NO');

Line 760: x_ic_item_mst_row.whse_item_id := l_ic_item_mst_row.item_id;

756: -- BUG#2461984 VAK
757: GMIGUTL.get_item(UPPER(RTRIM(p_item_rec.whse_item_no)), l_ic_item_mst_row, l_ic_item_cpg_row);
758: IF l_ic_item_mst_row.item_id IS NOT NULL
759: THEN
760: x_ic_item_mst_row.whse_item_id := l_ic_item_mst_row.item_id;
761: ELSE
762: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_WHSE_ITEM_NO');
763: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);
764: FND_MSG_PUB.Add;

Line 771: x_ic_item_mst_row.qcitem_id:= NULL;

767:
768:
769: IF NVL(p_item_rec.qcitem_no,' ') = ' '
770: THEN
771: x_ic_item_mst_row.qcitem_id:= NULL;
772: ELSE
773: -- BUG#2461984 VAK
774: GMIGUTL.get_item(UPPER(RTRIM(p_item_rec.qcitem_no)),l_ic_item_mst_row, l_ic_item_cpg_row);
775: IF l_ic_item_mst_row.item_id IS NOT NULL

Line 774: GMIGUTL.get_item(UPPER(RTRIM(p_item_rec.qcitem_no)),l_ic_item_mst_row, l_ic_item_cpg_row);

770: THEN
771: x_ic_item_mst_row.qcitem_id:= NULL;
772: ELSE
773: -- BUG#2461984 VAK
774: GMIGUTL.get_item(UPPER(RTRIM(p_item_rec.qcitem_no)),l_ic_item_mst_row, l_ic_item_cpg_row);
775: IF l_ic_item_mst_row.item_id IS NOT NULL
776: THEN
777: x_ic_item_mst_row.qcitem_id := l_ic_item_mst_row.item_id;
778: ELSE

Line 775: IF l_ic_item_mst_row.item_id IS NOT NULL

771: x_ic_item_mst_row.qcitem_id:= NULL;
772: ELSE
773: -- BUG#2461984 VAK
774: GMIGUTL.get_item(UPPER(RTRIM(p_item_rec.qcitem_no)),l_ic_item_mst_row, l_ic_item_cpg_row);
775: IF l_ic_item_mst_row.item_id IS NOT NULL
776: THEN
777: x_ic_item_mst_row.qcitem_id := l_ic_item_mst_row.item_id;
778: ELSE
779: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_QCITEM_NO');

Line 777: x_ic_item_mst_row.qcitem_id := l_ic_item_mst_row.item_id;

773: -- BUG#2461984 VAK
774: GMIGUTL.get_item(UPPER(RTRIM(p_item_rec.qcitem_no)),l_ic_item_mst_row, l_ic_item_cpg_row);
775: IF l_ic_item_mst_row.item_id IS NOT NULL
776: THEN
777: x_ic_item_mst_row.qcitem_id := l_ic_item_mst_row.item_id;
778: ELSE
779: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_QCITEM_NO');
780: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.qcitem_no);
781: FND_MSG_PUB.Add;

Line 786: x_ic_item_mst_row.exported_date := GMA_GLOBAL_GRP.SY$MIN_DATE;

782: END IF;
783: END IF;
784:
785: /* Exported date */
786: x_ic_item_mst_row.exported_date := GMA_GLOBAL_GRP.SY$MIN_DATE;
787:
788: /* Audit columns */
789: x_ic_item_mst_row.creation_date := SYSDATE;
790: x_ic_item_mst_row.last_update_date := SYSDATE;

Line 789: x_ic_item_mst_row.creation_date := SYSDATE;

785: /* Exported date */
786: x_ic_item_mst_row.exported_date := GMA_GLOBAL_GRP.SY$MIN_DATE;
787:
788: /* Audit columns */
789: x_ic_item_mst_row.creation_date := SYSDATE;
790: x_ic_item_mst_row.last_update_date := SYSDATE;
791: x_ic_item_mst_row.created_by := GMIGUTL.DEFAULT_USER_ID;
792: x_ic_item_mst_row.last_updated_by := GMIGUTL.DEFAULT_USER_ID;
793: x_ic_item_mst_row.last_update_login := GMIGUTL.DEFAULT_LOGIN;

Line 790: x_ic_item_mst_row.last_update_date := SYSDATE;

786: x_ic_item_mst_row.exported_date := GMA_GLOBAL_GRP.SY$MIN_DATE;
787:
788: /* Audit columns */
789: x_ic_item_mst_row.creation_date := SYSDATE;
790: x_ic_item_mst_row.last_update_date := SYSDATE;
791: x_ic_item_mst_row.created_by := GMIGUTL.DEFAULT_USER_ID;
792: x_ic_item_mst_row.last_updated_by := GMIGUTL.DEFAULT_USER_ID;
793: x_ic_item_mst_row.last_update_login := GMIGUTL.DEFAULT_LOGIN;
794: x_ic_item_mst_row.delete_mark := 0;

Line 791: x_ic_item_mst_row.created_by := GMIGUTL.DEFAULT_USER_ID;

787:
788: /* Audit columns */
789: x_ic_item_mst_row.creation_date := SYSDATE;
790: x_ic_item_mst_row.last_update_date := SYSDATE;
791: x_ic_item_mst_row.created_by := GMIGUTL.DEFAULT_USER_ID;
792: x_ic_item_mst_row.last_updated_by := GMIGUTL.DEFAULT_USER_ID;
793: x_ic_item_mst_row.last_update_login := GMIGUTL.DEFAULT_LOGIN;
794: x_ic_item_mst_row.delete_mark := 0;
795: x_ic_item_mst_row.trans_cnt := 1;

Line 792: x_ic_item_mst_row.last_updated_by := GMIGUTL.DEFAULT_USER_ID;

788: /* Audit columns */
789: x_ic_item_mst_row.creation_date := SYSDATE;
790: x_ic_item_mst_row.last_update_date := SYSDATE;
791: x_ic_item_mst_row.created_by := GMIGUTL.DEFAULT_USER_ID;
792: x_ic_item_mst_row.last_updated_by := GMIGUTL.DEFAULT_USER_ID;
793: x_ic_item_mst_row.last_update_login := GMIGUTL.DEFAULT_LOGIN;
794: x_ic_item_mst_row.delete_mark := 0;
795: x_ic_item_mst_row.trans_cnt := 1;
796:

Line 793: x_ic_item_mst_row.last_update_login := GMIGUTL.DEFAULT_LOGIN;

789: x_ic_item_mst_row.creation_date := SYSDATE;
790: x_ic_item_mst_row.last_update_date := SYSDATE;
791: x_ic_item_mst_row.created_by := GMIGUTL.DEFAULT_USER_ID;
792: x_ic_item_mst_row.last_updated_by := GMIGUTL.DEFAULT_USER_ID;
793: x_ic_item_mst_row.last_update_login := GMIGUTL.DEFAULT_LOGIN;
794: x_ic_item_mst_row.delete_mark := 0;
795: x_ic_item_mst_row.trans_cnt := 1;
796:
797: /* Bug 2506207 */

Line 794: x_ic_item_mst_row.delete_mark := 0;

790: x_ic_item_mst_row.last_update_date := SYSDATE;
791: x_ic_item_mst_row.created_by := GMIGUTL.DEFAULT_USER_ID;
792: x_ic_item_mst_row.last_updated_by := GMIGUTL.DEFAULT_USER_ID;
793: x_ic_item_mst_row.last_update_login := GMIGUTL.DEFAULT_LOGIN;
794: x_ic_item_mst_row.delete_mark := 0;
795: x_ic_item_mst_row.trans_cnt := 1;
796:
797: /* Bug 2506207 */
798: /* Removed UPPER function on all attribute columns */

Line 795: x_ic_item_mst_row.trans_cnt := 1;

791: x_ic_item_mst_row.created_by := GMIGUTL.DEFAULT_USER_ID;
792: x_ic_item_mst_row.last_updated_by := GMIGUTL.DEFAULT_USER_ID;
793: x_ic_item_mst_row.last_update_login := GMIGUTL.DEFAULT_LOGIN;
794: x_ic_item_mst_row.delete_mark := 0;
795: x_ic_item_mst_row.trans_cnt := 1;
796:
797: /* Bug 2506207 */
798: /* Removed UPPER function on all attribute columns */
799: /* Setup attributes 'as is' */

Line 801: x_ic_item_mst_row.attribute1 := RTRIM(p_item_rec.attribute1);

797: /* Bug 2506207 */
798: /* Removed UPPER function on all attribute columns */
799: /* Setup attributes 'as is' */
800: --BEGIN BUG#2461984 VAK
801: x_ic_item_mst_row.attribute1 := RTRIM(p_item_rec.attribute1);
802: x_ic_item_mst_row.attribute2 := RTRIM(p_item_rec.attribute2);
803: x_ic_item_mst_row.attribute3 := RTRIM(p_item_rec.attribute3);
804: x_ic_item_mst_row.attribute4 := RTRIM(p_item_rec.attribute4);
805: x_ic_item_mst_row.attribute5 := RTRIM(p_item_rec.attribute5);

Line 802: x_ic_item_mst_row.attribute2 := RTRIM(p_item_rec.attribute2);

798: /* Removed UPPER function on all attribute columns */
799: /* Setup attributes 'as is' */
800: --BEGIN BUG#2461984 VAK
801: x_ic_item_mst_row.attribute1 := RTRIM(p_item_rec.attribute1);
802: x_ic_item_mst_row.attribute2 := RTRIM(p_item_rec.attribute2);
803: x_ic_item_mst_row.attribute3 := RTRIM(p_item_rec.attribute3);
804: x_ic_item_mst_row.attribute4 := RTRIM(p_item_rec.attribute4);
805: x_ic_item_mst_row.attribute5 := RTRIM(p_item_rec.attribute5);
806: x_ic_item_mst_row.attribute6 := RTRIM(p_item_rec.attribute6);

Line 803: x_ic_item_mst_row.attribute3 := RTRIM(p_item_rec.attribute3);

799: /* Setup attributes 'as is' */
800: --BEGIN BUG#2461984 VAK
801: x_ic_item_mst_row.attribute1 := RTRIM(p_item_rec.attribute1);
802: x_ic_item_mst_row.attribute2 := RTRIM(p_item_rec.attribute2);
803: x_ic_item_mst_row.attribute3 := RTRIM(p_item_rec.attribute3);
804: x_ic_item_mst_row.attribute4 := RTRIM(p_item_rec.attribute4);
805: x_ic_item_mst_row.attribute5 := RTRIM(p_item_rec.attribute5);
806: x_ic_item_mst_row.attribute6 := RTRIM(p_item_rec.attribute6);
807: x_ic_item_mst_row.attribute7 := RTRIM(p_item_rec.attribute7);

Line 804: x_ic_item_mst_row.attribute4 := RTRIM(p_item_rec.attribute4);

800: --BEGIN BUG#2461984 VAK
801: x_ic_item_mst_row.attribute1 := RTRIM(p_item_rec.attribute1);
802: x_ic_item_mst_row.attribute2 := RTRIM(p_item_rec.attribute2);
803: x_ic_item_mst_row.attribute3 := RTRIM(p_item_rec.attribute3);
804: x_ic_item_mst_row.attribute4 := RTRIM(p_item_rec.attribute4);
805: x_ic_item_mst_row.attribute5 := RTRIM(p_item_rec.attribute5);
806: x_ic_item_mst_row.attribute6 := RTRIM(p_item_rec.attribute6);
807: x_ic_item_mst_row.attribute7 := RTRIM(p_item_rec.attribute7);
808: x_ic_item_mst_row.attribute8 := RTRIM(p_item_rec.attribute8);

Line 805: x_ic_item_mst_row.attribute5 := RTRIM(p_item_rec.attribute5);

801: x_ic_item_mst_row.attribute1 := RTRIM(p_item_rec.attribute1);
802: x_ic_item_mst_row.attribute2 := RTRIM(p_item_rec.attribute2);
803: x_ic_item_mst_row.attribute3 := RTRIM(p_item_rec.attribute3);
804: x_ic_item_mst_row.attribute4 := RTRIM(p_item_rec.attribute4);
805: x_ic_item_mst_row.attribute5 := RTRIM(p_item_rec.attribute5);
806: x_ic_item_mst_row.attribute6 := RTRIM(p_item_rec.attribute6);
807: x_ic_item_mst_row.attribute7 := RTRIM(p_item_rec.attribute7);
808: x_ic_item_mst_row.attribute8 := RTRIM(p_item_rec.attribute8);
809: x_ic_item_mst_row.attribute9 := RTRIM(p_item_rec.attribute9);

Line 806: x_ic_item_mst_row.attribute6 := RTRIM(p_item_rec.attribute6);

802: x_ic_item_mst_row.attribute2 := RTRIM(p_item_rec.attribute2);
803: x_ic_item_mst_row.attribute3 := RTRIM(p_item_rec.attribute3);
804: x_ic_item_mst_row.attribute4 := RTRIM(p_item_rec.attribute4);
805: x_ic_item_mst_row.attribute5 := RTRIM(p_item_rec.attribute5);
806: x_ic_item_mst_row.attribute6 := RTRIM(p_item_rec.attribute6);
807: x_ic_item_mst_row.attribute7 := RTRIM(p_item_rec.attribute7);
808: x_ic_item_mst_row.attribute8 := RTRIM(p_item_rec.attribute8);
809: x_ic_item_mst_row.attribute9 := RTRIM(p_item_rec.attribute9);
810: x_ic_item_mst_row.attribute10 := RTRIM(p_item_rec.attribute10);

Line 807: x_ic_item_mst_row.attribute7 := RTRIM(p_item_rec.attribute7);

803: x_ic_item_mst_row.attribute3 := RTRIM(p_item_rec.attribute3);
804: x_ic_item_mst_row.attribute4 := RTRIM(p_item_rec.attribute4);
805: x_ic_item_mst_row.attribute5 := RTRIM(p_item_rec.attribute5);
806: x_ic_item_mst_row.attribute6 := RTRIM(p_item_rec.attribute6);
807: x_ic_item_mst_row.attribute7 := RTRIM(p_item_rec.attribute7);
808: x_ic_item_mst_row.attribute8 := RTRIM(p_item_rec.attribute8);
809: x_ic_item_mst_row.attribute9 := RTRIM(p_item_rec.attribute9);
810: x_ic_item_mst_row.attribute10 := RTRIM(p_item_rec.attribute10);
811: x_ic_item_mst_row.attribute11 := RTRIM(p_item_rec.attribute11);

Line 808: x_ic_item_mst_row.attribute8 := RTRIM(p_item_rec.attribute8);

804: x_ic_item_mst_row.attribute4 := RTRIM(p_item_rec.attribute4);
805: x_ic_item_mst_row.attribute5 := RTRIM(p_item_rec.attribute5);
806: x_ic_item_mst_row.attribute6 := RTRIM(p_item_rec.attribute6);
807: x_ic_item_mst_row.attribute7 := RTRIM(p_item_rec.attribute7);
808: x_ic_item_mst_row.attribute8 := RTRIM(p_item_rec.attribute8);
809: x_ic_item_mst_row.attribute9 := RTRIM(p_item_rec.attribute9);
810: x_ic_item_mst_row.attribute10 := RTRIM(p_item_rec.attribute10);
811: x_ic_item_mst_row.attribute11 := RTRIM(p_item_rec.attribute11);
812: x_ic_item_mst_row.attribute12 := RTRIM(p_item_rec.attribute12);

Line 809: x_ic_item_mst_row.attribute9 := RTRIM(p_item_rec.attribute9);

805: x_ic_item_mst_row.attribute5 := RTRIM(p_item_rec.attribute5);
806: x_ic_item_mst_row.attribute6 := RTRIM(p_item_rec.attribute6);
807: x_ic_item_mst_row.attribute7 := RTRIM(p_item_rec.attribute7);
808: x_ic_item_mst_row.attribute8 := RTRIM(p_item_rec.attribute8);
809: x_ic_item_mst_row.attribute9 := RTRIM(p_item_rec.attribute9);
810: x_ic_item_mst_row.attribute10 := RTRIM(p_item_rec.attribute10);
811: x_ic_item_mst_row.attribute11 := RTRIM(p_item_rec.attribute11);
812: x_ic_item_mst_row.attribute12 := RTRIM(p_item_rec.attribute12);
813: x_ic_item_mst_row.attribute13 := RTRIM(p_item_rec.attribute13);

Line 810: x_ic_item_mst_row.attribute10 := RTRIM(p_item_rec.attribute10);

806: x_ic_item_mst_row.attribute6 := RTRIM(p_item_rec.attribute6);
807: x_ic_item_mst_row.attribute7 := RTRIM(p_item_rec.attribute7);
808: x_ic_item_mst_row.attribute8 := RTRIM(p_item_rec.attribute8);
809: x_ic_item_mst_row.attribute9 := RTRIM(p_item_rec.attribute9);
810: x_ic_item_mst_row.attribute10 := RTRIM(p_item_rec.attribute10);
811: x_ic_item_mst_row.attribute11 := RTRIM(p_item_rec.attribute11);
812: x_ic_item_mst_row.attribute12 := RTRIM(p_item_rec.attribute12);
813: x_ic_item_mst_row.attribute13 := RTRIM(p_item_rec.attribute13);
814: x_ic_item_mst_row.attribute14 := RTRIM(p_item_rec.attribute14);

Line 811: x_ic_item_mst_row.attribute11 := RTRIM(p_item_rec.attribute11);

807: x_ic_item_mst_row.attribute7 := RTRIM(p_item_rec.attribute7);
808: x_ic_item_mst_row.attribute8 := RTRIM(p_item_rec.attribute8);
809: x_ic_item_mst_row.attribute9 := RTRIM(p_item_rec.attribute9);
810: x_ic_item_mst_row.attribute10 := RTRIM(p_item_rec.attribute10);
811: x_ic_item_mst_row.attribute11 := RTRIM(p_item_rec.attribute11);
812: x_ic_item_mst_row.attribute12 := RTRIM(p_item_rec.attribute12);
813: x_ic_item_mst_row.attribute13 := RTRIM(p_item_rec.attribute13);
814: x_ic_item_mst_row.attribute14 := RTRIM(p_item_rec.attribute14);
815: x_ic_item_mst_row.attribute15 := RTRIM(p_item_rec.attribute15);

Line 812: x_ic_item_mst_row.attribute12 := RTRIM(p_item_rec.attribute12);

808: x_ic_item_mst_row.attribute8 := RTRIM(p_item_rec.attribute8);
809: x_ic_item_mst_row.attribute9 := RTRIM(p_item_rec.attribute9);
810: x_ic_item_mst_row.attribute10 := RTRIM(p_item_rec.attribute10);
811: x_ic_item_mst_row.attribute11 := RTRIM(p_item_rec.attribute11);
812: x_ic_item_mst_row.attribute12 := RTRIM(p_item_rec.attribute12);
813: x_ic_item_mst_row.attribute13 := RTRIM(p_item_rec.attribute13);
814: x_ic_item_mst_row.attribute14 := RTRIM(p_item_rec.attribute14);
815: x_ic_item_mst_row.attribute15 := RTRIM(p_item_rec.attribute15);
816: x_ic_item_mst_row.attribute16 := RTRIM(p_item_rec.attribute16);

Line 813: x_ic_item_mst_row.attribute13 := RTRIM(p_item_rec.attribute13);

809: x_ic_item_mst_row.attribute9 := RTRIM(p_item_rec.attribute9);
810: x_ic_item_mst_row.attribute10 := RTRIM(p_item_rec.attribute10);
811: x_ic_item_mst_row.attribute11 := RTRIM(p_item_rec.attribute11);
812: x_ic_item_mst_row.attribute12 := RTRIM(p_item_rec.attribute12);
813: x_ic_item_mst_row.attribute13 := RTRIM(p_item_rec.attribute13);
814: x_ic_item_mst_row.attribute14 := RTRIM(p_item_rec.attribute14);
815: x_ic_item_mst_row.attribute15 := RTRIM(p_item_rec.attribute15);
816: x_ic_item_mst_row.attribute16 := RTRIM(p_item_rec.attribute16);
817: x_ic_item_mst_row.attribute17 := RTRIM(p_item_rec.attribute17);

Line 814: x_ic_item_mst_row.attribute14 := RTRIM(p_item_rec.attribute14);

810: x_ic_item_mst_row.attribute10 := RTRIM(p_item_rec.attribute10);
811: x_ic_item_mst_row.attribute11 := RTRIM(p_item_rec.attribute11);
812: x_ic_item_mst_row.attribute12 := RTRIM(p_item_rec.attribute12);
813: x_ic_item_mst_row.attribute13 := RTRIM(p_item_rec.attribute13);
814: x_ic_item_mst_row.attribute14 := RTRIM(p_item_rec.attribute14);
815: x_ic_item_mst_row.attribute15 := RTRIM(p_item_rec.attribute15);
816: x_ic_item_mst_row.attribute16 := RTRIM(p_item_rec.attribute16);
817: x_ic_item_mst_row.attribute17 := RTRIM(p_item_rec.attribute17);
818: x_ic_item_mst_row.attribute18 := RTRIM(p_item_rec.attribute18);

Line 815: x_ic_item_mst_row.attribute15 := RTRIM(p_item_rec.attribute15);

811: x_ic_item_mst_row.attribute11 := RTRIM(p_item_rec.attribute11);
812: x_ic_item_mst_row.attribute12 := RTRIM(p_item_rec.attribute12);
813: x_ic_item_mst_row.attribute13 := RTRIM(p_item_rec.attribute13);
814: x_ic_item_mst_row.attribute14 := RTRIM(p_item_rec.attribute14);
815: x_ic_item_mst_row.attribute15 := RTRIM(p_item_rec.attribute15);
816: x_ic_item_mst_row.attribute16 := RTRIM(p_item_rec.attribute16);
817: x_ic_item_mst_row.attribute17 := RTRIM(p_item_rec.attribute17);
818: x_ic_item_mst_row.attribute18 := RTRIM(p_item_rec.attribute18);
819: x_ic_item_mst_row.attribute19 := RTRIM(p_item_rec.attribute19);

Line 816: x_ic_item_mst_row.attribute16 := RTRIM(p_item_rec.attribute16);

812: x_ic_item_mst_row.attribute12 := RTRIM(p_item_rec.attribute12);
813: x_ic_item_mst_row.attribute13 := RTRIM(p_item_rec.attribute13);
814: x_ic_item_mst_row.attribute14 := RTRIM(p_item_rec.attribute14);
815: x_ic_item_mst_row.attribute15 := RTRIM(p_item_rec.attribute15);
816: x_ic_item_mst_row.attribute16 := RTRIM(p_item_rec.attribute16);
817: x_ic_item_mst_row.attribute17 := RTRIM(p_item_rec.attribute17);
818: x_ic_item_mst_row.attribute18 := RTRIM(p_item_rec.attribute18);
819: x_ic_item_mst_row.attribute19 := RTRIM(p_item_rec.attribute19);
820: x_ic_item_mst_row.attribute20 := RTRIM(p_item_rec.attribute20);

Line 817: x_ic_item_mst_row.attribute17 := RTRIM(p_item_rec.attribute17);

813: x_ic_item_mst_row.attribute13 := RTRIM(p_item_rec.attribute13);
814: x_ic_item_mst_row.attribute14 := RTRIM(p_item_rec.attribute14);
815: x_ic_item_mst_row.attribute15 := RTRIM(p_item_rec.attribute15);
816: x_ic_item_mst_row.attribute16 := RTRIM(p_item_rec.attribute16);
817: x_ic_item_mst_row.attribute17 := RTRIM(p_item_rec.attribute17);
818: x_ic_item_mst_row.attribute18 := RTRIM(p_item_rec.attribute18);
819: x_ic_item_mst_row.attribute19 := RTRIM(p_item_rec.attribute19);
820: x_ic_item_mst_row.attribute20 := RTRIM(p_item_rec.attribute20);
821: x_ic_item_mst_row.attribute21 := RTRIM(p_item_rec.attribute21);

Line 818: x_ic_item_mst_row.attribute18 := RTRIM(p_item_rec.attribute18);

814: x_ic_item_mst_row.attribute14 := RTRIM(p_item_rec.attribute14);
815: x_ic_item_mst_row.attribute15 := RTRIM(p_item_rec.attribute15);
816: x_ic_item_mst_row.attribute16 := RTRIM(p_item_rec.attribute16);
817: x_ic_item_mst_row.attribute17 := RTRIM(p_item_rec.attribute17);
818: x_ic_item_mst_row.attribute18 := RTRIM(p_item_rec.attribute18);
819: x_ic_item_mst_row.attribute19 := RTRIM(p_item_rec.attribute19);
820: x_ic_item_mst_row.attribute20 := RTRIM(p_item_rec.attribute20);
821: x_ic_item_mst_row.attribute21 := RTRIM(p_item_rec.attribute21);
822: x_ic_item_mst_row.attribute22 := RTRIM(p_item_rec.attribute22);

Line 819: x_ic_item_mst_row.attribute19 := RTRIM(p_item_rec.attribute19);

815: x_ic_item_mst_row.attribute15 := RTRIM(p_item_rec.attribute15);
816: x_ic_item_mst_row.attribute16 := RTRIM(p_item_rec.attribute16);
817: x_ic_item_mst_row.attribute17 := RTRIM(p_item_rec.attribute17);
818: x_ic_item_mst_row.attribute18 := RTRIM(p_item_rec.attribute18);
819: x_ic_item_mst_row.attribute19 := RTRIM(p_item_rec.attribute19);
820: x_ic_item_mst_row.attribute20 := RTRIM(p_item_rec.attribute20);
821: x_ic_item_mst_row.attribute21 := RTRIM(p_item_rec.attribute21);
822: x_ic_item_mst_row.attribute22 := RTRIM(p_item_rec.attribute22);
823: x_ic_item_mst_row.attribute23 := RTRIM(p_item_rec.attribute23);

Line 820: x_ic_item_mst_row.attribute20 := RTRIM(p_item_rec.attribute20);

816: x_ic_item_mst_row.attribute16 := RTRIM(p_item_rec.attribute16);
817: x_ic_item_mst_row.attribute17 := RTRIM(p_item_rec.attribute17);
818: x_ic_item_mst_row.attribute18 := RTRIM(p_item_rec.attribute18);
819: x_ic_item_mst_row.attribute19 := RTRIM(p_item_rec.attribute19);
820: x_ic_item_mst_row.attribute20 := RTRIM(p_item_rec.attribute20);
821: x_ic_item_mst_row.attribute21 := RTRIM(p_item_rec.attribute21);
822: x_ic_item_mst_row.attribute22 := RTRIM(p_item_rec.attribute22);
823: x_ic_item_mst_row.attribute23 := RTRIM(p_item_rec.attribute23);
824: x_ic_item_mst_row.attribute24 := RTRIM(p_item_rec.attribute24);

Line 821: x_ic_item_mst_row.attribute21 := RTRIM(p_item_rec.attribute21);

817: x_ic_item_mst_row.attribute17 := RTRIM(p_item_rec.attribute17);
818: x_ic_item_mst_row.attribute18 := RTRIM(p_item_rec.attribute18);
819: x_ic_item_mst_row.attribute19 := RTRIM(p_item_rec.attribute19);
820: x_ic_item_mst_row.attribute20 := RTRIM(p_item_rec.attribute20);
821: x_ic_item_mst_row.attribute21 := RTRIM(p_item_rec.attribute21);
822: x_ic_item_mst_row.attribute22 := RTRIM(p_item_rec.attribute22);
823: x_ic_item_mst_row.attribute23 := RTRIM(p_item_rec.attribute23);
824: x_ic_item_mst_row.attribute24 := RTRIM(p_item_rec.attribute24);
825: x_ic_item_mst_row.attribute25 := RTRIM(p_item_rec.attribute25);

Line 822: x_ic_item_mst_row.attribute22 := RTRIM(p_item_rec.attribute22);

818: x_ic_item_mst_row.attribute18 := RTRIM(p_item_rec.attribute18);
819: x_ic_item_mst_row.attribute19 := RTRIM(p_item_rec.attribute19);
820: x_ic_item_mst_row.attribute20 := RTRIM(p_item_rec.attribute20);
821: x_ic_item_mst_row.attribute21 := RTRIM(p_item_rec.attribute21);
822: x_ic_item_mst_row.attribute22 := RTRIM(p_item_rec.attribute22);
823: x_ic_item_mst_row.attribute23 := RTRIM(p_item_rec.attribute23);
824: x_ic_item_mst_row.attribute24 := RTRIM(p_item_rec.attribute24);
825: x_ic_item_mst_row.attribute25 := RTRIM(p_item_rec.attribute25);
826: x_ic_item_mst_row.attribute26 := RTRIM(p_item_rec.attribute26);

Line 823: x_ic_item_mst_row.attribute23 := RTRIM(p_item_rec.attribute23);

819: x_ic_item_mst_row.attribute19 := RTRIM(p_item_rec.attribute19);
820: x_ic_item_mst_row.attribute20 := RTRIM(p_item_rec.attribute20);
821: x_ic_item_mst_row.attribute21 := RTRIM(p_item_rec.attribute21);
822: x_ic_item_mst_row.attribute22 := RTRIM(p_item_rec.attribute22);
823: x_ic_item_mst_row.attribute23 := RTRIM(p_item_rec.attribute23);
824: x_ic_item_mst_row.attribute24 := RTRIM(p_item_rec.attribute24);
825: x_ic_item_mst_row.attribute25 := RTRIM(p_item_rec.attribute25);
826: x_ic_item_mst_row.attribute26 := RTRIM(p_item_rec.attribute26);
827: x_ic_item_mst_row.attribute27 := RTRIM(p_item_rec.attribute27);

Line 824: x_ic_item_mst_row.attribute24 := RTRIM(p_item_rec.attribute24);

820: x_ic_item_mst_row.attribute20 := RTRIM(p_item_rec.attribute20);
821: x_ic_item_mst_row.attribute21 := RTRIM(p_item_rec.attribute21);
822: x_ic_item_mst_row.attribute22 := RTRIM(p_item_rec.attribute22);
823: x_ic_item_mst_row.attribute23 := RTRIM(p_item_rec.attribute23);
824: x_ic_item_mst_row.attribute24 := RTRIM(p_item_rec.attribute24);
825: x_ic_item_mst_row.attribute25 := RTRIM(p_item_rec.attribute25);
826: x_ic_item_mst_row.attribute26 := RTRIM(p_item_rec.attribute26);
827: x_ic_item_mst_row.attribute27 := RTRIM(p_item_rec.attribute27);
828: x_ic_item_mst_row.attribute28 := RTRIM(p_item_rec.attribute28);

Line 825: x_ic_item_mst_row.attribute25 := RTRIM(p_item_rec.attribute25);

821: x_ic_item_mst_row.attribute21 := RTRIM(p_item_rec.attribute21);
822: x_ic_item_mst_row.attribute22 := RTRIM(p_item_rec.attribute22);
823: x_ic_item_mst_row.attribute23 := RTRIM(p_item_rec.attribute23);
824: x_ic_item_mst_row.attribute24 := RTRIM(p_item_rec.attribute24);
825: x_ic_item_mst_row.attribute25 := RTRIM(p_item_rec.attribute25);
826: x_ic_item_mst_row.attribute26 := RTRIM(p_item_rec.attribute26);
827: x_ic_item_mst_row.attribute27 := RTRIM(p_item_rec.attribute27);
828: x_ic_item_mst_row.attribute28 := RTRIM(p_item_rec.attribute28);
829: x_ic_item_mst_row.attribute29 := RTRIM(p_item_rec.attribute29);

Line 826: x_ic_item_mst_row.attribute26 := RTRIM(p_item_rec.attribute26);

822: x_ic_item_mst_row.attribute22 := RTRIM(p_item_rec.attribute22);
823: x_ic_item_mst_row.attribute23 := RTRIM(p_item_rec.attribute23);
824: x_ic_item_mst_row.attribute24 := RTRIM(p_item_rec.attribute24);
825: x_ic_item_mst_row.attribute25 := RTRIM(p_item_rec.attribute25);
826: x_ic_item_mst_row.attribute26 := RTRIM(p_item_rec.attribute26);
827: x_ic_item_mst_row.attribute27 := RTRIM(p_item_rec.attribute27);
828: x_ic_item_mst_row.attribute28 := RTRIM(p_item_rec.attribute28);
829: x_ic_item_mst_row.attribute29 := RTRIM(p_item_rec.attribute29);
830: x_ic_item_mst_row.attribute30 := RTRIM(p_item_rec.attribute30);

Line 827: x_ic_item_mst_row.attribute27 := RTRIM(p_item_rec.attribute27);

823: x_ic_item_mst_row.attribute23 := RTRIM(p_item_rec.attribute23);
824: x_ic_item_mst_row.attribute24 := RTRIM(p_item_rec.attribute24);
825: x_ic_item_mst_row.attribute25 := RTRIM(p_item_rec.attribute25);
826: x_ic_item_mst_row.attribute26 := RTRIM(p_item_rec.attribute26);
827: x_ic_item_mst_row.attribute27 := RTRIM(p_item_rec.attribute27);
828: x_ic_item_mst_row.attribute28 := RTRIM(p_item_rec.attribute28);
829: x_ic_item_mst_row.attribute29 := RTRIM(p_item_rec.attribute29);
830: x_ic_item_mst_row.attribute30 := RTRIM(p_item_rec.attribute30);
831: x_ic_item_mst_row.attribute_category := RTRIM(p_item_rec.attribute_category);

Line 828: x_ic_item_mst_row.attribute28 := RTRIM(p_item_rec.attribute28);

824: x_ic_item_mst_row.attribute24 := RTRIM(p_item_rec.attribute24);
825: x_ic_item_mst_row.attribute25 := RTRIM(p_item_rec.attribute25);
826: x_ic_item_mst_row.attribute26 := RTRIM(p_item_rec.attribute26);
827: x_ic_item_mst_row.attribute27 := RTRIM(p_item_rec.attribute27);
828: x_ic_item_mst_row.attribute28 := RTRIM(p_item_rec.attribute28);
829: x_ic_item_mst_row.attribute29 := RTRIM(p_item_rec.attribute29);
830: x_ic_item_mst_row.attribute30 := RTRIM(p_item_rec.attribute30);
831: x_ic_item_mst_row.attribute_category := RTRIM(p_item_rec.attribute_category);
832: --END BUG#2461984

Line 829: x_ic_item_mst_row.attribute29 := RTRIM(p_item_rec.attribute29);

825: x_ic_item_mst_row.attribute25 := RTRIM(p_item_rec.attribute25);
826: x_ic_item_mst_row.attribute26 := RTRIM(p_item_rec.attribute26);
827: x_ic_item_mst_row.attribute27 := RTRIM(p_item_rec.attribute27);
828: x_ic_item_mst_row.attribute28 := RTRIM(p_item_rec.attribute28);
829: x_ic_item_mst_row.attribute29 := RTRIM(p_item_rec.attribute29);
830: x_ic_item_mst_row.attribute30 := RTRIM(p_item_rec.attribute30);
831: x_ic_item_mst_row.attribute_category := RTRIM(p_item_rec.attribute_category);
832: --END BUG#2461984
833: -- 21/Feb/2002 P Lowe Bug 2233859 - Field ont_pricing_qty_source

Line 830: x_ic_item_mst_row.attribute30 := RTRIM(p_item_rec.attribute30);

826: x_ic_item_mst_row.attribute26 := RTRIM(p_item_rec.attribute26);
827: x_ic_item_mst_row.attribute27 := RTRIM(p_item_rec.attribute27);
828: x_ic_item_mst_row.attribute28 := RTRIM(p_item_rec.attribute28);
829: x_ic_item_mst_row.attribute29 := RTRIM(p_item_rec.attribute29);
830: x_ic_item_mst_row.attribute30 := RTRIM(p_item_rec.attribute30);
831: x_ic_item_mst_row.attribute_category := RTRIM(p_item_rec.attribute_category);
832: --END BUG#2461984
833: -- 21/Feb/2002 P Lowe Bug 2233859 - Field ont_pricing_qty_source
834:

Line 831: x_ic_item_mst_row.attribute_category := RTRIM(p_item_rec.attribute_category);

827: x_ic_item_mst_row.attribute27 := RTRIM(p_item_rec.attribute27);
828: x_ic_item_mst_row.attribute28 := RTRIM(p_item_rec.attribute28);
829: x_ic_item_mst_row.attribute29 := RTRIM(p_item_rec.attribute29);
830: x_ic_item_mst_row.attribute30 := RTRIM(p_item_rec.attribute30);
831: x_ic_item_mst_row.attribute_category := RTRIM(p_item_rec.attribute_category);
832: --END BUG#2461984
833: -- 21/Feb/2002 P Lowe Bug 2233859 - Field ont_pricing_qty_source
834:
835:

Line 838: x_ic_item_mst_row.ont_pricing_qty_source := NVL(p_item_rec.ont_pricing_qty_source,0);

834:
835:
836: IF p_item_rec.ont_pricing_qty_source BETWEEN 0 AND 1
837: THEN
838: x_ic_item_mst_row.ont_pricing_qty_source := NVL(p_item_rec.ont_pricing_qty_source,0);
839: ELSE
840: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ONT_SOURCE');
841: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);
842: FND_MSG_PUB.Add;

Line 846: and x_ic_item_mst_row.dualum_ind < 1 )

842: FND_MSG_PUB.Add;
843: END IF;
844:
845: IF (p_item_rec.ont_pricing_qty_source > 0
846: and x_ic_item_mst_row.dualum_ind < 1 )
847: or (p_item_rec.ont_pricing_qty_source > 0
848: and UPPER(NVL(FND_PROFILE.VALUE('GML_OM_INTEGRATION'),'N')) = 'N' )
849:
850: THEN

Line 856: x_ic_item_mst_row.ont_pricing_qty_source := NVL(p_item_rec.ont_pricing_qty_source,0);

852: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);
853: FND_MSG_PUB.Add;
854: END IF;
855:
856: x_ic_item_mst_row.ont_pricing_qty_source := NVL(p_item_rec.ont_pricing_qty_source,0);
857:
858: /* Jalaj Srivastava Bug 3158806
859: Replace check for CPG_INSTALL with lot control */
860: IF p_item_rec.lot_ctl = 1

Line 876: Populate dummy column level code in ic_item_mst with hold days. */

872: x_ic_item_cpg_row.ic_hold_days := p_item_rec.ic_hold_days;
873: /* Jalaj Srivastava Bug 3158806
874: Removed nvl above so that hold days in cpg table go as null if user did not sepcify
875: hold days.
876: Populate dummy column level code in ic_item_mst with hold days. */
877: x_ic_item_mst_row.level_code := x_ic_item_cpg_row.ic_hold_days;
878:
879: IF x_ic_item_cpg_row.ic_matr_days < 0
880: THEN

Line 877: x_ic_item_mst_row.level_code := x_ic_item_cpg_row.ic_hold_days;

873: /* Jalaj Srivastava Bug 3158806
874: Removed nvl above so that hold days in cpg table go as null if user did not sepcify
875: hold days.
876: Populate dummy column level code in ic_item_mst with hold days. */
877: x_ic_item_mst_row.level_code := x_ic_item_cpg_row.ic_hold_days;
878:
879: IF x_ic_item_cpg_row.ic_matr_days < 0
880: THEN
881: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_HOLD_DAYS');