DBA Data[Home] [Help]

APPS.PQH_GENERIC_HIERARCHY_PACKAGE dependencies on FND_MSG_PUB

Line 522: fnd_msg_pub.initialize;

518: end if;
519: --
520: -- Initialize message pub
521: --
522: fnd_msg_pub.initialize;
523: --
524: -- check for version existance
525: --
526: Open csr_version_exists;

Line 548: fnd_msg_pub.add;

544: --
545: Exception
546: when others
547: then
548: fnd_msg_pub.add;
549: End chk_version_exists;
550: --
551: -- ----------------------------------------------------------------------------
552: -- |----------------------< create_lookup_and_shared_type>--------------------|

Line 803: fnd_msg_pub.add;

799: end if;
800: fnd_message.set_name('PQH','PQH_GHR_LOOKUP_INS_FAIL');
801: fnd_message.set_token('TYPE',p_lookup_type);
802: fnd_message.set_token('CODE',p_lookup_code);
803: fnd_msg_pub.add;
804: end create_lookup_value;
805: -- ----------------------------------------------------------------------------
806: -- |--------------------------< update_lookup_value >-------------------------|
807: -- ----------------------------------------------------------------------------

Line 979: fnd_msg_pub.add;

975: hr_utility.set_location('Unexpected Error'||l_proc, 60);
976: end if;
977: hr_multi_message.disable_message_list;
978: fnd_message.set_name('PQH','PQH_GHR_SHARED_TYPE_INS_FAIL');
979: fnd_msg_pub.add;
980: end create_shared_type;
981: --
982: -- ----------------------------------------------------------------------------
983: -- |--------------------------< update_shared_type >-------------------------|

Line 1022: fnd_msg_pub.initialize;

1018: --
1019: savepoint update_shared_type;
1020: --
1021: -- Initialize message pub
1022: fnd_msg_pub.initialize;
1023: --
1024: -- Check for duplicate shared type entry
1025: open csr_shared_type_entry;
1026: fetch csr_shared_type_entry into l_shared_type_id,l_object_version_number;

Line 1072: fnd_msg_pub.add;

1068: rollback to update_shared_type;
1069: if g_debug then
1070: hr_utility.set_location('An Error has occured:', 50);
1071: end if;
1072: fnd_msg_pub.add;
1073: end update_shared_type;
1074: --
1075: -- ----------------------------------------------------------------------------
1076: -- |--------------------------< create_node_type >---------------------------|

Line 1136: fnd_msg_pub.initialize;

1132: --
1133: Savepoint create_node_type;
1134: --
1135: -- Initialize message pub
1136: fnd_msg_pub.initialize;
1137: --
1138: -- Insert Validate
1139: --
1140: Open csr_chk_duplicate;

Line 1208: fnd_msg_pub.add;

1204: then
1205: if g_debug then
1206: hr_utility.set_location('An Error has occured', 70);
1207: end if;
1208: fnd_msg_pub.add;
1209: rollback to create_node_type;
1210: end create_node_type;
1211: --
1212: --

Line 1257: fnd_msg_pub.initialize;

1253: Savepoint update_node_type;
1254: --
1255: --Initialize message pub
1256: --
1257: fnd_msg_pub.initialize;
1258: --
1259: --Check that the node type entry exists
1260: --
1261: Open csr_node_type_entry;

Line 1326: fnd_msg_pub.add;

1322: end if;
1323: --
1324: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
1325: fnd_message.set_token('TABLE_NAME', 'per_gen_hier_node_types');
1326: fnd_msg_pub.add;
1327: When others
1328: then
1329: if g_debug then
1330: hr_utility.set_location('An Error has occured', 70);

Line 1333: fnd_msg_pub.add;

1329: if g_debug then
1330: hr_utility.set_location('An Error has occured', 70);
1331: end if;
1332: rollback to update_node_type;
1333: fnd_msg_pub.add;
1334: end update_node_type;
1335: --
1336: --
1337: -- ----------------------------------------------------------------------------

Line 1393: fnd_msg_pub.initialize;

1389: Savepoint delete_node_type;
1390:
1391: --Initialize message pub
1392: --
1393: fnd_msg_pub.initialize;
1394: --
1395: --
1396: --Check that the node type entry exists
1397: --

Line 1451: fnd_msg_pub.add;

1447: hr_utility.set_location('Error: Object Locked', 50);
1448: end if;
1449: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
1450: fnd_message.set_token('TABLE_NAME', 'per_gen_hier_node_types');
1451: fnd_msg_pub.add;
1452: When others
1453: then
1454: if g_debug then
1455: hr_utility.set_location('An Error has Occured', 60);

Line 1458: fnd_msg_pub.add;

1454: if g_debug then
1455: hr_utility.set_location('An Error has Occured', 60);
1456: end if;
1457: rollback to delete_node_type;
1458: fnd_msg_pub.add;
1459: End delete_node_type;
1460: --
1461: --
1462: --

Line 1491: fnd_msg_pub.initialize;

1487: end if;
1488: --
1489: -- Initialize message pub
1490: --
1491: fnd_msg_pub.initialize;
1492: --
1493: -- Issue a savepoint
1494: --
1495: Savepoint delete_type_structure;

Line 1524: fnd_msg_pub.add;

1520: if g_debug then
1521: hr_utility.set_location('An Error has occured', 40);
1522: end if;
1523: Rollback to delete_type_structure;
1524: fnd_msg_pub.add;
1525: End delete_type_structure;
1526: --
1527: --
1528: -- ----------------------------------------------------------------------------

Line 1610: fnd_msg_pub.initialize;

1606: end if;
1607: --
1608: -- Initialize message pub
1609: --
1610: fnd_msg_pub.initialize;
1611: --
1612: if g_debug then
1613: hr_utility.set_location('Calling copy proc. with p_type='||p_type, 20);
1614: end if;

Line 1804: fnd_msg_pub.add();

1800: --
1801: if g_debug then
1802: hr_utility.set_location('An Error has occured', 40);
1803: end if;
1804: fnd_msg_pub.add();
1805: End copy_hierarchy_version;
1806: --
1807: --
1808: --