DBA Data[Home] [Help]

APPS.GMI_CMP_TRAN_PVT dependencies on FND_API

Line 83: RAISE FND_API.G_EXC_ERROR;

79: THEN
80: FND_MESSAGE.SET_NAME('GMI','IC_API_UNABLE_TO_GET_SURROGATE');
81: FND_MESSAGE.SET_TOKEN('SKEY','trans_id');
82: FND_MSG_PUB.Add;
83: RAISE FND_API.G_EXC_ERROR;
84: END IF;
85: END IF;
86:
87: -- Perform update according to type of transaction

Line 94: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

90: l_cmp_tran_rec.doc_type = 'TRNI')
91: THEN
92: IF NOT Update_movement(l_cmp_tran_rec)
93: THEN
94: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
95: END IF;
96: ELSIF (l_cmp_tran_rec.doc_type = 'STSI')
97: THEN
98: IF NOT Update_lot_status(l_cmp_tran_rec)

Line 100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

96: ELSIF (l_cmp_tran_rec.doc_type = 'STSI')
97: THEN
98: IF NOT Update_lot_status(l_cmp_tran_rec)
99: THEN
100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
101: END IF;
102: ELSIF (l_cmp_tran_rec.doc_type = 'GRDI')
103: THEN
104: IF NOT Update_QC_grade(l_cmp_tran_rec)

Line 106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

102: ELSIF (l_cmp_tran_rec.doc_type = 'GRDI')
103: THEN
104: IF NOT Update_QC_grade(l_cmp_tran_rec)
105: THEN
106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
107: END IF;
108: END IF;
109:
110: RETURN TRUE;

Line 114: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

110: RETURN TRUE;
111:
112: EXCEPTION
113:
114: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
115: RETURN FALSE;
116:
117: WHEN OTHERS THEN
118: -- IF FND_MSG_PUB.check_msg_level

Line 168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

164:
165: -- insert row in ic_tran_cmp
166: IF NOT insert_ic_tran_cmp(l_cmp_tran_rec)
167: THEN
168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
169: END IF;
170:
171: -- Update location inventory
172: IF NOT Update_ic_loct_inv(l_cmp_tran_rec)

Line 174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

170:
171: -- Update location inventory
172: IF NOT Update_ic_loct_inv(l_cmp_tran_rec)
173: THEN
174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
175: END IF;
176:
177: -- Update inventory summary
178: IF NOT Update_ic_summ_inv(l_cmp_tran_rec)

Line 180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

176:
177: -- Update inventory summary
178: IF NOT Update_ic_summ_inv(l_cmp_tran_rec)
179: THEN
180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
181: END IF;
182:
183: RETURN TRUE;
184:

Line 187: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

183: RETURN TRUE;
184:
185: EXCEPTION
186:
187: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
188: RETURN FALSE;
189:
190: WHEN OTHERS THEN
191: -- IF FND_MSG_PUB.check_msg_level

Line 239: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

235:
236: -- insert row in ic_tran_cmp
237: IF NOT insert_ic_tran_cmp(l_cmp_tran_rec)
238: THEN
239: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
240: END IF;
241:
242: -- Update location inventory
243: IF NOT Update_ic_loct_inv_LOT_STATUS(l_cmp_tran_rec)

Line 245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

241:
242: -- Update location inventory
243: IF NOT Update_ic_loct_inv_LOT_STATUS(l_cmp_tran_rec)
244: THEN
245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
246: END IF;
247:
248: RETURN TRUE;
249:

Line 252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

248: RETURN TRUE;
249:
250: EXCEPTION
251:
252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
253: RETURN FALSE;
254:
255: WHEN OTHERS THEN
256: -- IF FND_MSG_PUB.check_msg_level

Line 305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

301:
302: -- insert row in ic_tran_cmp
303: IF NOT insert_ic_tran_cmp(l_cmp_tran_rec)
304: THEN
305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
306: END IF;
307:
308: -- Update lots Master for new QC grade
309: IF (p_cmp_tran_rec.line_type = 1)

Line 324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

320:
321: -- Update summary inventory
322: IF NOT Update_ic_summ_inv_QC_GRADE(l_cmp_tran_rec)
323: THEN
324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
325: END IF;
326:
327: RETURN TRUE;
328:

Line 331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

327: RETURN TRUE;
328:
329: EXCEPTION
330:
331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
332: RETURN FALSE;
333:
334: WHEN OTHERS THEN
335: -- IF FND_MSG_PUB.check_msg_level

Line 510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

506: THEN
507: -- Insert location inventory
508: IF NOT Insert_Ic_Loct_Inv(p_cmp_tran_rec)
509: THEN
510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
511: END IF;
512: END IF;
513:
514: CLOSE location_inv;

Line 548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

544: RETURN TRUE;
545:
546: EXCEPTION
547:
548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
549: RETURN FALSE;
550:
551: WHEN OTHERS THEN
552: -- IF FND_MSG_PUB.check_msg_level

Line 757: RAISE FND_API.G_EXC_ERROR;

753: THEN
754: FND_MESSAGE.SET_NAME('GMI','IC_API_UNABLE_TO_GET_SURROGATE');
755: FND_MESSAGE.SET_TOKEN('SKEY','summ_inv_id');
756: FND_MSG_PUB.Add;
757: RAISE FND_API.G_EXC_ERROR;
758: ELSE
759: INSERT INTO ic_summ_inv
760: ( summ_inv_id
761: , item_id

Line 851: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

847: RETURN TRUE;
848:
849: EXCEPTION
850:
851: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
852: RETURN FALSE;
853:
854: WHEN OTHERS THEN
855: -- IF FND_MSG_PUB.check_msg_level

Line 930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

926: THEN
927: -- Insert location inventory
928: IF NOT Insert_Ic_Loct_Inv(p_cmp_tran_rec)
929: THEN
930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
931: END IF;
932: END IF;
933:
934: CLOSE location_inv;

Line 960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

956:
957: -- Update inventory summary
958: IF NOT Update_ic_summ_inv(l_cmp_tran_rec)
959: THEN
960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
961: END IF;
962:
963: RETURN TRUE;
964:

Line 967: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

963: RETURN TRUE;
964:
965: EXCEPTION
966:
967: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
968: RETURN FALSE;
969:
970: WHEN OTHERS THEN
971: -- IF FND_MSG_PUB.check_msg_level

Line 1065: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

1061: -- Update inventory summary
1062: IF NOT Update_ic_summ_inv(l_cmp_tran_rec)
1063: THEN
1064: CLOSE location_inv;
1065: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1066: END IF;
1067:
1068: END LOOP;
1069:

Line 1076: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1072: RETURN TRUE;
1073:
1074: EXCEPTION
1075:
1076: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1077: RETURN FALSE;
1078:
1079: WHEN OTHERS THEN
1080: -- IF FND_MSG_PUB.check_msg_level