DBA Data[Home] [Help]

APPS.GMIVLOT dependencies on GMIGUTL

Line 122: IF NOT FND_API.Compatible_API_CALL ( GMIGUTL.API_VERSION

118: l_def_lot_desc NUMBER; /* Bug 2343411 */
119:
120: BEGIN
121: /* Standard call to check for call compatibility. */
122: IF NOT FND_API.Compatible_API_CALL ( GMIGUTL.API_VERSION
123: , p_api_version
124: , l_api_name
125: , G_PKG_NAME
126: )

Line 162: x_ic_lots_mst_row.created_by := GMIGUTL.DEFAULT_USER_ID;

158: x_ic_lots_mst_row.creation_date := SYSDATE;
159: x_ic_lots_mst_row.last_update_date := SYSDATE;
160: --END BUG#3270249
161:
162: x_ic_lots_mst_row.created_by := GMIGUTL.DEFAULT_USER_ID;
163: x_ic_lots_mst_row.last_updated_by := GMIGUTL.DEFAULT_USER_ID;
164: x_ic_lots_mst_row.last_update_login:= GMIGUTL.DEFAULT_LOGIN;
165:
166: -- Jatinder B3158806 - Removed check for SY$CPG_INSTALL

Line 163: x_ic_lots_mst_row.last_updated_by := GMIGUTL.DEFAULT_USER_ID;

159: x_ic_lots_mst_row.last_update_date := SYSDATE;
160: --END BUG#3270249
161:
162: x_ic_lots_mst_row.created_by := GMIGUTL.DEFAULT_USER_ID;
163: x_ic_lots_mst_row.last_updated_by := GMIGUTL.DEFAULT_USER_ID;
164: x_ic_lots_mst_row.last_update_login:= GMIGUTL.DEFAULT_LOGIN;
165:
166: -- Jatinder B3158806 - Removed check for SY$CPG_INSTALL
167: /* Set up values for ic_lots_cpg. */

Line 164: x_ic_lots_mst_row.last_update_login:= GMIGUTL.DEFAULT_LOGIN;

160: --END BUG#3270249
161:
162: x_ic_lots_mst_row.created_by := GMIGUTL.DEFAULT_USER_ID;
163: x_ic_lots_mst_row.last_updated_by := GMIGUTL.DEFAULT_USER_ID;
164: x_ic_lots_mst_row.last_update_login:= GMIGUTL.DEFAULT_LOGIN;
165:
166: -- Jatinder B3158806 - Removed check for SY$CPG_INSTALL
167: /* Set up values for ic_lots_cpg. */
168: x_ic_lots_cpg_row.item_id := p_ic_item_mst_row.item_id;

Line 170: x_ic_lots_cpg_row.created_by := GMIGUTL.DEFAULT_USER_ID;

166: -- Jatinder B3158806 - Removed check for SY$CPG_INSTALL
167: /* Set up values for ic_lots_cpg. */
168: x_ic_lots_cpg_row.item_id := p_ic_item_mst_row.item_id;
169: x_ic_lots_cpg_row.lot_id := NULL;
170: x_ic_lots_cpg_row.created_by := GMIGUTL.DEFAULT_USER_ID;
171: x_ic_lots_cpg_row.last_updated_by := GMIGUTL.DEFAULT_USER_ID;
172: x_ic_lots_cpg_row.creation_date:= x_ic_lots_mst_row.creation_date;
173: x_ic_lots_cpg_row.last_update_date := x_ic_lots_mst_row.last_update_date;
174: x_ic_lots_cpg_row.last_update_login:= GMIGUTL.DEFAULT_LOGIN;

Line 171: x_ic_lots_cpg_row.last_updated_by := GMIGUTL.DEFAULT_USER_ID;

167: /* Set up values for ic_lots_cpg. */
168: x_ic_lots_cpg_row.item_id := p_ic_item_mst_row.item_id;
169: x_ic_lots_cpg_row.lot_id := NULL;
170: x_ic_lots_cpg_row.created_by := GMIGUTL.DEFAULT_USER_ID;
171: x_ic_lots_cpg_row.last_updated_by := GMIGUTL.DEFAULT_USER_ID;
172: x_ic_lots_cpg_row.creation_date:= x_ic_lots_mst_row.creation_date;
173: x_ic_lots_cpg_row.last_update_date := x_ic_lots_mst_row.last_update_date;
174: x_ic_lots_cpg_row.last_update_login:= GMIGUTL.DEFAULT_LOGIN;
175:

Line 174: x_ic_lots_cpg_row.last_update_login:= GMIGUTL.DEFAULT_LOGIN;

170: x_ic_lots_cpg_row.created_by := GMIGUTL.DEFAULT_USER_ID;
171: x_ic_lots_cpg_row.last_updated_by := GMIGUTL.DEFAULT_USER_ID;
172: x_ic_lots_cpg_row.creation_date:= x_ic_lots_mst_row.creation_date;
173: x_ic_lots_cpg_row.last_update_date := x_ic_lots_mst_row.last_update_date;
174: x_ic_lots_cpg_row.last_update_login:= GMIGUTL.DEFAULT_LOGIN;
175:
176: /* Bug 2343411 - User defined lot description */
177: /* Based on the value of the profile option, populate the lot_desc */
178:

Line 180: l_def_lot_desc := GMIGUTL.IC$DEFAULT_LOT_DESC;

176: /* Bug 2343411 - User defined lot description */
177: /* Based on the value of the profile option, populate the lot_desc */
178:
179: /* First, lets get the value of the profile option */
180: l_def_lot_desc := GMIGUTL.IC$DEFAULT_LOT_DESC;
181:
182: /* Only set up the default lot desc if the user does not pass one in */
183: IF p_lot_rec.lot_desc IS NULL
184: THEN

Line 260: AND p_lot_rec.lot_no = GMIGUTL.IC$DEFAULT_LOT

256: x_ic_lots_mst_row.attribute30 := UPPER(p_lot_rec.attribute30);
257: x_ic_lots_mst_row.attribute_category := UPPER(p_lot_rec.attribute_category);
258:
259: IF p_validation_level = FND_API.G_VALID_LEVEL_NONE
260: AND p_lot_rec.lot_no = GMIGUTL.IC$DEFAULT_LOT
261: THEN
262: /* We are creating the default lot for a new item. */
263: x_ic_lots_mst_row.lot_no := GMIGUTL.IC$DEFAULT_LOT;
264: x_ic_lots_mst_row.lot_id := 0;

Line 263: x_ic_lots_mst_row.lot_no := GMIGUTL.IC$DEFAULT_LOT;

259: IF p_validation_level = FND_API.G_VALID_LEVEL_NONE
260: AND p_lot_rec.lot_no = GMIGUTL.IC$DEFAULT_LOT
261: THEN
262: /* We are creating the default lot for a new item. */
263: x_ic_lots_mst_row.lot_no := GMIGUTL.IC$DEFAULT_LOT;
264: x_ic_lots_mst_row.lot_id := 0;
265: x_ic_lots_mst_row.qc_grade := UPPER(p_ic_item_mst_row.qc_grade);
266: x_ic_lots_mst_row.lot_created := p_ic_item_mst_row.creation_date;
267: -- Bug 2458413 - Need to set up default dates to avoid having them

Line 288: GMIGUTL.IC$API_ALLOW_INACTIVE = 0

284: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_ic_item_mst_row.item_no);
285: FND_MSG_PUB.Add;
286: RAISE FND_API.G_EXC_ERROR;
287: ELSIF p_ic_item_mst_row.inactive_ind = 1 AND
288: GMIGUTL.IC$API_ALLOW_INACTIVE = 0
289: THEN
290: FND_MESSAGE.SET_NAME('GMI','IC_API_INACTIVE_ITEM_NO');
291: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_ic_item_mst_row.item_no);
292: FND_MSG_PUB.Add;

Line 346: IF GMIGUTL.v_qc_grade(UPPER(p_lot_rec.qc_grade),l_qc_grad_mst_row)

342: IF NVL(p_lot_rec.qc_grade, p_ic_item_mst_row.qc_grade) = p_ic_item_mst_row.qc_grade
343: THEN
344: x_ic_lots_mst_row.qc_grade := p_ic_item_mst_row.qc_grade;
345: ELSE
346: IF GMIGUTL.v_qc_grade(UPPER(p_lot_rec.qc_grade),l_qc_grad_mst_row)
347: THEN
348: x_ic_lots_mst_row.qc_grade := l_qc_grad_mst_row.qc_grade;
349: ELSE
350: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_QC_GRADE');

Line 365: IF GMIGUTL.v_expaction_code

361: IF p_lot_rec.expaction_code IS NULL
362: THEN
363: x_ic_lots_mst_row.expaction_code := p_ic_item_mst_row.expaction_code;
364: ELSE
365: IF GMIGUTL.v_expaction_code
366: (UPPER(p_lot_rec.expaction_code), l_qc_actn_mst_row)
367: THEN
368: x_ic_lots_mst_row.expaction_code:=l_qc_actn_mst_row.action_code;
369: ELSE

Line 519: IF GMIGUTL.v_ship_vendor(p_lot_rec.shipvendor_no,l_po_vend_mst_row)

515: IF NVL(p_lot_rec.shipvendor_no, ' ') = ' '
516: THEN
517: x_ic_lots_mst_row.shipvend_id := NULL;
518: ELSE
519: IF GMIGUTL.v_ship_vendor(p_lot_rec.shipvendor_no,l_po_vend_mst_row)
520: THEN
521: x_ic_lots_mst_row.shipvend_id:= l_po_vend_mst_row.vendor_id;
522: ELSE
523: FND_MESSAGE.SET_NAME('GMI','IC_API_INV_LOT_SHIPVENDOR_NO');

Line 541: IF p_ic_item_cpg_row.ic_hold_days is not NULL and GMIGUTL.SY$CPG_INSTALL <> 0 THEN

537: THEN
538: /* Jalaj Srivastava Bug 3158806
539: hold release date would be populated by the first yielding transaction
540: for non CPG installs */
541: IF p_ic_item_cpg_row.ic_hold_days is not NULL and GMIGUTL.SY$CPG_INSTALL <> 0 THEN
542: x_ic_lots_cpg_row.ic_hold_date :=
543: x_ic_lots_mst_row.lot_created +
544: p_ic_item_cpg_row.ic_hold_days;
545: END IF;

Line 559: IF GMIGUTL.SY$CPG_INSTALL <> 0

555: Assign hold release date when passed by the user*/
556: x_ic_lots_cpg_row.ic_hold_date := p_lot_rec.ic_hold_date;
557: END IF;
558:
559: IF GMIGUTL.SY$CPG_INSTALL <> 0
560: THEN
561: /* Validate Maturity date (CPG) */
562: IF NVL(p_lot_rec.ic_matr_date, FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE
563: THEN