APPS.EDW_ORGANIZATION_M_C dependencies on EDW_ORGANIZATION_M_C

Line 1: Package Body EDW_ORGANIZATION_M_C AS

1: Package Body EDW_ORGANIZATION_M_C AS
2: /* $Header: hrieporg.pkb 120.1 2005/06/07 05:16:57 anmajumd noship $ */
3:
4: g_row_count NUMBER:= 0;
5: g_exception_message VARCHAR2(2000) := NULL;

Line 346: EDW_ORGANIZATION_M_C.g_row_count := EDW_ORGANIZATION_M_C.g_row_count +

342: ' rows into the EDW_ORGA_ORG_LSTG staging table');
343: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
344: edw_log.put_line(' ');
345:
346: EDW_ORGANIZATION_M_C.g_row_count := EDW_ORGANIZATION_M_C.g_row_count +
347: l_rows_inserted;
348:
349: -- ---------------------------------------------------------------------------
350: -- END OF Collection , Developer Customizable Section

Line 359: EDW_ORGANIZATION_M_C.g_exception_message := Retcode || ':' || Errbuf;

355: When others then
356:
357: Errbuf := sqlerrm;
358: Retcode := sqlcode;
359: EDW_ORGANIZATION_M_C.g_exception_message := Retcode || ':' || Errbuf;
360: rollback;
361:
362: raise;
363:

Line 569: EDW_ORGANIZATION_M_C.g_exception_message := Retcode || ':' || Errbuf;

565: When others then
566:
567: Errbuf := sqlerrm;
568: Retcode := sqlcode;
569: EDW_ORGANIZATION_M_C.g_exception_message := Retcode || ':' || Errbuf;
570: rollback;
571:
572: raise;
573:

Line 775: EDW_ORGANIZATION_M_C.g_exception_message := Retcode || ':' || Errbuf;

771: When others then
772:
773: Errbuf := sqlerrm;
774: Retcode := sqlcode;
775: EDW_ORGANIZATION_M_C.g_exception_message := Retcode || ':' || Errbuf;
776: rollback;
777:
778: raise;
779:

Line 898: EDW_ORGANIZATION_M_C.g_exception_message := Retcode || ':' || Errbuf;

894:
895: edw_log.put_line( 'In exception section of Push_Business_Grp' );
896: Errbuf := sqlerrm;
897: Retcode := sqlcode;
898: EDW_ORGANIZATION_M_C.g_exception_message := Retcode || ':' || Errbuf;
899: rollback;
900:
901: raise;
902:

Line 990: Edw_Organization_m_C.Push_INT_ORGANIZATION(

986:
987: edw_log.put_line(' ');
988: edw_log.put_line( 'About to call bottom-level orgs routine' );
989:
990: Edw_Organization_m_C.Push_INT_ORGANIZATION(
991: Errbuf,
992: Retcode,
993: g_push_date_range1,
994: g_push_date_range2

Line 1000: Edw_Organization_M_C.Push_Oper_Unit(

996:
997: edw_log.put_line( 'Bottom-level orgs routine completed ok' );
998: edw_log.put_line( 'About to call Operating Units routine' );
999:
1000: Edw_Organization_M_C.Push_Oper_Unit(
1001: Errbuf,
1002: Retcode,
1003: g_push_date_range1,
1004: g_push_date_range2

Line 1010: Edw_Organization_m_C.Push_Legal_Entity(

1006:
1007: edw_log.put_line( 'Operating Units routine completed ok' );
1008: edw_log.put_line( 'About to call Legal Entities routine' );
1009:
1010: Edw_Organization_m_C.Push_Legal_Entity(
1011: Errbuf,
1012: Retcode,
1013: g_push_date_range1,
1014: g_push_date_range2

Line 1020: Edw_Organization_M_C.Push_Business_Grp(

1016:
1017: edw_log.put_line( 'Legal Entities routine completed ok' );
1018: edw_log.put_line( 'About to call Business Groups routine' );
1019:
1020: Edw_Organization_M_C.Push_Business_Grp(
1021: Errbuf,
1022: Retcode,
1023: g_push_date_range1,
1024: g_push_date_range2

Line 1037: Edw_Organization_M_C.Push_Tree(

1033: /*************************************************/
1034:
1035: edw_log.put_line( 'About to call Org Tree 1 routine' );
1036:
1037: Edw_Organization_M_C.Push_Tree(
1038: p_from_date => g_push_date_range1,
1039: p_to_date => g_push_date_range2,
1040: p_tree => 1 );
1041:

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 1055: EDW_ORGANIZATION_M_C.g_exception_message := EDW_ORGANIZATION_M_C.g_exception_message ||'<>'||Retcode || ':' || Errbuf;

1051:
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:

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;

Line 1062: End EDW_ORGANIZATION_M_C;

1058: raise;
1059:
1060: End Push;
1061:
1062: End EDW_ORGANIZATION_M_C;