DBA Data[Home] [Help]

APPS.EGO_ITEM_PVT dependencies on FND_MSG_PUB

Line 158: fnd_msg_pub.Add;

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;
162: ELSIF p_organization_code IS NOT NULL THEN

Line 177: fnd_msg_pub.Add;

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;
181: ELSE

Line 220: fnd_msg_pub.Add;

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;
224: ELSIF x_item_number IS NOT NULL THEN

Line 239: fnd_msg_pub.Add;

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;
243: ELSE

Line 256: fnd_msg_pub.Add;

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;
260: EXCEPTION

Line 297: fnd_msg_pub.Add;

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;
301: ELSIF x_revision IS NOT NULL THEN

Line 315: fnd_msg_pub.Add;

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;
319: ELSE

Line 549: fnd_msg_pub.Add;

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;
553: EXCEPTION

Line 3051: fnd_msg_pub.Add;

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;
3054: ELSE
3055: CLOSE c_user_party_id;

Line 3134: fnd_msg_pub.Add;

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
3138: CLOSE c_priv_cursor;

Line 3225: FND_MSG_PUB.Initialize;

3221: --
3222: -- Initialize message list
3223: --
3224: IF FND_API.To_Boolean(p_init_msg_list) THEN
3225: FND_MSG_PUB.Initialize;
3226: END IF;
3227: code_debug(l_api_name||' msg pub initialized ' );
3228: --
3229: --Standard checks

Line 3313: fnd_msg_pub.Add;

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 ' );
3317: l_sysdate := SYSDATE;

Line 3348: fnd_msg_pub.Add;

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;
3351: --
3352: -- no security check done for the update of grants of type instance set.

Line 3418: fnd_msg_pub.Add;

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
3422: ,p_end_date => p_end_date

Line 3427: fnd_msg_pub.Add;

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
3431: l_start_date := NVL(p_start_date,l_start_date);

Line 3447: fnd_msg_pub.Add;

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;
3451: IF FND_API.To_Boolean( p_commit ) THEN

Line 3488: fnd_msg_pub.Add;

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 ');
3491: --
3492: -- validate the menu details passed

Line 3510: fnd_msg_pub.Add;

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 ');
3513: --
3514: -- validate the start_date - end_date standrad checks

Line 3523: fnd_msg_pub.Add;

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
3527: ,p_validation_type => G_GT_VAL

Line 3532: fnd_msg_pub.Add;

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
3536: ,p_validation_type => G_GT_VAL

Line 3541: fnd_msg_pub.Add;

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:
3545: IF l_instance_set_id IS NOT NULL OR p_instance_set_name IS NOT NULL THEN

Line 3563: fnd_msg_pub.Add;

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 ');
3566: IF NOT validate_function_security(p_function_name => G_FN_NAME_ADMIN
3567: ,p_set_message => G_TRUE) THEN

Line 3644: fnd_msg_pub.Add;

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
3648: -- as per standards

Line 3669: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

3665: IF FND_API.To_Boolean( p_commit ) THEN
3666: ROLLBACK TO PROCESS_ITEM_ROLE_SP;
3667: END IF;
3668: x_return_status := FND_API.G_RET_STS_ERROR;
3669: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
3670: ,p_count => x_msg_count
3671: ,p_data => x_msg_data);
3672: WHEN OTHERS THEN
3673: IF FND_API.To_Boolean( p_commit ) THEN

Line 3681: FND_MSG_PUB.Add;

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);
3685: code_debug(' EXCEPTION in '||l_api_name||' : ' ||x_msg_data );

Line 3682: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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);
3685: code_debug(' EXCEPTION in '||l_api_name||' : ' ||x_msg_data );
3686: END Process_item_role;

Line 3823: FND_MSG_PUB.Initialize;

3819: --
3820: -- Initialize message list
3821: --
3822: IF FND_API.To_Boolean(p_init_msg_list) THEN
3823: FND_MSG_PUB.Initialize;
3824: END IF;
3825: code_debug(l_api_name||' msg pub initialized ' );
3826: --
3827: --Standard checks

Line 3867: FND_MSG_PUB.Add;

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;
3871: l_organization_id := p_organization_id;

Line 3893: fnd_msg_pub.Add;

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;
3897: --

Line 3930: fnd_msg_pub.Add;

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;
3934: ELSIF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_DEMOTE THEN

Line 4001: fnd_msg_pub.Add;

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
4004: END IF; -- validate item
4005: END IF; -- validate org

Line 4033: fnd_msg_pub.Add;

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
4037: OPEN c_get_next_phase (cp_lifecycle_id => l_curr_lifecycle_id

Line 4052: fnd_msg_pub.Add;

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;
4056: ELSIF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_DEMOTE THEN

Line 4072: fnd_msg_pub.Add;

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;
4076: END IF;

Line 4073: fnd_msg_pub.Add;

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;
4076: END IF;
4077: END IF;

Line 4150: fnd_msg_pub.Add;

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.
4154: IF p_phase_id IS NOT NULL THEN

Line 4195: fnd_msg_pub.Add;

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:
4199: IF l_change_status_flag THEN

Line 4276: fnd_msg_pub.Add;

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
4280: code_debug (l_api_name ||' calling EGO_ITEM_LC_IMP_PC_PUB.Implement_Pending_Changes ');

Line 4304: fnd_msg_pub.Add;

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;
4308: END IF;

Line 4326: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

4322: IF FND_API.To_Boolean( p_commit ) THEN
4323: ROLLBACK TO PROCESS_ITEM_PHASE_SP;
4324: END IF;
4325: x_return_status := FND_API.G_RET_STS_ERROR;
4326: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
4327: ,p_count => x_msg_count
4328: ,p_data => x_msg_data);
4329: WHEN OTHERS THEN
4330: IF FND_API.To_Boolean( p_commit ) THEN

Line 4353: FND_MSG_PUB.Add;

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);
4357: code_debug(' Exception in '||l_api_name||' : ' ||x_msg_data );

Line 4354: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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);
4357: code_debug(' Exception in '||l_api_name||' : ' ||x_msg_data );
4358: END Process_item_phase_and_status;

Line 4411: FND_MSG_PUB.Initialize;

4407: --
4408: -- Initialize message list
4409: --
4410: IF FND_API.To_Boolean(p_init_msg_list) THEN
4411: FND_MSG_PUB.Initialize;
4412: END IF;
4413: code_debug(l_api_name||' msg pub initialized ' );
4414: --
4415: --Standard checks

Line 4438: FND_MSG_PUB.Add;

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:
4442: --

Line 4522: fnd_msg_pub.Add;

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;
4526: ELSE

Line 4543: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

4539: IF FND_API.To_Boolean( p_commit ) THEN
4540: ROLLBACK TO IMPLEMENT_CHANGES_SP;
4541: END IF;
4542: x_return_status := FND_API.G_RET_STS_ERROR;
4543: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
4544: ,p_count => x_msg_count
4545: ,p_data => x_msg_data);
4546: WHEN OTHERS THEN
4547: IF FND_API.To_Boolean( p_commit ) THEN

Line 4555: FND_MSG_PUB.Add;

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);
4559: code_debug(' Exception in '||l_api_name||' : ' ||x_msg_data );

Line 4556: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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);
4559: code_debug(' Exception in '||l_api_name||' : ' ||x_msg_data );
4560: END Implement_Item_Pending_Changes;