67: IS
68: BEGIN
69:
70: IF p_message_name = 'OZF_CLAM_NOTES_STATUS_CHANGE' THEN
71: fnd_message.set_name('OZF', 'OZF_CLAM_NOTES_STATUS_CHANGE');
72: fnd_message.set_token('STATUS_CODE', p_token_1);
73: fnd_message.set_token('NEW_STATUS_CODE', p_token_2);
74: END IF;
75:
68: BEGIN
69:
70: IF p_message_name = 'OZF_CLAM_NOTES_STATUS_CHANGE' THEN
71: fnd_message.set_name('OZF', 'OZF_CLAM_NOTES_STATUS_CHANGE');
72: fnd_message.set_token('STATUS_CODE', p_token_1);
73: fnd_message.set_token('NEW_STATUS_CODE', p_token_2);
74: END IF;
75:
76: IF p_message_name = 'OZF_CLAM_NOTES_STATUS_SAME' THEN
69:
70: IF p_message_name = 'OZF_CLAM_NOTES_STATUS_CHANGE' THEN
71: fnd_message.set_name('OZF', 'OZF_CLAM_NOTES_STATUS_CHANGE');
72: fnd_message.set_token('STATUS_CODE', p_token_1);
73: fnd_message.set_token('NEW_STATUS_CODE', p_token_2);
74: END IF;
75:
76: IF p_message_name = 'OZF_CLAM_NOTES_STATUS_SAME' THEN
77: fnd_message.set_name('OZF', 'OZF_CLAM_NOTES_STATUS_SAME');
73: fnd_message.set_token('NEW_STATUS_CODE', p_token_2);
74: END IF;
75:
76: IF p_message_name = 'OZF_CLAM_NOTES_STATUS_SAME' THEN
77: fnd_message.set_name('OZF', 'OZF_CLAM_NOTES_STATUS_SAME');
78: fnd_message.set_token('STATUS_CODE', p_token_1);
79: END IF;
80:
81: IF p_message_name = 'OZF_CLAM_NOTES_RCPT_CHANGE' THEN
74: END IF;
75:
76: IF p_message_name = 'OZF_CLAM_NOTES_STATUS_SAME' THEN
77: fnd_message.set_name('OZF', 'OZF_CLAM_NOTES_STATUS_SAME');
78: fnd_message.set_token('STATUS_CODE', p_token_1);
79: END IF;
80:
81: IF p_message_name = 'OZF_CLAM_NOTES_RCPT_CHANGE' THEN
82: fnd_message.set_name('OZF', 'OZF_CLAM_NOTES_RCPT_CHANGE');
78: fnd_message.set_token('STATUS_CODE', p_token_1);
79: END IF;
80:
81: IF p_message_name = 'OZF_CLAM_NOTES_RCPT_CHANGE' THEN
82: fnd_message.set_name('OZF', 'OZF_CLAM_NOTES_RCPT_CHANGE');
83: fnd_message.set_token('RECEIPT_NUMBER', p_token_1);
84: fnd_message.set_token('NEW_RECEIPT_NUMBER', p_token_2);
85: END IF;
86:
79: END IF;
80:
81: IF p_message_name = 'OZF_CLAM_NOTES_RCPT_CHANGE' THEN
82: fnd_message.set_name('OZF', 'OZF_CLAM_NOTES_RCPT_CHANGE');
83: fnd_message.set_token('RECEIPT_NUMBER', p_token_1);
84: fnd_message.set_token('NEW_RECEIPT_NUMBER', p_token_2);
85: END IF;
86:
87: IF p_message_name = 'OZF_CLAM_NOTES_RCPT_SAME' THEN
80:
81: IF p_message_name = 'OZF_CLAM_NOTES_RCPT_CHANGE' THEN
82: fnd_message.set_name('OZF', 'OZF_CLAM_NOTES_RCPT_CHANGE');
83: fnd_message.set_token('RECEIPT_NUMBER', p_token_1);
84: fnd_message.set_token('NEW_RECEIPT_NUMBER', p_token_2);
85: END IF;
86:
87: IF p_message_name = 'OZF_CLAM_NOTES_RCPT_SAME' THEN
88: fnd_message.set_name('OZF', 'OZF_CLAM_NOTES_RCPT_SAME');
84: fnd_message.set_token('NEW_RECEIPT_NUMBER', p_token_2);
85: END IF;
86:
87: IF p_message_name = 'OZF_CLAM_NOTES_RCPT_SAME' THEN
88: fnd_message.set_name('OZF', 'OZF_CLAM_NOTES_RCPT_SAME');
89: fnd_message.set_token('RECEIPT_NUMBER', p_token_1);
90: END IF;
91:
92: IF p_message_name = 'OZF_CLAM_NOTES_APPLY_CHANGE' THEN
85: END IF;
86:
87: IF p_message_name = 'OZF_CLAM_NOTES_RCPT_SAME' THEN
88: fnd_message.set_name('OZF', 'OZF_CLAM_NOTES_RCPT_SAME');
89: fnd_message.set_token('RECEIPT_NUMBER', p_token_1);
90: END IF;
91:
92: IF p_message_name = 'OZF_CLAM_NOTES_APPLY_CHANGE' THEN
93: fnd_message.set_name('OZF', 'OZF_CLAM_NOTES_APPLY_CHANGE');
89: fnd_message.set_token('RECEIPT_NUMBER', p_token_1);
90: END IF;
91:
92: IF p_message_name = 'OZF_CLAM_NOTES_APPLY_CHANGE' THEN
93: fnd_message.set_name('OZF', 'OZF_CLAM_NOTES_APPLY_CHANGE');
94: fnd_message.set_token('OLD_AMOUNT', p_token_1);
95: fnd_message.set_token('NEW_AMOUNT', p_token_2);
96: fnd_message.set_token('AMOUNT_APPLIED_L', p_token_3);
97: fnd_message.set_token('AMOUNT_APPLIED', p_token_4);
90: END IF;
91:
92: IF p_message_name = 'OZF_CLAM_NOTES_APPLY_CHANGE' THEN
93: fnd_message.set_name('OZF', 'OZF_CLAM_NOTES_APPLY_CHANGE');
94: fnd_message.set_token('OLD_AMOUNT', p_token_1);
95: fnd_message.set_token('NEW_AMOUNT', p_token_2);
96: fnd_message.set_token('AMOUNT_APPLIED_L', p_token_3);
97: fnd_message.set_token('AMOUNT_APPLIED', p_token_4);
98: fnd_message.set_token('RECEIPT_NUMBER', p_token_5);
91:
92: IF p_message_name = 'OZF_CLAM_NOTES_APPLY_CHANGE' THEN
93: fnd_message.set_name('OZF', 'OZF_CLAM_NOTES_APPLY_CHANGE');
94: fnd_message.set_token('OLD_AMOUNT', p_token_1);
95: fnd_message.set_token('NEW_AMOUNT', p_token_2);
96: fnd_message.set_token('AMOUNT_APPLIED_L', p_token_3);
97: fnd_message.set_token('AMOUNT_APPLIED', p_token_4);
98: fnd_message.set_token('RECEIPT_NUMBER', p_token_5);
99: END IF;
92: IF p_message_name = 'OZF_CLAM_NOTES_APPLY_CHANGE' THEN
93: fnd_message.set_name('OZF', 'OZF_CLAM_NOTES_APPLY_CHANGE');
94: fnd_message.set_token('OLD_AMOUNT', p_token_1);
95: fnd_message.set_token('NEW_AMOUNT', p_token_2);
96: fnd_message.set_token('AMOUNT_APPLIED_L', p_token_3);
97: fnd_message.set_token('AMOUNT_APPLIED', p_token_4);
98: fnd_message.set_token('RECEIPT_NUMBER', p_token_5);
99: END IF;
100:
93: fnd_message.set_name('OZF', 'OZF_CLAM_NOTES_APPLY_CHANGE');
94: fnd_message.set_token('OLD_AMOUNT', p_token_1);
95: fnd_message.set_token('NEW_AMOUNT', p_token_2);
96: fnd_message.set_token('AMOUNT_APPLIED_L', p_token_3);
97: fnd_message.set_token('AMOUNT_APPLIED', p_token_4);
98: fnd_message.set_token('RECEIPT_NUMBER', p_token_5);
99: END IF;
100:
101: IF p_message_name = 'OZF_CLAM_NOTES_UNAPPLY_CHANGE' THEN
94: fnd_message.set_token('OLD_AMOUNT', p_token_1);
95: fnd_message.set_token('NEW_AMOUNT', p_token_2);
96: fnd_message.set_token('AMOUNT_APPLIED_L', p_token_3);
97: fnd_message.set_token('AMOUNT_APPLIED', p_token_4);
98: fnd_message.set_token('RECEIPT_NUMBER', p_token_5);
99: END IF;
100:
101: IF p_message_name = 'OZF_CLAM_NOTES_UNAPPLY_CHANGE' THEN
102: fnd_message.set_name('OZF', 'OZF_CLAM_NOTES_UNAPPLY_CHANGE');
98: fnd_message.set_token('RECEIPT_NUMBER', p_token_5);
99: END IF;
100:
101: IF p_message_name = 'OZF_CLAM_NOTES_UNAPPLY_CHANGE' THEN
102: fnd_message.set_name('OZF', 'OZF_CLAM_NOTES_UNAPPLY_CHANGE');
103: fnd_message.set_token('OLD_AMOUNT', p_token_1);
104: fnd_message.set_token('NEW_AMOUNT', p_token_2);
105: fnd_message.set_token('AMOUNT_APPLIED', p_token_3);
106: fnd_message.set_token('RECEIPT_NUMBER', p_token_4);
99: END IF;
100:
101: IF p_message_name = 'OZF_CLAM_NOTES_UNAPPLY_CHANGE' THEN
102: fnd_message.set_name('OZF', 'OZF_CLAM_NOTES_UNAPPLY_CHANGE');
103: fnd_message.set_token('OLD_AMOUNT', p_token_1);
104: fnd_message.set_token('NEW_AMOUNT', p_token_2);
105: fnd_message.set_token('AMOUNT_APPLIED', p_token_3);
106: fnd_message.set_token('RECEIPT_NUMBER', p_token_4);
107: END IF;
100:
101: IF p_message_name = 'OZF_CLAM_NOTES_UNAPPLY_CHANGE' THEN
102: fnd_message.set_name('OZF', 'OZF_CLAM_NOTES_UNAPPLY_CHANGE');
103: fnd_message.set_token('OLD_AMOUNT', p_token_1);
104: fnd_message.set_token('NEW_AMOUNT', p_token_2);
105: fnd_message.set_token('AMOUNT_APPLIED', p_token_3);
106: fnd_message.set_token('RECEIPT_NUMBER', p_token_4);
107: END IF;
108:
101: IF p_message_name = 'OZF_CLAM_NOTES_UNAPPLY_CHANGE' THEN
102: fnd_message.set_name('OZF', 'OZF_CLAM_NOTES_UNAPPLY_CHANGE');
103: fnd_message.set_token('OLD_AMOUNT', p_token_1);
104: fnd_message.set_token('NEW_AMOUNT', p_token_2);
105: fnd_message.set_token('AMOUNT_APPLIED', p_token_3);
106: fnd_message.set_token('RECEIPT_NUMBER', p_token_4);
107: END IF;
108:
109: IF p_message_name = 'OZF_CLAM_NOTES_AR_BAL_ZERO' THEN
102: fnd_message.set_name('OZF', 'OZF_CLAM_NOTES_UNAPPLY_CHANGE');
103: fnd_message.set_token('OLD_AMOUNT', p_token_1);
104: fnd_message.set_token('NEW_AMOUNT', p_token_2);
105: fnd_message.set_token('AMOUNT_APPLIED', p_token_3);
106: fnd_message.set_token('RECEIPT_NUMBER', p_token_4);
107: END IF;
108:
109: IF p_message_name = 'OZF_CLAM_NOTES_AR_BAL_ZERO' THEN
110: fnd_message.set_name('OZF', 'OZF_CLAM_NOTES_AR_BAL_ZERO');
106: fnd_message.set_token('RECEIPT_NUMBER', p_token_4);
107: END IF;
108:
109: IF p_message_name = 'OZF_CLAM_NOTES_AR_BAL_ZERO' THEN
110: fnd_message.set_name('OZF', 'OZF_CLAM_NOTES_AR_BAL_ZERO');
111: END IF;
112:
113: IF p_message_name = 'OZF_CLAM_NOTES_RCPTS_UNAPPLIED' THEN
114: fnd_message.set_name('OZF', 'OZF_CLAM_NOTES_RCPTS_UNAPPLIED');
110: fnd_message.set_name('OZF', 'OZF_CLAM_NOTES_AR_BAL_ZERO');
111: END IF;
112:
113: IF p_message_name = 'OZF_CLAM_NOTES_RCPTS_UNAPPLIED' THEN
114: fnd_message.set_name('OZF', 'OZF_CLAM_NOTES_RCPTS_UNAPPLIED');
115: END IF;
116:
117: IF p_message_name = 'OZF_CLAM_NOTES_NO_SUBS_APPLY' THEN
118: fnd_message.set_name('OZF', 'OZF_CLAM_NOTES_NO_SUBS_APPLY');
114: fnd_message.set_name('OZF', 'OZF_CLAM_NOTES_RCPTS_UNAPPLIED');
115: END IF;
116:
117: IF p_message_name = 'OZF_CLAM_NOTES_NO_SUBS_APPLY' THEN
118: fnd_message.set_name('OZF', 'OZF_CLAM_NOTES_NO_SUBS_APPLY');
119: fnd_message.set_token('RECEIPT_NUMBER', p_token_1);
120: END IF;
121:
122: IF p_message_name = 'OZF_CLAM_NOTES_NO_SUBS_UNAPPLY' THEN
115: END IF;
116:
117: IF p_message_name = 'OZF_CLAM_NOTES_NO_SUBS_APPLY' THEN
118: fnd_message.set_name('OZF', 'OZF_CLAM_NOTES_NO_SUBS_APPLY');
119: fnd_message.set_token('RECEIPT_NUMBER', p_token_1);
120: END IF;
121:
122: IF p_message_name = 'OZF_CLAM_NOTES_NO_SUBS_UNAPPLY' THEN
123: fnd_message.set_name('OZF', 'OZF_CLAM_NOTES_NO_SUBS_UNAPPLY');
119: fnd_message.set_token('RECEIPT_NUMBER', p_token_1);
120: END IF;
121:
122: IF p_message_name = 'OZF_CLAM_NOTES_NO_SUBS_UNAPPLY' THEN
123: fnd_message.set_name('OZF', 'OZF_CLAM_NOTES_NO_SUBS_UNAPPLY');
124: fnd_message.set_token('RECEIPT_NUMBER', p_token_1);
125: END IF;
126:
127: IF p_message_name = 'OZF_CLAM_NOTES_CLAIM_PENDING' THEN
120: END IF;
121:
122: IF p_message_name = 'OZF_CLAM_NOTES_NO_SUBS_UNAPPLY' THEN
123: fnd_message.set_name('OZF', 'OZF_CLAM_NOTES_NO_SUBS_UNAPPLY');
124: fnd_message.set_token('RECEIPT_NUMBER', p_token_1);
125: END IF;
126:
127: IF p_message_name = 'OZF_CLAM_NOTES_CLAIM_PENDING' THEN
128: fnd_message.set_name('OZF', 'OZF_CLAM_NOTES_CLAIM_PENDING');
124: fnd_message.set_token('RECEIPT_NUMBER', p_token_1);
125: END IF;
126:
127: IF p_message_name = 'OZF_CLAM_NOTES_CLAIM_PENDING' THEN
128: fnd_message.set_name('OZF', 'OZF_CLAM_NOTES_CLAIM_PENDING');
129: END IF;
130:
131: IF p_message_name = 'OZF_CLAM_NOTES_CLAIM_CLOSED' THEN
132: fnd_message.set_name('OZF', 'OZF_CLAM_NOTES_CLAIM_CLOSED');
128: fnd_message.set_name('OZF', 'OZF_CLAM_NOTES_CLAIM_PENDING');
129: END IF;
130:
131: IF p_message_name = 'OZF_CLAM_NOTES_CLAIM_CLOSED' THEN
132: fnd_message.set_name('OZF', 'OZF_CLAM_NOTES_CLAIM_CLOSED');
133: END IF;
134:
135: IF p_message_name = 'OZF_CLAIM_NOTES_AMOUNT_UNAPPLY' THEN
136: fnd_message.set_name('OZF', 'OZF_CLAIM_NOTES_AMOUNT_UNAPPLY');
132: fnd_message.set_name('OZF', 'OZF_CLAM_NOTES_CLAIM_CLOSED');
133: END IF;
134:
135: IF p_message_name = 'OZF_CLAIM_NOTES_AMOUNT_UNAPPLY' THEN
136: fnd_message.set_name('OZF', 'OZF_CLAIM_NOTES_AMOUNT_UNAPPLY');
137: fnd_message.set_token('RECEIPT_NUMBER', p_token_1);
138: END IF;
139:
140:
133: END IF;
134:
135: IF p_message_name = 'OZF_CLAIM_NOTES_AMOUNT_UNAPPLY' THEN
136: fnd_message.set_name('OZF', 'OZF_CLAIM_NOTES_AMOUNT_UNAPPLY');
137: fnd_message.set_token('RECEIPT_NUMBER', p_token_1);
138: END IF;
139:
140:
141: IF p_message_name = 'OZF_CLAIM_NOTES_AMOUNT_ADJUST' THEN
138: END IF;
139:
140:
141: IF p_message_name = 'OZF_CLAIM_NOTES_AMOUNT_ADJUST' THEN
142: fnd_message.set_name('OZF', 'OZF_CLAIM_NOTES_AMOUNT_ADJUST');
143: fnd_message.set_token('CLAIM_NUMBER', p_token_1);
144: fnd_message.set_token('STATUS_CODE', p_token_2);
145: fnd_message.set_token('NEW_CLAIM_NUMBER', p_token_3);
146: fnd_message.set_token('AMOUNT_APPLIED', p_token_4);
139:
140:
141: IF p_message_name = 'OZF_CLAIM_NOTES_AMOUNT_ADJUST' THEN
142: fnd_message.set_name('OZF', 'OZF_CLAIM_NOTES_AMOUNT_ADJUST');
143: fnd_message.set_token('CLAIM_NUMBER', p_token_1);
144: fnd_message.set_token('STATUS_CODE', p_token_2);
145: fnd_message.set_token('NEW_CLAIM_NUMBER', p_token_3);
146: fnd_message.set_token('AMOUNT_APPLIED', p_token_4);
147: fnd_message.set_token('AMOUNT', p_token_5);
140:
141: IF p_message_name = 'OZF_CLAIM_NOTES_AMOUNT_ADJUST' THEN
142: fnd_message.set_name('OZF', 'OZF_CLAIM_NOTES_AMOUNT_ADJUST');
143: fnd_message.set_token('CLAIM_NUMBER', p_token_1);
144: fnd_message.set_token('STATUS_CODE', p_token_2);
145: fnd_message.set_token('NEW_CLAIM_NUMBER', p_token_3);
146: fnd_message.set_token('AMOUNT_APPLIED', p_token_4);
147: fnd_message.set_token('AMOUNT', p_token_5);
148: fnd_message.set_token('NEW_AMOUNT', p_token_6);
141: IF p_message_name = 'OZF_CLAIM_NOTES_AMOUNT_ADJUST' THEN
142: fnd_message.set_name('OZF', 'OZF_CLAIM_NOTES_AMOUNT_ADJUST');
143: fnd_message.set_token('CLAIM_NUMBER', p_token_1);
144: fnd_message.set_token('STATUS_CODE', p_token_2);
145: fnd_message.set_token('NEW_CLAIM_NUMBER', p_token_3);
146: fnd_message.set_token('AMOUNT_APPLIED', p_token_4);
147: fnd_message.set_token('AMOUNT', p_token_5);
148: fnd_message.set_token('NEW_AMOUNT', p_token_6);
149: END IF;
142: fnd_message.set_name('OZF', 'OZF_CLAIM_NOTES_AMOUNT_ADJUST');
143: fnd_message.set_token('CLAIM_NUMBER', p_token_1);
144: fnd_message.set_token('STATUS_CODE', p_token_2);
145: fnd_message.set_token('NEW_CLAIM_NUMBER', p_token_3);
146: fnd_message.set_token('AMOUNT_APPLIED', p_token_4);
147: fnd_message.set_token('AMOUNT', p_token_5);
148: fnd_message.set_token('NEW_AMOUNT', p_token_6);
149: END IF;
150:
143: fnd_message.set_token('CLAIM_NUMBER', p_token_1);
144: fnd_message.set_token('STATUS_CODE', p_token_2);
145: fnd_message.set_token('NEW_CLAIM_NUMBER', p_token_3);
146: fnd_message.set_token('AMOUNT_APPLIED', p_token_4);
147: fnd_message.set_token('AMOUNT', p_token_5);
148: fnd_message.set_token('NEW_AMOUNT', p_token_6);
149: END IF;
150:
151: IF p_message_name = 'OZF_CLAIM_NOTES_AMOUNT_SPLIT' THEN
144: fnd_message.set_token('STATUS_CODE', p_token_2);
145: fnd_message.set_token('NEW_CLAIM_NUMBER', p_token_3);
146: fnd_message.set_token('AMOUNT_APPLIED', p_token_4);
147: fnd_message.set_token('AMOUNT', p_token_5);
148: fnd_message.set_token('NEW_AMOUNT', p_token_6);
149: END IF;
150:
151: IF p_message_name = 'OZF_CLAIM_NOTES_AMOUNT_SPLIT' THEN
152: fnd_message.set_name('OZF', 'OZF_CLAIM_NOTES_AMOUNT_SPLIT');
148: fnd_message.set_token('NEW_AMOUNT', p_token_6);
149: END IF;
150:
151: IF p_message_name = 'OZF_CLAIM_NOTES_AMOUNT_SPLIT' THEN
152: fnd_message.set_name('OZF', 'OZF_CLAIM_NOTES_AMOUNT_SPLIT');
153: fnd_message.set_token('OLD_AMOUNT', p_token_1);
154: fnd_message.set_token('NEW_AMOUNT', p_token_2);
155: fnd_message.set_token('SPLIT_AMOUNT', p_token_3);
156:
149: END IF;
150:
151: IF p_message_name = 'OZF_CLAIM_NOTES_AMOUNT_SPLIT' THEN
152: fnd_message.set_name('OZF', 'OZF_CLAIM_NOTES_AMOUNT_SPLIT');
153: fnd_message.set_token('OLD_AMOUNT', p_token_1);
154: fnd_message.set_token('NEW_AMOUNT', p_token_2);
155: fnd_message.set_token('SPLIT_AMOUNT', p_token_3);
156:
157: END IF;
150:
151: IF p_message_name = 'OZF_CLAIM_NOTES_AMOUNT_SPLIT' THEN
152: fnd_message.set_name('OZF', 'OZF_CLAIM_NOTES_AMOUNT_SPLIT');
153: fnd_message.set_token('OLD_AMOUNT', p_token_1);
154: fnd_message.set_token('NEW_AMOUNT', p_token_2);
155: fnd_message.set_token('SPLIT_AMOUNT', p_token_3);
156:
157: END IF;
158:
151: IF p_message_name = 'OZF_CLAIM_NOTES_AMOUNT_SPLIT' THEN
152: fnd_message.set_name('OZF', 'OZF_CLAIM_NOTES_AMOUNT_SPLIT');
153: fnd_message.set_token('OLD_AMOUNT', p_token_1);
154: fnd_message.set_token('NEW_AMOUNT', p_token_2);
155: fnd_message.set_token('SPLIT_AMOUNT', p_token_3);
156:
157: END IF;
158:
159: IF p_message_name = 'OZF_CLAM_NOTES_AFFECTED' THEN
156:
157: END IF;
158:
159: IF p_message_name = 'OZF_CLAM_NOTES_AFFECTED' THEN
160: fnd_message.set_name('OZF', 'OZF_CLAM_NOTES_AFFECTED');
161: fnd_message.set_token('CLAIM_NUMBER', p_token_1);
162: fnd_message.set_token('AMOUNT_APPLIED', p_token_2);
163: END IF;
164:
157: END IF;
158:
159: IF p_message_name = 'OZF_CLAM_NOTES_AFFECTED' THEN
160: fnd_message.set_name('OZF', 'OZF_CLAM_NOTES_AFFECTED');
161: fnd_message.set_token('CLAIM_NUMBER', p_token_1);
162: fnd_message.set_token('AMOUNT_APPLIED', p_token_2);
163: END IF;
164:
165: RETURN fnd_message.get;
158:
159: IF p_message_name = 'OZF_CLAM_NOTES_AFFECTED' THEN
160: fnd_message.set_name('OZF', 'OZF_CLAM_NOTES_AFFECTED');
161: fnd_message.set_token('CLAIM_NUMBER', p_token_1);
162: fnd_message.set_token('AMOUNT_APPLIED', p_token_2);
163: END IF;
164:
165: RETURN fnd_message.get;
166:
161: fnd_message.set_token('CLAIM_NUMBER', p_token_1);
162: fnd_message.set_token('AMOUNT_APPLIED', p_token_2);
163: END IF;
164:
165: RETURN fnd_message.get;
166:
167: END Build_Note;
168:
169: ---------------------------------------------------------------------
347:
348: WHEN OTHERS THEN
349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
350: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
351: FND_MESSAGE.set_name('AMS', 'AMS_CLAIM_UPD_DEDU_ERR');
352: FND_MSG_PUB.add;
353: END IF;
354: -- Standard call to get message count and if count=1, get the message
355: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
423: EXCEPTION
424: WHEN OTHERS THEN
425: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
426: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
427: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
428: FND_MSG_PUB.add;
429: END IF;
430: -- Standard call to get message count and if count=1, get the message
431: FND_MSG_PUB.Count_And_Get (
653: l_deduction_rec.receipt_id IS NULL OR
654: l_deduction_rec.currency_code IS NULL OR
655: l_deduction_rec.amount IS NULL THEN
656: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
657: FND_MESSAGE.Set_Name('OZF','OZF_REQUIRED_FIELDS_MISSING');
658: FND_MSG_PUB.Add;
659: END IF;
660: RAISE FND_API.g_exc_error;
661: ELSIF l_deduction_rec.source_object_id IS NOT NULL AND
661: ELSIF l_deduction_rec.source_object_id IS NOT NULL AND
662: l_deduction_rec.source_object_type_id IS NULL THEN
663: -- source_object_type_id is required for transaction-related deduction.
664: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
665: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_SRC_INFO_MISSING');
666: FND_MSG_PUB.add;
667: END IF;
668: RAISE FND_API.g_exc_error;
669: END IF;
874: END IF;
875:
876: -- Debug Message
877: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
878: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
879: FND_MESSAGE.Set_Token('TEXT',l_full_name||'End');
880: FND_MSG_PUB.Add;
881: END IF;
882:
875:
876: -- Debug Message
877: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
878: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
879: FND_MESSAGE.Set_Token('TEXT',l_full_name||'End');
880: FND_MSG_PUB.Add;
881: END IF;
882:
883: -- Standard call to get message count and if count is 1, get message info.
899: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
900: ROLLBACK TO CREATE_CLAIM_GRP;
901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
902: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
903: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
904: FND_MSG_PUB.add;
905: END IF;
906: FND_MSG_PUB.Count_And_Get (
907: p_encoded => FND_API.G_FALSE,
912: WHEN OTHERS THEN
913: ROLLBACK TO CREATE_CLAIM_GRP;
914: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
915: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
916: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
917: FND_MSG_PUB.add;
918: END IF;
919: FND_MSG_PUB.Count_And_Get (
920: p_encoded => FND_API.G_FALSE,
1153: WHEN FND_API.G_EXC_ERROR THEN
1154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1155: WHEN OTHERS THEN
1156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1157: FND_MESSAGE.set_name('OZF', 'OZF_API_DEBUG_MESSAGE');
1158: FND_MESSAGE.set_token('TEXT', l_full_name||'An error happened in '||l_full_name);
1159: FND_MSG_PUB.add;
1160:
1161: END Check_Update_Allowed;
1154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1155: WHEN OTHERS THEN
1156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1157: FND_MESSAGE.set_name('OZF', 'OZF_API_DEBUG_MESSAGE');
1158: FND_MESSAGE.set_token('TEXT', l_full_name||'An error happened in '||l_full_name);
1159: FND_MSG_PUB.add;
1160:
1161: END Check_Update_Allowed;
1162:
1337:
1338: IF l_status_code <> 'CLOSED' THEN
1339: IF l_status_code = 'PENDING_CLOSE' THEN
1340: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1341: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_STATUS_PENDING_CLOSE');
1342: FND_MSG_PUB.add;
1343: END IF;
1344: RAISE FND_API.G_EXC_ERROR;
1345: END IF;
1530:
1531: FOR ref_split_claim_csr in split_claim_csr(l_deduction_rec.claim_id) LOOP
1532: IF ref_split_claim_csr.status_code = 'PENDING_CLOSE' THEN
1533: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1534: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_STATUS_PENDING_CLOSE');
1535: FND_MSG_PUB.add;
1536: END IF;
1537: RAISE FND_API.G_EXC_ERROR;
1538: END IF;
1819:
1820: WHEN OTHERS THEN
1821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1822: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1823: FND_MESSAGE.set_name('AMS', 'AMS_CLAIM_UPD_DEDU_ERR');
1824: FND_MSG_PUB.add;
1825: END IF;
1826: -- Standard call to get message count and if count=1, get the message
1827: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
2061: END IF;
2062:
2063: IF l_status_code = 'PENDING_CLOSE' THEN
2064: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2065: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_STATUS_PENDING_CLOSE');
2066: FND_MSG_PUB.add;
2067: END IF;
2068: RAISE FND_API.G_EXC_ERROR;
2069: END IF;
2266:
2267: IF l_update_allowed_flag = 'N' THEN
2268:
2269: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2270: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_STATUS_PENDING_CLOSE');
2271: FND_MSG_PUB.add;
2272: END IF;
2273: RAISE FND_API.G_EXC_ERROR;
2274: END IF;
2510: );
2511: WHEN OTHERS THEN
2512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2513: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2514: FND_MESSAGE.set_name('AMS', 'AMS_CLAIM_UPD_DEDU_ERR');
2515: FND_MSG_PUB.add;
2516: END IF;
2517: -- Standard call to get message count and if count=1, get the message
2518: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
2588: EXCEPTION
2589: WHEN OTHERS THEN
2590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2591: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2592: FND_MESSAGE.set_name('AMS', 'AMS_CLAIM_UPD_DEDU_ERR');
2593: FND_MSG_PUB.add;
2594: END IF;
2595: FND_MSG_PUB.Count_And_Get (
2596: p_encoded => FND_API.G_FALSE,
2791: -- "claim_id" or "source_object_id" is required field for updat_deduction
2792: IF l_deduction_rec.claim_id IS NULL AND
2793: l_deduction_rec.source_object_id IS NULL THEN
2794: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2795: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_INSUFFICIENT_VAL');
2796: FND_MSG_PUB.add;
2797: END IF;
2798: RAISE FND_API.G_EXC_ERROR;
2799: END IF;
2800:
2801: IF l_deduction_rec.applied_action_type IS NULL OR
2802: l_deduction_rec.applied_action_type NOT IN ('A','U') THEN
2803: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2804: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_INVALID_ACTION');
2805: FND_MSG_PUB.add;
2806: END IF;
2807: RAISE FND_API.G_EXC_ERROR;
2808: ELSE
2809: IF l_deduction_rec.applied_action_type = 'A' THEN
2810: IF l_deduction_rec.amount IS NULL OR
2811: l_deduction_rec.receipt_id IS NULL THEN
2812: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2813: FND_MESSAGE.set_name('AMS', 'AMS_CLAIM_INSUFFICIENT_VAL_A');
2814: FND_MSG_PUB.add;
2815: END IF;
2816: RAISE FND_API.G_EXC_ERROR;
2817: END IF;
2819: IF l_deduction_rec.amount IS NULL OR
2820: l_deduction_rec.amount_applied IS NULL OR
2821: l_deduction_rec.applied_receipt_id IS NULL THEN
2822: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2823: FND_MESSAGE.set_name('AMS', 'AMS_CLAIM_INSUFFICIENT_VAL_U');
2824: FND_MSG_PUB.add;
2825: END IF;
2826: RAISE FND_API.G_EXC_ERROR;
2827: END IF;
2884: (l_deduction_rec.amount IS NULL OR
2885: l_deduction_rec.amount = FND_API.G_MISS_NUM
2886: ) THEN
2887: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2888: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_INSUF_VAL_UPD');
2889: FND_MSG_PUB.add;
2890: END IF;
2891: RAISE FND_API.G_EXC_ERROR;
2892: ELSE
2897: (l_deduction_rec.applied_receipt_id IS NULL OR
2898: l_deduction_rec.applied_receipt_id = FND_API.G_MISS_NUM
2899: ) THEN
2900: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2901: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_INSUF_VAL_UPD');
2902: FND_MSG_PUB.add;
2903: END IF;
2904: RAISE FND_API.G_EXC_ERROR;
2905: END IF;
2910: (l_deduction_rec.applied_receipt_id IS NULL OR
2911: l_deduction_rec.applied_receipt_id = FND_API.G_MISS_NUM
2912: ) THEN
2913: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2914: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_INSUF_VAL_UPD');
2915: FND_MSG_PUB.add;
2916: END IF;
2917: RAISE FND_API.G_EXC_ERROR;
2918: END IF;
2917: RAISE FND_API.G_EXC_ERROR;
2918: END IF;
2919: ELSE
2920: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2921: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_INVALID_ACTION_UPD');
2922: FND_MSG_PUB.add;
2923: END IF;
2924: RAISE FND_API.G_EXC_ERROR;
2925: END IF;
3070: WHEN OTHERS THEN
3071: ROLLBACK TO UPDATE_claim_GRP;
3072: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3073: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3074: FND_MESSAGE.set_name('AMS', 'AMS_CLAIM_UPD_DEDU_ERR');
3075: FND_MSG_PUB.add;
3076: END IF;
3077: FND_MSG_PUB.Count_And_Get (
3078: p_encoded => FND_API.G_FALSE,
3287: IF csr_get_claim_dtls%ISOPEN THEN
3288: CLOSE csr_get_claim_dtls;
3289: END IF;
3290: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3291: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
3292: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
3293: FND_MSG_PUB.Add;
3294: END IF;
3295: x_application_ref_num := NULL;
3288: CLOSE csr_get_claim_dtls;
3289: END IF;
3290: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3291: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
3292: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
3293: FND_MSG_PUB.Add;
3294: END IF;
3295: x_application_ref_num := NULL;
3296: x_secondary_appl_ref_id := NULL;