APPS.EDW_ORGANIZATION_M_C dependencies on EDW_COLLECTION_UTIL

Line 89: l_push_lookup := EDW_COLLECTION_UTIL.get_lookup_value(

85: /* If pushing down, fetch the push down level lookup */
86: /*****************************************************/
87: IF (p_from_level > p_to_level) THEN
88: /* Get push lookup */
89: l_push_lookup := EDW_COLLECTION_UTIL.get_lookup_value(
90: 'EDW_LEVEL_LOOKUP', l_push_from_level);
91: /* Write warning message if lookup doesn't exist */
92: IF (l_push_lookup IS NULL) THEN
93: edw_log.put_line('**Warning**: No Lookup Code Found in GET_LOOKUP_VALUE');

Line 475: l_tmp_str1 := EDW_COLLECTION_UTIL.get_lookup_value(

471:
472:
473: -- Start of change by S.Bhattal, 11-OCT-2000
474:
475: l_tmp_str1 := EDW_COLLECTION_UTIL.get_lookup_value(
476: 'EDW_LEVEL_LOOKUP', 'ORG_OPERATING_UNIT' );
477:
478: l_tmp_str2 := EDW_COLLECTION_UTIL.get_lookup_value(
479: 'EDW_LEVEL_LOOKUP', 'ORG_LEGAL_ENTITY' );

Line 478: l_tmp_str2 := EDW_COLLECTION_UTIL.get_lookup_value(

474:
475: l_tmp_str1 := EDW_COLLECTION_UTIL.get_lookup_value(
476: 'EDW_LEVEL_LOOKUP', 'ORG_OPERATING_UNIT' );
477:
478: l_tmp_str2 := EDW_COLLECTION_UTIL.get_lookup_value(
479: 'EDW_LEVEL_LOOKUP', 'ORG_LEGAL_ENTITY' );
480:
481: if (l_tmp_str1 is null) or (l_tmp_str2 is null) THEN
482: edw_log.put_line('***Warning*** : No Lookup Code Found in GET_LOOKUP_VALUE when Pushing Operating Unit');

Line 684: l_tmp_str := EDW_COLLECTION_UTIL.get_lookup_value(

680: edw_log.put_line(' ');
681:
682: -- Start of change by S.Bhattal, 11-OCT-2000
683:
684: l_tmp_str := EDW_COLLECTION_UTIL.get_lookup_value(
685: 'EDW_LEVEL_LOOKUP', 'ORG_LEGAL_ENTITY' );
686:
687: if(l_tmp_str is null) THEN
688: edw_log.put_line('***Warning*** : No Lookup Code Found in GET_LOOKUP_VALUE when Pushing Legal Entity');

Line 957: If (Not EDW_COLLECTION_UTIL.setup('EDW_ORGANIZATION_M')) Then

953:
954: Errbuf := NULL;
955: Retcode := 0;
956:
957: If (Not EDW_COLLECTION_UTIL.setup('EDW_ORGANIZATION_M')) Then
958: Return;
959: End If;
960:
961: -- Added by S.Bhattal, AUG-2000

Line 972: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);

968:
969: -- End of change
970:
971: g_push_date_range1 := nvl(l_from_date,
972: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
973:
974: g_push_date_range2 := nvl(l_to_date, EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
975:
976: edw_log.put_line( 'The collection range is from '||

Line 974: g_push_date_range2 := nvl(l_to_date, EDW_COLLECTION_UTIL.G_local_curr_push_start_date);

970:
971: g_push_date_range1 := nvl(l_from_date,
972: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
973:
974: g_push_date_range2 := nvl(l_to_date, EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
975:
976: edw_log.put_line( 'The collection range is from '||
977: to_char(g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
978: to_char(g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));

Line 1046: EDW_COLLECTION_UTIL.wrapup(TRUE, EDW_ORGANIZATION_M_C.g_row_count, null, g_push_date_range1, g_push_date_range2);

1042: edw_log.put_line( 'Org Tree 1 routine completed ok' );
1043:
1044: /*************************************************/
1045:
1046: EDW_COLLECTION_UTIL.wrapup(TRUE, EDW_ORGANIZATION_M_C.g_row_count, null, g_push_date_range1, g_push_date_range2);
1047:
1048: Exception
1049:
1050: When others then

Line 1056: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_ORGANIZATION_M_C.g_exception_message, g_push_date_range1, g_push_date_range2);

1052: Errbuf := sqlerrm;
1053: Retcode := sqlcode;
1054:
1055: EDW_ORGANIZATION_M_C.g_exception_message := EDW_ORGANIZATION_M_C.g_exception_message ||'<>'||Retcode || ':' || Errbuf;
1056: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_ORGANIZATION_M_C.g_exception_message, g_push_date_range1, g_push_date_range2);
1057:
1058: raise;
1059:
1060: End Push;