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.GCS_INTERCO_DYN_BUILD_PKG dependencies on GCS_UTILITY_PKG

Line 49: GCS_UTILITY_PKG.g_module_enter || l_api_name ||

45: BEGIN
46: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
47: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
48: g_api || '.' || l_api_name,
49: GCS_UTILITY_PKG.g_module_enter || l_api_name ||
50: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
51: END IF;
52: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter ||
53: -- l_api_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

Line 52: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter ||

48: g_api || '.' || l_api_name,
49: GCS_UTILITY_PKG.g_module_enter || l_api_name ||
50: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
51: END IF;
52: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter ||
53: -- l_api_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
54:
55: body_block :=
56: 'CREATE OR REPLACE PACKAGE BODY GCS_INTERCO_DYNAMIC_PKG AS

Line 96: gcs_utility_pkg.g_module_enter

92:
93: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
94: fnd_log.STRING (fnd_log.level_procedure,
95: g_pkg_name || ''.'' || l_api_name,
96: gcs_utility_pkg.g_module_enter
97: || '' ''
98: || l_api_name
99: || ''() ''
100: || TO_CHAR (SYSDATE, ''DD-MON-YYYY HH:MI:SS'')

Line 192: ' giet.', GCS_UTILITY_PKG.g_nl, ' NULL,', line_num);

188: curr_pos := curr_pos + g_line_size;
189: line_num := line_num + 1;
190: END LOOP;
191: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(
192: ' giet.', GCS_UTILITY_PKG.g_nl, ' NULL,', line_num);
193:
194:
195:
196: body_block := '

Line 252: ' AND fb.', ' = giet. ', GCS_UTILITY_PKG.g_nl, line_num);

248:
249:
250: --******--
251: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Join_List(
252: ' AND fb.', ' = giet. ', GCS_UTILITY_PKG.g_nl, line_num);
253: --******--
254:
255: body_block :=
256: '

Line 274: ' giet.', GCS_UTILITY_PKG.g_nl, '', line_num);

270:
271:
272: --******--
273: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(
274: ' giet.', GCS_UTILITY_PKG.g_nl, '', line_num);
275:
276:
277: body_block :=
278: 'giet.line_item_id;';

Line 345: ' giet.', GCS_UTILITY_PKG.g_nl, ' NULL,', line_num);

341: curr_pos := curr_pos + g_line_size;
342: line_num := line_num + 1;
343: END LOOP;
344: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(
345: ' giet.', GCS_UTILITY_PKG.g_nl, ' NULL,', line_num);
346:
347:
348:
349: body_block := '

Line 405: ' AND fb.', ' = giet. ', GCS_UTILITY_PKG.g_nl, line_num);

401:
402:
403: --******--
404: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Join_List(
405: ' AND fb.', ' = giet. ', GCS_UTILITY_PKG.g_nl, line_num);
406:
407: --******--
408:
409:

Line 429: ' giet.', GCS_UTILITY_PKG.g_nl, '', line_num);

425:
426:
427: --******--
428: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(
429: ' giet.', GCS_UTILITY_PKG.g_nl, '', line_num);
430:
431:
432: body_block :=
433: 'giet.line_item_id;';

Line 532: ')),',GCS_UTILITY_PKG.g_nl, ' NULL,', line_num);

528: ' giet.',
529: 'DECODE(giet.elim_lob_id, NULL,giet.',
530: 'DECODE(p_lob_dim_col_name, ',
531: ' giet.elim_lob_id, giet.',
532: ')),',GCS_UTILITY_PKG.g_nl, ' NULL,', line_num);
533:
534: body_block := '
535: SUM(NVL(fb.ytd_debit_balance_e,0))
536: , SUM(NVL(fb.ytd_credit_balance_e,0))

Line 590: ' AND fb.', ' = giet. ', GCS_UTILITY_PKG.g_nl, line_num);

586: END LOOP;
587: --******--
588:
589: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Join_List(
590: ' AND fb.', ' = giet. ', GCS_UTILITY_PKG.g_nl, line_num);
591:
592: body_block :=
593: '
594: GROUP BY gihg.entry_id, giet.company_cost_center_org_id,

Line 614: ')),',GCS_UTILITY_PKG.g_nl, '', line_num);

610: ' giet.',
611: 'DECODE(giet.elim_lob_id, NULL,giet.',
612: 'DECODE(p_lob_dim_col_name, ',
613: ' giet.elim_lob_id, giet.',
614: ')),',GCS_UTILITY_PKG.g_nl, '', line_num);
615:
616:
617: body_block :=
618: '

Line 715: ')),',GCS_UTILITY_PKG.g_nl, ' NULL,', line_num);

711: ' giet.',
712: 'DECODE(giet.elim_lob_id, NULL,giet.',
713: 'DECODE(p_lob_dim_col_name, ',
714: ' giet.elim_lob_id, giet.',
715: ')),',GCS_UTILITY_PKG.g_nl, ' NULL,', line_num);
716:
717: body_block := '
718: SUM(NVL(fb.ytd_debit_balance_e,0))
719: , SUM(NVL(fb.ytd_credit_balance_e,0))

Line 773: ' AND fb.', ' = giet. ', GCS_UTILITY_PKG.g_nl, line_num);

769: END LOOP;
770: --******--
771:
772: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Join_List(
773: ' AND fb.', ' = giet. ', GCS_UTILITY_PKG.g_nl, line_num);
774:
775: body_block :=
776: '
777: GROUP BY gihg.entry_id, giet.company_cost_center_org_id,

Line 797: ')),',GCS_UTILITY_PKG.g_nl, '', line_num);

793: ' giet.',
794: 'DECODE(giet.elim_lob_id, NULL,giet.',
795: 'DECODE(p_lob_dim_col_name, ',
796: ' giet.elim_lob_id, giet.',
797: ')),',GCS_UTILITY_PKG.g_nl, '', line_num);
798:
799:
800: body_block :=
801: '

Line 886: ' giet.', GCS_UTILITY_PKG.g_nl, ' NULL,', line_num);

882: curr_pos := curr_pos + g_line_size;
883: line_num := line_num + 1;
884: END LOOP;
885: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(
886: ' giet.', GCS_UTILITY_PKG.g_nl, ' NULL,', line_num);
887:
888:
889:
890: body_block := '

Line 938: ' AND fb.', ' = giet. ', GCS_UTILITY_PKG.g_nl, line_num);

934:
935:
936: --******--
937: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Join_List(
938: ' AND fb.', ' = giet. ', GCS_UTILITY_PKG.g_nl, line_num);
939:
940:
941: --******--
942: body_block := '

Line 967: GCS_UTILITY_PKG.g_nl, line_num);

963: --******--
964:
965: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Join_List(
966: ' AND giet3.', ' = giet. ',
967: GCS_UTILITY_PKG.g_nl, line_num);
968:
969: body_block :=
970: '
971: AND gim2.line_item_id = giet3.line_item_id

Line 1007: ' giet.', GCS_UTILITY_PKG.g_nl, '', line_num);

1003:
1004:
1005: --******--
1006: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(
1007: ' giet.', GCS_UTILITY_PKG.g_nl, '', line_num);
1008:
1009:
1010: body_block :=
1011: 'giet.line_item_id;';

Line 1107: ')),',GCS_UTILITY_PKG.g_nl, ' NULL,', line_num);

1103: ' giet.',
1104: 'DECODE(giet.elim_lob_id, NULL,giet.',
1105: 'DECODE(p_lob_dim_col_name, ',
1106: ' giet.elim_lob_id, giet.',
1107: ')),',GCS_UTILITY_PKG.g_nl, ' NULL,', line_num);
1108:
1109:
1110: body_block := '
1111: SUM(NVL(fb.ytd_debit_balance_e,0))

Line 1157: ' AND fb.', ' = giet. ', GCS_UTILITY_PKG.g_nl, line_num);

1153: END LOOP;
1154: --******--
1155:
1156: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Join_List(
1157: ' AND fb.', ' = giet. ', GCS_UTILITY_PKG.g_nl, line_num);
1158: body_block := '
1159: AND NOT EXISTS (SELECT 1
1160: FROM GCS_INTERCO_ELM_TRX giet3,
1161: GCS_INTERCO_MEMBERS gim2

Line 1186: GCS_UTILITY_PKG.g_nl, line_num);

1182:
1183:
1184: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Join_List(
1185: ' AND giet3.', ' = giet. ',
1186: GCS_UTILITY_PKG.g_nl, line_num);
1187:
1188: body_block :=
1189: ' AND gim2.line_item_id = giet3.line_item_id
1190: AND gim2.rule_id = gihg.rule_id

Line 1230: ')),',GCS_UTILITY_PKG.g_nl, '', line_num);

1226: ' giet.',
1227: 'DECODE(giet.elim_lob_id, NULL,giet.',
1228: 'DECODE(p_lob_dim_col_name, ',
1229: ' giet.elim_lob_id, giet.',
1230: ')),',GCS_UTILITY_PKG.g_nl, '', line_num);
1231:
1232:
1233: body_block :=
1234: '

Line 1285: GCS_UTILITY_PKG.g_module_success || l_api_name ||

1281: END If; -- End of elimination mode.
1282: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1283: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
1284: g_pkg_name || ''.'' || l_api_name,
1285: GCS_UTILITY_PKG.g_module_success || l_api_name ||
1286: to_char(sysdate, '' DD-MON-YYYY HH:MI:SS''));
1287: END IF;
1288: RETURN TRUE;
1289:

Line 1299: GCS_UTILITY_PKG.g_module_failure || l_api_name ||

1295: g_pkg_name || ''.'' || l_api_name,
1296: SUBSTR(SQLERRM, 1, 255));
1297: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
1298: g_pkg_name || ''.'' || l_api_name,
1299: GCS_UTILITY_PKG.g_module_failure || l_api_name ||
1300: to_char(sysdate, '' DD-MON-YYYY HH:MI:SS''));
1301: END IF;
1302: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure
1303: -- ||l_api_name || to_char(sysdate

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

1298: g_pkg_name || ''.'' || l_api_name,
1299: GCS_UTILITY_PKG.g_module_failure || l_api_name ||
1300: to_char(sysdate, '' DD-MON-YYYY HH:MI:SS''));
1301: END IF;
1302: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure
1303: -- ||l_api_name || to_char(sysdate
1304: -- , '' DD-MON-YYYY HH:MI:SS''));
1305: RETURN FALSE;
1306: END INSR_INTERCO_LINES;

Line 1364: gcs_utility_pkg.g_module_enter

1360:
1361: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1362: fnd_log.STRING (fnd_log.level_procedure,
1363: g_pkg_name || ''.'' || l_api_name,
1364: gcs_utility_pkg.g_module_enter
1365: || '' ''
1366: || l_api_name
1367: || ''() ''
1368: || TO_CHAR (SYSDATE, ''DD-MON-YYYY HH:MI:SS'')

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

1524: WHERE gihg1.entry_id = gel.entry_id
1525: AND gel.receivables_org_id =
1526: fcoa2.company_cost_center_org_id
1527: AND fcoa2.attribute_id =
1528: gcs_utility_pkg.g_dimension_attr_info(''COMPANY_COST_CENTER_ORG_ID-COMPANY'').attribute_id
1529: AND fcoa2.version_id =
1530: gcs_utility_pkg.g_dimension_attr_info(''COMPANY_COST_CENTER_ORG_ID-COMPANY'').version_id
1531: AND gel.payables_org_id = fcoa3.company_cost_center_org_id
1532: AND fcoa3.attribute_id =

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

1526: fcoa2.company_cost_center_org_id
1527: AND fcoa2.attribute_id =
1528: gcs_utility_pkg.g_dimension_attr_info(''COMPANY_COST_CENTER_ORG_ID-COMPANY'').attribute_id
1529: AND fcoa2.version_id =
1530: gcs_utility_pkg.g_dimension_attr_info(''COMPANY_COST_CENTER_ORG_ID-COMPANY'').version_id
1531: AND gel.payables_org_id = fcoa3.company_cost_center_org_id
1532: AND fcoa3.attribute_id =
1533: gcs_utility_pkg.g_dimension_attr_info(''COMPANY_COST_CENTER_ORG_ID-COMPANY'').attribute_id
1534: AND fcoa3.version_id =

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

1529: AND fcoa2.version_id =
1530: gcs_utility_pkg.g_dimension_attr_info(''COMPANY_COST_CENTER_ORG_ID-COMPANY'').version_id
1531: AND gel.payables_org_id = fcoa3.company_cost_center_org_id
1532: AND fcoa3.attribute_id =
1533: gcs_utility_pkg.g_dimension_attr_info(''COMPANY_COST_CENTER_ORG_ID-COMPANY'').attribute_id
1534: AND fcoa3.version_id =
1535: gcs_utility_pkg.g_dimension_attr_info(''COMPANY_COST_CENTER_ORG_ID-COMPANY'').version_id
1536: GROUP BY gihg1.entry_id, fcoa2.dim_attribute_numeric_member,
1537: fcoa3.dim_attribute_numeric_member;

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

1531: AND gel.payables_org_id = fcoa3.company_cost_center_org_id
1532: AND fcoa3.attribute_id =
1533: gcs_utility_pkg.g_dimension_attr_info(''COMPANY_COST_CENTER_ORG_ID-COMPANY'').attribute_id
1534: AND fcoa3.version_id =
1535: gcs_utility_pkg.g_dimension_attr_info(''COMPANY_COST_CENTER_ORG_ID-COMPANY'').version_id
1536: GROUP BY gihg1.entry_id, fcoa2.dim_attribute_numeric_member,
1537: fcoa3.dim_attribute_numeric_member;
1538: ';
1539:

Line 1846: GCS_UTILITY_PKG.g_module_success || l_api_name ||

1842:
1843: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1844: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
1845: g_pkg_name || ''.'' || l_api_name,
1846: GCS_UTILITY_PKG.g_module_success || l_api_name ||
1847: to_char(sysdate, '' DD-MON-YYYY HH:MI:SS''));
1848: END IF;
1849: Return TRUE;
1850: ';

Line 1877: GCS_UTILITY_PKG.g_module_failure || l_api_name ||

1873: g_pkg_name || ''.'' || l_api_name,
1874: SUBSTR(SQLERRM, 1, 255));
1875: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
1876: g_pkg_name || ''.'' || l_api_name,
1877: GCS_UTILITY_PKG.g_module_failure || l_api_name ||
1878: to_char(sysdate, '' DD-MON-YYYY HH:MI:SS''));
1879: END IF;
1880:
1881: p_err_code := SQLCODE;

Line 2004: gcs_utility_pkg.g_module_enter

2000: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2001:
2002: fnd_log.STRING (fnd_log.level_procedure,
2003: g_pkg_name || ''.'' || l_api_name,
2004: gcs_utility_pkg.g_module_enter
2005: || '' ''
2006: || l_api_name
2007: || ''() ''
2008: || TO_CHAR (SYSDATE, ''DD-MON-YYYY HH:MI:SS'')

Line 2223: 'gel.', GCS_UTILITY_PKG.g_nl, ' NULL, ', line_num);

2219: END LOOP;
2220:
2221:
2222: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(
2223: 'gel.', GCS_UTILITY_PKG.g_nl, ' NULL, ', line_num);
2224:
2225: body_block := '
2226: SYSDATE, g_fnd_user_id,
2227: SYSDATE, g_fnd_user_id,

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

2275: body_block :='
2276: AND gel.company_cost_center_org_id =
2277: fcoa2.company_cost_center_org_id
2278: AND fcoa2.attribute_id =
2279: gcs_utility_pkg.g_dimension_attr_info(''COMPANY_COST_CENTER_ORG_ID-COST_CENTER'').attribute_id
2280: AND fcoa2.version_id =
2281: gcs_utility_pkg.g_dimension_attr_info(''COMPANY_COST_CENTER_ORG_ID-COST_CENTER'').version_id
2282: AND gel.intercompany_id = fcoa3.company_cost_center_org_id
2283: AND fcoa3.attribute_id =

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

2277: fcoa2.company_cost_center_org_id
2278: AND fcoa2.attribute_id =
2279: gcs_utility_pkg.g_dimension_attr_info(''COMPANY_COST_CENTER_ORG_ID-COST_CENTER'').attribute_id
2280: AND fcoa2.version_id =
2281: gcs_utility_pkg.g_dimension_attr_info(''COMPANY_COST_CENTER_ORG_ID-COST_CENTER'').version_id
2282: AND gel.intercompany_id = fcoa3.company_cost_center_org_id
2283: AND fcoa3.attribute_id =
2284: gcs_utility_pkg.g_dimension_attr_info(''COMPANY_COST_CENTER_ORG_ID-COST_CENTER'').attribute_id
2285: AND fcoa3.version_id =

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

2280: AND fcoa2.version_id =
2281: gcs_utility_pkg.g_dimension_attr_info(''COMPANY_COST_CENTER_ORG_ID-COST_CENTER'').version_id
2282: AND gel.intercompany_id = fcoa3.company_cost_center_org_id
2283: AND fcoa3.attribute_id =
2284: gcs_utility_pkg.g_dimension_attr_info(''COMPANY_COST_CENTER_ORG_ID-COST_CENTER'').attribute_id
2285: AND fcoa3.version_id =
2286: gcs_utility_pkg.g_dimension_attr_info(''COMPANY_COST_CENTER_ORG_ID-COST_CENTER'').version_id
2287: AND fcca.attribute_id = gcs_utility_pkg.g_dimension_attr_info(''USER_DIM1_ID-ELIMINATION_LOB'').attribute_id
2288: AND fcca.version_id = gcs_utility_pkg.g_dimension_attr_info(''USER_DIM1_ID-ELIMINATION_LOB'').version_id

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

2282: AND gel.intercompany_id = fcoa3.company_cost_center_org_id
2283: AND fcoa3.attribute_id =
2284: gcs_utility_pkg.g_dimension_attr_info(''COMPANY_COST_CENTER_ORG_ID-COST_CENTER'').attribute_id
2285: AND fcoa3.version_id =
2286: gcs_utility_pkg.g_dimension_attr_info(''COMPANY_COST_CENTER_ORG_ID-COST_CENTER'').version_id
2287: AND fcca.attribute_id = gcs_utility_pkg.g_dimension_attr_info(''USER_DIM1_ID-ELIMINATION_LOB'').attribute_id
2288: AND fcca.version_id = gcs_utility_pkg.g_dimension_attr_info(''USER_DIM1_ID-ELIMINATION_LOB'').version_id
2289: ';
2290: --******--

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

2283: AND fcoa3.attribute_id =
2284: gcs_utility_pkg.g_dimension_attr_info(''COMPANY_COST_CENTER_ORG_ID-COST_CENTER'').attribute_id
2285: AND fcoa3.version_id =
2286: gcs_utility_pkg.g_dimension_attr_info(''COMPANY_COST_CENTER_ORG_ID-COST_CENTER'').version_id
2287: AND fcca.attribute_id = gcs_utility_pkg.g_dimension_attr_info(''USER_DIM1_ID-ELIMINATION_LOB'').attribute_id
2288: AND fcca.version_id = gcs_utility_pkg.g_dimension_attr_info(''USER_DIM1_ID-ELIMINATION_LOB'').version_id
2289: ';
2290: --******--
2291: curr_pos := 1;

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

2284: gcs_utility_pkg.g_dimension_attr_info(''COMPANY_COST_CENTER_ORG_ID-COST_CENTER'').attribute_id
2285: AND fcoa3.version_id =
2286: gcs_utility_pkg.g_dimension_attr_info(''COMPANY_COST_CENTER_ORG_ID-COST_CENTER'').version_id
2287: AND fcca.attribute_id = gcs_utility_pkg.g_dimension_attr_info(''USER_DIM1_ID-ELIMINATION_LOB'').attribute_id
2288: AND fcca.version_id = gcs_utility_pkg.g_dimension_attr_info(''USER_DIM1_ID-ELIMINATION_LOB'').version_id
2289: ';
2290: --******--
2291: curr_pos := 1;
2292: body_len := LENGTH(body_block);

Line 2369: GCS_UTILITY_PKG.g_nl, line_num);

2365:
2366:
2367: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Join_List(
2368: ' AND giet1.', ' = gel. ',
2369: GCS_UTILITY_PKG.g_nl, line_num);
2370:
2371:
2372:
2373: body_block :=

Line 2458: 'gel.', GCS_UTILITY_PKG.g_nl, ' NULL, ', line_num);

2454: END LOOP;
2455:
2456:
2457: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(
2458: 'gel.', GCS_UTILITY_PKG.g_nl, ' NULL, ', line_num);
2459:
2460: body_block := '
2461: SYSDATE, g_fnd_user_id,
2462: SYSDATE, g_fnd_user_id,

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

2510: body_block :='
2511: AND gel.company_cost_center_org_id =
2512: fcoa2.company_cost_center_org_id
2513: AND fcoa2.attribute_id =
2514: gcs_utility_pkg.g_dimension_attr_info(''COMPANY_COST_CENTER_ORG_ID-COST_CENTER'').attribute_id
2515: AND fcoa2.version_id =
2516: gcs_utility_pkg.g_dimension_attr_info(''COMPANY_COST_CENTER_ORG_ID-COST_CENTER'').version_id
2517: AND gel.intercompany_id = fcoa3.company_cost_center_org_id
2518: AND fcoa3.attribute_id =

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

2512: fcoa2.company_cost_center_org_id
2513: AND fcoa2.attribute_id =
2514: gcs_utility_pkg.g_dimension_attr_info(''COMPANY_COST_CENTER_ORG_ID-COST_CENTER'').attribute_id
2515: AND fcoa2.version_id =
2516: gcs_utility_pkg.g_dimension_attr_info(''COMPANY_COST_CENTER_ORG_ID-COST_CENTER'').version_id
2517: AND gel.intercompany_id = fcoa3.company_cost_center_org_id
2518: AND fcoa3.attribute_id =
2519: gcs_utility_pkg.g_dimension_attr_info(''COMPANY_COST_CENTER_ORG_ID-COST_CENTER'').attribute_id
2520: AND fcoa3.version_id =

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

2515: AND fcoa2.version_id =
2516: gcs_utility_pkg.g_dimension_attr_info(''COMPANY_COST_CENTER_ORG_ID-COST_CENTER'').version_id
2517: AND gel.intercompany_id = fcoa3.company_cost_center_org_id
2518: AND fcoa3.attribute_id =
2519: gcs_utility_pkg.g_dimension_attr_info(''COMPANY_COST_CENTER_ORG_ID-COST_CENTER'').attribute_id
2520: AND fcoa3.version_id =
2521: gcs_utility_pkg.g_dimension_attr_info(''COMPANY_COST_CENTER_ORG_ID-COST_CENTER'').version_id
2522: AND fcca.attribute_id = gcs_utility_pkg.g_dimension_attr_info(''USER_DIM1_ID-ELIMINATION_LOB'').attribute_id
2523: AND fcca.version_id = gcs_utility_pkg.g_dimension_attr_info(''USER_DIM1_ID-ELIMINATION_LOB'').version_id

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

2517: AND gel.intercompany_id = fcoa3.company_cost_center_org_id
2518: AND fcoa3.attribute_id =
2519: gcs_utility_pkg.g_dimension_attr_info(''COMPANY_COST_CENTER_ORG_ID-COST_CENTER'').attribute_id
2520: AND fcoa3.version_id =
2521: gcs_utility_pkg.g_dimension_attr_info(''COMPANY_COST_CENTER_ORG_ID-COST_CENTER'').version_id
2522: AND fcca.attribute_id = gcs_utility_pkg.g_dimension_attr_info(''USER_DIM1_ID-ELIMINATION_LOB'').attribute_id
2523: AND fcca.version_id = gcs_utility_pkg.g_dimension_attr_info(''USER_DIM1_ID-ELIMINATION_LOB'').version_id
2524: ';
2525: --******--

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

2518: AND fcoa3.attribute_id =
2519: gcs_utility_pkg.g_dimension_attr_info(''COMPANY_COST_CENTER_ORG_ID-COST_CENTER'').attribute_id
2520: AND fcoa3.version_id =
2521: gcs_utility_pkg.g_dimension_attr_info(''COMPANY_COST_CENTER_ORG_ID-COST_CENTER'').version_id
2522: AND fcca.attribute_id = gcs_utility_pkg.g_dimension_attr_info(''USER_DIM1_ID-ELIMINATION_LOB'').attribute_id
2523: AND fcca.version_id = gcs_utility_pkg.g_dimension_attr_info(''USER_DIM1_ID-ELIMINATION_LOB'').version_id
2524: ';
2525: --******--
2526: curr_pos := 1;

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

2519: gcs_utility_pkg.g_dimension_attr_info(''COMPANY_COST_CENTER_ORG_ID-COST_CENTER'').attribute_id
2520: AND fcoa3.version_id =
2521: gcs_utility_pkg.g_dimension_attr_info(''COMPANY_COST_CENTER_ORG_ID-COST_CENTER'').version_id
2522: AND fcca.attribute_id = gcs_utility_pkg.g_dimension_attr_info(''USER_DIM1_ID-ELIMINATION_LOB'').attribute_id
2523: AND fcca.version_id = gcs_utility_pkg.g_dimension_attr_info(''USER_DIM1_ID-ELIMINATION_LOB'').version_id
2524: ';
2525: --******--
2526: curr_pos := 1;
2527: body_len := LENGTH(body_block);

Line 2604: GCS_UTILITY_PKG.g_nl, line_num);

2600:
2601:
2602: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Join_List(
2603: ' AND giet1.', ' = gel. ',
2604: GCS_UTILITY_PKG.g_nl, line_num);
2605:
2606:
2607:
2608: body_block :=

Line 2709: ' ', GCS_UTILITY_PKG.g_nl, ' NULL, ', line_num);

2705: END LOOP;
2706:
2707:
2708: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(
2709: ' ', GCS_UTILITY_PKG.g_nl, ' NULL, ', line_num);
2710:
2711:
2712: body_block := '
2713: SYSDATE, g_fnd_user_id,

Line 2779: ' AND giet1.', ' = gel. ', GCS_UTILITY_PKG.g_nl, line_num);

2775: END LOOP;
2776:
2777:
2778: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Join_List(
2779: ' AND giet1.', ' = gel. ', GCS_UTILITY_PKG.g_nl, line_num);
2780:
2781: body_block := '
2782: AND giet1.line_item_id = gel.line_item_id);
2783:

Line 2866: ' ', GCS_UTILITY_PKG.g_nl, ' NULL, ', line_num);

2862: END LOOP;
2863:
2864:
2865: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(
2866: ' ', GCS_UTILITY_PKG.g_nl, ' NULL, ', line_num);
2867:
2868:
2869: body_block := '
2870: SYSDATE, g_fnd_user_id,

Line 2936: ' AND giet1.', ' = gel. ', GCS_UTILITY_PKG.g_nl, line_num);

2932: END LOOP;
2933:
2934:
2935: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Join_List(
2936: ' AND giet1.', ' = gel. ', GCS_UTILITY_PKG.g_nl, line_num);
2937:
2938: body_block := '
2939: AND giet1.line_item_id = gel.line_item_id);
2940:

Line 3044: ' ', GCS_UTILITY_PKG.g_nl, ' NULL, ', line_num);

3040: END LOOP;
3041:
3042:
3043: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(
3044: ' ', GCS_UTILITY_PKG.g_nl, ' NULL, ', line_num);
3045:
3046: body_block := '
3047: SYSDATE, g_fnd_user_id,
3048: SYSDATE, g_fnd_user_id,

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

3093:
3094:
3095: body_block := '
3096: AND fcoa2.attribute_id =
3097: gcs_utility_pkg.g_dimension_attr_info(''COMPANY_COST_CENTER_ORG_ID-COMPANY'').attribute_id
3098: AND fcoa2.version_id =
3099: gcs_utility_pkg.g_dimension_attr_info(''COMPANY_COST_CENTER_ORG_ID-COMPANY'').version_id
3100: AND gel.intercompany_id = fcoa3.company_cost_center_org_id
3101: AND fcoa3.attribute_id =

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

3095: body_block := '
3096: AND fcoa2.attribute_id =
3097: gcs_utility_pkg.g_dimension_attr_info(''COMPANY_COST_CENTER_ORG_ID-COMPANY'').attribute_id
3098: AND fcoa2.version_id =
3099: gcs_utility_pkg.g_dimension_attr_info(''COMPANY_COST_CENTER_ORG_ID-COMPANY'').version_id
3100: AND gel.intercompany_id = fcoa3.company_cost_center_org_id
3101: AND fcoa3.attribute_id =
3102: gcs_utility_pkg.g_dimension_attr_info(''COMPANY_COST_CENTER_ORG_ID-COMPANY'').attribute_id
3103: AND fcoa3.version_id =

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

3098: AND fcoa2.version_id =
3099: gcs_utility_pkg.g_dimension_attr_info(''COMPANY_COST_CENTER_ORG_ID-COMPANY'').version_id
3100: AND gel.intercompany_id = fcoa3.company_cost_center_org_id
3101: AND fcoa3.attribute_id =
3102: gcs_utility_pkg.g_dimension_attr_info(''COMPANY_COST_CENTER_ORG_ID-COMPANY'').attribute_id
3103: AND fcoa3.version_id =
3104: gcs_utility_pkg.g_dimension_attr_info(''COMPANY_COST_CENTER_ORG_ID-COMPANY'').version_id
3105:
3106: ';

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

3100: AND gel.intercompany_id = fcoa3.company_cost_center_org_id
3101: AND fcoa3.attribute_id =
3102: gcs_utility_pkg.g_dimension_attr_info(''COMPANY_COST_CENTER_ORG_ID-COMPANY'').attribute_id
3103: AND fcoa3.version_id =
3104: gcs_utility_pkg.g_dimension_attr_info(''COMPANY_COST_CENTER_ORG_ID-COMPANY'').version_id
3105:
3106: ';
3107: --******--
3108: curr_pos := 1;

Line 3145: ' AND giet1.', ' = gel. ', GCS_UTILITY_PKG.g_nl, line_num);

3141:
3142:
3143:
3144: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Join_List(
3145: ' AND giet1.', ' = gel. ', GCS_UTILITY_PKG.g_nl, line_num);
3146:
3147: body_block := '
3148: AND giet1.line_item_id = gel.line_item_id);
3149:

Line 3253: ' ', GCS_UTILITY_PKG.g_nl, ' NULL, ', line_num);

3249: END LOOP;
3250:
3251:
3252: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(
3253: ' ', GCS_UTILITY_PKG.g_nl, ' NULL, ', line_num);
3254:
3255: body_block := '
3256: SYSDATE, g_fnd_user_id,
3257: SYSDATE, g_fnd_user_id,

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

3301:
3302:
3303: body_block := '
3304: AND fcoa2.attribute_id =
3305: gcs_utility_pkg.g_dimension_attr_info(''COMPANY_COST_CENTER_ORG_ID-COMPANY'').attribute_id
3306: AND fcoa2.version_id =
3307: gcs_utility_pkg.g_dimension_attr_info(''COMPANY_COST_CENTER_ORG_ID-COMPANY'').version_id
3308: AND gel.intercompany_id = fcoa3.company_cost_center_org_id
3309: AND fcoa3.attribute_id =

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

3303: body_block := '
3304: AND fcoa2.attribute_id =
3305: gcs_utility_pkg.g_dimension_attr_info(''COMPANY_COST_CENTER_ORG_ID-COMPANY'').attribute_id
3306: AND fcoa2.version_id =
3307: gcs_utility_pkg.g_dimension_attr_info(''COMPANY_COST_CENTER_ORG_ID-COMPANY'').version_id
3308: AND gel.intercompany_id = fcoa3.company_cost_center_org_id
3309: AND fcoa3.attribute_id =
3310: gcs_utility_pkg.g_dimension_attr_info(''COMPANY_COST_CENTER_ORG_ID-COMPANY'').attribute_id
3311: AND fcoa3.version_id =

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

3306: AND fcoa2.version_id =
3307: gcs_utility_pkg.g_dimension_attr_info(''COMPANY_COST_CENTER_ORG_ID-COMPANY'').version_id
3308: AND gel.intercompany_id = fcoa3.company_cost_center_org_id
3309: AND fcoa3.attribute_id =
3310: gcs_utility_pkg.g_dimension_attr_info(''COMPANY_COST_CENTER_ORG_ID-COMPANY'').attribute_id
3311: AND fcoa3.version_id =
3312: gcs_utility_pkg.g_dimension_attr_info(''COMPANY_COST_CENTER_ORG_ID-COMPANY'').version_id
3313: AND fcoa3.dim_attribute_numeric_member <>
3314: fcoa2.dim_attribute_numeric_member

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

3308: AND gel.intercompany_id = fcoa3.company_cost_center_org_id
3309: AND fcoa3.attribute_id =
3310: gcs_utility_pkg.g_dimension_attr_info(''COMPANY_COST_CENTER_ORG_ID-COMPANY'').attribute_id
3311: AND fcoa3.version_id =
3312: gcs_utility_pkg.g_dimension_attr_info(''COMPANY_COST_CENTER_ORG_ID-COMPANY'').version_id
3313: AND fcoa3.dim_attribute_numeric_member <>
3314: fcoa2.dim_attribute_numeric_member
3315:
3316: ';

Line 3355: ' AND giet1.', ' = gel. ', GCS_UTILITY_PKG.g_nl, line_num);

3351:
3352:
3353:
3354: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Join_List(
3355: ' AND giet1.', ' = gel. ', GCS_UTILITY_PKG.g_nl, line_num);
3356:
3357: body_block := '
3358: AND giet1.line_item_id = gel.line_item_id);
3359:

Line 3395: GCS_UTILITY_PKG.g_module_success || l_api_name ||

3391: THEN
3392:
3393: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3394: g_pkg_name || ''.'' || l_api_name,
3395: GCS_UTILITY_PKG.g_module_success || l_api_name ||
3396: to_char(sysdate, '' DD-MON-YYYY HH:MI:SS''));
3397: END IF;
3398:
3399: COMMIT;

Line 3483: GCS_UTILITY_PKG.g_module_failure || l_api_name ||

3479: g_pkg_name || ''.'' || l_api_name,
3480: SUBSTR(SQLERRM, 1, 255));
3481: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
3482: g_pkg_name || ''.'' || l_api_name,
3483: GCS_UTILITY_PKG.g_module_failure || l_api_name ||
3484: to_char(sysdate, '' DD-MON-YYYY HH:MI:SS''));
3485: END IF;
3486:
3487: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure

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

3483: GCS_UTILITY_PKG.g_module_failure || l_api_name ||
3484: to_char(sysdate, '' DD-MON-YYYY HH:MI:SS''));
3485: END IF;
3486:
3487: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure
3488: -- ||l_api_name || to_char(sysdate
3489: -- , '' DD-MON-YYYY HH:MI:SS''));
3490: x_retcode := 2;
3491:

Line 3512: gcs_utility_pkg.g_module_success

3508: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3509:
3510: fnd_log.STRING (fnd_log.level_procedure,
3511: g_pkg_name || ''.'' || l_api_name,
3512: gcs_utility_pkg.g_module_success
3513: || '' ''
3514: || l_api_name
3515: || ''() ''
3516: || TO_CHAR (SYSDATE, ''DD-MON-YYYY HH:MI:SS'')

Line 3561: GCS_UTILITY_PKG.g_module_failure || l_api_name ||

3557:
3558: SUBSTR(SQLERRM, 1, 255));
3559: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
3560: g_api || '.' || l_api_name,
3561: GCS_UTILITY_PKG.g_module_failure || l_api_name ||
3562: to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));
3563: END IF;
3564: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure
3565: -- ||l_api_name || to_char(sysdate

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

3560: g_api || '.' || l_api_name,
3561: GCS_UTILITY_PKG.g_module_failure || l_api_name ||
3562: to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));
3563: END IF;
3564: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure
3565: -- ||l_api_name || to_char(sysdate
3566: -- , ' DD-MON-YYYY HH:MI:SS'));
3567:
3568: