16: --Change History:
17: --Who When What
18: -------------------------------------------------------------------
19: BEGIN
20: FND_MESSAGE.SET_NAME('IGS','IGS_FI_CAL_BALANCES_LOG');
21: FND_MESSAGE.SET_TOKEN('PARAMETER_NAME',p_msg_name);
22: FND_MESSAGE.SET_TOKEN('PARAMETER_VAL' ,p_msg_val) ;
23: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
24: END log_messages ;
17: --Who When What
18: -------------------------------------------------------------------
19: BEGIN
20: FND_MESSAGE.SET_NAME('IGS','IGS_FI_CAL_BALANCES_LOG');
21: FND_MESSAGE.SET_TOKEN('PARAMETER_NAME',p_msg_name);
22: FND_MESSAGE.SET_TOKEN('PARAMETER_VAL' ,p_msg_val) ;
23: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
24: END log_messages ;
25:
18: -------------------------------------------------------------------
19: BEGIN
20: FND_MESSAGE.SET_NAME('IGS','IGS_FI_CAL_BALANCES_LOG');
21: FND_MESSAGE.SET_TOKEN('PARAMETER_NAME',p_msg_name);
22: FND_MESSAGE.SET_TOKEN('PARAMETER_VAL' ,p_msg_val) ;
23: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
24: END log_messages ;
25:
26: PROCEDURE aggregate_match(
19: BEGIN
20: FND_MESSAGE.SET_NAME('IGS','IGS_FI_CAL_BALANCES_LOG');
21: FND_MESSAGE.SET_TOKEN('PARAMETER_NAME',p_msg_name);
22: FND_MESSAGE.SET_TOKEN('PARAMETER_VAL' ,p_msg_val) ;
23: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
24: END log_messages ;
25:
26: PROCEDURE aggregate_match(
27: errbuf OUT NOCOPY VARCHAR2,
124: l_fseog_pcntg := (NVL(l_tot_fseog,0)/l_total) * 100;
125: l_match_pcntg := (NVL(l_tot_match,0)/l_total) * 100;
126: END IF;
127:
128: FND_MESSAGE.SET_NAME('IGF','IGF_AW_FSEOG_PERCENTAGE');
129: FND_MESSAGE.SET_TOKEN('FSEOG_PCNTG',l_fseog_pcntg);
130: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
131:
132: FND_MESSAGE.SET_NAME('IGF','IGF_AW_MATCH_PERCENTAGE');
125: l_match_pcntg := (NVL(l_tot_match,0)/l_total) * 100;
126: END IF;
127:
128: FND_MESSAGE.SET_NAME('IGF','IGF_AW_FSEOG_PERCENTAGE');
129: FND_MESSAGE.SET_TOKEN('FSEOG_PCNTG',l_fseog_pcntg);
130: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
131:
132: FND_MESSAGE.SET_NAME('IGF','IGF_AW_MATCH_PERCENTAGE');
133: FND_MESSAGE.SET_TOKEN('MATCH_PCNTG',l_match_pcntg);
126: END IF;
127:
128: FND_MESSAGE.SET_NAME('IGF','IGF_AW_FSEOG_PERCENTAGE');
129: FND_MESSAGE.SET_TOKEN('FSEOG_PCNTG',l_fseog_pcntg);
130: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
131:
132: FND_MESSAGE.SET_NAME('IGF','IGF_AW_MATCH_PERCENTAGE');
133: FND_MESSAGE.SET_TOKEN('MATCH_PCNTG',l_match_pcntg);
134: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
128: FND_MESSAGE.SET_NAME('IGF','IGF_AW_FSEOG_PERCENTAGE');
129: FND_MESSAGE.SET_TOKEN('FSEOG_PCNTG',l_fseog_pcntg);
130: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
131:
132: FND_MESSAGE.SET_NAME('IGF','IGF_AW_MATCH_PERCENTAGE');
133: FND_MESSAGE.SET_TOKEN('MATCH_PCNTG',l_match_pcntg);
134: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
135:
136: EXCEPTION
129: FND_MESSAGE.SET_TOKEN('FSEOG_PCNTG',l_fseog_pcntg);
130: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
131:
132: FND_MESSAGE.SET_NAME('IGF','IGF_AW_MATCH_PERCENTAGE');
133: FND_MESSAGE.SET_TOKEN('MATCH_PCNTG',l_match_pcntg);
134: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
135:
136: EXCEPTION
137: WHEN OTHERS THEN
130: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
131:
132: FND_MESSAGE.SET_NAME('IGF','IGF_AW_MATCH_PERCENTAGE');
133: FND_MESSAGE.SET_TOKEN('MATCH_PCNTG',l_match_pcntg);
134: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
135:
136: EXCEPTION
137: WHEN OTHERS THEN
138: retcode := 2;
135:
136: EXCEPTION
137: WHEN OTHERS THEN
138: retcode := 2;
139: errbuf := FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');
140: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL ;
141: END aggregate_match;
142: END igf_aw_fisap;