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.INV_MGD_MVT_STATS_PVT dependencies on FND_LOG

Line 101: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

97: l_return_status1 VARCHAR2(1);
98: l_return_status2 VARCHAR2(1);
99:
100: BEGIN
101: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
102: THEN
103: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
104: , G_MODULE_NAME || l_api_name || '.begin'
105: ,'enter procedure'

Line 103: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

99:
100: BEGIN
101: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
102: THEN
103: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
104: , G_MODULE_NAME || l_api_name || '.begin'
105: ,'enter procedure'
106: );
107: END IF;

Line 177: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

173:
174: --yawang fix bug 2268875
175: IF l_return_status1 <> 'S'
176: THEN
177: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
178: THEN
179: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
180: , G_MODULE_NAME || l_api_name
181: , 'Failed in calling default_attr '||substrb(x_msg_data,1,255)

Line 179: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

175: IF l_return_status1 <> 'S'
176: THEN
177: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
178: THEN
179: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
180: , G_MODULE_NAME || l_api_name
181: , 'Failed in calling default_attr '||substrb(x_msg_data,1,255)
182: );
183: END IF;

Line 188: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

184: END IF;
185:
186: IF l_return_status2 <> 'S'
187: THEN
188: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
189: THEN
190: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
191: , G_MODULE_NAME || l_api_name
192: , 'Failed in calling default_Value '||substrb(x_msg_data,1,255)

Line 190: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

186: IF l_return_status2 <> 'S'
187: THEN
188: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
189: THEN
190: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
191: , G_MODULE_NAME || l_api_name
192: , 'Failed in calling default_Value '||substrb(x_msg_data,1,255)
193: );
194: END IF;

Line 503: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

499:
500: g_movement_id := l_parent_movement_id;
501: g_parent_movement_id := nvl(l_movement_id,l_parent_movement_id);
502:
503: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
504: THEN
505: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
506: , G_MODULE_NAME || l_api_name
507: , 'Insert movement record successfully'

Line 505: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

501: g_parent_movement_id := nvl(l_movement_id,l_parent_movement_id);
502:
503: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
504: THEN
505: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
506: , G_MODULE_NAME || l_api_name
507: , 'Insert movement record successfully'
508: );
509: END IF;

Line 516: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

512: x_movement_transaction := l_movement_transaction;
513: x_movement_transaction.movement_id := g_movement_id;
514: END IF;
515:
516: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
517: THEN
518: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
519: , G_MODULE_NAME || l_api_name || '.end'
520: ,'exit procedure'

Line 518: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

514: END IF;
515:
516: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
517: THEN
518: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
519: , G_MODULE_NAME || l_api_name || '.end'
520: ,'exit procedure'
521: );
522: END IF;

Line 590: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

586: )
587: IS
588: l_api_name CONSTANT VARCHAR2(30) := 'Init_Movement_Record';
589: BEGIN
590: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
591: THEN
592: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
593: , G_MODULE_NAME || l_api_name || '.begin'
594: ,'enter procedure'

Line 592: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

588: l_api_name CONSTANT VARCHAR2(30) := 'Init_Movement_Record';
589: BEGIN
590: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
591: THEN
592: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
593: , G_MODULE_NAME || l_api_name || '.begin'
594: ,'enter procedure'
595: );
596: END IF;

Line 617: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

613: x_movement_transaction.statistical_procedure_code := NULL;
614: x_movement_transaction.transport_mode := '3';
615: x_movement_transaction.financial_document_flag := 'NOT_REQUIRED';
616:
617: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
618: THEN
619: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
620: , G_MODULE_NAME || l_api_name || '.end'
621: ,'exit procedure'

Line 619: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

615: x_movement_transaction.financial_document_flag := 'NOT_REQUIRED';
616:
617: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
618: THEN
619: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
620: , G_MODULE_NAME || l_api_name || '.end'
621: ,'exit procedure'
622: );
623: END IF;

Line 652: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

648: )
649: IS
650: l_api_name CONSTANT VARCHAR2(30) := 'Get_Open_Mvmt_Stats_Txns';
651: BEGIN
652: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
653: THEN
654: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
655: , G_MODULE_NAME || l_api_name || '.begin'
656: ,'enter procedure'

Line 654: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

650: l_api_name CONSTANT VARCHAR2(30) := 'Get_Open_Mvmt_Stats_Txns';
651: BEGIN
652: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
653: THEN
654: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
655: , G_MODULE_NAME || l_api_name || '.begin'
656: ,'enter procedure'
657: );
658: END IF;

Line 827: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

823: AND (movement_status = 'O' OR (financial_document_flag = 'MISSING'))
824: ORDER BY
825: mtl_stats.movement_id;
826:
827: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
828: THEN
829: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
830: , G_MODULE_NAME || l_api_name || '.end'
831: ,'exit procedure'

Line 829: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

825: mtl_stats.movement_id;
826:
827: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
828: THEN
829: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
830: , G_MODULE_NAME || l_api_name || '.end'
831: ,'exit procedure'
832: );
833: END IF;

Line 872: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

868: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
869: l_return_status1 VARCHAR2(1);
870: l_return_status2 VARCHAR2(1);
871: BEGIN
872: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
873: THEN
874: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
875: , G_MODULE_NAME || l_api_name || '.begin'
876: ,'enter procedure'

Line 874: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

870: l_return_status2 VARCHAR2(1);
871: BEGIN
872: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
873: THEN
874: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
875: , G_MODULE_NAME || l_api_name || '.begin'
876: ,'enter procedure'
877: );
878: END IF;

Line 922: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

918: , x_return_status => l_return_status2
919: );
920: IF l_return_status1 <> 'S'
921: THEN
922: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
923: THEN
924: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
925: , G_MODULE_NAME || l_api_name
926: , 'Failed in calling default_attr '||substrb(x_msg_data,1,255)

Line 924: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

920: IF l_return_status1 <> 'S'
921: THEN
922: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
923: THEN
924: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
925: , G_MODULE_NAME || l_api_name
926: , 'Failed in calling default_attr '||substrb(x_msg_data,1,255)
927: );
928: END IF;

Line 933: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

929: END IF;
930:
931: IF l_return_status2 <> 'S'
932: THEN
933: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
934: THEN
935: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
936: , G_MODULE_NAME || l_api_name
937: , 'Failed in calling default_Value '||substrb(x_msg_data,1,255)

Line 935: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

931: IF l_return_status2 <> 'S'
932: THEN
933: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
934: THEN
935: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
936: , G_MODULE_NAME || l_api_name
937: , 'Failed in calling default_Value '||substrb(x_msg_data,1,255)
938: );
939: END IF;

Line 1109: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1105: , customer_vat_number = P_MOVEMENT_STATISTICS.customer_vat_number
1106: WHERE movement_id = P_MOVEMENT_STATISTICS.movement_id;
1107:
1108: COMMIT ;
1109: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1110: THEN
1111: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1112: , G_MODULE_NAME || l_api_name || '.end'
1113: ,'exit procedure'

Line 1111: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1107:
1108: COMMIT ;
1109: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1110: THEN
1111: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1112: , G_MODULE_NAME || l_api_name || '.end'
1113: ,'exit procedure'
1114: );
1115: END IF;

Line 1259: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1255: l_corrected VARCHAR2(1);
1256: validate_rule_flag VARCHAR2(1);
1257:
1258: BEGIN
1259: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1260: THEN
1261: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1262: , G_MODULE_NAME || l_api_name || '.begin'
1263: ,'enter procedure'

Line 1261: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1257:
1258: BEGIN
1259: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1260: THEN
1261: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1262: , G_MODULE_NAME || l_api_name || '.begin'
1263: ,'enter procedure'
1264: );
1265: END IF;

Line 1427: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1423: -- record updated
1424: x_updated_flag :='Y';
1425:
1426: -- report exception for MISSING invoice
1427: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1428: THEN
1429: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1430: , G_MODULE_NAME || l_api_name
1431: ,'Exception: invoice missing'

Line 1429: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1425:
1426: -- report exception for MISSING invoice
1427: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1428: THEN
1429: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1430: , G_MODULE_NAME || l_api_name
1431: ,'Exception: invoice missing'
1432: );
1433: END IF;

Line 1574: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1570: -- (the magic of get invoice info is it update exchange rate information
1571: -- whether or not the invoice is available)
1572: IF l_orig_mvmt_transaction.currency_conversion_rate = 0
1573: THEN
1574: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1575: THEN
1576: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1577: , G_MODULE_NAME || l_api_name
1578: ,'Exception: currency_conversion_rate missing'

Line 1576: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1572: IF l_orig_mvmt_transaction.currency_conversion_rate = 0
1573: THEN
1574: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1575: THEN
1576: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1577: , G_MODULE_NAME || l_api_name
1578: ,'Exception: currency_conversion_rate missing'
1579: );
1580: END IF;

Line 1630: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1626: x_excp_list := g_final_excp_list;
1627: g_final_excp_list.DELETE;
1628: x_movement_statistics := l_orig_mvmt_transaction;
1629:
1630: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1631: THEN
1632: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1633: , G_MODULE_NAME || l_api_name || '.end'
1634: ,'exit procedure'

Line 1632: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1628: x_movement_statistics := l_orig_mvmt_transaction;
1629:
1630: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1631: THEN
1632: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1633: , G_MODULE_NAME || l_api_name || '.end'
1634: ,'exit procedure'
1635: );
1636: END IF;

Line 1703: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1699: l_total_weight NUMBER;
1700: l_rounding_method VARCHAR2(30);
1701:
1702: BEGIN
1703: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1704: THEN
1705: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1706: , G_MODULE_NAME || l_api_name || '.begin'
1707: ,'enter procedure'

Line 1705: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1701:
1702: BEGIN
1703: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1704: THEN
1705: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1706: , G_MODULE_NAME || l_api_name || '.begin'
1707: ,'enter procedure'
1708: );
1709: END IF;

Line 1859: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1855: END IF;
1856:
1857: x_movement_statistics := l_orig_mvmt_transaction;
1858:
1859: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1860: THEN
1861: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1862: , G_MODULE_NAME || l_api_name || '.end'
1863: ,'exit procedure'

Line 1861: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1857: x_movement_statistics := l_orig_mvmt_transaction;
1858:
1859: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1860: THEN
1861: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1862: , G_MODULE_NAME || l_api_name || '.end'
1863: ,'exit procedure'
1864: );
1865: END IF;

Line 1978: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1974: l_mvt_transaction_rec INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1975: l_api_name CONSTANT VARCHAR2(30) := 'Partner_vat_number';
1976:
1977: BEGIN
1978: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1979: THEN
1980: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1981: , G_MODULE_NAME || l_api_name || '.begin'
1982: ,'enter procedure'

Line 1980: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1976:
1977: BEGIN
1978: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1979: THEN
1980: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1981: , G_MODULE_NAME || l_api_name || '.begin'
1982: ,'enter procedure'
1983: );
1984: END IF;

Line 1992: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1988:
1989: l_mvt_transaction_rec:=p_mvt_transaction_rec;
1990:
1991: ----check if the value matches any of the value in the lookup table
1992: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1993: THEN
1994: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1995: , G_MODULE_NAME || l_api_name
1996: ,'check if the value matches any of the value in the lookup table'

Line 1994: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1990:
1991: ----check if the value matches any of the value in the lookup table
1992: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1993: THEN
1994: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1995: , G_MODULE_NAME || l_api_name
1996: ,'check if the value matches any of the value in the lookup table'
1997: );
1998: END IF;

Line 2008: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2004: AND lookup_code = p_rule_field_value;
2005:
2006: IF l_count=0
2007: THEN
2008: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2009: THEN
2010: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2011: , G_MODULE_NAME || l_api_name
2012: , 'No,the value does not matches any of the values in the lookup table,

Line 2010: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

2006: IF l_count=0
2007: THEN
2008: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2009: THEN
2010: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2011: , G_MODULE_NAME || l_api_name
2012: , 'No,the value does not matches any of the values in the lookup table,
2013: get the value from the appropiate form'
2014: );

Line 2027: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2023: l_form_vat_value:=INV_MGD_MVT_UTILS_PKG.Get_Cust_VAT_Number
2024: ( p_site_use_id => p_mvt_transaction_rec.bill_to_site_use_id
2025: );
2026:
2027: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2028: THEN
2029: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2030: , G_MODULE_NAME || l_api_name
2031: , 'partner=customer, VAT='||l_form_vat_value

Line 2029: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

2025: );
2026:
2027: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2028: THEN
2029: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2030: , G_MODULE_NAME || l_api_name
2031: , 'partner=customer, VAT='||l_form_vat_value
2032: );
2033: END IF;

Line 2045: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2041: );
2042:
2043: l_form_vat_value:=l_mvt_transaction_rec.customer_vat_number;
2044:
2045: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2046: THEN
2047: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2048: , G_MODULE_NAME || l_api_name
2049: , 'partner=vendor, VAT='||l_form_vat_value

Line 2047: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

2043: l_form_vat_value:=l_mvt_transaction_rec.customer_vat_number;
2044:
2045: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2046: THEN
2047: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2048: , G_MODULE_NAME || l_api_name
2049: , 'partner=vendor, VAT='||l_form_vat_value
2050: );
2051: END IF;

Line 2060: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2056: l_form_vat_value :=INV_MGD_MVT_UTILS_PKG.Get_Org_VAT_Number
2057: ( p_entity_org_id => p_mvt_transaction_rec.entity_org_id
2058: , p_date => p_mvt_transaction_rec.transaction_date);
2059:
2060: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2061: THEN
2062: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2063: , G_MODULE_NAME || l_api_name
2064: , 'partner=organization, VAT='||l_form_vat_value

Line 2062: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

2058: , p_date => p_mvt_transaction_rec.transaction_date);
2059:
2060: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2061: THEN
2062: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2063: , G_MODULE_NAME || l_api_name
2064: , 'partner=organization, VAT='||l_form_vat_value
2065: );
2066: END IF;

Line 2086: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2082: ,p_message_cd => 1
2083: );
2084: x_return_status := FND_API.G_RET_STS_ERROR;
2085:
2086: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2087: THEN
2088: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2089: , G_MODULE_NAME || l_api_name
2090: , 'The value in the form does not match to any of the lookup values, this is the exception'

Line 2088: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

2084: x_return_status := FND_API.G_RET_STS_ERROR;
2085:
2086: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2087: THEN
2088: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2089: , G_MODULE_NAME || l_api_name
2090: , 'The value in the form does not match to any of the lookup values, this is the exception'
2091: );
2092: END IF;

Line 2100: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2096: UPDATE mtl_movement_statistics
2097: SET customer_vat_number=l_form_vat_value
2098: WHERE movement_id=p_mvt_transaction_rec.movement_id;
2099:
2100: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2101: THEN
2102: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2103: , G_MODULE_NAME || l_api_name
2104: , 'The value in the form matches one of the lookup value,

Line 2102: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

2098: WHERE movement_id=p_mvt_transaction_rec.movement_id;
2099:
2100: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2101: THEN
2102: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2103: , G_MODULE_NAME || l_api_name
2104: , 'The value in the form matches one of the lookup value,
2105: correct value in the mvt_statistics table.'
2106: );

Line 2111: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2107: END IF;
2108: END IF;
2109: END IF;
2110:
2111: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2112: THEN
2113: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2114: , G_MODULE_NAME || l_api_name || '.end'
2115: ,'exit procedure'

Line 2113: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2109: END IF;
2110:
2111: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2112: THEN
2113: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2114: , G_MODULE_NAME || l_api_name || '.end'
2115: ,'exit procedure'
2116: );
2117: END IF;

Line 2179: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2175: WHERE RULE_SET_CODE = p_movement_stat_usages_rec.Attribute_rule_set_code
2176: AND SOURCE_TYPE = x_movement_transaction.document_source_type;
2177:
2178: BEGIN
2179: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2180: THEN
2181: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2182: , G_MODULE_NAME || l_api_name || '.begin'
2183: ,'enter procedure'

Line 2181: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2177:
2178: BEGIN
2179: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2180: THEN
2181: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2182: , G_MODULE_NAME || l_api_name || '.begin'
2183: ,'enter procedure'
2184: );
2185: END IF;

Line 2196: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2192:
2193: -- Init x_return_status
2194: x_return_status := FND_API.G_RET_STS_SUCCESS;
2195:
2196: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2197: THEN
2198: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2199: , G_MODULE_NAME || l_api_name
2200: , 'RULE_SET_CODE= '||p_movement_stat_usages_rec.Attribute_rule_set_code

Line 2198: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

2194: x_return_status := FND_API.G_RET_STS_SUCCESS;
2195:
2196: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2197: THEN
2198: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2199: , G_MODULE_NAME || l_api_name
2200: , 'RULE_SET_CODE= '||p_movement_stat_usages_rec.Attribute_rule_set_code
2201: );
2202: END IF;

Line 2246: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2242: Rule_Field_Value := l_orig_mvmt_transaction.CUSTOMER_VAT_NUMBER;
2243: ELSE Rule_Field_Value := NULL;
2244: END IF;
2245:
2246: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2247: THEN
2248: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2249: , G_MODULE_NAME || l_api_name
2250: , 'Rules_rec.attribute_code= '||Rules_rec.attribute_code

Line 2248: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

2244: END IF;
2245:
2246: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2247: THEN
2248: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2249: , G_MODULE_NAME || l_api_name
2250: , 'Rules_rec.attribute_code= '||Rules_rec.attribute_code
2251: );
2252: END IF;

Line 2254: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2250: , 'Rules_rec.attribute_code= '||Rules_rec.attribute_code
2251: );
2252: END IF;
2253:
2254: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2255: THEN
2256: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2257: , G_MODULE_NAME || l_api_name
2258: , 'Rule_Field_Value= '||Rule_Field_Value

Line 2256: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

2252: END IF;
2253:
2254: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2255: THEN
2256: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2257: , G_MODULE_NAME || l_api_name
2258: , 'Rule_Field_Value= '||Rule_Field_Value
2259: );
2260: END IF;

Line 2262: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2258: , 'Rule_Field_Value= '||Rule_Field_Value
2259: );
2260: END IF;
2261:
2262: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2263: THEN
2264: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2265: , G_MODULE_NAME || l_api_name
2266: , 'Rules_rec.Attribute_property_Code= '||Rules_rec.Attribute_property_Code

Line 2264: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

2260: END IF;
2261:
2262: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2263: THEN
2264: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2265: , G_MODULE_NAME || l_api_name
2266: , 'Rules_rec.Attribute_property_Code= '||Rules_rec.Attribute_property_Code
2267: );
2268: END IF;

Line 2278: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2274: -- Need to raise an exception only for REQUIRED fields
2275: IF Rules_rec.Attribute_property_Code = 'REQUIRED_UPDATEABLE'
2276: OR Rules_rec.Attribute_property_Code = 'REQUIRED_NON_UPDATEABLE'
2277: THEN
2278: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2279: THEN
2280: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2281: , G_MODULE_NAME || l_api_name
2282: , 'Exception for '||Rules_rec.attribute_code

Line 2280: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

2276: OR Rules_rec.Attribute_property_Code = 'REQUIRED_NON_UPDATEABLE'
2277: THEN
2278: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2279: THEN
2280: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2281: , G_MODULE_NAME || l_api_name
2282: , 'Exception for '||Rules_rec.attribute_code
2283: );
2284: END IF;

Line 2297: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2293: , p_attribute_code => Rules_rec.attribute_code
2294: , x_return_status => l_return_status
2295: );
2296:
2297: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2298: THEN
2299: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2300: , G_MODULE_NAME || l_api_name
2301: , 'out of Partner_vat_number with status '||l_return_status

Line 2299: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

2295: );
2296:
2297: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2298: THEN
2299: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2300: , G_MODULE_NAME || l_api_name
2301: , 'out of Partner_vat_number with status '||l_return_status
2302: );
2303: END IF;

Line 2328: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2324:
2325: -----for Trading Partner VAT
2326: IF Rules_rec.attribute_code='PARTNER_VAT_NUMBER'
2327: THEN
2328: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2329: THEN
2330: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2331: , G_MODULE_NAME || l_api_name
2332: , 'Rules_rec.attribute_code='||Rules_rec.attribute_code

Line 2330: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

2326: IF Rules_rec.attribute_code='PARTNER_VAT_NUMBER'
2327: THEN
2328: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2329: THEN
2330: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2331: , G_MODULE_NAME || l_api_name
2332: , 'Rules_rec.attribute_code='||Rules_rec.attribute_code
2333: );
2334: END IF;

Line 2343: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2339: , p_attribute_code => Rules_rec.attribute_code
2340: , x_return_status => l_return_status
2341: );
2342:
2343: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2344: THEN
2345: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2346: , G_MODULE_NAME || l_api_name
2347: , 'out of Partner_vat_number with status '||l_return_status

Line 2345: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

2341: );
2342:
2343: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2344: THEN
2345: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2346: , G_MODULE_NAME || l_api_name
2347: , 'out of Partner_vat_number with status '||l_return_status
2348: );
2349: END IF;

Line 2413: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2409:
2410:
2411: x_movement_transaction := l_orig_mvmt_transaction;
2412:
2413: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2414: THEN
2415: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2416: , G_MODULE_NAME || l_api_name || '.end'
2417: ,'exit procedure'

Line 2415: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2411: x_movement_transaction := l_orig_mvmt_transaction;
2412:
2413: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2414: THEN
2415: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2416: , G_MODULE_NAME || l_api_name || '.end'
2417: ,'exit procedure'
2418: );
2419: END IF;

Line 2454: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2450: )
2451: IS
2452: l_api_name CONSTANT VARCHAR2(30) := 'Get_Invoice_Transactions';
2453: BEGIN
2454: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2455: THEN
2456: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2457: , G_MODULE_NAME || l_api_name || '.begin'
2458: ,'enter procedure'

Line 2456: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2452: l_api_name CONSTANT VARCHAR2(30) := 'Get_Invoice_Transactions';
2453: BEGIN
2454: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2455: THEN
2456: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2457: , G_MODULE_NAME || l_api_name || '.begin'
2458: ,'enter procedure'
2459: );
2460: END IF;

Line 2627: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2623: AND movement_status in ('O','V')
2624: AND financial_document_flag <> 'NOT_REQUIRED'
2625: ORDER BY mtl_stats.movement_id;
2626:
2627: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2628: THEN
2629: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2630: , G_MODULE_NAME || l_api_name || '.end'
2631: ,'exit procedure'

Line 2629: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2625: ORDER BY mtl_stats.movement_id;
2626:
2627: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2628: THEN
2629: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2630: , G_MODULE_NAME || l_api_name || '.end'
2631: ,'exit procedure'
2632: );
2633: END IF;

Line 2665: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2661: )
2662: IS
2663: l_api_name CONSTANT VARCHAR2(30) := 'Get_PO_Trans_With_Correction';
2664: BEGIN
2665: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2666: THEN
2667: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2668: , G_MODULE_NAME || l_api_name || '.begin'
2669: ,'enter procedure'

Line 2667: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2663: l_api_name CONSTANT VARCHAR2(30) := 'Get_PO_Trans_With_Correction';
2664: BEGIN
2665: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2666: THEN
2667: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2668: , G_MODULE_NAME || l_api_name || '.begin'
2669: ,'enter procedure'
2670: );
2671: END IF;

Line 2842: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2838: WHERE mvt_stat_status = 'NEW'
2839: AND transaction_type = 'CORRECT')
2840: ORDER BY mtl_stats.movement_id;
2841:
2842: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2843: THEN
2844: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2845: , G_MODULE_NAME || l_api_name || '.end'
2846: ,'exit procedure'

Line 2844: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2840: ORDER BY mtl_stats.movement_id;
2841:
2842: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2843: THEN
2844: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2845: , G_MODULE_NAME || l_api_name || '.end'
2846: ,'exit procedure'
2847: );
2848: END IF;

Line 2878: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2874: )
2875: IS
2876: l_api_name CONSTANT VARCHAR2(30) := 'Get_Pending_Txns';
2877: BEGIN
2878: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2879: THEN
2880: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2881: , G_MODULE_NAME || l_api_name || '.begin'
2882: ,'enter procedure'

Line 2880: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2876: l_api_name CONSTANT VARCHAR2(30) := 'Get_Pending_Txns';
2877: BEGIN
2878: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2879: THEN
2880: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2881: , G_MODULE_NAME || l_api_name || '.begin'
2882: ,'enter procedure'
2883: );
2884: END IF;

Line 3049: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3045: AND movement_status = 'P'
3046: ORDER BY
3047: mtl_stats.movement_id;
3048:
3049: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3050: THEN
3051: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3052: , G_MODULE_NAME || l_api_name || '.end'
3053: ,'exit procedure'

Line 3051: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3047: mtl_stats.movement_id;
3048:
3049: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3050: THEN
3051: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3052: , G_MODULE_NAME || l_api_name || '.end'
3053: ,'exit procedure'
3054: );
3055: END IF;