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_MSG_PUB

Line 162: fnd_msg_pub.Add;

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

Line 181: fnd_msg_pub.Add;

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

Line 224: fnd_msg_pub.Add;

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

Line 243: fnd_msg_pub.Add;

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

Line 260: fnd_msg_pub.Add;

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

Line 301: fnd_msg_pub.Add;

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

Line 319: fnd_msg_pub.Add;

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

Line 553: fnd_msg_pub.Add;

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

Line 3311: fnd_msg_pub.Add;

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;
3314: ELSE
3315: CLOSE c_user_party_id;

Line 3394: fnd_msg_pub.Add;

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

Line 3485: FND_MSG_PUB.Initialize;

3481: --
3482: -- Initialize message list
3483: --
3484: IF FND_API.To_Boolean(p_init_msg_list) THEN
3485: FND_MSG_PUB.Initialize;
3486: END IF;
3487: code_debug(l_api_name||' msg pub initialized ' );
3488: --
3489: --Standard checks

Line 3573: fnd_msg_pub.Add;

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

Line 3608: fnd_msg_pub.Add;

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

Line 3678: fnd_msg_pub.Add;

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

Line 3687: fnd_msg_pub.Add;

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

Line 3707: fnd_msg_pub.Add;

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

Line 3748: fnd_msg_pub.Add;

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

Line 3770: fnd_msg_pub.Add;

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

Line 3783: fnd_msg_pub.Add;

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

Line 3792: fnd_msg_pub.Add;

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

Line 3801: fnd_msg_pub.Add;

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

Line 3823: fnd_msg_pub.Add;

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

Line 3904: fnd_msg_pub.Add;

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

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

3925: IF FND_API.To_Boolean( p_commit ) THEN
3926: ROLLBACK TO PROCESS_ITEM_ROLE_SP;
3927: END IF;
3928: x_return_status := FND_API.G_RET_STS_ERROR;
3929: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
3930: ,p_count => x_msg_count
3931: ,p_data => x_msg_data);
3932: WHEN OTHERS THEN
3933: IF FND_API.To_Boolean( p_commit ) THEN

Line 3941: FND_MSG_PUB.Add;

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

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

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

Line 4100: FND_MSG_PUB.Initialize;

4096: --
4097: -- Initialize message list
4098: --
4099: IF FND_API.To_Boolean(p_init_msg_list) THEN
4100: FND_MSG_PUB.Initialize;
4101: END IF;
4102: code_debug(l_api_name||' msg pub initialized ' );
4103: --
4104: --Standard checks

Line 4158: FND_MSG_PUB.Add;

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

Line 4184: fnd_msg_pub.Add;

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

Line 4221: fnd_msg_pub.Add;

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

Line 4292: fnd_msg_pub.Add;

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
4295: END IF; -- validate item
4296: END IF; -- validate org

Line 4325: fnd_msg_pub.Add;

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

Line 4351: fnd_msg_pub.Add;

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

Line 4373: fnd_msg_pub.Add;

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;
4377: l_future_phase_id := p_phase_id;

Line 4405: fnd_msg_pub.Add;

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

Line 4429: fnd_msg_pub.Add;

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

Line 4430: fnd_msg_pub.Add;

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;
4433: END IF;
4434: ELSE

Line 4452: fnd_msg_pub.Add;

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;
4456: l_future_phase_id := p_phase_id;

Line 4483: fnd_msg_pub.Add;

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;
4486: END IF;
4487: -- PROMOTE/DEMOTE can be used to skip the phase

Line 4510: fnd_msg_pub.Add;

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;
4514: l_future_phase_id := p_phase_id;

Line 4533: fnd_msg_pub.Add;

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:
4537: END IF;*/

Line 4611: fnd_msg_pub.Add;

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

Line 4656: fnd_msg_pub.Add;

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

Line 4764: fnd_msg_pub.Add;

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

Line 4792: fnd_msg_pub.Add;

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

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

4810: IF FND_API.To_Boolean( p_commit ) THEN
4811: ROLLBACK TO PROCESS_ITEM_PHASE_SP;
4812: END IF;
4813: x_return_status := FND_API.G_RET_STS_ERROR;
4814: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
4815: ,p_count => x_msg_count
4816: ,p_data => x_msg_data);
4817: WHEN OTHERS THEN
4818: IF FND_API.To_Boolean( p_commit ) THEN

Line 4844: FND_MSG_PUB.Add;

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

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

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

Line 4902: FND_MSG_PUB.Initialize;

4898: --
4899: -- Initialize message list
4900: --
4901: IF FND_API.To_Boolean(p_init_msg_list) THEN
4902: FND_MSG_PUB.Initialize;
4903: END IF;
4904: code_debug(l_api_name||' msg pub initialized ' );
4905: --
4906: --Standard checks

Line 4929: FND_MSG_PUB.Add;

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

Line 5013: fnd_msg_pub.Add;

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

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

5030: IF FND_API.To_Boolean( p_commit ) THEN
5031: ROLLBACK TO IMPLEMENT_CHANGES_SP;
5032: END IF;
5033: x_return_status := FND_API.G_RET_STS_ERROR;
5034: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5035: ,p_count => x_msg_count
5036: ,p_data => x_msg_data);
5037: WHEN OTHERS THEN
5038: IF FND_API.To_Boolean( p_commit ) THEN

Line 5046: FND_MSG_PUB.Add;

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

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

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

Line 6282: FND_MSG_PUB.Initialize;

6278: --
6279: -- Initialize message list
6280: --
6281: IF FND_API.To_Boolean(p_init_msg_list) THEN
6282: FND_MSG_PUB.Initialize;
6283: END IF;
6284:
6285: x_return_status := FND_API.G_RET_STS_SUCCESS;
6286:

Line 6311: fnd_msg_pub.Add;

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;
6315: END;

Line 6328: fnd_msg_pub.Add;

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;
6332: END;

Line 6339: fnd_msg_pub.Add;

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

Line 6384: fnd_msg_pub.Add;

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:
6388: EXCEPTION

Line 6496: fnd_msg_pub.Add;

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

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

6562: ROLLBACK TO Process_Serial_Tag_Assign;
6563: code_debug(l_api_name||' returning expected error ');
6564:
6565: x_return_status := FND_API.G_RET_STS_ERROR;
6566: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
6567: ,p_count => x_msg_count
6568: ,p_data => x_msg_data);
6569: WHEN OTHERS THEN
6570: ROLLBACK TO Process_Serial_Tag_Assign;

Line 6577: FND_MSG_PUB.Add;

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);
6581:

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

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