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_LC_IMP_PC_PUB dependencies on FND_MESSAGE

Line 203: fnd_message.set_name('EGO', 'EGO_ITEM_PENDING_CHANGES_EXIST');

199: SELECT organization_name
200: INTO l_org_name
201: FROM org_organization_definitions
202: WHERE organization_id = l_organization_id;
203: fnd_message.set_name('EGO', 'EGO_ITEM_PENDING_CHANGES_EXIST');
204: fnd_message.set_token('ITEM_NUMBER', l_item_number);
205: fnd_message.set_token('ORG_NAME', l_org_name);
206: x_msg_data := fnd_message.get();
207: code_debug(' error msg '|| x_msg_data);

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

200: INTO l_org_name
201: FROM org_organization_definitions
202: WHERE organization_id = l_organization_id;
203: fnd_message.set_name('EGO', 'EGO_ITEM_PENDING_CHANGES_EXIST');
204: fnd_message.set_token('ITEM_NUMBER', l_item_number);
205: fnd_message.set_token('ORG_NAME', l_org_name);
206: x_msg_data := fnd_message.get();
207: code_debug(' error msg '|| x_msg_data);
208: ELSE

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

201: FROM org_organization_definitions
202: WHERE organization_id = l_organization_id;
203: fnd_message.set_name('EGO', 'EGO_ITEM_PENDING_CHANGES_EXIST');
204: fnd_message.set_token('ITEM_NUMBER', l_item_number);
205: fnd_message.set_token('ORG_NAME', l_org_name);
206: x_msg_data := fnd_message.get();
207: code_debug(' error msg '|| x_msg_data);
208: ELSE
209: code_debug(' no pending changes ');

Line 206: x_msg_data := fnd_message.get();

202: WHERE organization_id = l_organization_id;
203: fnd_message.set_name('EGO', 'EGO_ITEM_PENDING_CHANGES_EXIST');
204: fnd_message.set_token('ITEM_NUMBER', l_item_number);
205: fnd_message.set_token('ORG_NAME', l_org_name);
206: x_msg_data := fnd_message.get();
207: code_debug(' error msg '|| x_msg_data);
208: ELSE
209: code_debug(' no pending changes ');
210: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

949: IF c_rev_pending_phase_change%ISOPEN THEN
950: CLOSE c_rev_pending_phase_change;
951: END IF;
952: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
953: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
954: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
955: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'IMPLEMENT_ALL_PENDING_CHANGES');
956: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
957: x_msg_count := 1;

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

950: CLOSE c_rev_pending_phase_change;
951: END IF;
952: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
953: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
954: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
955: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'IMPLEMENT_ALL_PENDING_CHANGES');
956: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
957: x_msg_count := 1;
958: x_msg_data := FND_MESSAGE.GET;

Line 955: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'IMPLEMENT_ALL_PENDING_CHANGES');

951: END IF;
952: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
953: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
954: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
955: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'IMPLEMENT_ALL_PENDING_CHANGES');
956: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
957: x_msg_count := 1;
958: x_msg_data := FND_MESSAGE.GET;
959: -- x_return_status := FND_API.G_RET_STS_ERROR;

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

952: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
953: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
954: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
955: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'IMPLEMENT_ALL_PENDING_CHANGES');
956: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
957: x_msg_count := 1;
958: x_msg_data := FND_MESSAGE.GET;
959: -- x_return_status := FND_API.G_RET_STS_ERROR;
960: -- x_msg_data := FND_MESSAGE.Get_String('EGO', 'EGO_EXT_EXCEPTION_OCCURED');

Line 958: x_msg_data := FND_MESSAGE.GET;

954: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
955: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'IMPLEMENT_ALL_PENDING_CHANGES');
956: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
957: x_msg_count := 1;
958: x_msg_data := FND_MESSAGE.GET;
959: -- x_return_status := FND_API.G_RET_STS_ERROR;
960: -- x_msg_data := FND_MESSAGE.Get_String('EGO', 'EGO_EXT_EXCEPTION_OCCURED');
961:
962: END Implement_All_Pending_Changes;

Line 960: -- x_msg_data := FND_MESSAGE.Get_String('EGO', 'EGO_EXT_EXCEPTION_OCCURED');

956: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
957: x_msg_count := 1;
958: x_msg_data := FND_MESSAGE.GET;
959: -- x_return_status := FND_API.G_RET_STS_ERROR;
960: -- x_msg_data := FND_MESSAGE.Get_String('EGO', 'EGO_EXT_EXCEPTION_OCCURED');
961:
962: END Implement_All_Pending_Changes;
963:
964:

Line 1151: fnd_message.Set_Name(G_APP_NAME, 'EGO_API_INVALID_PARAMS');

1147: ( (p_revision IS NOT NULL OR p_revision_id IS NOT NULL) AND p_status_code IS NOT NULL)
1148: OR
1149: (p_phase_id IS NULL AND p_status_code IS NULL)
1150: ) THEN
1151: fnd_message.Set_Name(G_APP_NAME, 'EGO_API_INVALID_PARAMS');
1152: fnd_message.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
1153: fnd_message.Set_Token(G_API_NAME_TOKEN, l_api_name);
1154: FND_MSG_PUB.Add;
1155: RAISE FND_API.G_EXC_ERROR;

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

1148: OR
1149: (p_phase_id IS NULL AND p_status_code IS NULL)
1150: ) THEN
1151: fnd_message.Set_Name(G_APP_NAME, 'EGO_API_INVALID_PARAMS');
1152: fnd_message.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
1153: fnd_message.Set_Token(G_API_NAME_TOKEN, l_api_name);
1154: FND_MSG_PUB.Add;
1155: RAISE FND_API.G_EXC_ERROR;
1156: END IF;

Line 1153: fnd_message.Set_Token(G_API_NAME_TOKEN, l_api_name);

1149: (p_phase_id IS NULL AND p_status_code IS NULL)
1150: ) THEN
1151: fnd_message.Set_Name(G_APP_NAME, 'EGO_API_INVALID_PARAMS');
1152: fnd_message.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
1153: fnd_message.Set_Token(G_API_NAME_TOKEN, l_api_name);
1154: FND_MSG_PUB.Add;
1155: RAISE FND_API.G_EXC_ERROR;
1156: END IF;
1157:

Line 1191: fnd_message.Set_Name(G_APP_NAME, 'EGO_ITEM_NOT_READY_FOR_CHANGE');

1187: code_debug( l_api_name ||' curr values - current_phase_id '||l_phase_id_curr||' lifecycle_id '||l_lifecycle_id_itm||' status_code '||l_status_code_itm );
1188:
1189: -- bug 3909677
1190: IF NVL(l_approval_status,'A') <> 'A' THEN
1191: fnd_message.Set_Name(G_APP_NAME, 'EGO_ITEM_NOT_READY_FOR_CHANGE');
1192: SELECT CONCATENATED_SEGMENTS
1193: INTO l_dummy_char
1194: FROM MTL_SYSTEM_ITEMS_KFV
1195: WHERE INVENTORY_ITEM_ID = p_inventory_item_id

Line 1197: fnd_message.set_token('ITEM_NUMBER', l_dummy_char);

1193: INTO l_dummy_char
1194: FROM MTL_SYSTEM_ITEMS_KFV
1195: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
1196: AND ORGANIZATION_ID = p_organization_id;
1197: fnd_message.set_token('ITEM_NUMBER', l_dummy_char);
1198: SELECT name
1199: INTO l_dummy_char
1200: FROM hr_all_organization_units_vl
1201: WHERE organization_id = p_organization_id;

Line 1202: fnd_message.set_token('ORGANIZATION', l_dummy_char);

1198: SELECT name
1199: INTO l_dummy_char
1200: FROM hr_all_organization_units_vl
1201: WHERE organization_id = p_organization_id;
1202: fnd_message.set_token('ORGANIZATION', l_dummy_char);
1203: fnd_msg_pub.Add;
1204: RAISE FND_API.G_EXC_ERROR;
1205: END IF;
1206:

Line 1259: fnd_message.Set_Name(G_APP_NAME, 'EGO_NO_STATUS_FOR_PHASE_ERR');

1255: SELECT name
1256: INTO l_dummy_char
1257: FROM PA_EGO_PHASES_V
1258: WHERE proj_element_id = p_phase_id;
1259: fnd_message.Set_Name(G_APP_NAME, 'EGO_NO_STATUS_FOR_PHASE_ERR');
1260: fnd_message.Set_Token('PHASE', l_dummy_char);
1261: FND_MSG_PUB.Add;
1262: RAISE FND_API.G_EXC_ERROR;
1263: ELSE

Line 1260: fnd_message.Set_Token('PHASE', l_dummy_char);

1256: INTO l_dummy_char
1257: FROM PA_EGO_PHASES_V
1258: WHERE proj_element_id = p_phase_id;
1259: fnd_message.Set_Name(G_APP_NAME, 'EGO_NO_STATUS_FOR_PHASE_ERR');
1260: fnd_message.Set_Token('PHASE', l_dummy_char);
1261: FND_MSG_PUB.Add;
1262: RAISE FND_API.G_EXC_ERROR;
1263: ELSE
1264: CLOSE c_get_def_status_code;

Line 1297: fnd_message.Set_Name(G_APP_NAME, 'EGO_ITEM_PENDING_PHASE_CHANGE');

1293: ELSE
1294: l_dummy_char := p_item_number;
1295: END IF;
1296: IF l_revision_id IS NULL THEN
1297: fnd_message.Set_Name(G_APP_NAME, 'EGO_ITEM_PENDING_PHASE_CHANGE');
1298: fnd_message.Set_Token('ITEM_NUMBER', l_dummy_char);
1299: FND_MSG_PUB.Add;
1300: RAISE FND_API.G_EXC_ERROR;
1301: ELSE

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

1294: l_dummy_char := p_item_number;
1295: END IF;
1296: IF l_revision_id IS NULL THEN
1297: fnd_message.Set_Name(G_APP_NAME, 'EGO_ITEM_PENDING_PHASE_CHANGE');
1298: fnd_message.Set_Token('ITEM_NUMBER', l_dummy_char);
1299: FND_MSG_PUB.Add;
1300: RAISE FND_API.G_EXC_ERROR;
1301: ELSE
1302: fnd_message.Set_Name(G_APP_NAME, 'EGO_REV_PENDING_PHASE_CHANGE');

Line 1302: fnd_message.Set_Name(G_APP_NAME, 'EGO_REV_PENDING_PHASE_CHANGE');

1298: fnd_message.Set_Token('ITEM_NUMBER', l_dummy_char);
1299: FND_MSG_PUB.Add;
1300: RAISE FND_API.G_EXC_ERROR;
1301: ELSE
1302: fnd_message.Set_Name(G_APP_NAME, 'EGO_REV_PENDING_PHASE_CHANGE');
1303: fnd_message.Set_Token('ITEM_NUMBER', l_dummy_char);
1304: fnd_message.Set_Token('REVISION', l_revision);
1305: FND_MSG_PUB.Add;
1306: RAISE FND_API.G_EXC_ERROR;

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

1299: FND_MSG_PUB.Add;
1300: RAISE FND_API.G_EXC_ERROR;
1301: ELSE
1302: fnd_message.Set_Name(G_APP_NAME, 'EGO_REV_PENDING_PHASE_CHANGE');
1303: fnd_message.Set_Token('ITEM_NUMBER', l_dummy_char);
1304: fnd_message.Set_Token('REVISION', l_revision);
1305: FND_MSG_PUB.Add;
1306: RAISE FND_API.G_EXC_ERROR;
1307: END IF;

Line 1304: fnd_message.Set_Token('REVISION', l_revision);

1300: RAISE FND_API.G_EXC_ERROR;
1301: ELSE
1302: fnd_message.Set_Name(G_APP_NAME, 'EGO_REV_PENDING_PHASE_CHANGE');
1303: fnd_message.Set_Token('ITEM_NUMBER', l_dummy_char);
1304: fnd_message.Set_Token('REVISION', l_revision);
1305: FND_MSG_PUB.Add;
1306: RAISE FND_API.G_EXC_ERROR;
1307: END IF;
1308: END IF; -- l_pending_rec_count

Line 1324: fnd_message.Set_Name(G_APP_NAME, 'EGO_ITEM_INVALID_STATUS');

1320: );
1321: FETCH c_validate_status_code INTO l_status_code;
1322: IF c_validate_status_code%NOTFOUND THEN
1323: CLOSE c_validate_status_code;
1324: fnd_message.Set_Name(G_APP_NAME, 'EGO_ITEM_INVALID_STATUS');
1325: fnd_message.Set_Token('STATUS', p_status_code);
1326: SELECT name
1327: INTO l_dummy_char
1328: FROM PA_EGO_PHASES_V

Line 1325: fnd_message.Set_Token('STATUS', p_status_code);

1321: FETCH c_validate_status_code INTO l_status_code;
1322: IF c_validate_status_code%NOTFOUND THEN
1323: CLOSE c_validate_status_code;
1324: fnd_message.Set_Name(G_APP_NAME, 'EGO_ITEM_INVALID_STATUS');
1325: fnd_message.Set_Token('STATUS', p_status_code);
1326: SELECT name
1327: INTO l_dummy_char
1328: FROM PA_EGO_PHASES_V
1329: WHERE proj_element_id = NVL(p_phase_id,l_phase_id_curr);

Line 1330: fnd_message.Set_Token('PHASE', l_dummy_char);

1326: SELECT name
1327: INTO l_dummy_char
1328: FROM PA_EGO_PHASES_V
1329: WHERE proj_element_id = NVL(p_phase_id,l_phase_id_curr);
1330: fnd_message.Set_Token('PHASE', l_dummy_char);
1331: FND_MSG_PUB.Add;
1332: RAISE FND_API.G_EXC_ERROR;
1333: ELSE
1334: code_debug (l_api_name ||' checking for master controlled status ');

Line 1341: fnd_message.Set_Name(G_APP_NAME,'EGO_ITEM_STATUS_MC');

1337: l_status_master_controlled := get_master_controlled_status();
1338: IF ('T' = l_status_master_controlled) AND NOT ('T' = l_is_master_org) THEN
1339: IF l_status_code_itm <> l_status_code THEN
1340: code_debug (l_api_name ||' status changes controlled at master cannot change ');
1341: fnd_message.Set_Name(G_APP_NAME,'EGO_ITEM_STATUS_MC');
1342: fnd_msg_pub.Add;
1343: RAISE FND_API.G_EXC_ERROR;
1344: END IF;
1345: END IF; -- status is master controlled and we are in context of child org

Line 1438: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);

1434: IF c_validate_status_code%ISOPEN THEN
1435: CLOSE c_validate_status_code;
1436: END IF;
1437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1438: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
1439: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
1440: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1441: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
1442: FND_MSG_PUB.Add;

Line 1439: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);

1435: CLOSE c_validate_status_code;
1436: END IF;
1437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1438: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
1439: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
1440: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1441: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
1442: FND_MSG_PUB.Add;
1443: END Create_Pending_Phase_Change;

Line 1440: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);

1436: END IF;
1437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1438: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
1439: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
1440: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1441: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
1442: FND_MSG_PUB.Add;
1443: END Create_Pending_Phase_Change;
1444:

Line 1441: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);

1437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1438: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
1439: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
1440: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1441: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
1442: FND_MSG_PUB.Add;
1443: END Create_Pending_Phase_Change;
1444:
1445:

Line 1509: fnd_message.Set_Name(G_APP_NAME, 'EGO_API_INVALID_PARAMS');

1505: p_effective_date IS NULL
1506: OR
1507: p_transaction_type NOT IN (EGO_ITEM_PUB.G_TTYPE_UPDATE, EGO_ITEM_PUB.G_TTYPE_DELETE)
1508: ) THEN
1509: fnd_message.Set_Name(G_APP_NAME, 'EGO_API_INVALID_PARAMS');
1510: fnd_message.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
1511: fnd_message.Set_Token(G_API_NAME_TOKEN, l_api_name);
1512: FND_MSG_PUB.Add;
1513: RAISE FND_API.G_EXC_ERROR;

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

1506: OR
1507: p_transaction_type NOT IN (EGO_ITEM_PUB.G_TTYPE_UPDATE, EGO_ITEM_PUB.G_TTYPE_DELETE)
1508: ) THEN
1509: fnd_message.Set_Name(G_APP_NAME, 'EGO_API_INVALID_PARAMS');
1510: fnd_message.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
1511: fnd_message.Set_Token(G_API_NAME_TOKEN, l_api_name);
1512: FND_MSG_PUB.Add;
1513: RAISE FND_API.G_EXC_ERROR;
1514: END IF;

Line 1511: fnd_message.Set_Token(G_API_NAME_TOKEN, l_api_name);

1507: p_transaction_type NOT IN (EGO_ITEM_PUB.G_TTYPE_UPDATE, EGO_ITEM_PUB.G_TTYPE_DELETE)
1508: ) THEN
1509: fnd_message.Set_Name(G_APP_NAME, 'EGO_API_INVALID_PARAMS');
1510: fnd_message.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
1511: fnd_message.Set_Token(G_API_NAME_TOKEN, l_api_name);
1512: FND_MSG_PUB.Add;
1513: RAISE FND_API.G_EXC_ERROR;
1514: END IF;
1515:

Line 1569: fnd_message.Set_Name(G_APP_NAME, 'EGO_NO_REC_UPDATE');

1565: AND implemented_date IS NULL;
1566: IF SQL%ROWCOUNT = 0 THEN
1567: code_debug(l_api_name|| ' cannot update record!! ');
1568: -- no records found for update
1569: fnd_message.Set_Name(G_APP_NAME, 'EGO_NO_REC_UPDATE');
1570: FND_MSG_PUB.Add;
1571: RAISE FND_API.G_EXC_ERROR;
1572: END IF;
1573:

Line 1593: fnd_message.Set_Name(G_APP_NAME, 'EGO_NO_REC_DELETE');

1589: AND pending_flag = 'Y'
1590: AND implemented_date IS NULL;
1591: IF SQL%ROWCOUNT = 0 THEN
1592: -- no records found for delete
1593: fnd_message.Set_Name(G_APP_NAME, 'EGO_NO_REC_DELETE');
1594: FND_MSG_PUB.Add;
1595: RAISE FND_API.G_EXC_ERROR;
1596: END IF;
1597:

Line 1754: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);

1750: IF FND_API.To_Boolean(p_commit) THEN
1751: ROLLBACK TO Delete_Pending_Phase_Change_SP;
1752: END IF;
1753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1754: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
1755: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
1756: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1757: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
1758: FND_MSG_PUB.Add;

Line 1755: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);

1751: ROLLBACK TO Delete_Pending_Phase_Change_SP;
1752: END IF;
1753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1754: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
1755: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
1756: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1757: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
1758: FND_MSG_PUB.Add;
1759:

Line 1756: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);

1752: END IF;
1753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1754: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
1755: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
1756: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1757: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
1758: FND_MSG_PUB.Add;
1759:
1760: END Delete_Pending_Phase_Change;

Line 1757: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);

1753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1754: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
1755: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
1756: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1757: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
1758: FND_MSG_PUB.Add;
1759:
1760: END Delete_Pending_Phase_Change;
1761: ***/

Line 1855: FND_MESSAGE.Set_name(G_APP_NAME, 'EGO_API_INVALID_PARAMS');

1851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1852: END IF;
1853:
1854: IF (p_change_id IS NULL AND p_change_line_id IS NULL) THEN
1855: FND_MESSAGE.Set_name(G_APP_NAME, 'EGO_API_INVALID_PARAMS');
1856: FND_MESSAGE.Set_token('PKG_NAME', G_PKG_NAME);
1857: FND_MESSAGE.Set_Token('PROC_NAME', l_api_name);
1858: x_msg_data := FND_MESSAGE.get();
1859: x_msg_count := 1;

Line 1856: FND_MESSAGE.Set_token('PKG_NAME', G_PKG_NAME);

1852: END IF;
1853:
1854: IF (p_change_id IS NULL AND p_change_line_id IS NULL) THEN
1855: FND_MESSAGE.Set_name(G_APP_NAME, 'EGO_API_INVALID_PARAMS');
1856: FND_MESSAGE.Set_token('PKG_NAME', G_PKG_NAME);
1857: FND_MESSAGE.Set_Token('PROC_NAME', l_api_name);
1858: x_msg_data := FND_MESSAGE.get();
1859: x_msg_count := 1;
1860: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1857: FND_MESSAGE.Set_Token('PROC_NAME', l_api_name);

1853:
1854: IF (p_change_id IS NULL AND p_change_line_id IS NULL) THEN
1855: FND_MESSAGE.Set_name(G_APP_NAME, 'EGO_API_INVALID_PARAMS');
1856: FND_MESSAGE.Set_token('PKG_NAME', G_PKG_NAME);
1857: FND_MESSAGE.Set_Token('PROC_NAME', l_api_name);
1858: x_msg_data := FND_MESSAGE.get();
1859: x_msg_count := 1;
1860: x_return_status := FND_API.G_RET_STS_ERROR;
1861: RETURN;

Line 1858: x_msg_data := FND_MESSAGE.get();

1854: IF (p_change_id IS NULL AND p_change_line_id IS NULL) THEN
1855: FND_MESSAGE.Set_name(G_APP_NAME, 'EGO_API_INVALID_PARAMS');
1856: FND_MESSAGE.Set_token('PKG_NAME', G_PKG_NAME);
1857: FND_MESSAGE.Set_Token('PROC_NAME', l_api_name);
1858: x_msg_data := FND_MESSAGE.get();
1859: x_msg_count := 1;
1860: x_return_status := FND_API.G_RET_STS_ERROR;
1861: RETURN;
1862: END IF;

Line 1920: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);

1916: IF FND_API.To_Boolean(p_commit) THEN
1917: ROLLBACK TO Implement_Pending_Changes_SP;
1918: END IF;
1919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1920: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
1921: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
1922: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1923: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
1924: FND_MSG_PUB.Add;

Line 1921: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);

1917: ROLLBACK TO Implement_Pending_Changes_SP;
1918: END IF;
1919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1920: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
1921: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
1922: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1923: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
1924: FND_MSG_PUB.Add;
1925: FND_MSG_PUB.Count_And_Get(

Line 1922: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);

1918: END IF;
1919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1920: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
1921: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
1922: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1923: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
1924: FND_MSG_PUB.Add;
1925: FND_MSG_PUB.Count_And_Get(
1926: p_encoded => FND_API.G_FALSE,

Line 1923: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);

1919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1920: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
1921: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
1922: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1923: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
1924: FND_MSG_PUB.Add;
1925: FND_MSG_PUB.Count_And_Get(
1926: p_encoded => FND_API.G_FALSE,
1927: p_count => x_msg_count,

Line 2166: ERRBUF := FND_MESSAGE.Get_String('EGO', 'EGO_IPC_SUCCESS');

2162:
2163: END IF; -- if there are any orgs
2164:
2165: RETCODE := G_SUCCESS;
2166: ERRBUF := FND_MESSAGE.Get_String('EGO', 'EGO_IPC_SUCCESS');
2167:
2168: END Implement_Pending_Changes_CP;
2169:
2170: END EGO_ITEM_LC_IMP_PC_PUB;