454: OR
455: (p_change_line_id IS NULL AND p_change_id IS NULL)
456: ) THEN
457: -- what are you planning to delete?
458: fnd_message.set_name('EGO', 'EGO_IPI_INSUFFICIENT_PARAMS');
459: fnd_message.set_token('PROG_NAME', G_PKG_NAME||'.'||l_api_name);
460: x_msg_data := fnd_message.get;
461: x_msg_count := 1;
462: code_debug(x_msg_data );
455: (p_change_line_id IS NULL AND p_change_id IS NULL)
456: ) THEN
457: -- what are you planning to delete?
458: fnd_message.set_name('EGO', 'EGO_IPI_INSUFFICIENT_PARAMS');
459: fnd_message.set_token('PROG_NAME', G_PKG_NAME||'.'||l_api_name);
460: x_msg_data := fnd_message.get;
461: x_msg_count := 1;
462: code_debug(x_msg_data );
463: RETURN;
456: ) THEN
457: -- what are you planning to delete?
458: fnd_message.set_name('EGO', 'EGO_IPI_INSUFFICIENT_PARAMS');
459: fnd_message.set_token('PROG_NAME', G_PKG_NAME||'.'||l_api_name);
460: x_msg_data := fnd_message.get;
461: x_msg_count := 1;
462: code_debug(x_msg_data );
463: RETURN;
464: END IF;
567: ,p_data => x_msg_data);
568: WHEN OTHERS THEN
569: code_debug( 'EXCEPTION others ');
570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
571: fnd_message.set_name('EGO', 'EGO_PLSQL_ERR');
572: fnd_message.set_token('PKG_NAME', G_PKG_NAME);
573: fnd_message.set_token('API_NAME', l_api_name);
574: fnd_message.set_token('SQL_ERR_MSG', SQLERRM);
575: x_msg_data := fnd_message.get;
568: WHEN OTHERS THEN
569: code_debug( 'EXCEPTION others ');
570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
571: fnd_message.set_name('EGO', 'EGO_PLSQL_ERR');
572: fnd_message.set_token('PKG_NAME', G_PKG_NAME);
573: fnd_message.set_token('API_NAME', l_api_name);
574: fnd_message.set_token('SQL_ERR_MSG', SQLERRM);
575: x_msg_data := fnd_message.get;
576: x_msg_count := 1;
569: code_debug( 'EXCEPTION others ');
570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
571: fnd_message.set_name('EGO', 'EGO_PLSQL_ERR');
572: fnd_message.set_token('PKG_NAME', G_PKG_NAME);
573: fnd_message.set_token('API_NAME', l_api_name);
574: fnd_message.set_token('SQL_ERR_MSG', SQLERRM);
575: x_msg_data := fnd_message.get;
576: x_msg_count := 1;
577: END Deleting_Obj_Pending_Changes;
570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
571: fnd_message.set_name('EGO', 'EGO_PLSQL_ERR');
572: fnd_message.set_token('PKG_NAME', G_PKG_NAME);
573: fnd_message.set_token('API_NAME', l_api_name);
574: fnd_message.set_token('SQL_ERR_MSG', SQLERRM);
575: x_msg_data := fnd_message.get;
576: x_msg_count := 1;
577: END Deleting_Obj_Pending_Changes;
578: ----------------------------------------------------------------------
571: fnd_message.set_name('EGO', 'EGO_PLSQL_ERR');
572: fnd_message.set_token('PKG_NAME', G_PKG_NAME);
573: fnd_message.set_token('API_NAME', l_api_name);
574: fnd_message.set_token('SQL_ERR_MSG', SQLERRM);
575: x_msg_data := fnd_message.get;
576: x_msg_count := 1;
577: END Deleting_Obj_Pending_Changes;
578: ----------------------------------------------------------------------
579: