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.AHL_MC_PATH_POSITION_PVT dependencies on FND_MSG_PUB

Line 128: FND_MSG_PUB.Initialize;

124: END IF;
125:
126: -- Initialize message list if p_init_msg_list is set to TRUE
127: IF FND_API.To_Boolean(p_init_msg_list) THEN
128: FND_MSG_PUB.Initialize;
129: END IF;
130:
131: --initialize ver spec score;
132: l_ver_spec_score := 0;

Line 151: FND_MSG_PUB.ADD;

147: FND_MESSAGE.Set_Name('AHL','AHL_MC_PATH_NODE_INV');
148: FND_MESSAGE.Set_Token('MC_ID',l_pos_rec.mc_id);
149: FND_MESSAGE.Set_Token('VER',l_pos_rec.version_number);
150: FND_MESSAGE.Set_Token('POS_KEY',l_pos_rec.position_key);
151: FND_MSG_PUB.ADD;
152: END IF;
153: CLOSE check_mc_ids_csr;
154:
155: IF (l_pos_rec.version_number IS NOT NULL AND

Line 172: FND_MSG_PUB.ADD;

168: FND_MESSAGE.Set_Name('AHL','AHL_MC_PATH_RELNSHIP_INV');
169: FND_MESSAGE.Set_Token('MC_ID',p_path_position_tbl(i+1).mc_id);
170: FND_MESSAGE.Set_Token('VER',p_path_position_tbl(i+1).version_number);
171: FND_MESSAGE.Set_Token('POS_KEY',l_pos_rec.position_key);
172: FND_MSG_PUB.ADD;
173: END IF;
174: CLOSE check_mc_relationships_csr;
175: END IF;
176:

Line 193: FND_MSG_PUB.ADD;

189: l_return_val);
190: IF NOT(l_return_val) THEN
191: FND_MESSAGE.Set_Name('AHL','AHL_MC_POSREF_INVALID');
192: FND_MESSAGE.Set_Token('POSREF',p_position_ref_meaning);
193: FND_MSG_PUB.ADD;
194: END IF;
195: END IF;
196: ELSE
197: l_position_ref_code := p_position_ref_code;

Line 201: l_msg_count := FND_MSG_PUB.count_msg;

197: l_position_ref_code := p_position_ref_code;
198: END IF;
199:
200: -- Check Error Message stack.
201: l_msg_count := FND_MSG_PUB.count_msg;
202: IF l_msg_count > 0 THEN
203: RAISE FND_API.G_EXC_ERROR;
204: END IF;
205:

Line 219: FND_MSG_PUB.ADD;

215: l_sib_pos_ref_code := get_posref_by_path(l_path_tbl, FND_API.G_TRUE);
216: IF (l_sib_pos_ref_code = l_position_ref_code) THEN
217: FND_MESSAGE.Set_Name('AHL','AHL_MC_POSREF_DUPLICATE');
218: FND_MESSAGE.Set_Token('POSREF',l_position_ref_code);
219: FND_MSG_PUB.ADD;
220: END IF;
221: END LOOP;
222: CLOSE get_sibling_poskey_csr;
223: END IF;

Line 226: l_msg_count := FND_MSG_PUB.count_msg;

222: CLOSE get_sibling_poskey_csr;
223: END IF;
224:
225: -- Check Error Message stack.
226: l_msg_count := FND_MSG_PUB.count_msg;
227: IF l_msg_count > 0 THEN
228: RAISE FND_API.G_EXC_ERROR;
229: END IF;
230:

Line 392: FND_MSG_PUB.Count_And_Get

388: IF FND_API.TO_BOOLEAN(p_commit) THEN
389: COMMIT WORK;
390: END IF;
391: -- Standard call to get message count and if count is 1, get message info
392: FND_MSG_PUB.Count_And_Get
393: ( p_count => x_msg_count,
394: p_data => x_msg_data,
395: p_encoded => fnd_api.g_false
396: );

Line 401: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

397: EXCEPTION
398: WHEN FND_API.G_EXC_ERROR THEN
399: Rollback to Create_Position_ID_pvt;
400: x_return_status := FND_API.G_RET_STS_ERROR;
401: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
402: p_data => x_msg_data,
403: p_encoded => fnd_api.g_false);
404: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
405: Rollback to Create_Position_ID_pvt;

Line 407: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

403: p_encoded => fnd_api.g_false);
404: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
405: Rollback to Create_Position_ID_pvt;
406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
407: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
408: p_data => x_msg_data,
409: p_encoded => fnd_api.g_false);
410: WHEN OTHERS THEN
411: Rollback to Create_Position_ID_pvt;

Line 413: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,

409: p_encoded => fnd_api.g_false);
410: WHEN OTHERS THEN
411: Rollback to Create_Position_ID_pvt;
412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
413: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
414: p_procedure_name => l_api_name,
415: p_error_text => SQLERRM);
416: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
417: p_data => x_msg_data,

Line 416: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
413: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
414: p_procedure_name => l_api_name,
415: p_error_text => SQLERRM);
416: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
417: p_data => x_msg_data,
418: p_encoded => fnd_api.g_false);
419:
420: END Create_Position_ID;

Line 550: FND_MSG_PUB.Initialize;

546: END IF;
547:
548: -- Initialize message list if p_init_msg_list is set to TRUE
549: IF FND_API.To_Boolean(p_init_msg_list) THEN
550: FND_MSG_PUB.Initialize;
551: END IF;
552:
553: --Fetch the position informations for the instance
554: OPEN get_last_uc_rec_csr(p_csi_item_instance_id);

Line 665: FND_MSG_PUB.Count_And_Get

661: END IF;
662: CLOSE get_last_uc_rec_csr;
663:
664: -- Standard call to get message count and if count is 1, get message info
665: FND_MSG_PUB.Count_And_Get
666: ( p_count => x_msg_count,
667: p_data => x_msg_data,
668: p_encoded => fnd_api.g_false
669: );

Line 674: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

670: EXCEPTION
671: WHEN FND_API.G_EXC_ERROR THEN
672: Rollback to Map_Instance_To_Positions_pvt;
673: x_return_status := FND_API.G_RET_STS_ERROR;
674: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
675: p_data => x_msg_data,
676: p_encoded => fnd_api.g_false);
677: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
678: Rollback to Map_Instance_To_Positions_pvt;

Line 680: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

676: p_encoded => fnd_api.g_false);
677: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
678: Rollback to Map_Instance_To_Positions_pvt;
679: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
680: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
681: p_data => x_msg_data,
682: p_encoded => fnd_api.g_false);
683: WHEN OTHERS THEN
684: Rollback to Map_Instance_To_Positions_pvt;

Line 686: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,

682: p_encoded => fnd_api.g_false);
683: WHEN OTHERS THEN
684: Rollback to Map_Instance_To_Positions_pvt;
685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
686: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
687: p_procedure_name => l_api_name,
688: p_error_text => SQLERRM);
689: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
690: p_data => x_msg_data,

Line 689: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
686: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
687: p_procedure_name => l_api_name,
688: p_error_text => SQLERRM);
689: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
690: p_data => x_msg_data,
691: p_encoded => fnd_api.g_false);
692: END Map_Instance_To_Positions;
693:

Line 776: FND_MSG_PUB.Initialize;

772: END IF;
773:
774: -- Initialize message list if p_init_msg_list is set to TRUE
775: IF FND_API.To_Boolean(p_init_msg_list) THEN
776: FND_MSG_PUB.Initialize;
777: END IF;
778:
779: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
780: fnd_log.string(fnd_log.level_statement,l_full_name,'-- p_position_id --'||p_position_id);

Line 931: FND_MSG_PUB.Count_And_Get

927: COMMIT WORK;
928: END IF;
929:
930: -- Standard call to get message count and if count is 1, get message info
931: FND_MSG_PUB.Count_And_Get
932: ( p_count => x_msg_count,
933: p_data => x_msg_data,
934: p_encoded => fnd_api.g_false
935: );

Line 945: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

941: EXCEPTION
942: WHEN FND_API.G_EXC_ERROR THEN
943: Rollback to map_position_to_instances_pvt;
944: x_return_status := FND_API.G_RET_STS_ERROR;
945: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
946: p_data => x_msg_data,
947: p_encoded => fnd_api.g_false);
948: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
949: Rollback to map_position_to_instances_pvt;

Line 951: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

947: p_encoded => fnd_api.g_false);
948: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
949: Rollback to map_position_to_instances_pvt;
950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
951: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
952: p_data => x_msg_data,
953: p_encoded => fnd_api.g_false);
954: WHEN OTHERS THEN
955: Rollback to map_position_to_instances_pvt;

Line 957: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,

953: p_encoded => fnd_api.g_false);
954: WHEN OTHERS THEN
955: Rollback to map_position_to_instances_pvt;
956: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
957: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
958: p_procedure_name => l_api_name,
959: p_error_text => SQLERRM);
960: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
961: p_data => x_msg_data,

Line 960: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

956: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
957: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
958: p_procedure_name => l_api_name,
959: p_error_text => SQLERRM);
960: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
961: p_data => x_msg_data,
962: p_encoded => fnd_api.g_false);
963: END Map_Position_To_Instances;
964:

Line 1149: FND_MSG_PUB.Initialize;

1145: END IF;
1146:
1147: -- Initialize message list if p_init_msg_list is set to TRUE
1148: IF FND_API.To_Boolean(p_init_msg_list) THEN
1149: FND_MSG_PUB.Initialize;
1150: END IF;
1151:
1152: --Step 0) Validate that p_csi_item_instance is not null and valid
1153: IF (p_csi_item_instance_id IS NULL) THEN

Line 1155: FND_MSG_PUB.ADD;

1151:
1152: --Step 0) Validate that p_csi_item_instance is not null and valid
1153: IF (p_csi_item_instance_id IS NULL) THEN
1154: FND_MESSAGE.Set_Name('AHL','AHL_MC_POS_INSTANCE_ID_NULL');
1155: FND_MSG_PUB.ADD;
1156: RAISE FND_API.G_EXC_ERROR;
1157: END IF;
1158: --Validate that the input instance is a unit
1159: OPEN check_instance_top_csr (p_csi_item_instance_id);

Line 1163: FND_MSG_PUB.ADD;

1159: OPEN check_instance_top_csr (p_csi_item_instance_id);
1160: FETCH check_instance_top_csr INTO l_dummy;
1161: IF (check_instance_top_csr%NOTFOUND) THEN
1162: FND_MESSAGE.Set_Name('AHL','AHL_MC_POS_INSTANCE_ID_INV');
1163: FND_MSG_PUB.ADD;
1164: RAISE FND_API.G_EXC_ERROR;
1165: END IF;
1166: CLOSE check_instance_top_csr;
1167:

Line 1187: FND_MSG_PUB.ADD;

1183: -- Populate the lowest level instance id based on this query.
1184: --If table is less than 1 in size, this is invalid path
1185: IF (l_path_tbl.COUNT<1) THEN
1186: FND_MESSAGE.Set_Name('AHL','AHL_MC_POS_PATH_ID_INV');
1187: FND_MSG_PUB.ADD;
1188: RAISE FND_API.G_EXC_ERROR;
1189:
1190: --If there is only 1 row, then lowest level UC = p_csi_instance_id
1191: ELSIF (l_path_tbl.COUNT =1) THEN

Line 1310: FND_MSG_PUB.Count_And_Get

1306: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1307: fnd_log.string(fnd_log.level_procedure, l_full_name||'.end', 'At the end of PLSQL procedure. About to count and get error messages.');
1308: END IF;
1309: -- Standard call to get message count and if count is 1, get message info
1310: FND_MSG_PUB.Count_And_Get
1311: ( p_count => x_msg_count,
1312: p_data => x_msg_data,
1313: p_encoded => fnd_api.g_false
1314: );

Line 1319: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

1315: EXCEPTION
1316: WHEN FND_API.G_EXC_ERROR THEN
1317: Rollback to Get_Pos_Empty_Instance_pvt;
1318: x_return_status := FND_API.G_RET_STS_ERROR;
1319: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1320: p_data => x_msg_data,
1321: p_encoded => fnd_api.g_false);
1322: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1323: Rollback to Get_Pos_Empty_Instance_pvt;

Line 1325: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

1321: p_encoded => fnd_api.g_false);
1322: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1323: Rollback to Get_Pos_Empty_Instance_pvt;
1324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1325: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1326: p_data => x_msg_data,
1327: p_encoded => fnd_api.g_false);
1328: WHEN OTHERS THEN
1329: Rollback to Get_Pos_Empty_Instance_pvt;

Line 1331: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,

1327: p_encoded => fnd_api.g_false);
1328: WHEN OTHERS THEN
1329: Rollback to Get_Pos_Empty_Instance_pvt;
1330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1331: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
1332: p_procedure_name => l_api_name,
1333: p_error_text => SQLERRM);
1334: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1335: p_data => x_msg_data,

Line 1334: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

1330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1331: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
1332: p_procedure_name => l_api_name,
1333: p_error_text => SQLERRM);
1334: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1335: p_data => x_msg_data,
1336: p_encoded => fnd_api.g_false);
1337: END Get_Pos_Instance;
1338:

Line 1484: FND_MSG_PUB.Initialize;

1480: END IF;
1481:
1482: -- Initialize message list if p_init_msg_list is set to TRUE
1483: IF FND_API.To_Boolean(p_init_msg_list) THEN
1484: FND_MSG_PUB.Initialize;
1485: END IF;
1486:
1487: --Check Status of MC allows for editing
1488: OPEN check_mc_status_csr(p_to_mc_header_id);

Line 1493: FND_MSG_PUB.ADD;

1489: FETCH check_mc_status_csr INTO l_status_code, l_status;
1490: IF (check_mc_status_csr%NOTFOUND) THEN
1491: FND_MESSAGE.Set_Name('AHL','AHL_UC_MC_HEADER_ID_INVALID');
1492: FND_MESSAGE.Set_Token('MC_HEADER_ID',p_to_mc_header_id);
1493: FND_MSG_PUB.ADD;
1494: CLOSE check_mc_status_csr;
1495: RAISE FND_API.G_EXC_ERROR;
1496: ELSIF ( l_status_code <> 'DRAFT' AND
1497: l_status_code <> 'APPROVAL_REJECTED') THEN

Line 1500: FND_MSG_PUB.ADD;

1496: ELSIF ( l_status_code <> 'DRAFT' AND
1497: l_status_code <> 'APPROVAL_REJECTED') THEN
1498: FND_MESSAGE.Set_Name('AHL','AHL_MC_EDIT_INV_MC');
1499: FND_MESSAGE.Set_Token('STATUS', l_status);
1500: FND_MSG_PUB.ADD;
1501: CLOSE check_mc_status_csr;
1502: RAISE FND_API.G_EXC_ERROR;
1503: END IF;
1504: CLOSE check_mc_status_csr;

Line 1577: FND_MSG_PUB.Count_And_Get

1573: IF FND_API.TO_BOOLEAN(p_commit) THEN
1574: COMMIT WORK;
1575: END IF;
1576: -- Standard call to get message count and if count is 1, get message info
1577: FND_MSG_PUB.Count_And_Get
1578: ( p_count => x_msg_count,
1579: p_data => x_msg_data,
1580: p_encoded => fnd_api.g_false
1581: );

Line 1586: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

1582: EXCEPTION
1583: WHEN FND_API.G_EXC_ERROR THEN
1584: Rollback to Copy_Positions_For_Mc_pvt;
1585: x_return_status := FND_API.G_RET_STS_ERROR;
1586: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1587: p_data => x_msg_data,
1588: p_encoded => fnd_api.g_false);
1589: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1590: Rollback to Copy_Positions_For_Mc_pvt;

Line 1592: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

1588: p_encoded => fnd_api.g_false);
1589: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1590: Rollback to Copy_Positions_For_Mc_pvt;
1591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1592: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1593: p_data => x_msg_data,
1594: p_encoded => fnd_api.g_false);
1595: WHEN OTHERS THEN
1596: Rollback to Copy_Positions_For_Mc_pvt;

Line 1598: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,

1594: p_encoded => fnd_api.g_false);
1595: WHEN OTHERS THEN
1596: Rollback to Copy_Positions_For_Mc_pvt;
1597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1598: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
1599: p_procedure_name => l_api_name,
1600: p_error_text => SQLERRM);
1601: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1602: p_data => x_msg_data,

Line 1601: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

1597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1598: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
1599: p_procedure_name => l_api_name,
1600: p_error_text => SQLERRM);
1601: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1602: p_data => x_msg_data,
1603: p_encoded => fnd_api.g_false);
1604: END Copy_Positions_For_MC;
1605:

Line 1677: FND_MSG_PUB.Initialize;

1673: END IF;
1674:
1675: -- Initialize message list if p_init_msg_list is set to TRUE
1676: IF FND_API.To_Boolean(p_init_msg_list) THEN
1677: FND_MSG_PUB.Initialize;
1678: END IF;
1679:
1680: --Fetch the to mc_header_id information
1681: OPEN get_mc_id_ver_csr(p_to_mc_header_id);

Line 1687: FND_MSG_PUB.ADD;

1683: IF (get_mc_id_ver_csr%NOTFOUND) THEN
1684: FND_MESSAGE.Set_Name('AHL','AHL_MC_HEADER_ID_INVALID');
1685: FND_MESSAGE.Set_Token('NAME','');
1686: FND_MESSAGE.Set_Token('MC_HEADER_ID',p_to_mc_header_id);
1687: FND_MSG_PUB.ADD;
1688: CLOSE get_mc_id_ver_csr;
1689: RAISE FND_API.G_EXC_ERROR;
1690: END IF;
1691: CLOSE get_mc_id_ver_csr;

Line 1741: x_msg_count := FND_MSG_PUB.count_msg;

1737: FETCH get_path_position_ref_csr INTO l_pos_ref_code;
1738: CLOSE get_path_position_ref_csr;
1739:
1740: -- Check Error Message stack.
1741: x_msg_count := FND_MSG_PUB.count_msg;
1742: IF x_msg_count > 0 THEN
1743: RAISE FND_API.G_EXC_ERROR;
1744: END IF;
1745:

Line 1764: FND_MSG_PUB.Initialize;

1760: -- Suppress the validation errors from Create API.
1761: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1762: --Suppress the expected errors
1763: --Clean out the messages
1764: FND_MSG_PUB.Initialize;
1765: x_position_id := null;
1766: x_return_status := FND_API.G_RET_STS_SUCCESS;
1767: x_msg_count := 0;
1768: x_msg_data := null;

Line 1789: FND_MSG_PUB.Count_And_Get

1785: COMMIT WORK;
1786: END IF;
1787:
1788: -- Standard call to get message count and if count is 1, get message info
1789: FND_MSG_PUB.Count_And_Get
1790: ( p_count => x_msg_count,
1791: p_data => x_msg_data,
1792: p_encoded => fnd_api.g_false
1793: );

Line 1798: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

1794: EXCEPTION
1795: WHEN FND_API.G_EXC_ERROR THEN
1796: Rollback to Copy_Position_pvt;
1797: x_return_status := FND_API.G_RET_STS_ERROR;
1798: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1799: p_data => x_msg_data,
1800: p_encoded => fnd_api.g_false);
1801: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1802: Rollback to Copy_Position_pvt;

Line 1804: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

1800: p_encoded => fnd_api.g_false);
1801: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1802: Rollback to Copy_Position_pvt;
1803: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1804: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1805: p_data => x_msg_data,
1806: p_encoded => fnd_api.g_false);
1807: WHEN OTHERS THEN
1808: Rollback to Copy_Position_pvt;

Line 1810: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,

1806: p_encoded => fnd_api.g_false);
1807: WHEN OTHERS THEN
1808: Rollback to Copy_Position_pvt;
1809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1810: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
1811: p_procedure_name => l_api_name,
1812: p_error_text => SQLERRM);
1813: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1814: p_data => x_msg_data,

Line 1813: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

1809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1810: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
1811: p_procedure_name => l_api_name,
1812: p_error_text => SQLERRM);
1813: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1814: p_data => x_msg_data,
1815: p_encoded => fnd_api.g_false);
1816: END Copy_Position;
1817:

Line 1904: FND_MSG_PUB.Initialize;

1900: END IF;
1901:
1902: -- Initialize message list if p_init_msg_list is set to TRUE
1903: IF FND_API.To_Boolean(p_init_msg_list) THEN
1904: FND_MSG_PUB.Initialize;
1905: END IF;
1906:
1907: --Check Status of MC allows for editing
1908: OPEN check_mc_status_csr(p_mc_header_id);

Line 1914: FND_MSG_PUB.ADD;

1910: IF (check_mc_status_csr%NOTFOUND) THEN
1911: FND_MESSAGE.Set_Name('AHL','AHL_MC_HEADER_ID_INVALID');
1912: FND_MESSAGE.Set_Token('NAME','');
1913: FND_MESSAGE.Set_Token('MC_HEADER_ID',p_mc_header_id);
1914: FND_MSG_PUB.ADD;
1915: CLOSE check_mc_status_csr;
1916: RAISE FND_API.G_EXC_ERROR;
1917: ELSIF ( l_status_code <> 'DRAFT' AND
1918: l_status_code <> 'APPROVAL_REJECTED') THEN

Line 1921: FND_MSG_PUB.ADD;

1917: ELSIF ( l_status_code <> 'DRAFT' AND
1918: l_status_code <> 'APPROVAL_REJECTED') THEN
1919: FND_MESSAGE.Set_Name('AHL','AHL_MC_EDIT_INV_MC');
1920: FND_MESSAGE.Set_Token('STATUS', l_status);
1921: FND_MSG_PUB.ADD;
1922: CLOSE check_mc_status_csr;
1923: RAISE FND_API.G_EXC_ERROR;
1924: END IF;
1925: CLOSE check_mc_status_csr;

Line 1989: FND_MSG_PUB.Count_And_Get

1985: IF FND_API.TO_BOOLEAN(p_commit) THEN
1986: COMMIT WORK;
1987: END IF;
1988: -- Standard call to get message count and if count is 1, get message info
1989: FND_MSG_PUB.Count_And_Get
1990: ( p_count => x_msg_count,
1991: p_data => x_msg_data,
1992: p_encoded => fnd_api.g_false
1993: );

Line 1998: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

1994: EXCEPTION
1995: WHEN FND_API.G_EXC_ERROR THEN
1996: Rollback to Delete_Positions_For_Mc_pvt;
1997: x_return_status := FND_API.G_RET_STS_ERROR;
1998: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1999: p_data => x_msg_data,
2000: p_encoded => fnd_api.g_false);
2001: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2002: Rollback to Delete_Positions_For_Mc_pvt;

Line 2004: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

2000: p_encoded => fnd_api.g_false);
2001: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2002: Rollback to Delete_Positions_For_Mc_pvt;
2003: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2004: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2005: p_data => x_msg_data,
2006: p_encoded => fnd_api.g_false);
2007: WHEN OTHERS THEN
2008: Rollback to Delete_Positions_For_Mc_pvt;

Line 2010: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,

2006: p_encoded => fnd_api.g_false);
2007: WHEN OTHERS THEN
2008: Rollback to Delete_Positions_For_Mc_pvt;
2009: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2010: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
2011: p_procedure_name => l_api_name,
2012: p_error_text => SQLERRM);
2013: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2014: p_data => x_msg_data,

Line 2013: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

2009: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2010: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
2011: p_procedure_name => l_api_name,
2012: p_error_text => SQLERRM);
2013: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2014: p_data => x_msg_data,
2015: p_encoded => fnd_api.g_false);
2016: END Delete_Positions_For_MC;
2017:

Line 2617: FND_MSG_PUB.Initialize;

2613: END IF;
2614:
2615: -- Initialize message list if p_init_msg_list is set to TRUE
2616: IF FND_API.To_Boolean(p_init_msg_list) THEN
2617: FND_MSG_PUB.Initialize;
2618: END IF;
2619:
2620: --Fetch the position informations for the instance
2621: OPEN get_last_uc_rec_csr(p_csi_item_instance_id);

Line 2696: x_msg_count := FND_MSG_PUB.count_msg;

2692: end if;
2693:
2694: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 21-Dec-2007
2695: -- There is no need to call the API Create_Position_ID, if there are pending validation errors.
2696: x_msg_count := FND_MSG_PUB.count_msg;
2697: IF x_msg_count > 0 THEN
2698: RAISE FND_API.G_EXC_ERROR;
2699: END IF;
2700:

Line 2727: FND_MSG_PUB.Count_And_Get

2723: COMMIT WORK;
2724: END IF;
2725:
2726: -- Standard call to get message count and if count is 1, get message info
2727: FND_MSG_PUB.Count_And_Get
2728: ( p_count => x_msg_count,
2729: p_data => x_msg_data,
2730: p_encoded => fnd_api.g_false
2731: );

Line 2736: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

2732: EXCEPTION
2733: WHEN FND_API.G_EXC_ERROR THEN
2734: Rollback to Map_Instance_To_Pos_ID_pvt;
2735: x_return_status := FND_API.G_RET_STS_ERROR;
2736: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2737: p_data => x_msg_data,
2738: p_encoded => fnd_api.g_false);
2739: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2740: Rollback to Map_Instance_To_Pos_ID_pvt;

Line 2742: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

2738: p_encoded => fnd_api.g_false);
2739: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2740: Rollback to Map_Instance_To_Pos_ID_pvt;
2741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2742: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2743: p_data => x_msg_data,
2744: p_encoded => fnd_api.g_false);
2745: WHEN OTHERS THEN
2746: Rollback to Map_Instance_To_Pos_ID_pvt;

Line 2748: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,

2744: p_encoded => fnd_api.g_false);
2745: WHEN OTHERS THEN
2746: Rollback to Map_Instance_To_Pos_ID_pvt;
2747: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2748: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
2749: p_procedure_name => l_api_name,
2750: p_error_text => SQLERRM);
2751: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2752: p_data => x_msg_data,

Line 2751: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

2747: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2748: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
2749: p_procedure_name => l_api_name,
2750: p_error_text => SQLERRM);
2751: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2752: p_data => x_msg_data,
2753: p_encoded => fnd_api.g_false);
2754:
2755: END Map_Instance_To_Pos_Id;