DBA Data[Home] [Help]

APPS.GMD_SUBSTITUTION_PVT dependencies on FND_MSG_PUB

Line 79: FND_MSG_PUB.ADD;

75: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',l_old_substitution_name);
76: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE','SUBSTITUTION');
77: FND_MESSAGE.SET_TOKEN('NEW_ITEM',l_old_substitution_name||' - '||
78: l_old_substitution_version);
79: FND_MSG_PUB.ADD;
80: END IF;
81: END IF;
82:
83: /* Get the messgae list and count generated by this API */

Line 84: fnd_msg_pub.count_and_get (

80: END IF;
81: END IF;
82:
83: /* Get the messgae list and count generated by this API */
84: fnd_msg_pub.count_and_get (
85: p_count => x_message_count
86: ,p_encoded => FND_API.g_false
87: ,p_data => x_message_list);
88: END Create_new_substitution_vers;

Line 129: FND_MSG_PUB.ADD;

125: CLOSE get_item_info;
126:
127: IF (l_original_prim_item_um IS NULL) THEN
128: FND_MESSAGE.SET_NAME ('GMD', 'GMD_INVALID_ORIGINAL_ITEM');
129: FND_MSG_PUB.ADD;
130: RAISE substitution_creation_failure;
131: END IF;
132:
133: -- Call the table handler for insert of substitution header

Line 191: fnd_msg_pub.count_and_get (

187: Raise substitution_creation_failure;
188: END IF;
189:
190: /* Get the messgae list and count generated by this API */
191: fnd_msg_pub.count_and_get (
192: p_count => x_message_count
193: ,p_encoded => FND_API.g_false
194: ,p_data => x_message_list);
195:

Line 199: fnd_msg_pub.count_and_get (

195:
196: EXCEPTION
197: WHEN substitution_creation_failure THEN
198: x_return_status := FND_API.G_RET_STS_ERROR;
199: fnd_msg_pub.count_and_get (
200: p_count => x_message_count
201: ,p_encoded => FND_API.g_false
202: ,p_data => x_message_list);
203: WHEN OTHERS THEN

Line 204: fnd_msg_pub.add_exc_msg (GMD_SUBSTITUTION_PVT.m_pkg_name, l_api_name);

200: p_count => x_message_count
201: ,p_encoded => FND_API.g_false
202: ,p_data => x_message_list);
203: WHEN OTHERS THEN
204: fnd_msg_pub.add_exc_msg (GMD_SUBSTITUTION_PVT.m_pkg_name, l_api_name);
205: x_return_status := FND_API.g_ret_sts_unexp_error;
206: fnd_msg_pub.count_and_get (
207: p_count => x_message_count
208: ,p_encoded => FND_API.g_false

Line 206: fnd_msg_pub.count_and_get (

202: ,p_data => x_message_list);
203: WHEN OTHERS THEN
204: fnd_msg_pub.add_exc_msg (GMD_SUBSTITUTION_PVT.m_pkg_name, l_api_name);
205: x_return_status := FND_API.g_ret_sts_unexp_error;
206: fnd_msg_pub.count_and_get (
207: p_count => x_message_count
208: ,p_encoded => FND_API.g_false
209: ,p_data => x_message_list);
210: END Create_substitution_header;

Line 258: fnd_msg_pub.count_and_get (

254: Raise substitution_creation_failure;
255: END IF;
256:
257: /* Get the messgae list and count generated by this API */
258: fnd_msg_pub.count_and_get (
259: p_count => x_message_count
260: ,p_encoded => FND_API.g_false
261: ,p_data => x_message_list);
262: EXCEPTION

Line 265: fnd_msg_pub.count_and_get (

261: ,p_data => x_message_list);
262: EXCEPTION
263: WHEN substitution_creation_failure THEN
264: x_return_status := FND_API.G_RET_STS_ERROR;
265: fnd_msg_pub.count_and_get (
266: p_count => x_message_count
267: ,p_encoded => FND_API.g_false
268: ,p_data => x_message_list);
269: WHEN OTHERS THEN

Line 270: fnd_msg_pub.add_exc_msg (GMD_SUBSTITUTION_PVT.m_pkg_name, l_api_name);

266: p_count => x_message_count
267: ,p_encoded => FND_API.g_false
268: ,p_data => x_message_list);
269: WHEN OTHERS THEN
270: fnd_msg_pub.add_exc_msg (GMD_SUBSTITUTION_PVT.m_pkg_name, l_api_name);
271: x_return_status := FND_API.g_ret_sts_unexp_error;
272: fnd_msg_pub.count_and_get (
273: p_count => x_message_count
274: ,p_encoded => FND_API.g_false

Line 272: fnd_msg_pub.count_and_get (

268: ,p_data => x_message_list);
269: WHEN OTHERS THEN
270: fnd_msg_pub.add_exc_msg (GMD_SUBSTITUTION_PVT.m_pkg_name, l_api_name);
271: x_return_status := FND_API.g_ret_sts_unexp_error;
272: fnd_msg_pub.count_and_get (
273: p_count => x_message_count
274: ,p_encoded => FND_API.g_false
275: ,p_data => x_message_list);
276: END Create_substitution_detail;

Line 379: fnd_msg_pub.count_and_get (

375: , x_return_status => x_return_status
376: );
377:
378: /* Get the messgae list and count generated by this API */
379: fnd_msg_pub.count_and_get (
380: p_count => x_message_count
381: ,p_encoded => FND_API.g_false
382: ,p_data => x_message_list);
383: EXCEPTION

Line 386: fnd_msg_pub.count_and_get (

382: ,p_data => x_message_list);
383: EXCEPTION
384: WHEN substitution_creation_failure THEN
385: x_return_status := FND_API.G_RET_STS_ERROR;
386: fnd_msg_pub.count_and_get (
387: p_count => x_message_count
388: ,p_encoded => FND_API.g_false
389: ,p_data => x_message_list);
390: WHEN OTHERS THEN

Line 391: fnd_msg_pub.add_exc_msg (GMD_SUBSTITUTION_PVT.m_pkg_name, l_api_name);

387: p_count => x_message_count
388: ,p_encoded => FND_API.g_false
389: ,p_data => x_message_list);
390: WHEN OTHERS THEN
391: fnd_msg_pub.add_exc_msg (GMD_SUBSTITUTION_PVT.m_pkg_name, l_api_name);
392: x_return_status := FND_API.g_ret_sts_unexp_error;
393: fnd_msg_pub.count_and_get (
394: p_count => x_message_count
395: ,p_encoded => FND_API.g_false

Line 393: fnd_msg_pub.count_and_get (

389: ,p_data => x_message_list);
390: WHEN OTHERS THEN
391: fnd_msg_pub.add_exc_msg (GMD_SUBSTITUTION_PVT.m_pkg_name, l_api_name);
392: x_return_status := FND_API.g_ret_sts_unexp_error;
393: fnd_msg_pub.count_and_get (
394: p_count => x_message_count
395: ,p_encoded => FND_API.g_false
396: ,p_data => x_message_list);
397: END Create_formula_association;

Line 464: FND_MSG_PUB.ADD;

460: CLOSE check_for_date_overlap;
461:
462: IF (l_dummy > 0) THEN
463: FND_MESSAGE.SET_NAME('GMD','GMD_ITSUB_DATE_PRE_OVERLAP');
464: FND_MSG_PUB.ADD;
465: RAISE substitution_update_failure;
466: END IF;
467:
468: -- Call the table handler for update of substitution header

Line 554: fnd_msg_pub.count_and_get (

550: , x_return_status => x_return_status
551: );
552:
553: /* Get the messgae list and count generated by this API */
554: fnd_msg_pub.count_and_get (
555: p_count => x_message_count
556: ,p_encoded => FND_API.g_false
557: ,p_data => x_message_list);
558: EXCEPTION

Line 561: fnd_msg_pub.count_and_get (

557: ,p_data => x_message_list);
558: EXCEPTION
559: WHEN substitution_update_failure THEN
560: x_return_status := FND_API.G_RET_STS_ERROR;
561: fnd_msg_pub.count_and_get (
562: p_count => x_message_count
563: ,p_encoded => FND_API.g_false
564: ,p_data => x_message_list);
565: WHEN OTHERS THEN

Line 566: fnd_msg_pub.add_exc_msg (GMD_SUBSTITUTION_PVT.m_pkg_name, l_api_name);

562: p_count => x_message_count
563: ,p_encoded => FND_API.g_false
564: ,p_data => x_message_list);
565: WHEN OTHERS THEN
566: fnd_msg_pub.add_exc_msg (GMD_SUBSTITUTION_PVT.m_pkg_name, l_api_name);
567: x_return_status := FND_API.g_ret_sts_unexp_error;
568: fnd_msg_pub.count_and_get (
569: p_count => x_message_count
570: ,p_encoded => FND_API.g_false

Line 568: fnd_msg_pub.count_and_get (

564: ,p_data => x_message_list);
565: WHEN OTHERS THEN
566: fnd_msg_pub.add_exc_msg (GMD_SUBSTITUTION_PVT.m_pkg_name, l_api_name);
567: x_return_status := FND_API.g_ret_sts_unexp_error;
568: fnd_msg_pub.count_and_get (
569: p_count => x_message_count
570: ,p_encoded => FND_API.g_false
571: ,p_data => x_message_list);
572: END Update_substitution_header;

Line 619: fnd_msg_pub.count_and_get (

615: , x_return_status => x_return_status
616: );
617:
618: /* Get the messgae list and count generated by this API */
619: fnd_msg_pub.count_and_get (
620: p_count => x_message_count
621: ,p_encoded => FND_API.g_false
622: ,p_data => x_message_list);
623: EXCEPTION

Line 625: fnd_msg_pub.add_exc_msg (gmd_substitution_pvt.m_pkg_name, l_api_name);

621: ,p_encoded => FND_API.g_false
622: ,p_data => x_message_list);
623: EXCEPTION
624: WHEN OTHERS THEN
625: fnd_msg_pub.add_exc_msg (gmd_substitution_pvt.m_pkg_name, l_api_name);
626: x_return_status := FND_API.g_ret_sts_unexp_error;
627: fnd_msg_pub.count_and_get (
628: p_count => x_message_count
629: ,p_encoded => FND_API.g_false

Line 627: fnd_msg_pub.count_and_get (

623: EXCEPTION
624: WHEN OTHERS THEN
625: fnd_msg_pub.add_exc_msg (gmd_substitution_pvt.m_pkg_name, l_api_name);
626: x_return_status := FND_API.g_ret_sts_unexp_error;
627: fnd_msg_pub.count_and_get (
628: p_count => x_message_count
629: ,p_encoded => FND_API.g_false
630: ,p_data => x_message_list);
631: END Update_substitution_detail;

Line 713: fnd_msg_pub.count_and_get (

709: , x_return_status => x_return_status
710: );
711:
712: /* Get the messgae list and count generated by this API */
713: fnd_msg_pub.count_and_get (
714: p_count => x_message_count
715: ,p_encoded => FND_API.g_false
716: ,p_data => x_message_list);
717: EXCEPTION

Line 719: fnd_msg_pub.add_exc_msg (gmd_substitution_pvt.m_pkg_name, l_api_name);

715: ,p_encoded => FND_API.g_false
716: ,p_data => x_message_list);
717: EXCEPTION
718: WHEN OTHERS THEN
719: fnd_msg_pub.add_exc_msg (gmd_substitution_pvt.m_pkg_name, l_api_name);
720: x_return_status := FND_API.g_ret_sts_unexp_error;
721: fnd_msg_pub.count_and_get (
722: p_count => x_message_count
723: ,p_encoded => FND_API.g_false

Line 721: fnd_msg_pub.count_and_get (

717: EXCEPTION
718: WHEN OTHERS THEN
719: fnd_msg_pub.add_exc_msg (gmd_substitution_pvt.m_pkg_name, l_api_name);
720: x_return_status := FND_API.g_ret_sts_unexp_error;
721: fnd_msg_pub.count_and_get (
722: p_count => x_message_count
723: ,p_encoded => FND_API.g_false
724: ,p_data => x_message_list);
725: END Delete_formula_association;

Line 934: fnd_msg_pub.count_and_get (

930: -- Assign the new substitution version
931: x_new_substitution_version := l_substitution_hdr_rec.substitution_version;
932:
933: /* Get the messgae list and count generated by this API */
934: fnd_msg_pub.count_and_get (
935: p_count => x_message_count
936: ,p_encoded => FND_API.g_false
937: ,p_data => x_message_list);
938: EXCEPTION

Line 941: fnd_msg_pub.count_and_get (

937: ,p_data => x_message_list);
938: EXCEPTION
939: WHEN substitution_creation_failure THEN
940: x_return_status := FND_API.G_RET_STS_ERROR;
941: fnd_msg_pub.count_and_get (
942: p_count => x_message_count
943: ,p_encoded => FND_API.g_false
944: ,p_data => x_message_list);
945: WHEN OTHERS THEN

Line 946: fnd_msg_pub.add_exc_msg (gmd_substitution_pvt.m_pkg_name, l_api_name);

942: p_count => x_message_count
943: ,p_encoded => FND_API.g_false
944: ,p_data => x_message_list);
945: WHEN OTHERS THEN
946: fnd_msg_pub.add_exc_msg (gmd_substitution_pvt.m_pkg_name, l_api_name);
947: x_return_status := FND_API.g_ret_sts_unexp_error;
948: fnd_msg_pub.count_and_get (
949: p_count => x_message_count
950: ,p_encoded => FND_API.g_false

Line 948: fnd_msg_pub.count_and_get (

944: ,p_data => x_message_list);
945: WHEN OTHERS THEN
946: fnd_msg_pub.add_exc_msg (gmd_substitution_pvt.m_pkg_name, l_api_name);
947: x_return_status := FND_API.g_ret_sts_unexp_error;
948: fnd_msg_pub.count_and_get (
949: p_count => x_message_count
950: ,p_encoded => FND_API.g_false
951: ,p_data => x_message_list);
952: END Copy_substitution;