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.

[Home] [Help]

APPS.GCS_INTERCO_DYNAMIC_PKG dependencies on GCS_UTILITY_PKG

Line 41: gcs_utility_pkg.g_module_enter

37:
38: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
39: fnd_log.STRING (fnd_log.level_procedure,
40: g_pkg_name || '.' || l_api_name,
41: gcs_utility_pkg.g_module_enter
42: || ' '
43: || l_api_name
44: || '() '
45: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')

Line 638: GCS_UTILITY_PKG.g_module_success || l_api_name ||

634: END If; -- End of elimination mode.
635: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
636: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
637: g_pkg_name || '.' || l_api_name,
638: GCS_UTILITY_PKG.g_module_success || l_api_name ||
639: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
640: END IF;
641: RETURN TRUE;
642:

Line 652: GCS_UTILITY_PKG.g_module_failure || l_api_name ||

648: g_pkg_name || '.' || l_api_name,
649: SUBSTR(SQLERRM, 1, 255));
650: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
651: g_pkg_name || '.' || l_api_name,
652: GCS_UTILITY_PKG.g_module_failure || l_api_name ||
653: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
654: END IF;
655: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure
656: -- ||l_api_name || to_char(sysdate

Line 655: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure

651: g_pkg_name || '.' || l_api_name,
652: GCS_UTILITY_PKG.g_module_failure || l_api_name ||
653: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
654: END IF;
655: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure
656: -- ||l_api_name || to_char(sysdate
657: -- , ' DD-MON-YYYY HH:MI:SS'));
658: RETURN FALSE;
659: END INSR_INTERCO_LINES;

Line 691: gcs_utility_pkg.g_module_enter

687:
688: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
689: fnd_log.STRING (fnd_log.level_procedure,
690: g_pkg_name || '.' || l_api_name,
691: gcs_utility_pkg.g_module_enter
692: || ' '
693: || l_api_name
694: || '() '
695: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')

Line 784: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY').attribute_id

780: WHERE gihg1.entry_id = gel.entry_id
781: AND gel.receivables_org_id =
782: fcoa2.company_cost_center_org_id
783: AND fcoa2.attribute_id =
784: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY').attribute_id
785: AND fcoa2.version_id =
786: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY').version_id
787: AND gel.payables_org_id = fcoa3.company_cost_center_org_id
788: AND fcoa3.attribute_id =

Line 786: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY').version_id

782: fcoa2.company_cost_center_org_id
783: AND fcoa2.attribute_id =
784: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY').attribute_id
785: AND fcoa2.version_id =
786: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY').version_id
787: AND gel.payables_org_id = fcoa3.company_cost_center_org_id
788: AND fcoa3.attribute_id =
789: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY').attribute_id
790: AND fcoa3.version_id =

Line 789: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY').attribute_id

785: AND fcoa2.version_id =
786: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY').version_id
787: AND gel.payables_org_id = fcoa3.company_cost_center_org_id
788: AND fcoa3.attribute_id =
789: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY').attribute_id
790: AND fcoa3.version_id =
791: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY').version_id
792: GROUP BY gihg1.entry_id, fcoa2.dim_attribute_numeric_member,
793: fcoa3.dim_attribute_numeric_member;

Line 791: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY').version_id

787: AND gel.payables_org_id = fcoa3.company_cost_center_org_id
788: AND fcoa3.attribute_id =
789: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY').attribute_id
790: AND fcoa3.version_id =
791: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY').version_id
792: GROUP BY gihg1.entry_id, fcoa2.dim_attribute_numeric_member,
793: fcoa3.dim_attribute_numeric_member;
794:
795: g_no_rows := NVL(SQL%ROWCOUNT,0);

Line 951: GCS_UTILITY_PKG.g_module_success || l_api_name ||

947:
948: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
949: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
950: g_pkg_name || '.' || l_api_name,
951: GCS_UTILITY_PKG.g_module_success || l_api_name ||
952: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
953: END IF;
954: Return TRUE;
955:

Line 967: GCS_UTILITY_PKG.g_module_failure || l_api_name ||

963: g_pkg_name || '.' || l_api_name,
964: SUBSTR(SQLERRM, 1, 255));
965: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
966: g_pkg_name || '.' || l_api_name,
967: GCS_UTILITY_PKG.g_module_failure || l_api_name ||
968: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
969: END IF;
970:
971: p_err_code := SQLCODE;

Line 1043: gcs_utility_pkg.g_module_enter

1039: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1040:
1041: fnd_log.STRING (fnd_log.level_procedure,
1042: g_pkg_name || '.' || l_api_name,
1043: gcs_utility_pkg.g_module_enter
1044: || ' '
1045: || l_api_name
1046: || '() '
1047: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')

Line 1242: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COST_CENTER').attribute_id

1238:
1239: AND gel.company_cost_center_org_id =
1240: fcoa2.company_cost_center_org_id
1241: AND fcoa2.attribute_id =
1242: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COST_CENTER').attribute_id
1243: AND fcoa2.version_id =
1244: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COST_CENTER').version_id
1245: AND gel.intercompany_id = fcoa3.company_cost_center_org_id
1246: AND fcoa3.attribute_id =

Line 1244: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COST_CENTER').version_id

1240: fcoa2.company_cost_center_org_id
1241: AND fcoa2.attribute_id =
1242: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COST_CENTER').attribute_id
1243: AND fcoa2.version_id =
1244: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COST_CENTER').version_id
1245: AND gel.intercompany_id = fcoa3.company_cost_center_org_id
1246: AND fcoa3.attribute_id =
1247: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COST_CENTER').attribute_id
1248: AND fcoa3.version_id =

Line 1247: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COST_CENTER').attribute_id

1243: AND fcoa2.version_id =
1244: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COST_CENTER').version_id
1245: AND gel.intercompany_id = fcoa3.company_cost_center_org_id
1246: AND fcoa3.attribute_id =
1247: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COST_CENTER').attribute_id
1248: AND fcoa3.version_id =
1249: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COST_CENTER').version_id
1250: AND fcca.attribute_id = gcs_utility_pkg.g_dimension_attr_info('USER_DIM1_ID-ELIMINATION_LOB').attribute_id
1251: AND fcca.version_id = gcs_utility_pkg.g_dimension_attr_info('USER_DIM1_ID-ELIMINATION_LOB').version_id

Line 1249: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COST_CENTER').version_id

1245: AND gel.intercompany_id = fcoa3.company_cost_center_org_id
1246: AND fcoa3.attribute_id =
1247: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COST_CENTER').attribute_id
1248: AND fcoa3.version_id =
1249: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COST_CENTER').version_id
1250: AND fcca.attribute_id = gcs_utility_pkg.g_dimension_attr_info('USER_DIM1_ID-ELIMINATION_LOB').attribute_id
1251: AND fcca.version_id = gcs_utility_pkg.g_dimension_attr_info('USER_DIM1_ID-ELIMINATION_LOB').version_id
1252:
1253: AND fcca.user_dim1_id = (

Line 1250: AND fcca.attribute_id = gcs_utility_pkg.g_dimension_attr_info('USER_DIM1_ID-ELIMINATION_LOB').attribute_id

1246: AND fcoa3.attribute_id =
1247: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COST_CENTER').attribute_id
1248: AND fcoa3.version_id =
1249: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COST_CENTER').version_id
1250: AND fcca.attribute_id = gcs_utility_pkg.g_dimension_attr_info('USER_DIM1_ID-ELIMINATION_LOB').attribute_id
1251: AND fcca.version_id = gcs_utility_pkg.g_dimension_attr_info('USER_DIM1_ID-ELIMINATION_LOB').version_id
1252:
1253: AND fcca.user_dim1_id = (
1254: SELECT fcch1.parent_id

Line 1251: AND fcca.version_id = gcs_utility_pkg.g_dimension_attr_info('USER_DIM1_ID-ELIMINATION_LOB').version_id

1247: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COST_CENTER').attribute_id
1248: AND fcoa3.version_id =
1249: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COST_CENTER').version_id
1250: AND fcca.attribute_id = gcs_utility_pkg.g_dimension_attr_info('USER_DIM1_ID-ELIMINATION_LOB').attribute_id
1251: AND fcca.version_id = gcs_utility_pkg.g_dimension_attr_info('USER_DIM1_ID-ELIMINATION_LOB').version_id
1252:
1253: AND fcca.user_dim1_id = (
1254: SELECT fcch1.parent_id
1255: FROM fem_user_dim1_hier fcch1,

Line 1385: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COST_CENTER').attribute_id

1381:
1382: AND gel.company_cost_center_org_id =
1383: fcoa2.company_cost_center_org_id
1384: AND fcoa2.attribute_id =
1385: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COST_CENTER').attribute_id
1386: AND fcoa2.version_id =
1387: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COST_CENTER').version_id
1388: AND gel.intercompany_id = fcoa3.company_cost_center_org_id
1389: AND fcoa3.attribute_id =

Line 1387: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COST_CENTER').version_id

1383: fcoa2.company_cost_center_org_id
1384: AND fcoa2.attribute_id =
1385: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COST_CENTER').attribute_id
1386: AND fcoa2.version_id =
1387: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COST_CENTER').version_id
1388: AND gel.intercompany_id = fcoa3.company_cost_center_org_id
1389: AND fcoa3.attribute_id =
1390: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COST_CENTER').attribute_id
1391: AND fcoa3.version_id =

Line 1390: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COST_CENTER').attribute_id

1386: AND fcoa2.version_id =
1387: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COST_CENTER').version_id
1388: AND gel.intercompany_id = fcoa3.company_cost_center_org_id
1389: AND fcoa3.attribute_id =
1390: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COST_CENTER').attribute_id
1391: AND fcoa3.version_id =
1392: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COST_CENTER').version_id
1393: AND fcca.attribute_id = gcs_utility_pkg.g_dimension_attr_info('USER_DIM1_ID-ELIMINATION_LOB').attribute_id
1394: AND fcca.version_id = gcs_utility_pkg.g_dimension_attr_info('USER_DIM1_ID-ELIMINATION_LOB').version_id

Line 1392: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COST_CENTER').version_id

1388: AND gel.intercompany_id = fcoa3.company_cost_center_org_id
1389: AND fcoa3.attribute_id =
1390: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COST_CENTER').attribute_id
1391: AND fcoa3.version_id =
1392: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COST_CENTER').version_id
1393: AND fcca.attribute_id = gcs_utility_pkg.g_dimension_attr_info('USER_DIM1_ID-ELIMINATION_LOB').attribute_id
1394: AND fcca.version_id = gcs_utility_pkg.g_dimension_attr_info('USER_DIM1_ID-ELIMINATION_LOB').version_id
1395:
1396: AND fcca.user_dim1_id = (

Line 1393: AND fcca.attribute_id = gcs_utility_pkg.g_dimension_attr_info('USER_DIM1_ID-ELIMINATION_LOB').attribute_id

1389: AND fcoa3.attribute_id =
1390: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COST_CENTER').attribute_id
1391: AND fcoa3.version_id =
1392: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COST_CENTER').version_id
1393: AND fcca.attribute_id = gcs_utility_pkg.g_dimension_attr_info('USER_DIM1_ID-ELIMINATION_LOB').attribute_id
1394: AND fcca.version_id = gcs_utility_pkg.g_dimension_attr_info('USER_DIM1_ID-ELIMINATION_LOB').version_id
1395:
1396: AND fcca.user_dim1_id = (
1397: SELECT fcch1.parent_id

Line 1394: AND fcca.version_id = gcs_utility_pkg.g_dimension_attr_info('USER_DIM1_ID-ELIMINATION_LOB').version_id

1390: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COST_CENTER').attribute_id
1391: AND fcoa3.version_id =
1392: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COST_CENTER').version_id
1393: AND fcca.attribute_id = gcs_utility_pkg.g_dimension_attr_info('USER_DIM1_ID-ELIMINATION_LOB').attribute_id
1394: AND fcca.version_id = gcs_utility_pkg.g_dimension_attr_info('USER_DIM1_ID-ELIMINATION_LOB').version_id
1395:
1396: AND fcca.user_dim1_id = (
1397: SELECT fcch1.parent_id
1398: FROM fem_user_dim1_hier fcch1,

Line 1708: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY').attribute_id

1704: AND gcr1.actual_ownership_flag ='Y'
1705: AND gcr1.dominant_parent_flag = 'Y'
1706:
1707: AND fcoa2.attribute_id =
1708: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY').attribute_id
1709: AND fcoa2.version_id =
1710: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY').version_id
1711: AND gel.intercompany_id = fcoa3.company_cost_center_org_id
1712: AND fcoa3.attribute_id =

Line 1710: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY').version_id

1706:
1707: AND fcoa2.attribute_id =
1708: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY').attribute_id
1709: AND fcoa2.version_id =
1710: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY').version_id
1711: AND gel.intercompany_id = fcoa3.company_cost_center_org_id
1712: AND fcoa3.attribute_id =
1713: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY').attribute_id
1714: AND fcoa3.version_id =

Line 1713: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY').attribute_id

1709: AND fcoa2.version_id =
1710: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY').version_id
1711: AND gel.intercompany_id = fcoa3.company_cost_center_org_id
1712: AND fcoa3.attribute_id =
1713: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY').attribute_id
1714: AND fcoa3.version_id =
1715: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY').version_id
1716:
1717:

Line 1715: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY').version_id

1711: AND gel.intercompany_id = fcoa3.company_cost_center_org_id
1712: AND fcoa3.attribute_id =
1713: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY').attribute_id
1714: AND fcoa3.version_id =
1715: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY').version_id
1716:
1717:
1718: AND NOT EXISTS ( SELECT 1 FROM GCS_INTERCO_ELM_TRX giet1
1719: WHERE giet1.hierarchy_id = geh.hierarchy_id

Line 1819: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY').attribute_id

1815: AND gel.company_cost_center_org_id =
1816: fcoa2.company_cost_center_org_id
1817:
1818: AND fcoa2.attribute_id =
1819: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY').attribute_id
1820: AND fcoa2.version_id =
1821: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY').version_id
1822: AND gel.intercompany_id = fcoa3.company_cost_center_org_id
1823: AND fcoa3.attribute_id =

Line 1821: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY').version_id

1817:
1818: AND fcoa2.attribute_id =
1819: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY').attribute_id
1820: AND fcoa2.version_id =
1821: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY').version_id
1822: AND gel.intercompany_id = fcoa3.company_cost_center_org_id
1823: AND fcoa3.attribute_id =
1824: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY').attribute_id
1825: AND fcoa3.version_id =

Line 1824: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY').attribute_id

1820: AND fcoa2.version_id =
1821: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY').version_id
1822: AND gel.intercompany_id = fcoa3.company_cost_center_org_id
1823: AND fcoa3.attribute_id =
1824: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY').attribute_id
1825: AND fcoa3.version_id =
1826: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY').version_id
1827: AND fcoa3.dim_attribute_numeric_member <>
1828: fcoa2.dim_attribute_numeric_member

Line 1826: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY').version_id

1822: AND gel.intercompany_id = fcoa3.company_cost_center_org_id
1823: AND fcoa3.attribute_id =
1824: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY').attribute_id
1825: AND fcoa3.version_id =
1826: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY').version_id
1827: AND fcoa3.dim_attribute_numeric_member <>
1828: fcoa2.dim_attribute_numeric_member
1829:
1830:

Line 1868: GCS_UTILITY_PKG.g_module_success || l_api_name ||

1864: THEN
1865:
1866: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1867: g_pkg_name || '.' || l_api_name,
1868: GCS_UTILITY_PKG.g_module_success || l_api_name ||
1869: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
1870: END IF;
1871:
1872: COMMIT;

Line 1932: GCS_UTILITY_PKG.g_module_failure || l_api_name ||

1928: g_pkg_name || '.' || l_api_name,
1929: SUBSTR(SQLERRM, 1, 255));
1930: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
1931: g_pkg_name || '.' || l_api_name,
1932: GCS_UTILITY_PKG.g_module_failure || l_api_name ||
1933: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
1934: END IF;
1935:
1936: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure

Line 1936: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure

1932: GCS_UTILITY_PKG.g_module_failure || l_api_name ||
1933: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
1934: END IF;
1935:
1936: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure
1937: -- ||l_api_name || to_char(sysdate
1938: -- , ' DD-MON-YYYY HH:MI:SS'));
1939: x_retcode := 2;
1940:

Line 1948: gcs_utility_pkg.g_module_success

1944: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1945:
1946: fnd_log.STRING (fnd_log.level_procedure,
1947: g_pkg_name || '.' || l_api_name,
1948: gcs_utility_pkg.g_module_success
1949: || ' '
1950: || l_api_name
1951: || '() '
1952: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')