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_ADJS_JNL

Line 472: | x_ic_adjs_jnl_row1 OUT ic_adjs_jnl%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 |
476: | x_msg_data OUT VARCHAR2 - Messages in encoded format |

Line 473: | x_ic_adjs_jnl_row2 OUT ic_adjs_jnl%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 |
476: | x_msg_data OUT VARCHAR2 - Messages in encoded format |
477: | |

Line 523: , x_ic_adjs_jnl_row1 OUT NOCOPY ic_adjs_jnl%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
527: , x_msg_data OUT NOCOPY VARCHAR2

Line 524: , x_ic_adjs_jnl_row2 OUT NOCOPY ic_adjs_jnl%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
527: , x_msg_data OUT NOCOPY VARCHAR2
528: )

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 571: AND a.trans_type = x_ic_adjs_jnl_row1.trans_type;

567: AND j.delete_mark = 0
568: AND j.posted_ind = 0
569: AND a.orgn_code = j.orgn_code
570: AND a.journal_id = j.journal_id
571: AND a.trans_type = x_ic_adjs_jnl_row1.trans_type;
572:
573: CURSOR get_doc_line IS
574: SELECT nvl(max(doc_line),0) + 1
575: FROM ic_adjs_jnl

Line 575: FROM ic_adjs_jnl

571: AND a.trans_type = x_ic_adjs_jnl_row1.trans_type;
572:
573: CURSOR get_doc_line IS
574: SELECT nvl(max(doc_line),0) + 1
575: FROM ic_adjs_jnl
576: WHERE orgn_code = x_ic_adjs_jnl_row1.orgn_code AND
577: journal_id = x_ic_adjs_jnl_row1.journal_id;
578:
579:

Line 576: WHERE orgn_code = x_ic_adjs_jnl_row1.orgn_code AND

572:
573: CURSOR get_doc_line IS
574: SELECT nvl(max(doc_line),0) + 1
575: FROM ic_adjs_jnl
576: WHERE orgn_code = x_ic_adjs_jnl_row1.orgn_code AND
577: journal_id = x_ic_adjs_jnl_row1.journal_id;
578:
579:
580: BEGIN

Line 577: journal_id = x_ic_adjs_jnl_row1.journal_id;

573: CURSOR get_doc_line IS
574: SELECT nvl(max(doc_line),0) + 1
575: FROM ic_adjs_jnl
576: WHERE orgn_code = x_ic_adjs_jnl_row1.orgn_code AND
577: journal_id = x_ic_adjs_jnl_row1.journal_id;
578:
579:
580: BEGIN
581:

Line 608: , x_ic_adjs_jnl_row1 => x_ic_adjs_jnl_row1

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
612: , x_msg_data => x_msg_data

Line 609: , x_ic_adjs_jnl_row2 => x_ic_adjs_jnl_row2

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
612: , x_msg_data => x_msg_data
613: );

Line 622: IF x_ic_adjs_jnl_row1.trans_type IN ('CREI','CRER')

618: /* If this is a 'CREI' transaction and the item is lot controlled */
619: /* then we must create the lot first as we'll need the ID in what */
620: /* follows. */
621:
622: IF x_ic_adjs_jnl_row1.trans_type IN ('CREI','CRER')
623: THEN
624: IF p_ic_item_mst_row.lot_ctl = 0
625: THEN
626: l_ic_lots_mst_row.lot_id := 0;

Line 628: x_ic_adjs_jnl_row1.lot_id := l_ic_lots_mst_row.lot_id;

624: IF p_ic_item_mst_row.lot_ctl = 0
625: THEN
626: l_ic_lots_mst_row.lot_id := 0;
627: l_ic_lots_mst_row.lot_no := GMIGUTL.IC$DEFAULT_LOT;
628: x_ic_adjs_jnl_row1.lot_id := l_ic_lots_mst_row.lot_id;
629: ELSE
630: l_lot_rec.lot_no := p_qty_rec.lot_no;
631: IF p_ic_item_mst_row.sublot_ctl = 1
632: THEN

Line 665: x_ic_adjs_jnl_row1.lot_id := l_ic_lots_mst_row.lot_id;

661: END IF;
662:
663: IF x_return_status = FND_API.G_RET_STS_SUCCESS
664: THEN
665: x_ic_adjs_jnl_row1.lot_id := l_ic_lots_mst_row.lot_id;
666: ELSE
667: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
668: END IF;
669: END IF;

Line 675: x_ic_adjs_jnl_row1.lot_id := l_ic_lots_mst_row.lot_id;

671: IF p_ic_item_mst_row.lot_ctl = 0
672: THEN
673: l_ic_lots_mst_row.lot_id := 0;
674: l_ic_lots_mst_row.lot_no := GMIGUTL.IC$DEFAULT_LOT;
675: x_ic_adjs_jnl_row1.lot_id := l_ic_lots_mst_row.lot_id;
676: END IF;
677: END IF;
678:
679: /* *********************************************************************

Line 689: AND (x_ic_adjs_jnl_row1.trans_type = 'TRNI')

685: IF ( (p_ic_item_mst_row.lot_ctl = 1)
686: AND ( (p_ic_item_mst_row.status_ctl = 0)
687: OR (fnd_profile.value('IC$MOVEDIFFSTAT') IN (0,2))
688: )
689: AND (x_ic_adjs_jnl_row1.trans_type = 'TRNI')
690: AND (fnd_profile.value('IC$MOVEALLOC') = 1)
691: ) THEN
692:
693: GMIALLOC.CHECK_ALLOC_QTY

Line 701: ,pfrom_whse_code => x_ic_adjs_jnl_row1.whse_code

697: ,p_validation_level => fnd_api.g_valid_level_full
698: ,x_return_status => x_return_status
699: ,x_msg_count => x_msg_count
700: ,x_msg_data => x_msg_data
701: ,pfrom_whse_code => x_ic_adjs_jnl_row1.whse_code
702: ,pfrom_location => nvl(x_ic_adjs_jnl_row1.location,fnd_profile.value('IC$DEFAULT_LOCT'))
703: ,plot_id => x_ic_adjs_jnl_row1.lot_id
704: ,pitem_id => x_ic_adjs_jnl_row1.item_id
705: ,pmove_qty => x_ic_adjs_jnl_row2.qty

Line 702: ,pfrom_location => nvl(x_ic_adjs_jnl_row1.location,fnd_profile.value('IC$DEFAULT_LOCT'))

698: ,x_return_status => x_return_status
699: ,x_msg_count => x_msg_count
700: ,x_msg_data => x_msg_data
701: ,pfrom_whse_code => x_ic_adjs_jnl_row1.whse_code
702: ,pfrom_location => nvl(x_ic_adjs_jnl_row1.location,fnd_profile.value('IC$DEFAULT_LOCT'))
703: ,plot_id => x_ic_adjs_jnl_row1.lot_id
704: ,pitem_id => x_ic_adjs_jnl_row1.item_id
705: ,pmove_qty => x_ic_adjs_jnl_row2.qty
706: ,pto_whse_code => x_ic_adjs_jnl_row2.whse_code

Line 703: ,plot_id => x_ic_adjs_jnl_row1.lot_id

699: ,x_msg_count => x_msg_count
700: ,x_msg_data => x_msg_data
701: ,pfrom_whse_code => x_ic_adjs_jnl_row1.whse_code
702: ,pfrom_location => nvl(x_ic_adjs_jnl_row1.location,fnd_profile.value('IC$DEFAULT_LOCT'))
703: ,plot_id => x_ic_adjs_jnl_row1.lot_id
704: ,pitem_id => x_ic_adjs_jnl_row1.item_id
705: ,pmove_qty => x_ic_adjs_jnl_row2.qty
706: ,pto_whse_code => x_ic_adjs_jnl_row2.whse_code
707: ,x_move_allocations => x_move_allocations

Line 704: ,pitem_id => x_ic_adjs_jnl_row1.item_id

700: ,x_msg_data => x_msg_data
701: ,pfrom_whse_code => x_ic_adjs_jnl_row1.whse_code
702: ,pfrom_location => nvl(x_ic_adjs_jnl_row1.location,fnd_profile.value('IC$DEFAULT_LOCT'))
703: ,plot_id => x_ic_adjs_jnl_row1.lot_id
704: ,pitem_id => x_ic_adjs_jnl_row1.item_id
705: ,pmove_qty => x_ic_adjs_jnl_row2.qty
706: ,pto_whse_code => x_ic_adjs_jnl_row2.whse_code
707: ,x_move_allocations => x_move_allocations
708: );

Line 705: ,pmove_qty => x_ic_adjs_jnl_row2.qty

701: ,pfrom_whse_code => x_ic_adjs_jnl_row1.whse_code
702: ,pfrom_location => nvl(x_ic_adjs_jnl_row1.location,fnd_profile.value('IC$DEFAULT_LOCT'))
703: ,plot_id => x_ic_adjs_jnl_row1.lot_id
704: ,pitem_id => x_ic_adjs_jnl_row1.item_id
705: ,pmove_qty => x_ic_adjs_jnl_row2.qty
706: ,pto_whse_code => x_ic_adjs_jnl_row2.whse_code
707: ,x_move_allocations => x_move_allocations
708: );
709:

Line 706: ,pto_whse_code => x_ic_adjs_jnl_row2.whse_code

702: ,pfrom_location => nvl(x_ic_adjs_jnl_row1.location,fnd_profile.value('IC$DEFAULT_LOCT'))
703: ,plot_id => x_ic_adjs_jnl_row1.lot_id
704: ,pitem_id => x_ic_adjs_jnl_row1.item_id
705: ,pmove_qty => x_ic_adjs_jnl_row2.qty
706: ,pto_whse_code => x_ic_adjs_jnl_row2.whse_code
707: ,x_move_allocations => x_move_allocations
708: );
709:
710: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

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 810: FETCH get_doc_line INTO x_ic_adjs_jnl_row1.doc_line;

806: prev_orgn_code := NULL;
807: prev_journal_no := NULL;
808: END IF;
809: OPEN get_doc_line;
810: FETCH get_doc_line INTO x_ic_adjs_jnl_row1.doc_line;
811: CLOSE get_doc_line;
812:
813: IF GMIVDBL.ic_adjs_jnl_insert(x_ic_adjs_jnl_row1,x_ic_adjs_jnl_row1) THEN
814: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 813: IF GMIVDBL.ic_adjs_jnl_insert(x_ic_adjs_jnl_row1,x_ic_adjs_jnl_row1) THEN

809: OPEN get_doc_line;
810: FETCH get_doc_line INTO x_ic_adjs_jnl_row1.doc_line;
811: CLOSE get_doc_line;
812:
813: IF GMIVDBL.ic_adjs_jnl_insert(x_ic_adjs_jnl_row1,x_ic_adjs_jnl_row1) THEN
814: x_return_status := FND_API.G_RET_STS_SUCCESS;
815: IF (substr(x_ic_adjs_jnl_row1.trans_type,4,1) = 'I') THEN
816: GMIVQTY.construct_txn_rec
817: (x_ic_adjs_jnl_row1, l_tran_rec);

Line 815: IF (substr(x_ic_adjs_jnl_row1.trans_type,4,1) = 'I') THEN

811: CLOSE get_doc_line;
812:
813: IF GMIVDBL.ic_adjs_jnl_insert(x_ic_adjs_jnl_row1,x_ic_adjs_jnl_row1) THEN
814: x_return_status := FND_API.G_RET_STS_SUCCESS;
815: IF (substr(x_ic_adjs_jnl_row1.trans_type,4,1) = 'I') THEN
816: GMIVQTY.construct_txn_rec
817: (x_ic_adjs_jnl_row1, l_tran_rec);
818: GMI_TRANS_ENGINE_PUB.create_completed_transaction
819: ( p_api_version => 1.0

Line 817: (x_ic_adjs_jnl_row1, l_tran_rec);

813: IF GMIVDBL.ic_adjs_jnl_insert(x_ic_adjs_jnl_row1,x_ic_adjs_jnl_row1) THEN
814: x_return_status := FND_API.G_RET_STS_SUCCESS;
815: IF (substr(x_ic_adjs_jnl_row1.trans_type,4,1) = 'I') THEN
816: GMIVQTY.construct_txn_rec
817: (x_ic_adjs_jnl_row1, l_tran_rec);
818: GMI_TRANS_ENGINE_PUB.create_completed_transaction
819: ( p_api_version => 1.0
820: , p_init_msg_list => FND_API.G_FALSE
821: , p_commit => FND_API.G_FALSE

Line 833: END IF; --IF (substr(x_ic_adjs_jnl_row1.trans_type,4,1) = 'I')

829: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
830: THEN
831: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
832: END IF;
833: END IF; --IF (substr(x_ic_adjs_jnl_row1.trans_type,4,1) = 'I')
834:
835: IF substr(x_ic_adjs_jnl_row1.trans_type,1,3) IN ('TRN','STS','GRD') THEN
836: x_ic_adjs_jnl_row2.doc_id := x_ic_adjs_jnl_row1.doc_id;
837: x_ic_adjs_jnl_row2.journal_id := x_ic_adjs_jnl_row1.journal_id;

Line 835: IF substr(x_ic_adjs_jnl_row1.trans_type,1,3) IN ('TRN','STS','GRD') THEN

831: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
832: END IF;
833: END IF; --IF (substr(x_ic_adjs_jnl_row1.trans_type,4,1) = 'I')
834:
835: IF substr(x_ic_adjs_jnl_row1.trans_type,1,3) IN ('TRN','STS','GRD') THEN
836: x_ic_adjs_jnl_row2.doc_id := x_ic_adjs_jnl_row1.doc_id;
837: x_ic_adjs_jnl_row2.journal_id := x_ic_adjs_jnl_row1.journal_id;
838: x_ic_adjs_jnl_row2.doc_line := x_ic_adjs_jnl_row1.doc_line + 1;
839: IF GMIVDBL.ic_adjs_jnl_insert(x_ic_adjs_jnl_row2, x_ic_adjs_jnl_row2) THEN

Line 836: x_ic_adjs_jnl_row2.doc_id := x_ic_adjs_jnl_row1.doc_id;

832: END IF;
833: END IF; --IF (substr(x_ic_adjs_jnl_row1.trans_type,4,1) = 'I')
834:
835: IF substr(x_ic_adjs_jnl_row1.trans_type,1,3) IN ('TRN','STS','GRD') THEN
836: x_ic_adjs_jnl_row2.doc_id := x_ic_adjs_jnl_row1.doc_id;
837: x_ic_adjs_jnl_row2.journal_id := x_ic_adjs_jnl_row1.journal_id;
838: x_ic_adjs_jnl_row2.doc_line := x_ic_adjs_jnl_row1.doc_line + 1;
839: IF GMIVDBL.ic_adjs_jnl_insert(x_ic_adjs_jnl_row2, x_ic_adjs_jnl_row2) THEN
840: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 837: x_ic_adjs_jnl_row2.journal_id := x_ic_adjs_jnl_row1.journal_id;

833: END IF; --IF (substr(x_ic_adjs_jnl_row1.trans_type,4,1) = 'I')
834:
835: IF substr(x_ic_adjs_jnl_row1.trans_type,1,3) IN ('TRN','STS','GRD') THEN
836: x_ic_adjs_jnl_row2.doc_id := x_ic_adjs_jnl_row1.doc_id;
837: x_ic_adjs_jnl_row2.journal_id := x_ic_adjs_jnl_row1.journal_id;
838: x_ic_adjs_jnl_row2.doc_line := x_ic_adjs_jnl_row1.doc_line + 1;
839: IF GMIVDBL.ic_adjs_jnl_insert(x_ic_adjs_jnl_row2, x_ic_adjs_jnl_row2) THEN
840: x_return_status := FND_API.G_RET_STS_SUCCESS;
841: IF (substr(x_ic_adjs_jnl_row1.trans_type,4,1) = 'I') THEN

Line 838: x_ic_adjs_jnl_row2.doc_line := x_ic_adjs_jnl_row1.doc_line + 1;

834:
835: IF substr(x_ic_adjs_jnl_row1.trans_type,1,3) IN ('TRN','STS','GRD') THEN
836: x_ic_adjs_jnl_row2.doc_id := x_ic_adjs_jnl_row1.doc_id;
837: x_ic_adjs_jnl_row2.journal_id := x_ic_adjs_jnl_row1.journal_id;
838: x_ic_adjs_jnl_row2.doc_line := x_ic_adjs_jnl_row1.doc_line + 1;
839: IF GMIVDBL.ic_adjs_jnl_insert(x_ic_adjs_jnl_row2, x_ic_adjs_jnl_row2) THEN
840: x_return_status := FND_API.G_RET_STS_SUCCESS;
841: IF (substr(x_ic_adjs_jnl_row1.trans_type,4,1) = 'I') THEN
842: GMIVQTY.construct_txn_rec

Line 839: IF GMIVDBL.ic_adjs_jnl_insert(x_ic_adjs_jnl_row2, x_ic_adjs_jnl_row2) THEN

835: IF substr(x_ic_adjs_jnl_row1.trans_type,1,3) IN ('TRN','STS','GRD') THEN
836: x_ic_adjs_jnl_row2.doc_id := x_ic_adjs_jnl_row1.doc_id;
837: x_ic_adjs_jnl_row2.journal_id := x_ic_adjs_jnl_row1.journal_id;
838: x_ic_adjs_jnl_row2.doc_line := x_ic_adjs_jnl_row1.doc_line + 1;
839: IF GMIVDBL.ic_adjs_jnl_insert(x_ic_adjs_jnl_row2, x_ic_adjs_jnl_row2) THEN
840: x_return_status := FND_API.G_RET_STS_SUCCESS;
841: IF (substr(x_ic_adjs_jnl_row1.trans_type,4,1) = 'I') THEN
842: GMIVQTY.construct_txn_rec
843: (x_ic_adjs_jnl_row2, l_tran_rec);

Line 841: IF (substr(x_ic_adjs_jnl_row1.trans_type,4,1) = 'I') THEN

837: x_ic_adjs_jnl_row2.journal_id := x_ic_adjs_jnl_row1.journal_id;
838: x_ic_adjs_jnl_row2.doc_line := x_ic_adjs_jnl_row1.doc_line + 1;
839: IF GMIVDBL.ic_adjs_jnl_insert(x_ic_adjs_jnl_row2, x_ic_adjs_jnl_row2) THEN
840: x_return_status := FND_API.G_RET_STS_SUCCESS;
841: IF (substr(x_ic_adjs_jnl_row1.trans_type,4,1) = 'I') THEN
842: GMIVQTY.construct_txn_rec
843: (x_ic_adjs_jnl_row2, l_tran_rec);
844: GMI_TRANS_ENGINE_PUB.create_completed_transaction
845: ( p_api_version => 1.0

Line 843: (x_ic_adjs_jnl_row2, l_tran_rec);

839: IF GMIVDBL.ic_adjs_jnl_insert(x_ic_adjs_jnl_row2, x_ic_adjs_jnl_row2) THEN
840: x_return_status := FND_API.G_RET_STS_SUCCESS;
841: IF (substr(x_ic_adjs_jnl_row1.trans_type,4,1) = 'I') THEN
842: GMIVQTY.construct_txn_rec
843: (x_ic_adjs_jnl_row2, l_tran_rec);
844: GMI_TRANS_ENGINE_PUB.create_completed_transaction
845: ( p_api_version => 1.0
846: , p_init_msg_list => FND_API.G_FALSE
847: , p_commit => FND_API.G_FALSE

Line 876: ,pto_whse_code => x_ic_adjs_jnl_row2.whse_code

872: ,x_return_status => x_return_status
873: ,x_msg_count => x_msg_count
874: ,x_msg_data => x_msg_data
875: ,pdoc_id => l_tran_rec.doc_id
876: ,pto_whse_code => x_ic_adjs_jnl_row2.whse_code
877: ,pto_location => nvl(x_ic_adjs_jnl_row2.location,fnd_profile.value('IC$DEFAULT_LOCT'))
878: );
879:
880:

Line 877: ,pto_location => nvl(x_ic_adjs_jnl_row2.location,fnd_profile.value('IC$DEFAULT_LOCT'))

873: ,x_msg_count => x_msg_count
874: ,x_msg_data => x_msg_data
875: ,pdoc_id => l_tran_rec.doc_id
876: ,pto_whse_code => x_ic_adjs_jnl_row2.whse_code
877: ,pto_location => nvl(x_ic_adjs_jnl_row2.location,fnd_profile.value('IC$DEFAULT_LOCT'))
878: );
879:
880:
881: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 889: END IF; --(substr(x_ic_adjs_jnl_row1.trans_type,4,1) = 'I')

885: END IF;
886:
887: END IF;--}
888:
889: END IF; --(substr(x_ic_adjs_jnl_row1.trans_type,4,1) = 'I')
890: ELSE --GMIVDBL.ic_adjs_jnl_insert(x_ic_adjs_jnl_row2, x_ic_adjs_jnl_row2)
891: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
892: END IF; --GMIVDBL.ic_adjs_jnl_insert(x_ic_adjs_jnl_row2, x_ic_adjs_jnl_row2)
893: END IF; --substr(x_ic_adjs_jnl_row1.trans_type,1,3) IN ('TRN','STS','GRD')

Line 890: ELSE --GMIVDBL.ic_adjs_jnl_insert(x_ic_adjs_jnl_row2, x_ic_adjs_jnl_row2)

886:
887: END IF;--}
888:
889: END IF; --(substr(x_ic_adjs_jnl_row1.trans_type,4,1) = 'I')
890: ELSE --GMIVDBL.ic_adjs_jnl_insert(x_ic_adjs_jnl_row2, x_ic_adjs_jnl_row2)
891: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
892: END IF; --GMIVDBL.ic_adjs_jnl_insert(x_ic_adjs_jnl_row2, x_ic_adjs_jnl_row2)
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)

Line 892: END IF; --GMIVDBL.ic_adjs_jnl_insert(x_ic_adjs_jnl_row2, x_ic_adjs_jnl_row2)

888:
889: END IF; --(substr(x_ic_adjs_jnl_row1.trans_type,4,1) = 'I')
890: ELSE --GMIVDBL.ic_adjs_jnl_insert(x_ic_adjs_jnl_row2, x_ic_adjs_jnl_row2)
891: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
892: END IF; --GMIVDBL.ic_adjs_jnl_insert(x_ic_adjs_jnl_row2, x_ic_adjs_jnl_row2)
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)

Line 893: END IF; --substr(x_ic_adjs_jnl_row1.trans_type,1,3) IN ('TRN','STS','GRD')

889: END IF; --(substr(x_ic_adjs_jnl_row1.trans_type,4,1) = 'I')
890: ELSE --GMIVDBL.ic_adjs_jnl_insert(x_ic_adjs_jnl_row2, x_ic_adjs_jnl_row2)
891: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
892: END IF; --GMIVDBL.ic_adjs_jnl_insert(x_ic_adjs_jnl_row2, x_ic_adjs_jnl_row2)
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)

Line 894: ELSE --GMIVDBL.ic_adjs_jnl_insert(x_ic_adjs_jnl_row1,x_ic_adjs_jnl_row1)

890: ELSE --GMIVDBL.ic_adjs_jnl_insert(x_ic_adjs_jnl_row2, x_ic_adjs_jnl_row2)
891: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
892: END IF; --GMIVDBL.ic_adjs_jnl_insert(x_ic_adjs_jnl_row2, x_ic_adjs_jnl_row2)
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;

Line 896: END IF; --GMIVDBL.ic_adjs_jnl_insert(x_ic_adjs_jnl_row1,x_ic_adjs_jnl_row1)

892: END IF; --GMIVDBL.ic_adjs_jnl_insert(x_ic_adjs_jnl_row2, x_ic_adjs_jnl_row2)
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;

Line 905: IF(x_ic_adjs_jnl_row1.trans_type = 'CREI') THEN

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

Line 907: ELSIF(x_ic_adjs_jnl_row1.trans_type = 'ADJI') THEN

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');
911: ELSIF(x_ic_adjs_jnl_row1.trans_type = 'STSI') THEN

Line 909: ELSIF(x_ic_adjs_jnl_row1.trans_type = 'TRNI') 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');
913: ELSIF(x_ic_adjs_jnl_row1.trans_type = 'GRDI') THEN

Line 911: ELSIF(x_ic_adjs_jnl_row1.trans_type = 'STSI') THEN

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');
915: ELSIF (x_ic_adjs_jnl_row1.trans_type = 'CRER') THEN

Line 913: ELSIF(x_ic_adjs_jnl_row1.trans_type = 'GRDI') THEN

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');
917: ELSIF(x_ic_adjs_jnl_row1.trans_type = 'ADJR') THEN

Line 915: ELSIF (x_ic_adjs_jnl_row1.trans_type = 'CRER') THEN

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');
919: ELSIF(x_ic_adjs_jnl_row1.trans_type = 'TRNR') THEN

Line 917: ELSIF(x_ic_adjs_jnl_row1.trans_type = 'ADJR') THEN

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');
921: ELSIF(x_ic_adjs_jnl_row1.trans_type = 'STSR') THEN

Line 919: ELSIF(x_ic_adjs_jnl_row1.trans_type = 'TRNR') THEN

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');
923: ELSIF(x_ic_adjs_jnl_row1.trans_type = 'GRDR') THEN

Line 921: ELSIF(x_ic_adjs_jnl_row1.trans_type = 'STSR') THEN

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');
925: END IF;

Line 923: ELSIF(x_ic_adjs_jnl_row1.trans_type = 'GRDR') THEN

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
927: FND_MESSAGE.SET_TOKEN('DOC_LINE', x_ic_adjs_jnl_row1.doc_line);

Line 926: IF (x_ic_adjs_jnl_row1.trans_type IN ('CRER','ADJR')) 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
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);

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 928: ELSIF (x_ic_adjs_jnl_row1.trans_type IN ('GRDR','TRNR','STSR')) 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;
932: FND_MESSAGE.SET_TOKEN('JOURNAL_NO', x_ic_jrnl_mst_row.journal_no);

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 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 944: IF (x_ic_adjs_jnl_row1.trans_type = 'TRNI' and x_move_allocations = 'Y') THEN

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: