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_CONC_REPLACE_PKG dependencies on FND_MSG_PUB

Line 72: fnd_msg_pub.add_exc_msg (G_PKG_NAME, l_api_name);

68: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
69:
70: EXCEPTION
71: WHEN OTHERS THEN
72: fnd_msg_pub.add_exc_msg (G_PKG_NAME, l_api_name);
73: END delete_recipe_dependencies;
74:
75: /*###############################################################
76: # NAME

Line 186: fnd_msg_pub.add_exc_msg (G_PKG_NAME, l_api_name);

182: WHEN OTHERS THEN
183: IF (dbms_sql.is_open(l_cursor_id)) THEN
184: dbms_sql.close_cursor(l_cursor_id);
185: END IF;
186: fnd_msg_pub.add_exc_msg (G_PKG_NAME, l_api_name);
187: END Populate_search_table;
188:
189: /* ************************************************************************ */
190: /* API name : Mass_Replace_Operation */

Line 205: /* 19-SEP-2006 Kalyani Removed unwanted fnd_msg_pub.add calls. */

201: /* 20-JUN-2006 Kapil M Changes made to get the recipe type */
202: /* value */
203: /* 19-SEP-2006 Kalyani Display orgn code in log file. */
204: /* 19-SEP-2006 Kalyani Check item access for override orgn */
205: /* 19-SEP-2006 Kalyani Removed unwanted fnd_msg_pub.add calls. */
206: /* ************************************************************************ */
207: PROCEDURE Mass_Replace_Operation ( err_buf OUT NOCOPY VARCHAR2,
208: ret_code OUT NOCOPY VARCHAR2,
209: pConcurrent_id IN NUMBER DEFAULT NULL,

Line 651: FND_MSG_PUB.ADD;

647: FND_MESSAGE.SET_NAME('GMD', 'GMD_REPLACE_NOT_ALLOWED');
648: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
649: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
650: FND_MESSAGE.SET_TOKEN('STATUS',get_status_meaning(l_status_type) );
651: FND_MSG_PUB.ADD;
652: RAISE NO_UPDATE_EXCEPTION;
653: END IF;
654:
655: -- Convert scale factor to number - applicable in non US number formats

Line 674: FND_MSG_PUB.ADD;

670: IF l_itm_exists <> 1 THEN
671: FND_MESSAGE.SET_NAME('gmd', 'GMD_FORMULA_ITMORG_NOT_FOUND');
672: FND_MESSAGE.SET_TOKEN('ITEM',get_item_no(get_object_rec.new_name));
673: FND_MESSAGE.SET_TOKEN('ORGN',get_orgn_code(l_orgn_id));
674: FND_MSG_PUB.ADD;
675: RAISE NO_UPDATE_EXCEPTION;
676: END IF;
677:
678: -- Check if the Revision is enabled for the item.

Line 695: FND_MSG_PUB.ADD;

691: FND_MESSAGE.SET_NAME('GMD', 'GMD_FORMULA_ITMREV_NOT_FOUND');
692: FND_MESSAGE.SET_TOKEN('ITEM',get_item_no(get_object_rec.new_name));
693: FND_MESSAGE.set_token('REV',get_object_rec.new_version );
694: FND_MESSAGE.SET_TOKEN('ORGN',get_orgn_code(l_orgn_id));
695: FND_MSG_PUB.ADD;
696: RAISE NO_UPDATE_EXCEPTION;
697: END IF;
698: END IF;
699: END IF;

Line 709: FND_MSG_PUB.ADD;

705: FETCH Cur_experimental_items INTO l_expr_items_found;
706: CLOSE Cur_experimental_items;
707: IF l_expr_items_found > 0 THEN
708: FND_MESSAGE.SET_NAME('GMD', 'GMD_EXPR_ITEMS_FOUND');
709: FND_MSG_PUB.ADD;
710: RAISE NO_UPDATE_EXCEPTION;
711: END IF;
712: END IF;
713: END IF;

Line 835: FND_MSG_PUB.ADD;

831: AND NVL(revision, -1) = NVL(get_object_rec.old_version, -1);
832: -- Raise and exception is replace was not performed
833: IF (SQL%NOTFOUND) THEN
834: FND_MESSAGE.SET_NAME('GMD', 'GMD_FORM_UPD_NO_ACCESS');
835: FND_MSG_PUB.ADD;
836: RAISE NO_UPDATE_EXCEPTION;
837: END IF;
838: -- Item substitution realted fix, Bug 4479101
839: FOR my_subs_rec IN Cur_get_substitute_id(get_object_rec.old_name, get_object_rec.object_id) LOOP --bug 4479101

Line 927: FND_MSG_PUB.ADD;

923: FND_MESSAGE.SET_NAME('GMD', 'GMD_REPLACE_NOT_ALLOWED');
924: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
925: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
926: FND_MESSAGE.SET_TOKEN('STATUS',get_status_meaning(l_status_type) );
927: FND_MSG_PUB.ADD;
928: RAISE NO_UPDATE_EXCEPTION;
929: END IF;
930:
931: SELECT DECODE(get_object_rec.replace_type,'FORMULA_ID'

Line 964: -- Bug 5531791 Removed FND_MSG_PUB.GET and FND_MSG_PUB.ADD as the message

960: ,p_organization_id => l_organization_id
961: ,x_return_status => l_status );
962:
963: IF l_status <> FND_API.g_ret_sts_success THEN
964: -- Bug 5531791 Removed FND_MSG_PUB.GET and FND_MSG_PUB.ADD as the message
965: -- is already added by GMD_API_GRP.check_item_exists
966: RAISE NO_UPDATE_EXCEPTION;
967: END IF;
968:

Line 986: -- Bug 5531791 Removed FND_MSG_PUB.GET and FND_MSG_PUB.ADD as the message

982: ,p_organization_id => l_org_id
983: ,x_return_status => l_status );
984:
985: IF l_status <> FND_API.g_ret_sts_success THEN
986: -- Bug 5531791 Removed FND_MSG_PUB.GET and FND_MSG_PUB.ADD as the message
987: -- is already added by GMD_API_GRP.check_item_exists
988: RAISE NO_UPDATE_EXCEPTION;
989: END IF;
990: -- Bug 5531717 add code to check for ovverride orgn

Line 1090: FND_MSG_PUB.ADD;

1086: WHERE recipe_id = get_object_rec.object_id;
1087:
1088: IF (sql%notfound) THEN
1089: FND_MESSAGE.SET_NAME('GMD', 'GMD_RCP_UPD_NO_ACCESS');
1090: FND_MSG_PUB.ADD;
1091: RAISE NO_UPDATE_EXCEPTION;
1092: END IF;
1093: -- Delete all recipe dependencies if either formula or
1094: -- routing is replaced.

Line 1161: FND_MSG_PUB.ADD;

1157: FND_MESSAGE.SET_NAME('GMD', 'GMD_REPLACE_NOT_ALLOWED');
1158: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
1159: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
1160: FND_MESSAGE.SET_TOKEN('STATUS',get_status_meaning(l_status_type) );
1161: FND_MSG_PUB.ADD;
1162: RAISE NO_UPDATE_EXCEPTION;
1163: END IF;
1164:
1165: IF (l_action_flag IN ('I')) THEN

Line 1361: FND_MSG_PUB.ADD;

1357: FND_MESSAGE.SET_NAME('GMD', 'GMD_REPLACE_NOT_ALLOWED');
1358: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
1359: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
1360: FND_MESSAGE.SET_TOKEN('STATUS',get_status_meaning(l_status_type) );
1361: FND_MSG_PUB.ADD;
1362: RAISE NO_UPDATE_EXCEPTION;
1363: END IF;
1364:
1365: IF (l_action_flag IN ('I')) THEN

Line 1567: -- Bug 5531791 Removed FND_MSG_PUB.GET and FND_MSG_PUB.ADD as the message

1563: (p_formula_id => l_form_id
1564: ,p_organization_id => get_object_rec.new_name
1565: ,x_return_status => l_status );
1566: IF l_status <> FND_API.g_ret_sts_success THEN
1567: -- Bug 5531791 Removed FND_MSG_PUB.GET and FND_MSG_PUB.ADD as the message
1568: -- is already added by GMD_API_GRP.check_item_exists
1569: RAISE NO_UPDATE_EXCEPTION;
1570: END IF;
1571: ELSE

Line 1593: FND_MSG_PUB.ADD;

1589: FND_MESSAGE.SET_NAME('GMD', 'GMD_REPLACE_NOT_ALLOWED');
1590: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
1591: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
1592: FND_MESSAGE.SET_TOKEN('STATUS',get_status_meaning(l_status_type) );
1593: FND_MSG_PUB.ADD;
1594: RAISE NO_UPDATE_EXCEPTION;
1595: END IF; -- for action flags for VRs
1596: END IF; -- After working thro' every object type condition
1597: END IF; -- replace type is checked for 'STATUS'

Line 1673: -- fnd_msg_pub.add;

1669:
1670: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',pObject_type);
1671: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',get_object_rec.object_vers);
1672: -- to be removed
1673: -- fnd_msg_pub.add;
1674: END IF;
1675:
1676: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1677: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

Line 1686: -- Passing fnd_msg_pub.Count_Msg to get the top most message

1682: ||l_rowcount);
1683: EXCEPTION
1684: WHEN NO_UPDATE_EXCEPTION THEN
1685: -- Bug# 5008299 Kapil M
1686: -- Passing fnd_msg_pub.Count_Msg to get the top most message
1687: fnd_msg_pub.get
1688: (p_msg_index => fnd_msg_pub.Count_Msg
1689: ,p_data => l_error_text
1690: ,p_encoded => 'F'

Line 1687: fnd_msg_pub.get

1683: EXCEPTION
1684: WHEN NO_UPDATE_EXCEPTION THEN
1685: -- Bug# 5008299 Kapil M
1686: -- Passing fnd_msg_pub.Count_Msg to get the top most message
1687: fnd_msg_pub.get
1688: (p_msg_index => fnd_msg_pub.Count_Msg
1689: ,p_data => l_error_text
1690: ,p_encoded => 'F'
1691: ,p_msg_index_out => l_dummy_cnt

Line 1688: (p_msg_index => fnd_msg_pub.Count_Msg

1684: WHEN NO_UPDATE_EXCEPTION THEN
1685: -- Bug# 5008299 Kapil M
1686: -- Passing fnd_msg_pub.Count_Msg to get the top most message
1687: fnd_msg_pub.get
1688: (p_msg_index => fnd_msg_pub.Count_Msg
1689: ,p_data => l_error_text
1690: ,p_encoded => 'F'
1691: ,p_msg_index_out => l_dummy_cnt
1692: );

Line 1773: fnd_msg_pub.add_exc_msg (G_PKG_NAME, l_api_name);

1769: ret_code := 2;
1770: err_buf := NULL;
1771: l_retval := fnd_concurrent.set_completion_status('WARNING',sqlerrm);
1772:
1773: fnd_msg_pub.add_exc_msg (G_PKG_NAME, l_api_name);
1774: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');
1775:
1776: IF (get_object_rec.replace_type = 'INGREDIENT') THEN
1777: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','LM_INGREDIENT',true);

Line 1865: fnd_msg_pub.get

1861:
1862: EXCEPTION
1863: -- this exception occurs when no rows were selected for update.
1864: WHEN NO_REPLACE_EXCEPTION THEN
1865: fnd_msg_pub.get
1866: (p_msg_index => 1
1867: ,p_data => l_error_text
1868: ,p_encoded => 'F'
1869: ,p_msg_index_out => l_dummy_cnt

Line 1892: fnd_msg_pub.add_exc_msg (G_PKG_NAME, l_api_name);

1888: ret_code := 2;
1889: err_buf := NULL;
1890: l_retval := fnd_concurrent.set_completion_status('WARNING',sqlerrm);
1891:
1892: fnd_msg_pub.add_exc_msg (G_PKG_NAME, l_api_name);
1893: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');
1894: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);
1895: IF (pReplace_type = 'INGREDIENT') THEN
1896: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE', get_item_no(pNew_name) );

Line 2050: FND_MSG_PUB.ADD;

2046: fnd_dsql.add_text( ' And '||l_replace_type||' IS NULL )');
2047: ELSE
2048: -- pOld_Name cannot be null
2049: FND_MESSAGE.SET_NAME('GMD','GMD_NO_ASSIGN_VALUE_EXCEPTION');
2050: FND_MSG_PUB.ADD;
2051: RAISE VALIDATION_FAILED_EXCEPTION;
2052: END IF;
2053: ELSE
2054: fnd_dsql.add_text( ' And '||l_replace_type||' IN (');

Line 2144: fnd_msg_pub.add_exc_msg (G_PKG_NAME, l_api_name);

2140: ||' : When Others for Validate_all_rep_rows, Error '||
2141: sqlerrm);
2142: END IF;
2143: x_return_status := 'U';
2144: fnd_msg_pub.add_exc_msg (G_PKG_NAME, l_api_name);
2145:
2146: END Validate_All_Replace_rows;
2147:
2148: END;