eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMIGAPI dependencies on IC_JRNL_MST

Line 471: | x_ic_jrnl_mst_row OUT ic_jrnl_mst%ROWTYPE |

467: | p_ic_item_mst_row IN ic_item_mst%ROWTYPE |
468: | p_ic_item_cpg_row IN ic_item_cpg%ROWTYPE |
469: | p_ic_lots_mst_row IN ic_lots_mst%ROWTYPE |
470: | p_ic_lots_cpg_row IN ic_lots_cpg%ROWTYPE |
471: | x_ic_jrnl_mst_row OUT ic_jrnl_mst%ROWTYPE |
472: | x_ic_adjs_jnl_row1 OUT ic_adjs_jnl%ROWTYPE |
473: | x_ic_adjs_jnl_row2 OUT ic_adjs_jnl%ROWTYPE |
474: | x_return_status OUT VARCHAR2 - Return Status |
475: | x_msg_count OUT NUMBER - Number of messages |

Line 522: , x_ic_jrnl_mst_row OUT NOCOPY ic_jrnl_mst%ROWTYPE

518: , p_ic_item_mst_row IN ic_item_mst%ROWTYPE
519: , p_ic_item_cpg_row IN ic_item_cpg%ROWTYPE
520: , p_ic_lots_mst_row IN ic_lots_mst%ROWTYPE
521: , p_ic_lots_cpg_row IN ic_lots_cpg%ROWTYPE
522: , x_ic_jrnl_mst_row OUT NOCOPY ic_jrnl_mst%ROWTYPE
523: , x_ic_adjs_jnl_row1 OUT NOCOPY ic_adjs_jnl%ROWTYPE
524: , x_ic_adjs_jnl_row2 OUT NOCOPY ic_adjs_jnl%ROWTYPE
525: , x_return_status OUT NOCOPY VARCHAR2
526: , x_msg_count OUT NOCOPY NUMBER

Line 557: FROM ic_jrnl_mst

553: --Cursor added to fetch the number of records for a journal no.
554: l_record_count NUMBER;
555: CURSOR Check_Record_Count IS
556: SELECT count(*)
557: FROM ic_jrnl_mst
558: WHERE journal_no = l_qty_rec.journal_no
559: AND orgn_code = l_qty_rec.orgn_code;
560: --END BUG#1834743
561:

Line 564: FROM ic_jrnl_mst j, ic_adjs_jnl a

560: --END BUG#1834743
561:
562: Cursor check_journal_no IS
563: SELECT count(1)
564: FROM ic_jrnl_mst j, ic_adjs_jnl a
565: where j.journal_no = l_qty_rec.journal_no
566: AND j.orgn_code = l_qty_rec.orgn_code
567: AND j.delete_mark = 0
568: AND j.posted_ind = 0

Line 607: , x_ic_jrnl_mst_row => x_ic_jrnl_mst_row

603: , p_ic_item_mst_row => p_ic_item_mst_row
604: , p_ic_item_cpg_row => p_ic_item_cpg_row
605: , p_ic_lots_mst_row => p_ic_lots_mst_row
606: , p_ic_lots_cpg_row => p_ic_lots_cpg_row
607: , x_ic_jrnl_mst_row => x_ic_jrnl_mst_row
608: , x_ic_adjs_jnl_row1 => x_ic_adjs_jnl_row1
609: , x_ic_adjs_jnl_row2 => x_ic_adjs_jnl_row2
610: , x_return_status => x_return_status
611: , x_msg_count => x_msg_count

Line 731: x_ic_jrnl_mst_row.journal_no :=GMA_GLOBAL_GRP.Get_doc_no ( 'JRNL', p_qty_rec.orgn_code);

727:
728: --Jalaj Srivastava Bug 2483656
729: IF (l_assign_type = 2) THEN
730: IF (p_qty_rec.trans_type <= 5) THEN
731: x_ic_jrnl_mst_row.journal_no :=GMA_GLOBAL_GRP.Get_doc_no ( 'JRNL', p_qty_rec.orgn_code);
732: ELSIF (p_qty_rec.trans_type >= 6) THEN
733: IF (p_qty_rec.journal_no IS NULL) THEN
734: x_ic_jrnl_mst_row.journal_no :=GMA_GLOBAL_GRP.Get_doc_no ( 'JRNL' , p_qty_rec.orgn_code);
735: ELSE

Line 734: x_ic_jrnl_mst_row.journal_no :=GMA_GLOBAL_GRP.Get_doc_no ( 'JRNL' , p_qty_rec.orgn_code);

730: IF (p_qty_rec.trans_type <= 5) THEN
731: x_ic_jrnl_mst_row.journal_no :=GMA_GLOBAL_GRP.Get_doc_no ( 'JRNL', p_qty_rec.orgn_code);
732: ELSIF (p_qty_rec.trans_type >= 6) THEN
733: IF (p_qty_rec.journal_no IS NULL) THEN
734: x_ic_jrnl_mst_row.journal_no :=GMA_GLOBAL_GRP.Get_doc_no ( 'JRNL' , p_qty_rec.orgn_code);
735: ELSE
736: IF ( (upper(p_qty_rec.journal_no) = 'PREVIOUS')
737: AND (p_qty_rec.orgn_code = prev_orgn_code)
738: ) THEN

Line 750: x_ic_jrnl_mst_row.journal_no := l_qty_rec.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;
752: END IF;
753: END IF;
754: ELSE

Line 764: x_ic_jrnl_mst_row.journal_no := l_qty_rec.journal_no;

760: --If there are no records retreived, then a journal is created sucessfully,
761: --else an error message is displayed.
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;

Line 779: x_ic_jrnl_mst_row.journal_no := l_qty_rec.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

Line 789: IF (NVL(x_ic_jrnl_mst_row.journal_no, ' ') = ' ') THEN

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

Line 796: IF GMIVDBL.ic_jrnl_mst_insert(x_ic_jrnl_mst_row, x_ic_jrnl_mst_row) THEN

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;
798: x_ic_adjs_jnl_row1.journal_id := x_ic_jrnl_mst_row.journal_id;
799: --Jalaj Srivastava Bug 2483656
800: IF ( (l_assign_type = 2)

Line 798: x_ic_adjs_jnl_row1.journal_id := x_ic_jrnl_mst_row.journal_id;

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;
798: x_ic_adjs_jnl_row1.journal_id := x_ic_jrnl_mst_row.journal_id;
799: --Jalaj Srivastava Bug 2483656
800: IF ( (l_assign_type = 2)
801: AND (p_qty_rec.trans_type >=6)
802: ) THEN

Line 804: prev_journal_no := x_ic_jrnl_mst_row.journal_no;

800: IF ( (l_assign_type = 2)
801: AND (p_qty_rec.trans_type >=6)
802: ) THEN
803: prev_orgn_code := p_qty_rec.orgn_code;
804: prev_journal_no := x_ic_jrnl_mst_row.journal_no;
805: ELSE
806: prev_orgn_code := NULL;
807: prev_journal_no := NULL;
808: END IF;

Line 897: ELSE --GMIVDBL.ic_jrnl_mst_insert(x_ic_jrnl_mst_row, x_ic_jrnl_mst_row)

893: END IF; --substr(x_ic_adjs_jnl_row1.trans_type,1,3) IN ('TRN','STS','GRD')
894: ELSE --GMIVDBL.ic_adjs_jnl_insert(x_ic_adjs_jnl_row1,x_ic_adjs_jnl_row1)
895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
896: END IF; --GMIVDBL.ic_adjs_jnl_insert(x_ic_adjs_jnl_row1,x_ic_adjs_jnl_row1)
897: ELSE --GMIVDBL.ic_jrnl_mst_insert(x_ic_jrnl_mst_row, x_ic_jrnl_mst_row)
898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
899: END IF;
900: END IF;
901:

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