DBA Data[Home] [Help]

APPS.OE_COMMITMENT_PVT dependencies on FND_MESSAGE

Line 115: FND_MESSAGE.SET_NAME('ONT','OE_COM_ZERO_BALANCE');

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' ) ;

Line 116: FND_MESSAGE.SET_TOKEN('COMMITMENT' , l_trx_number);

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 ) ;

Line 127: FND_MESSAGE.Set_Name('ONT','OE_COM_BALANCE_WARNING');

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

Line 128: FND_MESSAGE.Set_Token('COMMITMENT',l_trx_number);

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' ) ;

Line 129: FND_Message.Set_Token('BALANCE',TO_CHAR(l_total_balance * -1, g_fmt_mask));

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;

Line 136: FND_MESSAGE.Set_Name('ONT','OE_COM_BALANCE');

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;

Line 137: FND_MESSAGE.Set_Token('COMMITMENT',l_trx_number);

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:

Line 138: -- FND_Message.Set_Token('BALANCE',l_total_balance);

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;

Line 139: FND_Message.Set_Token('BALANCE',l_converted_total_balance);

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:

Line 671: FND_MESSAGE.Set_Name('ONT','OE_COM_BALANCE');

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:

Line 672: FND_MESSAGE.Set_Token('COMMITMENT',l_commitment);

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

Line 673: FND_Message.Set_Token('BALANCE',to_char(l_new_commitment_bal, g_fmt_mask));

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

Line 678: FND_MESSAGE.Set_Name('ONT','OE_COM_BALANCE_WARNING');

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;

Line 679: FND_MESSAGE.Set_Token('COMMITMENT',l_commitment);

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;

Line 680: FND_Message.Set_Token('BALANCE',TO_CHAR(l_overdrawn_amount, g_fmt_mask));

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;

Line 1129: FND_MESSAGE.Set_Name('ONT','OE_COM_BALANCE');

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

Line 1130: FND_MESSAGE.Set_Token('COMMITMENT',l_commitment);

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:

Line 1131: FND_Message.Set_Token('BALANCE',to_char(l_new_commitment_bal, g_fmt_mask));

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: