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)
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
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;
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:
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)
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
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);
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;
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:
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)
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
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);
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;
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
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;
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;
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
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;
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;
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
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;
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;
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
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;
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;
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
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');
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');
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');
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');
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');
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');
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');
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');
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
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
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;
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);
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);
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);
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;
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:
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: /* **************************************************************
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
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