51: -- initialize the message stack
52: FND_MSG_PUB.Initialize;
53:
54:
55: HZ_MGD_MASS_UPDATE_REP_GEN.Initialize;
56:
57: HZ_MGD_MASS_UPDATE_REP_GEN.log( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_PROCEDURE
58: , p_msg => '>> Run_Mass_Update_Credit_Usages');
59:
53:
54:
55: HZ_MGD_MASS_UPDATE_REP_GEN.Initialize;
56:
57: HZ_MGD_MASS_UPDATE_REP_GEN.log( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_PROCEDURE
58: , p_msg => '>> Run_Mass_Update_Credit_Usages');
59:
60: -----assigning p_release to the global G_RELEASE
61: HZ_MGD_MASS_UPDATE_REP_GEN.log
57: HZ_MGD_MASS_UPDATE_REP_GEN.log( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_PROCEDURE
58: , p_msg => '>> Run_Mass_Update_Credit_Usages');
59:
60: -----assigning p_release to the global G_RELEASE
61: HZ_MGD_MASS_UPDATE_REP_GEN.log
62: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_STATEMENT
63: , p_msg => 'assigning p_release to the global G_RELEASE='
64: ||p_release
65: );
58: , p_msg => '>> Run_Mass_Update_Credit_Usages');
59:
60: -----assigning p_release to the global G_RELEASE
61: HZ_MGD_MASS_UPDATE_REP_GEN.log
62: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_STATEMENT
63: , p_msg => 'assigning p_release to the global G_RELEASE='
64: ||p_release
65: );
66:
65: );
66:
67: HZ_MGD_MASS_UPDATE_CP.G_RELEASE:=p_release;
68:
69: HZ_MGD_MASS_UPDATE_REP_GEN.log
70: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_STATEMENT
71: , p_msg => 'p_profile_class_id='||TO_CHAR(p_profile_class_id)
72: ||'p_currency_code='||p_currency_code
73: );
66:
67: HZ_MGD_MASS_UPDATE_CP.G_RELEASE:=p_release;
68:
69: HZ_MGD_MASS_UPDATE_REP_GEN.log
70: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_STATEMENT
71: , p_msg => 'p_profile_class_id='||TO_CHAR(p_profile_class_id)
72: ||'p_currency_code='||p_currency_code
73: );
74:
83:
84: COMMIT;
85:
86: -- Print the Report
87: HZ_MGD_MASS_UPDATE_REP_GEN.Generate_Report
88: ( p_prof_class_id => p_profile_class_id
89: , p_currency_code => p_currency_code
90: , p_profile_class_amount_id => p_profile_class_amount_id
91: );
89: , p_currency_code => p_currency_code
90: , p_profile_class_amount_id => p_profile_class_amount_id
91: );
92:
93: HZ_MGD_MASS_UPDATE_REP_GEN.Log( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_PROCEDURE
94: , p_msg => '<< Run_Mass_Update_Credit_Usages');
95:
96:
97: EXCEPTION
95:
96:
97: EXCEPTION
98: WHEN OTHERS THEN
99: HZ_MGD_MASS_UPDATE_REP_GEN.Log(HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_EXCEPTION,'SQLERRM '|| SQLERRM) ;
100:
101: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
102: THEN
103: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, 'Run_Mass_Update_Credit_Usages');