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 157: fnd_message.Set_Name(G_APP_NAME, 'EGO_ORGANIZATION_ID');

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

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

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

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

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

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

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

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

157: fnd_message.Set_Name(G_APP_NAME, 'EGO_ORGANIZATION_ID');
158: l_dummy_char := fnd_message.get();
159: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');
160: fnd_message.Set_Token('NAME', l_dummy_char);
161: fnd_message.Set_Token('VALUE', x_organization_id);
162: fnd_msg_pub.Add;
163: END IF;
164: RETURN FALSE;
165: END;

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

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

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

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

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

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

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

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

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

176: fnd_message.Set_Name(G_APP_NAME, 'EGO_ORGANIZATION_CODE');
177: l_dummy_char := fnd_message.get();
178: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');
179: fnd_message.Set_Token('NAME', l_dummy_char);
180: fnd_message.Set_Token('VALUE', p_organization_code);
181: fnd_msg_pub.Add;
182: END IF;
183: RETURN FALSE;
184: END;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

255: fnd_message.Set_Name(G_APP_NAME, 'EGO_ORGANIZATION');
256: l_dummy_char := fnd_message.get();
257: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');
258: fnd_message.Set_Token('NAME', l_dummy_char);
259: fnd_message.Set_Token('VALUE', ' ');
260: fnd_msg_pub.Add;
261: END IF;
262: RETURN FALSE;
263: END IF;

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

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

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

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

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

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

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

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

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

548: IF fnd_function.test(p_function_name) THEN
549: RETURN TRUE;
550: ELSE
551: IF FND_API.To_Boolean(p_set_message) THEN
552: fnd_message.Set_Name(G_APP_NAME, 'EGO_NO_FUNC_PRIVILEGE_FOR_USER');
553: fnd_msg_pub.Add;
554: END IF;
555: RETURN FALSE;
556: END IF;

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

1650: ,x_return_status => l_return_status
1651: ,x_return_err => l_return_err
1652: );
1653:
1654: FND_MESSAGE.set_name('INV', l_return_err); --Setting error message to be returned
1655:
1656: ELSIF ( G_Item_Rec.Transaction_Type = 'CREATE' ) THEN
1657:
1658: INV_ITEM_GRP.Create_Item

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

3305: CLOSE c_user_party_id;
3306: --
3307: -- user is not registered properly
3308: --
3309: fnd_message.Set_Name(G_APP_NAME, 'EGO_NO_FUNC_PRIVILEGE_FOR_USER');
3310: IF FND_API.To_Boolean(p_set_message) THEN
3311: fnd_msg_pub.Add;
3312: END IF;
3313: RETURN FALSE;

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

3346: CLOSE c_priv_cursor;
3347: IF FND_API.To_Boolean(p_set_message) THEN
3348: code_debug (' user does not have privilege '||p_function_name ||' on item '||p_inventory_item_id);
3349: IF p_function_name = G_FN_NAME_ADD_ROLE THEN
3350: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_CANNOT_GRANT');
3351: -- EGO_IPI_CANNOT_GRANT : User "USER" does not have privilege to give grants on Item "ITEM" in Organization "ORGANIZATION".
3352: ELSIF p_function_name IN (G_FN_NAME_PROMOTE) THEN
3353: fnd_message.Set_Name(G_APP_NAME, 'EGO_NO_PRIV_PROMOTE');
3354: -- 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 3353: fnd_message.Set_Name(G_APP_NAME, 'EGO_NO_PRIV_PROMOTE');

3349: IF p_function_name = G_FN_NAME_ADD_ROLE THEN
3350: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_CANNOT_GRANT');
3351: -- EGO_IPI_CANNOT_GRANT : User "USER" does not have privilege to give grants on Item "ITEM" in Organization "ORGANIZATION".
3352: ELSIF p_function_name IN (G_FN_NAME_PROMOTE) THEN
3353: fnd_message.Set_Name(G_APP_NAME, 'EGO_NO_PRIV_PROMOTE');
3354: -- 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".
3355: ELSIF p_function_name IN (G_FN_NAME_DEMOTE) THEN
3356: fnd_message.Set_Name(G_APP_NAME, 'EGO_NO_PRIV_DEMOTE');
3357: -- 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 3356: fnd_message.Set_Name(G_APP_NAME, 'EGO_NO_PRIV_DEMOTE');

3352: ELSIF p_function_name IN (G_FN_NAME_PROMOTE) THEN
3353: fnd_message.Set_Name(G_APP_NAME, 'EGO_NO_PRIV_PROMOTE');
3354: -- 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".
3355: ELSIF p_function_name IN (G_FN_NAME_DEMOTE) THEN
3356: fnd_message.Set_Name(G_APP_NAME, 'EGO_NO_PRIV_DEMOTE');
3357: -- 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".
3358: ELSIF p_function_name = G_FN_NAME_CHANGE_STATUS THEN
3359: fnd_message.Set_Name(G_APP_NAME, 'EGO_NO_PRIV_CHANGE_STATUS');
3360: -- EGO_NO_PRIV_CHANGE_STATUS : User "USER" does not have privilege to change status of Item "ITEM" in Organization "ORGANIZATION".

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

3355: ELSIF p_function_name IN (G_FN_NAME_DEMOTE) THEN
3356: fnd_message.Set_Name(G_APP_NAME, 'EGO_NO_PRIV_DEMOTE');
3357: -- 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".
3358: ELSIF p_function_name = G_FN_NAME_CHANGE_STATUS THEN
3359: fnd_message.Set_Name(G_APP_NAME, 'EGO_NO_PRIV_CHANGE_STATUS');
3360: -- EGO_NO_PRIV_CHANGE_STATUS : User "USER" does not have privilege to change status of Item "ITEM" in Organization "ORGANIZATION".
3361: ELSIF p_function_name = G_FN_NAME_EDIT_LC_PROJ THEN
3362: fnd_message.set_name(G_APP_NAME, 'EGO_NO_PRIV_ITEM_PROJ_ASSOC');
3363: -- 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 3362: fnd_message.set_name(G_APP_NAME, 'EGO_NO_PRIV_ITEM_PROJ_ASSOC');

3358: ELSIF p_function_name = G_FN_NAME_CHANGE_STATUS THEN
3359: fnd_message.Set_Name(G_APP_NAME, 'EGO_NO_PRIV_CHANGE_STATUS');
3360: -- EGO_NO_PRIV_CHANGE_STATUS : User "USER" does not have privilege to change status of Item "ITEM" in Organization "ORGANIZATION".
3361: ELSIF p_function_name = G_FN_NAME_EDIT_LC_PROJ THEN
3362: fnd_message.set_name(G_APP_NAME, 'EGO_NO_PRIV_ITEM_PROJ_ASSOC');
3363: -- 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".
3364: END IF;
3365: IF l_owner_party_name IS NULL THEN
3366: OPEN c_user_party_name (cp_party_id => l_owner_party_id);

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

3366: OPEN c_user_party_name (cp_party_id => l_owner_party_id);
3367: FETCH c_user_party_name INTO l_owner_party_name;
3368: CLOSE c_user_party_name;
3369: END IF;
3370: fnd_message.Set_Token('USER', l_owner_party_name);
3371: IF p_item_number IS NULL THEN
3372: SELECT concatenated_segments
3373: INTO l_dummy_char
3374: FROM mtl_system_items_b_kfv

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

3377: ELSE
3378: l_dummy_char := p_item_number;
3379: END IF;
3380: IF p_function_name = G_FN_NAME_ADD_ROLE THEN
3381: fnd_message.Set_Token('ITEM', l_dummy_char);
3382: ELSE
3383: fnd_message.Set_Token('ITEM_NUMBER', l_dummy_char);
3384: END IF;
3385: IF p_organization_name IS NULL THEN

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

3379: END IF;
3380: IF p_function_name = G_FN_NAME_ADD_ROLE THEN
3381: fnd_message.Set_Token('ITEM', l_dummy_char);
3382: ELSE
3383: fnd_message.Set_Token('ITEM_NUMBER', l_dummy_char);
3384: END IF;
3385: IF p_organization_name IS NULL THEN
3386: SELECT name
3387: INTO l_dummy_char

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

3389: WHERE organization_id = p_organization_id;
3390: ELSE
3391: l_dummy_char := p_organization_name;
3392: END IF;
3393: fnd_message.Set_Token('ORGANIZATION', l_dummy_char);
3394: fnd_msg_pub.Add;
3395: END IF;
3396: RETURN FALSE;
3397: ELSE

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

3566: --
3567: -- inalid parameters passed
3568: --
3569: code_debug (l_api_version ||' invalid parameters passed ');
3570: fnd_message.Set_Name(G_APP_NAME, G_INVALID_PARAMS_MSG);
3571: fnd_message.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
3572: fnd_message.Set_Token(G_PROC_NAME_TOKEN, l_api_name);
3573: fnd_msg_pub.Add;
3574: RAISE FND_API.G_EXC_ERROR;

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

3567: -- inalid parameters passed
3568: --
3569: code_debug (l_api_version ||' invalid parameters passed ');
3570: fnd_message.Set_Name(G_APP_NAME, G_INVALID_PARAMS_MSG);
3571: fnd_message.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
3572: fnd_message.Set_Token(G_PROC_NAME_TOKEN, l_api_name);
3573: fnd_msg_pub.Add;
3574: RAISE FND_API.G_EXC_ERROR;
3575: END IF;

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

3568: --
3569: code_debug (l_api_version ||' invalid parameters passed ');
3570: fnd_message.Set_Name(G_APP_NAME, G_INVALID_PARAMS_MSG);
3571: fnd_message.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
3572: fnd_message.Set_Token(G_PROC_NAME_TOKEN, l_api_name);
3573: fnd_msg_pub.Add;
3574: RAISE FND_API.G_EXC_ERROR;
3575: END IF;
3576: code_debug(l_api_name||' valid params passed ' );

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

3600: EXCEPTION
3601: WHEN NO_DATA_FOUND THEN
3602: code_debug (l_api_version ||' no grant found for modification ');
3603: IF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE THEN
3604: fnd_message.set_name (G_APP_NAME, 'EGO_NO_REC_UPDATE');
3605: ELSE
3606: fnd_message.set_name (G_APP_NAME, 'EGO_NO_REC_DELETE');
3607: END IF;
3608: fnd_msg_pub.Add;

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

3602: code_debug (l_api_version ||' no grant found for modification ');
3603: IF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE THEN
3604: fnd_message.set_name (G_APP_NAME, 'EGO_NO_REC_UPDATE');
3605: ELSE
3606: fnd_message.set_name (G_APP_NAME, 'EGO_NO_REC_DELETE');
3607: END IF;
3608: fnd_msg_pub.Add;
3609: RAISE FND_API.G_EXC_ERROR;
3610: END;

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

3673: ,p_end_date => l_end_date
3674: ,p_validation_type => G_GT_VAL
3675: ) THEN
3676: code_debug (l_api_version ||' grant is already end dated ');
3677: fnd_message.Set_Name(G_APP_NAME, 'EGO_GRANT_END_DATED');
3678: fnd_msg_pub.Add;
3679: RAISE FND_API.G_EXC_ERROR;
3680: END IF;
3681: IF date_check (p_start_date => l_sysdate

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

3682: ,p_end_date => p_end_date
3683: ,p_validation_type => G_GT_VAL
3684: ) THEN
3685: code_debug (l_api_version ||' end date less than sysdate ');
3686: fnd_message.Set_Name(G_APP_NAME, 'EGO_ENDDATE_LT_CURRDATE');
3687: fnd_msg_pub.Add;
3688: RAISE FND_API.G_EXC_ERROR;
3689: END IF;
3690: IF (p_start_date > l_sysdate and l_start_date > l_sysdate) THEN

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

3700: );
3701: code_debug(l_api_name||' returning EGO_SECURITY_PUB.set_grant_date with status '||x_return_status );
3702: IF x_return_status = G_FALSE THEN
3703: code_debug (l_api_version ||' overlap grant found for update ');
3704: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_OVERLAP_GRANT');
3705: fnd_message.Set_Token('START_DATE', l_start_date);
3706: fnd_message.Set_Token('END_DATE', p_end_date);
3707: fnd_msg_pub.Add;
3708: RAISE FND_API.G_EXC_ERROR;

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

3701: code_debug(l_api_name||' returning EGO_SECURITY_PUB.set_grant_date with status '||x_return_status );
3702: IF x_return_status = G_FALSE THEN
3703: code_debug (l_api_version ||' overlap grant found for update ');
3704: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_OVERLAP_GRANT');
3705: fnd_message.Set_Token('START_DATE', l_start_date);
3706: fnd_message.Set_Token('END_DATE', p_end_date);
3707: fnd_msg_pub.Add;
3708: RAISE FND_API.G_EXC_ERROR;
3709: ELSE

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

3702: IF x_return_status = G_FALSE THEN
3703: code_debug (l_api_version ||' overlap grant found for update ');
3704: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_OVERLAP_GRANT');
3705: fnd_message.Set_Token('START_DATE', l_start_date);
3706: fnd_message.Set_Token('END_DATE', p_end_date);
3707: fnd_msg_pub.Add;
3708: RAISE FND_API.G_EXC_ERROR;
3709: ELSE
3710: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

3728: ) THEN
3729: code_debug (l_api_version ||' invalid party passed ');
3730: l_create_grant_flag := FALSE;
3731: IF p_party_type = EGO_ITEM_PUB.G_USER_PARTY_TYPE THEN
3732: fnd_message.Set_Name(G_APP_NAME, 'EGO_USER');
3733: l_dummy_char := fnd_message.get();
3734: ELSIF p_party_type = EGO_ITEM_PUB.G_GROUP_PARTY_TYPE THEN
3735: fnd_message.Set_Name(G_APP_NAME, 'EGO_GROUP_NAME');
3736: l_dummy_char := fnd_message.get();

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

3729: code_debug (l_api_version ||' invalid party passed ');
3730: l_create_grant_flag := FALSE;
3731: IF p_party_type = EGO_ITEM_PUB.G_USER_PARTY_TYPE THEN
3732: fnd_message.Set_Name(G_APP_NAME, 'EGO_USER');
3733: l_dummy_char := fnd_message.get();
3734: ELSIF p_party_type = EGO_ITEM_PUB.G_GROUP_PARTY_TYPE THEN
3735: fnd_message.Set_Name(G_APP_NAME, 'EGO_GROUP_NAME');
3736: l_dummy_char := fnd_message.get();
3737: ELSIF p_party_type = EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE THEN

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

3731: IF p_party_type = EGO_ITEM_PUB.G_USER_PARTY_TYPE THEN
3732: fnd_message.Set_Name(G_APP_NAME, 'EGO_USER');
3733: l_dummy_char := fnd_message.get();
3734: ELSIF p_party_type = EGO_ITEM_PUB.G_GROUP_PARTY_TYPE THEN
3735: fnd_message.Set_Name(G_APP_NAME, 'EGO_GROUP_NAME');
3736: l_dummy_char := fnd_message.get();
3737: ELSIF p_party_type = EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE THEN
3738: fnd_message.Set_Name(G_APP_NAME, 'EGO_COMPANY');
3739: l_dummy_char := fnd_message.get();

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

3732: fnd_message.Set_Name(G_APP_NAME, 'EGO_USER');
3733: l_dummy_char := fnd_message.get();
3734: ELSIF p_party_type = EGO_ITEM_PUB.G_GROUP_PARTY_TYPE THEN
3735: fnd_message.Set_Name(G_APP_NAME, 'EGO_GROUP_NAME');
3736: l_dummy_char := fnd_message.get();
3737: ELSIF p_party_type = EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE THEN
3738: fnd_message.Set_Name(G_APP_NAME, 'EGO_COMPANY');
3739: l_dummy_char := fnd_message.get();
3740: END IF;

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

3734: ELSIF p_party_type = EGO_ITEM_PUB.G_GROUP_PARTY_TYPE THEN
3735: fnd_message.Set_Name(G_APP_NAME, 'EGO_GROUP_NAME');
3736: l_dummy_char := fnd_message.get();
3737: ELSIF p_party_type = EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE THEN
3738: fnd_message.Set_Name(G_APP_NAME, 'EGO_COMPANY');
3739: l_dummy_char := fnd_message.get();
3740: END IF;
3741: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');
3742: fnd_message.Set_Token('NAME', l_dummy_char);

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

3735: fnd_message.Set_Name(G_APP_NAME, 'EGO_GROUP_NAME');
3736: l_dummy_char := fnd_message.get();
3737: ELSIF p_party_type = EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE THEN
3738: fnd_message.Set_Name(G_APP_NAME, 'EGO_COMPANY');
3739: l_dummy_char := fnd_message.get();
3740: END IF;
3741: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');
3742: fnd_message.Set_Token('NAME', l_dummy_char);
3743: IF l_party_id IS NOT NULL THEN

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

3737: ELSIF p_party_type = EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE THEN
3738: fnd_message.Set_Name(G_APP_NAME, 'EGO_COMPANY');
3739: l_dummy_char := fnd_message.get();
3740: END IF;
3741: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');
3742: fnd_message.Set_Token('NAME', l_dummy_char);
3743: IF l_party_id IS NOT NULL THEN
3744: fnd_message.Set_Token('VALUE', l_party_id);
3745: ELSE

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

3738: fnd_message.Set_Name(G_APP_NAME, 'EGO_COMPANY');
3739: l_dummy_char := fnd_message.get();
3740: END IF;
3741: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');
3742: fnd_message.Set_Token('NAME', l_dummy_char);
3743: IF l_party_id IS NOT NULL THEN
3744: fnd_message.Set_Token('VALUE', l_party_id);
3745: ELSE
3746: fnd_message.Set_Token('VALUE', l_party_name);

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

3740: END IF;
3741: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');
3742: fnd_message.Set_Token('NAME', l_dummy_char);
3743: IF l_party_id IS NOT NULL THEN
3744: fnd_message.Set_Token('VALUE', l_party_id);
3745: ELSE
3746: fnd_message.Set_Token('VALUE', l_party_name);
3747: END IF;
3748: fnd_msg_pub.Add;

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

3742: fnd_message.Set_Token('NAME', l_dummy_char);
3743: IF l_party_id IS NOT NULL THEN
3744: fnd_message.Set_Token('VALUE', l_party_id);
3745: ELSE
3746: fnd_message.Set_Token('VALUE', l_party_name);
3747: END IF;
3748: fnd_msg_pub.Add;
3749: END IF;
3750: code_debug(l_api_name||' validate party done ');

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

3757: ,p_menu_type => 'SECURITY'
3758: ) THEN
3759: code_debug (l_api_version ||' invalid menu passed ');
3760: l_create_grant_flag := FALSE;
3761: fnd_message.Set_Name(G_APP_NAME, 'EGO_ROLE');
3762: l_dummy_char := fnd_message.get();
3763: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');
3764: fnd_message.Set_Token('NAME', l_dummy_char);
3765: IF l_role_id IS NOT NULL THEN

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

3758: ) THEN
3759: code_debug (l_api_version ||' invalid menu passed ');
3760: l_create_grant_flag := FALSE;
3761: fnd_message.Set_Name(G_APP_NAME, 'EGO_ROLE');
3762: l_dummy_char := fnd_message.get();
3763: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');
3764: fnd_message.Set_Token('NAME', l_dummy_char);
3765: IF l_role_id IS NOT NULL THEN
3766: fnd_message.Set_Token('VALUE', l_role_id);

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

3759: code_debug (l_api_version ||' invalid menu passed ');
3760: l_create_grant_flag := FALSE;
3761: fnd_message.Set_Name(G_APP_NAME, 'EGO_ROLE');
3762: l_dummy_char := fnd_message.get();
3763: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');
3764: fnd_message.Set_Token('NAME', l_dummy_char);
3765: IF l_role_id IS NOT NULL THEN
3766: fnd_message.Set_Token('VALUE', l_role_id);
3767: ELSE

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

3760: l_create_grant_flag := FALSE;
3761: fnd_message.Set_Name(G_APP_NAME, 'EGO_ROLE');
3762: l_dummy_char := fnd_message.get();
3763: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');
3764: fnd_message.Set_Token('NAME', l_dummy_char);
3765: IF l_role_id IS NOT NULL THEN
3766: fnd_message.Set_Token('VALUE', l_role_id);
3767: ELSE
3768: fnd_message.Set_Token('VALUE', p_role_name);

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

3762: l_dummy_char := fnd_message.get();
3763: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');
3764: fnd_message.Set_Token('NAME', l_dummy_char);
3765: IF l_role_id IS NOT NULL THEN
3766: fnd_message.Set_Token('VALUE', l_role_id);
3767: ELSE
3768: fnd_message.Set_Token('VALUE', p_role_name);
3769: END IF;
3770: fnd_msg_pub.Add;

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

3764: fnd_message.Set_Token('NAME', l_dummy_char);
3765: IF l_role_id IS NOT NULL THEN
3766: fnd_message.Set_Token('VALUE', l_role_id);
3767: ELSE
3768: fnd_message.Set_Token('VALUE', p_role_name);
3769: END IF;
3770: fnd_msg_pub.Add;
3771: END IF;
3772: code_debug(l_api_name||' validate menu done ');

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

3778: ,p_validation_type => G_LT_VAL
3779: ) THEN
3780: code_debug (l_api_version ||' start date less than sysdate ');
3781: l_create_grant_flag := FALSE;
3782: fnd_message.Set_Name(G_APP_NAME, 'EGO_INVALID_GRANT_START_DATE');
3783: fnd_msg_pub.Add;
3784: END IF;
3785: IF date_check (p_start_date => l_sysdate
3786: ,p_end_date => p_end_date

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

3787: ,p_validation_type => G_GT_VAL
3788: ) THEN
3789: code_debug (l_api_version ||' end date less than sysdate ');
3790: l_create_grant_flag := FALSE;
3791: fnd_message.Set_Name(G_APP_NAME, 'EGO_ENDDATE_LT_CURRDATE');
3792: fnd_msg_pub.Add;
3793: END IF;
3794: IF date_check (p_start_date => l_start_date
3795: ,p_end_date => p_end_date

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

3796: ,p_validation_type => G_GT_VAL
3797: ) THEN
3798: code_debug (l_api_version ||' end date less than startdate ');
3799: l_create_grant_flag := FALSE;
3800: fnd_message.Set_Name(G_APP_NAME, 'EGO_ENDDATE_EXCEEDS_STARTDATE');
3801: fnd_msg_pub.Add;
3802: END IF;
3803: code_debug(l_api_name||' validate date done ');
3804:

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

3810: ,p_set_disp_name => p_instance_set_name
3811: ) THEN
3812: code_debug (l_api_version ||' invalid instance set ');
3813: l_create_grant_flag := FALSE;
3814: fnd_message.Set_Name(G_APP_NAME, 'EGO_INSTANCE');
3815: l_dummy_char := fnd_message.get();
3816: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');
3817: fnd_message.Set_Token('NAME', l_dummy_char);
3818: IF l_instance_set_id IS NOT NULL THEN

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

3811: ) THEN
3812: code_debug (l_api_version ||' invalid instance set ');
3813: l_create_grant_flag := FALSE;
3814: fnd_message.Set_Name(G_APP_NAME, 'EGO_INSTANCE');
3815: l_dummy_char := fnd_message.get();
3816: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');
3817: fnd_message.Set_Token('NAME', l_dummy_char);
3818: IF l_instance_set_id IS NOT NULL THEN
3819: fnd_message.Set_Token('VALUE', l_instance_set_id);

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

3812: code_debug (l_api_version ||' invalid instance set ');
3813: l_create_grant_flag := FALSE;
3814: fnd_message.Set_Name(G_APP_NAME, 'EGO_INSTANCE');
3815: l_dummy_char := fnd_message.get();
3816: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');
3817: fnd_message.Set_Token('NAME', l_dummy_char);
3818: IF l_instance_set_id IS NOT NULL THEN
3819: fnd_message.Set_Token('VALUE', l_instance_set_id);
3820: ELSE

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

3813: l_create_grant_flag := FALSE;
3814: fnd_message.Set_Name(G_APP_NAME, 'EGO_INSTANCE');
3815: l_dummy_char := fnd_message.get();
3816: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');
3817: fnd_message.Set_Token('NAME', l_dummy_char);
3818: IF l_instance_set_id IS NOT NULL THEN
3819: fnd_message.Set_Token('VALUE', l_instance_set_id);
3820: ELSE
3821: fnd_message.Set_Token('VALUE', p_instance_set_name);

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

3815: l_dummy_char := fnd_message.get();
3816: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');
3817: fnd_message.Set_Token('NAME', l_dummy_char);
3818: IF l_instance_set_id IS NOT NULL THEN
3819: fnd_message.Set_Token('VALUE', l_instance_set_id);
3820: ELSE
3821: fnd_message.Set_Token('VALUE', p_instance_set_name);
3822: END IF;
3823: fnd_msg_pub.Add;

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

3817: fnd_message.Set_Token('NAME', l_dummy_char);
3818: IF l_instance_set_id IS NOT NULL THEN
3819: fnd_message.Set_Token('VALUE', l_instance_set_id);
3820: ELSE
3821: fnd_message.Set_Token('VALUE', p_instance_set_name);
3822: END IF;
3823: fnd_msg_pub.Add;
3824: END IF;
3825: code_debug(l_api_name||' validate instance done ');

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

3897: );
3898: code_debug(l_api_name||' returning EGO_SECURITY_PUB.grant_role_guid with status '||x_return_status);
3899: IF x_return_status = G_FALSE THEN
3900: code_debug (l_api_version ||' grant overlap when creating new grant ');
3901: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_OVERLAP_GRANT');
3902: fnd_message.Set_Token('START_DATE', l_start_date);
3903: fnd_message.Set_Token('END_DATE', p_end_date);
3904: fnd_msg_pub.Add;
3905: RAISE FND_API.G_EXC_ERROR;

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

3898: code_debug(l_api_name||' returning EGO_SECURITY_PUB.grant_role_guid with status '||x_return_status);
3899: IF x_return_status = G_FALSE THEN
3900: code_debug (l_api_version ||' grant overlap when creating new grant ');
3901: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_OVERLAP_GRANT');
3902: fnd_message.Set_Token('START_DATE', l_start_date);
3903: fnd_message.Set_Token('END_DATE', p_end_date);
3904: fnd_msg_pub.Add;
3905: RAISE FND_API.G_EXC_ERROR;
3906: ELSE

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

3899: IF x_return_status = G_FALSE THEN
3900: code_debug (l_api_version ||' grant overlap when creating new grant ');
3901: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_OVERLAP_GRANT');
3902: fnd_message.Set_Token('START_DATE', l_start_date);
3903: fnd_message.Set_Token('END_DATE', p_end_date);
3904: fnd_msg_pub.Add;
3905: RAISE FND_API.G_EXC_ERROR;
3906: ELSE
3907: -- changing return status to FND_API.G_RET_STS_SUCCESS

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

3933: IF FND_API.To_Boolean( p_commit ) THEN
3934: ROLLBACK TO PROCESS_ITEM_ROLE_SP;
3935: END IF;
3936: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3937: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
3938: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
3939: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
3940: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
3941: FND_MSG_PUB.Add;

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

3934: ROLLBACK TO PROCESS_ITEM_ROLE_SP;
3935: END IF;
3936: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3937: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
3938: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
3939: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
3940: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
3941: FND_MSG_PUB.Add;
3942: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

3935: END IF;
3936: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3937: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
3938: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
3939: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
3940: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
3941: FND_MSG_PUB.Add;
3942: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
3943: ,p_count => x_msg_count

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

3936: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3937: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
3938: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
3939: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
3940: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
3941: FND_MSG_PUB.Add;
3942: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
3943: ,p_count => x_msg_count
3944: ,p_data => x_msg_data);

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

4151: --
4152: -- inalid parameters passed
4153: --
4154: code_debug (l_api_version ||' invalid parameters passed ');
4155: fnd_message.Set_Name(G_APP_NAME, G_INVALID_PARAMS_MSG);
4156: fnd_message.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
4157: fnd_message.Set_Token(G_PROC_NAME_TOKEN, l_api_name);
4158: FND_MSG_PUB.Add;
4159: RAISE FND_API.G_EXC_ERROR;

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

4152: -- inalid parameters passed
4153: --
4154: code_debug (l_api_version ||' invalid parameters passed ');
4155: fnd_message.Set_Name(G_APP_NAME, G_INVALID_PARAMS_MSG);
4156: fnd_message.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
4157: fnd_message.Set_Token(G_PROC_NAME_TOKEN, l_api_name);
4158: FND_MSG_PUB.Add;
4159: RAISE FND_API.G_EXC_ERROR;
4160: END IF;

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

4153: --
4154: code_debug (l_api_version ||' invalid parameters passed ');
4155: fnd_message.Set_Name(G_APP_NAME, G_INVALID_PARAMS_MSG);
4156: fnd_message.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
4157: fnd_message.Set_Token(G_PROC_NAME_TOKEN, l_api_name);
4158: FND_MSG_PUB.Add;
4159: RAISE FND_API.G_EXC_ERROR;
4160: END IF;
4161: l_change_status_flag := TRUE;

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

4179: ,p_validation_type => G_LT_VAL
4180: ) THEN
4181: code_debug (l_api_name ||' effective date is less than system date ');
4182: l_change_status_flag := FALSE;
4183: fnd_message.Set_Name(G_APP_NAME, 'EGO_ITEM_INVALID_EFFCT_DATE');
4184: fnd_msg_pub.Add;
4185: ELSE
4186: code_debug (l_api_name ||' effective date is valid ');
4187: END IF;

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

4216: -- item is not approved no operations permitted
4217: --
4218: code_debug (l_api_name ||' unapproved item ');
4219: l_change_status_flag := FALSE;
4220: fnd_message.Set_Name(G_APP_NAME, 'EGO_ITEM_NOT_APPROVED');
4221: fnd_msg_pub.Add;
4222: ELSE
4223: IF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_PROMOTE THEN
4224: l_priv_function_name := G_FN_NAME_PROMOTE;

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

4284: ) THEN
4285: l_change_status_flag := FALSE;
4286: code_debug (l_api_name ||' no lifecycle associated to item / revision ');
4287: IF l_revision_id IS NULL THEN
4288: fnd_message.Set_Name(G_APP_NAME, 'EGO_ITEM_NO_LC_FOR_CHANGE');
4289: ELSE
4290: fnd_message.Set_Name(G_APP_NAME, 'EGO_REV_NO_LC_FOR_CHANGE');
4291: END IF;
4292: fnd_msg_pub.Add;

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

4286: code_debug (l_api_name ||' no lifecycle associated to item / revision ');
4287: IF l_revision_id IS NULL THEN
4288: fnd_message.Set_Name(G_APP_NAME, 'EGO_ITEM_NO_LC_FOR_CHANGE');
4289: ELSE
4290: fnd_message.Set_Name(G_APP_NAME, 'EGO_REV_NO_LC_FOR_CHANGE');
4291: END IF;
4292: fnd_msg_pub.Add;
4293: END IF;
4294: END IF; -- approval status

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

4314: ,p_revision => l_revision) THEN
4315: code_debug (l_api_name ||' lc project associated to item / revision ');
4316: l_change_status_flag := FALSE;
4317: IF l_revision IS NOT NULL THEN
4318: fnd_message.Set_Name(G_APP_NAME,'EGO_ITEM_REV_LC_PROJ_EXISTS');
4319: fnd_message.set_token('REVISION', l_revision);
4320: ELSE
4321: fnd_message.Set_Name(G_APP_NAME,'ITEM_LC_PROJ_EXISTS');
4322: END IF;

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

4315: code_debug (l_api_name ||' lc project associated to item / revision ');
4316: l_change_status_flag := FALSE;
4317: IF l_revision IS NOT NULL THEN
4318: fnd_message.Set_Name(G_APP_NAME,'EGO_ITEM_REV_LC_PROJ_EXISTS');
4319: fnd_message.set_token('REVISION', l_revision);
4320: ELSE
4321: fnd_message.Set_Name(G_APP_NAME,'ITEM_LC_PROJ_EXISTS');
4322: END IF;
4323: fnd_message.set_token('ITEM_NUMBER', l_item_number);

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

4317: IF l_revision IS NOT NULL THEN
4318: fnd_message.Set_Name(G_APP_NAME,'EGO_ITEM_REV_LC_PROJ_EXISTS');
4319: fnd_message.set_token('REVISION', l_revision);
4320: ELSE
4321: fnd_message.Set_Name(G_APP_NAME,'ITEM_LC_PROJ_EXISTS');
4322: END IF;
4323: fnd_message.set_token('ITEM_NUMBER', l_item_number);
4324: fnd_message.set_token('ORG_NAME', l_org_name);
4325: fnd_msg_pub.Add;

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

4319: fnd_message.set_token('REVISION', l_revision);
4320: ELSE
4321: fnd_message.Set_Name(G_APP_NAME,'ITEM_LC_PROJ_EXISTS');
4322: END IF;
4323: fnd_message.set_token('ITEM_NUMBER', l_item_number);
4324: fnd_message.set_token('ORG_NAME', l_org_name);
4325: fnd_msg_pub.Add;
4326: END IF;
4327:

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

4320: ELSE
4321: fnd_message.Set_Name(G_APP_NAME,'ITEM_LC_PROJ_EXISTS');
4322: END IF;
4323: fnd_message.set_token('ITEM_NUMBER', l_item_number);
4324: fnd_message.set_token('ORG_NAME', l_org_name);
4325: fnd_msg_pub.Add;
4326: END IF;
4327:
4328: IF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_PROMOTE THEN

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

4340: IF c_get_next_phase%NOTFOUND THEN
4341: CLOSE c_get_next_phase;
4342: code_debug (l_api_name ||' no phase to promote ');
4343: l_change_status_flag := FALSE;
4344: fnd_message.Set_Name(G_APP_NAME,'EGO_ITEM_CANNOT_PROMOTE');
4345: l_dummy_char := get_lifecycle_name (p_lc_phase_type => 'LIFECYCLE'
4346: ,p_proj_element_id => l_curr_lifecycle_id);
4347: fnd_message.set_token('LIFE_CYCLE', l_dummy_char);
4348: l_dummy_char := get_lifecycle_name (p_lc_phase_type => 'PHASE'

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

4343: l_change_status_flag := FALSE;
4344: fnd_message.Set_Name(G_APP_NAME,'EGO_ITEM_CANNOT_PROMOTE');
4345: l_dummy_char := get_lifecycle_name (p_lc_phase_type => 'LIFECYCLE'
4346: ,p_proj_element_id => l_curr_lifecycle_id);
4347: fnd_message.set_token('LIFE_CYCLE', l_dummy_char);
4348: l_dummy_char := get_lifecycle_name (p_lc_phase_type => 'PHASE'
4349: ,p_proj_element_id => l_curr_phase_id);
4350: fnd_message.set_token('PHASE', l_dummy_char);
4351: fnd_msg_pub.Add;

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

4346: ,p_proj_element_id => l_curr_lifecycle_id);
4347: fnd_message.set_token('LIFE_CYCLE', l_dummy_char);
4348: l_dummy_char := get_lifecycle_name (p_lc_phase_type => 'PHASE'
4349: ,p_proj_element_id => l_curr_phase_id);
4350: fnd_message.set_token('PHASE', l_dummy_char);
4351: fnd_msg_pub.Add;
4352: ELSE
4353: CLOSE c_get_next_phase;
4354: END IF;

Line 4366: fnd_message.Set_Name(G_APP_NAME,'EGO_LC_PHASE_NOT_ALLOWED');

4362: CLOSE c_chk_phase_against_lc;
4363: l_dummy_char := null;
4364: code_debug (l_api_name ||' phase does not exists in the current lifecycle of the item');
4365: l_change_status_flag := FALSE;
4366: fnd_message.Set_Name(G_APP_NAME,'EGO_LC_PHASE_NOT_ALLOWED');
4367: l_dummy_char := get_lifecycle_name (p_lc_phase_type => 'LIFECYCLE'
4368: ,p_proj_element_id => l_curr_lifecycle_id);
4369: fnd_message.set_token('LIFECYCLE', l_dummy_char);
4370: l_dummy_char := get_lifecycle_name (p_lc_phase_type => 'PHASE'

Line 4369: fnd_message.set_token('LIFECYCLE', l_dummy_char);

4365: l_change_status_flag := FALSE;
4366: fnd_message.Set_Name(G_APP_NAME,'EGO_LC_PHASE_NOT_ALLOWED');
4367: l_dummy_char := get_lifecycle_name (p_lc_phase_type => 'LIFECYCLE'
4368: ,p_proj_element_id => l_curr_lifecycle_id);
4369: fnd_message.set_token('LIFECYCLE', l_dummy_char);
4370: l_dummy_char := get_lifecycle_name (p_lc_phase_type => 'PHASE'
4371: ,p_proj_element_id => p_phase_id);
4372: fnd_message.set_token('PHASE', l_dummy_char);
4373: fnd_msg_pub.Add;

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

4368: ,p_proj_element_id => l_curr_lifecycle_id);
4369: fnd_message.set_token('LIFECYCLE', l_dummy_char);
4370: l_dummy_char := get_lifecycle_name (p_lc_phase_type => 'PHASE'
4371: ,p_proj_element_id => p_phase_id);
4372: fnd_message.set_token('PHASE', l_dummy_char);
4373: fnd_msg_pub.Add;
4374: -- EGO_LIFECYCLE_PHASE_INVALID if phase is invalid id?
4375: ELSE
4376: CLOSE c_chk_phase_against_lc;

Line 4390: fnd_message.Set_Name(G_APP_NAME,'EGO_LC_PROMOTE_NOT_ALLOWED');

4386:
4387: IF l_phase_sequence < l_item_sequence THEN
4388: code_debug (l_api_name ||' INVALID PHASE FOR PROMOTE');
4389: l_change_status_flag := FALSE;
4390: fnd_message.Set_Name(G_APP_NAME,'EGO_LC_PROMOTE_NOT_ALLOWED');
4391:
4392: l_dummy_char := get_lifecycle_name (p_lc_phase_type => 'LIFECYCLE'
4393: ,p_proj_element_id => l_curr_lifecycle_id);
4394:

Line 4395: fnd_message.set_token('LIFECYCLE', l_dummy_char);

4391:
4392: l_dummy_char := get_lifecycle_name (p_lc_phase_type => 'LIFECYCLE'
4393: ,p_proj_element_id => l_curr_lifecycle_id);
4394:
4395: fnd_message.set_token('LIFECYCLE', l_dummy_char);
4396: l_dummy_char := get_lifecycle_name (p_lc_phase_type => 'PHASE'
4397: ,p_proj_element_id => p_phase_id);
4398:
4399: fnd_message.set_token('PHASE', l_dummy_char);

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

4395: fnd_message.set_token('LIFECYCLE', l_dummy_char);
4396: l_dummy_char := get_lifecycle_name (p_lc_phase_type => 'PHASE'
4397: ,p_proj_element_id => p_phase_id);
4398:
4399: fnd_message.set_token('PHASE', l_dummy_char);
4400: l_dummy_char := get_lifecycle_name (p_lc_phase_type => 'PHASE'
4401: ,p_proj_element_id => l_curr_phase_id);
4402:
4403: fnd_message.set_token('CURRENTPHASE', l_dummy_char);

Line 4403: fnd_message.set_token('CURRENTPHASE', l_dummy_char);

4399: fnd_message.set_token('PHASE', l_dummy_char);
4400: l_dummy_char := get_lifecycle_name (p_lc_phase_type => 'PHASE'
4401: ,p_proj_element_id => l_curr_phase_id);
4402:
4403: fnd_message.set_token('CURRENTPHASE', l_dummy_char);
4404:
4405: fnd_msg_pub.Add;
4406: END IF;
4407: END IF;

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

4418: IF c_get_priv_phase%NOTFOUND THEN
4419: CLOSE c_get_priv_phase;
4420: code_debug (l_api_name ||' no phase to demote ');
4421: l_change_status_flag := FALSE;
4422: fnd_message.Set_Name(G_APP_NAME,'EGO_ITEM_CANNOT_DEMOTE');
4423: l_dummy_char := get_lifecycle_name (p_lc_phase_type => 'LIFECYCLE'
4424: ,p_proj_element_id => l_curr_lifecycle_id);
4425: fnd_message.set_token('LIFE_CYCLE', l_dummy_char);
4426: l_dummy_char := get_lifecycle_name (p_lc_phase_type => 'PHASE'

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

4421: l_change_status_flag := FALSE;
4422: fnd_message.Set_Name(G_APP_NAME,'EGO_ITEM_CANNOT_DEMOTE');
4423: l_dummy_char := get_lifecycle_name (p_lc_phase_type => 'LIFECYCLE'
4424: ,p_proj_element_id => l_curr_lifecycle_id);
4425: fnd_message.set_token('LIFE_CYCLE', l_dummy_char);
4426: l_dummy_char := get_lifecycle_name (p_lc_phase_type => 'PHASE'
4427: ,p_proj_element_id => l_curr_phase_id);
4428: fnd_message.set_token('PHASE', l_dummy_char);
4429: fnd_msg_pub.Add;

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

4424: ,p_proj_element_id => l_curr_lifecycle_id);
4425: fnd_message.set_token('LIFE_CYCLE', l_dummy_char);
4426: l_dummy_char := get_lifecycle_name (p_lc_phase_type => 'PHASE'
4427: ,p_proj_element_id => l_curr_phase_id);
4428: fnd_message.set_token('PHASE', l_dummy_char);
4429: fnd_msg_pub.Add;
4430: fnd_msg_pub.Add;
4431: ELSE
4432: CLOSE c_get_priv_phase;

Line 4445: fnd_message.Set_Name(G_APP_NAME,'EGO_LC_PHASE_NOT_ALLOWED');

4441: CLOSE c_chk_phase_against_lc;
4442: l_dummy_char := null;
4443: code_debug (l_api_name ||' phase does not exists in the current lifecycle of the item');
4444: l_change_status_flag := FALSE;
4445: fnd_message.Set_Name(G_APP_NAME,'EGO_LC_PHASE_NOT_ALLOWED');
4446: l_dummy_char := get_lifecycle_name (p_lc_phase_type => 'LIFECYCLE'
4447: ,p_proj_element_id => l_curr_lifecycle_id);
4448: fnd_message.set_token('LIFECYCLE', l_dummy_char);
4449: l_dummy_char := get_lifecycle_name (p_lc_phase_type => 'PHASE'

Line 4448: fnd_message.set_token('LIFECYCLE', l_dummy_char);

4444: l_change_status_flag := FALSE;
4445: fnd_message.Set_Name(G_APP_NAME,'EGO_LC_PHASE_NOT_ALLOWED');
4446: l_dummy_char := get_lifecycle_name (p_lc_phase_type => 'LIFECYCLE'
4447: ,p_proj_element_id => l_curr_lifecycle_id);
4448: fnd_message.set_token('LIFECYCLE', l_dummy_char);
4449: l_dummy_char := get_lifecycle_name (p_lc_phase_type => 'PHASE'
4450: ,p_proj_element_id => p_phase_id);
4451: fnd_message.set_token('PHASE', l_dummy_char);
4452: fnd_msg_pub.Add;

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

4447: ,p_proj_element_id => l_curr_lifecycle_id);
4448: fnd_message.set_token('LIFECYCLE', l_dummy_char);
4449: l_dummy_char := get_lifecycle_name (p_lc_phase_type => 'PHASE'
4450: ,p_proj_element_id => p_phase_id);
4451: fnd_message.set_token('PHASE', l_dummy_char);
4452: fnd_msg_pub.Add;
4453: -- EGO_LIFECYCLE_PHASE_INVALID if phase is invalid id?
4454: ELSE
4455: CLOSE c_chk_phase_against_lc;

Line 4469: fnd_message.Set_Name(G_APP_NAME,'EGO_LC_DEMOTE_NOT_ALLOWED');

4465:
4466: IF l_phase_sequence > l_item_sequence THEN
4467: code_debug (l_api_name ||' INVALID PHASE FOR DEMOTE');
4468: l_change_status_flag := FALSE;
4469: fnd_message.Set_Name(G_APP_NAME,'EGO_LC_DEMOTE_NOT_ALLOWED');
4470: l_dummy_char := get_lifecycle_name (p_lc_phase_type => 'LIFECYCLE'
4471: ,p_proj_element_id => l_curr_lifecycle_id);
4472:
4473: fnd_message.set_token('LIFECYCLE', l_dummy_char);

Line 4473: fnd_message.set_token('LIFECYCLE', l_dummy_char);

4469: fnd_message.Set_Name(G_APP_NAME,'EGO_LC_DEMOTE_NOT_ALLOWED');
4470: l_dummy_char := get_lifecycle_name (p_lc_phase_type => 'LIFECYCLE'
4471: ,p_proj_element_id => l_curr_lifecycle_id);
4472:
4473: fnd_message.set_token('LIFECYCLE', l_dummy_char);
4474: l_dummy_char := get_lifecycle_name (p_lc_phase_type => 'PHASE'
4475: ,p_proj_element_id => p_phase_id);
4476:
4477: fnd_message.set_token('PHASE', l_dummy_char);

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

4473: fnd_message.set_token('LIFECYCLE', l_dummy_char);
4474: l_dummy_char := get_lifecycle_name (p_lc_phase_type => 'PHASE'
4475: ,p_proj_element_id => p_phase_id);
4476:
4477: fnd_message.set_token('PHASE', l_dummy_char);
4478: l_dummy_char := get_lifecycle_name (p_lc_phase_type => 'PHASE'
4479: ,p_proj_element_id => l_curr_phase_id);
4480:
4481: fnd_message.set_token('CURRENTPHASE', l_dummy_char);

Line 4481: fnd_message.set_token('CURRENTPHASE', l_dummy_char);

4477: fnd_message.set_token('PHASE', l_dummy_char);
4478: l_dummy_char := get_lifecycle_name (p_lc_phase_type => 'PHASE'
4479: ,p_proj_element_id => l_curr_phase_id);
4480:
4481: fnd_message.set_token('CURRENTPHASE', l_dummy_char);
4482:
4483: fnd_msg_pub.Add;
4484: END IF;
4485: END IF;

Line 4503: fnd_message.Set_Name(G_APP_NAME,'EGO_LC_PHASE_NOT_ALLOWED');

4499: CLOSE c_chk_phase_against_lc;
4500: l_dummy_char := null;
4501: code_debug (l_api_name ||' phase does not exists in the current lifecycle of the item');
4502: l_change_status_flag := FALSE;
4503: fnd_message.Set_Name(G_APP_NAME,'EGO_LC_PHASE_NOT_ALLOWED');
4504: l_dummy_char := get_lifecycle_name (p_lc_phase_type => 'LIFECYCLE'
4505: ,p_proj_element_id => l_curr_lifecycle_id);
4506: fnd_message.set_token('LIFECYCLE', l_dummy_char);
4507: l_dummy_char := get_lifecycle_name (p_lc_phase_type => 'PHASE'

Line 4506: fnd_message.set_token('LIFECYCLE', l_dummy_char);

4502: l_change_status_flag := FALSE;
4503: fnd_message.Set_Name(G_APP_NAME,'EGO_LC_PHASE_NOT_ALLOWED');
4504: l_dummy_char := get_lifecycle_name (p_lc_phase_type => 'LIFECYCLE'
4505: ,p_proj_element_id => l_curr_lifecycle_id);
4506: fnd_message.set_token('LIFECYCLE', l_dummy_char);
4507: l_dummy_char := get_lifecycle_name (p_lc_phase_type => 'PHASE'
4508: ,p_proj_element_id => p_phase_id);
4509: fnd_message.set_token('PHASE', l_dummy_char);
4510: fnd_msg_pub.Add;

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

4505: ,p_proj_element_id => l_curr_lifecycle_id);
4506: fnd_message.set_token('LIFECYCLE', l_dummy_char);
4507: l_dummy_char := get_lifecycle_name (p_lc_phase_type => 'PHASE'
4508: ,p_proj_element_id => p_phase_id);
4509: fnd_message.set_token('PHASE', l_dummy_char);
4510: fnd_msg_pub.Add;
4511: -- EGO_LIFECYCLE_PHASE_INVALID if phase is invalid id?
4512: ELSE
4513: CLOSE c_chk_phase_against_lc;

Line 4529: fnd_message.Set_Name(G_APP_NAME,'EGO_LC_PHASE_CHG_NOT_ALLOWED');

4525:
4526: IF l_phase_sequence < l_item_sequence THEN
4527: code_debug (l_api_name ||' for CHANGE_PHASE only promotes are allowed');
4528: l_change_status_flag := FALSE;
4529: fnd_message.Set_Name(G_APP_NAME,'EGO_LC_PHASE_CHG_NOT_ALLOWED');
4530:
4531: fnd_message.set_token('ITEM_NUMBER', l_item_number);
4532: fnd_message.set_token('REVISION', l_revision);
4533: fnd_msg_pub.Add;

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

4527: code_debug (l_api_name ||' for CHANGE_PHASE only promotes are allowed');
4528: l_change_status_flag := FALSE;
4529: fnd_message.Set_Name(G_APP_NAME,'EGO_LC_PHASE_CHG_NOT_ALLOWED');
4530:
4531: fnd_message.set_token('ITEM_NUMBER', l_item_number);
4532: fnd_message.set_token('REVISION', l_revision);
4533: fnd_msg_pub.Add;
4534: END IF;
4535:

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

4528: l_change_status_flag := FALSE;
4529: fnd_message.Set_Name(G_APP_NAME,'EGO_LC_PHASE_CHG_NOT_ALLOWED');
4530:
4531: fnd_message.set_token('ITEM_NUMBER', l_item_number);
4532: fnd_message.set_token('REVISION', l_revision);
4533: fnd_msg_pub.Add;
4534: END IF;
4535:
4536:

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

4575: ELSE
4576: l_error_message := 'EGO_ITEM_REV_NO_DEMOTE';
4577: END IF;
4578: END IF;
4579: fnd_message.Set_Name(G_APP_NAME,l_error_message);
4580: fnd_message.set_token('ITEM_NUMBER', l_item_number);
4581: IF l_revision_id IS NOT NULL THEN
4582: fnd_message.set_token('REVISION', l_revision);
4583: END IF;

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

4576: l_error_message := 'EGO_ITEM_REV_NO_DEMOTE';
4577: END IF;
4578: END IF;
4579: fnd_message.Set_Name(G_APP_NAME,l_error_message);
4580: fnd_message.set_token('ITEM_NUMBER', l_item_number);
4581: IF l_revision_id IS NOT NULL THEN
4582: fnd_message.set_token('REVISION', l_revision);
4583: END IF;
4584: l_dummy_char := get_lifecycle_name (p_lc_phase_type => 'LIFECYCLE'

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

4578: END IF;
4579: fnd_message.Set_Name(G_APP_NAME,l_error_message);
4580: fnd_message.set_token('ITEM_NUMBER', l_item_number);
4581: IF l_revision_id IS NOT NULL THEN
4582: fnd_message.set_token('REVISION', l_revision);
4583: END IF;
4584: l_dummy_char := get_lifecycle_name (p_lc_phase_type => 'LIFECYCLE'
4585: ,p_proj_element_id => l_curr_lifecycle_id);
4586: fnd_message.set_token('LIFE_CYCLE', l_dummy_char);

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

4582: fnd_message.set_token('REVISION', l_revision);
4583: END IF;
4584: l_dummy_char := get_lifecycle_name (p_lc_phase_type => 'LIFECYCLE'
4585: ,p_proj_element_id => l_curr_lifecycle_id);
4586: fnd_message.set_token('LIFE_CYCLE', l_dummy_char);
4587: l_dummy_char := get_lifecycle_name (p_lc_phase_type => 'PHASE'
4588: ,p_proj_element_id => l_curr_phase_id);
4589: fnd_message.set_token('PHASE', l_dummy_char);
4590: SELECT concatenated_segments

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

4585: ,p_proj_element_id => l_curr_lifecycle_id);
4586: fnd_message.set_token('LIFE_CYCLE', l_dummy_char);
4587: l_dummy_char := get_lifecycle_name (p_lc_phase_type => 'PHASE'
4588: ,p_proj_element_id => l_curr_phase_id);
4589: fnd_message.set_token('PHASE', l_dummy_char);
4590: SELECT concatenated_segments
4591: INTO l_dummy_char
4592: FROM MTL_ITEM_CATALOG_GROUPS_KFV
4593: WHERE ITEM_CATALOG_GROUP_ID = (

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

4606: START WITH item_catalog_group_id = l_curr_cc_id
4607: ) CAT_HIER
4608: WHERE ROWNUM = 1
4609: );
4610: fnd_message.set_token('CATALOG_CATEGORY_NAME', l_dummy_char);
4611: fnd_msg_pub.Add;
4612: END IF;
4613: ELSIF p_transaction_type IN (EGO_ITEM_PUB.G_TTYPE_UPDATE, EGO_ITEM_PUB.G_TTYPE_DELETE) THEN
4614: -- check if the user has privilege to update the item.

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

4648: ,p_set_message => G_TRUE
4649: ) THEN
4650: code_debug(l_api_name ||' user does not have privilege to update the existing change '||p_transaction_type);
4651: l_change_status_flag := FALSE;
4652: fnd_message.Set_Name(G_APP_NAME,l_error_message);
4653: fnd_message.set_token('USER', FND_GLOBAL.USER_NAME);
4654: fnd_message.set_token('ITEM_NUMBER', l_item_number);
4655: fnd_message.set_token('ORGANIZATION', l_org_name);
4656: fnd_msg_pub.Add;

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

4649: ) THEN
4650: code_debug(l_api_name ||' user does not have privilege to update the existing change '||p_transaction_type);
4651: l_change_status_flag := FALSE;
4652: fnd_message.Set_Name(G_APP_NAME,l_error_message);
4653: fnd_message.set_token('USER', FND_GLOBAL.USER_NAME);
4654: fnd_message.set_token('ITEM_NUMBER', l_item_number);
4655: fnd_message.set_token('ORGANIZATION', l_org_name);
4656: fnd_msg_pub.Add;
4657: END IF;

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

4650: code_debug(l_api_name ||' user does not have privilege to update the existing change '||p_transaction_type);
4651: l_change_status_flag := FALSE;
4652: fnd_message.Set_Name(G_APP_NAME,l_error_message);
4653: fnd_message.set_token('USER', FND_GLOBAL.USER_NAME);
4654: fnd_message.set_token('ITEM_NUMBER', l_item_number);
4655: fnd_message.set_token('ORGANIZATION', l_org_name);
4656: fnd_msg_pub.Add;
4657: END IF;
4658: END IF;

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

4651: l_change_status_flag := FALSE;
4652: fnd_message.Set_Name(G_APP_NAME,l_error_message);
4653: fnd_message.set_token('USER', FND_GLOBAL.USER_NAME);
4654: fnd_message.set_token('ITEM_NUMBER', l_item_number);
4655: fnd_message.set_token('ORGANIZATION', l_org_name);
4656: fnd_msg_pub.Add;
4657: END IF;
4658: END IF;
4659:

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

4758: -- this will occur only in case of exception
4759: -- all valid values are passed.
4760: --
4761: IF x_msg_count = 1 THEN
4762: fnd_message.Set_Name(G_APP_NAME,'EGO_GENERIC_MSG_TEXT');
4763: fnd_message.set_token('MESSAGE', x_msg_data);
4764: fnd_msg_pub.Add;
4765: END IF;
4766: RAISE FND_API.G_EXC_ERROR;

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

4759: -- all valid values are passed.
4760: --
4761: IF x_msg_count = 1 THEN
4762: fnd_message.Set_Name(G_APP_NAME,'EGO_GENERIC_MSG_TEXT');
4763: fnd_message.set_token('MESSAGE', x_msg_data);
4764: fnd_msg_pub.Add;
4765: END IF;
4766: RAISE FND_API.G_EXC_ERROR;
4767: ELSIF FND_API.To_Boolean(p_implement_changes) THEN

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

4786: code_debug (l_api_name ||' return status from ego_item_lc_imp_pc_pub.Implement_Pending_Changes '||x_return_status);
4787: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4788: code_debug (l_api_name ||' cannot implement changes '||x_msg_data);
4789: IF x_msg_count = 1 THEN
4790: fnd_message.Set_Name(G_APP_NAME,'EGO_GENERIC_MSG_TEXT');
4791: fnd_message.set_token('MESSAGE', x_msg_data);
4792: fnd_msg_pub.Add;
4793: END IF;
4794: RAISE FND_API.G_EXC_ERROR;

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

4787: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4788: code_debug (l_api_name ||' cannot implement changes '||x_msg_data);
4789: IF x_msg_count = 1 THEN
4790: fnd_message.Set_Name(G_APP_NAME,'EGO_GENERIC_MSG_TEXT');
4791: fnd_message.set_token('MESSAGE', x_msg_data);
4792: fnd_msg_pub.Add;
4793: END IF;
4794: RAISE FND_API.G_EXC_ERROR;
4795: END IF;

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

4836: END IF;
4837: IF c_chk_phase_against_lc%ISOPEN THEN
4838: CLOSE c_chk_phase_against_lc;
4839: END IF;
4840: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
4841: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
4842: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
4843: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
4844: FND_MSG_PUB.Add;

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

4837: IF c_chk_phase_against_lc%ISOPEN THEN
4838: CLOSE c_chk_phase_against_lc;
4839: END IF;
4840: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
4841: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
4842: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
4843: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
4844: FND_MSG_PUB.Add;
4845: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

4838: CLOSE c_chk_phase_against_lc;
4839: END IF;
4840: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
4841: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
4842: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
4843: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
4844: FND_MSG_PUB.Add;
4845: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
4846: ,p_count => x_msg_count

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

4839: END IF;
4840: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
4841: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
4842: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
4843: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
4844: FND_MSG_PUB.Add;
4845: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
4846: ,p_count => x_msg_count
4847: ,p_data => x_msg_data);

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

4922: --
4923: -- invalid params passed
4924: --
4925: code_debug (l_api_name ||' invalid parameters passed ');
4926: fnd_message.Set_Name(G_APP_NAME, G_INVALID_PARAMS_MSG);
4927: fnd_message.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
4928: fnd_message.Set_Token(G_PROC_NAME_TOKEN, l_api_name);
4929: FND_MSG_PUB.Add;
4930: RAISE FND_API.G_EXC_ERROR;

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

4923: -- invalid params passed
4924: --
4925: code_debug (l_api_name ||' invalid parameters passed ');
4926: fnd_message.Set_Name(G_APP_NAME, G_INVALID_PARAMS_MSG);
4927: fnd_message.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
4928: fnd_message.Set_Token(G_PROC_NAME_TOKEN, l_api_name);
4929: FND_MSG_PUB.Add;
4930: RAISE FND_API.G_EXC_ERROR;
4931: END IF;

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

4924: --
4925: code_debug (l_api_name ||' invalid parameters passed ');
4926: fnd_message.Set_Name(G_APP_NAME, G_INVALID_PARAMS_MSG);
4927: fnd_message.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
4928: fnd_message.Set_Token(G_PROC_NAME_TOKEN, l_api_name);
4929: FND_MSG_PUB.Add;
4930: RAISE FND_API.G_EXC_ERROR;
4931: END IF;
4932:

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

5007: code_debug (l_api_name ||' return status from ego_item_lc_imp_pc_pub.Implement_Pending_Changes '||x_return_status);
5008: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5009: IF x_msg_count = 1 THEN
5010: code_debug (l_api_name ||' cannot implement changes for '||x_msg_data);
5011: fnd_message.Set_Name(G_APP_NAME,'EGO_GENERIC_MSG_TEXT');
5012: fnd_message.set_token('MESSAGE', x_msg_data);
5013: fnd_msg_pub.Add;
5014: END IF;
5015: RAISE FND_API.G_EXC_ERROR;

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

5008: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5009: IF x_msg_count = 1 THEN
5010: code_debug (l_api_name ||' cannot implement changes for '||x_msg_data);
5011: fnd_message.Set_Name(G_APP_NAME,'EGO_GENERIC_MSG_TEXT');
5012: fnd_message.set_token('MESSAGE', x_msg_data);
5013: fnd_msg_pub.Add;
5014: END IF;
5015: RAISE FND_API.G_EXC_ERROR;
5016: END IF;

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

5038: IF FND_API.To_Boolean( p_commit ) THEN
5039: ROLLBACK TO IMPLEMENT_CHANGES_SP;
5040: END IF;
5041: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5042: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
5043: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
5044: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
5045: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
5046: FND_MSG_PUB.Add;

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

5039: ROLLBACK TO IMPLEMENT_CHANGES_SP;
5040: END IF;
5041: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5042: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
5043: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
5044: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
5045: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
5046: FND_MSG_PUB.Add;
5047: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

5040: END IF;
5041: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5042: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
5043: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
5044: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
5045: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
5046: FND_MSG_PUB.Add;
5047: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5048: ,p_count => x_msg_count

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

5041: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5042: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
5043: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
5044: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
5045: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
5046: FND_MSG_PUB.Add;
5047: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5048: ,p_count => x_msg_count
5049: ,p_data => x_msg_data);

Line 6310: fnd_message.set_name('INV','INV_TEMPLATE_ERROR');

6306: from mtl_item_templates
6307: where template_id = p_template_id;
6308: EXCEPTION
6309: WHEN NO_DATA_FOUND THEN
6310: fnd_message.set_name('INV','INV_TEMPLATE_ERROR');
6311: fnd_msg_pub.Add;
6312: RAISE FND_API.G_EXC_ERROR;
6313: WHEN OTHERS THEN
6314: null;

Line 6327: fnd_message.set_name('INV','INV_INVALID_ITEM_ORG');

6323: where inventory_item_id = p_inventory_item_id
6324: and organization_id = p_organization_id;
6325: EXCEPTION
6326: WHEN NO_DATA_FOUND THEN
6327: fnd_message.set_name('INV','INV_INVALID_ITEM_ORG');
6328: fnd_msg_pub.Add;
6329: RAISE FND_API.G_EXC_ERROR;
6330: WHEN OTHERS THEN
6331: null;

Line 6338: fnd_message.set_name('INV','INV_ST_INVALID_COMBINATION');

6334: END IF;
6335:
6336: ELSE
6337:
6338: fnd_message.set_name('INV','INV_ST_INVALID_COMBINATION');
6339: fnd_msg_pub.Add;
6340: RAISE FND_API.G_EXC_ERROR;
6341:
6342: END IF;

Line 6382: fnd_message.set_name('INV','INV_ALREADY_EXISTS');

6378:
6379: END IF;
6380:
6381: IF l_exists = 'Y' THEN
6382: fnd_message.set_name('INV','INV_ALREADY_EXISTS');
6383: fnd_message.set_token('ENTITY',l_transaction_type_name,FALSE);
6384: fnd_msg_pub.Add;
6385: RAISE FND_API.G_EXC_ERROR;
6386: END IF;

Line 6383: fnd_message.set_token('ENTITY',l_transaction_type_name,FALSE);

6379: END IF;
6380:
6381: IF l_exists = 'Y' THEN
6382: fnd_message.set_name('INV','INV_ALREADY_EXISTS');
6383: fnd_message.set_token('ENTITY',l_transaction_type_name,FALSE);
6384: fnd_msg_pub.Add;
6385: RAISE FND_API.G_EXC_ERROR;
6386: END IF;
6387:

Line 6494: FND_MESSAGE.SET_NAME('INV','INV_PENDING_TXNS_EXISTS');

6490:
6491: END IF;
6492:
6493: IF l_exists = 'Y' THEN
6494: FND_MESSAGE.SET_NAME('INV','INV_PENDING_TXNS_EXISTS');
6495: fnd_message.set_token('ENTITY',l_transaction_type_name,FALSE);
6496: fnd_msg_pub.Add;
6497: RAISE FND_API.G_EXC_ERROR;
6498: END IF;

Line 6495: fnd_message.set_token('ENTITY',l_transaction_type_name,FALSE);

6491: END IF;
6492:
6493: IF l_exists = 'Y' THEN
6494: FND_MESSAGE.SET_NAME('INV','INV_PENDING_TXNS_EXISTS');
6495: fnd_message.set_token('ENTITY',l_transaction_type_name,FALSE);
6496: fnd_msg_pub.Add;
6497: RAISE FND_API.G_EXC_ERROR;
6498: END IF;
6499:

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

6569: WHEN OTHERS THEN
6570: ROLLBACK TO Process_Serial_Tag_Assign;
6571: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6572:
6573: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
6574: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
6575: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
6576: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
6577: FND_MSG_PUB.Add;

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

6570: ROLLBACK TO Process_Serial_Tag_Assign;
6571: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6572:
6573: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
6574: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
6575: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
6576: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
6577: FND_MSG_PUB.Add;
6578: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

6571: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6572:
6573: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
6574: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
6575: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
6576: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
6577: FND_MSG_PUB.Add;
6578: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
6579: ,p_count => x_msg_count

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

6572:
6573: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
6574: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
6575: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
6576: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
6577: FND_MSG_PUB.Add;
6578: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
6579: ,p_count => x_msg_count
6580: ,p_data => x_msg_data);