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.EGO_ITEM_PVT dependencies on FND_MESSAGE

Line 153: fnd_message.Set_Name(G_APP_NAME, 'EGO_ORGANIZATION_ID');

149: RETURN TRUE;
150: EXCEPTION
151: WHEN OTHERS THEN
152: IF FND_API.To_Boolean(p_set_message) THEN
153: fnd_message.Set_Name(G_APP_NAME, 'EGO_ORGANIZATION_ID');
154: l_dummy_char := fnd_message.get();
155: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');
156: fnd_message.Set_Token('NAME', l_dummy_char);
157: fnd_message.Set_Token('VALUE', x_organization_id);

Line 154: l_dummy_char := fnd_message.get();

150: EXCEPTION
151: WHEN OTHERS THEN
152: IF FND_API.To_Boolean(p_set_message) THEN
153: fnd_message.Set_Name(G_APP_NAME, 'EGO_ORGANIZATION_ID');
154: l_dummy_char := fnd_message.get();
155: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');
156: fnd_message.Set_Token('NAME', l_dummy_char);
157: fnd_message.Set_Token('VALUE', x_organization_id);
158: fnd_msg_pub.Add;

Line 155: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');

151: WHEN OTHERS THEN
152: IF FND_API.To_Boolean(p_set_message) THEN
153: fnd_message.Set_Name(G_APP_NAME, 'EGO_ORGANIZATION_ID');
154: l_dummy_char := fnd_message.get();
155: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');
156: fnd_message.Set_Token('NAME', l_dummy_char);
157: fnd_message.Set_Token('VALUE', x_organization_id);
158: fnd_msg_pub.Add;
159: END IF;

Line 156: fnd_message.Set_Token('NAME', l_dummy_char);

152: IF FND_API.To_Boolean(p_set_message) THEN
153: fnd_message.Set_Name(G_APP_NAME, 'EGO_ORGANIZATION_ID');
154: l_dummy_char := fnd_message.get();
155: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');
156: fnd_message.Set_Token('NAME', l_dummy_char);
157: fnd_message.Set_Token('VALUE', x_organization_id);
158: fnd_msg_pub.Add;
159: END IF;
160: RETURN FALSE;

Line 157: fnd_message.Set_Token('VALUE', x_organization_id);

153: fnd_message.Set_Name(G_APP_NAME, 'EGO_ORGANIZATION_ID');
154: l_dummy_char := fnd_message.get();
155: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');
156: fnd_message.Set_Token('NAME', l_dummy_char);
157: fnd_message.Set_Token('VALUE', x_organization_id);
158: fnd_msg_pub.Add;
159: END IF;
160: RETURN FALSE;
161: END;

Line 172: fnd_message.Set_Name(G_APP_NAME, 'EGO_ORGANIZATION_CODE');

168: RETURN TRUE;
169: EXCEPTION
170: WHEN OTHERS THEN
171: IF FND_API.To_Boolean(p_set_message) THEN
172: fnd_message.Set_Name(G_APP_NAME, 'EGO_ORGANIZATION_CODE');
173: l_dummy_char := fnd_message.get();
174: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');
175: fnd_message.Set_Token('NAME', l_dummy_char);
176: fnd_message.Set_Token('VALUE', p_organization_code);

Line 173: l_dummy_char := fnd_message.get();

169: EXCEPTION
170: WHEN OTHERS THEN
171: IF FND_API.To_Boolean(p_set_message) THEN
172: fnd_message.Set_Name(G_APP_NAME, 'EGO_ORGANIZATION_CODE');
173: l_dummy_char := fnd_message.get();
174: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');
175: fnd_message.Set_Token('NAME', l_dummy_char);
176: fnd_message.Set_Token('VALUE', p_organization_code);
177: fnd_msg_pub.Add;

Line 174: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');

170: WHEN OTHERS THEN
171: IF FND_API.To_Boolean(p_set_message) THEN
172: fnd_message.Set_Name(G_APP_NAME, 'EGO_ORGANIZATION_CODE');
173: l_dummy_char := fnd_message.get();
174: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');
175: fnd_message.Set_Token('NAME', l_dummy_char);
176: fnd_message.Set_Token('VALUE', p_organization_code);
177: fnd_msg_pub.Add;
178: END IF;

Line 175: fnd_message.Set_Token('NAME', l_dummy_char);

171: IF FND_API.To_Boolean(p_set_message) THEN
172: fnd_message.Set_Name(G_APP_NAME, 'EGO_ORGANIZATION_CODE');
173: l_dummy_char := fnd_message.get();
174: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');
175: fnd_message.Set_Token('NAME', l_dummy_char);
176: fnd_message.Set_Token('VALUE', p_organization_code);
177: fnd_msg_pub.Add;
178: END IF;
179: RETURN FALSE;

Line 176: fnd_message.Set_Token('VALUE', p_organization_code);

172: fnd_message.Set_Name(G_APP_NAME, 'EGO_ORGANIZATION_CODE');
173: l_dummy_char := fnd_message.get();
174: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');
175: fnd_message.Set_Token('NAME', l_dummy_char);
176: fnd_message.Set_Token('VALUE', p_organization_code);
177: fnd_msg_pub.Add;
178: END IF;
179: RETURN FALSE;
180: END;

Line 218: fnd_message.Set_Name(G_APP_NAME, 'EGO_EF_BL_INV_ITEM_ID_ERR');

214: RETURN TRUE;
215: EXCEPTION
216: WHEN OTHERS THEN
217: IF FND_API.To_Boolean(p_set_message) THEN
218: fnd_message.Set_Name(G_APP_NAME, 'EGO_EF_BL_INV_ITEM_ID_ERR');
219: fnd_message.Set_Token('ITEM_ID', x_inventory_item_id);
220: fnd_msg_pub.Add;
221: END IF;
222: RETURN FALSE;

Line 219: fnd_message.Set_Token('ITEM_ID', x_inventory_item_id);

215: EXCEPTION
216: WHEN OTHERS THEN
217: IF FND_API.To_Boolean(p_set_message) THEN
218: fnd_message.Set_Name(G_APP_NAME, 'EGO_EF_BL_INV_ITEM_ID_ERR');
219: fnd_message.Set_Token('ITEM_ID', x_inventory_item_id);
220: fnd_msg_pub.Add;
221: END IF;
222: RETURN FALSE;
223: END;

Line 237: fnd_message.Set_Name(G_APP_NAME, 'EGO_EF_BL_ITEM_NUM_ERR');

233: RETURN TRUE;
234: EXCEPTION
235: WHEN OTHERS THEN
236: IF FND_API.To_Boolean(p_set_message) THEN
237: fnd_message.Set_Name(G_APP_NAME, 'EGO_EF_BL_ITEM_NUM_ERR');
238: fnd_message.Set_Token('ITEM_NUMBER', x_item_number);
239: fnd_msg_pub.Add;
240: END IF;
241: RETURN FALSE;

Line 238: fnd_message.Set_Token('ITEM_NUMBER', x_item_number);

234: EXCEPTION
235: WHEN OTHERS THEN
236: IF FND_API.To_Boolean(p_set_message) THEN
237: fnd_message.Set_Name(G_APP_NAME, 'EGO_EF_BL_ITEM_NUM_ERR');
238: fnd_message.Set_Token('ITEM_NUMBER', x_item_number);
239: fnd_msg_pub.Add;
240: END IF;
241: RETURN FALSE;
242: END;

Line 251: fnd_message.Set_Name(G_APP_NAME, 'EGO_ORGANIZATION');

247: RETURN FALSE;
248: END IF;
249: ELSE
250: IF FND_API.To_Boolean(p_set_message) THEN
251: fnd_message.Set_Name(G_APP_NAME, 'EGO_ORGANIZATION');
252: l_dummy_char := fnd_message.get();
253: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');
254: fnd_message.Set_Token('NAME', l_dummy_char);
255: fnd_message.Set_Token('VALUE', ' ');

Line 252: l_dummy_char := fnd_message.get();

248: END IF;
249: ELSE
250: IF FND_API.To_Boolean(p_set_message) THEN
251: fnd_message.Set_Name(G_APP_NAME, 'EGO_ORGANIZATION');
252: l_dummy_char := fnd_message.get();
253: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');
254: fnd_message.Set_Token('NAME', l_dummy_char);
255: fnd_message.Set_Token('VALUE', ' ');
256: fnd_msg_pub.Add;

Line 253: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');

249: ELSE
250: IF FND_API.To_Boolean(p_set_message) THEN
251: fnd_message.Set_Name(G_APP_NAME, 'EGO_ORGANIZATION');
252: l_dummy_char := fnd_message.get();
253: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');
254: fnd_message.Set_Token('NAME', l_dummy_char);
255: fnd_message.Set_Token('VALUE', ' ');
256: fnd_msg_pub.Add;
257: END IF;

Line 254: fnd_message.Set_Token('NAME', l_dummy_char);

250: IF FND_API.To_Boolean(p_set_message) THEN
251: fnd_message.Set_Name(G_APP_NAME, 'EGO_ORGANIZATION');
252: l_dummy_char := fnd_message.get();
253: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');
254: fnd_message.Set_Token('NAME', l_dummy_char);
255: fnd_message.Set_Token('VALUE', ' ');
256: fnd_msg_pub.Add;
257: END IF;
258: RETURN FALSE;

Line 255: fnd_message.Set_Token('VALUE', ' ');

251: fnd_message.Set_Name(G_APP_NAME, 'EGO_ORGANIZATION');
252: l_dummy_char := fnd_message.get();
253: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');
254: fnd_message.Set_Token('NAME', l_dummy_char);
255: fnd_message.Set_Token('VALUE', ' ');
256: fnd_msg_pub.Add;
257: END IF;
258: RETURN FALSE;
259: END IF;

Line 295: fnd_message.Set_Name(G_APP_NAME, 'EGO_REVISIONID_INVALID');

291: RETURN TRUE;
292: EXCEPTION
293: WHEN OTHERS THEN
294: IF FND_API.To_Boolean(p_set_message) THEN
295: fnd_message.Set_Name(G_APP_NAME, 'EGO_REVISIONID_INVALID');
296: fnd_message.Set_Token('REVISION_ID', x_revision_id);
297: fnd_msg_pub.Add;
298: END IF;
299: RETURN FALSE;

Line 296: fnd_message.Set_Token('REVISION_ID', x_revision_id);

292: EXCEPTION
293: WHEN OTHERS THEN
294: IF FND_API.To_Boolean(p_set_message) THEN
295: fnd_message.Set_Name(G_APP_NAME, 'EGO_REVISIONID_INVALID');
296: fnd_message.Set_Token('REVISION_ID', x_revision_id);
297: fnd_msg_pub.Add;
298: END IF;
299: RETURN FALSE;
300: END;

Line 313: fnd_message.Set_Name(G_APP_NAME, 'EGO_REVISION_INVALID');

309: RETURN TRUE;
310: EXCEPTION
311: WHEN OTHERS THEN
312: IF FND_API.To_Boolean(p_set_message) THEN
313: fnd_message.Set_Name(G_APP_NAME, 'EGO_REVISION_INVALID');
314: fnd_message.Set_Token('REVISION', x_revision);
315: fnd_msg_pub.Add;
316: END IF;
317: RETURN FALSE;

Line 314: fnd_message.Set_Token('REVISION', x_revision);

310: EXCEPTION
311: WHEN OTHERS THEN
312: IF FND_API.To_Boolean(p_set_message) THEN
313: fnd_message.Set_Name(G_APP_NAME, 'EGO_REVISION_INVALID');
314: fnd_message.Set_Token('REVISION', x_revision);
315: fnd_msg_pub.Add;
316: END IF;
317: RETURN FALSE;
318: END;

Line 548: fnd_message.Set_Name(G_APP_NAME, 'EGO_NO_FUNC_PRIVILEGE_FOR_USER');

544: IF fnd_function.test(p_function_name) THEN
545: RETURN TRUE;
546: ELSE
547: IF FND_API.To_Boolean(p_set_message) THEN
548: fnd_message.Set_Name(G_APP_NAME, 'EGO_NO_FUNC_PRIVILEGE_FOR_USER');
549: fnd_msg_pub.Add;
550: END IF;
551: RETURN FALSE;
552: END IF;

Line 1427: FND_MESSAGE.set_name('INV', l_return_err); --Setting error message to be returned

1423: ,x_return_status => l_return_status
1424: ,x_return_err => l_return_err
1425: );
1426:
1427: FND_MESSAGE.set_name('INV', l_return_err); --Setting error message to be returned
1428:
1429: ELSIF ( G_Item_Rec.Transaction_Type = 'CREATE' ) THEN
1430:
1431: INV_ITEM_GRP.Create_Item

Line 3049: fnd_message.Set_Name(G_APP_NAME, 'EGO_NO_FUNC_PRIVILEGE_FOR_USER');

3045: CLOSE c_user_party_id;
3046: --
3047: -- user is not registered properly
3048: --
3049: fnd_message.Set_Name(G_APP_NAME, 'EGO_NO_FUNC_PRIVILEGE_FOR_USER');
3050: IF FND_API.To_Boolean(p_set_message) THEN
3051: fnd_msg_pub.Add;
3052: END IF;
3053: RETURN FALSE;

Line 3090: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_CANNOT_GRANT');

3086: CLOSE c_priv_cursor;
3087: IF FND_API.To_Boolean(p_set_message) THEN
3088: code_debug (' user does not have privilege '||p_function_name ||' on item '||p_inventory_item_id);
3089: IF p_function_name = G_FN_NAME_ADD_ROLE THEN
3090: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_CANNOT_GRANT');
3091: -- EGO_IPI_CANNOT_GRANT : User "USER" does not have privilege to give grants on Item "ITEM" in Organization "ORGANIZATION".
3092: ELSIF p_function_name IN (G_FN_NAME_PROMOTE) THEN
3093: fnd_message.Set_Name(G_APP_NAME, 'EGO_NO_PRIV_PROMOTE');
3094: -- EGO_NO_PRIV_PROMOTE : User "USER" does not have privilege to create, update, or delete pending phase records for promotion of Item "ITEM_NUMBER" in Organization "ORGANIZATION".

Line 3093: fnd_message.Set_Name(G_APP_NAME, 'EGO_NO_PRIV_PROMOTE');

3089: IF p_function_name = G_FN_NAME_ADD_ROLE THEN
3090: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_CANNOT_GRANT');
3091: -- EGO_IPI_CANNOT_GRANT : User "USER" does not have privilege to give grants on Item "ITEM" in Organization "ORGANIZATION".
3092: ELSIF p_function_name IN (G_FN_NAME_PROMOTE) THEN
3093: fnd_message.Set_Name(G_APP_NAME, 'EGO_NO_PRIV_PROMOTE');
3094: -- EGO_NO_PRIV_PROMOTE : User "USER" does not have privilege to create, update, or delete pending phase records for promotion of Item "ITEM_NUMBER" in Organization "ORGANIZATION".
3095: ELSIF p_function_name IN (G_FN_NAME_DEMOTE) THEN
3096: fnd_message.Set_Name(G_APP_NAME, 'EGO_NO_PRIV_DEMOTE');
3097: -- EGO_NO_PRIV_DEMOTE : User "USER" does not have privilege to create, update, or delete pending phase records for demotion of Item "ITEM_NUMBER" in Organization "ORGANIZATION".

Line 3096: fnd_message.Set_Name(G_APP_NAME, 'EGO_NO_PRIV_DEMOTE');

3092: ELSIF p_function_name IN (G_FN_NAME_PROMOTE) THEN
3093: fnd_message.Set_Name(G_APP_NAME, 'EGO_NO_PRIV_PROMOTE');
3094: -- EGO_NO_PRIV_PROMOTE : User "USER" does not have privilege to create, update, or delete pending phase records for promotion of Item "ITEM_NUMBER" in Organization "ORGANIZATION".
3095: ELSIF p_function_name IN (G_FN_NAME_DEMOTE) THEN
3096: fnd_message.Set_Name(G_APP_NAME, 'EGO_NO_PRIV_DEMOTE');
3097: -- EGO_NO_PRIV_DEMOTE : User "USER" does not have privilege to create, update, or delete pending phase records for demotion of Item "ITEM_NUMBER" in Organization "ORGANIZATION".
3098: ELSIF p_function_name = G_FN_NAME_CHANGE_STATUS THEN
3099: fnd_message.Set_Name(G_APP_NAME, 'EGO_NO_PRIV_CHANGE_STATUS');
3100: -- EGO_NO_PRIV_CHANGE_STATUS : User "USER" does not have privilege to change status of Item "ITEM" in Organization "ORGANIZATION".

Line 3099: fnd_message.Set_Name(G_APP_NAME, 'EGO_NO_PRIV_CHANGE_STATUS');

3095: ELSIF p_function_name IN (G_FN_NAME_DEMOTE) THEN
3096: fnd_message.Set_Name(G_APP_NAME, 'EGO_NO_PRIV_DEMOTE');
3097: -- EGO_NO_PRIV_DEMOTE : User "USER" does not have privilege to create, update, or delete pending phase records for demotion of Item "ITEM_NUMBER" in Organization "ORGANIZATION".
3098: ELSIF p_function_name = G_FN_NAME_CHANGE_STATUS THEN
3099: fnd_message.Set_Name(G_APP_NAME, 'EGO_NO_PRIV_CHANGE_STATUS');
3100: -- EGO_NO_PRIV_CHANGE_STATUS : User "USER" does not have privilege to change status of Item "ITEM" in Organization "ORGANIZATION".
3101: ELSIF p_function_name = G_FN_NAME_EDIT_LC_PROJ THEN
3102: fnd_message.set_name(G_APP_NAME, 'EGO_NO_PRIV_ITEM_PROJ_ASSOC');
3103: -- EGO_NO_PRIV_ITEM_PROJ_ASSOC : User "USER" does not have privilege to create, update or delete project associtions on Item "ITEM" in Organization "ORGANIZATION".

Line 3102: fnd_message.set_name(G_APP_NAME, 'EGO_NO_PRIV_ITEM_PROJ_ASSOC');

3098: ELSIF p_function_name = G_FN_NAME_CHANGE_STATUS THEN
3099: fnd_message.Set_Name(G_APP_NAME, 'EGO_NO_PRIV_CHANGE_STATUS');
3100: -- EGO_NO_PRIV_CHANGE_STATUS : User "USER" does not have privilege to change status of Item "ITEM" in Organization "ORGANIZATION".
3101: ELSIF p_function_name = G_FN_NAME_EDIT_LC_PROJ THEN
3102: fnd_message.set_name(G_APP_NAME, 'EGO_NO_PRIV_ITEM_PROJ_ASSOC');
3103: -- EGO_NO_PRIV_ITEM_PROJ_ASSOC : User "USER" does not have privilege to create, update or delete project associtions on Item "ITEM" in Organization "ORGANIZATION".
3104: END IF;
3105: IF l_owner_party_name IS NULL THEN
3106: OPEN c_user_party_name (cp_party_id => l_owner_party_id);

Line 3110: fnd_message.Set_Token('USER', l_owner_party_name);

3106: OPEN c_user_party_name (cp_party_id => l_owner_party_id);
3107: FETCH c_user_party_name INTO l_owner_party_name;
3108: CLOSE c_user_party_name;
3109: END IF;
3110: fnd_message.Set_Token('USER', l_owner_party_name);
3111: IF p_item_number IS NULL THEN
3112: SELECT concatenated_segments
3113: INTO l_dummy_char
3114: FROM mtl_system_items_b_kfv

Line 3121: fnd_message.Set_Token('ITEM', l_dummy_char);

3117: ELSE
3118: l_dummy_char := p_item_number;
3119: END IF;
3120: IF p_function_name = G_FN_NAME_ADD_ROLE THEN
3121: fnd_message.Set_Token('ITEM', l_dummy_char);
3122: ELSE
3123: fnd_message.Set_Token('ITEM_NUMBER', l_dummy_char);
3124: END IF;
3125: IF p_organization_name IS NULL THEN

Line 3123: fnd_message.Set_Token('ITEM_NUMBER', l_dummy_char);

3119: END IF;
3120: IF p_function_name = G_FN_NAME_ADD_ROLE THEN
3121: fnd_message.Set_Token('ITEM', l_dummy_char);
3122: ELSE
3123: fnd_message.Set_Token('ITEM_NUMBER', l_dummy_char);
3124: END IF;
3125: IF p_organization_name IS NULL THEN
3126: SELECT name
3127: INTO l_dummy_char

Line 3133: fnd_message.Set_Token('ORGANIZATION', l_dummy_char);

3129: WHERE organization_id = p_organization_id;
3130: ELSE
3131: l_dummy_char := p_organization_name;
3132: END IF;
3133: fnd_message.Set_Token('ORGANIZATION', l_dummy_char);
3134: fnd_msg_pub.Add;
3135: END IF;
3136: RETURN FALSE;
3137: ELSE

Line 3310: fnd_message.Set_Name(G_APP_NAME, G_INVALID_PARAMS_MSG);

3306: --
3307: -- inalid parameters passed
3308: --
3309: code_debug (l_api_version ||' invalid parameters passed ');
3310: fnd_message.Set_Name(G_APP_NAME, G_INVALID_PARAMS_MSG);
3311: fnd_message.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
3312: fnd_message.Set_Token(G_PROC_NAME_TOKEN, l_api_name);
3313: fnd_msg_pub.Add;
3314: RAISE FND_API.G_EXC_ERROR;

Line 3311: fnd_message.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);

3307: -- inalid parameters passed
3308: --
3309: code_debug (l_api_version ||' invalid parameters passed ');
3310: fnd_message.Set_Name(G_APP_NAME, G_INVALID_PARAMS_MSG);
3311: fnd_message.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
3312: fnd_message.Set_Token(G_PROC_NAME_TOKEN, l_api_name);
3313: fnd_msg_pub.Add;
3314: RAISE FND_API.G_EXC_ERROR;
3315: END IF;

Line 3312: fnd_message.Set_Token(G_PROC_NAME_TOKEN, l_api_name);

3308: --
3309: code_debug (l_api_version ||' invalid parameters passed ');
3310: fnd_message.Set_Name(G_APP_NAME, G_INVALID_PARAMS_MSG);
3311: fnd_message.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
3312: fnd_message.Set_Token(G_PROC_NAME_TOKEN, l_api_name);
3313: fnd_msg_pub.Add;
3314: RAISE FND_API.G_EXC_ERROR;
3315: END IF;
3316: code_debug(l_api_name||' valid params passed ' );

Line 3344: fnd_message.set_name (G_APP_NAME, 'EGO_NO_REC_UPDATE');

3340: EXCEPTION
3341: WHEN NO_DATA_FOUND THEN
3342: code_debug (l_api_version ||' no grant found for modification ');
3343: IF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE THEN
3344: fnd_message.set_name (G_APP_NAME, 'EGO_NO_REC_UPDATE');
3345: ELSE
3346: fnd_message.set_name (G_APP_NAME, 'EGO_NO_REC_DELETE');
3347: END IF;
3348: fnd_msg_pub.Add;

Line 3346: fnd_message.set_name (G_APP_NAME, 'EGO_NO_REC_DELETE');

3342: code_debug (l_api_version ||' no grant found for modification ');
3343: IF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE THEN
3344: fnd_message.set_name (G_APP_NAME, 'EGO_NO_REC_UPDATE');
3345: ELSE
3346: fnd_message.set_name (G_APP_NAME, 'EGO_NO_REC_DELETE');
3347: END IF;
3348: fnd_msg_pub.Add;
3349: RAISE FND_API.G_EXC_ERROR;
3350: END;

Line 3417: fnd_message.Set_Name(G_APP_NAME, 'EGO_GRANT_END_DATED');

3413: ,p_end_date => l_end_date
3414: ,p_validation_type => G_GT_VAL
3415: ) THEN
3416: code_debug (l_api_version ||' grant is already end dated ');
3417: fnd_message.Set_Name(G_APP_NAME, 'EGO_GRANT_END_DATED');
3418: fnd_msg_pub.Add;
3419: RAISE FND_API.G_EXC_ERROR;
3420: END IF;
3421: IF date_check (p_start_date => l_sysdate

Line 3426: fnd_message.Set_Name(G_APP_NAME, 'EGO_ENDDATE_LT_CURRDATE');

3422: ,p_end_date => p_end_date
3423: ,p_validation_type => G_GT_VAL
3424: ) THEN
3425: code_debug (l_api_version ||' end date less than sysdate ');
3426: fnd_message.Set_Name(G_APP_NAME, 'EGO_ENDDATE_LT_CURRDATE');
3427: fnd_msg_pub.Add;
3428: RAISE FND_API.G_EXC_ERROR;
3429: END IF;
3430: IF (p_start_date > l_sysdate and l_start_date > l_sysdate) THEN

Line 3444: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_OVERLAP_GRANT');

3440: );
3441: code_debug(l_api_name||' returning EGO_SECURITY_PUB.set_grant_date with status '||x_return_status );
3442: IF x_return_status = G_FALSE THEN
3443: code_debug (l_api_version ||' overlap grant found for update ');
3444: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_OVERLAP_GRANT');
3445: fnd_message.Set_Token('START_DATE', l_start_date);
3446: fnd_message.Set_Token('END_DATE', p_end_date);
3447: fnd_msg_pub.Add;
3448: RAISE FND_API.G_EXC_ERROR;

Line 3445: fnd_message.Set_Token('START_DATE', l_start_date);

3441: code_debug(l_api_name||' returning EGO_SECURITY_PUB.set_grant_date with status '||x_return_status );
3442: IF x_return_status = G_FALSE THEN
3443: code_debug (l_api_version ||' overlap grant found for update ');
3444: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_OVERLAP_GRANT');
3445: fnd_message.Set_Token('START_DATE', l_start_date);
3446: fnd_message.Set_Token('END_DATE', p_end_date);
3447: fnd_msg_pub.Add;
3448: RAISE FND_API.G_EXC_ERROR;
3449: ELSE

Line 3446: fnd_message.Set_Token('END_DATE', p_end_date);

3442: IF x_return_status = G_FALSE THEN
3443: code_debug (l_api_version ||' overlap grant found for update ');
3444: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_OVERLAP_GRANT');
3445: fnd_message.Set_Token('START_DATE', l_start_date);
3446: fnd_message.Set_Token('END_DATE', p_end_date);
3447: fnd_msg_pub.Add;
3448: RAISE FND_API.G_EXC_ERROR;
3449: ELSE
3450: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3472: fnd_message.Set_Name(G_APP_NAME, 'EGO_USER');

3468: ) THEN
3469: code_debug (l_api_version ||' invalid party passed ');
3470: l_create_grant_flag := FALSE;
3471: IF p_party_type = EGO_ITEM_PUB.G_USER_PARTY_TYPE THEN
3472: fnd_message.Set_Name(G_APP_NAME, 'EGO_USER');
3473: l_dummy_char := fnd_message.get();
3474: ELSIF p_party_type = EGO_ITEM_PUB.G_GROUP_PARTY_TYPE THEN
3475: fnd_message.Set_Name(G_APP_NAME, 'EGO_GROUP_NAME');
3476: l_dummy_char := fnd_message.get();

Line 3473: l_dummy_char := fnd_message.get();

3469: code_debug (l_api_version ||' invalid party passed ');
3470: l_create_grant_flag := FALSE;
3471: IF p_party_type = EGO_ITEM_PUB.G_USER_PARTY_TYPE THEN
3472: fnd_message.Set_Name(G_APP_NAME, 'EGO_USER');
3473: l_dummy_char := fnd_message.get();
3474: ELSIF p_party_type = EGO_ITEM_PUB.G_GROUP_PARTY_TYPE THEN
3475: fnd_message.Set_Name(G_APP_NAME, 'EGO_GROUP_NAME');
3476: l_dummy_char := fnd_message.get();
3477: ELSIF p_party_type = EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE THEN

Line 3475: fnd_message.Set_Name(G_APP_NAME, 'EGO_GROUP_NAME');

3471: IF p_party_type = EGO_ITEM_PUB.G_USER_PARTY_TYPE THEN
3472: fnd_message.Set_Name(G_APP_NAME, 'EGO_USER');
3473: l_dummy_char := fnd_message.get();
3474: ELSIF p_party_type = EGO_ITEM_PUB.G_GROUP_PARTY_TYPE THEN
3475: fnd_message.Set_Name(G_APP_NAME, 'EGO_GROUP_NAME');
3476: l_dummy_char := fnd_message.get();
3477: ELSIF p_party_type = EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE THEN
3478: fnd_message.Set_Name(G_APP_NAME, 'EGO_COMPANY');
3479: l_dummy_char := fnd_message.get();

Line 3476: l_dummy_char := fnd_message.get();

3472: fnd_message.Set_Name(G_APP_NAME, 'EGO_USER');
3473: l_dummy_char := fnd_message.get();
3474: ELSIF p_party_type = EGO_ITEM_PUB.G_GROUP_PARTY_TYPE THEN
3475: fnd_message.Set_Name(G_APP_NAME, 'EGO_GROUP_NAME');
3476: l_dummy_char := fnd_message.get();
3477: ELSIF p_party_type = EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE THEN
3478: fnd_message.Set_Name(G_APP_NAME, 'EGO_COMPANY');
3479: l_dummy_char := fnd_message.get();
3480: END IF;

Line 3478: fnd_message.Set_Name(G_APP_NAME, 'EGO_COMPANY');

3474: ELSIF p_party_type = EGO_ITEM_PUB.G_GROUP_PARTY_TYPE THEN
3475: fnd_message.Set_Name(G_APP_NAME, 'EGO_GROUP_NAME');
3476: l_dummy_char := fnd_message.get();
3477: ELSIF p_party_type = EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE THEN
3478: fnd_message.Set_Name(G_APP_NAME, 'EGO_COMPANY');
3479: l_dummy_char := fnd_message.get();
3480: END IF;
3481: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');
3482: fnd_message.Set_Token('NAME', l_dummy_char);

Line 3479: l_dummy_char := fnd_message.get();

3475: fnd_message.Set_Name(G_APP_NAME, 'EGO_GROUP_NAME');
3476: l_dummy_char := fnd_message.get();
3477: ELSIF p_party_type = EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE THEN
3478: fnd_message.Set_Name(G_APP_NAME, 'EGO_COMPANY');
3479: l_dummy_char := fnd_message.get();
3480: END IF;
3481: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');
3482: fnd_message.Set_Token('NAME', l_dummy_char);
3483: IF l_party_id IS NOT NULL THEN

Line 3481: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');

3477: ELSIF p_party_type = EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE THEN
3478: fnd_message.Set_Name(G_APP_NAME, 'EGO_COMPANY');
3479: l_dummy_char := fnd_message.get();
3480: END IF;
3481: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');
3482: fnd_message.Set_Token('NAME', l_dummy_char);
3483: IF l_party_id IS NOT NULL THEN
3484: fnd_message.Set_Token('VALUE', l_party_id);
3485: ELSE

Line 3482: fnd_message.Set_Token('NAME', l_dummy_char);

3478: fnd_message.Set_Name(G_APP_NAME, 'EGO_COMPANY');
3479: l_dummy_char := fnd_message.get();
3480: END IF;
3481: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');
3482: fnd_message.Set_Token('NAME', l_dummy_char);
3483: IF l_party_id IS NOT NULL THEN
3484: fnd_message.Set_Token('VALUE', l_party_id);
3485: ELSE
3486: fnd_message.Set_Token('VALUE', l_party_name);

Line 3484: fnd_message.Set_Token('VALUE', l_party_id);

3480: END IF;
3481: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');
3482: fnd_message.Set_Token('NAME', l_dummy_char);
3483: IF l_party_id IS NOT NULL THEN
3484: fnd_message.Set_Token('VALUE', l_party_id);
3485: ELSE
3486: fnd_message.Set_Token('VALUE', l_party_name);
3487: END IF;
3488: fnd_msg_pub.Add;

Line 3486: fnd_message.Set_Token('VALUE', l_party_name);

3482: fnd_message.Set_Token('NAME', l_dummy_char);
3483: IF l_party_id IS NOT NULL THEN
3484: fnd_message.Set_Token('VALUE', l_party_id);
3485: ELSE
3486: fnd_message.Set_Token('VALUE', l_party_name);
3487: END IF;
3488: fnd_msg_pub.Add;
3489: END IF;
3490: code_debug(l_api_name||' validate party done ');

Line 3501: fnd_message.Set_Name(G_APP_NAME, 'EGO_ROLE');

3497: ,p_menu_type => 'SECURITY'
3498: ) THEN
3499: code_debug (l_api_version ||' invalid menu passed ');
3500: l_create_grant_flag := FALSE;
3501: fnd_message.Set_Name(G_APP_NAME, 'EGO_ROLE');
3502: l_dummy_char := fnd_message.get();
3503: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');
3504: fnd_message.Set_Token('NAME', l_dummy_char);
3505: IF l_role_id IS NOT NULL THEN

Line 3502: l_dummy_char := fnd_message.get();

3498: ) THEN
3499: code_debug (l_api_version ||' invalid menu passed ');
3500: l_create_grant_flag := FALSE;
3501: fnd_message.Set_Name(G_APP_NAME, 'EGO_ROLE');
3502: l_dummy_char := fnd_message.get();
3503: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');
3504: fnd_message.Set_Token('NAME', l_dummy_char);
3505: IF l_role_id IS NOT NULL THEN
3506: fnd_message.Set_Token('VALUE', l_role_id);

Line 3503: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');

3499: code_debug (l_api_version ||' invalid menu passed ');
3500: l_create_grant_flag := FALSE;
3501: fnd_message.Set_Name(G_APP_NAME, 'EGO_ROLE');
3502: l_dummy_char := fnd_message.get();
3503: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');
3504: fnd_message.Set_Token('NAME', l_dummy_char);
3505: IF l_role_id IS NOT NULL THEN
3506: fnd_message.Set_Token('VALUE', l_role_id);
3507: ELSE

Line 3504: fnd_message.Set_Token('NAME', l_dummy_char);

3500: l_create_grant_flag := FALSE;
3501: fnd_message.Set_Name(G_APP_NAME, 'EGO_ROLE');
3502: l_dummy_char := fnd_message.get();
3503: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');
3504: fnd_message.Set_Token('NAME', l_dummy_char);
3505: IF l_role_id IS NOT NULL THEN
3506: fnd_message.Set_Token('VALUE', l_role_id);
3507: ELSE
3508: fnd_message.Set_Token('VALUE', p_role_name);

Line 3506: fnd_message.Set_Token('VALUE', l_role_id);

3502: l_dummy_char := fnd_message.get();
3503: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');
3504: fnd_message.Set_Token('NAME', l_dummy_char);
3505: IF l_role_id IS NOT NULL THEN
3506: fnd_message.Set_Token('VALUE', l_role_id);
3507: ELSE
3508: fnd_message.Set_Token('VALUE', p_role_name);
3509: END IF;
3510: fnd_msg_pub.Add;

Line 3508: fnd_message.Set_Token('VALUE', p_role_name);

3504: fnd_message.Set_Token('NAME', l_dummy_char);
3505: IF l_role_id IS NOT NULL THEN
3506: fnd_message.Set_Token('VALUE', l_role_id);
3507: ELSE
3508: fnd_message.Set_Token('VALUE', p_role_name);
3509: END IF;
3510: fnd_msg_pub.Add;
3511: END IF;
3512: code_debug(l_api_name||' validate menu done ');

Line 3522: fnd_message.Set_Name(G_APP_NAME, 'EGO_INVALID_GRANT_START_DATE');

3518: ,p_validation_type => G_LT_VAL
3519: ) THEN
3520: code_debug (l_api_version ||' start date less than sysdate ');
3521: l_create_grant_flag := FALSE;
3522: fnd_message.Set_Name(G_APP_NAME, 'EGO_INVALID_GRANT_START_DATE');
3523: fnd_msg_pub.Add;
3524: END IF;
3525: IF date_check (p_start_date => l_sysdate
3526: ,p_end_date => p_end_date

Line 3531: fnd_message.Set_Name(G_APP_NAME, 'EGO_ENDDATE_LT_CURRDATE');

3527: ,p_validation_type => G_GT_VAL
3528: ) THEN
3529: code_debug (l_api_version ||' end date less than sysdate ');
3530: l_create_grant_flag := FALSE;
3531: fnd_message.Set_Name(G_APP_NAME, 'EGO_ENDDATE_LT_CURRDATE');
3532: fnd_msg_pub.Add;
3533: END IF;
3534: IF date_check (p_start_date => l_start_date
3535: ,p_end_date => p_end_date

Line 3540: fnd_message.Set_Name(G_APP_NAME, 'EGO_ENDDATE_EXCEEDS_STARTDATE');

3536: ,p_validation_type => G_GT_VAL
3537: ) THEN
3538: code_debug (l_api_version ||' end date less than startdate ');
3539: l_create_grant_flag := FALSE;
3540: fnd_message.Set_Name(G_APP_NAME, 'EGO_ENDDATE_EXCEEDS_STARTDATE');
3541: fnd_msg_pub.Add;
3542: END IF;
3543: code_debug(l_api_name||' validate date done ');
3544:

Line 3554: fnd_message.Set_Name(G_APP_NAME, 'EGO_INSTANCE');

3550: ,p_set_disp_name => p_instance_set_name
3551: ) THEN
3552: code_debug (l_api_version ||' invalid instance set ');
3553: l_create_grant_flag := FALSE;
3554: fnd_message.Set_Name(G_APP_NAME, 'EGO_INSTANCE');
3555: l_dummy_char := fnd_message.get();
3556: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');
3557: fnd_message.Set_Token('NAME', l_dummy_char);
3558: IF l_instance_set_id IS NOT NULL THEN

Line 3555: l_dummy_char := fnd_message.get();

3551: ) THEN
3552: code_debug (l_api_version ||' invalid instance set ');
3553: l_create_grant_flag := FALSE;
3554: fnd_message.Set_Name(G_APP_NAME, 'EGO_INSTANCE');
3555: l_dummy_char := fnd_message.get();
3556: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');
3557: fnd_message.Set_Token('NAME', l_dummy_char);
3558: IF l_instance_set_id IS NOT NULL THEN
3559: fnd_message.Set_Token('VALUE', l_instance_set_id);

Line 3556: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');

3552: code_debug (l_api_version ||' invalid instance set ');
3553: l_create_grant_flag := FALSE;
3554: fnd_message.Set_Name(G_APP_NAME, 'EGO_INSTANCE');
3555: l_dummy_char := fnd_message.get();
3556: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');
3557: fnd_message.Set_Token('NAME', l_dummy_char);
3558: IF l_instance_set_id IS NOT NULL THEN
3559: fnd_message.Set_Token('VALUE', l_instance_set_id);
3560: ELSE

Line 3557: fnd_message.Set_Token('NAME', l_dummy_char);

3553: l_create_grant_flag := FALSE;
3554: fnd_message.Set_Name(G_APP_NAME, 'EGO_INSTANCE');
3555: l_dummy_char := fnd_message.get();
3556: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');
3557: fnd_message.Set_Token('NAME', l_dummy_char);
3558: IF l_instance_set_id IS NOT NULL THEN
3559: fnd_message.Set_Token('VALUE', l_instance_set_id);
3560: ELSE
3561: fnd_message.Set_Token('VALUE', p_instance_set_name);

Line 3559: fnd_message.Set_Token('VALUE', l_instance_set_id);

3555: l_dummy_char := fnd_message.get();
3556: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');
3557: fnd_message.Set_Token('NAME', l_dummy_char);
3558: IF l_instance_set_id IS NOT NULL THEN
3559: fnd_message.Set_Token('VALUE', l_instance_set_id);
3560: ELSE
3561: fnd_message.Set_Token('VALUE', p_instance_set_name);
3562: END IF;
3563: fnd_msg_pub.Add;

Line 3561: fnd_message.Set_Token('VALUE', p_instance_set_name);

3557: fnd_message.Set_Token('NAME', l_dummy_char);
3558: IF l_instance_set_id IS NOT NULL THEN
3559: fnd_message.Set_Token('VALUE', l_instance_set_id);
3560: ELSE
3561: fnd_message.Set_Token('VALUE', p_instance_set_name);
3562: END IF;
3563: fnd_msg_pub.Add;
3564: END IF;
3565: code_debug(l_api_name||' validate instance done ');

Line 3641: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_OVERLAP_GRANT');

3637: );
3638: code_debug(l_api_name||' returning EGO_SECURITY_PUB.grant_role_guid with status '||x_return_status);
3639: IF x_return_status = G_FALSE THEN
3640: code_debug (l_api_version ||' grant overlap when creating new grant ');
3641: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_OVERLAP_GRANT');
3642: fnd_message.Set_Token('START_DATE', l_start_date);
3643: fnd_message.Set_Token('END_DATE', p_end_date);
3644: fnd_msg_pub.Add;
3645: RAISE FND_API.G_EXC_ERROR;

Line 3642: fnd_message.Set_Token('START_DATE', l_start_date);

3638: code_debug(l_api_name||' returning EGO_SECURITY_PUB.grant_role_guid with status '||x_return_status);
3639: IF x_return_status = G_FALSE THEN
3640: code_debug (l_api_version ||' grant overlap when creating new grant ');
3641: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_OVERLAP_GRANT');
3642: fnd_message.Set_Token('START_DATE', l_start_date);
3643: fnd_message.Set_Token('END_DATE', p_end_date);
3644: fnd_msg_pub.Add;
3645: RAISE FND_API.G_EXC_ERROR;
3646: ELSE

Line 3643: fnd_message.Set_Token('END_DATE', p_end_date);

3639: IF x_return_status = G_FALSE THEN
3640: code_debug (l_api_version ||' grant overlap when creating new grant ');
3641: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_OVERLAP_GRANT');
3642: fnd_message.Set_Token('START_DATE', l_start_date);
3643: fnd_message.Set_Token('END_DATE', p_end_date);
3644: fnd_msg_pub.Add;
3645: RAISE FND_API.G_EXC_ERROR;
3646: ELSE
3647: -- changing return status to FND_API.G_RET_STS_SUCCESS

Line 3677: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);

3673: IF FND_API.To_Boolean( p_commit ) THEN
3674: ROLLBACK TO PROCESS_ITEM_ROLE_SP;
3675: END IF;
3676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3677: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
3678: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
3679: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
3680: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
3681: FND_MSG_PUB.Add;

Line 3678: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);

3674: ROLLBACK TO PROCESS_ITEM_ROLE_SP;
3675: END IF;
3676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3677: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
3678: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
3679: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
3680: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
3681: FND_MSG_PUB.Add;
3682: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 3679: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);

3675: END IF;
3676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3677: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
3678: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
3679: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
3680: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
3681: FND_MSG_PUB.Add;
3682: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
3683: ,p_count => x_msg_count

Line 3680: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);

3676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3677: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
3678: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
3679: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
3680: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
3681: FND_MSG_PUB.Add;
3682: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
3683: ,p_count => x_msg_count
3684: ,p_data => x_msg_data);

Line 3864: fnd_message.Set_Name(G_APP_NAME, G_INVALID_PARAMS_MSG);

3860: --
3861: -- inalid parameters passed
3862: --
3863: code_debug (l_api_version ||' invalid parameters passed ');
3864: fnd_message.Set_Name(G_APP_NAME, G_INVALID_PARAMS_MSG);
3865: fnd_message.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
3866: fnd_message.Set_Token(G_PROC_NAME_TOKEN, l_api_name);
3867: FND_MSG_PUB.Add;
3868: RAISE FND_API.G_EXC_ERROR;

Line 3865: fnd_message.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);

3861: -- inalid parameters passed
3862: --
3863: code_debug (l_api_version ||' invalid parameters passed ');
3864: fnd_message.Set_Name(G_APP_NAME, G_INVALID_PARAMS_MSG);
3865: fnd_message.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
3866: fnd_message.Set_Token(G_PROC_NAME_TOKEN, l_api_name);
3867: FND_MSG_PUB.Add;
3868: RAISE FND_API.G_EXC_ERROR;
3869: END IF;

Line 3866: fnd_message.Set_Token(G_PROC_NAME_TOKEN, l_api_name);

3862: --
3863: code_debug (l_api_version ||' invalid parameters passed ');
3864: fnd_message.Set_Name(G_APP_NAME, G_INVALID_PARAMS_MSG);
3865: fnd_message.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
3866: fnd_message.Set_Token(G_PROC_NAME_TOKEN, l_api_name);
3867: FND_MSG_PUB.Add;
3868: RAISE FND_API.G_EXC_ERROR;
3869: END IF;
3870: l_change_status_flag := TRUE;

Line 3892: fnd_message.Set_Name(G_APP_NAME, 'EGO_ITEM_INVALID_EFFCT_DATE');

3888: ,p_validation_type => G_LT_VAL
3889: ) THEN
3890: code_debug (l_api_name ||' effective date is less than system date ');
3891: l_change_status_flag := FALSE;
3892: fnd_message.Set_Name(G_APP_NAME, 'EGO_ITEM_INVALID_EFFCT_DATE');
3893: fnd_msg_pub.Add;
3894: ELSE
3895: code_debug (l_api_name ||' effective date is valid ');
3896: END IF;

Line 3929: fnd_message.Set_Name(G_APP_NAME, 'EGO_ITEM_NOT_APPROVED');

3925: -- item is not approved no operations permitted
3926: --
3927: code_debug (l_api_name ||' unapproved item ');
3928: l_change_status_flag := FALSE;
3929: fnd_message.Set_Name(G_APP_NAME, 'EGO_ITEM_NOT_APPROVED');
3930: fnd_msg_pub.Add;
3931: ELSE
3932: IF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_PROMOTE THEN
3933: l_priv_function_name := G_FN_NAME_PROMOTE;

Line 3997: fnd_message.Set_Name(G_APP_NAME, 'EGO_ITEM_NO_LC_FOR_CHANGE');

3993: ) THEN
3994: l_change_status_flag := FALSE;
3995: code_debug (l_api_name ||' no lifecycle associated to item / revision ');
3996: IF l_revision_id IS NULL THEN
3997: fnd_message.Set_Name(G_APP_NAME, 'EGO_ITEM_NO_LC_FOR_CHANGE');
3998: ELSE
3999: fnd_message.Set_Name(G_APP_NAME, 'EGO_REV_NO_LC_FOR_CHANGE');
4000: END IF;
4001: fnd_msg_pub.Add;

Line 3999: fnd_message.Set_Name(G_APP_NAME, 'EGO_REV_NO_LC_FOR_CHANGE');

3995: code_debug (l_api_name ||' no lifecycle associated to item / revision ');
3996: IF l_revision_id IS NULL THEN
3997: fnd_message.Set_Name(G_APP_NAME, 'EGO_ITEM_NO_LC_FOR_CHANGE');
3998: ELSE
3999: fnd_message.Set_Name(G_APP_NAME, 'EGO_REV_NO_LC_FOR_CHANGE');
4000: END IF;
4001: fnd_msg_pub.Add;
4002: END IF;
4003: END IF; -- approval status

Line 4026: fnd_message.Set_Name(G_APP_NAME,'EGO_ITEM_REV_LC_PROJ_EXISTS');

4022: ,p_revision => l_revision) THEN
4023: code_debug (l_api_name ||' lc project associated to item / revision ');
4024: l_change_status_flag := FALSE;
4025: IF l_revision IS NOT NULL THEN
4026: fnd_message.Set_Name(G_APP_NAME,'EGO_ITEM_REV_LC_PROJ_EXISTS');
4027: fnd_message.set_token('REVISION', l_revision);
4028: ELSE
4029: fnd_message.Set_Name(G_APP_NAME,'ITEM_LC_PROJ_EXISTS');
4030: END IF;

Line 4027: fnd_message.set_token('REVISION', l_revision);

4023: code_debug (l_api_name ||' lc project associated to item / revision ');
4024: l_change_status_flag := FALSE;
4025: IF l_revision IS NOT NULL THEN
4026: fnd_message.Set_Name(G_APP_NAME,'EGO_ITEM_REV_LC_PROJ_EXISTS');
4027: fnd_message.set_token('REVISION', l_revision);
4028: ELSE
4029: fnd_message.Set_Name(G_APP_NAME,'ITEM_LC_PROJ_EXISTS');
4030: END IF;
4031: fnd_message.set_token('ITEM_NUMBER', l_item_number);

Line 4029: fnd_message.Set_Name(G_APP_NAME,'ITEM_LC_PROJ_EXISTS');

4025: IF l_revision IS NOT NULL THEN
4026: fnd_message.Set_Name(G_APP_NAME,'EGO_ITEM_REV_LC_PROJ_EXISTS');
4027: fnd_message.set_token('REVISION', l_revision);
4028: ELSE
4029: fnd_message.Set_Name(G_APP_NAME,'ITEM_LC_PROJ_EXISTS');
4030: END IF;
4031: fnd_message.set_token('ITEM_NUMBER', l_item_number);
4032: fnd_message.set_token('ORG_NAME', l_org_name);
4033: fnd_msg_pub.Add;

Line 4031: fnd_message.set_token('ITEM_NUMBER', l_item_number);

4027: fnd_message.set_token('REVISION', l_revision);
4028: ELSE
4029: fnd_message.Set_Name(G_APP_NAME,'ITEM_LC_PROJ_EXISTS');
4030: END IF;
4031: fnd_message.set_token('ITEM_NUMBER', l_item_number);
4032: fnd_message.set_token('ORG_NAME', l_org_name);
4033: fnd_msg_pub.Add;
4034: END IF;
4035:

Line 4032: fnd_message.set_token('ORG_NAME', l_org_name);

4028: ELSE
4029: fnd_message.Set_Name(G_APP_NAME,'ITEM_LC_PROJ_EXISTS');
4030: END IF;
4031: fnd_message.set_token('ITEM_NUMBER', l_item_number);
4032: fnd_message.set_token('ORG_NAME', l_org_name);
4033: fnd_msg_pub.Add;
4034: END IF;
4035:
4036: IF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_PROMOTE THEN

Line 4045: fnd_message.Set_Name(G_APP_NAME,'EGO_ITEM_CANNOT_PROMOTE');

4041: IF c_get_next_phase%NOTFOUND THEN
4042: CLOSE c_get_next_phase;
4043: code_debug (l_api_name ||' no phase to promote ');
4044: l_change_status_flag := FALSE;
4045: fnd_message.Set_Name(G_APP_NAME,'EGO_ITEM_CANNOT_PROMOTE');
4046: l_dummy_char := get_lifecycle_name (p_lc_phase_type => 'LIFECYCLE'
4047: ,p_proj_element_id => l_curr_lifecycle_id);
4048: fnd_message.set_token('LIFE_CYCLE', l_dummy_char);
4049: l_dummy_char := get_lifecycle_name (p_lc_phase_type => 'PHASE'

Line 4048: fnd_message.set_token('LIFE_CYCLE', l_dummy_char);

4044: l_change_status_flag := FALSE;
4045: fnd_message.Set_Name(G_APP_NAME,'EGO_ITEM_CANNOT_PROMOTE');
4046: l_dummy_char := get_lifecycle_name (p_lc_phase_type => 'LIFECYCLE'
4047: ,p_proj_element_id => l_curr_lifecycle_id);
4048: fnd_message.set_token('LIFE_CYCLE', l_dummy_char);
4049: l_dummy_char := get_lifecycle_name (p_lc_phase_type => 'PHASE'
4050: ,p_proj_element_id => l_curr_phase_id);
4051: fnd_message.set_token('PHASE', l_dummy_char);
4052: fnd_msg_pub.Add;

Line 4051: fnd_message.set_token('PHASE', l_dummy_char);

4047: ,p_proj_element_id => l_curr_lifecycle_id);
4048: fnd_message.set_token('LIFE_CYCLE', l_dummy_char);
4049: l_dummy_char := get_lifecycle_name (p_lc_phase_type => 'PHASE'
4050: ,p_proj_element_id => l_curr_phase_id);
4051: fnd_message.set_token('PHASE', l_dummy_char);
4052: fnd_msg_pub.Add;
4053: ELSE
4054: CLOSE c_get_next_phase;
4055: END IF;

Line 4065: fnd_message.Set_Name(G_APP_NAME,'EGO_ITEM_CANNOT_DEMOTE');

4061: IF c_get_priv_phase%NOTFOUND THEN
4062: CLOSE c_get_priv_phase;
4063: code_debug (l_api_name ||' no phase to demote ');
4064: l_change_status_flag := FALSE;
4065: fnd_message.Set_Name(G_APP_NAME,'EGO_ITEM_CANNOT_DEMOTE');
4066: l_dummy_char := get_lifecycle_name (p_lc_phase_type => 'LIFECYCLE'
4067: ,p_proj_element_id => l_curr_lifecycle_id);
4068: fnd_message.set_token('LIFE_CYCLE', l_dummy_char);
4069: l_dummy_char := get_lifecycle_name (p_lc_phase_type => 'PHASE'

Line 4068: fnd_message.set_token('LIFE_CYCLE', l_dummy_char);

4064: l_change_status_flag := FALSE;
4065: fnd_message.Set_Name(G_APP_NAME,'EGO_ITEM_CANNOT_DEMOTE');
4066: l_dummy_char := get_lifecycle_name (p_lc_phase_type => 'LIFECYCLE'
4067: ,p_proj_element_id => l_curr_lifecycle_id);
4068: fnd_message.set_token('LIFE_CYCLE', l_dummy_char);
4069: l_dummy_char := get_lifecycle_name (p_lc_phase_type => 'PHASE'
4070: ,p_proj_element_id => l_curr_phase_id);
4071: fnd_message.set_token('PHASE', l_dummy_char);
4072: fnd_msg_pub.Add;

Line 4071: fnd_message.set_token('PHASE', l_dummy_char);

4067: ,p_proj_element_id => l_curr_lifecycle_id);
4068: fnd_message.set_token('LIFE_CYCLE', l_dummy_char);
4069: l_dummy_char := get_lifecycle_name (p_lc_phase_type => 'PHASE'
4070: ,p_proj_element_id => l_curr_phase_id);
4071: fnd_message.set_token('PHASE', l_dummy_char);
4072: fnd_msg_pub.Add;
4073: fnd_msg_pub.Add;
4074: ELSE
4075: CLOSE c_get_priv_phase;

Line 4118: fnd_message.Set_Name(G_APP_NAME,l_error_message);

4114: ELSE
4115: l_error_message := 'EGO_ITEM_REV_NO_DEMOTE';
4116: END IF;
4117: END IF;
4118: fnd_message.Set_Name(G_APP_NAME,l_error_message);
4119: fnd_message.set_token('ITEM_NUMBER', l_item_number);
4120: IF l_revision_id IS NOT NULL THEN
4121: fnd_message.set_token('REVISION', l_revision);
4122: END IF;

Line 4119: fnd_message.set_token('ITEM_NUMBER', l_item_number);

4115: l_error_message := 'EGO_ITEM_REV_NO_DEMOTE';
4116: END IF;
4117: END IF;
4118: fnd_message.Set_Name(G_APP_NAME,l_error_message);
4119: fnd_message.set_token('ITEM_NUMBER', l_item_number);
4120: IF l_revision_id IS NOT NULL THEN
4121: fnd_message.set_token('REVISION', l_revision);
4122: END IF;
4123: l_dummy_char := get_lifecycle_name (p_lc_phase_type => 'LIFECYCLE'

Line 4121: fnd_message.set_token('REVISION', l_revision);

4117: END IF;
4118: fnd_message.Set_Name(G_APP_NAME,l_error_message);
4119: fnd_message.set_token('ITEM_NUMBER', l_item_number);
4120: IF l_revision_id IS NOT NULL THEN
4121: fnd_message.set_token('REVISION', l_revision);
4122: END IF;
4123: l_dummy_char := get_lifecycle_name (p_lc_phase_type => 'LIFECYCLE'
4124: ,p_proj_element_id => l_curr_lifecycle_id);
4125: fnd_message.set_token('LIFE_CYCLE', l_dummy_char);

Line 4125: fnd_message.set_token('LIFE_CYCLE', l_dummy_char);

4121: fnd_message.set_token('REVISION', l_revision);
4122: END IF;
4123: l_dummy_char := get_lifecycle_name (p_lc_phase_type => 'LIFECYCLE'
4124: ,p_proj_element_id => l_curr_lifecycle_id);
4125: fnd_message.set_token('LIFE_CYCLE', l_dummy_char);
4126: l_dummy_char := get_lifecycle_name (p_lc_phase_type => 'PHASE'
4127: ,p_proj_element_id => l_curr_phase_id);
4128: fnd_message.set_token('PHASE', l_dummy_char);
4129: SELECT concatenated_segments

Line 4128: fnd_message.set_token('PHASE', l_dummy_char);

4124: ,p_proj_element_id => l_curr_lifecycle_id);
4125: fnd_message.set_token('LIFE_CYCLE', l_dummy_char);
4126: l_dummy_char := get_lifecycle_name (p_lc_phase_type => 'PHASE'
4127: ,p_proj_element_id => l_curr_phase_id);
4128: fnd_message.set_token('PHASE', l_dummy_char);
4129: SELECT concatenated_segments
4130: INTO l_dummy_char
4131: FROM MTL_ITEM_CATALOG_GROUPS_KFV
4132: WHERE ITEM_CATALOG_GROUP_ID = (

Line 4149: fnd_message.set_token('CATALOG_CATEGORY_NAME', l_dummy_char);

4145: START WITH item_catalog_group_id = l_curr_cc_id
4146: ) CAT_HIER
4147: WHERE ROWNUM = 1
4148: );
4149: fnd_message.set_token('CATALOG_CATEGORY_NAME', l_dummy_char);
4150: fnd_msg_pub.Add;
4151: END IF;
4152: ELSIF p_transaction_type IN (EGO_ITEM_PUB.G_TTYPE_UPDATE, EGO_ITEM_PUB.G_TTYPE_DELETE) THEN
4153: -- check if the user has privilege to update the item.

Line 4191: fnd_message.Set_Name(G_APP_NAME,l_error_message);

4187: ,p_set_message => G_TRUE
4188: ) THEN
4189: code_debug(l_api_name ||' user does not have privilege to update the existing change '||p_transaction_type);
4190: l_change_status_flag := FALSE;
4191: fnd_message.Set_Name(G_APP_NAME,l_error_message);
4192: fnd_message.set_token('USER', FND_GLOBAL.USER_NAME);
4193: fnd_message.set_token('ITEM_NUMBER', l_item_number);
4194: fnd_message.set_token('ORGANIZATION', l_org_name);
4195: fnd_msg_pub.Add;

Line 4192: fnd_message.set_token('USER', FND_GLOBAL.USER_NAME);

4188: ) THEN
4189: code_debug(l_api_name ||' user does not have privilege to update the existing change '||p_transaction_type);
4190: l_change_status_flag := FALSE;
4191: fnd_message.Set_Name(G_APP_NAME,l_error_message);
4192: fnd_message.set_token('USER', FND_GLOBAL.USER_NAME);
4193: fnd_message.set_token('ITEM_NUMBER', l_item_number);
4194: fnd_message.set_token('ORGANIZATION', l_org_name);
4195: fnd_msg_pub.Add;
4196: END IF;

Line 4193: fnd_message.set_token('ITEM_NUMBER', l_item_number);

4189: code_debug(l_api_name ||' user does not have privilege to update the existing change '||p_transaction_type);
4190: l_change_status_flag := FALSE;
4191: fnd_message.Set_Name(G_APP_NAME,l_error_message);
4192: fnd_message.set_token('USER', FND_GLOBAL.USER_NAME);
4193: fnd_message.set_token('ITEM_NUMBER', l_item_number);
4194: fnd_message.set_token('ORGANIZATION', l_org_name);
4195: fnd_msg_pub.Add;
4196: END IF;
4197: END IF;

Line 4194: fnd_message.set_token('ORGANIZATION', l_org_name);

4190: l_change_status_flag := FALSE;
4191: fnd_message.Set_Name(G_APP_NAME,l_error_message);
4192: fnd_message.set_token('USER', FND_GLOBAL.USER_NAME);
4193: fnd_message.set_token('ITEM_NUMBER', l_item_number);
4194: fnd_message.set_token('ORGANIZATION', l_org_name);
4195: fnd_msg_pub.Add;
4196: END IF;
4197: END IF;
4198:

Line 4274: fnd_message.Set_Name(G_APP_NAME,'EGO_GENERIC_MSG_TEXT');

4270: -- this will occur only in case of exception
4271: -- all valid values are passed.
4272: --
4273: IF x_msg_count = 1 THEN
4274: fnd_message.Set_Name(G_APP_NAME,'EGO_GENERIC_MSG_TEXT');
4275: fnd_message.set_token('MESSAGE', x_msg_data);
4276: fnd_msg_pub.Add;
4277: END IF;
4278: RAISE FND_API.G_EXC_ERROR;

Line 4275: fnd_message.set_token('MESSAGE', x_msg_data);

4271: -- all valid values are passed.
4272: --
4273: IF x_msg_count = 1 THEN
4274: fnd_message.Set_Name(G_APP_NAME,'EGO_GENERIC_MSG_TEXT');
4275: fnd_message.set_token('MESSAGE', x_msg_data);
4276: fnd_msg_pub.Add;
4277: END IF;
4278: RAISE FND_API.G_EXC_ERROR;
4279: ELSIF FND_API.To_Boolean(p_implement_changes) THEN

Line 4302: fnd_message.Set_Name(G_APP_NAME,'EGO_GENERIC_MSG_TEXT');

4298: code_debug (l_api_name ||' return status from ego_item_lc_imp_pc_pub.Implement_Pending_Changes '||x_return_status);
4299: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4300: code_debug (l_api_name ||' cannot implement changes '||x_msg_data);
4301: IF x_msg_count = 1 THEN
4302: fnd_message.Set_Name(G_APP_NAME,'EGO_GENERIC_MSG_TEXT');
4303: fnd_message.set_token('MESSAGE', x_msg_data);
4304: fnd_msg_pub.Add;
4305: END IF;
4306: RAISE FND_API.G_EXC_ERROR;

Line 4303: fnd_message.set_token('MESSAGE', x_msg_data);

4299: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4300: code_debug (l_api_name ||' cannot implement changes '||x_msg_data);
4301: IF x_msg_count = 1 THEN
4302: fnd_message.Set_Name(G_APP_NAME,'EGO_GENERIC_MSG_TEXT');
4303: fnd_message.set_token('MESSAGE', x_msg_data);
4304: fnd_msg_pub.Add;
4305: END IF;
4306: RAISE FND_API.G_EXC_ERROR;
4307: END IF;

Line 4349: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);

4345: END IF;
4346: IF c_get_priv_phase%ISOPEN THEN
4347: CLOSE c_get_priv_phase;
4348: END IF;
4349: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
4350: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
4351: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
4352: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
4353: FND_MSG_PUB.Add;

Line 4350: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);

4346: IF c_get_priv_phase%ISOPEN THEN
4347: CLOSE c_get_priv_phase;
4348: END IF;
4349: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
4350: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
4351: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
4352: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
4353: FND_MSG_PUB.Add;
4354: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 4351: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);

4347: CLOSE c_get_priv_phase;
4348: END IF;
4349: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
4350: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
4351: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
4352: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
4353: FND_MSG_PUB.Add;
4354: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
4355: ,p_count => x_msg_count

Line 4352: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);

4348: END IF;
4349: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
4350: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
4351: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
4352: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
4353: FND_MSG_PUB.Add;
4354: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
4355: ,p_count => x_msg_count
4356: ,p_data => x_msg_data);

Line 4435: fnd_message.Set_Name(G_APP_NAME, G_INVALID_PARAMS_MSG);

4431: --
4432: -- invalid params passed
4433: --
4434: code_debug (l_api_name ||' invalid parameters passed ');
4435: fnd_message.Set_Name(G_APP_NAME, G_INVALID_PARAMS_MSG);
4436: fnd_message.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
4437: fnd_message.Set_Token(G_PROC_NAME_TOKEN, l_api_name);
4438: FND_MSG_PUB.Add;
4439: RAISE FND_API.G_EXC_ERROR;

Line 4436: fnd_message.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);

4432: -- invalid params passed
4433: --
4434: code_debug (l_api_name ||' invalid parameters passed ');
4435: fnd_message.Set_Name(G_APP_NAME, G_INVALID_PARAMS_MSG);
4436: fnd_message.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
4437: fnd_message.Set_Token(G_PROC_NAME_TOKEN, l_api_name);
4438: FND_MSG_PUB.Add;
4439: RAISE FND_API.G_EXC_ERROR;
4440: END IF;

Line 4437: fnd_message.Set_Token(G_PROC_NAME_TOKEN, l_api_name);

4433: --
4434: code_debug (l_api_name ||' invalid parameters passed ');
4435: fnd_message.Set_Name(G_APP_NAME, G_INVALID_PARAMS_MSG);
4436: fnd_message.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
4437: fnd_message.Set_Token(G_PROC_NAME_TOKEN, l_api_name);
4438: FND_MSG_PUB.Add;
4439: RAISE FND_API.G_EXC_ERROR;
4440: END IF;
4441:

Line 4520: fnd_message.Set_Name(G_APP_NAME,'EGO_GENERIC_MSG_TEXT');

4516: code_debug (l_api_name ||' return status from ego_item_lc_imp_pc_pub.Implement_Pending_Changes '||x_return_status);
4517: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4518: IF x_msg_count = 1 THEN
4519: code_debug (l_api_name ||' cannot implement changes for '||x_msg_data);
4520: fnd_message.Set_Name(G_APP_NAME,'EGO_GENERIC_MSG_TEXT');
4521: fnd_message.set_token('MESSAGE', x_msg_data);
4522: fnd_msg_pub.Add;
4523: END IF;
4524: RAISE FND_API.G_EXC_ERROR;

Line 4521: fnd_message.set_token('MESSAGE', x_msg_data);

4517: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4518: IF x_msg_count = 1 THEN
4519: code_debug (l_api_name ||' cannot implement changes for '||x_msg_data);
4520: fnd_message.Set_Name(G_APP_NAME,'EGO_GENERIC_MSG_TEXT');
4521: fnd_message.set_token('MESSAGE', x_msg_data);
4522: fnd_msg_pub.Add;
4523: END IF;
4524: RAISE FND_API.G_EXC_ERROR;
4525: END IF;

Line 4551: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);

4547: IF FND_API.To_Boolean( p_commit ) THEN
4548: ROLLBACK TO IMPLEMENT_CHANGES_SP;
4549: END IF;
4550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4551: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
4552: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
4553: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
4554: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
4555: FND_MSG_PUB.Add;

Line 4552: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);

4548: ROLLBACK TO IMPLEMENT_CHANGES_SP;
4549: END IF;
4550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4551: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
4552: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
4553: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
4554: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
4555: FND_MSG_PUB.Add;
4556: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 4553: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);

4549: END IF;
4550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4551: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
4552: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
4553: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
4554: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
4555: FND_MSG_PUB.Add;
4556: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
4557: ,p_count => x_msg_count

Line 4554: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);

4550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4551: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
4552: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
4553: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
4554: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
4555: FND_MSG_PUB.Add;
4556: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
4557: ,p_count => x_msg_count
4558: ,p_data => x_msg_data);