eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_SUBSTITUTION_PVT dependencies on FND_API

Line 50: x_return_status := FND_API.G_RET_STS_SUCCESS;

46: FROM gmd_item_substitution_hdr_b
47: WHERE substitution_id = vSubstitution_id;
48: BEGIN
49: /* Set the return status to success initially */
50: x_return_status := FND_API.G_RET_STS_SUCCESS;
51:
52: -- If version control is turned ON - copy the existing formula substitution
53: -- details and its association and create a new substitution header with
54: -- these details.

Line 86: ,p_encoded => FND_API.g_false

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;
89:
90: /* =============================================================== */

Line 121: x_return_status := FND_API.G_RET_STS_SUCCESS;

117: /* Define Exceptions */
118: substitution_creation_failure EXCEPTION;
119: BEGIN
120: /* Set the return status to success initially */
121: x_return_status := FND_API.G_RET_STS_SUCCESS;
122:
123: OPEN get_item_info(p_substitution_hdr_rec.original_inventory_item_id);
124: FETCH get_item_info INTO l_original_prim_item_um;
125: CLOSE get_item_info;

Line 193: ,p_encoded => FND_API.g_false

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:
196: EXCEPTION
197: WHEN substitution_creation_failure THEN

Line 198: x_return_status := FND_API.G_RET_STS_ERROR;

194: ,p_data => x_message_list);
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);

Line 201: ,p_encoded => FND_API.g_false

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

Line 205: x_return_status := FND_API.g_ret_sts_unexp_error;

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
209: ,p_data => x_message_list);

Line 208: ,p_encoded => FND_API.g_false

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;
211:
212: /* =============================================================== */

Line 237: x_return_status := FND_API.G_RET_STS_SUCCESS;

233: /* Define Exceptions */
234: substitution_creation_failure EXCEPTION;
235: BEGIN
236: /* Set the return status to success initially */
237: x_return_status := FND_API.G_RET_STS_SUCCESS;
238:
239: -- Call the table handler for insert of substitution details
240: GMD_ITEM_SUBSTITUTION_DTL_PKG.INSERT_ROW(
241: X_ROWID => l_row_id,

Line 260: ,p_encoded => FND_API.g_false

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
263: WHEN substitution_creation_failure THEN
264: x_return_status := FND_API.G_RET_STS_ERROR;

Line 264: x_return_status := FND_API.G_RET_STS_ERROR;

260: ,p_encoded => FND_API.g_false
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);

Line 267: ,p_encoded => FND_API.g_false

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

Line 271: x_return_status := FND_API.g_ret_sts_unexp_error;

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
275: ,p_data => x_message_list);

Line 274: ,p_encoded => FND_API.g_false

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;
277:
278:

Line 316: x_return_status := FND_API.G_RET_STS_SUCCESS;

312: /* Define Exceptions */
313: substitution_creation_failure EXCEPTION;
314: BEGIN
315: /* Set the return status to success initially */
316: x_return_status := FND_API.G_RET_STS_SUCCESS;
317:
318: -- Calculation 1
319: -- List status is Appr for Gen Use and formulas are associated to this list
320: -- set the associated flag to 'Y'

Line 381: ,p_encoded => FND_API.g_false

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
384: WHEN substitution_creation_failure THEN
385: x_return_status := FND_API.G_RET_STS_ERROR;

Line 385: x_return_status := FND_API.G_RET_STS_ERROR;

381: ,p_encoded => FND_API.g_false
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);

Line 388: ,p_encoded => FND_API.g_false

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

Line 392: x_return_status := FND_API.g_ret_sts_unexp_error;

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
396: ,p_data => x_message_list);

Line 395: ,p_encoded => FND_API.g_false

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;
398:
399: /* =============================================================== */

Line 445: x_return_status := FND_API.G_RET_STS_SUCCESS;

441: /* Define Exceptions */
442: substitution_update_failure EXCEPTION;
443: BEGIN
444: /* Set the return status to success initially */
445: x_return_status := FND_API.G_RET_STS_SUCCESS;
446:
447: OPEN get_old_subs_rec(p_substitution_hdr_rec.substitution_id);
448: FETCH get_old_subs_rec INTO l_old_substitution_hdr_rec;
449: CLOSE get_old_subs_rec;

Line 556: ,p_encoded => FND_API.g_false

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
559: WHEN substitution_update_failure THEN
560: x_return_status := FND_API.G_RET_STS_ERROR;

Line 560: x_return_status := FND_API.G_RET_STS_ERROR;

556: ,p_encoded => FND_API.g_false
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);

Line 563: ,p_encoded => FND_API.g_false

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

Line 567: x_return_status := FND_API.g_ret_sts_unexp_error;

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
571: ,p_data => x_message_list);

Line 570: ,p_encoded => FND_API.g_false

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;
573:
574: /* =============================================================== */

Line 595: x_return_status := FND_API.G_RET_STS_SUCCESS;

591: l_api_name CONSTANT VARCHAR2(30) := 'Update_substitution_detail';
592: l_substitution_dtl_rec gmd_item_substitution_dtl%ROWTYPE;
593: BEGIN
594: /* Set the return status to success initially */
595: x_return_status := FND_API.G_RET_STS_SUCCESS;
596:
597: -- Call the table handler for update of substitution details
598: GMD_ITEM_SUBSTITUTION_DTL_PKG.UPDATE_ROW(
599: X_SUBSTITUTION_LINE_ID => p_substitution_dtl_rec.substitution_line_id,

Line 621: ,p_encoded => FND_API.g_false

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
624: WHEN OTHERS THEN
625: fnd_msg_pub.add_exc_msg (gmd_substitution_pvt.m_pkg_name, l_api_name);

Line 626: x_return_status := FND_API.g_ret_sts_unexp_error;

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
630: ,p_data => x_message_list);

Line 629: ,p_encoded => FND_API.g_false

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;
632:
633: /* =============================================================== */

Line 674: x_return_status := FND_API.G_RET_STS_SUCCESS;

670: AND y.formula_id = vformula_id
671: AND z.substitution_status BETWEEN 700 AND 799;
672: BEGIN
673: /* Set the return status to success initially */
674: x_return_status := FND_API.G_RET_STS_SUCCESS;
675:
676: OPEN get_fm_and_orig_item(p_formula_substitution_id);
677: FETCH get_fm_and_orig_item INTO l_formula_id
678: , l_original_item_id

Line 715: ,p_encoded => FND_API.g_false

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
718: WHEN OTHERS THEN
719: fnd_msg_pub.add_exc_msg (gmd_substitution_pvt.m_pkg_name, l_api_name);

Line 720: x_return_status := FND_API.g_ret_sts_unexp_error;

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
724: ,p_data => x_message_list);

Line 723: ,p_encoded => FND_API.g_false

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;
726:
727: /* =============================================================== */

Line 848: x_return_status := FND_API.G_RET_STS_SUCCESS;

844: -- Exception declaration
845: substitution_creation_failure EXCEPTION;
846: BEGIN
847: /* Set the return status to success initially */
848: x_return_status := FND_API.G_RET_STS_SUCCESS;
849:
850: /* Populate the record */
851: -- Populate header
852: OPEN get_substitution_hdr_rec(p_old_substitution_id);

Line 895: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

891: , x_message_list => x_message_list
892: , x_return_status => x_return_status
893: );
894:
895: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
896: RAISE substitution_creation_failure;
897: END IF;
898:
899: -- Insert substitution detail

Line 914: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

910: , x_message_list => x_message_list
911: , x_return_status => x_return_status
912: );
913:
914: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
915: RAISE substitution_creation_failure;
916: END IF;
917:
918: Create_formula_association

Line 926: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

922: , x_message_list => x_message_list
923: , x_return_status => x_return_status
924: );
925:
926: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
927: RAISE substitution_creation_failure;
928: END IF;
929:
930: -- Assign the new substitution version

Line 936: ,p_encoded => FND_API.g_false

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
939: WHEN substitution_creation_failure THEN
940: x_return_status := FND_API.G_RET_STS_ERROR;

Line 940: x_return_status := FND_API.G_RET_STS_ERROR;

936: ,p_encoded => FND_API.g_false
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);

Line 943: ,p_encoded => FND_API.g_false

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

Line 947: x_return_status := FND_API.g_ret_sts_unexp_error;

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
951: ,p_data => x_message_list);

Line 950: ,p_encoded => FND_API.g_false

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;
953:
954: END GMD_SUBSTITUTION_PVT;