DBA Data[Home] [Help]

APPS.EGO_ITEM_LC_IMP_PC_PUB dependencies on FND_MSG_PUB

Line 937: FND_MSG_PUB.Count_And_Get(

933: IF FND_API.To_Boolean( p_commit ) THEN
934: ROLLBACK TO Implement_All_Pending_Changes;
935: END IF;
936: x_return_status := FND_API.G_RET_STS_ERROR;
937: FND_MSG_PUB.Count_And_Get(
938: p_encoded => FND_API.G_FALSE,
939: p_count => x_msg_count,
940: p_data => x_msg_data
941: );

Line 1154: FND_MSG_PUB.Add;

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:
1158: l_revision := p_revision;

Line 1203: fnd_msg_pub.Add;

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:
1207: IF FND_API.To_Boolean(p_perform_security_check) THEN

Line 1261: FND_MSG_PUB.Add;

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

Line 1299: FND_MSG_PUB.Add;

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');
1303: fnd_message.Set_Token('ITEM_NUMBER', l_dummy_char);

Line 1305: FND_MSG_PUB.Add;

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
1309: END IF; -- NVL(l_phase_id_curr,-1) <> p_phase_id

Line 1331: FND_MSG_PUB.Add;

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 ');
1335: l_is_master_org := get_master_org_status(p_organization_id);

Line 1342: fnd_msg_pub.Add;

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
1346: END IF; -- status is valid

Line 1442: FND_MSG_PUB.Add;

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

Line 1512: FND_MSG_PUB.Add;

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:
1516: IF FND_API.To_Boolean(p_perform_security_check) THEN

Line 1570: FND_MSG_PUB.Add;

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:
1574: ELSIF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_DELETE THEN

Line 1594: FND_MSG_PUB.Add;

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

Line 1758: FND_MSG_PUB.Add;

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: ***/
1762:

Line 1903: FND_MSG_PUB.Count_And_Get(

1899: COMMIT WORK;
1900: END IF;
1901: ELSE
1902: IF x_msg_count <>1 THEN
1903: FND_MSG_PUB.Count_And_Get(
1904: p_encoded => FND_API.G_FALSE,
1905: p_count => x_msg_count,
1906: p_data => x_msg_data
1907: );

Line 1924: FND_MSG_PUB.Add;

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,
1928: p_data => x_msg_data

Line 1925: FND_MSG_PUB.Count_And_Get(

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,
1928: p_data => x_msg_data
1929: );