DBA Data[Home] [Help]

APPS.XTR_CALC_P dependencies on FND_MESSAGE

Line 90: FND_MESSAGE.Set_Name('XTR', 'XTR_1059');

86: begin
87: if start_date is not null and end_date is not null and method is not null then
88:
89: if l_end_date 90: FND_MESSAGE.Set_Name('XTR', 'XTR_1059');
91: APP_EXCEPTION.raise_exception;
92:
93: else
94:

Line 486: FND_MESSAGE.Set_Name('XTR','XTR_2171');

482: Fetch BOND_DETAILS into l_currency, l_coupon_rate, l_frequency, l_bond_maturity_date,
483: l_year_calc_type, l_bond_start_date, l_calc_type;
484: If (BOND_DETAILS%NOTFOUND) then
485: Close BOND_DETAILS;
486: FND_MESSAGE.Set_Name('XTR','XTR_2171');
487: APP_EXCEPTION.Raise_Exception;
488: End If;
489: Close BOND_DETAILS;
490:

Line 496: FND_MESSAGE.Set_Name('XTR','XTR_2171');

492: open CHK_OVERRIDE ;
493: fetch CHK_OVERRIDE into l_chk_commence,l_orig_freq,l_first_orig_coupon_date;
494: If (CHK_OVERRIDE%NOTFOUND) then
495: Close CHK_OVERRIDE;
496: FND_MESSAGE.Set_Name('XTR','XTR_2171');
497: APP_EXCEPTION.Raise_Exception;
498: End If;
499: close CHK_OVERRIDE;
500:

Line 768: FND_MESSAGE.Set_Name ('XTR', 'XTR_2172');

764: WHEN OTHERS then
765: errnum := SQLCODE;
766: errmsg := SUBSTR(SQLERRM,1,100);
767: l_errmsg := to_char(errnum) || ' - ' || errmsg;
768: FND_MESSAGE.Set_Name ('XTR', 'XTR_2172');
769: FND_MESSAGE.Set_Token ('TABLE', 'XTR_ROLLOVER_TRANSACTIONS');
770: FND_MESSAGE.Set_Token ('ERRCODE_TEXT', l_errmsg);
771: APP_EXCEPTION.Raise_Exception;
772: END;

Line 769: FND_MESSAGE.Set_Token ('TABLE', 'XTR_ROLLOVER_TRANSACTIONS');

765: errnum := SQLCODE;
766: errmsg := SUBSTR(SQLERRM,1,100);
767: l_errmsg := to_char(errnum) || ' - ' || errmsg;
768: FND_MESSAGE.Set_Name ('XTR', 'XTR_2172');
769: FND_MESSAGE.Set_Token ('TABLE', 'XTR_ROLLOVER_TRANSACTIONS');
770: FND_MESSAGE.Set_Token ('ERRCODE_TEXT', l_errmsg);
771: APP_EXCEPTION.Raise_Exception;
772: END;
773:

Line 770: FND_MESSAGE.Set_Token ('ERRCODE_TEXT', l_errmsg);

766: errmsg := SUBSTR(SQLERRM,1,100);
767: l_errmsg := to_char(errnum) || ' - ' || errmsg;
768: FND_MESSAGE.Set_Name ('XTR', 'XTR_2172');
769: FND_MESSAGE.Set_Token ('TABLE', 'XTR_ROLLOVER_TRANSACTIONS');
770: FND_MESSAGE.Set_Token ('ERRCODE_TEXT', l_errmsg);
771: APP_EXCEPTION.Raise_Exception;
772: END;
773:
774: BEGIN

Line 875: FND_MESSAGE.Set_Name ('XTR', 'XTR_2172');

871: WHEN OTHERS then
872: errnum := SQLCODE;
873: errmsg := SUBSTR(SQLERRM,1,100);
874: l_errmsg := to_char(errnum) || '. ' || errmsg;
875: FND_MESSAGE.Set_Name ('XTR', 'XTR_2172');
876: FND_MESSAGE.Set_Token ('TABLE', 'XTR_DEAL_DATE_AMOUNTS');
877: FND_MESSAGE.Set_Token ('ERRCODE_TEXT', l_errmsg);
878: APP_EXCEPTION.Raise_Exception;
879: END;

Line 876: FND_MESSAGE.Set_Token ('TABLE', 'XTR_DEAL_DATE_AMOUNTS');

872: errnum := SQLCODE;
873: errmsg := SUBSTR(SQLERRM,1,100);
874: l_errmsg := to_char(errnum) || '. ' || errmsg;
875: FND_MESSAGE.Set_Name ('XTR', 'XTR_2172');
876: FND_MESSAGE.Set_Token ('TABLE', 'XTR_DEAL_DATE_AMOUNTS');
877: FND_MESSAGE.Set_Token ('ERRCODE_TEXT', l_errmsg);
878: APP_EXCEPTION.Raise_Exception;
879: END;
880:

Line 877: FND_MESSAGE.Set_Token ('ERRCODE_TEXT', l_errmsg);

873: errmsg := SUBSTR(SQLERRM,1,100);
874: l_errmsg := to_char(errnum) || '. ' || errmsg;
875: FND_MESSAGE.Set_Name ('XTR', 'XTR_2172');
876: FND_MESSAGE.Set_Token ('TABLE', 'XTR_DEAL_DATE_AMOUNTS');
877: FND_MESSAGE.Set_Token ('ERRCODE_TEXT', l_errmsg);
878: APP_EXCEPTION.Raise_Exception;
879: END;
880:
881: l_last_coupon_date := l_coupon_date;

Line 1097: -- fnd_message.debug('l_start_date = ' || l_start_date);

1093: open START_ROW;
1094: fetch START_ROW INTO l_start_date;
1095: close START_ROW;
1096:
1097: -- fnd_message.debug('l_start_date = ' || l_start_date);
1098: -- fnd_message.debug('l_ref_date = ' || l_ref_date);
1099: -- fnd_message.debug(' l_trans_num = ' || l_trans_num);
1100:
1101: if l_start_date is NULL then

Line 1098: -- fnd_message.debug('l_ref_date = ' || l_ref_date);

1094: fetch START_ROW INTO l_start_date;
1095: close START_ROW;
1096:
1097: -- fnd_message.debug('l_start_date = ' || l_start_date);
1098: -- fnd_message.debug('l_ref_date = ' || l_ref_date);
1099: -- fnd_message.debug(' l_trans_num = ' || l_trans_num);
1100:
1101: if l_start_date is NULL then
1102: l_start_date := l_ref_date;

Line 1099: -- fnd_message.debug(' l_trans_num = ' || l_trans_num);

1095: close START_ROW;
1096:
1097: -- fnd_message.debug('l_start_date = ' || l_start_date);
1098: -- fnd_message.debug('l_ref_date = ' || l_ref_date);
1099: -- fnd_message.debug(' l_trans_num = ' || l_trans_num);
1100:
1101: if l_start_date is NULL then
1102: l_start_date := l_ref_date;
1103: l_prv_row_exists := 'N';