DBA Data[Home] [Help]

APPS.EGO_ITEM_LC_IMP_PC_PUB dependencies on FND_MSG_PUB

Line 939: FND_MSG_PUB.Count_And_Get(

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

Line 1163: FND_MSG_PUB.Add;

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

Line 1212: fnd_msg_pub.Add;

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

Line 1270: FND_MSG_PUB.Add;

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

Line 1308: FND_MSG_PUB.Add;

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

Line 1314: FND_MSG_PUB.Add;

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

Line 1354: FND_MSG_PUB.Add;

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

Line 1365: fnd_msg_pub.Add;

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

Line 1388: FND_MSG_PUB.Add;

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

Line 1399: fnd_msg_pub.Add;

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

Line 1504: FND_MSG_PUB.Add;

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

Line 1574: FND_MSG_PUB.Add;

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

Line 1632: FND_MSG_PUB.Add;

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

Line 1656: FND_MSG_PUB.Add;

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

Line 1820: FND_MSG_PUB.Add;

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

Line 1970: FND_MSG_PUB.Count_And_Get(

1966: COMMIT WORK;
1967: END IF;
1968: ELSE
1969: IF x_msg_count <>1 THEN
1970: FND_MSG_PUB.Count_And_Get(
1971: p_encoded => FND_API.G_FALSE,
1972: p_count => x_msg_count,
1973: p_data => x_msg_data
1974: );

Line 1991: FND_MSG_PUB.Add;

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

Line 1992: FND_MSG_PUB.Count_And_Get(

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,
1995: p_data => x_msg_data
1996: );