DBA Data[Home] [Help]

APPS.GMIGAPI dependencies on FND_MSG_PUB

Line 74: FND_MSG_PUB.Initialize;

70:
71: /* Initialize message list if p_int_msg_list is set TRUE. */
72: IF FND_API.to_boolean(p_init_msg_list)
73: THEN
74: FND_MSG_PUB.Initialize;
75: END IF;
76:
77: x_return_status :=FND_API.G_RET_STS_SUCCESS;
78:

Line 142: FND_MSG_PUB.Add;

138: IF x_return_status = FND_API.G_RET_STS_SUCCESS
139: THEN
140: FND_MESSAGE.SET_NAME('GMI','IC_API_ITEM_CREATED');
141: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_lot_rec.item_no);
142: FND_MSG_PUB.Add;
143:
144: IF FND_API.to_boolean(p_commit)
145: THEN
146: COMMIT;

Line 158: FND_MSG_PUB.Count_AND_GET

154: ELSE
155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
156: END IF;
157:
158: FND_MSG_PUB.Count_AND_GET
159: (p_count => x_msg_count, p_data => x_msg_data);
160:
161: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
162: THEN

Line 171: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);

167: WHEN OTHERS THEN
168: ROLLBACK TO Create_Item;
169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
170:
171: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
172: FND_MSG_PUB.Count_AND_GET
173: (p_count => x_msg_count, p_data => x_msg_data);
174: END Create_Item;
175:

Line 172: FND_MSG_PUB.Count_AND_GET

168: ROLLBACK TO Create_Item;
169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
170:
171: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
172: FND_MSG_PUB.Count_AND_GET
173: (p_count => x_msg_count, p_data => x_msg_data);
174: END Create_Item;
175:
176:

Line 239: FND_MSG_PUB.Initialize;

235:
236: /* Initialize message list if p_int_msg_list is set TRUE. */
237: IF FND_API.to_boolean(p_init_msg_list)
238: THEN
239: FND_MSG_PUB.Initialize;
240: END IF;
241:
242: x_return_status :=FND_API.G_RET_STS_SUCCESS;
243:

Line 277: FND_MSG_PUB.Add;

273: FND_MESSAGE.SET_NAME('GMI','IC_API_LOT_CREATED');
274: FND_MESSAGE.SET_TOKEN('ITEM_NO', p_lot_rec.item_no);
275: FND_MESSAGE.SET_TOKEN('LOT_NO', p_lot_rec.lot_no);
276: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', p_lot_rec.sublot_no);
277: FND_MSG_PUB.Add;
278:
279: IF FND_API.to_boolean(p_commit)
280: THEN
281: COMMIT WORK;

Line 292: FND_MSG_PUB.Count_AND_GET

288: ELSE
289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
290: END IF;
291:
292: FND_MSG_PUB.Count_AND_GET
293: (p_count => x_msg_count, p_data => x_msg_data);
294:
295: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
296: THEN

Line 305: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);

301: WHEN OTHERS THEN
302: ROLLBACK TO Create_Lot;
303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
304:
305: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
306: FND_MSG_PUB.Count_AND_GET
307: (p_count => x_msg_count, p_data => x_msg_data);
308: END Create_Lot;
309:

Line 306: FND_MSG_PUB.Count_AND_GET

302: ROLLBACK TO Create_Lot;
303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
304:
305: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
306: FND_MSG_PUB.Count_AND_GET
307: (p_count => x_msg_count, p_data => x_msg_data);
308: END Create_Lot;
309:
310:

Line 376: FND_MSG_PUB.Initialize;

372:
373: /* Initialize message list if p_int_msg_list is set TRUE. */
374: IF FND_API.to_boolean(p_init_msg_list)
375: THEN
376: FND_MSG_PUB.Initialize;
377: END IF;
378:
379: x_return_status :=FND_API.G_RET_STS_SUCCESS;
380:

Line 407: FND_MSG_PUB.Add;

403: FND_MESSAGE.SET_TOKEN('ITEM_NO', p_conv_rec.item_no);
404: FND_MESSAGE.SET_TOKEN('LOT_NO', p_conv_rec.lot_no);
405: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', p_conv_rec.sublot_no);
406: FND_MESSAGE.SET_TOKEN('UM_TYPE', x_ic_item_cnv_row.um_type);
407: FND_MSG_PUB.Add;
408:
409: IF FND_API.to_boolean(p_commit)
410: THEN
411: COMMIT WORK;

Line 423: FND_MSG_PUB.Add;

419: FND_MESSAGE.SET_TOKEN('ITEM_NO', p_conv_rec.item_no);
420: FND_MESSAGE.SET_TOKEN('LOT_NO', p_conv_rec.lot_no);
421: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', p_conv_rec.sublot_no);
422: FND_MESSAGE.SET_TOKEN('UM_TYPE', x_ic_item_cnv_row.um_type);
423: FND_MSG_PUB.Add;
424: ELSE
425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
426: END IF;
427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 431: FND_MSG_PUB.Count_AND_GET

427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
428: END IF;
429: END IF;
430:
431: FND_MSG_PUB.Count_AND_GET
432: (p_count => x_msg_count, p_data => x_msg_data);
433:
434: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
435: THEN

Line 444: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);

440: WHEN OTHERS THEN
441: ROLLBACK TO Create_Conv;
442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
443:
444: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
445: FND_MSG_PUB.Count_AND_GET
446: (p_count => x_msg_count, p_data => x_msg_data);
447: END Create_Item_lot_Conv;
448:

Line 445: FND_MSG_PUB.Count_AND_GET

441: ROLLBACK TO Create_Conv;
442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
443:
444: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
445: FND_MSG_PUB.Count_AND_GET
446: (p_count => x_msg_count, p_data => x_msg_data);
447: END Create_Item_lot_Conv;
448:
449:

Line 593: FND_MSG_PUB.Initialize;

589:
590: /* Initialize message list if p_int_msg_list is set TRUE. */
591: IF FND_API.to_boolean(p_init_msg_list)
592: THEN
593: FND_MSG_PUB.Initialize;
594: END IF;
595:
596: x_return_status :=FND_API.G_RET_STS_SUCCESS;
597: --Jalaj Srivastava Bug 2483656

Line 747: FND_MSG_PUB.Add;

743: CLOSE check_journal_no;
744: IF (l_record_count = 0) THEN
745: FND_MESSAGE.SET_NAME ('GMI', 'IC_API_INVALID_JOURNAL_NO');
746: FND_MESSAGE.SET_TOKEN('JOURNAL_NO',p_qty_rec.journal_no);
747: FND_MSG_PUB.Add;
748: RAISE FND_API.G_EXC_ERROR;
749: ELSE
750: x_ic_jrnl_mst_row.journal_no := l_qty_rec.journal_no;
751: END IF;

Line 767: FND_MSG_PUB.Add;

763: IF l_record_count = 0 THEN
764: x_ic_jrnl_mst_row.journal_no := l_qty_rec.journal_no;
765: ELSIF (p_qty_rec.trans_type <= 5) THEN
766: FND_MESSAGE.SET_NAME ('GMI', 'GMI_JOURNALNOEXISTS');
767: FND_MSG_PUB.Add;
768: RAISE FND_API.G_EXC_ERROR;
769: ELSIF (p_qty_rec.trans_type >=6) THEN
770: OPEN check_journal_no;
771: FETCH check_journal_no INTO l_record_count;

Line 776: FND_MSG_PUB.Add;

772: CLOSE check_journal_no;
773: IF (l_record_count = 0) THEN
774: FND_MESSAGE.SET_NAME ('GMI', 'IC_API_INVALID_JOURNAL_NO');
775: FND_MESSAGE.SET_TOKEN('JOURNAL_NO',l_qty_rec.journal_no);
776: FND_MSG_PUB.Add;
777: RAISE FND_API.G_EXC_ERROR;
778: ELSE
779: x_ic_jrnl_mst_row.journal_no := l_qty_rec.journal_no;
780: END IF;

Line 786: FND_MSG_PUB.Add;

782: END IF;
783: IF (upper(l_qty_rec.journal_no) = 'PREVIOUS') THEN
784: FND_MESSAGE.SET_NAME ('GMI', 'IC_API_INVALID_JOURNAL_NO');
785: FND_MESSAGE.SET_TOKEN('JOURNAL_NO',l_qty_rec.journal_no);
786: FND_MSG_PUB.Add;
787: RAISE FND_API.G_EXC_ERROR;
788: END IF;
789: IF (NVL(x_ic_jrnl_mst_row.journal_no, ' ') = ' ') THEN
790: FND_MESSAGE.SET_NAME('GMI','IC_API_UNABLE_TO_GET_DOC_NO');

Line 793: FND_MSG_PUB.Add;

789: IF (NVL(x_ic_jrnl_mst_row.journal_no, ' ') = ' ') THEN
790: FND_MESSAGE.SET_NAME('GMI','IC_API_UNABLE_TO_GET_DOC_NO');
791: FND_MESSAGE.SET_TOKEN('DOC_TYPE','JRNL');
792: FND_MESSAGE.SET_TOKEN('ORGN_CODE',p_qty_rec.orgn_code);
793: FND_MSG_PUB.Add;
794: RAISE FND_API.G_EXC_ERROR;
795: END IF;
796: IF GMIVDBL.ic_jrnl_mst_insert(x_ic_jrnl_mst_row, x_ic_jrnl_mst_row) THEN
797: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 937: FND_MSG_PUB.Add;

933: FND_MESSAGE.SET_TOKEN('ORGN_CODE', x_ic_adjs_jnl_row1.orgn_code);
934: FND_MESSAGE.SET_TOKEN('ITEM_NO', p_ic_item_mst_row.item_no);
935: FND_MESSAGE.SET_TOKEN('LOT_NO',p_ic_lots_mst_row.lot_no);
936: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',p_ic_lots_mst_row.sublot_no);
937: FND_MSG_PUB.Add;
938:
939: /* **************************************************************
940: Jalaj Srivastava Bug 3282770
941: Post message to log to indicate that the allocations have been

Line 947: FND_MSG_PUB.Add;

943: *************************************************************** */
944: IF (x_ic_adjs_jnl_row1.trans_type = 'TRNI' and x_move_allocations = 'Y') THEN
945: FND_MESSAGE.SET_NAME('GMI','GMI_ALLOCATIONS_MOVED');
946: END IF;
947: FND_MSG_PUB.Add;
948:
949: IF FND_API.to_boolean(p_commit) THEN
950: COMMIT WORK;
951: END IF;

Line 955: FND_MSG_PUB.Count_AND_GET

951: END IF;
952: ELSE
953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
954: END IF; --(x_return_status = FND_API.G_RET_STS_SUCCESS)
955: FND_MSG_PUB.Count_AND_GET
956: (p_count => x_msg_count, p_data => x_msg_data);
957: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
958: ROLLBACK TO Create_Posting;
959: END IF;

Line 965: FND_MSG_PUB.Count_AND_GET

961: EXCEPTION
962: WHEN FND_API.G_EXC_ERROR THEN
963: ROLLBACK TO Create_Posting;
964: x_return_status := FND_API.G_RET_STS_ERROR;
965: FND_MSG_PUB.Count_AND_GET
966: (p_count => x_msg_count, p_data => x_msg_data);
967: WHEN OTHERS THEN
968: ROLLBACK TO Create_Posting;
969: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 971: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);

967: WHEN OTHERS THEN
968: ROLLBACK TO Create_Posting;
969: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
970:
971: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
972: FND_MSG_PUB.Count_AND_GET
973: (p_count => x_msg_count, p_data => x_msg_data);
974: END Inventory_Posting;
975:

Line 972: FND_MSG_PUB.Count_AND_GET

968: ROLLBACK TO Create_Posting;
969: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
970:
971: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
972: FND_MSG_PUB.Count_AND_GET
973: (p_count => x_msg_count, p_data => x_msg_data);
974: END Inventory_Posting;
975:
976:

Line 1000: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);

996: l_return_status NUMBER;
997: BEGIN
998: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
999:
1000: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1001: FND_MSG_PUB.Count_AND_GET
1002: (p_count => x_msg_count, p_data => x_msg_data);
1003: END Inventory_Transfer;
1004:

Line 1001: FND_MSG_PUB.Count_AND_GET

997: BEGIN
998: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
999:
1000: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1001: FND_MSG_PUB.Count_AND_GET
1002: (p_count => x_msg_count, p_data => x_msg_data);
1003: END Inventory_Transfer;
1004:
1005: END GMIGAPI;