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.RCV_ACCEVENTS_PVT dependencies on RCV_SEEDEVENTS_PVT

Line 399: l_rcv_event RCV_SeedEvents_PVT.rcv_event_rec_type;

395: l_msg_data VARCHAR2(8000) := '';
396: l_stmt_num NUMBER := 0;
397: l_api_message VARCHAR2(1000);
398:
399: l_rcv_event RCV_SeedEvents_PVT.rcv_event_rec_type;
400: l_rcv_events_tbl RCV_SeedEvents_PVT.rcv_event_tbl_type;
401: l_rae_count NUMBER;
402:
403: -- 12i Complex Work Procurement------------------------------------

Line 400: l_rcv_events_tbl RCV_SeedEvents_PVT.rcv_event_tbl_type;

396: l_stmt_num NUMBER := 0;
397: l_api_message VARCHAR2(1000);
398:
399: l_rcv_event RCV_SeedEvents_PVT.rcv_event_rec_type;
400: l_rcv_events_tbl RCV_SeedEvents_PVT.rcv_event_tbl_type;
401: l_rae_count NUMBER;
402:
403: -- 12i Complex Work Procurement------------------------------------
404: l_matching_basis PO_LINE_LOCATIONS.matching_basis%TYPE;

Line 599: RCV_SeedEvents_PVT.Seed_RAEEvent(

595: IF l_po_distribution_id <> -1 THEN
596:
597: l_stmt_num := 80;
598:
599: RCV_SeedEvents_PVT.Seed_RAEEvent(
600: p_api_version => 1.0,
601: x_return_status => l_return_status,
602: x_msg_count => l_msg_count,
603: x_msg_data => l_msg_data,

Line 605: p_event_type_id => RCV_SeedEvents_PVT.ADJUST_RECEIVE,

601: x_return_status => l_return_status,
602: x_msg_count => l_msg_count,
603: x_msg_data => l_msg_data,
604: p_event_source => 'RETROPRICE',
605: p_event_type_id => RCV_SeedEvents_PVT.ADJUST_RECEIVE,
606: p_rcv_transaction_id => c_par_txn.transaction_id,
607: p_inv_distribution_id => NULL,
608: p_po_distribution_id => l_po_distribution_id,
609: p_direct_delivery_flag => NULL,

Line 647: RCV_SeedEvents_PVT.Seed_RAEEvent(

643:
644: FOR c_po_dist IN c_po_dists_csr (c_par_txn.transaction_id) LOOP
645: l_stmt_num := 90;
646:
647: RCV_SeedEvents_PVT.Seed_RAEEvent(
648: p_api_version => 1.0,
649: x_return_status => l_return_status,
650: x_msg_count => l_msg_count,
651: x_msg_data => l_msg_data,

Line 653: p_event_type_id => RCV_SeedEvents_PVT.ADJUST_RECEIVE,

649: x_return_status => l_return_status,
650: x_msg_count => l_msg_count,
651: x_msg_data => l_msg_data,
652: p_event_source => 'RETROPRICE',
653: p_event_type_id => RCV_SeedEvents_PVT.ADJUST_RECEIVE,
654: p_rcv_transaction_id => c_par_txn.transaction_id,
655: p_inv_distribution_id => NULL,
656: p_po_distribution_id => c_po_dist.po_distribution_id,
657: p_direct_delivery_flag => NULL,

Line 699: RCV_SeedEvents_PVT.Seed_RAEEvent(

695:
696: l_stmt_num := 100;
697:
698: FOR c_del_txn IN c_deliver_txns_csr(c_par_txn.transaction_id) LOOP
699: RCV_SeedEvents_PVT.Seed_RAEEvent(
700: p_api_version => 1.0,
701: x_return_status => l_return_status,
702: x_msg_count => l_msg_count,
703: x_msg_data => l_msg_data,

Line 705: p_event_type_id => RCV_SeedEvents_PVT.ADJUST_DELIVER,

701: x_return_status => l_return_status,
702: x_msg_count => l_msg_count,
703: x_msg_data => l_msg_data,
704: p_event_source => 'RETROPRICE',
705: p_event_type_id => RCV_SeedEvents_PVT.ADJUST_DELIVER,
706: p_rcv_transaction_id => c_del_txn.transaction_id,
707: p_inv_distribution_id => NULL,
708: p_po_distribution_id => c_del_txn.po_distribution_id,
709: p_direct_delivery_flag => NULL,

Line 752: RCV_SeedEvents_PVT.Insert_RAEEvents(

748:
749: IF (l_rcv_events_tbl.count > 0) THEN
750: -- Insert events into RCV_Accounting_Events
751: l_stmt_num := 110;
752: RCV_SeedEvents_PVT.Insert_RAEEvents(
753: p_api_version => 1.0,
754: x_return_status => l_return_status,
755: x_msg_count => l_msg_count,
756: x_msg_data => l_msg_data,

Line 872: l_rcv_event RCV_SeedEvents_PVT.rcv_event_rec_type;

868: l_msg_data VARCHAR2(8000) := '';
869: l_stmt_num NUMBER := 0;
870: l_api_message VARCHAR2(1000);
871:
872: l_rcv_event RCV_SeedEvents_PVT.rcv_event_rec_type;
873: l_rcv_events_tbl RCV_SeedEvents_PVT.rcv_event_tbl_type;
874: l_event_type_id NUMBER;
875:
876: l_transaction_flows_tbl INV_TRANSACTION_FLOW_PUB.g_transaction_flow_tbl_type;

Line 873: l_rcv_events_tbl RCV_SeedEvents_PVT.rcv_event_tbl_type;

869: l_stmt_num NUMBER := 0;
870: l_api_message VARCHAR2(1000);
871:
872: l_rcv_event RCV_SeedEvents_PVT.rcv_event_rec_type;
873: l_rcv_events_tbl RCV_SeedEvents_PVT.rcv_event_tbl_type;
874: l_event_type_id NUMBER;
875:
876: l_transaction_flows_tbl INV_TRANSACTION_FLOW_PUB.g_transaction_flow_tbl_type;
877: l_transaction_forward_flow_rec INV_TRANSACTION_FLOW_PUB.mtl_transaction_flow_rec_type;

Line 1038: l_rcv_event RCV_SeedEvents_PVT.rcv_event_rec_type;

1034: l_msg_data VARCHAR2(8000) := '';
1035: l_stmt_num NUMBER := 0;
1036: l_api_message VARCHAR2(1000);
1037:
1038: l_rcv_event RCV_SeedEvents_PVT.rcv_event_rec_type;
1039: l_rcv_events_tbl RCV_SeedEvents_PVT.rcv_event_tbl_type;
1040: l_event_type_id NUMBER;
1041:
1042:

Line 1039: l_rcv_events_tbl RCV_SeedEvents_PVT.rcv_event_tbl_type;

1035: l_stmt_num NUMBER := 0;
1036: l_api_message VARCHAR2(1000);
1037:
1038: l_rcv_event RCV_SeedEvents_PVT.rcv_event_rec_type;
1039: l_rcv_events_tbl RCV_SeedEvents_PVT.rcv_event_tbl_type;
1040: l_event_type_id NUMBER;
1041:
1042:
1043: l_transaction_flows_tbl INV_TRANSACTION_FLOW_PUB.g_transaction_flow_tbl_type;

Line 1379: RCV_SeedEvents_PVT.Seed_RAEEvent(

1375: END IF;
1376:
1377:
1378: l_stmt_num := 80;
1379: RCV_SeedEvents_PVT.Seed_RAEEvent(
1380: p_api_version => 1.0,
1381: x_return_status => l_return_status,
1382: x_msg_count => l_msg_count,
1383: x_msg_data => l_msg_data,

Line 1385: p_event_type_id => RCV_SeedEvents_PVT.LOGICAL_RECEIVE,

1381: x_return_status => l_return_status,
1382: x_msg_count => l_msg_count,
1383: x_msg_data => l_msg_data,
1384: p_event_source => 'RECEIVING',
1385: p_event_type_id => RCV_SeedEvents_PVT.LOGICAL_RECEIVE,
1386: p_rcv_transaction_id => p_rcv_transaction_id,
1387: p_inv_distribution_id => NULL,
1388: p_po_distribution_id => rec_pod.po_distribution_id,
1389: p_direct_delivery_flag => p_direct_delivery_flag,

Line 1428: RCV_SeedEvents_PVT.Seed_RAEEvent(

1424: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
1425: ,'Seeding Invoice Match in RAE');
1426: END IF;
1427:
1428: RCV_SeedEvents_PVT.Seed_RAEEvent(
1429: p_api_version => 1.0,
1430: x_return_status => l_return_status,
1431: x_msg_count => l_msg_count,
1432: x_msg_data => l_msg_data,

Line 1434: p_event_type_id => RCV_SeedEvents_PVT.INTERCOMPANY_INVOICE,

1430: x_return_status => l_return_status,
1431: x_msg_count => l_msg_count,
1432: x_msg_data => l_msg_data,
1433: p_event_source => 'RECEIVING',
1434: p_event_type_id => RCV_SeedEvents_PVT.INTERCOMPANY_INVOICE,
1435: p_rcv_transaction_id => p_rcv_transaction_id,
1436: p_inv_distribution_id => NULL,
1437: p_po_distribution_id => rec_pod.po_distribution_id,
1438: p_direct_delivery_flag => p_direct_delivery_flag,

Line 1500: RCV_SeedEvents_PVT.Seed_RAEEvent(

1496: ,'Drop Ship : Seeding Logical Receive in RAE');
1497: END IF;
1498:
1499: l_stmt_num := 120;
1500: RCV_SeedEvents_PVT.Seed_RAEEvent(
1501: p_api_version => 1.0,
1502: x_return_status => l_return_status,
1503: x_msg_count => l_msg_count,
1504: x_msg_data => l_msg_data,

Line 1506: p_event_type_id => RCV_SeedEvents_PVT.LOGICAL_RECEIVE,

1502: x_return_status => l_return_status,
1503: x_msg_count => l_msg_count,
1504: x_msg_data => l_msg_data,
1505: p_event_source => 'RECEIVING',
1506: p_event_type_id => RCV_SeedEvents_PVT.LOGICAL_RECEIVE,
1507: p_rcv_transaction_id => p_rcv_transaction_id,
1508: p_inv_distribution_id => NULL,
1509: p_po_distribution_id => rec_pod.po_distribution_id,
1510: p_direct_delivery_flag => p_direct_delivery_flag,

Line 1541: SELECT decode(RT.transaction_type,'CORRECT',RCV_SeedEvents_PVT.CORRECT,

1537:
1538: ELSE
1539:
1540: l_stmt_num := 130;
1541: SELECT decode(RT.transaction_type,'CORRECT',RCV_SeedEvents_PVT.CORRECT,
1542: RCV_SeedEvents_PVT.RECEIVE)
1543: INTO l_event_type_id
1544: FROM rcv_Transactions RT
1545: WHERE transaction_id = p_rcv_transaction_id;

Line 1542: RCV_SeedEvents_PVT.RECEIVE)

1538: ELSE
1539:
1540: l_stmt_num := 130;
1541: SELECT decode(RT.transaction_type,'CORRECT',RCV_SeedEvents_PVT.CORRECT,
1542: RCV_SeedEvents_PVT.RECEIVE)
1543: INTO l_event_type_id
1544: FROM rcv_Transactions RT
1545: WHERE transaction_id = p_rcv_transaction_id;
1546:

Line 1553: RCV_SeedEvents_PVT.Seed_RAEEvent(

1549: ,'Not Drop Ship : Seeding Receive in RAE');
1550: END IF;
1551:
1552: l_stmt_num := 140;
1553: RCV_SeedEvents_PVT.Seed_RAEEvent(
1554: p_api_version => 1.0,
1555: x_return_status => l_return_status,
1556: x_msg_count => l_msg_count,
1557: x_msg_data => l_msg_data,

Line 1599: RCV_SeedEvents_PVT.Insert_RAEEvents(

1595: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1596: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
1597: ,'Inserting events into RAE');
1598: END IF;
1599: RCV_SeedEvents_PVT.Insert_RAEEvents(
1600: p_api_version => 1.0,
1601: x_return_status => l_return_status,
1602: x_msg_count => l_msg_count,
1603: x_msg_data => l_msg_data,

Line 1622: RCV_SeedEvents_PVT.Insert_MMTEvents(

1618: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1619: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
1620: ,'Inserting events into MMT');
1621: END IF;
1622: RCV_SeedEvents_PVT.Insert_MMTEvents(
1623: p_api_version => 1.0,
1624: x_return_status => l_return_status,
1625: x_msg_count => l_msg_count,
1626: x_msg_data => l_msg_data,

Line 1743: l_rcv_event RCV_SeedEvents_PVT.rcv_event_rec_type;

1739: l_msg_data VARCHAR2(8000) := '';
1740: l_stmt_num NUMBER := 0;
1741: l_api_message VARCHAR2(1000);
1742:
1743: l_rcv_event RCV_SeedEvents_PVT.rcv_event_rec_type;
1744: l_rcv_events_tbl RCV_SeedEvents_PVT.rcv_event_tbl_type;
1745: l_event_type_id NUMBER;
1746:
1747: l_transaction_flows_tbl INV_TRANSACTION_FLOW_PUB.g_transaction_flow_tbl_type;

Line 1744: l_rcv_events_tbl RCV_SeedEvents_PVT.rcv_event_tbl_type;

1740: l_stmt_num NUMBER := 0;
1741: l_api_message VARCHAR2(1000);
1742:
1743: l_rcv_event RCV_SeedEvents_PVT.rcv_event_rec_type;
1744: l_rcv_events_tbl RCV_SeedEvents_PVT.rcv_event_tbl_type;
1745: l_event_type_id NUMBER;
1746:
1747: l_transaction_flows_tbl INV_TRANSACTION_FLOW_PUB.g_transaction_flow_tbl_type;
1748: l_transaction_reverse_flow_rec INV_TRANSACTION_FLOW_PUB.mtl_transaction_flow_rec_type := NULL;

Line 2030: SELECT decode(RT.transaction_type,'CORRECT',RCV_SeedEvents_PVT.CORRECT,

2026: END IF;
2027: END IF;
2028:
2029: l_stmt_num := 50;
2030: SELECT decode(RT.transaction_type,'CORRECT',RCV_SeedEvents_PVT.CORRECT,
2031: RCV_SeedEvents_PVT.DELIVER)
2032: INTO l_event_type_id
2033: FROM rcv_Transactions RT
2034: WHERE transaction_id = p_rcv_transaction_id;

Line 2031: RCV_SeedEvents_PVT.DELIVER)

2027: END IF;
2028:
2029: l_stmt_num := 50;
2030: SELECT decode(RT.transaction_type,'CORRECT',RCV_SeedEvents_PVT.CORRECT,
2031: RCV_SeedEvents_PVT.DELIVER)
2032: INTO l_event_type_id
2033: FROM rcv_Transactions RT
2034: WHERE transaction_id = p_rcv_transaction_id;
2035:

Line 2042: RCV_SeedEvents_PVT.Seed_RAEEvent(

2038: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
2039: ,'Seeding Deliver Event');
2040: END IF;
2041:
2042: RCV_SeedEvents_PVT.Seed_RAEEvent(
2043: p_api_version => 1.0,
2044: x_return_status => l_return_status,
2045: x_msg_count => l_msg_count,
2046: x_msg_data => l_msg_data,

Line 2087: RCV_SeedEvents_PVT.Check_EncumbranceFlag(

2083: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2084: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
2085: ,'Checking if encumbrance events need to be seeded.');
2086: END IF;
2087: RCV_SeedEvents_PVT.Check_EncumbranceFlag(
2088: p_api_version => 1.0,
2089: x_return_status => l_return_status,
2090: x_msg_count => l_msg_count,
2091: x_msg_data => l_msg_data,

Line 2118: RCV_SeedEvents_PVT.Seed_RAEEvent(

2114: ,'Seeding Encumbrance Reversal Event');
2115: END IF;
2116:
2117:
2118: RCV_SeedEvents_PVT.Seed_RAEEvent(
2119: p_api_version => 1.0,
2120: x_return_status => l_return_status,
2121: x_msg_count => l_msg_count,
2122: x_msg_data => l_msg_data,

Line 2124: p_event_type_id => RCV_SeedEvents_PVT.ENCUMBRANCE_REVERSAL,

2120: x_return_status => l_return_status,
2121: x_msg_count => l_msg_count,
2122: x_msg_data => l_msg_data,
2123: p_event_source => 'RECEIVING',
2124: p_event_type_id => RCV_SeedEvents_PVT.ENCUMBRANCE_REVERSAL,
2125: p_rcv_transaction_id => p_rcv_transaction_id,
2126: p_inv_distribution_id => NULL,
2127: p_po_distribution_id => l_po_distribution_id,
2128: p_direct_delivery_flag => p_direct_delivery_flag,

Line 2167: RCV_SeedEvents_PVT.Insert_RAEEvents(

2163: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2164: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
2165: ,'Inserting events into RAE');
2166: END IF;
2167: RCV_SeedEvents_PVT.Insert_RAEEvents(
2168: p_api_version => 1.0,
2169: x_return_status => l_return_status,
2170: x_msg_count => l_msg_count,
2171: x_msg_data => l_msg_data,

Line 2290: l_rcv_event RCV_SeedEvents_PVT.rcv_event_rec_type;

2286: l_msg_data VARCHAR2(8000) := '';
2287: l_stmt_num NUMBER := 0;
2288: l_api_message VARCHAR2(1000);
2289:
2290: l_rcv_event RCV_SeedEvents_PVT.rcv_event_rec_type;
2291: l_rcv_events_tbl RCV_SeedEvents_PVT.rcv_event_tbl_type;
2292: l_event_type_id NUMBER;
2293:
2294: l_transaction_flows_tbl INV_TRANSACTION_FLOW_PUB.g_transaction_flow_tbl_type;

Line 2291: l_rcv_events_tbl RCV_SeedEvents_PVT.rcv_event_tbl_type;

2287: l_stmt_num NUMBER := 0;
2288: l_api_message VARCHAR2(1000);
2289:
2290: l_rcv_event RCV_SeedEvents_PVT.rcv_event_rec_type;
2291: l_rcv_events_tbl RCV_SeedEvents_PVT.rcv_event_tbl_type;
2292: l_event_type_id NUMBER;
2293:
2294: l_transaction_flows_tbl INV_TRANSACTION_FLOW_PUB.g_transaction_flow_tbl_type;
2295: l_transaction_reverse_flow_rec INV_TRANSACTION_FLOW_PUB.mtl_transaction_flow_rec_type := NULL;

Line 2568: SELECT decode(RT.transaction_type,'CORRECT',RCV_SeedEvents_PVT.CORRECT,

2564: END IF;
2565: END IF;
2566:
2567: l_stmt_num := 50;
2568: SELECT decode(RT.transaction_type,'CORRECT',RCV_SeedEvents_PVT.CORRECT,
2569: RCV_SeedEvents_PVT.RETURN_TO_RECEIVING)
2570: INTO l_event_type_id
2571: FROM rcv_Transactions RT
2572: WHERE transaction_id = p_rcv_transaction_id;

Line 2569: RCV_SeedEvents_PVT.RETURN_TO_RECEIVING)

2565: END IF;
2566:
2567: l_stmt_num := 50;
2568: SELECT decode(RT.transaction_type,'CORRECT',RCV_SeedEvents_PVT.CORRECT,
2569: RCV_SeedEvents_PVT.RETURN_TO_RECEIVING)
2570: INTO l_event_type_id
2571: FROM rcv_Transactions RT
2572: WHERE transaction_id = p_rcv_transaction_id;
2573:

Line 2580: RCV_SeedEvents_PVT.Seed_RAEEvent(

2576: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
2577: ,'Seeding RTR Event');
2578: END IF;
2579:
2580: RCV_SeedEvents_PVT.Seed_RAEEvent(
2581: p_api_version => 1.0,
2582: x_return_status => l_return_status,
2583: x_msg_count => l_msg_count,
2584: x_msg_data => l_msg_data,

Line 2626: RCV_SeedEvents_PVT.Check_EncumbranceFlag(

2622: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2623: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
2624: ,'Checking if encumbrance events need to be seeded.');
2625: END IF;
2626: RCV_SeedEvents_PVT.Check_EncumbranceFlag(
2627: p_api_version => 1.0,
2628: x_return_status => l_return_status,
2629: x_msg_count => l_msg_count,
2630: x_msg_data => l_msg_data,

Line 2657: RCV_SeedEvents_PVT.Seed_RAEEvent(

2653: ,'Seeding Encumbrance Reversal Event');
2654: END IF;
2655:
2656:
2657: RCV_SeedEvents_PVT.Seed_RAEEvent(
2658: p_api_version => 1.0,
2659: x_return_status => l_return_status,
2660: x_msg_count => l_msg_count,
2661: x_msg_data => l_msg_data,

Line 2663: p_event_type_id => RCV_SeedEvents_PVT.ENCUMBRANCE_REVERSAL,

2659: x_return_status => l_return_status,
2660: x_msg_count => l_msg_count,
2661: x_msg_data => l_msg_data,
2662: p_event_source => 'RECEIVING',
2663: p_event_type_id => RCV_SeedEvents_PVT.ENCUMBRANCE_REVERSAL,
2664: p_rcv_transaction_id => p_rcv_transaction_id,
2665: p_inv_distribution_id => NULL,
2666: p_po_distribution_id => l_po_distribution_id,
2667: p_direct_delivery_flag => p_direct_delivery_flag,

Line 2705: RCV_SeedEvents_PVT.Insert_RAEEvents(

2701: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2702: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
2703: ,'Inserting events into RAE');
2704: END IF;
2705: RCV_SeedEvents_PVT.Insert_RAEEvents(
2706: p_api_version => 1.0,
2707: x_return_status => l_return_status,
2708: x_msg_count => l_msg_count,
2709: x_msg_data => l_msg_data,

Line 2826: l_rcv_event RCV_SeedEvents_PVT.rcv_event_rec_type;

2822: l_msg_data VARCHAR2(8000) := '';
2823: l_stmt_num NUMBER := 0;
2824: l_api_message VARCHAR2(1000);
2825:
2826: l_rcv_event RCV_SeedEvents_PVT.rcv_event_rec_type;
2827: l_rcv_events_tbl RCV_SeedEvents_PVT.rcv_event_tbl_type;
2828: l_event_type_id NUMBER;
2829:
2830:

Line 2827: l_rcv_events_tbl RCV_SeedEvents_PVT.rcv_event_tbl_type;

2823: l_stmt_num NUMBER := 0;
2824: l_api_message VARCHAR2(1000);
2825:
2826: l_rcv_event RCV_SeedEvents_PVT.rcv_event_rec_type;
2827: l_rcv_events_tbl RCV_SeedEvents_PVT.rcv_event_tbl_type;
2828: l_event_type_id NUMBER;
2829:
2830:
2831: l_transaction_flows_tbl INV_TRANSACTION_FLOW_PUB.g_transaction_flow_tbl_type;

Line 3161: RCV_SeedEvents_PVT.Seed_RAEEvent(

3157: l_transfer_org_id := l_transaction_reverse_flow_rec.from_org_id;
3158: l_transfer_organization_id := l_transaction_reverse_flow_rec.from_organization_id;
3159: END IF;
3160:
3161: RCV_SeedEvents_PVT.Seed_RAEEvent(
3162: p_api_version => 1.0,
3163: x_return_status => l_return_status,
3164: x_msg_count => l_msg_count,
3165: x_msg_data => l_msg_data,

Line 3167: p_event_type_id => RCV_SeedEvents_PVT.LOGICAL_RETURN_TO_VENDOR,

3163: x_return_status => l_return_status,
3164: x_msg_count => l_msg_count,
3165: x_msg_data => l_msg_data,
3166: p_event_source => 'RECEIVING',
3167: p_event_type_id => RCV_SeedEvents_PVT.LOGICAL_RETURN_TO_VENDOR,
3168: p_rcv_transaction_id => p_rcv_transaction_id,
3169: p_inv_distribution_id => NULL,
3170: p_po_distribution_id => rec_pod.po_distribution_id,
3171: p_direct_delivery_flag => p_direct_delivery_flag,

Line 3210: RCV_SeedEvents_PVT.Seed_RAEEvent(

3206: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
3207: ,'Seeding Invoice Match in RAE');
3208: END IF;
3209:
3210: RCV_SeedEvents_PVT.Seed_RAEEvent(
3211: p_api_version => 1.0,
3212: x_return_status => l_return_status,
3213: x_msg_count => l_msg_count,
3214: x_msg_data => l_msg_data,

Line 3216: p_event_type_id => RCV_SeedEvents_PVT.INTERCOMPANY_REVERSAL,

3212: x_return_status => l_return_status,
3213: x_msg_count => l_msg_count,
3214: x_msg_data => l_msg_data,
3215: p_event_source => 'RECEIVING',
3216: p_event_type_id => RCV_SeedEvents_PVT.INTERCOMPANY_REVERSAL,
3217: p_rcv_transaction_id => p_rcv_transaction_id,
3218: p_inv_distribution_id => NULL,
3219: p_po_distribution_id => rec_pod.po_distribution_id,
3220: p_direct_delivery_flag => p_direct_delivery_flag,

Line 3274: SELECT decode(RT.transaction_type,'CORRECT',RCV_SeedEvents_PVT.CORRECT,

3270:
3271: -- The drop ship flag is not applicable in the case of returns. There will always
3272: -- be a physical receipt in the procuring org.
3273: l_stmt_num := 110;
3274: SELECT decode(RT.transaction_type,'CORRECT',RCV_SeedEvents_PVT.CORRECT,
3275: RCV_SeedEvents_PVT.RETURN_TO_VENDOR)
3276: INTO l_event_type_id
3277: FROM rcv_Transactions RT
3278: WHERE transaction_id = p_rcv_transaction_id;

Line 3275: RCV_SeedEvents_PVT.RETURN_TO_VENDOR)

3271: -- The drop ship flag is not applicable in the case of returns. There will always
3272: -- be a physical receipt in the procuring org.
3273: l_stmt_num := 110;
3274: SELECT decode(RT.transaction_type,'CORRECT',RCV_SeedEvents_PVT.CORRECT,
3275: RCV_SeedEvents_PVT.RETURN_TO_VENDOR)
3276: INTO l_event_type_id
3277: FROM rcv_Transactions RT
3278: WHERE transaction_id = p_rcv_transaction_id;
3279:

Line 3286: RCV_SeedEvents_PVT.Seed_RAEEvent(

3282: ,'Seeding RTV in RAE');
3283: END IF;
3284:
3285: l_stmt_num := 120;
3286: RCV_SeedEvents_PVT.Seed_RAEEvent(
3287: p_api_version => 1.0,
3288: x_return_status => l_return_status,
3289: x_msg_count => l_msg_count,
3290: x_msg_data => l_msg_data,

Line 3331: RCV_SeedEvents_PVT.Insert_RAEEvents(

3327: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3328: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
3329: ,'Inserting events into RAE');
3330: END IF;
3331: RCV_SeedEvents_PVT.Insert_RAEEvents(
3332: p_api_version => 1.0,
3333: x_return_status => l_return_status,
3334: x_msg_count => l_msg_count,
3335: x_msg_data => l_msg_data,

Line 3354: RCV_SeedEvents_PVT.Insert_MMTEvents(

3350: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3351: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
3352: ,'Inserting events into MMT');
3353: END IF;
3354: RCV_SeedEvents_PVT.Insert_MMTEvents(
3355: p_api_version => 1.0,
3356: x_return_status => l_return_status,
3357: x_msg_count => l_msg_count,
3358: x_msg_data => l_msg_data,

Line 3529: l_rcv_event RCV_SeedEvents_PVT.rcv_event_rec_type;

3525:
3526: l_qualifier_code_tbl INV_TRANSACTION_FLOW_PUB.NUMBER_TBL;
3527: l_qualifier_value_tbl INV_TRANSACTION_FLOW_PUB.NUMBER_TBL;
3528:
3529: l_rcv_event RCV_SeedEvents_PVT.rcv_event_rec_type;
3530: l_ic_pricing_option NUMBER := 1;
3531: l_unit_price NUMBER := 0;
3532: l_unit_landed_cost NUMBER := NULL;
3533: l_currency_code VARCHAR2(15) := NULL;

Line 3750: RCV_SeedEvents_PVT.Get_UnitPrice( p_api_version => l_api_version,

3746: l_rcv_event.po_line_location_id := l_po_line_location_id;
3747: l_rcv_event.set_of_books_id := l_rcv_sob_id;
3748:
3749: l_stmt_num := 60;
3750: RCV_SeedEvents_PVT.Get_UnitPrice( p_api_version => l_api_version,
3751: x_return_status => l_return_status,
3752: x_msg_count => l_msg_count,
3753: x_msg_data => l_msg_data,
3754: p_rcv_event => l_rcv_event,

Line 3787: RCV_SeedEvents_PVT.Get_Currency(

3783: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
3784: ,'Getting Currency Information');
3785: END IF;
3786: l_stmt_num :=70;
3787: RCV_SeedEvents_PVT.Get_Currency(
3788: p_api_version => l_api_version,
3789: x_return_status => l_return_status,
3790: x_msg_count => l_msg_count,
3791: x_msg_data => l_msg_data,