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_PUB dependencies on FND_API

Line 168: x_return_status := FND_API.G_RET_STS_SUCCESS;

164: BEGIN
165: SAVEPOINT substitution_api;
166:
167: -- Set the return status to success initially
168: x_return_status := FND_API.G_RET_STS_SUCCESS;
169: -- Assigning local record types for manipulation of data values
170: l_substitution_hdr_rec := p_substitution_hdr_rec;
171: l_substitution_dtl_rec := p_substitution_dtl_rec;
172:

Line 174: IF (p_init_msg_list = FND_API.g_true) THEN

170: l_substitution_hdr_rec := p_substitution_hdr_rec;
171: l_substitution_dtl_rec := p_substitution_dtl_rec;
172:
173: /* Initialize message list and count if needed */
174: IF (p_init_msg_list = FND_API.g_true) THEN
175: fnd_msg_pub.initialize;
176: END IF;
177:
178: /* Intialize the setup fields */

Line 187: IF NOT FND_API.compatible_api_call ( 1.0

183: RAISE setup_failure;
184: END IF;
185:
186: /* Make sure we are call compatible */
187: IF NOT FND_API.compatible_api_call ( 1.0
188: ,p_api_version
189: ,'Create_substitution'
190: ,gmd_substitution_pub.m_pkg_name) THEN
191: RAISE invalid_version;

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

391: , x_message_list => x_message_list
392: , x_return_status => x_return_status
393: );
394:
395: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
396: RAISE substitution_creation_failure;
397: END IF;
398:
399: /* Required fields at detail level */

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

525: , x_message_list => x_message_list
526: , x_return_status => x_return_status
527: );
528:
529: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
530: RAISE substitution_creation_failure;
531: END IF;
532:
533: FOR i in 1 .. p_formula_substitution_tbl.count LOOP

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

614: , x_message_list => x_message_list
615: , x_return_status => x_return_status
616: );
617:
618: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
619: RAISE substitution_creation_failure;
620: END IF;
621:
622:

Line 623: IF (p_commit = FND_API.g_true) THEN

619: RAISE substitution_creation_failure;
620: END IF;
621:
622:
623: IF (p_commit = FND_API.g_true) THEN
624: Commit;
625: END IF;
626: EXCEPTION
627: WHEN substitution_creation_failure OR invalid_version OR setup_failure THEN

Line 628: x_return_status := FND_API.g_ret_sts_error;

624: Commit;
625: END IF;
626: EXCEPTION
627: WHEN substitution_creation_failure OR invalid_version OR setup_failure THEN
628: x_return_status := FND_API.g_ret_sts_error;
629: fnd_msg_pub.count_and_get (
630: p_count => x_message_count
631: ,p_encoded => FND_API.g_false
632: ,p_data => x_message_list);

Line 631: ,p_encoded => FND_API.g_false

627: WHEN substitution_creation_failure OR invalid_version OR setup_failure THEN
628: x_return_status := FND_API.g_ret_sts_error;
629: fnd_msg_pub.count_and_get (
630: p_count => x_message_count
631: ,p_encoded => FND_API.g_false
632: ,p_data => x_message_list);
633: ROLLBACK TO SAVEPOINT substitution_api;
634: WHEN OTHERS THEN
635: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 635: x_return_status := FND_API.g_ret_sts_unexp_error;

631: ,p_encoded => FND_API.g_false
632: ,p_data => x_message_list);
633: ROLLBACK TO SAVEPOINT substitution_api;
634: WHEN OTHERS THEN
635: x_return_status := FND_API.g_ret_sts_unexp_error;
636: fnd_msg_pub.add_exc_msg (gmd_substitution_pub.m_pkg_name, l_api_name);
637: fnd_msg_pub.count_and_get (
638: p_count => x_message_count
639: ,p_encoded => FND_API.g_false

Line 639: ,p_encoded => FND_API.g_false

635: x_return_status := FND_API.g_ret_sts_unexp_error;
636: fnd_msg_pub.add_exc_msg (gmd_substitution_pub.m_pkg_name, l_api_name);
637: fnd_msg_pub.count_and_get (
638: p_count => x_message_count
639: ,p_encoded => FND_API.g_false
640: ,p_data => x_message_list);
641: ROLLBACK TO SAVEPOINT substitution_api;
642: END Create_substitution;
643:

Line 702: x_return_status := FND_API.G_RET_STS_SUCCESS;

698: BEGIN
699: SAVEPOINT substitution_api;
700:
701: /* Set the return status to success initially */
702: x_return_status := FND_API.G_RET_STS_SUCCESS;
703:
704: /* Initialize message list and count if needed */
705: IF (p_init_msg_list = FND_API.G_True) THEN
706: fnd_msg_pub.initialize;

Line 705: IF (p_init_msg_list = FND_API.G_True) THEN

701: /* Set the return status to success initially */
702: x_return_status := FND_API.G_RET_STS_SUCCESS;
703:
704: /* Initialize message list and count if needed */
705: IF (p_init_msg_list = FND_API.G_True) THEN
706: fnd_msg_pub.initialize;
707: END IF;
708:
709: /* Intialize the setup fields */

Line 718: IF NOT FND_API.compatible_api_call ( 1.0

714: RAISE setup_failure;
715: END IF;
716:
717: /* Make sure we are call compatible */
718: IF NOT FND_API.compatible_api_call ( 1.0
719: ,p_api_version
720: ,'Create_formula_association'
721: ,gmd_substitution_pub.m_pkg_name) THEN
722: RAISE invalid_version;

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

863: , x_message_list => x_message_list
864: , x_return_status => x_return_status
865: );
866:
867: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
868: RAISE substitution_creation_failure;
869: END IF;
870:
871: IF (p_commit = FND_API.g_true) THEN

Line 871: IF (p_commit = FND_API.g_true) THEN

867: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
868: RAISE substitution_creation_failure;
869: END IF;
870:
871: IF (p_commit = FND_API.g_true) THEN
872: Commit;
873: END IF;
874:
875: EXCEPTION

Line 877: x_return_status := FND_API.G_RET_STS_ERROR;

873: END IF;
874:
875: EXCEPTION
876: WHEN substitution_creation_failure OR invalid_version OR setup_failure THEN
877: x_return_status := FND_API.G_RET_STS_ERROR;
878: fnd_msg_pub.count_and_get (
879: p_count => x_message_count
880: ,p_encoded => FND_API.g_false
881: ,p_data => x_message_list);

Line 880: ,p_encoded => FND_API.g_false

876: WHEN substitution_creation_failure OR invalid_version OR setup_failure THEN
877: x_return_status := FND_API.G_RET_STS_ERROR;
878: fnd_msg_pub.count_and_get (
879: p_count => x_message_count
880: ,p_encoded => FND_API.g_false
881: ,p_data => x_message_list);
882: ROLLBACK TO SAVEPOINT substitution_api;
883: WHEN OTHERS THEN
884: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 884: x_return_status := FND_API.g_ret_sts_unexp_error;

880: ,p_encoded => FND_API.g_false
881: ,p_data => x_message_list);
882: ROLLBACK TO SAVEPOINT substitution_api;
883: WHEN OTHERS THEN
884: x_return_status := FND_API.g_ret_sts_unexp_error;
885: fnd_msg_pub.add_exc_msg (gmd_substitution_pub.m_pkg_name, l_api_name);
886: fnd_msg_pub.count_and_get (
887: p_count => x_message_count
888: ,p_encoded => FND_API.g_false

Line 888: ,p_encoded => FND_API.g_false

884: x_return_status := FND_API.g_ret_sts_unexp_error;
885: fnd_msg_pub.add_exc_msg (gmd_substitution_pub.m_pkg_name, l_api_name);
886: fnd_msg_pub.count_and_get (
887: p_count => x_message_count
888: ,p_encoded => FND_API.g_false
889: ,p_data => x_message_list);
890: ROLLBACK TO SAVEPOINT substitution_api;
891: END Create_formula_association;
892:

Line 938: x_return_status := FND_API.G_RET_STS_SUCCESS;

934: BEGIN
935: SAVEPOINT substitution_api;
936:
937: /* Set the return status to success initially */
938: x_return_status := FND_API.G_RET_STS_SUCCESS;
939:
940: /* Initialize message list and count if needed */
941: IF (p_init_msg_list = FND_API.G_true) THEN
942: fnd_msg_pub.initialize;

Line 941: IF (p_init_msg_list = FND_API.G_true) THEN

937: /* Set the return status to success initially */
938: x_return_status := FND_API.G_RET_STS_SUCCESS;
939:
940: /* Initialize message list and count if needed */
941: IF (p_init_msg_list = FND_API.G_true) THEN
942: fnd_msg_pub.initialize;
943: END IF;
944:
945: /* Intialize the setup fields */

Line 954: IF NOT FND_API.compatible_api_call ( 1.0

950: RAISE setup_failure;
951: END IF;
952:
953: /* Make sure we are call compatible */
954: IF NOT FND_API.compatible_api_call ( 1.0
955: ,p_api_version
956: ,'Update_substitution_header'
957: ,gmd_substitution_pub.m_pkg_name) THEN
958: RAISE invalid_version;

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

1151: , x_message_list => x_message_list
1152: , x_return_status => x_return_status
1153: );
1154:
1155: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1156: RAISE substitution_update_failure;
1157: END IF;
1158:
1159: IF (p_commit = FND_API.g_true) THEN

Line 1159: IF (p_commit = FND_API.g_true) THEN

1155: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1156: RAISE substitution_update_failure;
1157: END IF;
1158:
1159: IF (p_commit = FND_API.g_true) THEN
1160: Commit;
1161: END IF;
1162:
1163: EXCEPTION

Line 1167: ,p_encoded => FND_API.g_false

1163: EXCEPTION
1164: WHEN substitution_update_failure OR invalid_version OR setup_failure THEN
1165: fnd_msg_pub.count_and_get (
1166: p_count => x_message_count
1167: ,p_encoded => FND_API.g_false
1168: ,p_data => x_message_list);
1169: x_return_status := FND_API.G_RET_STS_ERROR;
1170: ROLLBACK TO SAVEPOINT substitution_api;
1171: WHEN OTHERS THEN

Line 1169: x_return_status := FND_API.G_RET_STS_ERROR;

1165: fnd_msg_pub.count_and_get (
1166: p_count => x_message_count
1167: ,p_encoded => FND_API.g_false
1168: ,p_data => x_message_list);
1169: x_return_status := FND_API.G_RET_STS_ERROR;
1170: ROLLBACK TO SAVEPOINT substitution_api;
1171: WHEN OTHERS THEN
1172: x_return_status := FND_API.g_ret_sts_unexp_error;
1173: fnd_msg_pub.add_exc_msg (gmd_substitution_pub.m_pkg_name, l_api_name);

Line 1172: x_return_status := FND_API.g_ret_sts_unexp_error;

1168: ,p_data => x_message_list);
1169: x_return_status := FND_API.G_RET_STS_ERROR;
1170: ROLLBACK TO SAVEPOINT substitution_api;
1171: WHEN OTHERS THEN
1172: x_return_status := FND_API.g_ret_sts_unexp_error;
1173: fnd_msg_pub.add_exc_msg (gmd_substitution_pub.m_pkg_name, l_api_name);
1174: fnd_msg_pub.count_and_get (
1175: p_count => x_message_count
1176: ,p_encoded => FND_API.g_false

Line 1176: ,p_encoded => FND_API.g_false

1172: x_return_status := FND_API.g_ret_sts_unexp_error;
1173: fnd_msg_pub.add_exc_msg (gmd_substitution_pub.m_pkg_name, l_api_name);
1174: fnd_msg_pub.count_and_get (
1175: p_count => x_message_count
1176: ,p_encoded => FND_API.g_false
1177: ,p_data => x_message_list);
1178: ROLLBACK TO SAVEPOINT substitution_api;
1179: END Update_substitution_header;
1180:

Line 1243: x_return_status := FND_API.G_RET_STS_SUCCESS;

1239: BEGIN
1240: SAVEPOINT substitution_api;
1241:
1242: /* Set the return status to success initially */
1243: x_return_status := FND_API.G_RET_STS_SUCCESS;
1244:
1245: /* Initialize message list and count if needed */
1246: IF (p_init_msg_list = FND_API.G_True) THEN
1247: fnd_msg_pub.initialize;

Line 1246: IF (p_init_msg_list = FND_API.G_True) THEN

1242: /* Set the return status to success initially */
1243: x_return_status := FND_API.G_RET_STS_SUCCESS;
1244:
1245: /* Initialize message list and count if needed */
1246: IF (p_init_msg_list = FND_API.G_True) THEN
1247: fnd_msg_pub.initialize;
1248: END IF;
1249:
1250: /* Intialize the setup fields */

Line 1259: IF NOT FND_API.compatible_api_call ( 1.0

1255: RAISE setup_failure;
1256: END IF;
1257:
1258: /* Make sure we are call compatible */
1259: IF NOT FND_API.compatible_api_call ( 1.0
1260: ,p_api_version
1261: ,'Update_substitution_header'
1262: ,gmd_substitution_pub.m_pkg_name) THEN
1263: RAISE invalid_version;

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

1425: , x_message_list => x_message_list
1426: , x_return_status => x_return_status
1427: );
1428:
1429: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1430: RAISE substitution_update_failure;
1431: END IF;
1432:
1433: IF (p_commit = FND_API.g_true) THEN

Line 1433: IF (p_commit = FND_API.g_true) THEN

1429: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1430: RAISE substitution_update_failure;
1431: END IF;
1432:
1433: IF (p_commit = FND_API.g_true) THEN
1434: Commit;
1435: END IF;
1436: EXCEPTION
1437: WHEN substitution_update_failure OR invalid_version OR setup_failure THEN

Line 1440: ,p_encoded => FND_API.g_false

1436: EXCEPTION
1437: WHEN substitution_update_failure OR invalid_version OR setup_failure THEN
1438: fnd_msg_pub.count_and_get (
1439: p_count => x_message_count
1440: ,p_encoded => FND_API.g_false
1441: ,p_data => x_message_list);
1442: x_return_status := FND_API.G_RET_STS_ERROR;
1443: ROLLBACK TO SAVEPOINT substitution_api;
1444: WHEN OTHERS THEN

Line 1442: x_return_status := FND_API.G_RET_STS_ERROR;

1438: fnd_msg_pub.count_and_get (
1439: p_count => x_message_count
1440: ,p_encoded => FND_API.g_false
1441: ,p_data => x_message_list);
1442: x_return_status := FND_API.G_RET_STS_ERROR;
1443: ROLLBACK TO SAVEPOINT substitution_api;
1444: WHEN OTHERS THEN
1445: x_return_status := FND_API.g_ret_sts_unexp_error;
1446: fnd_msg_pub.add_exc_msg (gmd_substitution_pub.m_pkg_name, l_api_name);

Line 1445: x_return_status := FND_API.g_ret_sts_unexp_error;

1441: ,p_data => x_message_list);
1442: x_return_status := FND_API.G_RET_STS_ERROR;
1443: ROLLBACK TO SAVEPOINT substitution_api;
1444: WHEN OTHERS THEN
1445: x_return_status := FND_API.g_ret_sts_unexp_error;
1446: fnd_msg_pub.add_exc_msg (gmd_substitution_pub.m_pkg_name, l_api_name);
1447: fnd_msg_pub.count_and_get (
1448: p_count => x_message_count
1449: ,p_encoded => FND_API.g_false

Line 1449: ,p_encoded => FND_API.g_false

1445: x_return_status := FND_API.g_ret_sts_unexp_error;
1446: fnd_msg_pub.add_exc_msg (gmd_substitution_pub.m_pkg_name, l_api_name);
1447: fnd_msg_pub.count_and_get (
1448: p_count => x_message_count
1449: ,p_encoded => FND_API.g_false
1450: ,p_data => x_message_list);
1451: ROLLBACK TO SAVEPOINT substitution_api;
1452: END Update_substitution_detail;
1453:

Line 1506: x_return_status := FND_API.G_RET_STS_SUCCESS;

1502: BEGIN
1503: SAVEPOINT substitution_api;
1504:
1505: /* Set the return status to success initially */
1506: x_return_status := FND_API.G_RET_STS_SUCCESS;
1507:
1508: /* Initialize message list and count if needed */
1509: IF (p_init_msg_list = FND_API.G_True) THEN
1510: fnd_msg_pub.initialize;

Line 1509: IF (p_init_msg_list = FND_API.G_True) THEN

1505: /* Set the return status to success initially */
1506: x_return_status := FND_API.G_RET_STS_SUCCESS;
1507:
1508: /* Initialize message list and count if needed */
1509: IF (p_init_msg_list = FND_API.G_True) THEN
1510: fnd_msg_pub.initialize;
1511: END IF;
1512:
1513: /* Intialize the setup fields */

Line 1522: IF NOT FND_API.compatible_api_call ( 1.0

1518: RAISE setup_failure;
1519: END IF;
1520:
1521: /* Make sure we are call compatible */
1522: IF NOT FND_API.compatible_api_call ( 1.0
1523: ,p_api_version
1524: ,'Delete_formula_association'
1525: ,gmd_substitution_pub.m_pkg_name) THEN
1526: RAISE invalid_version;

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

1616: , x_message_list => x_message_list
1617: , x_return_status => x_return_status
1618: );
1619:
1620: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1621: RAISE substitution_delete_failure;
1622: END IF;
1623:
1624: IF (p_commit = FND_API.g_true) THEN

Line 1624: IF (p_commit = FND_API.g_true) THEN

1620: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1621: RAISE substitution_delete_failure;
1622: END IF;
1623:
1624: IF (p_commit = FND_API.g_true) THEN
1625: Commit;
1626: END IF;
1627:
1628: EXCEPTION

Line 1632: ,p_encoded => FND_API.g_false

1628: EXCEPTION
1629: WHEN substitution_delete_failure OR invalid_version OR setup_failure THEN
1630: fnd_msg_pub.count_and_get (
1631: p_count => x_message_count
1632: ,p_encoded => FND_API.g_false
1633: ,p_data => x_message_list);
1634: x_return_status := FND_API.G_RET_STS_ERROR;
1635: ROLLBACK TO SAVEPOINT substitution_api;
1636: WHEN OTHERS THEN

Line 1634: x_return_status := FND_API.G_RET_STS_ERROR;

1630: fnd_msg_pub.count_and_get (
1631: p_count => x_message_count
1632: ,p_encoded => FND_API.g_false
1633: ,p_data => x_message_list);
1634: x_return_status := FND_API.G_RET_STS_ERROR;
1635: ROLLBACK TO SAVEPOINT substitution_api;
1636: WHEN OTHERS THEN
1637: x_return_status := FND_API.g_ret_sts_unexp_error;
1638: fnd_msg_pub.add_exc_msg (gmd_substitution_pub.m_pkg_name, l_api_name);

Line 1637: x_return_status := FND_API.g_ret_sts_unexp_error;

1633: ,p_data => x_message_list);
1634: x_return_status := FND_API.G_RET_STS_ERROR;
1635: ROLLBACK TO SAVEPOINT substitution_api;
1636: WHEN OTHERS THEN
1637: x_return_status := FND_API.g_ret_sts_unexp_error;
1638: fnd_msg_pub.add_exc_msg (gmd_substitution_pub.m_pkg_name, l_api_name);
1639: fnd_msg_pub.count_and_get (
1640: p_count => x_message_count
1641: ,p_encoded => FND_API.g_false

Line 1641: ,p_encoded => FND_API.g_false

1637: x_return_status := FND_API.g_ret_sts_unexp_error;
1638: fnd_msg_pub.add_exc_msg (gmd_substitution_pub.m_pkg_name, l_api_name);
1639: fnd_msg_pub.count_and_get (
1640: p_count => x_message_count
1641: ,p_encoded => FND_API.g_false
1642: ,p_data => x_message_list);
1643: ROLLBACK TO SAVEPOINT substitution_api;
1644: END Delete_formula_association;
1645: