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 955: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);

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

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

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

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

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

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

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

Line 960: x_msg_data := FND_MESSAGE.GET;

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

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

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

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

1156: ( (p_revision IS NOT NULL OR p_revision_id IS NOT NULL) AND p_status_code IS NOT NULL)
1157: OR
1158: (p_phase_id IS NULL AND p_status_code IS NULL)
1159: ) THEN
1160: fnd_message.Set_Name(G_APP_NAME, 'EGO_API_INVALID_PARAMS');
1161: fnd_message.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
1162: fnd_message.Set_Token(G_API_NAME_TOKEN, l_api_name);
1163: FND_MSG_PUB.Add;
1164: RAISE FND_API.G_EXC_ERROR;

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

1157: OR
1158: (p_phase_id IS NULL AND p_status_code IS NULL)
1159: ) THEN
1160: fnd_message.Set_Name(G_APP_NAME, 'EGO_API_INVALID_PARAMS');
1161: fnd_message.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
1162: fnd_message.Set_Token(G_API_NAME_TOKEN, l_api_name);
1163: FND_MSG_PUB.Add;
1164: RAISE FND_API.G_EXC_ERROR;
1165: END IF;

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

1158: (p_phase_id IS NULL AND p_status_code IS NULL)
1159: ) THEN
1160: fnd_message.Set_Name(G_APP_NAME, 'EGO_API_INVALID_PARAMS');
1161: fnd_message.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
1162: fnd_message.Set_Token(G_API_NAME_TOKEN, l_api_name);
1163: FND_MSG_PUB.Add;
1164: RAISE FND_API.G_EXC_ERROR;
1165: END IF;
1166:

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

1196: 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 );
1197:
1198: -- bug 3909677
1199: IF NVL(l_approval_status,'A') <> 'A' THEN
1200: fnd_message.Set_Name(G_APP_NAME, 'EGO_ITEM_NOT_READY_FOR_CHANGE');
1201: SELECT CONCATENATED_SEGMENTS
1202: INTO l_dummy_char
1203: FROM MTL_SYSTEM_ITEMS_KFV
1204: WHERE INVENTORY_ITEM_ID = p_inventory_item_id

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

1202: INTO l_dummy_char
1203: FROM MTL_SYSTEM_ITEMS_KFV
1204: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
1205: AND ORGANIZATION_ID = p_organization_id;
1206: fnd_message.set_token('ITEM_NUMBER', l_dummy_char);
1207: SELECT name
1208: INTO l_dummy_char
1209: FROM hr_all_organization_units_vl
1210: WHERE organization_id = p_organization_id;

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

1207: SELECT name
1208: INTO l_dummy_char
1209: FROM hr_all_organization_units_vl
1210: WHERE organization_id = p_organization_id;
1211: fnd_message.set_token('ORGANIZATION', l_dummy_char);
1212: fnd_msg_pub.Add;
1213: RAISE FND_API.G_EXC_ERROR;
1214: END IF;
1215:

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

1264: SELECT name
1265: INTO l_dummy_char
1266: FROM PA_EGO_PHASES_V
1267: WHERE proj_element_id = p_phase_id;
1268: fnd_message.Set_Name(G_APP_NAME, 'EGO_NO_STATUS_FOR_PHASE_ERR');
1269: fnd_message.Set_Token('PHASE', l_dummy_char);
1270: FND_MSG_PUB.Add;
1271: RAISE FND_API.G_EXC_ERROR;
1272: ELSE

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

1265: INTO l_dummy_char
1266: FROM PA_EGO_PHASES_V
1267: WHERE proj_element_id = p_phase_id;
1268: fnd_message.Set_Name(G_APP_NAME, 'EGO_NO_STATUS_FOR_PHASE_ERR');
1269: fnd_message.Set_Token('PHASE', l_dummy_char);
1270: FND_MSG_PUB.Add;
1271: RAISE FND_API.G_EXC_ERROR;
1272: ELSE
1273: CLOSE c_get_def_status_code;

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

1302: ELSE
1303: l_dummy_char := p_item_number;
1304: END IF;
1305: IF l_revision_id IS NULL THEN
1306: fnd_message.Set_Name(G_APP_NAME, 'EGO_ITEM_PENDING_PHASE_CHANGE');
1307: fnd_message.Set_Token('ITEM_NUMBER', l_dummy_char);
1308: FND_MSG_PUB.Add;
1309: RAISE FND_API.G_EXC_ERROR;
1310: ELSE

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

1303: l_dummy_char := p_item_number;
1304: END IF;
1305: IF l_revision_id IS NULL THEN
1306: fnd_message.Set_Name(G_APP_NAME, 'EGO_ITEM_PENDING_PHASE_CHANGE');
1307: fnd_message.Set_Token('ITEM_NUMBER', l_dummy_char);
1308: FND_MSG_PUB.Add;
1309: RAISE FND_API.G_EXC_ERROR;
1310: ELSE
1311: fnd_message.Set_Name(G_APP_NAME, 'EGO_REV_PENDING_PHASE_CHANGE');

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

1307: fnd_message.Set_Token('ITEM_NUMBER', l_dummy_char);
1308: FND_MSG_PUB.Add;
1309: RAISE FND_API.G_EXC_ERROR;
1310: ELSE
1311: fnd_message.Set_Name(G_APP_NAME, 'EGO_REV_PENDING_PHASE_CHANGE');
1312: fnd_message.Set_Token('ITEM_NUMBER', l_dummy_char);
1313: fnd_message.Set_Token('REVISION', l_revision);
1314: FND_MSG_PUB.Add;
1315: RAISE FND_API.G_EXC_ERROR;

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

1308: FND_MSG_PUB.Add;
1309: RAISE FND_API.G_EXC_ERROR;
1310: ELSE
1311: fnd_message.Set_Name(G_APP_NAME, 'EGO_REV_PENDING_PHASE_CHANGE');
1312: fnd_message.Set_Token('ITEM_NUMBER', l_dummy_char);
1313: fnd_message.Set_Token('REVISION', l_revision);
1314: FND_MSG_PUB.Add;
1315: RAISE FND_API.G_EXC_ERROR;
1316: END IF;

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

1309: RAISE FND_API.G_EXC_ERROR;
1310: ELSE
1311: fnd_message.Set_Name(G_APP_NAME, 'EGO_REV_PENDING_PHASE_CHANGE');
1312: fnd_message.Set_Token('ITEM_NUMBER', l_dummy_char);
1313: fnd_message.Set_Token('REVISION', l_revision);
1314: FND_MSG_PUB.Add;
1315: RAISE FND_API.G_EXC_ERROR;
1316: END IF;
1317: END IF; -- l_pending_rec_count

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

1343: );
1344: FETCH c_validate_status_code INTO l_status_code;
1345: IF c_validate_status_code%NOTFOUND THEN
1346: CLOSE c_validate_status_code;
1347: fnd_message.Set_Name(G_APP_NAME, 'EGO_ITEM_INVALID_STATUS');
1348: fnd_message.Set_Token('STATUS', p_status_code);
1349: SELECT name
1350: INTO l_dummy_char
1351: FROM PA_EGO_PHASES_V

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

1344: FETCH c_validate_status_code INTO l_status_code;
1345: IF c_validate_status_code%NOTFOUND THEN
1346: CLOSE c_validate_status_code;
1347: fnd_message.Set_Name(G_APP_NAME, 'EGO_ITEM_INVALID_STATUS');
1348: fnd_message.Set_Token('STATUS', p_status_code);
1349: SELECT name
1350: INTO l_dummy_char
1351: FROM PA_EGO_PHASES_V
1352: WHERE proj_element_id = NVL(p_phase_id,l_phase_id_curr);

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

1349: SELECT name
1350: INTO l_dummy_char
1351: FROM PA_EGO_PHASES_V
1352: WHERE proj_element_id = NVL(p_phase_id,l_phase_id_curr);
1353: fnd_message.Set_Token('PHASE', l_dummy_char);
1354: FND_MSG_PUB.Add;
1355: RAISE FND_API.G_EXC_ERROR;
1356: ELSE
1357: code_debug (l_api_name ||' checking for master controlled status ');

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

1360: l_status_master_controlled := get_master_controlled_status();
1361: IF ('T' = l_status_master_controlled) AND NOT ('T' = l_is_master_org) THEN
1362: IF l_status_code_itm <> l_status_code THEN
1363: code_debug (l_api_name ||' status changes controlled at master cannot change ');
1364: fnd_message.Set_Name(G_APP_NAME,'EGO_ITEM_STATUS_MC');
1365: fnd_msg_pub.Add;
1366: RAISE FND_API.G_EXC_ERROR;
1367: END IF;
1368: END IF; -- status is master controlled and we are in context of child org

Line 1381: fnd_message.Set_Name(G_APP_NAME, 'EGO_STATUS_INVALID');

1377: );
1378: FETCH c_item_validate_status_code INTO l_status_code;
1379: IF c_item_validate_status_code%NOTFOUND THEN
1380: CLOSE c_item_validate_status_code;
1381: fnd_message.Set_Name(G_APP_NAME, 'EGO_STATUS_INVALID');
1382: -- fnd_message.Set_Token('STATUS', p_status_code);
1383: -- SELECT name
1384: -- INTO l_dummy_char
1385: -- FROM PA_EGO_PHASES_V

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

1378: FETCH c_item_validate_status_code INTO l_status_code;
1379: IF c_item_validate_status_code%NOTFOUND THEN
1380: CLOSE c_item_validate_status_code;
1381: fnd_message.Set_Name(G_APP_NAME, 'EGO_STATUS_INVALID');
1382: -- fnd_message.Set_Token('STATUS', p_status_code);
1383: -- SELECT name
1384: -- INTO l_dummy_char
1385: -- FROM PA_EGO_PHASES_V
1386: -- WHERE proj_element_id = NVL(p_phase_id,l_phase_id_curr);

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

1383: -- SELECT name
1384: -- INTO l_dummy_char
1385: -- FROM PA_EGO_PHASES_V
1386: -- WHERE proj_element_id = NVL(p_phase_id,l_phase_id_curr);
1387: -- fnd_message.Set_Token('PHASE', l_dummy_char);
1388: FND_MSG_PUB.Add;
1389: RAISE FND_API.G_EXC_ERROR;
1390: ELSE
1391: code_debug (l_api_name ||' checking for master controlled status ');

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

1394: l_status_master_controlled := get_master_controlled_status();
1395: IF ('T' = l_status_master_controlled) AND NOT ('T' = l_is_master_org) THEN
1396: IF l_status_code_itm <> l_status_code THEN
1397: code_debug (l_api_name ||' status changes controlled at master cannot change ');
1398: fnd_message.Set_Name(G_APP_NAME,'EGO_ITEM_STATUS_MC');
1399: fnd_msg_pub.Add;
1400: RAISE FND_API.G_EXC_ERROR;
1401: END IF;
1402: END IF; -- status is master controlled and we are in context of child org

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

1496: IF c_validate_status_code%ISOPEN THEN
1497: CLOSE c_validate_status_code;
1498: END IF;
1499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1500: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
1501: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
1502: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1503: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
1504: FND_MSG_PUB.Add;

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

1497: CLOSE c_validate_status_code;
1498: END IF;
1499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1500: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
1501: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
1502: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1503: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
1504: FND_MSG_PUB.Add;
1505: END Create_Pending_Phase_Change;

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

1498: END IF;
1499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1500: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
1501: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
1502: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1503: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
1504: FND_MSG_PUB.Add;
1505: END Create_Pending_Phase_Change;
1506:

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

1499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1500: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
1501: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
1502: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1503: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
1504: FND_MSG_PUB.Add;
1505: END Create_Pending_Phase_Change;
1506:
1507:

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

1567: p_effective_date IS NULL
1568: OR
1569: p_transaction_type NOT IN (EGO_ITEM_PUB.G_TTYPE_UPDATE, EGO_ITEM_PUB.G_TTYPE_DELETE)
1570: ) THEN
1571: fnd_message.Set_Name(G_APP_NAME, 'EGO_API_INVALID_PARAMS');
1572: fnd_message.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
1573: fnd_message.Set_Token(G_API_NAME_TOKEN, l_api_name);
1574: FND_MSG_PUB.Add;
1575: RAISE FND_API.G_EXC_ERROR;

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

1568: OR
1569: p_transaction_type NOT IN (EGO_ITEM_PUB.G_TTYPE_UPDATE, EGO_ITEM_PUB.G_TTYPE_DELETE)
1570: ) THEN
1571: fnd_message.Set_Name(G_APP_NAME, 'EGO_API_INVALID_PARAMS');
1572: fnd_message.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
1573: fnd_message.Set_Token(G_API_NAME_TOKEN, l_api_name);
1574: FND_MSG_PUB.Add;
1575: RAISE FND_API.G_EXC_ERROR;
1576: END IF;

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

1569: p_transaction_type NOT IN (EGO_ITEM_PUB.G_TTYPE_UPDATE, EGO_ITEM_PUB.G_TTYPE_DELETE)
1570: ) THEN
1571: fnd_message.Set_Name(G_APP_NAME, 'EGO_API_INVALID_PARAMS');
1572: fnd_message.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
1573: fnd_message.Set_Token(G_API_NAME_TOKEN, l_api_name);
1574: FND_MSG_PUB.Add;
1575: RAISE FND_API.G_EXC_ERROR;
1576: END IF;
1577:

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

1627: AND implemented_date IS NULL;
1628: IF SQL%ROWCOUNT = 0 THEN
1629: code_debug(l_api_name|| ' cannot update record!! ');
1630: -- no records found for update
1631: fnd_message.Set_Name(G_APP_NAME, 'EGO_NO_REC_UPDATE');
1632: FND_MSG_PUB.Add;
1633: RAISE FND_API.G_EXC_ERROR;
1634: END IF;
1635:

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

1651: AND pending_flag = 'Y'
1652: AND implemented_date IS NULL;
1653: IF SQL%ROWCOUNT = 0 THEN
1654: -- no records found for delete
1655: fnd_message.Set_Name(G_APP_NAME, 'EGO_NO_REC_DELETE');
1656: FND_MSG_PUB.Add;
1657: RAISE FND_API.G_EXC_ERROR;
1658: END IF;
1659:

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

1812: IF FND_API.To_Boolean(p_commit) THEN
1813: ROLLBACK TO Delete_Pending_Phase_Change_SP;
1814: END IF;
1815: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1816: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
1817: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
1818: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1819: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
1820: FND_MSG_PUB.Add;

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

1813: ROLLBACK TO Delete_Pending_Phase_Change_SP;
1814: END IF;
1815: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1816: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
1817: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
1818: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1819: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
1820: FND_MSG_PUB.Add;
1821:

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

1814: END IF;
1815: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1816: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
1817: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
1818: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1819: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
1820: FND_MSG_PUB.Add;
1821:
1822: END Delete_Pending_Phase_Change;

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

1815: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1816: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
1817: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
1818: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1819: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
1820: FND_MSG_PUB.Add;
1821:
1822: END Delete_Pending_Phase_Change;
1823: ***/

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

1918: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1919: END IF;
1920:
1921: IF (p_change_id IS NULL AND p_change_line_id IS NULL) THEN
1922: FND_MESSAGE.Set_name(G_APP_NAME, 'EGO_API_INVALID_PARAMS');
1923: FND_MESSAGE.Set_token('PKG_NAME', G_PKG_NAME);
1924: FND_MESSAGE.Set_Token('PROC_NAME', l_api_name);
1925: x_msg_data := FND_MESSAGE.get();
1926: x_msg_count := 1;

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

1919: END IF;
1920:
1921: IF (p_change_id IS NULL AND p_change_line_id IS NULL) THEN
1922: FND_MESSAGE.Set_name(G_APP_NAME, 'EGO_API_INVALID_PARAMS');
1923: FND_MESSAGE.Set_token('PKG_NAME', G_PKG_NAME);
1924: FND_MESSAGE.Set_Token('PROC_NAME', l_api_name);
1925: x_msg_data := FND_MESSAGE.get();
1926: x_msg_count := 1;
1927: x_return_status := FND_API.G_RET_STS_ERROR;

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

1920:
1921: IF (p_change_id IS NULL AND p_change_line_id IS NULL) THEN
1922: FND_MESSAGE.Set_name(G_APP_NAME, 'EGO_API_INVALID_PARAMS');
1923: FND_MESSAGE.Set_token('PKG_NAME', G_PKG_NAME);
1924: FND_MESSAGE.Set_Token('PROC_NAME', l_api_name);
1925: x_msg_data := FND_MESSAGE.get();
1926: x_msg_count := 1;
1927: x_return_status := FND_API.G_RET_STS_ERROR;
1928: RETURN;

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

1921: IF (p_change_id IS NULL AND p_change_line_id IS NULL) THEN
1922: FND_MESSAGE.Set_name(G_APP_NAME, 'EGO_API_INVALID_PARAMS');
1923: FND_MESSAGE.Set_token('PKG_NAME', G_PKG_NAME);
1924: FND_MESSAGE.Set_Token('PROC_NAME', l_api_name);
1925: x_msg_data := FND_MESSAGE.get();
1926: x_msg_count := 1;
1927: x_return_status := FND_API.G_RET_STS_ERROR;
1928: RETURN;
1929: END IF;

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

1983: IF FND_API.To_Boolean(p_commit) THEN
1984: ROLLBACK TO Implement_Pending_Changes_SP;
1985: END IF;
1986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1987: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
1988: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
1989: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1990: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
1991: FND_MSG_PUB.Add;

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

1984: ROLLBACK TO Implement_Pending_Changes_SP;
1985: END IF;
1986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1987: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
1988: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
1989: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1990: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
1991: FND_MSG_PUB.Add;
1992: FND_MSG_PUB.Count_And_Get(

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

1985: END IF;
1986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1987: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
1988: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
1989: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1990: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
1991: FND_MSG_PUB.Add;
1992: FND_MSG_PUB.Count_And_Get(
1993: p_encoded => FND_API.G_FALSE,

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

1986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1987: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
1988: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
1989: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1990: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
1991: FND_MSG_PUB.Add;
1992: FND_MSG_PUB.Count_And_Get(
1993: p_encoded => FND_API.G_FALSE,
1994: p_count => x_msg_count,

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

2229:
2230: END IF; -- if there are any orgs
2231:
2232: RETCODE := G_SUCCESS;
2233: ERRBUF := FND_MESSAGE.Get_String('EGO', 'EGO_IPC_SUCCESS');
2234:
2235: END Implement_Pending_Changes_CP;
2236:
2237: END EGO_ITEM_LC_IMP_PC_PUB;