DBA Data[Home] [Help]

APPS.GMIVITM dependencies on GMIGUTL

Line 383: (GMIGUTL.API_VERSION, p_api_version, 'Validate_Item', G_PKG_NAME)

379: BEGIN
380:
381: /* Standard call to check for call compatibility. */
382: IF NOT FND_API.Compatible_API_CALL
383: (GMIGUTL.API_VERSION, p_api_version, 'Validate_Item', G_PKG_NAME)
384: THEN
385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
386: END IF;
387:

Line 410: GMIGUTL.get_um(RTRIM(p_item_rec.item_um), l_sy_uoms_mst_row, l_sy_uoms_typ_row);

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

Line 446: GMIGUTL.get_um(RTRIM(p_item_rec.item_um2), l_sy_uoms_mst_row, l_sy_uoms_typ_row);

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
448: THEN
449: -- BUG#2461984 VAK
450: x_ic_item_mst_row.item_um2 := RTRIM(l_sy_uoms_mst_row.um_code);

Line 579: IF GMIGUTL.v_qc_grade(UPPER(RTRIM(p_item_rec.qc_grade)), l_qc_grad_mst_row)

575: THEN
576: IF NVL(p_item_rec.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;

Line 612: IF GMIGUTL.v_expaction_code(UPPER(RTRIM(p_item_rec.expaction_code)),l_qc_actn_mst_row)

608:
609: IF NVL(p_item_rec.expaction_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;

Line 652: IF GMIGUTL.v_lot_status(UPPER(p_item_rec.lot_status), l_ic_lots_sts_row)

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)
653: THEN
654: x_ic_item_mst_row.lot_status := l_ic_lots_sts_row.lot_status;
655: END IF;
656: END IF;

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 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 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 903: x_ic_item_cpg_row.created_by := GMIGUTL.DEFAULT_USER_ID;

899: IF p_item_rec.lot_ctl = 1
900: THEN
901: x_ic_item_cpg_row.creation_date := SYSDATE;
902: x_ic_item_cpg_row.last_update_date := SYSDATE;
903: x_ic_item_cpg_row.created_by := GMIGUTL.DEFAULT_USER_ID;
904: x_ic_item_cpg_row.last_updated_by := GMIGUTL.DEFAULT_USER_ID;
905: x_ic_item_cpg_row.last_update_login := GMIGUTL.DEFAULT_LOGIN;
906: END IF;
907:

Line 904: x_ic_item_cpg_row.last_updated_by := GMIGUTL.DEFAULT_USER_ID;

900: THEN
901: x_ic_item_cpg_row.creation_date := SYSDATE;
902: x_ic_item_cpg_row.last_update_date := SYSDATE;
903: x_ic_item_cpg_row.created_by := GMIGUTL.DEFAULT_USER_ID;
904: x_ic_item_cpg_row.last_updated_by := GMIGUTL.DEFAULT_USER_ID;
905: x_ic_item_cpg_row.last_update_login := GMIGUTL.DEFAULT_LOGIN;
906: END IF;
907:
908: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 905: x_ic_item_cpg_row.last_update_login := GMIGUTL.DEFAULT_LOGIN;

901: x_ic_item_cpg_row.creation_date := SYSDATE;
902: x_ic_item_cpg_row.last_update_date := SYSDATE;
903: x_ic_item_cpg_row.created_by := GMIGUTL.DEFAULT_USER_ID;
904: x_ic_item_cpg_row.last_updated_by := GMIGUTL.DEFAULT_USER_ID;
905: x_ic_item_cpg_row.last_update_login := GMIGUTL.DEFAULT_LOGIN;
906: END IF;
907:
908: x_return_status := FND_API.G_RET_STS_SUCCESS;
909: