DBA Data[Home] [Help]

APPS.GMIGAPI dependencies on FND_MESSAGE

Line 140: FND_MESSAGE.SET_NAME('GMI','IC_API_ITEM_CREATED');

136: );
137:
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)

Line 141: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_lot_rec.item_no);

137:
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

Line 273: FND_MESSAGE.SET_NAME('GMI','IC_API_LOT_CREATED');

269: ELSE
270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
271: END IF;
272:
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;

Line 274: FND_MESSAGE.SET_TOKEN('ITEM_NO', p_lot_rec.item_no);

270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
271: END IF;
272:
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:

Line 275: FND_MESSAGE.SET_TOKEN('LOT_NO', p_lot_rec.lot_no);

271: END IF;
272:
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)

Line 276: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', p_lot_rec.sublot_no);

272:
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

Line 402: FND_MESSAGE.SET_NAME('GMI','IC_API_ILC_CREATED');

398: /* Set token for uom type to be displayed in the success message */
399: IF GMIVDBL.ic_item_cnv_insert(x_ic_item_cnv_row, x_ic_item_cnv_row)
400: THEN
401:
402: FND_MESSAGE.SET_NAME('GMI','IC_API_ILC_CREATED');
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);

Line 403: FND_MESSAGE.SET_TOKEN('ITEM_NO', p_conv_rec.item_no);

399: IF GMIVDBL.ic_item_cnv_insert(x_ic_item_cnv_row, x_ic_item_cnv_row)
400: THEN
401:
402: FND_MESSAGE.SET_NAME('GMI','IC_API_ILC_CREATED');
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;

Line 404: FND_MESSAGE.SET_TOKEN('LOT_NO', p_conv_rec.lot_no);

400: THEN
401:
402: FND_MESSAGE.SET_NAME('GMI','IC_API_ILC_CREATED');
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:

Line 405: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', p_conv_rec.sublot_no);

401:
402: FND_MESSAGE.SET_NAME('GMI','IC_API_ILC_CREATED');
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)

Line 406: FND_MESSAGE.SET_TOKEN('UM_TYPE', x_ic_item_cnv_row.um_type);

402: FND_MESSAGE.SET_NAME('GMI','IC_API_ILC_CREATED');
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

Line 418: FND_MESSAGE.SET_NAME('GMI','IC_API_ITEM_CNV_ALREADY_EXISTS');

414: /* Display message if conversion already exists. */
415: ELSE
416: IF GMIGUTL.DB_ERRNUM = -1
417: THEN
418: FND_MESSAGE.SET_NAME('GMI','IC_API_ITEM_CNV_ALREADY_EXISTS');
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);

Line 419: FND_MESSAGE.SET_TOKEN('ITEM_NO', p_conv_rec.item_no);

415: ELSE
416: IF GMIGUTL.DB_ERRNUM = -1
417: THEN
418: FND_MESSAGE.SET_NAME('GMI','IC_API_ITEM_CNV_ALREADY_EXISTS');
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;

Line 420: FND_MESSAGE.SET_TOKEN('LOT_NO', p_conv_rec.lot_no);

416: IF GMIGUTL.DB_ERRNUM = -1
417: THEN
418: FND_MESSAGE.SET_NAME('GMI','IC_API_ITEM_CNV_ALREADY_EXISTS');
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

Line 421: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', p_conv_rec.sublot_no);

417: THEN
418: FND_MESSAGE.SET_NAME('GMI','IC_API_ITEM_CNV_ALREADY_EXISTS');
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;

Line 422: FND_MESSAGE.SET_TOKEN('UM_TYPE', x_ic_item_cnv_row.um_type);

418: FND_MESSAGE.SET_NAME('GMI','IC_API_ITEM_CNV_ALREADY_EXISTS');
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;

Line 745: FND_MESSAGE.SET_NAME ('GMI', 'IC_API_INVALID_JOURNAL_NO');

741: OPEN check_journal_no;
742: FETCH check_journal_no INTO l_record_count;
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

Line 746: FND_MESSAGE.SET_TOKEN('JOURNAL_NO',p_qty_rec.journal_no);

742: FETCH check_journal_no INTO l_record_count;
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;

Line 766: FND_MESSAGE.SET_NAME ('GMI', 'GMI_JOURNALNOEXISTS');

762:
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;

Line 774: FND_MESSAGE.SET_NAME ('GMI', 'IC_API_INVALID_JOURNAL_NO');

770: OPEN check_journal_no;
771: FETCH check_journal_no INTO l_record_count;
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

Line 775: FND_MESSAGE.SET_TOKEN('JOURNAL_NO',l_qty_rec.journal_no);

771: FETCH check_journal_no INTO l_record_count;
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;

Line 784: FND_MESSAGE.SET_NAME ('GMI', 'IC_API_INVALID_JOURNAL_NO');

780: END IF;
781: END IF;
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;

Line 785: FND_MESSAGE.SET_TOKEN('JOURNAL_NO',l_qty_rec.journal_no);

781: END IF;
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

Line 790: FND_MESSAGE.SET_NAME('GMI','IC_API_UNABLE_TO_GET_DOC_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');
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;

Line 791: FND_MESSAGE.SET_TOKEN('DOC_TYPE','JRNL');

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

Line 792: FND_MESSAGE.SET_TOKEN('ORGN_CODE',p_qty_rec.orgn_code);

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

Line 906: FND_MESSAGE.SET_NAME('GMI','IC_API_CRE_TRAN_POSTED');

902: /* Bug 1655794 - Generate the output log file with proper messages */
903: /* upon sucessful run of the API. */
904: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
905: IF(x_ic_adjs_jnl_row1.trans_type = 'CREI') THEN
906: FND_MESSAGE.SET_NAME('GMI','IC_API_CRE_TRAN_POSTED');
907: ELSIF(x_ic_adjs_jnl_row1.trans_type = 'ADJI') THEN
908: FND_MESSAGE.SET_NAME('GMI','IC_API_ADJ_TRAN_POSTED');
909: ELSIF(x_ic_adjs_jnl_row1.trans_type = 'TRNI') THEN
910: FND_MESSAGE.SET_NAME('GMI','IC_API_TRN_TRAN_POSTED');

Line 908: FND_MESSAGE.SET_NAME('GMI','IC_API_ADJ_TRAN_POSTED');

904: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
905: IF(x_ic_adjs_jnl_row1.trans_type = 'CREI') THEN
906: FND_MESSAGE.SET_NAME('GMI','IC_API_CRE_TRAN_POSTED');
907: ELSIF(x_ic_adjs_jnl_row1.trans_type = 'ADJI') THEN
908: FND_MESSAGE.SET_NAME('GMI','IC_API_ADJ_TRAN_POSTED');
909: ELSIF(x_ic_adjs_jnl_row1.trans_type = 'TRNI') THEN
910: FND_MESSAGE.SET_NAME('GMI','IC_API_TRN_TRAN_POSTED');
911: ELSIF(x_ic_adjs_jnl_row1.trans_type = 'STSI') THEN
912: FND_MESSAGE.SET_NAME('GMI','IC_API_STS_TRAN_POSTED');

Line 910: FND_MESSAGE.SET_NAME('GMI','IC_API_TRN_TRAN_POSTED');

906: FND_MESSAGE.SET_NAME('GMI','IC_API_CRE_TRAN_POSTED');
907: ELSIF(x_ic_adjs_jnl_row1.trans_type = 'ADJI') THEN
908: FND_MESSAGE.SET_NAME('GMI','IC_API_ADJ_TRAN_POSTED');
909: ELSIF(x_ic_adjs_jnl_row1.trans_type = 'TRNI') THEN
910: FND_MESSAGE.SET_NAME('GMI','IC_API_TRN_TRAN_POSTED');
911: ELSIF(x_ic_adjs_jnl_row1.trans_type = 'STSI') THEN
912: FND_MESSAGE.SET_NAME('GMI','IC_API_STS_TRAN_POSTED');
913: ELSIF(x_ic_adjs_jnl_row1.trans_type = 'GRDI') THEN
914: FND_MESSAGE.SET_NAME('GMI','IC_API_GRD_TRAN_POSTED');

Line 912: FND_MESSAGE.SET_NAME('GMI','IC_API_STS_TRAN_POSTED');

908: FND_MESSAGE.SET_NAME('GMI','IC_API_ADJ_TRAN_POSTED');
909: ELSIF(x_ic_adjs_jnl_row1.trans_type = 'TRNI') THEN
910: FND_MESSAGE.SET_NAME('GMI','IC_API_TRN_TRAN_POSTED');
911: ELSIF(x_ic_adjs_jnl_row1.trans_type = 'STSI') THEN
912: FND_MESSAGE.SET_NAME('GMI','IC_API_STS_TRAN_POSTED');
913: ELSIF(x_ic_adjs_jnl_row1.trans_type = 'GRDI') THEN
914: FND_MESSAGE.SET_NAME('GMI','IC_API_GRD_TRAN_POSTED');
915: ELSIF (x_ic_adjs_jnl_row1.trans_type = 'CRER') THEN
916: FND_MESSAGE.SET_NAME('GMI','IC_API_CRER_TRAN_CREATED');

Line 914: FND_MESSAGE.SET_NAME('GMI','IC_API_GRD_TRAN_POSTED');

910: FND_MESSAGE.SET_NAME('GMI','IC_API_TRN_TRAN_POSTED');
911: ELSIF(x_ic_adjs_jnl_row1.trans_type = 'STSI') THEN
912: FND_MESSAGE.SET_NAME('GMI','IC_API_STS_TRAN_POSTED');
913: ELSIF(x_ic_adjs_jnl_row1.trans_type = 'GRDI') THEN
914: FND_MESSAGE.SET_NAME('GMI','IC_API_GRD_TRAN_POSTED');
915: ELSIF (x_ic_adjs_jnl_row1.trans_type = 'CRER') THEN
916: FND_MESSAGE.SET_NAME('GMI','IC_API_CRER_TRAN_CREATED');
917: ELSIF(x_ic_adjs_jnl_row1.trans_type = 'ADJR') THEN
918: FND_MESSAGE.SET_NAME('GMI','IC_API_ADJR_TRAN_CREATED');

Line 916: FND_MESSAGE.SET_NAME('GMI','IC_API_CRER_TRAN_CREATED');

912: FND_MESSAGE.SET_NAME('GMI','IC_API_STS_TRAN_POSTED');
913: ELSIF(x_ic_adjs_jnl_row1.trans_type = 'GRDI') THEN
914: FND_MESSAGE.SET_NAME('GMI','IC_API_GRD_TRAN_POSTED');
915: ELSIF (x_ic_adjs_jnl_row1.trans_type = 'CRER') THEN
916: FND_MESSAGE.SET_NAME('GMI','IC_API_CRER_TRAN_CREATED');
917: ELSIF(x_ic_adjs_jnl_row1.trans_type = 'ADJR') THEN
918: FND_MESSAGE.SET_NAME('GMI','IC_API_ADJR_TRAN_CREATED');
919: ELSIF(x_ic_adjs_jnl_row1.trans_type = 'TRNR') THEN
920: FND_MESSAGE.SET_NAME('GMI','IC_API_TRNR_TRAN_CREATED');

Line 918: FND_MESSAGE.SET_NAME('GMI','IC_API_ADJR_TRAN_CREATED');

914: FND_MESSAGE.SET_NAME('GMI','IC_API_GRD_TRAN_POSTED');
915: ELSIF (x_ic_adjs_jnl_row1.trans_type = 'CRER') THEN
916: FND_MESSAGE.SET_NAME('GMI','IC_API_CRER_TRAN_CREATED');
917: ELSIF(x_ic_adjs_jnl_row1.trans_type = 'ADJR') THEN
918: FND_MESSAGE.SET_NAME('GMI','IC_API_ADJR_TRAN_CREATED');
919: ELSIF(x_ic_adjs_jnl_row1.trans_type = 'TRNR') THEN
920: FND_MESSAGE.SET_NAME('GMI','IC_API_TRNR_TRAN_CREATED');
921: ELSIF(x_ic_adjs_jnl_row1.trans_type = 'STSR') THEN
922: FND_MESSAGE.SET_NAME('GMI','IC_API_STSR_TRAN_CREATED');

Line 920: FND_MESSAGE.SET_NAME('GMI','IC_API_TRNR_TRAN_CREATED');

916: FND_MESSAGE.SET_NAME('GMI','IC_API_CRER_TRAN_CREATED');
917: ELSIF(x_ic_adjs_jnl_row1.trans_type = 'ADJR') THEN
918: FND_MESSAGE.SET_NAME('GMI','IC_API_ADJR_TRAN_CREATED');
919: ELSIF(x_ic_adjs_jnl_row1.trans_type = 'TRNR') THEN
920: FND_MESSAGE.SET_NAME('GMI','IC_API_TRNR_TRAN_CREATED');
921: ELSIF(x_ic_adjs_jnl_row1.trans_type = 'STSR') THEN
922: FND_MESSAGE.SET_NAME('GMI','IC_API_STSR_TRAN_CREATED');
923: ELSIF(x_ic_adjs_jnl_row1.trans_type = 'GRDR') THEN
924: FND_MESSAGE.SET_NAME('GMI','IC_API_GRDR_TRAN_CREATED');

Line 922: FND_MESSAGE.SET_NAME('GMI','IC_API_STSR_TRAN_CREATED');

918: FND_MESSAGE.SET_NAME('GMI','IC_API_ADJR_TRAN_CREATED');
919: ELSIF(x_ic_adjs_jnl_row1.trans_type = 'TRNR') THEN
920: FND_MESSAGE.SET_NAME('GMI','IC_API_TRNR_TRAN_CREATED');
921: ELSIF(x_ic_adjs_jnl_row1.trans_type = 'STSR') THEN
922: FND_MESSAGE.SET_NAME('GMI','IC_API_STSR_TRAN_CREATED');
923: ELSIF(x_ic_adjs_jnl_row1.trans_type = 'GRDR') THEN
924: FND_MESSAGE.SET_NAME('GMI','IC_API_GRDR_TRAN_CREATED');
925: END IF;
926: IF (x_ic_adjs_jnl_row1.trans_type IN ('CRER','ADJR')) THEN

Line 924: FND_MESSAGE.SET_NAME('GMI','IC_API_GRDR_TRAN_CREATED');

920: FND_MESSAGE.SET_NAME('GMI','IC_API_TRNR_TRAN_CREATED');
921: ELSIF(x_ic_adjs_jnl_row1.trans_type = 'STSR') THEN
922: FND_MESSAGE.SET_NAME('GMI','IC_API_STSR_TRAN_CREATED');
923: ELSIF(x_ic_adjs_jnl_row1.trans_type = 'GRDR') THEN
924: FND_MESSAGE.SET_NAME('GMI','IC_API_GRDR_TRAN_CREATED');
925: END IF;
926: IF (x_ic_adjs_jnl_row1.trans_type IN ('CRER','ADJR')) THEN
927: FND_MESSAGE.SET_TOKEN('DOC_LINE', x_ic_adjs_jnl_row1.doc_line);
928: ELSIF (x_ic_adjs_jnl_row1.trans_type IN ('GRDR','TRNR','STSR')) THEN

Line 927: FND_MESSAGE.SET_TOKEN('DOC_LINE', x_ic_adjs_jnl_row1.doc_line);

923: ELSIF(x_ic_adjs_jnl_row1.trans_type = 'GRDR') THEN
924: FND_MESSAGE.SET_NAME('GMI','IC_API_GRDR_TRAN_CREATED');
925: END IF;
926: IF (x_ic_adjs_jnl_row1.trans_type IN ('CRER','ADJR')) THEN
927: FND_MESSAGE.SET_TOKEN('DOC_LINE', x_ic_adjs_jnl_row1.doc_line);
928: ELSIF (x_ic_adjs_jnl_row1.trans_type IN ('GRDR','TRNR','STSR')) THEN
929: FND_MESSAGE.SET_TOKEN('DOC_LINE_FROM', x_ic_adjs_jnl_row1.doc_line);
930: FND_MESSAGE.SET_TOKEN('DOC_LINE_TO', x_ic_adjs_jnl_row2.doc_line);
931: END IF;

Line 929: FND_MESSAGE.SET_TOKEN('DOC_LINE_FROM', x_ic_adjs_jnl_row1.doc_line);

925: END IF;
926: IF (x_ic_adjs_jnl_row1.trans_type IN ('CRER','ADJR')) THEN
927: FND_MESSAGE.SET_TOKEN('DOC_LINE', x_ic_adjs_jnl_row1.doc_line);
928: ELSIF (x_ic_adjs_jnl_row1.trans_type IN ('GRDR','TRNR','STSR')) THEN
929: FND_MESSAGE.SET_TOKEN('DOC_LINE_FROM', x_ic_adjs_jnl_row1.doc_line);
930: FND_MESSAGE.SET_TOKEN('DOC_LINE_TO', x_ic_adjs_jnl_row2.doc_line);
931: END IF;
932: FND_MESSAGE.SET_TOKEN('JOURNAL_NO', x_ic_jrnl_mst_row.journal_no);
933: FND_MESSAGE.SET_TOKEN('ORGN_CODE', x_ic_adjs_jnl_row1.orgn_code);

Line 930: FND_MESSAGE.SET_TOKEN('DOC_LINE_TO', x_ic_adjs_jnl_row2.doc_line);

926: IF (x_ic_adjs_jnl_row1.trans_type IN ('CRER','ADJR')) THEN
927: FND_MESSAGE.SET_TOKEN('DOC_LINE', x_ic_adjs_jnl_row1.doc_line);
928: ELSIF (x_ic_adjs_jnl_row1.trans_type IN ('GRDR','TRNR','STSR')) THEN
929: FND_MESSAGE.SET_TOKEN('DOC_LINE_FROM', x_ic_adjs_jnl_row1.doc_line);
930: FND_MESSAGE.SET_TOKEN('DOC_LINE_TO', x_ic_adjs_jnl_row2.doc_line);
931: END IF;
932: FND_MESSAGE.SET_TOKEN('JOURNAL_NO', x_ic_jrnl_mst_row.journal_no);
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);

Line 932: FND_MESSAGE.SET_TOKEN('JOURNAL_NO', x_ic_jrnl_mst_row.journal_no);

928: ELSIF (x_ic_adjs_jnl_row1.trans_type IN ('GRDR','TRNR','STSR')) THEN
929: FND_MESSAGE.SET_TOKEN('DOC_LINE_FROM', x_ic_adjs_jnl_row1.doc_line);
930: FND_MESSAGE.SET_TOKEN('DOC_LINE_TO', x_ic_adjs_jnl_row2.doc_line);
931: END IF;
932: FND_MESSAGE.SET_TOKEN('JOURNAL_NO', x_ic_jrnl_mst_row.journal_no);
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);

Line 933: FND_MESSAGE.SET_TOKEN('ORGN_CODE', x_ic_adjs_jnl_row1.orgn_code);

929: FND_MESSAGE.SET_TOKEN('DOC_LINE_FROM', x_ic_adjs_jnl_row1.doc_line);
930: FND_MESSAGE.SET_TOKEN('DOC_LINE_TO', x_ic_adjs_jnl_row2.doc_line);
931: END IF;
932: FND_MESSAGE.SET_TOKEN('JOURNAL_NO', x_ic_jrnl_mst_row.journal_no);
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;

Line 934: FND_MESSAGE.SET_TOKEN('ITEM_NO', p_ic_item_mst_row.item_no);

930: FND_MESSAGE.SET_TOKEN('DOC_LINE_TO', x_ic_adjs_jnl_row2.doc_line);
931: END IF;
932: FND_MESSAGE.SET_TOKEN('JOURNAL_NO', x_ic_jrnl_mst_row.journal_no);
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:

Line 935: FND_MESSAGE.SET_TOKEN('LOT_NO',p_ic_lots_mst_row.lot_no);

931: END IF;
932: FND_MESSAGE.SET_TOKEN('JOURNAL_NO', x_ic_jrnl_mst_row.journal_no);
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: /* **************************************************************

Line 936: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',p_ic_lots_mst_row.sublot_no);

932: FND_MESSAGE.SET_TOKEN('JOURNAL_NO', x_ic_jrnl_mst_row.journal_no);
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

Line 945: FND_MESSAGE.SET_NAME('GMI','GMI_ALLOCATIONS_MOVED');

941: Post message to log to indicate that the allocations have been
942: moved.
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