[Home] [Help]
6: g_period_start_date DATE;
7: g_period_end_date DATE;
8: g_match_rule_code VARCHAR2(30);
9: g_currency_code VARCHAR2(30);
10: g_dimension_attr_info gcs_utility_pkg.t_hash_dimension_attr_info
11: := gcs_utility_pkg.g_dimension_attr_info;
12: g_gcs_dimension_info gcs_utility_pkg.t_hash_gcs_dimension_info
13: := gcs_utility_pkg.g_gcs_dimension_info;
14: g_fnd_user_id NUMBER := fnd_global.user_id;
7: g_period_end_date DATE;
8: g_match_rule_code VARCHAR2(30);
9: g_currency_code VARCHAR2(30);
10: g_dimension_attr_info gcs_utility_pkg.t_hash_dimension_attr_info
11: := gcs_utility_pkg.g_dimension_attr_info;
12: g_gcs_dimension_info gcs_utility_pkg.t_hash_gcs_dimension_info
13: := gcs_utility_pkg.g_gcs_dimension_info;
14: g_fnd_user_id NUMBER := fnd_global.user_id;
15: g_fnd_login_id NUMBER := fnd_global.login_id;
8: g_match_rule_code VARCHAR2(30);
9: g_currency_code VARCHAR2(30);
10: g_dimension_attr_info gcs_utility_pkg.t_hash_dimension_attr_info
11: := gcs_utility_pkg.g_dimension_attr_info;
12: g_gcs_dimension_info gcs_utility_pkg.t_hash_gcs_dimension_info
13: := gcs_utility_pkg.g_gcs_dimension_info;
14: g_fnd_user_id NUMBER := fnd_global.user_id;
15: g_fnd_login_id NUMBER := fnd_global.login_id;
16: -- Action types for writing module information to the log file.
9: g_currency_code VARCHAR2(30);
10: g_dimension_attr_info gcs_utility_pkg.t_hash_dimension_attr_info
11: := gcs_utility_pkg.g_dimension_attr_info;
12: g_gcs_dimension_info gcs_utility_pkg.t_hash_gcs_dimension_info
13: := gcs_utility_pkg.g_gcs_dimension_info;
14: g_fnd_user_id NUMBER := fnd_global.user_id;
15: g_fnd_login_id NUMBER := fnd_global.login_id;
16: -- Action types for writing module information to the log file.
17:
149:
150: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
151: fnd_log.STRING (fnd_log.level_procedure,
152: g_pkg_name || '.' || l_api_name,
153: gcs_utility_pkg.g_module_enter
154: || ' '
155: || l_api_name
156: || '() '
157: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
424: g_pkg_name || '.' || l_api_name,
425: ' No rows to process');
426: fnd_log.STRING (fnd_log.level_procedure,
427: g_pkg_name || '.' || l_api_name,
428: gcs_utility_pkg.g_module_success
429: || ' '
430: || l_api_name
431: || '() '
432: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
624:
625: SELECT member_col
626: BULK COLLECT INTO l_dims_list
627: FROM fem_xdim_dimensions
628: WHERE gcs_utility_pkg.Get_Dimension_Required(member_col) = 'Y'
629: AND member_col <> 'ENTITY_ID';
630:
631: FOR i in l_dims_list.first .. l_dims_list.last loop
632:
779: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
780:
781: fnd_log.STRING (fnd_log.level_procedure,
782: g_pkg_name || '.' || l_api_name,
783: gcs_utility_pkg.g_module_success
784: || ' '
785: || l_api_name
786: || '() '
787: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
803: SUBSTR(SQLERRM, 1, 255));
804:
805: fnd_log.STRING (fnd_log.level_unexpected,
806: g_pkg_name || '.' || l_api_name,
807: gcs_utility_pkg.g_module_failure
808: || ' '
809: || l_api_name
810: || '() '
811: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
831: SUBSTR(SQLERRM, 1, 255));
832:
833: fnd_log.STRING (fnd_log.level_unexpected,
834: g_pkg_name || '.' || l_api_name,
835: gcs_utility_pkg.g_module_failure
836: || ' '
837: || l_api_name
838: || '() '
839: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
854: SUBSTR(SQLERRM, 1, 255));
855:
856: fnd_log.STRING (fnd_log.level_unexpected,
857: g_pkg_name || '.' || l_api_name,
858: gcs_utility_pkg.g_module_failure
859: || ' '
860: || l_api_name
861: || '() '
862: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
877: SUBSTR(SQLERRM, 1, 255));
878:
879: fnd_log.STRING (fnd_log.level_unexpected,
880: g_pkg_name || '.' || l_api_name,
881: gcs_utility_pkg.g_module_failure
882: || ' '
883: || l_api_name
884: || '() '
885: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
903: SUBSTR(l_err_msg, 1, 255));
904:
905: fnd_log.STRING (fnd_log.level_unexpected,
906: g_pkg_name || '.' || l_api_name,
907: gcs_utility_pkg.g_module_failure
908: || ' '
909: || l_api_name
910: || '() '
911: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
930: || SUBSTR(SQLERRM, 1, 255));
931:
932: fnd_log.STRING (fnd_log.level_unexpected,
933: g_pkg_name || '.' || l_api_name,
934: gcs_utility_pkg.g_module_failure
935: || ' '
936: || l_api_name
937: || '() '
938: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
957: || SUBSTR(SQLERRM, 1, 255));
958:
959: fnd_log.STRING (fnd_log.level_unexpected,
960: g_pkg_name || '.' || l_api_name,
961: gcs_utility_pkg.g_module_failure
962: || ' '
963: || l_api_name
964: || '() '
965: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
984: || SUBSTR(SQLERRM, 1, 255));
985:
986: fnd_log.STRING (fnd_log.level_unexpected,
987: g_pkg_name || '.' || l_api_name,
988: gcs_utility_pkg.g_module_failure
989: || ' '
990: || l_api_name
991: || '() '
992: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
1034: SUBSTR(SQLERRM, 1, 255));
1035:
1036: fnd_log.STRING (fnd_log.level_unexpected,
1037: g_pkg_name || '.' || l_api_name,
1038: gcs_utility_pkg.g_module_failure
1039: || ' '
1040: || l_api_name
1041: || '() '
1042: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
1056: SUBSTR(SQLERRM, 1, 255));
1057:
1058: fnd_log.STRING (fnd_log.level_unexpected,
1059: g_pkg_name || '.' || l_api_name,
1060: gcs_utility_pkg.g_module_failure
1061: || ' '
1062: || l_api_name
1063: || '() '
1064: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
1096:
1097: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1098: fnd_log.STRING (fnd_log.level_procedure,
1099: g_pkg_name || '.' || l_api_name,
1100: gcs_utility_pkg.g_module_enter
1101: || ' '
1102: || l_api_name
1103: || '() '
1104: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
1634: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1635:
1636: fnd_log.STRING (fnd_log.level_procedure,
1637: g_pkg_name || '.' || l_api_name,
1638: gcs_utility_pkg.g_module_success
1639: || ' '
1640: || l_api_name
1641: || '() '
1642: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
1663: SUBSTR(SQLERRM, 1, 255));
1664:
1665: fnd_log.STRING (fnd_log.level_unexpected,
1666: g_pkg_name || '.' || l_api_name,
1667: gcs_utility_pkg.g_module_failure
1668: || ' '
1669: || l_api_name
1670: || '() '
1671: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
1684: SUBSTR(SQLERRM, 1, 255));
1685:
1686: fnd_log.STRING (fnd_log.level_unexpected,
1687: g_pkg_name || '.' || l_api_name,
1688: gcs_utility_pkg.g_module_failure
1689: || ' '
1690: || l_api_name
1691: || '() '
1692: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
1801:
1802: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1803: fnd_log.STRING (fnd_log.level_procedure,
1804: g_pkg_name || '.' || l_api_name,
1805: gcs_utility_pkg.g_module_enter
1806: || ' '
1807: || l_api_name
1808: || '() '
1809: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
1850: p_currency_code,
1851: l_period_end_date,
1852: 'Corporate'); */
1853:
1854: -- Call the gcs_utility_pkg.get_conversion_rate to get the
1855: -- conversion rate.
1856:
1857: GCS_UTILITY_PKG.Get_Conversion_Rate
1858: (p_source_currency => entries.threshold_currency,
1853:
1854: -- Call the gcs_utility_pkg.get_conversion_rate to get the
1855: -- conversion rate.
1856:
1857: GCS_UTILITY_PKG.Get_Conversion_Rate
1858: (p_source_currency => entries.threshold_currency,
1859: p_target_currency => p_currency_code,
1860: p_cal_period_id => p_cal_period_id,
1861: p_conversion_rate => x_corp_rate,
2454: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2455:
2456: fnd_log.STRING (fnd_log.level_procedure,
2457: g_pkg_name || '.' || l_api_name,
2458: gcs_utility_pkg.g_module_success
2459: || ' '
2460: || l_api_name
2461: || '() '
2462: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
2473: g_pkg_name || '.' || l_api_name,
2474: SUBSTR(SQLERRM, 1, 255));
2475: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
2476: g_pkg_name || '.' || l_api_name,
2477: GCS_UTILITY_PKG.g_module_failure || l_api_name ||
2478: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
2479: END IF;
2480:
2481: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure
2477: GCS_UTILITY_PKG.g_module_failure || l_api_name ||
2478: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
2479: END IF;
2480:
2481: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure
2482: -- ||l_api_name || to_char(sysdate
2483: -- , ' DD-MON-YYYY HH:MI:SS'));
2484: RETURN FALSE;
2485: