111: close c_trx_number_cur;
112:
113: if l_commitment_bal <= 0 then
114: --raise error if saved balance has exceeded allowed balance
115: FND_MESSAGE.SET_NAME('ONT','OE_COM_ZERO_BALANCE');
116: FND_MESSAGE.SET_TOKEN('COMMITMENT' , l_trx_number);
117: OE_MSG_PUB.ADD;
118: IF l_debug_level > 0 THEN
119: oe_debug_pub.add( ' COMMITMENT HAVE OVERDRAWN MORE THAN ONCE' ) ;
112:
113: if l_commitment_bal <= 0 then
114: --raise error if saved balance has exceeded allowed balance
115: FND_MESSAGE.SET_NAME('ONT','OE_COM_ZERO_BALANCE');
116: FND_MESSAGE.SET_TOKEN('COMMITMENT' , l_trx_number);
117: OE_MSG_PUB.ADD;
118: IF l_debug_level > 0 THEN
119: oe_debug_pub.add( ' COMMITMENT HAVE OVERDRAWN MORE THAN ONCE' ) ;
120: oe_debug_pub.add( ' EXPECTED ERROR IN EVALUATE_COMMITMENT' , 1 ) ;
123: -- move code to calculate_commitment
124: elsif l_total_balance <= 0 then
125: --not to raise error if balance - current line amount exceed
126: --balance, allowing to use up last available balance
127: FND_MESSAGE.Set_Name('ONT','OE_COM_BALANCE_WARNING');
128: FND_MESSAGE.Set_Token('COMMITMENT',l_trx_number);
129: FND_Message.Set_Token('BALANCE',TO_CHAR(l_total_balance * -1, g_fmt_mask));
130: OE_MSG_PUB.ADD;
131: IF l_debug_level > 0 THEN
124: elsif l_total_balance <= 0 then
125: --not to raise error if balance - current line amount exceed
126: --balance, allowing to use up last available balance
127: FND_MESSAGE.Set_Name('ONT','OE_COM_BALANCE_WARNING');
128: FND_MESSAGE.Set_Token('COMMITMENT',l_trx_number);
129: FND_Message.Set_Token('BALANCE',TO_CHAR(l_total_balance * -1, g_fmt_mask));
130: OE_MSG_PUB.ADD;
131: IF l_debug_level > 0 THEN
132: oe_debug_pub.add( ' ISSUE A WARNING ABOUT COMMITMENT HAS BEEN OVERDRAWN' ) ;
125: --not to raise error if balance - current line amount exceed
126: --balance, allowing to use up last available balance
127: FND_MESSAGE.Set_Name('ONT','OE_COM_BALANCE_WARNING');
128: FND_MESSAGE.Set_Token('COMMITMENT',l_trx_number);
129: FND_Message.Set_Token('BALANCE',TO_CHAR(l_total_balance * -1, g_fmt_mask));
130: OE_MSG_PUB.ADD;
131: IF l_debug_level > 0 THEN
132: oe_debug_pub.add( ' ISSUE A WARNING ABOUT COMMITMENT HAS BEEN OVERDRAWN' ) ;
133: END IF;
132: oe_debug_pub.add( ' ISSUE A WARNING ABOUT COMMITMENT HAS BEEN OVERDRAWN' ) ;
133: END IF;
134: -- show the message after saving the commitment
135: else
136: FND_MESSAGE.Set_Name('ONT','OE_COM_BALANCE');
137: FND_MESSAGE.Set_Token('COMMITMENT',l_trx_number);
138: -- FND_Message.Set_Token('BALANCE',l_total_balance);
139: FND_Message.Set_Token('BALANCE',l_converted_total_balance);
140: OE_MSG_PUB.ADD;
133: END IF;
134: -- show the message after saving the commitment
135: else
136: FND_MESSAGE.Set_Name('ONT','OE_COM_BALANCE');
137: FND_MESSAGE.Set_Token('COMMITMENT',l_trx_number);
138: -- FND_Message.Set_Token('BALANCE',l_total_balance);
139: FND_Message.Set_Token('BALANCE',l_converted_total_balance);
140: OE_MSG_PUB.ADD;
141:
134: -- show the message after saving the commitment
135: else
136: FND_MESSAGE.Set_Name('ONT','OE_COM_BALANCE');
137: FND_MESSAGE.Set_Token('COMMITMENT',l_trx_number);
138: -- FND_Message.Set_Token('BALANCE',l_total_balance);
139: FND_Message.Set_Token('BALANCE',l_converted_total_balance);
140: OE_MSG_PUB.ADD;
141:
142: end if;
135: else
136: FND_MESSAGE.Set_Name('ONT','OE_COM_BALANCE');
137: FND_MESSAGE.Set_Token('COMMITMENT',l_trx_number);
138: -- FND_Message.Set_Token('BALANCE',l_total_balance);
139: FND_Message.Set_Token('BALANCE',l_converted_total_balance);
140: OE_MSG_PUB.ADD;
141:
142: end if;
143:
667: IF l_debug_level > 0 THEN
668: oe_debug_pub.add( 'NEW COMMITMENT BALANCE IS: '||L_NEW_COMMITMENT_BAL ) ;
669: END IF;
670:
671: FND_MESSAGE.Set_Name('ONT','OE_COM_BALANCE');
672: FND_MESSAGE.Set_Token('COMMITMENT',l_commitment);
673: FND_Message.Set_Token('BALANCE',to_char(l_new_commitment_bal, g_fmt_mask));
674: OE_MSG_PUB.ADD;
675:
668: oe_debug_pub.add( 'NEW COMMITMENT BALANCE IS: '||L_NEW_COMMITMENT_BAL ) ;
669: END IF;
670:
671: FND_MESSAGE.Set_Name('ONT','OE_COM_BALANCE');
672: FND_MESSAGE.Set_Token('COMMITMENT',l_commitment);
673: FND_Message.Set_Token('BALANCE',to_char(l_new_commitment_bal, g_fmt_mask));
674: OE_MSG_PUB.ADD;
675:
676: -- to display message if the current line overdraws
669: END IF;
670:
671: FND_MESSAGE.Set_Name('ONT','OE_COM_BALANCE');
672: FND_MESSAGE.Set_Token('COMMITMENT',l_commitment);
673: FND_Message.Set_Token('BALANCE',to_char(l_new_commitment_bal, g_fmt_mask));
674: OE_MSG_PUB.ADD;
675:
676: -- to display message if the current line overdraws
677: IF l_total > l_commitment_bal and nvl(l_overdrawn_amount, 0) <> 0 THEN
674: OE_MSG_PUB.ADD;
675:
676: -- to display message if the current line overdraws
677: IF l_total > l_commitment_bal and nvl(l_overdrawn_amount, 0) <> 0 THEN
678: FND_MESSAGE.Set_Name('ONT','OE_COM_BALANCE_WARNING');
679: FND_MESSAGE.Set_Token('COMMITMENT',l_commitment);
680: FND_Message.Set_Token('BALANCE',TO_CHAR(l_overdrawn_amount, g_fmt_mask));
681: OE_MSG_PUB.ADD;
682: END IF;
675:
676: -- to display message if the current line overdraws
677: IF l_total > l_commitment_bal and nvl(l_overdrawn_amount, 0) <> 0 THEN
678: FND_MESSAGE.Set_Name('ONT','OE_COM_BALANCE_WARNING');
679: FND_MESSAGE.Set_Token('COMMITMENT',l_commitment);
680: FND_Message.Set_Token('BALANCE',TO_CHAR(l_overdrawn_amount, g_fmt_mask));
681: OE_MSG_PUB.ADD;
682: END IF;
683: l_show_balance := FALSE;
676: -- to display message if the current line overdraws
677: IF l_total > l_commitment_bal and nvl(l_overdrawn_amount, 0) <> 0 THEN
678: FND_MESSAGE.Set_Name('ONT','OE_COM_BALANCE_WARNING');
679: FND_MESSAGE.Set_Token('COMMITMENT',l_commitment);
680: FND_Message.Set_Token('BALANCE',TO_CHAR(l_overdrawn_amount, g_fmt_mask));
681: OE_MSG_PUB.ADD;
682: END IF;
683: l_show_balance := FALSE;
684: END IF;
1125: l_min_acct_unit, TRUE
1126: );
1127: END IF;
1128:
1129: FND_MESSAGE.Set_Name('ONT','OE_COM_BALANCE');
1130: FND_MESSAGE.Set_Token('COMMITMENT',l_commitment);
1131: FND_Message.Set_Token('BALANCE',to_char(l_new_commitment_bal, g_fmt_mask));
1132: OE_MSG_PUB.ADD;
1133: --bug 3560198
1126: );
1127: END IF;
1128:
1129: FND_MESSAGE.Set_Name('ONT','OE_COM_BALANCE');
1130: FND_MESSAGE.Set_Token('COMMITMENT',l_commitment);
1131: FND_Message.Set_Token('BALANCE',to_char(l_new_commitment_bal, g_fmt_mask));
1132: OE_MSG_PUB.ADD;
1133: --bug 3560198
1134:
1127: END IF;
1128:
1129: FND_MESSAGE.Set_Name('ONT','OE_COM_BALANCE');
1130: FND_MESSAGE.Set_Token('COMMITMENT',l_commitment);
1131: FND_Message.Set_Token('BALANCE',to_char(l_new_commitment_bal, g_fmt_mask));
1132: OE_MSG_PUB.ADD;
1133: --bug 3560198
1134:
1135: