DBA Data[Home] [Help]

APPS.AR_INTEREST_BATCHES_PKG dependencies on FND_MESSAGE

Line 67: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');

63: IF (C%NOTFOUND) THEN
64: CLOSE C;
65: l_continue := 'N';
66: x_return_status := fnd_api.g_ret_sts_error;
67: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
68: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
69: p_count => x_msg_count,
70: p_data => x_msg_data);
71: END IF;

Line 86: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');

82: THEN
83: RETURN;
84: ELSE
85: x_return_status := fnd_api.g_ret_sts_error;
86: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
87: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
88: p_count => x_msg_count,
89: p_data => x_msg_data);
90: END IF;

Line 116: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

112: IF p_action = 'UPDATE' THEN
113:
114: IF p_old_batch_rec.batch_status IS NULL OR p_new_batch_rec.batch_status IS NULL
115: THEN
116: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
117: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'BATCH_STATUS' );
118: FND_MSG_PUB.ADD;
119: x_return_status := FND_API.G_RET_STS_ERROR;
120: END IF;

Line 117: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'BATCH_STATUS' );

113:
114: IF p_old_batch_rec.batch_status IS NULL OR p_new_batch_rec.batch_status IS NULL
115: THEN
116: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
117: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'BATCH_STATUS' );
118: FND_MSG_PUB.ADD;
119: x_return_status := FND_API.G_RET_STS_ERROR;
120: END IF;
121:

Line 124: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

120: END IF;
121:
122: IF p_old_batch_rec.transferred_status IS NULL OR p_new_batch_rec.transferred_status IS NULL
123: THEN
124: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
125: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'TRANSFERRED_STATUS' );
126: FND_MSG_PUB.ADD;
127: x_return_status := FND_API.G_RET_STS_ERROR;
128: END IF;

Line 125: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'TRANSFERRED_STATUS' );

121:
122: IF p_old_batch_rec.transferred_status IS NULL OR p_new_batch_rec.transferred_status IS NULL
123: THEN
124: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
125: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'TRANSFERRED_STATUS' );
126: FND_MSG_PUB.ADD;
127: x_return_status := FND_API.G_RET_STS_ERROR;
128: END IF;
129:

Line 134: FND_MESSAGE.SET_NAME( 'AR', 'AR_ONLY_VALUE_ALLOWED' );

130: IF p_new_batch_rec.batch_status NOT IN ('D','F') OR
131: p_old_batch_rec.batch_status NOT IN ('D','F')
132: THEN
133: arp_util.debug('Value value possible for batch_status is F or D');
134: FND_MESSAGE.SET_NAME( 'AR', 'AR_ONLY_VALUE_ALLOWED' );
135: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'BATCH_STATUS' );
136: FND_MESSAGE.SET_TOKEN( 'VALUES', g_draft||','||g_final);
137: FND_MSG_PUB.ADD;
138: x_return_status := FND_API.G_RET_STS_ERROR;

Line 135: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'BATCH_STATUS' );

131: p_old_batch_rec.batch_status NOT IN ('D','F')
132: THEN
133: arp_util.debug('Value value possible for batch_status is F or D');
134: FND_MESSAGE.SET_NAME( 'AR', 'AR_ONLY_VALUE_ALLOWED' );
135: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'BATCH_STATUS' );
136: FND_MESSAGE.SET_TOKEN( 'VALUES', g_draft||','||g_final);
137: FND_MSG_PUB.ADD;
138: x_return_status := FND_API.G_RET_STS_ERROR;
139: END IF;

Line 136: FND_MESSAGE.SET_TOKEN( 'VALUES', g_draft||','||g_final);

132: THEN
133: arp_util.debug('Value value possible for batch_status is F or D');
134: FND_MESSAGE.SET_NAME( 'AR', 'AR_ONLY_VALUE_ALLOWED' );
135: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'BATCH_STATUS' );
136: FND_MESSAGE.SET_TOKEN( 'VALUES', g_draft||','||g_final);
137: FND_MSG_PUB.ADD;
138: x_return_status := FND_API.G_RET_STS_ERROR;
139: END IF;
140:

Line 145: FND_MESSAGE.SET_NAME( 'AR', 'AR_ONLY_VALUE_ALLOWED' );

141: IF p_new_batch_rec.transferred_status NOT IN ('N','E','S','P') OR
142: p_old_batch_rec.transferred_status NOT IN ('N','E','S','P')
143: THEN
144: arp_util.debug('Value value possible for transferred_status are N, E , S , P');
145: FND_MESSAGE.SET_NAME( 'AR', 'AR_ONLY_VALUE_ALLOWED' );
146: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'TRANSFERRED_STATUS' );
147: FND_MESSAGE.SET_TOKEN( 'VALUES', g_not||','||g_error||','||g_success);
148: FND_MSG_PUB.ADD;
149: x_return_status := FND_API.G_RET_STS_ERROR;

Line 146: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'TRANSFERRED_STATUS' );

142: p_old_batch_rec.transferred_status NOT IN ('N','E','S','P')
143: THEN
144: arp_util.debug('Value value possible for transferred_status are N, E , S , P');
145: FND_MESSAGE.SET_NAME( 'AR', 'AR_ONLY_VALUE_ALLOWED' );
146: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'TRANSFERRED_STATUS' );
147: FND_MESSAGE.SET_TOKEN( 'VALUES', g_not||','||g_error||','||g_success);
148: FND_MSG_PUB.ADD;
149: x_return_status := FND_API.G_RET_STS_ERROR;
150: END IF;

Line 147: FND_MESSAGE.SET_TOKEN( 'VALUES', g_not||','||g_error||','||g_success);

143: THEN
144: arp_util.debug('Value value possible for transferred_status are N, E , S , P');
145: FND_MESSAGE.SET_NAME( 'AR', 'AR_ONLY_VALUE_ALLOWED' );
146: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'TRANSFERRED_STATUS' );
147: FND_MESSAGE.SET_TOKEN( 'VALUES', g_not||','||g_error||','||g_success);
148: FND_MSG_PUB.ADD;
149: x_return_status := FND_API.G_RET_STS_ERROR;
150: END IF;
151:

Line 156: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_COLUMN' );

152:
153: IF p_old_batch_rec.batch_status = 'F' AND p_new_batch_rec.batch_status <> 'F'
154: THEN
155: arp_util.debug('Can not update the batch status as it is F');
156: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_COLUMN' );
157: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'batch_status');
158: FND_MSG_PUB.ADD;
159: x_return_status := FND_API.G_RET_STS_ERROR;
160: END IF;

Line 157: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'batch_status');

153: IF p_old_batch_rec.batch_status = 'F' AND p_new_batch_rec.batch_status <> 'F'
154: THEN
155: arp_util.debug('Can not update the batch status as it is F');
156: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_COLUMN' );
157: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'batch_status');
158: FND_MSG_PUB.ADD;
159: x_return_status := FND_API.G_RET_STS_ERROR;
160: END IF;
161:

Line 168: fnd_message.set_name('AR', 'AR_STATUS_RESERVE_FOR_SRS');

164: IF p_new_batch_rec.transferred_status NOT IN ('N')
165: AND p_new_batch_rec.transferred_status <> p_old_batch_rec.transferred_status
166: THEN
167: x_return_status := fnd_api.g_ret_sts_error;
168: fnd_message.set_name('AR', 'AR_STATUS_RESERVE_FOR_SRS');
169: fnd_msg_pub.add;
170: END IF;
171: END IF;
172:

Line 176: FND_MESSAGE.SET_NAME( 'AR', 'AR_ONLY_VALUE_ALLOWED' );

172:
173:
174: IF p_new_batch_rec.batch_status = 'D' AND p_new_batch_rec.transferred_status <> 'N' THEN
175: arp_util.debug('Draft batch only accepts transferred status N');
176: FND_MESSAGE.SET_NAME( 'AR', 'AR_ONLY_VALUE_ALLOWED' );
177: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'TRANSFERRED_STATUS' );
178: FND_MESSAGE.SET_TOKEN( 'VALUES', g_not);
179: FND_MSG_PUB.ADD;
180: x_return_status := FND_API.G_RET_STS_ERROR;

Line 177: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'TRANSFERRED_STATUS' );

173:
174: IF p_new_batch_rec.batch_status = 'D' AND p_new_batch_rec.transferred_status <> 'N' THEN
175: arp_util.debug('Draft batch only accepts transferred status N');
176: FND_MESSAGE.SET_NAME( 'AR', 'AR_ONLY_VALUE_ALLOWED' );
177: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'TRANSFERRED_STATUS' );
178: FND_MESSAGE.SET_TOKEN( 'VALUES', g_not);
179: FND_MSG_PUB.ADD;
180: x_return_status := FND_API.G_RET_STS_ERROR;
181: END IF;

Line 178: FND_MESSAGE.SET_TOKEN( 'VALUES', g_not);

174: IF p_new_batch_rec.batch_status = 'D' AND p_new_batch_rec.transferred_status <> 'N' THEN
175: arp_util.debug('Draft batch only accepts transferred status N');
176: FND_MESSAGE.SET_NAME( 'AR', 'AR_ONLY_VALUE_ALLOWED' );
177: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'TRANSFERRED_STATUS' );
178: FND_MESSAGE.SET_TOKEN( 'VALUES', g_not);
179: FND_MSG_PUB.ADD;
180: x_return_status := FND_API.G_RET_STS_ERROR;
181: END IF;
182:

Line 186: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_COLUMN' );

182:
183:
184: IF p_old_batch_rec.transferred_status = 'S' AND p_new_batch_rec.transferred_status <> 'S' THEN
185: arp_util.debug('Can not update a successfull batch transferred status');
186: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_COLUMN' );
187: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'transferred_status' );
188: FND_MSG_PUB.ADD;
189: x_return_status := FND_API.G_RET_STS_ERROR;
190: END IF;

Line 187: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'transferred_status' );

183:
184: IF p_old_batch_rec.transferred_status = 'S' AND p_new_batch_rec.transferred_status <> 'S' THEN
185: arp_util.debug('Can not update a successfull batch transferred status');
186: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_COLUMN' );
187: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'transferred_status' );
188: FND_MSG_PUB.ADD;
189: x_return_status := FND_API.G_RET_STS_ERROR;
190: END IF;
191:

Line 198: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

194: END IF;
195:
196: IF p_new_batch_rec.gl_date = fnd_api.g_miss_date THEN
197: arp_util.debug('Gl Date can not be null');
198: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
199: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'gl_date' );
200: FND_MSG_PUB.ADD;
201: x_return_status := FND_API.G_RET_STS_ERROR;
202: END IF;

Line 199: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'gl_date' );

195:
196: IF p_new_batch_rec.gl_date = fnd_api.g_miss_date THEN
197: arp_util.debug('Gl Date can not be null');
198: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
199: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'gl_date' );
200: FND_MSG_PUB.ADD;
201: x_return_status := FND_API.G_RET_STS_ERROR;
202: END IF;
203:

Line 208: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_COLUMN' );

204: IF (p_new_batch_rec.gl_date <> fnd_api.g_miss_date) AND
205: (p_old_batch_rec.gl_date <> p_new_batch_rec.gl_date)
206: THEN
207: IF p_new_batch_rec.transferred_status <> 'N' THEN
208: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_COLUMN' );
209: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'GL_DATE' );
210: FND_MSG_PUB.ADD;
211: x_return_status := FND_API.G_RET_STS_ERROR;
212: END IF;

Line 209: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'GL_DATE' );

205: (p_old_batch_rec.gl_date <> p_new_batch_rec.gl_date)
206: THEN
207: IF p_new_batch_rec.transferred_status <> 'N' THEN
208: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_COLUMN' );
209: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'GL_DATE' );
210: FND_MSG_PUB.ADD;
211: x_return_status := FND_API.G_RET_STS_ERROR;
212: END IF;
213: END IF;

Line 222: FND_MESSAGE.SET_NAME( 'AR', 'AR_DRAFT_BATCH_DELETABLE' );

218: IF p_action = 'DELETE' THEN
219: IF p_old_batch_rec.batch_status <> 'D' THEN
220: arp_util.debug('Only Draft batches are delateable');
221: x_return_status := FND_API.G_RET_STS_ERROR;
222: FND_MESSAGE.SET_NAME( 'AR', 'AR_DRAFT_BATCH_DELETABLE' );
223: FND_MSG_PUB.ADD;
224: END IF;
225: END IF;
226:

Line 281: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');

277: l_rec.OBJECT_VERSION_NUMBER;
278: CLOSE c;
279:
280: IF l_rec.INTEREST_BATCH_ID IS NULL THEN
281: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
282: fnd_message.set_token('RECORD', 'ar_interest_batches');
283: fnd_message.set_token('VALUE',
284: NVL(TO_CHAR(P_INTEREST_BATCH_ID), 'null'));
285: fnd_msg_pub.add;

Line 282: fnd_message.set_token('RECORD', 'ar_interest_batches');

278: CLOSE c;
279:
280: IF l_rec.INTEREST_BATCH_ID IS NULL THEN
281: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
282: fnd_message.set_token('RECORD', 'ar_interest_batches');
283: fnd_message.set_token('VALUE',
284: NVL(TO_CHAR(P_INTEREST_BATCH_ID), 'null'));
285: fnd_msg_pub.add;
286: RAISE fnd_api.g_exc_error;

Line 283: fnd_message.set_token('VALUE',

279:
280: IF l_rec.INTEREST_BATCH_ID IS NULL THEN
281: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
282: fnd_message.set_token('RECORD', 'ar_interest_batches');
283: fnd_message.set_token('VALUE',
284: NVL(TO_CHAR(P_INTEREST_BATCH_ID), 'null'));
285: fnd_msg_pub.add;
286: RAISE fnd_api.g_exc_error;
287: END IF;

Line 295: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');

291: (x_object_version_number IS NOT NULL AND
292: l_rec.OBJECT_VERSION_NUMBER IS NOT NULL AND
293: x_object_version_number = l_rec.OBJECT_VERSION_NUMBER))
294: THEN
295: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
296: fnd_message.set_token('TABLE', 'ar_interest_batches');
297: fnd_msg_pub.add;
298: RAISE fnd_api.g_exc_error;
299: END IF;

Line 296: fnd_message.set_token('TABLE', 'ar_interest_batches');

292: l_rec.OBJECT_VERSION_NUMBER IS NOT NULL AND
293: x_object_version_number = l_rec.OBJECT_VERSION_NUMBER))
294: THEN
295: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
296: fnd_message.set_token('TABLE', 'ar_interest_batches');
297: fnd_msg_pub.add;
298: RAISE fnd_api.g_exc_error;
299: END IF;
300:

Line 338: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

334: x_msg_data := FND_MSG_PUB.Get(FND_MSG_PUB.G_LAST,FND_API.G_FALSE );
335: END IF;
336: WHEN OTHERS THEN
337: x_return_status := fnd_api.g_ret_sts_unexp_error;
338: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
339: fnd_message.set_token('ERROR' ,SQLERRM);
340: fnd_msg_pub.add;
341: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
342: p_count => x_msg_count,

Line 339: fnd_message.set_token('ERROR' ,SQLERRM);

335: END IF;
336: WHEN OTHERS THEN
337: x_return_status := fnd_api.g_ret_sts_unexp_error;
338: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
339: fnd_message.set_token('ERROR' ,SQLERRM);
340: fnd_msg_pub.add;
341: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
342: p_count => x_msg_count,
343: p_data => x_msg_data);

Line 406: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');

402: l_rec.OBJECT_VERSION_NUMBER;
403: CLOSE c;
404:
405: IF l_rec.INTEREST_BATCH_ID IS NULL THEN
406: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
407: fnd_message.set_token('RECORD', 'ar_interest_batches');
408: fnd_message.set_token('VALUE',
409: NVL(TO_CHAR(P_INTEREST_BATCH_ID), 'null'));
410: fnd_msg_pub.add;

Line 407: fnd_message.set_token('RECORD', 'ar_interest_batches');

403: CLOSE c;
404:
405: IF l_rec.INTEREST_BATCH_ID IS NULL THEN
406: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
407: fnd_message.set_token('RECORD', 'ar_interest_batches');
408: fnd_message.set_token('VALUE',
409: NVL(TO_CHAR(P_INTEREST_BATCH_ID), 'null'));
410: fnd_msg_pub.add;
411: RAISE fnd_api.g_exc_error;

Line 408: fnd_message.set_token('VALUE',

404:
405: IF l_rec.INTEREST_BATCH_ID IS NULL THEN
406: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
407: fnd_message.set_token('RECORD', 'ar_interest_batches');
408: fnd_message.set_token('VALUE',
409: NVL(TO_CHAR(P_INTEREST_BATCH_ID), 'null'));
410: fnd_msg_pub.add;
411: RAISE fnd_api.g_exc_error;
412: END IF;

Line 420: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');

416: (x_object_version_number IS NOT NULL AND
417: l_rec.OBJECT_VERSION_NUMBER IS NOT NULL AND
418: x_object_version_number = l_rec.OBJECT_VERSION_NUMBER))
419: THEN
420: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
421: fnd_message.set_token('TABLE', 'ar_interest_batches');
422: fnd_msg_pub.add;
423: RAISE fnd_api.g_exc_error;
424: END IF;

Line 421: fnd_message.set_token('TABLE', 'ar_interest_batches');

417: l_rec.OBJECT_VERSION_NUMBER IS NOT NULL AND
418: x_object_version_number = l_rec.OBJECT_VERSION_NUMBER))
419: THEN
420: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
421: fnd_message.set_token('TABLE', 'ar_interest_batches');
422: fnd_msg_pub.add;
423: RAISE fnd_api.g_exc_error;
424: END IF;
425:

Line 492: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

488:
489: WHEN OTHERS THEN
490: rollback to update_batch;
491: x_return_status := fnd_api.g_ret_sts_unexp_error;
492: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
493: fnd_message.set_token('ERROR' ,SQLERRM);
494: fnd_msg_pub.add;
495: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
496: p_count => x_msg_count,

Line 493: fnd_message.set_token('ERROR' ,SQLERRM);

489: WHEN OTHERS THEN
490: rollback to update_batch;
491: x_return_status := fnd_api.g_ret_sts_unexp_error;
492: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
493: fnd_message.set_token('ERROR' ,SQLERRM);
494: fnd_msg_pub.add;
495: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
496: p_count => x_msg_count,
497: p_data => x_msg_data);