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 197: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

193:
194: --yawang fix bug 2268875
195: IF l_return_status1 <> 'S'
196: THEN
197: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
198: THEN
199: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
200: , G_MODULE_NAME || l_api_name
201: , 'Failed in calling default_attr '||substrb(x_msg_data,1,255)

Line 199: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

195: IF l_return_status1 <> 'S'
196: THEN
197: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
198: THEN
199: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
200: , G_MODULE_NAME || l_api_name
201: , 'Failed in calling default_attr '||substrb(x_msg_data,1,255)
202: );
203: END IF;

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

204: END IF;
205:
206: IF l_return_status2 <> 'S'
207: THEN
208: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
209: THEN
210: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
211: , G_MODULE_NAME || l_api_name
212: , 'Failed in calling default_Value '||substrb(x_msg_data,1,255)

Line 210: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

206: IF l_return_status2 <> 'S'
207: THEN
208: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
209: THEN
210: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
211: , G_MODULE_NAME || l_api_name
212: , 'Failed in calling default_Value '||substrb(x_msg_data,1,255)
213: );
214: END IF;

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

519:
520: g_movement_id := l_parent_movement_id;
521: g_parent_movement_id := nvl(l_movement_id,l_parent_movement_id);
522:
523: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
524: THEN
525: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
526: , G_MODULE_NAME || l_api_name
527: , 'Insert movement record successfully'

Line 525: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

521: g_parent_movement_id := nvl(l_movement_id,l_parent_movement_id);
522:
523: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
524: THEN
525: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
526: , G_MODULE_NAME || l_api_name
527: , 'Insert movement record successfully'
528: );
529: END IF;

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

532: x_movement_transaction := l_movement_transaction;
533: x_movement_transaction.movement_id := g_movement_id;
534: END IF;
535:
536: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
537: THEN
538: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
539: , G_MODULE_NAME || l_api_name || '.end'
540: ,'exit procedure'

Line 538: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

534: END IF;
535:
536: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
537: THEN
538: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
539: , G_MODULE_NAME || l_api_name || '.end'
540: ,'exit procedure'
541: );
542: END IF;

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

606: )
607: IS
608: l_api_name CONSTANT VARCHAR2(30) := 'Init_Movement_Record';
609: BEGIN
610: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
611: THEN
612: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
613: , G_MODULE_NAME || l_api_name || '.begin'
614: ,'enter procedure'

Line 612: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

608: l_api_name CONSTANT VARCHAR2(30) := 'Init_Movement_Record';
609: BEGIN
610: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
611: THEN
612: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
613: , G_MODULE_NAME || l_api_name || '.begin'
614: ,'enter procedure'
615: );
616: END IF;

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

633: x_movement_transaction.statistical_procedure_code := NULL;
634: x_movement_transaction.transport_mode := '3';
635: x_movement_transaction.financial_document_flag := 'NOT_REQUIRED';
636:
637: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
638: THEN
639: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
640: , G_MODULE_NAME || l_api_name || '.end'
641: ,'exit procedure'

Line 639: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

635: x_movement_transaction.financial_document_flag := 'NOT_REQUIRED';
636:
637: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
638: THEN
639: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
640: , G_MODULE_NAME || l_api_name || '.end'
641: ,'exit procedure'
642: );
643: END IF;

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

668: )
669: IS
670: l_api_name CONSTANT VARCHAR2(30) := 'Get_Open_Mvmt_Stats_Txns';
671: BEGIN
672: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
673: THEN
674: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
675: , G_MODULE_NAME || l_api_name || '.begin'
676: ,'enter procedure'

Line 674: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

670: l_api_name CONSTANT VARCHAR2(30) := 'Get_Open_Mvmt_Stats_Txns';
671: BEGIN
672: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
673: THEN
674: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
675: , G_MODULE_NAME || l_api_name || '.begin'
676: ,'enter procedure'
677: );
678: END IF;

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

843: AND (movement_status = 'O' OR (financial_document_flag = 'MISSING'))
844: ORDER BY
845: mtl_stats.movement_id;
846:
847: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
848: THEN
849: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
850: , G_MODULE_NAME || l_api_name || '.end'
851: ,'exit procedure'

Line 849: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

845: mtl_stats.movement_id;
846:
847: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
848: THEN
849: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
850: , G_MODULE_NAME || l_api_name || '.end'
851: ,'exit procedure'
852: );
853: END IF;

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

888: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
889: l_return_status1 VARCHAR2(1);
890: l_return_status2 VARCHAR2(1);
891: BEGIN
892: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
893: THEN
894: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
895: , G_MODULE_NAME || l_api_name || '.begin'
896: ,'enter procedure'

Line 894: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

890: l_return_status2 VARCHAR2(1);
891: BEGIN
892: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
893: THEN
894: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
895: , G_MODULE_NAME || l_api_name || '.begin'
896: ,'enter procedure'
897: );
898: END IF;

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

958: , x_return_status => l_return_status2
959: );
960: IF l_return_status1 <> 'S'
961: THEN
962: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
963: THEN
964: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
965: , G_MODULE_NAME || l_api_name
966: , 'Failed in calling default_attr '||substrb(x_msg_data,1,255)

Line 964: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

960: IF l_return_status1 <> 'S'
961: THEN
962: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
963: THEN
964: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
965: , G_MODULE_NAME || l_api_name
966: , 'Failed in calling default_attr '||substrb(x_msg_data,1,255)
967: );
968: END IF;

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

969: END IF;
970:
971: IF l_return_status2 <> 'S'
972: THEN
973: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
974: THEN
975: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
976: , G_MODULE_NAME || l_api_name
977: , 'Failed in calling default_Value '||substrb(x_msg_data,1,255)

Line 975: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

971: IF l_return_status2 <> 'S'
972: THEN
973: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
974: THEN
975: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
976: , G_MODULE_NAME || l_api_name
977: , 'Failed in calling default_Value '||substrb(x_msg_data,1,255)
978: );
979: END IF;

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

1145: , customer_vat_number = P_MOVEMENT_STATISTICS.customer_vat_number
1146: WHERE movement_id = P_MOVEMENT_STATISTICS.movement_id;
1147:
1148: COMMIT ;
1149: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1150: THEN
1151: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1152: , G_MODULE_NAME || l_api_name || '.end'
1153: ,'exit procedure'

Line 1151: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1147:
1148: COMMIT ;
1149: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1150: THEN
1151: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1152: , G_MODULE_NAME || l_api_name || '.end'
1153: ,'exit procedure'
1154: );
1155: END IF;

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

1295: l_corrected VARCHAR2(1);
1296: validate_rule_flag VARCHAR2(1);
1297:
1298: BEGIN
1299: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1300: THEN
1301: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1302: , G_MODULE_NAME || l_api_name || '.begin'
1303: ,'enter procedure'

Line 1301: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1297:
1298: BEGIN
1299: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1300: THEN
1301: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1302: , G_MODULE_NAME || l_api_name || '.begin'
1303: ,'enter procedure'
1304: );
1305: END IF;

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

1463: -- record updated
1464: x_updated_flag :='Y';
1465:
1466: -- report exception for MISSING invoice
1467: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1468: THEN
1469: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1470: , G_MODULE_NAME || l_api_name
1471: ,'Exception: invoice missing'

Line 1469: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1465:
1466: -- report exception for MISSING invoice
1467: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1468: THEN
1469: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1470: , G_MODULE_NAME || l_api_name
1471: ,'Exception: invoice missing'
1472: );
1473: END IF;

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

1610: -- (the magic of get invoice info is it update exchange rate information
1611: -- whether or not the invoice is available)
1612: IF l_orig_mvmt_transaction.currency_conversion_rate = 0
1613: THEN
1614: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1615: THEN
1616: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1617: , G_MODULE_NAME || l_api_name
1618: ,'Exception: currency_conversion_rate missing'

Line 1616: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1612: IF l_orig_mvmt_transaction.currency_conversion_rate = 0
1613: THEN
1614: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1615: THEN
1616: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1617: , G_MODULE_NAME || l_api_name
1618: ,'Exception: currency_conversion_rate missing'
1619: );
1620: END IF;

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

1666: x_excp_list := g_final_excp_list;
1667: g_final_excp_list.DELETE;
1668: x_movement_statistics := l_orig_mvmt_transaction;
1669:
1670: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1671: THEN
1672: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1673: , G_MODULE_NAME || l_api_name || '.end'
1674: ,'exit procedure'

Line 1672: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1668: x_movement_statistics := l_orig_mvmt_transaction;
1669:
1670: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1671: THEN
1672: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1673: , G_MODULE_NAME || l_api_name || '.end'
1674: ,'exit procedure'
1675: );
1676: END IF;

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

1739: l_total_weight NUMBER;
1740: l_rounding_method VARCHAR2(30);
1741:
1742: BEGIN
1743: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1744: THEN
1745: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1746: , G_MODULE_NAME || l_api_name || '.begin'
1747: ,'enter procedure'

Line 1745: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1741:
1742: BEGIN
1743: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1744: THEN
1745: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1746: , G_MODULE_NAME || l_api_name || '.begin'
1747: ,'enter procedure'
1748: );
1749: END IF;

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

1895: END IF;
1896:
1897: x_movement_statistics := l_orig_mvmt_transaction;
1898:
1899: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1900: THEN
1901: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1902: , G_MODULE_NAME || l_api_name || '.end'
1903: ,'exit procedure'

Line 1901: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1897: x_movement_statistics := l_orig_mvmt_transaction;
1898:
1899: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1900: THEN
1901: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1902: , G_MODULE_NAME || l_api_name || '.end'
1903: ,'exit procedure'
1904: );
1905: END IF;

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

2014: l_mvt_transaction_rec INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
2015: l_api_name CONSTANT VARCHAR2(30) := 'Partner_vat_number';
2016:
2017: BEGIN
2018: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2019: THEN
2020: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2021: , G_MODULE_NAME || l_api_name || '.begin'
2022: ,'enter procedure'

Line 2020: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2016:
2017: BEGIN
2018: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2019: THEN
2020: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2021: , G_MODULE_NAME || l_api_name || '.begin'
2022: ,'enter procedure'
2023: );
2024: END IF;

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

2028:
2029: l_mvt_transaction_rec:=p_mvt_transaction_rec;
2030:
2031: ----check if the value matches any of the value in the lookup table
2032: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2033: THEN
2034: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2035: , G_MODULE_NAME || l_api_name
2036: ,'check if the value matches any of the value in the lookup table'

Line 2034: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

2030:
2031: ----check if the value matches any of the value in the lookup table
2032: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2033: THEN
2034: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2035: , G_MODULE_NAME || l_api_name
2036: ,'check if the value matches any of the value in the lookup table'
2037: );
2038: END IF;

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

2044: AND lookup_code = p_rule_field_value;
2045:
2046: IF l_count=0
2047: THEN
2048: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2049: THEN
2050: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2051: , G_MODULE_NAME || l_api_name
2052: , 'No,the value does not matches any of the values in the lookup table,

Line 2050: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

2046: IF l_count=0
2047: THEN
2048: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2049: THEN
2050: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2051: , G_MODULE_NAME || l_api_name
2052: , 'No,the value does not matches any of the values in the lookup table,
2053: get the value from the appropiate form'
2054: );

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

2063: l_form_vat_value:=INV_MGD_MVT_UTILS_PKG.Get_Cust_VAT_Number
2064: ( p_site_use_id => p_mvt_transaction_rec.bill_to_site_use_id
2065: );
2066:
2067: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2068: THEN
2069: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2070: , G_MODULE_NAME || l_api_name
2071: , 'partner=customer, VAT='||l_form_vat_value

Line 2069: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

2065: );
2066:
2067: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2068: THEN
2069: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2070: , G_MODULE_NAME || l_api_name
2071: , 'partner=customer, VAT='||l_form_vat_value
2072: );
2073: END IF;

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

2081: );
2082:
2083: l_form_vat_value:=l_mvt_transaction_rec.customer_vat_number;
2084:
2085: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2086: THEN
2087: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2088: , G_MODULE_NAME || l_api_name
2089: , 'partner=vendor, VAT='||l_form_vat_value

Line 2087: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

2083: l_form_vat_value:=l_mvt_transaction_rec.customer_vat_number;
2084:
2085: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2086: THEN
2087: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2088: , G_MODULE_NAME || l_api_name
2089: , 'partner=vendor, VAT='||l_form_vat_value
2090: );
2091: END IF;

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

2096: l_form_vat_value :=INV_MGD_MVT_UTILS_PKG.Get_Org_VAT_Number
2097: ( p_entity_org_id => p_mvt_transaction_rec.entity_org_id
2098: , p_date => p_mvt_transaction_rec.transaction_date);
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: , 'partner=organization, VAT='||l_form_vat_value

Line 2102: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

2098: , p_date => p_mvt_transaction_rec.transaction_date);
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: , 'partner=organization, VAT='||l_form_vat_value
2105: );
2106: END IF;

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

2122: ,p_message_cd => 1
2123: );
2124: x_return_status := FND_API.G_RET_STS_ERROR;
2125:
2126: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2127: THEN
2128: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2129: , G_MODULE_NAME || l_api_name
2130: , 'The value in the form does not match to any of the lookup values, this is the exception'

Line 2128: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

2124: x_return_status := FND_API.G_RET_STS_ERROR;
2125:
2126: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2127: THEN
2128: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2129: , G_MODULE_NAME || l_api_name
2130: , 'The value in the form does not match to any of the lookup values, this is the exception'
2131: );
2132: END IF;

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

2136: UPDATE mtl_movement_statistics
2137: SET customer_vat_number=l_form_vat_value
2138: WHERE movement_id=p_mvt_transaction_rec.movement_id;
2139:
2140: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2141: THEN
2142: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2143: , G_MODULE_NAME || l_api_name
2144: , 'The value in the form matches one of the lookup value,

Line 2142: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

2138: WHERE movement_id=p_mvt_transaction_rec.movement_id;
2139:
2140: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2141: THEN
2142: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2143: , G_MODULE_NAME || l_api_name
2144: , 'The value in the form matches one of the lookup value,
2145: correct value in the mvt_statistics table.'
2146: );

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

2147: END IF;
2148: END IF;
2149: END IF;
2150:
2151: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2152: THEN
2153: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2154: , G_MODULE_NAME || l_api_name || '.end'
2155: ,'exit procedure'

Line 2153: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2149: END IF;
2150:
2151: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2152: THEN
2153: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2154: , G_MODULE_NAME || l_api_name || '.end'
2155: ,'exit procedure'
2156: );
2157: END IF;

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

2215: WHERE RULE_SET_CODE = p_movement_stat_usages_rec.Attribute_rule_set_code
2216: AND SOURCE_TYPE = x_movement_transaction.document_source_type;
2217:
2218: BEGIN
2219: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2220: THEN
2221: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2222: , G_MODULE_NAME || l_api_name || '.begin'
2223: ,'enter procedure'

Line 2221: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2217:
2218: BEGIN
2219: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2220: THEN
2221: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2222: , G_MODULE_NAME || l_api_name || '.begin'
2223: ,'enter procedure'
2224: );
2225: END IF;

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

2232:
2233: -- Init x_return_status
2234: x_return_status := FND_API.G_RET_STS_SUCCESS;
2235:
2236: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2237: THEN
2238: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2239: , G_MODULE_NAME || l_api_name
2240: , 'RULE_SET_CODE= '||p_movement_stat_usages_rec.Attribute_rule_set_code

Line 2238: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

2234: x_return_status := FND_API.G_RET_STS_SUCCESS;
2235:
2236: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2237: THEN
2238: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2239: , G_MODULE_NAME || l_api_name
2240: , 'RULE_SET_CODE= '||p_movement_stat_usages_rec.Attribute_rule_set_code
2241: );
2242: END IF;

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

2282: Rule_Field_Value := l_orig_mvmt_transaction.CUSTOMER_VAT_NUMBER;
2283: ELSE Rule_Field_Value := NULL;
2284: END IF;
2285:
2286: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2287: THEN
2288: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2289: , G_MODULE_NAME || l_api_name
2290: , 'Rules_rec.attribute_code= '||Rules_rec.attribute_code

Line 2288: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

2284: END IF;
2285:
2286: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2287: THEN
2288: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2289: , G_MODULE_NAME || l_api_name
2290: , 'Rules_rec.attribute_code= '||Rules_rec.attribute_code
2291: );
2292: END IF;

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

2290: , 'Rules_rec.attribute_code= '||Rules_rec.attribute_code
2291: );
2292: END IF;
2293:
2294: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2295: THEN
2296: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2297: , G_MODULE_NAME || l_api_name
2298: , 'Rule_Field_Value= '||Rule_Field_Value

Line 2296: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

2292: END IF;
2293:
2294: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2295: THEN
2296: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2297: , G_MODULE_NAME || l_api_name
2298: , 'Rule_Field_Value= '||Rule_Field_Value
2299: );
2300: END IF;

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

2298: , 'Rule_Field_Value= '||Rule_Field_Value
2299: );
2300: END IF;
2301:
2302: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2303: THEN
2304: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2305: , G_MODULE_NAME || l_api_name
2306: , 'Rules_rec.Attribute_property_Code= '||Rules_rec.Attribute_property_Code

Line 2304: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

2300: END IF;
2301:
2302: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2303: THEN
2304: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2305: , G_MODULE_NAME || l_api_name
2306: , 'Rules_rec.Attribute_property_Code= '||Rules_rec.Attribute_property_Code
2307: );
2308: END IF;

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

2314: -- Need to raise an exception only for REQUIRED fields
2315: IF Rules_rec.Attribute_property_Code = 'REQUIRED_UPDATEABLE'
2316: OR Rules_rec.Attribute_property_Code = 'REQUIRED_NON_UPDATEABLE'
2317: THEN
2318: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2319: THEN
2320: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2321: , G_MODULE_NAME || l_api_name
2322: , 'Exception for '||Rules_rec.attribute_code

Line 2320: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

2316: OR Rules_rec.Attribute_property_Code = 'REQUIRED_NON_UPDATEABLE'
2317: THEN
2318: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2319: THEN
2320: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2321: , G_MODULE_NAME || l_api_name
2322: , 'Exception for '||Rules_rec.attribute_code
2323: );
2324: END IF;

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

2333: , p_attribute_code => Rules_rec.attribute_code
2334: , x_return_status => l_return_status
2335: );
2336:
2337: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2338: THEN
2339: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2340: , G_MODULE_NAME || l_api_name
2341: , 'out of Partner_vat_number with status '||l_return_status

Line 2339: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

2335: );
2336:
2337: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2338: THEN
2339: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2340: , G_MODULE_NAME || l_api_name
2341: , 'out of Partner_vat_number with status '||l_return_status
2342: );
2343: END IF;

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

2364:
2365: -----for Trading Partner VAT
2366: IF Rules_rec.attribute_code='PARTNER_VAT_NUMBER'
2367: THEN
2368: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2369: THEN
2370: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2371: , G_MODULE_NAME || l_api_name
2372: , 'Rules_rec.attribute_code='||Rules_rec.attribute_code

Line 2370: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

2366: IF Rules_rec.attribute_code='PARTNER_VAT_NUMBER'
2367: THEN
2368: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2369: THEN
2370: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2371: , G_MODULE_NAME || l_api_name
2372: , 'Rules_rec.attribute_code='||Rules_rec.attribute_code
2373: );
2374: END IF;

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

2379: , p_attribute_code => Rules_rec.attribute_code
2380: , x_return_status => l_return_status
2381: );
2382:
2383: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2384: THEN
2385: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2386: , G_MODULE_NAME || l_api_name
2387: , 'out of Partner_vat_number with status '||l_return_status

Line 2385: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

2381: );
2382:
2383: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2384: THEN
2385: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2386: , G_MODULE_NAME || l_api_name
2387: , 'out of Partner_vat_number with status '||l_return_status
2388: );
2389: END IF;

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

2449:
2450:
2451: x_movement_transaction := l_orig_mvmt_transaction;
2452:
2453: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2454: THEN
2455: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2456: , G_MODULE_NAME || l_api_name || '.end'
2457: ,'exit procedure'

Line 2455: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2451: x_movement_transaction := l_orig_mvmt_transaction;
2452:
2453: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2454: THEN
2455: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2456: , G_MODULE_NAME || l_api_name || '.end'
2457: ,'exit procedure'
2458: );
2459: END IF;

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

2490: )
2491: IS
2492: l_api_name CONSTANT VARCHAR2(30) := 'Get_Invoice_Transactions';
2493: BEGIN
2494: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2495: THEN
2496: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2497: , G_MODULE_NAME || l_api_name || '.begin'
2498: ,'enter procedure'

Line 2496: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2492: l_api_name CONSTANT VARCHAR2(30) := 'Get_Invoice_Transactions';
2493: BEGIN
2494: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2495: THEN
2496: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2497: , G_MODULE_NAME || l_api_name || '.begin'
2498: ,'enter procedure'
2499: );
2500: END IF;

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

2663: AND movement_status in ('O','V')
2664: AND financial_document_flag <> 'NOT_REQUIRED'
2665: ORDER BY mtl_stats.movement_id;
2666:
2667: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2668: THEN
2669: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2670: , G_MODULE_NAME || l_api_name || '.end'
2671: ,'exit procedure'

Line 2669: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2665: ORDER BY mtl_stats.movement_id;
2666:
2667: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2668: THEN
2669: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2670: , G_MODULE_NAME || l_api_name || '.end'
2671: ,'exit procedure'
2672: );
2673: END IF;

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

2701: )
2702: IS
2703: l_api_name CONSTANT VARCHAR2(30) := 'Get_PO_Trans_With_Correction';
2704: BEGIN
2705: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2706: THEN
2707: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2708: , G_MODULE_NAME || l_api_name || '.begin'
2709: ,'enter procedure'

Line 2707: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2703: l_api_name CONSTANT VARCHAR2(30) := 'Get_PO_Trans_With_Correction';
2704: BEGIN
2705: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2706: THEN
2707: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2708: , G_MODULE_NAME || l_api_name || '.begin'
2709: ,'enter procedure'
2710: );
2711: END IF;

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

2878: WHERE mvt_stat_status = 'NEW'
2879: AND transaction_type = 'CORRECT')
2880: ORDER BY mtl_stats.movement_id;
2881:
2882: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2883: THEN
2884: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2885: , G_MODULE_NAME || l_api_name || '.end'
2886: ,'exit procedure'

Line 2884: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2880: ORDER BY mtl_stats.movement_id;
2881:
2882: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2883: THEN
2884: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2885: , G_MODULE_NAME || l_api_name || '.end'
2886: ,'exit procedure'
2887: );
2888: END IF;

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

2914: )
2915: IS
2916: l_api_name CONSTANT VARCHAR2(30) := 'Get_Pending_Txns';
2917: BEGIN
2918: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2919: THEN
2920: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2921: , G_MODULE_NAME || l_api_name || '.begin'
2922: ,'enter procedure'

Line 2920: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2916: l_api_name CONSTANT VARCHAR2(30) := 'Get_Pending_Txns';
2917: BEGIN
2918: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2919: THEN
2920: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2921: , G_MODULE_NAME || l_api_name || '.begin'
2922: ,'enter procedure'
2923: );
2924: END IF;

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

3085: AND movement_status = 'P'
3086: ORDER BY
3087: mtl_stats.movement_id;
3088:
3089: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3090: THEN
3091: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3092: , G_MODULE_NAME || l_api_name || '.end'
3093: ,'exit procedure'

Line 3091: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3087: mtl_stats.movement_id;
3088:
3089: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3090: THEN
3091: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3092: , G_MODULE_NAME || l_api_name || '.end'
3093: ,'exit procedure'
3094: );
3095: END IF;