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: /*###############################################################

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

317: WHEN OTHERS THEN
318: /*IF (dbms_sql.is_open(l_cursor_id)) THEN
319: dbms_sql.close_cursor(l_cursor_id);
320: END IF;*/
321: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);
322: END Populate_search_table;
323:
324: /* ************************************************************************ */
325: /* API name : Mass_Replace_Operation */

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

336: /* 20-JUN-2006 Kapil M Changes made to get the recipe type */
337: /* value */
338: /* 19-SEP-2006 Kalyani Display orgn code in log file. */
339: /* 19-SEP-2006 Kalyani Check item access for override orgn */
340: /* 19-SEP-2006 Kalyani Removed unwanted fnd_msg_pub.add calls. */
341: /* ************************************************************************ */
342: PROCEDURE Mass_Replace_Operation ( err_buf OUT NOCOPY VARCHAR2,
343: ret_code OUT NOCOPY VARCHAR2,
344: pConcurrent_id IN NUMBER DEFAULT NULL,

Line 804: FND_MSG_PUB.ADD;

800: FND_MESSAGE.SET_NAME('GMD', 'GMD_REPLACE_NOT_ALLOWED');
801: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
802: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
803: FND_MESSAGE.SET_TOKEN('STATUS',get_status_meaning(l_status_type) );
804: FND_MSG_PUB.ADD;
805: RAISE NO_UPDATE_EXCEPTION;
806: END IF;
807:
808: -- Convert scale factor to number - applicable in non US number formats

Line 827: FND_MSG_PUB.ADD;

823: IF l_itm_exists <> 1 THEN
824: FND_MESSAGE.SET_NAME('gmd', 'GMD_FORMULA_ITMORG_NOT_FOUND');
825: FND_MESSAGE.SET_TOKEN('ITEM',get_item_no(get_object_rec.new_name));
826: FND_MESSAGE.SET_TOKEN('ORGN',get_orgn_code(l_orgn_id));
827: FND_MSG_PUB.ADD;
828: RAISE NO_UPDATE_EXCEPTION;
829: END IF;
830:
831: -- Check if the Revision is enabled for the item.

Line 848: FND_MSG_PUB.ADD;

844: FND_MESSAGE.SET_NAME('GMD', 'GMD_FORMULA_ITMREV_NOT_FOUND');
845: FND_MESSAGE.SET_TOKEN('ITEM',get_item_no(get_object_rec.new_name));
846: FND_MESSAGE.set_token('REV',get_object_rec.new_version );
847: FND_MESSAGE.SET_TOKEN('ORGN',get_orgn_code(l_orgn_id));
848: FND_MSG_PUB.ADD;
849: RAISE NO_UPDATE_EXCEPTION;
850: END IF;
851: END IF;
852: END IF;

Line 862: FND_MSG_PUB.ADD;

858: FETCH Cur_experimental_items INTO l_expr_items_found;
859: CLOSE Cur_experimental_items;
860: IF l_expr_items_found > 0 THEN
861: FND_MESSAGE.SET_NAME('GMD', 'GMD_EXPR_ITEMS_FOUND');
862: FND_MSG_PUB.ADD;
863: RAISE NO_UPDATE_EXCEPTION;
864: END IF;
865: END IF;
866: END IF;

Line 988: FND_MSG_PUB.ADD;

984: AND NVL(revision, -1) = NVL(get_object_rec.old_version, -1);
985: -- Raise and exception is replace was not performed
986: IF (SQL%NOTFOUND) THEN
987: FND_MESSAGE.SET_NAME('GMD', 'GMD_FORM_UPD_NO_ACCESS');
988: FND_MSG_PUB.ADD;
989: RAISE NO_UPDATE_EXCEPTION;
990: END IF;
991: -- Item substitution realted fix, Bug 4479101
992: FOR my_subs_rec IN Cur_get_substitute_id(get_object_rec.old_name, get_object_rec.object_id) LOOP --bug 4479101

Line 1080: FND_MSG_PUB.ADD;

1076: FND_MESSAGE.SET_NAME('GMD', 'GMD_REPLACE_NOT_ALLOWED');
1077: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
1078: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
1079: FND_MESSAGE.SET_TOKEN('STATUS',get_status_meaning(l_status_type) );
1080: FND_MSG_PUB.ADD;
1081: RAISE NO_UPDATE_EXCEPTION;
1082: END IF;
1083:
1084: SELECT DECODE(get_object_rec.replace_type,'FORMULA_ID'

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

1113: ,p_organization_id => l_organization_id
1114: ,x_return_status => l_status );
1115:
1116: IF l_status <> FND_API.g_ret_sts_success THEN
1117: -- Bug 5531791 Removed FND_MSG_PUB.GET and FND_MSG_PUB.ADD as the message
1118: -- is already added by GMD_API_GRP.check_item_exists
1119: RAISE NO_UPDATE_EXCEPTION;
1120: END IF;
1121:

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

1135: ,p_organization_id => l_org_id
1136: ,x_return_status => l_status );
1137:
1138: IF l_status <> FND_API.g_ret_sts_success THEN
1139: -- Bug 5531791 Removed FND_MSG_PUB.GET and FND_MSG_PUB.ADD as the message
1140: -- is already added by GMD_API_GRP.check_item_exists
1141: RAISE NO_UPDATE_EXCEPTION;
1142: END IF;
1143: -- Bug 5531717 add code to check for ovverride orgn

Line 1243: FND_MSG_PUB.ADD;

1239: WHERE recipe_id = get_object_rec.object_id;
1240:
1241: IF (sql%notfound) THEN
1242: FND_MESSAGE.SET_NAME('GMD', 'GMD_RCP_UPD_NO_ACCESS');
1243: FND_MSG_PUB.ADD;
1244: RAISE NO_UPDATE_EXCEPTION;
1245: END IF;
1246: -- Delete all recipe dependencies if either formula or
1247: -- routing is replaced.

Line 1314: FND_MSG_PUB.ADD;

1310: FND_MESSAGE.SET_NAME('GMD', 'GMD_REPLACE_NOT_ALLOWED');
1311: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
1312: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
1313: FND_MESSAGE.SET_TOKEN('STATUS',get_status_meaning(l_status_type) );
1314: FND_MSG_PUB.ADD;
1315: RAISE NO_UPDATE_EXCEPTION;
1316: END IF;
1317:
1318: IF (l_action_flag IN ('I')) THEN

Line 1530: FND_MSG_PUB.ADD;

1526: FND_MESSAGE.SET_NAME('GMD', 'GMD_REPLACE_NOT_ALLOWED');
1527: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
1528: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
1529: FND_MESSAGE.SET_TOKEN('STATUS',get_status_meaning(l_status_type) );
1530: FND_MSG_PUB.ADD;
1531: RAISE NO_UPDATE_EXCEPTION;
1532: END IF;
1533:
1534: IF (l_action_flag IN ('I')) THEN

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

1749: (p_formula_id => l_form_id
1750: ,p_organization_id => get_object_rec.new_name
1751: ,x_return_status => l_status );
1752: IF l_status <> FND_API.g_ret_sts_success THEN
1753: -- Bug 5531791 Removed FND_MSG_PUB.GET and FND_MSG_PUB.ADD as the message
1754: -- is already added by GMD_API_GRP.check_item_exists
1755: RAISE NO_UPDATE_EXCEPTION;
1756: END IF;
1757: ELSE

Line 1779: FND_MSG_PUB.ADD;

1775: FND_MESSAGE.SET_NAME('GMD', 'GMD_REPLACE_NOT_ALLOWED');
1776: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
1777: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
1778: FND_MESSAGE.SET_TOKEN('STATUS',get_status_meaning(l_status_type) );
1779: FND_MSG_PUB.ADD;
1780: RAISE NO_UPDATE_EXCEPTION;
1781: END IF; -- for action flags for VRs
1782: END IF; -- After working thro' every object type condition
1783: END IF; -- replace type is checked for 'STATUS'

Line 1859: -- fnd_msg_pub.add;

1855:
1856: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',pObject_type);
1857: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',get_object_rec.object_vers);
1858: -- to be removed
1859: -- fnd_msg_pub.add;
1860: END IF;
1861:
1862: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1863: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

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

1868: ||l_rowcount);
1869: EXCEPTION
1870: WHEN NO_UPDATE_EXCEPTION THEN
1871: -- Bug# 5008299 Kapil M
1872: -- Passing fnd_msg_pub.Count_Msg to get the top most message
1873: fnd_msg_pub.get
1874: (p_msg_index => fnd_msg_pub.Count_Msg
1875: ,p_data => l_error_text
1876: ,p_encoded => 'F'

Line 1873: fnd_msg_pub.get

1869: EXCEPTION
1870: WHEN NO_UPDATE_EXCEPTION THEN
1871: -- Bug# 5008299 Kapil M
1872: -- Passing fnd_msg_pub.Count_Msg to get the top most message
1873: fnd_msg_pub.get
1874: (p_msg_index => fnd_msg_pub.Count_Msg
1875: ,p_data => l_error_text
1876: ,p_encoded => 'F'
1877: ,p_msg_index_out => l_dummy_cnt

Line 1874: (p_msg_index => fnd_msg_pub.Count_Msg

1870: WHEN NO_UPDATE_EXCEPTION THEN
1871: -- Bug# 5008299 Kapil M
1872: -- Passing fnd_msg_pub.Count_Msg to get the top most message
1873: fnd_msg_pub.get
1874: (p_msg_index => fnd_msg_pub.Count_Msg
1875: ,p_data => l_error_text
1876: ,p_encoded => 'F'
1877: ,p_msg_index_out => l_dummy_cnt
1878: );

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

1955: ret_code := 2;
1956: err_buf := NULL;
1957: l_retval := fnd_concurrent.set_completion_status('WARNING',sqlerrm);
1958:
1959: fnd_msg_pub.add_exc_msg (G_PKG_NAME, l_api_name);
1960: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');
1961:
1962: IF (get_object_rec.replace_type = 'INGREDIENT') THEN
1963: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','LM_INGREDIENT',true);

Line 2051: fnd_msg_pub.get

2047:
2048: EXCEPTION
2049: -- this exception occurs when no rows were selected for update.
2050: WHEN NO_REPLACE_EXCEPTION THEN
2051: fnd_msg_pub.get
2052: (p_msg_index => 1
2053: ,p_data => l_error_text
2054: ,p_encoded => 'F'
2055: ,p_msg_index_out => l_dummy_cnt

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

2074: ret_code := 2;
2075: err_buf := NULL;
2076: l_retval := fnd_concurrent.set_completion_status('WARNING',sqlerrm);
2077:
2078: fnd_msg_pub.add_exc_msg (G_PKG_NAME, l_api_name);
2079: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');
2080: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);
2081: IF (pReplace_type = 'INGREDIENT') THEN
2082: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE', get_item_no(pNew_name) );

Line 2236: FND_MSG_PUB.ADD;

2232: fnd_dsql.add_text( ' And '||l_replace_type||' IS NULL )');
2233: ELSE
2234: -- pOld_Name cannot be null
2235: FND_MESSAGE.SET_NAME('GMD','GMD_NO_ASSIGN_VALUE_EXCEPTION');
2236: FND_MSG_PUB.ADD;
2237: RAISE VALIDATION_FAILED_EXCEPTION;
2238: END IF;
2239: ELSE
2240: fnd_dsql.add_text( ' And '||l_replace_type||' IN (');

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

2326: ||' : When Others for Validate_all_rep_rows, Error '||
2327: sqlerrm);
2328: END IF;
2329: x_return_status := 'U';
2330: fnd_msg_pub.add_exc_msg (G_PKG_NAME, l_api_name);
2331:
2332: END Validate_All_Replace_rows;
2333:
2334: END;